Populations légales communales 2017-2021

Name: Populations légales communales 2017-2021
Creator: icem7

Descripción

Populations légales communales 2017-2021 au format parquet

Producer

icem7

Latest update

23 de enero de 2024

Licencia

License Not Specified

Metadata quality

55.55555555555556/100

Data description empty

Update frequency not set

Temporal coverage not set

1 Main file

Populations légales communales de 2017 à 2021

Updated on 23 de enero de 2024

parquet (1.2MB)

68 downloads

URL: https://static.data.gouv.fr/resources/populations-legales-communales-2017-2021/20240122-151058/poplegales2017-2021.parquet
Permalink: https://www.data.gouv.fr/es/datasets/r/4b2365c4-82b6-4e36-aa41-a11c8a302ff9
sha1: 96d1a8fce1f971a74e1677ceb5f1f01c4f08aba6
MIME Type: application/octet-stream

Created on: 28 de diciembre de 2023
Modified on: 23 de enero de 2024

Tamaño: 1.2MB

Source Insee.
Assemblage issu de cette requête :
CREATE OR replace TABLE insee_poplegid(annee VARCHAR(4),file_id VARCHAR) ;
INSERT INTO insee_poplegid
VALUES ('2021','7739582'),('2020','6683035'),('2019','6011070'),('2018','4989724'),('2017','4265429') ;

CREATE OR REPLACE MACRO get_file_id(an) AS
CASE WHEN an = 2021 THEN '7739582'
WHEN an = 2020 THEN '6683035'
WHEN an = 2019 THEN '6011070'
WHEN an = 2018 THEN '4989724'
WHEN an = 2017 THEN '4265429'
END ;

CREATE OR REPLACE MACRO get_filename_com(an) AS
CASE WHEN an >= 2019 THEN 'donnees_communes'
ELSE 'Communes' END ;

CREATE OR REPLACE MACRO get_poplegale_com(an) AS 'https://icem7.fr/data/proxy_unzip.php?clear_cache=0'
|| '&file=' || get_filename_com(an) || '.csv'
|| '&url=https://www.insee.fr/fr/statistiques/fichier/' || get_file_id(an) || '/ensemble.zip' ;

SELECT CASE WHEN DEPCOM IS NOT null THEN DEPCOM WHEN Commune IS NOT NULL THEN COM ELSE (SUBSTRING(CODDEP,1,2) || CODCOM) END AS CODGEO,
CASE WHEN CODGEO < '97' THEN SUBSTRING(CODGEO,1,2) ELSE SUBSTRING(CODGEO,1,3) END AS CODDEP,
CASE WHEN Commune IS NOT NULL THEN Commune ELSE COM end AS LIBGEO, PMUN, PTOT, PCAP, insee_poplegid.annee AS ANNEE_RP
FROM read_csv_auto(list_transform(generate_series(2017, 2021), n -> get_poplegale_com(n) ), filename = true, union_by_name = true) a
LEFT JOIN insee_poplegid ON split_part(a.filename, '/', -2) = insee_poplegid.file_id
ORDER BY CODGEO, ANNEE_RP

There are no reuses for this dataset yet.

Publish a reuse What's a reuse ?

There are no discussions for this dataset yet.

There are no community resources for this dataset yet.

Share your resources Learn more about the community

Information

Licencia

License Not Specified

ID

658d7b6224d22ec7fe76e564

Temporality

Creation

28 de diciembre de 2023

Frequency

Desconocido

Latest update

23 de enero de 2024

Cobertura espacial

Territorial coverage granularity

Ciudad francesa

Actions

Embed

<div data-udata-dataset="658d7b6224d22ec7fe76e564"></div><script data-udata="https://www.data.gouv.fr/" src="https://static.data.gouv.fr/static/oembed.js" async defer></script>

Statistics for the year

Download traffic metrics as CSV

Views

1,5k

98 in nov 2024

Downloads

1 in nov 2024

Populations légales communales 2017-2021

Descripción

Producer

Latest update

Licencia

Metadata quality:

Metadata quality

Information

Etiquetas

Licencia

ID

Temporality

Creation

Frequency

Latest update

Cobertura espacial

Territorial coverage granularity

Actions

Embed

Statistics for the year

Views

Downloads

Reuses of this dataset

Followers