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

View and edit SQL

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

country_or_region

  • Spain · 8,138
Link rowid ▼ day country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
579 2020-09-15 Spain Andalusia     43678 1614 10671 31393 37.5443 -4.7278 2020-09-16 04:22:53 Andalusia, Spain
580 2020-09-15 Spain Aragon     31172 1212 3772 26188 41.5976 -0.9057 2020-09-16 04:22:53 Aragon, Spain
581 2020-09-15 Spain Asturias     4095 340 1063 2692 43.3614 -5.8593 2020-09-16 04:22:53 Asturias, Spain
582 2020-09-15 Spain Baleares     11278 264 1533 9481 39.710358 2.995148 2020-09-16 04:22:53 Baleares, Spain
583 2020-09-15 Spain C. Valenciana     32603 1521 9970 21112 39.484 -0.7533 2020-09-16 04:22:53 C. Valenciana, Spain
584 2020-09-15 Spain Canarias     10969 200 1537 9232 28.2916 -16.6291 2020-09-16 04:22:53 Canarias, Spain
585 2020-09-15 Spain Cantabria     5798 227 2287 3284 43.1828 -3.9878 2020-09-16 04:22:53 Cantabria, Spain
586 2020-09-15 Spain Castilla - La Mancha     32260 3058 6392 22810 39.2796 -3.0977 2020-09-16 04:22:53 Castilla - La Mancha, Spain
587 2020-09-15 Spain Castilla y Leon     36832 2912 8716 25204 41.8357 -4.3976 2020-09-16 04:22:53 Castilla y Leon, Spain
588 2020-09-15 Spain Catalonia     123393 5780 26203 91410 41.5912 1.5209 2020-09-16 04:22:53 Catalonia, Spain
589 2020-09-15 Spain Ceuta     416 8 163 245 35.8894 -5.3213 2020-09-16 04:22:53 Ceuta, Spain
590 2020-09-15 Spain Extremadura     7260 538 2652 4070 39.4937 -6.0679 2020-09-16 04:22:53 Extremadura, Spain
591 2020-09-15 Spain Galicia     18077 692 9204 8181 42.5751 -8.1339 2020-09-16 04:22:53 Galicia, Spain
592 2020-09-15 Spain La Rioja     6978 387 3107 3484 42.2871 -2.5396 2020-09-16 04:22:53 La Rioja, Spain
593 2020-09-15 Spain Madrid     174680 8925 40736 125019 40.4168 -3.7038 2020-09-16 04:22:53 Madrid, Spain
594 2020-09-15 Spain Melilla     655 4 125 526 35.2923 -2.9381 2020-09-16 04:22:53 Melilla, Spain
595 2020-09-15 Spain Murcia     11733 178 2180 9375 37.9922 -1.1307 2020-09-16 04:22:53 Murcia, Spain
596 2020-09-15 Spain Navarra     13407 548 3905 8954 42.6954 -1.6761 2020-09-16 04:22:53 Navarra, Spain
597 2020-09-15 Spain Pais Vasco     37883 1596 16160 20127 42.9896 -2.6189 2020-09-16 04:22:53 Pais Vasco, Spain
598 2020-09-15 Spain Unknown     0 0 0 0     2020-09-16 04:22:53 Unknown, Spain
4557 2020-12-05 Spain Andalusia     238783 4296 10671 223816 37.5443 -4.7278 2020-12-06 05:26:18 Andalusia, Spain
4558 2020-12-05 Spain Aragon     74534 2360 3772 68402 41.5976 -0.9057 2020-12-06 05:26:18 Aragon, Spain
4559 2020-12-05 Spain Asturias     24175 1073 1063 22039 43.3614 -5.8593 2020-12-06 05:26:18 Asturias, Spain
4560 2020-12-05 Spain Baleares     25288 425 1533 23330 39.710358 2.995148 2020-12-06 05:26:18 Baleares, Spain
4561 2020-12-05 Spain C. Valenciana     108586 2444 9970 96172 39.484 -0.7533 2020-12-06 05:26:18 C. Valenciana, Spain
4562 2020-12-05 Spain Canarias     21753 346 1537 19870 28.2916 -16.6291 2020-12-06 05:26:18 Canarias, Spain
4563 2020-12-05 Spain Cantabria     15903 324 2287 13292 43.1828 -3.9878 2020-12-06 05:26:18 Cantabria, Spain
4564 2020-12-05 Spain Castilla - La Mancha     87956 3825 6392 77739 39.2796 -3.0977 2020-12-06 05:26:18 Castilla - La Mancha, Spain
4565 2020-12-05 Spain Castilla y Leon     123433 4647 8716 110070 41.8357 -4.3976 2020-12-06 05:26:18 Castilla y Leon, Spain
4566 2020-12-05 Spain Catalonia     310141 8126 26203 275812 41.5912 1.5209 2020-12-06 05:26:18 Catalonia, Spain
4567 2020-12-05 Spain Ceuta     2854 55 163 2636 35.8894 -5.3213 2020-12-06 05:26:18 Ceuta, Spain
4568 2020-12-05 Spain Extremadura     29461 971 2652 25838 39.4937 -6.0679 2020-12-06 05:26:18 Extremadura, Spain
4569 2020-12-05 Spain Galicia     51557 1246 9204 41107 42.5751 -8.1339 2020-12-06 05:26:18 Galicia, Spain
4570 2020-12-05 Spain La Rioja     16881 561 3107 13213 42.2871 -2.5396 2020-12-06 05:26:18 La Rioja, Spain
4571 2020-12-05 Spain Madrid     354326 11426 40736 302164 40.4168 -3.7038 2020-12-06 05:26:18 Madrid, Spain
4572 2020-12-05 Spain Melilla     4152 43 125 3984 35.2923 -2.9381 2020-12-06 05:26:18 Melilla, Spain
4573 2020-12-05 Spain Murcia     55116 623 2180 52313 37.9922 -1.1307 2020-12-06 05:26:18 Murcia, Spain
4574 2020-12-05 Spain Navarra     40032 893 3905 35234 42.6954 -1.6761 2020-12-06 05:26:18 Navarra, Spain
4575 2020-12-05 Spain Pais Vasco     99716 2568 16160 80988 42.9896 -2.6189 2020-12-06 05:26:18 Pais Vasco, Spain
4576 2020-12-05 Spain Unknown     0 0 0 0     2020-12-06 05:26:18 Unknown, Spain
11004 2020-06-09 Spain Andalusia     12791 1404 10671 716 37.5443 -4.7278 2020-06-10 04:07:00 Andalusia, Spain
11011 2020-06-09 Spain Aragon     5792 826 3772 1194 41.5976 -0.9057 2020-06-10 04:07:00 Aragon, Spain
11019 2020-06-09 Spain Asturias     2430 314 1063 1053 43.3614 -5.8593 2020-06-10 04:07:00 Asturias, Spain
11029 2020-06-09 Spain Baleares     2135 209 1533 393 39.710358 2.995148 2020-06-10 04:07:00 Baleares, Spain
11048 2020-06-09 Spain C. Valenciana     11342 1332 9970 40 39.484 -0.7533 2020-06-10 04:07:00 C. Valenciana, Spain
11055 2020-06-09 Spain Canarias     2372 151 1537 684 28.2916 -16.6291 2020-06-10 04:07:00 Canarias, Spain
11056 2020-06-09 Spain Cantabria     2324 202 2287 -165 43.1828 -3.9878 2020-06-10 04:07:00 Cantabria, Spain
11060 2020-06-09 Spain Castilla - La Mancha     17609 2945 6392 8272 39.2796 -3.0977 2020-06-10 04:07:00 Castilla - La Mancha, Spain
11061 2020-06-09 Spain Castilla y Leon     19193 1928 8716 8549 41.8357 -4.3976 2020-06-10 04:07:00 Castilla y Leon, Spain
11062 2020-06-09 Spain Catalonia     59232 5587 26203 27442 41.5912 1.5209 2020-06-10 04:07:00 Catalonia, Spain
11067 2020-06-09 Spain Ceuta     163 4 163 -4 35.8894 -5.3213 2020-06-10 04:07:00 Ceuta, Spain
11101 2020-06-09 Spain Extremadura     2978 508 2652 -182 39.4937 -6.0679 2020-06-10 04:07:00 Extremadura, Spain
11111 2020-06-09 Spain Galicia     9148 609 9204 -665 42.5751 -8.1339 2020-06-10 04:07:00 Galicia, Spain
11199 2020-06-09 Spain La Rioja     4062 362 3107 593 42.2871 -2.5396 2020-06-10 04:07:00 La Rioja, Spain
11215 2020-06-09 Spain Madrid     69804 8691 40736 20377 40.4168 -3.7038 2020-06-10 04:07:00 Madrid, Spain
11229 2020-06-09 Spain Melilla     122 2 125 -5 35.2923 -2.9381 2020-06-10 04:07:00 Melilla, Spain
11245 2020-06-09 Spain Murcia     1619 148 2180 -709 37.9922 -1.1307 2020-06-10 04:07:00 Murcia, Spain
11252 2020-06-09 Spain Navarra     5295 490 3905 900 42.6954 -1.6761 2020-06-10 04:07:00 Navarra, Spain
11291 2020-06-09 Spain Pais Vasco     13555 1424 16160 -4029 42.9896 -2.6189 2020-06-10 04:07:00 Pais Vasco, Spain
11412 2020-06-09 Spain Unknown     0 0 0 0     2020-06-10 04:07:00 Unknown, Spain
12226 2021-04-28 Spain Andalusia     548238 9612 10671 527955 37.5443 -4.7278 2021-04-29 04:20:55 Andalusia, Spain
12227 2021-04-28 Spain Aragon     117618 3437 3772 110409 41.5976 -0.9057 2021-04-29 04:20:55 Aragon, Spain
12228 2021-04-28 Spain Asturias     50518 1943 1063 47512 43.3614 -5.8593 2021-04-29 04:20:55 Asturias, Spain
12229 2021-04-28 Spain Baleares     59139 819 1533 56787 39.710358 2.995148 2021-04-29 04:20:55 Baleares, Spain
12230 2021-04-28 Spain C. Valenciana     390245 7285 9970 372990 39.484 -0.7533 2021-04-29 04:20:55 C. Valenciana, Spain
12231 2021-04-28 Spain Canarias     52332 727 1537 50068 28.2916 -16.6291 2021-04-29 04:20:55 Canarias, Spain
12232 2021-04-28 Spain Cantabria     28529 556 2287 25686 43.1828 -3.9878 2021-04-29 04:20:55 Cantabria, Spain
12233 2021-04-28 Spain Castilla - La Mancha     184520 5845 6392 172283 39.2796 -3.0977 2021-04-29 04:20:55 Castilla - La Mancha, Spain
12234 2021-04-28 Spain Castilla y Leon     222354 6750 8716 206888 41.8357 -4.3976 2021-04-29 04:20:55 Castilla y Leon, Spain
12235 2021-04-28 Spain Catalonia     580682 14019 26203 540460 41.5912 1.5209 2021-04-29 04:20:55 Catalonia, Spain
12236 2021-04-28 Spain Ceuta     5746 104 163 5479 35.8894 -5.3213 2021-04-29 04:20:55 Ceuta, Spain
12237 2021-04-28 Spain Extremadura     73776 1788 2652 69336 39.4937 -6.0679 2021-04-29 04:20:55 Extremadura, Spain
12238 2021-04-28 Spain Galicia     121549 2372 9204 109973 42.5751 -8.1339 2021-04-29 04:20:55 Galicia, Spain
12239 2021-04-28 Spain La Rioja     29485 757 3107 25621 42.2871 -2.5396 2021-04-29 04:20:55 La Rioja, Spain
12240 2021-04-28 Spain Madrid     678022 14969 40736 622317 40.4168 -3.7038 2021-04-29 04:20:55 Madrid, Spain
12241 2021-04-28 Spain Melilla     8677 89 125 8463 35.2923 -2.9381 2021-04-29 04:20:55 Melilla, Spain
12242 2021-04-28 Spain Murcia     110604 1586 2180 106838 37.9922 -1.1307 2021-04-29 04:20:55 Murcia, Spain
12243 2021-04-28 Spain Navarra     59538 1154 3905 54479 42.6954 -1.6761 2021-04-29 04:20:55 Navarra, Spain
12244 2021-04-28 Spain Pais Vasco     183227 4131 16160 162936 42.9896 -2.6189 2021-04-29 04:20:55 Pais Vasco, Spain
12245 2021-04-28 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
18215 2020-04-03 Spain       119199 11198 30513 77488 40.463667 -3.7492199999999998 2020-04-03 22:46:20 Spain
21332 2020-06-17 Spain Andalusia     12839 1404 10671 764 37.5443 -4.7278 2020-06-18 04:33:18 Andalusia, Spain
21341 2020-06-17 Spain Aragon     5850 826 3772 1252 41.5976 -0.9057 2020-06-18 04:33:18 Aragon, Spain
21351 2020-06-17 Spain Asturias     2436 314 1063 1059 43.3614 -5.8593 2020-06-18 04:33:18 Asturias, Spain
21362 2020-06-17 Spain Baleares     2165 209 1533 423 39.710358 2.995148 2020-06-18 04:33:18 Baleares, Spain
21383 2020-06-17 Spain C. Valenciana     11431 1332 9970 129 39.484 -0.7533 2020-06-18 04:33:18 C. Valenciana, Spain
21390 2020-06-17 Spain Canarias     2382 151 1537 694 28.2916 -16.6291 2020-06-18 04:33:18 Canarias, Spain
21391 2020-06-17 Spain Cantabria     2338 202 2287 -151 43.1828 -3.9878 2020-06-18 04:33:18 Cantabria, Spain
21395 2020-06-17 Spain Castilla - La Mancha     17845 2945 6392 8508 39.2796 -3.0977 2020-06-18 04:33:18 Castilla - La Mancha, Spain
21396 2020-06-17 Spain Castilla y Leon     19407 1928 8716 8763 41.8357 -4.3976 2020-06-18 04:33:18 Castilla y Leon, Spain
21397 2020-06-17 Spain Catalonia     60030 5587 26203 28240 41.5912 1.5209 2020-06-18 04:33:18 Catalonia, Spain
21402 2020-06-17 Spain Ceuta     163 4 163 -4 35.8894 -5.3213 2020-06-18 04:33:18 Ceuta, Spain
21441 2020-06-17 Spain Extremadura     2992 508 2652 -168 39.4937 -6.0679 2020-06-18 04:33:18 Extremadura, Spain
21451 2020-06-17 Spain Galicia     9164 609 9204 -649 42.5751 -8.1339 2020-06-18 04:33:18 Galicia, Spain
21550 2020-06-17 Spain La Rioja     4070 362 3107 601 42.2871 -2.5396 2020-06-18 04:33:18 La Rioja, Spain
21568 2020-06-17 Spain Madrid     70799 8691 40736 21372 40.4168 -3.7038 2020-06-18 04:33:18 Madrid, Spain
21585 2020-06-17 Spain Melilla     124 2 125 -3 35.2923 -2.9381 2020-06-18 04:33:18 Melilla, Spain
21602 2020-06-17 Spain Murcia     1631 148 2180 -697 37.9922 -1.1307 2020-06-18 04:33:18 Murcia, Spain
21610 2020-06-17 Spain Navarra     5359 490 3905 964 42.6954 -1.6761 2020-06-18 04:33:18 Navarra, Spain
21651 2020-06-17 Spain Pais Vasco     13658 1424 16160 -3926 42.9896 -2.6189 2020-06-18 04:33:18 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]);