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 Answers 2

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, 2021 at 11:07
  • Perfect data source. Well organized, clear. Thumb ups to the swisses! Feb 8, 2021 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. Feb 8, 2021 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, 2021 at 17:48
  • Maybe ask the Risklayer people directly? There are "Get in touch" links in the page footer.
    – knb
    Feb 8, 2021 at 17:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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