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-04-18 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
982856 982856 2021-04-17 Germany Baden-Wurttemberg     403509 9047 359400 37971 48.6616 9.3501 2021-04-18 04:20:41 Baden-Wurttemberg, Germany
982857 982857 2021-04-17 Germany Bayern     550632 13715 491800 48472 48.7904 11.4979 2021-04-18 04:20:41 Bayern, Germany
982858 982858 2021-04-17 Germany Berlin     158305 3146 145200 10583 52.52 13.405 2021-04-18 04:20:41 Berlin, Germany
982859 982859 2021-04-17 Germany Brandenburg     96158 3443 85380 7789 52.4125 12.5316 2021-04-18 04:20:41 Brandenburg, Germany
982860 982860 2021-04-17 Germany Bremen     23276 435 21010 1995 53.0793 8.8017 2021-04-18 04:20:41 Bremen, Germany
982861 982861 2021-04-17 Germany Hamburg     67542 1429 58540 7983 53.5511 9.9937 2021-04-18 04:20:41 Hamburg, Germany
982862 982862 2021-04-17 Germany Hessen     242061 6596 213800 23194 50.6521 9.1624 2021-04-18 04:20:41 Hessen, Germany
982863 982863 2021-04-17 Germany Mecklenburg-Vorpommern     35843 926 31280 3953 53.6127 12.4296 2021-04-18 04:20:41 Mecklenburg-Vorpommern, Germany
982864 982864 2021-04-17 Germany Niedersachsen     219426 5119 198300 17550 52.6367 9.8451 2021-04-18 04:20:41 Niedersachsen, Germany
982865 982865 2021-04-17 Germany Nordrhein-Westfalen     674695 14854 601400 62865 51.4332 7.6616 2021-04-18 04:20:41 Nordrhein-Westfalen, Germany
982866 982866 2021-04-17 Germany Rheinland-Pfalz     128834 3447 114300 11669 50.1183 7.309 2021-04-18 04:20:41 Rheinland-Pfalz, Germany
982867 982867 2021-04-17 Germany Saarland     34434 942 31550 2298 49.3964 7.023 2021-04-18 04:20:41 Saarland, Germany
982868 982868 2021-04-17 Germany Sachsen     244070 8724 216600 19999 51.1045 13.2017 2021-04-18 04:20:41 Sachsen, Germany
982869 982869 2021-04-17 Germany Sachsen-Anhalt     82455 2909 73210 6977 51.9503 11.6923 2021-04-18 04:20:41 Sachsen-Anhalt, Germany
982870 982870 2021-04-17 Germany Schleswig-Holstein     54780 1474 48940 4717 54.2194 9.6961 2021-04-18 04:20:41 Schleswig-Holstein, Germany
982871 982871 2021-04-17 Germany Thuringen     107057 3641 93830 10210 51.011 10.8453 2021-04-18 04:20:41 Thuringen, Germany
982872 982872 2021-04-17 Germany Unknown     11569 0 0 11569     2021-04-18 04:20:41 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]);