Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

Data source: Big Local News · About: big-local-datasette

Custom SQL query

annotations

/id, /fields/Annotation Summary, /fields/State, /fields/States Daily Column, /fields/Metric, /fields/Annotation, /fields/Evidence For, /fields/Evidence Type, /fields/Evidence...

1,190 rows

cdc

<head><title>Document Moved</title></head>

1 row

cdc_cases_deaths

submission_date, state, tot_cases, conf_cases, prob_cases, new_case, pnew_case, tot_death, conf_death...

24,240 rows

cdc_vaccinations_ltc_timeseries

runid, Date, Location, ShortName, LongName, Census2019, Administered_Fed_LTC, Administered_Fed_LTC_Dose1, Administered_Fed_LTC_Dose2...

2,816 rows

cdc_vaccinations_ltc_timeseries_daily

runid, Date, Location, ShortName, LongName, Census2019, Administered_Fed_LTC, Administered_Fed_LTC_Dose1, Administered_Fed_LTC_Dose2...

2,304 rows

cdc_vaccinations_timeseries

runid, Date, Location, ShortName, LongName, Census2019, Doses_Distributed, Doses_Administered, Dist_Per_100K...

4,485 rows

cdc_vaccinations_timeseries_daily

runid, Date, Location, ShortName, LongName, Census2019, Doses_Distributed, Doses_Administered, Dist_Per_100K...

3,250 rows

crdt

Date, State, Cases_Total, Cases_White, Cases_Black, Cases_Latinx, Cases_Asian, Cases_AIAN, Cases_NHPI...

5,208 rows

fda_covid_ivd_euas

Date EUA First Issued, Most recent authorization or revision, Entity, Diagnostic (Most Recent Letter of Authorization), Prduct attributes, Authorized Setting, Authorization Labeling, Amendments and Other Documents, Federal Register Notice for EUA...

3 rows

ltc

Date, State_Abbr, data_timestamp, Data_Type, PosRes_nh, ProbPosRes_nh, DeathRes_nh, ProbDeathRes_nh, PosStaff_nh...

6,886 rows

ltc_nv

Facility Name, Facility Type, County, Unique Confirmed Cases, Deaths Residents/Patients, Deaths Staff, Attack Rate Residents/Patients, Attack Rate Staff, Confirmed COVID-19 Cases Residents/Patients...

207 rows

ltc_wv

County, Facility Name, Active Positive Residents, Active Positve Staff, COVID-19 Associated Deaths, Recovered Residents, Recovered Staff, Cumulative Residents, Cumulative Staff...

123 rows

states_current

date, state, positive, probableCases, negative, pending, totalTestResultsSource, totalTestResults, hospitalizedCurrently...

56 rows

states_daily_4pm_et

date, state, positive, probableCases, negative, pending, totalTestResultsSource, totalTestResults, hospitalizedCurrently...

20,444 rows

states_info

state, notes, covid19Site, covid19SiteSecondary, covid19SiteTertiary, covid19SiteQuaternary, covid19SiteQuinary, twitter, covid19SiteOld...

56 rows

states_matrix

1, , Source Links, Common Assumptions, Other Notes, Per Metric, Per State Source Notes, Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes

57 rows

us_current

date, states, positive, negative, pending, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative...

1 row

us_daily

date, states, positive, negative, pending, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative...

414 rows

Download SQLite DB: COVIDtracking_data_archive.db 9.9 MB