johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Germany" and province_or_state = "Berlin" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181949 | 181949 | 2021-02-21 | Germany | Berlin | 126825 | 2727 | 119154 | 5025 | 52.52 | 13.405 | 2021-02-22 05:24:21 | Berlin, Germany | ||
742223 | 742223 | 2021-02-20 | Germany | Berlin | 126573 | 2720 | 118666 | 5441 | 52.52 | 13.405 | 2021-02-21 05:24:33 | Berlin, Germany | ||
471321 | 471321 | 2021-02-19 | Germany | Berlin | 126201 | 2702 | 118431 | 5431 | 52.52 | 13.405 | 2021-02-20 05:22:51 | Berlin, Germany | ||
1153030 | 1153030 | 2021-02-18 | Germany | Berlin | 125726 | 2670 | 118071 | 5437 | 52.52 | 13.405 | 2021-02-19 05:24:16 | Berlin, Germany | ||
3600950 | 3600950 | 2021-02-17 | Germany | Berlin | 125274 | 2644 | 117577 | 5488 | 52.52 | 13.405 | 2021-02-18 05:22:58 | Berlin, Germany | ||
3050085 | 3050085 | 2021-02-16 | Germany | Berlin | 124979 | 2619 | 117094 | 5560 | 52.52 | 13.405 | 2021-02-17 05:23:10 | Berlin, Germany | ||
1338184 | 1338184 | 2021-02-15 | Germany | Berlin | 124782 | 2608 | 116510 | 5857 | 52.52 | 13.405 | 2021-02-16 05:24:38 | Berlin, Germany | ||
2283335 | 2283335 | 2021-02-14 | Germany | Berlin | 124711 | 2604 | 115881 | 6300 | 52.52 | 13.405 | 2021-02-15 05:24:49 | Berlin, Germany | ||
2677735 | 2677735 | 2021-02-13 | Germany | Berlin | 124518 | 2598 | 115338 | 6776 | 52.52 | 13.405 | 2021-02-14 05:23:43 | Berlin, Germany | ||
3539368 | 3539368 | 2021-02-12 | Germany | Berlin | 124134 | 2574 | 115124 | 6796 | 52.52 | 13.405 | 2021-02-13 05:22:12 | Berlin, Germany | ||
2637631 | 2637631 | 2021-02-11 | Germany | Berlin | 123649 | 2551 | 114773 | 6787 | 52.52 | 13.405 | 2021-02-12 05:23:29 | Berlin, Germany | ||
3978486 | 3978486 | 2021-02-10 | Germany | Berlin | 123192 | 2507 | 114028 | 7151 | 52.52 | 13.405 | 2021-02-11 05:23:55 | Berlin, Germany | ||
1527806 | 1527806 | 2021-02-09 | Germany | Berlin | 122890 | 2486 | 113443 | 7242 | 52.52 | 13.405 | 2021-02-10 05:22:41 | Berlin, Germany | ||
613597 | 613597 | 2021-02-08 | Germany | Berlin | 122606 | 2471 | 112038 | 8366 | 52.52 | 13.405 | 2021-02-09 05:23:30 | Berlin, Germany | ||
1672366 | 1672366 | 2021-02-07 | Germany | Berlin | 122456 | 2467 | 112023 | 8112 | 52.52 | 13.405 | 2021-02-08 05:22:39 | Berlin, Germany | ||
974827 | 974827 | 2021-02-06 | Germany | Berlin | 122229 | 2454 | 111145 | 8844 | 52.52 | 13.405 | 2021-02-07 05:23:00 | Berlin, Germany | ||
1588085 | 1588085 | 2021-02-05 | Germany | Berlin | 121878 | 2420 | 110818 | 8957 | 52.52 | 13.405 | 2021-02-06 05:23:55 | Berlin, Germany | ||
790292 | 790292 | 2021-02-04 | Germany | Berlin | 121399 | 2376 | 110416 | 9042 | 52.52 | 13.405 | 2021-02-05 05:22:38 | Berlin, Germany | ||
340184 | 340184 | 2021-02-03 | Germany | Berlin | 120750 | 2328 | 109552 | 9471 | 52.52 | 13.405 | 2021-02-04 05:22:26 | Berlin, Germany | ||
1684410 | 1684410 | 2021-02-02 | Germany | Berlin | 120397 | 2295 | 108540 | 9882 | 52.52 | 13.405 | 2021-02-03 05:22:52 | Berlin, Germany | ||
1676380 | 1676380 | 2021-02-01 | Germany | Berlin | 119943 | 2278 | 107650 | 10452 | 52.52 | 13.405 | 2021-02-02 05:22:49 | Berlin, Germany | ||
1459668 | 1459668 | 2021-01-31 | Germany | Berlin | 119844 | 2268 | 106105 | 11556 | 52.52 | 13.405 | 2021-02-01 05:22:53 | Berlin, Germany | ||
2211576 | 2211576 | 2021-01-30 | Germany | Berlin | 119514 | 2238 | 106086 | 11490 | 52.52 | 13.405 | 2021-01-31 05:22:42 | Berlin, Germany | ||
1897063 | 1897063 | 2021-01-29 | Germany | Berlin | 118955 | 2198 | 105113 | 12158 | 52.52 | 13.405 | 2021-01-30 05:22:49 | Berlin, Germany | ||
2481879 | 2481879 | 2021-01-28 | Germany | Berlin | 118433 | 2164 | 105033 | 11724 | 52.52 | 13.405 | 2021-01-29 05:22:23 | Berlin, Germany | ||
3153514 | 3153514 | 2021-01-27 | Germany | Berlin | 117602 | 2111 | 103721 | 12562 | 52.52 | 13.405 | 2021-01-28 05:22:24 | Berlin, Germany | ||
12249 | 12249 | 2021-01-26 | Germany | Berlin | 117114 | 2067 | 103721 | 11735 | 52.52 | 13.405 | 2021-01-27 05:23:41 | Berlin, Germany | ||
2567573 | 2567573 | 2021-01-25 | Germany | Berlin | 116742 | 2040 | 102879 | 12178 | 52.52 | 13.405 | 2021-01-26 05:22:02 | Berlin, Germany | ||
1759205 | 1759205 | 2021-01-24 | Germany | Berlin | 116582 | 2039 | 102085 | 12630 | 52.52 | 13.405 | 2021-01-25 05:22:16 | Berlin, Germany | ||
2426812 | 2426812 | 2021-01-23 | Germany | Berlin | 116119 | 2021 | 101197 | 13359 | 52.52 | 13.405 | 2021-01-24 05:22:35 | Berlin, Germany | ||
2466714 | 2466714 | 2021-01-22 | Germany | Berlin | 115506 | 1996 | 100596 | 13515 | 52.52 | 13.405 | 2021-01-23 05:22:03 | Berlin, Germany | ||
435265 | 435265 | 2021-01-21 | Germany | Berlin | 114606 | 1957 | 99675 | 13846 | 52.52 | 13.405 | 2021-01-22 05:22:10 | Berlin, Germany | ||
1093997 | 1093997 | 2021-01-20 | Germany | Berlin | 113875 | 1918 | 99001 | 13658 | 52.52 | 13.405 | 2021-01-21 05:22:01 | Berlin, Germany | ||
908087 | 908087 | 2021-01-19 | Germany | Berlin | 113055 | 1860 | 98093 | 13873 | 52.52 | 13.405 | 2021-01-20 05:21:54 | Berlin, Germany | ||
237150 | 237150 | 2021-01-18 | Germany | Berlin | 112511 | 1833 | 95722 | 15478 | 52.52 | 13.405 | 2021-01-19 05:22:15 | Berlin, Germany | ||
3503267 | 3503267 | 2021-01-17 | Germany | Berlin | 112262 | 1823 | 95600 | 15083 | 52.52 | 13.405 | 2021-01-18 05:22:34 | Berlin, Germany | ||
3101350 | 3101350 | 2021-01-16 | Germany | Berlin | 111730 | 1800 | 93823 | 16587 | 52.52 | 13.405 | 2021-01-17 05:22:17 | Berlin, Germany | ||
3515312 | 3515312 | 2021-01-15 | Germany | Berlin | 110740 | 1755 | 93262 | 16675 | 52.52 | 13.405 | 2021-01-16 05:22:40 | Berlin, Germany | ||
3879485 | 3879485 | 2021-01-14 | Germany | Berlin | 109569 | 1711 | 93003 | 15989 | 52.52 | 13.405 | 2021-01-15 05:22:24 | Berlin, Germany | ||
3308112 | 3308112 | 2021-01-13 | Germany | Berlin | 108295 | 1635 | 91830 | 16028 | 52.52 | 13.405 | 2021-01-14 05:22:32 | Berlin, Germany | ||
774257 | 774257 | 2021-01-12 | Germany | Berlin | 107226 | 1591 | 90530 | 16138 | 52.52 | 13.405 | 2021-01-13 05:22:15 | Berlin, Germany | ||
189978 | 189978 | 2021-01-11 | Germany | Berlin | 106190 | 1565 | 89036 | 16606 | 52.52 | 13.405 | 2021-01-12 05:22:15 | Berlin, Germany | ||
2625781 | 2625781 | 2021-01-10 | Germany | Berlin | 105850 | 1560 | 88003 | 16629 | 52.52 | 13.405 | 2021-01-11 05:21:50 | Berlin, Germany | ||
3899869 | 3899869 | 2021-01-09 | Germany | Berlin | 105118 | 1547 | 86643 | 17654 | 52.52 | 13.405 | 2021-01-10 05:22:12 | Berlin, Germany | ||
153892 | 153892 | 2021-01-08 | Germany | Berlin | 103639 | 1487 | 86037 | 17541 | 52.52 | 13.405 | 2021-01-09 05:22:18 | Berlin, Germany | ||
2541316 | 2541316 | 2021-01-07 | Germany | Berlin | 102070 | 1445 | 85203 | 16956 | 52.52 | 13.405 | 2021-01-08 05:22:42 | Berlin, Germany | ||
2864625 | 2864625 | 2021-01-06 | Germany | Berlin | 100760 | 1390 | 84112 | 16520 | 52.52 | 13.405 | 2021-01-07 05:22:03 | Berlin, Germany | ||
3034212 | 3034212 | 2021-01-05 | Germany | Berlin | 99525 | 1327 | 82837 | 16544 | 52.52 | 13.405 | 2021-01-06 05:22:16 | Berlin, Germany | ||
1061757 | 1061757 | 2021-01-04 | Germany | Berlin | 98754 | 1305 | 81536 | 16673 | 52.52 | 13.405 | 2021-01-05 05:21:49 | Berlin, Germany | ||
3230360 | 3230360 | 2021-01-03 | Germany | Berlin | 98097 | 1285 | 80457 | 17003 | 52.52 | 13.405 | 2021-01-04 05:22:02 | Berlin, Germany | ||
2227429 | 2227429 | 2021-01-02 | Germany | Berlin | 97637 | 1277 | 79296 | 17528 | 52.52 | 13.405 | 2021-01-03 05:22:52 | Berlin, Germany | ||
1136793 | 1136793 | 2021-01-01 | Germany | Berlin | 96788 | 1247 | 78947 | 17428 | 52.52 | 13.405 | 2021-01-02 05:22:33 | Berlin, Germany | ||
3695399 | 3695399 | 2020-12-31 | Germany | Berlin | 96788 | 1247 | 77560 | 18614 | 52.52 | 13.405 | 2021-01-01 05:23:07 | Berlin, Germany | ||
1010214 | 1010214 | 2020-12-30 | Germany | Berlin | 95729 | 1213 | 77315 | 18240 | 52.52 | 13.405 | 2020-12-31 05:22:49 | Berlin, Germany | ||
766229 | 766229 | 2020-12-29 | Germany | Berlin | 94442 | 1172 | 75918 | 18612 | 52.52 | 13.405 | 2020-12-30 05:22:34 | Berlin, Germany | ||
3761493 | 3761493 | 2020-12-28 | Germany | Berlin | 93796 | 1149 | 74744 | 18537 | 52.52 | 13.405 | 2020-12-29 05:22:37 | Berlin, Germany | ||
3777813 | 3777813 | 2020-12-27 | Germany | Berlin | 92981 | 1128 | 73754 | 18904 | 52.52 | 13.405 | 2020-12-28 05:22:06 | Berlin, Germany | ||
2223418 | 2223418 | 2020-12-26 | Germany | Berlin | 92346 | 1118 | 72771 | 19093 | 52.52 | 13.405 | 2020-12-27 05:22:55 | Berlin, Germany | ||
202165 | 202165 | 2020-12-25 | Germany | Berlin | 91116 | 1105 | 72427 | 18812 | 52.52 | 13.405 | 2020-12-26 05:22:28 | Berlin, Germany | ||
3691388 | 3691388 | 2020-12-24 | Germany | Berlin | 91116 | 1105 | 71848 | 19115 | 52.52 | 13.405 | 2020-12-25 05:22:48 | Berlin, Germany | ||
2406740 | 2406740 | 2020-12-23 | Germany | Berlin | 89519 | 1066 | 70636 | 19386 | 52.52 | 13.405 | 2020-12-24 05:23:04 | Berlin, Germany | ||
3769786 | 3769786 | 2020-12-22 | Germany | Berlin | 88029 | 1024 | 69394 | 19074 | 52.52 | 13.405 | 2020-12-23 05:22:03 | Berlin, Germany | ||
927602 | 927602 | 2020-12-21 | Germany | Berlin | 86884 | 1006 | 68163 | 18843 | 52.52 | 13.405 | 2020-12-22 05:22:33 | Berlin, Germany | ||
2119623 | 2119623 | 2020-12-20 | Germany | Berlin | 86564 | 1001 | 67026 | 19044 | 52.52 | 13.405 | 2020-12-21 05:27:58 | Berlin, Germany | ||
2931130 | 2931130 | 2020-12-19 | Germany | Berlin | 85244 | 985 | 65841 | 19722 | 52.52 | 13.405 | 2020-12-20 05:27:32 | Berlin, Germany | ||
1901076 | 1901076 | 2020-12-18 | Germany | Berlin | 83697 | 959 | 65235 | 19024 | 52.52 | 13.405 | 2020-12-19 05:27:52 | Berlin, Germany | ||
2127902 | 2127902 | 2020-12-17 | Germany | Berlin | 82253 | 929 | 64529 | 18209 | 52.52 | 13.405 | 2020-12-18 05:28:18 | Berlin, Germany | ||
3149502 | 3149502 | 2020-12-16 | Germany | Berlin | 80936 | 899 | 63184 | 18140 | 52.52 | 13.405 | 2020-12-17 05:28:12 | Berlin, Germany | ||
1034283 | 1034283 | 2020-12-15 | Germany | Berlin | 79807 | 846 | 61914 | 18123 | 52.52 | 13.405 | 2020-12-16 05:28:04 | Berlin, Germany | ||
1751177 | 1751177 | 2020-12-14 | Germany | Berlin | 78796 | 821 | 60703 | 18258 | 52.52 | 13.405 | 2020-12-15 05:26:38 | Berlin, Germany | ||
3847697 | 3847697 | 2020-12-13 | Germany | Berlin | 78248 | 813 | 59421 | 18556 | 52.52 | 13.405 | 2020-12-14 05:26:27 | Berlin, Germany | ||
845479 | 845479 | 2020-12-12 | Germany | Berlin | 77208 | 790 | 58198 | 19239 | 52.52 | 13.405 | 2020-12-13 05:27:20 | Berlin, Germany | ||
860586 | 860586 | 2020-12-11 | Germany | Berlin | 76204 | 768 | 57526 | 18896 | 52.52 | 13.405 | 2020-12-12 05:26:19 | Berlin, Germany | ||
1600128 | 1600128 | 2020-12-10 | Germany | Berlin | 74552 | 749 | 56840 | 18602 | 52.52 | 13.405 | 2020-12-11 05:26:59 | Berlin, Germany | ||
2975137 | 2975137 | 2020-12-09 | Germany | Berlin | 73430 | 732 | 55369 | 18436 | 52.52 | 13.405 | 2020-12-10 05:26:19 | Berlin, Germany | ||
1818697 | 1818697 | 2020-12-08 | Germany | Berlin | 72082 | 699 | 53921 | 18778 | 52.52 | 13.405 | 2020-12-09 05:28:01 | Berlin, Germany | ||
2347333 | 2347333 | 2020-12-07 | Germany | Berlin | 71442 | 683 | 52363 | 19021 | 52.52 | 13.405 | 2020-12-08 05:27:42 | Berlin, Germany | ||
1006203 | 1006203 | 2020-12-06 | Germany | Berlin | 71087 | 679 | 51095 | 19665 | 52.52 | 13.405 | 2020-12-07 05:26:14 | Berlin, Germany | ||
1632212 | 1632212 | 2020-12-05 | Germany | Berlin | 69768 | 657 | 49705 | 20704 | 52.52 | 13.405 | 2020-12-06 05:26:18 | Berlin, Germany | ||
3859740 | 3859740 | 2020-12-04 | Germany | Berlin | 68508 | 641 | 49231 | 19880 | 52.52 | 13.405 | 2020-12-05 05:27:36 | Berlin, Germany | ||
74998 | 74998 | 2020-12-03 | Germany | Berlin | 67264 | 618 | 48499 | 19368 | 52.52 | 13.405 | 2020-12-04 05:27:27 | Berlin, Germany | ||
738210 | 738210 | 2020-12-02 | Germany | Berlin | 66306 | 594 | 47197 | 19449 | 52.52 | 13.405 | 2020-12-03 05:28:22 | Berlin, Germany | ||
2537304 | 2537304 | 2020-12-01 | Germany | Berlin | 65145 | 565 | 45910 | 19802 | 52.52 | 13.405 | 2020-12-02 05:27:41 | Berlin, Germany | ||
1584073 | 1584073 | 2020-11-30 | Germany | Berlin | 64220 | 553 | 44614 | 19966 | 52.52 | 13.405 | 2020-12-01 05:26:18 | Berlin, Germany | ||
3566476 | 3566476 | 2020-11-29 | Germany | Berlin | 63064 | 539 | 43227 | 20440 | 52.52 | 13.405 | 2020-11-30 05:26:13 | Berlin, Germany | ||
2935141 | 2935141 | 2020-11-28 | Germany | Berlin | 63064 | 539 | 41780 | 20745 | 52.52 | 13.405 | 2020-11-29 05:25:55 | Berlin, Germany | ||
392144 | 392144 | 2020-11-27 | Germany | Berlin | 61664 | 527 | 41246 | 21279 | 52.52 | 13.405 | 2020-11-28 05:25:50 | Berlin, Germany | ||
923591 | 923591 | 2020-11-26 | Germany | Berlin | 60554 | 508 | 40528 | 20609 | 52.52 | 13.405 | 2020-11-27 05:26:53 | Berlin, Germany | ||
1972496 | 1972496 | 2020-11-25 | Germany | Berlin | 58924 | 492 | 39260 | 20786 | 52.52 | 13.405 | 2020-11-26 05:27:44 | Berlin, Germany | ||
1350227 | 1350227 | 2020-11-24 | Germany | Berlin | 57309 | 456 | 38117 | 20315 | 52.52 | 13.405 | 2020-11-25 05:27:20 | Berlin, Germany | ||
678221 | 678221 | 2020-11-23 | Germany | Berlin | 56504 | 449 | 36876 | 19977 | 52.52 | 13.405 | 2020-11-24 05:27:31 | Berlin, Germany | ||
3189897 | 3189897 | 2020-11-22 | Germany | Berlin | 56068 | 447 | 35781 | 20274 | 52.52 | 13.405 | 2020-11-23 05:25:26 | Berlin, Germany | ||
3836391 | 3836391 | 2020-11-21 | Germany | Berlin | 55018 | 441 | 34803 | 20818 | 52.52 | 13.405 | 2020-11-22 05:25:45 | Berlin, Germany | ||
2701419 | 2701419 | 2020-11-20 | Germany | Berlin | 53315 | 422 | 33850 | 20727 | 52.52 | 13.405 | 2020-11-21 05:25:51 | Berlin, Germany | ||
821479 | 821479 | 2020-11-19 | Germany | Berlin | 52068 | 401 | 32827 | 20066 | 52.52 | 13.405 | 2020-11-20 05:26:28 | Berlin, Germany | ||
122613 | 122613 | 2020-11-18 | Germany | Berlin | 50611 | 394 | 31806 | 19861 | 52.52 | 13.405 | 2020-11-19 05:25:23 | Berlin, Germany | ||
3338501 | 3338501 | 2020-11-17 | Germany | Berlin | 49039 | 371 | 30940 | 19277 | 52.52 | 13.405 | 2020-11-18 05:40:31 | Berlin, Germany | ||
3169546 | 3169546 | 2020-11-16 | Germany | Berlin | 47697 | 363 | 29927 | 18741 | 52.52 | 13.405 | 2020-11-17 05:25:54 | Berlin, Germany | ||
2880114 | 2880114 | 2020-11-15 | Germany | Berlin | 47265 | 358 | 29700 | 17634 | 52.52 | 13.405 | 2020-11-16 05:25:57 | Berlin, Germany | ||
2915092 | 2915092 | 2020-11-14 | Germany | Berlin | 46434 | 348 | 28923 | 17984 | 52.52 | 13.405 | 2020-11-15 05:26:53 | Berlin, Germany |
Advanced export
JSON shape: default, array, newline-delimited
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]);