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 = "Baleares" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3675938 | 3675938 | 2021-05-04 | Spain | Baleares | 59463 | 823 | 1533 | 57107 | 39.710358 | 2.995148 | 2021-05-05 04:20:43 | Baleares, Spain | ||
2761205 | 2761205 | 2021-05-03 | Spain | Baleares | 59427 | 822 | 1533 | 57072 | 39.710358 | 2.995148 | 2021-05-04 04:20:34 | Baleares, Spain | ||
2451058 | 2451058 | 2021-05-02 | Spain | Baleares | 59276 | 820 | 1533 | 56923 | 39.710358 | 2.995148 | 2021-05-03 04:20:39 | Baleares, Spain | ||
2825071 | 2825071 | 2021-05-01 | Spain | Baleares | 59276 | 820 | 1533 | 56923 | 39.710358 | 2.995148 | 2021-05-02 04:20:48 | Baleares, Spain | ||
380479 | 380479 | 2021-04-30 | Spain | Baleares | 59276 | 820 | 1533 | 56923 | 39.710358 | 2.995148 | 2021-05-01 04:20:47 | Baleares, Spain | ||
1636602 | 1636602 | 2021-04-29 | Spain | Baleares | 59191 | 820 | 1533 | 56838 | 39.710358 | 2.995148 | 2021-04-30 04:21:03 | Baleares, Spain | ||
3393681 | 3393681 | 2021-04-28 | Spain | Baleares | 59139 | 819 | 1533 | 56787 | 39.710358 | 2.995148 | 2021-04-29 04:20:55 | Baleares, Spain | ||
3702397 | 3702397 | 2021-04-27 | Spain | Baleares | 59074 | 819 | 1533 | 56722 | 39.710358 | 2.995148 | 2021-04-28 04:20:32 | Baleares, Spain | ||
888406 | 888406 | 2021-04-26 | Spain | Baleares | 59016 | 814 | 1533 | 56669 | 39.710358 | 2.995148 | 2021-04-27 04:20:52 | Baleares, Spain | ||
955151 | 955151 | 2021-04-25 | Spain | Baleares | 58885 | 798 | 1533 | 56554 | 39.710358 | 2.995148 | 2021-04-26 04:21:04 | Baleares, Spain | ||
3924298 | 3924298 | 2021-04-24 | Spain | Baleares | 58885 | 798 | 1533 | 56554 | 39.710358 | 2.995148 | 2021-04-25 04:20:32 | Baleares, Spain | ||
1409329 | 1409329 | 2021-04-23 | Spain | Baleares | 58885 | 798 | 1533 | 56554 | 39.710358 | 2.995148 | 2021-04-24 04:20:38 | Baleares, Spain | ||
1568392 | 1568392 | 2021-04-22 | Spain | Baleares | 58821 | 793 | 1533 | 56495 | 39.710358 | 2.995148 | 2021-04-23 04:20:52 | Baleares, Spain | ||
3242613 | 3242613 | 2021-04-21 | Spain | Baleares | 58756 | 787 | 1533 | 56436 | 39.710358 | 2.995148 | 2021-04-22 04:20:53 | Baleares, Spain | ||
2021009 | 2021009 | 2021-04-20 | Spain | Baleares | 58664 | 780 | 1533 | 56351 | 39.710358 | 2.995148 | 2021-04-21 04:21:14 | Baleares, Spain | ||
2411130 | 2411130 | 2021-04-19 | Spain | Baleares | 58664 | 780 | 1533 | 56351 | 39.710358 | 2.995148 | 2021-04-20 04:20:41 | Baleares, Spain | ||
3129807 | 3129807 | 2021-04-18 | Spain | Baleares | 58533 | 780 | 1533 | 56220 | 39.710358 | 2.995148 | 2021-04-19 04:20:57 | Baleares, Spain | ||
983235 | 983235 | 2021-04-17 | Spain | Baleares | 58533 | 780 | 1533 | 56220 | 39.710358 | 2.995148 | 2021-04-18 04:20:41 | Baleares, Spain | ||
170330 | 170330 | 2021-04-16 | Spain | Baleares | 58533 | 780 | 1533 | 56220 | 39.710358 | 2.995148 | 2021-04-17 04:20:40 | Baleares, Spain | ||
2549161 | 2549161 | 2021-04-15 | Spain | Baleares | 58477 | 780 | 1533 | 56164 | 39.710358 | 2.995148 | 2021-04-16 04:20:46 | Baleares, Spain | ||
1842231 | 1842231 | 2021-04-14 | Spain | Baleares | 58428 | 780 | 1533 | 56115 | 39.710358 | 2.995148 | 2021-04-15 04:20:54 | Baleares, Spain | ||
2571965 | 2571965 | 2021-04-13 | Spain | Baleares | 58380 | 780 | 1533 | 56067 | 39.710358 | 2.995148 | 2021-04-14 04:20:41 | Baleares, Spain | ||
36716 | 36716 | 2021-04-12 | Spain | Baleares | 58298 | 779 | 1533 | 55986 | 39.710358 | 2.995148 | 2021-04-13 04:20:37 | Baleares, Spain | ||
3883875 | 3883875 | 2021-04-11 | Spain | Baleares | 58153 | 779 | 1533 | 55841 | 39.710358 | 2.995148 | 2021-04-12 04:21:00 | Baleares, Spain | ||
2983543 | 2983543 | 2021-04-10 | Spain | Baleares | 58153 | 779 | 1533 | 55841 | 39.710358 | 2.995148 | 2021-04-11 04:20:56 | Baleares, Spain | ||
605975 | 605975 | 2021-04-09 | Spain | Baleares | 58153 | 779 | 1533 | 55841 | 39.710358 | 2.995148 | 2021-04-10 04:20:59 | Baleares, Spain | ||
2646039 | 2646039 | 2021-04-08 | Spain | Baleares | 58082 | 779 | 1533 | 55770 | 39.710358 | 2.995148 | 2021-04-09 04:21:13 | Baleares, Spain | ||
2247681 | 2247681 | 2021-04-07 | Spain | Baleares | 58000 | 778 | 1533 | 55689 | 39.710358 | 2.995148 | 2021-04-08 04:21:13 | Baleares, Spain | ||
3003591 | 3003591 | 2021-04-06 | Spain | Baleares | 57932 | 777 | 1533 | 55622 | 39.710358 | 2.995148 | 2021-04-07 04:20:53 | Baleares, Spain | ||
3085586 | 3085586 | 2021-04-05 | Spain | Baleares | 57901 | 777 | 1533 | 55591 | 39.710358 | 2.995148 | 2021-04-06 04:20:32 | Baleares, Spain | ||
388509 | 388509 | 2021-04-04 | Spain | Baleares | 57809 | 777 | 1533 | 55499 | 39.710358 | 2.995148 | 2021-04-05 04:20:35 | Baleares, Spain | ||
3710425 | 3710425 | 2021-04-03 | Spain | Baleares | 57809 | 777 | 1533 | 55499 | 39.710358 | 2.995148 | 2021-04-04 04:20:49 | Baleares, Spain | ||
241541 | 241541 | 2021-04-02 | Spain | Baleares | 57727 | 777 | 1533 | 55417 | 39.710358 | 2.995148 | 2021-04-03 04:20:44 | Baleares, Spain | ||
1302338 | 1302338 | 2021-04-01 | Spain | Baleares | 57727 | 777 | 1533 | 55417 | 39.710358 | 2.995148 | 2021-04-02 04:20:36 | Baleares, Spain | ||
638210 | 638210 | 2021-03-31 | Spain | Baleares | 57676 | 777 | 1533 | 55366 | 39.710358 | 2.995148 | 2021-04-01 04:27:05 | Baleares, Spain | ||
3643839 | 3643839 | 2021-03-30 | Spain | Baleares | 57619 | 777 | 1533 | 55309 | 39.710358 | 2.995148 | 2021-03-31 04:26:25 | Baleares, Spain | ||
1290292 | 1290292 | 2021-03-29 | Spain | Baleares | 57558 | 777 | 1533 | 55248 | 39.710358 | 2.995148 | 2021-03-30 04:26:23 | Baleares, Spain | ||
1536214 | 1536214 | 2021-03-28 | Spain | Baleares | 57315 | 777 | 1533 | 55005 | 39.710358 | 2.995148 | 2021-03-29 04:28:35 | Baleares, Spain | ||
1219854 | 1219854 | 2021-03-27 | Spain | Baleares | 57315 | 777 | 1533 | 55005 | 39.710358 | 2.995148 | 2021-03-28 05:28:10 | Baleares, Spain | ||
1881272 | 1881272 | 2021-03-26 | Spain | Baleares | 57315 | 777 | 1533 | 55005 | 39.710358 | 2.995148 | 2021-03-27 05:25:04 | Baleares, Spain | ||
1980902 | 1980902 | 2021-03-25 | Spain | Baleares | 57270 | 777 | 1533 | 54960 | 39.710358 | 2.995148 | 2021-03-26 05:26:55 | Baleares, Spain | ||
2781280 | 2781280 | 2021-03-24 | Spain | Baleares | 57130 | 772 | 1533 | 54825 | 39.710358 | 2.995148 | 2021-03-25 05:27:00 | Baleares, Spain | ||
1798925 | 1798925 | 2021-03-23 | Spain | Baleares | 57130 | 772 | 1533 | 54825 | 39.710358 | 2.995148 | 2021-03-24 05:25:40 | Baleares, Spain | ||
1204093 | 1204093 | 2021-03-22 | Spain | Baleares | 57088 | 766 | 1533 | 54789 | 39.710358 | 2.995148 | 2021-03-23 05:26:18 | Baleares, Spain | ||
3369615 | 3369615 | 2021-03-21 | Spain | Baleares | 56881 | 750 | 1533 | 54598 | 39.710358 | 2.995148 | 2021-03-22 05:25:43 | Baleares, Spain | ||
1744825 | 1744825 | 2021-03-20 | Spain | Baleares | 56881 | 750 | 1533 | 54598 | 39.710358 | 2.995148 | 2021-03-21 05:25:44 | Baleares, Spain | ||
3421205 | 3421205 | 2021-03-19 | Spain | Baleares | 56881 | 750 | 1533 | 54598 | 39.710358 | 2.995148 | 2021-03-20 05:25:46 | Baleares, Spain | ||
3453143 | 3453143 | 2021-03-18 | Spain | Baleares | 56881 | 750 | 1533 | 54598 | 39.710358 | 2.995148 | 2021-03-19 05:26:09 | Baleares, Spain | ||
3621367 | 3621367 | 2021-03-17 | Spain | Baleares | 56828 | 742 | 1533 | 54553 | 39.710358 | 2.995148 | 2021-03-18 05:26:22 | Baleares, Spain | ||
702691 | 702691 | 2021-03-16 | Spain | Baleares | 56785 | 739 | 1533 | 54513 | 39.710358 | 2.995148 | 2021-03-17 05:25:07 | Baleares, Spain | ||
2056169 | 2056169 | 2021-03-15 | Spain | Baleares | 56752 | 735 | 1533 | 54484 | 39.710358 | 2.995148 | 2021-03-16 05:25:13 | Baleares, Spain | ||
1732781 | 1732781 | 2021-03-14 | Spain | Baleares | 56663 | 733 | 1533 | 54397 | 39.710358 | 2.995148 | 2021-03-15 05:25:51 | Baleares, Spain | ||
1580438 | 1580438 | 2021-03-13 | Spain | Baleares | 56663 | 733 | 1533 | 54397 | 39.710358 | 2.995148 | 2021-03-14 05:25:37 | Baleares, Spain | ||
1838217 | 1838217 | 2021-03-12 | Spain | Baleares | 56663 | 733 | 1533 | 54397 | 39.710358 | 2.995148 | 2021-03-13 05:25:15 | Baleares, Spain | ||
352582 | 352582 | 2021-03-11 | Spain | Baleares | 56621 | 733 | 1533 | 54355 | 39.710358 | 2.995148 | 2021-03-12 05:26:50 | Baleares, Spain | ||
3962806 | 3962806 | 2021-03-10 | Spain | Baleares | 56519 | 732 | 1533 | 54254 | 39.710358 | 2.995148 | 2021-03-11 05:25:48 | Baleares, Spain | ||
3663894 | 3663894 | 2021-03-09 | Spain | Baleares | 56476 | 732 | 1533 | 54211 | 39.710358 | 2.995148 | 2021-03-10 05:24:35 | Baleares, Spain | ||
2359753 | 2359753 | 2021-03-08 | Spain | Baleares | 56438 | 731 | 1533 | 54174 | 39.710358 | 2.995148 | 2021-03-09 05:28:19 | Baleares, Spain | ||
55091 | 55091 | 2021-03-07 | Spain | Baleares | 56338 | 730 | 1533 | 54075 | 39.710358 | 2.995148 | 2021-03-08 05:24:48 | Baleares, Spain | ||
3667908 | 3667908 | 2021-03-06 | Spain | Baleares | 56338 | 730 | 1533 | 54075 | 39.710358 | 2.995148 | 2021-03-07 05:21:54 | Baleares, Spain | ||
1616529 | 1616529 | 2021-03-05 | Spain | Baleares | 56338 | 730 | 1533 | 54075 | 39.710358 | 2.995148 | 2021-03-06 04:23:41 | Baleares, Spain | ||
2207940 | 2207940 | 2021-03-04 | Spain | Baleares | 56286 | 729 | 1533 | 54024 | 39.710358 | 2.995148 | 2021-03-05 05:26:29 | Baleares, Spain | ||
1090361 | 1090361 | 2021-03-03 | Spain | Baleares | 56236 | 727 | 1533 | 53976 | 39.710358 | 2.995148 | 2021-03-04 05:24:24 | Baleares, Spain | ||
3254433 | 3254433 | 2021-03-02 | Spain | Baleares | 56196 | 725 | 1533 | 53938 | 39.710358 | 2.995148 | 2021-03-03 05:23:28 | Baleares, Spain | ||
998725 | 998725 | 2021-03-01 | Spain | Baleares | 56164 | 725 | 1533 | 53906 | 39.710358 | 2.995148 | 2021-03-02 05:23:30 | Baleares, Spain | ||
2367783 | 2367783 | 2021-02-28 | Spain | Baleares | 55991 | 707 | 1533 | 53751 | 39.710358 | 2.995148 | 2021-03-01 05:23:01 | Baleares, Spain | ||
3066285 | 3066285 | 2021-02-27 | Spain | Baleares | 55991 | 707 | 1533 | 53751 | 39.710358 | 2.995148 | 2021-02-28 05:22:20 | Baleares, Spain | ||
2183869 | 2183869 | 2021-02-26 | Spain | Baleares | 55991 | 707 | 1533 | 53751 | 39.710358 | 2.995148 | 2021-02-27 05:22:28 | Baleares, Spain | ||
1858291 | 1858291 | 2021-02-25 | Spain | Baleares | 55934 | 700 | 1533 | 53701 | 39.710358 | 2.995148 | 2021-02-26 05:22:40 | Baleares, Spain | ||
280469 | 280469 | 2021-02-24 | Spain | Baleares | 55873 | 691 | 1533 | 53649 | 39.710358 | 2.995148 | 2021-02-25 05:24:57 | Baleares, Spain | ||
1936737 | 1936737 | 2021-02-23 | Spain | Baleares | 55802 | 684 | 1533 | 53585 | 39.710358 | 2.995148 | 2021-02-24 05:29:16 | Baleares, Spain | ||
530992 | 530992 | 2021-02-22 | Spain | Baleares | 55751 | 681 | 1533 | 53537 | 39.710358 | 2.995148 | 2021-02-23 05:23:41 | Baleares, Spain | ||
182326 | 182326 | 2021-02-21 | Spain | Baleares | 55559 | 680 | 1533 | 53346 | 39.710358 | 2.995148 | 2021-02-22 05:24:21 | Baleares, Spain | ||
742600 | 742600 | 2021-02-20 | Spain | Baleares | 55559 | 680 | 1533 | 53346 | 39.710358 | 2.995148 | 2021-02-21 05:24:33 | Baleares, Spain | ||
471698 | 471698 | 2021-02-19 | Spain | Baleares | 55559 | 680 | 1533 | 53346 | 39.710358 | 2.995148 | 2021-02-20 05:22:51 | Baleares, Spain | ||
1153407 | 1153407 | 2021-02-18 | Spain | Baleares | 55467 | 677 | 1533 | 53257 | 39.710358 | 2.995148 | 2021-02-19 05:24:16 | Baleares, Spain | ||
3601327 | 3601327 | 2021-02-17 | Spain | Baleares | 55349 | 674 | 1533 | 53142 | 39.710358 | 2.995148 | 2021-02-18 05:22:58 | Baleares, Spain | ||
3050462 | 3050462 | 2021-02-16 | Spain | Baleares | 55220 | 672 | 1533 | 53015 | 39.710358 | 2.995148 | 2021-02-17 05:23:10 | Baleares, Spain | ||
1338561 | 1338561 | 2021-02-15 | Spain | Baleares | 55092 | 668 | 1533 | 52891 | 39.710358 | 2.995148 | 2021-02-16 05:24:38 | Baleares, Spain | ||
2283712 | 2283712 | 2021-02-14 | Spain | Baleares | 54731 | 653 | 1533 | 52545 | 39.710358 | 2.995148 | 2021-02-15 05:24:49 | Baleares, Spain | ||
2678112 | 2678112 | 2021-02-13 | Spain | Baleares | 54731 | 653 | 1533 | 52545 | 39.710358 | 2.995148 | 2021-02-14 05:23:43 | Baleares, Spain | ||
3539745 | 3539745 | 2021-02-12 | Spain | Baleares | 54731 | 653 | 1533 | 52545 | 39.710358 | 2.995148 | 2021-02-13 05:22:12 | Baleares, Spain | ||
2638008 | 2638008 | 2021-02-11 | Spain | Baleares | 54591 | 648 | 1533 | 52410 | 39.710358 | 2.995148 | 2021-02-12 05:23:29 | Baleares, Spain | ||
3978863 | 3978863 | 2021-02-10 | Spain | Baleares | 54429 | 642 | 1533 | 52254 | 39.710358 | 2.995148 | 2021-02-11 05:23:55 | Baleares, Spain | ||
1528183 | 1528183 | 2021-02-09 | Spain | Baleares | 54248 | 637 | 1533 | 52078 | 39.710358 | 2.995148 | 2021-02-10 05:22:41 | Baleares, Spain | ||
613974 | 613974 | 2021-02-08 | Spain | Baleares | 54083 | 631 | 1533 | 51919 | 39.710358 | 2.995148 | 2021-02-09 05:23:30 | Baleares, Spain | ||
1672743 | 1672743 | 2021-02-07 | Spain | Baleares | 53584 | 622 | 1533 | 51429 | 39.710358 | 2.995148 | 2021-02-08 05:22:39 | Baleares, Spain | ||
975204 | 975204 | 2021-02-06 | Spain | Baleares | 53584 | 622 | 1533 | 51429 | 39.710358 | 2.995148 | 2021-02-07 05:23:00 | Baleares, Spain | ||
1588462 | 1588462 | 2021-02-05 | Spain | Baleares | 53584 | 622 | 1533 | 51429 | 39.710358 | 2.995148 | 2021-02-06 05:23:55 | Baleares, Spain | ||
790669 | 790669 | 2021-02-04 | Spain | Baleares | 53343 | 617 | 1533 | 51193 | 39.710358 | 2.995148 | 2021-02-05 05:22:38 | Baleares, Spain | ||
340561 | 340561 | 2021-02-03 | Spain | Baleares | 53027 | 609 | 1533 | 50885 | 39.710358 | 2.995148 | 2021-02-04 05:22:26 | Baleares, Spain | ||
1684787 | 1684787 | 2021-02-02 | Spain | Baleares | 52706 | 603 | 1533 | 50570 | 39.710358 | 2.995148 | 2021-02-03 05:22:52 | Baleares, Spain | ||
1676757 | 1676757 | 2021-02-01 | Spain | Baleares | 52490 | 590 | 1533 | 50367 | 39.710358 | 2.995148 | 2021-02-02 05:22:49 | Baleares, Spain | ||
1460045 | 1460045 | 2021-01-31 | Spain | Baleares | 51575 | 577 | 1533 | 49465 | 39.710358 | 2.995148 | 2021-02-01 05:22:53 | Baleares, Spain | ||
2211953 | 2211953 | 2021-01-30 | Spain | Baleares | 51575 | 577 | 1533 | 49465 | 39.710358 | 2.995148 | 2021-01-31 05:22:42 | Baleares, Spain | ||
1897440 | 1897440 | 2021-01-29 | Spain | Baleares | 51575 | 577 | 1533 | 49465 | 39.710358 | 2.995148 | 2021-01-30 05:22:49 | Baleares, Spain | ||
2482256 | 2482256 | 2021-01-28 | Spain | Baleares | 51103 | 571 | 1533 | 48999 | 39.710358 | 2.995148 | 2021-01-29 05:22:23 | Baleares, Spain | ||
3153891 | 3153891 | 2021-01-27 | Spain | Baleares | 50585 | 563 | 1533 | 48489 | 39.710358 | 2.995148 | 2021-01-28 05:22:24 | Baleares, Spain | ||
12626 | 12626 | 2021-01-26 | Spain | Baleares | 50059 | 555 | 1533 | 47971 | 39.710358 | 2.995148 | 2021-01-27 05:23:41 | Baleares, Spain | ||
2567950 | 2567950 | 2021-01-25 | Spain | Baleares | 49610 | 549 | 1533 | 47528 | 39.710358 | 2.995148 | 2021-01-26 05:22:02 | Baleares, 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]);