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 = "Asturias" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 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
- …
province_or_state 1
- Asturias · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
619 | 619 | 2021-12-02 | Spain | Asturias | 74591 | 2094 | 0 | 43.3614 | -5.8593 | 2021-12-03 04:23:05 | Asturias, Spain | |||
4635 | 4635 | 2021-10-28 | Spain | Asturias | 71376 | 2077 | 0 | 43.3614 | -5.8593 | 2021-10-29 04:22:03 | Asturias, Spain | |||
16643 | 16643 | 2021-09-18 | Spain | Asturias | 70721 | 2063 | 0 | 43.3614 | -5.8593 | 2021-09-19 04:21:34 | Asturias, Spain | |||
24690 | 24690 | 2022-03-20 | Spain | Asturias | 199853 | 2568 | 0 | 43.3614 | -5.8593 | 2022-03-21 04:20:50 | Asturias, Spain | |||
28705 | 28705 | 2021-11-11 | Spain | Asturias | 71841 | 2080 | 0 | 43.3614 | -5.8593 | 2021-11-12 04:22:01 | Asturias, Spain | |||
32704 | 32704 | 2021-08-25 | Spain | Asturias | 69968 | 2049 | 0 | 43.3614 | -5.8593 | 2021-08-26 04:21:28 | Asturias, Spain | |||
43997 | 43997 | 2021-11-02 | Spain | Asturias | 71530 | 2078 | 0 | 43.3614 | -5.8593 | 2021-11-03 06:22:09 | Asturias, Spain | |||
63354 | 63354 | 2022-11-12 | Spain | Asturias | 261520 | 3281 | 0 | 43.3614 | -5.8593 | 2022-11-13 04:21:14 | Asturias, Spain | |||
67349 | 67349 | 2021-09-01 | Spain | Asturias | 70334 | 2053 | 0 | 43.3614 | -5.8593 | 2021-09-02 04:21:15 | Asturias, Spain | |||
71380 | 71380 | 2022-02-07 | Spain | Asturias | 182327 | 2349 | 0 | 43.3614 | -5.8593 | 2022-02-08 04:21:15 | Asturias, Spain | |||
87414 | 87414 | 2021-11-09 | Spain | Asturias | 71700 | 2079 | 0 | 43.3614 | -5.8593 | 2021-11-10 04:21:38 | Asturias, Spain | |||
91432 | 91432 | 2022-07-23 | Spain | Asturias | 251812 | 2993 | 0 | 43.3614 | -5.8593 | 2022-07-24 04:20:47 | Asturias, Spain | |||
99615 | 99615 | 2022-01-14 | Spain | Asturias | 134043 | 2208 | 0 | 43.3614 | -5.8593 | 2022-01-15 04:21:07 | Asturias, Spain | |||
103614 | 103614 | 2021-08-15 | Spain | Asturias | 68966 | 2024 | 0 | 43.3614 | -5.8593 | 2021-08-16 04:21:31 | Asturias, Spain | |||
115042 | 115042 | 2022-09-06 | Spain | Asturias | 256077 | 3106 | 0 | 43.3614 | -5.8593 | 2022-09-07 04:20:59 | Asturias, Spain | |||
127022 | 127022 | 2022-01-09 | Spain | Asturias | 113025 | 2185 | 0 | 43.3614 | -5.8593 | 2022-01-10 04:22:07 | Asturias, Spain | |||
131042 | 131042 | 2022-10-04 | Spain | Asturias | 257831 | 3119 | 0 | 43.3614 | -5.8593 | 2022-10-05 04:23:06 | Asturias, Spain | |||
138260 | 138260 | 2021-12-04 | Spain | Asturias | 74920 | 2094 | 0 | 43.3614 | -5.8593 | 2021-12-05 04:22:25 | Asturias, Spain | |||
142278 | 142278 | 2022-07-09 | Spain | Asturias | 245524 | 2913 | 0 | 43.3614 | -5.8593 | 2022-07-10 04:20:54 | Asturias, Spain | |||
150273 | 150273 | 2021-11-29 | Spain | Asturias | 73759 | 2091 | 0 | 43.3614 | -5.8593 | 2021-11-30 04:22:53 | Asturias, Spain | |||
158302 | 158302 | 2022-03-29 | Spain | Asturias | 205070 | 2590 | 0 | 43.3614 | -5.8593 | 2022-03-30 04:20:45 | Asturias, Spain | |||
162317 | 162317 | 2021-11-19 | Spain | Asturias | 72249 | 2086 | 0 | 43.3614 | -5.8593 | 2021-11-20 04:22:17 | Asturias, Spain | |||
166335 | 166335 | 2022-06-21 | Spain | Asturias | 236588 | 2867 | 0 | 43.3614 | -5.8593 | 2022-06-22 04:20:54 | Asturias, Spain | |||
178314 | 178314 | 2021-09-02 | Spain | Asturias | 70385 | 2054 | 0 | 43.3614 | -5.8593 | 2021-09-03 04:21:20 | Asturias, Spain | |||
186360 | 186360 | 2022-02-13 | Spain | Asturias | 186129 | 2364 | 0 | 43.3614 | -5.8593 | 2022-02-14 04:20:51 | Asturias, Spain | |||
198551 | 198551 | 2022-10-19 | Spain | Asturias | 258983 | 3221 | 0 | 43.3614 | -5.8593 | 2022-10-20 04:22:59 | Asturias, Spain | |||
218272 | 218272 | 2022-12-26 | Spain | Asturias | 263985 | 3379 | 0 | 43.3614 | -5.8593 | 2022-12-27 04:21:07 | Asturias, Spain | |||
222285 | 222285 | 2022-05-09 | Spain | Asturias | 226247 | 2763 | 0 | 43.3614 | -5.8593 | 2022-05-10 04:20:50 | Asturias, Spain | |||
229517 | 229517 | 2022-05-31 | Spain | Asturias | 231744 | 2826 | 0 | 43.3614 | -5.8593 | 2022-06-01 04:20:55 | Asturias, Spain | |||
233532 | 233532 | 2022-02-11 | Spain | Asturias | 186129 | 2364 | 0 | 43.3614 | -5.8593 | 2022-02-12 04:21:06 | Asturias, Spain | |||
245557 | 245557 | 2021-08-17 | Spain | Asturias | 69313 | 2037 | 0 | 43.3614 | -5.8593 | 2021-08-18 04:21:35 | Asturias, Spain | |||
249571 | 249571 | 2021-09-04 | Spain | Asturias | 70444 | 2055 | 0 | 43.3614 | -5.8593 | 2021-09-05 04:21:33 | Asturias, Spain | |||
253604 | 253604 | 2022-09-08 | Spain | Asturias | 256077 | 3106 | 0 | 43.3614 | -5.8593 | 2022-09-09 04:21:11 | Asturias, Spain | |||
257622 | 257622 | 2022-12-10 | Spain | Asturias | 263228 | 3360 | 0 | 43.3614 | -5.8593 | 2022-12-11 04:20:50 | Asturias, Spain | |||
261822 | 261822 | 2022-03-15 | Spain | Asturias | 198338 | 2561 | 0 | 43.3614 | -5.8593 | 2022-03-16 04:20:50 | Asturias, Spain | |||
276472 | 276472 | 2021-11-03 | Spain | Asturias | 71561 | 2078 | 0 | 43.3614 | -5.8593 | 2021-11-04 04:22:20 | Asturias, Spain | |||
288285 | 288285 | 2021-10-31 | Spain | Asturias | 71416 | 2077 | 0 | 43.3614 | -5.8593 | 2021-11-01 04:22:01 | Asturias, Spain | |||
292305 | 292305 | 2022-11-15 | Spain | Asturias | 261520 | 3281 | 0 | 43.3614 | -5.8593 | 2022-11-16 04:21:09 | Asturias, Spain | |||
304158 | 304158 | 2022-04-16 | Spain | Asturias | 210439 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-17 04:20:59 | Asturias, Spain | |||
308177 | 308177 | 2022-12-13 | Spain | Asturias | 263228 | 3360 | 0 | 43.3614 | -5.8593 | 2022-12-14 04:21:04 | Asturias, Spain | |||
312193 | 312193 | 2022-11-13 | Spain | Asturias | 261520 | 3281 | 0 | 43.3614 | -5.8593 | 2022-11-14 04:21:09 | Asturias, Spain | |||
316206 | 316206 | 2022-02-12 | Spain | Asturias | 186129 | 2364 | 0 | 43.3614 | -5.8593 | 2022-02-13 04:21:00 | Asturias, Spain | |||
320225 | 320225 | 2022-10-30 | Spain | Asturias | 260463 | 3244 | 0 | 43.3614 | -5.8593 | 2022-10-31 04:21:36 | Asturias, Spain | |||
328199 | 328199 | 2022-12-27 | Spain | Asturias | 263985 | 3379 | 0 | 43.3614 | -5.8593 | 2022-12-28 04:21:04 | Asturias, Spain | |||
336226 | 336226 | 2022-03-18 | Spain | Asturias | 199853 | 2568 | 0 | 43.3614 | -5.8593 | 2022-03-19 04:20:47 | Asturias, Spain | |||
348589 | 348589 | 2022-12-14 | Spain | Asturias | 263228 | 3360 | 0 | 43.3614 | -5.8593 | 2022-12-15 04:20:58 | Asturias, Spain | |||
356616 | 356616 | 2022-03-11 | Spain | Asturias | 197400 | 2519 | 0 | 43.3614 | -5.8593 | 2022-03-12 04:20:50 | Asturias, Spain | |||
360632 | 360632 | 2022-05-07 | Spain | Asturias | 224409 | 2738 | 0 | 43.3614 | -5.8593 | 2022-05-08 04:20:49 | Asturias, Spain | |||
372489 | 372489 | 2022-09-13 | Spain | Asturias | 256464 | 3108 | 0 | 43.3614 | -5.8593 | 2022-09-14 04:20:44 | Asturias, Spain | |||
384516 | 384516 | 2022-09-23 | Spain | Asturias | 257046 | 3116 | 0 | 43.3614 | -5.8593 | 2022-09-24 04:21:40 | Asturias, Spain | |||
396557 | 396557 | 2022-10-07 | Spain | Asturias | 258261 | 3211 | 0 | 43.3614 | -5.8593 | 2022-10-08 04:22:56 | Asturias, Spain | |||
404583 | 404583 | 2021-12-07 | Spain | Asturias | 76340 | 2094 | 0 | 43.3614 | -5.8593 | 2021-12-08 04:22:46 | Asturias, Spain | |||
419628 | 419628 | 2022-09-18 | Spain | Asturias | 256632 | 3111 | 0 | 43.3614 | -5.8593 | 2022-09-19 04:21:49 | Asturias, Spain | |||
423640 | 423640 | 2021-10-10 | Spain | Asturias | 70950 | 2068 | 0 | 43.3614 | -5.8593 | 2021-10-11 04:21:31 | Asturias, Spain | |||
431650 | 431650 | 2022-11-03 | Spain | Asturias | 260463 | 3244 | 0 | 43.3614 | -5.8593 | 2022-11-04 04:22:11 | Asturias, Spain | |||
443644 | 443644 | 2021-10-20 | Spain | Asturias | 71145 | 2072 | 0 | 43.3614 | -5.8593 | 2021-10-21 04:21:18 | Asturias, Spain | |||
447660 | 447660 | 2021-11-17 | Spain | Asturias | 72087 | 2084 | 0 | 43.3614 | -5.8593 | 2021-11-18 04:21:33 | Asturias, Spain | |||
451680 | 451680 | 2022-12-21 | Spain | Asturias | 263589 | 3378 | 0 | 43.3614 | -5.8593 | 2022-12-22 04:20:56 | Asturias, Spain | |||
459669 | 459669 | 2022-02-02 | Spain | Asturias | 176969 | 2319 | 0 | 43.3614 | -5.8593 | 2022-02-03 04:21:21 | Asturias, Spain | |||
463686 | 463686 | 2022-05-02 | Spain | Asturias | 220365 | 2710 | 0 | 43.3614 | -5.8593 | 2022-05-03 04:21:00 | Asturias, Spain | |||
467701 | 467701 | 2021-10-07 | Spain | Asturias | 70937 | 2067 | 0 | 43.3614 | -5.8593 | 2021-10-08 04:21:25 | Asturias, Spain | |||
475733 | 475733 | 2022-06-26 | Spain | Asturias | 237793 | 2873 | 0 | 43.3614 | -5.8593 | 2022-06-27 04:21:00 | Asturias, Spain | |||
479883 | 479883 | 2022-11-08 | Spain | Asturias | 261004 | 3260 | 0 | 43.3614 | -5.8593 | 2022-11-09 04:21:22 | Asturias, Spain | |||
487913 | 487913 | 2022-11-25 | Spain | Asturias | 262523 | 3308 | 0 | 43.3614 | -5.8593 | 2022-11-26 04:21:11 | Asturias, Spain | |||
491925 | 491925 | 2021-10-14 | Spain | Asturias | 71048 | 2070 | 0 | 43.3614 | -5.8593 | 2021-10-15 04:21:26 | Asturias, Spain | |||
495941 | 495941 | 2021-11-06 | Spain | Asturias | 71626 | 2078 | 0 | 43.3614 | -5.8593 | 2021-11-07 04:21:53 | Asturias, Spain | |||
499958 | 499958 | 2022-04-02 | Spain | Asturias | 206817 | 2598 | 0 | 43.3614 | -5.8593 | 2022-04-03 04:20:48 | Asturias, Spain | |||
503977 | 503977 | 2022-12-17 | Spain | Asturias | 263589 | 3378 | 0 | 43.3614 | -5.8593 | 2022-12-18 04:21:03 | Asturias, Spain | |||
507972 | 507972 | 2021-08-14 | Spain | Asturias | 68966 | 2024 | 0 | 43.3614 | -5.8593 | 2021-08-15 04:21:41 | Asturias, Spain | |||
511986 | 511986 | 2021-08-19 | Spain | Asturias | 69503 | 2042 | 0 | 43.3614 | -5.8593 | 2021-08-20 04:21:33 | Asturias, Spain | |||
516021 | 516021 | 2022-10-15 | Spain | Asturias | 258983 | 3221 | 0 | 43.3614 | -5.8593 | 2022-10-16 04:22:39 | Asturias, Spain | |||
535025 | 535025 | 2021-10-27 | Spain | Asturias | 71347 | 2077 | 0 | 43.3614 | -5.8593 | 2021-10-28 04:22:08 | Asturias, Spain | |||
539045 | 539045 | 2022-10-26 | Spain | Asturias | 259770 | 3238 | 0 | 43.3614 | -5.8593 | 2022-10-27 04:22:01 | Asturias, Spain | |||
543061 | 543061 | 2022-12-15 | Spain | Asturias | 263228 | 3360 | 0 | 43.3614 | -5.8593 | 2022-12-16 04:21:01 | Asturias, Spain | |||
551063 | 551063 | 2021-12-08 | Spain | Asturias | 76340 | 2094 | 0 | 43.3614 | -5.8593 | 2021-12-09 04:22:49 | Asturias, Spain | |||
555079 | 555079 | 2022-01-16 | Spain | Asturias | 134043 | 2208 | 0 | 43.3614 | -5.8593 | 2022-01-17 04:21:08 | Asturias, Spain | |||
559097 | 559097 | 2022-06-16 | Spain | Asturias | 234843 | 2859 | 0 | 43.3614 | -5.8593 | 2022-06-17 04:20:56 | Asturias, Spain | |||
567393 | 567393 | 2021-10-29 | Spain | Asturias | 71416 | 2077 | 0 | 43.3614 | -5.8593 | 2021-10-30 04:22:03 | Asturias, Spain | |||
575122 | 575122 | 2022-02-25 | Spain | Asturias | 193358 | 2476 | 0 | 43.3614 | -5.8593 | 2022-02-26 04:21:12 | Asturias, Spain | |||
589916 | 589916 | 2021-08-08 | Spain | Asturias | 67771 | 2015 | 0 | 43.3614 | -5.8593 | 2021-08-09 04:21:24 | Asturias, Spain | |||
593949 | 593949 | 2022-07-01 | Spain | Asturias | 241064 | 2887 | 0 | 43.3614 | -5.8593 | 2022-07-02 04:21:16 | Asturias, Spain | |||
597963 | 597963 | 2021-10-19 | Spain | Asturias | 71130 | 2071 | 0 | 43.3614 | -5.8593 | 2021-10-20 04:21:00 | Asturias, Spain | |||
601979 | 601979 | 2021-09-23 | Spain | Asturias | 70784 | 2066 | 0 | 43.3614 | -5.8593 | 2021-09-24 04:21:44 | Asturias, Spain | |||
618155 | 618155 | 2022-11-05 | Spain | Asturias | 261004 | 3260 | 0 | 43.3614 | -5.8593 | 2022-11-06 04:21:24 | Asturias, Spain | |||
622169 | 622169 | 2022-05-22 | Spain | Asturias | 230377 | 2808 | 0 | 43.3614 | -5.8593 | 2022-05-26 04:20:50 | Asturias, Spain | |||
630199 | 630199 | 2022-07-12 | Spain | Asturias | 247653 | 2926 | 0 | 43.3614 | -5.8593 | 2022-07-13 04:20:58 | Asturias, Spain | |||
634213 | 634213 | 2021-10-13 | Spain | Asturias | 71041 | 2070 | 0 | 43.3614 | -5.8593 | 2021-10-14 04:21:29 | Asturias, Spain | |||
642226 | 642226 | 2021-09-07 | Spain | Asturias | 70549 | 2057 | 0 | 43.3614 | -5.8593 | 2021-09-08 04:21:31 | Asturias, Spain | |||
650254 | 650254 | 2021-08-09 | Spain | Asturias | 68324 | 2020 | 0 | 43.3614 | -5.8593 | 2021-08-10 04:21:27 | Asturias, Spain | |||
654285 | 654285 | 2021-10-22 | Spain | Asturias | 71203 | 2074 | 0 | 43.3614 | -5.8593 | 2021-10-23 04:21:32 | Asturias, Spain | |||
658604 | 658604 | 2022-05-13 | Spain | Asturias | 227953 | 2781 | 0 | 43.3614 | -5.8593 | 2022-05-14 04:20:48 | Asturias, Spain | |||
670590 | 670590 | 2022-07-21 | Spain | Asturias | 250842 | 2972 | 0 | 43.3614 | -5.8593 | 2022-07-22 04:21:15 | Asturias, Spain | |||
674606 | 674606 | 2022-07-30 | Spain | Asturias | 253099 | 3021 | 0 | 43.3614 | -5.8593 | 2022-07-31 04:21:02 | Asturias, Spain | |||
682630 | 682630 | 2021-10-24 | Spain | Asturias | 71203 | 2074 | 0 | 43.3614 | -5.8593 | 2021-10-25 04:22:31 | Asturias, Spain | |||
686646 | 686646 | 2021-11-13 | Spain | Asturias | 71880 | 2081 | 0 | 43.3614 | -5.8593 | 2021-11-14 04:21:31 | Asturias, Spain | |||
690666 | 690666 | 2022-12-23 | Spain | Asturias | 263985 | 3379 | 0 | 43.3614 | -5.8593 | 2022-12-24 04:21:02 | Asturias, Spain | |||
694679 | 694679 | 2022-03-17 | Spain | Asturias | 198338 | 2561 | 0 | 43.3614 | -5.8593 | 2022-03-18 04:20:55 | Asturias, Spain | |||
698694 | 698694 | 2021-11-04 | Spain | Asturias | 71585 | 2078 | 0 | 43.3614 | -5.8593 | 2021-11-05 04:21:54 | Asturias, Spain | |||
706724 | 706724 | 2021-09-29 | Spain | Asturias | 70874 | 2066 | 0 | 43.3614 | -5.8593 | 2021-09-30 04:21:20 | Asturias, Spain | |||
710743 | 710743 | 2022-11-01 | Spain | Asturias | 260463 | 3244 | 0 | 43.3614 | -5.8593 | 2022-11-02 04:22:09 | Asturias, 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]);