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)

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	Business activity sector of the establishment.Business activity sector of the establishment.
—	mode_de_retraitMode de retrait	text	Methods of order pickup offered, e.g. drive or delivery.Methods of order pickup offered, e.g. drive or delivery.
—	communeCommune	text	Name of the municipality where the business is located.Name of the municipality where the business is located.
—	geopoint	geo_point_2d	Geographic coordinates (latitude, longitude) of the business.Geographic coordinates (latitude, longitude) of the business.
—	code_inseeINSEE commune code	text	INSEE code identifying the municipality.INSEE code identifying the municipality.
—	epci	text	Name of the intermunicipal body (EPCI) the municipality belongs to.Name of the intermunicipal body (EPCI) the municipality belongs to.
—	code_epciCode epci	text	Code identifying the intermunicipal body (EPCI).Code identifying the intermunicipal body (EPCI).
—	geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude, longitude) of the business.Geographic coordinates (latitude, longitude) of the business.
—	geo_shapeShape	geo_shape	Geographic shape (point geometry) of the business location.Geographic shape (point geometry) of the business location.
—	ad_lonAd lon	text	Longitude of the business address.Longitude of the business address.
100%	nometablissement	text	Name of the business or establishment.Name of the business or establishment.
90.4%	jourethoraire	text	Opening days and hours of the business, in structured format.Opening days and hours of the business, in structured format.
100%	latitudeLatitude	text	Latitude of the business location.Latitude of the business location.
100%	ad_numnomrueAd numnomrue	text	Street number and name of the business address.Street number and name of the business address.
100%	idccica	text	Internal record identifier from the CCI/CA source.Internal record identifier from the CCI/CA source.
93.6%	drive	text	Indicates whether the business offers a drive-through service.Indicates whether the business offers a drive-through service.
100%	longitudeLongitude	text	Longitude of the business location.Longitude of the business location.
100%	ccica_idCcica id	text	Identifier assigned by the CCI/CA for this establishment.Identifier assigned by the CCI/CA for this establishment.
68.2%	contact_webContact web	text	Website URL for contacting the business.Website URL for contacting the business.
100%	date_entreeDate entree	text	Date and time the record was entered into the dataset.Date and time the record was entered into the dataset.
100%	approval_statusApproval status	text	Approval status code of the listing.Approval status code of the listing.
100%	ad_latAd lat	text	Latitude of the business address.Latitude of the business address.
100%	livraison	text	Indicates whether the business offers delivery service.Indicates whether the business offers delivery service.
100%	ad_codepostalAd codepostal	text	Postal code of the business address.Postal code of the business address.
100%	ad_villeAd ville	text	City or town of the business address.City or town of the business address.

Schema captured from opendatasoft 3 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 de la Vallée de la Doller et du Soult · drive: Non

{
  "epci": "CC de la Vallée de la Doller et du Soultzbach",
  "drive": "Non",
  "ad_lat": "47.7132011",
  "ad_lon": "7.1663346",
  "commune": "Burnhaupt-le-Bas",
  "idccica": "125",
  "ad_ville": "Burnhaupt-le-Bas",
  "ccica_id": "125",
  "geopoint": {
    "lat": 47.7132011,
    "lon": 7.1663346
  },
  "latitude": "47.7132011",
  "code_epci": "246800676",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.1663346,
        47.7132011
      ]
    },
    "properties": {}
  },
  "livraison": "Non",
  "longitude": "7.1663346",
  "code_insee": "68059",
  "contact_web": null,
  "date_entree": "24/04/2020 15:46",
  "ad_numnomrue": "3 Avenue de l'Europe",
  "geo_point_2d": {
    "lat": 47.7132011,
    "lon": 7.1663346
  },
  "ad_codepostal": "68520",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"10:00\",\"fromtimelabel\":\"10:00\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"15:00\",\"fromtimelabel\":\"15:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"10:00\",\"fromtimelabel\":\"10:00\",\"totime\":\"12:00\",\"totimelabel\":\"12:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"15:00\",\"fromtimelabel\":\"15:00\",\"totime\":\"18:00\",\"totimelabel\":\"18:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"me…",
  "approval_status": "1",
  "mode_de_retrait": null,
  "secteuractivite": "Producteur / Agriculteur",
  "nometablissement": "JARDINERIE TOURNESOL"
}

Record 2epci: CC Pays Rhin - Brisach · drive: Oui

{
  "epci": "CC Pays Rhin - Brisach",
  "drive": "Oui",
  "ad_lat": "48.0917843",
  "ad_lon": "7.5070727",
  "commune": "Durrenentzen",
  "idccica": "611",
  "ad_ville": "Durrenentzen",
  "ccica_id": "611",
  "geopoint": {
    "lat": 48.0917843,
    "lon": 7.5070727
  },
  "latitude": "48.0917843",
  "code_epci": "200066025",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.5070727,
        48.0917843
      ]
    },
    "properties": {}
  },
  "livraison": "Oui",
  "longitude": "7.5070727",
  "code_insee": "68076",
  "contact_web": "http://www.safranetoile.com/",
  "date_entree": "07/04/2020 22:05",
  "ad_numnomrue": "34B rue du Rhin",
  "geo_point_2d": {
    "lat": 48.0917843,
    "lon": 7.5070727
  },
  "ad_codepostal": "68320",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"17:00\",\"totimelabel\":\"17:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"17:00\",\"totimelabel\":\"17:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"17:00\",\"totimelabel\":\"17:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"17:00\",\"totimelabel\":\"17:00\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "approval_status": "1",
  "mode_de_retrait": [
    "Drive",
    "Livraison"
  ],
  "secteuractivite": "Producteur / Agriculteur",
  "nometablissement": "Safran étoilé"
}

Record 3epci: CC Sundgau · drive: Oui

{
  "epci": "CC Sundgau",
  "drive": "Oui",
  "ad_lat": "47.6722475",
  "ad_lon": "7.2653604",
  "commune": "Illfurth",
  "idccica": "1592",
  "ad_ville": "Illfurth",
  "ccica_id": "1592",
  "geopoint": {
    "lat": 47.6722475,
    "lon": 7.2653604
  },
  "latitude": "47.6722475",
  "code_epci": "200066041",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.2653604,
        47.6722475
      ]
    },
    "properties": {}
  },
  "livraison": "Oui",
  "longitude": "7.2653604",
  "code_insee": "68152",
  "contact_web": "https://www.facebook.com",
  "date_entree": "30/03/2020 10:31",
  "ad_numnomrue": "9 Route de Mulhouse",
  "geo_point_2d": {
    "lat": 47.6722475,
    "lon": 7.2653604
  },
  "ad_codepostal": "68720",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"17:00\",\"totimelabel\":\"17:00\"}]",
  "approval_status": "1",
  "mode_de_retrait": [
    "Drive",
    "Livraison"
  ],
  "secteuractivite": "Alimentaire",
  "nometablissement": "Etablissements Walger"
}

Record 4epci: CC du Kochersberg · drive: Non

{
  "epci": "CC du Kochersberg",
  "drive": "Non",
  "ad_lat": "48.6940002",
  "ad_lon": "7.5437352",
  "commune": "Rohr",
  "idccica": "375",
  "ad_ville": "Rohr",
  "ccica_id": "375",
  "geopoint": {
    "lat": 48.6940002,
    "lon": 7.5437352
  },
  "latitude": "48.6940002",
  "code_epci": "200034635",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.5437352,
        48.6940002
      ]
    },
    "properties": {}
  },
  "livraison": "Non",
  "longitude": "7.5437352",
  "code_insee": "67406",
  "contact_web": null,
  "date_entree": "13/04/2020 13:27",
  "ad_numnomrue": "31 Rue Principale",
  "geo_point_2d": {
    "lat": 48.6940002,
    "lon": 7.5437352
  },
  "ad_codepostal": "67270",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"19:00\",\"totimelabel\":\"19:00\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"19:00\",\"totimelabel\":\"19:00\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"19:00\",\"totimelabel\":\"19:00\"},{\"day\":\"Thursday\",\"daylabel\":\"jeu\",\"fromtime\":\"08:00\",\"fromtimelabel\":\"08:00\",\"totime\":\"19:00\",\"totimelabel\":\"19:00\"},{\"day\":\"Friday\",\"daylabel\":\"v…",
  "approval_status": "1",
  "mode_de_retrait": null,
  "secteuractivite": "Producteur / Agriculteur",
  "nometablissement": "EARL FRIESS"
}

Record 5epci: CC de l'Outre-Forêt · drive: Oui

{
  "epci": "CC de l'Outre-Forêt",
  "drive": "Oui",
  "ad_lat": "48.9278111",
  "ad_lon": "7.8972146",
  "commune": "Soultz-sous-Forêts",
  "idccica": "1059",
  "ad_ville": "SOULTZ-SOUS-FORÊTS",
  "ccica_id": "1059",
  "geopoint": {
    "lat": 48.9278111,
    "lon": 7.8972146
  },
  "latitude": "48.9278111",
  "code_epci": "200040178",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        7.8972146,
        48.9278111
      ]
    },
    "properties": {}
  },
  "livraison": "Non",
  "longitude": "7.8972146",
  "code_insee": "67474",
  "contact_web": "http://allo-informatique.eu",
  "date_entree": "04/04/2020 12:05",
  "ad_numnomrue": "6, Rue des Chênes - ZA du ROESSELBACH",
  "geo_point_2d": {
    "lat": 48.9278111,
    "lon": 7.8972146
  },
  "ad_codepostal": "67250",
  "jourethoraire": "[{\"day\":\"Monday\",\"daylabel\":\"lun\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:30\",\"totimelabel\":\"18:30\"},{\"day\":\"Tuesday\",\"daylabel\":\"mar\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:30\",\"totimelabel\":\"18:30\"},{\"day\":\"Wednesday\",\"daylabel\":\"mer\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:30\",\"totimelabel\":\"18:30\"},{\"day\":\"Friday\",\"daylabel\":\"ven\",\"fromtime\":\"09:00\",\"fromtimelabel\":\"09:00\",\"totime\":\"18:30\",\"totimelabel\":\"18:30\"},{\"day\":\"Saturday\",\"daylabel\":\"s…",
  "approval_status": "1",
  "mode_de_retrait": [
    "Drive"
  ],
  "secteuractivite": "Équipement",
  "nometablissement": "ALLO INFORMATIQUE Eurl"
}

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 3 days ago

Dataset

Volume & freshness

Records

1.7k

1692

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.