johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,298 rows where country_or_region = "Spain" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 20
- Andalusia 152
- Aragon 152
- Asturias 152
- Baleares 152
- C. Valenciana 152
- Canarias 152
- Cantabria 152
- Castilla - La Mancha 152
- Castilla y Leon 152
- Catalonia 152
- Ceuta 152
- Extremadura 152
- Galicia 152
- La Rioja 152
- Madrid 152
- Melilla 152
- Murcia 152
- Navarra 152
- Pais Vasco 152
- Unknown 147
country_or_region 1
- Spain · 3,138 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2291723 | 2291723 | 2020-10-12 | Spain | Andalusia | 79383 | 2020 | 10671 | 66692 | 37.5443 | -4.7278 | 2020-10-13 04:24:02 | Andalusia, Spain | ||
2291724 | 2291724 | 2020-10-12 | Spain | Aragon | 40672 | 1481 | 3772 | 35419 | 41.5976 | -0.9057 | 2020-10-13 04:24:02 | Aragon, Spain | ||
2291725 | 2291725 | 2020-10-12 | Spain | Asturias | 6986 | 356 | 1063 | 5567 | 43.3614 | -5.8593 | 2020-10-13 04:24:02 | Asturias, Spain | ||
2291726 | 2291726 | 2020-10-12 | Spain | Baleares | 15349 | 316 | 1533 | 13500 | 39.710358 | 2.995148 | 2020-10-13 04:24:02 | Baleares, Spain | ||
2291727 | 2291727 | 2020-10-12 | Spain | C. Valenciana | 45813 | 1645 | 9970 | 34198 | 39.484 | -0.7533 | 2020-10-13 04:24:02 | C. Valenciana, Spain | ||
2291728 | 2291728 | 2020-10-12 | Spain | Canarias | 15173 | 247 | 1537 | 13389 | 28.2916 | -16.6291 | 2020-10-13 04:24:02 | Canarias, Spain | ||
2291729 | 2291729 | 2020-10-12 | Spain | Cantabria | 7362 | 237 | 2287 | 4838 | 43.1828 | -3.9878 | 2020-10-13 04:24:02 | Cantabria, Spain | ||
2291730 | 2291730 | 2020-10-12 | Spain | Castilla - La Mancha | 49613 | 3266 | 6392 | 39955 | 39.2796 | -3.0977 | 2020-10-13 04:24:02 | Castilla - La Mancha, Spain | ||
2291731 | 2291731 | 2020-10-12 | Spain | Castilla y Leon | 57489 | 3232 | 8716 | 45541 | 41.8357 | -4.3976 | 2020-10-13 04:24:02 | Castilla y Leon, Spain | ||
2291732 | 2291732 | 2020-10-12 | Spain | Catalonia | 160551 | 5883 | 26203 | 128465 | 41.5912 | 1.5209 | 2020-10-13 04:24:02 | Catalonia, Spain | ||
2291733 | 2291733 | 2020-10-12 | Spain | Ceuta | 847 | 12 | 163 | 672 | 35.8894 | -5.3213 | 2020-10-13 04:24:02 | Ceuta, Spain | ||
2291734 | 2291734 | 2020-10-12 | Spain | Extremadura | 12856 | 630 | 2652 | 9574 | 39.4937 | -6.0679 | 2020-10-13 04:24:02 | Extremadura, Spain | ||
2291735 | 2291735 | 2020-10-12 | Spain | Galicia | 24522 | 785 | 9204 | 14533 | 42.5751 | -8.1339 | 2020-10-13 04:24:02 | Galicia, Spain | ||
2291736 | 2291736 | 2020-10-12 | Spain | La Rioja | 9505 | 429 | 3107 | 5969 | 42.2871 | -2.5396 | 2020-10-13 04:24:02 | La Rioja, Spain | ||
2291737 | 2291737 | 2020-10-12 | Spain | Madrid | 266896 | 9786 | 40736 | 216374 | 40.4168 | -3.7038 | 2020-10-13 04:24:02 | Madrid, Spain | ||
2291738 | 2291738 | 2020-10-12 | Spain | Melilla | 1400 | 8 | 125 | 1267 | 35.2923 | -2.9381 | 2020-10-13 04:24:02 | Melilla, Spain | ||
2291739 | 2291739 | 2020-10-12 | Spain | Murcia | 23926 | 236 | 2180 | 21510 | 37.9922 | -1.1307 | 2020-10-13 04:24:02 | Murcia, Spain | ||
2291740 | 2291740 | 2020-10-12 | Spain | Navarra | 22474 | 618 | 3905 | 17951 | 42.6954 | -1.6761 | 2020-10-13 04:24:02 | Navarra, Spain | ||
2291741 | 2291741 | 2020-10-12 | Spain | Pais Vasco | 48151 | 1937 | 16160 | 30054 | 42.9896 | -2.6189 | 2020-10-13 04:24:02 | Pais Vasco, Spain | ||
2291742 | 2291742 | 2020-10-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-13 04:24:02 | Unknown, Spain | ||||
3786175 | 3786175 | 2020-10-11 | Spain | Andalusia | 74620 | 1979 | 10671 | 61970 | 37.5443 | -4.7278 | 2020-10-12 04:23:45 | Andalusia, Spain | ||
3786176 | 3786176 | 2020-10-11 | Spain | Aragon | 39267 | 1470 | 3772 | 34025 | 41.5976 | -0.9057 | 2020-10-12 04:23:45 | Aragon, Spain | ||
3786177 | 3786177 | 2020-10-11 | Spain | Asturias | 6353 | 354 | 1063 | 4936 | 43.3614 | -5.8593 | 2020-10-12 04:23:45 | Asturias, Spain | ||
3786178 | 3786178 | 2020-10-11 | Spain | Baleares | 14975 | 316 | 1533 | 13126 | 39.710358 | 2.995148 | 2020-10-12 04:23:45 | Baleares, Spain | ||
3786179 | 3786179 | 2020-10-11 | Spain | C. Valenciana | 45220 | 1644 | 9970 | 33606 | 39.484 | -0.7533 | 2020-10-12 04:23:45 | C. Valenciana, Spain | ||
3786180 | 3786180 | 2020-10-11 | Spain | Canarias | 14775 | 241 | 1537 | 12997 | 28.2916 | -16.6291 | 2020-10-12 04:23:45 | Canarias, Spain | ||
3786181 | 3786181 | 2020-10-11 | Spain | Cantabria | 7192 | 237 | 2287 | 4668 | 43.1828 | -3.9878 | 2020-10-12 04:23:45 | Cantabria, Spain | ||
3786182 | 3786182 | 2020-10-11 | Spain | Castilla - La Mancha | 48584 | 3254 | 6392 | 38938 | 39.2796 | -3.0977 | 2020-10-12 04:23:45 | Castilla - La Mancha, Spain | ||
3786183 | 3786183 | 2020-10-11 | Spain | Castilla y Leon | 54744 | 3199 | 8716 | 42829 | 41.8357 | -4.3976 | 2020-10-12 04:23:45 | Castilla y Leon, Spain | ||
3786184 | 3786184 | 2020-10-11 | Spain | Catalonia | 154354 | 5875 | 26203 | 122276 | 41.5912 | 1.5209 | 2020-10-12 04:23:45 | Catalonia, Spain | ||
3786185 | 3786185 | 2020-10-11 | Spain | Ceuta | 790 | 11 | 163 | 616 | 35.8894 | -5.3213 | 2020-10-12 04:23:45 | Ceuta, Spain | ||
3786186 | 3786186 | 2020-10-11 | Spain | Extremadura | 12269 | 622 | 2652 | 8995 | 39.4937 | -6.0679 | 2020-10-12 04:23:45 | Extremadura, Spain | ||
3786187 | 3786187 | 2020-10-11 | Spain | Galicia | 23523 | 777 | 9204 | 13542 | 42.5751 | -8.1339 | 2020-10-12 04:23:45 | Galicia, Spain | ||
3786188 | 3786188 | 2020-10-11 | Spain | La Rioja | 9299 | 426 | 3107 | 5766 | 42.2871 | -2.5396 | 2020-10-12 04:23:45 | La Rioja, Spain | ||
3786189 | 3786189 | 2020-10-11 | Spain | Madrid | 261762 | 9739 | 40736 | 211287 | 40.4168 | -3.7038 | 2020-10-12 04:23:45 | Madrid, Spain | ||
3786190 | 3786190 | 2020-10-11 | Spain | Melilla | 1273 | 6 | 125 | 1142 | 35.2923 | -2.9381 | 2020-10-12 04:23:45 | Melilla, Spain | ||
3786191 | 3786191 | 2020-10-11 | Spain | Murcia | 23013 | 231 | 2180 | 20602 | 37.9922 | -1.1307 | 2020-10-12 04:23:45 | Murcia, Spain | ||
3786192 | 3786192 | 2020-10-11 | Spain | Navarra | 21016 | 611 | 3905 | 16500 | 42.6954 | -1.6761 | 2020-10-12 04:23:45 | Navarra, Spain | ||
3786193 | 3786193 | 2020-10-11 | Spain | Pais Vasco | 48083 | 1937 | 16160 | 29986 | 42.9896 | -2.6189 | 2020-10-12 04:23:45 | Pais Vasco, Spain | ||
3786194 | 3786194 | 2020-10-11 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-12 04:23:45 | Unknown, Spain | ||||
2602313 | 2602313 | 2020-10-10 | Spain | Andalusia | 74620 | 1979 | 10671 | 61970 | 37.5443 | -4.7278 | 2020-10-11 04:23:46 | Andalusia, Spain | ||
2602314 | 2602314 | 2020-10-10 | Spain | Aragon | 39267 | 1470 | 3772 | 34025 | 41.5976 | -0.9057 | 2020-10-11 04:23:46 | Aragon, Spain | ||
2602315 | 2602315 | 2020-10-10 | Spain | Asturias | 6353 | 354 | 1063 | 4936 | 43.3614 | -5.8593 | 2020-10-11 04:23:46 | Asturias, Spain | ||
2602316 | 2602316 | 2020-10-10 | Spain | Baleares | 14975 | 316 | 1533 | 13126 | 39.710358 | 2.995148 | 2020-10-11 04:23:46 | Baleares, Spain | ||
2602317 | 2602317 | 2020-10-10 | Spain | C. Valenciana | 45220 | 1644 | 9970 | 33606 | 39.484 | -0.7533 | 2020-10-11 04:23:46 | C. Valenciana, Spain | ||
2602318 | 2602318 | 2020-10-10 | Spain | Canarias | 14775 | 241 | 1537 | 12997 | 28.2916 | -16.6291 | 2020-10-11 04:23:46 | Canarias, Spain | ||
2602319 | 2602319 | 2020-10-10 | Spain | Cantabria | 7192 | 237 | 2287 | 4668 | 43.1828 | -3.9878 | 2020-10-11 04:23:46 | Cantabria, Spain | ||
2602320 | 2602320 | 2020-10-10 | Spain | Castilla - La Mancha | 48584 | 3254 | 6392 | 38938 | 39.2796 | -3.0977 | 2020-10-11 04:23:46 | Castilla - La Mancha, Spain | ||
2602321 | 2602321 | 2020-10-10 | Spain | Castilla y Leon | 54744 | 3199 | 8716 | 42829 | 41.8357 | -4.3976 | 2020-10-11 04:23:46 | Castilla y Leon, Spain | ||
2602322 | 2602322 | 2020-10-10 | Spain | Catalonia | 154354 | 5875 | 26203 | 122276 | 41.5912 | 1.5209 | 2020-10-11 04:23:46 | Catalonia, Spain | ||
2602323 | 2602323 | 2020-10-10 | Spain | Ceuta | 790 | 11 | 163 | 616 | 35.8894 | -5.3213 | 2020-10-11 04:23:46 | Ceuta, Spain | ||
2602324 | 2602324 | 2020-10-10 | Spain | Extremadura | 12269 | 622 | 2652 | 8995 | 39.4937 | -6.0679 | 2020-10-11 04:23:46 | Extremadura, Spain | ||
2602325 | 2602325 | 2020-10-10 | Spain | Galicia | 23523 | 777 | 9204 | 13542 | 42.5751 | -8.1339 | 2020-10-11 04:23:46 | Galicia, Spain | ||
2602326 | 2602326 | 2020-10-10 | Spain | La Rioja | 9299 | 426 | 3107 | 5766 | 42.2871 | -2.5396 | 2020-10-11 04:23:46 | La Rioja, Spain | ||
2602327 | 2602327 | 2020-10-10 | Spain | Madrid | 261762 | 9739 | 40736 | 211287 | 40.4168 | -3.7038 | 2020-10-11 04:23:46 | Madrid, Spain | ||
2602328 | 2602328 | 2020-10-10 | Spain | Melilla | 1273 | 6 | 125 | 1142 | 35.2923 | -2.9381 | 2020-10-11 04:23:46 | Melilla, Spain | ||
2602329 | 2602329 | 2020-10-10 | Spain | Murcia | 23013 | 231 | 2180 | 20602 | 37.9922 | -1.1307 | 2020-10-11 04:23:46 | Murcia, Spain | ||
2602330 | 2602330 | 2020-10-10 | Spain | Navarra | 21016 | 611 | 3905 | 16500 | 42.6954 | -1.6761 | 2020-10-11 04:23:46 | Navarra, Spain | ||
2602331 | 2602331 | 2020-10-10 | Spain | Pais Vasco | 48083 | 1937 | 16160 | 29986 | 42.9896 | -2.6189 | 2020-10-11 04:23:46 | Pais Vasco, Spain | ||
2602332 | 2602332 | 2020-10-10 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-11 04:23:46 | Unknown, Spain | ||||
817846 | 817846 | 2020-10-09 | Spain | Andalusia | 74620 | 1979 | 10671 | 61970 | 37.5443 | -4.7278 | 2020-10-10 04:23:57 | Andalusia, Spain | ||
817847 | 817847 | 2020-10-09 | Spain | Aragon | 39267 | 1470 | 3772 | 34025 | 41.5976 | -0.9057 | 2020-10-10 04:23:57 | Aragon, Spain | ||
817848 | 817848 | 2020-10-09 | Spain | Asturias | 6353 | 354 | 1063 | 4936 | 43.3614 | -5.8593 | 2020-10-10 04:23:57 | Asturias, Spain | ||
817849 | 817849 | 2020-10-09 | Spain | Baleares | 14975 | 316 | 1533 | 13126 | 39.710358 | 2.995148 | 2020-10-10 04:23:57 | Baleares, Spain | ||
817850 | 817850 | 2020-10-09 | Spain | C. Valenciana | 45220 | 1644 | 9970 | 33606 | 39.484 | -0.7533 | 2020-10-10 04:23:57 | C. Valenciana, Spain | ||
817851 | 817851 | 2020-10-09 | Spain | Canarias | 14775 | 241 | 1537 | 12997 | 28.2916 | -16.6291 | 2020-10-10 04:23:57 | Canarias, Spain | ||
817852 | 817852 | 2020-10-09 | Spain | Cantabria | 7192 | 237 | 2287 | 4668 | 43.1828 | -3.9878 | 2020-10-10 04:23:57 | Cantabria, Spain | ||
817853 | 817853 | 2020-10-09 | Spain | Castilla - La Mancha | 48584 | 3254 | 6392 | 38938 | 39.2796 | -3.0977 | 2020-10-10 04:23:57 | Castilla - La Mancha, Spain | ||
817854 | 817854 | 2020-10-09 | Spain | Castilla y Leon | 54744 | 3199 | 8716 | 42829 | 41.8357 | -4.3976 | 2020-10-10 04:23:57 | Castilla y Leon, Spain | ||
817855 | 817855 | 2020-10-09 | Spain | Catalonia | 154354 | 5875 | 26203 | 122276 | 41.5912 | 1.5209 | 2020-10-10 04:23:57 | Catalonia, Spain | ||
817856 | 817856 | 2020-10-09 | Spain | Ceuta | 790 | 11 | 163 | 616 | 35.8894 | -5.3213 | 2020-10-10 04:23:57 | Ceuta, Spain | ||
817857 | 817857 | 2020-10-09 | Spain | Extremadura | 12269 | 622 | 2652 | 8995 | 39.4937 | -6.0679 | 2020-10-10 04:23:57 | Extremadura, Spain | ||
817858 | 817858 | 2020-10-09 | Spain | Galicia | 23523 | 777 | 9204 | 13542 | 42.5751 | -8.1339 | 2020-10-10 04:23:57 | Galicia, Spain | ||
817859 | 817859 | 2020-10-09 | Spain | La Rioja | 9299 | 426 | 3107 | 5766 | 42.2871 | -2.5396 | 2020-10-10 04:23:57 | La Rioja, Spain | ||
817860 | 817860 | 2020-10-09 | Spain | Madrid | 261762 | 9739 | 40736 | 211287 | 40.4168 | -3.7038 | 2020-10-10 04:23:57 | Madrid, Spain | ||
817861 | 817861 | 2020-10-09 | Spain | Melilla | 1273 | 6 | 125 | 1142 | 35.2923 | -2.9381 | 2020-10-10 04:23:57 | Melilla, Spain | ||
817862 | 817862 | 2020-10-09 | Spain | Murcia | 23013 | 231 | 2180 | 20602 | 37.9922 | -1.1307 | 2020-10-10 04:23:57 | Murcia, Spain | ||
817863 | 817863 | 2020-10-09 | Spain | Navarra | 21016 | 611 | 3905 | 16500 | 42.6954 | -1.6761 | 2020-10-10 04:23:57 | Navarra, Spain | ||
817864 | 817864 | 2020-10-09 | Spain | Pais Vasco | 48083 | 1937 | 16160 | 29986 | 42.9896 | -2.6189 | 2020-10-10 04:23:57 | Pais Vasco, Spain | ||
817865 | 817865 | 2020-10-09 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-10 04:23:57 | Unknown, Spain | ||||
2689961 | 2689961 | 2020-10-08 | Spain | Andalusia | 72556 | 1965 | 10671 | 59920 | 37.5443 | -4.7278 | 2020-10-09 04:23:59 | Andalusia, Spain | ||
2689962 | 2689962 | 2020-10-08 | Spain | Aragon | 38541 | 1412 | 3772 | 33357 | 41.5976 | -0.9057 | 2020-10-09 04:23:59 | Aragon, Spain | ||
2689963 | 2689963 | 2020-10-08 | Spain | Asturias | 6237 | 351 | 1063 | 4823 | 43.3614 | -5.8593 | 2020-10-09 04:23:59 | Asturias, Spain | ||
2689964 | 2689964 | 2020-10-08 | Spain | Baleares | 14859 | 313 | 1533 | 13013 | 39.710358 | 2.995148 | 2020-10-09 04:23:59 | Baleares, Spain | ||
2689965 | 2689965 | 2020-10-08 | Spain | C. Valenciana | 44644 | 1640 | 9970 | 33034 | 39.484 | -0.7533 | 2020-10-09 04:23:59 | C. Valenciana, Spain | ||
2689966 | 2689966 | 2020-10-08 | Spain | Canarias | 14588 | 240 | 1537 | 12811 | 28.2916 | -16.6291 | 2020-10-09 04:23:59 | Canarias, Spain | ||
2689967 | 2689967 | 2020-10-08 | Spain | Cantabria | 7161 | 237 | 2287 | 4637 | 43.1828 | -3.9878 | 2020-10-09 04:23:59 | Cantabria, Spain | ||
2689968 | 2689968 | 2020-10-08 | Spain | Castilla - La Mancha | 47968 | 3244 | 6392 | 38332 | 39.2796 | -3.0977 | 2020-10-09 04:23:59 | Castilla - La Mancha, Spain | ||
2689969 | 2689969 | 2020-10-08 | Spain | Castilla y Leon | 53735 | 3179 | 8716 | 41840 | 41.8357 | -4.3976 | 2020-10-09 04:23:59 | Castilla y Leon, Spain | ||
2689970 | 2689970 | 2020-10-08 | Spain | Catalonia | 152154 | 5865 | 26203 | 120086 | 41.5912 | 1.5209 | 2020-10-09 04:23:59 | Catalonia, Spain | ||
2689971 | 2689971 | 2020-10-08 | Spain | Ceuta | 750 | 11 | 163 | 576 | 35.8894 | -5.3213 | 2020-10-09 04:23:59 | Ceuta, Spain | ||
2689972 | 2689972 | 2020-10-08 | Spain | Extremadura | 12041 | 621 | 2652 | 8768 | 39.4937 | -6.0679 | 2020-10-09 04:23:59 | Extremadura, Spain | ||
2689973 | 2689973 | 2020-10-08 | Spain | Galicia | 23055 | 773 | 9204 | 13078 | 42.5751 | -8.1339 | 2020-10-09 04:23:59 | Galicia, Spain | ||
2689974 | 2689974 | 2020-10-08 | Spain | La Rioja | 9221 | 425 | 3107 | 5689 | 42.2871 | -2.5396 | 2020-10-09 04:23:59 | La Rioja, Spain | ||
2689975 | 2689975 | 2020-10-08 | Spain | Madrid | 258767 | 9637 | 40736 | 208394 | 40.4168 | -3.7038 | 2020-10-09 04:23:59 | Madrid, Spain | ||
2689976 | 2689976 | 2020-10-08 | Spain | Melilla | 1230 | 6 | 125 | 1099 | 35.2923 | -2.9381 | 2020-10-09 04:23:59 | Melilla, Spain | ||
2689977 | 2689977 | 2020-10-08 | Spain | Murcia | 22633 | 226 | 2180 | 20227 | 37.9922 | -1.1307 | 2020-10-09 04:23:59 | Murcia, Spain | ||
2689978 | 2689978 | 2020-10-08 | Spain | Navarra | 20553 | 607 | 3905 | 16041 | 42.6954 | -1.6761 | 2020-10-09 04:23:59 | Navarra, Spain | ||
2689979 | 2689979 | 2020-10-08 | Spain | Pais Vasco | 47631 | 1936 | 16160 | 29535 | 42.9896 | -2.6189 | 2020-10-09 04:23:59 | Pais Vasco, Spain | ||
2689980 | 2689980 | 2020-10-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-09 04:23:59 | Unknown, Spain |
Advanced export
JSON shape: default, array, newline-delimited
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]);