johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where country_or_region = "Singapore" and deaths = 30 sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36706 | 36706 | 2021-04-12 | Singapore | 60678 | 30 | 60357 | 291 | 1.2833 | 103.8333 | 2021-04-13 04:20:37 | Singapore | |||
170320 | 170320 | 2021-04-16 | Singapore | 60769 | 30 | 60446 | 293 | 1.2833 | 103.8333 | 2021-04-17 04:20:40 | Singapore | |||
241531 | 241531 | 2021-04-02 | Singapore | 60450 | 30 | 60176 | 244 | 1.2833 | 103.8333 | 2021-04-03 04:20:44 | Singapore | |||
380469 | 380469 | 2021-04-30 | Singapore | 61145 | 30 | 60751 | 364 | 1.2833 | 103.8333 | 2021-05-01 04:20:47 | Singapore | |||
388499 | 388499 | 2021-04-04 | Singapore | 60478 | 30 | 60202 | 246 | 1.2833 | 103.8333 | 2021-04-05 04:20:35 | Singapore | |||
605965 | 605965 | 2021-04-09 | Singapore | 60601 | 30 | 60304 | 267 | 1.2833 | 103.8333 | 2021-04-10 04:20:59 | Singapore | |||
638200 | 638200 | 2021-03-31 | Singapore | 60381 | 30 | 60149 | 202 | 1.2833 | 103.8333 | 2021-04-01 04:27:05 | Singapore | |||
702681 | 702681 | 2021-03-16 | Singapore | 60128 | 30 | 59984 | 114 | 1.2833 | 103.8333 | 2021-03-17 05:25:07 | Singapore | |||
888396 | 888396 | 2021-04-26 | Singapore | 61051 | 30 | 60682 | 339 | 1.2833 | 103.8333 | 2021-04-27 04:20:52 | Singapore | |||
955141 | 955141 | 2021-04-25 | Singapore | 61006 | 30 | 60662 | 314 | 1.2833 | 103.8333 | 2021-04-26 04:21:04 | Singapore | |||
983225 | 983225 | 2021-04-17 | Singapore | 60808 | 30 | 60463 | 315 | 1.2833 | 103.8333 | 2021-04-18 04:20:41 | Singapore | |||
1204083 | 1204083 | 2021-03-22 | Singapore | 60208 | 30 | 60051 | 127 | 1.2833 | 103.8333 | 2021-03-23 05:26:18 | Singapore | |||
1219844 | 1219844 | 2021-03-27 | Singapore | 60288 | 30 | 60113 | 145 | 1.2833 | 103.8333 | 2021-03-28 05:28:10 | Singapore | |||
1290282 | 1290282 | 2021-03-29 | Singapore | 60321 | 30 | 60131 | 160 | 1.2833 | 103.8333 | 2021-03-30 04:26:23 | Singapore | |||
1302328 | 1302328 | 2021-04-01 | Singapore | 60407 | 30 | 60161 | 216 | 1.2833 | 103.8333 | 2021-04-02 04:20:36 | Singapore | |||
1409319 | 1409319 | 2021-04-23 | Singapore | 60943 | 30 | 60613 | 300 | 1.2833 | 103.8333 | 2021-04-24 04:20:38 | Singapore | |||
1536204 | 1536204 | 2021-03-28 | Singapore | 60300 | 30 | 60122 | 148 | 1.2833 | 103.8333 | 2021-03-29 04:28:35 | Singapore | |||
1568382 | 1568382 | 2021-04-22 | Singapore | 60904 | 30 | 60603 | 271 | 1.2833 | 103.8333 | 2021-04-23 04:20:52 | Singapore | |||
1580428 | 1580428 | 2021-03-13 | Singapore | 60088 | 30 | 59961 | 97 | 1.2833 | 103.8333 | 2021-03-14 05:25:37 | Singapore | |||
1636592 | 1636592 | 2021-04-29 | Singapore | 61121 | 30 | 60718 | 373 | 1.2833 | 103.8333 | 2021-04-30 04:21:03 | Singapore | |||
1732771 | 1732771 | 2021-03-14 | Singapore | 60105 | 30 | 59968 | 107 | 1.2833 | 103.8333 | 2021-03-15 05:25:51 | Singapore | |||
1744815 | 1744815 | 2021-03-20 | Singapore | 60184 | 30 | 60022 | 132 | 1.2833 | 103.8333 | 2021-03-21 05:25:44 | Singapore | |||
1798915 | 1798915 | 2021-03-23 | Singapore | 60221 | 30 | 60063 | 128 | 1.2833 | 103.8333 | 2021-03-24 05:25:40 | Singapore | |||
1842221 | 1842221 | 2021-04-14 | Singapore | 60719 | 30 | 60392 | 297 | 1.2833 | 103.8333 | 2021-04-15 04:20:54 | Singapore | |||
1881262 | 1881262 | 2021-03-26 | Singapore | 60265 | 30 | 60103 | 132 | 1.2833 | 103.8333 | 2021-03-27 05:25:04 | Singapore | |||
1980892 | 1980892 | 2021-03-25 | Singapore | 60253 | 30 | 60086 | 137 | 1.2833 | 103.8333 | 2021-03-26 05:26:55 | Singapore | |||
2020999 | 2020999 | 2021-04-20 | Singapore | 60865 | 30 | 60540 | 295 | 1.2833 | 103.8333 | 2021-04-21 04:21:14 | Singapore | |||
2056159 | 2056159 | 2021-03-15 | Singapore | 60117 | 30 | 59974 | 113 | 1.2833 | 103.8333 | 2021-03-16 05:25:13 | Singapore | |||
2247671 | 2247671 | 2021-04-07 | Singapore | 60554 | 30 | 60260 | 264 | 1.2833 | 103.8333 | 2021-04-08 04:21:13 | Singapore | |||
2411120 | 2411120 | 2021-04-19 | Singapore | 60851 | 30 | 60503 | 318 | 1.2833 | 103.8333 | 2021-04-20 04:20:41 | Singapore | |||
2549151 | 2549151 | 2021-04-15 | Singapore | 60735 | 30 | 60417 | 288 | 1.2833 | 103.8333 | 2021-04-16 04:20:46 | Singapore | |||
2571955 | 2571955 | 2021-04-13 | Singapore | 60692 | 30 | 60374 | 288 | 1.2833 | 103.8333 | 2021-04-14 04:20:41 | Singapore | |||
2646029 | 2646029 | 2021-04-08 | Singapore | 60575 | 30 | 60284 | 261 | 1.2833 | 103.8333 | 2021-04-09 04:21:13 | Singapore | |||
2781270 | 2781270 | 2021-03-24 | Singapore | 60236 | 30 | 60078 | 128 | 1.2833 | 103.8333 | 2021-03-25 05:27:00 | Singapore | |||
2983533 | 2983533 | 2021-04-10 | Singapore | 60633 | 30 | 60322 | 281 | 1.2833 | 103.8333 | 2021-04-11 04:20:56 | Singapore | |||
3003581 | 3003581 | 2021-04-06 | Singapore | 60519 | 30 | 60239 | 250 | 1.2833 | 103.8333 | 2021-04-07 04:20:53 | Singapore | |||
3085576 | 3085576 | 2021-04-05 | Singapore | 60495 | 30 | 60214 | 251 | 1.2833 | 103.8333 | 2021-04-06 04:20:32 | Singapore | |||
3129797 | 3129797 | 2021-04-18 | Singapore | 60831 | 30 | 60485 | 316 | 1.2833 | 103.8333 | 2021-04-19 04:20:57 | Singapore | |||
3242603 | 3242603 | 2021-04-21 | Singapore | 60880 | 30 | 60576 | 274 | 1.2833 | 103.8333 | 2021-04-22 04:20:53 | Singapore | |||
3369605 | 3369605 | 2021-03-21 | Singapore | 60196 | 30 | 60038 | 128 | 1.2833 | 103.8333 | 2021-03-22 05:25:43 | Singapore | |||
3393671 | 3393671 | 2021-04-28 | Singapore | 61086 | 30 | 60718 | 338 | 1.2833 | 103.8333 | 2021-04-29 04:20:55 | Singapore | |||
3421195 | 3421195 | 2021-03-19 | Singapore | 60167 | 30 | 60019 | 118 | 1.2833 | 103.8333 | 2021-03-20 05:25:46 | Singapore | |||
3453133 | 3453133 | 2021-03-18 | Singapore | 60152 | 30 | 60014 | 108 | 1.2833 | 103.8333 | 2021-03-19 05:26:09 | Singapore | |||
3621357 | 3621357 | 2021-03-17 | Singapore | 60137 | 30 | 60001 | 106 | 1.2833 | 103.8333 | 2021-03-18 05:26:22 | Singapore | |||
3643829 | 3643829 | 2021-03-30 | Singapore | 60347 | 30 | 60138 | 179 | 1.2833 | 103.8333 | 2021-03-31 04:26:25 | Singapore | |||
3702387 | 3702387 | 2021-04-27 | Singapore | 61063 | 30 | 60704 | 329 | 1.2833 | 103.8333 | 2021-04-28 04:20:32 | Singapore | |||
3710415 | 3710415 | 2021-04-03 | Singapore | 60468 | 30 | 60185 | 253 | 1.2833 | 103.8333 | 2021-04-04 04:20:49 | Singapore | |||
3883865 | 3883865 | 2021-04-11 | Singapore | 60653 | 30 | 60335 | 288 | 1.2833 | 103.8333 | 2021-04-12 04:21:00 | Singapore | |||
3924288 | 3924288 | 2021-04-24 | Singapore | 60966 | 30 | 60629 | 307 | 1.2833 | 103.8333 | 2021-04-25 04:20:32 | 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]);