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-07-26 sorted by day descending

✎ View and edit SQL

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

Suggested facets: active, 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
1502581 1502581 2020-07-25 Germany Baden-Wurttemberg     36819 1841 34260 727 48.6616 9.3501 2020-07-26 04:35:00 Baden-Wurttemberg, Germany
1502589 1502589 2020-07-25 Germany Bayern     50260 2619 46600 1048 48.7904 11.4979 2020-07-26 04:35:00 Bayern, Germany
1502592 1502592 2020-07-25 Germany Berlin     8957 223 8429 338 52.52 13.405 2020-07-26 04:35:00 Berlin, Germany
1502600 1502600 2020-07-25 Germany Brandenburg     3524 168 3300 70 52.4125 12.5316 2020-07-26 04:35:00 Brandenburg, Germany
1502601 1502601 2020-07-25 Germany Bremen     1742 55 1635 55 53.0793 8.8017 2020-07-26 04:35:00 Bremen, Germany
1502703 1502703 2020-07-25 Germany Hamburg     5291 261 5000 42 53.5511 9.9937 2020-07-26 04:35:00 Hamburg, Germany
1502708 1502708 2020-07-25 Germany Hessen     11649 518 10700 431 50.6521 9.1624 2020-07-26 04:35:00 Hessen, Germany
1502812 1502812 2020-07-25 Germany Mecklenburg-Vorpommern     843 20 786 37 53.6127 12.4296 2020-07-26 04:35:00 Mecklenburg-Vorpommern, Germany
1502846 1502846 2020-07-25 Germany Niedersachsen     14222 648 13200 373 52.6367 9.8451 2020-07-26 04:35:00 Niedersachsen, Germany
1502852 1502852 2020-07-25 Germany Nordrhein-Westfalen     47257 1728 43200 2329 51.4332 7.6616 2020-07-26 04:35:00 Nordrhein-Westfalen, Germany
1502915 1502915 2020-07-25 Germany Rheinland-Pfalz     7409 238 6865 309 50.1183 7.309 2020-07-26 04:35:00 Rheinland-Pfalz, Germany
1502925 1502925 2020-07-25 Germany Saarland     2849 174 2609 66 49.3964 7.023 2020-07-26 04:35:00 Saarland, Germany
1502926 1502926 2020-07-25 Germany Sachsen     5512 225 5240 47 51.1045 13.2017 2020-07-26 04:35:00 Sachsen, Germany
1502927 1502927 2020-07-25 Germany Sachsen-Anhalt     1979 63 1855 63 51.9503 11.6923 2020-07-26 04:35:00 Sachsen-Anhalt, Germany
1502946 1502946 2020-07-25 Germany Schleswig-Holstein     3311 155 3100 63 54.2194 9.6961 2020-07-26 04:35:00 Schleswig-Holstein, Germany
1502983 1502983 2020-07-25 Germany Thuringen     3340 182 3140 18 51.011 10.8453 2020-07-26 04:35:00 Thuringen, Germany
1503008 1503008 2020-07-25 Germany Unknown     1219 0 0 1219     2020-07-26 04:35:00 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]);