daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4 rows where country_or_region = "Mexico" and deaths = 1486 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state 3
country_or_region 1
- Mexico · 4 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-06-21 | Mexico | Baja California Sur | 36319 | 1486 | 0 | 34833 | 26.0444 | -111.6661 | 2021-06-22 04:21:34 | Baja California Sur, Mexico | ||
2021-06-20 | Mexico | Baja California Sur | 36223 | 1486 | 0 | 34737 | 26.0444 | -111.6661 | 2021-06-21 04:21:41 | Baja California Sur, Mexico | ||
2021-02-12 | Mexico | Nayarit | 10438 | 1486 | 0 | 8952 | 21.7514 | -104.8455 | 2021-02-13 05:22:12 | Nayarit, Mexico | ||
2021-01-14 | Mexico | Aguascalientes | 18161 | 1486 | 0 | 16675 | 21.8853 | -102.2916 | 2021-01-15 05:22:24 | Aguascalientes, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;