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)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3254435 | 3254435 | 2021-03-02 | Spain | Canarias | 41058 | 599 | 1537 | 38922 | 28.2916 | -16.6291 | 2021-03-03 05:23:28 | Canarias, Spain | ||
998727 | 998727 | 2021-03-01 | Spain | Canarias | 40887 | 596 | 1537 | 38754 | 28.2916 | -16.6291 | 2021-03-02 05:23:30 | Canarias, Spain | ||
2367785 | 2367785 | 2021-02-28 | Spain | Canarias | 40477 | 589 | 1537 | 38351 | 28.2916 | -16.6291 | 2021-03-01 05:23:01 | Canarias, Spain | ||
3066287 | 3066287 | 2021-02-27 | Spain | Canarias | 40477 | 589 | 1537 | 38351 | 28.2916 | -16.6291 | 2021-02-28 05:22:20 | Canarias, Spain | ||
2183871 | 2183871 | 2021-02-26 | Spain | Canarias | 40477 | 589 | 1537 | 38351 | 28.2916 | -16.6291 | 2021-02-27 05:22:28 | Canarias, Spain | ||
1858293 | 1858293 | 2021-02-25 | Spain | Canarias | 40268 | 588 | 1537 | 38143 | 28.2916 | -16.6291 | 2021-02-26 05:22:40 | Canarias, Spain | ||
280471 | 280471 | 2021-02-24 | Spain | Canarias | 40104 | 585 | 1537 | 37982 | 28.2916 | -16.6291 | 2021-02-25 05:24:57 | Canarias, Spain | ||
1936739 | 1936739 | 2021-02-23 | Spain | Canarias | 39884 | 582 | 1537 | 37765 | 28.2916 | -16.6291 | 2021-02-24 05:29:16 | Canarias, Spain | ||
530994 | 530994 | 2021-02-22 | Spain | Canarias | 39693 | 580 | 1537 | 37576 | 28.2916 | -16.6291 | 2021-02-23 05:23:41 | Canarias, Spain | ||
182328 | 182328 | 2021-02-21 | Spain | Canarias | 39249 | 572 | 1537 | 37140 | 28.2916 | -16.6291 | 2021-02-22 05:24:21 | Canarias, Spain | ||
742602 | 742602 | 2021-02-20 | Spain | Canarias | 39249 | 572 | 1537 | 37140 | 28.2916 | -16.6291 | 2021-02-21 05:24:33 | Canarias, Spain | ||
471700 | 471700 | 2021-02-19 | Spain | Canarias | 39249 | 572 | 1537 | 37140 | 28.2916 | -16.6291 | 2021-02-20 05:22:51 | Canarias, Spain | ||
1153409 | 1153409 | 2021-02-18 | Spain | Canarias | 39081 | 571 | 1537 | 36973 | 28.2916 | -16.6291 | 2021-02-19 05:24:16 | Canarias, Spain | ||
3601329 | 3601329 | 2021-02-17 | Spain | Canarias | 38967 | 568 | 1537 | 36862 | 28.2916 | -16.6291 | 2021-02-18 05:22:58 | Canarias, Spain | ||
3050464 | 3050464 | 2021-02-16 | Spain | Canarias | 38794 | 567 | 1537 | 36690 | 28.2916 | -16.6291 | 2021-02-17 05:23:10 | Canarias, Spain | ||
1338563 | 1338563 | 2021-02-15 | Spain | Canarias | 38668 | 565 | 1537 | 36566 | 28.2916 | -16.6291 | 2021-02-16 05:24:38 | Canarias, Spain | ||
2283714 | 2283714 | 2021-02-14 | Spain | Canarias | 38170 | 558 | 1537 | 36075 | 28.2916 | -16.6291 | 2021-02-15 05:24:49 | Canarias, Spain | ||
2678114 | 2678114 | 2021-02-13 | Spain | Canarias | 38170 | 558 | 1537 | 36075 | 28.2916 | -16.6291 | 2021-02-14 05:23:43 | Canarias, Spain | ||
3539747 | 3539747 | 2021-02-12 | Spain | Canarias | 38170 | 558 | 1537 | 36075 | 28.2916 | -16.6291 | 2021-02-13 05:22:12 | Canarias, Spain | ||
2638010 | 2638010 | 2021-02-11 | Spain | Canarias | 37869 | 554 | 1537 | 35778 | 28.2916 | -16.6291 | 2021-02-12 05:23:29 | Canarias, Spain | ||
3978865 | 3978865 | 2021-02-10 | Spain | Canarias | 37634 | 553 | 1537 | 35544 | 28.2916 | -16.6291 | 2021-02-11 05:23:55 | Canarias, Spain | ||
1528185 | 1528185 | 2021-02-09 | Spain | Canarias | 37422 | 550 | 1537 | 35335 | 28.2916 | -16.6291 | 2021-02-10 05:22:41 | Canarias, Spain | ||
613976 | 613976 | 2021-02-08 | Spain | Canarias | 37248 | 549 | 1537 | 35162 | 28.2916 | -16.6291 | 2021-02-09 05:23:30 | Canarias, Spain | ||
1672745 | 1672745 | 2021-02-07 | Spain | Canarias | 36678 | 542 | 1537 | 34599 | 28.2916 | -16.6291 | 2021-02-08 05:22:39 | Canarias, Spain | ||
975206 | 975206 | 2021-02-06 | Spain | Canarias | 36678 | 542 | 1537 | 34599 | 28.2916 | -16.6291 | 2021-02-07 05:23:00 | Canarias, Spain | ||
1588464 | 1588464 | 2021-02-05 | Spain | Canarias | 36678 | 542 | 1537 | 34599 | 28.2916 | -16.6291 | 2021-02-06 05:23:55 | Canarias, Spain | ||
790671 | 790671 | 2021-02-04 | Spain | Canarias | 36430 | 540 | 1537 | 34353 | 28.2916 | -16.6291 | 2021-02-05 05:22:38 | Canarias, Spain | ||
340563 | 340563 | 2021-02-03 | Spain | Canarias | 36176 | 537 | 1537 | 34102 | 28.2916 | -16.6291 | 2021-02-04 05:22:26 | Canarias, Spain | ||
1684789 | 1684789 | 2021-02-02 | Spain | Canarias | 35941 | 533 | 1537 | 33871 | 28.2916 | -16.6291 | 2021-02-03 05:22:52 | Canarias, Spain | ||
1676759 | 1676759 | 2021-02-01 | Spain | Canarias | 35729 | 531 | 1537 | 33661 | 28.2916 | -16.6291 | 2021-02-02 05:22:49 | Canarias, Spain | ||
1460047 | 1460047 | 2021-01-31 | Spain | Canarias | 35014 | 524 | 1537 | 32953 | 28.2916 | -16.6291 | 2021-02-01 05:22:53 | Canarias, Spain | ||
2211955 | 2211955 | 2021-01-30 | Spain | Canarias | 35014 | 524 | 1537 | 32953 | 28.2916 | -16.6291 | 2021-01-31 05:22:42 | Canarias, Spain | ||
1897442 | 1897442 | 2021-01-29 | Spain | Canarias | 35014 | 524 | 1537 | 32953 | 28.2916 | -16.6291 | 2021-01-30 05:22:49 | Canarias, Spain | ||
2482258 | 2482258 | 2021-01-28 | Spain | Canarias | 34681 | 520 | 1537 | 32624 | 28.2916 | -16.6291 | 2021-01-29 05:22:23 | Canarias, Spain | ||
3153893 | 3153893 | 2021-01-27 | Spain | Canarias | 34350 | 516 | 1537 | 32297 | 28.2916 | -16.6291 | 2021-01-28 05:22:24 | Canarias, Spain | ||
12628 | 12628 | 2021-01-26 | Spain | Canarias | 34013 | 515 | 1537 | 31961 | 28.2916 | -16.6291 | 2021-01-27 05:23:41 | Canarias, Spain | ||
2567952 | 2567952 | 2021-01-25 | Spain | Canarias | 33785 | 513 | 1537 | 31735 | 28.2916 | -16.6291 | 2021-01-26 05:22:02 | 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]);