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 combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, day (date)
last_update (date) >30 ✖
- 2022-04-13 42
- 2022-05-26 42
- 2020-05-15 21
- 2020-05-16 21
- 2020-05-17 21
- 2020-05-18 21
- 2020-05-19 21
- 2020-05-20 21
- 2020-05-21 21
- 2020-05-22 21
- 2020-05-23 21
- 2020-05-24 21
- 2020-05-25 21
- 2020-05-26 21
- 2020-05-27 21
- 2020-05-28 21
- 2020-05-29 21
- 2020-05-30 21
- 2020-05-31 21
- 2020-06-01 21
- 2020-06-02 21
- 2020-06-03 21
- 2020-06-04 21
- 2020-06-05 21
- 2020-06-06 21
- 2020-06-07 21
- 2020-06-08 21
- 2020-06-09 21
- 2020-06-10 21
- 2020-06-11 21
- …
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,264 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40133 | 40133 | 2020-03-05 | Italy | 3858 | 148 | 414 | 43.0 | 12.0 | 2020-03-05T17:43:03 | |||||
62473 | 62473 | 2020-03-07 | Italy | 5883 | 233 | 589 | 43.0 | 12.0 | 2020-03-07T17:33:03 | |||||
98803 | 98803 | 2020-03-04 | Italy | 3089 | 107 | 276 | 43.0 | 12.0 | 2020-03-04T19:23:03 | |||||
107075 | 107075 | 2020-02-15 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
261018 | 261018 | 2020-03-03 | Italy | 2502 | 79 | 160 | 43.0 | 12.0 | 2020-03-03T20:03:06 | |||||
339624 | 339624 | 2020-03-21 | Italy | 53578 | 4825 | 6072 | 41.8719 | 12.5674 | 2020-03-21T17:43:03 | |||||
479145 | 479145 | 2020-02-25 | Italy | 322 | 10 | 1 | 2020-02-25T18:55:32 | |||||||
562495 | 562495 | 2020-03-01 | Italy | 1694 | 34 | 83 | 43.0 | 12.0 | 2020-03-01T23:23:02 | |||||
566716 | 566716 | 2020-02-06 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
617400 | 617400 | 2020-02-27 | Italy | 655 | 17 | 45 | 2020-02-27T23:23:02 | |||||||
657684 | 657684 | 2020-03-09 | Italy | 9172 | 463 | 724 | 43.0 | 12.0 | 2020-03-09T18:13:11 | |||||
1085660 | 1085660 | 2020-02-22 | Italy | 62 | 2 | 1 | 2020-02-22T23:43:02 | |||||||
1152634 | 1152634 | 2020-03-02 | Italy | 2036 | 52 | 149 | 43.0 | 12.0 | 2020-03-02T20:23:16 | |||||
1176876 | 1176876 | 2020-03-18 | Italy | 35713 | 2978 | 4025 | 41.8719 | 12.5674 | 2020-03-18T17:33:05 | |||||
1192494 | 1192494 | 2020-02-14 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1243396 | 1243396 | 2020-02-17 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1366087 | 1366087 | 2020-02-08 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1463462 | 1463462 | 2020-03-15 | Italy | 24747 | 1809 | 2335 | 41.8719 | 12.5674 | 2020-03-14T20:13:16 | |||||
1526872 | 1526872 | 2020-03-19 | Italy | 41035 | 3405 | 4440 | 41.8719 | 12.5674 | 2020-03-19T17:43:03 | |||||
1527200 | 1527200 | 2020-03-08 | Italy | 7375 | 366 | 622 | 43.0 | 12.0 | 2020-03-08T18:03:04 | |||||
1559701 | 1559701 | 2020-02-13 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1720090 | 1720090 | 2020-02-19 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1783122 | 1783122 | 2020-02-18 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1888749 | 1888749 | 2020-02-16 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2091709 | 2091709 | 2020-02-05 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
2509760 | 2509760 | 2020-02-26 | Italy | 453 | 12 | 3 | 2020-02-26T23:43:03 | |||||||
2567291 | 2567291 | 2020-02-12 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2860589 | 2860589 | 2020-02-03 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2883913 | 2883913 | 2020-02-28 | Italy | 888 | 21 | 46 | 2020-02-28T20:13:09 | |||||||
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 | |||||||
3362417 | 3362417 | 2020-02-09 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3413185 | 3413185 | 2020-02-01 | Italy | 2 | 0 | 0 | 1/31/2020 8:15 | |||||||
3471925 | 3471925 | 2020-02-04 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
3551213 | 3551213 | 2020-02-24 | Italy | 229 | 7 | 1 | 2020-02-24T23:43:01 | |||||||
3733921 | 3733921 | 2020-03-20 | Italy | 47021 | 4032 | 4440 | 41.8719 | 12.5674 | 2020-03-20T17:43:03 | |||||
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 | |||||
3891307 | 3891307 | 2020-03-17 | Italy | 31506 | 2503 | 2941 | 41.8719 | 12.5674 | 2020-03-17T18:33:02 | |||||
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 | |||
161990 | 161990 | 2021-11-19 | Italy | Abruzzo | 85661 | 2574 | 0 | 42.35122196 | 13.39843823 | 2021-11-20 04:22:17 | Abruzzo, Italy | |||
166007 | 166007 | 2022-06-21 | Italy | Abruzzo | 418437 | 3369 | 0 | 42.35122196 | 13.39843823 | 2022-06-22 04:20:54 | Abruzzo, Italy | |||
170022 | 170022 | 2021-04-16 | Italy | Abruzzo | 68948 | 2315 | 56737 | 9896 | 42.35122196 | 13.39843823 | 2021-04-17 04:20:40 | Abruzzo, Italy | ||
176982 | 176982 | 2020-07-27 | Italy | Abruzzo | 3368 | 471 | 2783 | 114 | 42.35122196 | 13.39843823 | 2020-07-28 04:58:43 | Abruzzo, Italy | ||
178004 | 178004 | 2021-09-02 | Italy | Abruzzo | 79317 | 2531 | 0 | 42.35122196 | 13.39843823 | 2021-09-03 04:21:20 | Abruzzo, Italy | |||
182018 | 182018 | 2021-02-21 | Italy | Abruzzo | 51093 | 1620 | 36549 | 12924 | 42.35122196 | 13.39843823 | 2021-02-22 05:24:21 | Abruzzo, Italy | ||
186033 | 186033 | 2022-02-13 | Italy | Abruzzo | 243678 | 2881 | 0 | 42.35122196 | 13.39843823 | 2022-02-14 04:20:51 | Abruzzo, Italy | |||
190047 | 190047 | 2021-01-11 | Italy | Abruzzo | 37873 | 1285 | 25208 | 11380 | 42.35122196 | 13.39843823 | 2021-01-12 05:22:15 | Abruzzo, Italy | ||
194045 | 194045 | 2020-08-31 | Italy | Abruzzo | 3777 | 472 | 2878 | 427 | 42.35122196 | 13.39843823 | 2020-09-01 04:28:31 | Abruzzo, Italy | ||
198221 | 198221 | 2022-10-19 | Italy | Abruzzo | 579179 | 3692 | 0 | 42.35122196 | 13.39843823 | 2022-10-20 04:22:59 | Abruzzo, Italy | |||
202234 | 202234 | 2020-12-25 | Italy | Abruzzo | 34437 | 1162 | 21408 | 11867 | 42.35122196 | 13.39843823 | 2020-12-26 05:22:28 | Abruzzo, Italy | ||
206232 | 206232 | 2020-08-19 | Italy | Abruzzo | 3577 | 472 | 2840 | 265 | 42.35122196 | 13.39843823 | 2020-08-20 04:27:43 | 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]);