johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 55 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1928208 | 1928208 | 2020-07-30 | Germany | Bremen | 1763 | 55 | 1647 | 74 | 53.0793 | 8.8017 | 2020-07-31 04:35:18 | Bremen, Germany | ||
2958376 | 2958376 | 2020-07-29 | Germany | Bremen | 1758 | 55 | 1645 | 66 | 53.0793 | 8.8017 | 2020-07-30 04:35:05 | Bremen, Germany | ||
3184992 | 3184992 | 2020-07-28 | Germany | Bremen | 1752 | 55 | 1638 | 68 | 53.0793 | 8.8017 | 2020-07-29 04:35:11 | Bremen, Germany | ||
177044 | 177044 | 2020-07-27 | Germany | Bremen | 1747 | 55 | 1638 | 62 | 53.0793 | 8.8017 | 2020-07-28 04:58:43 | Bremen, Germany | ||
442357 | 442357 | 2020-07-26 | Germany | Bremen | 1746 | 55 | 1635 | 56 | 53.0793 | 8.8017 | 2020-07-27 04:35:02 | Bremen, Germany | ||
1502601 | 1502601 | 2020-07-25 | Germany | Bremen | 1742 | 55 | 1635 | 55 | 53.0793 | 8.8017 | 2020-07-26 04:35:00 | Bremen, Germany | ||
2563571 | 2563571 | 2020-07-24 | Germany | Bremen | 1733 | 55 | 1635 | 55 | 53.0793 | 8.8017 | 2020-07-25 04:47:39 | Bremen, Germany | ||
61800 | 61800 | 2020-07-23 | Germany | Bremen | 1727 | 55 | 1635 | 46 | 53.0793 | 8.8017 | 2020-07-24 05:30:40 | Bremen, Germany | ||
844591 | 844591 | 2020-07-22 | Germany | Bremen | 1725 | 55 | 1634 | 41 | 53.0793 | 8.8017 | 2020-07-23 05:15:04 | Bremen, Germany | ||
1707330 | 1707330 | 2020-07-21 | Germany | Bremen | 1721 | 55 | 1629 | 42 | 53.0793 | 8.8017 | 2020-07-22 04:34:42 | Bremen, Germany | ||
326821 | 326821 | 2020-07-20 | Germany | Bremen | 1720 | 55 | 1626 | 39 | 53.0793 | 8.8017 | 2020-07-21 04:38:46 | Bremen, Germany | ||
121726 | 121726 | 2020-07-19 | Germany | Bremen | 1718 | 55 | 1623 | 41 | 53.0793 | 8.8017 | 2020-07-20 05:34:40 | Bremen, Germany | ||
3205115 | 3205115 | 2020-07-18 | Germany | Bremen | 1709 | 55 | 1623 | 40 | 53.0793 | 8.8017 | 2020-07-19 04:34:58 | Bremen, Germany | ||
2708417 | 2708417 | 2020-07-17 | Germany | Bremen | 1701 | 55 | 1623 | 32 | 53.0793 | 8.8017 | 2020-07-18 04:34:45 | Bremen, Germany | ||
367236 | 367236 | 2020-07-16 | Germany | Bremen | 1697 | 55 | 1619 | 30 | 53.0793 | 8.8017 | 2020-07-17 04:34:50 | Bremen, Germany | ||
2747904 | 2747904 | 2020-07-15 | Germany | Bremen | 1691 | 55 | 1616 | 29 | 53.0793 | 8.8017 | 2020-07-16 04:44:59 | Bremen, Germany | ||
2158548 | 2158548 | 2020-07-14 | Germany | Bremen | 1691 | 55 | 1611 | 28 | 53.0793 | 8.8017 | 2020-07-15 04:34:39 | Bremen, Germany | ||
3491189 | 3491189 | 2020-07-13 | Germany | Bremen | 1690 | 55 | 1608 | 31 | 53.0793 | 8.8017 | 2020-07-14 04:34:46 | Bremen, Germany | ||
3737451 | 3737451 | 2020-07-12 | Germany | Bremen | 1689 | 55 | 1605 | 33 | 53.0793 | 8.8017 | 2020-07-13 04:43:04 | Bremen, Germany | ||
3435846 | 3435846 | 2020-07-11 | Germany | Bremen | 1689 | 55 | 1604 | 33 | 53.0793 | 8.8017 | 2020-07-12 04:34:30 | 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]);