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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
1838214 | 1838214 | 2021-03-12 | Spain | Andalusia | 488872 | 8804 | 10671 | 469397 | 37.5443 | -4.7278 | 2021-03-13 05:25:15 | Andalusia, Spain | ||
352579 | 352579 | 2021-03-11 | Spain | Andalusia | 487818 | 8769 | 10671 | 468378 | 37.5443 | -4.7278 | 2021-03-12 05:26:50 | Andalusia, Spain | ||
3962803 | 3962803 | 2021-03-10 | Spain | Andalusia | 486723 | 8733 | 10671 | 467319 | 37.5443 | -4.7278 | 2021-03-11 05:25:48 | Andalusia, Spain | ||
3663891 | 3663891 | 2021-03-09 | Spain | Andalusia | 485759 | 8697 | 10671 | 466391 | 37.5443 | -4.7278 | 2021-03-10 05:24:35 | Andalusia, Spain | ||
2359750 | 2359750 | 2021-03-08 | Spain | Andalusia | 485175 | 8627 | 10671 | 465877 | 37.5443 | -4.7278 | 2021-03-09 05:28:19 | Andalusia, Spain | ||
55088 | 55088 | 2021-03-07 | Spain | Andalusia | 482590 | 8566 | 10671 | 463353 | 37.5443 | -4.7278 | 2021-03-08 05:24:48 | Andalusia, Spain | ||
3667905 | 3667905 | 2021-03-06 | Spain | Andalusia | 482590 | 8566 | 10671 | 463353 | 37.5443 | -4.7278 | 2021-03-07 05:21:54 | Andalusia, Spain | ||
1616526 | 1616526 | 2021-03-05 | Spain | Andalusia | 482590 | 8566 | 10671 | 463353 | 37.5443 | -4.7278 | 2021-03-06 04:23:41 | Andalusia, Spain | ||
2207937 | 2207937 | 2021-03-04 | Spain | Andalusia | 481316 | 8515 | 10671 | 462130 | 37.5443 | -4.7278 | 2021-03-05 05:26:29 | Andalusia, Spain | ||
1090358 | 1090358 | 2021-03-03 | Spain | Andalusia | 480334 | 8475 | 10671 | 461188 | 37.5443 | -4.7278 | 2021-03-04 05:24:24 | Andalusia, Spain | ||
3254430 | 3254430 | 2021-03-02 | Spain | Andalusia | 479848 | 8405 | 10671 | 460772 | 37.5443 | -4.7278 | 2021-03-03 05:23:28 | Andalusia, Spain | ||
998722 | 998722 | 2021-03-01 | Spain | Andalusia | 479489 | 8393 | 10671 | 460425 | 37.5443 | -4.7278 | 2021-03-02 05:23:30 | Andalusia, Spain | ||
2367780 | 2367780 | 2021-02-28 | Spain | Andalusia | 476822 | 8328 | 10671 | 457823 | 37.5443 | -4.7278 | 2021-03-01 05:23:01 | Andalusia, Spain | ||
3066282 | 3066282 | 2021-02-27 | Spain | Andalusia | 476822 | 8328 | 10671 | 457823 | 37.5443 | -4.7278 | 2021-02-28 05:22:20 | Andalusia, Spain | ||
2183866 | 2183866 | 2021-02-26 | Spain | Andalusia | 476822 | 8328 | 10671 | 457823 | 37.5443 | -4.7278 | 2021-02-27 05:22:28 | Andalusia, Spain | ||
1858288 | 1858288 | 2021-02-25 | Spain | Andalusia | 475599 | 8293 | 10671 | 456635 | 37.5443 | -4.7278 | 2021-02-26 05:22:40 | Andalusia, Spain | ||
280466 | 280466 | 2021-02-24 | Spain | Andalusia | 474331 | 8236 | 10671 | 455424 | 37.5443 | -4.7278 | 2021-02-25 05:24:57 | Andalusia, Spain | ||
1936734 | 1936734 | 2021-02-23 | Spain | Andalusia | 472983 | 8141 | 10671 | 454171 | 37.5443 | -4.7278 | 2021-02-24 05:29:16 | Andalusia, Spain | ||
530989 | 530989 | 2021-02-22 | Spain | Andalusia | 472186 | 8043 | 10671 | 453472 | 37.5443 | -4.7278 | 2021-02-23 05:23:41 | Andalusia, Spain | ||
182323 | 182323 | 2021-02-21 | Spain | Andalusia | 468648 | 7946 | 10671 | 450031 | 37.5443 | -4.7278 | 2021-02-22 05:24:21 | Andalusia, Spain | ||
742597 | 742597 | 2021-02-20 | Spain | Andalusia | 468648 | 7946 | 10671 | 450031 | 37.5443 | -4.7278 | 2021-02-21 05:24:33 | Andalusia, Spain | ||
471695 | 471695 | 2021-02-19 | Spain | Andalusia | 468648 | 7946 | 10671 | 450031 | 37.5443 | -4.7278 | 2021-02-20 05:22:51 | Andalusia, Spain | ||
1153404 | 1153404 | 2021-02-18 | Spain | Andalusia | 466308 | 7878 | 10671 | 447759 | 37.5443 | -4.7278 | 2021-02-19 05:24:16 | Andalusia, Spain | ||
3601324 | 3601324 | 2021-02-17 | Spain | Andalusia | 464449 | 7792 | 10671 | 445986 | 37.5443 | -4.7278 | 2021-02-18 05:22:58 | Andalusia, Spain | ||
3050459 | 3050459 | 2021-02-16 | Spain | Andalusia | 462624 | 7717 | 10671 | 444236 | 37.5443 | -4.7278 | 2021-02-17 05:23:10 | Andalusia, Spain | ||
1338558 | 1338558 | 2021-02-15 | Spain | Andalusia | 461623 | 7610 | 10671 | 443342 | 37.5443 | -4.7278 | 2021-02-16 05:24:38 | Andalusia, Spain | ||
2283709 | 2283709 | 2021-02-14 | Spain | Andalusia | 455484 | 7409 | 10671 | 437404 | 37.5443 | -4.7278 | 2021-02-15 05:24:49 | Andalusia, Spain | ||
2678109 | 2678109 | 2021-02-13 | Spain | Andalusia | 455484 | 7409 | 10671 | 437404 | 37.5443 | -4.7278 | 2021-02-14 05:23:43 | Andalusia, Spain | ||
3539742 | 3539742 | 2021-02-12 | Spain | Andalusia | 455484 | 7409 | 10671 | 437404 | 37.5443 | -4.7278 | 2021-02-13 05:22:12 | Andalusia, Spain | ||
2638005 | 2638005 | 2021-02-11 | Spain | Andalusia | 452318 | 7281 | 10671 | 434366 | 37.5443 | -4.7278 | 2021-02-12 05:23:29 | Andalusia, Spain | ||
3978860 | 3978860 | 2021-02-10 | Spain | Andalusia | 448767 | 7173 | 10671 | 430923 | 37.5443 | -4.7278 | 2021-02-11 05:23:55 | Andalusia, Spain | ||
1528180 | 1528180 | 2021-02-09 | Spain | Andalusia | 445780 | 7063 | 10671 | 428046 | 37.5443 | -4.7278 | 2021-02-10 05:22:41 | Andalusia, Spain | ||
613971 | 613971 | 2021-02-08 | Spain | Andalusia | 443758 | 6937 | 10671 | 426150 | 37.5443 | -4.7278 | 2021-02-09 05:23:30 | Andalusia, Spain | ||
1672740 | 1672740 | 2021-02-07 | Spain | Andalusia | 432228 | 6757 | 10671 | 414800 | 37.5443 | -4.7278 | 2021-02-08 05:22:39 | Andalusia, Spain | ||
975201 | 975201 | 2021-02-06 | Spain | Andalusia | 432228 | 6757 | 10671 | 414800 | 37.5443 | -4.7278 | 2021-02-07 05:23:00 | Andalusia, Spain | ||
1588459 | 1588459 | 2021-02-05 | Spain | Andalusia | 432228 | 6757 | 10671 | 414800 | 37.5443 | -4.7278 | 2021-02-06 05:23:55 | Andalusia, Spain | ||
790666 | 790666 | 2021-02-04 | Spain | Andalusia | 427083 | 6651 | 10671 | 409761 | 37.5443 | -4.7278 | 2021-02-05 05:22:38 | Andalusia, Spain | ||
340558 | 340558 | 2021-02-03 | Spain | Andalusia | 420352 | 6581 | 10671 | 403100 | 37.5443 | -4.7278 | 2021-02-04 05:22:26 | Andalusia, Spain | ||
1684784 | 1684784 | 2021-02-02 | Spain | Andalusia | 415278 | 6491 | 10671 | 398116 | 37.5443 | -4.7278 | 2021-02-03 05:22:52 | Andalusia, Spain | ||
1676754 | 1676754 | 2021-02-01 | Spain | Andalusia | 411468 | 6390 | 10671 | 394407 | 37.5443 | -4.7278 | 2021-02-02 05:22:49 | Andalusia, Spain | ||
1460042 | 1460042 | 2021-01-31 | Spain | Andalusia | 391102 | 6260 | 10671 | 374171 | 37.5443 | -4.7278 | 2021-02-01 05:22:53 | Andalusia, Spain | ||
2211950 | 2211950 | 2021-01-30 | Spain | Andalusia | 391102 | 6260 | 10671 | 374171 | 37.5443 | -4.7278 | 2021-01-31 05:22:42 | Andalusia, Spain | ||
1897437 | 1897437 | 2021-01-29 | Spain | Andalusia | 391102 | 6260 | 10671 | 374171 | 37.5443 | -4.7278 | 2021-01-30 05:22:49 | Andalusia, Spain | ||
2482253 | 2482253 | 2021-01-28 | Spain | Andalusia | 383399 | 6173 | 10671 | 366555 | 37.5443 | -4.7278 | 2021-01-29 05:22:23 | Andalusia, Spain | ||
3153888 | 3153888 | 2021-01-27 | Spain | Andalusia | 379715 | 6091 | 10671 | 362953 | 37.5443 | -4.7278 | 2021-01-28 05:22:24 | Andalusia, Spain | ||
12623 | 12623 | 2021-01-26 | Spain | Andalusia | 373028 | 6007 | 10671 | 356350 | 37.5443 | -4.7278 | 2021-01-27 05:23:41 | Andalusia, Spain | ||
2567947 | 2567947 | 2021-01-25 | Spain | Andalusia | 368220 | 5925 | 10671 | 351624 | 37.5443 | -4.7278 | 2021-01-26 05:22:02 | 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]);