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

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 ▼
22022 2020-03-06 Spain       400 5 2   40.0 -4.0 2020-03-06T20:13:13  
64389 2020-03-17 Spain       11748 533 1028   40.4637 -3.7492 2020-03-17T20:53:02  
68687 2020-03-01 Spain       84 0 2   40.0 -4.0 2020-03-01T23:33:03  
72823 2020-02-02 Spain       1 0 0       2020-02-01T23:43:02  
72859 2020-03-05 Spain       259 3 2   40.0 -4.0 2020-03-05T17:43:03  
80290 2020-02-25 Spain       6 0 2       2020-02-25T21:33:02  
179367 2020-03-19 Spain       17963 830 1107   40.4637 -3.7492 2020-03-19T20:13:08  
252575 2020-02-07 Spain       1 0 0       2020-02-01T23:43:02  
299499 2020-02-18 Spain       2 0 2       2020-02-15T17:23:04  
306703 2020-03-21 Spain       25374 1375 2125   40.4637 -3.7492 2020-03-21T13:13:30  
367996 2020-03-15 Spain       7798 289 517   40.4637 -3.7492 2020-03-15T18:20:18  
383972 2020-02-01 Spain       1 0 0       2/1/2020 2:13  
399884 2020-02-11 Spain       2 0 0       2020-02-09T20:33:03  
477677 2020-02-04 Spain       1 0 0       2020-02-01T23:43:02  
523910 2020-02-09 Spain       2 0 0       2020-02-09T20:33:03  
527961 2020-02-06 Spain       1 0 0       2020-02-01T23:43:02  
629415 2020-02-26 Spain       13 0 2       2020-02-26T20:43:02  
643105 2020-03-18 Spain       13910 623 1081   40.4637 -3.7492 2020-03-18T13:13:13  
655327 2020-02-17 Spain       2 0 2       2020-02-15T17:23:04  
677720 2020-02-08 Spain       1 0 0       2020-02-01T23:43:02  
766258 2020-03-02 Spain       120 0 2   40.0 -4.0 2020-03-02T14:43:05  
803580 2020-02-29 Spain       45 0 2       2020-02-29T19:13:08  
826286 2020-03-14 Spain       6391 195 517   40.4637 -3.7492 2020-03-14T22:13:11  
826581 2020-02-27 Spain       15 0 2       2020-02-27T13:23:02  
864950 2020-03-13 Spain       5232 133 193   40.4637 -3.7492 2020-03-11T20:00:00  
933942 2020-03-07 Spain       500 10 30   40.0 -4.0 2020-03-07T17:43:05  
996173 2020-03-04 Spain       222 2 2   40.0 -4.0 2020-03-04T20:43:02  
996366 2020-02-16 Spain       2 0 2       2020-02-15T17:23:04  
1071615 2020-02-28 Spain       32 0 2       2020-02-28T15:33:03  
1079696 2020-02-22 Spain       2 0 2       2020-02-15T17:23:04  
1091739 2020-02-23 Spain       2 0 2       2020-02-15T17:23:04  
1156676 2020-02-24 Spain       2 0 2       2020-02-15T17:23:04  
1183846 2020-03-12 Spain       2277 55 183   40.0 -4.0 2020-03-12T01:17:58  
1191196 2020-03-09 Spain       1073 28 32   40.0 -4.0 2020-03-09T18:13:11  
1274038 2020-03-03 Spain       165 1 2   40.0 -4.0 2020-03-03T23:53:03  
1277085 2020-02-14 Spain       2 0 0       2020-02-09T20:33:03  
1285136 2020-02-15 Spain       2 0 2       2020-02-15T17:23:04  
1350217 2020-02-03 Spain       1 0 0       2020-02-01T23:43:02  
1442253 2020-02-10 Spain       2 0 0       2020-02-09T20:33:03  
1522672 2020-03-20 Spain       20410 1043 1588   40.4637 -3.7492 2020-03-20T17:43:03  
1542126 2020-02-12 Spain       2 0 0       2020-02-09T20:33:03  
1588722 2020-03-10 Spain       1695 35 32   40.0 -4.0 2020-03-10T23:53:02  
1596861 2020-03-16 Spain       9942 342 530   40.4637 -3.7492 2020-03-16T20:13:11  
1597189 2020-02-19 Spain       2 0 2       2020-02-15T17:23:04  
1597276 2020-02-05 Spain       1 0 0       2020-02-01T23:43:02  
1659432 2020-02-20 Spain       2 0 2       2020-02-15T17:23:04  
1710530 2020-02-13 Spain       2 0 0       2020-02-09T20:33:03  
1714532 2020-03-08 Spain       673 17 30   40.0 -4.0 2020-03-08T20:33:02  
1718726 2020-03-11 Spain       2277 54 183   40.0 -4.0 2020-03-11T20:53:02  
1738881 2020-02-21 Spain       2 0 2       2020-02-15T17:23:04  
579 2020-09-15 Spain Andalusia     43678 1614 10671 31393 37.5443 -4.7278 2020-09-16 04:22:53 Andalusia, Spain
4557 2020-12-05 Spain Andalusia     238783 4296 10671 223816 37.5443 -4.7278 2020-12-06 05:26:18 Andalusia, Spain
11004 2020-06-09 Spain Andalusia     12791 1404 10671 716 37.5443 -4.7278 2020-06-10 04:07:00 Andalusia, Spain
12226 2021-04-28 Spain Andalusia     548238 9612 10671 527955 37.5443 -4.7278 2021-04-29 04:20:55 Andalusia, Spain
21332 2020-06-17 Spain Andalusia     12839 1404 10671 764 37.5443 -4.7278 2020-06-18 04:33:18 Andalusia, Spain
22802 2021-03-12 Spain Andalusia     488872 8804 10671 469397 37.5443 -4.7278 2021-03-13 05:25:15 Andalusia, Spain
29450 2020-08-02 Spain Andalusia     15107 1435 10671 3001 37.5443 -4.7278 2020-08-03 04:34:35 Andalusia, Spain
30714 2020-10-09 Spain Andalusia     74620 1979 10671 61970 37.5443 -4.7278 2020-10-10 04:23:57 Andalusia, Spain
34677 2020-08-21 Spain Andalusia     22825 1460 10671 10694 37.5443 -4.7278 2020-08-22 04:27:49 Andalusia, Spain
38653 2021-04-29 Spain Andalusia     549722 9617 10671 529434 37.5443 -4.7278 2021-04-30 04:21:03 Andalusia, Spain
42639 2021-02-26 Spain Andalusia     476822 8328 10671 457823 37.5443 -4.7278 2021-02-27 05:22:28 Andalusia, Spain
46622 2020-12-31 Spain Andalusia     264371 5123 10671 248577 37.5443 -4.7278 2021-01-01 05:23:07 Andalusia, Spain
50590 2020-09-24 Spain Andalusia     53725 1714 10671 41340 37.5443 -4.7278 2020-09-25 04:23:00 Andalusia, Spain
54572 2021-05-22 Spain Andalusia     574048 9856 10671 553521 37.5443 -4.7278 2021-05-23 04:20:51 Andalusia, Spain
65263 2021-05-18 Spain Andalusia     570363 9825 10671 549867 37.5443 -4.7278 2021-05-19 04:20:42 Andalusia, Spain
69376 2021-01-08 Spain Andalusia     276669 5251 10671 260747 37.5443 -4.7278 2021-01-09 05:22:18 Andalusia, Spain
73610 2021-04-04 Spain Andalusia     508174 9214 10671 488289 37.5443 -4.7278 2021-04-05 04:20:35 Andalusia, Spain
80935 2021-06-12 Spain Andalusia     598947 9975 10671 578301 37.5443 -4.7278 2021-06-13 04:22:44 Andalusia, Spain
87459 2020-07-03 Spain Andalusia     13205 1433 10671 1101 37.5443 -4.7278 2020-07-04 04:33:51 Andalusia, Spain
88726 2021-04-06 Spain Andalusia     511920 9276 10671 491973 37.5443 -4.7278 2021-04-07 04:20:53 Andalusia, Spain
92710 2021-01-09 Spain Andalusia     276669 5251 10671 260747 37.5443 -4.7278 2021-01-10 05:22:12 Andalusia, Spain
96696 2021-04-22 Spain Andalusia     539780 9495 10671 519614 37.5443 -4.7278 2021-04-23 04:20:52 Andalusia, Spain
100732 2021-02-23 Spain Andalusia     472983 8141 10671 454171 37.5443 -4.7278 2021-02-24 05:29:16 Andalusia, Spain
104700 2020-09-25 Spain Andalusia     56615 1744 10671 44200 37.5443 -4.7278 2020-09-26 04:23:00 Andalusia, Spain
108679 2020-12-28 Spain Andalusia     260433 5032 10671 244730 37.5443 -4.7278 2020-12-29 05:22:37 Andalusia, Spain
112648 2020-10-26 Spain Andalusia     114707 2314 10671 101722 37.5443 -4.7278 2020-10-27 04:24:45 Andalusia, Spain
116632 2021-02-21 Spain Andalusia     468648 7946 10671 450031 37.5443 -4.7278 2021-02-22 05:24:21 Andalusia, Spain
123108 2021-04-05 Spain Andalusia     510909 9241 10671 490997 37.5443 -4.7278 2021-04-06 04:20:32 Andalusia, Spain
127076 2020-09-29 Spain Andalusia     59873 1780 10671 47422 37.5443 -4.7278 2020-09-30 04:23:33 Andalusia, Spain
133723 2020-08-06 Spain Andalusia     16308 1438 10671 4199 37.5443 -4.7278 2020-08-07 04:35:11 Andalusia, Spain
135005 2021-01-19 Spain Andalusia     327415 5600 10671 311144 37.5443 -4.7278 2021-01-20 05:21:54 Andalusia, Spain
141652 2020-07-30 Spain Andalusia     14924 1435 10671 2818 37.5443 -4.7278 2020-07-31 04:35:18 Andalusia, Spain
145487 2020-07-11 Spain Andalusia     13386 1435 10671 1280 37.5443 -4.7278 2020-07-12 04:34:30 Andalusia, Spain
149251 2020-06-21 Spain Andalusia     12884 1426 10671 787 37.5443 -4.7278 2020-06-22 04:33:20 Andalusia, Spain
150514 2020-11-19 Spain Andalusia     208674 3472 10671 194531 37.5443 -4.7278 2020-11-20 05:26:28 Andalusia, Spain
154552 2020-12-23 Spain Andalusia     256664 4912 10671 241081 37.5443 -4.7278 2020-12-24 05:23:04 Andalusia, Spain
161438 2020-11-02 Spain Andalusia     145826 2570 10671 132585 37.5443 -4.7278 2020-11-03 06:00:16 Andalusia, Spain
167814 2020-05-19 Spain Andalusia     12471 1358 0 11113 37.5443 -4.7278 2020-05-20 02:32:19 Andalusia, Spain
168747 2021-06-19 Spain Andalusia     606879 10009 10671 586199 37.5443 -4.7278 2021-06-20 04:21:48 Andalusia, Spain
172730 2021-03-09 Spain Andalusia     485759 8697 10671 466391 37.5443 -4.7278 2021-03-10 05:24:35 Andalusia, Spain
180254 2020-12-04 Spain Andalusia     238783 4296 10671 223816 37.5443 -4.7278 2020-12-05 05:27:36 Andalusia, Spain
186698 2020-06-07 Spain Andalusia     12783 1404 10671 708 37.5443 -4.7278 2020-06-08 03:33:22 Andalusia, Spain
187920 2021-02-20 Spain Andalusia     468648 7946 10671 450031 37.5443 -4.7278 2021-02-21 05:24:33 Andalusia, Spain
194568 2020-08-03 Spain Andalusia     15638 1435 10671 3532 37.5443 -4.7278 2020-08-04 04:41:59 Andalusia, Spain
195831 2020-08-28 Spain Andalusia     27734 1480 10671 15583 37.5443 -4.7278 2020-08-29 04:28:19 Andalusia, Spain
199789 2020-08-24 Spain Andalusia     24650 1466 10671 12513 37.5443 -4.7278 2020-08-25 04:28:02 Andalusia, Spain
207190 2021-02-22 Spain Andalusia     472186 8043 10671 453472 37.5443 -4.7278 2021-02-23 05:23:41 Andalusia, Spain
211160 2020-11-08 Spain Andalusia     161148 2781 10671 147696 37.5443 -4.7278 2020-11-09 05:25:45 Andalusia, Spain
215143 2021-01-13 Spain Andalusia     294474 5401 10671 278402 37.5443 -4.7278 2021-01-14 05:22:32 Andalusia, Spain
225100 2020-07-07 Spain Andalusia     13275 1433 10671 1171 37.5443 -4.7278 2020-07-08 05:33:48 Andalusia, 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]);