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

View and edit SQL

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

province_or_state

  • Emilia-Romagna · 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
222909 2021-06-14 Italy Emilia-Romagna     385821 13234 364569 8018 44.49436681 11.3417208 2021-06-15 04:22:22 Emilia-Romagna, Italy
214941 2021-06-13 Italy Emilia-Romagna     385684 13233 364106 8345 44.49436681 11.3417208 2021-06-14 04:22:46 Emilia-Romagna, Italy
281511 2021-06-12 Italy Emilia-Romagna     385561 13230 363818 8513 44.49436681 11.3417208 2021-06-13 04:22:44 Emilia-Romagna, Italy
1633610 2021-06-11 Italy Emilia-Romagna     385457 13230 363523 8704 44.49436681 11.3417208 2021-06-12 04:22:22 Emilia-Romagna, Italy
662896 2021-06-10 Italy Emilia-Romagna     385321 13225 362876 9220 44.49436681 11.3417208 2021-06-11 04:23:20 Emilia-Romagna, Italy
882000 2021-06-09 Italy Emilia-Romagna     385176 13221 361632 10323 44.49436681 11.3417208 2021-06-10 04:23:17 Emilia-Romagna, Italy
1709999 2021-06-08 Italy Emilia-Romagna     385070 13219 360892 10959 44.49436681 11.3417208 2021-06-09 04:23:31 Emilia-Romagna, Italy
1465843 2021-06-07 Italy Emilia-Romagna     384973 13212 360799 10962 44.49436681 11.3417208 2021-06-08 04:22:35 Emilia-Romagna, Italy
993610 2021-06-06 Italy Emilia-Romagna     384820 13209 360157 11454 44.49436681 11.3417208 2021-06-07 04:22:51 Emilia-Romagna, Italy
158400 2021-06-05 Italy Emilia-Romagna     384648 13208 359726 11714 44.49436681 11.3417208 2021-06-06 04:24:03 Emilia-Romagna, Italy
1516385 2021-06-04 Italy Emilia-Romagna     384514 13198 359102 12214 44.49436681 11.3417208 2021-06-05 04:23:03 Emilia-Romagna, Italy
1140696 2021-06-03 Italy Emilia-Romagna     384365 13193 357984 13188 44.49436681 11.3417208 2021-06-04 04:23:37 Emilia-Romagna, Italy
427140 2021-06-02 Italy Emilia-Romagna     384137 13190 357105 13842 44.49436681 11.3417208 2021-06-03 04:23:32 Emilia-Romagna, Italy
539647 2021-06-01 Italy Emilia-Romagna     383986 13189 356379 14418 44.49436681 11.3417208 2021-06-02 04:24:34 Emilia-Romagna, Italy
786832 2021-05-31 Italy Emilia-Romagna     383879 13186 355420 15273 44.49436681 11.3417208 2021-06-01 04:23:09 Emilia-Romagna, Italy
1330230 2021-05-30 Italy Emilia-Romagna     383693 13183 354748 15762 44.49436681 11.3417208 2021-05-31 03:08:59 Emilia-Romagna, Italy
67439 2021-05-29 Italy Emilia-Romagna     383503 13180 354260 16063 44.49436681 11.3417208 2021-05-30 04:20:55 Emilia-Romagna, Italy
195625 2021-05-28 Italy Emilia-Romagna     383282 13174 353718 16390 44.49436681 11.3417208 2021-05-29 04:20:41 Emilia-Romagna, Italy
938884 2021-05-27 Italy Emilia-Romagna     383025 13170 352498 17357 44.49436681 11.3417208 2021-05-28 04:20:36 Emilia-Romagna, Italy
1226559 2021-05-26 Italy Emilia-Romagna     382766 13167 352065 17534 44.49436681 11.3417208 2021-05-27 04:20:59 Emilia-Romagna, Italy
1338198 2021-05-25 Italy Emilia-Romagna     382544 13163 351559 17822 44.49436681 11.3417208 2021-05-26 04:20:35 Emilia-Romagna, Italy
203030 2021-05-24 Italy Emilia-Romagna     382387 13153 350713 18521 44.49436681 11.3417208 2021-05-25 04:21:08 Emilia-Romagna, Italy
99194 2021-05-23 Italy Emilia-Romagna     382073 13146 349845 19082 44.49436681 11.3417208 2021-05-24 04:20:53 Emilia-Romagna, Italy
523713 2021-05-22 Italy Emilia-Romagna     381776 13140 349298 19338 44.49436681 11.3417208 2021-05-23 04:20:51 Emilia-Romagna, Italy
859408 2021-05-21 Italy Emilia-Romagna     381439 13129 347102 21208 44.49436681 11.3417208 2021-05-22 04:20:45 Emilia-Romagna, Italy
720831 2021-05-20 Italy Emilia-Romagna     381029 13122 346200 21707 44.49436681 11.3417208 2021-05-21 04:20:43 Emilia-Romagna, Italy
407962 2021-05-19 Italy Emilia-Romagna     380569 13116 345439 22014 44.49436681 11.3417208 2021-05-20 04:21:05 Emilia-Romagna, Italy
782848 2021-05-18 Italy Emilia-Romagna     380246 13107 344858 22281 44.49436681 11.3417208 2021-05-19 04:20:42 Emilia-Romagna, Italy
1422990 2021-05-17 Italy Emilia-Romagna     379918 13097 343813 23008 44.49436681 11.3417208 2021-05-18 04:20:33 Emilia-Romagna, Italy
740176 2021-05-16 Italy Emilia-Romagna     379577 13088 343060 23429 44.49436681 11.3417208 2021-05-17 04:20:34 Emilia-Romagna, Italy
1116709 2021-05-15 Italy Emilia-Romagna     379130 13081 341330 24719 44.49436681 11.3417208 2021-05-16 04:20:49 Emilia-Romagna, Italy
1587218 2021-05-14 Italy Emilia-Romagna     378607 13067 338648 26892 44.49436681 11.3417208 2021-05-15 04:20:58 Emilia-Romagna, Italy
1675135 2021-05-13 Italy Emilia-Romagna     378060 13056 338195 26809 44.49436681 11.3417208 2021-05-14 04:20:41 Emilia-Romagna, Italy
802762 2021-05-12 Italy Emilia-Romagna     377444 13038 337875 26531 44.49436681 11.3417208 2021-05-13 04:20:51 Emilia-Romagna, Italy
1181150 2021-05-11 Italy Emilia-Romagna     376939 13031 335032 28876 44.49436681 11.3417208 2021-05-12 04:21:29 Emilia-Romagna, Italy
324940 2021-05-10 Italy Emilia-Romagna     376486 13019 332088 31379 44.49436681 11.3417208 2021-05-11 04:20:41 Emilia-Romagna, Italy
604087 2021-05-09 Italy Emilia-Romagna     376018 13010 329654 33354 44.49436681 11.3417208 2021-05-10 04:20:38 Emilia-Romagna, Italy
985834 2021-05-08 Italy Emilia-Romagna     375371 13007 324679 37685 44.49436681 11.3417208 2021-05-09 04:20:35 Emilia-Romagna, Italy
434316 2021-05-07 Italy Emilia-Romagna     374498 12992 321870 39636 44.49436681 11.3417208 2021-05-08 04:21:04 Emilia-Romagna, Italy
901097 2021-05-06 Italy Emilia-Romagna     373632 12976 321141 39515 44.49436681 11.3417208 2021-05-07 04:20:40 Emilia-Romagna, Italy
71423 2021-05-05 Italy Emilia-Romagna     372817 12957 320778 39082 44.49436681 11.3417208 2021-05-06 04:20:38 Emilia-Romagna, Italy
790816 2021-05-04 Italy Emilia-Romagna     372262 12940 320194 39128 44.49436681 11.3417208 2021-05-05 04:20:43 Emilia-Romagna, Italy
1613346 2021-05-03 Italy Emilia-Romagna     371776 12916 316859 42001 44.49436681 11.3417208 2021-05-04 04:20:34 Emilia-Romagna, Italy
885984 2021-05-02 Italy Emilia-Romagna     371137 12906 316468 41763 44.49436681 11.3417208 2021-05-03 04:20:39 Emilia-Romagna, Italy
511689 2021-05-01 Italy Emilia-Romagna     370190 12893 315967 41330 44.49436681 11.3417208 2021-05-02 04:20:48 Emilia-Romagna, Italy
14625 2021-04-30 Italy Emilia-Romagna     369250 12876 312018 44356 44.49436681 11.3417208 2021-05-01 04:20:47 Emilia-Romagna, Italy
1124729 2021-04-29 Italy Emilia-Romagna     368045 12859 311535 43651 44.49436681 11.3417208 2021-04-30 04:21:03 Emilia-Romagna, Italy
462026 2021-04-28 Italy Emilia-Romagna     367071 12843 308683 45545 44.49436681 11.3417208 2021-04-29 04:20:55 Emilia-Romagna, Italy
1314732 2021-04-27 Italy Emilia-Romagna     366432 12820 305809 47803 44.49436681 11.3417208 2021-04-28 04:20:32 Emilia-Romagna, Italy
1549159 2021-04-26 Italy Emilia-Romagna     365715 12801 304391 48523 44.49436681 11.3417208 2021-04-27 04:20:52 Emilia-Romagna, Italy
1629626 2021-04-25 Italy Emilia-Romagna     364782 12784 301517 50481 44.49436681 11.3417208 2021-04-26 04:21:04 Emilia-Romagna, Italy
353766 2021-04-24 Italy Emilia-Romagna     363782 12761 298618 52403 44.49436681 11.3417208 2021-04-25 04:20:32 Emilia-Romagna, Italy
724815 2021-04-23 Italy Emilia-Romagna     362801 12731 295521 54549 44.49436681 11.3417208 2021-04-24 04:20:38 Emilia-Romagna, Italy
1469827 2021-04-22 Italy Emilia-Romagna     361700 12718 292461 56521 44.49436681 11.3417208 2021-04-23 04:20:52 Emilia-Romagna, Italy
1222575 2021-04-21 Italy Emilia-Romagna     360694 12690 289471 58533 44.49436681 11.3417208 2021-04-22 04:20:53 Emilia-Romagna, Italy
458042 2021-04-20 Italy Emilia-Romagna     359941 12667 286311 60963 44.49436681 11.3417208 2021-04-21 04:21:14 Emilia-Romagna, Italy
1300230 2021-04-19 Italy Emilia-Romagna     359206 12640 283279 63287 44.49436681 11.3417208 2021-04-20 04:20:41 Emilia-Romagna, Italy
1069809 2021-04-18 Italy Emilia-Romagna     358329 12608 281836 63885 44.49436681 11.3417208 2021-04-19 04:20:57 Emilia-Romagna, Italy
1045691 2021-04-17 Italy Emilia-Romagna     357231 12587 280953 63691 44.49436681 11.3417208 2021-04-18 04:20:41 Emilia-Romagna, Italy
596967 2021-04-16 Italy Emilia-Romagna     356159 12557 279482 64120 44.49436681 11.3417208 2021-04-17 04:20:40 Emilia-Romagna, Italy
1621383 2021-04-15 Italy Emilia-Romagna     354901 12515 277120 65266 44.49436681 11.3417208 2021-04-16 04:20:46 Emilia-Romagna, Italy
950814 2021-04-14 Italy Emilia-Romagna     353761 12482 276162 65117 44.49436681 11.3417208 2021-04-15 04:20:54 Emilia-Romagna, Italy
592983 2021-04-13 Italy Emilia-Romagna     352908 12452 275503 64953 44.49436681 11.3417208 2021-04-14 04:20:41 Emilia-Romagna, Italy
32922 2021-04-12 Italy Emilia-Romagna     352131 12411 273287 66433 44.49436681 11.3417208 2021-04-13 04:20:37 Emilia-Romagna, Italy
1371937 2021-04-11 Italy Emilia-Romagna     350988 12380 271983 66625 44.49436681 11.3417208 2021-04-12 04:21:00 Emilia-Romagna, Italy
1667189 2021-04-10 Italy Emilia-Romagna     349822 12340 270050 67432 44.49436681 11.3417208 2021-04-11 04:20:56 Emilia-Romagna, Italy
1159805 2021-04-09 Italy Emilia-Romagna     348305 12307 267780 68218 44.49436681 11.3417208 2021-04-10 04:20:59 Emilia-Romagna, Italy
1057640 2021-04-08 Italy Emilia-Romagna     346820 12271 265694 68855 44.49436681 11.3417208 2021-04-09 04:21:13 Emilia-Romagna, Italy
1500429 2021-04-07 Italy Emilia-Romagna     345753 12246 264532 68975 44.49436681 11.3417208 2021-04-08 04:21:13 Emilia-Romagna, Italy
1207634 2021-04-06 Italy Emilia-Romagna     345196 12189 262117 70890 44.49436681 11.3417208 2021-04-07 04:20:53 Emilia-Romagna, Italy
122935 2021-04-05 Italy Emilia-Romagna     344408 12151 260051 72206 44.49436681 11.3417208 2021-04-06 04:20:32 Emilia-Romagna, Italy
1254736 2021-04-04 Italy Emilia-Romagna     342915 12113 258614 72188 44.49436681 11.3417208 2021-04-05 04:20:35 Emilia-Romagna, Italy
1128713 2021-04-03 Italy Emilia-Romagna     341218 12078 256660 72480 44.49436681 11.3417208 2021-04-04 04:20:49 Emilia-Romagna, Italy
270104 2021-04-02 Italy Emilia-Romagna     339440 12040 254151 73249 44.49436681 11.3417208 2021-04-03 04:20:44 Emilia-Romagna, Italy
1173436 2021-04-01 Italy Emilia-Romagna     337620 11984 253277 72359 44.49436681 11.3417208 2021-04-02 04:20:36 Emilia-Romagna, Italy
515747 2021-03-31 Italy Emilia-Romagna     335820 11917 251468 72435 44.49436681 11.3417208 2021-04-01 04:27:05 Emilia-Romagna, Italy
289476 2021-03-30 Italy Emilia-Romagna     334343 11859 249404 73080 44.49436681 11.3417208 2021-03-31 04:26:25 Emilia-Romagna, Italy
1575013 2021-03-29 Italy Emilia-Romagna     333169 11792 247487 73890 44.49436681 11.3417208 2021-03-30 04:26:23 Emilia-Romagna, Italy
631290 2021-03-28 Italy Emilia-Romagna     331173 11737 246682 72754 44.49436681 11.3417208 2021-03-29 04:28:35 Emilia-Romagna, Italy
608071 2021-03-27 Italy Emilia-Romagna     329041 11706 245274 72061 44.49436681 11.3417208 2021-03-28 05:28:10 Emilia-Romagna, Italy
1334214 2021-03-26 Italy Emilia-Romagna     326776 11673 243244 71859 44.49436681 11.3417208 2021-03-27 05:25:04 Emilia-Romagna, Italy
150653 2021-03-25 Italy Emilia-Romagna     324394 11627 240932 71835 44.49436681 11.3417208 2021-03-26 05:26:55 Emilia-Romagna, Italy
1598174 2021-03-24 Italy Emilia-Romagna     322337 11569 238912 71856 44.49436681 11.3417208 2021-03-25 05:27:00 Emilia-Romagna, Italy
403978 2021-03-23 Italy Emilia-Romagna     320632 11524 235512 73596 44.49436681 11.3417208 2021-03-24 05:25:40 Emilia-Romagna, Italy
1387515 2021-03-22 Italy Emilia-Romagna     319080 11468 232841 74771 44.49436681 11.3417208 2021-03-23 05:26:18 Emilia-Romagna, Italy
305002 2021-03-21 Italy Emilia-Romagna     316967 11424 231079 74464 44.49436681 11.3417208 2021-03-22 05:25:43 Emilia-Romagna, Italy
254051 2021-03-20 Italy Emilia-Romagna     314526 11390 229697 73439 44.49436681 11.3417208 2021-03-21 05:25:44 Emilia-Romagna, Italy
1230807 2021-03-19 Italy Emilia-Romagna     311988 11343 227858 72787 44.49436681 11.3417208 2021-03-20 05:25:46 Emilia-Romagna, Italy
974732 2021-03-18 Italy Emilia-Romagna     308826 11301 227087 70438 44.49436681 11.3417208 2021-03-19 05:26:09 Emilia-Romagna, Italy
1532367 2021-03-17 Italy Emilia-Romagna     306324 11236 225473 69615 44.49436681 11.3417208 2021-03-18 05:26:22 Emilia-Romagna, Italy
55561 2021-03-16 Italy Emilia-Romagna     304314 11184 224138 68992 44.49436681 11.3417208 2021-03-17 05:25:07 Emilia-Romagna, Italy
562874 2021-03-15 Italy Emilia-Romagna     302148 11137 222718 68293 44.49436681 11.3417208 2021-03-16 05:25:13 Emilia-Romagna, Italy
851443 2021-03-14 Italy Emilia-Romagna     299339 11076 221695 66568 44.49436681 11.3417208 2021-03-15 05:25:51 Emilia-Romagna, Italy
942868 2021-03-13 Italy Emilia-Romagna     296324 11025 220812 64487 44.49436681 11.3417208 2021-03-14 05:25:37 Emilia-Romagna, Italy
1310748 2021-03-12 Italy Emilia-Romagna     293400 10994 219789 62617 44.49436681 11.3417208 2021-03-13 05:25:15 Emilia-Romagna, Italy
1077586 2021-03-11 Italy Emilia-Romagna     289957 10959 218332 60666 44.49436681 11.3417208 2021-03-12 05:26:50 Emilia-Romagna, Italy
954798 2021-03-10 Italy Emilia-Romagna     287136 10914 216774 59448 44.49436681 11.3417208 2021-03-11 05:25:48 Emilia-Romagna, Italy
543631 2021-03-09 Italy Emilia-Romagna     285021 10871 215754 58396 44.49436681 11.3417208 2021-03-10 05:24:35 Emilia-Romagna, Italy
1520369 2021-03-08 Italy Emilia-Romagna     282616 10827 214771 57018 44.49436681 11.3417208 2021-03-09 05:28:19 Emilia-Romagna, Italy
866650 2021-03-07 Italy Emilia-Romagna     279646 10777 213934 54935 44.49436681 11.3417208 2021-03-08 05:24:48 Emilia-Romagna, 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]);