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

397 rows where country_or_region = "Spain" and province_or_state = "Cantabria" sorted by day descending

View and edit SQL

Suggested facets: recovered, day (date), last_update (date)

province_or_state

  • Cantabria · 397

country_or_region

  • Spain · 397
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
223218 2021-06-14 Spain Cantabria     30653 566 2287 27800 43.1828 -3.9878 2021-06-15 04:22:22 Cantabria, Spain
215250 2021-06-13 Spain Cantabria     30588 566 2287 27735 43.1828 -3.9878 2021-06-14 04:22:46 Cantabria, Spain
281820 2021-06-12 Spain Cantabria     30588 566 2287 27735 43.1828 -3.9878 2021-06-13 04:22:44 Cantabria, Spain
1633919 2021-06-11 Spain Cantabria     30588 566 2287 27735 43.1828 -3.9878 2021-06-12 04:22:22 Cantabria, Spain
663205 2021-06-10 Spain Cantabria     30563 566 2287 27710 43.1828 -3.9878 2021-06-11 04:23:20 Cantabria, Spain
882309 2021-06-09 Spain Cantabria     30543 566 2287 27690 43.1828 -3.9878 2021-06-10 04:23:17 Cantabria, Spain
1710308 2021-06-08 Spain Cantabria     30511 566 2287 27658 43.1828 -3.9878 2021-06-09 04:23:31 Cantabria, Spain
1466152 2021-06-07 Spain Cantabria     30483 565 2287 27631 43.1828 -3.9878 2021-06-08 04:22:35 Cantabria, Spain
993919 2021-06-06 Spain Cantabria     30414 565 2287 27562 43.1828 -3.9878 2021-06-07 04:22:51 Cantabria, Spain
158709 2021-06-05 Spain Cantabria     30414 565 2287 27562 43.1828 -3.9878 2021-06-06 04:24:03 Cantabria, Spain
1516694 2021-06-04 Spain Cantabria     30414 565 2287 27562 43.1828 -3.9878 2021-06-05 04:23:03 Cantabria, Spain
1141005 2021-06-03 Spain Cantabria     30376 565 2287 27524 43.1828 -3.9878 2021-06-04 04:23:37 Cantabria, Spain
427449 2021-06-02 Spain Cantabria     30352 565 2287 27500 43.1828 -3.9878 2021-06-03 04:23:32 Cantabria, Spain
539956 2021-06-01 Spain Cantabria     30300 565 2287 27448 43.1828 -3.9878 2021-06-02 04:24:34 Cantabria, Spain
787141 2021-05-31 Spain Cantabria     30268 565 2287 27416 43.1828 -3.9878 2021-06-01 04:23:09 Cantabria, Spain
1330539 2021-05-30 Spain Cantabria     30178 564 2287 27327 43.1828 -3.9878 2021-05-31 03:08:59 Cantabria, Spain
67748 2021-05-29 Spain Cantabria     30178 564 2287 27327 43.1828 -3.9878 2021-05-30 04:20:55 Cantabria, Spain
195934 2021-05-28 Spain Cantabria     30178 564 2287 27327 43.1828 -3.9878 2021-05-29 04:20:41 Cantabria, Spain
939193 2021-05-27 Spain Cantabria     30135 564 2287 27284 43.1828 -3.9878 2021-05-28 04:20:36 Cantabria, Spain
1226867 2021-05-26 Spain Cantabria     30086 563 2287 27236 43.1828 -3.9878 2021-05-27 04:20:59 Cantabria, Spain
1338506 2021-05-25 Spain Cantabria     30054 563 2287 27204 43.1828 -3.9878 2021-05-26 04:20:35 Cantabria, Spain
203338 2021-05-24 Spain Cantabria     30011 563 2287 27161 43.1828 -3.9878 2021-05-25 04:21:08 Cantabria, Spain
99502 2021-05-23 Spain Cantabria     29907 562 2287 27058 43.1828 -3.9878 2021-05-24 04:20:53 Cantabria, Spain
524021 2021-05-22 Spain Cantabria     29907 562 2287 27058 43.1828 -3.9878 2021-05-23 04:20:51 Cantabria, Spain
859716 2021-05-21 Spain Cantabria     29907 562 2287 27058 43.1828 -3.9878 2021-05-22 04:20:45 Cantabria, Spain
721139 2021-05-20 Spain Cantabria     29877 561 2287 27029 43.1828 -3.9878 2021-05-21 04:20:43 Cantabria, Spain
408270 2021-05-19 Spain Cantabria     29851 561 2287 27003 43.1828 -3.9878 2021-05-20 04:21:05 Cantabria, Spain
783156 2021-05-18 Spain Cantabria     29812 561 2287 26964 43.1828 -3.9878 2021-05-19 04:20:42 Cantabria, Spain
1423298 2021-05-17 Spain Cantabria     29771 561 2287 26923 43.1828 -3.9878 2021-05-18 04:20:33 Cantabria, Spain
740484 2021-05-16 Spain Cantabria     29696 560 2287 26849 43.1828 -3.9878 2021-05-17 04:20:34 Cantabria, Spain
1117017 2021-05-15 Spain Cantabria     29696 560 2287 26849 43.1828 -3.9878 2021-05-16 04:20:49 Cantabria, Spain
1587526 2021-05-14 Spain Cantabria     29696 560 2287 26849 43.1828 -3.9878 2021-05-15 04:20:58 Cantabria, Spain
1675443 2021-05-13 Spain Cantabria     29649 560 2287 26802 43.1828 -3.9878 2021-05-14 04:20:41 Cantabria, Spain
803070 2021-05-12 Spain Cantabria     29602 560 2287 26755 43.1828 -3.9878 2021-05-13 04:20:51 Cantabria, Spain
1181458 2021-05-11 Spain Cantabria     29556 560 2287 26709 43.1828 -3.9878 2021-05-12 04:21:29 Cantabria, Spain
325248 2021-05-10 Spain Cantabria     29505 560 2287 26658 43.1828 -3.9878 2021-05-11 04:20:41 Cantabria, Spain
604395 2021-05-09 Spain Cantabria     29352 558 2287 26507 43.1828 -3.9878 2021-05-10 04:20:38 Cantabria, Spain
986142 2021-05-08 Spain Cantabria     29352 558 2287 26507 43.1828 -3.9878 2021-05-09 04:20:35 Cantabria, Spain
434624 2021-05-07 Spain Cantabria     29352 558 2287 26507 43.1828 -3.9878 2021-05-08 04:21:04 Cantabria, Spain
901405 2021-05-06 Spain Cantabria     29281 558 2287 26436 43.1828 -3.9878 2021-05-07 04:20:40 Cantabria, Spain
71731 2021-05-05 Spain Cantabria     29212 558 2287 26367 43.1828 -3.9878 2021-05-06 04:20:38 Cantabria, Spain
791124 2021-05-04 Spain Cantabria     29142 557 2287 26298 43.1828 -3.9878 2021-05-05 04:20:43 Cantabria, Spain
1613654 2021-05-03 Spain Cantabria     29059 557 2287 26215 43.1828 -3.9878 2021-05-04 04:20:34 Cantabria, Spain
886292 2021-05-02 Spain Cantabria     28763 557 2287 25919 43.1828 -3.9878 2021-05-03 04:20:39 Cantabria, Spain
511997 2021-05-01 Spain Cantabria     28763 557 2287 25919 43.1828 -3.9878 2021-05-02 04:20:48 Cantabria, Spain
14933 2021-04-30 Spain Cantabria     28763 557 2287 25919 43.1828 -3.9878 2021-05-01 04:20:47 Cantabria, Spain
1125037 2021-04-29 Spain Cantabria     28629 556 2287 25786 43.1828 -3.9878 2021-04-30 04:21:03 Cantabria, Spain
462334 2021-04-28 Spain Cantabria     28529 556 2287 25686 43.1828 -3.9878 2021-04-29 04:20:55 Cantabria, Spain
1315040 2021-04-27 Spain Cantabria     28441 555 2287 25599 43.1828 -3.9878 2021-04-28 04:20:32 Cantabria, Spain
1549467 2021-04-26 Spain Cantabria     28310 554 2287 25469 43.1828 -3.9878 2021-04-27 04:20:52 Cantabria, Spain
1629934 2021-04-25 Spain Cantabria     28004 554 2287 25163 43.1828 -3.9878 2021-04-26 04:21:04 Cantabria, Spain
354074 2021-04-24 Spain Cantabria     28004 554 2287 25163 43.1828 -3.9878 2021-04-25 04:20:32 Cantabria, Spain
725123 2021-04-23 Spain Cantabria     28004 554 2287 25163 43.1828 -3.9878 2021-04-24 04:20:38 Cantabria, Spain
1470135 2021-04-22 Spain Cantabria     27885 554 2287 25044 43.1828 -3.9878 2021-04-23 04:20:52 Cantabria, Spain
1222883 2021-04-21 Spain Cantabria     27778 553 2287 24938 43.1828 -3.9878 2021-04-22 04:20:53 Cantabria, Spain
458350 2021-04-20 Spain Cantabria     27579 553 2287 27135 43.1828 -3.9878 2021-04-21 04:21:14 Cantabria, Spain
1300538 2021-04-19 Spain Cantabria     27579 553 2287 24739 43.1828 -3.9878 2021-04-20 04:20:41 Cantabria, Spain
1070117 2021-04-18 Spain Cantabria     27269 551 2287 24431 43.1828 -3.9878 2021-04-19 04:20:57 Cantabria, Spain
1045999 2021-04-17 Spain Cantabria     27269 551 2287 24431 43.1828 -3.9878 2021-04-18 04:20:41 Cantabria, Spain
597275 2021-04-16 Spain Cantabria     27269 551 2287 24431 43.1828 -3.9878 2021-04-17 04:20:40 Cantabria, Spain
1621691 2021-04-15 Spain Cantabria     27135 550 2287 24298 43.1828 -3.9878 2021-04-16 04:20:46 Cantabria, Spain
951122 2021-04-14 Spain Cantabria     27069 550 2287 24232 43.1828 -3.9878 2021-04-15 04:20:54 Cantabria, Spain
593291 2021-04-13 Spain Cantabria     26990 550 2287 24153 43.1828 -3.9878 2021-04-14 04:20:41 Cantabria, Spain
33230 2021-04-12 Spain Cantabria     26888 548 2287 24053 43.1828 -3.9878 2021-04-13 04:20:37 Cantabria, Spain
1372245 2021-04-11 Spain Cantabria     26653 546 2287 23820 43.1828 -3.9878 2021-04-12 04:21:00 Cantabria, Spain
1667497 2021-04-10 Spain Cantabria     26653 546 2287 23820 43.1828 -3.9878 2021-04-11 04:20:56 Cantabria, Spain
1160113 2021-04-09 Spain Cantabria     26653 546 2287 23820 43.1828 -3.9878 2021-04-10 04:20:59 Cantabria, Spain
1057948 2021-04-08 Spain Cantabria     26552 546 2287 23719 43.1828 -3.9878 2021-04-09 04:21:13 Cantabria, Spain
1500737 2021-04-07 Spain Cantabria     26490 545 2287 23658 43.1828 -3.9878 2021-04-08 04:21:13 Cantabria, Spain
1207942 2021-04-06 Spain Cantabria     26425 545 2287 23593 43.1828 -3.9878 2021-04-07 04:20:53 Cantabria, Spain
123243 2021-04-05 Spain Cantabria     26368 544 2287 23537 43.1828 -3.9878 2021-04-06 04:20:32 Cantabria, Spain
1255044 2021-04-04 Spain Cantabria     26268 544 2287 23437 43.1828 -3.9878 2021-04-05 04:20:35 Cantabria, Spain
1129021 2021-04-03 Spain Cantabria     26268 544 2287 23437 43.1828 -3.9878 2021-04-04 04:20:49 Cantabria, Spain
270412 2021-04-02 Spain Cantabria     26077 542 2287 23248 43.1828 -3.9878 2021-04-03 04:20:44 Cantabria, Spain
1173744 2021-04-01 Spain Cantabria     26077 542 2287 23248 43.1828 -3.9878 2021-04-02 04:20:36 Cantabria, Spain
516055 2021-03-31 Spain Cantabria     26077 542 2287 23248 43.1828 -3.9878 2021-04-01 04:27:05 Cantabria, Spain
289784 2021-03-30 Spain Cantabria     26011 542 2287 23182 43.1828 -3.9878 2021-03-31 04:26:25 Cantabria, Spain
1575321 2021-03-29 Spain Cantabria     25949 542 2287 23120 43.1828 -3.9878 2021-03-30 04:26:23 Cantabria, Spain
631598 2021-03-28 Spain Cantabria     25813 541 2287 22985 43.1828 -3.9878 2021-03-29 04:28:35 Cantabria, Spain
608379 2021-03-27 Spain Cantabria     25813 541 2287 22985 43.1828 -3.9878 2021-03-28 05:28:10 Cantabria, Spain
1334522 2021-03-26 Spain Cantabria     25813 541 2287 22985 43.1828 -3.9878 2021-03-27 05:25:04 Cantabria, Spain
150961 2021-03-25 Spain Cantabria     25693 537 2287 22869 43.1828 -3.9878 2021-03-26 05:26:55 Cantabria, Spain
1598482 2021-03-24 Spain Cantabria     25592 532 2287 22773 43.1828 -3.9878 2021-03-25 05:27:00 Cantabria, Spain
404286 2021-03-23 Spain Cantabria     25592 532 2287 22773 43.1828 -3.9878 2021-03-24 05:25:40 Cantabria, Spain
1387823 2021-03-22 Spain Cantabria     25541 532 2287 22722 43.1828 -3.9878 2021-03-23 05:26:18 Cantabria, Spain
305310 2021-03-21 Spain Cantabria     25398 530 2287 22581 43.1828 -3.9878 2021-03-22 05:25:43 Cantabria, Spain
254359 2021-03-20 Spain Cantabria     25398 530 2287 22581 43.1828 -3.9878 2021-03-21 05:25:44 Cantabria, Spain
1231115 2021-03-19 Spain Cantabria     25398 530 2287 22581 43.1828 -3.9878 2021-03-20 05:25:46 Cantabria, Spain
975040 2021-03-18 Spain Cantabria     25398 530 2287 22581 43.1828 -3.9878 2021-03-19 05:26:09 Cantabria, Spain
1532675 2021-03-17 Spain Cantabria     25348 530 2287 22531 43.1828 -3.9878 2021-03-18 05:26:22 Cantabria, Spain
55869 2021-03-16 Spain Cantabria     25306 530 2287 22489 43.1828 -3.9878 2021-03-17 05:25:07 Cantabria, Spain
563182 2021-03-15 Spain Cantabria     25251 530 2287 22434 43.1828 -3.9878 2021-03-16 05:25:13 Cantabria, Spain
851751 2021-03-14 Spain Cantabria     25134 529 2287 22318 43.1828 -3.9878 2021-03-15 05:25:51 Cantabria, Spain
943176 2021-03-13 Spain Cantabria     25134 529 2287 22318 43.1828 -3.9878 2021-03-14 05:25:37 Cantabria, Spain
1311056 2021-03-12 Spain Cantabria     25134 529 2287 22318 43.1828 -3.9878 2021-03-13 05:25:15 Cantabria, Spain
1077894 2021-03-11 Spain Cantabria     25095 528 2287 22280 43.1828 -3.9878 2021-03-12 05:26:50 Cantabria, Spain
955106 2021-03-10 Spain Cantabria     25051 527 2287 22237 43.1828 -3.9878 2021-03-11 05:25:48 Cantabria, Spain
543939 2021-03-09 Spain Cantabria     25002 526 2287 22189 43.1828 -3.9878 2021-03-10 05:24:35 Cantabria, Spain
1520677 2021-03-08 Spain Cantabria     24975 523 2287 22165 43.1828 -3.9878 2021-03-09 05:28:19 Cantabria, Spain
866958 2021-03-07 Spain Cantabria     24866 518 2287 22061 43.1828 -3.9878 2021-03-08 05:24:48 Cantabria, 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]);