daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

21 rows where country_or_region = "Sweden" and "day" is on date 2021-01-31 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

country_or_region 1

  • Sweden · 21 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-01-31 Sweden Blekinge     7271 88 0 7183 56.2784 15.018 2021-02-01 05:22:53 Blekinge, Sweden
2021-01-31 Sweden Dalarna     13304 297 0 13007 61.0917 14.6664 2021-02-01 05:22:53 Dalarna, Sweden
2021-01-31 Sweden Gavleborg     18123 462 0 17661 61.3012 16.1534 2021-02-01 05:22:53 Gavleborg, Sweden
2021-01-31 Sweden Gotland     2602 42 0 2560 57.4684 18.4867 2021-02-01 05:22:53 Gotland, Sweden
2021-01-31 Sweden Halland     18787 220 0 18567 56.8967 12.8034 2021-02-01 05:22:53 Halland, Sweden
2021-01-31 Sweden Jamtland Harjedalen     5777 100 0 5677 63.1712 14.9592 2021-02-01 05:22:53 Jamtland Harjedalen, Sweden
2021-01-31 Sweden Jonkoping     22272 453 0 21819 57.3708 14.3439 2021-02-01 05:22:53 Jonkoping, Sweden
2021-01-31 Sweden Kalmar     9679 175 0 9504 57.235 16.1849 2021-02-01 05:22:53 Kalmar, Sweden
2021-01-31 Sweden Kronoberg     12054 270 0 11784 56.7183 14.4115 2021-02-01 05:22:53 Kronoberg, Sweden
2021-01-31 Sweden Norrbotten     10090 188 0 9902 66.8309 20.3992 2021-02-01 05:22:53 Norrbotten, Sweden
2021-01-31 Sweden Orebro     16162 265 0 15897 59.535 15.0066 2021-02-01 05:22:53 Orebro, Sweden
2021-01-31 Sweden Ostergotland     19441 477 0 18964 58.3454 15.5198 2021-02-01 05:22:53 Ostergotland, Sweden
2021-01-31 Sweden Skane     96713 1279 0 95434 55.9903 13.5958 2021-02-01 05:22:53 Skane, Sweden
2021-01-31 Sweden Sormland     11587 378 0 11209 59.0336 16.7519 2021-02-01 05:22:53 Sormland, Sweden
2021-01-31 Sweden Stockholm     137344 3714 0 133630 59.6025 18.1384 2021-02-01 05:22:53 Stockholm, Sweden
2021-01-31 Sweden Uppsala     21478 447 0 21031 60.0092 17.2715 2021-02-01 05:22:53 Uppsala, Sweden
2021-01-31 Sweden Varmland     7663 156 0 7507 59.7294 13.2354 2021-02-01 05:22:53 Varmland, Sweden
2021-01-31 Sweden Vasterbotten     10323 115 0 10208 65.3337 16.5162 2021-02-01 05:22:53 Vasterbotten, Sweden
2021-01-31 Sweden Vasternorrland     12991 353 0 12638 63.4276 17.7292 2021-02-01 05:22:53 Vasternorrland, Sweden
2021-01-31 Sweden Vastmanland     16665 299 0 16366 59.6714 16.2159 2021-02-01 05:22:53 Vastmanland, Sweden
2021-01-31 Sweden Vastra Gotaland     96631 1813 0 94818 58.2528 13.0596 2021-02-01 05:22:53 Vastra Gotaland, Sweden

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;