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

View and edit SQL

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

country_or_region

  • Spain · 8,238
Link rowid day ▼ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1637566 2020-02-01 Spain       1 0 0       2/1/2020 2:13  
1523230 2020-02-02 Spain       1 0 0       2020-02-01T23:43:02  
1215248 2020-02-03 Spain       1 0 0       2020-02-01T23:43:02  
677625 2020-02-04 Spain       1 0 0       2020-02-01T23:43:02  
242415 2020-02-05 Spain       1 0 0       2020-02-01T23:43:02  
673562 2020-02-06 Spain       1 0 0       2020-02-01T23:43:02  
874536 2020-02-07 Spain       1 0 0       2020-02-01T23:43:02  
1143345 2020-02-08 Spain       1 0 0       2020-02-01T23:43:02  
226606 2020-02-09 Spain       2 0 0       2020-02-09T20:33:03  
1311402 2020-02-10 Spain       2 0 0       2020-02-09T20:33:03  
754645 2020-02-11 Spain       2 0 0       2020-02-09T20:33:03  
1586174 2020-02-12 Spain       2 0 0       2020-02-09T20:33:03  
885799 2020-02-13 Spain       2 0 0       2020-02-09T20:33:03  
965381 2020-02-14 Spain       2 0 0       2020-02-09T20:33:03  
708814 2020-02-15 Spain       2 0 2       2020-02-15T17:23:04  
379580 2020-02-16 Spain       2 0 2       2020-02-15T17:23:04  
1369529 2020-02-17 Spain       2 0 2       2020-02-15T17:23:04  
353993 2020-02-18 Spain       2 0 2       2020-02-15T17:23:04  
754565 2020-02-19 Spain       2 0 2       2020-02-15T17:23:04  
491491 2020-02-20 Spain       2 0 2       2020-02-15T17:23:04  
120851 2020-02-21 Spain       2 0 2       2020-02-15T17:23:04  
1403274 2020-02-22 Spain       2 0 2       2020-02-15T17:23:04  
1012432 2020-02-23 Spain       2 0 2       2020-02-15T17:23:04  
1684537 2020-02-24 Spain       2 0 2       2020-02-15T17:23:04  
153328 2020-02-25 Spain       6 0 2       2020-02-25T21:33:02  
1086518 2020-02-26 Spain       13 0 2       2020-02-26T20:43:02  
685392 2020-02-27 Spain       15 0 2       2020-02-27T13:23:02  
1560765 2020-02-28 Spain       32 0 2       2020-02-28T15:33:03  
965242 2020-02-29 Spain       45 0 2       2020-02-29T19:13:08  
1507969 2020-03-01 Spain       84 0 2   40.0 -4.0 2020-03-01T23:33:03  
598634 2020-03-02 Spain       120 0 2   40.0 -4.0 2020-03-02T14:43:05  
1120043 2020-03-03 Spain       165 1 2   40.0 -4.0 2020-03-03T23:53:03  
132868 2020-03-04 Spain       222 2 2   40.0 -4.0 2020-03-04T20:43:02  
1107975 2020-03-05 Spain       259 3 2   40.0 -4.0 2020-03-05T17:43:03  
1188156 2020-03-06 Spain       400 5 2   40.0 -4.0 2020-03-06T20:13:13  
199286 2020-03-07 Spain       500 10 30   40.0 -4.0 2020-03-07T17:43:05  
1540508 2020-03-08 Spain       673 17 30   40.0 -4.0 2020-03-08T20:33:02  
425837 2020-03-09 Spain       1073 28 32   40.0 -4.0 2020-03-09T18:13:11  
1295447 2020-03-10 Spain       1695 35 32   40.0 -4.0 2020-03-10T23:53:02  
1180252 2020-03-11 Spain       2277 54 183   40.0 -4.0 2020-03-11T20:53:02  
984334 2020-03-12 Spain       2277 55 183   40.0 -4.0 2020-03-12T01:17:58  
778200 2020-03-13 Spain       5232 133 193   40.4637 -3.7492 2020-03-11T20:00:00  
642532 2020-03-14 Spain       6391 195 517   40.4637 -3.7492 2020-03-14T22:13:11  
1230391 2020-03-15 Spain       7798 289 517   40.4637 -3.7492 2020-03-15T18:20:18  
391047 2020-03-16 Spain       9942 342 530   40.4637 -3.7492 2020-03-16T20:13:11  
1082773 2020-03-17 Spain       11748 533 1028   40.4637 -3.7492 2020-03-17T20:53:02  
386771 2020-03-18 Spain       13910 623 1081   40.4637 -3.7492 2020-03-18T13:13:13  
1748183 2020-03-19 Spain       17963 830 1107   40.4637 -3.7492 2020-03-19T20:13:08  
137048 2020-03-20 Spain       20410 1043 1588   40.4637 -3.7492 2020-03-20T17:43:03  
1637201 2020-03-21 Spain       25374 1375 2125   40.4637 -3.7492 2020-03-21T13:13:30  
521760 2020-03-22 Spain       28603 1756 2125 24722 40.463667 -3.74922 3/22/20 23:45 Spain
1086442 2020-03-23 Spain       35136 2311 3355 29470 40.463667 -3.7492199999999998 2020-03-23 23:19:21 Spain
1523142 2020-03-24 Spain       39885 2808 3794 33283 40.463667 -3.7492199999999998 2020-03-24 23:37:15 Spain
298977 2020-03-25 Spain       49515 3647 5367 40501 40.463667 -3.7492199999999998 2020-03-25 23:33:04 Spain
99284 2020-03-26 Spain       57786 4365 7015 46406 40.463667 -3.7492199999999998 2020-03-26 23:48:18 Spain
1533728 2020-03-27 Spain       65719 5138 9357 51224 40.463667 -3.7492199999999998 2020-03-27 23:23:03 Spain
76464 2020-03-28 Spain       73235 5982 12285 54968 40.463667 -3.74922 3/28/20 23:05 Spain
1479549 2020-03-29 Spain       80110 6803 14709 58598 40.463667 -3.74922 3/29/20 23:08 Spain
95855 2020-03-30 Spain       87956 7716 16780 63460 40.463667 -3.74922 3/30/20 22:52 Spain
1176232 2020-03-31 Spain       95923 8464 19259 68200 40.463667 -3.7492199999999998 2020-03-31 23:43:43 Spain
1497119 2020-04-01 Spain       104118 9387 22647 72084 40.463667 -3.7492199999999998 2020-04-01 21:58:34 Spain
1096022 2020-04-02 Spain       112065 10348 26743 74974 40.463667 -3.74922 4/2/20 23:25 Spain
1456217 2020-04-03 Spain       119199 11198 30513 77488 40.463667 -3.7492199999999998 2020-04-03 22:46:20 Spain
459577 2020-04-04 Spain       126168 11947 34219 80002 40.463667 -3.74922 4/4/20 23:34 Spain
1399197 2020-04-05 Spain       131646 12641 38080 80925 40.463667 -3.7492199999999998 2020-04-05 23:06:26 Spain
360789 2020-04-06 Spain       136675 13341 40437 82897 40.463667 -3.74922 4/6/20 23:21 Spain
113865 2020-04-07 Spain       141942 14045 43208 84689 40.463667 -3.7492199999999998 2020-04-07 23:04:29 Spain
1571637 2020-04-08 Spain       148220 14792 48021 85407 40.463667 -3.7492199999999998 2020-04-08 22:51:39 Spain
1237520 2020-04-09 Spain       153222 15447 52165 85610 40.463667 -3.7492199999999998 2020-04-09 23:02:19 Spain
739439 2020-04-10 Spain       158273 16081 55668 86524 40.463667 -3.7492199999999998 2020-04-10 22:53:48 Spain
598570 2020-04-11 Spain       163027 16606 59109 87312 40.463667 -3.7492199999999998 2020-04-11 22:45:13 Spain
1211205 2020-04-12 Spain       166831 17209 62391 87231 40.463667 -3.74922 2020-04-12 23:17:00 Spain
33743 2020-04-13 Spain       170099 17756 64727 87616 40.463667 -3.7492199999999998 2020-04-13 23:07:34 Spain
1425721 2020-04-14 Spain       172541 18056 67504 86981 40.463667 -3.7492199999999998 2020-04-14 23:33:12 Spain
1165819 2020-04-15 Spain       177644 18708 70853 88083 40.463667 -3.7492199999999998 2020-04-15 22:56:32 Spain
540863 2020-04-16 Spain       184948 19315 74797 90836 40.463667 -3.7492199999999998 2020-04-16 23:30:31 Spain
272490 2020-04-17 Spain       190839 20002 74797 96040 40.463667 -3.7492199999999998 2020-04-17 23:30:32 Spain
1582101 2020-04-18 Spain       191726 20043 74797 96886 40.463667 -3.74922 2020-04-18 22:32:28 Spain
1263895 2020-04-19 Spain       198674 20453 77357 100864 40.463667 -3.74922 2020-04-19 23:40:41 Spain
116952 2020-04-20 Spain       200210 20852 80587 98771 40.463667 -3.7492199999999998 2020-04-20 23:36:27 Spain
645848 2020-04-21 Spain       204178 21282 82514 100382 40.463667 -3.7492199999999998 2020-04-21 23:30:30 Spain
1089652 2020-04-22 Spain       208389 21717 85915 100757 40.463667 -3.7492199999999998 2020-04-22 23:30:32 Spain
804459 2020-04-23 Spain       213024 22157 89250 101617 40.463667 -3.7492199999999998 2020-04-24 03:30:31 Spain
1530282 2020-04-24 Spain       219764 22524 92355 104885 40.463667 -3.7492199999999998 2020-04-25 06:30:33 Spain
453067 2020-04-25 Spain       223759 22902 95708 105149 40.463667 -3.7492199999999998 2020-04-26 02:30:31 Spain
1023513 2020-04-26 Spain       226629 23190 117727 85712 40.463667 -3.7492199999999998 2020-04-27 02:30:33 Spain
591604 2020-04-27 Spain       229422 23521 120832 85069 40.463667 -3.7492199999999998 2020-04-28 02:30:32 Spain
245567 2020-04-28 Spain       232128 23822 123903 84403 40.463667 -3.7492199999999998 2020-04-29 02:32:29 Spain
386736 2020-04-29 Spain       236899 24275 132929 79695 40.463667 -3.7492199999999998 2020-04-30 02:32:27 Spain
206616 2020-04-30 Spain       213435 24543 112050 76842 40.463667 -3.74922 2020-05-01 02:32:28 Spain
160503 2020-05-01 Spain       213435 24543 112050 76842 40.463667 -3.74922 2020-05-02 02:32:27 Spain
379493 2020-05-02 Spain       216582 25100 117248 74234 40.463667 -3.74922 2020-05-03 02:32:28 Spain
801339 2020-05-03 Spain       217466 25264 118902 73300 40.463667 -3.74922 2020-05-04 02:32:28 Spain
1131318 2020-05-04 Spain       218011 25428 121343 71240 40.463667 -3.74922 2020-05-05 02:32:34 Spain
1507901 2020-05-05 Spain       219329 25613 123486 70230 40.463667 -3.74922 2020-05-06 02:32:31 Spain
1222438 2020-05-06 Spain       220325 25857 126002 68466 40.463667 -3.74922 2020-05-07 02:32:28 Spain
1341726 2020-05-07 Spain       221447 26070 128511 66866 40.463667 -3.74922 2020-05-08 02:32:32 Spain
839522 2020-05-08 Spain       222857 26299 131148 65410 40.463667 -3.74922 2020-05-09 02:32:35 Spain
409868 2020-05-09 Spain       223578 26478 133952 63148 40.463667 -3.74922 2020-05-10 02:32:30 Spain
877758 2020-05-10 Spain       224350 26621 136166 61563 40.463667 -3.74922 2020-05-11 02:32:30 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]);