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 recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
307 | 307 | 2021-12-02 | Italy | Sardegna | 79160 | 1697 | 0 | 39.21531192 | 9.110616306 | 2021-12-03 04:23:05 | Sardegna, Italy | |||
4323 | 4323 | 2021-10-28 | Italy | Sardegna | 76097 | 1673 | 0 | 39.21531192 | 9.110616306 | 2021-10-29 04:22:03 | Sardegna, Italy | |||
16348 | 16348 | 2021-09-18 | Italy | Sardegna | 74674 | 1624 | 0 | 39.21531192 | 9.110616306 | 2021-09-19 04:21:34 | Sardegna, Italy | |||
24378 | 24378 | 2022-03-20 | Italy | Sardegna | 208594 | 2153 | 0 | 39.21531192 | 9.110616306 | 2022-03-21 04:20:50 | Sardegna, Italy | |||
28393 | 28393 | 2021-11-11 | Italy | Sardegna | 76849 | 1678 | 0 | 39.21531192 | 9.110616306 | 2021-11-12 04:22:01 | Sardegna, Italy | |||
32409 | 32409 | 2021-08-25 | Italy | Sardegna | 70340 | 1564 | 0 | 39.21531192 | 9.110616306 | 2021-08-26 04:21:28 | Sardegna, Italy | |||
43685 | 43685 | 2021-11-02 | Italy | Sardegna | 76238 | 1676 | 0 | 39.21531192 | 9.110616306 | 2021-11-03 06:22:09 | Sardegna, Italy | |||
63039 | 63039 | 2022-11-12 | Italy | Sardegna | 474879 | 2806 | 0 | 39.21531192 | 9.110616306 | 2022-11-13 04:21:14 | Sardegna, Italy | |||
67054 | 67054 | 2021-09-01 | Italy | Sardegna | 72373 | 1583 | 0 | 39.21531192 | 9.110616306 | 2021-09-02 04:21:15 | Sardegna, Italy | |||
71068 | 71068 | 2022-02-07 | Italy | Sardegna | 138244 | 1895 | 0 | 39.21531192 | 9.110616306 | 2022-02-08 04:21:15 | Sardegna, Italy | |||
87102 | 87102 | 2021-11-09 | Italy | Sardegna | 76633 | 1677 | 0 | 39.21531192 | 9.110616306 | 2021-11-10 04:21:38 | Sardegna, Italy | |||
91119 | 91119 | 2022-07-23 | Italy | Sardegna | 406243 | 2575 | 0 | 39.21531192 | 9.110616306 | 2022-07-24 04:20:47 | Sardegna, Italy | |||
99303 | 99303 | 2022-01-14 | Italy | Sardegna | 104399 | 1757 | 0 | 39.21531192 | 9.110616306 | 2022-01-15 04:21:07 | Sardegna, Italy | |||
103319 | 103319 | 2021-08-15 | Italy | Sardegna | 67038 | 1532 | 0 | 39.21531192 | 9.110616306 | 2021-08-16 04:21:31 | Sardegna, Italy | |||
114729 | 114729 | 2022-09-06 | Italy | Sardegna | 441335 | 2727 | 0 | 39.21531192 | 9.110616306 | 2022-09-07 04:20:59 | Sardegna, Italy | |||
126710 | 126710 | 2022-01-09 | Italy | Sardegna | 97472 | 1744 | 0 | 39.21531192 | 9.110616306 | 2022-01-10 04:22:07 | Sardegna, Italy | |||
130727 | 130727 | 2022-10-04 | Italy | Sardegna | 451636 | 2770 | 0 | 39.21531192 | 9.110616306 | 2022-10-05 04:23:06 | Sardegna, Italy | |||
137948 | 137948 | 2021-12-04 | Italy | Sardegna | 79548 | 1698 | 0 | 39.21531192 | 9.110616306 | 2021-12-05 04:22:25 | Sardegna, Italy | |||
141965 | 141965 | 2022-07-09 | Italy | Sardegna | 373474 | 2535 | 0 | 39.21531192 | 9.110616306 | 2022-07-10 04:20:54 | Sardegna, Italy | |||
149961 | 149961 | 2021-11-29 | Italy | Sardegna | 78774 | 1694 | 0 | 39.21531192 | 9.110616306 | 2021-11-30 04:22:53 | Sardegna, Italy | |||
157990 | 157990 | 2022-03-29 | Italy | Sardegna | 226053 | 2215 | 0 | 39.21531192 | 9.110616306 | 2022-03-30 04:20:45 | Sardegna, Italy | |||
162005 | 162005 | 2021-11-19 | Italy | Sardegna | 77641 | 1682 | 0 | 39.21531192 | 9.110616306 | 2021-11-20 04:22:17 | Sardegna, Italy | |||
166022 | 166022 | 2022-06-21 | Italy | Sardegna | 332488 | 2500 | 0 | 39.21531192 | 9.110616306 | 2022-06-22 04:20:54 | Sardegna, Italy | |||
178019 | 178019 | 2021-09-02 | Italy | Sardegna | 72641 | 1587 | 0 | 39.21531192 | 9.110616306 | 2021-09-03 04:21:20 | Sardegna, Italy | |||
186048 | 186048 | 2022-02-13 | Italy | Sardegna | 152958 | 1938 | 0 | 39.21531192 | 9.110616306 | 2022-02-14 04:20:51 | Sardegna, Italy | |||
198236 | 198236 | 2022-10-19 | Italy | Sardegna | 461709 | 2778 | 0 | 39.21531192 | 9.110616306 | 2022-10-20 04:22:59 | Sardegna, Italy | |||
217957 | 217957 | 2022-12-26 | Italy | Sardegna | 495931 | 2862 | 0 | 39.21531192 | 9.110616306 | 2022-12-27 04:21:07 | Sardegna, Italy | |||
221973 | 221973 | 2022-05-09 | Italy | Sardegna | 290282 | 2379 | 0 | 39.21531192 | 9.110616306 | 2022-05-10 04:20:50 | Sardegna, Italy | |||
229204 | 229204 | 2022-05-31 | Italy | Sardegna | 312415 | 2460 | 0 | 39.21531192 | 9.110616306 | 2022-06-01 04:20:55 | Sardegna, Italy | |||
233220 | 233220 | 2022-02-11 | Italy | Sardegna | 149411 | 1927 | 0 | 39.21531192 | 9.110616306 | 2022-02-12 04:21:06 | Sardegna, Italy | |||
245262 | 245262 | 2021-08-17 | Italy | Sardegna | 67511 | 1541 | 0 | 39.21531192 | 9.110616306 | 2021-08-18 04:21:35 | Sardegna, Italy | |||
249276 | 249276 | 2021-09-04 | Italy | Sardegna | 73083 | 1590 | 0 | 39.21531192 | 9.110616306 | 2021-09-05 04:21:33 | Sardegna, Italy | |||
253291 | 253291 | 2022-09-08 | Italy | Sardegna | 442038 | 2737 | 0 | 39.21531192 | 9.110616306 | 2022-09-09 04:21:11 | Sardegna, Italy | |||
257307 | 257307 | 2022-12-10 | Italy | Sardegna | 489035 | 2852 | 0 | 39.21531192 | 9.110616306 | 2022-12-11 04:20:50 | Sardegna, Italy | |||
261510 | 261510 | 2022-03-15 | Italy | Sardegna | 198145 | 2131 | 0 | 39.21531192 | 9.110616306 | 2022-03-16 04:20:50 | Sardegna, Italy | |||
276160 | 276160 | 2021-11-03 | Italy | Sardegna | 76296 | 1676 | 0 | 39.21531192 | 9.110616306 | 2021-11-04 04:22:20 | Sardegna, Italy | |||
287973 | 287973 | 2021-10-31 | Italy | Sardegna | 76187 | 1673 | 0 | 39.21531192 | 9.110616306 | 2021-11-01 04:22:01 | Sardegna, Italy | |||
291990 | 291990 | 2022-11-15 | Italy | Sardegna | 474879 | 2806 | 0 | 39.21531192 | 9.110616306 | 2022-11-16 04:21:09 | Sardegna, Italy | |||
303846 | 303846 | 2022-04-16 | Italy | Sardegna | 256889 | 2292 | 0 | 39.21531192 | 9.110616306 | 2022-04-17 04:20:59 | Sardegna, Italy | |||
307862 | 307862 | 2022-12-13 | Italy | Sardegna | 489035 | 2852 | 0 | 39.21531192 | 9.110616306 | 2022-12-14 04:21:04 | Sardegna, Italy | |||
311878 | 311878 | 2022-11-13 | Italy | Sardegna | 474879 | 2806 | 0 | 39.21531192 | 9.110616306 | 2022-11-14 04:21:09 | Sardegna, Italy | |||
315894 | 315894 | 2022-02-12 | Italy | Sardegna | 151379 | 1931 | 0 | 39.21531192 | 9.110616306 | 2022-02-13 04:21:00 | Sardegna, Italy | |||
319910 | 319910 | 2022-10-30 | Italy | Sardegna | 467935 | 2783 | 0 | 39.21531192 | 9.110616306 | 2022-10-31 04:21:36 | Sardegna, Italy | |||
327884 | 327884 | 2022-12-27 | Italy | Sardegna | 495931 | 2862 | 0 | 39.21531192 | 9.110616306 | 2022-12-28 04:21:04 | Sardegna, Italy | |||
335914 | 335914 | 2022-03-18 | Italy | Sardegna | 205258 | 2147 | 0 | 39.21531192 | 9.110616306 | 2022-03-19 04:20:47 | Sardegna, Italy | |||
348274 | 348274 | 2022-12-14 | Italy | Sardegna | 489035 | 2852 | 0 | 39.21531192 | 9.110616306 | 2022-12-15 04:20:58 | Sardegna, Italy | |||
356304 | 356304 | 2022-03-11 | Italy | Sardegna | 190963 | 2111 | 0 | 39.21531192 | 9.110616306 | 2022-03-12 04:20:50 | Sardegna, Italy | |||
360320 | 360320 | 2022-05-07 | Italy | Sardegna | 288866 | 2371 | 0 | 39.21531192 | 9.110616306 | 2022-05-08 04:20:49 | Sardegna, Italy | |||
372174 | 372174 | 2022-09-13 | Italy | Sardegna | 443512 | 2742 | 0 | 39.21531192 | 9.110616306 | 2022-09-14 04:20:44 | Sardegna, Italy | |||
384201 | 384201 | 2022-09-23 | Italy | Sardegna | 446874 | 2760 | 0 | 39.21531192 | 9.110616306 | 2022-09-24 04:21:40 | Sardegna, Italy | |||
396242 | 396242 | 2022-10-07 | Italy | Sardegna | 453640 | 2771 | 0 | 39.21531192 | 9.110616306 | 2022-10-08 04:22:56 | Sardegna, Italy | |||
404271 | 404271 | 2021-12-07 | Italy | Sardegna | 79871 | 1701 | 0 | 39.21531192 | 9.110616306 | 2021-12-08 04:22:46 | Sardegna, Italy | |||
419313 | 419313 | 2022-09-18 | Italy | Sardegna | 444962 | 2750 | 0 | 39.21531192 | 9.110616306 | 2022-09-19 04:21:49 | Sardegna, Italy | |||
423328 | 423328 | 2021-10-10 | Italy | Sardegna | 75641 | 1652 | 0 | 39.21531192 | 9.110616306 | 2021-10-11 04:21:31 | Sardegna, Italy | |||
431335 | 431335 | 2022-11-03 | Italy | Sardegna | 467935 | 2783 | 0 | 39.21531192 | 9.110616306 | 2022-11-04 04:22:11 | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
567081 | 567081 | 2021-10-29 | Italy | Sardegna | 76120 | 1673 | 0 | 39.21531192 | 9.110616306 | 2021-10-30 04:22:03 | Sardegna, Italy | |||
574810 | 574810 | 2022-02-25 | Italy | Sardegna | 173436 | 2030 | 0 | 39.21531192 | 9.110616306 | 2022-02-26 04:21:12 | 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 | |||
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 | |||
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 | |||
641931 | 641931 | 2021-09-07 | Italy | Sardegna | 73449 | 1599 | 0 | 39.21531192 | 9.110616306 | 2021-09-08 04:21:31 | 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 | |||
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 | |||
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 | |||
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 |
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]);