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

16,427 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: day (date), last_update (date)

country_or_region 1

  • Germany · 16,427 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752795 2752795 2022-12-29 Germany Baden-Wurttemberg     4967999 18566 0   48.6616 9.3501 2022-12-30 04:21:04 Baden-Wurttemberg, Germany
2752796 2752796 2022-12-29 Germany Bayern     6609337 27538 0   48.7904 11.4979 2022-12-30 04:21:04 Bayern, Germany
2752797 2752797 2022-12-29 Germany Berlin     1402221 5255 0   52.52 13.405 2022-12-30 04:21:04 Berlin, Germany
2752798 2752798 2022-12-29 Germany Brandenburg     1092883 6303 0   52.4125 12.5316 2022-12-30 04:21:04 Brandenburg, Germany
2752799 2752799 2022-12-29 Germany Bremen     297327 919 0   53.0793 8.8017 2022-12-30 04:21:04 Bremen, Germany
2752800 2752800 2022-12-29 Germany Hamburg     795565 3367 0   53.5511 9.9937 2022-12-30 04:21:04 Hamburg, Germany
2752801 2752801 2022-12-29 Germany Hessen     2848952 11884 0   50.6521 9.1624 2022-12-30 04:21:04 Hessen, Germany
2752802 2752802 2022-12-29 Germany Mecklenburg-Vorpommern     698152 2656 0   53.6127 12.4296 2022-12-30 04:21:04 Mecklenburg-Vorpommern, Germany
2752803 2752803 2022-12-29 Germany Niedersachsen     3747625 12297 0   52.6367 9.8451 2022-12-30 04:21:04 Niedersachsen, Germany
2752804 2752804 2022-12-29 Germany Nordrhein-Westfalen     7781619 29846 0   51.4332 7.6616 2022-12-30 04:21:04 Nordrhein-Westfalen, Germany
2752805 2752805 2022-12-29 Germany Rheinland-Pfalz     1719750 6644 0   50.1183 7.309 2022-12-30 04:21:04 Rheinland-Pfalz, Germany
2752806 2752806 2022-12-29 Germany Saarland     478970 2014 0   49.3964 7.023 2022-12-30 04:21:04 Saarland, Germany
2752807 2752807 2022-12-29 Germany Sachsen     1931357 16534 0   51.1045 13.2017 2022-12-30 04:21:04 Sachsen, Germany
2752808 2752808 2022-12-29 Germany Sachsen-Anhalt     945452 6120 0   51.9503 11.6923 2022-12-30 04:21:04 Sachsen-Anhalt, Germany
2752809 2752809 2022-12-29 Germany Schleswig-Holstein     1155870 3303 0   54.2194 9.6961 2022-12-30 04:21:04 Schleswig-Holstein, Germany
2752810 2752810 2022-12-29 Germany Thuringen     872890 8075 0   51.011 10.8453 2022-12-30 04:21:04 Thuringen, Germany
2752811 2752811 2022-12-29 Germany Unknown     0 0 0       2022-12-30 04:21:04 Unknown, Germany
1073801 1073801 2022-12-28 Germany Baden-Wurttemberg     4961488 18525 0   48.6616 9.3501 2022-12-29 04:21:01 Baden-Wurttemberg, Germany
1073802 1073802 2022-12-28 Germany Bayern     6603197 27482 0   48.7904 11.4979 2022-12-29 04:21:01 Bayern, Germany
1073803 1073803 2022-12-28 Germany Berlin     1398759 5243 0   52.52 13.405 2022-12-29 04:21:01 Berlin, Germany
1073804 1073804 2022-12-28 Germany Brandenburg     1090266 6291 0   52.4125 12.5316 2022-12-29 04:21:01 Brandenburg, Germany
1073805 1073805 2022-12-28 Germany Bremen     296325 917 0   53.0793 8.8017 2022-12-29 04:21:01 Bremen, Germany
1073806 1073806 2022-12-28 Germany Hamburg     794242 3358 0   53.5511 9.9937 2022-12-29 04:21:01 Hamburg, Germany
1073807 1073807 2022-12-28 Germany Hessen     2843692 11868 0   50.6521 9.1624 2022-12-29 04:21:01 Hessen, Germany
1073808 1073808 2022-12-28 Germany Mecklenburg-Vorpommern     696315 2643 0   53.6127 12.4296 2022-12-29 04:21:01 Mecklenburg-Vorpommern, Germany
1073809 1073809 2022-12-28 Germany Niedersachsen     3735470 12252 0   52.6367 9.8451 2022-12-29 04:21:01 Niedersachsen, Germany
1073810 1073810 2022-12-28 Germany Nordrhein-Westfalen     7759544 29770 0   51.4332 7.6616 2022-12-29 04:21:01 Nordrhein-Westfalen, Germany
1073811 1073811 2022-12-28 Germany Rheinland-Pfalz     1717047 6630 0   50.1183 7.309 2022-12-29 04:21:01 Rheinland-Pfalz, Germany
1073812 1073812 2022-12-28 Germany Saarland     478099 2010 0   49.3964 7.023 2022-12-29 04:21:01 Saarland, Germany
1073813 1073813 2022-12-28 Germany Sachsen     1929248 16525 0   51.1045 13.2017 2022-12-29 04:21:01 Sachsen, Germany
1073814 1073814 2022-12-28 Germany Sachsen-Anhalt     944143 6107 0   51.9503 11.6923 2022-12-29 04:21:01 Sachsen-Anhalt, Germany
1073815 1073815 2022-12-28 Germany Schleswig-Holstein     1152433 3289 0   54.2194 9.6961 2022-12-29 04:21:01 Schleswig-Holstein, Germany
1073816 1073816 2022-12-28 Germany Thuringen     872162 8062 0   51.011 10.8453 2022-12-29 04:21:01 Thuringen, Germany
1073817 1073817 2022-12-28 Germany Unknown     0 0 0       2022-12-29 04:21:01 Unknown, Germany
327798 327798 2022-12-27 Germany Baden-Wurttemberg     4955988 18494 0   48.6616 9.3501 2022-12-28 04:21:04 Baden-Wurttemberg, Germany
327799 327799 2022-12-27 Germany Bayern     6597086 27452 0   48.7904 11.4979 2022-12-28 04:21:04 Bayern, Germany
327800 327800 2022-12-27 Germany Berlin     1395995 5236 0   52.52 13.405 2022-12-28 04:21:04 Berlin, Germany
327801 327801 2022-12-27 Germany Brandenburg     1088700 6284 0   52.4125 12.5316 2022-12-28 04:21:04 Brandenburg, Germany
327802 327802 2022-12-27 Germany Bremen     295200 913 0   53.0793 8.8017 2022-12-28 04:21:04 Bremen, Germany
327803 327803 2022-12-27 Germany Hamburg     792813 3352 0   53.5511 9.9937 2022-12-28 04:21:04 Hamburg, Germany
327804 327804 2022-12-27 Germany Hessen     2838126 11857 0   50.6521 9.1624 2022-12-28 04:21:04 Hessen, Germany
327805 327805 2022-12-27 Germany Mecklenburg-Vorpommern     695163 2639 0   53.6127 12.4296 2022-12-28 04:21:04 Mecklenburg-Vorpommern, Germany
327806 327806 2022-12-27 Germany Niedersachsen     3726279 12230 0   52.6367 9.8451 2022-12-28 04:21:04 Niedersachsen, Germany
327807 327807 2022-12-27 Germany Nordrhein-Westfalen     7741626 29730 0   51.4332 7.6616 2022-12-28 04:21:04 Nordrhein-Westfalen, Germany
327808 327808 2022-12-27 Germany Rheinland-Pfalz     1715006 6626 0   50.1183 7.309 2022-12-28 04:21:04 Rheinland-Pfalz, Germany
327809 327809 2022-12-27 Germany Saarland     477361 2002 0   49.3964 7.023 2022-12-28 04:21:04 Saarland, Germany
327810 327810 2022-12-27 Germany Sachsen     1927930 16518 0   51.1045 13.2017 2022-12-28 04:21:04 Sachsen, Germany
327811 327811 2022-12-27 Germany Sachsen-Anhalt     943096 6107 0   51.9503 11.6923 2022-12-28 04:21:04 Sachsen-Anhalt, Germany
327812 327812 2022-12-27 Germany Schleswig-Holstein     1150078 3282 0   54.2194 9.6961 2022-12-28 04:21:04 Schleswig-Holstein, Germany
327813 327813 2022-12-27 Germany Thuringen     871531 8046 0   51.011 10.8453 2022-12-28 04:21:04 Thuringen, Germany
327814 327814 2022-12-27 Germany Unknown     0 0 0       2022-12-28 04:21:04 Unknown, Germany
217871 217871 2022-12-26 Germany Baden-Wurttemberg     4953505 18482 0   48.6616 9.3501 2022-12-27 04:21:07 Baden-Wurttemberg, Germany
217872 217872 2022-12-26 Germany Bayern     6594347 27437 0   48.7904 11.4979 2022-12-27 04:21:07 Bayern, Germany
217873 217873 2022-12-26 Germany Berlin     1394416 5229 0   52.52 13.405 2022-12-27 04:21:07 Berlin, Germany
217874 217874 2022-12-26 Germany Brandenburg     1087669 6279 0   52.4125 12.5316 2022-12-27 04:21:07 Brandenburg, Germany
217875 217875 2022-12-26 Germany Bremen     295132 912 0   53.0793 8.8017 2022-12-27 04:21:07 Bremen, Germany
217876 217876 2022-12-26 Germany Hamburg     792171 3351 0   53.5511 9.9937 2022-12-27 04:21:07 Hamburg, Germany
217877 217877 2022-12-26 Germany Hessen     2835186 11849 0   50.6521 9.1624 2022-12-27 04:21:07 Hessen, Germany
217878 217878 2022-12-26 Germany Mecklenburg-Vorpommern     694329 2637 0   53.6127 12.4296 2022-12-27 04:21:07 Mecklenburg-Vorpommern, Germany
217879 217879 2022-12-26 Germany Niedersachsen     3720355 12202 0   52.6367 9.8451 2022-12-27 04:21:07 Niedersachsen, Germany
217880 217880 2022-12-26 Germany Nordrhein-Westfalen     7731379 29684 0   51.4332 7.6616 2022-12-27 04:21:07 Nordrhein-Westfalen, Germany
217881 217881 2022-12-26 Germany Rheinland-Pfalz     1713242 6627 0   50.1183 7.309 2022-12-27 04:21:07 Rheinland-Pfalz, Germany
217882 217882 2022-12-26 Germany Saarland     477029 2001 0   49.3964 7.023 2022-12-27 04:21:07 Saarland, Germany
217883 217883 2022-12-26 Germany Sachsen     1927010 16510 0   51.1045 13.2017 2022-12-27 04:21:07 Sachsen, Germany
217884 217884 2022-12-26 Germany Sachsen-Anhalt     942400 6105 0   51.9503 11.6923 2022-12-27 04:21:07 Sachsen-Anhalt, Germany
217885 217885 2022-12-26 Germany Schleswig-Holstein     1148548 3276 0   54.2194 9.6961 2022-12-27 04:21:07 Schleswig-Holstein, Germany
217886 217886 2022-12-26 Germany Thuringen     871127 8030 0   51.011 10.8453 2022-12-27 04:21:07 Thuringen, Germany
217887 217887 2022-12-26 Germany Unknown     0 0 0       2022-12-27 04:21:07 Unknown, Germany
3222328 3222328 2022-12-25 Germany Baden-Wurttemberg     4953505 18482 0   48.6616 9.3501 2022-12-26 04:21:06 Baden-Wurttemberg, Germany
3222329 3222329 2022-12-25 Germany Bayern     6594347 27437 0   48.7904 11.4979 2022-12-26 04:21:06 Bayern, Germany
3222330 3222330 2022-12-25 Germany Berlin     1394416 5229 0   52.52 13.405 2022-12-26 04:21:06 Berlin, Germany
3222331 3222331 2022-12-25 Germany Brandenburg     1087669 6279 0   52.4125 12.5316 2022-12-26 04:21:06 Brandenburg, Germany
3222332 3222332 2022-12-25 Germany Bremen     295132 912 0   53.0793 8.8017 2022-12-26 04:21:06 Bremen, Germany
3222333 3222333 2022-12-25 Germany Hamburg     792171 3351 0   53.5511 9.9937 2022-12-26 04:21:06 Hamburg, Germany
3222334 3222334 2022-12-25 Germany Hessen     2835186 11849 0   50.6521 9.1624 2022-12-26 04:21:06 Hessen, Germany
3222335 3222335 2022-12-25 Germany Mecklenburg-Vorpommern     694329 2637 0   53.6127 12.4296 2022-12-26 04:21:06 Mecklenburg-Vorpommern, Germany
3222336 3222336 2022-12-25 Germany Niedersachsen     3720355 12202 0   52.6367 9.8451 2022-12-26 04:21:06 Niedersachsen, Germany
3222337 3222337 2022-12-25 Germany Nordrhein-Westfalen     7731379 29684 0   51.4332 7.6616 2022-12-26 04:21:06 Nordrhein-Westfalen, Germany
3222338 3222338 2022-12-25 Germany Rheinland-Pfalz     1713242 6627 0   50.1183 7.309 2022-12-26 04:21:06 Rheinland-Pfalz, Germany
3222339 3222339 2022-12-25 Germany Saarland     477029 2001 0   49.3964 7.023 2022-12-26 04:21:06 Saarland, Germany
3222340 3222340 2022-12-25 Germany Sachsen     1927010 16510 0   51.1045 13.2017 2022-12-26 04:21:06 Sachsen, Germany
3222341 3222341 2022-12-25 Germany Sachsen-Anhalt     942400 6105 0   51.9503 11.6923 2022-12-26 04:21:06 Sachsen-Anhalt, Germany
3222342 3222342 2022-12-25 Germany Schleswig-Holstein     1148548 3276 0   54.2194 9.6961 2022-12-26 04:21:06 Schleswig-Holstein, Germany
3222343 3222343 2022-12-25 Germany Thuringen     871127 8030 0   51.011 10.8453 2022-12-26 04:21:06 Thuringen, Germany
3222344 3222344 2022-12-25 Germany Unknown     0 0 0       2022-12-26 04:21:06 Unknown, Germany
1018242 1018242 2022-12-24 Germany Baden-Wurttemberg     4953505 18482 0   48.6616 9.3501 2022-12-25 04:21:04 Baden-Wurttemberg, Germany
1018243 1018243 2022-12-24 Germany Bayern     6594347 27437 0   48.7904 11.4979 2022-12-25 04:21:04 Bayern, Germany
1018244 1018244 2022-12-24 Germany Berlin     1394416 5229 0   52.52 13.405 2022-12-25 04:21:04 Berlin, Germany
1018245 1018245 2022-12-24 Germany Brandenburg     1087669 6279 0   52.4125 12.5316 2022-12-25 04:21:04 Brandenburg, Germany
1018246 1018246 2022-12-24 Germany Bremen     295132 912 0   53.0793 8.8017 2022-12-25 04:21:04 Bremen, Germany
1018247 1018247 2022-12-24 Germany Hamburg     792171 3351 0   53.5511 9.9937 2022-12-25 04:21:04 Hamburg, Germany
1018248 1018248 2022-12-24 Germany Hessen     2835186 11849 0   50.6521 9.1624 2022-12-25 04:21:04 Hessen, Germany
1018249 1018249 2022-12-24 Germany Mecklenburg-Vorpommern     694329 2637 0   53.6127 12.4296 2022-12-25 04:21:04 Mecklenburg-Vorpommern, Germany
1018250 1018250 2022-12-24 Germany Niedersachsen     3720355 12202 0   52.6367 9.8451 2022-12-25 04:21:04 Niedersachsen, Germany
1018251 1018251 2022-12-24 Germany Nordrhein-Westfalen     7731379 29684 0   51.4332 7.6616 2022-12-25 04:21:04 Nordrhein-Westfalen, Germany
1018252 1018252 2022-12-24 Germany Rheinland-Pfalz     1713242 6627 0   50.1183 7.309 2022-12-25 04:21:04 Rheinland-Pfalz, Germany
1018253 1018253 2022-12-24 Germany Saarland     477029 2001 0   49.3964 7.023 2022-12-25 04:21:04 Saarland, Germany
1018254 1018254 2022-12-24 Germany Sachsen     1927010 16510 0   51.1045 13.2017 2022-12-25 04:21:04 Sachsen, Germany
1018255 1018255 2022-12-24 Germany Sachsen-Anhalt     942400 6105 0   51.9503 11.6923 2022-12-25 04:21:04 Sachsen-Anhalt, Germany
1018256 1018256 2022-12-24 Germany Schleswig-Holstein     1148548 3276 0   54.2194 9.6961 2022-12-25 04:21:04 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] TEXT,
   [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]);