daily_reports (view)
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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Spain | La Rioja | 40917 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-03 04:23:05 | La Rioja, Spain | |||
2021-10-28 | Spain | La Rioja | 39648 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-29 04:22:03 | La Rioja, Spain | |||
2021-09-18 | Spain | La Rioja | 39329 | 822 | 0 | 42.2871 | -2.5396 | 2021-09-19 04:21:34 | La Rioja, Spain | |||
2022-03-20 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-21 04:20:50 | La Rioja, Spain | |||
2021-11-11 | Spain | La Rioja | 39913 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-12 04:22:01 | La Rioja, Spain | |||
2021-08-25 | Spain | La Rioja | 38628 | 815 | 0 | 42.2871 | -2.5396 | 2021-08-26 04:21:28 | La Rioja, Spain | |||
2021-11-02 | Spain | La Rioja | 39703 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-03 06:22:09 | La Rioja, Spain | |||
2022-11-12 | Spain | La Rioja | 109930 | 956 | 0 | 42.2871 | -2.5396 | 2022-11-13 04:21:14 | La Rioja, Spain | |||
2021-09-01 | Spain | La Rioja | 38984 | 818 | 0 | 42.2871 | -2.5396 | 2021-09-02 04:21:15 | La Rioja, Spain | |||
2022-02-07 | Spain | La Rioja | 85127 | 894 | 0 | 42.2871 | -2.5396 | 2022-02-08 04:21:15 | La Rioja, Spain | |||
2021-11-09 | Spain | La Rioja | 39821 | 824 | 0 | 42.2871 | -2.5396 | 2021-11-10 04:21:38 | La Rioja, Spain | |||
2022-07-23 | Spain | La Rioja | 107173 | 932 | 0 | 42.2871 | -2.5396 | 2022-07-24 04:20:47 | La Rioja, Spain | |||
2022-01-14 | Spain | La Rioja | 69257 | 861 | 0 | 42.2871 | -2.5396 | 2022-01-15 04:21:07 | La Rioja, Spain | |||
2021-08-15 | Spain | La Rioja | 37650 | 808 | 0 | 42.2871 | -2.5396 | 2021-08-16 04:21:31 | La Rioja, Spain | |||
2022-09-06 | Spain | La Rioja | 108404 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-07 04:20:59 | La Rioja, Spain | |||
2022-01-09 | Spain | La Rioja | 59541 | 853 | 0 | 42.2871 | -2.5396 | 2022-01-10 04:22:07 | La Rioja, Spain | |||
2022-10-04 | Spain | La Rioja | 108962 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-05 04:23:06 | La Rioja, Spain | |||
2021-12-04 | Spain | La Rioja | 41008 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-05 04:22:25 | La Rioja, Spain | |||
2022-07-09 | Spain | La Rioja | 105199 | 928 | 0 | 42.2871 | -2.5396 | 2022-07-10 04:20:54 | La Rioja, Spain | |||
2021-11-29 | Spain | La Rioja | 40655 | 829 | 0 | 42.2871 | -2.5396 | 2021-11-30 04:22:53 | La Rioja, Spain | |||
2022-03-29 | Spain | La Rioja | 92896 | 911 | 0 | 42.2871 | -2.5396 | 2022-03-30 04:20:45 | La Rioja, Spain | |||
2021-11-19 | Spain | La Rioja | 40214 | 827 | 0 | 42.2871 | -2.5396 | 2021-11-20 04:22:17 | La Rioja, Spain | |||
2022-06-21 | Spain | La Rioja | 101672 | 926 | 0 | 42.2871 | -2.5396 | 2022-06-22 04:20:54 | La Rioja, Spain | |||
2021-09-02 | Spain | La Rioja | 39032 | 818 | 0 | 42.2871 | -2.5396 | 2021-09-03 04:21:20 | La Rioja, Spain | |||
2022-02-13 | Spain | La Rioja | 86509 | 899 | 0 | 42.2871 | -2.5396 | 2022-02-14 04:20:51 | La Rioja, Spain | |||
2022-10-19 | Spain | La Rioja | 109389 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-20 04:22:59 | La Rioja, Spain | |||
2022-12-26 | Spain | La Rioja | 110731 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-27 04:21:07 | La Rioja, Spain | |||
2022-05-09 | Spain | La Rioja | 97607 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-10 04:20:50 | La Rioja, Spain | |||
2022-05-31 | Spain | La Rioja | 99738 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-01 04:20:55 | La Rioja, Spain | |||
2022-02-11 | Spain | La Rioja | 86509 | 899 | 0 | 42.2871 | -2.5396 | 2022-02-12 04:21:06 | La Rioja, Spain | |||
2021-08-17 | Spain | La Rioja | 37953 | 809 | 0 | 42.2871 | -2.5396 | 2021-08-18 04:21:35 | La Rioja, Spain | |||
2021-09-04 | Spain | La Rioja | 39065 | 819 | 0 | 42.2871 | -2.5396 | 2021-09-05 04:21:33 | La Rioja, Spain | |||
2022-09-08 | Spain | La Rioja | 108404 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-09 04:21:11 | La Rioja, Spain | |||
2022-12-10 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-11 04:20:50 | La Rioja, Spain | |||
2022-03-15 | Spain | La Rioja | 90785 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-16 04:20:50 | La Rioja, Spain | |||
2021-11-03 | Spain | La Rioja | 39717 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-04 04:22:20 | La Rioja, Spain | |||
2021-10-31 | Spain | La Rioja | 39663 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-01 04:22:01 | La Rioja, Spain | |||
2022-11-15 | Spain | La Rioja | 109930 | 956 | 0 | 42.2871 | -2.5396 | 2022-11-16 04:21:09 | La Rioja, Spain | |||
2022-04-16 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-17 04:20:59 | La Rioja, Spain | |||
2022-12-13 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-14 04:21:04 | La Rioja, Spain | |||
2022-11-13 | Spain | La Rioja | 109930 | 956 | 0 | 42.2871 | -2.5396 | 2022-11-14 04:21:09 | La Rioja, Spain | |||
2022-02-12 | Spain | La Rioja | 86509 | 899 | 0 | 42.2871 | -2.5396 | 2022-02-13 04:21:00 | La Rioja, Spain | |||
2022-10-30 | Spain | La Rioja | 109722 | 953 | 0 | 42.2871 | -2.5396 | 2022-10-31 04:21:36 | La Rioja, Spain | |||
2022-12-27 | Spain | La Rioja | 110731 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-28 04:21:04 | La Rioja, Spain | |||
2022-03-18 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-19 04:20:47 | La Rioja, Spain | |||
2022-12-14 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-15 04:20:58 | La Rioja, Spain | |||
2022-03-11 | Spain | La Rioja | 90461 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-12 04:20:50 | La Rioja, Spain | |||
2022-05-07 | Spain | La Rioja | 97089 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-08 04:20:49 | La Rioja, Spain | |||
2022-09-13 | Spain | La Rioja | 108500 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-14 04:20:44 | La Rioja, Spain | |||
2022-09-23 | Spain | La Rioja | 108657 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-24 04:21:40 | La Rioja, Spain | |||
2022-10-07 | Spain | La Rioja | 109124 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-08 04:22:56 | La Rioja, Spain | |||
2021-12-07 | Spain | La Rioja | 41313 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-08 04:22:46 | La Rioja, Spain | |||
2022-09-18 | Spain | La Rioja | 108571 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-19 04:21:49 | La Rioja, Spain | |||
2021-10-10 | Spain | La Rioja | 39526 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-11 04:21:31 | La Rioja, Spain | |||
2022-11-03 | Spain | La Rioja | 109722 | 953 | 0 | 42.2871 | -2.5396 | 2022-11-04 04:22:11 | La Rioja, Spain | |||
2021-10-20 | Spain | La Rioja | 39596 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-21 04:21:18 | La Rioja, Spain | |||
2021-11-17 | Spain | La Rioja | 40121 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-18 04:21:33 | La Rioja, Spain | |||
2022-12-21 | Spain | La Rioja | 110574 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-22 04:20:56 | La Rioja, Spain | |||
2022-02-02 | Spain | La Rioja | 83523 | 887 | 0 | 42.2871 | -2.5396 | 2022-02-03 04:21:21 | La Rioja, Spain | |||
2022-05-02 | Spain | La Rioja | 95906 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-03 04:21:00 | La Rioja, Spain | |||
2021-10-07 | Spain | La Rioja | 39520 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-08 04:21:25 | La Rioja, Spain | |||
2022-06-26 | Spain | La Rioja | 102297 | 925 | 0 | 42.2871 | -2.5396 | 2022-06-27 04:21:00 | La Rioja, Spain | |||
2022-11-08 | Spain | La Rioja | 109820 | 954 | 0 | 42.2871 | -2.5396 | 2022-11-09 04:21:22 | La Rioja, Spain | |||
2022-11-25 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-26 04:21:11 | La Rioja, Spain | |||
2021-10-14 | Spain | La Rioja | 39557 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-15 04:21:26 | La Rioja, Spain | |||
2021-11-06 | Spain | La Rioja | 39768 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-07 04:21:53 | La Rioja, Spain | |||
2022-04-02 | Spain | La Rioja | 93187 | 911 | 0 | 42.2871 | -2.5396 | 2022-04-03 04:20:48 | La Rioja, Spain | |||
2022-12-17 | Spain | La Rioja | 110574 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-18 04:21:03 | La Rioja, Spain | |||
2021-08-14 | Spain | La Rioja | 37650 | 808 | 0 | 42.2871 | -2.5396 | 2021-08-15 04:21:41 | La Rioja, Spain | |||
2021-08-19 | Spain | La Rioja | 38173 | 812 | 0 | 42.2871 | -2.5396 | 2021-08-20 04:21:33 | La Rioja, Spain | |||
2022-10-15 | Spain | La Rioja | 109389 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-16 04:22:39 | La Rioja, Spain | |||
2021-10-27 | Spain | La Rioja | 39638 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-28 04:22:08 | La Rioja, Spain | |||
2022-10-26 | Spain | La Rioja | 109591 | 951 | 0 | 42.2871 | -2.5396 | 2022-10-27 04:22:01 | La Rioja, Spain | |||
2022-12-15 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-16 04:21:01 | La Rioja, Spain | |||
2021-12-08 | Spain | La Rioja | 41313 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-09 04:22:49 | La Rioja, Spain | |||
2022-01-16 | Spain | La Rioja | 69257 | 861 | 0 | 42.2871 | -2.5396 | 2022-01-17 04:21:08 | La Rioja, Spain | |||
2022-06-16 | Spain | La Rioja | 100877 | 926 | 0 | 42.2871 | -2.5396 | 2022-06-17 04:20:56 | La Rioja, Spain | |||
2021-10-29 | Spain | La Rioja | 39663 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-30 04:22:03 | La Rioja, Spain | |||
2022-02-25 | Spain | La Rioja | 88769 | 906 | 0 | 42.2871 | -2.5396 | 2022-02-26 04:21:12 | La Rioja, Spain | |||
2021-08-08 | Spain | La Rioja | 36880 | 798 | 0 | 42.2871 | -2.5396 | 2021-08-09 04:21:24 | La Rioja, Spain | |||
2022-07-01 | Spain | La Rioja | 103512 | 927 | 0 | 42.2871 | -2.5396 | 2022-07-02 04:21:16 | La Rioja, Spain | |||
2021-10-19 | Spain | La Rioja | 39588 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-20 04:21:00 | La Rioja, Spain | |||
2021-09-23 | Spain | La Rioja | 39398 | 822 | 0 | 42.2871 | -2.5396 | 2021-09-24 04:21:44 | La Rioja, Spain | |||
2022-11-05 | Spain | La Rioja | 109820 | 954 | 0 | 42.2871 | -2.5396 | 2022-11-06 04:21:24 | La Rioja, Spain | |||
2022-05-22 | Spain | La Rioja | 99119 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-26 04:20:50 | La Rioja, Spain | |||
2022-07-12 | Spain | La Rioja | 105832 | 928 | 0 | 42.2871 | -2.5396 | 2022-07-13 04:20:58 | La Rioja, Spain | |||
2021-10-13 | Spain | La Rioja | 39552 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-14 04:21:29 | La Rioja, Spain | |||
2021-09-07 | Spain | La Rioja | 39159 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-08 04:21:31 | La Rioja, Spain | |||
2021-08-09 | Spain | La Rioja | 37184 | 802 | 0 | 42.2871 | -2.5396 | 2021-08-10 04:21:27 | La Rioja, Spain | |||
2021-10-22 | Spain | La Rioja | 39608 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-23 04:21:32 | La Rioja, Spain | |||
2022-05-13 | Spain | La Rioja | 98175 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-14 04:20:48 | La Rioja, Spain | |||
2022-07-21 | Spain | La Rioja | 106790 | 931 | 0 | 42.2871 | -2.5396 | 2022-07-22 04:21:15 | La Rioja, Spain | |||
2022-07-30 | Spain | La Rioja | 107574 | 937 | 0 | 42.2871 | -2.5396 | 2022-07-31 04:21:02 | La Rioja, Spain | |||
2021-10-24 | Spain | La Rioja | 39608 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-25 04:22:31 | La Rioja, Spain | |||
2021-11-13 | Spain | La Rioja | 39946 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-14 04:21:31 | La Rioja, Spain | |||
2022-12-23 | Spain | La Rioja | 110731 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-24 04:21:02 | La Rioja, Spain | |||
2022-03-17 | Spain | La Rioja | 90785 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-18 04:20:55 | La Rioja, Spain | |||
2021-11-04 | Spain | La Rioja | 39737 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-05 04:21:54 | La Rioja, Spain | |||
2021-09-29 | Spain | La Rioja | 39450 | 823 | 0 | 42.2871 | -2.5396 | 2021-09-30 04:21:20 | La Rioja, Spain | |||
2022-11-01 | Spain | La Rioja | 109722 | 953 | 0 | 42.2871 | -2.5396 | 2022-11-02 04:22:09 | La Rioja, Spain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;