Database
========

The Covid Tracking Project: Data API. It contains 2 main categories:
National Data, and State & Territories Data.

National Data
-------------

-  Historic US values:

   -  field_definitions

      -  Total test results
      -  Hospital discharges
      -  Confirmed Cases
      -  Cumulative hospitalized/Ever hospitalized
      -  Cumulative in ICU/Ever in ICU
      -  Cumulative on ventilator/Ever on ventilator
      -  Currently hospitalized/Now hospitalized
      -  Currently in ICU/Now in ICU
      -  Currently on ventilator/Now on ventilator
      -  Deaths (probable)
      -  Deaths (confirmed)
      -  Deaths (confirmed and probable)
      -  Probable Cases
      -  Last Update (ET)
      -  New deaths
      -  Date
      -  States (**Non reported**)

Every field is organized in 3 categories: cases, testing, and outcomes.
Then, every field can be accessed with aq dot after the category.

-  Single Day of data:

   -  Same information but you don’t need to download the whole dataset.
      This can be useful in order to make the dataretrieval parallel.

State & Terrtories Data
-----------------------

-  All state metadata: Basic information about all states, including
   notes about our methodology and the websites we use to check for
   data.

   -  field_definitions

      -  state_code
      -  COVID Tracking Project preferred total test units
      -  COVID Tracking Project preferred total test field
      -  State population (2019 census)
      -  Tertiary source for state COVID data
      -  Secondary source for state COVID data
      -  Primary source for state COVID data
      -  FIPS code
      -  State (or territory)

-  Single State Metadata: Same but per state

   -  field_definitions

      -  state_code
      -  COVID Tracking Project preferred total test units
      -  COVID Tracking Project preferred total test field
      -  State population (2019 census)
      -  Tertiary source for state COVID data
      -  Secondary source for state COVID data
      -  Primary source for state COVID data
      -  FIPS code
      -  State (or territory)

-  Historic data for a state or

   -  field_definitions

      -  Total test results
      -  Hospital discharges
      -  Confirmed Cases
      -  Cumulative hospitalized/Ever hospitalized
      -  Cumulative in ICU/Ever in ICU
      -  Cumulative on ventilator/Ever on ventilator
      -  Currently hospitalized/Now hospitalized
      -  Currently in ICU/Now in ICU
      -  Currently on ventilator/Now on ventilator
      -  Deaths (probable)
      -  Deaths (confirmed)
      -  Deaths (confirmed and probable)
      -  Probable Cases
      -  Last Update (ET)
      -  New deaths
      -  Date

-  Single day of data for a state or territory

   -  field_definitions

      -  Total test results
      -  Hospital discharges
      -  Confirmed Cases
      -  Cumulative hospitalized/Ever hospitalized
      -  Cumulative in ICU/Ever in ICU
      -  Cumulative on ventilator/Ever on ventilator
      -  Currently hospitalized/Now hospitalized
      -  Currently in ICU/Now in ICU
      -  Currently on ventilator/Now on ventilator
      -  Deaths (probable)
      -  Deaths (confirmed)
      -  Deaths (confirmed and probable)
      -  Probable Cases
      -  Last Update (ET)
      -  New deaths
      -  Date