⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

8,038 rows where country_or_region = "Spain" sorted by day descending

View and edit SQL

Suggested facets: latitude, combined_key, last_update (date)

longitude

country_or_region

  • Spain · 8,038
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
223212 2021-06-14 Spain Andalusia     601677 9981 10671 581025 37.5443 -4.7278 2021-06-15 04:22:22 Andalusia, Spain
223213 2021-06-14 Spain Aragon     125662 3530 3772 118360 41.5976 -0.9057 2021-06-15 04:22:22 Aragon, Spain
223214 2021-06-14 Spain Asturias     53120 1972 1063 50085 43.3614 -5.8593 2021-06-15 04:22:22 Asturias, Spain
223215 2021-06-14 Spain Baleares     60971 842 1533 58596 39.710358 2.995148 2021-06-15 04:22:22 Baleares, Spain
223216 2021-06-14 Spain C. Valenciana     397090 7405 9970 379715 39.484 -0.7533 2021-06-15 04:22:22 C. Valenciana, Spain
223217 2021-06-14 Spain Canarias     58184 782 1537 55865 28.2916 -16.6291 2021-06-15 04:22:22 Canarias, Spain
223218 2021-06-14 Spain Cantabria     30653 566 2287 27800 43.1828 -3.9878 2021-06-15 04:22:22 Cantabria, Spain
223219 2021-06-14 Spain Castilla - La Mancha     195140 5979 6392 182769 39.2796 -3.0977 2021-06-15 04:22:22 Castilla - La Mancha, Spain
223220 2021-06-14 Spain Castilla y Leon     233678 6906 8716 218056 41.8357 -4.3976 2021-06-15 04:22:22 Castilla y Leon, Spain
223221 2021-06-14 Spain Catalonia     630929 14691 26203 590035 41.5912 1.5209 2021-06-15 04:22:22 Catalonia, Spain
223222 2021-06-14 Spain Ceuta     5968 116 163 5689 35.8894 -5.3213 2021-06-15 04:22:22 Ceuta, Spain
223223 2021-06-14 Spain Extremadura     76539 1805 2652 72082 39.4937 -6.0679 2021-06-15 04:22:22 Extremadura, Spain
223224 2021-06-14 Spain Galicia     128151 2417 9204 116530 42.5751 -8.1339 2021-06-15 04:22:22 Galicia, Spain
223225 2021-06-14 Spain La Rioja     31482 775 3107 27600 42.2871 -2.5396 2021-06-15 04:22:22 La Rioja, Spain
223226 2021-06-14 Spain Madrid     724243 15378 40736 668129 40.4168 -3.7038 2021-06-15 04:22:22 Madrid, Spain
223227 2021-06-14 Spain Melilla     9206 97 125 8984 35.2923 -2.9381 2021-06-15 04:22:22 Melilla, Spain
223228 2021-06-14 Spain Murcia     113831 1604 2180 110047 37.9922 -1.1307 2021-06-15 04:22:22 Murcia, Spain
223229 2021-06-14 Spain Navarra     63225 1178 3905 58142 42.6954 -1.6761 2021-06-15 04:22:22 Navarra, Spain
223230 2021-06-14 Spain Pais Vasco     202018 4493 16160 181365 42.9896 -2.6189 2021-06-15 04:22:22 Pais Vasco, Spain
223231 2021-06-14 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
215244 2021-06-13 Spain Andalusia     598947 9975 10671 578301 37.5443 -4.7278 2021-06-14 04:22:46 Andalusia, Spain
215245 2021-06-13 Spain Aragon     125490 3530 3772 118188 41.5976 -0.9057 2021-06-14 04:22:46 Aragon, Spain
215246 2021-06-13 Spain Asturias     52979 1972 1063 49944 43.3614 -5.8593 2021-06-14 04:22:46 Asturias, Spain
215247 2021-06-13 Spain Baleares     60884 840 1533 58511 39.710358 2.995148 2021-06-14 04:22:46 Baleares, Spain
215248 2021-06-13 Spain C. Valenciana     396689 7404 9970 379315 39.484 -0.7533 2021-06-14 04:22:46 C. Valenciana, Spain
215249 2021-06-13 Spain Canarias     57808 781 1537 55490 28.2916 -16.6291 2021-06-14 04:22:46 Canarias, Spain
215250 2021-06-13 Spain Cantabria     30588 566 2287 27735 43.1828 -3.9878 2021-06-14 04:22:46 Cantabria, Spain
215251 2021-06-13 Spain Castilla - La Mancha     194727 5977 6392 182358 39.2796 -3.0977 2021-06-14 04:22:46 Castilla - La Mancha, Spain
215252 2021-06-13 Spain Castilla y Leon     233366 6904 8716 217746 41.8357 -4.3976 2021-06-14 04:22:46 Castilla y Leon, Spain
215253 2021-06-13 Spain Catalonia     629718 14691 26203 588824 41.5912 1.5209 2021-06-14 04:22:46 Catalonia, Spain
215254 2021-06-13 Spain Ceuta     5957 116 163 5678 35.8894 -5.3213 2021-06-14 04:22:46 Ceuta, Spain
215255 2021-06-13 Spain Extremadura     76421 1805 2652 71964 39.4937 -6.0679 2021-06-14 04:22:46 Extremadura, Spain
215256 2021-06-13 Spain Galicia     127925 2415 9204 116306 42.5751 -8.1339 2021-06-14 04:22:46 Galicia, Spain
215257 2021-06-13 Spain La Rioja     31409 775 3107 27527 42.2871 -2.5396 2021-06-14 04:22:46 La Rioja, Spain
215258 2021-06-13 Spain Madrid     723206 15378 40736 667092 40.4168 -3.7038 2021-06-14 04:22:46 Madrid, Spain
215259 2021-06-13 Spain Melilla     9201 97 125 8979 35.2923 -2.9381 2021-06-14 04:22:46 Melilla, Spain
215260 2021-06-13 Spain Murcia     113680 1604 2180 109896 37.9922 -1.1307 2021-06-14 04:22:46 Murcia, Spain
215261 2021-06-13 Spain Navarra     63087 1178 3905 58004 42.6954 -1.6761 2021-06-14 04:22:46 Navarra, Spain
215262 2021-06-13 Spain Pais Vasco     201518 4493 16160 180865 42.9896 -2.6189 2021-06-14 04:22:46 Pais Vasco, Spain
215263 2021-06-13 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
281814 2021-06-12 Spain Andalusia     598947 9975 10671 578301 37.5443 -4.7278 2021-06-13 04:22:44 Andalusia, Spain
281815 2021-06-12 Spain Aragon     125490 3530 3772 118188 41.5976 -0.9057 2021-06-13 04:22:44 Aragon, Spain
281816 2021-06-12 Spain Asturias     52979 1972 1063 49944 43.3614 -5.8593 2021-06-13 04:22:44 Asturias, Spain
281817 2021-06-12 Spain Baleares     60884 840 1533 58511 39.710358 2.995148 2021-06-13 04:22:44 Baleares, Spain
281818 2021-06-12 Spain C. Valenciana     396689 7404 9970 379315 39.484 -0.7533 2021-06-13 04:22:44 C. Valenciana, Spain
281819 2021-06-12 Spain Canarias     57808 781 1537 55490 28.2916 -16.6291 2021-06-13 04:22:44 Canarias, Spain
281820 2021-06-12 Spain Cantabria     30588 566 2287 27735 43.1828 -3.9878 2021-06-13 04:22:44 Cantabria, Spain
281821 2021-06-12 Spain Castilla - La Mancha     194727 5977 6392 182358 39.2796 -3.0977 2021-06-13 04:22:44 Castilla - La Mancha, Spain
281822 2021-06-12 Spain Castilla y Leon     233366 6904 8716 217746 41.8357 -4.3976 2021-06-13 04:22:44 Castilla y Leon, Spain
281823 2021-06-12 Spain Catalonia     629718 14691 26203 588824 41.5912 1.5209 2021-06-13 04:22:44 Catalonia, Spain
281824 2021-06-12 Spain Ceuta     5957 116 163 5678 35.8894 -5.3213 2021-06-13 04:22:44 Ceuta, Spain
281825 2021-06-12 Spain Extremadura     76421 1805 2652 71964 39.4937 -6.0679 2021-06-13 04:22:44 Extremadura, Spain
281826 2021-06-12 Spain Galicia     127925 2415 9204 116306 42.5751 -8.1339 2021-06-13 04:22:44 Galicia, Spain
281827 2021-06-12 Spain La Rioja     31409 775 3107 27527 42.2871 -2.5396 2021-06-13 04:22:44 La Rioja, Spain
281828 2021-06-12 Spain Madrid     723206 15378 40736 667092 40.4168 -3.7038 2021-06-13 04:22:44 Madrid, Spain
281829 2021-06-12 Spain Melilla     9201 97 125 8979 35.2923 -2.9381 2021-06-13 04:22:44 Melilla, Spain
281830 2021-06-12 Spain Murcia     113680 1604 2180 109896 37.9922 -1.1307 2021-06-13 04:22:44 Murcia, Spain
281831 2021-06-12 Spain Navarra     63087 1178 3905 58004 42.6954 -1.6761 2021-06-13 04:22:44 Navarra, Spain
281832 2021-06-12 Spain Pais Vasco     201518 4493 16160 180865 42.9896 -2.6189 2021-06-13 04:22:44 Pais Vasco, Spain
281833 2021-06-12 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1633913 2021-06-11 Spain Andalusia     598947 9975 10671 578301 37.5443 -4.7278 2021-06-12 04:22:22 Andalusia, Spain
1633914 2021-06-11 Spain Aragon     125490 3530 3772 118188 41.5976 -0.9057 2021-06-12 04:22:22 Aragon, Spain
1633915 2021-06-11 Spain Asturias     52979 1972 1063 49944 43.3614 -5.8593 2021-06-12 04:22:22 Asturias, Spain
1633916 2021-06-11 Spain Baleares     60884 840 1533 58511 39.710358 2.995148 2021-06-12 04:22:22 Baleares, Spain
1633917 2021-06-11 Spain C. Valenciana     396689 7404 9970 379315 39.484 -0.7533 2021-06-12 04:22:22 C. Valenciana, Spain
1633918 2021-06-11 Spain Canarias     57808 781 1537 55490 28.2916 -16.6291 2021-06-12 04:22:22 Canarias, Spain
1633919 2021-06-11 Spain Cantabria     30588 566 2287 27735 43.1828 -3.9878 2021-06-12 04:22:22 Cantabria, Spain
1633920 2021-06-11 Spain Castilla - La Mancha     194727 5977 6392 182358 39.2796 -3.0977 2021-06-12 04:22:22 Castilla - La Mancha, Spain
1633921 2021-06-11 Spain Castilla y Leon     233366 6904 8716 217746 41.8357 -4.3976 2021-06-12 04:22:22 Castilla y Leon, Spain
1633922 2021-06-11 Spain Catalonia     629718 14691 26203 588824 41.5912 1.5209 2021-06-12 04:22:22 Catalonia, Spain
1633923 2021-06-11 Spain Ceuta     5957 116 163 5678 35.8894 -5.3213 2021-06-12 04:22:22 Ceuta, Spain
1633924 2021-06-11 Spain Extremadura     76421 1805 2652 71964 39.4937 -6.0679 2021-06-12 04:22:22 Extremadura, Spain
1633925 2021-06-11 Spain Galicia     127925 2415 9204 116306 42.5751 -8.1339 2021-06-12 04:22:22 Galicia, Spain
1633926 2021-06-11 Spain La Rioja     31409 775 3107 27527 42.2871 -2.5396 2021-06-12 04:22:22 La Rioja, Spain
1633927 2021-06-11 Spain Madrid     723206 15378 40736 667092 40.4168 -3.7038 2021-06-12 04:22:22 Madrid, Spain
1633928 2021-06-11 Spain Melilla     9201 97 125 8979 35.2923 -2.9381 2021-06-12 04:22:22 Melilla, Spain
1633929 2021-06-11 Spain Murcia     113680 1604 2180 109896 37.9922 -1.1307 2021-06-12 04:22:22 Murcia, Spain
1633930 2021-06-11 Spain Navarra     63087 1178 3905 58004 42.6954 -1.6761 2021-06-12 04:22:22 Navarra, Spain
1633931 2021-06-11 Spain Pais Vasco     201518 4493 16160 180865 42.9896 -2.6189 2021-06-12 04:22:22 Pais Vasco, Spain
1633932 2021-06-11 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
663199 2021-06-10 Spain Andalusia     597465 9967 10671 576827 37.5443 -4.7278 2021-06-11 04:23:20 Andalusia, Spain
663200 2021-06-10 Spain Aragon     125373 3525 3772 118076 41.5976 -0.9057 2021-06-11 04:23:20 Aragon, Spain
663201 2021-06-10 Spain Asturias     52907 1972 1063 49872 43.3614 -5.8593 2021-06-11 04:23:20 Asturias, Spain
663202 2021-06-10 Spain Baleares     60840 840 1533 58467 39.710358 2.995148 2021-06-11 04:23:20 Baleares, Spain
663203 2021-06-10 Spain C. Valenciana     396502 7400 9970 379132 39.484 -0.7533 2021-06-11 04:23:20 C. Valenciana, Spain
663204 2021-06-10 Spain Canarias     57663 780 1537 55346 28.2916 -16.6291 2021-06-11 04:23:20 Canarias, Spain
663205 2021-06-10 Spain Cantabria     30563 566 2287 27710 43.1828 -3.9878 2021-06-11 04:23:20 Cantabria, Spain
663206 2021-06-10 Spain Castilla - La Mancha     194532 5966 6392 182174 39.2796 -3.0977 2021-06-11 04:23:20 Castilla - La Mancha, Spain
663207 2021-06-10 Spain Castilla y Leon     233165 6901 8716 217548 41.8357 -4.3976 2021-06-11 04:23:20 Castilla y Leon, Spain
663208 2021-06-10 Spain Catalonia     629143 14690 26203 588250 41.5912 1.5209 2021-06-11 04:23:20 Catalonia, Spain
663209 2021-06-10 Spain Ceuta     5948 116 163 5669 35.8894 -5.3213 2021-06-11 04:23:20 Ceuta, Spain
663210 2021-06-10 Spain Extremadura     76371 1805 2652 71914 39.4937 -6.0679 2021-06-11 04:23:20 Extremadura, Spain
663211 2021-06-10 Spain Galicia     127821 2415 9204 116202 42.5751 -8.1339 2021-06-11 04:23:20 Galicia, Spain
663212 2021-06-10 Spain La Rioja     31367 775 3107 27485 42.2871 -2.5396 2021-06-11 04:23:20 La Rioja, Spain
663213 2021-06-10 Spain Madrid     722667 15376 40736 666555 40.4168 -3.7038 2021-06-11 04:23:20 Madrid, Spain
663214 2021-06-10 Spain Melilla     9201 97 125 8979 35.2923 -2.9381 2021-06-11 04:23:20 Melilla, Spain
663215 2021-06-10 Spain Murcia     113603 1603 2180 109820 37.9922 -1.1307 2021-06-11 04:23:20 Murcia, Spain
663216 2021-06-10 Spain Navarra     63027 1178 3905 57944 42.6954 -1.6761 2021-06-11 04:23:20 Navarra, Spain
663217 2021-06-10 Spain Pais Vasco     201300 4493 16160 180647 42.9896 -2.6189 2021-06-11 04:23:20 Pais Vasco, Spain
663218 2021-06-10 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);