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 active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2673807 | 2673807 | 2021-07-18 | Italy | Sicilia | 235496 | 6006 | 224367 | 5123 | 38.11569725 | 13.362356699999998 | 2021-07-19 04:21:24 | 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 | ||
562961 | 562961 | 2021-06-22 | Italy | Sicilia | 230805 | 5945 | 219651 | 5209 | 38.11569725 | 13.362356699999998 | 2021-06-23 04:21:46 | 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 | ||
483584 | 483584 | 2021-07-19 | Italy | Sicilia | 235796 | 6007 | 224408 | 5381 | 38.11569725 | 13.362356699999998 | 2021-07-20 04:21:48 | 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 | ||
3358663 | 3358663 | 2021-06-21 | Italy | Sicilia | 230672 | 5938 | 219225 | 5509 | 38.11569725 | 13.362356699999998 | 2021-06-22 04:21:34 | Sicilia, Italy | ||
2884362 | 2884362 | 2021-06-20 | Italy | Sicilia | 230587 | 5936 | 219091 | 5560 | 38.11569725 | 13.362356699999998 | 2021-06-21 04:21:41 | Sicilia, Italy | ||
107445 | 107445 | 2021-06-19 | Italy | Sicilia | 230452 | 5936 | 218901 | 5615 | 38.11569725 | 13.362356699999998 | 2021-06-20 04:21:48 | 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 | ||
1125588 | 1125588 | 2021-06-18 | Italy | Sicilia | 230269 | 5931 | 218636 | 5702 | 38.11569725 | 13.362356699999998 | 2021-06-19 04:22:33 | Sicilia, Italy | ||
2371505 | 2371505 | 2021-07-20 | Italy | Sicilia | 236348 | 6010 | 224538 | 5800 | 38.11569725 | 13.362356699999998 | 2021-07-21 04:21:40 | Sicilia, Italy | ||
2911166 | 2911166 | 2021-06-17 | Italy | Sicilia | 230099 | 5928 | 218270 | 5901 | 38.11569725 | 13.362356699999998 | 2021-06-18 04:22:16 | 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 | ||
3030284 | 3030284 | 2021-06-16 | Italy | Sicilia | 229871 | 5928 | 217940 | 6003 | 38.11569725 | 13.362356699999998 | 2021-06-17 04:22:36 | 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 | ||
3331524 | 3331524 | 2021-07-21 | Italy | Sicilia | 236898 | 6019 | 224688 | 6191 | 38.11569725 | 13.362356699999998 | 2021-07-22 04:21:19 | Sicilia, Italy | ||
1026346 | 1026346 | 2020-10-17 | Italy | Sicilia | 11744 | 362 | 5101 | 6281 | 38.11569725 | 13.362356699999998 | 2020-10-18 04:24:25 | 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 | ||
2339390 | 2339390 | 2021-06-15 | Italy | Sicilia | 229703 | 5920 | 217416 | 6367 | 38.11569725 | 13.362356699999998 | 2021-06-16 04:22:32 | Sicilia, Italy | ||
3682835 | 3682835 | 2020-06-18 | Italy | Sicilia | 3464 | 280 | 2547 | 637 | 38.11569725 | 13.362356699999998 | 2020-06-19 04:33:17 | Sicilia, Italy | ||
3476305 | 3476305 | 2021-07-22 | Italy | Sicilia | 237418 | 6021 | 224794 | 6603 | 38.11569725 | 13.362356699999998 | 2021-07-23 04:21:29 | Sicilia, Italy | ||
1564086 | 1564086 | 2021-06-14 | Italy | Sicilia | 229503 | 5912 | 216960 | 6631 | 38.11569725 | 13.362356699999998 | 2021-06-15 04:22:22 | Sicilia, Italy | ||
1736503 | 1736503 | 2021-06-12 | Italy | Sicilia | 229157 | 5900 | 216559 | 6698 | 38.11569725 | 13.362356699999998 | 2021-06-13 04:22:44 | Sicilia, Italy | ||
3381369 | 3381369 | 2021-06-13 | Italy | Sicilia | 229340 | 5905 | 216713 | 6722 | 38.11569725 | 13.362356699999998 | 2021-06-14 04:22:46 | 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 | ||
762308 | 762308 | 2020-10-18 | Italy | Sicilia | 12292 | 365 | 5137 | 6790 | 38.11569725 | 13.362356699999998 | 2020-10-19 04:24:16 | Sicilia, Italy | ||
3970544 | 3970544 | 2021-06-11 | Italy | Sicilia | 228894 | 5897 | 216133 | 6864 | 38.11569725 | 13.362356699999998 | 2021-06-12 04:22:22 | Sicilia, Italy | ||
3137545 | 3137545 | 2021-07-23 | Italy | Sicilia | 237902 | 6023 | 224976 | 6903 | 38.11569725 | 13.362356699999998 | 2021-07-24 00:21:36 | Sicilia, Italy | ||
1794624 | 1794624 | 2020-10-19 | Italy | Sicilia | 12654 | 368 | 5267 | 7019 | 38.11569725 | 13.362356699999998 | 2020-10-20 04:24:22 | 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 | ||
837606 | 837606 | 2020-08-17 | Italy | Sicilia | 3780 | 286 | 2776 | 718 | 38.11569725 | 13.362356699999998 | 2020-08-18 04:27:56 | 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 | ||
522851 | 522851 | 2021-06-09 | Italy | Sicilia | 228337 | 5890 | 215125 | 7322 | 38.11569725 | 13.362356699999998 | 2021-06-10 04:23:17 | Sicilia, Italy | ||
2716966 | 2716966 | 2021-06-10 | Italy | Sicilia | 228621 | 5893 | 215367 | 7361 | 38.11569725 | 13.362356699999998 | 2021-06-11 04:23:20 | Sicilia, Italy | ||
1330241 | 1330241 | 2021-07-24 | Italy | Sicilia | 238528 | 6024 | 225032 | 7472 | 38.11569725 | 13.362356699999998 | 2021-07-25 04:22:12 | Sicilia, Italy | ||
3990604 | 3990604 | 2020-10-20 | Italy | Sicilia | 13228 | 378 | 5353 | 7497 | 38.11569725 | 13.362356699999998 | 2020-10-21 04:24:14 | 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 | ||
3472291 | 3472291 | 2021-06-08 | Italy | Sicilia | 228017 | 5888 | 214423 | 7706 | 38.11569725 | 13.362356699999998 | 2021-06-09 04:23:31 | Sicilia, Italy | ||
2191593 | 2191593 | 2020-10-21 | Italy | Sicilia | 13790 | 389 | 5551 | 7850 | 38.11569725 | 13.362356699999998 | 2020-10-22 04:24:27 | Sicilia, Italy | ||
3145575 | 3145575 | 2021-06-07 | Italy | Sicilia | 227680 | 5876 | 213921 | 7883 | 38.11569725 | 13.362356699999998 | 2021-06-08 04:22:35 | Sicilia, Italy | ||
2585982 | 2585982 | 2021-06-05 | Italy | Sicilia | 227249 | 5871 | 213483 | 7895 | 38.11569725 | 13.362356699999998 | 2021-06-06 04:24:03 | 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 | ||
1378501 | 1378501 | 2021-07-25 | Italy | Sicilia | 239096 | 6024 | 225151 | 7921 | 38.11569725 | 13.362356699999998 | 2021-07-26 04:21:28 | Sicilia, Italy | ||
825577 | 825577 | 2021-06-06 | Italy | Sicilia | 227524 | 5873 | 213680 | 7971 | 38.11569725 | 13.362356699999998 | 2021-06-07 04:22:51 | Sicilia, Italy | ||
287364 | 287364 | 2020-06-15 | Italy | Sicilia | 3458 | 280 | 2373 | 805 | 38.11569725 | 13.362356699999998 | 2020-06-16 04:33:09 | Sicilia, Italy | ||
1196038 | 1196038 | 2020-06-17 | Italy | Sicilia | 3462 | 280 | 2377 | 805 | 38.11569725 | 13.362356699999998 | 2020-06-18 04:33:18 | Sicilia, Italy | ||
2386801 | 2386801 | 2020-06-16 | Italy | Sicilia | 3460 | 280 | 2374 | 806 | 38.11569725 | 13.362356699999998 | 2020-06-17 04:33:21 | 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 | ||
2315296 | 2315296 | 2021-06-04 | Italy | Sicilia | 227015 | 5863 | 212834 | 8318 | 38.11569725 | 13.362356699999998 | 2021-06-05 04:23:03 | Sicilia, Italy | ||
3218292 | 3218292 | 2021-07-26 | Italy | Sicilia | 239553 | 6024 | 225162 | 8367 | 38.11569725 | 13.362356699999998 | 2021-07-27 04:21:18 | Sicilia, Italy | ||
1837315 | 1837315 | 2020-06-14 | Italy | Sicilia | 3457 | 279 | 2341 | 837 | 38.11569725 | 13.362356699999998 | 2020-06-15 03:33:14 | Sicilia, Italy | ||
737687 | 737687 | 2020-06-12 | Italy | Sicilia | 3455 | 279 | 2335 | 841 | 38.11569725 | 13.362356699999998 | 2020-06-13 03:33:14 | Sicilia, Italy | ||
3061367 | 3061367 | 2020-06-13 | Italy | Sicilia | 3456 | 279 | 2335 | 842 | 38.11569725 | 13.362356699999998 | 2020-06-14 03:33:15 | Sicilia, Italy | ||
1273657 | 1273657 | 2020-06-11 | Italy | Sicilia | 3455 | 279 | 2327 | 849 | 38.11569725 | 13.362356699999998 | 2020-06-12 05:09:52 | Sicilia, Italy | ||
1306149 | 1306149 | 2021-07-27 | Italy | Sicilia | 239989 | 6030 | 225451 | 8508 | 38.11569725 | 13.362356699999998 | 2021-07-28 04:21:39 | Sicilia, Italy | ||
217351 | 217351 | 2020-06-08 | Italy | Sicilia | 3452 | 278 | 2321 | 853 | 38.11569725 | 13.362356699999998 | 2020-06-09 03:33:03 | Sicilia, Italy | ||
1210924 | 1210924 | 2020-06-09 | Italy | Sicilia | 3454 | 278 | 2323 | 853 | 38.11569725 | 13.362356699999998 | 2020-06-10 04:07:00 | Sicilia, Italy | ||
2864098 | 2864098 | 2020-06-10 | Italy | Sicilia | 3455 | 278 | 2324 | 853 | 38.11569725 | 13.362356699999998 | 2020-06-11 03:33:41 | Sicilia, Italy | ||
1177488 | 1177488 | 2020-10-22 | Italy | Sicilia | 14586 | 397 | 5649 | 8540 | 38.11569725 | 13.362356699999998 | 2020-10-23 04:24:46 | Sicilia, Italy | ||
2800147 | 2800147 | 2020-06-07 | Italy | Sicilia | 3451 | 277 | 2312 | 862 | 38.11569725 | 13.362356699999998 | 2020-06-08 03:33:22 | Sicilia, Italy | ||
574203 | 574203 | 2020-06-06 | Italy | Sicilia | 3450 | 276 | 2308 | 866 | 38.11569725 | 13.362356699999998 | 2020-06-07 03:53:30 | Sicilia, Italy | ||
1708305 | 1708305 | 2021-06-02 | Italy | Sicilia | 226424 | 5855 | 211871 | 8698 | 38.11569725 | 13.362356699999998 | 2021-06-03 04:23:32 | Sicilia, Italy | ||
1269900 | 1269900 | 2020-06-05 | Italy | Sicilia | 3448 | 276 | 2300 | 872 | 38.11569725 | 13.362356699999998 | 2020-06-06 02:33:00 | 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 | ||
1448581 | 1448581 | 2021-06-03 | Italy | Sicilia | 226678 | 5858 | 212057 | 8763 | 38.11569725 | 13.362356699999998 | 2021-06-04 04:23:37 | Sicilia, Italy | ||
1281369 | 1281369 | 2020-06-04 | Italy | Sicilia | 3447 | 276 | 2292 | 879 | 38.11569725 | 13.362356699999998 | 2020-06-05 02:33:06 | Sicilia, Italy | ||
3866924 | 3866924 | 2020-06-03 | Italy | Sicilia | 3447 | 275 | 2292 | 880 | 38.11569725 | 13.362356699999998 | 2020-06-04 02:33:14 | Sicilia, Italy | ||
408288 | 408288 | 2021-07-28 | Italy | Sicilia | 240616 | 6036 | 225637 | 8943 | 38.11569725 | 13.362356699999998 | 2021-07-29 04:21:33 | 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 | ||
1053818 | 1053818 | 2020-10-23 | Italy | Sicilia | 15316 | 408 | 5772 | 9136 | 38.11569725 | 13.362356699999998 | 2020-10-24 04:24:46 | 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 | ||
3562562 | 3562562 | 2020-08-25 | Italy | Sicilia | 4091 | 286 | 2858 | 947 | 38.11569725 | 13.362356699999998 | 2020-08-26 04:28:11 | Sicilia, Italy | ||
3385383 | 3385383 | 2021-07-29 | Italy | Sicilia | 241335 | 6039 | 225821 | 9475 | 38.11569725 | 13.362356699999998 | 2021-07-30 04:21:34 | Sicilia, Italy | ||
2104123 | 2104123 | 2021-06-01 | Italy | Sicilia | 226135 | 5839 | 210808 | 9488 | 38.11569725 | 13.362356699999998 | 2021-06-02 04:24:34 | Sicilia, Italy | ||
2555966 | 2555966 | 2020-06-02 | Italy | Sicilia | 3447 | 275 | 2206 | 966 | 38.11569725 | 13.362356699999998 | 2020-06-03 02:33:13 | Sicilia, Italy | ||
805503 | 805503 | 2020-06-01 | Italy | Sicilia | 3443 | 274 | 2202 | 967 | 38.11569725 | 13.362356699999998 | 2020-06-02 02:33:08 | 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 | ||
1794064 | 1794064 | 2020-05-31 | Italy | Sicilia | 3443 | 274 | 2183 | 986 | 38.11569725 | 13.362356699999998 | 2020-06-01 02:32:46 | Sicilia, Italy | ||
3089416 | 3089416 | 2021-05-30 | Italy | Sicilia | 225551 | 5819 | 209849 | 9883 | 38.11569725 | 13.362356699999998 | 2021-05-31 03:08:59 | Sicilia, Italy | ||
3651563 | 3651563 | 2020-10-24 | Italy | Sicilia | 16202 | 417 | 5896 | 9889 | 38.11569725 | 13.362356699999998 | 2020-10-25 04:24:36 | Sicilia, Italy | ||
1188739 | 1188739 | 2021-05-31 | Italy | Sicilia | 225809 | 5827 | 210050 | 9932 | 38.11569725 | 13.362356699999998 | 2021-06-01 04:23:09 | Sicilia, Italy | ||
50785 | 50785 | 2021-05-29 | Italy | Sicilia | 225203 | 5814 | 209401 | 9988 | 38.11569725 | 13.362356699999998 | 2021-05-30 04:20:55 | Sicilia, Italy | ||
3638957 | 3638957 | 2020-05-30 | Italy | Sicilia | 3442 | 273 | 2170 | 999 | 38.11569725 | 13.362356699999998 | 2020-05-31 02:32:45 | Sicilia, Italy | ||
3296172 | 3296172 | 2021-07-30 | Italy | Sicilia | 242059 | 6043 | 226021 | 9995 | 38.11569725 | 13.362356699999998 | 2021-07-31 04:21:35 | 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]);