johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where confirmed = 19698 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2819001 | 2819001 | 2022-12-03 | US | New York | Cayuga | 36011 | 19698 | 171 | 0 | 42.91261714 | -76.55731592 | 2022-12-04 04:20:56 | Cayuga, New York, US | |
3432542 | 3432542 | 2022-07-14 | US | Wisconsin | Portage | 55097 | 19698 | 161 | 0 | 44.47558711 | -89.50152965 | 2022-07-15 04:20:53 | Portage, Wisconsin, US | |
1439529 | 1439529 | 2022-03-28 | US | Tennessee | Hamblen | 47063 | 19698 | 347 | 0 | 36.21990035 | -83.26586179 | 2022-03-29 04:20:46 | Hamblen, Tennessee, US | |
2320440 | 2320440 | 2022-03-16 | US | Indiana | Kosciusko | 18085 | 19698 | 228 | 0 | 41.24521668 | -85.86312322 | 2022-03-17 04:20:56 | Kosciusko, Indiana, US | |
2132207 | 2132207 | 2021-10-01 | Russia | Adygea Republic | 19698 | 432 | 0 | 44.6939006 | 40.1520421 | 2021-10-02 04:21:25 | Adygea Republic, Russia | |||
1778932 | 1778932 | 2021-08-30 | US | Wisconsin | Rock | 55105 | 19698 | 216 | 0 | 42.67151616 | -89.07147900000002 | 2021-08-31 04:21:46 | Rock, Wisconsin, US | |
3105351 | 3105351 | 2021-08-24 | France | Mayotte | 19698 | 175 | 0 | -12.8275 | 45.166244 | 2021-08-25 04:21:41 | Mayotte, France | |||
1809913 | 1809913 | 2021-05-27 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-28 04:20:36 | Midland, Texas, US | |
1313336 | 1313336 | 2021-05-26 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-27 04:20:59 | Midland, Texas, US | |
86262 | 86262 | 2021-05-25 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-26 04:20:35 | Midland, Texas, US | |
1416224 | 1416224 | 2021-05-24 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-25 04:21:08 | Midland, Texas, US | |
1774510 | 1774510 | 2021-05-23 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-24 04:20:53 | Midland, Texas, US | |
729665 | 729665 | 2021-05-22 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-23 04:20:51 | Midland, Texas, US | |
1955680 | 1955680 | 2021-05-21 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-22 04:20:45 | Midland, Texas, US | |
1916379 | 1916379 | 2021-05-20 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-21 04:20:43 | Midland, Texas, US | |
2258900 | 2258900 | 2021-05-19 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-20 04:21:05 | Midland, Texas, US | |
2393938 | 2393938 | 2021-05-18 | US | Texas | Midland | 48329 | 19698 | 271 | 0 | 31.86904128 | -102.0315682 | 2021-05-19 04:20:42 | Midland, Texas, US | |
3245455 | 3245455 | 2021-04-21 | US | Texas | Johnson | 48251 | 19698 | 364 | 0 | 32.37877812 | -97.36615819 | 2021-04-22 04:20:53 | Johnson, Texas, US | |
2985731 | 2985731 | 2021-04-10 | US | Ohio | Lake | 39085 | 19698 | 368 | 0 | 41.69710807 | -81.23676539 | 2021-04-11 04:20:56 | Lake, Ohio, US | |
2646002 | 2646002 | 2021-04-08 | Russia | Tatarstan Republic | 19698 | 428 | 16786 | 2484 | 55.7648572 | 52.43104273 | 2021-04-09 04:21:13 | Tatarstan Republic, Russia | ||
1302257 | 1302257 | 2021-04-01 | Russia | Karachay-Cherkess Republic | 19698 | 71 | 18866 | 761 | 43.7368326 | 41.7267991 | 2021-04-02 04:20:36 | Karachay-Cherkess Republic, Russia | ||
2183922 | 2183922 | 2021-02-26 | US | Alabama | Baldwin | 1003 | 19698 | 277 | 0 | 19421 | 30.72774991 | -87.72207058 | 2021-02-27 05:22:28 | Baldwin, Alabama, US |
2467193 | 2467193 | 2021-01-22 | US | Alabama | Montgomery | 1101 | 19698 | 326 | 0 | 19372 | 32.2206831 | -86.20969272 | 2021-01-23 05:22:03 | Montgomery, Alabama, US |
837934 | 837934 | 2020-08-17 | Sweden | Vastra Gotaland | 19698 | 845 | 0 | 18853 | 58.2528 | 13.0596 | 2020-08-18 04:27:56 | Vastra Gotaland, Sweden |
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]);