daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

545 rows where country_or_region = "Italy" sorted by confirmed

View and edit SQL

country_or_region

  • Italy · 545
day country_or_region province_or_state admin2 fips confirmed ▼ deaths recovered active latitude longitude last_update combined_key
2020-02-01 Italy       2 0 0       1/31/2020 8:15  
2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-04 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-05 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-06 Italy       2 0 0       2020-01-31T08:15:53  
2020-01-31 Italy       2 0 0       1/31/2020 23:59  
2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-17 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-10 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-13 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-11 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-18 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-16 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-09 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-15 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-07 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-08 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-21 Italy       20 1 0       2020-02-21T23:33:06  
2020-02-22 Italy       62 2 1       2020-02-22T23:43:02  
2020-02-23 Italy       155 3 2       2020-02-23T23:43:02  
2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
2020-05-14 Italy Basilicata     389 27 235 127 40.63947052 15.80514834 2020-05-15 02:33:02 Basilicata, Italy
2020-05-15 Italy Basilicata     389 27 242 120 40.63947052 15.80514834 2020-05-16 02:32:19 Basilicata, Italy
2020-05-16 Italy Basilicata     390 27 250 113 40.63947052 15.80514834 2020-05-17 02:32:32 Basilicata, Italy
2020-05-17 Italy Basilicata     392 27 261 104 40.63947052 15.80514834 2020-05-18 02:32:21 Basilicata, Italy
2020-05-18 Italy Basilicata     392 27 272 93 40.63947052 15.80514834 2020-05-19 02:32:18 Basilicata, Italy
2020-05-19 Italy Basilicata     393 27 282 84 40.63947052 15.80514834 2020-05-20 02:32:19 Basilicata, Italy
2020-05-20 Italy Basilicata     393 27 293 73 40.63947052 15.80514834 2020-05-21 02:32:48 Basilicata, Italy
2020-05-21 Italy Basilicata     394 27 307 60 40.63947052 15.80514834 2020-05-22 02:36:51 Basilicata, Italy
2020-05-22 Italy Basilicata     394 27 318 49 40.63947052 15.80514834 2020-05-23 02:32:42 Basilicata, Italy
2020-05-23 Italy Basilicata     398 27 330 41 40.63947052 15.80514834 2020-05-24 02:32:43 Basilicata, Italy
2020-05-28 Italy Basilicata     399 27 338 34 40.63947052 15.80514834 2020-05-29 02:32:50 Basilicata, Italy
2020-05-29 Italy Basilicata     399 27 339 33 40.63947052 15.80514834 2020-05-30 02:32:48 Basilicata, Italy
2020-06-01 Italy Basilicata     399 27 344 28 40.63947052 15.80514834 2020-06-02 02:33:08 Basilicata, Italy
2020-05-24 Italy Basilicata     399 27 333 39 40.63947052 15.80514834 2020-05-25 02:32:44 Basilicata, Italy
2020-06-03 Italy Basilicata     399 27 349 23 40.63947052 15.80514834 2020-06-04 02:33:14 Basilicata, Italy
2020-05-25 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-26 02:32:35 Basilicata, Italy
2020-05-27 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-28 02:32:31 Basilicata, Italy
2020-05-31 Italy Basilicata     399 27 343 29 40.63947052 15.80514834 2020-06-01 02:32:46 Basilicata, Italy
2020-06-02 Italy Basilicata     399 27 348 24 40.63947052 15.80514834 2020-06-03 02:33:13 Basilicata, Italy
2020-05-30 Italy Basilicata     399 27 341 31 40.63947052 15.80514834 2020-05-31 02:32:45 Basilicata, Italy
2020-05-26 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-27 02:32:31 Basilicata, Italy
2020-05-14 Italy Molise     403 22 152 229 41.55774754 14.65916051 2020-05-15 02:33:02 Molise, Italy
2020-05-15 Italy Molise     407 22 158 227 41.55774754 14.65916051 2020-05-16 02:32:19 Molise, Italy
2020-05-16 Italy Molise     410 22 173 215 41.55774754 14.65916051 2020-05-17 02:32:32 Molise, Italy
2020-05-17 Italy Molise     411 22 173 216 41.55774754 14.65916051 2020-05-18 02:32:21 Molise, Italy
2020-05-19 Italy Molise     422 22 188 212 41.55774754 14.65916051 2020-05-20 02:32:19 Molise, Italy
2020-05-20 Italy Molise     422 22 202 198 41.55774754 14.65916051 2020-05-21 02:32:48 Molise, Italy
2020-05-18 Italy Molise     422 22 183 217 41.55774754 14.65916051 2020-05-19 02:32:18 Molise, Italy
2020-05-21 Italy Molise     423 22 207 194 41.55774754 14.65916051 2020-05-22 02:36:51 Molise, Italy
2020-05-22 Italy Molise     426 22 220 184 41.55774754 14.65916051 2020-05-23 02:32:42 Molise, Italy
2020-05-23 Italy Molise     431 22 220 189 41.55774754 14.65916051 2020-05-24 02:32:43 Molise, Italy
2020-05-24 Italy Molise     432 22 227 183 41.55774754 14.65916051 2020-05-25 02:32:44 Molise, Italy
2020-05-25 Italy Molise     432 22 233 177 41.55774754 14.65916051 2020-05-26 02:32:35 Molise, Italy
2020-05-26 Italy Molise     432 22 236 174 41.55774754 14.65916051 2020-05-27 02:32:31 Molise, Italy
2020-05-27 Italy Molise     434 22 246 166 41.55774754 14.65916051 2020-05-28 02:32:31 Molise, Italy
2020-05-28 Italy Molise     435 22 250 163 41.55774754 14.65916051 2020-05-29 02:32:50 Molise, Italy
2020-05-29 Italy Molise     436 22 252 162 41.55774754 14.65916051 2020-05-30 02:32:48 Molise, Italy
2020-06-01 Italy Molise     436 22 279 135 41.55774754 14.65916051 2020-06-02 02:33:08 Molise, Italy
2020-06-03 Italy Molise     436 22 287 127 41.55774754 14.65916051 2020-06-04 02:33:14 Molise, Italy
2020-05-31 Italy Molise     436 22 269 145 41.55774754 14.65916051 2020-06-01 02:32:46 Molise, Italy
2020-06-02 Italy Molise     436 22 281 133 41.55774754 14.65916051 2020-06-03 02:33:13 Molise, Italy
2020-05-30 Italy Molise     436 22 258 156 41.55774754 14.65916051 2020-05-31 02:32:45 Molise, Italy
2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
2020-05-14 Italy Calabria     1143 95 524 524 38.90597598 16.59440194 2020-05-15 02:33:02 Calabria, Italy
2020-05-15 Italy Calabria     1144 95 544 505 38.90597598 16.59440194 2020-05-16 02:32:19 Calabria, Italy
2020-05-17 Italy Calabria     1151 95 634 422 38.90597598 16.59440194 2020-05-18 02:32:21 Calabria, Italy
2020-05-18 Italy Calabria     1151 95 655 401 38.90597598 16.59440194 2020-05-19 02:32:18 Calabria, Italy
2020-05-16 Italy Calabria     1151 95 582 474 38.90597598 16.59440194 2020-05-17 02:32:32 Calabria, Italy
2020-05-19 Italy Calabria     1153 95 676 382 38.90597598 16.59440194 2020-05-20 02:32:19 Calabria, Italy
2020-05-21 Italy Calabria     1156 96 734 326 38.90597598 16.59440194 2020-05-22 02:36:51 Calabria, Italy
2020-05-20 Italy Calabria     1156 96 707 353 38.90597598 16.59440194 2020-05-21 02:32:48 Calabria, Italy
2020-05-23 Italy Calabria     1157 96 773 288 38.90597598 16.59440194 2020-05-24 02:32:43 Calabria, Italy
2020-05-24 Italy Calabria     1157 96 786 275 38.90597598 16.59440194 2020-05-25 02:32:44 Calabria, Italy
2020-05-22 Italy Calabria     1157 96 759 302 38.90597598 16.59440194 2020-05-23 02:32:42 Calabria, Italy
2020-05-25 Italy Calabria     1157 96 797 264 38.90597598 16.59440194 2020-05-26 02:32:35 Calabria, Italy
2020-05-26 Italy Calabria     1157 96 823 238 38.90597598 16.59440194 2020-05-27 02:32:31 Calabria, Italy
2020-05-28 Italy Calabria     1158 96 892 170 38.90597598 16.59440194 2020-05-29 02:32:50 Calabria, Italy
2020-05-29 Italy Calabria     1158 97 902 159 38.90597598 16.59440194 2020-05-30 02:32:48 Calabria, Italy
2020-06-01 Italy Calabria     1158 97 926 135 38.90597598 16.59440194 2020-06-02 02:33:08 Calabria, Italy
2020-06-03 Italy Calabria     1158 97 951 110 38.90597598 16.59440194 2020-06-04 02:33:14 Calabria, Italy
2020-05-27 Italy Calabria     1158 96 872 190 38.90597598 16.59440194 2020-05-28 02:32:31 Calabria, Italy
2020-05-31 Italy Calabria     1158 97 917 144 38.90597598 16.59440194 2020-06-01 02:32:46 Calabria, Italy
2020-06-02 Italy Calabria     1158 97 949 112 38.90597598 16.59440194 2020-06-03 02:33:13 Calabria, Italy
2020-05-30 Italy Calabria     1158 97 910 151 38.90597598 16.59440194 2020-05-31 02:32:45 Calabria, Italy
2020-05-14 Italy Valle d'Aosta     1166 141 945 80 45.73750286 7.320149366 2020-05-15 02:33:02 Valle d'Aosta, Italy
2020-05-15 Italy Valle d'Aosta     1172 142 953 77 45.73750286 7.320149366 2020-05-16 02:32:19 Valle d'Aosta, Italy
2020-05-17 Italy Valle d'Aosta     1173 143 962 68 45.73750286 7.320149366 2020-05-18 02:32:21 Valle d'Aosta, Italy
2020-05-16 Italy Valle d'Aosta     1173 142 956 75 45.73750286 7.320149366 2020-05-17 02:32:32 Valle d'Aosta, Italy
2020-05-18 Italy Valle d'Aosta     1174 143 971 60 45.73750286 7.320149366 2020-05-19 02:32:18 Valle d'Aosta, Italy
2020-05-19 Italy Valle d'Aosta     1175 143 983 49 45.73750286 7.320149366 2020-05-20 02:32:19 Valle d'Aosta, Italy
2020-05-20 Italy Valle d'Aosta     1175 143 986 46 45.73750286 7.320149366 2020-05-21 02:32:48 Valle d'Aosta, Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 3038.857ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette