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-02-28 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

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
2732916 2732916 2022-02-27 Germany Baden-Wurttemberg     2031016 14191 0   48.6616 9.3501 2022-02-28 04:21:05 Baden-Wurttemberg, Germany
2732917 2732917 2022-02-27 Germany Bayern     2687779 21266 0   48.7904 11.4979 2022-02-28 04:21:05 Bayern, Germany
2732918 2732918 2022-02-27 Germany Berlin     727110 4242 0   52.52 13.405 2022-02-28 04:21:05 Berlin, Germany
2732919 2732919 2022-02-27 Germany Brandenburg     502811 5175 0   52.4125 12.5316 2022-02-28 04:21:05 Brandenburg, Germany
2732920 2732920 2022-02-27 Germany Bremen     113399 678 0   53.0793 8.8017 2022-02-28 04:21:05 Bremen, Germany
2732921 2732921 2022-02-27 Germany Hamburg     343788 2286 0   53.5511 9.9937 2022-02-28 04:21:05 Hamburg, Germany
2732922 2732922 2022-02-27 Germany Hessen     1043813 9139 0   50.6521 9.1624 2022-02-28 04:21:05 Hessen, Germany
2732923 2732923 2022-02-27 Germany Mecklenburg-Vorpommern     230191 1746 0   53.6127 12.4296 2022-02-28 04:21:05 Mecklenburg-Vorpommern, Germany
2732924 2732924 2022-02-27 Germany Niedersachsen     1011016 7417 0   52.6367 9.8451 2022-02-28 04:21:05 Niedersachsen, Germany
2732925 2732925 2022-02-27 Germany Nordrhein-Westfalen     2976909 22141 0   51.4332 7.6616 2022-02-28 04:21:05 Nordrhein-Westfalen, Germany
2732926 2732926 2022-02-27 Germany Rheinland-Pfalz     557620 4973 0   50.1183 7.309 2022-02-28 04:21:05 Rheinland-Pfalz, Germany
2732927 2732927 2022-02-27 Germany Saarland     154010 1398 0   49.3964 7.023 2022-02-28 04:21:05 Saarland, Germany
2732928 2732928 2022-02-27 Germany Sachsen     914758 14288 0   51.1045 13.2017 2022-02-28 04:21:05 Sachsen, Germany
2732929 2732929 2022-02-27 Germany Sachsen-Anhalt     393336 4732 0   51.9503 11.6923 2022-02-28 04:21:05 Sachsen-Anhalt, Germany
2732930 2732930 2022-02-27 Germany Schleswig-Holstein     311289 2102 0   54.2194 9.6961 2022-02-28 04:21:05 Schleswig-Holstein, Germany
2732931 2732931 2022-02-27 Germany Thuringen     400167 6597 0   51.011 10.8453 2022-02-28 04:21:05 Thuringen, Germany
2732932 2732932 2022-02-27 Germany Unknown     29886 0 0       2022-02-28 04:21:05 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]);