johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66 rows where confirmed = 8574 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1833677 | 1833677 | 2022-10-25 | US | West Virginia | Upshur | 54097 | 8574 | 103 | 0 | 38.89285061 | -80.23689136 | 2022-10-26 04:22:19 | Upshur, West Virginia, US | |
1252075 | 1252075 | 2022-08-23 | US | Kansas | McPherson | 20113 | 8574 | 129 | 0 | 38.39184858 | -97.64769869 | 2022-08-24 04:20:46 | McPherson, Kansas, US | |
2854179 | 2854179 | 2022-08-22 | US | Kansas | McPherson | 20113 | 8574 | 129 | 0 | 38.39184858 | -97.64769869 | 2022-08-23 04:20:56 | McPherson, Kansas, US | |
2404151 | 2404151 | 2022-08-21 | US | Kansas | McPherson | 20113 | 8574 | 129 | 0 | 38.39184858 | -97.64769869 | 2022-08-22 04:20:38 | McPherson, Kansas, US | |
3799229 | 3799229 | 2022-08-20 | US | Kansas | McPherson | 20113 | 8574 | 129 | 0 | 38.39184858 | -97.64769869 | 2022-08-21 04:20:44 | McPherson, Kansas, US | |
2364815 | 2364815 | 2022-08-19 | US | Kansas | McPherson | 20113 | 8574 | 129 | 0 | 38.39184858 | -97.64769869 | 2022-08-20 04:21:01 | McPherson, Kansas, US | |
1162486 | 1162486 | 2022-08-18 | US | Kansas | McPherson | 20113 | 8574 | 129 | 0 | 38.39184858 | -97.64769869 | 2022-08-19 04:20:54 | McPherson, Kansas, US | |
3951810 | 3951810 | 2022-08-17 | US | Kansas | McPherson | 20113 | 8574 | 129 | 0 | 38.39184858 | -97.64769869 | 2022-08-18 04:21:11 | McPherson, Kansas, US | |
2594576 | 2594576 | 2022-07-25 | US | California | Calaveras | 6009 | 8574 | 128 | 0 | 38.20537103 | -120.552913 | 2022-07-26 04:20:58 | Calaveras, California, US | |
2895836 | 2895836 | 2022-04-21 | US | Virginia | Warren | 51187 | 8574 | 155 | 0 | 38.90847745 | -78.20280433 | 2022-04-22 04:20:45 | Warren, Virginia, US | |
3730353 | 3730353 | 2022-04-03 | Netherlands | Bonaire, Sint Eustatius and Saba | 8574 | 33 | 0 | 12.1784 | -68.2385 | 2022-04-04 04:20:51 | Bonaire, Sint Eustatius and Saba, Netherlands | |||
499788 | 499788 | 2022-04-02 | Netherlands | Bonaire, Sint Eustatius and Saba | 8574 | 33 | 0 | 12.1784 | -68.2385 | 2022-04-03 04:20:48 | Bonaire, Sint Eustatius and Saba, Netherlands | |||
3350773 | 3350773 | 2022-04-01 | Netherlands | Bonaire, Sint Eustatius and Saba | 8574 | 33 | 0 | 12.1784 | -68.2385 | 2022-04-02 04:20:47 | Bonaire, Sint Eustatius and Saba, Netherlands | |||
3812459 | 3812459 | 2022-01-28 | US | Ohio | Williams | 39171 | 8574 | 153 | 0 | 41.56052014 | -84.58429552 | 2022-01-29 04:21:10 | Williams, Ohio, US | |
2052999 | 2052999 | 2022-01-25 | US | Indiana | Miami | 18103 | 8574 | 135 | 0 | 40.76940965 | -86.04525048 | 2022-01-26 04:21:07 | Miami, Indiana, US | |
555160 | 555160 | 2022-01-16 | US | Alabama | Escambia | 1053 | 8574 | 150 | 0 | 31.1256789 | -87.15918694 | 2022-01-17 04:21:08 | Escambia, Alabama, US | |
1284918 | 1284918 | 2022-01-05 | US | Tennessee | Cocke | 47029 | 8574 | 171 | 0 | 35.9278914 | -83.11828725 | 2022-01-06 04:22:09 | Cocke, Tennessee, US | |
1233051 | 1233051 | 2021-11-28 | US | Kentucky | Jessamine | 21113 | 8574 | 106 | 0 | 37.87119786 | -84.58252003 | 2021-11-29 04:22:30 | Jessamine, Kentucky, US | |
3642178 | 3642178 | 2021-11-08 | US | Oregon | Klamath | 41035 | 8574 | 127 | 0 | 42.68762984 | -121.64964609999998 | 2021-11-09 04:21:36 | Klamath, Oregon, US | |
1815605 | 1815605 | 2021-09-19 | US | Georgia | Laurens | 13175 | 8574 | 205 | 0 | 32.46325233 | -82.92221316 | 2021-09-20 04:21:22 | Laurens, Georgia, US | |
17185 | 17185 | 2021-09-18 | US | Georgia | Laurens | 13175 | 8574 | 205 | 0 | 32.46325233 | -82.92221316 | 2021-09-19 04:21:34 | Laurens, Georgia, US | |
2618870 | 2618870 | 2021-09-17 | US | Georgia | Laurens | 13175 | 8574 | 205 | 0 | 32.46325233 | -82.92221316 | 2021-09-18 04:21:24 | Laurens, Georgia, US | |
1265099 | 1265099 | 2021-09-09 | US | North Carolina | Duplin | 37061 | 8574 | 154 | 0 | 34.93449805 | -77.93140529 | 2021-09-10 04:21:20 | Duplin, North Carolina, US | |
2177310 | 2177310 | 2021-08-22 | US | Minnesota | Rice | 27131 | 8574 | 113 | 0 | 44.3543376 | -93.29658715 | 2021-08-23 04:21:27 | Rice, Minnesota, US | |
3557406 | 3557406 | 2021-08-21 | US | Minnesota | Rice | 27131 | 8574 | 113 | 0 | 44.3543376 | -93.29658715 | 2021-08-22 04:21:29 | Rice, Minnesota, US | |
1855748 | 1855748 | 2021-08-20 | US | Minnesota | Rice | 27131 | 8574 | 113 | 0 | 44.3543376 | -93.29658715 | 2021-08-21 04:21:38 | Rice, Minnesota, US | |
2718301 | 2718301 | 2021-06-10 | US | Kansas | Reno | 20155 | 8574 | 139 | 0 | 37.95230263 | -98.08607292 | 2021-06-11 04:23:20 | Reno, Kansas, US | |
524186 | 524186 | 2021-06-09 | US | Kansas | Reno | 20155 | 8574 | 139 | 0 | 37.95230263 | -98.08607292 | 2021-06-10 04:23:17 | Reno, Kansas, US | |
2318110 | 2318110 | 2021-06-04 | US | South Carolina | Darlington | 45031 | 8574 | 179 | 0 | 34.33358335 | -79.96027485 | 2021-06-05 04:23:03 | Darlington, South Carolina, US | |
1773996 | 1773996 | 2021-05-23 | US | Pennsylvania | Clearfield | 42033 | 8574 | 146 | 0 | 41.00110782 | -78.47592663 | 2021-05-24 04:20:53 | Clearfield, Pennsylvania, US | |
2453709 | 2453709 | 2021-05-02 | US | Tennessee | Hamblen | 47063 | 8574 | 172 | 0 | 36.21990035 | -83.26586179 | 2021-05-03 04:20:39 | Hamblen, Tennessee, US | |
3088974 | 3088974 | 2021-04-05 | Malaysia | Kedah | 8574 | 25 | 8277 | 272 | 6.1184 | 100.3685 | 2021-04-06 04:20:32 | Kedah, Malaysia | ||
390508 | 390508 | 2021-04-04 | US | North Carolina | Brunswick | 37019 | 8574 | 143 | 0 | 34.070565 | -78.22814204 | 2021-04-05 04:20:35 | Brunswick, North Carolina, US | |
3712424 | 3712424 | 2021-04-03 | US | North Carolina | Brunswick | 37019 | 8574 | 143 | 0 | 34.070565 | -78.22814204 | 2021-04-04 04:20:49 | Brunswick, North Carolina, US | |
243540 | 243540 | 2021-04-02 | US | North Carolina | Brunswick | 37019 | 8574 | 143 | 0 | 34.070565 | -78.22814204 | 2021-04-03 04:20:44 | Brunswick, North Carolina, US | |
1304335 | 1304335 | 2021-04-01 | US | North Carolina | Brunswick | 37019 | 8574 | 143 | 0 | 34.070565 | -78.22814204 | 2021-04-02 04:20:36 | Brunswick, North Carolina, US | |
1801428 | 1801428 | 2021-03-23 | US | Rhode Island | Washington | 44009 | 8574 | 162 | 0 | 41.45961631 | -71.61435303 | 2021-03-24 05:25:40 | Washington, Rhode Island, US | |
1206596 | 1206596 | 2021-03-22 | US | Rhode Island | Washington | 44009 | 8574 | 162 | 0 | 41.45961631 | -71.61435303 | 2021-03-23 05:26:18 | Washington, Rhode Island, US | |
3372118 | 3372118 | 2021-03-21 | US | Rhode Island | Washington | 44009 | 8574 | 162 | 0 | 41.45961631 | -71.61435303 | 2021-03-22 05:25:43 | Washington, Rhode Island, US | |
1747328 | 1747328 | 2021-03-20 | US | Rhode Island | Washington | 44009 | 8574 | 162 | 0 | 41.45961631 | -71.61435303 | 2021-03-21 05:25:44 | Washington, Rhode Island, US | |
3423708 | 3423708 | 2021-03-19 | US | Rhode Island | Washington | 44009 | 8574 | 162 | 0 | 41.45961631 | -71.61435303 | 2021-03-20 05:25:46 | Washington, Rhode Island, US | |
3455646 | 3455646 | 2021-03-18 | US | Rhode Island | Washington | 44009 | 8574 | 162 | 0 | 41.45961631 | -71.61435303 | 2021-03-19 05:26:09 | Washington, Rhode Island, US | |
3623870 | 3623870 | 2021-03-17 | US | Rhode Island | Washington | 44009 | 8574 | 162 | 0 | 41.45961631 | -71.61435303 | 2021-03-18 05:26:22 | Washington, Rhode Island, US | |
3621112 | 3621112 | 2021-03-17 | Japan | Okinawa | 8574 | 123 | 8125 | 326 | 25.768923 | 126.668016 | 2021-03-18 05:26:22 | Okinawa, Japan | ||
1091172 | 1091172 | 2021-03-03 | US | Indiana | Kosciusko | 18085 | 8574 | 111 | 0 | 8463 | 41.24521668 | -85.86312322 | 2021-03-04 05:24:24 | Kosciusko, Indiana, US |
533024 | 533024 | 2021-02-22 | US | North Carolina | Henderson | 37089 | 8574 | 127 | 0 | 8447 | 35.33788927 | -82.4766782 | 2021-02-23 05:23:41 | Henderson, North Carolina, US |
2285181 | 2285181 | 2021-02-14 | US | Minnesota | Sherburne | 27141 | 8574 | 73 | 0 | 8501 | 45.44447208 | -93.77617511 | 2021-02-15 05:24:49 | Sherburne, Minnesota, US |
1676830 | 1676830 | 2021-02-01 | US | Alabama | Cullman | 1043 | 8574 | 149 | 0 | 8425 | 34.13020303 | -86.86888037 | 2021-02-02 05:22:49 | Cullman, Alabama, US |
3880807 | 3880807 | 2021-01-14 | US | Iowa | Story | 19169 | 8574 | 33 | 0 | 8541 | 42.03621213 | -93.46499005 | 2021-01-15 05:22:24 | Story, Iowa, US |
156407 | 156407 | 2021-01-08 | US | North Dakota | Ward | 38101 | 8574 | 178 | 0 | 8415 | 48.22390169 | -101.5436763 | 2021-01-09 05:22:18 | Ward, North Dakota, US |
1065058 | 1065058 | 2021-01-04 | US | Texas | Smith | 48423 | 8574 | 269 | 0 | 12574 | 32.37474036 | -95.2717568 | 2021-01-05 05:21:49 | Smith, Texas, US |
3233661 | 3233661 | 2021-01-03 | US | Texas | Smith | 48423 | 8574 | 269 | 0 | 12574 | 32.37474036 | -95.2717568 | 2021-01-04 05:22:02 | Smith, Texas, US |
2230730 | 2230730 | 2021-01-02 | US | Texas | Smith | 48423 | 8574 | 269 | 0 | 12574 | 32.37474036 | -95.2717568 | 2021-01-03 05:22:52 | Smith, Texas, US |
1140094 | 1140094 | 2021-01-01 | US | Texas | Smith | 48423 | 8574 | 267 | 0 | 12576 | 32.37474036 | -95.2717568 | 2021-01-02 05:22:33 | Smith, Texas, US |
3850756 | 3850756 | 2020-12-13 | US | Tennessee | Out of TN | 80047 | 8574 | 56 | 0 | 11542 | 36.55606529 | 0.0 | 2020-12-14 05:26:27 | Out of TN, Tennessee, US |
395768 | 395768 | 2020-11-27 | US | Wisconsin | Fond du Lac | 55039 | 8574 | 56 | 0 | 8518 | 43.75354908 | -88.48885325 | 2020-11-28 05:25:50 | Fond du Lac, Wisconsin, US |
927215 | 927215 | 2020-11-26 | US | Wisconsin | Fond du Lac | 55039 | 8574 | 56 | 0 | 8518 | 43.75354908 | -88.48885325 | 2020-11-27 05:26:53 | Fond du Lac, Wisconsin, US |
1794832 | 1794832 | 2020-10-19 | Russia | Karachay-Cherkess Republic | 8574 | 30 | 5138 | 3406 | 43.7368326 | 41.7267991 | 2020-10-20 04:24:22 | Karachay-Cherkess Republic, Russia | ||
79285 | 79285 | 2020-10-14 | Russia | Kabardino-Balkarian Republic | 8574 | 109 | 6791 | 1674 | 43.4806048 | 43.5978976 | 2020-10-15 04:24:28 | Kabardino-Balkarian Republic, Russia | ||
3119068 | 3119068 | 2020-10-06 | US | Massachusetts | Hampden | 25013 | 8574 | 696 | 0 | 7783 | 42.13440424 | -72.63235561 | 2020-10-07 04:23:40 | Hampden, Massachusetts, US |
1121789 | 1121789 | 2020-09-17 | Russia | Kaluga Oblast | 8574 | 71 | 7323 | 1180 | 54.4382773 | 35.5272854 | 2020-09-18 05:05:00 | Kaluga Oblast, Russia | ||
666528 | 666528 | 2020-09-16 | Russia | Tyumen Oblast | 8574 | 32 | 7327 | 1215 | 58.8206488 | 70.3658837 | 2020-09-17 04:22:00 | Tyumen Oblast, Russia | ||
442566 | 442566 | 2020-07-26 | Chile | Maule | 8574 | 154 | 7379 | 1041 | -35.5183 | -71.6885 | 2020-07-27 04:35:02 | Maule, Chile | ||
3235737 | 3235737 | 2020-07-10 | US | Florida | Lee | 12071 | 8574 | 179 | 0 | 8395 | 26.58410348 | -81.88399313 | 2020-07-11 04:34:26 | Lee, Florida, US |
528497 | 528497 | 2020-07-04 | US | Pennsylvania | Montgomery | 42091 | 8574 | 810 | 0 | 7764 | 40.21053671 | -75.36652296 | 2020-07-05 04:33:46 | Montgomery, Pennsylvania, US |
3680140 | 3680140 | 2020-06-18 | US | Illinois | DuPage | 17043 | 8574 | 443 | 0 | 8131 | 41.85116968 | -88.08642662 | 2020-06-19 04:33:17 | DuPage, Illinois, 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]);