⚠️ 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 = "Murcia" sorted by day descending

View and edit SQL

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

province_or_state

  • Murcia · 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
223228 2021-06-14 Spain Murcia     113831 1604 2180 110047 37.9922 -1.1307 2021-06-15 04:22:22 Murcia, Spain
215260 2021-06-13 Spain Murcia     113680 1604 2180 109896 37.9922 -1.1307 2021-06-14 04:22:46 Murcia, Spain
281830 2021-06-12 Spain Murcia     113680 1604 2180 109896 37.9922 -1.1307 2021-06-13 04:22:44 Murcia, Spain
1633929 2021-06-11 Spain Murcia     113680 1604 2180 109896 37.9922 -1.1307 2021-06-12 04:22:22 Murcia, Spain
663215 2021-06-10 Spain Murcia     113603 1603 2180 109820 37.9922 -1.1307 2021-06-11 04:23:20 Murcia, Spain
882319 2021-06-09 Spain Murcia     113576 1603 2180 109793 37.9922 -1.1307 2021-06-10 04:23:17 Murcia, Spain
1710318 2021-06-08 Spain Murcia     113509 1603 2180 109726 37.9922 -1.1307 2021-06-09 04:23:31 Murcia, Spain
1466162 2021-06-07 Spain Murcia     113470 1602 2180 109688 37.9922 -1.1307 2021-06-08 04:22:35 Murcia, Spain
993929 2021-06-06 Spain Murcia     113352 1602 2180 109570 37.9922 -1.1307 2021-06-07 04:22:51 Murcia, Spain
158719 2021-06-05 Spain Murcia     113352 1602 2180 109570 37.9922 -1.1307 2021-06-06 04:24:03 Murcia, Spain
1516704 2021-06-04 Spain Murcia     113352 1602 2180 109570 37.9922 -1.1307 2021-06-05 04:23:03 Murcia, Spain
1141015 2021-06-03 Spain Murcia     113278 1602 2180 109496 37.9922 -1.1307 2021-06-04 04:23:37 Murcia, Spain
427459 2021-06-02 Spain Murcia     113200 1602 2180 109418 37.9922 -1.1307 2021-06-03 04:23:32 Murcia, Spain
539966 2021-06-01 Spain Murcia     113144 1600 2180 109364 37.9922 -1.1307 2021-06-02 04:24:34 Murcia, Spain
787151 2021-05-31 Spain Murcia     113069 1600 2180 109289 37.9922 -1.1307 2021-06-01 04:23:09 Murcia, Spain
1330549 2021-05-30 Spain Murcia     112926 1600 2180 109146 37.9922 -1.1307 2021-05-31 03:08:59 Murcia, Spain
67758 2021-05-29 Spain Murcia     112926 1600 2180 109146 37.9922 -1.1307 2021-05-30 04:20:55 Murcia, Spain
195944 2021-05-28 Spain Murcia     112926 1600 2180 109146 37.9922 -1.1307 2021-05-29 04:20:41 Murcia, Spain
939203 2021-05-27 Spain Murcia     112801 1600 2180 109021 37.9922 -1.1307 2021-05-28 04:20:36 Murcia, Spain
1226877 2021-05-26 Spain Murcia     112717 1597 2180 108940 37.9922 -1.1307 2021-05-27 04:20:59 Murcia, Spain
1338516 2021-05-25 Spain Murcia     112606 1596 2180 108830 37.9922 -1.1307 2021-05-26 04:20:35 Murcia, Spain
203348 2021-05-24 Spain Murcia     112513 1593 2180 108740 37.9922 -1.1307 2021-05-25 04:21:08 Murcia, Spain
99512 2021-05-23 Spain Murcia     112319 1593 2180 108546 37.9922 -1.1307 2021-05-24 04:20:53 Murcia, Spain
524031 2021-05-22 Spain Murcia     112319 1593 2180 108546 37.9922 -1.1307 2021-05-23 04:20:51 Murcia, Spain
859726 2021-05-21 Spain Murcia     112319 1593 2180 108546 37.9922 -1.1307 2021-05-22 04:20:45 Murcia, Spain
721149 2021-05-20 Spain Murcia     112207 1593 2180 108434 37.9922 -1.1307 2021-05-21 04:20:43 Murcia, Spain
408280 2021-05-19 Spain Murcia     112081 1593 2180 108308 37.9922 -1.1307 2021-05-20 04:21:05 Murcia, Spain
783166 2021-05-18 Spain Murcia     111956 1593 2180 108183 37.9922 -1.1307 2021-05-19 04:20:42 Murcia, Spain
1423308 2021-05-17 Spain Murcia     111885 1593 2180 108112 37.9922 -1.1307 2021-05-18 04:20:33 Murcia, Spain
740494 2021-05-16 Spain Murcia     111756 1593 2180 107983 37.9922 -1.1307 2021-05-17 04:20:34 Murcia, Spain
1117027 2021-05-15 Spain Murcia     111756 1593 2180 107983 37.9922 -1.1307 2021-05-16 04:20:49 Murcia, Spain
1587536 2021-05-14 Spain Murcia     111756 1593 2180 107983 37.9922 -1.1307 2021-05-15 04:20:58 Murcia, Spain
1675453 2021-05-13 Spain Murcia     111631 1593 2180 107858 37.9922 -1.1307 2021-05-14 04:20:41 Murcia, Spain
803080 2021-05-12 Spain Murcia     111551 1592 2180 107779 37.9922 -1.1307 2021-05-13 04:20:51 Murcia, Spain
1181468 2021-05-11 Spain Murcia     111481 1590 2180 107711 37.9922 -1.1307 2021-05-12 04:21:29 Murcia, Spain
325258 2021-05-10 Spain Murcia     111413 1590 2180 107643 37.9922 -1.1307 2021-05-11 04:20:41 Murcia, Spain
604405 2021-05-09 Spain Murcia     111248 1590 2180 107478 37.9922 -1.1307 2021-05-10 04:20:38 Murcia, Spain
986152 2021-05-08 Spain Murcia     111248 1590 2180 107478 37.9922 -1.1307 2021-05-09 04:20:35 Murcia, Spain
434634 2021-05-07 Spain Murcia     111248 1590 2180 107478 37.9922 -1.1307 2021-05-08 04:21:04 Murcia, Spain
901415 2021-05-06 Spain Murcia     111152 1590 2180 107382 37.9922 -1.1307 2021-05-07 04:20:40 Murcia, Spain
71741 2021-05-05 Spain Murcia     111090 1590 2180 107320 37.9922 -1.1307 2021-05-06 04:20:38 Murcia, Spain
791134 2021-05-04 Spain Murcia     110994 1590 2180 107224 37.9922 -1.1307 2021-05-05 04:20:43 Murcia, Spain
1613664 2021-05-03 Spain Murcia     110919 1587 2180 107152 37.9922 -1.1307 2021-05-04 04:20:34 Murcia, Spain
886302 2021-05-02 Spain Murcia     110778 1587 2180 107011 37.9922 -1.1307 2021-05-03 04:20:39 Murcia, Spain
512007 2021-05-01 Spain Murcia     110778 1587 2180 107011 37.9922 -1.1307 2021-05-02 04:20:48 Murcia, Spain
14943 2021-04-30 Spain Murcia     110778 1587 2180 107011 37.9922 -1.1307 2021-05-01 04:20:47 Murcia, Spain
1125047 2021-04-29 Spain Murcia     110680 1587 2180 106913 37.9922 -1.1307 2021-04-30 04:21:03 Murcia, Spain
462344 2021-04-28 Spain Murcia     110604 1586 2180 106838 37.9922 -1.1307 2021-04-29 04:20:55 Murcia, Spain
1315050 2021-04-27 Spain Murcia     110561 1586 2180 106795 37.9922 -1.1307 2021-04-28 04:20:32 Murcia, Spain
1549477 2021-04-26 Spain Murcia     110466 1586 2180 106700 37.9922 -1.1307 2021-04-27 04:20:52 Murcia, Spain
1629944 2021-04-25 Spain Murcia     110257 1585 2180 106492 37.9922 -1.1307 2021-04-26 04:21:04 Murcia, Spain
354084 2021-04-24 Spain Murcia     110257 1585 2180 106492 37.9922 -1.1307 2021-04-25 04:20:32 Murcia, Spain
725133 2021-04-23 Spain Murcia     110257 1585 2180 106492 37.9922 -1.1307 2021-04-24 04:20:38 Murcia, Spain
1470145 2021-04-22 Spain Murcia     110166 1585 2180 106401 37.9922 -1.1307 2021-04-23 04:20:52 Murcia, Spain
1222893 2021-04-21 Spain Murcia     110071 1585 2180 106306 37.9922 -1.1307 2021-04-22 04:20:53 Murcia, Spain
458360 2021-04-20 Spain Murcia     109908 1584 2180 108406 37.9922 -1.1307 2021-04-21 04:21:14 Murcia, Spain
1300548 2021-04-19 Spain Murcia     109908 1584 2180 106144 37.9922 -1.1307 2021-04-20 04:20:41 Murcia, Spain
1070127 2021-04-18 Spain Murcia     109743 1583 2180 105980 37.9922 -1.1307 2021-04-19 04:20:57 Murcia, Spain
1046009 2021-04-17 Spain Murcia     109743 1583 2180 105980 37.9922 -1.1307 2021-04-18 04:20:41 Murcia, Spain
597285 2021-04-16 Spain Murcia     109743 1583 2180 105980 37.9922 -1.1307 2021-04-17 04:20:40 Murcia, Spain
1621701 2021-04-15 Spain Murcia     109660 1577 2180 105903 37.9922 -1.1307 2021-04-16 04:20:46 Murcia, Spain
951132 2021-04-14 Spain Murcia     109586 1574 2180 105832 37.9922 -1.1307 2021-04-15 04:20:54 Murcia, Spain
593301 2021-04-13 Spain Murcia     109529 1574 2180 105775 37.9922 -1.1307 2021-04-14 04:20:41 Murcia, Spain
33240 2021-04-12 Spain Murcia     109395 1574 2180 105641 37.9922 -1.1307 2021-04-13 04:20:37 Murcia, Spain
1372255 2021-04-11 Spain Murcia     109243 1573 2180 105490 37.9922 -1.1307 2021-04-12 04:21:00 Murcia, Spain
1667507 2021-04-10 Spain Murcia     109243 1573 2180 105490 37.9922 -1.1307 2021-04-11 04:20:56 Murcia, Spain
1160123 2021-04-09 Spain Murcia     109243 1573 2180 105490 37.9922 -1.1307 2021-04-10 04:20:59 Murcia, Spain
1057958 2021-04-08 Spain Murcia     109135 1572 2180 105383 37.9922 -1.1307 2021-04-09 04:21:13 Murcia, Spain
1500747 2021-04-07 Spain Murcia     108996 1572 2180 105244 37.9922 -1.1307 2021-04-08 04:21:13 Murcia, Spain
1207952 2021-04-06 Spain Murcia     108939 1572 2180 105187 37.9922 -1.1307 2021-04-07 04:20:53 Murcia, Spain
123253 2021-04-05 Spain Murcia     108832 1567 2180 105085 37.9922 -1.1307 2021-04-06 04:20:32 Murcia, Spain
1255054 2021-04-04 Spain Murcia     108722 1565 2180 104977 37.9922 -1.1307 2021-04-05 04:20:35 Murcia, Spain
1129031 2021-04-03 Spain Murcia     108722 1565 2180 104977 37.9922 -1.1307 2021-04-04 04:20:49 Murcia, Spain
270422 2021-04-02 Spain Murcia     108650 1563 2180 104907 37.9922 -1.1307 2021-04-03 04:20:44 Murcia, Spain
1173754 2021-04-01 Spain Murcia     108650 1563 2180 104907 37.9922 -1.1307 2021-04-02 04:20:36 Murcia, Spain
516065 2021-03-31 Spain Murcia     108542 1562 2180 104800 37.9922 -1.1307 2021-04-01 04:27:05 Murcia, Spain
289794 2021-03-30 Spain Murcia     108418 1559 2180 104679 37.9922 -1.1307 2021-03-31 04:26:25 Murcia, Spain
1575331 2021-03-29 Spain Murcia     108346 1555 2180 104611 37.9922 -1.1307 2021-03-30 04:26:23 Murcia, Spain
631608 2021-03-28 Spain Murcia     108198 1553 2180 104465 37.9922 -1.1307 2021-03-29 04:28:35 Murcia, Spain
608389 2021-03-27 Spain Murcia     108198 1553 2180 104465 37.9922 -1.1307 2021-03-28 05:28:10 Murcia, Spain
1334532 2021-03-26 Spain Murcia     108198 1553 2180 104465 37.9922 -1.1307 2021-03-27 05:25:04 Murcia, Spain
150971 2021-03-25 Spain Murcia     108097 1553 2180 104364 37.9922 -1.1307 2021-03-26 05:26:55 Murcia, Spain
1598492 2021-03-24 Spain Murcia     107949 1550 2180 104219 37.9922 -1.1307 2021-03-25 05:27:00 Murcia, Spain
404296 2021-03-23 Spain Murcia     107949 1550 2180 104219 37.9922 -1.1307 2021-03-24 05:25:40 Murcia, Spain
1387833 2021-03-22 Spain Murcia     107868 1547 2180 104141 37.9922 -1.1307 2021-03-23 05:26:18 Murcia, Spain
305320 2021-03-21 Spain Murcia     107683 1544 2180 103959 37.9922 -1.1307 2021-03-22 05:25:43 Murcia, Spain
254369 2021-03-20 Spain Murcia     107683 1544 2180 103959 37.9922 -1.1307 2021-03-21 05:25:44 Murcia, Spain
1231125 2021-03-19 Spain Murcia     107683 1544 2180 103959 37.9922 -1.1307 2021-03-20 05:25:46 Murcia, Spain
975050 2021-03-18 Spain Murcia     107683 1544 2180 103959 37.9922 -1.1307 2021-03-19 05:26:09 Murcia, Spain
1532685 2021-03-17 Spain Murcia     107626 1543 2180 103903 37.9922 -1.1307 2021-03-18 05:26:22 Murcia, Spain
55879 2021-03-16 Spain Murcia     107580 1541 2180 103859 37.9922 -1.1307 2021-03-17 05:25:07 Murcia, Spain
563192 2021-03-15 Spain Murcia     107466 1539 2180 103747 37.9922 -1.1307 2021-03-16 05:25:13 Murcia, Spain
851761 2021-03-14 Spain Murcia     107314 1537 2180 103597 37.9922 -1.1307 2021-03-15 05:25:51 Murcia, Spain
943186 2021-03-13 Spain Murcia     107314 1537 2180 103597 37.9922 -1.1307 2021-03-14 05:25:37 Murcia, Spain
1311066 2021-03-12 Spain Murcia     107314 1537 2180 103597 37.9922 -1.1307 2021-03-13 05:25:15 Murcia, Spain
1077904 2021-03-11 Spain Murcia     107238 1536 2180 103522 37.9922 -1.1307 2021-03-12 05:26:50 Murcia, Spain
955116 2021-03-10 Spain Murcia     107143 1532 2180 103431 37.9922 -1.1307 2021-03-11 05:25:48 Murcia, Spain
543949 2021-03-09 Spain Murcia     107057 1531 2180 103346 37.9922 -1.1307 2021-03-10 05:24:35 Murcia, Spain
1520687 2021-03-08 Spain Murcia     106983 1525 2180 103278 37.9922 -1.1307 2021-03-09 05:28:19 Murcia, Spain
866968 2021-03-07 Spain Murcia     106808 1511 2180 103117 37.9922 -1.1307 2021-03-08 05:24:48 Murcia, 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]);