Register record·API·FRSTALE · checked 4d ago

E

School enrolment figures for the city of Le HaillanEffectifs scolaires de la ville du Haillan

Effectifs scolaires de la ville du HaillanSchool enrolment figures for the city of Le Haillan

APIDiscovered1/7blocked by verifiedQuery nowOpen workbench Subscribe🇫🇷France

This API provides data on the evolution of school enrolment numbers in the town of Le Haillan, part of Bordeaux Métropole. For each school, it gives the number of classes and total number of pupils since the 1994/1995 school year, and from 2015/2016 onward adds a breakdown of pupil numbers by grade level. The data is produced by the relevant municipal department and made available through the Bordeaux Métropole open data portal, with free access and no authentication required.Evolution des effectifs scolaires : > depuis l'année scolaire 1994/1995 par établissement : nombre de classes et nombre total d'élèves > à partir de l'année scolaire 2015/2016 par établissement : nombre de classes, nombre d'élèves par niveau et nombre total d'élèves Données produites par le servi...

education

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

Data schema (25 fields)

Filterable via the API (24)

nom_de_la_collectivitecode_insee_de_la_collectivitenumero_de_l_ecoledenomination_principalepatronymesecteuradresse_1_de_l_etablissementadresse_2_de_l_etablissementcpcommuneregion_academiqueacademiedepartementannee_scolairenombre_de_classenombre_total_d_eleveseffectif_en_pseffectif_en_mseffectif_en_gseffectif_en_cpeffectif_en_ce1effectif_en_ce2effectif_en_cm1effectif_en_cm2

Click a field to see example values.

Fill	Field	Type	Description
—	nom_de_la_collectiviteNom de la collectivité	text	Name of the local authority (municipality).Name of the local authority (municipality).
—	code_insee_de_la_collectiviteCode INSEE de la collectivité	int	INSEE code identifying the local authority.INSEE code identifying the local authority.
—	numero_de_l_ecoleNuméro de l'école	text	Official identification number of the school.Official identification number of the school.
—	denomination_principaleDénomination principale	text	Main official name/type of the school.Main official name/type of the school.
—	patronyme	text	School's common name or namesake.School's common name or namesake.
—	secteur	text	Sector of the school, public or private.Sector of the school, public or private.
—	geopoint	geo_point_2d	Geographic coordinates of the school.Geographic coordinates of the school.
—	adresse_1_de_l_etablissementAdresse 1 de l'établissement	text	First line of the school's address.First line of the school's address.
—	adresse_2_de_l_etablissementAdresse 2 de l'établissement	text	Second line of the school's address.Second line of the school's address.
—	cp	int	Postal code of the school's location.Postal code of the school's location.
100%	communeCommune	text	Name of the municipality where the school is located.Name of the municipality where the school is located.
100%	region_academiqueRégion Académique	text	Academic region the school belongs to.Academic region the school belongs to.
100%	academieAcadémie	text	Académie (education administrative district) the school belongs to.Académie (education administrative district) the school belongs to.
100%	departementDépartement	text	Department where the school is located.Department where the school is located.
100%	annee_scolaireAnnée_scolaire	text	School year covered by the record.School year covered by the record.
100%	nombre_de_classeNombre de classe	int	Number of classes in the school for the year.Number of classes in the school for the year.
100%	nombre_total_d_elevesNombre total d'Elèves	int	Total number of pupils enrolled in the school.Total number of pupils enrolled in the school.
16.6%	effectif_en_psEffectif en ps	int	Number of pupils enrolled in Petite Section (pre-kindergarten).Number of pupils enrolled in Petite Section (pre-kindergarten).
16.6%	effectif_en_msEffectif en ms	int	Number of pupils enrolled in Moyenne Section (kindergarten).Number of pupils enrolled in Moyenne Section (kindergarten).
16.6%	effectif_en_gsEffectif en gs	int	Number of pupils enrolled in Grande Section (pre-kindergarten).Number of pupils enrolled in Grande Section (pre-kindergarten).
11%	effectif_en_cpEffectif en cp	int	Number of pupils enrolled in CP (first grade).Number of pupils enrolled in CP (first grade).
11%	effectif_en_ce1Effectif en ce1	int	Number of pupils enrolled in CE1 (second grade).Number of pupils enrolled in CE1 (second grade).
11%	effectif_en_ce2Effectif en ce2	int	Number of pupils enrolled in CE2 (third grade).Number of pupils enrolled in CE2 (third grade).
11%	effectif_en_cm1Effectif en cm1	int	Number of pupils enrolled in CM1 (fourth grade).Number of pupils enrolled in CM1 (fourth grade).
11%	effectif_en_cm2Effectif en cm2	int	Number of pupils enrolled in CM2 (fifth grade).Number of pupils enrolled in CM2 (fifth grade).

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 1cp: 33185 · commune: LE HAILLAN

{
  "cp": 33185,
  "commune": "LE HAILLAN",
  "secteur": "PUBLIC",
  "academie": "BORDEAUX",
  "geopoint": {
    "lat": 44.88489,
    "lon": -0.678484
  },
  "patronyme": "TAUZINS",
  "departement": "Gironde",
  "annee_scolaire": "2010/2011",
  "effectif_en_cp": null,
  "effectif_en_gs": null,
  "effectif_en_ms": null,
  "effectif_en_ps": null,
  "effectif_en_ce1": null,
  "effectif_en_ce2": null,
  "effectif_en_cm1": null,
  "effectif_en_cm2": null,
  "nombre_de_classe": 3,
  "numero_de_l_ecole": "0332926B",
  "region_academique": "NOUVELLE-AQUITAINE",
  "nombre_total_d_eleves": 85,
  "nom_de_la_collectivite": "Ville Le Haillan",
  "denomination_principale": "ECOLE MATERNELLE PUBLIQUE",
  "adresse_1_de_l_etablissement": "rue des Arbousiers",
  "adresse_2_de_l_etablissement": null,
  "code_insee_de_la_collectivite": 33200
}

Record 2cp: 33185 · commune: LE HAILLAN

{
  "cp": 33185,
  "commune": "LE HAILLAN",
  "secteur": "PUBLIC",
  "academie": "BORDEAUX",
  "geopoint": {
    "lat": 44.88489,
    "lon": -0.678484
  },
  "patronyme": "TAUZINS",
  "departement": "Gironde",
  "annee_scolaire": "1995/1996",
  "effectif_en_cp": null,
  "effectif_en_gs": null,
  "effectif_en_ms": null,
  "effectif_en_ps": null,
  "effectif_en_ce1": null,
  "effectif_en_ce2": null,
  "effectif_en_cm1": null,
  "effectif_en_cm2": null,
  "nombre_de_classe": 3,
  "numero_de_l_ecole": "0332926B",
  "region_academique": "NOUVELLE-AQUITAINE",
  "nombre_total_d_eleves": 85,
  "nom_de_la_collectivite": "Ville Le Haillan",
  "denomination_principale": "ECOLE MATERNELLE PUBLIQUE",
  "adresse_1_de_l_etablissement": "rue des Arbousiers",
  "adresse_2_de_l_etablissement": null,
  "code_insee_de_la_collectivite": 33200
}

Record 3cp: 33185 · commune: LE HAILLAN

{
  "cp": 33185,
  "commune": "LE HAILLAN",
  "secteur": "PUBLIC",
  "academie": "BORDEAUX",
  "geopoint": {
    "lat": 44.873709,
    "lon": -0.677341
  },
  "patronyme": "CENTRE",
  "departement": "Gironde",
  "annee_scolaire": "2006/2007",
  "effectif_en_cp": null,
  "effectif_en_gs": null,
  "effectif_en_ms": null,
  "effectif_en_ps": null,
  "effectif_en_ce1": null,
  "effectif_en_ce2": null,
  "effectif_en_cm1": null,
  "effectif_en_cm2": null,
  "nombre_de_classe": 12,
  "numero_de_l_ecole": "0332631F",
  "region_academique": "NOUVELLE-AQUITAINE",
  "nombre_total_d_eleves": 320,
  "nom_de_la_collectivite": "Ville Le Haillan",
  "denomination_principale": "ECOLE ELEMENTAIRE PUBLIQUE",
  "adresse_1_de_l_etablissement": "9 place Henri Bos",
  "adresse_2_de_l_etablissement": null,
  "code_insee_de_la_collectivite": 33200
}

Record 4cp: 33185 · commune: LE HAILLAN

{
  "cp": 33185,
  "commune": "LE HAILLAN",
  "secteur": "PUBLIC",
  "academie": "BORDEAUX",
  "geopoint": {
    "lat": 44.866907,
    "lon": -0.671487
  },
  "patronyme": "LUZERNE",
  "departement": "Gironde",
  "annee_scolaire": "1998/1999",
  "effectif_en_cp": null,
  "effectif_en_gs": null,
  "effectif_en_ms": null,
  "effectif_en_ps": null,
  "effectif_en_ce1": null,
  "effectif_en_ce2": null,
  "effectif_en_cm1": null,
  "effectif_en_cm2": null,
  "nombre_de_classe": 5,
  "numero_de_l_ecole": "0332355F",
  "region_academique": "NOUVELLE-AQUITAINE",
  "nombre_total_d_eleves": 131,
  "nom_de_la_collectivite": "Ville Le Haillan",
  "denomination_principale": "ECOLE MATERNELLE PUBLIQUE",
  "adresse_1_de_l_etablissement": "rue Bernard de Girard",
  "adresse_2_de_l_etablissement": null,
  "code_insee_de_la_collectivite": 33200
}

Record 5cp: 33185 · commune: LE HAILLAN

{
  "cp": 33185,
  "commune": "LE HAILLAN",
  "secteur": "PUBLIC",
  "academie": "BORDEAUX",
  "geopoint": {
    "lat": 44.866907,
    "lon": -0.671487
  },
  "patronyme": "LUZERNE",
  "departement": "Gironde",
  "annee_scolaire": "2017/2018",
  "effectif_en_cp": null,
  "effectif_en_gs": 58,
  "effectif_en_ms": 61,
  "effectif_en_ps": 58,
  "effectif_en_ce1": null,
  "effectif_en_ce2": null,
  "effectif_en_cm1": null,
  "effectif_en_cm2": null,
  "nombre_de_classe": 6,
  "numero_de_l_ecole": "0332355F",
  "region_academique": "NOUVELLE-AQUITAINE",
  "nombre_total_d_eleves": 177,
  "nom_de_la_collectivite": "Ville Le Haillan",
  "denomination_principale": "ECOLE MATERNELLE PUBLIQUE",
  "adresse_1_de_l_etablissement": "rue Bernard de Girard",
  "adresse_2_de_l_etablissement": null,
  "code_insee_de_la_collectivite": 33200
}

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

Verification Status

Using the API

Configuration

Base URL: https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/leh_effectifs_scolaires

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/leh_effectifs_scolaires/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

50 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

145

Last upstream update

3 years ago

2023-07-10

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.

School enrolment figures for the city of Le HaillanEffectifs scolaires de la ville du Haillan

Trust score

Data schema (25 fields)

Query the data

Sample data (5 records)

Verification Status

Using the API

Configuration

License

Query examples

Rate limits

Dataset

Volume & freshness

License

Machine-readable & source