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 = "Sardegna" sorted by fips
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423328 | 423328 | 2021-10-10 | Italy | Sardegna | 75641 | 1652 | 0 | 39.21531192 | 9.110616306 | 2021-10-11 04:21:31 | Sardegna, Italy | |||
427329 | 427329 | 2020-09-07 | Italy | Sardegna | 2564 | 136 | 1286 | 1142 | 39.21531192 | 9.110616306 | 2020-09-08 04:28:25 | Sardegna, Italy | ||
431335 | 431335 | 2022-11-03 | Italy | Sardegna | 467935 | 2783 | 0 | 39.21531192 | 9.110616306 | 2022-11-04 04:22:11 | Sardegna, Italy | |||
435349 | 435349 | 2021-01-21 | Italy | Sardegna | 36473 | 927 | 18430 | 17116 | 39.21531192 | 9.110616306 | 2021-01-22 05:22:10 | Sardegna, Italy | ||
442700 | 442700 | 2020-07-26 | Italy | Sardegna | 1388 | 134 | 1235 | 19 | 39.21531192 | 9.110616306 | 2020-07-27 04:35:02 | Sardegna, Italy | ||
443332 | 443332 | 2021-10-20 | Italy | Sardegna | 75894 | 1663 | 0 | 39.21531192 | 9.110616306 | 2021-10-21 04:21:18 | Sardegna, Italy | |||
447348 | 447348 | 2021-11-17 | Italy | Sardegna | 77387 | 1681 | 0 | 39.21531192 | 9.110616306 | 2021-11-18 04:21:33 | Sardegna, Italy | |||
451365 | 451365 | 2022-12-21 | Italy | Sardegna | 492821 | 2858 | 0 | 39.21531192 | 9.110616306 | 2022-12-22 04:20:56 | Sardegna, Italy | |||
458726 | 458726 | 2020-08-07 | Italy | Sardegna | 1433 | 134 | 1241 | 58 | 39.21531192 | 9.110616306 | 2020-08-08 04:34:53 | Sardegna, Italy | ||
459357 | 459357 | 2022-02-02 | Italy | Sardegna | 127501 | 1856 | 0 | 39.21531192 | 9.110616306 | 2022-02-03 04:21:21 | Sardegna, Italy | |||
463374 | 463374 | 2022-05-02 | Italy | Sardegna | 281539 | 2354 | 0 | 39.21531192 | 9.110616306 | 2022-05-03 04:21:00 | Sardegna, Italy | |||
467389 | 467389 | 2021-10-07 | Italy | Sardegna | 75579 | 1650 | 0 | 39.21531192 | 9.110616306 | 2021-10-08 04:21:25 | Sardegna, Italy | |||
471405 | 471405 | 2021-02-19 | Italy | Sardegna | 40582 | 1102 | 26151 | 13329 | 39.21531192 | 9.110616306 | 2021-02-20 05:22:51 | Sardegna, Italy | ||
475420 | 475420 | 2022-06-26 | Italy | Sardegna | 341302 | 2509 | 0 | 39.21531192 | 9.110616306 | 2022-06-27 04:21:00 | Sardegna, Italy | |||
479568 | 479568 | 2022-11-08 | Italy | Sardegna | 470683 | 2789 | 0 | 39.21531192 | 9.110616306 | 2022-11-09 04:21:22 | Sardegna, Italy | |||
483583 | 483583 | 2021-07-19 | Italy | Sardegna | 58571 | 1495 | 55190 | 1886 | 39.21531192 | 9.110616306 | 2021-07-20 04:21:48 | Sardegna, Italy | ||
487598 | 487598 | 2022-11-25 | Italy | Sardegna | 482438 | 2832 | 0 | 39.21531192 | 9.110616306 | 2022-11-26 04:21:11 | Sardegna, Italy | |||
491613 | 491613 | 2021-10-14 | Italy | Sardegna | 75791 | 1657 | 0 | 39.21531192 | 9.110616306 | 2021-10-15 04:21:26 | Sardegna, Italy | |||
495629 | 495629 | 2021-11-06 | Italy | Sardegna | 76505 | 1677 | 0 | 39.21531192 | 9.110616306 | 2021-11-07 04:21:53 | Sardegna, Italy | |||
499646 | 499646 | 2022-04-02 | Italy | Sardegna | 233345 | 2243 | 0 | 39.21531192 | 9.110616306 | 2022-04-03 04:20:48 | Sardegna, Italy | |||
503662 | 503662 | 2022-12-17 | Italy | Sardegna | 492821 | 2858 | 0 | 39.21531192 | 9.110616306 | 2022-12-18 04:21:03 | Sardegna, Italy | |||
507677 | 507677 | 2021-08-14 | Italy | Sardegna | 66763 | 1527 | 0 | 39.21531192 | 9.110616306 | 2021-08-15 04:21:41 | Sardegna, Italy | |||
511691 | 511691 | 2021-08-19 | Italy | Sardegna | 68391 | 1550 | 0 | 39.21531192 | 9.110616306 | 2021-08-20 04:21:33 | Sardegna, Italy | |||
515706 | 515706 | 2022-10-15 | Italy | Sardegna | 458973 | 2775 | 0 | 39.21531192 | 9.110616306 | 2022-10-16 04:22:39 | Sardegna, Italy | |||
522850 | 522850 | 2021-06-09 | Italy | Sardegna | 56937 | 1481 | 43252 | 12204 | 39.21531192 | 9.110616306 | 2021-06-10 04:23:17 | Sardegna, Italy | ||
530076 | 530076 | 2020-07-04 | Italy | Sardegna | 1369 | 133 | 1223 | 13 | 39.21531192 | 9.110616306 | 2020-07-05 04:33:46 | Sardegna, Italy | ||
530699 | 530699 | 2021-02-22 | Italy | Sardegna | 40765 | 1118 | 26485 | 13162 | 39.21531192 | 9.110616306 | 2021-02-23 05:23:41 | Sardegna, Italy | ||
534713 | 534713 | 2021-10-27 | Italy | Sardegna | 76038 | 1671 | 0 | 39.21531192 | 9.110616306 | 2021-10-28 04:22:08 | Sardegna, Italy | |||
538730 | 538730 | 2022-10-26 | Italy | Sardegna | 466191 | 2781 | 0 | 39.21531192 | 9.110616306 | 2022-10-27 04:22:01 | Sardegna, Italy | |||
542746 | 542746 | 2022-12-15 | Italy | Sardegna | 489035 | 2852 | 0 | 39.21531192 | 9.110616306 | 2022-12-16 04:21:01 | Sardegna, Italy | |||
546746 | 546746 | 2020-09-12 | Italy | Sardegna | 2841 | 140 | 1322 | 1379 | 39.21531192 | 9.110616306 | 2020-09-13 04:30:52 | Sardegna, Italy | ||
550751 | 550751 | 2021-12-08 | Italy | Sardegna | 80009 | 1702 | 0 | 39.21531192 | 9.110616306 | 2021-12-09 04:22:49 | Sardegna, Italy | |||
554767 | 554767 | 2022-01-16 | Italy | Sardegna | 107206 | 1760 | 0 | 39.21531192 | 9.110616306 | 2022-01-17 04:21:08 | Sardegna, Italy | |||
558784 | 558784 | 2022-06-16 | Italy | Sardegna | 325639 | 2493 | 0 | 39.21531192 | 9.110616306 | 2022-06-17 04:20:56 | Sardegna, Italy | |||
562960 | 562960 | 2021-06-22 | Italy | Sardegna | 57128 | 1488 | 53199 | 2441 | 39.21531192 | 9.110616306 | 2021-06-23 04:21:46 | Sardegna, Italy | ||
567081 | 567081 | 2021-10-29 | Italy | Sardegna | 76120 | 1673 | 0 | 39.21531192 | 9.110616306 | 2021-10-30 04:22:03 | Sardegna, Italy | |||
574190 | 574190 | 2020-06-06 | Italy | Sardegna | 1362 | 131 | 1171 | 60 | 39.21531192 | 9.110616306 | 2020-06-07 03:53:30 | Sardegna, Italy | ||
574810 | 574810 | 2022-02-25 | Italy | Sardegna | 173436 | 2030 | 0 | 39.21531192 | 9.110616306 | 2022-02-26 04:21:12 | Sardegna, Italy | |||
578825 | 578825 | 2021-07-13 | Italy | Sardegna | 57666 | 1492 | 53611 | 2563 | 39.21531192 | 9.110616306 | 2021-07-14 04:21:35 | Sardegna, Italy | ||
582824 | 582824 | 2020-08-13 | Italy | Sardegna | 1479 | 134 | 1247 | 98 | 39.21531192 | 9.110616306 | 2020-08-14 04:51:19 | Sardegna, Italy | ||
589621 | 589621 | 2021-08-08 | Italy | Sardegna | 64654 | 1514 | 0 | 39.21531192 | 9.110616306 | 2021-08-09 04:21:24 | Sardegna, Italy | |||
593636 | 593636 | 2022-07-01 | Italy | Sardegna | 353529 | 2516 | 0 | 39.21531192 | 9.110616306 | 2022-07-02 04:21:16 | Sardegna, Italy | |||
597651 | 597651 | 2021-10-19 | Italy | Sardegna | 75866 | 1663 | 0 | 39.21531192 | 9.110616306 | 2021-10-20 04:21:00 | Sardegna, Italy | |||
601667 | 601667 | 2021-09-23 | Italy | Sardegna | 74918 | 1631 | 0 | 39.21531192 | 9.110616306 | 2021-09-24 04:21:44 | Sardegna, Italy | |||
605682 | 605682 | 2021-04-09 | Italy | Sardegna | 48315 | 1259 | 30607 | 16449 | 39.21531192 | 9.110616306 | 2021-04-10 04:20:59 | Sardegna, Italy | ||
609681 | 609681 | 2020-08-29 | Italy | Sardegna | 2092 | 134 | 1267 | 691 | 39.21531192 | 9.110616306 | 2020-08-30 04:28:22 | Sardegna, Italy | ||
613681 | 613681 | 2021-02-08 | Italy | Sardegna | 39583 | 1023 | 24033 | 14527 | 39.21531192 | 9.110616306 | 2021-02-09 05:23:30 | Sardegna, Italy | ||
617840 | 617840 | 2022-11-05 | Italy | Sardegna | 470683 | 2789 | 0 | 39.21531192 | 9.110616306 | 2022-11-06 04:21:24 | Sardegna, Italy | |||
621856 | 621856 | 2022-05-22 | Italy | Sardegna | 308184 | 2442 | 0 | 39.21531192 | 9.110616306 | 2022-05-26 04:20:50 | Sardegna, Italy | |||
625871 | 625871 | 2021-07-10 | Italy | Sardegna | 57477 | 1492 | 53587 | 2398 | 39.21531192 | 9.110616306 | 2021-07-11 04:21:43 | Sardegna, Italy | ||
629886 | 629886 | 2022-07-12 | Italy | Sardegna | 381156 | 2544 | 0 | 39.21531192 | 9.110616306 | 2022-07-13 04:20:58 | Sardegna, Italy | |||
633901 | 633901 | 2021-10-13 | Italy | Sardegna | 75742 | 1656 | 0 | 39.21531192 | 9.110616306 | 2021-10-14 04:21:29 | Sardegna, Italy | |||
637917 | 637917 | 2021-03-31 | Italy | Sardegna | 45503 | 1234 | 29872 | 14397 | 39.21531192 | 9.110616306 | 2021-04-01 04:27:05 | Sardegna, Italy | ||
641931 | 641931 | 2021-09-07 | Italy | Sardegna | 73449 | 1599 | 0 | 39.21531192 | 9.110616306 | 2021-09-08 04:21:31 | Sardegna, Italy | |||
645945 | 645945 | 2021-05-05 | Italy | Sardegna | 55146 | 1403 | 37496 | 16247 | 39.21531192 | 9.110616306 | 2021-05-06 04:20:38 | Sardegna, Italy | ||
649959 | 649959 | 2021-08-09 | Italy | Sardegna | 64826 | 1516 | 0 | 39.21531192 | 9.110616306 | 2021-08-10 04:21:27 | Sardegna, Italy | |||
653973 | 653973 | 2021-10-22 | Italy | Sardegna | 75942 | 1665 | 0 | 39.21531192 | 9.110616306 | 2021-10-23 04:21:32 | Sardegna, Italy | |||
658292 | 658292 | 2022-05-13 | Italy | Sardegna | 296340 | 2403 | 0 | 39.21531192 | 9.110616306 | 2022-05-14 04:20:48 | Sardegna, Italy | |||
662292 | 662292 | 2020-08-11 | Italy | Sardegna | 1461 | 134 | 1245 | 82 | 39.21531192 | 9.110616306 | 2020-08-12 04:27:29 | Sardegna, Italy | ||
666271 | 666271 | 2020-09-16 | Italy | Sardegna | 2991 | 140 | 1371 | 1480 | 39.21531192 | 9.110616306 | 2020-09-17 04:22:00 | Sardegna, Italy | ||
670277 | 670277 | 2022-07-21 | Italy | Sardegna | 402833 | 2571 | 0 | 39.21531192 | 9.110616306 | 2022-07-22 04:21:15 | Sardegna, Italy | |||
674293 | 674293 | 2022-07-30 | Italy | Sardegna | 416551 | 2599 | 0 | 39.21531192 | 9.110616306 | 2022-07-31 04:21:02 | Sardegna, Italy | |||
678305 | 678305 | 2020-11-23 | Italy | Sardegna | 18998 | 395 | 6139 | 12464 | 39.21531192 | 9.110616306 | 2020-11-24 05:27:31 | Sardegna, Italy | ||
682318 | 682318 | 2021-10-24 | Italy | Sardegna | 75970 | 1668 | 0 | 39.21531192 | 9.110616306 | 2021-10-25 04:22:31 | Sardegna, Italy | |||
686334 | 686334 | 2021-11-13 | Italy | Sardegna | 77036 | 1679 | 0 | 39.21531192 | 9.110616306 | 2021-11-14 04:21:31 | Sardegna, Italy | |||
690351 | 690351 | 2022-12-23 | Italy | Sardegna | 495931 | 2862 | 0 | 39.21531192 | 9.110616306 | 2022-12-24 04:21:02 | Sardegna, Italy | |||
694367 | 694367 | 2022-03-17 | Italy | Sardegna | 203145 | 2140 | 0 | 39.21531192 | 9.110616306 | 2022-03-18 04:20:55 | Sardegna, Italy | |||
698382 | 698382 | 2021-11-04 | Italy | Sardegna | 76333 | 1677 | 0 | 39.21531192 | 9.110616306 | 2021-11-05 04:21:54 | Sardegna, Italy | |||
702398 | 702398 | 2021-03-16 | Italy | Sardegna | 42632 | 1198 | 28618 | 12816 | 39.21531192 | 9.110616306 | 2021-03-17 05:25:07 | Sardegna, Italy | ||
706412 | 706412 | 2021-09-29 | Italy | Sardegna | 75205 | 1641 | 0 | 39.21531192 | 9.110616306 | 2021-09-30 04:21:20 | Sardegna, Italy | |||
710428 | 710428 | 2022-11-01 | Italy | Sardegna | 467935 | 2783 | 0 | 39.21531192 | 9.110616306 | 2022-11-02 04:22:09 | Sardegna, Italy | |||
714443 | 714443 | 2021-11-12 | Italy | Sardegna | 76945 | 1679 | 0 | 39.21531192 | 9.110616306 | 2021-11-13 04:21:38 | Sardegna, Italy | |||
718460 | 718460 | 2022-12-04 | Italy | Sardegna | 485716 | 2841 | 0 | 39.21531192 | 9.110616306 | 2022-12-05 04:20:58 | Sardegna, Italy | |||
722475 | 722475 | 2021-11-20 | Italy | Sardegna | 77770 | 1683 | 0 | 39.21531192 | 9.110616306 | 2021-11-21 04:22:13 | Sardegna, Italy | |||
726491 | 726491 | 2021-05-22 | Italy | Sardegna | 56409 | 1446 | 41479 | 13484 | 39.21531192 | 9.110616306 | 2021-05-23 04:20:51 | Sardegna, Italy | ||
730505 | 730505 | 2021-12-27 | Italy | Sardegna | 85064 | 1720 | 0 | 39.21531192 | 9.110616306 | 2021-12-28 04:21:47 | Sardegna, Italy | |||
737673 | 737673 | 2020-06-12 | Italy | Sardegna | 1363 | 131 | 1190 | 42 | 39.21531192 | 9.110616306 | 2020-06-13 03:33:14 | Sardegna, Italy | ||
738294 | 738294 | 2020-12-02 | Italy | Sardegna | 22340 | 453 | 8004 | 13883 | 39.21531192 | 9.110616306 | 2020-12-03 05:28:22 | Sardegna, Italy | ||
742307 | 742307 | 2021-02-20 | Italy | Sardegna | 40655 | 1109 | 26266 | 13280 | 39.21531192 | 9.110616306 | 2021-02-21 05:24:33 | Sardegna, Italy | ||
746322 | 746322 | 2022-04-23 | Italy | Sardegna | 268981 | 2328 | 0 | 39.21531192 | 9.110616306 | 2022-04-24 04:20:56 | Sardegna, Italy | |||
753680 | 753680 | 2020-08-01 | Italy | Sardegna | 1410 | 134 | 1237 | 39 | 39.21531192 | 9.110616306 | 2020-08-02 04:34:47 | Sardegna, Italy | ||
754295 | 754295 | 2020-10-28 | Italy | Sardegna | 8526 | 205 | 2973 | 5348 | 39.21531192 | 9.110616306 | 2020-10-29 04:24:49 | Sardegna, Italy | ||
758305 | 758305 | 2021-11-26 | Italy | Sardegna | 78444 | 1690 | 0 | 39.21531192 | 9.110616306 | 2021-11-27 04:22:45 | Sardegna, Italy | |||
762307 | 762307 | 2020-10-18 | Italy | Sardegna | 6096 | 174 | 2526 | 3396 | 39.21531192 | 9.110616306 | 2020-10-19 04:24:16 | Sardegna, Italy | ||
766313 | 766313 | 2020-12-29 | Italy | Sardegna | 30417 | 738 | 13421 | 16258 | 39.21531192 | 9.110616306 | 2020-12-30 05:22:34 | Sardegna, Italy | ||
770326 | 770326 | 2021-10-23 | Italy | Sardegna | 75965 | 1666 | 0 | 39.21531192 | 9.110616306 | 2021-10-24 04:21:22 | Sardegna, Italy | |||
774341 | 774341 | 2021-01-12 | Italy | Sardegna | 34436 | 850 | 16173 | 17413 | 39.21531192 | 9.110616306 | 2021-01-13 05:22:15 | Sardegna, Italy | ||
778354 | 778354 | 2021-07-08 | Italy | Sardegna | 57383 | 1492 | 53552 | 2339 | 39.21531192 | 9.110616306 | 2021-07-09 04:21:21 | Sardegna, Italy | ||
782368 | 782368 | 2021-12-13 | Italy | Sardegna | 80898 | 1710 | 0 | 39.21531192 | 9.110616306 | 2021-12-14 04:22:38 | Sardegna, Italy | |||
786370 | 786370 | 2020-10-15 | Italy | Sardegna | 5603 | 169 | 2410 | 3024 | 39.21531192 | 9.110616306 | 2020-10-16 04:24:01 | Sardegna, Italy | ||
790376 | 790376 | 2021-02-04 | Italy | Sardegna | 39079 | 1005 | 23323 | 14751 | 39.21531192 | 9.110616306 | 2021-02-05 05:22:38 | Sardegna, Italy | ||
794392 | 794392 | 2022-10-24 | Italy | Sardegna | 464374 | 2779 | 0 | 39.21531192 | 9.110616306 | 2022-10-25 04:21:53 | Sardegna, Italy | |||
798407 | 798407 | 2021-12-22 | Italy | Sardegna | 83072 | 1715 | 0 | 39.21531192 | 9.110616306 | 2021-12-23 04:21:21 | Sardegna, Italy | |||
805490 | 805490 | 2020-06-01 | Italy | Sardegna | 1357 | 131 | 1065 | 161 | 39.21531192 | 9.110616306 | 2020-06-02 02:33:08 | Sardegna, Italy | ||
809569 | 809569 | 2021-09-20 | Italy | Sardegna | 74776 | 1627 | 0 | 39.21531192 | 9.110616306 | 2021-09-21 04:21:26 | Sardegna, Italy | |||
813569 | 813569 | 2020-09-05 | Italy | Sardegna | 2486 | 136 | 1280 | 1070 | 39.21531192 | 9.110616306 | 2020-09-06 04:28:33 | Sardegna, Italy | ||
817560 | 817560 | 2020-10-09 | Italy | Sardegna | 4742 | 161 | 2012 | 2569 | 39.21531192 | 9.110616306 | 2020-10-10 04:23:57 | Sardegna, Italy | ||
821563 | 821563 | 2020-11-19 | Italy | Sardegna | 16997 | 362 | 5243 | 11392 | 39.21531192 | 9.110616306 | 2020-11-20 05:26:28 | Sardegna, Italy | ||
825576 | 825576 | 2021-06-06 | Italy | Sardegna | 56877 | 1473 | 42927 | 12477 | 39.21531192 | 9.110616306 | 2021-06-07 04:22:51 | Sardegna, Italy | ||
829590 | 829590 | 2021-07-09 | Italy | Sardegna | 57434 | 1492 | 53575 | 2367 | 39.21531192 | 9.110616306 | 2021-07-10 04:21:25 | Sardegna, 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]);