⚠️ 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

397 rows where country_or_region = "Italy" and province_or_state = "Basilicata" sorted by day descending

View and edit SQL

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

province_or_state

  • Basilicata · 397

country_or_region

  • Italy · 397
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
222906 2021-06-14 Italy Basilicata     26689 586 23150 2953 40.63947052 15.80514834 2021-06-15 04:22:22 Basilicata, Italy
214938 2021-06-13 Italy Basilicata     26688 585 23124 2979 40.63947052 15.80514834 2021-06-14 04:22:46 Basilicata, Italy
281508 2021-06-12 Italy Basilicata     26661 585 23087 2989 40.63947052 15.80514834 2021-06-13 04:22:44 Basilicata, Italy
1633607 2021-06-11 Italy Basilicata     26648 585 23035 3028 40.63947052 15.80514834 2021-06-12 04:22:22 Basilicata, Italy
662893 2021-06-10 Italy Basilicata     26596 585 22974 3037 40.63947052 15.80514834 2021-06-11 04:23:20 Basilicata, Italy
881997 2021-06-09 Italy Basilicata     26560 585 22841 3134 40.63947052 15.80514834 2021-06-10 04:23:17 Basilicata, Italy
1709996 2021-06-08 Italy Basilicata     26529 585 22778 3166 40.63947052 15.80514834 2021-06-09 04:23:31 Basilicata, Italy
1465840 2021-06-07 Italy Basilicata     26494 585 22630 3279 40.63947052 15.80514834 2021-06-08 04:22:35 Basilicata, Italy
993607 2021-06-06 Italy Basilicata     26493 584 22571 3338 40.63947052 15.80514834 2021-06-07 04:22:51 Basilicata, Italy
158397 2021-06-05 Italy Basilicata     26462 583 22501 3378 40.63947052 15.80514834 2021-06-06 04:24:03 Basilicata, Italy
1516382 2021-06-04 Italy Basilicata     26431 581 22351 3499 40.63947052 15.80514834 2021-06-05 04:23:03 Basilicata, Italy
1140693 2021-06-03 Italy Basilicata     26380 580 22248 3552 40.63947052 15.80514834 2021-06-04 04:23:37 Basilicata, Italy
427137 2021-06-02 Italy Basilicata     26377 580 22209 3588 40.63947052 15.80514834 2021-06-03 04:23:32 Basilicata, Italy
539644 2021-06-01 Italy Basilicata     26340 579 22127 3634 40.63947052 15.80514834 2021-06-02 04:24:34 Basilicata, Italy
786829 2021-05-31 Italy Basilicata     26316 579 21968 3769 40.63947052 15.80514834 2021-06-01 04:23:09 Basilicata, Italy
1330227 2021-05-30 Italy Basilicata     26310 578 21932 3800 40.63947052 15.80514834 2021-05-31 03:08:59 Basilicata, Italy
67436 2021-05-29 Italy Basilicata     26291 578 21867 3846 40.63947052 15.80514834 2021-05-30 04:20:55 Basilicata, Italy
195622 2021-05-28 Italy Basilicata     26245 574 21600 4071 40.63947052 15.80514834 2021-05-29 04:20:41 Basilicata, Italy
938881 2021-05-27 Italy Basilicata     26188 572 21494 4122 40.63947052 15.80514834 2021-05-28 04:20:36 Basilicata, Italy
1226556 2021-05-26 Italy Basilicata     26135 571 21347 4217 40.63947052 15.80514834 2021-05-27 04:20:59 Basilicata, Italy
1338195 2021-05-25 Italy Basilicata     26069 571 21172 4326 40.63947052 15.80514834 2021-05-26 04:20:35 Basilicata, Italy
203027 2021-05-24 Italy Basilicata     26019 570 21041 4408 40.63947052 15.80514834 2021-05-25 04:21:08 Basilicata, Italy
99191 2021-05-23 Italy Basilicata     26015 570 20934 4511 40.63947052 15.80514834 2021-05-24 04:20:53 Basilicata, Italy
523710 2021-05-22 Italy Basilicata     25977 570 20865 4542 40.63947052 15.80514834 2021-05-23 04:20:51 Basilicata, Italy
859405 2021-05-21 Italy Basilicata     25910 570 20741 4599 40.63947052 15.80514834 2021-05-22 04:20:45 Basilicata, Italy
720828 2021-05-20 Italy Basilicata     25848 569 20560 4719 40.63947052 15.80514834 2021-05-21 04:20:43 Basilicata, Italy
407959 2021-05-19 Italy Basilicata     25795 569 20471 4755 40.63947052 15.80514834 2021-05-20 04:21:05 Basilicata, Italy
782845 2021-05-18 Italy Basilicata     25728 567 20271 4890 40.63947052 15.80514834 2021-05-19 04:20:42 Basilicata, Italy
1422987 2021-05-17 Italy Basilicata     25644 564 20127 4953 40.63947052 15.80514834 2021-05-18 04:20:33 Basilicata, Italy
740173 2021-05-16 Italy Basilicata     25627 564 19925 5138 40.63947052 15.80514834 2021-05-17 04:20:34 Basilicata, Italy
1116706 2021-05-15 Italy Basilicata     25535 562 19732 5241 40.63947052 15.80514834 2021-05-16 04:20:49 Basilicata, Italy
1587215 2021-05-14 Italy Basilicata     25416 562 19537 5317 40.63947052 15.80514834 2021-05-15 04:20:58 Basilicata, Italy
1675132 2021-05-13 Italy Basilicata     25302 561 19400 5341 40.63947052 15.80514834 2021-05-14 04:20:41 Basilicata, Italy
802759 2021-05-12 Italy Basilicata     25211 559 19184 5468 40.63947052 15.80514834 2021-05-13 04:20:51 Basilicata, Italy
1181147 2021-05-11 Italy Basilicata     25089 555 18818 5716 40.63947052 15.80514834 2021-05-12 04:21:29 Basilicata, Italy
324937 2021-05-10 Italy Basilicata     25009 552 18549 5908 40.63947052 15.80514834 2021-05-11 04:20:41 Basilicata, Italy
604084 2021-05-09 Italy Basilicata     24985 548 18465 5972 40.63947052 15.80514834 2021-05-10 04:20:38 Basilicata, Italy
985831 2021-05-08 Italy Basilicata     24882 548 18307 6027 40.63947052 15.80514834 2021-05-09 04:20:35 Basilicata, Italy
434313 2021-05-07 Italy Basilicata     24765 546 18036 6183 40.63947052 15.80514834 2021-05-08 04:21:04 Basilicata, Italy
901094 2021-05-06 Italy Basilicata     24645 544 17919 6182 40.63947052 15.80514834 2021-05-07 04:20:40 Basilicata, Italy
71420 2021-05-05 Italy Basilicata     24505 543 17687 6275 40.63947052 15.80514834 2021-05-06 04:20:38 Basilicata, Italy
790813 2021-05-04 Italy Basilicata     24330 542 17565 6223 40.63947052 15.80514834 2021-05-05 04:20:43 Basilicata, Italy
1613343 2021-05-03 Italy Basilicata     24258 540 17487 6231 40.63947052 15.80514834 2021-05-04 04:20:34 Basilicata, Italy
885981 2021-05-02 Italy Basilicata     24232 536 17412 6284 40.63947052 15.80514834 2021-05-03 04:20:39 Basilicata, Italy
511686 2021-05-01 Italy Basilicata     24155 534 17329 6292 40.63947052 15.80514834 2021-05-02 04:20:48 Basilicata, Italy
14622 2021-04-30 Italy Basilicata     23956 534 17192 6230 40.63947052 15.80514834 2021-05-01 04:20:47 Basilicata, Italy
1124726 2021-04-29 Italy Basilicata     23784 531 17093 6160 40.63947052 15.80514834 2021-04-30 04:21:03 Basilicata, Italy
462023 2021-04-28 Italy Basilicata     23615 528 16957 6130 40.63947052 15.80514834 2021-04-29 04:20:55 Basilicata, Italy
1314729 2021-04-27 Italy Basilicata     23428 522 16847 6059 40.63947052 15.80514834 2021-04-28 04:20:32 Basilicata, Italy
1549156 2021-04-26 Italy Basilicata     23338 518 16756 6064 40.63947052 15.80514834 2021-04-27 04:20:52 Basilicata, Italy
1629623 2021-04-25 Italy Basilicata     23288 513 16655 6120 40.63947052 15.80514834 2021-04-26 04:21:04 Basilicata, Italy
353763 2021-04-24 Italy Basilicata     23125 513 16534 6078 40.63947052 15.80514834 2021-04-25 04:20:32 Basilicata, Italy
724812 2021-04-23 Italy Basilicata     22968 513 16357 6098 40.63947052 15.80514834 2021-04-24 04:20:38 Basilicata, Italy
1469824 2021-04-22 Italy Basilicata     22779 511 16296 5972 40.63947052 15.80514834 2021-04-23 04:20:52 Basilicata, Italy
1222572 2021-04-21 Italy Basilicata     22573 507 16227 5839 40.63947052 15.80514834 2021-04-22 04:20:53 Basilicata, Italy
458039 2021-04-20 Italy Basilicata     22400 502 16112 5786 40.63947052 15.80514834 2021-04-21 04:21:14 Basilicata, Italy
1300227 2021-04-19 Italy Basilicata     22254 497 16011 5746 40.63947052 15.80514834 2021-04-20 04:20:41 Basilicata, Italy
1069806 2021-04-18 Italy Basilicata     22207 497 15911 5799 40.63947052 15.80514834 2021-04-19 04:20:57 Basilicata, Italy
1045688 2021-04-17 Italy Basilicata     22061 497 15829 5735 40.63947052 15.80514834 2021-04-18 04:20:41 Basilicata, Italy
596964 2021-04-16 Italy Basilicata     21845 496 15707 5642 40.63947052 15.80514834 2021-04-17 04:20:40 Basilicata, Italy
1621380 2021-04-15 Italy Basilicata     21669 496 15633 5540 40.63947052 15.80514834 2021-04-16 04:20:46 Basilicata, Italy
950811 2021-04-14 Italy Basilicata     21452 494 15556 5402 40.63947052 15.80514834 2021-04-15 04:20:54 Basilicata, Italy
592980 2021-04-13 Italy Basilicata     21241 492 15492 5257 40.63947052 15.80514834 2021-04-14 04:20:41 Basilicata, Italy
32919 2021-04-12 Italy Basilicata     21059 489 15410 5160 40.63947052 15.80514834 2021-04-13 04:20:37 Basilicata, Italy
1371934 2021-04-11 Italy Basilicata     20984 484 15357 5143 40.63947052 15.80514834 2021-04-12 04:21:00 Basilicata, Italy
1667186 2021-04-10 Italy Basilicata     20735 482 15250 5003 40.63947052 15.80514834 2021-04-11 04:20:56 Basilicata, Italy
1159802 2021-04-09 Italy Basilicata     20564 479 15062 5023 40.63947052 15.80514834 2021-04-10 04:20:59 Basilicata, Italy
1057637 2021-04-08 Italy Basilicata     20360 475 14899 4986 40.63947052 15.80514834 2021-04-09 04:21:13 Basilicata, Italy
1500426 2021-04-07 Italy Basilicata     20197 470 14808 4919 40.63947052 15.80514834 2021-04-08 04:21:13 Basilicata, Italy
1207631 2021-04-06 Italy Basilicata     20055 462 14678 4915 40.63947052 15.80514834 2021-04-07 04:20:53 Basilicata, Italy
122932 2021-04-05 Italy Basilicata     20034 454 14664 4916 40.63947052 15.80514834 2021-04-06 04:20:32 Basilicata, Italy
1254733 2021-04-04 Italy Basilicata     20018 452 14544 5022 40.63947052 15.80514834 2021-04-05 04:20:35 Basilicata, Italy
1128710 2021-04-03 Italy Basilicata     19899 450 14463 4986 40.63947052 15.80514834 2021-04-04 04:20:49 Basilicata, Italy
270101 2021-04-02 Italy Basilicata     19805 448 14401 4956 40.63947052 15.80514834 2021-04-03 04:20:44 Basilicata, Italy
1173433 2021-04-01 Italy Basilicata     19639 445 14332 4862 40.63947052 15.80514834 2021-04-02 04:20:36 Basilicata, Italy
515744 2021-03-31 Italy Basilicata     19458 443 14241 4774 40.63947052 15.80514834 2021-04-01 04:27:05 Basilicata, Italy
289473 2021-03-30 Italy Basilicata     19309 441 14150 4718 40.63947052 15.80514834 2021-03-31 04:26:25 Basilicata, Italy
1575010 2021-03-29 Italy Basilicata     19181 439 13955 4787 40.63947052 15.80514834 2021-03-30 04:26:23 Basilicata, Italy
631287 2021-03-28 Italy Basilicata     19148 436 13904 4808 40.63947052 15.80514834 2021-03-29 04:28:35 Basilicata, Italy
608068 2021-03-27 Italy Basilicata     19000 433 13846 4721 40.63947052 15.80514834 2021-03-28 05:28:10 Basilicata, Italy
1334211 2021-03-26 Italy Basilicata     18867 431 13818 4618 40.63947052 15.80514834 2021-03-27 05:25:04 Basilicata, Italy
150650 2021-03-25 Italy Basilicata     18724 430 13742 4552 40.63947052 15.80514834 2021-03-26 05:26:55 Basilicata, Italy
1598171 2021-03-24 Italy Basilicata     18618 430 13690 4498 40.63947052 15.80514834 2021-03-25 05:27:00 Basilicata, Italy
403975 2021-03-23 Italy Basilicata     18503 420 13581 4502 40.63947052 15.80514834 2021-03-24 05:25:40 Basilicata, Italy
1387512 2021-03-22 Italy Basilicata     18382 419 13504 4459 40.63947052 15.80514834 2021-03-23 05:26:18 Basilicata, Italy
304999 2021-03-21 Italy Basilicata     18358 412 13476 4470 40.63947052 15.80514834 2021-03-22 05:25:43 Basilicata, Italy
254048 2021-03-20 Italy Basilicata     18250 406 13427 4417 40.63947052 15.80514834 2021-03-21 05:25:44 Basilicata, Italy
1230804 2021-03-19 Italy Basilicata     18103 406 13356 4341 40.63947052 15.80514834 2021-03-20 05:25:46 Basilicata, Italy
974729 2021-03-18 Italy Basilicata     17987 401 13269 4317 40.63947052 15.80514834 2021-03-19 05:26:09 Basilicata, Italy
1532364 2021-03-17 Italy Basilicata     17808 397 13226 4185 40.63947052 15.80514834 2021-03-18 05:26:22 Basilicata, Italy
55558 2021-03-16 Italy Basilicata     17682 393 13138 4151 40.63947052 15.80514834 2021-03-17 05:25:07 Basilicata, Italy
562871 2021-03-15 Italy Basilicata     17516 387 13008 4121 40.63947052 15.80514834 2021-03-16 05:25:13 Basilicata, Italy
851440 2021-03-14 Italy Basilicata     17449 387 12971 4091 40.63947052 15.80514834 2021-03-15 05:25:51 Basilicata, Italy
942865 2021-03-13 Italy Basilicata     17343 386 12929 4028 40.63947052 15.80514834 2021-03-14 05:25:37 Basilicata, Italy
1310745 2021-03-12 Italy Basilicata     17206 385 12889 3932 40.63947052 15.80514834 2021-03-13 05:25:15 Basilicata, Italy
1077583 2021-03-11 Italy Basilicata     17065 384 12766 3915 40.63947052 15.80514834 2021-03-12 05:26:50 Basilicata, Italy
954795 2021-03-10 Italy Basilicata     16914 381 12693 3840 40.63947052 15.80514834 2021-03-11 05:25:48 Basilicata, Italy
543628 2021-03-09 Italy Basilicata     16799 381 12616 3802 40.63947052 15.80514834 2021-03-10 05:24:35 Basilicata, Italy
1520366 2021-03-08 Italy Basilicata     16617 380 12559 3678 40.63947052 15.80514834 2021-03-09 05:28:19 Basilicata, Italy
866647 2021-03-07 Italy Basilicata     16589 379 12425 3785 40.63947052 15.80514834 2021-03-08 05:24:48 Basilicata, 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]);