johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where combined_key = "La Rioja, Spain" and country_or_region = "Spain" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, longitude, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
630 | 630 | 2021-12-02 | Spain | La Rioja | 40917 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-03 04:23:05 | La Rioja, Spain | |||
4646 | 4646 | 2021-10-28 | Spain | La Rioja | 39648 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-29 04:22:03 | La Rioja, Spain | |||
16654 | 16654 | 2021-09-18 | Spain | La Rioja | 39329 | 822 | 0 | 42.2871 | -2.5396 | 2021-09-19 04:21:34 | La Rioja, Spain | |||
24701 | 24701 | 2022-03-20 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-21 04:20:50 | La Rioja, Spain | |||
28716 | 28716 | 2021-11-11 | Spain | La Rioja | 39913 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-12 04:22:01 | 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 | |||
44008 | 44008 | 2021-11-02 | Spain | La Rioja | 39703 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-03 06:22:09 | La Rioja, Spain | |||
63365 | 63365 | 2022-11-12 | Spain | La Rioja | 109930 | 956 | 0 | 42.2871 | -2.5396 | 2022-11-13 04:21:14 | 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 | |||
71391 | 71391 | 2022-02-07 | Spain | La Rioja | 85127 | 894 | 0 | 42.2871 | -2.5396 | 2022-02-08 04:21:15 | La Rioja, Spain | |||
87425 | 87425 | 2021-11-09 | Spain | La Rioja | 39821 | 824 | 0 | 42.2871 | -2.5396 | 2021-11-10 04:21:38 | La Rioja, Spain | |||
91443 | 91443 | 2022-07-23 | Spain | La Rioja | 107173 | 932 | 0 | 42.2871 | -2.5396 | 2022-07-24 04:20:47 | La Rioja, Spain | |||
99626 | 99626 | 2022-01-14 | Spain | La Rioja | 69257 | 861 | 0 | 42.2871 | -2.5396 | 2022-01-15 04:21:07 | 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 | |||
115053 | 115053 | 2022-09-06 | Spain | La Rioja | 108404 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-07 04:20:59 | La Rioja, Spain | |||
127033 | 127033 | 2022-01-09 | Spain | La Rioja | 59541 | 853 | 0 | 42.2871 | -2.5396 | 2022-01-10 04:22:07 | La Rioja, Spain | |||
131053 | 131053 | 2022-10-04 | Spain | La Rioja | 108962 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-05 04:23:06 | La Rioja, Spain | |||
138271 | 138271 | 2021-12-04 | Spain | La Rioja | 41008 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-05 04:22:25 | La Rioja, Spain | |||
142289 | 142289 | 2022-07-09 | Spain | La Rioja | 105199 | 928 | 0 | 42.2871 | -2.5396 | 2022-07-10 04:20:54 | La Rioja, Spain | |||
150284 | 150284 | 2021-11-29 | Spain | La Rioja | 40655 | 829 | 0 | 42.2871 | -2.5396 | 2021-11-30 04:22:53 | La Rioja, Spain | |||
158313 | 158313 | 2022-03-29 | Spain | La Rioja | 92896 | 911 | 0 | 42.2871 | -2.5396 | 2022-03-30 04:20:45 | La Rioja, Spain | |||
162328 | 162328 | 2021-11-19 | Spain | La Rioja | 40214 | 827 | 0 | 42.2871 | -2.5396 | 2021-11-20 04:22:17 | La Rioja, Spain | |||
166346 | 166346 | 2022-06-21 | Spain | La Rioja | 101672 | 926 | 0 | 42.2871 | -2.5396 | 2022-06-22 04:20:54 | 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 | |||
186371 | 186371 | 2022-02-13 | Spain | La Rioja | 86509 | 899 | 0 | 42.2871 | -2.5396 | 2022-02-14 04:20:51 | La Rioja, Spain | |||
198562 | 198562 | 2022-10-19 | Spain | La Rioja | 109389 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-20 04:22:59 | La Rioja, Spain | |||
218283 | 218283 | 2022-12-26 | Spain | La Rioja | 110731 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-27 04:21:07 | La Rioja, Spain | |||
222296 | 222296 | 2022-05-09 | Spain | La Rioja | 97607 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-10 04:20:50 | La Rioja, Spain | |||
229528 | 229528 | 2022-05-31 | Spain | La Rioja | 99738 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-01 04:20:55 | La Rioja, Spain | |||
233543 | 233543 | 2022-02-11 | Spain | La Rioja | 86509 | 899 | 0 | 42.2871 | -2.5396 | 2022-02-12 04:21:06 | 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 | |||
249582 | 249582 | 2021-09-04 | Spain | La Rioja | 39065 | 819 | 0 | 42.2871 | -2.5396 | 2021-09-05 04:21:33 | La Rioja, Spain | |||
253615 | 253615 | 2022-09-08 | Spain | La Rioja | 108404 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-09 04:21:11 | La Rioja, Spain | |||
257633 | 257633 | 2022-12-10 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-11 04:20:50 | La Rioja, Spain | |||
261833 | 261833 | 2022-03-15 | Spain | La Rioja | 90785 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-16 04:20:50 | La Rioja, Spain | |||
276483 | 276483 | 2021-11-03 | Spain | La Rioja | 39717 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-04 04:22:20 | La Rioja, Spain | |||
288296 | 288296 | 2021-10-31 | Spain | La Rioja | 39663 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-01 04:22:01 | La Rioja, Spain | |||
292316 | 292316 | 2022-11-15 | Spain | La Rioja | 109930 | 956 | 0 | 42.2871 | -2.5396 | 2022-11-16 04:21:09 | La Rioja, Spain | |||
304169 | 304169 | 2022-04-16 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-17 04:20:59 | La Rioja, Spain | |||
308188 | 308188 | 2022-12-13 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-14 04:21:04 | La Rioja, Spain | |||
312204 | 312204 | 2022-11-13 | Spain | La Rioja | 109930 | 956 | 0 | 42.2871 | -2.5396 | 2022-11-14 04:21:09 | La Rioja, Spain | |||
316217 | 316217 | 2022-02-12 | Spain | La Rioja | 86509 | 899 | 0 | 42.2871 | -2.5396 | 2022-02-13 04:21:00 | La Rioja, Spain | |||
320236 | 320236 | 2022-10-30 | Spain | La Rioja | 109722 | 953 | 0 | 42.2871 | -2.5396 | 2022-10-31 04:21:36 | La Rioja, Spain | |||
328210 | 328210 | 2022-12-27 | Spain | La Rioja | 110731 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-28 04:21:04 | La Rioja, Spain | |||
336237 | 336237 | 2022-03-18 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-19 04:20:47 | La Rioja, Spain | |||
348600 | 348600 | 2022-12-14 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-15 04:20:58 | La Rioja, Spain | |||
356627 | 356627 | 2022-03-11 | Spain | La Rioja | 90461 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-12 04:20:50 | La Rioja, Spain | |||
360643 | 360643 | 2022-05-07 | Spain | La Rioja | 97089 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-08 04:20:49 | La Rioja, Spain | |||
372500 | 372500 | 2022-09-13 | Spain | La Rioja | 108500 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-14 04:20:44 | La Rioja, Spain | |||
384527 | 384527 | 2022-09-23 | Spain | La Rioja | 108657 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-24 04:21:40 | La Rioja, Spain | |||
396568 | 396568 | 2022-10-07 | Spain | La Rioja | 109124 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-08 04:22:56 | La Rioja, Spain | |||
404594 | 404594 | 2021-12-07 | Spain | La Rioja | 41313 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-08 04:22:46 | La Rioja, Spain | |||
419639 | 419639 | 2022-09-18 | Spain | La Rioja | 108571 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-19 04:21:49 | La Rioja, Spain | |||
423651 | 423651 | 2021-10-10 | Spain | La Rioja | 39526 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-11 04:21:31 | La Rioja, Spain | |||
431661 | 431661 | 2022-11-03 | Spain | La Rioja | 109722 | 953 | 0 | 42.2871 | -2.5396 | 2022-11-04 04:22:11 | La Rioja, Spain | |||
443655 | 443655 | 2021-10-20 | Spain | La Rioja | 39596 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-21 04:21:18 | La Rioja, Spain | |||
447671 | 447671 | 2021-11-17 | Spain | La Rioja | 40121 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-18 04:21:33 | La Rioja, Spain | |||
451691 | 451691 | 2022-12-21 | Spain | La Rioja | 110574 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-22 04:20:56 | La Rioja, Spain | |||
459680 | 459680 | 2022-02-02 | Spain | La Rioja | 83523 | 887 | 0 | 42.2871 | -2.5396 | 2022-02-03 04:21:21 | La Rioja, Spain | |||
463697 | 463697 | 2022-05-02 | Spain | La Rioja | 95906 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-03 04:21:00 | La Rioja, Spain | |||
467712 | 467712 | 2021-10-07 | Spain | La Rioja | 39520 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-08 04:21:25 | La Rioja, Spain | |||
475744 | 475744 | 2022-06-26 | Spain | La Rioja | 102297 | 925 | 0 | 42.2871 | -2.5396 | 2022-06-27 04:21:00 | La Rioja, Spain | |||
479894 | 479894 | 2022-11-08 | Spain | La Rioja | 109820 | 954 | 0 | 42.2871 | -2.5396 | 2022-11-09 04:21:22 | La Rioja, Spain | |||
487924 | 487924 | 2022-11-25 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-26 04:21:11 | La Rioja, Spain | |||
491936 | 491936 | 2021-10-14 | Spain | La Rioja | 39557 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-15 04:21:26 | La Rioja, Spain | |||
495952 | 495952 | 2021-11-06 | Spain | La Rioja | 39768 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-07 04:21:53 | La Rioja, Spain | |||
499969 | 499969 | 2022-04-02 | Spain | La Rioja | 93187 | 911 | 0 | 42.2871 | -2.5396 | 2022-04-03 04:20:48 | La Rioja, Spain | |||
503988 | 503988 | 2022-12-17 | Spain | La Rioja | 110574 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-18 04:21:03 | 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 | |||
511997 | 511997 | 2021-08-19 | Spain | La Rioja | 38173 | 812 | 0 | 42.2871 | -2.5396 | 2021-08-20 04:21:33 | La Rioja, Spain | |||
516032 | 516032 | 2022-10-15 | Spain | La Rioja | 109389 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-16 04:22:39 | La Rioja, Spain | |||
535036 | 535036 | 2021-10-27 | Spain | La Rioja | 39638 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-28 04:22:08 | La Rioja, Spain | |||
539056 | 539056 | 2022-10-26 | Spain | La Rioja | 109591 | 951 | 0 | 42.2871 | -2.5396 | 2022-10-27 04:22:01 | La Rioja, Spain | |||
543072 | 543072 | 2022-12-15 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-16 04:21:01 | La Rioja, Spain | |||
551074 | 551074 | 2021-12-08 | Spain | La Rioja | 41313 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-09 04:22:49 | La Rioja, Spain | |||
555090 | 555090 | 2022-01-16 | Spain | La Rioja | 69257 | 861 | 0 | 42.2871 | -2.5396 | 2022-01-17 04:21:08 | La Rioja, Spain | |||
559108 | 559108 | 2022-06-16 | Spain | La Rioja | 100877 | 926 | 0 | 42.2871 | -2.5396 | 2022-06-17 04:20:56 | La Rioja, Spain | |||
567404 | 567404 | 2021-10-29 | Spain | La Rioja | 39663 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-30 04:22:03 | La Rioja, Spain | |||
575133 | 575133 | 2022-02-25 | Spain | La Rioja | 88769 | 906 | 0 | 42.2871 | -2.5396 | 2022-02-26 04:21:12 | 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 | |||
593960 | 593960 | 2022-07-01 | Spain | La Rioja | 103512 | 927 | 0 | 42.2871 | -2.5396 | 2022-07-02 04:21:16 | La Rioja, Spain | |||
597974 | 597974 | 2021-10-19 | Spain | La Rioja | 39588 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-20 04:21:00 | La Rioja, Spain | |||
601990 | 601990 | 2021-09-23 | Spain | La Rioja | 39398 | 822 | 0 | 42.2871 | -2.5396 | 2021-09-24 04:21:44 | La Rioja, Spain | |||
618166 | 618166 | 2022-11-05 | Spain | La Rioja | 109820 | 954 | 0 | 42.2871 | -2.5396 | 2022-11-06 04:21:24 | La Rioja, Spain | |||
622180 | 622180 | 2022-05-22 | Spain | La Rioja | 99119 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-26 04:20:50 | La Rioja, Spain | |||
630210 | 630210 | 2022-07-12 | Spain | La Rioja | 105832 | 928 | 0 | 42.2871 | -2.5396 | 2022-07-13 04:20:58 | La Rioja, Spain | |||
634224 | 634224 | 2021-10-13 | Spain | La Rioja | 39552 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-14 04:21:29 | 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 | |||
650265 | 650265 | 2021-08-09 | Spain | La Rioja | 37184 | 802 | 0 | 42.2871 | -2.5396 | 2021-08-10 04:21:27 | La Rioja, Spain | |||
654296 | 654296 | 2021-10-22 | Spain | La Rioja | 39608 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-23 04:21:32 | La Rioja, Spain | |||
658615 | 658615 | 2022-05-13 | Spain | La Rioja | 98175 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-14 04:20:48 | La Rioja, Spain | |||
670601 | 670601 | 2022-07-21 | Spain | La Rioja | 106790 | 931 | 0 | 42.2871 | -2.5396 | 2022-07-22 04:21:15 | La Rioja, Spain | |||
674617 | 674617 | 2022-07-30 | Spain | La Rioja | 107574 | 937 | 0 | 42.2871 | -2.5396 | 2022-07-31 04:21:02 | La Rioja, Spain | |||
682641 | 682641 | 2021-10-24 | Spain | La Rioja | 39608 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-25 04:22:31 | La Rioja, Spain | |||
686657 | 686657 | 2021-11-13 | Spain | La Rioja | 39946 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-14 04:21:31 | La Rioja, Spain | |||
690677 | 690677 | 2022-12-23 | Spain | La Rioja | 110731 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-24 04:21:02 | La Rioja, Spain | |||
694690 | 694690 | 2022-03-17 | Spain | La Rioja | 90785 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-18 04:20:55 | La Rioja, Spain | |||
698705 | 698705 | 2021-11-04 | Spain | La Rioja | 39737 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-05 04:21:54 | La Rioja, Spain | |||
706735 | 706735 | 2021-09-29 | Spain | La Rioja | 39450 | 823 | 0 | 42.2871 | -2.5396 | 2021-09-30 04:21:20 | La Rioja, Spain | |||
710754 | 710754 | 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 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]);