COVID-19: Small Shops and Producers (hopla-courses)COVID-19 : Petits commerces et producteurs (hopla-courses)
COVID-19 : Petits commerces et producteurs (hopla-courses)COVID-19: Small Shops and Producers (hopla-courses)
This API provides a dataset listing small shops and producers, mostly food-related, that offered drive-through or delivery services during the COVID-19 lockdown period in France. The data originates from the citizen initiative hopla-courses.alsace, which collected self-reported information from local businesses about their continued activity. It is published via the Strasbourg open-data portal and covers the national context of small-scale retail adaptation during the pandemic, useful for tracking local commerce continuity efforts.Le jeu reprend l'ensemble des services Drive et/ou de livraison de petits commerces et producteurs, essentiellement alimentaires ayant signalé leur activité durant la période de confinement. Ces données sont issues de l'initiative citoyenne : hopla-courses.alsace Méthode de collecte Les données c...
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (12 fields)
Click a field to see example values.
| Fill | Field | Type | Description |
|---|---|---|---|
| — | hopla_idHopla id | int | — |
| — | nometablissement | text | — |
| — | mode_de_retraitMode de retrait | text | — |
| — | latitudeLatitude | double | — |
| — | longitudeLongitude | double | — |
| — | infocomplementaire | text | — |
| — | icon_google_numIcon google num | int | — |
| — | icon_google_labelIcon google label | text | — |
| — | icon_google_colorIcon google color | text | — |
| — | geopoint | geo_point_2d | — |
| 100% | epci | text | — |
| 100% | communeCommune | 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.
Sample data (5 records)
Record 1epci: CC du Pays de Sainte-Odile · commune: Obernai
{
"epci": "CC du Pays de Sainte-Odile",
"commune": "Obernai",
"geopoint": {
"lat": 48.462077,
"lon": 7.4726
},
"hopla_id": 7,
"latitude": 48.462077,
"longitude": 7.47260000000006,
"icon_google_num": 1798,
"mode_de_retrait": null,
"nometablissement": "Vins d'Alsace Robert Blanck",
"icon_google_color": "7CB342",
"icon_google_label": "Serre",
"infocomplementaire": null
}Record 2epci: CC du Pays de Barr · commune: Heiligenstein
{
"epci": "CC du Pays de Barr",
"commune": "Heiligenstein",
"geopoint": {
"lat": 48.426211,
"lon": 7.4503371
},
"hopla_id": 8,
"latitude": 48.426211,
"longitude": 7.45033710000007,
"icon_google_num": 1798,
"mode_de_retrait": null,
"nometablissement": "Earl Charles BOCH - Vigneron",
"icon_google_color": "7CB342",
"icon_google_label": "Serre",
"infocomplementaire": null
}Record 3epci: CC de la Vallée de Kaysersberg · commune: Kaysersberg Vignoble
{
"epci": "CC de la Vallée de Kaysersberg",
"commune": "Kaysersberg Vignoble",
"geopoint": {
"lat": 48.1481693,
"lon": 7.2508172
},
"hopla_id": 10,
"latitude": 48.1481693,
"longitude": 7.25081720000003,
"icon_google_num": 1798,
"mode_de_retrait": null,
"nometablissement": "Vins d'Alsace Jean Dietrich",
"icon_google_color": "7CB342",
"icon_google_label": "Serre",
"infocomplementaire": null
}Record 4epci: CC du Pays de Barr · commune: Barr
{
"epci": "CC du Pays de Barr",
"commune": "Barr",
"geopoint": {
"lat": 48.409473,
"lon": 7.450185
},
"hopla_id": 26,
"latitude": 48.409473,
"longitude": 7.45018500000003,
"icon_google_num": 1798,
"mode_de_retrait": null,
"nometablissement": "Domaine Hering",
"icon_google_color": "FF5252",
"icon_google_label": "Serre",
"infocomplementaire": "Drive, commande à passer en ligne (rubrique commande à chercher à Barr) et règlement de la commande en ligne. <br>Prendre rendez-vous par téléphone pour récupérer la commande sur notre parking."
}Record 5epci: CC du Pays de Ribeauvillé · commune: Zellenberg
{
"epci": "CC du Pays de Ribeauvillé",
"commune": "Zellenberg",
"geopoint": {
"lat": 48.1715216,
"lon": 7.320069
},
"hopla_id": 28,
"latitude": 48.1715216,
"longitude": 7.32006899999999,
"icon_google_num": 1798,
"mode_de_retrait": null,
"nometablissement": "Maison Jean Huttard",
"icon_google_color": "FFD600",
"icon_google_label": "Serre",
"infocomplementaire": "\"Périmètre de livraison 50 km pour 12 bouteilles ou 15km pour 6 bouteilles<br>Pour le drive horaire à convenir sur rdv\""
}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-petits-commerces-et-producteurs
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/covid-19-petits-commerces-et-producteurs/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.
Rate limits
Dataset
Volume & freshness
License
No license declared upstream.
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.