johns_hopkins_csse_daily_reports

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

545 rows where country_or_region = "Italy" sorted by confirmed descending

View and edit SQL

Suggested facets: latitude, last_update (date)

country_or_region

  • Italy · 545
Link rowid day country_or_region province_or_state admin2 fips confirmed ▲ deaths recovered active latitude longitude last_update combined_key
167865 2020-05-13 Italy       222104 31106 112541 78457 41.87194 12.56738 2020-05-14 03:32:28 Italy
226653 2020-05-12 Italy       221216 30911 109039 81266 41.87194 12.56738 2020-05-13 03:32:26 Italy
9732 2020-05-11 Italy       219814 30739 106587 82488 41.87194 12.56738 2020-05-12 03:32:27 Italy
214130 2020-05-10 Italy       219070 30560 105186 83324 41.87194 12.56738 2020-05-11 02:32:30 Italy
229885 2020-05-09 Italy       218268 30395 103031 84842 41.87194 12.56738 2020-05-10 02:32:30 Italy
49912 2020-05-08 Italy       217185 30201 99023 87961 41.87194 12.56738 2020-05-09 02:32:35 Italy
161604 2020-05-07 Italy       215858 29958 96276 89624 41.87194 12.56738 2020-05-08 02:32:32 Italy
129794 2020-05-06 Italy       214457 29684 93245 91528 41.87194 12.56738 2020-05-07 02:32:28 Italy
90544 2020-05-05 Italy       213013 29315 85231 98467 41.87194 12.56738 2020-05-06 02:32:31 Italy
210821 2020-05-04 Italy       211938 29079 82879 99980 41.87194 12.56738 2020-05-05 02:32:34 Italy
25989 2020-05-03 Italy       210717 28884 81654 100179 41.87194 12.56738 2020-05-04 02:32:28 Italy
53194 2020-05-02 Italy       209328 28710 79914 100704 41.87194 12.56738 2020-05-03 02:32:28 Italy
123506 2020-05-01 Italy       207428 28236 78249 100943 41.87194 12.56738 2020-05-02 02:32:27 Italy
3077 2020-04-30 Italy       205463 27967 75945 101551 41.87194 12.56738 2020-05-01 02:32:28 Italy
233338 2020-04-29 Italy       203591 27682 71252 104657 41.87194 12.56738 2020-04-30 02:32:27 Italy
136342 2020-04-28 Italy       201505 27359 68941 105205 41.87194 12.56738 2020-04-29 02:32:29 Italy
18886 2020-04-27 Italy       199414 26977 66624 105813 41.87194 12.56738 2020-04-28 02:30:32 Italy
171001 2020-04-26 Italy       197675 26644 64928 106103 41.87194 12.56738 2020-04-27 02:30:33 Italy
96525 2020-04-25 Italy       195351 26384 63120 105847 41.87194 12.56738 2020-04-26 02:30:31 Italy
236458 2020-04-24 Italy       192994 25969 60498 106527 41.87194 12.56738 2020-04-25 06:30:33 Italy
32856 2020-04-23 Italy       189973 25549 57576 106848 41.87194 12.56738 2020-04-24 03:30:31 Italy
73375 2020-04-22 Italy       187327 25085 54543 107699 41.87194 12.56738 2020-04-22 23:30:32 Italy
181187 2020-04-21 Italy       183957 24648 51600 107709 41.87194 12.56738 2020-04-21 23:30:30 Italy
15742 2020-04-20 Italy       181228 24114 48877 108237 41.87194 12.56738 2020-04-20 23:36:27 Italy
220113 2020-04-19 Italy       178972 23660 47055 108257 41.87194 12.56738 2020-04-19 23:40:41 Italy
83651 2020-04-18 Italy       175925 23227 44927 107771 41.87194 12.56738 2020-04-18 22:32:28 Italy
144910 2020-04-17 Italy       172434 22745 42727 106962 41.87194 12.56738 2020-04-17 23:30:32 Italy
80067 2020-04-16 Italy       168941 22170 40164 106607 41.87194 12.56738 2020-04-16 23:30:31 Italy
59787 2020-04-15 Italy       165155 21645 38092 105418 41.87194 12.56738 2020-04-15 22:56:32 Italy
113154 2020-04-14 Italy       162488 21067 37130 104291 41.87194 12.56738 2020-04-14 23:33:12 Italy
126508 2020-04-13 Italy       159516 20465 35435 103616 41.87194 12.56738 2020-04-13 23:07:34 Italy
76568 2020-04-12 Italy       156363 19899 34211 102253 41.87194 12.56738 2020-04-12 23:17:00 Italy
203982 2020-04-11 Italy       152271 19468 32534 100269 41.87194 12.56738 2020-04-11 22:45:13 Italy
154987 2020-04-10 Italy       147577 18849 30455 98273 41.87194 12.56738 2020-04-10 22:53:48 Italy
217042 2020-04-09 Italy       143626 18279 28470 96877 41.87194 12.56738 2020-04-09 23:02:19 Italy
164488 2020-04-08 Italy       139422 17669 26491 95262 41.87194 12.56738 2020-04-08 22:51:39 Italy
39614 2020-04-07 Italy       135586 17127 24392 94067 41.87194 12.56738 2020-04-07 23:04:29 Italy
141865 2020-04-06 Italy       132547 16523 22837 93187 41.87194 12.56738 4/6/20 23:21 Italy
186794 2020-04-05 Italy       128948 15887 21815 91246 41.87194 12.56738 2020-04-05 23:06:26 Italy
99494 2020-04-04 Italy       124632 15362 20996 88274 41.87194 12.56738 4/4/20 23:34 Italy
93172 2020-04-03 Italy       119827 14681 19758 85388 41.87194 12.56738 2020-04-03 22:46:20 Italy
12664 2020-04-02 Italy       115242 13915 18278 83049 41.87194 12.56738 4/2/20 23:25 Italy
138914 2020-04-01 Italy       110574 13155 16847 80572 41.87194 12.56738 2020-04-01 21:58:34 Italy
183626 2020-03-31 Italy       105792 12428 15729 77635 41.87194 12.56738 2020-03-31 23:43:43 Italy
63232 2020-03-30 Italy       101739 11591 14620 75528 41.87194 12.56738 3/30/20 22:52 Italy
46689 2020-03-29 Italy       97689 10779 13030 73880 41.87194 12.56738 3/29/20 23:08 Italy
174700 2020-03-28 Italy       92472 10023 12384 70065 41.87194 12.56738 3/28/20 23:05 Italy
102831 2020-06-03 Italy Lombardia     89442 16172 53046 20224 45.46679409 9.190347404 2020-06-04 02:33:14 Lombardia, Italy
200714 2020-06-02 Italy Lombardia     89205 16143 52807 20255 45.46679409 9.190347404 2020-06-03 02:33:13 Lombardia, Italy
69972 2020-06-01 Italy Lombardia     89018 16131 52026 20861 45.46679409 9.190347404 2020-06-02 02:33:08 Lombardia, Italy
197130 2020-05-31 Italy Lombardia     88968 16112 51860 20996 45.46679409 9.190347404 2020-06-01 02:32:46 Lombardia, Italy
207333 2020-05-30 Italy Lombardia     88758 16079 50870 21809 45.46679409 9.190347404 2020-05-31 02:32:45 Lombardia, Italy
42889 2020-05-29 Italy Lombardia     88537 16012 49842 22683 45.46679409 9.190347404 2020-05-30 02:32:48 Lombardia, Italy
36511 2020-05-28 Italy Lombardia     88183 15974 49296 22913 45.46679409 9.190347404 2020-05-29 02:32:50 Lombardia, Italy
193653 2020-05-27 Italy Lombardia     87801 15954 47810 24037 45.46679409 9.190347404 2020-05-28 02:32:31 Lombardia, Italy
243249 2020-05-26 Italy Lombardia     87417 15896 47044 24477 45.46679409 9.190347404 2020-05-27 02:32:31 Lombardia, Italy
190239 2020-05-25 Italy Lombardia     87258 15874 46169 25215 45.46679409 9.190347404 2020-05-26 02:32:35 Lombardia, Italy
87138 2020-05-24 Italy Lombardia     87110 15840 45656 25614 45.46679409 9.190347404 2020-05-25 02:32:44 Lombardia, Italy
22425 2020-05-23 Italy Lombardia     86825 15840 45355 25630 45.46679409 9.190347404 2020-05-24 02:32:43 Lombardia, Italy
239948 2020-03-27 Italy       86498 9134 10950 66414 41.87194 12.56738 2020-03-27 23:23:03 Italy
116359 2020-05-22 Italy Lombardia     86384 15784 44667 25933 45.46679409 9.190347404 2020-05-23 02:32:42 Lombardia, Italy
109858 2020-05-21 Italy Lombardia     86091 15727 43649 26715 45.46679409 9.190347404 2020-05-22 02:36:51 Lombardia, Italy
158184 2020-05-20 Italy Lombardia     85775 15662 43442 26671 45.46679409 9.190347404 2020-05-21 02:32:48 Lombardia, Italy
151769 2020-05-19 Italy Lombardia     85481 15597 42593 27291 45.46679409 9.190347404 2020-05-20 02:32:19 Lombardia, Italy
177849 2020-05-18 Italy Lombardia     85019 15543 42403 27073 45.46679409 9.190347404 2020-05-19 02:32:18 Lombardia, Italy
106507 2020-05-17 Italy Lombardia     84844 15519 41895 27430 45.46679409 9.190347404 2020-05-18 02:32:21 Lombardia, Italy
223264 2020-05-16 Italy Lombardia     84518 15450 41389 27679 45.46679409 9.190347404 2020-05-17 02:32:32 Lombardia, Italy
133026 2020-05-15 Italy Lombardia     84119 15411 40962 27746 45.46679409 9.190347404 2020-05-16 02:32:19 Lombardia, Italy
56608 2020-05-14 Italy Lombardia     83820 15296 38568 29956 45.46679409 9.190347404 2020-05-15 02:33:02 Lombardia, Italy
6506 2020-03-26 Italy       80589 8215 10361 62013 41.87194 12.56738 2020-03-26 23:48:18 Italy
148339 2020-03-25 Italy       74386 7503 9362 57521 41.87194 12.56738 2020-03-25 23:33:04 Italy
120330 2020-03-24 Italy       69176 6820 8326 54030 41.87194 12.56738 2020-03-24 23:37:15 Italy
66652 2020-03-23 Italy       63927 6077 7432 50418 41.87194 12.56738 2020-03-23 23:19:21 Italy
29323 2020-03-22 Italy       59138 5476 7024 46638 41.87194 12.56738 3/22/20 23:45 Italy
183722 2020-03-21 Italy       53578 4825 6072   41.8719 12.5674 2020-03-21T17:43:03  
33041 2020-03-20 Italy       47021 4032 4440   41.8719 12.5674 2020-03-20T17:43:03  
9901 2020-03-19 Italy       41035 3405 4440   41.8719 12.5674 2020-03-19T17:43:03  
229987 2020-03-18 Italy       35713 2978 4025   41.8719 12.5674 2020-03-18T17:33:05  
83752 2020-03-17 Italy       31506 2503 2941   41.8719 12.5674 2020-03-17T18:33:02  
102920 2020-06-03 Italy Piemonte     30734 3898 22150 4686 45.0732745 7.680687483 2020-06-04 02:33:14 Piemonte, Italy
200803 2020-06-02 Italy Piemonte     30715 3884 22003 4828 45.0732745 7.680687483 2020-06-03 02:33:13 Piemonte, Italy
70061 2020-06-01 Italy Piemonte     30658 3876 21720 5062 45.0732745 7.680687483 2020-06-02 02:33:08 Piemonte, Italy
197199 2020-05-31 Italy Piemonte     30637 3867 21609 5161 45.0732745 7.680687483 2020-06-01 02:32:46 Piemonte, Italy
207402 2020-05-30 Italy Piemonte     30583 3858 21435 5290 45.0732745 7.680687483 2020-05-31 02:32:45 Piemonte, Italy
42958 2020-05-29 Italy Piemonte     30501 3851 20992 5658 45.0732745 7.680687483 2020-05-30 02:32:48 Piemonte, Italy
36580 2020-05-28 Italy Piemonte     30445 3838 20535 6072 45.0732745 7.680687483 2020-05-29 02:32:50 Piemonte, Italy
193703 2020-05-27 Italy Piemonte     30387 3828 20095 6464 45.0732745 7.680687483 2020-05-28 02:32:31 Piemonte, Italy
243299 2020-05-26 Italy Piemonte     30314 3812 19561 6941 45.0732745 7.680687483 2020-05-27 02:32:31 Piemonte, Italy
190289 2020-05-25 Italy Piemonte     30228 3798 18934 7496 45.0732745 7.680687483 2020-05-26 02:32:35 Piemonte, Italy
87188 2020-05-24 Italy Piemonte     30180 3783 18694 7703 45.0732745 7.680687483 2020-05-25 02:32:44 Piemonte, Italy
22475 2020-05-23 Italy Piemonte     30137 3771 18341 8025 45.0732745 7.680687483 2020-05-24 02:32:43 Piemonte, Italy
116409 2020-05-22 Italy Piemonte     30077 3757 17868 8452 45.0732745 7.680687483 2020-05-23 02:32:42 Piemonte, Italy
109908 2020-05-21 Italy Piemonte     29990 3742 17538 8710 45.0732745 7.680687483 2020-05-22 02:36:51 Piemonte, Italy
158234 2020-05-20 Italy Piemonte     29885 3718 17016 9151 45.0732745 7.680687483 2020-05-21 02:32:48 Piemonte, Italy
151797 2020-05-19 Italy Piemonte     29727 3679 16413 9635 45.0732745 7.680687483 2020-05-20 02:32:19 Piemonte, Italy
177877 2020-05-18 Italy Piemonte     29619 3632 16113 9874 45.0732745 7.680687483 2020-05-19 02:32:18 Piemonte, Italy
106535 2020-05-17 Italy Piemonte     29547 3612 15696 10239 45.0732745 7.680687483 2020-05-18 02:32:21 Piemonte, Italy
223292 2020-05-16 Italy Piemonte     29483 3594 15187 10702 45.0732745 7.680687483 2020-05-17 02:32:32 Piemonte, Italy
133054 2020-05-15 Italy Piemonte     29346 3557 14676 11113 45.0732745 7.680687483 2020-05-16 02:32:19 Piemonte, Italy
56636 2020-05-14 Italy Piemonte     29209 3493 13825 11891 45.0732745 7.680687483 2020-05-15 02:33:02 Piemonte, 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
);
Powered by Datasette · Query took 2245.425ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette