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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
1759579 | 1759579 | 2021-01-24 | Spain | Andalusia | 348842 | 5770 | 10671 | 332401 | 37.5443 | -4.7278 | 2021-01-25 05:22:16 | Andalusia, Spain | ||
2427186 | 2427186 | 2021-01-23 | Spain | Andalusia | 348842 | 5770 | 10671 | 332401 | 37.5443 | -4.7278 | 2021-01-24 05:22:35 | Andalusia, Spain | ||
2467088 | 2467088 | 2021-01-22 | Spain | Andalusia | 348842 | 5770 | 10671 | 332401 | 37.5443 | -4.7278 | 2021-01-23 05:22:03 | Andalusia, Spain | ||
435639 | 435639 | 2021-01-21 | Spain | Andalusia | 340991 | 5720 | 10671 | 324600 | 37.5443 | -4.7278 | 2021-01-22 05:22:10 | Andalusia, Spain | ||
1094370 | 1094370 | 2021-01-20 | Spain | Andalusia | 333442 | 5664 | 10671 | 317107 | 37.5443 | -4.7278 | 2021-01-21 05:22:01 | Andalusia, Spain | ||
908460 | 908460 | 2021-01-19 | Spain | Andalusia | 327415 | 5600 | 10671 | 311144 | 37.5443 | -4.7278 | 2021-01-20 05:21:54 | Andalusia, Spain | ||
237523 | 237523 | 2021-01-18 | Spain | Andalusia | 323655 | 5532 | 10671 | 307452 | 37.5443 | -4.7278 | 2021-01-19 05:22:15 | Andalusia, Spain | ||
3503640 | 3503640 | 2021-01-17 | Spain | Andalusia | 306961 | 5470 | 10671 | 290820 | 37.5443 | -4.7278 | 2021-01-18 05:22:34 | Andalusia, Spain | ||
3101723 | 3101723 | 2021-01-16 | Spain | Andalusia | 306961 | 5470 | 10671 | 290820 | 37.5443 | -4.7278 | 2021-01-17 05:22:17 | Andalusia, Spain | ||
3515685 | 3515685 | 2021-01-15 | Spain | Andalusia | 306961 | 5470 | 10671 | 290820 | 37.5443 | -4.7278 | 2021-01-16 05:22:40 | Andalusia, Spain | ||
3879858 | 3879858 | 2021-01-14 | Spain | Andalusia | 300235 | 5430 | 10671 | 284134 | 37.5443 | -4.7278 | 2021-01-15 05:22:24 | Andalusia, Spain | ||
3308485 | 3308485 | 2021-01-13 | Spain | Andalusia | 294474 | 5401 | 10671 | 278402 | 37.5443 | -4.7278 | 2021-01-14 05:22:32 | Andalusia, Spain | ||
774630 | 774630 | 2021-01-12 | Spain | Andalusia | 288933 | 5366 | 10671 | 272896 | 37.5443 | -4.7278 | 2021-01-13 05:22:15 | Andalusia, Spain | ||
190351 | 190351 | 2021-01-11 | Spain | Andalusia | 286415 | 5329 | 10671 | 270415 | 37.5443 | -4.7278 | 2021-01-12 05:22:15 | Andalusia, Spain | ||
2626154 | 2626154 | 2021-01-10 | Spain | Andalusia | 276669 | 5251 | 10671 | 260747 | 37.5443 | -4.7278 | 2021-01-11 05:21:50 | Andalusia, Spain | ||
3900242 | 3900242 | 2021-01-09 | Spain | Andalusia | 276669 | 5251 | 10671 | 260747 | 37.5443 | -4.7278 | 2021-01-10 05:22:12 | Andalusia, Spain | ||
154265 | 154265 | 2021-01-08 | Spain | Andalusia | 276669 | 5251 | 10671 | 260747 | 37.5443 | -4.7278 | 2021-01-09 05:22:18 | Andalusia, Spain | ||
2541689 | 2541689 | 2021-01-07 | Spain | Andalusia | 274817 | 5210 | 10671 | 258936 | 37.5443 | -4.7278 | 2021-01-08 05:22:42 | Andalusia, Spain | ||
2864998 | 2864998 | 2021-01-06 | Spain | Andalusia | 269693 | 5187 | 10671 | 253835 | 37.5443 | -4.7278 | 2021-01-07 05:22:03 | Andalusia, Spain | ||
3034585 | 3034585 | 2021-01-05 | Spain | Andalusia | 269693 | 5187 | 10671 | 253835 | 37.5443 | -4.7278 | 2021-01-06 05:22:16 | Andalusia, Spain | ||
1062130 | 1062130 | 2021-01-04 | Spain | Andalusia | 267764 | 5146 | 10671 | 251947 | 37.5443 | -4.7278 | 2021-01-05 05:21:49 | Andalusia, Spain | ||
3230733 | 3230733 | 2021-01-03 | Spain | Andalusia | 264371 | 5123 | 10671 | 248577 | 37.5443 | -4.7278 | 2021-01-04 05:22:02 | Andalusia, Spain | ||
2227802 | 2227802 | 2021-01-02 | Spain | Andalusia | 264371 | 5123 | 10671 | 248577 | 37.5443 | -4.7278 | 2021-01-03 05:22:52 | Andalusia, Spain | ||
1137166 | 1137166 | 2021-01-01 | Spain | Andalusia | 264371 | 5123 | 10671 | 248577 | 37.5443 | -4.7278 | 2021-01-02 05:22:33 | Andalusia, Spain | ||
3695772 | 3695772 | 2020-12-31 | Spain | Andalusia | 264371 | 5123 | 10671 | 248577 | 37.5443 | -4.7278 | 2021-01-01 05:23:07 | Andalusia, Spain | ||
1010587 | 1010587 | 2020-12-30 | Spain | Andalusia | 262639 | 5100 | 10671 | 246868 | 37.5443 | -4.7278 | 2020-12-31 05:22:49 | Andalusia, Spain | ||
766602 | 766602 | 2020-12-29 | Spain | Andalusia | 261217 | 5083 | 10671 | 245463 | 37.5443 | -4.7278 | 2020-12-30 05:22:34 | Andalusia, Spain | ||
3761866 | 3761866 | 2020-12-28 | Spain | Andalusia | 260433 | 5032 | 10671 | 244730 | 37.5443 | -4.7278 | 2020-12-29 05:22:37 | Andalusia, Spain | ||
3778186 | 3778186 | 2020-12-27 | Spain | Andalusia | 257755 | 4950 | 10671 | 242134 | 37.5443 | -4.7278 | 2020-12-28 05:22:06 | Andalusia, Spain | ||
2223791 | 2223791 | 2020-12-26 | Spain | Andalusia | 257755 | 4950 | 10671 | 242134 | 37.5443 | -4.7278 | 2020-12-27 05:22:55 | Andalusia, Spain | ||
202538 | 202538 | 2020-12-25 | Spain | Andalusia | 257755 | 4950 | 10671 | 242134 | 37.5443 | -4.7278 | 2020-12-26 05:22:28 | Andalusia, Spain | ||
3691761 | 3691761 | 2020-12-24 | Spain | Andalusia | 257755 | 4950 | 10671 | 242134 | 37.5443 | -4.7278 | 2020-12-25 05:22:48 | Andalusia, Spain | ||
2407113 | 2407113 | 2020-12-23 | Spain | Andalusia | 256664 | 4912 | 10671 | 241081 | 37.5443 | -4.7278 | 2020-12-24 05:23:04 | Andalusia, Spain | ||
3770159 | 3770159 | 2020-12-22 | Spain | Andalusia | 255563 | 4874 | 10671 | 240018 | 37.5443 | -4.7278 | 2020-12-23 05:22:03 | Andalusia, Spain | ||
927975 | 927975 | 2020-12-21 | Spain | Andalusia | 254998 | 4841 | 10671 | 239486 | 37.5443 | -4.7278 | 2020-12-22 05:22:33 | Andalusia, Spain | ||
2119996 | 2119996 | 2020-12-20 | Spain | Andalusia | 252256 | 4723 | 10671 | 236862 | 37.5443 | -4.7278 | 2020-12-21 05:27:58 | Andalusia, Spain | ||
2931503 | 2931503 | 2020-12-19 | Spain | Andalusia | 252256 | 4723 | 10671 | 236862 | 37.5443 | -4.7278 | 2020-12-20 05:27:32 | Andalusia, Spain | ||
1901449 | 1901449 | 2020-12-18 | Spain | Andalusia | 252256 | 4723 | 10671 | 236862 | 37.5443 | -4.7278 | 2020-12-19 05:27:52 | Andalusia, Spain | ||
2128275 | 2128275 | 2020-12-17 | Spain | Andalusia | 251169 | 4681 | 10671 | 235817 | 37.5443 | -4.7278 | 2020-12-18 05:28:18 | Andalusia, Spain | ||
3149875 | 3149875 | 2020-12-16 | Spain | Andalusia | 249714 | 4656 | 10671 | 234387 | 37.5443 | -4.7278 | 2020-12-17 05:28:12 | Andalusia, Spain | ||
1034656 | 1034656 | 2020-12-15 | Spain | Andalusia | 248611 | 4631 | 10671 | 233309 | 37.5443 | -4.7278 | 2020-12-16 05:28:04 | Andalusia, Spain | ||
1751550 | 1751550 | 2020-12-14 | Spain | Andalusia | 248010 | 4582 | 10671 | 232757 | 37.5443 | -4.7278 | 2020-12-15 05:26:38 | Andalusia, Spain | ||
3848070 | 3848070 | 2020-12-13 | Spain | Andalusia | 244828 | 4524 | 10671 | 229633 | 37.5443 | -4.7278 | 2020-12-14 05:26:27 | Andalusia, Spain | ||
845852 | 845852 | 2020-12-12 | Spain | Andalusia | 244828 | 4524 | 10671 | 229633 | 37.5443 | -4.7278 | 2020-12-13 05:27:20 | Andalusia, Spain | ||
860959 | 860959 | 2020-12-11 | Spain | Andalusia | 244828 | 4524 | 10671 | 229633 | 37.5443 | -4.7278 | 2020-12-12 05:26:19 | Andalusia, Spain | ||
1600501 | 1600501 | 2020-12-10 | Spain | Andalusia | 243636 | 4492 | 10671 | 228473 | 37.5443 | -4.7278 | 2020-12-11 05:26:59 | Andalusia, Spain | ||
2975510 | 2975510 | 2020-12-09 | Spain | Andalusia | 243063 | 4437 | 10671 | 227955 | 37.5443 | -4.7278 | 2020-12-10 05:26:19 | Andalusia, Spain | ||
1819070 | 1819070 | 2020-12-08 | Spain | Andalusia | 242241 | 4367 | 10671 | 227203 | 37.5443 | -4.7278 | 2020-12-09 05:28:01 | 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]);