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

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

APIQuery nowOpen workbench Subscribe🇫🇷France

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 API base URL Read the docs

Trust score

How is this computed?

poor

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

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