⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

366 rows where country_or_region = "Singapore" sorted by day descending

View and edit SQL

Suggested facets: deaths, latitude, longitude, day (date), last_update (date)

country_or_region

  • Singapore · 366

province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
89957 2021-01-22 Singapore       59250 29 58983 238 1.2833 103.8333 2021-01-23 05:22:03 Singapore
302863 2021-01-21 Singapore       59235 29 58959 247 1.2833 103.8333 2021-01-22 05:22:10 Singapore
893914 2021-01-20 Singapore       59197 29 58926 242 1.2833 103.8333 2021-01-21 05:22:01 Singapore
322481 2021-01-19 Singapore       59157 29 58894 234 1.2833 103.8333 2021-01-20 05:21:54 Singapore
574467 2021-01-18 Singapore       59127 29 58868 230 1.2833 103.8333 2021-01-19 05:22:15 Singapore
539030 2021-01-17 Singapore       59113 29 58846 238 1.2833 103.8333 2021-01-18 05:22:34 Singapore
619818 2021-01-16 Singapore       59083 29 58784 270 1.2833 103.8333 2021-01-17 05:22:17 Singapore
184959 2021-01-15 Singapore       59059 29 58771 259 1.2833 103.8333 2021-01-16 05:22:40 Singapore
597651 2021-01-14 Singapore       59029 29 58757 243 1.2833 103.8333 2021-01-15 05:22:24 Singapore
729022 2021-01-13 Singapore       58984 29 58722 233 1.2833 103.8333 2021-01-14 05:22:32 Singapore
57378 2021-01-12 Singapore       58946 29 58694 223 1.2833 103.8333 2021-01-13 05:22:15 Singapore
269558 2021-01-11 Singapore       58929 29 58668 232 1.2833 103.8333 2021-01-12 05:22:15 Singapore
785529 2021-01-10 Singapore       58907 29 58636 242 1.2833 103.8333 2021-01-11 05:21:50 Singapore
138973 2021-01-09 Singapore       58865 29 58611 225 1.2833 103.8333 2021-01-10 05:22:12 Singapore
466789 2021-01-08 Singapore       58836 29 58580 227 1.2833 103.8333 2021-01-09 05:22:18 Singapore
294922 2021-01-07 Singapore       58813 29 58562 222 1.2833 103.8333 2021-01-08 05:22:42 Singapore
1049626 2021-01-06 Singapore       58780 29 58541 210 1.2833 103.8333 2021-01-07 05:22:03 Singapore
515991 2021-01-05 Singapore       58749 29 58517 203 1.2833 103.8333 2021-01-06 05:22:16 Singapore
984690 2021-01-04 Singapore       58721 29 58497 195 1.2833 103.8333 2021-01-05 05:21:49 Singapore
531635 2021-01-03 Singapore       58697 29 58487 181 1.2833 103.8333 2021-01-04 05:22:02 Singapore
454930 2021-01-02 Singapore       58662 29 58476 157 1.2833 103.8333 2021-01-03 05:22:52 Singapore
273534 2021-01-01 Singapore       58629 29 58449 151 1.2833 103.8333 2021-01-02 05:22:33 Singapore
550732 2020-12-31 Singapore       58599 29 58449 121 1.2833 103.8333 2021-01-01 05:23:07 Singapore
906116 2020-12-30 Singapore       58569 29 58411 129 1.2833 103.8333 2020-12-31 05:22:49 Singapore
75463 2020-12-29 Singapore       58542 29 58400 113 1.2833 103.8333 2020-12-30 05:22:34 Singapore
420319 2020-12-28 Singapore       58529 29 58386 114 1.2833 103.8333 2020-12-29 05:22:37 Singapore
216530 2020-12-27 Singapore       58524 29 58370 125 1.2833 103.8333 2020-12-28 05:22:06 Singapore
239568 2020-12-26 Singapore       58519 29 58362 128 1.2833 103.8333 2020-12-27 05:22:55 Singapore
34164 2020-12-25 Singapore       58509 29 58352 128 1.2833 103.8333 2020-12-26 05:22:28 Singapore
958683 2020-12-24 Singapore       58495 29 58332 134 1.2833 103.8333 2020-12-25 05:22:48 Singapore
18855 2020-12-23 Singapore       58482 29 58322 131 1.2833 103.8333 2020-12-24 05:23:04 Singapore
1037880 2020-12-22 Singapore       58461 29 58304 128 1.2833 103.8333 2020-12-23 05:22:03 Singapore
996477 2020-12-21 Singapore       58432 29 58287 116 1.2833 103.8333 2020-12-22 05:22:33 Singapore
558448 2020-12-20 Singapore       58422 29 58279 114 1.2833 103.8333 2020-12-21 05:27:58 Singapore
773630 2020-12-19 Singapore       58403 29 58274 100 1.2833 103.8333 2020-12-20 05:27:32 Singapore
1053602 2020-12-18 Singapore       58386 29 58265 92 1.2833 103.8333 2020-12-19 05:27:52 Singapore
450954 2020-12-17 Singapore       58377 29 58252 96 1.2833 103.8333 2020-12-18 05:28:18 Singapore
902140 2020-12-16 Singapore       58353 29 58238 86 1.2833 103.8333 2020-12-17 05:28:12 Singapore
470840 2020-12-15 Singapore       58341 29 58233 79 1.2833 103.8333 2020-12-16 05:28:04 Singapore
1033904 2020-12-14 Singapore       58325 29 58210 86 1.2833 103.8333 2020-12-15 05:26:38 Singapore
235541 2020-12-13 Singapore       58320 29 58208 83 1.2833 103.8333 2020-12-14 05:26:27 Singapore
1010868 2020-12-12 Singapore       58313 29 58197 87 1.2833 103.8333 2020-12-13 05:27:20 Singapore
446978 2020-12-11 Singapore       58305 29 58192 84 1.2833 103.8333 2020-12-12 05:26:19 Singapore
660937 2020-12-10 Singapore       58297 29 58188 80 1.2833 103.8333 2020-12-11 05:26:59 Singapore
311099 2020-12-09 Singapore       58291 29 58182 80 1.2833 103.8333 2020-12-10 05:26:19 Singapore
188936 2020-12-08 Singapore       58285 29 58176 80 1.2833 103.8333 2020-12-09 05:28:01 Singapore
412380 2020-12-07 Singapore       58273 29 58168 76 1.2833 103.8333 2020-12-08 05:27:42 Singapore
1121223 2020-12-06 Singapore       58260 29 58160 71 1.2833 103.8333 2020-12-07 05:26:14 Singapore
886501 2020-12-05 Singapore       58255 29 58158 68 1.2833 103.8333 2020-12-06 05:26:18 Singapore
26228 2020-12-04 Singapore       58242 29 58152 61 1.2833 103.8333 2020-12-05 05:27:36 Singapore
601627 2020-12-03 Singapore       58239 29 58145 65 1.2833 103.8333 2020-12-04 05:27:27 Singapore
381351 2020-12-02 Singapore       58230 29 58144 57 1.2833 103.8333 2020-12-03 05:28:22 Singapore
117105 2020-12-01 Singapore       58228 29 58139 60 1.2833 103.8333 2020-12-02 05:27:41 Singapore
243544 2020-11-30 Singapore       58218 29 58134 55 1.2833 103.8333 2020-12-01 05:26:18 Singapore
781552 2020-11-29 Singapore       58213 29 58124 60 1.2833 103.8333 2020-11-30 05:26:13 Singapore
769654 2020-11-28 Singapore       58205 29 58119 57 1.2833 103.8333 2020-11-29 05:25:55 Singapore
797254 2020-11-27 Singapore       58199 28 58111 60 1.2833 103.8333 2020-11-28 05:25:50 Singapore
1057578 2020-11-26 Singapore       58195 28 58104 63 1.2833 103.8333 2020-11-27 05:26:53 Singapore
519967 2020-11-25 Singapore       58190 28 58091 71 1.2833 103.8333 2020-11-26 05:27:44 Singapore
946661 2020-11-24 Singapore       58183 28 58079 76 1.2833 103.8333 2020-11-25 05:27:20 Singapore
832367 2020-11-23 Singapore       58165 28 58071 66 1.2833 103.8333 2020-11-24 05:27:31 Singapore
220505 2020-11-22 Singapore       58160 28 58067 65 1.2833 103.8333 2020-11-23 05:25:26 Singapore
765678 2020-11-21 Singapore       58148 28 58064 56 1.2833 103.8333 2020-11-22 05:25:45 Singapore
45514 2020-11-20 Singapore       58143 28 58058 57 1.2833 103.8333 2020-11-21 05:25:51 Singapore
377375 2020-11-19 Singapore       58139 28 58052 59 1.2833 103.8333 2020-11-20 05:26:28 Singapore
699232 2020-11-18 Singapore       58135 28 58046 61 1.2833 103.8333 2020-11-19 05:25:23 Singapore
1082899 2020-11-17 Singapore       58130 28 58039 63 1.2833 103.8333 2020-11-18 05:40:31 Singapore
196868 2020-11-16 Singapore       58124 28 58033 63 1.2833 103.8333 2020-11-17 05:25:54 Singapore
359867 2020-11-15 Singapore       58119 28 58029 62 1.2833 103.8333 2020-11-16 05:25:57 Singapore
695182 2020-11-14 Singapore       58116 28 58019 69 1.2833 103.8333 2020-11-15 05:26:53 Singapore
898106 2020-11-13 Singapore       58114 28 58008 78 1.2833 103.8333 2020-11-14 05:25:37 Singapore
388965 2020-11-12 Singapore       58102 28 58002 72 1.2833 103.8333 2020-11-13 05:25:30 Singapore
298885 2020-11-11 Singapore       58091 28 57990 73 1.2833 103.8333 2020-11-12 05:25:55 Singapore
416343 2020-11-10 Singapore       58073 28 57985 60 1.2833 103.8333 2020-11-11 05:25:30 Singapore
1090610 2020-11-09 Singapore       58064 28 57981 55 1.2833 103.8333 2020-11-10 05:40:07 Singapore
10895 2020-11-08 Singapore       58056 28 57975 53 1.2833 103.8333 2020-11-09 05:25:45 Singapore
839740 2020-11-07 Singapore       58054 28 57968 58 1.2833 103.8333 2020-11-08 05:24:56 Singapore
251458 2020-11-06 Singapore       58047 28 57959 60 1.2833 103.8333 2020-11-07 05:24:52 Singapore
1136536 2020-11-05 Singapore       58043 28 57949 66 1.2833 103.8333 2020-11-06 05:24:55 Singapore
874692 2020-11-04 Singapore       58036 28 57938 70 1.2833 103.8333 2020-11-05 06:05:03 Singapore
474803 2020-11-03 Singapore       58029 28 57937 64 1.2833 103.8333 2020-11-04 05:25:09 Singapore
867538 2020-11-02 Singapore       58020 28 57924 68 1.2833 103.8333 2020-11-03 06:00:16 Singapore
634494 2020-11-01 Singapore       58019 28 57924 67 1.2833 103.8333 2020-11-02 05:25:04 Singapore
501106 2020-10-31 Singapore       58015 28 57913 74 1.2833 103.8333 2020-11-01 04:36:19 Singapore
615843 2020-10-30 Singapore       58003 28 57909 66 1.2833 103.8333 2020-10-31 04:24:44 Singapore
878726 2020-10-29 Singapore       57994 28 57899 67 1.2833 103.8333 2020-10-30 04:24:49 Singapore
228425 2020-10-28 Singapore       57987 28 57890 69 1.2833 103.8333 2020-10-29 04:24:49 Singapore
1155007 2020-10-27 Singapore       57980 28 57883 69 1.2833 103.8333 2020-10-28 04:24:39 Singapore
337773 2020-10-26 Singapore       57973 28 57879 66 1.2833 103.8333 2020-10-27 04:24:45 Singapore
79425 2020-10-25 Singapore       57970 28 57858 84 1.2833 103.8333 2020-10-26 04:25:02 Singapore
41541 2020-10-24 Singapore       57965 28 57844 93 1.2833 103.8333 2020-10-25 04:24:36 Singapore
732984 2020-10-23 Singapore       57951 28 57832 91 1.2833 103.8333 2020-10-24 04:24:46 Singapore
932813 2020-10-22 Singapore       57941 28 57829 84 1.2833 103.8333 2020-10-23 04:24:46 Singapore
329856 2020-10-21 Singapore       57933 28 57821 84 1.2833 103.8333 2020-10-22 04:24:27 Singapore
30190 2020-10-20 Singapore       57921 28 57819 74 1.2833 103.8333 2020-10-21 04:24:14 Singapore
53403 2020-10-19 Singapore       57915 28 57819 68 1.2833 103.8333 2020-10-20 04:24:22 Singapore
928854 2020-10-18 Singapore       57911 28 57807 76 1.2833 103.8333 2020-10-19 04:24:16 Singapore
980716 2020-10-17 Singapore       57904 28 57798 78 1.2833 103.8333 2020-10-18 04:24:25 Singapore
174104 2020-10-16 Singapore       57901 28 57784 89 1.2833 103.8333 2020-10-17 04:24:12 Singapore
562410 2020-10-15 Singapore       57892 28 57764 100 1.2833 103.8333 2020-10-16 04:24:01 Singapore

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);