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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 15
- Castilla - La Mancha 960
- Castilla y Leon 960
- Catalonia 960
- Madrid 960
- Pais Vasco 931
- Andalusia 860
- C. Valenciana 855
- Aragon 812
- Galicia 716
- Asturias 704
- Extremadura 697
- Murcia 669
- Canarias 326
- Navarra 319
- Baleares 154
country_or_region 1
- Spain · 10,936 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2215946 | 2215946 | 2020-08-23 | Spain | Andalusia | 22825 | 1460 | 10671 | 10694 | 37.5443 | -4.7278 | 2020-08-24 04:27:56 | Andalusia, Spain | ||
2299728 | 2299728 | 2020-08-22 | Spain | Andalusia | 22825 | 1460 | 10671 | 10694 | 37.5443 | -4.7278 | 2020-08-23 04:27:48 | Andalusia, Spain | ||
2510467 | 2510467 | 2020-08-27 | Spain | C. Valenciana | 22004 | 1461 | 9970 | 10573 | 39.484 | -0.7533 | 2020-08-28 04:28:11 | C. Valenciana, Spain | ||
609971 | 609971 | 2020-08-29 | Spain | C. Valenciana | 22695 | 1462 | 9970 | 11263 | 39.484 | -0.7533 | 2020-08-30 04:28:22 | C. Valenciana, Spain | ||
1523466 | 1523466 | 2020-08-28 | Spain | C. Valenciana | 22695 | 1462 | 9970 | 11263 | 39.484 | -0.7533 | 2020-08-29 04:28:19 | C. Valenciana, Spain | ||
3932309 | 3932309 | 2020-08-30 | Spain | C. Valenciana | 22695 | 1462 | 9970 | 11263 | 39.484 | -0.7533 | 2020-08-31 04:28:27 | C. Valenciana, Spain | ||
3308497 | 3308497 | 2021-01-13 | Spain | Galicia | 69816 | 1463 | 9204 | 59149 | 42.5751 | -8.1339 | 2021-01-14 05:22:32 | Galicia, Spain | ||
194350 | 194350 | 2020-08-31 | Spain | C. Valenciana | 24096 | 1465 | 9970 | 12661 | 39.484 | -0.7533 | 2020-09-01 04:28:31 | C. Valenciana, Spain | ||
2991551 | 2991551 | 2020-08-24 | Spain | Andalusia | 24650 | 1466 | 10671 | 12513 | 37.5443 | -4.7278 | 2020-08-25 04:28:02 | Andalusia, Spain | ||
3260931 | 3260931 | 2020-05-18 | Spain | Pais Vasco | 13422 | 1466 | 16160 | 0 | 42.9896 | -2.6189 | 2020-05-19 02:32:18 | Pais Vasco, Spain | ||
3879870 | 3879870 | 2021-01-14 | Spain | Galicia | 71067 | 1466 | 9204 | 60397 | 42.5751 | -8.1339 | 2021-01-15 05:22:24 | Galicia, Spain | ||
817847 | 817847 | 2020-10-09 | Spain | Aragon | 39267 | 1470 | 3772 | 34025 | 41.5976 | -0.9057 | 2020-10-10 04:23:57 | Aragon, Spain | ||
2390193 | 2390193 | 2020-05-19 | Spain | Pais Vasco | 13409 | 1470 | 0 | 11939 | 42.9896 | -2.6189 | 2020-05-20 02:32:19 | Pais Vasco, Spain | ||
2602314 | 2602314 | 2020-10-10 | Spain | Aragon | 39267 | 1470 | 3772 | 34025 | 41.5976 | -0.9057 | 2020-10-11 04:23:46 | Aragon, Spain | ||
2642058 | 2642058 | 2022-02-14 | Spain | Navarra | 218696 | 1470 | 0 | 42.6954 | -1.6761 | 2022-02-15 04:21:09 | Navarra, Spain | |||
3786176 | 3786176 | 2020-10-11 | Spain | Aragon | 39267 | 1470 | 3772 | 34025 | 41.5976 | -0.9057 | 2020-10-12 04:23:45 | Aragon, Spain | ||
1676765 | 1676765 | 2021-02-01 | Spain | Extremadura | 65442 | 1471 | 2652 | 61319 | 39.4937 | -6.0679 | 2021-02-02 05:22:49 | Extremadura, Spain | ||
2567949 | 2567949 | 2021-01-25 | Spain | Asturias | 33779 | 1471 | 1063 | 31245 | 43.3614 | -5.8593 | 2021-01-26 05:22:02 | Asturias, Spain | ||
3562847 | 3562847 | 2020-08-25 | Spain | Andalusia | 25176 | 1471 | 10671 | 13034 | 37.5443 | -4.7278 | 2020-08-26 04:28:11 | Andalusia, Spain | ||
674607 | 674607 | 2022-07-30 | Spain | Baleares | 305429 | 1473 | 0 | 39.710358 | 2.995148 | 2022-07-31 04:21:02 | Baleares, Spain | |||
1105836 | 1105836 | 2020-09-02 | Spain | C. Valenciana | 25461 | 1473 | 9970 | 14018 | 39.484 | -0.7533 | 2020-09-03 04:28:22 | C. Valenciana, Spain | ||
1783806 | 1783806 | 2022-07-29 | Spain | Baleares | 305429 | 1473 | 0 | 39.710358 | 2.995148 | 2022-07-30 04:20:42 | Baleares, Spain | |||
2060165 | 2060165 | 2020-09-01 | Spain | C. Valenciana | 25006 | 1473 | 9970 | 13563 | 39.484 | -0.7533 | 2020-09-02 04:28:25 | C. Valenciana, Spain | ||
3617373 | 3617373 | 2022-08-01 | Spain | Baleares | 305429 | 1473 | 0 | 39.710358 | 2.995148 | 2022-08-02 04:20:53 | Baleares, Spain | |||
3871853 | 3871853 | 2022-07-31 | Spain | Baleares | 305429 | 1473 | 0 | 39.710358 | 2.995148 | 2022-08-01 04:21:03 | Baleares, Spain | |||
12625 | 12625 | 2021-01-26 | Spain | Asturias | 34214 | 1475 | 1063 | 31676 | 43.3614 | -5.8593 | 2021-01-27 05:23:41 | Asturias, Spain | ||
1354599 | 1354599 | 2020-09-03 | Spain | C. Valenciana | 25996 | 1475 | 9970 | 14551 | 39.484 | -0.7533 | 2020-09-04 04:28:26 | C. Valenciana, Spain | ||
1996923 | 1996923 | 2020-08-26 | Spain | Andalusia | 26017 | 1475 | 10671 | 13871 | 37.5443 | -4.7278 | 2020-08-27 04:28:15 | Andalusia, Spain | ||
3671957 | 3671957 | 2022-02-15 | Spain | Navarra | 219268 | 1475 | 0 | 42.6954 | -1.6761 | 2022-02-16 04:21:10 | Navarra, Spain | |||
2510463 | 2510463 | 2020-08-27 | Spain | Andalusia | 26829 | 1476 | 10671 | 14682 | 37.5443 | -4.7278 | 2020-08-28 04:28:11 | Andalusia, Spain | ||
1298357 | 1298357 | 2022-02-17 | Spain | Navarra | 220156 | 1477 | 0 | 42.6954 | -1.6761 | 2022-02-18 04:21:04 | Navarra, Spain | |||
3820743 | 3820743 | 2022-02-16 | Spain | Navarra | 219746 | 1477 | 0 | 42.6954 | -1.6761 | 2022-02-17 04:20:56 | Navarra, Spain | |||
813859 | 813859 | 2020-09-05 | Spain | C. Valenciana | 26710 | 1478 | 9970 | 15262 | 39.484 | -0.7533 | 2020-09-06 04:28:33 | C. Valenciana, Spain | ||
2662059 | 2662059 | 2020-09-04 | Spain | C. Valenciana | 26710 | 1478 | 9970 | 15262 | 39.484 | -0.7533 | 2020-09-05 04:28:19 | C. Valenciana, Spain | ||
3161904 | 3161904 | 2020-09-06 | Spain | C. Valenciana | 26710 | 1478 | 9970 | 15262 | 39.484 | -0.7533 | 2020-09-07 04:28:30 | C. Valenciana, Spain | ||
3153890 | 3153890 | 2021-01-27 | Spain | Asturias | 34811 | 1479 | 1063 | 32269 | 43.3614 | -5.8593 | 2021-01-28 05:22:24 | Asturias, Spain | ||
609967 | 609967 | 2020-08-29 | Spain | Andalusia | 27734 | 1480 | 10671 | 15583 | 37.5443 | -4.7278 | 2020-08-30 04:28:22 | Andalusia, Spain | ||
1431945 | 1431945 | 2020-05-20 | Spain | Pais Vasco | 13435 | 1480 | 0 | 11955 | 42.9896 | -2.6189 | 2020-05-21 02:32:48 | Pais Vasco, Spain | ||
1523462 | 1523462 | 2020-08-28 | Spain | Andalusia | 27734 | 1480 | 10671 | 15583 | 37.5443 | -4.7278 | 2020-08-29 04:28:19 | Andalusia, Spain | ||
3932305 | 3932305 | 2020-08-30 | Spain | Andalusia | 27734 | 1480 | 10671 | 15583 | 37.5443 | -4.7278 | 2020-08-31 04:28:27 | 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 | ||
3856138 | 3856138 | 2022-02-18 | Spain | Navarra | 220509 | 1481 | 0 | 42.6954 | -1.6761 | 2022-02-19 04:21:11 | Navarra, Spain | |||
3875882 | 3875882 | 2022-02-19 | Spain | Navarra | 220509 | 1481 | 0 | 42.6954 | -1.6761 | 2022-02-20 04:21:00 | Navarra, Spain | |||
3912324 | 3912324 | 2022-02-20 | Spain | Navarra | 220509 | 1481 | 0 | 42.6954 | -1.6761 | 2022-02-21 04:21:05 | Navarra, Spain | |||
998738 | 998738 | 2021-03-01 | Spain | Murcia | 106388 | 1482 | 2180 | 102726 | 37.9922 | -1.1307 | 2021-03-02 05:23:30 | Murcia, Spain | ||
268362 | 268362 | 2020-05-21 | Spain | Pais Vasco | 13421 | 1483 | 0 | 11938 | 42.9896 | -2.6189 | 2020-05-22 02:36:51 | Pais Vasco, Spain | ||
3101735 | 3101735 | 2021-01-16 | Spain | Galicia | 72332 | 1484 | 9204 | 61644 | 42.5751 | -8.1339 | 2021-01-17 05:22:17 | Galicia, Spain | ||
3503652 | 3503652 | 2021-01-17 | Spain | Galicia | 72332 | 1484 | 9204 | 61644 | 42.5751 | -8.1339 | 2021-01-18 05:22:34 | Galicia, Spain | ||
3515697 | 3515697 | 2021-01-15 | Spain | Galicia | 72332 | 1484 | 9204 | 61644 | 42.5751 | -8.1339 | 2021-01-16 05:22:40 | Galicia, Spain | ||
427619 | 427619 | 2020-09-07 | Spain | C. Valenciana | 27842 | 1485 | 9970 | 16387 | 39.484 | -0.7533 | 2020-09-08 04:28:25 | C. Valenciana, Spain | ||
3782184 | 3782184 | 2020-10-13 | Spain | Aragon | 41029 | 1485 | 3772 | 35772 | 41.5976 | -0.9057 | 2020-10-14 04:24:05 | Aragon, Spain | ||
71383 | 71383 | 2022-02-07 | Spain | Canarias | 264522 | 1487 | 0 | 28.2916 | -16.6291 | 2022-02-08 04:21:15 | Canarias, Spain | |||
880572 | 880572 | 2022-08-05 | Spain | Baleares | 306219 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-06 04:20:56 | Baleares, Spain | |||
1070185 | 1070185 | 2022-08-07 | Spain | Baleares | 306219 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-08 04:21:08 | Baleares, Spain | |||
1086367 | 1086367 | 2022-08-09 | Spain | Baleares | 306505 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-10 04:20:57 | Baleares, Spain | |||
1098410 | 1098410 | 2022-08-03 | Spain | Baleares | 305789 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-04 04:20:58 | Baleares, Spain | |||
1346612 | 1346612 | 2022-08-10 | Spain | Baleares | 306505 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-11 04:20:49 | Baleares, Spain | |||
1405335 | 1405335 | 2022-08-02 | Spain | Baleares | 305789 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-03 04:20:59 | Baleares, Spain | |||
1864856 | 1864856 | 2020-05-22 | Spain | Pais Vasco | 13454 | 1487 | 0 | 11967 | 42.9896 | -2.6189 | 2020-05-23 02:32:42 | Pais Vasco, Spain | ||
1940773 | 1940773 | 2022-08-06 | Spain | Baleares | 306219 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-07 04:20:54 | Baleares, Spain | |||
2008983 | 2008983 | 2022-08-04 | Spain | Baleares | 305789 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-05 04:20:52 | Baleares, Spain | |||
2447077 | 2447077 | 2022-02-22 | Spain | Navarra | 221554 | 1487 | 0 | 42.6954 | -1.6761 | 2022-02-23 04:21:09 | Navarra, Spain | |||
3254446 | 3254446 | 2021-03-02 | Spain | Murcia | 106452 | 1487 | 2180 | 102785 | 37.9922 | -1.1307 | 2021-03-03 05:23:28 | Murcia, Spain | ||
3543782 | 3543782 | 2022-08-08 | Spain | Baleares | 306219 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-09 04:20:34 | Baleares, Spain | |||
3718490 | 3718490 | 2022-02-21 | Spain | Navarra | 221206 | 1487 | 0 | 42.6954 | -1.6761 | 2022-02-22 04:21:01 | Navarra, Spain | |||
3908295 | 3908295 | 2022-08-11 | Spain | Baleares | 306505 | 1487 | 0 | 39.710358 | 2.995148 | 2022-08-12 04:20:54 | Baleares, Spain | |||
1362645 | 1362645 | 2022-02-08 | Spain | Canarias | 266095 | 1489 | 0 | 28.2916 | -16.6291 | 2022-02-09 04:21:04 | Canarias, Spain | |||
1058154 | 1058154 | 2022-02-23 | Spain | Navarra | 221838 | 1490 | 0 | 42.6954 | -1.6761 | 2022-02-24 04:21:14 | Navarra, Spain | |||
1511713 | 1511713 | 2022-02-24 | Spain | Navarra | 222202 | 1490 | 0 | 42.6954 | -1.6761 | 2022-02-25 04:21:11 | Navarra, Spain | |||
2482255 | 2482255 | 2021-01-28 | Spain | Asturias | 35374 | 1490 | 1063 | 32821 | 43.3614 | -5.8593 | 2021-01-29 05:22:23 | Asturias, Spain | ||
575137 | 575137 | 2022-02-25 | Spain | Navarra | 222441 | 1491 | 0 | 42.6954 | -1.6761 | 2022-02-26 04:21:12 | Navarra, Spain | |||
943138 | 943138 | 2022-02-28 | Spain | Navarra | 222441 | 1491 | 0 | 42.6954 | -1.6761 | 2022-03-01 04:21:09 | Navarra, Spain | |||
2733329 | 2733329 | 2022-02-27 | Spain | Navarra | 222441 | 1491 | 0 | 42.6954 | -1.6761 | 2022-02-28 04:21:05 | Navarra, Spain | |||
3046482 | 3046482 | 2022-02-26 | Spain | Navarra | 222441 | 1491 | 0 | 42.6954 | -1.6761 | 2022-02-27 04:21:04 | Navarra, Spain | |||
194346 | 194346 | 2020-08-31 | Spain | Andalusia | 29808 | 1493 | 10671 | 17644 | 37.5443 | -4.7278 | 2020-09-01 04:28:31 | Andalusia, Spain | ||
1684795 | 1684795 | 2021-02-02 | Spain | Extremadura | 65831 | 1493 | 2652 | 61686 | 39.4937 | -6.0679 | 2021-02-03 05:22:52 | Extremadura, Spain | ||
875642 | 875642 | 2020-05-24 | Spain | Pais Vasco | 13476 | 1494 | 0 | 11982 | 42.9896 | -2.6189 | 2020-05-25 02:32:44 | Pais Vasco, Spain | ||
997833 | 997833 | 2020-05-23 | Spain | Pais Vasco | 13467 | 1494 | 0 | 11973 | 42.9896 | -2.6189 | 2020-05-24 02:32:43 | Pais Vasco, Spain | ||
1244040 | 1244040 | 2020-09-08 | Spain | C. Valenciana | 28513 | 1494 | 9970 | 17049 | 39.484 | -0.7533 | 2020-09-09 04:28:48 | C. Valenciana, Spain | ||
79369 | 79369 | 2020-10-14 | Spain | Aragon | 41298 | 1495 | 3772 | 36031 | 41.5976 | -0.9057 | 2020-10-15 04:24:28 | Aragon, Spain | ||
1992964 | 1992964 | 2022-03-01 | Spain | Navarra | 223178 | 1495 | 0 | 42.6954 | -1.6761 | 2022-03-02 04:21:07 | Navarra, Spain | |||
1090374 | 1090374 | 2021-03-03 | Spain | Murcia | 106579 | 1496 | 2180 | 102903 | 37.9922 | -1.1307 | 2021-03-04 05:24:24 | Murcia, Spain | ||
1644667 | 1644667 | 2022-03-03 | Spain | Navarra | 223676 | 1497 | 0 | 42.6954 | -1.6761 | 2022-03-04 04:21:09 | Navarra, Spain | |||
2525670 | 2525670 | 2022-03-02 | Spain | Navarra | 223386 | 1497 | 0 | 42.6954 | -1.6761 | 2022-03-03 04:21:01 | Navarra, Spain | |||
2092402 | 2092402 | 2022-03-05 | Spain | Navarra | 223910 | 1499 | 0 | 42.6954 | -1.6761 | 2022-03-06 04:20:49 | Navarra, Spain | |||
2199945 | 2199945 | 2022-03-06 | Spain | Navarra | 223910 | 1499 | 0 | 42.6954 | -1.6761 | 2022-03-07 04:20:47 | Navarra, Spain | |||
2666102 | 2666102 | 2022-03-04 | Spain | Navarra | 223910 | 1499 | 0 | 42.6954 | -1.6761 | 2022-03-05 04:21:10 | Navarra, Spain | |||
3074338 | 3074338 | 2022-02-09 | Spain | Canarias | 267335 | 1499 | 0 | 28.2916 | -16.6291 | 2022-02-10 04:21:14 | Canarias, Spain | |||
1548276 | 1548276 | 2022-03-07 | Spain | Navarra | 224450 | 1500 | 0 | 42.6954 | -1.6761 | 2022-03-08 04:20:54 | Navarra, Spain | |||
2060161 | 2060161 | 2020-09-01 | Spain | Andalusia | 30767 | 1500 | 10671 | 18596 | 37.5443 | -4.7278 | 2020-09-02 04:28:25 | Andalusia, Spain | ||
786658 | 786658 | 2020-10-15 | Spain | Aragon | 41895 | 1501 | 3772 | 36622 | 41.5976 | -0.9057 | 2020-10-16 04:24:01 | Aragon, Spain | ||
1173466 | 1173466 | 2020-09-10 | Spain | C. Valenciana | 29907 | 1501 | 9970 | 18436 | 39.484 | -0.7533 | 2020-09-11 04:46:23 | C. Valenciana, Spain | ||
2171831 | 2171831 | 2020-09-09 | Spain | C. Valenciana | 29253 | 1501 | 9970 | 17782 | 39.484 | -0.7533 | 2020-09-10 04:29:01 | C. Valenciana, Spain | ||
919989 | 919989 | 2022-03-08 | Spain | Navarra | 224767 | 1502 | 0 | 42.6954 | -1.6761 | 2022-03-09 04:20:59 | Navarra, Spain | |||
2140478 | 2140478 | 2022-03-09 | Spain | Navarra | 225068 | 1502 | 0 | 42.6954 | -1.6761 | 2022-03-10 04:20:48 | Navarra, Spain | |||
2207953 | 2207953 | 2021-03-04 | Spain | Murcia | 106694 | 1502 | 2180 | 103012 | 37.9922 | -1.1307 | 2021-03-05 05:26:29 | Murcia, Spain | ||
1464377 | 1464377 | 2022-02-10 | Spain | Canarias | 268649 | 1503 | 0 | 28.2916 | -16.6291 | 2022-02-11 04:21:09 | Canarias, Spain | |||
1865783 | 1865783 | 2022-03-10 | Spain | Navarra | 225343 | 1504 | 0 | 42.6954 | -1.6761 | 2022-03-11 04:20:50 | Navarra, Spain | |||
237535 | 237535 | 2021-01-18 | Spain | Galicia | 75936 | 1505 | 9204 | 65227 | 42.5751 | -8.1339 | 2021-01-19 05:22:15 | Galicia, Spain | ||
356631 | 356631 | 2022-03-11 | Spain | Navarra | 225674 | 1505 | 0 | 42.6954 | -1.6761 | 2022-03-12 04:20:50 | Navarra, 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]);