johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where country_or_region = "Singapore" and deaths = 36 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137830 | 3137830 | 2021-07-23 | Singapore | 63924 | 36 | 62587 | 1301 | 1.2833 | 103.8333 | 2021-07-24 00:21:36 | Singapore | |||
3476590 | 3476590 | 2021-07-22 | Singapore | 63791 | 36 | 62576 | 1179 | 1.2833 | 103.8333 | 2021-07-23 04:21:29 | Singapore | |||
3331809 | 3331809 | 2021-07-21 | Singapore | 63621 | 36 | 62560 | 1025 | 1.2833 | 103.8333 | 2021-07-22 04:21:19 | Singapore | |||
2371790 | 2371790 | 2021-07-20 | Singapore | 63440 | 36 | 62543 | 861 | 1.2833 | 103.8333 | 2021-07-21 04:21:40 | Singapore | |||
483869 | 483869 | 2021-07-19 | Singapore | 63245 | 36 | 62532 | 677 | 1.2833 | 103.8333 | 2021-07-20 04:21:48 | Singapore | |||
2674092 | 2674092 | 2021-07-18 | Singapore | 63073 | 36 | 62526 | 511 | 1.2833 | 103.8333 | 2021-07-19 04:21:24 | Singapore | |||
3706404 | 3706404 | 2021-07-17 | Singapore | 62981 | 36 | 62512 | 433 | 1.2833 | 103.8333 | 2021-07-18 04:22:07 | Singapore | |||
2947635 | 2947635 | 2021-07-16 | Singapore | 62913 | 36 | 62498 | 379 | 1.2833 | 103.8333 | 2021-07-17 04:22:22 | Singapore | |||
296291 | 296291 | 2021-07-15 | Singapore | 62852 | 36 | 62481 | 335 | 1.2833 | 103.8333 | 2021-07-16 04:21:22 | Singapore | |||
3632236 | 3632236 | 2021-07-14 | Singapore | 62804 | 36 | 62467 | 301 | 1.2833 | 103.8333 | 2021-07-15 04:21:48 | Singapore | |||
579111 | 579111 | 2021-07-13 | Singapore | 62744 | 36 | 62453 | 255 | 1.2833 | 103.8333 | 2021-07-14 04:21:35 | Singapore | |||
3741360 | 3741360 | 2021-07-12 | Singapore | 62718 | 36 | 62432 | 250 | 1.2833 | 103.8333 | 2021-07-13 04:21:18 | Singapore | |||
3659873 | 3659873 | 2021-07-11 | Singapore | 62692 | 36 | 62414 | 242 | 1.2833 | 103.8333 | 2021-07-12 04:21:34 | Singapore | |||
626157 | 626157 | 2021-07-10 | Singapore | 62684 | 36 | 62397 | 251 | 1.2833 | 103.8333 | 2021-07-11 04:21:43 | Singapore | |||
829876 | 829876 | 2021-07-09 | Singapore | 62678 | 36 | 62374 | 268 | 1.2833 | 103.8333 | 2021-07-10 04:21:25 | Singapore | |||
778640 | 778640 | 2021-07-08 | Singapore | 62668 | 36 | 62363 | 269 | 1.2833 | 103.8333 | 2021-07-09 04:21:21 | Singapore | |||
1440862 | 1440862 | 2021-07-07 | Singapore | 62652 | 36 | 62341 | 275 | 1.2833 | 103.8333 | 2021-07-08 04:21:26 | Singapore | |||
2693967 | 2693967 | 2021-07-06 | Singapore | 62640 | 36 | 62313 | 291 | 1.2833 | 103.8333 | 2021-07-07 04:21:20 | Singapore | |||
1932716 | 1932716 | 2021-07-05 | Singapore | 62630 | 36 | 62299 | 295 | 1.2833 | 103.8333 | 2021-07-06 04:21:32 | Singapore | |||
1165447 | 1165447 | 2021-07-04 | Singapore | 62617 | 36 | 62286 | 295 | 1.2833 | 103.8333 | 2021-07-05 04:21:28 | Singapore | |||
1495881 | 1495881 | 2021-07-03 | Singapore | 62606 | 36 | 62265 | 305 | 1.2833 | 103.8333 | 2021-07-04 04:21:38 | Singapore | |||
2072196 | 2072196 | 2021-07-02 | Singapore | 62599 | 36 | 62250 | 313 | 1.2833 | 103.8333 | 2021-07-03 04:21:37 | Singapore | |||
2765212 | 2765212 | 2021-07-01 | Singapore | 62589 | 36 | 62234 | 319 | 1.2833 | 103.8333 | 2021-07-02 04:21:47 | Singapore | |||
1893420 | 1893420 | 2021-06-30 | Singapore | 62579 | 36 | 62228 | 315 | 1.2833 | 103.8333 | 2021-07-01 04:21:19 | Singapore | |||
400543 | 400543 | 2021-06-29 | Singapore | 62563 | 36 | 62563 | 0 | 1.2833 | 103.8333 | 2021-06-30 04:21:41 | Singapore | |||
3125786 | 3125786 | 2021-06-28 | Singapore | 62553 | 36 | 62212 | 305 | 1.2833 | 103.8333 | 2021-06-29 04:21:28 | Singapore | |||
2590281 | 2590281 | 2021-06-27 | Singapore | 62544 | 36 | 62195 | 313 | 1.2833 | 103.8333 | 2021-06-28 04:21:29 | Singapore | |||
3958785 | 3958785 | 2021-06-26 | Singapore | 62530 | 36 | 62181 | 313 | 1.2833 | 103.8333 | 2021-06-27 04:21:39 | 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]);