johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Lombardia" sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714436 | 714436 | 2021-11-12 | Italy | Lombardia | 903172 | 34222 | 0 | 45.46679409 | 9.190347404 | 2021-11-13 04:21:38 | Lombardia, Italy | |||
718453 | 718453 | 2022-12-04 | Italy | Lombardia | 3961860 | 43851 | 0 | 45.46679409 | 9.190347404 | 2022-12-05 04:20:58 | Lombardia, Italy | |||
722468 | 722468 | 2021-11-20 | Italy | Lombardia | 914572 | 34278 | 0 | 45.46679409 | 9.190347404 | 2021-11-21 04:22:13 | Lombardia, Italy | |||
730498 | 730498 | 2021-12-27 | Italy | Lombardia | 1075263 | 34952 | 0 | 45.46679409 | 9.190347404 | 2021-12-28 04:21:47 | Lombardia, Italy | |||
746315 | 746315 | 2022-04-23 | Italy | Lombardia | 2717998 | 39791 | 0 | 45.46679409 | 9.190347404 | 2022-04-24 04:20:56 | Lombardia, Italy | |||
758298 | 758298 | 2021-11-26 | Italy | Lombardia | 925051 | 34330 | 0 | 45.46679409 | 9.190347404 | 2021-11-27 04:22:45 | Lombardia, Italy | |||
770319 | 770319 | 2021-10-23 | Italy | Lombardia | 890932 | 34137 | 0 | 45.46679409 | 9.190347404 | 2021-10-24 04:21:22 | Lombardia, Italy | |||
782361 | 782361 | 2021-12-13 | Italy | Lombardia | 966856 | 34599 | 0 | 45.46679409 | 9.190347404 | 2021-12-14 04:22:38 | Lombardia, Italy | |||
794385 | 794385 | 2022-10-24 | Italy | Lombardia | 3745325 | 42964 | 0 | 45.46679409 | 9.190347404 | 2022-10-25 04:21:53 | Lombardia, Italy | |||
798400 | 798400 | 2021-12-22 | Italy | Lombardia | 1019298 | 34814 | 0 | 45.46679409 | 9.190347404 | 2021-12-23 04:21:21 | Lombardia, Italy | |||
809562 | 809562 | 2021-09-20 | Italy | Lombardia | 879789 | 33983 | 0 | 45.46679409 | 9.190347404 | 2021-09-21 04:21:26 | Lombardia, Italy | |||
833598 | 833598 | 2022-12-02 | Italy | Lombardia | 3961860 | 43851 | 0 | 45.46679409 | 9.190347404 | 2022-12-03 04:21:02 | Lombardia, Italy | |||
849570 | 849570 | 2022-11-02 | Italy | Lombardia | 3778186 | 43086 | 0 | 45.46679409 | 9.190347404 | 2022-11-03 04:22:05 | Lombardia, Italy | |||
853586 | 853586 | 2022-09-30 | Italy | Lombardia | 3573539 | 42546 | 0 | 45.46679409 | 9.190347404 | 2022-10-01 04:23:01 | Lombardia, Italy | |||
868770 | 868770 | 2022-12-11 | Italy | Lombardia | 3997099 | 44073 | 0 | 45.46679409 | 9.190347404 | 2022-12-12 04:21:01 | Lombardia, Italy | |||
876235 | 876235 | 2022-03-27 | Italy | Lombardia | 2503411 | 39189 | 0 | 45.46679409 | 9.190347404 | 2022-03-28 04:20:33 | Lombardia, Italy | |||
880251 | 880251 | 2022-08-05 | Italy | Lombardia | 3397420 | 41708 | 0 | 45.46679409 | 9.190347404 | 2022-08-06 04:20:56 | Lombardia, Italy | |||
896118 | 896118 | 2022-07-24 | Italy | Lombardia | 3321929 | 41320 | 0 | 45.46679409 | 9.190347404 | 2022-07-25 04:20:51 | Lombardia, Italy | |||
900134 | 900134 | 2022-07-22 | Italy | Lombardia | 3306888 | 41258 | 0 | 45.46679409 | 9.190347404 | 2022-07-23 04:20:53 | Lombardia, Italy | |||
904149 | 904149 | 2021-11-24 | Italy | Lombardia | 920540 | 34311 | 0 | 45.46679409 | 9.190347404 | 2021-11-25 04:22:33 | Lombardia, Italy | |||
912179 | 912179 | 2022-10-29 | Italy | Lombardia | 3778186 | 43086 | 0 | 45.46679409 | 9.190347404 | 2022-10-30 04:22:14 | Lombardia, Italy | |||
919655 | 919655 | 2022-03-08 | Italy | Lombardia | 2367735 | 38831 | 0 | 45.46679409 | 9.190347404 | 2022-03-09 04:20:59 | Lombardia, Italy | |||
934771 | 934771 | 2021-10-16 | Italy | Lombardia | 888500 | 34112 | 0 | 45.46679409 | 9.190347404 | 2021-10-17 04:21:29 | Lombardia, Italy | |||
938788 | 938788 | 2022-06-25 | Italy | Lombardia | 3001758 | 40773 | 0 | 45.46679409 | 9.190347404 | 2022-06-26 04:21:02 | Lombardia, Italy | |||
942804 | 942804 | 2022-02-28 | Italy | Lombardia | 2332560 | 38603 | 0 | 45.46679409 | 9.190347404 | 2022-03-01 04:21:09 | Lombardia, Italy | |||
946820 | 946820 | 2022-06-14 | Italy | Lombardia | 2931043 | 40691 | 0 | 45.46679409 | 9.190347404 | 2022-06-15 04:20:54 | Lombardia, Italy | |||
950836 | 950836 | 2022-03-12 | Italy | Lombardia | 2390493 | 38921 | 0 | 45.46679409 | 9.190347404 | 2022-03-13 04:20:49 | Lombardia, Italy | |||
958866 | 958866 | 2022-07-19 | Italy | Lombardia | 3275909 | 41170 | 0 | 45.46679409 | 9.190347404 | 2022-07-20 04:20:59 | Lombardia, Italy | |||
962882 | 962882 | 2022-09-09 | Italy | Lombardia | 3495958 | 42351 | 0 | 45.46679409 | 9.190347404 | 2022-09-10 04:21:10 | Lombardia, Italy | |||
970890 | 970890 | 2022-06-01 | Italy | Lombardia | 2895171 | 40552 | 0 | 45.46679409 | 9.190347404 | 2022-06-02 05:20:39 | Lombardia, Italy | |||
978919 | 978919 | 2022-02-01 | Italy | Lombardia | 2148470 | 37241 | 0 | 45.46679409 | 9.190347404 | 2022-02-02 04:21:09 | Lombardia, Italy | |||
986949 | 986949 | 2021-10-04 | Italy | Lombardia | 884920 | 34060 | 0 | 45.46679409 | 9.190347404 | 2021-10-05 04:21:27 | Lombardia, Italy | |||
990965 | 990965 | 2022-08-16 | Italy | Lombardia | 3428161 | 41987 | 0 | 45.46679409 | 9.190347404 | 2022-08-17 04:20:59 | Lombardia, Italy | |||
1014304 | 1014304 | 2021-11-21 | Italy | Lombardia | 916003 | 34280 | 0 | 45.46679409 | 9.190347404 | 2021-11-22 04:22:20 | Lombardia, Italy | |||
1018321 | 1018321 | 2022-12-24 | Italy | Lombardia | 4043487 | 44489 | 0 | 45.46679409 | 9.190347404 | 2022-12-25 04:21:04 | Lombardia, Italy | |||
1022337 | 1022337 | 2022-11-04 | Italy | Lombardia | 3797984 | 43188 | 0 | 45.46679409 | 9.190347404 | 2022-11-05 04:21:52 | Lombardia, Italy | |||
1030346 | 1030346 | 2021-12-06 | Italy | Lombardia | 947099 | 34470 | 0 | 45.46679409 | 9.190347404 | 2021-12-07 04:22:34 | Lombardia, Italy | |||
1049809 | 1049809 | 2022-11-06 | Italy | Lombardia | 3797984 | 43188 | 0 | 45.46679409 | 9.190347404 | 2022-11-07 04:21:26 | Lombardia, Italy | |||
1057820 | 1057820 | 2022-02-23 | Italy | Lombardia | 2313594 | 38423 | 0 | 45.46679409 | 9.190347404 | 2022-02-24 04:21:14 | Lombardia, Italy | |||
1065848 | 1065848 | 2022-07-28 | Italy | Lombardia | 3353664 | 41463 | 0 | 45.46679409 | 9.190347404 | 2022-07-29 04:20:45 | Lombardia, Italy | |||
1069864 | 1069864 | 2022-08-07 | Italy | Lombardia | 3404893 | 41779 | 0 | 45.46679409 | 9.190347404 | 2022-08-08 04:21:08 | Lombardia, Italy | |||
1073880 | 1073880 | 2022-12-28 | Italy | Lombardia | 4043487 | 44489 | 0 | 45.46679409 | 9.190347404 | 2022-12-29 04:21:01 | Lombardia, Italy | |||
1077895 | 1077895 | 2021-12-09 | Italy | Lombardia | 954741 | 34524 | 0 | 45.46679409 | 9.190347404 | 2021-12-10 04:22:28 | Lombardia, Italy | |||
1086046 | 1086046 | 2022-08-09 | Italy | Lombardia | 3411536 | 41826 | 0 | 45.46679409 | 9.190347404 | 2022-08-10 04:20:57 | Lombardia, Italy | |||
1098089 | 1098089 | 2022-08-03 | Italy | Lombardia | 3387359 | 41633 | 0 | 45.46679409 | 9.190347404 | 2022-08-04 04:20:58 | Lombardia, Italy | |||
1109545 | 1109545 | 2022-05-21 | Italy | Lombardia | 2869121 | 40408 | 0 | 45.46679409 | 9.190347404 | 2022-05-22 04:20:52 | Lombardia, Italy | |||
1113560 | 1113560 | 2022-01-11 | Italy | Lombardia | 1600333 | 35519 | 0 | 45.46679409 | 9.190347404 | 2022-01-12 04:21:44 | Lombardia, Italy | |||
1117576 | 1117576 | 2021-08-06 | Italy | Lombardia | 856667 | 33836 | 0 | 45.46679409 | 9.190347404 | 2021-08-07 04:21:30 | Lombardia, Italy | |||
1140883 | 1140883 | 2022-01-23 | Italy | Lombardia | 1979100 | 36527 | 0 | 45.46679409 | 9.190347404 | 2022-01-24 04:21:12 | Lombardia, Italy | |||
1144899 | 1144899 | 2021-12-01 | Italy | Lombardia | 935047 | 34396 | 0 | 45.46679409 | 9.190347404 | 2021-12-02 04:22:37 | Lombardia, Italy | |||
1148916 | 1148916 | 2022-12-12 | Italy | Lombardia | 3997099 | 44073 | 0 | 45.46679409 | 9.190347404 | 2022-12-13 04:21:01 | Lombardia, Italy | |||
1157123 | 1157123 | 2022-04-29 | Italy | Lombardia | 2758419 | 39915 | 0 | 45.46679409 | 9.190347404 | 2022-04-30 04:21:05 | Lombardia, Italy | |||
1161139 | 1161139 | 2022-08-18 | Italy | Lombardia | 3435844 | 42014 | 0 | 45.46679409 | 9.190347404 | 2022-08-19 04:20:54 | Lombardia, Italy | |||
1169169 | 1169169 | 2022-05-20 | Italy | Lombardia | 2865834 | 40384 | 0 | 45.46679409 | 9.190347404 | 2022-05-21 04:20:58 | Lombardia, Italy | |||
1184716 | 1184716 | 2022-05-18 | Italy | Lombardia | 2858315 | 40342 | 0 | 45.46679409 | 9.190347404 | 2022-05-19 04:20:54 | Lombardia, Italy | |||
1199778 | 1199778 | 2022-07-06 | Italy | Lombardia | 3119042 | 40898 | 0 | 45.46679409 | 9.190347404 | 2022-07-07 04:20:55 | Lombardia, Italy | |||
1211523 | 1211523 | 2022-07-11 | Italy | Lombardia | 3170752 | 40988 | 0 | 45.46679409 | 9.190347404 | 2022-07-12 04:20:51 | Lombardia, Italy | |||
1215538 | 1215538 | 2022-01-08 | Italy | Lombardia | 1500339 | 35365 | 0 | 45.46679409 | 9.190347404 | 2022-01-09 04:21:46 | Lombardia, Italy | |||
1223569 | 1223569 | 2022-04-14 | Italy | Lombardia | 2649677 | 39540 | 0 | 45.46679409 | 9.190347404 | 2022-04-15 04:20:57 | Lombardia, Italy | |||
1227584 | 1227584 | 2022-01-24 | Italy | Lombardia | 1987944 | 36614 | 0 | 45.46679409 | 9.190347404 | 2022-01-25 04:21:05 | Lombardia, Italy | |||
1231600 | 1231600 | 2021-11-28 | Italy | Lombardia | 929470 | 34349 | 0 | 45.46679409 | 9.190347404 | 2021-11-29 04:22:30 | Lombardia, Italy | |||
1235616 | 1235616 | 2021-09-27 | Italy | Lombardia | 882560 | 34026 | 0 | 45.46679409 | 9.190347404 | 2021-09-28 04:21:28 | Lombardia, Italy | |||
1239632 | 1239632 | 2022-11-28 | Italy | Lombardia | 3918510 | 43662 | 0 | 45.46679409 | 9.190347404 | 2022-11-29 04:21:05 | Lombardia, Italy | |||
1250728 | 1250728 | 2022-08-23 | Italy | Lombardia | 3449600 | 42123 | 0 | 45.46679409 | 9.190347404 | 2022-08-24 04:20:46 | Lombardia, Italy | |||
1254743 | 1254743 | 2021-12-20 | Italy | Lombardia | 1000437 | 34776 | 0 | 45.46679409 | 9.190347404 | 2021-12-21 03:21:27 | Lombardia, Italy | |||
1258759 | 1258759 | 2021-12-18 | Italy | Lombardia | 992464 | 34718 | 0 | 45.46679409 | 9.190347404 | 2021-12-19 04:21:11 | Lombardia, Italy | |||
1262775 | 1262775 | 2021-09-09 | Italy | Lombardia | 874671 | 33945 | 0 | 45.46679409 | 9.190347404 | 2021-09-10 04:21:20 | Lombardia, Italy | |||
1274259 | 1274259 | 2021-10-03 | Italy | Lombardia | 884814 | 34054 | 0 | 45.46679409 | 9.190347404 | 2021-10-04 04:21:31 | Lombardia, Italy | |||
1281960 | 1281960 | 2022-01-05 | Italy | Lombardia | 1380171 | 35240 | 0 | 45.46679409 | 9.190347404 | 2022-01-06 04:22:09 | Lombardia, Italy | |||
1285976 | 1285976 | 2022-01-04 | Italy | Lombardia | 1328584 | 35193 | 0 | 45.46679409 | 9.190347404 | 2022-01-05 04:21:59 | Lombardia, Italy | |||
1294006 | 1294006 | 2022-02-05 | Italy | Lombardia | 2202033 | 37569 | 0 | 45.46679409 | 9.190347404 | 2022-02-06 04:21:00 | Lombardia, Italy | |||
1298023 | 1298023 | 2022-02-17 | Italy | Lombardia | 2284163 | 38178 | 0 | 45.46679409 | 9.190347404 | 2022-02-18 04:21:04 | Lombardia, Italy | |||
1314170 | 1314170 | 2022-05-27 | Italy | Lombardia | 2884764 | 40501 | 0 | 45.46679409 | 9.190347404 | 2022-05-28 04:21:07 | Lombardia, Italy | |||
1318185 | 1318185 | 2022-01-26 | Italy | Lombardia | 2044124 | 36758 | 0 | 45.46679409 | 9.190347404 | 2022-01-27 04:21:19 | Lombardia, Italy | |||
1322201 | 1322201 | 2021-11-14 | Italy | Lombardia | 905429 | 34240 | 0 | 45.46679409 | 9.190347404 | 2021-11-15 04:21:36 | Lombardia, Italy | |||
1326218 | 1326218 | 2022-04-26 | Italy | Lombardia | 2729044 | 39854 | 0 | 45.46679409 | 9.190347404 | 2022-04-27 04:20:52 | Lombardia, Italy | |||
1334247 | 1334247 | 2021-09-28 | Italy | Lombardia | 882905 | 34032 | 0 | 45.46679409 | 9.190347404 | 2021-09-29 04:21:45 | Lombardia, Italy | |||
1342276 | 1342276 | 2021-08-11 | Italy | Lombardia | 859553 | 33845 | 0 | 45.46679409 | 9.190347404 | 2021-08-12 04:21:25 | Lombardia, Italy | |||
1346291 | 1346291 | 2022-08-10 | Italy | Lombardia | 3415276 | 41839 | 0 | 45.46679409 | 9.190347404 | 2022-08-11 04:20:49 | Lombardia, Italy | |||
1358307 | 1358307 | 2021-11-27 | Italy | Lombardia | 926977 | 34344 | 0 | 45.46679409 | 9.190347404 | 2021-11-28 04:22:43 | Lombardia, Italy | |||
1362323 | 1362323 | 2022-02-08 | Italy | Lombardia | 2225713 | 37763 | 0 | 45.46679409 | 9.190347404 | 2022-02-09 04:21:04 | Lombardia, Italy | |||
1366448 | 1366448 | 2022-10-28 | Italy | Lombardia | 3773197 | 43061 | 0 | 45.46679409 | 9.190347404 | 2022-10-29 04:21:13 | Lombardia, Italy | |||
1370464 | 1370464 | 2022-09-21 | Italy | Lombardia | 3528736 | 42449 | 0 | 45.46679409 | 9.190347404 | 2022-09-22 04:22:56 | Lombardia, Italy | |||
1374479 | 1374479 | 2021-09-15 | Italy | Lombardia | 877593 | 33968 | 0 | 45.46679409 | 9.190347404 | 2021-09-16 04:22:19 | Lombardia, Italy | |||
1385617 | 1385617 | 2021-09-13 | Italy | Lombardia | 876530 | 33956 | 0 | 45.46679409 | 9.190347404 | 2021-09-14 04:21:41 | Lombardia, Italy | |||
1389631 | 1389631 | 2022-01-07 | Italy | Lombardia | 1451531 | 35345 | 0 | 45.46679409 | 9.190347404 | 2022-01-08 04:21:53 | Lombardia, Italy | |||
1393648 | 1393648 | 2022-09-02 | Italy | Lombardia | 3479160 | 42267 | 0 | 45.46679409 | 9.190347404 | 2022-09-03 04:21:04 | Lombardia, Italy | |||
1397664 | 1397664 | 2022-05-06 | Italy | Lombardia | 2800489 | 40094 | 0 | 45.46679409 | 9.190347404 | 2022-05-07 04:21:09 | Lombardia, Italy | |||
1405014 | 1405014 | 2022-08-02 | Italy | Lombardia | 3381787 | 41613 | 0 | 45.46679409 | 9.190347404 | 2022-08-03 04:20:59 | Lombardia, Italy | |||
1417058 | 1417058 | 2022-07-08 | Italy | Lombardia | 3145145 | 40923 | 0 | 45.46679409 | 9.190347404 | 2022-07-09 04:20:59 | Lombardia, Italy | |||
1421074 | 1421074 | 2022-06-08 | Italy | Lombardia | 2911719 | 40614 | 0 | 45.46679409 | 9.190347404 | 2022-06-09 04:20:54 | Lombardia, Italy | |||
1432537 | 1432537 | 2021-12-28 | Italy | Lombardia | 1104058 | 34980 | 0 | 45.46679409 | 9.190347404 | 2021-12-29 03:21:43 | Lombardia, Italy | |||
1436554 | 1436554 | 2022-03-28 | Italy | Lombardia | 2506129 | 39197 | 0 | 45.46679409 | 9.190347404 | 2022-03-29 04:20:46 | Lombardia, Italy | |||
1464055 | 1464055 | 2022-02-10 | Italy | Lombardia | 2243482 | 37867 | 0 | 45.46679409 | 9.190347404 | 2022-02-11 04:21:09 | Lombardia, Italy | |||
1468071 | 1468071 | 2022-03-24 | Italy | Lombardia | 2479419 | 39141 | 0 | 45.46679409 | 9.190347404 | 2022-03-25 04:20:46 | Lombardia, Italy | |||
1472086 | 1472086 | 2022-01-17 | Italy | Lombardia | 1784827 | 35992 | 0 | 45.46679409 | 9.190347404 | 2022-01-18 04:21:04 | Lombardia, Italy | |||
1483542 | 1483542 | 2021-08-13 | Italy | Lombardia | 860893 | 33852 | 0 | 45.46679409 | 9.190347404 | 2021-08-14 04:21:25 | Lombardia, Italy | |||
1487557 | 1487557 | 2022-07-26 | Italy | Lombardia | 3337390 | 41403 | 0 | 45.46679409 | 9.190347404 | 2022-07-27 04:21:04 | Lombardia, Italy | |||
1491572 | 1491572 | 2021-10-12 | Italy | Lombardia | 887200 | 34093 | 0 | 45.46679409 | 9.190347404 | 2021-10-13 04:20:51 | Lombardia, Italy | |||
1503570 | 1503570 | 2022-05-16 | Italy | Lombardia | 2847027 | 40305 | 0 | 45.46679409 | 9.190347404 | 2022-05-17 04:20:59 | Lombardia, Italy |
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]);