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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
268425 | 268425 | 2020-05-21 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-22 02:36:51 | Unknown, Spain | ||||
875705 | 875705 | 2020-05-24 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-25 02:32:44 | Unknown, Spain | ||||
997896 | 997896 | 2020-05-23 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-24 02:32:43 | Unknown, Spain | ||||
1105025 | 1105025 | 2020-05-25 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-26 02:32:35 | Unknown, Spain | ||||
1432008 | 1432008 | 2020-05-20 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-21 02:32:48 | Unknown, Spain | ||||
1864919 | 1864919 | 2020-05-22 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-23 02:32:42 | Unknown, Spain | ||||
2390122 | 2390122 | 2020-05-19 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-20 02:32:19 | Unknown, Spain | ||||
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 | |||
137578 | 137578 | 2020-04-29 | Spain | 236899 | 24275 | 132929 | 79695 | 40.463667 | -3.7492199999999998 | 2020-04-30 02:32:27 | 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 | |||
271792 | 271792 | 2020-04-28 | Spain | 232128 | 23822 | 123903 | 84403 | 40.463667 | -3.7492199999999998 | 2020-04-29 02:32:29 | 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 | |||
3589447 | 3589447 | 2020-04-27 | Spain | 229422 | 23521 | 120832 | 85069 | 40.463667 | -3.7492199999999998 | 2020-04-28 02:30:32 | Spain | |||
2278781 | 2278781 | 2020-05-03 | Spain | 217466 | 25264 | 118902 | 73300 | 40.463667 | -3.74922 | 2020-05-04 02:32:28 | Spain | |||
3592625 | 3592625 | 2020-04-26 | Spain | 226629 | 23190 | 117727 | 85712 | 40.463667 | -3.7492199999999998 | 2020-04-27 02:30:33 | 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 | |||
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 | |||
2473562 | 2473562 | 2020-04-20 | Spain | 200210 | 20852 | 80587 | 98771 | 40.463667 | -3.7492199999999998 | 2020-04-20 23:36:27 | Spain | |||
1385254 | 1385254 | 2020-04-19 | Spain | 198674 | 20453 | 77357 | 100864 | 40.463667 | -3.74922 | 2020-04-19 23:40:41 | Spain | |||
50414 | 50414 | 2020-04-17 | Spain | 190839 | 20002 | 74797 | 96040 | 40.463667 | -3.7492199999999998 | 2020-04-17 23:30:32 | Spain | |||
418942 | 418942 | 2020-04-18 | Spain | 191726 | 20043 | 74797 | 96886 | 40.463667 | -3.74922 | 2020-04-18 22:32:28 | Spain | |||
934408 | 934408 | 2020-04-16 | Spain | 184948 | 19315 | 74797 | 90836 | 40.463667 | -3.7492199999999998 | 2020-04-16 23:30:31 | Spain | |||
860302 | 860302 | 2020-04-15 | Spain | 177644 | 18708 | 70853 | 88083 | 40.463667 | -3.7492199999999998 | 2020-04-15 22:56:32 | Spain | |||
3338218 | 3338218 | 2020-04-14 | Spain | 172541 | 18056 | 67504 | 86981 | 40.463667 | -3.7492199999999998 | 2020-04-14 23:33:12 | Spain | |||
43315 | 43315 | 2020-04-13 | Spain | 170099 | 17756 | 64727 | 87616 | 40.463667 | -3.7492199999999998 | 2020-04-13 23:07:34 | Spain | |||
2578341 | 2578341 | 2020-04-12 | Spain | 166831 | 17209 | 62391 | 87231 | 40.463667 | -3.74922 | 2020-04-12 23:17:00 | Spain | |||
2567178 | 2567178 | 2020-04-11 | Spain | 163027 | 16606 | 59109 | 87312 | 40.463667 | -3.7492199999999998 | 2020-04-11 22:45:13 | Spain | |||
1250363 | 1250363 | 2020-04-10 | Spain | 158273 | 16081 | 55668 | 86524 | 40.463667 | -3.7492199999999998 | 2020-04-10 22:53:48 | Spain | |||
3950100 | 3950100 | 2020-04-09 | Spain | 153222 | 15447 | 52165 | 85610 | 40.463667 | -3.7492199999999998 | 2020-04-09 23:02:19 | Spain | |||
3562207 | 3562207 | 2020-04-08 | Spain | 148220 | 14792 | 48021 | 85407 | 40.463667 | -3.7492199999999998 | 2020-04-08 22:51:39 | Spain | |||
3021882 | 3021882 | 2020-04-07 | Spain | 141942 | 14045 | 43208 | 84689 | 40.463667 | -3.7492199999999998 | 2020-04-07 23:04:29 | Spain | |||
8626 | 8626 | 2020-10-25 | Spain | Madrid | 292754 | 10211 | 40736 | 241807 | 40.4168 | -3.7038 | 2020-10-26 04:25:02 | Madrid, Spain | ||
12637 | 12637 | 2021-01-26 | Spain | Madrid | 498502 | 12425 | 40736 | 445341 | 40.4168 | -3.7038 | 2021-01-27 05:23:41 | Madrid, Spain | ||
20668 | 20668 | 2021-05-28 | Spain | Madrid | 714616 | 15285 | 40736 | 658595 | 40.4168 | -3.7038 | 2021-05-29 04:20:41 | Madrid, Spain | ||
36727 | 36727 | 2021-04-12 | Spain | Madrid | 644587 | 14705 | 40736 | 589146 | 40.4168 | -3.7038 | 2021-04-13 04:20:37 | Madrid, Spain | ||
51089 | 51089 | 2021-05-29 | Spain | Madrid | 714616 | 15285 | 40736 | 658595 | 40.4168 | -3.7038 | 2021-05-30 04:20:55 | Madrid, Spain | ||
55102 | 55102 | 2021-03-07 | Spain | Madrid | 593398 | 14104 | 40736 | 538558 | 40.4168 | -3.7038 | 2021-03-08 05:24:48 | Madrid, Spain | ||
61985 | 61985 | 2020-07-23 | Spain | Madrid | 73767 | 8450 | 40736 | 24581 | 40.4168 | -3.7038 | 2020-07-24 05:30:40 | Madrid, Spain | ||
75385 | 75385 | 2020-12-03 | Spain | Madrid | 353011 | 11413 | 40736 | 300862 | 40.4168 | -3.7038 | 2020-12-04 05:27:27 | Madrid, Spain | ||
79382 | 79382 | 2020-10-14 | Spain | Madrid | 270745 | 9837 | 40736 | 220172 | 40.4168 | -3.7038 | 2020-10-15 04:24:28 | Madrid, Spain | ||
83392 | 83392 | 2021-05-25 | Spain | Madrid | 711411 | 15243 | 40736 | 655432 | 40.4168 | -3.7038 | 2021-05-26 04:20:35 | Madrid, Spain | ||
98330 | 98330 | 2020-08-04 | Spain | Madrid | 77918 | 8457 | 40736 | 28725 | 40.4168 | -3.7038 | 2020-08-05 04:34:43 | Madrid, Spain | ||
107751 | 107751 | 2021-06-19 | Spain | Madrid | 726171 | 15402 | 40736 | 670033 | 40.4168 | -3.7038 | 2021-06-20 04:21:48 | Madrid, Spain | ||
121922 | 121922 | 2020-07-19 | Spain | Madrid | 73026 | 8446 | 40736 | 23844 | 40.4168 | -3.7038 | 2020-07-20 05:34:40 | Madrid, Spain | ||
123000 | 123000 | 2020-11-18 | Spain | Madrid | 336384 | 11158 | 40736 | 284490 | 40.4168 | -3.7038 | 2020-11-19 05:25:23 | Madrid, Spain | ||
146265 | 146265 | 2020-08-15 | Spain | Madrid | 87967 | 8481 | 40736 | 38750 | 40.4168 | -3.7038 | 2020-08-16 04:27:42 | Madrid, Spain | ||
154279 | 154279 | 2021-01-08 | Spain | Madrid | 421295 | 11971 | 40736 | 368588 | 40.4168 | -3.7038 | 2021-01-09 05:22:18 | Madrid, Spain | ||
170341 | 170341 | 2021-04-16 | Spain | Madrid | 654322 | 14803 | 40736 | 598783 | 40.4168 | -3.7038 | 2021-04-17 04:20:40 | Madrid, Spain | ||
177240 | 177240 | 2020-07-27 | Spain | Madrid | 74700 | 8451 | 40736 | 25513 | 40.4168 | -3.7038 | 2020-07-28 04:58:43 | Madrid, Spain | ||
182337 | 182337 | 2021-02-21 | Spain | Madrid | 573169 | 13538 | 40736 | 518895 | 40.4168 | -3.7038 | 2021-02-22 05:24:21 | Madrid, Spain | ||
190365 | 190365 | 2021-01-11 | Spain | Madrid | 429181 | 11996 | 40736 | 376449 | 40.4168 | -3.7038 | 2021-01-12 05:22:15 | Madrid, Spain | ||
194360 | 194360 | 2020-08-31 | Spain | Madrid | 126057 | 8648 | 40736 | 76673 | 40.4168 | -3.7038 | 2020-09-01 04:28:31 | Madrid, Spain | ||
202552 | 202552 | 2020-12-25 | Spain | Madrid | 385625 | 11687 | 40736 | 333202 | 40.4168 | -3.7038 | 2020-12-26 05:22:28 | Madrid, Spain | ||
206547 | 206547 | 2020-08-19 | Spain | Madrid | 97185 | 8518 | 40736 | 47931 | 40.4168 | -3.7038 | 2020-08-20 04:27:43 | Madrid, Spain | ||
210535 | 210535 | 2020-10-29 | Spain | Madrid | 303945 | 10403 | 40736 | 252806 | 40.4168 | -3.7038 | 2020-10-30 04:24:49 | Madrid, Spain | ||
217204 | 217204 | 2020-06-08 | Spain | Madrid | 69695 | 8691 | 40736 | 20268 | 40.4168 | -3.7038 | 2020-06-09 03:33:03 | Madrid, Spain | ||
237537 | 237537 | 2021-01-18 | Spain | Madrid | 458212 | 12054 | 40736 | 405422 | 40.4168 | -3.7038 | 2021-01-19 05:22:15 | Madrid, Spain | ||
241552 | 241552 | 2021-04-02 | Spain | Madrid | 627742 | 14578 | 40736 | 572428 | 40.4168 | -3.7038 | 2021-04-03 04:20:44 | Madrid, Spain | ||
272450 | 272450 | 2020-11-10 | Spain | Madrid | 322960 | 10850 | 40736 | 271374 | 40.4168 | -3.7038 | 2020-11-11 05:25:30 | Madrid, Spain | ||
280480 | 280480 | 2021-02-24 | Spain | Madrid | 580443 | 13713 | 40736 | 525994 | 40.4168 | -3.7038 | 2021-02-25 05:24:57 | Madrid, Spain | ||
287205 | 287205 | 2020-06-15 | Spain | Madrid | 70570 | 8691 | 40736 | 21143 | 40.4168 | -3.7038 | 2020-06-16 04:33:09 | Madrid, Spain | ||
296312 | 296312 | 2021-07-15 | Spain | Madrid | 757649 | 15494 | 40736 | 701419 | 40.4168 | -3.7038 | 2021-07-16 04:21:22 | Madrid, Spain | ||
303077 | 303077 | 2020-07-01 | Spain | Madrid | 72033 | 8427 | 40736 | 22870 | 40.4168 | -3.7038 | 2020-07-02 04:33:46 | Madrid, Spain | ||
327017 | 327017 | 2020-07-20 | Spain | Madrid | 73296 | 8447 | 40736 | 24113 | 40.4168 | -3.7038 | 2020-07-21 04:38:46 | Madrid, Spain | ||
332206 | 332206 | 2021-08-04 | Spain | Madrid | 830399 | 15563 | 40736 | 774100 | 40.4168 | -3.7038 | 2021-08-05 04:21:51 | Madrid, Spain | ||
340572 | 340572 | 2021-02-03 | Spain | Madrid | 533074 | 12741 | 40736 | 479597 | 40.4168 | -3.7038 | 2021-02-04 05:22:26 | Madrid, Spain | ||
344568 | 344568 | 2020-09-14 | Spain | Madrid | 171085 | 8843 | 40736 | 121506 | 40.4168 | -3.7038 | 2020-09-15 03:22:50 | Madrid, Spain | ||
352593 | 352593 | 2021-03-11 | Spain | Madrid | 600316 | 14278 | 40736 | 545302 | 40.4168 | -3.7038 | 2021-03-12 05:26:50 | Madrid, Spain | ||
367425 | 367425 | 2020-07-16 | Spain | Madrid | 72882 | 8445 | 40736 | 23701 | 40.4168 | -3.7038 | 2020-07-17 04:34:50 | Madrid, Spain | ||
371395 | 371395 | 2020-08-08 | Spain | Madrid | 80673 | 8458 | 40736 | 31479 | 40.4168 | -3.7038 | 2020-08-09 04:34:54 | Madrid, Spain | ||
376477 | 376477 | 2020-11-06 | Spain | Madrid | 319651 | 10842 | 40736 | 268073 | 40.4168 | -3.7038 | 2020-11-07 05:24:52 | Madrid, Spain | ||
380490 | 380490 | 2021-04-30 | Spain | Madrid | 682556 | 14994 | 40736 | 626826 | 40.4168 | -3.7038 | 2021-05-01 04:20:47 | Madrid, Spain | ||
388520 | 388520 | 2021-04-04 | Spain | Madrid | 629080 | 14579 | 40736 | 573765 | 40.4168 | -3.7038 | 2021-04-05 04:20:35 | Madrid, Spain | ||
392531 | 392531 | 2020-11-27 | Spain | Madrid | 346850 | 11352 | 40736 | 294762 | 40.4168 | -3.7038 | 2020-11-28 05:25:50 | Madrid, Spain | ||
400564 | 400564 | 2021-06-29 | Spain | Madrid | 731035 | 15440 | 40736 | 674859 | 40.4168 | -3.7038 | 2021-06-30 04:21:41 | Madrid, Spain | ||
408594 | 408594 | 2021-07-28 | Spain | Madrid | 805674 | 15520 | 40736 | 749418 | 40.4168 | -3.7038 | 2021-07-29 04:21:33 | Madrid, Spain | ||
415369 | 415369 | 2020-07-05 | Spain | Madrid | 72168 | 8439 | 40736 | 22993 | 40.4168 | -3.7038 | 2020-07-06 04:33:57 | Madrid, Spain | ||
427629 | 427629 | 2020-09-07 | Spain | Madrid | 146341 | 8748 | 40736 | 96857 | 40.4168 | -3.7038 | 2020-09-08 04:28:25 | Madrid, Spain | ||
435653 | 435653 | 2021-01-21 | Spain | Madrid | 477031 | 12210 | 40736 | 424085 | 40.4168 | -3.7038 | 2021-01-22 05:22:10 | Madrid, Spain | ||
442553 | 442553 | 2020-07-26 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-27 04:35:02 | Madrid, Spain | ||
458579 | 458579 | 2020-08-07 | Spain | Madrid | 80673 | 8458 | 40736 | 31479 | 40.4168 | -3.7038 | 2020-08-08 04:34:53 | Madrid, Spain | ||
471709 | 471709 | 2021-02-19 | Spain | Madrid | 573169 | 13538 | 40736 | 518895 | 40.4168 | -3.7038 | 2021-02-20 05:22:51 | Madrid, Spain | ||
483890 | 483890 | 2021-07-19 | Spain | Madrid | 768874 | 15501 | 40736 | 712637 | 40.4168 | -3.7038 | 2021-07-20 04:21:48 | Madrid, Spain | ||
523155 | 523155 | 2021-06-09 | Spain | Madrid | 722100 | 15373 | 40736 | 665991 | 40.4168 | -3.7038 | 2021-06-10 04:23:17 | Madrid, Spain | ||
529931 | 529931 | 2020-07-04 | Spain | Madrid | 72168 | 8439 | 40736 | 22993 | 40.4168 | -3.7038 | 2020-07-05 04:33:46 | Madrid, Spain | ||
531003 | 531003 | 2021-02-22 | Spain | Madrid | 576700 | 13631 | 40736 | 522333 | 40.4168 | -3.7038 | 2021-02-23 05:23:41 | Madrid, Spain | ||
547046 | 547046 | 2020-09-12 | Spain | Madrid | 160221 | 8818 | 40736 | 110667 | 40.4168 | -3.7038 | 2020-09-13 04:30:52 | Madrid, 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]);