daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
64 rows where confirmed = 12272 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 54
- Colombia 2
- Netherlands 2
- Chile 1
- China 1
- Georgia 1
- Russia 1
- Timor-Leste 1
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Mississippi | Warren | 28149 | 12272 | 218 | 0 | 32.35810271 | -90.83352619 | 2022-12-30 04:21:04 | Warren, Mississippi, US | |
2022-12-28 | US | Mississippi | Warren | 28149 | 12272 | 218 | 0 | 32.35810271 | -90.83352619 | 2022-12-29 04:21:01 | Warren, Mississippi, US | |
2022-12-27 | US | Mississippi | Warren | 28149 | 12272 | 218 | 0 | 32.35810271 | -90.83352619 | 2022-12-28 04:21:04 | Warren, Mississippi, US | |
2022-12-12 | US | Illinois | Fulton | 17057 | 12272 | 136 | 0 | 40.47289135 | -90.20862357 | 2022-12-13 04:21:01 | Fulton, Illinois, US | |
2022-12-08 | US | West Virginia | Greenbrier | 54025 | 12272 | 175 | 0 | 37.9463652 | -80.45335881 | 2022-12-09 04:21:05 | Greenbrier, West Virginia, US | |
2022-09-21 | US | Puerto Rico | Cidra | 72041 | 12272 | 0 | 0 | 18.173559 | -66.161179 | 2022-09-22 04:22:56 | Cidra, Puerto Rico, US | |
2022-09-20 | US | Puerto Rico | Cidra | 72041 | 12272 | 0 | 0 | 18.173559 | -66.161179 | 2022-09-21 04:23:22 | Cidra, Puerto Rico, US | |
2022-09-19 | US | Puerto Rico | Cidra | 72041 | 12272 | 0 | 0 | 18.173559 | -66.161179 | 2022-09-20 04:22:48 | Cidra, Puerto Rico, US | |
2022-09-18 | US | Puerto Rico | Cidra | 72041 | 12272 | 0 | 0 | 18.173559 | -66.161179 | 2022-09-19 04:21:49 | Cidra, Puerto Rico, US | |
2022-09-05 | US | New York | Columbia | 36021 | 12272 | 154 | 0 | 42.24819348 | -73.63089095 | 2022-09-06 04:21:02 | Columbia, New York, US | |
2022-08-15 | US | Wisconsin | Oconto | 55083 | 12272 | 125 | 0 | 45.02715345 | -88.26807503 | 2022-08-16 04:20:58 | Oconto, Wisconsin, US | |
2022-08-14 | US | Kentucky | Clark | 21049 | 12272 | 75 | 0 | 37.9689263 | -84.14615986 | 2022-08-15 04:20:59 | Clark, Kentucky, US | |
2022-08-13 | US | Kentucky | Clark | 21049 | 12272 | 75 | 0 | 37.9689263 | -84.14615986 | 2022-08-14 04:20:55 | Clark, Kentucky, US | |
2022-08-12 | US | Kentucky | Clark | 21049 | 12272 | 75 | 0 | 37.9689263 | -84.14615986 | 2022-08-13 04:20:52 | Clark, Kentucky, US | |
2022-08-11 | US | Kentucky | Clark | 21049 | 12272 | 75 | 0 | 37.9689263 | -84.14615986 | 2022-08-12 04:20:54 | Clark, Kentucky, US | |
2022-08-10 | US | Kentucky | Clark | 21049 | 12272 | 75 | 0 | 37.9689263 | -84.14615986 | 2022-08-11 04:20:49 | Clark, Kentucky, US | |
2022-08-09 | US | Kentucky | Clark | 21049 | 12272 | 75 | 0 | 37.9689263 | -84.14615986 | 2022-08-10 04:20:57 | Clark, Kentucky, US | |
2022-08-08 | US | Kentucky | Clark | 21049 | 12272 | 75 | 0 | 37.9689263 | -84.14615986 | 2022-08-09 04:20:34 | Clark, Kentucky, US | |
2022-07-06 | US | Wisconsin | Marinette | 55075 | 12272 | 131 | 0 | 45.38553432 | -88.033246 | 2022-07-07 04:20:55 | Marinette, Wisconsin, US | |
2022-05-16 | US | Louisiana | Lincoln | 22061 | 12272 | 144 | 0 | 32.6003154 | -92.6659741 | 2022-05-17 04:20:59 | Lincoln, Louisiana, US | |
2022-05-15 | US | Illinois | Franklin | 17055 | 12272 | 166 | 0 | 37.99189086 | -88.92567818 | 2022-05-16 04:20:47 | Franklin, Illinois, US | |
2022-05-14 | US | Illinois | Franklin | 17055 | 12272 | 166 | 0 | 37.99189086 | -88.92567818 | 2022-05-15 04:20:53 | Franklin, Illinois, US | |
2022-05-13 | US | Illinois | Franklin | 17055 | 12272 | 166 | 0 | 37.99189086 | -88.92567818 | 2022-05-14 04:20:48 | Franklin, Illinois, US | |
2022-04-25 | US | Tennessee | Campbell | 47013 | 12272 | 169 | 0 | 36.40355516 | -84.15108559999999 | 2022-04-26 04:20:51 | Campbell, Tennessee, US | |
2022-04-13 | US | Illinois | Franklin | 17055 | 12272 | 165 | 0 | 37.99189086 | -88.92567818 | 2022-04-13 23:21:06 | Franklin, Illinois, US | |
2022-04-12 | US | Illinois | Franklin | 17055 | 12272 | 165 | 0 | 37.99189086 | -88.92567818 | 2022-04-13 04:21:03 | Franklin, Illinois, US | |
2022-04-05 | US | Illinois | Franklin | 17055 | 12272 | 165 | 0 | 37.99189086 | -88.92567818 | 2022-04-06 04:20:49 | Franklin, Illinois, US | |
2022-03-31 | US | Washington | Mason | 53045 | 12272 | 138 | 0 | 47.35007586 | -123.1863685 | 2022-04-01 04:20:28 | Mason, Washington, US | |
2022-03-30 | US | Washington | Mason | 53045 | 12272 | 138 | 0 | 47.35007586 | -123.1863685 | 2022-03-31 04:20:56 | Mason, Washington, US | |
2022-03-11 | US | Maine | Aroostook | 23003 | 12272 | 145 | 0 | 46.65926321 | -68.59841248 | 2022-03-12 04:20:50 | Aroostook, Maine, US | |
2022-01-20 | US | Ohio | Athens | 39009 | 12272 | 113 | 0 | 39.33425634 | -82.04278644 | 2022-01-21 04:21:09 | Athens, Ohio, US | |
2021-12-11 | US | Alabama | Walker | 1127 | 12272 | 386 | 0 | 33.80270512 | -87.30027177 | 2021-12-12 04:22:12 | Walker, Alabama, US | |
2021-11-21 | US | Texas | Coryell | 48099 | 12272 | 166 | 0 | 31.39078397 | -97.79936155 | 2021-11-22 04:22:20 | Coryell, Texas, US | |
2021-11-20 | US | Texas | Coryell | 48099 | 12272 | 166 | 0 | 31.39078397 | -97.79936155 | 2021-11-21 04:22:13 | Coryell, Texas, US | |
2021-11-16 | United Kingdom | Jersey | 12272 | 80 | 0 | 0 | 49.2138 | -2.1358 | 2021-11-17 04:21:48 | Jersey, United Kingdom | ||
2021-10-12 | China | Hong Kong | 12272 | 213 | 0 | 22.3 | 114.2 | 2021-10-13 04:20:51 | Hong Kong, China | |||
2021-10-04 | US | Louisiana | Iberia | 22045 | 12272 | 220 | 0 | 29.86803617 | -91.75871777 | 2021-10-05 04:21:27 | Iberia, Louisiana, US | |
2021-09-19 | US | California | Napa | 6055 | 12272 | 95 | 0 | 38.50735751 | -122.33283899999999 | 2021-09-20 04:21:22 | Napa, California, US | |
2021-08-14 | Timor-Leste | 12272 | 29 | 0 | -8.874217 | 125.727539 | 2021-08-15 04:21:41 | Timor-Leste | ||||
2021-08-09 | US | Minnesota | Sherburne | 27141 | 12272 | 96 | 0 | 45.44447208 | -93.77617511 | 2021-08-10 04:21:27 | Sherburne, Minnesota, US | |
2021-08-02 | US | Alaska | Matanuska-Susitna | 2170 | 12272 | 61 | 0 | 62.31305045 | -149.5741743 | 2021-08-03 04:21:39 | Matanuska-Susitna, Alaska, US | |
2021-06-13 | US | Tennessee | Unassigned | 90047 | 12272 | 99 | 0 | 36.55606529 | 0.0 | 2021-06-14 04:22:46 | Unassigned, Tennessee, US | |
2021-06-12 | US | Tennessee | Unassigned | 90047 | 12272 | 99 | 0 | 36.55606529 | 0.0 | 2021-06-13 04:22:44 | Unassigned, Tennessee, US | |
2021-06-11 | US | Tennessee | Unassigned | 90047 | 12272 | 99 | 0 | 36.55606529 | 0.0 | 2021-06-12 04:22:22 | Unassigned, Tennessee, US | |
2021-05-31 | Netherlands | Curacao | 12272 | 122 | 12121 | 29 | 12.1696 | -68.99 | 2021-06-01 04:23:09 | Curacao, Netherlands | ||
2021-05-30 | Netherlands | Curacao | 12272 | 122 | 12121 | 29 | 12.1696 | -68.99 | 2021-05-31 03:08:59 | Curacao, Netherlands | ||
2021-05-29 | Russia | Chechen Republic | 12272 | 134 | 12011 | 127 | 43.39761470000001 | 45.6985005 | 2021-05-30 04:20:55 | Chechen Republic, Russia | ||
2021-05-05 | US | Washington | Franklin | 53021 | 12272 | 110 | 0 | 46.53351425 | -118.9018212 | 2021-05-06 04:20:38 | Franklin, Washington, US | |
2021-04-22 | US | Florida | Indian River | 12061 | 12272 | 290 | 0 | 27.69308961 | -80.60556721 | 2021-04-23 04:20:52 | Indian River, Florida, US | |
2021-04-16 | US | Florida | Charlotte | 12015 | 12272 | 402 | 0 | 26.90131002 | -81.92949121 | 2021-04-17 04:20:40 | Charlotte, Florida, US | |
2021-04-09 | US | Arkansas | Faulkner | 5045 | 12272 | 156 | 0 | 35.14719007 | -92.33717519 | 2021-04-10 04:20:59 | Faulkner, Arkansas, US | |
2021-04-06 | US | Michigan | Monroe | 26115 | 12272 | 214 | 0 | 41.92734151 | -83.53749864 | 2021-04-07 04:20:53 | Monroe, Michigan, US | |
2021-03-09 | US | Pennsylvania | Schuylkill | 42107 | 12272 | 372 | 0 | 40.70497338 | -76.2150785 | 2021-03-10 05:24:35 | Schuylkill, Pennsylvania, US | |
2021-03-07 | US | Missouri | Jasper | 29097 | 12272 | 224 | 0 | 37.20351921 | -94.34050458 | 2021-03-08 05:24:48 | Jasper, Missouri, US | |
2021-03-03 | US | Tennessee | Maury | 47119 | 12272 | 163 | 0 | 12075 | 35.6187413 | -87.07462444 | 2021-03-04 05:24:24 | Maury, Tennessee, US |
2021-02-25 | Colombia | Casanare | 12272 | 265 | 11646 | 361 | 5.7589 | -71.5724 | 2021-02-26 05:22:40 | Casanare, Colombia | ||
2021-02-12 | US | Mississippi | Rankin | 28121 | 12272 | 252 | 0 | 12020 | 32.26469147 | -89.94537876 | 2021-02-13 05:22:12 | Rankin, Mississippi, US |
2020-12-25 | US | Virginia | Chesterfield | 51041 | 12272 | 164 | 0 | 12108 | 37.37373208 | -77.58680140000001 | 2020-12-26 05:22:28 | Chesterfield, Virginia, US |
2020-11-21 | US | Florida | Alachua | 12001 | 12272 | 92 | 0 | 12180 | 29.67866525 | -82.35928158 | 2020-11-22 05:25:45 | Alachua, Florida, US |
2020-11-04 | US | North Carolina | Guilford | 37081 | 12272 | 213 | 0 | 12059 | 36.07959451 | -79.78824948 | 2020-11-05 06:05:03 | Guilford, North Carolina, US |
2020-10-31 | Chile | Magallanes | 12272 | 135 | 11690 | 447 | -52.368 | -70.9863 | 2020-11-01 04:36:19 | Magallanes, Chile | ||
2020-10-12 | Georgia | 12272 | 91 | 6538 | 5641 | 42.3154 | 43.3569 | 2020-10-13 04:24:02 | Georgia | |||
2020-09-16 | US | Florida | Collier | 12021 | 12272 | 194 | 0 | 12078 | 26.11091986 | -81.34687065 | 2020-09-17 04:22:00 | Collier, Florida, US |
2020-05-12 | Colombia | 12272 | 493 | 2971 | 8808 | 4.5709 | -74.2973 | 2020-05-13 03:32:26 | Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;