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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3503651 | 3503651 | 2021-01-17 | Spain | Extremadura | 51108 | 1189 | 2652 | 47267 | 39.4937 | -6.0679 | 2021-01-18 05:22:34 | Extremadura, Spain | ||
3101734 | 3101734 | 2021-01-16 | Spain | Extremadura | 51108 | 1189 | 2652 | 47267 | 39.4937 | -6.0679 | 2021-01-17 05:22:17 | Extremadura, Spain | ||
3515696 | 3515696 | 2021-01-15 | Spain | Extremadura | 51108 | 1189 | 2652 | 47267 | 39.4937 | -6.0679 | 2021-01-16 05:22:40 | Extremadura, Spain | ||
3879869 | 3879869 | 2021-01-14 | Spain | Extremadura | 49959 | 1183 | 2652 | 46124 | 39.4937 | -6.0679 | 2021-01-15 05:22:24 | Extremadura, Spain | ||
3308496 | 3308496 | 2021-01-13 | Spain | Extremadura | 48623 | 1166 | 2652 | 44805 | 39.4937 | -6.0679 | 2021-01-14 05:22:32 | Extremadura, Spain | ||
774641 | 774641 | 2021-01-12 | Spain | Extremadura | 47250 | 1158 | 2652 | 43440 | 39.4937 | -6.0679 | 2021-01-13 05:22:15 | Extremadura, Spain | ||
190362 | 190362 | 2021-01-11 | Spain | Extremadura | 46130 | 1135 | 2652 | 42343 | 39.4937 | -6.0679 | 2021-01-12 05:22:15 | Extremadura, Spain | ||
2626165 | 2626165 | 2021-01-10 | Spain | Extremadura | 43028 | 1111 | 2652 | 39265 | 39.4937 | -6.0679 | 2021-01-11 05:21:50 | Extremadura, Spain | ||
3900253 | 3900253 | 2021-01-09 | Spain | Extremadura | 43028 | 1111 | 2652 | 39265 | 39.4937 | -6.0679 | 2021-01-10 05:22:12 | Extremadura, Spain | ||
154276 | 154276 | 2021-01-08 | Spain | Extremadura | 43028 | 1111 | 2652 | 39265 | 39.4937 | -6.0679 | 2021-01-09 05:22:18 | Extremadura, Spain | ||
2541700 | 2541700 | 2021-01-07 | Spain | Extremadura | 41847 | 1097 | 2652 | 38098 | 39.4937 | -6.0679 | 2021-01-08 05:22:42 | Extremadura, Spain | ||
2865009 | 2865009 | 2021-01-06 | Spain | Extremadura | 40052 | 1089 | 2652 | 36311 | 39.4937 | -6.0679 | 2021-01-07 05:22:03 | Extremadura, Spain | ||
3034596 | 3034596 | 2021-01-05 | Spain | Extremadura | 40052 | 1089 | 2652 | 36311 | 39.4937 | -6.0679 | 2021-01-06 05:22:16 | Extremadura, Spain | ||
1062141 | 1062141 | 2021-01-04 | Spain | Extremadura | 39305 | 1083 | 2652 | 35570 | 39.4937 | -6.0679 | 2021-01-05 05:21:49 | Extremadura, Spain | ||
3230744 | 3230744 | 2021-01-03 | Spain | Extremadura | 37208 | 1067 | 2652 | 33489 | 39.4937 | -6.0679 | 2021-01-04 05:22:02 | Extremadura, Spain | ||
2227813 | 2227813 | 2021-01-02 | Spain | Extremadura | 37208 | 1067 | 2652 | 33489 | 39.4937 | -6.0679 | 2021-01-03 05:22:52 | Extremadura, Spain | ||
1137177 | 1137177 | 2021-01-01 | Spain | Extremadura | 37208 | 1067 | 2652 | 33489 | 39.4937 | -6.0679 | 2021-01-02 05:22:33 | Extremadura, Spain | ||
3695783 | 3695783 | 2020-12-31 | Spain | Extremadura | 37208 | 1067 | 2652 | 33489 | 39.4937 | -6.0679 | 2021-01-01 05:23:07 | Extremadura, Spain | ||
1010598 | 1010598 | 2020-12-30 | Spain | Extremadura | 36311 | 1064 | 2652 | 32595 | 39.4937 | -6.0679 | 2020-12-31 05:22:49 | Extremadura, Spain | ||
766613 | 766613 | 2020-12-29 | Spain | Extremadura | 35568 | 1062 | 2652 | 31854 | 39.4937 | -6.0679 | 2020-12-30 05:22:34 | Extremadura, Spain | ||
3761877 | 3761877 | 2020-12-28 | Spain | Extremadura | 35051 | 1057 | 2652 | 31342 | 39.4937 | -6.0679 | 2020-12-29 05:22:37 | Extremadura, Spain | ||
3778197 | 3778197 | 2020-12-27 | Spain | Extremadura | 34071 | 1044 | 2652 | 30375 | 39.4937 | -6.0679 | 2020-12-28 05:22:06 | Extremadura, Spain | ||
2223802 | 2223802 | 2020-12-26 | Spain | Extremadura | 34071 | 1044 | 2652 | 30375 | 39.4937 | -6.0679 | 2020-12-27 05:22:55 | Extremadura, Spain | ||
202549 | 202549 | 2020-12-25 | Spain | Extremadura | 34071 | 1044 | 2652 | 30375 | 39.4937 | -6.0679 | 2020-12-26 05:22:28 | Extremadura, Spain | ||
3691772 | 3691772 | 2020-12-24 | Spain | Extremadura | 34071 | 1044 | 2652 | 30375 | 39.4937 | -6.0679 | 2020-12-25 05:22:48 | Extremadura, Spain | ||
2407124 | 2407124 | 2020-12-23 | Spain | Extremadura | 33558 | 1041 | 2652 | 29865 | 39.4937 | -6.0679 | 2020-12-24 05:23:04 | Extremadura, Spain | ||
3770170 | 3770170 | 2020-12-22 | Spain | Extremadura | 33141 | 1037 | 2652 | 29452 | 39.4937 | -6.0679 | 2020-12-23 05:22:03 | Extremadura, Spain | ||
927986 | 927986 | 2020-12-21 | Spain | Extremadura | 32786 | 1034 | 2652 | 29100 | 39.4937 | -6.0679 | 2020-12-22 05:22:33 | Extremadura, Spain | ||
2120007 | 2120007 | 2020-12-20 | Spain | Extremadura | 31939 | 1029 | 2652 | 28258 | 39.4937 | -6.0679 | 2020-12-21 05:27:58 | Extremadura, Spain | ||
2931514 | 2931514 | 2020-12-19 | Spain | Extremadura | 31939 | 1029 | 2652 | 28258 | 39.4937 | -6.0679 | 2020-12-20 05:27:32 | Extremadura, Spain | ||
1901460 | 1901460 | 2020-12-18 | Spain | Extremadura | 31939 | 1029 | 2652 | 28258 | 39.4937 | -6.0679 | 2020-12-19 05:27:52 | Extremadura, Spain | ||
2128286 | 2128286 | 2020-12-17 | Spain | Extremadura | 31649 | 1021 | 2652 | 27976 | 39.4937 | -6.0679 | 2020-12-18 05:28:18 | Extremadura, Spain | ||
3149886 | 3149886 | 2020-12-16 | Spain | Extremadura | 30634 | 1020 | 2652 | 26962 | 39.4937 | -6.0679 | 2020-12-17 05:28:12 | Extremadura, Spain | ||
1034667 | 1034667 | 2020-12-15 | Spain | Extremadura | 30627 | 1015 | 2652 | 26960 | 39.4937 | -6.0679 | 2020-12-16 05:28:04 | Extremadura, Spain | ||
1751561 | 1751561 | 2020-12-14 | Spain | Extremadura | 30575 | 1012 | 2652 | 26911 | 39.4937 | -6.0679 | 2020-12-15 05:26:38 | Extremadura, Spain | ||
3848081 | 3848081 | 2020-12-13 | Spain | Extremadura | 30106 | 996 | 2652 | 26458 | 39.4937 | -6.0679 | 2020-12-14 05:26:27 | Extremadura, Spain | ||
845863 | 845863 | 2020-12-12 | Spain | Extremadura | 30106 | 996 | 2652 | 26458 | 39.4937 | -6.0679 | 2020-12-13 05:27:20 | Extremadura, Spain | ||
860970 | 860970 | 2020-12-11 | Spain | Extremadura | 30106 | 996 | 2652 | 26458 | 39.4937 | -6.0679 | 2020-12-12 05:26:19 | Extremadura, Spain | ||
1600512 | 1600512 | 2020-12-10 | Spain | Extremadura | 29956 | 990 | 2652 | 26314 | 39.4937 | -6.0679 | 2020-12-11 05:26:59 | Extremadura, Spain | ||
2975521 | 2975521 | 2020-12-09 | Spain | Extremadura | 29888 | 985 | 2652 | 26251 | 39.4937 | -6.0679 | 2020-12-10 05:26:19 | Extremadura, Spain | ||
1819081 | 1819081 | 2020-12-08 | Spain | Extremadura | 29731 | 982 | 2652 | 26097 | 39.4937 | -6.0679 | 2020-12-09 05:28:01 | Extremadura, Spain | ||
2347717 | 2347717 | 2020-12-07 | Spain | Extremadura | 29731 | 982 | 2652 | 26097 | 39.4937 | -6.0679 | 2020-12-08 05:27:42 | Extremadura, Spain | ||
1006587 | 1006587 | 2020-12-06 | Spain | Extremadura | 29461 | 971 | 2652 | 25838 | 39.4937 | -6.0679 | 2020-12-07 05:26:14 | Extremadura, Spain | ||
1632596 | 1632596 | 2020-12-05 | Spain | Extremadura | 29461 | 971 | 2652 | 25838 | 39.4937 | -6.0679 | 2020-12-06 05:26:18 | Extremadura, Spain | ||
3860124 | 3860124 | 2020-12-04 | Spain | Extremadura | 29461 | 971 | 2652 | 25838 | 39.4937 | -6.0679 | 2020-12-05 05:27:36 | Extremadura, Spain | ||
75382 | 75382 | 2020-12-03 | Spain | Extremadura | 29306 | 966 | 2652 | 25688 | 39.4937 | -6.0679 | 2020-12-04 05:27:27 | Extremadura, Spain | ||
738594 | 738594 | 2020-12-02 | Spain | Extremadura | 29132 | 956 | 2652 | 25524 | 39.4937 | -6.0679 | 2020-12-03 05:28:22 | Extremadura, Spain | ||
2537688 | 2537688 | 2020-12-01 | Spain | Extremadura | 28986 | 952 | 2652 | 25382 | 39.4937 | -6.0679 | 2020-12-02 05:27:41 | Extremadura, Spain | ||
1584457 | 1584457 | 2020-11-30 | Spain | Extremadura | 28843 | 941 | 2652 | 25250 | 39.4937 | -6.0679 | 2020-12-01 05:26:18 | 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 | ||
2935525 | 2935525 | 2020-11-28 | Spain | Extremadura | 28578 | 928 | 2652 | 24998 | 39.4937 | -6.0679 | 2020-11-29 05:25:55 | 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 | ||
923975 | 923975 | 2020-11-26 | Spain | Extremadura | 28289 | 915 | 2652 | 24722 | 39.4937 | -6.0679 | 2020-11-27 05:26:53 | 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 | ||
1350611 | 1350611 | 2020-11-24 | Spain | Extremadura | 27864 | 902 | 2652 | 24310 | 39.4937 | -6.0679 | 2020-11-25 05:27:20 | 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 | ||
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 | ||
2701803 | 2701803 | 2020-11-20 | Spain | Extremadura | 27155 | 874 | 2652 | 23629 | 39.4937 | -6.0679 | 2020-11-21 05:25:51 | 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 | ||
122997 | 122997 | 2020-11-18 | Spain | Extremadura | 26614 | 860 | 2652 | 23102 | 39.4937 | -6.0679 | 2020-11-19 05:25:23 | 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 | ||
3169930 | 3169930 | 2020-11-16 | Spain | Extremadura | 26066 | 838 | 2652 | 22576 | 39.4937 | -6.0679 | 2020-11-17 05:25:54 | 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 | ||
2785298 | 2785298 | 2020-11-13 | Spain | Extremadura | 25454 | 826 | 2652 | 21976 | 39.4937 | -6.0679 | 2020-11-14 05:25:37 | 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 | ||
3441107 | 3441107 | 2020-11-11 | Spain | Extremadura | 24649 | 805 | 2652 | 21192 | 39.4937 | -6.0679 | 2020-11-12 05:25:55 | 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 | ||
1728776 | 1728776 | 2020-11-08 | Spain | Extremadura | 22804 | 770 | 2652 | 19382 | 39.4937 | -6.0679 | 2020-11-09 05:25:45 | 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 | ||
376474 | 376474 | 2020-11-06 | Spain | Extremadura | 22804 | 770 | 2652 | 19382 | 39.4937 | -6.0679 | 2020-11-07 05:24:52 | 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 | ||
2919474 | 2919474 | 2020-11-04 | Spain | Extremadura | 21681 | 754 | 2652 | 18275 | 39.4937 | -6.0679 | 2020-11-05 06:05:03 | 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 | ||
3304486 | 3304486 | 2020-11-02 | Spain | Extremadura | 20606 | 732 | 2652 | 17222 | 39.4937 | -6.0679 | 2020-11-03 06:00:16 | 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 | ||
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 | ||
210532 | 210532 | 2020-10-29 | Spain | Extremadura | 18792 | 703 | 2652 | 15437 | 39.4937 | -6.0679 | 2020-10-30 04:24:49 | 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 | ||
1452878 | 1452878 | 2020-10-27 | Spain | Extremadura | 17715 | 697 | 2652 | 14366 | 39.4937 | -6.0679 | 2020-10-28 04:24:39 | 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 | ||
8623 | 8623 | 2020-10-25 | Spain | Extremadura | 16077 | 676 | 2652 | 12749 | 39.4937 | -6.0679 | 2020-10-26 04:25:02 | 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 | ||
1054115 | 1054115 | 2020-10-23 | Spain | Extremadura | 16077 | 676 | 2652 | 12749 | 39.4937 | -6.0679 | 2020-10-24 04:24:46 | 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 | ||
2191890 | 2191890 | 2020-10-21 | Spain | Extremadura | 15288 | 660 | 2652 | 11976 | 39.4937 | -6.0679 | 2020-10-22 04:24:27 | 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 | ||
1794921 | 1794921 | 2020-10-19 | Spain | Extremadura | 14686 | 651 | 2652 | 11383 | 39.4937 | -6.0679 | 2020-10-20 04:24:22 | 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 | ||
786668 | 786668 | 2020-10-15 | Spain | Extremadura | 13563 | 642 | 2652 | 10269 | 39.4937 | -6.0679 | 2020-10-16 04:24:01 | 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 | ||
3782194 | 3782194 | 2020-10-13 | Spain | Extremadura | 13010 | 632 | 2652 | 9726 | 39.4937 | -6.0679 | 2020-10-14 04:24:05 | 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 | ||
3786186 | 3786186 | 2020-10-11 | Spain | Extremadura | 12269 | 622 | 2652 | 8995 | 39.4937 | -6.0679 | 2020-10-12 04:23:45 | 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 |
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]);