⚠️ 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

5,938 rows where country_or_region = "Spain" sorted by day descending

View and edit SQL

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

country_or_region

  • Spain · 5,938
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
801570 2021-03-01 Spain Andalusia     479489 8393 10671 460425 37.5443 -4.7278 2021-03-02 05:23:30 Andalusia, Spain
801571 2021-03-01 Spain Aragon     106860 3265 3772 99823 41.5976 -0.9057 2021-03-02 05:23:30 Aragon, Spain
801572 2021-03-01 Spain Asturias     43540 1770 1063 40707 43.3614 -5.8593 2021-03-02 05:23:30 Asturias, Spain
801573 2021-03-01 Spain Baleares     56164 725 1533 53906 39.710358 2.995148 2021-03-02 05:23:30 Baleares, Spain
801574 2021-03-01 Spain C. Valenciana     379103 6658 9970 362475 39.484 -0.7533 2021-03-02 05:23:30 C. Valenciana, Spain
801575 2021-03-01 Spain Canarias     40887 596 1537 38754 28.2916 -16.6291 2021-03-02 05:23:30 Canarias, Spain
801576 2021-03-01 Spain Cantabria     24699 510 2287 21902 43.1828 -3.9878 2021-03-02 05:23:30 Cantabria, Spain
801577 2021-03-01 Spain Castilla - La Mancha     169170 5613 6392 157165 39.2796 -3.0977 2021-03-02 05:23:30 Castilla - La Mancha, Spain
801578 2021-03-01 Spain Castilla y Leon     206184 6345 8716 191123 41.8357 -4.3976 2021-03-02 05:23:30 Castilla y Leon, Spain
801579 2021-03-01 Spain Catalonia     582073 10730 26203 545140 41.5912 1.5209 2021-03-02 05:23:30 Catalonia, Spain
801580 2021-03-01 Spain Ceuta     4616 82 163 4371 35.8894 -5.3213 2021-03-02 05:23:30 Ceuta, Spain
801581 2021-03-01 Spain Extremadura     69043 1718 2652 64673 39.4937 -6.0679 2021-03-02 05:23:30 Extremadura, Spain
801582 2021-03-01 Spain Galicia     112070 2226 9204 100640 42.5751 -8.1339 2021-03-02 05:23:30 Galicia, Spain
801583 2021-03-01 Spain La Rioja     27463 725 3107 23631 42.2871 -2.5396 2021-03-02 05:23:30 La Rioja, Spain
801584 2021-03-01 Spain Madrid     586913 13874 40736 532303 40.4168 -3.7038 2021-03-02 05:23:30 Madrid, Spain
801585 2021-03-01 Spain Melilla     6981 72 125 6784 35.2923 -2.9381 2021-03-02 05:23:30 Melilla, Spain
801586 2021-03-01 Spain Murcia     106388 1482 2180 102726 37.9922 -1.1307 2021-03-02 05:23:30 Murcia, Spain
801587 2021-03-01 Spain Navarra     51379 1094 3905 46380 42.6954 -1.6761 2021-03-02 05:23:30 Navarra, Spain
801588 2021-03-01 Spain Pais Vasco     151509 3731 16160 131618 42.9896 -2.6189 2021-03-02 05:23:30 Pais Vasco, Spain
801589 2021-03-01 Spain Unknown     0 0 0 0     2021-03-02 05:23:30 Unknown, Spain
1066712 2021-02-28 Spain Andalusia     476822 8328 10671 457823 37.5443 -4.7278 2021-03-01 05:23:01 Andalusia, Spain
1066713 2021-02-28 Spain Aragon     106480 3258 3772 99450 41.5976 -0.9057 2021-03-01 05:23:01 Aragon, Spain
1066714 2021-02-28 Spain Asturias     43179 1750 1063 40366 43.3614 -5.8593 2021-03-01 05:23:01 Asturias, Spain
1066715 2021-02-28 Spain Baleares     55991 707 1533 53751 39.710358 2.995148 2021-03-01 05:23:01 Baleares, Spain
1066716 2021-02-28 Spain C. Valenciana     377866 6632 9970 361264 39.484 -0.7533 2021-03-01 05:23:01 C. Valenciana, Spain
1066717 2021-02-28 Spain Canarias     40477 589 1537 38351 28.2916 -16.6291 2021-03-01 05:23:01 Canarias, Spain
1066718 2021-02-28 Spain Cantabria     24574 508 2287 21779 43.1828 -3.9878 2021-03-01 05:23:01 Cantabria, Spain
1066719 2021-02-28 Spain Castilla - La Mancha     168561 5588 6392 156581 39.2796 -3.0977 2021-03-01 05:23:01 Castilla - La Mancha, Spain
1066720 2021-02-28 Spain Castilla y Leon     205587 6320 8716 190551 41.8357 -4.3976 2021-03-01 05:23:01 Castilla y Leon, Spain
1066721 2021-02-28 Spain Catalonia     577701 10575 26203 540923 41.5912 1.5209 2021-03-01 05:23:01 Catalonia, Spain
1066722 2021-02-28 Spain Ceuta     4562 81 163 4318 35.8894 -5.3213 2021-03-01 05:23:01 Ceuta, Spain
1066723 2021-02-28 Spain Extremadura     68952 1706 2652 64594 39.4937 -6.0679 2021-03-01 05:23:01 Extremadura, Spain
1066724 2021-02-28 Spain Galicia     111461 2194 9204 100063 42.5751 -8.1339 2021-03-01 05:23:01 Galicia, Spain
1066725 2021-02-28 Spain La Rioja     27422 725 3107 23590 42.2871 -2.5396 2021-03-01 05:23:01 La Rioja, Spain
1066726 2021-02-28 Spain Madrid     583862 13842 40736 529284 40.4168 -3.7038 2021-03-01 05:23:01 Madrid, Spain
1066727 2021-02-28 Spain Melilla     6938 70 125 6743 35.2923 -2.9381 2021-03-01 05:23:01 Melilla, Spain
1066728 2021-02-28 Spain Murcia     106200 1451 2180 102569 37.9922 -1.1307 2021-03-01 05:23:01 Murcia, Spain
1066729 2021-02-28 Spain Navarra     51244 1092 3905 46247 42.6954 -1.6761 2021-03-01 05:23:01 Navarra, Spain
1066730 2021-02-28 Spain Pais Vasco     150674 3726 16160 130788 42.9896 -2.6189 2021-03-01 05:23:01 Pais Vasco, Spain
1066731 2021-02-28 Spain Unknown     0 0 0 0     2021-03-01 05:23:01 Unknown, Spain
745105 2021-02-27 Spain Andalusia     476822 8328 10671 457823 37.5443 -4.7278 2021-02-28 05:22:20 Andalusia, Spain
745106 2021-02-27 Spain Aragon     106480 3258 3772 99450 41.5976 -0.9057 2021-02-28 05:22:20 Aragon, Spain
745107 2021-02-27 Spain Asturias     43179 1750 1063 40366 43.3614 -5.8593 2021-02-28 05:22:20 Asturias, Spain
745108 2021-02-27 Spain Baleares     55991 707 1533 53751 39.710358 2.995148 2021-02-28 05:22:20 Baleares, Spain
745109 2021-02-27 Spain C. Valenciana     377866 6632 9970 361264 39.484 -0.7533 2021-02-28 05:22:20 C. Valenciana, Spain
745110 2021-02-27 Spain Canarias     40477 589 1537 38351 28.2916 -16.6291 2021-02-28 05:22:20 Canarias, Spain
745111 2021-02-27 Spain Cantabria     24574 508 2287 21779 43.1828 -3.9878 2021-02-28 05:22:20 Cantabria, Spain
745112 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
745113 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
745114 2021-02-27 Spain Catalonia     577701 10575 26203 540923 41.5912 1.5209 2021-02-28 05:22:20 Catalonia, Spain
745115 2021-02-27 Spain Ceuta     4562 81 163 4318 35.8894 -5.3213 2021-02-28 05:22:20 Ceuta, Spain
745116 2021-02-27 Spain Extremadura     68952 1706 2652 64594 39.4937 -6.0679 2021-02-28 05:22:20 Extremadura, Spain
745117 2021-02-27 Spain Galicia     111461 2194 9204 100063 42.5751 -8.1339 2021-02-28 05:22:20 Galicia, Spain
745118 2021-02-27 Spain La Rioja     27422 725 3107 23590 42.2871 -2.5396 2021-02-28 05:22:20 La Rioja, Spain
745119 2021-02-27 Spain Madrid     583862 13842 40736 529284 40.4168 -3.7038 2021-02-28 05:22:20 Madrid, Spain
745120 2021-02-27 Spain Melilla     6938 70 125 6743 35.2923 -2.9381 2021-02-28 05:22:20 Melilla, Spain
745121 2021-02-27 Spain Murcia     106200 1451 2180 102569 37.9922 -1.1307 2021-02-28 05:22:20 Murcia, Spain
745122 2021-02-27 Spain Navarra     51244 1092 3905 46247 42.6954 -1.6761 2021-02-28 05:22:20 Navarra, Spain
745123 2021-02-27 Spain Pais Vasco     150674 3726 16160 130788 42.9896 -2.6189 2021-02-28 05:22:20 Pais Vasco, Spain
745124 2021-02-27 Spain Unknown     0 0 0 0     2021-02-28 05:22:20 Unknown, Spain
951249 2021-02-26 Spain Andalusia     476822 8328 10671 457823 37.5443 -4.7278 2021-02-27 05:22:28 Andalusia, Spain
951250 2021-02-26 Spain Aragon     106480 3258 3772 99450 41.5976 -0.9057 2021-02-27 05:22:28 Aragon, Spain
951251 2021-02-26 Spain Asturias     43179 1750 1063 40366 43.3614 -5.8593 2021-02-27 05:22:28 Asturias, Spain
951252 2021-02-26 Spain Baleares     55991 707 1533 53751 39.710358 2.995148 2021-02-27 05:22:28 Baleares, Spain
951253 2021-02-26 Spain C. Valenciana     377866 6632 9970 361264 39.484 -0.7533 2021-02-27 05:22:28 C. Valenciana, Spain
951254 2021-02-26 Spain Canarias     40477 589 1537 38351 28.2916 -16.6291 2021-02-27 05:22:28 Canarias, Spain
951255 2021-02-26 Spain Cantabria     24574 508 2287 21779 43.1828 -3.9878 2021-02-27 05:22:28 Cantabria, Spain
951256 2021-02-26 Spain Castilla - La Mancha     168561 5588 6392 156581 39.2796 -3.0977 2021-02-27 05:22:28 Castilla - La Mancha, Spain
951257 2021-02-26 Spain Castilla y Leon     205587 6320 8716 190551 41.8357 -4.3976 2021-02-27 05:22:28 Castilla y Leon, Spain
951258 2021-02-26 Spain Catalonia     577701 10575 26203 540923 41.5912 1.5209 2021-02-27 05:22:28 Catalonia, Spain
951259 2021-02-26 Spain Ceuta     4562 81 163 4318 35.8894 -5.3213 2021-02-27 05:22:28 Ceuta, Spain
951260 2021-02-26 Spain Extremadura     68952 1706 2652 64594 39.4937 -6.0679 2021-02-27 05:22:28 Extremadura, Spain
951261 2021-02-26 Spain Galicia     111461 2194 9204 100063 42.5751 -8.1339 2021-02-27 05:22:28 Galicia, Spain
951262 2021-02-26 Spain La Rioja     27422 725 3107 23590 42.2871 -2.5396 2021-02-27 05:22:28 La Rioja, Spain
951263 2021-02-26 Spain Madrid     583862 13842 40736 529284 40.4168 -3.7038 2021-02-27 05:22:28 Madrid, Spain
951264 2021-02-26 Spain Melilla     6938 70 125 6743 35.2923 -2.9381 2021-02-27 05:22:28 Melilla, Spain
951265 2021-02-26 Spain Murcia     106200 1451 2180 102569 37.9922 -1.1307 2021-02-27 05:22:28 Murcia, Spain
951266 2021-02-26 Spain Navarra     51244 1092 3905 46247 42.6954 -1.6761 2021-02-27 05:22:28 Navarra, Spain
951267 2021-02-26 Spain Pais Vasco     150674 3726 16160 130788 42.9896 -2.6189 2021-02-27 05:22:28 Pais Vasco, Spain
951268 2021-02-26 Spain Unknown     0 0 0 0     2021-02-27 05:22:28 Unknown, Spain
1280205 2021-02-25 Spain Andalusia     475599 8293 10671 456635 37.5443 -4.7278 2021-02-26 05:22:40 Andalusia, Spain
1280206 2021-02-25 Spain Aragon     106279 3241 3772 99266 41.5976 -0.9057 2021-02-26 05:22:40 Aragon, Spain
1280207 2021-02-25 Spain Asturias     43027 1741 1063 40223 43.3614 -5.8593 2021-02-26 05:22:40 Asturias, Spain
1280208 2021-02-25 Spain Baleares     55934 700 1533 53701 39.710358 2.995148 2021-02-26 05:22:40 Baleares, Spain
1280209 2021-02-25 Spain C. Valenciana     377330 6551 9970 360809 39.484 -0.7533 2021-02-26 05:22:40 C. Valenciana, Spain
1280210 2021-02-25 Spain Canarias     40268 588 1537 38143 28.2916 -16.6291 2021-02-26 05:22:40 Canarias, Spain
1280211 2021-02-25 Spain Cantabria     24530 506 2287 21737 43.1828 -3.9878 2021-02-26 05:22:40 Cantabria, Spain
1280212 2021-02-25 Spain Castilla - La Mancha     168167 5580 6392 156195 39.2796 -3.0977 2021-02-26 05:22:40 Castilla - La Mancha, Spain
1280213 2021-02-25 Spain Castilla y Leon     205296 6303 8716 190277 41.8357 -4.3976 2021-02-26 05:22:40 Castilla y Leon, Spain
1280214 2021-02-25 Spain Catalonia     574949 10494 26203 538252 41.5912 1.5209 2021-02-26 05:22:40 Catalonia, Spain
1280215 2021-02-25 Spain Ceuta     4548 81 163 4304 35.8894 -5.3213 2021-02-26 05:22:40 Ceuta, Spain
1280216 2021-02-25 Spain Extremadura     68925 1703 2652 64570 39.4937 -6.0679 2021-02-26 05:22:40 Extremadura, Spain
1280217 2021-02-25 Spain Galicia     111196 2188 9204 99804 42.5751 -8.1339 2021-02-26 05:22:40 Galicia, Spain
1280218 2021-02-25 Spain La Rioja     27404 724 3107 23573 42.2871 -2.5396 2021-02-26 05:22:40 La Rioja, Spain
1280219 2021-02-25 Spain Madrid     582299 13793 40736 527770 40.4168 -3.7038 2021-02-26 05:22:40 Madrid, Spain
1280220 2021-02-25 Spain Melilla     6920 68 125 6727 35.2923 -2.9381 2021-02-26 05:22:40 Melilla, Spain
1280221 2021-02-25 Spain Murcia     106054 1447 2180 102427 37.9922 -1.1307 2021-02-26 05:22:40 Murcia, Spain
1280222 2021-02-25 Spain Navarra     51188 1091 3905 46192 42.6954 -1.6761 2021-02-26 05:22:40 Navarra, Spain
1280223 2021-02-25 Spain Pais Vasco     150299 3721 16160 130418 42.9896 -2.6189 2021-02-26 05:22:40 Pais Vasco, Spain
1280224 2021-02-25 Spain Unknown     0 0 0 0     2021-02-26 05:22:40 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] 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]);