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

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
3048 2020-04-19 Spain       198674 20453 77357 100864 40.463667 -3.74922 2020-04-19 23:40:41 Spain
10458 2020-03-30 Spain       87956 7716 16780 63460 40.463667 -3.74922 3/30/20 22:52 Spain
21407 2020-04-24 Spain       219764 22524 92355 104885 40.463667 -3.7492199999999998 2020-04-25 06:30:33 Spain
28615 2020-05-11 Spain       227436 26744 137139 63553 40.463667 -3.74922 2020-05-12 03:32:27 Spain
47724 2020-05-09 Spain       223578 26478 133952 63148 40.463667 -3.74922 2020-05-10 02:32:30 Spain
67083 2020-02-27 Spain       15 0 2       2020-02-27T13:23:02  
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  
130398 2020-03-28 Spain       73235 5982 12285 54968 40.463667 -3.74922 3/28/20 23:05 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  
176748 2020-04-04 Spain       126168 11947 34219 80002 40.463667 -3.74922 4/4/20 23:34 Spain
187281 2020-04-26 Spain       226629 23190 117727 85712 40.463667 -3.7492199999999998 2020-04-27 02:30:33 Spain
195309 2020-02-11 Spain       2 0 0       2020-02-09T20:33:03  
202708 2020-03-24 Spain       39885 2808 3794 33283 40.463667 -3.7492199999999998 2020-03-24 23:37:15 Spain
265706 2020-03-04 Spain       222 2 2   40.0 -4.0 2020-03-04T20:43:02  
277204 2020-03-29 Spain       80110 6803 14709 58598 40.463667 -3.74922 3/29/20 23:08 Spain
301130 2020-03-05 Spain       259 3 2   40.0 -4.0 2020-03-05T17:43:03  
304680 2020-03-25 Spain       49515 3647 5367 40501 40.463667 -3.7492199999999998 2020-03-25 23:33:04 Spain
339239 2020-05-10 Spain       224350 26621 136166 61563 40.463667 -3.74922 2020-05-11 02:32:30 Spain
342210 2020-04-11 Spain       163027 16606 59109 87312 40.463667 -3.7492199999999998 2020-04-11 22:45:13 Spain
391756 2020-04-18 Spain       191726 20043 74797 96886 40.463667 -3.74922 2020-04-18 22:32:28 Spain
414953 2020-03-21 Spain       25374 1375 2125   40.4637 -3.7492 2020-03-21T13:13:30  
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  
422832 2020-04-22 Spain       208389 21717 85915 100757 40.463667 -3.7492199999999998 2020-04-22 23:30:32 Spain
433991 2020-05-01 Spain       213435 24543 112050 76842 40.463667 -3.74922 2020-05-02 02:32:27 Spain
511365 2020-04-05 Spain       131646 12641 38080 80925 40.463667 -3.7492199999999998 2020-04-05 23:06:26 Spain
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  
585468 2020-05-06 Spain       220325 25857 126002 68466 40.463667 -3.74922 2020-05-07 02:32:28 Spain
589614 2020-03-13 Spain       5232 133 193   40.4637 -3.7492 2020-03-11T20:00:00  
592658 2020-04-12 Spain       166831 17209 62391 87231 40.463667 -3.74922 2020-04-12 23:17:00 Spain
603755 2020-04-25 Spain       223759 22902 95708 105149 40.463667 -3.7492199999999998 2020-04-26 02:30:31 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  
720504 2020-05-08 Spain       222857 26299 131148 65410 40.463667 -3.74922 2020-05-09 02:32:35 Spain
739853 2020-03-27 Spain       65719 5138 9357 51224 40.463667 -3.7492199999999998 2020-03-27 23:23:03 Spain
762513 2020-03-20 Spain       20410 1043 1588   40.4637 -3.7492 2020-03-20T17:43:03  
817437 2020-05-12 Spain       228030 26920 138980 62130 40.463667 -3.74922 2020-05-13 03:32:26 Spain
851120 2020-03-31 Spain       95923 8464 19259 68200 40.463667 -3.7492199999999998 2020-03-31 23:43:43 Spain
863151 2020-02-14 Spain       2 0 0       2020-02-09T20:33:03  
866325 2020-04-30 Spain       213435 24543 112050 76842 40.463667 -3.74922 2020-05-01 02:32:28 Spain
889731 2020-02-23 Spain       2 0 2       2020-02-15T17:23:04  
896829 2020-04-23 Spain       213024 22157 89250 101617 40.463667 -3.7492199999999998 2020-04-24 03:30:31 Spain
919782 2020-04-21 Spain       204178 21282 82514 100382 40.463667 -3.7492199999999998 2020-04-21 23:30:30 Spain
923623 2020-03-17 Spain       11748 533 1028   40.4637 -3.7492 2020-03-17T20:53:02  
930797 2020-04-10 Spain       158273 16081 55668 86524 40.463667 -3.7492199999999998 2020-04-10 22:53:48 Spain
966454 2020-02-24 Spain       2 0 2       2020-02-15T17:23:04  
985502 2020-04-27 Spain       229422 23521 120832 85069 40.463667 -3.7492199999999998 2020-04-28 02:30:32 Spain
1012276 2020-04-20 Spain       200210 20852 80587 98771 40.463667 -3.7492199999999998 2020-04-20 23:36:27 Spain
1042740 2020-03-23 Spain       35136 2311 3355 29470 40.463667 -3.7492199999999998 2020-03-23 23:19:21 Spain
1045367 2020-04-03 Spain       119199 11198 30513 77488 40.463667 -3.7492199999999998 2020-04-03 22:46:20 Spain
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  
1092605 2020-03-22 Spain       28603 1756 2125 24722 40.463667 -3.74922 3/22/20 23:45 Spain
1124423 2020-02-01 Spain       1 0 0       2/1/2020 2:13  
1169830 2020-04-16 Spain       184948 19315 74797 90836 40.463667 -3.7492199999999998 2020-04-16 23:30:31 Spain
1169913 2020-02-15 Spain       2 0 2       2020-02-15T17:23:04  
1173111 2020-05-04 Spain       218011 25428 121343 71240 40.463667 -3.74922 2020-05-05 02:32:34 Spain
1203907 2020-02-07 Spain       1 0 0       2020-02-01T23:43:02  
1222250 2020-05-05 Spain       219329 25613 123486 70230 40.463667 -3.74922 2020-05-06 02:32:31 Spain
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  
1292003 2020-04-01 Spain       104118 9387 22647 72084 40.463667 -3.7492199999999998 2020-04-01 21:58:34 Spain
1306464 2020-04-02 Spain       112065 10348 26743 74974 40.463667 -3.74922 4/2/20 23:25 Spain
1318476 2020-02-20 Spain       2 0 2       2020-02-15T17:23:04  
1348825 2020-04-15 Spain       177644 18708 70853 88083 40.463667 -3.7492199999999998 2020-04-15 22:56:32 Spain
1367524 2020-04-07 Spain       141942 14045 43208 84689 40.463667 -3.7492199999999998 2020-04-07 23:04:29 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  
1496146 2020-04-09 Spain       153222 15447 52165 85610 40.463667 -3.7492199999999998 2020-04-09 23:02:19 Spain
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  
1539297 2020-04-28 Spain       232128 23822 123903 84403 40.463667 -3.7492199999999998 2020-04-29 02:32:29 Spain
1539331 2020-03-11 Spain       2277 54 183   40.0 -4.0 2020-03-11T20:53:02  
1542327 2020-04-06 Spain       136675 13341 40437 82897 40.463667 -3.74922 4/6/20 23:21 Spain
1545528 2020-05-03 Spain       217466 25264 118902 73300 40.463667 -3.74922 2020-05-04 02:32:28 Spain
1548770 2020-05-02 Spain       216582 25100 117248 74234 40.463667 -3.74922 2020-05-03 02:32:28 Spain
1563649 2020-04-08 Spain       148220 14792 48021 85407 40.463667 -3.7492199999999998 2020-04-08 22:51:39 Spain
1563731 2020-02-12 Spain       2 0 0       2020-02-09T20:33:03  
1574689 2020-04-13 Spain       170099 17756 64727 87616 40.463667 -3.7492199999999998 2020-04-13 23:07:34 Spain
1578705 2020-03-16 Spain       9942 342 530   40.4637 -3.7492 2020-03-16T20:13:11  
1593895 2020-04-14 Spain       172541 18056 67504 86981 40.463667 -3.7492199999999998 2020-04-14 23:33:12 Spain
1613019 2020-05-13 Spain       228691 27104 140823 60764 40.463667 -3.74922 2020-05-14 03:32:28 Spain
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  
1652680 2020-03-26 Spain       57786 4365 7015 46406 40.463667 -3.7492199999999998 2020-03-26 23:48:18 Spain
1655851 2020-04-29 Spain       236899 24275 132929 79695 40.463667 -3.7492199999999998 2020-04-30 02:32:27 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]);