johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where province_or_state = "Piemonte" sorted by recovered
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1511384 | 1511384 | 2022-02-24 | Italy | Piemonte | 971840 | 13005 | 0 | 45.0732745 | 7.680687483 | 2022-02-25 04:21:11 | Piemonte, Italy | |||
1531904 | 1531904 | 2022-08-26 | Italy | Piemonte | 1423489 | 13588 | 0 | 45.0732745 | 7.680687483 | 2022-08-27 04:20:57 | Piemonte, Italy | |||
1539934 | 1539934 | 2022-03-31 | Italy | Piemonte | 1050370 | 13197 | 0 | 45.0732745 | 7.680687483 | 2022-04-01 04:20:28 | Piemonte, Italy | |||
1547947 | 1547947 | 2022-03-07 | Italy | Piemonte | 989921 | 13092 | 0 | 45.0732745 | 7.680687483 | 2022-03-08 04:20:54 | Piemonte, Italy | |||
1560068 | 1560068 | 2022-09-28 | Italy | Piemonte | 1472013 | 13619 | 0 | 45.0732745 | 7.680687483 | 2022-09-29 04:22:34 | Piemonte, Italy | |||
1572112 | 1572112 | 2022-05-03 | Italy | Piemonte | 1151302 | 13329 | 0 | 45.0732745 | 7.680687483 | 2022-05-04 04:20:59 | Piemonte, Italy | |||
1576128 | 1576128 | 2022-04-10 | Italy | Piemonte | 1079057 | 13244 | 0 | 45.0732745 | 7.680687483 | 2022-04-11 04:21:02 | Piemonte, Italy | |||
1592183 | 1592183 | 2022-10-21 | Italy | Piemonte | 1568278 | 13660 | 0 | 45.0732745 | 7.680687483 | 2022-10-22 04:22:53 | Piemonte, Italy | |||
1596198 | 1596198 | 2021-08-26 | Italy | Piemonte | 371467 | 11713 | 0 | 45.0732745 | 7.680687483 | 2021-08-27 04:21:37 | Piemonte, Italy | |||
1604223 | 1604223 | 2021-08-16 | Italy | Piemonte | 369142 | 11705 | 0 | 45.0732745 | 7.680687483 | 2021-08-17 04:21:49 | Piemonte, Italy | |||
1608238 | 1608238 | 2022-07-20 | Italy | Piemonte | 1347135 | 13507 | 0 | 45.0732745 | 7.680687483 | 2022-07-21 04:21:10 | Piemonte, Italy | |||
1620249 | 1620249 | 2022-11-22 | Italy | Piemonte | 1624934 | 13700 | 0 | 45.0732745 | 7.680687483 | 2022-11-23 04:21:06 | Piemonte, Italy | |||
1624265 | 1624265 | 2022-09-22 | Italy | Piemonte | 1457985 | 13617 | 0 | 45.0732745 | 7.680687483 | 2022-09-23 04:23:13 | Piemonte, Italy | |||
1628281 | 1628281 | 2022-12-18 | Italy | Piemonte | 1687340 | 13751 | 0 | 45.0732745 | 7.680687483 | 2022-12-19 04:21:03 | Piemonte, Italy | |||
1640322 | 1640322 | 2022-11-20 | Italy | Piemonte | 1624934 | 13700 | 0 | 45.0732745 | 7.680687483 | 2022-11-21 04:21:05 | Piemonte, Italy | |||
1644338 | 1644338 | 2022-03-03 | Italy | Piemonte | 983763 | 13073 | 0 | 45.0732745 | 7.680687483 | 2022-03-04 04:21:09 | Piemonte, Italy | |||
1648354 | 1648354 | 2022-06-23 | Italy | Piemonte | 1229252 | 13464 | 0 | 45.0732745 | 7.680687483 | 2022-06-24 04:20:58 | Piemonte, Italy | |||
1652370 | 1652370 | 2022-04-09 | Italy | Piemonte | 1077299 | 13241 | 0 | 45.0732745 | 7.680687483 | 2022-04-10 04:20:52 | Piemonte, Italy | |||
1656386 | 1656386 | 2022-03-19 | Italy | Piemonte | 1017763 | 13150 | 0 | 45.0732745 | 7.680687483 | 2022-03-20 04:20:45 | Piemonte, Italy | |||
1660401 | 1660401 | 2021-12-12 | Italy | Piemonte | 413714 | 11916 | 0 | 45.0732745 | 7.680687483 | 2021-12-13 04:22:02 | Piemonte, Italy | |||
1664417 | 1664417 | 2021-12-11 | Italy | Piemonte | 412508 | 11916 | 0 | 45.0732745 | 7.680687483 | 2021-12-12 04:22:12 | Piemonte, Italy | |||
1668433 | 1668433 | 2021-12-29 | Italy | Piemonte | 471753 | 12029 | 0 | 45.0732745 | 7.680687483 | 2021-12-30 04:21:25 | Piemonte, Italy | |||
1680478 | 1680478 | 2022-08-29 | Italy | Piemonte | 1426353 | 13595 | 0 | 45.0732745 | 7.680687483 | 2022-08-30 04:21:03 | Piemonte, Italy | |||
1692293 | 1692293 | 2022-01-10 | Italy | Piemonte | 605597 | 12178 | 0 | 45.0732745 | 7.680687483 | 2022-01-11 04:22:01 | Piemonte, Italy | |||
1696310 | 1696310 | 2022-04-28 | Italy | Piemonte | 1137947 | 13305 | 0 | 45.0732745 | 7.680687483 | 2022-04-29 04:20:59 | Piemonte, Italy | |||
1700325 | 1700325 | 2022-01-03 | Italy | Piemonte | 509421 | 12072 | 0 | 45.0732745 | 7.680687483 | 2022-01-04 04:22:17 | Piemonte, Italy | |||
1716330 | 1716330 | 2021-12-16 | Italy | Piemonte | 420852 | 11938 | 0 | 45.0732745 | 7.680687483 | 2021-12-17 04:22:14 | Piemonte, Italy | |||
1720459 | 1720459 | 2022-03-25 | Italy | Piemonte | 1033761 | 13173 | 0 | 45.0732745 | 7.680687483 | 2022-03-26 04:20:23 | Piemonte, Italy | |||
1724474 | 1724474 | 2021-09-25 | Italy | Piemonte | 378173 | 11755 | 0 | 45.0732745 | 7.680687483 | 2021-09-26 04:21:29 | Piemonte, Italy | |||
1740514 | 1740514 | 2021-12-05 | Italy | Piemonte | 404599 | 11901 | 0 | 45.0732745 | 7.680687483 | 2021-12-06 04:22:34 | Piemonte, Italy | |||
1755273 | 1755273 | 2022-11-18 | Italy | Piemonte | 1624934 | 13700 | 0 | 45.0732745 | 7.680687483 | 2022-11-19 04:21:14 | Piemonte, Italy | |||
1763303 | 1763303 | 2022-06-20 | Italy | Piemonte | 1221117 | 13460 | 0 | 45.0732745 | 7.680687483 | 2022-06-21 04:20:56 | Piemonte, Italy | |||
1767319 | 1767319 | 2022-07-03 | Italy | Piemonte | 1262498 | 13477 | 0 | 45.0732745 | 7.680687483 | 2022-07-04 04:20:54 | Piemonte, Italy | |||
1775348 | 1775348 | 2021-08-30 | Italy | Piemonte | 372287 | 11716 | 0 | 45.0732745 | 7.680687483 | 2021-08-31 04:21:46 | Piemonte, Italy | |||
1779362 | 1779362 | 2022-01-27 | Italy | Piemonte | 840832 | 12532 | 0 | 45.0732745 | 7.680687483 | 2022-01-28 04:21:09 | Piemonte, Italy | |||
1783490 | 1783490 | 2022-07-29 | Italy | Piemonte | 1378620 | 13533 | 0 | 45.0732745 | 7.680687483 | 2022-07-30 04:20:42 | Piemonte, Italy | |||
1802720 | 1802720 | 2021-11-25 | Italy | Piemonte | 395575 | 11879 | 0 | 45.0732745 | 7.680687483 | 2021-11-26 04:22:33 | Piemonte, Italy | |||
1810751 | 1810751 | 2022-10-05 | Italy | Piemonte | 1498917 | 13625 | 0 | 45.0732745 | 7.680687483 | 2022-10-06 04:21:22 | Piemonte, Italy | |||
1814766 | 1814766 | 2021-09-19 | Italy | Piemonte | 376865 | 11746 | 0 | 45.0732745 | 7.680687483 | 2021-09-20 04:21:22 | Piemonte, Italy | |||
1830129 | 1830129 | 2022-10-25 | Italy | Piemonte | 1578178 | 13668 | 0 | 45.0732745 | 7.680687483 | 2022-10-26 04:22:19 | Piemonte, Italy | |||
1845951 | 1845951 | 2022-04-18 | Italy | Piemonte | 1103225 | 13264 | 0 | 45.0732745 | 7.680687483 | 2022-04-19 04:21:00 | Piemonte, Italy | |||
1849967 | 1849967 | 2022-05-26 | Italy | Piemonte | 1193899 | 13419 | 0 | 45.0732745 | 7.680687483 | 2022-05-27 04:20:56 | Piemonte, Italy | |||
1853982 | 1853982 | 2021-08-20 | Italy | Piemonte | 370156 | 11707 | 0 | 45.0732745 | 7.680687483 | 2021-08-21 04:21:38 | Piemonte, Italy | |||
1865454 | 1865454 | 2022-03-10 | Italy | Piemonte | 996394 | 13113 | 0 | 45.0732745 | 7.680687483 | 2022-03-11 04:20:50 | Piemonte, Italy | |||
1876962 | 1876962 | 2022-08-28 | Italy | Piemonte | 1425769 | 13595 | 0 | 45.0732745 | 7.680687483 | 2022-08-29 04:21:06 | Piemonte, Italy | |||
1884991 | 1884991 | 2021-09-12 | Italy | Piemonte | 375319 | 11733 | 0 | 45.0732745 | 7.680687483 | 2021-09-13 04:21:15 | Piemonte, Italy | |||
1889117 | 1889117 | 2022-09-14 | Italy | Piemonte | 1445607 | 13612 | 0 | 45.0732745 | 7.680687483 | 2022-09-15 04:21:02 | Piemonte, Italy | |||
1905172 | 1905172 | 2022-03-22 | Italy | Piemonte | 1025050 | 13166 | 0 | 45.0732745 | 7.680687483 | 2022-03-23 04:20:48 | Piemonte, Italy | |||
1909187 | 1909187 | 2021-10-17 | Italy | Piemonte | 381790 | 11790 | 0 | 45.0732745 | 7.680687483 | 2021-10-18 04:21:10 | Piemonte, Italy | |||
1921194 | 1921194 | 2021-09-24 | Italy | Piemonte | 377958 | 11754 | 0 | 45.0732745 | 7.680687483 | 2021-09-25 04:21:31 | Piemonte, Italy | |||
1940457 | 1940457 | 2022-08-06 | Italy | Piemonte | 1397296 | 13549 | 0 | 45.0732745 | 7.680687483 | 2022-08-07 04:20:54 | Piemonte, Italy | |||
1944473 | 1944473 | 2022-06-10 | Italy | Piemonte | 1207517 | 13447 | 0 | 45.0732745 | 7.680687483 | 2022-06-11 04:21:01 | Piemonte, Italy | |||
1948489 | 1948489 | 2022-04-12 | Italy | Piemonte | 1085953 | 13250 | 0 | 45.0732745 | 7.680687483 | 2022-04-13 04:21:03 | Piemonte, Italy | |||
1956518 | 1956518 | 2021-08-05 | Italy | Piemonte | 366821 | 11700 | 0 | 45.0732745 | 7.680687483 | 2021-08-06 04:21:18 | Piemonte, Italy | |||
1960532 | 1960532 | 2022-01-20 | Italy | Piemonte | 752628 | 12415 | 0 | 45.0732745 | 7.680687483 | 2022-01-21 04:21:09 | Piemonte, Italy | |||
1964549 | 1964549 | 2022-11-30 | Italy | Piemonte | 1641401 | 13712 | 0 | 45.0732745 | 7.680687483 | 2022-12-01 04:21:03 | Piemonte, Italy | |||
1968565 | 1968565 | 2022-08-13 | Italy | Piemonte | 1407775 | 13567 | 0 | 45.0732745 | 7.680687483 | 2022-08-14 04:20:55 | Piemonte, Italy | |||
1976592 | 1976592 | 2022-09-25 | Italy | Piemonte | 1463103 | 13618 | 0 | 45.0732745 | 7.680687483 | 2022-09-26 04:20:52 | Piemonte, Italy | |||
1984622 | 1984622 | 2022-12-07 | Italy | Piemonte | 1660127 | 13725 | 0 | 45.0732745 | 7.680687483 | 2022-12-08 04:21:07 | Piemonte, Italy | |||
1992635 | 1992635 | 2022-03-01 | Italy | Piemonte | 980015 | 13047 | 0 | 45.0732745 | 7.680687483 | 2022-03-02 04:21:07 | Piemonte, Italy | |||
2000636 | 2000636 | 2021-11-07 | Italy | Piemonte | 386863 | 11826 | 0 | 45.0732745 | 7.680687483 | 2021-11-08 04:21:43 | Piemonte, Italy | |||
2008667 | 2008667 | 2022-08-04 | Italy | Piemonte | 1393178 | 13541 | 0 | 45.0732745 | 7.680687483 | 2022-08-05 04:20:52 | Piemonte, Italy | |||
2012682 | 2012682 | 2022-02-06 | Italy | Piemonte | 915240 | 12720 | 0 | 45.0732745 | 7.680687483 | 2022-02-07 04:21:05 | Piemonte, Italy | |||
2016699 | 2016699 | 2022-09-20 | Italy | Piemonte | 1454163 | 13614 | 0 | 45.0732745 | 7.680687483 | 2022-09-21 04:23:22 | Piemonte, Italy | |||
2024729 | 2024729 | 2022-10-17 | Italy | Piemonte | 1548868 | 13645 | 0 | 45.0732745 | 7.680687483 | 2022-10-18 04:22:42 | Piemonte, Italy | |||
2028745 | 2028745 | 2022-04-24 | Italy | Piemonte | 1125530 | 13292 | 0 | 45.0732745 | 7.680687483 | 2022-04-25 04:20:56 | Piemonte, Italy | |||
2032761 | 2032761 | 2022-10-14 | Italy | Piemonte | 1540680 | 13640 | 0 | 45.0732745 | 7.680687483 | 2022-10-15 04:22:00 | Piemonte, Italy | |||
2043826 | 2043826 | 2021-10-18 | Italy | Piemonte | 381892 | 11794 | 0 | 45.0732745 | 7.680687483 | 2021-10-19 04:20:54 | Piemonte, Italy | |||
2047843 | 2047843 | 2022-05-25 | Italy | Piemonte | 1192625 | 13414 | 0 | 45.0732745 | 7.680687483 | 2022-05-26 04:20:50 | Piemonte, Italy | |||
2051858 | 2051858 | 2022-01-25 | Italy | Piemonte | 815536 | 12504 | 0 | 45.0732745 | 7.680687483 | 2022-01-26 04:21:07 | Piemonte, Italy | |||
2063879 | 2063879 | 2022-11-19 | Italy | Piemonte | 1624934 | 13700 | 0 | 45.0732745 | 7.680687483 | 2022-11-20 04:21:08 | Piemonte, Italy | |||
2067894 | 2067894 | 2021-08-31 | Italy | Piemonte | 372507 | 11717 | 0 | 45.0732745 | 7.680687483 | 2021-09-01 04:21:38 | Piemonte, Italy | |||
2075922 | 2075922 | 2021-09-26 | Italy | Piemonte | 378318 | 11756 | 0 | 45.0732745 | 7.680687483 | 2021-09-27 04:21:16 | Piemonte, Italy | |||
2083934 | 2083934 | 2022-05-15 | Italy | Piemonte | 1178205 | 13384 | 0 | 45.0732745 | 7.680687483 | 2022-05-16 04:20:47 | Piemonte, Italy | |||
2087949 | 2087949 | 2021-12-14 | Italy | Piemonte | 416794 | 11925 | 0 | 45.0732745 | 7.680687483 | 2021-12-15 03:22:16 | Piemonte, Italy | |||
2092073 | 2092073 | 2022-03-05 | Italy | Piemonte | 987276 | 13079 | 0 | 45.0732745 | 7.680687483 | 2022-03-06 04:20:49 | Piemonte, Italy | |||
2096089 | 2096089 | 2022-08-27 | Italy | Piemonte | 1424832 | 13595 | 0 | 45.0732745 | 7.680687483 | 2022-08-28 04:21:02 | Piemonte, Italy | |||
2100105 | 2100105 | 2022-11-26 | Italy | Piemonte | 1641401 | 13712 | 0 | 45.0732745 | 7.680687483 | 2022-11-27 04:21:05 | Piemonte, Italy | |||
2111675 | 2111675 | 2021-12-26 | Italy | Piemonte | 449538 | 11997 | 0 | 45.0732745 | 7.680687483 | 2021-12-27 04:21:58 | Piemonte, Italy | |||
2115692 | 2115692 | 2022-04-08 | Italy | Piemonte | 1074279 | 13233 | 0 | 45.0732745 | 7.680687483 | 2022-04-09 04:20:42 | Piemonte, Italy | |||
2123718 | 2123718 | 2021-10-21 | Italy | Piemonte | 382684 | 11800 | 0 | 45.0732745 | 7.680687483 | 2021-10-22 04:21:14 | Piemonte, Italy | |||
2131997 | 2131997 | 2021-10-01 | Italy | Piemonte | 379208 | 11762 | 0 | 45.0732745 | 7.680687483 | 2021-10-02 04:21:25 | Piemonte, Italy | |||
2136133 | 2136133 | 2022-12-01 | Italy | Piemonte | 1641401 | 13712 | 0 | 45.0732745 | 7.680687483 | 2022-12-02 04:21:07 | Piemonte, Italy | |||
2140149 | 2140149 | 2022-03-09 | Italy | Piemonte | 994150 | 13109 | 0 | 45.0732745 | 7.680687483 | 2022-03-10 04:20:48 | Piemonte, Italy | |||
2147617 | 2147617 | 2022-06-27 | Italy | Piemonte | 1237456 | 13468 | 0 | 45.0732745 | 7.680687483 | 2022-06-28 04:20:58 | Piemonte, Italy | |||
2151633 | 2151633 | 2022-07-16 | Italy | Piemonte | 1329435 | 13499 | 0 | 45.0732745 | 7.680687483 | 2022-07-17 04:21:15 | Piemonte, Italy | |||
2159507 | 2159507 | 2022-10-16 | Italy | Piemonte | 1547388 | 13641 | 0 | 45.0732745 | 7.680687483 | 2022-10-17 04:20:31 | Piemonte, Italy | |||
2163523 | 2163523 | 2022-03-26 | Italy | Piemonte | 1036286 | 13175 | 0 | 45.0732745 | 7.680687483 | 2022-03-27 04:20:47 | Piemonte, Italy | |||
2167538 | 2167538 | 2022-01-01 | Italy | Piemonte | 502219 | 12059 | 0 | 45.0732745 | 7.680687483 | 2022-01-02 04:20:52 | Piemonte, Italy | |||
2175544 | 2175544 | 2021-08-22 | Italy | Piemonte | 370558 | 11710 | 0 | 45.0732745 | 7.680687483 | 2021-08-23 04:21:27 | Piemonte, Italy | |||
2179559 | 2179559 | 2022-12-22 | Italy | Piemonte | 1687340 | 13751 | 0 | 45.0732745 | 7.680687483 | 2022-12-23 04:21:04 | Piemonte, Italy | |||
2187589 | 2187589 | 2022-06-22 | Italy | Piemonte | 1226658 | 13463 | 0 | 45.0732745 | 7.680687483 | 2022-06-23 04:20:55 | Piemonte, Italy | |||
2195599 | 2195599 | 2021-12-03 | Italy | Piemonte | 402583 | 11897 | 0 | 45.0732745 | 7.680687483 | 2021-12-04 04:22:18 | Piemonte, Italy | |||
2199616 | 2199616 | 2022-03-06 | Italy | Piemonte | 988384 | 13083 | 0 | 45.0732745 | 7.680687483 | 2022-03-07 04:20:47 | Piemonte, Italy | |||
2203631 | 2203631 | 2021-08-07 | Italy | Piemonte | 367227 | 11701 | 0 | 45.0732745 | 7.680687483 | 2021-08-08 04:21:33 | Piemonte, Italy | |||
2235359 | 2235359 | 2022-06-12 | Italy | Piemonte | 1209389 | 13447 | 0 | 45.0732745 | 7.680687483 | 2022-06-13 04:21:14 | Piemonte, Italy | |||
2239375 | 2239375 | 2022-06-28 | Italy | Piemonte | 1243317 | 13469 | 0 | 45.0732745 | 7.680687483 | 2022-06-29 04:20:59 | Piemonte, Italy | |||
2251401 | 2251401 | 2022-04-19 | Italy | Piemonte | 1106804 | 13267 | 0 | 45.0732745 | 7.680687483 | 2022-04-20 04:20:45 | Piemonte, Italy | |||
2259739 | 2259739 | 2022-10-02 | Italy | Piemonte | 1485130 | 13622 | 0 | 45.0732745 | 7.680687483 | 2022-10-03 04:23:11 | Piemonte, Italy | |||
2263867 | 2263867 | 2022-03-14 | Italy | Piemonte | 1003468 | 13127 | 0 | 45.0732745 | 7.680687483 | 2022-03-15 04:20:47 | Piemonte, 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]);