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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182031 | 182031 | 2021-02-21 | Italy | Piemonte | 238949 | 9265 | 216864 | 12820 | 45.0732745 | 7.680687483 | 2021-02-22 05:24:21 | Piemonte, Italy | ||
742305 | 742305 | 2021-02-20 | Italy | Piemonte | 238147 | 9257 | 216282 | 12608 | 45.0732745 | 7.680687483 | 2021-02-21 05:24:33 | Piemonte, Italy | ||
471403 | 471403 | 2021-02-19 | Italy | Piemonte | 237382 | 9245 | 215700 | 12437 | 45.0732745 | 7.680687483 | 2021-02-20 05:22:51 | Piemonte, Italy | ||
1153112 | 1153112 | 2021-02-18 | Italy | Piemonte | 236075 | 9220 | 214849 | 12006 | 45.0732745 | 7.680687483 | 2021-02-19 05:24:16 | Piemonte, Italy | ||
3601032 | 3601032 | 2021-02-17 | Italy | Piemonte | 235574 | 9204 | 214203 | 12167 | 45.0732745 | 7.680687483 | 2021-02-18 05:22:58 | Piemonte, Italy | ||
3050167 | 3050167 | 2021-02-16 | Italy | Piemonte | 234615 | 9182 | 213207 | 12226 | 45.0732745 | 7.680687483 | 2021-02-17 05:23:10 | Piemonte, Italy | ||
1338266 | 1338266 | 2021-02-15 | Italy | Piemonte | 233844 | 9145 | 212373 | 12326 | 45.0732745 | 7.680687483 | 2021-02-16 05:24:38 | Piemonte, Italy | ||
2283417 | 2283417 | 2021-02-14 | Italy | Piemonte | 233406 | 9131 | 211914 | 12361 | 45.0732745 | 7.680687483 | 2021-02-15 05:24:49 | Piemonte, Italy | ||
2677817 | 2677817 | 2021-02-13 | Italy | Piemonte | 232857 | 9125 | 211465 | 12267 | 45.0732745 | 7.680687483 | 2021-02-14 05:23:43 | Piemonte, Italy | ||
3539450 | 3539450 | 2021-02-12 | Italy | Piemonte | 232108 | 9109 | 210654 | 12345 | 45.0732745 | 7.680687483 | 2021-02-13 05:22:12 | Piemonte, Italy | ||
2637713 | 2637713 | 2021-02-11 | Italy | Piemonte | 231239 | 9089 | 209960 | 12190 | 45.0732745 | 7.680687483 | 2021-02-12 05:23:29 | Piemonte, Italy | ||
3978568 | 3978568 | 2021-02-10 | Italy | Piemonte | 230050 | 9067 | 208934 | 12049 | 45.0732745 | 7.680687483 | 2021-02-11 05:23:55 | Piemonte, Italy | ||
1527888 | 1527888 | 2021-02-09 | Italy | Piemonte | 229381 | 9049 | 208261 | 12071 | 45.0732745 | 7.680687483 | 2021-02-10 05:22:41 | Piemonte, Italy | ||
613679 | 613679 | 2021-02-08 | Italy | Piemonte | 228762 | 9014 | 207457 | 12291 | 45.0732745 | 7.680687483 | 2021-02-09 05:23:30 | Piemonte, Italy | ||
1672448 | 1672448 | 2021-02-07 | Italy | Piemonte | 228279 | 9002 | 206955 | 12322 | 45.0732745 | 7.680687483 | 2021-02-08 05:22:39 | Piemonte, Italy | ||
974909 | 974909 | 2021-02-06 | Italy | Piemonte | 227655 | 8994 | 206479 | 12182 | 45.0732745 | 7.680687483 | 2021-02-07 05:23:00 | Piemonte, Italy | ||
1588167 | 1588167 | 2021-02-05 | Italy | Piemonte | 226938 | 8973 | 205770 | 12195 | 45.0732745 | 7.680687483 | 2021-02-06 05:23:55 | Piemonte, Italy | ||
790374 | 790374 | 2021-02-04 | Italy | Piemonte | 226002 | 8951 | 205021 | 12030 | 45.0732745 | 7.680687483 | 2021-02-05 05:22:38 | Piemonte, Italy | ||
340266 | 340266 | 2021-02-03 | Italy | Piemonte | 225195 | 8920 | 204223 | 12052 | 45.0732745 | 7.680687483 | 2021-02-04 05:22:26 | Piemonte, Italy | ||
1684492 | 1684492 | 2021-02-02 | Italy | Piemonte | 224376 | 8895 | 203356 | 12125 | 45.0732745 | 7.680687483 | 2021-02-03 05:22:52 | Piemonte, Italy | ||
1676462 | 1676462 | 2021-02-01 | Italy | Piemonte | 223611 | 8858 | 202489 | 12264 | 45.0732745 | 7.680687483 | 2021-02-02 05:22:49 | Piemonte, Italy | ||
1459750 | 1459750 | 2021-01-31 | Italy | Piemonte | 223097 | 8847 | 201938 | 12312 | 45.0732745 | 7.680687483 | 2021-02-01 05:22:53 | Piemonte, Italy | ||
2211658 | 2211658 | 2021-01-30 | Italy | Piemonte | 222559 | 8833 | 201344 | 12382 | 45.0732745 | 7.680687483 | 2021-01-31 05:22:42 | Piemonte, Italy | ||
1897145 | 1897145 | 2021-01-29 | Italy | Piemonte | 221832 | 8774 | 200521 | 12537 | 45.0732745 | 7.680687483 | 2021-01-30 05:22:49 | Piemonte, Italy | ||
2481961 | 2481961 | 2021-01-28 | Italy | Piemonte | 220888 | 8736 | 199668 | 12484 | 45.0732745 | 7.680687483 | 2021-01-29 05:22:23 | Piemonte, Italy | ||
3153596 | 3153596 | 2021-01-27 | Italy | Piemonte | 219826 | 8693 | 198732 | 12401 | 45.0732745 | 7.680687483 | 2021-01-28 05:22:24 | Piemonte, Italy | ||
12331 | 12331 | 2021-01-26 | Italy | Piemonte | 219005 | 8642 | 197629 | 12734 | 45.0732745 | 7.680687483 | 2021-01-27 05:23:41 | Piemonte, Italy | ||
2567655 | 2567655 | 2021-01-25 | Italy | Piemonte | 218277 | 8604 | 196455 | 13218 | 45.0732745 | 7.680687483 | 2021-01-26 05:22:02 | Piemonte, Italy | ||
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 |
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]);