daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "Malaysia" and province_or_state = "Perak" sorted by country_or_region
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region ▼ | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-16 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-17 04:34:50 | Perak, Malaysia | ||
2020-08-08 | Malaysia | Perak | 265 | 6 | 255 | 4 | 4.5921 | 101.0901 | 2020-08-09 04:34:54 | Perak, Malaysia | ||
2022-09-13 | Malaysia | Perak | 224948 | 2021 | 0 | 4.5921 | 101.0901 | 2022-09-14 04:20:44 | Perak, Malaysia | |||
2020-11-06 | Malaysia | Perak | 550 | 8 | 481 | 61 | 4.5921 | 101.0901 | 2020-11-07 05:24:52 | Perak, Malaysia | ||
2021-04-30 | Malaysia | Perak | 14747 | 45 | 14148 | 554 | 4.5921 | 101.0901 | 2021-05-01 04:20:47 | Perak, Malaysia | ||
2022-09-23 | Malaysia | Perak | 226747 | 2032 | 0 | 4.5921 | 101.0901 | 2022-09-24 04:21:40 | Perak, Malaysia | |||
2021-04-04 | Malaysia | Perak | 13527 | 44 | 12799 | 684 | 4.5921 | 101.0901 | 2021-04-05 04:20:35 | Perak, Malaysia | ||
2020-11-27 | Malaysia | Perak | 1496 | 13 | 936 | 547 | 4.5921 | 101.0901 | 2020-11-28 05:25:50 | Perak, Malaysia | ||
2022-10-07 | Malaysia | Perak | 228742 | 2041 | 0 | 4.5921 | 101.0901 | 2022-10-08 04:22:56 | Perak, Malaysia | |||
2021-06-29 | Malaysia | Perak | 26489 | 128 | 24535 | 1826 | 4.5921 | 101.0901 | 2021-06-30 04:21:41 | Perak, Malaysia | ||
2021-12-07 | Malaysia | Perak | 124571 | 1293 | 0 | 4.5921 | 101.0901 | 2021-12-08 04:22:46 | Perak, Malaysia | |||
2021-07-28 | Malaysia | Perak | 35496 | 189 | 31364 | 3943 | 4.5921 | 101.0901 | 2021-07-29 04:21:33 | Perak, Malaysia | ||
2020-07-05 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-06 04:33:57 | Perak, Malaysia | ||
2020-01-26 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 1/26/20 16:00 | ||||
2020-04-18 | Malaysia | Perak | 251 | 6 | 215 | 30 | 4.5921 | 101.0901 | 2020-04-18 22:32:47 | Perak, Malaysia | ||
2022-09-18 | Malaysia | Perak | 225834 | 2027 | 0 | 4.5921 | 101.0901 | 2022-09-19 04:21:49 | Perak, Malaysia | |||
2021-10-10 | Malaysia | Perak | 109119 | 965 | 0 | 4.5921 | 101.0901 | 2021-10-11 04:21:31 | Perak, Malaysia | |||
2020-09-07 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-09-08 04:28:25 | Perak, Malaysia | ||
2022-11-03 | Malaysia | Perak | 233406 | 2051 | 0 | 4.5921 | 101.0901 | 2022-11-04 04:22:11 | Perak, Malaysia | |||
2021-01-21 | Malaysia | Perak | 5029 | 22 | 4094 | 913 | 4.5921 | 101.0901 | 2021-01-22 05:22:10 | Perak, Malaysia | ||
2020-07-26 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-27 04:35:02 | Perak, Malaysia | ||
2021-10-20 | Malaysia | Perak | 112850 | 1033 | 0 | 4.5921 | 101.0901 | 2021-10-21 04:21:18 | Perak, Malaysia | |||
2021-11-17 | Malaysia | Perak | 119917 | 1198 | 0 | 4.5921 | 101.0901 | 2021-11-18 04:21:33 | Perak, Malaysia | |||
2022-12-21 | Malaysia | Perak | 238203 | 2108 | 0 | 4.5921 | 101.0901 | 2022-12-22 04:20:56 | Perak, Malaysia | |||
2020-08-07 | Malaysia | Perak | 265 | 6 | 255 | 4 | 4.5921 | 101.0901 | 2020-08-08 04:34:53 | Perak, Malaysia | ||
2022-02-02 | Malaysia | Perak | 133585 | 1438 | 0 | 4.5921 | 101.0901 | 2022-02-03 04:21:21 | Perak, Malaysia | |||
2022-05-02 | Malaysia | Perak | 200857 | 1910 | 0 | 4.5921 | 101.0901 | 2022-05-03 04:21:00 | Perak, Malaysia | |||
2021-10-07 | Malaysia | Perak | 107163 | 950 | 0 | 4.5921 | 101.0901 | 2021-10-08 04:21:25 | Perak, Malaysia | |||
2021-02-19 | Malaysia | Perak | 7995 | 38 | 6875 | 1082 | 4.5921 | 101.0901 | 2021-02-20 05:22:51 | Perak, Malaysia | ||
2022-06-26 | Malaysia | Perak | 206481 | 1932 | 0 | 4.5921 | 101.0901 | 2022-06-27 04:21:00 | Perak, Malaysia | |||
2020-02-25 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-02-25T15:23:04 | ||||
2022-11-08 | Malaysia | Perak | 234470 | 2057 | 0 | 4.5921 | 101.0901 | 2022-11-09 04:21:22 | Perak, Malaysia | |||
2021-07-19 | Malaysia | Perak | 31571 | 156 | 28739 | 2676 | 4.5921 | 101.0901 | 2021-07-20 04:21:48 | Perak, Malaysia | ||
2022-11-25 | Malaysia | Perak | 236509 | 2076 | 0 | 4.5921 | 101.0901 | 2022-11-26 04:21:11 | Perak, Malaysia | |||
2021-10-14 | Malaysia | Perak | 110683 | 994 | 0 | 4.5921 | 101.0901 | 2021-10-15 04:21:26 | Perak, Malaysia | |||
2021-11-06 | Malaysia | Perak | 117453 | 1134 | 0 | 4.5921 | 101.0901 | 2021-11-07 04:21:53 | Perak, Malaysia | |||
2022-04-02 | Malaysia | Perak | 190799 | 1845 | 0 | 4.5921 | 101.0901 | 2022-04-03 04:20:48 | Perak, Malaysia | |||
2022-12-17 | Malaysia | Perak | 238062 | 2102 | 0 | 4.5921 | 101.0901 | 2022-12-18 04:21:03 | Perak, Malaysia | |||
2021-08-14 | Malaysia | Perak | 49511 | 319 | 40871 | 8321 | 4.5921 | 101.0901 | 2021-08-15 04:21:41 | Perak, Malaysia | ||
2021-08-19 | Malaysia | Perak | 54884 | 371 | 44660 | 9853 | 4.5921 | 101.0901 | 2021-08-20 04:21:33 | Perak, Malaysia | ||
2022-10-15 | Malaysia | Perak | 229811 | 2045 | 0 | 4.5921 | 101.0901 | 2022-10-16 04:22:39 | Perak, Malaysia | |||
2020-04-21 | Malaysia | Perak | 251 | 6 | 222 | 23 | 4.5921 | 101.0901 | 2020-04-21 23:30:50 | Perak, Malaysia | ||
2021-06-09 | Malaysia | Perak | 23001 | 109 | 20645 | 2247 | 4.5921 | 101.0901 | 2021-06-10 04:23:17 | Perak, Malaysia | ||
2020-07-04 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-05 04:33:46 | Perak, Malaysia | ||
2021-02-22 | Malaysia | Perak | 9466 | 39 | 7160 | 2267 | 4.5921 | 101.0901 | 2021-02-23 05:23:41 | Perak, Malaysia | ||
2021-10-27 | Malaysia | Perak | 115177 | 1098 | 0 | 4.5921 | 101.0901 | 2021-10-28 04:22:08 | Perak, Malaysia | |||
2022-10-26 | Malaysia | Perak | 231309 | 2048 | 0 | 4.5921 | 101.0901 | 2022-10-27 04:22:01 | Perak, Malaysia | |||
2022-12-15 | Malaysia | Perak | 237975 | 2101 | 0 | 4.5921 | 101.0901 | 2022-12-16 04:21:01 | Perak, Malaysia | |||
2020-09-12 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-09-13 04:30:52 | Perak, Malaysia | ||
2021-12-08 | Malaysia | Perak | 124754 | 1295 | 0 | 4.5921 | 101.0901 | 2021-12-09 04:22:49 | Perak, Malaysia | |||
2022-01-16 | Malaysia | Perak | 131167 | 1420 | 0 | 4.5921 | 101.0901 | 2022-01-17 04:21:08 | Perak, Malaysia | |||
2022-06-16 | Malaysia | Perak | 205340 | 1930 | 0 | 4.5921 | 101.0901 | 2022-06-17 04:20:56 | Perak, Malaysia | |||
2020-03-01 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-01T10:13:19 | ||||
2021-06-22 | Malaysia | Perak | 25272 | 120 | 23486 | 1666 | 4.5921 | 101.0901 | 2021-06-23 04:21:46 | Perak, Malaysia | ||
2020-02-06 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-02-06T23:23:02 | ||||
2021-10-29 | Malaysia | Perak | 115730 | 1114 | 0 | 4.5921 | 101.0901 | 2021-10-30 04:22:03 | Perak, Malaysia | |||
2020-06-06 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-07 03:53:30 | Perak, Malaysia | ||
2022-02-25 | Malaysia | Perak | 146577 | 1496 | 0 | 4.5921 | 101.0901 | 2022-02-26 04:21:12 | Perak, Malaysia | |||
2021-07-13 | Malaysia | Perak | 29605 | 143 | 27213 | 2249 | 4.5921 | 101.0901 | 2021-07-14 04:21:35 | Perak, Malaysia | ||
2020-08-13 | Malaysia | Perak | 268 | 6 | 255 | 7 | 4.5921 | 101.0901 | 2020-08-14 04:51:19 | Perak, Malaysia | ||
2020-04-05 | Malaysia | Perak | 212 | 4 | 68 | 140 | 4.5921 | 101.0901 | 2020-04-05 23:06:45 | Perak, Malaysia | ||
2021-08-08 | Malaysia | Perak | 43922 | 266 | 36443 | 7213 | 4.5921 | 101.0901 | 2021-08-09 04:21:24 | Perak, Malaysia | ||
2022-07-01 | Malaysia | Perak | 207192 | 1936 | 0 | 4.5921 | 101.0901 | 2022-07-02 04:21:16 | Perak, Malaysia | |||
2021-10-19 | Malaysia | Perak | 112457 | 1028 | 0 | 4.5921 | 101.0901 | 2021-10-20 04:21:00 | Perak, Malaysia | |||
2021-09-23 | Malaysia | Perak | 95686 | 781 | 0 | 4.5921 | 101.0901 | 2021-09-24 04:21:44 | Perak, Malaysia | |||
2021-04-09 | Malaysia | Perak | 13673 | 44 | 12912 | 717 | 4.5921 | 101.0901 | 2021-04-10 04:20:59 | Perak, Malaysia | ||
2020-08-29 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-08-30 04:28:22 | Perak, Malaysia | ||
2021-02-08 | Malaysia | Perak | 6922 | 34 | 5747 | 1141 | 4.5921 | 101.0901 | 2021-02-09 05:23:30 | Perak, Malaysia | ||
2020-02-27 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-02-27T12:13:14 | ||||
2022-11-05 | Malaysia | Perak | 234030 | 2051 | 0 | 4.5921 | 101.0901 | 2022-11-06 04:21:24 | Perak, Malaysia | |||
2022-05-22 | Malaysia | Perak | 203168 | 1921 | 0 | 4.5921 | 101.0901 | 2022-05-26 04:20:50 | Perak, Malaysia | |||
2021-07-10 | Malaysia | Perak | 28901 | 139 | 26497 | 2265 | 4.5921 | 101.0901 | 2021-07-11 04:21:43 | Perak, Malaysia | ||
2022-07-12 | Malaysia | Perak | 209605 | 1945 | 0 | 4.5921 | 101.0901 | 2022-07-13 04:20:58 | Perak, Malaysia | |||
2021-10-13 | Malaysia | Perak | 110274 | 986 | 0 | 4.5921 | 101.0901 | 2021-10-14 04:21:29 | Perak, Malaysia | |||
2021-03-31 | Malaysia | Perak | 12964 | 44 | 12563 | 357 | 4.5921 | 101.0901 | 2021-04-01 04:27:05 | Perak, Malaysia | ||
2021-09-07 | Malaysia | Perak | 76155 | 572 | 63401 | 12182 | 4.5921 | 101.0901 | 2021-09-08 04:21:31 | Perak, Malaysia | ||
2021-05-05 | Malaysia | Perak | 15129 | 49 | 14398 | 682 | 4.5921 | 101.0901 | 2021-05-06 04:20:38 | Perak, Malaysia | ||
2021-08-09 | Malaysia | Perak | 44857 | 268 | 37255 | 7334 | 4.5921 | 101.0901 | 2021-08-10 04:21:27 | Perak, Malaysia | ||
2021-10-22 | Malaysia | Perak | 113615 | 1058 | 0 | 4.5921 | 101.0901 | 2021-10-23 04:21:32 | Perak, Malaysia | |||
2020-03-09 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-09T14:33:03 | ||||
2022-05-13 | Malaysia | Perak | 202012 | 1919 | 0 | 4.5921 | 101.0901 | 2022-05-14 04:20:48 | Perak, Malaysia | |||
2020-08-11 | Malaysia | Perak | 268 | 6 | 255 | 7 | 4.5921 | 101.0901 | 2020-08-12 04:27:29 | Perak, Malaysia | ||
2020-09-16 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-09-17 04:22:00 | Perak, Malaysia | ||
2022-07-21 | Malaysia | Perak | 212299 | 1953 | 0 | 4.5921 | 101.0901 | 2022-07-22 04:21:15 | Perak, Malaysia | |||
2022-07-30 | Malaysia | Perak | 214824 | 1971 | 0 | 4.5921 | 101.0901 | 2022-07-31 04:21:02 | Perak, Malaysia | |||
2020-11-23 | Malaysia | Perak | 1183 | 13 | 739 | 431 | 4.5921 | 101.0901 | 2020-11-24 05:27:31 | Perak, Malaysia | ||
2021-10-24 | Malaysia | Perak | 114375 | 1067 | 0 | 4.5921 | 101.0901 | 2021-10-25 04:22:31 | Perak, Malaysia | |||
2021-11-13 | Malaysia | Perak | 118964 | 1178 | 0 | 4.5921 | 101.0901 | 2021-11-14 04:21:31 | Perak, Malaysia | |||
2022-12-23 | Malaysia | Perak | 238277 | 2109 | 0 | 4.5921 | 101.0901 | 2022-12-24 04:21:02 | Perak, Malaysia | |||
2022-03-17 | Malaysia | Perak | 174389 | 1686 | 0 | 4.5921 | 101.0901 | 2022-03-18 04:20:55 | Perak, Malaysia | |||
2021-11-04 | Malaysia | Perak | 116994 | 1130 | 0 | 4.5921 | 101.0901 | 2021-11-05 04:21:54 | Perak, Malaysia | |||
2021-03-16 | Malaysia | Perak | 12401 | 43 | 11843 | 515 | 4.5921 | 101.0901 | 2021-03-17 05:25:07 | Perak, Malaysia | ||
2021-09-29 | Malaysia | Perak | 101314 | 837 | 0 | 4.5921 | 101.0901 | 2021-09-30 04:21:20 | Perak, Malaysia | |||
2022-11-01 | Malaysia | Perak | 232701 | 2050 | 0 | 4.5921 | 101.0901 | 2022-11-02 04:22:09 | Perak, Malaysia | |||
2021-11-12 | Malaysia | Perak | 118697 | 1173 | 0 | 4.5921 | 101.0901 | 2021-11-13 04:21:38 | Perak, Malaysia | |||
2022-12-04 | Malaysia | Perak | 237317 | 2089 | 0 | 4.5921 | 101.0901 | 2022-12-05 04:20:58 | Perak, Malaysia | |||
2021-11-20 | Malaysia | Perak | 120742 | 1207 | 0 | 4.5921 | 101.0901 | 2021-11-21 04:22:13 | Perak, Malaysia | |||
2021-05-22 | Malaysia | Perak | 18268 | 74 | 16318 | 1876 | 4.5921 | 101.0901 | 2021-05-23 04:20:51 | Perak, Malaysia | ||
2021-12-27 | Malaysia | Perak | 128365 | 1378 | 0 | 4.5921 | 101.0901 | 2021-12-28 04:21:47 | Perak, Malaysia | |||
2020-06-12 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-13 03:33:14 | Perak, Malaysia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;