johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where confirmed = 20233 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3953083 | 3953083 | 2022-08-17 | US | Oklahoma | Payne | 40119 | 20233 | 171 | 0 | 36.07695283 | -96.97584944 | 2022-08-18 04:21:11 | Payne, Oklahoma, US | |
993585 | 993585 | 2022-08-16 | US | Oklahoma | Payne | 40119 | 20233 | 171 | 0 | 36.07695283 | -96.97584944 | 2022-08-17 04:20:59 | Payne, Oklahoma, US | |
2496624 | 2496624 | 2022-08-15 | US | Oklahoma | Payne | 40119 | 20233 | 171 | 0 | 36.07695283 | -96.97584944 | 2022-08-16 04:20:58 | Payne, Oklahoma, US | |
3650174 | 3650174 | 2022-08-14 | US | Oklahoma | Payne | 40119 | 20233 | 171 | 0 | 36.07695283 | -96.97584944 | 2022-08-15 04:20:59 | Payne, Oklahoma, US | |
1971180 | 1971180 | 2022-08-13 | US | Oklahoma | Payne | 40119 | 20233 | 171 | 0 | 36.07695283 | -96.97584944 | 2022-08-14 04:20:55 | Payne, Oklahoma, US | |
2890989 | 2890989 | 2022-08-12 | US | Oklahoma | Payne | 40119 | 20233 | 171 | 0 | 36.07695283 | -96.97584944 | 2022-08-13 04:20:52 | Payne, Oklahoma, US | |
3910594 | 3910594 | 2022-08-11 | US | Oklahoma | Payne | 40119 | 20233 | 171 | 0 | 36.07695283 | -96.97584944 | 2022-08-12 04:20:54 | Payne, Oklahoma, US | |
877918 | 877918 | 2022-03-27 | US | Michigan | Lapeer | 26087 | 20233 | 416 | 0 | 43.09052506 | -83.22153148 | 2022-03-28 04:20:33 | Lapeer, Michigan, US | |
2165201 | 2165201 | 2022-03-26 | US | Michigan | Lapeer | 26087 | 20233 | 416 | 0 | 43.09052506 | -83.22153148 | 2022-03-27 04:20:47 | Lapeer, Michigan, US | |
1722137 | 1722137 | 2022-03-25 | US | Michigan | Lapeer | 26087 | 20233 | 416 | 0 | 43.09052506 | -83.22153148 | 2022-03-26 04:20:23 | Lapeer, Michigan, US | |
1906349 | 1906349 | 2022-03-22 | US | Indiana | Warrick | 18173 | 20233 | 231 | 0 | 38.08922676 | -87.2716085 | 2022-03-23 04:20:48 | Warrick, Indiana, US | |
3912049 | 3912049 | 2022-02-20 | Japan | Wakayama | 20233 | 92 | 0 | 33.911879 | 135.505446 | 2022-02-21 04:21:05 | Wakayama, Japan | |||
33194 | 33194 | 2021-08-25 | US | Georgia | Columbia | 13073 | 20233 | 219 | 0 | 33.54534185 | -82.263524 | 2021-08-26 04:21:28 | Columbia, Georgia, US | |
2177132 | 2177132 | 2021-08-22 | US | Maryland | Howard | 24027 | 20233 | 264 | 0 | 39.25305293 | -76.93126208 | 2021-08-23 04:21:27 | Howard, Maryland, US | |
1189977 | 1189977 | 2021-05-31 | US | Iowa | Scott | 19163 | 20233 | 244 | 0 | 41.63935978 | -90.61959493 | 2021-06-01 04:23:09 | Scott, Iowa, US | |
2452128 | 2452128 | 2021-05-02 | US | Kansas | Wyandotte | 20209 | 20233 | 279 | 0 | 39.11727348 | -94.76378225 | 2021-05-03 04:20:39 | Wyandotte, Kansas, US | |
2826141 | 2826141 | 2021-05-01 | US | Kansas | Wyandotte | 20209 | 20233 | 279 | 0 | 39.11727348 | -94.76378225 | 2021-05-02 04:20:48 | Wyandotte, Kansas, US | |
381549 | 381549 | 2021-04-30 | US | Kansas | Wyandotte | 20209 | 20233 | 279 | 0 | 39.11727348 | -94.76378225 | 2021-05-01 04:20:47 | Wyandotte, Kansas, US | |
640403 | 640403 | 2021-03-31 | US | Ohio | Mahoning | 39099 | 20233 | 599 | 0 | 41.01631101 | -80.77287029 | 2021-04-01 04:27:05 | Mahoning, Ohio, US | |
471272 | 471272 | 2021-02-19 | Colombia | Sucre | 20233 | 757 | 19068 | 408 | 8.814 | -74.7233 | 2021-02-20 05:22:51 | Sucre, Colombia | ||
975645 | 975645 | 2021-02-06 | US | Florida | St. Lucie | 12111 | 20233 | 508 | 0 | 19725 | 27.37763908 | -80.47106649 | 2021-02-07 05:23:00 | St. Lucie, Florida, US |
3801612 | 3801612 | 2020-10-05 | Australia | Victoria | 20233 | 807 | 19126 | 300 | -37.8136 | 144.9631 | 2020-10-06 04:23:33 | Victoria, Australia | ||
2852488 | 2852488 | 2020-09-18 | United Kingdom | Wales | 20233 | 2601 | 0 | 18632 | 52.1307 | -3.7837 | 2020-09-19 04:22:00 | Wales, United Kingdom | ||
2740445 | 2740445 | 2020-08-03 | Italy | Veneto | 20233 | 2076 | 17106 | 1051 | 45.43490485 | 12.33845213 | 2020-08-04 04:41:59 | Veneto, Italy |
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]);