daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where province_or_state = "Berlin" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, day (date), last_update (date)
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-14 | Germany | Berlin | 6342 | 173 | 5737 | 479 | 52.52 | 13.405 | 2020-05-15 02:33:02 | Berlin, Germany | ||
2020-05-15 | Germany | Berlin | 6397 | 177 | 5787 | 456 | 52.52 | 13.405 | 2020-05-16 02:32:19 | Berlin, Germany | ||
2020-05-16 | Germany | Berlin | 6428 | 181 | 5825 | 437 | 52.52 | 13.405 | 2020-05-17 02:32:32 | Berlin, Germany | ||
2020-05-17 | Germany | Berlin | 6447 | 182 | 5850 | 422 | 52.52 | 13.405 | 2020-05-18 02:32:21 | Berlin, Germany | ||
2020-05-18 | Germany | Berlin | 6458 | 180 | 5880 | 412 | 52.52 | 13.405 | 2020-05-19 02:32:18 | Berlin, Germany | ||
2020-05-19 | Germany | Berlin | 6478 | 182 | 5918 | 399 | 52.52 | 13.405 | 2020-05-20 02:32:19 | Berlin, Germany | ||
2020-05-20 | Germany | Berlin | 6507 | 186 | 5959 | 407 | 52.52 | 13.405 | 2020-05-21 02:32:48 | Berlin, Germany | ||
2020-05-21 | Germany | Berlin | 6555 | 186 | 5987 | 405 | 52.52 | 13.405 | 2020-05-22 02:36:51 | Berlin, Germany | ||
2020-05-22 | Germany | Berlin | 6585 | 190 | 6018 | 403 | 52.52 | 13.405 | 2020-05-23 02:32:42 | Berlin, Germany | ||
2020-05-23 | Germany | Berlin | 6614 | 190 | 6049 | 396 | 52.52 | 13.405 | 2020-05-24 02:32:43 | Berlin, Germany | ||
2020-05-24 | Germany | Berlin | 6637 | 191 | 6060 | 390 | 52.52 | 13.405 | 2020-05-25 02:32:44 | Berlin, Germany | ||
2020-05-25 | Germany | Berlin | 6642 | 191 | 6086 | 374 | 52.52 | 13.405 | 2020-05-26 02:32:35 | Berlin, Germany | ||
2020-05-26 | Germany | Berlin | 6652 | 191 | 6123 | 356 | 52.52 | 13.405 | 2020-05-27 02:32:31 | Berlin, Germany | ||
2020-05-27 | Germany | Berlin | 6673 | 193 | 6175 | 334 | 52.52 | 13.405 | 2020-05-28 02:32:31 | Berlin, Germany | ||
2020-05-28 | Germany | Berlin | 6703 | 195 | 6208 | 333 | 52.52 | 13.405 | 2020-05-29 02:32:50 | Berlin, Germany | ||
2020-05-29 | Germany | Berlin | 6738 | 196 | 6240 | 329 | 52.52 | 13.405 | 2020-05-30 02:32:48 | Berlin, Germany | ||
2020-05-30 | Germany | Berlin | 6767 | 197 | 6259 | 342 | 52.52 | 13.405 | 2020-05-31 02:32:45 | Berlin, Germany | ||
2020-05-31 | Germany | Berlin | 6800 | 198 | 6279 | 338 | 52.52 | 13.405 | 2020-06-01 02:32:46 | Berlin, Germany | ||
2020-06-01 | Germany | Berlin | 6816 | 198 | 6319 | 321 | 52.52 | 13.405 | 2020-06-02 02:33:08 | Berlin, Germany | ||
2020-06-02 | Germany | Berlin | 6839 | 198 | 6358 | 317 | 52.52 | 13.405 | 2020-06-03 02:33:13 | Berlin, Germany | ||
2020-06-03 | Germany | Berlin | 6874 | 198 | 6388 | 312 | 52.52 | 13.405 | 2020-06-04 02:33:14 | Berlin, Germany | ||
2020-06-04 | Germany | Berlin | 6901 | 200 | 6412 | 333 | 52.52 | 13.405 | 2020-06-05 02:33:06 | Berlin, Germany | ||
2020-06-05 | Germany | Berlin | 6946 | 200 | 6443 | 319 | 52.52 | 13.405 | 2020-06-06 02:33:00 | Berlin, Germany | ||
2020-06-06 | Germany | Berlin | 6964 | 201 | 6455 | 336 | 52.52 | 13.405 | 2020-06-07 03:53:30 | Berlin, Germany | ||
2020-06-07 | Germany | Berlin | 6997 | 205 | 6470 | 340 | 52.52 | 13.405 | 2020-06-08 03:33:22 | Berlin, Germany | ||
2020-06-08 | Germany | Berlin | 7016 | 205 | 6495 | 341 | 52.52 | 13.405 | 2020-06-09 03:33:03 | Berlin, Germany | ||
2020-06-09 | Germany | Berlin | 7042 | 205 | 6531 | 344 | 52.52 | 13.405 | 2020-06-10 04:07:00 | Berlin, Germany | ||
2020-06-10 | Germany | Berlin | 7082 | 206 | 6559 | 368 | 52.52 | 13.405 | 2020-06-11 03:33:41 | Berlin, Germany | ||
2020-06-11 | Germany | Berlin | 7138 | 208 | 6582 | 374 | 52.52 | 13.405 | 2020-06-12 05:09:52 | Berlin, Germany | ||
2020-06-12 | Germany | Berlin | 7165 | 208 | 6582 | 461 | 52.52 | 13.405 | 2020-06-13 03:33:14 | Berlin, Germany | ||
2020-06-13 | Germany | Berlin | 7252 | 208 | 6627 | 446 | 52.52 | 13.405 | 2020-06-14 03:33:15 | Berlin, Germany | ||
2020-06-14 | Germany | Berlin | 7282 | 208 | 6656 | 457 | 52.52 | 13.405 | 2020-06-15 03:33:14 | Berlin, Germany | ||
2020-06-15 | Germany | Berlin | 7322 | 208 | 6685 | 475 | 52.52 | 13.405 | 2020-06-16 04:33:09 | Berlin, Germany | ||
2020-06-16 | Germany | Berlin | 7369 | 208 | 6725 | 467 | 52.52 | 13.405 | 2020-06-17 04:33:21 | Berlin, Germany | ||
2020-06-17 | Germany | Berlin | 7402 | 209 | 6778 | 486 | 52.52 | 13.405 | 2020-06-18 04:33:18 | Berlin, Germany | ||
2020-06-18 | Germany | Berlin | 7475 | 210 | 6806 | 585 | 52.52 | 13.405 | 2020-06-19 04:33:17 | Berlin, Germany | ||
2020-06-19 | Germany | Berlin | 7603 | 211 | 6850 | 671 | 52.52 | 13.405 | 2020-06-20 04:33:19 | Berlin, Germany | ||
2020-06-20 | Germany | Berlin | 7733 | 211 | 6874 | 718 | 52.52 | 13.405 | 2020-06-21 04:33:19 | Berlin, Germany | ||
2020-06-21 | Germany | Berlin | 7804 | 211 | 6886 | 735 | 52.52 | 13.405 | 2020-06-22 04:33:20 | Berlin, Germany | ||
2020-06-22 | Germany | Berlin | 7833 | 211 | 6920 | 784 | 52.52 | 13.405 | 2020-06-23 04:33:22 | Berlin, Germany | ||
2020-06-23 | Germany | Berlin | 7916 | 211 | 6961 | 802 | 52.52 | 13.405 | 2020-06-24 04:33:28 | Berlin, Germany | ||
2020-06-24 | Germany | Berlin | 7975 | 211 | 7032 | 776 | 52.52 | 13.405 | 2020-06-25 05:26:54 | Berlin, Germany | ||
2020-06-25 | Germany | Berlin | 8021 | 212 | 7081 | 802 | 52.52 | 13.405 | 2020-06-26 04:33:43 | Berlin, Germany | ||
2020-06-26 | Germany | Berlin | 8096 | 212 | 7125 | 806 | 52.52 | 13.405 | 2020-06-27 04:33:35 | Berlin, Germany | ||
2020-06-27 | Germany | Berlin | 8145 | 213 | 7196 | 758 | 52.52 | 13.405 | 2020-06-28 04:34:04 | Berlin, Germany | ||
2020-06-28 | Germany | Berlin | 8168 | 213 | 7217 | 745 | 52.52 | 13.405 | 2020-06-29 04:33:44 | Berlin, Germany | ||
2020-06-29 | Germany | Berlin | 8176 | 213 | 7272 | 733 | 52.52 | 13.405 | 2020-06-30 04:33:48 | Berlin, Germany | ||
2020-06-30 | Germany | Berlin | 8220 | 214 | 7349 | 679 | 52.52 | 13.405 | 2020-07-01 04:33:52 | Berlin, Germany | ||
2020-07-01 | Germany | Berlin | 8243 | 214 | 7433 | 654 | 52.52 | 13.405 | 2020-07-02 04:33:46 | Berlin, Germany | ||
2020-07-02 | Germany | Berlin | 8302 | 214 | 7515 | 615 | 52.52 | 13.405 | 2020-07-03 04:33:54 | Berlin, Germany | ||
2020-07-03 | Germany | Berlin | 8345 | 214 | 7612 | 566 | 52.52 | 13.405 | 2020-07-04 04:33:51 | Berlin, Germany | ||
2020-07-04 | Germany | Berlin | 8393 | 214 | 7646 | 572 | 52.52 | 13.405 | 2020-07-05 04:33:46 | Berlin, Germany | ||
2020-07-05 | Germany | Berlin | 8434 | 215 | 7670 | 565 | 52.52 | 13.405 | 2020-07-06 04:33:57 | Berlin, Germany | ||
2020-07-06 | Germany | Berlin | 8451 | 215 | 7738 | 508 | 52.52 | 13.405 | 2020-07-07 04:34:00 | Berlin, Germany | ||
2020-07-07 | Germany | Berlin | 8462 | 215 | 7783 | 503 | 52.52 | 13.405 | 2020-07-08 05:33:48 | Berlin, Germany | ||
2020-07-08 | Germany | Berlin | 8502 | 215 | 7828 | 493 | 52.52 | 13.405 | 2020-07-09 04:34:23 | Berlin, Germany | ||
2020-07-09 | Germany | Berlin | 8537 | 216 | 7896 | 473 | 52.52 | 13.405 | 2020-07-10 04:34:24 | Berlin, Germany | ||
2020-07-10 | Germany | Berlin | 8586 | 216 | 7938 | 462 | 52.52 | 13.405 | 2020-07-11 04:34:26 | Berlin, Germany | ||
2020-07-11 | Germany | Berlin | 8617 | 216 | 7967 | 452 | 52.52 | 13.405 | 2020-07-12 04:34:30 | Berlin, Germany | ||
2020-07-12 | Germany | Berlin | 8637 | 217 | 7995 | 425 | 52.52 | 13.405 | 2020-07-13 04:43:04 | Berlin, Germany | ||
2020-07-13 | Germany | Berlin | 8638 | 217 | 8036 | 400 | 52.52 | 13.405 | 2020-07-14 04:34:46 | Berlin, Germany | ||
2020-07-14 | Germany | Berlin | 8656 | 219 | 8069 | 384 | 52.52 | 13.405 | 2020-07-15 04:34:39 | Berlin, Germany | ||
2020-07-15 | Germany | Berlin | 8674 | 220 | 8114 | 363 | 52.52 | 13.405 | 2020-07-16 04:44:59 | Berlin, Germany | ||
2020-07-16 | Germany | Berlin | 8699 | 221 | 8169 | 334 | 52.52 | 13.405 | 2020-07-17 04:34:50 | Berlin, Germany | ||
2020-07-17 | Germany | Berlin | 8725 | 221 | 8199 | 327 | 52.52 | 13.405 | 2020-07-18 04:34:45 | Berlin, Germany | ||
2020-07-18 | Germany | Berlin | 8748 | 221 | 8235 | 316 | 52.52 | 13.405 | 2020-07-19 04:34:58 | Berlin, Germany | ||
2020-07-19 | Germany | Berlin | 8774 | 221 | 8250 | 307 | 52.52 | 13.405 | 2020-07-20 05:34:40 | Berlin, Germany | ||
2020-07-20 | Germany | Berlin | 8779 | 221 | 8283 | 297 | 52.52 | 13.405 | 2020-07-21 04:38:46 | Berlin, Germany | ||
2020-07-21 | Germany | Berlin | 8802 | 221 | 8312 | 302 | 52.52 | 13.405 | 2020-07-22 04:34:42 | Berlin, Germany | ||
2020-07-22 | Germany | Berlin | 8837 | 222 | 8356 | 281 | 52.52 | 13.405 | 2020-07-23 05:15:04 | Berlin, Germany | ||
2020-07-23 | Germany | Berlin | 8860 | 222 | 8386 | 285 | 52.52 | 13.405 | 2020-07-24 05:30:40 | Berlin, Germany | ||
2020-07-24 | Germany | Berlin | 8894 | 222 | 8418 | 315 | 52.52 | 13.405 | 2020-07-25 04:47:39 | Berlin, Germany | ||
2020-07-25 | Germany | Berlin | 8957 | 223 | 8429 | 338 | 52.52 | 13.405 | 2020-07-26 04:35:00 | Berlin, Germany | ||
2020-07-26 | Germany | Berlin | 8991 | 223 | 8450 | 327 | 52.52 | 13.405 | 2020-07-27 04:35:02 | Berlin, Germany | ||
2020-07-27 | Germany | Berlin | 9001 | 223 | 8482 | 314 | 52.52 | 13.405 | 2020-07-28 04:58:43 | Berlin, Germany | ||
2020-07-28 | Germany | Berlin | 9020 | 223 | 8514 | 333 | 52.52 | 13.405 | 2020-07-29 04:35:11 | Berlin, Germany | ||
2020-07-29 | Germany | Berlin | 9071 | 223 | 8542 | 384 | 52.52 | 13.405 | 2020-07-30 04:35:05 | Berlin, Germany | ||
2020-07-30 | Germany | Berlin | 9150 | 223 | 8572 | 396 | 52.52 | 13.405 | 2020-07-31 04:35:18 | Berlin, Germany | ||
2020-07-31 | Germany | Berlin | 9192 | 223 | 8590 | 460 | 52.52 | 13.405 | 2020-08-01 04:36:27 | Berlin, Germany | ||
2020-08-01 | Germany | Berlin | 9274 | 223 | 8627 | 468 | 52.52 | 13.405 | 2020-08-02 04:34:47 | Berlin, Germany | ||
2020-08-02 | Germany | Berlin | 9319 | 223 | 8658 | 446 | 52.52 | 13.405 | 2020-08-03 04:34:35 | Berlin, Germany | ||
2020-08-03 | Germany | Berlin | 9328 | 223 | 8705 | 438 | 52.52 | 13.405 | 2020-08-04 04:41:59 | Berlin, Germany | ||
2020-08-04 | Germany | Berlin | 9367 | 223 | 8748 | 427 | 52.52 | 13.405 | 2020-08-05 04:34:43 | Berlin, Germany | ||
2020-08-05 | Germany | Berlin | 9399 | 223 | 8800 | 465 | 52.52 | 13.405 | 2020-08-06 04:35:02 | Berlin, Germany | ||
2020-08-06 | Germany | Berlin | 9490 | 224 | 8857 | 461 | 52.52 | 13.405 | 2020-08-07 04:35:11 | Berlin, Germany | ||
2020-08-07 | Germany | Berlin | 9543 | 224 | 8888 | 527 | 52.52 | 13.405 | 2020-08-08 04:34:53 | Berlin, Germany | ||
2020-08-08 | Germany | Berlin | 9640 | 224 | 8908 | 555 | 52.52 | 13.405 | 2020-08-09 04:34:54 | Berlin, Germany | ||
2020-08-09 | Germany | Berlin | 9688 | 224 | 8936 | 537 | 52.52 | 13.405 | 2020-08-10 04:34:55 | Berlin, Germany | ||
2020-08-10 | Germany | Berlin | 9698 | 224 | 8984 | 531 | 52.52 | 13.405 | 2020-08-11 04:35:08 | Berlin, Germany | ||
2020-08-11 | Germany | Berlin | 9740 | 224 | 9035 | 591 | 52.52 | 13.405 | 2020-08-12 04:27:29 | Berlin, Germany | ||
2020-08-12 | Germany | Berlin | 9851 | 224 | 9088 | 663 | 52.52 | 13.405 | 2020-08-13 04:29:15 | Berlin, Germany | ||
2020-08-13 | Germany | Berlin | 9976 | 224 | 9132 | 750 | 52.52 | 13.405 | 2020-08-14 04:51:19 | Berlin, Germany | ||
2020-08-14 | Germany | Berlin | 9976 | 224 | 9193 | 778 | 52.52 | 13.405 | 2020-08-15 04:27:31 | Berlin, Germany | ||
2020-08-15 | Germany | Berlin | 10196 | 224 | 9239 | 774 | 52.52 | 13.405 | 2020-08-16 04:27:42 | Berlin, Germany | ||
2020-08-16 | Germany | Berlin | 10238 | 224 | 9273 | 755 | 52.52 | 13.405 | 2020-08-17 04:27:20 | Berlin, Germany | ||
2020-08-17 | Germany | Berlin | 10253 | 224 | 9322 | 772 | 52.52 | 13.405 | 2020-08-18 04:27:56 | Berlin, Germany | ||
2020-08-18 | Germany | Berlin | 10319 | 224 | 9376 | 793 | 52.52 | 13.405 | 2020-08-19 04:27:00 | Berlin, Germany | ||
2020-08-19 | Germany | Berlin | 10394 | 224 | 9442 | 796 | 52.52 | 13.405 | 2020-08-20 04:27:43 | Berlin, Germany | ||
2020-08-20 | Germany | Berlin | 10463 | 224 | 9513 | 803 | 52.52 | 13.405 | 2020-08-21 04:27:41 | Berlin, Germany | ||
2020-08-21 | Germany | Berlin | 10543 | 226 | 9609 | 819 | 52.52 | 13.405 | 2020-08-22 04:27:49 | Berlin, Germany |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;