Crimes Committed In France

Monthly counts of crimes committed since 2000

@kaggle.government_of_france_crimes_in_france

Table List

1 table(253.37 KB)

Crime In France

Crime In France

@kaggle.government_of_france_crimes_in_france.crime_in_france

253.37 KB
107 rows
214 columns
Only the first 100 columns are shown

index Index	libell_index Libellé Index	n_2017_08 2017–08	n_2017_07 2017–07	n_2017_06 2017–06	n_2017_05 2017–05	n_2017_04 2017–04	n_2017_03 2017–03	n_2017_02 2017–02	n_2017_01 2017–01	n_2016_12 2016–12	n_2016_11 2016–11	n_2016_10 2016–10	n_2016_09 2016–09	n_2016_08 2016–08	n_2016_07 2016–07	n_2016_06 2016–06	n_2016_05 2016–05	n_2016_04 2016–04	n_2016_03 2016–03	n_2016_02 2016–02	n_2016_01 2016–01	n_2015_12 2015–12	n_2015_11 2015–11	n_2015_10 2015–10	n_2015_09 2015–09	n_2015_08 2015–08	n_2015_07 2015–07	n_2015_06 2015–06	n_2015_05 2015–05	n_2015_04 2015–04	n_2015_03 2015–03	n_2015_02 2015–02	n_2015_01 2015–01	n_2014_12 2014–12	n_2014_11 2014–11	n_2014_10 2014–10	n_2014_09 2014–09	n_2014_08 2014–08	n_2014_07 2014–07	n_2014_06 2014–06	n_2014_05 2014–05	n_2014_04 2014–04	n_2014_03 2014–03	n_2014_02 2014–02	n_2014_01 2014–01	n_2013_12 2013–12	n_2013_11 2013–11	n_2013_10 2013–10	n_2013_09 2013–09	n_2013_08 2013–08	n_2013_07 2013–07	n_2013_06 2013–06	n_2013_05 2013–05	n_2013_04 2013–04	n_2013_03 2013–03	n_2013_02 2013–02	n_2013_01 2013–01	n_2012_12 2012–12	n_2012_11 2012–11	n_2012_10 2012–10	n_2012_09 2012–09	n_2012_08 2012–08	n_2012_07 2012–07	n_2012_06 2012–06	n_2012_05 2012–05	n_2012_04 2012–04	n_2012_03 2012–03	n_2012_02 2012–02	n_2012_01 2012–01	n_2011_12 2011–12	n_2011_11 2011–11	n_2011_10 2011–10	n_2011_09 2011–09	n_2011_08 2011–08	n_2011_07 2011–07	n_2011_06 2011–06	n_2011_05 2011–05	n_2011_04 2011–04	n_2011_03 2011–03	n_2011_02 2011–02	n_2011_01 2011–01	n_2010_12 2010–12	n_2010_11 2010–11	n_2010_10 2010–10	n_2010_09 2010–09	n_2010_08 2010–08	n_2010_07 2010–07	n_2010_06 2010–06	n_2010_05 2010–05	n_2010_04 2010–04	n_2010_03 2010–03	n_2010_02 2010–02	n_2010_01 2010–01	n_2009_12 2009–12	n_2009_11 2009–11	n_2009_10 2009–10	n_2009_09 2009–09	n_2009_08 2009–08	n_2009_07 2009–07
1	Règlements de compte entre malfaireurs	8	9	8	8	2	14	15	10	8	9	4	11	4	3	6	5	8	10	10	11	3	6	9	5	5	2	8	8	4	2	2	2	4	5	6	4	3	10	9	3	10	4	3	9	2	7	3	6	5	5	6	5	4	9	3		3	7	6	13	4	7	2	13	4	6	5	3	6	6	5	2	5	5	6	4	9	4	6	2	4	6	6	6	5	2	2	3	3	5	6	2	3	5	1	11	4	3
2	Homicides pour voler et à l'occasion de vols	3	2	4	4	6	2	4	6	4	2	2	5	4	5	1	2	4	3	2	9	4	3	2	1	1	1	1	3	3	2	1	1	5		1	2	2	4		2	3	1	3	3	5		5		4	3	4	2	2	2	4	2	4	5	3	5	1	4	3	3	3		4		7	3	2	9	2	2	2	1	2	5	5	4	4	1	4	3	2	13	3	1	2	1	3	5	1		3	3	1	5
3	Homicides pour d'autres motifs	67	75	55	52	76	56	51	61	69	50	51	44	69	163	85	53	49	65	78	58	72	187	66	53	46	52	53	41	56	70	39	63	50	42	51	61	53	52	63	48	46	45	45	59	53	44	58	54	47	58	65	43	48	63	50	66	52	38	51	71	59	62	52	52	51	65	53	45	55	76	62	63	67	48	61	65	57	58	52	56	47	56	45	66	44	57	61	66	61	45	53	52	68	55	40	50	56	39
4	Tentatives d'homicides pour voler et à l'occasion de vols	6	5	6	12	4	13	5	24	13	7	7	9	3	11	11	16	5	15	1	13	6	4	9	7	5	5	6	6	7	19	3	22	6	3	16	6	6	6	12	8	3	8	1	9	14	4	15	9	8	14	8	4	4	8	13	4	5	8	3	7	9	2	6	10	2	7	8	4	3	8	2	9	5	6	5	5	3	1	6	2	9	6	8	2	7	4	4	9	1	5	6	4	3	8	7	5	4	6
5	Tentatives homicides pour d'autres motifs	218	238	224	200	208	228	168	165	189	202	220	214	214	271	167	186	148	185	176	159	192	177	175	197	174	143	175	153	177	180	153	157	141	139	125	136	159	153	149	126	105	111	116	124	114	116	135	113	117	152	111	133	103	93	77	127	134	140	154	123	127	138	115	126	106	101	95	116	113	118	94	137	101	93	107	109	113	92	101	81	94	99	67	104	89	101	125	120	77	103	82	83	81	80	76	101	86	87
6	Coups et blessures volontaires suivis de mort	21	10	9	14	10	12	10	15	17	14	16	17	11	14	15	21	9	13	11	12	18	17	15	11	8	10	9	10	9	7	14	12	10	6	16	6	20	12	9	10	18	17	10	19	16	12	7	11	3	7	8	12	7	11	6	9	8	12	14	13	9	15	9	14	16	11	12	7	5	17	15	8	11	11	13	12	10	7	10	11	17	10	9	10	9	16	10	11	11	5	15	13	9	12	14	22	22	12
7	Autres coups et blessures volontaires criminels ou correctionnels	18886	20846	22676	20414	18188	20745	17404	18749	17903	19047	19515	20986	18485	19539	20915	19745	18869	19566	17675	19014	19628	19123	20357	19859	18087	20080	20644	18434	18752	19341	16245	16601	17643	17030	18683	18232	15487	18622	18171	17264	18131	17716	16944	17715	17752	17118	18839	17317	16861	18974	17556	17028	16772	16814	15694	16805	17401	16973	18796	16738	16910	17629	18624	17627	17002	17324	15821	16566	16185	16534	17908	17421	15970	16145	18325	18753	17811	18441	16316	16541	17087	16917	17684	17227	15336	17678	19214	17259	17194	18733	15881	16100	16592	16412	17941	16738	15633	18593
8	Prises d'otages à l'occasion de vols	4	8	5	7	7	6	3	6	8	10	8	5	4	6	6	2	2	4	9	6	8	3	2	3	4	4	2	1	2	2	2	3	4	4	2	1	3	1	5	4	5	2	4	3	3	1	4	5		3	6	4	2	1	1	7		1	3	2		1	3	2	2	1	5	5	5	4	2	1	2	1	2	2		1	1	1	1	2		2	2	2		1	2	5	4		1	3	4	2	1
9	Prises d'otages dans un autre but	4	6	6	4	10	1	8	6	4	6	6	10	6	2	5	2	4	7	5	5		1	2	4	3	3	1	2	4	3	2	5	3	6	1	1	1	1	2	2	2	2	5	4	4	2	3		3	5	4		2		2	4		2	3	2	2	4	1	2	1	1	1	2	4		2	1		1		3		1	1	1		2			1	1	1	1	4	2	4	1	4	5	1	2	1	6
10	Sequestrations	294	327	381	344	288	379	295	322	328	355	340	368	296	344	350	341	330	400	332	355	342	378	386	384	332	373	340	410	302	303	293	250	284	279	293	254	220	240	296	240	235	203	202	199	232	195	181	189	139	173	183	189	195	204	185	216	213	202	172	155	170	179	192	198	177	160	168	175	219	219	184	208	184	189	206	195	168	173	176	180	205	196	175	170	155	174	193	153	187	196	164	180	173	162	194	155	167	178


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
);