Register record·API·FRVERIFIED · checked 2d ago

C

COVID-19 : Lieux ouverts pendant le confinement en Alsace (OSM - ça reste ouvert)

Name: COVID-19 : Lieux ouverts pendant le confinement en Alsace (OSM - ça reste ouvert)
Creator: opendatasoft

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

Le jeu de données reprend les informations issues de la carte collaborative "ça reste ouvert" qui permet de partager les lieux ouvert ou fermés dans un quartier ou une commune : https://www.caresteouvert.fr/ Méthode de collecte et d'extraction Pour modifier les données, vous pouvez contribuer dir...

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

Data schema (52 fields)

Filterable via the API (51)

osm_idshopref_fr_finessaddr_housenumberdescription_covid19brand_websiteref_fr_sirenref_fr_siretaddr_streetaddr_cityaddr_postcodesource_opening_hours_covid19delivery_covid19emailtakeaway_covid19contact_emailopening_hours_covid19osm_typedrive_throughfull_idcontact_websitecontact_cityopening_hourscontact_phoneaddr_housenamenamewebsitecontact_housenumbersource_datephoneamenitycontact_postcodename_frcontact_streetdescriptionaddr_placeaddr_countrytakeawaytelephoneaddr_suburbdeliveryfacebooknote_covid19drive_through_covid19opening_hours_signedidosmlongitudelatitudesecteur_activitecommunesepci

Click a field to see example values.

Fill	Field	Type	Description
100%	osm_idOsm id	int	—
63.4%	shop	text	—
17%	ref_fr_finessRef fr finess	int	—
20.6%	addr_housenumberAddr housenumber	int	—
18.4%	description_covid19Description covid19	text	—
1.5%	brand_websiteBrand website	text	—
0%	ref_fr_sirenRef fr siren	text	—
14.3%	ref_fr_siretRef fr siret	int	—
20.6%	addr_streetAddr street	text	—
19.2%	addr_cityAddr city	text	—
20.9%	addr_postcodeAddr postcode	int	—
0.2%	source_opening_hours_covid19Source opening hours covid19	text	—
21.1%	delivery_covid19Delivery covid19	text	—
2.5%	email	text	—
19.2%	takeaway_covid19Takeaway covid19	text	—
2.9%	contact_emailContact email	text	—
100%	opening_hours_covid19Opening hours covid19	text	—
100%	osm_typeOsm type	text	—
1.7%	drive_throughDrive through	text	—
100%	full_idFull id	text	—
7.6%	contact_websiteContact website	text	—
10.8%	contact_cityContact city	text	—
31.4%	opening_hoursOpening hours	text	—
13%	contact_phoneContact phone	text	—
0.2%	addr_housenameAddr housename	text	—
93.6%	name	text	—
10.6%	website	text	—
10.6%	contact_housenumberContact housenumber	text	—
0.5%	source_dateSource date	text	—
16.7%	phone	text	—
35.6%	amenity	text	—
11.3%	contact_postcodeContact postcode	int	—
0.7%	name_frName fr	text	—
11.5%	contact_streetContact street	text	—
1.7%	description	text	—
0.2%	addr_placeAddr place	text	—
1.2%	addr_countryAddr country	text	—
3.4%	takeaway	text	—
0.5%	telephone	text	—
0%	addr_suburbAddr suburb	text	—
—	delivery	text	—
—	facebook	text	—
—	note_covid19Note covid19	text	—
—	drive_through_covid19Drive through covid19	text	—
—	opening_hours_signedOpening hours signed	text	—
—	idosm	int	—
—	longitudeLongitude	double	—
—	latitudeLatitude	double	—
—	geopoint	geo_point_2d	—
—	secteur_activiteSecteur activité	text	—
100%	communesCommune	text	—
100%	epci	text	—

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: CA de Haguenau · name: Norma

{
  "epci": "CA de Haguenau",
  "name": "Norma",
  "shop": "supermarket",
  "email": null,
  "idosm": 7,
  "phone": null,
  "osm_id": 7,
  "amenity": null,
  "full_id": "n4927048347",
  "name_fr": null,
  "website": null,
  "communes": "Schweighouse-sur-Moder",
  "delivery": null,
  "facebook": null,
  "geopoint": {
    "lat": 48.8304945,
    "lon": 7.7458691
  },
  "latitude": 48.8304945,
  "osm_type": "node",
  "takeaway": null,
  "addr_city": null,
  "longitude": 7.7458691,
  "telephone": null,
  "addr_place": null,
  "addr_street": null,
  "addr_suburb": null,
  "description": null,
  "source_date": null,
  "addr_country": null,
  "contact_city": null,
  "note_covid19": null,
  "ref_fr_siren": null,
  "ref_fr_siret": null,
  "addr_postcode": null,
  "brand_website": null,
  "contact_email": null,
  "contact_phone": null,
  "drive_through": null,
  "opening_hours": null,
  "ref_fr_finess": null,
  "addr_housename": null,
  "contact_street": null,
  "contact_website": null,
  "addr_housenumber": null,
  "contact_postcode": null,
  "delivery_covid19": null,
  "secteur_activite": "supermarket",
  "takeaway_covid19": null,
  "contact_housenumber": null,
  "description_covid19": null,
  "opening_hours_signed": null,
  "drive_through_covid19": null,
  "opening_hours_covid19": "open",
  "source_opening_hours_covid19": null
}

Record 2epci: CA Mulhouse Alsace Agglomération · name: Tabac-Presse Brasselet Hardy

{
  "epci": "CA Mulhouse Alsace Agglomération",
  "name": "Tabac-Presse Brasselet Hardy",
  "shop": "tobacco",
  "email": null,
  "idosm": 10,
  "phone": null,
  "osm_id": 10,
  "amenity": null,
  "full_id": "n4947608096",
  "name_fr": null,
  "website": null,
  "communes": "Ruelisheim",
  "delivery": null,
  "facebook": null,
  "geopoint": {
    "lat": 47.8224095,
    "lon": 7.3588498
  },
  "latitude": 47.8224095,
  "osm_type": "node",
  "takeaway": null,
  "addr_city": null,
  "longitude": 7.3588498,
  "telephone": null,
  "addr_place": null,
  "addr_street": null,
  "addr_suburb": null,
  "description": null,
  "source_date": null,
  "addr_country": null,
  "contact_city": null,
  "note_covid19": null,
  "ref_fr_siren": null,
  "ref_fr_siret": null,
  "addr_postcode": null,
  "brand_website": null,
  "contact_email": null,
  "contact_phone": null,
  "drive_through": null,
  "opening_hours": null,
  "ref_fr_finess": null,
  "addr_housename": null,
  "contact_street": null,
  "contact_website": null,
  "addr_housenumber": null,
  "contact_postcode": null,
  "delivery_covid19": null,
  "secteur_activite": "tobacco",
  "takeaway_covid19": null,
  "contact_housenumber": null,
  "description_covid19": null,
  "opening_hours_signed": null,
  "drive_through_covid19": null,
  "opening_hours_covid19": "open",
  "source_opening_hours_covid19": null
}

Record 3epci: CC Sauer-Pechelbronn · name: Chez Fred

{
  "epci": "CC Sauer-Pechelbronn",
  "name": "Chez Fred",
  "shop": "bakery",
  "email": null,
  "idosm": 13,
  "phone": null,
  "osm_id": 13,
  "amenity": null,
  "full_id": "n1340957364",
  "name_fr": null,
  "website": null,
  "communes": "Wœrth",
  "delivery": null,
  "facebook": null,
  "geopoint": {
    "lat": 48.9372992,
    "lon": 7.7442874
  },
  "latitude": 48.9372992,
  "osm_type": "node",
  "takeaway": null,
  "addr_city": null,
  "longitude": 7.7442874,
  "telephone": null,
  "addr_place": null,
  "addr_street": null,
  "addr_suburb": null,
  "description": null,
  "source_date": null,
  "addr_country": null,
  "contact_city": null,
  "note_covid19": null,
  "ref_fr_siren": null,
  "ref_fr_siret": null,
  "addr_postcode": null,
  "brand_website": null,
  "contact_email": null,
  "contact_phone": null,
  "drive_through": null,
  "opening_hours": "7/7 5h30-18h30",
  "ref_fr_finess": null,
  "addr_housename": null,
  "contact_street": null,
  "contact_website": null,
  "addr_housenumber": null,
  "contact_postcode": null,
  "delivery_covid19": null,
  "secteur_activite": "bakery",
  "takeaway_covid19": null,
  "contact_housenumber": null,
  "description_covid19": null,
  "opening_hours_signed": null,
  "drive_through_covid19": null,
  "opening_hours_covid19": "open",
  "source_opening_hours_covid19": null
}

Record 4epci: Eurométropole de Strasbourg · name: Carrefour City

{
  "epci": "Eurométropole de Strasbourg",
  "name": "Carrefour City",
  "shop": "supermarket",
  "email": null,
  "idosm": 14,
  "phone": null,
  "osm_id": 14,
  "amenity": null,
  "full_id": "n247840325",
  "name_fr": null,
  "website": null,
  "communes": "Strasbourg",
  "delivery": null,
  "facebook": null,
  "geopoint": {
    "lat": 48.5940767,
    "lon": 7.7197164
  },
  "latitude": 48.5940767,
  "osm_type": "node",
  "takeaway": null,
  "addr_city": null,
  "longitude": 7.7197164,
  "telephone": null,
  "addr_place": null,
  "addr_street": null,
  "addr_suburb": null,
  "description": null,
  "source_date": null,
  "addr_country": null,
  "contact_city": null,
  "note_covid19": null,
  "ref_fr_siren": null,
  "ref_fr_siret": null,
  "addr_postcode": null,
  "brand_website": null,
  "contact_email": null,
  "contact_phone": null,
  "drive_through": null,
  "opening_hours": null,
  "ref_fr_finess": null,
  "addr_housename": null,
  "contact_street": null,
  "contact_website": null,
  "addr_housenumber": null,
  "contact_postcode": null,
  "delivery_covid19": null,
  "secteur_activite": "supermarket",
  "takeaway_covid19": null,
  "contact_housenumber": null,
  "description_covid19": null,
  "opening_hours_signed": null,
  "drive_through_covid19": null,
  "opening_hours_covid19": "open",
  "source_opening_hours_covid19": null
}

Record 5epci: Eurométropole de Strasbourg · name: Bouchererie-charcuterie-traiteur Siegris

{
  "epci": "Eurométropole de Strasbourg",
  "name": "Bouchererie-charcuterie-traiteur Siegrist",
  "shop": "butcher",
  "email": null,
  "idosm": 18,
  "phone": null,
  "osm_id": 18,
  "amenity": null,
  "full_id": "n1353480919",
  "name_fr": null,
  "website": null,
  "communes": "Strasbourg",
  "delivery": null,
  "facebook": null,
  "geopoint": {
    "lat": 48.5688517,
    "lon": 7.7631537
  },
  "latitude": 48.5688517,
  "osm_type": "node",
  "takeaway": null,
  "addr_city": null,
  "longitude": 7.7631537,
  "telephone": null,
  "addr_place": null,
  "addr_street": null,
  "addr_suburb": null,
  "description": null,
  "source_date": null,
  "addr_country": null,
  "contact_city": null,
  "note_covid19": null,
  "ref_fr_siren": null,
  "ref_fr_siret": null,
  "addr_postcode": null,
  "brand_website": null,
  "contact_email": null,
  "contact_phone": null,
  "drive_through": null,
  "opening_hours": "Mo-Th 09:00-12:45,15:00-18:00, Fr 08:00-12:45,15:00-18:30, Sa 08:00-12:30",
  "ref_fr_finess": null,
  "addr_housename": null,
  "contact_street": null,
  "contact_website": null,
  "addr_housenumber": null,
  "contact_postcode": null,
  "delivery_covid19": null,
  "secteur_activite": "butcher",
  "takeaway_covid19": null,
  "contact_housenumber": null,
  "description_covid19": null,
  "opening_hours_signed": null,
  "drive_through_covid19": null,
  "opening_hours_covid19": "open",
  "source_opening_hours_covid19": 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-lieux-ouverts-pendant-le-confinement-osm-ca-reste-ouvert

License

Open Data Commons Open Database License 1.0Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/covid-19-lieux-ouverts-pendant-le-confinement-osm-ca-reste-ouvert/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

407

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.

COVID-19 : Lieux ouverts pendant le confinement en Alsace (OSM - ça reste ouvert)

Trust score

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