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-11-24 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
3312124 3312124 2022-11-23 Germany Baden-Wurttemberg     4880406 18038 0   48.6616 9.3501 2022-11-24 04:21:09 Baden-Wurttemberg, Germany
3312125 3312125 2022-11-23 Germany Bayern     6523530 27003 0   48.7904 11.4979 2022-11-24 04:21:09 Bayern, Germany
3312126 3312126 2022-11-23 Germany Berlin     1354005 5098 0   52.52 13.405 2022-11-24 04:21:09 Berlin, Germany
3312127 3312127 2022-11-23 Germany Brandenburg     1050201 6157 0   52.4125 12.5316 2022-11-24 04:21:09 Brandenburg, Germany
3312128 3312128 2022-11-23 Germany Bremen     283797 880 0   53.0793 8.8017 2022-11-24 04:21:09 Bremen, Germany
3312129 3312129 2022-11-23 Germany Hamburg     773225 3227 0   53.5511 9.9937 2022-11-24 04:21:09 Hamburg, Germany
3312130 3312130 2022-11-23 Germany Hessen     2779809 11613 0   50.6521 9.1624 2022-11-24 04:21:09 Hessen, Germany
3312131 3312131 2022-11-23 Germany Mecklenburg-Vorpommern     669142 2572 0   53.6127 12.4296 2022-11-24 04:21:09 Mecklenburg-Vorpommern, Germany
3312132 3312132 2022-11-23 Germany Niedersachsen     3554281 11648 0   52.6367 9.8451 2022-11-24 04:21:09 Niedersachsen, Germany
3312133 3312133 2022-11-23 Germany Nordrhein-Westfalen     7485125 28837 0   51.4332 7.6616 2022-11-24 04:21:09 Nordrhein-Westfalen, Germany
3312134 3312134 2022-11-23 Germany Rheinland-Pfalz     1678133 6527 0   50.1183 7.309 2022-11-24 04:21:09 Rheinland-Pfalz, Germany
3312135 3312135 2022-11-23 Germany Saarland     467428 1960 0   49.3964 7.023 2022-11-24 04:21:09 Saarland, Germany
3312136 3312136 2022-11-23 Germany Sachsen     1890551 16351 0   51.1045 13.2017 2022-11-24 04:21:09 Sachsen, Germany
3312137 3312137 2022-11-23 Germany Sachsen-Anhalt     919627 6020 0   51.9503 11.6923 2022-11-24 04:21:09 Sachsen-Anhalt, Germany
3312138 3312138 2022-11-23 Germany Schleswig-Holstein     1111708 3123 0   54.2194 9.6961 2022-11-24 04:21:09 Schleswig-Holstein, Germany
3312139 3312139 2022-11-23 Germany Thuringen     859403 7897 0   51.011 10.8453 2022-11-24 04:21:09 Thuringen, Germany
3312140 3312140 2022-11-23 Germany Unknown     0 0 0       2022-11-24 04:21:09 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]);