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-02-10 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
1527804 1527804 2021-02-09 Germany Baden-Wurttemberg     301091 7509 276773 17785 48.6616 9.3501 2021-02-10 05:22:41 Baden-Wurttemberg, Germany
1527805 1527805 2021-02-09 Germany Bayern     414332 11226 378694 25211 48.7904 11.4979 2021-02-10 05:22:41 Bayern, Germany
1527806 1527806 2021-02-09 Germany Berlin     122890 2486 113443 7242 52.52 13.405 2021-02-10 05:22:41 Berlin, Germany
1527807 1527807 2021-02-09 Germany Brandenburg     71303 2668 62567 6376 52.4125 12.5316 2021-02-10 05:22:41 Brandenburg, Germany
1527808 1527808 2021-02-09 Germany Bremen     16569 293 15268 1049 53.0793 8.8017 2021-02-10 05:22:41 Bremen, Germany
1527809 1527809 2021-02-09 Germany Hamburg     47884 1148 42235 4661 53.5511 9.9937 2021-02-10 05:22:41 Hamburg, Germany
1527810 1527810 2021-02-09 Germany Hessen     177331 5229 160028 12664 50.6521 9.1624 2021-02-10 05:22:41 Hessen, Germany
1527811 1527811 2021-02-09 Germany Mecklenburg-Vorpommern     21351 579 18424 2535 53.6127 12.4296 2021-02-10 05:22:41 Mecklenburg-Vorpommern, Germany
1527812 1527812 2021-02-09 Germany Niedersachsen     148877 3635 135643 10022 52.6367 9.8451 2021-02-10 05:22:41 Niedersachsen, Germany
1527813 1527813 2021-02-09 Germany Nordrhein-Westfalen     500500 11595 456798 34172 51.4332 7.6616 2021-02-10 05:22:41 Nordrhein-Westfalen, Germany
1527814 1527814 2021-02-09 Germany Rheinland-Pfalz     96076 2764 85832 7739 50.1183 7.309 2021-02-10 05:22:41 Rheinland-Pfalz, Germany
1527815 1527815 2021-02-09 Germany Saarland     26952 787 24581 1698 49.3964 7.023 2021-02-10 05:22:41 Saarland, Germany
1527816 1527816 2021-02-09 Germany Sachsen     184880 6816 169250 9059 51.1045 13.2017 2021-02-10 05:22:41 Sachsen, Germany
1527817 1527817 2021-02-09 Germany Sachsen-Anhalt     54897 1990 48387 4850 51.9503 11.6923 2021-02-10 05:22:41 Sachsen-Anhalt, Germany
1527818 1527818 2021-02-09 Germany Schleswig-Holstein     38136 1038 32801 4581 54.2194 9.6961 2021-02-10 05:22:41 Schleswig-Holstein, Germany
1527819 1527819 2021-02-09 Germany Thuringen     68855 2393 61242 5500 51.011 10.8453 2021-02-10 05:22:41 Thuringen, Germany
1527820 1527820 2021-02-09 Germany Unknown     1935 0 0 1935     2021-02-10 05:22:41 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]);