Éducation – Diplômes et formation : comparaison territoriale autour de la Communauté urbaine d’Arras

Ce jeu de données extrait les indicateurs de diplômes et de formation de l’INSEE pour les territoires de comparaison utiles au tableau de bord Éducation : communes de la Communauté urbaine d’Arras, EPCI, département, région et France. Il permet d’analyser le niveau de diplôme, la scolarisation et la formation de la population selon les dimensions disponibles dans le flux INSEE Mélodi.

Jeux de données liés

  • Diplômes et formation – INSEE Mélodi DS_RP_DIPLOMES_PRINC
    Ressource : 3a0195f8-cfd1-4ee3-8ac0-eb0261b53e98
  • Base du comparateur de territoires
    Ressource : a69528ba-9dac-43fd-b974-c9c62aec2c41

Data and Resources

Additional Info

Field Value
Source https://open.data4citizen.com/visualisation/information/?id=diplomes_et_formation__comparaison_territoriale_autour_de_la_c
Last Updated May 22, 2026, 10:13 (UTC)
Created May 22, 2026, 10:05 (UTC)
FTP_API FTP
LinkedDataSet ["base_du_comparateur_de_territoires","diplomes_et_formation"]
Picto
allow_data_inputs 0
data4citizen-type sql
data_interop 0
data_rgpd false
dataset-model {"db_type":"pgsql","db_name":"datastore","host":"db","port":"5432","login":"ckan","password":"ckan","sql_query":"WITH communes_cua AS (\r\n SELECT codgeo\r\n FROM \"a69528ba-9dac-43fd-b974-c9c62aec2c41\"\r\n WHERE epci = 200033579\r\n)\r\n\r\nSELECT\r\n d.geo,\r\n d.geo_object,\r\n\r\n CASE\r\n WHEN d.geo_object ILIKE 'COM-%' OR d.geo ILIKE 'COM-%' THEN 'commune'\r\n WHEN d.geo_object ILIKE 'EPCI-%' OR d.geo ILIKE 'EPCI-%' THEN 'epci'\r\n WHEN d.geo_object ILIKE 'DEP-%' OR d.geo ILIKE 'DEP-%' THEN 'departement'\r\n WHEN d.geo_object ILIKE 'REG-%' OR d.geo ILIKE 'REG-%' THEN 'region'\r\n WHEN d.geo_object ILIKE '%FE%' OR d.geo ILIKE '%FE%' OR d.geo_object ILIKE '%FR%' OR d.geo ILIKE '%FR%' THEN 'france'\r\n ELSE 'autre'\r\n END AS niveau_geo,\r\n\r\n d.time_period::integer AS annee,\r\n d.sex,\r\n d.age,\r\n d.educ,\r\n d.stud_area,\r\n d.rp_measure,\r\n d.freq,\r\n d.obs_status,\r\n d.obs_value,\r\n 'INSEE M\u00e9lodi - DS_RP_DIPLOMES_PRINC' AS source\r\nFROM \"3a0195f8-cfd1-4ee3-8ac0-eb0261b53e98\" d\r\nWHERE\r\n d.geo_object ILIKE '%200033579%'\r\n OR d.geo ILIKE '%200033579%'\r\n OR d.geo_object ILIKE '%DEP-62%'\r\n OR d.geo ILIKE '%DEP-62%'\r\n OR d.geo_object ILIKE '%REG-32%'\r\n OR d.geo ILIKE '%REG-32%'\r\n OR d.geo_object IN ('FE-1', 'FRANCE')\r\n OR d.geo IN ('FE-1', 'FRANCE')\r\n OR REPLACE(REPLACE(d.geo_object, 'COM-', ''), 'COMMUNE-', '') IN (\r\n SELECT codgeo FROM communes_cua\r\n )\r\n OR REPLACE(REPLACE(d.geo, 'COM-', ''), 'COMMUNE-', '') IN (\r\n SELECT codgeo FROM communes_cua\r\n )\r\nORDER BY niveau_geo, geo_object, annee, sex, age, educ;"}
dataset_not_visible 0
dataset_size 0.28923988342285156
date_dataset 2026-05-22
date_deposit 2026-05-22
date_modification 2026-05-22
date_modification_data 2026-05-22T10:06:08+00:00
date_moissonnage_last_modification 2026-05-22T10:06:13.324163
default_visu 0
disable_export_type {"flat_formats":false,"geographic_formats":false,"alternative_formats":false,"data_analysis_formats":false,"metadata":false}
donnees_source
edition_security {"roles":["administrator"],"users":["*1*","*99*","*127*"]}
encoding UTF-8
features analyze,api,table,raw_data
map_color
nb_geo_features 0
nb_views 00000005
not_visible_in_chart_interface 0
not_visible_in_map_interface 0
producer
records_count {"12c6ee9f-aa32-4676-9f7e-cfd163ae5a8e":"0000003150"}
show_cube_tab 0
themes ["education_et_enseignement"]
uploader user_d4c
weight 0
wfs_link
wms_link