| Source |
https://open.data4citizen.com/visualisation/information/?id=resultats_scolaires_et_valeur_ajoutee_des_colleges_et_lycees_d
|
| Last Updated |
May 27, 2026, 13:34 (UTC)
|
| Created |
May 22, 2026, 10:03 (UTC)
|
| FTP_API |
FTP |
| LinkedDataSet |
["indicateurs_de_valeur_ajoutee_des_lycees_d_enseignement_genera","indicateurs_de_valeur_ajoutee_des_colleges","liste_geolocalisee_des_etablissements_d_enseignement_des_premi_1","base_du_comparateur_de_territoires"] |
| 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 DISTINCT\r\n TRIM(UPPER(e.libelle_de_la_commune)) AS commune\r\n FROM \"fdd6b3cd-d459-41bf-86d8-5ea9b404ecf2\" e\r\n JOIN \"a69528ba-9dac-43fd-b974-c9c62aec2c41\" c\r\n ON TRIM(e.code_insee_de_la_commune) = TRIM(c.codgeo)\r\n WHERE c.epci = 200033579\r\n),\r\n\r\nivac_colleges AS (\r\n SELECT\r\n 'college' AS type_etablissement,\r\n session::integer AS annee,\r\n uai,\r\n nom_de_l_etablissement AS nom_etablissement,\r\n commune,\r\n NULL::text AS code_commune,\r\n code_departement,\r\n departement,\r\n academie,\r\n secteur,\r\n nb_candidats_g AS nb_candidats,\r\n taux_de_reussite_g AS taux_reussite,\r\n va_du_taux_de_reussite_g AS valeur_ajoutee_taux_reussite,\r\n taux_d_acces_6eme_3eme AS taux_acces,\r\n note_a_l_ecrit_g AS note_ecrit,\r\n va_de_la_note_g AS valeur_ajoutee_note,\r\n nb_mentions_global_g AS nb_mentions,\r\n 'IVAC coll\u00e8ges' AS source_indicateur\r\n FROM \"fb7d465f-0b2e-4253-a72a-6c3a7b60ffe0\"\r\n WHERE code_departement = '62'\r\n AND TRIM(UPPER(commune)) IN (\r\n SELECT commune FROM communes_cua\r\n )\r\n),\r\n\r\nival_lycees AS (\r\n SELECT\r\n 'lycee_gt' AS type_etablissement,\r\n annee::integer AS annee,\r\n uai,\r\n etablissement AS nom_etablissement,\r\n commune,\r\n code_commune,\r\n code_departement,\r\n departement,\r\n academie,\r\n secteur,\r\n \"presents_-_toutes_series\" AS nb_candidats,\r\n \"taux_de_reussite_-_toutes_series\" AS taux_reussite,\r\n \"valeur_ajoutee_du_taux_de_reussite_-_toutes_series\" AS valeur_ajoutee_taux_reussite,\r\n taux_d_acces_2nde_bac AS taux_acces,\r\n NULL::numeric AS note_ecrit,\r\n NULL::numeric AS valeur_ajoutee_note,\r\n NULL::numeric AS nb_mentions,\r\n 'IVAL lyc\u00e9es GT' AS source_indicateur\r\n FROM \"fbe31dd6-5295-45e6-b15f-ad753814d221\"\r\n WHERE code_departement = '62'\r\n AND TRIM(UPPER(commune)) IN (\r\n SELECT commune FROM communes_cua\r\n )\r\n)\r\n\r\nSELECT *\r\nFROM ivac_colleges\r\n\r\nUNION ALL\r\n\r\nSELECT *\r\nFROM ival_lycees\r\n\r\nORDER BY commune, type_etablissement, nom_etablissement, annee;"} |
| dataset_not_visible |
0 |
| dataset_size |
0.011340141296386719 |
| date_dataset |
2026-05-22 |
| date_deposit |
2026-05-22 |
| date_modification |
2026-05-22 |
| date_modification_data |
2026-05-22T10:03:27+00:00 |
| date_moissonnage_last_modification |
2026-05-22T10:03:30.759640 |
| 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 |
{"e5887e1f-29f3-44c5-a99a-f8aed305a118":"0000000088"} |
| show_cube_tab |
0 |
| themes |
["education_et_enseignement"] |
| tooltip |
{"resources":[{"type":"standard","resource_id":"e5887e1f-29f3-44c5-a99a-f8aed305a118","value":{"title":"","fields":"_id,type_etablissement,annee,uai,nom_etablissement,commune,code_commune,code_departement,departement,academie,secteur,nb_candidats,taux_reussite,valeur_ajoutee_taux_reussite,taux_acces,note_ecrit,valeur_ajoutee_note,nb_mentions,source_indicateur"}}]} |
| uploader |
user_d4c |
| weight |
0 |
| wfs_link |
|
| wms_link |
|