Apprenticeship - detailed enrolment figures 2011-2012Apprentissage - effectifs détaillés 2011-2012

Apprentissage - effectifs détaillés 2011-2012Apprenticeship - detailed enrolment figures 2011-2012

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset provides detailed data on apprentices for the 2011-2012 school year in the Île-de-France region, published via the region's open data portal. It covers apprentice profiles, including age, sex, nationality, department and city of residence, and parents' occupation and socio-professional category. It also describes the training followed, such as level, specialty, diploma and duration, as well as prior education and training location. The data is useful for analysing apprenticeship patterns and vocational training pathways among young people in the region during that period.Toutes les informations sur les apprentis de l'année scolaire 2011-2012 : profil des jeunes (âge, sexe, nationalité, département et ville, profession et catégorie socioprofessionnelle des parents),... formation suivie (niveau, spécialité et diplôme, durée) et précédente formation ; lieu de format...

education

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (50 fields)

Filterable via the API (50)

annee_scolairediplomelibelle_diplomecode_niveautype_diplomecode_groupe_specialitelibelle_specialitelibelle_specialite_comid_oglibelle_ogid_etabnom_complet_cfanumero_sectionduree_formation_moisannee_formationid_siteformationcode_uai_sitelibelle_lien_cfanom_site_formationadresse1_siteadresse2_siteadresse3_sitecode_commune_site_inseecode_postal_sitelibelle_ville_sitenum_sectionage_jeune_decembrehandicap_oui_non_videcode_sexesexecode_qualitelibelle_qualitecode_nationalitelibelle_nationalitecode_pcslibelle_pcs_parentcode_statut_jeunelibelle_statut_jeunecode_origine_prec_cfalibelle_origine_prec_cfacode_origine_annee_preclibelle_origine_annee_preccode_depart_jeune_inseecode_commune_jeune_inseecode_postal_jeunelibelle_ville_jeunecode_naf_entreprisedepart_entreprisecode_insee_entreprisecode_uai_etab_annee_prec

Click a field to see example values.

Fill	Field	Type	Description
100%	annee_scolaireAnnee scolaire	text	School year of the apprenticeship record (e.g. 11/12).School year of the apprenticeship record (e.g. 11/12).
89.4%	diplome	int	Code identifying the diploma or qualification pursued.Code identifying the diploma or qualification pursued.
100%	libelle_diplomeLibelle diplome	text	Full name of the diploma or qualification.Full name of the diploma or qualification.
100%	code_niveauCode niveau	int	Code for the qualification level of the diploma.Code for the qualification level of the diploma.
100%	type_diplomeType diplome	text	Type or category of the diploma.Type or category of the diploma.
100%	code_groupe_specialiteCode groupe specialite	int	Code for the specialty group of the training.Code for the specialty group of the training.
100%	libelle_specialiteLibelle specialite	text	Name of the training specialty.Name of the training specialty.
100%	libelle_specialite_comLibelle specialite com	text	Detailed or commentary label of the training specialty.Detailed or commentary label of the training specialty.
100%	id_ogId og	int	Identifier of the organizing body (training operator).Identifier of the organizing body (training operator).
100%	libelle_ogLibelle og	text	Name of the organizing body running the training.Name of the organizing body running the training.
100%	id_etabId etab	int	Identifier of the training establishment (CFA).Identifier of the training establishment (CFA).
100%	nom_complet_cfaNom complet cfa	text	Full name of the apprenticeship training center (CFA).Full name of the apprenticeship training center (CFA).
100%	numero_sectionNumero section	int	Number of the training section or class group.Number of the training section or class group.
100%	duree_formation_moisDuree formation mois	int	Duration of the training in months.Duration of the training in months.
100%	annee_formationAnnee formation	int	Year of the training course (e.g. year 1, 2).Year of the training course (e.g. year 1, 2).
100%	id_siteformationId siteformation	int	Identifier of the training site.Identifier of the training site.
100%	code_uai_siteCode uai site	text	National education institution code (UAI) of the training site.National education institution code (UAI) of the training site.
100%	libelle_lien_cfaLibelle lien cfa	text	Type of link between the training site and the CFA.Type of link between the training site and the CFA.
100%	nom_site_formationNom site formation	text	Name of the training site.Name of the training site.
100%	adresse1_siteAdresse1 site	text	First line of the training site's address.First line of the training site's address.
11.3%	adresse2_siteAdresse2 site	text	Second line of the training site's address.Second line of the training site's address.
0.5%	adresse3_siteAdresse3 site	text	Third line of the training site's address.Third line of the training site's address.
100%	code_commune_site_inseeCode commune site insee	int	INSEE code of the commune where the training site is located.INSEE code of the commune where the training site is located.
100%	code_postal_siteCode postal site	int	Postal code of the training site.Postal code of the training site.
100%	libelle_ville_siteLibelle ville site	text	Name of the city of the training site.Name of the city of the training site.
100%	num_sectionNum section	int	Number of the training section or class group.Number of the training section or class group.
100%	age_jeune_decembreAge jeune decembre	int	Age of the apprentice as of December of the school year.Age of the apprentice as of December of the school year.
24.4%	handicap_oui_non_videHandicap oui non vide	text	Indicates whether the apprentice has a declared disability.Indicates whether the apprentice has a declared disability.
100%	code_sexeCode sexe	text	Code for the apprentice's sex.Code for the apprentice's sex.
100%	sexe	text	Sex of the apprentice.Sex of the apprentice.
100%	code_qualiteCode qualite	text	Code indicating the apprentice's status (e.g. internal/external).Code indicating the apprentice's status (e.g. internal/external).
100%	libelle_qualiteLibelle qualite	text	Label describing the apprentice's status (e.g. internal/external).Label describing the apprentice's status (e.g. internal/external).
100%	code_nationaliteCode nationalite	int	Code for the apprentice's nationality.Code for the apprentice's nationality.
100%	libelle_nationaliteLibelle nationalite	text	Name of the apprentice's nationality.Name of the apprentice's nationality.
100%	code_pcsCode pcs	int	Socio-professional category code of the apprentice's parents.Socio-professional category code of the apprentice's parents.
100%	libelle_pcs_parentLibelle pcs parent	text	Label of the parents' socio-professional category.Label of the parents' socio-professional category.
100%	code_statut_jeuneCode statut jeune	text	Code for the apprentice's contractual status.Code for the apprentice's contractual status.
100%	libelle_statut_jeuneLibelle statut jeune	text	Label describing the apprentice's contractual status.Label describing the apprentice's contractual status.
100%	code_origine_prec_cfaCode origine prec cfa	int	Code for the apprentice's previous training situation before this CFA.Code for the apprentice's previous training situation before this CFA.
100%	libelle_origine_prec_cfaLibelle origine prec cfa	text	Label describing the apprentice's previous training situation before this CFA.Label describing the apprentice's previous training situation before this CFA.
100%	code_origine_annee_precCode origine annee prec	int	Code for the apprentice's situation in the previous academic year.Code for the apprentice's situation in the previous academic year.
100%	libelle_origine_annee_precLibelle origine annee prec	text	Label describing the apprentice's situation in the previous academic year.Label describing the apprentice's situation in the previous academic year.
100%	code_depart_jeune_inseeCode depart jeune insee	int	INSEE department code of the apprentice's residence.INSEE department code of the apprentice's residence.
100%	code_commune_jeune_inseeCode commune jeune insee	int	INSEE commune code of the apprentice's residence.INSEE commune code of the apprentice's residence.
100%	code_postal_jeuneCode postal jeune	int	Postal code of the apprentice's residence.Postal code of the apprentice's residence.
99.8%	libelle_ville_jeuneLibelle ville jeune	text	Name of the city where the apprentice resides.Name of the city where the apprentice resides.
98.9%	code_naf_entrepriseCode naf entreprise	text	NAF activity code of the apprentice's employing company.NAF activity code of the apprentice's employing company.
99.2%	depart_entrepriseDepart entreprise	int	Department number where the employing company is located.Department number where the employing company is located.
99.2%	code_insee_entrepriseCode insee entreprise	int	INSEE commune code of the employing company's location.INSEE commune code of the employing company's location.
100%	code_uai_etab_annee_precCode uai etab annee prec	text	UAI code of the establishment attended in the previous year.UAI code of the establishment attended in the previous year.

Schema captured from opendatasoft 3 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1sexe: Masculin · id_og: 39

{
  "sexe": "Masculin",
  "id_og": 39,
  "diplome": 63199999,
  "id_etab": 41,
  "code_pcs": 99,
  "code_sexe": "M",
  "libelle_og": "Association de Formation Coiffure",
  "code_niveau": 6,
  "num_section": 26,
  "code_qualite": "E",
  "type_diplome": "DIMA",
  "adresse1_site": "27 boulevard Ney",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0750739W",
  "annee_scolaire": "11/12",
  "numero_section": 26,
  "annee_formation": 1,
  "libelle_diplome": "DIMA - Dispositif d'Initiation aux Métiers en Alternance (DIMA)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA Soins Personnels Coiffure - Ambroise-Croisat",
  "code_nationalite": 1,
  "code_postal_site": 75018,
  "id_siteformation": 638,
  "libelle_lien_cfa": "Local du CFA",
  "code_postal_jeune": 75018,
  "code_statut_jeune": "DIMA",
  "depart_entreprise": null,
  "age_jeune_decembre": 15,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Dispositif d'initiation aux métiers en alternance",
  "libelle_ville_site": "PARIS",
  "nom_site_formation": "CFA de la Coiffure Ambroise Croisat",
  "code_naf_entreprise": null,
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "PARIS",
  "duree_formation_mois": 12,
  "libelle_statut_jeune": "Dispositif d'Initiation aux Métiers en Alternance",
  "code_insee_entreprise": null,
  "code_origine_prec_cfa": 15,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 999,
  "libelle_specialite_com": "Dispositif d'initiation aux métiers en alternance",
  "code_commune_site_insee": 75118,
  "code_depart_jeune_insee": 75,
  "code_origine_annee_prec": 15,
  "code_commune_jeune_insee": 75118,
  "code_uai_etab_annee_prec": "0752534X",
  "libelle_origine_prec_cfa": "4EME GENERALE (en collège)",
  "libelle_origine_annee_prec": "4EME GENERALE (en collège)"
}

Record 2sexe: Masculin · id_og: 141

{
  "sexe": "Masculin",
  "id_og": 141,
  "diplome": 13534110,
  "id_etab": 257,
  "code_pcs": 99,
  "code_sexe": "M",
  "libelle_og": "FORMASUP PARIS",
  "code_niveau": 1,
  "num_section": 178,
  "code_qualite": "E",
  "type_diplome": "MASTER PRO",
  "adresse1_site": "2 rue de la Liberté",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0931827F",
  "annee_scolaire": "11/12",
  "numero_section": 178,
  "annee_formation": 1,
  "libelle_diplome": "Sciences humaines et sociales : géopolitique spé géopolitique locale:aménagement et enjeux de territoires (MASTER Paris 8)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA FORMASUP Paris",
  "code_nationalite": 1,
  "code_postal_site": 93200,
  "id_siteformation": 2533,
  "libelle_lien_cfa": "UFA (L6232-8)",
  "code_postal_jeune": 94500,
  "code_statut_jeune": "A",
  "depart_entreprise": 93,
  "age_jeune_decembre": 23,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Aménagement du territoire, développement, urbanisme",
  "libelle_ville_site": "SAINT-DENIS",
  "nom_site_formation": "Université Paris VIII Vincennes Saint-Denis",
  "code_naf_entreprise": "8411Z",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "CHAMPIGNY-SUR-MARNE",
  "duree_formation_mois": 12,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 93008,
  "code_origine_prec_cfa": 69,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 341,
  "libelle_specialite_com": "Aménagement du territoire, développement, urbanisme",
  "code_commune_site_insee": 93066,
  "code_depart_jeune_insee": 94,
  "code_origine_annee_prec": 69,
  "code_commune_jeune_insee": 94017,
  "code_uai_etab_annee_prec": "75",
  "libelle_origine_prec_cfa": "AUTRE SCOLARITE SUPERIEURE",
  "libelle_origine_annee_prec": "AUTRE SCOLARITE SUPERIEURE"
}

Record 3sexe: Masculin · id_og: 218

{
  "sexe": "Masculin",
  "id_og": 218,
  "diplome": null,
  "id_etab": 371,
  "code_pcs": 99,
  "code_sexe": "M",
  "libelle_og": "Conservatoire National des Arts et Métiers - CNAM",
  "code_niveau": 2,
  "num_section": 3,
  "code_qualite": "E",
  "type_diplome": "DIP2-CNAM",
  "adresse1_site": "61 rue du Landy",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0932469D",
  "annee_scolaire": "11/12",
  "numero_section": 3,
  "annee_formation": 2,
  "libelle_diplome": "Responsable commercial en vente et en mercatique (CNAM)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA du Conservatoire National des Arts et Métiers - CNAM",
  "code_nationalite": 1,
  "code_postal_site": 93210,
  "id_siteformation": 1672,
  "libelle_lien_cfa": "Local du CFA",
  "code_postal_jeune": 95190,
  "code_statut_jeune": "A",
  "depart_entreprise": 95,
  "age_jeune_decembre": 22,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Commerce, vente",
  "libelle_ville_site": "LA PLAINE ST DENIS",
  "nom_site_formation": "CFA du Conservatoire National des Arts et Métiers - CNAM",
  "code_naf_entreprise": "6831Z",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "GOUSSAINVILLE",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 95280,
  "code_origine_prec_cfa": 61,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 312,
  "libelle_specialite_com": "Commerce, vente",
  "code_commune_site_insee": 93900,
  "code_depart_jeune_insee": 95,
  "code_origine_annee_prec": 61,
  "code_commune_jeune_insee": 95280,
  "code_uai_etab_annee_prec": "93",
  "libelle_origine_prec_cfa": "2EME ANNEE BTS (en lycée)",
  "libelle_origine_annee_prec": "2EME ANNEE BTS (en lycée)"
}

Record 4sexe: Féminin · id_og: 118

{
  "sexe": "Féminin",
  "id_og": 118,
  "diplome": 13532618,
  "id_etab": 157,
  "code_pcs": 99,
  "code_sexe": "F",
  "libelle_og": "Association pour le Développement de la Formation Supérieure par Alternance",
  "code_niveau": 1,
  "num_section": 63,
  "code_qualite": "E",
  "type_diplome": "MASTER PRO",
  "adresse1_site": "Bâtiment Copernic",
  "adresse2_site": "5 boulevard Descartes",
  "adresse3_site": null,
  "code_uai_site": "0772223Y",
  "annee_scolaire": "11/12",
  "numero_section": 63,
  "annee_formation": 1,
  "libelle_diplome": "Sciences Humaines et Sociales : Information et Communication Spé Cultures et Métiers du Web (MASTER Marne la Vallée)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA Descartes de Marne la Vallée",
  "code_nationalite": 1,
  "code_postal_site": 77420,
  "id_siteformation": 1938,
  "libelle_lien_cfa": "Convention L6231-3",
  "code_postal_jeune": 94270,
  "code_statut_jeune": "A",
  "depart_entreprise": 78,
  "age_jeune_decembre": 25,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Informatique, traitement de l'information, réseaux de transmission des données",
  "libelle_ville_site": "CHAMPS-SUR-MARNE",
  "nom_site_formation": "Université de Marne-la-Vallée",
  "code_naf_entreprise": "6202A",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "LE KREMLIN-BICETRE",
  "duree_formation_mois": 12,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 78686,
  "code_origine_prec_cfa": 107,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 326,
  "libelle_specialite_com": "Informatique, réseaux",
  "code_commune_site_insee": 77083,
  "code_depart_jeune_insee": 94,
  "code_origine_annee_prec": 107,
  "code_commune_jeune_insee": 94043,
  "code_uai_etab_annee_prec": "0772223Y",
  "libelle_origine_prec_cfa": "APPRENTISSAGE BAC+4 (STATUT APPRENTISSAGE)",
  "libelle_origine_annee_prec": "APPRENTISSAGE BAC+4 (STATUT APPRENTISSAGE)"
}

Record 5sexe: Féminin · id_og: 60

{
  "sexe": "Féminin",
  "id_og": 60,
  "diplome": 50033604,
  "id_etab": 83,
  "code_pcs": 99,
  "code_sexe": "F",
  "libelle_og": "Institut de Formation et de Perfectionnement aux Métiers",
  "code_niveau": 5,
  "num_section": 3,
  "code_qualite": "E",
  "type_diplome": "CAP",
  "adresse1_site": "4 boulevard du Levant",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0922275Y",
  "annee_scolaire": "11/12",
  "numero_section": 3,
  "annee_formation": 2,
  "libelle_diplome": "Esthétique cosmétique : soins esthétiques - conseils - vente (CAP)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA de l'Institut de Formation et de Perfectionnement aux Métiers",
  "code_nationalite": 1,
  "code_postal_site": 92000,
  "id_siteformation": 133,
  "libelle_lien_cfa": "Local du CFA",
  "code_postal_jeune": 78230,
  "code_statut_jeune": "A",
  "depart_entreprise": 78,
  "age_jeune_decembre": 18,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Coiffure, esthétique, et autres spécialités des services aux personnes",
  "libelle_ville_site": "NANTERRE",
  "nom_site_formation": "CFA IFPM",
  "code_naf_entreprise": "9602B",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "LE PECQ",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 78124,
  "code_origine_prec_cfa": 91,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 336,
  "libelle_specialite_com": "Coiffure, esthétique",
  "code_commune_site_insee": 92050,
  "code_depart_jeune_insee": 78,
  "code_origine_annee_prec": 73,
  "code_commune_jeune_insee": 78481,
  "code_uai_etab_annee_prec": "92",
  "libelle_origine_prec_cfa": "2EME ANNEE BAC PRO OU BT (STATUT APPRENTISSAGE)",
  "libelle_origine_annee_prec": "1ERE ANNEE CAP OU AUTRE DIPLOME DE NIVEAU V (STATUT APPRENTISSAGE)"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://data.iledefrance.fr/api/explore/v2.1/catalog/datasets/apprentissage_-_effectifs_detailles_2011-2012

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.iledefrance.fr/api/explore/v2.1/catalog/datasets/apprentissage_-_effectifs_detailles_2011-2012/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

10 000 req/day

per ipmeasured

observed 3 days ago

Dataset

Volume & freshness

Records

84k

84255

Update cadence

Annual

declared upstream

Last upstream update

7 years ago

2020-02-19

Temporal coverage

2011 → 2012

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.