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

14,166 rows where country_or_region = "Germany" sorted by day descending

✎ View and edit SQL

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

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

country_or_region 1

  • Germany · 14,166 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
647469 647469 2022-08-18 Germany Baden-Wurttemberg     4352097 16841 0   48.6616 9.3501 2022-08-19 04:20:54 Baden-Wurttemberg, Germany
647470 647470 2022-08-18 Germany Bayern     5788107 25284 0   48.7904 11.4979 2022-08-19 04:20:54 Bayern, Germany
647471 647471 2022-08-18 Germany Berlin     1213981 4739 0   52.52 13.405 2022-08-19 04:20:54 Berlin, Germany
647472 647472 2022-08-18 Germany Brandenburg     907473 5839 0   52.4125 12.5316 2022-08-19 04:20:54 Brandenburg, Germany
647473 647473 2022-08-18 Germany Bremen     247136 822 0   53.0793 8.8017 2022-08-19 04:20:54 Bremen, Germany
647474 647474 2022-08-18 Germany Hamburg     704780 2918 0   53.5511 9.9937 2022-08-19 04:20:54 Hamburg, Germany
647475 647475 2022-08-18 Germany Hessen     2380975 10823 0   50.6521 9.1624 2022-08-19 04:20:54 Hessen, Germany
647476 647476 2022-08-18 Germany Mecklenburg-Vorpommern     573752 2382 0   53.6127 12.4296 2022-08-19 04:20:54 Mecklenburg-Vorpommern, Germany
647477 647477 2022-08-18 Germany Niedersachsen     3049813 10327 0   52.6367 9.8451 2022-08-19 04:20:54 Niedersachsen, Germany
647478 647478 2022-08-18 Germany Nordrhein-Westfalen     6482404 26824 0   51.4332 7.6616 2022-08-19 04:20:54 Nordrhein-Westfalen, Germany
647479 647479 2022-08-18 Germany Rheinland-Pfalz     1428973 6024 0   50.1183 7.309 2022-08-19 04:20:54 Rheinland-Pfalz, Germany
647480 647480 2022-08-18 Germany Saarland     393054 1804 0   49.3964 7.023 2022-08-19 04:20:54 Saarland, Germany
647481 647481 2022-08-18 Germany Sachsen     1694486 15826 0   51.1045 13.2017 2022-08-19 04:20:54 Sachsen, Germany
647482 647482 2022-08-18 Germany Sachsen-Anhalt     812095 5614 0   51.9503 11.6923 2022-08-19 04:20:54 Sachsen-Anhalt, Germany
647483 647483 2022-08-18 Germany Schleswig-Holstein     967386 2790 0   54.2194 9.6961 2022-08-19 04:20:54 Schleswig-Holstein, Germany
647484 647484 2022-08-18 Germany Thuringen     775372 7526 0   51.011 10.8453 2022-08-19 04:20:54 Thuringen, Germany
647485 647485 2022-08-18 Germany Unknown     0 0 0       2022-08-19 04:20:54 Unknown, Germany
2706241 2706241 2022-08-17 Germany Baden-Wurttemberg     4347811 16830 0   48.6616 9.3501 2022-08-18 04:21:11 Baden-Wurttemberg, Germany
2706242 2706242 2022-08-17 Germany Bayern     5781796 25258 0   48.7904 11.4979 2022-08-18 04:21:11 Bayern, Germany
2706243 2706243 2022-08-17 Germany Berlin     1212876 4735 0   52.52 13.405 2022-08-18 04:21:11 Berlin, Germany
2706244 2706244 2022-08-17 Germany Brandenburg     906057 5830 0   52.4125 12.5316 2022-08-18 04:21:11 Brandenburg, Germany
2706245 2706245 2022-08-17 Germany Bremen     246826 821 0   53.0793 8.8017 2022-08-18 04:21:11 Bremen, Germany
2706246 2706246 2022-08-17 Germany Hamburg     703839 2910 0   53.5511 9.9937 2022-08-18 04:21:11 Hamburg, Germany
2706247 2706247 2022-08-17 Germany Hessen     2376947 10805 0   50.6521 9.1624 2022-08-18 04:21:11 Hessen, Germany
2706248 2706248 2022-08-17 Germany Mecklenburg-Vorpommern     572820 2376 0   53.6127 12.4296 2022-08-18 04:21:11 Mecklenburg-Vorpommern, Germany
2706249 2706249 2022-08-17 Germany Niedersachsen     3044490 10312 0   52.6367 9.8451 2022-08-18 04:21:11 Niedersachsen, Germany
2706250 2706250 2022-08-17 Germany Nordrhein-Westfalen     6468854 26784 0   51.4332 7.6616 2022-08-18 04:21:11 Nordrhein-Westfalen, Germany
2706251 2706251 2022-08-17 Germany Rheinland-Pfalz     1426509 6023 0   50.1183 7.309 2022-08-18 04:21:11 Rheinland-Pfalz, Germany
2706252 2706252 2022-08-17 Germany Saarland     392334 1797 0   49.3964 7.023 2022-08-18 04:21:11 Saarland, Germany
2706253 2706253 2022-08-17 Germany Sachsen     1692392 15819 0   51.1045 13.2017 2022-08-18 04:21:11 Sachsen, Germany
2706254 2706254 2022-08-17 Germany Sachsen-Anhalt     811132 5608 0   51.9503 11.6923 2022-08-18 04:21:11 Sachsen-Anhalt, Germany
2706255 2706255 2022-08-17 Germany Schleswig-Holstein     965880 2787 0   54.2194 9.6961 2022-08-18 04:21:11 Schleswig-Holstein, Germany
2706256 2706256 2022-08-17 Germany Thuringen     774597 7519 0   51.011 10.8453 2022-08-18 04:21:11 Thuringen, Germany
2706257 2706257 2022-08-17 Germany Unknown     0 0 0       2022-08-18 04:21:11 Unknown, Germany
2395908 2395908 2022-08-16 Germany Baden-Wurttemberg     4342611 16800 0   48.6616 9.3501 2022-08-17 04:20:59 Baden-Wurttemberg, Germany
2395909 2395909 2022-08-16 Germany Bayern     5773087 25221 0   48.7904 11.4979 2022-08-17 04:20:59 Bayern, Germany
2395910 2395910 2022-08-16 Germany Berlin     1211311 4731 0   52.52 13.405 2022-08-17 04:20:59 Berlin, Germany
2395911 2395911 2022-08-16 Germany Brandenburg     904093 5827 0   52.4125 12.5316 2022-08-17 04:20:59 Brandenburg, Germany
2395912 2395912 2022-08-16 Germany Bremen     246193 819 0   53.0793 8.8017 2022-08-17 04:20:59 Bremen, Germany
2395913 2395913 2022-08-16 Germany Hamburg     702627 2904 0   53.5511 9.9937 2022-08-17 04:20:59 Hamburg, Germany
2395914 2395914 2022-08-16 Germany Hessen     2371963 10792 0   50.6521 9.1624 2022-08-17 04:20:59 Hessen, Germany
2395915 2395915 2022-08-16 Germany Mecklenburg-Vorpommern     571655 2376 0   53.6127 12.4296 2022-08-17 04:20:59 Mecklenburg-Vorpommern, Germany
2395916 2395916 2022-08-16 Germany Niedersachsen     3037841 10289 0   52.6367 9.8451 2022-08-17 04:20:59 Niedersachsen, Germany
2395917 2395917 2022-08-16 Germany Nordrhein-Westfalen     6453382 26759 0   51.4332 7.6616 2022-08-17 04:20:59 Nordrhein-Westfalen, Germany
2395918 2395918 2022-08-16 Germany Rheinland-Pfalz     1423770 6016 0   50.1183 7.309 2022-08-17 04:20:59 Rheinland-Pfalz, Germany
2395919 2395919 2022-08-16 Germany Saarland     391520 1794 0   49.3964 7.023 2022-08-17 04:20:59 Saarland, Germany
2395920 2395920 2022-08-16 Germany Sachsen     1689440 15806 0   51.1045 13.2017 2022-08-17 04:20:59 Sachsen, Germany
2395921 2395921 2022-08-16 Germany Sachsen-Anhalt     809473 5596 0   51.9503 11.6923 2022-08-17 04:20:59 Sachsen-Anhalt, Germany
2395922 2395922 2022-08-16 Germany Schleswig-Holstein     963952 2783 0   54.2194 9.6961 2022-08-17 04:20:59 Schleswig-Holstein, Germany
2395923 2395923 2022-08-16 Germany Thuringen     773557 7517 0   51.011 10.8453 2022-08-17 04:20:59 Thuringen, Germany
2395924 2395924 2022-08-16 Germany Unknown     0 0 0       2022-08-17 04:20:59 Unknown, Germany
2356620 2356620 2022-08-15 Germany Baden-Wurttemberg     4336379 16764 0   48.6616 9.3501 2022-08-16 04:20:58 Baden-Wurttemberg, Germany
2356621 2356621 2022-08-15 Germany Bayern     5759976 25174 0   48.7904 11.4979 2022-08-16 04:20:58 Bayern, Germany
2356622 2356622 2022-08-15 Germany Berlin     1209499 4745 0   52.52 13.405 2022-08-16 04:20:58 Berlin, Germany
2356623 2356623 2022-08-15 Germany Brandenburg     902071 5823 0   52.4125 12.5316 2022-08-16 04:20:58 Brandenburg, Germany
2356624 2356624 2022-08-15 Germany Bremen     245737 819 0   53.0793 8.8017 2022-08-16 04:20:58 Bremen, Germany
2356625 2356625 2022-08-15 Germany Hamburg     701895 2899 0   53.5511 9.9937 2022-08-16 04:20:58 Hamburg, Germany
2356626 2356626 2022-08-15 Germany Hessen     2367037 10786 0   50.6521 9.1624 2022-08-16 04:20:58 Hessen, Germany
2356627 2356627 2022-08-15 Germany Mecklenburg-Vorpommern     569695 2368 0   53.6127 12.4296 2022-08-16 04:20:58 Mecklenburg-Vorpommern, Germany
2356628 2356628 2022-08-15 Germany Niedersachsen     3030370 10263 0   52.6367 9.8451 2022-08-16 04:20:58 Niedersachsen, Germany
2356629 2356629 2022-08-15 Germany Nordrhein-Westfalen     6437049 26731 0   51.4332 7.6616 2022-08-16 04:20:58 Nordrhein-Westfalen, Germany
2356630 2356630 2022-08-15 Germany Rheinland-Pfalz     1421166 6003 0   50.1183 7.309 2022-08-16 04:20:58 Rheinland-Pfalz, Germany
2356631 2356631 2022-08-15 Germany Saarland     390463 1793 0   49.3964 7.023 2022-08-16 04:20:58 Saarland, Germany
2356632 2356632 2022-08-15 Germany Sachsen     1686416 15802 0   51.1045 13.2017 2022-08-16 04:20:58 Sachsen, Germany
2356633 2356633 2022-08-15 Germany Sachsen-Anhalt     807688 5586 0   51.9503 11.6923 2022-08-16 04:20:58 Sachsen-Anhalt, Germany
2356634 2356634 2022-08-15 Germany Schleswig-Holstein     961017 2781 0   54.2194 9.6961 2022-08-16 04:20:58 Schleswig-Holstein, Germany
2356635 2356635 2022-08-15 Germany Thuringen     772627 7501 0   51.011 10.8453 2022-08-16 04:20:58 Thuringen, Germany
2356636 2356636 2022-08-15 Germany Unknown     0 0 0       2022-08-16 04:20:58 Unknown, Germany
1835088 1835088 2022-08-14 Germany Baden-Wurttemberg     4329219 16754 0   48.6616 9.3501 2022-08-15 04:20:59 Baden-Wurttemberg, Germany
1835089 1835089 2022-08-14 Germany Bayern     5759975 25174 0   48.7904 11.4979 2022-08-15 04:20:59 Bayern, Germany
1835090 1835090 2022-08-14 Germany Berlin     1206624 4739 0   52.52 13.405 2022-08-15 04:20:59 Berlin, Germany
1835091 1835091 2022-08-14 Germany Brandenburg     899800 5817 0   52.4125 12.5316 2022-08-15 04:20:59 Brandenburg, Germany
1835092 1835092 2022-08-14 Germany Bremen     245157 819 0   53.0793 8.8017 2022-08-15 04:20:59 Bremen, Germany
1835093 1835093 2022-08-14 Germany Hamburg     700609 2895 0   53.5511 9.9937 2022-08-15 04:20:59 Hamburg, Germany
1835094 1835094 2022-08-14 Germany Hessen     2360283 10772 0   50.6521 9.1624 2022-08-15 04:20:59 Hessen, Germany
1835095 1835095 2022-08-14 Germany Mecklenburg-Vorpommern     568328 2366 0   53.6127 12.4296 2022-08-15 04:20:59 Mecklenburg-Vorpommern, Germany
1835096 1835096 2022-08-14 Germany Niedersachsen     3022534 10234 0   52.6367 9.8451 2022-08-15 04:20:59 Niedersachsen, Germany
1835097 1835097 2022-08-14 Germany Nordrhein-Westfalen     6416112 26692 0   51.4332 7.6616 2022-08-15 04:20:59 Nordrhein-Westfalen, Germany
1835098 1835098 2022-08-14 Germany Rheinland-Pfalz     1417915 5999 0   50.1183 7.309 2022-08-15 04:20:59 Rheinland-Pfalz, Germany
1835099 1835099 2022-08-14 Germany Saarland     390463 1793 0   49.3964 7.023 2022-08-15 04:20:59 Saarland, Germany
1835100 1835100 2022-08-14 Germany Sachsen     1683387 15794 0   51.1045 13.2017 2022-08-15 04:20:59 Sachsen, Germany
1835101 1835101 2022-08-14 Germany Sachsen-Anhalt     806107 5582 0   51.9503 11.6923 2022-08-15 04:20:59 Sachsen-Anhalt, Germany
1835102 1835102 2022-08-14 Germany Schleswig-Holstein     957472 2774 0   54.2194 9.6961 2022-08-15 04:20:59 Schleswig-Holstein, Germany
1835103 1835103 2022-08-14 Germany Thuringen     771355 7494 0   51.011 10.8453 2022-08-15 04:20:59 Thuringen, Germany
1835104 1835104 2022-08-14 Germany Unknown     0 0 0       2022-08-15 04:20:59 Unknown, Germany
1608974 1608974 2022-08-13 Germany Baden-Wurttemberg     4329219 16754 0   48.6616 9.3501 2022-08-14 04:20:55 Baden-Wurttemberg, Germany
1608975 1608975 2022-08-13 Germany Bayern     5759975 25174 0   48.7904 11.4979 2022-08-14 04:20:55 Bayern, Germany
1608976 1608976 2022-08-13 Germany Berlin     1206624 4739 0   52.52 13.405 2022-08-14 04:20:55 Berlin, Germany
1608977 1608977 2022-08-13 Germany Brandenburg     899800 5817 0   52.4125 12.5316 2022-08-14 04:20:55 Brandenburg, Germany
1608978 1608978 2022-08-13 Germany Bremen     245157 819 0   53.0793 8.8017 2022-08-14 04:20:55 Bremen, Germany
1608979 1608979 2022-08-13 Germany Hamburg     700609 2895 0   53.5511 9.9937 2022-08-14 04:20:55 Hamburg, Germany
1608980 1608980 2022-08-13 Germany Hessen     2360283 10772 0   50.6521 9.1624 2022-08-14 04:20:55 Hessen, Germany
1608981 1608981 2022-08-13 Germany Mecklenburg-Vorpommern     568328 2366 0   53.6127 12.4296 2022-08-14 04:20:55 Mecklenburg-Vorpommern, Germany
1608982 1608982 2022-08-13 Germany Niedersachsen     3022534 10234 0   52.6367 9.8451 2022-08-14 04:20:55 Niedersachsen, Germany
1608983 1608983 2022-08-13 Germany Nordrhein-Westfalen     6416112 26692 0   51.4332 7.6616 2022-08-14 04:20:55 Nordrhein-Westfalen, Germany
1608984 1608984 2022-08-13 Germany Rheinland-Pfalz     1417915 5999 0   50.1183 7.309 2022-08-14 04:20:55 Rheinland-Pfalz, Germany
1608985 1608985 2022-08-13 Germany Saarland     390463 1793 0   49.3964 7.023 2022-08-14 04:20:55 Saarland, Germany
1608986 1608986 2022-08-13 Germany Sachsen     1683387 15794 0   51.1045 13.2017 2022-08-14 04:20:55 Sachsen, Germany
1608987 1608987 2022-08-13 Germany Sachsen-Anhalt     806107 5582 0   51.9503 11.6923 2022-08-14 04:20:55 Sachsen-Anhalt, Germany
1608988 1608988 2022-08-13 Germany Schleswig-Holstein     957475 2774 0   54.2194 9.6961 2022-08-14 04:20:55 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]);