johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where country_or_region = "Singapore" and deaths = 31 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2256009 | 2256009 | 2021-05-19 | Singapore | 61689 | 31 | 61183 | 475 | 1.2833 | 103.8333 | 2021-05-20 04:21:05 | Singapore | |||
2391047 | 2391047 | 2021-05-18 | Singapore | 61651 | 31 | 61134 | 486 | 1.2833 | 103.8333 | 2021-05-19 04:20:42 | Singapore | |||
3574872 | 3574872 | 2021-05-17 | Singapore | 61613 | 31 | 61123 | 459 | 1.2833 | 103.8333 | 2021-05-18 04:20:33 | Singapore | |||
2939602 | 2939602 | 2021-05-16 | Singapore | 61585 | 31 | 61104 | 450 | 1.2833 | 103.8333 | 2021-05-17 04:20:34 | Singapore | |||
1873232 | 1873232 | 2021-05-15 | Singapore | 61536 | 31 | 61062 | 443 | 1.2833 | 103.8333 | 2021-05-16 04:20:49 | Singapore | |||
1082201 | 1082201 | 2021-05-14 | Singapore | 61505 | 31 | 61047 | 427 | 1.2833 | 103.8333 | 2021-05-15 04:20:58 | Singapore | |||
3054467 | 3054467 | 2021-05-13 | Singapore | 61453 | 31 | 61029 | 393 | 1.2833 | 103.8333 | 2021-05-14 04:20:41 | Singapore | |||
2004937 | 2004937 | 2021-05-12 | Singapore | 61419 | 31 | 61006 | 382 | 1.2833 | 103.8333 | 2021-05-13 04:20:51 | Singapore | |||
3954768 | 3954768 | 2021-05-11 | Singapore | 61403 | 31 | 60975 | 397 | 1.2833 | 103.8333 | 2021-05-12 04:21:29 | Singapore | |||
2821047 | 2821047 | 2021-05-10 | Singapore | 61378 | 31 | 60953 | 394 | 1.2833 | 103.8333 | 2021-05-11 04:20:41 | Singapore | |||
1425379 | 1425379 | 2021-05-09 | Singapore | 61359 | 31 | 60933 | 395 | 1.2833 | 103.8333 | 2021-05-10 04:20:38 | Singapore | |||
1552247 | 1552247 | 2021-05-08 | Singapore | 61331 | 31 | 60912 | 388 | 1.2833 | 103.8333 | 2021-05-09 04:20:35 | Singapore | |||
2502305 | 2502305 | 2021-05-07 | Singapore | 61311 | 31 | 60906 | 374 | 1.2833 | 103.8333 | 2021-05-08 04:21:04 | Singapore | |||
3113761 | 3113761 | 2021-05-06 | Singapore | 61286 | 31 | 60873 | 382 | 1.2833 | 103.8333 | 2021-05-07 04:20:40 | Singapore | |||
646228 | 646228 | 2021-05-05 | Singapore | 61268 | 31 | 60844 | 393 | 1.2833 | 103.8333 | 2021-05-06 04:20:38 | Singapore | |||
3675928 | 3675928 | 2021-05-04 | Singapore | 61252 | 31 | 60823 | 398 | 1.2833 | 103.8333 | 2021-05-05 04:20:43 | Singapore | |||
2761195 | 2761195 | 2021-05-03 | Singapore | 61235 | 31 | 60806 | 398 | 1.2833 | 103.8333 | 2021-05-04 04:20:34 | Singapore | |||
2451048 | 2451048 | 2021-05-02 | Singapore | 61218 | 31 | 60786 | 401 | 1.2833 | 103.8333 | 2021-05-03 04:20:39 | Singapore | |||
2825061 | 2825061 | 2021-05-01 | Singapore | 61179 | 31 | 60765 | 383 | 1.2833 | 103.8333 | 2021-05-02 04:20:48 | 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]);