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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1759287 | 1759287 | 2021-01-24 | Italy | Piemonte | 217677 | 8583 | 195748 | 13346 | 45.0732745 | 7.680687483 | 2021-01-25 05:22:16 | Piemonte, Italy | ||
2426894 | 2426894 | 2021-01-23 | Italy | Piemonte | 217058 | 8574 | 195029 | 13455 | 45.0732745 | 7.680687483 | 2021-01-24 05:22:35 | Piemonte, Italy | ||
2466796 | 2466796 | 2021-01-22 | Italy | Piemonte | 216127 | 8548 | 194223 | 13356 | 45.0732745 | 7.680687483 | 2021-01-23 05:22:03 | Piemonte, Italy | ||
435347 | 435347 | 2021-01-21 | Italy | Piemonte | 215278 | 8525 | 193160 | 13593 | 45.0732745 | 7.680687483 | 2021-01-22 05:22:10 | Piemonte, Italy | ||
1094079 | 1094079 | 2021-01-20 | Italy | Piemonte | 214517 | 8496 | 192116 | 13905 | 45.0732745 | 7.680687483 | 2021-01-21 05:22:01 | Piemonte, Italy | ||
908169 | 908169 | 2021-01-19 | Italy | Piemonte | 213911 | 8453 | 191020 | 14438 | 45.0732745 | 7.680687483 | 2021-01-20 05:21:54 | Piemonte, Italy | ||
237232 | 237232 | 2021-01-18 | Italy | Piemonte | 213195 | 8419 | 189987 | 14789 | 45.0732745 | 7.680687483 | 2021-01-19 05:22:15 | Piemonte, Italy | ||
3503349 | 3503349 | 2021-01-17 | Italy | Piemonte | 212760 | 8400 | 189360 | 15000 | 45.0732745 | 7.680687483 | 2021-01-18 05:22:34 | Piemonte, Italy | ||
3101432 | 3101432 | 2021-01-16 | Italy | Piemonte | 212265 | 8381 | 188770 | 15114 | 45.0732745 | 7.680687483 | 2021-01-17 05:22:17 | Piemonte, Italy | ||
3515394 | 3515394 | 2021-01-15 | Italy | Piemonte | 211209 | 8319 | 188084 | 14806 | 45.0732745 | 7.680687483 | 2021-01-16 05:22:40 | Piemonte, Italy | ||
3879567 | 3879567 | 2021-01-14 | Italy | Piemonte | 210338 | 8299 | 187316 | 14723 | 45.0732745 | 7.680687483 | 2021-01-15 05:22:24 | Piemonte, Italy | ||
3308194 | 3308194 | 2021-01-13 | Italy | Piemonte | 209481 | 8278 | 186443 | 14760 | 45.0732745 | 7.680687483 | 2021-01-14 05:22:32 | Piemonte, Italy | ||
774339 | 774339 | 2021-01-12 | Italy | Piemonte | 208472 | 8237 | 185465 | 14770 | 45.0732745 | 7.680687483 | 2021-01-13 05:22:15 | Piemonte, Italy | ||
190060 | 190060 | 2021-01-11 | Italy | Piemonte | 207571 | 8195 | 184391 | 14985 | 45.0732745 | 7.680687483 | 2021-01-12 05:22:15 | Piemonte, Italy | ||
2625863 | 2625863 | 2021-01-10 | Italy | Piemonte | 206962 | 8176 | 183444 | 15342 | 45.0732745 | 7.680687483 | 2021-01-11 05:21:50 | Piemonte, Italy | ||
3899951 | 3899951 | 2021-01-09 | Italy | Piemonte | 206159 | 8165 | 182165 | 15829 | 45.0732745 | 7.680687483 | 2021-01-10 05:22:12 | Piemonte, Italy | ||
153974 | 153974 | 2021-01-08 | Italy | Piemonte | 204627 | 8133 | 178949 | 17545 | 45.0732745 | 7.680687483 | 2021-01-09 05:22:18 | Piemonte, Italy | ||
2541398 | 2541398 | 2021-01-07 | Italy | Piemonte | 203782 | 8106 | 177977 | 17699 | 45.0732745 | 7.680687483 | 2021-01-08 05:22:42 | Piemonte, Italy | ||
2864707 | 2864707 | 2021-01-06 | Italy | Piemonte | 202778 | 8088 | 176275 | 18415 | 45.0732745 | 7.680687483 | 2021-01-07 05:22:03 | Piemonte, Italy | ||
3034294 | 3034294 | 2021-01-05 | Italy | Piemonte | 201615 | 8043 | 173930 | 19642 | 45.0732745 | 7.680687483 | 2021-01-06 05:22:16 | Piemonte, Italy | ||
1061839 | 1061839 | 2021-01-04 | Italy | Piemonte | 200506 | 7988 | 172005 | 20513 | 45.0732745 | 7.680687483 | 2021-01-05 05:21:49 | Piemonte, Italy | ||
3230442 | 3230442 | 2021-01-03 | Italy | Piemonte | 200060 | 7979 | 170618 | 21463 | 45.0732745 | 7.680687483 | 2021-01-04 05:22:02 | Piemonte, Italy | ||
2227511 | 2227511 | 2021-01-02 | Italy | Piemonte | 199319 | 7971 | 167151 | 24197 | 45.0732745 | 7.680687483 | 2021-01-03 05:22:52 | Piemonte, Italy | ||
1136875 | 1136875 | 2021-01-01 | Italy | Piemonte | 198886 | 7960 | 164397 | 26529 | 45.0732745 | 7.680687483 | 2021-01-02 05:22:33 | Piemonte, Italy | ||
3695481 | 3695481 | 2020-12-31 | Italy | Piemonte | 197828 | 7922 | 161649 | 28257 | 45.0732745 | 7.680687483 | 2021-01-01 05:23:07 | Piemonte, Italy | ||
1010296 | 1010296 | 2020-12-30 | Italy | Piemonte | 196461 | 7893 | 159609 | 28959 | 45.0732745 | 7.680687483 | 2020-12-31 05:22:49 | Piemonte, Italy | ||
766311 | 766311 | 2020-12-29 | Italy | Piemonte | 195415 | 7860 | 158172 | 29383 | 45.0732745 | 7.680687483 | 2020-12-30 05:22:34 | Piemonte, Italy | ||
3761575 | 3761575 | 2020-12-28 | Italy | Piemonte | 194575 | 7804 | 156468 | 30303 | 45.0732745 | 7.680687483 | 2020-12-29 05:22:37 | Piemonte, Italy | ||
3777895 | 3777895 | 2020-12-27 | Italy | Piemonte | 194262 | 7784 | 155416 | 31062 | 45.0732745 | 7.680687483 | 2020-12-28 05:22:06 | Piemonte, Italy | ||
2223500 | 2223500 | 2020-12-26 | Italy | Piemonte | 193792 | 7767 | 154468 | 31557 | 45.0732745 | 7.680687483 | 2020-12-27 05:22:55 | Piemonte, Italy | ||
202247 | 202247 | 2020-12-25 | Italy | Piemonte | 193375 | 7755 | 154123 | 31497 | 45.0732745 | 7.680687483 | 2020-12-26 05:22:28 | Piemonte, Italy | ||
3691470 | 3691470 | 2020-12-24 | Italy | Piemonte | 192500 | 7727 | 149903 | 34870 | 45.0732745 | 7.680687483 | 2020-12-25 05:22:48 | Piemonte, Italy | ||
2406822 | 2406822 | 2020-12-23 | Italy | Piemonte | 191443 | 7679 | 147203 | 36561 | 45.0732745 | 7.680687483 | 2020-12-24 05:23:04 | Piemonte, Italy | ||
3769868 | 3769868 | 2020-12-22 | Italy | Piemonte | 190510 | 7621 | 145980 | 36909 | 45.0732745 | 7.680687483 | 2020-12-23 05:22:03 | Piemonte, Italy | ||
927684 | 927684 | 2020-12-21 | Italy | Piemonte | 189968 | 7571 | 144440 | 37957 | 45.0732745 | 7.680687483 | 2020-12-22 05:22:33 | Piemonte, Italy | ||
2119705 | 2119705 | 2020-12-20 | Italy | Piemonte | 189357 | 7528 | 143738 | 38091 | 45.0732745 | 7.680687483 | 2020-12-21 05:27:58 | Piemonte, Italy | ||
2931212 | 2931212 | 2020-12-19 | Italy | Piemonte | 188528 | 7499 | 142436 | 38593 | 45.0732745 | 7.680687483 | 2020-12-20 05:27:32 | Piemonte, Italy | ||
1901158 | 1901158 | 2020-12-18 | Italy | Piemonte | 187890 | 7461 | 139129 | 41300 | 45.0732745 | 7.680687483 | 2020-12-19 05:27:52 | Piemonte, Italy | ||
2127984 | 2127984 | 2020-12-17 | Italy | Piemonte | 189270 | 7382 | 136345 | 45543 | 45.0732745 | 7.680687483 | 2020-12-18 05:28:18 | Piemonte, Italy | ||
3149584 | 3149584 | 2020-12-16 | Italy | Piemonte | 188387 | 7302 | 132982 | 48103 | 45.0732745 | 7.680687483 | 2020-12-17 05:28:12 | Piemonte, Italy | ||
1034365 | 1034365 | 2020-12-15 | Italy | Piemonte | 187172 | 7213 | 128989 | 50970 | 45.0732745 | 7.680687483 | 2020-12-16 05:28:04 | Piemonte, Italy | ||
1751259 | 1751259 | 2020-12-14 | Italy | Piemonte | 186066 | 7136 | 125594 | 53336 | 45.0732745 | 7.680687483 | 2020-12-15 05:26:38 | Piemonte, Italy | ||
3847779 | 3847779 | 2020-12-13 | Italy | Piemonte | 185538 | 7088 | 122476 | 55974 | 45.0732745 | 7.680687483 | 2020-12-14 05:26:27 | Piemonte, Italy | ||
845561 | 845561 | 2020-12-12 | Italy | Piemonte | 184527 | 7052 | 119614 | 57861 | 45.0732745 | 7.680687483 | 2020-12-13 05:27:20 | Piemonte, Italy | ||
860668 | 860668 | 2020-12-11 | Italy | Piemonte | 183084 | 6993 | 116100 | 59991 | 45.0732745 | 7.680687483 | 2020-12-12 05:26:19 | Piemonte, Italy | ||
1600210 | 1600210 | 2020-12-10 | Italy | Piemonte | 181531 | 6897 | 113527 | 61107 | 45.0732745 | 7.680687483 | 2020-12-11 05:26:59 | Piemonte, Italy | ||
2975219 | 2975219 | 2020-12-09 | Italy | Piemonte | 180557 | 6813 | 110261 | 63483 | 45.0732745 | 7.680687483 | 2020-12-10 05:26:19 | Piemonte, Italy | ||
1818779 | 1818779 | 2020-12-08 | Italy | Piemonte | 179651 | 6746 | 108392 | 64513 | 45.0732745 | 7.680687483 | 2020-12-09 05:28:01 | Piemonte, Italy | ||
2347415 | 2347415 | 2020-12-07 | Italy | Piemonte | 178699 | 6687 | 106263 | 65749 | 45.0732745 | 7.680687483 | 2020-12-08 05:27:42 | Piemonte, Italy | ||
1006285 | 1006285 | 2020-12-06 | Italy | Piemonte | 177788 | 6623 | 105127 | 66038 | 45.0732745 | 7.680687483 | 2020-12-07 05:26:14 | Piemonte, Italy | ||
1632294 | 1632294 | 2020-12-05 | Italy | Piemonte | 176519 | 6568 | 103188 | 66763 | 45.0732745 | 7.680687483 | 2020-12-06 05:26:18 | Piemonte, Italy | ||
3859822 | 3859822 | 2020-12-04 | Italy | Piemonte | 175063 | 6506 | 100081 | 68476 | 45.0732745 | 7.680687483 | 2020-12-05 05:27:36 | Piemonte, Italy | ||
75080 | 75080 | 2020-12-03 | Italy | Piemonte | 172931 | 6452 | 96473 | 70006 | 45.0732745 | 7.680687483 | 2020-12-04 05:27:27 | Piemonte, Italy | ||
738292 | 738292 | 2020-12-02 | Italy | Piemonte | 170701 | 6360 | 93454 | 70887 | 45.0732745 | 7.680687483 | 2020-12-03 05:28:22 | Piemonte, Italy | ||
2537386 | 2537386 | 2020-12-01 | Italy | Piemonte | 169133 | 6303 | 90561 | 72269 | 45.0732745 | 7.680687483 | 2020-12-02 05:27:41 | Piemonte, Italy | ||
1584155 | 1584155 | 2020-11-30 | Italy | Piemonte | 167516 | 6239 | 86334 | 74943 | 45.0732745 | 7.680687483 | 2020-12-01 05:26:18 | Piemonte, Italy | ||
3566558 | 3566558 | 2020-11-29 | Italy | Piemonte | 166331 | 6154 | 83193 | 76984 | 45.0732745 | 7.680687483 | 2020-11-30 05:26:13 | Piemonte, Italy | ||
2935223 | 2935223 | 2020-11-28 | Italy | Piemonte | 164310 | 6070 | 82163 | 76077 | 45.0732745 | 7.680687483 | 2020-11-29 05:25:55 | Piemonte, Italy | ||
392226 | 392226 | 2020-11-27 | Italy | Piemonte | 162153 | 5972 | 78592 | 77589 | 45.0732745 | 7.680687483 | 2020-11-28 05:25:50 | Piemonte, Italy | ||
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 |
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]);