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-02-04 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
2473846 2473846 2022-02-03 Germany Baden-Wurttemberg     1432455 13720 0   48.6616 9.3501 2022-02-04 04:21:10 Baden-Wurttemberg, Germany
2473847 2473847 2022-02-03 Germany Bayern     1882637 20563 0   48.7904 11.4979 2022-02-04 04:21:10 Bayern, Germany
2473848 2473848 2022-02-03 Germany Berlin     570739 4129 0   52.52 13.405 2022-02-04 04:21:10 Berlin, Germany
2473849 2473849 2022-02-03 Germany Brandenburg     362782 5012 0   52.4125 12.5316 2022-02-04 04:21:10 Brandenburg, Germany
2473850 2473850 2022-02-03 Germany Bremen     90518 654 0   53.0793 8.8017 2022-02-04 04:21:10 Bremen, Germany
2473851 2473851 2022-02-03 Germany Hamburg     265604 2150 0   53.5511 9.9937 2022-02-04 04:21:10 Hamburg, Germany
2473852 2473852 2022-02-03 Germany Hessen     760014 8855 0   50.6521 9.1624 2022-02-04 04:21:10 Hessen, Germany
2473853 2473853 2022-02-03 Germany Mecklenburg-Vorpommern     156320 1650 0   53.6127 12.4296 2022-02-04 04:21:10 Mecklenburg-Vorpommern, Germany
2473854 2473854 2022-02-03 Germany Niedersachsen     691192 7120 0   52.6367 9.8451 2022-02-04 04:21:10 Niedersachsen, Germany
2473855 2473855 2022-02-03 Germany Nordrhein-Westfalen     2113546 21193 0   51.4332 7.6616 2022-02-04 04:21:10 Nordrhein-Westfalen, Germany
2473856 2473856 2022-02-03 Germany Rheinland-Pfalz     403218 4819 0   50.1183 7.309 2022-02-04 04:21:10 Rheinland-Pfalz, Germany
2473857 2473857 2022-02-03 Germany Saarland     109740 1335 0   49.3964 7.023 2022-02-04 04:21:10 Saarland, Germany
2473858 2473858 2022-02-03 Germany Sachsen     744799 14105 0   51.1045 13.2017 2022-02-04 04:21:10 Sachsen, Germany
2473859 2473859 2022-02-03 Germany Sachsen-Anhalt     278722 4613 0   51.9503 11.6923 2022-02-04 04:21:10 Sachsen-Anhalt, Germany
2473860 2473860 2022-02-03 Germany Schleswig-Holstein     232964 1984 0   54.2194 9.6961 2022-02-04 04:21:10 Schleswig-Holstein, Germany
2473861 2473861 2022-02-03 Germany Thuringen     327514 6432 0   51.011 10.8453 2022-02-04 04:21:10 Thuringen, Germany
2473862 2473862 2022-02-03 Germany Unknown     51966 0 0       2022-02-04 04:21:10 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]);