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 active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
217090 | 217090 | 2020-06-08 | Spain | Extremadura | 2977 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-09 03:33:03 | Extremadura, Spain | ||
287078 | 287078 | 2020-06-15 | Spain | Extremadura | 2988 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-16 04:33:09 | Extremadura, Spain | ||
302950 | 302950 | 2020-07-01 | Spain | Extremadura | 3033 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-02 04:33:46 | Extremadura, Spain | ||
415242 | 415242 | 2020-07-05 | Spain | Extremadura | 3047 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-06 04:33:57 | Extremadura, Spain | ||
529804 | 529804 | 2020-07-04 | Spain | Extremadura | 3047 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-05 04:33:46 | Extremadura, Spain | ||
573943 | 573943 | 2020-06-06 | Spain | Extremadura | 2977 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-07 03:53:30 | Extremadura, Spain | ||
737401 | 737401 | 2020-06-12 | Spain | Extremadura | 2984 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-13 03:33:14 | Extremadura, Spain | ||
805253 | 805253 | 2020-06-01 | Spain | Extremadura | 2966 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-02 02:33:08 | Extremadura, Spain | ||
887217 | 887217 | 2020-07-07 | Spain | Extremadura | 3066 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-08 05:33:48 | Extremadura, Spain | ||
1005392 | 1005392 | 2020-07-09 | Spain | Extremadura | 3082 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-10 04:34:24 | Extremadura, Spain | ||
1041146 | 1041146 | 2020-05-26 | Spain | Extremadura | 2955 | 507 | 2652 | 0 | 39.4937 | -6.0679 | 2020-05-27 02:32:31 | Extremadura, Spain | ||
1135984 | 1135984 | 2020-06-26 | Spain | Extremadura | 3025 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-27 04:33:35 | Extremadura, Spain | ||
1195752 | 1195752 | 2020-06-17 | Spain | Extremadura | 2992 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-18 04:33:18 | Extremadura, Spain | ||
1210663 | 1210663 | 2020-06-09 | Spain | Extremadura | 2978 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-10 04:07:00 | Extremadura, Spain | ||
1269640 | 1269640 | 2020-06-05 | Spain | Extremadura | 2976 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-06 02:33:00 | Extremadura, Spain | ||
1273371 | 1273371 | 2020-06-11 | Spain | Extremadura | 2983 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-12 05:09:52 | Extremadura, Spain | ||
1281119 | 1281119 | 2020-06-04 | Spain | Extremadura | 2973 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-05 02:33:06 | Extremadura, Spain | ||
1404385 | 1404385 | 2020-05-14 | Spain | Extremadura | 2923 | 492 | 2482 | 0 | 39.4937 | -6.0679 | 2020-05-15 02:33:02 | Extremadura, Spain | ||
1510490 | 1510490 | 2020-06-22 | Spain | Extremadura | 3010 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-23 04:33:22 | Extremadura, Spain | ||
1522296 | 1522296 | 2020-06-23 | Spain | Extremadura | 3011 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-24 04:33:28 | Extremadura, Spain | ||
1691400 | 1691400 | 2020-06-19 | Spain | Extremadura | 3000 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-20 04:33:19 | Extremadura, Spain | ||
1790311 | 1790311 | 2020-05-29 | Spain | Extremadura | 2963 | 507 | 2652 | 0 | 39.4937 | -6.0679 | 2020-05-30 02:32:48 | Extremadura, Spain | ||
1793877 | 1793877 | 2020-05-31 | Spain | Extremadura | 2966 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-01 02:32:46 | Extremadura, Spain | ||
1829495 | 1829495 | 2020-05-16 | Spain | Extremadura | 2958 | 497 | 2609 | 0 | 39.4937 | -6.0679 | 2020-05-17 02:32:32 | Extremadura, Spain | ||
1837029 | 1837029 | 2020-06-14 | Spain | Extremadura | 2987 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-15 03:33:14 | Extremadura, Spain | ||
2039703 | 2039703 | 2020-06-27 | Spain | Extremadura | 3026 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-28 04:34:04 | Extremadura, Spain | ||
2222608 | 2222608 | 2020-07-08 | Spain | Extremadura | 3076 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-09 04:34:23 | Extremadura, Spain | ||
2234465 | 2234465 | 2020-07-03 | Spain | Extremadura | 3047 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-04 04:33:51 | Extremadura, Spain | ||
2306368 | 2306368 | 2020-06-28 | Spain | Extremadura | 3026 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-29 04:33:44 | Extremadura, Spain | ||
2386515 | 2386515 | 2020-06-16 | Spain | Extremadura | 2990 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-17 04:33:21 | Extremadura, Spain | ||
2437822 | 2437822 | 2020-06-20 | Spain | Extremadura | 3001 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-21 04:33:19 | Extremadura, Spain | ||
2548183 | 2548183 | 2020-05-27 | Spain | Extremadura | 2955 | 507 | 2652 | 0 | 39.4937 | -6.0679 | 2020-05-28 02:32:31 | Extremadura, Spain | ||
2555716 | 2555716 | 2020-06-02 | Spain | Extremadura | 2971 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-03 02:33:13 | Extremadura, Spain | ||
2624971 | 2624971 | 2020-06-25 | Spain | Extremadura | 3019 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-26 04:33:43 | Extremadura, Spain | ||
2632805 | 2632805 | 2020-06-29 | Spain | Extremadura | 3027 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-30 04:33:48 | Extremadura, Spain | ||
2684777 | 2684777 | 2020-07-06 | Spain | Extremadura | 3064 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-07 04:34:00 | Extremadura, Spain | ||
2700611 | 2700611 | 2020-06-24 | Spain | Extremadura | 3017 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-25 05:26:54 | Extremadura, Spain | ||
2712191 | 2712191 | 2020-05-28 | Spain | Extremadura | 2961 | 507 | 2652 | 0 | 39.4937 | -6.0679 | 2020-05-29 02:32:50 | Extremadura, Spain | ||
2799887 | 2799887 | 2020-06-07 | Spain | Extremadura | 2977 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-08 03:33:22 | Extremadura, Spain | ||
2863814 | 2863814 | 2020-06-10 | Spain | Extremadura | 2982 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-11 03:33:41 | Extremadura, Spain | ||
2974328 | 2974328 | 2020-06-30 | Spain | Extremadura | 3030 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-01 04:33:52 | Extremadura, Spain | ||
3045259 | 3045259 | 2020-07-02 | Spain | Extremadura | 3040 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-03 04:33:54 | Extremadura, Spain | ||
3061081 | 3061081 | 2020-06-13 | Spain | Extremadura | 2985 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-14 03:33:15 | Extremadura, Spain | ||
3237407 | 3237407 | 2020-07-10 | Spain | Extremadura | 3106 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-11 04:34:26 | Extremadura, Spain | ||
3249229 | 3249229 | 2020-06-21 | Spain | Extremadura | 3006 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-22 04:33:20 | Extremadura, Spain | ||
3260867 | 3260867 | 2020-05-18 | Spain | Extremadura | 2948 | 500 | 2652 | 0 | 39.4937 | -6.0679 | 2020-05-19 02:32:18 | Extremadura, Spain | ||
3276211 | 3276211 | 2020-05-15 | Spain | Extremadura | 2933 | 494 | 2587 | 0 | 39.4937 | -6.0679 | 2020-05-16 02:32:19 | Extremadura, Spain | ||
3416261 | 3416261 | 2020-05-17 | Spain | Extremadura | 2958 | 497 | 2609 | 0 | 39.4937 | -6.0679 | 2020-05-18 02:32:21 | Extremadura, Spain | ||
3435909 | 3435909 | 2020-07-11 | Spain | Extremadura | 3106 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-12 04:34:30 | Extremadura, Spain | ||
3638770 | 3638770 | 2020-05-30 | Spain | Extremadura | 2964 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-05-31 02:32:45 | Extremadura, Spain | ||
3682549 | 3682549 | 2020-06-18 | Spain | Extremadura | 2999 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-19 04:33:17 | Extremadura, Spain | ||
3737514 | 3737514 | 2020-07-12 | Spain | Extremadura | 3106 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-13 04:43:04 | Extremadura, Spain | ||
3866674 | 3866674 | 2020-06-03 | Spain | Extremadura | 2974 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-04 02:33:14 | Extremadura, Spain | ||
1479846 | 1479846 | 2020-08-21 | Spain | Extremadura | 4194 | 524 | 2652 | 1018 | 39.4937 | -6.0679 | 2020-08-22 04:27:49 | Extremadura, Spain | ||
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 | ||
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 | ||
1707394 | 1707394 | 2020-07-21 | Spain | Extremadura | 3278 | 519 | 2652 | 107 | 39.4937 | -6.0679 | 2020-07-22 04:34:42 | 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 | ||
2991562 | 2991562 | 2020-08-24 | Spain | Extremadura | 4409 | 526 | 2652 | 1231 | 39.4937 | -6.0679 | 2020-08-25 04:28:02 | 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 | ||
844655 | 844655 | 2020-07-22 | Spain | Extremadura | 3295 | 519 | 2652 | 124 | 39.4937 | -6.0679 | 2020-07-23 05:15:04 | Extremadura, Spain | ||
61857 | 61857 | 2020-07-23 | Spain | Extremadura | 3298 | 519 | 2652 | 127 | 39.4937 | -6.0679 | 2020-07-24 05:30:40 | 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 | ||
3562858 | 3562858 | 2020-08-25 | Spain | Extremadura | 4465 | 526 | 2652 | 1287 | 39.4937 | -6.0679 | 2020-08-26 04:28:11 | Extremadura, Spain | ||
442421 | 442421 | 2020-07-26 | Spain | Extremadura | 3302 | 519 | 2652 | 131 | 39.4937 | -6.0679 | 2020-07-27 04:35:02 | Extremadura, Spain | ||
1502665 | 1502665 | 2020-07-25 | Spain | Extremadura | 3302 | 519 | 2652 | 131 | 39.4937 | -6.0679 | 2020-07-26 04:35:00 | Extremadura, Spain | ||
2563635 | 2563635 | 2020-07-24 | Spain | Extremadura | 3302 | 519 | 2652 | 131 | 39.4937 | -6.0679 | 2020-07-25 04:47:39 | 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 | ||
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 | ||
177108 | 177108 | 2020-07-27 | Spain | Extremadura | 3316 | 519 | 2652 | 145 | 39.4937 | -6.0679 | 2020-07-28 04:58:43 | 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 | ||
754594 | 754594 | 2020-10-28 | Spain | Extremadura | 18288 | 701 | 2652 | 14935 | 39.4937 | -6.0679 | 2020-10-29 04:24:49 | Extremadura, Spain | ||
3185056 | 3185056 | 2020-07-28 | Spain | Extremadura | 3322 | 519 | 2652 | 151 | 39.4937 | -6.0679 | 2020-07-29 04:35:11 | 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 | ||
3932316 | 3932316 | 2020-08-30 | Spain | Extremadura | 4698 | 526 | 2652 | 1520 | 39.4937 | -6.0679 | 2020-08-31 04:28:27 | 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 | ||
2958440 | 2958440 | 2020-07-29 | Spain | Extremadura | 3345 | 519 | 2652 | 174 | 39.4937 | -6.0679 | 2020-07-30 04:35:05 | 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 | ||
1928272 | 1928272 | 2020-07-30 | Spain | Extremadura | 3351 | 520 | 2652 | 179 | 39.4937 | -6.0679 | 2020-07-31 04:35:18 | 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 | ||
194357 | 194357 | 2020-08-31 | Spain | Extremadura | 5033 | 527 | 2652 | 1854 | 39.4937 | -6.0679 | 2020-09-01 04:28:31 | 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 | ||
2060172 | 2060172 | 2020-09-01 | Spain | Extremadura | 5158 | 527 | 2652 | 1979 | 39.4937 | -6.0679 | 2020-09-02 04:28:25 | 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]);