Populations légales communales 2017-2021

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

Description

Populations légales communales 2017-2021 au format parquet

Producer

icem7

Latest update

January 23, 2024

License

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 January 23, 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/en/datasets/r/4b2365c4-82b6-4e36-aa41-a11c8a302ff9
sha1: 96d1a8fce1f971a74e1677ceb5f1f01c4f08aba6
MIME Type: application/octet-stream

Created on: December 28, 2023
Modified on: January 23, 2024

Size: 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

License

License Not Specified

ID

658d7b6224d22ec7fe76e564

Temporality

Creation

December 28, 2023

Frequency

Unknown

Latest update

January 23, 2024

Spatial coverage

Territorial coverage granularity

French town

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>

Populations légales communales 2017-2021

Description

Producer

Latest update

License

Metadata quality:

Metadata quality

Information

Tags

License

ID

Temporality

Creation

Frequency

Latest update

Spatial coverage

Territorial coverage granularity

Actions

Embed

Statistics for the year

Views

Downloads

Reuses of this dataset

Followers