Apprenticeship - detailed enrolment figures 2009-2010Apprentissage - effectifs détaillés 2009-2010

Apprentissage - effectifs détaillés 2009-2010Apprenticeship - detailed enrolment figures 2009-2010

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset provides detailed information on apprentices enrolled during the 2009-2010 school year in the Île-de-France region of France. It covers the profile of the young people concerned, including age, sex, nationality, department and city of residence, and the profession and socio-professional category of their parents. It also details the training followed, such as level, specialty, diploma sought and duration, as well as any previous training undertaken and the location where training took place. The data is published on the Île-de-France open data portal.Toutes les informations sur les apprentis de l'année scolaire 2009-2010 : 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.School year of the apprenticeship record.
100%	diplome	text	Code identifying the diploma or qualification.Code identifying the diploma or qualification.
100%	libelle_diplomeLibelle diplome	text	Name of the diploma or qualification.Name of the diploma or qualification.
100%	code_niveauCode niveau	int	Numeric code for the qualification level.Numeric code for the qualification level.
100%	type_diplomeType diplome	text	Type or category of diploma (e.g. BAC PRO, LICENCE PRO).Type or category of diploma (e.g. BAC PRO, LICENCE PRO).
100%	code_groupe_specialiteCode groupe specialite	int	Code identifying the specialty group of the training.Code identifying the specialty group of the training.
100%	libelle_specialiteLibelle specialite	text	Name of the training specialty field.Name of the training specialty field.
100%	libelle_specialite_comLibelle specialite com	text	Additional label or comment for the training specialty.Additional label or comment for the training specialty.
100%	id_ogId og	int	Identifier of the organizing body (training organization).Identifier of the organizing body (training organization).
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.Identifier of the training establishment.
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 identifying the training section/class.Number identifying the training section/class.
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 program (e.g. 1st, 2nd year).Year of the training program (e.g. 1st, 2nd year).
100%	id_siteformationId siteformation	text	Identifier of the training site.Identifier of the training site.
100%	code_uai_siteCode uai site	text	UAI code identifying the training site institution.UAI code identifying the training site institution.
100%	libelle_lien_cfaLibelle lien cfa	text	Description of the site's relationship to the main CFA.Description of the site's relationship to the main 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.
8.6%	adresse2_siteAdresse2 site	text	Second line of the training site's address.Second line of the training site's address.
0.4%	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 training site's municipality.INSEE code of the training site's municipality.
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 where the training site is located.Name of the city where the training site is located.
100%	num_sectionNum section	int	Number identifying the training section/class.Number identifying the training section/class.
100%	age_jeune_decembreAge jeune decembre	int	Age of the apprentice in December of the school year.Age of the apprentice in December of the school year.
25.1%	handicap_oui_non_videHandicap oui non vide	text	Indicates whether the apprentice has a disability.Indicates whether the apprentice has a disability.
100%	code_sexeCode sexe	text	Code for the apprentice's gender (M/F).Code for the apprentice's gender (M/F).
100%	sexe	text	Gender of the apprentice.Gender of the apprentice.
100%	code_qualiteCode qualite	text	Code for the apprentice's boarding/meal status.Code for the apprentice's boarding/meal status.
100%	libelle_qualiteLibelle qualite	text	Label describing the apprentice's boarding/meal status.Label describing the apprentice's boarding/meal status.
100%	code_nationaliteCode nationalite	int	Code for the apprentice's nationality group.Code for the apprentice's nationality group.
100%	libelle_nationaliteLibelle nationalite	text	Label describing the apprentice's nationality group.Label describing the apprentice's nationality group.
100%	code_pcsCode pcs	int	Socio-professional category code of the apprentice's parent.Socio-professional category code of the apprentice's parent.
100%	libelle_pcs_parentLibelle pcs parent	text	Label of the parent's socio-professional category.Label of the parent's 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 institution origin.Code for the apprentice's previous training institution origin.
100%	libelle_origine_prec_cfaLibelle origine prec cfa	text	Label describing the apprentice's previous training institution origin.Label describing the apprentice's previous training institution origin.
100%	code_origine_annee_precCode origine annee prec	int	Code for the apprentice's previous school year situation.Code for the apprentice's previous school year situation.
100%	libelle_origine_annee_precLibelle origine annee prec	text	Label describing the apprentice's previous school year situation.Label describing the apprentice's previous school year situation.
100%	code_depart_jeune_inseeCode depart jeune insee	int	INSEE code of the apprentice's home department.INSEE code of the apprentice's home department.
100%	code_commune_jeune_inseeCode commune jeune insee	int	INSEE code of the apprentice's home municipality.INSEE code of the apprentice's home municipality.
100%	code_postal_jeuneCode postal jeune	int	Postal code of the apprentice's residence.Postal code of the apprentice's residence.
99.6%	libelle_ville_jeuneLibelle ville jeune	text	Name of the city where the apprentice resides.Name of the city where the apprentice resides.
98.4%	code_naf_entrepriseCode naf entreprise	text	NAF code identifying the employer's business sector.NAF code identifying the employer's business sector.
98.6%	depart_entrepriseDepart entreprise	int	Department number of the employer's location.Department number of the employer's location.
98.6%	code_insee_entrepriseCode insee entreprise	int	INSEE code of the employer's municipality.INSEE code of the employer's municipality.
100%	code_uai_etab_annee_precCode uai etab annee prec	text	UAI code of the previous year's training institution.UAI code of the previous year's training institution.

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

{
  "sexe": "Masculin",
  "id_og": 99,
  "diplome": "40031202",
  "id_etab": 138,
  "code_pcs": 43,
  "code_sexe": "M",
  "libelle_og": "Association de Formation Interprofessionnelle de Poissy et Environs",
  "code_niveau": 4,
  "num_section": 27,
  "code_qualite": "D",
  "type_diplome": "BAC PRO",
  "adresse1_site": "20 quai Pierre Brunel",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0783288A",
  "annee_scolaire": "09/10",
  "numero_section": 27,
  "annee_formation": 1,
  "libelle_diplome": "Commerce (BAC PRO)",
  "libelle_qualite": "Demi-pensionnaire",
  "nom_complet_cfa": "CFA Vente et Commerce - AFIPE",
  "code_nationalite": 2,
  "code_postal_site": 78500,
  "id_siteformation": "1671",
  "libelle_lien_cfa": "Annexe du CFA",
  "code_postal_jeune": 78500,
  "code_statut_jeune": "A",
  "depart_entreprise": 78,
  "age_jeune_decembre": 18,
  "libelle_pcs_parent": "Profession intermédiaire de la santé du travail social",
  "libelle_specialite": "Commerce, vente",
  "libelle_ville_site": "SARTROUVILLE",
  "nom_site_formation": "Lycée Jean-Paul II",
  "code_naf_entreprise": "4721Z",
  "libelle_nationalite": "Communauté Européenne",
  "libelle_ville_jeune": "SARTROUVILLE",
  "duree_formation_mois": 36,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 78396,
  "code_origine_prec_cfa": 37,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 312,
  "libelle_specialite_com": "Commerce, vente",
  "code_commune_site_insee": 78586,
  "code_depart_jeune_insee": 78,
  "code_origine_annee_prec": 37,
  "code_commune_jeune_insee": 78586,
  "code_uai_etab_annee_prec": "78",
  "libelle_origine_prec_cfa": "SECONDE PROFESSIONNELLE (1ERE A DE BEP) OU 1ERE A CAP EN 2 ANS (en lycée)",
  "libelle_origine_annee_prec": "SECONDE PROFESSIONNELLE (1ERE A DE BEP) OU 1ERE A CAP EN 2 ANS (en lycée)"
}

Record 2sexe: Féminin · id_og: 79

{
  "sexe": "Féminin",
  "id_og": 79,
  "diplome": "25022111",
  "id_etab": 114,
  "code_pcs": 99,
  "code_sexe": "F",
  "libelle_og": "Institut de Formation Régional des Industries Alimentaires d'Ile-de-France (IFRIA Ile-de-France)",
  "code_niveau": 2,
  "num_section": 10,
  "code_qualite": "E",
  "type_diplome": "LICENCE PRO",
  "adresse1_site": "56 rue Planchat",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0753537M",
  "annee_scolaire": "09/10",
  "numero_section": 10,
  "annee_formation": 1,
  "libelle_diplome": "Industrie agro-alimentaire, alimentation spé qualité, sécurité, recherche, environnement (LP CNAM)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA IFRIA Ile de France",
  "code_nationalite": 1,
  "code_postal_site": 75020,
  "id_siteformation": "1965",
  "libelle_lien_cfa": "UFA (L6232-8)",
  "code_postal_jeune": 91200,
  "code_statut_jeune": "A",
  "depart_entreprise": 91,
  "age_jeune_decembre": 20,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Agro-alimentaire, alimentation, cuisine",
  "libelle_ville_site": "PARIS",
  "nom_site_formation": "Ecole Supérieure des Technologies de Biologie Appliquée",
  "code_naf_entreprise": "1089Z",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "ATHIS-MONS",
  "duree_formation_mois": 12,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 91021,
  "code_origine_prec_cfa": 117,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 221,
  "libelle_specialite_com": "Agro-alimentaire, alimentation, cuisine",
  "code_commune_site_insee": 75120,
  "code_depart_jeune_insee": 91,
  "code_origine_annee_prec": 117,
  "code_commune_jeune_insee": 91027,
  "code_uai_etab_annee_prec": "993",
  "libelle_origine_prec_cfa": "AUTRE",
  "libelle_origine_annee_prec": "AUTRE"
}

Record 3sexe: Masculin · id_og: 138

{
  "sexe": "Masculin",
  "id_og": 138,
  "diplome": "50022132",
  "id_etab": 126,
  "code_pcs": 99,
  "code_sexe": "M",
  "libelle_og": "Chambre de Métiers et de l'Artisanat des Yvelines",
  "code_niveau": 5,
  "num_section": 14,
  "code_qualite": "E",
  "type_diplome": "CAP",
  "adresse1_site": "17 avenue du Général Mangin",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0780424M",
  "annee_scolaire": "09/10",
  "numero_section": 14,
  "annee_formation": 2,
  "libelle_diplome": "Boulanger (CAP)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA de la Chambre de Métiers et de l'Artisanat des Yvelines",
  "code_nationalite": 1,
  "code_postal_site": 78000,
  "id_siteformation": "223",
  "libelle_lien_cfa": "Local du CFA",
  "code_postal_jeune": 78550,
  "code_statut_jeune": "A",
  "depart_entreprise": 78,
  "age_jeune_decembre": 18,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Agro-alimentaire, alimentation, cuisine",
  "libelle_ville_site": "VERSAILLES",
  "nom_site_formation": "CFA de la CMA du 78",
  "code_naf_entreprise": "1071C",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "RICHEBOURG",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 78310,
  "code_origine_prec_cfa": 23,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 221,
  "libelle_specialite_com": "Agro-alimentaire, alimentation, cuisine",
  "code_commune_site_insee": 78646,
  "code_depart_jeune_insee": 78,
  "code_origine_annee_prec": 73,
  "code_commune_jeune_insee": 78520,
  "code_uai_etab_annee_prec": "0780424M",
  "libelle_origine_prec_cfa": "3EME GENERALE (en collège)",
  "libelle_origine_annee_prec": "1ERE ANNEE CAP OU AUTRE DIPLOME DE NIVEAU V (STATUT APPRENTISSAGE)"
}

Record 4sexe: Féminin · id_og: 57

{
  "sexe": "Féminin",
  "id_og": 57,
  "diplome": "25031501",
  "id_etab": 77,
  "code_pcs": 99,
  "code_sexe": "F",
  "libelle_og": "Chambre de Commerce et d'Industrie de Versailles Val d'Oise - Yvelines",
  "code_niveau": 2,
  "num_section": 4,
  "code_qualite": "E",
  "type_diplome": "LICENCE PRO",
  "adresse1_site": "19 allée des Vignes",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0782118D",
  "annee_scolaire": "09/10",
  "numero_section": 4,
  "annee_formation": 1,
  "libelle_diplome": "Gestion des ressources humaines spé gestion des ressources humaines (LP)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA de la CCIV - ESSYM",
  "code_nationalite": 1,
  "code_postal_site": 78120,
  "id_siteformation": "2067",
  "libelle_lien_cfa": "Convention L6231-3",
  "code_postal_jeune": 78610,
  "code_statut_jeune": "A",
  "depart_entreprise": 78,
  "age_jeune_decembre": 22,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Ressources humaines, gestion du personnel, gestion de l'emploi",
  "libelle_ville_site": "RAMBOUILLET",
  "nom_site_formation": "Université de Versailles Saint-Quentin en Yvelines - IUT de Rambouillet",
  "code_naf_entreprise": "7010Z",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "AUFFARGIS",
  "duree_formation_mois": 10,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 78423,
  "code_origine_prec_cfa": 99,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 315,
  "libelle_specialite_com": "Gestion des ressources humaines",
  "code_commune_site_insee": 78517,
  "code_depart_jeune_insee": 78,
  "code_origine_annee_prec": 99,
  "code_commune_jeune_insee": 78030,
  "code_uai_etab_annee_prec": "78",
  "libelle_origine_prec_cfa": "2EME ANNEE DUT (STATUT APPRENTISSAGE)",
  "libelle_origine_annee_prec": "2EME ANNEE DUT (STATUT APPRENTISSAGE)"
}

Record 5sexe: Masculin · id_og: 205

{
  "sexe": "Masculin",
  "id_og": 205,
  "diplome": "50022136",
  "id_etab": 361,
  "code_pcs": 21,
  "code_sexe": "M",
  "libelle_og": "Association Faculte des Metiers de l'Essonne",
  "code_niveau": 5,
  "num_section": 103,
  "code_qualite": "E",
  "type_diplome": "CAP",
  "adresse1_site": "3 Chemin de la Grange Feu Louis",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0912267V",
  "annee_scolaire": "09/10",
  "numero_section": 103,
  "annee_formation": 2,
  "libelle_diplome": "Pâtissier (CAP)",
  "libelle_qualite": "Externe",
  "nom_complet_cfa": "CFA de la Faculté des Métiers de l'Essonne",
  "code_nationalite": 1,
  "code_postal_site": 91000,
  "id_siteformation": "2020",
  "libelle_lien_cfa": "Local du CFA",
  "code_postal_jeune": 91450,
  "code_statut_jeune": "A",
  "depart_entreprise": 91,
  "age_jeune_decembre": 17,
  "libelle_pcs_parent": "Artisan",
  "libelle_specialite": "Agro-alimentaire, alimentation, cuisine",
  "libelle_ville_site": "EVRY",
  "nom_site_formation": "CFA FDME - Site d'EVRY",
  "code_naf_entreprise": "1071C",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "SOISY-SUR-SEINE",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 91600,
  "code_origine_prec_cfa": 15,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 221,
  "libelle_specialite_com": "Agro-alimentaire, alimentation, cuisine",
  "code_commune_site_insee": 91228,
  "code_depart_jeune_insee": 91,
  "code_origine_annee_prec": 73,
  "code_commune_jeune_insee": 91600,
  "code_uai_etab_annee_prec": "0910846A",
  "libelle_origine_prec_cfa": "4EME GENERALE (en collège)",
  "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_2009-2010

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_2009-2010/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

77k

76668

Update cadence

Annual

declared upstream

Last upstream update

7 years ago

2020-02-19

Temporal coverage

2009 → 2010

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.