search

CSSEGISandData / COVID-19

Novel Coronavirus (COVID-19) Cases, provided by JHU CSSE
https://systems.jhu.edu/research/public-health/ncov/
29.14k stars 18.44k forks source link

Where is the data for the different states in the United States? #1652

Open RInterested opened 4 years ago

RInterested commented 4 years ago

The provinces in China and Canada, for example, are still accessible. But for the United States, there is only one row "US". Clearly the data by state is accessible through the map, but is Johns Hopkins making this information accessible only as a daily file for all US locations?

bfosten commented 4 years ago

The raw data for U.S. states is still in csse_covid_19_data/csse_covid_19_daily_reports, but it's not as easily accessible as it used to be.

To help ensure that it's always easily accessible, we've set up a new repo, CovidAPI. It provides the data from this Johns Hopkins repo but provides it in a stable format that includes daily statistics by states/provinces (see Regions).

RInterested commented 4 years ago

The raw data for U.S. states is still in csse_covid_19_data/csse_covid_19_daily_reports, but it's not as easily accessible as it used to be.

To help ensure that it's always easily accessible, we've set up a new repo, CovidAPI. It provides the data from this Johns Hopkins repo but provides it in a stable format that includes daily statistics by states/provinces (see Regions).

I can't find a compiled csv file in the CovidAPI, but I am not familiar with APIs.

bfosten commented 4 years ago

@RInterested Sorry that this wasn't clear; we'll try to improve that. Within the Regions section, there are links to CSVs, like regions/cases.csv and regions/deaths.csv. Each of these CSVs has cumulative counts per region per day.

bfosten commented 4 years ago

@RInterested I've updated the format of the README to add a new CSVs section that lists all of the CSVs, and there's a "Regions" section within it that has the CSVs with state-level data. (Some of the links in my previous comment will no longer work as a result.)

sibblegp commented 4 years ago

@CSSEGISandData Where is this data? It's extremely important.

jcampos8782 commented 4 years ago

See the pinned issue!!!: https://github.com/CSSEGISandData/COVID-19/issues/1250

The format is being changed and state level data will be available in separate files soon.

zacandereck commented 4 years ago

Why can't you aggregate by FIPS code? Leading two (2) digits (mind leading zero) in the US County FIPS code is the state identifier.

sibblegp commented 4 years ago

Their migration of data has gone absolutely disastrous. No backwards compatibility, poor design, failed to work with community, end of life-ing existing endpoints (CSVs), etc.. A first year computer science student would do better. Why is state level data not available yet? You went backwards in your feature set!

cipriancraciun commented 4 years ago

I have built a derived dataset based on JHU dataset, where (among other fixes and features) I also aggregate the data for US at both state and country level, and merge everything in a single dataset for easy usage:

(I try as much as possible not to change the format too much, mainly I only add new rows and columns.)