occ

cluster_num_id
{'link': '/cluster/{value}'}
gbifID
{'link': 'https://gbif.org/occurrence/{value}'}

70 rows where cluster_num_id = 39 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: locality, eventDate, recordedBy, collectorEventDate, eventDate (date)

Link rowid gbifID family scientificName locality decimalLatitude decimalLongitude elevation eventDate catalogNumber recordedBy recordedBy_first_family recordNumber_mainNumber ▼ has_coordinates cluster_num_id collectorNameNumber collectorEventDate
664892 664892 6161176447 Malvaceae Heritiera littoralis Dryand. ex Aiton Usukan to Khota Balud       1915-10-27 barcode-02679272 M. S. Clemens Clemens 9754 False 39 39 Clemens 9754 Clemens 1915-10-27
476591 476591 4853869273 Viscaceae Viscum L. Mount Kinabalu Trip,; Usukan To Khota Balud       1915-10-27T00:00 K004881556 Clemens, M.S. Clemens 9755 False 39 39 Clemens 9755 Clemens 1915-10-27T00:00
437639 437639 4850451682 Euphorbiaceae Microstachys chamaelea (L.) Müll.Arg. Mount Kinabalu Trip; Usukan To Khota Balud       1915-10-27T00:00 K003872452 Clemens, M.S. Clemens 9756 False 39 39 Clemens 9756 Clemens 1915-10-27T00:00
620894 620894 5083371874 Phyllanthaceae Bridelia stipularis (L.) Blume Usukan to Khota Balud       1915-10-27 barcode-02330689 M. S. Clemens Clemens 9761 False 39 39 Clemens 9761 Clemens 1915-10-27
603737 603737 5106880759 Lauraceae Litsea Lam. Usukan to Khota Balud       1915-10-27 barcode-02510367 J. Clemens & M. S. Clemens Clemens 9765 False 39 39 Clemens 9765 Clemens 1915-10-27
647025 647025 4014188313 Vitaceae Ampelocissus ochracea (Teijsm. & Binn.) Merr. Khota Balud to Kibayo       1915-10-28 barcode-02329574 M. S. Clemens Clemens 9767 False 39 39 Clemens 9767 Clemens 1915-10-28
649505 649505 5105312493 Meliaceae Trichilia connaroides (Wight & Arn.) Bentv. Khota Balud to Kibayo       1915-10-28 barcode-02653590 M. S. Clemens Clemens 9768 False 39 39 Clemens 9768 Clemens 1915-10-28
651079 651079 3961876413 Euphorbiaceae Acalypha amentacea Roxb. Khota Balud to Kibayo       1915-10-28 barcode-01767591 M. S. Clemens Clemens 9769 False 39 39 Clemens 9769 Clemens 1915-10-28
344826 344826 4849340431 Poaceae Panicum sarmentosum Roxb. Khota Balud To Kibayo       1915-10-28T00:00 K003369038 Clemens, M.S. Clemens 9770 False 39 39 Clemens 9770 Clemens 1915-10-28T00:00
639609 639609 4900312982 Poaceae Panicum sarmentosum Roxb. Khota Balud to Kibayo.       1915-10-28 barcode-02471970 M. S. Clemens Clemens 9770 False 39 39 Clemens 9770 Clemens 1915-10-28
617600 617600 4954814263 Phyllanthaceae Antidesma montanum Blume Khota Balud to Kibayo       1915-10-28 barcode-02475521 M. S. Clemens Clemens 9772 False 39 39 Clemens 9772 Clemens 1915-10-28
646523 646523 4950629520 Melastomataceae Dissochaeta celebica Blume Khota Balud to Kibayo       1915-10-28 barcode-02270620 M. S. Clemens Clemens 9773 False 39 39 Clemens 9773 Clemens 1915-10-28
304139 304139 5089816283 Asteraceae Mikania cordata (Burm.fil.) B.L.Rob. Mount Kinabalu. Khota Balud to Kibayo. British North Borneo       1915-10-28T00:00 K003179071 Clemens, M.S. Clemens 9774 False 39 39 Clemens 9774 Clemens 1915-10-28T00:00
615726 615726 4927357106 Primulaceae Maesa ramentacea (Roxb.) A.DC. Khota Balud to Kibayo       1915-10-28 barcode-02442734 J. Clemens & M. S. Clemens Clemens 9775 False 39 39 Clemens 9775 Clemens 1915-10-28
265932 265932 5130182667 Annonaceae Mitrella kentii (Blume) Miq. Mount Kinabalu; Khota Balud To Kibayo       1915-10-28T00:00 K003818042 Clemens, M.S. Clemens 9776 False 39 39 Clemens 9776 Clemens 1915-10-28T00:00
673680 673680 4878453289 Poaceae Pogonatherum paniceum (Lam.) Hack. Khota Balud to Kibayo.       1915-10-28 barcode-02470182 M. S. Clemens Clemens 9780 False 39 39 Clemens 9780 Clemens 1915-10-28
635880 635880 1998695267 Actinidiaceae Saurauia oblanceolata Merr. Khota Balud to Kibayo, Mount Kinabalu       1915-10-28 barcode-00098250 M. S. Clemens Clemens 9784 False 39 39 Clemens 9784 Clemens 1915-10-28
639887 639887 1998460568 Actinidiaceae Saurauia oblancifolia Merr. Khota Balud to Kibayo, Mount Kinabalu       1915-10-28 barcode-00098261 M. S. Clemens Clemens 9784 False 39 39 Clemens 9784 Clemens 1915-10-28
667839 667839 1999396121 Actinidiaceae Saurauia oblanceolata Merr. Khota Balud to Kibayo, Mount Kinabalu       1915-10-28 barcode-00098264 M. S. Clemens Clemens 9784 False 39 39 Clemens 9784 Clemens 1915-10-28
672257 672257 1998661702 Actinidiaceae Saurauia oblancifolia Merr. Khota Balud to Kibayo, Mount Kinabalu       1915-10-28 barcode-00098262 M. S. Clemens Clemens 9784 False 39 39 Clemens 9784 Clemens 1915-10-28
648457 648457 1998491292 Malvaceae Colona borneensis (Merr.) Burret Khota Balud to Kibayo       1915-10-28 barcode-00052299 M. S. Clemens Clemens 9786 False 39 39 Clemens 9786 Clemens 1915-10-28
642317 642317 5062415418 Fabaceae Saraca indica L. Khota Balud to Kibayo       1915-10-28 barcode-02304634 M. S. Clemens Clemens 9788 False 39 39 Clemens 9788 Clemens 1915-10-28
245910 245910 2534099457 Gleicheniaceae Dicranopteris linearis var. subspeciosa Holttum Mount Kinabalu, Khota Blaud to Kibayu       1915-10-28 1589673 Mary Strong Clemens Clemens 9789 False 39 39 Clemens 9789 Clemens 1915-10-28
244608 244608 1989048618 Pteridaceae Antrophyum parvulum Blume Khota Balud to Kibayo       1915-10-28 1162203 Mary S. Clemens Clemens 9790 False 39 39 Clemens 9790 Clemens 1915-10-28
246836 246836 3446894497 Pteridaceae Adiantum stenochlamys Baker Khota Balud to Kibayo       1915-10-28 1225436 Mary Strong Clemens Clemens 9793 False 39 39 Clemens 9793 Clemens 1915-10-28
448946 448946 5072754187 Poaceae Coelorachis glandulosa (Trin.) Stapf ex Ridl. Mount Kinabalu Trip; Khota Balud to Kibayo       1915-10-28T00:00 K002700385 Clemens, M.S. Clemens 9799 False 39 39 Clemens 9799 Clemens 1915-10-28T00:00
643332 643332 4037222421 Apocynaceae Tabernaemontana macrocarpa Jack Khota Balud to Kibayo       1915-10-28 barcode-02372482 M. S. Clemens Clemens 9809 False 39 39 Clemens 9809 Clemens 1915-10-28
660956 660956 1999016142 Actinidiaceae Saurauia heterosepala Merr. Mt. Kinabalu, Khota Balud to Kibayo       1915-10-28 barcode-00098179 M. S. Clemens Clemens 9812 False 39 39 Clemens 9812 Clemens 1915-10-28
624415 624415 4527894682 Lamiaceae Vitex vestita Wall. ex Walp. Khota Balud to Kibayo       1915-10-28 barcode-02526603 M. S. Clemens Clemens 9813 False 39 39 Clemens 9813 Clemens 1915-10-28
673103 673103 1998957996 Rubiaceae Timonius heterophyllus Merr. Mount Kinabalu, Khota Balud to Kibayo       1915-10-28 barcode-00312907 M. S. Clemens Clemens 9814 False 39 39 Clemens 9814 Clemens 1915-10-28
643872 643872 6061898994 Melastomataceae Medinilla Gaudich. Khota Balud to Kibayo       1915-10-28 barcode-02271393 M. S. Clemens Clemens 9815 False 39 39 Clemens 9815 Clemens 1915-10-28
624156 624156 4950629457 Melastomataceae Dissochaeta annulata Hook.fil. ex Triana Khota Balud to Kibayo       1915-10-28 barcode-02270567 M. S. Clemens Clemens 9816 False 39 39 Clemens 9816 Clemens 1915-10-28
640518 640518 4527883548 Clethraceae Clethra canescens var. clementis (Merr.) Sleumer Kibayo to Keung       1915-10-29 barcode-02521276 M. S. Clemens Clemens 9826 False 39 39 Clemens 9826 Clemens 1915-10-29
652334 652334 4849732674 Pentaphylacaceae Eurya trichocarpa Korth. Kibayo to Keung       1915-10-29 barcode-02524453 M. S. Clemens Clemens 9827 False 39 39 Clemens 9827 Clemens 1915-10-29
337092 337092 5004317967 Primulaceae Embelia dasythyrsa Miq. Mount Kinabalu Trip; Kibayo To Keung       1915-10-29T00:00 K001099682 Clemens, M.S. Clemens 9828 False 39 39 Clemens 9828 Clemens 1915-10-29T00:00
620442 620442 4920710842 Primulaceae Embelia dasythyrsa Miq. Kibayo to Keung       1915-10-29 barcode-02441791 M. S. Clemens Clemens 9828 False 39 39 Clemens 9828 Clemens 1915-10-29
669517 669517 4920710761 Primulaceae Embelia dasythyrsa Miq. Kibayo to Keung       1915-10-29 barcode-02441783 M. S. Clemens Clemens 9828 False 39 39 Clemens 9828 Clemens 1915-10-29
632574 632574 4939439347 Asteraceae Vernonia arborea Buch.-Ham. Kibayo to Keung.       1915-10-29 barcode-02247990 M. S. Clemens Clemens 9832 False 39 39 Clemens 9832 Clemens 1915-10-29
627147 627147 5105310625 Meliaceae Trichilia connaroides (Wight & Arn.) Bentv. Kibayo to Keung       1915-10-29 barcode-02653593 M. S. Clemens Clemens 9833 False 39 39 Clemens 9833 Clemens 1915-10-29
327494 327494 4926497957 Campanulaceae Codonopsis lancifolia subsp. celebica (Blume) Moeliono Mount Kinabalu Trip; Kibayo To Keung       1915-10-29T00:00 K004855065 Clemens, M.S. Clemens 9834 False 39 39 Clemens 9834 Clemens 1915-10-29T00:00
654332 654332 4527864864 Rhamnaceae Alphitonia excelsa (Fenzl) Reissek ex Endl. Kibayo to Keung       1915-10-29 barcode-02553549 M. S. Clemens Clemens 9836 False 39 39 Clemens 9836 Clemens 1915-10-29
651809 651809 5285073242 Urticaceae Oreocnide trinervis (Wedd.) Miq. Kibayo to Keung       1915-10-29 barcode-02663084 M. S. Clemens Clemens 9837 False 39 39 Clemens 9837 Clemens 1915-10-29
327676 327676 4873796181 Rhizophoraceae Gynotroches axillaris Blume Mount Kinabalu Trip; Kibayo to Keung       1915-10-29T00:00 K004632771 Clemens, M.S. Clemens 9845 False 39 39 Clemens 9845 Clemens 1915-10-29T00:00
614303 614303 5029072974 Rhizophoraceae Gynotroches axillaris Blume Kibayo to Keung       1915-10-29 barcode-02263182 M. S. Clemens Clemens 9845 False 39 39 Clemens 9845 Clemens 1915-10-29
644521 644521 1999319694 Lamiaceae Callicarpa fulvohirsuta Merr. Kibayo to Keung       1915-10-29 barcode-00093705 M. S. Clemens Clemens 9846 False 39 39 Clemens 9846 Clemens 1915-10-29
298644 298644 4853917722 Hypericaceae Hypericum japonicum Thunb. Mount Kinabalu Trip, Kibayo to Keung       1915-10-29T00:00 K002128386 Clemens, M.S. Clemens 9847 False 39 39 Clemens 9847 Clemens 1915-10-29T00:00
479424 479424 5077798839 Convolvulaceae Jacquemontia tomentella var. micrantha Hallier fil. Mount Kinabalu; Kibayo To Keung       1915-10-29T00:00 K001757257 Clemens, M.S. Clemens 9848 False 39 39 Clemens 9848 Clemens 1915-10-29T00:00
622415 622415 4920710707 Convolvulaceae Jacquemontia tomentella var. micrantha Hallier fil. Kibayo to Keung       1915-10-29 barcode-02422964 M. S. Clemens Clemens 9848 False 39 39 Clemens 9848 Clemens 1915-10-29
617675 617675 6180064740 Malvaceae Melochia umbellata (Houtt.) Stapf Kibayo to Keung       1915-10-29 barcode-02679907 M. S. Clemens Clemens 9850 False 39 39 Clemens 9850 Clemens 1915-10-29
627192 627192 6061898251 Rubiaceae Urophyllum glabrum Jack ex Wall. Kibayo to Keung       1915-10-29 barcode-02332192 M. S. Clemens Clemens 9853 False 39 39 Clemens 9853 Clemens 1915-10-29
636406 636406 5917413378 Rubiaceae Tarennoidea wallichii (Hook.f.) Tirveng. & Sastre Kibayo to Keung       1915-10-29 barcode-02306674 M. S. Clemens Clemens 9854 False 39 39 Clemens 9854 Clemens 1915-10-29
631270 631270 5843775849 Actinidiaceae Saurauia amoena Stapf Kibayo to Keung       1915-10-29 barcode-02667975 M. S. Clemens Clemens 9856 False 39 39 Clemens 9856 Clemens 1915-10-29
657284 657284 5843776515 Actinidiaceae Saurauia amoena Stapf Kibayo to Keung       1915-10-29 barcode-02667976 M. S. Clemens Clemens 9856 False 39 39 Clemens 9856 Clemens 1915-10-29
605903 605903 4527900363 Clethraceae Clethra canescens var. clementis (Merr.) Sleumer Kibayo to Keung       1915-10-29 barcode-02521275 M. S. Clemens Clemens 9859 False 39 39 Clemens 9859 Clemens 1915-10-29
664849 664849 6180060392 Pandaceae Galearia Zoll. & Moritzi Kibayo to Keung       1915-10-29 barcode-02298241 M. S. Clemens Clemens 9862 False 39 39 Clemens 9862 Clemens 1915-10-29
646869 646869 5917413652 Rubiaceae Aidia borneensis Ridsdale Kibayo to Keung       1915-10-29 barcode-02635315 M. S. Clemens Clemens 9863 False 39 39 Clemens 9863 Clemens 1915-10-29
658942 658942 4953242291 Melastomataceae Dissochaeta viminalis (Jack) Clausing Kibayo to Keung       1915-10-29 barcode-02270871 M. S. Clemens Clemens 9864 False 39 39 Clemens 9864 Clemens 1915-10-29
491584 491584 1931040833 Arecaceae Daemonorops Blume ex Schult.f., 1830 Kibayo to Deung. British North Borneo.       1915-10-29 02320744 M. S. Clemens Clemens 9867 False 39 39 Clemens 9867 Clemens 1915-10-29
654025 654025 5083373560 Rubiaceae Uncaria cordata (Lour.) Merr. Kibayo to Keung       1915-10-29 barcode-02474131 M. S. Clemens Clemens 9870 False 39 39 Clemens 9870 Clemens 1915-10-29
244019 244019 1988876606 Pteridaceae Antrophyum callifolium Blume Kibayo to Keung       1915-10-29 1162086 Mary S. Clemens Clemens 9872 False 39 39 Clemens 9872 Clemens 1915-10-29
348170 348170 4858975720 Melastomataceae Pternandra azurea var. azurea Mount Kinabalu Trip; Kibayo To Keung       1915-10-29T00:00 K003524857 Clemens, M.S. Clemens 9875 False 39 39 Clemens 9875 Clemens 1915-10-29T00:00
609952 609952 5083371010 Melastomataceae Pternandra coerulescens Jack Kibayo to Keung       1915-10-29 barcode-02515364 M. S. Clemens Clemens 9875 False 39 39 Clemens 9875 Clemens 1915-10-29
342893 342893 4850427179 Euphorbiaceae Macaranga costulata Pax & K.Hoffm. Mount Kinabalu Trip; Kibayo to Keung       1915-10-29T00:00 K003493474 Clemens, M.S. Clemens 9879 False 39 39 Clemens 9879 Clemens 1915-10-29T00:00
637510 637510 4527900678 Euphorbiaceae Macaranga costulata Pax & K.Hoffm. Kibayo to Keung       1915-10-29 barcode-02559897 M. S. Clemens Clemens 9879 False 39 39 Clemens 9879 Clemens 1915-10-29
668748 668748 4527899728 Euphorbiaceae Macaranga costulata Pax & K.Hoffm. Kibayo to Keung       1915-10-29 barcode-02559896 M. S. Clemens Clemens 9879 False 39 39 Clemens 9879 Clemens 1915-10-29
644211 644211 1999300698 Sapindaceae Otophora anomala Radlk. Kibayo-Keung       1915-10-29 barcode-00050862 M. S. Clemens Clemens 9880 False 39 39 Clemens 9880 Clemens 1915-10-29
623209 623209 1998844259 Plantaginaceae Brookea albicans Stapf Mount Kinabalu Trip, Kibayo to Keung       1915-10-29 barcode-00273055 M. S. Clemens Clemens 9881 False 39 39 Clemens 9881 Clemens 1915-10-29
622398 622398 4536378409 Pentaphylacaceae Adinandra collina Kobuski Kibayo to Keung       1915-10-29 barcode-02520567 M. S. Clemens Clemens 9882 False 39 39 Clemens 9882 Clemens 1915-10-29
645617 645617 4536373357 Pentaphylacaceae Adinandra collina Kobuski Kibayo to Keung       1915-10-29 barcode-02520552 M. S. Clemens Clemens 9882 False 39 39 Clemens 9882 Clemens 1915-10-29
666438 666438 6061903214 Rubiaceae Timonius borneensis Valeton Kibayo to Keung       1915-10-29 barcode-02638174 M. S. Clemens Clemens 9883 False 39 39 Clemens 9883 Clemens 1915-10-29

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "occ" (
   [gbifID] INTEGER,
   [family] TEXT,
   [scientificName] TEXT,
   [locality] TEXT,
   [decimalLatitude] FLOAT,
   [decimalLongitude] FLOAT,
   [elevation] TEXT,
   [eventDate] TEXT,
   [catalogNumber] TEXT,
   [recordedBy] TEXT,
   [recordedBy_first_family] TEXT,
   [recordNumber_mainNumber] INTEGER,
   [has_coordinates] TEXT,
   [cluster_num_id] INTEGER REFERENCES [cluster]([cluster_num_id]),
   [collectorNameNumber] TEXT,
   [collectorEventDate] TEXT
);
CREATE INDEX [idx_occ_cluster_num_id]
    ON [occ] ([cluster_num_id]);