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

407 rows where country_or_region = "Italy" and province_or_state = "Abruzzo" sorted by day descending

View and edit SQL

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

province_or_state

  • Abruzzo · 407

country_or_region

  • Italy · 407
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
234894 2021-06-24 Italy Abruzzo     74694 2512 71145 1037 42.35122196 13.39843823 2021-06-25 04:21:33 Abruzzo, Italy
471842 2021-06-23 Italy Abruzzo     74655 2511 71060 1084 42.35122196 13.39843823 2021-06-24 04:21:55 Abruzzo, Italy
626900 2021-06-22 Italy Abruzzo     74635 2509 70990 1136 42.35122196 13.39843823 2021-06-23 04:21:46 Abruzzo, Italy
226920 2021-06-21 Italy Abruzzo     74622 2509 70896 1217 42.35122196 13.39843823 2021-06-22 04:21:34 Abruzzo, Italy
1472442 2021-06-20 Italy Abruzzo     74628 2509 70844 1275 42.35122196 13.39843823 2021-06-21 04:21:41 Abruzzo, Italy
1303683 2021-06-19 Italy Abruzzo     74601 2509 70837 1255 42.35122196 13.39843823 2021-06-20 04:21:48 Abruzzo, Italy
303285 2021-06-18 Italy Abruzzo     74570 2507 70786 1277 42.35122196 13.39843823 2021-06-19 04:22:33 Abruzzo, Italy
886115 2021-06-17 Italy Abruzzo     74545 2507 70736 1302 42.35122196 13.39843823 2021-06-18 04:22:16 Abruzzo, Italy
42012 2021-06-16 Italy Abruzzo     74523 2506 70658 1359 42.35122196 13.39843823 2021-06-17 04:22:36 Abruzzo, Italy
1704834 2021-06-15 Italy Abruzzo     74496 2503 70616 1377 42.35122196 13.39843823 2021-06-16 04:22:32 Abruzzo, Italy
1661105 2021-06-14 Italy Abruzzo     74469 2502 70494 1473 42.35122196 13.39843823 2021-06-15 04:22:22 Abruzzo, Italy
319181 2021-06-13 Italy Abruzzo     74464 2502 70433 1529 42.35122196 13.39843823 2021-06-14 04:22:46 Abruzzo, Italy
618926 2021-06-12 Italy Abruzzo     74450 2502 70432 1516 42.35122196 13.39843823 2021-06-13 04:22:44 Abruzzo, Italy
591935 2021-06-11 Italy Abruzzo     74421 2500 70389 1532 42.35122196 13.39843823 2021-06-12 04:22:22 Abruzzo, Italy
272813 2021-06-10 Italy Abruzzo     74399 2499 70248 1652 42.35122196 13.39843823 2021-06-11 04:23:20 Abruzzo, Italy
1637871 2021-06-09 Italy Abruzzo     74362 2498 70029 1835 42.35122196 13.39843823 2021-06-10 04:23:17 Abruzzo, Italy
1744484 2021-06-08 Italy Abruzzo     74314 2498 69355 2461 42.35122196 13.39843823 2021-06-09 04:23:31 Abruzzo, Italy
577027 2021-06-07 Italy Abruzzo     74289 2496 67218 4575 42.35122196 13.39843823 2021-06-08 04:22:35 Abruzzo, Italy
245890 2021-06-06 Italy Abruzzo     74277 2491 66634 5152 42.35122196 13.39843823 2021-06-07 04:22:51 Abruzzo, Italy
673867 2021-06-05 Italy Abruzzo     74238 2490 66634 5114 42.35122196 13.39843823 2021-06-06 04:24:03 Abruzzo, Italy
553130 2021-06-04 Italy Abruzzo     74196 2490 66561 5145 42.35122196 13.39843823 2021-06-05 04:23:03 Abruzzo, Italy
1460527 2021-06-03 Italy Abruzzo     74151 2486 66387 5278 42.35122196 13.39843823 2021-06-04 04:23:37 Abruzzo, Italy
1399520 2021-06-02 Italy Abruzzo     74142 2484 66327 5331 42.35122196 13.39843823 2021-06-03 04:23:32 Abruzzo, Italy
1708867 2021-06-01 Italy Abruzzo     74075 2484 66251 5340 42.35122196 13.39843823 2021-06-02 04:24:34 Abruzzo, Italy
19097 2021-05-31 Italy Abruzzo     74040 2482 66065 5493 42.35122196 13.39843823 2021-06-01 04:23:09 Abruzzo, Italy
1497490 2021-05-30 Italy Abruzzo     74025 2480 65986 5559 42.35122196 13.39843823 2021-05-31 03:08:59 Abruzzo, Italy
622913 2021-05-29 Italy Abruzzo     73972 2480 65983 5509 42.35122196 13.39843823 2021-05-30 04:20:55 Abruzzo, Italy
80769 2021-05-28 Italy Abruzzo     73917 2478 65935 5504 42.35122196 13.39843823 2021-05-29 04:20:41 Abruzzo, Italy
1426044 2021-05-27 Italy Abruzzo     73874 2475 65780 5619 42.35122196 13.39843823 2021-05-28 04:20:36 Abruzzo, Italy
1549012 2021-05-26 Italy Abruzzo     73810 2473 65652 5685 42.35122196 13.39843823 2021-05-27 04:20:59 Abruzzo, Italy
1200588 2021-05-25 Italy Abruzzo     73744 2471 65449 5824 42.35122196 13.39843823 2021-05-26 04:20:35 Abruzzo, Italy
149581 2021-05-24 Italy Abruzzo     73704 2469 65327 5908 42.35122196 13.39843823 2021-05-25 04:21:08 Abruzzo, Italy
689734 2021-05-23 Italy Abruzzo     73689 2468 65254 5967 42.35122196 13.39843823 2021-05-24 04:20:53 Abruzzo, Italy
387348 2021-05-22 Italy Abruzzo     73621 2466 65254 5901 42.35122196 13.39843823 2021-05-23 04:20:51 Abruzzo, Italy
969663 2021-05-21 Italy Abruzzo     73493 2465 65198 5830 42.35122196 13.39843823 2021-05-22 04:20:45 Abruzzo, Italy
57625 2021-05-20 Italy Abruzzo     73427 2463 65021 5943 42.35122196 13.39843823 2021-05-21 04:20:43 Abruzzo, Italy
463887 2021-05-19 Italy Abruzzo     73366 2465 64806 6095 42.35122196 13.39843823 2021-05-20 04:21:05 Abruzzo, Italy
1275843 2021-05-18 Italy Abruzzo     73295 2460 64421 6414 42.35122196 13.39843823 2021-05-19 04:20:42 Abruzzo, Italy
230907 2021-05-17 Italy Abruzzo     73262 2457 63928 6877 42.35122196 13.39843823 2021-05-18 04:20:33 Abruzzo, Italy
1159122 2021-05-16 Italy Abruzzo     73242 2454 63820 6968 42.35122196 13.39843823 2021-05-17 04:20:34 Abruzzo, Italy
1008678 2021-05-15 Italy Abruzzo     73142 2453 63797 6892 42.35122196 13.39843823 2021-05-16 04:20:49 Abruzzo, Italy
804790 2021-05-14 Italy Abruzzo     73030 2452 63692 6886 42.35122196 13.39843823 2021-05-15 04:20:58 Abruzzo, Italy
1192618 2021-05-13 Italy Abruzzo     72887 2450 63427 7010 42.35122196 13.39843823 2021-05-14 04:20:41 Abruzzo, Italy
685747 2021-05-12 Italy Abruzzo     72799 2447 63093 7259 42.35122196 13.39843823 2021-05-13 04:20:51 Abruzzo, Italy
129147 2021-05-11 Italy Abruzzo     72649 2447 62531 7671 42.35122196 13.39843823 2021-05-12 04:21:29 Abruzzo, Italy
1257152 2021-05-10 Italy Abruzzo     72570 2438 62280 7852 42.35122196 13.39843823 2021-05-11 04:20:41 Abruzzo, Italy
121173 2021-05-09 Italy Abruzzo     72516 2437 62132 7947 42.35122196 13.39843823 2021-05-10 04:20:38 Abruzzo, Italy
88743 2021-05-08 Italy Abruzzo     72371 2434 62115 7822 42.35122196 13.39843823 2021-05-09 04:20:35 Abruzzo, Italy
522241 2021-05-07 Italy Abruzzo     72286 2428 61947 7911 42.35122196 13.39843823 2021-05-08 04:21:04 Abruzzo, Italy
1684865 2021-05-06 Italy Abruzzo     72090 2422 61506 8162 42.35122196 13.39843823 2021-05-07 04:20:40 Abruzzo, Italy
23084 2021-05-05 Italy Abruzzo     71916 2422 61333 8161 42.35122196 13.39843823 2021-05-06 04:20:38 Abruzzo, Italy
1331026 2021-05-04 Italy Abruzzo     71724 2420 60938 8366 42.35122196 13.39843823 2021-05-05 04:20:43 Abruzzo, Italy
1035613 2021-05-03 Italy Abruzzo     71640 2415 60613 8612 42.35122196 13.39843823 2021-05-04 04:20:34 Abruzzo, Italy
913803 2021-05-02 Italy Abruzzo     71603 2412 60458 8733 42.35122196 13.39843823 2021-05-03 04:20:39 Abruzzo, Italy
1756769 2021-05-01 Italy Abruzzo     71444 2408 60457 8579 42.35122196 13.39843823 2021-05-02 04:20:48 Abruzzo, Italy
1456540 2021-04-30 Italy Abruzzo     71218 2403 60432 8383 42.35122196 13.39843823 2021-05-01 04:20:47 Abruzzo, Italy
1614354 2021-04-29 Italy Abruzzo     71067 2397 60119 8551 42.35122196 13.39843823 2021-04-30 04:21:03 Abruzzo, Italy
483753 2021-04-28 Italy Abruzzo     70873 2391 59926 8556 42.35122196 13.39843823 2021-04-29 04:20:55 Abruzzo, Italy
334791 2021-04-27 Italy Abruzzo     70696 2385 59697 8614 42.35122196 13.39843823 2021-04-28 04:20:32 Abruzzo, Italy
1357836 2021-04-26 Italy Abruzzo     70615 2377 59181 9057 42.35122196 13.39843823 2021-04-27 04:20:52 Abruzzo, Italy
495792 2021-04-25 Italy Abruzzo     70519 2376 58998 9145 42.35122196 13.39843823 2021-04-26 04:21:04 Abruzzo, Italy
1112391 2021-04-24 Italy Abruzzo     70340 2369 58961 9010 42.35122196 13.39843823 2021-04-25 04:20:32 Abruzzo, Italy
487740 2021-04-23 Italy Abruzzo     70203 2360 58607 9236 42.35122196 13.39843823 2021-04-24 04:20:38 Abruzzo, Italy
1170125 2021-04-22 Italy Abruzzo     70045 2355 58270 9420 42.35122196 13.39843823 2021-04-23 04:20:52 Abruzzo, Italy
1403596 2021-04-21 Italy Abruzzo     69812 2347 57951 9514 42.35122196 13.39843823 2021-04-22 04:20:53 Abruzzo, Italy
1712854 2021-04-20 Italy Abruzzo     69650 2345 57800 9505 42.35122196 13.39843823 2021-04-21 04:21:14 Abruzzo, Italy
606983 2021-04-19 Italy Abruzzo     69480 2337 57385 9758 42.35122196 13.39843823 2021-04-20 04:20:41 Abruzzo, Italy
917790 2021-04-18 Italy Abruzzo     69384 2333 56951 10100 42.35122196 13.39843823 2021-04-19 04:20:57 Abruzzo, Italy
1319101 2021-04-17 Italy Abruzzo     69126 2329 56926 9871 42.35122196 13.39843823 2021-04-18 04:20:41 Abruzzo, Italy
988793 2021-04-16 Italy Abruzzo     68948 2315 56737 9896 42.35122196 13.39843823 2021-04-17 04:20:40 Abruzzo, Italy
379897 2021-04-15 Italy Abruzzo     68741 2298 56211 10232 42.35122196 13.39843823 2021-04-16 04:20:46 Abruzzo, Italy
905847 2021-04-14 Italy Abruzzo     68527 2293 55968 10266 42.35122196 13.39843823 2021-04-15 04:20:54 Abruzzo, Italy
1079074 2021-04-13 Italy Abruzzo     68265 2269 55735 10261 42.35122196 13.39843823 2021-04-14 04:20:41 Abruzzo, Italy
354310 2021-04-12 Italy Abruzzo     68091 2248 55433 10410 42.35122196 13.39843823 2021-04-13 04:20:37 Abruzzo, Italy
1180759 2021-04-11 Italy Abruzzo     68002 2243 55299 10460 42.35122196 13.39843823 2021-04-12 04:21:00 Abruzzo, Italy
1188631 2021-04-10 Italy Abruzzo     67743 2240 55277 10226 42.35122196 13.39843823 2021-04-11 04:20:56 Abruzzo, Italy
1692817 2021-04-09 Italy Abruzzo     67506 2227 55076 10203 42.35122196 13.39843823 2021-04-10 04:20:59 Abruzzo, Italy
569056 2021-04-08 Italy Abruzzo     67155 2212 54656 10287 42.35122196 13.39843823 2021-04-09 04:21:13 Abruzzo, Italy
1345875 2021-04-07 Italy Abruzzo     66878 2200 54281 10397 42.35122196 13.39843823 2021-04-08 04:21:13 Abruzzo, Italy
350243 2021-04-06 Italy Abruzzo     66660 2187 53902 10571 42.35122196 13.39843823 2021-04-07 04:20:53 Abruzzo, Italy
1043568 2021-04-05 Italy Abruzzo     66613 2173 53724 10716 42.35122196 13.39843823 2021-04-06 04:20:32 Abruzzo, Italy
214888 2021-04-04 Italy Abruzzo     66594 2169 53697 10728 42.35122196 13.39843823 2021-04-05 04:20:35 Abruzzo, Italy
1700847 2021-04-03 Italy Abruzzo     66156 2166 53691 10299 42.35122196 13.39843823 2021-04-04 04:20:49 Abruzzo, Italy
953536 2021-04-02 Italy Abruzzo     65931 2151 53440 10340 42.35122196 13.39843823 2021-04-03 04:20:44 Abruzzo, Italy
125160 2021-04-01 Italy Abruzzo     65508 2145 53222 10141 42.35122196 13.39843823 2021-04-02 04:20:36 Abruzzo, Italy
1516052 2021-03-31 Italy Abruzzo     65237 2136 52969 10132 42.35122196 13.39843823 2021-04-01 04:27:05 Abruzzo, Italy
1716841 2021-03-30 Italy Abruzzo     64924 2125 52539 10260 42.35122196 13.39843823 2021-03-31 04:26:25 Abruzzo, Italy
732828 2021-03-29 Italy Abruzzo     64774 2100 52112 10562 42.35122196 13.39843823 2021-03-30 04:26:23 Abruzzo, Italy
422132 2021-03-28 Italy Abruzzo     64550 2083 51801 10666 42.35122196 13.39843823 2021-03-29 04:28:35 Abruzzo, Italy
1732523 2021-03-27 Italy Abruzzo     64281 2074 51794 10413 42.35122196 13.39843823 2021-03-28 05:28:10 Abruzzo, Italy
402966 2021-03-26 Italy Abruzzo     63933 2072 51411 10450 42.35122196 13.39843823 2021-03-27 05:25:04 Abruzzo, Italy
1353849 2021-03-25 Italy Abruzzo     63541 2067 50987 10487 42.35122196 13.39843823 2021-03-26 05:26:55 Abruzzo, Italy
507539 2021-03-24 Italy Abruzzo     63231 2052 50528 10651 42.35122196 13.39843823 2021-03-25 05:27:00 Abruzzo, Italy
1590456 2021-03-23 Italy Abruzzo     62902 2041 49966 10895 42.35122196 13.39843823 2021-03-24 05:25:40 Abruzzo, Italy
839848 2021-03-22 Italy Abruzzo     62714 2023 49623 11068 42.35122196 13.39843823 2021-03-23 05:26:18 Abruzzo, Italy
721088 2021-03-21 Italy Abruzzo     62525 2016 49327 11182 42.35122196 13.39843823 2021-03-22 05:25:43 Abruzzo, Italy
442231 2021-03-20 Italy Abruzzo     62172 2007 49292 10873 42.35122196 13.39843823 2021-03-21 05:25:44 Abruzzo, Italy
545173 2021-03-19 Italy Abruzzo     61803 1972 48868 10963 42.35122196 13.39843823 2021-03-20 05:25:46 Abruzzo, Italy
1349862 2021-03-18 Italy Abruzzo     61387 1943 48342 11102 42.35122196 13.39843823 2021-03-19 05:26:09 Abruzzo, Italy
84756 2021-03-17 Italy Abruzzo     60928 1934 47316 11678 42.35122196 13.39843823 2021-03-18 05:26:22 Abruzzo, 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]);