Created
October 29, 2018 23:30
-
-
Save mcculley/b50b8037d56fee1e12cfa53399f498fe 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 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(nkill) AS total_killed FROM gtd WHERE country_txt = 'United States' AND nkill > 0 GROUP BY perpetrator_group_name ORDER BY total_killed DESC; | |
| perpetrator_group_name | total_killed | |
| --------------------------------------------------------------------------+-------------- | |
| Al-Qaida | 3001 | |
| Anti-Government extremists | 244 | |
| Jihadi-inspired extremists | 106 | |
| Unknown | 77 | |
| White extremists | 51 | |
| Black Nationalists | 24 | |
| Black Liberation Army | 19 | |
| Incel extremists | 17 | |
| Black Muslims | 17 | |
| Muslim extremists | 16 | |
| Zebra killers | 15 | |
| Anti-Police extremists | 12 | |
| Croatian Nationalists | 12 | |
| Republic of New Afrika | 10 | |
| Anti-White extremists | 10 | |
| Anti-Abortion extremists | 8 | |
| Fuerzas Armadas de Liberacion Nacional (FALN) | 7 | |
| Ku Klux Klan | 7 | |
| Macheteros | 6 | |
| Black Panthers | 6 | |
| Anti-Muslim extremists | 5 | |
| Armed Commandos of Liberation | 5 | |
| Anti-Technology extremists | 4 | |
| Omega-7 | 4 | |
| Jonathan Jackson Brigade | 4 | |
| Left-Wing Militants | 4 | |
| Jewish Defense League (JDL) | 4 | |
| Anti-Semitic extremists | 3 | |
| Neo-Nazi extremists | 3 | |
| Army of God | 3 | |
| World Church of the Creator | 3 | |
| Vietnamese Organization to Exterminate Communists and Restore the Nation | 3 | |
| Anti-Israeli extremists | 3 | |
| Minutemen American Defense | 2 | |
| Armenians | 2 | |
| Tribal Thumb | 2 | |
| Tontons Macoutes | 2 | |
| Symbionese Liberation Army (SLA) | 2 | |
| Anti-Liberal extremists | 2 | |
| Secret Organization Zero | 2 | |
| Revolutionary Commandos of the People (CRP) | 2 | |
| Americans for a Competent Federal Judicial System | 2 | |
| Chicano Liberation Front | 2 | |
| Posse Comitatus | 2 | |
| Otpor | 2 | |
| Justice Commandos for the Armenian Genocide | 2 | |
| American Indian Movement | 2 | |
| Movement for Cuban Justice (Pragmatistas) | 1 | |
| Anti-Communist Viets Organization | 1 | |
| Anti-Nuclear extremists | 1 | |
| Anti-Republican extremists | 1 | |
| Black Afro Militant Movement | 1 | |
| Black American Moslems | 1 | |
| Covenant, Sword and the Arm of the Lord (CSA) | 1 | |
| Croatian Freedom Fighters | 1 | |
| Gaddafi loyalists | 1 | |
| George Jackson Brigade | 1 | |
| Hanafi Muslims | 1 | |
| Hawaiian extremists | 1 | |
| Iranians | 1 | |
| Jamaat-al-Fuqra | 1 | |
| May 15 Organization for the Liberation of Palestine | 1 | |
| May 19 Communist Order | 1 | |
| Medellin Drug Cartel | 1 | |
| National Committee to Combat Fascism | 1 | |
| New World Liberation Front (NWLF) | 1 | |
| New Year's Gang | 1 | |
| Organization of Volunteers for the Puerto Rican Revolution | 1 | |
| Palestinians | 1 | |
| Popular Front for the Liberation of Palestine (PFLP) | 1 | |
| Puerto Rican Armed Resistance | 1 | |
| Qaddafi loyalists | 1 | |
| Sons of the Gestapo | 1 | |
| Sovereign Citizen | 1 | |
| The Order (Silent Brotherhood) | 1 | |
| Weather Underground, Weathermen | 1 | |
| Worldwide Organization of Native Taiwanese | 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment