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

✎ View and edit SQL

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

Suggested facets: 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
2764840 2764840 2021-07-01 Germany Baden-Wurttemberg     500702 10261 488300 2467 48.6616 9.3501 2021-07-02 04:21:47 Baden-Wurttemberg, Germany
2764841 2764841 2021-07-01 Germany Bayern     647616 15262 629900 2582 48.7904 11.4979 2021-07-02 04:21:47 Bayern, Germany
2764842 2764842 2021-07-01 Germany Berlin     180209 3560 176400 276 52.52 13.405 2021-07-02 04:21:47 Berlin, Germany
2764843 2764843 2021-07-01 Germany Brandenburg     108702 3806 104600 299 52.4125 12.5316 2021-07-02 04:21:47 Brandenburg, Germany
2764844 2764844 2021-07-01 Germany Bremen     27449 486 26880 91 53.0793 8.8017 2021-07-02 04:21:47 Bremen, Germany
2764845 2764845 2021-07-01 Germany Hamburg     77369 1596 75300 500 53.5511 9.9937 2021-07-02 04:21:47 Hamburg, Germany
2764846 2764846 2021-07-01 Germany Hessen     290935 7521 282100 1356 50.6521 9.1624 2021-07-02 04:21:47 Hessen, Germany
2764847 2764847 2021-07-01 Germany Mecklenburg-Vorpommern     44154 1156 42920 82 53.6127 12.4296 2021-07-02 04:21:47 Mecklenburg-Vorpommern, Germany
2764848 2764848 2021-07-01 Germany Niedersachsen     261055 5764 254600 738 52.6367 9.8451 2021-07-02 04:21:47 Niedersachsen, Germany
2764849 2764849 2021-07-01 Germany Nordrhein-Westfalen     816330 17151 796500 2835 51.4332 7.6616 2021-07-02 04:21:47 Nordrhein-Westfalen, Germany
2764850 2764850 2021-07-01 Germany Rheinland-Pfalz     155220 3890 150500 877 50.1183 7.309 2021-07-02 04:21:47 Rheinland-Pfalz, Germany
2764851 2764851 2021-07-01 Germany Saarland     41486 1020 40350 123 49.3964 7.023 2021-07-02 04:21:47 Saarland, Germany
2764852 2764852 2021-07-01 Germany Sachsen     285886 10081 275100 743 51.1045 13.2017 2021-07-02 04:21:47 Sachsen, Germany
2764853 2764853 2021-07-01 Germany Sachsen-Anhalt     99238 3428 95620 234 51.9503 11.6923 2021-07-02 04:21:47 Sachsen-Anhalt, Germany
2764854 2764854 2021-07-01 Germany Schleswig-Holstein     63906 1621 61940 358 54.2194 9.6961 2021-07-02 04:21:47 Schleswig-Holstein, Germany
2764855 2764855 2021-07-01 Germany Thuringen     128776 4335 124000 444 51.011 10.8453 2021-07-02 04:21:47 Thuringen, Germany
2764856 2764856 2021-07-01 Germany Unknown     6930 0 0 6930     2021-07-02 04:21:47 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]);