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

8,546 rows where country_or_region = "Italy" sorted by deaths

View and edit SQL

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

province_or_state

country_or_region

  • Italy · 8,546
Link rowid day country_or_region province_or_state admin2 fips confirmed deaths ▼ recovered active latitude longitude last_update combined_key
72813 2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
252560 2020-02-07 Italy       3 0 0       2020-02-07T17:53:02  
299494 2020-02-18 Italy       3 0 0       2020-02-07T17:53:02  
383960 2020-02-01 Italy       2 0 0       1/31/2020 8:15  
399879 2020-02-11 Italy       3 0 0       2020-02-07T17:53:02  
477663 2020-02-04 Italy       2 0 0       2020-01-31T08:15:53  
523904 2020-02-09 Italy       3 0 0       2020-02-07T17:53:02  
527948 2020-02-06 Italy       2 0 0       2020-01-31T08:15:53  
655322 2020-02-17 Italy       3 0 0       2020-02-07T17:53:02  
677705 2020-02-08 Italy       3 0 0       2020-02-07T17:53:02  
996361 2020-02-16 Italy       3 0 0       2020-02-07T17:53:02  
1113585 2020-01-31 Italy       2 0 0       1/31/2020 23:59  
1277080 2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
1285131 2020-02-15 Italy       3 0 0       2020-02-07T17:53:02  
1350205 2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
1442248 2020-02-10 Italy       3 0 0       2020-02-07T17:53:02  
1542121 2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
1597183 2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
1597263 2020-02-05 Italy       2 0 0       2020-01-31T08:15:53  
1659427 2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
1710525 2020-02-13 Italy       3 0 0       2020-02-07T17:53:02  
1738860 2020-02-21 Italy       20 1 0       2020-02-21T23:33:06  
1079672 2020-02-22 Italy       62 2 1       2020-02-22T23:43:02  
1091703 2020-02-23 Italy       155 3 2       2020-02-23T23:43:02  
1156638 2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
80255 2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
629383 2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
826545 2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
1071580 2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
167895 2020-05-19 Italy Molise     422 22 188 212 41.55774754 14.65916051 2020-05-20 02:32:19 Molise, Italy
252226 2020-05-27 Italy Molise     434 22 246 166 41.55774754 14.65916051 2020-05-28 02:32:31 Molise, Italy
310136 2020-05-23 Italy Molise     431 22 220 189 41.55774754 14.65916051 2020-05-24 02:32:43 Molise, Italy
317500 2020-05-20 Italy Molise     422 22 202 198 41.55774754 14.65916051 2020-05-21 02:32:48 Molise, Italy
448576 2020-06-02 Italy Molise     436 22 281 133 41.55774754 14.65916051 2020-06-03 02:33:13 Molise, Italy
504462 2020-05-16 Italy Molise     410 22 173 215 41.55774754 14.65916051 2020-05-17 02:32:32 Molise, Italy
777541 2020-05-28 Italy Molise     435 22 250 163 41.55774754 14.65916051 2020-05-29 02:32:50 Molise, Italy
911285 2020-05-17 Italy Molise     411 22 173 216 41.55774754 14.65916051 2020-05-18 02:32:21 Molise, Italy
995820 2020-05-31 Italy Molise     436 22 269 145 41.55774754 14.65916051 2020-06-01 02:32:46 Molise, Italy
1144378 2020-05-22 Italy Molise     426 22 220 184 41.55774754 14.65916051 2020-05-23 02:32:42 Molise, Italy
1299236 2020-05-15 Italy Molise     407 22 158 227 41.55774754 14.65916051 2020-05-16 02:32:19 Molise, Italy
1302753 2020-06-01 Italy Molise     436 22 279 135 41.55774754 14.65916051 2020-06-02 02:33:08 Molise, Italy
1384000 2020-05-24 Italy Molise     432 22 227 183 41.55774754 14.65916051 2020-05-25 02:32:44 Molise, Italy
1452457 2020-05-21 Italy Molise     423 22 207 194 41.55774754 14.65916051 2020-05-22 02:36:51 Molise, Italy
1455947 2020-05-29 Italy Molise     436 22 252 162 41.55774754 14.65916051 2020-05-30 02:32:48 Molise, Italy
1463532 2020-06-03 Italy Molise     436 22 287 127 41.55774754 14.65916051 2020-06-04 02:33:14 Molise, Italy
1494728 2020-05-30 Italy Molise     436 22 258 156 41.55774754 14.65916051 2020-05-31 02:32:45 Molise, Italy
1537803 2020-05-26 Italy Molise     432 22 236 174 41.55774754 14.65916051 2020-05-27 02:32:31 Molise, Italy
1624148 2020-05-25 Italy Molise     432 22 233 177 41.55774754 14.65916051 2020-05-26 02:32:35 Molise, Italy
1635446 2020-05-18 Italy Molise     422 22 183 217 41.55774754 14.65916051 2020-05-19 02:32:18 Molise, Italy
1666493 2020-05-14 Italy Molise     403 22 152 229 41.55774754 14.65916051 2020-05-15 02:33:02 Molise, Italy
287 2020-09-15 Italy Molise     570 23 450 97 41.55774754 14.65916051 2020-09-16 04:22:53 Molise, Italy
11238 2020-06-09 Italy Molise     438 23 295 120 41.55774754 14.65916051 2020-06-10 04:07:00 Molise, Italy
21595 2020-06-17 Italy Molise     440 23 355 62 41.55774754 14.65916051 2020-06-18 04:33:18 Molise, Italy
29720 2020-08-02 Italy Molise     475 23 421 31 41.55774754 14.65916051 2020-08-03 04:34:35 Molise, Italy
34385 2020-08-21 Italy Molise     509 23 430 56 41.55774754 14.65916051 2020-08-22 04:27:49 Molise, Italy
50298 2020-09-24 Italy Molise     627 23 471 133 41.55774754 14.65916051 2020-09-25 04:23:00 Molise, Italy
87722 2020-07-03 Italy Molise     445 23 401 21 41.55774754 14.65916051 2020-07-04 04:33:51 Molise, Italy
104408 2020-09-25 Italy Molise     632 23 476 133 41.55774754 14.65916051 2020-09-26 04:23:00 Molise, Italy
133993 2020-08-06 Italy Molise     478 23 421 34 41.55774754 14.65916051 2020-08-07 04:35:11 Molise, Italy
141922 2020-07-30 Italy Molise     470 23 421 26 41.55774754 14.65916051 2020-07-31 04:35:18 Molise, Italy
145750 2020-07-11 Italy Molise     445 23 410 12 41.55774754 14.65916051 2020-07-12 04:34:30 Molise, Italy
149514 2020-06-21 Italy Molise     441 23 378 40 41.55774754 14.65916051 2020-06-22 04:33:20 Molise, Italy
186931 2020-06-07 Italy Molise     436 23 293 120 41.55774754 14.65916051 2020-06-08 03:33:22 Molise, Italy
194838 2020-08-03 Italy Molise     477 23 421 33 41.55774754 14.65916051 2020-08-04 04:41:59 Molise, Italy
195539 2020-08-28 Italy Molise     522 23 432 67 41.55774754 14.65916051 2020-08-29 04:28:19 Molise, Italy
199497 2020-08-24 Italy Molise     511 23 432 56 41.55774754 14.65916051 2020-08-25 04:28:02 Molise, Italy
225363 2020-07-07 Italy Molise     445 23 404 18 41.55774754 14.65916051 2020-07-08 05:33:48 Molise, Italy
234027 2020-09-21 Italy Molise     618 23 463 132 41.55774754 14.65916051 2020-09-22 04:23:00 Molise, Italy
241976 2020-08-22 Italy Molise     510 23 430 57 41.55774754 14.65916051 2020-08-23 04:27:48 Molise, Italy
267944 2020-07-05 Italy Molise     445 23 401 21 41.55774754 14.65916051 2020-07-06 04:33:57 Molise, Italy
310708 2020-08-31 Italy Molise     525 23 432 70 41.55774754 14.65916051 2020-09-01 04:28:31 Molise, Italy
332493 2020-08-10 Italy Molise     479 23 423 33 41.55774754 14.65916051 2020-08-11 04:35:08 Molise, Italy
343682 2020-06-22 Italy Molise     444 23 378 43 41.55774754 14.65916051 2020-06-23 04:33:22 Molise, Italy
344375 2020-08-30 Italy Molise     525 23 432 70 41.55774754 14.65916051 2020-08-31 04:28:27 Molise, Italy
356348 2020-09-18 Italy Molise     581 23 458 100 41.55774754 14.65916051 2020-09-19 04:22:00 Molise, Italy
376512 2020-09-07 Italy Molise     545 23 436 86 41.55774754 14.65916051 2020-09-08 04:28:25 Molise, Italy
383510 2020-06-10 Italy Molise     439 23 296 120 41.55774754 14.65916051 2020-06-11 03:33:41 Molise, Italy
391483 2020-08-09 Italy Molise     479 23 421 35 41.55774754 14.65916051 2020-08-10 04:34:55 Molise, Italy
392186 2020-09-11 Italy Molise     559 23 448 88 41.55774754 14.65916051 2020-09-12 04:25:05 Molise, Italy
404179 2020-09-02 Italy Molise     528 23 432 73 41.55774754 14.65916051 2020-09-03 04:28:22 Molise, Italy
408141 2020-09-08 Italy Molise     548 23 437 88 41.55774754 14.65916051 2020-09-09 04:28:48 Molise, Italy
415240 2020-07-16 Italy Molise     446 23 414 9 41.55774754 14.65916051 2020-07-17 04:34:50 Molise, Italy
427354 2020-09-20 Italy Molise     587 23 460 104 41.55774754 14.65916051 2020-09-21 04:23:00 Molise, Italy
461334 2020-06-27 Italy Molise     445 23 396 26 41.55774754 14.65916051 2020-06-28 04:34:04 Molise, Italy
477197 2020-07-24 Italy Molise     460 23 419 18 41.55774754 14.65916051 2020-07-25 04:47:39 Molise, Italy
481962 2020-09-23 Italy Molise     623 23 468 132 41.55774754 14.65916051 2020-09-24 04:23:00 Molise, Italy
493028 2020-07-06 Italy Molise     445 23 401 21 41.55774754 14.65916051 2020-07-07 04:34:00 Molise, Italy
520184 2020-08-27 Italy Molise     521 23 432 66 41.55774754 14.65916051 2020-08-28 04:28:11 Molise, Italy
531262 2020-06-06 Italy Molise     436 23 292 121 41.55774754 14.65916051 2020-06-07 03:53:30 Molise, Italy
550123 2020-06-12 Italy Molise     439 23 302 114 41.55774754 14.65916051 2020-06-13 03:33:14 Molise, Italy
559903 2020-06-28 Italy Molise     445 23 396 26 41.55774754 14.65916051 2020-06-29 04:33:44 Molise, Italy
575761 2020-08-29 Italy Molise     524 23 432 69 41.55774754 14.65916051 2020-08-30 04:28:22 Molise, Italy
616930 2020-07-20 Italy Molise     446 23 415 8 41.55774754 14.65916051 2020-07-21 04:38:46 Molise, Italy
636812 2020-06-20 Italy Molise     441 23 365 53 41.55774754 14.65916051 2020-06-21 04:33:19 Molise, Italy
650889 2020-07-21 Italy Molise     446 23 415 8 41.55774754 14.65916051 2020-07-22 04:34:42 Molise, Italy
658739 2020-06-29 Italy Molise     445 23 396 26 41.55774754 14.65916051 2020-06-30 04:33:48 Molise, Italy
662379 2020-08-17 Italy Molise     487 23 429 35 41.55774754 14.65916051 2020-08-18 04:27:56 Molise, Italy
669321 2020-06-04 Italy Molise     436 23 288 125 41.55774754 14.65916051 2020-06-05 02:33:06 Molise, Italy
678019 2020-08-16 Italy Molise     487 23 429 35 41.55774754 14.65916051 2020-08-17 04:27:20 Molise, Italy
712913 2020-06-18 Italy Molise     440 23 357 60 41.55774754 14.65916051 2020-06-19 04:33:17 Molise, 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]);