Created
October 29, 2018 23:19
-
-
Save mcculley/e53b3cf346f1574f263fcde7c7457a39 to your computer and use it in GitHub Desktop.
simple SQL query of Global Terrorism Database (https://www.start.umd.edu/gtd/) by perpetrator group and total US killed
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT perpetrator_group_name, SUM(nkillus) AS total_killed FROM gtd WHERE country_txt = 'United States' AND nkillus > 0 GROUP BY perpetrator_group_name ORDER BY total_killed DESC; | |
| perpetrator_group_name | total_killed | |
| ---------------------------------------------------+-------------- | |
| Al-Qaida | 2907 | |
| Anti-Government extremists | 185 | |
| Jihadi-inspired extremists | 91 | |
| Unknown | 54 | |
| White extremists | 49 | |
| Black Nationalists | 23 | |
| Incel extremists | 17 | |
| Zebra killers | 15 | |
| Muslim extremists | 14 | |
| Anti-Police extremists | 12 | |
| Black Muslims | 12 | |
| Anti-White extremists | 10 | |
| Republic of New Afrika | 10 | |
| Black Liberation Army | 8 | |
| Ku Klux Klan | 7 | |
| Anti-Abortion extremists | 6 | |
| Left-Wing Militants | 5 | |
| Anti-Muslim extremists | 5 | |
| Armed Commandos of Liberation | 5 | |
| Jonathan Jackson Brigade | 4 | |
| Macheteros | 4 | |
| World Church of the Creator | 3 | |
| Anti-Semitic extremists | 3 | |
| Anti-Technology extremists | 3 | |
| Neo-Nazi extremists | 3 | |
| Black Panthers | 3 | |
| American Indian Movement | 2 | |
| Army of God | 2 | |
| Minutemen American Defense | 2 | |
| Otpor | 2 | |
| Posse Comitatus | 2 | |
| Tribal Thumb | 2 | |
| Anti-Liberal extremists | 2 | |
| Americans for a Competent Federal Judicial System | 2 | |
| The Order (Silent Brotherhood) | 1 | |
| Movement for Cuban Justice (Pragmatistas) | 1 | |
| Anti-Republican extremists | 1 | |
| Croatian Freedom Fighters | 1 | |
| Chicano Liberation Front | 1 | |
| Covenant, Sword and the Arm of the Lord (CSA) | 1 | |
| Anti-Nuclear extremists | 1 | |
| Sons of the Gestapo | 1 | |
| Sovereign Citizen | 1 | |
| Jamaat-al-Fuqra | 1 | |
| Symbionese Liberation Army (SLA) | 1 | |
| Iranians | 1 | |
| Black Afro Militant Movement | 1 | |
| Hawaiian extremists | 1 | |
| Gaddafi loyalists | 1 | |
| May 19 Communist Order | 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment