johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
172 rows where confirmed = 4671 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
546161 | 546161 | 2022-12-15 | US | Virginia | Patrick | 51141 | 4671 | 102 | 0 | 36.6801638 | -80.2865648 | 2022-12-16 04:21:01 | Patrick, Virginia, US | |
2816580 | 2816580 | 2022-12-03 | China | Shanxi | 4671 | 0 | 0 | 37.5777 | 112.2922 | 2022-12-04 04:20:56 | Shanxi, China | |||
3314802 | 3314802 | 2022-11-23 | US | Oklahoma | Kingfisher | 40073 | 4671 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-11-24 04:21:09 | Kingfisher, Oklahoma, US | |
1622843 | 1622843 | 2022-11-22 | US | Oklahoma | Kingfisher | 40073 | 4671 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-11-23 04:21:06 | Kingfisher, Oklahoma, US | |
3462731 | 3462731 | 2022-11-21 | US | Oklahoma | Kingfisher | 40073 | 4671 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-11-22 04:20:47 | Kingfisher, Oklahoma, US | |
1642916 | 1642916 | 2022-11-20 | US | Oklahoma | Kingfisher | 40073 | 4671 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-11-21 04:21:05 | Kingfisher, Oklahoma, US | |
2066473 | 2066473 | 2022-11-19 | US | Oklahoma | Kingfisher | 40073 | 4671 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-11-20 04:21:08 | Kingfisher, Oklahoma, US | |
1757867 | 1757867 | 2022-11-18 | US | Oklahoma | Kingfisher | 40073 | 4671 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-11-19 04:21:14 | Kingfisher, Oklahoma, US | |
3028860 | 3028860 | 2022-11-17 | US | Oklahoma | Kingfisher | 40073 | 4671 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-11-18 04:21:15 | Kingfisher, Oklahoma, US | |
2432804 | 2432804 | 2022-11-09 | US | Mississippi | Yalobusha | 28161 | 4671 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-11-10 04:21:16 | Yalobusha, Mississippi, US | |
481460 | 481460 | 2022-11-08 | US | Mississippi | Yalobusha | 28161 | 4671 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-11-09 04:21:22 | Yalobusha, Mississippi, US | |
2440610 | 2440610 | 2022-11-07 | US | Mississippi | Yalobusha | 28161 | 4671 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-11-08 04:21:21 | Yalobusha, Mississippi, US | |
1051708 | 1051708 | 2022-11-06 | US | Mississippi | Yalobusha | 28161 | 4671 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-11-07 04:21:26 | Yalobusha, Mississippi, US | |
619732 | 619732 | 2022-11-05 | US | Mississippi | Yalobusha | 28161 | 4671 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-11-06 04:21:24 | Yalobusha, Mississippi, US | |
1024236 | 1024236 | 2022-11-04 | US | Mississippi | Yalobusha | 28161 | 4671 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-11-05 04:21:52 | Yalobusha, Mississippi, US | |
433227 | 433227 | 2022-11-03 | US | Mississippi | Yalobusha | 28161 | 4671 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-11-04 04:22:11 | Yalobusha, Mississippi, US | |
851469 | 851469 | 2022-11-02 | US | Mississippi | Yalobusha | 28161 | 4671 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-11-03 04:22:05 | Yalobusha, Mississippi, US | |
198044 | 198044 | 2022-10-19 | China | Fujian | 4671 | 1 | 0 | 26.0789 | 117.9874 | 2022-10-20 04:22:59 | Fujian, China | |||
2163114 | 2163114 | 2022-10-16 | US | Wisconsin | Richland | 55103 | 4671 | 52 | 0 | 43.3762778 | -90.43012729 | 2022-10-17 04:20:31 | Richland, Wisconsin, US | |
519311 | 519311 | 2022-10-15 | US | Wisconsin | Richland | 55103 | 4671 | 52 | 0 | 43.3762778 | -90.43012729 | 2022-10-16 04:22:39 | Richland, Wisconsin, US | |
2036368 | 2036368 | 2022-10-14 | US | Wisconsin | Richland | 55103 | 4671 | 52 | 0 | 43.3762778 | -90.43012729 | 2022-10-15 04:22:00 | Richland, Wisconsin, US | |
3253305 | 3253305 | 2022-10-11 | US | Texas | Lavaca | 48285 | 4671 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-10-12 04:22:51 | Lavaca, Texas, US | |
2970564 | 2970564 | 2022-10-10 | US | Texas | Lavaca | 48285 | 4671 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-10-11 04:23:05 | Lavaca, Texas, US | |
2968437 | 2968437 | 2022-10-10 | US | Illinois | Mercer | 17131 | 4671 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-10-11 04:23:05 | Mercer, Illinois, US | |
3098473 | 3098473 | 2022-10-09 | US | Illinois | Mercer | 17131 | 4671 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-10-10 04:22:32 | Mercer, Illinois, US | |
4003698 | 4003698 | 2022-10-08 | US | Illinois | Mercer | 17131 | 4671 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-10-09 04:21:16 | Mercer, Illinois, US | |
397295 | 397295 | 2022-10-07 | US | Illinois | Mercer | 17131 | 4671 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-10-08 04:22:56 | Mercer, Illinois, US | |
1625786 | 1625786 | 2022-09-22 | US | Louisiana | Bienville | 22013 | 4671 | 115 | 0 | 32.34569994 | -93.05398492 | 2022-09-23 04:23:13 | Bienville, Louisiana, US | |
420412 | 420412 | 2022-09-18 | US | Indiana | Carroll | 18015 | 4671 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-09-19 04:21:49 | Carroll, Indiana, US | |
3374436 | 3374436 | 2022-09-17 | US | Indiana | Carroll | 18015 | 4671 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-09-18 04:22:50 | Carroll, Indiana, US | |
2356544 | 2356544 | 2022-09-16 | US | Indiana | Carroll | 18015 | 4671 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-09-17 04:20:19 | Carroll, Indiana, US | |
3769041 | 3769041 | 2022-09-11 | US | Texas | Llano | 48299 | 4671 | 98 | 0 | 30.70645047 | -98.68475262 | 2022-09-12 04:20:58 | Llano, Texas, US | |
3827616 | 3827616 | 2022-09-10 | US | Texas | Llano | 48299 | 4671 | 98 | 0 | 30.70645047 | -98.68475262 | 2022-09-11 04:20:50 | Llano, Texas, US | |
966073 | 966073 | 2022-09-09 | US | Texas | Llano | 48299 | 4671 | 98 | 0 | 30.70645047 | -98.68475262 | 2022-09-10 04:21:10 | Llano, Texas, US | |
992177 | 992177 | 2022-08-16 | US | Iowa | Crawford | 19047 | 4671 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-08-17 04:20:59 | Crawford, Iowa, US | |
2495216 | 2495216 | 2022-08-15 | US | Iowa | Crawford | 19047 | 4671 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-08-16 04:20:58 | Crawford, Iowa, US | |
3648766 | 3648766 | 2022-08-14 | US | Iowa | Crawford | 19047 | 4671 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-08-15 04:20:59 | Crawford, Iowa, US | |
1969772 | 1969772 | 2022-08-13 | US | Iowa | Crawford | 19047 | 4671 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-08-14 04:20:55 | Crawford, Iowa, US | |
2889581 | 2889581 | 2022-08-12 | US | Iowa | Crawford | 19047 | 4671 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-08-13 04:20:52 | Crawford, Iowa, US | |
3909186 | 3909186 | 2022-08-11 | US | Iowa | Crawford | 19047 | 4671 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-08-12 04:20:54 | Crawford, Iowa, US | |
1347503 | 1347503 | 2022-08-10 | US | Iowa | Crawford | 19047 | 4671 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-08-11 04:20:49 | Crawford, Iowa, US | |
1069225 | 1069225 | 2022-07-28 | US | Virginia | Goochland | 51075 | 4671 | 55 | 0 | 37.71714806 | -77.90381514 | 2022-07-29 04:20:45 | Goochland, Virginia, US | |
3110130 | 3110130 | 2022-07-13 | US | Colorado | Otero | 8089 | 4671 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-07-14 04:20:57 | Otero, Colorado, US | |
2147525 | 2147525 | 2022-06-27 | France | Saint Barthelemy | 4671 | 6 | 0 | 17.9 | -62.8333 | 2022-06-28 04:20:58 | Saint Barthelemy, France | |||
475326 | 475326 | 2022-06-26 | France | Saint Barthelemy | 4671 | 6 | 0 | 17.9 | -62.8333 | 2022-06-27 04:21:00 | Saint Barthelemy, France | |||
938701 | 938701 | 2022-06-25 | France | Saint Barthelemy | 4671 | 6 | 0 | 17.9 | -62.8333 | 2022-06-26 04:21:02 | Saint Barthelemy, France | |||
3346521 | 3346521 | 2022-06-24 | France | Saint Barthelemy | 4671 | 6 | 0 | 17.9 | -62.8333 | 2022-06-25 04:20:57 | Saint Barthelemy, France | |||
1648262 | 1648262 | 2022-06-23 | France | Saint Barthelemy | 4671 | 6 | 0 | 17.9 | -62.8333 | 2022-06-24 04:20:58 | Saint Barthelemy, France | |||
2187497 | 2187497 | 2022-06-22 | France | Saint Barthelemy | 4671 | 6 | 0 | 17.9 | -62.8333 | 2022-06-23 04:20:55 | Saint Barthelemy, France | |||
165928 | 165928 | 2022-06-21 | France | Saint Barthelemy | 4671 | 6 | 0 | 17.9 | -62.8333 | 2022-06-22 04:20:54 | Saint Barthelemy, France | |||
3025192 | 3025192 | 2022-03-23 | US | Tennessee | Bledsoe | 47007 | 4671 | 56 | 0 | 35.59942968 | -85.20611967 | 2022-03-24 04:20:43 | Bledsoe, Tennessee, US | |
1908114 | 1908114 | 2022-03-22 | US | Tennessee | Bledsoe | 47007 | 4671 | 56 | 0 | 35.59942968 | -85.20611967 | 2022-03-23 04:20:48 | Bledsoe, Tennessee, US | |
3241245 | 3241245 | 2022-03-21 | US | Tennessee | Bledsoe | 47007 | 4671 | 56 | 0 | 35.59942968 | -85.20611967 | 2022-03-22 04:20:54 | Bledsoe, Tennessee, US | |
27318 | 27318 | 2022-03-20 | US | Tennessee | Bledsoe | 47007 | 4671 | 56 | 0 | 35.59942968 | -85.20611967 | 2022-03-21 04:20:50 | Bledsoe, Tennessee, US | |
1659328 | 1659328 | 2022-03-19 | US | Tennessee | Bledsoe | 47007 | 4671 | 56 | 0 | 35.59942968 | -85.20611967 | 2022-03-20 04:20:45 | Bledsoe, Tennessee, US | |
338854 | 338854 | 2022-03-18 | US | Tennessee | Bledsoe | 47007 | 4671 | 56 | 0 | 35.59942968 | -85.20611967 | 2022-03-19 04:20:47 | Bledsoe, Tennessee, US | |
697307 | 697307 | 2022-03-17 | US | Tennessee | Bledsoe | 47007 | 4671 | 56 | 0 | 35.59942968 | -85.20611967 | 2022-03-18 04:20:55 | Bledsoe, Tennessee, US | |
2322250 | 2322250 | 2022-03-16 | US | Tennessee | Bledsoe | 47007 | 4671 | 56 | 0 | 35.59942968 | -85.20611967 | 2022-03-17 04:20:56 | Bledsoe, Tennessee, US | |
263508 | 263508 | 2022-03-15 | US | Missouri | Texas | 29215 | 4671 | 96 | 0 | 37.31728859 | -91.96564727 | 2022-03-16 04:20:50 | Texas, Missouri, US | |
2201359 | 2201359 | 2022-03-06 | US | Minnesota | Fillmore | 27045 | 4671 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-03-07 04:20:47 | Fillmore, Minnesota, US | |
2093816 | 2093816 | 2022-03-05 | US | Minnesota | Fillmore | 27045 | 4671 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-03-06 04:20:49 | Fillmore, Minnesota, US | |
2667516 | 2667516 | 2022-03-04 | US | Minnesota | Fillmore | 27045 | 4671 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-03-05 04:21:10 | Fillmore, Minnesota, US | |
2525742 | 2525742 | 2022-03-02 | US | Alabama | Hale | 1065 | 4671 | 99 | 0 | 32.76039258 | -87.63284988 | 2022-03-03 04:21:01 | Hale, Alabama, US | |
2448177 | 2448177 | 2022-02-22 | US | Kentucky | Garrard | 21079 | 4671 | 69 | 0 | 37.638866799999995 | -84.53289319 | 2022-02-23 04:21:09 | Garrard, Kentucky, US | |
3077439 | 3077439 | 2022-02-09 | US | Virginia | Powhatan | 51145 | 4671 | 43 | 0 | 37.55016038 | -77.91267882 | 2022-02-10 04:21:14 | Powhatan, Virginia, US | |
1364077 | 1364077 | 2022-02-08 | US | Minnesota | Hubbard | 27057 | 4671 | 56 | 0 | 47.10778564 | -94.91693868 | 2022-02-09 04:21:04 | Hubbard, Minnesota, US | |
981216 | 981216 | 2022-02-01 | US | New York | Schoharie | 36095 | 4671 | 33 | 0 | 42.58831742 | -74.44339029999998 | 2022-02-02 04:21:09 | Schoharie, New York, US | |
3228040 | 3228040 | 2022-01-19 | US | Maryland | Somerset | 24039 | 4671 | 63 | 0 | 38.1163542 | -75.75118623 | 2022-01-20 04:21:07 | Somerset, Maryland, US | |
3688008 | 3688008 | 2022-01-13 | US | Arkansas | Sevier | 5133 | 4671 | 63 | 0 | 33.99780401 | -94.2424869 | 2022-01-14 04:21:54 | Sevier, Arkansas, US | |
800904 | 800904 | 2021-12-22 | US | Ohio | Henry | 39069 | 4671 | 92 | 0 | 41.333964200000004 | -84.06830637 | 2021-12-23 04:21:21 | Henry, Ohio, US | |
1261731 | 1261731 | 2021-12-18 | US | Tennessee | Grainger | 47057 | 4671 | 75 | 0 | 36.27469206 | -83.51254721 | 2021-12-19 04:21:11 | Grainger, Tennessee, US | |
3499490 | 3499490 | 2021-12-15 | US | Virginia | Amherst | 51009 | 4671 | 62 | 0 | 37.60308293 | -79.14548696 | 2021-12-16 04:22:11 | Amherst, Virginia, US | |
3497223 | 3497223 | 2021-12-15 | US | Illinois | Perry | 17145 | 4671 | 80 | 0 | 38.08510853 | -89.36856219 | 2021-12-16 04:22:11 | Perry, Illinois, US | |
3655968 | 3655968 | 2021-12-10 | US | Alabama | Geneva | 1061 | 4671 | 137 | 0 | 31.09389027 | -85.83572839 | 2021-12-11 04:22:45 | Geneva, Alabama, US | |
553214 | 553214 | 2021-12-08 | US | Ohio | Adams | 39001 | 4671 | 116 | 0 | 38.84541072 | -83.4718964 | 2021-12-09 04:22:49 | Adams, Ohio, US | |
2197595 | 2197595 | 2021-12-03 | US | Missouri | Stoddard | 29207 | 4671 | 106 | 0 | 36.85571651 | -89.9444155 | 2021-12-04 04:22:18 | Stoddard, Missouri, US | |
2301 | 2301 | 2021-12-02 | US | Missouri | Stoddard | 29207 | 4671 | 106 | 0 | 36.85571651 | -89.9444155 | 2021-12-03 04:23:05 | Stoddard, Missouri, US | |
1017002 | 1017002 | 2021-11-21 | US | Pennsylvania | Elk | 42047 | 4671 | 65 | 0 | 41.42822061 | -78.64524744 | 2021-11-22 04:22:20 | Elk, Pennsylvania, US | |
449518 | 449518 | 2021-11-17 | US | Nevada | Nye | 32023 | 4671 | 166 | 0 | 38.04264256 | -116.47227020000001 | 2021-11-18 04:21:33 | Nye, Nevada, US | |
493147 | 493147 | 2021-10-14 | US | Louisiana | Jefferson Davis | 22053 | 4671 | 124 | 0 | 30.26896765 | -92.81210004 | 2021-10-15 04:21:26 | Jefferson Davis, Louisiana, US | |
1495063 | 1495063 | 2021-10-12 | US | Washington | Stevens | 53065 | 4671 | 78 | 0 | 48.40035475 | -117.8542701 | 2021-10-13 04:20:51 | Stevens, Washington, US | |
2962881 | 2962881 | 2021-10-08 | US | West Virginia | Preston | 54077 | 4671 | 66 | 0 | 39.46770987 | -79.66712803 | 2021-10-09 04:21:34 | Preston, West Virginia, US | |
2960031 | 2960031 | 2021-10-08 | US | Colorado | Summit | 8117 | 4671 | 11 | 0 | 39.63803232 | -106.1150762 | 2021-10-09 04:21:34 | Summit, Colorado, US | |
990564 | 990564 | 2021-10-04 | US | Wisconsin | Trempealeau | 55121 | 4671 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-10-05 04:21:27 | Trempealeau, Wisconsin, US | |
2773879 | 2773879 | 2021-09-30 | US | Georgia | White | 13311 | 4671 | 116 | 0 | 34.64624278 | -83.74905525 | 2021-10-01 04:21:35 | White, Georgia, US | |
1235646 | 1235646 | 2021-09-27 | Japan | Kagawa | 4671 | 36 | 0 | 34.217292 | 133.969047 | 2021-09-28 04:21:28 | Kagawa, Japan | |||
2075947 | 2075947 | 2021-09-26 | Japan | Kagawa | 4671 | 36 | 0 | 34.217292 | 133.969047 | 2021-09-27 04:21:16 | Kagawa, Japan | |||
3283817 | 3283817 | 2021-09-05 | US | Tennessee | Henderson | 47077 | 4671 | 82 | 0 | 35.65581134 | -88.38600175 | 2021-09-06 04:21:22 | Henderson, Tennessee, US | |
179297 | 179297 | 2021-09-02 | US | Kansas | Cowley | 20035 | 4671 | 116 | 0 | 37.23781842 | -96.83776647 | 2021-09-03 04:21:20 | Cowley, Kansas, US | |
68332 | 68332 | 2021-09-01 | US | Kansas | Cowley | 20035 | 4671 | 116 | 0 | 37.23781842 | -96.83776647 | 2021-09-02 04:21:15 | Cowley, Kansas, US | |
67065 | 67065 | 2021-09-01 | Japan | Ehime | 4671 | 80 | 0 | 33.624835 | 132.856842 | 2021-09-02 04:21:15 | Ehime, Japan | |||
3108533 | 3108533 | 2021-08-24 | US | Texas | Erath | 48143 | 4671 | 72 | 0 | 32.23602653 | -98.21773417 | 2021-08-25 04:21:41 | Erath, Texas, US | |
3106942 | 3106942 | 2021-08-24 | US | Louisiana | Beauregard | 22011 | 4671 | 87 | 0 | 30.64836518 | -93.34173616 | 2021-08-25 04:21:41 | Beauregard, Louisiana, US | |
1486800 | 1486800 | 2021-08-13 | US | Texas | Waller | 48473 | 4671 | 52 | 0 | 30.01058447 | -95.99011759 | 2021-08-14 04:21:25 | Waller, Texas, US | |
1344503 | 1344503 | 2021-08-11 | US | New Mexico | Unassigned | 90035 | 4671 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-08-12 04:21:25 | Unassigned, New Mexico, US | |
1343769 | 1343769 | 2021-08-11 | US | Kentucky | Whitley | 21235 | 4671 | 63 | 0 | 36.75700531 | -84.14541217 | 2021-08-12 04:21:25 | Whitley, Kentucky, US | |
1956898 | 1956898 | 2021-08-05 | US | Alabama | Franklin | 1059 | 4671 | 81 | 0 | 34.44235334 | -87.84289505 | 2021-08-06 04:21:18 | Franklin, Alabama, US | |
3468100 | 3468100 | 2021-08-03 | Germany | Unknown | 4671 | 0 | 0 | 4671 | 2021-08-04 04:21:25 | Unknown, Germany | ||||
3221273 | 3221273 | 2021-07-26 | US | Tennessee | Obion | 47131 | 4671 | 97 | 0 | 36.35732446 | -89.14921589 | 2021-07-27 04:21:18 | Obion, Tennessee, US | |
2375166 | 2375166 | 2021-07-20 | United Kingdom | Gibraltar | 4671 | 94 | 4302 | 275 | 36.1408 | -5.3536 | 2021-07-21 04:21:40 | Gibraltar, United Kingdom |
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]);