johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
177 rows where confirmed = 5007 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331443 | 331443 | 2022-12-27 | US | Wisconsin | Burnett | 55013 | 5007 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-12-28 04:21:04 | Burnett, Wisconsin, US | |
3324071 | 3324071 | 2022-12-16 | China | Yunnan | 5007 | 2 | 0 | 24.974 | 101.487 | 2022-12-17 04:21:04 | Yunnan, China | |||
542583 | 542583 | 2022-12-15 | China | Yunnan | 5007 | 2 | 0 | 24.974 | 101.487 | 2022-12-16 04:21:01 | Yunnan, China | |||
348111 | 348111 | 2022-12-14 | China | Yunnan | 5007 | 2 | 0 | 24.974 | 101.487 | 2022-12-15 04:20:58 | Yunnan, China | |||
307699 | 307699 | 2022-12-13 | China | Yunnan | 5007 | 2 | 0 | 24.974 | 101.487 | 2022-12-14 04:21:04 | Yunnan, China | |||
3525471 | 3525471 | 2022-11-24 | US | Montana | Park | 30067 | 5007 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-25 04:21:06 | Park, Montana, US | |
3314254 | 3314254 | 2022-11-23 | US | Montana | Park | 30067 | 5007 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-24 04:21:09 | Park, Montana, US | |
1622295 | 1622295 | 2022-11-22 | US | Montana | Park | 30067 | 5007 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-23 04:21:06 | Park, Montana, US | |
3462183 | 3462183 | 2022-11-21 | US | Montana | Park | 30067 | 5007 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-22 04:20:47 | Park, Montana, US | |
1642368 | 1642368 | 2022-11-20 | US | Montana | Park | 30067 | 5007 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-21 04:21:05 | Park, Montana, US | |
2065925 | 2065925 | 2022-11-19 | US | Montana | Park | 30067 | 5007 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-20 04:21:08 | Park, Montana, US | |
1757319 | 1757319 | 2022-11-18 | US | Montana | Park | 30067 | 5007 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-19 04:21:14 | Park, Montana, US | |
320425 | 320425 | 2022-10-30 | US | Arkansas | Grant | 5053 | 5007 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-10-31 04:21:36 | Grant, Arkansas, US | |
1366970 | 1366970 | 2022-10-28 | US | Arkansas | Grant | 5053 | 5007 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-10-29 04:21:13 | Grant, Arkansas, US | |
3038825 | 3038825 | 2022-10-27 | US | Arkansas | Grant | 5053 | 5007 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-10-28 04:22:31 | Grant, Arkansas, US | |
539400 | 539400 | 2022-10-26 | US | Colorado | Otero | 8089 | 5007 | 133 | 0 | 37.9014485 | -103.7173385 | 2022-10-27 04:22:01 | Otero, Colorado, US | |
2272891 | 2272891 | 2022-10-20 | US | Illinois | Bond | 17005 | 5007 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-10-21 04:22:23 | Bond, Illinois, US | |
4005415 | 4005415 | 2022-10-08 | US | Puerto Rico | Guayanilla | 72059 | 5007 | 0 | 0 | 18.039942 | -66.79186 | 2022-10-09 04:21:16 | Guayanilla, Puerto Rico, US | |
3996931 | 3996931 | 2022-09-27 | US | North Carolina | Bertie | 37015 | 5007 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-28 04:23:01 | Bertie, North Carolina, US | |
2771259 | 2771259 | 2022-09-26 | US | North Carolina | Bertie | 37015 | 5007 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-27 04:23:01 | Bertie, North Carolina, US | |
1978912 | 1978912 | 2022-09-25 | US | North Carolina | Bertie | 37015 | 5007 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-26 04:20:52 | Bertie, North Carolina, US | |
2652079 | 2652079 | 2022-09-24 | US | North Carolina | Bertie | 37015 | 5007 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-25 04:23:31 | Bertie, North Carolina, US | |
386519 | 386519 | 2022-09-23 | US | North Carolina | Bertie | 37015 | 5007 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-24 04:21:40 | Bertie, North Carolina, US | |
1626585 | 1626585 | 2022-09-22 | US | North Carolina | Bertie | 37015 | 5007 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-23 04:23:13 | Bertie, North Carolina, US | |
1372789 | 1372789 | 2022-09-21 | US | North Carolina | Bertie | 37015 | 5007 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-22 04:22:56 | Bertie, North Carolina, US | |
1892492 | 1892492 | 2022-09-14 | US | Virginia | Goochland | 51075 | 5007 | 58 | 0 | 37.71714806 | -77.90381514 | 2022-09-15 04:21:02 | Goochland, Virginia, US | |
3748650 | 3748650 | 2022-09-07 | US | Wisconsin | Crawford | 55023 | 5007 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-09-08 04:21:02 | Crawford, Wisconsin, US | |
2854653 | 2854653 | 2022-08-22 | US | Mississippi | Calhoun | 28013 | 5007 | 73 | 0 | 33.93683395 | -89.33686647 | 2022-08-23 04:20:56 | Calhoun, Mississippi, US | |
2406266 | 2406266 | 2022-08-21 | US | Washington | Asotin | 53003 | 5007 | 72 | 0 | 46.18894415 | -117.2022851 | 2022-08-22 04:20:38 | Asotin, Washington, US | |
2404625 | 2404625 | 2022-08-21 | US | Mississippi | Calhoun | 28013 | 5007 | 73 | 0 | 33.93683395 | -89.33686647 | 2022-08-22 04:20:38 | Calhoun, Mississippi, US | |
3801344 | 3801344 | 2022-08-20 | US | Washington | Asotin | 53003 | 5007 | 72 | 0 | 46.18894415 | -117.2022851 | 2022-08-21 04:20:44 | Asotin, Washington, US | |
3800830 | 3800830 | 2022-08-20 | US | Tennessee | Bledsoe | 47007 | 5007 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-08-21 04:20:44 | Bledsoe, Tennessee, US | |
3799703 | 3799703 | 2022-08-20 | US | Mississippi | Calhoun | 28013 | 5007 | 73 | 0 | 33.93683395 | -89.33686647 | 2022-08-21 04:20:44 | Calhoun, Mississippi, US | |
2366930 | 2366930 | 2022-08-19 | US | Washington | Asotin | 53003 | 5007 | 72 | 0 | 46.18894415 | -117.2022851 | 2022-08-20 04:21:01 | Asotin, Washington, US | |
2366416 | 2366416 | 2022-08-19 | US | Tennessee | Bledsoe | 47007 | 5007 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-08-20 04:21:01 | Bledsoe, Tennessee, US | |
2365289 | 2365289 | 2022-08-19 | US | Mississippi | Calhoun | 28013 | 5007 | 73 | 0 | 33.93683395 | -89.33686647 | 2022-08-20 04:21:01 | Calhoun, Mississippi, US | |
1162960 | 1162960 | 2022-08-18 | US | Mississippi | Calhoun | 28013 | 5007 | 73 | 0 | 33.93683395 | -89.33686647 | 2022-08-19 04:20:54 | Calhoun, Mississippi, US | |
3952284 | 3952284 | 2022-08-17 | US | Mississippi | Calhoun | 28013 | 5007 | 73 | 0 | 33.93683395 | -89.33686647 | 2022-08-18 04:21:11 | Calhoun, Mississippi, US | |
3952004 | 3952004 | 2022-08-17 | US | Louisiana | Jackson | 22049 | 5007 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-18 04:21:11 | Jackson, Louisiana, US | |
992786 | 992786 | 2022-08-16 | US | Mississippi | Calhoun | 28013 | 5007 | 73 | 0 | 33.93683395 | -89.33686647 | 2022-08-17 04:20:59 | Calhoun, Mississippi, US | |
2495825 | 2495825 | 2022-08-15 | US | Mississippi | Calhoun | 28013 | 5007 | 73 | 0 | 33.93683395 | -89.33686647 | 2022-08-16 04:20:58 | Calhoun, Mississippi, US | |
1089282 | 1089282 | 2022-08-09 | US | Texas | Reeves | 48389 | 5007 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-10 04:20:57 | Reeves, Texas, US | |
3546697 | 3546697 | 2022-08-08 | US | Texas | Reeves | 48389 | 5007 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-09 04:20:34 | Reeves, Texas, US | |
2336367 | 2336367 | 2022-07-27 | US | Illinois | Cass | 17017 | 5007 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-07-28 04:20:56 | Cass, Illinois, US | |
478755 | 478755 | 2022-06-26 | US | Virginia | Buchanan | 51027 | 5007 | 124 | 0 | 37.26818323 | -82.03749726 | 2022-06-27 04:21:00 | Buchanan, Virginia, US | |
942130 | 942130 | 2022-06-25 | US | Virginia | Buchanan | 51027 | 5007 | 124 | 0 | 37.26818323 | -82.03749726 | 2022-06-26 04:21:02 | Buchanan, Virginia, US | |
3349950 | 3349950 | 2022-06-24 | US | Virginia | Buchanan | 51027 | 5007 | 124 | 0 | 37.26818323 | -82.03749726 | 2022-06-25 04:20:57 | Buchanan, Virginia, US | |
1651966 | 1651966 | 2022-06-23 | US | Wisconsin | Taylor | 55119 | 5007 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-06-24 04:20:58 | Taylor, Wisconsin, US | |
3985786 | 3985786 | 2022-06-15 | US | Texas | Milam | 48331 | 5007 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-06-16 04:20:55 | Milam, Texas, US | |
3726825 | 3726825 | 2022-06-07 | US | Colorado | Chaffee | 8015 | 5007 | 48 | 0 | 38.74745778 | -106.1926573 | 2022-06-08 04:20:55 | Chaffee, Colorado, US | |
3890839 | 3890839 | 2022-06-06 | US | Texas | Scurry | 48415 | 5007 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-06-07 04:21:08 | Scurry, Texas, US | |
3535889 | 3535889 | 2022-05-10 | US | Alaska | Kodiak Island | 2150 | 5007 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-11 04:20:48 | Kodiak Island, Alaska, US | |
222424 | 222424 | 2022-05-09 | US | Alaska | Kodiak Island | 2150 | 5007 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-10 04:20:50 | Kodiak Island, Alaska, US | |
2331809 | 2331809 | 2022-05-08 | US | Alaska | Kodiak Island | 2150 | 5007 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-09 04:20:54 | Kodiak Island, Alaska, US | |
360771 | 360771 | 2022-05-07 | US | Alaska | Kodiak Island | 2150 | 5007 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-08 04:20:49 | Kodiak Island, Alaska, US | |
1398122 | 1398122 | 2022-05-06 | US | Alaska | Kodiak Island | 2150 | 5007 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-07 04:21:09 | Kodiak Island, Alaska, US | |
2598477 | 2598477 | 2022-05-05 | US | Alaska | Kodiak Island | 2150 | 5007 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-06 04:21:00 | Kodiak Island, Alaska, US | |
3265926 | 3265926 | 2022-05-04 | US | Alaska | Kodiak Island | 2150 | 5007 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-05 04:20:55 | Kodiak Island, Alaska, US | |
1574447 | 1574447 | 2022-05-03 | US | North Carolina | Currituck | 37053 | 5007 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-05-04 04:20:59 | Currituck, North Carolina, US | |
465707 | 465707 | 2022-05-02 | US | North Carolina | Currituck | 37053 | 5007 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-05-03 04:21:00 | Currituck, North Carolina, US | |
3918346 | 3918346 | 2022-05-01 | US | North Carolina | Currituck | 37053 | 5007 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-05-02 04:21:10 | Currituck, North Carolina, US | |
2843150 | 2843150 | 2022-04-30 | US | North Carolina | Currituck | 37053 | 5007 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-05-01 04:20:57 | Currituck, North Carolina, US | |
1159463 | 1159463 | 2022-04-29 | US | North Carolina | Currituck | 37053 | 5007 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-30 04:21:05 | Currituck, North Carolina, US | |
1698645 | 1698645 | 2022-04-28 | US | North Carolina | Currituck | 37053 | 5007 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-29 04:20:59 | Currituck, North Carolina, US | |
3854128 | 3854128 | 2022-04-27 | US | North Carolina | Currituck | 37053 | 5007 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-28 04:20:47 | Currituck, North Carolina, US | |
1951550 | 1951550 | 2022-04-12 | US | Texas | Burleson | 48051 | 5007 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-04-13 04:21:03 | Burleson, Texas, US | |
3209303 | 3209303 | 2022-04-11 | US | Texas | Burleson | 48051 | 5007 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-04-12 04:20:49 | Burleson, Texas, US | |
3209091 | 3209091 | 2022-04-11 | US | South Carolina | Hampton | 45049 | 5007 | 85 | 0 | 32.77419582 | -81.13845571 | 2022-04-12 04:20:49 | Hampton, South Carolina, US | |
1578977 | 1578977 | 2022-04-10 | US | South Carolina | Hampton | 45049 | 5007 | 85 | 0 | 32.77419582 | -81.13845571 | 2022-04-11 04:21:02 | Hampton, South Carolina, US | |
1655219 | 1655219 | 2022-04-09 | US | South Carolina | Hampton | 45049 | 5007 | 85 | 0 | 32.77419582 | -81.13845571 | 2022-04-10 04:20:52 | Hampton, South Carolina, US | |
2118541 | 2118541 | 2022-04-08 | US | South Carolina | Hampton | 45049 | 5007 | 85 | 0 | 32.77419582 | -81.13845571 | 2022-04-09 04:20:42 | Hampton, South Carolina, US | |
3323065 | 3323065 | 2022-04-07 | US | South Carolina | Hampton | 45049 | 5007 | 85 | 0 | 32.77419582 | -81.13845571 | 2022-04-08 04:20:48 | Hampton, South Carolina, US | |
2803601 | 2803601 | 2022-04-06 | US | South Carolina | Hampton | 45049 | 5007 | 85 | 0 | 32.77419582 | -81.13845571 | 2022-04-07 04:20:53 | Hampton, South Carolina, US | |
3870370 | 3870370 | 2022-04-05 | US | South Carolina | Hampton | 45049 | 5007 | 85 | 0 | 32.77419582 | -81.13845571 | 2022-04-06 04:20:49 | Hampton, South Carolina, US | |
1543433 | 1543433 | 2022-03-31 | US | West Virginia | Brooke | 54009 | 5007 | 106 | 0 | 40.27367263 | -80.57915332 | 2022-04-01 04:20:28 | Brooke, West Virginia, US | |
2321972 | 2321972 | 2022-03-16 | US | Oregon | Union | 41061 | 5007 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-17 04:20:56 | Union, Oregon, US | |
264172 | 264172 | 2022-03-15 | US | Oregon | Union | 41061 | 5007 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-16 04:20:50 | Union, Oregon, US | |
2266531 | 2266531 | 2022-03-14 | US | Oregon | Union | 41061 | 5007 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-15 04:20:47 | Union, Oregon, US | |
2264928 | 2264928 | 2022-03-14 | US | Illinois | Pike | 17149 | 5007 | 65 | 0 | 39.62265059 | -90.8877017 | 2022-03-15 04:20:47 | Pike, Illinois, US | |
3630597 | 3630597 | 2022-03-13 | US | Oregon | Union | 41061 | 5007 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-14 04:20:46 | Union, Oregon, US | |
953505 | 953505 | 2022-03-12 | US | Oregon | Union | 41061 | 5007 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-13 04:20:49 | Union, Oregon, US | |
358966 | 358966 | 2022-03-11 | US | Oregon | Union | 41061 | 5007 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-12 04:20:50 | Union, Oregon, US | |
921624 | 921624 | 2022-03-08 | US | Missouri | New Madrid | 29143 | 5007 | 83 | 0 | 36.59666326 | -89.66070007 | 2022-03-09 04:20:59 | New Madrid, Missouri, US | |
1549911 | 1549911 | 2022-03-07 | US | Missouri | New Madrid | 29143 | 5007 | 82 | 0 | 36.59666326 | -89.66070007 | 2022-03-08 04:20:54 | New Madrid, Missouri, US | |
1548815 | 1548815 | 2022-03-07 | US | Georgia | McDuffie | 13189 | 5007 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-03-08 04:20:54 | McDuffie, Georgia, US | |
2200484 | 2200484 | 2022-03-06 | US | Georgia | McDuffie | 13189 | 5007 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-03-07 04:20:47 | McDuffie, Georgia, US | |
2092941 | 2092941 | 2022-03-05 | US | Georgia | McDuffie | 13189 | 5007 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-03-06 04:20:49 | McDuffie, Georgia, US | |
2666641 | 2666641 | 2022-03-04 | US | Georgia | McDuffie | 13189 | 5007 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-03-05 04:21:10 | McDuffie, Georgia, US | |
1645206 | 1645206 | 2022-03-03 | US | Georgia | McDuffie | 13189 | 5007 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-03-04 04:21:09 | McDuffie, Georgia, US | |
2642107 | 2642107 | 2022-02-14 | US | Alabama | Cherokee | 1019 | 5007 | 74 | 0 | 34.17805983 | -85.60638968 | 2022-02-15 04:21:09 | Cherokee, Alabama, US | |
3076110 | 3076110 | 2022-02-09 | US | Nebraska | Dawson | 31047 | 5007 | 31 | 0 | 40.87028216 | -99.82014609999999 | 2022-02-10 04:21:14 | Dawson, Nebraska, US | |
2015184 | 2015184 | 2022-02-06 | US | Ohio | Holmes | 39075 | 5007 | 180 | 0 | 40.56163713 | -81.92635677 | 2022-02-07 04:21:05 | Holmes, Ohio, US | |
3301122 | 3301122 | 2022-01-30 | US | Hawaii | Out of HI | 80015 | 5007 | 12 | 0 | 22.03935037 | 0.0 | 2022-01-31 04:21:09 | Out of HI, Hawaii, US | |
1230394 | 1230394 | 2022-01-24 | US | Puerto Rico | San Sebastian | 72131 | 5007 | 0 | 0 | 18.328646 | -66.971214 | 2022-01-25 04:21:05 | San Sebastian, Puerto Rico, US | |
3425884 | 3425884 | 2022-01-21 | US | Idaho | Elmore | 16039 | 5007 | 55 | 0 | 43.3507101 | -115.4701578 | 2022-01-22 04:21:13 | Elmore, Idaho, US | |
1113937 | 1113937 | 2022-01-11 | US | Alabama | Bibb | 1007 | 5007 | 95 | 0 | 32.99642064 | -87.12511459999996 | 2022-01-12 04:21:44 | Bibb, Alabama, US | |
3520889 | 3520889 | 2022-01-02 | US | Kentucky | Ohio | 21183 | 5007 | 91 | 0 | 37.47751843 | -86.85368087 | 2022-01-03 02:22:25 | Ohio, Kentucky, US | |
2169019 | 2169019 | 2022-01-01 | US | Kentucky | Ohio | 21183 | 5007 | 91 | 0 | 37.47751843 | -86.85368087 | 2022-01-02 04:20:52 | Ohio, Kentucky, US | |
2778450 | 2778450 | 2021-12-31 | US | Kentucky | Ohio | 21183 | 5007 | 91 | 0 | 37.47751843 | -86.85368087 | 2022-01-01 04:22:14 | Ohio, Kentucky, US | |
4000107 | 4000107 | 2021-12-30 | US | Kentucky | Ohio | 21183 | 5007 | 91 | 0 | 37.47751843 | -86.85368087 | 2021-12-31 04:21:50 | Ohio, Kentucky, 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]);