Register record·API·FRVERIFIED · checked 16h ago

C

COVID-19 Confinement N°2 : Commerces ouverts, autorisés à maintenir une activité en Alsace (CCI/CA)

Name: COVID-19 Confinement N°2 : Commerces ouverts, autorisés à maintenir une activité en Alsace (CCI/CA)
Creator: opendatasoft

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

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

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

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	—
—	mode_de_retraitMode de retrait	text	—
—	communeCommune	text	—
—	geopoint	geo_point_2d	—
—	code_inseeINSEE commune code	text	—
—	epci	text	—
—	code_epciCode epci	text	—
—	nometablissementNom de l'établissement	text	—
—	jourethoraireJours et horaires d'ouverture	text	—
—	ad_numnomrueAdresse de l'établissement	text	—
100%	drive	text	—
81.3%	contact_webSite internet	text	—
100%	approval_statusApproval status	int	—
96.9%	ad_lonAdresse de votre établissement Longitude	double	—
100%	livraison	text	—
99.1%	ad_codepostalCode postal	int	—
100%	ad_villeCommune (saisie)	text	—
60.3%	photoAjouter une photo	text	—
100%	siretNuméro SIRET	text	—
0%	ad_complementAdresse de votre établissement (Complément d'adresse)	text	—
0%	adresse_de_votre_etablissement_etat_provinceAdresse de votre établissement (État / Province)	text	—
100%	ad_paysAdresse de votre établissement (Pays)	text	—
96.6%	ndeg_de_telephoneN° de téléphone	text	—
95.9%	adresse_e_mail_de_contactAdresse e-mail	text	—
100%	info_complementaireSouhaitez-vous ajouter des informations complémentaires ?	text	—
49.1%	info_descriptionAjoutez les informations complémentaires	text	—
100%	entry_idEntry id	int	—
100%	entry_dateEntry date	datetime	—
0%	revision_parent_dateRevision parent date	text	—
0%	revision_date_gmtRevision date gmt	text	—
96.9%	ad_latAdresse de votre établissement Latitude	double	—

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 1epci: — · drive: Oui

{
  "epci": null,
  "drive": "Oui",
  "photo": "https://outils.ccimp.com/wp-content/uploads/gravity_forms/10-895df7c171ea2979e88b974bbebeddea/2020/11/IMG_8119.jpg",
  "siret": "329425102",
  "ad_lat": null,
  "ad_lon": null,
  "ad_pays": "France",
  "commune": null,
  "ad_ville": "SCHIRMECK",
  "entry_id": 27449,
  "geopoint": null,
  "code_epci": null,
  "livraison": "Oui",
  "code_insee": null,
  "entry_date": "2020-11-17T17:34:22+00:00",
  "contact_web": "http://www.meubles-marchal.fr",
  "ad_numnomrue": "ZA LE CHIMPY",
  "ad_codepostal": 67130,
  "ad_complement": null,
  "jourethoraire": "\"null\"",
  "approval_status": 3,
  "mode_de_retrait": [
    "Drive / Click&Collect",
    "Livraison"
  ],
  "secteuractivite": "Equipement de la maison",
  "info_description": null,
  "nometablissement": "meubles MARCHAL",
  "ndeg_de_telephone": "03.88.97.02.45",
  "revision_date_gmt": null,
  "info_complementaire": "Non",
  "revision_parent_date": null,
  "adresse_e_mail_de_contact": "meubles.marchal@wanadoo.fr",
  "adresse_de_votre_etablissement_etat_province": null
}

Record 2epci: — · drive: Oui

{
  "epci": null,
  "drive": "Oui",
  "photo": null,
  "siret": "32959733000102",
  "ad_lat": null,
  "ad_lon": null,
  "ad_pays": "France",
  "commune": null,
  "ad_ville": "Marmoutier",
  "entry_id": 27386,
  "geopoint": null,
  "code_epci": null,
  "livraison": "Non",
  "code_insee": null,
  "entry_date": "2020-11-17T16:36:31+00:00",
  "contact_web": "https://alsace-ensemble.com/wp/",
  "ad_numnomrue": "7 Rue de Saverne",
  "ad_codepostal": 67440,
  "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": 2,
  "mode_de_retrait": [
    "Drive / Click&Collect"
  ],
  "secteuractivite": "Equipement de la maison",
  "info_description": null,
  "nometablissement": "Centrakor Saverne",
  "ndeg_de_telephone": "03.88.71.42.71",
  "revision_date_gmt": null,
  "info_complementaire": "Non",
  "revision_parent_date": null,
  "adresse_e_mail_de_contact": "saverne@centrakor.fr",
  "adresse_de_votre_etablissement_etat_province": null
}

Record 3epci: CC du Pays de Barr · drive: Oui

{
  "epci": "CC du Pays de Barr",
  "drive": "Oui",
  "photo": "https://outils.ccimp.com/wp-content/uploads/gravity_forms/10-895df7c171ea2979e88b974bbebeddea/2020/11/cadre-cheminee-Supra.jpg",
  "siret": "419126727",
  "ad_lat": 48.3202075,
  "ad_lon": 7.4278461,
  "ad_pays": "France",
  "commune": "Dambach-la-Ville",
  "ad_ville": "Dambach-la-Ville",
  "entry_id": 27331,
  "geopoint": {
    "lat": 48.3202075,
    "lon": 7.4278461
  },
  "code_epci": "200034270",
  "livraison": "Oui",
  "code_insee": "67084",
  "entry_date": "2020-11-17T15:38:12+00:00",
  "contact_web": null,
  "ad_numnomrue": "2 RUE DU VIGNOBLE",
  "ad_codepostal": 67650,
  "ad_complement": null,
  "jourethoraire": "\"null\"",
  "approval_status": 1,
  "mode_de_retrait": [
    "Drive / Click&Collect",
    "Livraison"
  ],
  "secteuractivite": "Autre",
  "info_description": "Atelier d'émail sur pierre de lave, décoration intérieur et extérieur   ,plan de cuisine, plateau de table ,gravure ; le tout en pieces uniques ou sur commande;\r\nsur rdv par telelephone",
  "nometablissement": "SR INTEMPORALE",
  "ndeg_de_telephone": "0602319553",
  "revision_date_gmt": null,
  "info_complementaire": "Oui",
  "revision_parent_date": null,
  "adresse_e_mail_de_contact": "didier.esslinger@laposte.net",
  "adresse_de_votre_etablissement_etat_province": null
}

Record 4epci: Eurométropole de Strasbourg · drive: Oui

{
  "epci": "Eurométropole de Strasbourg",
  "drive": "Oui",
  "photo": "https://outils.ccimp.com/wp-content/uploads/gravity_forms/10-895df7c171ea2979e88b974bbebeddea/2020/11/Logo-E-boutique.jpg",
  "siret": "50018442900024",
  "ad_lat": 48.5201122,
  "ad_lon": 7.7015011,
  "ad_pays": "France",
  "commune": "Geispolsheim",
  "ad_ville": "Geispolsheim",
  "entry_id": 27055,
  "geopoint": {
    "lat": 48.5201122,
    "lon": 7.7015011
  },
  "code_epci": "246700488",
  "livraison": "Oui",
  "code_insee": "67152",
  "entry_date": "2020-11-17T11:24:44+00:00",
  "contact_web": "https://boutique.musee-du-chocolat.com/fr/",
  "ad_numnomrue": "Rue du Pont-du-Péage",
  "ad_codepostal": 67118,
  "ad_complement": null,
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"09:30\",\"fromtimelabel\":\"9 h 30 min\",\"totime\":\"17:30\",\"totimelabel\":\"17 h 30 min\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"09:30\",\"fromtimelabel\":\"9 h 30 min\",\"totime\":\"17:30\",\"totimelabel\":\"17 h 30 min\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"09:30\",\"fromtimelabel\":\"9 h 30 min\",\"totime\":\"17:30\",\"totimelabel\":\"17 h 30 min\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"09:30\",\"fromtimelabel\":\"9 h 30 min\",\"totime\":\"17:30\",\"totimelabel\":…",
  "approval_status": 1,
  "mode_de_retrait": [
    "Drive / Click&Collect",
    "Livraison"
  ],
  "secteuractivite": "Commerce alimentaire",
  "info_description": null,
  "nometablissement": "Les Secrets du Chocolat - La boutique",
  "ndeg_de_telephone": "0388550490",
  "revision_date_gmt": null,
  "info_complementaire": "Non",
  "revision_parent_date": null,
  "adresse_e_mail_de_contact": "reservation@musee-du-chocolat.com",
  "adresse_de_votre_etablissement_etat_province": null
}

Record 5epci: CC de l'Alsace Bossue · drive: Oui

{
  "epci": "CC de l'Alsace Bossue",
  "drive": "Oui",
  "photo": null,
  "siret": "67658025100012",
  "ad_lat": 48.9382247,
  "ad_lon": 7.1862077,
  "ad_pays": "France",
  "commune": "Diemeringen",
  "ad_ville": "DIEMERINGEN",
  "entry_id": 26987,
  "geopoint": {
    "lat": 48.9382247,
    "lon": 7.1862077
  },
  "code_epci": "200067841",
  "livraison": "Oui",
  "code_insee": "67095",
  "entry_date": "2020-11-17T10:10:27+00:00",
  "contact_web": "https://www.bigmat.fr/schmidtetcie/",
  "ad_numnomrue": "26 Grand Rue",
  "ad_codepostal": 67430,
  "ad_complement": null,
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"8 h 00 min\",\"totime\":\"12:00\",\"totimelabel\":\"12 h 00 min\"},{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"13:30\",\"fromtimelabel\":\"13 h 30 min\",\"totime\":\"18:00\",\"totimelabel\":\"18 h 00 min\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"13:30\",\"fromtimelabel\":\"13 h 30 min\",\"totime\":\"18:00\",\"totimelabel\":\"18 h 00 min\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"13:30\",\"fromtimelabel\":\"13 h 30 min\",\"totime\":\"18:00\",\"totimelabel\"…",
  "approval_status": 1,
  "mode_de_retrait": [
    "Drive / Click&Collect",
    "Livraison"
  ],
  "secteuractivite": "Équipement / Matériel",
  "info_description": "ouverture normale",
  "nometablissement": "Schmidt Ernest et cie",
  "ndeg_de_telephone": "+33388004220",
  "revision_date_gmt": null,
  "info_complementaire": "Oui",
  "revision_parent_date": null,
  "adresse_e_mail_de_contact": "contact@bigmat-schmidt.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

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

Full API documentation ↗

Rate limits

2 000 000 req/day

per ipmeasured

observed 6 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

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.

COVID-19 Confinement N°2 : Commerces ouverts, autorisés à maintenir une activité en Alsace (CCI/CA)

Trust score

Data schema (31 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