johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23 rows where confirmed = 28994 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3745498 | 3745498 | 2022-09-07 | US | Alabama | Limestone | 1083 | 28994 | 302 | 0 | 34.81185586 | -86.98310072 | 2022-09-08 04:21:02 | Limestone, Alabama, US | |
115138 | 115138 | 2022-09-06 | US | Alabama | Limestone | 1083 | 28994 | 302 | 0 | 34.81185586 | -86.98310072 | 2022-09-07 04:20:59 | Limestone, Alabama, US | |
2634110 | 2634110 | 2022-09-05 | US | Alabama | Limestone | 1083 | 28994 | 302 | 0 | 34.81185586 | -86.98310072 | 2022-09-06 04:21:02 | Limestone, Alabama, US | |
2987674 | 2987674 | 2022-09-04 | US | Alabama | Limestone | 1083 | 28994 | 302 | 0 | 34.81185586 | -86.98310072 | 2022-09-05 04:21:01 | Limestone, Alabama, US | |
2713359 | 2713359 | 2022-09-03 | US | Alabama | Limestone | 1083 | 28994 | 302 | 0 | 34.81185586 | -86.98310072 | 2022-09-04 04:21:22 | Limestone, Alabama, US | |
1394064 | 1394064 | 2022-09-02 | US | Alabama | Limestone | 1083 | 28994 | 302 | 0 | 34.81185586 | -86.98310072 | 2022-09-03 04:21:04 | Limestone, Alabama, US | |
3547893 | 3547893 | 2022-09-01 | US | Alabama | Limestone | 1083 | 28994 | 302 | 0 | 34.81185586 | -86.98310072 | 2022-09-02 04:21:07 | Limestone, Alabama, US | |
3322402 | 3322402 | 2022-04-07 | US | New Hampshire | Strafford | 33017 | 28994 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-04-06 23:20:53 | Strafford, New Hampshire, US | |
2802938 | 2802938 | 2022-04-06 | US | New Hampshire | Strafford | 33017 | 28994 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-04-06 23:20:53 | Strafford, New Hampshire, US | |
3869707 | 3869707 | 2022-04-05 | US | New Hampshire | Strafford | 33017 | 28994 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-04-06 04:20:49 | Strafford, New Hampshire, US | |
2751049 | 2751049 | 2022-04-04 | US | New Hampshire | Strafford | 33017 | 28994 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-04-05 04:20:48 | Strafford, New Hampshire, US | |
3732395 | 3732395 | 2022-04-03 | US | New Hampshire | Strafford | 33017 | 28994 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-04-04 04:20:51 | Strafford, New Hampshire, US | |
501830 | 501830 | 2022-04-02 | US | New Hampshire | Strafford | 33017 | 28994 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-04-03 04:20:48 | Strafford, New Hampshire, US | |
3352815 | 3352815 | 2022-04-01 | US | New Hampshire | Strafford | 33017 | 28994 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-04-02 04:20:47 | Strafford, New Hampshire, US | |
1542120 | 1542120 | 2022-03-31 | US | New Hampshire | Strafford | 33017 | 28994 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-04-01 04:20:28 | Strafford, New Hampshire, US | |
3816189 | 3816189 | 2021-12-23 | Chile | Arica y Parinacota | 28994 | 546 | 0 | -18.594 | -69.4785 | 2021-12-24 04:21:34 | Arica y Parinacota, Chile | |||
1325828 | 1325828 | 2021-11-14 | US | Wisconsin | Winnebago | 55139 | 28994 | 276 | 0 | 44.06886922 | -88.64477096 | 2021-11-15 04:21:36 | Winnebago, Wisconsin, US | |
689954 | 689954 | 2021-11-13 | US | Wisconsin | Winnebago | 55139 | 28994 | 276 | 0 | 44.06886922 | -88.64477096 | 2021-11-14 04:21:31 | Winnebago, Wisconsin, US | |
718063 | 718063 | 2021-11-12 | US | Wisconsin | Winnebago | 55139 | 28994 | 276 | 0 | 44.06886922 | -88.64477096 | 2021-11-13 04:21:38 | Winnebago, Wisconsin, US | |
3577860 | 3577860 | 2021-05-17 | US | Utah | Southwest Utah | 28994 | 270 | 0 | 37.85447192 | -111.4418764 | 2021-05-18 04:20:33 | Southwest Utah, Utah, US | ||
1301847 | 1301847 | 2021-04-01 | Chile | Tarapaca | 28994 | 515 | 27362 | 1117 | -19.9232 | -69.5132 | 2021-04-02 04:20:36 | Tarapaca, Chile | ||
3153909 | 3153909 | 2021-01-27 | Sudan | 28994 | 1760 | 20936 | 6298 | 12.8628 | 30.2176 | 2021-01-28 05:22:24 | Sudan | |||
3150210 | 3150210 | 2020-12-16 | US | Colorado | Jefferson | 8059 | 28994 | 619 | 0 | 25886 | 39.58635604 | -105.2517692 | 2020-12-17 05:28:12 | Jefferson, Colorado, 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]);