⚠️ 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

456 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 · 456

province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1007259 2021-04-22 Singapore       60904 30 60603 271 1.2833 103.8333 2021-04-23 04:20:52 Singapore
1103335 2021-04-21 Singapore       60880 30 60576 274 1.2833 103.8333 2021-04-22 04:20:53 Singapore
999293 2021-04-20 Singapore       60865 30 60540 295 1.2833 103.8333 2021-04-21 04:21:14 Singapore
122146 2021-04-19 Singapore       60851 30 60503 318 1.2833 103.8333 2021-04-20 04:20:41 Singapore
1265195 2021-04-18 Singapore       60831 30 60485 316 1.2833 103.8333 2021-04-19 04:20:57 Singapore
712544 2021-04-17 Singapore       60808 30 60463 315 1.2833 103.8333 2021-04-18 04:20:41 Singapore
893066 2021-04-16 Singapore       60769 30 60446 293 1.2833 103.8333 2021-04-17 04:20:40 Singapore
1025706 2021-04-15 Singapore       60735 30 60417 288 1.2833 103.8333 2021-04-16 04:20:46 Singapore
1174298 2021-04-14 Singapore       60719 30 60392 297 1.2833 103.8333 2021-04-15 04:20:54 Singapore
944991 2021-04-13 Singapore       60692 30 60374 288 1.2833 103.8333 2021-04-14 04:20:41 Singapore
948974 2021-04-12 Singapore       60678 30 60357 291 1.2833 103.8333 2021-04-13 04:20:37 Singapore
133874 2021-04-11 Singapore       60653 30 60335 288 1.2833 103.8333 2021-04-12 04:21:00 Singapore
548260 2021-04-10 Singapore       60633 30 60322 281 1.2833 103.8333 2021-04-11 04:20:56 Singapore
30841 2021-04-09 Singapore       60601 30 60304 267 1.2833 103.8333 2021-04-10 04:20:59 Singapore
1297004 2021-04-08 Singapore       60575 30 60284 261 1.2833 103.8333 2021-04-09 04:21:13 Singapore
15018 2021-04-07 Singapore       60554 30 60260 264 1.2833 103.8333 2021-04-08 04:21:13 Singapore
932626 2021-04-06 Singapore       60519 30 60239 250 1.2833 103.8333 2021-04-07 04:20:53 Singapore
963742 2021-04-05 Singapore       60495 30 60214 251 1.2833 103.8333 2021-04-06 04:20:32 Singapore
1230669 2021-04-04 Singapore       60478 30 60202 246 1.2833 103.8333 2021-04-05 04:20:35 Singapore
361594 2021-04-03 Singapore       60468 30 60185 253 1.2833 103.8333 2021-04-04 04:20:49 Singapore
392578 2021-04-02 Singapore       60450 30 60176 244 1.2833 103.8333 2021-04-03 04:20:44 Singapore
396561 2021-04-01 Singapore       60407 30 60161 216 1.2833 103.8333 2021-04-02 04:20:36 Singapore
1300987 2021-03-31 Singapore       60381 30 60149 202 1.2833 103.8333 2021-04-01 04:27:05 Singapore
1416795 2021-03-30 Singapore       60347 30 60138 179 1.2833 103.8333 2021-03-31 04:26:25 Singapore
704581 2021-03-29 Singapore       60321 30 60131 160 1.2833 103.8333 2021-03-30 04:26:23 Singapore
823281 2021-03-28 Singapore       60300 30 60122 148 1.2833 103.8333 2021-03-29 04:28:35 Singapore
586432 2021-03-27 Singapore       60288 30 60113 145 1.2833 103.8333 2021-03-28 05:28:10 Singapore
1506655 2021-03-26 Singapore       60265 30 60103 132 1.2833 103.8333 2021-03-27 05:25:04 Singapore
38807 2021-03-25 Singapore       60253 30 60086 137 1.2833 103.8333 2021-03-26 05:26:55 Singapore
1373582 2021-03-24 Singapore       60236 30 60078 128 1.2833 103.8333 2021-03-25 05:27:00 Singapore
1226686 2021-03-23 Singapore       60221 30 60063 128 1.2833 103.8333 2021-03-24 05:25:40 Singapore
502300 2021-03-22 Singapore       60208 30 60051 127 1.2833 103.8333 2021-03-23 05:26:18 Singapore
764544 2021-03-21 Singapore       60196 30 60038 128 1.2833 103.8333 2021-03-22 05:25:43 Singapore
250243 2021-03-20 Singapore       60184 30 60022 132 1.2833 103.8333 2021-03-21 05:25:44 Singapore
188484 2021-03-19 Singapore       60167 30 60019 118 1.2833 103.8333 2021-03-20 05:25:46 Singapore
1060758 2021-03-18 Singapore       60152 30 60014 108 1.2833 103.8333 2021-03-19 05:26:09 Singapore
1056775 2021-03-17 Singapore       60137 30 60001 106 1.2833 103.8333 2021-03-18 05:26:22 Singapore
654204 2021-03-16 Singapore       60128 30 59984 114 1.2833 103.8333 2021-03-17 05:25:07 Singapore
54652 2021-03-15 Singapore       60117 30 59974 113 1.2833 103.8333 2021-03-16 05:25:13 Singapore
1166385 2021-03-14 Singapore       60105 30 59968 107 1.2833 103.8333 2021-03-15 05:25:51 Singapore
1144169 2021-03-13 Singapore       60088 30 59961 97 1.2833 103.8333 2021-03-14 05:25:37 Singapore
662148 2021-03-12 Singapore       60080 29 59950 101 1.2833 103.8333 2021-03-13 05:25:15 Singapore
666387 2021-03-11 Singapore       60070 29 59939 102 1.2833 103.8333 2021-03-12 05:26:50 Singapore
1033187 2021-03-10 Singapore       60062 29 59911 122 1.2833 103.8333 2021-03-11 05:25:48 Singapore
34824 2021-03-09 Singapore       60052 29 59905 118 1.2833 103.8333 2021-03-10 05:24:35 Singapore
1083905 2021-03-08 Singapore       60046 29 59900 117 1.2833 103.8333 2021-03-09 05:28:19 Singapore
1316850 2021-03-07 Singapore       60033 29 59894 110 1.2833 103.8333 2021-03-08 05:24:48 Singapore
445596 2021-03-06 Singapore       60020 29 59879 112 1.2833 103.8333 2021-03-07 05:21:54 Singapore
200433 2021-03-05 Singapore       60007 29 59870 108 1.2833 103.8333 2021-03-06 04:23:41 Singapore
1079847 2021-03-04 Singapore       59998 29 59857 112 1.2833 103.8333 2021-03-05 05:26:29 Singapore
831189 2021-03-03 Singapore       59979 29 59849 101 1.2833 103.8333 2021-03-04 05:24:24 Singapore
373537 2021-03-02 Singapore       59956 29 59842 85 1.2833 103.8333 2021-03-03 05:23:28 Singapore
874873 2021-03-01 Singapore       59948 29 59830 89 1.2833 103.8333 2021-03-02 05:23:30 Singapore
1238090 2021-02-28 Singapore       59936 29 59823 84 1.2833 103.8333 2021-03-01 05:23:01 Singapore
613030 2021-02-27 Singapore       59925 29 59816 80 1.2833 103.8333 2021-02-28 05:22:20 Singapore
192467 2021-02-26 Singapore       59913 29 59803 81 1.2833 103.8333 2021-02-27 05:22:28 Singapore
1003276 2021-02-25 Singapore       59900 29 59785 86 1.2833 103.8333 2021-02-26 05:22:40 Singapore
100086 2021-02-24 Singapore       59890 29 59761 100 1.2833 103.8333 2021-02-25 05:24:57 Singapore
424302 2021-02-23 Singapore       59883 29 59753 101 1.2833 103.8333 2021-02-24 05:29:16 Singapore
196450 2021-02-22 Singapore       59879 29 59746 104 1.2833 103.8333 2021-02-23 05:23:41 Singapore
377520 2021-02-21 Singapore       59869 29 59731 109 1.2833 103.8333 2021-02-22 05:24:21 Singapore
204416 2021-02-20 Singapore       59858 29 59719 110 1.2833 103.8333 2021-02-21 05:24:33 Singapore
853962 2021-02-19 Singapore       59846 29 59697 120 1.2833 103.8333 2021-02-20 05:22:51 Singapore
1178280 2021-02-18 Singapore       59832 29 59679 124 1.2833 103.8333 2021-02-19 05:24:16 Singapore
1428699 2021-02-17 Singapore       59821 29 59676 116 1.2833 103.8333 2021-02-18 05:22:58 Singapore
274042 2021-02-16 Singapore       59810 29 59661 120 1.2833 103.8333 2021-02-17 05:23:10 Singapore
129890 2021-02-15 Singapore       59809 29 59641 139 1.2833 103.8333 2021-02-16 05:24:38 Singapore
341678 2021-02-14 Singapore       59800 29 59621 150 1.2833 103.8333 2021-02-15 05:24:49 Singapore
3895 2021-02-13 Singapore       59786 29 59604 153 1.2833 103.8333 2021-02-14 05:23:43 Singapore
494086 2021-02-12 Singapore       59777 29 59569 179 1.2833 103.8333 2021-02-13 05:22:12 Singapore
1121670 2021-02-11 Singapore       59759 29 59558 172 1.2833 103.8333 2021-02-12 05:23:29 Singapore
1017780 2021-02-10 Singapore       59747 29 59526 192 1.2833 103.8333 2021-02-11 05:23:55 Singapore
1445077 2021-02-09 Singapore       59732 29 59506 197 1.2833 103.8333 2021-02-10 05:22:41 Singapore
536336 2021-02-08 Singapore       59721 29 59484 208 1.2833 103.8333 2021-02-09 05:23:30 Singapore
486162 2021-02-07 Singapore       59699 29 59433 237 1.2833 103.8333 2021-02-08 05:22:39 Singapore
312080 2021-02-06 Singapore       59675 29 59405 241 1.2833 103.8333 2021-02-07 05:23:00 Singapore
266109 2021-02-05 Singapore       59649 29 59373 247 1.2833 103.8333 2021-02-06 05:23:55 Singapore
1242072 2021-02-04 Singapore       59624 29 59348 247 1.2833 103.8333 2021-02-05 05:22:38 Singapore
293231 2021-02-03 Singapore       59602 29 59320 253 1.2833 103.8333 2021-02-04 05:22:26 Singapore
456642 2021-02-02 Singapore       59584 29 59301 254 1.2833 103.8333 2021-02-03 05:22:52 Singapore
65749 2021-02-01 Singapore       59565 29 59271 265 1.2833 103.8333 2021-02-02 05:22:49 Singapore
1253989 2021-01-31 Singapore       59536 29 59228 279 1.2833 103.8333 2021-02-01 05:22:53 Singapore
670432 2021-01-30 Singapore       59507 29 59196 282 1.2833 103.8333 2021-01-31 05:22:42 Singapore
1277121 2021-01-29 Singapore       59449 29 59181 239 1.2833 103.8333 2021-01-30 05:22:49 Singapore
1377606 2021-01-28 Singapore       59425 29 59148 248 1.2833 103.8333 2021-01-29 05:22:23 Singapore
979510 2021-01-27 Singapore       59391 29 59104 258 1.2833 103.8333 2021-01-28 05:22:24 Singapore
404524 2021-01-26 Singapore       59366 29 59086 251 1.2833 103.8333 2021-01-27 05:23:41 Singapore
156679 2021-01-25 Singapore       59352 29 59066 257 1.2833 103.8333 2021-01-26 05:22:02 Singapore
335013 2021-01-24 Singapore       59308 29 59041 238 1.2833 103.8333 2021-01-25 05:22:16 Singapore
176533 2021-01-23 Singapore       59260 29 59015 216 1.2833 103.8333 2021-01-24 05:22:35 Singapore
862156 2021-01-22 Singapore       59250 29 58983 238 1.2833 103.8333 2021-01-23 05:22:03 Singapore
556223 2021-01-21 Singapore       59235 29 58959 247 1.2833 103.8333 2021-01-22 05:22:10 Singapore
742602 2021-01-20 Singapore       59197 29 58926 242 1.2833 103.8333 2021-01-21 05:22:01 Singapore
913150 2021-01-19 Singapore       59157 29 58894 234 1.2833 103.8333 2021-01-20 05:21:54 Singapore
738620 2021-01-18 Singapore       59127 29 58868 230 1.2833 103.8333 2021-01-19 05:22:15 Singapore
300024 2021-01-17 Singapore       59113 29 58846 238 1.2833 103.8333 2021-01-18 05:22:34 Singapore
1491436 2021-01-16 Singapore       59083 29 58784 270 1.2833 103.8333 2021-01-17 05:22:17 Singapore
108021 2021-01-15 Singapore       59059 29 58771 259 1.2833 103.8333 2021-01-16 05:22:40 Singapore
412547 2021-01-14 Singapore       59029 29 58757 243 1.2833 103.8333 2021-01-15 05:22:24 Singapore
674414 2021-01-13 Singapore       58984 29 58722 233 1.2833 103.8333 2021-01-14 05:22:32 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]);