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 latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107054 | 107054 | 2020-02-15 | Singapore | 72 | 0 | 18 | 2020-02-15T23:53:02 | |||||||
197797 | 197797 | 2020-01-24 | Singapore | 3 | 0 | 0 | 1/24/20 17:00 | |||||||
197878 | 197878 | 2020-01-29 | Singapore | 7 | 0 | 0 | 1/29/20 19:30 | |||||||
415871 | 415871 | 2020-01-26 | Singapore | 4 | 0 | 0 | 1/26/20 16:00 | |||||||
479160 | 479160 | 2020-02-25 | Singapore | 91 | 0 | 53 | 2020-02-25T18:55:32 | |||||||
566698 | 566698 | 2020-02-06 | Singapore | 28 | 0 | 0 | 2020-02-05T16:33:03 | |||||||
617420 | 617420 | 2020-02-27 | Singapore | 93 | 0 | 62 | 2020-02-26T19:33:02 | |||||||
864415 | 864415 | 2020-01-23 | Singapore | 1 | 0 | 0 | 1/23/20 17:00 | |||||||
1085655 | 1085655 | 2020-02-22 | Singapore | 85 | 0 | 37 | 2020-02-21T03:43:02 | |||||||
1192474 | 1192474 | 2020-02-14 | Singapore | 67 | 0 | 17 | 2020-02-14T12:43:02 | |||||||
1243375 | 1243375 | 2020-02-17 | Singapore | 77 | 0 | 24 | 2020-02-17T14:33:04 | |||||||
1305793 | 1305793 | 2020-01-28 | Singapore | 7 | 0 | 0 | 1/28/20 23:00 | |||||||
1366070 | 1366070 | 2020-02-08 | Singapore | 33 | 0 | 2 | 2020-02-08T12:53:01 | |||||||
1527531 | 1527531 | 2020-01-30 | Singapore | 10 | 0 | 0 | 1/30/20 16:00 | |||||||
1559683 | 1559683 | 2020-02-13 | Singapore | 58 | 0 | 15 | 2020-02-13T14:33:02 | |||||||
1720070 | 1720070 | 2020-02-19 | Singapore | 84 | 0 | 34 | 2020-02-19T22:13:08 | |||||||
1783101 | 1783101 | 2020-02-18 | Singapore | 81 | 0 | 29 | 2020-02-18T16:53:03 | |||||||
1888728 | 1888728 | 2020-02-16 | Singapore | 75 | 0 | 18 | 2020-02-16T16:23:06 | |||||||
2091690 | 2091690 | 2020-02-05 | Singapore | 28 | 0 | 0 | 2020-02-05T16:33:03 | |||||||
2135737 | 2135737 | 2020-02-21 | Singapore | 85 | 0 | 37 | 2020-02-21T03:43:02 | |||||||
2263479 | 2263479 | 2020-02-20 | Singapore | 84 | 0 | 34 | 2020-02-19T22:13:08 | |||||||
2379259 | 2379259 | 2020-02-02 | Singapore | 18 | 0 | 0 | 2020-02-02T01:03:32 | |||||||
2509776 | 2509776 | 2020-02-26 | Singapore | 93 | 0 | 62 | 2020-02-26T19:33:02 | |||||||
2567274 | 2567274 | 2020-02-12 | Singapore | 50 | 0 | 15 | 2020-02-12T19:53:02 | |||||||
2860573 | 2860573 | 2020-02-03 | Singapore | 18 | 0 | 0 | 2020-02-02T01:03:32 | |||||||
2883936 | 2883936 | 2020-02-28 | Singapore | 93 | 0 | 62 | 2020-02-26T19:33:02 | |||||||
2938970 | 2938970 | 2020-01-25 | Singapore | 3 | 0 | 0 | 1/25/20 17:00 | |||||||
3089031 | 3089031 | 2020-02-10 | Singapore | 45 | 0 | 2 | 2020-02-10T19:03:02 | |||||||
3173367 | 3173367 | 2020-02-23 | Singapore | 89 | 0 | 51 | 2020-02-23T15:13:15 | |||||||
3197733 | 3197733 | 2020-02-11 | Singapore | 47 | 0 | 9 | 2020-02-11T16:43:06 | |||||||
3205811 | 3205811 | 2020-02-29 | Singapore | 102 | 0 | 72 | 2020-02-29T14:33:03 | |||||||
3222029 | 3222029 | 2020-02-07 | Singapore | 30 | 0 | 0 | 2020-02-07T03:03:03 | |||||||
3362400 | 3362400 | 2020-02-09 | Singapore | 40 | 0 | 2 | 2020-02-09T02:43:02 | |||||||
3413171 | 3413171 | 2020-02-01 | Singapore | 16 | 0 | 0 | 2/1/2020 5:37 | |||||||
3471908 | 3471908 | 2020-02-04 | Singapore | 24 | 0 | 0 | 2020-02-04T15:33:03 | |||||||
3551223 | 3551223 | 2020-02-24 | Singapore | 89 | 0 | 51 | 2020-02-23T15:13:15 | |||||||
3753096 | 3753096 | 2020-01-27 | Singapore | 5 | 0 | 0 | 1/27/20 23:59 | |||||||
3761211 | 3761211 | 2020-01-31 | Singapore | 13 | 0 | 0 | 1/31/2020 23:59 | |||||||
610 | 610 | 2021-12-02 | Singapore | 267150 | 735 | 0 | 1.2833 | 103.8333 | 2021-12-03 04:23:05 | Singapore | ||||
4626 | 4626 | 2021-10-28 | Singapore | 187851 | 364 | 0 | 1.2833 | 103.8333 | 2021-10-29 04:22:03 | Singapore | ||||
8605 | 8605 | 2020-10-25 | Singapore | 57970 | 28 | 57858 | 84 | 1.2833 | 103.8333 | 2020-10-26 04:25:02 | Singapore | |||
12616 | 12616 | 2021-01-26 | Singapore | 59366 | 29 | 59086 | 251 | 1.2833 | 103.8333 | 2021-01-27 05:23:41 | Singapore | |||
16634 | 16634 | 2021-09-18 | Singapore | 76792 | 60 | 0 | 1.2833 | 103.8333 | 2021-09-19 04:21:34 | Singapore | ||||
20647 | 20647 | 2021-05-28 | Singapore | 61970 | 32 | 61407 | 531 | 1.2833 | 103.8333 | 2021-05-29 04:20:41 | Singapore | |||
24681 | 24681 | 2022-03-20 | Singapore | 1015017 | 1198 | 0 | 1.2833 | 103.8333 | 2022-03-21 04:20:50 | Singapore | ||||
28696 | 28696 | 2021-11-11 | Singapore | 230077 | 548 | 0 | 1.2833 | 103.8333 | 2021-11-12 04:22:01 | Singapore | ||||
32695 | 32695 | 2021-08-25 | Singapore | 66812 | 52 | 0 | 1.2833 | 103.8333 | 2021-08-26 04:21:28 | Singapore | ||||
36706 | 36706 | 2021-04-12 | Singapore | 60678 | 30 | 60357 | 291 | 1.2833 | 103.8333 | 2021-04-13 04:20:37 | Singapore | |||
40163 | 40163 | 2020-03-05 | Singapore | 117 | 0 | 78 | 1.2833 | 103.8333 | 2020-03-05T13:43:04 | |||||
43309 | 43309 | 2020-04-13 | Singapore | 2918 | 9 | 586 | 2323 | 1.2833 | 103.8333 | 2020-04-13 23:07:34 | Singapore | |||
43988 | 43988 | 2021-11-02 | Singapore | 204340 | 430 | 0 | 1.2833 | 103.8333 | 2021-11-03 06:22:09 | Singapore | ||||
50408 | 50408 | 2020-04-17 | Singapore | 5050 | 11 | 708 | 4331 | 1.2833 | 103.8333 | 2020-04-17 23:30:32 | Singapore | |||
51068 | 51068 | 2021-05-29 | Singapore | 62003 | 32 | 61423 | 548 | 1.2833 | 103.8333 | 2021-05-30 04:20:55 | Singapore | |||
55081 | 55081 | 2021-03-07 | Singapore | 60033 | 29 | 59894 | 110 | 1.2833 | 103.8333 | 2021-03-08 05:24:48 | Singapore | |||
62367 | 62367 | 2020-07-23 | Singapore | 49098 | 27 | 45015 | 4056 | 1.2833 | 103.8333 | 2020-07-24 05:30:40 | Singapore | |||
62506 | 62506 | 2020-03-07 | Singapore | 138 | 0 | 78 | 1.2833 | 103.8333 | 2020-03-07T17:53:03 | |||||
63345 | 63345 | 2022-11-12 | Singapore | 2138598 | 1694 | 0 | 1.2833 | 103.8333 | 2022-11-13 04:21:14 | Singapore | ||||
67340 | 67340 | 2021-09-01 | Singapore | 67800 | 55 | 0 | 1.2833 | 103.8333 | 2021-09-02 04:21:15 | Singapore | ||||
71371 | 71371 | 2022-02-07 | Singapore | 405629 | 874 | 0 | 1.2833 | 103.8333 | 2022-02-08 04:21:15 | Singapore | ||||
75364 | 75364 | 2020-12-03 | Singapore | 58239 | 29 | 58145 | 65 | 1.2833 | 103.8333 | 2020-12-04 05:27:27 | Singapore | |||
79361 | 79361 | 2020-10-14 | Singapore | 57889 | 28 | 57752 | 109 | 1.2833 | 103.8333 | 2020-10-15 04:24:28 | Singapore | |||
83371 | 83371 | 2021-05-25 | Singapore | 61890 | 32 | 61329 | 529 | 1.2833 | 103.8333 | 2021-05-26 04:20:35 | Singapore | |||
87405 | 87405 | 2021-11-09 | Singapore | 224200 | 523 | 0 | 1.2833 | 103.8333 | 2021-11-10 04:21:38 | Singapore | ||||
91423 | 91423 | 2022-07-23 | Singapore | 1652981 | 1472 | 0 | 1.2833 | 103.8333 | 2022-07-24 04:20:47 | Singapore | ||||
98731 | 98731 | 2020-08-04 | Singapore | 53346 | 27 | 47454 | 5865 | 1.2833 | 103.8333 | 2020-08-05 04:34:43 | Singapore | |||
98833 | 98833 | 2020-03-04 | Singapore | 110 | 0 | 78 | 1.2833 | 103.8333 | 2020-03-03T15:23:03 | |||||
99606 | 99606 | 2022-01-14 | Singapore | 290030 | 840 | 0 | 1.2833 | 103.8333 | 2022-01-15 04:21:07 | Singapore | ||||
103605 | 103605 | 2021-08-15 | Singapore | 66172 | 44 | 0 | 1.2833 | 103.8333 | 2021-08-16 04:21:31 | Singapore | ||||
107730 | 107730 | 2021-06-19 | Singapore | 62403 | 34 | 62023 | 346 | 1.2833 | 103.8333 | 2021-06-20 04:21:48 | Singapore | |||
114349 | 114349 | 2020-05-08 | Singapore | 21707 | 20 | 2040 | 19647 | 1.2833 | 103.8333 | 2020-05-09 02:32:35 | Singapore | |||
115033 | 115033 | 2022-09-06 | Singapore | 1850015 | 1596 | 0 | 1.2833 | 103.8333 | 2022-09-07 04:20:59 | Singapore | ||||
122322 | 122322 | 2020-07-19 | Singapore | 47912 | 27 | 44086 | 3799 | 1.2833 | 103.8333 | 2020-07-20 05:34:40 | Singapore | |||
122979 | 122979 | 2020-11-18 | Singapore | 58135 | 28 | 58046 | 61 | 1.2833 | 103.8333 | 2020-11-19 05:25:23 | Singapore | |||
127013 | 127013 | 2022-01-09 | Singapore | 285647 | 838 | 0 | 1.2833 | 103.8333 | 2022-01-10 04:22:07 | Singapore | ||||
131033 | 131033 | 2022-10-04 | Singapore | 1924139 | 1624 | 0 | 1.2833 | 103.8333 | 2022-10-05 04:23:06 | Singapore | ||||
137572 | 137572 | 2020-04-29 | Singapore | 15641 | 14 | 1188 | 14439 | 1.2833 | 103.8333 | 2020-04-30 02:32:27 | Singapore | |||
138251 | 138251 | 2021-12-04 | Singapore | 268659 | 746 | 0 | 1.2833 | 103.8333 | 2021-12-05 04:22:25 | Singapore | ||||
142269 | 142269 | 2022-07-09 | Singapore | 1523881 | 1428 | 0 | 1.2833 | 103.8333 | 2022-07-10 04:20:54 | Singapore | ||||
146245 | 146245 | 2020-08-15 | Singapore | 55661 | 27 | 51521 | 4113 | 1.2833 | 103.8333 | 2020-08-16 04:27:42 | Singapore | |||
150264 | 150264 | 2021-11-29 | Singapore | 263486 | 710 | 0 | 1.2833 | 103.8333 | 2021-11-30 04:22:53 | Singapore | ||||
154258 | 154258 | 2021-01-08 | Singapore | 58836 | 29 | 58580 | 227 | 1.2833 | 103.8333 | 2021-01-09 05:22:18 | Singapore | |||
158293 | 158293 | 2022-03-29 | Singapore | 1085094 | 1258 | 0 | 1.2833 | 103.8333 | 2022-03-30 04:20:45 | Singapore | ||||
162308 | 162308 | 2021-11-19 | Singapore | 248587 | 641 | 0 | 1.2833 | 103.8333 | 2021-11-20 04:22:17 | Singapore | ||||
166326 | 166326 | 2022-06-21 | Singapore | 1378090 | 1405 | 0 | 1.2833 | 103.8333 | 2022-06-22 04:20:54 | Singapore | ||||
170320 | 170320 | 2021-04-16 | Singapore | 60769 | 30 | 60446 | 293 | 1.2833 | 103.8333 | 2021-04-17 04:20:40 | Singapore | |||
177640 | 177640 | 2020-07-27 | Singapore | 50838 | 27 | 45692 | 5119 | 1.2833 | 103.8333 | 2020-07-28 04:58:43 | Singapore | |||
178305 | 178305 | 2021-09-02 | Singapore | 67991 | 55 | 0 | 1.2833 | 103.8333 | 2021-09-03 04:21:20 | Singapore | ||||
182316 | 182316 | 2021-02-21 | Singapore | 59869 | 29 | 59731 | 109 | 1.2833 | 103.8333 | 2021-02-22 05:24:21 | Singapore | |||
186351 | 186351 | 2022-02-13 | Singapore | 469495 | 897 | 0 | 1.2833 | 103.8333 | 2022-02-14 04:20:51 | Singapore | ||||
190344 | 190344 | 2021-01-11 | Singapore | 58929 | 29 | 58668 | 232 | 1.2833 | 103.8333 | 2021-01-12 05:22:15 | Singapore | |||
194340 | 194340 | 2020-08-31 | Singapore | 56812 | 27 | 55658 | 1127 | 1.2833 | 103.8333 | 2020-09-01 04:28:31 | Singapore | |||
198542 | 198542 | 2022-10-19 | Singapore | 2037947 | 1654 | 0 | 1.2833 | 103.8333 | 2022-10-20 04:22:59 | Singapore | ||||
202531 | 202531 | 2020-12-25 | Singapore | 58509 | 29 | 58352 | 128 | 1.2833 | 103.8333 | 2020-12-26 05:22:28 | Singapore | |||
206527 | 206527 | 2020-08-19 | Singapore | 56031 | 27 | 52810 | 3194 | 1.2833 | 103.8333 | 2020-08-20 04:27:43 | Singapore | |||
210514 | 210514 | 2020-10-29 | Singapore | 57994 | 28 | 57899 | 67 | 1.2833 | 103.8333 | 2020-10-30 04:24:49 | Singapore | |||
217580 | 217580 | 2020-06-08 | Singapore | 38296 | 25 | 25368 | 12903 | 1.2833 | 103.8333 | 2020-06-09 03:33:03 | Singapore | |||
218263 | 218263 | 2022-12-26 | Singapore | 2197084 | 1711 | 0 | 1.2833 | 103.8333 | 2022-12-27 04:21:07 | Singapore | ||||
222276 | 222276 | 2022-05-09 | Singapore | 1220193 | 1352 | 0 | 1.2833 | 103.8333 | 2022-05-10 04:20:50 | Singapore | ||||
228826 | 228826 | 2020-04-30 | Singapore | 16169 | 15 | 1244 | 14910 | 1.2833 | 103.8333 | 2020-05-01 02:32:28 | Singapore | |||
229508 | 229508 | 2022-05-31 | Singapore | 1303294 | 1389 | 0 | 1.2833 | 103.8333 | 2022-06-01 04:20:55 | 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]);