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-11 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
1173090 1173090 2020-09-10 Germany Baden-Wurttemberg     44396 1868 39246 3496 48.6616 9.3501 2020-09-11 04:46:23 Baden-Wurttemberg, Germany
1173091 1173091 2020-09-10 Germany Bayern     60759 2644 53914 4428 48.7904 11.4979 2020-09-11 04:46:23 Bayern, Germany
1173092 1173092 2020-09-10 Germany Berlin     11951 226 11012 851 52.52 13.405 2020-09-11 04:46:23 Berlin, Germany
1173093 1173093 2020-09-10 Germany Brandenburg     3966 169 3710 117 52.4125 12.5316 2020-09-11 04:46:23 Brandenburg, Germany
1173094 1173094 2020-09-10 Germany Bremen     2094 58 1914 140 53.0793 8.8017 2020-09-11 04:46:23 Bremen, Germany
1173095 1173095 2020-09-10 Germany Hamburg     6626 267 5813 618 53.5511 9.9937 2020-09-11 04:46:23 Hamburg, Germany
1173096 1173096 2020-09-10 Germany Hessen     16500 537 14707 1256 50.6521 9.1624 2020-09-11 04:46:23 Hessen, Germany
1173097 1173097 2020-09-10 Germany Mecklenburg-Vorpommern     1044 20 987 39 53.6127 12.4296 2020-09-11 04:46:23 Mecklenburg-Vorpommern, Germany
1173098 1173098 2020-09-10 Germany Niedersachsen     17572 665 15745 1207 52.6367 9.8451 2020-09-11 04:46:23 Niedersachsen, Germany
1173099 1173099 2020-09-10 Germany Nordrhein-Westfalen     61201 1827 56620 2754 51.4332 7.6616 2020-09-11 04:46:23 Nordrhein-Westfalen, Germany
1173100 1173100 2020-09-10 Germany Rheinland-Pfalz     9560 245 8583 742 50.1183 7.309 2020-09-11 04:46:23 Rheinland-Pfalz, Germany
1173101 1173101 2020-09-10 Germany Saarland     3218 175 2944 99 49.3964 7.023 2020-09-11 04:46:23 Saarland, Germany
1173102 1173102 2020-09-10 Germany Sachsen     6255 225 5648 404 51.1045 13.2017 2020-09-11 04:46:23 Sachsen, Germany
1173103 1173103 2020-09-10 Germany Sachsen-Anhalt     2305 66 2151 100 51.9503 11.6923 2020-09-11 04:46:23 Sachsen-Anhalt, Germany
1173104 1173104 2020-09-10 Germany Schleswig-Holstein     4197 161 3864 182 54.2194 9.6961 2020-09-11 04:46:23 Schleswig-Holstein, Germany
1173105 1173105 2020-09-10 Germany Thuringen     3722 188 3425 109 51.011 10.8453 2020-09-11 04:46:23 Thuringen, Germany
1173106 1173106 2020-09-10 Germany Unknown     1979 0 0 1979     2020-09-11 04:46:23 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]);