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

14,838 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)

province_or_state 20

country_or_region 1

  • Spain · 14,838 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1733757 1733757 2022-05-20 Spain Andalusia     1478534 13561 0   37.5443 -4.7278 2022-05-21 04:20:58 Andalusia, Spain
1733758 1733758 2022-05-20 Spain Aragon     424602 4748 0   41.5976 -0.9057 2022-05-21 04:20:58 Aragon, Spain
1733759 1733759 2022-05-20 Spain Asturias     229332 2796 0   43.3614 -5.8593 2022-05-21 04:20:58 Asturias, Spain
1733760 1733760 2022-05-20 Spain Baleares     286083 1373 0   39.710358 2.995148 2022-05-21 04:20:58 Baleares, Spain
1733761 1733761 2022-05-20 Spain C. Valenciana     1420911 9332 0   39.484 -0.7533 2022-05-21 04:20:58 C. Valenciana, Spain
1733762 1733762 2022-05-20 Spain Canarias     364996 1739 0   28.2916 -16.6291 2022-05-21 04:20:58 Canarias, Spain
1733763 1733763 2022-05-20 Spain Cantabria     140593 841 0   43.1828 -3.9878 2022-05-21 04:20:58 Cantabria, Spain
1733764 1733764 2022-05-20 Spain Castilla - La Mancha     520132 7271 0   39.2796 -3.0977 2022-05-21 04:20:58 Castilla - La Mancha, Spain
1733765 1733765 2022-05-20 Spain Castilla y Leon     740971 8595 0   41.8357 -4.3976 2022-05-21 04:20:58 Castilla y Leon, Spain
1733766 1733766 2022-05-20 Spain Catalonia     2441774 19128 0   41.5912 1.5209 2022-05-21 04:20:58 Catalonia, Spain
1733767 1733767 2022-05-20 Spain Ceuta     21544 152 0   35.8894 -5.3213 2022-05-21 04:20:58 Ceuta, Spain
1733768 1733768 2022-05-20 Spain Extremadura     270744 2360 0   39.4937 -6.0679 2022-05-21 04:20:58 Extremadura, Spain
1733769 1733769 2022-05-20 Spain Galicia     644998 3422 0   42.5751 -8.1339 2022-05-21 04:20:58 Galicia, Spain
1733770 1733770 2022-05-20 Spain La Rioja     98637 922 0   42.2871 -2.5396 2022-05-21 04:20:58 La Rioja, Spain
1733771 1733771 2022-05-20 Spain Madrid     1704832 18711 0   40.4168 -3.7038 2022-05-21 04:20:58 Madrid, Spain
1733772 1733772 2022-05-20 Spain Melilla     21537 154 0   35.2923 -2.9381 2022-05-21 04:20:58 Melilla, Spain
1733773 1733773 2022-05-20 Spain Murcia     424321 2299 0   37.9922 -1.1307 2022-05-21 04:20:58 Murcia, Spain
1733774 1733774 2022-05-20 Spain Navarra     239819 1561 0   42.6954 -1.6761 2022-05-21 04:20:58 Navarra, Spain
1733775 1733775 2022-05-20 Spain Pais Vasco     704874 6677 0   42.9896 -2.6189 2022-05-21 04:20:58 Pais Vasco, Spain
1733776 1733776 2022-05-20 Spain Unknown     0 0 0       2022-05-21 04:20:58 Unknown, Spain
2573175 2573175 2022-05-19 Spain Andalusia     1478534 13561 0   37.5443 -4.7278 2022-05-20 04:20:57 Andalusia, Spain
2573176 2573176 2022-05-19 Spain Aragon     424602 4748 0   41.5976 -0.9057 2022-05-20 04:20:57 Aragon, Spain
2573177 2573177 2022-05-19 Spain Asturias     229332 2796 0   43.3614 -5.8593 2022-05-20 04:20:57 Asturias, Spain
2573178 2573178 2022-05-19 Spain Baleares     286083 1373 0   39.710358 2.995148 2022-05-20 04:20:57 Baleares, Spain
2573179 2573179 2022-05-19 Spain C. Valenciana     1420911 9332 0   39.484 -0.7533 2022-05-20 04:20:57 C. Valenciana, Spain
2573180 2573180 2022-05-19 Spain Canarias     364996 1739 0   28.2916 -16.6291 2022-05-20 04:20:57 Canarias, Spain
2573181 2573181 2022-05-19 Spain Cantabria     140593 841 0   43.1828 -3.9878 2022-05-20 04:20:57 Cantabria, Spain
2573182 2573182 2022-05-19 Spain Castilla - La Mancha     520132 7271 0   39.2796 -3.0977 2022-05-20 04:20:57 Castilla - La Mancha, Spain
2573183 2573183 2022-05-19 Spain Castilla y Leon     740971 8595 0   41.8357 -4.3976 2022-05-20 04:20:57 Castilla y Leon, Spain
2573184 2573184 2022-05-19 Spain Catalonia     2441774 19128 0   41.5912 1.5209 2022-05-20 04:20:57 Catalonia, Spain
2573185 2573185 2022-05-19 Spain Ceuta     21544 152 0   35.8894 -5.3213 2022-05-20 04:20:57 Ceuta, Spain
2573186 2573186 2022-05-19 Spain Extremadura     270744 2360 0   39.4937 -6.0679 2022-05-20 04:20:57 Extremadura, Spain
2573187 2573187 2022-05-19 Spain Galicia     644998 3422 0   42.5751 -8.1339 2022-05-20 04:20:57 Galicia, Spain
2573188 2573188 2022-05-19 Spain La Rioja     98637 922 0   42.2871 -2.5396 2022-05-20 04:20:57 La Rioja, Spain
2573189 2573189 2022-05-19 Spain Madrid     1704832 18711 0   40.4168 -3.7038 2022-05-20 04:20:57 Madrid, Spain
2573190 2573190 2022-05-19 Spain Melilla     21537 154 0   35.2923 -2.9381 2022-05-20 04:20:57 Melilla, Spain
2573191 2573191 2022-05-19 Spain Murcia     424321 2299 0   37.9922 -1.1307 2022-05-20 04:20:57 Murcia, Spain
2573192 2573192 2022-05-19 Spain Navarra     239819 1561 0   42.6954 -1.6761 2022-05-20 04:20:57 Navarra, Spain
2573193 2573193 2022-05-19 Spain Pais Vasco     704874 6677 0   42.9896 -2.6189 2022-05-20 04:20:57 Pais Vasco, Spain
2573194 2573194 2022-05-19 Spain Unknown     0 0 0       2022-05-20 04:20:57 Unknown, Spain
1432561 1432561 2022-05-18 Spain Andalusia     1478534 13561 0   37.5443 -4.7278 2022-05-19 04:20:54 Andalusia, Spain
1432562 1432562 2022-05-18 Spain Aragon     424602 4748 0   41.5976 -0.9057 2022-05-19 04:20:54 Aragon, Spain
1432563 1432563 2022-05-18 Spain Asturias     229332 2796 0   43.3614 -5.8593 2022-05-19 04:20:54 Asturias, Spain
1432564 1432564 2022-05-18 Spain Baleares     286083 1373 0   39.710358 2.995148 2022-05-19 04:20:54 Baleares, Spain
1432565 1432565 2022-05-18 Spain C. Valenciana     1420911 9332 0   39.484 -0.7533 2022-05-19 04:20:54 C. Valenciana, Spain
1432566 1432566 2022-05-18 Spain Canarias     364996 1739 0   28.2916 -16.6291 2022-05-19 04:20:54 Canarias, Spain
1432567 1432567 2022-05-18 Spain Cantabria     140593 841 0   43.1828 -3.9878 2022-05-19 04:20:54 Cantabria, Spain
1432568 1432568 2022-05-18 Spain Castilla - La Mancha     520132 7271 0   39.2796 -3.0977 2022-05-19 04:20:54 Castilla - La Mancha, Spain
1432569 1432569 2022-05-18 Spain Castilla y Leon     740971 8595 0   41.8357 -4.3976 2022-05-19 04:20:54 Castilla y Leon, Spain
1432570 1432570 2022-05-18 Spain Catalonia     2441774 19128 0   41.5912 1.5209 2022-05-19 04:20:54 Catalonia, Spain
1432571 1432571 2022-05-18 Spain Ceuta     21544 152 0   35.8894 -5.3213 2022-05-19 04:20:54 Ceuta, Spain
1432572 1432572 2022-05-18 Spain Extremadura     270744 2360 0   39.4937 -6.0679 2022-05-19 04:20:54 Extremadura, Spain
1432573 1432573 2022-05-18 Spain Galicia     644998 3422 0   42.5751 -8.1339 2022-05-19 04:20:54 Galicia, Spain
1432574 1432574 2022-05-18 Spain La Rioja     98637 922 0   42.2871 -2.5396 2022-05-19 04:20:54 La Rioja, Spain
1432575 1432575 2022-05-18 Spain Madrid     1704832 18711 0   40.4168 -3.7038 2022-05-19 04:20:54 Madrid, Spain
1432576 1432576 2022-05-18 Spain Melilla     21537 154 0   35.2923 -2.9381 2022-05-19 04:20:54 Melilla, Spain
1432577 1432577 2022-05-18 Spain Murcia     424321 2299 0   37.9922 -1.1307 2022-05-19 04:20:54 Murcia, Spain
1432578 1432578 2022-05-18 Spain Navarra     239819 1561 0   42.6954 -1.6761 2022-05-19 04:20:54 Navarra, Spain
1432579 1432579 2022-05-18 Spain Pais Vasco     704874 6677 0   42.9896 -2.6189 2022-05-19 04:20:54 Pais Vasco, Spain
1432580 1432580 2022-05-18 Spain Unknown     0 0 0       2022-05-19 04:20:54 Unknown, Spain
1599837 1599837 2022-05-17 Spain Andalusia     1478534 13561 0   37.5443 -4.7278 2022-05-18 04:20:50 Andalusia, Spain
1599838 1599838 2022-05-17 Spain Aragon     424602 4748 0   41.5976 -0.9057 2022-05-18 04:20:50 Aragon, Spain
1599839 1599839 2022-05-17 Spain Asturias     229332 2796 0   43.3614 -5.8593 2022-05-18 04:20:50 Asturias, Spain
1599840 1599840 2022-05-17 Spain Baleares     286083 1373 0   39.710358 2.995148 2022-05-18 04:20:50 Baleares, Spain
1599841 1599841 2022-05-17 Spain C. Valenciana     1420911 9332 0   39.484 -0.7533 2022-05-18 04:20:50 C. Valenciana, Spain
1599842 1599842 2022-05-17 Spain Canarias     364996 1739 0   28.2916 -16.6291 2022-05-18 04:20:50 Canarias, Spain
1599843 1599843 2022-05-17 Spain Cantabria     140593 841 0   43.1828 -3.9878 2022-05-18 04:20:50 Cantabria, Spain
1599844 1599844 2022-05-17 Spain Castilla - La Mancha     520132 7271 0   39.2796 -3.0977 2022-05-18 04:20:50 Castilla - La Mancha, Spain
1599845 1599845 2022-05-17 Spain Castilla y Leon     740971 8595 0   41.8357 -4.3976 2022-05-18 04:20:50 Castilla y Leon, Spain
1599846 1599846 2022-05-17 Spain Catalonia     2441774 19128 0   41.5912 1.5209 2022-05-18 04:20:50 Catalonia, Spain
1599847 1599847 2022-05-17 Spain Ceuta     21544 152 0   35.8894 -5.3213 2022-05-18 04:20:50 Ceuta, Spain
1599848 1599848 2022-05-17 Spain Extremadura     270744 2360 0   39.4937 -6.0679 2022-05-18 04:20:50 Extremadura, Spain
1599849 1599849 2022-05-17 Spain Galicia     644998 3422 0   42.5751 -8.1339 2022-05-18 04:20:50 Galicia, Spain
1599850 1599850 2022-05-17 Spain La Rioja     98637 922 0   42.2871 -2.5396 2022-05-18 04:20:50 La Rioja, Spain
1599851 1599851 2022-05-17 Spain Madrid     1704832 18711 0   40.4168 -3.7038 2022-05-18 04:20:50 Madrid, Spain
1599852 1599852 2022-05-17 Spain Melilla     21537 154 0   35.2923 -2.9381 2022-05-18 04:20:50 Melilla, Spain
1599853 1599853 2022-05-17 Spain Murcia     424321 2299 0   37.9922 -1.1307 2022-05-18 04:20:50 Murcia, Spain
1599854 1599854 2022-05-17 Spain Navarra     239819 1561 0   42.6954 -1.6761 2022-05-18 04:20:50 Navarra, Spain
1599855 1599855 2022-05-17 Spain Pais Vasco     704874 6677 0   42.9896 -2.6189 2022-05-18 04:20:50 Pais Vasco, Spain
1599856 1599856 2022-05-17 Spain Unknown     0 0 0       2022-05-18 04:20:50 Unknown, Spain
2425955 2425955 2022-05-16 Spain Andalusia     1472865 13542 0   37.5443 -4.7278 2022-05-17 04:20:59 Andalusia, Spain
2425956 2425956 2022-05-16 Spain Aragon     423226 4738 0   41.5976 -0.9057 2022-05-17 04:20:59 Aragon, Spain
2425957 2425957 2022-05-16 Spain Asturias     227953 2781 0   43.3614 -5.8593 2022-05-17 04:20:59 Asturias, Spain
2425958 2425958 2022-05-16 Spain Baleares     285291 1365 0   39.710358 2.995148 2022-05-17 04:20:59 Baleares, Spain
2425959 2425959 2022-05-16 Spain C. Valenciana     1414800 9317 0   39.484 -0.7533 2022-05-17 04:20:59 C. Valenciana, Spain
2425960 2425960 2022-05-16 Spain Canarias     362636 1732 0   28.2916 -16.6291 2022-05-17 04:20:59 Canarias, Spain
2425961 2425961 2022-05-16 Spain Cantabria     139689 837 0   43.1828 -3.9878 2022-05-17 04:20:59 Cantabria, Spain
2425962 2425962 2022-05-16 Spain Castilla - La Mancha     516597 7254 0   39.2796 -3.0977 2022-05-17 04:20:59 Castilla - La Mancha, Spain
2425963 2425963 2022-05-16 Spain Castilla y Leon     737185 8577 0   41.8357 -4.3976 2022-05-17 04:20:59 Castilla y Leon, Spain
2425964 2425964 2022-05-16 Spain Catalonia     2434675 19114 0   41.5912 1.5209 2022-05-17 04:20:59 Catalonia, Spain
2425965 2425965 2022-05-16 Spain Ceuta     21325 151 0   35.8894 -5.3213 2022-05-17 04:20:59 Ceuta, Spain
2425966 2425966 2022-05-16 Spain Extremadura     269218 2351 0   39.4937 -6.0679 2022-05-17 04:20:59 Extremadura, Spain
2425967 2425967 2022-05-16 Spain Galicia     640908 3396 0   42.5751 -8.1339 2022-05-17 04:20:59 Galicia, Spain
2425968 2425968 2022-05-16 Spain La Rioja     98175 922 0   42.2871 -2.5396 2022-05-17 04:20:59 La Rioja, Spain
2425969 2425969 2022-05-16 Spain Madrid     1697899 18701 0   40.4168 -3.7038 2022-05-17 04:20:59 Madrid, Spain
2425970 2425970 2022-05-16 Spain Melilla     21453 154 0   35.2923 -2.9381 2022-05-17 04:20:59 Melilla, Spain
2425971 2425971 2022-05-16 Spain Murcia     422381 2279 0   37.9922 -1.1307 2022-05-17 04:20:59 Murcia, Spain
2425972 2425972 2022-05-16 Spain Navarra     239219 1554 0   42.6954 -1.6761 2022-05-17 04:20:59 Navarra, Spain
2425973 2425973 2022-05-16 Spain Pais Vasco     701627 6679 0   42.9896 -2.6189 2022-05-17 04:20:59 Pais Vasco, Spain
2425974 2425974 2022-05-16 Spain Unknown     0 0 0       2022-05-17 04:20:59 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]);