johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where active = 91 and country_or_region = "Germany" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude
province_or_state 6
- Mecklenburg-Vorpommern 3
- Saarland 3
- Sachsen-Anhalt 2
- Bremen 1
- Hamburg 1
- Thuringen 1
country_or_region 1
- Germany · 11 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2764844 | 2764844 | 2021-07-01 | Germany | Bremen | 27449 | 486 | 26880 | 91 | 53.0793 | 8.8017 | 2021-07-02 04:21:47 | Bremen, Germany | ||
966815 | 966815 | 2020-09-29 | Germany | Saarland | 3297 | 177 | 3103 | 91 | 49.3964 | 7.023 | 2020-09-30 04:23:33 | Saarland, Germany | ||
2653687 | 2653687 | 2020-09-23 | Germany | Saarland | 3252 | 176 | 3039 | 91 | 49.3964 | 7.023 | 2020-09-24 04:23:00 | Saarland, Germany | ||
2848758 | 2848758 | 2020-09-18 | Germany | Saarland | 3214 | 176 | 3000 | 91 | 49.3964 | 7.023 | 2020-09-19 04:22:00 | Saarland, Germany | ||
662213 | 662213 | 2020-08-11 | Germany | Mecklenburg-Vorpommern | 943 | 20 | 841 | 91 | 53.6127 | 12.4296 | 2020-08-12 04:27:29 | Mecklenburg-Vorpommern, Germany | ||
1920433 | 1920433 | 2020-08-10 | Germany | Mecklenburg-Vorpommern | 938 | 20 | 833 | 91 | 53.6127 | 12.4296 | 2020-08-11 04:35:08 | Mecklenburg-Vorpommern, Germany | ||
458594 | 458594 | 2020-08-07 | Germany | Mecklenburg-Vorpommern | 910 | 20 | 820 | 91 | 53.6127 | 12.4296 | 2020-08-08 04:34:53 | Mecklenburg-Vorpommern, Germany | ||
2974583 | 2974583 | 2020-06-30 | Germany | Sachsen-Anhalt | 1871 | 58 | 1725 | 91 | 51.9503 | 11.6923 | 2020-07-01 04:33:52 | Sachsen-Anhalt, Germany | ||
1522608 | 1522608 | 2020-06-23 | Germany | Thuringen | 3229 | 178 | 2960 | 91 | 51.011 | 10.8453 | 2020-06-24 04:33:28 | Thuringen, Germany | ||
287113 | 287113 | 2020-06-15 | Germany | Hamburg | 5144 | 255 | 4800 | 91 | 53.5511 | 9.9937 | 2020-06-16 04:33:09 | Hamburg, Germany | ||
1104988 | 1104988 | 2020-05-25 | Germany | Sachsen-Anhalt | 1694 | 54 | 1554 | 91 | 51.9503 | 11.6923 | 2020-05-26 02:32:35 | Sachsen-Anhalt, 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]);