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-12-14 sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

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
3847695 3847695 2020-12-13 Germany Baden-Wurttemberg     186044 3400 136052 48764 48.6616 9.3501 2020-12-14 05:26:27 Baden-Wurttemberg, Germany
3847696 3847696 2020-12-13 Germany Bayern     256903 4848 193749 61149 48.7904 11.4979 2020-12-14 05:26:27 Bayern, Germany
3847697 3847697 2020-12-13 Germany Berlin     78248 813 59421 18556 52.52 13.405 2020-12-14 05:26:27 Berlin, Germany
3847698 3847698 2020-12-13 Germany Brandenburg     26434 481 20383 8103 52.4125 12.5316 2020-12-14 05:26:27 Brandenburg, Germany
3847699 3847699 2020-12-13 Germany Bremen     11661 154 9713 1857 53.0793 8.8017 2020-12-14 05:26:27 Bremen, Germany
3847700 3847700 2020-12-13 Germany Hamburg     29135 478 22000 6934 53.5511 9.9937 2020-12-14 05:26:27 Hamburg, Germany
3847701 3847701 2020-12-13 Germany Hessen     107361 1749 79222 27339 50.6521 9.1624 2020-12-14 05:26:27 Hessen, Germany
3847702 3847702 2020-12-13 Germany Mecklenburg-Vorpommern     8069 96 5962 2174 53.6127 12.4296 2020-12-14 05:26:27 Mecklenburg-Vorpommern, Germany
3847703 3847703 2020-12-13 Germany Niedersachsen     84771 1419 71241 13061 52.6367 9.8451 2020-12-14 05:26:27 Niedersachsen, Germany
3847704 3847704 2020-12-13 Germany Nordrhein-Westfalen     314937 4455 246364 67113 51.4332 7.6616 2020-12-14 05:26:27 Nordrhein-Westfalen, Germany
3847705 3847705 2020-12-13 Germany Rheinland-Pfalz     55536 846 38120 17370 50.1183 7.309 2020-12-14 05:26:27 Rheinland-Pfalz, Germany
3847706 3847706 2020-12-13 Germany Saarland     15588 301 12947 2882 49.3964 7.023 2020-12-14 05:26:27 Saarland, Germany
3847707 3847707 2020-12-13 Germany Sachsen     84245 1652 52000 33105 51.1045 13.2017 2020-12-14 05:26:27 Sachsen, Germany
3847708 3847708 2020-12-13 Germany Sachsen-Anhalt     18152 271 12040 6240 51.9503 11.6923 2020-12-14 05:26:27 Sachsen-Anhalt, Germany
3847709 3847709 2020-12-13 Germany Schleswig-Holstein     17960 291 13931 3876 54.2194 9.6961 2020-12-14 05:26:27 Schleswig-Holstein, Germany
3847710 3847710 2020-12-13 Germany Thuringen     25672 533 17562 8064 51.011 10.8453 2020-12-14 05:26:27 Thuringen, Germany
3847711 3847711 2020-12-13 Germany Unknown     11410 0 0 11410     2020-12-14 05:26:27 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]);