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-03-12 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
352203 352203 2021-03-11 Germany Baden-Wurttemberg     327180 8346 305970 14429 48.6616 9.3501 2021-03-12 05:26:50 Baden-Wurttemberg, Germany
352204 352204 2021-03-11 Germany Bayern     452024 12743 420463 20873 48.7904 11.4979 2021-03-12 05:26:50 Bayern, Germany
352205 352205 2021-03-11 Germany Berlin     132828 2917 125710 4756 52.52 13.405 2021-03-12 05:26:50 Berlin, Germany
352206 352206 2021-03-11 Germany Brandenburg     79052 3124 72600 3715 52.4125 12.5316 2021-03-12 05:26:50 Brandenburg, Germany
352207 352207 2021-03-11 Germany Bremen     18688 375 17599 781 53.0793 8.8017 2021-03-12 05:26:50 Bremen, Germany
352208 352208 2021-03-11 Germany Hamburg     53949 1314 49134 3806 53.5511 9.9937 2021-03-12 05:26:50 Hamburg, Germany
352209 352209 2021-03-11 Germany Hessen     195365 5999 180123 10224 50.6521 9.1624 2021-03-12 05:26:50 Hessen, Germany
352210 352210 2021-03-11 Germany Mecklenburg-Vorpommern     26144 792 23427 2140 53.6127 12.4296 2021-03-12 05:26:50 Mecklenburg-Vorpommern, Germany
352211 352211 2021-03-11 Germany Niedersachsen     172568 4547 159634 9473 52.6367 9.8451 2021-03-12 05:26:50 Niedersachsen, Germany
352212 352212 2021-03-11 Germany Nordrhein-Westfalen     550996 13564 512135 28054 51.4332 7.6616 2021-03-12 05:26:50 Nordrhein-Westfalen, Germany
352213 352213 2021-03-11 Germany Rheinland-Pfalz     105249 3186 98033 4485 50.1183 7.309 2021-03-12 05:26:50 Rheinland-Pfalz, Germany
352214 352214 2021-03-11 Germany Saarland     29774 904 27948 990 49.3964 7.023 2021-03-12 05:26:50 Saarland, Germany
352215 352215 2021-03-11 Germany Sachsen     200207 8071 185150 7805 51.1045 13.2017 2021-03-12 05:26:50 Sachsen, Germany
352216 352216 2021-03-11 Germany Sachsen-Anhalt     63590 2540 57803 3837 51.9503 11.6923 2021-03-12 05:26:50 Sachsen-Anhalt, Germany
352217 352217 2021-03-11 Germany Schleswig-Holstein     44451 1359 40568 2787 54.2194 9.6961 2021-03-12 05:26:50 Schleswig-Holstein, Germany
352218 352218 2021-03-11 Germany Thuringen     80882 3029 73087 5415 51.011 10.8453 2021-03-12 05:26:50 Thuringen, Germany
352219 352219 2021-03-11 Germany Unknown     452 0 0 452     2021-03-12 05:26:50 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]);