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

8,038 rows where country_or_region = "Spain" sorted by active

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Spain · 8,038
Link rowid day country_or_region province_or_state admin2 fips confirmed deaths recovered active ▼ latitude longitude last_update combined_key
43903 2020-07-30 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-07-31 04:35:18 Ceuta, Spain
66622 2020-07-05 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-06 04:33:57 Melilla, Spain
67083 2020-02-27 Spain       15 0 2       2020-02-27T13:23:02  
106215 2020-08-08 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-09 04:34:54 Ceuta, Spain
126667 2020-02-28 Spain       32 0 2       2020-02-28T15:33:03  
126744 2020-03-14 Spain       6391 195 517   40.4637 -3.7492 2020-03-14T22:13:11  
133816 2020-07-04 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-05 04:33:46 Melilla, Spain
134285 2020-02-10 Spain       2 0 0       2020-02-09T20:33:03  
150246 2020-03-02 Spain       120 0 2   40.0 -4.0 2020-03-02T14:43:05  
166127 2020-02-16 Spain       2 0 2       2020-02-15T17:23:04  
195309 2020-02-11 Spain       2 0 0       2020-02-09T20:33:03  
210048 2020-08-04 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-05 04:34:43 Ceuta, Spain
241703 2020-07-10 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-11 04:34:26 Melilla, Spain
265706 2020-03-04 Spain       222 2 2   40.0 -4.0 2020-03-04T20:43:02  
301130 2020-03-05 Spain       259 3 2   40.0 -4.0 2020-03-05T17:43:03  
372754 2020-07-11 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-12 04:34:30 Melilla, Spain
376574 2020-07-13 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-14 04:34:46 Melilla, Spain
399101 2020-08-05 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-06 04:35:02 Ceuta, Spain
414953 2020-03-21 Spain       25374 1375 2125   40.4637 -3.7492 2020-03-21T13:13:30  
418589 2020-08-06 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-07 04:35:11 Ceuta, Spain
419207 2020-03-18 Spain       13910 623 1081   40.4637 -3.7492 2020-03-18T13:13:13  
419499 2020-03-09 Spain       1073 28 32   40.0 -4.0 2020-03-09T18:13:11  
515441 2020-02-08 Spain       1 0 0       2020-02-01T23:43:02  
527406 2020-03-15 Spain       7798 289 517   40.4637 -3.7492 2020-03-15T18:20:18  
573855 2020-08-09 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-10 04:34:55 Ceuta, Spain
581860 2020-07-14 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-15 04:34:39 Melilla, Spain
589614 2020-03-13 Spain       5232 133 193   40.4637 -3.7492 2020-03-11T20:00:00  
622458 2020-08-02 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-03 04:34:35 Ceuta, Spain
638308 2020-08-03 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-04 04:41:59 Ceuta, Spain
646894 2020-03-03 Spain       165 1 2   40.0 -4.0 2020-03-03T23:53:03  
647080 2020-02-03 Spain       1 0 0       2020-02-01T23:43:02  
650479 2020-07-03 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-04 04:33:51 Melilla, Spain
685845 2020-07-12 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-13 04:43:04 Melilla, Spain
762513 2020-03-20 Spain       20410 1043 1588   40.4637 -3.7492 2020-03-20T17:43:03  
782137 2020-07-07 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-08 05:33:48 Melilla, Spain
863151 2020-02-14 Spain       2 0 0       2020-02-09T20:33:03  
889731 2020-02-23 Spain       2 0 2       2020-02-15T17:23:04  
923204 2020-07-06 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-07 04:34:00 Melilla, Spain
923623 2020-03-17 Spain       11748 533 1028   40.4637 -3.7492 2020-03-17T20:53:02  
965781 2020-08-07 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-08 04:34:53 Ceuta, Spain
966454 2020-02-24 Spain       2 0 2       2020-02-15T17:23:04  
1069299 2020-03-12 Spain       2277 55 183   40.0 -4.0 2020-03-12T01:17:58  
1073553 2020-02-19 Spain       2 0 2       2020-02-15T17:23:04  
1073630 2020-02-18 Spain       2 0 2       2020-02-15T17:23:04  
1073670 2020-03-07 Spain       500 10 30   40.0 -4.0 2020-03-07T17:43:05  
1085294 2020-03-01 Spain       84 0 2   40.0 -4.0 2020-03-01T23:33:03  
1104097 2020-07-09 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-10 04:34:24 Melilla, Spain
1124423 2020-02-01 Spain       1 0 0       2/1/2020 2:13  
1169913 2020-02-15 Spain       2 0 2       2020-02-15T17:23:04  
1203907 2020-02-07 Spain       1 0 0       2020-02-01T23:43:02  
1230309 2020-03-10 Spain       1695 35 32   40.0 -4.0 2020-03-10T23:53:02  
1250280 2020-03-06 Spain       400 5 2   40.0 -4.0 2020-03-06T20:13:13  
1281574 2020-02-13 Spain       2 0 0       2020-02-09T20:33:03  
1318476 2020-02-20 Spain       2 0 2       2020-02-15T17:23:04  
1325509 2020-07-31 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-01 04:36:27 Ceuta, Spain
1329519 2020-07-08 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-09 04:34:23 Melilla, Spain
1352183 2020-08-01 Spain Ceuta     166 4 163   35.8894 -5.3213 2020-08-02 04:34:47 Ceuta, Spain
1371614 2020-02-22 Spain       2 0 2       2020-02-15T17:23:04  
1430722 2020-02-06 Spain       1 0 0       2020-02-01T23:43:02  
1430747 2020-03-08 Spain       673 17 30   40.0 -4.0 2020-03-08T20:33:02  
1450878 2020-02-29 Spain       45 0 2       2020-02-29T19:13:08  
1485273 2020-02-17 Spain       2 0 2       2020-02-15T17:23:04  
1512089 2020-02-09 Spain       2 0 0       2020-02-09T20:33:03  
1536102 2020-02-26 Spain       13 0 2       2020-02-26T20:43:02  
1539331 2020-03-11 Spain       2277 54 183   40.0 -4.0 2020-03-11T20:53:02  
1563731 2020-02-12 Spain       2 0 0       2020-02-09T20:33:03  
1578705 2020-03-16 Spain       9942 342 530   40.4637 -3.7492 2020-03-16T20:13:11  
1617097 2020-02-04 Spain       1 0 0       2020-02-01T23:43:02  
1629040 2020-03-19 Spain       17963 830 1107   40.4637 -3.7492 2020-03-19T20:13:08  
1649112 2020-02-21 Spain       2 0 2       2020-02-15T17:23:04  
1649202 2020-02-05 Spain       1 0 0       2020-02-01T23:43:02  
1649271 2020-02-02 Spain       1 0 0       2020-02-01T23:43:02  
1713739 2020-02-25 Spain       6 0 2       2020-02-25T21:33:02  
492737 2020-05-21 Spain Unknown     0 0 150376 -150376     2020-05-22 02:36:51 Unknown, Spain
618933 2020-05-22 Spain Unknown     0 0 150376 -150376     2020-05-23 02:32:42 Unknown, Spain
713120 2020-05-20 Spain Unknown     0 0 150376 -150376     2020-05-21 02:32:48 Unknown, Spain
881509 2020-05-25 Spain Unknown     0 0 150376 -150376     2020-05-26 02:32:35 Unknown, Spain
1077095 2020-05-23 Spain Unknown     0 0 150376 -150376     2020-05-24 02:32:43 Unknown, Spain
1166512 2020-05-19 Spain Unknown     0 0 150376 -150376     2020-05-20 02:32:19 Unknown, Spain
1454179 2020-05-24 Spain Unknown     0 0 150376 -150376     2020-05-25 02:32:44 Unknown, Spain
353240 2020-05-18 Spain Pais Vasco     13422 1466 16160 -4204 42.9896 -2.6189 2020-05-19 02:32:18 Pais Vasco, Spain
1159251 2020-05-26 Spain Pais Vasco     13486 1424 16160 -4098 42.9896 -2.6189 2020-05-27 02:32:31 Pais Vasco, Spain
1207080 2020-05-27 Spain Pais Vasco     13486 1424 16160 -4098 42.9896 -2.6189 2020-05-28 02:32:31 Pais Vasco, Spain
1273282 2020-05-28 Spain Pais Vasco     13489 1424 16160 -4095 42.9896 -2.6189 2020-05-29 02:32:50 Pais Vasco, Spain
54977 2020-05-29 Spain Pais Vasco     13494 1424 16160 -4090 42.9896 -2.6189 2020-05-30 02:32:48 Pais Vasco, Spain
1039059 2020-05-30 Spain Pais Vasco     13506 1424 16160 -4078 42.9896 -2.6189 2020-05-31 02:32:45 Pais Vasco, Spain
1465258 2020-05-31 Spain Pais Vasco     13508 1424 16160 -4076 42.9896 -2.6189 2020-06-01 02:32:46 Pais Vasco, Spain
762182 2020-06-01 Spain Pais Vasco     13511 1424 16160 -4073 42.9896 -2.6189 2020-06-02 02:33:08 Pais Vasco, Spain
331948 2020-06-02 Spain Pais Vasco     13513 1424 16160 -4071 42.9896 -2.6189 2020-06-03 02:33:13 Pais Vasco, Spain
1027551 2020-06-03 Spain Pais Vasco     13523 1424 16160 -4061 42.9896 -2.6189 2020-06-04 02:33:14 Pais Vasco, Spain
180100 2020-06-04 Spain Pais Vasco     13527 1424 16160 -4057 42.9896 -2.6189 2020-06-05 02:33:06 Pais Vasco, Spain
1261764 2020-06-05 Spain Pais Vasco     13529 1424 16160 -4055 42.9896 -2.6189 2020-06-06 02:33:00 Pais Vasco, Spain
1461678 2020-06-06 Spain Pais Vasco     13535 1424 16160 -4049 42.9896 -2.6189 2020-06-07 03:53:30 Pais Vasco, Spain
1378967 2020-06-07 Spain Pais Vasco     13542 1424 16160 -4042 42.9896 -2.6189 2020-06-08 03:33:22 Pais Vasco, Spain
1394547 2020-06-08 Spain Pais Vasco     13548 1424 16160 -4036 42.9896 -2.6189 2020-06-09 03:33:03 Pais Vasco, Spain
1188246 2020-06-19 Spain Pais Vasco     13679 1554 16160 -4035 42.9896 -2.6189 2020-06-20 04:33:19 Pais Vasco, Spain
1321844 2020-06-09 Spain Pais Vasco     13555 1424 16160 -4029 42.9896 -2.6189 2020-06-10 04:07:00 Pais Vasco, Spain
1218718 2020-06-20 Spain Pais Vasco     13693 1555 16160 -4022 42.9896 -2.6189 2020-06-21 04:33:19 Pais Vasco, Spain
758518 2020-06-21 Spain Pais Vasco     13708 1555 16160 -4007 42.9896 -2.6189 2020-06-22 04:33:20 Pais Vasco, Spain
157756 2020-06-22 Spain Pais Vasco     13715 1555 16160 -4000 42.9896 -2.6189 2020-06-23 04:33:22 Pais Vasco, 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]);