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 2022-09-28 sorted by day descending

✎ View and edit SQL

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

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
3994527 3994527 2022-09-27 Germany Baden-Wurttemberg     4476662 17265 0   48.6616 9.3501 2022-09-28 04:23:01 Baden-Wurttemberg, Germany
3994528 3994528 2022-09-27 Germany Bayern     5994222 25786 0   48.7904 11.4979 2022-09-28 04:23:01 Bayern, Germany
3994529 3994529 2022-09-27 Germany Berlin     1259680 4808 0   52.52 13.405 2022-09-28 04:23:01 Berlin, Germany
3994530 3994530 2022-09-27 Germany Brandenburg     950200 5906 0   52.4125 12.5316 2022-09-28 04:23:01 Brandenburg, Germany
3994531 3994531 2022-09-27 Germany Bremen     258143 836 0   53.0793 8.8017 2022-09-28 04:23:01 Bremen, Germany
3994532 3994532 2022-09-27 Germany Hamburg     725678 3058 0   53.5511 9.9937 2022-09-28 04:23:01 Hamburg, Germany
3994533 3994533 2022-09-27 Germany Hessen     2491695 11065 0   50.6521 9.1624 2022-09-28 04:23:01 Hessen, Germany
3994534 3994534 2022-09-27 Germany Mecklenburg-Vorpommern     603135 2455 0   53.6127 12.4296 2022-09-28 04:23:01 Mecklenburg-Vorpommern, Germany
3994535 3994535 2022-09-27 Germany Niedersachsen     3195581 10771 0   52.6367 9.8451 2022-09-28 04:23:01 Niedersachsen, Germany
3994536 3994536 2022-09-27 Germany Nordrhein-Westfalen     6771445 27384 0   51.4332 7.6616 2022-09-28 04:23:01 Nordrhein-Westfalen, Germany
3994537 3994537 2022-09-27 Germany Rheinland-Pfalz     1498625 6164 0   50.1183 7.309 2022-09-28 04:23:01 Rheinland-Pfalz, Germany
3994538 3994538 2022-09-27 Germany Saarland     410974 1848 0   49.3964 7.023 2022-09-28 04:23:01 Saarland, Germany
3994539 3994539 2022-09-27 Germany Sachsen     1755366 16022 0   51.1045 13.2017 2022-09-28 04:23:01 Sachsen, Germany
3994540 3994540 2022-09-27 Germany Sachsen-Anhalt     840148 5708 0   51.9503 11.6923 2022-09-28 04:23:01 Sachsen-Anhalt, Germany
3994541 3994541 2022-09-27 Germany Schleswig-Holstein     1009984 2878 0   54.2194 9.6961 2022-09-28 04:23:01 Schleswig-Holstein, Germany
3994542 3994542 2022-09-27 Germany Thuringen     799794 7622 0   51.011 10.8453 2022-09-28 04:23:01 Thuringen, Germany
3994543 3994543 2022-09-27 Germany Unknown     0 0 0       2022-09-28 04:23:01 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]);