johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

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

✎ View and edit SQL

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

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
3840822 3840822 2022-01-15 Sweden Blekinge     17524 139 0   56.2784 15.017999999999999 2022-01-16 04:21:12 Blekinge, Sweden
3840823 3840823 2022-01-15 Sweden Dalarna     39825 368 0   61.0917 14.6664 2022-01-16 04:21:12 Dalarna, Sweden
3840824 3840824 2022-01-15 Sweden Gavleborg     46542 579 0   61.3012 16.1534 2022-01-16 04:21:12 Gavleborg, Sweden
3840825 3840825 2022-01-15 Sweden Gotland     6179 54 0   57.4684 18.4867 2022-01-16 04:21:12 Gotland, Sweden
3840826 3840826 2022-01-15 Sweden Halland     60486 341 0   56.8967 12.8034 2022-01-16 04:21:12 Halland, Sweden
3840827 3840827 2022-01-15 Sweden Jamtland Harjedalen     19636 130 0   63.1712 14.9592 2022-01-16 04:21:12 Jamtland Harjedalen, Sweden
3840828 3840828 2022-01-15 Sweden Jonkoping     56131 575 0   57.3708 14.3439 2022-01-16 04:21:12 Jonkoping, Sweden
3840829 3840829 2022-01-15 Sweden Kalmar     33087 263 0   57.235 16.1849 2022-01-16 04:21:12 Kalmar, Sweden
3840830 3840830 2022-01-15 Sweden Kronoberg     28951 333 0   56.7183 14.4115 2022-01-16 04:21:12 Kronoberg, Sweden
3840831 3840831 2022-01-15 Sweden Norrbotten     33369 299 0   66.8309 20.3992 2022-01-16 04:21:12 Norrbotten, Sweden
3840832 3840832 2022-01-15 Sweden Orebro     45898 364 0   59.535 15.0066 2022-01-16 04:21:12 Orebro, Sweden
3840833 3840833 2022-01-15 Sweden Ostergotland     54594 670 0   58.3454 15.5198 2022-01-16 04:21:12 Ostergotland, Sweden
3840834 3840834 2022-01-15 Sweden Skane     227458 1871 0   55.9903 13.5958 2022-01-16 04:21:12 Skane, Sweden
3840835 3840835 2022-01-15 Sweden Sormland     37189 492 0   59.0336 16.7519 2022-01-16 04:21:12 Sormland, Sweden
3840836 3840836 2022-01-15 Sweden Stockholm     388644 4634 0   59.6025 18.1384 2022-01-16 04:21:12 Stockholm, Sweden
3840837 3840837 2022-01-15 Sweden Uppsala     56449 562 0   60.0092 17.2715 2022-01-16 04:21:12 Uppsala, Sweden
3840838 3840838 2022-01-15 Sweden Varmland     31447 233 0   59.7294 13.2354 2022-01-16 04:21:12 Varmland, Sweden
3840839 3840839 2022-01-15 Sweden Vasterbotten     33000 204 0   65.3337 16.5162 2022-01-16 04:21:12 Vasterbotten, Sweden
3840840 3840840 2022-01-15 Sweden Vasternorrland     34337 489 0   63.4276 17.7292 2022-01-16 04:21:12 Vasternorrland, Sweden
3840841 3840841 2022-01-15 Sweden Vastmanland     43550 391 0   59.6714 16.2159 2022-01-16 04:21:12 Vastmanland, Sweden
3840842 3840842 2022-01-15 Sweden Vastra Gotaland     266067 2522 0   58.2528 13.0596 2022-01-16 04:21:12 Vastra Gotaland, Sweden

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);