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-10-16 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
786284 786284 2020-10-15 Germany Baden-Wurttemberg     56488 1919 47737 7798 48.6616 9.3501 2020-10-16 04:24:01 Baden-Wurttemberg, Germany
786285 786285 2020-10-15 Germany Bayern     75535 2700 65787 8191 48.7904 11.4979 2020-10-16 04:24:01 Bayern, Germany
786286 786286 2020-10-15 Germany Berlin     19537 237 15652 4197 52.52 13.405 2020-10-16 04:24:01 Berlin, Germany
786287 786287 2020-10-15 Germany Brandenburg     5098 172 4342 710 52.4125 12.5316 2020-10-16 04:24:01 Brandenburg, Germany
786288 786288 2020-10-15 Germany Bremen     3274 62 2428 887 53.0793 8.8017 2020-10-16 04:24:01 Bremen, Germany
786289 786289 2020-10-15 Germany Hamburg     9288 278 7517 1661 53.5511 9.9937 2020-10-16 04:24:01 Hamburg, Germany
786290 786290 2020-10-15 Germany Hessen     23481 569 19270 4310 50.6521 9.1624 2020-10-16 04:24:01 Hessen, Germany
786291 786291 2020-10-15 Germany Mecklenburg-Vorpommern     1532 20 1270 305 53.6127 12.4296 2020-10-16 04:24:01 Mecklenburg-Vorpommern, Germany
786292 786292 2020-10-15 Germany Niedersachsen     24009 706 20270 3744 52.6367 9.8451 2020-10-16 04:24:01 Niedersachsen, Germany
786293 786293 2020-10-15 Germany Nordrhein-Westfalen     84161 1931 69183 15196 51.4332 7.6616 2020-10-16 04:24:01 Nordrhein-Westfalen, Germany
786294 786294 2020-10-15 Germany Rheinland-Pfalz     12647 260 10731 1891 50.1183 7.309 2020-10-16 04:24:01 Rheinland-Pfalz, Germany
786295 786295 2020-10-15 Germany Saarland     3960 177 3345 630 49.3964 7.023 2020-10-16 04:24:01 Saarland, Germany
786296 786296 2020-10-15 Germany Sachsen     9122 252 7157 1923 51.1045 13.2017 2020-10-16 04:24:01 Sachsen, Germany
786297 786297 2020-10-15 Germany Sachsen-Anhalt     2999 68 2639 350 51.9503 11.6923 2020-10-16 04:24:01 Sachsen-Anhalt, Germany
786298 786298 2020-10-15 Germany Schleswig-Holstein     5456 163 4780 567 54.2194 9.6961 2020-10-16 04:24:01 Schleswig-Holstein, Germany
786299 786299 2020-10-15 Germany Thuringen     4636 196 4029 486 51.011 10.8453 2020-10-16 04:24:01 Thuringen, Germany
786300 786300 2020-10-15 Germany Unknown     3385 0 0 3385     2020-10-16 04:24:01 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]);