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 = "Umbria" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016704 | 2016704 | 2022-09-20 | Italy | Umbria | 371742 | 2096 | 0 | 43.10675841 | 12.38824698 | 2022-09-21 04:23:22 | Umbria, Italy | |||
3570577 | 3570577 | 2022-09-19 | Italy | Umbria | 371271 | 2092 | 0 | 43.10675841 | 12.38824698 | 2022-09-20 04:22:48 | Umbria, Italy | |||
419316 | 419316 | 2022-09-18 | Italy | Umbria | 371122 | 2091 | 0 | 43.10675841 | 12.38824698 | 2022-09-19 04:21:49 | Umbria, Italy | |||
3373340 | 3373340 | 2022-09-17 | Italy | Umbria | 370747 | 2091 | 0 | 43.10675841 | 12.38824698 | 2022-09-18 04:22:50 | Umbria, Italy | |||
2355448 | 2355448 | 2022-09-16 | Italy | Umbria | 370390 | 2091 | 0 | 43.10675841 | 12.38824698 | 2022-09-17 04:20:19 | Umbria, Italy | |||
3986605 | 3986605 | 2022-09-15 | Italy | Umbria | 370006 | 2089 | 0 | 43.10675841 | 12.38824698 | 2022-09-16 04:21:19 | Umbria, Italy | |||
1889122 | 1889122 | 2022-09-14 | Italy | Umbria | 369601 | 2088 | 0 | 43.10675841 | 12.38824698 | 2022-09-15 04:21:02 | Umbria, Italy | |||
372177 | 372177 | 2022-09-13 | Italy | Umbria | 369228 | 2085 | 0 | 43.10675841 | 12.38824698 | 2022-09-14 04:20:44 | Umbria, Italy | |||
2394782 | 2394782 | 2022-09-12 | Italy | Umbria | 368863 | 2084 | 0 | 43.10675841 | 12.38824698 | 2022-09-13 04:20:57 | Umbria, Italy | |||
3765860 | 3765860 | 2022-09-11 | Italy | Umbria | 368724 | 2084 | 0 | 43.10675841 | 12.38824698 | 2022-09-12 04:20:58 | Umbria, Italy | |||
3824435 | 3824435 | 2022-09-10 | Italy | Umbria | 368433 | 2084 | 0 | 43.10675841 | 12.38824698 | 2022-09-11 04:20:50 | Umbria, Italy | |||
962892 | 962892 | 2022-09-09 | Italy | Umbria | 368064 | 2081 | 0 | 43.10675841 | 12.38824698 | 2022-09-10 04:21:10 | Umbria, Italy | |||
253294 | 253294 | 2022-09-08 | Italy | Umbria | 367797 | 2080 | 0 | 43.10675841 | 12.38824698 | 2022-09-09 04:21:11 | Umbria, Italy | |||
3745092 | 3745092 | 2022-09-07 | Italy | Umbria | 367471 | 2079 | 0 | 43.10675841 | 12.38824698 | 2022-09-08 04:21:02 | Umbria, Italy | |||
114732 | 114732 | 2022-09-06 | Italy | Umbria | 367168 | 2079 | 0 | 43.10675841 | 12.38824698 | 2022-09-07 04:20:59 | Umbria, Italy | |||
2633704 | 2633704 | 2022-09-05 | Italy | Umbria | 366810 | 2077 | 0 | 43.10675841 | 12.38824698 | 2022-09-06 04:21:02 | Umbria, Italy | |||
2987268 | 2987268 | 2022-09-04 | Italy | Umbria | 366711 | 2076 | 0 | 43.10675841 | 12.38824698 | 2022-09-05 04:21:01 | Umbria, Italy | |||
2712953 | 2712953 | 2022-09-03 | Italy | Umbria | 366468 | 2073 | 0 | 43.10675841 | 12.38824698 | 2022-09-04 04:21:22 | Umbria, Italy | |||
1393658 | 1393658 | 2022-09-02 | Italy | Umbria | 366149 | 2071 | 0 | 43.10675841 | 12.38824698 | 2022-09-03 04:21:04 | Umbria, Italy | |||
3547487 | 3547487 | 2022-09-01 | Italy | Umbria | 365914 | 2069 | 0 | 43.10675841 | 12.38824698 | 2022-09-02 04:21:07 | Umbria, Italy | |||
2343407 | 2343407 | 2022-08-31 | Italy | Umbria | 365549 | 2069 | 0 | 43.10675841 | 12.38824698 | 2022-09-01 04:21:03 | Umbria, Italy | |||
3773887 | 3773887 | 2022-08-30 | Italy | Umbria | 365188 | 2068 | 0 | 43.10675841 | 12.38824698 | 2022-08-31 04:20:57 | Umbria, Italy | |||
1680483 | 1680483 | 2022-08-29 | Italy | Umbria | 364793 | 2066 | 0 | 43.10675841 | 12.38824698 | 2022-08-30 04:21:03 | Umbria, Italy | |||
1876967 | 1876967 | 2022-08-28 | Italy | Umbria | 364633 | 2065 | 0 | 43.10675841 | 12.38824698 | 2022-08-29 04:21:06 | Umbria, Italy | |||
2096094 | 2096094 | 2022-08-27 | Italy | Umbria | 364334 | 2064 | 0 | 43.10675841 | 12.38824698 | 2022-08-28 04:21:02 | Umbria, Italy | |||
1531909 | 1531909 | 2022-08-26 | Italy | Umbria | 363993 | 2062 | 0 | 43.10675841 | 12.38824698 | 2022-08-27 04:20:57 | Umbria, Italy | |||
2828796 | 2828796 | 2022-08-25 | Italy | Umbria | 363672 | 2061 | 0 | 43.10675841 | 12.38824698 | 2022-08-26 04:21:02 | Umbria, Italy | |||
2323329 | 2323329 | 2022-08-24 | Italy | Umbria | 363318 | 2060 | 0 | 43.10675841 | 12.38824698 | 2022-08-25 04:21:13 | Umbria, Italy | |||
1250738 | 1250738 | 2022-08-23 | Italy | Umbria | 362909 | 2060 | 0 | 43.10675841 | 12.38824698 | 2022-08-24 04:20:46 | Umbria, Italy | |||
2852842 | 2852842 | 2022-08-22 | Italy | Umbria | 362419 | 2056 | 0 | 43.10675841 | 12.38824698 | 2022-08-23 04:20:56 | Umbria, Italy | |||
2402814 | 2402814 | 2022-08-21 | Italy | Umbria | 362229 | 2056 | 0 | 43.10675841 | 12.38824698 | 2022-08-22 04:20:38 | Umbria, Italy | |||
3797892 | 3797892 | 2022-08-20 | Italy | Umbria | 361874 | 2047 | 0 | 43.10675841 | 12.38824698 | 2022-08-21 04:20:44 | Umbria, Italy | |||
2363478 | 2363478 | 2022-08-19 | Italy | Umbria | 361475 | 2036 | 0 | 43.10675841 | 12.38824698 | 2022-08-20 04:21:01 | Umbria, Italy | |||
1161149 | 1161149 | 2022-08-18 | Italy | Umbria | 361065 | 2036 | 0 | 43.10675841 | 12.38824698 | 2022-08-19 04:20:54 | Umbria, Italy | |||
3950473 | 3950473 | 2022-08-17 | Italy | Umbria | 360578 | 2025 | 0 | 43.10675841 | 12.38824698 | 2022-08-18 04:21:11 | Umbria, Italy | |||
990975 | 990975 | 2022-08-16 | Italy | Umbria | 360005 | 2022 | 0 | 43.10675841 | 12.38824698 | 2022-08-17 04:20:59 | Umbria, Italy | |||
2494014 | 2494014 | 2022-08-15 | Italy | Umbria | 359854 | 2021 | 0 | 43.10675841 | 12.38824698 | 2022-08-16 04:20:58 | Umbria, Italy | |||
3647564 | 3647564 | 2022-08-14 | Italy | Umbria | 359638 | 2021 | 0 | 43.10675841 | 12.38824698 | 2022-08-15 04:20:59 | Umbria, Italy | |||
1968570 | 1968570 | 2022-08-13 | Italy | Umbria | 359266 | 2012 | 0 | 43.10675841 | 12.38824698 | 2022-08-14 04:20:55 | Umbria, Italy | |||
2888379 | 2888379 | 2022-08-12 | Italy | Umbria | 358821 | 2011 | 0 | 43.10675841 | 12.38824698 | 2022-08-13 04:20:52 | Umbria, Italy | |||
3907984 | 3907984 | 2022-08-11 | Italy | Umbria | 358325 | 2009 | 0 | 43.10675841 | 12.38824698 | 2022-08-12 04:20:54 | Umbria, Italy | |||
1346301 | 1346301 | 2022-08-10 | Italy | Umbria | 357736 | 2008 | 0 | 43.10675841 | 12.38824698 | 2022-08-11 04:20:49 | Umbria, Italy | |||
1086056 | 1086056 | 2022-08-09 | Italy | Umbria | 357090 | 2000 | 0 | 43.10675841 | 12.38824698 | 2022-08-10 04:20:57 | Umbria, Italy | |||
3543471 | 3543471 | 2022-08-08 | Italy | Umbria | 356368 | 1991 | 0 | 43.10675841 | 12.38824698 | 2022-08-09 04:20:34 | Umbria, Italy | |||
1069874 | 1069874 | 2022-08-07 | Italy | Umbria | 356107 | 1991 | 0 | 43.10675841 | 12.38824698 | 2022-08-08 04:21:08 | Umbria, Italy | |||
1940462 | 1940462 | 2022-08-06 | Italy | Umbria | 355504 | 1988 | 0 | 43.10675841 | 12.38824698 | 2022-08-07 04:20:54 | Umbria, Italy | |||
880261 | 880261 | 2022-08-05 | Italy | Umbria | 354814 | 1986 | 0 | 43.10675841 | 12.38824698 | 2022-08-06 04:20:56 | Umbria, Italy | |||
2008672 | 2008672 | 2022-08-04 | Italy | Umbria | 354071 | 1985 | 0 | 43.10675841 | 12.38824698 | 2022-08-05 04:20:52 | Umbria, Italy | |||
1098099 | 1098099 | 2022-08-03 | Italy | Umbria | 353303 | 1981 | 0 | 43.10675841 | 12.38824698 | 2022-08-04 04:20:58 | Umbria, Italy | |||
1405024 | 1405024 | 2022-08-02 | Italy | Umbria | 352356 | 1973 | 0 | 43.10675841 | 12.38824698 | 2022-08-03 04:20:59 | Umbria, Italy | |||
3617062 | 3617062 | 2022-08-01 | Italy | Umbria | 351096 | 1969 | 0 | 43.10675841 | 12.38824698 | 2022-08-02 04:20:53 | Umbria, Italy | |||
3871542 | 3871542 | 2022-07-31 | Italy | Umbria | 350693 | 1968 | 0 | 43.10675841 | 12.38824698 | 2022-08-01 04:21:03 | Umbria, Italy | |||
674296 | 674296 | 2022-07-30 | Italy | Umbria | 349833 | 1967 | 0 | 43.10675841 | 12.38824698 | 2022-07-31 04:21:02 | Umbria, Italy | |||
1783495 | 1783495 | 2022-07-29 | Italy | Umbria | 348917 | 1966 | 0 | 43.10675841 | 12.38824698 | 2022-07-30 04:20:42 | Umbria, Italy | |||
1065858 | 1065858 | 2022-07-28 | Italy | Umbria | 347985 | 1957 | 0 | 43.10675841 | 12.38824698 | 2022-07-29 04:20:45 | Umbria, Italy | |||
2335377 | 2335377 | 2022-07-27 | Italy | Umbria | 346823 | 1954 | 0 | 43.10675841 | 12.38824698 | 2022-07-28 04:20:56 | Umbria, Italy | |||
1487567 | 1487567 | 2022-07-26 | Italy | Umbria | 345561 | 1937 | 0 | 43.10675841 | 12.38824698 | 2022-07-27 04:21:04 | Umbria, Italy | |||
2594013 | 2594013 | 2022-07-25 | Italy | Umbria | 344067 | 1932 | 0 | 43.10675841 | 12.38824698 | 2022-07-26 04:20:58 | Umbria, Italy | |||
896128 | 896128 | 2022-07-24 | Italy | Umbria | 343548 | 1932 | 0 | 43.10675841 | 12.38824698 | 2022-07-25 04:20:51 | Umbria, Italy | |||
91122 | 91122 | 2022-07-23 | Italy | Umbria | 342357 | 1926 | 0 | 43.10675841 | 12.38824698 | 2022-07-24 04:20:47 | Umbria, Italy | |||
900144 | 900144 | 2022-07-22 | Italy | Umbria | 341151 | 1922 | 0 | 43.10675841 | 12.38824698 | 2022-07-23 04:20:53 | Umbria, Italy | |||
670280 | 670280 | 2022-07-21 | Italy | Umbria | 339805 | 1917 | 0 | 43.10675841 | 12.38824698 | 2022-07-22 04:21:15 | Umbria, Italy | |||
1608243 | 1608243 | 2022-07-20 | Italy | Umbria | 338193 | 1917 | 0 | 43.10675841 | 12.38824698 | 2022-07-21 04:21:10 | Umbria, Italy | |||
958876 | 958876 | 2022-07-19 | Italy | Umbria | 336503 | 1897 | 0 | 43.10675841 | 12.38824698 | 2022-07-20 04:20:59 | Umbria, Italy | |||
3210263 | 3210263 | 2022-07-18 | Italy | Umbria | 334438 | 1895 | 0 | 43.10675841 | 12.38824698 | 2022-07-19 04:20:58 | Umbria, Italy | |||
3405438 | 3405438 | 2022-07-17 | Italy | Umbria | 333776 | 1894 | 0 | 43.10675841 | 12.38824698 | 2022-07-18 04:20:59 | Umbria, Italy | |||
2151638 | 2151638 | 2022-07-16 | Italy | Umbria | 332470 | 1894 | 0 | 43.10675841 | 12.38824698 | 2022-07-17 04:21:15 | Umbria, Italy | |||
2418871 | 2418871 | 2022-07-15 | Italy | Umbria | 330846 | 1893 | 0 | 43.10675841 | 12.38824698 | 2022-07-16 04:21:05 | Umbria, Italy | |||
3428946 | 3428946 | 2022-07-14 | Italy | Umbria | 328995 | 1892 | 0 | 43.10675841 | 12.38824698 | 2022-07-15 04:20:53 | Umbria, Italy | |||
3109466 | 3109466 | 2022-07-13 | Italy | Umbria | 326989 | 1892 | 0 | 43.10675841 | 12.38824698 | 2022-07-14 04:20:57 | Umbria, Italy | |||
629889 | 629889 | 2022-07-12 | Italy | Umbria | 324791 | 1891 | 0 | 43.10675841 | 12.38824698 | 2022-07-13 04:20:58 | Umbria, Italy | |||
1211533 | 1211533 | 2022-07-11 | Italy | Umbria | 322577 | 1891 | 0 | 43.10675841 | 12.38824698 | 2022-07-12 04:20:51 | Umbria, Italy | |||
2789015 | 2789015 | 2022-07-10 | Italy | Umbria | 321782 | 1891 | 0 | 43.10675841 | 12.38824698 | 2022-07-11 04:20:46 | Umbria, Italy | |||
141968 | 141968 | 2022-07-09 | Italy | Umbria | 320097 | 1890 | 0 | 43.10675841 | 12.38824698 | 2022-07-10 04:20:54 | Umbria, Italy | |||
1417068 | 1417068 | 2022-07-08 | Italy | Umbria | 318308 | 1890 | 0 | 43.10675841 | 12.38824698 | 2022-07-09 04:20:59 | Umbria, Italy | |||
2740993 | 2740993 | 2022-07-07 | Italy | Umbria | 316494 | 1885 | 0 | 43.10675841 | 12.38824698 | 2022-07-08 04:20:56 | Umbria, Italy | |||
1199788 | 1199788 | 2022-07-06 | Italy | Umbria | 314622 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-07-07 04:20:55 | Umbria, Italy | |||
3966531 | 3966531 | 2022-07-05 | Italy | Umbria | 312682 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-07-06 04:20:58 | Umbria, Italy | |||
3078042 | 3078042 | 2022-07-04 | Italy | Umbria | 310658 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-07-05 04:20:45 | Umbria, Italy | |||
1767324 | 1767324 | 2022-07-03 | Italy | Umbria | 310039 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-07-04 04:20:54 | Umbria, Italy | |||
3365310 | 3365310 | 2022-07-02 | Italy | Umbria | 308521 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-07-03 04:20:59 | Umbria, Italy | |||
593639 | 593639 | 2022-07-01 | Italy | Umbria | 307039 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-07-02 04:21:16 | Umbria, Italy | |||
3940040 | 3940040 | 2022-06-30 | Italy | Umbria | 305528 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-07-01 04:21:10 | Umbria, Italy | |||
2489998 | 2489998 | 2022-06-29 | Italy | Umbria | 303968 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-06-30 04:21:01 | Umbria, Italy | |||
2239380 | 2239380 | 2022-06-28 | Italy | Umbria | 302652 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-06-29 04:20:59 | Umbria, Italy | |||
2147622 | 2147622 | 2022-06-27 | Italy | Umbria | 301190 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-06-28 04:20:58 | Umbria, Italy | |||
475423 | 475423 | 2022-06-26 | Italy | Umbria | 300675 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-06-27 04:21:00 | Umbria, Italy | |||
938798 | 938798 | 2022-06-25 | Italy | Umbria | 299720 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-06-26 04:21:02 | Umbria, Italy | |||
3346618 | 3346618 | 2022-06-24 | Italy | Umbria | 298779 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-06-25 04:20:57 | Umbria, Italy | |||
1648359 | 1648359 | 2022-06-23 | Italy | Umbria | 297803 | 1884 | 0 | 43.10675841 | 12.38824698 | 2022-06-24 04:20:58 | Umbria, Italy | |||
2187594 | 2187594 | 2022-06-22 | Italy | Umbria | 296847 | 1883 | 0 | 43.10675841 | 12.38824698 | 2022-06-23 04:20:55 | Umbria, Italy | |||
166025 | 166025 | 2022-06-21 | Italy | Umbria | 296016 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-22 04:20:54 | Umbria, Italy | |||
1763308 | 1763308 | 2022-06-20 | Italy | Umbria | 295154 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-21 04:20:56 | Umbria, Italy | |||
3269494 | 3269494 | 2022-06-19 | Italy | Umbria | 294852 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-20 04:21:01 | Umbria, Italy | |||
3397406 | 3397406 | 2022-06-18 | Italy | Umbria | 294253 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-19 04:20:51 | Umbria, Italy | |||
2311283 | 2311283 | 2022-06-17 | Italy | Umbria | 293615 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-18 04:21:10 | Umbria, Italy | |||
558787 | 558787 | 2022-06-16 | Italy | Umbria | 292982 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-17 04:20:56 | Umbria, Italy | |||
3982589 | 3982589 | 2022-06-15 | Italy | Umbria | 292408 | 1878 | 0 | 43.10675841 | 12.38824698 | 2022-06-16 04:20:55 | Umbria, Italy | |||
946830 | 946830 | 2022-06-14 | Italy | Umbria | 291800 | 1878 | 0 | 43.10675841 | 12.38824698 | 2022-06-15 04:20:54 | Umbria, Italy | |||
2979238 | 2979238 | 2022-06-13 | Italy | Umbria | 291204 | 1871 | 0 | 43.10675841 | 12.38824698 | 2022-06-14 04:20:52 | 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]);