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

✎ View and edit SQL

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

Suggested facets: day (date), 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
1712232 1712232 2021-06-25 Germany Baden-Wurttemberg     500093 10195 487400 2879 48.6616 9.3501 2021-06-26 04:21:43 Baden-Wurttemberg, Germany
1712233 1712233 2021-06-25 Germany Bayern     647107 15233 628700 3292 48.7904 11.4979 2021-06-26 04:21:43 Bayern, Germany
1712234 1712234 2021-06-25 Germany Berlin     180071 3552 175800 768 52.52 13.405 2021-06-26 04:21:43 Berlin, Germany
1712235 1712235 2021-06-25 Germany Brandenburg     108649 3792 104600 271 52.4125 12.5316 2021-06-26 04:21:43 Brandenburg, Germany
1712236 1712236 2021-06-25 Germany Bremen     27423 483 26810 136 53.0793 8.8017 2021-06-26 04:21:43 Bremen, Germany
1712237 1712237 2021-06-25 Germany Hamburg     77235 1589 75000 665 53.5511 9.9937 2021-06-26 04:21:43 Hamburg, Germany
1712238 1712238 2021-06-25 Germany Hessen     290538 7501 281100 2020 50.6521 9.1624 2021-06-26 04:21:43 Hessen, Germany
1712239 1712239 2021-06-25 Germany Mecklenburg-Vorpommern     44121 1151 42910 72 53.6127 12.4296 2021-06-26 04:21:43 Mecklenburg-Vorpommern, Germany
1712240 1712240 2021-06-25 Germany Niedersachsen     260843 5754 254100 1015 52.6367 9.8451 2021-06-26 04:21:43 Niedersachsen, Germany
1712241 1712241 2021-06-25 Germany Nordrhein-Westfalen     815516 17105 794600 3950 51.4332 7.6616 2021-06-26 04:21:43 Nordrhein-Westfalen, Germany
1712242 1712242 2021-06-25 Germany Rheinland-Pfalz     155034 3874 150400 798 50.1183 7.309 2021-06-26 04:21:43 Rheinland-Pfalz, Germany
1712243 1712243 2021-06-25 Germany Saarland     41435 1019 40270 154 49.3964 7.023 2021-06-26 04:21:43 Saarland, Germany
1712244 1712244 2021-06-25 Germany Sachsen     285755 10063 274600 1115 51.1045 13.2017 2021-06-26 04:21:43 Sachsen, Germany
1712245 1712245 2021-06-25 Germany Sachsen-Anhalt     99208 3423 95450 386 51.9503 11.6923 2021-06-26 04:21:43 Sachsen-Anhalt, Germany
1712246 1712246 2021-06-25 Germany Schleswig-Holstein     63824 1620 61830 388 54.2194 9.6961 2021-06-26 04:21:43 Schleswig-Holstein, Germany
1712247 1712247 2021-06-25 Germany Thuringen     128728 4324 123900 510 51.011 10.8453 2021-06-26 04:21:43 Thuringen, Germany
1712248 1712248 2021-06-25 Germany Unknown     7024 0 0 7024     2021-06-26 04:21:43 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]);