daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where deaths = 7 and province_or_state = "Perak" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-11-03 | Malaysia | Perak | 520 | 7 | 452 | 61 | 4.5921 | 101.0901 | 2020-11-04 05:25:09 | Perak, Malaysia | ||
2020-11-02 | Malaysia | Perak | 517 | 7 | 445 | 65 | 4.5921 | 101.0901 | 2020-11-03 06:00:16 | Perak, Malaysia | ||
2020-11-01 | Malaysia | Perak | 515 | 7 | 436 | 72 | 4.5921 | 101.0901 | 2020-11-02 05:25:04 | Perak, Malaysia | ||
2020-10-31 | Malaysia | Perak | 510 | 7 | 426 | 77 | 4.5921 | 101.0901 | 2020-11-01 04:36:19 | Perak, Malaysia | ||
2020-10-30 | Malaysia | Perak | 504 | 7 | 426 | 71 | 4.5921 | 101.0901 | 2020-10-31 04:24:44 | Perak, Malaysia | ||
2020-10-29 | Malaysia | Perak | 494 | 7 | 404 | 83 | 4.5921 | 101.0901 | 2020-10-30 04:24:49 | Perak, Malaysia | ||
2020-10-28 | Malaysia | Perak | 489 | 7 | 404 | 78 | 4.5921 | 101.0901 | 2020-10-29 04:24:49 | Perak, Malaysia | ||
2020-10-27 | Malaysia | Perak | 483 | 7 | 381 | 95 | 4.5921 | 101.0901 | 2020-10-28 04:24:39 | Perak, Malaysia | ||
2020-10-26 | Malaysia | Perak | 472 | 7 | 381 | 84 | 4.5921 | 101.0901 | 2020-10-27 04:24:45 | Perak, Malaysia | ||
2020-10-25 | Malaysia | Perak | 464 | 7 | 378 | 79 | 4.5921 | 101.0901 | 2020-10-26 04:25:02 | Perak, Malaysia | ||
2020-10-24 | Malaysia | Perak | 458 | 7 | 363 | 88 | 4.5921 | 101.0901 | 2020-10-25 04:24:36 | Perak, Malaysia | ||
2020-10-23 | Malaysia | Perak | 448 | 7 | 302 | 139 | 4.5921 | 101.0901 | 2020-10-24 04:24:46 | Perak, Malaysia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;