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 recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 20
- Andalusia 903
- Aragon 903
- Asturias 903
- Baleares 903
- C. Valenciana 903
- Canarias 903
- Cantabria 903
- Castilla - La Mancha 903
- Castilla y Leon 903
- Catalonia 903
- Ceuta 903
- Extremadura 903
- Galicia 903
- La Rioja 903
- Madrid 903
- Melilla 903
- Murcia 903
- Navarra 903
- Pais Vasco 903
- Unknown 850
country_or_region 1
- Spain · 18,110 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
447658 | 447658 | 2021-11-17 | Spain | Andalusia | 813881 | 11313 | 0 | 37.5443 | -4.7278 | 2021-11-18 04:21:33 | Andalusia, Spain | |||
447659 | 447659 | 2021-11-17 | Spain | Aragon | 165227 | 3925 | 0 | 41.5976 | -0.9057 | 2021-11-18 04:21:33 | Aragon, Spain | |||
447660 | 447660 | 2021-11-17 | Spain | Asturias | 72087 | 2084 | 0 | 43.3614 | -5.8593 | 2021-11-18 04:21:33 | Asturias, Spain | |||
447661 | 447661 | 2021-11-17 | Spain | Baleares | 102936 | 1011 | 0 | 39.710358 | 2.995148 | 2021-11-18 04:21:33 | Baleares, Spain | |||
447662 | 447662 | 2021-11-17 | Spain | C. Valenciana | 521600 | 7859 | 0 | 39.484 | -0.7533 | 2021-11-18 04:21:33 | C. Valenciana, Spain | |||
447663 | 447663 | 2021-11-17 | Spain | Canarias | 99812 | 1033 | 0 | 28.2916 | -16.6291 | 2021-11-18 04:21:33 | Canarias, Spain | |||
447664 | 447664 | 2021-11-17 | Spain | Cantabria | 47262 | 612 | 0 | 43.1828 | -3.9878 | 2021-11-18 04:21:33 | Cantabria, Spain | |||
447665 | 447665 | 2021-11-17 | Spain | Castilla - La Mancha | 242304 | 6512 | 0 | 39.2796 | -3.0977 | 2021-11-18 04:21:33 | Castilla - La Mancha, Spain | |||
447666 | 447666 | 2021-11-17 | Spain | Castilla y Leon | 304260 | 7379 | 0 | 41.8357 | -4.3976 | 2021-11-18 04:21:33 | Castilla y Leon, Spain | |||
447667 | 447667 | 2021-11-17 | Spain | Catalonia | 942731 | 15996 | 0 | 41.5912 | 1.5209 | 2021-11-18 04:21:33 | Catalonia, Spain | |||
447668 | 447668 | 2021-11-17 | Spain | Ceuta | 7613 | 128 | 0 | 35.8894 | -5.3213 | 2021-11-18 04:21:33 | Ceuta, Spain | |||
447669 | 447669 | 2021-11-17 | Spain | Extremadura | 103865 | 1991 | 0 | 39.4937 | -6.0679 | 2021-11-18 04:21:33 | Extremadura, Spain | |||
447670 | 447670 | 2021-11-17 | Spain | Galicia | 189343 | 2656 | 0 | 42.5751 | -8.1339 | 2021-11-18 04:21:33 | Galicia, Spain | |||
447671 | 447671 | 2021-11-17 | Spain | La Rioja | 40121 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-18 04:21:33 | La Rioja, Spain | |||
447672 | 447672 | 2021-11-17 | Spain | Madrid | 905548 | 16278 | 0 | 40.4168 | -3.7038 | 2021-11-18 04:21:33 | Madrid, Spain | |||
447673 | 447673 | 2021-11-17 | Spain | Melilla | 11135 | 113 | 0 | 35.2923 | -2.9381 | 2021-11-18 04:21:33 | Melilla, Spain | |||
447674 | 447674 | 2021-11-17 | Spain | Murcia | 143965 | 1759 | 0 | 37.9922 | -1.1307 | 2021-11-18 04:21:33 | Murcia, Spain | |||
447675 | 447675 | 2021-11-17 | Spain | Navarra | 85201 | 1256 | 0 | 42.6954 | -1.6761 | 2021-11-18 04:21:33 | Navarra, Spain | |||
447676 | 447676 | 2021-11-17 | Spain | Pais Vasco | 268821 | 5045 | 0 | 42.9896 | -2.6189 | 2021-11-18 04:21:33 | Pais Vasco, Spain | |||
447677 | 447677 | 2021-11-17 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
451678 | 451678 | 2022-12-21 | Spain | Andalusia | 1611387 | 14912 | 0 | 37.5443 | -4.7278 | 2022-12-22 04:20:56 | Andalusia, Spain | |||
451679 | 451679 | 2022-12-21 | Spain | Aragon | 463561 | 5389 | 0 | 41.5976 | -0.9057 | 2022-12-22 04:20:56 | Aragon, Spain | |||
451680 | 451680 | 2022-12-21 | Spain | Asturias | 263589 | 3378 | 0 | 43.3614 | -5.8593 | 2022-12-22 04:20:56 | Asturias, Spain | |||
451681 | 451681 | 2022-12-21 | Spain | Baleares | 312814 | 1605 | 0 | 39.710358 | 2.995148 | 2022-12-22 04:20:56 | Baleares, Spain | |||
451682 | 451682 | 2022-12-21 | Spain | C. Valenciana | 1575618 | 10196 | 0 | 39.484 | -0.7533 | 2022-12-22 04:20:56 | C. Valenciana, Spain | |||
451683 | 451683 | 2022-12-21 | Spain | Canarias | 456506 | 2147 | 0 | 28.2916 | -16.6291 | 2022-12-22 04:20:56 | Canarias, Spain | |||
451684 | 451684 | 2022-12-21 | Spain | Cantabria | 161752 | 976 | 0 | 43.1828 | -3.9878 | 2022-12-22 04:20:56 | Cantabria, Spain | |||
451685 | 451685 | 2022-12-21 | Spain | Castilla - La Mancha | 605329 | 8011 | 0 | 39.2796 | -3.0977 | 2022-12-22 04:20:56 | Castilla - La Mancha, Spain | |||
451686 | 451686 | 2022-12-21 | Spain | Castilla y Leon | 839955 | 9257 | 0 | 41.8357 | -4.3976 | 2022-12-22 04:20:56 | Castilla y Leon, Spain | |||
451687 | 451687 | 2022-12-21 | Spain | Catalonia | 2670726 | 20831 | 0 | 41.5912 | 1.5209 | 2022-12-22 04:20:56 | Catalonia, Spain | |||
451688 | 451688 | 2022-12-21 | Spain | Ceuta | 24535 | 192 | 0 | 35.8894 | -5.3213 | 2022-12-22 04:20:56 | Ceuta, Spain | |||
451689 | 451689 | 2022-12-21 | Spain | Extremadura | 307529 | 2667 | 0 | 39.4937 | -6.0679 | 2022-12-22 04:20:56 | Extremadura, Spain | |||
451690 | 451690 | 2022-12-21 | Spain | Galicia | 742872 | 3978 | 0 | 42.5751 | -8.1339 | 2022-12-22 04:20:56 | Galicia, Spain | |||
451691 | 451691 | 2022-12-21 | Spain | La Rioja | 110574 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-22 04:20:56 | La Rioja, Spain | |||
451692 | 451692 | 2022-12-21 | Spain | Madrid | 1969685 | 20181 | 0 | 40.4168 | -3.7038 | 2022-12-22 04:20:56 | Madrid, Spain | |||
451693 | 451693 | 2022-12-21 | Spain | Melilla | 25103 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-22 04:20:56 | Melilla, Spain | |||
451694 | 451694 | 2022-12-21 | Spain | Murcia | 462576 | 2497 | 0 | 37.9922 | -1.1307 | 2022-12-22 04:20:56 | Murcia, Spain | |||
451695 | 451695 | 2022-12-21 | Spain | Navarra | 256858 | 1736 | 0 | 42.6954 | -1.6761 | 2022-12-22 04:20:56 | Navarra, Spain | |||
451696 | 451696 | 2022-12-21 | Spain | Pais Vasco | 790270 | 7577 | 0 | 42.9896 | -2.6189 | 2022-12-22 04:20:56 | Pais Vasco, Spain | |||
451697 | 451697 | 2022-12-21 | Spain | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Spain | |||||
458796 | 458796 | 2020-08-07 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-08 04:34:53 | Unknown, Spain | ||||
459667 | 459667 | 2022-02-02 | Spain | Andalusia | 1255906 | 12088 | 0 | 37.5443 | -4.7278 | 2022-02-03 04:21:21 | Andalusia, Spain | |||
459668 | 459668 | 2022-02-02 | Spain | Aragon | 371068 | 4508 | 0 | 41.5976 | -0.9057 | 2022-02-03 04:21:21 | Aragon, Spain | |||
459669 | 459669 | 2022-02-02 | Spain | Asturias | 176969 | 2319 | 0 | 43.3614 | -5.8593 | 2022-02-03 04:21:21 | Asturias, Spain | |||
459670 | 459670 | 2022-02-02 | Spain | Baleares | 232463 | 1135 | 0 | 39.710358 | 2.995148 | 2022-02-03 04:21:21 | Baleares, Spain | |||
459671 | 459671 | 2022-02-02 | Spain | C. Valenciana | 1150908 | 8594 | 0 | 39.484 | -0.7533 | 2022-02-03 04:21:21 | C. Valenciana, Spain | |||
459672 | 459672 | 2022-02-02 | Spain | Canarias | 259715 | 1442 | 0 | 28.2916 | -16.6291 | 2022-02-03 04:21:21 | Canarias, Spain | |||
459673 | 459673 | 2022-02-02 | Spain | Cantabria | 114125 | 685 | 0 | 43.1828 | -3.9878 | 2022-02-03 04:21:21 | Cantabria, Spain | |||
459674 | 459674 | 2022-02-02 | Spain | Castilla - La Mancha | 438600 | 6875 | 0 | 39.2796 | -3.0977 | 2022-02-03 04:21:21 | Castilla - La Mancha, Spain | |||
459675 | 459675 | 2022-02-02 | Spain | Castilla y Leon | 608179 | 7950 | 0 | 41.8357 | -4.3976 | 2022-02-03 04:21:21 | Castilla y Leon, Spain | |||
459676 | 459676 | 2022-02-02 | Spain | Catalonia | 2078656 | 16303 | 0 | 41.5912 | 1.5209 | 2022-02-03 04:21:21 | Catalonia, Spain | |||
459677 | 459677 | 2022-02-02 | Spain | Ceuta | 17850 | 141 | 0 | 35.8894 | -5.3213 | 2022-02-03 04:21:21 | Ceuta, Spain | |||
459678 | 459678 | 2022-02-02 | Spain | Extremadura | 214806 | 2141 | 0 | 39.4937 | -6.0679 | 2022-02-03 04:21:21 | Extremadura, Spain | |||
459679 | 459679 | 2022-02-02 | Spain | Galicia | 458113 | 2942 | 0 | 42.5751 | -8.1339 | 2022-02-03 04:21:21 | Galicia, Spain | |||
459680 | 459680 | 2022-02-02 | Spain | La Rioja | 83523 | 887 | 0 | 42.2871 | -2.5396 | 2022-02-03 04:21:21 | La Rioja, Spain | |||
459681 | 459681 | 2022-02-02 | Spain | Madrid | 1488786 | 16615 | 0 | 40.4168 | -3.7038 | 2022-02-03 04:21:21 | Madrid, Spain | |||
459682 | 459682 | 2022-02-02 | Spain | Melilla | 19328 | 132 | 0 | 35.2923 | -2.9381 | 2022-02-03 04:21:21 | Melilla, Spain | |||
459683 | 459683 | 2022-02-02 | Spain | Murcia | 331436 | 1996 | 0 | 37.9922 | -1.1307 | 2022-02-03 04:21:21 | Murcia, Spain | |||
459684 | 459684 | 2022-02-02 | Spain | Navarra | 210433 | 1420 | 0 | 42.6954 | -1.6761 | 2022-02-03 04:21:21 | Navarra, Spain | |||
459685 | 459685 | 2022-02-02 | Spain | Pais Vasco | 614484 | 5684 | 0 | 42.9896 | -2.6189 | 2022-02-03 04:21:21 | Pais Vasco, Spain | |||
459686 | 459686 | 2022-02-02 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
463684 | 463684 | 2022-05-02 | Spain | Andalusia | 1445042 | 13447 | 0 | 37.5443 | -4.7278 | 2022-05-03 04:21:00 | Andalusia, Spain | |||
463685 | 463685 | 2022-05-02 | Spain | Aragon | 416624 | 4696 | 0 | 41.5976 | -0.9057 | 2022-05-03 04:21:00 | Aragon, Spain | |||
463686 | 463686 | 2022-05-02 | Spain | Asturias | 220365 | 2710 | 0 | 43.3614 | -5.8593 | 2022-05-03 04:21:00 | Asturias, Spain | |||
463687 | 463687 | 2022-05-02 | Spain | Baleares | 282058 | 1341 | 0 | 39.710358 | 2.995148 | 2022-05-03 04:21:00 | Baleares, Spain | |||
463688 | 463688 | 2022-05-02 | Spain | C. Valenciana | 1390766 | 9256 | 0 | 39.484 | -0.7533 | 2022-05-03 04:21:00 | C. Valenciana, Spain | |||
463689 | 463689 | 2022-05-02 | Spain | Canarias | 352983 | 1709 | 0 | 28.2916 | -16.6291 | 2022-05-03 04:21:00 | Canarias, Spain | |||
463690 | 463690 | 2022-05-02 | Spain | Cantabria | 135700 | 809 | 0 | 43.1828 | -3.9878 | 2022-05-03 04:21:00 | Cantabria, Spain | |||
463691 | 463691 | 2022-05-02 | Spain | Castilla - La Mancha | 503136 | 7205 | 0 | 39.2796 | -3.0977 | 2022-05-03 04:21:00 | Castilla - La Mancha, Spain | |||
463692 | 463692 | 2022-05-02 | Spain | Castilla y Leon | 716456 | 8487 | 0 | 41.8357 | -4.3976 | 2022-05-03 04:21:00 | Castilla y Leon, Spain | |||
463693 | 463693 | 2022-05-02 | Spain | Catalonia | 2404756 | 18981 | 0 | 41.5912 | 1.5209 | 2022-05-03 04:21:00 | Catalonia, Spain | |||
463694 | 463694 | 2022-05-02 | Spain | Ceuta | 20595 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-03 04:21:00 | Ceuta, Spain | |||
463695 | 463695 | 2022-05-02 | Spain | Extremadura | 261981 | 2319 | 0 | 39.4937 | -6.0679 | 2022-05-03 04:21:00 | Extremadura, Spain | |||
463696 | 463696 | 2022-05-02 | Spain | Galicia | 619950 | 3326 | 0 | 42.5751 | -8.1339 | 2022-05-03 04:21:00 | Galicia, Spain | |||
463697 | 463697 | 2022-05-02 | Spain | La Rioja | 95906 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-03 04:21:00 | La Rioja, Spain | |||
463698 | 463698 | 2022-05-02 | Spain | Madrid | 1668621 | 18542 | 0 | 40.4168 | -3.7038 | 2022-05-03 04:21:00 | Madrid, Spain | |||
463699 | 463699 | 2022-05-02 | Spain | Melilla | 21073 | 155 | 0 | 35.2923 | -2.9381 | 2022-05-03 04:21:00 | Melilla, Spain | |||
463700 | 463700 | 2022-05-02 | Spain | Murcia | 410726 | 2250 | 0 | 37.9922 | -1.1307 | 2022-05-03 04:21:00 | Murcia, Spain | |||
463701 | 463701 | 2022-05-02 | Spain | Navarra | 240920 | 1544 | 0 | 42.6954 | -1.6761 | 2022-05-03 04:21:00 | Navarra, Spain | |||
463702 | 463702 | 2022-05-02 | Spain | Pais Vasco | 688494 | 6611 | 0 | 42.9896 | -2.6189 | 2022-05-03 04:21:00 | Pais Vasco, Spain | |||
463703 | 463703 | 2022-05-02 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
467699 | 467699 | 2021-10-07 | Spain | Andalusia | 803238 | 11175 | 0 | 37.5443 | -4.7278 | 2021-10-08 04:21:25 | Andalusia, Spain | |||
467700 | 467700 | 2021-10-07 | Spain | Aragon | 161423 | 3847 | 0 | 41.5976 | -0.9057 | 2021-10-08 04:21:25 | Aragon, Spain | |||
467701 | 467701 | 2021-10-07 | Spain | Asturias | 70937 | 2067 | 0 | 43.3614 | -5.8593 | 2021-10-08 04:21:25 | Asturias, Spain | |||
467702 | 467702 | 2021-10-07 | Spain | Baleares | 99620 | 962 | 0 | 39.710358 | 2.995148 | 2021-10-08 04:21:25 | Baleares, Spain | |||
467703 | 467703 | 2021-10-07 | Spain | C. Valenciana | 511109 | 7776 | 0 | 39.484 | -0.7533 | 2021-10-08 04:21:25 | C. Valenciana, Spain | |||
467704 | 467704 | 2021-10-07 | Spain | Canarias | 95604 | 999 | 0 | 28.2916 | -16.6291 | 2021-10-08 04:21:25 | Canarias, Spain | |||
467705 | 467705 | 2021-10-07 | Spain | Cantabria | 46360 | 608 | 0 | 43.1828 | -3.9878 | 2021-10-08 04:21:25 | Cantabria, Spain | |||
467706 | 467706 | 2021-10-07 | Spain | Castilla - La Mancha | 238535 | 6469 | 0 | 39.2796 | -3.0977 | 2021-10-08 04:21:25 | Castilla - La Mancha, Spain | |||
467707 | 467707 | 2021-10-07 | Spain | Castilla y Leon | 299666 | 7318 | 0 | 41.8357 | -4.3976 | 2021-10-08 04:21:25 | Castilla y Leon, Spain | |||
467708 | 467708 | 2021-10-07 | Spain | Catalonia | 919883 | 15709 | 0 | 41.5912 | 1.5209 | 2021-10-08 04:21:25 | Catalonia, Spain | |||
467709 | 467709 | 2021-10-07 | Spain | Ceuta | 7564 | 128 | 0 | 35.8894 | -5.3213 | 2021-10-08 04:21:25 | Ceuta, Spain | |||
467710 | 467710 | 2021-10-07 | Spain | Extremadura | 102653 | 1989 | 0 | 39.4937 | -6.0679 | 2021-10-08 04:21:25 | Extremadura, Spain | |||
467711 | 467711 | 2021-10-07 | Spain | Galicia | 186744 | 2637 | 0 | 42.5751 | -8.1339 | 2021-10-08 04:21:25 | Galicia, Spain | |||
467712 | 467712 | 2021-10-07 | Spain | La Rioja | 39520 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-08 04:21:25 | La Rioja, Spain | |||
467713 | 467713 | 2021-10-07 | Spain | Madrid | 892668 | 16133 | 0 | 40.4168 | -3.7038 | 2021-10-08 04:21:25 | Madrid, Spain | |||
467714 | 467714 | 2021-10-07 | Spain | Melilla | 11022 | 108 | 0 | 35.2923 | -2.9381 | 2021-10-08 04:21:25 | Melilla, Spain | |||
467715 | 467715 | 2021-10-07 | Spain | Murcia | 141126 | 1737 | 0 | 37.9922 | -1.1307 | 2021-10-08 04:21:25 | Murcia, Spain | |||
467716 | 467716 | 2021-10-07 | Spain | Navarra | 82657 | 1247 | 0 | 42.6954 | -1.6761 | 2021-10-08 04:21:25 | Navarra, Spain | |||
467717 | 467717 | 2021-10-07 | Spain | Pais Vasco | 260981 | 4969 | 0 | 42.9896 | -2.6189 | 2021-10-08 04:21:25 | Pais Vasco, 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]);