New fields must be added to understand the crisis

[JiPiBi]

The 3 values we have to understand the crisis are not sufficient : Confirmed - Deceased - Recovered

As many countries discover often too late , the real issue is to count the hospitalized people and the people put in ICU
Worldometers give the ICU value
Official Italian and French sites give these 2 values at a region level ( In France at the Departement level)

It's time to change

[JiPiBi]

Worldometers

[JiPiBi]

French data

rea = ICU
rad = recovered

[JiPiBi]

Italian data

[cipriancraciun]

Can someone point to a machine-readable (and reliable) dataset?

(I have already augmented the JHU dataset as described in #1281, and I could add these values to that.)

[JiPiBi]

For Italy : link this well known site
https://github.com/pcm-dpc/COVID-19

For France :
https://github.com/opencovid19-fr/data
in this repo : folder dist gives in one file data at different level of granularity
there is an english read.me to explain the data with english translation of the fields

Good work !

[cipriancraciun]

@JiPiBi unless people start standardizing on a particular data-format (I mean a JSON or TSV schema), merging all these datasets will be a nightmare.

For example in order to merge, clean and augment the JHU dataset it took me about 3 full work-days. (And the raw data was already available in a single semi-consistent format...)

[cipriancraciun]

@JiPiBi the repository for Italy that you've pointed at (https://github.com/pcm-dpc/COVID-19/) looks reasonable enough (although it would have helped if the fields and description would have been in English...) (Perhaps if I have the time and energy I'll integrate it in my dataset.)

BTW, is this an official dataset? (I.e. the ones that publish it are the italian authorities, or this is a volunteer project?)

(In order to augment that data I would also need a dataset with the population of each province / county. Do you know of an official one? Or, like in the case of US, I'll have to scrape Wikipedia...) :)

[hamedmh]

Hi, reg. the Italian dataset, the source is included in the repo as pdf-files.

[michim321]

Hi! I totally second this request! I also would like to see the data broken down by # hospitalizations (regular + ICU). @cipriancraciun the Italian data comes from the official source (Interior Ministry) and it's been really useful to me to understand trends/gravity of each individual category.
I hope this is possible to obtain at the state level, eventually, before hospitals go totally insane.

THANK YOU

[JiPiBi]

No reaction of JHU . But the issue in the real world remains
I close