USA-statewise(COVID-19 Cases)

USA COVID-19 state wise cases from 13-01-20 to 07-03-21

@kaggle.umeshkumar017_usastatewisecovid19_cases

Table List

1 table(1.65 MB)

All States History

@kaggle.umeshkumar017_usastatewisecovid19_cases.all_states_history

1.65 MB
20780 rows
41 columns

date Date	state State	death Death	deathconfirmed DeathConfirmed	deathincrease DeathIncrease	deathprobable DeathProbable	hospitalized Hospitalized	hospitalizedcumulative HospitalizedCumulative	hospitalizedcurrently HospitalizedCurrently	hospitalizedincrease HospitalizedIncrease	inicucumulative InIcuCumulative	inicucurrently InIcuCurrently	negative Negative	negativeincrease NegativeIncrease	negativetestsantibody NegativeTestsAntibody	negativetestsviral NegativeTestsViral	onventilatorcumulative OnVentilatorCumulative	onventilatorcurrently OnVentilatorCurrently	positive Positive	positivecasesviral PositiveCasesViral	positiveincrease PositiveIncrease	positivetestsantibody PositiveTestsAntibody	positivetestsantigen PositiveTestsAntigen	positivetestspeopleantigen PositiveTestsPeopleAntigen	positivetestsviral PositiveTestsViral	recovered Recovered	totaltestencountersviral TotalTestEncountersViral	totaltestencountersviralincrease TotalTestEncountersViralIncrease	totaltestresults TotalTestResults	totaltestresultsincrease TotalTestResultsIncrease	totaltestsantibody TotalTestsAntibody	totaltestsantigen TotalTestsAntigen	totaltestspeopleantibody TotalTestsPeopleAntibody	totaltestspeopleantigen TotalTestsPeopleAntigen	totaltestspeopleviral TotalTestsPeopleViral	totaltestspeopleviralincrease TotalTestsPeopleViralIncrease	totaltestsviral TotalTestsViral	totaltestsviralincrease TotalTestsViralIncrease
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AK	305				1293	1293	33							1660758		2	56886						68693				1731628								1731628
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AL	10148	7963	-1	2185	45976	45976	494		2676		1931711	2087			1515		499819	392077	408					295690			2323788	2347			119757		2323788	2347
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AR	5319	4308	22	1011	14926	14926	335	11		141	2480716	3267		2480716	1533	65	324818	255726	165			81803		315517			2736442	3380				481311			2736442	3380
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AS											2140																2140								2140
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AZ	16328	14403	5	1925	57907	57907	963	44		273	3073010	13678				143	826454	769935	1335								7908105	45110	580569		444089		3842945	14856	7908105	45110
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CA	54124		258				4291			1159							3501394	3501394	3816								49646014	133186							49646014	133186
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	5989	5251	3	735	23904	23904	326	18			2199458		369995				436602	410976	840	63087					6415123	38163	6415123	38163	435053				2616541	6107
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CT	7704	6327		1377			428							6188566			285330	265709			22245		323284				6520366			396680					6520366
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	DC	1030						150			38						16	41419		146					29570	1261363	5726	1261363	5726					441942	1149
Sun Mar 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	DE	1473	1337	9	136			104			13	545070	917					88354	83621	215				91873		1431942	5867	1431942	5867					633424	1132


CREATE TABLE all_states_history (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "death" DOUBLE,
  "deathconfirmed" DOUBLE,
  "deathincrease" BIGINT,
  "deathprobable" DOUBLE,
  "hospitalized" DOUBLE,
  "hospitalizedcumulative" DOUBLE,
  "hospitalizedcurrently" DOUBLE,
  "hospitalizedincrease" BIGINT,
  "inicucumulative" DOUBLE,
  "inicucurrently" DOUBLE,
  "negative" DOUBLE,
  "negativeincrease" BIGINT,
  "negativetestsantibody" DOUBLE,
  "negativetestspeopleantibody" DOUBLE,
  "negativetestsviral" DOUBLE,
  "onventilatorcumulative" DOUBLE,
  "onventilatorcurrently" DOUBLE,
  "positive" DOUBLE,
  "positivecasesviral" DOUBLE,
  "positiveincrease" BIGINT,
  "positivescore" BIGINT,
  "positivetestsantibody" DOUBLE,
  "positivetestsantigen" DOUBLE,
  "positivetestspeopleantibody" DOUBLE,
  "positivetestspeopleantigen" DOUBLE,
  "positivetestsviral" DOUBLE,
  "recovered" DOUBLE,
  "totaltestencountersviral" DOUBLE,
  "totaltestencountersviralincrease" BIGINT,
  "totaltestresults" DOUBLE,
  "totaltestresultsincrease" BIGINT,
  "totaltestsantibody" DOUBLE,
  "totaltestsantigen" DOUBLE,
  "totaltestspeopleantibody" DOUBLE,
  "totaltestspeopleantigen" DOUBLE,
  "totaltestspeopleviral" DOUBLE,
  "totaltestspeopleviralincrease" BIGINT,
  "totaltestsviral" DOUBLE,
  "totaltestsviralincrease" BIGINT
);