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

Table List

2 tables(1.76 MB)

Covid19 Counties Usa

@kaggle.soumyasacharya_covid19_usa_dataset_21012020_to_25072020.covid19_counties_usa

1.7 MB
369909 rows
6 columns

date Date	county County	state State	fips Fips	cases Cases
Tue Jan 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Snohomish	Washington	53061	1
Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Snohomish	Washington	53061	1
Thu Jan 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Snohomish	Washington	53061	1
Fri Jan 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Cook	Illinois	17031	1
Fri Jan 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Snohomish	Washington	53061	1
Sat Jan 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Orange	California	6059	1
Sat Jan 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Cook	Illinois	17031	1
Sat Jan 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Snohomish	Washington	53061	1
Sun Jan 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Maricopa	Arizona	4013	1
Sun Jan 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Los Angeles	California	6037	1


CREATE TABLE covid19_counties_usa (
  "date" TIMESTAMP,
  "county" VARCHAR,
  "state" VARCHAR,
  "fips" DOUBLE,
  "cases" BIGINT,
  "deaths" BIGINT
);