daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
104 rows where active = 1827 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-20 | Russia | Kaluga Oblast | 39649 | 434 | 37388 | 1827 | 54.4382773 | 35.5272854 | 2021-07-21 04:21:40 | Kaluga Oblast, Russia | ||
2021-06-10 | Colombia | Huila | 62285 | 2133 | 58325 | 1827 | 2.5359 | -75.5277 | 2021-06-11 04:23:20 | Huila, Colombia | ||
2021-06-07 | Germany | Berlin | 179121 | 3506 | 173900 | 1827 | 52.52 | 13.405 | 2021-06-08 04:22:35 | Berlin, Germany | ||
2021-05-13 | Colombia | Magdalena | 63967 | 2442 | 59698 | 1827 | 10.4113 | -74.4057 | 2021-05-14 04:20:41 | Magdalena, Colombia | ||
2021-05-08 | Ukraine | Crimea Republic* | 41273 | 1252 | 38194 | 1827 | 45.2835 | 34.2008 | 2021-05-09 04:20:35 | Crimea Republic*, Ukraine | ||
2021-04-28 | Togo | 12898 | 122 | 10949 | 1827 | 8.6195 | 0.8248 | 2021-04-29 04:20:55 | Togo | |||
2021-04-23 | Russia | Kursk Oblast | 35934 | 674 | 33433 | 1827 | 51.6568453 | 36.4852695 | 2021-04-24 04:20:38 | Kursk Oblast, Russia | ||
2021-03-26 | Kyrgyzstan | 87858 | 1494 | 84537 | 1827 | 41.20438 | 74.766098 | 2021-03-27 05:25:04 | Kyrgyzstan | |||
2021-03-02 | US | Florida | Gulf | 12045 | 1868 | 41 | 0 | 1827 | 29.93543004 | -85.24270990000002 | 2021-03-03 05:23:28 | Gulf, Florida, US |
2021-02-28 | US | Florida | Gulf | 12045 | 1868 | 41 | 0 | 1827 | 29.93543004 | -85.24270990000002 | 2021-03-01 05:23:01 | Gulf, Florida, US |
2021-02-28 | US | Arkansas | Polk | 5113 | 1892 | 65 | 0 | 1827 | 34.48254879 | -94.22728802 | 2021-03-01 05:23:01 | Polk, Arkansas, US |
2021-02-27 | US | Georgia | Lamar | 13171 | 1876 | 49 | 0 | 1827 | 33.07841647 | -84.14263877 | 2021-02-28 05:22:20 | Lamar, Georgia, US |
2021-02-27 | Russia | Tambov Oblast | 26154 | 341 | 23986 | 1827 | 52.9019574 | 41.3578918 | 2021-02-28 05:22:20 | Tambov Oblast, Russia | ||
2021-02-22 | US | Texas | Madison | 48313 | 2109 | 24 | 0 | 1827 | 30.96694679 | -95.93003775 | 2021-02-23 05:23:41 | Madison, Texas, US |
2021-02-21 | US | North Carolina | Dare | 37055 | 1835 | 8 | 0 | 1827 | 35.66520691 | -75.71767334 | 2021-02-22 05:24:21 | Dare, North Carolina, US |
2021-02-20 | US | North Carolina | Dare | 37055 | 1835 | 8 | 0 | 1827 | 35.66520691 | -75.71767334 | 2021-02-21 05:24:33 | Dare, North Carolina, US |
2021-02-20 | US | Minnesota | Martin | 27091 | 1855 | 28 | 0 | 1827 | 43.67429718 | -94.55099908 | 2021-02-21 05:24:33 | Martin, Minnesota, US |
2021-02-18 | US | Wisconsin | Vernon | 55123 | 1866 | 39 | 0 | 1827 | 43.59422667 | -90.8324691 | 2021-02-19 05:24:16 | Vernon, Wisconsin, US |
2021-02-17 | US | Nevada | Churchill | 32001 | 1876 | 49 | 0 | 1827 | 39.58105744 | -118.3394607 | 2021-02-18 05:22:58 | Churchill, Nevada, US |
2021-02-17 | US | Georgia | Crisp | 13081 | 1884 | 57 | 0 | 1827 | 31.92289565 | -83.76811843 | 2021-02-18 05:22:58 | Crisp, Georgia, US |
2021-02-16 | US | New York | Franklin | 36033 | 1838 | 11 | 0 | 1827 | 44.59040891 | -74.29926032 | 2021-02-17 05:23:10 | Franklin, New York, US |
2021-02-13 | US | Arkansas | Cross | 5037 | 1874 | 47 | 0 | 1827 | 35.29631396 | -90.77185818 | 2021-02-14 05:23:43 | Cross, Arkansas, US |
2021-02-05 | US | Florida | Madison | 12079 | 1864 | 37 | 0 | 1827 | 30.44396917 | -83.47398594 | 2021-02-06 05:23:55 | Madison, Florida, US |
2021-02-04 | US | Kentucky | Wayne | 21231 | 1858 | 31 | 0 | 1827 | 36.80310688 | -84.8251971 | 2021-02-05 05:22:38 | Wayne, Kentucky, US |
2021-01-31 | US | Colorado | Pitkin | 8097 | 1881 | 4 | 0 | 1827 | 39.21720112 | -106.9310027 | 2021-02-01 05:22:53 | Pitkin, Colorado, US |
2021-01-30 | US | Arkansas | Drew | 5043 | 1858 | 31 | 0 | 1827 | 33.59035001 | -91.71777921 | 2021-01-31 05:22:42 | Drew, Arkansas, US |
2021-01-26 | US | Kentucky | Marion | 21155 | 1847 | 20 | 0 | 1827 | 37.55218078 | -85.26898542 | 2021-01-27 05:23:41 | Marion, Kentucky, US |
2021-01-23 | US | West Virginia | Mingo | 54059 | 1847 | 20 | 0 | 1827 | 37.73048351 | -82.13338365 | 2021-01-24 05:22:35 | Mingo, West Virginia, US |
2021-01-21 | US | Arkansas | Conway | 5029 | 1849 | 22 | 0 | 1827 | 35.26205537 | -92.70506566 | 2021-01-22 05:22:10 | Conway, Arkansas, US |
2021-01-19 | US | South Carolina | Union | 45087 | 1880 | 53 | 0 | 1827 | 34.68835752 | -81.61730349 | 2021-01-20 05:21:54 | Union, South Carolina, US |
2021-01-17 | US | Virginia | Isle of Wight | 51093 | 1860 | 33 | 0 | 1827 | 36.90579348 | -76.70842863 | 2021-01-18 05:22:34 | Isle of Wight, Virginia, US |
2021-01-04 | US | Texas | Hockley | 48219 | 2858 | 79 | 0 | 1827 | 33.60771256 | -102.3431676 | 2021-01-05 05:21:49 | Hockley, Texas, US |
2021-01-03 | US | Texas | Hockley | 48219 | 2858 | 79 | 0 | 1827 | 33.60771256 | -102.3431676 | 2021-01-04 05:22:02 | Hockley, Texas, US |
2021-01-03 | US | Indiana | Randolph | 18135 | 1879 | 52 | 0 | 1827 | 40.15734772 | -85.01139319 | 2021-01-04 05:22:02 | Randolph, Indiana, US |
2021-01-02 | US | Texas | Hockley | 48219 | 2858 | 79 | 0 | 1827 | 33.60771256 | -102.3431676 | 2021-01-03 05:22:52 | Hockley, Texas, US |
2021-01-01 | US | Texas | Hockley | 48219 | 2858 | 79 | 0 | 1827 | 33.60771256 | -102.3431676 | 2021-01-02 05:22:33 | Hockley, Texas, US |
2021-01-01 | US | Georgia | Emanuel | 13107 | 1880 | 53 | 0 | 1827 | 32.59221302 | -82.30239915 | 2021-01-02 05:22:33 | Emanuel, Georgia, US |
2020-12-26 | US | North Dakota | Rolette | 38079 | 1821 | 20 | 0 | 1827 | 48.77245354 | -99.84097493 | 2020-12-27 05:22:55 | Rolette, North Dakota, US |
2020-12-23 | US | Illinois | Jersey | 17083 | 1853 | 26 | 0 | 1827 | 39.08869046 | -90.35393073 | 2020-12-24 05:23:04 | Jersey, Illinois, US |
2020-12-20 | US | Ohio | Highland | 39071 | 1863 | 36 | 0 | 1827 | 39.1839264 | -83.60331456 | 2020-12-21 05:27:58 | Highland, Ohio, US |
2020-12-18 | Mozambique | 17338 | 146 | 15365 | 1827 | -18.665695 | 35.529562 | 2020-12-19 05:27:52 | Mozambique | |||
2020-12-15 | Russia | Zabaykalsky Krai | 23204 | 341 | 21036 | 1827 | 52.248521 | 115.956325 | 2020-12-16 05:28:04 | Zabaykalsky Krai, Russia | ||
2020-12-11 | US | Arkansas | Sevier | 5133 | 1847 | 20 | 0 | 1827 | 33.99780401 | -94.2424869 | 2020-12-12 05:26:19 | Sevier, Arkansas, US |
2020-12-10 | US | Utah | TriCounty | 1836 | 9 | 0 | 1827 | 40.12491499 | -109.5174415 | 2020-12-11 05:26:59 | TriCounty, Utah, US | |
2020-12-09 | US | Indiana | Whitley | 18183 | 1851 | 24 | 0 | 1827 | 41.13863784 | -85.50791236 | 2020-12-10 05:26:19 | Whitley, Indiana, US |
2020-12-05 | US | Ohio | Preble | 39135 | 1876 | 49 | 0 | 1827 | 39.7420247 | -84.64787018 | 2020-12-06 05:26:18 | Preble, Ohio, US |
2020-12-04 | US | Iowa | Crawford | 19047 | 1843 | 16 | 0 | 1827 | 42.03718237 | -95.3819718 | 2020-12-05 05:27:36 | Crawford, Iowa, US |
2020-12-02 | US | Wisconsin | Waushara | 55137 | 1837 | 10 | 0 | 1827 | 44.11324419 | -89.24317107 | 2020-12-03 05:28:22 | Waushara, Wisconsin, US |
2020-12-02 | US | Illinois | Fayette | 17051 | 1860 | 33 | 0 | 1827 | 39.00072038 | -89.02452658 | 2020-12-03 05:28:22 | Fayette, Illinois, US |
2020-12-01 | US | Missouri | Webster | 29225 | 1851 | 24 | 0 | 1827 | 37.2813734 | -92.876329 | 2020-12-02 05:27:41 | Webster, Missouri, US |
2020-11-30 | US | New Hampshire | Merrimack | 33013 | 1862 | 35 | 0 | 1827 | 43.29662971 | -71.6811573 | 2020-12-01 05:26:18 | Merrimack, New Hampshire, US |
2020-11-30 | US | Kansas | Harvey | 20079 | 1842 | 15 | 0 | 1827 | 38.04293782 | -97.42747573 | 2020-12-01 05:26:18 | Harvey, Kansas, US |
2020-11-28 | Russia | Vladimir Oblast | 12962 | 313 | 10822 | 1827 | 56.0503336 | 40.6561633 | 2020-11-29 05:25:55 | Vladimir Oblast, Russia | ||
2020-11-27 | US | Minnesota | Steele | 27147 | 1833 | 6 | 0 | 1827 | 44.02240351 | -93.22627088 | 2020-11-28 05:25:50 | Steele, Minnesota, US |
2020-11-26 | US | Oklahoma | Custer | 40039 | 1839 | 12 | 0 | 1827 | 35.63853802 | -99.00170785 | 2020-11-27 05:26:53 | Custer, Oklahoma, US |
2020-11-25 | US | Oklahoma | Custer | 40039 | 1839 | 12 | 0 | 1827 | 35.63853802 | -99.00170785 | 2020-11-26 05:27:44 | Custer, Oklahoma, US |
2020-11-20 | US | Oregon | Deschutes | 41017 | 1841 | 14 | 0 | 1827 | 43.91570171 | -121.2289121 | 2020-11-21 05:25:51 | Deschutes, Oregon, US |
2020-11-20 | US | Indiana | Morgan | 18109 | 1872 | 45 | 0 | 1827 | 39.47899078 | -86.44573375 | 2020-11-21 05:25:51 | Morgan, Indiana, US |
2020-11-18 | US | Texas | Caldwell | 48055 | 1568 | 39 | 0 | 1827 | 29.83668859 | -97.61814775 | 2020-11-19 05:25:23 | Caldwell, Texas, US |
2020-11-15 | US | Mississippi | Leflore | 28083 | 1915 | 88 | 0 | 1827 | 33.55545125 | -90.29900733 | 2020-11-16 05:25:57 | Leflore, Mississippi, US |
2020-11-15 | US | Florida | Okeechobee | 12093 | 1870 | 43 | 0 | 1827 | 27.386336199999995 | -80.88944347 | 2020-11-16 05:25:57 | Okeechobee, Florida, US |
2020-11-11 | US | Oklahoma | McCurtain | 40089 | 1868 | 41 | 0 | 1827 | 34.11664328 | -94.77222373 | 2020-11-12 05:25:55 | McCurtain, Oklahoma, US |
2020-11-06 | US | North Carolina | Columbus | 37047 | 1891 | 64 | 0 | 1827 | 34.26744084 | -78.65801424 | 2020-11-07 05:24:52 | Columbus, North Carolina, US |
2020-11-01 | US | Washington | Whitman | 53075 | 1843 | 16 | 0 | 1827 | 46.90022523 | -117.5241763 | 2020-11-02 05:25:04 | Whitman, Washington, US |
2020-10-29 | US | Florida | Unassigned | 90012 | 1827 | 0 | 0 | 1827 | 30.86747479 | 0.0 | 2020-10-30 04:24:49 | Unassigned, Florida, US |
2020-10-28 | US | Nebraska | Buffalo | 31019 | 1844 | 17 | 0 | 1827 | 40.85486962 | -99.07500296 | 2020-10-29 04:24:49 | Buffalo, Nebraska, US |
2020-10-20 | US | New Mexico | Lea | 35025 | 1855 | 28 | 0 | 1827 | 32.79215361 | -103.4123733 | 2020-10-21 04:24:14 | Lea, New Mexico, US |
2020-10-20 | US | Alabama | Dallas | 1047 | 1854 | 27 | 0 | 1827 | 32.32688101 | -87.10866709999998 | 2020-10-21 04:24:14 | Dallas, Alabama, US |
2020-10-17 | US | Missouri | Cass | 29037 | 1855 | 28 | 0 | 1827 | 38.64789422 | -94.353399 | 2020-10-18 04:24:25 | Cass, Missouri, US |
2020-10-15 | US | New York | Niagara | 36063 | 1928 | 101 | 0 | 1827 | 43.19898042 | -78.74777412 | 2020-10-16 04:24:01 | Niagara, New York, US |
2020-10-13 | US | Louisiana | St. Charles | 22089 | 1889 | 62 | 0 | 1827 | 29.90709658 | -90.35555967 | 2020-10-14 04:24:05 | St. Charles, Louisiana, US |
2020-10-10 | US | Iowa | Marshall | 19127 | 1863 | 36 | 0 | 1827 | 42.03586837 | -92.9990819 | 2020-10-11 04:23:46 | Marshall, Iowa, US |
2020-10-08 | Sweden | Vasternorrland | 1964 | 137 | 0 | 1827 | 63.4276 | 17.7292 | 2020-10-09 04:23:59 | Vasternorrland, Sweden | ||
2020-10-05 | US | Texas | Coryell | 48099 | 2159 | 12 | 0 | 1827 | 31.39078397 | -97.79936155 | 2020-10-06 04:23:33 | Coryell, Texas, US |
2020-10-04 | US | Texas | Coryell | 48099 | 2154 | 12 | 0 | 1827 | 31.39078397 | -97.79936155 | 2020-10-05 04:23:33 | Coryell, Texas, US |
2020-10-03 | US | Texas | Coryell | 48099 | 2153 | 12 | 0 | 1827 | 31.39078397 | -97.79936155 | 2020-10-04 04:23:44 | Coryell, Texas, US |
2020-10-03 | US | Mississippi | Bolivar | 28011 | 1898 | 71 | 0 | 1827 | 33.79696941 | -90.87372121 | 2020-10-04 04:23:44 | Bolivar, Mississippi, US |
2020-10-02 | US | Texas | Coryell | 48099 | 2141 | 12 | 0 | 1827 | 31.39078397 | -97.79936155 | 2020-10-03 04:23:40 | Coryell, Texas, US |
2020-09-30 | US | Georgia | Fayette | 13113 | 1877 | 50 | 0 | 1827 | 33.41357794 | -84.49089434 | 2020-10-01 04:23:42 | Fayette, Georgia, US |
2020-09-23 | US | Wisconsin | Fond du Lac | 55039 | 1840 | 13 | 0 | 1827 | 43.75354908 | -88.48885325 | 2020-09-24 04:23:00 | Fond du Lac, Wisconsin, US |
2020-09-11 | US | Idaho | Twin Falls | 16083 | 1862 | 35 | 0 | 1827 | 42.35440512 | -114.6685381 | 2020-09-12 04:25:05 | Twin Falls, Idaho, US |
2020-09-07 | Russia | Samara Oblast | 9196 | 135 | 7234 | 1827 | 53.2128813 | 50.8914633 | 2020-09-08 04:28:25 | Samara Oblast, Russia | ||
2020-09-04 | Russia | Sakhalin Oblast | 4622 | 0 | 2795 | 1827 | 49.7219665 | 143.448533 | 2020-09-05 04:28:19 | Sakhalin Oblast, Russia | ||
2020-09-01 | US | Louisiana | Vermilion | 22113 | 1873 | 46 | 0 | 1827 | 29.83517605 | -92.30292538 | 2020-09-02 04:28:25 | Vermilion, Louisiana, US |
2020-08-31 | US | Texas | Guadalupe | 48187 | 3386 | 72 | 0 | 1827 | 29.58165339 | -97.94786822 | 2020-09-01 04:28:31 | Guadalupe, Texas, US |
2020-08-30 | US | Texas | Guadalupe | 48187 | 3377 | 72 | 0 | 1827 | 29.58165339 | -97.94786822 | 2020-08-31 04:28:27 | Guadalupe, Texas, US |
2020-08-29 | US | Texas | Guadalupe | 48187 | 3374 | 72 | 0 | 1827 | 29.58165339 | -97.94786822 | 2020-08-30 04:28:22 | Guadalupe, Texas, US |
2020-08-25 | US | Indiana | Johnson | 18081 | 1956 | 129 | 0 | 1827 | 39.48994426 | -86.10149107 | 2020-08-26 04:28:11 | Johnson, Indiana, US |
2020-08-17 | Belarus | 69589 | 613 | 67149 | 1827 | 53.7098 | 27.9534 | 2020-08-18 04:27:56 | Belarus | |||
2020-08-15 | US | Iowa | Scott | 19163 | 1842 | 15 | 0 | 1827 | 41.63935978 | -90.61959493 | 2020-08-16 04:27:42 | Scott, Iowa, US |
2020-08-14 | US | North Carolina | Davidson | 37057 | 1849 | 22 | 0 | 1827 | 35.79115496 | -80.21256572 | 2020-08-15 04:27:31 | Davidson, North Carolina, US |
2020-08-13 | Italy | Emilia-Romagna | 30257 | 4298 | 24132 | 1827 | 44.49436681 | 11.3417208 | 2020-08-14 04:51:19 | Emilia-Romagna, Italy | ||
2020-08-08 | US | Mississippi | Jones | 28067 | 1885 | 58 | 0 | 1827 | 31.62257767 | -89.16896899999998 | 2020-08-09 04:34:54 | Jones, Mississippi, US |
2020-07-16 | US | Nebraska | Dakota | 31043 | 1864 | 37 | 0 | 1827 | 42.39040144 | -96.56656425 | 2020-07-17 04:34:50 | Dakota, Nebraska, US |
2020-07-11 | US | South Carolina | York | 45091 | 1839 | 12 | 0 | 1827 | 34.97281497 | -81.18085944 | 2020-07-12 04:34:30 | York, South Carolina, US |
2020-07-07 | Somalia | 3015 | 92 | 1096 | 1827 | 5.152149 | 46.199616 | 2020-07-08 05:33:48 | Somalia | |||
2020-07-02 | US | Florida | St. Lucie | 12111 | 1876 | 49 | 0 | 1827 | 27.37763908 | -80.47106649 | 2020-07-03 04:33:54 | St. Lucie, Florida, US |
2020-07-02 | US | Arizona | Santa Cruz | 4023 | 1849 | 22 | 0 | 1827 | 31.52508998 | -110.8479088 | 2020-07-03 04:33:54 | Santa Cruz, Arizona, US |
2020-06-25 | Bulgaria | 4408 | 211 | 2370 | 1827 | 42.7339 | 25.4858 | 2020-06-26 04:33:43 | Bulgaria | |||
2020-06-22 | US | Texas | Galveston | 48167 | 1352 | 40 | 0 | 1827 | 29.40167322 | -94.90469073 | 2020-06-23 04:33:22 | Galveston, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;