⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

402 rows where country_or_region = "Italy" and province_or_state = "Valle d'Aosta" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Valle d'Aosta · 402

country_or_region

  • Italy · 402
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168457 2021-06-19 Italy Valle d'Aosta     11670 472 11137 61 45.73750286 7.320149366 2021-06-20 04:21:48 Valle d'Aosta, Italy
685982 2021-06-18 Italy Valle d'Aosta     11667 472 11131 64 45.73750286 7.320149366 2021-06-19 04:22:33 Valle d'Aosta, Italy
958039 2021-06-17 Italy Valle d'Aosta     11665 472 11119 74 45.73750286 7.320149366 2021-06-18 04:22:16 Valle d'Aosta, Italy
1281406 2021-06-16 Italy Valle d'Aosta     11662 472 11109 81 45.73750286 7.320149366 2021-06-17 04:22:36 Valle d'Aosta, Italy
681996 2021-06-15 Italy Valle d'Aosta     11661 472 11099 90 45.73750286 7.320149366 2021-06-16 04:22:32 Valle d'Aosta, Italy
372550 2021-06-14 Italy Valle d'Aosta     11658 472 11090 96 45.73750286 7.320149366 2021-06-15 04:22:22 Valle d'Aosta, Italy
1223366 2021-06-13 Italy Valle d'Aosta     11656 472 11089 95 45.73750286 7.320149366 2021-06-14 04:22:46 Valle d'Aosta, Italy
80647 2021-06-12 Italy Valle d'Aosta     11655 472 11082 101 45.73750286 7.320149366 2021-06-13 04:22:44 Valle d'Aosta, Italy
969950 2021-06-11 Italy Valle d'Aosta     11653 472 11069 112 45.73750286 7.320149366 2021-06-12 04:22:22 Valle d'Aosta, Italy
1438523 2021-06-10 Italy Valle d'Aosta     11649 472 11061 116 45.73750286 7.320149366 2021-06-11 04:23:20 Valle d'Aosta, Italy
1157022 2021-06-09 Italy Valle d'Aosta     11641 472 11051 118 45.73750286 7.320149366 2021-06-10 04:23:17 Valle d'Aosta, Italy
1231338 2021-06-08 Italy Valle d'Aosta     11637 472 11035 130 45.73750286 7.320149366 2021-06-09 04:23:31 Valle d'Aosta, Italy
360334 2021-06-07 Italy Valle d'Aosta     11629 472 11006 151 45.73750286 7.320149366 2021-06-08 04:22:35 Valle d'Aosta, Italy
1075962 2021-06-06 Italy Valle d'Aosta     11626 472 11005 149 45.73750286 7.320149366 2021-06-07 04:22:51 Valle d'Aosta, Italy
1613354 2021-06-05 Italy Valle d'Aosta     11621 472 10989 160 45.73750286 7.320149366 2021-06-06 04:24:03 Valle d'Aosta, Italy
1125640 2021-06-04 Italy Valle d'Aosta     11616 472 10977 167 45.73750286 7.320149366 2021-06-05 04:23:03 Valle d'Aosta, Italy
318096 2021-06-03 Italy Valle d'Aosta     11611 472 10957 182 45.73750286 7.320149366 2021-06-04 04:23:37 Valle d'Aosta, Italy
1133609 2021-06-02 Italy Valle d'Aosta     11609 472 10933 204 45.73750286 7.320149366 2021-06-03 04:23:32 Valle d'Aosta, Italy
291786 2021-06-01 Italy Valle d'Aosta     11601 472 10917 212 45.73750286 7.320149366 2021-06-02 04:24:34 Valle d'Aosta, Italy
1651737 2021-05-31 Italy Valle d'Aosta     11593 472 10885 236 45.73750286 7.320149366 2021-06-01 04:23:09 Valle d'Aosta, Italy
980965 2021-05-30 Italy Valle d'Aosta     11583 472 10883 228 45.73750286 7.320149366 2021-05-31 03:08:59 Valle d'Aosta, Italy
841346 2021-05-29 Italy Valle d'Aosta     11567 472 10868 227 45.73750286 7.320149366 2021-05-30 04:20:55 Valle d'Aosta, Italy
697918 2021-05-28 Italy Valle d'Aosta     11545 472 10853 220 45.73750286 7.320149366 2021-05-29 04:20:41 Valle d'Aosta, Italy
1369419 2021-05-27 Italy Valle d'Aosta     11541 472 10834 235 45.73750286 7.320149366 2021-05-28 04:20:36 Valle d'Aosta, Italy
1292504 2021-05-26 Italy Valle d'Aosta     11534 472 10820 242 45.73750286 7.320149366 2021-05-27 04:20:59 Valle d'Aosta, Italy
602875 2021-05-25 Italy Valle d'Aosta     11525 472 10795 258 45.73750286 7.320149366 2021-05-26 04:20:35 Valle d'Aosta, Italy
1365433 2021-05-24 Italy Valle d'Aosta     11504 471 10748 285 45.73750286 7.320149366 2021-05-25 04:21:08 Valle d'Aosta, Italy
419946 2021-05-23 Italy Valle d'Aosta     11499 471 10733 295 45.73750286 7.320149366 2021-05-24 04:20:53 Valle d'Aosta, Italy
54285 2021-05-22 Italy Valle d'Aosta     11484 471 10698 315 45.73750286 7.320149366 2021-05-23 04:20:51 Valle d'Aosta, Italy
368564 2021-05-21 Italy Valle d'Aosta     11456 471 10660 325 45.73750286 7.320149366 2021-05-22 04:20:45 Valle d'Aosta, Italy
1024363 2021-05-20 Italy Valle d'Aosta     11443 471 10628 344 45.73750286 7.320149366 2021-05-21 04:20:43 Valle d'Aosta, Italy
1678989 2021-05-19 Italy Valle d'Aosta     11425 471 10600 354 45.73750286 7.320149366 2021-05-20 04:21:05 Valle d'Aosta, Italy
64976 2021-05-18 Italy Valle d'Aosta     11402 469 10546 387 45.73750286 7.320149366 2021-05-19 04:20:42 Valle d'Aosta, Italy
1243048 2021-05-17 Italy Valle d'Aosta     11393 468 10483 442 45.73750286 7.320149366 2021-05-18 04:20:33 Valle d'Aosta, Italy
1067896 2021-05-16 Italy Valle d'Aosta     11384 467 10466 451 45.73750286 7.320149366 2021-05-17 04:20:34 Valle d'Aosta, Italy
505024 2021-05-15 Italy Valle d'Aosta     11364 467 10425 472 45.73750286 7.320149366 2021-05-16 04:20:49 Valle d'Aosta, Italy
892629 2021-05-14 Italy Valle d'Aosta     11354 466 10372 516 45.73750286 7.320149366 2021-05-15 04:20:58 Valle d'Aosta, Italy
531964 2021-05-13 Italy Valle d'Aosta     11311 466 10342 503 45.73750286 7.320149366 2021-05-14 04:20:41 Valle d'Aosta, Italy
1719251 2021-05-12 Italy Valle d'Aosta     11282 466 10303 513 45.73750286 7.320149366 2021-05-13 04:20:51 Valle d'Aosta, Italy
1723237 2021-05-11 Italy Valle d'Aosta     11259 464 10261 534 45.73750286 7.320149366 2021-05-12 04:21:29 Valle d'Aosta, Italy
1164994 2021-05-10 Italy Valle d'Aosta     11236 463 10205 568 45.73750286 7.320149366 2021-05-11 04:20:41 Valle d'Aosta, Italy
1168980 2021-05-09 Italy Valle d'Aosta     11217 462 10163 592 45.73750286 7.320149366 2021-05-10 04:20:38 Valle d'Aosta, Italy
1659767 2021-05-08 Italy Valle d'Aosta     11209 462 10142 605 45.73750286 7.320149366 2021-05-09 04:20:35 Valle d'Aosta, Italy
799865 2021-05-07 Italy Valle d'Aosta     11169 461 10078 630 45.73750286 7.320149366 2021-05-08 04:21:04 Valle d'Aosta, Italy
1219380 2021-05-06 Italy Valle d'Aosta     11118 461 10047 610 45.73750286 7.320149366 2021-05-07 04:20:40 Valle d'Aosta, Italy
415960 2021-05-05 Italy Valle d'Aosta     11078 460 9988 630 45.73750286 7.320149366 2021-05-06 04:20:38 Valle d'Aosta, Italy
673981 2021-05-04 Italy Valle d'Aosta     11066 459 9922 685 45.73750286 7.320149366 2021-05-05 04:20:43 Valle d'Aosta, Italy
1088005 2021-05-03 Italy Valle d'Aosta     11041 459 9867 715 45.73750286 7.320149366 2021-05-04 04:20:34 Valle d'Aosta, Italy
1727223 2021-05-02 Italy Valle d'Aosta     11013 459 9856 698 45.73750286 7.320149366 2021-05-03 04:20:39 Valle d'Aosta, Italy
1084019 2021-05-01 Italy Valle d'Aosta     10990 459 9804 727 45.73750286 7.320149366 2021-05-02 04:20:48 Valle d'Aosta, Italy
1388547 2021-04-30 Italy Valle d'Aosta     10932 458 9725 749 45.73750286 7.320149366 2021-05-01 04:20:47 Valle d'Aosta, Italy
38366 2021-04-29 Italy Valle d'Aosta     10884 455 9665 764 45.73750286 7.320149366 2021-04-30 04:21:03 Valle d'Aosta, Italy
11939 2021-04-28 Italy Valle d'Aosta     10823 455 9618 750 45.73750286 7.320149366 2021-04-29 04:20:55 Valle d'Aosta, Italy
853322 2021-04-27 Italy Valle d'Aosta     10786 454 9549 783 45.73750286 7.320149366 2021-04-28 04:20:32 Valle d'Aosta, Italy
1063910 2021-04-26 Italy Valle d'Aosta     10746 454 9478 814 45.73750286 7.320149366 2021-04-27 04:20:52 Valle d'Aosta, Italy
1476160 2021-04-25 Italy Valle d'Aosta     10693 451 9450 792 45.73750286 7.320149366 2021-04-26 04:21:04 Valle d'Aosta, Italy
743781 2021-04-24 Italy Valle d'Aosta     10643 450 9412 781 45.73750286 7.320149366 2021-04-25 04:20:32 Valle d'Aosta, Italy
1430580 2021-04-23 Italy Valle d'Aosta     10598 446 9311 841 45.73750286 7.320149366 2021-04-24 04:20:38 Valle d'Aosta, Italy
96409 2021-04-22 Italy Valle d'Aosta     10553 445 9245 863 45.73750286 7.320149366 2021-04-23 04:20:52 Valle d'Aosta, Italy
849336 2021-04-21 Italy Valle d'Aosta     10514 443 9180 891 45.73750286 7.320149366 2021-04-22 04:20:53 Valle d'Aosta, Italy
826954 2021-04-20 Italy Valle d'Aosta     10468 441 9106 921 45.73750286 7.320149366 2021-04-21 04:21:14 Valle d'Aosta, Italy
770665 2021-04-19 Italy Valle d'Aosta     10433 439 9015 979 45.73750286 7.320149366 2021-04-20 04:20:41 Valle d'Aosta, Italy
1415974 2021-04-18 Italy Valle d'Aosta     10366 439 8975 952 45.73750286 7.320149366 2021-04-19 04:20:57 Valle d'Aosta, Italy
984951 2021-04-17 Italy Valle d'Aosta     10337 439 8879 1019 45.73750286 7.320149366 2021-04-18 04:20:41 Valle d'Aosta, Italy
238014 2021-04-16 Italy Valle d'Aosta     10299 437 8816 1046 45.73750286 7.320149366 2021-04-17 04:20:40 Valle d'Aosta, Italy
579743 2021-04-15 Italy Valle d'Aosta     10269 437 8740 1092 45.73750286 7.320149366 2021-04-16 04:20:46 Valle d'Aosta, Italy
1266371 2021-04-14 Italy Valle d'Aosta     10195 436 8617 1142 45.73750286 7.320149366 2021-04-15 04:20:54 Valle d'Aosta, Italy
701904 2021-04-13 Italy Valle d'Aosta     10135 436 8579 1120 45.73750286 7.320149366 2021-04-14 04:20:41 Valle d'Aosta, Italy
1671017 2021-04-12 Italy Valle d'Aosta     10087 436 8522 1129 45.73750286 7.320149366 2021-04-13 04:20:37 Valle d'Aosta, Italy
784722 2021-04-11 Italy Valle d'Aosta     10055 436 8509 1110 45.73750286 7.320149366 2021-04-12 04:21:00 Valle d'Aosta, Italy
1392533 2021-04-10 Italy Valle d'Aosta     10013 436 8435 1142 45.73750286 7.320149366 2021-04-11 04:20:56 Valle d'Aosta, Italy
965964 2021-04-09 Italy Valle d'Aosta     9935 436 8372 1127 45.73750286 7.320149366 2021-04-10 04:20:59 Valle d'Aosta, Italy
689968 2021-04-08 Italy Valle d'Aosta     9870 434 8324 1112 45.73750286 7.320149366 2021-04-09 04:21:13 Valle d'Aosta, Italy
1277420 2021-04-07 Italy Valle d'Aosta     9816 431 8212 1173 45.73750286 7.320149366 2021-04-08 04:21:13 Valle d'Aosta, Italy
88439 2021-04-06 Italy Valle d'Aosta     9755 429 8129 1197 45.73750286 7.320149366 2021-04-07 04:20:53 Valle d'Aosta, Italy
122821 2021-04-05 Italy Valle d'Aosta     9721 428 8120 1173 45.73750286 7.320149366 2021-04-06 04:20:32 Valle d'Aosta, Italy
73323 2021-04-04 Italy Valle d'Aosta     9646 428 8112 1106 45.73750286 7.320149366 2021-04-05 04:20:35 Valle d'Aosta, Italy
791939 2021-04-03 Italy Valle d'Aosta     9544 427 8072 1045 45.73750286 7.320149366 2021-04-04 04:20:49 Valle d'Aosta, Italy
1020377 2021-04-02 Italy Valle d'Aosta     9465 426 8041 998 45.73750286 7.320149366 2021-04-03 04:20:44 Valle d'Aosta, Italy
1350539 2021-04-01 Italy Valle d'Aosta     9350 425 7996 929 45.73750286 7.320149366 2021-04-02 04:20:36 Valle d'Aosta, Italy
1690925 2021-03-31 Italy Valle d'Aosta     9298 425 7971 902 45.73750286 7.320149366 2021-04-01 04:27:05 Valle d'Aosta, Italy
873294 2021-03-30 Italy Valle d'Aosta     9236 424 7910 902 45.73750286 7.320149366 2021-03-31 04:26:25 Valle d'Aosta, Italy
1400341 2021-03-29 Italy Valle d'Aosta     9102 421 7839 842 45.73750286 7.320149366 2021-03-30 04:26:23 Valle d'Aosta, Italy
1624744 2021-03-28 Italy Valle d'Aosta     9075 420 7835 820 45.73750286 7.320149366 2021-03-29 04:28:35 Valle d'Aosta, Italy
1472174 2021-03-27 Italy Valle d'Aosta     8998 420 7787 791 45.73750286 7.320149366 2021-03-28 05:28:10 Valle d'Aosta, Italy
720721 2021-03-26 Italy Valle d'Aosta     8873 420 7763 690 45.73750286 7.320149366 2021-03-27 05:25:04 Valle d'Aosta, Italy
1617340 2021-03-25 Italy Valle d'Aosta     8816 419 7748 649 45.73750286 7.320149366 2021-03-26 05:26:55 Valle d'Aosta, Italy
470001 2021-03-24 Italy Valle d'Aosta     8755 419 7709 627 45.73750286 7.320149366 2021-03-25 05:27:00 Valle d'Aosta, Italy
1585041 2021-03-23 Italy Valle d'Aosta     8685 419 7697 569 45.73750286 7.320149366 2021-03-24 05:25:40 Valle d'Aosta, Italy
716735 2021-03-22 Italy Valle d'Aosta     8655 419 7671 565 45.73750286 7.320149366 2021-03-23 05:26:18 Valle d'Aosta, Italy
1675003 2021-03-21 Italy Valle d'Aosta     8603 419 7654 530 45.73750286 7.320149366 2021-03-22 05:25:43 Valle d'Aosta, Italy
1746942 2021-03-20 Italy Valle d'Aosta     8575 419 7653 503 45.73750286 7.320149366 2021-03-21 05:25:44 Valle d'Aosta, Italy
230064 2021-03-19 Italy Valle d'Aosta     8514 419 7642 453 45.73750286 7.320149366 2021-03-20 05:25:46 Valle d'Aosta, Italy
477999 2021-03-18 Italy Valle d'Aosta     8451 419 7634 398 45.73750286 7.320149366 2021-03-19 05:26:09 Valle d'Aosta, Italy
1426594 2021-03-17 Italy Valle d'Aosta     8414 419 7626 369 45.73750286 7.320149366 2021-03-18 05:26:22 Valle d'Aosta, Italy
1593182 2021-03-16 Italy Valle d'Aosta     8365 418 7602 345 45.73750286 7.320149366 2021-03-17 05:25:07 Valle d'Aosta, Italy
1176181 2021-03-15 Italy Valle d'Aosta     8341 417 7591 333 45.73750286 7.320149366 2021-03-16 05:25:13 Valle d'Aosta, Italy
275866 2021-03-14 Italy Valle d'Aosta     8305 417 7586 302 45.73750286 7.320149366 2021-03-15 05:25:51 Valle d'Aosta, Italy
1161008 2021-03-13 Italy Valle d'Aosta     8271 417 7582 272 45.73750286 7.320149366 2021-03-14 05:25:37 Valle d'Aosta, Italy
22515 2021-03-12 Italy Valle d'Aosta     8240 417 7576 247 45.73750286 7.320149366 2021-03-13 05:25:15 Valle d'Aosta, Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);