⚠️ 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,178 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,178
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
89964 2021-01-22 Spain Andalusia     348842 5770 10671 332401 37.5443 -4.7278 2021-01-23 05:22:03 Andalusia, Spain
89965 2021-01-22 Spain Aragon     91963 2824 3772 85367 41.5976 -0.9057 2021-01-23 05:22:03 Aragon, Spain
89966 2021-01-22 Spain Asturias     32402 1445 1063 29894 43.3614 -5.8593 2021-01-23 05:22:03 Asturias, Spain
89967 2021-01-22 Spain Baleares     47984 544 1533 45907 39.710358 2.995148 2021-01-23 05:22:03 Baleares, Spain
89968 2021-01-22 Spain C. Valenciana     245280 4016 9970 231294 39.484 -0.7533 2021-01-23 05:22:03 C. Valenciana, Spain
89969 2021-01-22 Spain Canarias     32971 494 1537 30940 28.2916 -16.6291 2021-01-23 05:22:03 Canarias, Spain
89970 2021-01-22 Spain Cantabria     21127 436 2287 18404 43.1828 -3.9878 2021-01-23 05:22:03 Cantabria, Spain
89971 2021-01-22 Spain Castilla - La Mancha     134196 4288 6392 123516 39.2796 -3.0977 2021-01-23 05:22:03 Castilla - La Mancha, Spain
89972 2021-01-22 Spain Castilla y Leon     167444 5440 8716 153288 41.8357 -4.3976 2021-01-23 05:22:03 Castilla y Leon, Spain
89973 2021-01-22 Spain Catalonia     461871 9236 26203 426432 41.5912 1.5209 2021-01-23 05:22:03 Catalonia, Spain
89974 2021-01-22 Spain Ceuta     3658 67 163 3428 35.8894 -5.3213 2021-01-23 05:22:03 Ceuta, Spain
89975 2021-01-22 Spain Extremadura     58917 1291 2652 54974 39.4937 -6.0679 2021-01-23 05:22:03 Extremadura, Spain
89976 2021-01-22 Spain Galicia     82542 1580 9204 71758 42.5751 -8.1339 2021-01-23 05:22:03 Galicia, Spain
89977 2021-01-22 Spain La Rioja     23166 618 3107 19441 42.2871 -2.5396 2021-01-23 05:22:03 La Rioja, Spain
89978 2021-01-22 Spain Madrid     483391 12266 40736 430389 40.4168 -3.7038 2021-01-23 05:22:03 Madrid, Spain
89979 2021-01-22 Spain Melilla     5496 49 125 5322 35.2923 -2.9381 2021-01-23 05:22:03 Melilla, Spain
89980 2021-01-22 Spain Murcia     86468 883 2180 83405 37.9922 -1.1307 2021-01-23 05:22:03 Murcia, Spain
89981 2021-01-22 Spain Navarra     46481 995 3905 41581 42.6954 -1.6761 2021-01-23 05:22:03 Navarra, Spain
89982 2021-01-22 Spain Pais Vasco     125361 3199 16160 106002 42.9896 -2.6189 2021-01-23 05:22:03 Pais Vasco, Spain
89983 2021-01-22 Spain Unknown     0 0 0 0     2021-01-23 05:22:03 Unknown, Spain
302870 2021-01-21 Spain Andalusia     340991 5720 10671 324600 37.5443 -4.7278 2021-01-22 05:22:10 Andalusia, Spain
302871 2021-01-21 Spain Aragon     91191 2808 3772 84611 41.5976 -0.9057 2021-01-22 05:22:10 Aragon, Spain
302872 2021-01-21 Spain Asturias     31895 1434 1063 29398 43.3614 -5.8593 2021-01-22 05:22:10 Asturias, Spain
302873 2021-01-21 Spain Baleares     47359 538 1533 45288 39.710358 2.995148 2021-01-22 05:22:10 Baleares, Spain
302874 2021-01-21 Spain C. Valenciana     236657 3914 9970 222773 39.484 -0.7533 2021-01-22 05:22:10 C. Valenciana, Spain
302875 2021-01-21 Spain Canarias     32638 493 1537 30608 28.2916 -16.6291 2021-01-22 05:22:10 Canarias, Spain
302876 2021-01-21 Spain Cantabria     20930 418 2287 18225 43.1828 -3.9878 2021-01-22 05:22:10 Cantabria, Spain
302877 2021-01-21 Spain Castilla - La Mancha     132362 4256 6392 121714 39.2796 -3.0977 2021-01-22 05:22:10 Castilla - La Mancha, Spain
302878 2021-01-21 Spain Castilla y Leon     164560 5419 8716 150425 41.8357 -4.3976 2021-01-22 05:22:10 Castilla y Leon, Spain
302879 2021-01-21 Spain Catalonia     456108 9185 26203 420720 41.5912 1.5209 2021-01-22 05:22:10 Catalonia, Spain
302880 2021-01-21 Spain Ceuta     3617 67 163 3387 35.8894 -5.3213 2021-01-22 05:22:10 Ceuta, Spain
302881 2021-01-21 Spain Extremadura     57858 1271 2652 53935 39.4937 -6.0679 2021-01-22 05:22:10 Extremadura, Spain
302882 2021-01-21 Spain Galicia     80627 1585 9204 69838 42.5751 -8.1339 2021-01-22 05:22:10 Galicia, Spain
302883 2021-01-21 Spain La Rioja     22748 614 3107 19027 42.2871 -2.5396 2021-01-22 05:22:10 La Rioja, Spain
302884 2021-01-21 Spain Madrid     477031 12210 40736 424085 40.4168 -3.7038 2021-01-22 05:22:10 Madrid, Spain
302885 2021-01-21 Spain Melilla     5407 49 125 5233 35.2923 -2.9381 2021-01-22 05:22:10 Melilla, Spain
302886 2021-01-21 Spain Murcia     84318 872 2180 81266 37.9922 -1.1307 2021-01-22 05:22:10 Murcia, Spain
302887 2021-01-21 Spain Navarra     46152 994 3905 41253 42.6954 -1.6761 2021-01-22 05:22:10 Navarra, Spain
302888 2021-01-21 Spain Pais Vasco     124226 3194 16160 104872 42.9896 -2.6189 2021-01-22 05:22:10 Pais Vasco, Spain
302889 2021-01-21 Spain Unknown     0 0 0 0     2021-01-22 05:22:10 Unknown, Spain
893921 2021-01-20 Spain Andalusia     333442 5664 10671 317107 37.5443 -4.7278 2021-01-21 05:22:01 Andalusia, Spain
893922 2021-01-20 Spain Aragon     90406 2795 3772 83839 41.5976 -0.9057 2021-01-21 05:22:01 Aragon, Spain
893923 2021-01-20 Spain Asturias     31453 1424 1063 28966 43.3614 -5.8593 2021-01-21 05:22:01 Asturias, Spain
893924 2021-01-20 Spain Baleares     46721 538 1533 44650 39.710358 2.995148 2021-01-21 05:22:01 Baleares, Spain
893925 2021-01-20 Spain C. Valenciana     228205 3803 9970 214432 39.484 -0.7533 2021-01-21 05:22:01 C. Valenciana, Spain
893926 2021-01-20 Spain Canarias     32309 490 1537 30282 28.2916 -16.6291 2021-01-21 05:22:01 Canarias, Spain
893927 2021-01-20 Spain Cantabria     20724 417 2287 18020 43.1828 -3.9878 2021-01-21 05:22:01 Cantabria, Spain
893928 2021-01-20 Spain Castilla - La Mancha     129591 4223 6392 118976 39.2796 -3.0977 2021-01-21 05:22:01 Castilla - La Mancha, Spain
893929 2021-01-20 Spain Castilla y Leon     161590 5408 8716 147466 41.8357 -4.3976 2021-01-21 05:22:01 Castilla y Leon, Spain
893930 2021-01-20 Spain Catalonia     450191 9159 26203 414829 41.5912 1.5209 2021-01-21 05:22:01 Catalonia, Spain
893931 2021-01-20 Spain Ceuta     3560 67 163 3330 35.8894 -5.3213 2021-01-21 05:22:01 Ceuta, Spain
893932 2021-01-20 Spain Extremadura     56724 1250 2652 52822 39.4937 -6.0679 2021-01-21 05:22:01 Extremadura, Spain
893933 2021-01-20 Spain Galicia     78676 1562 9204 67910 42.5751 -8.1339 2021-01-21 05:22:01 Galicia, Spain
893934 2021-01-20 Spain La Rioja     22347 614 3107 18626 42.2871 -2.5396 2021-01-21 05:22:01 La Rioja, Spain
893935 2021-01-20 Spain Madrid     469934 12149 40736 417049 40.4168 -3.7038 2021-01-21 05:22:01 Madrid, Spain
893936 2021-01-20 Spain Melilla     5319 49 125 5145 35.2923 -2.9381 2021-01-21 05:22:01 Melilla, Spain
893937 2021-01-20 Spain Murcia     82243 852 2180 79211 37.9922 -1.1307 2021-01-21 05:22:01 Murcia, Spain
893938 2021-01-20 Spain Navarra     45909 993 3905 41011 42.6954 -1.6761 2021-01-21 05:22:01 Navarra, Spain
893939 2021-01-20 Spain Pais Vasco     122974 3180 16160 103634 42.9896 -2.6189 2021-01-21 05:22:01 Pais Vasco, Spain
893940 2021-01-20 Spain Unknown     0 0 0 0     2021-01-21 05:22:01 Unknown, Spain
322488 2021-01-19 Spain Andalusia     327415 5600 10671 311144 37.5443 -4.7278 2021-01-20 05:21:54 Andalusia, Spain
322489 2021-01-19 Spain Aragon     89570 2782 3772 83016 41.5976 -0.9057 2021-01-20 05:21:54 Aragon, Spain
322490 2021-01-19 Spain Asturias     31083 1417 1063 28603 43.3614 -5.8593 2021-01-20 05:21:54 Asturias, Spain
322491 2021-01-19 Spain Baleares     46110 528 1533 44049 39.710358 2.995148 2021-01-20 05:21:54 Baleares, Spain
322492 2021-01-19 Spain C. Valenciana     218400 3679 9970 204751 39.484 -0.7533 2021-01-20 05:21:54 C. Valenciana, Spain
322493 2021-01-19 Spain Canarias     32010 484 1537 29989 28.2916 -16.6291 2021-01-20 05:21:54 Canarias, Spain
322494 2021-01-19 Spain Cantabria     20520 417 2287 17816 43.1828 -3.9878 2021-01-20 05:21:54 Cantabria, Spain
322495 2021-01-19 Spain Castilla - La Mancha     127541 4210 6392 116939 39.2796 -3.0977 2021-01-20 05:21:54 Castilla - La Mancha, Spain
322496 2021-01-19 Spain Castilla y Leon     158607 5399 8716 144492 41.8357 -4.3976 2021-01-20 05:21:54 Castilla y Leon, Spain
322497 2021-01-19 Spain Catalonia     444330 9119 26203 409008 41.5912 1.5209 2021-01-20 05:21:54 Catalonia, Spain
322498 2021-01-19 Spain Ceuta     3522 66 163 3293 35.8894 -5.3213 2021-01-20 05:21:54 Ceuta, Spain
322499 2021-01-19 Spain Extremadura     55480 1227 2652 51601 39.4937 -6.0679 2021-01-20 05:21:54 Extremadura, Spain
322500 2021-01-19 Spain Galicia     77232 1536 9204 66492 42.5751 -8.1339 2021-01-20 05:21:54 Galicia, Spain
322501 2021-01-19 Spain La Rioja     21936 612 3107 18217 42.2871 -2.5396 2021-01-20 05:21:54 La Rioja, Spain
322502 2021-01-19 Spain Madrid     463716 12100 40736 410880 40.4168 -3.7038 2021-01-20 05:21:54 Madrid, Spain
322503 2021-01-19 Spain Melilla     5235 49 125 5061 35.2923 -2.9381 2021-01-20 05:21:54 Melilla, Spain
322504 2021-01-19 Spain Murcia     80242 839 2180 77223 37.9922 -1.1307 2021-01-20 05:21:54 Murcia, Spain
322505 2021-01-19 Spain Navarra     45701 992 3905 40804 42.6954 -1.6761 2021-01-20 05:21:54 Navarra, Spain
322506 2021-01-19 Spain Pais Vasco     122092 3117 16160 102815 42.9896 -2.6189 2021-01-20 05:21:54 Pais Vasco, Spain
322507 2021-01-19 Spain Unknown     0 0 0 0     2021-01-20 05:21:54 Unknown, Spain
574474 2021-01-18 Spain Andalusia     323655 5532 10671 307452 37.5443 -4.7278 2021-01-19 05:22:15 Andalusia, Spain
574475 2021-01-18 Spain Aragon     89041 2772 3772 82497 41.5976 -0.9057 2021-01-19 05:22:15 Aragon, Spain
574476 2021-01-18 Spain Asturias     30804 1409 1063 28332 43.3614 -5.8593 2021-01-19 05:22:15 Asturias, Spain
574477 2021-01-18 Spain Baleares     45533 518 1533 43482 39.710358 2.995148 2021-01-19 05:22:15 Baleares, Spain
574478 2021-01-18 Spain C. Valenciana     210451 3609 9970 196872 39.484 -0.7533 2021-01-19 05:22:15 C. Valenciana, Spain
574479 2021-01-18 Spain Canarias     31699 476 1537 29686 28.2916 -16.6291 2021-01-19 05:22:15 Canarias, Spain
574480 2021-01-18 Spain Cantabria     20401 415 2287 17699 43.1828 -3.9878 2021-01-19 05:22:15 Cantabria, Spain
574481 2021-01-18 Spain Castilla - La Mancha     125393 4208 6392 114793 39.2796 -3.0977 2021-01-19 05:22:15 Castilla - La Mancha, Spain
574482 2021-01-18 Spain Castilla y Leon     156306 5369 8716 142221 41.8357 -4.3976 2021-01-19 05:22:15 Castilla y Leon, Spain
574483 2021-01-18 Spain Catalonia     439154 9048 26203 403903 41.5912 1.5209 2021-01-19 05:22:15 Catalonia, Spain
574484 2021-01-18 Spain Ceuta     3491 66 163 3262 35.8894 -5.3213 2021-01-19 05:22:15 Ceuta, Spain
574485 2021-01-18 Spain Extremadura     54396 1217 2652 50527 39.4937 -6.0679 2021-01-19 05:22:15 Extremadura, Spain
574486 2021-01-18 Spain Galicia     75936 1505 9204 65227 42.5751 -8.1339 2021-01-19 05:22:15 Galicia, Spain
574487 2021-01-18 Spain La Rioja     21706 611 3107 17988 42.2871 -2.5396 2021-01-19 05:22:15 La Rioja, Spain
574488 2021-01-18 Spain Madrid     458212 12054 40736 405422 40.4168 -3.7038 2021-01-19 05:22:15 Madrid, Spain
574489 2021-01-18 Spain Melilla     5170 49 125 4996 35.2923 -2.9381 2021-01-19 05:22:15 Melilla, Spain
574490 2021-01-18 Spain Murcia     78456 824 2180 75452 37.9922 -1.1307 2021-01-19 05:22:15 Murcia, Spain
574491 2021-01-18 Spain Navarra     45431 991 3905 40535 42.6954 -1.6761 2021-01-19 05:22:15 Navarra, Spain
574492 2021-01-18 Spain Pais Vasco     121216 3096 16160 101960 42.9896 -2.6189 2021-01-19 05:22:15 Pais Vasco, Spain
574493 2021-01-18 Spain Unknown     0 0 0 0     2021-01-19 05:22:15 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]);