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 2021-02-27 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
2183490 2183490 2021-02-26 Germany Baden-Wurttemberg     314625 8042 295477 12068 48.6616 9.3501 2021-02-27 05:22:28 Baden-Wurttemberg, Germany
2183491 2183491 2021-02-26 Germany Bayern     433804 12329 405108 17758 48.7904 11.4979 2021-02-27 05:22:28 Bayern, Germany
2183492 2183492 2021-02-26 Germany Berlin     128234 2797 120864 5268 52.52 13.405 2021-02-27 05:22:28 Berlin, Germany
2183493 2183493 2021-02-26 Germany Brandenburg     75982 2977 69302 3930 52.4125 12.5316 2021-02-27 05:22:28 Brandenburg, Germany
2183494 2183494 2021-02-26 Germany Bremen     17790 333 16747 807 53.0793 8.8017 2021-02-27 05:22:28 Bremen, Germany
2183495 2183495 2021-02-26 Germany Hamburg     51262 1257 46551 3648 53.5511 9.9937 2021-02-27 05:22:28 Hamburg, Germany
2183496 2183496 2021-02-26 Germany Hessen     187011 5801 172536 9440 50.6521 9.1624 2021-02-27 05:22:28 Hessen, Germany
2183497 2183497 2021-02-26 Germany Mecklenburg-Vorpommern     24130 727 21268 2309 53.6127 12.4296 2021-02-27 05:22:28 Mecklenburg-Vorpommern, Germany
2183498 2183498 2021-02-26 Germany Niedersachsen     162668 4270 149424 9884 52.6367 9.8451 2021-02-27 05:22:28 Niedersachsen, Germany
2183499 2183499 2021-02-26 Germany Nordrhein-Westfalen     528690 12958 490807 26868 51.4332 7.6616 2021-02-27 05:22:28 Nordrhein-Westfalen, Germany
2183500 2183500 2021-02-26 Germany Rheinland-Pfalz     101435 3070 93815 4931 50.1183 7.309 2021-02-27 05:22:28 Rheinland-Pfalz, Germany
2183501 2183501 2021-02-26 Germany Saarland     28666 865 26694 1220 49.3964 7.023 2021-02-27 05:22:28 Saarland, Germany
2183502 2183502 2021-02-26 Germany Sachsen     193105 7613 178650 7362 51.1045 13.2017 2021-02-27 05:22:28 Sachsen, Germany
2183503 2183503 2021-02-26 Germany Sachsen-Anhalt     59863 2381 54119 3840 51.9503 11.6923 2021-02-27 05:22:28 Sachsen-Anhalt, Germany
2183504 2183504 2021-02-26 Germany Schleswig-Holstein     41989 1272 37741 3214 54.2194 9.6961 2021-02-27 05:22:28 Schleswig-Holstein, Germany
2183505 2183505 2021-02-26 Germany Thuringen     75430 2827 68070 5030 51.011 10.8453 2021-02-27 05:22:28 Thuringen, Germany
2183506 2183506 2021-02-26 Germany Unknown     1817 0 0 1817     2021-02-27 05:22:28 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]);