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-07-05 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
1165075 1165075 2021-07-04 Germany Baden-Wurttemberg     500787 10272 488800 2180 48.6616 9.3501 2021-07-05 04:21:28 Baden-Wurttemberg, Germany
1165076 1165076 2021-07-04 Germany Bayern     647744 15267 630500 2220 48.7904 11.4979 2021-07-05 04:21:28 Bayern, Germany
1165077 1165077 2021-07-04 Germany Berlin     180225 3560 176500 216 52.52 13.405 2021-07-05 04:21:28 Berlin, Germany
1165078 1165078 2021-07-04 Germany Brandenburg     108706 3807 104600 311 52.4125 12.5316 2021-07-05 04:21:28 Brandenburg, Germany
1165079 1165079 2021-07-04 Germany Bremen     27458 487 26890 98 53.0793 8.8017 2021-07-05 04:21:28 Bremen, Germany
1165080 1165080 2021-07-04 Germany Hamburg     77396 1597 75300 570 53.5511 9.9937 2021-07-05 04:21:28 Hamburg, Germany
1165081 1165081 2021-07-04 Germany Hessen     290994 7538 282500 1153 50.6521 9.1624 2021-07-05 04:21:28 Hessen, Germany
1165082 1165082 2021-07-04 Germany Mecklenburg-Vorpommern     44156 1156 42930 79 53.6127 12.4296 2021-07-05 04:21:28 Mecklenburg-Vorpommern, Germany
1165083 1165083 2021-07-04 Germany Niedersachsen     261107 5769 254700 748 52.6367 9.8451 2021-07-05 04:21:28 Niedersachsen, Germany
1165084 1165084 2021-07-04 Germany Nordrhein-Westfalen     816500 17165 796900 2767 51.4332 7.6616 2021-07-05 04:21:28 Nordrhein-Westfalen, Germany
1165085 1165085 2021-07-04 Germany Rheinland-Pfalz     155262 3892 150500 943 50.1183 7.309 2021-07-05 04:21:28 Rheinland-Pfalz, Germany
1165086 1165086 2021-07-04 Germany Saarland     41497 1024 40360 133 49.3964 7.023 2021-07-05 04:21:28 Saarland, Germany
1165087 1165087 2021-07-04 Germany Sachsen     285904 10084 275300 556 51.1045 13.2017 2021-07-05 04:21:28 Sachsen, Germany
1165088 1165088 2021-07-04 Germany Sachsen-Anhalt     99243 3428 95680 175 51.9503 11.6923 2021-07-05 04:21:28 Sachsen-Anhalt, Germany
1165089 1165089 2021-07-04 Germany Schleswig-Holstein     63921 1623 61960 380 54.2194 9.6961 2021-07-05 04:21:28 Schleswig-Holstein, Germany
1165090 1165090 2021-07-04 Germany Thuringen     128782 4338 124100 364 51.011 10.8453 2021-07-05 04:21:28 Thuringen, Germany
1165091 1165091 2021-07-04 Germany Unknown     7018 0 0 7018     2021-07-05 04:21:28 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]);