johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where confirmed = 30468 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2017531 | 2017531 | 2022-09-20 | US | Georgia | Floyd | 13115 | 30468 | 538 | 0 | 34.26268279 | -85.21577392 | 2022-09-21 04:23:22 | Floyd, Georgia, US | |
3571404 | 3571404 | 2022-09-19 | US | Georgia | Floyd | 13115 | 30468 | 538 | 0 | 34.26268279 | -85.21577392 | 2022-09-20 04:22:48 | Floyd, Georgia, US | |
420143 | 420143 | 2022-09-18 | US | Georgia | Floyd | 13115 | 30468 | 538 | 0 | 34.26268279 | -85.21577392 | 2022-09-19 04:21:49 | Floyd, Georgia, US | |
3374167 | 3374167 | 2022-09-17 | US | Georgia | Floyd | 13115 | 30468 | 538 | 0 | 34.26268279 | -85.21577392 | 2022-09-18 04:22:50 | Floyd, Georgia, US | |
2356275 | 2356275 | 2022-09-16 | US | Georgia | Floyd | 13115 | 30468 | 538 | 0 | 34.26268279 | -85.21577392 | 2022-09-17 04:20:19 | Floyd, Georgia, US | |
3987432 | 3987432 | 2022-09-15 | US | Georgia | Floyd | 13115 | 30468 | 538 | 0 | 34.26268279 | -85.21577392 | 2022-09-16 04:21:19 | Floyd, Georgia, US | |
1889949 | 1889949 | 2022-09-14 | US | Georgia | Floyd | 13115 | 30468 | 538 | 0 | 34.26268279 | -85.21577392 | 2022-09-15 04:21:02 | Floyd, Georgia, US | |
1720555 | 1720555 | 2022-03-25 | Mali | 30468 | 727 | 0 | 17.570692 | -3.996166000000001 | 2022-03-26 04:20:23 | Mali | ||||
459384 | 459384 | 2022-02-02 | Japan | Kumamoto | 30468 | 148 | 0 | 32.608154 | 130.74523100000002 | 2022-02-03 04:21:21 | Kumamoto, Japan | |||
979134 | 979134 | 2022-02-01 | Russia | Adygea Republic | 30468 | 824 | 0 | 44.6939006 | 40.1520421 | 2022-02-02 04:21:09 | Adygea Republic, Russia | |||
3465670 | 3465670 | 2022-01-18 | US | Louisiana | Bossier | 22015 | 30468 | 419 | 0 | 32.67932307 | -93.60460152 | 2022-01-19 04:21:23 | Bossier, Louisiana, US | |
1717028 | 1717028 | 2021-12-16 | US | Delaware | Kent | 10001 | 30468 | 481 | 0 | 39.08646628 | -75.56884914 | 2021-12-17 04:22:14 | Kent, Delaware, US | |
1233980 | 1233980 | 2021-11-28 | US | North Carolina | Onslow | 37133 | 30468 | 272 | 0 | 34.72607366 | -77.42908179 | 2021-11-29 04:22:30 | Onslow, North Carolina, US | |
1360687 | 1360687 | 2021-11-27 | US | North Carolina | Onslow | 37133 | 30468 | 272 | 0 | 34.72607366 | -77.42908179 | 2021-11-28 04:22:43 | Onslow, North Carolina, US | |
760678 | 760678 | 2021-11-26 | US | North Carolina | Onslow | 37133 | 30468 | 272 | 0 | 34.72607366 | -77.42908179 | 2021-11-27 04:22:45 | Onslow, North Carolina, US | |
1805095 | 1805095 | 2021-11-25 | US | North Carolina | Onslow | 37133 | 30468 | 272 | 0 | 34.72607366 | -77.42908179 | 2021-11-26 04:22:33 | Onslow, North Carolina, US | |
906529 | 906529 | 2021-11-24 | US | North Carolina | Onslow | 37133 | 30468 | 272 | 0 | 34.72607366 | -77.42908179 | 2021-11-25 04:22:33 | Onslow, North Carolina, US | |
2256437 | 2256437 | 2021-05-19 | US | Florida | Lake | 12069 | 30468 | 645 | 0 | 28.76202069 | -81.7125123 | 2021-05-20 04:21:05 | Lake, Florida, US | |
1222073 | 1222073 | 2021-03-27 | US | Ohio | Stark | 39151 | 30468 | 907 | 0 | 40.81482476 | -81.36437305 | 2021-03-28 05:28:10 | Stark, Ohio, 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]);