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-01-03 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
2227427 2227427 2021-01-02 Germany Baden-Wurttemberg     242744 4894 192449 46540 48.6616 9.3501 2021-01-03 05:22:52 Baden-Wurttemberg, Germany
2227428 2227428 2021-01-02 Germany Bayern     330855 6811 266937 58814 48.7904 11.4979 2021-01-03 05:22:52 Bayern, Germany
2227429 2227429 2021-01-02 Germany Berlin     97637 1277 79296 17528 52.52 13.405 2021-01-03 05:22:52 Berlin, Germany
2227430 2227430 2021-01-02 Germany Brandenburg     42384 982 32837 13216 52.4125 12.5316 2021-01-03 05:22:52 Brandenburg, Germany
2227431 2227431 2021-01-02 Germany Bremen     13703 201 12067 1449 53.0793 8.8017 2021-01-03 05:22:52 Bremen, Germany
2227432 2227432 2021-01-02 Germany Hamburg     37293 658 27512 9366 53.5511 9.9937 2021-01-03 05:22:52 Hamburg, Germany
2227433 2227433 2021-01-02 Germany Hessen     139368 2917 110076 26927 50.6521 9.1624 2021-01-03 05:22:52 Hessen, Germany
2227434 2227434 2021-01-02 Germany Mecklenburg-Vorpommern     12362 173 9644 2636 53.6127 12.4296 2021-01-03 05:22:52 Mecklenburg-Vorpommern, Germany
2227435 2227435 2021-01-02 Germany Niedersachsen     109810 2016 93305 14938 52.6367 9.8451 2021-01-03 05:22:52 Niedersachsen, Germany
2227436 2227436 2021-01-02 Germany Nordrhein-Westfalen     398678 6701 328729 65114 51.4332 7.6616 2021-01-03 05:22:52 Nordrhein-Westfalen, Germany
2227437 2227437 2021-01-02 Germany Rheinland-Pfalz     73545 1459 54772 17683 50.1183 7.309 2021-01-03 05:22:52 Rheinland-Pfalz, Germany
2227438 2227438 2021-01-02 Germany Saarland     20111 440 18334 1811 49.3964 7.023 2021-01-03 05:22:52 Saarland, Germany
2227439 2227439 2021-01-02 Germany Sachsen     137031 3302 100600 34379 51.1045 13.2017 2021-01-03 05:22:52 Sachsen, Germany
2227440 2227440 2021-01-02 Germany Sachsen-Anhalt     30708 666 23248 7899 51.9503 11.6923 2021-01-03 05:22:52 Sachsen-Anhalt, Germany
2227441 2227441 2021-01-02 Germany Schleswig-Holstein     25247 436 19176 5921 54.2194 9.6961 2021-01-03 05:22:52 Schleswig-Holstein, Germany
2227442 2227442 2021-01-02 Germany Thuringen     43875 1027 31828 11508 51.011 10.8453 2021-01-03 05:22:52 Thuringen, Germany
2227443 2227443 2021-01-02 Germany Unknown     2521 0 0 2521     2021-01-03 05:22:52 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]);