johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where country_or_region = "Sweden" and deaths = 99 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, longitude, combined_key, day (date), last_update (date)
province_or_state 3
country_or_region 1
- Sweden · 17 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2567975 | 2567975 | 2021-01-25 | Sweden | Jamtland Harjedalen | 5568 | 99 | 0 | 5469 | 63.1712 | 14.9592 | 2021-01-26 05:22:02 | Jamtland Harjedalen, Sweden | ||
1759607 | 1759607 | 2021-01-24 | Sweden | Jamtland Harjedalen | 5568 | 99 | 0 | 5469 | 63.1712 | 14.9592 | 2021-01-25 05:22:16 | Jamtland Harjedalen, Sweden | ||
2427214 | 2427214 | 2021-01-23 | Sweden | Jamtland Harjedalen | 5568 | 99 | 0 | 5469 | 63.1712 | 14.9592 | 2021-01-24 05:22:35 | Jamtland Harjedalen, Sweden | ||
2467116 | 2467116 | 2021-01-22 | Sweden | Jamtland Harjedalen | 5568 | 99 | 0 | 5469 | 63.1712 | 14.9592 | 2021-01-23 05:22:03 | Jamtland Harjedalen, Sweden | ||
435667 | 435667 | 2021-01-21 | Sweden | Jamtland Harjedalen | 5535 | 99 | 0 | 5436 | 63.1712 | 14.9592 | 2021-01-22 05:22:10 | Jamtland Harjedalen, Sweden | ||
1094398 | 1094398 | 2021-01-20 | Sweden | Jamtland Harjedalen | 5484 | 99 | 0 | 5385 | 63.1712 | 14.9592 | 2021-01-21 05:22:01 | Jamtland Harjedalen, Sweden | ||
908488 | 908488 | 2021-01-19 | Sweden | Jamtland Harjedalen | 5391 | 99 | 0 | 5292 | 63.1712 | 14.9592 | 2021-01-20 05:21:54 | Jamtland Harjedalen, Sweden | ||
237551 | 237551 | 2021-01-18 | Sweden | Jamtland Harjedalen | 5327 | 99 | 0 | 5228 | 63.1712 | 14.9592 | 2021-01-19 05:22:15 | Jamtland Harjedalen, Sweden | ||
3503668 | 3503668 | 2021-01-17 | Sweden | Jamtland Harjedalen | 5327 | 99 | 0 | 5228 | 63.1712 | 14.9592 | 2021-01-18 05:22:34 | Jamtland Harjedalen, Sweden | ||
3101751 | 3101751 | 2021-01-16 | Sweden | Jamtland Harjedalen | 5327 | 99 | 0 | 5228 | 63.1712 | 14.9592 | 2021-01-17 05:22:17 | Jamtland Harjedalen, Sweden | ||
3515713 | 3515713 | 2021-01-15 | Sweden | Jamtland Harjedalen | 5327 | 99 | 0 | 5228 | 63.1712 | 14.9592 | 2021-01-16 05:22:40 | Jamtland Harjedalen, Sweden | ||
3879886 | 3879886 | 2021-01-14 | Sweden | Jamtland Harjedalen | 5289 | 99 | 0 | 5190 | 63.1712 | 14.9592 | 2021-01-15 05:22:24 | Jamtland Harjedalen, Sweden | ||
678621 | 678621 | 2020-11-23 | Sweden | Halland | 5527 | 99 | 0 | 5428 | 56.8967 | 12.8034 | 2020-11-24 05:27:31 | Halland, Sweden | ||
3190297 | 3190297 | 2020-11-22 | Sweden | Halland | 5527 | 99 | 0 | 5428 | 56.8967 | 12.8034 | 2020-11-23 05:25:26 | Halland, Sweden | ||
3836791 | 3836791 | 2020-11-21 | Sweden | Halland | 5527 | 99 | 0 | 5428 | 56.8967 | 12.8034 | 2020-11-22 05:25:45 | Halland, Sweden | ||
2701819 | 2701819 | 2020-11-20 | Sweden | Halland | 5527 | 99 | 0 | 5428 | 56.8967 | 12.8034 | 2020-11-21 05:25:51 | Halland, Sweden | ||
2386867 | 2386867 | 2020-06-16 | Sweden | Vasternorrland | 1039 | 99 | 0 | 940 | 63.4276 | 17.7292 | 2020-06-17 04:33:21 | Vasternorrland, 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]);