johns_hopkins_csse_daily_reports

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

7,298 rows where country_or_region = "Spain" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Spain · 7,298 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1020512 1020512 2021-05-08 Spain Andalusia     558932 9700 10671 538561 37.5443 -4.7278 2021-05-09 04:20:35 Andalusia, Spain
1020513 1020513 2021-05-08 Spain Aragon     120282 3452 3772 113058 41.5976 -0.9057 2021-05-09 04:20:35 Aragon, Spain
1020514 1020514 2021-05-08 Spain Asturias     51158 1946 1063 48149 43.3614 -5.8593 2021-05-09 04:20:35 Asturias, Spain
1020515 1020515 2021-05-08 Spain Baleares     59627 827 1533 57267 39.710358 2.995148 2021-05-09 04:20:35 Baleares, Spain
1020516 1020516 2021-05-08 Spain C. Valenciana     391613 7329 9970 374314 39.484 -0.7533 2021-05-09 04:20:35 C. Valenciana, Spain
1020517 1020517 2021-05-08 Spain Canarias     53609 742 1537 51330 28.2916 -16.6291 2021-05-09 04:20:35 Canarias, Spain
1020518 1020518 2021-05-08 Spain Cantabria     29352 558 2287 26507 43.1828 -3.9878 2021-05-09 04:20:35 Cantabria, Spain
1020519 1020519 2021-05-08 Spain Castilla - La Mancha     187594 5883 6392 175319 39.2796 -3.0977 2021-05-09 04:20:35 Castilla - La Mancha, Spain
1020520 1020520 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
1020521 1020521 2021-05-08 Spain Catalonia     592912 14319 26203 552390 41.5912 1.5209 2021-05-09 04:20:35 Catalonia, Spain
1020522 1020522 2021-05-08 Spain Ceuta     5770 109 163 5498 35.8894 -5.3213 2021-05-09 04:20:35 Ceuta, Spain
1020523 1020523 2021-05-08 Spain Extremadura     74442 1794 2652 69996 39.4937 -6.0679 2021-05-09 04:20:35 Extremadura, Spain
1020524 1020524 2021-05-08 Spain Galicia     123274 2380 9204 111690 42.5751 -8.1339 2021-05-09 04:20:35 Galicia, Spain
1020525 1020525 2021-05-08 Spain La Rioja     30005 762 3107 26136 42.2871 -2.5396 2021-05-09 04:20:35 La Rioja, Spain
1020526 1020526 2021-05-08 Spain Madrid     692750 15087 40736 636927 40.4168 -3.7038 2021-05-09 04:20:35 Madrid, Spain
1020527 1020527 2021-05-08 Spain Melilla     8826 94 125 8607 35.2923 -2.9381 2021-05-09 04:20:35 Melilla, Spain
1020528 1020528 2021-05-08 Spain Murcia     111248 1590 2180 107478 37.9922 -1.1307 2021-05-09 04:20:35 Murcia, Spain
1020529 1020529 2021-05-08 Spain Navarra     60753 1164 3905 55684 42.6954 -1.6761 2021-05-09 04:20:35 Navarra, Spain
1020530 1020530 2021-05-08 Spain Pais Vasco     190197 4274 16160 169763 42.9896 -2.6189 2021-05-09 04:20:35 Pais Vasco, Spain
1020531 1020531 2021-05-08 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
928685 928685 2021-05-07 Spain Andalusia     558932 9700 10671 538561 37.5443 -4.7278 2021-05-08 04:21:04 Andalusia, Spain
928686 928686 2021-05-07 Spain Aragon     120282 3452 3772 113058 41.5976 -0.9057 2021-05-08 04:21:04 Aragon, Spain
928687 928687 2021-05-07 Spain Asturias     51158 1946 1063 48149 43.3614 -5.8593 2021-05-08 04:21:04 Asturias, Spain
928688 928688 2021-05-07 Spain Baleares     59627 827 1533 57267 39.710358 2.995148 2021-05-08 04:21:04 Baleares, Spain
928689 928689 2021-05-07 Spain C. Valenciana     391613 7329 9970 374314 39.484 -0.7533 2021-05-08 04:21:04 C. Valenciana, Spain
928690 928690 2021-05-07 Spain Canarias     53609 742 1537 51330 28.2916 -16.6291 2021-05-08 04:21:04 Canarias, Spain
928691 928691 2021-05-07 Spain Cantabria     29352 558 2287 26507 43.1828 -3.9878 2021-05-08 04:21:04 Cantabria, Spain
928692 928692 2021-05-07 Spain Castilla - La Mancha     187594 5883 6392 175319 39.2796 -3.0977 2021-05-08 04:21:04 Castilla - La Mancha, Spain
928693 928693 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
928694 928694 2021-05-07 Spain Catalonia     592912 14319 26203 552390 41.5912 1.5209 2021-05-08 04:21:04 Catalonia, Spain
928695 928695 2021-05-07 Spain Ceuta     5770 109 163 5498 35.8894 -5.3213 2021-05-08 04:21:04 Ceuta, Spain
928696 928696 2021-05-07 Spain Extremadura     74442 1794 2652 69996 39.4937 -6.0679 2021-05-08 04:21:04 Extremadura, Spain
928697 928697 2021-05-07 Spain Galicia     123274 2380 9204 111690 42.5751 -8.1339 2021-05-08 04:21:04 Galicia, Spain
928698 928698 2021-05-07 Spain La Rioja     30005 762 3107 26136 42.2871 -2.5396 2021-05-08 04:21:04 La Rioja, Spain
928699 928699 2021-05-07 Spain Madrid     692750 15087 40736 636927 40.4168 -3.7038 2021-05-08 04:21:04 Madrid, Spain
928700 928700 2021-05-07 Spain Melilla     8826 94 125 8607 35.2923 -2.9381 2021-05-08 04:21:04 Melilla, Spain
928701 928701 2021-05-07 Spain Murcia     111248 1590 2180 107478 37.9922 -1.1307 2021-05-08 04:21:04 Murcia, Spain
928702 928702 2021-05-07 Spain Navarra     60753 1164 3905 55684 42.6954 -1.6761 2021-05-08 04:21:04 Navarra, Spain
928703 928703 2021-05-07 Spain Pais Vasco     190197 4274 16160 169763 42.9896 -2.6189 2021-05-08 04:21:04 Pais Vasco, Spain
928704 928704 2021-05-07 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
622755 622755 2021-05-06 Spain Andalusia     557408 9689 10671 537048 37.5443 -4.7278 2021-05-07 04:20:40 Andalusia, Spain
622756 622756 2021-05-06 Spain Aragon     120025 3454 3772 112799 41.5976 -0.9057 2021-05-07 04:20:40 Aragon, Spain
622757 622757 2021-05-06 Spain Asturias     51096 1946 1063 48087 43.3614 -5.8593 2021-05-07 04:20:40 Asturias, Spain
622758 622758 2021-05-06 Spain Baleares     59557 825 1533 57199 39.710358 2.995148 2021-05-07 04:20:40 Baleares, Spain
622759 622759 2021-05-06 Spain C. Valenciana     391438 7323 9970 374145 39.484 -0.7533 2021-05-07 04:20:40 C. Valenciana, Spain
622760 622760 2021-05-06 Spain Canarias     53486 739 1537 51210 28.2916 -16.6291 2021-05-07 04:20:40 Canarias, Spain
622761 622761 2021-05-06 Spain Cantabria     29281 558 2287 26436 43.1828 -3.9878 2021-05-07 04:20:40 Cantabria, Spain
622762 622762 2021-05-06 Spain Castilla - La Mancha     187198 5883 6392 174923 39.2796 -3.0977 2021-05-07 04:20:40 Castilla - La Mancha, Spain
622763 622763 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
622764 622764 2021-05-06 Spain Catalonia     591034 14292 26203 550539 41.5912 1.5209 2021-05-07 04:20:40 Catalonia, Spain
622765 622765 2021-05-06 Spain Ceuta     5769 109 163 5497 35.8894 -5.3213 2021-05-07 04:20:40 Ceuta, Spain
622766 622766 2021-05-06 Spain Extremadura     74379 1794 2652 69933 39.4937 -6.0679 2021-05-07 04:20:40 Extremadura, Spain
622767 622767 2021-05-06 Spain Galicia     123042 2379 9204 111459 42.5751 -8.1339 2021-05-07 04:20:40 Galicia, Spain
622768 622768 2021-05-06 Spain La Rioja     29958 761 3107 26090 42.2871 -2.5396 2021-05-07 04:20:40 La Rioja, Spain
622769 622769 2021-05-06 Spain Madrid     690695 15075 40736 634884 40.4168 -3.7038 2021-05-07 04:20:40 Madrid, Spain
622770 622770 2021-05-06 Spain Melilla     8787 93 125 8569 35.2923 -2.9381 2021-05-07 04:20:40 Melilla, Spain
622771 622771 2021-05-06 Spain Murcia     111152 1590 2180 107382 37.9922 -1.1307 2021-05-07 04:20:40 Murcia, Spain
622772 622772 2021-05-06 Spain Navarra     60625 1165 3905 55555 42.6954 -1.6761 2021-05-07 04:20:40 Navarra, Spain
622773 622773 2021-05-06 Spain Pais Vasco     189580 4273 16160 169147 42.9896 -2.6189 2021-05-07 04:20:40 Pais Vasco, Spain
622774 622774 2021-05-06 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
453268 453268 2021-05-05 Spain Andalusia     556194 9681 10671 535842 37.5443 -4.7278 2021-05-06 04:20:38 Andalusia, Spain
453269 453269 2021-05-05 Spain Aragon     119698 3454 3772 112472 41.5976 -0.9057 2021-05-06 04:20:38 Aragon, Spain
453270 453270 2021-05-05 Spain Asturias     51047 1946 1063 48038 43.3614 -5.8593 2021-05-06 04:20:38 Asturias, Spain
453271 453271 2021-05-05 Spain Baleares     59515 824 1533 57158 39.710358 2.995148 2021-05-06 04:20:38 Baleares, Spain
453272 453272 2021-05-05 Spain C. Valenciana     391270 7322 9970 373978 39.484 -0.7533 2021-05-06 04:20:38 C. Valenciana, Spain
453273 453273 2021-05-05 Spain Canarias     53332 735 1537 51060 28.2916 -16.6291 2021-05-06 04:20:38 Canarias, Spain
453274 453274 2021-05-05 Spain Cantabria     29212 558 2287 26367 43.1828 -3.9878 2021-05-06 04:20:38 Cantabria, Spain
453275 453275 2021-05-05 Spain Castilla - La Mancha     186828 5880 6392 174556 39.2796 -3.0977 2021-05-06 04:20:38 Castilla - La Mancha, Spain
453276 453276 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
453277 453277 2021-05-05 Spain Catalonia     589156 14271 26203 548682 41.5912 1.5209 2021-05-06 04:20:38 Catalonia, Spain
453278 453278 2021-05-05 Spain Ceuta     5768 108 163 5497 35.8894 -5.3213 2021-05-06 04:20:38 Ceuta, Spain
453279 453279 2021-05-05 Spain Extremadura     74321 1793 2652 69876 39.4937 -6.0679 2021-05-06 04:20:38 Extremadura, Spain
453280 453280 2021-05-05 Spain Galicia     122812 2378 9204 111230 42.5751 -8.1339 2021-05-06 04:20:38 Galicia, Spain
453281 453281 2021-05-05 Spain La Rioja     29912 761 3107 26044 42.2871 -2.5396 2021-05-06 04:20:38 La Rioja, Spain
453282 453282 2021-05-05 Spain Madrid     688562 15041 40736 632785 40.4168 -3.7038 2021-05-06 04:20:38 Madrid, Spain
453283 453283 2021-05-05 Spain Melilla     8772 92 125 8555 35.2923 -2.9381 2021-05-06 04:20:38 Melilla, Spain
453284 453284 2021-05-05 Spain Murcia     111090 1590 2180 107320 37.9922 -1.1307 2021-05-06 04:20:38 Murcia, Spain
453285 453285 2021-05-05 Spain Navarra     60487 1165 3905 55417 42.6954 -1.6761 2021-05-06 04:20:38 Navarra, Spain
453286 453286 2021-05-05 Spain Pais Vasco     188890 4191 16160 168539 42.9896 -2.6189 2021-05-06 04:20:38 Pais Vasco, Spain
453287 453287 2021-05-05 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
764972 764972 2021-05-04 Spain Andalusia     554961 9666 10671 534624 37.5443 -4.7278 2021-05-05 04:20:43 Andalusia, Spain
764973 764973 2021-05-04 Spain Aragon     119340 3446 3772 112122 41.5976 -0.9057 2021-05-05 04:20:43 Aragon, Spain
764974 764974 2021-05-04 Spain Asturias     50995 1945 1063 47987 43.3614 -5.8593 2021-05-05 04:20:43 Asturias, Spain
764975 764975 2021-05-04 Spain Baleares     59463 823 1533 57107 39.710358 2.995148 2021-05-05 04:20:43 Baleares, Spain
764976 764976 2021-05-04 Spain C. Valenciana     391121 7318 9970 373833 39.484 -0.7533 2021-05-05 04:20:43 C. Valenciana, Spain
764977 764977 2021-05-04 Spain Canarias     53169 732 1537 50900 28.2916 -16.6291 2021-05-05 04:20:43 Canarias, Spain
764978 764978 2021-05-04 Spain Cantabria     29142 557 2287 26298 43.1828 -3.9878 2021-05-05 04:20:43 Cantabria, Spain
764979 764979 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
764980 764980 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
764981 764981 2021-05-04 Spain Catalonia     587461 14191 26203 547067 41.5912 1.5209 2021-05-05 04:20:43 Catalonia, Spain
764982 764982 2021-05-04 Spain Ceuta     5766 107 163 5496 35.8894 -5.3213 2021-05-05 04:20:43 Ceuta, Spain
764983 764983 2021-05-04 Spain Extremadura     74254 1791 2652 69811 39.4937 -6.0679 2021-05-05 04:20:43 Extremadura, Spain
764984 764984 2021-05-04 Spain Galicia     122625 2378 9204 111043 42.5751 -8.1339 2021-05-05 04:20:43 Galicia, Spain
764985 764985 2021-05-04 Spain La Rioja     29826 760 3107 25959 42.2871 -2.5396 2021-05-05 04:20:43 La Rioja, Spain
764986 764986 2021-05-04 Spain Madrid     686681 15016 40736 630929 40.4168 -3.7038 2021-05-05 04:20:43 Madrid, Spain
764987 764987 2021-05-04 Spain Melilla     8753 90 125 8538 35.2923 -2.9381 2021-05-05 04:20:43 Melilla, Spain
764988 764988 2021-05-04 Spain Murcia     110994 1590 2180 107224 37.9922 -1.1307 2021-05-05 04:20:43 Murcia, Spain
764989 764989 2021-05-04 Spain Navarra     60376 1164 3905 55307 42.6954 -1.6761 2021-05-05 04:20:43 Navarra, Spain
764990 764990 2021-05-04 Spain Pais Vasco     188197 4189 16160 167848 42.9896 -2.6189 2021-05-05 04:20:43 Pais Vasco, Spain
764991 764991 2021-05-04 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] TEXT,
   [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]);