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

24 rows where confirmed = 19874 and country_or_region = "US" 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
3224666 3224666 2022-12-25 US New York Cayuga 36011 19874 175 0   42.91261714 -76.55731592 2022-12-26 04:21:06 Cayuga, New York, US
490554 490554 2022-11-25 US Tennessee Coffee 47031 19874 286 0   35.49090731 -86.07311784 2022-11-26 04:21:11 Coffee, Tennessee, US
200024 200024 2022-10-19 US Minnesota Rice 27131 19874 193 0   44.3543376 -93.29658715 2022-10-20 04:22:59 Rice, Minnesota, US
2758685 2758685 2022-10-18 US Minnesota Rice 27131 19874 193 0   44.3543376 -93.29658715 2022-10-19 04:22:26 Rice, Minnesota, US
2026519 2026519 2022-10-17 US Minnesota Rice 27131 19874 193 0   44.3543376 -93.29658715 2022-10-18 04:22:42 Rice, Minnesota, US
2161297 2161297 2022-10-16 US Minnesota Rice 27131 19874 193 0   44.3543376 -93.29658715 2022-10-17 04:20:31 Rice, Minnesota, US
517494 517494 2022-10-15 US Minnesota Rice 27131 19874 193 0   44.3543376 -93.29658715 2022-10-16 04:22:39 Rice, Minnesota, US
2034551 2034551 2022-10-14 US Minnesota Rice 27131 19874 193 0   44.3543376 -93.29658715 2022-10-15 04:22:00 Rice, Minnesota, US
3755239 3755239 2022-10-13 US Minnesota Rice 27131 19874 193 0   44.3543376 -93.29658715 2022-10-14 04:22:28 Rice, Minnesota, US
3854308 3854308 2022-04-27 US Ohio Marion 39101 19874 268 0   40.58610662 -83.15736305 2022-04-28 04:20:47 Marion, Ohio, US
3855304 3855304 2022-04-27 US West Virginia Harrison 54033 19874 251 0   39.2853852 -80.37919577 2022-04-28 04:20:47 Harrison, West Virginia, US
1328738 1328738 2022-04-26 US Ohio Marion 39101 19874 268 0   40.58610662 -83.15736305 2022-04-27 04:20:52 Marion, Ohio, US
3724692 3724692 2022-04-25 US Ohio Marion 39101 19874 268 0   40.58610662 -83.15736305 2022-04-26 04:20:51 Marion, Ohio, US
2031260 2031260 2022-04-24 US Ohio Marion 39101 19874 268 0   40.58610662 -83.15736305 2022-04-25 04:20:56 Marion, Ohio, US
748835 748835 2022-04-23 US Ohio Marion 39101 19874 268 0   40.58610662 -83.15736305 2022-04-24 04:20:56 Marion, Ohio, US
3439320 3439320 2022-04-22 US Ohio Marion 39101 19874 268 0   40.58610662 -83.15736305 2022-04-23 04:20:50 Marion, Ohio, US
2894905 2894905 2022-04-21 US Ohio Marion 39101 19874 268 0   40.58610662 -83.15736305 2022-04-22 04:20:45 Marion, Ohio, US
2443261 2443261 2022-04-13 US Arkansas Lonoke 5085 19874 243 0   34.75392199 -91.88742357 2022-04-13 23:21:06 Lonoke, Arkansas, US
3206816 3206816 2022-04-11 US California Humboldt 6023 19874 141 0   40.69923009 -123.876044 2022-04-12 04:20:49 Humboldt, California, US
501940 501940 2022-04-02 US New York Steuben 36101 19874 247 0   42.2689144 -77.3829924 2022-04-03 04:20:48 Steuben, New York, US
1907922 1907922 2022-03-22 US Puerto Rico Caguas 72025 19874 0 0   18.211615 -66.050779 2022-03-23 04:20:48 Caguas, Puerto Rico, US
1299945 1299945 2022-02-17 US Missouri Cole 29051 19874 269 0   38.50455671 -92.27860244 2022-02-18 04:21:04 Cole, Missouri, US
2519712 2519712 2021-08-18 US Louisiana Tangipahoa 22105 19874 381 0   30.62888673 -90.40664996 2021-08-19 04:21:15 Tangipahoa, Louisiana, US
3636796 3636796 2020-05-30 US Texas Harris 48201 19874 231 0 11989 29.86 -95.39 2020-05-31 02:32:45 Harris, Texas, 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]);