johns_hopkins_csse_daily_reports

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

991 rows where country_or_region = "Germany" sorted by day descending

View and edit SQL

country_or_region

  • Germany · 991
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
311669 2020-07-04 Germany Baden-Wurttemberg     35817 1839 33570 408 48.6616 9.3501 2020-07-05 04:33:46 Baden-Wurttemberg, Germany
311677 2020-07-04 Germany Bayern     48655 2600 45290 765 48.7904 11.4979 2020-07-05 04:33:46 Bayern, Germany
311680 2020-07-04 Germany Berlin     8433 215 7646 572 52.52 13.405 2020-07-05 04:33:46 Berlin, Germany
311688 2020-07-04 Germany Brandenburg     3488 172 3210 106 52.4125 12.5316 2020-07-05 04:33:46 Brandenburg, Germany
311689 2020-07-04 Germany Bremen     1681 53 1564 64 53.0793 8.8017 2020-07-05 04:33:46 Bremen, Germany
311787 2020-07-04 Germany Hamburg     5219 260 4900 59 53.5511 9.9937 2020-07-05 04:33:46 Hamburg, Germany
311792 2020-07-04 Germany Hessen     10918 511 10009 398 50.6521 9.1624 2020-07-05 04:33:46 Hessen, Germany
311894 2020-07-04 Germany Mecklenburg-Vorpommern     804 20 772 12 53.6127 12.4296 2020-07-05 04:33:46 Mecklenburg-Vorpommern, Germany
311928 2020-07-04 Germany Niedersachsen     13647 637 12334 676 52.6367 9.8451 2020-07-05 04:33:46 Niedersachsen, Germany
311932 2020-07-04 Germany Nordrhein-Westfalen     43853 1688 39222 2943 51.4332 7.6616 2020-07-05 04:33:46 Nordrhein-Westfalen, Germany
311994 2020-07-04 Germany Rheinland-Pfalz     7080 235 6635 210 50.1183 7.309 2020-07-05 04:33:46 Rheinland-Pfalz, Germany
312004 2020-07-04 Germany Saarland     2807 174 2585 48 49.3964 7.023 2020-07-05 04:33:46 Saarland, Germany
312005 2020-07-04 Germany Sachsen     5458 224 5180 54 51.1045 13.2017 2020-07-05 04:33:46 Sachsen, Germany
312006 2020-07-04 Germany Sachsen-Anhalt     1882 59 1758 65 51.9503 11.6923 2020-07-05 04:33:46 Sachsen-Anhalt, Germany
312024 2020-07-04 Germany Schleswig-Holstein     3181 152 3000 29 54.2194 9.6961 2020-07-05 04:33:46 Schleswig-Holstein, Germany
312062 2020-07-04 Germany Thuringen     3267 181 3060 26 51.011 10.8453 2020-07-05 04:33:46 Thuringen, Germany
312087 2020-07-04 Germany Unknown     1008 0 265 743     2020-07-05 04:33:46 Unknown, Germany
252103 2020-07-03 Germany Baden-Wurttemberg     35817 1837 33570 410 48.6616 9.3501 2020-07-04 04:33:51 Baden-Wurttemberg, Germany
252111 2020-07-03 Germany Bayern     48587 2598 45250 739 48.7904 11.4979 2020-07-04 04:33:51 Bayern, Germany
252114 2020-07-03 Germany Berlin     8392 214 7612 566 52.52 13.405 2020-07-04 04:33:51 Berlin, Germany
252122 2020-07-03 Germany Brandenburg     3479 172 3200 107 52.4125 12.5316 2020-07-04 04:33:51 Brandenburg, Germany
252123 2020-07-03 Germany Bremen     1678 53 1564 61 53.0793 8.8017 2020-07-04 04:33:51 Bremen, Germany
252221 2020-07-03 Germany Hamburg     5216 260 4900 56 53.5511 9.9937 2020-07-04 04:33:51 Hamburg, Germany
252226 2020-07-03 Germany Hessen     10894 509 9993 392 50.6521 9.1624 2020-07-04 04:33:51 Hessen, Germany
252328 2020-07-03 Germany Mecklenburg-Vorpommern     804 20 769 15 53.6127 12.4296 2020-07-04 04:33:51 Mecklenburg-Vorpommern, Germany
252362 2020-07-03 Germany Niedersachsen     13632 636 12268 728 52.6367 9.8451 2020-07-04 04:33:51 Niedersachsen, Germany
252366 2020-07-03 Germany Nordrhein-Westfalen     43660 1686 37974 4000 51.4332 7.6616 2020-07-04 04:33:51 Nordrhein-Westfalen, Germany
252428 2020-07-03 Germany Rheinland-Pfalz     7068 235 6623 210 50.1183 7.309 2020-07-04 04:33:51 Rheinland-Pfalz, Germany
252438 2020-07-03 Germany Saarland     2807 174 2584 49 49.3964 7.023 2020-07-04 04:33:51 Saarland, Germany
252439 2020-07-03 Germany Sachsen     5457 224 5180 53 51.1045 13.2017 2020-07-04 04:33:51 Sachsen, Germany
252440 2020-07-03 Germany Sachsen-Anhalt     1882 59 1758 65 51.9503 11.6923 2020-07-04 04:33:51 Sachsen-Anhalt, Germany
252458 2020-07-03 Germany Schleswig-Holstein     3178 152 3000 26 54.2194 9.6961 2020-07-04 04:33:51 Schleswig-Holstein, Germany
252496 2020-07-03 Germany Thuringen     3266 181 3060 25 51.011 10.8453 2020-07-04 04:33:51 Thuringen, Germany
252521 2020-07-03 Germany Unknown     963 0 995 -32     2020-07-04 04:33:51 Unknown, Germany
203484 2020-07-02 Germany Baden-Wurttemberg     35780 1839 33518 423 48.6616 9.3501 2020-07-03 04:33:54 Baden-Wurttemberg, Germany
203492 2020-07-02 Germany Bayern     48547 2597 45210 740 48.7904 11.4979 2020-07-03 04:33:54 Bayern, Germany
203495 2020-07-02 Germany Berlin     8344 214 7515 615 52.52 13.405 2020-07-03 04:33:54 Berlin, Germany
203503 2020-07-02 Germany Brandenburg     3470 172 3200 98 52.4125 12.5316 2020-07-03 04:33:54 Brandenburg, Germany
203504 2020-07-02 Germany Bremen     1678 53 1560 65 53.0793 8.8017 2020-07-03 04:33:54 Bremen, Germany
203602 2020-07-02 Germany Hamburg     5211 260 4900 51 53.5511 9.9937 2020-07-03 04:33:54 Hamburg, Germany
203607 2020-07-02 Germany Hessen     10869 508 9952 409 50.6521 9.1624 2020-07-03 04:33:54 Hessen, Germany
203709 2020-07-02 Germany Mecklenburg-Vorpommern     803 20 769 14 53.6127 12.4296 2020-07-03 04:33:54 Mecklenburg-Vorpommern, Germany
203743 2020-07-02 Germany Niedersachsen     13605 634 12265 706 52.6367 9.8451 2020-07-03 04:33:54 Niedersachsen, Germany
203747 2020-07-02 Germany Nordrhein-Westfalen     43436 1684 37853 3899 51.4332 7.6616 2020-07-03 04:33:54 Nordrhein-Westfalen, Germany
203809 2020-07-02 Germany Rheinland-Pfalz     7036 235 6603 198 50.1183 7.309 2020-07-03 04:33:54 Rheinland-Pfalz, Germany
203819 2020-07-02 Germany Saarland     2807 174 2584 49 49.3964 7.023 2020-07-03 04:33:54 Saarland, Germany
203820 2020-07-02 Germany Sachsen     5457 224 5165 68 51.1045 13.2017 2020-07-03 04:33:54 Sachsen, Germany
203821 2020-07-02 Germany Sachsen-Anhalt     1880 59 1749 72 51.9503 11.6923 2020-07-03 04:33:54 Sachsen-Anhalt, Germany
203839 2020-07-02 Germany Schleswig-Holstein     3176 152 3000 24 54.2194 9.6961 2020-07-03 04:33:54 Schleswig-Holstein, Germany
203877 2020-07-02 Germany Thuringen     3260 181 3050 29 51.011 10.8453 2020-07-03 04:33:54 Thuringen, Germany
203903 2020-07-02 Germany Unknown     1011 0 907 104     2020-07-03 04:33:54 Unknown, Germany
159725 2020-07-01 Germany Baden-Wurttemberg     35755 1838 33300 617 48.6616 9.3501 2020-07-02 04:33:46 Baden-Wurttemberg, Germany
159733 2020-07-01 Germany Bayern     48480 2594 45100 786 48.7904 11.4979 2020-07-02 04:33:46 Bayern, Germany
159736 2020-07-01 Germany Berlin     8301 214 7433 654 52.52 13.405 2020-07-02 04:33:46 Berlin, Germany
159744 2020-07-01 Germany Brandenburg     3459 171 3200 88 52.4125 12.5316 2020-07-02 04:33:46 Brandenburg, Germany
159745 2020-07-01 Germany Bremen     1673 53 1556 64 53.0793 8.8017 2020-07-02 04:33:46 Bremen, Germany
159843 2020-07-01 Germany Hamburg     5204 259 4900 45 53.5511 9.9937 2020-07-02 04:33:46 Hamburg, Germany
159848 2020-07-01 Germany Hessen     10811 508 9909 394 50.6521 9.1624 2020-07-02 04:33:46 Hessen, Germany
159950 2020-07-01 Germany Mecklenburg-Vorpommern     803 20 767 16 53.6127 12.4296 2020-07-02 04:33:46 Mecklenburg-Vorpommern, Germany
159984 2020-07-01 Germany Niedersachsen     13577 632 12250 695 52.6367 9.8451 2020-07-02 04:33:46 Niedersachsen, Germany
159988 2020-07-01 Germany Nordrhein-Westfalen     43242 1683 37700 3859 51.4332 7.6616 2020-07-02 04:33:46 Nordrhein-Westfalen, Germany
160050 2020-07-01 Germany Rheinland-Pfalz     7027 235 6603 189 50.1183 7.309 2020-07-02 04:33:46 Rheinland-Pfalz, Germany
160060 2020-07-01 Germany Saarland     2806 173 2584 49 49.3964 7.023 2020-07-02 04:33:46 Saarland, Germany
160061 2020-07-01 Germany Sachsen     5451 223 5150 78 51.1045 13.2017 2020-07-02 04:33:46 Sachsen, Germany
160062 2020-07-01 Germany Sachsen-Anhalt     1878 59 1725 94 51.9503 11.6923 2020-07-02 04:33:46 Sachsen-Anhalt, Germany
160080 2020-07-01 Germany Schleswig-Holstein     3163 152 3000 11 54.2194 9.6961 2020-07-02 04:33:46 Schleswig-Holstein, Germany
160118 2020-07-01 Germany Thuringen     3258 181 3040 37 51.011 10.8453 2020-07-02 04:33:46 Thuringen, Germany
160144 2020-07-01 Germany Unknown     1005 0 883 122     2020-07-02 04:33:46 Unknown, Germany
325720 2020-06-30 Germany Baden-Wurttemberg     35705 1838 33300 567 48.6616 9.3501 2020-07-01 04:33:52 Baden-Wurttemberg, Germany
325728 2020-06-30 Germany Bayern     48400 2594 45100 706 48.7904 11.4979 2020-07-01 04:33:52 Bayern, Germany
325731 2020-06-30 Germany Berlin     8242 214 7349 679 52.52 13.405 2020-07-01 04:33:52 Berlin, Germany
325739 2020-06-30 Germany Brandenburg     3451 171 3200 80 52.4125 12.5316 2020-07-01 04:33:52 Brandenburg, Germany
325740 2020-06-30 Germany Bremen     1670 53 1539 78 53.0793 8.8017 2020-07-01 04:33:52 Bremen, Germany
325838 2020-06-30 Germany Hamburg     5203 259 4900 44 53.5511 9.9937 2020-07-01 04:33:52 Hamburg, Germany
325843 2020-06-30 Germany Hessen     10795 508 9900 387 50.6521 9.1624 2020-07-01 04:33:52 Hessen, Germany
325945 2020-06-30 Germany Mecklenburg-Vorpommern     803 20 767 16 53.6127 12.4296 2020-07-01 04:33:52 Mecklenburg-Vorpommern, Germany
325979 2020-06-30 Germany Niedersachsen     13535 630 12100 805 52.6367 9.8451 2020-07-01 04:33:52 Niedersachsen, Germany
325983 2020-06-30 Germany Nordrhein-Westfalen     43066 1680 37700 3686 51.4332 7.6616 2020-07-01 04:33:52 Nordrhein-Westfalen, Germany
326045 2020-06-30 Germany Rheinland-Pfalz     7001 235 6597 169 50.1183 7.309 2020-07-01 04:33:52 Rheinland-Pfalz, Germany
326055 2020-06-30 Germany Saarland     2806 173 2581 52 49.3964 7.023 2020-07-01 04:33:52 Saarland, Germany
326056 2020-06-30 Germany Sachsen     5448 223 5125 100 51.1045 13.2017 2020-07-01 04:33:52 Sachsen, Germany
326057 2020-06-30 Germany Sachsen-Anhalt     1875 59 1725 91 51.9503 11.6923 2020-07-01 04:33:52 Sachsen-Anhalt, Germany
326075 2020-06-30 Germany Schleswig-Holstein     3159 152 3000 7 54.2194 9.6961 2020-07-01 04:33:52 Schleswig-Holstein, Germany
326113 2020-06-30 Germany Thuringen     3254 181 3030 43 51.011 10.8453 2020-07-01 04:33:52 Thuringen, Germany
326139 2020-06-30 Germany Unknown     1005 0 187 818     2020-07-01 04:33:52 Unknown, Germany
49524 2020-06-29 Germany Baden-Wurttemberg     35630 1830 33300 500 48.6616 9.3501 2020-06-30 04:33:48 Baden-Wurttemberg, Germany
49532 2020-06-29 Germany Bayern     48344 2594 45100 650 48.7904 11.4979 2020-06-30 04:33:48 Bayern, Germany
49535 2020-06-29 Germany Berlin     8219 214 7272 733 52.52 13.405 2020-06-30 04:33:48 Berlin, Germany
49543 2020-06-29 Germany Brandenburg     3451 171 3200 80 52.4125 12.5316 2020-06-30 04:33:48 Brandenburg, Germany
49544 2020-06-29 Germany Bremen     1665 53 1533 79 53.0793 8.8017 2020-06-30 04:33:48 Bremen, Germany
49642 2020-06-29 Germany Hamburg     5200 259 4900 41 53.5511 9.9937 2020-06-30 04:33:48 Hamburg, Germany
49647 2020-06-29 Germany Hessen     10762 506 9900 356 50.6521 9.1624 2020-06-30 04:33:48 Hessen, Germany
49749 2020-06-29 Germany Mecklenburg-Vorpommern     802 20 765 17 53.6127 12.4296 2020-06-30 04:33:48 Mecklenburg-Vorpommern, Germany
49783 2020-06-29 Germany Niedersachsen     13502 630 12100 772 52.6367 9.8451 2020-06-30 04:33:48 Niedersachsen, Germany
49787 2020-06-29 Germany Nordrhein-Westfalen     42869 1678 37700 3491 51.4332 7.6616 2020-06-30 04:33:48 Nordrhein-Westfalen, Germany
49849 2020-06-29 Germany Rheinland-Pfalz     6987 235 6590 162 50.1183 7.309 2020-06-30 04:33:48 Rheinland-Pfalz, Germany
49859 2020-06-29 Germany Saarland     2806 173 2577 56 49.3964 7.023 2020-06-30 04:33:48 Saarland, Germany
49860 2020-06-29 Germany Sachsen     5444 222 5105 117 51.1045 13.2017 2020-06-30 04:33:48 Sachsen, Germany
49861 2020-06-29 Germany Sachsen-Anhalt     1873 58 1718 97 51.9503 11.6923 2020-06-30 04:33:48 Sachsen-Anhalt, Germany
49879 2020-06-29 Germany Schleswig-Holstein     3147 152 2990 5 54.2194 9.6961 2020-06-30 04:33:48 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
);
Powered by Datasette · Query took 2547.622ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette