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 = "Melaka" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
343952 | 343952 | 2021-02-03 | Malaysia | Melaka | 3770 | 13 | 2507 | 1250 | 2.1896 | 102.2501 | 2021-02-04 05:22:26 | Melaka, Malaysia | ||
347942 | 347942 | 2020-09-14 | Malaysia | Melaka | 257 | 6 | 249 | 2 | 2.1896 | 102.2501 | 2020-09-15 03:22:50 | Melaka, Malaysia | ||
348354 | 348354 | 2022-12-14 | Malaysia | Melaka | 143411 | 1198 | 0 | 2.1896 | 102.2501 | 2022-12-15 04:20:58 | Melaka, Malaysia | |||
355972 | 355972 | 2021-03-11 | Malaysia | Melaka | 6137 | 22 | 5960 | 155 | 2.1896 | 102.2501 | 2021-03-12 05:26:50 | Melaka, Malaysia | ||
356383 | 356383 | 2022-03-11 | Malaysia | Melaka | 105694 | 1030 | 0 | 2.1896 | 102.2501 | 2022-03-12 04:20:50 | Melaka, Malaysia | |||
360399 | 360399 | 2022-05-07 | Malaysia | Melaka | 122368 | 1118 | 0 | 2.1896 | 102.2501 | 2022-05-08 04:20:49 | Melaka, Malaysia | |||
367865 | 367865 | 2020-07-16 | Malaysia | Melaka | 253 | 6 | 246 | 1 | 2.1896 | 102.2501 | 2020-07-17 04:34:50 | Melaka, Malaysia | ||
371842 | 371842 | 2020-08-08 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-09 04:34:54 | Melaka, Malaysia | ||
372254 | 372254 | 2022-09-13 | Malaysia | Melaka | 134180 | 1183 | 0 | 2.1896 | 102.2501 | 2022-09-14 04:20:44 | Melaka, Malaysia | |||
379855 | 379855 | 2020-11-06 | Malaysia | Melaka | 315 | 6 | 300 | 9 | 2.1896 | 102.2501 | 2020-11-07 05:24:52 | Melaka, Malaysia | ||
383869 | 383869 | 2021-04-30 | Malaysia | Melaka | 7369 | 22 | 7003 | 344 | 2.1896 | 102.2501 | 2021-05-01 04:20:47 | Melaka, Malaysia | ||
384281 | 384281 | 2022-09-23 | Malaysia | Melaka | 134928 | 1184 | 0 | 2.1896 | 102.2501 | 2022-09-24 04:21:40 | Melaka, Malaysia | |||
391899 | 391899 | 2021-04-04 | Malaysia | Melaka | 6603 | 22 | 6300 | 281 | 2.1896 | 102.2501 | 2021-04-05 04:20:35 | Melaka, Malaysia | ||
395910 | 395910 | 2020-11-27 | Malaysia | Melaka | 380 | 6 | 360 | 14 | 2.1896 | 102.2501 | 2020-11-28 05:25:50 | Melaka, Malaysia | ||
396322 | 396322 | 2022-10-07 | Malaysia | Melaka | 135729 | 1184 | 0 | 2.1896 | 102.2501 | 2022-10-08 04:22:56 | Melaka, Malaysia | |||
403940 | 403940 | 2021-06-29 | Malaysia | Melaka | 18187 | 144 | 15375 | 2668 | 2.1896 | 102.2501 | 2021-06-30 04:21:41 | Melaka, Malaysia | ||
404350 | 404350 | 2021-12-07 | Malaysia | Melaka | 72561 | 943 | 0 | 2.1896 | 102.2501 | 2021-12-08 04:22:46 | Melaka, Malaysia | |||
411970 | 411970 | 2021-07-28 | Malaysia | Melaka | 29667 | 354 | 23847 | 5466 | 2.1896 | 102.2501 | 2021-07-29 04:21:33 | Melaka, Malaysia | ||
415806 | 415806 | 2020-07-05 | Malaysia | Melaka | 251 | 6 | 245 | 0 | 2.1896 | 102.2501 | 2020-07-06 04:33:57 | Melaka, Malaysia | ||
415885 | 415885 | 2020-01-26 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 1/26/20 16:00 | ||||
418977 | 418977 | 2020-04-18 | Malaysia | Melaka | 144 | 5 | 49 | 90 | 2.1896 | 102.2501 | 2020-04-18 22:32:47 | Melaka, Malaysia | ||
419393 | 419393 | 2022-09-18 | Malaysia | Melaka | 134569 | 1184 | 0 | 2.1896 | 102.2501 | 2022-09-19 04:21:49 | Melaka, Malaysia | |||
423407 | 423407 | 2021-10-10 | Malaysia | Melaka | 60806 | 867 | 0 | 2.1896 | 102.2501 | 2021-10-11 04:21:31 | Melaka, Malaysia | |||
431003 | 431003 | 2020-09-07 | Malaysia | Melaka | 257 | 6 | 249 | 2 | 2.1896 | 102.2501 | 2020-09-08 04:28:25 | Melaka, Malaysia | ||
431415 | 431415 | 2022-11-03 | Malaysia | Melaka | 137438 | 1188 | 0 | 2.1896 | 102.2501 | 2022-11-04 04:22:11 | Melaka, Malaysia | |||
439033 | 439033 | 2021-01-21 | Malaysia | Melaka | 2471 | 7 | 1566 | 898 | 2.1896 | 102.2501 | 2021-01-22 05:22:10 | Melaka, Malaysia | ||
443001 | 443001 | 2020-07-26 | Malaysia | Melaka | 253 | 6 | 247 | 0 | 2.1896 | 102.2501 | 2020-07-27 04:35:02 | Melaka, Malaysia | ||
443411 | 443411 | 2021-10-20 | Malaysia | Melaka | 62879 | 890 | 0 | 2.1896 | 102.2501 | 2021-10-21 04:21:18 | Melaka, Malaysia | |||
447427 | 447427 | 2021-11-17 | Malaysia | Melaka | 68437 | 920 | 0 | 2.1896 | 102.2501 | 2021-11-18 04:21:33 | Melaka, Malaysia | |||
451445 | 451445 | 2022-12-21 | Malaysia | Melaka | 143838 | 1198 | 0 | 2.1896 | 102.2501 | 2022-12-22 04:20:56 | Melaka, Malaysia | |||
459026 | 459026 | 2020-08-07 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-08 04:34:53 | Melaka, Malaysia | ||
459436 | 459436 | 2022-02-02 | Malaysia | Melaka | 82200 | 973 | 0 | 2.1896 | 102.2501 | 2022-02-03 04:21:21 | Melaka, Malaysia | |||
463453 | 463453 | 2022-05-02 | Malaysia | Melaka | 122127 | 1118 | 0 | 2.1896 | 102.2501 | 2022-05-03 04:21:00 | Melaka, Malaysia | |||
467468 | 467468 | 2021-10-07 | Malaysia | Melaka | 60070 | 863 | 0 | 2.1896 | 102.2501 | 2021-10-08 04:21:25 | Melaka, Malaysia | |||
475088 | 475088 | 2021-02-19 | Malaysia | Melaka | 5749 | 19 | 5015 | 715 | 2.1896 | 102.2501 | 2021-02-20 05:22:51 | Melaka, Malaysia | ||
475500 | 475500 | 2022-06-26 | Malaysia | Melaka | 125767 | 1131 | 0 | 2.1896 | 102.2501 | 2022-06-27 04:21:00 | Melaka, Malaysia | |||
479232 | 479232 | 2020-02-25 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-02-25T15:23:04 | ||||
479648 | 479648 | 2022-11-08 | Malaysia | Melaka | 138240 | 1188 | 0 | 2.1896 | 102.2501 | 2022-11-09 04:21:22 | Melaka, Malaysia | |||
487266 | 487266 | 2021-07-19 | Malaysia | Melaka | 25521 | 255 | 20165 | 5101 | 2.1896 | 102.2501 | 2021-07-20 04:21:48 | Melaka, Malaysia | ||
487678 | 487678 | 2022-11-25 | Malaysia | Melaka | 141269 | 1190 | 0 | 2.1896 | 102.2501 | 2022-11-26 04:21:11 | Melaka, Malaysia | |||
491692 | 491692 | 2021-10-14 | Malaysia | Melaka | 61632 | 875 | 0 | 2.1896 | 102.2501 | 2021-10-15 04:21:26 | Melaka, Malaysia | |||
495708 | 495708 | 2021-11-06 | Malaysia | Melaka | 66508 | 907 | 0 | 2.1896 | 102.2501 | 2021-11-07 04:21:53 | Melaka, Malaysia | |||
499725 | 499725 | 2022-04-02 | Malaysia | Melaka | 117277 | 1092 | 0 | 2.1896 | 102.2501 | 2022-04-03 04:20:48 | Melaka, Malaysia | |||
503742 | 503742 | 2022-12-17 | Malaysia | Melaka | 143644 | 1198 | 0 | 2.1896 | 102.2501 | 2022-12-18 04:21:03 | Melaka, Malaysia | |||
511360 | 511360 | 2021-08-14 | Malaysia | Melaka | 38891 | 528 | 31696 | 6667 | 2.1896 | 102.2501 | 2021-08-15 04:21:41 | Melaka, Malaysia | ||
515374 | 515374 | 2021-08-19 | Malaysia | Melaka | 42581 | 584 | 34286 | 7711 | 2.1896 | 102.2501 | 2021-08-20 04:21:33 | Melaka, Malaysia | ||
515786 | 515786 | 2022-10-15 | Malaysia | Melaka | 136125 | 1186 | 0 | 2.1896 | 102.2501 | 2022-10-16 04:22:39 | Melaka, Malaysia | |||
522515 | 522515 | 2020-04-21 | Malaysia | Melaka | 184 | 5 | 70 | 109 | 2.1896 | 102.2501 | 2020-04-21 23:30:50 | Melaka, Malaysia | ||
526533 | 526533 | 2021-06-09 | Malaysia | Melaka | 14168 | 98 | 10580 | 3490 | 2.1896 | 102.2501 | 2021-06-10 04:23:17 | Melaka, Malaysia | ||
530368 | 530368 | 2020-07-04 | Malaysia | Melaka | 251 | 6 | 245 | 0 | 2.1896 | 102.2501 | 2020-07-05 04:33:46 | Melaka, Malaysia | ||
534382 | 534382 | 2021-02-22 | Malaysia | Melaka | 5860 | 19 | 5382 | 459 | 2.1896 | 102.2501 | 2021-02-23 05:23:41 | Melaka, Malaysia | ||
534792 | 534792 | 2021-10-27 | Malaysia | Melaka | 64368 | 898 | 0 | 2.1896 | 102.2501 | 2021-10-28 04:22:08 | Melaka, Malaysia | |||
538810 | 538810 | 2022-10-26 | Malaysia | Melaka | 136691 | 1188 | 0 | 2.1896 | 102.2501 | 2022-10-27 04:22:01 | Melaka, Malaysia | |||
542826 | 542826 | 2022-12-15 | Malaysia | Melaka | 143493 | 1198 | 0 | 2.1896 | 102.2501 | 2022-12-16 04:21:01 | Melaka, Malaysia | |||
550420 | 550420 | 2020-09-12 | Malaysia | Melaka | 257 | 6 | 249 | 2 | 2.1896 | 102.2501 | 2020-09-13 04:30:52 | Melaka, Malaysia | ||
550830 | 550830 | 2021-12-08 | Malaysia | Melaka | 72690 | 944 | 0 | 2.1896 | 102.2501 | 2021-12-09 04:22:49 | Melaka, Malaysia | |||
554846 | 554846 | 2022-01-16 | Malaysia | Melaka | 78661 | 964 | 0 | 2.1896 | 102.2501 | 2022-01-17 04:21:08 | Melaka, Malaysia | |||
558864 | 558864 | 2022-06-16 | Malaysia | Melaka | 125147 | 1129 | 0 | 2.1896 | 102.2501 | 2022-06-17 04:20:56 | Melaka, Malaysia | |||
562625 | 562625 | 2020-03-01 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-03-01T10:13:19 | ||||
566643 | 566643 | 2021-06-22 | Malaysia | Melaka | 16367 | 123 | 14548 | 1696 | 2.1896 | 102.2501 | 2021-06-23 04:21:46 | Melaka, Malaysia | ||
566746 | 566746 | 2020-02-06 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-02-06T23:23:02 | ||||
567160 | 567160 | 2021-10-29 | Malaysia | Melaka | 64885 | 900 | 0 | 2.1896 | 102.2501 | 2021-10-30 04:22:03 | Melaka, Malaysia | |||
574474 | 574474 | 2020-06-06 | Malaysia | Melaka | 229 | 6 | 196 | 27 | 2.1896 | 102.2501 | 2020-06-07 03:53:30 | Melaka, Malaysia | ||
574889 | 574889 | 2022-02-25 | Malaysia | Melaka | 95452 | 995 | 0 | 2.1896 | 102.2501 | 2022-02-26 04:21:12 | Melaka, Malaysia | |||
582508 | 582508 | 2021-07-13 | Malaysia | Melaka | 22604 | 218 | 18344 | 4042 | 2.1896 | 102.2501 | 2021-07-14 04:21:35 | Melaka, Malaysia | ||
586489 | 586489 | 2020-08-13 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-14 04:51:19 | Melaka, Malaysia | ||
589286 | 589286 | 2020-04-05 | Malaysia | Melaka | 85 | 2 | 0 | 83 | 2.1896 | 102.2501 | 2020-04-05 23:06:45 | Melaka, Malaysia | ||
593304 | 593304 | 2021-08-08 | Malaysia | Melaka | 35579 | 477 | 28162 | 6940 | 2.1896 | 102.2501 | 2021-08-09 04:21:24 | Melaka, Malaysia | ||
593716 | 593716 | 2022-07-01 | Malaysia | Melaka | 126184 | 1133 | 0 | 2.1896 | 102.2501 | 2022-07-02 04:21:16 | Melaka, Malaysia | |||
597730 | 597730 | 2021-10-19 | Malaysia | Melaka | 62767 | 888 | 0 | 2.1896 | 102.2501 | 2021-10-20 04:21:00 | Melaka, Malaysia | |||
601746 | 601746 | 2021-09-23 | Malaysia | Melaka | 56020 | 831 | 0 | 2.1896 | 102.2501 | 2021-09-24 04:21:44 | Melaka, Malaysia | |||
609365 | 609365 | 2021-04-09 | Malaysia | Melaka | 6693 | 22 | 6451 | 220 | 2.1896 | 102.2501 | 2021-04-10 04:20:59 | Melaka, Malaysia | ||
613351 | 613351 | 2020-08-29 | Malaysia | Melaka | 257 | 6 | 249 | 2 | 2.1896 | 102.2501 | 2020-08-30 04:28:22 | Melaka, Malaysia | ||
617365 | 617365 | 2021-02-08 | Malaysia | Melaka | 5135 | 17 | 3146 | 1972 | 2.1896 | 102.2501 | 2021-02-09 05:23:30 | Melaka, Malaysia | ||
617504 | 617504 | 2020-02-27 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-02-27T12:13:14 | ||||
617920 | 617920 | 2022-11-05 | Malaysia | Melaka | 137806 | 1188 | 0 | 2.1896 | 102.2501 | 2022-11-06 04:21:24 | Melaka, Malaysia | |||
621936 | 621936 | 2022-05-22 | Malaysia | Melaka | 124063 | 1123 | 0 | 2.1896 | 102.2501 | 2022-05-26 04:20:50 | Melaka, Malaysia | |||
629554 | 629554 | 2021-07-10 | Malaysia | Melaka | 21592 | 197 | 17864 | 3531 | 2.1896 | 102.2501 | 2021-07-11 04:21:43 | Melaka, Malaysia | ||
629966 | 629966 | 2022-07-12 | Malaysia | Melaka | 126977 | 1141 | 0 | 2.1896 | 102.2501 | 2022-07-13 04:20:58 | Melaka, Malaysia | |||
633980 | 633980 | 2021-10-13 | Malaysia | Melaka | 61377 | 874 | 0 | 2.1896 | 102.2501 | 2021-10-14 04:21:29 | Melaka, Malaysia | |||
641600 | 641600 | 2021-03-31 | Malaysia | Melaka | 6537 | 22 | 6196 | 319 | 2.1896 | 102.2501 | 2021-04-01 04:27:05 | Melaka, Malaysia | ||
645614 | 645614 | 2021-09-07 | Malaysia | Melaka | 51208 | 743 | 44829 | 5636 | 2.1896 | 102.2501 | 2021-09-08 04:21:31 | Melaka, Malaysia | ||
649628 | 649628 | 2021-05-05 | Malaysia | Melaka | 7674 | 23 | 7181 | 470 | 2.1896 | 102.2501 | 2021-05-06 04:20:38 | Melaka, Malaysia | ||
653642 | 653642 | 2021-08-09 | Malaysia | Melaka | 35939 | 485 | 28657 | 6797 | 2.1896 | 102.2501 | 2021-08-10 04:21:27 | Melaka, Malaysia | ||
654052 | 654052 | 2021-10-22 | Malaysia | Melaka | 63297 | 890 | 0 | 2.1896 | 102.2501 | 2021-10-23 04:21:32 | Melaka, Malaysia | |||
657956 | 657956 | 2020-03-09 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-03-09T14:33:03 | ||||
658371 | 658371 | 2022-05-13 | Malaysia | Melaka | 122993 | 1118 | 0 | 2.1896 | 102.2501 | 2022-05-14 04:20:48 | Melaka, Malaysia | |||
665955 | 665955 | 2020-08-11 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-12 04:27:29 | Melaka, Malaysia | ||
669945 | 669945 | 2020-09-16 | Malaysia | Melaka | 257 | 6 | 252 | 0 | 2.1896 | 102.2501 | 2020-09-17 04:22:00 | Melaka, Malaysia | ||
670357 | 670357 | 2022-07-21 | Malaysia | Melaka | 128063 | 1151 | 0 | 2.1896 | 102.2501 | 2022-07-22 04:21:15 | Melaka, Malaysia | |||
674373 | 674373 | 2022-07-30 | Malaysia | Melaka | 129208 | 1154 | 0 | 2.1896 | 102.2501 | 2022-07-31 04:21:02 | Melaka, Malaysia | |||
681987 | 681987 | 2020-11-23 | Malaysia | Melaka | 377 | 6 | 346 | 25 | 2.1896 | 102.2501 | 2020-11-24 05:27:31 | Melaka, Malaysia | ||
682397 | 682397 | 2021-10-24 | Malaysia | Melaka | 63782 | 890 | 0 | 2.1896 | 102.2501 | 2021-10-25 04:22:31 | Melaka, Malaysia | |||
686413 | 686413 | 2021-11-13 | Malaysia | Melaka | 67808 | 914 | 0 | 2.1896 | 102.2501 | 2021-11-14 04:21:31 | Melaka, Malaysia | |||
690431 | 690431 | 2022-12-23 | Malaysia | Melaka | 143953 | 1198 | 0 | 2.1896 | 102.2501 | 2022-12-24 04:21:02 | Melaka, Malaysia | |||
694446 | 694446 | 2022-03-17 | Malaysia | Melaka | 109699 | 1051 | 0 | 2.1896 | 102.2501 | 2022-03-18 04:20:55 | Melaka, Malaysia | |||
698461 | 698461 | 2021-11-04 | Malaysia | Melaka | 66135 | 905 | 0 | 2.1896 | 102.2501 | 2021-11-05 04:21:54 | Melaka, Malaysia | |||
706081 | 706081 | 2021-03-16 | Malaysia | Melaka | 6171 | 22 | 6009 | 140 | 2.1896 | 102.2501 | 2021-03-17 05:25:07 | Melaka, Malaysia | ||
706491 | 706491 | 2021-09-29 | Malaysia | Melaka | 58146 | 850 | 0 | 2.1896 | 102.2501 | 2021-09-30 04:21:20 | Melaka, Malaysia | |||
710508 | 710508 | 2022-11-01 | Malaysia | Melaka | 137185 | 1188 | 0 | 2.1896 | 102.2501 | 2022-11-02 04:22:09 | Melaka, 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]);