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 = "La Rioja" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182336 | 182336 | 2021-02-21 | Spain | La Rioja | 27306 | 715 | 3107 | 23484 | 42.2871 | -2.5396 | 2021-02-22 05:24:21 | La Rioja, Spain | ||
742610 | 742610 | 2021-02-20 | Spain | La Rioja | 27306 | 715 | 3107 | 23484 | 42.2871 | -2.5396 | 2021-02-21 05:24:33 | La Rioja, Spain | ||
471708 | 471708 | 2021-02-19 | Spain | La Rioja | 27306 | 715 | 3107 | 23484 | 42.2871 | -2.5396 | 2021-02-20 05:22:51 | La Rioja, Spain | ||
1153417 | 1153417 | 2021-02-18 | Spain | La Rioja | 27294 | 712 | 3107 | 23475 | 42.2871 | -2.5396 | 2021-02-19 05:24:16 | La Rioja, Spain | ||
3601337 | 3601337 | 2021-02-17 | Spain | La Rioja | 27248 | 711 | 3107 | 23430 | 42.2871 | -2.5396 | 2021-02-18 05:22:58 | La Rioja, Spain | ||
3050472 | 3050472 | 2021-02-16 | Spain | La Rioja | 27220 | 708 | 3107 | 23405 | 42.2871 | -2.5396 | 2021-02-17 05:23:10 | La Rioja, Spain | ||
1338571 | 1338571 | 2021-02-15 | Spain | La Rioja | 27190 | 706 | 3107 | 23377 | 42.2871 | -2.5396 | 2021-02-16 05:24:38 | La Rioja, Spain | ||
2283722 | 2283722 | 2021-02-14 | Spain | La Rioja | 27084 | 696 | 3107 | 23281 | 42.2871 | -2.5396 | 2021-02-15 05:24:49 | La Rioja, Spain | ||
2678122 | 2678122 | 2021-02-13 | Spain | La Rioja | 27084 | 696 | 3107 | 23281 | 42.2871 | -2.5396 | 2021-02-14 05:23:43 | La Rioja, Spain | ||
3539755 | 3539755 | 2021-02-12 | Spain | La Rioja | 27084 | 696 | 3107 | 23281 | 42.2871 | -2.5396 | 2021-02-13 05:22:12 | La Rioja, Spain | ||
2638018 | 2638018 | 2021-02-11 | Spain | La Rioja | 27023 | 694 | 3107 | 23222 | 42.2871 | -2.5396 | 2021-02-12 05:23:29 | La Rioja, Spain | ||
3978873 | 3978873 | 2021-02-10 | Spain | La Rioja | 26992 | 691 | 3107 | 23194 | 42.2871 | -2.5396 | 2021-02-11 05:23:55 | La Rioja, Spain | ||
1528193 | 1528193 | 2021-02-09 | Spain | La Rioja | 26919 | 684 | 3107 | 23128 | 42.2871 | -2.5396 | 2021-02-10 05:22:41 | La Rioja, Spain | ||
613984 | 613984 | 2021-02-08 | Spain | La Rioja | 26884 | 679 | 3107 | 23098 | 42.2871 | -2.5396 | 2021-02-09 05:23:30 | La Rioja, Spain | ||
1672753 | 1672753 | 2021-02-07 | Spain | La Rioja | 26634 | 667 | 3107 | 22860 | 42.2871 | -2.5396 | 2021-02-08 05:22:39 | La Rioja, Spain | ||
975214 | 975214 | 2021-02-06 | Spain | La Rioja | 26634 | 667 | 3107 | 22860 | 42.2871 | -2.5396 | 2021-02-07 05:23:00 | La Rioja, Spain | ||
1588472 | 1588472 | 2021-02-05 | Spain | La Rioja | 26634 | 667 | 3107 | 22860 | 42.2871 | -2.5396 | 2021-02-06 05:23:55 | La Rioja, Spain | ||
790679 | 790679 | 2021-02-04 | Spain | La Rioja | 26503 | 665 | 3107 | 22731 | 42.2871 | -2.5396 | 2021-02-05 05:22:38 | La Rioja, Spain | ||
340571 | 340571 | 2021-02-03 | Spain | La Rioja | 26307 | 661 | 3107 | 22539 | 42.2871 | -2.5396 | 2021-02-04 05:22:26 | La Rioja, Spain | ||
1684797 | 1684797 | 2021-02-02 | Spain | La Rioja | 26004 | 656 | 3107 | 22241 | 42.2871 | -2.5396 | 2021-02-03 05:22:52 | La Rioja, Spain | ||
1676767 | 1676767 | 2021-02-01 | Spain | La Rioja | 25877 | 652 | 3107 | 22118 | 42.2871 | -2.5396 | 2021-02-02 05:22:49 | La Rioja, Spain | ||
1460055 | 1460055 | 2021-01-31 | Spain | La Rioja | 25224 | 638 | 3107 | 21479 | 42.2871 | -2.5396 | 2021-02-01 05:22:53 | La Rioja, Spain | ||
2211963 | 2211963 | 2021-01-30 | Spain | La Rioja | 25224 | 638 | 3107 | 21479 | 42.2871 | -2.5396 | 2021-01-31 05:22:42 | La Rioja, Spain | ||
1897450 | 1897450 | 2021-01-29 | Spain | La Rioja | 25224 | 638 | 3107 | 21479 | 42.2871 | -2.5396 | 2021-01-30 05:22:49 | La Rioja, Spain | ||
2482266 | 2482266 | 2021-01-28 | Spain | La Rioja | 24939 | 636 | 3107 | 21196 | 42.2871 | -2.5396 | 2021-01-29 05:22:23 | La Rioja, Spain | ||
3153901 | 3153901 | 2021-01-27 | Spain | La Rioja | 24489 | 634 | 3107 | 20748 | 42.2871 | -2.5396 | 2021-01-28 05:22:24 | La Rioja, Spain | ||
12636 | 12636 | 2021-01-26 | Spain | La Rioja | 24161 | 626 | 3107 | 20428 | 42.2871 | -2.5396 | 2021-01-27 05:23:41 | La Rioja, Spain | ||
2567960 | 2567960 | 2021-01-25 | Spain | La Rioja | 23895 | 626 | 3107 | 20162 | 42.2871 | -2.5396 | 2021-01-26 05:22:02 | La Rioja, Spain | ||
1759592 | 1759592 | 2021-01-24 | Spain | La Rioja | 23166 | 618 | 3107 | 19441 | 42.2871 | -2.5396 | 2021-01-25 05:22:16 | La Rioja, Spain | ||
2427199 | 2427199 | 2021-01-23 | Spain | La Rioja | 23166 | 618 | 3107 | 19441 | 42.2871 | -2.5396 | 2021-01-24 05:22:35 | La Rioja, Spain | ||
2467101 | 2467101 | 2021-01-22 | Spain | La Rioja | 23166 | 618 | 3107 | 19441 | 42.2871 | -2.5396 | 2021-01-23 05:22:03 | La Rioja, Spain | ||
435652 | 435652 | 2021-01-21 | Spain | La Rioja | 22748 | 614 | 3107 | 19027 | 42.2871 | -2.5396 | 2021-01-22 05:22:10 | La Rioja, Spain | ||
1094383 | 1094383 | 2021-01-20 | Spain | La Rioja | 22347 | 614 | 3107 | 18626 | 42.2871 | -2.5396 | 2021-01-21 05:22:01 | La Rioja, Spain | ||
908473 | 908473 | 2021-01-19 | Spain | La Rioja | 21936 | 612 | 3107 | 18217 | 42.2871 | -2.5396 | 2021-01-20 05:21:54 | La Rioja, Spain | ||
237536 | 237536 | 2021-01-18 | Spain | La Rioja | 21706 | 611 | 3107 | 17988 | 42.2871 | -2.5396 | 2021-01-19 05:22:15 | La Rioja, Spain | ||
3503653 | 3503653 | 2021-01-17 | Spain | La Rioja | 20934 | 605 | 3107 | 17222 | 42.2871 | -2.5396 | 2021-01-18 05:22:34 | La Rioja, Spain | ||
3101736 | 3101736 | 2021-01-16 | Spain | La Rioja | 20934 | 605 | 3107 | 17222 | 42.2871 | -2.5396 | 2021-01-17 05:22:17 | La Rioja, Spain | ||
3515698 | 3515698 | 2021-01-15 | Spain | La Rioja | 20934 | 605 | 3107 | 17222 | 42.2871 | -2.5396 | 2021-01-16 05:22:40 | La Rioja, Spain | ||
3879871 | 3879871 | 2021-01-14 | Spain | La Rioja | 20719 | 603 | 3107 | 17009 | 42.2871 | -2.5396 | 2021-01-15 05:22:24 | La Rioja, Spain | ||
3308498 | 3308498 | 2021-01-13 | Spain | La Rioja | 20316 | 599 | 3107 | 16610 | 42.2871 | -2.5396 | 2021-01-14 05:22:32 | La Rioja, Spain | ||
774643 | 774643 | 2021-01-12 | Spain | La Rioja | 20015 | 598 | 3107 | 16310 | 42.2871 | -2.5396 | 2021-01-13 05:22:15 | La Rioja, Spain | ||
190364 | 190364 | 2021-01-11 | Spain | La Rioja | 19866 | 596 | 3107 | 16163 | 42.2871 | -2.5396 | 2021-01-12 05:22:15 | La Rioja, Spain | ||
2626167 | 2626167 | 2021-01-10 | Spain | La Rioja | 19326 | 594 | 3107 | 15625 | 42.2871 | -2.5396 | 2021-01-11 05:21:50 | La Rioja, Spain | ||
3900255 | 3900255 | 2021-01-09 | Spain | La Rioja | 19326 | 594 | 3107 | 15625 | 42.2871 | -2.5396 | 2021-01-10 05:22:12 | La Rioja, Spain | ||
154278 | 154278 | 2021-01-08 | Spain | La Rioja | 19326 | 594 | 3107 | 15625 | 42.2871 | -2.5396 | 2021-01-09 05:22:18 | La Rioja, Spain | ||
2541702 | 2541702 | 2021-01-07 | Spain | La Rioja | 19139 | 592 | 3107 | 15440 | 42.2871 | -2.5396 | 2021-01-08 05:22:42 | La Rioja, Spain | ||
2865011 | 2865011 | 2021-01-06 | Spain | La Rioja | 18855 | 588 | 3107 | 15160 | 42.2871 | -2.5396 | 2021-01-07 05:22:03 | La Rioja, Spain | ||
3034598 | 3034598 | 2021-01-05 | Spain | La Rioja | 18855 | 588 | 3107 | 15160 | 42.2871 | -2.5396 | 2021-01-06 05:22:16 | La Rioja, Spain | ||
1062143 | 1062143 | 2021-01-04 | Spain | La Rioja | 18779 | 587 | 3107 | 15085 | 42.2871 | -2.5396 | 2021-01-05 05:21:49 | La Rioja, Spain | ||
3230746 | 3230746 | 2021-01-03 | Spain | La Rioja | 18426 | 586 | 3107 | 14733 | 42.2871 | -2.5396 | 2021-01-04 05:22:02 | La Rioja, Spain | ||
2227815 | 2227815 | 2021-01-02 | Spain | La Rioja | 18426 | 586 | 3107 | 14733 | 42.2871 | -2.5396 | 2021-01-03 05:22:52 | La Rioja, Spain | ||
1137179 | 1137179 | 2021-01-01 | Spain | La Rioja | 18426 | 586 | 3107 | 14733 | 42.2871 | -2.5396 | 2021-01-02 05:22:33 | La Rioja, Spain | ||
3695785 | 3695785 | 2020-12-31 | Spain | La Rioja | 18426 | 586 | 3107 | 14733 | 42.2871 | -2.5396 | 2021-01-01 05:23:07 | La Rioja, Spain | ||
1010600 | 1010600 | 2020-12-30 | Spain | La Rioja | 18244 | 586 | 3107 | 14551 | 42.2871 | -2.5396 | 2020-12-31 05:22:49 | La Rioja, Spain | ||
766615 | 766615 | 2020-12-29 | Spain | La Rioja | 18128 | 586 | 3107 | 14435 | 42.2871 | -2.5396 | 2020-12-30 05:22:34 | La Rioja, Spain | ||
3761879 | 3761879 | 2020-12-28 | Spain | La Rioja | 18095 | 585 | 3107 | 14403 | 42.2871 | -2.5396 | 2020-12-29 05:22:37 | La Rioja, Spain | ||
3778199 | 3778199 | 2020-12-27 | Spain | La Rioja | 17908 | 581 | 3107 | 14220 | 42.2871 | -2.5396 | 2020-12-28 05:22:06 | La Rioja, Spain | ||
2223804 | 2223804 | 2020-12-26 | Spain | La Rioja | 17908 | 581 | 3107 | 14220 | 42.2871 | -2.5396 | 2020-12-27 05:22:55 | La Rioja, Spain | ||
202551 | 202551 | 2020-12-25 | Spain | La Rioja | 17908 | 581 | 3107 | 14220 | 42.2871 | -2.5396 | 2020-12-26 05:22:28 | La Rioja, Spain | ||
3691774 | 3691774 | 2020-12-24 | Spain | La Rioja | 17908 | 581 | 3107 | 14220 | 42.2871 | -2.5396 | 2020-12-25 05:22:48 | La Rioja, Spain | ||
2407126 | 2407126 | 2020-12-23 | Spain | La Rioja | 17822 | 581 | 3107 | 14134 | 42.2871 | -2.5396 | 2020-12-24 05:23:04 | La Rioja, Spain | ||
3770172 | 3770172 | 2020-12-22 | Spain | La Rioja | 17755 | 579 | 3107 | 14069 | 42.2871 | -2.5396 | 2020-12-23 05:22:03 | La Rioja, Spain | ||
927988 | 927988 | 2020-12-21 | Spain | La Rioja | 17726 | 579 | 3107 | 14040 | 42.2871 | -2.5396 | 2020-12-22 05:22:33 | La Rioja, Spain | ||
2120009 | 2120009 | 2020-12-20 | Spain | La Rioja | 17553 | 577 | 3107 | 13869 | 42.2871 | -2.5396 | 2020-12-21 05:27:58 | La Rioja, Spain | ||
2931516 | 2931516 | 2020-12-19 | Spain | La Rioja | 17553 | 577 | 3107 | 13869 | 42.2871 | -2.5396 | 2020-12-20 05:27:32 | La Rioja, Spain | ||
1901462 | 1901462 | 2020-12-18 | Spain | La Rioja | 17553 | 577 | 3107 | 13869 | 42.2871 | -2.5396 | 2020-12-19 05:27:52 | La Rioja, Spain | ||
2128288 | 2128288 | 2020-12-17 | Spain | La Rioja | 17477 | 576 | 3107 | 13794 | 42.2871 | -2.5396 | 2020-12-18 05:28:18 | La Rioja, Spain | ||
3149888 | 3149888 | 2020-12-16 | Spain | La Rioja | 17429 | 576 | 3107 | 13746 | 42.2871 | -2.5396 | 2020-12-17 05:28:12 | La Rioja, Spain | ||
1034669 | 1034669 | 2020-12-15 | Spain | La Rioja | 17377 | 576 | 3107 | 13694 | 42.2871 | -2.5396 | 2020-12-16 05:28:04 | La Rioja, Spain | ||
1751563 | 1751563 | 2020-12-14 | Spain | La Rioja | 17344 | 575 | 3107 | 13662 | 42.2871 | -2.5396 | 2020-12-15 05:26:38 | La Rioja, Spain | ||
3848083 | 3848083 | 2020-12-13 | Spain | La Rioja | 17184 | 573 | 3107 | 13504 | 42.2871 | -2.5396 | 2020-12-14 05:26:27 | La Rioja, Spain | ||
845865 | 845865 | 2020-12-12 | Spain | La Rioja | 17184 | 573 | 3107 | 13504 | 42.2871 | -2.5396 | 2020-12-13 05:27:20 | La Rioja, Spain | ||
860972 | 860972 | 2020-12-11 | Spain | La Rioja | 17184 | 573 | 3107 | 13504 | 42.2871 | -2.5396 | 2020-12-12 05:26:19 | La Rioja, Spain | ||
1600514 | 1600514 | 2020-12-10 | Spain | La Rioja | 17130 | 573 | 3107 | 13450 | 42.2871 | -2.5396 | 2020-12-11 05:26:59 | La Rioja, Spain | ||
2975523 | 2975523 | 2020-12-09 | Spain | La Rioja | 17094 | 572 | 3107 | 13415 | 42.2871 | -2.5396 | 2020-12-10 05:26:19 | La Rioja, Spain | ||
1819083 | 1819083 | 2020-12-08 | Spain | La Rioja | 17025 | 567 | 3107 | 13351 | 42.2871 | -2.5396 | 2020-12-09 05:28:01 | La Rioja, Spain | ||
2347719 | 2347719 | 2020-12-07 | Spain | La Rioja | 17025 | 567 | 3107 | 13351 | 42.2871 | -2.5396 | 2020-12-08 05:27:42 | La Rioja, Spain | ||
1006589 | 1006589 | 2020-12-06 | Spain | La Rioja | 16881 | 561 | 3107 | 13213 | 42.2871 | -2.5396 | 2020-12-07 05:26:14 | La Rioja, Spain | ||
1632598 | 1632598 | 2020-12-05 | Spain | La Rioja | 16881 | 561 | 3107 | 13213 | 42.2871 | -2.5396 | 2020-12-06 05:26:18 | La Rioja, Spain | ||
3860126 | 3860126 | 2020-12-04 | Spain | La Rioja | 16881 | 561 | 3107 | 13213 | 42.2871 | -2.5396 | 2020-12-05 05:27:36 | La Rioja, Spain | ||
75384 | 75384 | 2020-12-03 | Spain | La Rioja | 16838 | 560 | 3107 | 13171 | 42.2871 | -2.5396 | 2020-12-04 05:27:27 | La Rioja, Spain | ||
738596 | 738596 | 2020-12-02 | Spain | La Rioja | 16793 | 554 | 3107 | 13132 | 42.2871 | -2.5396 | 2020-12-03 05:28:22 | La Rioja, Spain | ||
2537690 | 2537690 | 2020-12-01 | Spain | La Rioja | 16704 | 553 | 3107 | 13044 | 42.2871 | -2.5396 | 2020-12-02 05:27:41 | La Rioja, Spain | ||
1584459 | 1584459 | 2020-11-30 | Spain | La Rioja | 16669 | 550 | 3107 | 13012 | 42.2871 | -2.5396 | 2020-12-01 05:26:18 | La Rioja, Spain | ||
3566862 | 3566862 | 2020-11-29 | Spain | La Rioja | 16398 | 543 | 3107 | 12748 | 42.2871 | -2.5396 | 2020-11-30 05:26:13 | La Rioja, Spain | ||
2935527 | 2935527 | 2020-11-28 | Spain | La Rioja | 16398 | 543 | 3107 | 12748 | 42.2871 | -2.5396 | 2020-11-29 05:25:55 | La Rioja, Spain | ||
392530 | 392530 | 2020-11-27 | Spain | La Rioja | 16398 | 543 | 3107 | 12748 | 42.2871 | -2.5396 | 2020-11-28 05:25:50 | La Rioja, Spain | ||
923977 | 923977 | 2020-11-26 | Spain | La Rioja | 16328 | 543 | 3107 | 12678 | 42.2871 | -2.5396 | 2020-11-27 05:26:53 | La Rioja, Spain | ||
1972882 | 1972882 | 2020-11-25 | Spain | La Rioja | 16235 | 537 | 3107 | 12591 | 42.2871 | -2.5396 | 2020-11-26 05:27:44 | La Rioja, Spain | ||
1350613 | 1350613 | 2020-11-24 | Spain | La Rioja | 16112 | 533 | 3107 | 12472 | 42.2871 | -2.5396 | 2020-11-25 05:27:20 | La Rioja, Spain | ||
678607 | 678607 | 2020-11-23 | Spain | La Rioja | 16066 | 530 | 3107 | 12429 | 42.2871 | -2.5396 | 2020-11-24 05:27:31 | La Rioja, Spain | ||
3190283 | 3190283 | 2020-11-22 | Spain | La Rioja | 15771 | 526 | 3107 | 12138 | 42.2871 | -2.5396 | 2020-11-23 05:25:26 | La Rioja, Spain | ||
3836777 | 3836777 | 2020-11-21 | Spain | La Rioja | 15771 | 526 | 3107 | 12138 | 42.2871 | -2.5396 | 2020-11-22 05:25:45 | La Rioja, Spain | ||
2701805 | 2701805 | 2020-11-20 | Spain | La Rioja | 15771 | 526 | 3107 | 12138 | 42.2871 | -2.5396 | 2020-11-21 05:25:51 | La Rioja, Spain | ||
821865 | 821865 | 2020-11-19 | Spain | La Rioja | 15667 | 523 | 3107 | 12037 | 42.2871 | -2.5396 | 2020-11-20 05:26:28 | La Rioja, Spain | ||
122999 | 122999 | 2020-11-18 | Spain | La Rioja | 15509 | 521 | 3107 | 11881 | 42.2871 | -2.5396 | 2020-11-19 05:25:23 | La Rioja, Spain | ||
3338887 | 3338887 | 2020-11-17 | Spain | La Rioja | 15381 | 517 | 3107 | 11757 | 42.2871 | -2.5396 | 2020-11-18 05:40:31 | La Rioja, Spain | ||
3169932 | 3169932 | 2020-11-16 | Spain | La Rioja | 15305 | 516 | 3107 | 11682 | 42.2871 | -2.5396 | 2020-11-17 05:25:54 | La Rioja, Spain | ||
2880500 | 2880500 | 2020-11-15 | Spain | La Rioja | 14972 | 506 | 3107 | 11359 | 42.2871 | -2.5396 | 2020-11-16 05:25:57 | La Rioja, Spain | ||
2915478 | 2915478 | 2020-11-14 | Spain | La Rioja | 14972 | 506 | 3107 | 11359 | 42.2871 | -2.5396 | 2020-11-15 05:26:53 | La Rioja, 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]);