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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026261 | 1026261 | 2020-10-17 | Germany | Berlin | 20764 | 240 | 16065 | 4822 | 52.52 | 13.405 | 2020-10-18 04:24:25 | Berlin, Germany | ||
2856756 | 2856756 | 2020-10-16 | Germany | Berlin | 20088 | 239 | 15850 | 4674 | 52.52 | 13.405 | 2020-10-17 04:24:12 | Berlin, Germany | ||
786286 | 786286 | 2020-10-15 | Germany | Berlin | 19537 | 237 | 15652 | 4197 | 52.52 | 13.405 | 2020-10-16 04:24:01 | Berlin, Germany | ||
78997 | 78997 | 2020-10-14 | Germany | Berlin | 19033 | 237 | 15341 | 3959 | 52.52 | 13.405 | 2020-10-15 04:24:28 | Berlin, Germany | ||
3781812 | 3781812 | 2020-10-13 | Germany | Berlin | 18327 | 234 | 15077 | 3719 | 52.52 | 13.405 | 2020-10-14 04:24:05 | Berlin, Germany | ||
2291352 | 2291352 | 2020-10-12 | Germany | Berlin | 18075 | 234 | 14847 | 3246 | 52.52 | 13.405 | 2020-10-13 04:24:02 | Berlin, Germany | ||
3785805 | 3785805 | 2020-10-11 | Germany | Berlin | 17828 | 234 | 14622 | 3219 | 52.52 | 13.405 | 2020-10-12 04:23:45 | Berlin, Germany | ||
2601943 | 2601943 | 2020-10-10 | Germany | Berlin | 17555 | 234 | 14375 | 3219 | 52.52 | 13.405 | 2020-10-11 04:23:46 | Berlin, Germany | ||
817476 | 817476 | 2020-10-09 | Germany | Berlin | 17112 | 233 | 14257 | 3064 | 52.52 | 13.405 | 2020-10-10 04:23:57 | Berlin, Germany | ||
2689591 | 2689591 | 2020-10-08 | Germany | Berlin | 16615 | 232 | 14106 | 2773 | 52.52 | 13.405 | 2020-10-09 04:23:59 | Berlin, Germany | ||
1041733 | 1041733 | 2020-10-07 | Germany | Berlin | 16237 | 231 | 13901 | 2482 | 52.52 | 13.405 | 2020-10-08 04:23:56 | Berlin, Germany | ||
3117394 | 3117394 | 2020-10-06 | Germany | Berlin | 15949 | 231 | 13726 | 2280 | 52.52 | 13.405 | 2020-10-07 04:23:40 | Berlin, Germany | ||
3801806 | 3801806 | 2020-10-05 | Germany | Berlin | 15648 | 231 | 13557 | 2161 | 52.52 | 13.405 | 2020-10-06 04:23:33 | Berlin, Germany | ||
1822696 | 1822696 | 2020-10-04 | Germany | Berlin | 15574 | 231 | 13270 | 2146 | 52.52 | 13.405 | 2020-10-05 04:23:33 | Berlin, Germany | ||
2514080 | 2514080 | 2020-10-03 | Germany | Berlin | 15371 | 231 | 13168 | 2174 | 52.52 | 13.405 | 2020-10-04 04:23:44 | Berlin, Germany | ||
3389298 | 3389298 | 2020-10-02 | Germany | Berlin | 15032 | 229 | 13060 | 2079 | 52.52 | 13.405 | 2020-10-03 04:23:40 | Berlin, Germany | ||
2379539 | 2379539 | 2020-10-01 | Germany | Berlin | 14788 | 228 | 12888 | 1914 | 52.52 | 13.405 | 2020-10-02 04:23:51 | Berlin, Germany | ||
1045725 | 1045725 | 2020-09-30 | Germany | Berlin | 14500 | 228 | 12751 | 1808 | 52.52 | 13.405 | 2020-10-01 04:23:42 | Berlin, Germany | ||
966806 | 966806 | 2020-09-29 | Germany | Berlin | 14327 | 228 | 12595 | 1676 | 52.52 | 13.405 | 2020-09-30 04:23:33 | Berlin, Germany | ||
1515303 | 1515303 | 2020-09-28 | Germany | Berlin | 14196 | 228 | 12457 | 1641 | 52.52 | 13.405 | 2020-09-29 04:23:42 | Berlin, Germany | ||
2581891 | 2581891 | 2020-09-27 | Germany | Berlin | 14113 | 228 | 12307 | 1660 | 52.52 | 13.405 | 2020-09-28 04:23:00 | Berlin, Germany | ||
2613943 | 2613943 | 2020-09-26 | Germany | Berlin | 13970 | 228 | 12242 | 1642 | 52.52 | 13.405 | 2020-09-27 04:23:00 | Berlin, Germany | ||
2812658 | 2812658 | 2020-09-25 | Germany | Berlin | 13811 | 228 | 12176 | 1565 | 52.52 | 13.405 | 2020-09-26 04:23:00 | Berlin, Germany | ||
2605935 | 2605935 | 2020-09-24 | Germany | Berlin | 13573 | 228 | 12061 | 1521 | 52.52 | 13.405 | 2020-09-25 04:23:00 | Berlin, Germany | ||
2653678 | 2653678 | 2020-09-23 | Germany | Berlin | 13374 | 228 | 11935 | 1409 | 52.52 | 13.405 | 2020-09-24 04:23:00 | Berlin, Germany | ||
3316127 | 3316127 | 2020-09-22 | Germany | Berlin | 13257 | 227 | 11843 | 1302 | 52.52 | 13.405 | 2020-09-23 04:23:00 | Berlin, Germany | ||
2836726 | 2836726 | 2020-09-21 | Germany | Berlin | 13109 | 227 | 11763 | 1266 | 52.52 | 13.405 | 2020-09-22 04:23:00 | Berlin, Germany | ||
3093330 | 3093330 | 2020-09-20 | Germany | Berlin | 13065 | 227 | 11724 | 1157 | 52.52 | 13.405 | 2020-09-21 04:23:00 | Berlin, Germany | ||
2454680 | 2454680 | 2020-09-19 | Germany | Berlin | 12919 | 227 | 11667 | 1170 | 52.52 | 13.405 | 2020-09-20 04:22:00 | Berlin, Germany | ||
2848749 | 2848749 | 2020-09-18 | Germany | Berlin | 12733 | 227 | 11608 | 1083 | 52.52 | 13.405 | 2020-09-19 04:22:00 | Berlin, Germany | ||
1121498 | 1121498 | 2020-09-17 | Germany | Berlin | 12593 | 227 | 11532 | 973 | 52.52 | 13.405 | 2020-09-18 05:05:00 | Berlin, Germany | ||
666187 | 666187 | 2020-09-16 | Germany | Berlin | 12463 | 227 | 11450 | 915 | 52.52 | 13.405 | 2020-09-17 04:22:00 | Berlin, Germany | ||
2728912 | 2728912 | 2020-09-15 | Germany | Berlin | 12354 | 226 | 11367 | 868 | 52.52 | 13.405 | 2020-09-16 04:22:53 | Berlin, Germany | ||
344184 | 344184 | 2020-09-14 | Germany | Berlin | 12269 | 226 | 11272 | 855 | 52.52 | 13.405 | 2020-09-15 03:22:50 | Berlin, Germany | ||
2868623 | 2868623 | 2020-09-13 | Germany | Berlin | 12254 | 226 | 11178 | 864 | 52.52 | 13.405 | 2020-09-14 04:26:00 | Berlin, Germany | ||
546662 | 546662 | 2020-09-12 | Germany | Berlin | 12216 | 226 | 11124 | 903 | 52.52 | 13.405 | 2020-09-13 04:30:52 | Berlin, Germany | ||
1444491 | 1444491 | 2020-09-11 | Germany | Berlin | 12090 | 226 | 11078 | 911 | 52.52 | 13.405 | 2020-09-12 04:25:05 | Berlin, Germany | ||
1173092 | 1173092 | 2020-09-10 | Germany | Berlin | 11951 | 226 | 11012 | 851 | 52.52 | 13.405 | 2020-09-11 04:46:23 | Berlin, Germany | ||
2171457 | 2171457 | 2020-09-09 | Germany | Berlin | 11879 | 226 | 10931 | 793 | 52.52 | 13.405 | 2020-09-10 04:29:01 | Berlin, Germany | ||
1243666 | 1243666 | 2020-09-08 | Germany | Berlin | 11792 | 226 | 10833 | 819 | 52.52 | 13.405 | 2020-09-09 04:28:48 | Berlin, Germany | ||
427245 | 427245 | 2020-09-07 | Germany | Berlin | 11727 | 226 | 10740 | 825 | 52.52 | 13.405 | 2020-09-08 04:28:25 | Berlin, Germany | ||
3161530 | 3161530 | 2020-09-06 | Germany | Berlin | 11703 | 226 | 10662 | 838 | 52.52 | 13.405 | 2020-09-07 04:28:30 | Berlin, Germany | ||
813485 | 813485 | 2020-09-05 | Germany | Berlin | 11623 | 226 | 10610 | 866 | 52.52 | 13.405 | 2020-09-06 04:28:33 | Berlin, Germany | ||
2661685 | 2661685 | 2020-09-04 | Germany | Berlin | 11529 | 226 | 10566 | 830 | 52.52 | 13.405 | 2020-09-05 04:28:19 | Berlin, Germany | ||
1354225 | 1354225 | 2020-09-03 | Germany | Berlin | 11431 | 226 | 10507 | 795 | 52.52 | 13.405 | 2020-09-04 04:28:26 | Berlin, Germany | ||
1105462 | 1105462 | 2020-09-02 | Germany | Berlin | 11347 | 226 | 10440 | 764 | 52.52 | 13.405 | 2020-09-03 04:28:22 | Berlin, Germany | ||
2059791 | 2059791 | 2020-09-01 | Germany | Berlin | 11266 | 226 | 10387 | 733 | 52.52 | 13.405 | 2020-09-02 04:28:25 | Berlin, Germany | ||
193976 | 193976 | 2020-08-31 | Germany | Berlin | 11189 | 226 | 10312 | 727 | 52.52 | 13.405 | 2020-09-01 04:28:31 | Berlin, Germany | ||
3931935 | 3931935 | 2020-08-30 | Germany | Berlin | 11183 | 226 | 10220 | 742 | 52.52 | 13.405 | 2020-08-31 04:28:27 | Berlin, Germany | ||
609597 | 609597 | 2020-08-29 | Germany | Berlin | 11125 | 226 | 10185 | 771 | 52.52 | 13.405 | 2020-08-30 04:28:22 | Berlin, Germany | ||
1523092 | 1523092 | 2020-08-28 | Germany | Berlin | 11011 | 226 | 10129 | 769 | 52.52 | 13.405 | 2020-08-29 04:28:19 | Berlin, Germany | ||
2510093 | 2510093 | 2020-08-27 | Germany | Berlin | 10934 | 226 | 10051 | 733 | 52.52 | 13.405 | 2020-08-28 04:28:11 | Berlin, Germany | ||
1996553 | 1996553 | 2020-08-26 | Germany | Berlin | 10852 | 226 | 9972 | 735 | 52.52 | 13.405 | 2020-08-27 04:28:15 | Berlin, Germany | ||
3562477 | 3562477 | 2020-08-25 | Germany | Berlin | 10786 | 226 | 9875 | 750 | 52.52 | 13.405 | 2020-08-26 04:28:11 | Berlin, Germany | ||
2991181 | 2991181 | 2020-08-24 | Germany | Berlin | 10728 | 226 | 9806 | 753 | 52.52 | 13.405 | 2020-08-25 04:28:02 | Berlin, Germany | ||
2215576 | 2215576 | 2020-08-23 | Germany | Berlin | 10717 | 226 | 9721 | 780 | 52.52 | 13.405 | 2020-08-24 04:27:56 | Berlin, Germany | ||
2299358 | 2299358 | 2020-08-22 | Germany | Berlin | 10655 | 226 | 9660 | 830 | 52.52 | 13.405 | 2020-08-23 04:27:48 | Berlin, Germany | ||
1479465 | 1479465 | 2020-08-21 | Germany | Berlin | 10543 | 226 | 9609 | 819 | 52.52 | 13.405 | 2020-08-22 04:27:49 | Berlin, Germany | ||
3484214 | 3484214 | 2020-08-20 | Germany | Berlin | 10463 | 224 | 9513 | 803 | 52.52 | 13.405 | 2020-08-21 04:27:41 | Berlin, Germany | ||
206163 | 206163 | 2020-08-19 | Germany | Berlin | 10394 | 224 | 9442 | 796 | 52.52 | 13.405 | 2020-08-20 04:27:43 | Berlin, Germany | ||
3177917 | 3177917 | 2020-08-18 | Germany | Berlin | 10319 | 224 | 9376 | 793 | 52.52 | 13.405 | 2020-08-19 04:27:00 | Berlin, Germany | ||
837521 | 837521 | 2020-08-17 | Germany | Berlin | 10253 | 224 | 9322 | 772 | 52.52 | 13.405 | 2020-08-18 04:27:56 | Berlin, Germany | ||
1555879 | 1555879 | 2020-08-16 | Germany | Berlin | 10238 | 224 | 9273 | 755 | 52.52 | 13.405 | 2020-08-17 04:27:20 | Berlin, Germany | ||
145881 | 145881 | 2020-08-15 | Germany | Berlin | 10196 | 224 | 9239 | 774 | 52.52 | 13.405 | 2020-08-16 04:27:42 | Berlin, Germany | ||
1612156 | 1612156 | 2020-08-14 | Germany | Berlin | 9976 | 224 | 9193 | 778 | 52.52 | 13.405 | 2020-08-15 04:27:31 | Berlin, Germany | ||
582740 | 582740 | 2020-08-13 | Germany | Berlin | 9976 | 224 | 9132 | 750 | 52.52 | 13.405 | 2020-08-14 04:51:19 | Berlin, Germany | ||
3531359 | 3531359 | 2020-08-12 | Germany | Berlin | 9851 | 224 | 9088 | 663 | 52.52 | 13.405 | 2020-08-13 04:29:15 | Berlin, Germany | ||
662208 | 662208 | 2020-08-11 | Germany | Berlin | 9740 | 224 | 9035 | 591 | 52.52 | 13.405 | 2020-08-12 04:27:29 | Berlin, Germany | ||
1920212 | 1920212 | 2020-08-10 | Germany | Berlin | 9698 | 224 | 8984 | 531 | 52.52 | 13.405 | 2020-08-11 04:35:08 | Berlin, Germany | ||
3923021 | 3923021 | 2020-08-09 | Germany | Berlin | 9688 | 224 | 8936 | 537 | 52.52 | 13.405 | 2020-08-10 04:34:55 | Berlin, Germany | ||
371189 | 371189 | 2020-08-08 | Germany | Berlin | 9640 | 224 | 8908 | 555 | 52.52 | 13.405 | 2020-08-09 04:34:54 | Berlin, Germany | ||
458373 | 458373 | 2020-08-07 | Germany | Berlin | 9543 | 224 | 8888 | 527 | 52.52 | 13.405 | 2020-08-08 04:34:53 | Berlin, Germany | ||
3612058 | 3612058 | 2020-08-06 | Germany | Berlin | 9490 | 224 | 8857 | 461 | 52.52 | 13.405 | 2020-08-07 04:35:11 | Berlin, Germany | ||
3792888 | 3792888 | 2020-08-05 | Germany | Berlin | 9399 | 223 | 8800 | 465 | 52.52 | 13.405 | 2020-08-06 04:35:02 | Berlin, Germany | ||
98124 | 98124 | 2020-08-04 | Germany | Berlin | 9367 | 223 | 8748 | 427 | 52.52 | 13.405 | 2020-08-05 04:34:43 | Berlin, Germany | ||
2740007 | 2740007 | 2020-08-03 | Germany | Berlin | 9328 | 223 | 8705 | 438 | 52.52 | 13.405 | 2020-08-04 04:41:59 | Berlin, Germany | ||
2807759 | 2807759 | 2020-08-02 | Germany | Berlin | 9319 | 223 | 8658 | 446 | 52.52 | 13.405 | 2020-08-03 04:34:35 | Berlin, Germany | ||
753327 | 753327 | 2020-08-01 | Germany | Berlin | 9274 | 223 | 8627 | 468 | 52.52 | 13.405 | 2020-08-02 04:34:47 | Berlin, Germany | ||
3264492 | 3264492 | 2020-07-31 | Germany | Berlin | 9192 | 223 | 8590 | 460 | 52.52 | 13.405 | 2020-08-01 04:36:27 | Berlin, Germany | ||
1928199 | 1928199 | 2020-07-30 | Germany | Berlin | 9150 | 223 | 8572 | 396 | 52.52 | 13.405 | 2020-07-31 04:35:18 | Berlin, Germany | ||
2958367 | 2958367 | 2020-07-29 | Germany | Berlin | 9071 | 223 | 8542 | 384 | 52.52 | 13.405 | 2020-07-30 04:35:05 | Berlin, Germany | ||
3184983 | 3184983 | 2020-07-28 | Germany | Berlin | 9020 | 223 | 8514 | 333 | 52.52 | 13.405 | 2020-07-29 04:35:11 | Berlin, Germany | ||
177035 | 177035 | 2020-07-27 | Germany | Berlin | 9001 | 223 | 8482 | 314 | 52.52 | 13.405 | 2020-07-28 04:58:43 | Berlin, Germany | ||
442348 | 442348 | 2020-07-26 | Germany | Berlin | 8991 | 223 | 8450 | 327 | 52.52 | 13.405 | 2020-07-27 04:35:02 | Berlin, Germany | ||
1502592 | 1502592 | 2020-07-25 | Germany | Berlin | 8957 | 223 | 8429 | 338 | 52.52 | 13.405 | 2020-07-26 04:35:00 | Berlin, Germany | ||
2563562 | 2563562 | 2020-07-24 | Germany | Berlin | 8894 | 222 | 8418 | 315 | 52.52 | 13.405 | 2020-07-25 04:47:39 | Berlin, Germany | ||
61791 | 61791 | 2020-07-23 | Germany | Berlin | 8860 | 222 | 8386 | 285 | 52.52 | 13.405 | 2020-07-24 05:30:40 | Berlin, Germany | ||
844582 | 844582 | 2020-07-22 | Germany | Berlin | 8837 | 222 | 8356 | 281 | 52.52 | 13.405 | 2020-07-23 05:15:04 | Berlin, Germany | ||
1707321 | 1707321 | 2020-07-21 | Germany | Berlin | 8802 | 221 | 8312 | 302 | 52.52 | 13.405 | 2020-07-22 04:34:42 | Berlin, Germany | ||
326812 | 326812 | 2020-07-20 | Germany | Berlin | 8779 | 221 | 8283 | 297 | 52.52 | 13.405 | 2020-07-21 04:38:46 | Berlin, Germany | ||
121717 | 121717 | 2020-07-19 | Germany | Berlin | 8774 | 221 | 8250 | 307 | 52.52 | 13.405 | 2020-07-20 05:34:40 | Berlin, Germany | ||
3205106 | 3205106 | 2020-07-18 | Germany | Berlin | 8748 | 221 | 8235 | 316 | 52.52 | 13.405 | 2020-07-19 04:34:58 | Berlin, Germany | ||
2708408 | 2708408 | 2020-07-17 | Germany | Berlin | 8725 | 221 | 8199 | 327 | 52.52 | 13.405 | 2020-07-18 04:34:45 | Berlin, Germany | ||
367227 | 367227 | 2020-07-16 | Germany | Berlin | 8699 | 221 | 8169 | 334 | 52.52 | 13.405 | 2020-07-17 04:34:50 | Berlin, Germany | ||
2747895 | 2747895 | 2020-07-15 | Germany | Berlin | 8674 | 220 | 8114 | 363 | 52.52 | 13.405 | 2020-07-16 04:44:59 | Berlin, Germany | ||
2158539 | 2158539 | 2020-07-14 | Germany | Berlin | 8656 | 219 | 8069 | 384 | 52.52 | 13.405 | 2020-07-15 04:34:39 | Berlin, Germany | ||
3491180 | 3491180 | 2020-07-13 | Germany | Berlin | 8638 | 217 | 8036 | 400 | 52.52 | 13.405 | 2020-07-14 04:34:46 | Berlin, Germany | ||
3737442 | 3737442 | 2020-07-12 | Germany | Berlin | 8637 | 217 | 7995 | 425 | 52.52 | 13.405 | 2020-07-13 04:43:04 | Berlin, Germany | ||
3435837 | 3435837 | 2020-07-11 | Germany | Berlin | 8617 | 216 | 7967 | 452 | 52.52 | 13.405 | 2020-07-12 04:34:30 | Berlin, Germany | ||
3237335 | 3237335 | 2020-07-10 | Germany | Berlin | 8586 | 216 | 7938 | 462 | 52.52 | 13.405 | 2020-07-11 04:34:26 | 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]);