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

16 rows where country_or_region = "Germany" and "last_update" is on date 2022-03-22 sorted by day descending

✎ View and edit SQL

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

country_or_region 1

  • Germany · 16 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
3238219 3238219 2022-03-21 Germany Baden-Wurttemberg     2717383 14790 0   48.6616 9.3501 2022-03-22 04:20:54 Baden-Wurttemberg, Germany
3238220 3238220 2022-03-21 Germany Bayern     3551401 22093 0   48.7904 11.4979 2022-03-22 04:20:54 Bayern, Germany
3238221 3238221 2022-03-21 Germany Berlin     840010 4319 0   52.52 13.405 2022-03-22 04:20:54 Berlin, Germany
3238222 3238222 2022-03-21 Germany Brandenburg     628833 5340 0   52.4125 12.5316 2022-03-22 04:20:54 Brandenburg, Germany
3238223 3238223 2022-03-21 Germany Bremen     135555 705 0   53.0793 8.8017 2022-03-22 04:20:54 Bremen, Germany
3238224 3238224 2022-03-21 Germany Hamburg     402892 2350 0   53.5511 9.9937 2022-03-22 04:20:54 Hamburg, Germany
3238225 3238225 2022-03-21 Germany Hessen     1279250 9483 0   50.6521 9.1624 2022-03-22 04:20:54 Hessen, Germany
3238226 3238226 2022-03-21 Germany Mecklenburg-Vorpommern     342257 1901 0   53.6127 12.4296 2022-03-22 04:20:54 Mecklenburg-Vorpommern, Germany
3238227 3238227 2022-03-21 Germany Niedersachsen     1420058 7798 0   52.6367 9.8451 2022-03-22 04:20:54 Niedersachsen, Germany
3238228 3238228 2022-03-21 Germany Nordrhein-Westfalen     3807191 23126 0   51.4332 7.6616 2022-03-22 04:20:54 Nordrhein-Westfalen, Germany
3238229 3238229 2022-03-21 Germany Rheinland-Pfalz     759477 5151 0   50.1183 7.309 2022-03-22 04:20:54 Rheinland-Pfalz, Germany
3238230 3238230 2022-03-21 Germany Saarland     213507 1477 0   49.3964 7.023 2022-03-22 04:20:54 Saarland, Germany
3238231 3238231 2022-03-21 Germany Sachsen     1174024 14540 0   51.1045 13.2017 2022-03-22 04:20:54 Sachsen, Germany
3238232 3238232 2022-03-21 Germany Sachsen-Anhalt     537448 4907 0   51.9503 11.6923 2022-03-22 04:20:54 Sachsen-Anhalt, Germany
3238233 3238233 2022-03-21 Germany Schleswig-Holstein     432426 2223 0   54.2194 9.6961 2022-03-22 04:20:54 Schleswig-Holstein, Germany
3238234 3238234 2022-03-21 Germany Thuringen     530619 6726 0   51.011 10.8453 2022-03-22 04:20:54 Thuringen, 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]);