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-04-02 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
1301959 1301959 2021-04-01 Germany Baden-Wurttemberg     364953 8704 331000 28003 48.6616 9.3501 2021-04-02 04:20:36 Baden-Wurttemberg, Germany
1301960 1301960 2021-04-01 Germany Bayern     500549 13263 453400 37203 48.7904 11.4979 2021-04-02 04:20:36 Bayern, Germany
1301961 1301961 2021-04-01 Germany Berlin     146257 3054 135000 9403 52.52 13.405 2021-04-02 04:20:36 Berlin, Germany
1301962 1301962 2021-04-01 Germany Brandenburg     88464 3306 78570 7315 52.4125 12.5316 2021-04-02 04:20:36 Brandenburg, Germany
1301963 1301963 2021-04-01 Germany Bremen     20970 406 19170 1561 53.0793 8.8017 2021-04-02 04:20:36 Bremen, Germany
1301964 1301964 2021-04-01 Germany Hamburg     61257 1382 53570 6846 53.5511 9.9937 2021-04-02 04:20:36 Hamburg, Germany
1301965 1301965 2021-04-01 Germany Hessen     219484 6338 195800 19329 50.6521 9.1624 2021-04-02 04:20:36 Hessen, Germany
1301966 1301966 2021-04-01 Germany Mecklenburg-Vorpommern     30650 867 27110 2981 53.6127 12.4296 2021-04-02 04:20:36 Mecklenburg-Vorpommern, Germany
1301967 1301967 2021-04-01 Germany Niedersachsen     198107 4880 179000 15875 52.6367 9.8451 2021-04-02 04:20:36 Niedersachsen, Germany
1301968 1301968 2021-04-01 Germany Nordrhein-Westfalen     612947 14230 554100 49248 51.4332 7.6616 2021-04-02 04:20:36 Nordrhein-Westfalen, Germany
1301969 1301969 2021-04-01 Germany Rheinland-Pfalz     116795 3328 105300 9047 50.1183 7.309 2021-04-02 04:20:36 Rheinland-Pfalz, Germany
1301970 1301970 2021-04-01 Germany Saarland     31923 926 29700 1485 49.3964 7.023 2021-04-02 04:20:36 Saarland, Germany
1301971 1301971 2021-04-01 Germany Sachsen     222264 8373 197600 17877 51.1045 13.2017 2021-04-02 04:20:36 Sachsen, Germany
1301972 1301972 2021-04-01 Germany Sachsen-Anhalt     73163 2713 64940 6367 51.9503 11.6923 2021-04-02 04:20:36 Sachsen-Anhalt, Germany
1301973 1301973 2021-04-01 Germany Schleswig-Holstein     49996 1436 44740 4176 54.2194 9.6961 2021-04-02 04:20:36 Schleswig-Holstein, Germany
1301974 1301974 2021-04-01 Germany Thuringen     95394 3337 83020 9875 51.011 10.8453 2021-04-02 04:20:36 Thuringen, Germany
1301975 1301975 2021-04-01 Germany Unknown     10889 0 0 10889     2021-04-02 04:20:36 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]);