johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where confirmed = 11694 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557844 | 2557844 | 2022-11-29 | US | Iowa | Webster | 19187 | 11694 | 180 | 0 | 42.42853483 | -94.17987389 | 2022-11-30 04:21:07 | Webster, Iowa, US | |
1240918 | 1240918 | 2022-11-28 | US | Iowa | Webster | 19187 | 11694 | 180 | 0 | 42.42853483 | -94.17987389 | 2022-11-29 04:21:05 | Webster, Iowa, US | |
3552906 | 3552906 | 2022-11-27 | US | Iowa | Webster | 19187 | 11694 | 180 | 0 | 42.42853483 | -94.17987389 | 2022-11-28 04:21:02 | Webster, Iowa, US | |
2101386 | 2101386 | 2022-11-26 | US | Iowa | Webster | 19187 | 11694 | 180 | 0 | 42.42853483 | -94.17987389 | 2022-11-27 04:21:05 | Webster, Iowa, US | |
488877 | 488877 | 2022-11-25 | US | Iowa | Webster | 19187 | 11694 | 180 | 0 | 42.42853483 | -94.17987389 | 2022-11-26 04:21:11 | Webster, Iowa, US | |
3524706 | 3524706 | 2022-11-24 | US | Iowa | Webster | 19187 | 11694 | 180 | 0 | 42.42853483 | -94.17987389 | 2022-11-25 04:21:06 | Webster, Iowa, US | |
3313489 | 3313489 | 2022-11-23 | US | Iowa | Webster | 19187 | 11694 | 180 | 0 | 42.42853483 | -94.17987389 | 2022-11-24 04:21:09 | Webster, Iowa, US | |
2759362 | 2759362 | 2022-10-18 | US | North Dakota | Williams | 38105 | 11694 | 68 | 0 | 48.34522353 | -103.4793387 | 2022-10-19 04:22:26 | Williams, North Dakota, US | |
1373776 | 1373776 | 2022-09-21 | US | Utah | Wasatch | 49051 | 11694 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-09-22 04:22:56 | Wasatch, Utah, US | |
2020006 | 2020006 | 2022-09-20 | US | Utah | Wasatch | 49051 | 11694 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-09-21 04:23:22 | Wasatch, Utah, US | |
3573879 | 3573879 | 2022-09-19 | US | Utah | Wasatch | 49051 | 11694 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-09-20 04:22:48 | Wasatch, Utah, US | |
422618 | 422618 | 2022-09-18 | US | Utah | Wasatch | 49051 | 11694 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-09-19 04:21:49 | Wasatch, Utah, US | |
3376642 | 3376642 | 2022-09-17 | US | Utah | Wasatch | 49051 | 11694 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-09-18 04:22:50 | Wasatch, Utah, US | |
2358750 | 2358750 | 2022-09-16 | US | Utah | Wasatch | 49051 | 11694 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-09-17 04:20:19 | Wasatch, Utah, US | |
3989907 | 3989907 | 2022-09-15 | US | Utah | Wasatch | 49051 | 11694 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-09-16 04:21:19 | Wasatch, Utah, US | |
2398285 | 2398285 | 2022-09-12 | US | West Virginia | Greenbrier | 54025 | 11694 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-13 04:20:57 | Greenbrier, West Virginia, US | |
2854991 | 2854991 | 2022-08-22 | US | Nebraska | Unassigned | 90031 | 11694 | 951 | 0 | 42.8997274 | 0.0 | 2022-08-23 04:20:56 | Unassigned, Nebraska, US | |
2404963 | 2404963 | 2022-08-21 | US | Nebraska | Unassigned | 90031 | 11694 | 951 | 0 | 42.8997274 | 0.0 | 2022-08-22 04:20:38 | Unassigned, Nebraska, US | |
3800041 | 3800041 | 2022-08-20 | US | Nebraska | Unassigned | 90031 | 11694 | 951 | 0 | 42.8997274 | 0.0 | 2022-08-21 04:20:44 | Unassigned, Nebraska, US | |
2365627 | 2365627 | 2022-08-19 | US | Nebraska | Unassigned | 90031 | 11694 | 951 | 0 | 42.8997274 | 0.0 | 2022-08-20 04:21:01 | Unassigned, Nebraska, US | |
2190750 | 2190750 | 2022-06-22 | US | Texas | Jim Wells | 48249 | 11694 | 211 | 0 | 27.73103938 | -98.0904705 | 2022-06-23 04:20:55 | Jim Wells, Texas, US | |
3000881 | 3000881 | 2022-05-24 | US | Maryland | Calvert | 24009 | 11694 | 146 | 0 | 38.53961642 | -76.56820632 | 2022-05-25 04:20:56 | Calvert, Maryland, US | |
223557 | 223557 | 2022-05-09 | US | Maine | Oxford | 23017 | 11694 | 148 | 0 | 44.49952995 | -70.75682123 | 2022-05-10 04:20:50 | Oxford, Maine, US | |
2332454 | 2332454 | 2022-05-08 | US | Indiana | Cass | 18017 | 11694 | 164 | 0 | 40.76135835 | -86.34830753 | 2022-05-09 04:20:54 | Cass, Indiana, US | |
361416 | 361416 | 2022-05-07 | US | Indiana | Cass | 18017 | 11694 | 164 | 0 | 40.76135835 | -86.34830753 | 2022-05-08 04:20:49 | Cass, Indiana, US | |
1398767 | 1398767 | 2022-05-06 | US | Indiana | Cass | 18017 | 11694 | 164 | 0 | 40.76135835 | -86.34830753 | 2022-05-07 04:21:09 | Cass, Indiana, US | |
3878498 | 3878498 | 2022-02-19 | US | Tennessee | Campbell | 47013 | 11694 | 145 | 0 | 36.40355516 | -84.15108559999999 | 2022-02-20 04:21:00 | Campbell, Tennessee, US | |
1299071 | 1299071 | 2022-02-17 | US | Illinois | Marion | 17121 | 11694 | 199 | 0 | 38.64963204 | -88.91899208 | 2022-02-18 04:21:04 | Marion, Illinois, US | |
3673600 | 3673600 | 2022-02-15 | US | Missouri | Pettis | 29159 | 11694 | 145 | 0 | 38.72798918 | -93.28471706 | 2022-02-16 04:21:10 | Pettis, Missouri, US | |
186139 | 186139 | 2022-02-13 | Malaysia | W.P. Labuan | 11694 | 151 | 0 | 5.2831 | 115.2308 | 2022-02-14 04:20:51 | W.P. Labuan, Malaysia | |||
128121 | 128121 | 2022-01-09 | US | Kentucky | Christian | 21047 | 11694 | 175 | 0 | 36.89267803 | -87.49055367 | 2022-01-10 04:22:07 | Christian, Kentucky, US | |
1216956 | 1216956 | 2022-01-08 | US | Kentucky | Christian | 21047 | 11694 | 175 | 0 | 36.89267803 | -87.49055367 | 2022-01-09 04:21:46 | Christian, Kentucky, US | |
1391049 | 1391049 | 2022-01-07 | US | Kentucky | Christian | 21047 | 11694 | 175 | 0 | 36.89267803 | -87.49055367 | 2022-01-08 04:21:53 | Christian, Kentucky, US | |
447797 | 447797 | 2021-11-17 | US | Alaska | Kenai Peninsula | 2122 | 11694 | 65 | 0 | 60.24429722 | -151.53888840000005 | 2021-11-18 04:21:33 | Kenai Peninsula, Alaska, US | |
30877 | 30877 | 2021-11-11 | US | Ohio | Erie | 39043 | 11694 | 199 | 0 | 41.36796058 | -82.62904521 | 2021-11-12 04:22:01 | Erie, Ohio, US | |
30686 | 30686 | 2021-11-11 | US | New York | St. Lawrence | 36089 | 11694 | 139 | 0 | 44.4976179 | -75.06550039 | 2021-11-12 04:22:01 | St. Lawrence, New York, US | |
2004171 | 2004171 | 2021-11-07 | US | West Virginia | Raleigh | 54081 | 11694 | 178 | 0 | 37.76936795 | -81.2456041 | 2021-11-08 04:21:43 | Raleigh, West Virginia, US | |
3493748 | 3493748 | 2021-10-26 | US | Maryland | Carroll | 24013 | 11694 | 287 | 0 | 39.56453592 | -77.02373735 | 2021-10-27 04:22:32 | Carroll, Maryland, US | |
1495004 | 1495004 | 2021-10-12 | US | Virginia | Roanoke City | 51770 | 11694 | 228 | 0 | 37.27791025 | -79.96189766 | 2021-10-13 04:20:51 | Roanoke City, Virginia, US | |
3892884 | 3892884 | 2021-08-29 | US | Idaho | Twin Falls | 16083 | 11694 | 143 | 0 | 42.35440512 | -114.6685381 | 2021-08-30 04:21:23 | Twin Falls, Idaho, US | |
2793987 | 2793987 | 2021-08-28 | US | Idaho | Twin Falls | 16083 | 11694 | 143 | 0 | 42.35440512 | -114.6685381 | 2021-08-29 04:21:14 | Twin Falls, Idaho, US | |
2924146 | 2924146 | 2021-08-27 | US | Idaho | Twin Falls | 16083 | 11694 | 143 | 0 | 42.35440512 | -114.6685381 | 2021-08-28 04:21:28 | Twin Falls, Idaho, US | |
3127809 | 3127809 | 2021-06-28 | US | North Carolina | Cleveland | 37045 | 11694 | 228 | 0 | 35.33553364 | -81.55204486 | 2021-06-29 04:21:28 | Cleveland, North Carolina, US | |
3472627 | 3472627 | 2021-06-08 | Taiwan* | 11694 | 308 | 1133 | 10253 | 23.7 | 121.0 | 2021-06-09 04:23:31 | Taiwan* | |||
1913636 | 1913636 | 2021-05-20 | US | Alaska | Matanuska-Susitna | 2170 | 11694 | 57 | 0 | 62.31305045 | -149.5741743 | 2021-05-21 04:20:43 | Matanuska-Susitna, Alaska, US | |
3004100 | 3004100 | 2021-04-06 | US | Georgia | Floyd | 13115 | 11694 | 212 | 0 | 34.26268279 | -85.21577392 | 2021-04-07 04:20:53 | Floyd, Georgia, US | |
3710330 | 3710330 | 2021-04-03 | Russia | Chechen Republic | 11694 | 117 | 11376 | 201 | 43.39761470000001 | 45.6985005 | 2021-04-04 04:20:49 | Chechen Republic, Russia | ||
2639251 | 2639251 | 2021-02-11 | US | Louisiana | Tangipahoa | 22105 | 11694 | 254 | 0 | 11440 | 30.62888673 | -90.40664996 | 2021-02-12 05:23:29 | Tangipahoa, Louisiana, US |
1588017 | 1588017 | 2021-02-05 | Colombia | Casanare | 11694 | 238 | 10945 | 511 | 5.7589 | -71.5724 | 2021-02-06 05:23:55 | Casanare, Colombia | ||
862465 | 862465 | 2020-12-11 | US | Mississippi | DeSoto | 28033 | 11694 | 111 | 0 | 11583 | 34.87625235 | -89.99091418 | 2020-12-12 05:26:19 | DeSoto, Mississippi, US |
1350522 | 1350522 | 2020-11-24 | Russia | Karachay-Cherkess Republic | 11694 | 34 | 7860 | 3800 | 43.7368326 | 41.7267991 | 2020-11-25 05:27:20 | Karachay-Cherkess Republic, Russia | ||
3409629 | 3409629 | 2020-11-01 | Russia | Belgorod Oblast | 11694 | 61 | 10255 | 1378 | 50.7080119 | 37.5837615 | 2020-11-02 05:25:04 | Belgorod Oblast, Russia | ||
2193735 | 2193735 | 2020-10-21 | US | Nevada | Washoe | 32031 | 11694 | 186 | 0 | 11508 | 40.66562265 | -119.6631594 | 2020-10-22 04:24:27 | Washoe, Nevada, 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]);