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

✎ View and edit SQL

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

Suggested facets: day (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
1006201 1006201 2020-12-06 Germany Baden-Wurttemberg     164843 3007 120243 43376 48.6616 9.3501 2020-12-07 05:26:14 Baden-Wurttemberg, Germany
1006202 1006202 2020-12-06 Germany Bayern     229675 4289 171004 56567 48.7904 11.4979 2020-12-07 05:26:14 Bayern, Germany
1006203 1006203 2020-12-06 Germany Berlin     71087 679 51095 19665 52.52 13.405 2020-12-07 05:26:14 Berlin, Germany
1006204 1006204 2020-12-06 Germany Brandenburg     22206 419 17368 5898 52.4125 12.5316 2020-12-07 05:26:14 Brandenburg, Germany
1006205 1006205 2020-12-06 Germany Bremen     10761 136 8936 1763 53.0793 8.8017 2020-12-07 05:26:14 Bremen, Germany
1006206 1006206 2020-12-06 Germany Hamburg     26619 419 19475 6957 53.5511 9.9937 2020-12-07 05:26:14 Hamburg, Germany
1006207 1006207 2020-12-06 Germany Hessen     95954 1460 68981 26178 50.6521 9.1624 2020-12-07 05:26:14 Hessen, Germany
1006208 1006208 2020-12-06 Germany Mecklenburg-Vorpommern     6687 74 5181 1527 53.6127 12.4296 2020-12-07 05:26:14 Mecklenburg-Vorpommern, Germany
1006209 1006209 2020-12-06 Germany Niedersachsen     77033 1261 63986 12489 52.6367 9.8451 2020-12-07 05:26:14 Niedersachsen, Germany
1006210 1006210 2020-12-06 Germany Nordrhein-Westfalen     284816 3924 219774 63450 51.4332 7.6616 2020-12-07 05:26:14 Nordrhein-Westfalen, Germany
1006211 1006211 2020-12-06 Germany Rheinland-Pfalz     48779 666 32233 16589 50.1183 7.309 2020-12-07 05:26:14 Rheinland-Pfalz, Germany
1006212 1006212 2020-12-06 Germany Saarland     13887 271 11611 2372 49.3964 7.023 2020-12-07 05:26:14 Saarland, Germany
1006213 1006213 2020-12-06 Germany Sachsen     68244 1279 41260 27616 51.1045 13.2017 2020-12-07 05:26:14 Sachsen, Germany
1006214 1006214 2020-12-06 Germany Sachsen-Anhalt     14616 208 10014 4727 51.9503 11.6923 2020-12-07 05:26:14 Sachsen-Anhalt, Germany
1006215 1006215 2020-12-06 Germany Schleswig-Holstein     15627 264 12636 2880 54.2194 9.6961 2020-12-07 05:26:14 Schleswig-Holstein, Germany
1006216 1006216 2020-12-06 Germany Thuringen     20489 416 14488 6067 51.011 10.8453 2020-12-07 05:26:14 Thuringen, Germany
1006217 1006217 2020-12-06 Germany Unknown     9155 0 0 9155     2020-12-07 05:26:14 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]);