COVID-19: Open establishments (aggregate of 3 sources)COVID-19 : Etablissements ouverts (agrégat de 3 sources)

COVID-19 : Etablissements ouverts (agrégat de 3 sources)COVID-19: Open establishments (aggregate of 3 sources)

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

This dataset, published via the Strasbourg open-data portal, aggregates, without duplicates, three sources listing establishments that remained open during the COVID-19 lockdown period in the Alsace region of France. It combines data from the CCI/CMA/CA network on shops authorized to maintain activity, the Hopla-courses source covering small shops and local producers, and a third source, into a single consolidated list. It is intended to help identify which local businesses continued operating during the lockdown.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

Trust score

How is this computed?

poor

Weighted across five axes. Tap a ring for what it measures.

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	Name of the establishment.Name of the establishment.
61.5%	jourethoraire	text	Opening days and hours, in JSON format.Opening days and hours, in JSON format.
71.5%	ad_numnomrueAdresse	text	Street number and name of the establishment's address.Street number and name of the establishment's address.
67.6%	drive	text	Indicates whether the establishment offers a drive-through/pickup service.Indicates whether the establishment offers a drive-through/pickup service.
68%	ccica_idCcica id	int	Identifier from the CCI/CMA/CA source.Identifier from the CCI/CMA/CA source.
47.3%	contact_webSite Internet	text	Website or social media URL of the establishment.Website or social media URL of the establishment.
68%	date_entreeDate entrée	datetime	Date and time the establishment was added to the dataset.Date and time the establishment was added to the dataset.
100%	secteuractiviteSecteur d'activités	text	Business sector of the establishment.Business sector of the establishment.
85.3%	livraison	text	Indicates whether the establishment offers home delivery.Indicates whether the establishment offers home delivery.
71.1%	ad_codepostalCode postal	text	Postal code of the establishment's address.Postal code of the establishment's address.
100%	fk_osm_idFk osm id	int	Identifier linking to the OpenStreetMap source.Identifier linking to the OpenStreetMap source.
100%	id	int	Unique internal identifier of the record.Unique internal identifier of the record.
70.9%	ad_villeAd ville	text	City of the establishment's address.City of the establishment's address.
100%	fk_hopla_idFk hopla id	int	Identifier linking to the Hopla-courses source.Identifier linking to the Hopla-courses source.
123%	mode_de_retraitMode de retrait	text	List of available order pickup or service methods.List of available order pickup or service methods.
100%	epci	text	Name of the intercommunal association (EPCI) covering the establishment.Name of the intercommunal association (EPCI) covering the establishment.
100%	communeCommune	text	Municipality where the establishment is located.Municipality where the establishment is located.
100%	sourceidSource	text	Name of the original data source for the record.Name of the original data source for the record.
100%	longitudeLongitude	double	Longitude coordinate of the establishment's location.Longitude coordinate of the establishment's location.
100%	latitudeLatitude	double	Latitude coordinate of the establishment's location.Latitude coordinate of the establishment's location.
—	secteuractivite_initialSecteur activités initial	text	Original business sector as recorded in the source data.Original business sector as recorded in the source data.
—	infocomplementaireInfo complémentaire	text	Additional information about the establishment.Additional information about the establishment.
—	jourethoraire_2Jour et horaire (osm)	text	Opening days and hours from the OpenStreetMap source.Opening days and hours from the OpenStreetMap source.
—	pointgeo	geo_point_2d	Geographic coordinates of the establishment as a point.Geographic coordinates of the establishment as a point.
—	licence	text	License under which the data is published.License under which the data is published.

Schema captured from opendatasoft 2 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: 1278 · epci: CA Colmar Agglomération

{
  "id": 1278,
  "epci": "CA Colmar Agglomération",
  "drive": "Oui",
  "commune": "Colmar",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "Colmar",
  "ccica_id": 1278,
  "latitude": 48.07841000001062,
  "pointgeo": {
    "lat": 48.07841,
    "lon": 7.358248
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Oui",
  "longitude": 7.358247999999999,
  "contact_web": "https://www.facebook.com/Fromagerie-Saint-Nicolas-383641235156569",
  "date_entree": "2020-02-04T10:25:00+00:00",
  "fk_hopla_id": 0,
  "ad_numnomrue": "18 Rue Saint-Nicolas",
  "ad_codepostal": "68000",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"14:00\",\"fromtimelabel\":\"14:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Drive",
    "Livraison"
  ],
  "secteuractivite": "Alimentaire",
  "nometablissement": "La Fromagerie Saint-Nicolas",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

Record 2id: 1358 · epci: CC de Hanau-La Petite Pierre

{
  "id": 1358,
  "epci": "CC de Hanau-La Petite Pierre",
  "drive": "Oui",
  "commune": "Bouxwiller",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "Bouxwiller",
  "ccica_id": 1358,
  "latitude": 48.82493080000846,
  "pointgeo": {
    "lat": 48.8249308,
    "lon": 7.4813839
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Oui",
  "longitude": 7.481383899999998,
  "contact_web": "http://www.patisserievoegtling.fr",
  "date_entree": "2020-01-04T14:48:00+00:00",
  "fk_hopla_id": 0,
  "ad_numnomrue": "10 rue des Seigneurs",
  "ad_codepostal": "67330",
  "jourethoraire": "[{\"day\":\"Friday\",\"daylabel\":\"ven\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"14:00\",\"totimelabel\":\"14:00\"},{\"day\":\"Saturday\",\"daylabel\":\"sam\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"14:00\",\"totimelabel\":\"14:00\"},{\"day\":\"Sunday\",\"daylabel\":\"dim\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"14:00\",\"totimelabel\":\"14:00\"}]",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Drive",
    "Livraison"
  ],
  "secteuractivite": "Alimentaire",
  "nometablissement": "Pâtisserie salon de thé Voegtling",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

Record 3id: 1221 · epci: CA Mulhouse Alsace Agglomération

{
  "id": 1221,
  "epci": "CA Mulhouse Alsace Agglomération",
  "drive": "Non",
  "commune": "Mulhouse",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "Mulhouse",
  "ccica_id": 1221,
  "latitude": 47.7363073000116,
  "pointgeo": {
    "lat": 47.7363073,
    "lon": 7.3326116
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Oui",
  "longitude": 7.3326116,
  "contact_web": "http://www.dirringer-mulhouse.fr",
  "date_entree": "2020-02-04T21:29:00+00:00",
  "fk_hopla_id": 0,
  "ad_numnomrue": "81 Avenue d'Altkirch",
  "ad_codepostal": "68100",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"07:00\",\"fromtimelabel\":\"07:00\",\"totime\":\"16:00\",\"totimelabel\":\"16:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"07:00\",\"fromtimelabel\":\"07:00\",\"totime\":\"16:00\",\"totimelabel\":\"16:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"07:00\",\"fromtimelabel\":\"07:00\",\"totime\":\"16:00\",\"totimelabel\":\"16:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"07:00\",\"fromtimelabel\":\"07:00\",\"totime\":\"16:00\",\"totimelabel\":\"16:00\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Livraison"
  ],
  "secteuractivite": "Alimentaire",
  "nometablissement": "Boulangerie Pâtisserie Dirringer",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

Record 4id: 731 · epci: CA Colmar Agglomération

{
  "id": 731,
  "epci": "CA Colmar Agglomération",
  "drive": "Non",
  "commune": "Colmar",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "Colmar",
  "ccica_id": 731,
  "latitude": 48.07779610001062,
  "pointgeo": {
    "lat": 48.0777961,
    "lon": 7.3541608
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Non",
  "longitude": 7.354160799999998,
  "contact_web": "http://www.bizkot.fr",
  "date_entree": "2020-06-04T16:13:00+00:00",
  "fk_hopla_id": 0,
  "ad_numnomrue": "2 Boulevard du Champ de Mars",
  "ad_codepostal": "68000",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"14:30\",\"totimelabel\":\"14:30\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"14:30\",\"totimelabel\":\"14:30\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"00:00\",\"fromtimelabel\":\"00:00\",\"totime\":\"00:00\",\"totimelabel\":\"00:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"14:30\",\"totimelabel\":\"14:30\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Non connu"
  ],
  "secteuractivite": "Alimentaire",
  "nometablissement": "Boulangerie Bizkot",
  "infocomplementaire": null,
  "secteuractivite_initial": null
}

Record 5id: 1555 · epci: CC de la Région de Molsheim-Mutzig

{
  "id": 1555,
  "epci": "CC de la Région de Molsheim-Mutzig",
  "drive": "Non",
  "commune": "Soultz-les-Bains",
  "licence": "Licence ouverte v2.0 (Etalab)",
  "ad_ville": "Soultz-les-Bains",
  "ccica_id": 1555,
  "latitude": 48.5695623000092,
  "pointgeo": {
    "lat": 48.5695623,
    "lon": 7.4902487
  },
  "sourceid": "CCI/CMA/CA",
  "fk_osm_id": 0,
  "livraison": "Oui",
  "longitude": 7.490248699999999,
  "contact_web": "https://www.lucien-doriath.fr/fr/",
  "date_entree": "2020-03-30T14:31:00+00:00",
  "fk_hopla_id": 333,
  "ad_numnomrue": "30 Rue de Molsheim",
  "ad_codepostal": "67120",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "jourethoraire_2": null,
  "mode_de_retrait": [
    "Livraison"
  ],
  "secteuractivite": "Producteur / Agriculteur",
  "nometablissement": "Foie Gras Lucien Doriath",
  "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 2 days ago

Dataset

Volume & freshness

Records

2.5k

2488

Last upstream update

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