johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
240 rows where confirmed = 4678 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953814 | 2953814 | 2022-12-20 | US | North Dakota | Richland | 38077 | 4678 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-12-21 04:21:03 | Richland, North Dakota, US | |
1628112 | 1628112 | 2022-12-18 | China | Shandong | 4678 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-19 04:21:03 | Shandong, China | |||
503491 | 503491 | 2022-12-17 | China | Shandong | 4678 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-18 04:21:03 | Shandong, China | |||
1641833 | 1641833 | 2022-11-20 | US | Kentucky | Webster | 21233 | 4678 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-11-21 04:21:05 | Webster, Kentucky, US | |
2065390 | 2065390 | 2022-11-19 | US | Kentucky | Webster | 21233 | 4678 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-11-20 04:21:08 | Webster, Kentucky, US | |
1756784 | 1756784 | 2022-11-18 | US | Kentucky | Webster | 21233 | 4678 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-11-19 04:21:14 | Webster, Kentucky, US | |
3027777 | 3027777 | 2022-11-17 | US | Kentucky | Webster | 21233 | 4678 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-11-18 04:21:15 | Webster, Kentucky, US | |
3026980 | 3026980 | 2022-11-17 | US | Florida | Calhoun | 12013 | 4678 | 104 | 0 | 30.40666734 | -85.19394153 | 2022-11-18 04:21:15 | Calhoun, Florida, US | |
2487488 | 2487488 | 2022-11-16 | US | Kentucky | Webster | 21233 | 4678 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-11-17 04:21:11 | Webster, Kentucky, US | |
2486691 | 2486691 | 2022-11-16 | US | Florida | Calhoun | 12013 | 4678 | 104 | 0 | 30.40666734 | -85.19394153 | 2022-11-17 04:21:11 | Calhoun, Florida, US | |
293499 | 293499 | 2022-11-15 | US | Kentucky | Webster | 21233 | 4678 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-11-16 04:21:09 | Webster, Kentucky, US | |
293165 | 293165 | 2022-11-15 | US | Indiana | Vermillion | 18165 | 4678 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-11-16 04:21:09 | Vermillion, Indiana, US | |
292702 | 292702 | 2022-11-15 | US | Florida | Calhoun | 12013 | 4678 | 104 | 0 | 30.40666734 | -85.19394153 | 2022-11-16 04:21:09 | Calhoun, Florida, US | |
3598529 | 3598529 | 2022-11-14 | US | Kentucky | Webster | 21233 | 4678 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-11-15 04:21:16 | Webster, Kentucky, US | |
3598195 | 3598195 | 2022-11-14 | US | Indiana | Vermillion | 18165 | 4678 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-11-15 04:21:16 | Vermillion, Indiana, US | |
3597732 | 3597732 | 2022-11-14 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-15 04:21:16 | Calhoun, Florida, US | |
313053 | 313053 | 2022-11-13 | US | Indiana | Vermillion | 18165 | 4678 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-11-14 04:21:09 | Vermillion, Indiana, US | |
312590 | 312590 | 2022-11-13 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-14 04:21:09 | Calhoun, Florida, US | |
64214 | 64214 | 2022-11-12 | US | Indiana | Vermillion | 18165 | 4678 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-11-13 04:21:14 | Vermillion, Indiana, US | |
63751 | 63751 | 2022-11-12 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-13 04:21:14 | Calhoun, Florida, US | |
2928376 | 2928376 | 2022-11-11 | US | Indiana | Vermillion | 18165 | 4678 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-11-12 04:20:41 | Vermillion, Indiana, US | |
2927913 | 2927913 | 2022-11-11 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-12 04:20:41 | Calhoun, Florida, US | |
2507212 | 2507212 | 2022-11-10 | US | Indiana | Vermillion | 18165 | 4678 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-11-11 04:21:22 | Vermillion, Indiana, US | |
2506749 | 2506749 | 2022-11-10 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-11 04:21:22 | Calhoun, Florida, US | |
2432087 | 2432087 | 2022-11-09 | US | Indiana | Vermillion | 18165 | 4678 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-11-10 04:21:16 | Vermillion, Indiana, US | |
2431624 | 2431624 | 2022-11-09 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-10 04:21:16 | Calhoun, Florida, US | |
483049 | 483049 | 2022-11-08 | US | Washington | Pacific | 53049 | 4678 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-09 04:21:22 | Pacific, Washington, US | |
480280 | 480280 | 2022-11-08 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-09 04:21:22 | Calhoun, Florida, US | |
2442199 | 2442199 | 2022-11-07 | US | Washington | Pacific | 53049 | 4678 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-08 04:21:21 | Pacific, Washington, US | |
2439430 | 2439430 | 2022-11-07 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-08 04:21:21 | Calhoun, Florida, US | |
1053297 | 1053297 | 2022-11-06 | US | Washington | Pacific | 53049 | 4678 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-07 04:21:26 | Pacific, Washington, US | |
1050528 | 1050528 | 2022-11-06 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-07 04:21:26 | Calhoun, Florida, US | |
621321 | 621321 | 2022-11-05 | US | Washington | Pacific | 53049 | 4678 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-06 04:21:24 | Pacific, Washington, US | |
618552 | 618552 | 2022-11-05 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-06 04:21:24 | Calhoun, Florida, US | |
1025825 | 1025825 | 2022-11-04 | US | Washington | Pacific | 53049 | 4678 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-05 04:21:52 | Pacific, Washington, US | |
1023056 | 1023056 | 2022-11-04 | US | Florida | Calhoun | 12013 | 4678 | 103 | 0 | 30.40666734 | -85.19394153 | 2022-11-05 04:21:52 | Calhoun, Florida, US | |
434816 | 434816 | 2022-11-03 | US | Washington | Pacific | 53049 | 4678 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-04 04:22:11 | Pacific, Washington, US | |
853058 | 853058 | 2022-11-02 | US | Washington | Pacific | 53049 | 4678 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-03 04:22:05 | Pacific, Washington, US | |
1833612 | 1833612 | 2022-10-25 | US | Washington | Pacific | 53049 | 4678 | 71 | 0 | 46.55418369 | -123.7285716 | 2022-10-26 04:22:19 | Pacific, Washington, US | |
797873 | 797873 | 2022-10-24 | US | Washington | Pacific | 53049 | 4678 | 71 | 0 | 46.55418369 | -123.7285716 | 2022-10-25 04:21:53 | Pacific, Washington, US | |
2760077 | 2760077 | 2022-10-18 | US | Texas | Lavaca | 48285 | 4678 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-10-19 04:22:26 | Lavaca, Texas, US | |
2027911 | 2027911 | 2022-10-17 | US | Texas | Lavaca | 48285 | 4678 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-10-18 04:22:42 | Lavaca, Texas, US | |
2162268 | 2162268 | 2022-10-16 | US | Puerto Rico | Ciales | 72039 | 4678 | 0 | 0 | 18.28885 | -66.516475 | 2022-10-17 04:20:31 | Ciales, Puerto Rico, US | |
3251947 | 3251947 | 2022-10-11 | US | Mississippi | Clarke | 28023 | 4678 | 112 | 0 | 32.04158545 | -88.6889622 | 2022-10-12 04:22:51 | Clarke, Mississippi, US | |
2970723 | 2970723 | 2022-10-10 | US | Virginia | Buckingham | 51029 | 4678 | 61 | 0 | 37.57242268 | -78.52518834 | 2022-10-11 04:23:05 | Buckingham, Virginia, US | |
2969206 | 2969206 | 2022-10-10 | US | Mississippi | Clarke | 28023 | 4678 | 112 | 0 | 32.04158545 | -88.6889622 | 2022-10-11 04:23:05 | Clarke, Mississippi, US | |
3099242 | 3099242 | 2022-10-09 | US | Mississippi | Clarke | 28023 | 4678 | 112 | 0 | 32.04158545 | -88.6889622 | 2022-10-10 04:22:32 | Clarke, Mississippi, US | |
4004467 | 4004467 | 2022-10-08 | US | Mississippi | Clarke | 28023 | 4678 | 112 | 0 | 32.04158545 | -88.6889622 | 2022-10-09 04:21:16 | Clarke, Mississippi, US | |
398064 | 398064 | 2022-10-07 | US | Mississippi | Clarke | 28023 | 4678 | 112 | 0 | 32.04158545 | -88.6889622 | 2022-10-08 04:22:56 | Clarke, Mississippi, US | |
2532978 | 2532978 | 2022-10-06 | US | Wisconsin | Washburn | 55129 | 4678 | 48 | 0 | 45.89838588 | -91.79050449 | 2022-10-07 04:23:08 | Washburn, Wisconsin, US | |
2531181 | 2531181 | 2022-10-06 | US | Mississippi | Clarke | 28023 | 4678 | 112 | 0 | 32.04158545 | -88.6889622 | 2022-10-07 04:23:08 | Clarke, Mississippi, US | |
1814372 | 1814372 | 2022-10-05 | US | Wisconsin | Washburn | 55129 | 4678 | 48 | 0 | 45.89838588 | -91.79050449 | 2022-10-06 04:21:22 | Washburn, Wisconsin, US | |
1812575 | 1812575 | 2022-10-05 | US | Mississippi | Clarke | 28023 | 4678 | 112 | 0 | 32.04158545 | -88.6889622 | 2022-10-06 04:21:22 | Clarke, Mississippi, US | |
132549 | 132549 | 2022-10-04 | US | Mississippi | Clarke | 28023 | 4678 | 112 | 0 | 32.04158545 | -88.6889622 | 2022-10-05 04:23:06 | Clarke, Mississippi, US | |
1563629 | 1563629 | 2022-09-28 | US | Wisconsin | Burnett | 55013 | 4678 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-09-29 04:22:34 | Burnett, Wisconsin, US | |
1889618 | 1889618 | 2022-09-14 | US | Arkansas | Clay | 5021 | 4678 | 97 | 0 | 36.36826212 | -90.4148172 | 2022-09-15 04:21:02 | Clay, Arkansas, US | |
2715694 | 2715694 | 2022-09-03 | US | Puerto Rico | Arroyo | 72015 | 4678 | 0 | 0 | 17.998457 | -66.056546 | 2022-09-04 04:21:22 | Arroyo, Puerto Rico, US | |
2889100 | 2889100 | 2022-08-12 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-13 04:20:52 | Gulf, Florida, US | |
3908705 | 3908705 | 2022-08-11 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-12 04:20:54 | Gulf, Florida, US | |
1347022 | 1347022 | 2022-08-10 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-11 04:20:49 | Gulf, Florida, US | |
1089614 | 1089614 | 2022-08-09 | US | Wisconsin | Crawford | 55023 | 4678 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-08-10 04:20:57 | Crawford, Wisconsin, US | |
1086777 | 1086777 | 2022-08-09 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-10 04:20:57 | Gulf, Florida, US | |
3544192 | 3544192 | 2022-08-08 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-09 04:20:34 | Gulf, Florida, US | |
1070595 | 1070595 | 2022-08-07 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-08 04:21:08 | Gulf, Florida, US | |
1941183 | 1941183 | 2022-08-06 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-07 04:20:54 | Gulf, Florida, US | |
880982 | 880982 | 2022-08-05 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-06 04:20:56 | Gulf, Florida, US | |
2009393 | 2009393 | 2022-08-04 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-05 04:20:52 | Gulf, Florida, US | |
1098820 | 1098820 | 2022-08-03 | US | Florida | Gulf | 12045 | 4678 | 82 | 0 | 29.93543004 | -85.2427099 | 2022-08-04 04:20:58 | Gulf, Florida, US | |
1405745 | 1405745 | 2022-08-02 | US | Florida | Gulf | 12045 | 4678 | 80 | 0 | 29.93543004 | -85.2427099 | 2022-08-03 04:20:59 | Gulf, Florida, US | |
3620429 | 3620429 | 2022-08-01 | US | Virginia | Goochland | 51075 | 4678 | 56 | 0 | 37.71714806 | -77.90381514 | 2022-08-02 04:20:53 | Goochland, Virginia, US | |
3617783 | 3617783 | 2022-08-01 | US | Florida | Gulf | 12045 | 4678 | 80 | 0 | 29.93543004 | -85.2427099 | 2022-08-02 04:20:53 | Gulf, Florida, US | |
3872987 | 3872987 | 2022-07-31 | US | Kentucky | Knott | 21119 | 4678 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-08-01 04:21:03 | Knott, Kentucky, US | |
3872263 | 3872263 | 2022-07-31 | US | Florida | Gulf | 12045 | 4678 | 80 | 0 | 29.93543004 | -85.2427099 | 2022-08-01 04:21:03 | Gulf, Florida, US | |
675741 | 675741 | 2022-07-30 | US | Kentucky | Knott | 21119 | 4678 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-31 04:21:02 | Knott, Kentucky, US | |
675017 | 675017 | 2022-07-30 | US | Florida | Gulf | 12045 | 4678 | 80 | 0 | 29.93543004 | -85.2427099 | 2022-07-31 04:21:02 | Gulf, Florida, US | |
1784940 | 1784940 | 2022-07-29 | US | Kentucky | Knott | 21119 | 4678 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-30 04:20:42 | Knott, Kentucky, US | |
1784216 | 1784216 | 2022-07-29 | US | Florida | Gulf | 12045 | 4678 | 80 | 0 | 29.93543004 | -85.2427099 | 2022-07-30 04:20:42 | Gulf, Florida, US | |
1067303 | 1067303 | 2022-07-28 | US | Kentucky | Knott | 21119 | 4678 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-29 04:20:45 | Knott, Kentucky, US | |
2336822 | 2336822 | 2022-07-27 | US | Kentucky | Knott | 21119 | 4678 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-28 04:20:56 | Knott, Kentucky, US | |
1489012 | 1489012 | 2022-07-26 | US | Kentucky | Knott | 21119 | 4678 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-27 04:21:04 | Knott, Kentucky, US | |
2595458 | 2595458 | 2022-07-25 | US | Kentucky | Knott | 21119 | 4678 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-26 04:20:58 | Knott, Kentucky, US | |
3406453 | 3406453 | 2022-07-17 | US | Illinois | Hancock | 17067 | 4678 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-07-18 04:20:59 | Hancock, Illinois, US | |
2152653 | 2152653 | 2022-07-16 | US | Illinois | Hancock | 17067 | 4678 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-07-17 04:21:15 | Hancock, Illinois, US | |
2419886 | 2419886 | 2022-07-15 | US | Illinois | Hancock | 17067 | 4678 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-07-16 04:21:05 | Hancock, Illinois, US | |
169477 | 169477 | 2022-06-21 | US | Washington | Asotin | 53003 | 4678 | 67 | 0 | 46.18894415 | -117.2022851 | 2022-06-22 04:20:54 | Asotin, Washington, US | |
1766760 | 1766760 | 2022-06-20 | US | Washington | Asotin | 53003 | 4678 | 67 | 0 | 46.18894415 | -117.2022851 | 2022-06-21 04:20:56 | Asotin, Washington, US | |
1765119 | 1765119 | 2022-06-20 | US | Mississippi | Calhoun | 28013 | 4678 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-21 04:20:56 | Calhoun, Mississippi, US | |
3272946 | 3272946 | 2022-06-19 | US | Washington | Asotin | 53003 | 4678 | 67 | 0 | 46.18894415 | -117.2022851 | 2022-06-20 04:21:01 | Asotin, Washington, US | |
3271305 | 3271305 | 2022-06-19 | US | Mississippi | Calhoun | 28013 | 4678 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-20 04:21:01 | Calhoun, Mississippi, US | |
3400858 | 3400858 | 2022-06-18 | US | Washington | Asotin | 53003 | 4678 | 67 | 0 | 46.18894415 | -117.2022851 | 2022-06-19 04:20:51 | Asotin, Washington, US | |
3399217 | 3399217 | 2022-06-18 | US | Mississippi | Calhoun | 28013 | 4678 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-19 04:20:51 | Calhoun, Mississippi, US | |
2314735 | 2314735 | 2022-06-17 | US | Washington | Asotin | 53003 | 4678 | 67 | 0 | 46.18894415 | -117.2022851 | 2022-06-18 04:21:10 | Asotin, Washington, US | |
2313094 | 2313094 | 2022-06-17 | US | Mississippi | Calhoun | 28013 | 4678 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-18 04:21:10 | Calhoun, Mississippi, US | |
560598 | 560598 | 2022-06-16 | US | Mississippi | Calhoun | 28013 | 4678 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-17 04:20:56 | Calhoun, Mississippi, US | |
3984400 | 3984400 | 2022-06-15 | US | Mississippi | Calhoun | 28013 | 4678 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-16 04:20:55 | Calhoun, Mississippi, US | |
948641 | 948641 | 2022-06-14 | US | Mississippi | Calhoun | 28013 | 4678 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-15 04:20:54 | Calhoun, Mississippi, US | |
2981049 | 2981049 | 2022-06-13 | US | Mississippi | Calhoun | 28013 | 4678 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-14 04:20:52 | Calhoun, Mississippi, US | |
3160775 | 3160775 | 2022-06-09 | US | Texas | Jones | 48253 | 4678 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-06-10 04:20:55 | Jones, Texas, US | |
3136339 | 3136339 | 2022-06-03 | US | Puerto Rico | Utuado | 72141 | 4678 | 0 | 0 | 18.271214 | -66.702984 | 2022-06-04 04:20:58 | Utuado, Puerto Rico, US | |
2534875 | 2534875 | 2022-05-12 | US | Kentucky | Unassigned | 90021 | 4678 | 52 | 0 | 38.97065142 | 0.0 | 2022-05-13 04:20:51 | Unassigned, Kentucky, 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]);