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

View and edit SQL

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

province_or_state

  • Andalusia · 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
235203 2021-06-24 Spain Andalusia     612979 10026 10671 592282 37.5443 -4.7278 2021-06-25 04:21:33 Andalusia, Spain
472151 2021-06-23 Spain Andalusia     611513 10025 10671 590817 37.5443 -4.7278 2021-06-24 04:21:55 Andalusia, Spain
627209 2021-06-22 Spain Andalusia     610335 10019 10671 589645 37.5443 -4.7278 2021-06-23 04:21:46 Andalusia, Spain
227229 2021-06-21 Spain Andalusia     609412 10016 10671 588725 37.5443 -4.7278 2021-06-22 04:21:34 Andalusia, Spain
1472751 2021-06-20 Spain Andalusia     606879 10009 10671 586199 37.5443 -4.7278 2021-06-21 04:21:41 Andalusia, Spain
1303992 2021-06-19 Spain Andalusia     606879 10009 10671 586199 37.5443 -4.7278 2021-06-20 04:21:48 Andalusia, Spain
303594 2021-06-18 Spain Andalusia     606879 10009 10671 586199 37.5443 -4.7278 2021-06-19 04:22:33 Andalusia, Spain
886424 2021-06-17 Spain Andalusia     605431 10008 10671 584752 37.5443 -4.7278 2021-06-18 04:22:16 Andalusia, Spain
42319 2021-06-16 Spain Andalusia     603988 10000 10671 583317 37.5443 -4.7278 2021-06-17 04:22:36 Andalusia, Spain
1705141 2021-06-15 Spain Andalusia     602955 9999 10671 582285 37.5443 -4.7278 2021-06-16 04:22:32 Andalusia, Spain
1661412 2021-06-14 Spain Andalusia     601677 9981 10671 581025 37.5443 -4.7278 2021-06-15 04:22:22 Andalusia, Spain
319488 2021-06-13 Spain Andalusia     598947 9975 10671 578301 37.5443 -4.7278 2021-06-14 04:22:46 Andalusia, Spain
619233 2021-06-12 Spain Andalusia     598947 9975 10671 578301 37.5443 -4.7278 2021-06-13 04:22:44 Andalusia, Spain
592242 2021-06-11 Spain Andalusia     598947 9975 10671 578301 37.5443 -4.7278 2021-06-12 04:22:22 Andalusia, Spain
273120 2021-06-10 Spain Andalusia     597465 9967 10671 576827 37.5443 -4.7278 2021-06-11 04:23:20 Andalusia, Spain
1638178 2021-06-09 Spain Andalusia     595838 9950 10671 575217 37.5443 -4.7278 2021-06-10 04:23:17 Andalusia, Spain
1744791 2021-06-08 Spain Andalusia     594650 9947 10671 574032 37.5443 -4.7278 2021-06-09 04:23:31 Andalusia, Spain
577334 2021-06-07 Spain Andalusia     593602 9934 10671 572997 37.5443 -4.7278 2021-06-08 04:22:35 Andalusia, Spain
246197 2021-06-06 Spain Andalusia     590684 9928 10671 570085 37.5443 -4.7278 2021-06-07 04:22:51 Andalusia, Spain
674174 2021-06-05 Spain Andalusia     590684 9928 10671 570085 37.5443 -4.7278 2021-06-06 04:24:03 Andalusia, Spain
553437 2021-06-04 Spain Andalusia     590684 9928 10671 570085 37.5443 -4.7278 2021-06-05 04:23:03 Andalusia, Spain
1460834 2021-06-03 Spain Andalusia     589198 9918 10671 568609 37.5443 -4.7278 2021-06-04 04:23:37 Andalusia, Spain
1399827 2021-06-02 Spain Andalusia     587551 9918 10671 566962 37.5443 -4.7278 2021-06-03 04:23:32 Andalusia, Spain
1709174 2021-06-01 Spain Andalusia     586178 9900 10671 565607 37.5443 -4.7278 2021-06-02 04:24:34 Andalusia, Spain
19404 2021-05-31 Spain Andalusia     584878 9887 10671 564320 37.5443 -4.7278 2021-06-01 04:23:09 Andalusia, Spain
1497797 2021-05-30 Spain Andalusia     581880 9880 10671 561329 37.5443 -4.7278 2021-05-31 03:08:59 Andalusia, Spain
623220 2021-05-29 Spain Andalusia     581880 9880 10671 561329 37.5443 -4.7278 2021-05-30 04:20:55 Andalusia, Spain
81076 2021-05-28 Spain Andalusia     581880 9880 10671 561329 37.5443 -4.7278 2021-05-29 04:20:41 Andalusia, Spain
1426351 2021-05-27 Spain Andalusia     580383 9877 10671 559835 37.5443 -4.7278 2021-05-28 04:20:36 Andalusia, Spain
1549318 2021-05-26 Spain Andalusia     578909 9875 10671 558363 37.5443 -4.7278 2021-05-27 04:20:59 Andalusia, Spain
1200894 2021-05-25 Spain Andalusia     577638 9867 10671 557100 37.5443 -4.7278 2021-05-26 04:20:35 Andalusia, Spain
149887 2021-05-24 Spain Andalusia     576718 9866 10671 556181 37.5443 -4.7278 2021-05-25 04:21:08 Andalusia, Spain
690040 2021-05-23 Spain Andalusia     574048 9856 10671 553521 37.5443 -4.7278 2021-05-24 04:20:53 Andalusia, Spain
387654 2021-05-22 Spain Andalusia     574048 9856 10671 553521 37.5443 -4.7278 2021-05-23 04:20:51 Andalusia, Spain
969969 2021-05-21 Spain Andalusia     574048 9856 10671 553521 37.5443 -4.7278 2021-05-22 04:20:45 Andalusia, Spain
57931 2021-05-20 Spain Andalusia     572825 9853 10671 552301 37.5443 -4.7278 2021-05-21 04:20:43 Andalusia, Spain
464193 2021-05-19 Spain Andalusia     571401 9840 10671 550890 37.5443 -4.7278 2021-05-20 04:21:05 Andalusia, Spain
1276149 2021-05-18 Spain Andalusia     570363 9825 10671 549867 37.5443 -4.7278 2021-05-19 04:20:42 Andalusia, Spain
231213 2021-05-17 Spain Andalusia     569401 9808 10671 548922 37.5443 -4.7278 2021-05-18 04:20:33 Andalusia, Spain
1159428 2021-05-16 Spain Andalusia     566808 9797 10671 546340 37.5443 -4.7278 2021-05-17 04:20:34 Andalusia, Spain
1008984 2021-05-15 Spain Andalusia     566808 9797 10671 546340 37.5443 -4.7278 2021-05-16 04:20:49 Andalusia, Spain
805096 2021-05-14 Spain Andalusia     566808 9797 10671 546340 37.5443 -4.7278 2021-05-15 04:20:58 Andalusia, Spain
1192924 2021-05-13 Spain Andalusia     565201 9787 10671 544743 37.5443 -4.7278 2021-05-14 04:20:41 Andalusia, Spain
686053 2021-05-12 Spain Andalusia     563882 9778 10671 543433 37.5443 -4.7278 2021-05-13 04:20:51 Andalusia, Spain
129453 2021-05-11 Spain Andalusia     562593 9760 10671 542162 37.5443 -4.7278 2021-05-12 04:21:29 Andalusia, Spain
1257458 2021-05-10 Spain Andalusia     561585 9708 10671 541206 37.5443 -4.7278 2021-05-11 04:20:41 Andalusia, Spain
121479 2021-05-09 Spain Andalusia     558932 9700 10671 538561 37.5443 -4.7278 2021-05-10 04:20:38 Andalusia, Spain
89049 2021-05-08 Spain Andalusia     558932 9700 10671 538561 37.5443 -4.7278 2021-05-09 04:20:35 Andalusia, Spain
522547 2021-05-07 Spain Andalusia     558932 9700 10671 538561 37.5443 -4.7278 2021-05-08 04:21:04 Andalusia, Spain
1685171 2021-05-06 Spain Andalusia     557408 9689 10671 537048 37.5443 -4.7278 2021-05-07 04:20:40 Andalusia, Spain
23390 2021-05-05 Spain Andalusia     556194 9681 10671 535842 37.5443 -4.7278 2021-05-06 04:20:38 Andalusia, Spain
1331332 2021-05-04 Spain Andalusia     554961 9666 10671 534624 37.5443 -4.7278 2021-05-05 04:20:43 Andalusia, Spain
1035919 2021-05-03 Spain Andalusia     553953 9634 10671 533648 37.5443 -4.7278 2021-05-04 04:20:34 Andalusia, Spain
914109 2021-05-02 Spain Andalusia     551106 9628 10671 530807 37.5443 -4.7278 2021-05-03 04:20:39 Andalusia, Spain
1757075 2021-05-01 Spain Andalusia     551106 9628 10671 530807 37.5443 -4.7278 2021-05-02 04:20:48 Andalusia, Spain
1456846 2021-04-30 Spain Andalusia     551106 9628 10671 530807 37.5443 -4.7278 2021-05-01 04:20:47 Andalusia, Spain
1614660 2021-04-29 Spain Andalusia     549722 9617 10671 529434 37.5443 -4.7278 2021-04-30 04:21:03 Andalusia, Spain
484059 2021-04-28 Spain Andalusia     548238 9612 10671 527955 37.5443 -4.7278 2021-04-29 04:20:55 Andalusia, Spain
335097 2021-04-27 Spain Andalusia     546943 9584 10671 526688 37.5443 -4.7278 2021-04-28 04:20:32 Andalusia, Spain
1358142 2021-04-26 Spain Andalusia     545483 9564 10671 525248 37.5443 -4.7278 2021-04-27 04:20:52 Andalusia, Spain
496098 2021-04-25 Spain Andalusia     541843 9528 10671 521644 37.5443 -4.7278 2021-04-26 04:21:04 Andalusia, Spain
1112697 2021-04-24 Spain Andalusia     541843 9528 10671 521644 37.5443 -4.7278 2021-04-25 04:20:32 Andalusia, Spain
488046 2021-04-23 Spain Andalusia     541843 9528 10671 521644 37.5443 -4.7278 2021-04-24 04:20:38 Andalusia, Spain
1170431 2021-04-22 Spain Andalusia     539780 9495 10671 519614 37.5443 -4.7278 2021-04-23 04:20:52 Andalusia, Spain
1403902 2021-04-21 Spain Andalusia     537908 9479 10671 517758 37.5443 -4.7278 2021-04-22 04:20:53 Andalusia, Spain
1713160 2021-04-20 Spain Andalusia     534597 9432 10671 526550 37.5443 -4.7278 2021-04-21 04:21:14 Andalusia, Spain
607289 2021-04-19 Spain Andalusia     534597 9432 10671 514494 37.5443 -4.7278 2021-04-20 04:20:41 Andalusia, Spain
918096 2021-04-18 Spain Andalusia     530392 9415 10671 510306 37.5443 -4.7278 2021-04-19 04:20:57 Andalusia, Spain
1319407 2021-04-17 Spain Andalusia     530392 9415 10671 510306 37.5443 -4.7278 2021-04-18 04:20:41 Andalusia, Spain
989099 2021-04-16 Spain Andalusia     530392 9415 10671 510306 37.5443 -4.7278 2021-04-17 04:20:40 Andalusia, Spain
380203 2021-04-15 Spain Andalusia     527997 9393 10671 507933 37.5443 -4.7278 2021-04-16 04:20:46 Andalusia, Spain
906153 2021-04-14 Spain Andalusia     526143 9379 10671 506093 37.5443 -4.7278 2021-04-15 04:20:54 Andalusia, Spain
1079380 2021-04-13 Spain Andalusia     523865 9362 10671 503832 37.5443 -4.7278 2021-04-14 04:20:41 Andalusia, Spain
354616 2021-04-12 Spain Andalusia     523865 9362 10671 503832 37.5443 -4.7278 2021-04-13 04:20:37 Andalusia, Spain
1181065 2021-04-11 Spain Andalusia     518285 9347 10671 498267 37.5443 -4.7278 2021-04-12 04:21:00 Andalusia, Spain
1188937 2021-04-10 Spain Andalusia     518285 9347 10671 498267 37.5443 -4.7278 2021-04-11 04:20:56 Andalusia, Spain
1693123 2021-04-09 Spain Andalusia     518285 9347 10671 498267 37.5443 -4.7278 2021-04-10 04:20:59 Andalusia, Spain
569362 2021-04-08 Spain Andalusia     516112 9332 10671 496109 37.5443 -4.7278 2021-04-09 04:21:13 Andalusia, Spain
1346181 2021-04-07 Spain Andalusia     513619 9315 10671 493633 37.5443 -4.7278 2021-04-08 04:21:13 Andalusia, Spain
350549 2021-04-06 Spain Andalusia     511920 9276 10671 491973 37.5443 -4.7278 2021-04-07 04:20:53 Andalusia, Spain
1043874 2021-04-05 Spain Andalusia     510909 9241 10671 490997 37.5443 -4.7278 2021-04-06 04:20:32 Andalusia, Spain
215194 2021-04-04 Spain Andalusia     508174 9214 10671 488289 37.5443 -4.7278 2021-04-05 04:20:35 Andalusia, Spain
1701153 2021-04-03 Spain Andalusia     508174 9214 10671 488289 37.5443 -4.7278 2021-04-04 04:20:49 Andalusia, Spain
953842 2021-04-02 Spain Andalusia     505796 9206 10671 485919 37.5443 -4.7278 2021-04-03 04:20:44 Andalusia, Spain
125466 2021-04-01 Spain Andalusia     505796 9206 10671 485919 37.5443 -4.7278 2021-04-02 04:20:36 Andalusia, Spain
1516358 2021-03-31 Spain Andalusia     505796 9206 10671 485919 37.5443 -4.7278 2021-04-01 04:27:05 Andalusia, Spain
1717147 2021-03-30 Spain Andalusia     504001 9193 10671 484137 37.5443 -4.7278 2021-03-31 04:26:25 Andalusia, Spain
733134 2021-03-29 Spain Andalusia     503853 9176 10671 484006 37.5443 -4.7278 2021-03-30 04:26:23 Andalusia, Spain
422438 2021-03-28 Spain Andalusia     501013 9147 10671 481195 37.5443 -4.7278 2021-03-29 04:28:35 Andalusia, Spain
1732829 2021-03-27 Spain Andalusia     501013 9147 10671 481195 37.5443 -4.7278 2021-03-28 05:28:10 Andalusia, Spain
403272 2021-03-26 Spain Andalusia     501013 9147 10671 481195 37.5443 -4.7278 2021-03-27 05:25:04 Andalusia, Spain
1354155 2021-03-25 Spain Andalusia     499710 9136 10671 479903 37.5443 -4.7278 2021-03-26 05:26:55 Andalusia, Spain
507845 2021-03-24 Spain Andalusia     497531 9093 10671 477767 37.5443 -4.7278 2021-03-25 05:27:00 Andalusia, Spain
1590762 2021-03-23 Spain Andalusia     497531 9093 10671 477767 37.5443 -4.7278 2021-03-24 05:25:40 Andalusia, Spain
840154 2021-03-22 Spain Andalusia     496864 9060 10671 477133 37.5443 -4.7278 2021-03-23 05:26:18 Andalusia, Spain
721394 2021-03-21 Spain Andalusia     493578 8988 10671 473919 37.5443 -4.7278 2021-03-22 05:25:43 Andalusia, Spain
442537 2021-03-20 Spain Andalusia     493578 8988 10671 473919 37.5443 -4.7278 2021-03-21 05:25:44 Andalusia, Spain
545479 2021-03-19 Spain Andalusia     493578 8988 10671 473919 37.5443 -4.7278 2021-03-20 05:25:46 Andalusia, Spain
1350168 2021-03-18 Spain Andalusia     493578 8988 10671 473919 37.5443 -4.7278 2021-03-19 05:26:09 Andalusia, Spain
85062 2021-03-17 Spain Andalusia     492490 8947 10671 472872 37.5443 -4.7278 2021-03-18 05:26:22 Andalusia, 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]);