johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and latitude = "43.10675841" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2235364 | 2235364 | 2022-06-12 | Italy | Umbria | 291027 | 1871 | 0 | 43.10675841 | 12.38824698 | 2022-06-13 04:21:14 | Umbria, Italy | |||
3141562 | 3141562 | 2022-06-11 | Italy | Umbria | 290620 | 1868 | 0 | 43.10675841 | 12.38824698 | 2022-06-12 04:20:53 | Umbria, Italy | |||
1944478 | 1944478 | 2022-06-10 | Italy | Umbria | 290198 | 1853 | 0 | 43.10675841 | 12.38824698 | 2022-06-11 04:21:01 | Umbria, Italy | |||
3157617 | 3157617 | 2022-06-09 | Italy | Umbria | 289795 | 1852 | 0 | 43.10675841 | 12.38824698 | 2022-06-10 04:20:55 | Umbria, Italy | |||
1421084 | 1421084 | 2022-06-08 | Italy | Umbria | 289321 | 1852 | 0 | 43.10675841 | 12.38824698 | 2022-06-09 04:20:54 | Umbria, Italy | |||
3726198 | 3726198 | 2022-06-07 | Italy | Umbria | 288873 | 1852 | 0 | 43.10675841 | 12.38824698 | 2022-06-08 04:20:55 | Umbria, Italy | |||
3887600 | 3887600 | 2022-06-06 | Italy | Umbria | 288397 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-06-07 04:21:08 | Umbria, Italy | |||
3507369 | 3507369 | 2022-06-05 | Italy | Umbria | 288217 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-06-06 04:20:57 | Umbria, Italy | |||
3527446 | 3527446 | 2022-06-04 | Italy | Umbria | 287882 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-06-05 04:20:55 | Umbria, Italy | |||
3133532 | 3133532 | 2022-06-03 | Italy | Umbria | 287477 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-06-04 04:20:58 | Umbria, Italy | |||
3578607 | 3578607 | 2022-06-02 | Italy | Umbria | 287283 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-06-03 04:20:58 | Umbria, Italy | |||
970900 | 970900 | 2022-06-01 | Italy | Umbria | 286863 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-06-02 05:20:39 | Umbria, Italy | |||
229207 | 229207 | 2022-05-31 | Italy | Umbria | 286443 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-06-01 04:20:55 | Umbria, Italy | |||
3185972 | 3185972 | 2022-05-30 | Italy | Umbria | 286046 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-05-31 04:20:51 | Umbria, Italy | |||
3198121 | 3198121 | 2022-05-29 | Italy | Umbria | 285892 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-05-30 04:20:50 | Umbria, Italy | |||
2724999 | 2724999 | 2022-05-28 | Italy | Umbria | 285416 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-05-29 04:20:53 | Umbria, Italy | |||
1314180 | 1314180 | 2022-05-27 | Italy | Umbria | 285211 | 1851 | 0 | 43.10675841 | 12.38824698 | 2022-05-28 04:21:07 | Umbria, Italy | |||
1849972 | 1849972 | 2022-05-26 | Italy | Umbria | 284770 | 1847 | 0 | 43.10675841 | 12.38824698 | 2022-05-27 04:20:56 | Umbria, Italy | |||
2047848 | 2047848 | 2022-05-25 | Italy | Umbria | 284344 | 1842 | 0 | 43.10675841 | 12.38824698 | 2022-05-26 04:20:50 | Umbria, Italy | |||
2999286 | 2999286 | 2022-05-24 | Italy | Umbria | 283885 | 1842 | 0 | 43.10675841 | 12.38824698 | 2022-05-25 04:20:56 | Umbria, Italy | |||
3593007 | 3593007 | 2022-05-23 | Italy | Umbria | 283385 | 1842 | 0 | 43.10675841 | 12.38824698 | 2022-05-24 04:20:57 | Umbria, Italy | |||
621859 | 621859 | 2022-05-22 | Italy | Umbria | 284344 | 1842 | 0 | 43.10675841 | 12.38824698 | 2022-05-26 04:20:50 | Umbria, Italy | |||
1109555 | 1109555 | 2022-05-21 | Italy | Umbria | 282754 | 1842 | 0 | 43.10675841 | 12.38824698 | 2022-05-22 04:20:52 | Umbria, Italy | |||
1169179 | 1169179 | 2022-05-20 | Italy | Umbria | 282234 | 1842 | 0 | 43.10675841 | 12.38824698 | 2022-05-21 04:20:58 | Umbria, Italy | |||
3895942 | 3895942 | 2022-05-19 | Italy | Umbria | 281668 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-20 04:20:57 | Umbria, Italy | |||
1184726 | 1184726 | 2022-05-18 | Italy | Umbria | 281007 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-19 04:20:54 | Umbria, Italy | |||
3582623 | 3582623 | 2022-05-17 | Italy | Umbria | 280331 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-18 04:20:50 | Umbria, Italy | |||
1503580 | 1503580 | 2022-05-16 | Italy | Umbria | 279637 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-17 04:20:59 | Umbria, Italy | |||
2083939 | 2083939 | 2022-05-15 | Italy | Umbria | 279357 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-16 04:20:47 | Umbria, Italy | |||
3354650 | 3354650 | 2022-05-14 | Italy | Umbria | 278706 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-15 04:20:53 | Umbria, Italy | |||
658295 | 658295 | 2022-05-13 | Italy | Umbria | 278059 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-14 04:20:48 | Umbria, Italy | |||
2533378 | 2533378 | 2022-05-12 | Italy | Umbria | 277339 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-13 04:20:51 | Umbria, Italy | |||
3444824 | 3444824 | 2022-05-11 | Italy | Umbria | 276511 | 1838 | 0 | 43.10675841 | 12.38824698 | 2022-05-12 04:20:54 | Umbria, Italy | |||
3535441 | 3535441 | 2022-05-10 | Italy | Umbria | 275722 | 1837 | 0 | 43.10675841 | 12.38824698 | 2022-05-11 04:20:48 | Umbria, Italy | |||
221976 | 221976 | 2022-05-09 | Italy | Umbria | 274861 | 1837 | 0 | 43.10675841 | 12.38824698 | 2022-05-10 04:20:50 | Umbria, Italy | |||
2331361 | 2331361 | 2022-05-08 | Italy | Umbria | 274502 | 1837 | 0 | 43.10675841 | 12.38824698 | 2022-05-09 04:20:54 | Umbria, Italy | |||
360323 | 360323 | 2022-05-07 | Italy | Umbria | 273797 | 1836 | 0 | 43.10675841 | 12.38824698 | 2022-05-08 04:20:49 | Umbria, Italy | |||
1397674 | 1397674 | 2022-05-06 | Italy | Umbria | 273051 | 1836 | 0 | 43.10675841 | 12.38824698 | 2022-05-07 04:21:09 | Umbria, Italy | |||
2598029 | 2598029 | 2022-05-05 | Italy | Umbria | 272125 | 1836 | 0 | 43.10675841 | 12.38824698 | 2022-05-06 04:21:00 | Umbria, Italy | |||
3265478 | 3265478 | 2022-05-04 | Italy | Umbria | 271236 | 1835 | 0 | 43.10675841 | 12.38824698 | 2022-05-05 04:20:55 | Umbria, Italy | |||
1572117 | 1572117 | 2022-05-03 | Italy | Umbria | 270343 | 1834 | 0 | 43.10675841 | 12.38824698 | 2022-05-04 04:20:59 | Umbria, Italy | |||
463377 | 463377 | 2022-05-02 | Italy | Umbria | 269399 | 1834 | 0 | 43.10675841 | 12.38824698 | 2022-05-03 04:21:00 | Umbria, Italy | |||
3916016 | 3916016 | 2022-05-01 | Italy | Umbria | 269015 | 1834 | 0 | 43.10675841 | 12.38824698 | 2022-05-02 04:21:10 | Umbria, Italy | |||
2840820 | 2840820 | 2022-04-30 | Italy | Umbria | 268201 | 1834 | 0 | 43.10675841 | 12.38824698 | 2022-05-01 04:20:57 | Umbria, Italy | |||
1157133 | 1157133 | 2022-04-29 | Italy | Umbria | 267223 | 1834 | 0 | 43.10675841 | 12.38824698 | 2022-04-30 04:21:05 | Umbria, Italy | |||
1696315 | 1696315 | 2022-04-28 | Italy | Umbria | 266081 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-29 04:20:59 | Umbria, Italy | |||
3851798 | 3851798 | 2022-04-27 | Italy | Umbria | 264453 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-28 04:20:47 | Umbria, Italy | |||
1326228 | 1326228 | 2022-04-26 | Italy | Umbria | 263326 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-27 04:20:52 | Umbria, Italy | |||
3722182 | 3722182 | 2022-04-25 | Italy | Umbria | 262916 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-26 04:20:51 | Umbria, Italy | |||
2028750 | 2028750 | 2022-04-24 | Italy | Umbria | 262399 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-25 04:20:56 | Umbria, Italy | |||
746325 | 746325 | 2022-04-23 | Italy | Umbria | 261296 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-24 04:20:56 | Umbria, Italy | |||
3436810 | 3436810 | 2022-04-22 | Italy | Umbria | 259822 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-23 04:20:50 | Umbria, Italy | |||
2892395 | 2892395 | 2022-04-21 | Italy | Umbria | 258498 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-22 04:20:45 | Umbria, Italy | |||
2307267 | 2307267 | 2022-04-20 | Italy | Umbria | 257015 | 1831 | 0 | 43.10675841 | 12.38824698 | 2022-04-21 04:20:46 | Umbria, Italy | |||
2251406 | 2251406 | 2022-04-19 | Italy | Umbria | 255367 | 1826 | 0 | 43.10675841 | 12.38824698 | 2022-04-20 04:20:45 | Umbria, Italy | |||
1845956 | 1845956 | 2022-04-18 | Italy | Umbria | 254929 | 1826 | 0 | 43.10675841 | 12.38824698 | 2022-04-19 04:21:00 | Umbria, Italy | |||
3416900 | 3416900 | 2022-04-17 | Italy | Umbria | 254477 | 1826 | 0 | 43.10675841 | 12.38824698 | 2022-04-18 04:21:12 | Umbria, Italy | |||
303849 | 303849 | 2022-04-16 | Italy | Umbria | 253506 | 1826 | 0 | 43.10675841 | 12.38824698 | 2022-04-17 04:20:59 | Umbria, Italy | |||
2669794 | 2669794 | 2022-04-15 | Italy | Umbria | 252343 | 1826 | 0 | 43.10675841 | 12.38824698 | 2022-04-16 04:20:48 | Umbria, Italy | |||
1223579 | 1223579 | 2022-04-14 | Italy | Umbria | 251246 | 1826 | 0 | 43.10675841 | 12.38824698 | 2022-04-15 04:20:57 | Umbria, Italy | |||
2442737 | 2442737 | 2022-04-13 | Italy | Umbria | 250071 | 1826 | 0 | 43.10675841 | 12.38824698 | 2022-04-13 23:21:06 | Umbria, Italy | |||
1948494 | 1948494 | 2022-04-12 | Italy | Umbria | 248698 | 1825 | 0 | 43.10675841 | 12.38824698 | 2022-04-13 04:21:03 | Umbria, Italy | |||
3206247 | 3206247 | 2022-04-11 | Italy | Umbria | 247442 | 1825 | 0 | 43.10675841 | 12.38824698 | 2022-04-12 04:20:49 | Umbria, Italy | |||
1576133 | 1576133 | 2022-04-10 | Italy | Umbria | 246821 | 1825 | 0 | 43.10675841 | 12.38824698 | 2022-04-11 04:21:02 | Umbria, Italy | |||
1652375 | 1652375 | 2022-04-09 | Italy | Umbria | 245691 | 1824 | 0 | 43.10675841 | 12.38824698 | 2022-04-10 04:20:52 | Umbria, Italy | |||
2115697 | 2115697 | 2022-04-08 | Italy | Umbria | 244553 | 1824 | 0 | 43.10675841 | 12.38824698 | 2022-04-09 04:20:42 | Umbria, Italy | |||
3320221 | 3320221 | 2022-04-07 | Italy | Umbria | 243286 | 1824 | 0 | 43.10675841 | 12.38824698 | 2022-04-08 04:20:48 | Umbria, Italy | |||
2800757 | 2800757 | 2022-04-06 | Italy | Umbria | 242016 | 1824 | 0 | 43.10675841 | 12.38824698 | 2022-04-07 04:20:53 | Umbria, Italy | |||
3867526 | 3867526 | 2022-04-05 | Italy | Umbria | 240543 | 1822 | 0 | 43.10675841 | 12.38824698 | 2022-04-06 04:20:49 | Umbria, Italy | |||
2748868 | 2748868 | 2022-04-04 | Italy | Umbria | 238798 | 1818 | 0 | 43.10675841 | 12.38824698 | 2022-04-05 04:20:48 | Umbria, Italy | |||
3730214 | 3730214 | 2022-04-03 | Italy | Umbria | 238298 | 1815 | 0 | 43.10675841 | 12.38824698 | 2022-04-04 04:20:51 | Umbria, Italy | |||
499649 | 499649 | 2022-04-02 | Italy | Umbria | 237095 | 1813 | 0 | 43.10675841 | 12.38824698 | 2022-04-03 04:20:48 | Umbria, Italy | |||
3350634 | 3350634 | 2022-04-01 | Italy | Umbria | 235712 | 1808 | 0 | 43.10675841 | 12.38824698 | 2022-04-02 04:20:47 | Umbria, Italy | |||
1539939 | 1539939 | 2022-03-31 | Italy | Umbria | 234073 | 1805 | 0 | 43.10675841 | 12.38824698 | 2022-04-01 04:20:28 | Umbria, Italy | |||
2477952 | 2477952 | 2022-03-30 | Italy | Umbria | 232556 | 1801 | 0 | 43.10675841 | 12.38824698 | 2022-03-31 04:20:56 | Umbria, Italy | |||
157993 | 157993 | 2022-03-29 | Italy | Umbria | 230735 | 1799 | 0 | 43.10675841 | 12.38824698 | 2022-03-30 04:20:45 | Umbria, Italy | |||
1436564 | 1436564 | 2022-03-28 | Italy | Umbria | 228555 | 1792 | 0 | 43.10675841 | 12.38824698 | 2022-03-29 04:20:46 | Umbria, Italy | |||
876245 | 876245 | 2022-03-27 | Italy | Umbria | 227867 | 1791 | 0 | 43.10675841 | 12.38824698 | 2022-03-28 04:20:33 | Umbria, Italy | |||
2163528 | 2163528 | 2022-03-26 | Italy | Umbria | 226323 | 1788 | 0 | 43.10675841 | 12.38824698 | 2022-03-27 04:20:47 | Umbria, Italy | |||
1720464 | 1720464 | 2022-03-25 | Italy | Umbria | 224633 | 1786 | 0 | 43.10675841 | 12.38824698 | 2022-03-26 04:20:23 | Umbria, Italy | |||
1468081 | 1468081 | 2022-03-24 | Italy | Umbria | 222707 | 1782 | 0 | 43.10675841 | 12.38824698 | 2022-03-25 04:20:46 | Umbria, Italy | |||
3022255 | 3022255 | 2022-03-23 | Italy | Umbria | 220900 | 1780 | 0 | 43.10675841 | 12.38824698 | 2022-03-24 04:20:43 | Umbria, Italy | |||
1905177 | 1905177 | 2022-03-22 | Italy | Umbria | 218750 | 1778 | 0 | 43.10675841 | 12.38824698 | 2022-03-23 04:20:48 | Umbria, Italy | |||
3238308 | 3238308 | 2022-03-21 | Italy | Umbria | 216276 | 1777 | 0 | 43.10675841 | 12.38824698 | 2022-03-22 04:20:54 | Umbria, Italy | |||
24381 | 24381 | 2022-03-20 | Italy | Umbria | 215512 | 1774 | 0 | 43.10675841 | 12.38824698 | 2022-03-21 04:20:50 | Umbria, Italy | |||
1656391 | 1656391 | 2022-03-19 | Italy | Umbria | 213605 | 1772 | 0 | 43.10675841 | 12.38824698 | 2022-03-20 04:20:45 | Umbria, Italy | |||
335917 | 335917 | 2022-03-18 | Italy | Umbria | 211616 | 1772 | 0 | 43.10675841 | 12.38824698 | 2022-03-19 04:20:47 | Umbria, Italy | |||
694370 | 694370 | 2022-03-17 | Italy | Umbria | 209309 | 1770 | 0 | 43.10675841 | 12.38824698 | 2022-03-18 04:20:55 | Umbria, Italy | |||
2319313 | 2319313 | 2022-03-16 | Italy | Umbria | 206787 | 1768 | 0 | 43.10675841 | 12.38824698 | 2022-03-17 04:20:56 | Umbria, Italy | |||
261513 | 261513 | 2022-03-15 | Italy | Umbria | 204484 | 1766 | 0 | 43.10675841 | 12.38824698 | 2022-03-16 04:20:50 | Umbria, Italy | |||
2263872 | 2263872 | 2022-03-14 | Italy | Umbria | 201738 | 1762 | 0 | 43.10675841 | 12.38824698 | 2022-03-15 04:20:47 | Umbria, Italy | |||
3627938 | 3627938 | 2022-03-13 | Italy | Umbria | 200943 | 1760 | 0 | 43.10675841 | 12.38824698 | 2022-03-14 04:20:46 | Umbria, Italy | |||
950846 | 950846 | 2022-03-12 | Italy | Umbria | 199119 | 1757 | 0 | 43.10675841 | 12.38824698 | 2022-03-13 04:20:49 | Umbria, Italy | |||
356307 | 356307 | 2022-03-11 | Italy | Umbria | 197405 | 1756 | 0 | 43.10675841 | 12.38824698 | 2022-03-12 04:20:50 | Umbria, Italy | |||
1865459 | 1865459 | 2022-03-10 | Italy | Umbria | 195569 | 1756 | 0 | 43.10675841 | 12.38824698 | 2022-03-11 04:20:50 | Umbria, Italy | |||
2140154 | 2140154 | 2022-03-09 | Italy | Umbria | 193798 | 1754 | 0 | 43.10675841 | 12.38824698 | 2022-03-10 04:20:48 | Umbria, Italy | |||
919665 | 919665 | 2022-03-08 | Italy | Umbria | 192299 | 1751 | 0 | 43.10675841 | 12.38824698 | 2022-03-09 04:20:59 | Umbria, Italy | |||
1547952 | 1547952 | 2022-03-07 | Italy | Umbria | 190664 | 1750 | 0 | 43.10675841 | 12.38824698 | 2022-03-08 04:20:54 | Umbria, Italy | |||
2199621 | 2199621 | 2022-03-06 | Italy | Umbria | 190163 | 1750 | 0 | 43.10675841 | 12.38824698 | 2022-03-07 04:20:47 | Umbria, Italy | |||
2092078 | 2092078 | 2022-03-05 | Italy | Umbria | 189031 | 1749 | 0 | 43.10675841 | 12.38824698 | 2022-03-06 04:20:49 | Umbria, 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]);