johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where country_or_region = "Solomon Islands" and deaths = 146 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update, day (date), last_update (date)
country_or_region 1
- Solomon Islands · 22 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
229511 | 229511 | 2022-05-31 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-06-01 04:20:55 | Solomon Islands | ||||
3186276 | 3186276 | 2022-05-30 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-31 04:20:51 | Solomon Islands | ||||
3198425 | 3198425 | 2022-05-29 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-30 04:20:50 | Solomon Islands | ||||
2725303 | 2725303 | 2022-05-28 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-29 04:20:53 | Solomon Islands | ||||
1314484 | 1314484 | 2022-05-27 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-28 04:21:07 | Solomon Islands | ||||
1850276 | 1850276 | 2022-05-26 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-27 04:20:56 | Solomon Islands | ||||
2048152 | 2048152 | 2022-05-25 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-26 04:20:50 | Solomon Islands | ||||
2999590 | 2999590 | 2022-05-24 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-25 04:20:56 | Solomon Islands | ||||
3593311 | 3593311 | 2022-05-23 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-24 04:20:57 | Solomon Islands | ||||
622163 | 622163 | 2022-05-22 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-26 04:20:50 | Solomon Islands | ||||
1109859 | 1109859 | 2022-05-21 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-22 04:20:52 | Solomon Islands | ||||
1169483 | 1169483 | 2022-05-20 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-21 04:20:58 | Solomon Islands | ||||
3896246 | 3896246 | 2022-05-19 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-20 04:20:57 | Solomon Islands | ||||
1185030 | 1185030 | 2022-05-18 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-19 04:20:54 | Solomon Islands | ||||
3582927 | 3582927 | 2022-05-17 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-18 04:20:50 | Solomon Islands | ||||
1503884 | 1503884 | 2022-05-16 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-17 04:20:59 | Solomon Islands | ||||
2084243 | 2084243 | 2022-05-15 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-16 04:20:47 | Solomon Islands | ||||
3354953 | 3354953 | 2022-05-14 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-15 04:20:53 | Solomon Islands | ||||
658598 | 658598 | 2022-05-13 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-14 04:20:48 | Solomon Islands | ||||
2533681 | 2533681 | 2022-05-12 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-13 04:20:51 | Solomon Islands | ||||
3445127 | 3445127 | 2022-05-11 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-12 04:20:54 | Solomon Islands | ||||
3535744 | 3535744 | 2022-05-10 | Solomon Islands | 18174 | 146 | 0 | -9.6457 | 160.1562 | 2022-05-11 04:20:48 | Solomon Islands |
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]);