⚠️ 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,138 rows where country_or_region = "Spain" sorted by deaths

View and edit SQL

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

country_or_region

  • Spain · 8,138
Link rowid day country_or_region province_or_state admin2 fips confirmed deaths ▼ recovered active latitude longitude last_update combined_key
598 2020-09-15 Spain Unknown     0 0 0 0     2020-09-16 04:22:53 Unknown, Spain
4576 2020-12-05 Spain Unknown     0 0 0 0     2020-12-06 05:26:18 Unknown, Spain
11412 2020-06-09 Spain Unknown     0 0 0 0     2020-06-10 04:07:00 Unknown, Spain
12245 2021-04-28 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
21783 2020-06-17 Spain Unknown     0 0 0 0     2020-06-18 04:33:18 Unknown, Spain
22821 2021-03-12 Spain Unknown     0 0 0 0     2021-03-13 05:25:15 Unknown, Spain
29910 2020-08-02 Spain Unknown     0 0 0 0     2020-08-03 04:34:35 Unknown, Spain
30733 2020-10-09 Spain Unknown     0 0 0 0     2020-10-10 04:23:57 Unknown, Spain
34696 2020-08-21 Spain Unknown     0 0 0 0     2020-08-22 04:27:49 Unknown, Spain
38672 2021-04-29 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
42658 2021-02-26 Spain Unknown     0 0 0 0     2021-02-27 05:22:28 Unknown, Spain
46641 2020-12-31 Spain Unknown     0 0 0 0     2021-01-01 05:23:07 Unknown, Spain
50609 2020-09-24 Spain Unknown     0 0 0 0     2020-09-25 04:23:00 Unknown, Spain
54591 2021-05-22 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
68687 2020-03-01 Spain       84 0 2   40.0 -4.0 2020-03-01T23:33:03  
69395 2021-01-08 Spain Unknown     0 0 0 0     2021-01-09 05:22:18 Unknown, Spain
72823 2020-02-02 Spain       1 0 0       2020-02-01T23:43:02  
73629 2021-04-04 Spain Unknown     0 0 0 0     2021-04-05 04:20:35 Unknown, Spain
80290 2020-02-25 Spain       6 0 2       2020-02-25T21:33:02  
80954 2021-06-12 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
87909 2020-07-03 Spain Unknown     0 0 0 0     2020-07-04 04:33:51 Unknown, Spain
88745 2021-04-06 Spain Unknown     0 0 0 0     2021-04-07 04:20:53 Unknown, Spain
92729 2021-01-09 Spain Unknown     0 0 0 0     2021-01-10 05:22:12 Unknown, Spain
96715 2021-04-22 Spain Unknown     0 0 0 0     2021-04-23 04:20:52 Unknown, Spain
100751 2021-02-23 Spain Unknown     0 0 0 0     2021-02-24 05:29:16 Unknown, Spain
104719 2020-09-25 Spain Unknown     0 0 0 0     2020-09-26 04:23:00 Unknown, Spain
108698 2020-12-28 Spain Unknown     0 0 0 0     2020-12-29 05:22:37 Unknown, Spain
112667 2020-10-26 Spain Unknown     0 0 0 0     2020-10-27 04:24:45 Unknown, Spain
116651 2021-02-21 Spain Unknown     0 0 0 0     2021-02-22 05:24:21 Unknown, Spain
123127 2021-04-05 Spain Unknown     0 0 0 0     2021-04-06 04:20:32 Unknown, Spain
127095 2020-09-29 Spain Unknown     0 0 0 0     2020-09-30 04:23:33 Unknown, Spain
134183 2020-08-06 Spain Unknown     0 0 0 0     2020-08-07 04:35:11 Unknown, Spain
135024 2021-01-19 Spain Unknown     0 0 0 0     2021-01-20 05:21:54 Unknown, Spain
142111 2020-07-30 Spain Unknown     0 0 0 0     2020-07-31 04:35:18 Unknown, Spain
145938 2020-07-11 Spain Unknown     0 0 0 0     2020-07-12 04:34:30 Unknown, Spain
149702 2020-06-21 Spain Unknown     0 0 0 0     2020-06-22 04:33:20 Unknown, Spain
150533 2020-11-19 Spain Unknown     0 0 0 0     2020-11-20 05:26:28 Unknown, Spain
154571 2020-12-23 Spain Unknown     0 0 0 0     2020-12-24 05:23:04 Unknown, Spain
161457 2020-11-02 Spain Unknown     0 0 0 0     2020-11-03 06:00:16 Unknown, Spain
167843 2020-05-19 Spain Unknown     0 0 150376 -150376     2020-05-20 02:32:19 Unknown, Spain
168766 2021-06-19 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
172749 2021-03-09 Spain Unknown     0 0 0 0     2021-03-10 05:24:35 Unknown, Spain
180273 2020-12-04 Spain Unknown     0 0 0 0     2020-12-05 05:27:36 Unknown, Spain
187106 2020-06-07 Spain Unknown     0 0 0 0     2020-06-08 03:33:22 Unknown, Spain
187939 2021-02-20 Spain Unknown     0 0 0 0     2021-02-21 05:24:33 Unknown, Spain
195028 2020-08-03 Spain Unknown     0 0 0 0     2020-08-04 04:41:59 Unknown, Spain
195850 2020-08-28 Spain Unknown     0 0 0 0     2020-08-29 04:28:19 Unknown, Spain
199808 2020-08-24 Spain Unknown     0 0 0 0     2020-08-25 04:28:02 Unknown, Spain
207209 2021-02-22 Spain Unknown     0 0 0 0     2021-02-23 05:23:41 Unknown, Spain
211179 2020-11-08 Spain Unknown     0 0 0 0     2020-11-09 05:25:45 Unknown, Spain
215162 2021-01-13 Spain Unknown     0 0 0 0     2021-01-14 05:22:32 Unknown, Spain
225550 2020-07-07 Spain Unknown     0 0 0 0     2020-07-08 05:33:48 Unknown, Spain
226384 2020-11-28 Spain Unknown     0 0 0 0     2020-11-29 05:25:55 Unknown, Spain
230370 2021-03-19 Spain Unknown     0 0 0 0     2021-03-20 05:25:46 Unknown, Spain
234338 2020-09-21 Spain Unknown     0 0 0 0     2020-09-22 04:23:00 Unknown, Spain
238320 2021-04-16 Spain Unknown     0 0 0 0     2021-04-17 04:20:40 Unknown, Spain
242287 2020-08-22 Spain Unknown     0 0 0 0     2020-08-23 04:27:48 Unknown, Spain
252314 2020-05-27 Spain Unknown     0 0 0 0     2020-05-28 02:32:31 Unknown, Spain
252575 2020-02-07 Spain       1 0 0       2020-02-01T23:43:02  
253204 2021-03-10 Spain Unknown     0 0 0 0     2021-03-11 05:25:48 Unknown, Spain
257189 2021-02-16 Spain Unknown     0 0 0 0     2021-02-17 05:23:10 Unknown, Spain
261173 2020-11-29 Spain Unknown     0 0 0 0     2020-11-30 05:26:13 Unknown, Spain
268131 2020-07-05 Spain Unknown     0 0 0 0     2020-07-06 04:33:57 Unknown, Spain
272188 2020-10-19 Spain Unknown     0 0 0 0     2020-10-20 04:24:22 Unknown, Spain
276172 2021-03-14 Spain Unknown     0 0 0 0     2021-03-15 05:25:51 Unknown, Spain
280157 2021-01-23 Spain Unknown     0 0 0 0     2021-01-24 05:22:35 Unknown, Spain
284126 2020-10-02 Spain Unknown     0 0 0 0     2020-10-03 04:23:40 Unknown, Spain
288106 2021-01-07 Spain Unknown     0 0 0 0     2021-01-08 05:22:42 Unknown, Spain
292093 2021-06-01 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
296075 2020-12-13 Spain Unknown     0 0 0 0     2020-12-14 05:26:27 Unknown, Spain
299499 2020-02-18 Spain       2 0 2       2020-02-15T17:23:04  
303331 2020-11-26 Spain Unknown     0 0 0 0     2020-11-27 05:26:53 Unknown, Spain
310224 2020-05-23 Spain Unknown     0 0 150376 -150376     2020-05-24 02:32:43 Unknown, Spain
311019 2020-08-31 Spain Unknown     0 0 0 0     2020-09-01 04:28:31 Unknown, Spain
317588 2020-05-20 Spain Unknown     0 0 150376 -150376     2020-05-21 02:32:48 Unknown, Spain
318403 2021-06-03 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
322384 2020-11-16 Spain Unknown     0 0 0 0     2020-11-17 05:25:54 Unknown, Spain
332683 2020-08-10 Spain Unknown     0 0 0 0     2020-08-11 04:35:08 Unknown, Spain
336954 2021-03-05 Spain Unknown     0 0 0 0     2021-03-06 04:23:41 Unknown, Spain
343870 2020-06-22 Spain Unknown     0 0 0 0     2020-06-23 04:33:22 Unknown, Spain
344686 2020-08-30 Spain Unknown     0 0 0 0     2020-08-31 04:28:27 Unknown, Spain
348663 2021-02-27 Spain Unknown     0 0 0 0     2021-02-28 05:22:20 Unknown, Spain
352692 2021-01-06 Spain Unknown     0 0 0 0     2021-01-07 05:22:03 Unknown, Spain
356659 2020-09-18 Spain Unknown     0 0 0 0     2020-09-19 04:22:00 Unknown, Spain
360641 2021-06-07 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
364622 2020-11-13 Spain Unknown     0 0 0 0     2020-11-14 05:25:37 Unknown, Spain
368870 2021-05-21 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
376823 2020-09-07 Spain Unknown     0 0 0 0     2020-09-08 04:28:25 Unknown, Spain
383696 2020-06-10 Spain Unknown     0 0 0 0     2020-06-11 03:33:41 Unknown, Spain
383972 2020-02-01 Spain       1 0 0       2/1/2020 2:13  
384584 2020-10-17 Spain Unknown     0 0 0 0     2020-10-18 04:24:25 Unknown, Spain
391673 2020-08-09 Spain Unknown     0 0 0 0     2020-08-10 04:34:55 Unknown, Spain
392497 2020-09-11 Spain Unknown     0 0 0 0     2020-09-12 04:25:05 Unknown, Spain
396462 2020-11-01 Spain Unknown     0 0 0 0     2020-11-02 05:25:04 Unknown, Spain
399884 2020-02-11 Spain       2 0 0       2020-02-09T20:33:03  
400523 2021-03-04 Spain Unknown     0 0 0 0     2021-03-05 05:26:29 Unknown, Spain
404490 2020-09-02 Spain Unknown     0 0 0 0     2020-09-03 04:28:22 Unknown, Spain
408452 2020-09-08 Spain Unknown     0 0 0 0     2020-09-09 04:28:48 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]);