johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
187 rows where confirmed = 3784 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176208 | 3176208 | 2022-12-19 | US | North Dakota | Mountrail | 38061 | 3784 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-12-20 04:21:04 | Mountrail, North Dakota, US | |
1150564 | 1150564 | 2022-12-12 | US | Michigan | Arenac | 26011 | 3784 | 82 | 0 | 44.0636262 | -83.89277559 | 2022-12-13 04:21:01 | Arenac, Michigan, US | |
870418 | 870418 | 2022-12-11 | US | Michigan | Arenac | 26011 | 3784 | 82 | 0 | 44.0636262 | -83.89277559 | 2022-12-12 04:21:01 | Arenac, Michigan, US | |
258948 | 258948 | 2022-12-10 | US | Michigan | Arenac | 26011 | 3784 | 82 | 0 | 44.0636262 | -83.89277559 | 2022-12-11 04:20:50 | Arenac, Michigan, US | |
3937662 | 3937662 | 2022-12-09 | US | Michigan | Arenac | 26011 | 3784 | 82 | 0 | 44.0636262 | -83.89277559 | 2022-12-10 04:21:02 | Arenac, Michigan, US | |
3378994 | 3378994 | 2022-12-08 | US | Michigan | Arenac | 26011 | 3784 | 82 | 0 | 44.0636262 | -83.89277559 | 2022-12-09 04:21:05 | Arenac, Michigan, US | |
1986265 | 1986265 | 2022-12-07 | US | Michigan | Arenac | 26011 | 3784 | 82 | 0 | 44.0636262 | -83.89277559 | 2022-12-08 04:21:07 | Arenac, Michigan, US | |
3715788 | 3715788 | 2022-12-06 | US | Michigan | Arenac | 26011 | 3784 | 82 | 0 | 44.0636262 | -83.89277559 | 2022-12-07 04:20:58 | Arenac, Michigan, US | |
323247 | 323247 | 2022-10-30 | US | Virginia | Brunswick | 51025 | 3784 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-10-31 04:21:36 | Brunswick, Virginia, US | |
915523 | 915523 | 2022-10-29 | US | Virginia | Brunswick | 51025 | 3784 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-10-30 04:22:14 | Brunswick, Virginia, US | |
1369792 | 1369792 | 2022-10-28 | US | Virginia | Brunswick | 51025 | 3784 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-10-29 04:21:13 | Brunswick, Virginia, US | |
3041647 | 3041647 | 2022-10-27 | US | Virginia | Brunswick | 51025 | 3784 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-10-28 04:22:31 | Brunswick, Virginia, US | |
3253728 | 3253728 | 2022-10-11 | US | Wisconsin | Price | 55099 | 3784 | 35 | 0 | 45.68051754 | -90.3609888 | 2022-10-12 04:22:51 | Price, Wisconsin, US | |
3996502 | 3996502 | 2022-09-27 | US | Mississippi | Webster | 28155 | 3784 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-09-28 04:23:01 | Webster, Mississippi, US | |
2770830 | 2770830 | 2022-09-26 | US | Mississippi | Webster | 28155 | 3784 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-09-27 04:23:01 | Webster, Mississippi, US | |
1978483 | 1978483 | 2022-09-25 | US | Mississippi | Webster | 28155 | 3784 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-09-26 04:20:52 | Webster, Mississippi, US | |
2651650 | 2651650 | 2022-09-24 | US | Mississippi | Webster | 28155 | 3784 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-09-25 04:23:31 | Webster, Mississippi, US | |
386090 | 386090 | 2022-09-23 | US | Mississippi | Webster | 28155 | 3784 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-09-24 04:21:40 | Webster, Mississippi, US | |
1626156 | 1626156 | 2022-09-22 | US | Mississippi | Webster | 28155 | 3784 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-09-23 04:23:13 | Webster, Mississippi, US | |
1372360 | 1372360 | 2022-09-21 | US | Mississippi | Webster | 28155 | 3784 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-09-22 04:22:56 | Webster, Mississippi, US | |
2018590 | 2018590 | 2022-09-20 | US | Mississippi | Webster | 28155 | 3784 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-09-21 04:23:22 | Webster, Mississippi, US | |
2017706 | 2017706 | 2022-09-20 | US | Illinois | Cumberland | 17035 | 3784 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-09-21 04:23:22 | Cumberland, Illinois, US | |
1087285 | 1087285 | 2022-08-09 | US | Iowa | Jefferson | 19101 | 3784 | 52 | 0 | 41.03192394 | -91.94849466 | 2022-08-10 04:20:57 | Jefferson, Iowa, US | |
3544700 | 3544700 | 2022-08-08 | US | Iowa | Jefferson | 19101 | 3784 | 52 | 0 | 41.03192394 | -91.94849466 | 2022-08-09 04:20:34 | Jefferson, Iowa, US | |
1071103 | 1071103 | 2022-08-07 | US | Iowa | Jefferson | 19101 | 3784 | 52 | 0 | 41.03192394 | -91.94849466 | 2022-08-08 04:21:08 | Jefferson, Iowa, US | |
1941691 | 1941691 | 2022-08-06 | US | Iowa | Jefferson | 19101 | 3784 | 52 | 0 | 41.03192394 | -91.94849466 | 2022-08-07 04:20:54 | Jefferson, Iowa, US | |
1940265 | 1940265 | 2022-08-06 | China | Beijing | 3784 | 9 | 0 | 40.1824 | 116.4142 | 2022-08-07 04:20:54 | Beijing, China | |||
881490 | 881490 | 2022-08-05 | US | Iowa | Jefferson | 19101 | 3784 | 52 | 0 | 41.03192394 | -91.94849466 | 2022-08-06 04:20:56 | Jefferson, Iowa, US | |
2009901 | 2009901 | 2022-08-04 | US | Iowa | Jefferson | 19101 | 3784 | 52 | 0 | 41.03192394 | -91.94849466 | 2022-08-05 04:20:52 | Jefferson, Iowa, US | |
1099328 | 1099328 | 2022-08-03 | US | Iowa | Jefferson | 19101 | 3784 | 52 | 0 | 41.03192394 | -91.94849466 | 2022-08-04 04:20:58 | Jefferson, Iowa, US | |
1067004 | 1067004 | 2022-07-28 | US | Indiana | Parke | 18121 | 3784 | 50 | 0 | 39.77202286 | -87.20375833 | 2022-07-29 04:20:45 | Parke, Indiana, US | |
2336523 | 2336523 | 2022-07-27 | US | Indiana | Parke | 18121 | 3784 | 50 | 0 | 39.77202286 | -87.20375833 | 2022-07-28 04:20:56 | Parke, Indiana, US | |
959724 | 959724 | 2022-07-19 | US | Georgia | Jefferson | 13163 | 3784 | 113 | 0 | 33.05867328 | -82.41609057 | 2022-07-20 04:20:59 | Jefferson, Georgia, US | |
3211111 | 3211111 | 2022-07-18 | US | Georgia | Jefferson | 13163 | 3784 | 113 | 0 | 33.05867328 | -82.41609057 | 2022-07-19 04:20:58 | Jefferson, Georgia, US | |
3406286 | 3406286 | 2022-07-17 | US | Georgia | Jefferson | 13163 | 3784 | 113 | 0 | 33.05867328 | -82.41609057 | 2022-07-18 04:20:59 | Jefferson, Georgia, US | |
2152486 | 2152486 | 2022-07-16 | US | Georgia | Jefferson | 13163 | 3784 | 113 | 0 | 33.05867328 | -82.41609057 | 2022-07-17 04:21:15 | Jefferson, Georgia, US | |
2419719 | 2419719 | 2022-07-15 | US | Georgia | Jefferson | 13163 | 3784 | 113 | 0 | 33.05867328 | -82.41609057 | 2022-07-16 04:21:05 | Jefferson, Georgia, US | |
3429794 | 3429794 | 2022-07-14 | US | Georgia | Jefferson | 13163 | 3784 | 113 | 0 | 33.05867328 | -82.41609057 | 2022-07-15 04:20:53 | Jefferson, Georgia, US | |
3110983 | 3110983 | 2022-07-13 | US | Louisiana | Caldwell | 22021 | 3784 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-07-14 04:20:57 | Caldwell, Louisiana, US | |
3110314 | 3110314 | 2022-07-13 | US | Georgia | Jefferson | 13163 | 3784 | 113 | 0 | 33.05867328 | -82.41609057 | 2022-07-14 04:20:57 | Jefferson, Georgia, US | |
2150798 | 2150798 | 2022-06-27 | US | Texas | Leon | 48289 | 3784 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-06-28 04:20:58 | Leon, Texas, US | |
2148277 | 2148277 | 2022-06-27 | US | Colorado | Las Animas | 8071 | 3784 | 44 | 0 | 37.3153406 | -104.0376458 | 2022-06-28 04:20:58 | Las Animas, Colorado, US | |
3144517 | 3144517 | 2022-06-11 | US | Tennessee | Decatur | 47039 | 3784 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-06-12 04:20:53 | Decatur, Tennessee, US | |
1947433 | 1947433 | 2022-06-10 | US | Tennessee | Decatur | 47039 | 3784 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-06-11 04:21:01 | Decatur, Tennessee, US | |
3538182 | 3538182 | 2022-05-10 | US | Puerto Rico | Barceloneta | 72017 | 3784 | 0 | 0 | 18.445533 | -66.560531 | 2022-05-11 04:20:48 | Barceloneta, Puerto Rico, US | |
3725285 | 3725285 | 2022-04-25 | US | Texas | Falls | 48145 | 3784 | 64 | 0 | 31.25350609 | -96.93630086 | 2022-04-26 04:20:51 | Falls, Texas, US | |
2031853 | 2031853 | 2022-04-24 | US | Texas | Falls | 48145 | 3784 | 64 | 0 | 31.25350609 | -96.93630086 | 2022-04-25 04:20:56 | Falls, Texas, US | |
749428 | 749428 | 2022-04-23 | US | Texas | Falls | 48145 | 3784 | 64 | 0 | 31.25350609 | -96.93630086 | 2022-04-24 04:20:56 | Falls, Texas, US | |
3439913 | 3439913 | 2022-04-22 | US | Texas | Falls | 48145 | 3784 | 64 | 0 | 31.25350609 | -96.93630086 | 2022-04-23 04:20:50 | Falls, Texas, US | |
2254798 | 2254798 | 2022-04-19 | US | Virginia | Manassas Park | 51685 | 3784 | 27 | 0 | 38.77058531 | -77.44399307 | 2022-04-20 04:20:45 | Manassas Park, Virginia, US | |
2254728 | 2254728 | 2022-04-19 | US | Virginia | Appomattox | 51011 | 3784 | 52 | 0 | 37.37569884 | -78.81340003 | 2022-04-20 04:20:45 | Appomattox, Virginia, US | |
1849278 | 1849278 | 2022-04-18 | US | Virginia | Appomattox | 51011 | 3784 | 52 | 0 | 37.37569884 | -78.81340003 | 2022-04-19 04:21:00 | Appomattox, Virginia, US | |
3353709 | 3353709 | 2022-04-01 | US | Texas | Colorado | 48089 | 3784 | 63 | 0 | 29.622097999999998 | -96.5273805 | 2022-04-02 04:20:47 | Colorado, Texas, US | |
2166340 | 2166340 | 2022-03-26 | US | Puerto Rico | Yauco | 72153 | 3784 | 0 | 0 | 18.080374 | -66.858814 | 2022-03-27 04:20:47 | Yauco, Puerto Rico, US | |
1470315 | 1470315 | 2022-03-24 | US | New Mexico | Socorro | 35053 | 3784 | 86 | 0 | 34.00715494 | -106.9298354 | 2022-03-25 04:20:46 | Socorro, New Mexico, US | |
3024489 | 3024489 | 2022-03-23 | US | New Mexico | Socorro | 35053 | 3784 | 86 | 0 | 34.00715494 | -106.9298354 | 2022-03-24 04:20:43 | Socorro, New Mexico, US | |
3022615 | 3022615 | 2022-03-23 | Tonga | 3784 | 2 | 0 | -21.179000000000002 | -175.1982 | 2022-03-24 04:20:43 | Tonga | ||||
1907411 | 1907411 | 2022-03-22 | US | New Mexico | Socorro | 35053 | 3784 | 86 | 0 | 34.00715494 | -106.9298354 | 2022-03-23 04:20:48 | Socorro, New Mexico, US | |
1905537 | 1905537 | 2022-03-22 | Tonga | 3784 | 2 | 0 | -21.179000000000002 | -175.1982 | 2022-03-23 04:20:48 | Tonga | ||||
3238692 | 3238692 | 2022-03-21 | US | Alabama | Crenshaw | 1041 | 3784 | 96 | 0 | 31.72941803 | -86.31593104 | 2022-03-22 04:20:54 | Crenshaw, Alabama, US | |
24765 | 24765 | 2022-03-20 | US | Alabama | Crenshaw | 1041 | 3784 | 96 | 0 | 31.72941803 | -86.31593104 | 2022-03-21 04:20:50 | Crenshaw, Alabama, US | |
1656775 | 1656775 | 2022-03-19 | US | Alabama | Crenshaw | 1041 | 3784 | 96 | 0 | 31.72941803 | -86.31593104 | 2022-03-20 04:20:45 | Crenshaw, Alabama, US | |
336301 | 336301 | 2022-03-18 | US | Alabama | Crenshaw | 1041 | 3784 | 96 | 0 | 31.72941803 | -86.31593104 | 2022-03-19 04:20:47 | Crenshaw, Alabama, US | |
694754 | 694754 | 2022-03-17 | US | Alabama | Crenshaw | 1041 | 3784 | 96 | 0 | 31.72941803 | -86.31593104 | 2022-03-18 04:20:55 | Crenshaw, Alabama, US | |
2319697 | 2319697 | 2022-03-16 | US | Alabama | Crenshaw | 1041 | 3784 | 95 | 0 | 31.72941803 | -86.31593104 | 2022-03-17 04:20:56 | Crenshaw, Alabama, US | |
265097 | 265097 | 2022-03-15 | US | Wisconsin | Marquette | 55077 | 3784 | 56 | 0 | 43.81911946 | -89.40073763 | 2022-03-16 04:20:50 | Marquette, Wisconsin, US | |
2736603 | 2736603 | 2022-02-27 | US | Wisconsin | Richland | 55103 | 3784 | 43 | 0 | 43.3762778 | -90.43012729 | 2022-02-28 04:21:05 | Richland, Wisconsin, US | |
3049756 | 3049756 | 2022-02-26 | US | Wisconsin | Richland | 55103 | 3784 | 43 | 0 | 43.3762778 | -90.43012729 | 2022-02-27 04:21:04 | Richland, Wisconsin, US | |
578411 | 578411 | 2022-02-25 | US | Wisconsin | Richland | 55103 | 3784 | 43 | 0 | 43.3762778 | -90.43012729 | 2022-02-26 04:21:12 | Richland, Wisconsin, US | |
1514987 | 1514987 | 2022-02-24 | US | Wisconsin | Richland | 55103 | 3784 | 42 | 0 | 43.3762778 | -90.43012729 | 2022-02-25 04:21:11 | Richland, Wisconsin, US | |
3913500 | 3913500 | 2022-02-20 | US | Kentucky | Washington | 21229 | 3784 | 55 | 0 | 37.75599461 | -85.17407732 | 2022-02-21 04:21:05 | Washington, Kentucky, US | |
3877058 | 3877058 | 2022-02-19 | US | Kentucky | Washington | 21229 | 3784 | 55 | 0 | 37.75599461 | -85.17407732 | 2022-02-20 04:21:00 | Washington, Kentucky, US | |
3857314 | 3857314 | 2022-02-18 | US | Kentucky | Washington | 21229 | 3784 | 55 | 0 | 37.75599461 | -85.17407732 | 2022-02-19 04:21:11 | Washington, Kentucky, US | |
233748 | 233748 | 2022-02-11 | US | Arkansas | Madison | 5087 | 3784 | 54 | 0 | 36.01038185 | -93.72524943 | 2022-02-12 04:21:06 | Madison, Arkansas, US | |
2660582 | 2660582 | 2022-01-31 | US | Puerto Rico | Yabucoa | 72151 | 3784 | 0 | 0 | 18.070399 | -65.896289 | 2022-02-01 04:21:11 | Yabucoa, Puerto Rico, US | |
1142806 | 1142806 | 2022-01-23 | US | Missouri | Cooper | 29053 | 3784 | 70 | 0 | 38.844478 | -92.80896081 | 2022-01-24 04:21:12 | Cooper, Missouri, US | |
3427691 | 3427691 | 2022-01-21 | US | Puerto Rico | Guayama | 72057 | 3784 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-01-22 04:21:13 | Guayama, Puerto Rico, US | |
1694295 | 1694295 | 2022-01-10 | US | Missouri | Vernon | 29217 | 3784 | 88 | 0 | 37.8457799 | -94.34127305 | 2022-01-11 04:22:01 | Vernon, Missouri, US | |
733613 | 733613 | 2021-12-27 | US | Texas | Fayette | 48149 | 3784 | 95 | 0 | 29.87788372 | -96.92076062 | 2021-12-28 04:21:47 | Fayette, Texas, US | |
2906344 | 2906344 | 2021-12-19 | US | Oregon | Lincoln | 41041 | 3784 | 58 | 0 | 44.64252874 | -123.86991200000001 | 2021-12-20 04:21:43 | Lincoln, Oregon, US | |
1261417 | 1261417 | 2021-12-18 | US | Oregon | Lincoln | 41041 | 3784 | 58 | 0 | 44.64252874 | -123.86991200000001 | 2021-12-19 04:21:11 | Lincoln, Oregon, US | |
2401445 | 2401445 | 2021-12-17 | US | Oregon | Lincoln | 41041 | 3784 | 58 | 0 | 44.64252874 | -123.86991200000001 | 2021-12-18 02:22:20 | Lincoln, Oregon, US | |
2399318 | 2399318 | 2021-12-17 | US | Arkansas | Lincoln | 5079 | 3784 | 58 | 0 | 33.95317155 | -91.74002806 | 2021-12-18 02:22:20 | Lincoln, Arkansas, US | |
1718032 | 1718032 | 2021-12-16 | US | Michigan | Osceola | 26133 | 3784 | 54 | 0 | 43.98992088 | -85.32566756 | 2021-12-17 04:22:14 | Osceola, Michigan, US | |
3497866 | 3497866 | 2021-12-15 | US | Michigan | Osceola | 26133 | 3784 | 54 | 0 | 43.98992088 | -85.32566756 | 2021-12-16 04:22:11 | Osceola, Michigan, US | |
2197109 | 2197109 | 2021-12-03 | US | Kentucky | Woodford | 21239 | 3784 | 31 | 0 | 38.04178222 | -84.7417556 | 2021-12-04 04:22:18 | Woodford, Kentucky, US | |
90037 | 90037 | 2021-11-09 | US | South Dakota | Yankton | 46135 | 3784 | 40 | 0 | 43.00924485 | -97.39467635 | 2021-11-10 04:21:38 | Yankton, South Dakota, US | |
3122929 | 3122929 | 2021-11-05 | US | Kentucky | Johnson | 21115 | 3784 | 48 | 0 | 37.85106355 | -82.8264322 | 2021-11-06 04:21:51 | Johnson, Kentucky, US | |
698878 | 698878 | 2021-11-04 | US | Arkansas | Cleburne | 5023 | 3784 | 92 | 0 | 35.53864922 | -92.02640019 | 2021-11-05 04:21:54 | Cleburne, Arkansas, US | |
535757 | 535757 | 2021-10-27 | US | Illinois | McDonough | 17109 | 3784 | 62 | 0 | 40.45674722 | -90.67775541 | 2021-10-28 04:22:08 | McDonough, Illinois, US | |
3493194 | 3493194 | 2021-10-26 | US | Illinois | McDonough | 17109 | 3784 | 61 | 0 | 40.45674722 | -90.67775541 | 2021-10-27 04:22:32 | McDonough, Illinois, US | |
656973 | 656973 | 2021-10-22 | US | Tennessee | Morgan | 47129 | 3784 | 47 | 0 | 36.13248031 | -84.64880098 | 2021-10-23 04:21:32 | Morgan, Tennessee, US | |
1911918 | 1911918 | 2021-10-17 | US | Pennsylvania | Warren | 42123 | 3784 | 117 | 0 | 41.81304978 | -79.26969577 | 2021-10-18 04:21:10 | Warren, Pennsylvania, US | |
468118 | 468118 | 2021-10-07 | US | Florida | Holmes | 12059 | 3784 | 49 | 0 | 30.86747479 | -85.81319222 | 2021-10-08 04:21:25 | Holmes, Florida, US | |
2459498 | 2459498 | 2021-10-06 | US | Florida | Holmes | 12059 | 3784 | 49 | 0 | 30.86747479 | -85.81319222 | 2021-10-07 04:21:36 | Holmes, Florida, US | |
3833191 | 3833191 | 2021-10-05 | US | Florida | Holmes | 12059 | 3784 | 49 | 0 | 30.86747479 | -85.81319222 | 2021-10-06 04:21:33 | Holmes, Florida, US | |
987684 | 987684 | 2021-10-04 | US | Florida | Holmes | 12059 | 3784 | 49 | 0 | 30.86747479 | -85.81319222 | 2021-10-05 04:21:27 | Holmes, Florida, US | |
1274994 | 1274994 | 2021-10-03 | US | Florida | Holmes | 12059 | 3784 | 49 | 0 | 30.86747479 | -85.81319222 | 2021-10-04 04:21:31 | Holmes, Florida, US | |
3928747 | 3928747 | 2021-10-02 | US | Florida | Holmes | 12059 | 3784 | 49 | 0 | 30.86747479 | -85.81319222 | 2021-10-03 04:21:24 | Holmes, Florida, US | |
2132727 | 2132727 | 2021-10-01 | US | Florida | Holmes | 12059 | 3784 | 49 | 0 | 30.86747479 | -85.81319222 | 2021-10-02 04:21:25 | Holmes, Florida, 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]);