johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
170 rows where confirmed = 4457 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3378401 | 3378401 | 2022-12-08 | US | Illinois | Massac | 17127 | 4457 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-12-09 04:21:05 | Massac, Illinois, US | |
2416862 | 2416862 | 2022-12-05 | US | Missouri | Wright | 29229 | 4457 | 93 | 0 | 37.27029221 | -92.46914488 | 2022-12-06 04:21:03 | Wright, Missouri, US | |
720470 | 720470 | 2022-12-04 | US | Missouri | Wright | 29229 | 4457 | 93 | 0 | 37.27029221 | -92.46914488 | 2022-12-05 04:20:58 | Wright, Missouri, US | |
2818759 | 2818759 | 2022-12-03 | US | Missouri | Wright | 29229 | 4457 | 93 | 0 | 37.27029221 | -92.46914488 | 2022-12-04 04:20:56 | Wright, Missouri, US | |
835615 | 835615 | 2022-12-02 | US | Missouri | Wright | 29229 | 4457 | 93 | 0 | 37.27029221 | -92.46914488 | 2022-12-03 04:21:02 | Wright, Missouri, US | |
2138145 | 2138145 | 2022-12-01 | US | Missouri | Wright | 29229 | 4457 | 93 | 0 | 37.27029221 | -92.46914488 | 2022-12-02 04:21:07 | Wright, Missouri, US | |
1966561 | 1966561 | 2022-11-30 | US | Missouri | Wright | 29229 | 4457 | 93 | 0 | 37.27029221 | -92.46914488 | 2022-12-01 04:21:03 | Wright, Missouri, US | |
2558575 | 2558575 | 2022-11-29 | US | Missouri | Wright | 29229 | 4457 | 93 | 0 | 37.27029221 | -92.46914488 | 2022-11-30 04:21:07 | Wright, Missouri, US | |
2431320 | 2431320 | 2022-11-09 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-10 04:21:16 | Lamar, Alabama, US | |
479976 | 479976 | 2022-11-08 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-09 04:21:22 | Lamar, Alabama, US | |
2439126 | 2439126 | 2022-11-07 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-08 04:21:21 | Lamar, Alabama, US | |
1050224 | 1050224 | 2022-11-06 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-07 04:21:26 | Lamar, Alabama, US | |
618248 | 618248 | 2022-11-05 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-06 04:21:24 | Lamar, Alabama, US | |
1022752 | 1022752 | 2022-11-04 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-05 04:21:52 | Lamar, Alabama, US | |
431743 | 431743 | 2022-11-03 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-04 04:22:11 | Lamar, Alabama, US | |
853168 | 853168 | 2022-11-02 | US | Wisconsin | Marquette | 55077 | 4457 | 65 | 0 | 43.81911946 | -89.40073763 | 2022-11-03 04:22:05 | Marquette, Wisconsin, US | |
849985 | 849985 | 2022-11-02 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-03 04:22:05 | Lamar, Alabama, US | |
710836 | 710836 | 2022-11-01 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-02 04:22:09 | Lamar, Alabama, US | |
3285285 | 3285285 | 2022-10-31 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-01 04:22:36 | Lamar, Alabama, US | |
320318 | 320318 | 2022-10-30 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-31 04:21:36 | Lamar, Alabama, US | |
912594 | 912594 | 2022-10-29 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-30 04:22:14 | Lamar, Alabama, US | |
1366863 | 1366863 | 2022-10-28 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-29 04:21:13 | Lamar, Alabama, US | |
3041698 | 3041698 | 2022-10-27 | US | Virginia | King William | 51101 | 4457 | 49 | 0 | 37.70965316 | -77.09384941 | 2022-10-28 04:22:31 | King William, Virginia, US | |
3038718 | 3038718 | 2022-10-27 | US | Alabama | Lamar | 1075 | 4457 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-28 04:22:31 | Lamar, Alabama, US | |
3214797 | 3214797 | 2022-10-12 | US | Arkansas | Izard | 5065 | 4457 | 77 | 0 | 36.09604046 | -91.90847954 | 2022-10-13 04:22:39 | Izard, Arkansas, US | |
1814261 | 1814261 | 2022-10-05 | US | West Virginia | Grant | 54023 | 4457 | 60 | 0 | 39.10314817 | -79.19440518 | 2022-10-06 04:21:22 | Grant, West Virginia, US | |
117650 | 117650 | 2022-09-06 | US | South Dakota | Oglala Lakota | 46102 | 4457 | 61 | 0 | 43.33749164 | -102.5555498 | 2022-09-07 04:20:59 | Oglala Lakota, South Dakota, US | |
2636622 | 2636622 | 2022-09-05 | US | South Dakota | Oglala Lakota | 46102 | 4457 | 61 | 0 | 43.33749164 | -102.5555498 | 2022-09-06 04:21:02 | Oglala Lakota, South Dakota, US | |
2990186 | 2990186 | 2022-09-04 | US | South Dakota | Oglala Lakota | 46102 | 4457 | 61 | 0 | 43.33749164 | -102.5555498 | 2022-09-05 04:21:01 | Oglala Lakota, South Dakota, US | |
2715871 | 2715871 | 2022-09-03 | US | South Dakota | Oglala Lakota | 46102 | 4457 | 61 | 0 | 43.33749164 | -102.5555498 | 2022-09-04 04:21:22 | Oglala Lakota, South Dakota, US | |
1396576 | 1396576 | 2022-09-02 | US | South Dakota | Oglala Lakota | 46102 | 4457 | 61 | 0 | 43.33749164 | -102.5555498 | 2022-09-03 04:21:04 | Oglala Lakota, South Dakota, US | |
3550405 | 3550405 | 2022-09-01 | US | South Dakota | Oglala Lakota | 46102 | 4457 | 61 | 0 | 43.33749164 | -102.5555498 | 2022-09-02 04:21:07 | Oglala Lakota, South Dakota, US | |
2346325 | 2346325 | 2022-08-31 | US | South Dakota | Oglala Lakota | 46102 | 4457 | 61 | 0 | 43.33749164 | -102.5555498 | 2022-09-01 04:21:03 | Oglala Lakota, South Dakota, US | |
1087103 | 1087103 | 2022-08-09 | US | Illinois | Mercer | 17131 | 4457 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-08-10 04:20:57 | Mercer, Illinois, US | |
1073207 | 1073207 | 2022-08-07 | US | Virginia | Buckingham | 51029 | 4457 | 59 | 0 | 37.57242268 | -78.52518834 | 2022-08-08 04:21:08 | Buckingham, Virginia, US | |
1943795 | 1943795 | 2022-08-06 | US | Virginia | Buckingham | 51029 | 4457 | 59 | 0 | 37.57242268 | -78.52518834 | 2022-08-07 04:20:54 | Buckingham, Virginia, US | |
883594 | 883594 | 2022-08-05 | US | Virginia | Buckingham | 51029 | 4457 | 59 | 0 | 37.57242268 | -78.52518834 | 2022-08-06 04:20:56 | Buckingham, Virginia, US | |
673454 | 673454 | 2022-07-21 | US | Texas | Lavaca | 48285 | 4457 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-22 04:21:15 | Lavaca, Texas, US | |
3943212 | 3943212 | 2022-06-30 | US | Texas | Lamb | 48279 | 4457 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-07-01 04:21:10 | Lamb, Texas, US | |
1850987 | 1850987 | 2022-05-26 | US | Illinois | Hancock | 17067 | 4457 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-05-27 04:20:56 | Hancock, Illinois, US | |
3897514 | 3897514 | 2022-05-19 | US | Louisiana | Winn | 22127 | 4457 | 64 | 0 | 31.94449367 | -92.63789413 | 2022-05-20 04:20:57 | Winn, Louisiana, US | |
2895137 | 2895137 | 2022-04-21 | US | Puerto Rico | Barranquitas | 72019 | 4457 | 0 | 0 | 18.201592 | -66.30963 | 2022-04-22 04:20:45 | Barranquitas, Puerto Rico, US | |
1655159 | 1655159 | 2022-04-09 | US | Puerto Rico | Morovis | 72101 | 4457 | 0 | 0 | 18.316963 | -66.420383 | 2022-04-10 04:20:52 | Morovis, Puerto Rico, US | |
3323461 | 3323461 | 2022-04-07 | US | Texas | Shelby | 48419 | 4457 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-04-08 04:20:48 | Shelby, Texas, US | |
2803997 | 2803997 | 2022-04-06 | US | Texas | Shelby | 48419 | 4457 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-04-07 04:20:53 | Shelby, Texas, US | |
3868034 | 3868034 | 2022-04-05 | US | Arkansas | Grant | 5053 | 4457 | 61 | 0 | 34.29017991 | -92.42320562 | 2022-04-06 04:20:49 | Grant, Arkansas, US | |
2749376 | 2749376 | 2022-04-04 | US | Arkansas | Grant | 5053 | 4457 | 61 | 0 | 34.29017991 | -92.42320562 | 2022-04-05 04:20:48 | Grant, Arkansas, US | |
3730722 | 3730722 | 2022-04-03 | US | Arkansas | Grant | 5053 | 4457 | 61 | 0 | 34.29017991 | -92.42320562 | 2022-04-04 04:20:51 | Grant, Arkansas, US | |
500157 | 500157 | 2022-04-02 | US | Arkansas | Grant | 5053 | 4457 | 61 | 0 | 34.29017991 | -92.42320562 | 2022-04-03 04:20:48 | Grant, Arkansas, US | |
3351142 | 3351142 | 2022-04-01 | US | Arkansas | Grant | 5053 | 4457 | 60 | 0 | 34.29017991 | -92.42320562 | 2022-04-02 04:20:47 | Grant, Arkansas, US | |
1469105 | 1469105 | 2022-03-24 | US | Illinois | Johnson | 17087 | 4457 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-03-25 04:20:46 | Johnson, Illinois, US | |
26164 | 26164 | 2022-03-20 | US | Minnesota | Roseau | 27135 | 4457 | 44 | 0 | 48.77501878 | -95.81079919 | 2022-03-21 04:20:50 | Roseau, Minnesota, US | |
1658174 | 1658174 | 2022-03-19 | US | Minnesota | Roseau | 27135 | 4457 | 44 | 0 | 48.77501878 | -95.81079919 | 2022-03-20 04:20:45 | Roseau, Minnesota, US | |
337700 | 337700 | 2022-03-18 | US | Minnesota | Roseau | 27135 | 4457 | 44 | 0 | 48.77501878 | -95.81079919 | 2022-03-19 04:20:47 | Roseau, Minnesota, US | |
696153 | 696153 | 2022-03-17 | US | Minnesota | Roseau | 27135 | 4457 | 44 | 0 | 48.77501878 | -95.81079919 | 2022-03-18 04:20:55 | Roseau, Minnesota, US | |
2320197 | 2320197 | 2022-03-16 | US | Georgia | Putnam | 13237 | 4457 | 102 | 0 | 33.32056115 | -83.37552891 | 2022-03-17 04:20:56 | Putnam, Georgia, US | |
3720797 | 3720797 | 2022-02-21 | US | Oregon | Clatsop | 41007 | 4457 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-22 04:21:01 | Clatsop, Oregon, US | |
3914631 | 3914631 | 2022-02-20 | US | Oregon | Clatsop | 41007 | 4457 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-21 04:21:05 | Clatsop, Oregon, US | |
3878189 | 3878189 | 2022-02-19 | US | Oregon | Clatsop | 41007 | 4457 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-20 04:21:00 | Clatsop, Oregon, US | |
3858445 | 3858445 | 2022-02-18 | US | Oregon | Clatsop | 41007 | 4457 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-19 04:21:11 | Clatsop, Oregon, US | |
234801 | 234801 | 2022-02-11 | US | Maine | Knox | 23013 | 4457 | 22 | 0 | 44.11486325 | -69.10529169 | 2022-02-12 04:21:06 | Knox, Maine, US | |
2014188 | 2014188 | 2022-02-06 | US | Kentucky | Wayne | 21231 | 4457 | 80 | 0 | 36.80310688 | -84.8251971 | 2022-02-07 04:21:05 | Wayne, Kentucky, US | |
1295517 | 1295517 | 2022-02-05 | US | Kentucky | Wayne | 21231 | 4457 | 80 | 0 | 36.80310688 | -84.8251971 | 2022-02-06 04:21:00 | Wayne, Kentucky, US | |
2330543 | 2330543 | 2022-02-04 | US | Texas | Montague | 48337 | 4457 | 114 | 0 | 33.67521893 | -97.72500958 | 2022-02-05 04:21:05 | Montague, Texas, US | |
2328845 | 2328845 | 2022-02-04 | US | Kentucky | Wayne | 21231 | 4457 | 80 | 0 | 36.80310688 | -84.8251971 | 2022-02-05 04:21:05 | Wayne, Kentucky, US | |
979735 | 979735 | 2022-02-01 | US | Georgia | Crisp | 13081 | 4457 | 129 | 0 | 31.92289565 | -83.76811843 | 2022-02-02 04:21:09 | Crisp, Georgia, US | |
3812611 | 3812611 | 2022-01-28 | US | Pennsylvania | Juniata | 42067 | 4457 | 165 | 0 | 40.53358749 | -77.39975129999998 | 2022-01-29 04:21:10 | Juniata, Pennsylvania, US | |
2052398 | 2052398 | 2022-01-25 | US | Arkansas | Phillips | 5107 | 4457 | 84 | 0 | 34.43268455 | -90.84800154 | 2022-01-26 04:21:07 | Phillips, Arkansas, US | |
2833282 | 2833282 | 2022-01-22 | US | Arizona | La Paz | 4012 | 4457 | 114 | 0 | 33.72854224 | -113.98100290000001 | 2022-01-23 04:21:13 | La Paz, Arizona, US | |
1961593 | 1961593 | 2022-01-20 | US | Illinois | Pike | 17149 | 4457 | 62 | 0 | 39.62265059 | -90.8877017 | 2022-01-21 04:21:09 | Pike, Illinois, US | |
3688434 | 3688434 | 2022-01-13 | US | Idaho | Payette | 16075 | 4457 | 75 | 0 | 44.00545243 | -116.7647695 | 2022-01-14 04:21:54 | Payette, Idaho, US | |
3520872 | 3520872 | 2022-01-02 | US | Kentucky | Marion | 21155 | 4457 | 63 | 0 | 37.55218078 | -85.26898542 | 2022-01-03 02:22:25 | Marion, Kentucky, US | |
2169002 | 2169002 | 2022-01-01 | US | Kentucky | Marion | 21155 | 4457 | 63 | 0 | 37.55218078 | -85.26898542 | 2022-01-02 04:20:52 | Marion, Kentucky, US | |
2778433 | 2778433 | 2021-12-31 | US | Kentucky | Marion | 21155 | 4457 | 63 | 0 | 37.55218078 | -85.26898542 | 2022-01-01 04:22:14 | Marion, Kentucky, US | |
4000090 | 4000090 | 2021-12-30 | US | Kentucky | Marion | 21155 | 4457 | 63 | 0 | 37.55218078 | -85.26898542 | 2021-12-31 04:21:50 | Marion, Kentucky, US | |
1669897 | 1669897 | 2021-12-29 | US | Kentucky | Marion | 21155 | 4457 | 63 | 0 | 37.55218078 | -85.26898542 | 2021-12-30 04:21:25 | Marion, Kentucky, US | |
1256634 | 1256634 | 2021-12-20 | US | Mississippi | Wayne | 28153 | 4457 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-12-21 03:21:27 | Wayne, Mississippi, US | |
2904658 | 2904658 | 2021-12-19 | US | Idaho | Jerome | 16053 | 4457 | 55 | 0 | 42.68891267 | -114.2655033 | 2021-12-20 04:21:43 | Jerome, Idaho, US | |
1259731 | 1259731 | 2021-12-18 | US | Idaho | Jerome | 16053 | 4457 | 55 | 0 | 42.68891267 | -114.2655033 | 2021-12-19 04:21:11 | Jerome, Idaho, US | |
551243 | 551243 | 2021-12-08 | US | Arkansas | Carroll | 5015 | 4457 | 78 | 0 | 36.34038560000001 | -93.54270261 | 2021-12-09 04:22:49 | Carroll, Arkansas, US | |
1148373 | 1148373 | 2021-12-01 | US | Washington | Island | 53029 | 4457 | 50 | 0 | 48.14713305 | -122.5216407 | 2021-12-02 04:22:37 | Island, Washington, US | |
1146033 | 1146033 | 2021-12-01 | US | Indiana | Jennings | 18079 | 4457 | 67 | 0 | 38.99588883 | -85.62710784 | 2021-12-02 04:22:37 | Jennings, Indiana, US | |
3404885 | 3404885 | 2021-11-30 | US | Washington | Island | 53029 | 4457 | 50 | 0 | 48.14713305 | -122.5216407 | 2021-12-01 04:22:29 | Island, Washington, US | |
3748977 | 3748977 | 2021-11-22 | Comoros | 4457 | 150 | 0 | -11.6455 | 43.3333 | 2021-11-23 04:22:39 | Comoros | ||||
723931 | 723931 | 2021-11-20 | US | Kentucky | Lincoln | 21137 | 4457 | 101 | 0 | 37.45475628 | -84.6565327 | 2021-11-21 04:22:13 | Lincoln, Kentucky, US | |
3345563 | 3345563 | 2021-11-16 | US | Tennessee | Grainger | 47057 | 4457 | 68 | 0 | 36.27469206 | -83.51254721 | 2021-11-17 04:21:48 | Grainger, Tennessee, US | |
30387 | 30387 | 2021-11-11 | US | Missouri | Stoddard | 29207 | 4457 | 74 | 0 | 36.85571651 | -89.9444155 | 2021-11-12 04:22:01 | Stoddard, Missouri, US | |
29029 | 29029 | 2021-11-11 | US | Colorado | Delta | 8029 | 4457 | 101 | 0 | 38.86246243 | -107.86313419999999 | 2021-11-12 04:22:01 | Delta, Colorado, US | |
2846826 | 2846826 | 2021-11-10 | US | Missouri | Stoddard | 29207 | 4457 | 74 | 0 | 36.85571651 | -89.9444155 | 2021-11-11 04:21:45 | Stoddard, Missouri, US | |
3513835 | 3513835 | 2021-11-01 | US | North Dakota | Stutsman | 38093 | 4457 | 87 | 0 | 46.97962541 | -98.95637318 | 2021-11-02 04:22:03 | Stutsman, North Dakota, US | |
536601 | 536601 | 2021-10-27 | US | Mississippi | Yazoo | 28163 | 4457 | 88 | 0 | 32.77890365 | -90.39656148 | 2021-10-28 04:22:08 | Yazoo, Mississippi, US | |
1493105 | 1493105 | 2021-10-12 | US | Louisiana | East Feliciana | 22037 | 4457 | 142 | 0 | 30.84425359 | -91.04976723 | 2021-10-13 04:20:51 | East Feliciana, Louisiana, US | |
2962047 | 2962047 | 2021-10-08 | US | Pennsylvania | Greene | 42059 | 4457 | 50 | 0 | 39.85746531 | -80.22357106 | 2021-10-09 04:21:34 | Greene, Pennsylvania, US | |
2459869 | 2459869 | 2021-10-06 | US | Indiana | Daviess | 18027 | 4457 | 111 | 0 | 38.70186039 | -87.07185406 | 2021-10-07 04:21:36 | Daviess, Indiana, US | |
2134993 | 2134993 | 2021-10-01 | US | Tennessee | McNairy | 47109 | 4457 | 65 | 0 | 35.17468549 | -88.5647812 | 2021-10-02 04:21:25 | McNairy, Tennessee, US | |
2774898 | 2774898 | 2021-09-30 | US | Missouri | Lafayette | 29107 | 4457 | 71 | 0 | 39.06986886 | -93.78076396 | 2021-10-01 04:21:35 | Lafayette, Missouri, US | |
1237456 | 1237456 | 2021-09-27 | US | Mississippi | Itawamba | 28057 | 4457 | 100 | 0 | 34.27993475 | -88.3606733 | 2021-09-28 04:21:28 | Itawamba, Mississippi, US | |
602522 | 602522 | 2021-09-23 | US | Georgia | Lee | 13177 | 4457 | 74 | 0 | 31.779330600000005 | -84.14324253 | 2021-09-24 04:21:44 | Lee, Georgia, US | |
3011869 | 3011869 | 2021-09-22 | US | Arkansas | Yell | 5149 | 4457 | 76 | 0 | 35.00292371 | -93.41171338 | 2021-09-23 04:21:43 | Yell, Arkansas, US | |
3760451 | 3760451 | 2021-09-21 | US | Tennessee | Overton | 47133 | 4457 | 75 | 0 | 36.34117832 | -85.28989535 | 2021-09-22 04:21:45 | Overton, Tennessee, 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]);