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 longitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-10-10 | Italy | Piemonte | 380577 | 11778 | 0 | 45.0732745 | 7.680687483 | 2021-10-11 04:21:31 | Piemonte, Italy | |||
2020-09-07 | Italy | Piemonte | 33293 | 4151 | 27390 | 1752 | 45.0732745 | 7.680687483 | 2020-09-08 04:28:25 | Piemonte, Italy | ||
2022-11-03 | Italy | Piemonte | 1587152 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-04 04:22:11 | Piemonte, Italy | |||
2021-01-21 | Italy | Piemonte | 215278 | 8525 | 193160 | 13593 | 45.0732745 | 7.680687483 | 2021-01-22 05:22:10 | Piemonte, Italy | ||
2020-07-26 | Italy | Piemonte | 31606 | 4126 | 26678 | 802 | 45.0732745 | 7.680687483 | 2020-07-27 04:35:02 | Piemonte, Italy | ||
2021-10-20 | Italy | Piemonte | 382417 | 11799 | 0 | 45.0732745 | 7.680687483 | 2021-10-21 04:21:18 | Piemonte, Italy | |||
2021-11-17 | Italy | Piemonte | 390998 | 11857 | 0 | 45.0732745 | 7.680687483 | 2021-11-18 04:21:33 | Piemonte, Italy | |||
2022-12-21 | Italy | Piemonte | 1687340 | 13751 | 0 | 45.0732745 | 7.680687483 | 2022-12-22 04:20:56 | Piemonte, Italy | |||
2020-08-07 | Italy | Piemonte | 31799 | 4136 | 26871 | 792 | 45.0732745 | 7.680687483 | 2020-08-08 04:34:53 | Piemonte, Italy | ||
2022-02-02 | Italy | Piemonte | 892339 | 12657 | 0 | 45.0732745 | 7.680687483 | 2022-02-03 04:21:21 | Piemonte, Italy | |||
2022-05-02 | Italy | Piemonte | 1147432 | 13320 | 0 | 45.0732745 | 7.680687483 | 2022-05-03 04:21:00 | Piemonte, Italy | |||
2021-10-07 | Italy | Piemonte | 380149 | 11774 | 0 | 45.0732745 | 7.680687483 | 2021-10-08 04:21:25 | Piemonte, Italy | |||
2021-02-19 | Italy | Piemonte | 237382 | 9245 | 215700 | 12437 | 45.0732745 | 7.680687483 | 2021-02-20 05:22:51 | Piemonte, Italy | ||
2022-06-26 | Italy | Piemonte | 1236332 | 13468 | 0 | 45.0732745 | 7.680687483 | 2022-06-27 04:21:00 | Piemonte, Italy | |||
2022-11-08 | Italy | Piemonte | 1597214 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-09 04:21:22 | Piemonte, Italy | |||
2021-07-19 | Italy | Piemonte | 363787 | 11699 | 351075 | 1013 | 45.0732745 | 7.680687483 | 2021-07-20 04:21:48 | Piemonte, Italy | ||
2022-11-25 | Italy | Piemonte | 1641401 | 13712 | 0 | 45.0732745 | 7.680687483 | 2022-11-26 04:21:11 | Piemonte, Italy | |||
2021-10-14 | Italy | Piemonte | 381268 | 11783 | 0 | 45.0732745 | 7.680687483 | 2021-10-15 04:21:26 | Piemonte, Italy | |||
2021-11-06 | Italy | Piemonte | 386629 | 11826 | 0 | 45.0732745 | 7.680687483 | 2021-11-07 04:21:53 | Piemonte, Italy | |||
2022-04-02 | Italy | Piemonte | 1056144 | 13205 | 0 | 45.0732745 | 7.680687483 | 2022-04-03 04:20:48 | Piemonte, Italy | |||
2022-12-17 | Italy | Piemonte | 1687340 | 13751 | 0 | 45.0732745 | 7.680687483 | 2022-12-18 04:21:03 | Piemonte, Italy | |||
2021-08-14 | Italy | Piemonte | 368843 | 11705 | 0 | 45.0732745 | 7.680687483 | 2021-08-15 04:21:41 | Piemonte, Italy | |||
2021-08-19 | Italy | Piemonte | 369906 | 11706 | 0 | 45.0732745 | 7.680687483 | 2021-08-20 04:21:33 | Piemonte, Italy | |||
2022-10-15 | Italy | Piemonte | 1544523 | 13641 | 0 | 45.0732745 | 7.680687483 | 2022-10-16 04:22:39 | Piemonte, Italy | |||
2021-06-09 | Italy | Piemonte | 361734 | 11666 | 346877 | 3191 | 45.0732745 | 7.680687483 | 2021-06-10 04:23:17 | Piemonte, Italy | ||
2020-07-04 | Italy | Piemonte | 31405 | 4102 | 26086 | 1217 | 45.0732745 | 7.680687483 | 2020-07-05 04:33:46 | Piemonte, Italy | ||
2021-02-22 | Italy | Piemonte | 239588 | 9287 | 217381 | 12920 | 45.0732745 | 7.680687483 | 2021-02-23 05:23:41 | Piemonte, Italy | ||
2021-10-27 | Italy | Piemonte | 383961 | 11807 | 0 | 45.0732745 | 7.680687483 | 2021-10-28 04:22:08 | Piemonte, Italy | |||
2022-10-26 | Italy | Piemonte | 1581280 | 13672 | 0 | 45.0732745 | 7.680687483 | 2022-10-27 04:22:01 | Piemonte, Italy | |||
2022-12-15 | Italy | Piemonte | 1676250 | 13739 | 0 | 45.0732745 | 7.680687483 | 2022-12-16 04:21:01 | Piemonte, Italy | |||
2020-09-12 | Italy | Piemonte | 33671 | 4153 | 27488 | 2030 | 45.0732745 | 7.680687483 | 2020-09-13 04:30:52 | Piemonte, Italy | ||
2021-12-08 | Italy | Piemonte | 407850 | 11909 | 0 | 45.0732745 | 7.680687483 | 2021-12-09 04:22:49 | Piemonte, Italy | |||
2022-01-16 | Italy | Piemonte | 693908 | 12291 | 0 | 45.0732745 | 7.680687483 | 2022-01-17 04:21:08 | Piemonte, Italy | |||
2022-06-16 | Italy | Piemonte | 1215906 | 13457 | 0 | 45.0732745 | 7.680687483 | 2022-06-17 04:20:56 | Piemonte, Italy | |||
2021-06-22 | Italy | Piemonte | 362659 | 11693 | 349505 | 1461 | 45.0732745 | 7.680687483 | 2021-06-23 04:21:46 | Piemonte, Italy | ||
2021-10-29 | Italy | Piemonte | 384493 | 11811 | 0 | 45.0732745 | 7.680687483 | 2021-10-30 04:22:03 | Piemonte, Italy | |||
2020-06-06 | Italy | Piemonte | 30845 | 3934 | 22744 | 4167 | 45.0732745 | 7.680687483 | 2020-06-07 03:53:30 | Piemonte, Italy | ||
2022-02-25 | Italy | Piemonte | 973788 | 13017 | 0 | 45.0732745 | 7.680687483 | 2022-02-26 04:21:12 | Piemonte, Italy | |||
2021-07-13 | Italy | Piemonte | 363360 | 11698 | 350885 | 777 | 45.0732745 | 7.680687483 | 2021-07-14 04:21:35 | Piemonte, Italy | ||
2020-08-13 | Italy | Piemonte | 31982 | 4139 | 26979 | 864 | 45.0732745 | 7.680687483 | 2020-08-14 04:51:19 | Piemonte, Italy | ||
2021-08-08 | Italy | Piemonte | 367378 | 11701 | 0 | 45.0732745 | 7.680687483 | 2021-08-09 04:21:24 | Piemonte, Italy | |||
2022-07-01 | Italy | Piemonte | 1255993 | 13472 | 0 | 45.0732745 | 7.680687483 | 2022-07-02 04:21:16 | Piemonte, Italy | |||
2021-10-19 | Italy | Piemonte | 382137 | 11798 | 0 | 45.0732745 | 7.680687483 | 2021-10-20 04:21:00 | Piemonte, Italy | |||
2021-09-23 | Italy | Piemonte | 377745 | 11751 | 0 | 45.0732745 | 7.680687483 | 2021-09-24 04:21:44 | Piemonte, Italy | |||
2021-04-09 | Italy | Piemonte | 323937 | 10625 | 283629 | 29683 | 45.0732745 | 7.680687483 | 2021-04-10 04:20:59 | Piemonte, Italy | ||
2020-08-29 | Italy | Piemonte | 32784 | 4145 | 27256 | 1383 | 45.0732745 | 7.680687483 | 2020-08-30 04:28:22 | Piemonte, Italy | ||
2021-02-08 | Italy | Piemonte | 228762 | 9014 | 207457 | 12291 | 45.0732745 | 7.680687483 | 2021-02-09 05:23:30 | Piemonte, Italy | ||
2022-11-05 | Italy | Piemonte | 1597214 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-06 04:21:24 | Piemonte, Italy | |||
2022-05-22 | Italy | Piemonte | 1192625 | 13414 | 0 | 45.0732745 | 7.680687483 | 2022-05-26 04:20:50 | Piemonte, Italy | |||
2021-07-10 | Italy | Piemonte | 363243 | 11698 | 350834 | 711 | 45.0732745 | 7.680687483 | 2021-07-11 04:21:43 | Piemonte, Italy | ||
2022-07-12 | Italy | Piemonte | 1307102 | 13491 | 0 | 45.0732745 | 7.680687483 | 2022-07-13 04:20:58 | Piemonte, Italy | |||
2021-10-13 | Italy | Piemonte | 381070 | 11782 | 0 | 45.0732745 | 7.680687483 | 2021-10-14 04:21:29 | Piemonte, Italy | |||
2021-03-31 | Italy | Piemonte | 309280 | 10308 | 263913 | 35059 | 45.0732745 | 7.680687483 | 2021-04-01 04:27:05 | Piemonte, Italy | ||
2021-09-07 | Italy | Piemonte | 374123 | 11727 | 0 | 45.0732745 | 7.680687483 | 2021-09-08 04:21:31 | Piemonte, Italy | |||
2021-05-05 | Italy | Piemonte | 348904 | 11352 | 323186 | 14366 | 45.0732745 | 7.680687483 | 2021-05-06 04:20:38 | Piemonte, Italy | ||
2021-08-09 | Italy | Piemonte | 367468 | 11701 | 0 | 45.0732745 | 7.680687483 | 2021-08-10 04:21:27 | Piemonte, Italy | |||
2021-10-22 | Italy | Piemonte | 382962 | 11802 | 0 | 45.0732745 | 7.680687483 | 2021-10-23 04:21:32 | Piemonte, Italy | |||
2022-05-13 | Italy | Piemonte | 1174659 | 13381 | 0 | 45.0732745 | 7.680687483 | 2022-05-14 04:20:48 | Piemonte, Italy | |||
2020-08-11 | Italy | Piemonte | 31914 | 4136 | 26956 | 822 | 45.0732745 | 7.680687483 | 2020-08-12 04:27:29 | Piemonte, Italy | ||
2020-09-16 | Italy | Piemonte | 33970 | 4153 | 27590 | 2227 | 45.0732745 | 7.680687483 | 2020-09-17 04:22:00 | Piemonte, Italy | ||
2022-07-21 | Italy | Piemonte | 1351869 | 13511 | 0 | 45.0732745 | 7.680687483 | 2022-07-22 04:21:15 | Piemonte, Italy | |||
2022-07-30 | Italy | Piemonte | 1381084 | 13533 | 0 | 45.0732745 | 7.680687483 | 2022-07-31 04:21:02 | Piemonte, Italy | |||
2020-11-23 | Italy | Piemonte | 151305 | 5646 | 68736 | 76923 | 45.0732745 | 7.680687483 | 2020-11-24 05:27:31 | Piemonte, Italy | ||
2021-10-24 | Italy | Piemonte | 383368 | 11804 | 0 | 45.0732745 | 7.680687483 | 2021-10-25 04:22:31 | Piemonte, Italy | |||
2021-11-13 | Italy | Piemonte | 389250 | 11849 | 0 | 45.0732745 | 7.680687483 | 2021-11-14 04:21:31 | Piemonte, Italy | |||
2022-12-23 | Italy | Piemonte | 1694793 | 13762 | 0 | 45.0732745 | 7.680687483 | 2022-12-24 04:21:02 | Piemonte, Italy | |||
2022-03-17 | Italy | Piemonte | 1012452 | 13141 | 0 | 45.0732745 | 7.680687483 | 2022-03-18 04:20:55 | Piemonte, Italy | |||
2021-11-04 | Italy | Piemonte | 385852 | 11821 | 0 | 45.0732745 | 7.680687483 | 2021-11-05 04:21:54 | Piemonte, Italy | |||
2021-03-16 | Italy | Piemonte | 277295 | 9725 | 236786 | 30784 | 45.0732745 | 7.680687483 | 2021-03-17 05:25:07 | Piemonte, Italy | ||
2021-09-29 | Italy | Piemonte | 378845 | 11762 | 0 | 45.0732745 | 7.680687483 | 2021-09-30 04:21:20 | Piemonte, Italy | |||
2022-11-01 | Italy | Piemonte | 1587152 | 13677 | 0 | 45.0732745 | 7.680687483 | 2022-11-02 04:22:09 | Piemonte, Italy | |||
2021-11-12 | Italy | Piemonte | 388767 | 11849 | 0 | 45.0732745 | 7.680687483 | 2021-11-13 04:21:38 | Piemonte, Italy | |||
2022-12-04 | Italy | Piemonte | 1660127 | 13725 | 0 | 45.0732745 | 7.680687483 | 2022-12-05 04:20:58 | Piemonte, Italy | |||
2021-11-20 | Italy | Piemonte | 392689 | 11864 | 0 | 45.0732745 | 7.680687483 | 2021-11-21 04:22:13 | Piemonte, Italy | |||
2021-05-22 | Italy | Piemonte | 358188 | 11577 | 338402 | 8209 | 45.0732745 | 7.680687483 | 2021-05-23 04:20:51 | Piemonte, Italy | ||
2021-12-27 | Italy | Piemonte | 454149 | 12010 | 0 | 45.0732745 | 7.680687483 | 2021-12-28 04:21:47 | Piemonte, Italy | |||
2020-06-12 | Italy | Piemonte | 30989 | 3996 | 24096 | 2897 | 45.0732745 | 7.680687483 | 2020-06-13 03:33:14 | Piemonte, Italy | ||
2020-12-02 | Italy | Piemonte | 170701 | 6360 | 93454 | 70887 | 45.0732745 | 7.680687483 | 2020-12-03 05:28:22 | Piemonte, Italy | ||
2021-02-20 | Italy | Piemonte | 238147 | 9257 | 216282 | 12608 | 45.0732745 | 7.680687483 | 2021-02-21 05:24:33 | Piemonte, Italy | ||
2022-04-23 | Italy | Piemonte | 1122761 | 13288 | 0 | 45.0732745 | 7.680687483 | 2022-04-24 04:20:56 | Piemonte, Italy | |||
2020-08-01 | Italy | Piemonte | 31683 | 4129 | 26753 | 801 | 45.0732745 | 7.680687483 | 2020-08-02 04:34:47 | Piemonte, Italy | ||
2020-10-28 | Italy | Piemonte | 62445 | 4305 | 32353 | 25787 | 45.0732745 | 7.680687483 | 2020-10-29 04:24:49 | Piemonte, Italy | ||
2021-11-26 | Italy | Piemonte | 396435 | 11879 | 0 | 45.0732745 | 7.680687483 | 2021-11-27 04:22:45 | Piemonte, Italy | |||
2020-10-18 | Italy | Piemonte | 43990 | 4198 | 29959 | 9833 | 45.0732745 | 7.680687483 | 2020-10-19 04:24:16 | Piemonte, Italy | ||
2020-12-29 | Italy | Piemonte | 195415 | 7860 | 158172 | 29383 | 45.0732745 | 7.680687483 | 2020-12-30 05:22:34 | Piemonte, Italy | ||
2021-10-23 | Italy | Piemonte | 383208 | 11804 | 0 | 45.0732745 | 7.680687483 | 2021-10-24 04:21:22 | Piemonte, Italy | |||
2021-01-12 | Italy | Piemonte | 208472 | 8237 | 185465 | 14770 | 45.0732745 | 7.680687483 | 2021-01-13 05:22:15 | Piemonte, Italy | ||
2021-07-08 | Italy | Piemonte | 363170 | 11697 | 350772 | 701 | 45.0732745 | 7.680687483 | 2021-07-09 04:21:21 | Piemonte, Italy | ||
2021-12-13 | Italy | Piemonte | 414941 | 11922 | 0 | 45.0732745 | 7.680687483 | 2021-12-14 04:22:38 | Piemonte, Italy | |||
2020-10-15 | Italy | Piemonte | 41074 | 4190 | 29576 | 7308 | 45.0732745 | 7.680687483 | 2020-10-16 04:24:01 | Piemonte, Italy | ||
2021-02-04 | Italy | Piemonte | 226002 | 8951 | 205021 | 12030 | 45.0732745 | 7.680687483 | 2021-02-05 05:22:38 | Piemonte, Italy | ||
2022-10-24 | Italy | Piemonte | 1573356 | 13666 | 0 | 45.0732745 | 7.680687483 | 2022-10-25 04:21:53 | Piemonte, Italy | |||
2021-12-22 | Italy | Piemonte | 435346 | 11970 | 0 | 45.0732745 | 7.680687483 | 2021-12-23 04:21:21 | Piemonte, Italy | |||
2020-06-01 | Italy | Piemonte | 30658 | 3876 | 21720 | 5062 | 45.0732745 | 7.680687483 | 2020-06-02 02:33:08 | Piemonte, Italy | ||
2021-09-20 | Italy | Piemonte | 377000 | 11748 | 0 | 45.0732745 | 7.680687483 | 2021-09-21 04:21:26 | Piemonte, Italy | |||
2020-09-05 | Italy | Piemonte | 33200 | 4150 | 27365 | 1685 | 45.0732745 | 7.680687483 | 2020-09-06 04:28:33 | Piemonte, Italy | ||
2020-10-09 | Italy | Piemonte | 37595 | 4172 | 29113 | 4310 | 45.0732745 | 7.680687483 | 2020-10-10 04:23:57 | Piemonte, Italy | ||
2020-11-19 | Italy | Piemonte | 140177 | 5331 | 57609 | 77237 | 45.0732745 | 7.680687483 | 2020-11-20 05:26:28 | Piemonte, Italy | ||
2021-06-06 | Italy | Piemonte | 361401 | 11654 | 345934 | 3813 | 45.0732745 | 7.680687483 | 2021-06-07 04:22:51 | Piemonte, Italy | ||
2021-07-09 | Italy | Piemonte | 363210 | 11698 | 350815 | 697 | 45.0732745 | 7.680687483 | 2021-07-10 04:21:25 | Piemonte, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;