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

View and edit SQL

country_or_region

  • Spain · 7,218
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
791118 2021-05-04 Spain Andalusia     554961 9666 10671 534624 37.5443 -4.7278 2021-05-05 04:20:43 Andalusia, Spain
791119 2021-05-04 Spain Aragon     119340 3446 3772 112122 41.5976 -0.9057 2021-05-05 04:20:43 Aragon, Spain
791120 2021-05-04 Spain Asturias     50995 1945 1063 47987 43.3614 -5.8593 2021-05-05 04:20:43 Asturias, Spain
791121 2021-05-04 Spain Baleares     59463 823 1533 57107 39.710358 2.995148 2021-05-05 04:20:43 Baleares, Spain
791122 2021-05-04 Spain C. Valenciana     391121 7318 9970 373833 39.484 -0.7533 2021-05-05 04:20:43 C. Valenciana, Spain
791123 2021-05-04 Spain Canarias     53169 732 1537 50900 28.2916 -16.6291 2021-05-05 04:20:43 Canarias, Spain
791124 2021-05-04 Spain Cantabria     29142 557 2287 26298 43.1828 -3.9878 2021-05-05 04:20:43 Cantabria, Spain
791125 2021-05-04 Spain Castilla - La Mancha     186481 5861 6392 174228 39.2796 -3.0977 2021-05-05 04:20:43 Castilla - La Mancha, Spain
791126 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
791127 2021-05-04 Spain Catalonia     587461 14191 26203 547067 41.5912 1.5209 2021-05-05 04:20:43 Catalonia, Spain
791128 2021-05-04 Spain Ceuta     5766 107 163 5496 35.8894 -5.3213 2021-05-05 04:20:43 Ceuta, Spain
791129 2021-05-04 Spain Extremadura     74254 1791 2652 69811 39.4937 -6.0679 2021-05-05 04:20:43 Extremadura, Spain
791130 2021-05-04 Spain Galicia     122625 2378 9204 111043 42.5751 -8.1339 2021-05-05 04:20:43 Galicia, Spain
791131 2021-05-04 Spain La Rioja     29826 760 3107 25959 42.2871 -2.5396 2021-05-05 04:20:43 La Rioja, Spain
791132 2021-05-04 Spain Madrid     686681 15016 40736 630929 40.4168 -3.7038 2021-05-05 04:20:43 Madrid, Spain
791133 2021-05-04 Spain Melilla     8753 90 125 8538 35.2923 -2.9381 2021-05-05 04:20:43 Melilla, Spain
791134 2021-05-04 Spain Murcia     110994 1590 2180 107224 37.9922 -1.1307 2021-05-05 04:20:43 Murcia, Spain
791135 2021-05-04 Spain Navarra     60376 1164 3905 55307 42.6954 -1.6761 2021-05-05 04:20:43 Navarra, Spain
791136 2021-05-04 Spain Pais Vasco     188197 4189 16160 167848 42.9896 -2.6189 2021-05-05 04:20:43 Pais Vasco, Spain
791137 2021-05-04 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1613648 2021-05-03 Spain Andalusia     553953 9634 10671 533648 37.5443 -4.7278 2021-05-04 04:20:34 Andalusia, Spain
1613649 2021-05-03 Spain Aragon     119153 3444 3772 111937 41.5976 -0.9057 2021-05-04 04:20:34 Aragon, Spain
1613650 2021-05-03 Spain Asturias     50925 1945 1063 47917 43.3614 -5.8593 2021-05-04 04:20:34 Asturias, Spain
1613651 2021-05-03 Spain Baleares     59427 822 1533 57072 39.710358 2.995148 2021-05-04 04:20:34 Baleares, Spain
1613652 2021-05-03 Spain C. Valenciana     390994 7313 9970 373711 39.484 -0.7533 2021-05-04 04:20:34 C. Valenciana, Spain
1613653 2021-05-03 Spain Canarias     53026 732 1537 50757 28.2916 -16.6291 2021-05-04 04:20:34 Canarias, Spain
1613654 2021-05-03 Spain Cantabria     29059 557 2287 26215 43.1828 -3.9878 2021-05-04 04:20:34 Cantabria, Spain
1613655 2021-05-03 Spain Castilla - La Mancha     186199 5861 6392 173946 39.2796 -3.0977 2021-05-04 04:20:34 Castilla - La Mancha, Spain
1613656 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
1613657 2021-05-03 Spain Catalonia     588394 14152 26203 548039 41.5912 1.5209 2021-05-04 04:20:34 Catalonia, Spain
1613658 2021-05-03 Spain Ceuta     5764 106 163 5495 35.8894 -5.3213 2021-05-04 04:20:34 Ceuta, Spain
1613659 2021-05-03 Spain Extremadura     74181 1791 2652 69738 39.4937 -6.0679 2021-05-04 04:20:34 Extremadura, Spain
1613660 2021-05-03 Spain Galicia     122477 2377 9204 110896 42.5751 -8.1339 2021-05-04 04:20:34 Galicia, Spain
1613661 2021-05-03 Spain La Rioja     29792 760 3107 25925 42.2871 -2.5396 2021-05-04 04:20:34 La Rioja, Spain
1613662 2021-05-03 Spain Madrid     685903 15015 40736 630152 40.4168 -3.7038 2021-05-04 04:20:34 Madrid, Spain
1613663 2021-05-03 Spain Melilla     8735 89 125 8521 35.2923 -2.9381 2021-05-04 04:20:34 Melilla, Spain
1613664 2021-05-03 Spain Murcia     110919 1587 2180 107152 37.9922 -1.1307 2021-05-04 04:20:34 Murcia, Spain
1613665 2021-05-03 Spain Navarra     60249 1163 3905 55181 42.6954 -1.6761 2021-05-04 04:20:34 Navarra, Spain
1613666 2021-05-03 Spain Pais Vasco     187530 4186 16160 167184 42.9896 -2.6189 2021-05-04 04:20:34 Pais Vasco, Spain
1613667 2021-05-03 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
886286 2021-05-02 Spain Andalusia     551106 9628 10671 530807 37.5443 -4.7278 2021-05-03 04:20:39 Andalusia, Spain
886287 2021-05-02 Spain Aragon     118361 3437 3772 111152 41.5976 -0.9057 2021-05-03 04:20:39 Aragon, Spain
886288 2021-05-02 Spain Asturias     50733 1944 1063 47726 43.3614 -5.8593 2021-05-03 04:20:39 Asturias, Spain
886289 2021-05-02 Spain Baleares     59276 820 1533 56923 39.710358 2.995148 2021-05-03 04:20:39 Baleares, Spain
886290 2021-05-02 Spain C. Valenciana     390646 7306 9970 373370 39.484 -0.7533 2021-05-03 04:20:39 C. Valenciana, Spain
886291 2021-05-02 Spain Canarias     52655 731 1537 50387 28.2916 -16.6291 2021-05-03 04:20:39 Canarias, Spain
886292 2021-05-02 Spain Cantabria     28763 557 2287 25919 43.1828 -3.9878 2021-05-03 04:20:39 Cantabria, Spain
886293 2021-05-02 Spain Castilla - La Mancha     185354 5851 6392 173111 39.2796 -3.0977 2021-05-03 04:20:39 Castilla - La Mancha, Spain
886294 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
886295 2021-05-02 Spain Catalonia     585069 14149 26203 544717 41.5912 1.5209 2021-05-03 04:20:39 Catalonia, Spain
886296 2021-05-02 Spain Ceuta     5753 104 163 5486 35.8894 -5.3213 2021-05-03 04:20:39 Ceuta, Spain
886297 2021-05-02 Spain Extremadura     73966 1790 2652 69524 39.4937 -6.0679 2021-05-03 04:20:39 Extremadura, Spain
886298 2021-05-02 Spain Galicia     122010 2377 9204 110429 42.5751 -8.1339 2021-05-03 04:20:39 Galicia, Spain
886299 2021-05-02 Spain La Rioja     29605 760 3107 25738 42.2871 -2.5396 2021-05-03 04:20:39 La Rioja, Spain
886300 2021-05-02 Spain Madrid     682556 14994 40736 626826 40.4168 -3.7038 2021-05-03 04:20:39 Madrid, Spain
886301 2021-05-02 Spain Melilla     8705 89 125 8491 35.2923 -2.9381 2021-05-03 04:20:39 Melilla, Spain
886302 2021-05-02 Spain Murcia     110778 1587 2180 107011 37.9922 -1.1307 2021-05-03 04:20:39 Murcia, Spain
886303 2021-05-02 Spain Navarra     59870 1156 3905 54809 42.6954 -1.6761 2021-05-03 04:20:39 Navarra, Spain
886304 2021-05-02 Spain Pais Vasco     185771 4182 16160 165429 42.9896 -2.6189 2021-05-03 04:20:39 Pais Vasco, Spain
886305 2021-05-02 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
511991 2021-05-01 Spain Andalusia     551106 9628 10671 530807 37.5443 -4.7278 2021-05-02 04:20:48 Andalusia, Spain
511992 2021-05-01 Spain Aragon     118361 3437 3772 111152 41.5976 -0.9057 2021-05-02 04:20:48 Aragon, Spain
511993 2021-05-01 Spain Asturias     50733 1944 1063 47726 43.3614 -5.8593 2021-05-02 04:20:48 Asturias, Spain
511994 2021-05-01 Spain Baleares     59276 820 1533 56923 39.710358 2.995148 2021-05-02 04:20:48 Baleares, Spain
511995 2021-05-01 Spain C. Valenciana     390646 7306 9970 373370 39.484 -0.7533 2021-05-02 04:20:48 C. Valenciana, Spain
511996 2021-05-01 Spain Canarias     52655 731 1537 50387 28.2916 -16.6291 2021-05-02 04:20:48 Canarias, Spain
511997 2021-05-01 Spain Cantabria     28763 557 2287 25919 43.1828 -3.9878 2021-05-02 04:20:48 Cantabria, Spain
511998 2021-05-01 Spain Castilla - La Mancha     185354 5851 6392 173111 39.2796 -3.0977 2021-05-02 04:20:48 Castilla - La Mancha, Spain
511999 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
512000 2021-05-01 Spain Catalonia     585069 14149 26203 544717 41.5912 1.5209 2021-05-02 04:20:48 Catalonia, Spain
512001 2021-05-01 Spain Ceuta     5753 104 163 5486 35.8894 -5.3213 2021-05-02 04:20:48 Ceuta, Spain
512002 2021-05-01 Spain Extremadura     73966 1790 2652 69524 39.4937 -6.0679 2021-05-02 04:20:48 Extremadura, Spain
512003 2021-05-01 Spain Galicia     122010 2377 9204 110429 42.5751 -8.1339 2021-05-02 04:20:48 Galicia, Spain
512004 2021-05-01 Spain La Rioja     29605 760 3107 25738 42.2871 -2.5396 2021-05-02 04:20:48 La Rioja, Spain
512005 2021-05-01 Spain Madrid     682556 14994 40736 626826 40.4168 -3.7038 2021-05-02 04:20:48 Madrid, Spain
512006 2021-05-01 Spain Melilla     8705 89 125 8491 35.2923 -2.9381 2021-05-02 04:20:48 Melilla, Spain
512007 2021-05-01 Spain Murcia     110778 1587 2180 107011 37.9922 -1.1307 2021-05-02 04:20:48 Murcia, Spain
512008 2021-05-01 Spain Navarra     59870 1156 3905 54809 42.6954 -1.6761 2021-05-02 04:20:48 Navarra, Spain
512009 2021-05-01 Spain Pais Vasco     185771 4182 16160 165429 42.9896 -2.6189 2021-05-02 04:20:48 Pais Vasco, Spain
512010 2021-05-01 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
14927 2021-04-30 Spain Andalusia     551106 9628 10671 530807 37.5443 -4.7278 2021-05-01 04:20:47 Andalusia, Spain
14928 2021-04-30 Spain Aragon     118361 3437 3772 111152 41.5976 -0.9057 2021-05-01 04:20:47 Aragon, Spain
14929 2021-04-30 Spain Asturias     50733 1944 1063 47726 43.3614 -5.8593 2021-05-01 04:20:47 Asturias, Spain
14930 2021-04-30 Spain Baleares     59276 820 1533 56923 39.710358 2.995148 2021-05-01 04:20:47 Baleares, Spain
14931 2021-04-30 Spain C. Valenciana     390646 7306 9970 373370 39.484 -0.7533 2021-05-01 04:20:47 C. Valenciana, Spain
14932 2021-04-30 Spain Canarias     52655 731 1537 50387 28.2916 -16.6291 2021-05-01 04:20:47 Canarias, Spain
14933 2021-04-30 Spain Cantabria     28763 557 2287 25919 43.1828 -3.9878 2021-05-01 04:20:47 Cantabria, Spain
14934 2021-04-30 Spain Castilla - La Mancha     185354 5851 6392 173111 39.2796 -3.0977 2021-05-01 04:20:47 Castilla - La Mancha, Spain
14935 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
14936 2021-04-30 Spain Catalonia     585069 14149 26203 544717 41.5912 1.5209 2021-05-01 04:20:47 Catalonia, Spain
14937 2021-04-30 Spain Ceuta     5753 104 163 5486 35.8894 -5.3213 2021-05-01 04:20:47 Ceuta, Spain
14938 2021-04-30 Spain Extremadura     73966 1790 2652 69524 39.4937 -6.0679 2021-05-01 04:20:47 Extremadura, Spain
14939 2021-04-30 Spain Galicia     122010 2377 9204 110429 42.5751 -8.1339 2021-05-01 04:20:47 Galicia, Spain
14940 2021-04-30 Spain La Rioja     29605 760 3107 25738 42.2871 -2.5396 2021-05-01 04:20:47 La Rioja, Spain
14941 2021-04-30 Spain Madrid     682556 14994 40736 626826 40.4168 -3.7038 2021-05-01 04:20:47 Madrid, Spain
14942 2021-04-30 Spain Melilla     8705 89 125 8491 35.2923 -2.9381 2021-05-01 04:20:47 Melilla, Spain
14943 2021-04-30 Spain Murcia     110778 1587 2180 107011 37.9922 -1.1307 2021-05-01 04:20:47 Murcia, Spain
14944 2021-04-30 Spain Navarra     59870 1156 3905 54809 42.6954 -1.6761 2021-05-01 04:20:47 Navarra, Spain
14945 2021-04-30 Spain Pais Vasco     185771 4182 16160 165429 42.9896 -2.6189 2021-05-01 04:20:47 Pais Vasco, Spain
14946 2021-04-30 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, 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]);