Register record·API·FR·Updated MonthlySTALE · checked 4d ago

E

ERP (Establishments Open to the Public) of BordeauxERP (établissements recevant du public) de Bordeaux

Name: ERP (Establishments Open to the Public) of Bordeaux
Creator: opendatasoft

ERP (établissements recevant du public) de BordeauxERP (Establishments Open to the Public) of Bordeaux

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

This API provides a complete list of establishments open to the public (ERP) in the city of Bordeaux. It is published as part of the Bordeaux Métropole open-data portal and offers free access without authentication. The dataset covers venues such as shops, public buildings, and other facilities accessible to the public within the city, and can be used for mapping, safety planning, or accessibility studies related to public establishments in Bordeaux.Liste complète des établissements ouverts de la ville de Bordeaux recevant du public.

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

Data schema (13 fields)

Filterable via the API (12)

avec_hebergementnom_etablissementpropriete_villecategorietypeadresse_1adresse_2code_postalcommunecantoneffectif_personnelnb_visiteurs_max

Click a field to see example values.

Fill	Field	Type	Description
100%	avec_hebergementAvec hebergement	text	—
100%	nom_etablissementNom etablissement	text	—
100%	propriete_villePropriete ville	text	—
94%	categorie	double	—
94.6%	type	text	—
98%	adresse_1Adresse 1	text	—
6.3%	adresse_2Adresse 2	text	—
99.8%	code_postalPostal code	text	—
100%	communeCommune	text	—
43.8%	canton	text	—
—	effectif_personnelEffectif personnel	int	—
—	nb_visiteurs_maxNb visiteurs max	int	—
—	geometrie	geo_point_2d	—

Schema captured from opendatasoft 6 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 1type: N · canton: —

{
  "type": "N",
  "canton": null,
  "commune": "BORDEAUX",
  "adresse_1": "22 rue Saumenude",
  "adresse_2": null,
  "categorie": 5,
  "geometrie": {
    "lat": 44.845913,
    "lon": -0.579204
  },
  "code_postal": "33000",
  "propriete_ville": "0",
  "avec_hebergement": "0",
  "nb_visiteurs_max": 0,
  "nom_etablissement": "LE POISSON ROUGE",
  "effectif_personnel": 0
}

Record 2type: — · canton: —

{
  "type": null,
  "canton": null,
  "commune": "BORDEAUX",
  "adresse_1": "375 avenue Thiers",
  "adresse_2": null,
  "categorie": null,
  "geometrie": {
    "lat": 44.852712,
    "lon": -0.539148
  },
  "code_postal": "33100",
  "propriete_ville": "0",
  "avec_hebergement": "0",
  "nb_visiteurs_max": 19,
  "nom_etablissement": "LE REFLET DU MIROIR",
  "effectif_personnel": 0
}

Record 3type: M · canton: —

{
  "type": "M",
  "canton": null,
  "commune": "BORDEAUX",
  "adresse_1": "55 rue des Etrangers- rue Blanqui et Voie nouvelle",
  "adresse_2": null,
  "categorie": 5,
  "geometrie": {
    "lat": 44.85847,
    "lon": -0.607336
  },
  "code_postal": "33000",
  "propriete_ville": "0",
  "avec_hebergement": "0",
  "nb_visiteurs_max": 119,
  "nom_etablissement": "LES BASSINS À FLOTS - COMMERCE 1",
  "effectif_personnel": 3
}

Record 4type: R · canton: 06 St Seurin Fondaudège

{
  "type": "R",
  "canton": "06 St Seurin Fondaudège",
  "commune": "BORDEAUX",
  "adresse_1": "76 RUE LAROCHE",
  "adresse_2": null,
  "categorie": 5,
  "geometrie": {
    "lat": 44.852282,
    "lon": -0.585369
  },
  "code_postal": "33000",
  "propriete_ville": "0",
  "avec_hebergement": "0",
  "nb_visiteurs_max": 0,
  "nom_etablissement": "LES COMPAGNONS DU DEVOIR:BAT SUD",
  "effectif_personnel": 0
}

Record 5type: N · canton: 05 Hotel de Ville et Quinconces

{
  "type": "N",
  "canton": "05 Hotel de Ville et Quinconces",
  "commune": "BORDEAUX",
  "adresse_1": "22 RUE DOCTEUR CHARLES NANCEL PENARD",
  "adresse_2": "17 RUE VILLENEUVE",
  "categorie": 5,
  "geometrie": {
    "lat": 44.839774,
    "lon": -0.581131
  },
  "code_postal": "33000",
  "propriete_ville": "0",
  "avec_hebergement": "0",
  "nb_visiteurs_max": 40,
  "nom_etablissement": "LES DELICES DU FOURNIL",
  "effectif_personnel": 3
}

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/bor_erp

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/bor_erp/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 6 days ago

Dataset

Volume & freshness

Records

9.2k

9243

Update cadence

Monthly

declared upstream

Last upstream update

7 years ago

2020-03-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.

ERP (Establishments Open to the Public) of BordeauxERP (établissements recevant du public) de Bordeaux

Trust score

Data schema (13 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