johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where country_or_region = "Singapore" and deaths = 26 sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3491775 | 3491775 | 2020-07-13 | Singapore | 46283 | 26 | 42541 | 3716 | 1.2833 | 103.8333 | 2020-07-14 04:34:46 | Singapore | |||
3738038 | 3738038 | 2020-07-12 | Singapore | 45961 | 26 | 42285 | 3650 | 1.2833 | 103.8333 | 2020-07-13 04:43:04 | Singapore | |||
3436433 | 3436433 | 2020-07-11 | Singapore | 45783 | 26 | 42026 | 3731 | 1.2833 | 103.8333 | 2020-07-12 04:34:30 | Singapore | |||
3237931 | 3237931 | 2020-07-10 | Singapore | 45614 | 26 | 41780 | 3808 | 1.2833 | 103.8333 | 2020-07-11 04:34:26 | Singapore | |||
1005916 | 1005916 | 2020-07-09 | Singapore | 45423 | 26 | 41645 | 3752 | 1.2833 | 103.8333 | 2020-07-10 04:34:24 | Singapore | |||
2223131 | 2223131 | 2020-07-08 | Singapore | 45298 | 26 | 41323 | 3949 | 1.2833 | 103.8333 | 2020-07-09 04:34:23 | Singapore | |||
887740 | 887740 | 2020-07-07 | Singapore | 45140 | 26 | 41002 | 4112 | 1.2833 | 103.8333 | 2020-07-08 05:33:48 | Singapore | |||
2685300 | 2685300 | 2020-07-06 | Singapore | 44983 | 26 | 40717 | 4240 | 1.2833 | 103.8333 | 2020-07-07 04:34:00 | Singapore | |||
415765 | 415765 | 2020-07-05 | Singapore | 44800 | 26 | 40441 | 4333 | 1.2833 | 103.8333 | 2020-07-06 04:33:57 | Singapore | |||
530327 | 530327 | 2020-07-04 | Singapore | 44664 | 26 | 40117 | 4521 | 1.2833 | 103.8333 | 2020-07-05 04:33:46 | Singapore | |||
2234988 | 2234988 | 2020-07-03 | Singapore | 44479 | 26 | 39769 | 4684 | 1.2833 | 103.8333 | 2020-07-04 04:33:51 | Singapore | |||
3045783 | 3045783 | 2020-07-02 | Singapore | 44310 | 26 | 39429 | 4855 | 1.2833 | 103.8333 | 2020-07-03 04:33:54 | Singapore | |||
303474 | 303474 | 2020-07-01 | Singapore | 44122 | 26 | 39011 | 5085 | 1.2833 | 103.8333 | 2020-07-02 04:33:46 | Singapore | |||
2974852 | 2974852 | 2020-06-30 | Singapore | 43907 | 26 | 38500 | 5381 | 1.2833 | 103.8333 | 2020-07-01 04:33:52 | Singapore | |||
2633329 | 2633329 | 2020-06-29 | Singapore | 43661 | 26 | 37985 | 5650 | 1.2833 | 103.8333 | 2020-06-30 04:33:48 | Singapore | |||
2306892 | 2306892 | 2020-06-28 | Singapore | 43459 | 26 | 37508 | 5925 | 1.2833 | 103.8333 | 2020-06-29 04:33:44 | Singapore | |||
2040227 | 2040227 | 2020-06-27 | Singapore | 43246 | 26 | 37163 | 6057 | 1.2833 | 103.8333 | 2020-06-28 04:34:04 | Singapore | |||
1136508 | 1136508 | 2020-06-26 | Singapore | 42955 | 26 | 36825 | 6104 | 1.2833 | 103.8333 | 2020-06-27 04:33:35 | Singapore | |||
2625495 | 2625495 | 2020-06-25 | Singapore | 42736 | 26 | 36604 | 6106 | 1.2833 | 103.8333 | 2020-06-26 04:33:43 | Singapore | |||
2701135 | 2701135 | 2020-06-24 | Singapore | 42623 | 26 | 36299 | 6298 | 1.2833 | 103.8333 | 2020-06-25 05:26:54 | Singapore | |||
1522820 | 1522820 | 2020-06-23 | Singapore | 42432 | 26 | 35995 | 6411 | 1.2833 | 103.8333 | 2020-06-24 04:33:28 | Singapore | |||
1511014 | 1511014 | 2020-06-22 | Singapore | 42313 | 26 | 35590 | 6697 | 1.2833 | 103.8333 | 2020-06-23 04:33:22 | Singapore | |||
3249753 | 3249753 | 2020-06-21 | Singapore | 42095 | 26 | 34942 | 7127 | 1.2833 | 103.8333 | 2020-06-22 04:33:20 | Singapore | |||
2438346 | 2438346 | 2020-06-20 | Singapore | 41833 | 26 | 34224 | 7583 | 1.2833 | 103.8333 | 2020-06-21 04:33:19 | Singapore | |||
1691924 | 1691924 | 2020-06-19 | Singapore | 41615 | 26 | 33459 | 8130 | 1.2833 | 103.8333 | 2020-06-20 04:33:19 | Singapore | |||
3683073 | 3683073 | 2020-06-18 | Singapore | 41473 | 26 | 32712 | 8735 | 1.2833 | 103.8333 | 2020-06-19 04:33:17 | Singapore | |||
1196276 | 1196276 | 2020-06-17 | Singapore | 41216 | 26 | 31938 | 9252 | 1.2833 | 103.8333 | 2020-06-18 04:33:18 | Singapore | |||
2387039 | 2387039 | 2020-06-16 | Singapore | 40969 | 26 | 31163 | 9780 | 1.2833 | 103.8333 | 2020-06-17 04:33:21 | Singapore | |||
287602 | 287602 | 2020-06-15 | Singapore | 40818 | 26 | 30366 | 10426 | 1.2833 | 103.8333 | 2020-06-16 04:33:09 | Singapore | |||
1837553 | 1837553 | 2020-06-14 | Singapore | 40604 | 26 | 29589 | 10989 | 1.2833 | 103.8333 | 2020-06-15 03:33:14 | Singapore | |||
3061605 | 3061605 | 2020-06-13 | Singapore | 40197 | 26 | 28808 | 11363 | 1.2833 | 103.8333 | 2020-06-14 03:33:15 | 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]);