johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68 rows where confirmed = 8540 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3223077 | 3223077 | 2022-12-25 | US | Colorado | Logan | 8075 | 8540 | 119 | 0 | 40.7249637 | -103.110817 | 2022-12-26 04:21:06 | Logan, Colorado, US | |
1018991 | 1018991 | 2022-12-24 | US | Colorado | Logan | 8075 | 8540 | 119 | 0 | 40.7249637 | -103.110817 | 2022-12-25 04:21:04 | Logan, Colorado, US | |
691014 | 691014 | 2022-12-23 | US | Colorado | Logan | 8075 | 8540 | 119 | 0 | 40.7249637 | -103.110817 | 2022-12-24 04:21:02 | Logan, Colorado, US | |
2180224 | 2180224 | 2022-12-22 | US | Colorado | Logan | 8075 | 8540 | 119 | 0 | 40.7249637 | -103.110817 | 2022-12-23 04:21:04 | Logan, Colorado, US | |
3177333 | 3177333 | 2022-12-19 | US | Wisconsin | Door | 55029 | 8540 | 82 | 0 | 44.95856458 | -87.30002707 | 2022-12-20 04:21:04 | Door, Wisconsin, US | |
3715172 | 3715172 | 2022-12-06 | US | Illinois | Iroquois | 17075 | 8540 | 128 | 0 | 40.74717633 | -87.82466784 | 2022-12-07 04:20:58 | Iroquois, Illinois, US | |
2418374 | 2418374 | 2022-12-05 | US | West Virginia | Mason | 54053 | 8540 | 105 | 0 | 38.77071799 | -82.02524219 | 2022-12-06 04:21:03 | Mason, West Virginia, US | |
2066672 | 2066672 | 2022-11-19 | US | Puerto Rico | Morovis | 72101 | 8540 | 0 | 0 | 18.316963 | -66.420383 | 2022-11-20 04:21:08 | Morovis, Puerto Rico, US | |
2398328 | 2398328 | 2022-09-12 | US | West Virginia | Wyoming | 54109 | 8540 | 125 | 0 | 37.612327 | -81.54511071 | 2022-09-13 04:20:57 | Wyoming, West Virginia, US | |
255510 | 255510 | 2022-09-08 | US | New Mexico | Grant | 35017 | 8540 | 106 | 0 | 32.73911281 | -108.3827845 | 2022-09-09 04:21:11 | Grant, New Mexico, US | |
1683854 | 1683854 | 2022-08-29 | US | Virginia | Halifax | 51083 | 8540 | 171 | 0 | 36.76654925 | -78.93512622 | 2022-08-30 04:21:03 | Halifax, Virginia, US | |
2326853 | 2326853 | 2022-08-24 | US | West Virginia | Nicholas | 54067 | 8540 | 101 | 0 | 38.29617706 | -80.79759588 | 2022-08-25 04:21:13 | Nicholas, West Virginia, US | |
1407896 | 1407896 | 2022-08-02 | US | South Dakota | Brookings | 46011 | 8540 | 56 | 0 | 44.36974375 | -96.79079945 | 2022-08-03 04:20:59 | Brookings, South Dakota, US | |
3619934 | 3619934 | 2022-08-01 | US | South Dakota | Brookings | 46011 | 8540 | 56 | 0 | 44.36974375 | -96.79079945 | 2022-08-02 04:20:53 | Brookings, South Dakota, US | |
3874824 | 3874824 | 2022-07-31 | US | Texas | Wood | 48499 | 8540 | 289 | 0 | 32.78722382 | -95.38236368 | 2022-08-01 04:21:03 | Wood, Texas, US | |
3874414 | 3874414 | 2022-07-31 | US | South Dakota | Brookings | 46011 | 8540 | 56 | 0 | 44.36974375 | -96.79079945 | 2022-08-01 04:21:03 | Brookings, South Dakota, US | |
677578 | 677578 | 2022-07-30 | US | Texas | Wood | 48499 | 8540 | 289 | 0 | 32.78722382 | -95.38236368 | 2022-07-31 04:21:02 | Wood, Texas, US | |
677168 | 677168 | 2022-07-30 | US | South Dakota | Brookings | 46011 | 8540 | 56 | 0 | 44.36974375 | -96.79079945 | 2022-07-31 04:21:02 | Brookings, South Dakota, US | |
1786777 | 1786777 | 2022-07-29 | US | Texas | Wood | 48499 | 8540 | 289 | 0 | 32.78722382 | -95.38236368 | 2022-07-30 04:20:42 | Wood, Texas, US | |
1786367 | 1786367 | 2022-07-29 | US | South Dakota | Brookings | 46011 | 8540 | 56 | 0 | 44.36974375 | -96.79079945 | 2022-07-30 04:20:42 | Brookings, South Dakota, US | |
1068730 | 1068730 | 2022-07-28 | US | South Dakota | Brookings | 46011 | 8540 | 56 | 0 | 44.36974375 | -96.79079945 | 2022-07-29 04:20:45 | Brookings, South Dakota, US | |
2338249 | 2338249 | 2022-07-27 | US | South Dakota | Brookings | 46011 | 8540 | 56 | 0 | 44.36974375 | -96.79079945 | 2022-07-28 04:20:56 | Brookings, South Dakota, US | |
2240534 | 2240534 | 2022-06-28 | US | Indiana | Ripley | 18137 | 8540 | 139 | 0 | 39.10235626 | -85.26212744 | 2022-06-29 04:20:59 | Ripley, Indiana, US | |
2148776 | 2148776 | 2022-06-27 | US | Indiana | Ripley | 18137 | 8540 | 139 | 0 | 39.10235626 | -85.26212744 | 2022-06-28 04:20:58 | Ripley, Indiana, US | |
3530434 | 3530434 | 2022-06-04 | US | Tennessee | Macon | 47111 | 8540 | 145 | 0 | 36.53157855 | -86.00778595 | 2022-06-05 04:20:55 | Macon, Tennessee, US | |
3136520 | 3136520 | 2022-06-03 | US | Tennessee | Macon | 47111 | 8540 | 145 | 0 | 36.53157855 | -86.00778595 | 2022-06-04 04:20:58 | Macon, Tennessee, US | |
1227052 | 1227052 | 2022-04-14 | US | Washington | Okanogan | 53047 | 8540 | 123 | 0 | 48.54855019 | -119.73872240000001 | 2022-04-15 04:20:57 | Okanogan, Washington, US | |
1540078 | 1540078 | 2022-03-31 | Netherlands | Bonaire, Sint Eustatius and Saba | 8540 | 31 | 0 | 12.1784 | -68.2385 | 2022-04-01 04:20:28 | Bonaire, Sint Eustatius and Saba, Netherlands | |||
1867735 | 1867735 | 2022-03-10 | US | New York | Orleans | 36073 | 8540 | 112 | 0 | 43.2516977 | -78.2320066 | 2022-03-11 04:20:50 | Orleans, New York, US | |
1513072 | 1513072 | 2022-02-24 | US | Michigan | Mecosta | 26107 | 8540 | 102 | 0 | 43.64064262 | -85.32463223 | 2022-02-25 04:21:11 | Mecosta, Michigan, US | |
1059513 | 1059513 | 2022-02-23 | US | Michigan | Mecosta | 26107 | 8540 | 102 | 0 | 43.64064262 | -85.32463223 | 2022-02-24 04:21:14 | Mecosta, Michigan, US | |
1363207 | 1363207 | 2022-02-08 | US | Georgia | Oconee | 13219 | 8540 | 93 | 0 | 33.83749973 | -83.43679568 | 2022-02-09 04:21:04 | Oconee, Georgia, US | |
1296988 | 1296988 | 2022-02-05 | US | Tennessee | Henderson | 47077 | 8540 | 129 | 0 | 35.65581134 | -88.38600175 | 2022-02-06 04:21:00 | Henderson, Tennessee, US | |
2966039 | 2966039 | 2021-12-24 | US | Pennsylvania | Bedford | 42009 | 8540 | 220 | 0 | 40.00522157 | -78.48998442 | 2021-12-25 04:21:37 | Bedford, Pennsylvania, US | |
1255852 | 1255852 | 2021-12-20 | US | Indiana | DeKalb | 18033 | 8540 | 116 | 0 | 41.39804622 | -84.99906934 | 2021-12-21 03:21:27 | DeKalb, Indiana, US | |
3499752 | 3499752 | 2021-12-15 | US | Wisconsin | Marinette | 55075 | 8540 | 87 | 0 | 45.38553432 | -88.03324599999998 | 2021-12-16 04:22:11 | Marinette, Wisconsin, US | |
3498823 | 3498823 | 2021-12-15 | US | Oregon | Polk | 41053 | 8540 | 108 | 0 | 44.90322804 | -123.4128888 | 2021-12-16 04:22:11 | Polk, Oregon, US | |
1666886 | 1666886 | 2021-12-11 | US | Ohio | Athens | 39009 | 8540 | 103 | 0 | 39.33425634 | -82.04278644 | 2021-12-12 04:22:12 | Athens, Ohio, US | |
3658805 | 3658805 | 2021-12-10 | US | Texas | Rusk | 48401 | 8540 | 189 | 0 | 32.10773545 | -94.76176432 | 2021-12-11 04:22:45 | Rusk, Texas, US | |
3658778 | 3658778 | 2021-12-10 | US | Texas | Nacogdoches | 48347 | 8540 | 237 | 0 | 31.62017125 | -94.61803994 | 2021-12-11 04:22:45 | Nacogdoches, Texas, US | |
164457 | 164457 | 2021-11-19 | US | North Dakota | Stark | 38089 | 8540 | 71 | 0 | 46.80851182 | -102.65763259999999 | 2021-11-20 04:22:17 | Stark, North Dakota, US | |
715884 | 715884 | 2021-11-12 | US | Kentucky | Hopkins | 21107 | 8540 | 204 | 0 | 37.30939025 | -87.54670406 | 2021-11-13 04:21:38 | Hopkins, Kentucky, US | |
290275 | 290275 | 2021-10-31 | US | New York | Wayne | 36117 | 8540 | 88 | 0 | 43.15494365 | -77.02976528 | 2021-11-01 04:22:01 | Wayne, New York, US | |
2133577 | 2133577 | 2021-10-01 | US | Maine | Kennebec | 23011 | 8540 | 91 | 0 | 44.40759555 | -69.76738544 | 2021-10-02 04:21:25 | Kennebec, Maine, US | |
1236193 | 1236193 | 2021-09-27 | US | California | Humboldt | 6023 | 8540 | 91 | 0 | 40.69923009 | -123.876044 | 2021-09-28 04:21:28 | Humboldt, California, US | |
3013586 | 3013586 | 2021-09-22 | US | New York | Ontario | 36069 | 8540 | 97 | 0 | 42.85145728 | -77.30874425 | 2021-09-23 04:21:43 | Ontario, New York, US | |
249738 | 249738 | 2021-09-04 | US | Arizona | Santa Cruz | 4023 | 8540 | 187 | 0 | 31.52508998 | -110.8479088 | 2021-09-05 04:21:33 | Santa Cruz, Arizona, US | |
1486743 | 1486743 | 2021-08-13 | US | Texas | Orange | 48361 | 8540 | 158 | 0 | 30.11879481 | -93.89412775 | 2021-08-14 04:21:25 | Orange, Texas, US | |
2902873 | 2902873 | 2021-08-12 | US | Texas | Orange | 48361 | 8540 | 158 | 0 | 30.11879481 | -93.89412775 | 2021-08-13 04:21:24 | Orange, Texas, US | |
2354774 | 2354774 | 2021-08-10 | US | Virginia | Frederick | 51069 | 8540 | 103 | 0 | 39.20172582 | -78.25974949 | 2021-08-11 04:21:58 | Frederick, Virginia, US | |
591051 | 591051 | 2021-08-08 | US | Kentucky | Laurel | 21125 | 8540 | 82 | 0 | 37.10975748 | -84.11321779 | 2021-08-09 04:21:24 | Laurel, Kentucky, US | |
2718059 | 2718059 | 2021-06-10 | US | Indiana | Hancock | 18059 | 8540 | 144 | 0 | 39.82304555 | -85.77566351 | 2021-06-11 04:23:20 | Hancock, Indiana, US | |
2589384 | 2589384 | 2021-06-05 | US | Virginia | Roanoke City | 51770 | 8540 | 194 | 0 | 37.27791025 | -79.96189766 | 2021-06-06 04:24:03 | Roanoke City, Virginia, US | |
648448 | 648448 | 2021-05-05 | US | Ohio | Pickaway | 39129 | 8540 | 121 | 0 | 39.64170392 | -83.0243386 | 2021-05-06 04:20:38 | Pickaway, Ohio, US | |
3705048 | 3705048 | 2021-04-27 | US | Tennessee | Hamblen | 47063 | 8540 | 171 | 0 | 36.21990035 | -83.26586179 | 2021-04-28 04:20:32 | Hamblen, Tennessee, US | |
391897 | 391897 | 2021-04-04 | Malaysia | Kedah | 8540 | 25 | 8247 | 268 | 6.1184 | 100.3685 | 2021-04-05 04:20:35 | Kedah, Malaysia | ||
243746 | 243746 | 2021-04-02 | US | Ohio | Muskingum | 39119 | 8540 | 130 | 0 | 39.96575964 | -81.94363275 | 2021-04-03 04:20:44 | Muskingum, Ohio, US | |
1841333 | 1841333 | 2021-03-12 | US | Virginia | Spotsylvania | 51177 | 8540 | 104 | 0 | 38.18574462 | -77.655399 | 2021-03-13 05:25:15 | Spotsylvania, Virginia, US | |
3308342 | 3308342 | 2021-01-13 | Pakistan | Azad Jammu and Kashmir | 8540 | 236 | 8021 | 283 | 34.027401 | 73.947253 | 2021-01-14 05:22:32 | Azad Jammu and Kashmir, Pakistan | ||
2223321 | 2223321 | 2020-12-26 | China | Hong Kong | 8540 | 136 | 7394 | 1010 | 22.3 | 114.2 | 2020-12-27 05:22:55 | Hong Kong, China | ||
2931351 | 2931351 | 2020-12-19 | Netherlands | Zeeland | 8540 | 115 | 0 | 8429 | 51.47936 | 3.861559 | 2020-12-20 05:27:32 | Zeeland, Netherlands | ||
3839791 | 3839791 | 2020-11-21 | US | Virginia | Chesterfield | 51041 | 8540 | 127 | 0 | 8413 | 37.37373208 | -77.58680140000001 | 2020-11-22 05:25:45 | Chesterfield, Virginia, US |
1990427 | 1990427 | 2020-11-09 | US | Mississippi | Hinds | 28049 | 8540 | 182 | 0 | 8358 | 32.2656285 | -90.44435448 | 2020-11-10 05:40:07 | Hinds, Mississippi, US |
379589 | 379589 | 2020-11-06 | US | Virginia | Virginia Beach | 51810 | 8540 | 110 | 0 | 8430 | 36.73285734 | -76.04566934 | 2020-11-07 05:24:52 | Virginia Beach, Virginia, US |
1026539 | 1026539 | 2020-10-17 | Russia | Buryatia Republic | 8540 | 92 | 7082 | 1366 | 52.7182426 | 109.492143 | 2020-10-18 04:24:25 | Buryatia Republic, Russia | ||
2293603 | 2293603 | 2020-10-12 | US | New Jersey | Morris | 34027 | 8540 | 832 | 0 | 7708 | 40.86095313 | -74.54553709999998 | 2020-10-13 04:24:02 | Morris, New Jersey, US |
1515585 | 1515585 | 2020-09-28 | Russia | Chuvashia Republic | 8540 | 93 | 7207 | 1240 | 55.4259922 | 47.0849429 | 2020-09-29 04:23:42 | Chuvashia Republic, Russia | ||
2171440 | 2171440 | 2020-09-09 | Finland | 8540 | 318 | 7500 | 593 | 61.92411 | 25.748151 | 2020-09-10 04:29:01 | Finland |
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]);