johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where active = 7 and country_or_region = "Solomon Islands" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
country_or_region 1
- Solomon Islands · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1528176 | 1528176 | 2021-02-09 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-10 05:22:41 | Solomon Islands | |||
613967 | 613967 | 2021-02-08 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-09 05:23:30 | Solomon Islands | |||
1672736 | 1672736 | 2021-02-07 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-08 05:22:39 | Solomon Islands | |||
975197 | 975197 | 2021-02-06 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-07 05:23:00 | Solomon Islands | |||
1588455 | 1588455 | 2021-02-05 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-06 05:23:55 | Solomon Islands | |||
790662 | 790662 | 2021-02-04 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-05 05:22:38 | Solomon Islands | |||
340554 | 340554 | 2021-02-03 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-04 05:22:26 | Solomon Islands | |||
1684780 | 1684780 | 2021-02-02 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-03 05:22:52 | Solomon Islands | |||
1676750 | 1676750 | 2021-02-01 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-02 05:22:49 | Solomon Islands | |||
1460038 | 1460038 | 2021-01-31 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-02-01 05:22:53 | Solomon Islands | |||
2211946 | 2211946 | 2021-01-30 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-31 05:22:42 | Solomon Islands | |||
1897433 | 1897433 | 2021-01-29 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-30 05:22:49 | Solomon Islands | |||
2482249 | 2482249 | 2021-01-28 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-29 05:22:23 | Solomon Islands | |||
3153884 | 3153884 | 2021-01-27 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-28 05:22:24 | Solomon Islands | |||
12619 | 12619 | 2021-01-26 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-27 05:23:41 | Solomon Islands | |||
2567943 | 2567943 | 2021-01-25 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-26 05:22:02 | Solomon Islands | |||
1759575 | 1759575 | 2021-01-24 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-25 05:22:16 | Solomon Islands | |||
2427182 | 2427182 | 2021-01-23 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-24 05:22:35 | Solomon Islands | |||
2467084 | 2467084 | 2021-01-22 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-23 05:22:03 | Solomon Islands | |||
435635 | 435635 | 2021-01-21 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-22 05:22:10 | Solomon Islands | |||
1094366 | 1094366 | 2021-01-20 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-21 05:22:01 | Solomon Islands | |||
908456 | 908456 | 2021-01-19 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-20 05:21:54 | Solomon Islands | |||
237519 | 237519 | 2021-01-18 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-19 05:22:15 | Solomon Islands | |||
3503636 | 3503636 | 2021-01-17 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-18 05:22:34 | Solomon Islands | |||
3101719 | 3101719 | 2021-01-16 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-17 05:22:17 | Solomon Islands | |||
3515681 | 3515681 | 2021-01-15 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-16 05:22:40 | Solomon Islands | |||
3879854 | 3879854 | 2021-01-14 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-15 05:22:24 | Solomon Islands | |||
3308481 | 3308481 | 2021-01-13 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-14 05:22:32 | Solomon Islands | |||
774626 | 774626 | 2021-01-12 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-13 05:22:15 | Solomon Islands | |||
190347 | 190347 | 2021-01-11 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-12 05:22:15 | Solomon Islands | |||
2626150 | 2626150 | 2021-01-10 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-11 05:21:50 | Solomon Islands | |||
3900238 | 3900238 | 2021-01-09 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-10 05:22:12 | Solomon Islands | |||
154261 | 154261 | 2021-01-08 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-09 05:22:18 | Solomon Islands | |||
2541685 | 2541685 | 2021-01-07 | Solomon Islands | 17 | 0 | 10 | 7 | -9.6457 | 160.1562 | 2021-01-08 05:22:42 | 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]);