daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16,427 rows where country_or_region = "Germany" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, day (date), last_update (date)
province_or_state 18
- Baden-Wurttemberg 960
- Bayern 960
- Berlin 960
- Brandenburg 960
- Bremen 960
- Hamburg 960
- Hessen 960
- Mecklenburg-Vorpommern 960
- Niedersachsen 960
- Nordrhein-Westfalen 960
- Rheinland-Pfalz 960
- Saarland 960
- Sachsen 960
- Sachsen-Anhalt 960
- Schleswig-Holstein 960
- Thuringen 960
- Unknown 960
- Bavaria 4
country_or_region 1
- Germany · 16,427 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-01-28 | Germany | Bavaria | 4 | 0 | 0 | 1/28/20 23:00 | ||||||
2020-01-29 | Germany | Bavaria | 4 | 0 | 0 | 1/29/20 19:30 | ||||||
2020-01-30 | Germany | Bavaria | 4 | 0 | 0 | 1/30/20 16:00 | ||||||
2020-01-31 | Germany | Bavaria | 5 | 0 | 0 | 1/31/2020 23:59 | ||||||
2020-02-01 | Germany | 8 | 0 | 0 | 2/1/2020 18:33 | |||||||
2020-02-02 | Germany | 10 | 0 | 0 | 2020-02-02T18:03:05 | |||||||
2020-02-06 | Germany | 12 | 0 | 0 | 2020-02-03T20:53:02 | |||||||
2020-02-05 | Germany | 12 | 0 | 0 | 2020-02-03T20:53:02 | |||||||
2020-02-03 | Germany | 12 | 0 | 0 | 2020-02-03T20:53:02 | |||||||
2020-02-04 | Germany | 12 | 0 | 0 | 2020-02-03T20:53:02 | |||||||
2020-02-08 | Germany | 13 | 0 | 0 | 2020-02-07T16:33:03 | |||||||
2020-02-07 | Germany | 13 | 0 | 0 | 2020-02-07T16:33:03 | |||||||
2020-02-10 | Germany | 14 | 0 | 0 | 2020-02-09T06:13:11 | |||||||
2020-02-09 | Germany | 14 | 0 | 0 | 2020-02-09T06:13:11 | |||||||
2020-02-12 | Germany | 16 | 0 | 0 | 2020-02-11T19:33:03 | |||||||
2020-02-11 | Germany | 16 | 0 | 0 | 2020-02-11T19:33:03 | |||||||
2020-02-15 | Germany | 16 | 0 | 1 | 2020-02-13T15:13:11 | |||||||
2020-02-14 | Germany | 16 | 0 | 1 | 2020-02-13T15:13:11 | |||||||
2020-02-17 | Germany | 16 | 0 | 1 | 2020-02-13T15:13:11 | |||||||
2020-02-13 | Germany | 16 | 0 | 1 | 2020-02-13T15:13:11 | |||||||
2020-02-16 | Germany | 16 | 0 | 1 | 2020-02-13T15:13:11 | |||||||
2020-02-19 | Germany | 16 | 0 | 12 | 2020-02-18T17:03:03 | |||||||
2020-02-18 | Germany | 16 | 0 | 12 | 2020-02-18T17:03:03 | |||||||
2020-02-20 | Germany | 16 | 0 | 12 | 2020-02-18T17:03:03 | |||||||
2020-02-22 | Germany | 16 | 0 | 14 | 2020-02-21T23:03:13 | |||||||
2020-02-21 | Germany | 16 | 0 | 14 | 2020-02-21T23:03:13 | |||||||
2020-02-23 | Germany | 16 | 0 | 14 | 2020-02-21T23:03:13 | |||||||
2020-02-24 | Germany | 16 | 0 | 14 | 2020-02-21T23:03:13 | |||||||
2020-02-25 | Germany | 17 | 0 | 14 | 2020-02-25T21:33:02 | |||||||
2020-02-26 | Germany | 27 | 0 | 15 | 2020-02-26T23:43:03 | |||||||
2020-02-27 | Germany | 46 | 0 | 16 | 2020-02-27T23:13:04 | |||||||
2020-02-28 | Germany | 48 | 0 | 16 | 2020-02-28T00:13:18 | |||||||
2020-02-29 | Germany | 79 | 0 | 16 | 2020-02-29T14:43:03 | |||||||
2020-03-01 | Germany | 130 | 0 | 16 | 51.0 | 9.0 | 2020-03-01T23:23:02 | |||||
2020-03-02 | Germany | 159 | 0 | 16 | 51.0 | 9.0 | 2020-03-02T20:33:02 | |||||
2020-03-03 | Germany | 196 | 0 | 16 | 51.0 | 9.0 | 2020-03-03T20:03:06 | |||||
2020-03-04 | Germany | 262 | 0 | 16 | 51.0 | 9.0 | 2020-03-04T19:33:03 | |||||
2020-03-05 | Germany | 482 | 0 | 16 | 51.0 | 9.0 | 2020-03-05T17:43:03 | |||||
2020-03-06 | Germany | 670 | 0 | 17 | 51.0 | 9.0 | 2020-03-06T17:53:03 | |||||
2020-03-07 | Germany | 799 | 0 | 18 | 51.0 | 9.0 | 2020-03-07T17:43:05 | |||||
2020-03-08 | Germany | 1040 | 0 | 18 | 51.0 | 9.0 | 2020-03-08T21:03:03 | |||||
2020-03-09 | Germany | 1176 | 2 | 18 | 51.0 | 9.0 | 2020-03-09T18:13:11 | |||||
2020-03-10 | Germany | 1457 | 2 | 18 | 51.0 | 9.0 | 2020-03-10T18:53:02 | |||||
2020-03-11 | Germany | 1908 | 3 | 25 | 51.0 | 9.0 | 2020-03-11T19:13:17 | |||||
2020-03-13 | Germany | 3675 | 7 | 46 | 51.1657 | 10.4515 | 2020-03-11T20:00:00 | |||||
2020-03-12 | Germany | 2078 | 3 | 25 | 51.0 | 9.0 | 2020-03-12T09:53:06 | |||||
2020-03-14 | Germany | 4585 | 9 | 46 | 51.1657 | 10.4515 | 2020-03-14T22:13:11 | |||||
2020-03-15 | Germany | 5795 | 11 | 46 | 51.1657 | 10.4515 | 2020-03-15T18:20:18 | |||||
2020-03-16 | Germany | 7272 | 17 | 67 | 51.1657 | 10.4515 | 2020-03-16T20:13:11 | |||||
2020-03-17 | Germany | 9257 | 24 | 67 | 51.1657 | 10.4515 | 2020-03-17T18:53:02 | |||||
2020-03-18 | Germany | 12327 | 28 | 105 | 51.1657 | 10.4515 | 2020-03-18T19:33:02 | |||||
2020-03-19 | Germany | 15320 | 44 | 113 | 51.1657 | 10.4515 | 2020-03-19T20:13:08 | |||||
2020-03-20 | Germany | 19848 | 67 | 180 | 51.1657 | 10.4515 | 2020-03-20T20:13:15 | |||||
2020-03-21 | Germany | 22213 | 84 | 233 | 51.1657 | 10.4515 | 2020-03-21T20:43:02 | |||||
2020-03-23 | Germany | 29056 | 123 | 453 | 28480 | 51.165690999999995 | 10.451526 | 2020-03-23 23:19:21 | Germany | |||
2020-03-24 | Germany | 32986 | 157 | 3243 | 29586 | 51.165690999999995 | 10.451526 | 2020-03-24 23:37:15 | Germany | |||
2020-03-25 | Germany | 37323 | 206 | 3547 | 33570 | 51.165690999999995 | 10.451526 | 2020-03-25 23:33:04 | Germany | |||
2020-03-26 | Germany | 43938 | 267 | 5673 | 37998 | 51.165690999999995 | 10.451526 | 2020-03-26 23:48:18 | Germany | |||
2020-03-27 | Germany | 50871 | 342 | 6658 | 43871 | 51.165690999999995 | 10.451526 | 2020-03-27 23:23:03 | Germany | |||
2020-03-31 | Germany | 71808 | 775 | 16100 | 54933 | 51.165690999999995 | 10.451526 | 2020-03-31 23:43:43 | Germany | |||
2020-04-01 | Germany | 77872 | 920 | 18700 | 58252 | 51.165690999999995 | 10.451526 | 2020-04-01 21:58:34 | Germany | |||
2020-04-03 | Germany | 91159 | 1275 | 24575 | 65309 | 51.165690999999995 | 10.451526 | 2020-04-03 22:46:20 | Germany | |||
2020-04-05 | Germany | 100123 | 1584 | 28700 | 69839 | 51.165690999999995 | 10.451526 | 2020-04-05 23:06:26 | Germany | |||
2020-04-07 | Germany | 107663 | 2016 | 36081 | 69566 | 51.165690999999995 | 10.451526 | 2020-04-07 23:04:29 | Germany | |||
2020-04-08 | Germany | 113296 | 2349 | 46300 | 64647 | 51.165690999999995 | 10.451526 | 2020-04-08 22:51:39 | Germany | |||
2020-04-09 | Germany | 118181 | 2607 | 52407 | 63167 | 51.165690999999995 | 10.451526 | 2020-04-09 23:02:19 | Germany | |||
2020-04-10 | Germany | 122171 | 2767 | 53913 | 65491 | 51.165690999999995 | 10.451526 | 2020-04-10 22:53:48 | Germany | |||
2020-04-11 | Germany | 124908 | 2736 | 57400 | 64772 | 51.165690999999995 | 10.451526 | 2020-04-11 22:45:13 | Germany | |||
2020-04-12 | Germany | 127854 | 3022 | 60300 | 64532 | 51.165691 | 10.451526 | 2020-04-12 23:17:00 | Germany | |||
2020-04-13 | Germany | 130072 | 3194 | 64300 | 62578 | 51.165690999999995 | 10.451526 | 2020-04-13 23:07:34 | Germany | |||
2020-04-14 | Germany | 131359 | 3294 | 68200 | 59865 | 51.165690999999995 | 10.451526 | 2020-04-14 23:33:12 | Germany | |||
2020-04-15 | Germany | 134753 | 3804 | 72600 | 58349 | 51.165690999999995 | 10.451526 | 2020-04-15 22:56:32 | Germany | |||
2020-04-16 | Germany | 137698 | 4052 | 77000 | 56646 | 51.165690999999995 | 10.451526 | 2020-04-16 23:30:31 | Germany | |||
2020-04-17 | Germany | 141397 | 4352 | 83114 | 53931 | 51.165690999999995 | 10.451526 | 2020-04-17 23:30:32 | Germany | |||
2020-04-18 | Germany | 143342 | 4459 | 85400 | 53483 | 51.165691 | 10.451526 | 2020-04-18 22:32:28 | Germany | |||
2020-04-19 | Germany | 145184 | 4586 | 88000 | 52598 | 51.165691 | 10.451526 | 2020-04-19 23:40:41 | Germany | |||
2020-04-20 | Germany | 147065 | 4862 | 91500 | 50703 | 51.165690999999995 | 10.451526 | 2020-04-20 23:36:27 | Germany | |||
2020-04-21 | Germany | 148291 | 5033 | 95200 | 48058 | 51.165690999999995 | 10.451526 | 2020-04-21 23:30:30 | Germany | |||
2020-04-22 | Germany | 150648 | 5279 | 99400 | 45969 | 51.165690999999995 | 10.451526 | 2020-04-22 23:30:32 | Germany | |||
2020-04-23 | Germany | 153129 | 5575 | 103300 | 44254 | 51.165690999999995 | 10.451526 | 2020-04-24 03:30:31 | Germany | |||
2020-04-24 | Germany | 154999 | 5760 | 109800 | 39439 | 51.165690999999995 | 10.451526 | 2020-04-25 06:30:33 | Germany | |||
2020-04-25 | Germany | 156513 | 5877 | 109800 | 40836 | 51.165690999999995 | 10.451526 | 2020-04-26 02:30:31 | Germany | |||
2020-04-26 | Germany | 157770 | 5976 | 112000 | 39794 | 51.165690999999995 | 10.451526 | 2020-04-27 02:30:33 | Germany | |||
2020-04-27 | Germany | 158758 | 6126 | 114500 | 38132 | 51.165690999999995 | 10.451526 | 2020-04-28 02:30:32 | Germany | |||
2020-04-28 | Germany | 159912 | 6314 | 117400 | 36198 | 51.165690999999995 | 10.451526 | 2020-04-29 02:32:29 | Germany | |||
2020-04-29 | Germany | 161539 | 6467 | 120400 | 34672 | 51.165690999999995 | 10.451526 | 2020-04-30 02:32:27 | Germany | |||
2020-04-30 | Germany | 163009 | 6623 | 123500 | 32886 | 51.165690999999995 | 10.451526 | 2020-05-01 02:32:28 | Germany | |||
2020-05-01 | Germany | 164077 | 6736 | 126900 | 30441 | 51.165690999999995 | 10.451526 | 2020-05-02 02:32:27 | Germany | |||
2020-05-02 | Germany | 164967 | 6812 | 129000 | 29155 | 51.165690999999995 | 10.451526 | 2020-05-03 02:32:28 | Germany | |||
2020-05-03 | Germany | 165664 | 6866 | 130600 | 28198 | 51.165690999999995 | 10.451526 | 2020-05-04 02:32:28 | Germany | |||
2020-05-04 | Germany | 166152 | 6993 | 132700 | 26459 | 51.165690999999995 | 10.451526 | 2020-05-05 02:32:34 | Germany | |||
2020-05-05 | Germany | 167007 | 6993 | 135100 | 24914 | 51.165690999999995 | 10.451526 | 2020-05-06 02:32:31 | Germany | |||
2020-05-06 | Germany | 168162 | 7275 | 139900 | 20987 | 51.165690999999995 | 10.451526 | 2020-05-07 02:32:28 | Germany | |||
2020-05-07 | Germany | 169430 | 7392 | 141700 | 20338 | 51.165690999999995 | 10.451526 | 2020-05-08 02:32:32 | Germany | |||
2020-05-08 | Germany | 170588 | 7510 | 141700 | 21378 | 51.165691 | 10.451526 | 2020-05-09 02:32:35 | Germany | |||
2020-05-09 | Germany | 171324 | 7549 | 143300 | 20475 | 51.165691 | 10.451526 | 2020-05-10 02:32:30 | Germany | |||
2020-05-10 | Germany | 171879 | 7569 | 144400 | 19910 | 51.165691 | 10.451526 | 2020-05-11 02:32:30 | Germany | |||
2020-05-11 | Germany | 172576 | 7661 | 145617 | 19298 | 51.165691 | 10.451526 | 2020-05-12 03:32:27 | Germany | |||
2020-05-12 | Germany | 173171 | 7738 | 147200 | 18233 | 51.165691 | 10.451526 | 2020-05-13 03:32:26 | Germany | |||
2020-05-13 | Germany | 174098 | 7861 | 148700 | 17537 | 51.165691 | 10.451526 | 2020-05-14 03:32:28 | Germany |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;