johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Sicilia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026346 | 1026346 | 2020-10-17 | Italy | Sicilia | 11744 | 362 | 5101 | 6281 | 38.11569725 | 13.362356699999998 | 2020-10-18 04:24:25 | Sicilia, Italy | ||
2856841 | 2856841 | 2020-10-16 | Italy | Sicilia | 11269 | 360 | 4975 | 5934 | 38.11569725 | 13.362356699999998 | 2020-10-17 04:24:12 | Sicilia, Italy | ||
786371 | 786371 | 2020-10-15 | Italy | Sicilia | 10691 | 350 | 4854 | 5487 | 38.11569725 | 13.362356699999998 | 2020-10-16 04:24:01 | Sicilia, Italy | ||
79082 | 79082 | 2020-10-14 | Italy | Sicilia | 10292 | 343 | 4762 | 5187 | 38.11569725 | 13.362356699999998 | 2020-10-15 04:24:28 | Sicilia, Italy | ||
3781897 | 3781897 | 2020-10-13 | Italy | Sicilia | 9926 | 341 | 4708 | 4877 | 38.11569725 | 13.362356699999998 | 2020-10-14 04:24:05 | Sicilia, Italy | ||
2291437 | 2291437 | 2020-10-12 | Italy | Sicilia | 9592 | 339 | 4571 | 4682 | 38.11569725 | 13.362356699999998 | 2020-10-13 04:24:02 | Sicilia, Italy | ||
3785890 | 3785890 | 2020-10-11 | Italy | Sicilia | 9294 | 336 | 4557 | 4401 | 38.11569725 | 13.362356699999998 | 2020-10-12 04:23:45 | Sicilia, Italy | ||
2602028 | 2602028 | 2020-10-10 | Italy | Sicilia | 8997 | 335 | 4519 | 4143 | 38.11569725 | 13.362356699999998 | 2020-10-11 04:23:46 | Sicilia, Italy | ||
817561 | 817561 | 2020-10-09 | Italy | Sicilia | 8712 | 333 | 4478 | 3901 | 38.11569725 | 13.362356699999998 | 2020-10-10 04:23:57 | Sicilia, Italy | ||
2689676 | 2689676 | 2020-10-08 | Italy | Sicilia | 8479 | 329 | 4454 | 3696 | 38.11569725 | 13.362356699999998 | 2020-10-09 04:23:59 | Sicilia, Italy | ||
1041818 | 1041818 | 2020-10-07 | Italy | Sicilia | 8220 | 326 | 4345 | 3549 | 38.11569725 | 13.362356699999998 | 2020-10-08 04:23:56 | Sicilia, Italy | ||
3117479 | 3117479 | 2020-10-06 | Italy | Sicilia | 8007 | 322 | 4237 | 3448 | 38.11569725 | 13.362356699999998 | 2020-10-07 04:23:40 | Sicilia, Italy | ||
3801891 | 3801891 | 2020-10-05 | Italy | Sicilia | 7809 | 321 | 4130 | 3358 | 38.11569725 | 13.362356699999998 | 2020-10-06 04:23:33 | Sicilia, Italy | ||
1822781 | 1822781 | 2020-10-04 | Italy | Sicilia | 7681 | 319 | 4115 | 3247 | 38.11569725 | 13.362356699999998 | 2020-10-05 04:23:33 | Sicilia, Italy | ||
2514165 | 2514165 | 2020-10-03 | Italy | Sicilia | 7596 | 317 | 4108 | 3171 | 38.11569725 | 13.362356699999998 | 2020-10-04 04:23:44 | Sicilia, Italy | ||
3389383 | 3389383 | 2020-10-02 | Italy | Sicilia | 7414 | 314 | 4052 | 3048 | 38.11569725 | 13.362356699999998 | 2020-10-03 04:23:40 | Sicilia, Italy | ||
2379624 | 2379624 | 2020-10-01 | Italy | Sicilia | 7274 | 312 | 4026 | 2936 | 38.11569725 | 13.362356699999998 | 2020-10-02 04:23:51 | Sicilia, Italy | ||
1045810 | 1045810 | 2020-09-30 | Italy | Sicilia | 7118 | 311 | 3941 | 2866 | 38.11569725 | 13.362356699999998 | 2020-10-01 04:23:42 | Sicilia, Italy | ||
966891 | 966891 | 2020-09-29 | Italy | Sicilia | 6948 | 310 | 3851 | 2787 | 38.11569725 | 13.362356699999998 | 2020-09-30 04:23:33 | Sicilia, Italy | ||
1515388 | 1515388 | 2020-09-28 | Italy | Sicilia | 6785 | 309 | 3733 | 2743 | 38.11569725 | 13.362356699999998 | 2020-09-29 04:23:42 | Sicilia, Italy | ||
2581976 | 2581976 | 2020-09-27 | Italy | Sicilia | 6683 | 308 | 3716 | 2659 | 38.11569725 | 13.3623567 | 2020-09-28 04:23:00 | Sicilia, Italy | ||
2614028 | 2614028 | 2020-09-26 | Italy | Sicilia | 6576 | 306 | 3687 | 2583 | 38.11569725 | 13.3623567 | 2020-09-27 04:23:00 | Sicilia, Italy | ||
2812743 | 2812743 | 2020-09-25 | Italy | Sicilia | 6466 | 306 | 3630 | 2530 | 38.11569725 | 13.3623567 | 2020-09-26 04:23:00 | Sicilia, Italy | ||
2606020 | 2606020 | 2020-09-24 | Italy | Sicilia | 6359 | 304 | 3594 | 2461 | 38.11569725 | 13.3623567 | 2020-09-25 04:23:00 | Sicilia, Italy | ||
2653763 | 2653763 | 2020-09-23 | Italy | Sicilia | 6234 | 303 | 3519 | 2412 | 38.11569725 | 13.3623567 | 2020-09-24 04:23:00 | Sicilia, Italy | ||
3316212 | 3316212 | 2020-09-22 | Italy | Sicilia | 6145 | 300 | 3455 | 2390 | 38.11569725 | 13.3623567 | 2020-09-23 04:23:00 | Sicilia, Italy | ||
2836811 | 2836811 | 2020-09-21 | Italy | Sicilia | 6037 | 299 | 3390 | 2348 | 38.11569725 | 13.3623567 | 2020-09-22 04:23:00 | Sicilia, Italy | ||
3093415 | 3093415 | 2020-09-20 | Italy | Sicilia | 5962 | 296 | 3350 | 2316 | 38.11569725 | 13.3623567 | 2020-09-21 04:23:00 | Sicilia, Italy | ||
2454765 | 2454765 | 2020-09-19 | Italy | Sicilia | 5846 | 296 | 3318 | 2232 | 38.11569725 | 13.3623567 | 2020-09-20 04:22:00 | Sicilia, Italy | ||
2848834 | 2848834 | 2020-09-18 | Italy | Sicilia | 5748 | 296 | 3295 | 2157 | 38.11569725 | 13.3623567 | 2020-09-19 04:22:00 | Sicilia, Italy | ||
1121583 | 1121583 | 2020-09-17 | Italy | Sicilia | 5569 | 295 | 3231 | 2043 | 38.11569725 | 13.3623567 | 2020-09-18 05:05:00 | Sicilia, Italy | ||
666272 | 666272 | 2020-09-16 | Italy | Sicilia | 5473 | 295 | 3190 | 1988 | 38.11569725 | 13.3623567 | 2020-09-17 04:22:00 | Sicilia, Italy | ||
2728997 | 2728997 | 2020-09-15 | Italy | Sicilia | 5383 | 292 | 3172 | 1919 | 38.11569725 | 13.362356699999998 | 2020-09-16 04:22:53 | Sicilia, Italy | ||
344269 | 344269 | 2020-09-14 | Italy | Sicilia | 5306 | 292 | 3172 | 1842 | 38.11569725 | 13.362356699999998 | 2020-09-15 03:22:50 | Sicilia, Italy | ||
2868708 | 2868708 | 2020-09-13 | Italy | Sicilia | 5241 | 290 | 3158 | 1793 | 38.11569725 | 13.3623567 | 2020-09-14 04:26:00 | Sicilia, Italy | ||
546747 | 546747 | 2020-09-12 | Italy | Sicilia | 5180 | 289 | 3144 | 1747 | 38.11569725 | 13.362356699999998 | 2020-09-13 04:30:52 | Sicilia, Italy | ||
1444576 | 1444576 | 2020-09-11 | Italy | Sicilia | 5136 | 289 | 3141 | 1706 | 38.11569725 | 13.362356699999998 | 2020-09-12 04:25:05 | Sicilia, Italy | ||
1173177 | 1173177 | 2020-09-10 | Italy | Sicilia | 5032 | 289 | 3140 | 1603 | 38.11569725 | 13.362356699999998 | 2020-09-11 04:46:23 | Sicilia, Italy | ||
2171542 | 2171542 | 2020-09-09 | Italy | Sicilia | 4926 | 289 | 3110 | 1527 | 38.11569725 | 13.362356699999998 | 2020-09-10 04:29:01 | Sicilia, Italy | ||
1243751 | 1243751 | 2020-09-08 | Italy | Sicilia | 4849 | 289 | 3106 | 1454 | 38.11569725 | 13.362356699999998 | 2020-09-09 04:28:48 | Sicilia, Italy | ||
427330 | 427330 | 2020-09-07 | Italy | Sicilia | 4765 | 289 | 3097 | 1379 | 38.11569725 | 13.362356699999998 | 2020-09-08 04:28:25 | Sicilia, Italy | ||
3161615 | 3161615 | 2020-09-06 | Italy | Sicilia | 4716 | 289 | 3093 | 1334 | 38.11569725 | 13.362356699999998 | 2020-09-07 04:28:30 | Sicilia, Italy | ||
813570 | 813570 | 2020-09-05 | Italy | Sicilia | 4679 | 289 | 3047 | 1343 | 38.11569725 | 13.362356699999998 | 2020-09-06 04:28:33 | Sicilia, Italy | ||
2661770 | 2661770 | 2020-09-04 | Italy | Sicilia | 4565 | 288 | 2993 | 1284 | 38.11569725 | 13.362356699999998 | 2020-09-05 04:28:19 | Sicilia, Italy | ||
1354310 | 1354310 | 2020-09-03 | Italy | Sicilia | 4487 | 288 | 2947 | 1252 | 38.11569725 | 13.362356699999998 | 2020-09-04 04:28:26 | Sicilia, Italy | ||
1105547 | 1105547 | 2020-09-02 | Italy | Sicilia | 4433 | 287 | 2919 | 1227 | 38.11569725 | 13.362356699999998 | 2020-09-03 04:28:22 | Sicilia, Italy | ||
2059876 | 2059876 | 2020-09-01 | Italy | Sicilia | 4350 | 287 | 2911 | 1152 | 38.11569725 | 13.362356699999998 | 2020-09-02 04:28:25 | Sicilia, Italy | ||
194061 | 194061 | 2020-08-31 | Italy | Sicilia | 4317 | 286 | 2906 | 1125 | 38.11569725 | 13.362356699999998 | 2020-09-01 04:28:31 | Sicilia, Italy | ||
3932020 | 3932020 | 2020-08-30 | Italy | Sicilia | 4291 | 286 | 2891 | 1114 | 38.11569725 | 13.362356699999998 | 2020-08-31 04:28:27 | Sicilia, Italy | ||
609682 | 609682 | 2020-08-29 | Italy | Sicilia | 4257 | 286 | 2887 | 1084 | 38.11569725 | 13.362356699999998 | 2020-08-30 04:28:22 | Sicilia, Italy | ||
1523177 | 1523177 | 2020-08-28 | Italy | Sicilia | 4228 | 286 | 2884 | 1058 | 38.11569725 | 13.362356699999998 | 2020-08-29 04:28:19 | Sicilia, Italy | ||
2510178 | 2510178 | 2020-08-27 | Italy | Sicilia | 4174 | 286 | 2869 | 1019 | 38.11569725 | 13.362356699999998 | 2020-08-28 04:28:11 | Sicilia, Italy | ||
1996638 | 1996638 | 2020-08-26 | Italy | Sicilia | 4124 | 286 | 2858 | 980 | 38.11569725 | 13.362356699999998 | 2020-08-27 04:28:15 | Sicilia, Italy | ||
3562562 | 3562562 | 2020-08-25 | Italy | Sicilia | 4091 | 286 | 2858 | 947 | 38.11569725 | 13.362356699999998 | 2020-08-26 04:28:11 | Sicilia, Italy | ||
2991266 | 2991266 | 2020-08-24 | Italy | Sicilia | 4067 | 286 | 2834 | 947 | 38.11569725 | 13.362356699999998 | 2020-08-25 04:28:02 | Sicilia, Italy | ||
2215661 | 2215661 | 2020-08-23 | Italy | Sicilia | 4002 | 286 | 2813 | 903 | 38.11569725 | 13.362356699999998 | 2020-08-24 04:27:56 | Sicilia, Italy | ||
2299443 | 2299443 | 2020-08-22 | Italy | Sicilia | 3967 | 286 | 2807 | 874 | 38.11569725 | 13.362356699999998 | 2020-08-23 04:27:48 | Sicilia, Italy | ||
1479550 | 1479550 | 2020-08-21 | Italy | Sicilia | 3919 | 286 | 2805 | 828 | 38.11569725 | 13.362356699999998 | 2020-08-22 04:27:49 | Sicilia, Italy | ||
3484299 | 3484299 | 2020-08-20 | Italy | Sicilia | 3875 | 286 | 2799 | 790 | 38.11569725 | 13.362356699999998 | 2020-08-21 04:27:41 | Sicilia, Italy | ||
206248 | 206248 | 2020-08-19 | Italy | Sicilia | 3838 | 286 | 2786 | 766 | 38.11569725 | 13.362356699999998 | 2020-08-20 04:27:43 | Sicilia, Italy | ||
3178002 | 3178002 | 2020-08-18 | Italy | Sicilia | 3793 | 286 | 2785 | 722 | 38.11569725 | 13.3623567 | 2020-08-19 04:27:00 | Sicilia, Italy | ||
837606 | 837606 | 2020-08-17 | Italy | Sicilia | 3780 | 286 | 2776 | 718 | 38.11569725 | 13.362356699999998 | 2020-08-18 04:27:56 | Sicilia, Italy | ||
1555964 | 1555964 | 2020-08-16 | Italy | Sicilia | 3766 | 285 | 2769 | 712 | 38.11569725 | 13.362356699999998 | 2020-08-17 04:27:20 | Sicilia, Italy | ||
145966 | 145966 | 2020-08-15 | Italy | Sicilia | 3727 | 284 | 2766 | 677 | 38.11569725 | 13.362356699999998 | 2020-08-16 04:27:42 | Sicilia, Italy | ||
1612241 | 1612241 | 2020-08-14 | Italy | Sicilia | 3681 | 284 | 2766 | 631 | 38.11569725 | 13.362356699999998 | 2020-08-15 04:27:31 | Sicilia, Italy | ||
582825 | 582825 | 2020-08-13 | Italy | Sicilia | 3645 | 284 | 2757 | 604 | 38.11569725 | 13.362356699999998 | 2020-08-14 04:51:19 | Sicilia, Italy | ||
3531444 | 3531444 | 2020-08-12 | Italy | Sicilia | 3603 | 284 | 2757 | 562 | 38.11569725 | 13.362356699999998 | 2020-08-13 04:29:15 | Sicilia, Italy | ||
662293 | 662293 | 2020-08-11 | Italy | Sicilia | 3574 | 284 | 2752 | 538 | 38.11569725 | 13.362356699999998 | 2020-08-12 04:27:29 | Sicilia, Italy | ||
1920579 | 1920579 | 2020-08-10 | Italy | Sicilia | 3485 | 284 | 2751 | 450 | 38.11569725 | 13.362356699999998 | 2020-08-11 04:35:08 | Sicilia, Italy | ||
3923388 | 3923388 | 2020-08-09 | Italy | Sicilia | 3453 | 284 | 2749 | 420 | 38.11569725 | 13.362356699999998 | 2020-08-10 04:34:55 | Sicilia, Italy | ||
371556 | 371556 | 2020-08-08 | Italy | Sicilia | 3424 | 284 | 2743 | 397 | 38.11569725 | 13.362356699999998 | 2020-08-09 04:34:54 | Sicilia, Italy | ||
458740 | 458740 | 2020-08-07 | Italy | Sicilia | 3396 | 284 | 2743 | 369 | 38.11569725 | 13.362356699999998 | 2020-08-08 04:34:53 | Sicilia, Italy | ||
3612425 | 3612425 | 2020-08-06 | Italy | Sicilia | 3369 | 284 | 2743 | 342 | 38.11569725 | 13.362356699999998 | 2020-08-07 04:35:11 | Sicilia, Italy | ||
3793255 | 3793255 | 2020-08-05 | Italy | Sicilia | 3339 | 284 | 2741 | 314 | 38.11569725 | 13.362356699999998 | 2020-08-06 04:35:02 | Sicilia, Italy | ||
98491 | 98491 | 2020-08-04 | Italy | Sicilia | 3318 | 284 | 2741 | 293 | 38.11569725 | 13.362356699999998 | 2020-08-05 04:34:43 | Sicilia, Italy | ||
2740374 | 2740374 | 2020-08-03 | Italy | Sicilia | 3308 | 283 | 2737 | 288 | 38.11569725 | 13.362356699999998 | 2020-08-04 04:41:59 | Sicilia, Italy | ||
2808126 | 2808126 | 2020-08-02 | Italy | Sicilia | 3305 | 283 | 2737 | 285 | 38.11569725 | 13.362356699999998 | 2020-08-03 04:34:35 | Sicilia, Italy | ||
753694 | 753694 | 2020-08-01 | Italy | Sicilia | 3298 | 283 | 2734 | 281 | 38.11569725 | 13.362356699999998 | 2020-08-02 04:34:47 | Sicilia, Italy | ||
3264859 | 3264859 | 2020-07-31 | Italy | Sicilia | 3288 | 283 | 2730 | 275 | 38.11569725 | 13.362356699999998 | 2020-08-01 04:36:27 | Sicilia, Italy | ||
1928566 | 1928566 | 2020-07-30 | Italy | Sicilia | 3272 | 283 | 2730 | 259 | 38.11569725 | 13.362356699999998 | 2020-07-31 04:35:18 | Sicilia, Italy | ||
2958734 | 2958734 | 2020-07-29 | Italy | Sicilia | 3233 | 283 | 2726 | 224 | 38.11569725 | 13.362356699999998 | 2020-07-30 04:35:05 | Sicilia, Italy | ||
3185350 | 3185350 | 2020-07-28 | Italy | Sicilia | 3215 | 283 | 2726 | 206 | 38.11569725 | 13.362356699999998 | 2020-07-29 04:35:11 | Sicilia, Italy | ||
177401 | 177401 | 2020-07-27 | Italy | Sicilia | 3196 | 283 | 2719 | 194 | 38.11569725 | 13.362356699999998 | 2020-07-28 04:58:43 | Sicilia, Italy | ||
442714 | 442714 | 2020-07-26 | Italy | Sicilia | 3193 | 283 | 2715 | 195 | 38.11569725 | 13.362356699999998 | 2020-07-27 04:35:02 | Sicilia, Italy | ||
1502958 | 1502958 | 2020-07-25 | Italy | Sicilia | 3179 | 283 | 2715 | 181 | 38.11569725 | 13.362356699999998 | 2020-07-26 04:35:00 | Sicilia, Italy | ||
2563928 | 2563928 | 2020-07-24 | Italy | Sicilia | 3166 | 283 | 2713 | 170 | 38.11569725 | 13.362356699999998 | 2020-07-25 04:47:39 | Sicilia, Italy | ||
62136 | 62136 | 2020-07-23 | Italy | Sicilia | 3158 | 283 | 2712 | 163 | 38.11569725 | 13.362356699999998 | 2020-07-24 05:30:40 | Sicilia, Italy | ||
844948 | 844948 | 2020-07-22 | Italy | Sicilia | 3153 | 283 | 2709 | 161 | 38.11569725 | 13.362356699999998 | 2020-07-23 05:15:04 | Sicilia, Italy | ||
1707687 | 1707687 | 2020-07-21 | Italy | Sicilia | 3146 | 283 | 2706 | 157 | 38.11569725 | 13.362356699999998 | 2020-07-22 04:34:42 | Sicilia, Italy | ||
327178 | 327178 | 2020-07-20 | Italy | Sicilia | 3144 | 283 | 2704 | 157 | 38.11569725 | 13.362356699999998 | 2020-07-21 04:38:46 | Sicilia, Italy | ||
122083 | 122083 | 2020-07-19 | Italy | Sicilia | 3142 | 283 | 2697 | 162 | 38.11569725 | 13.362356699999998 | 2020-07-20 05:34:40 | Sicilia, Italy | ||
3205472 | 3205472 | 2020-07-18 | Italy | Sicilia | 3140 | 283 | 2695 | 162 | 38.11569725 | 13.362356699999998 | 2020-07-19 04:34:58 | Sicilia, Italy | ||
2708774 | 2708774 | 2020-07-17 | Italy | Sicilia | 3136 | 283 | 2695 | 158 | 38.11569725 | 13.362356699999998 | 2020-07-18 04:34:45 | Sicilia, Italy | ||
367584 | 367584 | 2020-07-16 | Italy | Sicilia | 3132 | 283 | 2695 | 154 | 38.11569725 | 13.362356699999998 | 2020-07-17 04:34:50 | Sicilia, Italy | ||
2748252 | 2748252 | 2020-07-15 | Italy | Sicilia | 3115 | 283 | 2695 | 137 | 38.11569725 | 13.362356699999998 | 2020-07-16 04:44:59 | Sicilia, Italy | ||
2158896 | 2158896 | 2020-07-14 | Italy | Sicilia | 3115 | 283 | 2695 | 137 | 38.11569725 | 13.362356699999998 | 2020-07-15 04:34:39 | Sicilia, Italy | ||
3491537 | 3491537 | 2020-07-13 | Italy | Sicilia | 3100 | 283 | 2694 | 123 | 38.11569725 | 13.362356699999998 | 2020-07-14 04:34:46 | Sicilia, Italy | ||
3737800 | 3737800 | 2020-07-12 | Italy | Sicilia | 3099 | 283 | 2693 | 123 | 38.11569725 | 13.362356699999998 | 2020-07-13 04:43:04 | Sicilia, Italy | ||
3436195 | 3436195 | 2020-07-11 | Italy | Sicilia | 3099 | 283 | 2693 | 123 | 38.11569725 | 13.362356699999998 | 2020-07-12 04:34:30 | Sicilia, Italy | ||
3237693 | 3237693 | 2020-07-10 | Italy | Sicilia | 3098 | 283 | 2691 | 124 | 38.11569725 | 13.362356699999998 | 2020-07-11 04:34:26 | Sicilia, Italy |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);