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-21 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
2016615 2016615 2022-09-20 Germany Baden-Wurttemberg     4443873 17217 0   48.6616 9.3501 2022-09-21 04:23:22 Baden-Wurttemberg, Germany
2016616 2016616 2022-09-20 Germany Bayern     5934894 25721 0   48.7904 11.4979 2022-09-21 04:23:22 Bayern, Germany
2016617 2016617 2022-09-20 Germany Berlin     1251012 4796 0   52.52 13.405 2022-09-21 04:23:22 Berlin, Germany
2016618 2016618 2022-09-20 Germany Brandenburg     940485 5892 0   52.4125 12.5316 2022-09-21 04:23:22 Brandenburg, Germany
2016619 2016619 2022-09-20 Germany Bremen     255530 834 0   53.0793 8.8017 2022-09-21 04:23:22 Bremen, Germany
2016620 2016620 2022-09-20 Germany Hamburg     721770 3026 0   53.5511 9.9937 2022-09-21 04:23:22 Hamburg, Germany
2016621 2016621 2022-09-20 Germany Hessen     2462346 11035 0   50.6521 9.1624 2022-09-21 04:23:22 Hessen, Germany
2016622 2016622 2022-09-20 Germany Mecklenburg-Vorpommern     596608 2446 0   53.6127 12.4296 2022-09-21 04:23:22 Mecklenburg-Vorpommern, Germany
2016623 2016623 2022-09-20 Germany Niedersachsen     3164780 10713 0   52.6367 9.8451 2022-09-21 04:23:22 Niedersachsen, Germany
2016624 2016624 2022-09-20 Germany Nordrhein-Westfalen     6717232 27288 0   51.4332 7.6616 2022-09-21 04:23:22 Nordrhein-Westfalen, Germany
2016625 2016625 2022-09-20 Germany Rheinland-Pfalz     1479001 6130 0   50.1183 7.309 2022-09-21 04:23:22 Rheinland-Pfalz, Germany
2016626 2016626 2022-09-20 Germany Saarland     405472 1841 0   49.3964 7.023 2022-09-21 04:23:22 Saarland, Germany
2016627 2016627 2022-09-20 Germany Sachsen     1740186 15980 0   51.1045 13.2017 2022-09-21 04:23:22 Sachsen, Germany
2016628 2016628 2022-09-20 Germany Sachsen-Anhalt     833337 5694 0   51.9503 11.6923 2022-09-21 04:23:22 Sachsen-Anhalt, Germany
2016629 2016629 2022-09-20 Germany Schleswig-Holstein     1000635 2862 0   54.2194 9.6961 2022-09-21 04:23:22 Schleswig-Holstein, Germany
2016630 2016630 2022-09-20 Germany Thuringen     793432 7604 0   51.011 10.8453 2022-09-21 04:23:22 Thuringen, Germany
2016631 2016631 2022-09-20 Germany Unknown     0 0 0       2022-09-21 04:23:22 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]);