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

407 rows where country_or_region = "Spain" and province_or_state = "Castilla y Leon" sorted by day descending

View and edit SQL

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

province_or_state

  • Castilla y Leon · 407

country_or_region

  • Spain · 407
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
235211 2021-06-24 Spain Castilla y Leon     234890 6918 8716 219256 41.8357 -4.3976 2021-06-25 04:21:33 Castilla y Leon, Spain
472159 2021-06-23 Spain Castilla y Leon     234790 6917 8716 219157 41.8357 -4.3976 2021-06-24 04:21:55 Castilla y Leon, Spain
627217 2021-06-22 Spain Castilla y Leon     234686 6917 8716 219053 41.8357 -4.3976 2021-06-23 04:21:46 Castilla y Leon, Spain
227237 2021-06-21 Spain Castilla y Leon     234561 6915 8716 218930 41.8357 -4.3976 2021-06-22 04:21:34 Castilla y Leon, Spain
1472759 2021-06-20 Spain Castilla y Leon     234291 6913 8716 218662 41.8357 -4.3976 2021-06-21 04:21:41 Castilla y Leon, Spain
1304000 2021-06-19 Spain Castilla y Leon     234291 6913 8716 218662 41.8357 -4.3976 2021-06-20 04:21:48 Castilla y Leon, Spain
303602 2021-06-18 Spain Castilla y Leon     234291 6913 8716 218662 41.8357 -4.3976 2021-06-19 04:22:33 Castilla y Leon, Spain
886432 2021-06-17 Spain Castilla y Leon     234173 6913 8716 218544 41.8357 -4.3976 2021-06-18 04:22:16 Castilla y Leon, Spain
42327 2021-06-16 Spain Castilla y Leon     234063 6911 8716 218436 41.8357 -4.3976 2021-06-17 04:22:36 Castilla y Leon, Spain
1705149 2021-06-15 Spain Castilla y Leon     233863 6909 8716 218238 41.8357 -4.3976 2021-06-16 04:22:32 Castilla y Leon, Spain
1661420 2021-06-14 Spain Castilla y Leon     233678 6906 8716 218056 41.8357 -4.3976 2021-06-15 04:22:22 Castilla y Leon, Spain
319496 2021-06-13 Spain Castilla y Leon     233366 6904 8716 217746 41.8357 -4.3976 2021-06-14 04:22:46 Castilla y Leon, Spain
619241 2021-06-12 Spain Castilla y Leon     233366 6904 8716 217746 41.8357 -4.3976 2021-06-13 04:22:44 Castilla y Leon, Spain
592250 2021-06-11 Spain Castilla y Leon     233366 6904 8716 217746 41.8357 -4.3976 2021-06-12 04:22:22 Castilla y Leon, Spain
273128 2021-06-10 Spain Castilla y Leon     233165 6901 8716 217548 41.8357 -4.3976 2021-06-11 04:23:20 Castilla y Leon, Spain
1638186 2021-06-09 Spain Castilla y Leon     232976 6901 8716 217359 41.8357 -4.3976 2021-06-10 04:23:17 Castilla y Leon, Spain
1744799 2021-06-08 Spain Castilla y Leon     232770 6899 8716 217155 41.8357 -4.3976 2021-06-09 04:23:31 Castilla y Leon, Spain
577342 2021-06-07 Spain Castilla y Leon     232567 6894 8716 216957 41.8357 -4.3976 2021-06-08 04:22:35 Castilla y Leon, Spain
246205 2021-06-06 Spain Castilla y Leon     232170 6894 8716 216560 41.8357 -4.3976 2021-06-07 04:22:51 Castilla y Leon, Spain
674182 2021-06-05 Spain Castilla y Leon     232170 6894 8716 216560 41.8357 -4.3976 2021-06-06 04:24:03 Castilla y Leon, Spain
553445 2021-06-04 Spain Castilla y Leon     232170 6894 8716 216560 41.8357 -4.3976 2021-06-05 04:23:03 Castilla y Leon, Spain
1460842 2021-06-03 Spain Castilla y Leon     231924 6890 8716 216318 41.8357 -4.3976 2021-06-04 04:23:37 Castilla y Leon, Spain
1399835 2021-06-02 Spain Castilla y Leon     231661 6890 8716 216055 41.8357 -4.3976 2021-06-03 04:23:32 Castilla y Leon, Spain
1709182 2021-06-01 Spain Castilla y Leon     231403 6884 8716 215803 41.8357 -4.3976 2021-06-02 04:24:34 Castilla y Leon, Spain
19412 2021-05-31 Spain Castilla y Leon     231104 6884 8716 215504 41.8357 -4.3976 2021-06-01 04:23:09 Castilla y Leon, Spain
1497805 2021-05-30 Spain Castilla y Leon     230600 6882 8716 215002 41.8357 -4.3976 2021-05-31 03:08:59 Castilla y Leon, Spain
623228 2021-05-29 Spain Castilla y Leon     230600 6882 8716 215002 41.8357 -4.3976 2021-05-30 04:20:55 Castilla y Leon, Spain
81084 2021-05-28 Spain Castilla y Leon     230600 6882 8716 215002 41.8357 -4.3976 2021-05-29 04:20:41 Castilla y Leon, Spain
1426359 2021-05-27 Spain Castilla y Leon     230308 6880 8716 214712 41.8357 -4.3976 2021-05-28 04:20:36 Castilla y Leon, Spain
1549326 2021-05-26 Spain Castilla y Leon     230066 6874 8716 214476 41.8357 -4.3976 2021-05-27 04:20:59 Castilla y Leon, Spain
1200902 2021-05-25 Spain Castilla y Leon     229794 6875 8716 214203 41.8357 -4.3976 2021-05-26 04:20:35 Castilla y Leon, Spain
149895 2021-05-24 Spain Castilla y Leon     229529 6874 8716 213939 41.8357 -4.3976 2021-05-25 04:21:08 Castilla y Leon, Spain
690048 2021-05-23 Spain Castilla y Leon     228451 6833 8716 212902 41.8357 -4.3976 2021-05-24 04:20:53 Castilla y Leon, Spain
387662 2021-05-22 Spain Castilla y Leon     228451 6833 8716 212902 41.8357 -4.3976 2021-05-23 04:20:51 Castilla y Leon, Spain
969977 2021-05-21 Spain Castilla y Leon     228451 6833 8716 212902 41.8357 -4.3976 2021-05-22 04:20:45 Castilla y Leon, Spain
57939 2021-05-20 Spain Castilla y Leon     228162 6831 8716 212615 41.8357 -4.3976 2021-05-21 04:20:43 Castilla y Leon, Spain
464201 2021-05-19 Spain Castilla y Leon     227899 6828 8716 212355 41.8357 -4.3976 2021-05-20 04:21:05 Castilla y Leon, Spain
1276157 2021-05-18 Spain Castilla y Leon     227579 6825 8716 212038 41.8357 -4.3976 2021-05-19 04:20:42 Castilla y Leon, Spain
231221 2021-05-17 Spain Castilla y Leon     227316 6816 8716 211784 41.8357 -4.3976 2021-05-18 04:20:33 Castilla y Leon, Spain
1159436 2021-05-16 Spain Castilla y Leon     226769 6804 8716 211249 41.8357 -4.3976 2021-05-17 04:20:34 Castilla y Leon, Spain
1008992 2021-05-15 Spain Castilla y Leon     226769 6804 8716 211249 41.8357 -4.3976 2021-05-16 04:20:49 Castilla y Leon, Spain
805104 2021-05-14 Spain Castilla y Leon     226769 6804 8716 211249 41.8357 -4.3976 2021-05-15 04:20:58 Castilla y Leon, Spain
1192932 2021-05-13 Spain Castilla y Leon     226475 6803 8716 210956 41.8357 -4.3976 2021-05-14 04:20:41 Castilla y Leon, Spain
686061 2021-05-12 Spain Castilla y Leon     226223 6794 8716 210713 41.8357 -4.3976 2021-05-13 04:20:51 Castilla y Leon, Spain
129461 2021-05-11 Spain Castilla y Leon     225983 6788 8716 210479 41.8357 -4.3976 2021-05-12 04:21:29 Castilla y Leon, Spain
1257466 2021-05-10 Spain Castilla y Leon     225660 6785 8716 210159 41.8357 -4.3976 2021-05-11 04:20:41 Castilla y Leon, Spain
121487 2021-05-09 Spain Castilla y Leon     225064 6782 8716 209566 41.8357 -4.3976 2021-05-10 04:20:38 Castilla y Leon, Spain
89057 2021-05-08 Spain Castilla y Leon     225064 6782 8716 209566 41.8357 -4.3976 2021-05-09 04:20:35 Castilla y Leon, Spain
522555 2021-05-07 Spain Castilla y Leon     225064 6782 8716 209566 41.8357 -4.3976 2021-05-08 04:21:04 Castilla y Leon, Spain
1685179 2021-05-06 Spain Castilla y Leon     224712 6778 8716 209218 41.8357 -4.3976 2021-05-07 04:20:40 Castilla y Leon, Spain
23398 2021-05-05 Spain Castilla y Leon     224396 6776 8716 208904 41.8357 -4.3976 2021-05-06 04:20:38 Castilla y Leon, Spain
1331340 2021-05-04 Spain Castilla y Leon     225340 6775 8716 209849 41.8357 -4.3976 2021-05-05 04:20:43 Castilla y Leon, Spain
1035927 2021-05-03 Spain Castilla y Leon     223750 6759 8716 208275 41.8357 -4.3976 2021-05-04 04:20:34 Castilla y Leon, Spain
914117 2021-05-02 Spain Castilla y Leon     223100 6754 8716 207630 41.8357 -4.3976 2021-05-03 04:20:39 Castilla y Leon, Spain
1757083 2021-05-01 Spain Castilla y Leon     223100 6754 8716 207630 41.8357 -4.3976 2021-05-02 04:20:48 Castilla y Leon, Spain
1456854 2021-04-30 Spain Castilla y Leon     223100 6754 8716 207630 41.8357 -4.3976 2021-05-01 04:20:47 Castilla y Leon, Spain
1614668 2021-04-29 Spain Castilla y Leon     222744 6751 8716 207277 41.8357 -4.3976 2021-04-30 04:21:03 Castilla y Leon, Spain
484067 2021-04-28 Spain Castilla y Leon     222354 6750 8716 206888 41.8357 -4.3976 2021-04-29 04:20:55 Castilla y Leon, Spain
335105 2021-04-27 Spain Castilla y Leon     221970 6745 8716 206509 41.8357 -4.3976 2021-04-28 04:20:32 Castilla y Leon, Spain
1358150 2021-04-26 Spain Castilla y Leon     221515 6742 8716 206057 41.8357 -4.3976 2021-04-27 04:20:52 Castilla y Leon, Spain
496106 2021-04-25 Spain Castilla y Leon     220867 6735 8716 205416 41.8357 -4.3976 2021-04-26 04:21:04 Castilla y Leon, Spain
1112705 2021-04-24 Spain Castilla y Leon     220867 6735 8716 205416 41.8357 -4.3976 2021-04-25 04:20:32 Castilla y Leon, Spain
488054 2021-04-23 Spain Castilla y Leon     220867 6735 8716 205416 41.8357 -4.3976 2021-04-24 04:20:38 Castilla y Leon, Spain
1170439 2021-04-22 Spain Castilla y Leon     220468 6727 8716 205025 41.8357 -4.3976 2021-04-23 04:20:52 Castilla y Leon, Spain
1403910 2021-04-21 Spain Castilla y Leon     220083 6723 8716 204644 41.8357 -4.3976 2021-04-22 04:20:53 Castilla y Leon, Spain
1713168 2021-04-20 Spain Castilla y Leon     219244 6713 8716 212934 41.8357 -4.3976 2021-04-21 04:21:14 Castilla y Leon, Spain
607297 2021-04-19 Spain Castilla y Leon     219244 6713 8716 203815 41.8357 -4.3976 2021-04-20 04:20:41 Castilla y Leon, Spain
918104 2021-04-18 Spain Castilla y Leon     218384 6701 8716 202967 41.8357 -4.3976 2021-04-19 04:20:57 Castilla y Leon, Spain
1319415 2021-04-17 Spain Castilla y Leon     218384 6701 8716 202967 41.8357 -4.3976 2021-04-18 04:20:41 Castilla y Leon, Spain
989107 2021-04-16 Spain Castilla y Leon     218384 6701 8716 202967 41.8357 -4.3976 2021-04-17 04:20:40 Castilla y Leon, Spain
380211 2021-04-15 Spain Castilla y Leon     217954 6696 8716 202542 41.8357 -4.3976 2021-04-16 04:20:46 Castilla y Leon, Spain
906161 2021-04-14 Spain Castilla y Leon     217551 6694 8716 202141 41.8357 -4.3976 2021-04-15 04:20:54 Castilla y Leon, Spain
1079388 2021-04-13 Spain Castilla y Leon     217129 6690 8716 201723 41.8357 -4.3976 2021-04-14 04:20:41 Castilla y Leon, Spain
354624 2021-04-12 Spain Castilla y Leon     216720 6681 8716 201323 41.8357 -4.3976 2021-04-13 04:20:37 Castilla y Leon, Spain
1181073 2021-04-11 Spain Castilla y Leon     215845 6673 8716 200456 41.8357 -4.3976 2021-04-12 04:21:00 Castilla y Leon, Spain
1188945 2021-04-10 Spain Castilla y Leon     215845 6673 8716 200456 41.8357 -4.3976 2021-04-11 04:20:56 Castilla y Leon, Spain
1693131 2021-04-09 Spain Castilla y Leon     215845 6673 8716 200456 41.8357 -4.3976 2021-04-10 04:20:59 Castilla y Leon, Spain
569370 2021-04-08 Spain Castilla y Leon     215410 6672 8716 200022 41.8357 -4.3976 2021-04-09 04:21:13 Castilla y Leon, Spain
1346189 2021-04-07 Spain Castilla y Leon     214908 6658 8716 199534 41.8357 -4.3976 2021-04-08 04:21:13 Castilla y Leon, Spain
350557 2021-04-06 Spain Castilla y Leon     214460 6648 8716 199096 41.8357 -4.3976 2021-04-07 04:20:53 Castilla y Leon, Spain
1043882 2021-04-05 Spain Castilla y Leon     214007 6638 8716 198653 41.8357 -4.3976 2021-04-06 04:20:32 Castilla y Leon, Spain
215202 2021-04-04 Spain Castilla y Leon     213472 6633 8716 198123 41.8357 -4.3976 2021-04-05 04:20:35 Castilla y Leon, Spain
1701161 2021-04-03 Spain Castilla y Leon     213472 6633 8716 198123 41.8357 -4.3976 2021-04-04 04:20:49 Castilla y Leon, Spain
953850 2021-04-02 Spain Castilla y Leon     213046 6631 8716 197699 41.8357 -4.3976 2021-04-03 04:20:44 Castilla y Leon, Spain
125474 2021-04-01 Spain Castilla y Leon     213046 6631 8716 197699 41.8357 -4.3976 2021-04-02 04:20:36 Castilla y Leon, Spain
1516366 2021-03-31 Spain Castilla y Leon     212625 6626 8716 197283 41.8357 -4.3976 2021-04-01 04:27:05 Castilla y Leon, Spain
1717155 2021-03-30 Spain Castilla y Leon     212298 6622 8716 196960 41.8357 -4.3976 2021-03-31 04:26:25 Castilla y Leon, Spain
733142 2021-03-29 Spain Castilla y Leon     211909 6611 8716 196582 41.8357 -4.3976 2021-03-30 04:26:23 Castilla y Leon, Spain
422446 2021-03-28 Spain Castilla y Leon     211261 6608 8716 195937 41.8357 -4.3976 2021-03-29 04:28:35 Castilla y Leon, Spain
1732837 2021-03-27 Spain Castilla y Leon     211261 6608 8716 195937 41.8357 -4.3976 2021-03-28 05:28:10 Castilla y Leon, Spain
403280 2021-03-26 Spain Castilla y Leon     211261 6608 8716 195937 41.8357 -4.3976 2021-03-27 05:25:04 Castilla y Leon, Spain
1354163 2021-03-25 Spain Castilla y Leon     211004 6592 8716 195696 41.8357 -4.3976 2021-03-26 05:26:55 Castilla y Leon, Spain
507853 2021-03-24 Spain Castilla y Leon     210470 6585 8716 195169 41.8357 -4.3976 2021-03-25 05:27:00 Castilla y Leon, Spain
1590770 2021-03-23 Spain Castilla y Leon     210470 6585 8716 195169 41.8357 -4.3976 2021-03-24 05:25:40 Castilla y Leon, Spain
840162 2021-03-22 Spain Castilla y Leon     210267 6573 8716 194978 41.8357 -4.3976 2021-03-23 05:26:18 Castilla y Leon, Spain
721402 2021-03-21 Spain Castilla y Leon     209571 6550 8716 194305 41.8357 -4.3976 2021-03-22 05:25:43 Castilla y Leon, Spain
442545 2021-03-20 Spain Castilla y Leon     209571 6550 8716 194305 41.8357 -4.3976 2021-03-21 05:25:44 Castilla y Leon, Spain
545487 2021-03-19 Spain Castilla y Leon     209571 6550 8716 194305 41.8357 -4.3976 2021-03-20 05:25:46 Castilla y Leon, Spain
1350176 2021-03-18 Spain Castilla y Leon     209571 6550 8716 194305 41.8357 -4.3976 2021-03-19 05:26:09 Castilla y Leon, Spain
85070 2021-03-17 Spain Castilla y Leon     209333 6542 8716 194075 41.8357 -4.3976 2021-03-18 05:26:22 Castilla y Leon, 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]);