daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 34540 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 14
- Pakistan 2
- Belgium 1
- Netherlands 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-10-21 | US | Maine | Penobscot | 23019 | 34540 | 363 | 0 | 45.40194593 | -68.65020455 | 2022-10-22 04:22:53 | Penobscot, Maine, US | |
2022-07-30 | US | Puerto Rico | Caguas | 72025 | 34540 | 0 | 0 | 18.211615 | -66.050779 | 2022-07-31 04:21:02 | Caguas, Puerto Rico, US | |
2022-02-17 | US | Florida | Charlotte | 12015 | 34540 | 685 | 0 | 26.90131002 | -81.92949121 | 2022-02-18 04:21:04 | Charlotte, Florida, US | |
2022-02-16 | US | Florida | Charlotte | 12015 | 34540 | 685 | 0 | 26.90131002 | -81.92949121 | 2022-02-17 04:20:56 | Charlotte, Florida, US | |
2022-02-15 | US | Florida | Charlotte | 12015 | 34540 | 685 | 0 | 26.90131002 | -81.92949121 | 2022-02-16 04:21:10 | Charlotte, Florida, US | |
2022-02-14 | US | Florida | Charlotte | 12015 | 34540 | 685 | 0 | 26.90131002 | -81.92949121 | 2022-02-15 04:21:09 | Charlotte, Florida, US | |
2022-02-13 | US | Florida | Charlotte | 12015 | 34540 | 684 | 0 | 26.90131002 | -81.92949121 | 2022-02-14 04:20:51 | Charlotte, Florida, US | |
2022-02-12 | US | Florida | Charlotte | 12015 | 34540 | 684 | 0 | 26.90131002 | -81.92949121 | 2022-02-13 04:21:00 | Charlotte, Florida, US | |
2022-02-11 | US | Florida | Charlotte | 12015 | 34540 | 684 | 0 | 26.90131002 | -81.92949121 | 2022-02-12 04:21:06 | Charlotte, Florida, US | |
2021-11-25 | Pakistan | Azad Jammu and Kashmir | 34540 | 742 | 0 | 34.027401 | 73.947253 | 2021-11-26 04:22:33 | Azad Jammu and Kashmir, Pakistan | |||
2021-11-24 | Pakistan | Azad Jammu and Kashmir | 34540 | 742 | 0 | 34.027401 | 73.947253 | 2021-11-25 04:22:33 | Azad Jammu and Kashmir, Pakistan | |||
2021-10-03 | US | North Carolina | Union | 37179 | 34540 | 298 | 0 | 34.98960527 | -80.52955873 | 2021-10-04 04:21:31 | Union, North Carolina, US | |
2021-10-03 | Netherlands | Zeeland | 34540 | 259 | 0 | 51.47936 | 3.8615589999999997 | 2021-10-04 04:21:31 | Zeeland, Netherlands | |||
2021-10-02 | US | North Carolina | Union | 37179 | 34540 | 298 | 0 | 34.98960527 | -80.52955873 | 2021-10-03 04:21:24 | Union, North Carolina, US | |
2021-10-01 | US | North Carolina | Union | 37179 | 34540 | 298 | 0 | 34.98960527 | -80.52955873 | 2021-10-02 04:21:25 | Union, North Carolina, US | |
2021-05-31 | US | Pennsylvania | Westmoreland | 42129 | 34540 | 766 | 0 | 40.31377979999999 | -79.46615476 | 2021-06-01 04:23:09 | Westmoreland, Pennsylvania, US | |
2021-04-27 | US | New Hampshire | Hillsborough | 33011 | 34540 | 617 | 0 | 42.91537785 | -71.7200253 | 2021-04-28 04:20:32 | Hillsborough, New Hampshire, US | |
2020-12-20 | Belgium | Namur | 34540 | 0 | 0 | 34540 | 50.331 | 4.8221 | 2020-12-21 05:27:58 | Namur, Belgium |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;