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-13 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
2291350 2291350 2020-10-12 Germany Baden-Wurttemberg     54345 1901 46950 6086 48.6616 9.3501 2020-10-13 04:24:02 Baden-Wurttemberg, Germany
2291351 2291351 2020-10-12 Germany Bayern     73186 2685 64535 6564 48.7904 11.4979 2020-10-13 04:24:02 Bayern, Germany
2291352 2291352 2020-10-12 Germany Berlin     18075 234 14847 3246 52.52 13.405 2020-10-13 04:24:02 Berlin, Germany
2291353 2291353 2020-10-12 Germany Brandenburg     4771 169 4211 496 52.4125 12.5316 2020-10-13 04:24:02 Brandenburg, Germany
2291354 2291354 2020-10-12 Germany Bremen     3080 61 2324 728 53.0793 8.8017 2020-10-13 04:24:02 Bremen, Germany
2291355 2291355 2020-10-12 Germany Hamburg     8963 277 7221 1542 53.5511 9.9937 2020-10-13 04:24:02 Hamburg, Germany
2291356 2291356 2020-10-12 Germany Hessen     22039 562 18537 3211 50.6521 9.1624 2020-10-13 04:24:02 Hessen, Germany
2291357 2291357 2020-10-12 Germany Mecklenburg-Vorpommern     1373 20 1206 195 53.6127 12.4296 2020-10-13 04:24:02 Mecklenburg-Vorpommern, Germany
2291358 2291358 2020-10-12 Germany Niedersachsen     22662 697 19557 3011 52.6367 9.8451 2020-10-13 04:24:02 Niedersachsen, Germany
2291359 2291359 2020-10-12 Germany Nordrhein-Westfalen     79981 1913 67129 12146 51.4332 7.6616 2020-10-13 04:24:02 Nordrhein-Westfalen, Germany
2291360 2291360 2020-10-12 Germany Rheinland-Pfalz     12106 256 10503 1475 50.1183 7.309 2020-10-13 04:24:02 Rheinland-Pfalz, Germany
2291361 2291361 2020-10-12 Germany Saarland     3703 177 3271 367 49.3964 7.023 2020-10-13 04:24:02 Saarland, Germany
2291362 2291362 2020-10-12 Germany Sachsen     8413 248 6930 1381 51.1045 13.2017 2020-10-13 04:24:02 Sachsen, Germany
2291363 2291363 2020-10-12 Germany Sachsen-Anhalt     2932 68 2557 341 51.9503 11.6923 2020-10-13 04:24:02 Sachsen-Anhalt, Germany
2291364 2291364 2020-10-12 Germany Schleswig-Holstein     5260 162 4670 493 54.2194 9.6961 2020-10-13 04:24:02 Schleswig-Holstein, Germany
2291365 2291365 2020-10-12 Germany Thuringen     4442 191 3943 351 51.011 10.8453 2020-10-13 04:24:02 Thuringen, Germany
2291366 2291366 2020-10-12 Germany Unknown     3186 0 0 3186     2020-10-13 04:24:02 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]);