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-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
3781810 3781810 2020-10-13 Germany Baden-Wurttemberg     54939 1903 46950 6780 48.6616 9.3501 2020-10-14 04:24:05 Baden-Wurttemberg, Germany
3781811 3781811 2020-10-13 Germany Bayern     73788 2689 64971 6795 48.7904 11.4979 2020-10-14 04:24:05 Bayern, Germany
3781812 3781812 2020-10-13 Germany Berlin     18327 234 15077 3719 52.52 13.405 2020-10-14 04:24:05 Berlin, Germany
3781813 3781813 2020-10-13 Germany Brandenburg     4794 169 4253 568 52.4125 12.5316 2020-10-14 04:24:05 Brandenburg, Germany
3781814 3781814 2020-10-13 Germany Bremen     3113 61 2355 749 53.0793 8.8017 2020-10-14 04:24:05 Bremen, Germany
3781815 3781815 2020-10-13 Germany Hamburg     9040 277 7300 1575 53.5511 9.9937 2020-10-14 04:24:05 Hamburg, Germany
3781816 3781816 2020-10-13 Germany Hessen     22310 562 18760 3492 50.6521 9.1624 2020-10-14 04:24:05 Hessen, Germany
3781817 3781817 2020-10-13 Germany Mecklenburg-Vorpommern     1416 20 1220 237 53.6127 12.4296 2020-10-14 04:24:05 Mecklenburg-Vorpommern, Germany
3781818 3781818 2020-10-13 Germany Niedersachsen     23265 696 19729 3129 52.6367 9.8451 2020-10-14 04:24:05 Niedersachsen, Germany
3781819 3781819 2020-10-13 Germany Nordrhein-Westfalen     81192 1917 67816 12617 51.4332 7.6616 2020-10-14 04:24:05 Nordrhein-Westfalen, Germany
3781820 3781820 2020-10-13 Germany Rheinland-Pfalz     12235 257 10578 1572 50.1183 7.309 2020-10-14 04:24:05 Rheinland-Pfalz, Germany
3781821 3781821 2020-10-13 Germany Saarland     3720 177 3279 456 49.3964 7.023 2020-10-14 04:24:05 Saarland, Germany
3781822 3781822 2020-10-13 Germany Sachsen     8559 248 6990 1502 51.1045 13.2017 2020-10-14 04:24:05 Sachsen, Germany
3781823 3781823 2020-10-13 Germany Sachsen-Anhalt     2942 68 2575 347 51.9503 11.6923 2020-10-14 04:24:05 Sachsen-Anhalt, Germany
3781824 3781824 2020-10-13 Germany Schleswig-Holstein     5325 162 4713 515 54.2194 9.6961 2020-10-14 04:24:05 Schleswig-Holstein, Germany
3781825 3781825 2020-10-13 Germany Thuringen     4488 194 3967 392 51.011 10.8453 2020-10-14 04:24:05 Thuringen, Germany
3781826 3781826 2020-10-13 Germany Unknown     2654 0 0 2654     2020-10-14 04:24:05 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]);