daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
combined_key 22 ✖
- Abruzzo, Italy 960
- Basilicata, Italy 960
- Calabria, Italy 960
- Campania, Italy 960
- Emilia-Romagna, Italy 960
- Friuli Venezia Giulia, Italy 960
- Lazio, Italy 960
- Liguria, Italy 960
- Lombardia, Italy 960
- Marche, Italy 960
- Molise, Italy 960
- P.A. Bolzano, Italy 960
- P.A. Trento, Italy 960
- Piemonte, Italy 960
- Puglia, Italy 960
- Sardegna, Italy 960
- Sicilia, Italy 960
- Toscana, Italy 960
- Umbria, Italy 960
- Valle d'Aosta, Italy 960
- Veneto, Italy 960
- Italy 53
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 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-02-06 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-02-05 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-02-02 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-02-03 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-02-01 | Italy | 2 | 0 | 0 | 1/31/2020 8:15 | |||||||
2020-02-04 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-01-31 | Italy | 2 | 0 | 0 | 1/31/2020 23:59 | |||||||
2020-02-15 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-14 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-17 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-08 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-13 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-19 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-18 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-16 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-20 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-12 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-10 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-11 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-07 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-09 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-21 | Italy | 20 | 1 | 0 | 2020-02-21T23:33:06 | |||||||
2020-02-22 | Italy | 62 | 2 | 1 | 2020-02-22T23:43:02 | |||||||
2020-02-23 | Italy | 155 | 3 | 2 | 2020-02-23T23:43:02 | |||||||
2020-02-24 | Italy | 229 | 7 | 1 | 2020-02-24T23:43:01 | |||||||
2020-02-25 | Italy | 322 | 10 | 1 | 2020-02-25T18:55:32 | |||||||
2020-05-14 | Italy | Basilicata | 389 | 27 | 235 | 127 | 40.63947052 | 15.80514834 | 2020-05-15 02:33:02 | Basilicata, Italy | ||
2020-05-15 | Italy | Basilicata | 389 | 27 | 242 | 120 | 40.63947052 | 15.80514834 | 2020-05-16 02:32:19 | Basilicata, Italy | ||
2020-05-16 | Italy | Basilicata | 390 | 27 | 250 | 113 | 40.63947052 | 15.80514834 | 2020-05-17 02:32:32 | Basilicata, Italy | ||
2020-05-18 | Italy | Basilicata | 392 | 27 | 272 | 93 | 40.63947052 | 15.80514834 | 2020-05-19 02:32:18 | Basilicata, Italy | ||
2020-05-17 | Italy | Basilicata | 392 | 27 | 261 | 104 | 40.63947052 | 15.80514834 | 2020-05-18 02:32:21 | Basilicata, Italy | ||
2020-05-20 | Italy | Basilicata | 393 | 27 | 293 | 73 | 40.63947052 | 15.80514834 | 2020-05-21 02:32:48 | Basilicata, Italy | ||
2020-05-19 | Italy | Basilicata | 393 | 27 | 282 | 84 | 40.63947052 | 15.80514834 | 2020-05-20 02:32:19 | Basilicata, Italy | ||
2020-05-21 | Italy | Basilicata | 394 | 27 | 307 | 60 | 40.63947052 | 15.80514834 | 2020-05-22 02:36:51 | Basilicata, Italy | ||
2020-05-22 | Italy | Basilicata | 394 | 27 | 318 | 49 | 40.63947052 | 15.80514834 | 2020-05-23 02:32:42 | Basilicata, Italy | ||
2020-05-23 | Italy | Basilicata | 398 | 27 | 330 | 41 | 40.63947052 | 15.80514834 | 2020-05-24 02:32:43 | Basilicata, Italy | ||
2020-06-08 | Italy | Basilicata | 399 | 27 | 359 | 13 | 40.63947052 | 15.80514834 | 2020-06-09 03:33:03 | Basilicata, Italy | ||
2020-06-06 | Italy | Basilicata | 399 | 27 | 355 | 17 | 40.63947052 | 15.80514834 | 2020-06-07 03:53:30 | Basilicata, Italy | ||
2020-06-01 | Italy | Basilicata | 399 | 27 | 344 | 28 | 40.63947052 | 15.80514834 | 2020-06-02 02:33:08 | Basilicata, Italy | ||
2020-05-24 | Italy | Basilicata | 399 | 27 | 333 | 39 | 40.63947052 | 15.80514834 | 2020-05-25 02:32:44 | Basilicata, Italy | ||
2020-05-26 | Italy | Basilicata | 399 | 27 | 336 | 36 | 40.63947052 | 15.80514834 | 2020-05-27 02:32:31 | Basilicata, Italy | ||
2020-05-25 | Italy | Basilicata | 399 | 27 | 336 | 36 | 40.63947052 | 15.80514834 | 2020-05-26 02:32:35 | Basilicata, Italy | ||
2020-06-05 | Italy | Basilicata | 399 | 27 | 354 | 18 | 40.63947052 | 15.80514834 | 2020-06-06 02:33:00 | Basilicata, Italy | ||
2020-06-04 | Italy | Basilicata | 399 | 27 | 352 | 20 | 40.63947052 | 15.80514834 | 2020-06-05 02:33:06 | Basilicata, Italy | ||
2020-05-29 | Italy | Basilicata | 399 | 27 | 339 | 33 | 40.63947052 | 15.80514834 | 2020-05-30 02:32:48 | Basilicata, Italy | ||
2020-05-31 | Italy | Basilicata | 399 | 27 | 343 | 29 | 40.63947052 | 15.80514834 | 2020-06-01 02:32:46 | Basilicata, Italy | ||
2020-05-27 | Italy | Basilicata | 399 | 27 | 336 | 36 | 40.63947052 | 15.80514834 | 2020-05-28 02:32:31 | Basilicata, Italy | ||
2020-06-02 | Italy | Basilicata | 399 | 27 | 348 | 24 | 40.63947052 | 15.80514834 | 2020-06-03 02:33:13 | Basilicata, Italy | ||
2020-05-28 | Italy | Basilicata | 399 | 27 | 338 | 34 | 40.63947052 | 15.80514834 | 2020-05-29 02:32:50 | Basilicata, Italy | ||
2020-06-07 | Italy | Basilicata | 399 | 27 | 358 | 14 | 40.63947052 | 15.80514834 | 2020-06-08 03:33:22 | Basilicata, Italy | ||
2020-05-30 | Italy | Basilicata | 399 | 27 | 341 | 31 | 40.63947052 | 15.80514834 | 2020-05-31 02:32:45 | Basilicata, Italy | ||
2020-06-03 | Italy | Basilicata | 399 | 27 | 349 | 23 | 40.63947052 | 15.80514834 | 2020-06-04 02:33:14 | Basilicata, Italy | ||
2020-06-09 | Italy | Basilicata | 400 | 27 | 359 | 14 | 40.63947052 | 15.80514834 | 2020-06-10 04:07:00 | Basilicata, Italy | ||
2020-06-10 | Italy | Basilicata | 400 | 27 | 362 | 11 | 40.63947052 | 15.80514834 | 2020-06-11 03:33:41 | Basilicata, Italy | ||
2020-06-15 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-16 04:33:09 | Basilicata, Italy | ||
2020-06-12 | Italy | Basilicata | 401 | 27 | 362 | 12 | 40.63947052 | 15.80514834 | 2020-06-13 03:33:14 | Basilicata, Italy | ||
2020-06-26 | Italy | Basilicata | 401 | 27 | 367 | 7 | 40.63947052 | 15.80514834 | 2020-06-27 04:33:35 | Basilicata, Italy | ||
2020-06-17 | Italy | Basilicata | 401 | 27 | 364 | 10 | 40.63947052 | 15.80514834 | 2020-06-18 04:33:18 | Basilicata, Italy | ||
2020-06-11 | Italy | Basilicata | 401 | 27 | 362 | 12 | 40.63947052 | 15.80514834 | 2020-06-12 05:09:52 | Basilicata, Italy | ||
2020-06-22 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-23 04:33:22 | Basilicata, Italy | ||
2020-06-23 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-24 04:33:28 | Basilicata, Italy | ||
2020-06-19 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-20 04:33:19 | Basilicata, Italy | ||
2020-06-14 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-15 03:33:14 | Basilicata, Italy | ||
2020-06-27 | Italy | Basilicata | 401 | 27 | 367 | 7 | 40.63947052 | 15.80514834 | 2020-06-28 04:34:04 | Basilicata, Italy | ||
2020-06-28 | Italy | Basilicata | 401 | 27 | 372 | 2 | 40.63947052 | 15.80514834 | 2020-06-29 04:33:44 | Basilicata, Italy | ||
2020-06-16 | Italy | Basilicata | 401 | 27 | 364 | 10 | 40.63947052 | 15.80514834 | 2020-06-17 04:33:21 | Basilicata, Italy | ||
2020-06-20 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-21 04:33:19 | Basilicata, Italy | ||
2020-06-25 | Italy | Basilicata | 401 | 27 | 367 | 7 | 40.63947052 | 15.80514834 | 2020-06-26 04:33:43 | Basilicata, Italy | ||
2020-06-24 | Italy | Basilicata | 401 | 27 | 367 | 7 | 40.63947052 | 15.80514834 | 2020-06-25 05:26:54 | Basilicata, Italy | ||
2020-06-13 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-14 03:33:15 | Basilicata, Italy | ||
2020-06-21 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-22 04:33:20 | Basilicata, Italy | ||
2020-06-18 | Italy | Basilicata | 401 | 27 | 364 | 10 | 40.63947052 | 15.80514834 | 2020-06-19 04:33:17 | Basilicata, Italy | ||
2020-07-01 | Italy | Basilicata | 402 | 27 | 373 | 2 | 40.63947052 | 15.80514834 | 2020-07-02 04:33:46 | Basilicata, Italy | ||
2020-06-29 | Italy | Basilicata | 402 | 27 | 372 | 3 | 40.63947052 | 15.80514834 | 2020-06-30 04:33:48 | Basilicata, Italy | ||
2020-06-30 | Italy | Basilicata | 402 | 27 | 372 | 3 | 40.63947052 | 15.80514834 | 2020-07-01 04:33:52 | Basilicata, Italy | ||
2020-07-02 | Italy | Basilicata | 402 | 27 | 373 | 2 | 40.63947052 | 15.80514834 | 2020-07-03 04:33:54 | Basilicata, Italy | ||
2020-05-14 | Italy | Molise | 403 | 22 | 152 | 229 | 41.55774754 | 14.65916051 | 2020-05-15 02:33:02 | Molise, Italy | ||
2020-07-05 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-06 04:33:57 | Basilicata, Italy | ||
2020-07-04 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-05 04:33:46 | Basilicata, Italy | ||
2020-07-07 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-08 05:33:48 | Basilicata, Italy | ||
2020-07-03 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-04 04:33:51 | Basilicata, Italy | ||
2020-07-06 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-07 04:34:00 | Basilicata, Italy | ||
2020-07-16 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-17 04:34:50 | Basilicata, Italy | ||
2020-07-09 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-10 04:34:24 | Basilicata, Italy | ||
2020-07-08 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-09 04:34:23 | Basilicata, Italy | ||
2020-07-17 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-18 04:34:45 | Basilicata, Italy | ||
2020-07-15 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-16 04:44:59 | Basilicata, Italy | ||
2020-07-18 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-19 04:34:58 | Basilicata, Italy | ||
2020-07-10 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-11 04:34:26 | Basilicata, Italy | ||
2020-07-14 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-15 04:34:39 | Basilicata, Italy | ||
2020-07-11 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-12 04:34:30 | Basilicata, Italy | ||
2020-07-13 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-14 04:34:46 | Basilicata, Italy | ||
2020-07-12 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-13 04:43:04 | Basilicata, Italy | ||
2020-05-15 | Italy | Molise | 407 | 22 | 158 | 227 | 41.55774754 | 14.65916051 | 2020-05-16 02:32:19 | Molise, Italy | ||
2020-07-19 | Italy | Basilicata | 408 | 28 | 373 | 7 | 40.63947052 | 15.80514834 | 2020-07-20 05:34:40 | Basilicata, Italy | ||
2020-07-20 | Italy | Basilicata | 408 | 28 | 373 | 7 | 40.63947052 | 15.80514834 | 2020-07-21 04:38:46 | Basilicata, Italy | ||
2020-07-21 | Italy | Basilicata | 408 | 28 | 373 | 7 | 40.63947052 | 15.80514834 | 2020-07-22 04:34:42 | Basilicata, Italy | ||
2020-05-16 | Italy | Molise | 410 | 22 | 173 | 215 | 41.55774754 | 14.65916051 | 2020-05-17 02:32:32 | Molise, Italy | ||
2020-05-17 | Italy | Molise | 411 | 22 | 173 | 216 | 41.55774754 | 14.65916051 | 2020-05-18 02:32:21 | Molise, Italy | ||
2020-05-20 | Italy | Molise | 422 | 22 | 202 | 198 | 41.55774754 | 14.65916051 | 2020-05-21 02:32:48 | Molise, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;