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

19,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: combined_key, day (date)

province_or_state 20

country_or_region 1

  • Spain · 19,298 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2753194 2753194 2022-12-29 Spain Andalusia     1613017 14940 0   37.5443 -4.7278 2022-12-30 04:21:04 Andalusia, Spain
2753195 2753195 2022-12-29 Spain Aragon     463877 5401 0   41.5976 -0.9057 2022-12-30 04:21:04 Aragon, Spain
2753196 2753196 2022-12-29 Spain Asturias     263985 3379 0   43.3614 -5.8593 2022-12-30 04:21:04 Asturias, Spain
2753197 2753197 2022-12-29 Spain Baleares     313228 1607 0   39.710358 2.995148 2022-12-30 04:21:04 Baleares, Spain
2753198 2753198 2022-12-29 Spain C. Valenciana     1577590 10218 0   39.484 -0.7533 2022-12-30 04:21:04 C. Valenciana, Spain
2753199 2753199 2022-12-29 Spain Canarias     457923 2160 0   28.2916 -16.6291 2022-12-30 04:21:04 Canarias, Spain
2753200 2753200 2022-12-29 Spain Cantabria     162065 977 0   43.1828 -3.9878 2022-12-30 04:21:04 Cantabria, Spain
2753201 2753201 2022-12-29 Spain Castilla - La Mancha     606368 8023 0   39.2796 -3.0977 2022-12-30 04:21:04 Castilla - La Mancha, Spain
2753202 2753202 2022-12-29 Spain Castilla y Leon     841300 9301 0   41.8357 -4.3976 2022-12-30 04:21:04 Castilla y Leon, Spain
2753203 2753203 2022-12-29 Spain Catalonia     2673415 20868 0   41.5912 1.5209 2022-12-30 04:21:04 Catalonia, Spain
2753204 2753204 2022-12-29 Spain Ceuta     24553 192 0   35.8894 -5.3213 2022-12-30 04:21:04 Ceuta, Spain
2753205 2753205 2022-12-29 Spain Extremadura     307939 2671 0   39.4937 -6.0679 2022-12-30 04:21:04 Extremadura, Spain
2753206 2753206 2022-12-29 Spain Galicia     744496 3992 0   42.5751 -8.1339 2022-12-30 04:21:04 Galicia, Spain
2753207 2753207 2022-12-29 Spain La Rioja     110731 959 0   42.2871 -2.5396 2022-12-30 04:21:04 La Rioja, Spain
2753208 2753208 2022-12-29 Spain Madrid     1972473 20223 0   40.4168 -3.7038 2022-12-30 04:21:04 Madrid, Spain
2753209 2753209 2022-12-29 Spain Melilla     25166 169 0   35.2923 -2.9381 2022-12-30 04:21:04 Melilla, Spain
2753210 2753210 2022-12-29 Spain Murcia     463033 2504 0   37.9922 -1.1307 2022-12-30 04:21:04 Murcia, Spain
2753211 2753211 2022-12-29 Spain Navarra     257097 1739 0   42.6954 -1.6761 2022-12-30 04:21:04 Navarra, Spain
2753212 2753212 2022-12-29 Spain Pais Vasco     791781 7576 0   42.9896 -2.6189 2022-12-30 04:21:04 Pais Vasco, Spain
2753213 2753213 2022-12-29 Spain Unknown     0 0 0       2022-12-30 04:21:04 Unknown, Spain
1074200 1074200 2022-12-28 Spain Andalusia     1613017 14940 0   37.5443 -4.7278 2022-12-29 04:21:01 Andalusia, Spain
1074201 1074201 2022-12-28 Spain Aragon     463877 5401 0   41.5976 -0.9057 2022-12-29 04:21:01 Aragon, Spain
1074202 1074202 2022-12-28 Spain Asturias     263985 3379 0   43.3614 -5.8593 2022-12-29 04:21:01 Asturias, Spain
1074203 1074203 2022-12-28 Spain Baleares     313228 1607 0   39.710358 2.995148 2022-12-29 04:21:01 Baleares, Spain
1074204 1074204 2022-12-28 Spain C. Valenciana     1577590 10218 0   39.484 -0.7533 2022-12-29 04:21:01 C. Valenciana, Spain
1074205 1074205 2022-12-28 Spain Canarias     457923 2160 0   28.2916 -16.6291 2022-12-29 04:21:01 Canarias, Spain
1074206 1074206 2022-12-28 Spain Cantabria     162065 977 0   43.1828 -3.9878 2022-12-29 04:21:01 Cantabria, Spain
1074207 1074207 2022-12-28 Spain Castilla - La Mancha     606368 8023 0   39.2796 -3.0977 2022-12-29 04:21:01 Castilla - La Mancha, Spain
1074208 1074208 2022-12-28 Spain Castilla y Leon     841300 9301 0   41.8357 -4.3976 2022-12-29 04:21:01 Castilla y Leon, Spain
1074209 1074209 2022-12-28 Spain Catalonia     2673415 20868 0   41.5912 1.5209 2022-12-29 04:21:01 Catalonia, Spain
1074210 1074210 2022-12-28 Spain Ceuta     24553 192 0   35.8894 -5.3213 2022-12-29 04:21:01 Ceuta, Spain
1074211 1074211 2022-12-28 Spain Extremadura     307939 2671 0   39.4937 -6.0679 2022-12-29 04:21:01 Extremadura, Spain
1074212 1074212 2022-12-28 Spain Galicia     744496 3992 0   42.5751 -8.1339 2022-12-29 04:21:01 Galicia, Spain
1074213 1074213 2022-12-28 Spain La Rioja     110731 959 0   42.2871 -2.5396 2022-12-29 04:21:01 La Rioja, Spain
1074214 1074214 2022-12-28 Spain Madrid     1972473 20223 0   40.4168 -3.7038 2022-12-29 04:21:01 Madrid, Spain
1074215 1074215 2022-12-28 Spain Melilla     25166 169 0   35.2923 -2.9381 2022-12-29 04:21:01 Melilla, Spain
1074216 1074216 2022-12-28 Spain Murcia     463033 2504 0   37.9922 -1.1307 2022-12-29 04:21:01 Murcia, Spain
1074217 1074217 2022-12-28 Spain Navarra     257097 1739 0   42.6954 -1.6761 2022-12-29 04:21:01 Navarra, Spain
1074218 1074218 2022-12-28 Spain Pais Vasco     791781 7576 0   42.9896 -2.6189 2022-12-29 04:21:01 Pais Vasco, Spain
1074219 1074219 2022-12-28 Spain Unknown     0 0 0       2022-12-29 04:21:01 Unknown, Spain
328197 328197 2022-12-27 Spain Andalusia     1613017 14940 0   37.5443 -4.7278 2022-12-28 04:21:04 Andalusia, Spain
328198 328198 2022-12-27 Spain Aragon     463877 5401 0   41.5976 -0.9057 2022-12-28 04:21:04 Aragon, Spain
328199 328199 2022-12-27 Spain Asturias     263985 3379 0   43.3614 -5.8593 2022-12-28 04:21:04 Asturias, Spain
328200 328200 2022-12-27 Spain Baleares     313228 1607 0   39.710358 2.995148 2022-12-28 04:21:04 Baleares, Spain
328201 328201 2022-12-27 Spain C. Valenciana     1577590 10218 0   39.484 -0.7533 2022-12-28 04:21:04 C. Valenciana, Spain
328202 328202 2022-12-27 Spain Canarias     457923 2160 0   28.2916 -16.6291 2022-12-28 04:21:04 Canarias, Spain
328203 328203 2022-12-27 Spain Cantabria     162065 977 0   43.1828 -3.9878 2022-12-28 04:21:04 Cantabria, Spain
328204 328204 2022-12-27 Spain Castilla - La Mancha     606368 8023 0   39.2796 -3.0977 2022-12-28 04:21:04 Castilla - La Mancha, Spain
328205 328205 2022-12-27 Spain Castilla y Leon     841300 9301 0   41.8357 -4.3976 2022-12-28 04:21:04 Castilla y Leon, Spain
328206 328206 2022-12-27 Spain Catalonia     2673415 20868 0   41.5912 1.5209 2022-12-28 04:21:04 Catalonia, Spain
328207 328207 2022-12-27 Spain Ceuta     24553 192 0   35.8894 -5.3213 2022-12-28 04:21:04 Ceuta, Spain
328208 328208 2022-12-27 Spain Extremadura     307939 2671 0   39.4937 -6.0679 2022-12-28 04:21:04 Extremadura, Spain
328209 328209 2022-12-27 Spain Galicia     744496 3992 0   42.5751 -8.1339 2022-12-28 04:21:04 Galicia, Spain
328210 328210 2022-12-27 Spain La Rioja     110731 959 0   42.2871 -2.5396 2022-12-28 04:21:04 La Rioja, Spain
328211 328211 2022-12-27 Spain Madrid     1972473 20223 0   40.4168 -3.7038 2022-12-28 04:21:04 Madrid, Spain
328212 328212 2022-12-27 Spain Melilla     25166 169 0   35.2923 -2.9381 2022-12-28 04:21:04 Melilla, Spain
328213 328213 2022-12-27 Spain Murcia     463033 2504 0   37.9922 -1.1307 2022-12-28 04:21:04 Murcia, Spain
328214 328214 2022-12-27 Spain Navarra     257097 1739 0   42.6954 -1.6761 2022-12-28 04:21:04 Navarra, Spain
328215 328215 2022-12-27 Spain Pais Vasco     791781 7576 0   42.9896 -2.6189 2022-12-28 04:21:04 Pais Vasco, Spain
328216 328216 2022-12-27 Spain Unknown     0 0 0       2022-12-28 04:21:04 Unknown, Spain
218270 218270 2022-12-26 Spain Andalusia     1613017 14940 0   37.5443 -4.7278 2022-12-27 04:21:07 Andalusia, Spain
218271 218271 2022-12-26 Spain Aragon     463877 5401 0   41.5976 -0.9057 2022-12-27 04:21:07 Aragon, Spain
218272 218272 2022-12-26 Spain Asturias     263985 3379 0   43.3614 -5.8593 2022-12-27 04:21:07 Asturias, Spain
218273 218273 2022-12-26 Spain Baleares     313228 1607 0   39.710358 2.995148 2022-12-27 04:21:07 Baleares, Spain
218274 218274 2022-12-26 Spain C. Valenciana     1577590 10218 0   39.484 -0.7533 2022-12-27 04:21:07 C. Valenciana, Spain
218275 218275 2022-12-26 Spain Canarias     457923 2160 0   28.2916 -16.6291 2022-12-27 04:21:07 Canarias, Spain
218276 218276 2022-12-26 Spain Cantabria     162065 977 0   43.1828 -3.9878 2022-12-27 04:21:07 Cantabria, Spain
218277 218277 2022-12-26 Spain Castilla - La Mancha     606368 8023 0   39.2796 -3.0977 2022-12-27 04:21:07 Castilla - La Mancha, Spain
218278 218278 2022-12-26 Spain Castilla y Leon     841300 9301 0   41.8357 -4.3976 2022-12-27 04:21:07 Castilla y Leon, Spain
218279 218279 2022-12-26 Spain Catalonia     2673415 20868 0   41.5912 1.5209 2022-12-27 04:21:07 Catalonia, Spain
218280 218280 2022-12-26 Spain Ceuta     24553 192 0   35.8894 -5.3213 2022-12-27 04:21:07 Ceuta, Spain
218281 218281 2022-12-26 Spain Extremadura     307939 2671 0   39.4937 -6.0679 2022-12-27 04:21:07 Extremadura, Spain
218282 218282 2022-12-26 Spain Galicia     744496 3992 0   42.5751 -8.1339 2022-12-27 04:21:07 Galicia, Spain
218283 218283 2022-12-26 Spain La Rioja     110731 959 0   42.2871 -2.5396 2022-12-27 04:21:07 La Rioja, Spain
218284 218284 2022-12-26 Spain Madrid     1972473 20223 0   40.4168 -3.7038 2022-12-27 04:21:07 Madrid, Spain
218285 218285 2022-12-26 Spain Melilla     25166 169 0   35.2923 -2.9381 2022-12-27 04:21:07 Melilla, Spain
218286 218286 2022-12-26 Spain Murcia     463033 2504 0   37.9922 -1.1307 2022-12-27 04:21:07 Murcia, Spain
218287 218287 2022-12-26 Spain Navarra     257097 1739 0   42.6954 -1.6761 2022-12-27 04:21:07 Navarra, Spain
218288 218288 2022-12-26 Spain Pais Vasco     791781 7576 0   42.9896 -2.6189 2022-12-27 04:21:07 Pais Vasco, Spain
218289 218289 2022-12-26 Spain Unknown     0 0 0       2022-12-27 04:21:07 Unknown, Spain
3222727 3222727 2022-12-25 Spain Andalusia     1613017 14940 0   37.5443 -4.7278 2022-12-26 04:21:06 Andalusia, Spain
3222728 3222728 2022-12-25 Spain Aragon     463877 5401 0   41.5976 -0.9057 2022-12-26 04:21:06 Aragon, Spain
3222729 3222729 2022-12-25 Spain Asturias     263985 3379 0   43.3614 -5.8593 2022-12-26 04:21:06 Asturias, Spain
3222730 3222730 2022-12-25 Spain Baleares     313228 1607 0   39.710358 2.995148 2022-12-26 04:21:06 Baleares, Spain
3222731 3222731 2022-12-25 Spain C. Valenciana     1577590 10218 0   39.484 -0.7533 2022-12-26 04:21:06 C. Valenciana, Spain
3222732 3222732 2022-12-25 Spain Canarias     457923 2160 0   28.2916 -16.6291 2022-12-26 04:21:06 Canarias, Spain
3222733 3222733 2022-12-25 Spain Cantabria     162065 977 0   43.1828 -3.9878 2022-12-26 04:21:06 Cantabria, Spain
3222734 3222734 2022-12-25 Spain Castilla - La Mancha     606368 8023 0   39.2796 -3.0977 2022-12-26 04:21:06 Castilla - La Mancha, Spain
3222735 3222735 2022-12-25 Spain Castilla y Leon     841300 9301 0   41.8357 -4.3976 2022-12-26 04:21:06 Castilla y Leon, Spain
3222736 3222736 2022-12-25 Spain Catalonia     2673415 20868 0   41.5912 1.5209 2022-12-26 04:21:06 Catalonia, Spain
3222737 3222737 2022-12-25 Spain Ceuta     24553 192 0   35.8894 -5.3213 2022-12-26 04:21:06 Ceuta, Spain
3222738 3222738 2022-12-25 Spain Extremadura     307939 2671 0   39.4937 -6.0679 2022-12-26 04:21:06 Extremadura, Spain
3222739 3222739 2022-12-25 Spain Galicia     744496 3992 0   42.5751 -8.1339 2022-12-26 04:21:06 Galicia, Spain
3222740 3222740 2022-12-25 Spain La Rioja     110731 959 0   42.2871 -2.5396 2022-12-26 04:21:06 La Rioja, Spain
3222741 3222741 2022-12-25 Spain Madrid     1972473 20223 0   40.4168 -3.7038 2022-12-26 04:21:06 Madrid, Spain
3222742 3222742 2022-12-25 Spain Melilla     25166 169 0   35.2923 -2.9381 2022-12-26 04:21:06 Melilla, Spain
3222743 3222743 2022-12-25 Spain Murcia     463033 2504 0   37.9922 -1.1307 2022-12-26 04:21:06 Murcia, Spain
3222744 3222744 2022-12-25 Spain Navarra     257097 1739 0   42.6954 -1.6761 2022-12-26 04:21:06 Navarra, Spain
3222745 3222745 2022-12-25 Spain Pais Vasco     791781 7576 0   42.9896 -2.6189 2022-12-26 04:21:06 Pais Vasco, Spain
3222746 3222746 2022-12-25 Spain Unknown     0 0 0       2022-12-26 04:21:06 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]);