daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where confirmed = 31505 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-09-19 | US | New York | Oswego | 36075 | 31505 | 209 | 0 | 43.42778894 | -76.14635194 | 2022-09-20 04:22:48 | Oswego, New York, US | |
2022-01-25 | US | Pennsylvania | Cambria | 42021 | 31505 | 660 | 0 | 40.49527404 | -78.71377428 | 2022-01-26 04:21:07 | Cambria, Pennsylvania, US | |
2022-01-17 | US | New Mexico | San Juan | 35045 | 31505 | 671 | 0 | 36.50838318 | -108.32043700000001 | 2022-01-18 04:21:04 | San Juan, New Mexico, US | |
2022-01-16 | US | New Mexico | San Juan | 35045 | 31505 | 671 | 0 | 36.50838318 | -108.32043700000001 | 2022-01-17 04:21:08 | San Juan, New Mexico, US | |
2022-01-15 | US | New Mexico | San Juan | 35045 | 31505 | 671 | 0 | 36.50838318 | -108.32043700000001 | 2022-01-16 04:21:12 | San Juan, New Mexico, US | |
2022-01-14 | US | New Mexico | San Juan | 35045 | 31505 | 671 | 0 | 36.50838318 | -108.32043700000001 | 2022-01-15 04:21:07 | San Juan, New Mexico, US | |
2021-07-22 | Netherlands | Zeeland | 31505 | 249 | 0 | 31190 | 51.47936 | 3.861559 | 2021-07-23 04:21:29 | Zeeland, Netherlands | ||
2021-06-24 | US | Arkansas | Washington | 5143 | 31505 | 356 | 0 | 35.976844 | -94.21800746 | 2021-06-25 04:21:33 | Washington, Arkansas, US | |
2021-05-11 | Colombia | Cauca | 31505 | 843 | 30006 | 656 | 2.705 | -76.82600000000002 | 2021-05-12 04:21:29 | Cauca, Colombia | ||
2021-03-11 | US | Virginia | Virginia Beach | 51810 | 31505 | 347 | 0 | 36.73285734 | -76.04566934 | 2021-03-12 05:26:50 | Virginia Beach, Virginia, US | |
2021-02-15 | US | New York | Onondaga | 36067 | 31505 | 607 | 0 | 30898 | 43.00491923 | -76.19971155 | 2021-02-16 05:24:38 | Onondaga, New York, US |
2021-01-26 | US | Louisiana | East Baton Rouge | 22033 | 31505 | 662 | 0 | 30843 | 30.53842039 | -91.09777565 | 2021-01-27 05:23:41 | East Baton Rouge, Louisiana, US |
2020-11-17 | Chile | Valparaiso | 31505 | 1109 | 29952 | 444 | -33.0472 | -71.6127 | 2020-11-18 05:40:31 | Valparaiso, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;