johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

4,425 rows where country_or_region = "Germany" sorted by day descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Germany · 4,425 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
89587 89587 2021-01-22 Germany Baden-Wurttemberg     282920 6585 246280 30055 48.6616 9.3501 2021-01-23 05:22:03 Baden-Wurttemberg, Germany
89588 89588 2021-01-22 Germany Bayern     387863 9583 335561 42719 48.7904 11.4979 2021-01-23 05:22:03 Bayern, Germany
89589 89589 2021-01-22 Germany Berlin     116132 2021 100596 13515 52.52 13.405 2021-01-23 05:22:03 Berlin, Germany
89590 89590 2021-01-22 Germany Brandenburg     64482 2054 49828 12600 52.4125 12.5316 2021-01-23 05:22:03 Brandenburg, Germany
89591 89591 2021-01-22 Germany Bremen     15326 250 13957 1119 53.0793 8.8017 2021-01-23 05:22:03 Bremen, Germany
89592 89592 2021-01-22 Germany Hamburg     44256 976 36334 6946 53.5511 9.9937 2021-01-23 05:22:03 Hamburg, Germany
89593 89593 2021-01-22 Germany Hessen     164944 4362 139468 21114 50.6521 9.1624 2021-01-23 05:22:03 Hessen, Germany
89594 89594 2021-01-22 Germany Mecklenburg-Vorpommern     18109 355 14179 3575 53.6127 12.4296 2021-01-23 05:22:03 Mecklenburg-Vorpommern, Germany
89595 89595 2021-01-22 Germany Niedersachsen     134927 2945 117758 14224 52.6367 9.8451 2021-01-23 05:22:03 Niedersachsen, Germany
89596 89596 2021-01-22 Germany Nordrhein-Westfalen     467471 9895 405101 52475 51.4332 7.6616 2021-01-23 05:22:03 Nordrhein-Westfalen, Germany
89597 89597 2021-01-22 Germany Rheinland-Pfalz     88612 2263 72260 14089 50.1183 7.309 2021-01-23 05:22:03 Rheinland-Pfalz, Germany
89598 89598 2021-01-22 Germany Saarland     24300 691 21764 1845 49.3964 7.023 2021-01-23 05:22:03 Saarland, Germany
89599 89599 2021-01-22 Germany Sachsen     173272 5670 147900 19702 51.1045 13.2017 2021-01-23 05:22:03 Sachsen, Germany
89600 89600 2021-01-22 Germany Sachsen-Anhalt     47659 1421 37136 9102 51.9503 11.6923 2021-01-23 05:22:03 Sachsen-Anhalt, Germany
89601 89601 2021-01-22 Germany Schleswig-Holstein     33245 741 26505 5999 54.2194 9.6961 2021-01-23 05:22:03 Schleswig-Holstein, Germany
89602 89602 2021-01-22 Germany Thuringen     61290 1901 49267 10122 51.011 10.8453 2021-01-23 05:22:03 Thuringen, Germany
89603 89603 2021-01-22 Germany Unknown     453 0 0 453     2021-01-23 05:22:03 Unknown, Germany
302493 302493 2021-01-21 Germany Baden-Wurttemberg     281393 6514 244388 30491 48.6616 9.3501 2021-01-22 05:22:10 Baden-Wurttemberg, Germany
302494 302494 2021-01-21 Germany Bayern     385784 9420 332844 43520 48.7904 11.4979 2021-01-22 05:22:10 Bayern, Germany
302495 302495 2021-01-21 Germany Berlin     115517 1996 99675 13846 52.52 13.405 2021-01-22 05:22:10 Berlin, Germany
302496 302496 2021-01-21 Germany Brandenburg     63809 2017 49141 12651 52.4125 12.5316 2021-01-22 05:22:10 Brandenburg, Germany
302497 302497 2021-01-21 Germany Bremen     15248 248 13892 1108 53.0793 8.8017 2021-01-22 05:22:10 Bremen, Germany
302498 302498 2021-01-21 Germany Hamburg     43926 962 36114 6850 53.5511 9.9937 2021-01-22 05:22:10 Hamburg, Germany
302499 302499 2021-01-21 Germany Hessen     163853 4318 138465 21070 50.6521 9.1624 2021-01-22 05:22:10 Hessen, Germany
302500 302500 2021-01-21 Germany Mecklenburg-Vorpommern     17826 344 14021 3461 53.6127 12.4296 2021-01-22 05:22:10 Mecklenburg-Vorpommern, Germany
302501 302501 2021-01-21 Germany Niedersachsen     133417 2900 116658 13859 52.6367 9.8451 2021-01-22 05:22:10 Niedersachsen, Germany
302502 302502 2021-01-21 Germany Nordrhein-Westfalen     464139 9773 402457 51909 51.4332 7.6616 2021-01-22 05:22:10 Nordrhein-Westfalen, Germany
302503 302503 2021-01-21 Germany Rheinland-Pfalz     87855 2216 71801 13838 50.1183 7.309 2021-01-22 05:22:10 Rheinland-Pfalz, Germany
302504 302504 2021-01-21 Germany Saarland     24116 679 21596 1841 49.3964 7.023 2021-01-22 05:22:10 Saarland, Germany
302505 302505 2021-01-21 Germany Sachsen     171878 5517 145500 20861 51.1045 13.2017 2021-01-22 05:22:10 Sachsen, Germany
302506 302506 2021-01-21 Germany Sachsen-Anhalt     46627 1374 36236 9017 51.9503 11.6923 2021-01-22 05:22:10 Sachsen-Anhalt, Germany
302507 302507 2021-01-21 Germany Schleswig-Holstein     32820 725 26182 5913 54.2194 9.6961 2021-01-22 05:22:10 Schleswig-Holstein, Germany
302508 302508 2021-01-21 Germany Thuringen     60617 1873 48678 10066 51.011 10.8453 2021-01-22 05:22:10 Thuringen, Germany
302509 302509 2021-01-21 Germany Unknown     70 0 0 70     2021-01-22 05:22:10 Unknown, Germany
893545 893545 2021-01-20 Germany Baden-Wurttemberg     279479 6419 242272 30788 48.6616 9.3501 2021-01-21 05:22:01 Baden-Wurttemberg, Germany
893546 893546 2021-01-20 Germany Bayern     383107 9282 329651 44174 48.7904 11.4979 2021-01-21 05:22:01 Bayern, Germany
893547 893547 2021-01-20 Germany Berlin     114616 1957 99001 13658 52.52 13.405 2021-01-21 05:22:01 Berlin, Germany
893548 893548 2021-01-20 Germany Brandenburg     62754 1979 48152 12623 52.4125 12.5316 2021-01-21 05:22:01 Brandenburg, Germany
893549 893549 2021-01-20 Germany Bremen     15151 240 13817 1094 53.0793 8.8017 2021-01-21 05:22:01 Bremen, Germany
893550 893550 2021-01-20 Germany Hamburg     43620 950 35916 6754 53.5511 9.9937 2021-01-21 05:22:01 Hamburg, Germany
893551 893551 2021-01-20 Germany Hessen     162321 4257 137354 20710 50.6521 9.1624 2021-01-21 05:22:01 Hessen, Germany
893552 893552 2021-01-20 Germany Mecklenburg-Vorpommern     17553 340 13822 3391 53.6127 12.4296 2021-01-21 05:22:01 Mecklenburg-Vorpommern, Germany
893553 893553 2021-01-20 Germany Niedersachsen     132095 2829 115395 13871 52.6367 9.8451 2021-01-21 05:22:01 Niedersachsen, Germany
893554 893554 2021-01-20 Germany Nordrhein-Westfalen     460709 9635 398951 52123 51.4332 7.6616 2021-01-21 05:22:01 Nordrhein-Westfalen, Germany
893555 893555 2021-01-20 Germany Rheinland-Pfalz     87040 2187 71063 13790 50.1183 7.309 2021-01-21 05:22:01 Rheinland-Pfalz, Germany
893556 893556 2021-01-20 Germany Saarland     23894 671 21409 1814 49.3964 7.023 2021-01-21 05:22:01 Saarland, Germany
893557 893557 2021-01-20 Germany Sachsen     170784 5433 142800 22551 51.1045 13.2017 2021-01-21 05:22:01 Sachsen, Germany
893558 893558 2021-01-20 Germany Sachsen-Anhalt     45699 1316 35284 9099 51.9503 11.6923 2021-01-21 05:22:01 Sachsen-Anhalt, Germany
893559 893559 2021-01-20 Germany Schleswig-Holstein     32297 707 25872 5718 54.2194 9.6961 2021-01-21 05:22:01 Schleswig-Holstein, Germany
893560 893560 2021-01-20 Germany Thuringen     59744 1808 47560 10376 51.011 10.8453 2021-01-21 05:22:01 Thuringen, Germany
893561 893561 2021-01-20 Germany Unknown     9755 0 0 9755     2021-01-21 05:22:01 Unknown, Germany
322112 322112 2021-01-19 Germany Baden-Wurttemberg     277126 6324 239758 31044 48.6616 9.3501 2021-01-20 05:21:54 Baden-Wurttemberg, Germany
322113 322113 2021-01-19 Germany Bayern     380295 9106 326482 44707 48.7904 11.4979 2021-01-20 05:21:54 Bayern, Germany
322114 322114 2021-01-19 Germany Berlin     113884 1918 98093 13873 52.52 13.405 2021-01-20 05:21:54 Berlin, Germany
322115 322115 2021-01-19 Germany Brandenburg     61928 1910 47168 12850 52.4125 12.5316 2021-01-20 05:21:54 Brandenburg, Germany
322116 322116 2021-01-19 Germany Bremen     15027 239 13774 1014 53.0793 8.8017 2021-01-20 05:21:54 Bremen, Germany
322117 322117 2021-01-19 Germany Hamburg     43335 935 35623 6777 53.5511 9.9937 2021-01-20 05:21:54 Hamburg, Germany
322118 322118 2021-01-19 Germany Hessen     160738 4190 135810 20738 50.6521 9.1624 2021-01-20 05:21:54 Hessen, Germany
322119 322119 2021-01-19 Germany Mecklenburg-Vorpommern     17261 327 13625 3309 53.6127 12.4296 2021-01-20 05:21:54 Mecklenburg-Vorpommern, Germany
322120 322120 2021-01-19 Germany Niedersachsen     130467 2768 113959 13740 52.6367 9.8451 2021-01-20 05:21:54 Niedersachsen, Germany
322121 322121 2021-01-19 Germany Nordrhein-Westfalen     456855 9473 395294 52088 51.4332 7.6616 2021-01-20 05:21:54 Nordrhein-Westfalen, Germany
322122 322122 2021-01-19 Germany Rheinland-Pfalz     86124 2145 70277 13702 50.1183 7.309 2021-01-20 05:21:54 Rheinland-Pfalz, Germany
322123 322123 2021-01-19 Germany Saarland     23691 657 21323 1711 49.3964 7.023 2021-01-20 05:21:54 Saarland, Germany
322124 322124 2021-01-19 Germany Sachsen     168943 5307 139900 23736 51.1045 13.2017 2021-01-20 05:21:54 Sachsen, Germany
322125 322125 2021-01-19 Germany Sachsen-Anhalt     44733 1274 34497 8962 51.9503 11.6923 2021-01-20 05:21:54 Sachsen-Anhalt, Germany
322126 322126 2021-01-19 Germany Schleswig-Holstein     31842 691 25524 5627 54.2194 9.6961 2021-01-20 05:21:54 Schleswig-Holstein, Germany
322127 322127 2021-01-19 Germany Thuringen     58813 1733 46606 10474 51.011 10.8453 2021-01-20 05:21:54 Thuringen, Germany
322128 322128 2021-01-19 Germany Unknown     553 0 0 553     2021-01-20 05:21:54 Unknown, Germany
574098 574098 2021-01-18 Germany Baden-Wurttemberg     275414 6218 234191 35005 48.6616 9.3501 2021-01-19 05:22:15 Baden-Wurttemberg, Germany
574099 574099 2021-01-18 Germany Bayern     376497 8772 319013 48712 48.7904 11.4979 2021-01-19 05:22:15 Bayern, Germany
574100 574100 2021-01-18 Germany Berlin     113060 1860 95722 15478 52.52 13.405 2021-01-19 05:22:15 Berlin, Germany
574101 574101 2021-01-18 Germany Brandenburg     61284 1827 45004 14453 52.4125 12.5316 2021-01-19 05:22:15 Brandenburg, Germany
574102 574102 2021-01-18 Germany Bremen     14957 237 13607 1113 53.0793 8.8017 2021-01-19 05:22:15 Bremen, Germany
574103 574103 2021-01-18 Germany Hamburg     43084 906 34600 7578 53.5511 9.9937 2021-01-19 05:22:15 Hamburg, Germany
574104 574104 2021-01-18 Germany Hessen     158968 3964 132119 22885 50.6521 9.1624 2021-01-19 05:22:15 Hessen, Germany
574105 574105 2021-01-18 Germany Mecklenburg-Vorpommern     16900 310 13099 3491 53.6127 12.4296 2021-01-19 05:22:15 Mecklenburg-Vorpommern, Germany
574106 574106 2021-01-18 Germany Niedersachsen     129324 2644 110640 16040 52.6367 9.8451 2021-01-19 05:22:15 Niedersachsen, Germany
574107 574107 2021-01-18 Germany Nordrhein-Westfalen     451898 9123 385774 57001 51.4332 7.6616 2021-01-19 05:22:15 Nordrhein-Westfalen, Germany
574108 574108 2021-01-18 Germany Rheinland-Pfalz     85524 2104 68879 14541 50.1183 7.309 2021-01-19 05:22:15 Rheinland-Pfalz, Germany
574109 574109 2021-01-18 Germany Saarland     23490 652 21219 1619 49.3964 7.023 2021-01-19 05:22:15 Saarland, Germany
574110 574110 2021-01-18 Germany Sachsen     167734 5148 136600 25986 51.1045 13.2017 2021-01-19 05:22:15 Sachsen, Germany
574111 574111 2021-01-18 Germany Sachsen-Anhalt     43851 1207 33768 8876 51.9503 11.6923 2021-01-19 05:22:15 Sachsen-Anhalt, Germany
574112 574112 2021-01-18 Germany Schleswig-Holstein     31171 652 24588 5931 54.2194 9.6961 2021-01-19 05:22:15 Schleswig-Holstein, Germany
574113 574113 2021-01-18 Germany Thuringen     57594 1639 44373 11582 51.011 10.8453 2021-01-19 05:22:15 Thuringen, Germany
574114 574114 2021-01-18 Germany Unknown     8632 0 0 8632     2021-01-19 05:22:15 Unknown, Germany
538661 538661 2021-01-17 Germany Baden-Wurttemberg     274829 6111 234191 34527 48.6616 9.3501 2021-01-18 05:22:34 Baden-Wurttemberg, Germany
538662 538662 2021-01-17 Germany Bayern     375137 8697 319013 47427 48.7904 11.4979 2021-01-18 05:22:34 Bayern, Germany
538663 538663 2021-01-17 Germany Berlin     112516 1833 95600 15083 52.52 13.405 2021-01-18 05:22:34 Berlin, Germany
538664 538664 2021-01-17 Germany Brandenburg     60907 1808 45004 14095 52.4125 12.5316 2021-01-18 05:22:34 Brandenburg, Germany
538665 538665 2021-01-17 Germany Bremen     14943 232 13406 1305 53.0793 8.8017 2021-01-18 05:22:34 Bremen, Germany
538666 538666 2021-01-17 Germany Hamburg     42879 906 34585 7388 53.5511 9.9937 2021-01-18 05:22:34 Hamburg, Germany
538667 538667 2021-01-17 Germany Hessen     158968 3964 132119 22885 50.6521 9.1624 2021-01-18 05:22:34 Hessen, Germany
538668 538668 2021-01-17 Germany Mecklenburg-Vorpommern     16746 308 13099 3339 53.6127 12.4296 2021-01-18 05:22:34 Mecklenburg-Vorpommern, Germany
538669 538669 2021-01-17 Germany Niedersachsen     128826 2634 110640 15552 52.6367 9.8451 2021-01-18 05:22:34 Niedersachsen, Germany
538670 538670 2021-01-17 Germany Nordrhein-Westfalen     451898 9123 385774 57001 51.4332 7.6616 2021-01-18 05:22:34 Nordrhein-Westfalen, Germany
538671 538671 2021-01-17 Germany Rheinland-Pfalz     85053 2056 68099 14898 50.1183 7.309 2021-01-18 05:22:34 Rheinland-Pfalz, Germany
538672 538672 2021-01-17 Germany Saarland     23442 642 20948 1852 49.3964 7.023 2021-01-18 05:22:34 Saarland, Germany
538673 538673 2021-01-17 Germany Sachsen     167286 5104 134900 27282 51.1045 13.2017 2021-01-18 05:22:34 Sachsen, Germany
538674 538674 2021-01-17 Germany Sachsen-Anhalt     43421 1192 33201 9028 51.9503 11.6923 2021-01-18 05:22:34 Sachsen-Anhalt, Germany
538675 538675 2021-01-17 Germany Schleswig-Holstein     31171 652 24588 5931 54.2194 9.6961 2021-01-18 05:22:34 Schleswig-Holstein, Germany

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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] INTEGER,
   [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]);