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-06-14 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
3381282 3381282 2021-06-13 Germany Baden-Wurttemberg     498142 10074 481400 6774 48.6616 9.3501 2021-06-14 04:22:46 Baden-Wurttemberg, Germany
3381283 3381283 2021-06-13 Germany Bayern     644999 15099 623800 6261 48.7904 11.4979 2021-06-14 04:22:46 Bayern, Germany
3381284 3381284 2021-06-13 Germany Berlin     179670 3517 174900 1276 52.52 13.405 2021-06-14 04:22:46 Berlin, Germany
3381285 3381285 2021-06-13 Germany Brandenburg     108641 3755 104000 898 52.4125 12.5316 2021-06-14 04:22:46 Brandenburg, Germany
3381286 3381286 2021-06-13 Germany Bremen     27341 478 26540 327 53.0793 8.8017 2021-06-14 04:22:46 Bremen, Germany
3381287 3381287 2021-06-13 Germany Hamburg     76876 1580 74100 1205 53.5511 9.9937 2021-06-14 04:22:46 Hamburg, Germany
3381288 3381288 2021-06-13 Germany Hessen     289484 7436 277000 5080 50.6521 9.1624 2021-06-14 04:22:46 Hessen, Germany
3381289 3381289 2021-06-13 Germany Mecklenburg-Vorpommern     44068 1145 42800 126 53.6127 12.4296 2021-06-14 04:22:46 Mecklenburg-Vorpommern, Germany
3381290 3381290 2021-06-13 Germany Niedersachsen     260206 5699 252800 1734 52.6367 9.8451 2021-06-14 04:22:46 Niedersachsen, Germany
3381291 3381291 2021-06-13 Germany Nordrhein-Westfalen     813246 16981 784100 12264 51.4332 7.6616 2021-06-14 04:22:46 Nordrhein-Westfalen, Germany
3381292 3381292 2021-06-13 Germany Rheinland-Pfalz     154441 3783 149100 1609 50.1183 7.309 2021-06-14 04:22:46 Rheinland-Pfalz, Germany
3381293 3381293 2021-06-13 Germany Saarland     41260 1016 39800 451 49.3964 7.023 2021-06-14 04:22:46 Saarland, Germany
3381294 3381294 2021-06-13 Germany Sachsen     285412 9974 271900 3575 51.1045 13.2017 2021-06-14 04:22:46 Sachsen, Germany
3381295 3381295 2021-06-13 Germany Sachsen-Anhalt     99071 3399 94400 1320 51.9503 11.6923 2021-06-14 04:22:46 Sachsen-Anhalt, Germany
3381296 3381296 2021-06-13 Germany Schleswig-Holstein     63634 1613 61300 724 54.2194 9.6961 2021-06-14 04:22:46 Schleswig-Holstein, Germany
3381297 3381297 2021-06-13 Germany Thuringen     128478 4285 123400 803 51.011 10.8453 2021-06-14 04:22:46 Thuringen, Germany
3381298 3381298 2021-06-13 Germany Unknown     7679 0 0 7679     2021-06-14 04:22:46 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]);