johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where country_or_region = "Norway" and deaths = 256 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, last_update (date)
country_or_region 1
- Norway · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3531585 | 3531585 | 2020-08-12 | Norway | 9783 | 256 | 8857 | 670 | 60.472 | 8.4689 | 2020-08-13 04:29:15 | Norway | |||
662434 | 662434 | 2020-08-11 | Norway | 9751 | 256 | 8857 | 638 | 60.472 | 8.4689 | 2020-08-12 04:27:29 | Norway | |||
1920797 | 1920797 | 2020-08-10 | Norway | 9684 | 256 | 8857 | 571 | 60.472 | 8.4689 | 2020-08-11 04:35:08 | Norway | |||
3923606 | 3923606 | 2020-08-09 | Norway | 9638 | 256 | 8857 | 525 | 60.472 | 8.4689 | 2020-08-10 04:34:55 | Norway | |||
371774 | 371774 | 2020-08-08 | Norway | 9599 | 256 | 8857 | 486 | 60.472 | 8.4689 | 2020-08-09 04:34:54 | Norway | |||
458958 | 458958 | 2020-08-07 | Norway | 9551 | 256 | 8857 | 438 | 60.472 | 8.4689 | 2020-08-08 04:34:53 | Norway | |||
3612643 | 3612643 | 2020-08-06 | Norway | 9468 | 256 | 8857 | 355 | 60.472 | 8.4689 | 2020-08-07 04:35:11 | Norway | |||
3793473 | 3793473 | 2020-08-05 | Norway | 9409 | 256 | 8752 | 401 | 60.472 | 8.4689 | 2020-08-06 04:35:02 | Norway | |||
98709 | 98709 | 2020-08-04 | Norway | 9362 | 256 | 8752 | 354 | 60.472 | 8.4689 | 2020-08-05 04:34:43 | Norway | |||
2740592 | 2740592 | 2020-08-03 | Norway | 9334 | 256 | 8752 | 326 | 60.472 | 8.4689 | 2020-08-04 04:41:59 | Norway |
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]);