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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2463091 | 2463091 | 2021-09-14 | Spain | La Rioja | 39285 | 822 | 0 | 42.2871 | -2.5396 | 2021-09-15 03:22:37 | La Rioja, Spain | |||
1385930 | 1385930 | 2021-09-13 | Spain | La Rioja | 39267 | 821 | 0 | 42.2871 | -2.5396 | 2021-09-14 04:21:41 | La Rioja, Spain | |||
1885299 | 1885299 | 2021-09-12 | Spain | La Rioja | 39225 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-13 04:21:15 | La Rioja, Spain | |||
3806202 | 3806202 | 2021-09-11 | Spain | La Rioja | 39225 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-12 04:21:13 | La Rioja, Spain | |||
3449142 | 3449142 | 2021-09-10 | Spain | La Rioja | 39225 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-11 04:21:30 | La Rioja, Spain | |||
1263088 | 1263088 | 2021-09-09 | Spain | La Rioja | 39197 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-10 04:21:20 | La Rioja, Spain | |||
2279458 | 2279458 | 2021-09-08 | Spain | La Rioja | 39181 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-09 04:21:27 | La Rioja, Spain | |||
642237 | 642237 | 2021-09-07 | Spain | La Rioja | 39159 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-08 04:21:31 | La Rioja, Spain | |||
3194300 | 3194300 | 2021-09-06 | Spain | La Rioja | 39138 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-07 04:21:35 | La Rioja, Spain | |||
3281168 | 3281168 | 2021-09-05 | Spain | La Rioja | 39065 | 819 | 0 | 42.2871 | -2.5396 | 2021-09-06 04:21:22 | La Rioja, Spain | |||
249582 | 249582 | 2021-09-04 | Spain | La Rioja | 39065 | 819 | 0 | 42.2871 | -2.5396 | 2021-09-05 04:21:33 | La Rioja, Spain | |||
3974863 | 3974863 | 2021-09-03 | Spain | La Rioja | 39065 | 819 | 0 | 42.2871 | -2.5396 | 2021-09-04 04:21:28 | La Rioja, Spain | |||
178325 | 178325 | 2021-09-02 | Spain | La Rioja | 39032 | 818 | 0 | 42.2871 | -2.5396 | 2021-09-03 04:21:20 | La Rioja, Spain | |||
67360 | 67360 | 2021-09-01 | Spain | La Rioja | 38984 | 818 | 0 | 42.2871 | -2.5396 | 2021-09-02 04:21:15 | La Rioja, Spain | |||
2068202 | 2068202 | 2021-08-31 | Spain | La Rioja | 38953 | 818 | 0 | 42.2871 | -2.5396 | 2021-09-01 04:21:38 | La Rioja, Spain | |||
1775656 | 1775656 | 2021-08-30 | Spain | La Rioja | 38903 | 818 | 0 | 42.2871 | -2.5396 | 2021-08-31 04:21:46 | La Rioja, Spain | |||
3892230 | 3892230 | 2021-08-29 | Spain | La Rioja | 38765 | 816 | 0 | 42.2871 | -2.5396 | 2021-08-30 04:21:23 | La Rioja, Spain | |||
2793333 | 2793333 | 2021-08-28 | Spain | La Rioja | 38765 | 816 | 0 | 42.2871 | -2.5396 | 2021-08-29 04:21:14 | La Rioja, Spain | |||
2923492 | 2923492 | 2021-08-27 | Spain | La Rioja | 38765 | 816 | 0 | 42.2871 | -2.5396 | 2021-08-28 04:21:28 | La Rioja, Spain | |||
1596506 | 1596506 | 2021-08-26 | Spain | La Rioja | 38704 | 815 | 0 | 42.2871 | -2.5396 | 2021-08-27 04:21:37 | La Rioja, Spain | |||
32715 | 32715 | 2021-08-25 | Spain | La Rioja | 38628 | 815 | 0 | 42.2871 | -2.5396 | 2021-08-26 04:21:28 | La Rioja, Spain | |||
3105754 | 3105754 | 2021-08-24 | Spain | La Rioja | 38561 | 814 | 0 | 42.2871 | -2.5396 | 2021-08-25 04:21:41 | La Rioja, Spain | |||
3165925 | 3165925 | 2021-08-23 | Spain | La Rioja | 38488 | 813 | 0 | 42.2871 | -2.5396 | 2021-08-24 04:21:19 | La Rioja, Spain | |||
2175852 | 2175852 | 2021-08-22 | Spain | La Rioja | 38277 | 812 | 0 | 42.2871 | -2.5396 | 2021-08-23 04:21:27 | La Rioja, Spain | |||
3555948 | 3555948 | 2021-08-21 | Spain | La Rioja | 38277 | 812 | 0 | 42.2871 | -2.5396 | 2021-08-22 04:21:29 | La Rioja, Spain | |||
1854290 | 1854290 | 2021-08-20 | Spain | La Rioja | 38277 | 812 | 0 | 42.2871 | -2.5396 | 2021-08-21 04:21:38 | La Rioja, Spain | |||
511997 | 511997 | 2021-08-19 | Spain | La Rioja | 38173 | 812 | 0 | 42.2871 | -2.5396 | 2021-08-20 04:21:33 | La Rioja, Spain | |||
2518476 | 2518476 | 2021-08-18 | Spain | La Rioja | 38064 | 811 | 0 | 42.2871 | -2.5396 | 2021-08-19 04:21:15 | La Rioja, Spain | |||
245568 | 245568 | 2021-08-17 | Spain | La Rioja | 37953 | 809 | 0 | 42.2871 | -2.5396 | 2021-08-18 04:21:35 | La Rioja, Spain | |||
1604531 | 1604531 | 2021-08-16 | Spain | La Rioja | 37883 | 809 | 0 | 42.2871 | -2.5396 | 2021-08-17 04:21:49 | La Rioja, Spain | |||
103625 | 103625 | 2021-08-15 | Spain | La Rioja | 37650 | 808 | 0 | 42.2871 | -2.5396 | 2021-08-16 04:21:31 | La Rioja, Spain | |||
507983 | 507983 | 2021-08-14 | Spain | La Rioja | 37650 | 808 | 0 | 42.2871 | -2.5396 | 2021-08-15 04:21:41 | La Rioja, Spain | |||
1483855 | 1483855 | 2021-08-13 | Spain | La Rioja | 37650 | 808 | 0 | 42.2871 | -2.5396 | 2021-08-14 04:21:25 | La Rioja, Spain | |||
2899985 | 2899985 | 2021-08-12 | Spain | La Rioja | 37536 | 808 | 0 | 42.2871 | -2.5396 | 2021-08-13 04:21:24 | La Rioja, Spain | |||
1342589 | 1342589 | 2021-08-11 | Spain | La Rioja | 37431 | 806 | 0 | 42.2871 | -2.5396 | 2021-08-12 04:21:25 | La Rioja, Spain | |||
2351736 | 2351736 | 2021-08-10 | Spain | La Rioja | 37271 | 804 | 0 | 42.2871 | -2.5396 | 2021-08-11 04:21:58 | La Rioja, Spain | |||
650265 | 650265 | 2021-08-09 | Spain | La Rioja | 37184 | 802 | 0 | 42.2871 | -2.5396 | 2021-08-10 04:21:27 | La Rioja, Spain | |||
589927 | 589927 | 2021-08-08 | Spain | La Rioja | 36880 | 798 | 0 | 42.2871 | -2.5396 | 2021-08-09 04:21:24 | La Rioja, Spain | |||
2203939 | 2203939 | 2021-08-07 | Spain | La Rioja | 36880 | 798 | 0 | 42.2871 | -2.5396 | 2021-08-08 04:21:33 | La Rioja, Spain | |||
1117889 | 1117889 | 2021-08-06 | Spain | La Rioja | 36880 | 798 | 0 | 42.2871 | -2.5396 | 2021-08-07 04:21:30 | La Rioja, Spain | |||
1956826 | 1956826 | 2021-08-05 | Spain | La Rioja | 36716 | 798 | 0 | 42.2871 | -2.5396 | 2021-08-06 04:21:18 | La Rioja, Spain | |||
332205 | 332205 | 2021-08-04 | Spain | La Rioja | 36563 | 797 | 3107 | 32659 | 42.2871 | -2.5396 | 2021-08-05 04:21:51 | La Rioja, Spain | ||
3468476 | 3468476 | 2021-08-03 | Spain | La Rioja | 36370 | 795 | 3107 | 32468 | 42.2871 | -2.5396 | 2021-08-04 04:21:25 | La Rioja, Spain | ||
3683750 | 3683750 | 2021-08-02 | Spain | La Rioja | 36270 | 793 | 3107 | 32370 | 42.2871 | -2.5396 | 2021-08-03 04:21:39 | La Rioja, Spain | ||
3015649 | 3015649 | 2021-08-01 | Spain | La Rioja | 35801 | 785 | 3107 | 31909 | 42.2871 | -2.5396 | 2021-08-02 04:21:36 | La Rioja, Spain | ||
3904272 | 3904272 | 2021-07-31 | Spain | La Rioja | 35801 | 785 | 3107 | 31909 | 42.2871 | -2.5396 | 2021-08-01 04:21:50 | La Rioja, Spain | ||
3296477 | 3296477 | 2021-07-30 | Spain | La Rioja | 35801 | 785 | 3107 | 31909 | 42.2871 | -2.5396 | 2021-07-31 04:21:35 | La Rioja, Spain | ||
3385688 | 3385688 | 2021-07-29 | Spain | La Rioja | 35614 | 782 | 3107 | 31725 | 42.2871 | -2.5396 | 2021-07-30 04:21:34 | La Rioja, Spain | ||
408593 | 408593 | 2021-07-28 | Spain | La Rioja | 35426 | 782 | 3107 | 31537 | 42.2871 | -2.5396 | 2021-07-29 04:21:33 | La Rioja, Spain | ||
1306454 | 1306454 | 2021-07-27 | Spain | La Rioja | 35185 | 782 | 3107 | 31296 | 42.2871 | -2.5396 | 2021-07-28 04:21:39 | La Rioja, Spain | ||
3218597 | 3218597 | 2021-07-26 | Spain | La Rioja | 35008 | 782 | 3107 | 31119 | 42.2871 | -2.5396 | 2021-07-27 04:21:18 | La Rioja, Spain | ||
1378806 | 1378806 | 2021-07-25 | Spain | La Rioja | 34545 | 779 | 3107 | 30659 | 42.2871 | -2.5396 | 2021-07-26 04:21:28 | La Rioja, Spain | ||
1330546 | 1330546 | 2021-07-24 | Spain | La Rioja | 34545 | 779 | 3107 | 30659 | 42.2871 | -2.5396 | 2021-07-25 04:22:12 | La Rioja, Spain | ||
3137850 | 3137850 | 2021-07-23 | Spain | La Rioja | 34545 | 779 | 3107 | 30659 | 42.2871 | -2.5396 | 2021-07-24 00:21:36 | La Rioja, Spain | ||
3476610 | 3476610 | 2021-07-22 | Spain | La Rioja | 34241 | 778 | 3107 | 30356 | 42.2871 | -2.5396 | 2021-07-23 04:21:29 | La Rioja, Spain | ||
3331829 | 3331829 | 2021-07-21 | Spain | La Rioja | 34067 | 778 | 3107 | 30182 | 42.2871 | -2.5396 | 2021-07-22 04:21:19 | La Rioja, Spain | ||
2371810 | 2371810 | 2021-07-20 | Spain | La Rioja | 33890 | 778 | 3107 | 30005 | 42.2871 | -2.5396 | 2021-07-21 04:21:40 | La Rioja, Spain | ||
483889 | 483889 | 2021-07-19 | Spain | La Rioja | 33722 | 778 | 3107 | 29837 | 42.2871 | -2.5396 | 2021-07-20 04:21:48 | La Rioja, Spain | ||
2674112 | 2674112 | 2021-07-18 | Spain | La Rioja | 33166 | 778 | 3107 | 29281 | 42.2871 | -2.5396 | 2021-07-19 04:21:24 | La Rioja, Spain | ||
3706424 | 3706424 | 2021-07-17 | Spain | La Rioja | 33166 | 778 | 3107 | 29281 | 42.2871 | -2.5396 | 2021-07-18 04:22:07 | La Rioja, Spain | ||
2947655 | 2947655 | 2021-07-16 | Spain | La Rioja | 33166 | 778 | 3107 | 29281 | 42.2871 | -2.5396 | 2021-07-17 04:22:22 | La Rioja, Spain | ||
296311 | 296311 | 2021-07-15 | Spain | La Rioja | 33077 | 778 | 3107 | 29192 | 42.2871 | -2.5396 | 2021-07-16 04:21:22 | La Rioja, Spain | ||
3632256 | 3632256 | 2021-07-14 | Spain | La Rioja | 33031 | 778 | 3107 | 29146 | 42.2871 | -2.5396 | 2021-07-15 04:21:48 | La Rioja, Spain | ||
579131 | 579131 | 2021-07-13 | Spain | La Rioja | 32928 | 778 | 3107 | 29043 | 42.2871 | -2.5396 | 2021-07-14 04:21:35 | La Rioja, Spain | ||
3741380 | 3741380 | 2021-07-12 | Spain | La Rioja | 32787 | 778 | 3107 | 28902 | 42.2871 | -2.5396 | 2021-07-13 04:21:18 | La Rioja, Spain | ||
3659893 | 3659893 | 2021-07-11 | Spain | La Rioja | 32539 | 778 | 3107 | 28654 | 42.2871 | -2.5396 | 2021-07-12 04:21:34 | La Rioja, Spain | ||
626177 | 626177 | 2021-07-10 | Spain | La Rioja | 32539 | 778 | 3107 | 28654 | 42.2871 | -2.5396 | 2021-07-11 04:21:43 | La Rioja, Spain | ||
829896 | 829896 | 2021-07-09 | Spain | La Rioja | 32539 | 778 | 3107 | 28654 | 42.2871 | -2.5396 | 2021-07-10 04:21:25 | La Rioja, Spain | ||
778660 | 778660 | 2021-07-08 | Spain | La Rioja | 32462 | 778 | 3107 | 28577 | 42.2871 | -2.5396 | 2021-07-09 04:21:21 | La Rioja, Spain | ||
1440882 | 1440882 | 2021-07-07 | Spain | La Rioja | 32378 | 778 | 3107 | 28493 | 42.2871 | -2.5396 | 2021-07-08 04:21:26 | La Rioja, Spain | ||
2693987 | 2693987 | 2021-07-06 | Spain | La Rioja | 32310 | 778 | 3107 | 28425 | 42.2871 | -2.5396 | 2021-07-07 04:21:20 | La Rioja, Spain | ||
1932736 | 1932736 | 2021-07-05 | Spain | La Rioja | 32254 | 778 | 3107 | 28369 | 42.2871 | -2.5396 | 2021-07-06 04:21:32 | La Rioja, Spain | ||
1165467 | 1165467 | 2021-07-04 | Spain | La Rioja | 32073 | 778 | 3107 | 28188 | 42.2871 | -2.5396 | 2021-07-05 04:21:28 | La Rioja, Spain | ||
1495901 | 1495901 | 2021-07-03 | Spain | La Rioja | 32073 | 778 | 3107 | 28188 | 42.2871 | -2.5396 | 2021-07-04 04:21:38 | La Rioja, Spain | ||
2072216 | 2072216 | 2021-07-02 | Spain | La Rioja | 32073 | 778 | 3107 | 28188 | 42.2871 | -2.5396 | 2021-07-03 04:21:37 | La Rioja, Spain | ||
2765232 | 2765232 | 2021-07-01 | Spain | La Rioja | 32027 | 778 | 3107 | 28142 | 42.2871 | -2.5396 | 2021-07-02 04:21:47 | La Rioja, Spain | ||
1893440 | 1893440 | 2021-06-30 | Spain | La Rioja | 31987 | 778 | 3107 | 28102 | 42.2871 | -2.5396 | 2021-07-01 04:21:19 | La Rioja, Spain | ||
400563 | 400563 | 2021-06-29 | Spain | La Rioja | 31955 | 778 | 3107 | 28070 | 42.2871 | -2.5396 | 2021-06-30 04:21:41 | La Rioja, Spain | ||
3125806 | 3125806 | 2021-06-28 | Spain | La Rioja | 31920 | 778 | 3107 | 28035 | 42.2871 | -2.5396 | 2021-06-29 04:21:28 | La Rioja, Spain | ||
2590301 | 2590301 | 2021-06-27 | Spain | La Rioja | 31850 | 778 | 3107 | 27965 | 42.2871 | -2.5396 | 2021-06-28 04:21:29 | La Rioja, Spain | ||
3958805 | 3958805 | 2021-06-26 | Spain | La Rioja | 31850 | 778 | 3107 | 27965 | 42.2871 | -2.5396 | 2021-06-27 04:21:39 | La Rioja, Spain | ||
1712624 | 1712624 | 2021-06-25 | Spain | La Rioja | 31850 | 778 | 3107 | 27965 | 42.2871 | -2.5396 | 2021-06-26 04:21:43 | La Rioja, Spain | ||
2295749 | 2295749 | 2021-06-24 | Spain | La Rioja | 31810 | 777 | 3107 | 27926 | 42.2871 | -2.5396 | 2021-06-25 04:21:33 | La Rioja, Spain | ||
2423189 | 2423189 | 2021-06-23 | Spain | La Rioja | 31778 | 776 | 3107 | 27895 | 42.2871 | -2.5396 | 2021-06-24 04:21:55 | La Rioja, Spain | ||
563266 | 563266 | 2021-06-22 | Spain | La Rioja | 31752 | 775 | 3107 | 27870 | 42.2871 | -2.5396 | 2021-06-23 04:21:46 | La Rioja, Spain | ||
3358968 | 3358968 | 2021-06-21 | Spain | La Rioja | 31735 | 775 | 3107 | 27853 | 42.2871 | -2.5396 | 2021-06-22 04:21:34 | La Rioja, Spain | ||
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 |
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]);