daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where deaths = 15 and province_or_state = "Perak" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-12-13 | Malaysia | Perak | 2460 | 15 | 1911 | 534 | 4.5921 | 101.0901 | 2020-12-14 05:26:27 | Perak, Malaysia | ||
2020-12-12 | Malaysia | Perak | 2355 | 15 | 1882 | 458 | 4.5921 | 101.0901 | 2020-12-13 05:27:20 | Perak, Malaysia | ||
2020-12-11 | Malaysia | Perak | 2293 | 15 | 1841 | 437 | 4.5921 | 101.0901 | 2020-12-12 05:26:19 | Perak, Malaysia | ||
2020-12-10 | Malaysia | Perak | 2281 | 15 | 1801 | 465 | 4.5921 | 101.0901 | 2020-12-11 05:26:59 | Perak, Malaysia | ||
2020-12-09 | Malaysia | Perak | 2166 | 15 | 1756 | 395 | 4.5921 | 101.0901 | 2020-12-10 05:26:19 | Perak, Malaysia | ||
2020-12-08 | Malaysia | Perak | 2133 | 15 | 1708 | 410 | 4.5921 | 101.0901 | 2020-12-09 05:28:01 | Perak, Malaysia | ||
2020-12-07 | Malaysia | Perak | 2104 | 15 | 1608 | 481 | 4.5921 | 101.0901 | 2020-12-08 05:27:42 | Perak, Malaysia | ||
2020-12-06 | Malaysia | Perak | 2050 | 15 | 1575 | 460 | 4.5921 | 101.0901 | 2020-12-07 05:26:14 | Perak, Malaysia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;