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-08-06 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
1956434 1956434 2021-08-05 Germany Baden-Wurttemberg     506733 10422 0   48.6616 9.3501 2021-08-06 04:21:18 Baden-Wurttemberg, Germany
1956435 1956435 2021-08-05 Germany Bayern     654776 15348 0   48.7904 11.4979 2021-08-06 04:21:18 Bayern, Germany
1956436 1956436 2021-08-05 Germany Berlin     183583 3585 0   52.52 13.405 2021-08-06 04:21:18 Berlin, Germany
1956437 1956437 2021-08-05 Germany Brandenburg     109432 3818 0   52.4125 12.5316 2021-08-06 04:21:18 Brandenburg, Germany
1956438 1956438 2021-08-05 Germany Bremen     27995 493 0   53.0793 8.8017 2021-08-06 04:21:18 Bremen, Germany
1956439 1956439 2021-08-05 Germany Hamburg     79471 1621 0   53.5511 9.9937 2021-08-06 04:21:18 Hamburg, Germany
1956440 1956440 2021-08-05 Germany Hessen     295667 7592 0   50.6521 9.1624 2021-08-06 04:21:18 Hessen, Germany
1956441 1956441 2021-08-05 Germany Mecklenburg-Vorpommern     44588 1182 0   53.6127 12.4296 2021-08-06 04:21:18 Mecklenburg-Vorpommern, Germany
1956442 1956442 2021-08-05 Germany Niedersachsen     265981 5820 0   52.6367 9.8451 2021-08-06 04:21:18 Niedersachsen, Germany
1956443 1956443 2021-08-05 Germany Nordrhein-Westfalen     830647 17299 0   51.4332 7.6616 2021-08-06 04:21:18 Nordrhein-Westfalen, Germany
1956444 1956444 2021-08-05 Germany Rheinland-Pfalz     158039 3907 0   50.1183 7.309 2021-08-06 04:21:18 Rheinland-Pfalz, Germany
1956445 1956445 2021-08-05 Germany Saarland     42290 1030 0   49.3964 7.023 2021-08-06 04:21:18 Saarland, Germany
1956446 1956446 2021-08-05 Germany Sachsen     286828 10138 0   51.1045 13.2017 2021-08-06 04:21:18 Sachsen, Germany
1956447 1956447 2021-08-05 Germany Sachsen-Anhalt     99625 3454 0   51.9503 11.6923 2021-08-06 04:21:18 Sachsen-Anhalt, Germany
1956448 1956448 2021-08-05 Germany Schleswig-Holstein     66002 1639 0   54.2194 9.6961 2021-08-06 04:21:18 Schleswig-Holstein, Germany
1956449 1956449 2021-08-05 Germany Thuringen     129328 4382 0   51.011 10.8453 2021-08-06 04:21:18 Thuringen, Germany
1956450 1956450 2021-08-05 Germany Unknown     4796 0 0       2021-08-06 04:21:18 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]);