1

I am looking for the regionalized historical covid 19 data for western european countries, especially the number of hospitalization.

By regionalized, I mean for each subdivision of a given country (lander for germany for example).

By historical, I mean data for, ideally, every day since last march.

By western european I mean Germany, Italy, Switzerland, Spain and Portugal mainly.

France already have precise historical data per departements: https://www.data.gouv.fr/fr/datasets/r/63352e38-d353-4b54-bfd1-f1b3ee1cabd7 (from https://www.data.gouv.fr/fr/datasets/donnees-relatives-aux-resultats-des-tests-virologiques-covid-19/). I would like the equivalent for the aforementioned countries.

6
2

Switzerland's COVID hospitalizations are available from the federal government:

https://www.covid19.admin.ch/en/epidemiologic/hosp

In the footer of the page, you'll see download links for raw data (csv or json)

csv and json downloads

The hospitalizations are available across 4 files, depending on which dimensions you'd like to see the data (age, gender, etc). If you browse the data on the website above, the naming of fields will be more clear.

csv examples of swiss covid hospitalization data


The URLs of the zipped json and csv archives have unique hashes when they are updated. But with some curl-magic you can fetch the newest version:

curl -o covid19-data.zip https://www.covid19.admin.ch` \
  curl -s https://www.covid19.admin.ch/en/ \
    | grep -o '"[^"]*sources-json.zip"' \
    | cut -d '"' -f 2`

source: https://gist.github.com/rkaravia/36e461305bed8cf3fb62be4ea61c3325

2
  • BTW - with CH and all its regions, you also get FL ;) – philshem Feb 8 at 11:07
  • Perfect data source. Well organized, clear. Thumb ups to the swisses! – Luke Skywalker Feb 8 at 18:40
0

For some countries you've already got links in comments, so here is an answer for Germany.

For Germany, you can get visualization on County-Level from the Risklayer website, which is maintained by CEDIM GmbH, a spin-off from KIT, a large, publicly-funded research institute.

If you scroll down, or search for "Crowdsourcing", on that page, you'll find a link to a Google Sheet that relies on, well, crowdsourced data.
(At the time I am writing this, 28 people are accessing that document).

Note that this Google sheet has many subsheets. One of them is "Länder" and it contains, for instance, the number of intensive-care units occupied. The number of hospitalizations is probably correlated, but difficult to measure.

3
  • Unless I am mistaken these are not historical data. They are the current status of things. The panel "curve" have historical data but they are not split on lander. I don't speak german so I may have missed something. – Luke Skywalker Feb 8 at 16:41
  • I simply assumed that the historial data is also in the Google Sheet. Both countrywide newspapers "Tagesspiegel" and "Berliner Morgenpost" use these data in their respective interactive visualisations. At least they say so in their sources sections ("Quellen"). – knb Feb 8 at 17:48
  • Maybe ask the Risklayer people directly? There are "Get in touch" links in the page footer. – knb Feb 8 at 17:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.