johns_hopkins_csse_daily_reports

Table actions
⚠️ 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.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

12 rows where country_or_region = "US", deaths = 272 and province_or_state = "Utah" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
3642821 3642821 2021-11-08 US Utah Davis 49011 56842 272 0   40.99001837 -112.1139997 2021-11-09 04:21:36 Davis, Utah, US
3014611 3014611 2021-09-22 US Utah Weber-Morgan   39220 272 0   41.27116049 -111.9145117 2021-09-23 04:21:43 Weber-Morgan, Utah, US
3760749 3760749 2021-09-21 US Utah Weber-Morgan   39025 272 0   41.27116049 -111.9145117 2021-09-22 04:21:45 Weber-Morgan, Utah, US
23635 23635 2021-05-28 US Utah Southwest Utah   29207 272 0   37.85447192 -111.4418764 2021-05-29 04:20:41 Southwest Utah, Utah, US
1810010 1810010 2021-05-27 US Utah Southwest Utah   29185 272 0   37.85447192 -111.4418764 2021-05-28 04:20:36 Southwest Utah, Utah, US
1313433 1313433 2021-05-26 US Utah Southwest Utah   29155 272 0   37.85447192 -111.4418764 2021-05-27 04:20:59 Southwest Utah, Utah, US
86359 86359 2021-05-25 US Utah Southwest Utah   29124 272 0   37.85447192 -111.4418764 2021-05-26 04:20:35 Southwest Utah, Utah, US
1416321 1416321 2021-05-24 US Utah Southwest Utah   29117 272 0   37.85447192 -111.4418764 2021-05-25 04:21:08 Southwest Utah, Utah, US
1774607 1774607 2021-05-23 US Utah Southwest Utah   29106 272 0   37.85447192 -111.4418764 2021-05-24 04:20:53 Southwest Utah, Utah, US
729762 729762 2021-05-22 US Utah Southwest Utah   29094 272 0   37.85447192 -111.4418764 2021-05-23 04:20:51 Southwest Utah, Utah, US
1955777 1955777 2021-05-21 US Utah Southwest Utah   29079 272 0   37.85447192 -111.4418764 2021-05-22 04:20:45 Southwest Utah, Utah, US
1916476 1916476 2021-05-20 US Utah Southwest Utah   29052 272 0   37.85447192 -111.4418764 2021-05-21 04:20:43 Southwest Utah, Utah, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);