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

View and edit SQL

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

province_or_state

  • Unknown · 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
168766 2021-06-19 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
686291 2021-06-18 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
958348 2021-06-17 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1281713 2021-06-16 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
682303 2021-06-15 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
372857 2021-06-14 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1223673 2021-06-13 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
80954 2021-06-12 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
970257 2021-06-11 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1438830 2021-06-10 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1157329 2021-06-09 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1231645 2021-06-08 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
360641 2021-06-07 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1076269 2021-06-06 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1613661 2021-06-05 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1125947 2021-06-04 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
318403 2021-06-03 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1133916 2021-06-02 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
292093 2021-06-01 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1652044 2021-05-31 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
981272 2021-05-30 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
841653 2021-05-29 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
698225 2021-05-28 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1369726 2021-05-27 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1292810 2021-05-26 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
603181 2021-05-25 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1365739 2021-05-24 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
420252 2021-05-23 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
54591 2021-05-22 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
368870 2021-05-21 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1024669 2021-05-20 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1679295 2021-05-19 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
65282 2021-05-18 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1243354 2021-05-17 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1068202 2021-05-16 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
505330 2021-05-15 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
892935 2021-05-14 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
532270 2021-05-13 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1719557 2021-05-12 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1723543 2021-05-11 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1165300 2021-05-10 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1169286 2021-05-09 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1660073 2021-05-08 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
800171 2021-05-07 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1219686 2021-05-06 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
416266 2021-05-05 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
674287 2021-05-04 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1088311 2021-05-03 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1727529 2021-05-02 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1084325 2021-05-01 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1388853 2021-04-30 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
38672 2021-04-29 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
12245 2021-04-28 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
853628 2021-04-27 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1064216 2021-04-26 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1476466 2021-04-25 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
744087 2021-04-24 Spain Unknown     0 0 0 0     2021-04-25 04:20:32 Unknown, Spain
1430886 2021-04-23 Spain Unknown     0 0 0 0     2021-04-24 04:20:38 Unknown, Spain
96715 2021-04-22 Spain Unknown     0 0 0 0     2021-04-23 04:20:52 Unknown, Spain
849642 2021-04-21 Spain Unknown     0 0 0 0     2021-04-22 04:20:53 Unknown, Spain
827260 2021-04-20 Spain Unknown     0 0 0 0     2021-04-21 04:21:14 Unknown, Spain
770971 2021-04-19 Spain Unknown     0 0 0 0     2021-04-20 04:20:41 Unknown, Spain
1416280 2021-04-18 Spain Unknown     0 0 0 0     2021-04-19 04:20:57 Unknown, Spain
985257 2021-04-17 Spain Unknown     0 0 0 0     2021-04-18 04:20:41 Unknown, Spain
238320 2021-04-16 Spain Unknown     0 0 0 0     2021-04-17 04:20:40 Unknown, Spain
580049 2021-04-15 Spain Unknown     0 0 0 0     2021-04-16 04:20:46 Unknown, Spain
1266677 2021-04-14 Spain Unknown     0 0 0 0     2021-04-15 04:20:54 Unknown, Spain
702210 2021-04-13 Spain Unknown     0 0 0 0     2021-04-14 04:20:41 Unknown, Spain
1671323 2021-04-12 Spain Unknown     0 0 0 0     2021-04-13 04:20:37 Unknown, Spain
785028 2021-04-11 Spain Unknown     0 0 0 0     2021-04-12 04:21:00 Unknown, Spain
1392839 2021-04-10 Spain Unknown     0 0 0 0     2021-04-11 04:20:56 Unknown, Spain
966270 2021-04-09 Spain Unknown     0 0 0 0     2021-04-10 04:20:59 Unknown, Spain
690274 2021-04-08 Spain Unknown     0 0 0 0     2021-04-09 04:21:13 Unknown, Spain
1277726 2021-04-07 Spain Unknown     0 0 0 0     2021-04-08 04:21:13 Unknown, Spain
88745 2021-04-06 Spain Unknown     0 0 0 0     2021-04-07 04:20:53 Unknown, Spain
123127 2021-04-05 Spain Unknown     0 0 0 0     2021-04-06 04:20:32 Unknown, Spain
73629 2021-04-04 Spain Unknown     0 0 0 0     2021-04-05 04:20:35 Unknown, Spain
792245 2021-04-03 Spain Unknown     0 0 0 0     2021-04-04 04:20:49 Unknown, Spain
1020683 2021-04-02 Spain Unknown     0 0 0 0     2021-04-03 04:20:44 Unknown, Spain
1350845 2021-04-01 Spain Unknown     0 0 0 0     2021-04-02 04:20:36 Unknown, Spain
1691231 2021-03-31 Spain Unknown     0 0 0 0     2021-04-01 04:27:05 Unknown, Spain
873600 2021-03-30 Spain Unknown     0 0 0 0     2021-03-31 04:26:25 Unknown, Spain
1400647 2021-03-29 Spain Unknown     0 0 0 0     2021-03-30 04:26:23 Unknown, Spain
1625050 2021-03-28 Spain Unknown     0 0 0 0     2021-03-29 04:28:35 Unknown, Spain
1472480 2021-03-27 Spain Unknown     0 0 0 0     2021-03-28 05:28:10 Unknown, Spain
721027 2021-03-26 Spain Unknown     0 0 0 0     2021-03-27 05:25:04 Unknown, Spain
1617646 2021-03-25 Spain Unknown     0 0 0 0     2021-03-26 05:26:55 Unknown, Spain
470307 2021-03-24 Spain Unknown     0 0 0 0     2021-03-25 05:27:00 Unknown, Spain
1585347 2021-03-23 Spain Unknown     0 0 0 0     2021-03-24 05:25:40 Unknown, Spain
717041 2021-03-22 Spain Unknown     0 0 0 0     2021-03-23 05:26:18 Unknown, Spain
1675309 2021-03-21 Spain Unknown     0 0 0 0     2021-03-22 05:25:43 Unknown, Spain
1747248 2021-03-20 Spain Unknown     0 0 0 0     2021-03-21 05:25:44 Unknown, Spain
230370 2021-03-19 Spain Unknown     0 0 0 0     2021-03-20 05:25:46 Unknown, Spain
478305 2021-03-18 Spain Unknown     0 0 0 0     2021-03-19 05:26:09 Unknown, Spain
1426900 2021-03-17 Spain Unknown     0 0 0 0     2021-03-18 05:26:22 Unknown, Spain
1593488 2021-03-16 Spain Unknown     0 0 0 0     2021-03-17 05:25:07 Unknown, Spain
1176487 2021-03-15 Spain Unknown     0 0 0 0     2021-03-16 05:25:13 Unknown, Spain
276172 2021-03-14 Spain Unknown     0 0 0 0     2021-03-15 05:25:51 Unknown, Spain
1161314 2021-03-13 Spain Unknown     0 0 0 0     2021-03-14 05:25:37 Unknown, Spain
22821 2021-03-12 Spain Unknown     0 0 0 0     2021-03-13 05:25:15 Unknown, 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]);