daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Germany" and province_or_state = "Nordrhein-Westfalen" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-06-15 | Germany | Nordrhein-Westfalen | 813572 | 16995 | 787100 | 9770 | 51.4332 | 7.6616 | 2021-06-16 04:22:32 | Nordrhein-Westfalen, Germany | ||
2021-06-16 | Germany | Nordrhein-Westfalen | 813878 | 17008 | 787700 | 9392 | 51.4332 | 7.6616 | 2021-06-17 04:22:36 | Nordrhein-Westfalen, Germany | ||
2020-10-09 | Germany | Nordrhein-Westfalen | 76796 | 1900 | 66256 | 8639 | 51.4332 | 7.6616 | 2020-10-10 04:23:57 | Nordrhein-Westfalen, Germany | ||
2020-10-07 | Germany | Nordrhein-Westfalen | 74615 | 1891 | 65151 | 8626 | 51.4332 | 7.6616 | 2020-10-08 04:23:56 | Nordrhein-Westfalen, Germany | ||
2021-08-04 | Germany | Nordrhein-Westfalen | 829571 | 17297 | 804900 | 8448 | 51.4332 | 7.6616 | 2021-08-05 04:21:51 | Nordrhein-Westfalen, Germany | ||
2021-06-17 | Germany | Nordrhein-Westfalen | 814114 | 17022 | 789100 | 8254 | 51.4332 | 7.6616 | 2021-06-18 04:22:16 | Nordrhein-Westfalen, Germany | ||
2020-10-06 | Germany | Nordrhein-Westfalen | 73842 | 1886 | 64624 | 8100 | 51.4332 | 7.6616 | 2020-10-07 04:23:40 | Nordrhein-Westfalen, Germany | ||
2020-10-08 | Germany | Nordrhein-Westfalen | 75671 | 1894 | 65752 | 8023 | 51.4332 | 7.6616 | 2020-10-09 04:23:59 | Nordrhein-Westfalen, Germany | ||
2020-10-05 | Germany | Nordrhein-Westfalen | 72995 | 1884 | 64068 | 7888 | 51.4332 | 7.6616 | 2020-10-06 04:23:33 | Nordrhein-Westfalen, Germany | ||
2021-08-03 | Germany | Nordrhein-Westfalen | 828457 | 17296 | 804400 | 7874 | 51.4332 | 7.6616 | 2021-08-04 04:21:25 | Nordrhein-Westfalen, Germany | ||
2021-06-18 | Germany | Nordrhein-Westfalen | 814384 | 17030 | 789800 | 7762 | 51.4332 | 7.6616 | 2021-06-19 04:22:33 | Nordrhein-Westfalen, Germany | ||
2020-11-20 | Germany | Nordrhein-Westfalen | 222535 | 2887 | 148023 | 76817 | 51.4332 | 7.6616 | 2020-11-21 05:25:51 | Nordrhein-Westfalen, Germany | ||
2021-06-19 | Germany | Nordrhein-Westfalen | 814384 | 17030 | 790100 | 7679 | 51.4332 | 7.6616 | 2021-06-20 04:21:48 | Nordrhein-Westfalen, Germany | ||
2020-11-21 | Germany | Nordrhein-Westfalen | 227783 | 2943 | 151513 | 76507 | 51.4332 | 7.6616 | 2020-11-22 05:25:45 | Nordrhein-Westfalen, Germany | ||
2020-10-04 | Germany | Nordrhein-Westfalen | 72581 | 1884 | 63082 | 7615 | 51.4332 | 7.6616 | 2020-10-05 04:23:33 | Nordrhein-Westfalen, Germany | ||
2020-11-19 | Germany | Nordrhein-Westfalen | 216809 | 2819 | 143888 | 75760 | 51.4332 | 7.6616 | 2020-11-20 05:26:28 | Nordrhein-Westfalen, Germany | ||
2021-04-29 | Germany | Nordrhein-Westfalen | 730086 | 15435 | 644600 | 75622 | 51.4332 | 7.6616 | 2021-04-30 04:21:03 | Nordrhein-Westfalen, Germany | ||
2020-11-22 | Germany | Nordrhein-Westfalen | 230976 | 2956 | 154562 | 75481 | 51.4332 | 7.6616 | 2020-11-23 05:25:26 | Nordrhein-Westfalen, Germany | ||
2020-11-23 | Germany | Nordrhein-Westfalen | 233020 | 2977 | 158342 | 75417 | 51.4332 | 7.6616 | 2020-11-24 05:27:31 | Nordrhein-Westfalen, Germany | ||
2021-04-30 | Germany | Nordrhein-Westfalen | 735731 | 15509 | 649200 | 75337 | 51.4332 | 7.6616 | 2021-05-01 04:20:47 | Nordrhein-Westfalen, Germany | ||
2021-05-01 | Germany | Nordrhein-Westfalen | 740088 | 15551 | 653100 | 75241 | 51.4332 | 7.6616 | 2021-05-02 04:20:48 | Nordrhein-Westfalen, Germany | ||
2021-04-28 | Germany | Nordrhein-Westfalen | 724667 | 15375 | 639800 | 74851 | 51.4332 | 7.6616 | 2021-04-29 04:20:55 | Nordrhein-Westfalen, Germany | ||
2020-11-24 | Germany | Nordrhein-Westfalen | 236806 | 3047 | 163057 | 74779 | 51.4332 | 7.6616 | 2020-11-25 05:27:20 | Nordrhein-Westfalen, Germany | ||
2020-11-25 | Germany | Nordrhein-Westfalen | 240962 | 3126 | 167999 | 74662 | 51.4332 | 7.6616 | 2020-11-26 05:27:44 | Nordrhein-Westfalen, Germany | ||
2020-11-26 | Germany | Nordrhein-Westfalen | 245871 | 3210 | 173105 | 74473 | 51.4332 | 7.6616 | 2020-11-27 05:26:53 | Nordrhein-Westfalen, Germany | ||
2021-06-20 | Germany | Nordrhein-Westfalen | 814823 | 17044 | 790400 | 7445 | 51.4332 | 7.6616 | 2021-06-21 04:21:41 | Nordrhein-Westfalen, Germany | ||
2020-12-23 | Germany | Nordrhein-Westfalen | 362430 | 5608 | 289063 | 74217 | 51.4332 | 7.6616 | 2020-12-24 05:23:04 | Nordrhein-Westfalen, Germany | ||
2020-11-18 | Germany | Nordrhein-Westfalen | 211380 | 2766 | 139851 | 74139 | 51.4332 | 7.6616 | 2020-11-19 05:25:23 | Nordrhein-Westfalen, Germany | ||
2021-04-23 | Germany | Nordrhein-Westfalen | 703887 | 15159 | 620400 | 73921 | 51.4332 | 7.6616 | 2021-04-24 04:20:38 | Nordrhein-Westfalen, Germany | ||
2020-10-03 | Germany | Nordrhein-Westfalen | 72063 | 1882 | 62792 | 7389 | 51.4332 | 7.6616 | 2020-10-04 04:23:44 | Nordrhein-Westfalen, Germany | ||
2020-12-24 | Germany | Nordrhein-Westfalen | 369058 | 5778 | 293690 | 73773 | 51.4332 | 7.6616 | 2020-12-25 05:22:48 | Nordrhein-Westfalen, Germany | ||
2020-12-19 | Germany | Nordrhein-Westfalen | 345186 | 5177 | 270511 | 73743 | 51.4332 | 7.6616 | 2020-12-20 05:27:32 | Nordrhein-Westfalen, Germany | ||
2021-08-02 | Germany | Nordrhein-Westfalen | 827847 | 17292 | 803800 | 7361 | 51.4332 | 7.6616 | 2021-08-03 04:21:39 | Nordrhein-Westfalen, Germany | ||
2020-11-27 | Germany | Nordrhein-Westfalen | 250884 | 3306 | 178315 | 73420 | 51.4332 | 7.6616 | 2020-11-28 05:25:50 | Nordrhein-Westfalen, Germany | ||
2020-12-22 | Germany | Nordrhein-Westfalen | 357298 | 5425 | 283693 | 73129 | 51.4332 | 7.6616 | 2020-12-23 05:22:03 | Nordrhein-Westfalen, Germany | ||
2021-05-03 | Germany | Nordrhein-Westfalen | 746246 | 15593 | 659700 | 73066 | 51.4332 | 7.6616 | 2021-05-04 04:20:34 | Nordrhein-Westfalen, Germany | ||
2020-12-21 | Germany | Nordrhein-Westfalen | 352719 | 5245 | 278868 | 73005 | 51.4332 | 7.6616 | 2020-12-22 05:22:33 | Nordrhein-Westfalen, Germany | ||
2020-12-20 | Germany | Nordrhein-Westfalen | 349463 | 5209 | 274530 | 72944 | 51.4332 | 7.6616 | 2020-12-21 05:27:58 | Nordrhein-Westfalen, Germany | ||
2020-11-17 | Germany | Nordrhein-Westfalen | 207224 | 2700 | 135693 | 72921 | 51.4332 | 7.6616 | 2020-11-18 05:40:31 | Nordrhein-Westfalen, Germany | ||
2020-11-28 | Germany | Nordrhein-Westfalen | 255115 | 3380 | 182205 | 72767 | 51.4332 | 7.6616 | 2020-11-29 05:25:55 | Nordrhein-Westfalen, Germany | ||
2020-11-16 | Germany | Nordrhein-Westfalen | 202817 | 2637 | 131792 | 72732 | 51.4332 | 7.6616 | 2020-11-17 05:25:54 | Nordrhein-Westfalen, Germany | ||
2020-12-25 | Germany | Nordrhein-Westfalen | 369058 | 5778 | 297114 | 72712 | 51.4332 | 7.6616 | 2020-12-26 05:22:28 | Nordrhein-Westfalen, Germany | ||
2021-04-24 | Germany | Nordrhein-Westfalen | 709522 | 15201 | 626500 | 72642 | 51.4332 | 7.6616 | 2021-04-25 04:20:32 | Nordrhein-Westfalen, Germany | ||
2021-04-22 | Germany | Nordrhein-Westfalen | 696949 | 15116 | 616200 | 72528 | 51.4332 | 7.6616 | 2021-04-23 04:20:52 | Nordrhein-Westfalen, Germany | ||
2020-12-26 | Germany | Nordrhein-Westfalen | 375714 | 5888 | 299683 | 72458 | 51.4332 | 7.6616 | 2020-12-27 05:22:55 | Nordrhein-Westfalen, Germany | ||
2021-05-04 | Germany | Nordrhein-Westfalen | 748455 | 15689 | 664500 | 72251 | 51.4332 | 7.6616 | 2021-05-05 04:20:43 | Nordrhein-Westfalen, Germany | ||
2020-12-31 | Germany | Nordrhein-Westfalen | 393185 | 6552 | 318212 | 72036 | 51.4332 | 7.6616 | 2021-01-01 05:23:07 | Nordrhein-Westfalen, Germany | ||
2020-11-29 | Germany | Nordrhein-Westfalen | 258390 | 3418 | 185347 | 71864 | 51.4332 | 7.6616 | 2020-11-30 05:26:13 | Nordrhein-Westfalen, Germany | ||
2020-12-18 | Germany | Nordrhein-Westfalen | 339176 | 5075 | 268153 | 71856 | 51.4332 | 7.6616 | 2020-12-19 05:27:52 | Nordrhein-Westfalen, Germany | ||
2020-11-15 | Germany | Nordrhein-Westfalen | 200063 | 2623 | 128399 | 71781 | 51.4332 | 7.6616 | 2020-11-16 05:25:57 | Nordrhein-Westfalen, Germany | ||
2020-11-14 | Germany | Nordrhein-Westfalen | 196363 | 2616 | 125857 | 71583 | 51.4332 | 7.6616 | 2020-11-15 05:26:53 | Nordrhein-Westfalen, Germany | ||
2021-04-25 | Germany | Nordrhein-Westfalen | 714360 | 15218 | 630100 | 71542 | 51.4332 | 7.6616 | 2021-04-26 04:21:04 | Nordrhein-Westfalen, Germany | ||
2020-11-13 | Germany | Nordrhein-Westfalen | 191011 | 2581 | 122653 | 71094 | 51.4332 | 7.6616 | 2020-11-14 05:25:37 | Nordrhein-Westfalen, Germany | ||
2021-05-02 | Germany | Nordrhein-Westfalen | 743916 | 15575 | 659700 | 70953 | 51.4332 | 7.6616 | 2021-05-03 04:20:39 | Nordrhein-Westfalen, Germany | ||
2020-12-27 | Germany | Nordrhein-Westfalen | 378105 | 5964 | 303674 | 70747 | 51.4332 | 7.6616 | 2020-12-28 05:22:06 | Nordrhein-Westfalen, Germany | ||
2020-11-30 | Germany | Nordrhein-Westfalen | 260646 | 3435 | 189636 | 70564 | 51.4332 | 7.6616 | 2020-12-01 05:26:18 | Nordrhein-Westfalen, Germany | ||
2021-07-31 | Germany | Nordrhein-Westfalen | 826173 | 17291 | 803300 | 7011 | 51.4332 | 7.6616 | 2021-08-01 04:21:50 | Nordrhein-Westfalen, Germany | ||
2021-06-21 | Germany | Nordrhein-Westfalen | 814893 | 17048 | 790900 | 6999 | 51.4332 | 7.6616 | 2021-06-22 04:21:34 | Nordrhein-Westfalen, Germany | ||
2021-04-26 | Germany | Nordrhein-Westfalen | 716866 | 15224 | 634700 | 69831 | 51.4332 | 7.6616 | 2021-04-27 04:20:52 | Nordrhein-Westfalen, Germany | ||
2020-11-12 | Germany | Nordrhein-Westfalen | 185138 | 2517 | 118827 | 69603 | 51.4332 | 7.6616 | 2020-11-13 05:25:30 | Nordrhein-Westfalen, Germany | ||
2021-04-27 | Germany | Nordrhein-Westfalen | 719818 | 15287 | 639800 | 69492 | 51.4332 | 7.6616 | 2021-04-28 04:20:32 | Nordrhein-Westfalen, Germany | ||
2020-10-02 | Germany | Nordrhein-Westfalen | 71357 | 1879 | 62530 | 6947 | 51.4332 | 7.6616 | 2020-10-03 04:23:40 | Nordrhein-Westfalen, Germany | ||
2021-05-07 | Germany | Nordrhein-Westfalen | 761517 | 15863 | 679800 | 69336 | 51.4332 | 7.6616 | 2021-05-08 04:21:04 | Nordrhein-Westfalen, Germany | ||
2020-12-17 | Germany | Nordrhein-Westfalen | 332684 | 4927 | 264825 | 69276 | 51.4332 | 7.6616 | 2020-12-18 05:28:18 | Nordrhein-Westfalen, Germany | ||
2020-12-01 | Germany | Nordrhein-Westfalen | 263715 | 3515 | 194490 | 68958 | 51.4332 | 7.6616 | 2020-12-02 05:27:41 | Nordrhein-Westfalen, Germany | ||
2020-12-02 | Germany | Nordrhein-Westfalen | 267069 | 3621 | 199410 | 68895 | 51.4332 | 7.6616 | 2020-12-03 05:28:22 | Nordrhein-Westfalen, Germany | ||
2020-12-03 | Germany | Nordrhein-Westfalen | 272026 | 3721 | 204396 | 68507 | 51.4332 | 7.6616 | 2020-12-04 05:27:27 | Nordrhein-Westfalen, Germany | ||
2020-12-28 | Germany | Nordrhein-Westfalen | 380487 | 6066 | 308312 | 68469 | 51.4332 | 7.6616 | 2020-12-29 05:22:37 | Nordrhein-Westfalen, Germany | ||
2020-12-30 | Germany | Nordrhein-Westfalen | 387437 | 6451 | 318212 | 68371 | 51.4332 | 7.6616 | 2020-12-31 05:22:49 | Nordrhein-Westfalen, Germany | ||
2021-05-08 | Germany | Nordrhein-Westfalen | 765050 | 15914 | 683900 | 68367 | 51.4332 | 7.6616 | 2021-05-09 04:20:35 | Nordrhein-Westfalen, Germany | ||
2020-12-04 | Germany | Nordrhein-Westfalen | 276697 | 3793 | 209300 | 68299 | 51.4332 | 7.6616 | 2020-12-05 05:27:36 | Nordrhein-Westfalen, Germany | ||
2020-12-29 | Germany | Nordrhein-Westfalen | 383008 | 6227 | 313172 | 67814 | 51.4332 | 7.6616 | 2020-12-30 05:22:34 | Nordrhein-Westfalen, Germany | ||
2020-12-12 | Germany | Nordrhein-Westfalen | 310932 | 4422 | 242720 | 67762 | 51.4332 | 7.6616 | 2020-12-13 05:27:20 | Nordrhein-Westfalen, Germany | ||
2021-08-01 | Germany | Nordrhein-Westfalen | 826173 | 17291 | 803800 | 6755 | 51.4332 | 7.6616 | 2021-08-02 04:21:36 | Nordrhein-Westfalen, Germany | ||
2020-12-16 | Germany | Nordrhein-Westfalen | 326681 | 4786 | 260253 | 67504 | 51.4332 | 7.6616 | 2020-12-17 05:28:12 | Nordrhein-Westfalen, Germany | ||
2020-11-11 | Germany | Nordrhein-Westfalen | 180523 | 2465 | 115152 | 67469 | 51.4332 | 7.6616 | 2020-11-12 05:25:55 | Nordrhein-Westfalen, Germany | ||
2020-12-13 | Germany | Nordrhein-Westfalen | 314937 | 4455 | 246364 | 67113 | 51.4332 | 7.6616 | 2020-12-14 05:26:27 | Nordrhein-Westfalen, Germany | ||
2020-12-14 | Germany | Nordrhein-Westfalen | 317966 | 4489 | 250551 | 66885 | 51.4332 | 7.6616 | 2020-12-15 05:26:38 | Nordrhein-Westfalen, Germany | ||
2020-12-15 | Germany | Nordrhein-Westfalen | 322051 | 4615 | 255063 | 66832 | 51.4332 | 7.6616 | 2020-12-16 05:28:04 | Nordrhein-Westfalen, Germany | ||
2020-11-10 | Germany | Nordrhein-Westfalen | 175951 | 2395 | 111342 | 66716 | 51.4332 | 7.6616 | 2020-11-11 05:25:30 | Nordrhein-Westfalen, Germany | ||
2021-05-05 | Germany | Nordrhein-Westfalen | 752510 | 15759 | 675000 | 66615 | 51.4332 | 7.6616 | 2021-05-06 04:20:38 | Nordrhein-Westfalen, Germany | ||
2020-12-11 | Germany | Nordrhein-Westfalen | 305464 | 4346 | 240428 | 66082 | 51.4332 | 7.6616 | 2020-12-12 05:26:19 | Nordrhein-Westfalen, Germany | ||
2021-05-06 | Germany | Nordrhein-Westfalen | 757423 | 15808 | 679800 | 65854 | 51.4332 | 7.6616 | 2021-05-07 04:20:40 | Nordrhein-Westfalen, Germany | ||
2021-01-01 | Germany | Nordrhein-Westfalen | 393185 | 6552 | 326307 | 65670 | 51.4332 | 7.6616 | 2021-01-02 05:22:33 | Nordrhein-Westfalen, Germany | ||
2021-04-21 | Germany | Nordrhein-Westfalen | 690253 | 15057 | 616200 | 65633 | 51.4332 | 7.6616 | 2021-04-22 04:20:53 | Nordrhein-Westfalen, Germany | ||
2020-12-05 | Germany | Nordrhein-Westfalen | 281492 | 3892 | 215744 | 65147 | 51.4332 | 7.6616 | 2020-12-06 05:26:18 | Nordrhein-Westfalen, Germany | ||
2021-01-02 | Germany | Nordrhein-Westfalen | 398678 | 6701 | 328729 | 65114 | 51.4332 | 7.6616 | 2021-01-03 05:22:52 | Nordrhein-Westfalen, Germany | ||
2021-05-10 | Germany | Nordrhein-Westfalen | 769889 | 15943 | 690300 | 64968 | 51.4332 | 7.6616 | 2021-05-11 04:20:41 | Nordrhein-Westfalen, Germany | ||
2021-06-22 | Germany | Nordrhein-Westfalen | 814963 | 17064 | 791600 | 6447 | 51.4332 | 7.6616 | 2021-06-23 04:21:46 | Nordrhein-Westfalen, Germany | ||
2020-12-10 | Germany | Nordrhein-Westfalen | 298431 | 4226 | 237134 | 63984 | 51.4332 | 7.6616 | 2020-12-11 05:26:59 | Nordrhein-Westfalen, Germany | ||
2021-07-30 | Germany | Nordrhein-Westfalen | 826173 | 17291 | 803200 | 6389 | 51.4332 | 7.6616 | 2021-07-31 04:21:35 | Nordrhein-Westfalen, Germany | ||
2021-05-09 | Germany | Nordrhein-Westfalen | 768194 | 15927 | 690300 | 63646 | 51.4332 | 7.6616 | 2021-05-10 04:20:38 | Nordrhein-Westfalen, Germany | ||
2021-01-09 | Germany | Nordrhein-Westfalen | 424492 | 7866 | 356170 | 63598 | 51.4332 | 7.6616 | 2021-01-10 05:22:12 | Nordrhein-Westfalen, Germany | ||
2020-10-01 | Germany | Nordrhein-Westfalen | 70580 | 1880 | 62341 | 6359 | 51.4332 | 7.6616 | 2020-10-02 04:23:51 | Nordrhein-Westfalen, Germany | ||
2021-04-20 | Germany | Nordrhein-Westfalen | 684238 | 14974 | 611700 | 63496 | 51.4332 | 7.6616 | 2021-04-21 04:21:14 | Nordrhein-Westfalen, Germany | ||
2020-12-06 | Germany | Nordrhein-Westfalen | 284816 | 3924 | 219774 | 63450 | 51.4332 | 7.6616 | 2020-12-07 05:26:14 | Nordrhein-Westfalen, Germany | ||
2020-11-08 | Germany | Nordrhein-Westfalen | 168205 | 2341 | 105872 | 63404 | 51.4332 | 7.6616 | 2020-11-09 05:25:45 | Nordrhein-Westfalen, Germany | ||
2021-04-18 | Germany | Nordrhein-Westfalen | 679133 | 14868 | 603900 | 63174 | 51.4332 | 7.6616 | 2021-04-19 04:20:57 | Nordrhein-Westfalen, Germany | ||
2021-04-16 | Germany | Nordrhein-Westfalen | 669472 | 14813 | 596700 | 63141 | 51.4332 | 7.6616 | 2021-04-17 04:20:40 | Nordrhein-Westfalen, Germany | ||
2021-01-03 | Germany | Nordrhein-Westfalen | 400594 | 6751 | 332584 | 63115 | 51.4332 | 7.6616 | 2021-01-04 05:22:02 | Nordrhein-Westfalen, Germany |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;