daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5 rows where confirmed = 34357 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 5 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-03-24 | US | Pennsylvania | Schuylkill | 42107 | 34357 | 671 | 0 | 40.70497338 | -76.2150785 | 2022-03-25 04:20:46 | Schuylkill, Pennsylvania, US | |
2022-02-15 | US | Arkansas | Faulkner | 5045 | 34357 | 282 | 0 | 35.14719007 | -92.33717519 | 2022-02-16 04:21:10 | Faulkner, Arkansas, US | |
2021-04-24 | US | New Hampshire | Hillsborough | 33011 | 34357 | 616 | 0 | 42.91537785 | -71.7200253 | 2021-04-25 04:20:32 | Hillsborough, New Hampshire, US | |
2021-02-11 | US | Louisiana | East Baton Rouge | 22033 | 34357 | 704 | 0 | 33653 | 30.53842039 | -91.09777565 | 2021-02-12 05:23:29 | East Baton Rouge, Louisiana, US |
2020-12-12 | US | Indiana | Lake | 18089 | 34357 | 594 | 0 | 33763 | 41.41874274 | -87.38277575 | 2020-12-13 05:27:20 | Lake, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;