johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 22409 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2506129 | 2506129 | 2022-11-10 | Malaysia | W.P. Labuan | 22409 | 157 | 0 | 5.2831 | 115.2308 | 2022-11-11 04:21:22 | W.P. Labuan, Malaysia | |||
2313579 | 2313579 | 2022-06-17 | US | New York | Tompkins | 36109 | 22409 | 87 | 0 | 42.44945765 | -76.47229843 | 2022-06-18 04:21:10 | Tompkins, New York, US | |
1229871 | 1229871 | 2022-01-24 | US | New York | Oswego | 36075 | 22409 | 160 | 0 | 43.42778894 | -76.14635194 | 2022-01-25 04:21:05 | Oswego, New York, US | |
468950 | 468950 | 2021-10-07 | US | Louisiana | Tangipahoa | 22105 | 22409 | 487 | 0 | 30.62888673 | -90.40664996 | 2021-10-08 04:21:25 | Tangipahoa, Louisiana, US | |
2464027 | 2464027 | 2021-09-14 | US | Iowa | Scott | 19163 | 22409 | 257 | 0 | 41.63935978 | -90.61959493 | 2021-09-15 03:22:37 | Scott, Iowa, US | |
1386866 | 1386866 | 2021-09-13 | US | Iowa | Scott | 19163 | 22409 | 257 | 0 | 41.63935978 | -90.61959493 | 2021-09-14 04:21:41 | Scott, Iowa, US | |
1886235 | 1886235 | 2021-09-12 | US | Iowa | Scott | 19163 | 22409 | 257 | 0 | 41.63935978 | -90.61959493 | 2021-09-13 04:21:15 | Scott, Iowa, US | |
3807138 | 3807138 | 2021-09-11 | US | Iowa | Scott | 19163 | 22409 | 257 | 0 | 41.63935978 | -90.61959493 | 2021-09-12 04:21:13 | Scott, Iowa, US | |
3450078 | 3450078 | 2021-09-10 | US | Iowa | Scott | 19163 | 22409 | 257 | 0 | 41.63935978 | -90.61959493 | 2021-09-11 04:21:30 | Scott, Iowa, US | |
1264024 | 1264024 | 2021-09-09 | US | Iowa | Scott | 19163 | 22409 | 257 | 0 | 41.63935978 | -90.61959493 | 2021-09-10 04:21:20 | Scott, Iowa, US | |
2280394 | 2280394 | 2021-09-08 | US | Iowa | Scott | 19163 | 22409 | 257 | 0 | 41.63935978 | -90.61959493 | 2021-09-09 04:21:27 | Scott, Iowa, US | |
2592487 | 2592487 | 2021-06-27 | US | Ohio | Mahoning | 39099 | 22409 | 619 | 0 | 41.01631101 | -80.77287029 | 2021-06-28 04:21:29 | Mahoning, Ohio, US | |
36602 | 36602 | 2021-04-12 | Peru | Tacna | 22409 | 1503 | 0 | 20906 | -17.644160999999997 | -70.27756 | 2021-04-13 04:20:37 | Tacna, Peru | ||
3086806 | 3086806 | 2021-04-05 | US | Louisiana | Lafayette | 22055 | 22409 | 270 | 0 | 30.2049055 | -92.06959876 | 2021-04-06 04:20:32 | Lafayette, Louisiana, US | |
2864947 | 2864947 | 2021-01-06 | Russia | Orel Oblast | 22409 | 282 | 19992 | 2135 | 52.96854329999999 | 36.0692477 | 2021-01-07 05:22:03 | Orel Oblast, Russia | ||
122895 | 122895 | 2020-11-18 | Russia | Chelyabinsk Oblast | 22409 | 184 | 20846 | 1379 | 54.4223954 | 61.1865846 | 2020-11-19 05:25:23 | Chelyabinsk Oblast, Russia | ||
2700562 | 2700562 | 2020-06-24 | Colombia | Capital District | 22409 | 540 | 10044 | 11825 | 4.711 | -74.0721 | 2020-06-25 05:26:54 | Capital District, Colombia | ||
1522247 | 1522247 | 2020-06-23 | Colombia | Capital District | 22409 | 540 | 10044 | 11825 | 4.711 | -74.0721 | 2020-06-24 04:33:28 | Capital District, Colombia |
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]);