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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2785300 | 2785300 | 2020-11-13 | Spain | La Rioja | 14972 | 506 | 3107 | 11359 | 42.2871 | -2.5396 | 2020-11-14 05:25:37 | La Rioja, Spain | ||
865065 | 865065 | 2020-11-12 | Spain | La Rioja | 14796 | 504 | 3107 | 11185 | 42.2871 | -2.5396 | 2020-11-13 05:25:30 | La Rioja, Spain | ||
3441109 | 3441109 | 2020-11-11 | Spain | La Rioja | 14587 | 498 | 3107 | 10982 | 42.2871 | -2.5396 | 2020-11-12 05:25:55 | La Rioja, Spain | ||
272449 | 272449 | 2020-11-10 | Spain | La Rioja | 14277 | 492 | 3107 | 10678 | 42.2871 | -2.5396 | 2020-11-11 05:25:30 | La Rioja, Spain | ||
1988926 | 1988926 | 2020-11-09 | Spain | La Rioja | 14277 | 492 | 3107 | 10678 | 42.2871 | -2.5396 | 2020-11-10 05:40:07 | La Rioja, Spain | ||
1728778 | 1728778 | 2020-11-08 | Spain | La Rioja | 13817 | 482 | 3107 | 10228 | 42.2871 | -2.5396 | 2020-11-09 05:25:45 | La Rioja, Spain | ||
1544238 | 1544238 | 2020-11-07 | Spain | La Rioja | 13817 | 482 | 3107 | 10228 | 42.2871 | -2.5396 | 2020-11-08 05:24:56 | La Rioja, Spain | ||
376476 | 376476 | 2020-11-06 | Spain | La Rioja | 13817 | 482 | 3107 | 10228 | 42.2871 | -2.5396 | 2020-11-07 05:24:52 | La Rioja, Spain | ||
892414 | 892414 | 2020-11-05 | Spain | La Rioja | 13568 | 479 | 3107 | 9982 | 42.2871 | -2.5396 | 2020-11-06 05:24:55 | La Rioja, Spain | ||
2919476 | 2919476 | 2020-11-04 | Spain | La Rioja | 13271 | 477 | 3107 | 9687 | 42.2871 | -2.5396 | 2020-11-05 06:05:03 | La Rioja, Spain | ||
2498313 | 2498313 | 2020-11-03 | Spain | La Rioja | 13122 | 471 | 3107 | 9544 | 42.2871 | -2.5396 | 2020-11-04 05:25:09 | La Rioja, Spain | ||
3304488 | 3304488 | 2020-11-02 | Spain | La Rioja | 13009 | 470 | 3107 | 9432 | 42.2871 | -2.5396 | 2020-11-03 06:00:16 | La Rioja, Spain | ||
3409737 | 3409737 | 2020-11-01 | Spain | La Rioja | 12510 | 463 | 3107 | 8940 | 42.2871 | -2.5396 | 2020-11-02 05:25:04 | La Rioja, Spain | ||
2080226 | 2080226 | 2020-10-31 | Spain | La Rioja | 12510 | 463 | 3107 | 8940 | 42.2871 | -2.5396 | 2020-11-01 04:36:19 | La Rioja, Spain | ||
2243679 | 2243679 | 2020-10-30 | Spain | La Rioja | 12510 | 463 | 3107 | 8940 | 42.2871 | -2.5396 | 2020-10-31 04:24:44 | La Rioja, Spain | ||
210534 | 210534 | 2020-10-29 | Spain | La Rioja | 12324 | 458 | 3107 | 8759 | 42.2871 | -2.5396 | 2020-10-30 04:24:49 | La Rioja, Spain | ||
754596 | 754596 | 2020-10-28 | Spain | La Rioja | 12093 | 456 | 3107 | 8530 | 42.2871 | -2.5396 | 2020-10-29 04:24:49 | La Rioja, Spain | ||
1452880 | 1452880 | 2020-10-27 | Spain | La Rioja | 11899 | 454 | 3107 | 8338 | 42.2871 | -2.5396 | 2020-10-28 04:24:39 | La Rioja, Spain | ||
3480604 | 3480604 | 2020-10-26 | Spain | La Rioja | 11759 | 453 | 3107 | 8199 | 42.2871 | -2.5396 | 2020-10-27 04:24:45 | La Rioja, Spain | ||
8625 | 8625 | 2020-10-25 | Spain | La Rioja | 11300 | 442 | 3107 | 7751 | 42.2871 | -2.5396 | 2020-10-26 04:25:02 | La Rioja, Spain | ||
3651862 | 3651862 | 2020-10-24 | Spain | La Rioja | 11300 | 442 | 3107 | 7751 | 42.2871 | -2.5396 | 2020-10-25 04:24:36 | La Rioja, Spain | ||
1054117 | 1054117 | 2020-10-23 | Spain | La Rioja | 11300 | 442 | 3107 | 7751 | 42.2871 | -2.5396 | 2020-10-24 04:24:46 | La Rioja, Spain | ||
1177787 | 1177787 | 2020-10-22 | Spain | La Rioja | 11121 | 441 | 3107 | 7573 | 42.2871 | -2.5396 | 2020-10-23 04:24:46 | La Rioja, Spain | ||
2191892 | 2191892 | 2020-10-21 | Spain | La Rioja | 10876 | 440 | 3107 | 7329 | 42.2871 | -2.5396 | 2020-10-22 04:24:27 | La Rioja, Spain | ||
3990903 | 3990903 | 2020-10-20 | Spain | La Rioja | 10722 | 440 | 3107 | 7175 | 42.2871 | -2.5396 | 2020-10-21 04:24:14 | La Rioja, Spain | ||
1794923 | 1794923 | 2020-10-19 | Spain | La Rioja | 10591 | 439 | 3107 | 7045 | 42.2871 | -2.5396 | 2020-10-20 04:24:22 | La Rioja, Spain | ||
762607 | 762607 | 2020-10-18 | Spain | La Rioja | 10136 | 436 | 3107 | 6593 | 42.2871 | -2.5396 | 2020-10-19 04:24:16 | La Rioja, Spain | ||
1026645 | 1026645 | 2020-10-17 | Spain | La Rioja | 10136 | 436 | 3107 | 6593 | 42.2871 | -2.5396 | 2020-10-18 04:24:25 | La Rioja, Spain | ||
2857140 | 2857140 | 2020-10-16 | Spain | La Rioja | 10136 | 436 | 3107 | 6593 | 42.2871 | -2.5396 | 2020-10-17 04:24:12 | La Rioja, Spain | ||
786670 | 786670 | 2020-10-15 | Spain | La Rioja | 9981 | 434 | 3107 | 6440 | 42.2871 | -2.5396 | 2020-10-16 04:24:01 | La Rioja, Spain | ||
79381 | 79381 | 2020-10-14 | Spain | La Rioja | 9851 | 435 | 3107 | 6309 | 42.2871 | -2.5396 | 2020-10-15 04:24:28 | La Rioja, Spain | ||
3782196 | 3782196 | 2020-10-13 | Spain | La Rioja | 9669 | 430 | 3107 | 6132 | 42.2871 | -2.5396 | 2020-10-14 04:24:05 | La Rioja, Spain | ||
2291736 | 2291736 | 2020-10-12 | Spain | La Rioja | 9505 | 429 | 3107 | 5969 | 42.2871 | -2.5396 | 2020-10-13 04:24:02 | La Rioja, Spain | ||
3786188 | 3786188 | 2020-10-11 | Spain | La Rioja | 9299 | 426 | 3107 | 5766 | 42.2871 | -2.5396 | 2020-10-12 04:23:45 | La Rioja, Spain | ||
2602326 | 2602326 | 2020-10-10 | Spain | La Rioja | 9299 | 426 | 3107 | 5766 | 42.2871 | -2.5396 | 2020-10-11 04:23:46 | 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]);