johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
215 rows where confirmed = 4128 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331442 | 331442 | 2022-12-27 | US | Wisconsin | Buffalo | 55011 | 4128 | 13 | 0 | 44.37835084 | -91.75332578 | 2022-12-28 04:21:04 | Buffalo, Wisconsin, US | |
3554818 | 3554818 | 2022-11-27 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-28 04:21:02 | Madison, Texas, US | |
2103298 | 2103298 | 2022-11-26 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-27 04:21:05 | Madison, Texas, US | |
490789 | 490789 | 2022-11-25 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-26 04:21:11 | Madison, Texas, US | |
3526618 | 3526618 | 2022-11-24 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-25 04:21:06 | Madison, Texas, US | |
3315401 | 3315401 | 2022-11-23 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-24 04:21:09 | Madison, Texas, US | |
1623442 | 1623442 | 2022-11-22 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-23 04:21:06 | Madison, Texas, US | |
1622698 | 1622698 | 2022-11-22 | US | North Dakota | Ramsey | 38071 | 4128 | 57 | 0 | 48.26886249 | -98.72223879 | 2022-11-23 04:21:06 | Ramsey, North Dakota, US | |
3463330 | 3463330 | 2022-11-21 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-22 04:20:47 | Madison, Texas, US | |
3462586 | 3462586 | 2022-11-21 | US | North Dakota | Ramsey | 38071 | 4128 | 57 | 0 | 48.26886249 | -98.72223879 | 2022-11-22 04:20:47 | Ramsey, North Dakota, US | |
1643515 | 1643515 | 2022-11-20 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-21 04:21:05 | Madison, Texas, US | |
2067072 | 2067072 | 2022-11-19 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-20 04:21:08 | Madison, Texas, US | |
1758466 | 1758466 | 2022-11-18 | US | Texas | Madison | 48313 | 4128 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-19 04:21:14 | Madison, Texas, US | |
711089 | 711089 | 2022-11-01 | US | Colorado | Las Animas | 8071 | 4128 | 47 | 0 | 37.3153406 | -104.0376458 | 2022-11-02 04:22:09 | Las Animas, Colorado, US | |
201792 | 201792 | 2022-10-19 | US | Wisconsin | Bayfield | 55007 | 4128 | 44 | 0 | 46.52868768 | -91.19716729 | 2022-10-20 04:22:59 | Bayfield, Wisconsin, US | |
2035058 | 2035058 | 2022-10-14 | US | New York | Schuyler | 36097 | 4128 | 29 | 0 | 42.39184015 | -76.8773299 | 2022-10-15 04:22:00 | Schuyler, New York, US | |
3217579 | 3217579 | 2022-10-12 | US | Utah | Unassigned | 90049 | 4128 | 7 | 0 | 41.72330587 | 0.0 | 2022-10-13 04:22:39 | Unassigned, Utah, US | |
3253428 | 3253428 | 2022-10-11 | US | Utah | Unassigned | 90049 | 4128 | 7 | 0 | 41.72330587 | 0.0 | 2022-10-12 04:22:51 | Unassigned, Utah, US | |
2970687 | 2970687 | 2022-10-10 | US | Utah | Unassigned | 90049 | 4128 | 7 | 0 | 41.72330587 | 0.0 | 2022-10-11 04:23:05 | Unassigned, Utah, US | |
3100723 | 3100723 | 2022-10-09 | US | Utah | Unassigned | 90049 | 4128 | 7 | 0 | 41.72330587 | 0.0 | 2022-10-10 04:22:32 | Unassigned, Utah, US | |
4005948 | 4005948 | 2022-10-08 | US | Utah | Unassigned | 90049 | 4128 | 7 | 0 | 41.72330587 | 0.0 | 2022-10-09 04:21:16 | Unassigned, Utah, US | |
399545 | 399545 | 2022-10-07 | US | Utah | Unassigned | 90049 | 4128 | 7 | 0 | 41.72330587 | 0.0 | 2022-10-08 04:22:56 | Unassigned, Utah, US | |
399009 | 399009 | 2022-10-07 | US | Puerto Rico | Florida | 72054 | 4128 | 0 | 0 | 18.373715 | -66.560488 | 2022-10-08 04:22:56 | Florida, Puerto Rico, US | |
2532662 | 2532662 | 2022-10-06 | US | Utah | Unassigned | 90049 | 4128 | 7 | 0 | 41.72330587 | 0.0 | 2022-10-07 04:23:08 | Unassigned, Utah, US | |
2262051 | 2262051 | 2022-10-02 | US | New York | Yates | 36123 | 4128 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-10-03 04:23:11 | Yates, New York, US | |
2395828 | 2395828 | 2022-09-12 | US | Illinois | Menard | 17129 | 4128 | 25 | 0 | 40.02742725 | -89.80246001 | 2022-09-13 04:20:57 | Menard, Illinois, US | |
253874 | 253874 | 2022-09-08 | US | California | Mariposa | 6043 | 4128 | 37 | 0 | 37.57978556 | -119.9073334 | 2022-09-09 04:21:11 | Mariposa, California, US | |
2497090 | 2497090 | 2022-08-15 | US | Texas | Colorado | 48089 | 4128 | 67 | 0 | 29.622098 | -96.5273805 | 2022-08-16 04:20:58 | Colorado, Texas, US | |
1943252 | 1943252 | 2022-08-06 | US | Puerto Rico | Patillas | 72109 | 4128 | 0 | 0 | 18.03174 | -66.012242 | 2022-08-07 04:20:54 | Patillas, Puerto Rico, US | |
1098484 | 1098484 | 2022-08-03 | US | Alabama | Crenshaw | 1041 | 4128 | 102 | 0 | 31.72941803 | -86.31593104 | 2022-08-04 04:20:58 | Crenshaw, Alabama, US | |
1408406 | 1408406 | 2022-08-02 | US | Virginia | King William | 51101 | 4128 | 46 | 0 | 37.70965316 | -77.09384941 | 2022-08-03 04:20:59 | King William, Virginia, US | |
1405409 | 1405409 | 2022-08-02 | US | Alabama | Crenshaw | 1041 | 4128 | 102 | 0 | 31.72941803 | -86.31593104 | 2022-08-03 04:20:59 | Crenshaw, Alabama, US | |
3620322 | 3620322 | 2022-08-01 | US | Texas | Tyler | 48457 | 4128 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-08-02 04:20:53 | Tyler, Texas, US | |
3617447 | 3617447 | 2022-08-01 | US | Alabama | Crenshaw | 1041 | 4128 | 102 | 0 | 31.72941803 | -86.31593104 | 2022-08-02 04:20:53 | Crenshaw, Alabama, US | |
3871927 | 3871927 | 2022-07-31 | US | Alabama | Crenshaw | 1041 | 4128 | 102 | 0 | 31.72941803 | -86.31593104 | 2022-08-01 04:21:03 | Crenshaw, Alabama, US | |
674681 | 674681 | 2022-07-30 | US | Alabama | Crenshaw | 1041 | 4128 | 102 | 0 | 31.72941803 | -86.31593104 | 2022-07-31 04:21:02 | Crenshaw, Alabama, US | |
1783880 | 1783880 | 2022-07-29 | US | Alabama | Crenshaw | 1041 | 4128 | 102 | 0 | 31.72941803 | -86.31593104 | 2022-07-30 04:20:42 | Crenshaw, Alabama, US | |
632268 | 632268 | 2022-07-12 | US | North Carolina | Polk | 37149 | 4128 | 65 | 0 | 35.27820615 | -82.16812354 | 2022-07-13 04:20:58 | Polk, North Carolina, US | |
1213912 | 1213912 | 2022-07-11 | US | North Carolina | Polk | 37149 | 4128 | 65 | 0 | 35.27820615 | -82.16812354 | 2022-07-12 04:20:51 | Polk, North Carolina, US | |
2791394 | 2791394 | 2022-07-10 | US | North Carolina | Polk | 37149 | 4128 | 65 | 0 | 35.27820615 | -82.16812354 | 2022-07-11 04:20:46 | Polk, North Carolina, US | |
144347 | 144347 | 2022-07-09 | US | North Carolina | Polk | 37149 | 4128 | 65 | 0 | 35.27820615 | -82.16812354 | 2022-07-10 04:20:54 | Polk, North Carolina, US | |
1419447 | 1419447 | 2022-07-08 | US | North Carolina | Polk | 37149 | 4128 | 65 | 0 | 35.27820615 | -82.16812354 | 2022-07-09 04:20:59 | Polk, North Carolina, US | |
2743372 | 2743372 | 2022-07-07 | US | North Carolina | Polk | 37149 | 4128 | 65 | 0 | 35.27820615 | -82.16812354 | 2022-07-08 04:20:56 | Polk, North Carolina, US | |
2741401 | 2741401 | 2022-07-07 | US | Alabama | Macon | 1087 | 4128 | 85 | 0 | 32.38759944 | -85.69267724 | 2022-07-08 04:20:56 | Macon, Alabama, US | |
1202167 | 1202167 | 2022-07-06 | US | North Carolina | Polk | 37149 | 4128 | 65 | 0 | 35.27820615 | -82.16812354 | 2022-07-07 04:20:55 | Polk, North Carolina, US | |
594165 | 594165 | 2022-07-01 | US | Arkansas | Madison | 5087 | 4128 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-07-02 04:21:16 | Madison, Arkansas, US | |
2493282 | 2493282 | 2022-06-29 | US | Texas | Young | 48503 | 4128 | 95 | 0 | 33.17659707 | -98.68790885 | 2022-06-30 04:21:01 | Young, Texas, US | |
2150908 | 2150908 | 2022-06-27 | US | Texas | Zavala | 48507 | 4128 | 68 | 0 | 28.86617238 | -99.76050829 | 2022-06-28 04:20:58 | Zavala, Texas, US | |
478709 | 478709 | 2022-06-26 | US | Texas | Zavala | 48507 | 4128 | 68 | 0 | 28.86617238 | -99.76050829 | 2022-06-27 04:21:00 | Zavala, Texas, US | |
478219 | 478219 | 2022-06-26 | US | Puerto Rico | Sabana Grande | 72121 | 4128 | 0 | 0 | 18.08282 | -66.943758 | 2022-06-27 04:21:00 | Sabana Grande, Puerto Rico, US | |
3581975 | 3581975 | 2022-06-02 | US | Virginia | Grayson | 51077 | 4128 | 83 | 0 | 36.65677234 | -81.23215889 | 2022-06-03 04:20:58 | Grayson, Virginia, US | |
1851023 | 1851023 | 2022-05-26 | US | Illinois | Moultrie | 17139 | 4128 | 44 | 0 | 39.64187451 | -88.62099969 | 2022-05-27 04:20:56 | Moultrie, Illinois, US | |
624303 | 624303 | 2022-05-22 | US | North Dakota | Richland | 38077 | 4128 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-05-26 04:20:50 | Richland, North Dakota, US | |
1111999 | 1111999 | 2022-05-21 | US | North Dakota | Richland | 38077 | 4128 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-05-22 04:20:52 | Richland, North Dakota, US | |
1157625 | 1157625 | 2022-04-29 | US | Arkansas | Clay | 5021 | 4128 | 93 | 0 | 36.36826212 | -90.4148172 | 2022-04-30 04:21:05 | Clay, Arkansas, US | |
2895088 | 2895088 | 2022-04-21 | US | Pennsylvania | Fulton | 42057 | 4128 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-04-22 04:20:45 | Fulton, Pennsylvania, US | |
2252613 | 2252613 | 2022-04-19 | US | Iowa | Dickinson | 19059 | 4128 | 72 | 0 | 43.37787725 | -95.1510206 | 2022-04-20 04:20:45 | Dickinson, Iowa, US | |
1847163 | 1847163 | 2022-04-18 | US | Iowa | Dickinson | 19059 | 4128 | 72 | 0 | 43.37787725 | -95.1510206 | 2022-04-19 04:21:00 | Dickinson, Iowa, US | |
3418107 | 3418107 | 2022-04-17 | US | Iowa | Dickinson | 19059 | 4128 | 72 | 0 | 43.37787725 | -95.1510206 | 2022-04-18 04:21:12 | Dickinson, Iowa, US | |
305056 | 305056 | 2022-04-16 | US | Iowa | Dickinson | 19059 | 4128 | 72 | 0 | 43.37787725 | -95.1510206 | 2022-04-17 04:20:59 | Dickinson, Iowa, US | |
2671001 | 2671001 | 2022-04-15 | US | Iowa | Dickinson | 19059 | 4128 | 72 | 0 | 43.37787725 | -95.1510206 | 2022-04-16 04:20:48 | Dickinson, Iowa, US | |
1224786 | 1224786 | 2022-04-14 | US | Iowa | Dickinson | 19059 | 4128 | 72 | 0 | 43.37787725 | -95.1510206 | 2022-04-15 04:20:57 | Dickinson, Iowa, US | |
2443944 | 2443944 | 2022-04-13 | US | Iowa | Dickinson | 19059 | 4128 | 72 | 0 | 43.37787725 | -95.1510206 | 2022-04-13 23:21:06 | Dickinson, Iowa, US | |
2751192 | 2751192 | 2022-04-04 | US | North Carolina | Chowan | 37041 | 4128 | 56 | 0 | 36.12908077 | -76.60118385 | 2022-04-05 04:20:48 | Chowan, North Carolina, US | |
2166282 | 2166282 | 2022-03-26 | US | Puerto Rico | Coamo | 72043 | 4128 | 0 | 0 | 18.097597 | -66.36014 | 2022-03-27 04:20:47 | Coamo, Puerto Rico, US | |
1905956 | 1905956 | 2022-03-22 | US | Georgia | Brantley | 13025 | 4128 | 106 | 0 | 31.19576557 | -81.97743999 | 2022-03-23 04:20:48 | Brantley, Georgia, US | |
2667366 | 2667366 | 2022-03-04 | US | Maine | Washington | 23029 | 4128 | 50 | 0 | 45.01607142 | -67.62813524 | 2022-03-05 04:21:10 | Washington, Maine, US | |
1646256 | 1646256 | 2022-03-03 | US | Missouri | Cooper | 29053 | 4128 | 74 | 0 | 38.844478 | -92.80896081 | 2022-03-04 04:21:09 | Cooper, Missouri, US | |
318908 | 318908 | 2022-02-12 | US | Tennessee | Sequatchie | 47153 | 4128 | 64 | 0 | 35.36979721 | -85.41022136 | 2022-02-13 04:21:00 | Sequatchie, Tennessee, US | |
2013462 | 2013462 | 2022-02-06 | US | Georgia | Ben Hill | 13017 | 4128 | 114 | 0 | 31.76095874 | -83.22145359 | 2022-02-07 04:21:05 | Ben Hill, Georgia, US | |
1294791 | 1294791 | 2022-02-05 | US | Georgia | Ben Hill | 13017 | 4128 | 114 | 0 | 31.76095874 | -83.22145359 | 2022-02-06 04:21:00 | Ben Hill, Georgia, US | |
2328119 | 2328119 | 2022-02-04 | US | Georgia | Ben Hill | 13017 | 4128 | 114 | 0 | 31.76095874 | -83.22145359 | 2022-02-05 04:21:05 | Ben Hill, Georgia, US | |
2658850 | 2658850 | 2022-01-31 | US | Illinois | White | 17193 | 4128 | 38 | 0 | 38.08706198 | -88.17657461 | 2022-02-01 04:21:11 | White, Illinois, US | |
3301471 | 3301471 | 2022-01-30 | US | Kansas | Bourbon | 20011 | 4128 | 46 | 0 | 37.85508555 | -94.84865997 | 2022-01-31 04:21:09 | Bourbon, Kansas, US | |
3063262 | 3063262 | 2022-01-29 | US | Kansas | Bourbon | 20011 | 4128 | 46 | 0 | 37.85508555 | -94.84865997 | 2022-01-30 04:21:26 | Bourbon, Kansas, US | |
3811196 | 3811196 | 2022-01-28 | US | Kansas | Bourbon | 20011 | 4128 | 46 | 0 | 37.85508555 | -94.84865997 | 2022-01-29 04:21:10 | Bourbon, Kansas, US | |
1319681 | 1319681 | 2022-01-26 | US | Kentucky | Rockcastle | 21203 | 4128 | 51 | 0 | 37.36642393 | -84.31176452 | 2022-01-27 04:21:19 | Rockcastle, Kentucky, US | |
2053064 | 2053064 | 2022-01-25 | US | Iowa | Crawford | 19047 | 4128 | 49 | 0 | 42.03718237 | -95.3819718 | 2022-01-26 04:21:07 | Crawford, Iowa, US | |
1228795 | 1228795 | 2022-01-24 | US | Iowa | Crawford | 19047 | 4128 | 49 | 0 | 42.03718237 | -95.3819718 | 2022-01-25 04:21:05 | Crawford, Iowa, US | |
1142094 | 1142094 | 2022-01-23 | US | Iowa | Crawford | 19047 | 4128 | 49 | 0 | 42.03718237 | -95.3819718 | 2022-01-24 04:21:12 | Crawford, Iowa, US | |
2834012 | 2834012 | 2022-01-22 | US | Iowa | Crawford | 19047 | 4128 | 49 | 0 | 42.03718237 | -95.3819718 | 2022-01-23 04:21:13 | Crawford, Iowa, US | |
3428048 | 3428048 | 2022-01-21 | US | Texas | Gonzales | 48177 | 4128 | 92 | 0 | 29.45634206 | -97.49424032 | 2022-01-22 04:21:13 | Gonzales, Texas, US | |
3426130 | 3426130 | 2022-01-21 | US | Iowa | Crawford | 19047 | 4128 | 49 | 0 | 42.03718237 | -95.3819718 | 2022-01-22 04:21:13 | Crawford, Iowa, US | |
1961738 | 1961738 | 2022-01-20 | US | Iowa | Crawford | 19047 | 4128 | 49 | 0 | 42.03718237 | -95.3819718 | 2022-01-21 04:21:09 | Crawford, Iowa, US | |
3227633 | 3227633 | 2022-01-19 | US | Iowa | Crawford | 19047 | 4128 | 49 | 0 | 42.03718237 | -95.3819718 | 2022-01-20 04:21:07 | Crawford, Iowa, US | |
1287513 | 1287513 | 2022-01-04 | US | Louisiana | Grant | 22043 | 4128 | 79 | 0 | 31.59882456 | -92.56124347 | 2022-01-05 04:21:59 | Grant, Louisiana, US | |
801522 | 801522 | 2021-12-22 | US | Texas | Frio | 48163 | 4128 | 78 | 0 | 28.86751206 | -99.10804207 | 2021-12-23 04:21:21 | Frio, Texas, US | |
3831562 | 3831562 | 2021-12-21 | US | Texas | Frio | 48163 | 4128 | 78 | 0 | 28.86751206 | -99.10804207 | 2021-12-22 04:21:54 | Frio, Texas, US | |
1258180 | 1258180 | 2021-12-20 | US | Virginia | Salem | 51775 | 4128 | 81 | 0 | 37.2836193 | -80.06219455 | 2021-12-21 03:21:27 | Salem, Virginia, US | |
1257573 | 1257573 | 2021-12-20 | US | South Carolina | Abbeville | 45001 | 4128 | 53 | 0 | 34.22333378 | -82.46170658 | 2021-12-21 03:21:27 | Abbeville, South Carolina, US | |
1030903 | 1030903 | 2021-12-06 | US | Arkansas | Sevier | 5133 | 4128 | 61 | 0 | 33.99780401 | -94.2424869 | 2021-12-07 04:22:34 | Sevier, Arkansas, US | |
1741561 | 1741561 | 2021-12-05 | US | Illinois | McDonough | 17109 | 4128 | 66 | 0 | 40.45674722 | -90.67775541 | 2021-12-06 04:22:34 | McDonough, Illinois, US | |
138993 | 138993 | 2021-12-04 | US | Illinois | McDonough | 17109 | 4128 | 66 | 0 | 40.45674722 | -90.67775541 | 2021-12-05 04:22:25 | McDonough, Illinois, US | |
2196646 | 2196646 | 2021-12-03 | US | Illinois | McDonough | 17109 | 4128 | 66 | 0 | 40.45674722 | -90.67775541 | 2021-12-04 04:22:18 | McDonough, Illinois, US | |
1147118 | 1147118 | 2021-12-01 | US | New Mexico | Cibola | 35006 | 4128 | 149 | 0 | 34.91131525 | -107.998876 | 2021-12-02 04:22:37 | Cibola, New Mexico, US | |
3345759 | 3345759 | 2021-11-16 | US | Texas | Karnes | 48255 | 4128 | 56 | 0 | 28.90705334 | -97.85960149 | 2021-11-17 04:21:48 | Karnes, Texas, US | |
3345627 | 3345627 | 2021-11-16 | US | Tennessee | Wayne | 47181 | 4128 | 39 | 0 | 35.23868267 | -87.78644456 | 2021-11-17 04:21:48 | Wayne, Tennessee, US | |
1325527 | 1325527 | 2021-11-14 | US | Virginia | Accomack | 51001 | 4128 | 80 | 0 | 37.76707161 | -75.63234615 | 2021-11-15 04:21:36 | Accomack, Virginia, US | |
689653 | 689653 | 2021-11-13 | US | Virginia | Accomack | 51001 | 4128 | 80 | 0 | 37.76707161 | -75.63234615 | 2021-11-14 04:21:31 | Accomack, Virginia, US | |
717762 | 717762 | 2021-11-12 | US | Virginia | Accomack | 51001 | 4128 | 80 | 0 | 37.76707161 | -75.63234615 | 2021-11-13 04:21:38 | Accomack, Virginia, 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]);