johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,298 rows where country_or_region = "Spain" sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, combined_key, day (date), last_update (date)
province_or_state 20
- Andalusia 960
- Aragon 960
- Asturias 960
- Baleares 960
- C. Valenciana 960
- Canarias 960
- Cantabria 960
- Castilla - La Mancha 960
- Castilla y Leon 960
- Catalonia 960
- Ceuta 960
- Extremadura 960
- Galicia 960
- La Rioja 960
- Madrid 960
- Melilla 960
- Murcia 960
- Navarra 960
- Pais Vasco 960
- Unknown 955
country_or_region 1
- Spain · 19,298 ✖
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002977 | 4002977 | 2022-10-08 | Spain | Unknown | 0 | 0 | 0 | 2022-10-09 04:21:16 | Unknown, Spain | |||||
4002976 | 4002976 | 2022-10-08 | Spain | Pais Vasco | 775017 | 7363 | 0 | 42.9896 | -2.6189 | 2022-10-09 04:21:16 | Pais Vasco, Spain | |||
4002975 | 4002975 | 2022-10-08 | Spain | Navarra | 255640 | 1711 | 0 | 42.6954 | -1.6761 | 2022-10-09 04:21:16 | Navarra, Spain | |||
4002974 | 4002974 | 2022-10-08 | Spain | Murcia | 457150 | 2454 | 0 | 37.9922 | -1.1307 | 2022-10-09 04:21:16 | Murcia, Spain | |||
4002973 | 4002973 | 2022-10-08 | Spain | Melilla | 24817 | 167 | 0 | 35.2923 | -2.9381 | 2022-10-09 04:21:16 | Melilla, Spain | |||
4002972 | 4002972 | 2022-10-08 | Spain | Madrid | 1928312 | 19815 | 0 | 40.4168 | -3.7038 | 2022-10-09 04:21:16 | Madrid, Spain | |||
4002971 | 4002971 | 2022-10-08 | Spain | La Rioja | 109124 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-09 04:21:16 | La Rioja, Spain | |||
4002970 | 4002970 | 2022-10-08 | Spain | Galicia | 730080 | 3908 | 0 | 42.5751 | -8.1339 | 2022-10-09 04:21:16 | Galicia, Spain | |||
4002969 | 4002969 | 2022-10-08 | Spain | Extremadura | 304106 | 2639 | 0 | 39.4937 | -6.0679 | 2022-10-09 04:21:16 | Extremadura, Spain | |||
4002968 | 4002968 | 2022-10-08 | Spain | Ceuta | 24248 | 188 | 0 | 35.8894 | -5.3213 | 2022-10-09 04:21:16 | Ceuta, Spain | |||
4002967 | 4002967 | 2022-10-08 | Spain | Catalonia | 2636638 | 20539 | 0 | 41.5912 | 1.5209 | 2022-10-09 04:21:16 | Catalonia, Spain | |||
4002966 | 4002966 | 2022-10-08 | Spain | Castilla y Leon | 824461 | 9183 | 0 | 41.8357 | -4.3976 | 2022-10-09 04:21:16 | Castilla y Leon, Spain | |||
4002965 | 4002965 | 2022-10-08 | Spain | Castilla - La Mancha | 595761 | 7870 | 0 | 39.2796 | -3.0977 | 2022-10-09 04:21:16 | Castilla - La Mancha, Spain | |||
4002964 | 4002964 | 2022-10-08 | Spain | Cantabria | 158752 | 958 | 0 | 43.1828 | -3.9878 | 2022-10-09 04:21:16 | Cantabria, Spain | |||
4002963 | 4002963 | 2022-10-08 | Spain | Canarias | 445460 | 2085 | 0 | 28.2916 | -16.6291 | 2022-10-09 04:21:16 | Canarias, Spain | |||
4002962 | 4002962 | 2022-10-08 | Spain | C. Valenciana | 1555252 | 10046 | 0 | 39.484 | -0.7533 | 2022-10-09 04:21:16 | C. Valenciana, Spain | |||
4002961 | 4002961 | 2022-10-08 | Spain | Baleares | 309748 | 1561 | 0 | 39.710358 | 2.995148 | 2022-10-09 04:21:16 | Baleares, Spain | |||
4002960 | 4002960 | 2022-10-08 | Spain | Asturias | 258261 | 3211 | 0 | 43.3614 | -5.8593 | 2022-10-09 04:21:16 | Asturias, Spain | |||
4002959 | 4002959 | 2022-10-08 | Spain | Aragon | 458388 | 5239 | 0 | 41.5976 | -0.9057 | 2022-10-09 04:21:16 | Aragon, Spain | |||
4002958 | 4002958 | 2022-10-08 | Spain | Andalusia | 1590726 | 14582 | 0 | 37.5443 | -4.7278 | 2022-10-09 04:21:16 | Andalusia, Spain | |||
3998957 | 3998957 | 2021-12-30 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
3998956 | 3998956 | 2021-12-30 | Spain | Pais Vasco | 364892 | 5156 | 0 | 42.9896 | -2.6189 | 2021-12-31 04:21:50 | Pais Vasco, Spain | |||
3998955 | 3998955 | 2021-12-30 | Spain | Navarra | 124046 | 1295 | 0 | 42.6954 | -1.6761 | 2021-12-31 04:21:50 | Navarra, Spain | |||
3998954 | 3998954 | 2021-12-30 | Spain | Murcia | 178441 | 1828 | 0 | 37.9922 | -1.1307 | 2021-12-31 04:21:50 | Murcia, Spain | |||
3998953 | 3998953 | 2021-12-30 | Spain | Melilla | 12793 | 121 | 0 | 35.2923 | -2.9381 | 2021-12-31 04:21:50 | Melilla, Spain | |||
3998952 | 3998952 | 2021-12-30 | Spain | Madrid | 1114550 | 16373 | 0 | 40.4168 | -3.7038 | 2021-12-31 04:21:50 | Madrid, Spain | |||
3998951 | 3998951 | 2021-12-30 | Spain | La Rioja | 52176 | 844 | 0 | 42.2871 | -2.5396 | 2021-12-31 04:21:50 | La Rioja, Spain | |||
3998950 | 3998950 | 2021-12-30 | Spain | Galicia | 246821 | 2754 | 0 | 42.5751 | -8.1339 | 2021-12-31 04:21:50 | Galicia, Spain | |||
3998949 | 3998949 | 2021-12-30 | Spain | Extremadura | 131237 | 2013 | 0 | 39.4937 | -6.0679 | 2021-12-31 04:21:50 | Extremadura, Spain | |||
3998948 | 3998948 | 2021-12-30 | Spain | Ceuta | 9285 | 131 | 0 | 35.8894 | -5.3213 | 2021-12-31 04:21:50 | Ceuta, Spain | |||
3998947 | 3998947 | 2021-12-30 | Spain | Catalonia | 1167381 | 16124 | 0 | 41.5912 | 1.5209 | 2021-12-31 04:21:50 | Catalonia, Spain | |||
3998946 | 3998946 | 2021-12-30 | Spain | Castilla y Leon | 389041 | 7553 | 0 | 41.8357 | -4.3976 | 2021-12-31 04:21:50 | Castilla y Leon, Spain | |||
3998945 | 3998945 | 2021-12-30 | Spain | Castilla - La Mancha | 281580 | 6584 | 0 | 39.2796 | -3.0977 | 2021-12-31 04:21:50 | Castilla - La Mancha, Spain | |||
3998944 | 3998944 | 2021-12-30 | Spain | Cantabria | 59700 | 626 | 0 | 43.1828 | -3.9878 | 2021-12-31 04:21:50 | Cantabria, Spain | |||
3998943 | 3998943 | 2021-12-30 | Spain | Canarias | 149021 | 1136 | 0 | 28.2916 | -16.6291 | 2021-12-31 04:21:50 | Canarias, Spain | |||
3998942 | 3998942 | 2021-12-30 | Spain | C. Valenciana | 628453 | 8090 | 0 | 39.484 | -0.7533 | 2021-12-31 04:21:50 | C. Valenciana, Spain | |||
3998941 | 3998941 | 2021-12-30 | Spain | Baleares | 130704 | 1065 | 0 | 39.710358 | 2.995148 | 2021-12-31 04:21:50 | Baleares, Spain | |||
3998940 | 3998940 | 2021-12-30 | Spain | Asturias | 96040 | 2157 | 0 | 43.3614 | -5.8593 | 2021-12-31 04:21:50 | Asturias, Spain | |||
3998939 | 3998939 | 2021-12-30 | Spain | Aragon | 214247 | 4077 | 0 | 41.5976 | -0.9057 | 2021-12-31 04:21:50 | Aragon, Spain | |||
3998938 | 3998938 | 2021-12-30 | Spain | Andalusia | 944337 | 11478 | 0 | 37.5443 | -4.7278 | 2021-12-31 04:21:50 | Andalusia, Spain | |||
3994945 | 3994945 | 2022-09-27 | Spain | Unknown | 0 | 0 | 0 | 2022-09-28 04:23:01 | Unknown, Spain | |||||
3994944 | 3994944 | 2022-09-27 | Spain | Pais Vasco | 773140 | 7345 | 0 | 42.9896 | -2.6189 | 2022-09-28 04:23:01 | Pais Vasco, Spain | |||
3994943 | 3994943 | 2022-09-27 | Spain | Navarra | 255444 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-28 04:23:01 | Navarra, Spain | |||
3994942 | 3994942 | 2022-09-27 | Spain | Murcia | 456141 | 2449 | 0 | 37.9922 | -1.1307 | 2022-09-28 04:23:01 | Murcia, Spain | |||
3994941 | 3994941 | 2022-09-27 | Spain | Melilla | 24786 | 167 | 0 | 35.2923 | -2.9381 | 2022-09-28 04:23:01 | Melilla, Spain | |||
3994940 | 3994940 | 2022-09-27 | Spain | Madrid | 1923771 | 19715 | 0 | 40.4168 | -3.7038 | 2022-09-28 04:23:01 | Madrid, Spain | |||
3994939 | 3994939 | 2022-09-27 | Spain | La Rioja | 108712 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-28 04:23:01 | La Rioja, Spain | |||
3994938 | 3994938 | 2022-09-27 | Spain | Galicia | 728513 | 3896 | 0 | 42.5751 | -8.1339 | 2022-09-28 04:23:01 | Galicia, Spain | |||
3994937 | 3994937 | 2022-09-27 | Spain | Extremadura | 303488 | 2632 | 0 | 39.4937 | -6.0679 | 2022-09-28 04:23:01 | Extremadura, Spain | |||
3994936 | 3994936 | 2022-09-27 | Spain | Ceuta | 24232 | 188 | 0 | 35.8894 | -5.3213 | 2022-09-28 04:23:01 | Ceuta, Spain | |||
3994935 | 3994935 | 2022-09-27 | Spain | Catalonia | 2633217 | 20519 | 0 | 41.5912 | 1.5209 | 2022-09-28 04:23:01 | Catalonia, Spain | |||
3994934 | 3994934 | 2022-09-27 | Spain | Castilla y Leon | 821880 | 9172 | 0 | 41.8357 | -4.3976 | 2022-09-28 04:23:01 | Castilla y Leon, Spain | |||
3994933 | 3994933 | 2022-09-27 | Spain | Castilla - La Mancha | 593160 | 7840 | 0 | 39.2796 | -3.0977 | 2022-09-28 04:23:01 | Castilla - La Mancha, Spain | |||
3994932 | 3994932 | 2022-09-27 | Spain | Cantabria | 158352 | 958 | 0 | 43.1828 | -3.9878 | 2022-09-28 04:23:01 | Cantabria, Spain | |||
3994931 | 3994931 | 2022-09-27 | Spain | Canarias | 443894 | 2075 | 0 | 28.2916 | -16.6291 | 2022-09-28 04:23:01 | Canarias, Spain | |||
3994930 | 3994930 | 2022-09-27 | Spain | C. Valenciana | 1552005 | 10027 | 0 | 39.484 | -0.7533 | 2022-09-28 04:23:01 | C. Valenciana, Spain | |||
3994929 | 3994929 | 2022-09-27 | Spain | Baleares | 309211 | 1561 | 0 | 39.710358 | 2.995148 | 2022-09-28 04:23:01 | Baleares, Spain | |||
3994928 | 3994928 | 2022-09-27 | Spain | Asturias | 257285 | 3116 | 0 | 43.3614 | -5.8593 | 2022-09-28 04:23:01 | Asturias, Spain | |||
3994927 | 3994927 | 2022-09-27 | Spain | Aragon | 457323 | 5221 | 0 | 41.5976 | -0.9057 | 2022-09-28 04:23:01 | Aragon, Spain | |||
3994926 | 3994926 | 2022-09-27 | Spain | Andalusia | 1587709 | 14549 | 0 | 37.5443 | -4.7278 | 2022-09-28 04:23:01 | Andalusia, Spain | |||
3990909 | 3990909 | 2020-10-20 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-21 04:24:14 | Unknown, Spain | ||||
3990908 | 3990908 | 2020-10-20 | Spain | Pais Vasco | 54861 | 2027 | 16160 | 36674 | 42.9896 | -2.6189 | 2020-10-21 04:24:14 | Pais Vasco, Spain | ||
3990907 | 3990907 | 2020-10-20 | Spain | Navarra | 26453 | 657 | 3905 | 21891 | 42.6954 | -1.6761 | 2020-10-21 04:24:14 | Navarra, Spain | ||
3990906 | 3990906 | 2020-10-20 | Spain | Murcia | 27578 | 270 | 2180 | 25128 | 37.9922 | -1.1307 | 2020-10-21 04:24:14 | Murcia, Spain | ||
3990905 | 3990905 | 2020-10-20 | Spain | Melilla | 1885 | 11 | 125 | 1749 | 35.2923 | -2.9381 | 2020-10-21 04:24:14 | Melilla, Spain | ||
3990904 | 3990904 | 2020-10-20 | Spain | Madrid | 283130 | 10059 | 40736 | 232335 | 40.4168 | -3.7038 | 2020-10-21 04:24:14 | Madrid, Spain | ||
3990903 | 3990903 | 2020-10-20 | Spain | La Rioja | 10722 | 440 | 3107 | 7175 | 42.2871 | -2.5396 | 2020-10-21 04:24:14 | La Rioja, Spain | ||
3990902 | 3990902 | 2020-10-20 | Spain | Galicia | 27259 | 834 | 9204 | 17221 | 42.5751 | -8.1339 | 2020-10-21 04:24:14 | Galicia, Spain | ||
3990901 | 3990901 | 2020-10-20 | Spain | Extremadura | 14884 | 656 | 2652 | 11576 | 39.4937 | -6.0679 | 2020-10-21 04:24:14 | Extremadura, Spain | ||
3990900 | 3990900 | 2020-10-20 | Spain | Ceuta | 1028 | 13 | 163 | 852 | 35.8894 | -5.3213 | 2020-10-21 04:24:14 | Ceuta, Spain | ||
3990899 | 3990899 | 2020-10-20 | Spain | Catalonia | 179552 | 5919 | 26203 | 147430 | 41.5912 | 1.5209 | 2020-10-21 04:24:14 | Catalonia, Spain | ||
3990898 | 3990898 | 2020-10-20 | Spain | Castilla y Leon | 65158 | 3380 | 8716 | 53062 | 41.8357 | -4.3976 | 2020-10-21 04:24:14 | Castilla y Leon, Spain | ||
3990897 | 3990897 | 2020-10-20 | Spain | Castilla - La Mancha | 54488 | 3331 | 6392 | 44765 | 39.2796 | -3.0977 | 2020-10-21 04:24:14 | Castilla - La Mancha, Spain | ||
3990896 | 3990896 | 2020-10-20 | Spain | Cantabria | 8016 | 247 | 2287 | 5482 | 43.1828 | -3.9878 | 2020-10-21 04:24:14 | Cantabria, Spain | ||
3990895 | 3990895 | 2020-10-20 | Spain | Canarias | 16082 | 259 | 1537 | 14286 | 28.2916 | -16.6291 | 2020-10-21 04:24:14 | Canarias, Spain | ||
3990894 | 3990894 | 2020-10-20 | Spain | C. Valenciana | 50966 | 1687 | 9970 | 39309 | 39.484 | -0.7533 | 2020-10-21 04:24:14 | C. Valenciana, Spain | ||
3990893 | 3990893 | 2020-10-20 | Spain | Baleares | 16316 | 332 | 1533 | 14451 | 39.710358 | 2.995148 | 2020-10-21 04:24:14 | Baleares, Spain | ||
3990892 | 3990892 | 2020-10-20 | Spain | Asturias | 8654 | 371 | 1063 | 7220 | 43.3614 | -5.8593 | 2020-10-21 04:24:14 | Asturias, Spain | ||
3990891 | 3990891 | 2020-10-20 | Spain | Aragon | 45066 | 1541 | 3772 | 39753 | 41.5976 | -0.9057 | 2020-10-21 04:24:14 | Aragon, Spain | ||
3990890 | 3990890 | 2020-10-20 | Spain | Andalusia | 96224 | 2176 | 10671 | 83377 | 37.5443 | -4.7278 | 2020-10-21 04:24:14 | Andalusia, Spain | ||
3986934 | 3986934 | 2022-09-15 | Spain | Unknown | 0 | 0 | 0 | 2022-09-16 04:21:19 | Unknown, Spain | |||||
3986933 | 3986933 | 2022-09-15 | Spain | Pais Vasco | 771335 | 7288 | 0 | 42.9896 | -2.6189 | 2022-09-16 04:21:19 | Pais Vasco, Spain | |||
3986932 | 3986932 | 2022-09-15 | Spain | Navarra | 255211 | 1703 | 0 | 42.6954 | -1.6761 | 2022-09-16 04:21:19 | Navarra, Spain | |||
3986931 | 3986931 | 2022-09-15 | Spain | Murcia | 454993 | 2443 | 0 | 37.9922 | -1.1307 | 2022-09-16 04:21:19 | Murcia, Spain | |||
3986930 | 3986930 | 2022-09-15 | Spain | Melilla | 24714 | 167 | 0 | 35.2923 | -2.9381 | 2022-09-16 04:21:19 | Melilla, Spain | |||
3986929 | 3986929 | 2022-09-15 | Spain | Madrid | 1918596 | 19292 | 0 | 40.4168 | -3.7038 | 2022-09-16 04:21:19 | Madrid, Spain | |||
3986928 | 3986928 | 2022-09-15 | Spain | La Rioja | 108500 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-16 04:21:19 | La Rioja, Spain | |||
3986927 | 3986927 | 2022-09-15 | Spain | Galicia | 726471 | 3886 | 0 | 42.5751 | -8.1339 | 2022-09-16 04:21:19 | Galicia, Spain | |||
3986926 | 3986926 | 2022-09-15 | Spain | Extremadura | 302690 | 2624 | 0 | 39.4937 | -6.0679 | 2022-09-16 04:21:19 | Extremadura, Spain | |||
3986925 | 3986925 | 2022-09-15 | Spain | Ceuta | 24224 | 187 | 0 | 35.8894 | -5.3213 | 2022-09-16 04:21:19 | Ceuta, Spain | |||
3986924 | 3986924 | 2022-09-15 | Spain | Catalonia | 2629284 | 20492 | 0 | 41.5912 | 1.5209 | 2022-09-16 04:21:19 | Catalonia, Spain | |||
3986923 | 3986923 | 2022-09-15 | Spain | Castilla y Leon | 818986 | 9157 | 0 | 41.8357 | -4.3976 | 2022-09-16 04:21:19 | Castilla y Leon, Spain | |||
3986922 | 3986922 | 2022-09-15 | Spain | Castilla - La Mancha | 589167 | 7806 | 0 | 39.2796 | -3.0977 | 2022-09-16 04:21:19 | Castilla - La Mancha, Spain | |||
3986921 | 3986921 | 2022-09-15 | Spain | Cantabria | 158017 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-16 04:21:19 | Cantabria, Spain | |||
3986920 | 3986920 | 2022-09-15 | Spain | Canarias | 442052 | 2060 | 0 | 28.2916 | -16.6291 | 2022-09-16 04:21:19 | Canarias, Spain | |||
3986919 | 3986919 | 2022-09-15 | Spain | C. Valenciana | 1547962 | 10000 | 0 | 39.484 | -0.7533 | 2022-09-16 04:21:19 | C. Valenciana, Spain | |||
3986918 | 3986918 | 2022-09-15 | Spain | Baleares | 308485 | 1530 | 0 | 39.710358 | 2.995148 | 2022-09-16 04:21:19 | Baleares, Spain | |||
3986917 | 3986917 | 2022-09-15 | Spain | Asturias | 256464 | 3108 | 0 | 43.3614 | -5.8593 | 2022-09-16 04:21:19 | Asturias, Spain | |||
3986916 | 3986916 | 2022-09-15 | Spain | Aragon | 456269 | 5209 | 0 | 41.5976 | -0.9057 | 2022-09-16 04:21:19 | Aragon, Spain | |||
3986915 | 3986915 | 2022-09-15 | Spain | Andalusia | 1580696 | 14422 | 0 | 37.5443 | -4.7278 | 2022-09-16 04:21:19 | Andalusia, 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]);