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

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
3676 2020-10-26 Spain Unknown     0 0 0 0     2020-10-27 04:24:45 Unknown, Spain
14106 2020-07-17 Spain Unknown     0 0 0 0     2020-07-18 04:34:45 Unknown, Spain
14946 2021-04-30 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
22043 2020-10-13 Spain Unknown     0 0 0 0     2020-10-14 04:24:05 Unknown, Spain
29259 2020-11-23 Spain Unknown     0 0 0 0     2020-11-24 05:27:31 Unknown, Spain
33243 2021-04-12 Spain Unknown     0 0 0 0     2021-04-13 04:20:37 Unknown, Spain
37210 2020-10-27 Spain Unknown     0 0 0 0     2020-10-28 04:24:39 Unknown, Spain
44292 2020-07-30 Spain Unknown     0 0 0 0     2020-07-31 04:35:18 Unknown, Spain
48369 2020-12-19 Spain Unknown     0 0 0 0     2020-12-20 05:27:32 Unknown, Spain
55067 2020-05-29 Spain Unknown     0 0 0 0     2020-05-30 02:32:48 Unknown, Spain
55882 2021-03-16 Spain Unknown     0 0 0 0     2021-03-17 05:25:07 Unknown, Spain
59863 2020-12-07 Spain Unknown     0 0 0 0     2020-12-08 05:27:42 Unknown, Spain
66819 2020-07-05 Spain Unknown     0 0 0 0     2020-07-06 04:33:57 Unknown, Spain
67761 2021-05-29 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
71744 2021-05-05 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
78823 2020-07-27 Spain Unknown     0 0 0 0     2020-07-28 04:58:43 Unknown, Spain
79650 2020-10-28 Spain Unknown     0 0 0 0     2020-10-29 04:24:49 Unknown, Spain
83613 2020-09-16 Spain Unknown     0 0 0 0     2020-09-17 04:22:00 Unknown, Spain
87574 2020-10-09 Spain Unknown     0 0 0 0     2020-10-10 04:23:57 Unknown, Spain
91551 2020-12-06 Spain Unknown     0 0 0 0     2020-12-07 05:26:14 Unknown, Spain
95531 2020-11-18 Spain Unknown     0 0 0 0     2020-11-19 05:25:23 Unknown, Spain
99515 2021-05-23 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
106605 2020-08-08 Spain Unknown     0 0 0 0     2020-08-09 04:34:54 Unknown, Spain
107443 2020-11-29 Spain Unknown     0 0 0 0     2020-11-30 05:26:13 Unknown, Spain
111408 2020-08-11 Spain Unknown     0 0 0 0     2020-08-12 04:27:29 Unknown, Spain
118460 2020-07-18 Spain Unknown     0 0 0 0     2020-07-19 04:34:58 Unknown, Spain
119282 2020-08-20 Spain Unknown     0 0 0 0     2020-08-21 04:27:41 Unknown, Spain
123256 2021-04-05 Spain Unknown     0 0 0 0     2021-04-06 04:20:32 Unknown, Spain
134013 2020-07-04 Spain Unknown     0 0 0 0     2020-07-05 04:33:46 Unknown, Spain
134285 2020-02-10 Spain       2 0 0       2020-02-09T20:33:03  
134903 2020-10-05 Spain Unknown     0 0 0 0     2020-10-06 04:23:33 Unknown, Spain
138879 2020-11-13 Spain Unknown     0 0 0 0     2020-11-14 05:25:37 Unknown, Spain
142862 2021-02-03 Spain Unknown     0 0 0 0     2021-02-04 05:22:26 Unknown, Spain
146846 2021-02-09 Spain Unknown     0 0 0 0     2021-02-10 05:22:41 Unknown, Spain
150974 2021-03-25 Spain Unknown     0 0 0 0     2021-03-26 05:26:55 Unknown, Spain
157888 2020-06-22 Spain Unknown     0 0 0 0     2020-06-23 04:33:22 Unknown, Spain
158722 2021-06-05 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
162704 2021-01-25 Spain Unknown     0 0 0 0     2021-01-26 05:22:02 Unknown, Spain
166766 2021-02-24 Spain Unknown     0 0 0 0     2021-02-25 05:24:57 Unknown, Spain
170731 2020-09-02 Spain Unknown     0 0 0 0     2020-09-03 04:28:22 Unknown, Spain
180219 2020-06-04 Spain Unknown     0 0 0 0     2020-06-05 02:33:06 Unknown, Spain
183957 2020-06-12 Spain Unknown     0 0 0 0     2020-06-13 03:33:14 Unknown, Spain
187933 2021-01-30 Spain Unknown     0 0 0 0     2021-01-31 05:22:42 Unknown, Spain
191899 2020-08-17 Spain Unknown     0 0 0 0     2020-08-18 04:27:56 Unknown, Spain
195309 2020-02-11 Spain       2 0 0       2020-02-09T20:33:03  
195947 2021-05-28 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
203351 2021-05-24 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
210438 2020-08-04 Spain Unknown     0 0 0 0     2020-08-05 04:34:43 Unknown, Spain
211277 2021-02-17 Spain Unknown     0 0 0 0     2021-02-18 05:22:58 Unknown, Spain
215263 2021-06-13 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
219245 2021-02-15 Spain Unknown     0 0 0 0     2021-02-16 05:24:38 Unknown, Spain
223231 2021-06-14 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
227213 2021-01-29 Spain Unknown     0 0 0 0     2021-01-30 05:22:49 Unknown, Spain
231179 2020-08-18 Spain Unknown     0 0 0 0     2020-08-19 04:27:00 Unknown, Spain
238086 2020-06-23 Spain Unknown     0 0 0 0     2020-06-24 04:33:28 Unknown, Spain
241901 2020-07-10 Spain Unknown     0 0 0 0     2020-07-11 04:34:26 Unknown, Spain
242732 2020-11-22 Spain Unknown     0 0 0 0     2020-11-23 05:25:26 Unknown, Spain
249608 2020-06-10 Spain Unknown     0 0 0 0     2020-06-11 03:33:41 Unknown, Spain
253530 2020-07-22 Spain Unknown     0 0 0 0     2020-07-23 05:15:04 Unknown, Spain
254372 2021-03-20 Spain Unknown     0 0 0 0     2021-03-21 05:25:44 Unknown, Spain
258337 2020-08-31 Spain Unknown     0 0 0 0     2020-09-01 04:28:31 Unknown, Spain
262313 2020-12-15 Spain Unknown     0 0 0 0     2020-12-16 05:28:04 Unknown, Spain
266443 2020-11-02 Spain Unknown     0 0 0 0     2020-11-03 06:00:16 Unknown, Spain
270425 2021-04-02 Spain Unknown     0 0 0 0     2021-04-03 04:20:44 Unknown, Spain
277847 2021-02-14 Spain Unknown     0 0 0 0     2021-02-15 05:24:49 Unknown, Spain
281833 2021-06-12 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
285813 2020-12-03 Spain Unknown     0 0 0 0     2020-12-04 05:27:27 Unknown, Spain
289797 2021-03-30 Spain Unknown     0 0 0 0     2021-03-31 04:26:25 Unknown, Spain
293779 2021-01-10 Spain Unknown     0 0 0 0     2021-01-11 05:21:50 Unknown, Spain
297744 2020-09-09 Spain Unknown     0 0 0 0     2020-09-10 04:29:01 Unknown, Spain
305323 2021-03-21 Spain Unknown     0 0 0 0     2021-03-22 05:25:43 Unknown, Spain
309307 2021-03-02 Spain Unknown     0 0 0 0     2021-03-03 05:23:28 Unknown, Spain
313289 2021-01-16 Spain Unknown     0 0 0 0     2021-01-17 05:22:17 Unknown, Spain
317257 2020-10-21 Spain Unknown     0 0 0 0     2020-10-22 04:24:27 Unknown, Spain
321221 2020-09-22 Spain Unknown     0 0 0 0     2020-09-23 04:23:00 Unknown, Spain
325261 2021-05-10 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
332067 2020-06-02 Spain Unknown     0 0 0 0     2020-06-03 02:33:13 Unknown, Spain
335814 2020-06-17 Spain Unknown     0 0 0 0     2020-06-18 04:33:18 Unknown, Spain
342840 2020-11-01 Spain Unknown     0 0 0 0     2020-11-02 05:25:04 Unknown, Spain
346803 2020-08-16 Spain Unknown     0 0 0 0     2020-08-17 04:27:20 Unknown, Spain
354087 2021-04-24 Spain Unknown     0 0 0 0     2021-04-25 04:20:32 Unknown, Spain
358052 2020-08-28 Spain Unknown     0 0 0 0     2020-08-29 04:28:19 Unknown, Spain
362025 2021-01-03 Spain Unknown     0 0 0 0     2021-01-04 05:22:02 Unknown, Spain
365990 2020-09-07 Spain Unknown     0 0 0 0     2020-09-08 04:28:25 Unknown, Spain
372952 2020-07-11 Spain Unknown     0 0 0 0     2020-07-12 04:34:30 Unknown, Spain
376772 2020-07-13 Spain Unknown     0 0 0 0     2020-07-14 04:34:46 Unknown, Spain
380565 2020-06-26 Spain Unknown     0 0 0 0     2020-06-27 04:33:35 Unknown, Spain
381398 2021-02-19 Spain Unknown     0 0 0 0     2021-02-20 05:22:51 Unknown, Spain
385364 2020-09-25 Spain Unknown     0 0 0 0     2020-09-26 04:23:00 Unknown, Spain
392400 2021-02-13 Spain Unknown     0 0 0 0     2021-02-14 05:23:43 Unknown, Spain
399491 2020-08-05 Spain Unknown     0 0 0 0     2020-08-06 04:35:02 Unknown, Spain
400316 2020-11-09 Spain Unknown     0 0 0 0     2020-11-10 05:40:07 Unknown, Spain
404299 2021-03-23 Spain Unknown     0 0 0 0     2021-03-24 05:25:40 Unknown, Spain
408283 2021-05-19 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
418979 2020-08-06 Spain Unknown     0 0 0 0     2020-08-07 04:35:11 Unknown, Spain
423476 2021-01-28 Spain Unknown     0 0 0 0     2021-01-29 05:22:23 Unknown, Spain
427462 2021-06-02 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
434637 2021-05-07 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
441718 2020-07-28 Spain Unknown     0 0 0 0     2020-07-29 04:35:11 Unknown, Spain
445644 2020-07-19 Spain Unknown     0 0 0 0     2020-07-20 05:34:40 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]);