daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Sicilia" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-22 | Italy | Sicilia | 3967 | 286 | 2807 | 874 | 38.11569725 | 13.362356699999998 | 2020-08-23 04:27:48 | Sicilia, Italy | ||
2020-08-23 | Italy | Sicilia | 4002 | 286 | 2813 | 903 | 38.11569725 | 13.362356699999998 | 2020-08-24 04:27:56 | Sicilia, Italy | ||
2020-08-24 | Italy | Sicilia | 4067 | 286 | 2834 | 947 | 38.11569725 | 13.362356699999998 | 2020-08-25 04:28:02 | Sicilia, Italy | ||
2020-08-25 | Italy | Sicilia | 4091 | 286 | 2858 | 947 | 38.11569725 | 13.362356699999998 | 2020-08-26 04:28:11 | Sicilia, Italy | ||
2020-08-26 | Italy | Sicilia | 4124 | 286 | 2858 | 980 | 38.11569725 | 13.362356699999998 | 2020-08-27 04:28:15 | Sicilia, Italy | ||
2020-08-27 | Italy | Sicilia | 4174 | 286 | 2869 | 1019 | 38.11569725 | 13.362356699999998 | 2020-08-28 04:28:11 | Sicilia, Italy | ||
2020-08-28 | Italy | Sicilia | 4228 | 286 | 2884 | 1058 | 38.11569725 | 13.362356699999998 | 2020-08-29 04:28:19 | Sicilia, Italy | ||
2020-08-29 | Italy | Sicilia | 4257 | 286 | 2887 | 1084 | 38.11569725 | 13.362356699999998 | 2020-08-30 04:28:22 | Sicilia, Italy | ||
2020-08-30 | Italy | Sicilia | 4291 | 286 | 2891 | 1114 | 38.11569725 | 13.362356699999998 | 2020-08-31 04:28:27 | Sicilia, Italy | ||
2020-08-31 | Italy | Sicilia | 4317 | 286 | 2906 | 1125 | 38.11569725 | 13.362356699999998 | 2020-09-01 04:28:31 | Sicilia, Italy | ||
2020-09-01 | Italy | Sicilia | 4350 | 287 | 2911 | 1152 | 38.11569725 | 13.362356699999998 | 2020-09-02 04:28:25 | Sicilia, Italy | ||
2020-09-02 | Italy | Sicilia | 4433 | 287 | 2919 | 1227 | 38.11569725 | 13.362356699999998 | 2020-09-03 04:28:22 | Sicilia, Italy | ||
2020-09-03 | Italy | Sicilia | 4487 | 288 | 2947 | 1252 | 38.11569725 | 13.362356699999998 | 2020-09-04 04:28:26 | Sicilia, Italy | ||
2020-09-04 | Italy | Sicilia | 4565 | 288 | 2993 | 1284 | 38.11569725 | 13.362356699999998 | 2020-09-05 04:28:19 | Sicilia, Italy | ||
2020-09-05 | Italy | Sicilia | 4679 | 289 | 3047 | 1343 | 38.11569725 | 13.362356699999998 | 2020-09-06 04:28:33 | Sicilia, Italy | ||
2020-09-06 | Italy | Sicilia | 4716 | 289 | 3093 | 1334 | 38.11569725 | 13.362356699999998 | 2020-09-07 04:28:30 | Sicilia, Italy | ||
2020-09-07 | Italy | Sicilia | 4765 | 289 | 3097 | 1379 | 38.11569725 | 13.362356699999998 | 2020-09-08 04:28:25 | Sicilia, Italy | ||
2020-09-08 | Italy | Sicilia | 4849 | 289 | 3106 | 1454 | 38.11569725 | 13.362356699999998 | 2020-09-09 04:28:48 | Sicilia, Italy | ||
2020-09-09 | Italy | Sicilia | 4926 | 289 | 3110 | 1527 | 38.11569725 | 13.362356699999998 | 2020-09-10 04:29:01 | Sicilia, Italy | ||
2020-09-10 | Italy | Sicilia | 5032 | 289 | 3140 | 1603 | 38.11569725 | 13.362356699999998 | 2020-09-11 04:46:23 | Sicilia, Italy | ||
2020-09-11 | Italy | Sicilia | 5136 | 289 | 3141 | 1706 | 38.11569725 | 13.362356699999998 | 2020-09-12 04:25:05 | Sicilia, Italy | ||
2020-09-12 | Italy | Sicilia | 5180 | 289 | 3144 | 1747 | 38.11569725 | 13.362356699999998 | 2020-09-13 04:30:52 | Sicilia, Italy | ||
2020-09-13 | Italy | Sicilia | 5241 | 290 | 3158 | 1793 | 38.11569725 | 13.3623567 | 2020-09-14 04:26:00 | Sicilia, Italy | ||
2020-09-14 | Italy | Sicilia | 5306 | 292 | 3172 | 1842 | 38.11569725 | 13.362356699999998 | 2020-09-15 03:22:50 | Sicilia, Italy | ||
2020-09-15 | Italy | Sicilia | 5383 | 292 | 3172 | 1919 | 38.11569725 | 13.362356699999998 | 2020-09-16 04:22:53 | Sicilia, Italy | ||
2020-09-16 | Italy | Sicilia | 5473 | 295 | 3190 | 1988 | 38.11569725 | 13.3623567 | 2020-09-17 04:22:00 | Sicilia, Italy | ||
2020-09-17 | Italy | Sicilia | 5569 | 295 | 3231 | 2043 | 38.11569725 | 13.3623567 | 2020-09-18 05:05:00 | Sicilia, Italy | ||
2020-09-18 | Italy | Sicilia | 5748 | 296 | 3295 | 2157 | 38.11569725 | 13.3623567 | 2020-09-19 04:22:00 | Sicilia, Italy | ||
2020-09-19 | Italy | Sicilia | 5846 | 296 | 3318 | 2232 | 38.11569725 | 13.3623567 | 2020-09-20 04:22:00 | Sicilia, Italy | ||
2020-09-20 | Italy | Sicilia | 5962 | 296 | 3350 | 2316 | 38.11569725 | 13.3623567 | 2020-09-21 04:23:00 | Sicilia, Italy | ||
2020-09-21 | Italy | Sicilia | 6037 | 299 | 3390 | 2348 | 38.11569725 | 13.3623567 | 2020-09-22 04:23:00 | Sicilia, Italy | ||
2020-09-22 | Italy | Sicilia | 6145 | 300 | 3455 | 2390 | 38.11569725 | 13.3623567 | 2020-09-23 04:23:00 | Sicilia, Italy | ||
2020-09-23 | Italy | Sicilia | 6234 | 303 | 3519 | 2412 | 38.11569725 | 13.3623567 | 2020-09-24 04:23:00 | Sicilia, Italy | ||
2020-09-24 | Italy | Sicilia | 6359 | 304 | 3594 | 2461 | 38.11569725 | 13.3623567 | 2020-09-25 04:23:00 | Sicilia, Italy | ||
2020-09-25 | Italy | Sicilia | 6466 | 306 | 3630 | 2530 | 38.11569725 | 13.3623567 | 2020-09-26 04:23:00 | Sicilia, Italy | ||
2020-09-26 | Italy | Sicilia | 6576 | 306 | 3687 | 2583 | 38.11569725 | 13.3623567 | 2020-09-27 04:23:00 | Sicilia, Italy | ||
2020-09-27 | Italy | Sicilia | 6683 | 308 | 3716 | 2659 | 38.11569725 | 13.3623567 | 2020-09-28 04:23:00 | Sicilia, Italy | ||
2020-09-28 | Italy | Sicilia | 6785 | 309 | 3733 | 2743 | 38.11569725 | 13.362356699999998 | 2020-09-29 04:23:42 | Sicilia, Italy | ||
2020-09-29 | Italy | Sicilia | 6948 | 310 | 3851 | 2787 | 38.11569725 | 13.362356699999998 | 2020-09-30 04:23:33 | Sicilia, Italy | ||
2020-09-30 | Italy | Sicilia | 7118 | 311 | 3941 | 2866 | 38.11569725 | 13.362356699999998 | 2020-10-01 04:23:42 | Sicilia, Italy | ||
2020-10-01 | Italy | Sicilia | 7274 | 312 | 4026 | 2936 | 38.11569725 | 13.362356699999998 | 2020-10-02 04:23:51 | Sicilia, Italy | ||
2020-10-02 | Italy | Sicilia | 7414 | 314 | 4052 | 3048 | 38.11569725 | 13.362356699999998 | 2020-10-03 04:23:40 | Sicilia, Italy | ||
2020-10-03 | Italy | Sicilia | 7596 | 317 | 4108 | 3171 | 38.11569725 | 13.362356699999998 | 2020-10-04 04:23:44 | Sicilia, Italy | ||
2020-10-04 | Italy | Sicilia | 7681 | 319 | 4115 | 3247 | 38.11569725 | 13.362356699999998 | 2020-10-05 04:23:33 | Sicilia, Italy | ||
2020-10-05 | Italy | Sicilia | 7809 | 321 | 4130 | 3358 | 38.11569725 | 13.362356699999998 | 2020-10-06 04:23:33 | Sicilia, Italy | ||
2020-10-06 | Italy | Sicilia | 8007 | 322 | 4237 | 3448 | 38.11569725 | 13.362356699999998 | 2020-10-07 04:23:40 | Sicilia, Italy | ||
2020-10-07 | Italy | Sicilia | 8220 | 326 | 4345 | 3549 | 38.11569725 | 13.362356699999998 | 2020-10-08 04:23:56 | Sicilia, Italy | ||
2020-10-08 | Italy | Sicilia | 8479 | 329 | 4454 | 3696 | 38.11569725 | 13.362356699999998 | 2020-10-09 04:23:59 | Sicilia, Italy | ||
2020-10-09 | Italy | Sicilia | 8712 | 333 | 4478 | 3901 | 38.11569725 | 13.362356699999998 | 2020-10-10 04:23:57 | Sicilia, Italy | ||
2020-10-10 | Italy | Sicilia | 8997 | 335 | 4519 | 4143 | 38.11569725 | 13.362356699999998 | 2020-10-11 04:23:46 | Sicilia, Italy | ||
2020-10-11 | Italy | Sicilia | 9294 | 336 | 4557 | 4401 | 38.11569725 | 13.362356699999998 | 2020-10-12 04:23:45 | Sicilia, Italy | ||
2020-10-12 | Italy | Sicilia | 9592 | 339 | 4571 | 4682 | 38.11569725 | 13.362356699999998 | 2020-10-13 04:24:02 | Sicilia, Italy | ||
2020-10-13 | Italy | Sicilia | 9926 | 341 | 4708 | 4877 | 38.11569725 | 13.362356699999998 | 2020-10-14 04:24:05 | Sicilia, Italy | ||
2020-10-14 | Italy | Sicilia | 10292 | 343 | 4762 | 5187 | 38.11569725 | 13.362356699999998 | 2020-10-15 04:24:28 | Sicilia, Italy | ||
2020-10-15 | Italy | Sicilia | 10691 | 350 | 4854 | 5487 | 38.11569725 | 13.362356699999998 | 2020-10-16 04:24:01 | Sicilia, Italy | ||
2020-10-16 | Italy | Sicilia | 11269 | 360 | 4975 | 5934 | 38.11569725 | 13.362356699999998 | 2020-10-17 04:24:12 | Sicilia, Italy | ||
2020-10-17 | Italy | Sicilia | 11744 | 362 | 5101 | 6281 | 38.11569725 | 13.362356699999998 | 2020-10-18 04:24:25 | Sicilia, Italy | ||
2020-10-18 | Italy | Sicilia | 12292 | 365 | 5137 | 6790 | 38.11569725 | 13.362356699999998 | 2020-10-19 04:24:16 | Sicilia, Italy | ||
2020-10-19 | Italy | Sicilia | 12654 | 368 | 5267 | 7019 | 38.11569725 | 13.362356699999998 | 2020-10-20 04:24:22 | Sicilia, Italy | ||
2020-10-20 | Italy | Sicilia | 13228 | 378 | 5353 | 7497 | 38.11569725 | 13.362356699999998 | 2020-10-21 04:24:14 | Sicilia, Italy | ||
2020-10-21 | Italy | Sicilia | 13790 | 389 | 5551 | 7850 | 38.11569725 | 13.362356699999998 | 2020-10-22 04:24:27 | Sicilia, Italy | ||
2020-10-22 | Italy | Sicilia | 14586 | 397 | 5649 | 8540 | 38.11569725 | 13.362356699999998 | 2020-10-23 04:24:46 | Sicilia, Italy | ||
2020-10-23 | Italy | Sicilia | 15316 | 408 | 5772 | 9136 | 38.11569725 | 13.362356699999998 | 2020-10-24 04:24:46 | Sicilia, Italy | ||
2020-10-24 | Italy | Sicilia | 16202 | 417 | 5896 | 9889 | 38.11569725 | 13.362356699999998 | 2020-10-25 04:24:36 | Sicilia, Italy | ||
2020-10-25 | Italy | Sicilia | 16897 | 428 | 5914 | 10555 | 38.11569725 | 13.362356699999998 | 2020-10-26 04:25:02 | Sicilia, Italy | ||
2020-10-26 | Italy | Sicilia | 17465 | 439 | 6081 | 10945 | 38.11569725 | 13.362356699999998 | 2020-10-27 04:24:45 | Sicilia, Italy | ||
2020-10-27 | Italy | Sicilia | 18325 | 449 | 6142 | 11734 | 38.11569725 | 13.362356699999998 | 2020-10-28 04:24:39 | Sicilia, Italy | ||
2020-10-28 | Italy | Sicilia | 19033 | 459 | 6386 | 12188 | 38.11569725 | 13.362356699999998 | 2020-10-29 04:24:49 | Sicilia, Italy | ||
2020-10-29 | Italy | Sicilia | 19822 | 472 | 6605 | 12745 | 38.11569725 | 13.362356699999998 | 2020-10-30 04:24:49 | Sicilia, Italy | ||
2020-10-30 | Italy | Sicilia | 20806 | 484 | 6758 | 13564 | 38.11569725 | 13.362356699999998 | 2020-10-31 04:24:44 | Sicilia, Italy | ||
2020-10-31 | Italy | Sicilia | 21758 | 502 | 6814 | 14442 | 38.11569725 | 13.362356699999998 | 2020-11-01 04:36:19 | Sicilia, Italy | ||
2020-11-01 | Italy | Sicilia | 22853 | 518 | 7011 | 15324 | 38.11569725 | 13.362356699999998 | 2020-11-02 05:25:04 | Sicilia, Italy | ||
2020-11-02 | Italy | Sicilia | 23877 | 536 | 7277 | 16064 | 38.11569725 | 13.362356699999998 | 2020-11-03 06:00:16 | Sicilia, Italy | ||
2020-11-03 | Italy | Sicilia | 24925 | 550 | 7569 | 16806 | 38.11569725 | 13.362356699999998 | 2020-11-04 05:25:09 | Sicilia, Italy | ||
2020-11-04 | Italy | Sicilia | 26080 | 569 | 7893 | 17618 | 38.11569725 | 13.362356699999998 | 2020-11-05 06:05:03 | Sicilia, Italy | ||
2020-11-05 | Italy | Sicilia | 27402 | 594 | 8282 | 18526 | 38.11569725 | 13.362356699999998 | 2020-11-06 05:24:55 | Sicilia, Italy | ||
2020-11-06 | Italy | Sicilia | 28825 | 628 | 8684 | 19513 | 38.11569725 | 13.362356699999998 | 2020-11-07 05:24:52 | Sicilia, Italy | ||
2020-11-07 | Italy | Sicilia | 30188 | 663 | 8788 | 20737 | 38.11569725 | 13.362356699999998 | 2020-11-08 05:24:56 | Sicilia, Italy | ||
2020-11-08 | Italy | Sicilia | 31271 | 676 | 9128 | 21467 | 38.11569725 | 13.362356699999998 | 2020-11-09 05:25:45 | Sicilia, Italy | ||
2020-11-09 | Italy | Sicilia | 32294 | 703 | 9652 | 21939 | 38.11569725 | 13.362356699999998 | 2020-11-10 05:40:07 | Sicilia, Italy | ||
2020-11-10 | Italy | Sicilia | 33495 | 735 | 9928 | 22832 | 38.11569725 | 13.362356699999998 | 2020-11-11 05:25:30 | Sicilia, Italy | ||
2020-11-11 | Italy | Sicilia | 34982 | 762 | 10656 | 23564 | 38.11569725 | 13.362356699999998 | 2020-11-12 05:25:55 | Sicilia, Italy | ||
2020-11-12 | Italy | Sicilia | 36674 | 802 | 10958 | 24914 | 38.11569725 | 13.362356699999998 | 2020-11-13 05:25:30 | Sicilia, Italy | ||
2020-11-13 | Italy | Sicilia | 38381 | 837 | 11258 | 26286 | 38.11569725 | 13.362356699999998 | 2020-11-14 05:25:37 | Sicilia, Italy | ||
2020-11-14 | Italy | Sicilia | 40110 | 860 | 11444 | 27806 | 38.11569725 | 13.362356699999998 | 2020-11-15 05:26:53 | Sicilia, Italy | ||
2020-11-15 | Italy | Sicilia | 41532 | 896 | 11829 | 28807 | 38.11569725 | 13.362356699999998 | 2020-11-16 05:25:57 | Sicilia, Italy | ||
2020-11-16 | Italy | Sicilia | 42993 | 932 | 12296 | 29765 | 38.11569725 | 13.362356699999998 | 2020-11-17 05:25:54 | Sicilia, Italy | ||
2020-11-17 | Italy | Sicilia | 44691 | 971 | 12964 | 30756 | 38.11569725 | 13.362356699999998 | 2020-11-18 05:40:31 | Sicilia, Italy | ||
2020-11-18 | Italy | Sicilia | 46528 | 1015 | 13411 | 32102 | 38.11569725 | 13.362356699999998 | 2020-11-19 05:25:23 | Sicilia, Italy | ||
2020-11-19 | Italy | Sicilia | 48399 | 1055 | 13763 | 33581 | 38.11569725 | 13.362356699999998 | 2020-11-20 05:26:28 | Sicilia, Italy | ||
2020-11-20 | Italy | Sicilia | 50033 | 1098 | 14179 | 34756 | 38.11569725 | 13.362356699999998 | 2020-11-21 05:25:51 | Sicilia, Italy | ||
2020-11-21 | Italy | Sicilia | 51871 | 1141 | 14489 | 36241 | 38.11569725 | 13.362356699999998 | 2020-11-22 05:25:45 | Sicilia, Italy | ||
2020-11-22 | Italy | Sicilia | 53129 | 1186 | 14781 | 37162 | 38.11569725 | 13.362356699999998 | 2020-11-23 05:25:26 | Sicilia, Italy | ||
2020-11-23 | Italy | Sicilia | 54378 | 1227 | 15238 | 37913 | 38.11569725 | 13.362356699999998 | 2020-11-24 05:27:31 | Sicilia, Italy | ||
2020-11-24 | Italy | Sicilia | 55684 | 1275 | 16210 | 38199 | 38.11569725 | 13.362356699999998 | 2020-11-25 05:27:20 | Sicilia, Italy | ||
2020-11-25 | Italy | Sicilia | 57001 | 1322 | 17359 | 38320 | 38.11569725 | 13.362356699999998 | 2020-11-26 05:27:44 | Sicilia, Italy | ||
2020-11-26 | Italy | Sicilia | 58769 | 1371 | 18890 | 38508 | 38.11569725 | 13.362356699999998 | 2020-11-27 05:26:53 | Sicilia, Italy | ||
2020-11-27 | Italy | Sicilia | 60335 | 1418 | 19834 | 39083 | 38.11569725 | 13.362356699999998 | 2020-11-28 05:25:50 | Sicilia, Italy | ||
2020-11-28 | Italy | Sicilia | 61524 | 1461 | 20181 | 39882 | 38.11569725 | 13.362356699999998 | 2020-11-29 05:25:55 | Sicilia, Italy | ||
2020-11-29 | Italy | Sicilia | 62548 | 1506 | 20558 | 40484 | 38.11569725 | 13.362356699999998 | 2020-11-30 05:26:13 | Sicilia, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;