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 recovered
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-11-12 | Italy | Lombardia | 903172 | 34222 | 0 | 45.46679409 | 9.190347404 | 2021-11-13 04:21:38 | Lombardia, Italy | |||
2022-12-04 | Italy | Lombardia | 3961860 | 43851 | 0 | 45.46679409 | 9.190347404 | 2022-12-05 04:20:58 | Lombardia, Italy | |||
2021-11-20 | Italy | Lombardia | 914572 | 34278 | 0 | 45.46679409 | 9.190347404 | 2021-11-21 04:22:13 | Lombardia, Italy | |||
2021-12-27 | Italy | Lombardia | 1075263 | 34952 | 0 | 45.46679409 | 9.190347404 | 2021-12-28 04:21:47 | Lombardia, Italy | |||
2022-04-23 | Italy | Lombardia | 2717998 | 39791 | 0 | 45.46679409 | 9.190347404 | 2022-04-24 04:20:56 | Lombardia, Italy | |||
2021-11-26 | Italy | Lombardia | 925051 | 34330 | 0 | 45.46679409 | 9.190347404 | 2021-11-27 04:22:45 | Lombardia, Italy | |||
2021-10-23 | Italy | Lombardia | 890932 | 34137 | 0 | 45.46679409 | 9.190347404 | 2021-10-24 04:21:22 | Lombardia, Italy | |||
2021-12-13 | Italy | Lombardia | 966856 | 34599 | 0 | 45.46679409 | 9.190347404 | 2021-12-14 04:22:38 | Lombardia, Italy | |||
2022-10-24 | Italy | Lombardia | 3745325 | 42964 | 0 | 45.46679409 | 9.190347404 | 2022-10-25 04:21:53 | Lombardia, Italy | |||
2021-12-22 | Italy | Lombardia | 1019298 | 34814 | 0 | 45.46679409 | 9.190347404 | 2021-12-23 04:21:21 | Lombardia, Italy | |||
2021-09-20 | Italy | Lombardia | 879789 | 33983 | 0 | 45.46679409 | 9.190347404 | 2021-09-21 04:21:26 | Lombardia, Italy | |||
2022-12-02 | Italy | Lombardia | 3961860 | 43851 | 0 | 45.46679409 | 9.190347404 | 2022-12-03 04:21:02 | Lombardia, Italy | |||
2022-11-02 | Italy | Lombardia | 3778186 | 43086 | 0 | 45.46679409 | 9.190347404 | 2022-11-03 04:22:05 | Lombardia, Italy | |||
2022-09-30 | Italy | Lombardia | 3573539 | 42546 | 0 | 45.46679409 | 9.190347404 | 2022-10-01 04:23:01 | Lombardia, Italy | |||
2022-12-11 | Italy | Lombardia | 3997099 | 44073 | 0 | 45.46679409 | 9.190347404 | 2022-12-12 04:21:01 | Lombardia, Italy | |||
2022-03-27 | Italy | Lombardia | 2503411 | 39189 | 0 | 45.46679409 | 9.190347404 | 2022-03-28 04:20:33 | Lombardia, Italy | |||
2022-08-05 | Italy | Lombardia | 3397420 | 41708 | 0 | 45.46679409 | 9.190347404 | 2022-08-06 04:20:56 | Lombardia, Italy | |||
2022-07-24 | Italy | Lombardia | 3321929 | 41320 | 0 | 45.46679409 | 9.190347404 | 2022-07-25 04:20:51 | Lombardia, Italy | |||
2022-07-22 | Italy | Lombardia | 3306888 | 41258 | 0 | 45.46679409 | 9.190347404 | 2022-07-23 04:20:53 | Lombardia, Italy | |||
2021-11-24 | Italy | Lombardia | 920540 | 34311 | 0 | 45.46679409 | 9.190347404 | 2021-11-25 04:22:33 | Lombardia, Italy | |||
2022-10-29 | Italy | Lombardia | 3778186 | 43086 | 0 | 45.46679409 | 9.190347404 | 2022-10-30 04:22:14 | Lombardia, Italy | |||
2022-03-08 | Italy | Lombardia | 2367735 | 38831 | 0 | 45.46679409 | 9.190347404 | 2022-03-09 04:20:59 | Lombardia, Italy | |||
2021-10-16 | Italy | Lombardia | 888500 | 34112 | 0 | 45.46679409 | 9.190347404 | 2021-10-17 04:21:29 | Lombardia, Italy | |||
2022-06-25 | Italy | Lombardia | 3001758 | 40773 | 0 | 45.46679409 | 9.190347404 | 2022-06-26 04:21:02 | Lombardia, Italy | |||
2022-02-28 | Italy | Lombardia | 2332560 | 38603 | 0 | 45.46679409 | 9.190347404 | 2022-03-01 04:21:09 | Lombardia, Italy | |||
2022-06-14 | Italy | Lombardia | 2931043 | 40691 | 0 | 45.46679409 | 9.190347404 | 2022-06-15 04:20:54 | Lombardia, Italy | |||
2022-03-12 | Italy | Lombardia | 2390493 | 38921 | 0 | 45.46679409 | 9.190347404 | 2022-03-13 04:20:49 | Lombardia, Italy | |||
2022-07-19 | Italy | Lombardia | 3275909 | 41170 | 0 | 45.46679409 | 9.190347404 | 2022-07-20 04:20:59 | Lombardia, Italy | |||
2022-09-09 | Italy | Lombardia | 3495958 | 42351 | 0 | 45.46679409 | 9.190347404 | 2022-09-10 04:21:10 | Lombardia, Italy | |||
2022-06-01 | Italy | Lombardia | 2895171 | 40552 | 0 | 45.46679409 | 9.190347404 | 2022-06-02 05:20:39 | Lombardia, Italy | |||
2022-02-01 | Italy | Lombardia | 2148470 | 37241 | 0 | 45.46679409 | 9.190347404 | 2022-02-02 04:21:09 | Lombardia, Italy | |||
2021-10-04 | Italy | Lombardia | 884920 | 34060 | 0 | 45.46679409 | 9.190347404 | 2021-10-05 04:21:27 | Lombardia, Italy | |||
2022-08-16 | Italy | Lombardia | 3428161 | 41987 | 0 | 45.46679409 | 9.190347404 | 2022-08-17 04:20:59 | Lombardia, Italy | |||
2021-11-21 | Italy | Lombardia | 916003 | 34280 | 0 | 45.46679409 | 9.190347404 | 2021-11-22 04:22:20 | Lombardia, Italy | |||
2022-12-24 | Italy | Lombardia | 4043487 | 44489 | 0 | 45.46679409 | 9.190347404 | 2022-12-25 04:21:04 | Lombardia, Italy | |||
2022-11-04 | Italy | Lombardia | 3797984 | 43188 | 0 | 45.46679409 | 9.190347404 | 2022-11-05 04:21:52 | Lombardia, Italy | |||
2021-12-06 | Italy | Lombardia | 947099 | 34470 | 0 | 45.46679409 | 9.190347404 | 2021-12-07 04:22:34 | Lombardia, Italy | |||
2022-11-06 | Italy | Lombardia | 3797984 | 43188 | 0 | 45.46679409 | 9.190347404 | 2022-11-07 04:21:26 | Lombardia, Italy | |||
2022-02-23 | Italy | Lombardia | 2313594 | 38423 | 0 | 45.46679409 | 9.190347404 | 2022-02-24 04:21:14 | Lombardia, Italy | |||
2022-07-28 | Italy | Lombardia | 3353664 | 41463 | 0 | 45.46679409 | 9.190347404 | 2022-07-29 04:20:45 | Lombardia, Italy | |||
2022-08-07 | Italy | Lombardia | 3404893 | 41779 | 0 | 45.46679409 | 9.190347404 | 2022-08-08 04:21:08 | Lombardia, Italy | |||
2022-12-28 | Italy | Lombardia | 4043487 | 44489 | 0 | 45.46679409 | 9.190347404 | 2022-12-29 04:21:01 | Lombardia, Italy | |||
2021-12-09 | Italy | Lombardia | 954741 | 34524 | 0 | 45.46679409 | 9.190347404 | 2021-12-10 04:22:28 | Lombardia, Italy | |||
2022-08-09 | Italy | Lombardia | 3411536 | 41826 | 0 | 45.46679409 | 9.190347404 | 2022-08-10 04:20:57 | Lombardia, Italy | |||
2022-08-03 | Italy | Lombardia | 3387359 | 41633 | 0 | 45.46679409 | 9.190347404 | 2022-08-04 04:20:58 | Lombardia, Italy | |||
2022-05-21 | Italy | Lombardia | 2869121 | 40408 | 0 | 45.46679409 | 9.190347404 | 2022-05-22 04:20:52 | Lombardia, Italy | |||
2022-01-11 | Italy | Lombardia | 1600333 | 35519 | 0 | 45.46679409 | 9.190347404 | 2022-01-12 04:21:44 | Lombardia, Italy | |||
2021-08-06 | Italy | Lombardia | 856667 | 33836 | 0 | 45.46679409 | 9.190347404 | 2021-08-07 04:21:30 | Lombardia, Italy | |||
2022-01-23 | Italy | Lombardia | 1979100 | 36527 | 0 | 45.46679409 | 9.190347404 | 2022-01-24 04:21:12 | Lombardia, Italy | |||
2021-12-01 | Italy | Lombardia | 935047 | 34396 | 0 | 45.46679409 | 9.190347404 | 2021-12-02 04:22:37 | Lombardia, Italy | |||
2022-12-12 | Italy | Lombardia | 3997099 | 44073 | 0 | 45.46679409 | 9.190347404 | 2022-12-13 04:21:01 | Lombardia, Italy | |||
2022-04-29 | Italy | Lombardia | 2758419 | 39915 | 0 | 45.46679409 | 9.190347404 | 2022-04-30 04:21:05 | Lombardia, Italy | |||
2022-08-18 | Italy | Lombardia | 3435844 | 42014 | 0 | 45.46679409 | 9.190347404 | 2022-08-19 04:20:54 | Lombardia, Italy | |||
2022-05-20 | Italy | Lombardia | 2865834 | 40384 | 0 | 45.46679409 | 9.190347404 | 2022-05-21 04:20:58 | Lombardia, Italy | |||
2022-05-18 | Italy | Lombardia | 2858315 | 40342 | 0 | 45.46679409 | 9.190347404 | 2022-05-19 04:20:54 | Lombardia, Italy | |||
2022-07-06 | Italy | Lombardia | 3119042 | 40898 | 0 | 45.46679409 | 9.190347404 | 2022-07-07 04:20:55 | Lombardia, Italy | |||
2022-07-11 | Italy | Lombardia | 3170752 | 40988 | 0 | 45.46679409 | 9.190347404 | 2022-07-12 04:20:51 | Lombardia, Italy | |||
2022-01-08 | Italy | Lombardia | 1500339 | 35365 | 0 | 45.46679409 | 9.190347404 | 2022-01-09 04:21:46 | Lombardia, Italy | |||
2022-04-14 | Italy | Lombardia | 2649677 | 39540 | 0 | 45.46679409 | 9.190347404 | 2022-04-15 04:20:57 | Lombardia, Italy | |||
2022-01-24 | Italy | Lombardia | 1987944 | 36614 | 0 | 45.46679409 | 9.190347404 | 2022-01-25 04:21:05 | Lombardia, Italy | |||
2021-11-28 | Italy | Lombardia | 929470 | 34349 | 0 | 45.46679409 | 9.190347404 | 2021-11-29 04:22:30 | Lombardia, Italy | |||
2021-09-27 | Italy | Lombardia | 882560 | 34026 | 0 | 45.46679409 | 9.190347404 | 2021-09-28 04:21:28 | Lombardia, Italy | |||
2022-11-28 | Italy | Lombardia | 3918510 | 43662 | 0 | 45.46679409 | 9.190347404 | 2022-11-29 04:21:05 | Lombardia, Italy | |||
2022-08-23 | Italy | Lombardia | 3449600 | 42123 | 0 | 45.46679409 | 9.190347404 | 2022-08-24 04:20:46 | Lombardia, Italy | |||
2021-12-20 | Italy | Lombardia | 1000437 | 34776 | 0 | 45.46679409 | 9.190347404 | 2021-12-21 03:21:27 | Lombardia, Italy | |||
2021-12-18 | Italy | Lombardia | 992464 | 34718 | 0 | 45.46679409 | 9.190347404 | 2021-12-19 04:21:11 | Lombardia, Italy | |||
2021-09-09 | Italy | Lombardia | 874671 | 33945 | 0 | 45.46679409 | 9.190347404 | 2021-09-10 04:21:20 | Lombardia, Italy | |||
2021-10-03 | Italy | Lombardia | 884814 | 34054 | 0 | 45.46679409 | 9.190347404 | 2021-10-04 04:21:31 | Lombardia, Italy | |||
2022-01-05 | Italy | Lombardia | 1380171 | 35240 | 0 | 45.46679409 | 9.190347404 | 2022-01-06 04:22:09 | Lombardia, Italy | |||
2022-01-04 | Italy | Lombardia | 1328584 | 35193 | 0 | 45.46679409 | 9.190347404 | 2022-01-05 04:21:59 | Lombardia, Italy | |||
2022-02-05 | Italy | Lombardia | 2202033 | 37569 | 0 | 45.46679409 | 9.190347404 | 2022-02-06 04:21:00 | Lombardia, Italy | |||
2022-02-17 | Italy | Lombardia | 2284163 | 38178 | 0 | 45.46679409 | 9.190347404 | 2022-02-18 04:21:04 | Lombardia, Italy | |||
2022-05-27 | Italy | Lombardia | 2884764 | 40501 | 0 | 45.46679409 | 9.190347404 | 2022-05-28 04:21:07 | Lombardia, Italy | |||
2022-01-26 | Italy | Lombardia | 2044124 | 36758 | 0 | 45.46679409 | 9.190347404 | 2022-01-27 04:21:19 | Lombardia, Italy | |||
2021-11-14 | Italy | Lombardia | 905429 | 34240 | 0 | 45.46679409 | 9.190347404 | 2021-11-15 04:21:36 | Lombardia, Italy | |||
2022-04-26 | Italy | Lombardia | 2729044 | 39854 | 0 | 45.46679409 | 9.190347404 | 2022-04-27 04:20:52 | Lombardia, Italy | |||
2021-09-28 | Italy | Lombardia | 882905 | 34032 | 0 | 45.46679409 | 9.190347404 | 2021-09-29 04:21:45 | Lombardia, Italy | |||
2021-08-11 | Italy | Lombardia | 859553 | 33845 | 0 | 45.46679409 | 9.190347404 | 2021-08-12 04:21:25 | Lombardia, Italy | |||
2022-08-10 | Italy | Lombardia | 3415276 | 41839 | 0 | 45.46679409 | 9.190347404 | 2022-08-11 04:20:49 | Lombardia, Italy | |||
2021-11-27 | Italy | Lombardia | 926977 | 34344 | 0 | 45.46679409 | 9.190347404 | 2021-11-28 04:22:43 | Lombardia, Italy | |||
2022-02-08 | Italy | Lombardia | 2225713 | 37763 | 0 | 45.46679409 | 9.190347404 | 2022-02-09 04:21:04 | Lombardia, Italy | |||
2022-10-28 | Italy | Lombardia | 3773197 | 43061 | 0 | 45.46679409 | 9.190347404 | 2022-10-29 04:21:13 | Lombardia, Italy | |||
2022-09-21 | Italy | Lombardia | 3528736 | 42449 | 0 | 45.46679409 | 9.190347404 | 2022-09-22 04:22:56 | Lombardia, Italy | |||
2021-09-15 | Italy | Lombardia | 877593 | 33968 | 0 | 45.46679409 | 9.190347404 | 2021-09-16 04:22:19 | Lombardia, Italy | |||
2021-09-13 | Italy | Lombardia | 876530 | 33956 | 0 | 45.46679409 | 9.190347404 | 2021-09-14 04:21:41 | Lombardia, Italy | |||
2022-01-07 | Italy | Lombardia | 1451531 | 35345 | 0 | 45.46679409 | 9.190347404 | 2022-01-08 04:21:53 | Lombardia, Italy | |||
2022-09-02 | Italy | Lombardia | 3479160 | 42267 | 0 | 45.46679409 | 9.190347404 | 2022-09-03 04:21:04 | Lombardia, Italy | |||
2022-05-06 | Italy | Lombardia | 2800489 | 40094 | 0 | 45.46679409 | 9.190347404 | 2022-05-07 04:21:09 | Lombardia, Italy | |||
2022-08-02 | Italy | Lombardia | 3381787 | 41613 | 0 | 45.46679409 | 9.190347404 | 2022-08-03 04:20:59 | Lombardia, Italy | |||
2022-07-08 | Italy | Lombardia | 3145145 | 40923 | 0 | 45.46679409 | 9.190347404 | 2022-07-09 04:20:59 | Lombardia, Italy | |||
2022-06-08 | Italy | Lombardia | 2911719 | 40614 | 0 | 45.46679409 | 9.190347404 | 2022-06-09 04:20:54 | Lombardia, Italy | |||
2021-12-28 | Italy | Lombardia | 1104058 | 34980 | 0 | 45.46679409 | 9.190347404 | 2021-12-29 03:21:43 | Lombardia, Italy | |||
2022-03-28 | Italy | Lombardia | 2506129 | 39197 | 0 | 45.46679409 | 9.190347404 | 2022-03-29 04:20:46 | Lombardia, Italy | |||
2022-02-10 | Italy | Lombardia | 2243482 | 37867 | 0 | 45.46679409 | 9.190347404 | 2022-02-11 04:21:09 | Lombardia, Italy | |||
2022-03-24 | Italy | Lombardia | 2479419 | 39141 | 0 | 45.46679409 | 9.190347404 | 2022-03-25 04:20:46 | Lombardia, Italy | |||
2022-01-17 | Italy | Lombardia | 1784827 | 35992 | 0 | 45.46679409 | 9.190347404 | 2022-01-18 04:21:04 | Lombardia, Italy | |||
2021-08-13 | Italy | Lombardia | 860893 | 33852 | 0 | 45.46679409 | 9.190347404 | 2021-08-14 04:21:25 | Lombardia, Italy | |||
2022-07-26 | Italy | Lombardia | 3337390 | 41403 | 0 | 45.46679409 | 9.190347404 | 2022-07-27 04:21:04 | Lombardia, Italy | |||
2021-10-12 | Italy | Lombardia | 887200 | 34093 | 0 | 45.46679409 | 9.190347404 | 2021-10-13 04:20:51 | Lombardia, Italy | |||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;