⚠️ 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,238 rows where country_or_region = "Spain" sorted by fips

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Spain · 8,238
Link rowid day country_or_region province_or_state admin2 fips ▼ confirmed deaths recovered active latitude longitude last_update combined_key
598 2021-02-27 Spain Andalusia     476822 8328 10671 457823 37.5443 -4.7278 2021-02-28 05:22:20 Andalusia, Spain
599 2021-02-27 Spain Aragon     106480 3258 3772 99450 41.5976 -0.9057 2021-02-28 05:22:20 Aragon, Spain
600 2021-02-27 Spain Asturias     43179 1750 1063 40366 43.3614 -5.8593 2021-02-28 05:22:20 Asturias, Spain
601 2021-02-27 Spain Baleares     55991 707 1533 53751 39.710358 2.995148 2021-02-28 05:22:20 Baleares, Spain
602 2021-02-27 Spain C. Valenciana     377866 6632 9970 361264 39.484 -0.7533 2021-02-28 05:22:20 C. Valenciana, Spain
603 2021-02-27 Spain Canarias     40477 589 1537 38351 28.2916 -16.6291 2021-02-28 05:22:20 Canarias, Spain
604 2021-02-27 Spain Cantabria     24574 508 2287 21779 43.1828 -3.9878 2021-02-28 05:22:20 Cantabria, Spain
605 2021-02-27 Spain Castilla - La Mancha     168561 5588 6392 156581 39.2796 -3.0977 2021-02-28 05:22:20 Castilla - La Mancha, Spain
606 2021-02-27 Spain Castilla y Leon     205587 6320 8716 190551 41.8357 -4.3976 2021-02-28 05:22:20 Castilla y Leon, Spain
607 2021-02-27 Spain Catalonia     577701 10575 26203 540923 41.5912 1.5209 2021-02-28 05:22:20 Catalonia, Spain
608 2021-02-27 Spain Ceuta     4562 81 163 4318 35.8894 -5.3213 2021-02-28 05:22:20 Ceuta, Spain
609 2021-02-27 Spain Extremadura     68952 1706 2652 64594 39.4937 -6.0679 2021-02-28 05:22:20 Extremadura, Spain
610 2021-02-27 Spain Galicia     111461 2194 9204 100063 42.5751 -8.1339 2021-02-28 05:22:20 Galicia, Spain
611 2021-02-27 Spain La Rioja     27422 725 3107 23590 42.2871 -2.5396 2021-02-28 05:22:20 La Rioja, Spain
612 2021-02-27 Spain Madrid     583862 13842 40736 529284 40.4168 -3.7038 2021-02-28 05:22:20 Madrid, Spain
613 2021-02-27 Spain Melilla     6938 70 125 6743 35.2923 -2.9381 2021-02-28 05:22:20 Melilla, Spain
614 2021-02-27 Spain Murcia     106200 1451 2180 102569 37.9922 -1.1307 2021-02-28 05:22:20 Murcia, Spain
615 2021-02-27 Spain Navarra     51244 1092 3905 46247 42.6954 -1.6761 2021-02-28 05:22:20 Navarra, Spain
616 2021-02-27 Spain Pais Vasco     150674 3726 16160 130788 42.9896 -2.6189 2021-02-28 05:22:20 Pais Vasco, Spain
617 2021-02-27 Spain Unknown     0 0 0 0     2021-02-28 05:22:20 Unknown, Spain
7037 2020-06-04 Spain Andalusia     12743 1404 10671 668 37.5443 -4.7278 2020-06-05 02:33:06 Andalusia, Spain
7044 2020-06-04 Spain Aragon     5734 826 3772 1136 41.5976 -0.9057 2020-06-05 02:33:06 Aragon, Spain
7052 2020-06-04 Spain Asturias     2425 311 1063 1051 43.3614 -5.8593 2020-06-05 02:33:06 Asturias, Spain
7062 2020-06-04 Spain Baleares     2164 209 1533 422 39.710358 2.995148 2020-06-05 02:33:06 Baleares, Spain
7080 2020-06-04 Spain C. Valenciana     11265 1332 9970 -37 39.484 -0.7533 2020-06-05 02:33:06 C. Valenciana, Spain
7087 2020-06-04 Spain Canarias     2361 151 1537 673 28.2916 -16.6291 2020-06-05 02:33:06 Canarias, Spain
7088 2020-06-04 Spain Cantabria     2316 202 2287 -173 43.1828 -3.9878 2020-06-05 02:33:06 Cantabria, Spain
7092 2020-06-04 Spain Castilla - La Mancha     17393 2945 6392 8056 39.2796 -3.0977 2020-06-05 02:33:06 Castilla - La Mancha, Spain
7093 2020-06-04 Spain Castilla y Leon     19009 1928 8716 8365 41.8357 -4.3976 2020-06-05 02:33:06 Castilla y Leon, Spain
7094 2020-06-04 Spain Catalonia     59163 5587 26203 27373 41.5912 1.5209 2020-06-05 02:33:06 Catalonia, Spain
7099 2020-06-04 Spain Ceuta     163 4 163 -4 35.8894 -5.3213 2020-06-05 02:33:06 Ceuta, Spain
7132 2020-06-04 Spain Extremadura     2973 508 2652 -187 39.4937 -6.0679 2020-06-05 02:33:06 Extremadura, Spain
7142 2020-06-04 Spain Galicia     9134 609 9204 -679 42.5751 -8.1339 2020-06-05 02:33:06 Galicia, Spain
7222 2020-06-04 Spain La Rioja     4054 362 3107 585 42.2871 -2.5396 2020-06-05 02:33:06 La Rioja, Spain
7238 2020-06-04 Spain Madrid     69236 8691 40736 19809 40.4168 -3.7038 2020-06-05 02:33:06 Madrid, Spain
7252 2020-06-04 Spain Melilla     122 2 125 -5 35.2923 -2.9381 2020-06-05 02:33:06 Melilla, Spain
7268 2020-06-04 Spain Murcia     1613 148 2180 -715 37.9922 -1.1307 2020-06-05 02:33:06 Murcia, Spain
7275 2020-06-04 Spain Navarra     5265 490 3905 870 42.6954 -1.6761 2020-06-05 02:33:06 Navarra, Spain
7311 2020-06-04 Spain Pais Vasco     13527 1424 16160 -4057 42.9896 -2.6189 2020-06-05 02:33:06 Pais Vasco, Spain
7430 2020-06-04 Spain Unknown     0 0 0 0     2020-06-05 02:33:06 Unknown, Spain
8221 2020-08-11 Spain Andalusia     17758 1443 10671 5644 37.5443 -4.7278 2020-08-12 04:27:29 Andalusia, Spain
8222 2020-08-11 Spain Aragon     18849 991 3772 14086 41.5976 -0.9057 2020-08-12 04:27:29 Aragon, Spain
8223 2020-08-11 Spain Asturias     2715 334 1063 1318 43.3614 -5.8593 2020-08-12 04:27:29 Asturias, Spain
8224 2020-08-11 Spain Baleares     3501 225 1533 1743 39.710358 2.995148 2020-08-12 04:27:29 Baleares, Spain
8225 2020-08-11 Spain C. Valenciana     15663 1439 9970 4254 39.484 -0.7533 2020-08-12 04:27:29 C. Valenciana, Spain
8226 2020-08-11 Spain Canarias     3041 164 1537 1340 28.2916 -16.6291 2020-08-12 04:27:29 Canarias, Spain
8227 2020-08-11 Spain Cantabria     2759 219 2287 253 43.1828 -3.9878 2020-08-12 04:27:29 Cantabria, Spain
8228 2020-08-11 Spain Castilla - La Mancha     19445 3035 6392 10018 39.2796 -3.0977 2020-08-12 04:27:29 Castilla - La Mancha, Spain
8229 2020-08-11 Spain Castilla y Leon     21994 2802 8716 10476 41.8357 -4.3976 2020-08-12 04:27:29 Castilla y Leon, Spain
8230 2020-08-11 Spain Catalonia     89015 5706 26203 57106 41.5912 1.5209 2020-08-12 04:27:29 Catalonia, Spain
8231 2020-08-11 Spain Ceuta     168 4 163 1 35.8894 -5.3213 2020-08-12 04:27:29 Ceuta, Spain
8232 2020-08-11 Spain Extremadura     3626 521 2652 453 39.4937 -6.0679 2020-08-12 04:27:29 Extremadura, Spain
8233 2020-08-11 Spain Galicia     10284 622 9204 458 42.5751 -8.1339 2020-08-12 04:27:29 Galicia, Spain
8234 2020-08-11 Spain La Rioja     4301 366 3107 828 42.2871 -2.5396 2020-08-12 04:27:29 La Rioja, Spain
8235 2020-08-11 Spain Madrid     83606 8464 40736 34406 40.4168 -3.7038 2020-08-12 04:27:29 Madrid, Spain
8236 2020-08-11 Spain Melilla     174 2 125 47 35.2923 -2.9381 2020-08-12 04:27:29 Melilla, Spain
8237 2020-08-11 Spain Murcia     3039 148 2180 711 37.9922 -1.1307 2020-08-12 04:27:29 Murcia, Spain
8238 2020-08-11 Spain Navarra     7564 531 3905 3128 42.6954 -1.6761 2020-08-12 04:27:29 Navarra, Spain
8239 2020-08-11 Spain Pais Vasco     19110 1565 16160 1385 42.9896 -2.6189 2020-08-12 04:27:29 Pais Vasco, Spain
8240 2020-08-11 Spain Unknown     0 0 0 0     2020-08-12 04:27:29 Unknown, Spain
12174 2020-09-27 Spain Andalusia     56615 1744 10671 44200 37.5443 -4.7278 2020-09-28 04:23:00 Andalusia, Spain
12175 2020-09-27 Spain Aragon     34722 1360 3772 29590 41.5976 -0.9057 2020-09-28 04:23:00 Aragon, Spain
12176 2020-09-27 Spain Asturias     4964 343 1063 3558 43.3614 -5.8593 2020-09-28 04:23:00 Asturias, Spain
12177 2020-09-27 Spain Baleares     13309 287 1533 11489 39.710358 2.995148 2020-09-28 04:23:00 Baleares, Spain
12178 2020-09-27 Spain C. Valenciana     38112 1583 9970 26559 39.484 -0.7533 2020-09-28 04:23:00 C. Valenciana, Spain
12179 2020-09-27 Spain Canarias     12762 220 1537 11005 28.2916 -16.6291 2020-09-28 04:23:00 Canarias, Spain
12180 2020-09-27 Spain Cantabria     6568 233 2287 4048 43.1828 -3.9878 2020-09-28 04:23:00 Cantabria, Spain
12181 2020-09-27 Spain Castilla - La Mancha     39954 3111 6392 30451 39.2796 -3.0977 2020-09-28 04:23:00 Castilla - La Mancha, Spain
12182 2020-09-27 Spain Castilla y Leon     44353 2994 8716 32643 41.8357 -4.3976 2020-09-28 04:23:00 Castilla y Leon, Spain
12183 2020-09-27 Spain Catalonia     135469 5829 26203 103437 41.5912 1.5209 2020-09-28 04:23:00 Catalonia, Spain
12184 2020-09-27 Spain Ceuta     528 10 163 355 35.8894 -5.3213 2020-09-28 04:23:00 Ceuta, Spain
12185 2020-09-27 Spain Extremadura     9890 564 2652 6674 39.4937 -6.0679 2020-09-28 04:23:00 Extremadura, Spain
12186 2020-09-27 Spain Galicia     20420 726 9204 10490 42.5751 -8.1339 2020-09-28 04:23:00 Galicia, Spain
12187 2020-09-27 Spain La Rioja     8101 409 3107 4585 42.2871 -2.5396 2020-09-28 04:23:00 La Rioja, Spain
12188 2020-09-27 Spain Madrid     213709 9213 40736 163760 40.4168 -3.7038 2020-09-28 04:23:00 Madrid, Spain
12189 2020-09-27 Spain Melilla     860 4 125 731 35.2923 -2.9381 2020-09-28 04:23:00 Melilla, Spain
12190 2020-09-27 Spain Murcia     17109 201 2180 14728 37.9922 -1.1307 2020-09-28 04:23:00 Murcia, Spain
12191 2020-09-27 Spain Navarra     16572 563 3905 12104 42.6954 -1.6761 2020-09-28 04:23:00 Navarra, Spain
12192 2020-09-27 Spain Pais Vasco     42464 1838 16160 24466 42.9896 -2.6189 2020-09-28 04:23:00 Pais Vasco, Spain
12193 2020-09-27 Spain Unknown     0 0 0 0     2020-09-28 04:23:00 Unknown, Spain
18771 2020-05-12 Spain       228030 26920 138980 62130 40.463667 -3.74922 2020-05-13 03:32:26 Spain
19404 2021-05-31 Spain Andalusia     584878 9887 10671 564320 37.5443 -4.7278 2021-06-01 04:23:09 Andalusia, Spain
19405 2021-05-31 Spain Aragon     124235 3509 3772 116954 41.5976 -0.9057 2021-06-01 04:23:09 Aragon, Spain
19406 2021-05-31 Spain Asturias     52380 1967 1063 49350 43.3614 -5.8593 2021-06-01 04:23:09 Asturias, Spain
19407 2021-05-31 Spain Baleares     60464 839 1533 58092 39.710358 2.995148 2021-06-01 04:23:09 Baleares, Spain
19408 2021-05-31 Spain C. Valenciana     394760 7392 9970 377398 39.484 -0.7533 2021-06-01 04:23:09 C. Valenciana, Spain
19409 2021-05-31 Spain Canarias     56487 770 1537 54180 28.2916 -16.6291 2021-06-01 04:23:09 Canarias, Spain
19410 2021-05-31 Spain Cantabria     30268 565 2287 27416 43.1828 -3.9878 2021-06-01 04:23:09 Cantabria, Spain
19411 2021-05-31 Spain Castilla - La Mancha     193066 5918 6392 180756 39.2796 -3.0977 2021-06-01 04:23:09 Castilla - La Mancha, Spain
19412 2021-05-31 Spain Castilla y Leon     231104 6884 8716 215504 41.8357 -4.3976 2021-06-01 04:23:09 Castilla y Leon, Spain
19413 2021-05-31 Spain Catalonia     611755 14542 26203 571010 41.5912 1.5209 2021-06-01 04:23:09 Catalonia, Spain
19414 2021-05-31 Spain Ceuta     5872 115 163 5594 35.8894 -5.3213 2021-06-01 04:23:09 Ceuta, Spain
19415 2021-05-31 Spain Extremadura     75829 1803 2652 71374 39.4937 -6.0679 2021-06-01 04:23:09 Extremadura, Spain
19416 2021-05-31 Spain Galicia     126933 2404 9204 115325 42.5751 -8.1339 2021-06-01 04:23:09 Galicia, Spain
19417 2021-05-31 Spain La Rioja     30897 771 3107 27019 42.2871 -2.5396 2021-06-01 04:23:09 La Rioja, Spain
19418 2021-05-31 Spain Madrid     716173 15287 40736 660150 40.4168 -3.7038 2021-06-01 04:23:09 Madrid, Spain
19419 2021-05-31 Spain Melilla     9124 97 125 8902 35.2923 -2.9381 2021-06-01 04:23:09 Melilla, Spain
19420 2021-05-31 Spain Murcia     113069 1600 2180 109289 37.9922 -1.1307 2021-06-01 04:23:09 Murcia, Spain
19421 2021-05-31 Spain Navarra     62422 1174 3905 57343 42.6954 -1.6761 2021-06-01 04:23:09 Navarra, Spain
19422 2021-05-31 Spain Pais Vasco     198674 4429 16160 178085 42.9896 -2.6189 2021-06-01 04:23:09 Pais Vasco, 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]);