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 = "Piemonte" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
923673 | 923673 | 2020-11-26 | Italy | Piemonte | 159004 | 5875 | 74723 | 78406 | 45.0732745 | 7.680687483 | 2020-11-27 05:26:53 | Piemonte, Italy | ||
1972578 | 1972578 | 2020-11-25 | Italy | Piemonte | 156253 | 5803 | 72529 | 77921 | 45.0732745 | 7.680687483 | 2020-11-26 05:27:44 | Piemonte, Italy | ||
1350309 | 1350309 | 2020-11-24 | Italy | Piemonte | 153375 | 5719 | 70581 | 77075 | 45.0732745 | 7.680687483 | 2020-11-25 05:27:20 | Piemonte, Italy | ||
678303 | 678303 | 2020-11-23 | Italy | Piemonte | 151305 | 5646 | 68736 | 76923 | 45.0732745 | 7.680687483 | 2020-11-24 05:27:31 | Piemonte, Italy | ||
3189979 | 3189979 | 2020-11-22 | Italy | Piemonte | 149575 | 5565 | 66998 | 77012 | 45.0732745 | 7.680687483 | 2020-11-23 05:25:26 | Piemonte, Italy | ||
3836473 | 3836473 | 2020-11-21 | Italy | Piemonte | 146934 | 5496 | 65346 | 76092 | 45.0732745 | 7.680687483 | 2020-11-22 05:25:45 | Piemonte, Italy | ||
2701501 | 2701501 | 2020-11-20 | Italy | Piemonte | 144038 | 5419 | 62074 | 76545 | 45.0732745 | 7.680687483 | 2020-11-21 05:25:51 | Piemonte, Italy | ||
821561 | 821561 | 2020-11-19 | Italy | Piemonte | 140177 | 5331 | 57609 | 77237 | 45.0732745 | 7.680687483 | 2020-11-20 05:26:28 | Piemonte, Italy | ||
122695 | 122695 | 2020-11-18 | Italy | Piemonte | 134828 | 5253 | 54511 | 75064 | 45.0732745 | 7.680687483 | 2020-11-19 05:25:23 | Piemonte, Italy | ||
3338583 | 3338583 | 2020-11-17 | Italy | Piemonte | 131547 | 5190 | 52571 | 73786 | 45.0732745 | 7.680687483 | 2020-11-18 05:40:31 | Piemonte, Italy | ||
3169628 | 3169628 | 2020-11-16 | Italy | Piemonte | 128941 | 5117 | 50884 | 72940 | 45.0732745 | 7.680687483 | 2020-11-17 05:25:54 | Piemonte, Italy | ||
2880196 | 2880196 | 2020-11-15 | Italy | Piemonte | 125465 | 5046 | 49190 | 71229 | 45.0732745 | 7.680687483 | 2020-11-16 05:25:57 | Piemonte, Italy | ||
2915174 | 2915174 | 2020-11-14 | Italy | Piemonte | 121783 | 5001 | 47567 | 69215 | 45.0732745 | 7.680687483 | 2020-11-15 05:26:53 | Piemonte, Italy | ||
2784996 | 2784996 | 2020-11-13 | Italy | Piemonte | 117312 | 4964 | 45694 | 66654 | 45.0732745 | 7.680687483 | 2020-11-14 05:25:37 | Piemonte, Italy | ||
864761 | 864761 | 2020-11-12 | Italy | Piemonte | 112054 | 4903 | 43953 | 63198 | 45.0732745 | 7.680687483 | 2020-11-13 05:25:30 | Piemonte, Italy | ||
3440806 | 3440806 | 2020-11-11 | Italy | Piemonte | 107267 | 4826 | 42087 | 60354 | 45.0732745 | 7.680687483 | 2020-11-12 05:25:55 | Piemonte, Italy | ||
272146 | 272146 | 2020-11-10 | Italy | Piemonte | 104314 | 4742 | 40737 | 58835 | 45.0732745 | 7.680687483 | 2020-11-11 05:25:30 | Piemonte, Italy | ||
1988623 | 1988623 | 2020-11-09 | Italy | Piemonte | 100655 | 4678 | 39721 | 56256 | 45.0732745 | 7.680687483 | 2020-11-10 05:40:07 | Piemonte, Italy | ||
1728475 | 1728475 | 2020-11-08 | Italy | Piemonte | 97779 | 4629 | 38953 | 54197 | 45.0732745 | 7.680687483 | 2020-11-09 05:25:45 | Piemonte, Italy | ||
1543935 | 1543935 | 2020-11-07 | Italy | Piemonte | 93895 | 4594 | 37812 | 51489 | 45.0732745 | 7.680687483 | 2020-11-08 05:24:56 | Piemonte, Italy | ||
376173 | 376173 | 2020-11-06 | Italy | Piemonte | 89458 | 4549 | 36993 | 47916 | 45.0732745 | 7.680687483 | 2020-11-07 05:24:52 | Piemonte, Italy | ||
892111 | 892111 | 2020-11-05 | Italy | Piemonte | 84580 | 4520 | 36086 | 43974 | 45.0732745 | 7.680687483 | 2020-11-06 05:24:55 | Piemonte, Italy | ||
2919173 | 2919173 | 2020-11-04 | Italy | Piemonte | 81409 | 4481 | 35351 | 41577 | 45.0732745 | 7.680687483 | 2020-11-05 06:05:03 | Piemonte, Italy | ||
2498010 | 2498010 | 2020-11-03 | Italy | Piemonte | 77832 | 4444 | 34675 | 38713 | 45.0732745 | 7.680687483 | 2020-11-04 05:25:09 | Piemonte, Italy | ||
3304185 | 3304185 | 2020-11-02 | Italy | Piemonte | 74663 | 4415 | 34153 | 36095 | 45.0732745 | 7.680687483 | 2020-11-03 06:00:16 | Piemonte, Italy | ||
3409434 | 3409434 | 2020-11-01 | Italy | Piemonte | 72660 | 4394 | 33852 | 34414 | 45.0732745 | 7.680687483 | 2020-11-02 05:25:04 | Piemonte, Italy | ||
2079923 | 2079923 | 2020-10-31 | Italy | Piemonte | 70636 | 4383 | 33429 | 32824 | 45.0732745 | 7.680687483 | 2020-11-01 04:36:19 | Piemonte, Italy | ||
2243376 | 2243376 | 2020-10-30 | Italy | Piemonte | 67749 | 4355 | 33006 | 30388 | 45.0732745 | 7.680687483 | 2020-10-31 04:24:44 | Piemonte, Italy | ||
210231 | 210231 | 2020-10-29 | Italy | Piemonte | 65030 | 4332 | 32807 | 27891 | 45.0732745 | 7.680687483 | 2020-10-30 04:24:49 | Piemonte, Italy | ||
754293 | 754293 | 2020-10-28 | Italy | Piemonte | 62445 | 4305 | 32353 | 25787 | 45.0732745 | 7.680687483 | 2020-10-29 04:24:49 | Piemonte, Italy | ||
1452578 | 1452578 | 2020-10-27 | Italy | Piemonte | 59618 | 4286 | 32092 | 23240 | 45.0732745 | 7.680687483 | 2020-10-28 04:24:39 | Piemonte, Italy | ||
3480302 | 3480302 | 2020-10-26 | Italy | Piemonte | 57160 | 4273 | 31620 | 21267 | 45.0732745 | 7.680687483 | 2020-10-27 04:24:45 | Piemonte, Italy | ||
8323 | 8323 | 2020-10-25 | Italy | Piemonte | 55535 | 4259 | 31399 | 19877 | 45.0732745 | 7.680687483 | 2020-10-26 04:25:02 | Piemonte, Italy | ||
3651560 | 3651560 | 2020-10-24 | Italy | Piemonte | 53248 | 4248 | 31157 | 17843 | 45.0732745 | 7.680687483 | 2020-10-25 04:24:36 | Piemonte, Italy | ||
1053815 | 1053815 | 2020-10-23 | Italy | Piemonte | 51700 | 4236 | 31002 | 16462 | 45.0732745 | 7.680687483 | 2020-10-24 04:24:46 | Piemonte, Italy | ||
1177485 | 1177485 | 2020-10-22 | Italy | Piemonte | 49668 | 4227 | 30661 | 14780 | 45.0732745 | 7.680687483 | 2020-10-23 04:24:46 | Piemonte, Italy | ||
2191590 | 2191590 | 2020-10-21 | Italy | Piemonte | 48118 | 4216 | 30467 | 13435 | 45.0732745 | 7.680687483 | 2020-10-22 04:24:27 | Piemonte, Italy | ||
3990601 | 3990601 | 2020-10-20 | Italy | Piemonte | 46319 | 4209 | 30228 | 11882 | 45.0732745 | 7.680687483 | 2020-10-21 04:24:14 | Piemonte, Italy | ||
1794621 | 1794621 | 2020-10-19 | Italy | Piemonte | 44923 | 4203 | 30113 | 10607 | 45.0732745 | 7.680687483 | 2020-10-20 04:24:22 | Piemonte, Italy | ||
762305 | 762305 | 2020-10-18 | Italy | Piemonte | 43990 | 4198 | 29959 | 9833 | 45.0732745 | 7.680687483 | 2020-10-19 04:24:16 | Piemonte, Italy | ||
1026343 | 1026343 | 2020-10-17 | Italy | Piemonte | 42867 | 4196 | 29791 | 8880 | 45.0732745 | 7.680687483 | 2020-10-18 04:24:25 | Piemonte, Italy | ||
2856838 | 2856838 | 2020-10-16 | Italy | Piemonte | 41895 | 4194 | 29643 | 8058 | 45.0732745 | 7.680687483 | 2020-10-17 04:24:12 | Piemonte, Italy | ||
786368 | 786368 | 2020-10-15 | Italy | Piemonte | 41074 | 4190 | 29576 | 7308 | 45.0732745 | 7.680687483 | 2020-10-16 04:24:01 | Piemonte, Italy | ||
79079 | 79079 | 2020-10-14 | Italy | Piemonte | 40041 | 4187 | 29467 | 6387 | 45.0732745 | 7.680687483 | 2020-10-15 04:24:28 | Piemonte, Italy | ||
3781894 | 3781894 | 2020-10-13 | Italy | Piemonte | 39542 | 4183 | 29394 | 5965 | 45.0732745 | 7.680687483 | 2020-10-14 04:24:05 | Piemonte, Italy | ||
2291434 | 2291434 | 2020-10-12 | Italy | Piemonte | 38957 | 4180 | 29314 | 5463 | 45.0732745 | 7.680687483 | 2020-10-13 04:24:02 | Piemonte, Italy | ||
3785887 | 3785887 | 2020-10-11 | Italy | Piemonte | 38503 | 4177 | 29270 | 5056 | 45.0732745 | 7.680687483 | 2020-10-12 04:23:45 | Piemonte, Italy | ||
2602025 | 2602025 | 2020-10-10 | Italy | Piemonte | 38094 | 4174 | 29179 | 4741 | 45.0732745 | 7.680687483 | 2020-10-11 04:23:46 | Piemonte, Italy | ||
817558 | 817558 | 2020-10-09 | Italy | Piemonte | 37595 | 4172 | 29113 | 4310 | 45.0732745 | 7.680687483 | 2020-10-10 04:23:57 | Piemonte, Italy | ||
2689673 | 2689673 | 2020-10-08 | Italy | Piemonte | 37194 | 4172 | 29043 | 3979 | 45.0732745 | 7.680687483 | 2020-10-09 04:23:59 | Piemonte, Italy | ||
1041815 | 1041815 | 2020-10-07 | Italy | Piemonte | 36858 | 4172 | 28962 | 3724 | 45.0732745 | 7.680687483 | 2020-10-08 04:23:56 | Piemonte, Italy | ||
3117476 | 3117476 | 2020-10-06 | Italy | Piemonte | 36571 | 4170 | 28819 | 3582 | 45.0732745 | 7.680687483 | 2020-10-07 04:23:40 | Piemonte, Italy | ||
3801888 | 3801888 | 2020-10-05 | Italy | Piemonte | 36312 | 4168 | 28721 | 3423 | 45.0732745 | 7.680687483 | 2020-10-06 04:23:33 | Piemonte, Italy | ||
1822778 | 1822778 | 2020-10-04 | Italy | Piemonte | 36183 | 4167 | 28646 | 3370 | 45.0732745 | 7.680687483 | 2020-10-05 04:23:33 | Piemonte, Italy | ||
2514162 | 2514162 | 2020-10-03 | Italy | Piemonte | 36010 | 4166 | 28567 | 3277 | 45.0732745 | 7.680687483 | 2020-10-04 04:23:44 | Piemonte, Italy | ||
3389380 | 3389380 | 2020-10-02 | Italy | Piemonte | 35731 | 4166 | 28505 | 3060 | 45.0732745 | 7.680687483 | 2020-10-03 04:23:40 | Piemonte, Italy | ||
2379621 | 2379621 | 2020-10-01 | Italy | Piemonte | 35512 | 4165 | 28440 | 2907 | 45.0732745 | 7.680687483 | 2020-10-02 04:23:51 | Piemonte, Italy | ||
1045807 | 1045807 | 2020-09-30 | Italy | Piemonte | 35402 | 4164 | 28394 | 2844 | 45.0732745 | 7.680687483 | 2020-10-01 04:23:42 | Piemonte, Italy | ||
966888 | 966888 | 2020-09-29 | Italy | Piemonte | 35232 | 4163 | 28337 | 2732 | 45.0732745 | 7.680687483 | 2020-09-30 04:23:33 | Piemonte, Italy | ||
1515385 | 1515385 | 2020-09-28 | Italy | Piemonte | 35132 | 4161 | 28287 | 2684 | 45.0732745 | 7.680687483 | 2020-09-29 04:23:42 | Piemonte, Italy | ||
2581973 | 2581973 | 2020-09-27 | Italy | Piemonte | 35038 | 4161 | 28244 | 2633 | 45.0732745 | 7.680687483 | 2020-09-28 04:23:00 | Piemonte, Italy | ||
2614025 | 2614025 | 2020-09-26 | Italy | Piemonte | 34906 | 4160 | 28183 | 2563 | 45.0732745 | 7.680687483 | 2020-09-27 04:23:00 | Piemonte, Italy | ||
2812740 | 2812740 | 2020-09-25 | Italy | Piemonte | 34799 | 4159 | 28138 | 2502 | 45.0732745 | 7.680687483 | 2020-09-26 04:23:00 | Piemonte, Italy | ||
2606017 | 2606017 | 2020-09-24 | Italy | Piemonte | 34679 | 4158 | 28059 | 2462 | 45.0732745 | 7.680687483 | 2020-09-25 04:23:00 | Piemonte, Italy | ||
2653760 | 2653760 | 2020-09-23 | Italy | Piemonte | 34575 | 4157 | 28000 | 2418 | 45.0732745 | 7.680687483 | 2020-09-24 04:23:00 | Piemonte, Italy | ||
3316209 | 3316209 | 2020-09-22 | Italy | Piemonte | 34480 | 4156 | 27931 | 2393 | 45.0732745 | 7.680687483 | 2020-09-23 04:23:00 | Piemonte, Italy | ||
2836808 | 2836808 | 2020-09-21 | Italy | Piemonte | 34396 | 4155 | 27883 | 2358 | 45.0732745 | 7.680687483 | 2020-09-22 04:23:00 | Piemonte, Italy | ||
3093412 | 3093412 | 2020-09-20 | Italy | Piemonte | 34339 | 4154 | 27859 | 2326 | 45.0732745 | 7.680687483 | 2020-09-21 04:23:00 | Piemonte, Italy | ||
2454762 | 2454762 | 2020-09-19 | Italy | Piemonte | 34241 | 4154 | 27783 | 2304 | 45.0732745 | 7.680687483 | 2020-09-20 04:22:00 | Piemonte, Italy | ||
2848831 | 2848831 | 2020-09-18 | Italy | Piemonte | 34167 | 4153 | 27752 | 2262 | 45.0732745 | 7.680687483 | 2020-09-19 04:22:00 | Piemonte, Italy | ||
1121580 | 1121580 | 2020-09-17 | Italy | Piemonte | 34040 | 4153 | 27665 | 2222 | 45.0732745 | 7.680687483 | 2020-09-18 05:05:00 | Piemonte, Italy | ||
666269 | 666269 | 2020-09-16 | Italy | Piemonte | 33970 | 4153 | 27590 | 2227 | 45.0732745 | 7.680687483 | 2020-09-17 04:22:00 | Piemonte, Italy | ||
2728994 | 2728994 | 2020-09-15 | Italy | Piemonte | 33853 | 4153 | 27543 | 2157 | 45.0732745 | 7.680687483 | 2020-09-16 04:22:53 | Piemonte, Italy | ||
344266 | 344266 | 2020-09-14 | Italy | Piemonte | 33814 | 4153 | 27532 | 2129 | 45.0732745 | 7.680687483 | 2020-09-15 03:22:50 | Piemonte, Italy | ||
2868705 | 2868705 | 2020-09-13 | Italy | Piemonte | 33753 | 4153 | 27503 | 2097 | 45.0732745 | 7.680687483 | 2020-09-14 04:26:00 | Piemonte, Italy | ||
546744 | 546744 | 2020-09-12 | Italy | Piemonte | 33671 | 4153 | 27488 | 2030 | 45.0732745 | 7.680687483 | 2020-09-13 04:30:52 | Piemonte, Italy | ||
1444573 | 1444573 | 2020-09-11 | Italy | Piemonte | 33578 | 4153 | 27465 | 1960 | 45.0732745 | 7.680687483 | 2020-09-12 04:25:05 | Piemonte, Italy | ||
1173174 | 1173174 | 2020-09-10 | Italy | Piemonte | 33521 | 4153 | 27450 | 1918 | 45.0732745 | 7.680687483 | 2020-09-11 04:46:23 | Piemonte, Italy | ||
2171539 | 2171539 | 2020-09-09 | Italy | Piemonte | 33447 | 4152 | 27431 | 1864 | 45.0732745 | 7.680687483 | 2020-09-10 04:29:01 | Piemonte, Italy | ||
1243748 | 1243748 | 2020-09-08 | Italy | Piemonte | 33335 | 4152 | 27414 | 1769 | 45.0732745 | 7.680687483 | 2020-09-09 04:28:48 | Piemonte, Italy | ||
427327 | 427327 | 2020-09-07 | Italy | Piemonte | 33293 | 4151 | 27390 | 1752 | 45.0732745 | 7.680687483 | 2020-09-08 04:28:25 | Piemonte, Italy | ||
3161612 | 3161612 | 2020-09-06 | Italy | Piemonte | 33256 | 4150 | 27379 | 1727 | 45.0732745 | 7.680687483 | 2020-09-07 04:28:30 | Piemonte, Italy | ||
813567 | 813567 | 2020-09-05 | Italy | Piemonte | 33200 | 4150 | 27365 | 1685 | 45.0732745 | 7.680687483 | 2020-09-06 04:28:33 | Piemonte, Italy | ||
2661767 | 2661767 | 2020-09-04 | Italy | Piemonte | 33146 | 4149 | 27349 | 1648 | 45.0732745 | 7.680687483 | 2020-09-05 04:28:19 | Piemonte, Italy | ||
1354307 | 1354307 | 2020-09-03 | Italy | Piemonte | 33064 | 4148 | 27330 | 1586 | 45.0732745 | 7.680687483 | 2020-09-04 04:28:26 | Piemonte, Italy | ||
1105544 | 1105544 | 2020-09-02 | Italy | Piemonte | 32989 | 4147 | 27321 | 1521 | 45.0732745 | 7.680687483 | 2020-09-03 04:28:22 | Piemonte, Italy | ||
2059873 | 2059873 | 2020-09-01 | Italy | Piemonte | 32923 | 4146 | 27313 | 1464 | 45.0732745 | 7.680687483 | 2020-09-02 04:28:25 | Piemonte, Italy | ||
194058 | 194058 | 2020-08-31 | Italy | Piemonte | 32881 | 4146 | 27303 | 1432 | 45.0732745 | 7.680687483 | 2020-09-01 04:28:31 | Piemonte, Italy | ||
3932017 | 3932017 | 2020-08-30 | Italy | Piemonte | 32844 | 4146 | 27293 | 1405 | 45.0732745 | 7.680687483 | 2020-08-31 04:28:27 | Piemonte, Italy | ||
609679 | 609679 | 2020-08-29 | Italy | Piemonte | 32784 | 4145 | 27256 | 1383 | 45.0732745 | 7.680687483 | 2020-08-30 04:28:22 | Piemonte, Italy | ||
1523174 | 1523174 | 2020-08-28 | Italy | Piemonte | 32694 | 4145 | 27203 | 1346 | 45.0732745 | 7.680687483 | 2020-08-29 04:28:19 | Piemonte, Italy | ||
2510175 | 2510175 | 2020-08-27 | Italy | Piemonte | 32603 | 4144 | 27178 | 1281 | 45.0732745 | 7.680687483 | 2020-08-28 04:28:11 | Piemonte, Italy | ||
1996635 | 1996635 | 2020-08-26 | Italy | Piemonte | 32515 | 4144 | 27163 | 1208 | 45.0732745 | 7.680687483 | 2020-08-27 04:28:15 | Piemonte, Italy | ||
3562559 | 3562559 | 2020-08-25 | Italy | Piemonte | 32440 | 4143 | 27155 | 1142 | 45.0732745 | 7.680687483 | 2020-08-26 04:28:11 | Piemonte, Italy | ||
2991263 | 2991263 | 2020-08-24 | Italy | Piemonte | 32383 | 4143 | 27145 | 1095 | 45.0732745 | 7.680687483 | 2020-08-25 04:28:02 | Piemonte, Italy | ||
2215658 | 2215658 | 2020-08-23 | Italy | Piemonte | 32343 | 4143 | 27139 | 1061 | 45.0732745 | 7.680687483 | 2020-08-24 04:27:56 | Piemonte, Italy | ||
2299440 | 2299440 | 2020-08-22 | Italy | Piemonte | 32301 | 4143 | 27127 | 1031 | 45.0732745 | 7.680687483 | 2020-08-23 04:27:48 | Piemonte, Italy | ||
1479547 | 1479547 | 2020-08-21 | Italy | Piemonte | 32260 | 4142 | 27117 | 1001 | 45.0732745 | 7.680687483 | 2020-08-22 04:27:49 | Piemonte, Italy | ||
3484296 | 3484296 | 2020-08-20 | Italy | Piemonte | 32221 | 4142 | 27102 | 977 | 45.0732745 | 7.680687483 | 2020-08-21 04:27:41 | Piemonte, Italy | ||
206245 | 206245 | 2020-08-19 | Italy | Piemonte | 32169 | 4142 | 27096 | 931 | 45.0732745 | 7.680687483 | 2020-08-20 04:27:43 | 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]);