johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 26199 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
312866 | 312866 | 2022-11-13 | US | Illinois | Adams | 17001 | 26199 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-14 04:21:09 | Adams, Illinois, US | |
64027 | 64027 | 2022-11-12 | US | Illinois | Adams | 17001 | 26199 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-13 04:21:14 | Adams, Illinois, US | |
2928189 | 2928189 | 2022-11-11 | US | Illinois | Adams | 17001 | 26199 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-12 04:20:41 | Adams, Illinois, US | |
2507025 | 2507025 | 2022-11-10 | US | Illinois | Adams | 17001 | 26199 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-11 04:21:22 | Adams, Illinois, US | |
2506734 | 2506734 | 2022-11-10 | US | Connecticut | Tolland | 9013 | 26199 | 301 | 0 | 41.85853803 | -72.3308481 | 2022-11-11 04:21:22 | Tolland, Connecticut, US | |
2760327 | 2760327 | 2022-10-18 | US | Virginia | Roanoke City | 51770 | 26199 | 408 | 0 | 37.27791025 | -79.96189766 | 2022-10-19 04:22:26 | Roanoke City, Virginia, US | |
1681053 | 1681053 | 2022-08-29 | US | California | Humboldt | 6023 | 26199 | 154 | 0 | 40.69923009 | -123.876044 | 2022-08-30 04:21:03 | Humboldt, California, US | |
1767730 | 1767730 | 2022-07-03 | US | Alabama | Limestone | 1083 | 26199 | 297 | 0 | 34.81185586 | -86.98310072 | 2022-07-04 04:20:54 | Limestone, Alabama, US | |
3365716 | 3365716 | 2022-07-02 | US | Alabama | Limestone | 1083 | 26199 | 297 | 0 | 34.81185586 | -86.98310072 | 2022-07-03 04:20:59 | Limestone, Alabama, US | |
594045 | 594045 | 2022-07-01 | US | Alabama | Limestone | 1083 | 26199 | 297 | 0 | 34.81185586 | -86.98310072 | 2022-07-02 04:21:16 | Limestone, Alabama, US | |
1505774 | 1505774 | 2022-05-16 | US | New Jersey | Hunterdon | 34019 | 26199 | 275 | 0 | 40.56335249 | -74.91284156 | 2022-05-17 04:20:59 | Hunterdon, New Jersey, US | |
722837 | 722837 | 2021-11-20 | Togo | 26199 | 243 | 0 | 8.6195 | 0.8248 | 2021-11-21 04:22:13 | Togo | ||||
162367 | 162367 | 2021-11-19 | Togo | 26199 | 243 | 0 | 8.6195 | 0.8248 | 2021-11-20 04:22:17 | Togo | ||||
288668 | 288668 | 2021-10-31 | US | Delaware | Kent | 10001 | 26199 | 445 | 0 | 39.08646628 | -75.56884914 | 2021-11-01 04:22:01 | Kent, Delaware, US | |
2781696 | 2781696 | 2021-03-24 | US | Florida | Lake | 12069 | 26199 | 592 | 0 | 28.76202069 | -81.7125123 | 2021-03-25 05:27:00 | Lake, Florida, 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]);