daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where country_or_region = "Ukraine" and deaths = 269 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 6
country_or_region 1
- Ukraine · 6 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-01-08 | Ukraine | Kirovohrad Oblast | 8753 | 269 | 4785 | 3699 | 48.5079 | 32.2623 | 2021-01-09 05:22:18 | Kirovohrad Oblast, Ukraine | ||
2020-12-27 | Ukraine | Luhansk Oblast | 9982 | 269 | 6818 | 2895 | 48.574 | 39.3078 | 2020-12-28 05:22:06 | Luhansk Oblast, Ukraine | ||
2020-11-27 | Ukraine | Crimea Republic* | 14686 | 269 | 10908 | 3509 | 45.2835 | 34.2008 | 2020-11-28 05:25:50 | Crimea Republic*, Ukraine | ||
2020-09-16 | Ukraine | Ivano-Frankivsk Oblast | 11677 | 269 | 4891 | 6517 | 48.9226 | 24.7111 | 2020-09-17 04:22:00 | Ivano-Frankivsk Oblast, Ukraine | ||
2020-09-13 | Ukraine | Kiev | 17261 | 269 | 5281 | 11711 | 50.4501 | 30.5234 | 2020-09-14 04:26:00 | Kiev, Ukraine | ||
2020-09-05 | Ukraine | Zakarpattia Oblast | 7988 | 269 | 3489 | 4230 | 48.6208 | 22.2879 | 2020-09-06 04:28:33 | Zakarpattia Oblast, Ukraine |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;