johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Spain" and province_or_state = "Canarias" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- …
province_or_state 1
- Canarias · 393 ✖
country_or_region 1
- Spain · 393 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2717261 | 2717261 | 2021-06-10 | Spain | Canarias | 57663 | 780 | 1537 | 55346 | 28.2916 | -16.6291 | 2021-06-11 04:23:20 | Canarias, Spain | ||
523146 | 523146 | 2021-06-09 | Spain | Canarias | 57508 | 778 | 1537 | 55193 | 28.2916 | -16.6291 | 2021-06-10 04:23:17 | Canarias, Spain | ||
3472586 | 3472586 | 2021-06-08 | Spain | Canarias | 57368 | 776 | 1537 | 55055 | 28.2916 | -16.6291 | 2021-06-09 04:23:31 | Canarias, Spain | ||
3145870 | 3145870 | 2021-06-07 | Spain | Canarias | 57250 | 775 | 1537 | 54938 | 28.2916 | -16.6291 | 2021-06-08 04:22:35 | Canarias, Spain | ||
825872 | 825872 | 2021-06-06 | Spain | Canarias | 56965 | 772 | 1537 | 54656 | 28.2916 | -16.6291 | 2021-06-07 04:22:51 | Canarias, Spain | ||
2586277 | 2586277 | 2021-06-05 | Spain | Canarias | 56965 | 772 | 1537 | 54656 | 28.2916 | -16.6291 | 2021-06-06 04:24:03 | Canarias, Spain | ||
2315591 | 2315591 | 2021-06-04 | Spain | Canarias | 56965 | 772 | 1537 | 54656 | 28.2916 | -16.6291 | 2021-06-05 04:23:03 | Canarias, Spain | ||
1448876 | 1448876 | 2021-06-03 | Spain | Canarias | 56834 | 771 | 1537 | 54526 | 28.2916 | -16.6291 | 2021-06-04 04:23:37 | Canarias, Spain | ||
1708600 | 1708600 | 2021-06-02 | Spain | Canarias | 56693 | 771 | 1537 | 54385 | 28.2916 | -16.6291 | 2021-06-03 04:23:32 | Canarias, Spain | ||
2104418 | 2104418 | 2021-06-01 | Spain | Canarias | 56561 | 770 | 1537 | 54254 | 28.2916 | -16.6291 | 2021-06-02 04:24:34 | Canarias, Spain | ||
1189034 | 1189034 | 2021-05-31 | Spain | Canarias | 56487 | 770 | 1537 | 54180 | 28.2916 | -16.6291 | 2021-06-01 04:23:09 | Canarias, Spain | ||
3089711 | 3089711 | 2021-05-30 | Spain | Canarias | 56226 | 769 | 1537 | 53920 | 28.2916 | -16.6291 | 2021-05-31 03:08:59 | Canarias, Spain | ||
51080 | 51080 | 2021-05-29 | Spain | Canarias | 56226 | 769 | 1537 | 53920 | 28.2916 | -16.6291 | 2021-05-30 04:20:55 | Canarias, Spain | ||
20659 | 20659 | 2021-05-28 | Spain | Canarias | 56226 | 769 | 1537 | 53920 | 28.2916 | -16.6291 | 2021-05-29 04:20:41 | Canarias, Spain | ||
1807034 | 1807034 | 2021-05-27 | Spain | Canarias | 56108 | 769 | 1537 | 53802 | 28.2916 | -16.6291 | 2021-05-28 04:20:36 | Canarias, Spain | ||
1310457 | 1310457 | 2021-05-26 | Spain | Canarias | 55966 | 768 | 1537 | 53661 | 28.2916 | -16.6291 | 2021-05-27 04:20:59 | Canarias, Spain | ||
83383 | 83383 | 2021-05-25 | Spain | Canarias | 55855 | 768 | 1537 | 53550 | 28.2916 | -16.6291 | 2021-05-26 04:20:35 | Canarias, Spain | ||
1413345 | 1413345 | 2021-05-24 | Spain | Canarias | 55759 | 768 | 1537 | 53454 | 28.2916 | -16.6291 | 2021-05-25 04:21:08 | Canarias, Spain | ||
1771631 | 1771631 | 2021-05-23 | Spain | Canarias | 55451 | 767 | 1537 | 53147 | 28.2916 | -16.6291 | 2021-05-24 04:20:53 | Canarias, Spain | ||
726786 | 726786 | 2021-05-22 | Spain | Canarias | 55451 | 767 | 1537 | 53147 | 28.2916 | -16.6291 | 2021-05-23 04:20:51 | Canarias, Spain | ||
1952801 | 1952801 | 2021-05-21 | Spain | Canarias | 55451 | 767 | 1537 | 53147 | 28.2916 | -16.6291 | 2021-05-22 04:20:45 | Canarias, Spain | ||
1913500 | 1913500 | 2021-05-20 | Spain | Canarias | 55294 | 766 | 1537 | 52991 | 28.2916 | -16.6291 | 2021-05-21 04:20:43 | Canarias, Spain | ||
2256021 | 2256021 | 2021-05-19 | Spain | Canarias | 55115 | 763 | 1537 | 52815 | 28.2916 | -16.6291 | 2021-05-20 04:21:05 | Canarias, Spain | ||
2391059 | 2391059 | 2021-05-18 | Spain | Canarias | 55009 | 763 | 1537 | 52709 | 28.2916 | -16.6291 | 2021-05-19 04:20:42 | Canarias, Spain | ||
3574884 | 3574884 | 2021-05-17 | Spain | Canarias | 54880 | 762 | 1537 | 52581 | 28.2916 | -16.6291 | 2021-05-18 04:20:33 | Canarias, Spain | ||
2939614 | 2939614 | 2021-05-16 | Spain | Canarias | 54526 | 760 | 1537 | 52229 | 28.2916 | -16.6291 | 2021-05-17 04:20:34 | Canarias, Spain | ||
1873244 | 1873244 | 2021-05-15 | Spain | Canarias | 54526 | 760 | 1537 | 52229 | 28.2916 | -16.6291 | 2021-05-16 04:20:49 | Canarias, Spain | ||
1082213 | 1082213 | 2021-05-14 | Spain | Canarias | 54526 | 760 | 1537 | 52229 | 28.2916 | -16.6291 | 2021-05-15 04:20:58 | Canarias, Spain | ||
3054479 | 3054479 | 2021-05-13 | Spain | Canarias | 54406 | 759 | 1537 | 52110 | 28.2916 | -16.6291 | 2021-05-14 04:20:41 | Canarias, Spain | ||
2004949 | 2004949 | 2021-05-12 | Spain | Canarias | 54222 | 754 | 1537 | 51931 | 28.2916 | -16.6291 | 2021-05-13 04:20:51 | Canarias, Spain | ||
3954780 | 3954780 | 2021-05-11 | Spain | Canarias | 54031 | 753 | 1537 | 51741 | 28.2916 | -16.6291 | 2021-05-12 04:21:29 | Canarias, Spain | ||
2821059 | 2821059 | 2021-05-10 | Spain | Canarias | 53909 | 752 | 1537 | 51620 | 28.2916 | -16.6291 | 2021-05-11 04:20:41 | Canarias, Spain | ||
1425391 | 1425391 | 2021-05-09 | Spain | Canarias | 53609 | 742 | 1537 | 51330 | 28.2916 | -16.6291 | 2021-05-10 04:20:38 | Canarias, Spain | ||
1552259 | 1552259 | 2021-05-08 | Spain | Canarias | 53609 | 742 | 1537 | 51330 | 28.2916 | -16.6291 | 2021-05-09 04:20:35 | Canarias, Spain | ||
2502317 | 2502317 | 2021-05-07 | Spain | Canarias | 53609 | 742 | 1537 | 51330 | 28.2916 | -16.6291 | 2021-05-08 04:21:04 | Canarias, Spain | ||
3113773 | 3113773 | 2021-05-06 | Spain | Canarias | 53486 | 739 | 1537 | 51210 | 28.2916 | -16.6291 | 2021-05-07 04:20:40 | Canarias, Spain | ||
646240 | 646240 | 2021-05-05 | Spain | Canarias | 53332 | 735 | 1537 | 51060 | 28.2916 | -16.6291 | 2021-05-06 04:20:38 | Canarias, Spain | ||
3675940 | 3675940 | 2021-05-04 | Spain | Canarias | 53169 | 732 | 1537 | 50900 | 28.2916 | -16.6291 | 2021-05-05 04:20:43 | Canarias, Spain | ||
2761207 | 2761207 | 2021-05-03 | Spain | Canarias | 53026 | 732 | 1537 | 50757 | 28.2916 | -16.6291 | 2021-05-04 04:20:34 | Canarias, Spain | ||
2451060 | 2451060 | 2021-05-02 | Spain | Canarias | 52655 | 731 | 1537 | 50387 | 28.2916 | -16.6291 | 2021-05-03 04:20:39 | Canarias, Spain | ||
2825073 | 2825073 | 2021-05-01 | Spain | Canarias | 52655 | 731 | 1537 | 50387 | 28.2916 | -16.6291 | 2021-05-02 04:20:48 | Canarias, Spain | ||
380481 | 380481 | 2021-04-30 | Spain | Canarias | 52655 | 731 | 1537 | 50387 | 28.2916 | -16.6291 | 2021-05-01 04:20:47 | Canarias, Spain | ||
1636604 | 1636604 | 2021-04-29 | Spain | Canarias | 52505 | 728 | 1537 | 50240 | 28.2916 | -16.6291 | 2021-04-30 04:21:03 | Canarias, Spain | ||
3393683 | 3393683 | 2021-04-28 | Spain | Canarias | 52332 | 727 | 1537 | 50068 | 28.2916 | -16.6291 | 2021-04-29 04:20:55 | Canarias, Spain | ||
3702399 | 3702399 | 2021-04-27 | Spain | Canarias | 52197 | 725 | 1537 | 49935 | 28.2916 | -16.6291 | 2021-04-28 04:20:32 | Canarias, Spain | ||
888408 | 888408 | 2021-04-26 | Spain | Canarias | 52033 | 724 | 1537 | 49772 | 28.2916 | -16.6291 | 2021-04-27 04:20:52 | Canarias, Spain | ||
955153 | 955153 | 2021-04-25 | Spain | Canarias | 51617 | 721 | 1537 | 49359 | 28.2916 | -16.6291 | 2021-04-26 04:21:04 | Canarias, Spain | ||
3924300 | 3924300 | 2021-04-24 | Spain | Canarias | 51617 | 721 | 1537 | 49359 | 28.2916 | -16.6291 | 2021-04-25 04:20:32 | Canarias, Spain | ||
1409331 | 1409331 | 2021-04-23 | Spain | Canarias | 51617 | 721 | 1537 | 49359 | 28.2916 | -16.6291 | 2021-04-24 04:20:38 | Canarias, Spain | ||
1568394 | 1568394 | 2021-04-22 | Spain | Canarias | 51452 | 717 | 1537 | 49198 | 28.2916 | -16.6291 | 2021-04-23 04:20:52 | Canarias, Spain | ||
3242615 | 3242615 | 2021-04-21 | Spain | Canarias | 51233 | 716 | 1537 | 48980 | 28.2916 | -16.6291 | 2021-04-22 04:20:53 | Canarias, Spain | ||
2021011 | 2021011 | 2021-04-20 | Spain | Canarias | 50881 | 714 | 1537 | 48630 | 28.2916 | -16.6291 | 2021-04-21 04:21:14 | Canarias, Spain | ||
2411132 | 2411132 | 2021-04-19 | Spain | Canarias | 50881 | 714 | 1537 | 48630 | 28.2916 | -16.6291 | 2021-04-20 04:20:41 | Canarias, Spain | ||
3129809 | 3129809 | 2021-04-18 | Spain | Canarias | 50321 | 708 | 1537 | 48076 | 28.2916 | -16.6291 | 2021-04-19 04:20:57 | Canarias, Spain | ||
983237 | 983237 | 2021-04-17 | Spain | Canarias | 50321 | 708 | 1537 | 48076 | 28.2916 | -16.6291 | 2021-04-18 04:20:41 | Canarias, Spain | ||
170332 | 170332 | 2021-04-16 | Spain | Canarias | 50321 | 708 | 1537 | 48076 | 28.2916 | -16.6291 | 2021-04-17 04:20:40 | Canarias, Spain | ||
2549163 | 2549163 | 2021-04-15 | Spain | Canarias | 50040 | 706 | 1537 | 47797 | 28.2916 | -16.6291 | 2021-04-16 04:20:46 | Canarias, Spain | ||
1842233 | 1842233 | 2021-04-14 | Spain | Canarias | 49828 | 701 | 1537 | 47590 | 28.2916 | -16.6291 | 2021-04-15 04:20:54 | Canarias, Spain | ||
2571967 | 2571967 | 2021-04-13 | Spain | Canarias | 49630 | 699 | 1537 | 47394 | 28.2916 | -16.6291 | 2021-04-14 04:20:41 | Canarias, Spain | ||
36718 | 36718 | 2021-04-12 | Spain | Canarias | 49418 | 698 | 1537 | 47183 | 28.2916 | -16.6291 | 2021-04-13 04:20:37 | Canarias, Spain | ||
3883877 | 3883877 | 2021-04-11 | Spain | Canarias | 48788 | 693 | 1537 | 46558 | 28.2916 | -16.6291 | 2021-04-12 04:21:00 | Canarias, Spain | ||
2983545 | 2983545 | 2021-04-10 | Spain | Canarias | 48788 | 693 | 1537 | 46558 | 28.2916 | -16.6291 | 2021-04-11 04:20:56 | Canarias, Spain | ||
605977 | 605977 | 2021-04-09 | Spain | Canarias | 48788 | 693 | 1537 | 46558 | 28.2916 | -16.6291 | 2021-04-10 04:20:59 | Canarias, Spain | ||
2646041 | 2646041 | 2021-04-08 | Spain | Canarias | 48460 | 690 | 1537 | 46233 | 28.2916 | -16.6291 | 2021-04-09 04:21:13 | Canarias, Spain | ||
2247683 | 2247683 | 2021-04-07 | Spain | Canarias | 48230 | 687 | 1537 | 46006 | 28.2916 | -16.6291 | 2021-04-08 04:21:13 | Canarias, Spain | ||
3003593 | 3003593 | 2021-04-06 | Spain | Canarias | 47994 | 686 | 1537 | 45771 | 28.2916 | -16.6291 | 2021-04-07 04:20:53 | Canarias, Spain | ||
3085588 | 3085588 | 2021-04-05 | Spain | Canarias | 47778 | 685 | 1537 | 45556 | 28.2916 | -16.6291 | 2021-04-06 04:20:32 | Canarias, Spain | ||
388511 | 388511 | 2021-04-04 | Spain | Canarias | 47422 | 682 | 1537 | 45203 | 28.2916 | -16.6291 | 2021-04-05 04:20:35 | Canarias, Spain | ||
3710427 | 3710427 | 2021-04-03 | Spain | Canarias | 47422 | 682 | 1537 | 45203 | 28.2916 | -16.6291 | 2021-04-04 04:20:49 | Canarias, Spain | ||
241543 | 241543 | 2021-04-02 | Spain | Canarias | 47098 | 677 | 1537 | 44884 | 28.2916 | -16.6291 | 2021-04-03 04:20:44 | Canarias, Spain | ||
1302340 | 1302340 | 2021-04-01 | Spain | Canarias | 47098 | 677 | 1537 | 44884 | 28.2916 | -16.6291 | 2021-04-02 04:20:36 | Canarias, Spain | ||
638212 | 638212 | 2021-03-31 | Spain | Canarias | 46880 | 676 | 1537 | 44667 | 28.2916 | -16.6291 | 2021-04-01 04:27:05 | Canarias, Spain | ||
3643841 | 3643841 | 2021-03-30 | Spain | Canarias | 46649 | 672 | 1537 | 44440 | 28.2916 | -16.6291 | 2021-03-31 04:26:25 | Canarias, Spain | ||
1290294 | 1290294 | 2021-03-29 | Spain | Canarias | 46445 | 670 | 1537 | 44238 | 28.2916 | -16.6291 | 2021-03-30 04:26:23 | Canarias, Spain | ||
1536216 | 1536216 | 2021-03-28 | Spain | Canarias | 46004 | 663 | 1537 | 43804 | 28.2916 | -16.6291 | 2021-03-29 04:28:35 | Canarias, Spain | ||
1219856 | 1219856 | 2021-03-27 | Spain | Canarias | 46004 | 663 | 1537 | 43804 | 28.2916 | -16.6291 | 2021-03-28 05:28:10 | Canarias, Spain | ||
1881274 | 1881274 | 2021-03-26 | Spain | Canarias | 46004 | 663 | 1537 | 43804 | 28.2916 | -16.6291 | 2021-03-27 05:25:04 | Canarias, Spain | ||
1980904 | 1980904 | 2021-03-25 | Spain | Canarias | 45809 | 661 | 1537 | 43611 | 28.2916 | -16.6291 | 2021-03-26 05:26:55 | Canarias, Spain | ||
2781282 | 2781282 | 2021-03-24 | Spain | Canarias | 45324 | 655 | 1537 | 43132 | 28.2916 | -16.6291 | 2021-03-25 05:27:00 | Canarias, Spain | ||
1798927 | 1798927 | 2021-03-23 | Spain | Canarias | 45324 | 655 | 1537 | 43132 | 28.2916 | -16.6291 | 2021-03-24 05:25:40 | Canarias, Spain | ||
1204095 | 1204095 | 2021-03-22 | Spain | Canarias | 45081 | 653 | 1537 | 42891 | 28.2916 | -16.6291 | 2021-03-23 05:26:18 | Canarias, Spain | ||
3369617 | 3369617 | 2021-03-21 | Spain | Canarias | 44260 | 641 | 1537 | 42082 | 28.2916 | -16.6291 | 2021-03-22 05:25:43 | Canarias, Spain | ||
1744827 | 1744827 | 2021-03-20 | Spain | Canarias | 44260 | 641 | 1537 | 42082 | 28.2916 | -16.6291 | 2021-03-21 05:25:44 | Canarias, Spain | ||
3421207 | 3421207 | 2021-03-19 | Spain | Canarias | 44260 | 641 | 1537 | 42082 | 28.2916 | -16.6291 | 2021-03-20 05:25:46 | Canarias, Spain | ||
3453145 | 3453145 | 2021-03-18 | Spain | Canarias | 44260 | 641 | 1537 | 42082 | 28.2916 | -16.6291 | 2021-03-19 05:26:09 | Canarias, Spain | ||
3621369 | 3621369 | 2021-03-17 | Spain | Canarias | 44041 | 640 | 1537 | 41864 | 28.2916 | -16.6291 | 2021-03-18 05:26:22 | Canarias, Spain | ||
702693 | 702693 | 2021-03-16 | Spain | Canarias | 43795 | 636 | 1537 | 41622 | 28.2916 | -16.6291 | 2021-03-17 05:25:07 | Canarias, Spain | ||
2056171 | 2056171 | 2021-03-15 | Spain | Canarias | 43531 | 630 | 1537 | 41364 | 28.2916 | -16.6291 | 2021-03-16 05:25:13 | Canarias, Spain | ||
1732783 | 1732783 | 2021-03-14 | Spain | Canarias | 43023 | 626 | 1537 | 40860 | 28.2916 | -16.6291 | 2021-03-15 05:25:51 | Canarias, Spain | ||
1580440 | 1580440 | 2021-03-13 | Spain | Canarias | 43023 | 626 | 1537 | 40860 | 28.2916 | -16.6291 | 2021-03-14 05:25:37 | Canarias, Spain | ||
1838219 | 1838219 | 2021-03-12 | Spain | Canarias | 43023 | 626 | 1537 | 40860 | 28.2916 | -16.6291 | 2021-03-13 05:25:15 | Canarias, Spain | ||
352584 | 352584 | 2021-03-11 | Spain | Canarias | 42777 | 623 | 1537 | 40617 | 28.2916 | -16.6291 | 2021-03-12 05:26:50 | Canarias, Spain | ||
3962808 | 3962808 | 2021-03-10 | Spain | Canarias | 42548 | 622 | 1537 | 40389 | 28.2916 | -16.6291 | 2021-03-11 05:25:48 | Canarias, Spain | ||
3663896 | 3663896 | 2021-03-09 | Spain | Canarias | 42326 | 620 | 1537 | 40169 | 28.2916 | -16.6291 | 2021-03-10 05:24:35 | Canarias, Spain | ||
2359755 | 2359755 | 2021-03-08 | Spain | Canarias | 42114 | 617 | 1537 | 39960 | 28.2916 | -16.6291 | 2021-03-09 05:28:19 | Canarias, Spain | ||
55093 | 55093 | 2021-03-07 | Spain | Canarias | 41635 | 607 | 1537 | 39491 | 28.2916 | -16.6291 | 2021-03-08 05:24:48 | Canarias, Spain | ||
3667910 | 3667910 | 2021-03-06 | Spain | Canarias | 41635 | 607 | 1537 | 39491 | 28.2916 | -16.6291 | 2021-03-07 05:21:54 | Canarias, Spain | ||
1616531 | 1616531 | 2021-03-05 | Spain | Canarias | 41635 | 607 | 1537 | 39491 | 28.2916 | -16.6291 | 2021-03-06 04:23:41 | Canarias, Spain | ||
2207942 | 2207942 | 2021-03-04 | Spain | Canarias | 41421 | 606 | 1537 | 39278 | 28.2916 | -16.6291 | 2021-03-05 05:26:29 | Canarias, Spain | ||
1090363 | 1090363 | 2021-03-03 | Spain | Canarias | 41250 | 606 | 1537 | 39107 | 28.2916 | -16.6291 | 2021-03-04 05:24:24 | Canarias, Spain |
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]);