johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
321 rows where confirmed = 2052 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3028332 | 3028332 | 2022-11-17 | US | Montana | Valley | 30105 | 2052 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-18 04:21:15 | Valley, Montana, US | |
2488043 | 2488043 | 2022-11-16 | US | Montana | Valley | 30105 | 2052 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-17 04:21:11 | Valley, Montana, US | |
294054 | 294054 | 2022-11-15 | US | Montana | Valley | 30105 | 2052 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-16 04:21:09 | Valley, Montana, US | |
3599084 | 3599084 | 2022-11-14 | US | Montana | Valley | 30105 | 2052 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-15 04:21:16 | Valley, Montana, US | |
3598657 | 3598657 | 2022-11-14 | US | Michigan | Alger | 26003 | 2052 | 17 | 0 | 46.41292944 | -86.60260122 | 2022-11-15 04:21:16 | Alger, Michigan, US | |
313515 | 313515 | 2022-11-13 | US | Michigan | Alger | 26003 | 2052 | 17 | 0 | 46.41292944 | -86.60260122 | 2022-11-14 04:21:09 | Alger, Michigan, US | |
64676 | 64676 | 2022-11-12 | US | Michigan | Alger | 26003 | 2052 | 17 | 0 | 46.41292944 | -86.60260122 | 2022-11-13 04:21:14 | Alger, Michigan, US | |
2928838 | 2928838 | 2022-11-11 | US | Michigan | Alger | 26003 | 2052 | 17 | 0 | 46.41292944 | -86.60260122 | 2022-11-12 04:20:41 | Alger, Michigan, US | |
2507674 | 2507674 | 2022-11-10 | US | Michigan | Alger | 26003 | 2052 | 17 | 0 | 46.41292944 | -86.60260122 | 2022-11-11 04:21:22 | Alger, Michigan, US | |
2432549 | 2432549 | 2022-11-09 | US | Michigan | Alger | 26003 | 2052 | 17 | 0 | 46.41292944 | -86.60260122 | 2022-11-10 04:21:16 | Alger, Michigan, US | |
1366660 | 1366660 | 2022-10-28 | Peru | Unknown | 2052 | 65 | 0 | 2022-10-29 04:21:13 | Unknown, Peru | |||||
2758218 | 2758218 | 2022-10-18 | US | Kansas | Greenwood | 20073 | 2052 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-10-19 04:22:26 | Greenwood, Kansas, US | |
2757575 | 2757575 | 2022-10-18 | US | Colorado | Rio Blanco | 8103 | 2052 | 14 | 0 | 39.97913541 | -108.2179009 | 2022-10-19 04:22:26 | Rio Blanco, Colorado, US | |
2026052 | 2026052 | 2022-10-17 | US | Kansas | Greenwood | 20073 | 2052 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-10-18 04:22:42 | Greenwood, Kansas, US | |
2025409 | 2025409 | 2022-10-17 | US | Colorado | Rio Blanco | 8103 | 2052 | 14 | 0 | 39.97913541 | -108.2179009 | 2022-10-18 04:22:42 | Rio Blanco, Colorado, US | |
2162714 | 2162714 | 2022-10-16 | US | Texas | Mitchell | 48335 | 2052 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-10-17 04:20:31 | Mitchell, Texas, US | |
2160830 | 2160830 | 2022-10-16 | US | Kansas | Greenwood | 20073 | 2052 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-10-17 04:20:31 | Greenwood, Kansas, US | |
518911 | 518911 | 2022-10-15 | US | Texas | Mitchell | 48335 | 2052 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-10-16 04:22:39 | Mitchell, Texas, US | |
517027 | 517027 | 2022-10-15 | US | Kansas | Greenwood | 20073 | 2052 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-10-16 04:22:39 | Greenwood, Kansas, US | |
2035968 | 2035968 | 2022-10-14 | US | Texas | Mitchell | 48335 | 2052 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-10-15 04:22:00 | Mitchell, Texas, US | |
2034084 | 2034084 | 2022-10-14 | US | Kansas | Greenwood | 20073 | 2052 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-10-15 04:22:00 | Greenwood, Kansas, US | |
3754772 | 3754772 | 2022-10-13 | US | Kansas | Greenwood | 20073 | 2052 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-10-14 04:22:28 | Greenwood, Kansas, US | |
3215597 | 3215597 | 2022-10-12 | US | Kansas | Greenwood | 20073 | 2052 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-10-13 04:22:39 | Greenwood, Kansas, US | |
2990714 | 2990714 | 2022-09-04 | US | Virginia | Williamsburg | 51830 | 2052 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-05 04:21:01 | Williamsburg, Virginia, US | |
2716399 | 2716399 | 2022-09-03 | US | Virginia | Williamsburg | 51830 | 2052 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-04 04:21:22 | Williamsburg, Virginia, US | |
1397104 | 1397104 | 2022-09-02 | US | Virginia | Williamsburg | 51830 | 2052 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-03 04:21:04 | Williamsburg, Virginia, US | |
3550933 | 3550933 | 2022-09-01 | US | Virginia | Williamsburg | 51830 | 2052 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-02 04:21:07 | Williamsburg, Virginia, US | |
2346853 | 2346853 | 2022-08-31 | US | Virginia | Williamsburg | 51830 | 2052 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-01 04:21:03 | Williamsburg, Virginia, US | |
1683704 | 1683704 | 2022-08-29 | US | Texas | Rains | 48379 | 2052 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-08-30 04:21:03 | Rains, Texas, US | |
994303 | 994303 | 2022-08-16 | US | Virginia | Bland | 51021 | 2052 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-17 04:20:59 | Bland, Virginia, US | |
2012056 | 2012056 | 2022-08-04 | US | Virginia | Lancaster | 51103 | 2052 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-08-05 04:20:52 | Lancaster, Virginia, US | |
899236 | 899236 | 2022-07-24 | US | Texas | Floyd | 48153 | 2052 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-07-25 04:20:51 | Floyd, Texas, US | |
1611829 | 1611829 | 2022-07-20 | US | Wisconsin | Menominee | 55078 | 2052 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-21 04:21:10 | Menominee, Wisconsin, US | |
3405268 | 3405268 | 2022-07-17 | China | Tianjin | 2052 | 3 | 0 | 39.3054 | 117.323 | 2022-07-18 04:20:59 | Tianjin, China | |||
2741677 | 2741677 | 2022-07-07 | US | Colorado | Yuma | 8125 | 2052 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-07-08 04:20:56 | Yuma, Colorado, US | |
1200472 | 1200472 | 2022-07-06 | US | Colorado | Yuma | 8125 | 2052 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-07-07 04:20:55 | Yuma, Colorado, US | |
3986182 | 3986182 | 2022-06-15 | US | Wisconsin | Pepin | 55091 | 2052 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-06-16 04:20:55 | Pepin, Wisconsin, US | |
972667 | 972667 | 2022-06-01 | US | Minnesota | Murray | 27101 | 2052 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-06-02 05:20:39 | Murray, Minnesota, US | |
230974 | 230974 | 2022-05-31 | US | Minnesota | Murray | 27101 | 2052 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-06-01 04:20:55 | Murray, Minnesota, US | |
230110 | 230110 | 2022-05-31 | US | Georgia | Terrell | 13273 | 2052 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-06-01 04:20:55 | Terrell, Georgia, US | |
3187739 | 3187739 | 2022-05-30 | US | Minnesota | Murray | 27101 | 2052 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-05-31 04:20:51 | Murray, Minnesota, US | |
3186875 | 3186875 | 2022-05-30 | US | Georgia | Terrell | 13273 | 2052 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-05-31 04:20:51 | Terrell, Georgia, US | |
3199888 | 3199888 | 2022-05-29 | US | Minnesota | Murray | 27101 | 2052 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-05-30 04:20:50 | Murray, Minnesota, US | |
3199024 | 3199024 | 2022-05-29 | US | Georgia | Terrell | 13273 | 2052 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-05-30 04:20:50 | Terrell, Georgia, US | |
2726766 | 2726766 | 2022-05-28 | US | Minnesota | Murray | 27101 | 2052 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-05-29 04:20:53 | Murray, Minnesota, US | |
2725902 | 2725902 | 2022-05-28 | US | Georgia | Terrell | 13273 | 2052 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-05-29 04:20:53 | Terrell, Georgia, US | |
1315947 | 1315947 | 2022-05-27 | US | Minnesota | Murray | 27101 | 2052 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-05-28 04:21:07 | Murray, Minnesota, US | |
1315083 | 1315083 | 2022-05-27 | US | Georgia | Terrell | 13273 | 2052 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-05-28 04:21:07 | Terrell, Georgia, US | |
1850875 | 1850875 | 2022-05-26 | US | Georgia | Terrell | 13273 | 2052 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-05-27 04:20:56 | Terrell, Georgia, US | |
1850348 | 1850348 | 2022-05-26 | US | Alabama | Choctaw | 1023 | 2052 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-05-27 04:20:56 | Choctaw, Alabama, US | |
2050816 | 2050816 | 2022-05-25 | US | Tennessee | Hancock | 47067 | 2052 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-05-26 04:20:50 | Hancock, Tennessee, US | |
2048751 | 2048751 | 2022-05-25 | US | Georgia | Terrell | 13273 | 2052 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-05-26 04:20:50 | Terrell, Georgia, US | |
2048224 | 2048224 | 2022-05-25 | US | Alabama | Choctaw | 1023 | 2052 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-05-26 04:20:50 | Choctaw, Alabama, US | |
3002254 | 3002254 | 2022-05-24 | US | Tennessee | Hancock | 47067 | 2052 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-05-25 04:20:56 | Hancock, Tennessee, US | |
622762 | 622762 | 2022-05-22 | US | Georgia | Terrell | 13273 | 2052 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-05-26 04:20:50 | Terrell, Georgia, US | |
622235 | 622235 | 2022-05-22 | US | Alabama | Choctaw | 1023 | 2052 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-05-26 04:20:50 | Choctaw, Alabama, US | |
1696118 | 1696118 | 2022-04-28 | China | Beijing | 2052 | 9 | 0 | 40.1824 | 116.4142 | 2022-04-29 04:20:59 | Beijing, China | |||
3724945 | 3724945 | 2022-04-25 | US | Puerto Rico | Guayanilla | 72059 | 2052 | 0 | 0 | 18.039942 | -66.79186 | 2022-04-26 04:20:51 | Guayanilla, Puerto Rico, US | |
3418375 | 3418375 | 2022-04-17 | US | Kentucky | Nicholas | 21181 | 2052 | 31 | 0 | 38.33342292 | -84.01889177 | 2022-04-18 04:21:12 | Nicholas, Kentucky, US | |
305324 | 305324 | 2022-04-16 | US | Kentucky | Nicholas | 21181 | 2052 | 31 | 0 | 38.33342292 | -84.01889177 | 2022-04-17 04:20:59 | Nicholas, Kentucky, US | |
2671269 | 2671269 | 2022-04-15 | US | Kentucky | Nicholas | 21181 | 2052 | 31 | 0 | 38.33342292 | -84.01889177 | 2022-04-16 04:20:48 | Nicholas, Kentucky, US | |
1225054 | 1225054 | 2022-04-14 | US | Kentucky | Nicholas | 21181 | 2052 | 31 | 0 | 38.33342292 | -84.01889177 | 2022-04-15 04:20:57 | Nicholas, Kentucky, US | |
2444212 | 2444212 | 2022-04-13 | US | Kentucky | Nicholas | 21181 | 2052 | 31 | 0 | 38.33342292 | -84.01889177 | 2022-04-13 23:21:06 | Nicholas, Kentucky, US | |
1949969 | 1949969 | 2022-04-12 | US | Kentucky | Nicholas | 21181 | 2052 | 31 | 0 | 38.33342292 | -84.01889177 | 2022-04-13 04:21:03 | Nicholas, Kentucky, US | |
3207722 | 3207722 | 2022-04-11 | US | Kentucky | Nicholas | 21181 | 2052 | 31 | 0 | 38.33342292 | -84.01889177 | 2022-04-12 04:20:49 | Nicholas, Kentucky, US | |
1723577 | 1723577 | 2022-03-25 | US | Texas | Gaines | 48165 | 2052 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-03-26 04:20:23 | Gaines, Texas, US | |
1471194 | 1471194 | 2022-03-24 | US | Texas | Gaines | 48165 | 2052 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-03-25 04:20:46 | Gaines, Texas, US | |
3025324 | 3025324 | 2022-03-23 | US | Texas | Clay | 48077 | 2052 | 34 | 0 | 33.78686685 | -98.20771198 | 2022-03-24 04:20:43 | Clay, Texas, US | |
3022089 | 3022089 | 2022-03-23 | China | Yunnan | 2052 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-24 04:20:43 | Yunnan, China | |||
1908246 | 1908246 | 2022-03-22 | US | Texas | Clay | 48077 | 2052 | 33 | 0 | 33.78686685 | -98.20771198 | 2022-03-23 04:20:48 | Clay, Texas, US | |
3241377 | 3241377 | 2022-03-21 | US | Texas | Clay | 48077 | 2052 | 32 | 0 | 33.78686685 | -98.20771198 | 2022-03-22 04:20:54 | Clay, Texas, US | |
27450 | 27450 | 2022-03-20 | US | Texas | Clay | 48077 | 2052 | 32 | 0 | 33.78686685 | -98.20771198 | 2022-03-21 04:20:50 | Clay, Texas, US | |
1659460 | 1659460 | 2022-03-19 | US | Texas | Clay | 48077 | 2052 | 32 | 0 | 33.78686685 | -98.20771198 | 2022-03-20 04:20:45 | Clay, Texas, US | |
338986 | 338986 | 2022-03-18 | US | Texas | Clay | 48077 | 2052 | 32 | 0 | 33.78686685 | -98.20771198 | 2022-03-19 04:20:47 | Clay, Texas, US | |
697439 | 697439 | 2022-03-17 | US | Texas | Clay | 48077 | 2052 | 32 | 0 | 33.78686685 | -98.20771198 | 2022-03-18 04:20:55 | Clay, Texas, US | |
1549958 | 1549958 | 2022-03-07 | US | Montana | Blaine | 30005 | 2052 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-08 04:20:54 | Blaine, Montana, US | |
1993891 | 1993891 | 2022-03-01 | US | Iowa | Palo Alto | 19147 | 2052 | 37 | 0 | 43.08193849 | -94.67824621 | 2022-03-02 04:21:07 | Palo Alto, Iowa, US | |
944065 | 944065 | 2022-02-28 | US | Iowa | Palo Alto | 19147 | 2052 | 37 | 0 | 43.08193849 | -94.67824621 | 2022-03-01 04:21:09 | Palo Alto, Iowa, US | |
2734256 | 2734256 | 2022-02-27 | US | Iowa | Palo Alto | 19147 | 2052 | 37 | 0 | 43.08193849 | -94.67824621 | 2022-02-28 04:21:05 | Palo Alto, Iowa, US | |
3047409 | 3047409 | 2022-02-26 | US | Iowa | Palo Alto | 19147 | 2052 | 37 | 0 | 43.08193849 | -94.67824621 | 2022-02-27 04:21:04 | Palo Alto, Iowa, US | |
576064 | 576064 | 2022-02-25 | US | Iowa | Palo Alto | 19147 | 2052 | 37 | 0 | 43.08193849 | -94.67824621 | 2022-02-26 04:21:12 | Palo Alto, Iowa, US | |
1512640 | 1512640 | 2022-02-24 | US | Iowa | Palo Alto | 19147 | 2052 | 37 | 0 | 43.08193849 | -94.67824621 | 2022-02-25 04:21:11 | Palo Alto, Iowa, US | |
1512176 | 1512176 | 2022-02-24 | US | Georgia | Candler | 13043 | 2052 | 91 | 0 | 32.40209349 | -82.07702563 | 2022-02-25 04:21:11 | Candler, Georgia, US | |
1059081 | 1059081 | 2022-02-23 | US | Iowa | Palo Alto | 19147 | 2052 | 37 | 0 | 43.08193849 | -94.67824621 | 2022-02-24 04:21:14 | Palo Alto, Iowa, US | |
1058617 | 1058617 | 2022-02-23 | US | Georgia | Candler | 13043 | 2052 | 91 | 0 | 32.40209349 | -82.07702563 | 2022-02-24 04:21:14 | Candler, Georgia, US | |
3878318 | 3878318 | 2022-02-19 | US | Puerto Rico | Florida | 72054 | 2052 | 0 | 0 | 18.373715 | -66.560488 | 2022-02-20 04:21:00 | Florida, Puerto Rico, US | |
189161 | 189161 | 2022-02-13 | US | Texas | Franklin | 48159 | 2052 | 38 | 0 | 33.17653242 | -95.21917243 | 2022-02-14 04:20:51 | Franklin, Texas, US | |
2475859 | 2475859 | 2022-02-03 | US | Missouri | Gentry | 29075 | 2052 | 28 | 0 | 40.21097916 | -94.40944419 | 2022-02-04 04:21:10 | Gentry, Missouri, US | |
981030 | 981030 | 2022-02-01 | US | Nebraska | Hamilton | 31081 | 2052 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-02-02 04:21:09 | Hamilton, Nebraska, US | |
980767 | 980767 | 2022-02-01 | US | Mississippi | Kemper | 28069 | 2052 | 43 | 0 | 32.75462946 | -88.64105766 | 2022-02-02 04:21:09 | Kemper, Mississippi, US | |
2660112 | 2660112 | 2022-01-31 | US | North Carolina | Graham | 37075 | 2052 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-02-01 04:21:11 | Graham, North Carolina, US | |
2659872 | 2659872 | 2022-01-31 | US | Nebraska | Hamilton | 31081 | 2052 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-02-01 04:21:11 | Hamilton, Nebraska, US | |
1780293 | 1780293 | 2022-01-27 | US | Georgia | Wilkinson | 13319 | 2052 | 49 | 0 | 32.80291082 | -83.17140684 | 2022-01-28 04:21:09 | Wilkinson, Georgia, US | |
1229608 | 1229608 | 2022-01-24 | US | Montana | Dawson | 30021 | 2052 | 53 | 0 | 47.26584855 | -104.89444170000002 | 2022-01-25 04:21:05 | Dawson, Montana, US | |
3428159 | 3428159 | 2022-01-21 | US | Texas | Runnels | 48399 | 2052 | 58 | 0 | 31.8314342 | -99.97616148 | 2022-01-22 04:21:13 | Runnels, Texas, US | |
1962319 | 1962319 | 2022-01-20 | US | Minnesota | Rock | 27133 | 2052 | 32 | 0 | 43.67482683 | -96.25296832 | 2022-01-21 04:21:09 | Rock, Minnesota, US | |
3616405 | 3616405 | 2022-01-12 | US | Virginia | Franklin City | 51620 | 2052 | 44 | 0 | 36.6831435 | -76.93859681 | 2022-01-13 08:00:09 | Franklin City, Virginia, US | |
1694193 | 1694193 | 2022-01-10 | US | Missouri | Bollinger | 29017 | 2052 | 36 | 0 | 37.32449052 | -90.02725304 | 2022-01-11 04:22:01 | Bollinger, Missouri, US | |
1218806 | 1218806 | 2022-01-08 | US | Texas | Trinity | 48455 | 2052 | 64 | 0 | 31.0879489 | -95.1367187 | 2022-01-09 04:21:46 | Trinity, Texas, US | |
1282351 | 1282351 | 2022-01-05 | US | Alabama | Conecuh | 1035 | 2052 | 62 | 0 | 31.43401703 | -86.99320044 | 2022-01-06 04:22:09 | Conecuh, Alabama, 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]);