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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2463083 | 2463083 | 2021-09-14 | Spain | Canarias | 93745 | 966 | 0 | 28.2916 | -16.6291 | 2021-09-15 03:22:37 | Canarias, Spain | |||
1385922 | 1385922 | 2021-09-13 | Spain | Canarias | 93635 | 965 | 0 | 28.2916 | -16.6291 | 2021-09-14 04:21:41 | Canarias, Spain | |||
1885291 | 1885291 | 2021-09-12 | Spain | Canarias | 93345 | 962 | 0 | 28.2916 | -16.6291 | 2021-09-13 04:21:15 | Canarias, Spain | |||
3806194 | 3806194 | 2021-09-11 | Spain | Canarias | 93345 | 962 | 0 | 28.2916 | -16.6291 | 2021-09-12 04:21:13 | Canarias, Spain | |||
3449134 | 3449134 | 2021-09-10 | Spain | Canarias | 93345 | 962 | 0 | 28.2916 | -16.6291 | 2021-09-11 04:21:30 | Canarias, Spain | |||
1263080 | 1263080 | 2021-09-09 | Spain | Canarias | 93233 | 962 | 0 | 28.2916 | -16.6291 | 2021-09-10 04:21:20 | Canarias, Spain | |||
2279450 | 2279450 | 2021-09-08 | Spain | Canarias | 93085 | 962 | 0 | 28.2916 | -16.6291 | 2021-09-09 04:21:27 | Canarias, Spain | |||
642229 | 642229 | 2021-09-07 | Spain | Canarias | 92958 | 959 | 0 | 28.2916 | -16.6291 | 2021-09-08 04:21:31 | Canarias, Spain | |||
3194292 | 3194292 | 2021-09-06 | Spain | Canarias | 92847 | 955 | 0 | 28.2916 | -16.6291 | 2021-09-07 04:21:35 | Canarias, Spain | |||
3281160 | 3281160 | 2021-09-05 | Spain | Canarias | 92509 | 947 | 0 | 28.2916 | -16.6291 | 2021-09-06 04:21:22 | Canarias, Spain | |||
249574 | 249574 | 2021-09-04 | Spain | Canarias | 92509 | 947 | 0 | 28.2916 | -16.6291 | 2021-09-05 04:21:33 | Canarias, Spain | |||
3974855 | 3974855 | 2021-09-03 | Spain | Canarias | 92509 | 947 | 0 | 28.2916 | -16.6291 | 2021-09-04 04:21:28 | Canarias, Spain | |||
178317 | 178317 | 2021-09-02 | Spain | Canarias | 92348 | 944 | 0 | 28.2916 | -16.6291 | 2021-09-03 04:21:20 | Canarias, Spain | |||
67352 | 67352 | 2021-09-01 | Spain | Canarias | 92174 | 943 | 0 | 28.2916 | -16.6291 | 2021-09-02 04:21:15 | Canarias, Spain | |||
2068194 | 2068194 | 2021-08-31 | Spain | Canarias | 92019 | 942 | 0 | 28.2916 | -16.6291 | 2021-09-01 04:21:38 | Canarias, Spain | |||
1775648 | 1775648 | 2021-08-30 | Spain | Canarias | 91858 | 939 | 0 | 28.2916 | -16.6291 | 2021-08-31 04:21:46 | Canarias, Spain | |||
3892222 | 3892222 | 2021-08-29 | Spain | Canarias | 91390 | 932 | 0 | 28.2916 | -16.6291 | 2021-08-30 04:21:23 | Canarias, Spain | |||
2793325 | 2793325 | 2021-08-28 | Spain | Canarias | 91390 | 932 | 0 | 28.2916 | -16.6291 | 2021-08-29 04:21:14 | Canarias, Spain | |||
2923484 | 2923484 | 2021-08-27 | Spain | Canarias | 91390 | 932 | 0 | 28.2916 | -16.6291 | 2021-08-28 04:21:28 | Canarias, Spain | |||
1596498 | 1596498 | 2021-08-26 | Spain | Canarias | 91179 | 927 | 0 | 28.2916 | -16.6291 | 2021-08-27 04:21:37 | Canarias, Spain | |||
32707 | 32707 | 2021-08-25 | Spain | Canarias | 90951 | 924 | 0 | 28.2916 | -16.6291 | 2021-08-26 04:21:28 | Canarias, Spain | |||
3105746 | 3105746 | 2021-08-24 | Spain | Canarias | 90700 | 921 | 0 | 28.2916 | -16.6291 | 2021-08-25 04:21:41 | Canarias, Spain | |||
3165917 | 3165917 | 2021-08-23 | Spain | Canarias | 90561 | 913 | 0 | 28.2916 | -16.6291 | 2021-08-24 04:21:19 | Canarias, Spain | |||
2175844 | 2175844 | 2021-08-22 | Spain | Canarias | 89866 | 902 | 0 | 28.2916 | -16.6291 | 2021-08-23 04:21:27 | Canarias, Spain | |||
3555940 | 3555940 | 2021-08-21 | Spain | Canarias | 89866 | 902 | 0 | 28.2916 | -16.6291 | 2021-08-22 04:21:29 | Canarias, Spain | |||
1854282 | 1854282 | 2021-08-20 | Spain | Canarias | 89866 | 902 | 0 | 28.2916 | -16.6291 | 2021-08-21 04:21:38 | Canarias, Spain | |||
511989 | 511989 | 2021-08-19 | Spain | Canarias | 89566 | 899 | 0 | 28.2916 | -16.6291 | 2021-08-20 04:21:33 | Canarias, Spain | |||
2518468 | 2518468 | 2021-08-18 | Spain | Canarias | 89227 | 896 | 0 | 28.2916 | -16.6291 | 2021-08-19 04:21:15 | Canarias, Spain | |||
245560 | 245560 | 2021-08-17 | Spain | Canarias | 88908 | 889 | 0 | 28.2916 | -16.6291 | 2021-08-18 04:21:35 | Canarias, Spain | |||
1604523 | 1604523 | 2021-08-16 | Spain | Canarias | 88577 | 886 | 0 | 28.2916 | -16.6291 | 2021-08-17 04:21:49 | Canarias, Spain | |||
103617 | 103617 | 2021-08-15 | Spain | Canarias | 87705 | 878 | 0 | 28.2916 | -16.6291 | 2021-08-16 04:21:31 | Canarias, Spain | |||
507975 | 507975 | 2021-08-14 | Spain | Canarias | 87705 | 878 | 0 | 28.2916 | -16.6291 | 2021-08-15 04:21:41 | Canarias, Spain | |||
1483847 | 1483847 | 2021-08-13 | Spain | Canarias | 87705 | 878 | 0 | 28.2916 | -16.6291 | 2021-08-14 04:21:25 | Canarias, Spain | |||
2899977 | 2899977 | 2021-08-12 | Spain | Canarias | 87247 | 871 | 0 | 28.2916 | -16.6291 | 2021-08-13 04:21:24 | Canarias, Spain | |||
1342581 | 1342581 | 2021-08-11 | Spain | Canarias | 86718 | 868 | 0 | 28.2916 | -16.6291 | 2021-08-12 04:21:25 | Canarias, Spain | |||
2351728 | 2351728 | 2021-08-10 | Spain | Canarias | 86114 | 863 | 0 | 28.2916 | -16.6291 | 2021-08-11 04:21:58 | Canarias, Spain | |||
650257 | 650257 | 2021-08-09 | Spain | Canarias | 85680 | 860 | 0 | 28.2916 | -16.6291 | 2021-08-10 04:21:27 | Canarias, Spain | |||
589919 | 589919 | 2021-08-08 | Spain | Canarias | 84179 | 848 | 0 | 28.2916 | -16.6291 | 2021-08-09 04:21:24 | Canarias, Spain | |||
2203931 | 2203931 | 2021-08-07 | Spain | Canarias | 84179 | 848 | 0 | 28.2916 | -16.6291 | 2021-08-08 04:21:33 | Canarias, Spain | |||
1117881 | 1117881 | 2021-08-06 | Spain | Canarias | 84179 | 848 | 0 | 28.2916 | -16.6291 | 2021-08-07 04:21:30 | Canarias, Spain | |||
1956818 | 1956818 | 2021-08-05 | Spain | Canarias | 83516 | 844 | 0 | 28.2916 | -16.6291 | 2021-08-06 04:21:18 | Canarias, Spain | |||
332197 | 332197 | 2021-08-04 | Spain | Canarias | 82694 | 842 | 1537 | 80315 | 28.2916 | -16.6291 | 2021-08-05 04:21:51 | Canarias, Spain | ||
3468468 | 3468468 | 2021-08-03 | Spain | Canarias | 81894 | 840 | 1537 | 79517 | 28.2916 | -16.6291 | 2021-08-04 04:21:25 | Canarias, Spain | ||
3683742 | 3683742 | 2021-08-02 | Spain | Canarias | 81225 | 833 | 1537 | 78855 | 28.2916 | -16.6291 | 2021-08-03 04:21:39 | Canarias, Spain | ||
3015641 | 3015641 | 2021-08-01 | Spain | Canarias | 79087 | 824 | 1537 | 76726 | 28.2916 | -16.6291 | 2021-08-02 04:21:36 | Canarias, Spain | ||
3904264 | 3904264 | 2021-07-31 | Spain | Canarias | 79087 | 824 | 1537 | 76726 | 28.2916 | -16.6291 | 2021-08-01 04:21:50 | Canarias, Spain | ||
3296469 | 3296469 | 2021-07-30 | Spain | Canarias | 79087 | 824 | 1537 | 76726 | 28.2916 | -16.6291 | 2021-07-31 04:21:35 | Canarias, Spain | ||
3385680 | 3385680 | 2021-07-29 | Spain | Canarias | 78233 | 822 | 1537 | 75874 | 28.2916 | -16.6291 | 2021-07-30 04:21:34 | Canarias, Spain | ||
408585 | 408585 | 2021-07-28 | Spain | Canarias | 77260 | 821 | 1537 | 74902 | 28.2916 | -16.6291 | 2021-07-29 04:21:33 | Canarias, Spain | ||
1306446 | 1306446 | 2021-07-27 | Spain | Canarias | 76317 | 817 | 1537 | 73963 | 28.2916 | -16.6291 | 2021-07-28 04:21:39 | Canarias, Spain | ||
3218589 | 3218589 | 2021-07-26 | Spain | Canarias | 75618 | 815 | 1537 | 73266 | 28.2916 | -16.6291 | 2021-07-27 04:21:18 | Canarias, Spain | ||
1378798 | 1378798 | 2021-07-25 | Spain | Canarias | 73495 | 810 | 1537 | 71148 | 28.2916 | -16.6291 | 2021-07-26 04:21:28 | Canarias, Spain | ||
1330538 | 1330538 | 2021-07-24 | Spain | Canarias | 73495 | 810 | 1537 | 71148 | 28.2916 | -16.6291 | 2021-07-25 04:22:12 | Canarias, Spain | ||
3137842 | 3137842 | 2021-07-23 | Spain | Canarias | 73495 | 810 | 1537 | 71148 | 28.2916 | -16.6291 | 2021-07-24 00:21:36 | Canarias, Spain | ||
3476602 | 3476602 | 2021-07-22 | Spain | Canarias | 72471 | 808 | 1537 | 70126 | 28.2916 | -16.6291 | 2021-07-23 04:21:29 | Canarias, Spain | ||
3331821 | 3331821 | 2021-07-21 | Spain | Canarias | 71558 | 808 | 1537 | 69213 | 28.2916 | -16.6291 | 2021-07-22 04:21:19 | Canarias, Spain | ||
2371802 | 2371802 | 2021-07-20 | Spain | Canarias | 70740 | 807 | 1537 | 68396 | 28.2916 | -16.6291 | 2021-07-21 04:21:40 | Canarias, Spain | ||
483881 | 483881 | 2021-07-19 | Spain | Canarias | 70104 | 806 | 1537 | 67761 | 28.2916 | -16.6291 | 2021-07-20 04:21:48 | Canarias, Spain | ||
2674104 | 2674104 | 2021-07-18 | Spain | Canarias | 68341 | 803 | 1537 | 66001 | 28.2916 | -16.6291 | 2021-07-19 04:21:24 | Canarias, Spain | ||
3706416 | 3706416 | 2021-07-17 | Spain | Canarias | 68341 | 803 | 1537 | 66001 | 28.2916 | -16.6291 | 2021-07-18 04:22:07 | Canarias, Spain | ||
2947647 | 2947647 | 2021-07-16 | Spain | Canarias | 68341 | 803 | 1537 | 66001 | 28.2916 | -16.6291 | 2021-07-17 04:22:22 | Canarias, Spain | ||
296303 | 296303 | 2021-07-15 | Spain | Canarias | 67609 | 802 | 1537 | 65270 | 28.2916 | -16.6291 | 2021-07-16 04:21:22 | Canarias, Spain | ||
3632248 | 3632248 | 2021-07-14 | Spain | Canarias | 66920 | 798 | 1537 | 64585 | 28.2916 | -16.6291 | 2021-07-15 04:21:48 | Canarias, Spain | ||
579123 | 579123 | 2021-07-13 | Spain | Canarias | 66284 | 797 | 1537 | 63950 | 28.2916 | -16.6291 | 2021-07-14 04:21:35 | Canarias, Spain | ||
3741372 | 3741372 | 2021-07-12 | Spain | Canarias | 65782 | 797 | 1537 | 63448 | 28.2916 | -16.6291 | 2021-07-13 04:21:18 | Canarias, Spain | ||
3659885 | 3659885 | 2021-07-11 | Spain | Canarias | 64476 | 795 | 1537 | 62144 | 28.2916 | -16.6291 | 2021-07-12 04:21:34 | Canarias, Spain | ||
626169 | 626169 | 2021-07-10 | Spain | Canarias | 64476 | 795 | 1537 | 62144 | 28.2916 | -16.6291 | 2021-07-11 04:21:43 | Canarias, Spain | ||
829888 | 829888 | 2021-07-09 | Spain | Canarias | 64476 | 795 | 1537 | 62144 | 28.2916 | -16.6291 | 2021-07-10 04:21:25 | Canarias, Spain | ||
778652 | 778652 | 2021-07-08 | Spain | Canarias | 63934 | 795 | 1537 | 61602 | 28.2916 | -16.6291 | 2021-07-09 04:21:21 | Canarias, Spain | ||
1440874 | 1440874 | 2021-07-07 | Spain | Canarias | 63424 | 795 | 1537 | 61092 | 28.2916 | -16.6291 | 2021-07-08 04:21:26 | Canarias, Spain | ||
2693979 | 2693979 | 2021-07-06 | Spain | Canarias | 63070 | 795 | 1537 | 60738 | 28.2916 | -16.6291 | 2021-07-07 04:21:20 | Canarias, Spain | ||
1932728 | 1932728 | 2021-07-05 | Spain | Canarias | 62740 | 795 | 1537 | 60408 | 28.2916 | -16.6291 | 2021-07-06 04:21:32 | Canarias, Spain | ||
1165459 | 1165459 | 2021-07-04 | Spain | Canarias | 61807 | 792 | 1537 | 59478 | 28.2916 | -16.6291 | 2021-07-05 04:21:28 | Canarias, Spain | ||
1495893 | 1495893 | 2021-07-03 | Spain | Canarias | 61807 | 792 | 1537 | 59478 | 28.2916 | -16.6291 | 2021-07-04 04:21:38 | Canarias, Spain | ||
2072208 | 2072208 | 2021-07-02 | Spain | Canarias | 61807 | 792 | 1537 | 59478 | 28.2916 | -16.6291 | 2021-07-03 04:21:37 | Canarias, Spain | ||
2765224 | 2765224 | 2021-07-01 | Spain | Canarias | 61463 | 791 | 1537 | 59135 | 28.2916 | -16.6291 | 2021-07-02 04:21:47 | Canarias, Spain | ||
1893432 | 1893432 | 2021-06-30 | Spain | Canarias | 61085 | 791 | 1537 | 58757 | 28.2916 | -16.6291 | 2021-07-01 04:21:19 | Canarias, Spain | ||
400555 | 400555 | 2021-06-29 | Spain | Canarias | 60795 | 790 | 1537 | 58468 | 28.2916 | -16.6291 | 2021-06-30 04:21:41 | Canarias, Spain | ||
3125798 | 3125798 | 2021-06-28 | Spain | Canarias | 60587 | 790 | 1537 | 58260 | 28.2916 | -16.6291 | 2021-06-29 04:21:28 | Canarias, Spain | ||
2590293 | 2590293 | 2021-06-27 | Spain | Canarias | 60067 | 789 | 1537 | 57741 | 28.2916 | -16.6291 | 2021-06-28 04:21:29 | Canarias, Spain | ||
3958797 | 3958797 | 2021-06-26 | Spain | Canarias | 60067 | 789 | 1537 | 57741 | 28.2916 | -16.6291 | 2021-06-27 04:21:39 | Canarias, Spain | ||
1712616 | 1712616 | 2021-06-25 | Spain | Canarias | 60067 | 789 | 1537 | 57741 | 28.2916 | -16.6291 | 2021-06-26 04:21:43 | Canarias, Spain | ||
2295741 | 2295741 | 2021-06-24 | Spain | Canarias | 59883 | 787 | 1537 | 57559 | 28.2916 | -16.6291 | 2021-06-25 04:21:33 | Canarias, Spain | ||
2423181 | 2423181 | 2021-06-23 | Spain | Canarias | 59670 | 787 | 1537 | 57346 | 28.2916 | -16.6291 | 2021-06-24 04:21:55 | Canarias, Spain | ||
563258 | 563258 | 2021-06-22 | Spain | Canarias | 59484 | 786 | 1537 | 57161 | 28.2916 | -16.6291 | 2021-06-23 04:21:46 | Canarias, Spain | ||
3358960 | 3358960 | 2021-06-21 | Spain | Canarias | 59309 | 786 | 1537 | 56986 | 28.2916 | -16.6291 | 2021-06-22 04:21:34 | Canarias, Spain | ||
2884659 | 2884659 | 2021-06-20 | Spain | Canarias | 58829 | 784 | 1537 | 56508 | 28.2916 | -16.6291 | 2021-06-21 04:21:41 | Canarias, Spain | ||
107742 | 107742 | 2021-06-19 | Spain | Canarias | 58829 | 784 | 1537 | 56508 | 28.2916 | -16.6291 | 2021-06-20 04:21:48 | Canarias, Spain | ||
1125885 | 1125885 | 2021-06-18 | Spain | Canarias | 58829 | 784 | 1537 | 56508 | 28.2916 | -16.6291 | 2021-06-19 04:22:33 | Canarias, Spain | ||
2911463 | 2911463 | 2021-06-17 | Spain | Canarias | 58642 | 783 | 1537 | 56322 | 28.2916 | -16.6291 | 2021-06-18 04:22:16 | Canarias, Spain | ||
3030579 | 3030579 | 2021-06-16 | Spain | Canarias | 58482 | 783 | 1537 | 56162 | 28.2916 | -16.6291 | 2021-06-17 04:22:36 | Canarias, Spain | ||
2339685 | 2339685 | 2021-06-15 | Spain | Canarias | 58315 | 783 | 1537 | 55995 | 28.2916 | -16.6291 | 2021-06-16 04:22:32 | Canarias, Spain | ||
1564381 | 1564381 | 2021-06-14 | Spain | Canarias | 58184 | 782 | 1537 | 55865 | 28.2916 | -16.6291 | 2021-06-15 04:22:22 | Canarias, Spain | ||
3381664 | 3381664 | 2021-06-13 | Spain | Canarias | 57808 | 781 | 1537 | 55490 | 28.2916 | -16.6291 | 2021-06-14 04:22:46 | Canarias, Spain | ||
1736798 | 1736798 | 2021-06-12 | Spain | Canarias | 57808 | 781 | 1537 | 55490 | 28.2916 | -16.6291 | 2021-06-13 04:22:44 | Canarias, Spain | ||
3970839 | 3970839 | 2021-06-11 | Spain | Canarias | 57808 | 781 | 1537 | 55490 | 28.2916 | -16.6291 | 2021-06-12 04:22:22 | Canarias, Spain | ||
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 |
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]);