johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,072 rows where country_or_region = "Singapore" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Singapore · 872 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
589245 | 589245 | 2020-04-05 | Singapore | 1309 | 6 | 320 | 983 | 1.2833 | 103.8333 | 2020-04-05 23:06:26 | Singapore | |||
589907 | 589907 | 2021-08-08 | Singapore | 65764 | 42 | 0 | 1.2833 | 103.8333 | 2021-08-09 04:21:24 | Singapore | ||||
593940 | 593940 | 2022-07-01 | Singapore | 1453155 | 1415 | 0 | 1.2833 | 103.8333 | 2022-07-02 04:21:16 | Singapore | ||||
597954 | 597954 | 2021-10-19 | Singapore | 154725 | 246 | 0 | 1.2833 | 103.8333 | 2021-10-20 04:21:00 | Singapore | ||||
601970 | 601970 | 2021-09-23 | Singapore | 82860 | 70 | 0 | 1.2833 | 103.8333 | 2021-09-24 04:21:44 | Singapore | ||||
605965 | 605965 | 2021-04-09 | Singapore | 60601 | 30 | 60304 | 267 | 1.2833 | 103.8333 | 2021-04-10 04:20:59 | Singapore | |||
609961 | 609961 | 2020-08-29 | Singapore | 56717 | 27 | 55447 | 1243 | 1.2833 | 103.8333 | 2020-08-30 04:28:22 | Singapore | |||
613964 | 613964 | 2021-02-08 | Singapore | 59721 | 29 | 59484 | 208 | 1.2833 | 103.8333 | 2021-02-09 05:23:30 | Singapore | |||
618146 | 618146 | 2022-11-05 | Singapore | 2121435 | 1686 | 0 | 1.2833 | 103.8333 | 2022-11-06 04:21:24 | Singapore | ||||
622160 | 622160 | 2022-05-22 | Singapore | 1269635 | 1375 | 0 | 1.2833 | 103.8333 | 2022-05-26 04:20:50 | Singapore | ||||
626157 | 626157 | 2021-07-10 | Singapore | 62684 | 36 | 62397 | 251 | 1.2833 | 103.8333 | 2021-07-11 04:21:43 | Singapore | |||
630190 | 630190 | 2022-07-12 | Singapore | 1540778 | 1437 | 0 | 1.2833 | 103.8333 | 2022-07-13 04:20:58 | Singapore | ||||
634204 | 634204 | 2021-10-13 | Singapore | 135395 | 192 | 0 | 1.2833 | 103.8333 | 2021-10-14 04:21:29 | Singapore | ||||
638200 | 638200 | 2021-03-31 | Singapore | 60381 | 30 | 60149 | 202 | 1.2833 | 103.8333 | 2021-04-01 04:27:05 | Singapore | |||
642217 | 642217 | 2021-09-07 | Singapore | 69233 | 55 | 0 | 1.2833 | 103.8333 | 2021-09-08 04:21:31 | Singapore | ||||
646228 | 646228 | 2021-05-05 | Singapore | 61268 | 31 | 60844 | 393 | 1.2833 | 103.8333 | 2021-05-06 04:20:38 | Singapore | |||
650245 | 650245 | 2021-08-09 | Singapore | 65836 | 42 | 0 | 1.2833 | 103.8333 | 2021-08-10 04:21:27 | Singapore | ||||
654276 | 654276 | 2021-10-22 | Singapore | 165663 | 294 | 0 | 1.2833 | 103.8333 | 2021-10-23 04:21:32 | Singapore | ||||
657717 | 657717 | 2020-03-09 | Singapore | 150 | 0 | 78 | 1.2833 | 103.8333 | 2020-03-08T13:33:13 | |||||
658595 | 658595 | 2022-05-13 | Singapore | 1236850 | 1362 | 0 | 1.2833 | 103.8333 | 2022-05-14 04:20:48 | Singapore | ||||
662572 | 662572 | 2020-08-11 | Singapore | 55353 | 27 | 50128 | 5198 | 1.2833 | 103.8333 | 2020-08-12 04:27:29 | Singapore | |||
666551 | 666551 | 2020-09-16 | Singapore | 57514 | 27 | 56955 | 532 | 1.2833 | 103.8333 | 2020-09-17 04:22:00 | Singapore | |||
670581 | 670581 | 2022-07-21 | Singapore | 1636109 | 1466 | 0 | 1.2833 | 103.8333 | 2022-07-22 04:21:15 | Singapore | ||||
674597 | 674597 | 2022-07-30 | Singapore | 1708950 | 1497 | 0 | 1.2833 | 103.8333 | 2022-07-31 04:21:02 | Singapore | ||||
678587 | 678587 | 2020-11-23 | Singapore | 58165 | 28 | 58071 | 66 | 1.2833 | 103.8333 | 2020-11-24 05:27:31 | Singapore | |||
682621 | 682621 | 2021-10-24 | Singapore | 172644 | 315 | 0 | 1.2833 | 103.8333 | 2021-10-25 04:22:31 | Singapore | ||||
686637 | 686637 | 2021-11-13 | Singapore | 235480 | 576 | 0 | 1.2833 | 103.8333 | 2021-11-14 04:21:31 | Singapore | ||||
690657 | 690657 | 2022-12-23 | Singapore | 2194963 | 1710 | 0 | 1.2833 | 103.8333 | 2022-12-24 04:21:02 | Singapore | ||||
694670 | 694670 | 2022-03-17 | Singapore | 986320 | 1182 | 0 | 1.2833 | 103.8333 | 2022-03-18 04:20:55 | Singapore | ||||
698685 | 698685 | 2021-11-04 | Singapore | 210978 | 459 | 0 | 1.2833 | 103.8333 | 2021-11-05 04:21:54 | Singapore | ||||
702681 | 702681 | 2021-03-16 | Singapore | 60128 | 30 | 59984 | 114 | 1.2833 | 103.8333 | 2021-03-17 05:25:07 | Singapore | |||
706715 | 706715 | 2021-09-29 | Singapore | 94043 | 93 | 0 | 1.2833 | 103.8333 | 2021-09-30 04:21:20 | Singapore | ||||
710734 | 710734 | 2022-11-01 | Singapore | 2108024 | 1680 | 0 | 1.2833 | 103.8333 | 2022-11-02 04:22:09 | Singapore | ||||
714746 | 714746 | 2021-11-12 | Singapore | 233176 | 562 | 0 | 1.2833 | 103.8333 | 2021-11-13 04:21:38 | Singapore | ||||
718766 | 718766 | 2022-12-04 | Singapore | 2172396 | 1705 | 0 | 1.2833 | 103.8333 | 2022-12-05 04:20:58 | Singapore | ||||
722778 | 722778 | 2021-11-20 | Singapore | 250518 | 654 | 0 | 1.2833 | 103.8333 | 2021-11-21 04:22:13 | Singapore | ||||
726774 | 726774 | 2021-05-22 | Singapore | 61799 | 32 | 61277 | 490 | 1.2833 | 103.8333 | 2021-05-23 04:20:51 | Singapore | |||
730808 | 730808 | 2021-12-27 | Singapore | 278044 | 825 | 0 | 1.2833 | 103.8333 | 2021-12-28 04:21:47 | Singapore | ||||
737925 | 737925 | 2020-06-12 | Singapore | 39850 | 25 | 28040 | 11785 | 1.2833 | 103.8333 | 2020-06-13 03:33:14 | Singapore | |||
738576 | 738576 | 2020-12-02 | Singapore | 58230 | 29 | 58144 | 57 | 1.2833 | 103.8333 | 2020-12-03 05:28:22 | Singapore | |||
742590 | 742590 | 2021-02-20 | Singapore | 59858 | 29 | 59719 | 110 | 1.2833 | 103.8333 | 2021-02-21 05:24:33 | Singapore | |||
746625 | 746625 | 2022-04-23 | Singapore | 1180124 | 1325 | 0 | 1.2833 | 103.8333 | 2022-04-24 04:20:56 | Singapore | ||||
753934 | 753934 | 2020-08-01 | Singapore | 52512 | 27 | 46740 | 5745 | 1.2833 | 103.8333 | 2020-08-02 04:34:47 | Singapore | |||
754576 | 754576 | 2020-10-28 | Singapore | 57987 | 28 | 57890 | 69 | 1.2833 | 103.8333 | 2020-10-29 04:24:49 | Singapore | |||
758608 | 758608 | 2021-11-26 | Singapore | 259875 | 684 | 0 | 1.2833 | 103.8333 | 2021-11-27 04:22:45 | Singapore | ||||
762587 | 762587 | 2020-10-18 | Singapore | 57911 | 28 | 57807 | 76 | 1.2833 | 103.8333 | 2020-10-19 04:24:16 | Singapore | |||
766595 | 766595 | 2020-12-29 | Singapore | 58542 | 29 | 58400 | 113 | 1.2833 | 103.8333 | 2020-12-30 05:22:34 | Singapore | |||
770629 | 770629 | 2021-10-23 | Singapore | 169261 | 300 | 0 | 1.2833 | 103.8333 | 2021-10-24 04:21:22 | Singapore | ||||
774623 | 774623 | 2021-01-12 | Singapore | 58946 | 29 | 58694 | 223 | 1.2833 | 103.8333 | 2021-01-13 05:22:15 | Singapore | |||
778640 | 778640 | 2021-07-08 | Singapore | 62668 | 36 | 62363 | 269 | 1.2833 | 103.8333 | 2021-07-09 04:21:21 | Singapore | |||
782671 | 782671 | 2021-12-13 | Singapore | 273701 | 798 | 0 | 1.2833 | 103.8333 | 2021-12-14 04:22:38 | Singapore | ||||
786650 | 786650 | 2020-10-15 | Singapore | 57892 | 28 | 57764 | 100 | 1.2833 | 103.8333 | 2020-10-16 04:24:01 | Singapore | |||
790659 | 790659 | 2021-02-04 | Singapore | 59624 | 29 | 59348 | 247 | 1.2833 | 103.8333 | 2021-02-05 05:22:38 | Singapore | |||
794698 | 794698 | 2022-10-24 | Singapore | 2067790 | 1663 | 0 | 1.2833 | 103.8333 | 2022-10-25 04:21:53 | Singapore | ||||
798710 | 798710 | 2021-12-22 | Singapore | 276720 | 818 | 0 | 1.2833 | 103.8333 | 2021-12-23 04:21:21 | Singapore | ||||
805724 | 805724 | 2020-06-01 | Singapore | 35292 | 24 | 22466 | 12802 | 1.2833 | 103.8333 | 2020-06-02 02:33:08 | Singapore | |||
809195 | 809195 | 2020-03-27 | Singapore | 732 | 2 | 183 | 547 | 1.2833 | 103.8333 | 2020-03-27 23:23:03 | Singapore | |||
809855 | 809855 | 2021-09-20 | Singapore | 78721 | 62 | 0 | 1.2833 | 103.8333 | 2021-09-21 04:21:26 | Singapore | ||||
813849 | 813849 | 2020-09-05 | Singapore | 56982 | 27 | 56267 | 688 | 1.2833 | 103.8333 | 2020-09-06 04:28:33 | Singapore | |||
817840 | 817840 | 2020-10-09 | Singapore | 57859 | 27 | 57675 | 157 | 1.2833 | 103.8333 | 2020-10-10 04:23:57 | Singapore | |||
821845 | 821845 | 2020-11-19 | Singapore | 58139 | 28 | 58052 | 59 | 1.2833 | 103.8333 | 2020-11-20 05:26:28 | Singapore | |||
825860 | 825860 | 2021-06-06 | Singapore | 62196 | 33 | 61635 | 528 | 1.2833 | 103.8333 | 2021-06-07 04:22:51 | Singapore | |||
829876 | 829876 | 2021-07-09 | Singapore | 62678 | 36 | 62374 | 268 | 1.2833 | 103.8333 | 2021-07-10 04:21:25 | Singapore | |||
833911 | 833911 | 2022-12-02 | Singapore | 2170498 | 1705 | 0 | 1.2833 | 103.8333 | 2022-12-03 04:21:02 | Singapore | ||||
837885 | 837885 | 2020-08-17 | Singapore | 55838 | 27 | 52350 | 3461 | 1.2833 | 103.8333 | 2020-08-18 04:27:56 | Singapore | |||
845187 | 845187 | 2020-07-22 | Singapore | 48744 | 27 | 44795 | 3922 | 1.2833 | 103.8333 | 2020-07-23 05:15:04 | Singapore | |||
845845 | 845845 | 2020-12-12 | Singapore | 58313 | 29 | 58197 | 87 | 1.2833 | 103.8333 | 2020-12-13 05:27:20 | Singapore | |||
849883 | 849883 | 2022-11-02 | Singapore | 2112110 | 1682 | 0 | 1.2833 | 103.8333 | 2022-11-03 04:22:05 | Singapore | ||||
853899 | 853899 | 2022-09-30 | Singapore | 1907907 | 1618 | 0 | 1.2833 | 103.8333 | 2022-10-01 04:23:01 | Singapore | ||||
860296 | 860296 | 2020-04-15 | Singapore | 3699 | 10 | 652 | 3037 | 1.2833 | 103.8333 | 2020-04-15 22:56:32 | Singapore | |||
860952 | 860952 | 2020-12-11 | Singapore | 58305 | 29 | 58192 | 84 | 1.2833 | 103.8333 | 2020-12-12 05:26:19 | Singapore | |||
865045 | 865045 | 2020-11-12 | Singapore | 58102 | 28 | 58002 | 72 | 1.2833 | 103.8333 | 2020-11-13 05:25:30 | Singapore | |||
869083 | 869083 | 2022-12-11 | Singapore | 2181048 | 1707 | 0 | 1.2833 | 103.8333 | 2022-12-12 04:21:01 | Singapore | ||||
875863 | 875863 | 2020-05-24 | Singapore | 31616 | 23 | 14876 | 16717 | 1.2833 | 103.8333 | 2020-05-25 02:32:44 | Singapore | |||
876545 | 876545 | 2022-03-27 | Singapore | 1067157 | 1250 | 0 | 1.2833 | 103.8333 | 2022-03-28 04:20:33 | Singapore | ||||
880562 | 880562 | 2022-08-05 | Singapore | 1749144 | 1534 | 0 | 1.2833 | 103.8333 | 2022-08-06 04:20:56 | Singapore | ||||
887740 | 887740 | 2020-07-07 | Singapore | 45140 | 26 | 41002 | 4112 | 1.2833 | 103.8333 | 2020-07-08 05:33:48 | Singapore | |||
888396 | 888396 | 2021-04-26 | Singapore | 61051 | 30 | 60682 | 339 | 1.2833 | 103.8333 | 2021-04-27 04:20:52 | Singapore | |||
892394 | 892394 | 2020-11-05 | Singapore | 58043 | 28 | 57949 | 66 | 1.2833 | 103.8333 | 2020-11-06 05:24:55 | Singapore | |||
896429 | 896429 | 2022-07-24 | Singapore | 1659156 | 1476 | 0 | 1.2833 | 103.8333 | 2022-07-25 04:20:51 | Singapore | ||||
900445 | 900445 | 2022-07-22 | Singapore | 1645092 | 1468 | 0 | 1.2833 | 103.8333 | 2022-07-23 04:20:53 | Singapore | ||||
904459 | 904459 | 2021-11-24 | Singapore | 257510 | 678 | 0 | 1.2833 | 103.8333 | 2021-11-25 04:22:33 | Singapore | ||||
908453 | 908453 | 2021-01-19 | Singapore | 59157 | 29 | 58894 | 234 | 1.2833 | 103.8333 | 2021-01-20 05:21:54 | Singapore | |||
912492 | 912492 | 2022-10-29 | Singapore | 2096520 | 1674 | 0 | 1.2833 | 103.8333 | 2022-10-30 04:22:14 | Singapore | ||||
919287 | 919287 | 2020-03-26 | Singapore | 683 | 2 | 172 | 509 | 1.2833 | 103.8333 | 2020-03-26 23:48:18 | Singapore | |||
919965 | 919965 | 2022-03-08 | Singapore | 846341 | 1099 | 0 | 1.2833 | 103.8333 | 2022-03-09 04:20:59 | Singapore | ||||
923957 | 923957 | 2020-11-26 | Singapore | 58195 | 28 | 58104 | 63 | 1.2833 | 103.8333 | 2020-11-27 05:26:53 | Singapore | |||
927968 | 927968 | 2020-12-21 | Singapore | 58432 | 29 | 58287 | 116 | 1.2833 | 103.8333 | 2020-12-22 05:22:33 | Singapore | |||
934402 | 934402 | 2020-04-16 | Singapore | 4427 | 10 | 683 | 3734 | 1.2833 | 103.8333 | 2020-04-16 23:30:31 | Singapore | |||
935081 | 935081 | 2021-10-16 | Singapore | 145120 | 224 | 0 | 1.2833 | 103.8333 | 2021-10-17 04:21:29 | Singapore | ||||
939099 | 939099 | 2022-06-25 | Singapore | 1403242 | 1408 | 0 | 1.2833 | 103.8333 | 2022-06-26 04:21:02 | Singapore | ||||
943114 | 943114 | 2022-02-28 | Singapore | 724424 | 1019 | 0 | 1.2833 | 103.8333 | 2022-03-01 04:21:09 | Singapore | ||||
947131 | 947131 | 2022-06-14 | Singapore | 1348775 | 1401 | 0 | 1.2833 | 103.8333 | 2022-06-15 04:20:54 | Singapore | ||||
951146 | 951146 | 2022-03-12 | Singapore | 929735 | 1139 | 0 | 1.2833 | 103.8333 | 2022-03-13 04:20:49 | Singapore | ||||
955141 | 955141 | 2021-04-25 | Singapore | 61006 | 30 | 60662 | 314 | 1.2833 | 103.8333 | 2021-04-26 04:21:04 | Singapore | |||
959177 | 959177 | 2022-07-19 | Singapore | 1616067 | 1460 | 0 | 1.2833 | 103.8333 | 2022-07-20 04:20:59 | Singapore | ||||
963193 | 963193 | 2022-09-09 | Singapore | 1856673 | 1602 | 0 | 1.2833 | 103.8333 | 2022-09-10 04:21:10 | Singapore | ||||
967170 | 967170 | 2020-09-29 | Singapore | 57742 | 27 | 57466 | 249 | 1.2833 | 103.8333 | 2020-09-30 04:23:33 | Singapore | |||
971201 | 971201 | 2022-06-01 | Singapore | 1306871 | 1389 | 0 | 1.2833 | 103.8333 | 2022-06-02 05:20:39 | Singapore | ||||
975194 | 975194 | 2021-02-06 | Singapore | 59675 | 29 | 59405 | 241 | 1.2833 | 103.8333 | 2021-02-07 05:23:00 | Singapore |
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]);