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-14 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
2571586 2571586 2021-04-13 Germany Baden-Wurttemberg     389388 8946 352100 31611 48.6616 9.3501 2021-04-14 04:20:41 Baden-Wurttemberg, Germany
2571587 2571587 2021-04-13 Germany Bayern     532732 13562 482200 41007 48.7904 11.4979 2021-04-14 04:20:41 Bayern, Germany
2571588 2571588 2021-04-13 Germany Berlin     153991 3126 142500 9051 52.52 13.405 2021-04-14 04:20:41 Berlin, Germany
2571589 2571589 2021-04-13 Germany Brandenburg     93523 3401 83640 7044 52.4125 12.5316 2021-04-14 04:20:41 Brandenburg, Germany
2571590 2571590 2021-04-13 Germany Bremen     22482 422 20540 1685 53.0793 8.8017 2021-04-14 04:20:41 Bremen, Germany
2571591 2571591 2021-04-13 Germany Hamburg     65915 1412 57200 7574 53.5511 9.9937 2021-04-14 04:20:41 Hamburg, Germany
2571592 2571592 2021-04-13 Germany Hessen     234519 6521 209100 20951 50.6521 9.1624 2021-04-14 04:20:41 Hessen, Germany
2571593 2571593 2021-04-13 Germany Mecklenburg-Vorpommern     34020 914 30180 3431 53.6127 12.4296 2021-04-14 04:20:41 Mecklenburg-Vorpommern, Germany
2571594 2571594 2021-04-13 Germany Niedersachsen     212176 5037 194000 14325 52.6367 9.8451 2021-04-14 04:20:41 Niedersachsen, Germany
2571595 2571595 2021-04-13 Germany Nordrhein-Westfalen     652744 14655 590000 52716 51.4332 7.6616 2021-04-14 04:20:41 Nordrhein-Westfalen, Germany
2571596 2571596 2021-04-13 Germany Rheinland-Pfalz     124741 3405 112100 9890 50.1183 7.309 2021-04-14 04:20:41 Rheinland-Pfalz, Germany
2571597 2571597 2021-04-13 Germany Saarland     33628 934 31080 1832 49.3964 7.023 2021-04-14 04:20:41 Saarland, Germany
2571598 2571598 2021-04-13 Germany Sachsen     236496 8573 212400 17038 51.1045 13.2017 2021-04-14 04:20:41 Sachsen, Germany
2571599 2571599 2021-04-13 Germany Sachsen-Anhalt     79541 2848 70920 6430 51.9503 11.6923 2021-04-14 04:20:41 Sachsen-Anhalt, Germany
2571600 2571600 2021-04-13 Germany Schleswig-Holstein     53332 1466 47900 4366 54.2194 9.6961 2021-04-14 04:20:41 Schleswig-Holstein, Germany
2571601 2571601 2021-04-13 Germany Thuringen     103095 3524 91050 9367 51.011 10.8453 2021-04-14 04:20:41 Thuringen, Germany
2571602 2571602 2021-04-13 Germany Unknown     9660 0 0 9660     2021-04-14 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]);