Last active
October 29, 2018 22:55
-
-
Save mcculley/f580382991a704a4070141f8cd6f4b3a 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
This file contains hidden or 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, COUNT(perpetrator_group_name) AS incident_count FROM gtd WHERE country_txt = 'United States' GROUP BY perpetrator_group_name ORDER BY incident_count DESC; | |
| perpetrator_group_name | incident_count | |
| --------------------------------------------------------------------------+---------------- | |
| Unknown | 573 | |
| Anti-Abortion extremists | 196 | |
| Left-Wing Militants | 169 | |
| Fuerzas Armadas de Liberacion Nacional (FALN) | 120 | |
| White extremists | 87 | |
| New World Liberation Front (NWLF) | 86 | |
| Black Nationalists | 83 | |
| Animal Liberation Front (ALF) | 76 | |
| Jewish Defense League (JDL) | 74 | |
| Student Radicals | 71 | |
| Earth Liberation Front (ELF) | 66 | |
| Omega-7 | 54 | |
| Weather Underground, Weathermen | 45 | |
| Macheteros | 37 | |
| Black Liberation Army | 36 | |
| Anti-Government extremists | 36 | |
| Chicano Liberation Front | 31 | |
| Jihadi-inspired extremists | 30 | |
| Armed Revolutionary Independence Movement (MIRA) | 30 | |
| United Freedom Front (UFF) | 29 | |
| Anti-Muslim extremists | 27 | |
| Puerto Rican Nationalists | 26 | |
| Ku Klux Klan | 26 | |
| Black Panthers | 24 | |
| Strikers | 23 | |
| Cuban Exiles | 21 | |
| Army of God | 21 | |
| Zebra killers | 20 | |
| May 19 Communist Order | 20 | |
| George Jackson Brigade | 20 | |
| Independent Armed Revolutionary Commandos (CRIA) | 19 | |
| Jewish Armed Resistance | 17 | |
| Aryan Republican Army | 16 | |
| Revolutionary Commandos of the People (CRP) | 15 | |
| Organization of Volunteers for the Puerto Rican Revolution | 15 | |
| Muslim extremists | 14 | |
| Anti-Technology extremists | 14 | |
| The Justice Department | 14 | |
| Armed Commandos of Liberation | 13 | |
| Croatian Nationalists | 12 | |
| National Front for the Liberation of Cuba (FLNC) | 12 | |
| Cuban Action | 12 | |
| Anti-Semitic extremists | 11 | |
| Neo-Nazi extremists | 10 | |
| Black September | 10 | |
| Chicano Radicals | 10 | |
| Luis Boitel Commandos | 9 | |
| Secret Cuban Government | 8 | |
| The Order (Silent Brotherhood) | 8 | |
| Jewish Extremists | 8 | |
| Up the IRS, Inc | 8 | |
| Justice Commandos for the Armenian Genocide | 8 | |
| Coalition to Save the Preserves (CSP) | 8 | |
| Symbionese Liberation Army (SLA) | 7 | |
| Anti-Police extremists | 7 | |
| Armenian Secret Army for the Liberation of Armenia | 7 | |
| Guerrilla Forces for Liberation | 7 | |
| Pedro Albizu Campos Revolutionary Forces | 7 | |
| American Indian Movement | 6 | |
| Anti-Government Group | 6 | |
| Anti-White extremists | 6 | |
| Aryan Nation | 6 | |
| Black Muslims | 6 | |
| World Church of the Creator | 6 | |
| Croatian Freedom Fighters | 5 | |
| Puerto Rican Revolutionary Movement | 5 | |
| Puerto Rican Armed Resistance | 5 | |
| Jamaat-al-Fuqra | 5 | |
| International Committee Against Nazism | 5 | |
| Americans for a Competent Federal Judicial System | 5 | |
| Revolutionary Force Seven | 5 | |
| Red Guerilla Family | 5 | |
| Environmentalists | 5 | |
| Evan Mecham Eco-Terrorist International Conspiracy (EMETIC) | 5 | |
| Fred Hampton Unit of the People's Forces | 5 | |
| Provisional Coordinating Committee for the Defense of Labor | 4 | |
| Popular Liberation Army (Puerto Rico) | 4 | |
| Phineas Priesthood | 4 | |
| Right-wing extremists | 4 | |
| Sovereign Citizen | 4 | |
| Anti-Environmentalists | 4 | |
| New Year's Gang | 4 | |
| Grupo Estrella | 4 | |
| New Jewish Defense League | 4 | |
| Latin America Anti-Communist Army (LAACA) | 4 | |
| Al-Qaida | 4 | |
| National Integration Front (FIN) | 4 | |
| Anti-LGBT extremists | 4 | |
| Black Afro Militant Movement | 4 | |
| Rajneeshees | 4 | |
| Covenant, Sword and the Arm of the Lord (CSA) | 4 | |
| Anti-Castro Group | 3 | |
| Black Hebrew Israelites | 3 | |
| Earth First! | 3 | |
| Front for the National Liberation of Puerto Rico | 3 | |
| Hanafi Muslims | 3 | |
| Incel extremists | 3 | |
| Armed Forces of Popular Resistance (FARP) | 3 | |
| Jewish Committee of Concern | 3 | |
| Anti-Gun Control extremists | 3 | |
| Otpor | 3 | |
| Puerto Rican Resistance Movement | 3 | |
| Revolutionary Action Party | 3 | |
| Revolutionary Force 9 | 3 | |
| Save Our Israel Land | 3 | |
| Animal Rights extremists | 3 | |
| Anarchists | 3 | |
| The Order II (Bruder Schweigen Strike Force II) | 3 | |
| Tontons Macoutes | 3 | |
| American Servicemen's Union (ASU) | 3 | |
| Vietnamese Organization to Exterminate Communists and Restore the Nation | 3 | |
| Black Revolutionary Assault Team | 3 | |
| Republic of New Afrika | 2 | |
| Students for a Democratic Society | 2 | |
| Veterans United for Non-Religious Memorials | 2 | |
| Environmental Life Force | 2 | |
| Pro-LGBT Rights extremists | 2 | |
| Revolutionary Cells-Animal Liberation Brigade | 2 | |
| Mujahedin-e Khalq (MEK) | 2 | |
| Palestinians | 2 | |
| Christian Liberation Army | 2 | |
| The Scorpion | 2 | |
| Revolutionary Force 26 | 2 | |
| Puerto Rican Liberation Front | 2 | |
| Coordination of the United Revolutionary Organization (CORU) | 2 | |
| Maccabee Squad and the Shield of David | 2 | |
| Continental Revolutionary Army | 2 | |
| Americans for Justice | 2 | |
| Vietnamese Refugees | 2 | |
| Black American Moslems | 2 | |
| Secret Army Organization | 2 | |
| Ninth of June Organization | 2 | |
| Secret Organization Zero | 2 | |
| Universal Proutist Revolutionary Federation | 2 | |
| Quartermoon Society | 2 | |
| Armenian Group | 2 | |
| Iranian extremists | 2 | |
| Sons of Liberty | 2 | |
| National Committee to Combat Fascism | 2 | |
| Irish Republican Army (IRA) | 2 | |
| Left-wing extremists | 2 | |
| Gay Liberation Front | 2 | |
| Farm Animal Revenge Militia (FARM) | 2 | |
| M-7 | 2 | |
| White Rabbit Three Percent Illinois Patriot Freedom Fighters Militia | 2 | |
| Palestine Liberation Organization (PLO) | 1 | |
| African-American extremists | 1 | |
| People's Brigade For A Healthy Genetic Future | 1 | |
| People's Liberation Army (United States) | 1 | |
| People's Revolutionary Party | 1 | |
| Cypriot | 1 | |
| Popular Front for the Liberation of Palestine (PFLP) | 1 | |
| Cuban extremists | 1 | |
| Posse Comitatus | 1 | |
| Cuban Secret Army | 1 | |
| BAY Bombers | 1 | |
| Cuban C-4 Movement | 1 | |
| Qaddafi loyalists | 1 | |
| ROSADO-SOTO Command | 1 | |
| Croatian Liberation Army | 1 | |
| Court Reform extremists | 1 | |
| Regulators | 1 | |
| Republic of Texas | 1 | |
| Revenge of the Trees | 1 | |
| Al-Qaida in the Arabian Peninsula (AQAP) | 1 | |
| Anti-Castro Command | 1 | |
| Revolutionary Communist Youth Brigade (RCYB) | 1 | |
| Welsh Extremists | 1 | |
| Revolutionary Labor Commandos | 1 | |
| White Panther Party | 1 | |
| Seattle Liberation Front | 1 | |
| Anti-Arab extremists | 1 | |
| Serbian Nationalists | 1 | |
| Sons of the Gestapo | 1 | |
| Condor | 1 | |
| Stop the War Coalition | 1 | |
| Anti Shah of Iran | 1 | |
| Students For Insurrection | 1 | |
| Supporters of Charles Manson | 1 | |
| Action Squad | 1 | |
| Tehrik-i-Taliban Pakistan (TTP) | 1 | |
| The Jewish Execution with Silence | 1 | |
| Citizens for Constitutional Freedom | 1 | |
| Comrades in Arms | 1 | |
| The World United Formosans for Independence (WUFI) | 1 | |
| Thunder of Zion | 1 | |
| Worldwide Organization of Native Taiwanese | 1 | |
| Tribal Thumb | 1 | |
| United Aryan Empire | 1 | |
| Youth of the Star | 1 | |
| United Jewish Underground | 1 | |
| Hatikvah Leumi or National Hope | 1 | |
| Hawaiian extremists | 1 | |
| Imperial Iranian Patriotic Organization | 1 | |
| Young Cuba | 1 | |
| Iranians | 1 | |
| Iraqi extremists | 1 | |
| Islamist extremists | 1 | |
| Armed Commandos of Student Self Defense | 1 | |
| Black Brigade (United States) | 1 | |
| Arabs | 1 | |
| Jewish Defenders | 1 | |
| Jewish Direct Action | 1 | |
| Antonia Martinez Student Commandos (AMSC) | 1 | |
| Gaddafi loyalists | 1 | |
| Jonathan Jackson Brigade | 1 | |
| Anti-Trump extremists | 1 | |
| Kahane Chai | 1 | |
| Anti-Sikh extremists | 1 | |
| Armenians | 1 | |
| Lebanese Man | 1 | |
| Anti-Republican extremists | 1 | |
| Libyan Students | 1 | |
| Lolita Lebron Puerto Rican Liberation Command | 1 | |
| Anti-Nuclear extremists | 1 | |
| Anti-Liberal extremists | 1 | |
| May 15 Organization for the Liberation of Palestine | 1 | |
| Fourth Reich Skinheads | 1 | |
| Medellin Drug Cartel | 1 | |
| Mexican Revolutionary Movement | 1 | |
| Minutemen American Defense | 1 | |
| Mormon Extremist | 1 | |
| Movement for Cuban Justice (Pragmatistas) | 1 | |
| Anti-Kim Jong-il extremists | 1 | |
| Anti-Israeli extremists | 1 | |
| National Socialist Liberation Front | 1 | |
| El Movimiento Revolucionario Independinista | 1 | |
| East Side Action Committee | 1 | |
| Nuclear Liberation Front | 1 | |
| Earth Night Action Group | 1 | |
| Organization 544 | 1 | |
| Organization Alliance of Cuban Intransigence | 1 | |
| Anti-Communist Viets Organization | 1 | |
| Boricua Revolutionary Front | 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment