⚠️ 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 = "Campania" sorted by day descending

View and edit SQL

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

province_or_state

  • Campania · 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
234897 2021-06-24 Italy Campania     423728 7400 406752 9576 40.83956555 14.25084984 2021-06-25 04:21:33 Campania, Italy
471845 2021-06-23 Italy Campania     423616 7393 406473 9750 40.83956555 14.25084984 2021-06-24 04:21:55 Campania, Italy
626903 2021-06-22 Italy Campania     423506 7391 406141 9974 40.83956555 14.25084984 2021-06-23 04:21:46 Campania, Italy
226923 2021-06-21 Italy Campania     423412 7390 405824 10198 40.83956555 14.25084984 2021-06-22 04:21:34 Campania, Italy
1472445 2021-06-20 Italy Campania     423381 7386 405623 10372 40.83956555 14.25084984 2021-06-21 04:21:41 Campania, Italy
1303686 2021-06-19 Italy Campania     423299 7383 405295 10621 40.83956555 14.25084984 2021-06-20 04:21:48 Campania, Italy
303288 2021-06-18 Italy Campania     423160 7379 405009 10772 40.83956555 14.25084984 2021-06-19 04:22:33 Campania, Italy
886118 2021-06-17 Italy Campania     423053 7371 404602 11080 40.83956555 14.25084984 2021-06-18 04:22:16 Campania, Italy
42015 2021-06-16 Italy Campania     422922 7363 404125 11434 40.83956555 14.25084984 2021-06-17 04:22:36 Campania, Italy
1704837 2021-06-15 Italy Campania     422755 7357 403661 11737 40.83956555 14.25084984 2021-06-16 04:22:32 Campania, Italy
1661108 2021-06-14 Italy Campania     422619 7342 355448 59829 40.83956555 14.25084984 2021-06-15 04:22:22 Campania, Italy
319184 2021-06-13 Italy Campania     422539 7337 355124 60078 40.83956555 14.25084984 2021-06-14 04:22:46 Campania, Italy
618929 2021-06-12 Italy Campania     422392 7334 354673 60385 40.83956555 14.25084984 2021-06-13 04:22:44 Campania, Italy
591938 2021-06-11 Italy Campania     422205 7326 354088 60791 40.83956555 14.25084984 2021-06-12 04:22:22 Campania, Italy
272816 2021-06-10 Italy Campania     422006 7315 353440 61251 40.83956555 14.25084984 2021-06-11 04:23:20 Campania, Italy
1637874 2021-06-09 Italy Campania     421797 7288 352687 61822 40.83956555 14.25084984 2021-06-10 04:23:17 Campania, Italy
1744487 2021-06-08 Italy Campania     421540 7268 351905 62367 40.83956555 14.25084984 2021-06-09 04:23:31 Campania, Italy
577030 2021-06-07 Italy Campania     421289 7252 351110 62927 40.83956555 14.25084984 2021-06-08 04:22:35 Campania, Italy
245893 2021-06-06 Italy Campania     421112 7242 350387 63483 40.83956555 14.25084984 2021-06-07 04:22:51 Campania, Italy
673870 2021-06-05 Italy Campania     420857 7241 349803 63813 40.83956555 14.25084984 2021-06-06 04:24:03 Campania, Italy
553133 2021-06-04 Italy Campania     420550 7239 349128 64183 40.83956555 14.25084984 2021-06-05 04:23:03 Campania, Italy
1460530 2021-06-03 Italy Campania     420250 7229 348023 64998 40.83956555 14.25084984 2021-06-04 04:23:37 Campania, Italy
1399523 2021-06-02 Italy Campania     420032 7221 347234 65577 40.83956555 14.25084984 2021-06-03 04:23:32 Campania, Italy
1708870 2021-06-01 Italy Campania     419644 7216 346440 65988 40.83956555 14.25084984 2021-06-02 04:24:34 Campania, Italy
19100 2021-05-31 Italy Campania     419269 7206 345384 66679 40.83956555 14.25084984 2021-06-01 04:23:09 Campania, Italy
1497493 2021-05-30 Italy Campania     418985 7191 344440 67354 40.83956555 14.25084984 2021-05-31 03:08:59 Campania, Italy
622916 2021-05-29 Italy Campania     418600 7190 343566 67844 40.83956555 14.25084984 2021-05-30 04:20:55 Campania, Italy
80772 2021-05-28 Italy Campania     418269 7183 343021 68065 40.83956555 14.25084984 2021-05-29 04:20:41 Campania, Italy
1426047 2021-05-27 Italy Campania     417792 7168 341763 68861 40.83956555 14.25084984 2021-05-28 04:20:36 Campania, Italy
1549015 2021-05-26 Italy Campania     417259 7147 340515 69597 40.83956555 14.25084984 2021-05-27 04:20:59 Campania, Italy
1200591 2021-05-25 Italy Campania     416776 7139 339214 70423 40.83956555 14.25084984 2021-05-26 04:20:35 Campania, Italy
149584 2021-05-24 Italy Campania     416366 7102 337994 71270 40.83956555 14.25084984 2021-05-25 04:21:08 Campania, Italy
689737 2021-05-23 Italy Campania     415965 7074 336853 72038 40.83956555 14.25084984 2021-05-24 04:20:53 Campania, Italy
387351 2021-05-22 Italy Campania     415337 7069 335737 72531 40.83956555 14.25084984 2021-05-23 04:20:51 Campania, Italy
969666 2021-05-21 Italy Campania     414772 7040 333404 74328 40.83956555 14.25084984 2021-05-22 04:20:45 Campania, Italy
57628 2021-05-20 Italy Campania     414067 6933 331774 75360 40.83956555 14.25084984 2021-05-21 04:20:43 Campania, Italy
463890 2021-05-19 Italy Campania     413418 6893 330200 76325 40.83956555 14.25084984 2021-05-20 04:21:05 Campania, Italy
1275846 2021-05-18 Italy Campania     412784 6874 328681 77229 40.83956555 14.25084984 2021-05-19 04:20:42 Campania, Italy
230910 2021-05-17 Italy Campania     412186 6844 326771 78571 40.83956555 14.25084984 2021-05-18 04:20:33 Campania, Italy
1159125 2021-05-16 Italy Campania     411636 6816 325178 79642 40.83956555 14.25084984 2021-05-17 04:20:34 Campania, Italy
1008681 2021-05-15 Italy Campania     410717 6805 323754 80158 40.83956555 14.25084984 2021-05-16 04:20:49 Campania, Italy
804793 2021-05-14 Italy Campania     409771 6797 322323 80651 40.83956555 14.25084984 2021-05-15 04:20:58 Campania, Italy
1192621 2021-05-13 Italy Campania     408653 6773 320430 81450 40.83956555 14.25084984 2021-05-14 04:20:41 Campania, Italy
685750 2021-05-12 Italy Campania     407543 6749 318376 82418 40.83956555 14.25084984 2021-05-13 04:20:51 Campania, Italy
129150 2021-05-11 Italy Campania     406416 6719 316423 83274 40.83956555 14.25084984 2021-05-12 04:21:29 Campania, Italy
1257155 2021-05-10 Italy Campania     405307 6690 314033 84584 40.83956555 14.25084984 2021-05-11 04:20:41 Campania, Italy
121176 2021-05-09 Italy Campania     404364 6636 312137 85591 40.83956555 14.25084984 2021-05-10 04:20:38 Campania, Italy
88746 2021-05-08 Italy Campania     403131 6626 310521 85984 40.83956555 14.25084984 2021-05-09 04:20:35 Campania, Italy
522244 2021-05-07 Italy Campania     401716 6591 308632 86493 40.83956555 14.25084984 2021-05-08 04:21:04 Campania, Italy
1684868 2021-05-06 Italy Campania     400334 6548 306455 87331 40.83956555 14.25084984 2021-05-07 04:20:40 Campania, Italy
23087 2021-05-05 Italy Campania     398831 6522 304273 88036 40.83956555 14.25084984 2021-05-06 04:20:38 Campania, Italy
1331029 2021-05-04 Italy Campania     397384 6484 301880 89020 40.83956555 14.25084984 2021-05-05 04:20:43 Campania, Italy
1035616 2021-05-03 Italy Campania     396053 6446 299192 90415 40.83956555 14.25084984 2021-05-04 04:20:34 Campania, Italy
913806 2021-05-02 Italy Campania     395094 6416 297441 91237 40.83956555 14.25084984 2021-05-03 04:20:39 Campania, Italy
1756772 2021-05-01 Italy Campania     393742 6405 295740 91597 40.83956555 14.25084984 2021-05-02 04:20:48 Campania, Italy
1456543 2021-04-30 Italy Campania     391792 6393 294011 91388 40.83956555 14.25084984 2021-05-01 04:20:47 Campania, Italy
1614357 2021-04-29 Italy Campania     389894 6369 291640 91885 40.83956555 14.25084984 2021-04-30 04:21:03 Campania, Italy
483756 2021-04-28 Italy Campania     387908 6336 289769 91803 40.83956555 14.25084984 2021-04-29 04:20:55 Campania, Italy
334794 2021-04-27 Italy Campania     386064 6305 288080 91679 40.83956555 14.25084984 2021-04-28 04:20:32 Campania, Italy
1357839 2021-04-26 Italy Campania     384410 6268 286423 91719 40.83956555 14.25084984 2021-04-27 04:20:52 Campania, Italy
495795 2021-04-25 Italy Campania     383128 6210 284587 92331 40.83956555 14.25084984 2021-04-26 04:21:04 Campania, Italy
1112394 2021-04-24 Italy Campania     381274 6189 283223 91862 40.83956555 14.25084984 2021-04-25 04:20:32 Campania, Italy
487743 2021-04-23 Italy Campania     379262 6144 281092 92026 40.83956555 14.25084984 2021-04-24 04:20:38 Campania, Italy
1170128 2021-04-22 Italy Campania     377292 6095 279179 92018 40.83956555 14.25084984 2021-04-23 04:20:52 Campania, Italy
1403599 2021-04-21 Italy Campania     375380 6069 277426 91885 40.83956555 14.25084984 2021-04-22 04:20:53 Campania, Italy
1712857 2021-04-20 Italy Campania     373499 6039 275673 91787 40.83956555 14.25084984 2021-04-21 04:21:14 Campania, Italy
606986 2021-04-19 Italy Campania     371749 5987 273561 92201 40.83956555 14.25084984 2021-04-20 04:20:41 Campania, Italy
917793 2021-04-18 Italy Campania     370415 5952 272042 92421 40.83956555 14.25084984 2021-04-19 04:20:57 Campania, Italy
1319104 2021-04-17 Italy Campania     368715 5934 270531 92250 40.83956555 14.25084984 2021-04-18 04:20:41 Campania, Italy
988796 2021-04-16 Italy Campania     366483 5922 268594 91967 40.83956555 14.25084984 2021-04-17 04:20:40 Campania, Italy
379900 2021-04-15 Italy Campania     364489 5891 267074 91524 40.83956555 14.25084984 2021-04-16 04:20:46 Campania, Italy
905850 2021-04-14 Italy Campania     362265 5851 264906 91508 40.83956555 14.25084984 2021-04-15 04:20:54 Campania, Italy
1079077 2021-04-13 Italy Campania     360053 5824 263291 90938 40.83956555 14.25084984 2021-04-14 04:20:41 Campania, Italy
354313 2021-04-12 Italy Campania     358426 5817 261443 91166 40.83956555 14.25084984 2021-04-13 04:20:37 Campania, Italy
1180762 2021-04-11 Italy Campania     357040 5774 259615 91651 40.83956555 14.25084984 2021-04-12 04:21:00 Campania, Italy
1188634 2021-04-10 Italy Campania     355186 5747 258061 91378 40.83956555 14.25084984 2021-04-11 04:20:56 Campania, Italy
1692820 2021-04-09 Italy Campania     353117 5734 256145 91238 40.83956555 14.25084984 2021-04-10 04:20:59 Campania, Italy
569059 2021-04-08 Italy Campania     350892 5703 254178 91011 40.83956555 14.25084984 2021-04-09 04:21:13 Campania, Italy
1345878 2021-04-07 Italy Campania     348959 5653 252199 91107 40.83956555 14.25084984 2021-04-08 04:21:13 Campania, Italy
350246 2021-04-06 Italy Campania     347601 5587 250112 91902 40.83956555 14.25084984 2021-04-07 04:20:53 Campania, Italy
1043571 2021-04-05 Italy Campania     346755 5525 248732 92498 40.83956555 14.25084984 2021-04-06 04:20:32 Campania, Italy
214891 2021-04-04 Italy Campania     345826 5516 247346 92964 40.83956555 14.25084984 2021-04-05 04:20:35 Campania, Italy
1700850 2021-04-03 Italy Campania     343918 5509 246327 92082 40.83956555 14.25084984 2021-04-04 04:20:49 Campania, Italy
953539 2021-04-02 Italy Campania     341604 5475 244359 91770 40.83956555 14.25084984 2021-04-03 04:20:44 Campania, Italy
125163 2021-04-01 Italy Campania     339547 5418 241380 92749 40.83956555 14.25084984 2021-04-02 04:20:36 Campania, Italy
1516055 2021-03-31 Italy Campania     337289 5363 238809 93117 40.83956555 14.25084984 2021-04-01 04:27:05 Campania, Italy
1716844 2021-03-30 Italy Campania     335273 5325 235743 94205 40.83956555 14.25084984 2021-03-31 04:26:25 Campania, Italy
732831 2021-03-29 Italy Campania     333700 5261 232906 95533 40.83956555 14.25084984 2021-03-30 04:26:23 Campania, Italy
422135 2021-03-28 Italy Campania     332531 5207 230662 96662 40.83956555 14.25084984 2021-03-29 04:28:35 Campania, Italy
1732526 2021-03-27 Italy Campania     330436 5189 229146 96101 40.83956555 14.25084984 2021-03-28 05:28:10 Campania, Italy
402969 2021-03-26 Italy Campania     328227 5158 226818 96251 40.83956555 14.25084984 2021-03-27 05:25:04 Campania, Italy
1353852 2021-03-25 Italy Campania     326280 5116 223924 97240 40.83956555 14.25084984 2021-03-26 05:26:55 Campania, Italy
507542 2021-03-24 Italy Campania     324212 5054 221110 98048 40.83956555 14.25084984 2021-03-25 05:27:00 Campania, Italy
1590459 2021-03-23 Italy Campania     322167 5002 219030 98135 40.83956555 14.25084984 2021-03-24 05:25:40 Campania, Italy
839851 2021-03-22 Italy Campania     320305 4940 216036 99329 40.83956555 14.25084984 2021-03-23 05:26:18 Campania, Italy
721091 2021-03-21 Italy Campania     318992 4897 213419 100676 40.83956555 14.25084984 2021-03-22 05:25:43 Campania, Italy
442234 2021-03-20 Italy Campania     317182 4871 211416 100895 40.83956555 14.25084984 2021-03-21 05:25:44 Campania, Italy
545176 2021-03-19 Italy Campania     314986 4843 209805 100338 40.83956555 14.25084984 2021-03-20 05:25:46 Campania, Italy
1349865 2021-03-18 Italy Campania     312989 4830 208600 99559 40.83956555 14.25084984 2021-03-19 05:26:09 Campania, Italy
84759 2021-03-17 Italy Campania     310766 4817 207302 98647 40.83956555 14.25084984 2021-03-18 05:26:22 Campania, 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]);