⚠️ 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 = "Galicia" sorted by day descending

View and edit SQL

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

province_or_state

  • Galicia · 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
168759 2021-06-19 Spain Galicia     128511 2418 9204 116889 42.5751 -8.1339 2021-06-20 04:21:48 Galicia, Spain
686284 2021-06-18 Spain Galicia     128511 2418 9204 116889 42.5751 -8.1339 2021-06-19 04:22:33 Galicia, Spain
958341 2021-06-17 Spain Galicia     128384 2417 9204 116763 42.5751 -8.1339 2021-06-18 04:22:16 Galicia, Spain
1281706 2021-06-16 Spain Galicia     128291 2417 9204 116670 42.5751 -8.1339 2021-06-17 04:22:36 Galicia, Spain
682296 2021-06-15 Spain Galicia     128220 2417 9204 116599 42.5751 -8.1339 2021-06-16 04:22:32 Galicia, Spain
372850 2021-06-14 Spain Galicia     128151 2417 9204 116530 42.5751 -8.1339 2021-06-15 04:22:22 Galicia, Spain
1223666 2021-06-13 Spain Galicia     127925 2415 9204 116306 42.5751 -8.1339 2021-06-14 04:22:46 Galicia, Spain
80947 2021-06-12 Spain Galicia     127925 2415 9204 116306 42.5751 -8.1339 2021-06-13 04:22:44 Galicia, Spain
970250 2021-06-11 Spain Galicia     127925 2415 9204 116306 42.5751 -8.1339 2021-06-12 04:22:22 Galicia, Spain
1438823 2021-06-10 Spain Galicia     127821 2415 9204 116202 42.5751 -8.1339 2021-06-11 04:23:20 Galicia, Spain
1157322 2021-06-09 Spain Galicia     127731 2414 9204 116113 42.5751 -8.1339 2021-06-10 04:23:17 Galicia, Spain
1231638 2021-06-08 Spain Galicia     127656 2414 9204 116038 42.5751 -8.1339 2021-06-09 04:23:31 Galicia, Spain
360634 2021-06-07 Spain Galicia     127561 2413 9204 115944 42.5751 -8.1339 2021-06-08 04:22:35 Galicia, Spain
1076262 2021-06-06 Spain Galicia     127330 2411 9204 115715 42.5751 -8.1339 2021-06-07 04:22:51 Galicia, Spain
1613654 2021-06-05 Spain Galicia     127330 2411 9204 115715 42.5751 -8.1339 2021-06-06 04:24:03 Galicia, Spain
1125940 2021-06-04 Spain Galicia     127330 2411 9204 115715 42.5751 -8.1339 2021-06-05 04:23:03 Galicia, Spain
318396 2021-06-03 Spain Galicia     127230 2407 9204 115619 42.5751 -8.1339 2021-06-04 04:23:37 Galicia, Spain
1133909 2021-06-02 Spain Galicia     127121 2407 9204 115510 42.5751 -8.1339 2021-06-03 04:23:32 Galicia, Spain
292086 2021-06-01 Spain Galicia     127028 2406 9204 115418 42.5751 -8.1339 2021-06-02 04:24:34 Galicia, Spain
1652037 2021-05-31 Spain Galicia     126933 2404 9204 115325 42.5751 -8.1339 2021-06-01 04:23:09 Galicia, Spain
981265 2021-05-30 Spain Galicia     126622 2402 9204 115016 42.5751 -8.1339 2021-05-31 03:08:59 Galicia, Spain
841646 2021-05-29 Spain Galicia     126622 2402 9204 115016 42.5751 -8.1339 2021-05-30 04:20:55 Galicia, Spain
698218 2021-05-28 Spain Galicia     126622 2402 9204 115016 42.5751 -8.1339 2021-05-29 04:20:41 Galicia, Spain
1369719 2021-05-27 Spain Galicia     126460 2402 9204 114854 42.5751 -8.1339 2021-05-28 04:20:36 Galicia, Spain
1292803 2021-05-26 Spain Galicia     126316 2400 9204 114712 42.5751 -8.1339 2021-05-27 04:20:59 Galicia, Spain
603174 2021-05-25 Spain Galicia     126181 2400 9204 114577 42.5751 -8.1339 2021-05-26 04:20:35 Galicia, Spain
1365732 2021-05-24 Spain Galicia     126082 2398 9204 114480 42.5751 -8.1339 2021-05-25 04:21:08 Galicia, Spain
420245 2021-05-23 Spain Galicia     125586 2397 9204 113985 42.5751 -8.1339 2021-05-24 04:20:53 Galicia, Spain
54584 2021-05-22 Spain Galicia     125586 2397 9204 113985 42.5751 -8.1339 2021-05-23 04:20:51 Galicia, Spain
368863 2021-05-21 Spain Galicia     125586 2397 9204 113985 42.5751 -8.1339 2021-05-22 04:20:45 Galicia, Spain
1024662 2021-05-20 Spain Galicia     125377 2396 9204 113777 42.5751 -8.1339 2021-05-21 04:20:43 Galicia, Spain
1679288 2021-05-19 Spain Galicia     125198 2396 9204 113598 42.5751 -8.1339 2021-05-20 04:21:05 Galicia, Spain
65275 2021-05-18 Spain Galicia     125065 2395 9204 113466 42.5751 -8.1339 2021-05-19 04:20:42 Galicia, Spain
1243347 2021-05-17 Spain Galicia     124948 2390 9204 113354 42.5751 -8.1339 2021-05-18 04:20:33 Galicia, Spain
1068195 2021-05-16 Spain Galicia     124532 2386 9204 112942 42.5751 -8.1339 2021-05-17 04:20:34 Galicia, Spain
505323 2021-05-15 Spain Galicia     124532 2386 9204 112942 42.5751 -8.1339 2021-05-16 04:20:49 Galicia, Spain
892928 2021-05-14 Spain Galicia     124532 2386 9204 112942 42.5751 -8.1339 2021-05-15 04:20:58 Galicia, Spain
532263 2021-05-13 Spain Galicia     124333 2384 9204 112745 42.5751 -8.1339 2021-05-14 04:20:41 Galicia, Spain
1719550 2021-05-12 Spain Galicia     124176 2382 9204 112590 42.5751 -8.1339 2021-05-13 04:20:51 Galicia, Spain
1723536 2021-05-11 Spain Galicia     123962 2381 9204 112377 42.5751 -8.1339 2021-05-12 04:21:29 Galicia, Spain
1165293 2021-05-10 Spain Galicia     123811 2381 9204 112226 42.5751 -8.1339 2021-05-11 04:20:41 Galicia, Spain
1169279 2021-05-09 Spain Galicia     123274 2380 9204 111690 42.5751 -8.1339 2021-05-10 04:20:38 Galicia, Spain
1660066 2021-05-08 Spain Galicia     123274 2380 9204 111690 42.5751 -8.1339 2021-05-09 04:20:35 Galicia, Spain
800164 2021-05-07 Spain Galicia     123274 2380 9204 111690 42.5751 -8.1339 2021-05-08 04:21:04 Galicia, Spain
1219679 2021-05-06 Spain Galicia     123042 2379 9204 111459 42.5751 -8.1339 2021-05-07 04:20:40 Galicia, Spain
416259 2021-05-05 Spain Galicia     122812 2378 9204 111230 42.5751 -8.1339 2021-05-06 04:20:38 Galicia, Spain
674280 2021-05-04 Spain Galicia     122625 2378 9204 111043 42.5751 -8.1339 2021-05-05 04:20:43 Galicia, Spain
1088304 2021-05-03 Spain Galicia     122477 2377 9204 110896 42.5751 -8.1339 2021-05-04 04:20:34 Galicia, Spain
1727522 2021-05-02 Spain Galicia     122010 2377 9204 110429 42.5751 -8.1339 2021-05-03 04:20:39 Galicia, Spain
1084318 2021-05-01 Spain Galicia     122010 2377 9204 110429 42.5751 -8.1339 2021-05-02 04:20:48 Galicia, Spain
1388846 2021-04-30 Spain Galicia     122010 2377 9204 110429 42.5751 -8.1339 2021-05-01 04:20:47 Galicia, Spain
38665 2021-04-29 Spain Galicia     121792 2375 9204 110213 42.5751 -8.1339 2021-04-30 04:21:03 Galicia, Spain
12238 2021-04-28 Spain Galicia     121549 2372 9204 109973 42.5751 -8.1339 2021-04-29 04:20:55 Galicia, Spain
853621 2021-04-27 Spain Galicia     121330 2372 9204 109754 42.5751 -8.1339 2021-04-28 04:20:32 Galicia, Spain
1064209 2021-04-26 Spain Galicia     121177 2369 9204 109604 42.5751 -8.1339 2021-04-27 04:20:52 Galicia, Spain
1476459 2021-04-25 Spain Galicia     120579 2366 9204 109009 42.5751 -8.1339 2021-04-26 04:21:04 Galicia, Spain
744080 2021-04-24 Spain Galicia     120579 2366 9204 109009 42.5751 -8.1339 2021-04-25 04:20:32 Galicia, Spain
1430879 2021-04-23 Spain Galicia     120579 2366 9204 109009 42.5751 -8.1339 2021-04-24 04:20:38 Galicia, Spain
96708 2021-04-22 Spain Galicia     120304 2365 9204 108735 42.5751 -8.1339 2021-04-23 04:20:52 Galicia, Spain
849635 2021-04-21 Spain Galicia     120076 2363 9204 108509 42.5751 -8.1339 2021-04-22 04:20:53 Galicia, Spain
827253 2021-04-20 Spain Galicia     119735 2361 9204 117519 42.5751 -8.1339 2021-04-21 04:21:14 Galicia, Spain
770964 2021-04-19 Spain Galicia     119735 2361 9204 108170 42.5751 -8.1339 2021-04-20 04:20:41 Galicia, Spain
1416273 2021-04-18 Spain Galicia     119178 2358 9204 107616 42.5751 -8.1339 2021-04-19 04:20:57 Galicia, Spain
985250 2021-04-17 Spain Galicia     119178 2358 9204 107616 42.5751 -8.1339 2021-04-18 04:20:41 Galicia, Spain
238313 2021-04-16 Spain Galicia     119178 2358 9204 107616 42.5751 -8.1339 2021-04-17 04:20:40 Galicia, Spain
580042 2021-04-15 Spain Galicia     118929 2358 9204 107367 42.5751 -8.1339 2021-04-16 04:20:46 Galicia, Spain
1266670 2021-04-14 Spain Galicia     118722 2357 9204 107161 42.5751 -8.1339 2021-04-15 04:20:54 Galicia, Spain
702203 2021-04-13 Spain Galicia     118559 2356 9204 106999 42.5751 -8.1339 2021-04-14 04:20:41 Galicia, Spain
1671316 2021-04-12 Spain Galicia     118376 2356 9204 106816 42.5751 -8.1339 2021-04-13 04:20:37 Galicia, Spain
785021 2021-04-11 Spain Galicia     117841 2353 9204 106284 42.5751 -8.1339 2021-04-12 04:21:00 Galicia, Spain
1392832 2021-04-10 Spain Galicia     117841 2353 9204 106284 42.5751 -8.1339 2021-04-11 04:20:56 Galicia, Spain
966263 2021-04-09 Spain Galicia     117841 2353 9204 106284 42.5751 -8.1339 2021-04-10 04:20:59 Galicia, Spain
690267 2021-04-08 Spain Galicia     117632 2348 9204 106080 42.5751 -8.1339 2021-04-09 04:21:13 Galicia, Spain
1277719 2021-04-07 Spain Galicia     117487 2345 9204 105938 42.5751 -8.1339 2021-04-08 04:21:13 Galicia, Spain
88738 2021-04-06 Spain Galicia     117311 2342 9204 105765 42.5751 -8.1339 2021-04-07 04:20:53 Galicia, Spain
123120 2021-04-05 Spain Galicia     117177 2340 9204 105633 42.5751 -8.1339 2021-04-06 04:20:32 Galicia, Spain
73622 2021-04-04 Spain Galicia     116967 2332 9204 105431 42.5751 -8.1339 2021-04-05 04:20:35 Galicia, Spain
792238 2021-04-03 Spain Galicia     116967 2332 9204 105431 42.5751 -8.1339 2021-04-04 04:20:49 Galicia, Spain
1020676 2021-04-02 Spain Galicia     116684 2327 9204 105153 42.5751 -8.1339 2021-04-03 04:20:44 Galicia, Spain
1350838 2021-04-01 Spain Galicia     116684 2327 9204 105153 42.5751 -8.1339 2021-04-02 04:20:36 Galicia, Spain
1691224 2021-03-31 Spain Galicia     116522 2327 9204 104991 42.5751 -8.1339 2021-04-01 04:27:05 Galicia, Spain
873593 2021-03-30 Spain Galicia     116361 2323 9204 104834 42.5751 -8.1339 2021-03-31 04:26:25 Galicia, Spain
1400640 2021-03-29 Spain Galicia     116200 2318 9204 104678 42.5751 -8.1339 2021-03-30 04:26:23 Galicia, Spain
1625043 2021-03-28 Spain Galicia     115836 2314 9204 104318 42.5751 -8.1339 2021-03-29 04:28:35 Galicia, Spain
1472473 2021-03-27 Spain Galicia     115836 2314 9204 104318 42.5751 -8.1339 2021-03-28 05:28:10 Galicia, Spain
721020 2021-03-26 Spain Galicia     115836 2314 9204 104318 42.5751 -8.1339 2021-03-27 05:25:04 Galicia, Spain
1617639 2021-03-25 Spain Galicia     115716 2312 9204 104200 42.5751 -8.1339 2021-03-26 05:26:55 Galicia, Spain
470300 2021-03-24 Spain Galicia     115390 2297 9204 103889 42.5751 -8.1339 2021-03-25 05:27:00 Galicia, Spain
1585340 2021-03-23 Spain Galicia     115390 2297 9204 103889 42.5751 -8.1339 2021-03-24 05:25:40 Galicia, Spain
717034 2021-03-22 Spain Galicia     115294 2296 9204 103794 42.5751 -8.1339 2021-03-23 05:26:18 Galicia, Spain
1675302 2021-03-21 Spain Galicia     114694 2286 9204 103204 42.5751 -8.1339 2021-03-22 05:25:43 Galicia, Spain
1747241 2021-03-20 Spain Galicia     114694 2286 9204 103204 42.5751 -8.1339 2021-03-21 05:25:44 Galicia, Spain
230363 2021-03-19 Spain Galicia     114694 2286 9204 103204 42.5751 -8.1339 2021-03-20 05:25:46 Galicia, Spain
478298 2021-03-18 Spain Galicia     114694 2286 9204 103204 42.5751 -8.1339 2021-03-19 05:26:09 Galicia, Spain
1426893 2021-03-17 Spain Galicia     114517 2283 9204 103030 42.5751 -8.1339 2021-03-18 05:26:22 Galicia, Spain
1593481 2021-03-16 Spain Galicia     114358 2282 9204 102872 42.5751 -8.1339 2021-03-17 05:25:07 Galicia, Spain
1176480 2021-03-15 Spain Galicia     114239 2278 9204 102757 42.5751 -8.1339 2021-03-16 05:25:13 Galicia, Spain
276165 2021-03-14 Spain Galicia     113753 2266 9204 102283 42.5751 -8.1339 2021-03-15 05:25:51 Galicia, Spain
1161307 2021-03-13 Spain Galicia     113753 2266 9204 102283 42.5751 -8.1339 2021-03-14 05:25:37 Galicia, Spain
22814 2021-03-12 Spain Galicia     113753 2266 9204 102283 42.5751 -8.1339 2021-03-13 05:25:15 Galicia, 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]);