johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where deaths = 56 and province_or_state = "Bremen" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2059793 | 2059793 | 2020-09-01 | Germany | Bremen | 2002 | 56 | 1821 | 140 | 53.0793 | 8.8017 | 2020-09-02 04:28:25 | Bremen, Germany | ||
193978 | 193978 | 2020-08-31 | Germany | Bremen | 1993 | 56 | 1815 | 134 | 53.0793 | 8.8017 | 2020-09-01 04:28:31 | Bremen, Germany | ||
3931937 | 3931937 | 2020-08-30 | Germany | Bremen | 1992 | 56 | 1805 | 131 | 53.0793 | 8.8017 | 2020-08-31 04:28:27 | Bremen, Germany | ||
609599 | 609599 | 2020-08-29 | Germany | Bremen | 1980 | 56 | 1800 | 127 | 53.0793 | 8.8017 | 2020-08-30 04:28:22 | Bremen, Germany | ||
1523094 | 1523094 | 2020-08-28 | Germany | Bremen | 1958 | 56 | 1774 | 153 | 53.0793 | 8.8017 | 2020-08-29 04:28:19 | Bremen, Germany | ||
2510095 | 2510095 | 2020-08-27 | Germany | Bremen | 1944 | 56 | 1785 | 119 | 53.0793 | 8.8017 | 2020-08-28 04:28:11 | Bremen, Germany | ||
1996555 | 1996555 | 2020-08-26 | Germany | Bremen | 1924 | 56 | 1780 | 111 | 53.0793 | 8.8017 | 2020-08-27 04:28:15 | Bremen, Germany | ||
3562479 | 3562479 | 2020-08-25 | Germany | Bremen | 1913 | 56 | 1767 | 104 | 53.0793 | 8.8017 | 2020-08-26 04:28:11 | Bremen, Germany | ||
2991183 | 2991183 | 2020-08-24 | Germany | Bremen | 1905 | 56 | 1767 | 92 | 53.0793 | 8.8017 | 2020-08-25 04:28:02 | Bremen, Germany | ||
2215578 | 2215578 | 2020-08-23 | Germany | Bremen | 1900 | 56 | 1759 | 85 | 53.0793 | 8.8017 | 2020-08-24 04:27:56 | Bremen, Germany | ||
2299360 | 2299360 | 2020-08-22 | Germany | Bremen | 1893 | 56 | 1758 | 82 | 53.0793 | 8.8017 | 2020-08-23 04:27:48 | Bremen, Germany | ||
1479467 | 1479467 | 2020-08-21 | Germany | Bremen | 1885 | 56 | 1753 | 87 | 53.0793 | 8.8017 | 2020-08-22 04:27:49 | Bremen, Germany | ||
3484216 | 3484216 | 2020-08-20 | Germany | Bremen | 1877 | 56 | 1744 | 88 | 53.0793 | 8.8017 | 2020-08-21 04:27:41 | Bremen, Germany | ||
206165 | 206165 | 2020-08-19 | Germany | Bremen | 1865 | 56 | 1741 | 84 | 53.0793 | 8.8017 | 2020-08-20 04:27:43 | Bremen, Germany | ||
3177919 | 3177919 | 2020-08-18 | Germany | Bremen | 1851 | 56 | 1730 | 81 | 53.0793 | 8.8017 | 2020-08-19 04:27:00 | Bremen, Germany | ||
837523 | 837523 | 2020-08-17 | Germany | Bremen | 1845 | 56 | 1726 | 72 | 53.0793 | 8.8017 | 2020-08-18 04:27:56 | Bremen, Germany | ||
1555881 | 1555881 | 2020-08-16 | Germany | Bremen | 1841 | 56 | 1721 | 64 | 53.0793 | 8.8017 | 2020-08-17 04:27:20 | Bremen, Germany | ||
145883 | 145883 | 2020-08-15 | Germany | Bremen | 1835 | 56 | 1721 | 61 | 53.0793 | 8.8017 | 2020-08-16 04:27:42 | Bremen, Germany | ||
1612158 | 1612158 | 2020-08-14 | Germany | Bremen | 1828 | 56 | 1721 | 61 | 53.0793 | 8.8017 | 2020-08-15 04:27:31 | Bremen, Germany | ||
582742 | 582742 | 2020-08-13 | Germany | Bremen | 1822 | 56 | 1717 | 58 | 53.0793 | 8.8017 | 2020-08-14 04:51:19 | Bremen, Germany | ||
3531361 | 3531361 | 2020-08-12 | Germany | Bremen | 1819 | 56 | 1709 | 60 | 53.0793 | 8.8017 | 2020-08-13 04:29:15 | Bremen, Germany | ||
662210 | 662210 | 2020-08-11 | Germany | Bremen | 1809 | 56 | 1699 | 67 | 53.0793 | 8.8017 | 2020-08-12 04:27:29 | Bremen, Germany | ||
1920221 | 1920221 | 2020-08-10 | Germany | Bremen | 1804 | 56 | 1697 | 59 | 53.0793 | 8.8017 | 2020-08-11 04:35:08 | Bremen, Germany | ||
3923030 | 3923030 | 2020-08-09 | Germany | Bremen | 1803 | 56 | 1684 | 63 | 53.0793 | 8.8017 | 2020-08-10 04:34:55 | Bremen, Germany | ||
371198 | 371198 | 2020-08-08 | Germany | Bremen | 1800 | 56 | 1684 | 63 | 53.0793 | 8.8017 | 2020-08-09 04:34:54 | Bremen, Germany | ||
458382 | 458382 | 2020-08-07 | Germany | Bremen | 1798 | 56 | 1684 | 63 | 53.0793 | 8.8017 | 2020-08-08 04:34:53 | Bremen, Germany | ||
3612067 | 3612067 | 2020-08-06 | Germany | Bremen | 1792 | 56 | 1680 | 65 | 53.0793 | 8.8017 | 2020-08-07 04:35:11 | Bremen, Germany | ||
3792897 | 3792897 | 2020-08-05 | Germany | Bremen | 1790 | 56 | 1674 | 65 | 53.0793 | 8.8017 | 2020-08-06 04:35:02 | Bremen, Germany | ||
98133 | 98133 | 2020-08-04 | Germany | Bremen | 1787 | 56 | 1673 | 64 | 53.0793 | 8.8017 | 2020-08-05 04:34:43 | Bremen, Germany | ||
2740016 | 2740016 | 2020-08-03 | Germany | Bremen | 1782 | 56 | 1664 | 69 | 53.0793 | 8.8017 | 2020-08-04 04:41:59 | Bremen, Germany | ||
2807768 | 2807768 | 2020-08-02 | Germany | Bremen | 1782 | 56 | 1656 | 72 | 53.0793 | 8.8017 | 2020-08-03 04:34:35 | Bremen, Germany | ||
753336 | 753336 | 2020-08-01 | Germany | Bremen | 1781 | 56 | 1656 | 72 | 53.0793 | 8.8017 | 2020-08-02 04:34:47 | Bremen, Germany | ||
3264501 | 3264501 | 2020-07-31 | Germany | Bremen | 1774 | 56 | 1656 | 72 | 53.0793 | 8.8017 | 2020-08-01 04:36:27 | Bremen, Germany |
Advanced export
JSON shape: default, array, newline-delimited
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]);