johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where country_or_region = "Sweden" and recovered = 550 sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) 8 ✖
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
country_or_region 1
- Sweden · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
934412 | 934412 | 2020-04-16 | Sweden | 12540 | 1333 | 550 | 10657 | 60.128161 | 18.643501 | 2020-04-16 23:30:31 | Sweden | |||
50418 | 50418 | 2020-04-17 | Sweden | 13216 | 1400 | 550 | 11266 | 60.128161 | 18.643501 | 2020-04-17 23:30:32 | Sweden | |||
418946 | 418946 | 2020-04-18 | Sweden | 13822 | 1511 | 550 | 11761 | 60.128161 | 18.643501 | 2020-04-18 22:32:28 | Sweden | |||
1385258 | 1385258 | 2020-04-19 | Sweden | 14385 | 1540 | 550 | 12295 | 60.128161 | 18.643501 | 2020-04-19 23:40:41 | Sweden | |||
2473566 | 2473566 | 2020-04-20 | Sweden | 14777 | 1580 | 550 | 12647 | 60.128161 | 18.643501 | 2020-04-20 23:36:27 | Sweden | |||
522484 | 522484 | 2020-04-21 | Sweden | 15322 | 1765 | 550 | 13007 | 60.128161 | 18.643501 | 2020-04-21 23:30:30 | Sweden | |||
1199418 | 1199418 | 2020-04-22 | Sweden | 16004 | 1937 | 550 | 13517 | 60.128161 | 18.643501 | 2020-04-22 23:30:32 | Sweden | |||
2524968 | 2524968 | 2020-04-23 | Sweden | 16755 | 2021 | 550 | 14184 | 60.128161 | 18.643501 | 2020-04-24 03:30:31 | Sweden |
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]);