⚠️ 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,651 rows where country_or_region = "Italy" sorted by longitude

View and edit SQL

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

province_or_state

country_or_region

  • Italy · 8,651
Link rowid day country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude ▼ last_update combined_key
120830 2020-02-21 Italy       20 1 0       2020-02-21T23:33:06  
153293 2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
226600 2020-02-09 Italy       3 0 0       2020-02-07T17:53:02  
242402 2020-02-05 Italy       2 0 0       2020-01-31T08:15:53  
353988 2020-02-18 Italy       3 0 0       2020-02-07T17:53:02  
379575 2020-02-16 Italy       3 0 0       2020-02-07T17:53:02  
491486 2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
673549 2020-02-06 Italy       2 0 0       2020-01-31T08:15:53  
677611 2020-02-04 Italy       2 0 0       2020-01-31T08:15:53  
685356 2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
708809 2020-02-15 Italy       3 0 0       2020-02-07T17:53:02  
754559 2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
754640 2020-02-11 Italy       3 0 0       2020-02-07T17:53:02  
874521 2020-02-07 Italy       3 0 0       2020-02-07T17:53:02  
885794 2020-02-13 Italy       3 0 0       2020-02-07T17:53:02  
965208 2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
965376 2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
1012396 2020-02-23 Italy       155 3 2       2020-02-23T23:43:02  
1023602 2020-01-31 Italy       2 0 0       1/31/2020 23:59  
1086486 2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
1143330 2020-02-08 Italy       3 0 0       2020-02-07T17:53:02  
1215236 2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
1311397 2020-02-10 Italy       3 0 0       2020-02-07T17:53:02  
1369524 2020-02-17 Italy       3 0 0       2020-02-07T17:53:02  
1403250 2020-02-22 Italy       62 2 1       2020-02-22T23:43:02  
1523220 2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
1560730 2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
1586169 2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
1637554 2020-02-01 Italy       2 0 0       1/31/2020 8:15  
1684499 2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
304 2021-02-27 Italy P.A. Trento     33729 1206 28868 3655 46.06893511 11.12123097 2021-02-28 05:22:20 P.A. Trento, Italy
7310 2020-06-04 Italy P.A. Trento     4433 464 3762 207 46.06893511 11.12123097 2020-06-05 02:33:06 P.A. Trento, Italy
7931 2020-08-11 Italy P.A. Trento     4998 405 4518 75 46.06893511 11.12123097 2020-08-12 04:27:29 P.A. Trento, Italy
11884 2020-09-27 Italy P.A. Trento     5922 405 4919 598 46.06893511 11.12123097 2020-09-28 04:23:00 P.A. Trento, Italy
19109 2021-05-31 Italy P.A. Trento     45427 1355 43599 473 46.06893511 11.12123097 2021-06-01 04:23:09 P.A. Trento, Italy
23096 2021-05-05 Italy P.A. Trento     44282 1346 42000 936 46.06893511 11.12123097 2021-05-06 04:20:38 P.A. Trento, Italy
27082 2021-02-08 Italy P.A. Trento     28974 1170 25207 2597 46.06893511 11.12123097 2021-02-09 05:23:30 P.A. Trento, Italy
34075 2020-11-20 Italy P.A. Trento     13761 563 10194 3004 46.06893511 11.12123097 2020-11-21 05:25:51 P.A. Trento, Italy
38046 2020-09-20 Italy P.A. Trento     5734 405 4772 557 46.06893511 11.12123097 2020-09-21 04:23:00 P.A. Trento, Italy
42024 2021-06-16 Italy P.A. Trento     45700 1360 44147 193 46.06893511 11.12123097 2021-06-17 04:22:36 P.A. Trento, Italy
46009 2020-12-21 Italy P.A. Trento     20154 855 17227 2072 46.06893511 11.12123097 2020-12-22 05:22:33 P.A. Trento, Italy
49980 2020-09-04 Italy P.A. Trento     5246 405 4611 230 46.06893511 11.12123097 2020-09-05 04:28:19 P.A. Trento, Italy
56993 2020-06-05 Italy P.A. Trento     4433 464 3846 123 46.06893511 11.12123097 2020-06-06 02:33:00 P.A. Trento, Italy
57637 2021-05-20 Italy P.A. Trento     45067 1354 43050 663 46.06893511 11.12123097 2021-05-21 04:20:43 P.A. Trento, Italy
64734 2020-06-22 Italy P.A. Trento     4464 466 3945 53 46.06893511 11.12123097 2020-06-23 04:33:22 P.A. Trento, Italy
65389 2021-02-13 Italy P.A. Trento     30164 1176 26275 2713 46.06893511 11.12123097 2021-02-14 05:23:43 P.A. Trento, Italy
69374 2020-11-14 Italy P.A. Trento     12300 516 8950 2834 46.06893511 11.12123097 2020-11-15 05:26:53 P.A. Trento, Italy
76795 2020-11-15 Italy P.A. Trento     12568 524 9082 2962 46.06893511 11.12123097 2020-11-16 05:25:57 P.A. Trento, Italy
80781 2021-05-28 Italy P.A. Trento     45353 1354 43481 518 46.06893511 11.12123097 2021-05-29 04:20:41 P.A. Trento, Italy
84768 2021-03-17 Italy P.A. Trento     38369 1246 33152 3971 46.06893511 11.12123097 2021-03-18 05:26:22 P.A. Trento, Italy
88755 2021-05-08 Italy P.A. Trento     44500 1346 42220 934 46.06893511 11.12123097 2021-05-09 04:20:35 P.A. Trento, Italy
99615 2020-11-17 Italy P.A. Trento     13025 542 9489 2994 46.06893511 11.12123097 2020-11-18 05:40:31 P.A. Trento, Italy
106696 2020-06-13 Italy P.A. Trento     4446 464 3912 70 46.06893511 11.12123097 2020-06-14 03:33:15 P.A. Trento, Italy
107350 2020-12-07 Italy P.A. Trento     17268 707 14044 2517 46.06893511 11.12123097 2020-12-08 05:27:42 P.A. Trento, Italy
120440 2020-07-05 Italy P.A. Trento     4873 405 4426 42 46.06893511 11.12123097 2020-07-06 04:33:57 P.A. Trento, Italy
121185 2021-05-09 Italy P.A. Trento     44557 1346 42331 880 46.06893511 11.12123097 2021-05-10 04:20:38 P.A. Trento, Italy
125172 2021-04-01 Italy P.A. Trento     41371 1286 37221 2864 46.06893511 11.12123097 2021-04-02 04:20:36 P.A. Trento, Italy
129159 2021-05-11 Italy P.A. Trento     44613 1349 42430 834 46.06893511 11.12123097 2021-05-12 04:21:29 P.A. Trento, Italy
133311 2021-02-28 Italy P.A. Trento     34058 1206 28919 3933 46.06893511 11.12123097 2021-03-01 05:23:01 P.A. Trento, Italy
137653 2021-03-09 Italy P.A. Trento     36222 1227 31050 3945 46.06893511 11.12123097 2021-03-10 05:24:35 P.A. Trento, Italy
141639 2021-01-08 Italy P.A. Trento     23153 998 20225 1930 46.06893511 11.12123097 2021-01-09 05:22:18 P.A. Trento, Italy
145611 2020-10-27 Italy P.A. Trento     8162 427 6087 1648 46.06893511 11.12123097 2020-10-28 04:24:39 P.A. Trento, Italy
149593 2021-05-24 Italy P.A. Trento     45198 1354 43246 598 46.06893511 11.12123097 2021-05-25 04:21:08 P.A. Trento, Italy
153665 2020-10-02 Italy P.A. Trento     6079 406 5086 587 46.06893511 11.12123097 2020-10-03 04:23:40 P.A. Trento, Italy
160837 2020-12-19 Italy P.A. Trento     19987 839 16785 2363 46.06893511 11.12123097 2020-12-20 05:27:32 P.A. Trento, Italy
164823 2021-03-04 Italy P.A. Trento     34921 1213 30007 3701 46.06893511 11.12123097 2021-03-05 05:26:29 P.A. Trento, Italy
168808 2020-11-24 Italy P.A. Trento     14368 599 11297 2472 46.06893511 11.12123097 2020-11-25 05:27:20 P.A. Trento, Italy
175569 2020-05-16 Italy P.A. Trento     4326 453 3528 345 46.06893511 11.12123097 2020-05-17 02:32:32 P.A. Trento, Italy
176105 2020-12-17 Italy P.A. Trento     19553 821 15681 3051 46.06893511 11.12123097 2020-12-18 05:28:18 P.A. Trento, Italy
180076 2020-08-29 Italy P.A. Trento     5084 405 4595 84 46.06893511 11.12123097 2020-08-30 04:28:22 P.A. Trento, Italy
184036 2020-10-07 Italy P.A. Trento     6296 406 5241 649 46.06893511 11.12123097 2020-10-08 04:23:56 P.A. Trento, Italy
191299 2020-07-31 Italy P.A. Trento     4975 405 4470 100 46.06893511 11.12123097 2020-08-01 04:36:27 P.A. Trento, Italy
194971 2020-06-01 Italy P.A. Trento     4432 462 3677 293 46.06893511 11.12123097 2020-06-02 02:33:08 P.A. Trento, Italy
195593 2020-10-04 Italy P.A. Trento     6175 406 5140 629 46.06893511 11.12123097 2020-10-05 04:23:33 P.A. Trento, Italy
199788 2020-10-12 Italy P.A. Trento     6485 409 5396 680 46.06893511 11.12123097 2020-10-13 04:24:02 P.A. Trento, Italy
206951 2021-01-05 Italy P.A. Trento     22700 984 19640 2076 46.06893511 11.12123097 2021-01-06 05:22:16 P.A. Trento, Italy
210922 2020-09-18 Italy P.A. Trento     5667 405 4704 558 46.06893511 11.12123097 2020-09-19 04:22:00 P.A. Trento, Italy
214900 2021-04-04 Italy P.A. Trento     41781 1297 37761 2723 46.06893511 11.12123097 2021-04-05 04:20:35 P.A. Trento, Italy
218885 2020-12-01 Italy P.A. Trento     15889 662 12777 2450 46.06893511 11.12123097 2020-12-02 05:27:41 P.A. Trento, Italy
222869 2021-01-01 Italy P.A. Trento     22033 952 19182 1899 46.06893511 11.12123097 2021-01-02 05:22:33 P.A. Trento, Italy
226932 2021-06-21 Italy P.A. Trento     45733 1361 44228 144 46.06893511 11.12123097 2021-06-22 04:21:34 P.A. Trento, Italy
230919 2021-05-17 Italy P.A. Trento     44929 1353 42817 759 46.06893511 11.12123097 2021-05-18 04:20:33 P.A. Trento, Italy
234906 2021-06-24 Italy P.A. Trento     45748 1361 44281 106 46.06893511 11.12123097 2021-06-25 04:21:33 P.A. Trento, Italy
242000 2020-06-20 Italy P.A. Trento     4458 466 3941 51 46.06893511 11.12123097 2020-06-21 04:33:19 P.A. Trento, Italy
245902 2021-06-06 Italy P.A. Trento     45568 1359 43853 356 46.06893511 11.12123097 2021-06-07 04:22:51 P.A. Trento, Italy
249887 2020-12-06 Italy P.A. Trento     17103 691 13995 2417 46.06893511 11.12123097 2020-12-07 05:26:14 P.A. Trento, Italy
253873 2021-03-16 Italy P.A. Trento     38084 1243 32889 3952 46.06893511 11.12123097 2021-03-17 05:25:07 P.A. Trento, Italy
261142 2020-07-29 Italy P.A. Trento     4970 405 4467 98 46.06893511 11.12123097 2020-07-30 04:35:05 P.A. Trento, Italy
261803 2020-11-25 Italy P.A. Trento     14547 606 11494 2447 46.06893511 11.12123097 2020-11-26 05:27:44 P.A. Trento, Italy
265787 2020-12-10 Italy P.A. Trento     17816 744 14626 2446 46.06893511 11.12123097 2020-12-11 05:26:59 P.A. Trento, Italy
272825 2021-06-10 Italy P.A. Trento     45640 1359 43956 325 46.06893511 11.12123097 2021-06-11 04:23:20 P.A. Trento, Italy
279949 2020-06-28 Italy P.A. Trento     4863 405 4404 54 46.06893511 11.12123097 2020-06-29 04:33:44 P.A. Trento, Italy
280604 2021-02-10 Italy P.A. Trento     29443 1174 25603 2666 46.06893511 11.12123097 2021-02-11 05:23:55 P.A. Trento, Italy
287370 2020-05-17 Italy P.A. Trento     4338 453 3584 301 46.06893511 11.12123097 2020-05-18 02:32:21 P.A. Trento, Italy
287907 2021-01-31 Italy P.A. Trento     27527 1147 23911 2469 46.06893511 11.12123097 2021-02-01 05:22:53 P.A. Trento, Italy
291894 2021-02-17 Italy P.A. Trento     30863 1187 26889 2787 46.06893511 11.12123097 2021-02-18 05:22:58 P.A. Trento, Italy
299310 2021-03-06 Italy P.A. Trento     35651 1220 30372 4059 46.06893511 11.12123097 2021-03-07 05:21:54 P.A. Trento, Italy
303297 2021-06-18 Italy P.A. Trento     45719 1361 44180 178 46.06893511 11.12123097 2021-06-19 04:22:33 P.A. Trento, Italy
307283 2021-01-17 Italy P.A. Trento     25073 1062 21581 2430 46.06893511 11.12123097 2021-01-18 05:22:34 P.A. Trento, Italy
311256 2020-09-23 Italy P.A. Trento     5783 405 4818 560 46.06893511 11.12123097 2020-09-24 04:23:00 P.A. Trento, 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]);