daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
52 rows where active = 3277 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-06-18 | Rwanda | 30048 | 378 | 26393 | 3277 | -1.9403 | 29.8739 | 2021-06-19 04:22:33 | Rwanda | |||
2021-05-16 | Gabon | 23799 | 143 | 20379 | 3277 | -0.8037 | 11.6094 | 2021-05-17 04:20:34 | Gabon | |||
2021-05-15 | Gabon | 23799 | 143 | 20379 | 3277 | -0.8037 | 11.6094 | 2021-05-16 04:20:49 | Gabon | |||
2021-05-14 | Gabon | 23799 | 143 | 20379 | 3277 | -0.8037 | 11.6094 | 2021-05-15 04:20:58 | Gabon | |||
2021-05-08 | Chile | Maule | 74678 | 1249 | 70152 | 3277 | -35.5183 | -71.6885 | 2021-05-09 04:20:35 | Maule, Chile | ||
2021-03-03 | US | Alabama | Dallas | 1047 | 3419 | 142 | 0 | 3277 | 32.32688101 | -87.10866709999998 | 2021-03-04 05:24:24 | Dallas, Alabama, US |
2021-02-24 | US | Tennessee | Macon | 47111 | 3356 | 73 | 0 | 3277 | 36.53157855 | -86.00778595 | 2021-02-25 05:24:57 | Macon, Tennessee, US |
2021-02-21 | Ukraine | Zaporizhia Oblast | 68721 | 1050 | 64394 | 3277 | 47.8388 | 35.1396 | 2021-02-22 05:24:21 | Zaporizhia Oblast, Ukraine | ||
2021-02-16 | US | Idaho | Nez Perce | 16069 | 3327 | 50 | 0 | 3277 | 46.32638236 | -116.7500975 | 2021-02-17 05:23:10 | Nez Perce, Idaho, US |
2021-02-07 | Colombia | Santander | 85939 | 3053 | 79609 | 3277 | 6.6437 | -73.6536 | 2021-02-08 05:22:39 | Santander, Colombia | ||
2021-02-06 | US | Oklahoma | Garvin | 40049 | 3315 | 38 | 0 | 3277 | 34.70418038 | -97.30811132 | 2021-02-07 05:23:00 | Garvin, Oklahoma, US |
2021-02-06 | Italy | Basilicata | 13609 | 337 | 9995 | 3277 | 40.63947052 | 15.80514834 | 2021-02-07 05:23:00 | Basilicata, Italy | ||
2021-02-05 | US | Alabama | Clarke | 1025 | 3317 | 40 | 0 | 3277 | 31.68099859 | -87.83548597 | 2021-02-06 05:23:55 | Clarke, Alabama, US |
2021-01-31 | US | Texas | Rusk | 48401 | 3645 | 79 | 0 | 3277 | 32.10773545 | -94.76176432 | 2021-02-01 05:22:53 | Rusk, Texas, US |
2021-01-31 | US | North Carolina | Haywood | 37087 | 3353 | 76 | 0 | 3277 | 35.55269063 | -82.98196486 | 2021-02-01 05:22:53 | Haywood, North Carolina, US |
2021-01-27 | US | Oklahoma | Texas | 40139 | 3298 | 21 | 0 | 3277 | 36.74777635 | -101.4889765 | 2021-01-28 05:22:24 | Texas, Oklahoma, US |
2021-01-27 | US | Arkansas | Miller | 5091 | 3305 | 28 | 0 | 3277 | 33.31403423 | -93.89285258 | 2021-01-28 05:22:24 | Miller, Arkansas, US |
2021-01-26 | US | New York | Madison | 36053 | 3354 | 77 | 0 | 3277 | 42.91653905 | -75.67266639 | 2021-01-27 05:23:41 | Madison, New York, US |
2021-01-22 | US | Georgia | Effingham | 13103 | 3321 | 44 | 0 | 3277 | 32.36616021 | -81.34280942 | 2021-01-23 05:22:03 | Effingham, Georgia, US |
2021-01-19 | US | South Dakota | Brookings | 46011 | 3309 | 32 | 0 | 3277 | 44.36974375 | -96.79079945 | 2021-01-20 05:21:54 | Brookings, South Dakota, US |
2021-01-18 | US | Oklahoma | Caddo | 40015 | 3319 | 42 | 0 | 3277 | 35.17364557 | -98.37534464 | 2021-01-19 05:22:15 | Caddo, Oklahoma, US |
2021-01-18 | US | North Carolina | Chatham | 37037 | 3345 | 68 | 0 | 3277 | 35.70394416 | -79.25541492 | 2021-01-19 05:22:15 | Chatham, North Carolina, US |
2021-01-17 | US | North Carolina | Chatham | 37037 | 3345 | 68 | 0 | 3277 | 35.70394416 | -79.25541492 | 2021-01-18 05:22:34 | Chatham, North Carolina, US |
2021-01-15 | US | Tennessee | Cheatham | 47021 | 3375 | 28 | 0 | 3277 | 36.26136216 | -87.08903581 | 2021-01-16 05:22:40 | Cheatham, Tennessee, US |
2021-01-11 | US | Louisiana | St. Mary | 22101 | 3381 | 104 | 0 | 3277 | 29.69262097 | -91.44702164 | 2021-01-12 05:22:15 | St. Mary, Louisiana, US |
2021-01-06 | Russia | Udmurt Republic | 20940 | 407 | 17256 | 3277 | 57.1961165 | 52.69598320000001 | 2021-01-07 05:22:03 | Udmurt Republic, Russia | ||
2021-01-05 | US | Virginia | Bedford | 51019 | 3308 | 31 | 0 | 3277 | 37.3080028 | -79.5281964 | 2021-01-06 05:22:16 | Bedford, Virginia, US |
2020-12-25 | US | South Dakota | Codington | 46029 | 3345 | 68 | 0 | 3277 | 44.97788119 | -97.18827677 | 2020-12-26 05:22:28 | Codington, South Dakota, US |
2020-12-24 | US | South Dakota | Codington | 46029 | 3345 | 68 | 0 | 3277 | 44.97788119 | -97.18827677 | 2020-12-25 05:22:48 | Codington, South Dakota, US |
2020-12-20 | US | Tennessee | Monroe | 47123 | 3426 | 51 | 0 | 3277 | 35.44550387 | -84.24902965 | 2020-12-21 05:27:58 | Monroe, Tennessee, US |
2020-12-16 | US | Iowa | Des Moines | 19057 | 3303 | 26 | 0 | 3277 | 40.92012606 | -91.18326592 | 2020-12-17 05:28:12 | Des Moines, Iowa, US |
2020-12-14 | US | Michigan | Marquette | 26103 | 3322 | 45 | 0 | 3277 | 46.4338914 | -87.64043701 | 2020-12-15 05:26:38 | Marquette, Michigan, US |
2020-12-13 | US | Indiana | Morgan | 18109 | 3339 | 62 | 0 | 3277 | 39.47899078 | -86.44573375 | 2020-12-14 05:26:27 | Morgan, Indiana, US |
2020-12-08 | US | Texas | Bowie | 48037 | 3406 | 108 | 0 | 3277 | 33.44626922 | -94.41834132 | 2020-12-09 05:28:01 | Bowie, Texas, US |
2020-12-06 | US | Kentucky | Campbell | 21037 | 3298 | 21 | 0 | 3277 | 38.94384345 | -84.37875208 | 2020-12-07 05:26:14 | Campbell, Kentucky, US |
2020-12-02 | US | Maryland | Carroll | 24013 | 3415 | 138 | 0 | 3277 | 39.56453592 | -77.02373735 | 2020-12-03 05:28:22 | Carroll, Maryland, US |
2020-12-01 | US | Florida | Gadsden | 12039 | 3334 | 57 | 0 | 3277 | 30.57796289 | -84.61915825 | 2020-12-02 05:27:41 | Gadsden, Florida, US |
2020-11-28 | US | West Virginia | Monongalia | 54061 | 3284 | 7 | 0 | 3277 | 39.63218457 | -80.04766838 | 2020-11-29 05:25:55 | Monongalia, West Virginia, US |
2020-11-27 | US | Indiana | Bartholomew | 18005 | 3353 | 76 | 0 | 3277 | 39.20744865 | -85.89558181 | 2020-11-28 05:25:50 | Bartholomew, Indiana, US |
2020-11-25 | India | Assam | 212021 | 978 | 207766 | 3277 | 26.357149 | 92.830441 | 2020-11-26 05:27:44 | Assam, India | ||
2020-10-23 | US | Tennessee | Washington | 47179 | 3309 | 49 | 0 | 3277 | 36.29472368 | -82.49454720000001 | 2020-10-24 04:24:46 | Washington, Tennessee, US |
2020-10-03 | Italy | Piemonte | 36010 | 4166 | 28567 | 3277 | 45.0732745 | 7.680687483 | 2020-10-04 04:23:44 | Piemonte, Italy | ||
2020-10-01 | US | Texas | Starr | 48427 | 3474 | 169 | 0 | 3277 | 26.56150059 | -98.73892358 | 2020-10-02 04:23:51 | Starr, Texas, US |
2020-09-27 | US | Washington | Clark | 53011 | 3351 | 74 | 0 | 3277 | 45.77568046 | -122.4829204 | 2020-09-28 04:23:00 | Clark, Washington, US |
2020-09-19 | US | Tennessee | Wilson | 47189 | 3346 | 41 | 0 | 3277 | 36.15496772 | -86.29775884 | 2020-09-20 04:22:00 | Wilson, Tennessee, US |
2020-08-31 | Colombia | Atlantico | 64128 | 2900 | 57951 | 3277 | 10.6966 | -74.8741 | 2020-09-01 04:28:31 | Atlantico, Colombia | ||
2020-08-25 | US | Virginia | Arlington | 51013 | 3415 | 138 | 0 | 3277 | 38.8767675 | -77.10139853 | 2020-08-26 04:28:11 | Arlington, Virginia, US |
2020-08-21 | US | Arizona | Mohave | 4015 | 3468 | 191 | 0 | 3277 | 35.70471703 | -113.7577902 | 2020-08-22 04:27:49 | Mohave, Arizona, US |
2020-08-15 | Ukraine | Zakarpattia Oblast | 6170 | 234 | 2659 | 3277 | 48.6208 | 22.2879 | 2020-08-16 04:27:42 | Zakarpattia Oblast, Ukraine | ||
2020-08-12 | Spain | Navarra | 7713 | 531 | 3905 | 3277 | 42.6954 | -1.6761 | 2020-08-13 04:29:15 | Navarra, Spain | ||
2020-08-04 | US | New Jersey | Atlantic | 34001 | 3529 | 252 | 0 | 3277 | 39.47538693 | -74.65848483 | 2020-08-05 04:34:43 | Atlantic, New Jersey, US |
2020-07-28 | US | Florida | Alachua | 12001 | 3297 | 20 | 0 | 3277 | 29.67866525 | -82.35928158 | 2020-07-29 04:35:11 | Alachua, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;