daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
103 rows where active = 2043 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-07-26 | Russia | Tyumen Oblast | 45174 | 950 | 42181 | 2043 | 58.8206488 | 70.36588370000001 | 2021-07-27 04:21:18 | Tyumen Oblast, Russia | ||
2021-06-05 | Russia | Penza Oblast | 47637 | 836 | 44758 | 2043 | 53.1655415 | 44.78791810000001 | 2021-06-06 04:24:03 | Penza Oblast, Russia | ||
2021-06-02 | Chile | Los Lagos | 78068 | 1053 | 74972 | 2043 | -41.9198 | -72.1416 | 2021-06-03 04:23:32 | Los Lagos, Chile | ||
2021-06-01 | Ukraine | Rivne Oblast | 78329 | 1173 | 75113 | 2043 | 50.6199 | 26.2516 | 2021-06-02 04:24:34 | Rivne Oblast, Ukraine | ||
2021-05-15 | Colombia | Caldas | 65938 | 1340 | 62555 | 2043 | 5.2983 | -75.2479 | 2021-05-16 04:20:49 | Caldas, Colombia | ||
2021-05-07 | Colombia | Bolivar | 85262 | 1632 | 81587 | 2043 | 8.6704 | -74.03 | 2021-05-08 04:21:04 | Bolivar, Colombia | ||
2021-04-23 | Russia | Penza Oblast | 44288 | 605 | 41640 | 2043 | 53.1655415 | 44.78791810000001 | 2021-04-24 04:20:38 | Penza Oblast, Russia | ||
2021-03-02 | US | New York | Lewis | 36049 | 2073 | 30 | 0 | 2043 | 43.7844157 | -75.44903992 | 2021-03-03 05:23:28 | Lewis, New York, US |
2021-03-01 | US | Wyoming | Uinta | 56041 | 2055 | 12 | 0 | 2043 | 41.2878183 | -110.54757820000002 | 2021-03-02 05:23:30 | Uinta, Wyoming, US |
2021-02-24 | US | Wisconsin | Langlade | 55067 | 2086 | 43 | 0 | 2043 | 45.26271619 | -89.07483625 | 2021-02-25 05:24:57 | Langlade, Wisconsin, US |
2021-02-23 | US | Missouri | Adair | 29001 | 2059 | 16 | 0 | 2043 | 40.19058551 | -92.60078167 | 2021-02-24 05:29:16 | Adair, Missouri, US |
2021-02-22 | US | Texas | Young | 48503 | 2066 | 38 | 0 | 2043 | 33.17659707 | -98.68790885 | 2021-02-23 05:23:41 | Young, Texas, US |
2021-02-22 | US | Minnesota | Waseca | 27161 | 2060 | 17 | 0 | 2043 | 44.02211116 | -93.58720034 | 2021-02-23 05:23:41 | Waseca, Minnesota, US |
2021-02-21 | US | Texas | Young | 48503 | 2066 | 38 | 0 | 2043 | 33.17659707 | -98.68790885 | 2021-02-22 05:24:21 | Young, Texas, US |
2021-02-21 | US | Indiana | Washington | 18175 | 2070 | 27 | 0 | 2043 | 38.60219804 | -86.1049363 | 2021-02-22 05:24:21 | Washington, Indiana, US |
2021-02-20 | US | Texas | Young | 48503 | 2066 | 38 | 0 | 2043 | 33.17659707 | -98.68790885 | 2021-02-21 05:24:33 | Young, Texas, US |
2021-02-19 | Russia | Krasnoyarsk Krai | 61040 | 2684 | 56313 | 2043 | 63.3233807 | 97.0979974 | 2021-02-20 05:22:51 | Krasnoyarsk Krai, Russia | ||
2021-02-18 | US | Nebraska | Gage | 31067 | 2059 | 16 | 0 | 2043 | 40.26186809 | -96.68946704 | 2021-02-19 05:24:16 | Gage, Nebraska, US |
2021-02-13 | US | Missouri | Warren | 29219 | 2056 | 13 | 0 | 2043 | 38.76529479 | -91.16124662 | 2021-02-14 05:23:43 | Warren, Missouri, US |
2021-02-08 | US | Idaho | Blaine | 16013 | 2057 | 14 | 0 | 2043 | 43.4085812 | -113.9752658 | 2021-02-09 05:23:30 | Blaine, Idaho, US |
2021-02-06 | US | New York | Otsego | 36077 | 2079 | 36 | 0 | 2043 | 42.63492579 | -75.03151402 | 2021-02-07 05:23:00 | Otsego, New York, US |
2021-02-05 | US | Missouri | Washington | 29221 | 2085 | 42 | 0 | 2043 | 37.96130078 | -90.87948158 | 2021-02-06 05:23:55 | Washington, Missouri, US |
2021-02-04 | US | Ohio | Gallia | 39053 | 2082 | 39 | 0 | 2043 | 38.82708533 | -82.31647569 | 2021-02-05 05:22:38 | Gallia, Ohio, US |
2021-02-03 | US | Texas | Hockley | 48219 | 3091 | 96 | 0 | 2043 | 33.60771256 | -102.3431676 | 2021-02-04 05:22:26 | Hockley, Texas, US |
2021-02-02 | US | Wisconsin | Vilas | 55125 | 2077 | 34 | 0 | 2043 | 46.05467334 | -89.51719204 | 2021-02-03 05:22:52 | Vilas, Wisconsin, US |
2021-02-02 | US | South Carolina | Barnwell | 45011 | 2086 | 43 | 0 | 2043 | 33.26679302 | -81.43584352 | 2021-02-03 05:22:52 | Barnwell, South Carolina, US |
2021-01-29 | US | Mississippi | Winston | 28159 | 2115 | 72 | 0 | 2043 | 33.08747908 | -89.03391385 | 2021-01-30 05:22:49 | Winston, Mississippi, US |
2021-01-26 | US | Washington | Mason | 53045 | 2061 | 18 | 0 | 2043 | 47.35007586 | -123.1863685 | 2021-01-27 05:23:41 | Mason, Washington, US |
2021-01-26 | US | Georgia | Peach | 13225 | 2080 | 37 | 0 | 2043 | 32.56934316 | -83.82937 | 2021-01-27 05:23:41 | Peach, Georgia, US |
2021-01-23 | US | Illinois | Saline | 17165 | 2082 | 39 | 0 | 2043 | 37.75332999 | -88.54119706 | 2021-01-24 05:22:35 | Saline, Illinois, US |
2021-01-21 | US | Virginia | Staunton | 51790 | 2092 | 49 | 0 | 2043 | 38.15965544 | -79.05979937 | 2021-01-22 05:22:10 | Staunton, Virginia, US |
2021-01-14 | Russia | Tula Oblast | 25696 | 887 | 22766 | 2043 | 53.9570701 | 37.3690909 | 2021-01-15 05:22:24 | Tula Oblast, Russia | ||
2021-01-13 | Russia | Tula Oblast | 25489 | 880 | 22566 | 2043 | 53.9570701 | 37.3690909 | 2021-01-14 05:22:32 | Tula Oblast, Russia | ||
2021-01-12 | US | Minnesota | Le Sueur | 27079 | 2058 | 15 | 0 | 2043 | 44.37136597 | -93.72844721 | 2021-01-13 05:22:15 | Le Sueur, Minnesota, US |
2021-01-10 | US | Texas | Matagorda | 48321 | 2159 | 68 | 0 | 2043 | 28.81955746 | -96.01230294 | 2021-01-11 05:21:50 | Matagorda, Texas, US |
2021-01-09 | US | Texas | Burnet | 48053 | 2589 | 30 | 0 | 2043 | 30.78801353 | -98.181887 | 2021-01-10 05:22:12 | Burnet, Texas, US |
2021-01-07 | US | Georgia | Madison | 13195 | 2067 | 24 | 0 | 2043 | 34.12920917 | -83.21218732 | 2021-01-08 05:22:42 | Madison, Georgia, US |
2021-01-03 | US | Missouri | Saline | 29195 | 2066 | 23 | 0 | 2043 | 39.13734288 | -93.20259964 | 2021-01-04 05:22:02 | Saline, Missouri, US |
2021-01-01 | US | Arkansas | Baxter | 5005 | 2114 | 71 | 0 | 2043 | 36.28784385 | -92.33782872 | 2021-01-02 05:22:33 | Baxter, Arkansas, US |
2020-12-31 | US | Arkansas | Carroll | 5015 | 2073 | 30 | 0 | 2043 | 36.34038560000001 | -93.54270261 | 2021-01-01 05:23:07 | Carroll, Arkansas, US |
2020-12-30 | US | Arkansas | Sevier | 5133 | 2063 | 20 | 0 | 2043 | 33.99780401 | -94.2424869 | 2020-12-31 05:22:49 | Sevier, Arkansas, US |
2020-12-25 | US | Iowa | Crawford | 19047 | 2064 | 21 | 0 | 2043 | 42.03718237 | -95.3819718 | 2020-12-26 05:22:28 | Crawford, Iowa, US |
2020-12-21 | US | Louisiana | Jefferson Davis | 22053 | 2105 | 62 | 0 | 2043 | 30.26896765 | -92.81210004 | 2020-12-22 05:22:33 | Jefferson Davis, Louisiana, US |
2020-12-20 | US | Illinois | Fulton | 17057 | 2067 | 24 | 0 | 2043 | 40.47289135 | -90.20862357 | 2020-12-21 05:27:58 | Fulton, Illinois, US |
2020-12-11 | US | Missouri | Marion | 29127 | 2063 | 20 | 0 | 2043 | 39.80601912 | -91.62203062 | 2020-12-12 05:26:19 | Marion, Missouri, US |
2020-12-10 | US | Texas | Brown | 48049 | 1574 | 37 | 0 | 2043 | 31.77430356 | -98.99907113 | 2020-12-11 05:26:59 | Brown, Texas, US |
2020-12-10 | US | New Hampshire | Strafford | 33017 | 2060 | 17 | 0 | 2043 | 43.291833 | -71.02336013 | 2020-12-11 05:26:59 | Strafford, New Hampshire, US |
2020-12-10 | US | Missouri | Marion | 29127 | 2063 | 20 | 0 | 2043 | 39.80601912 | -91.62203062 | 2020-12-11 05:26:59 | Marion, Missouri, US |
2020-12-06 | US | Virginia | Albemarle | 51003 | 2070 | 27 | 0 | 2043 | 38.02080697 | -78.55481085 | 2020-12-07 05:26:14 | Albemarle, Virginia, US |
2020-12-05 | US | Ohio | Belmont | 39013 | 2093 | 50 | 0 | 2043 | 40.01625942 | -80.9924051 | 2020-12-06 05:26:18 | Belmont, Ohio, US |
2020-11-30 | US | Arkansas | St. Francis | 5123 | 2058 | 15 | 0 | 2043 | 35.02201976 | -90.74828138 | 2020-12-01 05:26:18 | St. Francis, Arkansas, US |
2020-11-29 | US | South Carolina | Newberry | 45071 | 2107 | 64 | 0 | 2043 | 34.28629098 | -81.59935761 | 2020-11-30 05:26:13 | Newberry, South Carolina, US |
2020-11-28 | Russia | Bashkortostan Republic | 13987 | 80 | 11864 | 2043 | 54.8573563 | 57.1439682 | 2020-11-29 05:25:55 | Bashkortostan Republic, Russia | ||
2020-11-23 | US | Tennessee | Weakley | 47183 | 2072 | 34 | 0 | 2043 | 36.29896232 | -88.71990865 | 2020-11-24 05:27:31 | Weakley, Tennessee, US |
2020-11-20 | US | Michigan | Isabella | 26073 | 2060 | 17 | 0 | 2043 | 43.64060976 | -84.84664923 | 2020-11-21 05:25:51 | Isabella, Michigan, US |
2020-11-19 | US | Oklahoma | McClain | 40087 | 2059 | 16 | 0 | 2043 | 35.01123903 | -97.44572302 | 2020-11-20 05:26:28 | McClain, Oklahoma, US |
2020-11-17 | US | Minnesota | Mower | 27099 | 2065 | 22 | 0 | 2043 | 43.67142874 | -92.75234549 | 2020-11-18 05:40:31 | Mower, Minnesota, US |
2020-11-16 | US | Illinois | Grundy | 17063 | 2053 | 10 | 0 | 2043 | 41.28569601 | -88.41905692 | 2020-11-17 05:25:54 | Grundy, Illinois, US |
2020-11-15 | US | Michigan | Marquette | 26103 | 2065 | 22 | 0 | 2043 | 46.4338914 | -87.64043701 | 2020-11-16 05:25:57 | Marquette, Michigan, US |
2020-11-15 | Japan | Hokkaido | 5494 | 127 | 3324 | 2043 | 43.385711 | 142.552318 | 2020-11-16 05:25:57 | Hokkaido, Japan | ||
2020-11-14 | US | Wyoming | Campbell | 56005 | 2049 | 6 | 0 | 2043 | 44.24886082 | -105.5474404 | 2020-11-15 05:26:53 | Campbell, Wyoming, US |
2020-11-14 | US | West Virginia | Cabell | 54011 | 2087 | 44 | 0 | 2043 | 38.42424062 | -82.23855912 | 2020-11-15 05:26:53 | Cabell, West Virginia, US |
2020-11-14 | US | Michigan | Marquette | 26103 | 2065 | 22 | 0 | 2043 | 46.4338914 | -87.64043701 | 2020-11-15 05:26:53 | Marquette, Michigan, US |
2020-11-12 | US | West Virginia | Berkeley | 54003 | 2062 | 19 | 0 | 2043 | 39.46704621 | -78.02414609 | 2020-11-13 05:25:30 | Berkeley, West Virginia, US |
2020-11-12 | US | Arkansas | Greene | 5055 | 2067 | 24 | 0 | 2043 | 36.11735460000001 | -90.55832668 | 2020-11-13 05:25:30 | Greene, Arkansas, US |
2020-11-11 | US | California | Sutter | 6101 | 2054 | 12 | 0 | 2043 | 39.03417539 | -121.6945899 | 2020-11-12 05:25:55 | Sutter, California, US |
2020-11-10 | US | Indiana | Marshall | 18099 | 2079 | 36 | 0 | 2043 | 41.32467367 | -86.26185087 | 2020-11-11 05:25:30 | Marshall, Indiana, US |
2020-11-07 | US | Tennessee | Anderson | 47001 | 2085 | 18 | 0 | 2043 | 36.12684348 | -84.19965764 | 2020-11-08 05:24:56 | Anderson, Tennessee, US |
2020-11-03 | US | New Mexico | Santa Fe | 35049 | 2058 | 15 | 0 | 2043 | 35.50708973 | -105.9774716 | 2020-11-04 05:25:09 | Santa Fe, New Mexico, US |
2020-11-01 | US | Puerto Rico | Toa Baja | 72137 | 2043 | 0 | 0 | 2043 | 18.431446 | -66.213553 | 2020-11-02 05:25:04 | Toa Baja, Puerto Rico, US |
2020-10-23 | US | North Dakota | Morton | 38059 | 2144 | 50 | 0 | 2043 | 46.71681782 | -101.2822377 | 2020-10-24 04:24:46 | Morton, North Dakota, US |
2020-10-16 | US | Puerto Rico | Guaynabo | 72061 | 2043 | 0 | 0 | 2043 | 18.345114 | -66.11452299999999 | 2020-10-17 04:24:12 | Guaynabo, Puerto Rico, US |
2020-10-11 | US | Arkansas | Garland | 5051 | 2099 | 56 | 0 | 2043 | 34.57692074 | -93.14921604 | 2020-10-12 04:23:45 | Garland, Arkansas, US |
2020-10-10 | US | Florida | Walton | 12131 | 2072 | 29 | 0 | 2043 | 30.64204028 | -86.16935664 | 2020-10-11 04:23:46 | Walton, Florida, US |
2020-10-09 | US | Florida | Walton | 12131 | 2072 | 29 | 0 | 2043 | 30.64204028 | -86.16935664 | 2020-10-10 04:23:57 | Walton, Florida, US |
2020-10-07 | Mexico | Jalisco | 28639 | 3462 | 23134 | 2043 | 20.6595 | -103.3494 | 2020-10-08 04:23:56 | Jalisco, Mexico | ||
2020-10-03 | US | Georgia | Coffee | 13069 | 2094 | 51 | 0 | 2043 | 31.54892966 | -82.85492059999999 | 2020-10-04 04:23:44 | Coffee, Georgia, US |
2020-10-02 | US | Kentucky | Kenton | 21117 | 2092 | 49 | 0 | 2043 | 38.93950319 | -84.53241199 | 2020-10-03 04:23:40 | Kenton, Kentucky, US |
2020-10-01 | US | Pennsylvania | Lebanon | 42075 | 2103 | 60 | 0 | 2043 | 40.36680311 | -76.45651841 | 2020-10-02 04:23:51 | Lebanon, Pennsylvania, US |
2020-09-27 | Ukraine | Cherkasy Oblast | 3694 | 53 | 1598 | 2043 | 49.4444 | 32.0598 | 2020-09-28 04:23:00 | Cherkasy Oblast, Ukraine | ||
2020-09-25 | US | Ohio | Fairfield | 39045 | 2087 | 44 | 0 | 2043 | 39.75107189 | -82.63088163 | 2020-09-26 04:23:00 | Fairfield, Ohio, US |
2020-09-18 | US | Guam | 66 | 2074 | 31 | 0 | 2043 | 13.4443 | 144.7937 | 2020-09-19 04:22:00 | Guam, US | |
2020-09-18 | Russia | Leningrad Oblast | 7468 | 91 | 5334 | 2043 | 60.1853296 | 32.3925325 | 2020-09-19 04:22:00 | Leningrad Oblast, Russia | ||
2020-09-17 | Italy | Sicilia | 5569 | 295 | 3231 | 2043 | 38.11569725 | 13.3623567 | 2020-09-18 05:05:00 | Sicilia, Italy | ||
2020-09-15 | US | Nebraska | Dakota | 31043 | 2086 | 43 | 0 | 2043 | 42.39040144 | -96.56656425 | 2020-09-16 04:22:53 | Dakota, Nebraska, US |
2020-09-13 | US | Florida | Sumter | 12119 | 2103 | 60 | 0 | 2043 | 28.70181754 | -82.0794267 | 2020-09-14 04:26:00 | Sumter, Florida, US |
2020-09-09 | Sweden | Dalarna | 2217 | 174 | 0 | 2043 | 61.0917 | 14.6664 | 2020-09-10 04:29:01 | Dalarna, Sweden | ||
2020-08-28 | US | Mississippi | Forrest | 28035 | 2104 | 61 | 0 | 2043 | 31.18961454 | -89.25832496 | 2020-08-29 04:28:19 | Forrest, Mississippi, US |
2020-08-25 | US | New York | Ulster | 36111 | 2137 | 94 | 0 | 2043 | 41.89027881 | -74.26252104 | 2020-08-26 04:28:11 | Ulster, New York, US |
2020-08-20 | US | Georgia | Newton | 13217 | 2095 | 52 | 0 | 2043 | 33.55514538 | -83.84547140000002 | 2020-08-21 04:27:41 | Newton, Georgia, US |
2020-08-19 | Russia | Khabarovsk Krai | 9229 | 83 | 7103 | 2043 | 51.6312684 | 136.121524 | 2020-08-20 04:27:43 | Khabarovsk Krai, Russia | ||
2020-08-11 | US | North Carolina | Pitt | 37147 | 2054 | 11 | 0 | 2043 | 35.59535426 | -77.37353178 | 2020-08-12 04:27:29 | Pitt, North Carolina, US |
2020-07-26 | Russia | Altai Krai | 8531 | 64 | 6424 | 2043 | 52.693224300000004 | 82.69314240000001 | 2020-07-27 04:35:02 | Altai Krai, Russia | ||
2020-07-24 | Zambia | 3856 | 136 | 1677 | 2043 | -13.133897 | 27.849332 | 2020-07-25 04:47:39 | Zambia | |||
2020-07-22 | Colombia | Cordoba | 3173 | 357 | 773 | 2043 | 8.0493 | -75.574 | 2020-07-23 05:15:04 | Cordoba, Colombia | ||
2020-07-20 | Mexico | Tamaulipas | 11299 | 704 | 8552 | 2043 | 24.2669 | -98.8363 | 2020-07-21 04:38:46 | Tamaulipas, Mexico | ||
2020-07-07 | US | Illinois | McHenry | 17111 | 2141 | 98 | 0 | 2043 | 42.32451172 | -88.45248227 | 2020-07-08 05:33:48 | McHenry, Illinois, US |
2020-07-07 | US | New York | Albany | 36001 | 2164 | 121 | 0 | 2043 | 42.60060306 | -73.97723916 | 2020-07-08 05:33:48 | Albany, New York, US |
2020-07-06 | US | Pennsylvania | Dauphin | 42043 | 2183 | 140 | 0 | 2043 | 40.41377078 | -76.77993242 | 2020-07-07 04:34:00 | Dauphin, Pennsylvania, US |
2020-06-27 | US | Texas | Brazoria | 48039 | 1817 | 21 | 0 | 2043 | 29.18757369 | -95.44563172 | 2020-06-28 04:34:04 | Brazoria, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;