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

402 rows where country_or_region = "Spain" and province_or_state = "Asturias" sorted by day descending

View and edit SQL

Suggested facets: recovered, day (date), last_update (date)

province_or_state

  • Asturias · 402

country_or_region

  • Spain · 402
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168749 2021-06-19 Spain Asturias     53324 1974 1063 50287 43.3614 -5.8593 2021-06-20 04:21:48 Asturias, Spain
686274 2021-06-18 Spain Asturias     53324 1974 1063 50287 43.3614 -5.8593 2021-06-19 04:22:33 Asturias, Spain
958331 2021-06-17 Spain Asturias     53250 1974 1063 50213 43.3614 -5.8593 2021-06-18 04:22:16 Asturias, Spain
1281696 2021-06-16 Spain Asturias     53217 1973 1063 50181 43.3614 -5.8593 2021-06-17 04:22:36 Asturias, Spain
682286 2021-06-15 Spain Asturias     53168 1972 1063 50133 43.3614 -5.8593 2021-06-16 04:22:32 Asturias, Spain
372840 2021-06-14 Spain Asturias     53120 1972 1063 50085 43.3614 -5.8593 2021-06-15 04:22:22 Asturias, Spain
1223656 2021-06-13 Spain Asturias     52979 1972 1063 49944 43.3614 -5.8593 2021-06-14 04:22:46 Asturias, Spain
80937 2021-06-12 Spain Asturias     52979 1972 1063 49944 43.3614 -5.8593 2021-06-13 04:22:44 Asturias, Spain
970240 2021-06-11 Spain Asturias     52979 1972 1063 49944 43.3614 -5.8593 2021-06-12 04:22:22 Asturias, Spain
1438813 2021-06-10 Spain Asturias     52907 1972 1063 49872 43.3614 -5.8593 2021-06-11 04:23:20 Asturias, Spain
1157312 2021-06-09 Spain Asturias     52856 1972 1063 49821 43.3614 -5.8593 2021-06-10 04:23:17 Asturias, Spain
1231628 2021-06-08 Spain Asturias     52777 1972 1063 49742 43.3614 -5.8593 2021-06-09 04:23:31 Asturias, Spain
360624 2021-06-07 Spain Asturias     52737 1972 1063 49702 43.3614 -5.8593 2021-06-08 04:22:35 Asturias, Spain
1076252 2021-06-06 Spain Asturias     52603 1971 1063 49569 43.3614 -5.8593 2021-06-07 04:22:51 Asturias, Spain
1613644 2021-06-05 Spain Asturias     52603 1971 1063 49569 43.3614 -5.8593 2021-06-06 04:24:03 Asturias, Spain
1125930 2021-06-04 Spain Asturias     52603 1971 1063 49569 43.3614 -5.8593 2021-06-05 04:23:03 Asturias, Spain
318386 2021-06-03 Spain Asturias     52551 1967 1063 49521 43.3614 -5.8593 2021-06-04 04:23:37 Asturias, Spain
1133899 2021-06-02 Spain Asturias     52496 1967 1063 49466 43.3614 -5.8593 2021-06-03 04:23:32 Asturias, Spain
292076 2021-06-01 Spain Asturias     52455 1967 1063 49425 43.3614 -5.8593 2021-06-02 04:24:34 Asturias, Spain
1652027 2021-05-31 Spain Asturias     52380 1967 1063 49350 43.3614 -5.8593 2021-06-01 04:23:09 Asturias, Spain
981255 2021-05-30 Spain Asturias     52213 1965 1063 49185 43.3614 -5.8593 2021-05-31 03:08:59 Asturias, Spain
841636 2021-05-29 Spain Asturias     52213 1965 1063 49185 43.3614 -5.8593 2021-05-30 04:20:55 Asturias, Spain
698208 2021-05-28 Spain Asturias     52213 1965 1063 49185 43.3614 -5.8593 2021-05-29 04:20:41 Asturias, Spain
1369709 2021-05-27 Spain Asturias     52157 1965 1063 49129 43.3614 -5.8593 2021-05-28 04:20:36 Asturias, Spain
1292793 2021-05-26 Spain Asturias     52131 1965 1063 49103 43.3614 -5.8593 2021-05-27 04:20:59 Asturias, Spain
603164 2021-05-25 Spain Asturias     52062 1965 1063 49034 43.3614 -5.8593 2021-05-26 04:20:35 Asturias, Spain
1365722 2021-05-24 Spain Asturias     52021 1965 1063 48993 43.3614 -5.8593 2021-05-25 04:21:08 Asturias, Spain
420235 2021-05-23 Spain Asturias     51882 1963 1063 48856 43.3614 -5.8593 2021-05-24 04:20:53 Asturias, Spain
54574 2021-05-22 Spain Asturias     51882 1963 1063 48856 43.3614 -5.8593 2021-05-23 04:20:51 Asturias, Spain
368853 2021-05-21 Spain Asturias     51882 1963 1063 48856 43.3614 -5.8593 2021-05-22 04:20:45 Asturias, Spain
1024652 2021-05-20 Spain Asturias     51820 1962 1063 48795 43.3614 -5.8593 2021-05-21 04:20:43 Asturias, Spain
1679278 2021-05-19 Spain Asturias     51743 1960 1063 48720 43.3614 -5.8593 2021-05-20 04:21:05 Asturias, Spain
65265 2021-05-18 Spain Asturias     51694 1959 1063 48672 43.3614 -5.8593 2021-05-19 04:20:42 Asturias, Spain
1243337 2021-05-17 Spain Asturias     51645 1958 1063 48624 43.3614 -5.8593 2021-05-18 04:20:33 Asturias, Spain
1068185 2021-05-16 Spain Asturias     51513 1954 1063 48496 43.3614 -5.8593 2021-05-17 04:20:34 Asturias, Spain
505313 2021-05-15 Spain Asturias     51513 1954 1063 48496 43.3614 -5.8593 2021-05-16 04:20:49 Asturias, Spain
892918 2021-05-14 Spain Asturias     51513 1954 1063 48496 43.3614 -5.8593 2021-05-15 04:20:58 Asturias, Spain
532253 2021-05-13 Spain Asturias     51461 1954 1063 48444 43.3614 -5.8593 2021-05-14 04:20:41 Asturias, Spain
1719540 2021-05-12 Spain Asturias     51403 1952 1063 48388 43.3614 -5.8593 2021-05-13 04:20:51 Asturias, Spain
1723526 2021-05-11 Spain Asturias     51356 1952 1063 48341 43.3614 -5.8593 2021-05-12 04:21:29 Asturias, Spain
1165283 2021-05-10 Spain Asturias     51306 1951 1063 48292 43.3614 -5.8593 2021-05-11 04:20:41 Asturias, Spain
1169269 2021-05-09 Spain Asturias     51158 1946 1063 48149 43.3614 -5.8593 2021-05-10 04:20:38 Asturias, Spain
1660056 2021-05-08 Spain Asturias     51158 1946 1063 48149 43.3614 -5.8593 2021-05-09 04:20:35 Asturias, Spain
800154 2021-05-07 Spain Asturias     51158 1946 1063 48149 43.3614 -5.8593 2021-05-08 04:21:04 Asturias, Spain
1219669 2021-05-06 Spain Asturias     51096 1946 1063 48087 43.3614 -5.8593 2021-05-07 04:20:40 Asturias, Spain
416249 2021-05-05 Spain Asturias     51047 1946 1063 48038 43.3614 -5.8593 2021-05-06 04:20:38 Asturias, Spain
674270 2021-05-04 Spain Asturias     50995 1945 1063 47987 43.3614 -5.8593 2021-05-05 04:20:43 Asturias, Spain
1088294 2021-05-03 Spain Asturias     50925 1945 1063 47917 43.3614 -5.8593 2021-05-04 04:20:34 Asturias, Spain
1727512 2021-05-02 Spain Asturias     50733 1944 1063 47726 43.3614 -5.8593 2021-05-03 04:20:39 Asturias, Spain
1084308 2021-05-01 Spain Asturias     50733 1944 1063 47726 43.3614 -5.8593 2021-05-02 04:20:48 Asturias, Spain
1388836 2021-04-30 Spain Asturias     50733 1944 1063 47726 43.3614 -5.8593 2021-05-01 04:20:47 Asturias, Spain
38655 2021-04-29 Spain Asturias     50621 1943 1063 47615 43.3614 -5.8593 2021-04-30 04:21:03 Asturias, Spain
12228 2021-04-28 Spain Asturias     50518 1943 1063 47512 43.3614 -5.8593 2021-04-29 04:20:55 Asturias, Spain
853611 2021-04-27 Spain Asturias     50421 1943 1063 47415 43.3614 -5.8593 2021-04-28 04:20:32 Asturias, Spain
1064199 2021-04-26 Spain Asturias     50342 1942 1063 47337 43.3614 -5.8593 2021-04-27 04:20:52 Asturias, Spain
1476449 2021-04-25 Spain Asturias     50028 1938 1063 47027 43.3614 -5.8593 2021-04-26 04:21:04 Asturias, Spain
744070 2021-04-24 Spain Asturias     50028 1938 1063 47027 43.3614 -5.8593 2021-04-25 04:20:32 Asturias, Spain
1430869 2021-04-23 Spain Asturias     50028 1938 1063 47027 43.3614 -5.8593 2021-04-24 04:20:38 Asturias, Spain
96698 2021-04-22 Spain Asturias     49903 1937 1063 46903 43.3614 -5.8593 2021-04-23 04:20:52 Asturias, Spain
849625 2021-04-21 Spain Asturias     49801 1936 1063 46802 43.3614 -5.8593 2021-04-22 04:20:53 Asturias, Spain
827243 2021-04-20 Spain Asturias     49533 1933 1063 47727 43.3614 -5.8593 2021-04-21 04:21:14 Asturias, Spain
770954 2021-04-19 Spain Asturias     49533 1933 1063 46537 43.3614 -5.8593 2021-04-20 04:20:41 Asturias, Spain
1416263 2021-04-18 Spain Asturias     49243 1925 1063 46255 43.3614 -5.8593 2021-04-19 04:20:57 Asturias, Spain
985240 2021-04-17 Spain Asturias     49243 1925 1063 46255 43.3614 -5.8593 2021-04-18 04:20:41 Asturias, Spain
238303 2021-04-16 Spain Asturias     49243 1925 1063 46255 43.3614 -5.8593 2021-04-17 04:20:40 Asturias, Spain
580032 2021-04-15 Spain Asturias     49119 1925 1063 46131 43.3614 -5.8593 2021-04-16 04:20:46 Asturias, Spain
1266660 2021-04-14 Spain Asturias     48964 1924 1063 45977 43.3614 -5.8593 2021-04-15 04:20:54 Asturias, Spain
702193 2021-04-13 Spain Asturias     48771 1924 1063 45784 43.3614 -5.8593 2021-04-14 04:20:41 Asturias, Spain
1671306 2021-04-12 Spain Asturias     48652 1921 1063 45668 43.3614 -5.8593 2021-04-13 04:20:37 Asturias, Spain
785011 2021-04-11 Spain Asturias     48329 1918 1063 45348 43.3614 -5.8593 2021-04-12 04:21:00 Asturias, Spain
1392822 2021-04-10 Spain Asturias     48329 1918 1063 45348 43.3614 -5.8593 2021-04-11 04:20:56 Asturias, Spain
966253 2021-04-09 Spain Asturias     48329 1918 1063 45348 43.3614 -5.8593 2021-04-10 04:20:59 Asturias, Spain
690257 2021-04-08 Spain Asturias     48166 1917 1063 45186 43.3614 -5.8593 2021-04-09 04:21:13 Asturias, Spain
1277709 2021-04-07 Spain Asturias     48019 1908 1063 45048 43.3614 -5.8593 2021-04-08 04:21:13 Asturias, Spain
88728 2021-04-06 Spain Asturias     47897 1905 1063 44929 43.3614 -5.8593 2021-04-07 04:20:53 Asturias, Spain
123110 2021-04-05 Spain Asturias     47801 1903 1063 44835 43.3614 -5.8593 2021-04-06 04:20:32 Asturias, Spain
73612 2021-04-04 Spain Asturias     47628 1900 1063 44665 43.3614 -5.8593 2021-04-05 04:20:35 Asturias, Spain
792228 2021-04-03 Spain Asturias     47628 1900 1063 44665 43.3614 -5.8593 2021-04-04 04:20:49 Asturias, Spain
1020666 2021-04-02 Spain Asturias     47398 1895 1063 44440 43.3614 -5.8593 2021-04-03 04:20:44 Asturias, Spain
1350828 2021-04-01 Spain Asturias     47398 1895 1063 44440 43.3614 -5.8593 2021-04-02 04:20:36 Asturias, Spain
1691214 2021-03-31 Spain Asturias     47263 1891 1063 44309 43.3614 -5.8593 2021-04-01 04:27:05 Asturias, Spain
873583 2021-03-30 Spain Asturias     47105 1889 1063 44153 43.3614 -5.8593 2021-03-31 04:26:25 Asturias, Spain
1400630 2021-03-29 Spain Asturias     46986 1889 1063 44034 43.3614 -5.8593 2021-03-30 04:26:23 Asturias, Spain
1625033 2021-03-28 Spain Asturias     46670 1878 1063 43729 43.3614 -5.8593 2021-03-29 04:28:35 Asturias, Spain
1472463 2021-03-27 Spain Asturias     46670 1878 1063 43729 43.3614 -5.8593 2021-03-28 05:28:10 Asturias, Spain
721010 2021-03-26 Spain Asturias     46670 1878 1063 43729 43.3614 -5.8593 2021-03-27 05:25:04 Asturias, Spain
1617629 2021-03-25 Spain Asturias     46506 1877 1063 43566 43.3614 -5.8593 2021-03-26 05:26:55 Asturias, Spain
470290 2021-03-24 Spain Asturias     46271 1870 1063 43338 43.3614 -5.8593 2021-03-25 05:27:00 Asturias, Spain
1585330 2021-03-23 Spain Asturias     46271 1870 1063 43338 43.3614 -5.8593 2021-03-24 05:25:40 Asturias, Spain
717024 2021-03-22 Spain Asturias     46156 1867 1063 43226 43.3614 -5.8593 2021-03-23 05:26:18 Asturias, Spain
1675292 2021-03-21 Spain Asturias     45749 1828 1063 42858 43.3614 -5.8593 2021-03-22 05:25:43 Asturias, Spain
1747231 2021-03-20 Spain Asturias     45749 1828 1063 42858 43.3614 -5.8593 2021-03-21 05:25:44 Asturias, Spain
230353 2021-03-19 Spain Asturias     45749 1828 1063 42858 43.3614 -5.8593 2021-03-20 05:25:46 Asturias, Spain
478288 2021-03-18 Spain Asturias     45749 1828 1063 42858 43.3614 -5.8593 2021-03-19 05:26:09 Asturias, Spain
1426883 2021-03-17 Spain Asturias     45617 1825 1063 42729 43.3614 -5.8593 2021-03-18 05:26:22 Asturias, Spain
1593471 2021-03-16 Spain Asturias     45472 1819 1063 42590 43.3614 -5.8593 2021-03-17 05:25:07 Asturias, Spain
1176470 2021-03-15 Spain Asturias     45363 1817 1063 42483 43.3614 -5.8593 2021-03-16 05:25:13 Asturias, Spain
276155 2021-03-14 Spain Asturias     44999 1809 1063 42127 43.3614 -5.8593 2021-03-15 05:25:51 Asturias, Spain
1161297 2021-03-13 Spain Asturias     44999 1809 1063 42127 43.3614 -5.8593 2021-03-14 05:25:37 Asturias, Spain
22804 2021-03-12 Spain Asturias     44999 1809 1063 42127 43.3614 -5.8593 2021-03-13 05:25:15 Asturias, 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]);