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-27 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
2768855 2768855 2022-09-26 Germany Baden-Wurttemberg     4466430 17249 0   48.6616 9.3501 2022-09-27 04:23:01 Baden-Wurttemberg, Germany
2768856 2768856 2022-09-26 Germany Bayern     5973418 25778 0   48.7904 11.4979 2022-09-27 04:23:01 Bayern, Germany
2768857 2768857 2022-09-26 Germany Berlin     1257423 4807 0   52.52 13.405 2022-09-27 04:23:01 Berlin, Germany
2768858 2768858 2022-09-26 Germany Brandenburg     947908 5901 0   52.4125 12.5316 2022-09-27 04:23:01 Brandenburg, Germany
2768859 2768859 2022-09-26 Germany Bremen     257303 836 0   53.0793 8.8017 2022-09-27 04:23:01 Bremen, Germany
2768860 2768860 2022-09-26 Germany Hamburg     724372 3055 0   53.5511 9.9937 2022-09-27 04:23:01 Hamburg, Germany
2768861 2768861 2022-09-26 Germany Hessen     2482492 11061 0   50.6521 9.1624 2022-09-27 04:23:01 Hessen, Germany
2768862 2768862 2022-09-26 Germany Mecklenburg-Vorpommern     601580 2454 0   53.6127 12.4296 2022-09-27 04:23:01 Mecklenburg-Vorpommern, Germany
2768863 2768863 2022-09-26 Germany Niedersachsen     3187805 10751 0   52.6367 9.8451 2022-09-27 04:23:01 Niedersachsen, Germany
2768864 2768864 2022-09-26 Germany Nordrhein-Westfalen     6755098 27359 0   51.4332 7.6616 2022-09-27 04:23:01 Nordrhein-Westfalen, Germany
2768865 2768865 2022-09-26 Germany Rheinland-Pfalz     1493902 6160 0   50.1183 7.309 2022-09-27 04:23:01 Rheinland-Pfalz, Germany
2768866 2768866 2022-09-26 Germany Saarland     409349 1848 0   49.3964 7.023 2022-09-27 04:23:01 Saarland, Germany
2768867 2768867 2022-09-26 Germany Sachsen     1751659 16010 0   51.1045 13.2017 2022-09-27 04:23:01 Sachsen, Germany
2768868 2768868 2022-09-26 Germany Sachsen-Anhalt     838316 5703 0   51.9503 11.6923 2022-09-27 04:23:01 Sachsen-Anhalt, Germany
2768869 2768869 2022-09-26 Germany Schleswig-Holstein     1007139 2870 0   54.2194 9.6961 2022-09-27 04:23:01 Schleswig-Holstein, Germany
2768870 2768870 2022-09-26 Germany Thuringen     797856 7616 0   51.011 10.8453 2022-09-27 04:23:01 Thuringen, Germany
2768871 2768871 2022-09-26 Germany Unknown     0 0 0       2022-09-27 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]);