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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1636307 | 1636307 | 2021-04-29 | Italy | Piemonte | 344357 | 11237 | 316999 | 16121 | 45.0732745 | 7.680687483 | 2021-04-30 04:21:03 | Piemonte, Italy | ||
3393386 | 3393386 | 2021-04-28 | Italy | Piemonte | 343273 | 11219 | 315596 | 16458 | 45.0732745 | 7.680687483 | 2021-04-29 04:20:55 | Piemonte, Italy | ||
3702102 | 3702102 | 2021-04-27 | Italy | Piemonte | 342086 | 11185 | 314137 | 16764 | 45.0732745 | 7.680687483 | 2021-04-28 04:20:32 | Piemonte, Italy | ||
888111 | 888111 | 2021-04-26 | Italy | Piemonte | 341419 | 11158 | 313172 | 17089 | 45.0732745 | 7.680687483 | 2021-04-27 04:20:52 | Piemonte, Italy | ||
954856 | 954856 | 2021-04-25 | Italy | Piemonte | 340851 | 11137 | 312241 | 17473 | 45.0732745 | 7.680687483 | 2021-04-26 04:21:04 | Piemonte, Italy | ||
3924003 | 3924003 | 2021-04-24 | Italy | Piemonte | 339873 | 11124 | 311098 | 17651 | 45.0732745 | 7.680687483 | 2021-04-25 04:20:32 | Piemonte, Italy | ||
1409034 | 1409034 | 2021-04-23 | Italy | Piemonte | 339052 | 11104 | 309503 | 18445 | 45.0732745 | 7.680687483 | 2021-04-24 04:20:38 | Piemonte, Italy | ||
1568097 | 1568097 | 2021-04-22 | Italy | Piemonte | 337953 | 11085 | 307736 | 19132 | 45.0732745 | 7.680687483 | 2021-04-23 04:20:52 | Piemonte, Italy | ||
3242318 | 3242318 | 2021-04-21 | Italy | Piemonte | 336489 | 11039 | 305622 | 19828 | 45.0732745 | 7.680687483 | 2021-04-22 04:20:53 | Piemonte, Italy | ||
2020714 | 2020714 | 2021-04-20 | Italy | Piemonte | 335463 | 10991 | 303708 | 20764 | 45.0732745 | 7.680687483 | 2021-04-21 04:21:14 | Piemonte, Italy | ||
2410835 | 2410835 | 2021-04-19 | Italy | Piemonte | 334475 | 10960 | 301931 | 21584 | 45.0732745 | 7.680687483 | 2021-04-20 04:20:41 | Piemonte, Italy | ||
3129512 | 3129512 | 2021-04-18 | Italy | Piemonte | 333788 | 10927 | 300265 | 22596 | 45.0732745 | 7.680687483 | 2021-04-19 04:20:57 | Piemonte, Italy | ||
982940 | 982940 | 2021-04-17 | Italy | Piemonte | 333037 | 10924 | 299710 | 22403 | 45.0732745 | 7.680687483 | 2021-04-18 04:20:41 | Piemonte, Italy | ||
170035 | 170035 | 2021-04-16 | Italy | Piemonte | 332172 | 10899 | 297901 | 23372 | 45.0732745 | 7.680687483 | 2021-04-17 04:20:40 | Piemonte, Italy | ||
2548866 | 2548866 | 2021-04-15 | Italy | Piemonte | 330972 | 10861 | 295770 | 24341 | 45.0732745 | 7.680687483 | 2021-04-16 04:20:46 | Piemonte, Italy | ||
1841936 | 1841936 | 2021-04-14 | Italy | Piemonte | 329708 | 10835 | 293615 | 25258 | 45.0732745 | 7.680687483 | 2021-04-15 04:20:54 | Piemonte, Italy | ||
2571670 | 2571670 | 2021-04-13 | Italy | Piemonte | 328269 | 10765 | 291115 | 26389 | 45.0732745 | 7.680687483 | 2021-04-14 04:20:41 | Piemonte, Italy | ||
36421 | 36421 | 2021-04-12 | Italy | Piemonte | 327212 | 10690 | 288861 | 27661 | 45.0732745 | 7.680687483 | 2021-04-13 04:20:37 | Piemonte, Italy | ||
3883580 | 3883580 | 2021-04-11 | Italy | Piemonte | 326576 | 10660 | 287544 | 28372 | 45.0732745 | 7.680687483 | 2021-04-12 04:21:00 | Piemonte, Italy | ||
2983248 | 2983248 | 2021-04-10 | Italy | Piemonte | 325204 | 10647 | 285884 | 28673 | 45.0732745 | 7.680687483 | 2021-04-11 04:20:56 | Piemonte, Italy | ||
605680 | 605680 | 2021-04-09 | Italy | Piemonte | 323937 | 10625 | 283629 | 29683 | 45.0732745 | 7.680687483 | 2021-04-10 04:20:59 | Piemonte, Italy | ||
2645744 | 2645744 | 2021-04-08 | Italy | Piemonte | 322139 | 10588 | 281158 | 30393 | 45.0732745 | 7.680687483 | 2021-04-09 04:21:13 | Piemonte, Italy | ||
2247386 | 2247386 | 2021-04-07 | Italy | Piemonte | 320478 | 10560 | 278396 | 31522 | 45.0732745 | 7.680687483 | 2021-04-08 04:21:13 | Piemonte, Italy | ||
3003296 | 3003296 | 2021-04-06 | Italy | Piemonte | 319014 | 10481 | 275745 | 32788 | 45.0732745 | 7.680687483 | 2021-04-07 04:20:53 | Piemonte, Italy | ||
3085291 | 3085291 | 2021-04-05 | Italy | Piemonte | 318162 | 10463 | 273946 | 33753 | 45.0732745 | 7.680687483 | 2021-04-06 04:20:32 | Piemonte, Italy | ||
388214 | 388214 | 2021-04-04 | Italy | Piemonte | 317358 | 10450 | 272953 | 33955 | 45.0732745 | 7.680687483 | 2021-04-05 04:20:35 | Piemonte, Italy | ||
3710130 | 3710130 | 2021-04-03 | Italy | Piemonte | 315933 | 10422 | 271475 | 34036 | 45.0732745 | 7.680687483 | 2021-04-04 04:20:49 | Piemonte, Italy | ||
241246 | 241246 | 2021-04-02 | Italy | Piemonte | 313806 | 10399 | 269038 | 34369 | 45.0732745 | 7.680687483 | 2021-04-03 04:20:44 | Piemonte, Italy | ||
1302043 | 1302043 | 2021-04-01 | Italy | Piemonte | 311864 | 10336 | 266781 | 34747 | 45.0732745 | 7.680687483 | 2021-04-02 04:20:36 | Piemonte, Italy | ||
637915 | 637915 | 2021-03-31 | Italy | Piemonte | 309280 | 10308 | 263913 | 35059 | 45.0732745 | 7.680687483 | 2021-04-01 04:27:05 | Piemonte, Italy | ||
3643544 | 3643544 | 2021-03-30 | Italy | Piemonte | 306982 | 10269 | 261296 | 35417 | 45.0732745 | 7.680687483 | 2021-03-31 04:26:25 | Piemonte, Italy | ||
1289997 | 1289997 | 2021-03-29 | Italy | Piemonte | 305121 | 10208 | 259128 | 35785 | 45.0732745 | 7.680687483 | 2021-03-30 04:26:23 | Piemonte, Italy | ||
1535919 | 1535919 | 2021-03-28 | Italy | Piemonte | 303617 | 10190 | 257852 | 35575 | 45.0732745 | 7.680687483 | 2021-03-29 04:28:35 | Piemonte, Italy | ||
1219559 | 1219559 | 2021-03-27 | Italy | Piemonte | 302074 | 10180 | 256309 | 35585 | 45.0732745 | 7.680687483 | 2021-03-28 05:28:10 | Piemonte, Italy | ||
1880977 | 1880977 | 2021-03-26 | Italy | Piemonte | 299438 | 10131 | 254172 | 35135 | 45.0732745 | 7.680687483 | 2021-03-27 05:25:04 | Piemonte, Italy | ||
1980607 | 1980607 | 2021-03-25 | Italy | Piemonte | 297321 | 10093 | 251936 | 35292 | 45.0732745 | 7.680687483 | 2021-03-26 05:26:55 | Piemonte, Italy | ||
2780985 | 2780985 | 2021-03-24 | Italy | Piemonte | 294739 | 10053 | 249738 | 34948 | 45.0732745 | 7.680687483 | 2021-03-25 05:27:00 | Piemonte, Italy | ||
1798630 | 1798630 | 2021-03-23 | Italy | Piemonte | 292516 | 10023 | 247610 | 34883 | 45.0732745 | 7.680687483 | 2021-03-24 05:25:40 | Piemonte, Italy | ||
1203798 | 1203798 | 2021-03-22 | Italy | Piemonte | 290436 | 9948 | 245605 | 34883 | 45.0732745 | 7.680687483 | 2021-03-23 05:26:18 | Piemonte, Italy | ||
3369320 | 3369320 | 2021-03-21 | Italy | Piemonte | 288915 | 9908 | 244476 | 34531 | 45.0732745 | 7.680687483 | 2021-03-22 05:25:43 | Piemonte, Italy | ||
1744530 | 1744530 | 2021-03-20 | Italy | Piemonte | 287164 | 9896 | 243271 | 33997 | 45.0732745 | 7.680687483 | 2021-03-21 05:25:44 | Piemonte, Italy | ||
3420910 | 3420910 | 2021-03-19 | Italy | Piemonte | 285023 | 9844 | 241724 | 33455 | 45.0732745 | 7.680687483 | 2021-03-20 05:25:46 | Piemonte, Italy | ||
3452848 | 3452848 | 2021-03-18 | Italy | Piemonte | 282026 | 9811 | 240055 | 32160 | 45.0732745 | 7.680687483 | 2021-03-19 05:26:09 | Piemonte, Italy | ||
3621072 | 3621072 | 2021-03-17 | Italy | Piemonte | 279669 | 9766 | 238509 | 31394 | 45.0732745 | 7.680687483 | 2021-03-18 05:26:22 | Piemonte, Italy | ||
702396 | 702396 | 2021-03-16 | Italy | Piemonte | 277295 | 9725 | 236786 | 30784 | 45.0732745 | 7.680687483 | 2021-03-17 05:25:07 | Piemonte, Italy | ||
2055874 | 2055874 | 2021-03-15 | Italy | Piemonte | 275221 | 9682 | 235339 | 30200 | 45.0732745 | 7.680687483 | 2021-03-16 05:25:13 | Piemonte, Italy | ||
1732486 | 1732486 | 2021-03-14 | Italy | Piemonte | 273479 | 9663 | 234164 | 29652 | 45.0732745 | 7.680687483 | 2021-03-15 05:25:51 | Piemonte, Italy | ||
1580143 | 1580143 | 2021-03-13 | Italy | Piemonte | 271949 | 9660 | 233612 | 28677 | 45.0732745 | 7.680687483 | 2021-03-14 05:25:37 | Piemonte, Italy | ||
1837922 | 1837922 | 2021-03-12 | Italy | Piemonte | 269790 | 9632 | 232519 | 27639 | 45.0732745 | 7.680687483 | 2021-03-13 05:25:15 | Piemonte, Italy | ||
352287 | 352287 | 2021-03-11 | Italy | Piemonte | 266861 | 9604 | 231252 | 26005 | 45.0732745 | 7.680687483 | 2021-03-12 05:26:50 | Piemonte, Italy | ||
3962511 | 3962511 | 2021-03-10 | Italy | Piemonte | 264539 | 9562 | 230300 | 24677 | 45.0732745 | 7.680687483 | 2021-03-11 05:25:48 | Piemonte, Italy | ||
3663599 | 3663599 | 2021-03-09 | Italy | Piemonte | 262453 | 9533 | 229138 | 23782 | 45.0732745 | 7.680687483 | 2021-03-10 05:24:35 | Piemonte, Italy | ||
2359458 | 2359458 | 2021-03-08 | Italy | Piemonte | 260435 | 9511 | 228042 | 22882 | 45.0732745 | 7.680687483 | 2021-03-09 05:28:19 | Piemonte, Italy | ||
54796 | 54796 | 2021-03-07 | Italy | Piemonte | 259221 | 9495 | 227421 | 22305 | 45.0732745 | 7.680687483 | 2021-03-08 05:24:48 | Piemonte, Italy | ||
3667613 | 3667613 | 2021-03-06 | Italy | Piemonte | 257678 | 9486 | 226737 | 21455 | 45.0732745 | 7.680687483 | 2021-03-07 05:21:54 | Piemonte, Italy | ||
1616234 | 1616234 | 2021-03-05 | Italy | Piemonte | 255885 | 9461 | 225923 | 20501 | 45.0732745 | 7.680687483 | 2021-03-06 04:23:41 | Piemonte, Italy | ||
2207645 | 2207645 | 2021-03-04 | Italy | Piemonte | 253602 | 9437 | 225008 | 19157 | 45.0732745 | 7.680687483 | 2021-03-05 05:26:29 | Piemonte, Italy | ||
1090066 | 1090066 | 2021-03-03 | Italy | Piemonte | 251435 | 9411 | 224093 | 17931 | 45.0732745 | 7.680687483 | 2021-03-04 05:24:24 | Piemonte, Italy | ||
3254138 | 3254138 | 2021-03-02 | Italy | Piemonte | 249898 | 9395 | 223170 | 17333 | 45.0732745 | 7.680687483 | 2021-03-03 05:23:28 | Piemonte, Italy | ||
998430 | 998430 | 2021-03-01 | Italy | Piemonte | 248289 | 9375 | 222293 | 16621 | 45.0732745 | 7.680687483 | 2021-03-02 05:23:30 | Piemonte, Italy | ||
2367488 | 2367488 | 2021-02-28 | Italy | Piemonte | 247134 | 9369 | 221688 | 16077 | 45.0732745 | 7.680687483 | 2021-03-01 05:23:01 | Piemonte, Italy | ||
3065990 | 3065990 | 2021-02-27 | Italy | Piemonte | 246232 | 9365 | 221224 | 15643 | 45.0732745 | 7.680687483 | 2021-02-28 05:22:20 | Piemonte, Italy | ||
2183574 | 2183574 | 2021-02-26 | Italy | Piemonte | 245044 | 9351 | 220570 | 15123 | 45.0732745 | 7.680687483 | 2021-02-27 05:22:28 | Piemonte, Italy | ||
1857996 | 1857996 | 2021-02-25 | Italy | Piemonte | 243518 | 9346 | 219849 | 14323 | 45.0732745 | 7.680687483 | 2021-02-26 05:22:40 | Piemonte, Italy | ||
280174 | 280174 | 2021-02-24 | Italy | Piemonte | 242064 | 9326 | 219121 | 13617 | 45.0732745 | 7.680687483 | 2021-02-25 05:24:57 | Piemonte, Italy | ||
1936442 | 1936442 | 2021-02-23 | Italy | Piemonte | 240611 | 9309 | 218197 | 13105 | 45.0732745 | 7.680687483 | 2021-02-24 05:29:16 | Piemonte, Italy | ||
530697 | 530697 | 2021-02-22 | Italy | Piemonte | 239588 | 9287 | 217381 | 12920 | 45.0732745 | 7.680687483 | 2021-02-23 05:23:41 | Piemonte, Italy | ||
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 |
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]);