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-19 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
1755189 1755189 2022-11-18 Germany Baden-Wurttemberg     4869507 17994 0   48.6616 9.3501 2022-11-19 04:21:14 Baden-Wurttemberg, Germany
1755190 1755190 2022-11-18 Germany Bayern     6513971 26908 0   48.7904 11.4979 2022-11-19 04:21:14 Bayern, Germany
1755191 1755191 2022-11-18 Germany Berlin     1350249 5071 0   52.52 13.405 2022-11-19 04:21:14 Berlin, Germany
1755192 1755192 2022-11-18 Germany Brandenburg     1046483 6135 0   52.4125 12.5316 2022-11-19 04:21:14 Brandenburg, Germany
1755193 1755193 2022-11-18 Germany Bremen     282590 880 0   53.0793 8.8017 2022-11-19 04:21:14 Bremen, Germany
1755194 1755194 2022-11-18 Germany Hamburg     770757 3219 0   53.5511 9.9937 2022-11-19 04:21:14 Hamburg, Germany
1755195 1755195 2022-11-18 Germany Hessen     2772246 11569 0   50.6521 9.1624 2022-11-19 04:21:14 Hessen, Germany
1755196 1755196 2022-11-18 Germany Mecklenburg-Vorpommern     666300 2569 0   53.6127 12.4296 2022-11-19 04:21:14 Mecklenburg-Vorpommern, Germany
1755197 1755197 2022-11-18 Germany Niedersachsen     3544416 11595 0   52.6367 9.8451 2022-11-19 04:21:14 Niedersachsen, Germany
1755198 1755198 2022-11-18 Germany Nordrhein-Westfalen     7455324 28702 0   51.4332 7.6616 2022-11-19 04:21:14 Nordrhein-Westfalen, Germany
1755199 1755199 2022-11-18 Germany Rheinland-Pfalz     1673066 6495 0   50.1183 7.309 2022-11-19 04:21:14 Rheinland-Pfalz, Germany
1755200 1755200 2022-11-18 Germany Saarland     465995 1955 0   49.3964 7.023 2022-11-19 04:21:14 Saarland, Germany
1755201 1755201 2022-11-18 Germany Sachsen     1886171 16329 0   51.1045 13.2017 2022-11-19 04:21:14 Sachsen, Germany
1755202 1755202 2022-11-18 Germany Sachsen-Anhalt     916914 5987 0   51.9503 11.6923 2022-11-19 04:21:14 Sachsen-Anhalt, Germany
1755203 1755203 2022-11-18 Germany Schleswig-Holstein     1108328 3111 0   54.2194 9.6961 2022-11-19 04:21:14 Schleswig-Holstein, Germany
1755204 1755204 2022-11-18 Germany Thuringen     857760 7891 0   51.011 10.8453 2022-11-19 04:21:14 Thuringen, Germany
1755205 1755205 2022-11-18 Germany Unknown     0 0 0       2022-11-19 04:21:14 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]);