daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16,427 rows where country_or_region = "Germany" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 18
- Baden-Wurttemberg 960
- Bayern 960
- Berlin 960
- Brandenburg 960
- Bremen 960
- Hamburg 960
- Hessen 960
- Mecklenburg-Vorpommern 960
- Niedersachsen 960
- Nordrhein-Westfalen 960
- Rheinland-Pfalz 960
- Saarland 960
- Sachsen 960
- Sachsen-Anhalt 960
- Schleswig-Holstein 960
- Thuringen 960
- Unknown 960
- Bavaria 4
country_or_region 1
- Germany · 16,427 ✖
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-05-28 | Germany | Thuringen | 127183 | 4189 | 119700 | 3459 | 51.011 | 10.8453 | 2021-05-29 04:20:41 | Thuringen, Germany | ||
2021-05-28 | Germany | Unknown | 4556 | 0 | 0 | 4556 | 2021-05-29 04:20:41 | Unknown, Germany | ||||
2022-03-20 | Germany | Baden-Wurttemberg | 2637048 | 14758 | 0 | 48.6616 | 9.3501 | 2022-03-21 04:20:50 | Baden-Wurttemberg, Germany | |||
2022-03-20 | Germany | Bayern | 3448099 | 22049 | 0 | 48.7904 | 11.4979 | 2022-03-21 04:20:50 | Bayern, Germany | |||
2022-03-20 | Germany | Berlin | 833613 | 4315 | 0 | 52.52 | 13.405 | 2022-03-21 04:20:50 | Berlin, Germany | |||
2022-03-20 | Germany | Brandenburg | 621167 | 5332 | 0 | 52.4125 | 12.5316 | 2022-03-21 04:20:50 | Brandenburg, Germany | |||
2022-03-20 | Germany | Bremen | 132329 | 699 | 0 | 53.0793 | 8.8017 | 2022-03-21 04:20:50 | Bremen, Germany | |||
2022-03-20 | Germany | Hamburg | 392771 | 2348 | 0 | 53.5511 | 9.9937 | 2022-03-21 04:20:50 | Hamburg, Germany | |||
2022-03-20 | Germany | Hessen | 1251813 | 9464 | 0 | 50.6521 | 9.1624 | 2022-03-21 04:20:50 | Hessen, Germany | |||
2022-03-20 | Germany | Mecklenburg-Vorpommern | 330469 | 1888 | 0 | 53.6127 | 12.4296 | 2022-03-21 04:20:50 | Mecklenburg-Vorpommern, Germany | |||
2022-03-20 | Germany | Niedersachsen | 1375949 | 7780 | 0 | 52.6367 | 9.8451 | 2022-03-21 04:20:50 | Niedersachsen, Germany | |||
2022-03-20 | Germany | Nordrhein-Westfalen | 3728711 | 23054 | 0 | 51.4332 | 7.6616 | 2022-03-21 04:20:50 | Nordrhein-Westfalen, Germany | |||
2022-03-20 | Germany | Rheinland-Pfalz | 739953 | 5145 | 0 | 50.1183 | 7.309 | 2022-03-21 04:20:50 | Rheinland-Pfalz, Germany | |||
2022-03-20 | Germany | Saarland | 206079 | 1467 | 0 | 49.3964 | 7.023 | 2022-03-21 04:20:50 | Saarland, Germany | |||
2022-03-20 | Germany | Sachsen | 1135775 | 14516 | 0 | 51.1045 | 13.2017 | 2022-03-21 04:20:50 | Sachsen, Germany | |||
2022-03-20 | Germany | Sachsen-Anhalt | 520699 | 4895 | 0 | 51.9503 | 11.6923 | 2022-03-21 04:20:50 | Sachsen-Anhalt, Germany | |||
2022-03-20 | Germany | Schleswig-Holstein | 418649 | 2213 | 0 | 54.2194 | 9.6961 | 2022-03-21 04:20:50 | Schleswig-Holstein, Germany | |||
2022-03-20 | Germany | Thuringen | 514862 | 6723 | 0 | 51.011 | 10.8453 | 2022-03-21 04:20:50 | Thuringen, Germany | |||
2022-03-20 | Germany | Unknown | 37652 | 0 | 0 | 2022-03-19 23:20:51 | Unknown, Germany | |||||
2021-11-11 | Germany | Baden-Wurttemberg | 681537 | 11179 | 0 | 48.6616 | 9.3501 | 2021-11-12 04:22:01 | Baden-Wurttemberg, Germany | |||
2021-11-11 | Germany | Bayern | 898267 | 16434 | 0 | 48.7904 | 11.4979 | 2021-11-12 04:22:01 | Bayern, Germany | |||
2021-11-11 | Germany | Berlin | 238005 | 3753 | 0 | 52.52 | 13.405 | 2021-11-12 04:22:01 | Berlin, Germany | |||
2021-11-11 | Germany | Brandenburg | 135047 | 3961 | 0 | 52.4125 | 12.5316 | 2021-11-12 04:22:01 | Brandenburg, Germany | |||
2021-11-11 | Germany | Bremen | 36318 | 534 | 0 | 53.0793 | 8.8017 | 2021-11-12 04:22:01 | Bremen, Germany | |||
2021-11-11 | Germany | Hamburg | 102820 | 1843 | 0 | 53.5511 | 9.9937 | 2021-11-12 04:22:01 | Hamburg, Germany | |||
2021-11-11 | Germany | Hessen | 370878 | 7945 | 0 | 50.6521 | 9.1624 | 2021-11-12 04:22:01 | Hessen, Germany | |||
2021-11-11 | Germany | Mecklenburg-Vorpommern | 57102 | 1271 | 0 | 53.6127 | 12.4296 | 2021-11-12 04:22:01 | Mecklenburg-Vorpommern, Germany | |||
2021-11-11 | Germany | Niedersachsen | 334188 | 6148 | 0 | 52.6367 | 9.8451 | 2021-11-12 04:22:01 | Niedersachsen, Germany | |||
2021-11-11 | Germany | Nordrhein-Westfalen | 1051982 | 18424 | 0 | 51.4332 | 7.6616 | 2021-11-12 04:22:01 | Nordrhein-Westfalen, Germany | |||
2021-11-11 | Germany | Rheinland-Pfalz | 202501 | 4145 | 0 | 50.1183 | 7.309 | 2021-11-12 04:22:01 | Rheinland-Pfalz, Germany | |||
2021-11-11 | Germany | Saarland | 51785 | 1078 | 0 | 49.3964 | 7.023 | 2021-11-12 04:22:01 | Saarland, Germany | |||
2021-11-11 | Germany | Sachsen | 360620 | 10473 | 0 | 51.1045 | 13.2017 | 2021-11-12 04:22:01 | Sachsen, Germany | |||
2021-11-11 | Germany | Sachsen-Anhalt | 119943 | 3624 | 0 | 51.9503 | 11.6923 | 2021-11-12 04:22:01 | Sachsen-Anhalt, Germany | |||
2021-11-11 | Germany | Schleswig-Holstein | 85772 | 1747 | 0 | 54.2194 | 9.6961 | 2021-11-12 04:22:01 | Schleswig-Holstein, Germany | |||
2021-11-11 | Germany | Thuringen | 167485 | 4639 | 0 | 51.011 | 10.8453 | 2021-11-12 04:22:01 | Thuringen, Germany | |||
2021-11-11 | Germany | Unknown | 14420 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, Germany | |||||
2021-08-25 | Germany | Baden-Wurttemberg | 518705 | 10456 | 0 | 48.6616 | 9.3501 | 2021-08-26 04:21:28 | Baden-Wurttemberg, Germany | |||
2021-08-25 | Germany | Bayern | 668081 | 15393 | 0 | 48.7904 | 11.4979 | 2021-08-26 04:21:28 | Bayern, Germany | |||
2021-08-25 | Germany | Berlin | 190253 | 3595 | 0 | 52.52 | 13.405 | 2021-08-26 04:21:28 | Berlin, Germany | |||
2021-08-25 | Germany | Brandenburg | 110973 | 3822 | 0 | 52.4125 | 12.5316 | 2021-08-26 04:21:28 | Brandenburg, Germany | |||
2021-08-25 | Germany | Bremen | 28820 | 498 | 0 | 53.0793 | 8.8017 | 2021-08-26 04:21:28 | Bremen, Germany | |||
2021-08-25 | Germany | Hamburg | 83784 | 1640 | 0 | 53.5511 | 9.9937 | 2021-08-26 04:21:28 | Hamburg, Germany | |||
2021-08-25 | Germany | Hessen | 303606 | 7622 | 0 | 50.6521 | 9.1624 | 2021-08-26 04:21:28 | Hessen, Germany | |||
2021-08-25 | Germany | Mecklenburg-Vorpommern | 45763 | 1187 | 0 | 53.6127 | 12.4296 | 2021-08-26 04:21:28 | Mecklenburg-Vorpommern, Germany | |||
2021-08-25 | Germany | Niedersachsen | 273392 | 5845 | 0 | 52.6367 | 9.8451 | 2021-08-26 04:21:28 | Niedersachsen, Germany | |||
2021-08-25 | Germany | Nordrhein-Westfalen | 870356 | 17383 | 0 | 51.4332 | 7.6616 | 2021-08-26 04:21:28 | Nordrhein-Westfalen, Germany | |||
2021-08-25 | Germany | Rheinland-Pfalz | 162644 | 3921 | 0 | 50.1183 | 7.309 | 2021-08-26 04:21:28 | Rheinland-Pfalz, Germany | |||
2021-08-25 | Germany | Saarland | 43705 | 1031 | 0 | 49.3964 | 7.023 | 2021-08-26 04:21:28 | Saarland, Germany | |||
2021-08-25 | Germany | Sachsen | 288605 | 10159 | 0 | 51.1045 | 13.2017 | 2021-08-26 04:21:28 | Sachsen, Germany | |||
2021-08-25 | Germany | Sachsen-Anhalt | 100415 | 3471 | 0 | 51.9503 | 11.6923 | 2021-08-26 04:21:28 | Sachsen-Anhalt, Germany | |||
2021-08-25 | Germany | Schleswig-Holstein | 70071 | 1644 | 0 | 54.2194 | 9.6961 | 2021-08-26 04:21:28 | Schleswig-Holstein, Germany | |||
2021-08-25 | Germany | Thuringen | 130000 | 4394 | 0 | 51.011 | 10.8453 | 2021-08-26 04:21:28 | Thuringen, Germany | |||
2021-08-25 | Germany | Unknown | 9184 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Germany | |||||
2021-04-12 | Germany | Baden-Wurttemberg | 388266 | 8927 | 349900 | 30602 | 48.6616 | 9.3501 | 2021-04-13 04:20:37 | Baden-Wurttemberg, Germany | ||
2021-04-12 | Germany | Bayern | 530864 | 13514 | 478900 | 40279 | 48.7904 | 11.4979 | 2021-04-13 04:20:37 | Bayern, Germany | ||
2021-04-12 | Germany | Berlin | 153452 | 3122 | 141700 | 9175 | 52.52 | 13.405 | 2021-04-13 04:20:37 | Berlin, Germany | ||
2021-04-12 | Germany | Brandenburg | 93345 | 3373 | 83110 | 7012 | 52.4125 | 12.5316 | 2021-04-13 04:20:37 | Brandenburg, Germany | ||
2021-04-12 | Germany | Bremen | 22386 | 420 | 20420 | 1637 | 53.0793 | 8.8017 | 2021-04-13 04:20:37 | Bremen, Germany | ||
2021-04-12 | Germany | Hamburg | 65606 | 1412 | 56800 | 7714 | 53.5511 | 9.9937 | 2021-04-13 04:20:37 | Hamburg, Germany | ||
2021-04-12 | Germany | Hessen | 233812 | 6488 | 207700 | 20298 | 50.6521 | 9.1624 | 2021-04-13 04:20:37 | Hessen, Germany | ||
2021-04-12 | Germany | Mecklenburg-Vorpommern | 33839 | 907 | 29910 | 3199 | 53.6127 | 12.4296 | 2021-04-13 04:20:37 | Mecklenburg-Vorpommern, Germany | ||
2021-04-12 | Germany | Niedersachsen | 211519 | 5019 | 192500 | 14641 | 52.6367 | 9.8451 | 2021-04-13 04:20:37 | Niedersachsen, Germany | ||
2021-04-12 | Germany | Nordrhein-Westfalen | 649941 | 14587 | 586000 | 52089 | 51.4332 | 7.6616 | 2021-04-13 04:20:37 | Nordrhein-Westfalen, Germany | ||
2021-04-12 | Germany | Rheinland-Pfalz | 124109 | 3398 | 111600 | 9740 | 50.1183 | 7.309 | 2021-04-13 04:20:37 | Rheinland-Pfalz, Germany | ||
2021-04-12 | Germany | Saarland | 33562 | 932 | 30920 | 1791 | 49.3964 | 7.023 | 2021-04-13 04:20:37 | Saarland, Germany | ||
2021-04-12 | Germany | Sachsen | 235712 | 8558 | 210700 | 17247 | 51.1045 | 13.2017 | 2021-04-13 04:20:37 | Sachsen, Germany | ||
2021-04-12 | Germany | Sachsen-Anhalt | 79262 | 2833 | 70300 | 6533 | 51.9503 | 11.6923 | 2021-04-13 04:20:37 | Sachsen-Anhalt, Germany | ||
2021-04-12 | Germany | Schleswig-Holstein | 53135 | 1461 | 47590 | 4276 | 54.2194 | 9.6961 | 2021-04-13 04:20:37 | Schleswig-Holstein, Germany | ||
2021-04-12 | Germany | Thuringen | 102703 | 3501 | 90270 | 9301 | 51.011 | 10.8453 | 2021-04-13 04:20:37 | Thuringen, Germany | ||
2021-04-12 | Germany | Unknown | 1954 | 0 | 0 | 1954 | 2021-04-13 04:20:37 | Unknown, Germany | ||||
2020-03-05 | Germany | 482 | 0 | 16 | 51.0 | 9.0 | 2020-03-05T17:43:03 | |||||
2020-04-13 | Germany | 130072 | 3194 | 64300 | 62578 | 51.165690999999995 | 10.451526 | 2020-04-13 23:07:34 | Germany | |||
2021-11-02 | Germany | Baden-Wurttemberg | 637267 | 11003 | 0 | 48.6616 | 9.3501 | 2021-11-03 06:22:09 | Baden-Wurttemberg, Germany | |||
2021-11-02 | Germany | Bayern | 825571 | 16086 | 0 | 48.7904 | 11.4979 | 2021-11-03 06:22:09 | Bayern, Germany | |||
2021-11-02 | Germany | Berlin | 225044 | 3709 | 0 | 52.52 | 13.405 | 2021-11-03 06:22:09 | Berlin, Germany | |||
2021-11-02 | Germany | Brandenburg | 125353 | 3926 | 0 | 52.4125 | 12.5316 | 2021-11-03 06:22:09 | Brandenburg, Germany | |||
2021-11-02 | Germany | Bremen | 35470 | 532 | 0 | 53.0793 | 8.8017 | 2021-11-03 06:22:09 | Bremen, Germany | |||
2021-11-02 | Germany | Hamburg | 99067 | 1822 | 0 | 53.5511 | 9.9937 | 2021-11-03 06:22:09 | Hamburg, Germany | |||
2021-11-02 | Germany | Hessen | 356564 | 7862 | 0 | 50.6521 | 9.1624 | 2021-11-03 06:22:09 | Hessen, Germany | |||
2021-11-02 | Germany | Mecklenburg-Vorpommern | 53588 | 1252 | 0 | 53.6127 | 12.4296 | 2021-11-03 06:22:09 | Mecklenburg-Vorpommern, Germany | |||
2021-11-02 | Germany | Niedersachsen | 321620 | 6089 | 0 | 52.6367 | 9.8451 | 2021-11-03 06:22:09 | Niedersachsen, Germany | |||
2021-11-02 | Germany | Nordrhein-Westfalen | 1016517 | 18222 | 0 | 51.4332 | 7.6616 | 2021-11-03 06:22:09 | Nordrhein-Westfalen, Germany | |||
2021-11-02 | Germany | Rheinland-Pfalz | 193819 | 4094 | 0 | 50.1183 | 7.309 | 2021-11-03 06:22:09 | Rheinland-Pfalz, Germany | |||
2021-11-02 | Germany | Saarland | 49990 | 1067 | 0 | 49.3964 | 7.023 | 2021-11-03 06:22:09 | Saarland, Germany | |||
2021-11-02 | Germany | Sachsen | 329369 | 10334 | 0 | 51.1045 | 13.2017 | 2021-11-03 06:22:09 | Sachsen, Germany | |||
2021-11-02 | Germany | Sachsen-Anhalt | 112902 | 3585 | 0 | 51.9503 | 11.6923 | 2021-11-03 06:22:09 | Sachsen-Anhalt, Germany | |||
2021-11-02 | Germany | Schleswig-Holstein | 82287 | 1728 | 0 | 54.2194 | 9.6961 | 2021-11-03 06:22:09 | Schleswig-Holstein, Germany | |||
2021-11-02 | Germany | Thuringen | 153593 | 4522 | 0 | 51.011 | 10.8453 | 2021-11-03 06:22:09 | Thuringen, Germany | |||
2021-11-02 | Germany | Unknown | 11485 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Germany | |||||
2020-04-17 | Germany | 141397 | 4352 | 83114 | 53931 | 51.165690999999995 | 10.451526 | 2020-04-17 23:30:32 | Germany | |||
2021-05-29 | Germany | Baden-Wurttemberg | 491213 | 9933 | 465300 | 16941 | 48.6616 | 9.3501 | 2021-05-30 04:20:55 | Baden-Wurttemberg, Germany | ||
2021-05-29 | Germany | Bayern | 638232 | 14935 | 607900 | 15978 | 48.7904 | 11.4979 | 2021-05-30 04:20:55 | Bayern, Germany | ||
2021-05-29 | Germany | Berlin | 178221 | 3482 | 171600 | 3235 | 52.52 | 13.405 | 2021-05-30 04:20:55 | Berlin, Germany | ||
2021-05-29 | Germany | Brandenburg | 108158 | 3726 | 102100 | 2374 | 52.4125 | 12.5316 | 2021-05-30 04:20:55 | Brandenburg, Germany | ||
2021-05-29 | Germany | Bremen | 27028 | 473 | 25900 | 699 | 53.0793 | 8.8017 | 2021-05-30 04:20:55 | Bremen, Germany | ||
2021-05-29 | Germany | Hamburg | 76097 | 1557 | 72000 | 2604 | 53.5511 | 9.9937 | 2021-05-30 04:20:55 | Hamburg, Germany | ||
2021-05-29 | Germany | Hessen | 286111 | 7319 | 268100 | 11038 | 50.6521 | 9.1624 | 2021-05-30 04:20:55 | Hessen, Germany | ||
2021-05-29 | Germany | Mecklenburg-Vorpommern | 43808 | 1120 | 41900 | 809 | 53.6127 | 12.4296 | 2021-05-30 04:20:55 | Mecklenburg-Vorpommern, Germany | ||
2021-05-29 | Germany | Niedersachsen | 257661 | 5608 | 247200 | 5147 | 52.6367 | 9.8451 | 2021-05-30 04:20:55 | Niedersachsen, Germany | ||
2021-05-29 | Germany | Nordrhein-Westfalen | 803694 | 16710 | 759500 | 28516 | 51.4332 | 7.6616 | 2021-05-30 04:20:55 | Nordrhein-Westfalen, Germany |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;