johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 21
- Abruzzo 960
- Basilicata 960
- Calabria 960
- Campania 960
- Emilia-Romagna 960
- Friuli Venezia Giulia 960
- Lazio 960
- Liguria 960
- Lombardia 960
- Marche 960
- Molise 960
- P.A. Bolzano 960
- P.A. Trento 960
- Piemonte 960
- Puglia 960
- Sardegna 960
- Sicilia 960
- Toscana 960
- Umbria 960
- Valle d'Aosta 960
- Veneto 960
country_or_region 1
- Italy · 20,223 ✖
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1720090 | 1720090 | 2020-02-19 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1750823 | 1750823 | 2020-04-04 | Italy | 124632 | 15362 | 20996 | 88274 | 41.87194 | 12.56738 | 4/4/20 23:34 | Italy | |||
1783122 | 1783122 | 2020-02-18 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1872512 | 1872512 | 2020-03-30 | Italy | 101739 | 11591 | 14620 | 75528 | 41.87194 | 12.56738 | 3/30/20 22:52 | Italy | |||
1888749 | 1888749 | 2020-02-16 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1931987 | 1931987 | 2020-05-05 | Italy | 213013 | 29315 | 85231 | 98467 | 41.87194 | 12.56738 | 2020-05-06 02:32:31 | Italy | |||
2043385 | 2043385 | 2020-05-02 | Italy | 209328 | 28710 | 79914 | 100704 | 41.87194 | 12.56738 | 2020-05-03 02:32:28 | Italy | |||
2091709 | 2091709 | 2020-02-05 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2110947 | 2110947 | 2020-05-06 | Italy | 214457 | 29684 | 93245 | 91528 | 41.87194 | 12.56738 | 2020-05-07 02:32:28 | Italy | |||
2111087 | 2111087 | 2020-03-14 | Italy | 21157 | 1441 | 1966 | 41.8719 | 12.5674 | 2020-03-14T20:13:16 | |||||
2127431 | 2127431 | 2020-03-11 | Italy | 12462 | 827 | 1045 | 43.0 | 12.0 | 2020-03-11T21:33:02 | |||||
2135744 | 2135744 | 2020-02-21 | Italy | 20 | 1 | 0 | 2020-02-21T23:33:06 | |||||||
2147188 | 2147188 | 2020-03-23 | Italy | 63927 | 6077 | 7432 | 50418 | 41.87194 | 12.56738 | 2020-03-23 23:19:21 | Italy | |||
2255113 | 2255113 | 2020-03-16 | Italy | 27980 | 2158 | 2749 | 41.8719 | 12.5674 | 2020-03-16T17:33:03 | |||||
2263499 | 2263499 | 2020-02-20 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2278709 | 2278709 | 2020-05-03 | Italy | 210717 | 28884 | 81654 | 100179 | 41.87194 | 12.56738 | 2020-05-04 02:32:28 | Italy | |||
2282861 | 2282861 | 2020-03-12 | Italy | 12462 | 827 | 1045 | 43.0 | 12.0 | 2020-03-11T21:33:02 | |||||
2379275 | 2379275 | 2020-02-02 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2473490 | 2473490 | 2020-04-20 | Italy | 181228 | 24114 | 48877 | 108237 | 41.87194 | 12.56738 | 2020-04-20 23:36:27 | Italy | |||
2509760 | 2509760 | 2020-02-26 | Italy | 453 | 12 | 3 | 2020-02-26T23:43:03 | |||||||
2524892 | 2524892 | 2020-04-23 | Italy | 189973 | 25549 | 57576 | 106848 | 41.87194 | 12.56738 | 2020-04-24 03:30:31 | Italy | |||
2567106 | 2567106 | 2020-04-11 | Italy | 152271 | 19468 | 32534 | 100269 | 41.87194 | 12.56738 | 2020-04-11 22:45:13 | Italy | |||
2567291 | 2567291 | 2020-02-12 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2578269 | 2578269 | 2020-04-12 | Italy | 156363 | 19899 | 34211 | 102253 | 41.87194 | 12.56738 | 2020-04-12 23:17:00 | Italy | |||
2581544 | 2581544 | 2020-05-12 | Italy | 221216 | 30911 | 109039 | 81266 | 41.87194 | 12.56738 | 2020-05-13 03:32:26 | Italy | |||
2860589 | 2860589 | 2020-02-03 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2875748 | 2875748 | 2020-03-29 | Italy | 97689 | 10779 | 13030 | 73880 | 41.87194 | 12.56738 | 3/29/20 23:08 | Italy | |||
2883913 | 2883913 | 2020-02-28 | Italy | 888 | 21 | 46 | 2020-02-28T20:13:09 | |||||||
2899234 | 2899234 | 2020-05-09 | Italy | 218268 | 30395 | 103031 | 84842 | 41.87194 | 12.56738 | 2020-05-10 02:32:30 | Italy | |||
2910637 | 2910637 | 2020-03-22 | Italy | 59138 | 5476 | 7024 | 46638 | 41.87194 | 12.56738 | 3/22/20 23:45 | Italy | |||
3021810 | 3021810 | 2020-04-07 | Italy | 135586 | 17127 | 24392 | 94067 | 41.87194 | 12.56738 | 2020-04-07 23:04:29 | Italy | |||
3084850 | 3084850 | 2020-05-04 | Italy | 211938 | 29079 | 82879 | 99980 | 41.87194 | 12.56738 | 2020-05-05 02:32:34 | Italy | |||
3089049 | 3089049 | 2020-02-10 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3173359 | 3173359 | 2020-02-23 | Italy | 155 | 3 | 2 | 2020-02-23T23:43:02 | |||||||
3177478 | 3177478 | 2020-03-06 | Italy | 4636 | 197 | 523 | 43.0 | 12.0 | 2020-03-06T17:33:03 | |||||
3197750 | 3197750 | 2020-02-11 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3205787 | 3205787 | 2020-02-29 | Italy | 1128 | 29 | 46 | 2020-02-29T18:03:05 | |||||||
3222046 | 3222046 | 2020-02-07 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3295726 | 3295726 | 2020-05-07 | Italy | 215858 | 29958 | 96276 | 89624 | 41.87194 | 12.56738 | 2020-05-08 02:32:32 | Italy | |||
3331078 | 3331078 | 2020-05-11 | Italy | 219814 | 30739 | 106587 | 82488 | 41.87194 | 12.56738 | 2020-05-12 03:32:27 | Italy | |||
3338146 | 3338146 | 2020-04-14 | Italy | 162488 | 21067 | 37130 | 104291 | 41.87194 | 12.56738 | 2020-04-14 23:33:12 | Italy | |||
3362417 | 3362417 | 2020-02-09 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3364868 | 3364868 | 2020-04-01 | Italy | 110574 | 13155 | 16847 | 80572 | 41.87194 | 12.56738 | 2020-04-01 21:58:34 | Italy | |||
3413185 | 3413185 | 2020-02-01 | Italy | 2 | 0 | 0 | 1/31/2020 8:15 | |||||||
3459693 | 3459693 | 2020-05-10 | Italy | 219070 | 30560 | 105186 | 83324 | 41.87194 | 12.56738 | 2020-05-11 02:32:30 | Italy | |||
3471925 | 3471925 | 2020-02-04 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
3502902 | 3502902 | 2020-04-25 | Italy | 195351 | 26384 | 63120 | 105847 | 41.87194 | 12.56738 | 2020-04-26 02:30:31 | Italy | |||
3551213 | 3551213 | 2020-02-24 | Italy | 229 | 7 | 1 | 2020-02-24T23:43:01 | |||||||
3562135 | 3562135 | 2020-04-08 | Italy | 139422 | 17669 | 26491 | 95262 | 41.87194 | 12.56738 | 2020-04-08 22:51:39 | Italy | |||
3589375 | 3589375 | 2020-04-27 | Italy | 199414 | 26977 | 66624 | 105813 | 41.87194 | 12.56738 | 2020-04-28 02:30:32 | Italy | |||
3592553 | 3592553 | 2020-04-26 | Italy | 197675 | 26644 | 64928 | 106103 | 41.87194 | 12.56738 | 2020-04-27 02:30:33 | Italy | |||
3627492 | 3627492 | 2020-04-06 | Italy | 132547 | 16523 | 22837 | 93187 | 41.87194 | 12.56738 | 4/6/20 23:21 | Italy | |||
3701664 | 3701664 | 2020-04-02 | Italy | 115242 | 13915 | 18278 | 83049 | 41.87194 | 12.56738 | 4/2/20 23:25 | Italy | |||
3733921 | 3733921 | 2020-03-20 | Italy | 47021 | 4032 | 4440 | 41.8719 | 12.5674 | 2020-03-20T17:43:03 | |||||
3740634 | 3740634 | 2020-04-03 | Italy | 119827 | 14681 | 19758 | 85388 | 41.87194 | 12.56738 | 2020-04-03 22:46:20 | Italy | |||
3752815 | 3752815 | 2020-03-10 | Italy | 10149 | 631 | 724 | 43.0 | 12.0 | 2020-03-10T17:53:02 | |||||
3761223 | 3761223 | 2020-01-31 | Italy | 2 | 0 | 0 | 1/31/2020 23:59 | |||||||
3765346 | 3765346 | 2020-03-13 | Italy | 17660 | 1266 | 1439 | 41.8719 | 12.5674 | 2020-03-11T20:00:00 | |||||
3815961 | 3815961 | 2020-03-31 | Italy | 105792 | 12428 | 15729 | 77635 | 41.87194 | 12.56738 | 2020-03-31 23:43:43 | Italy | |||
3847337 | 3847337 | 2020-05-13 | Italy | 222104 | 31106 | 112541 | 78457 | 41.87194 | 12.56738 | 2020-05-14 03:32:28 | Italy | |||
3891307 | 3891307 | 2020-03-17 | Italy | 31506 | 2503 | 2941 | 41.8719 | 12.5674 | 2020-03-17T18:33:02 | |||||
3947084 | 3947084 | 2020-03-28 | Italy | 92472 | 10023 | 12384 | 70065 | 41.87194 | 12.56738 | 3/28/20 23:05 | Italy | |||
3950028 | 3950028 | 2020-04-09 | Italy | 143626 | 18279 | 28470 | 96877 | 41.87194 | 12.56738 | 2020-04-09 23:02:19 | Italy | |||
292 | 292 | 2021-12-02 | Italy | Abruzzo | 88379 | 2595 | 0 | 42.35122196 | 13.39843823 | 2021-12-03 04:23:05 | Abruzzo, Italy | |||
4308 | 4308 | 2021-10-28 | Italy | Abruzzo | 82646 | 2559 | 0 | 42.35122196 | 13.39843823 | 2021-10-29 04:22:03 | Abruzzo, Italy | |||
8310 | 8310 | 2020-10-25 | Italy | Abruzzo | 8068 | 514 | 3469 | 4085 | 42.35122196 | 13.39843823 | 2020-10-26 04:25:02 | Abruzzo, Italy | ||
12318 | 12318 | 2021-01-26 | Italy | Abruzzo | 41107 | 1435 | 29625 | 10047 | 42.35122196 | 13.39843823 | 2021-01-27 05:23:41 | Abruzzo, Italy | ||
16333 | 16333 | 2021-09-18 | Italy | Abruzzo | 80616 | 2535 | 0 | 42.35122196 | 13.39843823 | 2021-09-19 04:21:34 | Abruzzo, Italy | |||
20348 | 20348 | 2021-05-28 | Italy | Abruzzo | 73917 | 2478 | 65935 | 5504 | 42.35122196 | 13.39843823 | 2021-05-29 04:20:41 | Abruzzo, Italy | ||
24363 | 24363 | 2022-03-20 | Italy | Abruzzo | 291512 | 3040 | 0 | 42.35122196 | 13.39843823 | 2022-03-21 04:20:50 | Abruzzo, Italy | |||
28378 | 28378 | 2021-11-11 | Italy | Abruzzo | 84246 | 2566 | 0 | 42.35122196 | 13.39843823 | 2021-11-12 04:22:01 | Abruzzo, Italy | |||
32394 | 32394 | 2021-08-25 | Italy | Abruzzo | 78544 | 2523 | 0 | 42.35122196 | 13.39843823 | 2021-08-26 04:21:28 | Abruzzo, Italy | |||
36408 | 36408 | 2021-04-12 | Italy | Abruzzo | 68091 | 2248 | 55433 | 10410 | 42.35122196 | 13.39843823 | 2021-04-13 04:20:37 | Abruzzo, Italy | ||
43670 | 43670 | 2021-11-02 | Italy | Abruzzo | 83051 | 2562 | 0 | 42.35122196 | 13.39843823 | 2021-11-03 06:22:09 | Abruzzo, Italy | |||
50769 | 50769 | 2021-05-29 | Italy | Abruzzo | 73972 | 2480 | 65983 | 5509 | 42.35122196 | 13.39843823 | 2021-05-30 04:20:55 | Abruzzo, Italy | ||
54783 | 54783 | 2021-03-07 | Italy | Abruzzo | 57497 | 1801 | 42131 | 13565 | 42.35122196 | 13.39843823 | 2021-03-08 05:24:48 | Abruzzo, Italy | ||
61741 | 61741 | 2020-07-23 | Italy | Abruzzo | 3352 | 470 | 2767 | 115 | 42.35122196 | 13.39843823 | 2020-07-24 05:30:40 | Abruzzo, Italy | ||
63024 | 63024 | 2022-11-12 | Italy | Abruzzo | 595025 | 3727 | 0 | 42.35122196 | 13.39843823 | 2022-11-13 04:21:14 | Abruzzo, Italy | |||
67039 | 67039 | 2021-09-01 | Italy | Abruzzo | 79165 | 2530 | 0 | 42.35122196 | 13.39843823 | 2021-09-02 04:21:15 | Abruzzo, Italy | |||
71053 | 71053 | 2022-02-07 | Italy | Abruzzo | 232079 | 2846 | 0 | 42.35122196 | 13.39843823 | 2022-02-08 04:21:15 | Abruzzo, Italy | |||
75067 | 75067 | 2020-12-03 | Italy | Abruzzo | 29196 | 940 | 10428 | 17828 | 42.35122196 | 13.39843823 | 2020-12-04 05:27:27 | Abruzzo, Italy | ||
79066 | 79066 | 2020-10-14 | Italy | Abruzzo | 5446 | 489 | 3156 | 1801 | 42.35122196 | 13.39843823 | 2020-10-15 04:24:28 | Abruzzo, Italy | ||
83073 | 83073 | 2021-05-25 | Italy | Abruzzo | 73744 | 2471 | 65449 | 5824 | 42.35122196 | 13.39843823 | 2021-05-26 04:20:35 | Abruzzo, Italy | ||
87087 | 87087 | 2021-11-09 | Italy | Abruzzo | 83882 | 2566 | 0 | 42.35122196 | 13.39843823 | 2021-11-10 04:21:38 | Abruzzo, Italy | |||
91104 | 91104 | 2022-07-23 | Italy | Abruzzo | 491369 | 3434 | 0 | 42.35122196 | 13.39843823 | 2022-07-24 04:20:47 | Abruzzo, Italy | |||
98071 | 98071 | 2020-08-04 | Italy | Abruzzo | 3401 | 472 | 2804 | 125 | 42.35122196 | 13.39843823 | 2020-08-05 04:34:43 | Abruzzo, Italy | ||
99288 | 99288 | 2022-01-14 | Italy | Abruzzo | 159002 | 2689 | 0 | 42.35122196 | 13.39843823 | 2022-01-15 04:21:07 | Abruzzo, Italy | |||
103304 | 103304 | 2021-08-15 | Italy | Abruzzo | 77535 | 2518 | 0 | 42.35122196 | 13.39843823 | 2021-08-16 04:21:31 | Abruzzo, Italy | |||
107429 | 107429 | 2021-06-19 | Italy | Abruzzo | 74601 | 2509 | 70837 | 1255 | 42.35122196 | 13.39843823 | 2021-06-20 04:21:48 | Abruzzo, Italy | ||
114714 | 114714 | 2022-09-06 | Italy | Abruzzo | 543231 | 3643 | 0 | 42.35122196 | 13.39843823 | 2022-09-07 04:20:59 | Abruzzo, Italy | |||
121664 | 121664 | 2020-07-19 | Italy | Abruzzo | 3336 | 468 | 2751 | 117 | 42.35122196 | 13.39843823 | 2020-07-20 05:34:40 | Abruzzo, Italy | ||
122682 | 122682 | 2020-11-18 | Italy | Abruzzo | 21193 | 712 | 6091 | 14390 | 42.35122196 | 13.39843823 | 2020-11-19 05:25:23 | Abruzzo, Italy | ||
126695 | 126695 | 2022-01-09 | Italy | Abruzzo | 140545 | 2670 | 0 | 42.35122196 | 13.39843823 | 2022-01-10 04:22:07 | Abruzzo, Italy | |||
130712 | 130712 | 2022-10-04 | Italy | Abruzzo | 563661 | 3676 | 0 | 42.35122196 | 13.39843823 | 2022-10-05 04:23:06 | Abruzzo, Italy | |||
137933 | 137933 | 2021-12-04 | Italy | Abruzzo | 88943 | 2598 | 0 | 42.35122196 | 13.39843823 | 2021-12-05 04:22:25 | Abruzzo, Italy | |||
141950 | 141950 | 2022-07-09 | Italy | Abruzzo | 453988 | 3396 | 0 | 42.35122196 | 13.39843823 | 2022-07-10 04:20:54 | Abruzzo, Italy | |||
145950 | 145950 | 2020-08-15 | Italy | Abruzzo | 3558 | 472 | 2834 | 252 | 42.35122196 | 13.39843823 | 2020-08-16 04:27:42 | Abruzzo, Italy | ||
149946 | 149946 | 2021-11-29 | Italy | Abruzzo | 87502 | 2589 | 0 | 42.35122196 | 13.39843823 | 2021-11-30 04:22:53 | Abruzzo, Italy | |||
153961 | 153961 | 2021-01-08 | Italy | Abruzzo | 37038 | 1269 | 24672 | 11097 | 42.35122196 | 13.39843823 | 2021-01-09 05:22:18 | Abruzzo, Italy | ||
157975 | 157975 | 2022-03-29 | Italy | Abruzzo | 310256 | 3083 | 0 | 42.35122196 | 13.39843823 | 2022-03-30 04:20:45 | Abruzzo, 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]);