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

✎ View and edit SQL

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

Suggested facets: 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
678219 678219 2020-11-23 Germany Baden-Wurttemberg     133583 2449 91279 41044 48.6616 9.3501 2020-11-24 05:27:31 Baden-Wurttemberg, Germany
678220 678220 2020-11-23 Germany Bayern     183189 3440 126063 56250 48.7904 11.4979 2020-11-24 05:27:31 Bayern, Germany
678221 678221 2020-11-23 Germany Berlin     56504 449 36876 19977 52.52 13.405 2020-11-24 05:27:31 Berlin, Germany
678222 678222 2020-11-23 Germany Brandenburg     15673 280 12136 4515 52.4125 12.5316 2020-11-24 05:27:31 Brandenburg, Germany
678223 678223 2020-11-23 Germany Bremen     9284 108 7254 1952 53.0793 8.8017 2020-11-24 05:27:31 Bremen, Germany
678224 678224 2020-11-23 Germany Hamburg     22702 338 13718 8882 53.5511 9.9937 2020-11-24 05:27:31 Hamburg, Germany
678225 678225 2020-11-23 Germany Hessen     76341 1033 48143 28683 50.6521 9.1624 2020-11-24 05:27:31 Hessen, Germany
678226 678226 2020-11-23 Germany Mecklenburg-Vorpommern     5189 53 3845 1348 53.6127 12.4296 2020-11-24 05:27:31 Mecklenburg-Vorpommern, Germany
678227 678227 2020-11-23 Germany Niedersachsen     63305 1010 47137 16345 52.6367 9.8451 2020-11-24 05:27:31 Niedersachsen, Germany
678228 678228 2020-11-23 Germany Nordrhein-Westfalen     233020 2977 158342 75417 51.4332 7.6616 2020-11-24 05:27:31 Nordrhein-Westfalen, Germany
678229 678229 2020-11-23 Germany Rheinland-Pfalz     38309 420 22744 16097 50.1183 7.309 2020-11-24 05:27:31 Rheinland-Pfalz, Germany
678230 678230 2020-11-23 Germany Saarland     11385 236 9284 2188 49.3964 7.023 2020-11-24 05:27:31 Saarland, Germany
678231 678231 2020-11-23 Germany Sachsen     43967 667 27590 16655 51.1045 13.2017 2020-11-24 05:27:31 Sachsen, Germany
678232 678232 2020-11-23 Germany Sachsen-Anhalt     10030 122 6969 3236 51.9503 11.6923 2020-11-24 05:27:31 Sachsen-Anhalt, Germany
678233 678233 2020-11-23 Germany Schleswig-Holstein     12912 234 9623 3196 54.2194 9.6961 2020-11-24 05:27:31 Schleswig-Holstein, Germany
678234 678234 2020-11-23 Germany Thuringen     13740 296 9372 4487 51.011 10.8453 2020-11-24 05:27:31 Thuringen, Germany
678235 678235 2020-11-23 Germany Unknown     1715 0 0 1715     2020-11-24 05:27:31 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]);