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)

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

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

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

Trust score

How is this computed?

fair

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

Data schema (12 fields)

Filterable via the API (11)

hopla_idnometablissementmode_de_retraitlatitudelongitudeinfocomplementaireicon_google_numicon_google_labelicon_google_colorepcicommune

Click a field to see example values.

Fill	Field	Type	Description
—	hopla_idHopla id	int	Unique identifier from the hopla-courses initiative.Unique identifier from the hopla-courses initiative.
—	nometablissement	text	Name of the shop or producer.Name of the shop or producer.
—	mode_de_retraitMode de retrait	text	Delivery or pickup method offered.Delivery or pickup method offered.
—	latitudeLatitude	double	Latitude coordinate of the business location.Latitude coordinate of the business location.
—	longitudeLongitude	double	Longitude coordinate of the business location.Longitude coordinate of the business location.
—	infocomplementaire	text	Additional information about the business or its services.Additional information about the business or its services.
—	icon_google_numIcon google num	int	Numeric code for the Google map icon used.Numeric code for the Google map icon used.
—	icon_google_labelIcon google label	text	Label describing the Google map icon category.Label describing the Google map icon category.
—	icon_google_colorIcon google color	text	Hex color code of the Google map icon.Hex color code of the Google map icon.
—	geopoint	geo_point_2d	Geographic coordinates (latitude/longitude) of the business.Geographic coordinates (latitude/longitude) of the business.
100%	epci	text	Name of the intercommunal body (EPCI) the commune belongs to.Name of the intercommunal body (EPCI) the commune belongs to.
100%	communeCommune	text	Name of the municipality where the business is located.Name of the municipality where the business is located.

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 1epci: CC des Portes de Rosheim · commune: Bœrsch

{
  "epci": "CC des Portes de Rosheim",
  "commune": "Bœrsch",
  "geopoint": {
    "lat": 48.4686697,
    "lon": 7.4117933
  },
  "hopla_id": 539,
  "latitude": 48.4686697,
  "longitude": 7.4117933,
  "icon_google_num": 1577,
  "mode_de_retrait": [
    "Livraison"
  ],
  "nometablissement": "Restaurant du Cygne",
  "icon_google_color": "7CB342",
  "icon_google_label": "Restaurant",
  "infocomplementaire": "Livraison de plats du jour si commandé la veille"
}

Record 2epci: Eurométropole de Strasbourg · commune: Strasbourg

{
  "epci": "Eurométropole de Strasbourg",
  "commune": "Strasbourg",
  "geopoint": {
    "lat": 48.581767,
    "lon": 7.7479597
  },
  "hopla_id": 310,
  "latitude": 48.581767,
  "longitude": 7.74795970000002,
  "icon_google_num": 1567,
  "mode_de_retrait": [
    "Livraison"
  ],
  "nometablissement": "Dreher",
  "icon_google_color": "7CB342",
  "icon_google_label": "Restauration rapide",
  "infocomplementaire": null
}

Record 3epci: CC des Portes de Rosheim · commune: Bischoffsheim

{
  "epci": "CC des Portes de Rosheim",
  "commune": "Bischoffsheim",
  "geopoint": {
    "lat": 48.4883109,
    "lon": 7.5030648
  },
  "hopla_id": 413,
  "latitude": 48.4883109,
  "longitude": 7.50306479999995,
  "icon_google_num": 1553,
  "mode_de_retrait": [
    "Livraison"
  ],
  "nometablissement": "Ferme Schmitt SARL",
  "icon_google_color": "7CB342",
  "icon_google_label": "Steak",
  "infocomplementaire": null
}

Record 4epci: CC de Sélestat · commune: Châtenois

{
  "epci": "CC de Sélestat",
  "commune": "Châtenois",
  "geopoint": {
    "lat": 48.2727369,
    "lon": 7.3993364
  },
  "hopla_id": 281,
  "latitude": 48.2727369,
  "longitude": 7.39933640000004,
  "icon_google_num": 1684,
  "mode_de_retrait": [
    "Drive",
    "Livraison"
  ],
  "nometablissement": "Confitures et terroir",
  "icon_google_color": "0288D1",
  "icon_google_label": "Achats",
  "infocomplementaire": null
}

Record 5epci: CC Sud Alsace Largue · commune: Friesen

{
  "epci": "CC Sud Alsace Largue",
  "commune": "Friesen",
  "geopoint": {
    "lat": 47.5632446,
    "lon": 7.1540431
  },
  "hopla_id": 334,
  "latitude": 47.5632446,
  "longitude": 7.15404309999997,
  "icon_google_num": 1573,
  "mode_de_retrait": [
    "Livraison"
  ],
  "nometablissement": "Kohler Pisciculture",
  "icon_google_color": "7CB342",
  "icon_google_label": "Pêche",
  "infocomplementaire": "Notre pisciculture familiale vous fournira en truites arc en ciel(de 300grs à 1.5kg/pièces) , truites fario ( de 300/350grs/pieces), saumons de fontaines (300/350grs/pièces) soit vidées ou en filets.<br>Nous disposons également de carpes tranchées et filets de carpes goujonnettes pour vos repas \"carpes frites\". Le tout préparé frais chaque jour dans notre laboratoire de transformation.<br>Livraison possible dans le Haut-Rhin à convenir. <br>Téléphone : 03 89 25 62 32"
}

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

Licence Ouverte 2.0 (France / Etalab)Open

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

Full API documentation ↗

Rate limits

2 000 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

713

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.