daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Lombardia" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-22 | Italy | Lombardia | 98077 | 16852 | 75649 | 5576 | 45.46679409 | 9.190347404 | 2020-08-23 04:27:48 | Lombardia, Italy | ||
2020-08-23 | Italy | Lombardia | 98316 | 16856 | 75678 | 5782 | 45.46679409 | 9.190347404 | 2020-08-24 04:27:56 | Lombardia, Italy | ||
2020-08-24 | Italy | Lombardia | 98426 | 16857 | 75705 | 5864 | 45.46679409 | 9.190347404 | 2020-08-25 04:28:02 | Lombardia, Italy | ||
2020-08-25 | Italy | Lombardia | 98545 | 16857 | 75901 | 5787 | 45.46679409 | 9.190347404 | 2020-08-26 04:28:11 | Lombardia, Italy | ||
2020-08-26 | Italy | Lombardia | 98814 | 16857 | 75988 | 5969 | 45.46679409 | 9.190347404 | 2020-08-27 04:28:15 | Lombardia, Italy | ||
2020-08-27 | Italy | Lombardia | 99100 | 16857 | 76018 | 6225 | 45.46679409 | 9.190347404 | 2020-08-28 04:28:11 | Lombardia, Italy | ||
2020-08-28 | Italy | Lombardia | 99416 | 16860 | 76102 | 6454 | 45.46679409 | 9.190347404 | 2020-08-29 04:28:19 | Lombardia, Italy | ||
2020-08-29 | Italy | Lombardia | 99705 | 16860 | 76200 | 6645 | 45.46679409 | 9.190347404 | 2020-08-30 04:28:22 | Lombardia, Italy | ||
2020-08-30 | Italy | Lombardia | 99940 | 16863 | 76248 | 6829 | 45.46679409 | 9.190347404 | 2020-08-31 04:28:27 | Lombardia, Italy | ||
2020-08-31 | Italy | Lombardia | 100075 | 16865 | 76258 | 6952 | 45.46679409 | 9.190347404 | 2020-09-01 04:28:31 | Lombardia, Italy | ||
2020-09-01 | Italy | Lombardia | 100317 | 16867 | 76368 | 7082 | 45.46679409 | 9.190347404 | 2020-09-02 04:28:25 | Lombardia, Italy | ||
2020-09-02 | Italy | Lombardia | 100554 | 16869 | 76407 | 7278 | 45.46679409 | 9.190347404 | 2020-09-03 04:28:22 | Lombardia, Italy | ||
2020-09-03 | Italy | Lombardia | 100782 | 16870 | 76467 | 7445 | 45.46679409 | 9.190347404 | 2020-09-04 04:28:26 | Lombardia, Italy | ||
2020-09-04 | Italy | Lombardia | 101119 | 16876 | 76574 | 7669 | 45.46679409 | 9.190347404 | 2020-09-05 04:28:19 | Lombardia, Italy | ||
2020-09-05 | Italy | Lombardia | 101507 | 16877 | 76708 | 7922 | 45.46679409 | 9.190347404 | 2020-09-06 04:28:33 | Lombardia, Italy | ||
2020-09-06 | Italy | Lombardia | 101705 | 16880 | 76794 | 8031 | 45.46679409 | 9.190347404 | 2020-09-07 04:28:30 | Lombardia, Italy | ||
2020-09-07 | Italy | Lombardia | 101814 | 16886 | 76818 | 8110 | 45.46679409 | 9.190347404 | 2020-09-08 04:28:25 | Lombardia, Italy | ||
2020-09-08 | Italy | Lombardia | 102085 | 16888 | 76976 | 8221 | 45.46679409 | 9.190347404 | 2020-09-09 04:28:48 | Lombardia, Italy | ||
2020-09-09 | Italy | Lombardia | 102303 | 16891 | 77088 | 8324 | 45.46679409 | 9.190347404 | 2020-09-10 04:29:01 | Lombardia, Italy | ||
2020-09-10 | Italy | Lombardia | 102548 | 16892 | 77204 | 8452 | 45.46679409 | 9.190347404 | 2020-09-11 04:46:23 | Lombardia, Italy | ||
2020-09-11 | Italy | Lombardia | 102805 | 16896 | 77318 | 8591 | 45.46679409 | 9.190347404 | 2020-09-12 04:25:05 | Lombardia, Italy | ||
2020-09-12 | Italy | Lombardia | 103074 | 16896 | 77611 | 8567 | 45.46679409 | 9.190347404 | 2020-09-13 04:30:52 | Lombardia, Italy | ||
2020-09-13 | Italy | Lombardia | 103339 | 16899 | 77651 | 8789 | 45.46679409 | 9.190347404 | 2020-09-14 04:26:00 | Lombardia, Italy | ||
2020-09-14 | Italy | Lombardia | 103464 | 16901 | 77715 | 8848 | 45.46679409 | 9.190347404 | 2020-09-15 03:22:50 | Lombardia, Italy | ||
2020-09-15 | Italy | Lombardia | 103640 | 16903 | 77938 | 8799 | 45.46679409 | 9.190347404 | 2020-09-16 04:22:53 | Lombardia, Italy | ||
2020-09-16 | Italy | Lombardia | 103799 | 16905 | 78090 | 8804 | 45.46679409 | 9.190347404 | 2020-09-17 04:22:00 | Lombardia, Italy | ||
2020-09-17 | Italy | Lombardia | 104080 | 16906 | 78240 | 8934 | 45.46679409 | 9.190347404 | 2020-09-18 05:05:00 | Lombardia, Italy | ||
2020-09-18 | Italy | Lombardia | 104304 | 16908 | 78369 | 9027 | 45.46679409 | 9.190347404 | 2020-09-19 04:22:00 | Lombardia, Italy | ||
2020-09-19 | Italy | Lombardia | 104547 | 16917 | 78695 | 8935 | 45.46679409 | 9.190347404 | 2020-09-20 04:22:00 | Lombardia, Italy | ||
2020-09-20 | Italy | Lombardia | 104758 | 16922 | 78829 | 9007 | 45.46679409 | 9.190347404 | 2020-09-21 04:23:00 | Lombardia, Italy | ||
2020-09-21 | Italy | Lombardia | 104848 | 16923 | 78849 | 9076 | 45.46679409 | 9.190347404 | 2020-09-22 04:23:00 | Lombardia, Italy | ||
2020-09-22 | Italy | Lombardia | 105030 | 16925 | 79078 | 9027 | 45.46679409 | 9.190347404 | 2020-09-23 04:23:00 | Lombardia, Italy | ||
2020-09-23 | Italy | Lombardia | 105226 | 16925 | 79197 | 9104 | 45.46679409 | 9.190347404 | 2020-09-24 04:23:00 | Lombardia, Italy | ||
2020-09-24 | Italy | Lombardia | 105455 | 16935 | 79472 | 9048 | 45.46679409 | 9.190347404 | 2020-09-25 04:23:00 | Lombardia, Italy | ||
2020-09-25 | Italy | Lombardia | 105732 | 16937 | 79624 | 9171 | 45.46679409 | 9.190347404 | 2020-09-26 04:23:00 | Lombardia, Italy | ||
2020-09-26 | Italy | Lombardia | 105988 | 16941 | 79960 | 9087 | 45.46679409 | 9.190347404 | 2020-09-27 04:23:00 | Lombardia, Italy | ||
2020-09-27 | Italy | Lombardia | 106204 | 16946 | 80021 | 9237 | 45.46679409 | 9.190347404 | 2020-09-28 04:23:00 | Lombardia, Italy | ||
2020-09-28 | Italy | Lombardia | 106323 | 16948 | 80041 | 9334 | 45.46679409 | 9.190347404 | 2020-09-29 04:23:42 | Lombardia, Italy | ||
2020-09-29 | Italy | Lombardia | 106526 | 16951 | 80476 | 9099 | 45.46679409 | 9.190347404 | 2020-09-30 04:23:33 | Lombardia, Italy | ||
2020-09-30 | Italy | Lombardia | 106727 | 16955 | 80712 | 9060 | 45.46679409 | 9.190347404 | 2020-10-01 04:23:42 | Lombardia, Italy | ||
2020-10-01 | Italy | Lombardia | 107051 | 16960 | 80924 | 9167 | 45.46679409 | 9.190347404 | 2020-10-02 04:23:51 | Lombardia, Italy | ||
2020-10-02 | Italy | Lombardia | 107358 | 16964 | 81228 | 9166 | 45.46679409 | 9.190347404 | 2020-10-03 04:23:40 | Lombardia, Italy | ||
2020-10-03 | Italy | Lombardia | 107751 | 16969 | 81620 | 9162 | 45.46679409 | 9.190347404 | 2020-10-04 04:23:44 | Lombardia, Italy | ||
2020-10-04 | Italy | Lombardia | 108065 | 16971 | 81733 | 9361 | 45.46679409 | 9.190347404 | 2020-10-05 04:23:33 | Lombardia, Italy | ||
2020-10-05 | Italy | Lombardia | 108316 | 16973 | 81811 | 9532 | 45.46679409 | 9.190347404 | 2020-10-06 04:23:33 | Lombardia, Italy | ||
2020-10-06 | Italy | Lombardia | 108666 | 16973 | 82184 | 9509 | 45.46679409 | 9.190347404 | 2020-10-07 04:23:40 | Lombardia, Italy | ||
2020-10-07 | Italy | Lombardia | 109186 | 16978 | 82331 | 9877 | 45.46679409 | 9.190347404 | 2020-10-08 04:23:56 | Lombardia, Italy | ||
2020-10-08 | Italy | Lombardia | 109869 | 16979 | 82484 | 10406 | 45.46679409 | 9.190347404 | 2020-10-09 04:23:59 | Lombardia, Italy | ||
2020-10-09 | Italy | Lombardia | 110852 | 16980 | 82744 | 11128 | 45.46679409 | 9.190347404 | 2020-10-10 04:23:57 | Lombardia, Italy | ||
2020-10-10 | Italy | Lombardia | 111992 | 16982 | 82988 | 12022 | 45.46679409 | 9.190347404 | 2020-10-11 04:23:46 | Lombardia, Italy | ||
2020-10-11 | Italy | Lombardia | 113024 | 16985 | 83190 | 12849 | 45.46679409 | 9.190347404 | 2020-10-12 04:23:45 | Lombardia, Italy | ||
2020-10-12 | Italy | Lombardia | 113720 | 16988 | 83353 | 13379 | 45.46679409 | 9.190347404 | 2020-10-13 04:24:02 | Lombardia, Italy | ||
2020-10-13 | Italy | Lombardia | 114800 | 16994 | 83550 | 14256 | 45.46679409 | 9.190347404 | 2020-10-14 04:24:05 | Lombardia, Italy | ||
2020-10-14 | Italy | Lombardia | 116644 | 17011 | 84415 | 15218 | 45.46679409 | 9.190347404 | 2020-10-15 04:24:28 | Lombardia, Italy | ||
2020-10-15 | Italy | Lombardia | 118711 | 17037 | 84624 | 17050 | 45.46679409 | 9.190347404 | 2020-10-16 04:24:01 | Lombardia, Italy | ||
2020-10-16 | Italy | Lombardia | 121130 | 17044 | 84958 | 19128 | 45.46679409 | 9.190347404 | 2020-10-17 04:24:12 | Lombardia, Italy | ||
2020-10-17 | Italy | Lombardia | 123794 | 17057 | 85112 | 21625 | 45.46679409 | 9.190347404 | 2020-10-18 04:24:25 | Lombardia, Italy | ||
2020-10-18 | Italy | Lombardia | 126769 | 17078 | 86397 | 23294 | 45.46679409 | 9.190347404 | 2020-10-19 04:24:16 | Lombardia, Italy | ||
2020-10-19 | Italy | Lombardia | 128456 | 17084 | 86738 | 24634 | 45.46679409 | 9.190347404 | 2020-10-20 04:24:22 | Lombardia, Italy | ||
2020-10-20 | Italy | Lombardia | 130479 | 17103 | 87072 | 26304 | 45.46679409 | 9.190347404 | 2020-10-21 04:24:14 | Lombardia, Italy | ||
2020-10-21 | Italy | Lombardia | 134604 | 17123 | 87591 | 29890 | 45.46679409 | 9.190347404 | 2020-10-22 04:24:27 | Lombardia, Italy | ||
2020-10-22 | Italy | Lombardia | 138729 | 17152 | 88059 | 33518 | 45.46679409 | 9.190347404 | 2020-10-23 04:24:46 | Lombardia, Italy | ||
2020-10-23 | Italy | Lombardia | 143645 | 17159 | 88536 | 37950 | 45.46679409 | 9.190347404 | 2020-10-24 04:24:46 | Lombardia, Italy | ||
2020-10-24 | Italy | Lombardia | 148601 | 17210 | 88706 | 42685 | 45.46679409 | 9.190347404 | 2020-10-25 04:24:36 | Lombardia, Italy | ||
2020-10-25 | Italy | Lombardia | 154363 | 17235 | 89145 | 47983 | 45.46679409 | 9.190347404 | 2020-10-26 04:25:02 | Lombardia, Italy | ||
2020-10-26 | Italy | Lombardia | 157933 | 17252 | 90356 | 50325 | 45.46679409 | 9.190347404 | 2020-10-27 04:24:45 | Lombardia, Italy | ||
2020-10-27 | Italy | Lombardia | 162968 | 17310 | 90774 | 54884 | 45.46679409 | 9.190347404 | 2020-10-28 04:24:39 | Lombardia, Italy | ||
2020-10-28 | Italy | Lombardia | 170526 | 17357 | 91763 | 61406 | 45.46679409 | 9.190347404 | 2020-10-29 04:24:49 | Lombardia, Italy | ||
2020-10-29 | Italy | Lombardia | 177865 | 17414 | 92567 | 67884 | 45.46679409 | 9.190347404 | 2020-10-30 04:24:49 | Lombardia, Italy | ||
2020-10-30 | Italy | Lombardia | 186825 | 17462 | 94134 | 75229 | 45.46679409 | 9.190347404 | 2020-10-31 04:24:44 | Lombardia, Italy | ||
2020-10-31 | Italy | Lombardia | 195744 | 17535 | 96198 | 82011 | 45.46679409 | 9.190347404 | 2020-11-01 04:36:19 | Lombardia, Italy | ||
2020-11-01 | Italy | Lombardia | 204351 | 17589 | 96687 | 90075 | 45.46679409 | 9.190347404 | 2020-11-02 05:25:04 | Lombardia, Italy | ||
2020-11-02 | Italy | Lombardia | 209629 | 17635 | 97576 | 94418 | 45.46679409 | 9.190347404 | 2020-11-03 06:00:16 | Lombardia, Italy | ||
2020-11-03 | Italy | Lombardia | 216433 | 17752 | 100115 | 98566 | 45.46679409 | 9.190347404 | 2020-11-04 05:25:09 | Lombardia, Italy | ||
2020-11-04 | Italy | Lombardia | 224191 | 17848 | 101610 | 104733 | 45.46679409 | 9.190347404 | 2020-11-05 06:05:03 | Lombardia, Italy | ||
2020-11-05 | Italy | Lombardia | 233013 | 17987 | 102502 | 112524 | 45.46679409 | 9.190347404 | 2020-11-06 05:24:55 | Lombardia, Italy | ||
2020-11-06 | Italy | Lombardia | 242947 | 18118 | 107463 | 117366 | 45.46679409 | 9.190347404 | 2020-11-07 05:24:52 | Lombardia, Italy | ||
2020-11-07 | Italy | Lombardia | 254436 | 18226 | 108581 | 127629 | 45.46679409 | 9.190347404 | 2020-11-08 05:24:56 | Lombardia, Italy | ||
2020-11-08 | Italy | Lombardia | 260754 | 18343 | 110001 | 132410 | 45.46679409 | 9.190347404 | 2020-11-09 05:25:45 | Lombardia, Italy | ||
2020-11-09 | Italy | Lombardia | 265531 | 18442 | 115630 | 131459 | 45.46679409 | 9.190347404 | 2020-11-10 05:40:07 | Lombardia, Italy | ||
2020-11-10 | Italy | Lombardia | 276486 | 18571 | 122410 | 135505 | 45.46679409 | 9.190347404 | 2020-11-11 05:25:30 | Lombardia, Italy | ||
2020-11-11 | Italy | Lombardia | 284666 | 18723 | 124025 | 141918 | 45.46679409 | 9.190347404 | 2020-11-12 05:25:55 | Lombardia, Italy | ||
2020-11-12 | Italy | Lombardia | 293957 | 18910 | 132254 | 142793 | 45.46679409 | 9.190347404 | 2020-11-13 05:25:30 | Lombardia, Italy | ||
2020-11-13 | Italy | Lombardia | 304591 | 19028 | 134294 | 151269 | 45.46679409 | 9.190347404 | 2020-11-14 05:25:37 | Lombardia, Italy | ||
2020-11-14 | Italy | Lombardia | 312720 | 19186 | 137255 | 156279 | 45.46679409 | 9.190347404 | 2020-11-15 05:26:53 | Lombardia, Italy | ||
2020-11-15 | Italy | Lombardia | 320780 | 19367 | 138872 | 162541 | 45.46679409 | 9.190347404 | 2020-11-16 05:25:57 | Lombardia, Italy | ||
2020-11-16 | Italy | Lombardia | 324908 | 19466 | 153103 | 152339 | 45.46679409 | 9.190347404 | 2020-11-17 05:25:54 | Lombardia, Italy | ||
2020-11-17 | Italy | Lombardia | 333356 | 19668 | 157121 | 156567 | 45.46679409 | 9.190347404 | 2020-11-18 05:40:31 | Lombardia, Italy | ||
2020-11-18 | Italy | Lombardia | 340989 | 19850 | 169056 | 152083 | 45.46679409 | 9.190347404 | 2020-11-19 05:25:23 | Lombardia, Italy | ||
2020-11-19 | Italy | Lombardia | 348442 | 20015 | 172847 | 155580 | 45.46679409 | 9.190347404 | 2020-11-20 05:26:28 | Lombardia, Italy | ||
2020-11-20 | Italy | Lombardia | 357663 | 20190 | 177832 | 159641 | 45.46679409 | 9.190347404 | 2020-11-21 05:25:51 | Lombardia, Italy | ||
2020-11-21 | Italy | Lombardia | 366516 | 20359 | 183472 | 162685 | 45.46679409 | 9.190347404 | 2020-11-22 05:25:45 | Lombardia, Italy | ||
2020-11-22 | Italy | Lombardia | 371610 | 20524 | 186680 | 164406 | 45.46679409 | 9.190347404 | 2020-11-23 05:25:26 | Lombardia, Italy | ||
2020-11-23 | Italy | Lombardia | 376899 | 20664 | 206317 | 149918 | 45.46679409 | 9.190347404 | 2020-11-24 05:27:31 | Lombardia, Italy | ||
2020-11-24 | Italy | Lombardia | 381785 | 20850 | 212175 | 148760 | 45.46679409 | 9.190347404 | 2020-11-25 05:27:20 | Lombardia, Italy | ||
2020-11-25 | Italy | Lombardia | 386958 | 21005 | 227924 | 138029 | 45.46679409 | 9.190347404 | 2020-11-26 05:27:44 | Lombardia, Italy | ||
2020-11-26 | Italy | Lombardia | 392655 | 21212 | 231042 | 140401 | 45.46679409 | 9.190347404 | 2020-11-27 05:26:53 | Lombardia, Italy | ||
2020-11-27 | Italy | Lombardia | 398044 | 21393 | 246096 | 130555 | 45.46679409 | 9.190347404 | 2020-11-28 05:25:50 | Lombardia, Italy | ||
2020-11-28 | Italy | Lombardia | 402659 | 21512 | 250832 | 130315 | 45.46679409 | 9.190347404 | 2020-11-29 05:25:55 | Lombardia, Italy | ||
2020-11-29 | Italy | Lombardia | 405862 | 21647 | 251588 | 132627 | 45.46679409 | 9.190347404 | 2020-11-30 05:26:13 | Lombardia, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;