⚠️ 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

5,105 rows where country_or_region = "Germany" sorted by day descending

View and edit SQL

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

country_or_region

  • Germany · 5,105
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
904333 2021-03-03 Germany Baden-Wurttemberg     319940 8187 299439 12314 48.6616 9.3501 2021-03-04 05:24:24 Baden-Wurttemberg, Germany
904334 2021-03-03 Germany Bayern     441590 12559 410970 18061 48.7904 11.4979 2021-03-04 05:24:24 Bayern, Germany
904335 2021-03-03 Germany Berlin     130533 2862 122739 4932 52.52 13.405 2021-03-04 05:24:24 Berlin, Germany
904336 2021-03-03 Germany Brandenburg     77335 3064 70588 3683 52.4125 12.5316 2021-03-04 05:24:24 Brandenburg, Germany
904337 2021-03-03 Germany Bremen     18258 352 17048 858 53.0793 8.8017 2021-03-04 05:24:24 Bremen, Germany
904338 2021-03-03 Germany Hamburg     52466 1296 47569 3601 53.5511 9.9937 2021-03-04 05:24:24 Hamburg, Germany
904339 2021-03-03 Germany Hessen     190675 5894 175528 9253 50.6521 9.1624 2021-03-04 05:24:24 Hessen, Germany
904340 2021-03-03 Germany Mecklenburg-Vorpommern     25107 757 22124 2226 53.6127 12.4296 2021-03-04 05:24:24 Mecklenburg-Vorpommern, Germany
904341 2021-03-03 Germany Niedersachsen     166951 4391 153364 9196 52.6367 9.8451 2021-03-04 05:24:24 Niedersachsen, Germany
904342 2021-03-03 Germany Nordrhein-Westfalen     538211 13264 499124 25823 51.4332 7.6616 2021-03-04 05:24:24 Nordrhein-Westfalen, Germany
904343 2021-03-03 Germany Rheinland-Pfalz     103138 3133 95598 4407 50.1183 7.309 2021-03-04 05:24:24 Rheinland-Pfalz, Germany
904344 2021-03-03 Germany Saarland     29240 893 27204 1143 49.3964 7.023 2021-03-04 05:24:24 Saarland, Germany
904345 2021-03-03 Germany Sachsen     196134 7909 181050 7175 51.1045 13.2017 2021-03-04 05:24:24 Sachsen, Germany
904346 2021-03-03 Germany Sachsen-Anhalt     61689 2491 55504 3694 51.9503 11.6923 2021-03-04 05:24:24 Sachsen-Anhalt, Germany
904347 2021-03-03 Germany Schleswig-Holstein     43117 1316 38893 2908 54.2194 9.6961 2021-03-04 05:24:24 Schleswig-Holstein, Germany
904348 2021-03-03 Germany Thuringen     77800 2917 69986 4897 51.011 10.8453 2021-03-04 05:24:24 Thuringen, Germany
904349 2021-03-03 Germany Unknown     729 0 0 729     2021-03-04 05:24:24 Unknown, Germany
66714 2021-03-02 Germany Baden-Wurttemberg     318557 8152 298502 11903 48.6616 9.3501 2021-03-03 05:23:28 Baden-Wurttemberg, Germany
66715 2021-03-02 Germany Bayern     439747 12496 409686 17565 48.7904 11.4979 2021-03-03 05:23:28 Bayern, Germany
66716 2021-03-02 Germany Berlin     130087 2850 122319 4918 52.52 13.405 2021-03-03 05:23:28 Berlin, Germany
66717 2021-03-02 Germany Brandenburg     77022 3049 70291 3682 52.4125 12.5316 2021-03-03 05:23:28 Brandenburg, Germany
66718 2021-03-02 Germany Bremen     18149 348 16962 839 53.0793 8.8017 2021-03-03 05:23:28 Bremen, Germany
66719 2021-03-02 Germany Hamburg     52232 1287 47342 3603 53.5511 9.9937 2021-03-03 05:23:28 Hamburg, Germany
66720 2021-03-02 Germany Hessen     189743 5877 174857 9009 50.6521 9.1624 2021-03-03 05:23:28 Hessen, Germany
66721 2021-03-02 Germany Mecklenburg-Vorpommern     24863 752 21968 2143 53.6127 12.4296 2021-03-03 05:23:28 Mecklenburg-Vorpommern, Germany
66722 2021-03-02 Germany Niedersachsen     165839 4363 152505 8971 52.6367 9.8451 2021-03-03 05:23:28 Niedersachsen, Germany
66723 2021-03-02 Germany Nordrhein-Westfalen     535738 13195 497096 25447 51.4332 7.6616 2021-03-03 05:23:28 Nordrhein-Westfalen, Germany
66724 2021-03-02 Germany Rheinland-Pfalz     102707 3124 95154 4429 50.1183 7.309 2021-03-03 05:23:28 Rheinland-Pfalz, Germany
66725 2021-03-02 Germany Saarland     29097 888 27052 1157 49.3964 7.023 2021-03-03 05:23:28 Saarland, Germany
66726 2021-03-02 Germany Sachsen     195275 7861 180450 6964 51.1045 13.2017 2021-03-03 05:23:28 Sachsen, Germany
66727 2021-03-02 Germany Sachsen-Anhalt     61278 2475 55184 3619 51.9503 11.6923 2021-03-03 05:23:28 Sachsen-Anhalt, Germany
66728 2021-03-02 Germany Schleswig-Holstein     42825 1308 38641 2876 54.2194 9.6961 2021-03-03 05:23:28 Schleswig-Holstein, Germany
66729 2021-03-02 Germany Thuringen     77110 2901 69617 4592 51.011 10.8453 2021-03-03 05:23:28 Thuringen, Germany
66730 2021-03-02 Germany Unknown     1792 0 0 1792     2021-03-03 05:23:28 Unknown, Germany
1291292 2021-03-01 Germany Baden-Wurttemberg     317473 8102 296774 12597 48.6616 9.3501 2021-03-02 05:23:30 Baden-Wurttemberg, Germany
1291293 2021-03-01 Germany Bayern     438074 12431 406841 18802 48.7904 11.4979 2021-03-02 05:23:30 Bayern, Germany
1291294 2021-03-01 Germany Berlin     129604 2825 121584 5195 52.52 13.405 2021-03-02 05:23:30 Berlin, Germany
1291295 2021-03-01 Germany Brandenburg     76721 3024 69633 4064 52.4125 12.5316 2021-03-02 05:23:30 Brandenburg, Germany
1291296 2021-03-01 Germany Bremen     18071 347 16747 977 53.0793 8.8017 2021-03-02 05:23:30 Bremen, Germany
1291297 2021-03-01 Germany Hamburg     52049 1278 47000 3771 53.5511 9.9937 2021-03-02 05:23:30 Hamburg, Germany
1291298 2021-03-01 Germany Hessen     188912 5843 173390 9679 50.6521 9.1624 2021-03-02 05:23:30 Hessen, Germany
1291299 2021-03-01 Germany Mecklenburg-Vorpommern     24613 745 21663 2205 53.6127 12.4296 2021-03-02 05:23:30 Mecklenburg-Vorpommern, Germany
1291300 2021-03-01 Germany Niedersachsen     165339 4326 150672 10341 52.6367 9.8451 2021-03-02 05:23:30 Niedersachsen, Germany
1291301 2021-03-01 Germany Nordrhein-Westfalen     533871 13141 493315 27415 51.4332 7.6616 2021-03-02 05:23:30 Nordrhein-Westfalen, Germany
1291302 2021-03-01 Germany Rheinland-Pfalz     102444 3111 94608 4725 50.1183 7.309 2021-03-02 05:23:30 Rheinland-Pfalz, Germany
1291303 2021-03-01 Germany Saarland     28980 886 26893 1201 49.3964 7.023 2021-03-02 05:23:30 Saarland, Germany
1291304 2021-03-01 Germany Sachsen     194790 7817 179900 7073 51.1045 13.2017 2021-03-02 05:23:30 Sachsen, Germany
1291305 2021-03-01 Germany Sachsen-Anhalt     61063 2454 54858 3751 51.9503 11.6923 2021-03-02 05:23:30 Sachsen-Anhalt, Germany
1291306 2021-03-01 Germany Schleswig-Holstein     42638 1304 38116 3218 54.2194 9.6961 2021-03-02 05:23:30 Schleswig-Holstein, Germany
1291307 2021-03-01 Germany Thuringen     76636 2880 68725 5031 51.011 10.8453 2021-03-02 05:23:30 Thuringen, Germany
1291308 2021-03-01 Germany Unknown     4291 0 0 4291     2021-03-02 05:23:30 Unknown, Germany
579707 2021-02-28 Germany Baden-Wurttemberg     317047 8074 296774 12199 48.6616 9.3501 2021-03-01 05:23:01 Baden-Wurttemberg, Germany
579708 2021-02-28 Germany Bayern     437611 12389 406841 18381 48.7904 11.4979 2021-03-01 05:23:01 Bayern, Germany
579709 2021-02-28 Germany Berlin     129360 2818 121566 4976 52.52 13.405 2021-03-01 05:23:01 Berlin, Germany
579710 2021-02-28 Germany Brandenburg     76566 2998 69633 3935 52.4125 12.5316 2021-03-01 05:23:01 Brandenburg, Germany
579711 2021-02-28 Germany Bremen     18047 343 16747 957 53.0793 8.8017 2021-03-01 05:23:01 Bremen, Germany
579712 2021-02-28 Germany Hamburg     51791 1272 46963 3556 53.5511 9.9937 2021-03-01 05:23:01 Hamburg, Germany
579713 2021-02-28 Germany Hessen     188623 5825 173390 9408 50.6521 9.1624 2021-03-01 05:23:01 Hessen, Germany
579714 2021-02-28 Germany Mecklenburg-Vorpommern     24554 739 21543 2272 53.6127 12.4296 2021-03-01 05:23:01 Mecklenburg-Vorpommern, Germany
579715 2021-02-28 Germany Niedersachsen     164866 4298 150672 9896 52.6367 9.8451 2021-03-01 05:23:01 Niedersachsen, Germany
579716 2021-02-28 Germany Nordrhein-Westfalen     533148 13059 493315 26774 51.4332 7.6616 2021-03-01 05:23:01 Nordrhein-Westfalen, Germany
579717 2021-02-28 Germany Rheinland-Pfalz     102271 3095 94376 4800 50.1183 7.309 2021-03-01 05:23:01 Rheinland-Pfalz, Germany
579718 2021-02-28 Germany Saarland     28960 884 26830 1246 49.3964 7.023 2021-03-01 05:23:01 Saarland, Germany
579719 2021-02-28 Germany Sachsen     194569 7760 179500 7309 51.1045 13.2017 2021-03-01 05:23:01 Sachsen, Germany
579720 2021-02-28 Germany Sachsen-Anhalt     60877 2450 54557 3870 51.9503 11.6923 2021-03-01 05:23:01 Sachsen-Anhalt, Germany
579721 2021-02-28 Germany Schleswig-Holstein     42541 1284 38116 3141 54.2194 9.6961 2021-03-01 05:23:01 Schleswig-Holstein, Germany
579722 2021-02-28 Germany Thuringen     76450 2864 68725 4861 51.011 10.8453 2021-03-01 05:23:01 Thuringen, Germany
579723 2021-02-28 Germany Unknown     3014 0 0 3014     2021-03-01 05:23:01 Unknown, Germany
680433 2021-02-27 Germany Baden-Wurttemberg     316592 8068 296017 12507 48.6616 9.3501 2021-02-28 05:22:20 Baden-Wurttemberg, Germany
680434 2021-02-27 Germany Bayern     436473 12382 405916 18175 48.7904 11.4979 2021-02-28 05:22:20 Bayern, Germany
680435 2021-02-27 Germany Berlin     129257 2818 121073 5366 52.52 13.405 2021-02-28 05:22:20 Berlin, Germany
680436 2021-02-27 Germany Brandenburg     76477 2996 69450 4031 52.4125 12.5316 2021-02-28 05:22:20 Brandenburg, Germany
680437 2021-02-27 Germany Bremen     17997 341 16747 909 53.0793 8.8017 2021-02-28 05:22:20 Bremen, Germany
680438 2021-02-27 Germany Hamburg     51665 1270 46743 3652 53.5511 9.9937 2021-02-28 05:22:20 Hamburg, Germany
680439 2021-02-27 Germany Hessen     188380 5824 172912 9644 50.6521 9.1624 2021-02-28 05:22:20 Hessen, Germany
680440 2021-02-27 Germany Mecklenburg-Vorpommern     24488 739 21414 2335 53.6127 12.4296 2021-02-28 05:22:20 Mecklenburg-Vorpommern, Germany
680441 2021-02-27 Germany Niedersachsen     164439 4296 149936 10207 52.6367 9.8451 2021-02-28 05:22:20 Niedersachsen, Germany
680442 2021-02-27 Germany Nordrhein-Westfalen     532344 13044 491934 27366 51.4332 7.6616 2021-02-28 05:22:20 Nordrhein-Westfalen, Germany
680443 2021-02-27 Germany Rheinland-Pfalz     102006 3092 94075 4839 50.1183 7.309 2021-02-28 05:22:20 Rheinland-Pfalz, Germany
680444 2021-02-27 Germany Saarland     28921 883 26747 1291 49.3964 7.023 2021-02-28 05:22:20 Saarland, Germany
680445 2021-02-27 Germany Sachsen     194177 7755 179350 7072 51.1045 13.2017 2021-02-28 05:22:20 Sachsen, Germany
680446 2021-02-27 Germany Sachsen-Anhalt     60630 2443 54381 3806 51.9503 11.6923 2021-02-28 05:22:20 Sachsen-Anhalt, Germany
680447 2021-02-27 Germany Schleswig-Holstein     42445 1282 37932 3231 54.2194 9.6961 2021-02-28 05:22:20 Schleswig-Holstein, Germany
680448 2021-02-27 Germany Thuringen     76291 2859 68343 5089 51.011 10.8453 2021-02-28 05:22:20 Thuringen, Germany
680449 2021-02-27 Germany Unknown     1595 0 0 1595     2021-02-28 05:22:20 Unknown, Germany
873461 2021-02-26 Germany Baden-Wurttemberg     315605 8060 295477 12068 48.6616 9.3501 2021-02-27 05:22:28 Baden-Wurttemberg, Germany
873462 2021-02-26 Germany Bayern     435229 12363 405108 17758 48.7904 11.4979 2021-02-27 05:22:28 Bayern, Germany
873463 2021-02-26 Germany Berlin     128946 2814 120864 5268 52.52 13.405 2021-02-27 05:22:28 Berlin, Germany
873464 2021-02-26 Germany Brandenburg     76224 2992 69302 3930 52.4125 12.5316 2021-02-27 05:22:28 Brandenburg, Germany
873465 2021-02-26 Germany Bremen     17894 340 16747 807 53.0793 8.8017 2021-02-27 05:22:28 Bremen, Germany
873466 2021-02-26 Germany Hamburg     51462 1263 46551 3648 53.5511 9.9937 2021-02-27 05:22:28 Hamburg, Germany
873467 2021-02-26 Germany Hessen     187791 5815 172536 9440 50.6521 9.1624 2021-02-27 05:22:28 Hessen, Germany
873468 2021-02-26 Germany Mecklenburg-Vorpommern     24313 736 21268 2309 53.6127 12.4296 2021-02-27 05:22:28 Mecklenburg-Vorpommern, Germany
873469 2021-02-26 Germany Niedersachsen     163595 4287 149424 9884 52.6367 9.8451 2021-02-27 05:22:28 Niedersachsen, Germany
873470 2021-02-26 Germany Nordrhein-Westfalen     530703 13028 490807 26868 51.4332 7.6616 2021-02-27 05:22:28 Nordrhein-Westfalen, Germany
873471 2021-02-26 Germany Rheinland-Pfalz     101835 3089 93815 4931 50.1183 7.309 2021-02-27 05:22:28 Rheinland-Pfalz, Germany
873472 2021-02-26 Germany Saarland     28797 883 26694 1220 49.3964 7.023 2021-02-27 05:22:28 Saarland, Germany
873473 2021-02-26 Germany Sachsen     193719 7707 178650 7362 51.1045 13.2017 2021-02-27 05:22:28 Sachsen, Germany
873474 2021-02-26 Germany Sachsen-Anhalt     60394 2435 54119 3840 51.9503 11.6923 2021-02-27 05:22:28 Sachsen-Anhalt, Germany
873475 2021-02-26 Germany Schleswig-Holstein     42235 1280 37741 3214 54.2194 9.6961 2021-02-27 05:22:28 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]);