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 = "Lombardia" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1857991 | 1857991 | 2021-02-25 | Italy | Lombardia | 590804 | 28228 | 504748 | 57828 | 45.46679409 | 9.190347404 | 2021-02-26 05:22:40 | Lombardia, Italy | ||
280169 | 280169 | 2021-02-24 | Italy | Lombardia | 586561 | 28184 | 503152 | 55225 | 45.46679409 | 9.190347404 | 2021-02-25 05:24:57 | Lombardia, Italy | ||
1936437 | 1936437 | 2021-02-23 | Italy | Lombardia | 583251 | 28146 | 500390 | 54715 | 45.46679409 | 9.190347404 | 2021-02-24 05:29:16 | Lombardia, Italy | ||
530692 | 530692 | 2021-02-22 | Italy | Lombardia | 580771 | 28103 | 499299 | 53369 | 45.46679409 | 9.190347404 | 2021-02-23 05:23:41 | Lombardia, Italy | ||
182026 | 182026 | 2021-02-21 | Italy | Lombardia | 579280 | 28058 | 496177 | 55045 | 45.46679409 | 9.190347404 | 2021-02-22 05:24:21 | Lombardia, Italy | ||
742300 | 742300 | 2021-02-20 | Italy | Lombardia | 576766 | 28008 | 495393 | 53365 | 45.46679409 | 9.190347404 | 2021-02-21 05:24:33 | Lombardia, Italy | ||
471398 | 471398 | 2021-02-19 | Italy | Lombardia | 573747 | 27971 | 493987 | 51789 | 45.46679409 | 9.190347404 | 2021-02-20 05:22:51 | Lombardia, Italy | ||
1153107 | 1153107 | 2021-02-18 | Italy | Lombardia | 570023 | 27938 | 492112 | 49973 | 45.46679409 | 9.190347404 | 2021-02-19 05:24:16 | Lombardia, Italy | ||
3601027 | 3601027 | 2021-02-17 | Italy | Lombardia | 567483 | 27883 | 490907 | 48693 | 45.46679409 | 9.190347404 | 2021-02-18 05:22:58 | Lombardia, Italy | ||
3050162 | 3050162 | 2021-02-16 | Italy | Lombardia | 565719 | 27854 | 489192 | 48673 | 45.46679409 | 9.190347404 | 2021-02-17 05:23:10 | Lombardia, Italy | ||
1338261 | 1338261 | 2021-02-15 | Italy | Lombardia | 564023 | 27816 | 487577 | 48630 | 45.46679409 | 9.190347404 | 2021-02-16 05:24:38 | Lombardia, Italy | ||
2283412 | 2283412 | 2021-02-14 | Italy | Lombardia | 563078 | 27781 | 484680 | 50617 | 45.46679409 | 9.190347404 | 2021-02-15 05:24:49 | Lombardia, Italy | ||
2677812 | 2677812 | 2021-02-13 | Italy | Lombardia | 561091 | 27760 | 484180 | 49151 | 45.46679409 | 9.190347404 | 2021-02-14 05:23:43 | Lombardia, Italy | ||
3539445 | 3539445 | 2021-02-12 | Italy | Lombardia | 558814 | 27699 | 482645 | 48470 | 45.46679409 | 9.190347404 | 2021-02-13 05:22:12 | Lombardia, Italy | ||
2637708 | 2637708 | 2021-02-11 | Italy | Lombardia | 556288 | 27652 | 481626 | 47010 | 45.46679409 | 9.190347404 | 2021-02-12 05:23:29 | Lombardia, Italy | ||
3978563 | 3978563 | 2021-02-10 | Italy | Lombardia | 553854 | 27598 | 479645 | 46611 | 45.46679409 | 9.190347404 | 2021-02-11 05:23:55 | Lombardia, Italy | ||
1527883 | 1527883 | 2021-02-09 | Italy | Lombardia | 552005 | 27559 | 477407 | 47039 | 45.46679409 | 9.190347404 | 2021-02-10 05:22:41 | Lombardia, Italy | ||
613674 | 613674 | 2021-02-08 | Italy | Lombardia | 550380 | 27504 | 476502 | 46374 | 45.46679409 | 9.190347404 | 2021-02-09 05:23:30 | Lombardia, Italy | ||
1672443 | 1672443 | 2021-02-07 | Italy | Lombardia | 549485 | 27453 | 473192 | 48840 | 45.46679409 | 9.190347404 | 2021-02-08 05:22:39 | Lombardia, Italy | ||
974904 | 974904 | 2021-02-06 | Italy | Lombardia | 547970 | 27395 | 472266 | 48309 | 45.46679409 | 9.190347404 | 2021-02-07 05:23:00 | Lombardia, Italy | ||
1588162 | 1588162 | 2021-02-05 | Italy | Lombardia | 546047 | 27345 | 470500 | 48202 | 45.46679409 | 9.190347404 | 2021-02-06 05:23:55 | Lombardia, Italy | ||
790369 | 790369 | 2021-02-04 | Italy | Lombardia | 543543 | 27299 | 469348 | 46896 | 45.46679409 | 9.190347404 | 2021-02-05 05:22:38 | Lombardia, Italy | ||
340261 | 340261 | 2021-02-03 | Italy | Lombardia | 541797 | 27259 | 467193 | 47345 | 45.46679409 | 9.190347404 | 2021-02-04 05:22:26 | Lombardia, Italy | ||
1684487 | 1684487 | 2021-02-02 | Italy | Lombardia | 540059 | 27213 | 466287 | 46559 | 45.46679409 | 9.190347404 | 2021-02-03 05:22:52 | Lombardia, Italy | ||
1676457 | 1676457 | 2021-02-01 | Italy | Lombardia | 539147 | 27150 | 463522 | 48475 | 45.46679409 | 9.190347404 | 2021-02-02 05:22:49 | Lombardia, Italy | ||
1459745 | 1459745 | 2021-01-31 | Italy | Lombardia | 538054 | 27098 | 459879 | 51077 | 45.46679409 | 9.190347404 | 2021-02-01 05:22:53 | Lombardia, Italy | ||
2211653 | 2211653 | 2021-01-30 | Italy | Lombardia | 536616 | 27074 | 459401 | 50141 | 45.46679409 | 9.190347404 | 2021-01-31 05:22:42 | Lombardia, Italy | ||
1897140 | 1897140 | 2021-01-29 | Italy | Lombardia | 534784 | 27016 | 458254 | 49514 | 45.46679409 | 9.190347404 | 2021-01-30 05:22:49 | Lombardia, Italy | ||
2481956 | 2481956 | 2021-01-28 | Italy | Lombardia | 532884 | 26939 | 456106 | 49839 | 45.46679409 | 9.190347404 | 2021-01-29 05:22:23 | Lombardia, Italy | ||
3153591 | 3153591 | 2021-01-27 | Italy | Lombardia | 530281 | 26851 | 454392 | 49038 | 45.46679409 | 9.190347404 | 2021-01-28 05:22:24 | Lombardia, Italy | ||
12326 | 12326 | 2021-01-26 | Italy | Lombardia | 527988 | 26789 | 452231 | 48968 | 45.46679409 | 9.190347404 | 2021-01-27 05:23:41 | Lombardia, Italy | ||
2567650 | 2567650 | 2021-01-25 | Italy | Lombardia | 526758 | 26712 | 450069 | 49977 | 45.46679409 | 9.190347404 | 2021-01-26 05:22:02 | Lombardia, Italy | ||
1759282 | 1759282 | 2021-01-24 | Italy | Lombardia | 525274 | 26666 | 445604 | 53004 | 45.46679409 | 9.190347404 | 2021-01-25 05:22:16 | Lombardia, Italy | ||
2426889 | 2426889 | 2021-01-23 | Italy | Lombardia | 523899 | 26622 | 444809 | 52468 | 45.46679409 | 9.190347404 | 2021-01-24 05:22:35 | Lombardia, Italy | ||
2466791 | 2466791 | 2021-01-22 | Italy | Lombardia | 522364 | 26518 | 442631 | 53215 | 45.46679409 | 9.190347404 | 2021-01-23 05:22:03 | Lombardia, Italy | ||
435342 | 435342 | 2021-01-21 | Italy | Lombardia | 520395 | 26460 | 440880 | 53055 | 45.46679409 | 9.190347404 | 2021-01-22 05:22:10 | Lombardia, Italy | ||
1094074 | 1094074 | 2021-01-20 | Italy | Lombardia | 518161 | 26405 | 438058 | 53698 | 45.46679409 | 9.190347404 | 2021-01-21 05:22:01 | Lombardia, Italy | ||
908164 | 908164 | 2021-01-19 | Italy | Lombardia | 516285 | 26339 | 436485 | 53461 | 45.46679409 | 9.190347404 | 2021-01-20 05:21:54 | Lombardia, Italy | ||
237227 | 237227 | 2021-01-18 | Italy | Lombardia | 515355 | 26282 | 435509 | 53564 | 45.46679409 | 9.190347404 | 2021-01-19 05:22:15 | Lombardia, Italy | ||
3503344 | 3503344 | 2021-01-17 | Italy | Lombardia | 514166 | 26237 | 431787 | 56142 | 45.46679409 | 9.190347404 | 2021-01-18 05:22:34 | Lombardia, Italy | ||
3101427 | 3101427 | 2021-01-16 | Italy | Lombardia | 512563 | 26172 | 428393 | 57998 | 45.46679409 | 9.190347404 | 2021-01-17 05:22:17 | Lombardia, Italy | ||
3515389 | 3515389 | 2021-01-15 | Italy | Lombardia | 510429 | 26094 | 427181 | 57154 | 45.46679409 | 9.190347404 | 2021-01-16 05:22:40 | Lombardia, Italy | ||
3879562 | 3879562 | 2021-01-14 | Italy | Lombardia | 508224 | 26026 | 426098 | 56100 | 45.46679409 | 9.190347404 | 2021-01-15 05:22:24 | Lombardia, Italy | ||
3308189 | 3308189 | 2021-01-13 | Italy | Lombardia | 505637 | 25954 | 424720 | 54963 | 45.46679409 | 9.190347404 | 2021-01-14 05:22:32 | Lombardia, Italy | ||
774334 | 774334 | 2021-01-12 | Italy | Lombardia | 503392 | 25903 | 423074 | 54415 | 45.46679409 | 9.190347404 | 2021-01-13 05:22:15 | Lombardia, Italy | ||
190055 | 190055 | 2021-01-11 | Italy | Lombardia | 502246 | 25849 | 421890 | 54507 | 45.46679409 | 9.190347404 | 2021-01-12 05:22:15 | Lombardia, Italy | ||
2625858 | 2625858 | 2021-01-10 | Italy | Lombardia | 500758 | 25787 | 417173 | 57798 | 45.46679409 | 9.190347404 | 2021-01-11 05:21:50 | Lombardia, Italy | ||
3899946 | 3899946 | 2021-01-09 | Italy | Lombardia | 497491 | 25728 | 416326 | 55437 | 45.46679409 | 9.190347404 | 2021-01-10 05:22:12 | Lombardia, Italy | ||
153969 | 153969 | 2021-01-08 | Italy | Lombardia | 494985 | 25665 | 414643 | 54677 | 45.46679409 | 9.190347404 | 2021-01-09 05:22:18 | Lombardia, Italy | ||
2541393 | 2541393 | 2021-01-07 | Italy | Lombardia | 493022 | 25532 | 413248 | 54242 | 45.46679409 | 9.190347404 | 2021-01-08 05:22:42 | Lombardia, Italy | ||
2864702 | 2864702 | 2021-01-06 | Italy | Lombardia | 490223 | 25498 | 412034 | 52691 | 45.46679409 | 9.190347404 | 2021-01-07 05:22:03 | Lombardia, Italy | ||
3034289 | 3034289 | 2021-01-05 | Italy | Lombardia | 487271 | 25406 | 409548 | 52317 | 45.46679409 | 9.190347404 | 2021-01-06 05:22:16 | Lombardia, Italy | ||
1061834 | 1061834 | 2021-01-04 | Italy | Lombardia | 485933 | 25344 | 407902 | 52687 | 45.46679409 | 9.190347404 | 2021-01-05 05:21:49 | Lombardia, Italy | ||
3230437 | 3230437 | 2021-01-03 | Italy | Lombardia | 485070 | 25317 | 402798 | 56955 | 45.46679409 | 9.190347404 | 2021-01-04 05:22:02 | Lombardia, Italy | ||
2227506 | 2227506 | 2021-01-02 | Italy | Lombardia | 483361 | 25281 | 402070 | 56010 | 45.46679409 | 9.190347404 | 2021-01-03 05:22:52 | Lombardia, Italy | ||
1136870 | 1136870 | 2021-01-01 | Italy | Lombardia | 481959 | 25203 | 401444 | 55312 | 45.46679409 | 9.190347404 | 2021-01-02 05:22:33 | Lombardia, Italy | ||
3695476 | 3695476 | 2020-12-31 | Italy | Lombardia | 478903 | 25123 | 399157 | 54623 | 45.46679409 | 9.190347404 | 2021-01-01 05:23:07 | Lombardia, Italy | ||
1010291 | 1010291 | 2020-12-30 | Italy | Lombardia | 475044 | 25038 | 397010 | 52996 | 45.46679409 | 9.190347404 | 2020-12-31 05:22:49 | Lombardia, Italy | ||
766306 | 766306 | 2020-12-29 | Italy | Lombardia | 473371 | 24958 | 393995 | 54418 | 45.46679409 | 9.190347404 | 2020-12-30 05:22:34 | Lombardia, Italy | ||
3761570 | 3761570 | 2020-12-28 | Italy | Lombardia | 472528 | 24909 | 392854 | 54765 | 45.46679409 | 9.190347404 | 2020-12-29 05:22:37 | Lombardia, Italy | ||
3777890 | 3777890 | 2020-12-27 | Italy | Lombardia | 471955 | 24867 | 387761 | 59327 | 45.46679409 | 9.190347404 | 2020-12-28 05:22:06 | Lombardia, Italy | ||
2223495 | 2223495 | 2020-12-26 | Italy | Lombardia | 471489 | 24818 | 387049 | 59622 | 45.46679409 | 9.190347404 | 2020-12-27 05:22:55 | Lombardia, Italy | ||
202242 | 202242 | 2020-12-25 | Italy | Lombardia | 469883 | 24782 | 386391 | 58710 | 45.46679409 | 9.190347404 | 2020-12-26 05:22:28 | Lombardia, Italy | ||
3691465 | 3691465 | 2020-12-24 | Italy | Lombardia | 467255 | 24677 | 384670 | 57908 | 45.46679409 | 9.190347404 | 2020-12-25 05:22:48 | Lombardia, Italy | ||
2406817 | 2406817 | 2020-12-23 | Italy | Lombardia | 464599 | 24610 | 379750 | 60239 | 45.46679409 | 9.190347404 | 2020-12-24 05:23:04 | Lombardia, Italy | ||
3769863 | 3769863 | 2020-12-22 | Italy | Lombardia | 462446 | 24512 | 376790 | 61144 | 45.46679409 | 9.190347404 | 2020-12-23 05:22:03 | Lombardia, Italy | ||
927679 | 927679 | 2020-12-21 | Italy | Lombardia | 460168 | 24420 | 374434 | 61314 | 45.46679409 | 9.190347404 | 2020-12-22 05:22:33 | Lombardia, Italy | ||
2119700 | 2119700 | 2020-12-20 | Italy | Lombardia | 459218 | 24379 | 366058 | 68781 | 45.46679409 | 9.190347404 | 2020-12-21 05:27:58 | Lombardia, Italy | ||
2931207 | 2931207 | 2020-12-19 | Italy | Lombardia | 457423 | 24330 | 365440 | 67653 | 45.46679409 | 9.190347404 | 2020-12-20 05:27:32 | Lombardia, Italy | ||
1901153 | 1901153 | 2020-12-18 | Italy | Lombardia | 455479 | 24225 | 363044 | 68210 | 45.46679409 | 9.190347404 | 2020-12-19 05:27:52 | Lombardia, Italy | ||
2127979 | 2127979 | 2020-12-17 | Italy | Lombardia | 452735 | 24165 | 360529 | 68041 | 45.46679409 | 9.190347404 | 2020-12-18 05:28:18 | Lombardia, Italy | ||
3149579 | 3149579 | 2020-12-16 | Italy | Lombardia | 450005 | 24097 | 356175 | 69733 | 45.46679409 | 9.190347404 | 2020-12-17 05:28:12 | Lombardia, Italy | ||
1034360 | 1034360 | 2020-12-15 | Italy | Lombardia | 447011 | 23991 | 347130 | 75890 | 45.46679409 | 9.190347404 | 2020-12-16 05:28:04 | Lombardia, Italy | ||
1751254 | 1751254 | 2020-12-14 | Italy | Lombardia | 444607 | 23877 | 342409 | 78321 | 45.46679409 | 9.190347404 | 2020-12-15 05:26:38 | Lombardia, Italy | ||
3847774 | 3847774 | 2020-12-13 | Italy | Lombardia | 443662 | 23810 | 333503 | 86349 | 45.46679409 | 9.190347404 | 2020-12-14 05:26:27 | Lombardia, Italy | ||
845556 | 845556 | 2020-12-12 | Italy | Lombardia | 441327 | 23666 | 332595 | 85066 | 45.46679409 | 9.190347404 | 2020-12-13 05:27:20 | Lombardia, Italy | ||
860663 | 860663 | 2020-12-11 | Italy | Lombardia | 438591 | 23581 | 327561 | 87449 | 45.46679409 | 9.190347404 | 2020-12-12 05:26:19 | Lombardia, Italy | ||
1600205 | 1600205 | 2020-12-10 | Italy | Lombardia | 435653 | 23449 | 324961 | 87243 | 45.46679409 | 9.190347404 | 2020-12-11 05:26:59 | Lombardia, Italy | ||
2975214 | 2975214 | 2020-12-09 | Italy | Lombardia | 433560 | 23277 | 320380 | 89903 | 45.46679409 | 9.190347404 | 2020-12-10 05:26:19 | Lombardia, Italy | ||
1818774 | 1818774 | 2020-12-08 | Italy | Lombardia | 432327 | 23208 | 297290 | 111829 | 45.46679409 | 9.190347404 | 2020-12-09 05:28:01 | Lombardia, Italy | ||
2347410 | 2347410 | 2020-12-07 | Italy | Lombardia | 430671 | 23080 | 291591 | 116000 | 45.46679409 | 9.190347404 | 2020-12-08 05:27:42 | Lombardia, Italy | ||
1006280 | 1006280 | 2020-12-06 | Italy | Lombardia | 429109 | 23024 | 289706 | 116379 | 45.46679409 | 9.190347404 | 2020-12-07 05:26:14 | Lombardia, Italy | ||
1632289 | 1632289 | 2020-12-05 | Italy | Lombardia | 426696 | 22884 | 288056 | 115756 | 45.46679409 | 9.190347404 | 2020-12-06 05:26:18 | Lombardia, Italy | ||
3859817 | 3859817 | 2020-12-04 | Italy | Lombardia | 423548 | 22773 | 284073 | 116702 | 45.46679409 | 9.190347404 | 2020-12-05 05:27:36 | Lombardia, Italy | ||
75075 | 75075 | 2020-12-03 | Italy | Lombardia | 419015 | 22626 | 278058 | 118331 | 45.46679409 | 9.190347404 | 2020-12-04 05:27:27 | Lombardia, Italy | ||
738287 | 738287 | 2020-12-02 | Italy | Lombardia | 415264 | 22279 | 274189 | 118796 | 45.46679409 | 9.190347404 | 2020-12-03 05:28:22 | Lombardia, Italy | ||
2537381 | 2537381 | 2020-12-01 | Italy | Lombardia | 411839 | 22104 | 268702 | 121033 | 45.46679409 | 9.190347404 | 2020-12-02 05:27:41 | Lombardia, Italy | ||
1584150 | 1584150 | 2020-11-30 | Italy | Lombardia | 407791 | 21855 | 260528 | 125408 | 45.46679409 | 9.190347404 | 2020-12-01 05:26:18 | Lombardia, Italy | ||
3566553 | 3566553 | 2020-11-29 | Italy | Lombardia | 405862 | 21647 | 251588 | 132627 | 45.46679409 | 9.190347404 | 2020-11-30 05:26:13 | Lombardia, Italy | ||
2935218 | 2935218 | 2020-11-28 | Italy | Lombardia | 402659 | 21512 | 250832 | 130315 | 45.46679409 | 9.190347404 | 2020-11-29 05:25:55 | Lombardia, Italy | ||
392221 | 392221 | 2020-11-27 | Italy | Lombardia | 398044 | 21393 | 246096 | 130555 | 45.46679409 | 9.190347404 | 2020-11-28 05:25:50 | Lombardia, Italy | ||
923668 | 923668 | 2020-11-26 | Italy | Lombardia | 392655 | 21212 | 231042 | 140401 | 45.46679409 | 9.190347404 | 2020-11-27 05:26:53 | Lombardia, Italy | ||
1972573 | 1972573 | 2020-11-25 | Italy | Lombardia | 386958 | 21005 | 227924 | 138029 | 45.46679409 | 9.190347404 | 2020-11-26 05:27:44 | Lombardia, Italy | ||
1350304 | 1350304 | 2020-11-24 | Italy | Lombardia | 381785 | 20850 | 212175 | 148760 | 45.46679409 | 9.190347404 | 2020-11-25 05:27:20 | Lombardia, Italy | ||
678298 | 678298 | 2020-11-23 | Italy | Lombardia | 376899 | 20664 | 206317 | 149918 | 45.46679409 | 9.190347404 | 2020-11-24 05:27:31 | Lombardia, Italy | ||
3189974 | 3189974 | 2020-11-22 | Italy | Lombardia | 371610 | 20524 | 186680 | 164406 | 45.46679409 | 9.190347404 | 2020-11-23 05:25:26 | Lombardia, Italy | ||
3836468 | 3836468 | 2020-11-21 | Italy | Lombardia | 366516 | 20359 | 183472 | 162685 | 45.46679409 | 9.190347404 | 2020-11-22 05:25:45 | Lombardia, Italy | ||
2701496 | 2701496 | 2020-11-20 | Italy | Lombardia | 357663 | 20190 | 177832 | 159641 | 45.46679409 | 9.190347404 | 2020-11-21 05:25:51 | Lombardia, Italy | ||
821556 | 821556 | 2020-11-19 | Italy | Lombardia | 348442 | 20015 | 172847 | 155580 | 45.46679409 | 9.190347404 | 2020-11-20 05:26:28 | Lombardia, Italy | ||
122690 | 122690 | 2020-11-18 | Italy | Lombardia | 340989 | 19850 | 169056 | 152083 | 45.46679409 | 9.190347404 | 2020-11-19 05:25:23 | Lombardia, 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]);