daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

17 rows where country_or_region = "Germany" and day = "2022-01-12" 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 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-01-12 Germany Baden-Wurttemberg     1078015 13309 0   48.6616 9.3501 2022-01-13 08:00:09 Baden-Wurttemberg, Germany
2022-01-12 Germany Bayern     1398666 20054 0   48.7904 11.4979 2022-01-13 08:00:09 Bayern, Germany
2022-01-12 Germany Berlin     373566 4045 0   52.52 13.405 2022-01-13 08:00:09 Berlin, Germany
2022-01-12 Germany Brandenburg     262159 4830 0   52.4125 12.5316 2022-01-13 08:00:09 Brandenburg, Germany
2022-01-12 Germany Bremen     59658 613 0   53.0793 8.8017 2022-01-13 08:00:09 Bremen, Germany
2022-01-12 Germany Hamburg     158954 2034 0   53.5511 9.9937 2022-01-13 08:00:09 Hamburg, Germany
2022-01-12 Germany Hessen     518694 8646 0   50.6521 9.1624 2022-01-13 08:00:09 Hessen, Germany
2022-01-12 Germany Mecklenburg-Vorpommern     110910 1544 0   53.6127 12.4296 2022-01-13 08:00:09 Mecklenburg-Vorpommern, Germany
2022-01-12 Germany Niedersachsen     481958 6948 0   52.6367 9.8451 2022-01-13 08:00:09 Niedersachsen, Germany
2022-01-12 Germany Nordrhein-Westfalen     1487207 20676 0   51.4332 7.6616 2022-01-13 08:00:09 Nordrhein-Westfalen, Germany
2022-01-12 Germany Rheinland-Pfalz     298646 4723 0   50.1183 7.309 2022-01-13 08:00:09 Rheinland-Pfalz, Germany
2022-01-12 Germany Saarland     79514 1279 0   49.3964 7.023 2022-01-13 08:00:09 Saarland, Germany
2022-01-12 Germany Sachsen     672365 13543 0   51.1045 13.2017 2022-01-13 08:00:09 Sachsen, Germany
2022-01-12 Germany Sachsen-Anhalt     234929 4427 0   51.9503 11.6923 2022-01-13 08:00:09 Sachsen-Anhalt, Germany
2022-01-12 Germany Schleswig-Holstein     145847 1906 0   54.2194 9.6961 2022-01-13 08:00:09 Schleswig-Holstein, Germany
2022-01-12 Germany Thuringen     300723 6158 0   51.011 10.8453 2022-01-13 08:00:09 Thuringen, Germany
2022-01-12 Germany Unknown     33573 0 0       2022-01-13 08:00:09 Unknown, Germany

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;