French Cities

Different indicators of 100 french cities of the year 2005.

@kaggle.zakariakhodri3_french_cities_2005

Table List

1 table(56.69 KB)

French Cities 2005

@kaggle.zakariakhodri3_french_cities_2005.french_cities_2005

56.69 KB
100 rows
55 columns

ville Ville	chomage Chomage	chomagejeunes ChomageJeunes	chomagelong ChomageLong	evoluemploicree EvoluEmploiCree	activite Activite	emploifeminin EmploiFeminin	emploicommune EmploiCommune	defaillentreprise DefaillEntreprise	salaireannuel SalaireAnnuel	criminalite Criminalite	evolutioncrimes EvolutionCrimes	securiteroutiere SecuriteRoutiere	inondations Inondations	terrainspollues TerrainsPollues	usinesrisques UsinesRisques	mortaliteinfantile MortaliteInfantile	mortalitecancerpoumon MortaliteCancerPoumon	mortalitealcool MortaliteAlcool	decesinfarctus DecesInfarctus	tauxsuicide TauxSuicide	mortaliteglobale MortaliteGlobale	tailleclassesprimaires TailleClassesPrimaires	retard6eme Retard6eme	retard3eme Retard3eme	retardterminale RetardTerminale	metrecarreancien MetreCarreAncien	taxehabitation TaxeHabitation	foncierbati FoncierBati	metrecubeeau MetreCubeEau	proprietaires Proprietaires	logtsup4pieces LogtSup4pieces	logtinsalubre LogtInsalubre	logtvacant LogtVacant	logtconstruction LogtConstruction	mer Mer	ski Ski	soleil Soleil	pluie Pluie	temperature Temperature	marcheapied MarcheAPied	musees Musees	cinema Cinema	monumhistoriques MonumHistoriques	pretlivres PretLivres	restaurdistingues RestaurDistingues	presse Presse	etudiants Etudiants	impotrevenu ImpotRevenu	impotfortune ImpotFortune	imposables Imposables	evoldemographique EvolDemographique	vieillissement Vieillissement	attiranceglobale AttiranceGlobale	attiranceactifs AttiranceActifs
Agen	0.181	0.161	0.58	0.05	0.44	0.53	0.56	0.18	17210	105.7	-0.038	3.1	5	1		2.6	47.7	32.2	50.1	19.4	729.1	21.6	0.058	0.078	0.23	788	15.07	26.39	2.55	0.32	0.44	0.01	0.11	0.009	2	1	1984	111.5	12.6	0.17	1	3.1	9	3.7		28.6	0.06	1067	0.005	46	-0.013	0.56	0.38	0.47
AixEnProvence	0.166	0.133	0.55	0.1	0.43	0.47	0.57	0.13	22232	123.5	-0.014	2.2	5	1		4	33.6	23.3	52.4	17.2	703.9	24.9	0.021	0.072	0.202	1566	18.94	17.64	1.75	0.36	0.43	0.005	0.09	0.004	2	1	2836	60	13.6	0.11	5	4.2	64	4.4	1	19.9	0.31	2121	0.015	57	0.084	0.37	0.37	0.39
Ajaccio	0.166	0.181	0.52	0.02	0.43	0.46	0.77	0.14	17882	55.8	0.159	6.5	5	1	3	3.8	50.8	25.2	70.7	16.8	854	24.4	0.061	0.098	0.186	1220	22.72	15.02	2.23	0.44	0.49	0.006	0.09	0.014	3	2	2737	74.6	14.8	0.13	2	1.6	7	4.3	1	24.4	0.01	1207	0.004	47	-0.103	0.37	0.19	0.21
Albi	0.144	0.151	0.54	0.05	0.42	0.51	0.67	0.09	17923	68.7	0.084	1.8	6	4		0.8	43.2	26.2	67	23.3	756.5	22.1	0.043	0.119	0.167	804	13.41	25.21	1.96	0.49	0.6	0.006	0.08	0.008	1	1	2077	106	13.1	0.1	1	3	9	4.3		22.1	0.07	1245	0.004	51	-0.007	0.59	0.31	0.35
Amiens	0.2	0.165	0.61	0.05	0.44	0.46	0.64	0.17	18037	116.9	0.042	2.9	5	6	1	7	49.8	50	72.1	22	890.4	21.6	0.033	0.094	0.24	1058	17.97	27.76	1.93	0.35	0.49	0.033	0.07	0.001	2	1	1638	125.4	9.8	0.12	2	4	14	3.3		14.7	0.18	1208	0.006	47	0.028	0.24	0.26	0.28
Angers	0.157	0.164	0.56	0.02	0.43	0.51	0.6	0.11	17980	77.2	-0.052	4.4	9	3		6.6	43.3	40.3	56.4	23.6	739.4	23.2	0.038	0.083	0.176	1024	16.9	31.49	1.95	0.29	0.42	0.011	0.06	0.003	2	1	1944	107.7	11.5	0.09	7	4.3	41	6.4		16.3	0.18	1233	0.007	51	0.07	0.34	0.38	0.4
Angouleme	0.203	0.118	0.61	0.05	0.46	0.49	0.49	0.22	17794	71.3	-0.098	3.3	4	4	1	5	49.2	51.4	61.7	24.6	781.2	23.4	0.059	0.145	0.244	650	18.43	40.2	2.91	0.35	0.49	0.014	0.1	0.005	2	1	2025	118	12.5	0.12	4	4.5	2	4.6		28.8	0.04	1116	0.006	48	0.007	0.44	0.38	0.46
Annecy	0.134	0.123	0.44	0.03	0.48	0.51	0.47	0.11	18957	109	-0.007	5.8	3	5	1	5.6	39.2	41.2	52.9	26.9	750.3	24.2	0.03	0.059	0.139	1837	16.33	16.22	2.3	0.41	0.35	0.005	0.07	0.009	1	2	2027	110.4	9	0.17	1	3.9	5	12.1	2	26.8	0.04	1512	0.013	59	0.014	0.5	0.4	0.48
Antibes	0.153	0.198	0.49	0.05	0.43	0.47	0.53	0.15	19993	118.5	-0.191	9.2	16	2		2.6	39.7	27.1	71	15.4	671.1	24.6	0.03	0.095	0.219	2542	14.35	15.9	2.69	0.51	0.28	0.005	0.05	0.008	3	2	2694	63.1	15.6	0.1	2	1.9	5	4.1	1	23.3	0.01	1774	0.017	58	0.034	0.64	0.32	0.36
Arles	0.205	0.198	0.61	0.1	0.42	0.46	0.62	0.12	17737	77.3	-0.081	1.4	10	2		3.6	43.9	21.1	81.7	13.7	835.7	23.4	0.066	0.146	0.234	762	23.94	27.21	2.94	0.46	0.58	0.01	0.1	0.01	2	1	2836	56.9	14.4	0.11	4	1.8	40	3.6		17.4	0.01	995	0.005	44	-0.03	0.37	0.2	0.23


CREATE TABLE french_cities_2005 (
  "ville" VARCHAR,
  "chomage" DOUBLE,
  "chomagejeunes" DOUBLE,
  "chomagelong" DOUBLE,
  "evoluemploicree" DOUBLE,
  "activite" DOUBLE,
  "emploifeminin" DOUBLE,
  "emploicommune" DOUBLE,
  "defaillentreprise" DOUBLE,
  "salaireannuel" BIGINT,
  "criminalite" DOUBLE,
  "evolutioncrimes" DOUBLE,
  "securiteroutiere" DOUBLE,
  "inondations" BIGINT,
  "terrainspollues" BIGINT,
  "usinesrisques" BIGINT,
  "mortaliteinfantile" DOUBLE,
  "mortalitecancerpoumon" DOUBLE,
  "mortalitealcool" DOUBLE,
  "decesinfarctus" DOUBLE,
  "tauxsuicide" DOUBLE,
  "mortaliteglobale" DOUBLE,
  "tailleclassesprimaires" DOUBLE,
  "retard6eme" DOUBLE,
  "retard3eme" DOUBLE,
  "retardterminale" DOUBLE,
  "metrecarreancien" BIGINT,
  "taxehabitation" DOUBLE,
  "foncierbati" DOUBLE,
  "metrecubeeau" DOUBLE,
  "proprietaires" DOUBLE,
  "logtsup4pieces" DOUBLE,
  "logtinsalubre" DOUBLE,
  "logtvacant" DOUBLE,
  "logtconstruction" DOUBLE,
  "mer" BIGINT,
  "ski" BIGINT,
  "soleil" BIGINT,
  "pluie" DOUBLE,
  "temperature" DOUBLE,
  "marcheapied" DOUBLE,
  "musees" BIGINT,
  "cinema" DOUBLE,
  "monumhistoriques" BIGINT,
  "pretlivres" DOUBLE,
  "restaurdistingues" DOUBLE,
  "presse" DOUBLE,
  "etudiants" DOUBLE,
  "impotrevenu" BIGINT,
  "impotfortune" DOUBLE,
  "imposables" BIGINT,
  "evoldemographique" DOUBLE,
  "vieillissement" DOUBLE,
  "attiranceglobale" DOUBLE,
  "attiranceactifs" DOUBLE
);