johns_hopkins_csse_daily_reports
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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips ▼ | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
343955 | 343955 | 2021-02-03 | Malaysia | Perak | 6488 | 31 | 5081 | 1376 | 4.5921 | 101.0901 | 2021-02-04 05:22:26 | Perak, Malaysia | ||
347945 | 347945 | 2020-09-14 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-09-15 03:22:50 | Perak, Malaysia | ||
348357 | 348357 | 2022-12-14 | Malaysia | Perak | 237921 | 2101 | 0 | 4.5921 | 101.0901 | 2022-12-15 04:20:58 | Perak, Malaysia | |||
355975 | 355975 | 2021-03-11 | Malaysia | Perak | 12123 | 43 | 11480 | 600 | 4.5921 | 101.0901 | 2021-03-12 05:26:50 | Perak, Malaysia | ||
356386 | 356386 | 2022-03-11 | Malaysia | Perak | 166117 | 1612 | 0 | 4.5921 | 101.0901 | 2022-03-12 04:20:50 | Perak, Malaysia | |||
360402 | 360402 | 2022-05-07 | Malaysia | Perak | 201110 | 1915 | 0 | 4.5921 | 101.0901 | 2022-05-08 04:20:49 | Perak, Malaysia | |||
367868 | 367868 | 2020-07-16 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-17 04:34:50 | Perak, Malaysia | ||
371845 | 371845 | 2020-08-08 | Malaysia | Perak | 265 | 6 | 255 | 4 | 4.5921 | 101.0901 | 2020-08-09 04:34:54 | Perak, Malaysia | ||
372257 | 372257 | 2022-09-13 | Malaysia | Perak | 224948 | 2021 | 0 | 4.5921 | 101.0901 | 2022-09-14 04:20:44 | Perak, Malaysia | |||
379858 | 379858 | 2020-11-06 | Malaysia | Perak | 550 | 8 | 481 | 61 | 4.5921 | 101.0901 | 2020-11-07 05:24:52 | Perak, Malaysia | ||
383872 | 383872 | 2021-04-30 | Malaysia | Perak | 14747 | 45 | 14148 | 554 | 4.5921 | 101.0901 | 2021-05-01 04:20:47 | Perak, Malaysia | ||
384284 | 384284 | 2022-09-23 | Malaysia | Perak | 226747 | 2032 | 0 | 4.5921 | 101.0901 | 2022-09-24 04:21:40 | Perak, Malaysia | |||
391902 | 391902 | 2021-04-04 | Malaysia | Perak | 13527 | 44 | 12799 | 684 | 4.5921 | 101.0901 | 2021-04-05 04:20:35 | Perak, Malaysia | ||
395913 | 395913 | 2020-11-27 | Malaysia | Perak | 1496 | 13 | 936 | 547 | 4.5921 | 101.0901 | 2020-11-28 05:25:50 | Perak, Malaysia | ||
396325 | 396325 | 2022-10-07 | Malaysia | Perak | 228742 | 2041 | 0 | 4.5921 | 101.0901 | 2022-10-08 04:22:56 | Perak, Malaysia | |||
403943 | 403943 | 2021-06-29 | Malaysia | Perak | 26489 | 128 | 24535 | 1826 | 4.5921 | 101.0901 | 2021-06-30 04:21:41 | Perak, Malaysia | ||
404353 | 404353 | 2021-12-07 | Malaysia | Perak | 124571 | 1293 | 0 | 4.5921 | 101.0901 | 2021-12-08 04:22:46 | Perak, Malaysia | |||
411973 | 411973 | 2021-07-28 | Malaysia | Perak | 35496 | 189 | 31364 | 3943 | 4.5921 | 101.0901 | 2021-07-29 04:21:33 | Perak, Malaysia | ||
415809 | 415809 | 2020-07-05 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-06 04:33:57 | Perak, Malaysia | ||
415888 | 415888 | 2020-01-26 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 1/26/20 16:00 | ||||
418980 | 418980 | 2020-04-18 | Malaysia | Perak | 251 | 6 | 215 | 30 | 4.5921 | 101.0901 | 2020-04-18 22:32:47 | Perak, Malaysia | ||
419396 | 419396 | 2022-09-18 | Malaysia | Perak | 225834 | 2027 | 0 | 4.5921 | 101.0901 | 2022-09-19 04:21:49 | Perak, Malaysia | |||
423410 | 423410 | 2021-10-10 | Malaysia | Perak | 109119 | 965 | 0 | 4.5921 | 101.0901 | 2021-10-11 04:21:31 | Perak, Malaysia | |||
431006 | 431006 | 2020-09-07 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-09-08 04:28:25 | Perak, Malaysia | ||
431418 | 431418 | 2022-11-03 | Malaysia | Perak | 233406 | 2051 | 0 | 4.5921 | 101.0901 | 2022-11-04 04:22:11 | Perak, Malaysia | |||
439036 | 439036 | 2021-01-21 | Malaysia | Perak | 5029 | 22 | 4094 | 913 | 4.5921 | 101.0901 | 2021-01-22 05:22:10 | Perak, Malaysia | ||
443004 | 443004 | 2020-07-26 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-27 04:35:02 | Perak, Malaysia | ||
443414 | 443414 | 2021-10-20 | Malaysia | Perak | 112850 | 1033 | 0 | 4.5921 | 101.0901 | 2021-10-21 04:21:18 | Perak, Malaysia | |||
447430 | 447430 | 2021-11-17 | Malaysia | Perak | 119917 | 1198 | 0 | 4.5921 | 101.0901 | 2021-11-18 04:21:33 | Perak, Malaysia | |||
451448 | 451448 | 2022-12-21 | Malaysia | Perak | 238203 | 2108 | 0 | 4.5921 | 101.0901 | 2022-12-22 04:20:56 | Perak, Malaysia | |||
459029 | 459029 | 2020-08-07 | Malaysia | Perak | 265 | 6 | 255 | 4 | 4.5921 | 101.0901 | 2020-08-08 04:34:53 | Perak, Malaysia | ||
459439 | 459439 | 2022-02-02 | Malaysia | Perak | 133585 | 1438 | 0 | 4.5921 | 101.0901 | 2022-02-03 04:21:21 | Perak, Malaysia | |||
463456 | 463456 | 2022-05-02 | Malaysia | Perak | 200857 | 1910 | 0 | 4.5921 | 101.0901 | 2022-05-03 04:21:00 | Perak, Malaysia | |||
467471 | 467471 | 2021-10-07 | Malaysia | Perak | 107163 | 950 | 0 | 4.5921 | 101.0901 | 2021-10-08 04:21:25 | Perak, Malaysia | |||
475091 | 475091 | 2021-02-19 | Malaysia | Perak | 7995 | 38 | 6875 | 1082 | 4.5921 | 101.0901 | 2021-02-20 05:22:51 | Perak, Malaysia | ||
475503 | 475503 | 2022-06-26 | Malaysia | Perak | 206481 | 1932 | 0 | 4.5921 | 101.0901 | 2022-06-27 04:21:00 | Perak, Malaysia | |||
479235 | 479235 | 2020-02-25 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-02-25T15:23:04 | ||||
479651 | 479651 | 2022-11-08 | Malaysia | Perak | 234470 | 2057 | 0 | 4.5921 | 101.0901 | 2022-11-09 04:21:22 | Perak, Malaysia | |||
487269 | 487269 | 2021-07-19 | Malaysia | Perak | 31571 | 156 | 28739 | 2676 | 4.5921 | 101.0901 | 2021-07-20 04:21:48 | Perak, Malaysia | ||
487681 | 487681 | 2022-11-25 | Malaysia | Perak | 236509 | 2076 | 0 | 4.5921 | 101.0901 | 2022-11-26 04:21:11 | Perak, Malaysia | |||
491695 | 491695 | 2021-10-14 | Malaysia | Perak | 110683 | 994 | 0 | 4.5921 | 101.0901 | 2021-10-15 04:21:26 | Perak, Malaysia | |||
495711 | 495711 | 2021-11-06 | Malaysia | Perak | 117453 | 1134 | 0 | 4.5921 | 101.0901 | 2021-11-07 04:21:53 | Perak, Malaysia | |||
499728 | 499728 | 2022-04-02 | Malaysia | Perak | 190799 | 1845 | 0 | 4.5921 | 101.0901 | 2022-04-03 04:20:48 | Perak, Malaysia | |||
503745 | 503745 | 2022-12-17 | Malaysia | Perak | 238062 | 2102 | 0 | 4.5921 | 101.0901 | 2022-12-18 04:21:03 | Perak, Malaysia | |||
511363 | 511363 | 2021-08-14 | Malaysia | Perak | 49511 | 319 | 40871 | 8321 | 4.5921 | 101.0901 | 2021-08-15 04:21:41 | Perak, Malaysia | ||
515377 | 515377 | 2021-08-19 | Malaysia | Perak | 54884 | 371 | 44660 | 9853 | 4.5921 | 101.0901 | 2021-08-20 04:21:33 | Perak, Malaysia | ||
515789 | 515789 | 2022-10-15 | Malaysia | Perak | 229811 | 2045 | 0 | 4.5921 | 101.0901 | 2022-10-16 04:22:39 | Perak, Malaysia | |||
522518 | 522518 | 2020-04-21 | Malaysia | Perak | 251 | 6 | 222 | 23 | 4.5921 | 101.0901 | 2020-04-21 23:30:50 | Perak, Malaysia | ||
526536 | 526536 | 2021-06-09 | Malaysia | Perak | 23001 | 109 | 20645 | 2247 | 4.5921 | 101.0901 | 2021-06-10 04:23:17 | Perak, Malaysia | ||
530371 | 530371 | 2020-07-04 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-05 04:33:46 | Perak, Malaysia | ||
534385 | 534385 | 2021-02-22 | Malaysia | Perak | 9466 | 39 | 7160 | 2267 | 4.5921 | 101.0901 | 2021-02-23 05:23:41 | Perak, Malaysia | ||
534795 | 534795 | 2021-10-27 | Malaysia | Perak | 115177 | 1098 | 0 | 4.5921 | 101.0901 | 2021-10-28 04:22:08 | Perak, Malaysia | |||
538813 | 538813 | 2022-10-26 | Malaysia | Perak | 231309 | 2048 | 0 | 4.5921 | 101.0901 | 2022-10-27 04:22:01 | Perak, Malaysia | |||
542829 | 542829 | 2022-12-15 | Malaysia | Perak | 237975 | 2101 | 0 | 4.5921 | 101.0901 | 2022-12-16 04:21:01 | Perak, Malaysia | |||
550423 | 550423 | 2020-09-12 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-09-13 04:30:52 | Perak, Malaysia | ||
550833 | 550833 | 2021-12-08 | Malaysia | Perak | 124754 | 1295 | 0 | 4.5921 | 101.0901 | 2021-12-09 04:22:49 | Perak, Malaysia | |||
554849 | 554849 | 2022-01-16 | Malaysia | Perak | 131167 | 1420 | 0 | 4.5921 | 101.0901 | 2022-01-17 04:21:08 | Perak, Malaysia | |||
558867 | 558867 | 2022-06-16 | Malaysia | Perak | 205340 | 1930 | 0 | 4.5921 | 101.0901 | 2022-06-17 04:20:56 | Perak, Malaysia | |||
562628 | 562628 | 2020-03-01 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-01T10:13:19 | ||||
566646 | 566646 | 2021-06-22 | Malaysia | Perak | 25272 | 120 | 23486 | 1666 | 4.5921 | 101.0901 | 2021-06-23 04:21:46 | Perak, Malaysia | ||
566749 | 566749 | 2020-02-06 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-02-06T23:23:02 | ||||
567163 | 567163 | 2021-10-29 | Malaysia | Perak | 115730 | 1114 | 0 | 4.5921 | 101.0901 | 2021-10-30 04:22:03 | Perak, Malaysia | |||
574477 | 574477 | 2020-06-06 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-07 03:53:30 | Perak, Malaysia | ||
574892 | 574892 | 2022-02-25 | Malaysia | Perak | 146577 | 1496 | 0 | 4.5921 | 101.0901 | 2022-02-26 04:21:12 | Perak, Malaysia | |||
582511 | 582511 | 2021-07-13 | Malaysia | Perak | 29605 | 143 | 27213 | 2249 | 4.5921 | 101.0901 | 2021-07-14 04:21:35 | Perak, Malaysia | ||
586492 | 586492 | 2020-08-13 | Malaysia | Perak | 268 | 6 | 255 | 7 | 4.5921 | 101.0901 | 2020-08-14 04:51:19 | Perak, Malaysia | ||
589289 | 589289 | 2020-04-05 | Malaysia | Perak | 212 | 4 | 68 | 140 | 4.5921 | 101.0901 | 2020-04-05 23:06:45 | Perak, Malaysia | ||
593307 | 593307 | 2021-08-08 | Malaysia | Perak | 43922 | 266 | 36443 | 7213 | 4.5921 | 101.0901 | 2021-08-09 04:21:24 | Perak, Malaysia | ||
593719 | 593719 | 2022-07-01 | Malaysia | Perak | 207192 | 1936 | 0 | 4.5921 | 101.0901 | 2022-07-02 04:21:16 | Perak, Malaysia | |||
597733 | 597733 | 2021-10-19 | Malaysia | Perak | 112457 | 1028 | 0 | 4.5921 | 101.0901 | 2021-10-20 04:21:00 | Perak, Malaysia | |||
601749 | 601749 | 2021-09-23 | Malaysia | Perak | 95686 | 781 | 0 | 4.5921 | 101.0901 | 2021-09-24 04:21:44 | Perak, Malaysia | |||
609368 | 609368 | 2021-04-09 | Malaysia | Perak | 13673 | 44 | 12912 | 717 | 4.5921 | 101.0901 | 2021-04-10 04:20:59 | Perak, Malaysia | ||
613354 | 613354 | 2020-08-29 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-08-30 04:28:22 | Perak, Malaysia | ||
617368 | 617368 | 2021-02-08 | Malaysia | Perak | 6922 | 34 | 5747 | 1141 | 4.5921 | 101.0901 | 2021-02-09 05:23:30 | Perak, Malaysia | ||
617507 | 617507 | 2020-02-27 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-02-27T12:13:14 | ||||
617923 | 617923 | 2022-11-05 | Malaysia | Perak | 234030 | 2051 | 0 | 4.5921 | 101.0901 | 2022-11-06 04:21:24 | Perak, Malaysia | |||
621939 | 621939 | 2022-05-22 | Malaysia | Perak | 203168 | 1921 | 0 | 4.5921 | 101.0901 | 2022-05-26 04:20:50 | Perak, Malaysia | |||
629557 | 629557 | 2021-07-10 | Malaysia | Perak | 28901 | 139 | 26497 | 2265 | 4.5921 | 101.0901 | 2021-07-11 04:21:43 | Perak, Malaysia | ||
629969 | 629969 | 2022-07-12 | Malaysia | Perak | 209605 | 1945 | 0 | 4.5921 | 101.0901 | 2022-07-13 04:20:58 | Perak, Malaysia | |||
633983 | 633983 | 2021-10-13 | Malaysia | Perak | 110274 | 986 | 0 | 4.5921 | 101.0901 | 2021-10-14 04:21:29 | Perak, Malaysia | |||
641603 | 641603 | 2021-03-31 | Malaysia | Perak | 12964 | 44 | 12563 | 357 | 4.5921 | 101.0901 | 2021-04-01 04:27:05 | Perak, Malaysia | ||
645617 | 645617 | 2021-09-07 | Malaysia | Perak | 76155 | 572 | 63401 | 12182 | 4.5921 | 101.0901 | 2021-09-08 04:21:31 | Perak, Malaysia | ||
649631 | 649631 | 2021-05-05 | Malaysia | Perak | 15129 | 49 | 14398 | 682 | 4.5921 | 101.0901 | 2021-05-06 04:20:38 | Perak, Malaysia | ||
653645 | 653645 | 2021-08-09 | Malaysia | Perak | 44857 | 268 | 37255 | 7334 | 4.5921 | 101.0901 | 2021-08-10 04:21:27 | Perak, Malaysia | ||
654055 | 654055 | 2021-10-22 | Malaysia | Perak | 113615 | 1058 | 0 | 4.5921 | 101.0901 | 2021-10-23 04:21:32 | Perak, Malaysia | |||
657959 | 657959 | 2020-03-09 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-09T14:33:03 | ||||
658374 | 658374 | 2022-05-13 | Malaysia | Perak | 202012 | 1919 | 0 | 4.5921 | 101.0901 | 2022-05-14 04:20:48 | Perak, Malaysia | |||
665958 | 665958 | 2020-08-11 | Malaysia | Perak | 268 | 6 | 255 | 7 | 4.5921 | 101.0901 | 2020-08-12 04:27:29 | Perak, Malaysia | ||
669948 | 669948 | 2020-09-16 | Malaysia | Perak | 268 | 6 | 262 | 0 | 4.5921 | 101.0901 | 2020-09-17 04:22:00 | Perak, Malaysia | ||
670360 | 670360 | 2022-07-21 | Malaysia | Perak | 212299 | 1953 | 0 | 4.5921 | 101.0901 | 2022-07-22 04:21:15 | Perak, Malaysia | |||
674376 | 674376 | 2022-07-30 | Malaysia | Perak | 214824 | 1971 | 0 | 4.5921 | 101.0901 | 2022-07-31 04:21:02 | Perak, Malaysia | |||
681990 | 681990 | 2020-11-23 | Malaysia | Perak | 1183 | 13 | 739 | 431 | 4.5921 | 101.0901 | 2020-11-24 05:27:31 | Perak, Malaysia | ||
682400 | 682400 | 2021-10-24 | Malaysia | Perak | 114375 | 1067 | 0 | 4.5921 | 101.0901 | 2021-10-25 04:22:31 | Perak, Malaysia | |||
686416 | 686416 | 2021-11-13 | Malaysia | Perak | 118964 | 1178 | 0 | 4.5921 | 101.0901 | 2021-11-14 04:21:31 | Perak, Malaysia | |||
690434 | 690434 | 2022-12-23 | Malaysia | Perak | 238277 | 2109 | 0 | 4.5921 | 101.0901 | 2022-12-24 04:21:02 | Perak, Malaysia | |||
694449 | 694449 | 2022-03-17 | Malaysia | Perak | 174389 | 1686 | 0 | 4.5921 | 101.0901 | 2022-03-18 04:20:55 | Perak, Malaysia | |||
698464 | 698464 | 2021-11-04 | Malaysia | Perak | 116994 | 1130 | 0 | 4.5921 | 101.0901 | 2021-11-05 04:21:54 | Perak, Malaysia | |||
706084 | 706084 | 2021-03-16 | Malaysia | Perak | 12401 | 43 | 11843 | 515 | 4.5921 | 101.0901 | 2021-03-17 05:25:07 | Perak, Malaysia | ||
706494 | 706494 | 2021-09-29 | Malaysia | Perak | 101314 | 837 | 0 | 4.5921 | 101.0901 | 2021-09-30 04:21:20 | Perak, Malaysia | |||
710511 | 710511 | 2022-11-01 | Malaysia | Perak | 232701 | 2050 | 0 | 4.5921 | 101.0901 | 2022-11-02 04:22:09 | Perak, Malaysia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);