johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where country_or_region = "Germany" and "day" is on date 2020-12-21 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 17
- Baden-Wurttemberg 1
- Bayern 1
- Berlin 1
- Brandenburg 1
- Bremen 1
- Hamburg 1
- Hessen 1
- Mecklenburg-Vorpommern 1
- Niedersachsen 1
- Nordrhein-Westfalen 1
- Rheinland-Pfalz 1
- Saarland 1
- Sachsen 1
- Sachsen-Anhalt 1
- Schleswig-Holstein 1
- Thuringen 1
- Unknown 1
country_or_region 1
- Germany · 17 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
927600 | 927600 | 2020-12-21 | Germany | Baden-Wurttemberg | 212221 | 3969 | 156602 | 53763 | 48.6616 | 9.3501 | 2020-12-22 05:22:33 | Baden-Wurttemberg, Germany | ||
927601 | 927601 | 2020-12-21 | Germany | Bayern | 289760 | 5692 | 222633 | 64300 | 48.7904 | 11.4979 | 2020-12-22 05:22:33 | Bayern, Germany | ||
927602 | 927602 | 2020-12-21 | Germany | Berlin | 86884 | 1006 | 68163 | 18843 | 52.52 | 13.405 | 2020-12-22 05:22:33 | Berlin, Germany | ||
927603 | 927603 | 2020-12-21 | Germany | Brandenburg | 32379 | 658 | 24755 | 11017 | 52.4125 | 12.5316 | 2020-12-22 05:22:33 | Brandenburg, Germany | ||
927604 | 927604 | 2020-12-21 | Germany | Bremen | 12599 | 171 | 10602 | 1877 | 53.0793 | 8.8017 | 2020-12-22 05:22:33 | Bremen, Germany | ||
927605 | 927605 | 2020-12-21 | Germany | Hamburg | 32425 | 547 | 24541 | 7640 | 53.5511 | 9.9937 | 2020-12-22 05:22:33 | Hamburg, Germany | ||
927606 | 927606 | 2020-12-21 | Germany | Hessen | 121962 | 2147 | 91819 | 28619 | 50.6521 | 9.1624 | 2020-12-22 05:22:33 | Hessen, Germany | ||
927607 | 927607 | 2020-12-21 | Germany | Mecklenburg-Vorpommern | 9796 | 119 | 7092 | 2694 | 53.6127 | 12.4296 | 2020-12-22 05:22:33 | Mecklenburg-Vorpommern, Germany | ||
927608 | 927608 | 2020-12-21 | Germany | Niedersachsen | 94996 | 1648 | 79710 | 14838 | 52.6367 | 9.8451 | 2020-12-22 05:22:33 | Niedersachsen, Germany | ||
927609 | 927609 | 2020-12-21 | Germany | Nordrhein-Westfalen | 352719 | 5245 | 278868 | 73005 | 51.4332 | 7.6616 | 2020-12-22 05:22:33 | Nordrhein-Westfalen, Germany | ||
927610 | 927610 | 2020-12-21 | Germany | Rheinland-Pfalz | 63586 | 1062 | 44637 | 18913 | 50.1183 | 7.309 | 2020-12-22 05:22:33 | Rheinland-Pfalz, Germany | ||
927611 | 927611 | 2020-12-21 | Germany | Saarland | 17732 | 360 | 15321 | 2545 | 49.3964 | 7.023 | 2020-12-22 05:22:33 | Saarland, Germany | ||
927612 | 927612 | 2020-12-21 | Germany | Sachsen | 107014 | 2252 | 70000 | 36914 | 51.1045 | 13.2017 | 2020-12-22 05:22:33 | Sachsen, Germany | ||
927613 | 927613 | 2020-12-21 | Germany | Sachsen-Anhalt | 22978 | 392 | 15062 | 8178 | 51.9503 | 11.6923 | 2020-12-22 05:22:33 | Sachsen-Anhalt, Germany | ||
927614 | 927614 | 2020-12-21 | Germany | Schleswig-Holstein | 20849 | 324 | 15775 | 4952 | 54.2194 | 9.6961 | 2020-12-22 05:22:33 | Schleswig-Holstein, Germany | ||
927615 | 927615 | 2020-12-21 | Germany | Thuringen | 32752 | 683 | 22363 | 10528 | 51.011 | 10.8453 | 2020-12-22 05:22:33 | Thuringen, Germany | ||
927616 | 927616 | 2020-12-21 | Germany | Unknown | 539 | 0 | 0 | 539 | 2020-12-22 05:22:33 | Unknown, 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]);