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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3675948 | 3675948 | 2021-05-04 | Spain | La Rioja | 29826 | 760 | 3107 | 25959 | 42.2871 | -2.5396 | 2021-05-05 04:20:43 | La Rioja, Spain | ||
2761215 | 2761215 | 2021-05-03 | Spain | La Rioja | 29792 | 760 | 3107 | 25925 | 42.2871 | -2.5396 | 2021-05-04 04:20:34 | La Rioja, Spain | ||
2451068 | 2451068 | 2021-05-02 | Spain | La Rioja | 29605 | 760 | 3107 | 25738 | 42.2871 | -2.5396 | 2021-05-03 04:20:39 | La Rioja, Spain | ||
2825081 | 2825081 | 2021-05-01 | Spain | La Rioja | 29605 | 760 | 3107 | 25738 | 42.2871 | -2.5396 | 2021-05-02 04:20:48 | La Rioja, Spain | ||
380489 | 380489 | 2021-04-30 | Spain | La Rioja | 29605 | 760 | 3107 | 25738 | 42.2871 | -2.5396 | 2021-05-01 04:20:47 | La Rioja, Spain | ||
1636612 | 1636612 | 2021-04-29 | Spain | La Rioja | 29550 | 759 | 3107 | 25684 | 42.2871 | -2.5396 | 2021-04-30 04:21:03 | La Rioja, Spain | ||
3393691 | 3393691 | 2021-04-28 | Spain | La Rioja | 29485 | 757 | 3107 | 25621 | 42.2871 | -2.5396 | 2021-04-29 04:20:55 | La Rioja, Spain | ||
3702407 | 3702407 | 2021-04-27 | Spain | La Rioja | 29412 | 758 | 3107 | 25547 | 42.2871 | -2.5396 | 2021-04-28 04:20:32 | La Rioja, Spain | ||
888416 | 888416 | 2021-04-26 | Spain | La Rioja | 29351 | 757 | 3107 | 25487 | 42.2871 | -2.5396 | 2021-04-27 04:20:52 | La Rioja, Spain | ||
955161 | 955161 | 2021-04-25 | Spain | La Rioja | 29208 | 757 | 3107 | 25344 | 42.2871 | -2.5396 | 2021-04-26 04:21:04 | La Rioja, Spain | ||
3924308 | 3924308 | 2021-04-24 | Spain | La Rioja | 29208 | 757 | 3107 | 25344 | 42.2871 | -2.5396 | 2021-04-25 04:20:32 | La Rioja, Spain | ||
1409339 | 1409339 | 2021-04-23 | Spain | La Rioja | 29208 | 757 | 3107 | 25344 | 42.2871 | -2.5396 | 2021-04-24 04:20:38 | La Rioja, Spain | ||
1568402 | 1568402 | 2021-04-22 | Spain | La Rioja | 29109 | 756 | 3107 | 25246 | 42.2871 | -2.5396 | 2021-04-23 04:20:52 | La Rioja, Spain | ||
3242623 | 3242623 | 2021-04-21 | Spain | La Rioja | 29010 | 756 | 3107 | 25147 | 42.2871 | -2.5396 | 2021-04-22 04:20:53 | La Rioja, Spain | ||
2021019 | 2021019 | 2021-04-20 | Spain | La Rioja | 28875 | 756 | 3107 | 25012 | 42.2871 | -2.5396 | 2021-04-21 04:21:14 | La Rioja, Spain | ||
2411140 | 2411140 | 2021-04-19 | Spain | La Rioja | 28875 | 756 | 3107 | 25012 | 42.2871 | -2.5396 | 2021-04-20 04:20:41 | La Rioja, Spain | ||
3129817 | 3129817 | 2021-04-18 | Spain | La Rioja | 28746 | 753 | 3107 | 24886 | 42.2871 | -2.5396 | 2021-04-19 04:20:57 | La Rioja, Spain | ||
983245 | 983245 | 2021-04-17 | Spain | La Rioja | 28746 | 753 | 3107 | 24886 | 42.2871 | -2.5396 | 2021-04-18 04:20:41 | La Rioja, Spain | ||
170340 | 170340 | 2021-04-16 | Spain | La Rioja | 28746 | 753 | 3107 | 24886 | 42.2871 | -2.5396 | 2021-04-17 04:20:40 | La Rioja, Spain | ||
2549171 | 2549171 | 2021-04-15 | Spain | La Rioja | 28634 | 752 | 3107 | 24775 | 42.2871 | -2.5396 | 2021-04-16 04:20:46 | La Rioja, Spain | ||
1842241 | 1842241 | 2021-04-14 | Spain | La Rioja | 28586 | 751 | 3107 | 24728 | 42.2871 | -2.5396 | 2021-04-15 04:20:54 | La Rioja, Spain | ||
2571975 | 2571975 | 2021-04-13 | Spain | La Rioja | 28525 | 751 | 3107 | 24667 | 42.2871 | -2.5396 | 2021-04-14 04:20:41 | La Rioja, Spain | ||
36726 | 36726 | 2021-04-12 | Spain | La Rioja | 28480 | 751 | 3107 | 24622 | 42.2871 | -2.5396 | 2021-04-13 04:20:37 | La Rioja, Spain | ||
3883885 | 3883885 | 2021-04-11 | Spain | La Rioja | 28340 | 751 | 3107 | 24482 | 42.2871 | -2.5396 | 2021-04-12 04:21:00 | La Rioja, Spain | ||
2983553 | 2983553 | 2021-04-10 | Spain | La Rioja | 28340 | 751 | 3107 | 24482 | 42.2871 | -2.5396 | 2021-04-11 04:20:56 | La Rioja, Spain | ||
605985 | 605985 | 2021-04-09 | Spain | La Rioja | 28340 | 751 | 3107 | 24482 | 42.2871 | -2.5396 | 2021-04-10 04:20:59 | La Rioja, Spain | ||
2646049 | 2646049 | 2021-04-08 | Spain | La Rioja | 28282 | 750 | 3107 | 24425 | 42.2871 | -2.5396 | 2021-04-09 04:21:13 | La Rioja, Spain | ||
2247691 | 2247691 | 2021-04-07 | Spain | La Rioja | 28193 | 748 | 3107 | 24338 | 42.2871 | -2.5396 | 2021-04-08 04:21:13 | La Rioja, Spain | ||
3003601 | 3003601 | 2021-04-06 | Spain | La Rioja | 28140 | 748 | 3107 | 24285 | 42.2871 | -2.5396 | 2021-04-07 04:20:53 | La Rioja, Spain | ||
3085596 | 3085596 | 2021-04-05 | Spain | La Rioja | 28115 | 748 | 3107 | 24260 | 42.2871 | -2.5396 | 2021-04-06 04:20:32 | La Rioja, Spain | ||
388519 | 388519 | 2021-04-04 | Spain | La Rioja | 28049 | 745 | 3107 | 24197 | 42.2871 | -2.5396 | 2021-04-05 04:20:35 | La Rioja, Spain | ||
3710435 | 3710435 | 2021-04-03 | Spain | La Rioja | 28049 | 745 | 3107 | 24197 | 42.2871 | -2.5396 | 2021-04-04 04:20:49 | La Rioja, Spain | ||
241551 | 241551 | 2021-04-02 | Spain | La Rioja | 27955 | 744 | 3107 | 24104 | 42.2871 | -2.5396 | 2021-04-03 04:20:44 | La Rioja, Spain | ||
1302348 | 1302348 | 2021-04-01 | Spain | La Rioja | 27955 | 744 | 3107 | 24104 | 42.2871 | -2.5396 | 2021-04-02 04:20:36 | La Rioja, Spain | ||
638220 | 638220 | 2021-03-31 | Spain | La Rioja | 27895 | 744 | 3107 | 24044 | 42.2871 | -2.5396 | 2021-04-01 04:27:05 | La Rioja, Spain | ||
3643849 | 3643849 | 2021-03-30 | Spain | La Rioja | 27847 | 744 | 3107 | 23996 | 42.2871 | -2.5396 | 2021-03-31 04:26:25 | La Rioja, Spain | ||
1290302 | 1290302 | 2021-03-29 | Spain | La Rioja | 27801 | 744 | 3107 | 23950 | 42.2871 | -2.5396 | 2021-03-30 04:26:23 | La Rioja, Spain | ||
1536224 | 1536224 | 2021-03-28 | Spain | La Rioja | 27690 | 743 | 3107 | 23840 | 42.2871 | -2.5396 | 2021-03-29 04:28:35 | La Rioja, Spain | ||
1219864 | 1219864 | 2021-03-27 | Spain | La Rioja | 27690 | 743 | 3107 | 23840 | 42.2871 | -2.5396 | 2021-03-28 05:28:10 | La Rioja, Spain | ||
1881282 | 1881282 | 2021-03-26 | Spain | La Rioja | 27690 | 743 | 3107 | 23840 | 42.2871 | -2.5396 | 2021-03-27 05:25:04 | La Rioja, Spain | ||
1980912 | 1980912 | 2021-03-25 | Spain | La Rioja | 27643 | 742 | 3107 | 23794 | 42.2871 | -2.5396 | 2021-03-26 05:26:55 | La Rioja, Spain | ||
2781290 | 2781290 | 2021-03-24 | Spain | La Rioja | 27563 | 740 | 3107 | 23716 | 42.2871 | -2.5396 | 2021-03-25 05:27:00 | La Rioja, Spain | ||
1798935 | 1798935 | 2021-03-23 | Spain | La Rioja | 27563 | 740 | 3107 | 23716 | 42.2871 | -2.5396 | 2021-03-24 05:25:40 | La Rioja, Spain | ||
1204103 | 1204103 | 2021-03-22 | Spain | La Rioja | 27547 | 740 | 3107 | 23700 | 42.2871 | -2.5396 | 2021-03-23 05:26:18 | La Rioja, Spain | ||
3369625 | 3369625 | 2021-03-21 | Spain | La Rioja | 27442 | 738 | 3107 | 23597 | 42.2871 | -2.5396 | 2021-03-22 05:25:43 | La Rioja, Spain | ||
1744835 | 1744835 | 2021-03-20 | Spain | La Rioja | 27442 | 738 | 3107 | 23597 | 42.2871 | -2.5396 | 2021-03-21 05:25:44 | La Rioja, Spain | ||
3421215 | 3421215 | 2021-03-19 | Spain | La Rioja | 27442 | 738 | 3107 | 23597 | 42.2871 | -2.5396 | 2021-03-20 05:25:46 | La Rioja, Spain | ||
3453153 | 3453153 | 2021-03-18 | Spain | La Rioja | 27442 | 738 | 3107 | 23597 | 42.2871 | -2.5396 | 2021-03-19 05:26:09 | La Rioja, Spain | ||
3621377 | 3621377 | 2021-03-17 | Spain | La Rioja | 27423 | 737 | 3107 | 23579 | 42.2871 | -2.5396 | 2021-03-18 05:26:22 | La Rioja, Spain | ||
702701 | 702701 | 2021-03-16 | Spain | La Rioja | 27415 | 738 | 3107 | 23570 | 42.2871 | -2.5396 | 2021-03-17 05:25:07 | La Rioja, Spain | ||
2056179 | 2056179 | 2021-03-15 | Spain | La Rioja | 27409 | 737 | 3107 | 23565 | 42.2871 | -2.5396 | 2021-03-16 05:25:13 | La Rioja, Spain | ||
1732791 | 1732791 | 2021-03-14 | Spain | La Rioja | 27360 | 733 | 3107 | 23520 | 42.2871 | -2.5396 | 2021-03-15 05:25:51 | La Rioja, Spain | ||
1580448 | 1580448 | 2021-03-13 | Spain | La Rioja | 27360 | 733 | 3107 | 23520 | 42.2871 | -2.5396 | 2021-03-14 05:25:37 | La Rioja, Spain | ||
1838227 | 1838227 | 2021-03-12 | Spain | La Rioja | 27360 | 733 | 3107 | 23520 | 42.2871 | -2.5396 | 2021-03-13 05:25:15 | La Rioja, Spain | ||
352592 | 352592 | 2021-03-11 | Spain | La Rioja | 27646 | 732 | 3107 | 23807 | 42.2871 | -2.5396 | 2021-03-12 05:26:50 | La Rioja, Spain | ||
3962816 | 3962816 | 2021-03-10 | Spain | La Rioja | 27623 | 731 | 3107 | 23785 | 42.2871 | -2.5396 | 2021-03-11 05:25:48 | La Rioja, Spain | ||
3663904 | 3663904 | 2021-03-09 | Spain | La Rioja | 27606 | 730 | 3107 | 23769 | 42.2871 | -2.5396 | 2021-03-10 05:24:35 | La Rioja, Spain | ||
2359763 | 2359763 | 2021-03-08 | Spain | La Rioja | 27592 | 730 | 3107 | 23755 | 42.2871 | -2.5396 | 2021-03-09 05:28:19 | La Rioja, Spain | ||
55101 | 55101 | 2021-03-07 | Spain | La Rioja | 27553 | 729 | 3107 | 23717 | 42.2871 | -2.5396 | 2021-03-08 05:24:48 | La Rioja, Spain | ||
3667918 | 3667918 | 2021-03-06 | Spain | La Rioja | 27553 | 729 | 3107 | 23717 | 42.2871 | -2.5396 | 2021-03-07 05:21:54 | La Rioja, Spain | ||
1616539 | 1616539 | 2021-03-05 | Spain | La Rioja | 27553 | 729 | 3107 | 23717 | 42.2871 | -2.5396 | 2021-03-06 04:23:41 | La Rioja, Spain | ||
2207950 | 2207950 | 2021-03-04 | Spain | La Rioja | 27529 | 728 | 3107 | 23694 | 42.2871 | -2.5396 | 2021-03-05 05:26:29 | La Rioja, Spain | ||
1090371 | 1090371 | 2021-03-03 | Spain | La Rioja | 27506 | 728 | 3107 | 23671 | 42.2871 | -2.5396 | 2021-03-04 05:24:24 | La Rioja, Spain | ||
3254443 | 3254443 | 2021-03-02 | Spain | La Rioja | 27480 | 726 | 3107 | 23647 | 42.2871 | -2.5396 | 2021-03-03 05:23:28 | La Rioja, Spain | ||
998735 | 998735 | 2021-03-01 | Spain | La Rioja | 27463 | 725 | 3107 | 23631 | 42.2871 | -2.5396 | 2021-03-02 05:23:30 | La Rioja, Spain | ||
2367793 | 2367793 | 2021-02-28 | Spain | La Rioja | 27422 | 725 | 3107 | 23590 | 42.2871 | -2.5396 | 2021-03-01 05:23:01 | La Rioja, Spain | ||
3066295 | 3066295 | 2021-02-27 | Spain | La Rioja | 27422 | 725 | 3107 | 23590 | 42.2871 | -2.5396 | 2021-02-28 05:22:20 | La Rioja, Spain | ||
2183879 | 2183879 | 2021-02-26 | Spain | La Rioja | 27422 | 725 | 3107 | 23590 | 42.2871 | -2.5396 | 2021-02-27 05:22:28 | La Rioja, Spain | ||
1858301 | 1858301 | 2021-02-25 | Spain | La Rioja | 27404 | 724 | 3107 | 23573 | 42.2871 | -2.5396 | 2021-02-26 05:22:40 | La Rioja, Spain | ||
280479 | 280479 | 2021-02-24 | Spain | La Rioja | 27392 | 723 | 3107 | 23562 | 42.2871 | -2.5396 | 2021-02-25 05:24:57 | La Rioja, Spain | ||
1936747 | 1936747 | 2021-02-23 | Spain | La Rioja | 27372 | 721 | 3107 | 23544 | 42.2871 | -2.5396 | 2021-02-24 05:29:16 | La Rioja, Spain | ||
531002 | 531002 | 2021-02-22 | Spain | La Rioja | 27355 | 718 | 3107 | 23530 | 42.2871 | -2.5396 | 2021-02-23 05:23:41 | La Rioja, Spain | ||
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 |
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]);