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-09-27 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
2613941 2613941 2020-09-26 Germany Baden-Wurttemberg     48467 1877 42844 3986 48.6616 9.3501 2020-09-27 04:23:00 Baden-Wurttemberg, Germany
2613942 2613942 2020-09-26 Germany Bayern     67005 2657 58945 5413 48.7904 11.4979 2020-09-27 04:23:00 Bayern, Germany
2613943 2613943 2020-09-26 Germany Berlin     13970 228 12242 1642 52.52 13.405 2020-09-27 04:23:00 Berlin, Germany
2613944 2613944 2020-09-26 Germany Brandenburg     4203 169 3880 190 52.4125 12.5316 2020-09-27 04:23:00 Brandenburg, Germany
2613945 2613945 2020-09-26 Germany Bremen     2320 59 2084 222 53.0793 8.8017 2020-09-27 04:23:00 Bremen, Germany
2613946 2613946 2020-09-26 Germany Hamburg     7550 269 6431 937 53.5511 9.9937 2020-09-27 04:23:00 Hamburg, Germany
2613947 2613947 2020-09-26 Germany Hessen     18396 549 16375 1472 50.6521 9.1624 2020-09-27 04:23:00 Hessen, Germany
2613948 2613948 2020-09-26 Germany Mecklenburg-Vorpommern     1151 20 1044 88 53.6127 12.4296 2020-09-27 04:23:00 Mecklenburg-Vorpommern, Germany
2613949 2613949 2020-09-26 Germany Niedersachsen     19748 683 17180 1893 52.6367 9.8451 2020-09-27 04:23:00 Niedersachsen, Germany
2613950 2613950 2020-09-26 Germany Nordrhein-Westfalen     67903 1863 60388 5652 51.4332 7.6616 2020-09-27 04:23:00 Nordrhein-Westfalen, Germany
2613951 2613951 2020-09-26 Germany Rheinland-Pfalz     10439 251 9479 742 50.1183 7.309 2020-09-27 04:23:00 Rheinland-Pfalz, Germany
2613952 2613952 2020-09-26 Germany Saarland     3288 176 3074 85 49.3964 7.023 2020-09-27 04:23:00 Saarland, Germany
2613953 2613953 2020-09-26 Germany Sachsen     7052 233 6082 737 51.1045 13.2017 2020-09-27 04:23:00 Sachsen, Germany
2613954 2613954 2020-09-26 Germany Sachsen-Anhalt     2536 67 2275 194 51.9503 11.6923 2020-09-27 04:23:00 Sachsen-Anhalt, Germany
2613955 2613955 2020-09-26 Germany Schleswig-Holstein     4656 161 4128 367 54.2194 9.6961 2020-09-27 04:23:00 Schleswig-Holstein, Germany
2613956 2613956 2020-09-26 Germany Thuringen     4046 190 3653 203 51.011 10.8453 2020-09-27 04:23:00 Thuringen, Germany
2613957 2613957 2020-09-26 Germany Unknown     1640 0 0 1640     2020-09-27 04:23:00 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]);