Dataset: Crimes Committed In France

About this Dataset

Crimes Committed In France

Context

This dataset is an aggregated count of all crimes committed in France, broken down by month and category.

Content

This data was aggregated by the French national government and published online on the French Open Data Portal. It is a combination of records kept by both local and national police forces. It's important to note that the name of the categories of crime are in French!

Acknowledgements

This data is a part of a larger group of Excel files published by the French Goverment on the French Open Data Portal. It has been converted to a single CSV file before uploading here.

Inspiration

This is a simple time series dataset that can be probed for trends in the underlying types of crimes committed. Is petty theft more or less popular today than it was ten years ago? How much variation is there in the amount of robberies year-to-year? Can you normalize the growth in the number of crimes against the growth in the number of people? How do crimes committed here differ from those committed in, say, Los Angeles?

Tables

Crime In France

@kaggle.government_of_france_crimes_in_france.crime_in_france

253.37 KB
107 rows
214 columns


CREATE TABLE crime_in_france (
  "index" BIGINT,
  "libell_index" VARCHAR,
  "n_2017_08" BIGINT,
  "n_2017_07" BIGINT,
  "n_2017_06" BIGINT,
  "n_2017_05" BIGINT,
  "n_2017_04" BIGINT,
  "n_2017_03" BIGINT,
  "n_2017_02" BIGINT,
  "n_2017_01" BIGINT,
  "n_2016_12" BIGINT,
  "n_2016_11" BIGINT,
  "n_2016_10" BIGINT,
  "n_2016_09" BIGINT,
  "n_2016_08" BIGINT,
  "n_2016_07" BIGINT,
  "n_2016_06" BIGINT,
  "n_2016_05" BIGINT,
  "n_2016_04" BIGINT,
  "n_2016_03" BIGINT,
  "n_2016_02" BIGINT,
  "n_2016_01" BIGINT,
  "n_2015_12" BIGINT,
  "n_2015_11" BIGINT,
  "n_2015_10" BIGINT,
  "n_2015_09" BIGINT,
  "n_2015_08" BIGINT,
  "n_2015_07" BIGINT,
  "n_2015_06" BIGINT,
  "n_2015_05" BIGINT,
  "n_2015_04" BIGINT,
  "n_2015_03" BIGINT,
  "n_2015_02" BIGINT,
  "n_2015_01" BIGINT,
  "n_2014_12" BIGINT,
  "n_2014_11" BIGINT,
  "n_2014_10" BIGINT,
  "n_2014_09" BIGINT,
  "n_2014_08" BIGINT,
  "n_2014_07" BIGINT,
  "n_2014_06" BIGINT,
  "n_2014_05" BIGINT,
  "n_2014_04" BIGINT,
  "n_2014_03" BIGINT,
  "n_2014_02" BIGINT,
  "n_2014_01" BIGINT,
  "n_2013_12" BIGINT,
  "n_2013_11" BIGINT,
  "n_2013_10" BIGINT,
  "n_2013_09" BIGINT,
  "n_2013_08" BIGINT,
  "n_2013_07" BIGINT,
  "n_2013_06" BIGINT,
  "n_2013_05" BIGINT,
  "n_2013_04" BIGINT,
  "n_2013_03" BIGINT,
  "n_2013_02" BIGINT,
  "n_2013_01" BIGINT,
  "n_2012_12" BIGINT,
  "n_2012_11" BIGINT,
  "n_2012_10" BIGINT,
  "n_2012_09" BIGINT,
  "n_2012_08" BIGINT,
  "n_2012_07" BIGINT,
  "n_2012_06" BIGINT,
  "n_2012_05" BIGINT,
  "n_2012_04" BIGINT,
  "n_2012_03" BIGINT,
  "n_2012_02" BIGINT,
  "n_2012_01" BIGINT,
  "n_2011_12" BIGINT,
  "n_2011_11" BIGINT,
  "n_2011_10" BIGINT,
  "n_2011_09" BIGINT,
  "n_2011_08" BIGINT,
  "n_2011_07" BIGINT,
  "n_2011_06" BIGINT,
  "n_2011_05" BIGINT,
  "n_2011_04" BIGINT,
  "n_2011_03" BIGINT,
  "n_2011_02" BIGINT,
  "n_2011_01" BIGINT,
  "n_2010_12" BIGINT,
  "n_2010_11" BIGINT,
  "n_2010_10" BIGINT,
  "n_2010_09" BIGINT,
  "n_2010_08" BIGINT,
  "n_2010_07" BIGINT,
  "n_2010_06" BIGINT,
  "n_2010_05" BIGINT,
  "n_2010_04" BIGINT,
  "n_2010_03" BIGINT,
  "n_2010_02" BIGINT,
  "n_2010_01" BIGINT,
  "n_2009_12" BIGINT,
  "n_2009_11" BIGINT,
  "n_2009_10" BIGINT,
  "n_2009_09" BIGINT,
  "n_2009_08" BIGINT,
  "n_2009_07" BIGINT
);