List of French Hospitals and Health Clinics
There might not be a database covering all french hospital. So if we need more data that OpenStreetMap ha - Below is the data for France. The French government has created a website showing the list of all 4307 hospitals and clinics in France:
Click on "Voir la liste des établissements" to get the full list.
You will need to scrape that. Each hospital name has a link to its detailed information page:
I have just sent them a message asking for a dump of the data. They replied to me saying that all of their data comes from the FINESS database, which is also maintained by the French government, and available online "for private use" and unfortunately does not have dump downloads, so that would mean scraping that:
what is aimed; i want to have a full list of the dataset.
The private API returns the full list of establishments along with their "id" numbers in JSON format.This is a great approach; This is the full list. We can use the "id" number of each organization to look up the "details" page for each organization. So, using the route to the "details" page: https://www.scopesante.fr#/etablissements/PUT_ID_NUMBER_HERE/fiche-detaillee/
We can get the details for a specific establishment directly by calling the API. See: https://ws.scopesante.fr/v4/fiche-identite/010000024
This returns the details on the specific establishment. We can replace the number on the end of the URL with the "id" number of the establishment you are looking up. Using an API is usually more efficient than scraping the pages directly.
We have for example the follwing ending of a URL
This number is also visible in the overview see the https://ws.scopesante.fr/v4/carte-etablissements
So I have to do some combination:
The question is - how to retrieve the full dataset of the approx 4000 records ?
I guess that the key is
b. processing of JSON-data and
c. creating a db that stores the whole dataset
Now I want to have a closer look at the decoding with
json_decode() - as with every JSON API.
Many thanks for your help here.