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 = "Extremadura" sorted by deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2215957 | 2215957 | 2020-08-23 | Spain | Extremadura | 4194 | 524 | 2652 | 1018 | 39.4937 | -6.0679 | 2020-08-24 04:27:56 | Extremadura, Spain | ||
2299739 | 2299739 | 2020-08-22 | Spain | Extremadura | 4194 | 524 | 2652 | 1018 | 39.4937 | -6.0679 | 2020-08-23 04:27:48 | Extremadura, Spain | ||
609978 | 609978 | 2020-08-29 | Spain | Extremadura | 4698 | 526 | 2652 | 1520 | 39.4937 | -6.0679 | 2020-08-30 04:28:22 | Extremadura, Spain | ||
1523473 | 1523473 | 2020-08-28 | Spain | Extremadura | 4698 | 526 | 2652 | 1520 | 39.4937 | -6.0679 | 2020-08-29 04:28:19 | Extremadura, Spain | ||
1996934 | 1996934 | 2020-08-26 | Spain | Extremadura | 4566 | 526 | 2652 | 1388 | 39.4937 | -6.0679 | 2020-08-27 04:28:15 | Extremadura, Spain | ||
2510474 | 2510474 | 2020-08-27 | Spain | Extremadura | 4642 | 526 | 2652 | 1464 | 39.4937 | -6.0679 | 2020-08-28 04:28:11 | Extremadura, Spain | ||
2991562 | 2991562 | 2020-08-24 | Spain | Extremadura | 4409 | 526 | 2652 | 1231 | 39.4937 | -6.0679 | 2020-08-25 04:28:02 | Extremadura, Spain | ||
3562858 | 3562858 | 2020-08-25 | Spain | Extremadura | 4465 | 526 | 2652 | 1287 | 39.4937 | -6.0679 | 2020-08-26 04:28:11 | Extremadura, Spain | ||
3932316 | 3932316 | 2020-08-30 | Spain | Extremadura | 4698 | 526 | 2652 | 1520 | 39.4937 | -6.0679 | 2020-08-31 04:28:27 | Extremadura, Spain | ||
194357 | 194357 | 2020-08-31 | Spain | Extremadura | 5033 | 527 | 2652 | 1854 | 39.4937 | -6.0679 | 2020-09-01 04:28:31 | Extremadura, Spain | ||
2060172 | 2060172 | 2020-09-01 | Spain | Extremadura | 5158 | 527 | 2652 | 1979 | 39.4937 | -6.0679 | 2020-09-02 04:28:25 | Extremadura, Spain | ||
1105843 | 1105843 | 2020-09-02 | Spain | Extremadura | 5273 | 529 | 2652 | 2092 | 39.4937 | -6.0679 | 2020-09-03 04:28:22 | Extremadura, Spain | ||
1354606 | 1354606 | 2020-09-03 | Spain | Extremadura | 5411 | 529 | 2652 | 2230 | 39.4937 | -6.0679 | 2020-09-04 04:28:26 | Extremadura, Spain | ||
813866 | 813866 | 2020-09-05 | Spain | Extremadura | 5583 | 530 | 2652 | 2401 | 39.4937 | -6.0679 | 2020-09-06 04:28:33 | Extremadura, Spain | ||
2662066 | 2662066 | 2020-09-04 | Spain | Extremadura | 5583 | 530 | 2652 | 2401 | 39.4937 | -6.0679 | 2020-09-05 04:28:19 | Extremadura, Spain | ||
3161911 | 3161911 | 2020-09-06 | Spain | Extremadura | 5583 | 530 | 2652 | 2401 | 39.4937 | -6.0679 | 2020-09-07 04:28:30 | Extremadura, Spain | ||
427626 | 427626 | 2020-09-07 | Spain | Extremadura | 6031 | 533 | 2652 | 2846 | 39.4937 | -6.0679 | 2020-09-08 04:28:25 | Extremadura, Spain | ||
1244047 | 1244047 | 2020-09-08 | Spain | Extremadura | 6091 | 533 | 2652 | 2906 | 39.4937 | -6.0679 | 2020-09-09 04:28:48 | Extremadura, Spain | ||
344565 | 344565 | 2020-09-14 | Spain | Extremadura | 7041 | 538 | 2652 | 3851 | 39.4937 | -6.0679 | 2020-09-15 03:22:50 | Extremadura, Spain | ||
547043 | 547043 | 2020-09-12 | Spain | Extremadura | 6643 | 538 | 2652 | 3453 | 39.4937 | -6.0679 | 2020-09-13 04:30:52 | Extremadura, Spain | ||
1173473 | 1173473 | 2020-09-10 | Spain | Extremadura | 6421 | 538 | 2652 | 3231 | 39.4937 | -6.0679 | 2020-09-11 04:46:23 | Extremadura, Spain | ||
1444872 | 1444872 | 2020-09-11 | Spain | Extremadura | 6643 | 538 | 2652 | 3453 | 39.4937 | -6.0679 | 2020-09-12 04:25:05 | Extremadura, Spain | ||
2171838 | 2171838 | 2020-09-09 | Spain | Extremadura | 6246 | 538 | 2652 | 3056 | 39.4937 | -6.0679 | 2020-09-10 04:29:01 | Extremadura, Spain | ||
2729293 | 2729293 | 2020-09-15 | Spain | Extremadura | 7260 | 538 | 2652 | 4070 | 39.4937 | -6.0679 | 2020-09-16 04:22:53 | Extremadura, Spain | ||
2869004 | 2869004 | 2020-09-13 | Spain | Extremadura | 6643 | 538 | 2652 | 3453 | 39.4937 | -6.0679 | 2020-09-14 04:26:00 | Extremadura, Spain | ||
666568 | 666568 | 2020-09-16 | Spain | Extremadura | 7618 | 540 | 2652 | 4426 | 39.4937 | -6.0679 | 2020-09-17 04:22:00 | Extremadura, Spain | ||
1121879 | 1121879 | 2020-09-17 | Spain | Extremadura | 7883 | 540 | 2652 | 4691 | 39.4937 | -6.0679 | 2020-09-18 05:05:00 | Extremadura, Spain | ||
2455061 | 2455061 | 2020-09-19 | Spain | Extremadura | 8166 | 544 | 2652 | 4970 | 39.4937 | -6.0679 | 2020-09-20 04:22:00 | Extremadura, Spain | ||
2849130 | 2849130 | 2020-09-18 | Spain | Extremadura | 8166 | 544 | 2652 | 4970 | 39.4937 | -6.0679 | 2020-09-19 04:22:00 | Extremadura, Spain | ||
3093711 | 3093711 | 2020-09-20 | Spain | Extremadura | 8166 | 544 | 2652 | 4970 | 39.4937 | -6.0679 | 2020-09-21 04:23:00 | Extremadura, Spain | ||
2837107 | 2837107 | 2020-09-21 | Spain | Extremadura | 8959 | 549 | 2652 | 5758 | 39.4937 | -6.0679 | 2020-09-22 04:23:00 | Extremadura, Spain | ||
3316508 | 3316508 | 2020-09-22 | Spain | Extremadura | 9149 | 550 | 2652 | 5947 | 39.4937 | -6.0679 | 2020-09-23 04:23:00 | Extremadura, Spain | ||
2654059 | 2654059 | 2020-09-23 | Spain | Extremadura | 9370 | 557 | 2652 | 6161 | 39.4937 | -6.0679 | 2020-09-24 04:23:00 | Extremadura, Spain | ||
2606316 | 2606316 | 2020-09-24 | Spain | Extremadura | 9563 | 562 | 2652 | 6349 | 39.4937 | -6.0679 | 2020-09-25 04:23:00 | Extremadura, Spain | ||
2582272 | 2582272 | 2020-09-27 | Spain | Extremadura | 9890 | 564 | 2652 | 6674 | 39.4937 | -6.0679 | 2020-09-28 04:23:00 | Extremadura, Spain | ||
2614324 | 2614324 | 2020-09-26 | Spain | Extremadura | 9890 | 564 | 2652 | 6674 | 39.4937 | -6.0679 | 2020-09-27 04:23:00 | Extremadura, Spain | ||
2813039 | 2813039 | 2020-09-25 | Spain | Extremadura | 9890 | 564 | 2652 | 6674 | 39.4937 | -6.0679 | 2020-09-26 04:23:00 | Extremadura, Spain | ||
967187 | 967187 | 2020-09-29 | Spain | Extremadura | 10357 | 570 | 2652 | 7135 | 39.4937 | -6.0679 | 2020-09-30 04:23:33 | Extremadura, Spain | ||
1515684 | 1515684 | 2020-09-28 | Spain | Extremadura | 10357 | 570 | 2652 | 7135 | 39.4937 | -6.0679 | 2020-09-29 04:23:42 | Extremadura, Spain | ||
1046106 | 1046106 | 2020-09-30 | Spain | Extremadura | 10676 | 577 | 2652 | 7447 | 39.4937 | -6.0679 | 2020-10-01 04:23:42 | Extremadura, Spain | ||
2379920 | 2379920 | 2020-10-01 | Spain | Extremadura | 10853 | 581 | 2652 | 7620 | 39.4937 | -6.0679 | 2020-10-02 04:23:51 | Extremadura, Spain | ||
1823077 | 1823077 | 2020-10-04 | Spain | Extremadura | 11014 | 590 | 2652 | 7772 | 39.4937 | -6.0679 | 2020-10-05 04:23:33 | Extremadura, Spain | ||
2514461 | 2514461 | 2020-10-03 | Spain | Extremadura | 11014 | 590 | 2652 | 7772 | 39.4937 | -6.0679 | 2020-10-04 04:23:44 | Extremadura, Spain | ||
3389679 | 3389679 | 2020-10-02 | Spain | Extremadura | 11014 | 590 | 2652 | 7772 | 39.4937 | -6.0679 | 2020-10-03 04:23:40 | Extremadura, Spain | ||
3802187 | 3802187 | 2020-10-05 | Spain | Extremadura | 11448 | 600 | 2652 | 8196 | 39.4937 | -6.0679 | 2020-10-06 04:23:33 | Extremadura, Spain | ||
3117775 | 3117775 | 2020-10-06 | Spain | Extremadura | 11612 | 608 | 2652 | 8352 | 39.4937 | -6.0679 | 2020-10-07 04:23:40 | Extremadura, Spain | ||
1042114 | 1042114 | 2020-10-07 | Spain | Extremadura | 11839 | 617 | 2652 | 8570 | 39.4937 | -6.0679 | 2020-10-08 04:23:56 | Extremadura, Spain | ||
2689972 | 2689972 | 2020-10-08 | Spain | Extremadura | 12041 | 621 | 2652 | 8768 | 39.4937 | -6.0679 | 2020-10-09 04:23:59 | Extremadura, Spain | ||
817857 | 817857 | 2020-10-09 | Spain | Extremadura | 12269 | 622 | 2652 | 8995 | 39.4937 | -6.0679 | 2020-10-10 04:23:57 | Extremadura, Spain | ||
2602324 | 2602324 | 2020-10-10 | Spain | Extremadura | 12269 | 622 | 2652 | 8995 | 39.4937 | -6.0679 | 2020-10-11 04:23:46 | Extremadura, Spain | ||
3786186 | 3786186 | 2020-10-11 | Spain | Extremadura | 12269 | 622 | 2652 | 8995 | 39.4937 | -6.0679 | 2020-10-12 04:23:45 | Extremadura, Spain | ||
2291734 | 2291734 | 2020-10-12 | Spain | Extremadura | 12856 | 630 | 2652 | 9574 | 39.4937 | -6.0679 | 2020-10-13 04:24:02 | Extremadura, Spain | ||
3782194 | 3782194 | 2020-10-13 | Spain | Extremadura | 13010 | 632 | 2652 | 9726 | 39.4937 | -6.0679 | 2020-10-14 04:24:05 | Extremadura, Spain | ||
79379 | 79379 | 2020-10-14 | Spain | Extremadura | 13227 | 637 | 2652 | 9938 | 39.4937 | -6.0679 | 2020-10-15 04:24:28 | Extremadura, Spain | ||
786668 | 786668 | 2020-10-15 | Spain | Extremadura | 13563 | 642 | 2652 | 10269 | 39.4937 | -6.0679 | 2020-10-16 04:24:01 | Extremadura, Spain | ||
762605 | 762605 | 2020-10-18 | Spain | Extremadura | 13863 | 646 | 2652 | 10565 | 39.4937 | -6.0679 | 2020-10-19 04:24:16 | Extremadura, Spain | ||
1026643 | 1026643 | 2020-10-17 | Spain | Extremadura | 13863 | 646 | 2652 | 10565 | 39.4937 | -6.0679 | 2020-10-18 04:24:25 | Extremadura, Spain | ||
2857138 | 2857138 | 2020-10-16 | Spain | Extremadura | 13863 | 646 | 2652 | 10565 | 39.4937 | -6.0679 | 2020-10-17 04:24:12 | Extremadura, Spain | ||
1794921 | 1794921 | 2020-10-19 | Spain | Extremadura | 14686 | 651 | 2652 | 11383 | 39.4937 | -6.0679 | 2020-10-20 04:24:22 | Extremadura, Spain | ||
3990901 | 3990901 | 2020-10-20 | Spain | Extremadura | 14884 | 656 | 2652 | 11576 | 39.4937 | -6.0679 | 2020-10-21 04:24:14 | Extremadura, Spain | ||
2191890 | 2191890 | 2020-10-21 | Spain | Extremadura | 15288 | 660 | 2652 | 11976 | 39.4937 | -6.0679 | 2020-10-22 04:24:27 | Extremadura, Spain | ||
1177785 | 1177785 | 2020-10-22 | Spain | Extremadura | 15648 | 670 | 2652 | 12326 | 39.4937 | -6.0679 | 2020-10-23 04:24:46 | Extremadura, Spain | ||
8623 | 8623 | 2020-10-25 | Spain | Extremadura | 16077 | 676 | 2652 | 12749 | 39.4937 | -6.0679 | 2020-10-26 04:25:02 | Extremadura, Spain | ||
1054115 | 1054115 | 2020-10-23 | Spain | Extremadura | 16077 | 676 | 2652 | 12749 | 39.4937 | -6.0679 | 2020-10-24 04:24:46 | Extremadura, Spain | ||
3651860 | 3651860 | 2020-10-24 | Spain | Extremadura | 16077 | 676 | 2652 | 12749 | 39.4937 | -6.0679 | 2020-10-25 04:24:36 | Extremadura, Spain | ||
3480602 | 3480602 | 2020-10-26 | Spain | Extremadura | 17339 | 687 | 2652 | 14000 | 39.4937 | -6.0679 | 2020-10-27 04:24:45 | Extremadura, Spain | ||
1452878 | 1452878 | 2020-10-27 | Spain | Extremadura | 17715 | 697 | 2652 | 14366 | 39.4937 | -6.0679 | 2020-10-28 04:24:39 | Extremadura, Spain | ||
754594 | 754594 | 2020-10-28 | Spain | Extremadura | 18288 | 701 | 2652 | 14935 | 39.4937 | -6.0679 | 2020-10-29 04:24:49 | Extremadura, Spain | ||
210532 | 210532 | 2020-10-29 | Spain | Extremadura | 18792 | 703 | 2652 | 15437 | 39.4937 | -6.0679 | 2020-10-30 04:24:49 | Extremadura, Spain | ||
2080224 | 2080224 | 2020-10-31 | Spain | Extremadura | 19307 | 714 | 2652 | 15941 | 39.4937 | -6.0679 | 2020-11-01 04:36:19 | Extremadura, Spain | ||
2243677 | 2243677 | 2020-10-30 | Spain | Extremadura | 19307 | 714 | 2652 | 15941 | 39.4937 | -6.0679 | 2020-10-31 04:24:44 | Extremadura, Spain | ||
3409735 | 3409735 | 2020-11-01 | Spain | Extremadura | 19307 | 714 | 2652 | 15941 | 39.4937 | -6.0679 | 2020-11-02 05:25:04 | Extremadura, Spain | ||
3304486 | 3304486 | 2020-11-02 | Spain | Extremadura | 20606 | 732 | 2652 | 17222 | 39.4937 | -6.0679 | 2020-11-03 06:00:16 | Extremadura, Spain | ||
2498311 | 2498311 | 2020-11-03 | Spain | Extremadura | 20967 | 743 | 2652 | 17572 | 39.4937 | -6.0679 | 2020-11-04 05:25:09 | Extremadura, Spain | ||
2919474 | 2919474 | 2020-11-04 | Spain | Extremadura | 21681 | 754 | 2652 | 18275 | 39.4937 | -6.0679 | 2020-11-05 06:05:03 | Extremadura, Spain | ||
892412 | 892412 | 2020-11-05 | Spain | Extremadura | 22204 | 760 | 2652 | 18792 | 39.4937 | -6.0679 | 2020-11-06 05:24:55 | Extremadura, Spain | ||
376474 | 376474 | 2020-11-06 | Spain | Extremadura | 22804 | 770 | 2652 | 19382 | 39.4937 | -6.0679 | 2020-11-07 05:24:52 | Extremadura, Spain | ||
1544236 | 1544236 | 2020-11-07 | Spain | Extremadura | 22804 | 770 | 2652 | 19382 | 39.4937 | -6.0679 | 2020-11-08 05:24:56 | Extremadura, Spain | ||
1728776 | 1728776 | 2020-11-08 | Spain | Extremadura | 22804 | 770 | 2652 | 19382 | 39.4937 | -6.0679 | 2020-11-09 05:25:45 | Extremadura, Spain | ||
272447 | 272447 | 2020-11-10 | Spain | Extremadura | 23870 | 786 | 2652 | 20432 | 39.4937 | -6.0679 | 2020-11-11 05:25:30 | Extremadura, Spain | ||
1988924 | 1988924 | 2020-11-09 | Spain | Extremadura | 23870 | 786 | 2652 | 20432 | 39.4937 | -6.0679 | 2020-11-10 05:40:07 | Extremadura, Spain | ||
3441107 | 3441107 | 2020-11-11 | Spain | Extremadura | 24649 | 805 | 2652 | 21192 | 39.4937 | -6.0679 | 2020-11-12 05:25:55 | Extremadura, Spain | ||
865063 | 865063 | 2020-11-12 | Spain | Extremadura | 25107 | 813 | 2652 | 21642 | 39.4937 | -6.0679 | 2020-11-13 05:25:30 | Extremadura, Spain | ||
2785298 | 2785298 | 2020-11-13 | Spain | Extremadura | 25454 | 826 | 2652 | 21976 | 39.4937 | -6.0679 | 2020-11-14 05:25:37 | Extremadura, Spain | ||
2880498 | 2880498 | 2020-11-15 | Spain | Extremadura | 25454 | 826 | 2652 | 21976 | 39.4937 | -6.0679 | 2020-11-16 05:25:57 | Extremadura, Spain | ||
2915476 | 2915476 | 2020-11-14 | Spain | Extremadura | 25454 | 826 | 2652 | 21976 | 39.4937 | -6.0679 | 2020-11-15 05:26:53 | Extremadura, Spain | ||
3169930 | 3169930 | 2020-11-16 | Spain | Extremadura | 26066 | 838 | 2652 | 22576 | 39.4937 | -6.0679 | 2020-11-17 05:25:54 | Extremadura, Spain | ||
3338885 | 3338885 | 2020-11-17 | Spain | Extremadura | 26312 | 850 | 2652 | 22810 | 39.4937 | -6.0679 | 2020-11-18 05:40:31 | Extremadura, Spain | ||
122997 | 122997 | 2020-11-18 | Spain | Extremadura | 26614 | 860 | 2652 | 23102 | 39.4937 | -6.0679 | 2020-11-19 05:25:23 | Extremadura, Spain | ||
821863 | 821863 | 2020-11-19 | Spain | Extremadura | 26877 | 872 | 2652 | 23353 | 39.4937 | -6.0679 | 2020-11-20 05:26:28 | Extremadura, Spain | ||
2701803 | 2701803 | 2020-11-20 | Spain | Extremadura | 27155 | 874 | 2652 | 23629 | 39.4937 | -6.0679 | 2020-11-21 05:25:51 | Extremadura, Spain | ||
3190281 | 3190281 | 2020-11-22 | Spain | Extremadura | 27155 | 874 | 2652 | 23629 | 39.4937 | -6.0679 | 2020-11-23 05:25:26 | Extremadura, Spain | ||
3836775 | 3836775 | 2020-11-21 | Spain | Extremadura | 27155 | 874 | 2652 | 23629 | 39.4937 | -6.0679 | 2020-11-22 05:25:45 | Extremadura, Spain | ||
678605 | 678605 | 2020-11-23 | Spain | Extremadura | 27652 | 895 | 2652 | 24105 | 39.4937 | -6.0679 | 2020-11-24 05:27:31 | Extremadura, Spain | ||
1350611 | 1350611 | 2020-11-24 | Spain | Extremadura | 27864 | 902 | 2652 | 24310 | 39.4937 | -6.0679 | 2020-11-25 05:27:20 | Extremadura, Spain | ||
1972880 | 1972880 | 2020-11-25 | Spain | Extremadura | 28086 | 909 | 2652 | 24525 | 39.4937 | -6.0679 | 2020-11-26 05:27:44 | Extremadura, Spain | ||
923975 | 923975 | 2020-11-26 | Spain | Extremadura | 28289 | 915 | 2652 | 24722 | 39.4937 | -6.0679 | 2020-11-27 05:26:53 | Extremadura, Spain | ||
392528 | 392528 | 2020-11-27 | Spain | Extremadura | 28578 | 928 | 2652 | 24998 | 39.4937 | -6.0679 | 2020-11-28 05:25:50 | Extremadura, Spain | ||
2935525 | 2935525 | 2020-11-28 | Spain | Extremadura | 28578 | 928 | 2652 | 24998 | 39.4937 | -6.0679 | 2020-11-29 05:25:55 | Extremadura, Spain | ||
3566860 | 3566860 | 2020-11-29 | Spain | Extremadura | 28578 | 928 | 2652 | 24998 | 39.4937 | -6.0679 | 2020-11-30 05:26:13 | Extremadura, 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]);