daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
132 rows where active = 1749 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-07 | Canada | Ontario | 550337 | 9224 | 542903 | 1749 | 51.2538 | -85.3232 | 2021-07-08 04:21:26 | Ontario, Canada | ||
2021-07-04 | India | Uttarakhand | 340724 | 7333 | 331642 | 1749 | 30.156447 | 79.197608 | 2021-07-05 04:21:28 | Uttarakhand, India | ||
2021-06-21 | Japan | Kanagawa | 65597 | 937 | 62911 | 1749 | 35.415312 | 139.338983 | 2021-06-22 04:21:34 | Kanagawa, Japan | ||
2021-06-13 | Chile | Los Lagos | 81392 | 1113 | 78530 | 1749 | -41.9198 | -72.1416 | 2021-06-14 04:22:46 | Los Lagos, Chile | ||
2021-06-08 | Ukraine | Donetsk Oblast | 89824 | 2293 | 85782 | 1749 | 48.0159 | 37.8028 | 2021-06-09 04:23:31 | Donetsk Oblast, Ukraine | ||
2021-06-05 | Ukraine | Volyn Oblast | 61591 | 1164 | 58678 | 1749 | 50.7472 | 25.3254 | 2021-06-06 04:24:03 | Volyn Oblast, Ukraine | ||
2021-06-03 | Ukraine | Vinnytsia Oblast | 70616 | 1670 | 67197 | 1749 | 49.2331 | 28.4682 | 2021-06-04 04:23:37 | Vinnytsia Oblast, Ukraine | ||
2021-06-03 | Ukraine | Sumy Oblast | 77095 | 1294 | 74052 | 1749 | 50.9077 | 34.7981 | 2021-06-04 04:23:37 | Sumy Oblast, Ukraine | ||
2021-04-29 | Russia | Mordovia Republic | 20038 | 242 | 18047 | 1749 | 54.4419829 | 44.4661144 | 2021-04-30 04:21:03 | Mordovia Republic, Russia | ||
2021-04-14 | Russia | Vladimir Oblast | 30940 | 1045 | 28146 | 1749 | 56.0503336 | 40.6561633 | 2021-04-15 04:20:54 | Vladimir Oblast, Russia | ||
2021-03-22 | Kyrgyzstan | 87462 | 1490 | 84223 | 1749 | 41.20438 | 74.766098 | 2021-03-23 05:26:18 | Kyrgyzstan | |||
2021-03-06 | US | Iowa | Buchanan | 19019 | 1778 | 29 | 0 | 1749 | 42.4709188 | -91.83510825 | 2021-03-07 05:21:54 | Buchanan, Iowa, US |
2021-03-06 | US | Georgia | Jeff Davis | 13161 | 1794 | 45 | 0 | 1749 | 31.80405727 | -82.63724870000001 | 2021-03-07 05:21:54 | Jeff Davis, Georgia, US |
2021-03-06 | Russia | Tambov Oblast | 26953 | 357 | 24847 | 1749 | 52.9019574 | 41.3578918 | 2021-03-07 05:21:54 | Tambov Oblast, Russia | ||
2021-03-05 | US | Iowa | Buchanan | 19019 | 1778 | 29 | 0 | 1749 | 42.4709188 | -91.83510825 | 2021-03-06 04:23:41 | Buchanan, Iowa, US |
2021-02-28 | US | Indiana | Jay | 18075 | 1777 | 28 | 0 | 1749 | 40.43781032 | -85.00576229 | 2021-03-01 05:23:01 | Jay, Indiana, US |
2021-02-26 | US | Pennsylvania | Juniata | 42067 | 1829 | 80 | 0 | 1749 | 40.53358749 | -77.39975129999998 | 2021-02-27 05:22:28 | Juniata, Pennsylvania, US |
2021-02-22 | US | Virginia | Nottoway | 51135 | 1780 | 31 | 0 | 1749 | 37.1435975 | -78.05065922 | 2021-02-23 05:23:41 | Nottoway, Virginia, US |
2021-02-17 | US | Utah | San Juan | 49037 | 1785 | 36 | 0 | 1749 | 37.62762978 | -109.80337140000002 | 2021-02-18 05:22:58 | San Juan, Utah, US |
2021-02-15 | Thailand | 24714 | 82 | 22883 | 1749 | 15.870032 | 100.992541 | 2021-02-16 05:24:38 | Thailand | |||
2021-02-14 | US | Virginia | Southampton | 51175 | 1797 | 48 | 0 | 1749 | 36.72231125 | -77.10642712 | 2021-02-15 05:24:49 | Southampton, Virginia, US |
2021-02-11 | US | Florida | Gulf | 12045 | 1784 | 35 | 0 | 1749 | 29.93543004 | -85.24270990000002 | 2021-02-12 05:23:29 | Gulf, Florida, US |
2021-02-10 | US | Maryland | Talbot | 24041 | 1777 | 28 | 0 | 1749 | 38.76618159 | -76.10882561 | 2021-02-11 05:23:55 | Talbot, Maryland, US |
2021-02-09 | US | South Dakota | Clay | 46027 | 1764 | 15 | 0 | 1749 | 42.91296147 | -96.97656917 | 2021-02-10 05:22:41 | Clay, South Dakota, US |
2021-02-05 | US | Maryland | Garrett | 24023 | 1807 | 58 | 0 | 1749 | 39.52786077 | -79.27355126 | 2021-02-06 05:23:55 | Garrett, Maryland, US |
2021-02-04 | Chile | Antofagasta | 32471 | 668 | 30054 | 1749 | -23.6509 | -70.3975 | 2021-02-05 05:22:38 | Antofagasta, Chile | ||
2021-02-01 | US | North Carolina | Hertford | 37091 | 1804 | 55 | 0 | 1749 | 36.3607755 | -76.98104134 | 2021-02-02 05:22:49 | Hertford, North Carolina, US |
2021-01-31 | US | Oregon | Jefferson | 41031 | 1774 | 25 | 0 | 1749 | 44.62806839 | -121.17832 | 2021-02-01 05:22:53 | Jefferson, Oregon, US |
2021-01-30 | US | Oregon | Jefferson | 41031 | 1774 | 25 | 0 | 1749 | 44.62806839 | -121.17832 | 2021-01-31 05:22:42 | Jefferson, Oregon, US |
2021-01-30 | US | Georgia | Washington | 13303 | 1803 | 54 | 0 | 1749 | 32.96711864 | -82.79357039 | 2021-01-31 05:22:42 | Washington, Georgia, US |
2021-01-29 | Colombia | Cauca | 25382 | 633 | 23000 | 1749 | 2.705 | -76.82600000000002 | 2021-01-30 05:22:49 | Cauca, Colombia | ||
2021-01-28 | US | Wisconsin | Vernon | 55123 | 1786 | 37 | 0 | 1749 | 43.59422667 | -90.8324691 | 2021-01-29 05:22:23 | Vernon, Wisconsin, US |
2021-01-25 | US | Florida | Madison | 12079 | 1786 | 37 | 0 | 1749 | 30.44396917 | -83.47398594 | 2021-01-26 05:22:02 | Madison, Florida, US |
2021-01-23 | US | Alabama | Fayette | 1057 | 1778 | 29 | 0 | 1749 | 33.72076938 | -87.73886638 | 2021-01-24 05:22:35 | Fayette, Alabama, US |
2021-01-21 | US | Tennessee | Bledsoe | 47007 | 1813 | 11 | 0 | 1749 | 35.59942968 | -85.20611967 | 2021-01-22 05:22:10 | Bledsoe, Tennessee, US |
2021-01-20 | Congo (Brazzaville) | 7709 | 114 | 5846 | 1749 | -0.228 | 15.8277 | 2021-01-21 05:22:01 | Congo (Brazzaville) | |||
2021-01-19 | Congo (Brazzaville) | 7709 | 114 | 5846 | 1749 | -0.228 | 15.8277 | 2021-01-20 05:21:54 | Congo (Brazzaville) | |||
2021-01-18 | US | Montana | Hill | 30041 | 1786 | 37 | 0 | 1749 | 48.62879827 | -110.1129252 | 2021-01-19 05:22:15 | Hill, Montana, US |
2021-01-18 | Congo (Brazzaville) | 7709 | 114 | 5846 | 1749 | -0.228 | 15.8277 | 2021-01-19 05:22:15 | Congo (Brazzaville) | |||
2021-01-17 | Congo (Brazzaville) | 7709 | 114 | 5846 | 1749 | -0.228 | 15.8277 | 2021-01-18 05:22:34 | Congo (Brazzaville) | |||
2021-01-16 | Congo (Brazzaville) | 7709 | 114 | 5846 | 1749 | -0.228 | 15.8277 | 2021-01-17 05:22:17 | Congo (Brazzaville) | |||
2021-01-15 | Congo (Brazzaville) | 7709 | 114 | 5846 | 1749 | -0.228 | 15.8277 | 2021-01-16 05:22:40 | Congo (Brazzaville) | |||
2021-01-11 | US | Georgia | Burke | 13033 | 1772 | 23 | 0 | 1749 | 33.05917989 | -81.99928721 | 2021-01-12 05:22:15 | Burke, Georgia, US |
2021-01-08 | US | Ohio | Wyandot | 39175 | 1793 | 44 | 0 | 1749 | 40.84339621 | -83.30734173 | 2021-01-09 05:22:18 | Wyandot, Ohio, US |
2021-01-08 | US | Arizona | La Paz | 4012 | 1788 | 39 | 0 | 1749 | 33.72854224 | -113.9810029 | 2021-01-09 05:22:18 | La Paz, Arizona, US |
2021-01-06 | Colombia | Cesar | 34088 | 1004 | 31335 | 1749 | 9.3373 | -73.6536 | 2021-01-07 05:22:03 | Cesar, Colombia | ||
2021-01-05 | US | Ohio | Coshocton | 39031 | 1787 | 38 | 0 | 1749 | 40.30096166 | -81.91729018 | 2021-01-06 05:22:16 | Coshocton, Ohio, US |
2021-01-03 | US | Nebraska | Saline | 31151 | 1752 | 3 | 0 | 1749 | 40.52418865 | -97.14085859 | 2021-01-04 05:22:02 | Saline, Nebraska, US |
2021-01-01 | US | Nebraska | Cass | 31025 | 1762 | 13 | 0 | 1749 | 40.90899107 | -96.13971217 | 2021-01-02 05:22:33 | Cass, Nebraska, US |
2021-01-01 | US | Mississippi | Adams | 28001 | 1807 | 58 | 0 | 1749 | 31.47669768 | -91.35326037 | 2021-01-02 05:22:33 | Adams, Mississippi, US |
2020-12-31 | Rwanda | 8383 | 92 | 6542 | 1749 | -1.9403 | 29.8739 | 2021-01-01 05:23:07 | Rwanda | |||
2020-12-23 | US | Washington | Grays Harbor | 53027 | 1769 | 20 | 0 | 1749 | 47.14003705 | -123.7820567 | 2020-12-24 05:23:04 | Grays Harbor, Washington, US |
2020-12-23 | US | Nebraska | Gage | 31067 | 1759 | 10 | 0 | 1749 | 40.26186809 | -96.68946704 | 2020-12-24 05:23:04 | Gage, Nebraska, US |
2020-12-22 | US | Iowa | Boone | 19015 | 1764 | 15 | 0 | 1749 | 42.03657094 | -93.9313999 | 2020-12-23 05:22:03 | Boone, Iowa, US |
2020-12-17 | US | Minnesota | Meeker | 27093 | 1774 | 25 | 0 | 1749 | 45.12328869 | -94.52839455 | 2020-12-18 05:28:18 | Meeker, Minnesota, US |
2020-12-15 | Colombia | Caldas | 28406 | 544 | 26113 | 1749 | 5.2983 | -75.2479 | 2020-12-16 05:28:04 | Caldas, Colombia | ||
2020-12-10 | US | Oklahoma | Garvin | 40049 | 1767 | 18 | 0 | 1749 | 34.70418038 | -97.30811132 | 2020-12-11 05:26:59 | Garvin, Oklahoma, US |
2020-12-08 | US | Utah | TriCounty | 1757 | 8 | 0 | 1749 | 40.12491499 | -109.5174415 | 2020-12-09 05:28:01 | TriCounty, Utah, US | |
2020-11-30 | US | Arkansas | Boone | 5009 | 1793 | 44 | 0 | 1749 | 36.3084504 | -93.09374925 | 2020-12-01 05:26:18 | Boone, Arkansas, US |
2020-11-29 | US | Tennessee | White | 47185 | 1784 | 18 | 0 | 1749 | 35.92929884 | -85.45591799 | 2020-11-30 05:26:13 | White, Tennessee, US |
2020-11-27 | Colombia | Cesar | 29261 | 894 | 26618 | 1749 | 9.3373 | -73.6536 | 2020-11-28 05:25:50 | Cesar, Colombia | ||
2020-11-25 | US | Texas | Rusk | 48401 | 1637 | 30 | 0 | 1749 | 32.10773545 | -94.76176432 | 2020-11-26 05:27:44 | Rusk, Texas, US |
2020-11-25 | US | Tennessee | Macon | 47111 | 1781 | 28 | 0 | 1749 | 36.53157855 | -86.00778595 | 2020-11-26 05:27:44 | Macon, Tennessee, US |
2020-11-25 | US | Pennsylvania | Bradford | 42015 | 1780 | 31 | 0 | 1749 | 41.78869215 | -76.51570822 | 2020-11-26 05:27:44 | Bradford, Pennsylvania, US |
2020-11-23 | US | Texas | Medina | 48325 | 1712 | 48 | 0 | 1749 | 29.3557301 | -99.11030298 | 2020-11-24 05:27:31 | Medina, Texas, US |
2020-11-19 | US | Utah | Wasatch | 49051 | 1760 | 11 | 0 | 1749 | 40.33110236 | -111.1691419 | 2020-11-20 05:26:28 | Wasatch, Utah, US |
2020-11-18 | US | Kentucky | Henderson | 21101 | 1782 | 33 | 0 | 1749 | 37.79344553 | -87.57392021 | 2020-11-19 05:25:23 | Henderson, Kentucky, US |
2020-11-15 | US | Tennessee | Monroe | 47123 | 1813 | 40 | 0 | 1749 | 35.44550387 | -84.24902965 | 2020-11-16 05:25:57 | Monroe, Tennessee, US |
2020-11-15 | US | South Carolina | Cherokee | 45021 | 1806 | 57 | 0 | 1749 | 35.05122251 | -81.61828622 | 2020-11-16 05:25:57 | Cherokee, South Carolina, US |
2020-11-15 | US | Nebraska | Lincoln | 31111 | 1757 | 8 | 0 | 1749 | 41.04658298 | -100.7475374 | 2020-11-16 05:25:57 | Lincoln, Nebraska, US |
2020-11-14 | US | Georgia | Thomas | 13275 | 1826 | 77 | 0 | 1749 | 30.86392347 | -83.91847289 | 2020-11-15 05:26:53 | Thomas, Georgia, US |
2020-11-10 | US | Michigan | St. Joseph | 26149 | 1774 | 25 | 0 | 1749 | 41.91441767 | -85.52797979 | 2020-11-11 05:25:30 | St. Joseph, Michigan, US |
2020-11-09 | US | Mississippi | Leflore | 28083 | 1837 | 88 | 0 | 1749 | 33.55545125 | -90.29900733 | 2020-11-10 05:40:07 | Leflore, Mississippi, US |
2020-10-31 | US | Minnesota | Rice | 27131 | 1761 | 12 | 0 | 1749 | 44.3543376 | -93.29658715 | 2020-11-01 04:36:19 | Rice, Minnesota, US |
2020-10-28 | US | New York | Putnam | 36079 | 1812 | 63 | 0 | 1749 | 41.42630093 | -73.74965532 | 2020-10-29 04:24:49 | Putnam, New York, US |
2020-10-26 | Russia | Vologda Oblast | 6533 | 61 | 4723 | 1749 | 60.0391461 | 43.1215213 | 2020-10-27 04:24:45 | Vologda Oblast, Russia | ||
2020-10-25 | US | North Dakota | Williams | 38105 | 1828 | 14 | 0 | 1749 | 48.34522353 | -103.4793387 | 2020-10-26 04:25:02 | Williams, North Dakota, US |
2020-10-25 | US | Georgia | Effingham | 13103 | 1777 | 28 | 0 | 1749 | 32.36616021 | -81.34280942 | 2020-10-26 04:25:02 | Effingham, Georgia, US |
2020-10-24 | US | Nebraska | Buffalo | 31019 | 1763 | 14 | 0 | 1749 | 40.85486962 | -99.07500296 | 2020-10-25 04:24:36 | Buffalo, Nebraska, US |
2020-10-22 | US | Illinois | Boone | 17007 | 1774 | 25 | 0 | 1749 | 42.32359279 | -88.82345779 | 2020-10-23 04:24:46 | Boone, Illinois, US |
2020-10-20 | Spain | Melilla | 1885 | 11 | 125 | 1749 | 35.2923 | -2.9381 | 2020-10-21 04:24:14 | Melilla, Spain | ||
2020-10-19 | US | New Mexico | Chaves | 35005 | 1766 | 17 | 0 | 1749 | 33.36406072 | -104.4665365 | 2020-10-20 04:24:22 | Chaves, New Mexico, US |
2020-10-13 | US | Alabama | Blount | 1009 | 1765 | 16 | 0 | 1749 | 33.98210918 | -86.56790593 | 2020-10-14 04:24:05 | Blount, Alabama, US |
2020-10-08 | Russia | Kaluga Oblast | 9752 | 74 | 7929 | 1749 | 54.4382773 | 35.5272854 | 2020-10-09 04:23:59 | Kaluga Oblast, Russia | ||
2020-10-06 | US | North Carolina | Lee | 37105 | 1764 | 15 | 0 | 1749 | 35.47623147 | -79.17569362 | 2020-10-07 04:23:40 | Lee, North Carolina, US |
2020-10-01 | US | Tennessee | Gibson | 47053 | 1772 | 24 | 0 | 1749 | 35.99438059 | -88.93358327 | 2020-10-02 04:23:51 | Gibson, Tennessee, US |
2020-10-01 | US | Ohio | Clermont | 39025 | 1779 | 30 | 0 | 1749 | 39.04847534 | -84.15375786 | 2020-10-02 04:23:51 | Clermont, Ohio, US |
2020-10-01 | US | Connecticut | Litchfield | 9005 | 1890 | 141 | 0 | 1749 | 41.7937534 | -73.2451475 | 2020-10-02 04:23:51 | Litchfield, Connecticut, US |
2020-09-27 | US | Mississippi | Oktibbeha | 28105 | 1801 | 52 | 0 | 1749 | 33.42491685 | -88.87905132 | 2020-09-28 04:23:00 | Oktibbeha, Mississippi, US |
2020-09-27 | US | Illinois | Tazewell | 17179 | 1774 | 25 | 0 | 1749 | 40.50716185 | -89.51404662 | 2020-09-28 04:23:00 | Tazewell, Illinois, US |
2020-09-26 | US | Georgia | Walton | 13297 | 1802 | 53 | 0 | 1749 | 33.78017694 | -83.73552314 | 2020-09-27 04:23:00 | Walton, Georgia, US |
2020-09-25 | US | Alabama | Dallas | 1047 | 1775 | 26 | 0 | 1749 | 32.32688101 | -87.1086671 | 2020-09-26 04:23:00 | Dallas, Alabama, US |
2020-09-23 | US | Tennessee | Tipton | 47167 | 1765 | 17 | 0 | 1749 | 35.501942 | -89.73694895 | 2020-09-24 04:23:00 | Tipton, Tennessee, US |
2020-09-23 | US | Arkansas | Garland | 5051 | 1798 | 49 | 0 | 1749 | 34.57692074 | -93.14921604 | 2020-09-24 04:23:00 | Garland, Arkansas, US |
2020-09-22 | US | Indiana | Vigo | 18167 | 1781 | 32 | 0 | 1749 | 39.42944561 | -87.39169027 | 2020-09-23 04:23:00 | Vigo, Indiana, US |
2020-09-16 | US | Ohio | Licking | 39089 | 1809 | 60 | 0 | 1749 | 40.09136236 | -82.48185785 | 2020-09-17 04:22:00 | Licking, Ohio, US |
2020-09-14 | US | Tennessee | Hamblen | 47063 | 1776 | 22 | 0 | 1749 | 36.21990035 | -83.26586179 | 2020-09-15 03:22:50 | Hamblen, Tennessee, US |
2020-09-11 | US | South Carolina | Darlington | 45031 | 1796 | 47 | 0 | 1749 | 34.33358335 | -79.96027485 | 2020-09-12 04:25:05 | Darlington, South Carolina, US |
2020-09-11 | US | Arkansas | Hot Spring | 5059 | 1772 | 23 | 0 | 1749 | 34.31709259 | -92.95396325 | 2020-09-12 04:25:05 | Hot Spring, Arkansas, US |
2020-09-11 | US | Arkansas | Crittenden | 5035 | 1785 | 36 | 0 | 1749 | 35.21247318 | -90.30839406 | 2020-09-12 04:25:05 | Crittenden, Arkansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;