Establishments (business locations)Etablissement (d'une entreprise)

Etablissement (d'une entreprise)Establishments (business locations)

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset published on the Bordeaux Métropole open data portal represents, as point features, the locations of establishments—commercial, industrial or business premises—within the territory of Bordeaux Métropole. An establishment is defined as a geographically distinct production unit that is not necessarily an independent legal entity, as opposed to the company or enterprise itself. The dataset provides the geographic positioning of such establishments across the metropolitan area, useful for mapping economic activity and business presence at the local level.Dictionnaire Public Ce jeu de données représente sous forme de ponctuels l'emplacement des établissements (établissement commercial, industriel ou entreprise) présents sur le territoire de Bordeaux Métropole. Un établissement est une unité de production géographiquement individualisée mais juridi...

⬇ 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 (33 fields)

Filterable via the API (31)

gidraison_socialesigleenseigneforme_juridiqueforme_juridique_aggdate_entreprisedate_etablissementstatutnafgroupe_nafsection_nafurladressetelephoneemailidentannee_effectiftranche_effectifinseenomzonage_economiqueacteur_economiqueactivite_commerceoriginecdatemdategeom_ogeom_errsectioncodesection

Click a field to see example values.

Field	Type	Description
gid	int	Primary key identifier for the record.Clé primaire
raison_socialeRaison sociale	text	Legal (corporate) name of the business.Raison sociale
sigle	text	Acronym or abbreviation of the company name.Sigle
enseigne	text	Trading name or sign under which the establishment operates.Enseigne de l'établissement
forme_juridiqueForme juridique	text	Detailed legal form of the business.Forme juridique
forme_juridique_aggForme juridique agg	text	Aggregated category of the legal form of the business.Forme juridique agrégée : Liste des valeurs possibles : SARL_EURL : SARL et EURL COMMERCANT : Commerçant NON_RENSEIGNE : Non renseigné SPIC : Services Publics Industriels et Commerciaux EXPLOITANT_AGRICOLE : Exploitant Agricole ARTISAN_COMMERCANT : Artisan et Commerçant SA : SA ou assimilés AUTRE : Autres Groupement de Droit Privé AFFAIRE_PERSONNEL : Affaires personnelles personne physique ASSOCIATION : Associations ou assimilées et Organismes Professionnels SERVICE_PUBLIC : Services Publics Administratifs,Gestionnaires des Régimes de Protection Sociale ARTISAN : Artisan LIBERAL : Professions Libérales et Assimilés GES : Groupements d'Economie Sociale
date_entrepriseDate entreprise	datetime	Date the parent company was created.Date de création de l'entreprise
date_etablissementDate etablissement	datetime	Date the establishment was created.Date de création de l'établissement
statut	text	Status of the establishment, e.g. headquarters or secondary site.Statut de l'établissement : Liste des valeurs possibles : SIEGE_MONO : Siège mono etablissement SIEGE_MULTI : Siège multi établissements NON_RENSEIGNE : Non renseigné SIEGE : Siège SECONDAIRE : Secondaire
naf	text	NAF activity code of the establishment.Code NAF de l'établissement
groupe_nafGroupe naf	text	NAF activity group code.Groupe NAF
section_nafSection naf	text	NAF activity section code.Section NAF
url	text	Website URL of the establishment.URL de site web
adresse	text	Street address of the establishment.Adresse de l'établissement
telephone	text	Contact telephone number of the establishment.Numéro de téléphone
email	text	Contact email address of the establishment.Adresse email
ident	text	SIRET number identifying the establishment.Numéro de SIRET
annee_effectifAnnee effectif	text	Year of the last known workforce figure.Année dernier effectif connu
tranche_effectifTranche effectif	text	Employee headcount bracket of the establishment.Tranche d'effectif de l'établissement : Liste des valeurs possibles : ND : Unité non employeuse 00 : 0 salarié 01 : 1 ou 2 salariés 02 : 3 à 5 salariés 03 : 6 à 9 salariés 11 : 10 à 19 salariés 12 : 20 à 49 salariés 21 : 50 à 99 salariés 22 : 100 à 199 salariés 31 : 200 à 249 salariés 32 : 250 à 499 salariés 41 : 500 à 999 salariés 42 : 1 000 à 1 999 salariés 51 : 2 000 à 4 999 salariés 52 : 5 000 à 9 999 salariés 53 : 10 000 salariés et plus
insee	text	INSEE code of the municipality where the establishment is located.Code INSEE : Liste des valeurs possibles : 33003 : Ambarès-et-Lagrave 33004 : Ambès 33013 : Artigues-Près-Bordeaux 33032 : Bassens 33039 : Bègles 33056 : Blanquefort 33063 : Bordeaux 33065 : Bouliac 33069 : Le Bouscat 33075 : Bruges 33096 : Carbon-Blanc 33119 : Cenon 33162 : Eysines 33167 : Floirac 33192 : Gradignan 33200 : Le Haillan 33249 : Lormont 33273 : Martignas-sur-Jalle 33281 : Mérignac 33312 : Parempuyre 33318 : Pessac 33376 : Saint-Aubin-de-Médoc 33434 : Saint-Louis-de-Montferrand 33449 : Saint-Médard-en-Jalles 33487 : Saint-Vincent-de-Paul 33519 : Le Taillan-Médoc 33522 : Talence 33550 : Villenave-d'Ornon
nom	text	Name of the municipality.Nom de la commune
geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude, longitude) of the establishment.Geographic coordinates (latitude, longitude) of the establishment.
geo_shapeShape	geo_shape	Geometric shape data describing the establishment's location as GeoJSON.Geometric shape data describing the establishment's location as GeoJSON.
zonage_economiqueZonage economique	text	Economic activity zone in which the establishment is located.Zone d'activité à vocation économique
acteur_economiqueActeur economique	text	Indicates whether the establishment is classified as an economic actor.Acteur économique
activite_commerceActivite commerce	text	Type of commercial activity performed.Activité de commerce
origine	text	Source system or origin of the record.Origine de l'objet
cdate	datetime	Date the record was created.Date de création
mdate	datetime	Date the record was last modified.Date de modification
geom_oGeom o	text	Orientation code of the geometric point.Orientation du point
geom_errGeom err	text	Error code indicating a geometric anomaly in the record.Code d'erreur géométrique : Liste des valeurs possibles : 9999 : Polygone compose et / ou à sections multiples 9998 : Linéaire compose et / ou à sections multiples 9996 : La géométrie contient des informations LRS 9995 : Nombre de dimensions différent de 2 ou 3 9994 : Présence d'un arc de cercle 9000 : Erreur autre 13343 : Polygone de moins de 4 points 13349 : Polygone papillon 13350 : Deux éléments d'un polygone archipel se touchent 13351 : Deux éléments d'un polygone archipel se touchent 13356 : Point double 13366 : Combinaison invalide d'intérieur / extérieur d'un polygone 13367 : Orientation invalide d'intérieur / extérieur d'un polygone
section	text	Business activity section label.Business activity section label.
codesection	text	Code of the NAF activity section.Code of the NAF activity section.

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 1gid: 2448642 · naf: 6820B

{
  "gid": 2448642,
  "naf": "6820B",
  "nom": "Bordeaux",
  "url": null,
  "cdate": "2025-10-08T08:27:49+00:00",
  "email": null,
  "ident": "80521408700019",
  "insee": "33063",
  "mdate": "2014-09-28T22:00:00+00:00",
  "sigle": null,
  "geom_o": "0",
  "statut": "SIEGE_MONO",
  "adresse": "8 Cours du 30 Juillet, 33000 BORDEAUX",
  "origine": "AGDE",
  "section": "Activités immobilières",
  "enseigne": null,
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.5743338,
        44.8434307
      ]
    },
    "properties": {}
  },
  "telephone": null,
  "groupe_naf": "682",
  "codesection": "L",
  "section_naf": "L",
  "geo_point_2d": {
    "lat": 44.8434307,
    "lon": -0.5743338
  },
  "annee_effectif": "2026",
  "raison_sociale": "SCI LACAZE",
  "date_entreprise": "2014-09-28T22:00:00+00:00",
  "forme_juridique": "Société civile immobilière",
  "tranche_effectif": null,
  "acteur_economique": "False",
  "activite_commerce": "non attribué",
  "zonage_economique": "HORS_ZONAGE",
  "date_etablissement": "2014-09-28T22:00:00+00:00",
  "forme_juridique_agg": "AUTRE"
}

Record 2gid: 2271184 · naf: 7732Z

{
  "gid": 2271184,
  "naf": "7732Z",
  "nom": "Mérignac",
  "url": null,
  "cdate": "2025-10-08T08:27:49+00:00",
  "email": null,
  "ident": "95259264000025",
  "insee": "33281",
  "mdate": "2023-10-18T22:00:00+00:00",
  "sigle": null,
  "geom_o": "0",
  "statut": "SIEGE_MONO",
  "adresse": "54 Avenue de l'Argonne, 33700 MERIGNAC",
  "origine": "AGDE",
  "section": "Activités de services administratifs et de soutien",
  "enseigne": null,
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.6844504,
        44.8246863
      ]
    },
    "properties": {}
  },
  "telephone": null,
  "groupe_naf": "773",
  "codesection": "N",
  "section_naf": "N",
  "geo_point_2d": {
    "lat": 44.8246863,
    "lon": -0.6844504
  },
  "annee_effectif": "2026",
  "raison_sociale": "EURO BTP NOA",
  "date_entreprise": "2023-05-14T22:00:00+00:00",
  "forme_juridique": "Société par actions simplifiée (SAS)",
  "tranche_effectif": null,
  "acteur_economique": "True",
  "activite_commerce": "non attribué",
  "zonage_economique": "OIM_BORDEAUX_AEROPORT",
  "date_etablissement": "2023-10-18T22:00:00+00:00",
  "forme_juridique_agg": "SA"
}

Record 3gid: 2529301 · naf: 8299Z

{
  "gid": 2529301,
  "naf": "8299Z",
  "nom": "Villenave-d'Ornon",
  "url": null,
  "cdate": "2025-11-15T22:30:30+00:00",
  "email": null,
  "ident": "94758316700020",
  "insee": "33550",
  "mdate": "2025-11-14T23:00:00+00:00",
  "sigle": null,
  "geom_o": "0",
  "statut": "SIEGE_MONO",
  "adresse": "23 Avenue Jean Monnet, 33140 VILLENAVE-D'ORNON",
  "origine": "AGDE",
  "section": "Activités de services administratifs et de soutien",
  "enseigne": null,
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.5802649,
        44.7707779
      ]
    },
    "properties": {}
  },
  "telephone": null,
  "groupe_naf": "829",
  "codesection": "N",
  "section_naf": "N",
  "geo_point_2d": {
    "lat": 44.7707779,
    "lon": -0.5802649
  },
  "annee_effectif": "2026",
  "raison_sociale": "BERRY LAURINE VICTOIRE",
  "date_entreprise": "2022-11-27T23:00:00+00:00",
  "forme_juridique": "Entrepreneur individuel",
  "tranche_effectif": null,
  "acteur_economique": "True",
  "activite_commerce": "non attribué",
  "zonage_economique": "HORS_ZONAGE",
  "date_etablissement": "2025-11-14T23:00:00+00:00",
  "forme_juridique_agg": "AFFAIRE_PERSONNEL"
}

Record 4gid: 3066786 · naf: 5320Z

{
  "gid": 3066786,
  "naf": "5320Z",
  "nom": "Bordeaux",
  "url": null,
  "cdate": "2026-05-11T08:46:03+00:00",
  "email": null,
  "ident": "10334844700014",
  "insee": "33063",
  "mdate": "2026-04-03T22:00:00+00:00",
  "sigle": null,
  "geom_o": "0",
  "statut": "SIEGE_MONO",
  "adresse": "7 Rue Pasteur, 33000 BORDEAUX",
  "origine": "AGDE",
  "section": "Transports et entreposage",
  "enseigne": null,
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.599604,
        44.84531
      ]
    },
    "properties": {}
  },
  "telephone": null,
  "groupe_naf": "532",
  "codesection": "H",
  "section_naf": "H",
  "geo_point_2d": {
    "lat": 44.84531,
    "lon": -0.599604
  },
  "annee_effectif": "2026",
  "raison_sociale": "SIMONNEAU PAULIN",
  "date_entreprise": "2026-04-03T22:00:00+00:00",
  "forme_juridique": "Entrepreneur individuel",
  "tranche_effectif": null,
  "acteur_economique": "True",
  "activite_commerce": "non attribué",
  "zonage_economique": "HORS_ZONAGE",
  "date_etablissement": "2026-04-03T22:00:00+00:00",
  "forme_juridique_agg": "AFFAIRE_PERSONNEL"
}

Record 5gid: 2387913 · naf: 6820B

{
  "gid": 2387913,
  "naf": "6820B",
  "nom": "Bordeaux",
  "url": null,
  "cdate": "2025-10-08T08:27:49+00:00",
  "email": null,
  "ident": "90801229700010",
  "insee": "33063",
  "mdate": "2021-10-20T22:00:00+00:00",
  "sigle": null,
  "geom_o": "0",
  "statut": "SIEGE_MONO",
  "adresse": "32 Rue Masson, 33000 BORDEAUX",
  "origine": "AGDE",
  "section": "Activités immobilières",
  "enseigne": null,
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.6162436,
        44.8547099
      ]
    },
    "properties": {}
  },
  "telephone": null,
  "groupe_naf": "682",
  "codesection": "L",
  "section_naf": "L",
  "geo_point_2d": {
    "lat": 44.8547099,
    "lon": -0.6162436
  },
  "annee_effectif": "2026",
  "raison_sociale": "GASTRO INVEST",
  "date_entreprise": "2021-10-20T22:00:00+00:00",
  "forme_juridique": "Société civile immobilière",
  "tranche_effectif": null,
  "acteur_economique": "False",
  "activite_commerce": "non attribué",
  "zonage_economique": "HORS_ZONAGE",
  "date_etablissement": "2021-10-20T22:00:00+00:00",
  "forme_juridique_agg": "AUTRE"
}

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

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/fi_etabl_p/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 3 days ago

Dataset

Volume & freshness

Records

238k

238178

Last upstream update

3 days ago

2026-10-21

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.