Apprenticeship - detailed enrollment figures 2010-2011Apprentissage - effectifs détaillés 2010-2011

Apprentissage - effectifs détaillés 2010-2011Apprenticeship - detailed enrollment figures 2010-2011

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset, published via the Île-de-France regional open data portal, provides detailed statistics on apprentices enrolled during the 2010-2011 school year. It covers learner profiles (age, sex, nationality, department and city of residence, and parents' occupation and socio-professional category), the training pursued (level, specialty, diploma, and duration), prior education, and the location where the training took place. It is intended for analysis of apprenticeship demographics and training patterns across the Île-de-France region for that academic year.Toutes les informations sur les apprentis de l'année scolaire 2010-2011 : 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.
89.4%	diplome	int	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	Code for the level of the diploma.Code for the level of the diploma.
100%	type_diplomeType diplome	text	Type of diploma, e.g. CAP or BP.Type of diploma, e.g. CAP or BP.
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 field.Name of the training specialty field.
100%	libelle_specialite_comLibelle specialite com	text	Detailed or complementary name of the training specialty.Detailed or complementary name of the training specialty.
100%	id_ogId og	int	Identifier of the organizing body (e.g. chamber of commerce).Identifier of the organizing body (e.g. chamber of commerce).
100%	libelle_ogLibelle og	text	Name of the organizing body responsible for the CFA.Name of the organizing body responsible for the CFA.
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 or class.Number identifying the training section or 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 study within the training program.Year of study within the training program.
100%	id_siteformationId siteformation	int	Identifier of the training site.Identifier of the training site.
100%	code_uai_siteCode uai site	text	UAI code identifying the training site.UAI code identifying 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.
10.1%	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 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 town where the training site is located.Name of the town where the training site is located.
100%	num_sectionNum section	int	Number identifying the training section or class.Number identifying the training section or class.
100%	age_jeune_decembreAge jeune decembre	int	Age of the apprentice as of December.Age of the apprentice as of December.
24.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 sex.Code for the apprentice's sex.
100%	sexe	text	Sex of the apprentice.Sex 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	Description of the apprentice's boarding/meal status.Description of the apprentice's boarding/meal status.
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 parent.Socio-professional category code of the parent.
100%	libelle_pcs_parentLibelle pcs parent	text	Socio-professional category label of the parent.Socio-professional category label of the parent.
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	Description of the apprentice's contractual status.Description of the apprentice's contractual status.
100%	code_origine_prec_cfaCode origine prec cfa	int	Code for the apprentice's situation prior to this CFA.Code for the apprentice's situation prior to this CFA.
100%	libelle_origine_prec_cfaLibelle origine prec cfa	text	Description of the apprentice's situation prior to this CFA.Description of the apprentice's situation prior to this CFA.
100%	code_origine_annee_precCode origine annee prec	int	Code for the apprentice's situation in the previous year.Code for the apprentice's situation in the previous year.
100%	libelle_origine_annee_precLibelle origine annee prec	text	Description of the apprentice's situation in the previous year.Description of the apprentice's situation in the previous 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 code of the apprentice's municipality of residence.INSEE code of the apprentice's municipality of residence.
100%	code_postal_jeuneCode postal jeune	int	Postal code of the apprentice's residence.Postal code of the apprentice's residence.
99.7%	libelle_ville_jeuneLibelle ville jeune	text	Name of the town where the apprentice resides.Name of the town where the apprentice resides.
99%	code_naf_entrepriseCode naf entreprise	text	NAF activity code of the employing company.NAF activity code of the employing company.
99.3%	depart_entrepriseDepart entreprise	int	Department number of the employing company.Department number of the employing company.
99.3%	code_insee_entrepriseCode insee entreprise	int	INSEE code of the employing company's municipality.INSEE code of the employing company's municipality.
100%	code_uai_etab_annee_precCode uai etab annee prec	text	UAI code of the establishment attended the previous year.UAI code of the establishment attended the previous year.

Schema captured from opendatasoft 2 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: Féminin · id_og: 205

{
  "sexe": "Féminin",
  "id_og": 205,
  "diplome": null,
  "id_etab": 361,
  "code_pcs": 76,
  "code_sexe": "F",
  "libelle_og": "Association Faculte des Metiers de l'Essonne",
  "code_niveau": 3,
  "num_section": 76,
  "code_qualite": "D",
  "type_diplome": "TH3-C",
  "adresse1_site": "3 Chemin de la Grange Feu Louis",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0912267V",
  "annee_scolaire": "10/11",
  "numero_section": 76,
  "annee_formation": 1,
  "libelle_diplome": "Gestionnaire d'unité commerciale et de distribution de l'ACFCI (TH NIV3)",
  "libelle_qualite": "Demi-pensionnaire",
  "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": 91600,
  "code_statut_jeune": "A",
  "depart_entreprise": 91,
  "age_jeune_decembre": 22,
  "libelle_pcs_parent": "Retraite employé et ouvrier",
  "libelle_specialite": "Commerce, vente",
  "libelle_ville_site": "EVRY",
  "nom_site_formation": "CFA FDME - Site d'EVRY",
  "code_naf_entreprise": "4782Z",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "SAVIGNY-SUR-ORGE",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 91174,
  "code_origine_prec_cfa": 111,
  "handicap_oui_non_vide": null,
  "code_groupe_specialite": 312,
  "libelle_specialite_com": "Commerce, vente",
  "code_commune_site_insee": 91228,
  "code_depart_jeune_insee": 91,
  "code_origine_annee_prec": 111,
  "code_commune_jeune_insee": 91589,
  "code_uai_etab_annee_prec": "91",
  "libelle_origine_prec_cfa": "EMPLOI (Y COMPRIS CES)",
  "libelle_origine_annee_prec": "EMPLOI (Y COMPRIS CES)"
}

Record 2sexe: 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": "10/11",
  "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": 93290,
  "code_statut_jeune": "A",
  "depart_entreprise": 77,
  "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": "4642Z",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "TREMBLAY-EN-FRANCE",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 77294,
  "code_origine_prec_cfa": 65,
  "handicap_oui_non_vide": "N",
  "code_groupe_specialite": 312,
  "libelle_specialite_com": "Commerce, vente",
  "code_commune_site_insee": 93900,
  "code_depart_jeune_insee": 93,
  "code_origine_annee_prec": 105,
  "code_commune_jeune_insee": 93073,
  "code_uai_etab_annee_prec": "0932469D",
  "libelle_origine_prec_cfa": "2EME ANNEE IUT",
  "libelle_origine_annee_prec": "APPRENTISSAGE BAC+3 (STATUT APPRENTISSAGE)"
}

Record 3sexe: Masculin · id_og: 43

{
  "sexe": "Masculin",
  "id_og": 43,
  "diplome": 50022136,
  "id_etab": 45,
  "code_pcs": 99,
  "code_sexe": "M",
  "libelle_og": "Chambre des Métiers et de l'Artisanat Nord Seine et Marne",
  "code_niveau": 5,
  "num_section": 70,
  "code_qualite": "D",
  "type_diplome": "CAP",
  "adresse1_site": "Avenue des Sablons Bouillants",
  "adresse2_site": null,
  "adresse3_site": null,
  "code_uai_site": "0770998S",
  "annee_scolaire": "10/11",
  "numero_section": 70,
  "annee_formation": 2,
  "libelle_diplome": "Pâtissier (CAP)",
  "libelle_qualite": "Demi-pensionnaire",
  "nom_complet_cfa": "CFA Chambre de Métiers et Artisanat du Nord de la Seine-et-Marne",
  "code_nationalite": 1,
  "code_postal_site": 77100,
  "id_siteformation": 935,
  "libelle_lien_cfa": "Local du CFA",
  "code_postal_jeune": 77100,
  "code_statut_jeune": "A",
  "depart_entreprise": 77,
  "age_jeune_decembre": 20,
  "libelle_pcs_parent": "Non renseigné (inconnu ou sans objet)",
  "libelle_specialite": "Agro-alimentaire, alimentation, cuisine",
  "libelle_ville_site": "MEAUX",
  "nom_site_formation": "CFA de la Chambre de Métiers de Meaux",
  "code_naf_entreprise": "4711F",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "MEAUX",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 77284,
  "code_origine_prec_cfa": 47,
  "handicap_oui_non_vide": "N",
  "code_groupe_specialite": 221,
  "libelle_specialite_com": "Agro-alimentaire, alimentation, cuisine",
  "code_commune_site_insee": 77284,
  "code_depart_jeune_insee": 77,
  "code_origine_annee_prec": 73,
  "code_commune_jeune_insee": 77284,
  "code_uai_etab_annee_prec": "0770998S",
  "libelle_origine_prec_cfa": "SECONDE GENERALE OU TECHNOLOGIQUE (en lycée)",
  "libelle_origine_annee_prec": "1ERE ANNEE CAP OU AUTRE DIPLOME DE NIVEAU V (STATUT APPRENTISSAGE)"
}

Record 4sexe: Masculin · id_og: 138

{
  "sexe": "Masculin",
  "id_og": 138,
  "diplome": 50022136,
  "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": 48,
  "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": "10/11",
  "numero_section": 48,
  "annee_formation": 1,
  "libelle_diplome": "Pâtissier (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": 91430,
  "code_statut_jeune": "A",
  "depart_entreprise": 75,
  "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": "1071D",
  "libelle_nationalite": "France",
  "libelle_ville_jeune": "IGNY",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 75114,
  "code_origine_prec_cfa": 43,
  "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": 91,
  "code_origine_annee_prec": 43,
  "code_commune_jeune_insee": 91312,
  "code_uai_etab_annee_prec": "993",
  "libelle_origine_prec_cfa": "1ERE PROFESSIONNELLE (1ERE ANNEE BAC PRO OU BT) (en lycée)",
  "libelle_origine_annee_prec": "1ERE PROFESSIONNELLE (1ERE ANNEE BAC PRO OU BT) (en lycée)"
}

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": "10/11",
  "numero_section": 3,
  "annee_formation": 1,
  "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": 3,
  "code_postal_site": 92000,
  "id_siteformation": 133,
  "libelle_lien_cfa": "Local du CFA",
  "code_postal_jeune": 92000,
  "code_statut_jeune": "A",
  "depart_entreprise": 92,
  "age_jeune_decembre": 17,
  "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": "Autre",
  "libelle_ville_jeune": "NANTERRE",
  "duree_formation_mois": 24,
  "libelle_statut_jeune": "Contrat d'apprentissage",
  "code_insee_entreprise": 92009,
  "code_origine_prec_cfa": 75,
  "handicap_oui_non_vide": "O",
  "code_groupe_specialite": 336,
  "libelle_specialite_com": "Coiffure, esthétique",
  "code_commune_site_insee": 92050,
  "code_depart_jeune_insee": 92,
  "code_origine_annee_prec": 75,
  "code_commune_jeune_insee": 92050,
  "code_uai_etab_annee_prec": "993",
  "libelle_origine_prec_cfa": "2EME ANNEE CAP OU AUTRE DIPLOME DE NIVEAU V (STATUT APPRENTISSAGE)",
  "libelle_origine_annee_prec": "2EME 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_2010-2011

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_2010-2011/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 2 days ago

Dataset

Volume & freshness

Records

79k

78728

Update cadence

Annual

declared upstream

Last upstream update

7 years ago

2020-02-19

Temporal coverage

2010 → 2011

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.