johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
187 rows where confirmed = 4206 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3222974 | 3222974 | 2022-12-25 | US | Arkansas | Van Buren | 5141 | 4206 | 66 | 0 | 35.58095779 | -92.51295036 | 2022-12-26 04:21:06 | Van Buren, Arkansas, US | |
1018888 | 1018888 | 2022-12-24 | US | Arkansas | Van Buren | 5141 | 4206 | 66 | 0 | 35.58095779 | -92.51295036 | 2022-12-25 04:21:04 | Van Buren, Arkansas, US | |
310980 | 310980 | 2022-12-13 | US | Texas | Freestone | 48161 | 4206 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-14 04:21:04 | Freestone, Texas, US | |
1152041 | 1152041 | 2022-12-12 | US | Texas | Freestone | 48161 | 4206 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-13 04:21:01 | Freestone, Texas, US | |
1150885 | 1150885 | 2022-12-12 | US | Missouri | Moniteau | 29135 | 4206 | 60 | 0 | 38.63571781 | -92.57976951 | 2022-12-13 04:21:01 | Moniteau, Missouri, US | |
871895 | 871895 | 2022-12-11 | US | Texas | Freestone | 48161 | 4206 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-12 04:21:01 | Freestone, Texas, US | |
870739 | 870739 | 2022-12-11 | US | Missouri | Moniteau | 29135 | 4206 | 60 | 0 | 38.63571781 | -92.57976951 | 2022-12-12 04:21:01 | Moniteau, Missouri, US | |
260425 | 260425 | 2022-12-10 | US | Texas | Freestone | 48161 | 4206 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-11 04:20:50 | Freestone, Texas, US | |
259269 | 259269 | 2022-12-10 | US | Missouri | Moniteau | 29135 | 4206 | 60 | 0 | 38.63571781 | -92.57976951 | 2022-12-11 04:20:50 | Moniteau, Missouri, US | |
3939139 | 3939139 | 2022-12-09 | US | Texas | Freestone | 48161 | 4206 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-10 04:21:02 | Freestone, Texas, US | |
3937983 | 3937983 | 2022-12-09 | US | Missouri | Moniteau | 29135 | 4206 | 60 | 0 | 38.63571781 | -92.57976951 | 2022-12-10 04:21:02 | Moniteau, Missouri, US | |
3380471 | 3380471 | 2022-12-08 | US | Texas | Freestone | 48161 | 4206 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-09 04:21:05 | Freestone, Texas, US | |
3379315 | 3379315 | 2022-12-08 | US | Missouri | Moniteau | 29135 | 4206 | 60 | 0 | 38.63571781 | -92.57976951 | 2022-12-09 04:21:05 | Moniteau, Missouri, US | |
1987742 | 1987742 | 2022-12-07 | US | Texas | Freestone | 48161 | 4206 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-08 04:21:07 | Freestone, Texas, US | |
1986586 | 1986586 | 2022-12-07 | US | Missouri | Moniteau | 29135 | 4206 | 60 | 0 | 38.63571781 | -92.57976951 | 2022-12-08 04:21:07 | Moniteau, Missouri, US | |
3716109 | 3716109 | 2022-12-06 | US | Missouri | Moniteau | 29135 | 4206 | 60 | 0 | 38.63571781 | -92.57976951 | 2022-12-07 04:20:58 | Moniteau, Missouri, US | |
1757570 | 1757570 | 2022-11-18 | US | New York | Schuyler | 36097 | 4206 | 31 | 0 | 42.39184015 | -76.8773299 | 2022-11-19 04:21:14 | Schuyler, New York, US | |
480807 | 480807 | 2022-11-08 | US | Iowa | Kossuth | 19109 | 4206 | 93 | 0 | 43.20405458 | -94.20691791 | 2022-11-09 04:21:22 | Kossuth, Iowa, US | |
2439957 | 2439957 | 2022-11-07 | US | Iowa | Kossuth | 19109 | 4206 | 93 | 0 | 43.20405458 | -94.20691791 | 2022-11-08 04:21:21 | Kossuth, Iowa, US | |
1051055 | 1051055 | 2022-11-06 | US | Iowa | Kossuth | 19109 | 4206 | 93 | 0 | 43.20405458 | -94.20691791 | 2022-11-07 04:21:26 | Kossuth, Iowa, US | |
619079 | 619079 | 2022-11-05 | US | Iowa | Kossuth | 19109 | 4206 | 93 | 0 | 43.20405458 | -94.20691791 | 2022-11-06 04:21:24 | Kossuth, Iowa, US | |
1023583 | 1023583 | 2022-11-04 | US | Iowa | Kossuth | 19109 | 4206 | 93 | 0 | 43.20405458 | -94.20691791 | 2022-11-05 04:21:52 | Kossuth, Iowa, US | |
432574 | 432574 | 2022-11-03 | US | Iowa | Kossuth | 19109 | 4206 | 93 | 0 | 43.20405458 | -94.20691791 | 2022-11-04 04:22:11 | Kossuth, Iowa, US | |
850816 | 850816 | 2022-11-02 | US | Iowa | Kossuth | 19109 | 4206 | 93 | 0 | 43.20405458 | -94.20691791 | 2022-11-03 04:22:05 | Kossuth, Iowa, US | |
2272953 | 2272953 | 2022-10-20 | US | Illinois | Menard | 17129 | 4206 | 25 | 0 | 40.02742725 | -89.80246001 | 2022-10-21 04:22:23 | Menard, Illinois, US | |
200546 | 200546 | 2022-10-19 | US | New York | Yates | 36123 | 4206 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-10-20 04:22:59 | Yates, New York, US | |
133664 | 133664 | 2022-10-04 | US | South Dakota | Union | 46127 | 4206 | 52 | 0 | 42.83112163 | -96.6557828 | 2022-10-05 04:23:06 | Union, South Dakota, US | |
2688611 | 2688611 | 2022-10-03 | US | South Dakota | Union | 46127 | 4206 | 52 | 0 | 42.83112163 | -96.6557828 | 2022-10-04 04:22:55 | Union, South Dakota, US | |
2262678 | 2262678 | 2022-10-02 | US | South Dakota | Union | 46127 | 4206 | 52 | 0 | 42.83112163 | -96.6557828 | 2022-10-03 04:23:11 | Union, South Dakota, US | |
2998204 | 2998204 | 2022-10-01 | US | South Dakota | Union | 46127 | 4206 | 52 | 0 | 42.83112163 | -96.6557828 | 2022-10-02 04:21:23 | Union, South Dakota, US | |
856530 | 856530 | 2022-09-30 | US | South Dakota | Union | 46127 | 4206 | 52 | 0 | 42.83112163 | -96.6557828 | 2022-10-01 04:23:01 | Union, South Dakota, US | |
2378456 | 2378456 | 2022-09-29 | US | South Dakota | Union | 46127 | 4206 | 52 | 0 | 42.83112163 | -96.6557828 | 2022-09-30 04:23:09 | Union, South Dakota, US | |
1563007 | 1563007 | 2022-09-28 | US | South Dakota | Union | 46127 | 4206 | 52 | 0 | 42.83112163 | -96.6557828 | 2022-09-29 04:22:34 | Union, South Dakota, US | |
422423 | 422423 | 2022-09-18 | US | Texas | Falls | 48145 | 4206 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-19 04:21:49 | Falls, Texas, US | |
3376447 | 3376447 | 2022-09-17 | US | Texas | Falls | 48145 | 4206 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-18 04:22:50 | Falls, Texas, US | |
2358555 | 2358555 | 2022-09-16 | US | Texas | Falls | 48145 | 4206 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-17 04:20:19 | Falls, Texas, US | |
3989684 | 3989684 | 2022-09-15 | US | Texas | Colorado | 48089 | 4206 | 67 | 0 | 29.622098 | -96.5273805 | 2022-09-16 04:21:19 | Colorado, Texas, US | |
1892201 | 1892201 | 2022-09-14 | US | Texas | Colorado | 48089 | 4206 | 67 | 0 | 29.622098 | -96.5273805 | 2022-09-15 04:21:02 | Colorado, Texas, US | |
372686 | 372686 | 2022-09-13 | US | Arkansas | Franklin | 5047 | 4206 | 74 | 0 | 35.51202821 | -93.89299569 | 2022-09-14 04:20:44 | Franklin, Arkansas, US | |
371982 | 371982 | 2022-09-13 | China | Fujian | 4206 | 1 | 0 | 26.0789 | 117.9874 | 2022-09-14 04:20:44 | Fujian, China | |||
2635116 | 2635116 | 2022-09-05 | US | Kentucky | Clinton | 21053 | 4206 | 54 | 0 | 36.72581156 | -85.13377529 | 2022-09-06 04:21:02 | Clinton, Kentucky, US | |
2988680 | 2988680 | 2022-09-04 | US | Kentucky | Clinton | 21053 | 4206 | 54 | 0 | 36.72581156 | -85.13377529 | 2022-09-05 04:21:01 | Clinton, Kentucky, US | |
2714365 | 2714365 | 2022-09-03 | US | Kentucky | Clinton | 21053 | 4206 | 54 | 0 | 36.72581156 | -85.13377529 | 2022-09-04 04:21:22 | Clinton, Kentucky, US | |
1395070 | 1395070 | 2022-09-02 | US | Kentucky | Clinton | 21053 | 4206 | 54 | 0 | 36.72581156 | -85.13377529 | 2022-09-03 04:21:04 | Clinton, Kentucky, US | |
3548899 | 3548899 | 2022-09-01 | US | Kentucky | Clinton | 21053 | 4206 | 54 | 0 | 36.72581156 | -85.13377529 | 2022-09-02 04:21:07 | Clinton, Kentucky, US | |
2344819 | 2344819 | 2022-08-31 | US | Kentucky | Clinton | 21053 | 4206 | 54 | 0 | 36.72581156 | -85.13377529 | 2022-09-01 04:21:03 | Clinton, Kentucky, US | |
3775299 | 3775299 | 2022-08-30 | US | Kentucky | Clinton | 21053 | 4206 | 54 | 0 | 36.72581156 | -85.13377529 | 2022-08-31 04:20:57 | Clinton, Kentucky, US | |
1681895 | 1681895 | 2022-08-29 | US | Kentucky | Clinton | 21053 | 4206 | 54 | 0 | 36.72581156 | -85.13377529 | 2022-08-30 04:21:03 | Clinton, Kentucky, US | |
992051 | 992051 | 2022-08-16 | US | Illinois | Wabash | 17185 | 4206 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-08-17 04:20:59 | Wabash, Illinois, US | |
3544513 | 3544513 | 2022-08-08 | US | Illinois | Massac | 17127 | 4206 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-08-09 04:20:34 | Massac, Illinois, US | |
94406 | 94406 | 2022-07-23 | US | Texas | Young | 48503 | 4206 | 95 | 0 | 33.17659707 | -98.68790885 | 2022-07-24 04:20:47 | Young, Texas, US | |
673673 | 673673 | 2022-07-21 | US | Virginia | Manassas Park | 51685 | 4206 | 27 | 0 | 38.77058531 | -77.44399307 | 2022-07-22 04:21:15 | Manassas Park, Virginia, US | |
673245 | 673245 | 2022-07-21 | US | Tennessee | Grundy | 47061 | 4206 | 75 | 0 | 35.38433717 | -85.72142731 | 2022-07-22 04:21:15 | Grundy, Tennessee, US | |
1610804 | 1610804 | 2022-07-20 | US | Oklahoma | Choctaw | 40023 | 4206 | 64 | 0 | 34.02807439 | -95.54771129 | 2022-07-21 04:21:10 | Choctaw, Oklahoma, US | |
961437 | 961437 | 2022-07-19 | US | Oklahoma | Choctaw | 40023 | 4206 | 64 | 0 | 34.02807439 | -95.54771129 | 2022-07-20 04:20:59 | Choctaw, Oklahoma, US | |
3212824 | 3212824 | 2022-07-18 | US | Oklahoma | Choctaw | 40023 | 4206 | 64 | 0 | 34.02807439 | -95.54771129 | 2022-07-19 04:20:58 | Choctaw, Oklahoma, US | |
3407999 | 3407999 | 2022-07-17 | US | Oklahoma | Choctaw | 40023 | 4206 | 64 | 0 | 34.02807439 | -95.54771129 | 2022-07-18 04:20:59 | Choctaw, Oklahoma, US | |
2154199 | 2154199 | 2022-07-16 | US | Oklahoma | Choctaw | 40023 | 4206 | 64 | 0 | 34.02807439 | -95.54771129 | 2022-07-17 04:21:15 | Choctaw, Oklahoma, US | |
2421432 | 2421432 | 2022-07-15 | US | Oklahoma | Choctaw | 40023 | 4206 | 64 | 0 | 34.02807439 | -95.54771129 | 2022-07-16 04:21:05 | Choctaw, Oklahoma, US | |
3431507 | 3431507 | 2022-07-14 | US | Oklahoma | Choctaw | 40023 | 4206 | 64 | 0 | 34.02807439 | -95.54771129 | 2022-07-15 04:20:53 | Choctaw, Oklahoma, US | |
594178 | 594178 | 2022-07-01 | US | Arkansas | Polk | 5113 | 4206 | 150 | 0 | 34.48254879 | -94.22728802 | 2022-07-02 04:21:16 | Polk, Arkansas, US | |
2148000 | 2148000 | 2022-06-27 | US | Alabama | Clay | 1027 | 4206 | 82 | 0 | 33.26984193 | -85.85836077 | 2022-06-28 04:20:58 | Clay, Alabama, US | |
3400208 | 3400208 | 2022-06-18 | US | Puerto Rico | Santa Isabel | 72133 | 4206 | 0 | 0 | 17.994525 | -66.388913 | 2022-06-19 04:20:51 | Santa Isabel, Puerto Rico, US | |
950443 | 950443 | 2022-06-14 | US | Wisconsin | Washburn | 55129 | 4206 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-06-15 04:20:54 | Washburn, Wisconsin, US | |
3581976 | 3581976 | 2022-06-02 | US | Virginia | Greene | 51079 | 4206 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-06-03 04:20:58 | Greene, Virginia, US | |
3579631 | 3579631 | 2022-06-02 | US | Illinois | Jo Daviess | 17085 | 4206 | 36 | 0 | 42.36542373 | -90.21094405 | 2022-06-03 04:20:58 | Jo Daviess, Illinois, US | |
1853007 | 1853007 | 2022-05-26 | US | Texas | Aransas | 48007 | 4206 | 87 | 0 | 28.10556197 | -96.9995047 | 2022-05-27 04:20:56 | Aransas, Texas, US | |
3869322 | 3869322 | 2022-04-05 | US | Minnesota | Wadena | 27159 | 4206 | 54 | 0 | 46.58589171 | -94.96968506 | 2022-04-06 04:20:49 | Wadena, Minnesota, US | |
2750664 | 2750664 | 2022-04-04 | US | Minnesota | Wadena | 27159 | 4206 | 54 | 0 | 46.58589171 | -94.96968506 | 2022-04-05 04:20:48 | Wadena, Minnesota, US | |
3732010 | 3732010 | 2022-04-03 | US | Minnesota | Wadena | 27159 | 4206 | 54 | 0 | 46.58589171 | -94.96968506 | 2022-04-04 04:20:51 | Wadena, Minnesota, US | |
501445 | 501445 | 2022-04-02 | US | Minnesota | Wadena | 27159 | 4206 | 54 | 0 | 46.58589171 | -94.96968506 | 2022-04-03 04:20:48 | Wadena, Minnesota, US | |
3352430 | 3352430 | 2022-04-01 | US | Minnesota | Wadena | 27159 | 4206 | 54 | 0 | 46.58589171 | -94.96968506 | 2022-04-02 04:20:47 | Wadena, Minnesota, US | |
3239841 | 3239841 | 2022-03-21 | US | Louisiana | LaSalle | 22059 | 4206 | 56 | 0 | 31.67884782 | -92.15907765 | 2022-03-22 04:20:54 | LaSalle, Louisiana, US | |
2266614 | 2266614 | 2022-03-14 | US | Puerto Rico | Barranquitas | 72019 | 4206 | 0 | 0 | 18.201592 | -66.30963 | 2022-03-15 04:20:47 | Barranquitas, Puerto Rico, US | |
2143711 | 2143711 | 2022-03-09 | US | Wisconsin | Crawford | 55023 | 4206 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-03-10 04:20:48 | Crawford, Wisconsin, US | |
922676 | 922676 | 2022-03-08 | US | Tennessee | Sequatchie | 47153 | 4206 | 66 | 0 | 35.36979721 | -85.41022136 | 2022-03-09 04:20:59 | Sequatchie, Tennessee, US | |
1549767 | 1549767 | 2022-03-07 | US | Mississippi | Clarke | 28023 | 4206 | 106 | 0 | 32.04158545 | -88.68896219999998 | 2022-03-08 04:20:54 | Clarke, Mississippi, US | |
2200609 | 2200609 | 2022-03-06 | US | Illinois | Carroll | 17015 | 4206 | 47 | 0 | 42.06823429 | -89.93395545 | 2022-03-07 04:20:47 | Carroll, Illinois, US | |
2093066 | 2093066 | 2022-03-05 | US | Illinois | Carroll | 17015 | 4206 | 47 | 0 | 42.06823429 | -89.93395545 | 2022-03-06 04:20:49 | Carroll, Illinois, US | |
2666766 | 2666766 | 2022-03-04 | US | Illinois | Carroll | 17015 | 4206 | 47 | 0 | 42.06823429 | -89.93395545 | 2022-03-05 04:21:10 | Carroll, Illinois, US | |
186826 | 186826 | 2022-02-13 | US | Georgia | Ben Hill | 13017 | 4206 | 114 | 0 | 31.76095874 | -83.22145359 | 2022-02-14 04:20:51 | Ben Hill, Georgia, US | |
316672 | 316672 | 2022-02-12 | US | Georgia | Ben Hill | 13017 | 4206 | 114 | 0 | 31.76095874 | -83.22145359 | 2022-02-13 04:21:00 | Ben Hill, Georgia, US | |
233998 | 233998 | 2022-02-11 | US | Georgia | Ben Hill | 13017 | 4206 | 114 | 0 | 31.76095874 | -83.22145359 | 2022-02-12 04:21:06 | Ben Hill, Georgia, US | |
2477266 | 2477266 | 2022-02-03 | US | Virginia | Buchanan | 51027 | 4206 | 91 | 0 | 37.26818323 | -82.03749726 | 2022-02-04 04:21:10 | Buchanan, Virginia, US | |
2476566 | 2476566 | 2022-02-03 | US | Oregon | Clatsop | 41007 | 4206 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-04 04:21:10 | Clatsop, Oregon, US | |
1230531 | 1230531 | 2022-01-24 | US | Tennessee | Bledsoe | 47007 | 4206 | 43 | 0 | 35.59942968 | -85.20611967 | 2022-01-25 04:21:05 | Bledsoe, Tennessee, US | |
3688311 | 3688311 | 2022-01-13 | US | Georgia | Jones | 13169 | 4206 | 99 | 0 | 33.02512137 | -83.56019163 | 2022-01-14 04:21:54 | Jones, Georgia, US | |
1115305 | 1115305 | 2022-01-11 | US | Minnesota | Dodge | 27039 | 4206 | 14 | 0 | 44.02238415 | -92.86244324 | 2022-01-12 04:21:44 | Dodge, Minnesota, US | |
1693732 | 1693732 | 2022-01-10 | US | Kentucky | Hart | 21099 | 4206 | 85 | 0 | 37.29943898 | -85.88461055 | 2022-01-11 04:22:01 | Hart, Kentucky, US | |
731055 | 731055 | 2021-12-27 | US | Arkansas | Sevier | 5133 | 4206 | 63 | 0 | 33.99780401 | -94.2424869 | 2021-12-28 04:21:47 | Sevier, Arkansas, US | |
2112227 | 2112227 | 2021-12-26 | US | Arkansas | Sevier | 5133 | 4206 | 63 | 0 | 33.99780401 | -94.2424869 | 2021-12-27 04:21:58 | Sevier, Arkansas, US | |
2905082 | 2905082 | 2021-12-19 | US | Kentucky | Allen | 21003 | 4206 | 78 | 0 | 36.75197631 | -86.19457544 | 2021-12-20 04:21:43 | Allen, Kentucky, US | |
3499195 | 3499195 | 2021-12-15 | US | Tennessee | Wayne | 47181 | 4206 | 43 | 0 | 35.23868267 | -87.78644456 | 2021-12-16 04:22:11 | Wayne, Tennessee, US | |
1234926 | 1234926 | 2021-11-28 | US | Virginia | Accomack | 51001 | 4206 | 80 | 0 | 37.76707161 | -75.63234615 | 2021-11-29 04:22:30 | Accomack, Virginia, US | |
1361633 | 1361633 | 2021-11-27 | US | Virginia | Accomack | 51001 | 4206 | 80 | 0 | 37.76707161 | -75.63234615 | 2021-11-28 04:22:43 | Accomack, Virginia, US | |
761624 | 761624 | 2021-11-26 | US | Virginia | Accomack | 51001 | 4206 | 80 | 0 | 37.76707161 | -75.63234615 | 2021-11-27 04:22:45 | Accomack, Virginia, US | |
450073 | 450073 | 2021-11-17 | US | Pennsylvania | Susquehanna | 42115 | 4206 | 71 | 0 | 41.82147784 | -75.80071959 | 2021-11-18 04:21:33 | Susquehanna, Pennsylvania, US | |
3343706 | 3343706 | 2021-11-16 | US | Indiana | Fayette | 18041 | 4206 | 91 | 0 | 39.63684962 | -85.17797541 | 2021-11-17 04:21:48 | Fayette, Indiana, US | |
3495726 | 3495726 | 2021-10-26 | US | Wisconsin | Juneau | 55057 | 4206 | 35 | 0 | 43.92456975 | -90.11120239 | 2021-10-27 04:22:32 | Juneau, Wisconsin, US | |
493464 | 493464 | 2021-10-14 | US | Mississippi | Marion | 28091 | 4206 | 107 | 0 | 31.23132643 | -89.8209217 | 2021-10-15 04:21:26 | Marion, 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]);