johns_hopkins_csse_daily_reports

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

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

✎ View and edit SQL

This data as json, CSV (advanced)

country_or_region

  • Singapore · 164 ✖

province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
312273 312273 2020-07-04 Singapore       44664 26 40117 4521 1.2833 103.8333 2020-07-05 04:33:46 Singapore
252707 252707 2020-07-03 Singapore       44479 26 39769 4684 1.2833 103.8333 2020-07-04 04:33:51 Singapore
204089 204089 2020-07-02 Singapore       44310 26 39429 4855 1.2833 103.8333 2020-07-03 04:33:54 Singapore
160330 160330 2020-07-01 Singapore       44122 26 39011 5085 1.2833 103.8333 2020-07-02 04:33:46 Singapore
326325 326325 2020-06-30 Singapore       43907 26 38500 5381 1.2833 103.8333 2020-07-01 04:33:52 Singapore
50129 50129 2020-06-29 Singapore       43661 26 37985 5650 1.2833 103.8333 2020-06-30 04:33:48 Singapore
56835 56835 2020-06-28 Singapore       43459 26 37508 5925 1.2833 103.8333 2020-06-29 04:33:44 Singapore
80286 80286 2020-06-27 Singapore       43246 26 37163 6057 1.2833 103.8333 2020-06-28 04:34:04 Singapore
94474 94474 2020-06-26 Singapore       42955 26 36825 6104 1.2833 103.8333 2020-06-27 04:33:35 Singapore
359906 359906 2020-06-25 Singapore       42736 26 36604 6106 1.2833 103.8333 2020-06-26 04:33:43 Singapore
115827 115827 2020-06-24 Singapore       42623 26 36299 6298 1.2833 103.8333 2020-06-25 05:26:54 Singapore
105429 105429 2020-06-23 Singapore       42432 26 35995 6411 1.2833 103.8333 2020-06-24 04:33:28 Singapore
180093 180093 2020-06-22 Singapore       42313 26 35590 6697 1.2833 103.8333 2020-06-23 04:33:22 Singapore
186930 186930 2020-06-21 Singapore       42095 26 34942 7127 1.2833 103.8333 2020-06-22 04:33:20 Singapore
235359 235359 2020-06-20 Singapore       41833 26 34224 7583 1.2833 103.8333 2020-06-21 04:33:19 Singapore
86917 86917 2020-06-19 Singapore       41615 26 33459 8130 1.2833 103.8333 2020-06-20 04:33:19 Singapore
6574 6574 2020-06-18 Singapore       41473 26 32712 8735 1.2833 103.8333 2020-06-19 04:33:17 Singapore
39434 39434 2020-06-17 Singapore       41216 26 31938 9252 1.2833 103.8333 2020-06-18 04:33:18 Singapore
231606 231606 2020-06-16 Singapore       40969 26 31163 9780 1.2833 103.8333 2020-06-17 04:33:21 Singapore
131129 131129 2020-06-15 Singapore       40818 26 30366 10426 1.2833 103.8333 2020-06-16 04:33:09 Singapore
330314 330314 2020-06-14 Singapore       40604 26 29589 10989 1.2833 103.8333 2020-06-15 03:33:14 Singapore
221442 221442 2020-06-13 Singapore       40197 26 28808 11363 1.2833 103.8333 2020-06-14 03:33:15 Singapore
152818 152818 2020-06-12 Singapore       39850 25 28040 11785 1.2833 103.8333 2020-06-13 03:33:14 Singapore
156541 156541 2020-06-11 Singapore       39387 25 27286 12076 1.2833 103.8333 2020-06-12 05:09:52 Singapore
148805 148805 2020-06-10 Singapore       38965 25 26532 12408 1.2833 103.8333 2020-06-11 03:33:41 Singapore
271480 271480 2020-06-09 Singapore       38514 25 25877 12612 1.2833 103.8333 2020-06-10 04:07:00 Singapore
98435 98435 2020-06-08 Singapore       38296 25 25368 12903 1.2833 103.8333 2020-06-09 03:33:03 Singapore
145017 145017 2020-06-07 Singapore       37910 25 24886 12999 1.2833 103.8333 2020-06-08 03:33:22 Singapore
260168 260168 2020-06-06 Singapore       37527 25 24559 12943 1.2833 103.8333 2020-06-07 03:53:30 Singapore
256376 256376 2020-06-05 Singapore       37183 24 24209 12950 1.2833 103.8333 2020-06-06 02:33:00 Singapore
170030 170030 2020-06-04 Singapore       36922 24 23904 12994 1.2833 103.8333 2020-06-05 02:33:06 Singapore
319276 319276 2020-06-03 Singapore       36405 24 23582 12799 1.2833 103.8333 2020-06-04 02:33:14 Singapore
291880 291880 2020-06-02 Singapore       35836 24 23175 12637 1.2833 103.8333 2020-06-03 02:33:13 Singapore
193637 193637 2020-06-01 Singapore       35292 24 22466 12802 1.2833 103.8333 2020-06-02 02:33:08 Singapore
90440 90440 2020-05-31 Singapore       34884 23 21699 13162 1.2833 103.8333 2020-06-01 02:32:46 Singapore
245464 245464 2020-05-30 Singapore       34366 23 20727 13616 1.2833 103.8333 2020-05-31 02:32:45 Singapore
207749 207749 2020-05-29 Singapore       33860 23 19631 14206 1.2833 103.8333 2020-05-30 02:32:48 Singapore
22725 22725 2020-05-28 Singapore       33249 23 18294 14932 1.2833 103.8333 2020-05-29 02:32:50 Singapore
298989 298989 2020-05-27 Singapore       32876 23 17276 15577 1.2833 103.8333 2020-05-28 02:32:31 Singapore
46341 46341 2020-05-26 Singapore       32343 23 16444 15876 1.2833 103.8333 2020-05-27 02:32:31 Singapore
241939 241939 2020-05-25 Singapore       31960 23 15738 16199 1.2833 103.8333 2020-05-26 02:32:35 Singapore
200294 200294 2020-05-24 Singapore       31616 23 14876 16717 1.2833 103.8333 2020-05-25 02:32:44 Singapore
127380 127380 2020-05-23 Singapore       31068 23 13882 17163 1.2833 103.8333 2020-05-24 02:32:43 Singapore
19207 19207 2020-05-22 Singapore       30426 23 12995 17408 1.2833 103.8333 2020-05-23 02:32:42 Singapore
295500 295500 2020-05-21 Singapore       29812 23 12117 17672 1.2833 103.8333 2020-05-22 02:36:51 Singapore
112050 112050 2020-05-20 Singapore       29364 22 11207 18135 1.2833 103.8333 2020-05-21 02:32:48 Singapore
217698 217698 2020-05-19 Singapore       28794 22 10365 18407 1.2833 103.8333 2020-05-20 02:32:19 Singapore
315631 315631 2020-05-18 Singapore       28343 22 9835 18486 1.2833 103.8333 2020-05-19 02:32:18 Singapore
26032 26032 2020-05-17 Singapore       28038 22 9340 18676 1.2833 103.8333 2020-05-18 02:32:21 Singapore
267538 267538 2020-05-16 Singapore       27356 22 8342 18992 1.2833 103.8333 2020-05-17 02:32:32 Singapore
224739 224739 2020-05-15 Singapore       26891 21 7248 19622 1.2833 103.8333 2020-05-16 02:32:19 Singapore
166384 166384 2020-05-14 Singapore       26098 21 5973 20104 1.2833 103.8333 2020-05-15 02:33:02 Singapore
42783 42783 2020-05-13 Singapore       25346 21 4809 20516 1.2833 103.8333 2020-05-14 03:32:28 Singapore
263657 263657 2020-05-12 Singapore       24671 21 3851 20799 1.2833 103.8333 2020-05-13 03:32:26 Singapore
281619 281619 2020-05-11 Singapore       23822 21 3225 20576 1.2833 103.8333 2020-05-12 03:32:27 Singapore
302222 302222 2020-05-10 Singapore       23336 20 2721 20595 1.2833 103.8333 2020-05-11 02:32:30 Singapore
101664 101664 2020-05-09 Singapore       22460 20 2296 20144 1.2833 103.8333 2020-05-10 02:32:30 Singapore
108655 108655 2020-05-08 Singapore       21707 20 2040 19647 1.2833 103.8333 2020-05-09 02:32:35 Singapore
305445 305445 2020-05-07 Singapore       20939 20 1712 19207 1.2833 103.8333 2020-05-08 02:32:32 Singapore
138201 138201 2020-05-06 Singapore       20198 20 1634 18544 1.2833 103.8333 2020-05-07 02:32:28 Singapore
345936 345936 2020-05-05 Singapore       19410 18 1519 17873 1.2833 103.8333 2020-05-06 02:32:31 Singapore
284820 284820 2020-05-04 Singapore       18778 18 1457 17303 1.2833 103.8333 2020-05-05 02:32:34 Singapore
355863 355863 2020-05-03 Singapore       18205 18 1408 16779 1.2833 103.8333 2020-05-04 02:32:28 Singapore
333502 333502 2020-05-02 Singapore       17548 17 1347 16184 1.2833 103.8333 2020-05-03 02:32:28 Singapore
63458 63458 2020-05-01 Singapore       17101 16 1268 15817 1.2833 103.8333 2020-05-02 02:32:27 Singapore
196884 196884 2020-04-30 Singapore       16169 15 1244 14910 1.2833 103.8333 2020-05-01 02:32:28 Singapore
248632 248632 2020-04-29 Singapore       15641 14 1188 14439 1.2833 103.8333 2020-04-30 02:32:27 Singapore
173192 173192 2020-04-28 Singapore       14951 14 1128 13809 1.2833 103.8333 2020-04-29 02:32:29 Singapore
322527 322527 2020-04-27 Singapore       14423 14 1095 13314 1.2833 103.8333 2020-04-28 02:30:32 Singapore
134978 134978 2020-04-26 Singapore       13624 12 1060 12552 1.2833 103.8333 2020-04-27 02:30:33 Singapore
210947 210947 2020-04-25 Singapore       12693 12 1002 11679 1.2833 103.8333 2020-04-26 02:30:31 Singapore
352567 352567 2020-04-24 Singapore       12075 12 956 11107 1.2833 103.8333 2020-04-25 06:30:33 Singapore
227851 227851 2020-04-23 Singapore       11178 12 924 10242 1.2833 103.8333 2020-04-24 03:30:31 Singapore
238530 238530 2020-04-22 Singapore       10141 12 896 9233 1.2833 103.8333 2020-04-22 23:30:32 Singapore
342728 342728 2020-04-21 Singapore       9125 11 839 8275 1.2833 103.8333 2020-04-21 23:30:30 Singapore
336584 336584 2020-04-20 Singapore       8014 11 801 7202 1.2833 103.8333 2020-04-20 23:36:27 Singapore
189999 189999 2020-04-19 Singapore       6588 11 768 5809 1.2833 103.8333 2020-04-19 23:40:41 Singapore
339637 339637 2020-04-18 Singapore       5992 11 740 5241 1.2833 103.8333 2020-04-18 22:32:28 Singapore
69934 69934 2020-04-17 Singapore       5050 11 708 4331 1.2833 103.8333 2020-04-17 23:30:32 Singapore
141344 141344 2020-04-16 Singapore       4427 10 683 3734 1.2833 103.8333 2020-04-16 23:30:31 Singapore
15643 15643 2020-04-15 Singapore       3699 10 652 3037 1.2833 103.8333 2020-04-15 22:56:32 Singapore
76500 76500 2020-04-14 Singapore       3252 10 611 2631 1.2833 103.8333 2020-04-14 23:33:12 Singapore
29158 29158 2020-04-13 Singapore       2918 9 586 2323 1.2833 103.8333 2020-04-13 23:07:34 Singapore
118811 118811 2020-04-12 Singapore       2532 8 560 1964 1.2833 103.8333 2020-04-12 23:17:00 Singapore
32194 32194 2020-04-11 Singapore       2299 8 528 1763 1.2833 103.8333 2020-04-11 22:45:13 Singapore
183030 183030 2020-04-10 Singapore       2108 7 492 1609 1.2833 103.8333 2020-04-10 22:53:48 Singapore
73258 73258 2020-04-09 Singapore       1910 6 460 1444 1.2833 103.8333 2020-04-09 23:02:19 Singapore
83166 83166 2020-04-08 Singapore       1623 6 406 1211 1.2833 103.8333 2020-04-08 22:51:39 Singapore
2824 2824 2020-04-07 Singapore       1481 6 377 1098 1.2833 103.8333 2020-04-07 23:04:29 Singapore
308473 308473 2020-04-06 Singapore       1375 6 344 1025 1.2833 103.8333 4/6/20 23:21 Singapore
163090 163090 2020-04-05 Singapore       1309 6 320 983 1.2833 103.8333 2020-04-05 23:06:26 Singapore
176269 176269 2020-04-04 Singapore       1189 6 297 886 1.2833 103.8333 4/4/20 23:34 Singapore
52752 52752 2020-04-03 Singapore       1114 5 282 827 1.2833 103.8333 2020-04-03 22:46:20 Singapore
121383 121383 2020-04-02 Singapore       1049 4 266 779 1.2833 103.8333 4/2/20 23:25 Singapore
12620 12620 2020-04-01 Singapore       1000 3 245 752 1.2833 103.8333 2020-04-01 21:58:34 Singapore
123818 123818 2020-03-31 Singapore       926 3 240 683 1.2833 103.8333 2020-03-31 23:43:43 Singapore
60274 60274 2020-03-30 Singapore       879 3 228 648 1.2833 103.8333 3/30/20 22:52 Singapore
349450 349450 2020-03-29 Singapore       844 3 212 629 1.2833 103.8333 3/29/20 23:08 Singapore
66892 66892 2020-03-28 Singapore       802 2 198 602 1.2833 103.8333 3/28/20 23:05 Singapore
214387 214387 2020-03-27 Singapore       732 2 183 547 1.2833 103.8333 2020-03-27 23:23:03 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
);
Powered by Datasette · Query took 2340.994ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette