johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Spain" and province_or_state = "Andalusia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
- Andalusia · 403 ✖
country_or_region 1
- Spain · 403 ✖
combined_key 1 ✖
- Andalusia, Spain 403
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884654 | 2884654 | 2021-06-20 | Spain | Andalusia | 606879 | 10009 | 10671 | 586199 | 37.5443 | -4.7278 | 2021-06-21 04:21:41 | Andalusia, Spain | ||
107737 | 107737 | 2021-06-19 | Spain | Andalusia | 606879 | 10009 | 10671 | 586199 | 37.5443 | -4.7278 | 2021-06-20 04:21:48 | Andalusia, Spain | ||
1125880 | 1125880 | 2021-06-18 | Spain | Andalusia | 606879 | 10009 | 10671 | 586199 | 37.5443 | -4.7278 | 2021-06-19 04:22:33 | Andalusia, Spain | ||
2911458 | 2911458 | 2021-06-17 | Spain | Andalusia | 605431 | 10008 | 10671 | 584752 | 37.5443 | -4.7278 | 2021-06-18 04:22:16 | Andalusia, Spain | ||
3030574 | 3030574 | 2021-06-16 | Spain | Andalusia | 603988 | 10000 | 10671 | 583317 | 37.5443 | -4.7278 | 2021-06-17 04:22:36 | Andalusia, Spain | ||
2339680 | 2339680 | 2021-06-15 | Spain | Andalusia | 602955 | 9999 | 10671 | 582285 | 37.5443 | -4.7278 | 2021-06-16 04:22:32 | Andalusia, Spain | ||
1564376 | 1564376 | 2021-06-14 | Spain | Andalusia | 601677 | 9981 | 10671 | 581025 | 37.5443 | -4.7278 | 2021-06-15 04:22:22 | Andalusia, Spain | ||
3381659 | 3381659 | 2021-06-13 | Spain | Andalusia | 598947 | 9975 | 10671 | 578301 | 37.5443 | -4.7278 | 2021-06-14 04:22:46 | Andalusia, Spain | ||
1736793 | 1736793 | 2021-06-12 | Spain | Andalusia | 598947 | 9975 | 10671 | 578301 | 37.5443 | -4.7278 | 2021-06-13 04:22:44 | Andalusia, Spain | ||
3970834 | 3970834 | 2021-06-11 | Spain | Andalusia | 598947 | 9975 | 10671 | 578301 | 37.5443 | -4.7278 | 2021-06-12 04:22:22 | Andalusia, Spain | ||
2717256 | 2717256 | 2021-06-10 | Spain | Andalusia | 597465 | 9967 | 10671 | 576827 | 37.5443 | -4.7278 | 2021-06-11 04:23:20 | Andalusia, Spain | ||
523141 | 523141 | 2021-06-09 | Spain | Andalusia | 595838 | 9950 | 10671 | 575217 | 37.5443 | -4.7278 | 2021-06-10 04:23:17 | Andalusia, Spain | ||
3472581 | 3472581 | 2021-06-08 | Spain | Andalusia | 594650 | 9947 | 10671 | 574032 | 37.5443 | -4.7278 | 2021-06-09 04:23:31 | Andalusia, Spain | ||
3145865 | 3145865 | 2021-06-07 | Spain | Andalusia | 593602 | 9934 | 10671 | 572997 | 37.5443 | -4.7278 | 2021-06-08 04:22:35 | Andalusia, Spain | ||
825867 | 825867 | 2021-06-06 | Spain | Andalusia | 590684 | 9928 | 10671 | 570085 | 37.5443 | -4.7278 | 2021-06-07 04:22:51 | Andalusia, Spain | ||
2586272 | 2586272 | 2021-06-05 | Spain | Andalusia | 590684 | 9928 | 10671 | 570085 | 37.5443 | -4.7278 | 2021-06-06 04:24:03 | Andalusia, Spain | ||
2315586 | 2315586 | 2021-06-04 | Spain | Andalusia | 590684 | 9928 | 10671 | 570085 | 37.5443 | -4.7278 | 2021-06-05 04:23:03 | Andalusia, Spain | ||
1448871 | 1448871 | 2021-06-03 | Spain | Andalusia | 589198 | 9918 | 10671 | 568609 | 37.5443 | -4.7278 | 2021-06-04 04:23:37 | Andalusia, Spain | ||
1708595 | 1708595 | 2021-06-02 | Spain | Andalusia | 587551 | 9918 | 10671 | 566962 | 37.5443 | -4.7278 | 2021-06-03 04:23:32 | Andalusia, Spain | ||
2104413 | 2104413 | 2021-06-01 | Spain | Andalusia | 586178 | 9900 | 10671 | 565607 | 37.5443 | -4.7278 | 2021-06-02 04:24:34 | Andalusia, Spain | ||
1189029 | 1189029 | 2021-05-31 | Spain | Andalusia | 584878 | 9887 | 10671 | 564320 | 37.5443 | -4.7278 | 2021-06-01 04:23:09 | Andalusia, Spain | ||
3089706 | 3089706 | 2021-05-30 | Spain | Andalusia | 581880 | 9880 | 10671 | 561329 | 37.5443 | -4.7278 | 2021-05-31 03:08:59 | Andalusia, Spain | ||
51075 | 51075 | 2021-05-29 | Spain | Andalusia | 581880 | 9880 | 10671 | 561329 | 37.5443 | -4.7278 | 2021-05-30 04:20:55 | Andalusia, Spain | ||
20654 | 20654 | 2021-05-28 | Spain | Andalusia | 581880 | 9880 | 10671 | 561329 | 37.5443 | -4.7278 | 2021-05-29 04:20:41 | Andalusia, Spain | ||
1807029 | 1807029 | 2021-05-27 | Spain | Andalusia | 580383 | 9877 | 10671 | 559835 | 37.5443 | -4.7278 | 2021-05-28 04:20:36 | Andalusia, Spain | ||
1310452 | 1310452 | 2021-05-26 | Spain | Andalusia | 578909 | 9875 | 10671 | 558363 | 37.5443 | -4.7278 | 2021-05-27 04:20:59 | Andalusia, Spain | ||
83378 | 83378 | 2021-05-25 | Spain | Andalusia | 577638 | 9867 | 10671 | 557100 | 37.5443 | -4.7278 | 2021-05-26 04:20:35 | Andalusia, Spain | ||
1413340 | 1413340 | 2021-05-24 | Spain | Andalusia | 576718 | 9866 | 10671 | 556181 | 37.5443 | -4.7278 | 2021-05-25 04:21:08 | Andalusia, Spain | ||
1771626 | 1771626 | 2021-05-23 | Spain | Andalusia | 574048 | 9856 | 10671 | 553521 | 37.5443 | -4.7278 | 2021-05-24 04:20:53 | Andalusia, Spain | ||
726781 | 726781 | 2021-05-22 | Spain | Andalusia | 574048 | 9856 | 10671 | 553521 | 37.5443 | -4.7278 | 2021-05-23 04:20:51 | Andalusia, Spain | ||
1952796 | 1952796 | 2021-05-21 | Spain | Andalusia | 574048 | 9856 | 10671 | 553521 | 37.5443 | -4.7278 | 2021-05-22 04:20:45 | Andalusia, Spain | ||
1913495 | 1913495 | 2021-05-20 | Spain | Andalusia | 572825 | 9853 | 10671 | 552301 | 37.5443 | -4.7278 | 2021-05-21 04:20:43 | Andalusia, Spain | ||
2256016 | 2256016 | 2021-05-19 | Spain | Andalusia | 571401 | 9840 | 10671 | 550890 | 37.5443 | -4.7278 | 2021-05-20 04:21:05 | Andalusia, Spain | ||
2391054 | 2391054 | 2021-05-18 | Spain | Andalusia | 570363 | 9825 | 10671 | 549867 | 37.5443 | -4.7278 | 2021-05-19 04:20:42 | Andalusia, Spain | ||
3574879 | 3574879 | 2021-05-17 | Spain | Andalusia | 569401 | 9808 | 10671 | 548922 | 37.5443 | -4.7278 | 2021-05-18 04:20:33 | Andalusia, Spain | ||
2939609 | 2939609 | 2021-05-16 | Spain | Andalusia | 566808 | 9797 | 10671 | 546340 | 37.5443 | -4.7278 | 2021-05-17 04:20:34 | Andalusia, Spain | ||
1873239 | 1873239 | 2021-05-15 | Spain | Andalusia | 566808 | 9797 | 10671 | 546340 | 37.5443 | -4.7278 | 2021-05-16 04:20:49 | Andalusia, Spain | ||
1082208 | 1082208 | 2021-05-14 | Spain | Andalusia | 566808 | 9797 | 10671 | 546340 | 37.5443 | -4.7278 | 2021-05-15 04:20:58 | Andalusia, Spain | ||
3054474 | 3054474 | 2021-05-13 | Spain | Andalusia | 565201 | 9787 | 10671 | 544743 | 37.5443 | -4.7278 | 2021-05-14 04:20:41 | Andalusia, Spain | ||
2004944 | 2004944 | 2021-05-12 | Spain | Andalusia | 563882 | 9778 | 10671 | 543433 | 37.5443 | -4.7278 | 2021-05-13 04:20:51 | Andalusia, Spain | ||
3954775 | 3954775 | 2021-05-11 | Spain | Andalusia | 562593 | 9760 | 10671 | 542162 | 37.5443 | -4.7278 | 2021-05-12 04:21:29 | Andalusia, Spain | ||
2821054 | 2821054 | 2021-05-10 | Spain | Andalusia | 561585 | 9708 | 10671 | 541206 | 37.5443 | -4.7278 | 2021-05-11 04:20:41 | Andalusia, Spain | ||
1425386 | 1425386 | 2021-05-09 | Spain | Andalusia | 558932 | 9700 | 10671 | 538561 | 37.5443 | -4.7278 | 2021-05-10 04:20:38 | Andalusia, Spain | ||
1552254 | 1552254 | 2021-05-08 | Spain | Andalusia | 558932 | 9700 | 10671 | 538561 | 37.5443 | -4.7278 | 2021-05-09 04:20:35 | Andalusia, Spain | ||
2502312 | 2502312 | 2021-05-07 | Spain | Andalusia | 558932 | 9700 | 10671 | 538561 | 37.5443 | -4.7278 | 2021-05-08 04:21:04 | Andalusia, Spain | ||
3113768 | 3113768 | 2021-05-06 | Spain | Andalusia | 557408 | 9689 | 10671 | 537048 | 37.5443 | -4.7278 | 2021-05-07 04:20:40 | Andalusia, Spain | ||
646235 | 646235 | 2021-05-05 | Spain | Andalusia | 556194 | 9681 | 10671 | 535842 | 37.5443 | -4.7278 | 2021-05-06 04:20:38 | Andalusia, Spain | ||
3675935 | 3675935 | 2021-05-04 | Spain | Andalusia | 554961 | 9666 | 10671 | 534624 | 37.5443 | -4.7278 | 2021-05-05 04:20:43 | Andalusia, Spain | ||
2761202 | 2761202 | 2021-05-03 | Spain | Andalusia | 553953 | 9634 | 10671 | 533648 | 37.5443 | -4.7278 | 2021-05-04 04:20:34 | Andalusia, Spain | ||
2451055 | 2451055 | 2021-05-02 | Spain | Andalusia | 551106 | 9628 | 10671 | 530807 | 37.5443 | -4.7278 | 2021-05-03 04:20:39 | Andalusia, Spain | ||
2825068 | 2825068 | 2021-05-01 | Spain | Andalusia | 551106 | 9628 | 10671 | 530807 | 37.5443 | -4.7278 | 2021-05-02 04:20:48 | Andalusia, Spain | ||
380476 | 380476 | 2021-04-30 | Spain | Andalusia | 551106 | 9628 | 10671 | 530807 | 37.5443 | -4.7278 | 2021-05-01 04:20:47 | Andalusia, Spain | ||
1636599 | 1636599 | 2021-04-29 | Spain | Andalusia | 549722 | 9617 | 10671 | 529434 | 37.5443 | -4.7278 | 2021-04-30 04:21:03 | Andalusia, Spain | ||
3393678 | 3393678 | 2021-04-28 | Spain | Andalusia | 548238 | 9612 | 10671 | 527955 | 37.5443 | -4.7278 | 2021-04-29 04:20:55 | Andalusia, Spain | ||
3702394 | 3702394 | 2021-04-27 | Spain | Andalusia | 546943 | 9584 | 10671 | 526688 | 37.5443 | -4.7278 | 2021-04-28 04:20:32 | Andalusia, Spain | ||
888403 | 888403 | 2021-04-26 | Spain | Andalusia | 545483 | 9564 | 10671 | 525248 | 37.5443 | -4.7278 | 2021-04-27 04:20:52 | Andalusia, Spain | ||
955148 | 955148 | 2021-04-25 | Spain | Andalusia | 541843 | 9528 | 10671 | 521644 | 37.5443 | -4.7278 | 2021-04-26 04:21:04 | Andalusia, Spain | ||
3924295 | 3924295 | 2021-04-24 | Spain | Andalusia | 541843 | 9528 | 10671 | 521644 | 37.5443 | -4.7278 | 2021-04-25 04:20:32 | Andalusia, Spain | ||
1409326 | 1409326 | 2021-04-23 | Spain | Andalusia | 541843 | 9528 | 10671 | 521644 | 37.5443 | -4.7278 | 2021-04-24 04:20:38 | Andalusia, Spain | ||
1568389 | 1568389 | 2021-04-22 | Spain | Andalusia | 539780 | 9495 | 10671 | 519614 | 37.5443 | -4.7278 | 2021-04-23 04:20:52 | Andalusia, Spain | ||
3242610 | 3242610 | 2021-04-21 | Spain | Andalusia | 537908 | 9479 | 10671 | 517758 | 37.5443 | -4.7278 | 2021-04-22 04:20:53 | Andalusia, Spain | ||
2021006 | 2021006 | 2021-04-20 | Spain | Andalusia | 534597 | 9432 | 10671 | 514494 | 37.5443 | -4.7278 | 2021-04-21 04:21:14 | Andalusia, Spain | ||
2411127 | 2411127 | 2021-04-19 | Spain | Andalusia | 534597 | 9432 | 10671 | 514494 | 37.5443 | -4.7278 | 2021-04-20 04:20:41 | Andalusia, Spain | ||
3129804 | 3129804 | 2021-04-18 | Spain | Andalusia | 530392 | 9415 | 10671 | 510306 | 37.5443 | -4.7278 | 2021-04-19 04:20:57 | Andalusia, Spain | ||
983232 | 983232 | 2021-04-17 | Spain | Andalusia | 530392 | 9415 | 10671 | 510306 | 37.5443 | -4.7278 | 2021-04-18 04:20:41 | Andalusia, Spain | ||
170327 | 170327 | 2021-04-16 | Spain | Andalusia | 530392 | 9415 | 10671 | 510306 | 37.5443 | -4.7278 | 2021-04-17 04:20:40 | Andalusia, Spain | ||
2549158 | 2549158 | 2021-04-15 | Spain | Andalusia | 527997 | 9393 | 10671 | 507933 | 37.5443 | -4.7278 | 2021-04-16 04:20:46 | Andalusia, Spain | ||
1842228 | 1842228 | 2021-04-14 | Spain | Andalusia | 526143 | 9379 | 10671 | 506093 | 37.5443 | -4.7278 | 2021-04-15 04:20:54 | Andalusia, Spain | ||
2571962 | 2571962 | 2021-04-13 | Spain | Andalusia | 523865 | 9362 | 10671 | 503832 | 37.5443 | -4.7278 | 2021-04-14 04:20:41 | Andalusia, Spain | ||
36713 | 36713 | 2021-04-12 | Spain | Andalusia | 523865 | 9362 | 10671 | 503832 | 37.5443 | -4.7278 | 2021-04-13 04:20:37 | Andalusia, Spain | ||
3883872 | 3883872 | 2021-04-11 | Spain | Andalusia | 518285 | 9347 | 10671 | 498267 | 37.5443 | -4.7278 | 2021-04-12 04:21:00 | Andalusia, Spain | ||
2983540 | 2983540 | 2021-04-10 | Spain | Andalusia | 518285 | 9347 | 10671 | 498267 | 37.5443 | -4.7278 | 2021-04-11 04:20:56 | Andalusia, Spain | ||
605972 | 605972 | 2021-04-09 | Spain | Andalusia | 518285 | 9347 | 10671 | 498267 | 37.5443 | -4.7278 | 2021-04-10 04:20:59 | Andalusia, Spain | ||
2646036 | 2646036 | 2021-04-08 | Spain | Andalusia | 516112 | 9332 | 10671 | 496109 | 37.5443 | -4.7278 | 2021-04-09 04:21:13 | Andalusia, Spain | ||
2247678 | 2247678 | 2021-04-07 | Spain | Andalusia | 513619 | 9315 | 10671 | 493633 | 37.5443 | -4.7278 | 2021-04-08 04:21:13 | Andalusia, Spain | ||
3003588 | 3003588 | 2021-04-06 | Spain | Andalusia | 511920 | 9276 | 10671 | 491973 | 37.5443 | -4.7278 | 2021-04-07 04:20:53 | Andalusia, Spain | ||
3085583 | 3085583 | 2021-04-05 | Spain | Andalusia | 510909 | 9241 | 10671 | 490997 | 37.5443 | -4.7278 | 2021-04-06 04:20:32 | Andalusia, Spain | ||
388506 | 388506 | 2021-04-04 | Spain | Andalusia | 508174 | 9214 | 10671 | 488289 | 37.5443 | -4.7278 | 2021-04-05 04:20:35 | Andalusia, Spain | ||
3710422 | 3710422 | 2021-04-03 | Spain | Andalusia | 508174 | 9214 | 10671 | 488289 | 37.5443 | -4.7278 | 2021-04-04 04:20:49 | Andalusia, Spain | ||
241538 | 241538 | 2021-04-02 | Spain | Andalusia | 505796 | 9206 | 10671 | 485919 | 37.5443 | -4.7278 | 2021-04-03 04:20:44 | Andalusia, Spain | ||
1302335 | 1302335 | 2021-04-01 | Spain | Andalusia | 505796 | 9206 | 10671 | 485919 | 37.5443 | -4.7278 | 2021-04-02 04:20:36 | Andalusia, Spain | ||
638207 | 638207 | 2021-03-31 | Spain | Andalusia | 505796 | 9206 | 10671 | 485919 | 37.5443 | -4.7278 | 2021-04-01 04:27:05 | Andalusia, Spain | ||
3643836 | 3643836 | 2021-03-30 | Spain | Andalusia | 504001 | 9193 | 10671 | 484137 | 37.5443 | -4.7278 | 2021-03-31 04:26:25 | Andalusia, Spain | ||
1290289 | 1290289 | 2021-03-29 | Spain | Andalusia | 503853 | 9176 | 10671 | 484006 | 37.5443 | -4.7278 | 2021-03-30 04:26:23 | Andalusia, Spain | ||
1536211 | 1536211 | 2021-03-28 | Spain | Andalusia | 501013 | 9147 | 10671 | 481195 | 37.5443 | -4.7278 | 2021-03-29 04:28:35 | Andalusia, Spain | ||
1219851 | 1219851 | 2021-03-27 | Spain | Andalusia | 501013 | 9147 | 10671 | 481195 | 37.5443 | -4.7278 | 2021-03-28 05:28:10 | Andalusia, Spain | ||
1881269 | 1881269 | 2021-03-26 | Spain | Andalusia | 501013 | 9147 | 10671 | 481195 | 37.5443 | -4.7278 | 2021-03-27 05:25:04 | Andalusia, Spain | ||
1980899 | 1980899 | 2021-03-25 | Spain | Andalusia | 499710 | 9136 | 10671 | 479903 | 37.5443 | -4.7278 | 2021-03-26 05:26:55 | Andalusia, Spain | ||
2781277 | 2781277 | 2021-03-24 | Spain | Andalusia | 497531 | 9093 | 10671 | 477767 | 37.5443 | -4.7278 | 2021-03-25 05:27:00 | Andalusia, Spain | ||
1798922 | 1798922 | 2021-03-23 | Spain | Andalusia | 497531 | 9093 | 10671 | 477767 | 37.5443 | -4.7278 | 2021-03-24 05:25:40 | Andalusia, Spain | ||
1204090 | 1204090 | 2021-03-22 | Spain | Andalusia | 496864 | 9060 | 10671 | 477133 | 37.5443 | -4.7278 | 2021-03-23 05:26:18 | Andalusia, Spain | ||
3369612 | 3369612 | 2021-03-21 | Spain | Andalusia | 493578 | 8988 | 10671 | 473919 | 37.5443 | -4.7278 | 2021-03-22 05:25:43 | Andalusia, Spain | ||
1744822 | 1744822 | 2021-03-20 | Spain | Andalusia | 493578 | 8988 | 10671 | 473919 | 37.5443 | -4.7278 | 2021-03-21 05:25:44 | Andalusia, Spain | ||
3421202 | 3421202 | 2021-03-19 | Spain | Andalusia | 493578 | 8988 | 10671 | 473919 | 37.5443 | -4.7278 | 2021-03-20 05:25:46 | Andalusia, Spain | ||
3453140 | 3453140 | 2021-03-18 | Spain | Andalusia | 493578 | 8988 | 10671 | 473919 | 37.5443 | -4.7278 | 2021-03-19 05:26:09 | Andalusia, Spain | ||
3621364 | 3621364 | 2021-03-17 | Spain | Andalusia | 492490 | 8947 | 10671 | 472872 | 37.5443 | -4.7278 | 2021-03-18 05:26:22 | Andalusia, Spain | ||
702688 | 702688 | 2021-03-16 | Spain | Andalusia | 491533 | 8899 | 10671 | 471963 | 37.5443 | -4.7278 | 2021-03-17 05:25:07 | Andalusia, Spain | ||
2056166 | 2056166 | 2021-03-15 | Spain | Andalusia | 491082 | 8840 | 10671 | 471571 | 37.5443 | -4.7278 | 2021-03-16 05:25:13 | Andalusia, Spain | ||
1732778 | 1732778 | 2021-03-14 | Spain | Andalusia | 488872 | 8804 | 10671 | 469397 | 37.5443 | -4.7278 | 2021-03-15 05:25:51 | Andalusia, Spain | ||
1580435 | 1580435 | 2021-03-13 | Spain | Andalusia | 488872 | 8804 | 10671 | 469397 | 37.5443 | -4.7278 | 2021-03-14 05:25:37 | Andalusia, 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]);