daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where confirmed = 31207 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 14
- Mexico 1
- Netherlands 1
- Russia 1
- Serbia 1
- Trinidad and Tobago 1
- Ukraine 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-10-06 | US | New Jersey | Hunterdon | 34019 | 31207 | 289 | 0 | 40.56335249 | -74.91284156 | 2022-10-07 04:23:08 | Hunterdon, New Jersey, US | |
2022-08-16 | US | Pennsylvania | Lycoming | 42081 | 31207 | 549 | 0 | 41.34310539 | -77.06629984 | 2022-08-17 04:20:59 | Lycoming, Pennsylvania, US | |
2022-08-15 | US | Pennsylvania | Lycoming | 42081 | 31207 | 549 | 0 | 41.34310539 | -77.06629984 | 2022-08-16 04:20:58 | Lycoming, Pennsylvania, US | |
2022-08-14 | US | Pennsylvania | Lycoming | 42081 | 31207 | 549 | 0 | 41.34310539 | -77.06629984 | 2022-08-15 04:20:59 | Lycoming, Pennsylvania, US | |
2022-08-13 | US | Pennsylvania | Lycoming | 42081 | 31207 | 549 | 0 | 41.34310539 | -77.06629984 | 2022-08-14 04:20:55 | Lycoming, Pennsylvania, US | |
2022-08-12 | US | Pennsylvania | Lycoming | 42081 | 31207 | 549 | 0 | 41.34310539 | -77.06629984 | 2022-08-13 04:20:52 | Lycoming, Pennsylvania, US | |
2022-08-11 | US | Pennsylvania | Lycoming | 42081 | 31207 | 549 | 0 | 41.34310539 | -77.06629984 | 2022-08-12 04:20:54 | Lycoming, Pennsylvania, US | |
2022-08-10 | US | Pennsylvania | Lycoming | 42081 | 31207 | 549 | 0 | 41.34310539 | -77.06629984 | 2022-08-11 04:20:49 | Lycoming, Pennsylvania, US | |
2022-02-27 | US | Connecticut | Litchfield | 9005 | 31207 | 443 | 0 | 41.7937534 | -73.2451475 | 2022-02-28 04:21:05 | Litchfield, Connecticut, US | |
2022-02-26 | US | Connecticut | Litchfield | 9005 | 31207 | 443 | 0 | 41.7937534 | -73.2451475 | 2022-02-27 04:21:04 | Litchfield, Connecticut, US | |
2022-02-25 | US | Connecticut | Litchfield | 9005 | 31207 | 443 | 0 | 41.7937534 | -73.2451475 | 2022-02-26 04:21:12 | Litchfield, Connecticut, US | |
2021-12-11 | Ukraine | Kirovohrad Oblast | 31207 | 1339 | 0 | 48.5079 | 32.2623 | 2021-12-12 04:22:12 | Kirovohrad Oblast, Ukraine | |||
2021-10-22 | US | Missouri | St. Louis City | 29510 | 31207 | 601 | 0 | 38.63555736 | -90.24349225 | 2021-10-23 04:21:32 | St. Louis City, Missouri, US | |
2021-10-21 | US | Missouri | St. Louis City | 29510 | 31207 | 601 | 0 | 38.63555736 | -90.24349225 | 2021-10-22 04:21:14 | St. Louis City, Missouri, US | |
2021-09-13 | Mexico | Nayarit | 31207 | 2545 | 0 | 21.7514 | -104.8455 | 2021-09-14 04:21:41 | Nayarit, Mexico | |||
2021-07-19 | Netherlands | Zeeland | 31207 | 249 | 0 | 30894 | 51.47936 | 3.861559 | 2021-07-20 04:21:48 | Zeeland, Netherlands | ||
2021-06-23 | Trinidad and Tobago | 31207 | 768 | 22630 | 7809 | 10.6918 | -61.2225 | 2021-06-24 04:21:55 | Trinidad and Tobago | |||
2021-03-10 | Russia | Ivanovo Oblast | 31207 | 964 | 29405 | 838 | 56.9167446 | 41.43521370000001 | 2021-03-11 05:25:48 | Ivanovo Oblast, Russia | ||
2020-09-28 | US | Tennessee | Shelby | 47157 | 31207 | 460 | 0 | 30574 | 35.1864775 | -89.89692423 | 2020-09-29 04:23:42 | Shelby, Tennessee, US |
2020-08-28 | Serbia | 31207 | 709 | 0 | 30498 | 44.0165 | 21.0059 | 2020-08-29 04:28:19 | Serbia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;