daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where deaths = 44 and province_or_state = "Perak" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-04-27 | Malaysia | Perak | 14469 | 44 | 14011 | 414 | 4.5921 | 101.0901 | 2021-04-28 04:20:32 | Perak, Malaysia | ||
2021-04-26 | Malaysia | Perak | 14431 | 44 | 13967 | 420 | 4.5921 | 101.0901 | 2021-04-27 04:20:52 | Perak, Malaysia | ||
2021-04-25 | Malaysia | Perak | 14386 | 44 | 13929 | 413 | 4.5921 | 101.0901 | 2021-04-26 04:21:04 | Perak, Malaysia | ||
2021-04-24 | Malaysia | Perak | 14322 | 44 | 13878 | 400 | 4.5921 | 101.0901 | 2021-04-25 04:20:32 | Perak, Malaysia | ||
2021-04-23 | Malaysia | Perak | 14268 | 44 | 13845 | 379 | 4.5921 | 101.0901 | 2021-04-24 04:20:38 | Perak, Malaysia | ||
2021-04-22 | Malaysia | Perak | 14223 | 44 | 13794 | 385 | 4.5921 | 101.0901 | 2021-04-23 04:20:52 | Perak, Malaysia | ||
2021-04-21 | Malaysia | Perak | 14174 | 44 | 13752 | 378 | 4.5921 | 101.0901 | 2021-04-22 04:20:53 | Perak, Malaysia | ||
2021-04-20 | Malaysia | Perak | 14136 | 44 | 13726 | 366 | 4.5921 | 101.0901 | 2021-04-21 04:21:14 | Perak, Malaysia | ||
2021-04-19 | Malaysia | Perak | 14102 | 44 | 13680 | 378 | 4.5921 | 101.0901 | 2021-04-20 04:20:41 | Perak, Malaysia | ||
2021-04-18 | Malaysia | Perak | 14059 | 44 | 13643 | 372 | 4.5921 | 101.0901 | 2021-04-19 04:20:57 | Perak, Malaysia | ||
2021-04-17 | Malaysia | Perak | 14024 | 44 | 13611 | 369 | 4.5921 | 101.0901 | 2021-04-18 04:20:41 | Perak, Malaysia | ||
2021-04-16 | Malaysia | Perak | 13982 | 44 | 13278 | 660 | 4.5921 | 101.0901 | 2021-04-17 04:20:40 | Perak, Malaysia | ||
2021-04-15 | Malaysia | Perak | 13933 | 44 | 13078 | 811 | 4.5921 | 101.0901 | 2021-04-16 04:20:46 | Perak, Malaysia | ||
2021-04-14 | Malaysia | Perak | 13882 | 44 | 13061 | 777 | 4.5921 | 101.0901 | 2021-04-15 04:20:54 | Perak, Malaysia | ||
2021-04-13 | Malaysia | Perak | 13826 | 44 | 13003 | 779 | 4.5921 | 101.0901 | 2021-04-14 04:20:41 | Perak, Malaysia | ||
2021-04-12 | Malaysia | Perak | 13790 | 44 | 12989 | 757 | 4.5921 | 101.0901 | 2021-04-13 04:20:37 | Perak, Malaysia | ||
2021-04-11 | Malaysia | Perak | 13769 | 44 | 12972 | 753 | 4.5921 | 101.0901 | 2021-04-12 04:21:00 | Perak, Malaysia | ||
2021-04-10 | Malaysia | Perak | 13719 | 44 | 12946 | 729 | 4.5921 | 101.0901 | 2021-04-11 04:20:56 | Perak, Malaysia | ||
2021-04-09 | Malaysia | Perak | 13673 | 44 | 12912 | 717 | 4.5921 | 101.0901 | 2021-04-10 04:20:59 | Perak, Malaysia | ||
2021-04-08 | Malaysia | Perak | 13644 | 44 | 12893 | 707 | 4.5921 | 101.0901 | 2021-04-09 04:21:13 | Perak, Malaysia | ||
2021-04-07 | Malaysia | Perak | 13620 | 44 | 12839 | 737 | 4.5921 | 101.0901 | 2021-04-08 04:21:13 | Perak, Malaysia | ||
2021-04-06 | Malaysia | Perak | 13596 | 44 | 12830 | 722 | 4.5921 | 101.0901 | 2021-04-07 04:20:53 | Perak, Malaysia | ||
2021-04-05 | Malaysia | Perak | 13535 | 44 | 12818 | 673 | 4.5921 | 101.0901 | 2021-04-06 04:20:32 | Perak, Malaysia | ||
2021-04-04 | Malaysia | Perak | 13527 | 44 | 12799 | 684 | 4.5921 | 101.0901 | 2021-04-05 04:20:35 | Perak, Malaysia | ||
2021-04-03 | Malaysia | Perak | 13503 | 44 | 12796 | 663 | 4.5921 | 101.0901 | 2021-04-04 04:20:49 | Perak, Malaysia | ||
2021-04-02 | Malaysia | Perak | 13009 | 44 | 12723 | 242 | 4.5921 | 101.0901 | 2021-04-03 04:20:44 | Perak, Malaysia | ||
2021-04-01 | Malaysia | Perak | 12995 | 44 | 12639 | 312 | 4.5921 | 101.0901 | 2021-04-02 04:20:36 | Perak, Malaysia | ||
2021-03-31 | Malaysia | Perak | 12964 | 44 | 12563 | 357 | 4.5921 | 101.0901 | 2021-04-01 04:27:05 | Perak, Malaysia | ||
2021-03-30 | Malaysia | Perak | 12933 | 44 | 12535 | 354 | 4.5921 | 101.0901 | 2021-03-31 04:26:25 | Perak, Malaysia | ||
2021-03-29 | Malaysia | Perak | 12889 | 44 | 12520 | 325 | 4.5921 | 101.0901 | 2021-03-30 04:26:23 | Perak, Malaysia | ||
2021-03-28 | Malaysia | Perak | 12884 | 44 | 12497 | 343 | 4.5921 | 101.0901 | 2021-03-29 04:28:35 | Perak, Malaysia | ||
2021-03-27 | Malaysia | Perak | 12861 | 44 | 12435 | 382 | 4.5921 | 101.0901 | 2021-03-28 05:28:10 | Perak, Malaysia | ||
2021-03-26 | Malaysia | Perak | 12852 | 44 | 12404 | 404 | 4.5921 | 101.0901 | 2021-03-27 05:25:04 | Perak, Malaysia | ||
2021-03-25 | Malaysia | Perak | 12824 | 44 | 12363 | 417 | 4.5921 | 101.0901 | 2021-03-26 05:26:55 | Perak, Malaysia | ||
2021-03-24 | Malaysia | Perak | 12753 | 44 | 12336 | 373 | 4.5921 | 101.0901 | 2021-03-25 05:27:00 | Perak, Malaysia | ||
2021-03-23 | Malaysia | Perak | 12711 | 44 | 12266 | 401 | 4.5921 | 101.0901 | 2021-03-24 05:25:40 | Perak, Malaysia | ||
2021-03-22 | Malaysia | Perak | 12707 | 44 | 12232 | 431 | 4.5921 | 101.0901 | 2021-03-23 05:26:18 | Perak, Malaysia | ||
2021-03-21 | Malaysia | Perak | 12668 | 44 | 12199 | 425 | 4.5921 | 101.0901 | 2021-03-22 05:25:43 | Perak, Malaysia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;