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 = "Sicilia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714444 | 714444 | 2021-11-12 | Italy | Sicilia | 313813 | 7085 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-13 04:21:38 | Sicilia, Italy | |||
718461 | 718461 | 2022-12-04 | Italy | Sicilia | 1734738 | 12328 | 0 | 38.11569725 | 13.3623567 | 2022-12-05 04:20:58 | Sicilia, Italy | |||
722476 | 722476 | 2021-11-20 | Italy | Sicilia | 317944 | 7137 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-21 04:22:13 | Sicilia, Italy | |||
730506 | 730506 | 2021-12-27 | Italy | Sicilia | 356496 | 7447 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-28 04:21:47 | Sicilia, Italy | |||
746323 | 746323 | 2022-04-23 | Italy | Sicilia | 1083490 | 10479 | 0 | 38.11569725 | 13.362356699999998 | 2022-04-24 04:20:56 | Sicilia, Italy | |||
758306 | 758306 | 2021-11-26 | Italy | Sicilia | 321696 | 7179 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-27 04:22:45 | Sicilia, Italy | |||
770327 | 770327 | 2021-10-23 | Italy | Sicilia | 305283 | 6979 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-24 04:21:22 | Sicilia, Italy | |||
782369 | 782369 | 2021-12-13 | Italy | Sicilia | 334608 | 7287 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-14 04:22:38 | Sicilia, Italy | |||
794393 | 794393 | 2022-10-24 | Italy | Sicilia | 1680348 | 12235 | 0 | 38.11569725 | 13.3623567 | 2022-10-25 04:21:53 | Sicilia, Italy | |||
798408 | 798408 | 2021-12-22 | Italy | Sicilia | 346027 | 7381 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-23 04:21:21 | Sicilia, Italy | |||
809570 | 809570 | 2021-09-20 | Italy | Sicilia | 293659 | 6700 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-21 04:21:26 | Sicilia, Italy | |||
833606 | 833606 | 2022-12-02 | Italy | Sicilia | 1734738 | 12328 | 0 | 38.11569725 | 13.3623567 | 2022-12-03 04:21:02 | Sicilia, Italy | |||
849578 | 849578 | 2022-11-02 | Italy | Sicilia | 1688122 | 12247 | 0 | 38.11569725 | 13.3623567 | 2022-11-03 04:22:05 | Sicilia, Italy | |||
853594 | 853594 | 2022-09-30 | Italy | Sicilia | 1649837 | 12201 | 0 | 38.11569725 | 13.3623567 | 2022-10-01 04:23:01 | Sicilia, Italy | |||
868778 | 868778 | 2022-12-11 | Italy | Sicilia | 1746612 | 12356 | 0 | 38.11569725 | 13.3623567 | 2022-12-12 04:21:01 | Sicilia, Italy | |||
876243 | 876243 | 2022-03-27 | Italy | Sicilia | 951770 | 9987 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-28 04:20:33 | Sicilia, Italy | |||
880259 | 880259 | 2022-08-05 | Italy | Sicilia | 1573793 | 11775 | 0 | 38.11569725 | 13.3623567 | 2022-08-06 04:20:56 | Sicilia, Italy | |||
896126 | 896126 | 2022-07-24 | Italy | Sicilia | 1528211 | 11548 | 0 | 38.11569725 | 13.3623567 | 2022-07-25 04:20:51 | Sicilia, Italy | |||
900142 | 900142 | 2022-07-22 | Italy | Sicilia | 1517813 | 11525 | 0 | 38.11569725 | 13.3623567 | 2022-07-23 04:20:53 | Sicilia, Italy | |||
904157 | 904157 | 2021-11-24 | Italy | Sicilia | 320232 | 7168 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-25 04:22:33 | Sicilia, Italy | |||
912187 | 912187 | 2022-10-29 | Italy | Sicilia | 1688122 | 12247 | 0 | 38.11569725 | 13.3623567 | 2022-10-30 04:22:14 | Sicilia, Italy | |||
919663 | 919663 | 2022-03-08 | Italy | Sicilia | 825196 | 9655 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-09 04:20:59 | Sicilia, Italy | |||
934779 | 934779 | 2021-10-16 | Italy | Sicilia | 303185 | 6935 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-17 04:21:29 | Sicilia, Italy | |||
938796 | 938796 | 2022-06-25 | Italy | Sicilia | 1270110 | 11159 | 0 | 38.11569725 | 13.3623567 | 2022-06-26 04:21:02 | Sicilia, Italy | |||
942812 | 942812 | 2022-02-28 | Italy | Sicilia | 786279 | 9465 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-01 04:21:09 | Sicilia, Italy | |||
946828 | 946828 | 2022-06-14 | Italy | Sicilia | 1225659 | 11072 | 0 | 38.11569725 | 13.3623567 | 2022-06-15 04:20:54 | Sicilia, Italy | |||
950844 | 950844 | 2022-03-12 | Italy | Sicilia | 850813 | 9728 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-13 04:20:49 | Sicilia, Italy | |||
958874 | 958874 | 2022-07-19 | Italy | Sicilia | 1498339 | 11454 | 0 | 38.11569725 | 13.3623567 | 2022-07-20 04:20:59 | Sicilia, Italy | |||
962890 | 962890 | 2022-09-09 | Italy | Sicilia | 1630009 | 12146 | 0 | 38.11569725 | 13.3623567 | 2022-09-10 04:21:10 | Sicilia, Italy | |||
970898 | 970898 | 2022-06-01 | Italy | Sicilia | 1195447 | 10942 | 0 | 38.11569725 | 13.3623567 | 2022-06-02 05:20:39 | Sicilia, Italy | |||
978927 | 978927 | 2022-02-01 | Italy | Sicilia | 631070 | 8573 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-02 04:21:09 | Sicilia, Italy | |||
986957 | 986957 | 2021-10-04 | Italy | Sicilia | 299805 | 6852 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-05 04:21:27 | Sicilia, Italy | |||
990973 | 990973 | 2022-08-16 | Italy | Sicilia | 1595204 | 11912 | 0 | 38.11569725 | 13.3623567 | 2022-08-17 04:20:59 | Sicilia, Italy | |||
1014312 | 1014312 | 2021-11-21 | Italy | Sicilia | 318511 | 7146 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-22 04:22:20 | Sicilia, Italy | |||
1018329 | 1018329 | 2022-12-24 | Italy | Sicilia | 1767494 | 12410 | 0 | 38.11569725 | 13.3623567 | 2022-12-25 04:21:04 | Sicilia, Italy | |||
1022345 | 1022345 | 2022-11-04 | Italy | Sicilia | 1692614 | 12249 | 0 | 38.11569725 | 13.3623567 | 2022-11-05 04:21:52 | Sicilia, Italy | |||
1030354 | 1030354 | 2021-12-06 | Italy | Sicilia | 328386 | 7240 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-07 04:22:34 | Sicilia, Italy | |||
1049817 | 1049817 | 2022-11-06 | Italy | Sicilia | 1692614 | 12249 | 0 | 38.11569725 | 13.3623567 | 2022-11-07 04:21:26 | Sicilia, Italy | |||
1057828 | 1057828 | 2022-02-23 | Italy | Sicilia | 764778 | 9348 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-24 04:21:14 | Sicilia, Italy | |||
1065856 | 1065856 | 2022-07-28 | Italy | Sicilia | 1546677 | 11618 | 0 | 38.11569725 | 13.3623567 | 2022-07-29 04:20:45 | Sicilia, Italy | |||
1069872 | 1069872 | 2022-08-07 | Italy | Sicilia | 1578644 | 11801 | 0 | 38.11569725 | 13.3623567 | 2022-08-08 04:21:08 | Sicilia, Italy | |||
1073888 | 1073888 | 2022-12-28 | Italy | Sicilia | 1767494 | 12410 | 0 | 38.11569725 | 13.3623567 | 2022-12-29 04:21:01 | Sicilia, Italy | |||
1077903 | 1077903 | 2021-12-09 | Italy | Sicilia | 330768 | 7262 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-10 04:22:28 | Sicilia, Italy | |||
1086054 | 1086054 | 2022-08-09 | Italy | Sicilia | 1583091 | 11834 | 0 | 38.11569725 | 13.3623567 | 2022-08-10 04:20:57 | Sicilia, Italy | |||
1098097 | 1098097 | 2022-08-03 | Italy | Sicilia | 1567470 | 11735 | 0 | 38.11569725 | 13.3623567 | 2022-08-04 04:20:58 | Sicilia, Italy | |||
1109553 | 1109553 | 2022-05-21 | Italy | Sicilia | 1171573 | 10849 | 0 | 38.11569725 | 13.3623567 | 2022-05-22 04:20:52 | Sicilia, Italy | |||
1113568 | 1113568 | 2022-01-11 | Italy | Sicilia | 470384 | 7740 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-12 04:21:44 | Sicilia, Italy | |||
1117584 | 1117584 | 2021-08-06 | Italy | Sicilia | 247040 | 6076 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-07 04:21:30 | Sicilia, Italy | |||
1140891 | 1140891 | 2022-01-23 | Italy | Sicilia | 571715 | 8181 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-24 04:21:12 | Sicilia, Italy | |||
1144907 | 1144907 | 2021-12-01 | Italy | Sicilia | 324951 | 7214 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-02 04:22:37 | Sicilia, Italy | |||
1148924 | 1148924 | 2022-12-12 | Italy | Sicilia | 1746612 | 12356 | 0 | 38.11569725 | 13.3623567 | 2022-12-13 04:21:01 | Sicilia, Italy | |||
1157131 | 1157131 | 2022-04-29 | Italy | Sicilia | 1108482 | 10568 | 0 | 38.11569725 | 13.3623567 | 2022-04-30 04:21:05 | Sicilia, Italy | |||
1161147 | 1161147 | 2022-08-18 | Italy | Sicilia | 1600058 | 11946 | 0 | 38.11569725 | 13.3623567 | 2022-08-19 04:20:54 | Sicilia, Italy | |||
1169177 | 1169177 | 2022-05-20 | Italy | Sicilia | 1169300 | 10837 | 0 | 38.11569725 | 13.3623567 | 2022-05-21 04:20:58 | Sicilia, Italy | |||
1184724 | 1184724 | 2022-05-18 | Italy | Sicilia | 1164153 | 10824 | 0 | 38.11569725 | 13.3623567 | 2022-05-19 04:20:54 | Sicilia, Italy | |||
1199786 | 1199786 | 2022-07-06 | Italy | Sicilia | 1346318 | 11249 | 0 | 38.11569725 | 13.3623567 | 2022-07-07 04:20:55 | Sicilia, Italy | |||
1211531 | 1211531 | 2022-07-11 | Italy | Sicilia | 1432233 | 11292 | 0 | 38.11569725 | 13.3623567 | 2022-07-12 04:20:51 | Sicilia, Italy | |||
1215546 | 1215546 | 2022-01-08 | Italy | Sicilia | 436401 | 7667 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-09 04:21:46 | Sicilia, Italy | |||
1223577 | 1223577 | 2022-04-14 | Italy | Sicilia | 1041460 | 10328 | 0 | 38.11569725 | 13.362356699999998 | 2022-04-15 04:20:57 | Sicilia, Italy | |||
1227592 | 1227592 | 2022-01-24 | Italy | Sicilia | 575344 | 8214 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-25 04:21:05 | Sicilia, Italy | |||
1231608 | 1231608 | 2021-11-28 | Italy | Sicilia | 323118 | 7191 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-29 04:22:30 | Sicilia, Italy | |||
1235624 | 1235624 | 2021-09-27 | Italy | Sicilia | 296749 | 6792 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-28 04:21:28 | Sicilia, Italy | |||
1239640 | 1239640 | 2022-11-28 | Italy | Sicilia | 1724294 | 12298 | 0 | 38.11569725 | 13.3623567 | 2022-11-29 04:21:05 | Sicilia, Italy | |||
1250736 | 1250736 | 2022-08-23 | Italy | Sicilia | 1608566 | 12015 | 0 | 38.11569725 | 13.3623567 | 2022-08-24 04:20:46 | Sicilia, Italy | |||
1254751 | 1254751 | 2021-12-20 | Italy | Sicilia | 343154 | 7355 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-21 03:21:27 | Sicilia, Italy | |||
1258767 | 1258767 | 2021-12-18 | Italy | Sicilia | 341285 | 7339 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-19 04:21:11 | Sicilia, Italy | |||
1262783 | 1262783 | 2021-09-09 | Italy | Sicilia | 286083 | 6525 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-10 04:21:20 | Sicilia, Italy | |||
1274267 | 1274267 | 2021-10-03 | Italy | Sicilia | 299622 | 6846 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-04 04:21:31 | Sicilia, Italy | |||
1281968 | 1281968 | 2022-01-05 | Italy | Sicilia | 400459 | 7615 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-06 04:22:09 | Sicilia, Italy | |||
1285984 | 1285984 | 2022-01-04 | Italy | Sicilia | 393131 | 7583 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-05 04:21:59 | Sicilia, Italy | |||
1294014 | 1294014 | 2022-02-05 | Italy | Sicilia | 661546 | 8780 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-06 04:21:00 | Sicilia, Italy | |||
1298031 | 1298031 | 2022-02-17 | Italy | Sicilia | 734915 | 9185 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-18 04:21:04 | Sicilia, Italy | |||
1314178 | 1314178 | 2022-05-27 | Italy | Sicilia | 1185426 | 10915 | 0 | 38.11569725 | 13.3623567 | 2022-05-28 04:21:07 | Sicilia, Italy | |||
1318193 | 1318193 | 2022-01-26 | Italy | Sicilia | 590777 | 8336 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-27 04:21:19 | Sicilia, Italy | |||
1322209 | 1322209 | 2021-11-14 | Italy | Sicilia | 314641 | 7090 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-15 04:21:36 | Sicilia, Italy | |||
1326226 | 1326226 | 2022-04-26 | Italy | Sicilia | 1092492 | 10504 | 0 | 38.11569725 | 13.362356699999998 | 2022-04-27 04:20:52 | Sicilia, Italy | |||
1334255 | 1334255 | 2021-09-28 | Italy | Sicilia | 297302 | 6805 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-29 04:21:45 | Sicilia, Italy | |||
1342284 | 1342284 | 2021-08-11 | Italy | Sicilia | 251277 | 6109 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-12 04:21:25 | Sicilia, Italy | |||
1346299 | 1346299 | 2022-08-10 | Italy | Sicilia | 1585280 | 11857 | 0 | 38.11569725 | 13.3623567 | 2022-08-11 04:20:49 | Sicilia, Italy | |||
1358315 | 1358315 | 2021-11-27 | Italy | Sicilia | 322341 | 7187 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-28 04:22:43 | Sicilia, Italy | |||
1362331 | 1362331 | 2022-02-08 | Italy | Sicilia | 681048 | 8866 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-09 04:21:04 | Sicilia, Italy | |||
1366456 | 1366456 | 2022-10-28 | Italy | Sicilia | 1686840 | 12244 | 0 | 38.11569725 | 13.3623567 | 2022-10-29 04:21:13 | Sicilia, Italy | |||
1370472 | 1370472 | 2022-09-21 | Italy | Sicilia | 1640614 | 12182 | 0 | 38.11569725 | 13.3623567 | 2022-09-22 04:22:56 | Sicilia, Italy | |||
1374487 | 1374487 | 2021-09-15 | Italy | Sicilia | 290484 | 6637 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-16 04:22:19 | Sicilia, Italy | |||
1385625 | 1385625 | 2021-09-13 | Italy | Sicilia | 289329 | 6585 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-14 04:21:41 | Sicilia, Italy | |||
1389639 | 1389639 | 2022-01-07 | Italy | Sicilia | 423976 | 7643 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-08 04:21:53 | Sicilia, Italy | |||
1393656 | 1393656 | 2022-09-02 | Italy | Sicilia | 1622966 | 12116 | 0 | 38.11569725 | 13.3623567 | 2022-09-03 04:21:04 | Sicilia, Italy | |||
1397672 | 1397672 | 2022-05-06 | Italy | Sicilia | 1132901 | 10674 | 0 | 38.11569725 | 13.3623567 | 2022-05-07 04:21:09 | Sicilia, Italy | |||
1405022 | 1405022 | 2022-08-02 | Italy | Sicilia | 1564170 | 11705 | 0 | 38.11569725 | 13.3623567 | 2022-08-03 04:20:59 | Sicilia, Italy | |||
1417066 | 1417066 | 2022-07-08 | Italy | Sicilia | 1365448 | 11280 | 0 | 38.11569725 | 13.3623567 | 2022-07-09 04:20:59 | Sicilia, Italy | |||
1421082 | 1421082 | 2022-06-08 | Italy | Sicilia | 1210325 | 11020 | 0 | 38.11569725 | 13.3623567 | 2022-06-09 04:20:54 | Sicilia, Italy | |||
1432545 | 1432545 | 2021-12-28 | Italy | Sicilia | 359315 | 7475 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-29 03:21:43 | Sicilia, Italy | |||
1436562 | 1436562 | 2022-03-28 | Italy | Sicilia | 953526 | 9995 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-29 04:20:46 | Sicilia, Italy | |||
1464063 | 1464063 | 2022-02-10 | Italy | Sicilia | 696103 | 8948 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-11 04:21:09 | Sicilia, Italy | |||
1468079 | 1468079 | 2022-03-24 | Italy | Sicilia | 933284 | 9936 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-25 04:20:46 | Sicilia, Italy | |||
1472094 | 1472094 | 2022-01-17 | Italy | Sicilia | 526659 | 7938 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-18 04:21:04 | Sicilia, Italy | |||
1483550 | 1483550 | 2021-08-13 | Italy | Sicilia | 253512 | 6134 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-14 04:21:25 | Sicilia, Italy | |||
1487565 | 1487565 | 2022-07-26 | Italy | Sicilia | 1537179 | 11563 | 0 | 38.11569725 | 13.3623567 | 2022-07-27 04:21:04 | Sicilia, Italy | |||
1491580 | 1491580 | 2021-10-12 | Italy | Sicilia | 302162 | 6909 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-13 04:20:51 | Sicilia, Italy | |||
1503578 | 1503578 | 2022-05-16 | Italy | Sicilia | 1157723 | 10768 | 0 | 38.11569725 | 13.3623567 | 2022-05-17 04:20:59 | Sicilia, 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]);