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 191
- Aragon 191
- Asturias 191
- Baleares 191
- C. Valenciana 191
- Canarias 191
- Cantabria 191
- Castilla - La Mancha 191
- Castilla y Leon 191
- Catalonia 191
- Ceuta 191
- Extremadura 191
- Galicia 191
- La Rioja 191
- Madrid 191
- Melilla 191
- Murcia 191
- Navarra 191
- Pais Vasco 191
- Unknown 186
country_or_region 1
- Spain · 3,918 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2701792 | 2701792 | 2020-11-20 | Spain | Andalusia | 212439 | 3527 | 10671 | 198241 | 37.5443 | -4.7278 | 2020-11-21 05:25:51 | Andalusia, Spain | ||
2701793 | 2701793 | 2020-11-20 | Spain | Aragon | 70624 | 2148 | 3772 | 64704 | 41.5976 | -0.9057 | 2020-11-21 05:25:51 | Aragon, Spain | ||
2701794 | 2701794 | 2020-11-20 | Spain | Asturias | 20637 | 800 | 1063 | 18774 | 43.3614 | -5.8593 | 2020-11-21 05:25:51 | Asturias, Spain | ||
2701795 | 2701795 | 2020-11-20 | Spain | Baleares | 22764 | 398 | 1533 | 20833 | 39.710358 | 2.995148 | 2020-11-21 05:25:51 | Baleares, Spain | ||
2701796 | 2701796 | 2020-11-20 | Spain | C. Valenciana | 91912 | 2168 | 9970 | 79774 | 39.484 | -0.7533 | 2020-11-21 05:25:51 | C. Valenciana, Spain | ||
2701797 | 2701797 | 2020-11-20 | Spain | Canarias | 19869 | 322 | 1537 | 18010 | 28.2916 | -16.6291 | 2020-11-21 05:25:51 | Canarias, Spain | ||
2701798 | 2701798 | 2020-11-20 | Spain | Cantabria | 14145 | 293 | 2287 | 11565 | 43.1828 | -3.9878 | 2020-11-21 05:25:51 | Cantabria, Spain | ||
2701799 | 2701799 | 2020-11-20 | Spain | Castilla - La Mancha | 80928 | 3659 | 6392 | 70877 | 39.2796 | -3.0977 | 2020-11-21 05:25:51 | Castilla - La Mancha, Spain | ||
2701800 | 2701800 | 2020-11-20 | Spain | Castilla y Leon | 114549 | 4293 | 8716 | 101540 | 41.8357 | -4.3976 | 2020-11-21 05:25:51 | Castilla y Leon, Spain | ||
2701801 | 2701801 | 2020-11-20 | Spain | Catalonia | 292348 | 7495 | 26203 | 258650 | 41.5912 | 1.5209 | 2020-11-21 05:25:51 | Catalonia, Spain | ||
2701802 | 2701802 | 2020-11-20 | Spain | Ceuta | 2659 | 46 | 163 | 2450 | 35.8894 | -5.3213 | 2020-11-21 05:25:51 | Ceuta, Spain | ||
2701803 | 2701803 | 2020-11-20 | Spain | Extremadura | 27155 | 874 | 2652 | 23629 | 39.4937 | -6.0679 | 2020-11-21 05:25:51 | Extremadura, Spain | ||
2701804 | 2701804 | 2020-11-20 | Spain | Galicia | 46120 | 1131 | 9204 | 35785 | 42.5751 | -8.1339 | 2020-11-21 05:25:51 | Galicia, Spain | ||
2701805 | 2701805 | 2020-11-20 | Spain | La Rioja | 15771 | 526 | 3107 | 12138 | 42.2871 | -2.5396 | 2020-11-21 05:25:51 | La Rioja, Spain | ||
2701806 | 2701806 | 2020-11-20 | Spain | Madrid | 339405 | 11201 | 40736 | 287468 | 40.4168 | -3.7038 | 2020-11-21 05:25:51 | Madrid, Spain | ||
2701807 | 2701807 | 2020-11-20 | Spain | Melilla | 3853 | 35 | 125 | 3693 | 35.2923 | -2.9381 | 2020-11-21 05:25:51 | Melilla, Spain | ||
2701808 | 2701808 | 2020-11-20 | Spain | Murcia | 51666 | 543 | 2180 | 48943 | 37.9922 | -1.1307 | 2020-11-21 05:25:51 | Murcia, Spain | ||
2701809 | 2701809 | 2020-11-20 | Spain | Navarra | 38482 | 822 | 3905 | 33755 | 42.6954 | -1.6761 | 2020-11-21 05:25:51 | Navarra, Spain | ||
2701810 | 2701810 | 2020-11-20 | Spain | Pais Vasco | 91404 | 2338 | 16160 | 72906 | 42.9896 | -2.6189 | 2020-11-21 05:25:51 | Pais Vasco, Spain | ||
2701811 | 2701811 | 2020-11-20 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-21 05:25:51 | Unknown, Spain | ||||
821852 | 821852 | 2020-11-19 | Spain | Andalusia | 208674 | 3472 | 10671 | 194531 | 37.5443 | -4.7278 | 2020-11-20 05:26:28 | Andalusia, Spain | ||
821853 | 821853 | 2020-11-19 | Spain | Aragon | 70209 | 2129 | 3772 | 64308 | 41.5976 | -0.9057 | 2020-11-20 05:26:28 | Aragon, Spain | ||
821854 | 821854 | 2020-11-19 | Spain | Asturias | 20321 | 775 | 1063 | 18483 | 43.3614 | -5.8593 | 2020-11-20 05:26:28 | Asturias, Spain | ||
821855 | 821855 | 2020-11-19 | Spain | Baleares | 22581 | 398 | 1533 | 20650 | 39.710358 | 2.995148 | 2020-11-20 05:26:28 | Baleares, Spain | ||
821856 | 821856 | 2020-11-19 | Spain | C. Valenciana | 89994 | 2124 | 9970 | 77900 | 39.484 | -0.7533 | 2020-11-20 05:26:28 | C. Valenciana, Spain | ||
821857 | 821857 | 2020-11-19 | Spain | Canarias | 19753 | 321 | 1537 | 17895 | 28.2916 | -16.6291 | 2020-11-20 05:26:28 | Canarias, Spain | ||
821858 | 821858 | 2020-11-19 | Spain | Cantabria | 13984 | 292 | 2287 | 11405 | 43.1828 | -3.9878 | 2020-11-20 05:26:28 | Cantabria, Spain | ||
821859 | 821859 | 2020-11-19 | Spain | Castilla - La Mancha | 80269 | 3635 | 6392 | 70242 | 39.2796 | -3.0977 | 2020-11-20 05:26:28 | Castilla - La Mancha, Spain | ||
821860 | 821860 | 2020-11-19 | Spain | Castilla y Leon | 113142 | 4253 | 8716 | 100173 | 41.8357 | -4.3976 | 2020-11-20 05:26:28 | Castilla y Leon, Spain | ||
821861 | 821861 | 2020-11-19 | Spain | Catalonia | 290182 | 7450 | 26203 | 256529 | 41.5912 | 1.5209 | 2020-11-20 05:26:28 | Catalonia, Spain | ||
821862 | 821862 | 2020-11-19 | Spain | Ceuta | 2629 | 45 | 163 | 2421 | 35.8894 | -5.3213 | 2020-11-20 05:26:28 | Ceuta, Spain | ||
821863 | 821863 | 2020-11-19 | Spain | Extremadura | 26877 | 872 | 2652 | 23353 | 39.4937 | -6.0679 | 2020-11-20 05:26:28 | Extremadura, Spain | ||
821864 | 821864 | 2020-11-19 | Spain | Galicia | 45408 | 1114 | 9204 | 35090 | 42.5751 | -8.1339 | 2020-11-20 05:26:28 | Galicia, Spain | ||
821865 | 821865 | 2020-11-19 | Spain | La Rioja | 15667 | 523 | 3107 | 12037 | 42.2871 | -2.5396 | 2020-11-20 05:26:28 | La Rioja, Spain | ||
821866 | 821866 | 2020-11-19 | Spain | Madrid | 337999 | 11181 | 40736 | 286082 | 40.4168 | -3.7038 | 2020-11-20 05:26:28 | Madrid, Spain | ||
821867 | 821867 | 2020-11-19 | Spain | Melilla | 3806 | 35 | 125 | 3646 | 35.2923 | -2.9381 | 2020-11-20 05:26:28 | Melilla, Spain | ||
821868 | 821868 | 2020-11-19 | Spain | Murcia | 51266 | 521 | 2180 | 48565 | 37.9922 | -1.1307 | 2020-11-20 05:26:28 | Murcia, Spain | ||
821869 | 821869 | 2020-11-19 | Spain | Navarra | 38322 | 817 | 3905 | 33600 | 42.6954 | -1.6761 | 2020-11-20 05:26:28 | Navarra, Spain | ||
821870 | 821870 | 2020-11-19 | Spain | Pais Vasco | 90491 | 2334 | 16160 | 71997 | 42.9896 | -2.6189 | 2020-11-20 05:26:28 | Pais Vasco, Spain | ||
821871 | 821871 | 2020-11-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-20 05:26:28 | Unknown, Spain | ||||
122986 | 122986 | 2020-11-18 | Spain | Andalusia | 205359 | 3424 | 10671 | 191264 | 37.5443 | -4.7278 | 2020-11-19 05:25:23 | Andalusia, Spain | ||
122987 | 122987 | 2020-11-18 | Spain | Aragon | 69665 | 2106 | 3772 | 63787 | 41.5976 | -0.9057 | 2020-11-19 05:25:23 | Aragon, Spain | ||
122988 | 122988 | 2020-11-18 | Spain | Asturias | 19869 | 755 | 1063 | 18051 | 43.3614 | -5.8593 | 2020-11-19 05:25:23 | Asturias, Spain | ||
122989 | 122989 | 2020-11-18 | Spain | Baleares | 22408 | 397 | 1533 | 20478 | 39.710358 | 2.995148 | 2020-11-19 05:25:23 | Baleares, Spain | ||
122990 | 122990 | 2020-11-18 | Spain | C. Valenciana | 87787 | 2108 | 9970 | 75709 | 39.484 | -0.7533 | 2020-11-19 05:25:23 | C. Valenciana, Spain | ||
122991 | 122991 | 2020-11-18 | Spain | Canarias | 19605 | 319 | 1537 | 17749 | 28.2916 | -16.6291 | 2020-11-19 05:25:23 | Canarias, Spain | ||
122992 | 122992 | 2020-11-18 | Spain | Cantabria | 13750 | 291 | 2287 | 11172 | 43.1828 | -3.9878 | 2020-11-19 05:25:23 | Cantabria, Spain | ||
122993 | 122993 | 2020-11-18 | Spain | Castilla - La Mancha | 79579 | 3597 | 6392 | 69590 | 39.2796 | -3.0977 | 2020-11-19 05:25:23 | Castilla - La Mancha, Spain | ||
122994 | 122994 | 2020-11-18 | Spain | Castilla y Leon | 111281 | 4237 | 8716 | 98328 | 41.8357 | -4.3976 | 2020-11-19 05:25:23 | Castilla y Leon, Spain | ||
122995 | 122995 | 2020-11-18 | Spain | Catalonia | 288067 | 7426 | 26203 | 254438 | 41.5912 | 1.5209 | 2020-11-19 05:25:23 | Catalonia, Spain | ||
122996 | 122996 | 2020-11-18 | Spain | Ceuta | 2584 | 45 | 163 | 2376 | 35.8894 | -5.3213 | 2020-11-19 05:25:23 | Ceuta, Spain | ||
122997 | 122997 | 2020-11-18 | Spain | Extremadura | 26614 | 860 | 2652 | 23102 | 39.4937 | -6.0679 | 2020-11-19 05:25:23 | Extremadura, Spain | ||
122998 | 122998 | 2020-11-18 | Spain | Galicia | 44755 | 1108 | 9204 | 34443 | 42.5751 | -8.1339 | 2020-11-19 05:25:23 | Galicia, Spain | ||
122999 | 122999 | 2020-11-18 | Spain | La Rioja | 15509 | 521 | 3107 | 11881 | 42.2871 | -2.5396 | 2020-11-19 05:25:23 | La Rioja, Spain | ||
123000 | 123000 | 2020-11-18 | Spain | Madrid | 336384 | 11158 | 40736 | 284490 | 40.4168 | -3.7038 | 2020-11-19 05:25:23 | Madrid, Spain | ||
123001 | 123001 | 2020-11-18 | Spain | Melilla | 3764 | 34 | 125 | 3605 | 35.2923 | -2.9381 | 2020-11-19 05:25:23 | Melilla, Spain | ||
123002 | 123002 | 2020-11-18 | Spain | Murcia | 50838 | 512 | 2180 | 48146 | 37.9922 | -1.1307 | 2020-11-19 05:25:23 | Murcia, Spain | ||
123003 | 123003 | 2020-11-18 | Spain | Navarra | 38179 | 810 | 3905 | 33464 | 42.6954 | -1.6761 | 2020-11-19 05:25:23 | Navarra, Spain | ||
123004 | 123004 | 2020-11-18 | Spain | Pais Vasco | 89344 | 2331 | 16160 | 70853 | 42.9896 | -2.6189 | 2020-11-19 05:25:23 | Pais Vasco, Spain | ||
123005 | 123005 | 2020-11-18 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-19 05:25:23 | Unknown, Spain | ||||
3338874 | 3338874 | 2020-11-17 | Spain | Andalusia | 202491 | 3354 | 10671 | 188466 | 37.5443 | -4.7278 | 2020-11-18 05:40:31 | Andalusia, Spain | ||
3338875 | 3338875 | 2020-11-17 | Spain | Aragon | 69196 | 2067 | 3772 | 63357 | 41.5976 | -0.9057 | 2020-11-18 05:40:31 | Aragon, Spain | ||
3338876 | 3338876 | 2020-11-17 | Spain | Asturias | 19414 | 739 | 1063 | 17612 | 43.3614 | -5.8593 | 2020-11-18 05:40:31 | Asturias, Spain | ||
3338877 | 3338877 | 2020-11-17 | Spain | Baleares | 22204 | 397 | 1533 | 20274 | 39.710358 | 2.995148 | 2020-11-18 05:40:31 | Baleares, Spain | ||
3338878 | 3338878 | 2020-11-17 | Spain | C. Valenciana | 85879 | 2055 | 9970 | 73854 | 39.484 | -0.7533 | 2020-11-18 05:40:31 | C. Valenciana, Spain | ||
3338879 | 3338879 | 2020-11-17 | Spain | Canarias | 19456 | 318 | 1537 | 17601 | 28.2916 | -16.6291 | 2020-11-18 05:40:31 | Canarias, Spain | ||
3338880 | 3338880 | 2020-11-17 | Spain | Cantabria | 13473 | 282 | 2287 | 10904 | 43.1828 | -3.9878 | 2020-11-18 05:40:31 | Cantabria, Spain | ||
3338881 | 3338881 | 2020-11-17 | Spain | Castilla - La Mancha | 78735 | 3584 | 6392 | 68759 | 39.2796 | -3.0977 | 2020-11-18 05:40:31 | Castilla - La Mancha, Spain | ||
3338882 | 3338882 | 2020-11-17 | Spain | Castilla y Leon | 109973 | 4188 | 8716 | 97069 | 41.8357 | -4.3976 | 2020-11-18 05:40:31 | Castilla y Leon, Spain | ||
3338883 | 3338883 | 2020-11-17 | Spain | Catalonia | 285993 | 7410 | 26203 | 252380 | 41.5912 | 1.5209 | 2020-11-18 05:40:31 | Catalonia, Spain | ||
3338884 | 3338884 | 2020-11-17 | Spain | Ceuta | 2533 | 46 | 163 | 2324 | 35.8894 | -5.3213 | 2020-11-18 05:40:31 | Ceuta, Spain | ||
3338885 | 3338885 | 2020-11-17 | Spain | Extremadura | 26312 | 850 | 2652 | 22810 | 39.4937 | -6.0679 | 2020-11-18 05:40:31 | Extremadura, Spain | ||
3338886 | 3338886 | 2020-11-17 | Spain | Galicia | 44182 | 1101 | 9204 | 33877 | 42.5751 | -8.1339 | 2020-11-18 05:40:31 | Galicia, Spain | ||
3338887 | 3338887 | 2020-11-17 | Spain | La Rioja | 15381 | 517 | 3107 | 11757 | 42.2871 | -2.5396 | 2020-11-18 05:40:31 | La Rioja, Spain | ||
3338888 | 3338888 | 2020-11-17 | Spain | Madrid | 334655 | 11111 | 40736 | 282808 | 40.4168 | -3.7038 | 2020-11-18 05:40:31 | Madrid, Spain | ||
3338889 | 3338889 | 2020-11-17 | Spain | Melilla | 3728 | 34 | 125 | 3569 | 35.2923 | -2.9381 | 2020-11-18 05:40:31 | Melilla, Spain | ||
3338890 | 3338890 | 2020-11-17 | Spain | Murcia | 50298 | 501 | 2180 | 47617 | 37.9922 | -1.1307 | 2020-11-18 05:40:31 | Murcia, Spain | ||
3338891 | 3338891 | 2020-11-17 | Spain | Navarra | 38011 | 803 | 3905 | 33303 | 42.6954 | -1.6761 | 2020-11-18 05:40:31 | Navarra, Spain | ||
3338892 | 3338892 | 2020-11-17 | Spain | Pais Vasco | 88109 | 2331 | 16160 | 69618 | 42.9896 | -2.6189 | 2020-11-18 05:40:31 | Pais Vasco, Spain | ||
3338893 | 3338893 | 2020-11-17 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-18 05:40:31 | Unknown, Spain | ||||
3169919 | 3169919 | 2020-11-16 | Spain | Andalusia | 200550 | 3264 | 10671 | 186615 | 37.5443 | -4.7278 | 2020-11-17 05:25:54 | Andalusia, Spain | ||
3169920 | 3169920 | 2020-11-16 | Spain | Aragon | 68814 | 2039 | 3772 | 63003 | 41.5976 | -0.9057 | 2020-11-17 05:25:54 | Aragon, Spain | ||
3169921 | 3169921 | 2020-11-16 | Spain | Asturias | 19136 | 732 | 1063 | 17341 | 43.3614 | -5.8593 | 2020-11-17 05:25:54 | Asturias, Spain | ||
3169922 | 3169922 | 2020-11-16 | Spain | Baleares | 21988 | 391 | 1533 | 20064 | 39.710358 | 2.995148 | 2020-11-17 05:25:54 | Baleares, Spain | ||
3169923 | 3169923 | 2020-11-16 | Spain | C. Valenciana | 84029 | 2028 | 9970 | 72031 | 39.484 | -0.7533 | 2020-11-17 05:25:54 | C. Valenciana, Spain | ||
3169924 | 3169924 | 2020-11-16 | Spain | Canarias | 19360 | 312 | 1537 | 17511 | 28.2916 | -16.6291 | 2020-11-17 05:25:54 | Canarias, Spain | ||
3169925 | 3169925 | 2020-11-16 | Spain | Cantabria | 13235 | 279 | 2287 | 10669 | 43.1828 | -3.9878 | 2020-11-17 05:25:54 | Cantabria, Spain | ||
3169926 | 3169926 | 2020-11-16 | Spain | Castilla - La Mancha | 77866 | 3574 | 6392 | 67900 | 39.2796 | -3.0977 | 2020-11-17 05:25:54 | Castilla - La Mancha, Spain | ||
3169927 | 3169927 | 2020-11-16 | Spain | Castilla y Leon | 108777 | 4122 | 8716 | 95939 | 41.8357 | -4.3976 | 2020-11-17 05:25:54 | Castilla y Leon, Spain | ||
3169928 | 3169928 | 2020-11-16 | Spain | Catalonia | 283937 | 7382 | 26203 | 250352 | 41.5912 | 1.5209 | 2020-11-17 05:25:54 | Catalonia, Spain | ||
3169929 | 3169929 | 2020-11-16 | Spain | Ceuta | 2496 | 46 | 163 | 2287 | 35.8894 | -5.3213 | 2020-11-17 05:25:54 | Ceuta, Spain | ||
3169930 | 3169930 | 2020-11-16 | Spain | Extremadura | 26066 | 838 | 2652 | 22576 | 39.4937 | -6.0679 | 2020-11-17 05:25:54 | Extremadura, Spain | ||
3169931 | 3169931 | 2020-11-16 | Spain | Galicia | 43714 | 1084 | 9204 | 33426 | 42.5751 | -8.1339 | 2020-11-17 05:25:54 | Galicia, Spain | ||
3169932 | 3169932 | 2020-11-16 | Spain | La Rioja | 15305 | 516 | 3107 | 11682 | 42.2871 | -2.5396 | 2020-11-17 05:25:54 | La Rioja, Spain | ||
3169933 | 3169933 | 2020-11-16 | Spain | Madrid | 333215 | 11082 | 40736 | 281397 | 40.4168 | -3.7038 | 2020-11-17 05:25:54 | Madrid, Spain | ||
3169934 | 3169934 | 2020-11-16 | Spain | Melilla | 3685 | 33 | 125 | 3527 | 35.2923 | -2.9381 | 2020-11-17 05:25:54 | Melilla, Spain | ||
3169935 | 3169935 | 2020-11-16 | Spain | Murcia | 49720 | 486 | 2180 | 47054 | 37.9922 | -1.1307 | 2020-11-17 05:25:54 | Murcia, Spain | ||
3169936 | 3169936 | 2020-11-16 | Spain | Navarra | 37870 | 800 | 3905 | 33165 | 42.6954 | -1.6761 | 2020-11-17 05:25:54 | Navarra, Spain | ||
3169937 | 3169937 | 2020-11-16 | Spain | Pais Vasco | 87101 | 2245 | 16160 | 68696 | 42.9896 | -2.6189 | 2020-11-17 05:25:54 | Pais Vasco, Spain | ||
3169938 | 3169938 | 2020-11-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-17 05:25:54 | 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]);