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

View and edit SQL

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

province_or_state

  • Baleares · 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
223215 2021-06-14 Spain Baleares     60971 842 1533 58596 39.710358 2.995148 2021-06-15 04:22:22 Baleares, Spain
215247 2021-06-13 Spain Baleares     60884 840 1533 58511 39.710358 2.995148 2021-06-14 04:22:46 Baleares, Spain
281817 2021-06-12 Spain Baleares     60884 840 1533 58511 39.710358 2.995148 2021-06-13 04:22:44 Baleares, Spain
1633916 2021-06-11 Spain Baleares     60884 840 1533 58511 39.710358 2.995148 2021-06-12 04:22:22 Baleares, Spain
663202 2021-06-10 Spain Baleares     60840 840 1533 58467 39.710358 2.995148 2021-06-11 04:23:20 Baleares, Spain
882306 2021-06-09 Spain Baleares     60804 840 1533 58431 39.710358 2.995148 2021-06-10 04:23:17 Baleares, Spain
1710305 2021-06-08 Spain Baleares     60767 840 1533 58394 39.710358 2.995148 2021-06-09 04:23:31 Baleares, Spain
1466149 2021-06-07 Spain Baleares     60728 839 1533 58356 39.710358 2.995148 2021-06-08 04:22:35 Baleares, Spain
993916 2021-06-06 Spain Baleares     60619 839 1533 58247 39.710358 2.995148 2021-06-07 04:22:51 Baleares, Spain
158706 2021-06-05 Spain Baleares     60619 839 1533 58247 39.710358 2.995148 2021-06-06 04:24:03 Baleares, Spain
1516691 2021-06-04 Spain Baleares     60619 839 1533 58247 39.710358 2.995148 2021-06-05 04:23:03 Baleares, Spain
1141002 2021-06-03 Spain Baleares     60582 839 1533 58210 39.710358 2.995148 2021-06-04 04:23:37 Baleares, Spain
427446 2021-06-02 Spain Baleares     60537 839 1533 58165 39.710358 2.995148 2021-06-03 04:23:32 Baleares, Spain
539953 2021-06-01 Spain Baleares     60502 839 1533 58130 39.710358 2.995148 2021-06-02 04:24:34 Baleares, Spain
787138 2021-05-31 Spain Baleares     60464 839 1533 58092 39.710358 2.995148 2021-06-01 04:23:09 Baleares, Spain
1330536 2021-05-30 Spain Baleares     60364 839 1533 57992 39.710358 2.995148 2021-05-31 03:08:59 Baleares, Spain
67745 2021-05-29 Spain Baleares     60364 839 1533 57992 39.710358 2.995148 2021-05-30 04:20:55 Baleares, Spain
195931 2021-05-28 Spain Baleares     60364 839 1533 57992 39.710358 2.995148 2021-05-29 04:20:41 Baleares, Spain
939190 2021-05-27 Spain Baleares     60341 839 1533 57969 39.710358 2.995148 2021-05-28 04:20:36 Baleares, Spain
1226864 2021-05-26 Spain Baleares     60301 839 1533 57929 39.710358 2.995148 2021-05-27 04:20:59 Baleares, Spain
1338503 2021-05-25 Spain Baleares     60262 839 1533 57890 39.710358 2.995148 2021-05-26 04:20:35 Baleares, Spain
203335 2021-05-24 Spain Baleares     60226 839 1533 57854 39.710358 2.995148 2021-05-25 04:21:08 Baleares, Spain
99499 2021-05-23 Spain Baleares     60137 839 1533 57765 39.710358 2.995148 2021-05-24 04:20:53 Baleares, Spain
524018 2021-05-22 Spain Baleares     60137 839 1533 57765 39.710358 2.995148 2021-05-23 04:20:51 Baleares, Spain
859713 2021-05-21 Spain Baleares     60137 839 1533 57765 39.710358 2.995148 2021-05-22 04:20:45 Baleares, Spain
721136 2021-05-20 Spain Baleares     60098 837 1533 57728 39.710358 2.995148 2021-05-21 04:20:43 Baleares, Spain
408267 2021-05-19 Spain Baleares     60072 837 1533 57702 39.710358 2.995148 2021-05-20 04:21:05 Baleares, Spain
783153 2021-05-18 Spain Baleares     60033 835 1533 57665 39.710358 2.995148 2021-05-19 04:20:42 Baleares, Spain
1423295 2021-05-17 Spain Baleares     60003 833 1533 57637 39.710358 2.995148 2021-05-18 04:20:33 Baleares, Spain
740481 2021-05-16 Spain Baleares     59895 833 1533 57529 39.710358 2.995148 2021-05-17 04:20:34 Baleares, Spain
1117014 2021-05-15 Spain Baleares     59895 833 1533 57529 39.710358 2.995148 2021-05-16 04:20:49 Baleares, Spain
1587523 2021-05-14 Spain Baleares     59895 833 1533 57529 39.710358 2.995148 2021-05-15 04:20:58 Baleares, Spain
1675440 2021-05-13 Spain Baleares     59868 831 1533 57504 39.710358 2.995148 2021-05-14 04:20:41 Baleares, Spain
803067 2021-05-12 Spain Baleares     59837 830 1533 57474 39.710358 2.995148 2021-05-13 04:20:51 Baleares, Spain
1181455 2021-05-11 Spain Baleares     59797 829 1533 57435 39.710358 2.995148 2021-05-12 04:21:29 Baleares, Spain
325245 2021-05-10 Spain Baleares     59737 829 1533 57375 39.710358 2.995148 2021-05-11 04:20:41 Baleares, Spain
604392 2021-05-09 Spain Baleares     59627 827 1533 57267 39.710358 2.995148 2021-05-10 04:20:38 Baleares, Spain
986139 2021-05-08 Spain Baleares     59627 827 1533 57267 39.710358 2.995148 2021-05-09 04:20:35 Baleares, Spain
434621 2021-05-07 Spain Baleares     59627 827 1533 57267 39.710358 2.995148 2021-05-08 04:21:04 Baleares, Spain
901402 2021-05-06 Spain Baleares     59557 825 1533 57199 39.710358 2.995148 2021-05-07 04:20:40 Baleares, Spain
71728 2021-05-05 Spain Baleares     59515 824 1533 57158 39.710358 2.995148 2021-05-06 04:20:38 Baleares, Spain
791121 2021-05-04 Spain Baleares     59463 823 1533 57107 39.710358 2.995148 2021-05-05 04:20:43 Baleares, Spain
1613651 2021-05-03 Spain Baleares     59427 822 1533 57072 39.710358 2.995148 2021-05-04 04:20:34 Baleares, Spain
886289 2021-05-02 Spain Baleares     59276 820 1533 56923 39.710358 2.995148 2021-05-03 04:20:39 Baleares, Spain
511994 2021-05-01 Spain Baleares     59276 820 1533 56923 39.710358 2.995148 2021-05-02 04:20:48 Baleares, Spain
14930 2021-04-30 Spain Baleares     59276 820 1533 56923 39.710358 2.995148 2021-05-01 04:20:47 Baleares, Spain
1125034 2021-04-29 Spain Baleares     59191 820 1533 56838 39.710358 2.995148 2021-04-30 04:21:03 Baleares, Spain
462331 2021-04-28 Spain Baleares     59139 819 1533 56787 39.710358 2.995148 2021-04-29 04:20:55 Baleares, Spain
1315037 2021-04-27 Spain Baleares     59074 819 1533 56722 39.710358 2.995148 2021-04-28 04:20:32 Baleares, Spain
1549464 2021-04-26 Spain Baleares     59016 814 1533 56669 39.710358 2.995148 2021-04-27 04:20:52 Baleares, Spain
1629931 2021-04-25 Spain Baleares     58885 798 1533 56554 39.710358 2.995148 2021-04-26 04:21:04 Baleares, Spain
354071 2021-04-24 Spain Baleares     58885 798 1533 56554 39.710358 2.995148 2021-04-25 04:20:32 Baleares, Spain
725120 2021-04-23 Spain Baleares     58885 798 1533 56554 39.710358 2.995148 2021-04-24 04:20:38 Baleares, Spain
1470132 2021-04-22 Spain Baleares     58821 793 1533 56495 39.710358 2.995148 2021-04-23 04:20:52 Baleares, Spain
1222880 2021-04-21 Spain Baleares     58756 787 1533 56436 39.710358 2.995148 2021-04-22 04:20:53 Baleares, Spain
458347 2021-04-20 Spain Baleares     58664 780 1533 57938 39.710358 2.995148 2021-04-21 04:21:14 Baleares, Spain
1300535 2021-04-19 Spain Baleares     58664 780 1533 56351 39.710358 2.995148 2021-04-20 04:20:41 Baleares, Spain
1070114 2021-04-18 Spain Baleares     58533 780 1533 56220 39.710358 2.995148 2021-04-19 04:20:57 Baleares, Spain
1045996 2021-04-17 Spain Baleares     58533 780 1533 56220 39.710358 2.995148 2021-04-18 04:20:41 Baleares, Spain
597272 2021-04-16 Spain Baleares     58533 780 1533 56220 39.710358 2.995148 2021-04-17 04:20:40 Baleares, Spain
1621688 2021-04-15 Spain Baleares     58477 780 1533 56164 39.710358 2.995148 2021-04-16 04:20:46 Baleares, Spain
951119 2021-04-14 Spain Baleares     58428 780 1533 56115 39.710358 2.995148 2021-04-15 04:20:54 Baleares, Spain
593288 2021-04-13 Spain Baleares     58380 780 1533 56067 39.710358 2.995148 2021-04-14 04:20:41 Baleares, Spain
33227 2021-04-12 Spain Baleares     58298 779 1533 55986 39.710358 2.995148 2021-04-13 04:20:37 Baleares, Spain
1372242 2021-04-11 Spain Baleares     58153 779 1533 55841 39.710358 2.995148 2021-04-12 04:21:00 Baleares, Spain
1667494 2021-04-10 Spain Baleares     58153 779 1533 55841 39.710358 2.995148 2021-04-11 04:20:56 Baleares, Spain
1160110 2021-04-09 Spain Baleares     58153 779 1533 55841 39.710358 2.995148 2021-04-10 04:20:59 Baleares, Spain
1057945 2021-04-08 Spain Baleares     58082 779 1533 55770 39.710358 2.995148 2021-04-09 04:21:13 Baleares, Spain
1500734 2021-04-07 Spain Baleares     58000 778 1533 55689 39.710358 2.995148 2021-04-08 04:21:13 Baleares, Spain
1207939 2021-04-06 Spain Baleares     57932 777 1533 55622 39.710358 2.995148 2021-04-07 04:20:53 Baleares, Spain
123240 2021-04-05 Spain Baleares     57901 777 1533 55591 39.710358 2.995148 2021-04-06 04:20:32 Baleares, Spain
1255041 2021-04-04 Spain Baleares     57809 777 1533 55499 39.710358 2.995148 2021-04-05 04:20:35 Baleares, Spain
1129018 2021-04-03 Spain Baleares     57809 777 1533 55499 39.710358 2.995148 2021-04-04 04:20:49 Baleares, Spain
270409 2021-04-02 Spain Baleares     57727 777 1533 55417 39.710358 2.995148 2021-04-03 04:20:44 Baleares, Spain
1173741 2021-04-01 Spain Baleares     57727 777 1533 55417 39.710358 2.995148 2021-04-02 04:20:36 Baleares, Spain
516052 2021-03-31 Spain Baleares     57676 777 1533 55366 39.710358 2.995148 2021-04-01 04:27:05 Baleares, Spain
289781 2021-03-30 Spain Baleares     57619 777 1533 55309 39.710358 2.995148 2021-03-31 04:26:25 Baleares, Spain
1575318 2021-03-29 Spain Baleares     57558 777 1533 55248 39.710358 2.995148 2021-03-30 04:26:23 Baleares, Spain
631595 2021-03-28 Spain Baleares     57315 777 1533 55005 39.710358 2.995148 2021-03-29 04:28:35 Baleares, Spain
608376 2021-03-27 Spain Baleares     57315 777 1533 55005 39.710358 2.995148 2021-03-28 05:28:10 Baleares, Spain
1334519 2021-03-26 Spain Baleares     57315 777 1533 55005 39.710358 2.995148 2021-03-27 05:25:04 Baleares, Spain
150958 2021-03-25 Spain Baleares     57270 777 1533 54960 39.710358 2.995148 2021-03-26 05:26:55 Baleares, Spain
1598479 2021-03-24 Spain Baleares     57130 772 1533 54825 39.710358 2.995148 2021-03-25 05:27:00 Baleares, Spain
404283 2021-03-23 Spain Baleares     57130 772 1533 54825 39.710358 2.995148 2021-03-24 05:25:40 Baleares, Spain
1387820 2021-03-22 Spain Baleares     57088 766 1533 54789 39.710358 2.995148 2021-03-23 05:26:18 Baleares, Spain
305307 2021-03-21 Spain Baleares     56881 750 1533 54598 39.710358 2.995148 2021-03-22 05:25:43 Baleares, Spain
254356 2021-03-20 Spain Baleares     56881 750 1533 54598 39.710358 2.995148 2021-03-21 05:25:44 Baleares, Spain
1231112 2021-03-19 Spain Baleares     56881 750 1533 54598 39.710358 2.995148 2021-03-20 05:25:46 Baleares, Spain
975037 2021-03-18 Spain Baleares     56881 750 1533 54598 39.710358 2.995148 2021-03-19 05:26:09 Baleares, Spain
1532672 2021-03-17 Spain Baleares     56828 742 1533 54553 39.710358 2.995148 2021-03-18 05:26:22 Baleares, Spain
55866 2021-03-16 Spain Baleares     56785 739 1533 54513 39.710358 2.995148 2021-03-17 05:25:07 Baleares, Spain
563179 2021-03-15 Spain Baleares     56752 735 1533 54484 39.710358 2.995148 2021-03-16 05:25:13 Baleares, Spain
851748 2021-03-14 Spain Baleares     56663 733 1533 54397 39.710358 2.995148 2021-03-15 05:25:51 Baleares, Spain
943173 2021-03-13 Spain Baleares     56663 733 1533 54397 39.710358 2.995148 2021-03-14 05:25:37 Baleares, Spain
1311053 2021-03-12 Spain Baleares     56663 733 1533 54397 39.710358 2.995148 2021-03-13 05:25:15 Baleares, Spain
1077891 2021-03-11 Spain Baleares     56621 733 1533 54355 39.710358 2.995148 2021-03-12 05:26:50 Baleares, Spain
955103 2021-03-10 Spain Baleares     56519 732 1533 54254 39.710358 2.995148 2021-03-11 05:25:48 Baleares, Spain
543936 2021-03-09 Spain Baleares     56476 732 1533 54211 39.710358 2.995148 2021-03-10 05:24:35 Baleares, Spain
1520674 2021-03-08 Spain Baleares     56438 731 1533 54174 39.710358 2.995148 2021-03-09 05:28:19 Baleares, Spain
866955 2021-03-07 Spain Baleares     56338 730 1533 54075 39.710358 2.995148 2021-03-08 05:24:48 Baleares, 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]);