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

407 rows where country_or_region = "Spain" and province_or_state = "Catalonia" sorted by day descending

View and edit SQL

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

province_or_state

  • Catalonia · 407

country_or_region

  • Spain · 407
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
235212 2021-06-24 Spain Catalonia     638516 14731 26203 597582 41.5912 1.5209 2021-06-25 04:21:33 Catalonia, Spain
472160 2021-06-23 Spain Catalonia     637252 14729 26203 596320 41.5912 1.5209 2021-06-24 04:21:55 Catalonia, Spain
627218 2021-06-22 Spain Catalonia     636053 14728 26203 595122 41.5912 1.5209 2021-06-23 04:21:46 Catalonia, Spain
227238 2021-06-21 Spain Catalonia     634903 14714 26203 593986 41.5912 1.5209 2021-06-22 04:21:34 Catalonia, Spain
1472760 2021-06-20 Spain Catalonia     634247 14714 26203 593330 41.5912 1.5209 2021-06-21 04:21:41 Catalonia, Spain
1304001 2021-06-19 Spain Catalonia     634247 14714 26203 593330 41.5912 1.5209 2021-06-20 04:21:48 Catalonia, Spain
303603 2021-06-18 Spain Catalonia     634247 14714 26203 593330 41.5912 1.5209 2021-06-19 04:22:33 Catalonia, Spain
886433 2021-06-17 Spain Catalonia     633391 14713 26203 592475 41.5912 1.5209 2021-06-18 04:22:16 Catalonia, Spain
42328 2021-06-16 Spain Catalonia     632455 14713 26203 591539 41.5912 1.5209 2021-06-17 04:22:36 Catalonia, Spain
1705150 2021-06-15 Spain Catalonia     631554 14695 26203 590656 41.5912 1.5209 2021-06-16 04:22:32 Catalonia, Spain
1661421 2021-06-14 Spain Catalonia     630929 14691 26203 590035 41.5912 1.5209 2021-06-15 04:22:22 Catalonia, Spain
319497 2021-06-13 Spain Catalonia     629718 14691 26203 588824 41.5912 1.5209 2021-06-14 04:22:46 Catalonia, Spain
619242 2021-06-12 Spain Catalonia     629718 14691 26203 588824 41.5912 1.5209 2021-06-13 04:22:44 Catalonia, Spain
592251 2021-06-11 Spain Catalonia     629718 14691 26203 588824 41.5912 1.5209 2021-06-12 04:22:22 Catalonia, Spain
273129 2021-06-10 Spain Catalonia     629143 14690 26203 588250 41.5912 1.5209 2021-06-11 04:23:20 Catalonia, Spain
1638187 2021-06-09 Spain Catalonia     618757 14606 26203 577948 41.5912 1.5209 2021-06-10 04:23:17 Catalonia, Spain
1744800 2021-06-08 Spain Catalonia     617767 14606 26203 576958 41.5912 1.5209 2021-06-09 04:23:31 Catalonia, Spain
577343 2021-06-07 Spain Catalonia     617193 14599 26203 576391 41.5912 1.5209 2021-06-08 04:22:35 Catalonia, Spain
246206 2021-06-06 Spain Catalonia     615478 14595 26203 574680 41.5912 1.5209 2021-06-07 04:22:51 Catalonia, Spain
674183 2021-06-05 Spain Catalonia     615478 14595 26203 574680 41.5912 1.5209 2021-06-06 04:24:03 Catalonia, Spain
553446 2021-06-04 Spain Catalonia     615478 14595 26203 574680 41.5912 1.5209 2021-06-05 04:23:03 Catalonia, Spain
1460843 2021-06-03 Spain Catalonia     614471 14552 26203 573716 41.5912 1.5209 2021-06-04 04:23:37 Catalonia, Spain
1399836 2021-06-02 Spain Catalonia     613539 14552 26203 572784 41.5912 1.5209 2021-06-03 04:23:32 Catalonia, Spain
1709183 2021-06-01 Spain Catalonia     612377 14544 26203 571630 41.5912 1.5209 2021-06-02 04:24:34 Catalonia, Spain
19413 2021-05-31 Spain Catalonia     611755 14542 26203 571010 41.5912 1.5209 2021-06-01 04:23:09 Catalonia, Spain
1497806 2021-05-30 Spain Catalonia     611008 14531 26203 570274 41.5912 1.5209 2021-05-31 03:08:59 Catalonia, Spain
623229 2021-05-29 Spain Catalonia     611008 14531 26203 570274 41.5912 1.5209 2021-05-30 04:20:55 Catalonia, Spain
81085 2021-05-28 Spain Catalonia     611008 14531 26203 570274 41.5912 1.5209 2021-05-29 04:20:41 Catalonia, Spain
1426360 2021-05-27 Spain Catalonia     610001 14527 26203 569271 41.5912 1.5209 2021-05-28 04:20:36 Catalonia, Spain
1549327 2021-05-26 Spain Catalonia     609131 14526 26203 568402 41.5912 1.5209 2021-05-27 04:20:59 Catalonia, Spain
1200903 2021-05-25 Spain Catalonia     608353 14511 26203 567639 41.5912 1.5209 2021-05-26 04:20:35 Catalonia, Spain
149896 2021-05-24 Spain Catalonia     608047 14506 26203 567338 41.5912 1.5209 2021-05-25 04:21:08 Catalonia, Spain
690049 2021-05-23 Spain Catalonia     605851 14498 26203 565150 41.5912 1.5209 2021-05-24 04:20:53 Catalonia, Spain
387663 2021-05-22 Spain Catalonia     605851 14498 26203 565150 41.5912 1.5209 2021-05-23 04:20:51 Catalonia, Spain
969978 2021-05-21 Spain Catalonia     605851 14498 26203 565150 41.5912 1.5209 2021-05-22 04:20:45 Catalonia, Spain
57940 2021-05-20 Spain Catalonia     605100 14497 26203 564400 41.5912 1.5209 2021-05-21 04:20:43 Catalonia, Spain
464202 2021-05-19 Spain Catalonia     603975 14491 26203 563281 41.5912 1.5209 2021-05-20 04:21:05 Catalonia, Spain
1276158 2021-05-18 Spain Catalonia     602609 14484 26203 561922 41.5912 1.5209 2021-05-19 04:20:42 Catalonia, Spain
231222 2021-05-17 Spain Catalonia     602275 14470 26203 561602 41.5912 1.5209 2021-05-18 04:20:33 Catalonia, Spain
1159437 2021-05-16 Spain Catalonia     599891 14446 26203 559242 41.5912 1.5209 2021-05-17 04:20:34 Catalonia, Spain
1008993 2021-05-15 Spain Catalonia     599891 14446 26203 559242 41.5912 1.5209 2021-05-16 04:20:49 Catalonia, Spain
805105 2021-05-14 Spain Catalonia     599891 14446 26203 559242 41.5912 1.5209 2021-05-15 04:20:58 Catalonia, Spain
1192933 2021-05-13 Spain Catalonia     599033 14430 26203 558400 41.5912 1.5209 2021-05-14 04:20:41 Catalonia, Spain
686062 2021-05-12 Spain Catalonia     597957 14409 26203 557345 41.5912 1.5209 2021-05-13 04:20:51 Catalonia, Spain
129462 2021-05-11 Spain Catalonia     596478 14382 26203 555893 41.5912 1.5209 2021-05-12 04:21:29 Catalonia, Spain
1257467 2021-05-10 Spain Catalonia     596039 14342 26203 555494 41.5912 1.5209 2021-05-11 04:20:41 Catalonia, Spain
121488 2021-05-09 Spain Catalonia     592912 14319 26203 552390 41.5912 1.5209 2021-05-10 04:20:38 Catalonia, Spain
89058 2021-05-08 Spain Catalonia     592912 14319 26203 552390 41.5912 1.5209 2021-05-09 04:20:35 Catalonia, Spain
522556 2021-05-07 Spain Catalonia     592912 14319 26203 552390 41.5912 1.5209 2021-05-08 04:21:04 Catalonia, Spain
1685180 2021-05-06 Spain Catalonia     591034 14292 26203 550539 41.5912 1.5209 2021-05-07 04:20:40 Catalonia, Spain
23399 2021-05-05 Spain Catalonia     589156 14271 26203 548682 41.5912 1.5209 2021-05-06 04:20:38 Catalonia, Spain
1331341 2021-05-04 Spain Catalonia     587461 14191 26203 547067 41.5912 1.5209 2021-05-05 04:20:43 Catalonia, Spain
1035928 2021-05-03 Spain Catalonia     588394 14152 26203 548039 41.5912 1.5209 2021-05-04 04:20:34 Catalonia, Spain
914118 2021-05-02 Spain Catalonia     585069 14149 26203 544717 41.5912 1.5209 2021-05-03 04:20:39 Catalonia, Spain
1757084 2021-05-01 Spain Catalonia     585069 14149 26203 544717 41.5912 1.5209 2021-05-02 04:20:48 Catalonia, Spain
1456855 2021-04-30 Spain Catalonia     585069 14149 26203 544717 41.5912 1.5209 2021-05-01 04:20:47 Catalonia, Spain
1614669 2021-04-29 Spain Catalonia     582957 14082 26203 542672 41.5912 1.5209 2021-04-30 04:21:03 Catalonia, Spain
484068 2021-04-28 Spain Catalonia     580682 14019 26203 540460 41.5912 1.5209 2021-04-29 04:20:55 Catalonia, Spain
335106 2021-04-27 Spain Catalonia     578218 14013 26203 538002 41.5912 1.5209 2021-04-28 04:20:32 Catalonia, Spain
1358151 2021-04-26 Spain Catalonia     577407 13990 26203 537214 41.5912 1.5209 2021-04-27 04:20:52 Catalonia, Spain
496107 2021-04-25 Spain Catalonia     572754 13954 26203 532597 41.5912 1.5209 2021-04-26 04:21:04 Catalonia, Spain
1112706 2021-04-24 Spain Catalonia     572754 13954 26203 532597 41.5912 1.5209 2021-04-25 04:20:32 Catalonia, Spain
488055 2021-04-23 Spain Catalonia     572754 13954 26203 532597 41.5912 1.5209 2021-04-24 04:20:38 Catalonia, Spain
1170440 2021-04-22 Spain Catalonia     569080 13939 26203 528938 41.5912 1.5209 2021-04-23 04:20:52 Catalonia, Spain
1403911 2021-04-21 Spain Catalonia     566399 13917 26203 526279 41.5912 1.5209 2021-04-22 04:20:53 Catalonia, Spain
1713169 2021-04-20 Spain Catalonia     563680 13845 26203 550447 41.5912 1.5209 2021-04-21 04:21:14 Catalonia, Spain
607298 2021-04-19 Spain Catalonia     563680 13845 26203 523632 41.5912 1.5209 2021-04-20 04:20:41 Catalonia, Spain
918105 2021-04-18 Spain Catalonia     559460 13823 26203 519434 41.5912 1.5209 2021-04-19 04:20:57 Catalonia, Spain
1319416 2021-04-17 Spain Catalonia     559460 13823 26203 519434 41.5912 1.5209 2021-04-18 04:20:41 Catalonia, Spain
989108 2021-04-16 Spain Catalonia     559460 13823 26203 519434 41.5912 1.5209 2021-04-17 04:20:40 Catalonia, Spain
380212 2021-04-15 Spain Catalonia     557288 13815 26203 517270 41.5912 1.5209 2021-04-16 04:20:46 Catalonia, Spain
906162 2021-04-14 Spain Catalonia     555546 13778 26203 515565 41.5912 1.5209 2021-04-15 04:20:54 Catalonia, Spain
1079389 2021-04-13 Spain Catalonia     553393 13729 26203 513461 41.5912 1.5209 2021-04-14 04:20:41 Catalonia, Spain
354625 2021-04-12 Spain Catalonia     552395 13689 26203 512503 41.5912 1.5209 2021-04-13 04:20:37 Catalonia, Spain
1181074 2021-04-11 Spain Catalonia     547239 13568 26203 507468 41.5912 1.5209 2021-04-12 04:21:00 Catalonia, Spain
1188946 2021-04-10 Spain Catalonia     547239 13568 26203 507468 41.5912 1.5209 2021-04-11 04:20:56 Catalonia, Spain
1693132 2021-04-09 Spain Catalonia     547239 13568 26203 507468 41.5912 1.5209 2021-04-10 04:20:59 Catalonia, Spain
569371 2021-04-08 Spain Catalonia     544613 13552 26203 504858 41.5912 1.5209 2021-04-09 04:21:13 Catalonia, Spain
1346190 2021-04-07 Spain Catalonia     543680 13522 26203 503955 41.5912 1.5209 2021-04-08 04:21:13 Catalonia, Spain
350558 2021-04-06 Spain Catalonia     542879 13500 26203 503176 41.5912 1.5209 2021-04-07 04:20:53 Catalonia, Spain
1043883 2021-04-05 Spain Catalonia     542260 13500 26203 502557 41.5912 1.5209 2021-04-06 04:20:32 Catalonia, Spain
215203 2021-04-04 Spain Catalonia     539381 13484 26203 499694 41.5912 1.5209 2021-04-05 04:20:35 Catalonia, Spain
1701162 2021-04-03 Spain Catalonia     539381 13484 26203 499694 41.5912 1.5209 2021-04-04 04:20:49 Catalonia, Spain
953851 2021-04-02 Spain Catalonia     538008 13376 26203 498429 41.5912 1.5209 2021-04-03 04:20:44 Catalonia, Spain
125475 2021-04-01 Spain Catalonia     538008 13376 26203 498429 41.5912 1.5209 2021-04-02 04:20:36 Catalonia, Spain
1516367 2021-03-31 Spain Catalonia     536235 13335 26203 496697 41.5912 1.5209 2021-04-01 04:27:05 Catalonia, Spain
1717156 2021-03-30 Spain Catalonia     534368 13251 26203 494914 41.5912 1.5209 2021-03-31 04:26:25 Catalonia, Spain
733143 2021-03-29 Spain Catalonia     533746 13243 26203 494300 41.5912 1.5209 2021-03-30 04:26:23 Catalonia, Spain
422447 2021-03-28 Spain Catalonia     529904 13120 26203 490581 41.5912 1.5209 2021-03-29 04:28:35 Catalonia, Spain
1732838 2021-03-27 Spain Catalonia     529904 13120 26203 490581 41.5912 1.5209 2021-03-28 05:28:10 Catalonia, Spain
403281 2021-03-26 Spain Catalonia     529904 13120 26203 490581 41.5912 1.5209 2021-03-27 05:25:04 Catalonia, Spain
1354164 2021-03-25 Spain Catalonia     527829 12596 26203 489030 41.5912 1.5209 2021-03-26 05:26:55 Catalonia, Spain
507854 2021-03-24 Spain Catalonia     525096 12086 26203 486807 41.5912 1.5209 2021-03-25 05:27:00 Catalonia, Spain
1590771 2021-03-23 Spain Catalonia     525096 12086 26203 486807 41.5912 1.5209 2021-03-24 05:25:40 Catalonia, Spain
840163 2021-03-22 Spain Catalonia     523656 12041 26203 485412 41.5912 1.5209 2021-03-23 05:26:18 Catalonia, Spain
721403 2021-03-21 Spain Catalonia     520263 11659 26203 482401 41.5912 1.5209 2021-03-22 05:25:43 Catalonia, Spain
442546 2021-03-20 Spain Catalonia     520263 11659 26203 482401 41.5912 1.5209 2021-03-21 05:25:44 Catalonia, Spain
545488 2021-03-19 Spain Catalonia     520263 11659 26203 482401 41.5912 1.5209 2021-03-20 05:25:46 Catalonia, Spain
1350177 2021-03-18 Spain Catalonia     520263 11659 26203 482401 41.5912 1.5209 2021-03-19 05:26:09 Catalonia, Spain
85071 2021-03-17 Spain Catalonia     518822 11652 26203 480967 41.5912 1.5209 2021-03-18 05:26:22 Catalonia, 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]);