occ

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

55 rows where cluster_num_id = 21 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, decimalLatitude, decimalLongitude, elevation, recordedBy, has_coordinates, 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
496932 496932 2239571406 Orchidaceae Coelogyne cuprea H.Wendl. & Kraenzl. Mount Kinabalu, B. N. Borneo, Upper Kinabalu       1932-05-19 04027455 J. Clemens Clemens 30015 False 21 21 Clemens 30015 Clemens 1932-05-19
670553 670553 3500142325 Orchidaceae Coelogyne planiscapa Carr B. N. Borneo; Silau Basin       1932-05-19 barcode-02093213 J. Clemens & M. S. Clemens Clemens 30015 False 21 21 Clemens 30015 Clemens 1932-05-19
651669 651669 3887806306 Orchidaceae Bulbophyllum montense Ridl. Silau Basin       1932-04-09 barcode-02386983 J. Clemens & M. S. Clemens Clemens 30016 False 21 21 Clemens 30016 Clemens 1932-04-09
359248 359248 4953997012 Myricaceae Myrica javanica Reinw. ex Blume Mount Kinabalu; Upper Kinabalu       1932-06-03T00:00 K004052002 Clemens, J.; Clemens, M.S. Clemens 30024 False 21 21 Clemens 30024 Clemens 1932-06-03T00:00
670964 670964 5161624304 Myricaceae Morella javanica (Blume) I.M.Turner Upper Kinabalu       1932-06-03 barcode-02658487 J. Clemens & M. S. Clemens Clemens 30024 False 21 21 Clemens 30024 Clemens 1932-06-03
376036 376036 912672555 Lamiaceae Coleus galeatus (Vahl) Benth. Kinabalu. Tenompok 6.0 116.516667 1525.0 1932-03-17T00:00 K000897608 Clemens, J.; Clemens, M.S. Clemens 30028 True 21 21 Clemens 30028 Clemens 1932-03-17T00:00
636447 636447 5896723339 Lamiaceae Coleus galeatus (Vahl) Benth. Mount Kinabalu; B. N. Borneo; Tenompok       1932-03-17 barcode-02502864 J. Clemens & M. S. Clemens Clemens 30028 False 21 21 Clemens 30028 Clemens 1932-03-17
632603 632603 4927357694 Phyllocladaceae Phyllocladus hypophyllus Hook.f. Falls above Lumu.       1932-04 barcode-02246832 J. Clemens & M. S. Clemens Clemens 30029 False 21 21 Clemens 30029 Clemens 1932-04
495603 495603 3422278693 Phyllocladaceae Phyllocladus hypophyllus Hook.f. Paka       1932-06-03 4279085 J. Clemens Clemens 30030 False 21 21 Clemens 30030 Clemens 1932-06-03
623289 623289 4947986855 Asteraceae Myriactis wightii DC. Upper Kinabalu.       1932-03-26 barcode-02249180 J. Clemens & M. S. Clemens Clemens 30031 False 21 21 Clemens 30031 Clemens 1932-03-26
303536 303536 4601989411 Smilacaceae Smilax leucophylla Blume B. N. Borneo, Mt. Kinabalu; Tenompok, above trail       1932-04-22T00:00 K002377642 Clemens, J.; Clemens, M.S. Clemens 30037 False 21 21 Clemens 30037 Clemens 1932-04-22T00:00
655342 655342 4070100335 Smilacaceae Smilax L. Tenompok       1932-05-23 barcode-02325573 M. S. Clemens Clemens 30037 False 21 21 Clemens 30037 Clemens 1932-05-23
401817 401817 4601992359 Smilacaceae Smilax L. Mount Kinabalu; B. N. Borneo; Tenompok       1932-04-06T00:00 K002377846 Clemens, J.; Clemens, M.S. Clemens 30038 False 21 21 Clemens 30038 Clemens 1932-04-06T00:00
494882 494882 3898424404 Smilacaceae Smilax L. Mount Kinabalu B. N. Borneo Tenompok       1932-04-06 4343721 J. Clemens Clemens 30038 False 21 21 Clemens 30038 Clemens 1932-04-06
418052 418052 5132734454 Hernandiaceae Illigera celebica Miq. Mount Kinabalu; Tenompok       1932-05-13T00:00 K004182985 Clemens, J.; Clemens, M.S. Clemens 30041 False 21 21 Clemens 30041 Clemens 1932-05-13T00:00
489088 489088 4093677601 Hernandiaceae Illigera celebica Miq. Mount Kinabalu B. N. Borneo Tenompok       1932-05-13 4750168 J. Clemens Clemens 30041 False 21 21 Clemens 30041 Clemens 1932-05-13
633521 633521 4527859823 Hernandiaceae Illigera celebica Miq. Tenompok       1932-03-13 barcode-02222526 J. Clemens & M. S. Clemens Clemens 30041 False 21 21 Clemens 30041 Clemens 1932-03-13
629858 629858 5139648403 Nartheciaceae Aletris L. Kamburanga to Paka; Upper Kinabalu       1932-05-31 barcode-02657183 J. Clemens & M. S. Clemens Clemens 30043 False 21 21 Clemens 30043 Clemens 1932-05-31
671743 671743 5139645485 Nartheciaceae Aletris rigida Stapf Upper Kinabalu       1932-03-26 barcode-02657177 J. Clemens & M. S. Clemens Clemens 30044 False 21 21 Clemens 30044 Clemens 1932-03-26
259784 259784 5077848109 Nepenthaceae Nepenthes villosa Hook.fil. Mount Kinabalu; Kamburanga; Upper Kinabalu       1932-03-27T00:00 K005917322 Clemens, J.; Clemens, M.S. Clemens 30045 False 21 21 Clemens 30045 Clemens 1932-03-27T00:00
306709 306709 5077845120 Nepenthaceae Nepenthes villosa Hook.fil. Upper Kinabalu; Kamburanga       1932-03-27T00:00 K005917323 Clemens, J.; Clemens, M.S. Clemens 30045 False 21 21 Clemens 30045 Clemens 1932-03-27T00:00
491707 491707 1949829448 Nepenthaceae Nepenthes villosa Hook.fil. Mount Kinabalu, Kamburanga.       1932-03-27 03839937 J. Clemens Clemens 30045 False 21 21 Clemens 30045 Clemens 1932-03-27
641706 641706 2446832946 Nepenthaceae Nepenthes villosa Hook.fil. Kamburanga.       1932-03-27 barcode-01871373 J. Clemens & M. S. Clemens Clemens 30045 False 21 21 Clemens 30045 Clemens 1932-03-27
473576 473576 5077857116 Nepenthaceae Nepenthes tentaculata Hook.fil. Mt. Kinabalu       1932-05-02T00:00 K005917231 Clemens Clemens 30048 False 21 21 Clemens 30048 Clemens 1932-05-02T00:00
496437 496437 1949841262 Nepenthaceae Nepenthes L. Mt. Kinabalu, Kamboranga.       1932-03-29 3839948 J. Clemens Clemens 30048 False 21 21 Clemens 30048 Clemens 1932-03-29
393846 393846 5152215315 Gesneriaceae Cyrtandra pedicellata B.L.Burtt Upper Kinabalu, Silau Basin       1932-05-19T00:00 K001376709 Clemens, J.; Clemens, M.S. Clemens 30051 False 21 21 Clemens 30051 Clemens 1932-05-19T00:00
479161 479161 5152188313 Gesneriaceae Cyrtandra dolichopoda B.L.Burtt Mt. Kinabalu, Tenompok, trail to Tomis       1932-05-02T00:00 K001376514 Clemens, J.; Clemens, M.S. Clemens 30052 False 21 21 Clemens 30052 Clemens 1932-05-02T00:00
333979 333979 5152166310 Gesneriaceae Cyrtandra clarkei Stapf Upper Kinabalu, above Lumu       1932-05-30T00:00 K001376442 Clemens, J.; Clemens, M.S. Clemens 30054 False 21 21 Clemens 30054 Clemens 1932-05-30T00:00
465853 465853 5072812443 Campanulaceae Lobelia zeylanica L. Mount Kinabalu; Tenompok       1932-03-02T00:00 K005814690 Clemens, J.; Clemens, M.S. Clemens 30056 False 21 21 Clemens 30056 Clemens 1932-03-02T00:00
552606 552606 6061902364 Campanulaceae Lobelia zeylanica L. Tenompok       1932-03-02 barcode-01172530 J. Clemens & M. S. Clemens Clemens 30056 False 21 21 Clemens 30056 Clemens 1932-03-02
635308 635308 4169802384 Amaryllidaceae Proiphys amboinensis (L.) Herb. Dallas; Near Minitindok gorge       1932-04-22 barcode-02461927 J. Clemens & M. S. Clemens Clemens 30057 False 21 21 Clemens 30057 Clemens 1932-04-22
430939 430939 912383982 Eriocaulaceae Eriocaulon brevipedunculatum Merr. B. N. Borneo. Plants of Mount Kinabalu. Sacraficial rock.E1. Upper Mount Kinabalu 6.066667 116.55 2972.0 1932-06-01T00:00 K000457716 Clemens, M.S.; Clemens, J. Clemens 30059 True 21 21 Clemens 30059 Clemens 1932-06-01T00:00
612065 612065 5130969771 Eriocaulaceae Eriocaulon L. Upper Kinabalu       1932-06-01 barcode-02655026 J. Clemens & M. S. Clemens Clemens 30059 False 21 21 Clemens 30059 Clemens 1932-06-01
496739 496739 1949810744 Lentibulariaceae Utricularia striatula J.E.Sm. B. N. Borneo. Mount Kinabalu. Upper Kinabalu. Kamburanga       1932-05-03 03858386 J. Clemens Clemens 30060 False 21 21 Clemens 30060 Clemens 1932-05-03
497121 497121 3898424676 Cyperaceae Scirpus subcapitatus Thwaites Mount Kinabalu, B. N. Borneo, Upper Kinabalu       1932-05-30 4349012 J. Clemens Clemens 30062 False 21 21 Clemens 30062 Clemens 1932-05-30
495481 495481 3898414607 Cyperaceae Machaerina falcata (Nees) T.Koyama Mount Kinabalu, B. N. Borneo, Silau Basin, Upper Kinabalu       1932-05-18 4333605 J. Clemens Clemens 30063 False 21 21 Clemens 30063 Clemens 1932-05-18
434109 434109 4519471467 Cyperaceae Schoenus curvulus F.Muell. B. N. Borneo, Mt. Kinabalu       1932-03-26T00:00 K002397770 Clemens, J.; Clemens, M.S. Clemens 30067 False 21 21 Clemens 30067 Clemens 1932-03-26T00:00
489466 489466 3898431540 Cyperaceae Schoenus curvulus F.Muell. Mount Kinabalu, B. N. Borneo, Granite dome, Upper Kinabalu       1932-03-26 4339934 J. Clemens Clemens 30067 False 21 21 Clemens 30067 Clemens 1932-03-26
519829 519829 1249179876 Cyperaceae Schoenus curvulus F.Muell. Upper Kinabalu     3810.0 1932-03-26 MT00206428 Clemens, Joseph, Rev.; Clemens, Mary K.S. Clemens 30067 False 21 21 Clemens 30067 Clemens 1932-03-26
377114 377114 4873142472 Staphyleaceae Turpinia borneensis (Merr. & L.M.Perry) B.L.Linden Mount Kinabalu; Tenompok       1932-03-12T00:00 K002264854 Clemens, J.; Clemens, M.S. Clemens 30070 False 21 21 Clemens 30070 Clemens 1932-03-12T00:00
637716 637716 4406254366 Staphyleaceae Dalrympelea borneensis (Merr. & L.M.Perry) Nor-Ezzaw. Tenompok       1932-03-12 barcode-02459053 J. Clemens & M. S. Clemens Clemens 30070 False 21 21 Clemens 30070 Clemens 1932-03-12
384343 384343 912102638 Passifloraceae Adenia kinabaluensis W.J.de Wilde Sabah (B.N.Borneo), Mt. Kinabalu, Tenompok, near Lodge     1524.0 1932-04-22T00:00 K000036618 Clemens, J.; Clemens, M.S. Clemens 30074 False 21 21 Clemens 30074 Clemens 1932-04-22T00:00
427833 427833 912102632 Passifloraceae Adenia kinabaluensis W.J.de Wilde Sabah (B.N.Borneo), Mt. Kinabalu, Tenompok, near Lodge     1524.0 1932-04-22T00:00 K000036619 Clemens, J.; Clemens, M.S. Clemens 30074 False 21 21 Clemens 30074 Clemens 1932-04-22T00:00
240071 240071 575300177 Ericaceae Rigiolepis uroglossa (Sleumer) Argent Malaysia:Tenompok; below trail     1524.0 1932-04 E00438111 Clemens, Joseph & Clemens, Mary Strong Clemens 30076 False 21 21 Clemens 30076 Clemens 1932-04
415661 415661 5104002501 Ericaceae Vaccinium uroglossum Sleumer Mount Kinabalu; Tenompok       1932-04-01T00:00 K006436313 Clemens, J.; Clemens, M.S. Clemens 30076 False 21 21 Clemens 30076 Clemens 1932-04-01T00:00
336834 336834 5130187094 Ericaceae Rhododendron fallacinum Sleumer Mount Kinabalu; Upper Kinabalu       1932-06-03T00:00 K005520834 Clemens, J.; Clemens, M.S. Clemens 30078 False 21 21 Clemens 30078 Clemens 1932-06-03T00:00
552293 552293 4021389336 Ericaceae Rhododendron fallacinum Sleumer Upper Kinabalu       1932-06-03 barcode-01820600 J. Clemens & M. S. Clemens Clemens 30078 False 21 21 Clemens 30078 Clemens 1932-06-03
324909 324909 912587056 Ericaceae Rhododendron ericoides H.Low ex Hook.fil. Kinabalu. B.N. Borneo. Tenompok     1524.0 1932-04-01T00:00 K000769968 Clemens, J.; Clemens, M.S. Clemens 30081 False 21 21 Clemens 30081 Clemens 1932-04-01T00:00
521086 521086 574883733 Ericaceae Rhododendron × silvicola (Sleumer) Argent, A.L.Lamb, Phillipps & Collen. Malaysia:Borneo:Sabah:Mt. Kinabalu, above Tenompok.       1932-04 E00001294 Clemens, Joseph & Clemens, Mary Strong Clemens 30081 False 21 21 Clemens 30081 Clemens 1932-04
240525 240525 3497550506 Orchidaceae Thrixspermum triangulare Ames & C.Schweinf.         1932-03-24 E01059061 Clemens, Joseph & Clemens, Mary Strong Clemens 30083 False 21 21 Clemens 30083 Clemens 1932-03-24
656221 656221 3964721332 Orchidaceae Thrixspermum triangulare Ames & C.Schweinf. Upper Kinabalu       1932-03-24 barcode-02550360 J. Clemens & M. S. Clemens Clemens 30083 False 21 21 Clemens 30083 Clemens 1932-03-24
488595 488595 3991100160 Ericaceae Diplycosia ciliolata Hook.fil. Upper Kinabalu, Mount Kinabalu, B. N. Borneo       1932-05-19 4368442 J. Clemens Clemens 30084 False 21 21 Clemens 30084 Clemens 1932-05-19
474297 474297 4986787693 Escalloniaceae Polyosma bracteosa Stapf Mount Kinabalu; Upper Kinabalu       1932-05-30T00:00 K005652439 Clemens, J.; Clemens, M.S. Clemens 30090 False 21 21 Clemens 30090 Clemens 1932-05-30T00:00
526045 526045 4093692648 Escalloniaceae Polyosma bracteosa Stapf Mount Kinabalu B. N. Borneo Upper Kinabalu       1932-05-30 4756922 J. Clemens Clemens 30090 False 21 21 Clemens 30090 Clemens 1932-05-30
630563 630563 4907328456 Escalloniaceae Polyosma bracteosa Stapf Upper Kinabalu       1932-05-30 barcode-02500821 J. Clemens & M. S. Clemens Clemens 30090 False 21 21 Clemens 30090 Clemens 1932-05-30

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]);