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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714441 | 714441 | 2021-11-12 | Italy | Piemonte | 388767 | 11849 | 0 | 45.0732745 | 7.680687483 | 2021-11-13 04:21:38 | Piemonte, Italy | |||
718458 | 718458 | 2022-12-04 | Italy | Piemonte | 1660127 | 13725 | 0 | 45.0732745 | 7.680687483 | 2022-12-05 04:20:58 | Piemonte, Italy | |||
722473 | 722473 | 2021-11-20 | Italy | Piemonte | 392689 | 11864 | 0 | 45.0732745 | 7.680687483 | 2021-11-21 04:22:13 | Piemonte, Italy | |||
730503 | 730503 | 2021-12-27 | Italy | Piemonte | 454149 | 12010 | 0 | 45.0732745 | 7.680687483 | 2021-12-28 04:21:47 | Piemonte, Italy | |||
746320 | 746320 | 2022-04-23 | Italy | Piemonte | 1122761 | 13288 | 0 | 45.0732745 | 7.680687483 | 2022-04-24 04:20:56 | Piemonte, Italy | |||
758303 | 758303 | 2021-11-26 | Italy | Piemonte | 396435 | 11879 | 0 | 45.0732745 | 7.680687483 | 2021-11-27 04:22:45 | Piemonte, Italy | |||
770324 | 770324 | 2021-10-23 | Italy | Piemonte | 383208 | 11804 | 0 | 45.0732745 | 7.680687483 | 2021-10-24 04:21:22 | Piemonte, Italy | |||
782366 | 782366 | 2021-12-13 | Italy | Piemonte | 414941 | 11922 | 0 | 45.0732745 | 7.680687483 | 2021-12-14 04:22:38 | Piemonte, Italy | |||
794390 | 794390 | 2022-10-24 | Italy | Piemonte | 1573356 | 13666 | 0 | 45.0732745 | 7.680687483 | 2022-10-25 04:21:53 | Piemonte, Italy | |||
798405 | 798405 | 2021-12-22 | Italy | Piemonte | 435346 | 11970 | 0 | 45.0732745 | 7.680687483 | 2021-12-23 04:21:21 | Piemonte, Italy | |||
809567 | 809567 | 2021-09-20 | Italy | Piemonte | 377000 | 11748 | 0 | 45.0732745 | 7.680687483 | 2021-09-21 04:21:26 | Piemonte, Italy | |||
833603 | 833603 | 2022-12-02 | Italy | Piemonte | 1660127 | 13725 | 0 | 45.0732745 | 7.680687483 | 2022-12-03 04:21:02 | Piemonte, Italy | |||
849575 | 849575 | 2022-11-02 | Italy | Piemonte | 1587152 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-03 04:22:05 | Piemonte, Italy | |||
853591 | 853591 | 2022-09-30 | Italy | Piemonte | 1479127 | 13619 | 0 | 45.0732745 | 7.680687483 | 2022-10-01 04:23:01 | Piemonte, Italy | |||
868775 | 868775 | 2022-12-11 | Italy | Piemonte | 1676250 | 13739 | 0 | 45.0732745 | 7.680687483 | 2022-12-12 04:21:01 | Piemonte, Italy | |||
876240 | 876240 | 2022-03-27 | Italy | Piemonte | 1037828 | 13175 | 0 | 45.0732745 | 7.680687483 | 2022-03-28 04:20:33 | Piemonte, Italy | |||
880256 | 880256 | 2022-08-05 | Italy | Piemonte | 1395353 | 13547 | 0 | 45.0732745 | 7.680687483 | 2022-08-06 04:20:56 | Piemonte, Italy | |||
896123 | 896123 | 2022-07-24 | Italy | Piemonte | 1362362 | 13520 | 0 | 45.0732745 | 7.680687483 | 2022-07-25 04:20:51 | Piemonte, Italy | |||
900139 | 900139 | 2022-07-22 | Italy | Piemonte | 1355887 | 13513 | 0 | 45.0732745 | 7.680687483 | 2022-07-23 04:20:53 | Piemonte, Italy | |||
904154 | 904154 | 2021-11-24 | Italy | Piemonte | 394795 | 11876 | 0 | 45.0732745 | 7.680687483 | 2021-11-25 04:22:33 | Piemonte, Italy | |||
912184 | 912184 | 2022-10-29 | Italy | Piemonte | 1587152 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-10-30 04:22:14 | Piemonte, Italy | |||
919660 | 919660 | 2022-03-08 | Italy | Piemonte | 992251 | 13100 | 0 | 45.0732745 | 7.680687483 | 2022-03-09 04:20:59 | Piemonte, Italy | |||
934776 | 934776 | 2021-10-16 | Italy | Piemonte | 381685 | 11786 | 0 | 45.0732745 | 7.680687483 | 2021-10-17 04:21:29 | Piemonte, Italy | |||
938793 | 938793 | 2022-06-25 | Italy | Piemonte | 1234212 | 13468 | 0 | 45.0732745 | 7.680687483 | 2022-06-26 04:21:02 | Piemonte, Italy | |||
942809 | 942809 | 2022-02-28 | Italy | Piemonte | 977916 | 13030 | 0 | 45.0732745 | 7.680687483 | 2022-03-01 04:21:09 | Piemonte, Italy | |||
946825 | 946825 | 2022-06-14 | Italy | Piemonte | 1211928 | 13449 | 0 | 45.0732745 | 7.680687483 | 2022-06-15 04:20:54 | Piemonte, Italy | |||
950841 | 950841 | 2022-03-12 | Italy | Piemonte | 1000241 | 13119 | 0 | 45.0732745 | 7.680687483 | 2022-03-13 04:20:49 | Piemonte, Italy | |||
958871 | 958871 | 2022-07-19 | Italy | Piemonte | 1342148 | 13504 | 0 | 45.0732745 | 7.680687483 | 2022-07-20 04:20:59 | Piemonte, Italy | |||
962887 | 962887 | 2022-09-09 | Italy | Piemonte | 1439914 | 13609 | 0 | 45.0732745 | 7.680687483 | 2022-09-10 04:21:10 | Piemonte, Italy | |||
970895 | 970895 | 2022-06-01 | Italy | Piemonte | 1199091 | 13435 | 0 | 45.0732745 | 7.680687483 | 2022-06-02 05:20:39 | Piemonte, Italy | |||
978924 | 978924 | 2022-02-01 | Italy | Piemonte | 883852 | 12629 | 0 | 45.0732745 | 7.680687483 | 2022-02-02 04:21:09 | Piemonte, Italy | |||
986954 | 986954 | 2021-10-04 | Italy | Piemonte | 379607 | 11765 | 0 | 45.0732745 | 7.680687483 | 2021-10-05 04:21:27 | Piemonte, Italy | |||
990970 | 990970 | 2022-08-16 | Italy | Piemonte | 1409744 | 13570 | 0 | 45.0732745 | 7.680687483 | 2022-08-17 04:20:59 | Piemonte, Italy | |||
1014309 | 1014309 | 2021-11-21 | Italy | Piemonte | 393134 | 11864 | 0 | 45.0732745 | 7.680687483 | 2021-11-22 04:22:20 | Piemonte, Italy | |||
1018326 | 1018326 | 2022-12-24 | Italy | Piemonte | 1694793 | 13762 | 0 | 45.0732745 | 7.680687483 | 2022-12-25 04:21:04 | Piemonte, Italy | |||
1022342 | 1022342 | 2022-11-04 | Italy | Piemonte | 1597214 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-05 04:21:52 | Piemonte, Italy | |||
1030351 | 1030351 | 2021-12-06 | Italy | Piemonte | 405375 | 11906 | 0 | 45.0732745 | 7.680687483 | 2021-12-07 04:22:34 | Piemonte, Italy | |||
1049814 | 1049814 | 2022-11-06 | Italy | Piemonte | 1597214 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-07 04:21:26 | Piemonte, Italy | |||
1057825 | 1057825 | 2022-02-23 | Italy | Piemonte | 969648 | 12993 | 0 | 45.0732745 | 7.680687483 | 2022-02-24 04:21:14 | Piemonte, Italy | |||
1065853 | 1065853 | 2022-07-28 | Italy | Piemonte | 1375587 | 13529 | 0 | 45.0732745 | 7.680687483 | 2022-07-29 04:20:45 | Piemonte, Italy | |||
1069869 | 1069869 | 2022-08-07 | Italy | Piemonte | 1398600 | 13550 | 0 | 45.0732745 | 7.680687483 | 2022-08-08 04:21:08 | Piemonte, Italy | |||
1073885 | 1073885 | 2022-12-28 | Italy | Piemonte | 1694793 | 13762 | 0 | 45.0732745 | 7.680687483 | 2022-12-29 04:21:01 | Piemonte, Italy | |||
1077900 | 1077900 | 2021-12-09 | Italy | Piemonte | 409065 | 11910 | 0 | 45.0732745 | 7.680687483 | 2021-12-10 04:22:28 | Piemonte, Italy | |||
1086051 | 1086051 | 2022-08-09 | Italy | Piemonte | 1401904 | 13553 | 0 | 45.0732745 | 7.680687483 | 2022-08-10 04:20:57 | Piemonte, Italy | |||
1098094 | 1098094 | 2022-08-03 | Italy | Piemonte | 1390744 | 13539 | 0 | 45.0732745 | 7.680687483 | 2022-08-04 04:20:58 | Piemonte, Italy | |||
1109550 | 1109550 | 2022-05-21 | Italy | Piemonte | 1188171 | 13408 | 0 | 45.0732745 | 7.680687483 | 2022-05-22 04:20:52 | Piemonte, Italy | |||
1113565 | 1113565 | 2022-01-11 | Italy | Piemonte | 624204 | 12191 | 0 | 45.0732745 | 7.680687483 | 2022-01-12 04:21:44 | Piemonte, Italy | |||
1117581 | 1117581 | 2021-08-06 | Italy | Piemonte | 367057 | 11701 | 0 | 45.0732745 | 7.680687483 | 2021-08-07 04:21:30 | Piemonte, Italy | |||
1140888 | 1140888 | 2022-01-23 | Italy | Piemonte | 789354 | 12462 | 0 | 45.0732745 | 7.680687483 | 2022-01-24 04:21:12 | Piemonte, Italy | |||
1144904 | 1144904 | 2021-12-01 | Italy | Piemonte | 400190 | 11893 | 0 | 45.0732745 | 7.680687483 | 2021-12-02 04:22:37 | Piemonte, Italy | |||
1148921 | 1148921 | 2022-12-12 | Italy | Piemonte | 1676250 | 13739 | 0 | 45.0732745 | 7.680687483 | 2022-12-13 04:21:01 | Piemonte, Italy | |||
1157128 | 1157128 | 2022-04-29 | Italy | Piemonte | 1141349 | 13311 | 0 | 45.0732745 | 7.680687483 | 2022-04-30 04:21:05 | Piemonte, Italy | |||
1161144 | 1161144 | 2022-08-18 | Italy | Piemonte | 1413065 | 13572 | 0 | 45.0732745 | 7.680687483 | 2022-08-19 04:20:54 | Piemonte, Italy | |||
1169174 | 1169174 | 2022-05-20 | Italy | Piemonte | 1186917 | 13407 | 0 | 45.0732745 | 7.680687483 | 2022-05-21 04:20:58 | Piemonte, Italy | |||
1184721 | 1184721 | 2022-05-18 | Italy | Piemonte | 1183596 | 13398 | 0 | 45.0732745 | 7.680687483 | 2022-05-19 04:20:54 | Piemonte, Italy | |||
1199783 | 1199783 | 2022-07-06 | Italy | Piemonte | 1277040 | 13480 | 0 | 45.0732745 | 7.680687483 | 2022-07-07 04:20:55 | Piemonte, Italy | |||
1211528 | 1211528 | 2022-07-11 | Italy | Piemonte | 1298164 | 13485 | 0 | 45.0732745 | 7.680687483 | 2022-07-12 04:20:51 | Piemonte, Italy | |||
1215543 | 1215543 | 2022-01-08 | Italy | Piemonte | 586786 | 12153 | 0 | 45.0732745 | 7.680687483 | 2022-01-09 04:21:46 | Piemonte, Italy | |||
1223574 | 1223574 | 2022-04-14 | Italy | Piemonte | 1093436 | 13258 | 0 | 45.0732745 | 7.680687483 | 2022-04-15 04:20:57 | Piemonte, Italy | |||
1227589 | 1227589 | 2022-01-24 | Italy | Piemonte | 796880 | 12481 | 0 | 45.0732745 | 7.680687483 | 2022-01-25 04:21:05 | Piemonte, Italy | |||
1231605 | 1231605 | 2021-11-28 | Italy | Piemonte | 397860 | 11882 | 0 | 45.0732745 | 7.680687483 | 2021-11-29 04:22:30 | Piemonte, Italy | |||
1235621 | 1235621 | 2021-09-27 | Italy | Piemonte | 378436 | 11758 | 0 | 45.0732745 | 7.680687483 | 2021-09-28 04:21:28 | Piemonte, Italy | |||
1239637 | 1239637 | 2022-11-28 | Italy | Piemonte | 1641401 | 13712 | 0 | 45.0732745 | 7.680687483 | 2022-11-29 04:21:05 | Piemonte, Italy | |||
1250733 | 1250733 | 2022-08-23 | Italy | Piemonte | 1419342 | 13576 | 0 | 45.0732745 | 7.680687483 | 2022-08-24 04:20:46 | Piemonte, Italy | |||
1254748 | 1254748 | 2021-12-20 | Italy | Piemonte | 428838 | 11953 | 0 | 45.0732745 | 7.680687483 | 2021-12-21 03:21:27 | Piemonte, Italy | |||
1258764 | 1258764 | 2021-12-18 | Italy | Piemonte | 425688 | 11948 | 0 | 45.0732745 | 7.680687483 | 2021-12-19 04:21:11 | Piemonte, Italy | |||
1262780 | 1262780 | 2021-09-09 | Italy | Piemonte | 374621 | 11730 | 0 | 45.0732745 | 7.680687483 | 2021-09-10 04:21:20 | Piemonte, Italy | |||
1274264 | 1274264 | 2021-10-03 | Italy | Piemonte | 379529 | 11763 | 0 | 45.0732745 | 7.680687483 | 2021-10-04 04:21:31 | Piemonte, Italy | |||
1281965 | 1281965 | 2022-01-05 | Italy | Piemonte | 546811 | 12107 | 0 | 45.0732745 | 7.680687483 | 2022-01-06 04:22:09 | Piemonte, Italy | |||
1285981 | 1285981 | 2022-01-04 | Italy | Piemonte | 529874 | 12093 | 0 | 45.0732745 | 7.680687483 | 2022-01-05 04:21:59 | Piemonte, Italy | |||
1294011 | 1294011 | 2022-02-05 | Italy | Piemonte | 911656 | 12716 | 0 | 45.0732745 | 7.680687483 | 2022-02-06 04:21:00 | Piemonte, Italy | |||
1298028 | 1298028 | 2022-02-17 | Italy | Piemonte | 955939 | 12920 | 0 | 45.0732745 | 7.680687483 | 2022-02-18 04:21:04 | Piemonte, Italy | |||
1314175 | 1314175 | 2022-05-27 | Italy | Piemonte | 1194758 | 13427 | 0 | 45.0732745 | 7.680687483 | 2022-05-28 04:21:07 | Piemonte, Italy | |||
1318190 | 1318190 | 2022-01-26 | Italy | Piemonte | 829743 | 12516 | 0 | 45.0732745 | 7.680687483 | 2022-01-27 04:21:19 | Piemonte, Italy | |||
1322206 | 1322206 | 2021-11-14 | Italy | Piemonte | 389617 | 11850 | 0 | 45.0732745 | 7.680687483 | 2021-11-15 04:21:36 | Piemonte, Italy | |||
1326223 | 1326223 | 2022-04-26 | Italy | Piemonte | 1128256 | 13295 | 0 | 45.0732745 | 7.680687483 | 2022-04-27 04:20:52 | Piemonte, Italy | |||
1334252 | 1334252 | 2021-09-28 | Italy | Piemonte | 378628 | 11759 | 0 | 45.0732745 | 7.680687483 | 2021-09-29 04:21:45 | Piemonte, Italy | |||
1342281 | 1342281 | 2021-08-11 | Italy | Piemonte | 367982 | 11703 | 0 | 45.0732745 | 7.680687483 | 2021-08-12 04:21:25 | Piemonte, Italy | |||
1346296 | 1346296 | 2022-08-10 | Italy | Piemonte | 1403385 | 13558 | 0 | 45.0732745 | 7.680687483 | 2022-08-11 04:20:49 | Piemonte, Italy | |||
1358312 | 1358312 | 2021-11-27 | Italy | Piemonte | 397294 | 11881 | 0 | 45.0732745 | 7.680687483 | 2021-11-28 04:22:43 | Piemonte, Italy | |||
1362328 | 1362328 | 2022-02-08 | Italy | Piemonte | 925374 | 12758 | 0 | 45.0732745 | 7.680687483 | 2022-02-09 04:21:04 | Piemonte, Italy | |||
1366453 | 1366453 | 2022-10-28 | Italy | Piemonte | 1585394 | 13676 | 0 | 45.0732745 | 7.680687483 | 2022-10-29 04:21:13 | Piemonte, Italy | |||
1370469 | 1370469 | 2022-09-21 | Italy | Piemonte | 1455764 | 13615 | 0 | 45.0732745 | 7.680687483 | 2022-09-22 04:22:56 | Piemonte, Italy | |||
1374484 | 1374484 | 2021-09-15 | Italy | Piemonte | 375916 | 11740 | 0 | 45.0732745 | 7.680687483 | 2021-09-16 04:22:19 | Piemonte, Italy | |||
1385622 | 1385622 | 2021-09-13 | Italy | Piemonte | 375406 | 11733 | 0 | 45.0732745 | 7.680687483 | 2021-09-14 04:21:41 | Piemonte, Italy | |||
1389636 | 1389636 | 2022-01-07 | Italy | Piemonte | 568566 | 12136 | 0 | 45.0732745 | 7.680687483 | 2022-01-08 04:21:53 | Piemonte, Italy | |||
1393653 | 1393653 | 2022-09-02 | Italy | Piemonte | 1432497 | 13601 | 0 | 45.0732745 | 7.680687483 | 2022-09-03 04:21:04 | Piemonte, Italy | |||
1397669 | 1397669 | 2022-05-06 | Italy | Piemonte | 1159135 | 13343 | 0 | 45.0732745 | 7.680687483 | 2022-05-07 04:21:09 | Piemonte, Italy | |||
1405019 | 1405019 | 2022-08-02 | Italy | Piemonte | 1388302 | 13537 | 0 | 45.0732745 | 7.680687483 | 2022-08-03 04:20:59 | Piemonte, Italy | |||
1417063 | 1417063 | 2022-07-08 | Italy | Piemonte | 1287342 | 13482 | 0 | 45.0732745 | 7.680687483 | 2022-07-09 04:20:59 | Piemonte, Italy | |||
1421079 | 1421079 | 2022-06-08 | Italy | Piemonte | 1205370 | 13445 | 0 | 45.0732745 | 7.680687483 | 2022-06-09 04:20:54 | Piemonte, Italy | |||
1432542 | 1432542 | 2021-12-28 | Italy | Piemonte | 462082 | 12023 | 0 | 45.0732745 | 7.680687483 | 2021-12-29 03:21:43 | Piemonte, Italy | |||
1436559 | 1436559 | 2022-03-28 | Italy | Piemonte | 1040153 | 13180 | 0 | 45.0732745 | 7.680687483 | 2022-03-29 04:20:46 | Piemonte, Italy | |||
1464060 | 1464060 | 2022-02-10 | Italy | Piemonte | 934276 | 12795 | 0 | 45.0732745 | 7.680687483 | 2022-02-11 04:21:09 | Piemonte, Italy | |||
1468076 | 1468076 | 2022-03-24 | Italy | Piemonte | 1030956 | 13172 | 0 | 45.0732745 | 7.680687483 | 2022-03-25 04:20:46 | Piemonte, Italy | |||
1472091 | 1472091 | 2022-01-17 | Italy | Piemonte | 703472 | 12313 | 0 | 45.0732745 | 7.680687483 | 2022-01-18 04:21:04 | Piemonte, Italy | |||
1483547 | 1483547 | 2021-08-13 | Italy | Piemonte | 368563 | 11704 | 0 | 45.0732745 | 7.680687483 | 2021-08-14 04:21:25 | Piemonte, Italy | |||
1487562 | 1487562 | 2022-07-26 | Italy | Piemonte | 1368805 | 13526 | 0 | 45.0732745 | 7.680687483 | 2022-07-27 04:21:04 | Piemonte, Italy | |||
1491577 | 1491577 | 2021-10-12 | Italy | Piemonte | 380875 | 11781 | 0 | 45.0732745 | 7.680687483 | 2021-10-13 04:20:51 | Piemonte, Italy | |||
1503575 | 1503575 | 2022-05-16 | Italy | Piemonte | 1179088 | 13386 | 0 | 45.0732745 | 7.680687483 | 2022-05-17 04:20:59 | 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]);