covid

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Tables

economist_excess_deaths

country, region, region_code, start_date, end_date, days, year, week, population, total_deaths, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, cadence, month, total_deaths_per_7_days, covid_deaths_per_7_days, expected_deaths_per_7_days, excess_deaths_per_7_days, non_covid_deaths_per_7_days, covid_deaths_per_100k_per_7_days, excess_deaths_per_100k_per_7_days, quarter

24,912 rows

economist_historical_deaths

country, region, region_code, start_date, end_date, days, year, week, population, total_deaths, covid_deaths, expected_deaths, cadence, month

40,255 rows

johns_hopkins_csse_daily_reports

day, country_or_region, province_or_state, admin2, fips, confirmed, deaths, recovered, active, latitude, longitude, last_update, combined_key

4,006,353 rows

la_times_cdph_adult_and_senior_care_facilities

date, name, county, staff_confirmed_cases, patients_confirmed_cases, staff_deaths, patients_deaths, fips, staff_confirmed_cases_note, patients_confirmed_cases_note, staff_deaths_note, patients_deaths_note

116,613 rows

la_times_cdph_adult_and_senior_care_totals

date, confirmed_cases, deaths, active_cases, source_url

295 rows

la_times_cdph_hospital_patient_county_totals

date, county, fips, positive_patients, suspected_patients, icu_positive_patients, icu_suspected_patients, icu_available_beds

56,333 rows

la_times_cdph_skilled_nursing_facilities

date, id, slug, name, county, staff_confirmed_cases, patients_confirmed_cases, staff_deaths, patients_deaths, fips, staff_confirmed_cases_note, patients_confirmed_cases_note, staff_deaths_note, patients_deaths_note

776,631 rows