johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where confirmed = 35782 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
422780 | 422780 | 2022-09-18 | US | Washington | Franklin | 53021 | 35782 | 219 | 0 | 46.53351425 | -118.9018212 | 2022-09-19 04:21:49 | Franklin, Washington, US | |
3376804 | 3376804 | 2022-09-17 | US | Washington | Franklin | 53021 | 35782 | 219 | 0 | 46.53351425 | -118.9018212 | 2022-09-18 04:22:50 | Franklin, Washington, US | |
2358912 | 2358912 | 2022-09-16 | US | Washington | Franklin | 53021 | 35782 | 219 | 0 | 46.53351425 | -118.9018212 | 2022-09-17 04:20:19 | Franklin, Washington, US | |
3726217 | 3726217 | 2022-06-07 | Japan | Iwate | 35782 | 92 | 0 | 39.593287 | 141.361777 | 2022-06-08 04:20:55 | Iwate, Japan | |||
3867544 | 3867544 | 2022-04-05 | Japan | Ishikawa | 35782 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-06 04:20:49 | Ishikawa, Japan | |||
3911701 | 3911701 | 2022-02-20 | Australia | Northern Territory | 35782 | 15 | 0 | -12.4634 | 130.8456 | 2022-02-21 04:21:05 | Northern Territory, Australia | |||
129065 | 129065 | 2022-01-09 | US | North Carolina | Iredell | 37097 | 35782 | 362 | 0 | 35.80950511 | -80.8743128 | 2022-01-10 04:22:07 | Iredell, North Carolina, US | |
1217900 | 1217900 | 2022-01-08 | US | North Carolina | Iredell | 37097 | 35782 | 362 | 0 | 35.80950511 | -80.8743128 | 2022-01-09 04:21:46 | Iredell, North Carolina, US | |
1391993 | 1391993 | 2022-01-07 | US | North Carolina | Iredell | 37097 | 35782 | 362 | 0 | 35.80950511 | -80.8743128 | 2022-01-08 04:21:53 | Iredell, North Carolina, US | |
87371 | 87371 | 2021-11-09 | Russia | Sakhalin Oblast | 35782 | 388 | 0 | 49.7219665 | 143.448533 | 2021-11-10 04:21:38 | Sakhalin Oblast, Russia | |||
3974357 | 3974357 | 2021-09-03 | Chile | Nuble | 35782 | 637 | 0 | -36.7226 | -71.7622 | 2021-09-04 04:21:28 | Nuble, Chile | |||
2005791 | 2005791 | 2021-05-12 | US | Indiana | St. Joseph | 18141 | 35782 | 552 | 0 | 41.61756781 | -86.29040834 | 2021-05-13 04:20:51 | St. Joseph, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
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]);