home / fivethirtyeight

France Terror Attacks: country_stats_1993_appendix2.csv

This directory contains data, code and charts behind the story The Rise Of Religiously Inspired Terrorism In France.

The data source is the Global Terrorism Database (GTD). Raw data files from the GTD were retrieved on November 13, 2015; however, the raw data can not be made public. The data is freely available at the GTD website. Please see the GTD codebook -- the file GTD_Codebook_2015Final.pdf -- for more information.

Note: incident-level data for the year 1993 does not exist in the GTD database. However, in appendenix II of the codebook, GTD provides country-level summary statistics for that year; that data is included in the file country_stats_1993_appendix2.csv.

The FiveThirtyEight analysis is contained in the following files:

Header Notes
paris_terror_analysis.R An R script that loads the GTD raw data and performs analysis
france_fatalities.png Total fatalities from terrorism incidents in France, by year (from 1972 through 2014)
france_terrorism_fatalities_by_year.csv The raw data behind the chart above
eu_fatalities.png Total fatalities from terrorism incidents in the EU countries that joined in 1986 or earlier, from 1986 through 2014
eu_terrorism_fatalities_by_year.csv The raw data behind the chart above
eu_fatalities_by_country.png Total fatalities from terrorism incidents in the EU countries that joined in 1986 or earlier, for each country from 1972 through 2014
eu_terrorism_fatalities_by_country.csv The raw data behind the chart above
country_stats_1993_appendix2.csv This data is from Appendix II of the GTD codebook (found on pages 60-62); it includes country-level statistics on terrorism incidents in the year 1993.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

129 rows sorted by Number US Injured

View and edit SQL

Suggested facets: Number US Killed, Number US Injured

Link rowid Country Number of Incidents Percent Number Killed Number Injured Number US Killed Number US Injured ▼
128              
129              
2 Albania 2 0.04% 0 2 0 0
3 Algeria 311 6.28% 602 126 0 0
4 Angola 34 0.69% 373 111 0 0
5 Antigua and Barbuda 1 0.02% 0 0 0 0
6 Argentina 15 0.30% 2 1 0 0
7 Armenia 6 0.12% 5 17 0 0
8 Australia 2 0.04% 0 0 0 0
9 Austria 9 0.18% 0 5 0 0
10 Azerbaijan 4 0.08% 16 0 0 0
11 Bangladesh 47 0.95% 40 853 0 0
12 Belarus 1 0.02% 0 0 0 0
13 Belgium 4 0.08% 2 3 0 0
15 Bolivia 22 0.44% 2 1 0 0
16 Bosnia_Herzegovina 6 0.12% 7 8 0 0
17 Brazil 24 0.48% 97 29 10 0
18 Burundi 5 0.10% 106 0 0 0
20 Cameroon 4 0.08% 10 2 0 0
21 Canada 7 0.14% 0 0 0 0
22 Chad 13 0.26% 233 276 0 0
23 Chile 82 1.66% 13 31 0 0
24 China 21 0.42% 7 21 0 0
26 Comoros 2 0.04% 4 0 0 0
27 Congo (Brazzaville) 23 0.46% 106 5 0 0
28 Congo (Kinshasa) 12 0.24% 7 20 0 0
29 Corsica 67 1.35% 1 2 0 0
30 Costa Rica 3 0.06% 0 0 0 0
31 Croatia 4 0.08% 0 9 0 0
32 Cuba 5 0.10% 2 0 0 0
33 Cyprus 4 0.08% 0 16 0 0
34 Czech Republic 1 0.02% 0 0 0 0
35 Denmark 6 0.12% 0 36 0 0
36 Djibouti 2 0.04% 0 7 0 0
37 Dominican Republic 2 0.04% 1 0 0 0
38 Ecuador 11 0.22% 13 7 0 0
41 Estonia 5 0.10% 1 3 0 0
42 Ethiopia 2 0.04% 0 0 0 0
43 France 52 1.05% 5 9 0 0
44 Georgia 45 0.91% 194 96 1 0
46 Greece 30 0.61% 0 1 0 0
47 Guadeloupe 2 0.04% 0 0 0 0
49 Guinea 6 0.12% 12 50 0 0
50 Guinea_Bissau 1 0.02% 1 0 0 0
52 Honduras 5 0.10% 1 4 0 0
53 Hong Kong 4 0.08% 4 5 0 0
54 Hungary 3 0.06% 0 0 0 0
55 India 249 5.03% 1219 2546 0 0
56 Indonesia 3 0.06% 7 1 0 0
57 Iran 47 0.95% 78 41 0 0
58 Iraq 18 0.36% 33 59 0 0
59 Ireland 4 0.08% 1 1 0 0
60 Israel 240 4.84% 142 297 0 0
61 Italy 30 0.61% 14 126 0 0
63 Japan 45 0.91% 1 1 0 0
64 Jordan 1 0.02% 1 0 0 0
66 Kuwait 5 0.10% 1 0 0 0
67 Laos 1 0.02% 0 2 0 0
68 Latvia 1 0.02% 0 0 0 0
69 Lebanon 64 1.29% 51 174 0 0
71 Lithuania 3 0.06% 1 2 0 0
72 Malawi 1 0.02% 16 0 0 0
73 Malaysia 2 0.04% 0 0 0 0
74 Mali 8 0.16% 5 0 0 0
75 Mauritania 1 0.02% 0 2 0 0
77 Mozambique 8 0.16% 3 10 0 0
78 Myanmar (Burma) 20 0.40% 147 70 0 0
79 Nepal 2 0.04% 0 0 0 0
80 Netherlands 3 0.06% 0 0 0 0
81 Netherlands Antilles 2 0.04% 0 0 0 0
82 New Zealand 1 0.02% 0 0 0 0
84 Niger 7 0.14% 5 0 0 0
86 Northern Ireland 165 3.33% 73 175 0 0
87 Norway 7 0.14% 0 1 0 0
88 Pakistan 100 2.02% 228 302 0 0
90 Papua New Guinea 7 0.14% 43 13 0 0
91 Paraguay 3 0.06% 3 0 0 0
92 Peru 334 6.74% 316 307 0 0
95 Portugal 1 0.02% 0 0 0 0
96 Romania 1 0.02% 0 0 0 0
98 Rwanda 13 0.26% 81 155 0 0
99 Senegal 6 0.12% 121 0 0 0
100 Sierra Leone 4 0.08% 30 9 0 0
101 Singapore 1 0.02% 0 1 0 0
103 South Africa 426 8.60% 1009 631 1 0
104 South Korea 4 0.08% 0 1 0 0
105 Spain 50 1.01% 19 37 0 0
106 Sri Lanka 29 0.59% 1268 380 0 0
107 Sudan 2 0.04% 0 0 0 0
108 Suriname 4 0.08% 0 2 0 0
109 Swaziland 1 0.02% 0 1 0 0
110 Sweden 5 0.10% 0 1 0 0
111 Switzerland 12 0.24% 2 9 0 0
112 Taiwan 5 0.10% 34 57 0 0
113 Tajikistan 14 0.28% 373 19 0 0
115 Thailand 67 1.35% 34 97 0 0
116 Togo 13 0.26% 1 11 0 0
117 Trinidad and Tobago 2 0.04% 0 0 0 0
118 Turkey 386 7.79% 1166 403 0 0
119 Uganda 4 0.08% 2 1 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "terrorism/country_stats_1993_appendix2" (
"Country" TEXT,
  "Number of Incidents" INTEGER,
  "Percent" TEXT,
  "Number Killed" INTEGER,
  "Number Injured" INTEGER,
  "Number US Killed" INTEGER,
  "Number US Injured" INTEGER
)
Powered by Datasette · Query took 18.645ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub