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.

Custom SQL query

economist_excess_deaths

country, region, region_code, start_date, end_date, year, week, population, total_deaths...

12,320 rows

economist_historical_deaths

country, region, region_code, start_date, end_date, year, week, population, total_deaths...

39,432 rows

johns_hopkins_csse_daily_reports

day, country_or_region, province_or_state, admin2, fips, confirmed, deaths, recovered, active...

812,332 rows

la_times_cdph_adult_and_senior_care_facilities

date, slug, name, county, staff_confirmed_cases, patients_confirmed_cases, staff_deaths, patients_deaths, fips...

31,233 rows

la_times_cdph_adult_and_senior_care_totals

date, confirmed_cases, deaths, active_cases, source_url

161 rows

la_times_cdph_hospital_patient_county_totals

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

11,869 rows

la_times_cdph_skilled_nursing_facilities

date, id, slug, name, county, staff_confirmed_cases, patients_confirmed_cases, staff_deaths, patients_deaths...

229,948 rows

la_times_cdph_skilled_nursing_totals

date, staff_active_cases, patients_active_cases, staff_confirmed_cases, patients_confirmed_cases, staff_deaths, patients_deaths, staff_deaths_note, source_url

172 rows

la_times_cdph_state_totals

date, confirmed_cases, deaths, travel, person_to_person, community_spread, under_investigation, other_causes, self_monitoring...

275 rows

latimes_agency_totals

agency, county, fips, date, confirmed_cases, deaths, recoveries, did_not_update

14,101 rows

latimes_county_totals

date, county, fips, confirmed_cases, deaths, new_confirmed_cases, new_deaths

13,372 rows

latimes_place_totals

date, county, fips, place, confirmed_cases, note, x, y

169,208 rows

latimes_state_totals

date, confirmed_cases, deaths, new_confirmed_cases, new_deaths

276 rows

ny_times_us_counties

date, county, state, fips, cases, deaths

673,878 rows

ny_times_us_states

date, state, fips, cases, deaths

13,159 rows

us_census_county_populations_2019

fips, population

3,140 rows

us_census_state_populations_2019

region_id, division_id, state_id, state_name, pop_estimate_2019

57 rows

Views

Download SQLite DB: covid.db 259.3 MB

Powered by Datasette · Query took 26.481ms · About: simonw/covid-19-datasette