COVID-19: Shops Open and Authorised to Maintain Activity in Alsace (CCI/CA)COVID-19 : Commerces ouverts, autorisés à maintenir une activité en Alsace (CCI/CA)

Name: COVID-19: Shops Open and Authorised to Maintain Activity in Alsace (CCI/CA)
Creator: opendatasoft

COVID-19 : Commerces ouverts, autorisés à maintenir une activité en Alsace (CCI/CA)COVID-19: Shops Open and Authorised to Maintain Activity in Alsace (CCI/CA)

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This API lists businesses in the Alsace region authorised to keep operating during COVID-19-related restrictions on shops and stores. Published in connection with local chambers of commerce and agriculture (CCI/CA) and the city of Strasbourg's open data portal, it aims to give visibility to businesses that adapted their operations to the pandemic context, for example through specific opening hours or delivery and drive-through services. It supports residents in finding open businesses and helps municipalities and local organisations communicate available commercial services during the health crisis in the Alsace area.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

Trust score

How is this computed?

fair

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

Data schema (25 fields)

Filterable via the API (22)

secteuractivitemode_de_retraitcommunecode_inseeepcicode_epciad_lonnometablissementjourethorairelatitudead_numnomrueidccicadrivelongitudeccica_idcontact_webdate_entreeapproval_statusad_latlivraisonad_codepostalad_ville

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	—
—	geo_point_2dGeo Point	geo_point_2d	—
—	geo_shapeShape	geo_shape	—
—	ad_lonAd lon	text	—
100%	nometablissement	text	—
90.4%	jourethoraire	text	—
100%	latitudeLatitude	text	—
100%	ad_numnomrueAd numnomrue	text	—
100%	idccica	text	—
93.6%	drive	text	—
100%	longitudeLongitude	text	—
100%	ccica_idCcica id	text	—
68.2%	contact_webContact web	text	—
100%	date_entreeDate entree	text	—
100%	approval_statusApproval status	text	—
100%	ad_latAd lat	text	—
100%	livraison	text	—
100%	ad_codepostalAd codepostal	text	—
100%	ad_villeAd ville	text	—

Schema captured from opendatasoft 7 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: Eurométropole de Strasbourg · drive: Oui

{
  "epci": "Eurométropole de Strasbourg",
  "drive": "Oui",
  "ad_lat": "48.5843352",
  "ad_lon": "7.7511902",
  "commune": "Strasbourg",
  "idccica": "1118",
  "ad_ville": "Strasbourg",
  "ccica_id": "1118",
  "geopoint": {
    "lat": 48.5843352,
    "lon": 7.7511902
  },
  "latitude": "48.5843352",
  "code_epci": "246700488",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.7511902,
        48.5843352
      ]
    },
    "properties": {}
  },
  "livraison": "Oui",
  "longitude": "7.7511902",
  "code_insee": "67482",
  "contact_web": "https://www.erithajchocolat.com",
  "date_entree": "03/04/2020 18:38",
  "ad_numnomrue": "6 Rue Brûlée",
  "geo_point_2d": {
    "lat": 48.5843352,
    "lon": 7.7511902
  },
  "ad_codepostal": "67000",
  "jourethoraire": "[]",
  "approval_status": "1",
  "mode_de_retrait": [
    "Drive",
    "Livraison"
  ],
  "secteuractivite": "Alimentaire",
  "nometablissement": "ERITHAJ Chocolat"
}

Record 2epci: CA Colmar Agglomération · drive: —

{
  "epci": "CA Colmar Agglomération",
  "drive": null,
  "ad_lat": "48.072418",
  "ad_lon": "7.2921952",
  "commune": "Wintzenheim",
  "idccica": "1122",
  "ad_ville": "WINTZENHEIM",
  "ccica_id": "1122",
  "geopoint": {
    "lat": 48.072418,
    "lon": 7.2921952
  },
  "latitude": "48.072418",
  "code_epci": "246800726",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.2921952,
        48.072418
      ]
    },
    "properties": {}
  },
  "livraison": "Non",
  "longitude": "7.2921952",
  "code_insee": "68374",
  "contact_web": "http://www.boucherie-charcuterie-traiteur-florentz.com",
  "date_entree": "03/04/2020 18:27",
  "ad_numnomrue": "2 rue Etroite",
  "geo_point_2d": {
    "lat": 48.072418,
    "lon": 7.2921952
  },
  "ad_codepostal": "68920",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"07:30\",\"fromtimelabel\":\"07:30\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "approval_status": "1",
  "mode_de_retrait": null,
  "secteuractivite": "Alimentaire",
  "nometablissement": "Boucherie FLORENTZ"
}

Record 3epci: CC de la Région de Guebwiller · drive: Oui

{
  "epci": "CC de la Région de Guebwiller",
  "drive": "Oui",
  "ad_lat": "47.906585",
  "ad_lon": "7.2144574",
  "commune": "Guebwiller",
  "idccica": "1152",
  "ad_ville": "Guebwiller",
  "ccica_id": "1152",
  "geopoint": {
    "lat": 47.906585,
    "lon": 7.2144574
  },
  "latitude": "47.906585",
  "code_epci": "246800569",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.2144574,
        47.906585
      ]
    },
    "properties": {}
  },
  "livraison": "Non",
  "longitude": "7.2144574",
  "code_insee": "68112",
  "contact_web": "https://www.facebook.com/brknfd/posts/notre-menu/971142626321139/",
  "date_entree": "03/04/2020 17:07",
  "ad_numnomrue": "3 rue de la République",
  "geo_point_2d": {
    "lat": 47.906585,
    "lon": 7.2144574
  },
  "ad_codepostal": "68500",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"18:00\",\"fromtimelabel\":\"18:00\",\"totime\":\"22:00\",\"totimelabel\":\"22:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"18:00\",\"fromtimelabel\":\"18:00\",\"totime\":\"22:00\",\"totimelabel\":\"22:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"18:00\",\"fromtimelabel\":\"18:00\",\"totime\":\"22:00\",\"totimelabel\":\"22:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"18:00\",\"fromtimelabel\":\"18:00\",\"totime\":\"22:00\",\"totimelabel\":\"22:00\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "approval_status": "1",
  "mode_de_retrait": [
    "Drive"
  ],
  "secteuractivite": "Alimentaire",
  "nometablissement": "Break N Food"
}

Record 4epci: CC Sud Alsace Largue · drive: Non

{
  "epci": "CC Sud Alsace Largue",
  "drive": "Non",
  "ad_lat": "47.6311067",
  "ad_lon": "7.1177916",
  "commune": "Dannemarie",
  "idccica": "1179",
  "ad_ville": "DANNEMARIE",
  "ccica_id": "1179",
  "geopoint": {
    "lat": 47.6311067,
    "lon": 7.1177916
  },
  "latitude": "47.6311067",
  "code_epci": "200066033",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.1177916,
        47.6311067
      ]
    },
    "properties": {}
  },
  "livraison": "Non",
  "longitude": "7.1177916",
  "code_insee": "68068",
  "contact_web": "https://www.magasins-u.com/magasin/superu-dannemarie?xtor=SEC-5-GOO-[Magasinsu-Enseignes-non-drive]-[0]-0-[0]&gclid=EAIaIQobChMIgvK08qPM6AIVSETTCh0smQb_EAAYASAAEgLBC_D_BwE",
  "date_entree": "03/04/2020 14:03",
  "ad_numnomrue": "8 RUE ST LEONARD",
  "geo_point_2d": {
    "lat": 47.6311067,
    "lon": 7.1177916
  },
  "ad_codepostal": "68210",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "approval_status": "1",
  "mode_de_retrait": null,
  "secteuractivite": "Alimentaire",
  "nometablissement": "SUPER U"
}

Record 5epci: CC Sud Alsace Largue · drive: Oui

{
  "epci": "CC Sud Alsace Largue",
  "drive": "Oui",
  "ad_lat": "47.6310209",
  "ad_lon": "7.1267233",
  "commune": "Dannemarie",
  "idccica": "1187",
  "ad_ville": "DANNEMARIE",
  "ccica_id": "1187",
  "geopoint": {
    "lat": 47.6310209,
    "lon": 7.1267233
  },
  "latitude": "47.6310209",
  "code_epci": "200066033",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.1267233,
        47.6310209
      ]
    },
    "properties": {}
  },
  "livraison": "Non",
  "longitude": "7.1267233",
  "code_insee": "68068",
  "contact_web": "http://www.alsaterr.com",
  "date_entree": "03/04/2020 12:16",
  "ad_numnomrue": "46 B RUE DE BALE",
  "geo_point_2d": {
    "lat": 47.6310209,
    "lon": 7.1267233
  },
  "ad_codepostal": "68210",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"08:30\",\"fromtimelabel\":\"08:30\",\"totime\":\"17:30\",\"totimelabel\":\"17:30\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"08:30\",\"fromtimelabel\":\"08:30\",\"totime\":\"17:30\",\"totimelabel\":\"17:30\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"08:30\",\"fromtimelabel\":\"08:30\",\"totime\":\"17:30\",\"totimelabel\":\"17:30\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"08:30\",\"fromtimelabel\":\"08:30\",\"totime\":\"17:30\",\"totimelabel\":\"17:30\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "approval_status": "1",
  "mode_de_retrait": [
    "Drive"
  ],
  "secteuractivite": "Équipement",
  "nometablissement": "ALSATERR SARL"
}

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/commerces_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/commerces_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 7 days ago

Dataset

Volume & freshness

Records

1.7k

1692

Last upstream update

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