johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where country_or_region = "Sweden" and "day" is on date 2021-02-04 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 21
- Blekinge 1
- Dalarna 1
- Gavleborg 1
- Gotland 1
- Halland 1
- Jamtland Harjedalen 1
- Jonkoping 1
- Kalmar 1
- Kronoberg 1
- Norrbotten 1
- Orebro 1
- Ostergotland 1
- Skane 1
- Sormland 1
- Stockholm 1
- Uppsala 1
- Varmland 1
- Vasterbotten 1
- Vasternorrland 1
- Vastmanland 1
- Vastra Gotaland 1
country_or_region 1
- Sweden · 21 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
790689 | 790689 | 2021-02-04 | Sweden | Blekinge | 7446 | 106 | 0 | 7340 | 56.2784 | 15.018 | 2021-02-05 05:22:38 | Blekinge, Sweden | ||
790690 | 790690 | 2021-02-04 | Sweden | Dalarna | 13559 | 298 | 0 | 13261 | 61.0917 | 14.6664 | 2021-02-05 05:22:38 | Dalarna, Sweden | ||
790691 | 790691 | 2021-02-04 | Sweden | Gavleborg | 18621 | 471 | 0 | 18150 | 61.3012 | 16.1534 | 2021-02-05 05:22:38 | Gavleborg, Sweden | ||
790692 | 790692 | 2021-02-04 | Sweden | Gotland | 2620 | 44 | 0 | 2576 | 57.4684 | 18.4867 | 2021-02-05 05:22:38 | Gotland, Sweden | ||
790693 | 790693 | 2021-02-04 | Sweden | Halland | 19751 | 238 | 0 | 19513 | 56.8967 | 12.8034 | 2021-02-05 05:22:38 | Halland, Sweden | ||
790694 | 790694 | 2021-02-04 | Sweden | Jamtland Harjedalen | 5979 | 100 | 0 | 5879 | 63.1712 | 14.9592 | 2021-02-05 05:22:38 | Jamtland Harjedalen, Sweden | ||
790695 | 790695 | 2021-02-04 | Sweden | Jonkoping | 23072 | 470 | 0 | 22602 | 57.3708 | 14.3439 | 2021-02-05 05:22:38 | Jonkoping, Sweden | ||
790696 | 790696 | 2021-02-04 | Sweden | Kalmar | 10039 | 188 | 0 | 9851 | 57.235 | 16.1849 | 2021-02-05 05:22:38 | Kalmar, Sweden | ||
790697 | 790697 | 2021-02-04 | Sweden | Kronoberg | 12469 | 280 | 0 | 12189 | 56.7183 | 14.4115 | 2021-02-05 05:22:38 | Kronoberg, Sweden | ||
790698 | 790698 | 2021-02-04 | Sweden | Norrbotten | 10455 | 198 | 0 | 10257 | 66.8309 | 20.3992 | 2021-02-05 05:22:38 | Norrbotten, Sweden | ||
790699 | 790699 | 2021-02-04 | Sweden | Orebro | 16520 | 275 | 0 | 16245 | 59.535 | 15.0066 | 2021-02-05 05:22:38 | Orebro, Sweden | ||
790700 | 790700 | 2021-02-04 | Sweden | Ostergotland | 20206 | 506 | 0 | 19700 | 58.3454 | 15.5198 | 2021-02-05 05:22:38 | Ostergotland, Sweden | ||
790701 | 790701 | 2021-02-04 | Sweden | Skane | 100300 | 1414 | 0 | 98886 | 55.9903 | 13.5958 | 2021-02-05 05:22:38 | Skane, Sweden | ||
790702 | 790702 | 2021-02-04 | Sweden | Sormland | 11838 | 384 | 0 | 11454 | 59.0336 | 16.7519 | 2021-02-05 05:22:38 | Sormland, Sweden | ||
790703 | 790703 | 2021-02-04 | Sweden | Stockholm | 140199 | 3731 | 0 | 136468 | 59.6025 | 18.1384 | 2021-02-05 05:22:38 | Stockholm, Sweden | ||
790704 | 790704 | 2021-02-04 | Sweden | Uppsala | 21922 | 457 | 0 | 21465 | 60.0092 | 17.2715 | 2021-02-05 05:22:38 | Uppsala, Sweden | ||
790705 | 790705 | 2021-02-04 | Sweden | Varmland | 7909 | 161 | 0 | 7748 | 59.7294 | 13.2354 | 2021-02-05 05:22:38 | Varmland, Sweden | ||
790706 | 790706 | 2021-02-04 | Sweden | Vasterbotten | 10823 | 119 | 0 | 10704 | 65.3337 | 16.5162 | 2021-02-05 05:22:38 | Vasterbotten, Sweden | ||
790707 | 790707 | 2021-02-04 | Sweden | Vasternorrland | 13445 | 366 | 0 | 13079 | 63.4276 | 17.7292 | 2021-02-05 05:22:38 | Vasternorrland, Sweden | ||
790708 | 790708 | 2021-02-04 | Sweden | Vastmanland | 17077 | 309 | 0 | 16768 | 59.6714 | 16.2159 | 2021-02-05 05:22:38 | Vastmanland, Sweden | ||
790709 | 790709 | 2021-02-04 | Sweden | Vastra Gotaland | 100424 | 1913 | 0 | 98511 | 58.2528 | 13.0596 | 2021-02-05 05:22:38 | Vastra Gotaland, 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]);