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)
province_or_state 1
- La Rioja · 403 ✖
country_or_region 1
- Spain · 403 ✖
combined_key 1 ✖
- La Rioja, Spain 403
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884667 | 2884667 | 2021-06-20 | Spain | La Rioja | 31645 | 775 | 3107 | 27763 | 42.2871 | -2.5396 | 2021-06-21 04:21:41 | La Rioja, Spain | ||
107750 | 107750 | 2021-06-19 | Spain | La Rioja | 31645 | 775 | 3107 | 27763 | 42.2871 | -2.5396 | 2021-06-20 04:21:48 | La Rioja, Spain | ||
1125893 | 1125893 | 2021-06-18 | Spain | La Rioja | 31645 | 775 | 3107 | 27763 | 42.2871 | -2.5396 | 2021-06-19 04:22:33 | La Rioja, Spain | ||
2911471 | 2911471 | 2021-06-17 | Spain | La Rioja | 31600 | 775 | 3107 | 27718 | 42.2871 | -2.5396 | 2021-06-18 04:22:16 | La Rioja, Spain | ||
3030587 | 3030587 | 2021-06-16 | Spain | La Rioja | 31560 | 775 | 3107 | 27678 | 42.2871 | -2.5396 | 2021-06-17 04:22:36 | La Rioja, Spain | ||
2339693 | 2339693 | 2021-06-15 | Spain | La Rioja | 31518 | 775 | 3107 | 27636 | 42.2871 | -2.5396 | 2021-06-16 04:22:32 | La Rioja, Spain | ||
1564389 | 1564389 | 2021-06-14 | Spain | La Rioja | 31482 | 775 | 3107 | 27600 | 42.2871 | -2.5396 | 2021-06-15 04:22:22 | La Rioja, Spain | ||
3381672 | 3381672 | 2021-06-13 | Spain | La Rioja | 31409 | 775 | 3107 | 27527 | 42.2871 | -2.5396 | 2021-06-14 04:22:46 | La Rioja, Spain | ||
1736806 | 1736806 | 2021-06-12 | Spain | La Rioja | 31409 | 775 | 3107 | 27527 | 42.2871 | -2.5396 | 2021-06-13 04:22:44 | La Rioja, Spain | ||
3970847 | 3970847 | 2021-06-11 | Spain | La Rioja | 31409 | 775 | 3107 | 27527 | 42.2871 | -2.5396 | 2021-06-12 04:22:22 | La Rioja, Spain | ||
2717269 | 2717269 | 2021-06-10 | Spain | La Rioja | 31367 | 775 | 3107 | 27485 | 42.2871 | -2.5396 | 2021-06-11 04:23:20 | La Rioja, Spain | ||
523154 | 523154 | 2021-06-09 | Spain | La Rioja | 31348 | 775 | 3107 | 27466 | 42.2871 | -2.5396 | 2021-06-10 04:23:17 | La Rioja, Spain | ||
3472594 | 3472594 | 2021-06-08 | Spain | La Rioja | 31305 | 774 | 3107 | 27424 | 42.2871 | -2.5396 | 2021-06-09 04:23:31 | La Rioja, Spain | ||
3145878 | 3145878 | 2021-06-07 | Spain | La Rioja | 31265 | 774 | 3107 | 27384 | 42.2871 | -2.5396 | 2021-06-08 04:22:35 | La Rioja, Spain | ||
825880 | 825880 | 2021-06-06 | Spain | La Rioja | 31141 | 773 | 3107 | 27261 | 42.2871 | -2.5396 | 2021-06-07 04:22:51 | La Rioja, Spain | ||
2586285 | 2586285 | 2021-06-05 | Spain | La Rioja | 31141 | 773 | 3107 | 27261 | 42.2871 | -2.5396 | 2021-06-06 04:24:03 | La Rioja, Spain | ||
2315599 | 2315599 | 2021-06-04 | Spain | La Rioja | 31141 | 773 | 3107 | 27261 | 42.2871 | -2.5396 | 2021-06-05 04:23:03 | La Rioja, Spain | ||
1448884 | 1448884 | 2021-06-03 | Spain | La Rioja | 31097 | 771 | 3107 | 27219 | 42.2871 | -2.5396 | 2021-06-04 04:23:37 | La Rioja, Spain | ||
1708608 | 1708608 | 2021-06-02 | Spain | La Rioja | 30999 | 771 | 3107 | 27121 | 42.2871 | -2.5396 | 2021-06-03 04:23:32 | La Rioja, Spain | ||
2104426 | 2104426 | 2021-06-01 | Spain | La Rioja | 30942 | 771 | 3107 | 27064 | 42.2871 | -2.5396 | 2021-06-02 04:24:34 | La Rioja, Spain | ||
1189042 | 1189042 | 2021-05-31 | Spain | La Rioja | 30897 | 771 | 3107 | 27019 | 42.2871 | -2.5396 | 2021-06-01 04:23:09 | La Rioja, Spain | ||
3089719 | 3089719 | 2021-05-30 | Spain | La Rioja | 30749 | 771 | 3107 | 26871 | 42.2871 | -2.5396 | 2021-05-31 03:08:59 | La Rioja, Spain | ||
51088 | 51088 | 2021-05-29 | Spain | La Rioja | 30749 | 771 | 3107 | 26871 | 42.2871 | -2.5396 | 2021-05-30 04:20:55 | La Rioja, Spain | ||
20667 | 20667 | 2021-05-28 | Spain | La Rioja | 30749 | 771 | 3107 | 26871 | 42.2871 | -2.5396 | 2021-05-29 04:20:41 | La Rioja, Spain | ||
1807042 | 1807042 | 2021-05-27 | Spain | La Rioja | 30719 | 771 | 3107 | 26841 | 42.2871 | -2.5396 | 2021-05-28 04:20:36 | La Rioja, Spain | ||
1310465 | 1310465 | 2021-05-26 | Spain | La Rioja | 30695 | 771 | 3107 | 26817 | 42.2871 | -2.5396 | 2021-05-27 04:20:59 | La Rioja, Spain | ||
83391 | 83391 | 2021-05-25 | Spain | La Rioja | 30612 | 771 | 3107 | 26734 | 42.2871 | -2.5396 | 2021-05-26 04:20:35 | La Rioja, Spain | ||
1413353 | 1413353 | 2021-05-24 | Spain | La Rioja | 30562 | 771 | 3107 | 26684 | 42.2871 | -2.5396 | 2021-05-25 04:21:08 | La Rioja, Spain | ||
1771639 | 1771639 | 2021-05-23 | Spain | La Rioja | 30470 | 769 | 3107 | 26594 | 42.2871 | -2.5396 | 2021-05-24 04:20:53 | La Rioja, Spain | ||
726794 | 726794 | 2021-05-22 | Spain | La Rioja | 30470 | 769 | 3107 | 26594 | 42.2871 | -2.5396 | 2021-05-23 04:20:51 | La Rioja, Spain | ||
1952809 | 1952809 | 2021-05-21 | Spain | La Rioja | 30470 | 769 | 3107 | 26594 | 42.2871 | -2.5396 | 2021-05-22 04:20:45 | La Rioja, Spain | ||
1913508 | 1913508 | 2021-05-20 | Spain | La Rioja | 30431 | 769 | 3107 | 26555 | 42.2871 | -2.5396 | 2021-05-21 04:20:43 | La Rioja, Spain | ||
2256029 | 2256029 | 2021-05-19 | Spain | La Rioja | 30401 | 769 | 3107 | 26525 | 42.2871 | -2.5396 | 2021-05-20 04:21:05 | La Rioja, Spain | ||
2391067 | 2391067 | 2021-05-18 | Spain | La Rioja | 30356 | 769 | 3107 | 26480 | 42.2871 | -2.5396 | 2021-05-19 04:20:42 | La Rioja, Spain | ||
3574892 | 3574892 | 2021-05-17 | Spain | La Rioja | 30338 | 769 | 3107 | 26462 | 42.2871 | -2.5396 | 2021-05-18 04:20:33 | La Rioja, Spain | ||
2939622 | 2939622 | 2021-05-16 | Spain | La Rioja | 30258 | 767 | 3107 | 26384 | 42.2871 | -2.5396 | 2021-05-17 04:20:34 | La Rioja, Spain | ||
1873252 | 1873252 | 2021-05-15 | Spain | La Rioja | 30258 | 767 | 3107 | 26384 | 42.2871 | -2.5396 | 2021-05-16 04:20:49 | La Rioja, Spain | ||
1082221 | 1082221 | 2021-05-14 | Spain | La Rioja | 30258 | 767 | 3107 | 26384 | 42.2871 | -2.5396 | 2021-05-15 04:20:58 | La Rioja, Spain | ||
3054487 | 3054487 | 2021-05-13 | Spain | La Rioja | 30222 | 766 | 3107 | 26349 | 42.2871 | -2.5396 | 2021-05-14 04:20:41 | La Rioja, Spain | ||
2004957 | 2004957 | 2021-05-12 | Spain | La Rioja | 30181 | 765 | 3107 | 26309 | 42.2871 | -2.5396 | 2021-05-13 04:20:51 | La Rioja, Spain | ||
3954788 | 3954788 | 2021-05-11 | Spain | La Rioja | 30135 | 764 | 3107 | 26264 | 42.2871 | -2.5396 | 2021-05-12 04:21:29 | La Rioja, Spain | ||
2821067 | 2821067 | 2021-05-10 | Spain | La Rioja | 30098 | 762 | 3107 | 26229 | 42.2871 | -2.5396 | 2021-05-11 04:20:41 | La Rioja, Spain | ||
1425399 | 1425399 | 2021-05-09 | Spain | La Rioja | 30005 | 762 | 3107 | 26136 | 42.2871 | -2.5396 | 2021-05-10 04:20:38 | La Rioja, Spain | ||
1552267 | 1552267 | 2021-05-08 | Spain | La Rioja | 30005 | 762 | 3107 | 26136 | 42.2871 | -2.5396 | 2021-05-09 04:20:35 | La Rioja, Spain | ||
2502325 | 2502325 | 2021-05-07 | Spain | La Rioja | 30005 | 762 | 3107 | 26136 | 42.2871 | -2.5396 | 2021-05-08 04:21:04 | La Rioja, Spain | ||
3113781 | 3113781 | 2021-05-06 | Spain | La Rioja | 29958 | 761 | 3107 | 26090 | 42.2871 | -2.5396 | 2021-05-07 04:20:40 | La Rioja, Spain | ||
646248 | 646248 | 2021-05-05 | Spain | La Rioja | 29912 | 761 | 3107 | 26044 | 42.2871 | -2.5396 | 2021-05-06 04:20:38 | La Rioja, Spain | ||
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 |
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]);