occ

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

52 rows where cluster_num_id = 4 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, locality, decimalLatitude, decimalLongitude, elevation, eventDate, recordedBy, recordNumber_mainNumber, has_coordinates, collectorNameNumber, 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
296562 296562 4873120557 Euphorbiaceae Acalypha caturus Blume Sarawak, Borneo; Mount Poi;       1929-01-01T00:00 K005356858 Clemens, J.; Clemens, M.S. Clemens 20045 False 4 4 Clemens 20045 Clemens 1929-01-01T00:00
612417 612417 3948427331 Euphorbiaceae Acalypha L. Mount Poi; base camp       1929 barcode-01767281 J. Clemens & M. S. Clemens Clemens 20045 False 4 4 Clemens 20045 Clemens 1929
626357 626357 3925618327 Euphorbiaceae Acalypha caturus Blume Mount Poi       1929 barcode-01767196 J. Clemens & M. S. Clemens Clemens 20045 False 4 4 Clemens 20045 Clemens 1929
258411 258411 5060764613 Loranthaceae Elytranthe (Blume) Blume Sarawak; Borneo; Mount Poi       1929-01-01T00:00 K004554918 Clemens, J.; Clemens, M.S. Clemens 20047 False 4 4 Clemens 20047 Clemens 1929-01-01T00:00
516749 516749 5832029844 Loranthaceae Macrosolen ampullaceus (Roxb.) Tiegh. On trees, upper cave, at 4500 ft. Mount Poi     1371.6 1929 103808632 Joseph Clemens;Mary Strong Clemens Clemens 20047 False 4 4 Clemens 20047 Clemens 1929
644291 644291 4142711377 Verbenaceae Lantana camara L. Mount Poi       1929 barcode-02324689 M. S. Clemens Clemens 20048 False 4 4 Clemens 20048 Clemens 1929
367390 367390 4866499107 Melastomataceae Memecylon calyptratum K.Bremer Borneo; Mount Poi       1929-01-01T00:00 K004770744 Clemens, J.; Clemens, M.S. Clemens 20050 False 4 4 Clemens 20050 Clemens 1929-01-01T00:00
435483 435483 4853869998 Euphorbiaceae Mallotus minimifructus S.E.C.Sierra Sarawak, Borneo; Mount Poi       1929-01-01T00:00 K004807291 Clemens, J.; Clemens, M.S. Clemens 20052 False 4 4 Clemens 20052 Clemens 1929-01-01T00:00
490785 490785 2273861892 Euphorbiaceae Mallotus minimifructus S.E.C.Sierra Mount Poi       1929 4080276 J. Clemens Clemens 20052 False 4 4 Clemens 20052 Clemens 1929
602669 602669 864902253 Euphorbiaceae Mallotus minimifructus S.E.C.Sierra Malaysia: Borneo, Sarawak. 1929, Leg.: J. Clemens & M. S. Clemens 20052.       1929 B 10 0158435 Clemens,J. & Clemens,M.S. Clemens 20052 False 4 4 Clemens 20052 Clemens 1929
604407 604407 4527862587 Euphorbiaceae Mallotus minimifructus S.E.C.Sierra Mount Poi       1929 barcode-02418871 J. Clemens & M. S. Clemens Clemens 20052 False 4 4 Clemens 20052 Clemens 1929
611911 611911 5169571301 Phyllanthaceae Glochidion J.R.Forst. & G.Forst. Mount Poi       1929 barcode-02335639 J. Clemens & M. S. Clemens Clemens 20054 False 4 4 Clemens 20054 Clemens 1929
428583 428583 5200628537 Rhamnaceae Rhamnus borneensis Steenis Sarawak, Borneo; Mount Poi       1929-01-01T00:00 K004544180 Clemens, J.; Clemens, M.S. Clemens 20055 False 4 4 Clemens 20055 Clemens 1929-01-01T00:00
439131 439131 5072880422 Gesneriaceae Codonoboea scabrinervia (C.B.Clarke) A.Weber Sarawak, Borneo; Mount Poi       1929-01-01T00:00 K006190889 Clemens, J.; Clemens, M.S. Clemens 20062 False 4 4 Clemens 20062 Clemens 1929-01-01T00:00
405913 405913 4849402282 Rubiaceae Argostemma brookei B.Bremer Sarawak, Borneo; Mount Poi       1929-01-01T00:00 K004723945 Clemens, J.; Clemens, M.S. Clemens 20064 False 4 4 Clemens 20064 Clemens 1929-01-01T00:00
560300 560300 1258259052 Burmanniaceae Burmannia longifolia Becc. Mount Poi [Gunung Pueh, Mount Pueh].     1830.0 1929 1052592 Joseph Clemens;Mary Strong Clemens Clemens 20065 False 4 4 Clemens 20065 Clemens 1929
653249 653249 4924686902 Burmanniaceae Burmannia longifolia Becc. Mount Poi.       1929 barcode-02245580 J. Clemens & M. S. Clemens Clemens 20065 False 4 4 Clemens 20065 Clemens 1929
643327 643327 5105311696 Melastomataceae Sonerila Roxb. Mount Poi       1929 barcode-02515814 J. Clemens & M. S. Clemens Clemens 20067 False 4 4 Clemens 20067 Clemens 1929
566311 566311 1258027990 Primulaceae Ardisia Sw. Mount Poi, summit     1829.0 1929 100690122 Joseph Clemens Clemens 20072 False 4 4 Clemens 20072 Clemens 1929
356114 356114 4853868908 Euphorbiaceae Mallotus minimifructus S.E.C.Sierra Sarawak, Borneo; Mount Poi       1929-01-01T00:00 K004807293 Clemens, J.; Clemens, M.S. Clemens 20075 False 4 4 Clemens 20075 Clemens 1929-01-01T00:00
495581 495581 2273867380 Euphorbiaceae Mallotus minimifructus S.E.C.Sierra Mount Poi       1929 04080272 J. Clemens Clemens 20075 False 4 4 Clemens 20075 Clemens 1929
611612 611612 4527850315 Euphorbiaceae Mallotus minimifructus S.E.C.Sierra Mount Poi       1929 barcode-02418869 J. Clemens & M. S. Clemens Clemens 20075 False 4 4 Clemens 20075 Clemens 1929
418312 418312 5236085580 Triuridaceae Sciaphila arfakiana Becc. Borneo; Mount Poi.       1929-01-01T00:00 K003636384 Clemens, J.; Clemens, M.S. Clemens 20081 False 4 4 Clemens 20081 Clemens 1929-01-01T00:00
661843 661843 5891501476 Polygalaceae Xanthophyllum adenotus Miq. Mount Poi       1929 barcode-02310386 M. S. Clemens Clemens 20090 False 4 4 Clemens 20090 Clemens 1929
460500 460500 5956263936 Eriocaulaceae Eriocaulon L. Borneo. Mount Poi.     1829.0 1929-01-01 763228 Clemens, Rev. J. Clemens 20094 False 4 4 Clemens 20094 Clemens 1929-01-01
327 327 2575239674 Poaceae Isachne kinabaluensis Merr.         1929 Z-000098413 Joseph Clemens;M S Clemens Clemens 20095 False 4 4 Clemens 20095 Clemens 1929
251617 251617 4849314174 Poaceae Isachne kinabaluensis Merr. Mt Poi       1929-01-01T00:00 K003155019 Clemens, J.; Clemens, M.S. Clemens 20095 False 4 4 Clemens 20095 Clemens 1929-01-01T00:00
404130 404130 912602412 Ebenaceae Diospyros clementium Bakh. Sarawak, Borneo, Mount Poi.       1929-01-01T00:00 K000792646 Clemens, J.; Clemens, M.S. Clemens 20098 False 4 4 Clemens 20098 Clemens 1929-01-01T00:00
529060 529060 912602418 Ebenaceae Diospyros clementium Bakh. Sarawak, Borneo, Mount Poi.       1929-01-01T00:00 K000792645 Clemens, J.; Clemens, M.S. Clemens 20098 False 4 4 Clemens 20098 Clemens 1929-01-01T00:00
624351 624351 1999213283 Ebenaceae Diospyros clementium Bakh. Mount Poi, forest       1929 barcode-00112386 J. Clemens & M. S. Clemens Clemens 20098 False 4 4 Clemens 20098 Clemens 1929
330992 330992 4850475342 Euphorbiaceae Croton argyratus Blume Borneo; Mount Poi       1929-01-01T00:00 K004446496 Clemens, J.; Clemens, M.S. Clemens 20099 False 4 4 Clemens 20099 Clemens 1929-01-01T00:00
493728 493728 2235409279 Euphorbiaceae Croton argyratus Blume Mount Poi       1929 3993959 J. Clemens Clemens 20099 False 4 4 Clemens 20099 Clemens 1929
657018 657018 5139645351 Lauraceae Nothaphoebe Blume Mount Poi       1929 barcode-02514789 J. Clemens & M. S. Clemens Clemens 20102 False 4 4 Clemens 20102 Clemens 1929
440066 440066 5072848596 Gesneriaceae Codonoboea crinita (Jack) C.L.Lim Sarawak, Borneo; Mount Poi       1929-01-01T00:00 K006190779 Clemens, J.; Clemens, M.S. Clemens 20104 False 4 4 Clemens 20104 Clemens 1929-01-01T00:00
464377 464377 4873091946 Melastomataceae Phyllagathis rufa (Stapf) Cellin. Borneo; Mount Poi       1929-01-01T00:00 K003897546 Clemens, J.; Clemens, M.S. Clemens 20105 False 4 4 Clemens 20105 Clemens 1929-01-01T00:00
674031 674031 5073944400 Melastomataceae Phyllagathis rufa (Stapf) Cellin. Mount Poi       1929 barcode-02275860 J. Clemens & M. S. Clemens Clemens 20105 False 4 4 Clemens 20105 Clemens 1929
610922 610922 3794849352 Orchidaceae Podochilus lucescens Blume Mount Poi       1929 barcode-02339613 J. Clemens & M. S. Clemens Clemens 20124 False 4 4 Clemens 20124 Clemens 1929
452812 452812 5130169975 Annonaceae Monoon Miq. Mount Poi       1929-01-01T00:00 K003311621 Clemens, J.; Clemens, M.S. Clemens 20126 False 4 4 Clemens 20126 Clemens 1929-01-01T00:00
605293 605293 6061899650 Annonaceae Polyalthia Blume Mount Poi       1929 barcode-02615174 J. Clemens & M. S. Clemens Clemens 20126 False 4 4 Clemens 20126 Clemens 1929
369 369 2575337796 Apocynaceae Kopsia tenuis Leenh. & Steenis Borneo, Sarawak, Mount Poi       1929 Z-000053851 Joseph Clemens;Clemens, M S Clemens 20129 False 4 4 Clemens 20129 Clemens 1929
544 544 2575338521 Apocynaceae Kopsia tenuis Leenh. & Steenis Borneo, Sarawak, Mount Poi       1929 Z-000053850 Joseph Clemens;Clemens, M S Clemens 20129 False 4 4 Clemens 20129 Clemens 1929
407603 407603 5130198337 Apocynaceae Kopsia tenuis Leenh. & Steenis Sarawak Borneo; Mount Poi       1929-01-01T00:00 K005621105 Clemens, J.; Clemens, M.S. Clemens 20129 False 4 4 Clemens 20129 Clemens 1929-01-01T00:00
554284 554284 4067109266 Apocynaceae Kopsia tenuis Leenh. & Steenis Borneo, Sarawak, Mount Poi 1.552382 110.364576   1929   Clemens, J. Clemens 20129 True 4 4 Clemens 20129 Clemens 1929
617433 617433 3468658407 Apocynaceae Kopsia tenuis Leenh. & Steenis Mount Poi       1929 barcode-02378289 J. Clemens & M. S. Clemens Clemens 20129 False 4 4 Clemens 20129 Clemens 1929
496711 496711 3991112529 Fagaceae Lithocarpus Blume Borneo, Mount Poi       1929 4370894 J. Clemens;M. S. Clemens Clemens 20130 False 4 4 Clemens 20130 Clemens 1929
611459 611459 4947985092 Fagaceae Lithocarpus blumeanus (Korth.) Rehder Mount Poi       1929 barcode-02554794 J. Clemens & M. S. Clemens Clemens 20130 False 4 4 Clemens 20130 Clemens 1929
424387 424387 5183517025 Moraceae Ficus sinuata Thunb. Sarawak, Borneo; Mount Poi       1929-01-01T00:00 K005337628 Clemens, J.; Clemens, M.S. Clemens 20131 False 4 4 Clemens 20131 Clemens 1929-01-01T00:00
653743 653743 4870168841 Moraceae Ficus L. Mount Poi       1929 barcode-01130130 J. Clemens & M. S. Clemens Clemens 20131 False 4 4 Clemens 20131 Clemens 1929
616828 616828 4527863610 Myrtaceae Rhodamnia cinerea Jack Mount Poi       1929 barcode-02449147 J. Clemens & M. S. Clemens Clemens 20132 False 4 4 Clemens 20132 Clemens 1929
307580 307580 4602128042 Petrosaviaceae Petrosavia stellaris Becc. Borneo; Mount Poi       1929-01-01T00:00 K003909585 Clemens, J.; Clemens, M.S. Clemens 20134 False 4 4 Clemens 20134 Clemens 1929-01-01T00:00
632911 632911 4924690268 Podocarpaceae Dacrycarpus imbricatus (Blume) de Laub. Mount Pot.       1929 barcode-02246129 J. Clemens & M. S. Clemens Clemens 20134 False 4 4 Clemens 20134 Clemens 1929
604252 604252 4527902897 Myrtaceae Syzygium bankense (Hassk.) Merr. & L.M.Perry Mount Poi       1929 barcode-02449782 J. Clemens & M. S. Clemens Clemens 20136 False 4 4 Clemens 20136 Clemens 1929

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