johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
167 rows where confirmed = 4433 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1621578 | 1621578 | 2022-11-22 | US | Kansas | Jackson | 20085 | 4433 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-11-23 04:21:06 | Jackson, Kansas, US | |
3461466 | 3461466 | 2022-11-21 | US | Kansas | Jackson | 20085 | 4433 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-11-22 04:20:47 | Jackson, Kansas, US | |
1641651 | 1641651 | 2022-11-20 | US | Kansas | Jackson | 20085 | 4433 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-11-21 04:21:05 | Jackson, Kansas, US | |
2065208 | 2065208 | 2022-11-19 | US | Kansas | Jackson | 20085 | 4433 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-11-20 04:21:08 | Jackson, Kansas, US | |
1756602 | 1756602 | 2022-11-18 | US | Kansas | Jackson | 20085 | 4433 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-11-19 04:21:14 | Jackson, Kansas, US | |
3027595 | 3027595 | 2022-11-17 | US | Kansas | Jackson | 20085 | 4433 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-11-18 04:21:15 | Jackson, Kansas, US | |
3027316 | 3027316 | 2022-11-17 | US | Illinois | Massac | 17127 | 4433 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-11-18 04:21:15 | Massac, Illinois, US | |
2487306 | 2487306 | 2022-11-16 | US | Kansas | Jackson | 20085 | 4433 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-11-17 04:21:11 | Jackson, Kansas, US | |
2487027 | 2487027 | 2022-11-16 | US | Illinois | Massac | 17127 | 4433 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-11-17 04:21:11 | Massac, Illinois, US | |
3288233 | 3288233 | 2022-10-31 | US | Virginia | Dickenson | 51051 | 4433 | 64 | 0 | 37.12560977 | -82.35124171 | 2022-11-01 04:22:36 | Dickenson, Virginia, US | |
540971 | 540971 | 2022-10-26 | US | New Mexico | Socorro | 35053 | 4433 | 96 | 0 | 34.00715494 | -106.9298354 | 2022-10-27 04:22:01 | Socorro, New Mexico, US | |
1979565 | 1979565 | 2022-09-25 | US | Tennessee | Grundy | 47061 | 4433 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-09-26 04:20:52 | Grundy, Tennessee, US | |
2635207 | 2635207 | 2022-09-05 | US | Kentucky | Webster | 21233 | 4433 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-09-06 04:21:02 | Webster, Kentucky, US | |
2988771 | 2988771 | 2022-09-04 | US | Kentucky | Webster | 21233 | 4433 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-09-05 04:21:01 | Webster, Kentucky, US | |
2714456 | 2714456 | 2022-09-03 | US | Kentucky | Webster | 21233 | 4433 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-09-04 04:21:22 | Webster, Kentucky, US | |
1395161 | 1395161 | 2022-09-02 | US | Kentucky | Webster | 21233 | 4433 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-09-03 04:21:04 | Webster, Kentucky, US | |
3549401 | 3549401 | 2022-09-01 | US | Missouri | Cooper | 29053 | 4433 | 79 | 0 | 38.844478 | -92.80896081 | 2022-09-02 04:21:07 | Cooper, Missouri, US | |
3548990 | 3548990 | 2022-09-01 | US | Kentucky | Webster | 21233 | 4433 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-09-02 04:21:07 | Webster, Kentucky, US | |
2345321 | 2345321 | 2022-08-31 | US | Missouri | Cooper | 29053 | 4433 | 79 | 0 | 38.844478 | -92.80896081 | 2022-09-01 04:21:03 | Cooper, Missouri, US | |
2344910 | 2344910 | 2022-08-31 | US | Kentucky | Webster | 21233 | 4433 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-09-01 04:21:03 | Webster, Kentucky, US | |
3775801 | 3775801 | 2022-08-30 | US | Missouri | Cooper | 29053 | 4433 | 79 | 0 | 38.844478 | -92.80896081 | 2022-08-31 04:20:57 | Cooper, Missouri, US | |
3775390 | 3775390 | 2022-08-30 | US | Kentucky | Webster | 21233 | 4433 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-08-31 04:20:57 | Webster, Kentucky, US | |
1682397 | 1682397 | 2022-08-29 | US | Missouri | Cooper | 29053 | 4433 | 79 | 0 | 38.844478 | -92.80896081 | 2022-08-30 04:21:03 | Cooper, Missouri, US | |
1681986 | 1681986 | 2022-08-29 | US | Kentucky | Webster | 21233 | 4433 | 51 | 0 | 37.52168356 | -87.67989953 | 2022-08-30 04:21:03 | Webster, Kentucky, US | |
1878881 | 1878881 | 2022-08-28 | US | Missouri | Cooper | 29053 | 4433 | 79 | 0 | 38.844478 | -92.80896081 | 2022-08-29 04:21:06 | Cooper, Missouri, US | |
2098008 | 2098008 | 2022-08-27 | US | Missouri | Cooper | 29053 | 4433 | 79 | 0 | 38.844478 | -92.80896081 | 2022-08-28 04:21:02 | Cooper, Missouri, US | |
1533823 | 1533823 | 2022-08-26 | US | Missouri | Cooper | 29053 | 4433 | 79 | 0 | 38.844478 | -92.80896081 | 2022-08-27 04:20:57 | Cooper, Missouri, US | |
2496778 | 2496778 | 2022-08-15 | US | Puerto Rico | Guayanilla | 72059 | 4433 | 0 | 0 | 18.039942 | -66.79186 | 2022-08-16 04:20:58 | Guayanilla, Puerto Rico, US | |
1349321 | 1349321 | 2022-08-10 | US | Tennessee | Trousdale | 47169 | 4433 | 47 | 0 | 36.39026213 | -86.16087954 | 2022-08-11 04:20:49 | Trousdale, Tennessee, US | |
2009723 | 2009723 | 2022-08-04 | US | Illinois | Moultrie | 17139 | 4433 | 47 | 0 | 39.64187451 | -88.62099969 | 2022-08-05 04:20:52 | Moultrie, Illinois, US | |
1491120 | 1491120 | 2022-07-26 | US | Wisconsin | Burnett | 55013 | 4433 | 46 | 0 | 45.86303537 | -92.36711412 | 2022-07-27 04:21:04 | Burnett, Wisconsin, US | |
673649 | 673649 | 2022-07-21 | US | Virginia | Greene | 51079 | 4433 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-07-22 04:21:15 | Greene, Virginia, US | |
2422045 | 2422045 | 2022-07-15 | US | Texas | Lavaca | 48285 | 4433 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-16 04:21:05 | Lavaca, Texas, US | |
2150794 | 2150794 | 2022-06-27 | US | Texas | Lamb | 48279 | 4433 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-06-28 04:20:58 | Lamb, Texas, US | |
1651917 | 1651917 | 2022-06-23 | US | Wisconsin | Crawford | 55023 | 4433 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-06-24 04:20:58 | Crawford, Wisconsin, US | |
169392 | 169392 | 2022-06-21 | US | Virginia | Goochland | 51075 | 4433 | 53 | 0 | 37.71714806 | -77.90381514 | 2022-06-22 04:20:54 | Goochland, Virginia, US | |
167306 | 167306 | 2022-06-21 | US | Kansas | Atchison | 20005 | 4433 | 37 | 0 | 39.53185661 | -95.30870026 | 2022-06-22 04:20:54 | Atchison, Kansas, US | |
1764589 | 1764589 | 2022-06-20 | US | Kansas | Atchison | 20005 | 4433 | 37 | 0 | 39.53185661 | -95.30870026 | 2022-06-21 04:20:56 | Atchison, Kansas, US | |
3270775 | 3270775 | 2022-06-19 | US | Kansas | Atchison | 20005 | 4433 | 37 | 0 | 39.53185661 | -95.30870026 | 2022-06-20 04:21:01 | Atchison, Kansas, US | |
3398687 | 3398687 | 2022-06-18 | US | Kansas | Atchison | 20005 | 4433 | 37 | 0 | 39.53185661 | -95.30870026 | 2022-06-19 04:20:51 | Atchison, Kansas, US | |
2312564 | 2312564 | 2022-06-17 | US | Kansas | Atchison | 20005 | 4433 | 37 | 0 | 39.53185661 | -95.30870026 | 2022-06-18 04:21:10 | Atchison, Kansas, US | |
560068 | 560068 | 2022-06-16 | US | Kansas | Atchison | 20005 | 4433 | 37 | 0 | 39.53185661 | -95.30870026 | 2022-06-17 04:20:56 | Atchison, Kansas, US | |
3983870 | 3983870 | 2022-06-15 | US | Kansas | Atchison | 20005 | 4433 | 37 | 0 | 39.53185661 | -95.30870026 | 2022-06-16 04:20:55 | Atchison, Kansas, US | |
1316922 | 1316922 | 2022-05-27 | US | Puerto Rico | Barceloneta | 72017 | 4433 | 0 | 0 | 18.445533 | -66.560531 | 2022-05-28 04:21:07 | Barceloneta, Puerto Rico, US | |
466706 | 466706 | 2022-05-02 | US | Virginia | Bristol | 51520 | 4433 | 80 | 0 | 36.6163024 | -82.16359122 | 2022-05-03 04:21:00 | Bristol, Virginia, US | |
2252977 | 2252977 | 2022-04-19 | US | Louisiana | Winn | 22127 | 4433 | 63 | 0 | 31.94449367 | -92.63789413 | 2022-04-20 04:20:45 | Winn, Louisiana, US | |
2251858 | 2251858 | 2022-04-19 | US | Alaska | North Slope | 2185 | 4433 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-04-20 04:20:45 | North Slope, Alaska, US | |
1847527 | 1847527 | 2022-04-18 | US | Louisiana | Winn | 22127 | 4433 | 63 | 0 | 31.94449367 | -92.63789413 | 2022-04-19 04:21:00 | Winn, Louisiana, US | |
1846408 | 1846408 | 2022-04-18 | US | Alaska | North Slope | 2185 | 4433 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-04-19 04:21:00 | North Slope, Alaska, US | |
3417352 | 3417352 | 2022-04-17 | US | Alaska | North Slope | 2185 | 4433 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-04-18 04:21:12 | North Slope, Alaska, US | |
304301 | 304301 | 2022-04-16 | US | Alaska | North Slope | 2185 | 4433 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-04-17 04:20:59 | North Slope, Alaska, US | |
2670246 | 2670246 | 2022-04-15 | US | Alaska | North Slope | 2185 | 4433 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-04-16 04:20:48 | North Slope, Alaska, US | |
1224031 | 1224031 | 2022-04-14 | US | Alaska | North Slope | 2185 | 4433 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-04-15 04:20:57 | North Slope, Alaska, US | |
2443189 | 2443189 | 2022-04-13 | US | Alaska | North Slope | 2185 | 4433 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-04-13 23:21:06 | North Slope, Alaska, US | |
1439804 | 1439804 | 2022-03-28 | US | Texas | Shelby | 48419 | 4433 | 130 | 0 | 31.79211404 | -94.14550696 | 2022-03-29 04:20:46 | Shelby, Texas, US | |
879485 | 879485 | 2022-03-27 | US | Texas | Shelby | 48419 | 4433 | 130 | 0 | 31.79211404 | -94.14550696 | 2022-03-28 04:20:33 | Shelby, Texas, US | |
2166768 | 2166768 | 2022-03-26 | US | Texas | Shelby | 48419 | 4433 | 130 | 0 | 31.79211404 | -94.14550696 | 2022-03-27 04:20:47 | Shelby, Texas, US | |
1723704 | 1723704 | 2022-03-25 | US | Texas | Shelby | 48419 | 4433 | 130 | 0 | 31.79211404 | -94.14550696 | 2022-03-26 04:20:23 | Shelby, Texas, US | |
1905630 | 1905630 | 2022-03-22 | US | Alaska | Northwest Arctic | 2188 | 4433 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-03-23 04:20:48 | Northwest Arctic, Alaska, US | |
3238761 | 3238761 | 2022-03-21 | US | Alaska | Northwest Arctic | 2188 | 4433 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-03-22 04:20:54 | Northwest Arctic, Alaska, US | |
2203156 | 2203156 | 2022-03-06 | US | West Virginia | Taylor | 54091 | 4433 | 64 | 0 | 39.33602617 | -80.0421439 | 2022-03-07 04:20:47 | Taylor, West Virginia, US | |
2095613 | 2095613 | 2022-03-05 | US | West Virginia | Taylor | 54091 | 4433 | 64 | 0 | 39.33602617 | -80.0421439 | 2022-03-06 04:20:49 | Taylor, West Virginia, US | |
2669313 | 2669313 | 2022-03-04 | US | West Virginia | Taylor | 54091 | 4433 | 64 | 0 | 39.33602617 | -80.0421439 | 2022-03-05 04:21:10 | Taylor, West Virginia, US | |
1647878 | 1647878 | 2022-03-03 | US | West Virginia | Taylor | 54091 | 4433 | 64 | 0 | 39.33602617 | -80.0421439 | 2022-03-04 04:21:09 | Taylor, West Virginia, US | |
944262 | 944262 | 2022-02-28 | US | Kentucky | Lawrence | 21127 | 4433 | 59 | 0 | 38.07136018 | -82.72882223 | 2022-03-01 04:21:09 | Lawrence, Kentucky, US | |
2733402 | 2733402 | 2022-02-27 | US | Alabama | Henry | 1067 | 4433 | 69 | 0 | 31.51148016 | -85.24267944 | 2022-02-28 04:21:05 | Henry, Alabama, US | |
3046555 | 3046555 | 2022-02-26 | US | Alabama | Henry | 1067 | 4433 | 69 | 0 | 31.51148016 | -85.24267944 | 2022-02-27 04:21:04 | Henry, Alabama, US | |
1060541 | 1060541 | 2022-02-23 | US | Pennsylvania | Montour | 42093 | 4433 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-24 04:21:14 | Montour, Pennsylvania, US | |
3674790 | 3674790 | 2022-02-15 | US | Texas | Jones | 48253 | 4433 | 87 | 0 | 32.73997145 | -99.87861576 | 2022-02-16 04:21:10 | Jones, Texas, US | |
74470 | 74470 | 2022-02-07 | US | Virginia | New Kent | 51127 | 4433 | 30 | 0 | 37.50694406 | -76.99828634 | 2022-02-08 04:21:15 | New Kent, Virginia, US | |
2328919 | 2328919 | 2022-02-04 | US | Maine | Franklin | 23007 | 4433 | 49 | 0 | 44.97330019 | -70.44381045 | 2022-02-05 04:21:05 | Franklin, Maine, US | |
2477134 | 2477134 | 2022-02-03 | US | Texas | Montague | 48337 | 4433 | 114 | 0 | 33.67521893 | -97.72500958 | 2022-02-04 04:21:10 | Montague, Texas, US | |
460287 | 460287 | 2022-02-02 | US | Georgia | Worth | 13321 | 4433 | 103 | 0 | 31.55162306 | -83.85090513 | 2022-02-03 04:21:21 | Worth, Georgia, US | |
1143031 | 1143031 | 2022-01-23 | US | Nebraska | Saunders | 31155 | 4433 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2022-01-24 04:21:12 | Saunders, Nebraska, US | |
1141696 | 1141696 | 2022-01-23 | US | Georgia | Cook | 13075 | 4433 | 65 | 0 | 31.16068491 | -83.42947229 | 2022-01-24 04:21:12 | Cook, Georgia, US | |
2834949 | 2834949 | 2022-01-22 | US | Nebraska | Saunders | 31155 | 4433 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2022-01-23 04:21:13 | Saunders, Nebraska, US | |
2833614 | 2833614 | 2022-01-22 | US | Georgia | Cook | 13075 | 4433 | 65 | 0 | 31.16068491 | -83.42947229 | 2022-01-23 04:21:13 | Cook, Georgia, US | |
3427067 | 3427067 | 2022-01-21 | US | Nebraska | Saunders | 31155 | 4433 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2022-01-22 04:21:13 | Saunders, Nebraska, US | |
3425732 | 3425732 | 2022-01-21 | US | Georgia | Cook | 13075 | 4433 | 65 | 0 | 31.16068491 | -83.42947229 | 2022-01-22 04:21:13 | Cook, Georgia, US | |
1963965 | 1963965 | 2022-01-20 | US | Virginia | Scott | 51169 | 4433 | 93 | 0 | 36.71466456 | -82.60171704 | 2022-01-21 04:21:09 | Scott, Virginia, US | |
1961388 | 1961388 | 2022-01-20 | US | Georgia | Lamar | 13171 | 4433 | 103 | 0 | 33.07841647 | -84.14263877 | 2022-01-21 04:21:09 | Lamar, Georgia, US | |
3229827 | 3229827 | 2022-01-19 | US | Virginia | Mecklenburg | 51117 | 4433 | 100 | 0 | 36.67882005 | -78.36131056 | 2022-01-20 04:21:07 | Mecklenburg, Virginia, US | |
3843607 | 3843607 | 2022-01-15 | US | Texas | Gillespie | 48171 | 4433 | 86 | 0 | 30.31824095 | -98.94676915 | 2022-01-16 04:21:12 | Gillespie, Texas, US | |
3690904 | 3690904 | 2022-01-13 | US | Virginia | Waynesboro | 51820 | 4433 | 55 | 0 | 38.06451466 | -78.90293905 | 2022-01-14 04:21:54 | Waynesboro, Virginia, US | |
1701716 | 1701716 | 2022-01-03 | US | Kentucky | Allen | 21003 | 4433 | 83 | 0 | 36.75197631 | -86.19457544 | 2022-01-04 04:22:17 | Allen, Kentucky, US | |
1670829 | 1670829 | 2021-12-29 | US | North Carolina | Transylvania | 37175 | 4433 | 53 | 0 | 35.20383864 | -82.79638423 | 2021-12-30 04:21:25 | Transylvania, North Carolina, US | |
1717290 | 1717290 | 2021-12-16 | US | Idaho | Elmore | 16039 | 4433 | 52 | 0 | 43.3507101 | -115.4701578 | 2021-12-17 04:22:14 | Elmore, Idaho, US | |
3727 | 3727 | 2021-12-02 | US | Virginia | Pulaski | 51155 | 4433 | 97 | 0 | 37.06474963 | -80.71229738 | 2021-12-03 04:23:05 | Pulaski, Virginia, US | |
3071577 | 3071577 | 2021-11-23 | US | Louisiana | West Baton Rouge | 22121 | 4433 | 78 | 0 | 30.46058217 | -91.30989571 | 2021-11-24 04:22:14 | West Baton Rouge, Louisiana, US | |
450855 | 450855 | 2021-11-17 | US | West Virginia | Hancock | 54029 | 4433 | 118 | 0 | 40.51943859 | -80.57461608 | 2021-11-18 04:21:33 | Hancock, West Virginia, US | |
3344775 | 3344775 | 2021-11-16 | US | New Hampshire | Carroll | 33003 | 4433 | 20 | 0 | 43.87498583 | -71.20430216 | 2021-11-17 04:21:48 | Carroll, New Hampshire, US | |
686852 | 686852 | 2021-11-13 | US | Arkansas | Jackson | 5067 | 4433 | 46 | 0 | 35.59802983 | -91.21494602 | 2021-11-14 04:21:31 | Jackson, Arkansas, US | |
88897 | 88897 | 2021-11-09 | US | Minnesota | Todd | 27153 | 4433 | 38 | 0 | 46.06996226 | -94.89785296 | 2021-11-10 04:21:38 | Todd, Minnesota, US | |
2003166 | 2003166 | 2021-11-07 | US | Ohio | Pike | 39131 | 4433 | 77 | 0 | 39.07634001 | -83.06769584 | 2021-11-08 04:21:43 | Pike, Ohio, US | |
683791 | 683791 | 2021-10-24 | US | Kentucky | Montgomery | 21173 | 4433 | 55 | 0 | 38.03253032 | -83.9145241 | 2021-10-25 04:22:31 | Montgomery, Kentucky, US | |
771799 | 771799 | 2021-10-23 | US | Kentucky | Montgomery | 21173 | 4433 | 55 | 0 | 38.03253032 | -83.9145241 | 2021-10-24 04:21:22 | Montgomery, Kentucky, US | |
1492013 | 1492013 | 2021-10-12 | US | Alabama | Winston | 1133 | 4433 | 99 | 0 | 34.15030532 | -87.37325922 | 2021-10-13 04:20:51 | Winston, Alabama, US | |
1236019 | 1236019 | 2021-09-27 | US | Alabama | Geneva | 1061 | 4433 | 117 | 0 | 31.09389027 | -85.83572839 | 2021-09-28 04:21:28 | Geneva, Alabama, US | |
3013685 | 3013685 | 2021-09-22 | US | North Carolina | Pasquotank | 37139 | 4433 | 93 | 0 | 36.26723798 | -76.25134778 | 2021-09-23 04:21:43 | Pasquotank, North Carolina, US | |
3013174 | 3013174 | 2021-09-22 | US | Mississippi | Prentiss | 28117 | 4433 | 77 | 0 | 34.61810501 | -88.51986294 | 2021-09-23 04:21:43 | Prentiss, 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]);