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)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2463078 | 2463078 | 2021-09-14 | Spain | Andalusia | 795191 | 10998 | 0 | 37.5443 | -4.7278 | 2021-09-15 03:22:37 | Andalusia, Spain | |||
1385917 | 1385917 | 2021-09-13 | Spain | Andalusia | 794609 | 10977 | 0 | 37.5443 | -4.7278 | 2021-09-14 04:21:41 | Andalusia, Spain | |||
1885286 | 1885286 | 2021-09-12 | Spain | Andalusia | 793389 | 10963 | 0 | 37.5443 | -4.7278 | 2021-09-13 04:21:15 | Andalusia, Spain | |||
3806189 | 3806189 | 2021-09-11 | Spain | Andalusia | 793389 | 10963 | 0 | 37.5443 | -4.7278 | 2021-09-12 04:21:13 | Andalusia, Spain | |||
3449129 | 3449129 | 2021-09-10 | Spain | Andalusia | 793389 | 10963 | 0 | 37.5443 | -4.7278 | 2021-09-11 04:21:30 | Andalusia, Spain | |||
1263075 | 1263075 | 2021-09-09 | Spain | Andalusia | 792698 | 10946 | 0 | 37.5443 | -4.7278 | 2021-09-10 04:21:20 | Andalusia, Spain | |||
2279445 | 2279445 | 2021-09-08 | Spain | Andalusia | 791877 | 10933 | 0 | 37.5443 | -4.7278 | 2021-09-09 04:21:27 | Andalusia, Spain | |||
642224 | 642224 | 2021-09-07 | Spain | Andalusia | 791193 | 10906 | 0 | 37.5443 | -4.7278 | 2021-09-08 04:21:31 | Andalusia, Spain | |||
3194287 | 3194287 | 2021-09-06 | Spain | Andalusia | 790862 | 10884 | 0 | 37.5443 | -4.7278 | 2021-09-07 04:21:35 | Andalusia, Spain | |||
3281155 | 3281155 | 2021-09-05 | Spain | Andalusia | 788727 | 10865 | 0 | 37.5443 | -4.7278 | 2021-09-06 04:21:22 | Andalusia, Spain | |||
249569 | 249569 | 2021-09-04 | Spain | Andalusia | 788727 | 10865 | 0 | 37.5443 | -4.7278 | 2021-09-05 04:21:33 | Andalusia, Spain | |||
3974850 | 3974850 | 2021-09-03 | Spain | Andalusia | 788727 | 10865 | 0 | 37.5443 | -4.7278 | 2021-09-04 04:21:28 | Andalusia, Spain | |||
178312 | 178312 | 2021-09-02 | Spain | Andalusia | 787610 | 10836 | 0 | 37.5443 | -4.7278 | 2021-09-03 04:21:20 | Andalusia, Spain | |||
67347 | 67347 | 2021-09-01 | Spain | Andalusia | 786357 | 10810 | 0 | 37.5443 | -4.7278 | 2021-09-02 04:21:15 | Andalusia, Spain | |||
2068189 | 2068189 | 2021-08-31 | Spain | Andalusia | 785356 | 10796 | 0 | 37.5443 | -4.7278 | 2021-09-01 04:21:38 | Andalusia, Spain | |||
1775643 | 1775643 | 2021-08-30 | Spain | Andalusia | 784342 | 10777 | 0 | 37.5443 | -4.7278 | 2021-08-31 04:21:46 | Andalusia, Spain | |||
3892217 | 3892217 | 2021-08-29 | Spain | Andalusia | 781373 | 10748 | 0 | 37.5443 | -4.7278 | 2021-08-30 04:21:23 | Andalusia, Spain | |||
2793320 | 2793320 | 2021-08-28 | Spain | Andalusia | 781373 | 10748 | 0 | 37.5443 | -4.7278 | 2021-08-29 04:21:14 | Andalusia, Spain | |||
2923479 | 2923479 | 2021-08-27 | Spain | Andalusia | 781373 | 10748 | 0 | 37.5443 | -4.7278 | 2021-08-28 04:21:28 | Andalusia, Spain | |||
1596493 | 1596493 | 2021-08-26 | Spain | Andalusia | 779541 | 10720 | 0 | 37.5443 | -4.7278 | 2021-08-27 04:21:37 | Andalusia, Spain | |||
32702 | 32702 | 2021-08-25 | Spain | Andalusia | 779057 | 10616 | 0 | 37.5443 | -4.7278 | 2021-08-26 04:21:28 | Andalusia, Spain | |||
3105741 | 3105741 | 2021-08-24 | Spain | Andalusia | 777299 | 10600 | 0 | 37.5443 | -4.7278 | 2021-08-25 04:21:41 | Andalusia, Spain | |||
3165912 | 3165912 | 2021-08-23 | Spain | Andalusia | 775342 | 10548 | 0 | 37.5443 | -4.7278 | 2021-08-24 04:21:19 | Andalusia, Spain | |||
2175839 | 2175839 | 2021-08-22 | Spain | Andalusia | 770412 | 10514 | 0 | 37.5443 | -4.7278 | 2021-08-23 04:21:27 | Andalusia, Spain | |||
3555935 | 3555935 | 2021-08-21 | Spain | Andalusia | 770412 | 10514 | 0 | 37.5443 | -4.7278 | 2021-08-22 04:21:29 | Andalusia, Spain | |||
1854277 | 1854277 | 2021-08-20 | Spain | Andalusia | 770412 | 10514 | 0 | 37.5443 | -4.7278 | 2021-08-21 04:21:38 | Andalusia, Spain | |||
511984 | 511984 | 2021-08-19 | Spain | Andalusia | 767675 | 10492 | 0 | 37.5443 | -4.7278 | 2021-08-20 04:21:33 | Andalusia, Spain | |||
2518463 | 2518463 | 2021-08-18 | Spain | Andalusia | 765665 | 10463 | 0 | 37.5443 | -4.7278 | 2021-08-19 04:21:15 | Andalusia, Spain | |||
245555 | 245555 | 2021-08-17 | Spain | Andalusia | 764556 | 10427 | 0 | 37.5443 | -4.7278 | 2021-08-18 04:21:35 | Andalusia, Spain | |||
1604518 | 1604518 | 2021-08-16 | Spain | Andalusia | 761266 | 10419 | 0 | 37.5443 | -4.7278 | 2021-08-17 04:21:49 | Andalusia, Spain | |||
103612 | 103612 | 2021-08-15 | Spain | Andalusia | 756270 | 10396 | 0 | 37.5443 | -4.7278 | 2021-08-16 04:21:31 | Andalusia, Spain | |||
507970 | 507970 | 2021-08-14 | Spain | Andalusia | 756270 | 10396 | 0 | 37.5443 | -4.7278 | 2021-08-15 04:21:41 | Andalusia, Spain | |||
1483842 | 1483842 | 2021-08-13 | Spain | Andalusia | 756270 | 10396 | 0 | 37.5443 | -4.7278 | 2021-08-14 04:21:25 | Andalusia, Spain | |||
2899972 | 2899972 | 2021-08-12 | Spain | Andalusia | 752606 | 10384 | 0 | 37.5443 | -4.7278 | 2021-08-13 04:21:24 | Andalusia, Spain | |||
1342576 | 1342576 | 2021-08-11 | Spain | Andalusia | 748871 | 10361 | 0 | 37.5443 | -4.7278 | 2021-08-12 04:21:25 | Andalusia, Spain | |||
2351723 | 2351723 | 2021-08-10 | Spain | Andalusia | 745875 | 10338 | 0 | 37.5443 | -4.7278 | 2021-08-11 04:21:58 | Andalusia, Spain | |||
650252 | 650252 | 2021-08-09 | Spain | Andalusia | 742468 | 10310 | 0 | 37.5443 | -4.7278 | 2021-08-10 04:21:27 | Andalusia, Spain | |||
589914 | 589914 | 2021-08-08 | Spain | Andalusia | 733977 | 10287 | 0 | 37.5443 | -4.7278 | 2021-08-09 04:21:24 | Andalusia, Spain | |||
2203926 | 2203926 | 2021-08-07 | Spain | Andalusia | 733977 | 10287 | 0 | 37.5443 | -4.7278 | 2021-08-08 04:21:33 | Andalusia, Spain | |||
1117876 | 1117876 | 2021-08-06 | Spain | Andalusia | 733977 | 10287 | 0 | 37.5443 | -4.7278 | 2021-08-07 04:21:30 | Andalusia, Spain | |||
1956813 | 1956813 | 2021-08-05 | Spain | Andalusia | 729343 | 10269 | 0 | 37.5443 | -4.7278 | 2021-08-06 04:21:18 | Andalusia, Spain | |||
332192 | 332192 | 2021-08-04 | Spain | Andalusia | 724716 | 10254 | 10671 | 703791 | 37.5443 | -4.7278 | 2021-08-05 04:21:51 | Andalusia, Spain | ||
3468463 | 3468463 | 2021-08-03 | Spain | Andalusia | 721082 | 10238 | 10671 | 700173 | 37.5443 | -4.7278 | 2021-08-04 04:21:25 | Andalusia, Spain | ||
3683737 | 3683737 | 2021-08-02 | Spain | Andalusia | 716641 | 10215 | 10671 | 695755 | 37.5443 | -4.7278 | 2021-08-03 04:21:39 | Andalusia, Spain | ||
3015636 | 3015636 | 2021-08-01 | Spain | Andalusia | 707122 | 10201 | 10671 | 686250 | 37.5443 | -4.7278 | 2021-08-02 04:21:36 | Andalusia, Spain | ||
3904259 | 3904259 | 2021-07-31 | Spain | Andalusia | 707122 | 10201 | 10671 | 686250 | 37.5443 | -4.7278 | 2021-08-01 04:21:50 | Andalusia, Spain | ||
3296464 | 3296464 | 2021-07-30 | Spain | Andalusia | 707122 | 10201 | 10671 | 686250 | 37.5443 | -4.7278 | 2021-07-31 04:21:35 | Andalusia, Spain | ||
3385675 | 3385675 | 2021-07-29 | Spain | Andalusia | 702047 | 10193 | 10671 | 681183 | 37.5443 | -4.7278 | 2021-07-30 04:21:34 | Andalusia, Spain | ||
408580 | 408580 | 2021-07-28 | Spain | Andalusia | 697059 | 10180 | 10671 | 676208 | 37.5443 | -4.7278 | 2021-07-29 04:21:33 | Andalusia, Spain | ||
1306441 | 1306441 | 2021-07-27 | Spain | Andalusia | 693236 | 10172 | 10671 | 672393 | 37.5443 | -4.7278 | 2021-07-28 04:21:39 | Andalusia, Spain | ||
3218584 | 3218584 | 2021-07-26 | Spain | Andalusia | 688491 | 10157 | 10671 | 667663 | 37.5443 | -4.7278 | 2021-07-27 04:21:18 | Andalusia, Spain | ||
1378793 | 1378793 | 2021-07-25 | Spain | Andalusia | 678572 | 10151 | 10671 | 657750 | 37.5443 | -4.7278 | 2021-07-26 04:21:28 | Andalusia, Spain | ||
1330533 | 1330533 | 2021-07-24 | Spain | Andalusia | 678572 | 10151 | 10671 | 657750 | 37.5443 | -4.7278 | 2021-07-25 04:22:12 | Andalusia, Spain | ||
3137837 | 3137837 | 2021-07-23 | Spain | Andalusia | 678572 | 10151 | 10671 | 657750 | 37.5443 | -4.7278 | 2021-07-24 00:21:36 | Andalusia, Spain | ||
3476597 | 3476597 | 2021-07-22 | Spain | Andalusia | 672858 | 10144 | 10671 | 652043 | 37.5443 | -4.7278 | 2021-07-23 04:21:29 | Andalusia, Spain | ||
3331816 | 3331816 | 2021-07-21 | Spain | Andalusia | 669852 | 10132 | 10671 | 649049 | 37.5443 | -4.7278 | 2021-07-22 04:21:19 | Andalusia, Spain | ||
2371797 | 2371797 | 2021-07-20 | Spain | Andalusia | 666305 | 10125 | 10671 | 645509 | 37.5443 | -4.7278 | 2021-07-21 04:21:40 | Andalusia, Spain | ||
483876 | 483876 | 2021-07-19 | Spain | Andalusia | 662632 | 10116 | 10671 | 641845 | 37.5443 | -4.7278 | 2021-07-20 04:21:48 | Andalusia, Spain | ||
2674099 | 2674099 | 2021-07-18 | Spain | Andalusia | 654594 | 10107 | 10671 | 633816 | 37.5443 | -4.7278 | 2021-07-19 04:21:24 | Andalusia, Spain | ||
3706411 | 3706411 | 2021-07-17 | Spain | Andalusia | 654594 | 10107 | 10671 | 633816 | 37.5443 | -4.7278 | 2021-07-18 04:22:07 | Andalusia, Spain | ||
2947642 | 2947642 | 2021-07-16 | Spain | Andalusia | 654594 | 10107 | 10671 | 633816 | 37.5443 | -4.7278 | 2021-07-17 04:22:22 | Andalusia, Spain | ||
296298 | 296298 | 2021-07-15 | Spain | Andalusia | 651109 | 10105 | 10671 | 630333 | 37.5443 | -4.7278 | 2021-07-16 04:21:22 | Andalusia, Spain | ||
3632243 | 3632243 | 2021-07-14 | Spain | Andalusia | 647506 | 10102 | 10671 | 626733 | 37.5443 | -4.7278 | 2021-07-15 04:21:48 | Andalusia, Spain | ||
579118 | 579118 | 2021-07-13 | Spain | Andalusia | 644598 | 10101 | 10671 | 623826 | 37.5443 | -4.7278 | 2021-07-14 04:21:35 | Andalusia, Spain | ||
3741367 | 3741367 | 2021-07-12 | Spain | Andalusia | 641848 | 10096 | 10671 | 621081 | 37.5443 | -4.7278 | 2021-07-13 04:21:18 | Andalusia, Spain | ||
3659880 | 3659880 | 2021-07-11 | Spain | Andalusia | 635969 | 10095 | 10671 | 615203 | 37.5443 | -4.7278 | 2021-07-12 04:21:34 | Andalusia, Spain | ||
626164 | 626164 | 2021-07-10 | Spain | Andalusia | 635969 | 10095 | 10671 | 615203 | 37.5443 | -4.7278 | 2021-07-11 04:21:43 | Andalusia, Spain | ||
829883 | 829883 | 2021-07-09 | Spain | Andalusia | 635969 | 10095 | 10671 | 615203 | 37.5443 | -4.7278 | 2021-07-10 04:21:25 | Andalusia, Spain | ||
778647 | 778647 | 2021-07-08 | Spain | Andalusia | 633165 | 10092 | 10671 | 612402 | 37.5443 | -4.7278 | 2021-07-09 04:21:21 | Andalusia, Spain | ||
1440869 | 1440869 | 2021-07-07 | Spain | Andalusia | 630845 | 10086 | 10671 | 610088 | 37.5443 | -4.7278 | 2021-07-08 04:21:26 | Andalusia, Spain | ||
2693974 | 2693974 | 2021-07-06 | Spain | Andalusia | 628701 | 10078 | 10671 | 607952 | 37.5443 | -4.7278 | 2021-07-07 04:21:20 | Andalusia, Spain | ||
1932723 | 1932723 | 2021-07-05 | Spain | Andalusia | 626891 | 10073 | 10671 | 606147 | 37.5443 | -4.7278 | 2021-07-06 04:21:32 | Andalusia, Spain | ||
1165454 | 1165454 | 2021-07-04 | Spain | Andalusia | 622814 | 10067 | 10671 | 602076 | 37.5443 | -4.7278 | 2021-07-05 04:21:28 | Andalusia, Spain | ||
1495888 | 1495888 | 2021-07-03 | Spain | Andalusia | 622814 | 10067 | 10671 | 602076 | 37.5443 | -4.7278 | 2021-07-04 04:21:38 | Andalusia, Spain | ||
2072203 | 2072203 | 2021-07-02 | Spain | Andalusia | 622814 | 10067 | 10671 | 602076 | 37.5443 | -4.7278 | 2021-07-03 04:21:37 | Andalusia, Spain | ||
2765219 | 2765219 | 2021-07-01 | Spain | Andalusia | 621030 | 10062 | 10671 | 600297 | 37.5443 | -4.7278 | 2021-07-02 04:21:47 | Andalusia, Spain | ||
1893427 | 1893427 | 2021-06-30 | Spain | Andalusia | 619323 | 10062 | 10671 | 598590 | 37.5443 | -4.7278 | 2021-07-01 04:21:19 | Andalusia, Spain | ||
400550 | 400550 | 2021-06-29 | Spain | Andalusia | 618002 | 10041 | 10671 | 597290 | 37.5443 | -4.7278 | 2021-06-30 04:21:41 | Andalusia, Spain | ||
3125793 | 3125793 | 2021-06-28 | Spain | Andalusia | 616896 | 10034 | 10671 | 596191 | 37.5443 | -4.7278 | 2021-06-29 04:21:28 | Andalusia, Spain | ||
2590288 | 2590288 | 2021-06-27 | Spain | Andalusia | 614309 | 10028 | 10671 | 593610 | 37.5443 | -4.7278 | 2021-06-28 04:21:29 | Andalusia, Spain | ||
3958792 | 3958792 | 2021-06-26 | Spain | Andalusia | 614309 | 10028 | 10671 | 593610 | 37.5443 | -4.7278 | 2021-06-27 04:21:39 | Andalusia, Spain | ||
1712611 | 1712611 | 2021-06-25 | Spain | Andalusia | 614309 | 10028 | 10671 | 593610 | 37.5443 | -4.7278 | 2021-06-26 04:21:43 | Andalusia, Spain | ||
2295736 | 2295736 | 2021-06-24 | Spain | Andalusia | 612979 | 10026 | 10671 | 592282 | 37.5443 | -4.7278 | 2021-06-25 04:21:33 | Andalusia, Spain | ||
2423176 | 2423176 | 2021-06-23 | Spain | Andalusia | 611513 | 10025 | 10671 | 590817 | 37.5443 | -4.7278 | 2021-06-24 04:21:55 | Andalusia, Spain | ||
563253 | 563253 | 2021-06-22 | Spain | Andalusia | 610335 | 10019 | 10671 | 589645 | 37.5443 | -4.7278 | 2021-06-23 04:21:46 | Andalusia, Spain | ||
3358955 | 3358955 | 2021-06-21 | Spain | Andalusia | 609412 | 10016 | 10671 | 588725 | 37.5443 | -4.7278 | 2021-06-22 04:21:34 | Andalusia, Spain | ||
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 |
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]);