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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3503642 | 3503642 | 2021-01-17 | Spain | Asturias | 29913 | 1396 | 1063 | 27454 | 43.3614 | -5.8593 | 2021-01-18 05:22:34 | Asturias, Spain | ||
3101725 | 3101725 | 2021-01-16 | Spain | Asturias | 29913 | 1396 | 1063 | 27454 | 43.3614 | -5.8593 | 2021-01-17 05:22:17 | Asturias, Spain | ||
3515687 | 3515687 | 2021-01-15 | Spain | Asturias | 29913 | 1396 | 1063 | 27454 | 43.3614 | -5.8593 | 2021-01-16 05:22:40 | Asturias, Spain | ||
3879860 | 3879860 | 2021-01-14 | Spain | Asturias | 29597 | 1392 | 1063 | 27142 | 43.3614 | -5.8593 | 2021-01-15 05:22:24 | Asturias, Spain | ||
3308487 | 3308487 | 2021-01-13 | Spain | Asturias | 29318 | 1389 | 1063 | 26866 | 43.3614 | -5.8593 | 2021-01-14 05:22:32 | Asturias, Spain | ||
774632 | 774632 | 2021-01-12 | Spain | Asturias | 28996 | 1387 | 1063 | 26546 | 43.3614 | -5.8593 | 2021-01-13 05:22:15 | Asturias, Spain | ||
190353 | 190353 | 2021-01-11 | Spain | Asturias | 28737 | 1385 | 1063 | 26289 | 43.3614 | -5.8593 | 2021-01-12 05:22:15 | Asturias, Spain | ||
2626156 | 2626156 | 2021-01-10 | Spain | Asturias | 28196 | 1376 | 1063 | 25757 | 43.3614 | -5.8593 | 2021-01-11 05:21:50 | Asturias, Spain | ||
3900244 | 3900244 | 2021-01-09 | Spain | Asturias | 28196 | 1376 | 1063 | 25757 | 43.3614 | -5.8593 | 2021-01-10 05:22:12 | Asturias, Spain | ||
154267 | 154267 | 2021-01-08 | Spain | Asturias | 28196 | 1376 | 1063 | 25757 | 43.3614 | -5.8593 | 2021-01-09 05:22:18 | Asturias, Spain | ||
2541691 | 2541691 | 2021-01-07 | Spain | Asturias | 28045 | 1374 | 1063 | 25608 | 43.3614 | -5.8593 | 2021-01-08 05:22:42 | Asturias, Spain | ||
2865000 | 2865000 | 2021-01-06 | Spain | Asturias | 27689 | 1366 | 1063 | 25260 | 43.3614 | -5.8593 | 2021-01-07 05:22:03 | Asturias, Spain | ||
3034587 | 3034587 | 2021-01-05 | Spain | Asturias | 27689 | 1366 | 1063 | 25260 | 43.3614 | -5.8593 | 2021-01-06 05:22:16 | Asturias, Spain | ||
1062132 | 1062132 | 2021-01-04 | Spain | Asturias | 27559 | 1364 | 1063 | 25132 | 43.3614 | -5.8593 | 2021-01-05 05:21:49 | Asturias, Spain | ||
3230735 | 3230735 | 2021-01-03 | Spain | Asturias | 27171 | 1343 | 1063 | 24765 | 43.3614 | -5.8593 | 2021-01-04 05:22:02 | Asturias, Spain | ||
2227804 | 2227804 | 2021-01-02 | Spain | Asturias | 27171 | 1343 | 1063 | 24765 | 43.3614 | -5.8593 | 2021-01-03 05:22:52 | Asturias, Spain | ||
1137168 | 1137168 | 2021-01-01 | Spain | Asturias | 27171 | 1343 | 1063 | 24765 | 43.3614 | -5.8593 | 2021-01-02 05:22:33 | Asturias, Spain | ||
3695774 | 3695774 | 2020-12-31 | Spain | Asturias | 27171 | 1343 | 1063 | 24765 | 43.3614 | -5.8593 | 2021-01-01 05:23:07 | Asturias, Spain | ||
1010589 | 1010589 | 2020-12-30 | Spain | Asturias | 27044 | 1341 | 1063 | 24640 | 43.3614 | -5.8593 | 2020-12-31 05:22:49 | Asturias, Spain | ||
766604 | 766604 | 2020-12-29 | Spain | Asturias | 26912 | 1339 | 1063 | 24510 | 43.3614 | -5.8593 | 2020-12-30 05:22:34 | Asturias, Spain | ||
3761868 | 3761868 | 2020-12-28 | Spain | Asturias | 26838 | 1334 | 1063 | 24441 | 43.3614 | -5.8593 | 2020-12-29 05:22:37 | Asturias, Spain | ||
3778188 | 3778188 | 2020-12-27 | Spain | Asturias | 26565 | 1313 | 1063 | 24189 | 43.3614 | -5.8593 | 2020-12-28 05:22:06 | Asturias, Spain | ||
2223793 | 2223793 | 2020-12-26 | Spain | Asturias | 26565 | 1313 | 1063 | 24189 | 43.3614 | -5.8593 | 2020-12-27 05:22:55 | Asturias, Spain | ||
202540 | 202540 | 2020-12-25 | Spain | Asturias | 26565 | 1313 | 1063 | 24189 | 43.3614 | -5.8593 | 2020-12-26 05:22:28 | Asturias, Spain | ||
3691763 | 3691763 | 2020-12-24 | Spain | Asturias | 26565 | 1313 | 1063 | 24189 | 43.3614 | -5.8593 | 2020-12-25 05:22:48 | Asturias, Spain | ||
2407115 | 2407115 | 2020-12-23 | Spain | Asturias | 26469 | 1310 | 1063 | 24096 | 43.3614 | -5.8593 | 2020-12-24 05:23:04 | Asturias, Spain | ||
3770161 | 3770161 | 2020-12-22 | Spain | Asturias | 26370 | 1302 | 1063 | 24005 | 43.3614 | -5.8593 | 2020-12-23 05:22:03 | Asturias, Spain | ||
927977 | 927977 | 2020-12-21 | Spain | Asturias | 26297 | 1297 | 1063 | 23937 | 43.3614 | -5.8593 | 2020-12-22 05:22:33 | Asturias, Spain | ||
2119998 | 2119998 | 2020-12-20 | Spain | Asturias | 26046 | 1276 | 1063 | 23707 | 43.3614 | -5.8593 | 2020-12-21 05:27:58 | Asturias, Spain | ||
2931505 | 2931505 | 2020-12-19 | Spain | Asturias | 26046 | 1276 | 1063 | 23707 | 43.3614 | -5.8593 | 2020-12-20 05:27:32 | Asturias, Spain | ||
1901451 | 1901451 | 2020-12-18 | Spain | Asturias | 26046 | 1276 | 1063 | 23707 | 43.3614 | -5.8593 | 2020-12-19 05:27:52 | Asturias, Spain | ||
2128277 | 2128277 | 2020-12-17 | Spain | Asturias | 25955 | 1268 | 1063 | 23624 | 43.3614 | -5.8593 | 2020-12-18 05:28:18 | Asturias, Spain | ||
3149877 | 3149877 | 2020-12-16 | Spain | Asturias | 25864 | 1258 | 1063 | 23543 | 43.3614 | -5.8593 | 2020-12-17 05:28:12 | Asturias, Spain | ||
1034658 | 1034658 | 2020-12-15 | Spain | Asturias | 25746 | 1251 | 1063 | 23432 | 43.3614 | -5.8593 | 2020-12-16 05:28:04 | Asturias, Spain | ||
1751552 | 1751552 | 2020-12-14 | Spain | Asturias | 25616 | 1238 | 1063 | 23315 | 43.3614 | -5.8593 | 2020-12-15 05:26:38 | Asturias, Spain | ||
3848072 | 3848072 | 2020-12-13 | Spain | Asturias | 25159 | 1211 | 1063 | 22885 | 43.3614 | -5.8593 | 2020-12-14 05:26:27 | Asturias, Spain | ||
845854 | 845854 | 2020-12-12 | Spain | Asturias | 25159 | 1211 | 1063 | 22885 | 43.3614 | -5.8593 | 2020-12-13 05:27:20 | Asturias, Spain | ||
860961 | 860961 | 2020-12-11 | Spain | Asturias | 25159 | 1211 | 1063 | 22885 | 43.3614 | -5.8593 | 2020-12-12 05:26:19 | Asturias, Spain | ||
1600503 | 1600503 | 2020-12-10 | Spain | Asturias | 25025 | 1197 | 1063 | 22765 | 43.3614 | -5.8593 | 2020-12-11 05:26:59 | Asturias, Spain | ||
2975512 | 2975512 | 2020-12-09 | Spain | Asturias | 24903 | 1179 | 1063 | 22661 | 43.3614 | -5.8593 | 2020-12-10 05:26:19 | Asturias, Spain | ||
1819072 | 1819072 | 2020-12-08 | Spain | Asturias | 24692 | 1153 | 1063 | 22476 | 43.3614 | -5.8593 | 2020-12-09 05:28:01 | Asturias, Spain | ||
2347708 | 2347708 | 2020-12-07 | Spain | Asturias | 24692 | 1153 | 1063 | 22476 | 43.3614 | -5.8593 | 2020-12-08 05:27:42 | Asturias, Spain | ||
1006578 | 1006578 | 2020-12-06 | Spain | Asturias | 24175 | 1073 | 1063 | 22039 | 43.3614 | -5.8593 | 2020-12-07 05:26:14 | Asturias, Spain | ||
1632587 | 1632587 | 2020-12-05 | Spain | Asturias | 24175 | 1073 | 1063 | 22039 | 43.3614 | -5.8593 | 2020-12-06 05:26:18 | Asturias, Spain | ||
3860115 | 3860115 | 2020-12-04 | Spain | Asturias | 24175 | 1073 | 1063 | 22039 | 43.3614 | -5.8593 | 2020-12-05 05:27:36 | Asturias, Spain | ||
75373 | 75373 | 2020-12-03 | Spain | Asturias | 23946 | 1054 | 1063 | 21829 | 43.3614 | -5.8593 | 2020-12-04 05:27:27 | Asturias, Spain | ||
738585 | 738585 | 2020-12-02 | Spain | Asturias | 23722 | 1036 | 1063 | 21623 | 43.3614 | -5.8593 | 2020-12-03 05:28:22 | Asturias, Spain | ||
2537679 | 2537679 | 2020-12-01 | Spain | Asturias | 23485 | 1021 | 1063 | 21401 | 43.3614 | -5.8593 | 2020-12-02 05:27:41 | Asturias, Spain | ||
1584448 | 1584448 | 2020-11-30 | Spain | Asturias | 23337 | 1004 | 1063 | 21270 | 43.3614 | -5.8593 | 2020-12-01 05:26:18 | Asturias, Spain | ||
3566851 | 3566851 | 2020-11-29 | Spain | Asturias | 22746 | 954 | 1063 | 20729 | 43.3614 | -5.8593 | 2020-11-30 05:26:13 | Asturias, Spain | ||
2935516 | 2935516 | 2020-11-28 | Spain | Asturias | 22746 | 954 | 1063 | 20729 | 43.3614 | -5.8593 | 2020-11-29 05:25:55 | Asturias, Spain | ||
392519 | 392519 | 2020-11-27 | Spain | Asturias | 22746 | 954 | 1063 | 20729 | 43.3614 | -5.8593 | 2020-11-28 05:25:50 | Asturias, Spain | ||
923966 | 923966 | 2020-11-26 | Spain | Asturias | 22460 | 929 | 1063 | 20468 | 43.3614 | -5.8593 | 2020-11-27 05:26:53 | Asturias, Spain | ||
1972871 | 1972871 | 2020-11-25 | Spain | Asturias | 22200 | 904 | 1063 | 20233 | 43.3614 | -5.8593 | 2020-11-26 05:27:44 | Asturias, Spain | ||
1350602 | 1350602 | 2020-11-24 | Spain | Asturias | 21801 | 883 | 1063 | 19855 | 43.3614 | -5.8593 | 2020-11-25 05:27:20 | Asturias, Spain | ||
678596 | 678596 | 2020-11-23 | Spain | Asturias | 21570 | 857 | 1063 | 19650 | 43.3614 | -5.8593 | 2020-11-24 05:27:31 | Asturias, Spain | ||
3190272 | 3190272 | 2020-11-22 | Spain | Asturias | 20637 | 800 | 1063 | 18774 | 43.3614 | -5.8593 | 2020-11-23 05:25:26 | Asturias, Spain | ||
3836766 | 3836766 | 2020-11-21 | Spain | Asturias | 20637 | 800 | 1063 | 18774 | 43.3614 | -5.8593 | 2020-11-22 05:25:45 | Asturias, Spain | ||
2701794 | 2701794 | 2020-11-20 | Spain | Asturias | 20637 | 800 | 1063 | 18774 | 43.3614 | -5.8593 | 2020-11-21 05:25:51 | Asturias, Spain | ||
821854 | 821854 | 2020-11-19 | Spain | Asturias | 20321 | 775 | 1063 | 18483 | 43.3614 | -5.8593 | 2020-11-20 05:26:28 | Asturias, Spain | ||
122988 | 122988 | 2020-11-18 | Spain | Asturias | 19869 | 755 | 1063 | 18051 | 43.3614 | -5.8593 | 2020-11-19 05:25:23 | Asturias, Spain | ||
3338876 | 3338876 | 2020-11-17 | Spain | Asturias | 19414 | 739 | 1063 | 17612 | 43.3614 | -5.8593 | 2020-11-18 05:40:31 | Asturias, Spain | ||
3169921 | 3169921 | 2020-11-16 | Spain | Asturias | 19136 | 732 | 1063 | 17341 | 43.3614 | -5.8593 | 2020-11-17 05:25:54 | Asturias, Spain | ||
2880489 | 2880489 | 2020-11-15 | Spain | Asturias | 17669 | 661 | 1063 | 15945 | 43.3614 | -5.8593 | 2020-11-16 05:25:57 | Asturias, Spain | ||
2915467 | 2915467 | 2020-11-14 | Spain | Asturias | 17669 | 661 | 1063 | 15945 | 43.3614 | -5.8593 | 2020-11-15 05:26:53 | Asturias, Spain | ||
2785289 | 2785289 | 2020-11-13 | Spain | Asturias | 17669 | 661 | 1063 | 15945 | 43.3614 | -5.8593 | 2020-11-14 05:25:37 | Asturias, Spain | ||
865054 | 865054 | 2020-11-12 | Spain | Asturias | 17003 | 649 | 1063 | 15291 | 43.3614 | -5.8593 | 2020-11-13 05:25:30 | Asturias, Spain | ||
3441098 | 3441098 | 2020-11-11 | Spain | Asturias | 16396 | 622 | 1063 | 14711 | 43.3614 | -5.8593 | 2020-11-12 05:25:55 | Asturias, Spain | ||
272438 | 272438 | 2020-11-10 | Spain | Asturias | 15583 | 582 | 1063 | 13938 | 43.3614 | -5.8593 | 2020-11-11 05:25:30 | Asturias, Spain | ||
1988915 | 1988915 | 2020-11-09 | Spain | Asturias | 15583 | 582 | 1063 | 13938 | 43.3614 | -5.8593 | 2020-11-10 05:40:07 | Asturias, Spain | ||
1728767 | 1728767 | 2020-11-08 | Spain | Asturias | 14257 | 534 | 1063 | 12660 | 43.3614 | -5.8593 | 2020-11-09 05:25:45 | Asturias, Spain | ||
1544227 | 1544227 | 2020-11-07 | Spain | Asturias | 14257 | 534 | 1063 | 12660 | 43.3614 | -5.8593 | 2020-11-08 05:24:56 | Asturias, Spain | ||
376465 | 376465 | 2020-11-06 | Spain | Asturias | 14257 | 534 | 1063 | 12660 | 43.3614 | -5.8593 | 2020-11-07 05:24:52 | Asturias, Spain | ||
892403 | 892403 | 2020-11-05 | Spain | Asturias | 13676 | 520 | 1063 | 12093 | 43.3614 | -5.8593 | 2020-11-06 05:24:55 | Asturias, Spain | ||
2919465 | 2919465 | 2020-11-04 | Spain | Asturias | 13246 | 497 | 1063 | 11686 | 43.3614 | -5.8593 | 2020-11-05 06:05:03 | Asturias, Spain | ||
2498302 | 2498302 | 2020-11-03 | Spain | Asturias | 12953 | 484 | 1063 | 11406 | 43.3614 | -5.8593 | 2020-11-04 05:25:09 | Asturias, Spain | ||
3304477 | 3304477 | 2020-11-02 | Spain | Asturias | 12703 | 466 | 1063 | 11174 | 43.3614 | -5.8593 | 2020-11-03 06:00:16 | Asturias, Spain | ||
3409726 | 3409726 | 2020-11-01 | Spain | Asturias | 11795 | 437 | 1063 | 10295 | 43.3614 | -5.8593 | 2020-11-02 05:25:04 | Asturias, Spain | ||
2080215 | 2080215 | 2020-10-31 | Spain | Asturias | 11795 | 437 | 1063 | 10295 | 43.3614 | -5.8593 | 2020-11-01 04:36:19 | Asturias, Spain | ||
2243668 | 2243668 | 2020-10-30 | Spain | Asturias | 11795 | 437 | 1063 | 10295 | 43.3614 | -5.8593 | 2020-10-31 04:24:44 | Asturias, Spain | ||
210523 | 210523 | 2020-10-29 | Spain | Asturias | 11346 | 427 | 1063 | 9856 | 43.3614 | -5.8593 | 2020-10-30 04:24:49 | Asturias, Spain | ||
754585 | 754585 | 2020-10-28 | Spain | Asturias | 10944 | 419 | 1063 | 9462 | 43.3614 | -5.8593 | 2020-10-29 04:24:49 | Asturias, Spain | ||
1452869 | 1452869 | 2020-10-27 | Spain | Asturias | 10608 | 414 | 1063 | 9131 | 43.3614 | -5.8593 | 2020-10-28 04:24:39 | Asturias, Spain | ||
3480593 | 3480593 | 2020-10-26 | Spain | Asturias | 10367 | 409 | 1063 | 8895 | 43.3614 | -5.8593 | 2020-10-27 04:24:45 | Asturias, Spain | ||
8614 | 8614 | 2020-10-25 | Spain | Asturias | 9432 | 391 | 1063 | 7978 | 43.3614 | -5.8593 | 2020-10-26 04:25:02 | Asturias, Spain | ||
3651851 | 3651851 | 2020-10-24 | Spain | Asturias | 9432 | 391 | 1063 | 7978 | 43.3614 | -5.8593 | 2020-10-25 04:24:36 | Asturias, Spain | ||
1054106 | 1054106 | 2020-10-23 | Spain | Asturias | 9432 | 391 | 1063 | 7978 | 43.3614 | -5.8593 | 2020-10-24 04:24:46 | Asturias, Spain | ||
1177776 | 1177776 | 2020-10-22 | Spain | Asturias | 9109 | 383 | 1063 | 7663 | 43.3614 | -5.8593 | 2020-10-23 04:24:46 | Asturias, Spain | ||
2191881 | 2191881 | 2020-10-21 | Spain | Asturias | 8842 | 377 | 1063 | 7402 | 43.3614 | -5.8593 | 2020-10-22 04:24:27 | Asturias, Spain | ||
3990892 | 3990892 | 2020-10-20 | Spain | Asturias | 8654 | 371 | 1063 | 7220 | 43.3614 | -5.8593 | 2020-10-21 04:24:14 | Asturias, Spain | ||
1794912 | 1794912 | 2020-10-19 | Spain | Asturias | 8443 | 371 | 1063 | 7009 | 43.3614 | -5.8593 | 2020-10-20 04:24:22 | Asturias, Spain | ||
762596 | 762596 | 2020-10-18 | Spain | Asturias | 7701 | 365 | 1063 | 6273 | 43.3614 | -5.8593 | 2020-10-19 04:24:16 | Asturias, Spain | ||
1026634 | 1026634 | 2020-10-17 | Spain | Asturias | 7701 | 365 | 1063 | 6273 | 43.3614 | -5.8593 | 2020-10-18 04:24:25 | Asturias, Spain | ||
2857129 | 2857129 | 2020-10-16 | Spain | Asturias | 7701 | 365 | 1063 | 6273 | 43.3614 | -5.8593 | 2020-10-17 04:24:12 | Asturias, Spain | ||
786659 | 786659 | 2020-10-15 | Spain | Asturias | 7502 | 364 | 1063 | 6075 | 43.3614 | -5.8593 | 2020-10-16 04:24:01 | Asturias, Spain | ||
79370 | 79370 | 2020-10-14 | Spain | Asturias | 7312 | 361 | 1063 | 5888 | 43.3614 | -5.8593 | 2020-10-15 04:24:28 | Asturias, Spain | ||
3782185 | 3782185 | 2020-10-13 | Spain | Asturias | 7125 | 357 | 1063 | 5705 | 43.3614 | -5.8593 | 2020-10-14 04:24:05 | Asturias, Spain | ||
2291725 | 2291725 | 2020-10-12 | Spain | Asturias | 6986 | 356 | 1063 | 5567 | 43.3614 | -5.8593 | 2020-10-13 04:24:02 | Asturias, Spain | ||
3786177 | 3786177 | 2020-10-11 | Spain | Asturias | 6353 | 354 | 1063 | 4936 | 43.3614 | -5.8593 | 2020-10-12 04:23:45 | Asturias, Spain | ||
2602315 | 2602315 | 2020-10-10 | Spain | Asturias | 6353 | 354 | 1063 | 4936 | 43.3614 | -5.8593 | 2020-10-11 04:23:46 | 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]);