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 longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- …
province_or_state 1
- Sicilia · 960 ✖
latitude 1 ✖
- 38.11569725 960
country_or_region 1
- Italy · 960 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308 | 308 | 2021-12-02 | Italy | Sicilia | 325626 | 7218 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-03 04:23:05 | Sicilia, Italy | |||
4324 | 4324 | 2021-10-28 | Italy | Sicilia | 307175 | 7009 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-29 04:22:03 | Sicilia, Italy | |||
8326 | 8326 | 2020-10-25 | Italy | Sicilia | 16897 | 428 | 5914 | 10555 | 38.11569725 | 13.362356699999998 | 2020-10-26 04:25:02 | Sicilia, Italy | ||
12334 | 12334 | 2021-01-26 | Italy | Sicilia | 131607 | 3296 | 80832 | 47479 | 38.11569725 | 13.362356699999998 | 2021-01-27 05:23:41 | Sicilia, Italy | ||
16349 | 16349 | 2021-09-18 | Italy | Sicilia | 292607 | 6691 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-19 04:21:34 | Sicilia, Italy | |||
20364 | 20364 | 2021-05-28 | Italy | Sicilia | 224818 | 5807 | 208396 | 10615 | 38.11569725 | 13.362356699999998 | 2021-05-29 04:20:41 | Sicilia, Italy | ||
24379 | 24379 | 2022-03-20 | Italy | Sicilia | 905770 | 9860 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-21 04:20:50 | Sicilia, Italy | |||
28394 | 28394 | 2021-11-11 | Italy | Sicilia | 313267 | 7078 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-12 04:22:01 | Sicilia, Italy | |||
32410 | 32410 | 2021-08-25 | Italy | Sicilia | 268573 | 6259 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-26 04:21:28 | Sicilia, Italy | |||
36424 | 36424 | 2021-04-12 | Italy | Sicilia | 187597 | 5058 | 158830 | 23709 | 38.11569725 | 13.362356699999998 | 2021-04-13 04:20:37 | Sicilia, Italy | ||
43686 | 43686 | 2021-11-02 | Italy | Sicilia | 308909 | 7022 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-03 06:22: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 | ||
54799 | 54799 | 2021-03-07 | Italy | Sicilia | 156388 | 4235 | 135433 | 16720 | 38.11569725 | 13.362356699999998 | 2021-03-08 05:24:48 | 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 | ||
67055 | 67055 | 2021-09-01 | Italy | Sicilia | 277705 | 6369 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-02 04:21:15 | Sicilia, Italy | |||
71069 | 71069 | 2022-02-07 | Italy | Sicilia | 673220 | 8815 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-08 04:21:15 | Sicilia, Italy | |||
75083 | 75083 | 2020-12-03 | Italy | Sicilia | 67862 | 1650 | 26432 | 39780 | 38.11569725 | 13.362356699999998 | 2020-12-04 05:27:27 | 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 | ||
83089 | 83089 | 2021-05-25 | Italy | Sicilia | 223642 | 5758 | 205280 | 12604 | 38.11569725 | 13.362356699999998 | 2021-05-26 04:20:35 | Sicilia, Italy | ||
87103 | 87103 | 2021-11-09 | Italy | Sicilia | 312079 | 7060 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-10 04:21:38 | 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 | ||
99304 | 99304 | 2022-01-14 | Italy | Sicilia | 504809 | 7812 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-15 04:21:07 | Sicilia, Italy | |||
103320 | 103320 | 2021-08-15 | Italy | Sicilia | 255471 | 6141 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-16 04:21:31 | 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 | ||
122083 | 122083 | 2020-07-19 | Italy | Sicilia | 3142 | 283 | 2697 | 162 | 38.11569725 | 13.362356699999998 | 2020-07-20 05:34:40 | Sicilia, Italy | ||
122698 | 122698 | 2020-11-18 | Italy | Sicilia | 46528 | 1015 | 13411 | 32102 | 38.11569725 | 13.362356699999998 | 2020-11-19 05:25:23 | Sicilia, Italy | ||
126711 | 126711 | 2022-01-09 | Italy | Sicilia | 449350 | 7682 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-10 04:22:07 | Sicilia, Italy | |||
137949 | 137949 | 2021-12-04 | Italy | Sicilia | 327011 | 7228 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-05 04:22:25 | 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 | ||
149962 | 149962 | 2021-11-29 | Italy | Sicilia | 323677 | 7197 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-30 04:22:53 | Sicilia, Italy | |||
153977 | 153977 | 2021-01-08 | Italy | Sicilia | 104483 | 2664 | 62147 | 39672 | 38.11569725 | 13.362356699999998 | 2021-01-09 05:22:18 | Sicilia, Italy | ||
157991 | 157991 | 2022-03-29 | Italy | Sicilia | 961003 | 10026 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-30 04:20:45 | Sicilia, Italy | |||
162006 | 162006 | 2021-11-19 | Italy | Sicilia | 317296 | 7131 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-20 04:22:17 | Sicilia, Italy | |||
170038 | 170038 | 2021-04-16 | Italy | Sicilia | 193343 | 5128 | 163340 | 24875 | 38.11569725 | 13.362356699999998 | 2021-04-17 04:20:40 | 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 | ||
178020 | 178020 | 2021-09-02 | Italy | Sicilia | 278887 | 6392 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-03 04:21:20 | Sicilia, Italy | |||
182034 | 182034 | 2021-02-21 | Italy | Sicilia | 148990 | 3999 | 115811 | 29180 | 38.11569725 | 13.362356699999998 | 2021-02-22 05:24:21 | Sicilia, Italy | ||
186049 | 186049 | 2022-02-13 | Italy | Sicilia | 713609 | 9036 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-14 04:20:51 | Sicilia, Italy | |||
190063 | 190063 | 2021-01-11 | Italy | Sicilia | 109642 | 2765 | 64058 | 42819 | 38.11569725 | 13.362356699999998 | 2021-01-12 05:22:15 | 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 | ||
202250 | 202250 | 2020-12-25 | Italy | Sicilia | 88597 | 2256 | 53109 | 33232 | 38.11569725 | 13.362356699999998 | 2020-12-26 05:22:28 | 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 | ||
210234 | 210234 | 2020-10-29 | Italy | Sicilia | 19822 | 472 | 6605 | 12745 | 38.11569725 | 13.362356699999998 | 2020-10-30 04:24:49 | 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 | ||
233221 | 233221 | 2022-02-11 | Italy | Sicilia | 702199 | 8982 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-12 04:21:06 | Sicilia, Italy | |||
237235 | 237235 | 2021-01-18 | Italy | Sicilia | 122007 | 3027 | 72095 | 46885 | 38.11569725 | 13.362356699999998 | 2021-01-19 05:22:15 | Sicilia, Italy | ||
241249 | 241249 | 2021-04-02 | Italy | Sicilia | 176627 | 4662 | 150954 | 21011 | 38.11569725 | 13.362356699999998 | 2021-04-03 04:20:44 | Sicilia, Italy | ||
245263 | 245263 | 2021-08-17 | Italy | Sicilia | 257581 | 6148 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-18 04:21:35 | Sicilia, Italy | |||
249277 | 249277 | 2021-09-04 | Italy | Sicilia | 281435 | 6435 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-05 04:21:33 | Sicilia, Italy | |||
261511 | 261511 | 2022-03-15 | Italy | Sicilia | 867374 | 9767 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-16 04:20:50 | Sicilia, Italy | |||
268404 | 268404 | 2020-05-21 | Italy | Sicilia | 3417 | 268 | 1627 | 1522 | 38.11569725 | 13.362356699999998 | 2020-05-22 02:36:51 | Sicilia, Italy | ||
272149 | 272149 | 2020-11-10 | Italy | Sicilia | 33495 | 735 | 9928 | 22832 | 38.11569725 | 13.362356699999998 | 2020-11-11 05:25:30 | Sicilia, Italy | ||
276161 | 276161 | 2021-11-03 | Italy | Sicilia | 309307 | 7029 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-04 04:22:20 | Sicilia, Italy | |||
280177 | 280177 | 2021-02-24 | Italy | Sicilia | 150396 | 4060 | 118646 | 27690 | 38.11569725 | 13.362356699999998 | 2021-02-25 05:24:57 | 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 | ||
287974 | 287974 | 2021-10-31 | Italy | Sicilia | 308232 | 7017 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-01 04:22:01 | Sicilia, Italy | |||
296006 | 296006 | 2021-07-15 | Italy | Sicilia | 234275 | 6006 | 224129 | 4140 | 38.11569725 | 13.362356699999998 | 2021-07-16 04:21:22 | Sicilia, Italy | ||
303236 | 303236 | 2020-07-01 | Italy | Sicilia | 3081 | 282 | 2673 | 126 | 38.11569725 | 13.362356699999998 | 2020-07-02 04:33:46 | Sicilia, Italy | ||
303847 | 303847 | 2022-04-16 | Italy | Sicilia | 1051028 | 10353 | 0 | 38.11569725 | 13.362356699999998 | 2022-04-17 04:20:59 | Sicilia, Italy | |||
315895 | 315895 | 2022-02-12 | Italy | Sicilia | 708144 | 9024 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-13 04:21:00 | 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 | ||
331900 | 331900 | 2021-08-04 | Italy | Sicilia | 245420 | 6062 | 227263 | 12095 | 38.11569725 | 13.362356699999998 | 2021-08-05 04:21:51 | Sicilia, Italy | ||
335915 | 335915 | 2022-03-18 | Italy | Sicilia | 891982 | 9833 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-19 04:20:47 | Sicilia, Italy | |||
340269 | 340269 | 2021-02-03 | Italy | Sicilia | 138739 | 3579 | 94038 | 41122 | 38.11569725 | 13.362356699999998 | 2021-02-04 05:22:26 | 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 | ||
352290 | 352290 | 2021-03-11 | Italy | Sicilia | 158865 | 4305 | 141038 | 13522 | 38.11569725 | 13.362356699999998 | 2021-03-12 05:26:50 | Sicilia, Italy | ||
356305 | 356305 | 2022-03-11 | Italy | Sicilia | 844533 | 9721 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-12 04:20:50 | 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 | ||
371556 | 371556 | 2020-08-08 | Italy | Sicilia | 3424 | 284 | 2743 | 397 | 38.11569725 | 13.362356699999998 | 2020-08-09 04:34:54 | Sicilia, Italy | ||
376176 | 376176 | 2020-11-06 | Italy | Sicilia | 28825 | 628 | 8684 | 19513 | 38.11569725 | 13.362356699999998 | 2020-11-07 05:24:52 | Sicilia, Italy | ||
380187 | 380187 | 2021-04-30 | Italy | Sicilia | 208487 | 5410 | 178181 | 24896 | 38.11569725 | 13.362356699999998 | 2021-05-01 04:20:47 | Sicilia, Italy | ||
388217 | 388217 | 2021-04-04 | Italy | Sicilia | 178656 | 4697 | 151107 | 22852 | 38.11569725 | 13.362356699999998 | 2021-04-05 04:20:35 | Sicilia, Italy | ||
392229 | 392229 | 2020-11-27 | Italy | Sicilia | 60335 | 1418 | 19834 | 39083 | 38.11569725 | 13.362356699999998 | 2020-11-28 05:25:50 | Sicilia, Italy | ||
400258 | 400258 | 2021-06-29 | Italy | Sicilia | 231554 | 5967 | 221360 | 4227 | 38.11569725 | 13.362356699999998 | 2021-06-30 04:21:41 | Sicilia, Italy | ||
404272 | 404272 | 2021-12-07 | Italy | Sicilia | 329361 | 7250 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-08 04:22:46 | 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 | ||
415528 | 415528 | 2020-07-05 | Italy | Sicilia | 3094 | 282 | 2674 | 138 | 38.11569725 | 13.362356699999998 | 2020-07-06 04:33:57 | Sicilia, Italy | ||
423329 | 423329 | 2021-10-10 | Italy | Sicilia | 301658 | 6892 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-11 04:21:31 | 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 | ||
435350 | 435350 | 2021-01-21 | Italy | Sicilia | 126364 | 3129 | 76337 | 46898 | 38.11569725 | 13.362356699999998 | 2021-01-22 05:22:10 | 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 | ||
443333 | 443333 | 2021-10-20 | Italy | Sicilia | 304306 | 6960 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-21 04:21:18 | Sicilia, Italy | |||
447349 | 447349 | 2021-11-17 | Italy | Sicilia | 316126 | 7116 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-18 04:21:33 | 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 | ||
459358 | 459358 | 2022-02-02 | Italy | Sicilia | 640055 | 8622 | 0 | 38.11569725 | 13.362356699999998 | 2022-02-03 04:21:21 | Sicilia, Italy | |||
467390 | 467390 | 2021-10-07 | Italy | Sicilia | 300656 | 6877 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-08 04:21:25 | Sicilia, Italy | |||
471406 | 471406 | 2021-02-19 | Italy | Sicilia | 148105 | 3963 | 112573 | 31569 | 38.11569725 | 13.362356699999998 | 2021-02-20 05:22:51 | 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 | ||
491614 | 491614 | 2021-10-14 | Italy | Sicilia | 302736 | 6921 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-15 04:21:26 | Sicilia, Italy | |||
495630 | 495630 | 2021-11-06 | Italy | Sicilia | 310446 | 7046 | 0 | 38.11569725 | 13.362356699999998 | 2021-11-07 04:21:53 | Sicilia, Italy | |||
499647 | 499647 | 2022-04-02 | Italy | Sicilia | 986308 | 10120 | 0 | 38.11569725 | 13.362356699999998 | 2022-04-03 04:20:48 | Sicilia, Italy | |||
507678 | 507678 | 2021-08-14 | Italy | Sicilia | 254525 | 6137 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-15 04:21:41 | Sicilia, Italy | |||
511692 | 511692 | 2021-08-19 | Italy | Sicilia | 259955 | 6189 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-20 04:21:33 | 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 | ||
530090 | 530090 | 2020-07-04 | Italy | Sicilia | 3094 | 282 | 2674 | 138 | 38.11569725 | 13.362356699999998 | 2020-07-05 04:33:46 | Sicilia, Italy | ||
530700 | 530700 | 2021-02-22 | Italy | Sicilia | 149402 | 4018 | 116017 | 29367 | 38.11569725 | 13.362356699999998 | 2021-02-23 05:23:41 | Sicilia, Italy | ||
534714 | 534714 | 2021-10-27 | Italy | Sicilia | 306867 | 7000 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-28 04:22:08 | 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 | ||
550752 | 550752 | 2021-12-08 | Italy | Sicilia | 329979 | 7260 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-09 04:22:49 | Sicilia, Italy | |||
554768 | 554768 | 2022-01-16 | Italy | Sicilia | 522622 | 7915 | 0 | 38.11569725 | 13.362356699999998 | 2022-01-17 04:21:08 | 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]);