{"id":"73e794bf-1b06-43ea-93c0-e3704b413899","type":"API","name":"Etablissement (d'une entreprise)","slug":"etablissement-dune-entreprise","description":"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...","free_access_class":"UNKNOWN","auth_type":"UNKNOWN","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/fi_etabl_p/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/fi_etabl_p/","repo_url":null,"status":"ACTIVE","verification_state":"UNVERIFIED","tags":[],"logo_url":"https://opendata.bordeaux-metropole.fr/assets/favicon?tstamp=174885191012131","primary_source_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/fi_etabl_p/","extraction_confidence":"0.00","created_at":"2026-07-25T18:15:04.998Z","updated_at":"2026-07-25T20:19:00.611Z","last_verified_at":null,"deprecated_at":null,"ranking_score":0,"last_ranked_at":null,"last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'bordeaux':30B,72B 'ce':7B,49B 'commerci':21B 'commercial':63B 'd':2A,44A 'de':9B,14B,29B,37B,51B,56B,71B,79B 'des':18B,60B 'dictionnair':5B 'dictionnaire':47B 'donnees':52B 'donné':10B 'emplac':17B 'emplacement':59B 'entrepris':4A,24B 'entreprise':46A,66B 'est':34B,76B 'etabliss':1A 'etablissement':43A,62B,75B 'etablissements':61B 'form':13B 'forme':55B 'geographiquement':81B 'géographiqu':39B 'individualisee':82B 'individualisé':40B 'industriel':22B,64B 'jeu':8B,50B 'juridi':42B,84B 'l':16B,58B 'le':27B,69B 'mai':41B 'mais':83B 'metropole':73B 'métropol':31B 'ou':23B,65B 'ponctuel':15B 'ponctuels':57B 'presents':67B 'product':38B 'production':80B 'présent':25B 'public':6B,48B 'represente':53B 'représent':11B 'sous':12B,54B 'sur':26B,68B 'territoir':28B 'territoire':70B 'un':32B,74B 'une':3A,35B,45A,77B 'unite':78B 'unité':36B 'établiss':19B,20B,33B","popularity_score":"0.0000","maintenance_score":"0.0000","institution_id":null,"institution_type":null,"country_code":"FR","official_confidence":0,"proof_summary":"Confidence: 0%","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-26T20:01:16.705Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":13.75,"access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"List records","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/records?limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Select & filter","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/records?select=geo_point_2d%2Cgeo_shape%2Cgid&where=geom_o+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"API base URL","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p","source":"base_url","runnable":false},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/fi_etabl_p/","source":"docs","runnable":false}],"formats":["CSV"]},"api_details":{"id":"1aa8da6f-3664-4a0e-bb5d-e04c7deaf850","entry_id":"73e794bf-1b06-43ea-93c0-e3704b413899","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p","openapi_url":null,"graphql_url":null,"api_version":null,"spec_format":null,"endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p","created_at":"2026-07-25T18:15:05.153Z","updated_at":"2026-07-25T18:15:05.153Z"},"dataset_details":{"id":"a6abb744-6c05-44f8-a006-8fcd8872e39c","entry_id":"73e794bf-1b06-43ea-93c0-e3704b413899","upstream_issued":null,"upstream_modified":"2026-07-25T04:20:29.000Z","themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":"opendatasoft","source_portal_url":"https://opendata.bordeaux-metropole.fr","created_at":"2026-07-25T18:20:00.240Z","updated_at":"2026-07-25T18:20:00.240Z","publisher":null,"publisher_url":null,"distributions":[],"license":null},"license":{"id":"lo-2.0","spdx_id":"etalab-2.0","name":"Licence Ouverte 2.0 (France / Etalab)","url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","latest_check":null,"data_profile":{"id":"d47b3918-30b7-45c5-b0ce-653d0be67134","entry_id":"73e794bf-1b06-43ea-93c0-e3704b413899","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"fi_etabl_p","fields":[{"name":"geo_point_2d","type":"geo_point_2d","label":"Geo Point","filterable":false,"description":null},{"name":"geo_shape","type":"geo_shape","label":null,"filterable":false,"description":null},{"name":"gid","type":"int","label":null,"filterable":true,"description":"Clé primaire"},{"name":"geom_o","type":"text","label":null,"filterable":true,"description":"Orientation du point"},{"name":"geom_err","type":"text","label":null,"filterable":true,"description":"Code d'erreur géométrique : \nListe des valeurs possibles : \n9999 : Polygone compose et / ou à sections multiples\n9998 : Linéaire compose et / ou à sections multiples\n9996 : La géométrie contient des informations LRS\n9995 : Nombre de dimensions différent de 2 ou 3\n9994 : Présence d'un arc de cercle\n9000 : Erreur autre\n13343 : Polygone de moins de 4 points\n13349 : Polygone papillon\n13350 : Deux éléments d'un polygone archipel se touchent\n13351 : Deux éléments d'un polygone archipel  se touchent\n13356 : Point double\n13366 : Combinaison invalide d'intérieur / extérieur d'un polygone\n13367 : Orientation invalide d'intérieur / extérieur d'un polygone"},{"name":"ident","type":"text","label":null,"filterable":true,"description":"Numéro de SIRET"},{"name":"adresse","type":"text","label":null,"filterable":true,"description":"Adresse de l'établissement"},{"name":"insee","type":"text","label":null,"filterable":true,"description":"Code INSEE : \nListe des valeurs possibles : \n33003 : Ambarès-et-Lagrave\n33004 : Ambès\n33013 : Artigues-Près-Bordeaux\n33032 : Bassens\n33039 : Bègles\n33056 : Blanquefort\n33063 : Bordeaux\n33065 : Bouliac\n33069 : Le Bouscat\n33075 : Bruges\n33096 : Carbon-Blanc\n33119 : Cenon\n33162 : Eysines\n33167 : Floirac\n33192 : Gradignan\n33200 : Le Haillan\n33249 : Lormont\n33273 : Martignas-sur-Jalle\n33281 : Mérignac\n33312 : Parempuyre\n33318 : Pessac\n33376 : Saint-Aubin-de-Médoc\n33434 : Saint-Louis-de-Montferrand\n33449 : Saint-Médard-en-Jalles\n33487 : Saint-Vincent-de-Paul\n33519 : Le Taillan-Médoc\n33522 : Talence\n33550 : Villenave-d'Ornon"},{"name":"raison_sociale","type":"text","label":null,"filterable":true,"description":"Raison sociale"},{"name":"enseigne","type":"text","label":null,"filterable":true,"description":"Enseigne de l'établissement"},{"name":"sigle","type":"text","label":null,"filterable":true,"description":"Sigle"},{"name":"telephone","type":"text","label":null,"filterable":true,"description":"Numéro de téléphone"},{"name":"date_etablissement","type":"datetime","label":null,"filterable":true,"description":"Date de création de l'établissement"},{"name":"section","type":"text","label":null,"filterable":true,"description":null},{"name":"email","type":"text","label":null,"filterable":true,"description":"Adresse email"},{"name":"url","type":"text","label":null,"filterable":true,"description":"URL de site web"},{"name":"forme_juridique_agg","type":"text","label":null,"filterable":true,"description":"Forme juridique agrégée : \nListe des valeurs possibles : \nSARL_EURL : SARL et EURL\nCOMMERCANT : Commerçant\nNON_RENSEIGNE : Non renseigné\nSPIC : Services Publics Industriels et Commerciaux\nEXPLOITANT_AGRICOLE : Exploitant Agricole\nARTISAN_COMMERCANT : Artisan et Commerçant\nSA : SA ou assimilés\nAUTRE : Autres Groupement de Droit Privé\nAFFAIRE_PERSONNEL : Affaires personnelles personne physique\nASSOCIATION : Associations ou assimilées et Organismes Professionnels\nSERVICE_PUBLIC : Services Publics Administratifs,Gestionnaires des Régimes de Protection Sociale\nARTISAN : Artisan\nLIBERAL : Professions Libérales et Assimilés\nGES : Groupements d'Economie Sociale"},{"name":"forme_juridique","type":"text","label":null,"filterable":true,"description":"Forme juridique"},{"name":"statut","type":"text","label":null,"filterable":true,"description":"Statut de l'établissement : \nListe des valeurs possibles : \nSIEGE_MONO : Siège mono etablissement\nSIEGE_MULTI : Siège multi établissements\nNON_RENSEIGNE : Non renseigné\nSIEGE : Siège\nSECONDAIRE : Secondaire"},{"name":"date_entreprise","type":"datetime","label":null,"filterable":true,"description":"Date de création de l'entreprise"},{"name":"naf","type":"text","label":null,"filterable":true,"description":"Code NAF de l'établissement"},{"name":"annee_effectif","type":"text","label":null,"filterable":true,"description":"Année dernier effectif connu"},{"name":"tranche_effectif","type":"text","label":null,"filterable":true,"description":"Tranche d'effectif de l'établissement : \nListe des valeurs possibles : \nND : Unité non employeuse\n00 : 0 salarié\n01 : 1 ou 2 salariés\n02 : 3 à 5 salariés\n03 : 6 à 9 salariés\n11 : 10 à 19 salariés\n12 : 20 à 49 salariés\n21 : 50 à 99 salariés\n22 : 100 à 199 salariés\n31 : 200 à 249 salariés\n32 : 250 à 499 salariés\n41 : 500 à 999 salariés\n42 : 1 000 à 1 999 salariés\n51 : 2 000 à 4 999 salariés\n52 : 5 000 à 9 999 salariés\n53 : 10 000 salariés et plus"},{"name":"cdate","type":"datetime","label":null,"filterable":true,"description":"Date de création"},{"name":"mdate","type":"datetime","label":null,"filterable":true,"description":"Date de modification"},{"name":"codesection","type":"text","label":null,"filterable":true,"description":null},{"name":"nom","type":"text","label":null,"filterable":true,"description":"Nom de la commune"},{"name":"groupe_naf","type":"text","label":null,"filterable":true,"description":"Groupe NAF"},{"name":"section_naf","type":"text","label":null,"filterable":true,"description":"Section NAF"},{"name":"zonage_economique","type":"text","label":null,"filterable":true,"description":"Zone d'activité à vocation économique"},{"name":"acteur_economique","type":"text","label":null,"filterable":true,"description":"Acteur économique"},{"name":"activite_commerce","type":"text","label":null,"filterable":true,"description":"Activité de commerce"},{"name":"origine","type":"text","label":null,"filterable":true,"description":"Origine de l'objet"}],"field_count":33,"sample_records":[{"gid":2424151,"naf":"8621Z","nom":"Villenave-d'Ornon","url":null,"cdate":"2025-10-08T08:27:49+00:00","email":null,"ident":"41200437600023","insee":"33550","mdate":"2011-12-31T23:00:00+00:00","sigle":null,"geom_o":"0","statut":"SIEGE_MONO","adresse":"167 Avenue des Pyrénées, 33140 VILLENAVE-D'ORNON","origine":"AGDE","section":"Santé humaine et action sociale","enseigne":null,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5594189,44.762557]},"properties":{}},"telephone":"0556871252","groupe_naf":"862","codesection":"Q","section_naf":"Q","geo_point_2d":{"lat":44.762557,"lon":-0.5594189},"annee_effectif":"2026","raison_sociale":"BERNADET LOOTGIETER LAURE","date_entreprise":"1997-01-01T23:00:00+00:00","forme_juridique":"Entrepreneur individuel","tranche_effectif":null,"acteur_economique":"True","activite_commerce":"non attribué","zonage_economique":"HORS_ZONAGE","date_etablissement":"2000-10-15T22:00:00+00:00","forme_juridique_agg":"AFFAIRE_PERSONNEL"},{"gid":3053046,"naf":"8621Z","nom":"Mérignac","url":null,"cdate":"2025-12-21T22:19:21+00:00","email":null,"ident":"99532642800019","insee":"33281","mdate":"2025-11-30T23:00:00+00:00","sigle":null,"geom_o":"0","statut":"SIEGE_MONO","adresse":"N/A, 33700                MERIGNAC","origine":"AGDE","section":"Santé humaine et action sociale","enseigne":null,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.6746819,44.8333699]},"properties":{}},"telephone":null,"groupe_naf":"862","codesection":"Q","section_naf":"Q","geo_point_2d":{"lat":44.8333699,"lon":-0.6746819},"annee_effectif":"2026","raison_sociale":"INFORMATION NON-DIFFUSIBLE","date_entreprise":"2025-11-30T23: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-30T23:00:00+00:00","forme_juridique_agg":"AFFAIRE_PERSONNEL"},{"gid":3609705,"naf":"5630Z","nom":"Mérignac","url":null,"cdate":"2026-05-23T21:39:24+00:00","email":null,"ident":"78194438400010","insee":"33281","mdate":"2011-12-31T23:00:00+00:00","sigle":null,"geom_o":"0","statut":"SIEGE_MONO","adresse":"Rue du Jard, 33700 MERIGNAC","origine":"AGDE","section":"Hébergement et restauration","enseigne":null,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.6389167,44.8473557]},"properties":{}},"telephone":null,"groupe_naf":"563","codesection":"I","section_naf":"I","geo_point_2d":{"lat":44.8473557,"lon":-0.6389167},"annee_effectif":"2026","raison_sociale":"STADE AMICAL MERIGNACAIS DEBIT","date_entreprise":"1978-12-24T23:00:00+00:00","forme_juridique":"Association déclarée","tranche_effectif":null,"acteur_economique":"False","activite_commerce":"non attribué","zonage_economique":"HORS_ZONAGE","date_etablissement":"1993-12-24T23:00:00+00:00","forme_juridique_agg":"ASSOCIATION"},{"gid":2507729,"naf":"9003A","nom":"Bordeaux","url":null,"cdate":"2025-10-22T21:34:39+00:00","email":null,"ident":"80793724800019","insee":"33063","mdate":"2014-11-30T23:00:00+00:00","sigle":null,"geom_o":"0","statut":"SIEGE_MONO","adresse":"26 Rue Rolland, 33000 BORDEAUX","origine":"AGDE","section":"Arts, spectacles et activités récréatives","enseigne":null,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5811379,44.842635]},"properties":{}},"telephone":null,"groupe_naf":"900","codesection":"R","section_naf":"R","geo_point_2d":{"lat":44.842635,"lon":-0.5811379},"annee_effectif":"2026","raison_sociale":"ESPINASSE CLAIRE","date_entreprise":"2014-11-30T23:00:00+00:00","forme_juridique":"Entrepreneur individuel","tranche_effectif":null,"acteur_economique":"True","activite_commerce":"non attribué","zonage_economique":"HORS_ZONAGE","date_etablissement":"2014-11-30T23:00:00+00:00","forme_juridique_agg":"AFFAIRE_PERSONNEL"},{"gid":2423902,"naf":"9003A","nom":"Talence","url":null,"cdate":"2025-10-08T08:27:49+00:00","email":null,"ident":"33415481200021","insee":"33522","mdate":"2011-12-31T23:00:00+00:00","sigle":null,"geom_o":"0","statut":"SIEGE_MONO","adresse":"40 Rue de Lorraine, 33400 TALENCE","origine":"AGDE","section":"Arts, spectacles et activités récréatives","enseigne":null,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5914329,44.8225169]},"properties":{}},"telephone":null,"groupe_naf":"900","codesection":"R","section_naf":"R","geo_point_2d":{"lat":44.8225169,"lon":-0.5914329},"annee_effectif":"2026","raison_sociale":"BAL NATHALIE","date_entreprise":"1985-04-30T22:00:00+00:00","forme_juridique":"Entrepreneur individuel","tranche_effectif":null,"acteur_economique":"True","activite_commerce":"non attribué","zonage_economique":"HORS_ZONAGE","date_etablissement":"2010-01-03T23:00:00+00:00","forme_juridique_agg":"AFFAIRE_PERSONNEL"}],"record_count":"238178","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/records?limit=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 records of the dataset as JSON."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/records?select=geo_point_2d%2Cgeo_shape%2Cgid&where=geom_o+is+not+null&limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/records?select=geo_point_2d%2Cgeo_shape%2Cgid&where=geom_o+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (geo_point_2d, geo_shape, gid) and filter with ODSQL where clauses."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/fi_etabl_p/exports/csv' -o dataset.csv","label":"Export CSV","method":"GET","description":"Full dataset export as CSV (also available: json, parquet, xlsx)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-25T18:19:59.573Z","run_id":"76339c0b-d71f-4963-aa5a-65d3fbcc8d24","created_at":"2026-07-25T18:19:59.573Z","updated_at":"2026-07-25T18:19:59.573Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","license_id":"lo-2.0","previewable":true},"datasets":[],"limits":[{"id":"e2edf1ec-7d45-4bc8-96e3-c57d8f6e2aba","entry_id":"73e794bf-1b06-43ea-93c0-e3704b413899","limit_type":"requests_per_day","value":"50000","unit":"requests","period":"day","scope":"per-ip","source_id":null,"claim_type":"measured","confidence":"0.90","observed_at":"2026-07-25T18:20:00.395Z"}]}