johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
168 rows where confirmed = 4609 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1150843 | 1150843 | 2022-12-12 | US | Missouri | Cooper | 29053 | 4609 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-13 04:21:01 | Cooper, Missouri, US | |
870697 | 870697 | 2022-12-11 | US | Missouri | Cooper | 29053 | 4609 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-12 04:21:01 | Cooper, Missouri, US | |
259227 | 259227 | 2022-12-10 | US | Missouri | Cooper | 29053 | 4609 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-11 04:20:50 | Cooper, Missouri, US | |
3937941 | 3937941 | 2022-12-09 | US | Missouri | Cooper | 29053 | 4609 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-10 04:21:02 | Cooper, Missouri, US | |
3379273 | 3379273 | 2022-12-08 | US | Missouri | Cooper | 29053 | 4609 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-09 04:21:05 | Cooper, Missouri, US | |
3378400 | 3378400 | 2022-12-08 | US | Illinois | Mason | 17125 | 4609 | 66 | 0 | 40.23917274 | -89.91824452 | 2022-12-09 04:21:05 | Mason, Illinois, US | |
1986544 | 1986544 | 2022-12-07 | US | Missouri | Cooper | 29053 | 4609 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-08 04:21:07 | Cooper, Missouri, US | |
3716067 | 3716067 | 2022-12-06 | US | Missouri | Cooper | 29053 | 4609 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-07 04:20:58 | Cooper, Missouri, US | |
2816586 | 2816586 | 2022-12-03 | China | Yunnan | 4609 | 2 | 0 | 24.974 | 101.487 | 2022-12-04 04:20:56 | Yunnan, China | |||
1622701 | 1622701 | 2022-11-22 | US | North Dakota | Richland | 38077 | 4609 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-11-23 04:21:06 | Richland, North Dakota, US | |
2998026 | 2998026 | 2022-10-01 | US | Puerto Rico | Ciales | 72039 | 4609 | 0 | 0 | 18.28885 | -66.516475 | 2022-10-02 04:21:23 | Ciales, Puerto Rico, US | |
1374076 | 1374076 | 2022-09-21 | US | Wisconsin | Richland | 55103 | 4609 | 52 | 0 | 43.3762778 | -90.43012729 | 2022-09-22 04:22:56 | Richland, Wisconsin, US | |
3572466 | 3572466 | 2022-09-19 | US | Mississippi | Yalobusha | 28161 | 4609 | 61 | 0 | 34.02824175 | -89.7076205 | 2022-09-20 04:22:48 | Yalobusha, Mississippi, US | |
421205 | 421205 | 2022-09-18 | US | Mississippi | Yalobusha | 28161 | 4609 | 61 | 0 | 34.02824175 | -89.7076205 | 2022-09-19 04:21:49 | Yalobusha, Mississippi, US | |
3375229 | 3375229 | 2022-09-17 | US | Mississippi | Yalobusha | 28161 | 4609 | 61 | 0 | 34.02824175 | -89.7076205 | 2022-09-18 04:22:50 | Yalobusha, Mississippi, US | |
2357337 | 2357337 | 2022-09-16 | US | Mississippi | Yalobusha | 28161 | 4609 | 61 | 0 | 34.02824175 | -89.7076205 | 2022-09-17 04:20:19 | Yalobusha, Mississippi, US | |
3988494 | 3988494 | 2022-09-15 | US | Mississippi | Yalobusha | 28161 | 4609 | 61 | 0 | 34.02824175 | -89.7076205 | 2022-09-16 04:21:19 | Yalobusha, Mississippi, US | |
1891011 | 1891011 | 2022-09-14 | US | Mississippi | Yalobusha | 28161 | 4609 | 61 | 0 | 34.02824175 | -89.7076205 | 2022-09-15 04:21:02 | Yalobusha, Mississippi, US | |
2398115 | 2398115 | 2022-09-12 | US | Virginia | Buckingham | 51029 | 4609 | 60 | 0 | 37.57242268 | -78.52518834 | 2022-09-13 04:20:57 | Buckingham, Virginia, US | |
3766911 | 3766911 | 2022-09-11 | US | Illinois | Moultrie | 17139 | 4609 | 49 | 0 | 39.64187451 | -88.62099969 | 2022-09-12 04:20:58 | Moultrie, Illinois, US | |
3825486 | 3825486 | 2022-09-10 | US | Illinois | Moultrie | 17139 | 4609 | 49 | 0 | 39.64187451 | -88.62099969 | 2022-09-11 04:20:50 | Moultrie, Illinois, US | |
963943 | 963943 | 2022-09-09 | US | Illinois | Moultrie | 17139 | 4609 | 49 | 0 | 39.64187451 | -88.62099969 | 2022-09-10 04:21:10 | Moultrie, Illinois, US | |
254000 | 254000 | 2022-09-08 | US | Florida | Calhoun | 12013 | 4609 | 102 | 0 | 30.40666734 | -85.19394153 | 2022-09-09 04:21:11 | Calhoun, Florida, US | |
3745798 | 3745798 | 2022-09-07 | US | Florida | Calhoun | 12013 | 4609 | 102 | 0 | 30.40666734 | -85.19394153 | 2022-09-08 04:21:02 | Calhoun, Florida, US | |
115438 | 115438 | 2022-09-06 | US | Florida | Calhoun | 12013 | 4609 | 102 | 0 | 30.40666734 | -85.19394153 | 2022-09-07 04:20:59 | Calhoun, Florida, US | |
2634410 | 2634410 | 2022-09-05 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-09-06 04:21:02 | Calhoun, Florida, US | |
2987974 | 2987974 | 2022-09-04 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-09-05 04:21:01 | Calhoun, Florida, US | |
2713659 | 2713659 | 2022-09-03 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-09-04 04:21:22 | Calhoun, Florida, US | |
1394364 | 1394364 | 2022-09-02 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-09-03 04:21:04 | Calhoun, Florida, US | |
3548534 | 3548534 | 2022-09-01 | US | Illinois | Mercer | 17131 | 4609 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-09-02 04:21:07 | Mercer, Illinois, US | |
3548193 | 3548193 | 2022-09-01 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-09-02 04:21:07 | Calhoun, Florida, US | |
2346960 | 2346960 | 2022-08-31 | US | Wisconsin | Burnett | 55013 | 4609 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-09-01 04:21:03 | Burnett, Wisconsin, US | |
2344113 | 2344113 | 2022-08-31 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-09-01 04:21:03 | Calhoun, Florida, US | |
2343815 | 2343815 | 2022-08-31 | US | Alabama | Macon | 1087 | 4609 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-09-01 04:21:03 | Macon, Alabama, US | |
3777031 | 3777031 | 2022-08-30 | US | Texas | Houston | 48225 | 4609 | 113 | 0 | 31.31925973 | -95.42226208 | 2022-08-31 04:20:57 | Houston, Texas, US | |
3774593 | 3774593 | 2022-08-30 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-08-31 04:20:57 | Calhoun, Florida, US | |
3774295 | 3774295 | 2022-08-30 | US | Alabama | Macon | 1087 | 4609 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-31 04:20:57 | Macon, Alabama, US | |
1681189 | 1681189 | 2022-08-29 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-08-30 04:21:03 | Calhoun, Florida, US | |
1680891 | 1680891 | 2022-08-29 | US | Alabama | Macon | 1087 | 4609 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-30 04:21:03 | Macon, Alabama, US | |
1877673 | 1877673 | 2022-08-28 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-08-29 04:21:06 | Calhoun, Florida, US | |
1877375 | 1877375 | 2022-08-28 | US | Alabama | Macon | 1087 | 4609 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-29 04:21:06 | Macon, Alabama, US | |
2096800 | 2096800 | 2022-08-27 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-08-28 04:21:02 | Calhoun, Florida, US | |
2096502 | 2096502 | 2022-08-27 | US | Alabama | Macon | 1087 | 4609 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-28 04:21:02 | Macon, Alabama, US | |
1532615 | 1532615 | 2022-08-26 | US | Florida | Calhoun | 12013 | 4609 | 101 | 0 | 30.40666734 | -85.19394153 | 2022-08-27 04:20:57 | Calhoun, Florida, US | |
1532317 | 1532317 | 2022-08-26 | US | Alabama | Macon | 1087 | 4609 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-27 04:20:57 | Macon, Alabama, US | |
2832165 | 2832165 | 2022-08-25 | US | Virginia | Greene | 51079 | 4609 | 64 | 0 | 38.29545894 | -78.46525378 | 2022-08-26 04:21:02 | Greene, Virginia, US | |
2829204 | 2829204 | 2022-08-25 | US | Alabama | Macon | 1087 | 4609 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-26 04:21:02 | Macon, Alabama, US | |
3546643 | 3546643 | 2022-08-08 | US | Texas | Lamb | 48279 | 4609 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-08-09 04:20:34 | Lamb, Texas, US | |
1490323 | 1490323 | 2022-07-26 | US | Puerto Rico | Comerio | 72045 | 4609 | 0 | 0 | 18.224687 | -66.221622 | 2022-07-27 04:21:04 | Comerio, Puerto Rico, US | |
3158642 | 3158642 | 2022-06-09 | US | Illinois | Johnson | 17087 | 4609 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-06-10 04:20:55 | Johnson, Illinois, US | |
3186370 | 3186370 | 2022-05-30 | US | Alabama | Henry | 1067 | 4609 | 76 | 0 | 31.51148016 | -85.24267944 | 2022-05-31 04:20:51 | Henry, Alabama, US | |
3198519 | 3198519 | 2022-05-29 | US | Alabama | Henry | 1067 | 4609 | 76 | 0 | 31.51148016 | -85.24267944 | 2022-05-30 04:20:50 | Henry, Alabama, US | |
2725397 | 2725397 | 2022-05-28 | US | Alabama | Henry | 1067 | 4609 | 76 | 0 | 31.51148016 | -85.24267944 | 2022-05-29 04:20:53 | Henry, Alabama, US | |
1314578 | 1314578 | 2022-05-27 | US | Alabama | Henry | 1067 | 4609 | 76 | 0 | 31.51148016 | -85.24267944 | 2022-05-28 04:21:07 | Henry, Alabama, US | |
1852710 | 1852710 | 2022-05-26 | US | Puerto Rico | Aibonito | 72009 | 4609 | 0 | 0 | 18.131361 | -66.264131 | 2022-05-27 04:20:56 | Aibonito, Puerto Rico, US | |
661508 | 661508 | 2022-05-13 | US | Texas | Panola | 48365 | 4609 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-05-14 04:20:48 | Panola, Texas, US | |
3854955 | 3854955 | 2022-04-27 | US | Texas | Jones | 48253 | 4609 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-04-28 04:20:47 | Jones, Texas, US | |
746480 | 746480 | 2022-04-23 | New Zealand | Cook Islands | 4609 | 0 | 0 | -21.2367 | -159.7777 | 2022-04-24 04:20:56 | Cook Islands, New Zealand | |||
3436965 | 3436965 | 2022-04-22 | New Zealand | Cook Islands | 4609 | 0 | 0 | -21.2367 | -159.7777 | 2022-04-23 04:20:50 | Cook Islands, New Zealand | |||
1224506 | 1224506 | 2022-04-14 | US | Georgia | Worth | 13321 | 4609 | 116 | 0 | 31.55162306 | -83.85090513 | 2022-04-15 04:20:57 | Worth, Georgia, US | |
1948947 | 1948947 | 2022-04-12 | US | Alaska | Northwest Arctic | 2188 | 4609 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-04-13 04:21:03 | Northwest Arctic, Alaska, US | |
3206700 | 3206700 | 2022-04-11 | US | Alaska | Northwest Arctic | 2188 | 4609 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-04-12 04:20:49 | Northwest Arctic, Alaska, US | |
1577060 | 1577060 | 2022-04-10 | US | Georgia | Worth | 13321 | 4609 | 116 | 0 | 31.55162306 | -83.85090513 | 2022-04-11 04:21:02 | Worth, Georgia, US | |
1576586 | 1576586 | 2022-04-10 | US | Alaska | Northwest Arctic | 2188 | 4609 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-04-11 04:21:02 | Northwest Arctic, Alaska, US | |
1653302 | 1653302 | 2022-04-09 | US | Georgia | Worth | 13321 | 4609 | 116 | 0 | 31.55162306 | -83.85090513 | 2022-04-10 04:20:52 | Worth, Georgia, US | |
1652828 | 1652828 | 2022-04-09 | US | Alaska | Northwest Arctic | 2188 | 4609 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-04-10 04:20:52 | Northwest Arctic, Alaska, US | |
2116624 | 2116624 | 2022-04-08 | US | Georgia | Worth | 13321 | 4609 | 116 | 0 | 31.55162306 | -83.85090513 | 2022-04-09 04:20:42 | Worth, Georgia, US | |
2116150 | 2116150 | 2022-04-08 | US | Alaska | Northwest Arctic | 2188 | 4609 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-04-09 04:20:42 | Northwest Arctic, Alaska, US | |
3320674 | 3320674 | 2022-04-07 | US | Alaska | Northwest Arctic | 2188 | 4609 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-04-08 04:20:48 | Northwest Arctic, Alaska, US | |
2801210 | 2801210 | 2022-04-06 | US | Alaska | Northwest Arctic | 2188 | 4609 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-04-07 04:20:53 | Northwest Arctic, Alaska, US | |
2267418 | 2267418 | 2022-03-14 | US | Wisconsin | Adams | 55001 | 4609 | 55 | 0 | 43.96974651 | -89.76782777 | 2022-03-15 04:20:47 | Adams, Wisconsin, US | |
3631484 | 3631484 | 2022-03-13 | US | Wisconsin | Adams | 55001 | 4609 | 54 | 0 | 43.96974651 | -89.76782777 | 2022-03-14 04:20:46 | Adams, Wisconsin, US | |
954392 | 954392 | 2022-03-12 | US | Wisconsin | Adams | 55001 | 4609 | 54 | 0 | 43.96974651 | -89.76782777 | 2022-03-13 04:20:49 | Adams, Wisconsin, US | |
359853 | 359853 | 2022-03-11 | US | Wisconsin | Adams | 55001 | 4609 | 54 | 0 | 43.96974651 | -89.76782777 | 2022-03-12 04:20:50 | Adams, Wisconsin, US | |
1514588 | 1514588 | 2022-02-24 | US | Texas | Montague | 48337 | 4609 | 120 | 0 | 33.67521893 | -97.72500958 | 2022-02-25 04:21:11 | Montague, Texas, US | |
3912806 | 3912806 | 2022-02-20 | US | Georgia | Crisp | 13081 | 4609 | 130 | 0 | 31.92289565 | -83.76811843 | 2022-02-21 04:21:05 | Crisp, Georgia, US | |
3876364 | 3876364 | 2022-02-19 | US | Georgia | Crisp | 13081 | 4609 | 130 | 0 | 31.92289565 | -83.76811843 | 2022-02-20 04:21:00 | Crisp, Georgia, US | |
3856620 | 3856620 | 2022-02-18 | US | Georgia | Crisp | 13081 | 4609 | 130 | 0 | 31.92289565 | -83.76811843 | 2022-02-19 04:21:11 | Crisp, Georgia, US | |
1298839 | 1298839 | 2022-02-17 | US | Georgia | Crisp | 13081 | 4609 | 130 | 0 | 31.92289565 | -83.76811843 | 2022-02-18 04:21:04 | Crisp, Georgia, US | |
1364221 | 1364221 | 2022-02-08 | US | Missouri | Andrew | 29003 | 4609 | 47 | 0 | 39.98492163 | -94.80163024 | 2022-02-09 04:21:04 | Andrew, Missouri, US | |
3301087 | 3301087 | 2022-01-30 | US | Georgia | Tattnall | 13267 | 4609 | 121 | 0 | 32.04785085 | -82.05539188 | 2022-01-31 04:21:09 | Tattnall, Georgia, US | |
3062878 | 3062878 | 2022-01-29 | US | Georgia | Tattnall | 13267 | 4609 | 121 | 0 | 32.04785085 | -82.05539188 | 2022-01-30 04:21:26 | Tattnall, Georgia, US | |
3812200 | 3812200 | 2022-01-28 | US | New York | Schoharie | 36095 | 4609 | 33 | 0 | 42.58831742 | -74.44339029999998 | 2022-01-29 04:21:10 | Schoharie, New York, US | |
3810812 | 3810812 | 2022-01-28 | US | Georgia | Tattnall | 13267 | 4609 | 121 | 0 | 32.04785085 | -82.05539188 | 2022-01-29 04:21:10 | Tattnall, Georgia, US | |
1231022 | 1231022 | 2022-01-24 | US | Virginia | Scott | 51169 | 4609 | 93 | 0 | 36.71466456 | -82.60171704 | 2022-01-25 04:21:05 | Scott, Virginia, US | |
1141714 | 1141714 | 2022-01-23 | US | Georgia | Fannin | 13111 | 4609 | 124 | 0 | 34.86430205 | -84.316964 | 2022-01-24 04:21:12 | Fannin, Georgia, US | |
2833632 | 2833632 | 2022-01-22 | US | Georgia | Fannin | 13111 | 4609 | 124 | 0 | 34.86430205 | -84.316964 | 2022-01-23 04:21:13 | Fannin, Georgia, US | |
3425750 | 3425750 | 2022-01-21 | US | Georgia | Fannin | 13111 | 4609 | 124 | 0 | 34.86430205 | -84.316964 | 2022-01-22 04:21:13 | Fannin, Georgia, US | |
1669399 | 1669399 | 2021-12-29 | US | Idaho | Jefferson | 16051 | 4609 | 53 | 0 | 43.82078483 | -112.3131749 | 2021-12-30 04:21:25 | Jefferson, Idaho, US | |
3607860 | 3607860 | 2021-12-25 | US | Puerto Rico | Vega Baja | 72145 | 4609 | 0 | 0 | 18.428262 | -66.397924 | 2021-12-26 04:21:50 | Vega Baja, Puerto Rico, US | |
1662292 | 1662292 | 2021-12-12 | US | Mississippi | Yazoo | 28163 | 4609 | 93 | 0 | 32.77890365 | -90.39656148 | 2021-12-13 04:22:02 | Yazoo, Mississippi, US | |
1666308 | 1666308 | 2021-12-11 | US | Mississippi | Yazoo | 28163 | 4609 | 93 | 0 | 32.77890365 | -90.39656148 | 2021-12-12 04:22:12 | Yazoo, Mississippi, US | |
3657460 | 3657460 | 2021-12-10 | US | Mississippi | Yazoo | 28163 | 4609 | 93 | 0 | 32.77890365 | -90.39656148 | 2021-12-11 04:22:45 | Yazoo, Mississippi, US | |
162641 | 162641 | 2021-11-19 | US | Colorado | Delta | 8029 | 4609 | 110 | 0 | 38.86246243 | -107.86313419999999 | 2021-11-20 04:22:17 | Delta, Colorado, US | |
3291387 | 3291387 | 2021-11-18 | US | Ohio | Hardin | 39065 | 4609 | 101 | 0 | 40.66015414 | -83.65929931 | 2021-11-19 04:21:40 | Hardin, Ohio, US | |
3343394 | 3343394 | 2021-11-16 | US | Georgia | Chattooga | 13055 | 4609 | 105 | 0 | 34.47197698 | -85.34535662 | 2021-11-17 04:21:48 | Chattooga, Georgia, US | |
2848415 | 2848415 | 2021-11-10 | US | Wisconsin | Lincoln | 55069 | 4609 | 113 | 0 | 45.33737523 | -89.73411273 | 2021-11-11 04:21:45 | Lincoln, Wisconsin, US | |
2002047 | 2002047 | 2021-11-07 | US | Kentucky | Carter | 21043 | 4609 | 60 | 0 | 38.31690743 | -83.05092385 | 2021-11-08 04:21:43 | Carter, Kentucky, US | |
7844 | 7844 | 2021-10-28 | US | West Virginia | Mingo | 54059 | 4609 | 81 | 0 | 37.73048351 | -82.13338365 | 2021-10-29 04:22:03 | Mingo, West Virginia, US | |
1909748 | 1909748 | 2021-10-17 | US | Arkansas | Yell | 5149 | 4609 | 77 | 0 | 35.00292371 | -93.41171338 | 2021-10-18 04:21:10 | Yell, Arkansas, 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]);