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

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
383972 2020-02-01 Spain       1 0 0       2/1/2020 2:13  
72823 2020-02-02 Spain       1 0 0       2020-02-01T23:43:02  
252575 2020-02-07 Spain       1 0 0       2020-02-01T23:43:02  
477677 2020-02-04 Spain       1 0 0       2020-02-01T23:43:02  
527961 2020-02-06 Spain       1 0 0       2020-02-01T23:43:02  
677720 2020-02-08 Spain       1 0 0       2020-02-01T23:43:02  
1350217 2020-02-03 Spain       1 0 0       2020-02-01T23:43:02  
1597276 2020-02-05 Spain       1 0 0       2020-02-01T23:43:02  
399884 2020-02-11 Spain       2 0 0       2020-02-09T20:33:03  
523910 2020-02-09 Spain       2 0 0       2020-02-09T20:33:03  
1277085 2020-02-14 Spain       2 0 0       2020-02-09T20:33:03  
1442253 2020-02-10 Spain       2 0 0       2020-02-09T20:33:03  
1542126 2020-02-12 Spain       2 0 0       2020-02-09T20:33:03  
1710530 2020-02-13 Spain       2 0 0       2020-02-09T20:33:03  
299499 2020-02-18 Spain       2 0 2       2020-02-15T17:23:04  
655327 2020-02-17 Spain       2 0 2       2020-02-15T17:23:04  
996366 2020-02-16 Spain       2 0 2       2020-02-15T17:23:04  
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  
1285136 2020-02-15 Spain       2 0 2       2020-02-15T17:23:04  
1597189 2020-02-19 Spain       2 0 2       2020-02-15T17:23:04  
1659432 2020-02-20 Spain       2 0 2       2020-02-15T17:23:04  
1738881 2020-02-21 Spain       2 0 2       2020-02-15T17:23:04  
80290 2020-02-25 Spain       6 0 2       2020-02-25T21:33:02  
629415 2020-02-26 Spain       13 0 2       2020-02-26T20:43:02  
826581 2020-02-27 Spain       15 0 2       2020-02-27T13:23:02  
1071615 2020-02-28 Spain       32 0 2       2020-02-28T15:33:03  
803580 2020-02-29 Spain       45 0 2       2020-02-29T19:13:08  
68687 2020-03-01 Spain       84 0 2   40.0 -4.0 2020-03-01T23:33:03  
766258 2020-03-02 Spain       120 0 2   40.0 -4.0 2020-03-02T14:43:05  
1274038 2020-03-03 Spain       165 1 2   40.0 -4.0 2020-03-03T23:53:03  
996173 2020-03-04 Spain       222 2 2   40.0 -4.0 2020-03-04T20:43:02  
72859 2020-03-05 Spain       259 3 2   40.0 -4.0 2020-03-05T17:43:03  
22022 2020-03-06 Spain       400 5 2   40.0 -4.0 2020-03-06T20:13:13  
933942 2020-03-07 Spain       500 10 30   40.0 -4.0 2020-03-07T17:43:05  
1714532 2020-03-08 Spain       673 17 30   40.0 -4.0 2020-03-08T20:33:02  
1191196 2020-03-09 Spain       1073 28 32   40.0 -4.0 2020-03-09T18:13:11  
1588722 2020-03-10 Spain       1695 35 32   40.0 -4.0 2020-03-10T23:53:02  
864950 2020-03-13 Spain       5232 133 193   40.4637 -3.7492 2020-03-11T20:00:00  
1718726 2020-03-11 Spain       2277 54 183   40.0 -4.0 2020-03-11T20:53:02  
1183846 2020-03-12 Spain       2277 55 183   40.0 -4.0 2020-03-12T01:17:58  
826286 2020-03-14 Spain       6391 195 517   40.4637 -3.7492 2020-03-14T22:13:11  
367996 2020-03-15 Spain       7798 289 517   40.4637 -3.7492 2020-03-15T18:20:18  
1596861 2020-03-16 Spain       9942 342 530   40.4637 -3.7492 2020-03-16T20:13:11  
64389 2020-03-17 Spain       11748 533 1028   40.4637 -3.7492 2020-03-17T20:53:02  
643105 2020-03-18 Spain       13910 623 1081   40.4637 -3.7492 2020-03-18T13:13:13  
179367 2020-03-19 Spain       17963 830 1107   40.4637 -3.7492 2020-03-19T20:13:08  
1522672 2020-03-20 Spain       20410 1043 1588   40.4637 -3.7492 2020-03-20T17:43:03  
306703 2020-03-21 Spain       25374 1375 2125   40.4637 -3.7492 2020-03-21T13:13:30  
1423097 2020-03-23 Spain       35136 2311 3355 29470 40.463667 -3.7492199999999998 2020-03-23 23:19:21 Spain
1262048 2020-03-24 Spain       39885 2808 3794 33283 40.463667 -3.7492199999999998 2020-03-24 23:37:15 Spain
221930 2020-03-25 Spain       49515 3647 5367 40501 40.463667 -3.7492199999999998 2020-03-25 23:33:04 Spain
336308 2020-03-26 Spain       57786 4365 7015 46406 40.463667 -3.7492199999999998 2020-03-26 23:48:18 Spain
1314460 2020-03-27 Spain       65719 5138 9357 51224 40.463667 -3.7492199999999998 2020-03-27 23:23:03 Spain
837024 2020-03-31 Spain       95923 8464 19259 68200 40.463667 -3.7492199999999998 2020-03-31 23:43:43 Spain
122481 2020-04-01 Spain       104118 9387 22647 72084 40.463667 -3.7492199999999998 2020-04-01 21:58:34 Spain
18215 2020-04-03 Spain       119199 11198 30513 77488 40.463667 -3.7492199999999998 2020-04-03 22:46:20 Spain
451695 2020-04-05 Spain       131646 12641 38080 80925 40.463667 -3.7492199999999998 2020-04-05 23:06:26 Spain
553362 2020-04-07 Spain       141942 14045 43208 84689 40.463667 -3.7492199999999998 2020-04-07 23:04:29 Spain
822421 2020-04-08 Spain       148220 14792 48021 85407 40.463667 -3.7492199999999998 2020-04-08 22:51:39 Spain
160827 2020-04-09 Spain       153222 15447 52165 85610 40.463667 -3.7492199999999998 2020-04-09 23:02:19 Spain
662061 2020-04-10 Spain       158273 16081 55668 86524 40.463667 -3.7492199999999998 2020-04-10 22:53:48 Spain
609490 2020-04-11 Spain       163027 16606 59109 87312 40.463667 -3.7492199999999998 2020-04-11 22:45:13 Spain
1361126 2020-04-12 Spain       166831 17209 62391 87231 40.463667 -3.74922 2020-04-12 23:17:00 Spain
758402 2020-04-13 Spain       170099 17756 64727 87616 40.463667 -3.7492199999999998 2020-04-13 23:07:34 Spain
454714 2020-04-14 Spain       172541 18056 67504 86981 40.463667 -3.7492199999999998 2020-04-14 23:33:12 Spain
1101850 2020-04-15 Spain       177644 18708 70853 88083 40.463667 -3.7492199999999998 2020-04-15 22:56:32 Spain
980624 2020-04-16 Spain       184948 19315 74797 90836 40.463667 -3.7492199999999998 2020-04-16 23:30:31 Spain
1288181 2020-04-17 Spain       190839 20002 74797 96040 40.463667 -3.7492199999999998 2020-04-17 23:30:32 Spain
929909 2020-04-18 Spain       191726 20043 74797 96886 40.463667 -3.74922 2020-04-18 22:32:28 Spain
1449308 2020-04-19 Spain       198674 20453 77357 100864 40.463667 -3.74922 2020-04-19 23:40:41 Spain
434086 2020-04-20 Spain       200210 20852 80587 98771 40.463667 -3.7492199999999998 2020-04-20 23:36:27 Spain
1094836 2020-04-21 Spain       204178 21282 82514 100382 40.463667 -3.7492199999999998 2020-04-21 23:30:30 Spain
716394 2020-04-22 Spain       208389 21717 85915 100757 40.463667 -3.7492199999999998 2020-04-22 23:30:32 Spain
556479 2020-04-23 Spain       213024 22157 89250 101617 40.463667 -3.7492199999999998 2020-04-24 03:30:31 Spain
598540 2020-04-24 Spain       219764 22524 92355 104885 40.463667 -3.7492199999999998 2020-04-25 06:30:33 Spain
1187162 2020-04-25 Spain       223759 22902 95708 105149 40.463667 -3.7492199999999998 2020-04-26 02:30:31 Spain
1561036 2020-04-26 Spain       226629 23190 117727 85712 40.463667 -3.7492199999999998 2020-04-27 02:30:33 Spain
1426245 2020-04-27 Spain       229422 23521 120832 85069 40.463667 -3.7492199999999998 2020-04-28 02:30:32 Spain
743440 2020-04-28 Spain       232128 23822 123903 84403 40.463667 -3.7492199999999998 2020-04-29 02:32:29 Spain
542769 2020-04-29 Spain       236899 24275 132929 79695 40.463667 -3.7492199999999998 2020-04-30 02:32:27 Spain
61112 2020-04-30 Spain       213435 24543 112050 76842 40.463667 -3.74922 2020-05-01 02:32:28 Spain
302686 2020-05-01 Spain       213435 24543 112050 76842 40.463667 -3.74922 2020-05-02 02:32:27 Spain
643070 2020-05-02 Spain       216582 25100 117248 74234 40.463667 -3.74922 2020-05-03 02:32:28 Spain
457917 2020-05-03 Spain       217466 25264 118902 73300 40.463667 -3.74922 2020-05-04 02:32:28 Spain
328929 2020-05-04 Spain       218011 25428 121343 71240 40.463667 -3.74922 2020-05-05 02:32:34 Spain
1175839 2020-05-05 Spain       219329 25613 123486 70230 40.463667 -3.74922 2020-05-06 02:32:31 Spain
575441 2020-05-06 Spain       220325 25857 126002 68466 40.463667 -3.74922 2020-05-07 02:32:28 Spain
791595 2020-05-07 Spain       221447 26070 128511 66866 40.463667 -3.74922 2020-05-08 02:32:32 Spain
271555 2020-05-08 Spain       222857 26299 131148 65410 40.463667 -3.74922 2020-05-09 02:32:35 Spain
80205 2020-05-09 Spain       223578 26478 133952 63148 40.463667 -3.74922 2020-05-10 02:32:30 Spain
64352 2020-05-10 Spain       224350 26621 136166 61563 40.463667 -3.74922 2020-05-11 02:32:30 Spain
445273 2020-05-11 Spain       227436 26744 137139 63553 40.463667 -3.74922 2020-05-12 03:32:27 Spain
179330 2020-05-12 Spain       228030 26920 138980 62130 40.463667 -3.74922 2020-05-13 03:32:26 Spain
519864 2020-05-13 Spain       228691 27104 140823 60764 40.463667 -3.74922 2020-05-14 03:32:28 Spain
1666413 2020-05-14 Spain Andalusia     12359 1336 9918 1105 37.5443 -4.7278 2020-05-15 02:33:02 Andalusia, Spain
1666416 2020-05-14 Spain Aragon     5389 836 3471 1082 41.5976 -0.9057 2020-05-15 02:33:02 Aragon, Spain
1666418 2020-05-14 Spain Asturias     2356 308 1046 1002 43.3614 -5.8593 2020-05-15 02:33:02 Asturias, Spain
1666421 2020-05-14 Spain Baleares     1958 216 1492 250 39.710358 2.995148 2020-05-15 02:33:02 Baleares, 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]);