Register record·API·FRVERIFIED · checked 2d ago

C

COVID-19 : Etablissements ouverts (agrégat de 3 sources)

Name: COVID-19 : Etablissements ouverts (agrégat de 3 sources)
Creator: opendatasoft

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

Le jeu de données est un agrégat, sans doublons, de trois sources d'informations recensant les établissements ouverts pendant la période de confinement : source CCI/CMA/CA : Commerces ouverts, autorisés à maintenir une activité en Alsace source Hopla-courses : Petits commerces et producteurs - in...

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

Data schema (25 fields)

Filterable via the API (24)

nometablissementjourethorairead_numnomruedriveccica_idcontact_webdate_entreesecteuractivitelivraisonad_codepostalfk_osm_ididad_villefk_hopla_idmode_de_retraitepcicommunesourceidlongitudelatitudesecteuractivite_initialinfocomplementairejourethoraire_2licence

Click a field to see example values.

Fill	Field	Type	Description
99%	nometablissementNom	text	—
61.5%	jourethoraire	text	—
71.5%	ad_numnomrueAdresse	text	—
67.6%	drive	text	—
68%	ccica_idCcica id	int	—
47.3%	contact_webSite Internet	text	—
68%	date_entreeDate entrée	datetime	—
100%	secteuractiviteSecteur d'activités	text	—
85.3%	livraison	text	—
71.1%	ad_codepostalCode postal	text	—
100%	fk_osm_idFk osm id	int	—
100%	id	int	—
70.9%	ad_villeAd ville	text	—
100%	fk_hopla_idFk hopla id	int	—
123%	mode_de_retraitMode de retrait	text	—
100%	epci	text	—
100%	communeCommune	text	—
100%	sourceidSource	text	—
100%	longitudeLongitude	double	—
100%	latitudeLatitude	double	—
—	secteuractivite_initialSecteur activités initial	text	—
—	infocomplementaireInfo complémentaire	text	—
—	jourethoraire_2Jour et horaire (osm)	text	—
—	pointgeo	geo_point_2d	—
—	licence	text	—

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 1id: 11 · epci: Eurométropole de Strasbourg

{
  "id": 11,
  "epci": "Eurométropole de Strasbourg",
  "drive": "Oui",
  "commune": "Strasbourg",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "Strasbourg",
  "ccica_id": 11,
  "latitude": 48.58127780000916,
  "pointgeo": {
    "lat": 48.5812778,
    "lon": 7.744703
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Non",
  "longitude": 7.744703000000001,
  "contact_web": "https://quaidesbrumes.com/evenement/1522/mise-en-place-dun-service-de-retrait-de-commande",
  "date_entree": "2020-04-30T11:14:00+00:00",
  "fk_hopla_id": 177,
  "ad_numnomrue": "120 Grand'Rue",
  "ad_codepostal": "67000",
  "jourethoraire": "[{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"11:00\",\"fromtimelabel\":\"11:00\",\"totime\":\"13:00\",\"totimelabel\":\"13:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"11:00\",\"fromtimelabel\":\"11:00\",\"totime\":\"13:00\",\"totimelabel\":\"13:00\"},{\"day\":\"Saturday\",\"daylabel\":\"sam\",\"fromtime\":\"11:00\",\"fromtimelabel\":\"11:00\",\"totime\":\"13:00\",\"totimelabel\":\"13:00\"}]",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Drive"
  ],
  "secteuractivite": "Autre",
  "nometablissement": "Quai des Brumes",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

Record 2id: 17 · epci: CA Colmar Agglomération

{
  "id": 17,
  "epci": "CA Colmar Agglomération",
  "drive": "Oui",
  "commune": "Horbourg-Wihr",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "Horbourg-Wihr",
  "ccica_id": 17,
  "latitude": 48.074921500010625,
  "pointgeo": {
    "lat": 48.0749215,
    "lon": 7.4065786
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Oui",
  "longitude": 7.4065786,
  "contact_web": "https://www.cookettendances.com/",
  "date_entree": "2020-04-29T10:21:00+00:00",
  "fk_hopla_id": 0,
  "ad_numnomrue": "5 Rue de Ribeauvillé",
  "ad_codepostal": "68180",
  "jourethoraire": "[{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"09:30\",\"fromtimelabel\":\"09:30\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"09:30\",\"fromtimelabel\":\"09:30\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"09:30\",\"fromtimelabel\":\"09:30\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Friday\",\"daylabel\":\"ven\",\"fromtime\":\"09:30\",\"fromtimelabel\":\"09:30\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Saturday\",\"daylabel\":…",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Drive",
    "Livraison"
  ],
  "secteuractivite": "Autre",
  "nometablissement": "COOK ET TENDANCES",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

Record 3id: 21 · epci: CC Sundgau

{
  "id": 21,
  "epci": "CC Sundgau",
  "drive": "Oui",
  "commune": "Carspach",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "CARSPACH/ALTKIRCH",
  "ccica_id": 21,
  "latitude": 47.63005030001192,
  "pointgeo": {
    "lat": 47.6300503,
    "lon": 7.2007442
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Non",
  "longitude": 7.200744200000003,
  "contact_web": "http://wwwauberge-sundgovienne.fr",
  "date_entree": "2020-04-28T17:49:00+00:00",
  "fk_hopla_id": 0,
  "ad_numnomrue": "1 route de Belfort",
  "ad_codepostal": "68130",
  "jourethoraire": "[{\"day\":\"Friday\",\"daylabel\":\"ven\",\"fromtime\":\"11:00\",\"fromtimelabel\":\"11:00\",\"totime\":\"13:30\",\"totimelabel\":\"13:30\"},{\"day\":\"Saturday\",\"daylabel\":\"sam\",\"fromtime\":\"11:00\",\"fromtimelabel\":\"11:00\",\"totime\":\"13:30\",\"totimelabel\":\"13:30\"},{\"day\":\"Sunday\",\"daylabel\":\"dim\",\"fromtime\":\"11:00\",\"fromtimelabel\":\"11:00\",\"totime\":\"13:30\",\"totimelabel\":\"13:30\"}]",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Drive"
  ],
  "secteuractivite": "Restaurant",
  "nometablissement": "auberge sundgovienne",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

Record 4id: 29 · epci: CC de la Vallée de la Doller et du Soult

{
  "id": 29,
  "epci": "CC de la Vallée de la Doller et du Soultzbach",
  "drive": "Oui",
  "commune": "Masevaux-Niederbruck",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "MASEVAUX NIEDERBRUCK",
  "ccica_id": 29,
  "latitude": 47.77295640001151,
  "pointgeo": {
    "lat": 47.7729564,
    "lon": 6.9938779
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Non",
  "longitude": 6.9938779,
  "contact_web": "http://www.restaurant-linvitation.fr/accueil.html?fbclid=IwAR1UDg7Wadl8ldzQ_vKAQ_lMVWLE9m4ioFAm3VLWD9fIW4RiV1rfF6LQjCs",
  "date_entree": "2020-04-28T11:41:00+00:00",
  "fk_hopla_id": 0,
  "ad_numnomrue": "7 PORTE SAINT MARTIN",
  "ad_codepostal": "68290",
  "jourethoraire": "[{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"11:30\",\"fromtimelabel\":\"11:30\",\"totime\":\"13:30\",\"totimelabel\":\"13:30\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"11:30\",\"fromtimelabel\":\"11:30\",\"totime\":\"13:30\",\"totimelabel\":\"13:30\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"11:30\",\"fromtimelabel\":\"11:30\",\"totime\":\"13:30\",\"totimelabel\":\"13:30\"},{\"day\":\"Friday\",\"daylabel\":\"ven\",\"fromtime\":\"11:30\",\"fromtimelabel\":\"11:30\",\"totime\":\"13:30\",\"totimelabel\":\"13:30\"}]",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Drive"
  ],
  "secteuractivite": "Restaurant",
  "nometablissement": "restaurant linvitation",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

Record 5id: 52 · epci: Eurométropole de Strasbourg

{
  "id": 52,
  "epci": "Eurométropole de Strasbourg",
  "drive": "Non",
  "commune": "Plobsheim",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "Plobsheim",
  "ccica_id": 52,
  "latitude": 48.47141790000947,
  "pointgeo": {
    "lat": 48.4714179,
    "lon": 7.7345364
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Non",
  "longitude": 7.734536399999999,
  "contact_web": null,
  "date_entree": "2020-04-27T16:20:00+00:00",
  "fk_hopla_id": 0,
  "ad_numnomrue": "Rue de la Bannau",
  "ad_codepostal": "67115",
  "jourethoraire": "[{\"day\":\"Saturday\",\"daylabel\":\"sam\",\"fromtime\":\"10:00\",\"fromtimelabel\":\"10:00\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"}]",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Non connu"
  ],
  "secteuractivite": "Producteur / Agriculteur",
  "nometablissement": "La Ferme de la Bannau",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

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

Verification Status

Using the API

Configuration

Base URL: https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/covid-19-etablissements-ouverts-agregat-sources

License

Terms stated by the source (not a recognized license):

Licence Ouverte v2.0 (Etalab) ou Open Database License (ODbL) - suivant l'enregistrement (cf. info dans colonne "Licence")

Query examples

curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/covid-19-etablissements-ouverts-agregat-sources/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

2 000 000 req/day

per ipmeasured

observed 6 days ago

Dataset

Volume & freshness

Records

2.5k

2488

Last upstream update

6 years ago

2020-05-04

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.

COVID-19 : Etablissements ouverts (agrégat de 3 sources)

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