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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, day (date), last_update (date)
latitude 22 ✖
province_or_state 20
- Andalusia 960
- Aragon 960
- Asturias 960
- Baleares 960
- C. Valenciana 960
- Canarias 960
- Cantabria 960
- Castilla - La Mancha 960
- Castilla y Leon 960
- Catalonia 960
- Ceuta 960
- Extremadura 960
- Galicia 960
- La Rioja 960
- Madrid 960
- Melilla 960
- Murcia 960
- Navarra 960
- Pais Vasco 960
- Unknown 955
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3847410 | 3847410 | 2020-05-13 | Spain | 228691 | 27104 | 140823 | 60764 | 40.463667 | -3.74922 | 2020-05-14 03:32:28 | Spain | |||
2581616 | 2581616 | 2020-05-12 | Spain | 228030 | 26920 | 138980 | 62130 | 40.463667 | -3.74922 | 2020-05-13 03:32:26 | Spain | |||
3331150 | 3331150 | 2020-05-11 | Spain | 227436 | 26744 | 137139 | 63553 | 40.463667 | -3.74922 | 2020-05-12 03:32:27 | Spain | |||
3459765 | 3459765 | 2020-05-10 | Spain | 224350 | 26621 | 136166 | 61563 | 40.463667 | -3.74922 | 2020-05-11 02:32:30 | Spain | |||
2899306 | 2899306 | 2020-05-09 | Spain | 223578 | 26478 | 133952 | 63148 | 40.463667 | -3.74922 | 2020-05-10 02:32:30 | Spain | |||
114355 | 114355 | 2020-05-08 | Spain | 222857 | 26299 | 131148 | 65410 | 40.463667 | -3.74922 | 2020-05-09 02:32:35 | Spain | |||
3295798 | 3295798 | 2020-05-07 | Spain | 221447 | 26070 | 128511 | 66866 | 40.463667 | -3.74922 | 2020-05-08 02:32:32 | Spain | |||
2111019 | 2111019 | 2020-05-06 | Spain | 220325 | 25857 | 126002 | 68466 | 40.463667 | -3.74922 | 2020-05-07 02:32:28 | Spain | |||
1932059 | 1932059 | 2020-05-05 | Spain | 219329 | 25613 | 123486 | 70230 | 40.463667 | -3.74922 | 2020-05-06 02:32:31 | Spain | |||
3084922 | 3084922 | 2020-05-04 | Spain | 218011 | 25428 | 121343 | 71240 | 40.463667 | -3.74922 | 2020-05-05 02:32:34 | Spain | |||
2278781 | 2278781 | 2020-05-03 | Spain | 217466 | 25264 | 118902 | 73300 | 40.463667 | -3.74922 | 2020-05-04 02:32:28 | Spain | |||
2043457 | 2043457 | 2020-05-02 | Spain | 216582 | 25100 | 117248 | 74234 | 40.463667 | -3.74922 | 2020-05-03 02:32:28 | Spain | |||
228832 | 228832 | 2020-04-30 | Spain | 213435 | 24543 | 112050 | 76842 | 40.463667 | -3.74922 | 2020-05-01 02:32:28 | Spain | |||
1184351 | 1184351 | 2020-05-01 | Spain | 213435 | 24543 | 112050 | 76842 | 40.463667 | -3.74922 | 2020-05-02 02:32:27 | Spain | |||
137578 | 137578 | 2020-04-29 | Spain | 236899 | 24275 | 132929 | 79695 | 40.463667 | -3.7492199999999998 | 2020-04-30 02:32:27 | Spain | |||
271792 | 271792 | 2020-04-28 | Spain | 232128 | 23822 | 123903 | 84403 | 40.463667 | -3.7492199999999998 | 2020-04-29 02:32:29 | Spain | |||
3589447 | 3589447 | 2020-04-27 | Spain | 229422 | 23521 | 120832 | 85069 | 40.463667 | -3.7492199999999998 | 2020-04-28 02:30:32 | Spain | |||
3592625 | 3592625 | 2020-04-26 | Spain | 226629 | 23190 | 117727 | 85712 | 40.463667 | -3.7492199999999998 | 2020-04-27 02:30:33 | Spain | |||
3502974 | 3502974 | 2020-04-25 | Spain | 223759 | 22902 | 95708 | 105149 | 40.463667 | -3.7492199999999998 | 2020-04-26 02:30:31 | Spain | |||
1459375 | 1459375 | 2020-04-24 | Spain | 219764 | 22524 | 92355 | 104885 | 40.463667 | -3.7492199999999998 | 2020-04-25 06:30:33 | Spain | |||
2524964 | 2524964 | 2020-04-23 | Spain | 213024 | 22157 | 89250 | 101617 | 40.463667 | -3.7492199999999998 | 2020-04-24 03:30:31 | Spain | |||
1199414 | 1199414 | 2020-04-22 | Spain | 208389 | 21717 | 85915 | 100757 | 40.463667 | -3.7492199999999998 | 2020-04-22 23:30:32 | Spain | |||
522480 | 522480 | 2020-04-21 | Spain | 204178 | 21282 | 82514 | 100382 | 40.463667 | -3.7492199999999998 | 2020-04-21 23:30:30 | Spain | |||
218279 | 218279 | 2022-12-26 | Spain | Catalonia | 2673415 | 20868 | 0 | 41.5912 | 1.5209 | 2022-12-27 04:21:07 | Catalonia, Spain | |||
328206 | 328206 | 2022-12-27 | Spain | Catalonia | 2673415 | 20868 | 0 | 41.5912 | 1.5209 | 2022-12-28 04:21:04 | Catalonia, Spain | |||
690673 | 690673 | 2022-12-23 | Spain | Catalonia | 2673415 | 20868 | 0 | 41.5912 | 1.5209 | 2022-12-24 04:21:02 | Catalonia, Spain | |||
1018650 | 1018650 | 2022-12-24 | Spain | Catalonia | 2673415 | 20868 | 0 | 41.5912 | 1.5209 | 2022-12-25 04:21:04 | Catalonia, Spain | |||
1074209 | 1074209 | 2022-12-28 | Spain | Catalonia | 2673415 | 20868 | 0 | 41.5912 | 1.5209 | 2022-12-29 04:21:01 | Catalonia, Spain | |||
2753203 | 2753203 | 2022-12-29 | Spain | Catalonia | 2673415 | 20868 | 0 | 41.5912 | 1.5209 | 2022-12-30 04:21:04 | Catalonia, Spain | |||
3222736 | 3222736 | 2022-12-25 | Spain | Catalonia | 2673415 | 20868 | 0 | 41.5912 | 1.5209 | 2022-12-26 04:21:06 | Catalonia, Spain | |||
2473562 | 2473562 | 2020-04-20 | Spain | 200210 | 20852 | 80587 | 98771 | 40.463667 | -3.7492199999999998 | 2020-04-20 23:36:27 | Spain | |||
451687 | 451687 | 2022-12-21 | Spain | Catalonia | 2670726 | 20831 | 0 | 41.5912 | 1.5209 | 2022-12-22 04:20:56 | Catalonia, Spain | |||
503984 | 503984 | 2022-12-17 | Spain | Catalonia | 2670726 | 20831 | 0 | 41.5912 | 1.5209 | 2022-12-18 04:21:03 | Catalonia, Spain | |||
1628605 | 1628605 | 2022-12-18 | Spain | Catalonia | 2670726 | 20831 | 0 | 41.5912 | 1.5209 | 2022-12-19 04:21:03 | Catalonia, Spain | |||
2179883 | 2179883 | 2022-12-22 | Spain | Catalonia | 2670726 | 20831 | 0 | 41.5912 | 1.5209 | 2022-12-23 04:21:04 | Catalonia, Spain | |||
2951686 | 2951686 | 2022-12-20 | Spain | Catalonia | 2670726 | 20831 | 0 | 41.5912 | 1.5209 | 2022-12-21 04:21:03 | Catalonia, Spain | |||
3174088 | 3174088 | 2022-12-19 | Spain | Catalonia | 2670726 | 20831 | 0 | 41.5912 | 1.5209 | 2022-12-20 04:21:04 | Catalonia, Spain | |||
3324556 | 3324556 | 2022-12-16 | Spain | Catalonia | 2670726 | 20831 | 0 | 41.5912 | 1.5209 | 2022-12-17 04:21:04 | Catalonia, Spain | |||
257629 | 257629 | 2022-12-10 | Spain | Catalonia | 2667772 | 20811 | 0 | 41.5912 | 1.5209 | 2022-12-11 04:20:50 | Catalonia, Spain | |||
308184 | 308184 | 2022-12-13 | Spain | Catalonia | 2667772 | 20811 | 0 | 41.5912 | 1.5209 | 2022-12-14 04:21:04 | Catalonia, Spain | |||
348596 | 348596 | 2022-12-14 | Spain | Catalonia | 2667772 | 20811 | 0 | 41.5912 | 1.5209 | 2022-12-15 04:20:58 | Catalonia, Spain | |||
543068 | 543068 | 2022-12-15 | Spain | Catalonia | 2667772 | 20811 | 0 | 41.5912 | 1.5209 | 2022-12-16 04:21:01 | Catalonia, Spain | |||
869099 | 869099 | 2022-12-11 | Spain | Catalonia | 2667772 | 20811 | 0 | 41.5912 | 1.5209 | 2022-12-12 04:21:01 | Catalonia, Spain | |||
1149245 | 1149245 | 2022-12-12 | Spain | Catalonia | 2667772 | 20811 | 0 | 41.5912 | 1.5209 | 2022-12-13 04:21:01 | Catalonia, Spain | |||
3936343 | 3936343 | 2022-12-09 | Spain | Catalonia | 2667772 | 20811 | 0 | 41.5912 | 1.5209 | 2022-12-10 04:21:02 | Catalonia, Spain | |||
718782 | 718782 | 2022-12-04 | Spain | Catalonia | 2664218 | 20782 | 0 | 41.5912 | 1.5209 | 2022-12-05 04:20:58 | Catalonia, Spain | |||
833927 | 833927 | 2022-12-02 | Spain | Catalonia | 2664218 | 20782 | 0 | 41.5912 | 1.5209 | 2022-12-03 04:21:02 | Catalonia, Spain | |||
1984946 | 1984946 | 2022-12-07 | Spain | Catalonia | 2664218 | 20782 | 0 | 41.5912 | 1.5209 | 2022-12-08 04:21:07 | Catalonia, Spain | |||
2415174 | 2415174 | 2022-12-05 | Spain | Catalonia | 2664218 | 20782 | 0 | 41.5912 | 1.5209 | 2022-12-06 04:21:03 | Catalonia, Spain | |||
2817071 | 2817071 | 2022-12-03 | Spain | Catalonia | 2664218 | 20782 | 0 | 41.5912 | 1.5209 | 2022-12-04 04:20:56 | Catalonia, Spain | |||
3377675 | 3377675 | 2022-12-08 | Spain | Catalonia | 2664218 | 20782 | 0 | 41.5912 | 1.5209 | 2022-12-09 04:21:05 | Catalonia, Spain | |||
3714469 | 3714469 | 2022-12-06 | Spain | Catalonia | 2664218 | 20782 | 0 | 41.5912 | 1.5209 | 2022-12-07 04:20:58 | Catalonia, Spain | |||
487920 | 487920 | 2022-11-25 | Spain | Catalonia | 2660038 | 20772 | 0 | 41.5912 | 1.5209 | 2022-11-26 04:21:11 | Catalonia, Spain | |||
1239961 | 1239961 | 2022-11-28 | Spain | Catalonia | 2660038 | 20772 | 0 | 41.5912 | 1.5209 | 2022-11-29 04:21:05 | Catalonia, Spain | |||
1964873 | 1964873 | 2022-11-30 | Spain | Catalonia | 2660038 | 20772 | 0 | 41.5912 | 1.5209 | 2022-12-01 04:21:03 | Catalonia, Spain | |||
2100429 | 2100429 | 2022-11-26 | Spain | Catalonia | 2660038 | 20772 | 0 | 41.5912 | 1.5209 | 2022-11-27 04:21:05 | Catalonia, Spain | |||
2136457 | 2136457 | 2022-12-01 | Spain | Catalonia | 2660038 | 20772 | 0 | 41.5912 | 1.5209 | 2022-12-02 04:21:07 | Catalonia, Spain | |||
2556887 | 2556887 | 2022-11-29 | Spain | Catalonia | 2660038 | 20772 | 0 | 41.5912 | 1.5209 | 2022-11-30 04:21:07 | Catalonia, Spain | |||
3551949 | 3551949 | 2022-11-27 | Spain | Catalonia | 2660038 | 20772 | 0 | 41.5912 | 1.5209 | 2022-11-28 04:21:02 | Catalonia, Spain | |||
1620573 | 1620573 | 2022-11-22 | Spain | Catalonia | 2655575 | 20683 | 0 | 41.5912 | 1.5209 | 2022-11-23 04:21:06 | Catalonia, Spain | |||
1640646 | 1640646 | 2022-11-20 | Spain | Catalonia | 2655575 | 20683 | 0 | 41.5912 | 1.5209 | 2022-11-21 04:21:05 | Catalonia, Spain | |||
1755597 | 1755597 | 2022-11-18 | Spain | Catalonia | 2655575 | 20683 | 0 | 41.5912 | 1.5209 | 2022-11-19 04:21:14 | Catalonia, Spain | |||
2064203 | 2064203 | 2022-11-19 | Spain | Catalonia | 2655575 | 20683 | 0 | 41.5912 | 1.5209 | 2022-11-20 04:21:08 | Catalonia, Spain | |||
3312532 | 3312532 | 2022-11-23 | Spain | Catalonia | 2655575 | 20683 | 0 | 41.5912 | 1.5209 | 2022-11-24 04:21:09 | Catalonia, Spain | |||
3460461 | 3460461 | 2022-11-21 | Spain | Catalonia | 2655575 | 20683 | 0 | 41.5912 | 1.5209 | 2022-11-22 04:20:47 | Catalonia, Spain | |||
3523749 | 3523749 | 2022-11-24 | Spain | Catalonia | 2655575 | 20683 | 0 | 41.5912 | 1.5209 | 2022-11-25 04:21:06 | Catalonia, Spain | |||
479890 | 479890 | 2022-11-08 | Spain | Catalonia | 2648073 | 20569 | 0 | 41.5912 | 1.5209 | 2022-11-09 04:21:22 | Catalonia, Spain | |||
618162 | 618162 | 2022-11-05 | Spain | Catalonia | 2648073 | 20569 | 0 | 41.5912 | 1.5209 | 2022-11-06 04:21:24 | Catalonia, Spain | |||
1022666 | 1022666 | 2022-11-04 | Spain | Catalonia | 2648073 | 20569 | 0 | 41.5912 | 1.5209 | 2022-11-05 04:21:52 | Catalonia, Spain | |||
1050138 | 1050138 | 2022-11-06 | Spain | Catalonia | 2648073 | 20569 | 0 | 41.5912 | 1.5209 | 2022-11-07 04:21:26 | Catalonia, Spain | |||
2431234 | 2431234 | 2022-11-09 | Spain | Catalonia | 2648073 | 20569 | 0 | 41.5912 | 1.5209 | 2022-11-10 04:21:16 | Catalonia, Spain | |||
2439040 | 2439040 | 2022-11-07 | Spain | Catalonia | 2648073 | 20569 | 0 | 41.5912 | 1.5209 | 2022-11-08 04:21:21 | Catalonia, Spain | |||
2506359 | 2506359 | 2022-11-10 | Spain | Catalonia | 2648073 | 20569 | 0 | 41.5912 | 1.5209 | 2022-11-11 04:21:22 | Catalonia, Spain | |||
2927523 | 2927523 | 2022-11-11 | Spain | Catalonia | 2648073 | 20569 | 0 | 41.5912 | 1.5209 | 2022-11-12 04:20:41 | Catalonia, Spain | |||
320232 | 320232 | 2022-10-30 | Spain | Catalonia | 2645423 | 20566 | 0 | 41.5912 | 1.5209 | 2022-10-31 04:21:36 | Catalonia, Spain | |||
431657 | 431657 | 2022-11-03 | Spain | Catalonia | 2645423 | 20566 | 0 | 41.5912 | 1.5209 | 2022-11-04 04:22:11 | Catalonia, Spain | |||
710750 | 710750 | 2022-11-01 | Spain | Catalonia | 2645423 | 20566 | 0 | 41.5912 | 1.5209 | 2022-11-02 04:22:09 | Catalonia, Spain | |||
849899 | 849899 | 2022-11-02 | Spain | Catalonia | 2645423 | 20566 | 0 | 41.5912 | 1.5209 | 2022-11-03 04:22:05 | Catalonia, Spain | |||
912508 | 912508 | 2022-10-29 | Spain | Catalonia | 2645423 | 20566 | 0 | 41.5912 | 1.5209 | 2022-10-30 04:22:14 | Catalonia, Spain | |||
1366777 | 1366777 | 2022-10-28 | Spain | Catalonia | 2645423 | 20566 | 0 | 41.5912 | 1.5209 | 2022-10-29 04:21:13 | Catalonia, Spain | |||
3285199 | 3285199 | 2022-10-31 | Spain | Catalonia | 2645423 | 20566 | 0 | 41.5912 | 1.5209 | 2022-11-01 04:22:36 | Catalonia, Spain | |||
539052 | 539052 | 2022-10-26 | Spain | Catalonia | 2642381 | 20557 | 0 | 41.5912 | 1.5209 | 2022-10-27 04:22:01 | Catalonia, Spain | |||
794714 | 794714 | 2022-10-24 | Spain | Catalonia | 2642381 | 20557 | 0 | 41.5912 | 1.5209 | 2022-10-25 04:21:53 | Catalonia, Spain | |||
1592507 | 1592507 | 2022-10-21 | Spain | Catalonia | 2642381 | 20557 | 0 | 41.5912 | 1.5209 | 2022-10-22 04:22:53 | Catalonia, Spain | |||
1830453 | 1830453 | 2022-10-25 | Spain | Catalonia | 2642381 | 20557 | 0 | 41.5912 | 1.5209 | 2022-10-26 04:22:19 | Catalonia, Spain | |||
2268207 | 2268207 | 2022-10-22 | Spain | Catalonia | 2642381 | 20557 | 0 | 41.5912 | 1.5209 | 2022-10-23 04:22:46 | Catalonia, Spain | |||
3038632 | 3038632 | 2022-10-27 | Spain | Catalonia | 2642381 | 20557 | 0 | 41.5912 | 1.5209 | 2022-10-28 04:22:31 | Catalonia, Spain | |||
3277169 | 3277169 | 2022-10-23 | Spain | Catalonia | 2642381 | 20557 | 0 | 41.5912 | 1.5209 | 2022-10-24 04:22:29 | Catalonia, Spain | |||
63361 | 63361 | 2022-11-12 | Spain | Catalonia | 2651464 | 20551 | 0 | 41.5912 | 1.5209 | 2022-11-13 04:21:14 | Catalonia, Spain | |||
292312 | 292312 | 2022-11-15 | Spain | Catalonia | 2651464 | 20551 | 0 | 41.5912 | 1.5209 | 2022-11-16 04:21:09 | Catalonia, Spain | |||
312200 | 312200 | 2022-11-13 | Spain | Catalonia | 2651464 | 20551 | 0 | 41.5912 | 1.5209 | 2022-11-14 04:21:09 | Catalonia, Spain | |||
2486301 | 2486301 | 2022-11-16 | Spain | Catalonia | 2651464 | 20551 | 0 | 41.5912 | 1.5209 | 2022-11-17 04:21:11 | Catalonia, Spain | |||
3026590 | 3026590 | 2022-11-17 | Spain | Catalonia | 2651464 | 20551 | 0 | 41.5912 | 1.5209 | 2022-11-18 04:21:15 | Catalonia, Spain | |||
3597342 | 3597342 | 2022-11-14 | Spain | Catalonia | 2651464 | 20551 | 0 | 41.5912 | 1.5209 | 2022-11-15 04:21:16 | Catalonia, Spain | |||
198558 | 198558 | 2022-10-19 | Spain | Catalonia | 2639242 | 20545 | 0 | 41.5912 | 1.5209 | 2022-10-20 04:22:59 | Catalonia, Spain | |||
516028 | 516028 | 2022-10-15 | Spain | Catalonia | 2639242 | 20545 | 0 | 41.5912 | 1.5209 | 2022-10-16 04:22:39 | Catalonia, Spain | |||
2025053 | 2025053 | 2022-10-17 | Spain | Catalonia | 2639242 | 20545 | 0 | 41.5912 | 1.5209 | 2022-10-18 04:22:42 | Catalonia, Spain | |||
2033085 | 2033085 | 2022-10-14 | Spain | Catalonia | 2639242 | 20545 | 0 | 41.5912 | 1.5209 | 2022-10-15 04:22:00 | Catalonia, Spain | |||
2159831 | 2159831 | 2022-10-16 | Spain | Catalonia | 2639242 | 20545 | 0 | 41.5912 | 1.5209 | 2022-10-17 04:20:31 | Catalonia, Spain | |||
2272223 | 2272223 | 2022-10-20 | Spain | Catalonia | 2639242 | 20545 | 0 | 41.5912 | 1.5209 | 2022-10-21 04:22:23 | Catalonia, 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]);