France Terror Attacks: eu_terrorism_fatalities_by_year.csv

Table actions

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 · About: simonw/fivethirtyeight-datasette

29 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: fatalities

Link rowid ▼ iyear fatalities
1 1 2014 5
2 2 2013 6
3 3 2012 10
4 4 2011 4
5 5 2010 4
6 6 2009 14
7 7 2008 3
8 8 2007 8
9 9 2006 6
10 10 2005 60
11 11 2004 196
12 12 2003 5
13 13 2002 9
14 14 2001 25
15 15 2000 42
16 16 1999 12
17 17 1998 53
18 18 1997 45
19 19 1996 40
20 20 1995 60
21 21 1994 103
22 22 1993 71
23 23 1992 170
24 24 1991 169
25 25 1990 118
26 26 1989 110
27 27 1988 430
28 28 1987 185
29 29 1986 153

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "terrorism/eu_terrorism_fatalities_by_year" (
"iyear" INTEGER,
  "fatalities" INTEGER
);