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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1511379 | 1511379 | 2022-02-24 | Italy | Lombardia | 2318833 | 38468 | 0 | 45.46679409 | 9.190347404 | 2022-02-25 04:21:11 | Lombardia, Italy | |||
1531899 | 1531899 | 2022-08-26 | Italy | Lombardia | 3459038 | 42172 | 0 | 45.46679409 | 9.190347404 | 2022-08-27 04:20:57 | Lombardia, Italy | |||
1539929 | 1539929 | 2022-03-31 | Italy | Lombardia | 2537267 | 39261 | 0 | 45.46679409 | 9.190347404 | 2022-04-01 04:20:28 | Lombardia, Italy | |||
1547942 | 1547942 | 2022-03-07 | Italy | Lombardia | 2361238 | 38822 | 0 | 45.46679409 | 9.190347404 | 2022-03-08 04:20:54 | Lombardia, Italy | |||
1560063 | 1560063 | 2022-09-28 | Italy | Lombardia | 3560415 | 42532 | 0 | 45.46679409 | 9.190347404 | 2022-09-29 04:22:34 | Lombardia, Italy | |||
1572107 | 1572107 | 2022-05-03 | Italy | Lombardia | 2781909 | 40033 | 0 | 45.46679409 | 9.190347404 | 2022-05-04 04:20:59 | Lombardia, Italy | |||
1576123 | 1576123 | 2022-04-10 | Italy | Lombardia | 2617945 | 39461 | 0 | 45.46679409 | 9.190347404 | 2022-04-11 04:21:02 | Lombardia, Italy | |||
1592178 | 1592178 | 2022-10-21 | Italy | Lombardia | 3732878 | 42898 | 0 | 45.46679409 | 9.190347404 | 2022-10-22 04:22:53 | Lombardia, Italy | |||
1596193 | 1596193 | 2021-08-26 | Italy | Lombardia | 867243 | 33898 | 0 | 45.46679409 | 9.190347404 | 2021-08-27 04:21:37 | Lombardia, Italy | |||
1604218 | 1604218 | 2021-08-16 | Italy | Lombardia | 862040 | 33860 | 0 | 45.46679409 | 9.190347404 | 2021-08-17 04:21:49 | Lombardia, Italy | |||
1608233 | 1608233 | 2022-07-20 | Italy | Lombardia | 3287127 | 41185 | 0 | 45.46679409 | 9.190347404 | 2022-07-21 04:21:10 | Lombardia, Italy | |||
1620244 | 1620244 | 2022-11-22 | Italy | Lombardia | 3873641 | 43509 | 0 | 45.46679409 | 9.190347404 | 2022-11-23 04:21:06 | Lombardia, Italy | |||
1624260 | 1624260 | 2022-09-22 | Italy | Lombardia | 3532577 | 42461 | 0 | 45.46679409 | 9.190347404 | 2022-09-23 04:23:13 | Lombardia, Italy | |||
1628276 | 1628276 | 2022-12-18 | Italy | Lombardia | 4023176 | 44243 | 0 | 45.46679409 | 9.190347404 | 2022-12-19 04:21:03 | Lombardia, Italy | |||
1640317 | 1640317 | 2022-11-20 | Italy | Lombardia | 3873641 | 43509 | 0 | 45.46679409 | 9.190347404 | 2022-11-21 04:21:05 | Lombardia, Italy | |||
1644333 | 1644333 | 2022-03-03 | Italy | Lombardia | 2347405 | 38689 | 0 | 45.46679409 | 9.190347404 | 2022-03-04 04:21:09 | Lombardia, Italy | |||
1648349 | 1648349 | 2022-06-23 | Italy | Lombardia | 2985341 | 40753 | 0 | 45.46679409 | 9.190347404 | 2022-06-24 04:20:58 | Lombardia, Italy | |||
1652365 | 1652365 | 2022-04-09 | Italy | Lombardia | 2611334 | 39440 | 0 | 45.46679409 | 9.190347404 | 2022-04-10 04:20:52 | Lombardia, Italy | |||
1656381 | 1656381 | 2022-03-19 | Italy | Lombardia | 2440620 | 39043 | 0 | 45.46679409 | 9.190347404 | 2022-03-20 04:20:45 | Lombardia, Italy | |||
1660396 | 1660396 | 2021-12-12 | Italy | Lombardia | 965517 | 34576 | 0 | 45.46679409 | 9.190347404 | 2021-12-13 04:22:02 | Lombardia, Italy | |||
1664412 | 1664412 | 2021-12-11 | Italy | Lombardia | 962239 | 34566 | 0 | 45.46679409 | 9.190347404 | 2021-12-12 04:22:12 | Lombardia, Italy | |||
1668428 | 1668428 | 2021-12-29 | Italy | Lombardia | 1136754 | 35008 | 0 | 45.46679409 | 9.190347404 | 2021-12-30 04:21:25 | Lombardia, Italy | |||
1680473 | 1680473 | 2022-08-29 | Italy | Lombardia | 3465419 | 42218 | 0 | 45.46679409 | 9.190347404 | 2022-08-30 04:21:03 | Lombardia, Italy | |||
1692288 | 1692288 | 2022-01-10 | Italy | Lombardia | 1554778 | 35464 | 0 | 45.46679409 | 9.190347404 | 2022-01-11 04:22:01 | Lombardia, Italy | |||
1696305 | 1696305 | 2022-04-28 | Italy | Lombardia | 2750788 | 39889 | 0 | 45.46679409 | 9.190347404 | 2022-04-29 04:20:59 | Lombardia, Italy | |||
1700320 | 1700320 | 2022-01-03 | Italy | Lombardia | 1278480 | 35159 | 0 | 45.46679409 | 9.190347404 | 2022-01-04 04:22:17 | Lombardia, Italy | |||
1716325 | 1716325 | 2021-12-16 | Italy | Lombardia | 980755 | 34668 | 0 | 45.46679409 | 9.190347404 | 2021-12-17 04:22:14 | Lombardia, Italy | |||
1720454 | 1720454 | 2022-03-25 | Italy | Lombardia | 2488096 | 39162 | 0 | 45.46679409 | 9.190347404 | 2022-03-26 04:20:23 | Lombardia, Italy | |||
1724469 | 1724469 | 2021-09-25 | Italy | Lombardia | 882120 | 34012 | 0 | 45.46679409 | 9.190347404 | 2021-09-26 04:21:29 | Lombardia, Italy | |||
1740509 | 1740509 | 2021-12-05 | Italy | Lombardia | 946094 | 34455 | 0 | 45.46679409 | 9.190347404 | 2021-12-06 04:22:34 | Lombardia, Italy | |||
1755268 | 1755268 | 2022-11-18 | Italy | Lombardia | 3873641 | 43509 | 0 | 45.46679409 | 9.190347404 | 2022-11-19 04:21:14 | Lombardia, Italy | |||
1763298 | 1763298 | 2022-06-20 | Italy | Lombardia | 2957633 | 40727 | 0 | 45.46679409 | 9.190347404 | 2022-06-21 04:20:56 | Lombardia, Italy | |||
1767314 | 1767314 | 2022-07-03 | Italy | Lombardia | 3083075 | 40875 | 0 | 45.46679409 | 9.190347404 | 2022-07-04 04:20:54 | Lombardia, Italy | |||
1775343 | 1775343 | 2021-08-30 | Italy | Lombardia | 868971 | 33915 | 0 | 45.46679409 | 9.190347404 | 2021-08-31 04:21:46 | Lombardia, Italy | |||
1779357 | 1779357 | 2022-01-27 | Italy | Lombardia | 2069222 | 36881 | 0 | 45.46679409 | 9.190347404 | 2022-01-28 04:21:09 | Lombardia, Italy | |||
1783485 | 1783485 | 2022-07-29 | Italy | Lombardia | 3360511 | 41509 | 0 | 45.46679409 | 9.190347404 | 2022-07-30 04:20:42 | Lombardia, Italy | |||
1802715 | 1802715 | 2021-11-25 | Italy | Lombardia | 922842 | 34323 | 0 | 45.46679409 | 9.190347404 | 2021-11-26 04:22:33 | Lombardia, Italy | |||
1810746 | 1810746 | 2022-10-05 | Italy | Lombardia | 3607020 | 42594 | 0 | 45.46679409 | 9.190347404 | 2022-10-06 04:21:22 | Lombardia, Italy | |||
1814761 | 1814761 | 2021-09-19 | Italy | Lombardia | 879639 | 33982 | 0 | 45.46679409 | 9.190347404 | 2021-09-20 04:21:22 | Lombardia, Italy | |||
1830124 | 1830124 | 2022-10-25 | Italy | Lombardia | 3755304 | 42990 | 0 | 45.46679409 | 9.190347404 | 2022-10-26 04:22:19 | Lombardia, Italy | |||
1845946 | 1845946 | 2022-04-18 | Italy | Lombardia | 2674216 | 39654 | 0 | 45.46679409 | 9.190347404 | 2022-04-19 04:21:00 | Lombardia, Italy | |||
1849962 | 1849962 | 2022-05-26 | Italy | Lombardia | 2882315 | 40480 | 0 | 45.46679409 | 9.190347404 | 2022-05-27 04:20:56 | Lombardia, Italy | |||
1853977 | 1853977 | 2021-08-20 | Italy | Lombardia | 864216 | 33875 | 0 | 45.46679409 | 9.190347404 | 2021-08-21 04:21:38 | Lombardia, Italy | |||
1865449 | 1865449 | 2022-03-10 | Italy | Lombardia | 2379131 | 38870 | 0 | 45.46679409 | 9.190347404 | 2022-03-11 04:20:50 | Lombardia, Italy | |||
1876957 | 1876957 | 2022-08-28 | Italy | Lombardia | 3464377 | 42204 | 0 | 45.46679409 | 9.190347404 | 2022-08-29 04:21:06 | Lombardia, Italy | |||
1884986 | 1884986 | 2021-09-12 | Italy | Lombardia | 876310 | 33953 | 0 | 45.46679409 | 9.190347404 | 2021-09-13 04:21:15 | Lombardia, Italy | |||
1889112 | 1889112 | 2022-09-14 | Italy | Lombardia | 3508132 | 42387 | 0 | 45.46679409 | 9.190347404 | 2022-09-15 04:21:02 | Lombardia, Italy | |||
1905167 | 1905167 | 2022-03-22 | Italy | Lombardia | 2460913 | 39092 | 0 | 45.46679409 | 9.190347404 | 2022-03-23 04:20:48 | Lombardia, Italy | |||
1909182 | 1909182 | 2021-10-17 | Italy | Lombardia | 888797 | 34114 | 0 | 45.46679409 | 9.190347404 | 2021-10-18 04:21:10 | Lombardia, Italy | |||
1921189 | 1921189 | 2021-09-24 | Italy | Lombardia | 881642 | 34004 | 0 | 45.46679409 | 9.190347404 | 2021-09-25 04:21:31 | Lombardia, Italy | |||
1940452 | 1940452 | 2022-08-06 | Italy | Lombardia | 3401748 | 41747 | 0 | 45.46679409 | 9.190347404 | 2022-08-07 04:20:54 | Lombardia, Italy | |||
1944468 | 1944468 | 2022-06-10 | Italy | Lombardia | 2918124 | 40647 | 0 | 45.46679409 | 9.190347404 | 2022-06-11 04:21:01 | Lombardia, Italy | |||
1948484 | 1948484 | 2022-04-12 | Italy | Lombardia | 2632174 | 39500 | 0 | 45.46679409 | 9.190347404 | 2022-04-13 04:21:03 | Lombardia, Italy | |||
1956513 | 1956513 | 2021-08-05 | Italy | Lombardia | 856003 | 33835 | 0 | 45.46679409 | 9.190347404 | 2021-08-06 04:21:18 | Lombardia, Italy | |||
1960527 | 1960527 | 2022-01-20 | Italy | Lombardia | 1893559 | 36257 | 0 | 45.46679409 | 9.190347404 | 2022-01-21 04:21:09 | Lombardia, Italy | |||
1964544 | 1964544 | 2022-11-30 | Italy | Lombardia | 3918510 | 43662 | 0 | 45.46679409 | 9.190347404 | 2022-12-01 04:21:03 | Lombardia, Italy | |||
1968560 | 1968560 | 2022-08-13 | Italy | Lombardia | 3424288 | 41944 | 0 | 45.46679409 | 9.190347404 | 2022-08-14 04:20:55 | Lombardia, Italy | |||
1976587 | 1976587 | 2022-09-25 | Italy | Lombardia | 3543439 | 42497 | 0 | 45.46679409 | 9.190347404 | 2022-09-26 04:20:52 | Lombardia, Italy | |||
1984617 | 1984617 | 2022-12-07 | Italy | Lombardia | 3961860 | 43851 | 0 | 45.46679409 | 9.190347404 | 2022-12-08 04:21:07 | Lombardia, Italy | |||
1992630 | 1992630 | 2022-03-01 | Italy | Lombardia | 2338306 | 38631 | 0 | 45.46679409 | 9.190347404 | 2022-03-02 04:21:07 | Lombardia, Italy | |||
2000631 | 2000631 | 2021-11-07 | Italy | Lombardia | 898787 | 34201 | 0 | 45.46679409 | 9.190347404 | 2021-11-08 04:21:43 | Lombardia, Italy | |||
2008662 | 2008662 | 2022-08-04 | Italy | Lombardia | 3392728 | 41664 | 0 | 45.46679409 | 9.190347404 | 2022-08-05 04:20:52 | Lombardia, Italy | |||
2012677 | 2012677 | 2022-02-06 | Italy | Lombardia | 2210403 | 37643 | 0 | 45.46679409 | 9.190347404 | 2022-02-07 04:21:05 | Lombardia, Italy | |||
2016694 | 2016694 | 2022-09-20 | Italy | Lombardia | 3525211 | 42443 | 0 | 45.46679409 | 9.190347404 | 2022-09-21 04:23:22 | Lombardia, Italy | |||
2024724 | 2024724 | 2022-10-17 | Italy | Lombardia | 3697105 | 42801 | 0 | 45.46679409 | 9.190347404 | 2022-10-18 04:22:42 | Lombardia, Italy | |||
2028740 | 2028740 | 2022-04-24 | Italy | Lombardia | 2723970 | 39814 | 0 | 45.46679409 | 9.190347404 | 2022-04-25 04:20:56 | Lombardia, Italy | |||
2032756 | 2032756 | 2022-10-14 | Italy | Lombardia | 3681887 | 42746 | 0 | 45.46679409 | 9.190347404 | 2022-10-15 04:22:00 | Lombardia, Italy | |||
2043821 | 2043821 | 2021-10-18 | Italy | Lombardia | 888909 | 34119 | 0 | 45.46679409 | 9.190347404 | 2021-10-19 04:20:54 | Lombardia, Italy | |||
2047838 | 2047838 | 2022-05-25 | Italy | Lombardia | 2879573 | 40453 | 0 | 45.46679409 | 9.190347404 | 2022-05-26 04:20:50 | Lombardia, Italy | |||
2051853 | 2051853 | 2022-01-25 | Italy | Lombardia | 2016316 | 36684 | 0 | 45.46679409 | 9.190347404 | 2022-01-26 04:21:07 | Lombardia, Italy | |||
2063874 | 2063874 | 2022-11-19 | Italy | Lombardia | 3873641 | 43509 | 0 | 45.46679409 | 9.190347404 | 2022-11-20 04:21:08 | Lombardia, Italy | |||
2067889 | 2067889 | 2021-08-31 | Italy | Lombardia | 869694 | 33917 | 0 | 45.46679409 | 9.190347404 | 2021-09-01 04:21:38 | Lombardia, Italy | |||
2075917 | 2075917 | 2021-09-26 | Italy | Lombardia | 882424 | 34022 | 0 | 45.46679409 | 9.190347404 | 2021-09-27 04:21:16 | Lombardia, Italy | |||
2083929 | 2083929 | 2022-05-15 | Italy | Lombardia | 2845587 | 40286 | 0 | 45.46679409 | 9.190347404 | 2022-05-16 04:20:47 | Lombardia, Italy | |||
2087944 | 2087944 | 2021-12-14 | Italy | Lombardia | 970686 | 34619 | 0 | 45.46679409 | 9.190347404 | 2021-12-15 03:22:16 | Lombardia, Italy | |||
2092068 | 2092068 | 2022-03-05 | Italy | Lombardia | 2355997 | 38758 | 0 | 45.46679409 | 9.190347404 | 2022-03-06 04:20:49 | Lombardia, Italy | |||
2096084 | 2096084 | 2022-08-27 | Italy | Lombardia | 3462011 | 42189 | 0 | 45.46679409 | 9.190347404 | 2022-08-28 04:21:02 | Lombardia, Italy | |||
2100100 | 2100100 | 2022-11-26 | Italy | Lombardia | 3918510 | 43662 | 0 | 45.46679409 | 9.190347404 | 2022-11-27 04:21:05 | Lombardia, Italy | |||
2111670 | 2111670 | 2021-12-26 | Italy | Lombardia | 1070198 | 34940 | 0 | 45.46679409 | 9.190347404 | 2021-12-27 04:21:58 | Lombardia, Italy | |||
2115687 | 2115687 | 2022-04-08 | Italy | Lombardia | 2602794 | 39423 | 0 | 45.46679409 | 9.190347404 | 2022-04-09 04:20:42 | Lombardia, Italy | |||
2123713 | 2123713 | 2021-10-21 | Italy | Lombardia | 890161 | 34131 | 0 | 45.46679409 | 9.190347404 | 2021-10-22 04:21:14 | Lombardia, Italy | |||
2131992 | 2131992 | 2021-10-01 | Italy | Lombardia | 884125 | 34049 | 0 | 45.46679409 | 9.190347404 | 2021-10-02 04:21:25 | Lombardia, Italy | |||
2136128 | 2136128 | 2022-12-01 | Italy | Lombardia | 3918510 | 43662 | 0 | 45.46679409 | 9.190347404 | 2022-12-02 04:21:07 | Lombardia, Italy | |||
2140144 | 2140144 | 2022-03-09 | Italy | Lombardia | 2373318 | 38845 | 0 | 45.46679409 | 9.190347404 | 2022-03-10 04:20:48 | Lombardia, Italy | |||
2147612 | 2147612 | 2022-06-27 | Italy | Lombardia | 3011742 | 40798 | 0 | 45.46679409 | 9.190347404 | 2022-06-28 04:20:58 | Lombardia, Italy | |||
2151628 | 2151628 | 2022-07-16 | Italy | Lombardia | 3245496 | 41103 | 0 | 45.46679409 | 9.190347404 | 2022-07-17 04:21:15 | Lombardia, Italy | |||
2159502 | 2159502 | 2022-10-16 | Italy | Lombardia | 3695241 | 42788 | 0 | 45.46679409 | 9.190347404 | 2022-10-17 04:20:31 | Lombardia, Italy | |||
2163518 | 2163518 | 2022-03-26 | Italy | Lombardia | 2496628 | 39175 | 0 | 45.46679409 | 9.190347404 | 2022-03-27 04:20:47 | Lombardia, Italy | |||
2167533 | 2167533 | 2022-01-01 | Italy | Lombardia | 1254634 | 35095 | 0 | 45.46679409 | 9.190347404 | 2022-01-02 04:20:52 | Lombardia, Italy | |||
2175539 | 2175539 | 2021-08-22 | Italy | Lombardia | 865162 | 33880 | 0 | 45.46679409 | 9.190347404 | 2021-08-23 04:21:27 | Lombardia, Italy | |||
2179554 | 2179554 | 2022-12-22 | Italy | Lombardia | 4023176 | 44243 | 0 | 45.46679409 | 9.190347404 | 2022-12-23 04:21:04 | Lombardia, Italy | |||
2187584 | 2187584 | 2022-06-22 | Italy | Lombardia | 2976834 | 40738 | 0 | 45.46679409 | 9.190347404 | 2022-06-23 04:20:55 | Lombardia, Italy | |||
2195594 | 2195594 | 2021-12-03 | Italy | Lombardia | 940476 | 34428 | 0 | 45.46679409 | 9.190347404 | 2021-12-04 04:22:18 | Lombardia, Italy | |||
2199611 | 2199611 | 2022-03-06 | Italy | Lombardia | 2359624 | 38792 | 0 | 45.46679409 | 9.190347404 | 2022-03-07 04:20:47 | Lombardia, Italy | |||
2203626 | 2203626 | 2021-08-07 | Italy | Lombardia | 857423 | 33837 | 0 | 45.46679409 | 9.190347404 | 2021-08-08 04:21:33 | Lombardia, Italy | |||
2235354 | 2235354 | 2022-06-12 | Italy | Lombardia | 2923580 | 40670 | 0 | 45.46679409 | 9.190347404 | 2022-06-13 04:21:14 | Lombardia, Italy | |||
2239370 | 2239370 | 2022-06-28 | Italy | Lombardia | 3014117 | 40807 | 0 | 45.46679409 | 9.190347404 | 2022-06-29 04:20:59 | Lombardia, Italy | |||
2251396 | 2251396 | 2022-04-19 | Italy | Lombardia | 2676545 | 39658 | 0 | 45.46679409 | 9.190347404 | 2022-04-20 04:20:45 | Lombardia, Italy | |||
2259734 | 2259734 | 2022-10-02 | Italy | Lombardia | 3584426 | 42568 | 0 | 45.46679409 | 9.190347404 | 2022-10-03 04:23:11 | Lombardia, Italy | |||
2263862 | 2263862 | 2022-03-14 | Italy | Lombardia | 2397620 | 38952 | 0 | 45.46679409 | 9.190347404 | 2022-03-15 04:20:47 | 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]);