Covid-19 USA Dataset (21/01/2020 To 25/07/2020)
Number of Covid-19 cases in USA
@kaggle.soumyasacharya_covid19_usa_dataset_21012020_to_25072020
Number of Covid-19 cases in USA
@kaggle.soumyasacharya_covid19_usa_dataset_21012020_to_25072020
Data is obtained from COVID-19 Tracking project and NYTimes. Sincere thanks to them for making it available to the public.
Coronaviruses are a large family of viruses which may cause illness in animals or humans. In humans, several coronaviruses are known to cause respiratory infections ranging from the common cold to more severe diseases such as Middle East Respiratory Syndrome (MERS) and Severe Acute Respiratory Syndrome (SARS). The most recently discovered coronavirus causes coronavirus disease COVID-19 - World Health Organization
The number of new cases are increasing day by day around the world. This dataset has information from 50 US states and the District of Columbia at daily level.
LICENSE:
Please refer here
Apache License 2.0
A permissive license whose main conditions require preservation of copyright and license notices. Contributors provide an express grant of patent rights. Licensed works, modifications, and larger works may be distributed under different terms and without source code.
For counties dataset, please refer here
Content
us_states_covid19_daily.csv
This dataset has number of tests conducted in each state at daily level. Column descriptions are
date - date of observation
state - US state 2 digit code
positive - number of tests with positive results
negative - number of tests with negative results
pending - number of test with pending results
death - number of deaths
total - total number of tests
Acknowledgements
Sincere thanks to COVID-19 Tracking project from which the data is obtained.
Sincere thanks to NYTimes for the counties dataset
There is a nice tableau public dashboard on the data. Images for this dataset is obtained from the same. Thank you.
Inspiration
Some of the questions that could be answered are
How is the spread over time to various states
Change in number of people tested over time
CREATE TABLE covid19_counties_usa (
"date" TIMESTAMP,
"county" VARCHAR,
"state" VARCHAR,
"fips" DOUBLE,
"cases" BIGINT,
"deaths" BIGINT
);
CREATE TABLE covid19_usa_states (
"date" TIMESTAMP,
"state" VARCHAR,
"fips" BIGINT,
"cases" BIGINT,
"deaths" BIGINT
);
Anyone who has the link will be able to view this.