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

17 rows where country_or_region = "Germany" and "last_update" is on date 2020-09-05 sorted by day descending

✎ View and edit SQL

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

country_or_region 1

  • Germany · 17 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2661683 2661683 2020-09-04 Germany Baden-Wurttemberg     42925 1865 37913 3473 48.6616 9.3501 2020-09-05 04:28:19 Baden-Wurttemberg, Germany
2661684 2661684 2020-09-04 Germany Bayern     58385 2641 52085 3857 48.7904 11.4979 2020-09-05 04:28:19 Bayern, Germany
2661685 2661685 2020-09-04 Germany Berlin     11529 226 10566 830 52.52 13.405 2020-09-05 04:28:19 Berlin, Germany
2661686 2661686 2020-09-04 Germany Brandenburg     3902 169 3641 121 52.4125 12.5316 2020-09-05 04:28:19 Brandenburg, Germany
2661687 2661687 2020-09-04 Germany Bremen     2048 58 1843 158 53.0793 8.8017 2020-09-05 04:28:19 Bremen, Germany
2661688 2661688 2020-09-04 Germany Hamburg     6396 267 5679 504 53.5511 9.9937 2020-09-05 04:28:19 Hamburg, Germany
2661689 2661689 2020-09-04 Germany Hessen     15912 535 14010 1285 50.6521 9.1624 2020-09-05 04:28:19 Hessen, Germany
2661690 2661690 2020-09-04 Germany Mecklenburg-Vorpommern     1019 20 968 35 53.6127 12.4296 2020-09-05 04:28:19 Mecklenburg-Vorpommern, Germany
2661691 2661691 2020-09-04 Germany Niedersachsen     17133 665 15264 1215 52.6367 9.8451 2020-09-05 04:28:19 Niedersachsen, Germany
2661692 2661692 2020-09-04 Germany Nordrhein-Westfalen     59811 1821 54921 3068 51.4332 7.6616 2020-09-05 04:28:19 Nordrhein-Westfalen, Germany
2661693 2661693 2020-09-04 Germany Rheinland-Pfalz     9260 243 8277 752 50.1183 7.309 2020-09-05 04:28:19 Rheinland-Pfalz, Germany
2661694 2661694 2020-09-04 Germany Saarland     3176 174 2900 95 49.3964 7.023 2020-09-05 04:28:19 Saarland, Germany
2661695 2661695 2020-09-04 Germany Sachsen     6095 225 5539 355 51.1045 13.2017 2020-09-05 04:28:19 Sachsen, Germany
2661696 2661696 2020-09-04 Germany Sachsen-Anhalt     2263 66 2092 119 51.9503 11.6923 2020-09-05 04:28:19 Sachsen-Anhalt, Germany
2661697 2661697 2020-09-04 Germany Schleswig-Holstein     4107 161 3742 212 54.2194 9.6961 2020-09-05 04:28:19 Schleswig-Holstein, Germany
2661698 2661698 2020-09-04 Germany Thuringen     3658 186 3362 109 51.011 10.8453 2020-09-05 04:28:19 Thuringen, Germany
2661699 2661699 2020-09-04 Germany Unknown     1966 0 0 1966     2020-09-05 04:28:19 Unknown, Germany

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