Dataset: French Cities

About this Dataset

French Cities

You can find more details about the code and how i scrapped the data in this repository https://github.com/zakariakhodrium/french_cities

The dataset covers a wide range of socio-economic, environmental (Nature), and health-related indicators of 100 cities in France from the year 2005. the variables/features are partitioned like this :

Economics : Chomage, ChomageJeunes, ChomageLong, EvoluEmploiCree, Activite, EmploiFeminin,
EmploiCommune, DefaillEntreprise, SalaireAnnuel, ImpotRevenu, ImpotFortune, Imposables,
MetreCarreAncien, TaxeHabitation, FoncierBati, MetreCubeEau, EvolDemographique, Vieillissement,
AttiranceGlobale, AttiranceActifs, Proprietaires, LogtSup4pieces, LogtInsalubre, LogtVacant,
LogtConstruction
Risk Factors : Criminalite, EvolutionCrimes, SecuriteRoutiere, Inondations, TerrainsPollues, UsinesRisques,
MortaliteInfantile, MortaliteCancerPoumon, MortaliteAlcool, DecesInfarctus, TauxSuicide,
MortaliteGlobale, TailleClassesPrimaires, Retard6eme, Retard3eme, RetardTerminale
Nature : Mer, Ski, Soleil, Pluie, Temperature, MarcheAPied
Culture : Musees, Cinema, MonumHistoriques, PretLivres, RestaurDistingues, Presse, Etudiants

Tables

French Cities 2005

@kaggle.zakariakhodri3_french_cities_2005.french_cities_2005

56.69 KB
100 rows
55 columns


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