daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where confirmed = 13086 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-21 | US | Virginia | York | 51199 | 13086 | 127 | 0 | 37.24374789 | -76.54412815 | 2022-12-22 04:20:56 | York, Virginia, US | |
2022-12-18 | US | Wisconsin | Oconto | 55083 | 13086 | 129 | 0 | 45.02715345 | -88.26807503 | 2022-12-19 04:21:03 | Oconto, Wisconsin, US | |
2022-12-17 | US | Wisconsin | Oconto | 55083 | 13086 | 129 | 0 | 45.02715345 | -88.26807503 | 2022-12-18 04:21:03 | Oconto, Wisconsin, US | |
2022-12-16 | US | Wisconsin | Oconto | 55083 | 13086 | 129 | 0 | 45.02715345 | -88.26807503 | 2022-12-17 04:21:04 | Oconto, Wisconsin, US | |
2022-09-06 | US | Wisconsin | Marinette | 55075 | 13086 | 134 | 0 | 45.38553432 | -88.033246 | 2022-09-07 04:20:59 | Marinette, Wisconsin, US | |
2022-08-31 | US | Texas | Jim Wells | 48249 | 13086 | 216 | 0 | 27.73103938 | -98.0904705 | 2022-09-01 04:21:03 | Jim Wells, Texas, US | |
2022-08-23 | US | Indiana | Marshall | 18099 | 13086 | 202 | 0 | 41.32467367 | -86.26185087 | 2022-08-24 04:20:46 | Marshall, Indiana, US | |
2022-08-22 | US | Indiana | Marshall | 18099 | 13086 | 202 | 0 | 41.32467367 | -86.26185087 | 2022-08-23 04:20:56 | Marshall, Indiana, US | |
2022-08-17 | US | New York | Livingston | 36051 | 13086 | 124 | 0 | 42.72596275 | -77.77966158 | 2022-08-18 04:21:11 | Livingston, New York, US | |
2022-05-25 | US | Wisconsin | Grant | 55043 | 13086 | 146 | 0 | 42.8671731 | -90.7063218 | 2022-05-26 04:20:50 | Grant, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Grant | 55043 | 13086 | 146 | 0 | 42.8671731 | -90.7063218 | 2022-05-26 04:20:50 | Grant, Wisconsin, US | |
2022-05-10 | US | North Carolina | Haywood | 37087 | 13086 | 221 | 0 | 35.55269063 | -82.98196486 | 2022-05-11 04:20:48 | Haywood, North Carolina, US | |
2022-05-09 | US | North Carolina | Haywood | 37087 | 13086 | 221 | 0 | 35.55269063 | -82.98196486 | 2022-05-10 04:20:50 | Haywood, North Carolina, US | |
2022-05-08 | US | Tennessee | Warren | 47177 | 13086 | 177 | 0 | 35.6728299 | -85.77969117 | 2022-05-09 04:20:54 | Warren, Tennessee, US | |
2022-05-08 | US | North Carolina | Haywood | 37087 | 13086 | 221 | 0 | 35.55269063 | -82.98196486 | 2022-05-09 04:20:54 | Haywood, North Carolina, US | |
2022-05-07 | US | Tennessee | Warren | 47177 | 13086 | 177 | 0 | 35.6728299 | -85.77969117 | 2022-05-08 04:20:49 | Warren, Tennessee, US | |
2022-05-07 | US | North Carolina | Haywood | 37087 | 13086 | 221 | 0 | 35.55269063 | -82.98196486 | 2022-05-08 04:20:49 | Haywood, North Carolina, US | |
2022-05-06 | US | North Carolina | Haywood | 37087 | 13086 | 221 | 0 | 35.55269063 | -82.98196486 | 2022-05-07 04:21:09 | Haywood, North Carolina, US | |
2022-05-05 | US | North Carolina | Haywood | 37087 | 13086 | 221 | 0 | 35.55269063 | -82.98196486 | 2022-05-06 04:21:00 | Haywood, North Carolina, US | |
2022-05-04 | US | North Carolina | Haywood | 37087 | 13086 | 221 | 0 | 35.55269063 | -82.98196486 | 2022-05-05 04:20:55 | Haywood, North Carolina, US | |
2022-02-14 | US | Missouri | Taney | 29213 | 13086 | 200 | 0 | 36.65465345 | -93.04075153 | 2022-02-15 04:21:09 | Taney, Missouri, US | |
2022-01-19 | US | South Carolina | Georgetown | 45043 | 13086 | 192 | 0 | 33.43443342 | -79.33202141 | 2022-01-20 04:21:07 | Georgetown, South Carolina, US | |
2021-12-12 | Saint Lucia | 13086 | 283 | 0 | 13.9094 | -60.9789 | 2021-12-13 04:22:02 | Saint Lucia | ||||
2021-12-11 | Saint Lucia | 13086 | 283 | 0 | 13.9094 | -60.9789 | 2021-12-12 04:22:12 | Saint Lucia | ||||
2021-12-10 | Saint Lucia | 13086 | 283 | 0 | 13.9094 | -60.9789 | 2021-12-11 04:22:45 | Saint Lucia | ||||
2021-11-18 | US | Wisconsin | Manitowoc | 55071 | 13086 | 114 | 0 | 44.11946801 | -87.80928853 | 2021-11-19 04:21:40 | Manitowoc, Wisconsin, US | |
2021-10-21 | US | Pennsylvania | Adams | 42001 | 13086 | 217 | 0 | 39.87140411 | -77.21610347 | 2021-10-22 04:21:14 | Adams, Pennsylvania, US | |
2021-08-25 | US | Oregon | Deschutes | 41017 | 13086 | 91 | 0 | 43.91570171 | -121.2289121 | 2021-08-26 04:21:28 | Deschutes, Oregon, US | |
2021-05-13 | US | Texas | Randall | 48381 | 13086 | 283 | 0 | 34.96585996 | -101.8971322 | 2021-05-14 04:20:41 | Randall, Texas, US | |
2021-05-02 | US | Rhode Island | Unassigned | 90044 | 13086 | 18 | 0 | 41.87064746 | 0.0 | 2021-05-03 04:20:39 | Unassigned, Rhode Island, US | |
2021-05-01 | US | Rhode Island | Unassigned | 90044 | 13086 | 18 | 0 | 41.87064746 | 0.0 | 2021-05-02 04:20:48 | Unassigned, Rhode Island, US | |
2021-04-30 | US | Rhode Island | Unassigned | 90044 | 13086 | 18 | 0 | 41.87064746 | 0.0 | 2021-05-01 04:20:47 | Unassigned, Rhode Island, US | |
2021-04-09 | US | Virginia | Newport News | 51700 | 13086 | 215 | 0 | 37.08166899 | -76.51754109 | 2021-04-10 04:20:59 | Newport News, Virginia, US | |
2021-04-05 | US | California | Butte | 6007 | 13086 | 193 | 0 | 39.66727762 | -121.6005252 | 2021-04-06 04:20:32 | Butte, California, US | |
2021-02-25 | Sweden | Sormland | 13086 | 397 | 0 | 12689 | 59.0336 | 16.7519 | 2021-02-26 05:22:40 | Sormland, Sweden | ||
2021-02-03 | US | Alabama | Morgan | 1103 | 13086 | 209 | 0 | 12877 | 34.45500589 | -86.85475946 | 2021-02-04 05:22:26 | Morgan, Alabama, US |
2021-01-21 | US | Pennsylvania | Cumberland | 42041 | 13086 | 392 | 0 | 12694 | 40.1625372 | -77.26130755 | 2021-01-22 05:22:10 | Cumberland, Pennsylvania, US |
2020-11-22 | US | Washington | Snohomish | 53061 | 13086 | 267 | 0 | 12819 | 48.04615983 | -121.7170703 | 2020-11-23 05:25:26 | Snohomish, Washington, US |
2020-09-27 | Italy | Liguria | 13086 | 1599 | 9749 | 1738 | 44.41149315 | 8.9326992 | 2020-09-28 04:23:00 | Liguria, Italy | ||
2020-08-09 | Madagascar | 13086 | 148 | 10816 | 2122 | -18.766947 | 46.869107 | 2020-08-10 04:34:55 | Madagascar | |||
2020-08-03 | US | Connecticut | New Haven | 9009 | 13086 | 1104 | 0 | 11982 | 41.4080325 | -72.93620426 | 2020-08-04 04:41:59 | New Haven, Connecticut, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;