johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
406 rows where confirmed = 1688 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3377158 | 3377158 | 2022-12-08 | China | Anhui | 1688 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-09 04:21:05 | Anhui, China | |||
1984429 | 1984429 | 2022-12-07 | China | Anhui | 1688 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-08 04:21:07 | Anhui, China | |||
3715296 | 3715296 | 2022-12-06 | US | Indiana | Ohio | 18115 | 1688 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-07 04:20:58 | Ohio, Indiana, US | |
2416001 | 2416001 | 2022-12-05 | US | Indiana | Ohio | 18115 | 1688 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-06 04:21:03 | Ohio, Indiana, US | |
719609 | 719609 | 2022-12-04 | US | Indiana | Ohio | 18115 | 1688 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-05 04:20:58 | Ohio, Indiana, US | |
2817898 | 2817898 | 2022-12-03 | US | Indiana | Ohio | 18115 | 1688 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-04 04:20:56 | Ohio, Indiana, US | |
834754 | 834754 | 2022-12-02 | US | Indiana | Ohio | 18115 | 1688 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-03 04:21:02 | Ohio, Indiana, US | |
2137284 | 2137284 | 2022-12-01 | US | Indiana | Ohio | 18115 | 1688 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-02 04:21:07 | Ohio, Indiana, US | |
1965700 | 1965700 | 2022-11-30 | US | Indiana | Ohio | 18115 | 1688 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-01 04:21:03 | Ohio, Indiana, US | |
1240109 | 1240109 | 2022-11-28 | US | Alaska | Yukon-Koyukuk | 2290 | 1688 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-11-29 04:21:05 | Yukon-Koyukuk, Alaska, US | |
3552097 | 3552097 | 2022-11-27 | US | Alaska | Yukon-Koyukuk | 2290 | 1688 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-11-28 04:21:02 | Yukon-Koyukuk, Alaska, US | |
2100577 | 2100577 | 2022-11-26 | US | Alaska | Yukon-Koyukuk | 2290 | 1688 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-11-27 04:21:05 | Yukon-Koyukuk, Alaska, US | |
488068 | 488068 | 2022-11-25 | US | Alaska | Yukon-Koyukuk | 2290 | 1688 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-11-26 04:21:11 | Yukon-Koyukuk, Alaska, US | |
3523897 | 3523897 | 2022-11-24 | US | Alaska | Yukon-Koyukuk | 2290 | 1688 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-11-25 04:21:06 | Yukon-Koyukuk, Alaska, US | |
3312680 | 3312680 | 2022-11-23 | US | Alaska | Yukon-Koyukuk | 2290 | 1688 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-11-24 04:21:09 | Yukon-Koyukuk, Alaska, US | |
1620721 | 1620721 | 2022-11-22 | US | Alaska | Yukon-Koyukuk | 2290 | 1688 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-11-23 04:21:06 | Yukon-Koyukuk, Alaska, US | |
1050469 | 1050469 | 2022-11-06 | US | Colorado | Huerfano | 8055 | 1688 | 39 | 0 | 37.68473101 | -104.9612585 | 2022-11-07 04:21:26 | Huerfano, Colorado, US | |
618493 | 618493 | 2022-11-05 | US | Colorado | Huerfano | 8055 | 1688 | 39 | 0 | 37.68473101 | -104.9612585 | 2022-11-06 04:21:24 | Huerfano, Colorado, US | |
1022997 | 1022997 | 2022-11-04 | US | Colorado | Huerfano | 8055 | 1688 | 39 | 0 | 37.68473101 | -104.9612585 | 2022-11-05 04:21:52 | Huerfano, Colorado, US | |
434913 | 434913 | 2022-11-03 | US | Wisconsin | Iron | 55051 | 1688 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-11-04 04:22:11 | Iron, Wisconsin, US | |
434381 | 434381 | 2022-11-03 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-11-04 04:22:11 | Bailey, Texas, US | |
852623 | 852623 | 2022-11-02 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-11-03 04:22:05 | Bailey, Texas, US | |
713641 | 713641 | 2022-11-01 | US | Texas | Newton | 48351 | 1688 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-02 04:22:09 | Newton, Texas, US | |
713474 | 713474 | 2022-11-01 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-11-02 04:22:09 | Bailey, Texas, US | |
711283 | 711283 | 2022-11-01 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-11-02 04:22:09 | Jenkins, Georgia, US | |
3288090 | 3288090 | 2022-10-31 | US | Texas | Newton | 48351 | 1688 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-01 04:22:36 | Newton, Texas, US | |
3287923 | 3287923 | 2022-10-31 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-11-01 04:22:36 | Bailey, Texas, US | |
3285732 | 3285732 | 2022-10-31 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-11-01 04:22:36 | Jenkins, Georgia, US | |
322956 | 322956 | 2022-10-30 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-31 04:21:36 | Bailey, Texas, US | |
320765 | 320765 | 2022-10-30 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-31 04:21:36 | Jenkins, Georgia, US | |
915232 | 915232 | 2022-10-29 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-30 04:22:14 | Bailey, Texas, US | |
913041 | 913041 | 2022-10-29 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-30 04:22:14 | Jenkins, Georgia, US | |
1369501 | 1369501 | 2022-10-28 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-29 04:21:13 | Bailey, Texas, US | |
1367310 | 1367310 | 2022-10-28 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-29 04:21:13 | Jenkins, Georgia, US | |
3041356 | 3041356 | 2022-10-27 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-28 04:22:31 | Bailey, Texas, US | |
3039165 | 3039165 | 2022-10-27 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-28 04:22:31 | Jenkins, Georgia, US | |
541776 | 541776 | 2022-10-26 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-27 04:22:01 | Bailey, Texas, US | |
539585 | 539585 | 2022-10-26 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-27 04:22:01 | Jenkins, Georgia, US | |
1833177 | 1833177 | 2022-10-25 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-26 04:22:19 | Bailey, Texas, US | |
1830986 | 1830986 | 2022-10-25 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-26 04:22:19 | Jenkins, Georgia, US | |
797746 | 797746 | 2022-10-24 | US | Virginia | Cumberland | 51049 | 1688 | 29 | 0 | 37.51328851 | -78.24398086 | 2022-10-25 04:21:53 | Cumberland, Virginia, US | |
797438 | 797438 | 2022-10-24 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-25 04:21:53 | Bailey, Texas, US | |
795247 | 795247 | 2022-10-24 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-25 04:21:53 | Jenkins, Georgia, US | |
3279893 | 3279893 | 2022-10-23 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-24 04:22:29 | Bailey, Texas, US | |
3277702 | 3277702 | 2022-10-23 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-24 04:22:29 | Jenkins, Georgia, US | |
2270931 | 2270931 | 2022-10-22 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-23 04:22:46 | Bailey, Texas, US | |
2268740 | 2268740 | 2022-10-22 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-23 04:22:46 | Jenkins, Georgia, US | |
1595231 | 1595231 | 2022-10-21 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-22 04:22:53 | Bailey, Texas, US | |
1593040 | 1593040 | 2022-10-21 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-22 04:22:53 | Jenkins, Georgia, US | |
2274947 | 2274947 | 2022-10-20 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-21 04:22:23 | Bailey, Texas, US | |
2272756 | 2272756 | 2022-10-20 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-21 04:22:23 | Jenkins, Georgia, US | |
201282 | 201282 | 2022-10-19 | US | Texas | Bailey | 48017 | 1688 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-10-20 04:22:59 | Bailey, Texas, US | |
199091 | 199091 | 2022-10-19 | US | Georgia | Jenkins | 13165 | 1688 | 67 | 0 | 32.79248718 | -81.96040187 | 2022-10-20 04:22:59 | Jenkins, Georgia, US | |
3252547 | 3252547 | 2022-10-11 | US | North Dakota | Dickey | 38021 | 1688 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-10-12 04:22:51 | Dickey, North Dakota, US | |
3548498 | 3548498 | 2022-09-01 | US | Illinois | Gallatin | 17059 | 1688 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-09-02 04:21:07 | Gallatin, Illinois, US | |
3775066 | 3775066 | 2022-08-30 | US | Iowa | Adair | 19001 | 1688 | 51 | 0 | 41.33075609 | -94.47105874 | 2022-08-31 04:20:57 | Adair, Iowa, US | |
1681662 | 1681662 | 2022-08-29 | US | Iowa | Adair | 19001 | 1688 | 51 | 0 | 41.33075609 | -94.47105874 | 2022-08-30 04:21:03 | Adair, Iowa, US | |
1878146 | 1878146 | 2022-08-28 | US | Iowa | Adair | 19001 | 1688 | 51 | 0 | 41.33075609 | -94.47105874 | 2022-08-29 04:21:06 | Adair, Iowa, US | |
2097273 | 2097273 | 2022-08-27 | US | Iowa | Adair | 19001 | 1688 | 51 | 0 | 41.33075609 | -94.47105874 | 2022-08-28 04:21:02 | Adair, Iowa, US | |
1533088 | 1533088 | 2022-08-26 | US | Iowa | Adair | 19001 | 1688 | 51 | 0 | 41.33075609 | -94.47105874 | 2022-08-27 04:20:57 | Adair, Iowa, US | |
2829975 | 2829975 | 2022-08-25 | US | Iowa | Adair | 19001 | 1688 | 51 | 0 | 41.33075609 | -94.47105874 | 2022-08-26 04:21:02 | Adair, Iowa, US | |
2324508 | 2324508 | 2022-08-24 | US | Iowa | Adair | 19001 | 1688 | 51 | 0 | 41.33075609 | -94.47105874 | 2022-08-25 04:21:13 | Adair, Iowa, US | |
2403884 | 2403884 | 2022-08-21 | US | Illinois | Stark | 17175 | 1688 | 39 | 0 | 41.09309773 | -89.79745866 | 2022-08-22 04:20:38 | Stark, Illinois, US | |
3798962 | 3798962 | 2022-08-20 | US | Illinois | Stark | 17175 | 1688 | 39 | 0 | 41.09309773 | -89.79745866 | 2022-08-21 04:20:44 | Stark, Illinois, US | |
2364548 | 2364548 | 2022-08-19 | US | Illinois | Stark | 17175 | 1688 | 39 | 0 | 41.09309773 | -89.79745866 | 2022-08-20 04:21:01 | Stark, Illinois, US | |
1162219 | 1162219 | 2022-08-18 | US | Illinois | Stark | 17175 | 1688 | 39 | 0 | 41.09309773 | -89.79745866 | 2022-08-19 04:20:54 | Stark, Illinois, US | |
3951543 | 3951543 | 2022-08-17 | US | Illinois | Stark | 17175 | 1688 | 39 | 0 | 41.09309773 | -89.79745866 | 2022-08-18 04:21:11 | Stark, Illinois, US | |
1087260 | 1087260 | 2022-08-09 | US | Iowa | Davis | 19051 | 1688 | 34 | 0 | 40.74773536 | -92.41005468 | 2022-08-10 04:20:57 | Davis, Iowa, US | |
3544675 | 3544675 | 2022-08-08 | US | Iowa | Davis | 19051 | 1688 | 34 | 0 | 40.74773536 | -92.41005468 | 2022-08-09 04:20:34 | Davis, Iowa, US | |
1071078 | 1071078 | 2022-08-07 | US | Iowa | Davis | 19051 | 1688 | 34 | 0 | 40.74773536 | -92.41005468 | 2022-08-08 04:21:08 | Davis, Iowa, US | |
1941666 | 1941666 | 2022-08-06 | US | Iowa | Davis | 19051 | 1688 | 34 | 0 | 40.74773536 | -92.41005468 | 2022-08-07 04:20:54 | Davis, Iowa, US | |
881465 | 881465 | 2022-08-05 | US | Iowa | Davis | 19051 | 1688 | 34 | 0 | 40.74773536 | -92.41005468 | 2022-08-06 04:20:56 | Davis, Iowa, US | |
2009876 | 2009876 | 2022-08-04 | US | Iowa | Davis | 19051 | 1688 | 34 | 0 | 40.74773536 | -92.41005468 | 2022-08-05 04:20:52 | Davis, Iowa, US | |
1099303 | 1099303 | 2022-08-03 | US | Iowa | Davis | 19051 | 1688 | 34 | 0 | 40.74773536 | -92.41005468 | 2022-08-04 04:20:58 | Davis, Iowa, US | |
3111876 | 3111876 | 2022-07-13 | US | North Dakota | Bottineau | 38009 | 1688 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-07-14 04:20:57 | Bottineau, North Dakota, US | |
2791656 | 2791656 | 2022-07-10 | US | Oregon | Harney | 41025 | 1688 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-07-11 04:20:46 | Harney, Oregon, US | |
144609 | 144609 | 2022-07-09 | US | Oregon | Harney | 41025 | 1688 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-07-10 04:20:54 | Harney, Oregon, US | |
1419709 | 1419709 | 2022-07-08 | US | Oregon | Harney | 41025 | 1688 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-07-09 04:20:59 | Harney, Oregon, US | |
2743634 | 2743634 | 2022-07-07 | US | Oregon | Harney | 41025 | 1688 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-07-08 04:20:56 | Harney, Oregon, US | |
3967848 | 3967848 | 2022-07-05 | US | Kansas | Harper | 20077 | 1688 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-07-06 04:20:58 | Harper, Kansas, US | |
3079359 | 3079359 | 2022-07-04 | US | Kansas | Harper | 20077 | 1688 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-07-05 04:20:45 | Harper, Kansas, US | |
1768641 | 1768641 | 2022-07-03 | US | Kansas | Harper | 20077 | 1688 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-07-04 04:20:54 | Harper, Kansas, US | |
3366627 | 3366627 | 2022-07-02 | US | Kansas | Harper | 20077 | 1688 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-07-03 04:20:59 | Harper, Kansas, US | |
594956 | 594956 | 2022-07-01 | US | Kansas | Harper | 20077 | 1688 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-07-02 04:21:16 | Harper, Kansas, US | |
3941357 | 3941357 | 2022-06-30 | US | Kansas | Harper | 20077 | 1688 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-07-01 04:21:10 | Harper, Kansas, US | |
2491315 | 2491315 | 2022-06-29 | US | Kansas | Harper | 20077 | 1688 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-06-30 04:21:01 | Harper, Kansas, US | |
3272549 | 3272549 | 2022-06-19 | US | Texas | Brooks | 48047 | 1688 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-06-20 04:21:01 | Brooks, Texas, US | |
3985153 | 3985153 | 2022-06-15 | US | Oklahoma | Coal | 40029 | 1688 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-06-16 04:20:55 | Coal, Oklahoma, US | |
949394 | 949394 | 2022-06-14 | US | Oklahoma | Coal | 40029 | 1688 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-06-15 04:20:54 | Coal, Oklahoma, US | |
2981802 | 2981802 | 2022-06-13 | US | Oklahoma | Coal | 40029 | 1688 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-06-14 04:20:52 | Coal, Oklahoma, US | |
2237928 | 2237928 | 2022-06-12 | US | Oklahoma | Coal | 40029 | 1688 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-06-13 04:21:14 | Coal, Oklahoma, US | |
3144126 | 3144126 | 2022-06-11 | US | Oklahoma | Coal | 40029 | 1688 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-06-12 04:20:53 | Coal, Oklahoma, US | |
1947042 | 1947042 | 2022-06-10 | US | Oklahoma | Coal | 40029 | 1688 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-06-11 04:21:01 | Coal, Oklahoma, US | |
3160181 | 3160181 | 2022-06-09 | US | Oklahoma | Coal | 40029 | 1688 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-06-10 04:20:55 | Coal, Oklahoma, US | |
3727999 | 3727999 | 2022-06-07 | US | Minnesota | Wilkin | 27167 | 1688 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-06-08 04:20:55 | Wilkin, Minnesota, US | |
3726019 | 3726019 | 2022-06-07 | China | Liaoning | 1688 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-08 04:20:55 | Liaoning, China | |||
3887421 | 3887421 | 2022-06-06 | China | Liaoning | 1688 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-07 04:21:08 | Liaoning, China | |||
3593636 | 3593636 | 2022-05-23 | US | Colorado | Clear Creek | 8019 | 1688 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-05-24 04:20:57 | Clear Creek, Colorado, US | |
2895580 | 2895580 | 2022-04-21 | US | Texas | Marion | 48315 | 1688 | 59 | 0 | 32.79868409 | -94.35661230000001 | 2022-04-22 04:20:45 | Marion, Texas, US | |
2251840 | 2251840 | 2022-04-19 | US | Alaska | Aleutians West | 2016 | 1688 | 2 | 0 | 52.3233 | -174.1596 | 2022-04-20 04:20:45 | Aleutians West, Alaska, 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]);