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 admin2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423641 | 423641 | 2021-10-10 | Spain | Baleares | 99666 | 964 | 0 | 39.710358 | 2.995148 | 2021-10-11 04:21:31 | Baleares, Spain | |||
427618 | 427618 | 2020-09-07 | Spain | Baleares | 9501 | 245 | 1533 | 7723 | 39.710358 | 2.995148 | 2020-09-08 04:28:25 | Baleares, Spain | ||
431651 | 431651 | 2022-11-03 | Spain | Baleares | 310930 | 1585 | 0 | 39.710358 | 2.995148 | 2022-11-04 04:22:11 | Baleares, Spain | |||
435642 | 435642 | 2021-01-21 | Spain | Baleares | 47359 | 538 | 1533 | 45288 | 39.710358 | 2.995148 | 2021-01-22 05:22:10 | Baleares, Spain | ||
442341 | 442341 | 2020-07-26 | Spain | Baleares | 2343 | 224 | 1533 | 586 | 39.710358 | 2.995148 | 2020-07-27 04:35:02 | Baleares, Spain | ||
443645 | 443645 | 2021-10-20 | Spain | Baleares | 100224 | 979 | 0 | 39.710358 | 2.995148 | 2021-10-21 04:21:18 | Baleares, Spain | |||
447661 | 447661 | 2021-11-17 | Spain | Baleares | 102936 | 1011 | 0 | 39.710358 | 2.995148 | 2021-11-18 04:21:33 | Baleares, Spain | |||
451681 | 451681 | 2022-12-21 | Spain | Baleares | 312814 | 1605 | 0 | 39.710358 | 2.995148 | 2022-12-22 04:20:56 | Baleares, Spain | |||
458366 | 458366 | 2020-08-07 | Spain | Baleares | 3051 | 224 | 1533 | 1294 | 39.710358 | 2.995148 | 2020-08-08 04:34:53 | Baleares, Spain | ||
459670 | 459670 | 2022-02-02 | Spain | Baleares | 232463 | 1135 | 0 | 39.710358 | 2.995148 | 2022-02-03 04:21:21 | Baleares, Spain | |||
463687 | 463687 | 2022-05-02 | Spain | Baleares | 282058 | 1341 | 0 | 39.710358 | 2.995148 | 2022-05-03 04:21:00 | Baleares, Spain | |||
467702 | 467702 | 2021-10-07 | Spain | Baleares | 99620 | 962 | 0 | 39.710358 | 2.995148 | 2021-10-08 04:21:25 | 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 | ||
475734 | 475734 | 2022-06-26 | Spain | Baleares | 295705 | 1421 | 0 | 39.710358 | 2.995148 | 2022-06-27 04:21:00 | Baleares, Spain | |||
479884 | 479884 | 2022-11-08 | Spain | Baleares | 311162 | 1587 | 0 | 39.710358 | 2.995148 | 2022-11-09 04:21:22 | Baleares, Spain | |||
483879 | 483879 | 2021-07-19 | Spain | Baleares | 70924 | 847 | 1533 | 68544 | 39.710358 | 2.995148 | 2021-07-20 04:21:48 | Baleares, Spain | ||
487914 | 487914 | 2022-11-25 | Spain | Baleares | 312070 | 1601 | 0 | 39.710358 | 2.995148 | 2022-11-26 04:21:11 | Baleares, Spain | |||
491926 | 491926 | 2021-10-14 | Spain | Baleares | 99944 | 969 | 0 | 39.710358 | 2.995148 | 2021-10-15 04:21:26 | Baleares, Spain | |||
495942 | 495942 | 2021-11-06 | Spain | Baleares | 101465 | 1004 | 0 | 39.710358 | 2.995148 | 2021-11-07 04:21:53 | Baleares, Spain | |||
499959 | 499959 | 2022-04-02 | Spain | Baleares | 267638 | 1266 | 0 | 39.710358 | 2.995148 | 2022-04-03 04:20:48 | Baleares, Spain | |||
503978 | 503978 | 2022-12-17 | Spain | Baleares | 312814 | 1605 | 0 | 39.710358 | 2.995148 | 2022-12-18 04:21:03 | Baleares, Spain | |||
507973 | 507973 | 2021-08-14 | Spain | Baleares | 90816 | 881 | 0 | 39.710358 | 2.995148 | 2021-08-15 04:21:41 | Baleares, Spain | |||
511987 | 511987 | 2021-08-19 | Spain | Baleares | 93193 | 893 | 0 | 39.710358 | 2.995148 | 2021-08-20 04:21:33 | Baleares, Spain | |||
516022 | 516022 | 2022-10-15 | Spain | Baleares | 310086 | 1562 | 0 | 39.710358 | 2.995148 | 2022-10-16 04:22:39 | Baleares, Spain | |||
523144 | 523144 | 2021-06-09 | Spain | Baleares | 60804 | 840 | 1533 | 58431 | 39.710358 | 2.995148 | 2021-06-10 04:23:17 | Baleares, Spain | ||
529725 | 529725 | 2020-07-04 | Spain | Baleares | 2228 | 224 | 1533 | 471 | 39.710358 | 2.995148 | 2020-07-05 04:33:46 | 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 | ||
535026 | 535026 | 2021-10-27 | Spain | Baleares | 100734 | 995 | 0 | 39.710358 | 2.995148 | 2021-10-28 04:22:08 | Baleares, Spain | |||
539046 | 539046 | 2022-10-26 | Spain | Baleares | 310525 | 1576 | 0 | 39.710358 | 2.995148 | 2022-10-27 04:22:01 | Baleares, Spain | |||
543062 | 543062 | 2022-12-15 | Spain | Baleares | 312622 | 1604 | 0 | 39.710358 | 2.995148 | 2022-12-16 04:21:01 | Baleares, Spain | |||
547035 | 547035 | 2020-09-12 | Spain | Baleares | 10729 | 258 | 1533 | 8938 | 39.710358 | 2.995148 | 2020-09-13 04:30:52 | Baleares, Spain | ||
551064 | 551064 | 2021-12-08 | Spain | Baleares | 108183 | 1028 | 0 | 39.710358 | 2.995148 | 2021-12-09 04:22:49 | Baleares, Spain | |||
555080 | 555080 | 2022-01-16 | Spain | Baleares | 174044 | 1082 | 0 | 39.710358 | 2.995148 | 2022-01-17 04:21:08 | Baleares, Spain | |||
559098 | 559098 | 2022-06-16 | Spain | Baleares | 291922 | 1407 | 0 | 39.710358 | 2.995148 | 2022-06-17 04:20:56 | Baleares, Spain | |||
563256 | 563256 | 2021-06-22 | Spain | Baleares | 61283 | 844 | 1533 | 58906 | 39.710358 | 2.995148 | 2021-06-23 04:21:46 | Baleares, Spain | ||
567394 | 567394 | 2021-10-29 | Spain | Baleares | 100887 | 996 | 0 | 39.710358 | 2.995148 | 2021-10-30 04:22:03 | Baleares, Spain | |||
573871 | 573871 | 2020-06-06 | Spain | Baleares | 2118 | 209 | 1533 | 376 | 39.710358 | 2.995148 | 2020-06-07 03:53:30 | Baleares, Spain | ||
575123 | 575123 | 2022-02-25 | Spain | Baleares | 253142 | 1209 | 0 | 39.710358 | 2.995148 | 2022-02-26 04:21:12 | Baleares, Spain | |||
579121 | 579121 | 2021-07-13 | Spain | Baleares | 66591 | 844 | 1533 | 64214 | 39.710358 | 2.995148 | 2021-07-14 04:21:35 | Baleares, Spain | ||
583113 | 583113 | 2020-08-13 | Spain | Baleares | 4044 | 225 | 1533 | 2286 | 39.710358 | 2.995148 | 2020-08-14 04:51:19 | Baleares, Spain | ||
589917 | 589917 | 2021-08-08 | Spain | Baleares | 87010 | 875 | 0 | 39.710358 | 2.995148 | 2021-08-09 04:21:24 | Baleares, Spain | |||
593950 | 593950 | 2022-07-01 | Spain | Baleares | 298460 | 1425 | 0 | 39.710358 | 2.995148 | 2022-07-02 04:21:16 | Baleares, Spain | |||
597964 | 597964 | 2021-10-19 | Spain | Baleares | 100155 | 970 | 0 | 39.710358 | 2.995148 | 2021-10-20 04:21:00 | Baleares, Spain | |||
601980 | 601980 | 2021-09-23 | Spain | Baleares | 98791 | 956 | 0 | 39.710358 | 2.995148 | 2021-09-24 04:21:44 | 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 | ||
609970 | 609970 | 2020-08-29 | Spain | Baleares | 7648 | 233 | 1533 | 5882 | 39.710358 | 2.995148 | 2020-08-30 04:28:22 | 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 | ||
618156 | 618156 | 2022-11-05 | Spain | Baleares | 311162 | 1587 | 0 | 39.710358 | 2.995148 | 2022-11-06 04:21:24 | Baleares, Spain | |||
622170 | 622170 | 2022-05-22 | Spain | Baleares | 287038 | 1401 | 0 | 39.710358 | 2.995148 | 2022-05-26 04:20:50 | Baleares, Spain | |||
626167 | 626167 | 2021-07-10 | Spain | Baleares | 64853 | 844 | 1533 | 62476 | 39.710358 | 2.995148 | 2021-07-11 04:21:43 | Baleares, Spain | ||
630200 | 630200 | 2022-07-12 | Spain | Baleares | 302178 | 1441 | 0 | 39.710358 | 2.995148 | 2022-07-13 04:20:58 | Baleares, Spain | |||
634214 | 634214 | 2021-10-13 | Spain | Baleares | 99877 | 965 | 0 | 39.710358 | 2.995148 | 2021-10-14 04:21:29 | 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 | ||
642227 | 642227 | 2021-09-07 | Spain | Baleares | 97211 | 928 | 0 | 39.710358 | 2.995148 | 2021-09-08 04:21:31 | Baleares, Spain | |||
646238 | 646238 | 2021-05-05 | Spain | Baleares | 59515 | 824 | 1533 | 57158 | 39.710358 | 2.995148 | 2021-05-06 04:20:38 | Baleares, Spain | ||
650255 | 650255 | 2021-08-09 | Spain | Baleares | 88572 | 875 | 0 | 39.710358 | 2.995148 | 2021-08-10 04:21:27 | Baleares, Spain | |||
654286 | 654286 | 2021-10-22 | Spain | Baleares | 100363 | 992 | 0 | 39.710358 | 2.995148 | 2021-10-23 04:21:32 | Baleares, Spain | |||
658605 | 658605 | 2022-05-13 | Spain | Baleares | 285291 | 1365 | 0 | 39.710358 | 2.995148 | 2022-05-14 04:20:48 | Baleares, Spain | |||
662581 | 662581 | 2020-08-11 | Spain | Baleares | 3501 | 225 | 1533 | 1743 | 39.710358 | 2.995148 | 2020-08-12 04:27:29 | Baleares, Spain | ||
666560 | 666560 | 2020-09-16 | Spain | Baleares | 11452 | 268 | 1533 | 9651 | 39.710358 | 2.995148 | 2020-09-17 04:22:00 | Baleares, Spain | ||
670591 | 670591 | 2022-07-21 | Spain | Baleares | 303788 | 1446 | 0 | 39.710358 | 2.995148 | 2022-07-22 04:21:15 | Baleares, Spain | |||
674607 | 674607 | 2022-07-30 | Spain | Baleares | 305429 | 1473 | 0 | 39.710358 | 2.995148 | 2022-07-31 04:21:02 | Baleares, Spain | |||
678597 | 678597 | 2020-11-23 | Spain | Baleares | 23193 | 398 | 1533 | 21262 | 39.710358 | 2.995148 | 2020-11-24 05:27:31 | Baleares, Spain | ||
682631 | 682631 | 2021-10-24 | Spain | Baleares | 100363 | 992 | 0 | 39.710358 | 2.995148 | 2021-10-25 04:22:31 | Baleares, Spain | |||
686647 | 686647 | 2021-11-13 | Spain | Baleares | 102176 | 1011 | 0 | 39.710358 | 2.995148 | 2021-11-14 04:21:31 | Baleares, Spain | |||
690667 | 690667 | 2022-12-23 | Spain | Baleares | 313228 | 1607 | 0 | 39.710358 | 2.995148 | 2022-12-24 04:21:02 | Baleares, Spain | |||
694680 | 694680 | 2022-03-17 | Spain | Baleares | 259590 | 1231 | 0 | 39.710358 | 2.995148 | 2022-03-18 04:20:55 | Baleares, Spain | |||
698695 | 698695 | 2021-11-04 | Spain | Baleares | 101379 | 1004 | 0 | 39.710358 | 2.995148 | 2021-11-05 04:21:54 | 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 | ||
706725 | 706725 | 2021-09-29 | Spain | Baleares | 99234 | 959 | 0 | 39.710358 | 2.995148 | 2021-09-30 04:21:20 | Baleares, Spain | |||
710744 | 710744 | 2022-11-01 | Spain | Baleares | 310930 | 1585 | 0 | 39.710358 | 2.995148 | 2022-11-02 04:22:09 | Baleares, Spain | |||
714756 | 714756 | 2021-11-12 | Spain | Baleares | 102176 | 1011 | 0 | 39.710358 | 2.995148 | 2021-11-13 04:21:38 | Baleares, Spain | |||
718776 | 718776 | 2022-12-04 | Spain | Baleares | 312379 | 1603 | 0 | 39.710358 | 2.995148 | 2022-12-05 04:20:58 | Baleares, Spain | |||
722788 | 722788 | 2021-11-20 | Spain | Baleares | 103301 | 1012 | 0 | 39.710358 | 2.995148 | 2021-11-21 04:22:13 | Baleares, Spain | |||
726784 | 726784 | 2021-05-22 | Spain | Baleares | 60137 | 839 | 1533 | 57765 | 39.710358 | 2.995148 | 2021-05-23 04:20:51 | Baleares, Spain | ||
730818 | 730818 | 2021-12-27 | Spain | Baleares | 123414 | 1050 | 0 | 39.710358 | 2.995148 | 2021-12-28 04:21:47 | Baleares, Spain | |||
737322 | 737322 | 2020-06-12 | Spain | Baleares | 2146 | 209 | 1533 | 404 | 39.710358 | 2.995148 | 2020-06-13 03:33:14 | Baleares, Spain | ||
738586 | 738586 | 2020-12-02 | Spain | Baleares | 24803 | 413 | 1533 | 22857 | 39.710358 | 2.995148 | 2020-12-03 05:28:22 | 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 | ||
746635 | 746635 | 2022-04-23 | Spain | Baleares | 279901 | 1296 | 0 | 39.710358 | 2.995148 | 2022-04-24 04:20:56 | Baleares, Spain | |||
753320 | 753320 | 2020-08-01 | Spain | Baleares | 2545 | 224 | 1533 | 788 | 39.710358 | 2.995148 | 2020-08-02 04:34:47 | Baleares, Spain | ||
754586 | 754586 | 2020-10-28 | Spain | Baleares | 17852 | 357 | 1533 | 15962 | 39.710358 | 2.995148 | 2020-10-29 04:24:49 | Baleares, Spain | ||
758618 | 758618 | 2021-11-26 | Spain | Baleares | 104803 | 1021 | 0 | 39.710358 | 2.995148 | 2021-11-27 04:22:45 | Baleares, Spain | |||
762597 | 762597 | 2020-10-18 | Spain | Baleares | 15822 | 327 | 1533 | 13962 | 39.710358 | 2.995148 | 2020-10-19 04:24:16 | Baleares, Spain | ||
766605 | 766605 | 2020-12-29 | Spain | Baleares | 34426 | 458 | 1533 | 32435 | 39.710358 | 2.995148 | 2020-12-30 05:22:34 | Baleares, Spain | ||
770639 | 770639 | 2021-10-23 | Spain | Baleares | 100363 | 992 | 0 | 39.710358 | 2.995148 | 2021-10-24 04:21:22 | Baleares, Spain | |||
774633 | 774633 | 2021-01-12 | Spain | Baleares | 41816 | 497 | 1533 | 39786 | 39.710358 | 2.995148 | 2021-01-13 05:22:15 | Baleares, Spain | ||
778650 | 778650 | 2021-07-08 | Spain | Baleares | 64396 | 844 | 1533 | 62019 | 39.710358 | 2.995148 | 2021-07-09 04:21:21 | Baleares, Spain | ||
782681 | 782681 | 2021-12-13 | Spain | Baleares | 111032 | 1034 | 0 | 39.710358 | 2.995148 | 2021-12-14 04:22:38 | Baleares, Spain | |||
786660 | 786660 | 2020-10-15 | Spain | Baleares | 15697 | 325 | 1533 | 13839 | 39.710358 | 2.995148 | 2020-10-16 04:24:01 | 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 | ||
794708 | 794708 | 2022-10-24 | Spain | Baleares | 310525 | 1576 | 0 | 39.710358 | 2.995148 | 2022-10-25 04:21:53 | Baleares, Spain | |||
798720 | 798720 | 2021-12-22 | Spain | Baleares | 118236 | 1043 | 0 | 39.710358 | 2.995148 | 2021-12-23 04:21:21 | Baleares, Spain | |||
805183 | 805183 | 2020-06-01 | Spain | Baleares | 2142 | 209 | 1533 | 400 | 39.710358 | 2.995148 | 2020-06-02 02:33:08 | Baleares, Spain | ||
809865 | 809865 | 2021-09-20 | Spain | Baleares | 98549 | 948 | 0 | 39.710358 | 2.995148 | 2021-09-21 04:21:26 | Baleares, Spain | |||
813858 | 813858 | 2020-09-05 | Spain | Baleares | 9191 | 243 | 1533 | 7415 | 39.710358 | 2.995148 | 2020-09-06 04:28:33 | Baleares, Spain | ||
817849 | 817849 | 2020-10-09 | Spain | Baleares | 14975 | 316 | 1533 | 13126 | 39.710358 | 2.995148 | 2020-10-10 04:23:57 | Baleares, Spain | ||
821855 | 821855 | 2020-11-19 | Spain | Baleares | 22581 | 398 | 1533 | 20650 | 39.710358 | 2.995148 | 2020-11-20 05:26:28 | Baleares, Spain | ||
825870 | 825870 | 2021-06-06 | Spain | Baleares | 60619 | 839 | 1533 | 58247 | 39.710358 | 2.995148 | 2021-06-07 04:22:51 | Baleares, Spain | ||
829886 | 829886 | 2021-07-09 | Spain | Baleares | 64853 | 844 | 1533 | 62476 | 39.710358 | 2.995148 | 2021-07-10 04:21:25 | 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]);