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-07-18 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
3706032 3706032 2021-07-17 Germany Baden-Wurttemberg     502346 10333 490600 1905 48.6616 9.3501 2021-07-18 04:22:07 Baden-Wurttemberg, Germany
3706033 3706033 2021-07-17 Germany Bayern     649837 15304 632100 2923 48.7904 11.4979 2021-07-18 04:22:07 Bayern, Germany
3706034 3706034 2021-07-17 Germany Berlin     181017 3568 176700 879 52.52 13.405 2021-07-18 04:22:07 Berlin, Germany
3706035 3706035 2021-07-17 Germany Brandenburg     108908 3815 104700 417 52.4125 12.5316 2021-07-18 04:22:07 Brandenburg, Germany
3706036 3706036 2021-07-17 Germany Bremen     27604 489 26970 171 53.0793 8.8017 2021-07-18 04:22:07 Bremen, Germany
3706037 3706037 2021-07-17 Germany Hamburg     77823 1603 75700 601 53.5511 9.9937 2021-07-18 04:22:07 Hamburg, Germany
3706038 3706038 2021-07-17 Germany Hessen     292286 7563 283300 1758 50.6521 9.1624 2021-07-18 04:22:07 Hessen, Germany
3706039 3706039 2021-07-17 Germany Mecklenburg-Vorpommern     44225 1164 42960 117 53.6127 12.4296 2021-07-18 04:22:07 Mecklenburg-Vorpommern, Germany
3706040 3706040 2021-07-17 Germany Niedersachsen     262161 5802 255500 1182 52.6367 9.8451 2021-07-18 04:22:07 Niedersachsen, Germany
3706041 3706041 2021-07-17 Germany Nordrhein-Westfalen     819373 17238 799200 3686 51.4332 7.6616 2021-07-18 04:22:07 Nordrhein-Westfalen, Germany
3706042 3706042 2021-07-17 Germany Rheinland-Pfalz     155950 3895 151200 971 50.1183 7.309 2021-07-18 04:22:07 Rheinland-Pfalz, Germany
3706043 3706043 2021-07-17 Germany Saarland     41661 1030 40560 97 49.3964 7.023 2021-07-18 04:22:07 Saarland, Germany
3706044 3706044 2021-07-17 Germany Sachsen     286128 10111 275700 391 51.1045 13.2017 2021-07-18 04:22:07 Sachsen, Germany
3706045 3706045 2021-07-17 Germany Sachsen-Anhalt     99316 3434 95830 114 51.9503 11.6923 2021-07-18 04:22:07 Sachsen-Anhalt, Germany
3706046 3706046 2021-07-17 Germany Schleswig-Holstein     64221 1628 62260 421 54.2194 9.6961 2021-07-18 04:22:07 Schleswig-Holstein, Germany
3706047 3706047 2021-07-17 Germany Thuringen     128925 4360 124200 384 51.011 10.8453 2021-07-18 04:22:07 Thuringen, Germany
3706048 3706048 2021-07-17 Germany Unknown     6387 0 0 6387     2021-07-18 04:22:07 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]);