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-06-22 sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (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
3358576 3358576 2021-06-21 Germany Baden-Wurttemberg     499451 10161 485200 4397 48.6616 9.3501 2021-06-22 04:21:34 Baden-Wurttemberg, Germany
3358577 3358577 2021-06-21 Germany Bayern     646498 15187 627400 3988 48.7904 11.4979 2021-06-22 04:21:34 Bayern, Germany
3358578 3358578 2021-06-21 Germany Berlin     179871 3545 175400 976 52.52 13.405 2021-06-22 04:21:34 Berlin, Germany
3358579 3358579 2021-06-21 Germany Brandenburg     108640 3787 104500 354 52.4125 12.5316 2021-06-22 04:21:34 Brandenburg, Germany
3358580 3358580 2021-06-21 Germany Bremen     27386 483 26710 199 53.0793 8.8017 2021-06-22 04:21:34 Bremen, Germany
3358581 3358581 2021-06-21 Germany Hamburg     77121 1587 74800 749 53.5511 9.9937 2021-06-22 04:21:34 Hamburg, Germany
3358582 3358582 2021-06-21 Germany Hessen     290208 7470 279800 2959 50.6521 9.1624 2021-06-22 04:21:34 Hessen, Germany
3358583 3358583 2021-06-21 Germany Mecklenburg-Vorpommern     44101 1148 42890 65 53.6127 12.4296 2021-06-22 04:21:34 Mecklenburg-Vorpommern, Germany
3358584 3358584 2021-06-21 Germany Niedersachsen     260643 5727 253800 1146 52.6367 9.8451 2021-06-22 04:21:34 Niedersachsen, Germany
3358585 3358585 2021-06-21 Germany Nordrhein-Westfalen     814893 17048 790900 6999 51.4332 7.6616 2021-06-22 04:21:34 Nordrhein-Westfalen, Germany
3358586 3358586 2021-06-21 Germany Rheinland-Pfalz     154895 3869 150000 1065 50.1183 7.309 2021-06-22 04:21:34 Rheinland-Pfalz, Germany
3358587 3358587 2021-06-21 Germany Saarland     41383 1019 40100 270 49.3964 7.023 2021-06-22 04:21:34 Saarland, Germany
3358588 3358588 2021-06-21 Germany Sachsen     285654 10019 273900 1766 51.1045 13.2017 2021-06-22 04:21:34 Sachsen, Germany
3358589 3358589 2021-06-21 Germany Sachsen-Anhalt     99177 3414 95210 591 51.9503 11.6923 2021-06-22 04:21:34 Sachsen-Anhalt, Germany
3358590 3358590 2021-06-21 Germany Schleswig-Holstein     63759 1619 61640 521 54.2194 9.6961 2021-06-22 04:21:34 Schleswig-Holstein, Germany
3358591 3358591 2021-06-21 Germany Thuringen     128647 4312 123900 453 51.011 10.8453 2021-06-22 04:21:34 Thuringen, Germany
3358592 3358592 2021-06-21 Germany Unknown     7494 0 0 7494     2021-06-22 04:21:34 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]);