Register record·API·FRVERIFIED · checked 2d ago
C
COVID-19 Lockdown No. 2: Shops Open and Authorised to Maintain Activity in Alsace (CCI/CA)COVID-19 Confinement N°2 : Commerces ouverts, autorisés à maintenir une activité en Alsace (CCI/CA)
COVID-19 Confinement N°2 : Commerces ouverts, autorisés à maintenir une activité en Alsace (CCI/CA)COVID-19 Lockdown No. 2: Shops Open and Authorised to Maintain Activity in Alsace (CCI/CA)
This API lists businesses in the Alsace region authorised to remain open or maintain activity during the second COVID-19 lockdown in France, compiled from Chamber of Commerce and Industry (CCI) and Chamber of Agriculture (CA) sources. It aims to give visibility to shops and companies that adapted their operations to the restrictions, for example through specific opening hours or delivery and drive-through services. Published via the Strasbourg open-data portal, it provides a national-scope dataset at the time of the second lockdown, useful for locating accessible local businesses during the period.Contexte Dans le cadre des restrictions d’ouverture de commerces et magasins, nous souhaitons: Donner de la visibilité aux entreprises qui sont dans la capacité de maintenir leur activité en l’ayant adapté au contexte (horaires spécifiques, mise en place d’un service de livraison/drive) Permettre...
Trust score
How is this computed?42
fair
Weighted across five axes. Tap a ring for what it measures.
Data schema (31 fields)
Filterable via the API (30)
secteuractivitemode_de_retraitcommunecode_inseeepcicode_epcinometablissementjourethorairead_numnomruedrivecontact_webapproval_statusad_lonlivraisonad_codepostalad_villephotosiretad_complementadresse_de_votre_etablissement_etat_provincead_paysndeg_de_telephoneadresse_e_mail_de_contactinfo_complementaireinfo_descriptionentry_identry_daterevision_parent_daterevision_date_gmtad_lat
Click a field to see example values.
| Fill | Field | Type | Description |
|---|---|---|---|
| — | secteuractiviteSecteur d'activité | text | Business sector of the establishment.Business sector of the establishment. |
| — | mode_de_retraitMode de retrait | text | Methods offered for order pickup or delivery.Methods offered for order pickup or delivery. |
| — | communeCommune | text | Municipality where the establishment is located.Municipality where the establishment is located. |
| — | geopoint | geo_point_2d | Geographic coordinates of the establishment.Geographic coordinates of the establishment. |
| — | code_inseeINSEE commune code | text | INSEE code of the municipality.INSEE code of the municipality. |
| — | epci | text | Name of the inter-municipal authority (EPCI).Name of the inter-municipal authority (EPCI). |
| — | code_epciCode epci | text | Code identifying the inter-municipal authority (EPCI).Code identifying the inter-municipal authority (EPCI). |
| — | nometablissementNom de l'établissement | text | Name of the business establishment.Name of the business establishment. |
| — | jourethoraireJours et horaires d'ouverture | text | Opening days and hours, in structured format.Opening days and hours, in structured format. |
| — | ad_numnomrueAdresse de l'établissement | text | Street number and name of the establishment's address.Street number and name of the establishment's address. |
| 100% | drive | text | Indicates whether a drive-through service is available.Indicates whether a drive-through service is available. |
| 81.3% | contact_webSite internet | text | Website URL of the establishment.Website URL of the establishment. |
| 100% | approval_statusApproval status | int | Validation status of the submitted entry.Validation status of the submitted entry. |
| 96.9% | ad_lonAdresse de votre établissement Longitude | double | Longitude of the establishment's address.Longitude of the establishment's address. |
| 100% | livraison | text | Indicates whether home delivery is offered.Indicates whether home delivery is offered. |
| 99.1% | ad_codepostalCode postal | int | Postal code of the establishment's address.Postal code of the establishment's address. |
| 100% | ad_villeCommune (saisie) | text | City entered for the establishment's address.City entered for the establishment's address. |
| 60.3% | photoAjouter une photo | text | Photo file or upload status for the establishment.Photo file or upload status for the establishment. |
| 100% | siretNuméro SIRET | text | SIRET business registration number of the establishment.SIRET business registration number of the establishment. |
| 0% | ad_complementAdresse de votre établissement (Complément d'adresse) | text | Additional address details for the establishment.Additional address details for the establishment. |
| 0% | adresse_de_votre_etablissement_etat_provinceAdresse de votre établissement (État / Province) | text | State or province of the establishment's address.State or province of the establishment's address. |
| 100% | ad_paysAdresse de votre établissement (Pays) | text | Country of the establishment's address.Country of the establishment's address. |
| 96.6% | ndeg_de_telephoneN° de téléphone | text | Contact phone number of the establishment.Contact phone number of the establishment. |
| 95.9% | adresse_e_mail_de_contactAdresse e-mail | text | Contact email address of the establishment.Contact email address of the establishment. |
| 100% | info_complementaireSouhaitez-vous ajouter des informations complémentaires ? | text | Indicates whether additional information was provided.Indicates whether additional information was provided. |
| 49.1% | info_descriptionAjoutez les informations complémentaires | text | Additional information text about the establishment.Additional information text about the establishment. |
| 100% | entry_idEntry id | int | Unique identifier of the submitted entry.Unique identifier of the submitted entry. |
| 100% | entry_dateEntry date | datetime | Date and time the entry was submitted.Date and time the entry was submitted. |
| 0% | revision_parent_dateRevision parent date | text | Date of the parent revision of the entry.Date of the parent revision of the entry. |
| 0% | revision_date_gmtRevision date gmt | text | Date and time of the entry's revision, in GMT.Date and time of the entry's revision, in GMT. |
| 96.9% | ad_latAdresse de votre établissement Latitude | double | Latitude of the establishment's address.Latitude of the establishment's address. |
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.
=
Sample data (5 records)
Record 1epci: CC Pays Rhin - Brisach · drive: Oui
{
"epci": "CC Pays Rhin - Brisach",
"drive": "Oui",
"photo": null,
"siret": "32959733000706",
"ad_lat": 48.0104537,
"ad_lon": 7.5409912,
"ad_pays": "France",
"commune": "Volgelsheim",
"ad_ville": "Volgelsheim",
"entry_id": 23243,
"geopoint": {
"lat": 48.0104537,
"lon": 7.5409912
},
"code_epci": "200066025",
"livraison": "Non",
"code_insee": "68352",
"entry_date": "2020-11-12T11:55:39+00:00",
"contact_web": "http://www.vima.fr",
"ad_numnomrue": "1 Rue du Pourquoi Pas",
"ad_codepostal": 68600,
"ad_complement": null,
"jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"13:00\",\"fromtimelabel\":\"13 h 00 min\",\"totime\":\"18:00\",\"totimelabel\":\"18 h 00 min\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"13:00\",\"fromtimelabel\":\"13 h 00 min\",\"totime\":\"18:00\",\"totimelabel\":\"18 h 00 min\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"13:00\",\"fromtimelabel\":\"13 h 00 min\",\"totime\":\"18:00\",\"totimelabel\":\"18 h 00 min\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"13:00\",\"fromtimelabel\":\"13 h 00 min\",\"totime\":\"18:00\",\"totimelab…",
"approval_status": 1,
"mode_de_retrait": [
"Drive / Click&Collect"
],
"secteuractivite": "Équipement",
"info_description": null,
"nometablissement": "Centrale Internationale de Distribution Volgelsheim",
"ndeg_de_telephone": "03.88.27.98.98",
"revision_date_gmt": null,
"info_complementaire": "Non",
"revision_parent_date": null,
"adresse_e_mail_de_contact": "volgelsheim@centrakor.fr",
"adresse_de_votre_etablissement_etat_province": null
}Record 2epci: Eurométropole de Strasbourg · drive: Oui
{
"epci": "Eurométropole de Strasbourg",
"drive": "Oui",
"photo": "FAILED (Temporary file could not be moved.)",
"siret": "81414246900018",
"ad_lat": 48.5816,
"ad_lon": 7.7430699,
"ad_pays": "France",
"commune": "Strasbourg",
"ad_ville": "Strasbourg",
"entry_id": 16206,
"geopoint": {
"lat": 48.5816,
"lon": 7.7430699
},
"code_epci": "246700488",
"livraison": "Non",
"code_insee": "67482",
"entry_date": "2020-11-05T11:10:05+00:00",
"contact_web": "http://lafrituur.be/commande/",
"ad_numnomrue": "92 Grand'Rue",
"ad_codepostal": 67000,
"ad_complement": null,
"jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"11:30\",\"fromtimelabel\":\"11 h 30 min\",\"totime\":\"14:00\",\"totimelabel\":\"14 h 00 min\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"11:30\",\"fromtimelabel\":\"11 h 30 min\",\"totime\":\"14:00\",\"totimelabel\":\"14 h 00 min\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"11:30\",\"fromtimelabel\":\"11 h 30 min\",\"totime\":\"14:00\",\"totimelabel\":\"14 h 00 min\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"11:30\",\"fromtimelabel\":\"11 h 30 min\",\"totime\":\"14:00\",\"totimelab…",
"approval_status": 1,
"mode_de_retrait": [
"Drive / Click&Collect"
],
"secteuractivite": "Restaurant",
"info_description": null,
"nometablissement": "La Frituur",
"ndeg_de_telephone": "0388233150",
"revision_date_gmt": null,
"info_complementaire": "Non",
"revision_parent_date": null,
"adresse_e_mail_de_contact": "contact@lafrituur.be",
"adresse_de_votre_etablissement_etat_province": null
}Record 3epci: Eurométropole de Strasbourg · drive: Non
{
"epci": "Eurométropole de Strasbourg",
"drive": "Non",
"photo": null,
"siret": "38898358700055",
"ad_lat": 48.6045584,
"ad_lon": 7.7591685,
"ad_pays": "France",
"commune": "Schiltigheim",
"ad_ville": "Schiltigheim",
"entry_id": 20339,
"geopoint": {
"lat": 48.6045584,
"lon": 7.7591685
},
"code_epci": "246700488",
"livraison": "Non",
"code_insee": "67447",
"entry_date": "2020-11-09T12:42:01+00:00",
"contact_web": "https://strasbourg-nord-palais-des-congres.kyriad.com/fr-fr/",
"ad_numnomrue": "6 AVENUE PIERRE MENDES FRANCE",
"ad_codepostal": 67300,
"ad_complement": null,
"jourethoraire": "\"null\"",
"approval_status": 1,
"mode_de_retrait": null,
"secteuractivite": "Hébergement",
"info_description": null,
"nometablissement": "HOTEL KYRIAD STRASBOURG NORD PALAIS DES CONGRES",
"ndeg_de_telephone": "0388812444",
"revision_date_gmt": null,
"info_complementaire": "Non",
"revision_parent_date": null,
"adresse_e_mail_de_contact": "manager.strasbourg.pdc@kyriad.fr",
"adresse_de_votre_etablissement_etat_province": null
}Record 4epci: Eurométropole de Strasbourg · drive: Oui
{
"epci": "Eurométropole de Strasbourg",
"drive": "Oui",
"photo": null,
"siret": "78692030600986",
"ad_lat": 48.6404434,
"ad_lon": 7.7102896,
"ad_pays": "France",
"commune": "Mundolsheim",
"ad_ville": "Mundolsheim",
"entry_id": 20111,
"geopoint": {
"lat": 48.6404434,
"lon": 7.7102896
},
"code_epci": "246700488",
"livraison": "Oui",
"code_insee": "67309",
"entry_date": "2020-11-09T10:31:21+00:00",
"contact_web": "https://www.cora.fr/strasbourg",
"ad_numnomrue": "RM 63 - BP 91074",
"ad_codepostal": null,
"ad_complement": null,
"jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"08:30\",\"fromtimelabel\":\"8 h 30 min\",\"totime\":\"21:00\",\"totimelabel\":\"21 h 00 min\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"08:30\",\"fromtimelabel\":\"8 h 30 min\",\"totime\":\"21:00\",\"totimelabel\":\"21 h 00 min\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"08:30\",\"fromtimelabel\":\"8 h 30 min\",\"totime\":\"21:00\",\"totimelabel\":\"21 h 00 min\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"08:30\",\"fromtimelabel\":\"8 h 30 min\",\"totime\":\"21:00\",\"totimelabel\":…",
"approval_status": 1,
"mode_de_retrait": [
"Drive / Click&Collect",
"Livraison"
],
"secteuractivite": "Alimentaire",
"info_description": "Click and collect des produits non essentiels.",
"nometablissement": "cora Mundo'",
"ndeg_de_telephone": "03.88.20.96.96",
"revision_date_gmt": null,
"info_complementaire": "Oui",
"revision_parent_date": null,
"adresse_e_mail_de_contact": "st@cora.fr",
"adresse_de_votre_etablissement_etat_province": null
}Record 5epci: CC du Canton d'Erstein · drive: Oui
{
"epci": "CC du Canton d'Erstein",
"drive": "Oui",
"photo": null,
"siret": "53919528900027",
"ad_lat": 48.420762,
"ad_lon": 7.6512373,
"ad_pays": "France",
"commune": "Erstein",
"ad_ville": "ERSTEIN",
"entry_id": 24225,
"geopoint": {
"lat": 48.420762,
"lon": 7.6512373
},
"code_epci": "200067924",
"livraison": "Oui",
"code_insee": "67130",
"entry_date": "2020-11-13T10:27:04+00:00",
"contact_web": "https://www.cyclesscoots67.fr",
"ad_numnomrue": "29 A AVENUE DE LA GARE",
"ad_codepostal": 67150,
"ad_complement": null,
"jourethoraire": "[{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"9 h 00 min\",\"totime\":\"18:30\",\"totimelabel\":\"18 h 30 min\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"9 h 00 min\",\"totime\":\"18:30\",\"totimelabel\":\"18 h 30 min\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"9 h 00 min\",\"totime\":\"18:30\",\"totimelabel\":\"18 h 30 min\"},{\"day\":\"Friday\",\"daylabel\":\"ven\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"9 h 00 min\",\"totime\":\"18:30\",\"totimelabel\":…",
"approval_status": 1,
"mode_de_retrait": [
"Drive / Click&Collect",
"Livraison"
],
"secteuractivite": "Autre",
"info_description": null,
"nometablissement": "CYCLES SCOOTS 67",
"ndeg_de_telephone": "0388981313",
"revision_date_gmt": null,
"info_complementaire": "Non",
"revision_parent_date": null,
"adresse_e_mail_de_contact": "cycles.scoots.67@hotmail.fr",
"adresse_de_votre_etablissement_etat_province": 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-confinement-2-commerces-ouverts-autorises-a-maintenir-une-activite
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/covid-19-confinement-2-commerces-ouverts-autorises-a-maintenir-une-activite/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
2 000 000 req/day
per ipmeasured
observed 2 days ago
Dataset
Volume & freshness
Records
686
Last upstream update
6 years ago
2020-11-18
License
No license declared upstream.
○ Documentation○ Data dictionary○ Versioning
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.