{"access_audiences": [], "access_type": "open", "access_type_reason": null, "access_type_reason_category": null, "acronym": "Filosofi", "archived": null, "authorization_request_url": null, "badges": [], "contact_points": [], "created_at": "2024-10-02T11:06:12.584000+00:00", "deleted": null, "description": "L'Insee fournit des informations socio-\u00e9conomiques sur pr\u00e8s de 30 millions de m\u00e9nages. Il diffuse ces informations \u00e0 diff\u00e9rentes \u00e9chelles dont la plus petite est celle d\u2019un carreau de 200 m\u00e8tres de c\u00f4t\u00e9. Le fichier est en format parquet pour un requ\u00eatage avec duckdb par exemple. Le syst\u00e8me de projection est le 3035.", "description_short": null, "doi": null, "extras": {}, "featured": false, "frequency": "irregular", "frequency_date": "2023-10-12T04:00:00+00:00", "geopf": null, "harvest": null, "id": "66fd2924ca43b044d55a7b74", "internal": {"created_at_internal": "2024-10-02T11:06:12.584000+00:00", "last_modified_internal": "2026-03-10T08:59:29.899000+00:00"}, "last_modified": "2026-03-10T08:59:29.899000+00:00", "last_update": "2026-03-09T12:09:15.743000+00:00", "license": "lov2", "metrics": {"dataservices": 0, "discussions": 0, "discussions_open": 0, "followers": 0, "followers_by_months": {"2025-01": 0, "2025-02": 0, "2025-03": 0, "2025-04": 0, "2025-05": 0, "2025-06": 0, "2025-07": 0, "2025-08": 0, "2025-09": 0, "2025-10": 0, "2025-11": 0, "2025-12": 0, "2026-01": 0}, "resources_downloads": 2017, "reuses": 4, "reuses_by_months": {"2025-10": 0, "2025-11": 0, "2025-12": 0, "2026-01": 0, "2026-02": 0, "2026-03": 0, "2026-04": 0, "2026-05": 0, "2026-06": 1, "2026-07": 0, "2026-08": 1, "2026-09": 0, "2026-10": 1}, "views": 5796}, "organization": null, "owner": {"avatar": null, "avatar_thumbnail": null, "class": "User", "deleted": null, "first_name": "Fran\u00e7ois", "id": "66fd1e6804cb70304c6fc324", "last_name": "Semecurbe", "page": "https://www.data.gouv.fr/users/francois-semecurbe-1", "slug": "francois-semecurbe-1", "uri": "https://www.data.gouv.fr/api/1/users/francois-semecurbe-1/"}, "page": "https://www.data.gouv.fr/datasets/revenus-pauvrete-et-niveau-de-vie-donnees-carroyees-2019-et-2021-dispositif-fichier-localise-social-et-fiscal-filosofi", "permissions": {"delete": false, "edit": false, "edit_resources": false}, "private": false, "quality": {"all_resources_available": true, "dataset_description_quality": true, "has_open_format": true, "has_resources": true, "license": true, "resources_documentation": true, "score": 1.0, "spatial": true, "temporal_coverage": true, "update_frequency": true, "update_fulfilled_in_time": true}, "resources": [{"checksum": null, "created_at": "2026-03-09T12:00:56.512000+00:00", "description": null, "extras": {"analysis:check_id": 55081343, "analysis:error": "File too large to download", "analysis:last-modified-at": "2026-07-02T18:54:05+00:00", "analysis:last-modified-detection": "last-modified-header", "check:available": true, "check:cors:allow-credentials": "true", "check:cors:allow-headers": "Origin,Authorization,Accept,DNT,User-Agent,If-Modified-Since,Cache-Control,Content-Type,Range,sentry-trace,baggage", "check:cors:allow-methods": "GET, OPTIONS", "check:cors:allow-origin": "*", "check:cors:max-age": "1728000", "check:cors:status": 204, "check:date": "2026-03-09T12:09:18.395578+00:00", "check:headers:content-length": 94882677, "check:headers:content-type": "application/octet-stream", "check:id": 43240679, "check:status": 200, "check:timeout": false}, "filesize": 94882677, "filetype": "file", "format": "parquet", "geopf": null, "harvest": null, "id": "55432374-a91d-43d0-923d-4514dc3eb951", "internal": {"created_at_internal": "2026-03-09T12:00:56.512000+00:00", "last_modified_internal": "2026-03-09T12:09:15.743000+00:00"}, "last_modified": "2026-03-09T12:09:15.743000+00:00", "latest": "https://www.data.gouv.fr/api/1/datasets/r/55432374-a91d-43d0-923d-4514dc3eb951", "metrics": {"views": 1305}, "mime": "application/octet-stream", "preview_url": null, "schema": null, "title": "carreaux-200m-met-3035_2021.parquet", "type": "main", "url": "https://static.data.gouv.fr/resources/revenus-pauvrete-et-niveau-de-vie-donnees-carroyees-dispositif-fichier-localise-social-et-fiscal-filosofi/20260309-120901/carreaux-200m-met-3035-2021.parquet"}, {"checksum": {"type": "sha1", "value": "09a48efae5127de15b89b69f25d1ae5078f93cd8"}, "created_at": "2024-10-02T11:07:32.340000+00:00", "description": "La g\u00e9ometrie est en LAEA (epsg : 3035), la g\u00e9om\u00e9trie native des carreaux.\n\nExemple d'utilisation avec duckdb\n```\n-- installation des librairies spatiales\ninstall spatial;\nload spatial;\n\n-- Cr\u00e9ation d'une vue sur le fichier\nCREATE OR REPLACE VIEW filosofi AS from  read_parquet('https://www.data.gouv.fr/fr/datasets/r/b480cead-3f46-4b1b-a943-62a009b83f7a');\n\n-- D\u00e9finition d'une variable hubblo un disque de 1 km centr\u00e9 sur la Tour Eiffel\nset variable hubblo = st_buffer(ST_Point (3756295, 2889313),1000);\n\n-- Calcul simple de la population contenue dans le disque \nselect sum(ind) as ind\nfrom filosofi\nwhere ST_Intersects(filosofi.geometry, getvariable('hubblo'));\n\n-- Calcul avec interpolation spatiale de la population contenue dans le disque \n\nselect 'hubblo' as  unit, sum(ind*weight) as ind, \nfrom \n(SELECT *, st_area(st_intersection(geometry, getvariable('hubblo'))) / st_area(geometry) as weight \nfrom filosofi\nwhere ST_Intersects(geometry, getvariable('hubblo'))) ;\n```\n \n \n\nDictionnaire des variables :\n\n- idcar_200m : Identifiant Inspire du carreau de 200 m\n- idcar_1km : Identifiant Inspire du carreau de 1 km auquel appartient le carreau de 200 m\n- id_car_nat : Identifiant Inspire du carreau de niveau naturel auquel appartient le carreau de 200 m\n- i_est_200 : Vaut 1 si le carreau est imput\u00e9 par une valeur approch\u00e9e, 0 sinon.\n- i_est_1Km : Vaut 1 si le carreau de 1 km auquel est rattach\u00e9 le carreau de 200 m est imput\u00e9 par une valeur approch\u00e9e, 0 sinon.\n- lcog_geo : Code officiel g\u00e9ographique au 1er janvier 2020 de la ou des commune(s) dans laquelle (lesquelles) se trouve le carreau.\n- ind : Nombre d\u2019individus\n- men : Nombre de m\u00e9nages\n- men_pauv : Nombre de m\u00e9nages pauvres\n- men_1ind : Nombre de m\u00e9nages d\u2019un seul individu\n- men_5ind : Nombre de m\u00e9nages de 5 individus ou plus\n- men_prop : Nombre de m\u00e9nages propri\u00e9taires\n- men_fmp : Nombre de m\u00e9nages monoparentaux\n- ind_snv : Somme des niveaux de vie winsoris\u00e9s des individus\n- men_surf : Somme de la surface des logements du carreau\n- men_coll : Nombre de m\u00e9nages en logements collectifs\n- men_mais : Nombre de m\u00e9nages en maison\n- log_av45 : Nombre de logements construits avant 1945\n- log_45_70 : Nombre de logements construits entre 1945 et 1969\n- log_70_90 : Nombre de logements construits entre 1970 et 1989\n- log_ap90 : Nombre de logements construits depuis 1990\n- log_inc : Nombre de logements dont la date de construction est inconnue\n- log_soc : Nombre de logements sociaux\n- ind_0_3 : Nombre d\u2019individus de 0 \u00e0 3 ans\n- ind_4_5 : Nombre d\u2019individus de 4 \u00e0 5 ans\n- ind_6_10 : Nombre d\u2019individus de 6 \u00e0 10 ans\n- ind_11_17 : Nombre d\u2019individus de 11 \u00e0 17 ans\n- ind_18_24 : Nombre d\u2019individus de 18 \u00e0 24 ans\n- ind_25_39 : Nombre d\u2019individus de 25 \u00e0 39 ans\n- ind_40_54 : Nombre d\u2019individus de 40 \u00e0 54 ans\n- ind_55_64 : Nombre d\u2019individus de 55 \u00e0 64 ans\n- ind_65_79 : Nombre d\u2019individus de 65 \u00e0 79 ans\n- ind_80p : Nombre d\u2019individus de 80 ans ou plus\n- ind_inc : Nombre d\u2019individus dont l\u2019\u00e2ge est inconnu ", "extras": {"analysis:check_id": 54545210, "analysis:error": "File too large to download", "analysis:last-modified-at": "2026-07-02T18:54:09+00:00", "analysis:last-modified-detection": "last-modified-header", "check:available": true, "check:cors:allow-credentials": "true", "check:cors:allow-headers": "Origin,Authorization,Accept,DNT,User-Agent,If-Modified-Since,Cache-Control,Content-Type,Range,sentry-trace,baggage", "check:cors:allow-methods": "GET, OPTIONS", "check:cors:allow-origin": "*", "check:cors:max-age": "1728000", "check:cors:status": 204, "check:date": "2026-02-15T10:28:05.969000", "check:headers:content-length": 162243938, "check:headers:content-type": "application/octet-stream", "check:id": 41659915, "check:status": 200, "check:timeout": false}, "filesize": 162243938, "filetype": "file", "format": "parquet", "geopf": null, "harvest": null, "id": "b480cead-3f46-4b1b-a943-62a009b83f7a", "internal": {"created_at_internal": "2024-10-02T11:07:32.340000+00:00", "last_modified_internal": "2026-03-09T11:44:05.398000+00:00"}, "last_modified": "2026-03-09T11:44:05.398000+00:00", "latest": "https://www.data.gouv.fr/api/1/datasets/r/b480cead-3f46-4b1b-a943-62a009b83f7a", "metrics": {"views": 601}, "mime": "application/octet-stream", "preview_url": null, "schema": null, "title": "carreaux-200m-met-3035_2019.parquet", "type": "main", "url": "https://static.data.gouv.fr/resources/revenus-pauvrete-et-niveau-de-vie-en-2019-donnees-carroyees-dispositif-fichier-localise-social-et-fiscal-filosofi/20241002-110718/carreaux-200m-met-3035.parquet"}], "schema": null, "slug": "revenus-pauvrete-et-niveau-de-vie-donnees-carroyees-2019-et-2021-dispositif-fichier-localise-social-et-fiscal-filosofi", "spatial": {"geom": null, "granularity": "other", "zones": ["country-subset:fr:metro"]}, "tags": ["donnees-carroyees", "filosofi"], "temporal_coverage": {"end": "2021-01-01", "start": "2019-01-01"}, "title": "Revenus, pauvret\u00e9 et niveau de vie - Donn\u00e9es carroy\u00e9es  2019 et 2021 - Dispositif Fichier localis\u00e9 social et fiscal (Filosofi)", "uri": "https://www.data.gouv.fr/api/1/datasets/revenus-pauvrete-et-niveau-de-vie-donnees-carroyees-2019-et-2021-dispositif-fichier-localise-social-et-fiscal-filosofi/"}