daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where country_or_region = "Germany" and deaths = 54 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, longitude, combined_key, day (date), last_update (date)
province_or_state 3
country_or_region 1
- Germany · 18 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-11-24 | Germany | Mecklenburg-Vorpommern | 5247 | 54 | 3929 | 1404 | 53.6127 | 12.4296 | 2020-11-25 05:27:20 | Mecklenburg-Vorpommern, Germany | ||
2020-07-10 | Germany | Bremen | 1688 | 54 | 1604 | 33 | 53.0793 | 8.8017 | 2020-07-11 04:34:26 | Bremen, Germany | ||
2020-07-09 | Germany | Bremen | 1684 | 54 | 1600 | 37 | 53.0793 | 8.8017 | 2020-07-10 04:34:24 | Bremen, Germany | ||
2020-07-08 | Germany | Bremen | 1679 | 54 | 1599 | 34 | 53.0793 | 8.8017 | 2020-07-09 04:34:23 | Bremen, Germany | ||
2020-07-07 | Germany | Bremen | 1679 | 54 | 1596 | 34 | 53.0793 | 8.8017 | 2020-07-08 05:33:48 | Bremen, Germany | ||
2020-07-06 | Germany | Bremen | 1679 | 54 | 1589 | 39 | 53.0793 | 8.8017 | 2020-07-07 04:34:00 | Bremen, Germany | ||
2020-05-26 | Germany | Sachsen-Anhalt | 1698 | 54 | 1554 | 90 | 51.9503 | 11.6923 | 2020-05-27 02:32:31 | Sachsen-Anhalt, Germany | ||
2020-05-25 | Germany | Sachsen-Anhalt | 1694 | 54 | 1554 | 91 | 51.9503 | 11.6923 | 2020-05-26 02:32:35 | Sachsen-Anhalt, Germany | ||
2020-05-24 | Germany | Sachsen-Anhalt | 1694 | 54 | 1554 | 87 | 51.9503 | 11.6923 | 2020-05-25 02:32:44 | Sachsen-Anhalt, Germany | ||
2020-05-23 | Germany | Sachsen-Anhalt | 1692 | 54 | 1554 | 87 | 51.9503 | 11.6923 | 2020-05-24 02:32:43 | Sachsen-Anhalt, Germany | ||
2020-05-22 | Germany | Sachsen-Anhalt | 1692 | 54 | 1554 | 85 | 51.9503 | 11.6923 | 2020-05-23 02:32:42 | Sachsen-Anhalt, Germany | ||
2020-05-21 | Germany | Sachsen-Anhalt | 1689 | 54 | 1554 | 85 | 51.9503 | 11.6923 | 2020-05-22 02:36:51 | Sachsen-Anhalt, Germany | ||
2020-05-20 | Germany | Sachsen-Anhalt | 1680 | 54 | 1542 | 94 | 51.9503 | 11.6923 | 2020-05-21 02:32:48 | Sachsen-Anhalt, Germany | ||
2020-05-19 | Germany | Sachsen-Anhalt | 1679 | 54 | 1523 | 103 | 51.9503 | 11.6923 | 2020-05-20 02:32:19 | Sachsen-Anhalt, Germany | ||
2020-05-18 | Germany | Sachsen-Anhalt | 1678 | 54 | 1500 | 125 | 51.9503 | 11.6923 | 2020-05-19 02:32:18 | Sachsen-Anhalt, Germany | ||
2020-05-17 | Germany | Sachsen-Anhalt | 1676 | 54 | 1480 | 144 | 51.9503 | 11.6923 | 2020-05-18 02:32:21 | Sachsen-Anhalt, Germany | ||
2020-05-16 | Germany | Sachsen-Anhalt | 1676 | 54 | 1479 | 143 | 51.9503 | 11.6923 | 2020-05-17 02:32:32 | Sachsen-Anhalt, Germany | ||
2020-05-15 | Germany | Sachsen-Anhalt | 1668 | 54 | 1500 | 122 | 51.9503 | 11.6923 | 2020-05-16 02:32:19 | Sachsen-Anhalt, Germany |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;