daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Piemonte" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-02 | Italy | Piemonte | 1660127 | 13725 | 0 | 45.0732745 | 7.680687483 | 2022-12-03 04:21:02 | Piemonte, Italy | |||
2020-08-17 | Italy | Piemonte | 32100 | 4140 | 27086 | 874 | 45.0732745 | 7.680687483 | 2020-08-18 04:27:56 | Piemonte, Italy | ||
2020-07-22 | Italy | Piemonte | 31558 | 4123 | 26646 | 789 | 45.0732745 | 7.680687483 | 2020-07-23 05:15:04 | Piemonte, Italy | ||
2020-12-12 | Italy | Piemonte | 184527 | 7052 | 119614 | 57861 | 45.0732745 | 7.680687483 | 2020-12-13 05:27:20 | Piemonte, Italy | ||
2022-11-02 | Italy | Piemonte | 1587152 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-03 04:22:05 | Piemonte, Italy | |||
2022-09-30 | Italy | Piemonte | 1479127 | 13619 | 0 | 45.0732745 | 7.680687483 | 2022-10-01 04:23:01 | Piemonte, Italy | |||
2020-12-11 | Italy | Piemonte | 183084 | 6993 | 116100 | 59991 | 45.0732745 | 7.680687483 | 2020-12-12 05:26:19 | Piemonte, Italy | ||
2020-11-12 | Italy | Piemonte | 112054 | 4903 | 43953 | 63198 | 45.0732745 | 7.680687483 | 2020-11-13 05:25:30 | Piemonte, Italy | ||
2022-12-11 | Italy | Piemonte | 1676250 | 13739 | 0 | 45.0732745 | 7.680687483 | 2022-12-12 04:21:01 | Piemonte, Italy | |||
2020-05-24 | Italy | Piemonte | 30180 | 3783 | 18694 | 7703 | 45.0732745 | 7.680687483 | 2020-05-25 02:32:44 | Piemonte, Italy | ||
2022-03-27 | Italy | Piemonte | 1037828 | 13175 | 0 | 45.0732745 | 7.680687483 | 2022-03-28 04:20:33 | Piemonte, Italy | |||
2022-08-05 | Italy | Piemonte | 1395353 | 13547 | 0 | 45.0732745 | 7.680687483 | 2022-08-06 04:20:56 | Piemonte, Italy | |||
2020-07-07 | Italy | Piemonte | 31434 | 4107 | 26154 | 1173 | 45.0732745 | 7.680687483 | 2020-07-08 05:33:48 | Piemonte, Italy | ||
2021-04-26 | Italy | Piemonte | 341419 | 11158 | 313172 | 17089 | 45.0732745 | 7.680687483 | 2021-04-27 04:20:52 | Piemonte, Italy | ||
2020-11-05 | Italy | Piemonte | 84580 | 4520 | 36086 | 43974 | 45.0732745 | 7.680687483 | 2020-11-06 05:24:55 | Piemonte, Italy | ||
2022-07-24 | Italy | Piemonte | 1362362 | 13520 | 0 | 45.0732745 | 7.680687483 | 2022-07-25 04:20:51 | Piemonte, Italy | |||
2022-07-22 | Italy | Piemonte | 1355887 | 13513 | 0 | 45.0732745 | 7.680687483 | 2022-07-23 04:20:53 | Piemonte, Italy | |||
2021-11-24 | Italy | Piemonte | 394795 | 11876 | 0 | 45.0732745 | 7.680687483 | 2021-11-25 04:22:33 | Piemonte, Italy | |||
2021-01-19 | Italy | Piemonte | 213911 | 8453 | 191020 | 14438 | 45.0732745 | 7.680687483 | 2021-01-20 05:21:54 | Piemonte, Italy | ||
2022-10-29 | Italy | Piemonte | 1587152 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-10-30 04:22:14 | Piemonte, Italy | |||
2022-03-08 | Italy | Piemonte | 992251 | 13100 | 0 | 45.0732745 | 7.680687483 | 2022-03-09 04:20:59 | Piemonte, Italy | |||
2020-11-26 | Italy | Piemonte | 159004 | 5875 | 74723 | 78406 | 45.0732745 | 7.680687483 | 2020-11-27 05:26:53 | Piemonte, Italy | ||
2020-12-21 | Italy | Piemonte | 189968 | 7571 | 144440 | 37957 | 45.0732745 | 7.680687483 | 2020-12-22 05:22:33 | Piemonte, Italy | ||
2021-10-16 | Italy | Piemonte | 381685 | 11786 | 0 | 45.0732745 | 7.680687483 | 2021-10-17 04:21:29 | Piemonte, Italy | |||
2022-06-25 | Italy | Piemonte | 1234212 | 13468 | 0 | 45.0732745 | 7.680687483 | 2022-06-26 04:21:02 | Piemonte, Italy | |||
2022-02-28 | Italy | Piemonte | 977916 | 13030 | 0 | 45.0732745 | 7.680687483 | 2022-03-01 04:21:09 | Piemonte, Italy | |||
2022-06-14 | Italy | Piemonte | 1211928 | 13449 | 0 | 45.0732745 | 7.680687483 | 2022-06-15 04:20:54 | Piemonte, Italy | |||
2022-03-12 | Italy | Piemonte | 1000241 | 13119 | 0 | 45.0732745 | 7.680687483 | 2022-03-13 04:20:49 | Piemonte, Italy | |||
2021-04-25 | Italy | Piemonte | 340851 | 11137 | 312241 | 17473 | 45.0732745 | 7.680687483 | 2021-04-26 04:21:04 | Piemonte, Italy | ||
2022-07-19 | Italy | Piemonte | 1342148 | 13504 | 0 | 45.0732745 | 7.680687483 | 2022-07-20 04:20:59 | Piemonte, Italy | |||
2022-09-09 | Italy | Piemonte | 1439914 | 13609 | 0 | 45.0732745 | 7.680687483 | 2022-09-10 04:21:10 | Piemonte, Italy | |||
2020-09-29 | Italy | Piemonte | 35232 | 4163 | 28337 | 2732 | 45.0732745 | 7.680687483 | 2020-09-30 04:23:33 | Piemonte, Italy | ||
2022-06-01 | Italy | Piemonte | 1199091 | 13435 | 0 | 45.0732745 | 7.680687483 | 2022-06-02 05:20:39 | Piemonte, Italy | |||
2021-02-06 | Italy | Piemonte | 227655 | 8994 | 206479 | 12182 | 45.0732745 | 7.680687483 | 2021-02-07 05:23:00 | Piemonte, Italy | ||
2022-02-01 | Italy | Piemonte | 883852 | 12629 | 0 | 45.0732745 | 7.680687483 | 2022-02-02 04:21:09 | Piemonte, Italy | |||
2021-04-17 | Italy | Piemonte | 333037 | 10924 | 299710 | 22403 | 45.0732745 | 7.680687483 | 2021-04-18 04:20:41 | Piemonte, Italy | ||
2021-10-04 | Italy | Piemonte | 379607 | 11765 | 0 | 45.0732745 | 7.680687483 | 2021-10-05 04:21:27 | Piemonte, Italy | |||
2022-08-16 | Italy | Piemonte | 1409744 | 13570 | 0 | 45.0732745 | 7.680687483 | 2022-08-17 04:20:59 | Piemonte, Italy | |||
2020-05-23 | Italy | Piemonte | 30137 | 3771 | 18341 | 8025 | 45.0732745 | 7.680687483 | 2020-05-24 02:32:43 | Piemonte, Italy | ||
2021-03-01 | Italy | Piemonte | 248289 | 9375 | 222293 | 16621 | 45.0732745 | 7.680687483 | 2021-03-02 05:23:30 | Piemonte, Italy | ||
2020-07-09 | Italy | Piemonte | 31475 | 4108 | 26243 | 1124 | 45.0732745 | 7.680687483 | 2020-07-10 04:34:24 | Piemonte, Italy | ||
2020-12-06 | Italy | Piemonte | 177788 | 6623 | 105127 | 66038 | 45.0732745 | 7.680687483 | 2020-12-07 05:26:14 | Piemonte, Italy | ||
2020-12-30 | Italy | Piemonte | 196461 | 7893 | 159609 | 28959 | 45.0732745 | 7.680687483 | 2020-12-31 05:22:49 | Piemonte, Italy | ||
2021-11-21 | Italy | Piemonte | 393134 | 11864 | 0 | 45.0732745 | 7.680687483 | 2021-11-22 04:22:20 | Piemonte, Italy | |||
2022-12-24 | Italy | Piemonte | 1694793 | 13762 | 0 | 45.0732745 | 7.680687483 | 2022-12-25 04:21:04 | Piemonte, Italy | |||
2022-11-04 | Italy | Piemonte | 1597214 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-05 04:21:52 | Piemonte, Italy | |||
2020-10-17 | Italy | Piemonte | 42867 | 4196 | 29791 | 8880 | 45.0732745 | 7.680687483 | 2020-10-18 04:24:25 | Piemonte, Italy | ||
2021-12-06 | Italy | Piemonte | 405375 | 11906 | 0 | 45.0732745 | 7.680687483 | 2021-12-07 04:22:34 | Piemonte, Italy | |||
2020-12-15 | Italy | Piemonte | 187172 | 7213 | 128989 | 50970 | 45.0732745 | 7.680687483 | 2020-12-16 05:28:04 | Piemonte, Italy | ||
2020-05-26 | Italy | Piemonte | 30314 | 3812 | 19561 | 6941 | 45.0732745 | 7.680687483 | 2020-05-27 02:32:31 | Piemonte, Italy | ||
2020-10-07 | Italy | Piemonte | 36858 | 4172 | 28962 | 3724 | 45.0732745 | 7.680687483 | 2020-10-08 04:23:56 | Piemonte, Italy | ||
2020-09-30 | Italy | Piemonte | 35402 | 4164 | 28394 | 2844 | 45.0732745 | 7.680687483 | 2020-10-01 04:23:42 | Piemonte, Italy | ||
2022-11-06 | Italy | Piemonte | 1597214 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-07 04:21:26 | Piemonte, Italy | |||
2020-10-23 | Italy | Piemonte | 51700 | 4236 | 31002 | 16462 | 45.0732745 | 7.680687483 | 2020-10-24 04:24:46 | Piemonte, Italy | ||
2022-02-23 | Italy | Piemonte | 969648 | 12993 | 0 | 45.0732745 | 7.680687483 | 2022-02-24 04:21:14 | Piemonte, Italy | |||
2021-01-04 | Italy | Piemonte | 200506 | 7988 | 172005 | 20513 | 45.0732745 | 7.680687483 | 2021-01-05 05:21:49 | Piemonte, Italy | ||
2022-07-28 | Italy | Piemonte | 1375587 | 13529 | 0 | 45.0732745 | 7.680687483 | 2022-07-29 04:20:45 | Piemonte, Italy | |||
2022-08-07 | Italy | Piemonte | 1398600 | 13550 | 0 | 45.0732745 | 7.680687483 | 2022-08-08 04:21:08 | Piemonte, Italy | |||
2022-12-28 | Italy | Piemonte | 1694793 | 13762 | 0 | 45.0732745 | 7.680687483 | 2022-12-29 04:21:01 | Piemonte, Italy | |||
2021-12-09 | Italy | Piemonte | 409065 | 11910 | 0 | 45.0732745 | 7.680687483 | 2021-12-10 04:22:28 | Piemonte, Italy | |||
2021-05-14 | Italy | Piemonte | 354935 | 11484 | 331942 | 11509 | 45.0732745 | 7.680687483 | 2021-05-15 04:20:58 | Piemonte, Italy | ||
2022-08-09 | Italy | Piemonte | 1401904 | 13553 | 0 | 45.0732745 | 7.680687483 | 2022-08-10 04:20:57 | Piemonte, Italy | |||
2021-03-03 | Italy | Piemonte | 251435 | 9411 | 224093 | 17931 | 45.0732745 | 7.680687483 | 2021-03-04 05:24:24 | Piemonte, Italy | ||
2021-01-20 | Italy | Piemonte | 214517 | 8496 | 192116 | 13905 | 45.0732745 | 7.680687483 | 2021-01-21 05:22:01 | Piemonte, Italy | ||
2022-08-03 | Italy | Piemonte | 1390744 | 13539 | 0 | 45.0732745 | 7.680687483 | 2022-08-04 04:20:58 | Piemonte, Italy | |||
2020-05-25 | Italy | Piemonte | 30228 | 3798 | 18934 | 7496 | 45.0732745 | 7.680687483 | 2020-05-26 02:32:35 | Piemonte, Italy | ||
2020-09-02 | Italy | Piemonte | 32989 | 4147 | 27321 | 1521 | 45.0732745 | 7.680687483 | 2020-09-03 04:28:22 | Piemonte, Italy | ||
2022-05-21 | Italy | Piemonte | 1188171 | 13408 | 0 | 45.0732745 | 7.680687483 | 2022-05-22 04:20:52 | Piemonte, Italy | |||
2022-01-11 | Italy | Piemonte | 624204 | 12191 | 0 | 45.0732745 | 7.680687483 | 2022-01-12 04:21:44 | Piemonte, Italy | |||
2021-08-06 | Italy | Piemonte | 367057 | 11701 | 0 | 45.0732745 | 7.680687483 | 2021-08-07 04:21:30 | Piemonte, Italy | |||
2020-09-17 | Italy | Piemonte | 34040 | 4153 | 27665 | 2222 | 45.0732745 | 7.680687483 | 2020-09-18 05:05:00 | Piemonte, Italy | ||
2021-06-18 | Italy | Piemonte | 362497 | 11686 | 348906 | 1905 | 45.0732745 | 7.680687483 | 2021-06-19 04:22:33 | Piemonte, Italy | ||
2020-06-26 | Italy | Piemonte | 31311 | 4077 | 25649 | 1585 | 45.0732745 | 7.680687483 | 2020-06-27 04:33:35 | Piemonte, Italy | ||
2021-01-01 | Italy | Piemonte | 198886 | 7960 | 164397 | 26529 | 45.0732745 | 7.680687483 | 2021-01-02 05:22:33 | Piemonte, Italy | ||
2022-01-23 | Italy | Piemonte | 789354 | 12462 | 0 | 45.0732745 | 7.680687483 | 2022-01-24 04:21:12 | Piemonte, Italy | |||
2021-12-01 | Italy | Piemonte | 400190 | 11893 | 0 | 45.0732745 | 7.680687483 | 2021-12-02 04:22:37 | Piemonte, Italy | |||
2022-12-12 | Italy | Piemonte | 1676250 | 13739 | 0 | 45.0732745 | 7.680687483 | 2022-12-13 04:21:01 | Piemonte, Italy | |||
2021-02-18 | Italy | Piemonte | 236075 | 9220 | 214849 | 12006 | 45.0732745 | 7.680687483 | 2021-02-19 05:24:16 | Piemonte, Italy | ||
2022-04-29 | Italy | Piemonte | 1141349 | 13311 | 0 | 45.0732745 | 7.680687483 | 2022-04-30 04:21:05 | Piemonte, Italy | |||
2022-08-18 | Italy | Piemonte | 1413065 | 13572 | 0 | 45.0732745 | 7.680687483 | 2022-08-19 04:20:54 | Piemonte, Italy | |||
2021-07-04 | Italy | Piemonte | 363044 | 11696 | 350571 | 777 | 45.0732745 | 7.680687483 | 2021-07-05 04:21:28 | Piemonte, Italy | ||
2022-05-20 | Italy | Piemonte | 1186917 | 13407 | 0 | 45.0732745 | 7.680687483 | 2022-05-21 04:20:58 | Piemonte, Italy | |||
2020-09-10 | Italy | Piemonte | 33521 | 4153 | 27450 | 1918 | 45.0732745 | 7.680687483 | 2020-09-11 04:46:23 | Piemonte, Italy | ||
2020-10-22 | Italy | Piemonte | 49668 | 4227 | 30661 | 14780 | 45.0732745 | 7.680687483 | 2020-10-23 04:24:46 | Piemonte, Italy | ||
2022-05-18 | Italy | Piemonte | 1183596 | 13398 | 0 | 45.0732745 | 7.680687483 | 2022-05-19 04:20:54 | Piemonte, Italy | |||
2021-05-31 | Italy | Piemonte | 360274 | 11631 | 343478 | 5165 | 45.0732745 | 7.680687483 | 2021-06-01 04:23:09 | Piemonte, Italy | ||
2020-06-17 | Italy | Piemonte | 31131 | 4026 | 24720 | 2385 | 45.0732745 | 7.680687483 | 2020-06-18 04:33:18 | Piemonte, Italy | ||
2022-07-06 | Italy | Piemonte | 1277040 | 13480 | 0 | 45.0732745 | 7.680687483 | 2022-07-07 04:20:55 | Piemonte, Italy | |||
2021-03-22 | Italy | Piemonte | 290436 | 9948 | 245605 | 34883 | 45.0732745 | 7.680687483 | 2021-03-23 05:26:18 | Piemonte, Italy | ||
2020-06-09 | Italy | Piemonte | 30890 | 3961 | 23258 | 3671 | 45.0732745 | 7.680687483 | 2020-06-10 04:07:00 | Piemonte, Italy | ||
2022-07-11 | Italy | Piemonte | 1298164 | 13485 | 0 | 45.0732745 | 7.680687483 | 2022-07-12 04:20:51 | Piemonte, Italy | |||
2022-01-08 | Italy | Piemonte | 586786 | 12153 | 0 | 45.0732745 | 7.680687483 | 2022-01-09 04:21:46 | Piemonte, Italy | |||
2021-03-27 | Italy | Piemonte | 302074 | 10180 | 256309 | 35585 | 45.0732745 | 7.680687483 | 2021-03-28 05:28:10 | Piemonte, Italy | ||
2022-04-14 | Italy | Piemonte | 1093436 | 13258 | 0 | 45.0732745 | 7.680687483 | 2022-04-15 04:20:57 | Piemonte, Italy | |||
2022-01-24 | Italy | Piemonte | 796880 | 12481 | 0 | 45.0732745 | 7.680687483 | 2022-01-25 04:21:05 | Piemonte, Italy | |||
2021-11-28 | Italy | Piemonte | 397860 | 11882 | 0 | 45.0732745 | 7.680687483 | 2021-11-29 04:22:30 | Piemonte, Italy | |||
2021-09-27 | Italy | Piemonte | 378436 | 11758 | 0 | 45.0732745 | 7.680687483 | 2021-09-28 04:21:28 | Piemonte, Italy | |||
2022-11-28 | Italy | Piemonte | 1641401 | 13712 | 0 | 45.0732745 | 7.680687483 | 2022-11-29 04:21:05 | Piemonte, Italy | |||
2020-09-08 | Italy | Piemonte | 33335 | 4152 | 27414 | 1769 | 45.0732745 | 7.680687483 | 2020-09-09 04:28:48 | Piemonte, Italy | ||
2022-08-23 | Italy | Piemonte | 1419342 | 13576 | 0 | 45.0732745 | 7.680687483 | 2022-08-24 04:20:46 | Piemonte, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;