Territory Comparison DatabaseBase comparateur de territoires

Name: Territory Comparison Database
Creator: INSEE
License: https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf

Base comparateur de territoiresTerritory Comparison Database

Published by INSEE

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This dataset provides around thirty indicators describing population, housing, income, employment and business establishments at the municipal (commune) level in France. It is published by INSEE, the French national statistics institute. Indicators are subject to statistical disclosure control to protect confidentiality, and most are drawn from official national sources. The dataset is intended to allow comparison of local territories across France using consistent, standardized socio-economic and demographic measures at municipal level.Ce jeu de données présente une trentaine d’indicateurs décrivant la population, les logements, les revenus, l’emploi et les établissements au niveau communal. Les indicateurs sont soumis au secret statistique pour garantir la confidentialité des données. La plupart des indicateurs proposés sont n...

employment

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (37 fields)

Filterable via the API (35)

codgeonom_officiel_commune_arrondissement_municipalp20_popp14_popsuperfnais1420dece1420p20_mennaisd22decesd22p20_logp20_rpp20_rsecoccp20_logvacp20_rp_propnbmenfisc20pimp20med20tp6020p20_empltp20_emplt_salp14_empltp20_pop1564p20_chom1564p20_act1564ettot21etaz21etbe21etfz21etgu21etgz21etoq21ettef121ettefp1021idf

Click a field to see example values.

Fill	Field	Type	Description
100%	codgeoINSEE commune code	text	Geographic code combining department and commune or municipal district number.Code du département suivi du numéro de commune ou du numéro d'arrondissement municipal
100%	nom_officiel_commune_arrondissement_municipalNOM_COMMUNE	text	Official name of the commune or municipal district.Nom de la commune ou de l'arrondissement
100%	p20_popP20 pop	int	Population in 2020.Population en 2020
100%	p14_popP14 pop	int	Population in 2014.Population en 2014
100%	superf	double	Area of the commune in square kilometers.Superficie (en km2)
100%	nais1420	int	Number of births between 01/01/2014 and 01/01/2020.Nombre de naissances entre le 01/01/2014 et le 01/01/2020
100%	dece1420	int	Number of deaths between 01/01/2014 and 01/01/2020.Nombre de décès entre le 01/01/2014 et le 01/01/2020
100%	p20_menP20 men	double	Number of households in 2020.Nombre de ménages en 2020
100%	naisd22	int	Number of births registered by residence in 2022.Nombre de naissances domiciliées en 2022
100%	decesd22	int	Number of deaths registered by residence in 2022.Nombre de décès domiciliés en 2022
100%	p20_logP20 log	double	Number of dwellings in 2020.Nombre de logements en 2020
100%	p20_rpP20 rp	double	Number of main residences in 2020.Nombre de résidences principales en 2020
100%	p20_rsecoccP20 rsecocc	double	Number of secondary and occasionally occupied residences in 2020.Nombre de résidences secondaires et logements occasionnels en 2020
100%	p20_logvacP20 logvac	double	Number of vacant dwellings in 2020.Nombre de logements vacants en 2020
100%	p20_rp_propP20 rp prop	double	Number of owner-occupied main residences in 2020.Nombre de résidences principales occupées par propriétaires en 2020
100%	nbmenfisc20	text	Number of tax households in 2020.Nombre de ménages fiscaux en 2020
100%	pimp20	text	Share of tax households subject to income tax in 2020.Part des ménages fiscaux imposés en 2020
100%	med20	text	Median standard of living in 2020.Médiane du niveau vie en 2020
100%	tp6020	text	Poverty rate in 2020.Taux de pauvreté en 2020
100%	p20_empltP20 emplt	double	Number of jobs at the place of work in 2020.Nombre d'emplois au lieu de travail en 2020
100%	p20_emplt_salP20 emplt sal	double	Number of salaried jobs at the place of work in 2020.Nombre d'emplois salariés au lieu de travail en 2020
100%	p14_empltP14 emplt	double	Number of jobs at the place of work in 2014.Nombre d'emplois au lieu de travail en 2014
100%	p20_pop1564P20 pop1564	double	Number of people aged 15 to 64 in 2020.Nombre de personnes de 15 à 64 ans en 2020
100%	p20_chom1564P20 chom1564	double	Number of unemployed people aged 15 to 64 in 2020.Nombre de chômeurs de 15 à 64 ans en 2020
100%	p20_act1564P20 act1564	double	Number of economically active people aged 15 to 64 in 2020.Nombre de personnes actives de 15 à 64 ans en 2020
100%	ettot21	int	Total number of active business establishments at end of 2021.Total des établissements actifs fin 2021
100%	etaz21	int	Active establishments in agriculture, forestry and fishing, end of 2021.Établissements actifs de l'agriculture, sylviculture et pêche fin 2021
100%	etbe21	int	Active establishments in industry, end of 2021.Établissements actifs de l'industrie fin 2021
100%	etfz21	int	Active establishments in construction, end of 2021.Établissements actifs de la construction fin 2021
100%	etgu21	int	Active establishments in trade, transport and miscellaneous services, end of 2021.Établissements actifs du commerce, transports et services divers fin 2021
—	etgz21	int	Of which active establishments in retail and automotive repair, end of 2021.dont Établissements actifs du commerce et réparation automobile fin 2021
—	etoq21	int	Active establishments in public administration, education, health and social work, end of 2021.Établissements actifs de l'administration publique, enseignement, santé et action sociale fin 2021
—	ettef121	int	Active establishments with 1 to 9 employees, end of 2021.Établissements actifs de 1 à 9 salariés fin 2021
—	ettefp1021	int	Active establishments with 10 or more employees, end of 2021. Établissements actifs de 10 salariés ou plus fin 2021
—	idf	text	Indicates whether the commune is located in the Île-de-France region.Commune francilienne ? Oui / Non
—	geo_pointGeo point	geo_point_2d	Geographic point coordinates (latitude, longitude) of the commune.Geographic point coordinates (latitude, longitude) of the commune.
—	geo_shapeShape	geo_shape	Geographic boundary shape of the commune.Geographic boundary shape of the commune.

Schema captured from opendatasoft 3 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1idf: Oui · med20: 18320

{
  "idf": "Oui",
  "med20": "18320",
  "codgeo": "91174",
  "etaz21": 1,
  "etbe21": 70,
  "etfz21": 231,
  "etgu21": 868,
  "etgz21": 330,
  "etoq21": 147,
  "p20_rp": 21007.7108159297,
  "pimp20": "47,0",
  "superf": 11.01,
  "tp6020": "26,0",
  "ettot21": 1317,
  "naisd22": 1000,
  "p14_pop": 49373,
  "p20_log": 23366.3507686436,
  "p20_men": 21007.7108159297,
  "p20_pop": 52340,
  "dece1420": 1659,
  "decesd22": 319,
  "ettef121": 937,
  "nais1420": 6788,
  "geo_point": {
    "lat": 48.60396384035847,
    "lon": 2.4694615426223754
  },
  "geo_shape": "[large value omitted]",
  "p14_emplt": 19463.5668466623,
  "p20_emplt": 20585.466047477,
  "ettefp1021": 233,
  "p20_logvac": 2203.19661892531,
  "nbmenfisc20": "20813",
  "p20_act1564": 24494.2864759668,
  "p20_pop1564": 34230.0820141578,
  "p20_rp_prop": 8215.66964181671,
  "p20_rsecocc": 155.44333378857,
  "p20_chom1564": 2853.66376002492,
  "p20_emplt_sal": 18901.9185281677,
  "nom_officiel_commune_arrondissement_municipal": "Corbeil-Essonnes"
}

Record 2idf: Oui · med20: 19770

{
  "idf": "Oui",
  "med20": "19770",
  "codgeo": "78335",
  "etaz21": 0,
  "etbe21": 28,
  "etfz21": 71,
  "etgu21": 202,
  "etgz21": 60,
  "etoq21": 40,
  "p20_rp": 6276.72877138281,
  "pimp20": "47,0",
  "superf": 11.48,
  "tp6020": "20,0",
  "ettot21": 341,
  "naisd22": 325,
  "p14_pop": 16144,
  "p20_log": 6979.08239893074,
  "p20_men": 6276.72877138281,
  "p20_pop": 17112,
  "dece1420": 560,
  "decesd22": 96,
  "ettef121": 225,
  "nais1420": 2050,
  "geo_point": {
    "lat": 48.99450225897926,
    "lon": 1.7400782541282143
  },
  "geo_shape": "[large value omitted]",
  "p14_emplt": 4924.87475718002,
  "p20_emplt": 5266.43941468971,
  "ettefp1021": 76,
  "p20_logvac": 635.433830466198,
  "nbmenfisc20": "6328",
  "p20_act1564": 7838.45086350841,
  "p20_pop1564": 10747.7610150614,
  "p20_rp_prop": 3087.62885519448,
  "p20_rsecocc": 66.9197970817349,
  "p20_chom1564": 1297.99897320653,
  "p20_emplt_sal": 4871.88484200448,
  "nom_officiel_commune_arrondissement_municipal": "Limay"
}

Record 3idf: Oui · med20: 27360

{
  "idf": "Oui",
  "med20": "27360",
  "codgeo": "91315",
  "etaz21": 1,
  "etbe21": 8,
  "etfz21": 21,
  "etgu21": 83,
  "etgz21": 29,
  "etoq21": 11,
  "p20_rp": 2580.78731470721,
  "pimp20": "72,0",
  "superf": 12.2,
  "tp6020": "5,0",
  "ettot21": 124,
  "naisd22": 54,
  "p14_pop": 6673,
  "p20_log": 2779.93286245438,
  "p20_men": 2580.78731470721,
  "p20_pop": 6638,
  "dece1420": 184,
  "decesd22": 33,
  "ettef121": 106,
  "nais1420": 414,
  "geo_point": {
    "lat": 48.51429970352232,
    "lon": 2.3435980445783673
  },
  "geo_shape": "[large value omitted]",
  "p14_emplt": 853.400773341723,
  "p20_emplt": 871.535982714437,
  "ettefp1021": 11,
  "p20_logvac": 169.222123474284,
  "nbmenfisc20": "2659",
  "p20_act1564": 3474.33199419786,
  "p20_pop1564": 4377.83403247343,
  "p20_rp_prop": 2222.55460199185,
  "p20_rsecocc": 29.9234242728917,
  "p20_chom1564": 261.502971652816,
  "p20_emplt_sal": 758.173149628602,
  "nom_officiel_commune_arrondissement_municipal": "Itteville"
}

Record 4idf: Oui · med20: 25940

{
  "idf": "Oui",
  "med20": "25940",
  "codgeo": "77344",
  "etaz21": 4,
  "etbe21": 3,
  "etfz21": 8,
  "etgu21": 13,
  "etgz21": 4,
  "etoq21": 6,
  "p20_rp": 798.577810201306,
  "pimp20": "68,0",
  "superf": 15.17,
  "tp6020": "s",
  "ettot21": 34,
  "naisd22": 29,
  "p14_pop": 2126,
  "p20_log": 833.869824504047,
  "p20_men": 798.577810201306,
  "p20_pop": 2448,
  "dece1420": 42,
  "decesd22": 12,
  "ettef121": 24,
  "nais1420": 170,
  "geo_point": {
    "lat": 49.07026520101356,
    "lon": 2.8172928983783203
  },
  "geo_shape": "[large value omitted]",
  "p14_emplt": 255.065504655379,
  "p20_emplt": 269.297608362886,
  "ettefp1021": 4,
  "p20_logvac": 32.2669845053635,
  "nbmenfisc20": "797",
  "p20_act1564": 1319.47733482765,
  "p20_pop1564": 1668.99546336296,
  "p20_rp_prop": 670.299416586144,
  "p20_rsecocc": 3.02502979737783,
  "p20_chom1564": 96.637670418214,
  "p20_emplt_sal": 223.659956651982,
  "nom_officiel_commune_arrondissement_municipal": "Oissery"
}

Record 5idf: Oui · med20: 26480

{
  "idf": "Oui",
  "med20": "26480",
  "codgeo": "95395",
  "etaz21": 1,
  "etbe21": 3,
  "etfz21": 7,
  "etgu21": 15,
  "etgz21": 4,
  "etoq21": 4,
  "p20_rp": 329.620209490978,
  "pimp20": "s",
  "superf": 6.64,
  "tp6020": "s",
  "ettot21": 30,
  "naisd22": 14,
  "p14_pop": 927,
  "p20_log": 354.031638062407,
  "p20_men": 329.620209490978,
  "p20_pop": 907,
  "dece1420": 29,
  "decesd22": 8,
  "ettef121": 24,
  "nais1420": 66,
  "geo_point": {
    "lat": 49.05374799186114,
    "lon": 2.391933909528696
  },
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            2.394129400614969,
            49.068911179168175
          ],
          [
            2.393492815803715,
            49.06857977135715
          ],
          [
            2.38568793003873,
            49.066183400200174
          ],
          [
            2.386432472703731,
            49.06837218979024
          ],
          [
            2.375480806297,
            49.06345394544083
          ],
          [
            2.373851821628192,
            49.06033161847509
          ],
          [
            2.37268323028035,
            49.057056105363976
          ],
          [
            2.372004593692541,
            49.05626577620622
          ],
          [
            2.369656970887751,
            49.05456301840821
          ],
          [
            2.375777723998616,
            49.04878264080293
          ],
          [
            2.37988072202446,
            49.04668450387217
          ],
          [
            2.379486702568676,
            49.04634617217434
          ],
          [
            2.378743625252631,
            49.0447714453377
          ],
          [
            2.378808646310357,
            49.04402455339643
          ],
          [
            2.377949573208977,
            49.04208954048941
          ],
          [
            2.378708221255886,
            49.04190103967866
          ],
          [
            2.380127657528639,
            49.04169976066028
          ],
          [
            2.383072631359753,
            49.04214923365223
          ],
          [
            2.382745043547554,
            49.04197670388534
          ],
          [
            2.394816507863105,
            49.04050950550932
          ],
          [
            2.394707175226889,
            49.03991548665135
          ],
          [
            2.394774051476852,
            49.03910654870461
          ],
          [
            2.394654638524776,
            49.03890812403071
          ],
          [
            2.397499431002442,
            49.03985489320762
          ],
          [
            2.399176693753048,
            49.0397005413202
          ],
          [
            2.399848323359887,
            49.041941990226384
          ],
          [
            2.401634853367155,
            49.045603413956215
          ],
          [
            2.402094392931671,
            49.04513452735813
          ],
          [
            2.403421456391756,
            49.044162807822886
          ],
          [
            2.416372506876457,
            49.04839686145011
          ],
          [
            2.417430827407566,
            49.04758643767834
          ],
          [
            2.418397917567877,
            49.04649141958027
          ],
          [
            2.419966209471709,
            49.04741077710831
          ],
          [
            2.414309164517505,
            49.051468321698145
          ],
          [
            2.411250159710601,
            49.053283204185114
          ],
          [
            2.413258430117692,
            49.05619468190377
          ],
          [
            2.413371455100521,
            49.05708901674849
          ],
          [
            2.408520186774171,
            49.057180326830405
          ],
          [
            2.407532511802561,
            49.05632753525877
          ],
          [
            2.407258523760122,
            49.05635855427452
          ],
          [
            2.401594320397217,
            49.06205193806843
          ],
          [
            2.399117577451321,
            49.063595148845764
          ],
          [
            2.400718957106198,
            49.06498247650432
          ],
          [
            2.394129400614969,
            49.068911179168175
          ]
        ]
      ]
    },
    "properties": {}
  },
  "p14_emplt": 124.501506535951,
  "p20_emplt": 104.85068097469,
  "ettefp1021": 2,
  "p20_logvac": 19.3257142857143,
  "nbmenfisc20": "329",
  "p20_act1564": 488.258856234863,
  "p20_pop1564": 602.374109105904,
  "p20_rp_prop": 289.80368718236,
  "p20_rsecocc": 5.0857142857143,
  "p20_chom1564": 45.3695509321992,
  "p20_emplt_sal": 87.7746721232714,
  "nom_officiel_commune_arrondissement_municipal": "Le Mesnil-Aubry"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://data.iledefrance.fr/api/explore/v2.1/catalog/datasets/base-comparateur-de-territoires

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.iledefrance.fr/api/explore/v2.1/catalog/datasets/base-comparateur-de-territoires/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

10 000 req/day

per ipmeasured

observed 3 days ago

Dataset

Volume & freshness

Records

1.3k

1287

Last upstream update

11 months ago

2025-12-05

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.