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 province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Singapore · 972 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
367822 | 367822 | 2020-07-16 | Singapore | 47126 | 27 | 43256 | 3843 | 1.2833 | 103.8333 | 2020-07-17 04:34:50 | Singapore | |||
371796 | 371796 | 2020-08-08 | Singapore | 54929 | 27 | 48583 | 6319 | 1.2833 | 103.8333 | 2020-08-09 04:34:54 | Singapore | |||
372480 | 372480 | 2022-09-13 | Singapore | 1864742 | 1602 | 0 | 1.2833 | 103.8333 | 2022-09-14 04:20:44 | Singapore | ||||
376456 | 376456 | 2020-11-06 | Singapore | 58047 | 28 | 57959 | 60 | 1.2833 | 103.8333 | 2020-11-07 05:24:52 | Singapore | |||
380469 | 380469 | 2021-04-30 | Singapore | 61145 | 30 | 60751 | 364 | 1.2833 | 103.8333 | 2021-05-01 04:20:47 | Singapore | |||
384507 | 384507 | 2022-09-23 | Singapore | 1887202 | 1609 | 0 | 1.2833 | 103.8333 | 2022-09-24 04:21:40 | Singapore | ||||
388499 | 388499 | 2021-04-04 | Singapore | 60478 | 30 | 60202 | 246 | 1.2833 | 103.8333 | 2021-04-05 04:20:35 | Singapore | |||
392510 | 392510 | 2020-11-27 | Singapore | 58199 | 28 | 58111 | 60 | 1.2833 | 103.8333 | 2020-11-28 05:25:50 | Singapore | |||
396548 | 396548 | 2022-10-07 | Singapore | 1942204 | 1628 | 0 | 1.2833 | 103.8333 | 2022-10-08 04:22:56 | Singapore | ||||
400543 | 400543 | 2021-06-29 | Singapore | 62563 | 36 | 62563 | 0 | 1.2833 | 103.8333 | 2021-06-30 04:21:41 | Singapore | |||
404574 | 404574 | 2021-12-07 | Singapore | 270588 | 771 | 0 | 1.2833 | 103.8333 | 2021-12-08 04:22:46 | Singapore | ||||
408573 | 408573 | 2021-07-28 | Singapore | 64589 | 37 | 62663 | 1889 | 1.2833 | 103.8333 | 2021-07-29 04:21:33 | Singapore | |||
415765 | 415765 | 2020-07-05 | Singapore | 44800 | 26 | 40441 | 4333 | 1.2833 | 103.8333 | 2020-07-06 04:33:57 | Singapore | |||
415871 | 415871 | 2020-01-26 | Singapore | 4 | 0 | 0 | 1/26/20 16:00 | |||||||
418936 | 418936 | 2020-04-18 | Singapore | 5992 | 11 | 740 | 5241 | 1.2833 | 103.8333 | 2020-04-18 22:32:28 | Singapore | |||
419619 | 419619 | 2022-09-18 | Singapore | 1875275 | 1607 | 0 | 1.2833 | 103.8333 | 2022-09-19 04:21:49 | Singapore | ||||
423631 | 423631 | 2021-10-10 | Singapore | 126966 | 162 | 0 | 1.2833 | 103.8333 | 2021-10-11 04:21:31 | Singapore | ||||
427609 | 427609 | 2020-09-07 | Singapore | 57044 | 27 | 56408 | 609 | 1.2833 | 103.8333 | 2020-09-08 04:28:25 | Singapore | |||
431641 | 431641 | 2022-11-03 | Singapore | 2115621 | 1683 | 0 | 1.2833 | 103.8333 | 2022-11-04 04:22:11 | Singapore | ||||
435632 | 435632 | 2021-01-21 | Singapore | 59235 | 29 | 58959 | 247 | 1.2833 | 103.8333 | 2021-01-22 05:22:10 | Singapore | |||
442953 | 442953 | 2020-07-26 | Singapore | 50369 | 27 | 45521 | 4821 | 1.2833 | 103.8333 | 2020-07-27 04:35:02 | Singapore | |||
443635 | 443635 | 2021-10-20 | Singapore | 158587 | 264 | 0 | 1.2833 | 103.8333 | 2021-10-21 04:21:18 | Singapore | ||||
447651 | 447651 | 2021-11-17 | Singapore | 244815 | 619 | 0 | 1.2833 | 103.8333 | 2021-11-18 04:21:33 | Singapore | ||||
451671 | 451671 | 2022-12-21 | Singapore | 2192690 | 1710 | 0 | 1.2833 | 103.8333 | 2022-12-22 04:20:56 | Singapore | ||||
458980 | 458980 | 2020-08-07 | Singapore | 54797 | 27 | 48312 | 6458 | 1.2833 | 103.8333 | 2020-08-08 04:34:53 | Singapore | |||
459660 | 459660 | 2022-02-02 | Singapore | 362176 | 859 | 0 | 1.2833 | 103.8333 | 2022-02-03 04:21:21 | Singapore | ||||
463677 | 463677 | 2022-05-02 | Singapore | 1200976 | 1338 | 0 | 1.2833 | 103.8333 | 2022-05-03 04:21:00 | Singapore | ||||
467692 | 467692 | 2021-10-07 | Singapore | 116864 | 136 | 0 | 1.2833 | 103.8333 | 2021-10-08 04:21:25 | Singapore | ||||
471688 | 471688 | 2021-02-19 | Singapore | 59846 | 29 | 59697 | 120 | 1.2833 | 103.8333 | 2021-02-20 05:22:51 | Singapore | |||
475724 | 475724 | 2022-06-26 | Singapore | 1408358 | 1408 | 0 | 1.2833 | 103.8333 | 2022-06-27 04:21:00 | Singapore | ||||
479160 | 479160 | 2020-02-25 | Singapore | 91 | 0 | 53 | 2020-02-25T18:55:32 | |||||||
479874 | 479874 | 2022-11-08 | Singapore | 2128572 | 1691 | 0 | 1.2833 | 103.8333 | 2022-11-09 04:21:22 | Singapore | ||||
483869 | 483869 | 2021-07-19 | Singapore | 63245 | 36 | 62532 | 677 | 1.2833 | 103.8333 | 2021-07-20 04:21:48 | Singapore | |||
487904 | 487904 | 2022-11-25 | Singapore | 2161673 | 1702 | 0 | 1.2833 | 103.8333 | 2022-11-26 04:21:11 | Singapore | ||||
491916 | 491916 | 2021-10-14 | Singapore | 138327 | 207 | 0 | 1.2833 | 103.8333 | 2021-10-15 04:21:26 | Singapore | ||||
495932 | 495932 | 2021-11-06 | Singapore | 215780 | 480 | 0 | 1.2833 | 103.8333 | 2021-11-07 04:21:53 | Singapore | ||||
499949 | 499949 | 2022-04-02 | Singapore | 1106001 | 1272 | 0 | 1.2833 | 103.8333 | 2022-04-03 04:20:48 | Singapore | ||||
503968 | 503968 | 2022-12-17 | Singapore | 2188511 | 1709 | 0 | 1.2833 | 103.8333 | 2022-12-18 04:21:03 | Singapore | ||||
507963 | 507963 | 2021-08-14 | Singapore | 66119 | 44 | 0 | 1.2833 | 103.8333 | 2021-08-15 04:21:41 | Singapore | ||||
511977 | 511977 | 2021-08-19 | Singapore | 66366 | 46 | 0 | 1.2833 | 103.8333 | 2021-08-20 04:21:33 | Singapore | ||||
516012 | 516012 | 2022-10-15 | Singapore | 2005884 | 1641 | 0 | 1.2833 | 103.8333 | 2022-10-16 04:22:39 | Singapore | ||||
522474 | 522474 | 2020-04-21 | Singapore | 9125 | 11 | 839 | 8275 | 1.2833 | 103.8333 | 2020-04-21 23:30:30 | Singapore | |||
523134 | 523134 | 2021-06-09 | Singapore | 62223 | 34 | 61740 | 449 | 1.2833 | 103.8333 | 2021-06-10 04:23:17 | Singapore | |||
530327 | 530327 | 2020-07-04 | Singapore | 44664 | 26 | 40117 | 4521 | 1.2833 | 103.8333 | 2020-07-05 04:33:46 | Singapore | |||
530982 | 530982 | 2021-02-22 | Singapore | 59879 | 29 | 59746 | 104 | 1.2833 | 103.8333 | 2021-02-23 05:23:41 | Singapore | |||
535016 | 535016 | 2021-10-27 | Singapore | 184419 | 349 | 0 | 1.2833 | 103.8333 | 2021-10-28 04:22:08 | Singapore | ||||
539036 | 539036 | 2022-10-26 | Singapore | 2080341 | 1668 | 0 | 1.2833 | 103.8333 | 2022-10-27 04:22:01 | Singapore | ||||
543052 | 543052 | 2022-12-15 | Singapore | 2186214 | 1709 | 0 | 1.2833 | 103.8333 | 2022-12-16 04:21:01 | Singapore | ||||
547026 | 547026 | 2020-09-12 | Singapore | 57357 | 27 | 56699 | 631 | 1.2833 | 103.8333 | 2020-09-13 04:30:52 | Singapore | |||
551054 | 551054 | 2021-12-08 | Singapore | 271297 | 774 | 0 | 1.2833 | 103.8333 | 2021-12-09 04:22:49 | Singapore | ||||
555070 | 555070 | 2022-01-16 | Singapore | 291849 | 843 | 0 | 1.2833 | 103.8333 | 2022-01-17 04:21:08 | Singapore | ||||
559088 | 559088 | 2022-06-16 | Singapore | 1355801 | 1401 | 0 | 1.2833 | 103.8333 | 2022-06-17 04:20:56 | Singapore | ||||
562524 | 562524 | 2020-03-01 | Singapore | 106 | 0 | 72 | 1.2833 | 103.8333 | 2020-03-01T23:23:02 | |||||
563246 | 563246 | 2021-06-22 | Singapore | 62448 | 35 | 62098 | 315 | 1.2833 | 103.8333 | 2021-06-23 04:21:46 | Singapore | |||
566698 | 566698 | 2020-02-06 | Singapore | 28 | 0 | 0 | 2020-02-05T16:33:03 | |||||||
567384 | 567384 | 2021-10-29 | Singapore | 192099 | 380 | 0 | 1.2833 | 103.8333 | 2021-10-30 04:22:03 | Singapore | ||||
574433 | 574433 | 2020-06-06 | Singapore | 37527 | 25 | 24559 | 12943 | 1.2833 | 103.8333 | 2020-06-07 03:53:30 | Singapore | |||
575113 | 575113 | 2022-02-25 | Singapore | 679795 | 986 | 0 | 1.2833 | 103.8333 | 2022-02-26 04:21:12 | Singapore | ||||
579111 | 579111 | 2021-07-13 | Singapore | 62744 | 36 | 62453 | 255 | 1.2833 | 103.8333 | 2021-07-14 04:21:35 | Singapore | |||
583104 | 583104 | 2020-08-13 | Singapore | 55497 | 27 | 50736 | 4734 | 1.2833 | 103.8333 | 2020-08-14 04:51:19 | Singapore | |||
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 | |||
617420 | 617420 | 2020-02-27 | Singapore | 93 | 0 | 62 | 2020-02-26T19:33:02 | |||||||
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 |
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]);