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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2347706 | 2347706 | 2020-12-07 | Spain | Andalusia | 242241 | 4367 | 10671 | 227203 | 37.5443 | -4.7278 | 2020-12-08 05:27:42 | Andalusia, Spain | ||
1006576 | 1006576 | 2020-12-06 | Spain | Andalusia | 238783 | 4296 | 10671 | 223816 | 37.5443 | -4.7278 | 2020-12-07 05:26:14 | Andalusia, Spain | ||
1632585 | 1632585 | 2020-12-05 | Spain | Andalusia | 238783 | 4296 | 10671 | 223816 | 37.5443 | -4.7278 | 2020-12-06 05:26:18 | Andalusia, Spain | ||
3860113 | 3860113 | 2020-12-04 | Spain | Andalusia | 238783 | 4296 | 10671 | 223816 | 37.5443 | -4.7278 | 2020-12-05 05:27:36 | Andalusia, Spain | ||
75371 | 75371 | 2020-12-03 | Spain | Andalusia | 237397 | 4251 | 10671 | 222475 | 37.5443 | -4.7278 | 2020-12-04 05:27:27 | Andalusia, Spain | ||
738583 | 738583 | 2020-12-02 | Spain | Andalusia | 235820 | 4184 | 10671 | 220965 | 37.5443 | -4.7278 | 2020-12-03 05:28:22 | Andalusia, Spain | ||
2537677 | 2537677 | 2020-12-01 | Spain | Andalusia | 234238 | 4099 | 10671 | 219468 | 37.5443 | -4.7278 | 2020-12-02 05:27:41 | Andalusia, Spain | ||
1584446 | 1584446 | 2020-11-30 | Spain | Andalusia | 233413 | 4018 | 10671 | 218724 | 37.5443 | -4.7278 | 2020-12-01 05:26:18 | Andalusia, Spain | ||
3566849 | 3566849 | 2020-11-29 | Spain | Andalusia | 229104 | 3903 | 10671 | 214530 | 37.5443 | -4.7278 | 2020-11-30 05:26:13 | Andalusia, Spain | ||
2935514 | 2935514 | 2020-11-28 | Spain | Andalusia | 229104 | 3903 | 10671 | 214530 | 37.5443 | -4.7278 | 2020-11-29 05:25:55 | Andalusia, Spain | ||
392517 | 392517 | 2020-11-27 | Spain | Andalusia | 229104 | 3903 | 10671 | 214530 | 37.5443 | -4.7278 | 2020-11-28 05:25:50 | Andalusia, Spain | ||
923964 | 923964 | 2020-11-26 | Spain | Andalusia | 226989 | 3842 | 10671 | 212476 | 37.5443 | -4.7278 | 2020-11-27 05:26:53 | Andalusia, Spain | ||
1972869 | 1972869 | 2020-11-25 | Spain | Andalusia | 223426 | 3790 | 10671 | 208965 | 37.5443 | -4.7278 | 2020-11-26 05:27:44 | Andalusia, Spain | ||
1350600 | 1350600 | 2020-11-24 | Spain | Andalusia | 222194 | 3725 | 10671 | 207798 | 37.5443 | -4.7278 | 2020-11-25 05:27:20 | Andalusia, Spain | ||
678594 | 678594 | 2020-11-23 | Spain | Andalusia | 218279 | 3633 | 10671 | 203975 | 37.5443 | -4.7278 | 2020-11-24 05:27:31 | Andalusia, Spain | ||
3190270 | 3190270 | 2020-11-22 | Spain | Andalusia | 212439 | 3527 | 10671 | 198241 | 37.5443 | -4.7278 | 2020-11-23 05:25:26 | Andalusia, Spain | ||
3836764 | 3836764 | 2020-11-21 | Spain | Andalusia | 212439 | 3527 | 10671 | 198241 | 37.5443 | -4.7278 | 2020-11-22 05:25:45 | Andalusia, Spain | ||
2701792 | 2701792 | 2020-11-20 | Spain | Andalusia | 212439 | 3527 | 10671 | 198241 | 37.5443 | -4.7278 | 2020-11-21 05:25:51 | Andalusia, Spain | ||
821852 | 821852 | 2020-11-19 | Spain | Andalusia | 208674 | 3472 | 10671 | 194531 | 37.5443 | -4.7278 | 2020-11-20 05:26:28 | Andalusia, Spain | ||
122986 | 122986 | 2020-11-18 | Spain | Andalusia | 205359 | 3424 | 10671 | 191264 | 37.5443 | -4.7278 | 2020-11-19 05:25:23 | Andalusia, Spain | ||
3338874 | 3338874 | 2020-11-17 | Spain | Andalusia | 202491 | 3354 | 10671 | 188466 | 37.5443 | -4.7278 | 2020-11-18 05:40:31 | Andalusia, Spain | ||
3169919 | 3169919 | 2020-11-16 | Spain | Andalusia | 200550 | 3264 | 10671 | 186615 | 37.5443 | -4.7278 | 2020-11-17 05:25:54 | Andalusia, Spain | ||
2880487 | 2880487 | 2020-11-15 | Spain | Andalusia | 189744 | 3155 | 10671 | 175918 | 37.5443 | -4.7278 | 2020-11-16 05:25:57 | Andalusia, Spain | ||
2915465 | 2915465 | 2020-11-14 | Spain | Andalusia | 189744 | 3155 | 10671 | 175918 | 37.5443 | -4.7278 | 2020-11-15 05:26:53 | 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]);