johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
162 rows where confirmed = 5808 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
451907 | 451907 | 2022-12-21 | US | Arkansas | Phillips | 5107 | 5808 | 103 | 0 | 34.43268455 | -90.84800154 | 2022-12-22 04:20:56 | Phillips, Arkansas, US | |
351883 | 351883 | 2022-12-14 | US | Wisconsin | Sawyer | 55113 | 5808 | 65 | 0 | 45.87931905 | -91.14504927 | 2022-12-15 04:20:58 | Sawyer, Wisconsin, US | |
850640 | 850640 | 2022-11-02 | US | Illinois | Pike | 17149 | 5808 | 70 | 0 | 39.62265059 | -90.8877017 | 2022-11-03 04:22:05 | Pike, Illinois, US | |
1811169 | 1811169 | 2022-10-05 | US | Alabama | Marengo | 1091 | 5808 | 113 | 0 | 32.24767634 | -87.78796182 | 2022-10-06 04:21:22 | Marengo, Alabama, US | |
131143 | 131143 | 2022-10-04 | US | Alabama | Marengo | 1091 | 5808 | 113 | 0 | 32.24767634 | -87.78796182 | 2022-10-05 04:23:06 | Marengo, Alabama, US | |
2686090 | 2686090 | 2022-10-03 | US | Alabama | Marengo | 1091 | 5808 | 113 | 0 | 32.24767634 | -87.78796182 | 2022-10-04 04:22:55 | Marengo, Alabama, US | |
2260157 | 2260157 | 2022-10-02 | US | Alabama | Marengo | 1091 | 5808 | 113 | 0 | 32.24767634 | -87.78796182 | 2022-10-03 04:23:11 | Marengo, Alabama, US | |
2995683 | 2995683 | 2022-10-01 | US | Alabama | Marengo | 1091 | 5808 | 113 | 0 | 32.24767634 | -87.78796182 | 2022-10-02 04:21:23 | Marengo, Alabama, US | |
854009 | 854009 | 2022-09-30 | US | Alabama | Marengo | 1091 | 5808 | 113 | 0 | 32.24767634 | -87.78796182 | 2022-10-01 04:23:01 | Marengo, Alabama, US | |
2375935 | 2375935 | 2022-09-29 | US | Alabama | Marengo | 1091 | 5808 | 113 | 0 | 32.24767634 | -87.78796182 | 2022-09-30 04:23:09 | Marengo, Alabama, US | |
2831428 | 2831428 | 2022-08-25 | US | Oregon | Clatsop | 41007 | 5808 | 56 | 0 | 45.99712889 | -123.660711 | 2022-08-26 04:21:02 | Clatsop, Oregon, US | |
2403976 | 2403976 | 2022-08-21 | US | Indiana | Sullivan | 18153 | 5808 | 77 | 0 | 39.08952258 | -87.41414469 | 2022-08-22 04:20:38 | Sullivan, Indiana, US | |
3799054 | 3799054 | 2022-08-20 | US | Indiana | Sullivan | 18153 | 5808 | 77 | 0 | 39.08952258 | -87.41414469 | 2022-08-21 04:20:44 | Sullivan, Indiana, US | |
2364640 | 2364640 | 2022-08-19 | US | Indiana | Sullivan | 18153 | 5808 | 77 | 0 | 39.08952258 | -87.41414469 | 2022-08-20 04:21:01 | Sullivan, Indiana, US | |
994389 | 994389 | 2022-08-16 | US | Virginia | Powhatan | 51145 | 5808 | 63 | 0 | 37.55016038 | -77.91267882 | 2022-08-17 04:20:59 | Powhatan, Virginia, US | |
3910272 | 3910272 | 2022-08-11 | US | New York | Schoharie | 36095 | 5808 | 36 | 0 | 42.58831742 | -74.4433903 | 2022-08-12 04:20:54 | Schoharie, New York, US | |
1490948 | 1490948 | 2022-07-26 | US | Virginia | King George | 51099 | 5808 | 45 | 0 | 38.26818502 | -77.15852768 | 2022-07-27 04:21:04 | King George, Virginia, US | |
1610041 | 1610041 | 2022-07-20 | US | Minnesota | Waseca | 27161 | 5808 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-07-21 04:21:10 | Waseca, Minnesota, US | |
960674 | 960674 | 2022-07-19 | US | Minnesota | Waseca | 27161 | 5808 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-07-20 04:20:59 | Waseca, Minnesota, US | |
3212061 | 3212061 | 2022-07-18 | US | Minnesota | Waseca | 27161 | 5808 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-07-19 04:20:58 | Waseca, Minnesota, US | |
3408797 | 3408797 | 2022-07-17 | US | Virginia | Fluvanna | 51065 | 5808 | 47 | 0 | 37.84157909 | -78.27715475 | 2022-07-18 04:20:59 | Fluvanna, Virginia, US | |
3407236 | 3407236 | 2022-07-17 | US | Minnesota | Waseca | 27161 | 5808 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-07-18 04:20:59 | Waseca, Minnesota, US | |
2154997 | 2154997 | 2022-07-16 | US | Virginia | Fluvanna | 51065 | 5808 | 47 | 0 | 37.84157909 | -78.27715475 | 2022-07-17 04:21:15 | Fluvanna, Virginia, US | |
2153436 | 2153436 | 2022-07-16 | US | Minnesota | Waseca | 27161 | 5808 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-07-17 04:21:15 | Waseca, Minnesota, US | |
2422230 | 2422230 | 2022-07-15 | US | Virginia | Fluvanna | 51065 | 5808 | 47 | 0 | 37.84157909 | -78.27715475 | 2022-07-16 04:21:05 | Fluvanna, Virginia, US | |
2420669 | 2420669 | 2022-07-15 | US | Minnesota | Waseca | 27161 | 5808 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-07-16 04:21:05 | Waseca, Minnesota, US | |
3430744 | 3430744 | 2022-07-14 | US | Minnesota | Waseca | 27161 | 5808 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-07-15 04:20:53 | Waseca, Minnesota, US | |
3081277 | 3081277 | 2022-07-04 | US | Texas | San Jacinto | 48407 | 5808 | 102 | 0 | 30.57933681 | -95.16260304 | 2022-07-05 04:20:45 | San Jacinto, Texas, US | |
1770559 | 1770559 | 2022-07-03 | US | Texas | San Jacinto | 48407 | 5808 | 102 | 0 | 30.57933681 | -95.16260304 | 2022-07-04 04:20:54 | San Jacinto, Texas, US | |
3368545 | 3368545 | 2022-07-02 | US | Texas | San Jacinto | 48407 | 5808 | 102 | 0 | 30.57933681 | -95.16260304 | 2022-07-03 04:20:59 | San Jacinto, Texas, US | |
596874 | 596874 | 2022-07-01 | US | Texas | San Jacinto | 48407 | 5808 | 102 | 0 | 30.57933681 | -95.16260304 | 2022-07-02 04:21:16 | San Jacinto, Texas, US | |
2493569 | 2493569 | 2022-06-29 | US | Wisconsin | Iowa | 55049 | 5808 | 30 | 0 | 43.00050278 | -90.13469017 | 2022-06-30 04:21:01 | Iowa, Wisconsin, US | |
1650250 | 1650250 | 2022-06-23 | US | Missouri | Audrain | 29007 | 5808 | 113 | 0 | 39.215877 | -91.84242683 | 2022-06-24 04:20:58 | Audrain, Missouri, US | |
2189485 | 2189485 | 2022-06-22 | US | Missouri | Audrain | 29007 | 5808 | 113 | 0 | 39.215877 | -91.84242683 | 2022-06-23 04:20:55 | Audrain, Missouri, US | |
167916 | 167916 | 2022-06-21 | US | Missouri | Audrain | 29007 | 5808 | 113 | 0 | 39.215877 | -91.84242683 | 2022-06-22 04:20:54 | Audrain, Missouri, US | |
167400 | 167400 | 2022-06-21 | US | Kansas | Sumner | 20191 | 5808 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-22 04:20:54 | Sumner, Kansas, US | |
1766267 | 1766267 | 2022-06-20 | US | Tennessee | Fentress | 47049 | 5808 | 129 | 0 | 36.38128818 | -84.92870012 | 2022-06-21 04:20:56 | Fentress, Tennessee, US | |
1765199 | 1765199 | 2022-06-20 | US | Missouri | Audrain | 29007 | 5808 | 113 | 0 | 39.215877 | -91.84242683 | 2022-06-21 04:20:56 | Audrain, Missouri, US | |
1764683 | 1764683 | 2022-06-20 | US | Kansas | Sumner | 20191 | 5808 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-21 04:20:56 | Sumner, Kansas, US | |
3271385 | 3271385 | 2022-06-19 | US | Missouri | Audrain | 29007 | 5808 | 113 | 0 | 39.215877 | -91.84242683 | 2022-06-20 04:21:01 | Audrain, Missouri, US | |
3270959 | 3270959 | 2022-06-19 | US | Kentucky | McCreary | 21147 | 5808 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-06-20 04:21:01 | McCreary, Kentucky, US | |
3270869 | 3270869 | 2022-06-19 | US | Kansas | Sumner | 20191 | 5808 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-20 04:21:01 | Sumner, Kansas, US | |
3399297 | 3399297 | 2022-06-18 | US | Missouri | Audrain | 29007 | 5808 | 113 | 0 | 39.215877 | -91.84242683 | 2022-06-19 04:20:51 | Audrain, Missouri, US | |
3398871 | 3398871 | 2022-06-18 | US | Kentucky | McCreary | 21147 | 5808 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-06-19 04:20:51 | McCreary, Kentucky, US | |
3398781 | 3398781 | 2022-06-18 | US | Kansas | Sumner | 20191 | 5808 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-19 04:20:51 | Sumner, Kansas, US | |
2313174 | 2313174 | 2022-06-17 | US | Missouri | Audrain | 29007 | 5808 | 113 | 0 | 39.215877 | -91.84242683 | 2022-06-18 04:21:10 | Audrain, Missouri, US | |
2312748 | 2312748 | 2022-06-17 | US | Kentucky | McCreary | 21147 | 5808 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-06-18 04:21:10 | McCreary, Kentucky, US | |
2312658 | 2312658 | 2022-06-17 | US | Kansas | Sumner | 20191 | 5808 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-18 04:21:10 | Sumner, Kansas, US | |
560252 | 560252 | 2022-06-16 | US | Kentucky | McCreary | 21147 | 5808 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-06-17 04:20:56 | McCreary, Kentucky, US | |
560162 | 560162 | 2022-06-16 | US | Kansas | Sumner | 20191 | 5808 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-17 04:20:56 | Sumner, Kansas, US | |
3984054 | 3984054 | 2022-06-15 | US | Kentucky | McCreary | 21147 | 5808 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-06-16 04:20:55 | McCreary, Kentucky, US | |
3983964 | 3983964 | 2022-06-15 | US | Kansas | Sumner | 20191 | 5808 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-16 04:20:55 | Sumner, Kansas, US | |
948295 | 948295 | 2022-06-14 | US | Kentucky | McCreary | 21147 | 5808 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-06-15 04:20:54 | McCreary, Kentucky, US | |
2982333 | 2982333 | 2022-06-13 | US | Texas | Dimmit | 48127 | 5808 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-06-14 04:20:52 | Dimmit, Texas, US | |
2980703 | 2980703 | 2022-06-13 | US | Kentucky | McCreary | 21147 | 5808 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-06-14 04:20:52 | McCreary, Kentucky, US | |
2049450 | 2049450 | 2022-05-25 | US | Maryland | Garrett | 24023 | 5808 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-05-26 04:20:50 | Garrett, Maryland, US | |
623461 | 623461 | 2022-05-22 | US | Maryland | Garrett | 24023 | 5808 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-05-26 04:20:50 | Garrett, Maryland, US | |
2334137 | 2334137 | 2022-05-08 | US | Puerto Rico | Las Piedras | 72085 | 5808 | 0 | 0 | 18.187527 | -65.869468 | 2022-05-09 04:20:54 | Las Piedras, Puerto Rico, US | |
363089 | 363089 | 2022-05-07 | US | Puerto Rico | Hatillo | 72065 | 5808 | 0 | 0 | 18.410928 | -66.796326 | 2022-05-08 04:20:49 | Hatillo, Puerto Rico, US | |
1400712 | 1400712 | 2022-05-06 | US | Texas | Austin | 48015 | 5808 | 73 | 0 | 29.88548725 | -96.27736949 | 2022-05-07 04:21:09 | Austin, Texas, US | |
3917482 | 3917482 | 2022-05-01 | US | Kentucky | Meade | 21163 | 5808 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-05-02 04:21:10 | Meade, Kentucky, US | |
2842286 | 2842286 | 2022-04-30 | US | Kentucky | Meade | 21163 | 5808 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-05-01 04:20:57 | Meade, Kentucky, US | |
1158599 | 1158599 | 2022-04-29 | US | Kentucky | Meade | 21163 | 5808 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-04-30 04:21:05 | Meade, Kentucky, US | |
1697781 | 1697781 | 2022-04-28 | US | Kentucky | Meade | 21163 | 5808 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-04-29 04:20:59 | Meade, Kentucky, US | |
3853264 | 3853264 | 2022-04-27 | US | Kentucky | Meade | 21163 | 5808 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-04-28 04:20:47 | Meade, Kentucky, US | |
1327694 | 1327694 | 2022-04-26 | US | Kentucky | Meade | 21163 | 5808 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-04-27 04:20:52 | Meade, Kentucky, US | |
3723648 | 3723648 | 2022-04-25 | US | Kentucky | Meade | 21163 | 5808 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-04-26 04:20:51 | Meade, Kentucky, US | |
2751980 | 2751980 | 2022-04-04 | US | Texas | Frio | 48163 | 5808 | 93 | 0 | 28.86751206 | -99.10804207 | 2022-04-05 04:20:48 | Frio, Texas, US | |
3733326 | 3733326 | 2022-04-03 | US | Texas | Frio | 48163 | 5808 | 93 | 0 | 28.86751206 | -99.10804207 | 2022-04-04 04:20:51 | Frio, Texas, US | |
3629082 | 3629082 | 2022-03-13 | US | Indiana | Owen | 18119 | 5808 | 110 | 0 | 39.31145587 | -86.83900724 | 2022-03-14 04:20:46 | Owen, Indiana, US | |
3628900 | 3628900 | 2022-03-13 | US | Idaho | Jerome | 16053 | 5808 | 64 | 0 | 42.68891267 | -114.2655033 | 2022-03-14 04:20:46 | Jerome, Idaho, US | |
953791 | 953791 | 2022-03-12 | US | Tennessee | Chester | 47023 | 5808 | 96 | 0 | 35.42527478 | -88.6095842 | 2022-03-13 04:20:49 | Chester, Tennessee, US | |
951990 | 951990 | 2022-03-12 | US | Indiana | Owen | 18119 | 5808 | 110 | 0 | 39.31145587 | -86.83900724 | 2022-03-13 04:20:49 | Owen, Indiana, US | |
951808 | 951808 | 2022-03-12 | US | Idaho | Jerome | 16053 | 5808 | 64 | 0 | 42.68891267 | -114.2655033 | 2022-03-13 04:20:49 | Jerome, Idaho, US | |
359252 | 359252 | 2022-03-11 | US | Tennessee | Chester | 47023 | 5808 | 96 | 0 | 35.42527478 | -88.6095842 | 2022-03-12 04:20:50 | Chester, Tennessee, US | |
357451 | 357451 | 2022-03-11 | US | Indiana | Owen | 18119 | 5808 | 110 | 0 | 39.31145587 | -86.83900724 | 2022-03-12 04:20:50 | Owen, Indiana, US | |
357269 | 357269 | 2022-03-11 | US | Idaho | Jerome | 16053 | 5808 | 64 | 0 | 42.68891267 | -114.2655033 | 2022-03-12 04:20:50 | Jerome, Idaho, US | |
3912819 | 3912819 | 2022-02-20 | US | Georgia | Emanuel | 13107 | 5808 | 150 | 0 | 32.59221302 | -82.30239915 | 2022-02-21 04:21:05 | Emanuel, Georgia, US | |
3876377 | 3876377 | 2022-02-19 | US | Georgia | Emanuel | 13107 | 5808 | 150 | 0 | 32.59221302 | -82.30239915 | 2022-02-20 04:21:00 | Emanuel, Georgia, US | |
3856633 | 3856633 | 2022-02-18 | US | Georgia | Emanuel | 13107 | 5808 | 150 | 0 | 32.59221302 | -82.30239915 | 2022-02-19 04:21:11 | Emanuel, Georgia, US | |
1298852 | 1298852 | 2022-02-17 | US | Georgia | Emanuel | 13107 | 5808 | 150 | 0 | 32.59221302 | -82.30239915 | 2022-02-18 04:21:04 | Emanuel, Georgia, US | |
3823302 | 3823302 | 2022-02-16 | US | South Dakota | Davison | 46035 | 5808 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-02-17 04:20:56 | Davison, South Dakota, US | |
1363766 | 1363766 | 2022-02-08 | US | Kentucky | Harrison | 21097 | 5808 | 58 | 0 | 38.44188174 | -84.32869741 | 2022-02-09 04:21:04 | Harrison, Kentucky, US | |
72952 | 72952 | 2022-02-07 | US | Mississippi | Wayne | 28153 | 5808 | 79 | 0 | 31.64135687 | -88.69573913 | 2022-02-08 04:21:15 | Wayne, Mississippi, US | |
3301882 | 3301882 | 2022-01-30 | US | Michigan | Oceana | 26127 | 5808 | 87 | 0 | 43.64124435 | -86.26726673 | 2022-01-31 04:21:09 | Oceana, Michigan, US | |
3063673 | 3063673 | 2022-01-29 | US | Michigan | Oceana | 26127 | 5808 | 87 | 0 | 43.64124435 | -86.26726673 | 2022-01-30 04:21:26 | Oceana, Michigan, US | |
3811607 | 3811607 | 2022-01-28 | US | Michigan | Oceana | 26127 | 5808 | 87 | 0 | 43.64124435 | -86.26726673 | 2022-01-29 04:21:10 | Oceana, Michigan, US | |
1229803 | 1229803 | 2022-01-24 | US | New Mexico | Cibola | 35006 | 5808 | 166 | 0 | 34.91131525 | -107.998876 | 2022-01-25 04:21:05 | Cibola, New Mexico, US | |
1962386 | 1962386 | 2022-01-20 | US | Mississippi | Marion | 28091 | 5808 | 122 | 0 | 31.23132643 | -89.8209217 | 2022-01-21 04:21:09 | Marion, Mississippi, US | |
1961962 | 1961962 | 2022-01-20 | US | Kentucky | Grant | 21081 | 5808 | 43 | 0 | 38.64962758 | -84.62415957 | 2022-01-21 04:21:09 | Grant, Kentucky, US | |
1475097 | 1475097 | 2022-01-17 | US | Tennessee | Overton | 47133 | 5808 | 114 | 0 | 36.34117832 | -85.28989535 | 2022-01-18 04:21:04 | Overton, Tennessee, US | |
1694055 | 1694055 | 2022-01-10 | US | Minnesota | Lyon | 27083 | 5808 | 68 | 0 | 44.41327865 | -95.83806103 | 2022-01-11 04:22:01 | Lyon, Minnesota, US | |
3831789 | 3831789 | 2021-12-21 | US | Virginia | Charlottesville | 51540 | 5808 | 62 | 0 | 38.03527919 | -78.48569588 | 2021-12-22 04:21:54 | Charlottesville, Virginia, US | |
2198074 | 2198074 | 2021-12-03 | US | Ohio | Champaign | 39021 | 5808 | 97 | 0 | 40.13923427 | -83.76875242 | 2021-12-04 04:22:18 | Champaign, Ohio, US | |
1234316 | 1234316 | 2021-11-28 | US | Pennsylvania | McKean | 42083 | 5808 | 104 | 0 | 41.80938602 | -78.56478358 | 2021-11-29 04:22:30 | McKean, Pennsylvania, US | |
29691 | 29691 | 2021-11-11 | US | Kansas | Cowley | 20035 | 5808 | 127 | 0 | 37.23781842 | -96.83776647 | 2021-11-12 04:22:01 | Cowley, Kansas, US | |
2846130 | 2846130 | 2021-11-10 | US | Kansas | Cowley | 20035 | 5808 | 127 | 0 | 37.23781842 | -96.83776647 | 2021-11-11 04:21:45 | Cowley, Kansas, US | |
3642522 | 3642522 | 2021-11-08 | US | Tennessee | Marion | 47115 | 5808 | 55 | 0 | 35.12997174 | -85.62265895 | 2021-11-09 04:21:36 | Marion, Tennessee, US | |
278927 | 278927 | 2021-11-03 | US | Puerto Rico | Guaynabo | 72061 | 5808 | 0 | 0 | 18.345114000000002 | -66.11452299999999 | 2021-11-04 04:22:20 | Guaynabo, Puerto Rico, US | |
44865 | 44865 | 2021-11-02 | US | Indiana | Whitley | 18183 | 5808 | 56 | 0 | 41.13863784 | -85.50791236 | 2021-11-03 06:22:09 | Whitley, Indiana, 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]);