johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
197 rows where confirmed = 4230 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754293 | 2754293 | 2022-12-29 | US | Kentucky | Carroll | 21041 | 4230 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-30 04:21:04 | Carroll, Kentucky, US | |
1075299 | 1075299 | 2022-12-28 | US | Kentucky | Carroll | 21041 | 4230 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-29 04:21:01 | Carroll, Kentucky, US | |
329296 | 329296 | 2022-12-27 | US | Kentucky | Carroll | 21041 | 4230 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-28 04:21:04 | Carroll, Kentucky, US | |
218554 | 218554 | 2022-12-26 | US | California | Plumas | 6063 | 4230 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-27 04:21:07 | Plumas, California, US | |
3223011 | 3223011 | 2022-12-25 | US | California | Plumas | 6063 | 4230 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-26 04:21:06 | Plumas, California, US | |
1018925 | 1018925 | 2022-12-24 | US | California | Plumas | 6063 | 4230 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-25 04:21:04 | Plumas, California, US | |
690948 | 690948 | 2022-12-23 | US | California | Plumas | 6063 | 4230 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-24 04:21:02 | Plumas, California, US | |
2180158 | 2180158 | 2022-12-22 | US | California | Plumas | 6063 | 4230 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-23 04:21:04 | Plumas, California, US | |
451962 | 451962 | 2022-12-21 | US | California | Plumas | 6063 | 4230 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-22 04:20:56 | Plumas, California, US | |
2951961 | 2951961 | 2022-12-20 | US | California | Plumas | 6063 | 4230 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-21 04:21:03 | Plumas, California, US | |
2509622 | 2509622 | 2022-11-10 | US | Wisconsin | Lafayette | 55065 | 4230 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-11-11 04:21:22 | Lafayette, Wisconsin, US | |
482505 | 482505 | 2022-11-08 | US | South Dakota | Union | 46127 | 4230 | 53 | 0 | 42.83112163 | -96.6557828 | 2022-11-09 04:21:22 | Union, South Dakota, US | |
2441655 | 2441655 | 2022-11-07 | US | South Dakota | Union | 46127 | 4230 | 53 | 0 | 42.83112163 | -96.6557828 | 2022-11-08 04:21:21 | Union, South Dakota, US | |
1052753 | 1052753 | 2022-11-06 | US | South Dakota | Union | 46127 | 4230 | 53 | 0 | 42.83112163 | -96.6557828 | 2022-11-07 04:21:26 | Union, South Dakota, US | |
620777 | 620777 | 2022-11-05 | US | South Dakota | Union | 46127 | 4230 | 53 | 0 | 42.83112163 | -96.6557828 | 2022-11-06 04:21:24 | Union, South Dakota, US | |
1025281 | 1025281 | 2022-11-04 | US | South Dakota | Union | 46127 | 4230 | 53 | 0 | 42.83112163 | -96.6557828 | 2022-11-05 04:21:52 | Union, South Dakota, US | |
434272 | 434272 | 2022-11-03 | US | South Dakota | Union | 46127 | 4230 | 53 | 0 | 42.83112163 | -96.6557828 | 2022-11-04 04:22:11 | Union, South Dakota, US | |
852514 | 852514 | 2022-11-02 | US | South Dakota | Union | 46127 | 4230 | 53 | 0 | 42.83112163 | -96.6557828 | 2022-11-03 04:22:05 | Union, South Dakota, US | |
1370983 | 1370983 | 2022-09-21 | US | Arkansas | Franklin | 5047 | 4230 | 74 | 0 | 35.51202821 | -93.89299569 | 2022-09-22 04:22:56 | Franklin, Arkansas, US | |
2397550 | 2397550 | 2022-09-12 | US | Puerto Rico | Hormigueros | 72067 | 4230 | 0 | 0 | 18.134532 | -67.113972 | 2022-09-13 04:20:57 | Hormigueros, Puerto Rico, US | |
1608769 | 1608769 | 2022-07-20 | US | Arkansas | Madison | 5087 | 4230 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-07-21 04:21:10 | Madison, Arkansas, US | |
962162 | 962162 | 2022-07-19 | US | Texas | Zavala | 48507 | 4230 | 69 | 0 | 28.86617238 | -99.76050829 | 2022-07-20 04:20:59 | Zavala, Texas, US | |
1213977 | 1213977 | 2022-07-11 | US | North Dakota | Richland | 38077 | 4230 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-07-12 04:20:51 | Richland, North Dakota, US | |
1203121 | 1203121 | 2022-07-06 | US | Virginia | Buckingham | 51029 | 4230 | 58 | 0 | 37.57242268 | -78.52518834 | 2022-07-07 04:20:55 | Buckingham, Virginia, US | |
1202374 | 1202374 | 2022-07-06 | US | Oklahoma | Kingfisher | 40073 | 4230 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-07-07 04:20:55 | Kingfisher, Oklahoma, US | |
3969117 | 3969117 | 2022-07-05 | US | Oklahoma | Kingfisher | 40073 | 4230 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-07-06 04:20:58 | Kingfisher, Oklahoma, US | |
3967739 | 3967739 | 2022-07-05 | US | Iowa | Dickinson | 19059 | 4230 | 73 | 0 | 43.37787725 | -95.1510206 | 2022-07-06 04:20:58 | Dickinson, Iowa, US | |
3080628 | 3080628 | 2022-07-04 | US | Oklahoma | Kingfisher | 40073 | 4230 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-07-05 04:20:45 | Kingfisher, Oklahoma, US | |
3079250 | 3079250 | 2022-07-04 | US | Iowa | Dickinson | 19059 | 4230 | 73 | 0 | 43.37787725 | -95.1510206 | 2022-07-05 04:20:45 | Dickinson, Iowa, US | |
3078420 | 3078420 | 2022-07-04 | US | Alabama | Clay | 1027 | 4230 | 82 | 0 | 33.26984193 | -85.85836077 | 2022-07-05 04:20:45 | Clay, Alabama, US | |
1769910 | 1769910 | 2022-07-03 | US | Oklahoma | Kingfisher | 40073 | 4230 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-07-04 04:20:54 | Kingfisher, Oklahoma, US | |
1768532 | 1768532 | 2022-07-03 | US | Iowa | Dickinson | 19059 | 4230 | 73 | 0 | 43.37787725 | -95.1510206 | 2022-07-04 04:20:54 | Dickinson, Iowa, US | |
3367896 | 3367896 | 2022-07-02 | US | Oklahoma | Kingfisher | 40073 | 4230 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-07-03 04:20:59 | Kingfisher, Oklahoma, US | |
3366518 | 3366518 | 2022-07-02 | US | Iowa | Dickinson | 19059 | 4230 | 73 | 0 | 43.37787725 | -95.1510206 | 2022-07-03 04:20:59 | Dickinson, Iowa, US | |
596225 | 596225 | 2022-07-01 | US | Oklahoma | Kingfisher | 40073 | 4230 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-07-02 04:21:16 | Kingfisher, Oklahoma, US | |
594847 | 594847 | 2022-07-01 | US | Iowa | Dickinson | 19059 | 4230 | 73 | 0 | 43.37787725 | -95.1510206 | 2022-07-02 04:21:16 | Dickinson, Iowa, US | |
3942626 | 3942626 | 2022-06-30 | US | Oklahoma | Kingfisher | 40073 | 4230 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-07-01 04:21:10 | Kingfisher, Oklahoma, US | |
3941248 | 3941248 | 2022-06-30 | US | Iowa | Dickinson | 19059 | 4230 | 73 | 0 | 43.37787725 | -95.1510206 | 2022-07-01 04:21:10 | Dickinson, Iowa, US | |
2491206 | 2491206 | 2022-06-29 | US | Iowa | Dickinson | 19059 | 4230 | 73 | 0 | 43.37787725 | -95.1510206 | 2022-06-30 04:21:01 | Dickinson, Iowa, US | |
1766921 | 1766921 | 2022-06-20 | US | Wisconsin | Washburn | 55129 | 4230 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-06-21 04:20:56 | Washburn, Wisconsin, US | |
1765194 | 1765194 | 2022-06-20 | US | Mississippi | Yalobusha | 28161 | 4230 | 57 | 0 | 34.02824175 | -89.7076205 | 2022-06-21 04:20:56 | Yalobusha, Mississippi, US | |
3271380 | 3271380 | 2022-06-19 | US | Mississippi | Yalobusha | 28161 | 4230 | 57 | 0 | 34.02824175 | -89.7076205 | 2022-06-20 04:21:01 | Yalobusha, Mississippi, US | |
3399292 | 3399292 | 2022-06-18 | US | Mississippi | Yalobusha | 28161 | 4230 | 57 | 0 | 34.02824175 | -89.7076205 | 2022-06-19 04:20:51 | Yalobusha, Mississippi, US | |
2313169 | 2313169 | 2022-06-17 | US | Mississippi | Yalobusha | 28161 | 4230 | 57 | 0 | 34.02824175 | -89.7076205 | 2022-06-18 04:21:10 | Yalobusha, Mississippi, US | |
560673 | 560673 | 2022-06-16 | US | Mississippi | Yalobusha | 28161 | 4230 | 57 | 0 | 34.02824175 | -89.7076205 | 2022-06-17 04:20:56 | Yalobusha, Mississippi, US | |
3984475 | 3984475 | 2022-06-15 | US | Mississippi | Yalobusha | 28161 | 4230 | 57 | 0 | 34.02824175 | -89.7076205 | 2022-06-16 04:20:55 | Yalobusha, Mississippi, US | |
948716 | 948716 | 2022-06-14 | US | Mississippi | Yalobusha | 28161 | 4230 | 57 | 0 | 34.02824175 | -89.7076205 | 2022-06-15 04:20:54 | Yalobusha, Mississippi, US | |
2981124 | 2981124 | 2022-06-13 | US | Mississippi | Yalobusha | 28161 | 4230 | 57 | 0 | 34.02824175 | -89.7076205 | 2022-06-14 04:20:52 | Yalobusha, Mississippi, US | |
3581972 | 3581972 | 2022-06-02 | US | Virginia | Giles | 51071 | 4230 | 50 | 0 | 37.31234791 | -80.70636931 | 2022-06-03 04:20:58 | Giles, Virginia, US | |
3916985 | 3916985 | 2022-05-01 | US | Idaho | Minidoka | 16067 | 4230 | 63 | 0 | 42.85518524 | -113.6357257 | 2022-05-02 04:21:10 | Minidoka, Idaho, US | |
2841789 | 2841789 | 2022-04-30 | US | Idaho | Minidoka | 16067 | 4230 | 63 | 0 | 42.85518524 | -113.6357257 | 2022-05-01 04:20:57 | Minidoka, Idaho, US | |
1158102 | 1158102 | 2022-04-29 | US | Idaho | Minidoka | 16067 | 4230 | 63 | 0 | 42.85518524 | -113.6357257 | 2022-04-30 04:21:05 | Minidoka, Idaho, US | |
1328024 | 1328024 | 2022-04-26 | US | Minnesota | Wadena | 27159 | 4230 | 55 | 0 | 46.58589171 | -94.96968506 | 2022-04-27 04:20:52 | Wadena, Minnesota, US | |
3418715 | 3418715 | 2022-04-17 | US | Mississippi | Clarke | 28023 | 4230 | 108 | 0 | 32.04158545 | -88.68896219999998 | 2022-04-18 04:21:12 | Clarke, Mississippi, US | |
305664 | 305664 | 2022-04-16 | US | Mississippi | Clarke | 28023 | 4230 | 108 | 0 | 32.04158545 | -88.68896219999998 | 2022-04-17 04:20:59 | Clarke, Mississippi, US | |
2671609 | 2671609 | 2022-04-15 | US | Mississippi | Clarke | 28023 | 4230 | 108 | 0 | 32.04158545 | -88.68896219999998 | 2022-04-16 04:20:48 | Clarke, Mississippi, US | |
1225394 | 1225394 | 2022-04-14 | US | Mississippi | Clarke | 28023 | 4230 | 108 | 0 | 32.04158545 | -88.68896219999998 | 2022-04-15 04:20:57 | Clarke, Mississippi, US | |
2444552 | 2444552 | 2022-04-13 | US | Mississippi | Clarke | 28023 | 4230 | 108 | 0 | 32.04158545 | -88.68896219999998 | 2022-04-13 23:21:06 | Clarke, Mississippi, US | |
1950309 | 1950309 | 2022-04-12 | US | Mississippi | Clarke | 28023 | 4230 | 108 | 0 | 32.04158545 | -88.68896219999998 | 2022-04-13 04:21:03 | Clarke, Mississippi, US | |
3209001 | 3209001 | 2022-04-11 | US | Puerto Rico | Coamo | 72043 | 4230 | 0 | 0 | 18.097597 | -66.36014 | 2022-04-12 04:20:49 | Coamo, Puerto Rico, US | |
1579690 | 1579690 | 2022-04-10 | US | Wisconsin | Crawford | 55023 | 4230 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-04-11 04:21:02 | Crawford, Wisconsin, US | |
1655932 | 1655932 | 2022-04-09 | US | Wisconsin | Crawford | 55023 | 4230 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-04-10 04:20:52 | Crawford, Wisconsin, US | |
2119254 | 2119254 | 2022-04-08 | US | Wisconsin | Crawford | 55023 | 4230 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-04-09 04:20:42 | Crawford, Wisconsin, US | |
3323778 | 3323778 | 2022-04-07 | US | Wisconsin | Crawford | 55023 | 4230 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-04-08 04:20:48 | Crawford, Wisconsin, US | |
161515 | 161515 | 2022-03-29 | US | West Virginia | Morgan | 54065 | 4230 | 69 | 0 | 39.55439028 | -78.26311676 | 2022-03-30 04:20:45 | Morgan, West Virginia, US | |
1908351 | 1908351 | 2022-03-22 | US | Texas | Lee | 48287 | 4230 | 60 | 0 | 30.31120597 | -96.97045773 | 2022-03-23 04:20:48 | Lee, Texas, US | |
3241482 | 3241482 | 2022-03-21 | US | Texas | Lee | 48287 | 4230 | 60 | 0 | 30.31120597 | -96.97045773 | 2022-03-22 04:20:54 | Lee, Texas, US | |
27555 | 27555 | 2022-03-20 | US | Texas | Lee | 48287 | 4230 | 60 | 0 | 30.31120597 | -96.97045773 | 2022-03-21 04:20:50 | Lee, Texas, US | |
1659565 | 1659565 | 2022-03-19 | US | Texas | Lee | 48287 | 4230 | 60 | 0 | 30.31120597 | -96.97045773 | 2022-03-20 04:20:45 | Lee, Texas, US | |
2320301 | 2320301 | 2022-03-16 | US | Illinois | Carroll | 17015 | 4230 | 47 | 0 | 42.06823429 | -89.93395545 | 2022-03-17 04:20:56 | Carroll, Illinois, US | |
3719664 | 3719664 | 2022-02-21 | US | Kentucky | Union | 21225 | 4230 | 54 | 0 | 37.66166713 | -87.94300009 | 2022-02-22 04:21:01 | Union, Kentucky, US | |
1298795 | 1298795 | 2022-02-17 | US | Florida | Union | 12125 | 4230 | 111 | 0 | 30.04412971 | -82.37497443 | 2022-02-18 04:21:04 | Union, Florida, US | |
3821181 | 3821181 | 2022-02-16 | US | Florida | Union | 12125 | 4230 | 111 | 0 | 30.04412971 | -82.37497443 | 2022-02-17 04:20:56 | Union, Florida, US | |
3672395 | 3672395 | 2022-02-15 | US | Florida | Union | 12125 | 4230 | 111 | 0 | 30.04412971 | -82.37497443 | 2022-02-16 04:21:10 | Union, Florida, US | |
2642496 | 2642496 | 2022-02-14 | US | Florida | Union | 12125 | 4230 | 111 | 0 | 30.04412971 | -82.37497443 | 2022-02-15 04:21:09 | Union, Florida, US | |
186813 | 186813 | 2022-02-13 | US | Florida | Union | 12125 | 4230 | 106 | 0 | 30.04412971 | -82.37497443 | 2022-02-14 04:20:51 | Union, Florida, US | |
316659 | 316659 | 2022-02-12 | US | Florida | Union | 12125 | 4230 | 106 | 0 | 30.04412971 | -82.37497443 | 2022-02-13 04:21:00 | Union, Florida, US | |
233985 | 233985 | 2022-02-11 | US | Florida | Union | 12125 | 4230 | 106 | 0 | 30.04412971 | -82.37497443 | 2022-02-12 04:21:06 | Union, Florida, US | |
72150 | 72150 | 2022-02-07 | US | Illinois | White | 17193 | 4230 | 40 | 0 | 38.08706198 | -88.17657461 | 2022-02-08 04:21:15 | White, Illinois, US | |
1961449 | 1961449 | 2022-01-20 | US | Georgia | Union | 13291 | 4230 | 134 | 0 | 34.82995757 | -83.98967069 | 2022-01-21 04:21:09 | Union, Georgia, US | |
1695054 | 1695054 | 2022-01-10 | US | Puerto Rico | Corozal | 72047 | 4230 | 0 | 0 | 18.304264 | -66.327738 | 2022-01-11 04:22:01 | Corozal, Puerto Rico, US | |
128968 | 128968 | 2022-01-09 | US | New York | Essex | 36031 | 4230 | 49 | 0 | 44.11630765 | -73.77297842 | 2022-01-10 04:22:07 | Essex, New York, US | |
2170522 | 2170522 | 2022-01-01 | US | Tennessee | Johnson | 47091 | 4230 | 64 | 0 | 36.45523950000001 | -81.84886538 | 2022-01-02 04:20:52 | Johnson, Tennessee, US | |
785254 | 785254 | 2021-12-13 | US | South Dakota | Davison | 46035 | 4230 | 70 | 0 | 43.67490933 | -98.14458906 | 2021-12-14 04:22:38 | Davison, South Dakota, US | |
1079392 | 1079392 | 2021-12-09 | US | Kentucky | Rowan | 21205 | 4230 | 43 | 0 | 38.19484205 | -83.42088935 | 2021-12-10 04:22:28 | Rowan, Kentucky, US | |
1234945 | 1234945 | 2021-11-28 | US | Virginia | Caroline | 51033 | 4230 | 54 | 0 | 38.02679129 | -77.34901405 | 2021-11-29 04:22:30 | Caroline, Virginia, US | |
1361652 | 1361652 | 2021-11-27 | US | Virginia | Caroline | 51033 | 4230 | 54 | 0 | 38.02679129 | -77.34901405 | 2021-11-28 04:22:43 | Caroline, Virginia, US | |
761643 | 761643 | 2021-11-26 | US | Virginia | Caroline | 51033 | 4230 | 54 | 0 | 38.02679129 | -77.34901405 | 2021-11-27 04:22:45 | Caroline, Virginia, US | |
497057 | 497057 | 2021-11-06 | US | Kentucky | Grant | 21081 | 4230 | 35 | 0 | 38.64962758 | -84.62415957 | 2021-11-07 04:21:53 | Grant, Kentucky, US | |
278890 | 278890 | 2021-11-03 | US | Pennsylvania | Warren | 42123 | 4230 | 132 | 0 | 41.81304978 | -79.26969577 | 2021-11-04 04:22:20 | Warren, Pennsylvania, US | |
537201 | 537201 | 2021-10-27 | US | Ohio | Gallia | 39053 | 4230 | 76 | 0 | 38.82708533 | -82.31647569 | 2021-10-28 04:22:08 | Gallia, Ohio, US | |
2124602 | 2124602 | 2021-10-21 | US | Georgia | Pierce | 13229 | 4230 | 101 | 0 | 31.35928155 | -82.21598442 | 2021-10-22 04:21:14 | Pierce, Georgia, US | |
1910958 | 1910958 | 2021-10-17 | US | Minnesota | Nicollet | 27103 | 4230 | 51 | 0 | 44.35291112 | -94.24710352 | 2021-10-18 04:21:10 | Nicollet, Minnesota, US | |
1910303 | 1910303 | 2021-10-17 | US | Indiana | Greene | 18055 | 4230 | 96 | 0 | 39.03630547 | -86.96223202 | 2021-10-18 04:21:10 | Greene, Indiana, US | |
936547 | 936547 | 2021-10-16 | US | Minnesota | Nicollet | 27103 | 4230 | 51 | 0 | 44.35291112 | -94.24710352 | 2021-10-17 04:21:29 | Nicollet, Minnesota, US | |
2945102 | 2945102 | 2021-10-15 | US | Minnesota | Nicollet | 27103 | 4230 | 51 | 0 | 44.35291112 | -94.24710352 | 2021-10-16 04:21:15 | Nicollet, Minnesota, US | |
2944788 | 2944788 | 2021-10-15 | US | Kentucky | Lincoln | 21137 | 4230 | 80 | 0 | 37.45475628 | -84.6565327 | 2021-10-16 04:21:15 | Lincoln, Kentucky, US | |
1276785 | 1276785 | 2021-10-03 | US | Ohio | Morrow | 39117 | 4230 | 57 | 0 | 40.52363560000001 | -82.7892599 | 2021-10-04 04:21:31 | Morrow, Ohio, US | |
3931538 | 3931538 | 2021-10-02 | US | West Virginia | Mineral | 54057 | 4230 | 104 | 0 | 39.41561583 | -78.94104895 | 2021-10-03 04:21:24 | Mineral, West Virginia, US | |
603554 | 603554 | 2021-09-23 | US | Mississippi | Yazoo | 28163 | 4230 | 86 | 0 | 32.77890365 | -90.39656148 | 2021-09-24 04:21:44 | Yazoo, Mississippi, 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]);