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-11-15 sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (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
3596934 3596934 2022-11-14 Germany Baden-Wurttemberg     4854601 17937 0   48.6616 9.3501 2022-11-15 04:21:16 Baden-Wurttemberg, Germany
3596935 3596935 2022-11-14 Germany Bayern     6499552 26796 0   48.7904 11.4979 2022-11-15 04:21:16 Bayern, Germany
3596936 3596936 2022-11-14 Germany Berlin     1344987 5024 0   52.52 13.405 2022-11-15 04:21:16 Berlin, Germany
3596937 3596937 2022-11-14 Germany Brandenburg     1041481 6098 0   52.4125 12.5316 2022-11-15 04:21:16 Brandenburg, Germany
3596938 3596938 2022-11-14 Germany Bremen     281143 878 0   53.0793 8.8017 2022-11-15 04:21:16 Bremen, Germany
3596939 3596939 2022-11-14 Germany Hamburg     767510 3203 0   53.5511 9.9937 2022-11-15 04:21:16 Hamburg, Germany
3596940 3596940 2022-11-14 Germany Hessen     2761542 11517 0   50.6521 9.1624 2022-11-15 04:21:16 Hessen, Germany
3596941 3596941 2022-11-14 Germany Mecklenburg-Vorpommern     662793 2553 0   53.6127 12.4296 2022-11-15 04:21:16 Mecklenburg-Vorpommern, Germany
3596942 3596942 2022-11-14 Germany Niedersachsen     3522797 11483 0   52.6367 9.8451 2022-11-15 04:21:16 Niedersachsen, Germany
3596943 3596943 2022-11-14 Germany Nordrhein-Westfalen     7413267 28527 0   51.4332 7.6616 2022-11-15 04:21:16 Nordrhein-Westfalen, Germany
3596944 3596944 2022-11-14 Germany Rheinland-Pfalz     1666189 6455 0   50.1183 7.309 2022-11-15 04:21:16 Rheinland-Pfalz, Germany
3596945 3596945 2022-11-14 Germany Saarland     464378 1947 0   49.3964 7.023 2022-11-15 04:21:16 Saarland, Germany
3596946 3596946 2022-11-14 Germany Sachsen     1881637 16293 0   51.1045 13.2017 2022-11-15 04:21:16 Sachsen, Germany
3596947 3596947 2022-11-14 Germany Sachsen-Anhalt     913282 5935 0   51.9503 11.6923 2022-11-15 04:21:16 Sachsen-Anhalt, Germany
3596948 3596948 2022-11-14 Germany Schleswig-Holstein     1102614 3075 0   54.2194 9.6961 2022-11-15 04:21:16 Schleswig-Holstein, Germany
3596949 3596949 2022-11-14 Germany Thuringen     855622 7867 0   51.011 10.8453 2022-11-15 04:21:16 Thuringen, Germany
3596950 3596950 2022-11-14 Germany Unknown     0 0 0       2022-11-15 04:21:16 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]);