{"id":"7d182fb0-ec2d-4f02-9488-f5011bd05d07","type":"API","name":"ERP (établissements recevant du public) de Bordeaux","slug":"erp-etablissements-recevant-du-public-de-bordeaux","description":"Liste complète des établissements ouverts de la ville de Bordeaux recevant du public.","free_access_class":"UNKNOWN","auth_type":"UNKNOWN","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_erp/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_erp/","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/bor_erp/","extraction_confidence":"0.00","created_at":"2026-07-25T19:40:06.253Z","updated_at":"2026-07-25T20:19:01.124Z","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':7A,17B,27A,37B 'complete':29B 'complèt':9B 'de':6A,13B,16B,26A,33B,36B 'des':10B,30B 'du':4A,19B,24A,39B 'erp':1A,21A 'etablissements':22A,31B 'la':14B,34B 'list':8B 'liste':28B 'ouvert':12B 'ouverts':32B 'public':5A,20B,25A,40B 'recev':3A,18B 'recevant':23A,38B 'vill':15B 'ville':35B 'établiss':2A,11B","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-26T11:52:11.052Z","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/bor_erp/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/bor_erp/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/bor_erp/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/bor_erp/records?select=avec_hebergement%2Cnom_etablissement%2Cpropriete_ville&where=avec_hebergement+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/bor_erp","source":"base_url","runnable":false},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_erp/","source":"docs","runnable":false}],"formats":["CSV"]},"api_details":{"id":"ec50fffd-d351-40d6-8c03-bf97c0f079af","entry_id":"7d182fb0-ec2d-4f02-9488-f5011bd05d07","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_erp","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/bor_erp","created_at":"2026-07-25T19:40:06.419Z","updated_at":"2026-07-25T19:40:06.419Z"},"dataset_details":{"id":"692a9cd4-6eff-4e0e-a4e2-ec2e69687ffc","entry_id":"7d182fb0-ec2d-4f02-9488-f5011bd05d07","upstream_issued":null,"upstream_modified":"2020-03-10T08:41:50.000Z","themes":[],"update_frequency":"monthly","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-25T19:43:37.469Z","updated_at":"2026-07-25T19:43:37.469Z","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":"03c8f75c-ca63-4aa8-878e-de454589b8e4","entry_id":"7d182fb0-ec2d-4f02-9488-f5011bd05d07","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"bor_erp","fields":[{"name":"avec_hebergement","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"nom_etablissement","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"propriete_ville","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"categorie","type":"double","label":null,"fill_pct":94,"filterable":true,"description":null},{"name":"type","type":"text","label":null,"fill_pct":94.6,"filterable":true,"description":null},{"name":"adresse_1","type":"text","label":null,"fill_pct":98,"filterable":true,"description":null},{"name":"adresse_2","type":"text","label":null,"fill_pct":6.3,"filterable":true,"description":null},{"name":"code_postal","type":"text","label":null,"fill_pct":99.8,"filterable":true,"description":null},{"name":"commune","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"canton","type":"text","label":null,"fill_pct":43.8,"filterable":true,"description":null},{"name":"effectif_personnel","type":"int","label":null,"filterable":true,"description":null},{"name":"nb_visiteurs_max","type":"int","label":null,"filterable":true,"description":null},{"name":"geometrie","type":"geo_point_2d","label":null,"filterable":false,"description":null}],"field_count":13,"sample_records":[{"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},{"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},{"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},{"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},{"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}],"record_count":"9243","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_erp/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_erp/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/bor_erp/records?select=avec_hebergement%2Cnom_etablissement%2Cpropriete_ville&where=avec_hebergement+is+not+null&limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_erp/records?select=avec_hebergement%2Cnom_etablissement%2Cpropriete_ville&where=avec_hebergement+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (avec_hebergement, nom_etablissement, propriete_ville) and filter with ODSQL where clauses."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_erp/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_erp/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-25T19:43:36.960Z","run_id":"d1889ac6-c7f0-45e6-9b3d-eff912cddfa3","created_at":"2026-07-25T19:43:36.960Z","updated_at":"2026-07-25T19:43:36.960Z","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":"5abd1d1c-e807-494a-a267-089ee8fc04dc","entry_id":"7d182fb0-ec2d-4f02-9488-f5011bd05d07","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-25T19:43:37.638Z"}]}