johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
170 rows where confirmed = 4331 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756319 | 2756319 | 2022-12-29 | US | Virginia | Southampton | 51175 | 4331 | 102 | 0 | 36.72231125 | -77.10642712 | 2022-12-30 04:21:04 | Southampton, Virginia, US | |
1077325 | 1077325 | 2022-12-28 | US | Virginia | Southampton | 51175 | 4331 | 102 | 0 | 36.72231125 | -77.10642712 | 2022-12-29 04:21:01 | Southampton, Virginia, US | |
311447 | 311447 | 2022-12-13 | US | Wisconsin | Lafayette | 55065 | 4331 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-12-14 04:21:04 | Lafayette, Wisconsin, US | |
1622038 | 1622038 | 2022-11-22 | US | Minnesota | Renville | 27129 | 4331 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-11-23 04:21:06 | Renville, Minnesota, US | |
3461926 | 3461926 | 2022-11-21 | US | Minnesota | Renville | 27129 | 4331 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-11-22 04:20:47 | Renville, Minnesota, US | |
1642111 | 1642111 | 2022-11-20 | US | Minnesota | Renville | 27129 | 4331 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-11-21 04:21:05 | Renville, Minnesota, US | |
2065668 | 2065668 | 2022-11-19 | US | Minnesota | Renville | 27129 | 4331 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-11-20 04:21:08 | Renville, Minnesota, US | |
1757062 | 1757062 | 2022-11-18 | US | Minnesota | Renville | 27129 | 4331 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-11-19 04:21:14 | Renville, Minnesota, US | |
3028055 | 3028055 | 2022-11-17 | US | Minnesota | Renville | 27129 | 4331 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-11-18 04:21:15 | Renville, Minnesota, US | |
2758473 | 2758473 | 2022-10-18 | US | Louisiana | West Carroll | 22123 | 4331 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-19 04:22:26 | West Carroll, Louisiana, US | |
2026307 | 2026307 | 2022-10-17 | US | Louisiana | West Carroll | 22123 | 4331 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-18 04:22:42 | West Carroll, Louisiana, US | |
2161085 | 2161085 | 2022-10-16 | US | Louisiana | West Carroll | 22123 | 4331 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-17 04:20:31 | West Carroll, Louisiana, US | |
517282 | 517282 | 2022-10-15 | US | Louisiana | West Carroll | 22123 | 4331 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-16 04:22:39 | West Carroll, Louisiana, US | |
2034339 | 2034339 | 2022-10-14 | US | Louisiana | West Carroll | 22123 | 4331 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-15 04:22:00 | West Carroll, Louisiana, US | |
2325564 | 2325564 | 2022-08-24 | US | New Mexico | Socorro | 35053 | 4331 | 94 | 0 | 34.00715494 | -106.9298354 | 2022-08-25 04:21:13 | Socorro, New Mexico, US | |
3872960 | 3872960 | 2022-07-31 | US | Kentucky | Estill | 21065 | 4331 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-08-01 04:21:03 | Estill, Kentucky, US | |
675714 | 675714 | 2022-07-30 | US | Kentucky | Estill | 21065 | 4331 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-07-31 04:21:02 | Estill, Kentucky, US | |
1784913 | 1784913 | 2022-07-29 | US | Kentucky | Estill | 21065 | 4331 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-07-30 04:20:42 | Estill, Kentucky, US | |
1067276 | 1067276 | 2022-07-28 | US | Kentucky | Estill | 21065 | 4331 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-07-29 04:20:45 | Estill, Kentucky, US | |
2336795 | 2336795 | 2022-07-27 | US | Kentucky | Estill | 21065 | 4331 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-07-28 04:20:56 | Estill, Kentucky, US | |
1488985 | 1488985 | 2022-07-26 | US | Kentucky | Estill | 21065 | 4331 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-07-27 04:21:04 | Estill, Kentucky, US | |
2595431 | 2595431 | 2022-07-25 | US | Kentucky | Estill | 21065 | 4331 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-07-26 04:20:58 | Estill, Kentucky, US | |
3213757 | 3213757 | 2022-07-18 | US | West Virginia | Braxton | 54007 | 4331 | 45 | 0 | 38.70036159 | -80.72011184 | 2022-07-19 04:20:58 | Braxton, West Virginia, US | |
3113079 | 3113079 | 2022-07-13 | US | Wisconsin | Washburn | 55129 | 4331 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-07-14 04:20:57 | Washburn, Wisconsin, US | |
633254 | 633254 | 2022-07-12 | US | Virginia | Giles | 51071 | 4331 | 50 | 0 | 37.31234791 | -80.70636931 | 2022-07-13 04:20:58 | Giles, Virginia, US | |
630936 | 630936 | 2022-07-12 | US | Illinois | Mercer | 17131 | 4331 | 49 | 0 | 41.20596782 | -90.74290052 | 2022-07-13 04:20:58 | Mercer, Illinois, US | |
2790417 | 2790417 | 2022-07-10 | US | Kentucky | Caldwell | 21033 | 4331 | 62 | 0 | 37.14749129 | -87.86948214 | 2022-07-11 04:20:46 | Caldwell, Kentucky, US | |
2789985 | 2789985 | 2022-07-10 | US | Idaho | Minidoka | 16067 | 4331 | 65 | 0 | 42.85518524 | -113.6357257 | 2022-07-11 04:20:46 | Minidoka, Idaho, US | |
144764 | 144764 | 2022-07-09 | US | Puerto Rico | Sabana Grande | 72121 | 4331 | 0 | 0 | 18.08282 | -66.943758 | 2022-07-10 04:20:54 | Sabana Grande, Puerto Rico, US | |
143370 | 143370 | 2022-07-09 | US | Kentucky | Caldwell | 21033 | 4331 | 62 | 0 | 37.14749129 | -87.86948214 | 2022-07-10 04:20:54 | Caldwell, Kentucky, US | |
142938 | 142938 | 2022-07-09 | US | Idaho | Minidoka | 16067 | 4331 | 65 | 0 | 42.85518524 | -113.6357257 | 2022-07-10 04:20:54 | Minidoka, Idaho, US | |
1418470 | 1418470 | 2022-07-08 | US | Kentucky | Caldwell | 21033 | 4331 | 62 | 0 | 37.14749129 | -87.86948214 | 2022-07-09 04:20:59 | Caldwell, Kentucky, US | |
1418038 | 1418038 | 2022-07-08 | US | Idaho | Minidoka | 16067 | 4331 | 65 | 0 | 42.85518524 | -113.6357257 | 2022-07-09 04:20:59 | Minidoka, Idaho, US | |
2742395 | 2742395 | 2022-07-07 | US | Kentucky | Caldwell | 21033 | 4331 | 62 | 0 | 37.14749129 | -87.86948214 | 2022-07-08 04:20:56 | Caldwell, Kentucky, US | |
1201190 | 1201190 | 2022-07-06 | US | Kentucky | Caldwell | 21033 | 4331 | 62 | 0 | 37.14749129 | -87.86948214 | 2022-07-07 04:20:55 | Caldwell, Kentucky, US | |
3967933 | 3967933 | 2022-07-05 | US | Kentucky | Caldwell | 21033 | 4331 | 62 | 0 | 37.14749129 | -87.86948214 | 2022-07-06 04:20:58 | Caldwell, Kentucky, US | |
1766320 | 1766320 | 2022-06-20 | US | Tennessee | Sequatchie | 47153 | 4331 | 69 | 0 | 35.36979721 | -85.41022136 | 2022-06-21 04:20:56 | Sequatchie, Tennessee, US | |
3593996 | 3593996 | 2022-05-23 | US | Illinois | Carroll | 17015 | 4331 | 48 | 0 | 42.06823429 | -89.93395545 | 2022-05-24 04:20:57 | Carroll, Illinois, US | |
2031561 | 2031561 | 2022-04-24 | US | Puerto Rico | Yabucoa | 72151 | 4331 | 0 | 0 | 18.070399 | -65.896289 | 2022-04-25 04:20:56 | Yabucoa, Puerto Rico, US | |
3417899 | 3417899 | 2022-04-17 | US | Illinois | De Witt | 17039 | 4331 | 37 | 0 | 40.17514519 | -88.90959682 | 2022-04-18 04:21:12 | De Witt, Illinois, US | |
304848 | 304848 | 2022-04-16 | US | Illinois | De Witt | 17039 | 4331 | 37 | 0 | 40.17514519 | -88.90959682 | 2022-04-17 04:20:59 | De Witt, Illinois, US | |
2670793 | 2670793 | 2022-04-15 | US | Illinois | De Witt | 17039 | 4331 | 37 | 0 | 40.17514519 | -88.90959682 | 2022-04-16 04:20:48 | De Witt, Illinois, US | |
3209789 | 3209789 | 2022-04-11 | US | West Virginia | Wetzel | 54103 | 4331 | 83 | 0 | 39.6065771 | -80.64016540000001 | 2022-04-12 04:20:49 | Wetzel, West Virginia, US | |
1996091 | 1996091 | 2022-03-01 | US | Washington | Asotin | 53003 | 4331 | 61 | 0 | 46.18894415 | -117.2022851 | 2022-03-02 04:21:07 | Asotin, Washington, US | |
946265 | 946265 | 2022-02-28 | US | Washington | Asotin | 53003 | 4331 | 61 | 0 | 46.18894415 | -117.2022851 | 2022-03-01 04:21:09 | Asotin, Washington, US | |
1514135 | 1514135 | 2022-02-24 | US | Puerto Rico | Camuy | 72027 | 4331 | 0 | 0 | 18.418578 | -66.860206 | 2022-02-25 04:21:11 | Camuy, Puerto Rico, US | |
1058493 | 1058493 | 2022-02-23 | US | Colorado | Otero | 8089 | 4331 | 128 | 0 | 37.9014485 | -103.7173385 | 2022-02-24 04:21:14 | Otero, Colorado, US | |
2447261 | 2447261 | 2022-02-22 | US | Arkansas | Grant | 5053 | 4331 | 56 | 0 | 34.29017991 | -92.42320562 | 2022-02-23 04:21:09 | Grant, Arkansas, US | |
3913108 | 3913108 | 2022-02-20 | US | Indiana | Franklin | 18047 | 4331 | 54 | 0 | 39.4142482 | -85.06062647 | 2022-02-21 04:21:05 | Franklin, Indiana, US | |
3876666 | 3876666 | 2022-02-19 | US | Indiana | Franklin | 18047 | 4331 | 54 | 0 | 39.4142482 | -85.06062647 | 2022-02-20 04:21:00 | Franklin, Indiana, US | |
3856922 | 3856922 | 2022-02-18 | US | Indiana | Franklin | 18047 | 4331 | 54 | 0 | 39.4142482 | -85.06062647 | 2022-02-19 04:21:11 | Franklin, Indiana, US | |
1299485 | 1299485 | 2022-02-17 | US | Kentucky | Lewis | 21135 | 4331 | 78 | 0 | 38.53184419 | -83.37735618 | 2022-02-18 04:21:04 | Lewis, Kentucky, US | |
3076176 | 3076176 | 2022-02-09 | US | Nebraska | Washington | 31177 | 4331 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-02-10 04:21:14 | Washington, Nebraska, US | |
71117 | 71117 | 2022-02-07 | Japan | Tottori | 4331 | 5 | 0 | 35.359069 | 133.863619 | 2022-02-08 04:21:15 | Tottori, Japan | |||
982328 | 982328 | 2022-02-01 | US | Virginia | New Kent | 51127 | 4331 | 28 | 0 | 37.50694406 | -76.99828634 | 2022-02-02 04:21:09 | New Kent, Virginia, US | |
2659257 | 2659257 | 2022-01-31 | US | Kentucky | Rockcastle | 21203 | 4331 | 51 | 0 | 37.36642393 | -84.31176452 | 2022-02-01 04:21:11 | Rockcastle, Kentucky, US | |
1319013 | 1319013 | 2022-01-26 | US | Georgia | Elbert | 13105 | 4331 | 97 | 0 | 34.11302332 | -82.83936148 | 2022-01-27 04:21:19 | Elbert, Georgia, US | |
1117013 | 1117013 | 2022-01-11 | US | Virginia | Waynesboro | 51820 | 4331 | 55 | 0 | 38.06451466 | -78.90293905 | 2022-01-12 04:21:44 | Waynesboro, Virginia, US | |
1115003 | 1115003 | 2022-01-11 | US | Kentucky | Harrison | 21097 | 4331 | 57 | 0 | 38.44188174 | -84.32869741 | 2022-01-12 04:21:44 | Harrison, Kentucky, US | |
1693442 | 1693442 | 2022-01-10 | US | Indiana | Owen | 18119 | 4331 | 90 | 0 | 39.31145587 | -86.83900724 | 2022-01-11 04:22:01 | Owen, Indiana, US | |
1702637 | 1702637 | 2022-01-03 | US | North Carolina | Anson | 37007 | 4331 | 86 | 0 | 34.97403241 | -80.09953279 | 2022-01-04 04:22:17 | Anson, North Carolina, US | |
3522928 | 3522928 | 2022-01-02 | US | West Virginia | Mason | 54053 | 4331 | 69 | 0 | 38.77071799 | -82.02524219 | 2022-01-03 02:22:25 | Mason, West Virginia, US | |
2171058 | 2171058 | 2022-01-01 | US | West Virginia | Mason | 54053 | 4331 | 69 | 0 | 38.77071799 | -82.02524219 | 2022-01-02 04:20:52 | Mason, West Virginia, US | |
2780489 | 2780489 | 2021-12-31 | US | West Virginia | Mason | 54053 | 4331 | 69 | 0 | 38.77071799 | -82.02524219 | 2022-01-01 04:22:14 | Mason, West Virginia, US | |
4002146 | 4002146 | 2021-12-30 | US | West Virginia | Mason | 54053 | 4331 | 69 | 0 | 38.77071799 | -82.02524219 | 2021-12-31 04:21:50 | Mason, West Virginia, US | |
1433874 | 1433874 | 2021-12-28 | US | Kansas | Labette | 20099 | 4331 | 65 | 0 | 37.19113093 | -95.29849679 | 2021-12-29 03:21:43 | Labette, Kansas, US | |
731835 | 731835 | 2021-12-27 | US | Kansas | Labette | 20099 | 4331 | 64 | 0 | 37.19113093 | -95.29849679 | 2021-12-28 04:21:47 | Labette, Kansas, US | |
2112832 | 2112832 | 2021-12-26 | US | Indiana | Randolph | 18135 | 4331 | 115 | 0 | 40.15734772 | -85.01139319 | 2021-12-27 04:21:58 | Randolph, Indiana, US | |
3606204 | 3606204 | 2021-12-25 | US | Indiana | Randolph | 18135 | 4331 | 115 | 0 | 40.15734772 | -85.01139319 | 2021-12-26 04:21:50 | Randolph, Indiana, US | |
2964522 | 2964522 | 2021-12-24 | US | Indiana | Randolph | 18135 | 4331 | 115 | 0 | 40.15734772 | -85.01139319 | 2021-12-25 04:21:37 | Randolph, Indiana, US | |
3817554 | 3817554 | 2021-12-23 | US | Indiana | Randolph | 18135 | 4331 | 115 | 0 | 40.15734772 | -85.01139319 | 2021-12-24 04:21:34 | Randolph, Indiana, US | |
799562 | 799562 | 2021-12-22 | US | Indiana | Randolph | 18135 | 4331 | 115 | 0 | 40.15734772 | -85.01139319 | 2021-12-23 04:21:21 | Randolph, Indiana, US | |
3831031 | 3831031 | 2021-12-21 | US | Oklahoma | Jackson | 40065 | 4331 | 86 | 0 | 34.58781741 | -99.41138784 | 2021-12-22 04:21:54 | Jackson, Oklahoma, US | |
1257334 | 1257334 | 2021-12-20 | US | Oklahoma | Jackson | 40065 | 4331 | 86 | 0 | 34.58781741 | -99.41138784 | 2021-12-21 03:21:27 | Jackson, Oklahoma, US | |
2906277 | 2906277 | 2021-12-19 | US | Oklahoma | Jackson | 40065 | 4331 | 86 | 0 | 34.58781741 | -99.41138784 | 2021-12-20 04:21:43 | Jackson, Oklahoma, US | |
1261350 | 1261350 | 2021-12-18 | US | Oklahoma | Jackson | 40065 | 4331 | 86 | 0 | 34.58781741 | -99.41138784 | 2021-12-19 04:21:11 | Jackson, Oklahoma, US | |
2401378 | 2401378 | 2021-12-17 | US | Oklahoma | Jackson | 40065 | 4331 | 86 | 0 | 34.58781741 | -99.41138784 | 2021-12-18 02:22:20 | Jackson, Oklahoma, US | |
1718916 | 1718916 | 2021-12-16 | US | Oklahoma | Jackson | 40065 | 4331 | 86 | 0 | 34.58781741 | -99.41138784 | 2021-12-17 04:22:14 | Jackson, Oklahoma, US | |
1718491 | 1718491 | 2021-12-16 | US | Nevada | Churchill | 32001 | 4331 | 87 | 0 | 39.58105744 | -118.3394607 | 2021-12-17 04:22:14 | Churchill, Nevada, US | |
3499327 | 3499327 | 2021-12-15 | US | Texas | Karnes | 48255 | 4331 | 58 | 0 | 28.90705334 | -97.85960149 | 2021-12-16 04:22:11 | Karnes, Texas, US | |
3498750 | 3498750 | 2021-12-15 | US | Oklahoma | Jackson | 40065 | 4331 | 86 | 0 | 34.58781741 | -99.41138784 | 2021-12-16 04:22:11 | Jackson, Oklahoma, US | |
551650 | 551650 | 2021-12-08 | US | Georgia | Sumter | 13261 | 4331 | 138 | 0 | 32.03650571 | -84.19821492 | 2021-12-09 04:22:49 | Sumter, Georgia, US | |
1032226 | 1032226 | 2021-12-06 | US | Mississippi | Sunflower | 28133 | 4331 | 106 | 0 | 33.60192578 | -90.58882684 | 2021-12-07 04:22:34 | Sunflower, Mississippi, US | |
1743472 | 1743472 | 2021-12-05 | US | Tennessee | DeKalb | 47041 | 4331 | 77 | 0 | 35.97616272 | -85.83689361 | 2021-12-06 04:22:34 | DeKalb, Tennessee, US | |
3071133 | 3071133 | 2021-11-23 | US | Indiana | Jennings | 18079 | 4331 | 66 | 0 | 38.99588883 | -85.62710784 | 2021-11-24 04:22:14 | Jennings, Indiana, US | |
3751168 | 3751168 | 2021-11-22 | US | Nebraska | Adams | 31001 | 4331 | 46 | 0 | 40.52449420000001 | -98.50117804 | 2021-11-23 04:22:39 | Adams, Nebraska, US | |
162970 | 162970 | 2021-11-19 | US | Idaho | Jerome | 16053 | 4331 | 53 | 0 | 42.68891267 | -114.2655033 | 2021-11-20 04:22:17 | Jerome, Idaho, US | |
2001659 | 2001659 | 2021-11-07 | US | Illinois | Iroquois | 17075 | 4331 | 80 | 0 | 40.74717633 | -87.82466784 | 2021-11-08 04:21:43 | Iroquois, Illinois, US | |
496650 | 496650 | 2021-11-06 | US | Illinois | Iroquois | 17075 | 4331 | 80 | 0 | 40.74717633 | -87.82466784 | 2021-11-07 04:21:53 | Iroquois, Illinois, US | |
3122505 | 3122505 | 2021-11-05 | US | Illinois | Iroquois | 17075 | 4331 | 80 | 0 | 40.74717633 | -87.82466784 | 2021-11-06 04:21:51 | Iroquois, Illinois, US | |
277338 | 277338 | 2021-11-03 | US | Indiana | Wells | 18179 | 4331 | 89 | 0 | 40.72934187 | -85.22132966 | 2021-11-04 04:22:20 | Wells, Indiana, US | |
3493490 | 3493490 | 2021-10-26 | US | Kansas | Miami | 20121 | 4331 | 59 | 0 | 38.56383358 | -94.83832189 | 2021-10-27 04:22:32 | Miami, Kansas, US | |
3795212 | 3795212 | 2021-10-25 | US | Kansas | Miami | 20121 | 4331 | 59 | 0 | 38.56383358 | -94.83832189 | 2021-10-26 04:22:09 | Miami, Kansas, US | |
771804 | 771804 | 2021-10-23 | US | Kentucky | Ohio | 21183 | 4331 | 80 | 0 | 37.47751843 | -86.85368087 | 2021-10-24 04:21:22 | Ohio, Kentucky, US | |
2044893 | 2044893 | 2021-10-18 | US | Illinois | Saline | 17165 | 4331 | 69 | 0 | 37.75332999 | -88.54119706 | 2021-10-19 04:20:54 | Saline, Illinois, US | |
1237173 | 1237173 | 2021-09-27 | US | Louisiana | Sabine | 22085 | 4331 | 80 | 0 | 31.56388699 | -93.55433981 | 2021-09-28 04:21:28 | Sabine, Louisiana, US | |
812074 | 812074 | 2021-09-20 | US | Ohio | Ottawa | 39123 | 4331 | 86 | 0 | 41.53781826 | -83.0940185 | 2021-09-21 04:21:26 | Ottawa, Ohio, US | |
3807334 | 3807334 | 2021-09-11 | US | Kentucky | Logan | 21141 | 4331 | 77 | 0 | 36.85949479 | -86.877635 | 2021-09-12 04:21:13 | Logan, Kentucky, US | |
3806535 | 3806535 | 2021-09-11 | US | Colorado | Logan | 8075 | 4331 | 77 | 0 | 40.7249637 | -103.110817 | 2021-09-12 04:21:13 | Logan, Colorado, US | |
643407 | 643407 | 2021-09-07 | US | Kentucky | Taylor | 21217 | 4331 | 60 | 0 | 37.3677562 | -85.3329931 | 2021-09-08 04:21:31 | Taylor, 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]);