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 combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, longitude, last_update (date)
day (date) >30 ✖
- 2020-05-14 1
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- …
province_or_state 1
- La Rioja 960
country_or_region 1
- Spain · 960 ✖
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 | |||
8625 | 8625 | 2020-10-25 | Spain | La Rioja | 11300 | 442 | 3107 | 7751 | 42.2871 | -2.5396 | 2020-10-26 04:25:02 | 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 | ||
16654 | 16654 | 2021-09-18 | Spain | La Rioja | 39329 | 822 | 0 | 42.2871 | -2.5396 | 2021-09-19 04:21:34 | 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 | ||
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 | |||
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 | ||
44008 | 44008 | 2021-11-02 | Spain | La Rioja | 39703 | 823 | 0 | 42.2871 | -2.5396 | 2021-11-03 06:22:09 | 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 | ||
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 | ||
61966 | 61966 | 2020-07-23 | Spain | La Rioja | 4165 | 366 | 3107 | 692 | 42.2871 | -2.5396 | 2020-07-24 05:30:40 | 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 | |||
75384 | 75384 | 2020-12-03 | Spain | La Rioja | 16838 | 560 | 3107 | 13171 | 42.2871 | -2.5396 | 2020-12-04 05:27:27 | La Rioja, Spain | ||
79381 | 79381 | 2020-10-14 | Spain | La Rioja | 9851 | 435 | 3107 | 6309 | 42.2871 | -2.5396 | 2020-10-15 04:24:28 | 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 | ||
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 | |||
98310 | 98310 | 2020-08-04 | Spain | La Rioja | 4213 | 366 | 3107 | 740 | 42.2871 | -2.5396 | 2020-08-05 04:34:43 | 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 | |||
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 | ||
115053 | 115053 | 2022-09-06 | Spain | La Rioja | 108404 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-07 04:20:59 | La Rioja, Spain | |||
121903 | 121903 | 2020-07-19 | Spain | La Rioja | 4111 | 366 | 3107 | 638 | 42.2871 | -2.5396 | 2020-07-20 05:34:40 | La Rioja, Spain | ||
122999 | 122999 | 2020-11-18 | Spain | La Rioja | 15509 | 521 | 3107 | 11881 | 42.2871 | -2.5396 | 2020-11-19 05:25:23 | 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 | |||
146264 | 146264 | 2020-08-15 | Spain | La Rioja | 4430 | 366 | 3107 | 957 | 42.2871 | -2.5396 | 2020-08-16 04:27:42 | 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 | |||
154278 | 154278 | 2021-01-08 | Spain | La Rioja | 19326 | 594 | 3107 | 15625 | 42.2871 | -2.5396 | 2021-01-09 05:22:18 | 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 | |||
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 | ||
177221 | 177221 | 2020-07-27 | Spain | La Rioja | 4185 | 366 | 3107 | 712 | 42.2871 | -2.5396 | 2020-07-28 04:58:43 | 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 | |||
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 | ||
186371 | 186371 | 2022-02-13 | Spain | La Rioja | 86509 | 899 | 0 | 42.2871 | -2.5396 | 2022-02-14 04:20:51 | La Rioja, Spain | |||
190364 | 190364 | 2021-01-11 | Spain | La Rioja | 19866 | 596 | 3107 | 16163 | 42.2871 | -2.5396 | 2021-01-12 05:22:15 | La Rioja, Spain | ||
194359 | 194359 | 2020-08-31 | Spain | La Rioja | 5726 | 370 | 3107 | 2249 | 42.2871 | -2.5396 | 2020-09-01 04:28:31 | 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 | |||
202551 | 202551 | 2020-12-25 | Spain | La Rioja | 17908 | 581 | 3107 | 14220 | 42.2871 | -2.5396 | 2020-12-26 05:22:28 | La Rioja, Spain | ||
206546 | 206546 | 2020-08-19 | Spain | La Rioja | 4730 | 367 | 3107 | 1256 | 42.2871 | -2.5396 | 2020-08-20 04:27:43 | La Rioja, Spain | ||
210534 | 210534 | 2020-10-29 | Spain | La Rioja | 12324 | 458 | 3107 | 8759 | 42.2871 | -2.5396 | 2020-10-30 04:24:49 | La Rioja, Spain | ||
217188 | 217188 | 2020-06-08 | Spain | La Rioja | 4062 | 362 | 3107 | 593 | 42.2871 | -2.5396 | 2020-06-09 03:33:03 | 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 | |||
237536 | 237536 | 2021-01-18 | Spain | La Rioja | 21706 | 611 | 3107 | 17988 | 42.2871 | -2.5396 | 2021-01-19 05:22:15 | 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 | ||
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 | |||
268313 | 268313 | 2020-05-21 | Spain | La Rioja | 4033 | 354 | 0 | 3679 | 42.2871 | -2.5396 | 2020-05-22 02:36:51 | La Rioja, Spain | ||
272449 | 272449 | 2020-11-10 | Spain | La Rioja | 14277 | 492 | 3107 | 10678 | 42.2871 | -2.5396 | 2020-11-11 05:25:30 | 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 | |||
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 | ||
287187 | 287187 | 2020-06-15 | Spain | La Rioja | 4069 | 362 | 3107 | 600 | 42.2871 | -2.5396 | 2020-06-16 04:33:09 | 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 | |||
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 | ||
303059 | 303059 | 2020-07-01 | Spain | La Rioja | 4077 | 366 | 3107 | 604 | 42.2871 | -2.5396 | 2020-07-02 04:33:46 | 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 | |||
326998 | 326998 | 2020-07-20 | Spain | La Rioja | 4122 | 366 | 3107 | 649 | 42.2871 | -2.5396 | 2020-07-21 04:38:46 | 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 | |||
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 | ||
336237 | 336237 | 2022-03-18 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-19 04:20:47 | 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 | ||
344567 | 344567 | 2020-09-14 | Spain | La Rioja | 6907 | 384 | 3107 | 3416 | 42.2871 | -2.5396 | 2020-09-15 03:22:50 | 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 | |||
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 | ||
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 | |||
367407 | 367407 | 2020-07-16 | Spain | La Rioja | 4108 | 366 | 3107 | 635 | 42.2871 | -2.5396 | 2020-07-17 04:34:50 | La Rioja, Spain | ||
371375 | 371375 | 2020-08-08 | Spain | La Rioja | 4233 | 366 | 3107 | 760 | 42.2871 | -2.5396 | 2020-08-09 04:34:54 | 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 | |||
376476 | 376476 | 2020-11-06 | Spain | La Rioja | 13817 | 482 | 3107 | 10228 | 42.2871 | -2.5396 | 2020-11-07 05:24:52 | 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 | ||
384527 | 384527 | 2022-09-23 | Spain | La Rioja | 108657 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-24 04:21:40 | 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 | ||
392530 | 392530 | 2020-11-27 | Spain | La Rioja | 16398 | 543 | 3107 | 12748 | 42.2871 | -2.5396 | 2020-11-28 05:25:50 | 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 | |||
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 | ||
404594 | 404594 | 2021-12-07 | Spain | La Rioja | 41313 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-08 04:22:46 | 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 | ||
415351 | 415351 | 2020-07-05 | Spain | La Rioja | 4078 | 366 | 3107 | 605 | 42.2871 | -2.5396 | 2020-07-06 04:33:57 | 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 |
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]);