Dataset: The COVID Tracking Project (2020-2021)

About this Dataset

The COVID Tracking Project (2020-2021)

The COVID Tracking Project was a collaborative volunteer-run effort to track the ongoing COVID-19 pandemic in the United States. It maintained a daily-updated dataset of state-level information related to the outbreak, including counts of the number of cases, tests, hospitalizations, and deaths, the racial and ethnic demographic breakdowns of cases and deaths, and cases and deaths in long-term care facilities.Data was updated by hand from state health department webpages, press conferences, and outreach to state health officials. The project reported data from all states, the District of Columbia, and five US territories.

This data set consists of 26 columns. The columns are as follows :
date
states
positive
negative
pending
hospitalizedCurrently
hospitalizedCumulative
inIcuCurrently
inIcuCumulative
onVentilatorCurrently
onVentilatorCumulative
dateChecked death
hospitalized
totalTestResults
lastModified
recovered
total
posNeg
deathIncrease
hospitalizedIncrease
negativeIncrease
positiveIncrease
totalTestResultsIncrease
hash

Number of records -
'date': 20210307, 'states': 56, 'positive': 28756489, 'negative': 74582825, 'pending': 11808, 'hospitalizedCurrently': 40199, 'hospitalizedCumulative': 776361, 'inIcuCurrently': 8134, 'inIcuCumulative': 45475, 'onVentilatorCurrently': 2802, 'onVentilatorCumulative': 4281, 'dateChecked': '2021-03-07T24:00:00Z', 'death': 515151, 'hospitalized': 776361, 'totalTestResults': 363825123, 'lastModified': '2021-03-07T24:00:00Z', 'recovered': None, 'total': 0, 'posNeg': 0, 'deathIncrease': 842, 'hospitalizedIncrease': 726, 'negativeIncrease': 131835, 'positiveIncrease': 41835, 'totalTestResultsIncrease': 1170059, 'hash': 'a80d0063822e251249fd9a44730c49cb23defd83'

Thanks to The COVID Tracking Project website - https://covidtracking.com/

Would love to see your analysis and insights from this data set using various algorithms. Kindly let me know about your work from this data set via email. Feel free to connect on LinkedIn.
email : arunashivaprakash575@gmail.com
LinkedIn: https://www.linkedin.com/in/aruna-s-/

Tables

Covid Data

@kaggle.arunasivapragasam_covid_data.covid_data

82.28 KB
420 rows
26 columns


CREATE TABLE covid_data (
  "unnamed_0" BIGINT,
  "date" BIGINT,
  "states" BIGINT,
  "positive" DOUBLE,
  "negative" DOUBLE,
  "pending" DOUBLE,
  "hospitalizedcurrently" DOUBLE,
  "hospitalizedcumulative" DOUBLE,
  "inicucurrently" DOUBLE,
  "inicucumulative" DOUBLE,
  "onventilatorcurrently" DOUBLE,
  "onventilatorcumulative" DOUBLE,
  "datechecked" VARCHAR,
  "death" DOUBLE,
  "hospitalized" DOUBLE,
  "totaltestresults" BIGINT,
  "lastmodified" VARCHAR,
  "recovered" VARCHAR,
  "total" BIGINT,
  "posneg" BIGINT,
  "deathincrease" BIGINT,
  "hospitalizedincrease" BIGINT,
  "negativeincrease" BIGINT,
  "positiveincrease" BIGINT,
  "totaltestresultsincrease" BIGINT,
  "hash" VARCHAR
);