occ

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

27 rows where cluster_num_id = 59 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, 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
375078 375078 4958508632 Phyllanthaceae Glochidion obscurum (Roxb. ex Willd.) Blume Island or Province Sarawak; Borneo; Mount Poi       1929-09-06T00:00 K005533672 Clemens, J.; Clemens, M.S. Clemens 6733 False 59 59 Clemens 6733 Clemens 1929-09-06T00:00
477131 477131 5132678374 Gnetaceae Gnetum gnemon var. tenerum Markgr. Island or Province Sarawak; Mount Poi       1929-09-01T00:00 K000454724 Clemens, J.; Clemens, M.S. Clemens 6735 False 59 59 Clemens 6735 Clemens 1929-09-01T00:00
402106 402106 4958580698 Phyllanthaceae Antidesma neurocarpum Miq. Sarawak, Borneo; Mount Poi       1929-09-09T00:00 K005489290 Clemens, J.; Clemens, M.S. Clemens 6738 False 59 59 Clemens 6738 Clemens 1929-09-09T00:00
449128 449128 4873803493 Euphorbiaceae Croton griffithii Hook.f. Sarawak, Borneo; Mount Poi       1929-09-09T00:00 K004446751 Clemens, J.; Clemens, M.S. Clemens 6739 False 59 59 Clemens 6739 Clemens 1929-09-09T00:00
364791 364791 4873098326 Anacardiaceae Buchanania sessifolia Blume Sarawak, Borneo; Mount Poi; [Sa Baku base Poi]       1929-09-06T00:00 K002258034 Clemens, J.; Clemens, M.S.; Clemens, M.S. Clemens 6743 False 59 59 Clemens 6743 Clemens 1929-09-06T00:00
276304 276304 5183570898 Moraceae Ficus sagittata J.Koenig ex Vahl Sarawak, Borneo; Mount Poi; Sa Baku base Poi       1929-09-06T00:00 K005336692 Clemens, J.; Clemens, M.S. Clemens 6746 False 59 59 Clemens 6746 Clemens 1929-09-06T00:00
339696 339696 4853855121 Celastraceae Lophopetalum beccarianum Pierre Borneo; Mount Poi. [Sabaku]       1929-09-06T00:00 K004424114 Clemens, J.; Clemens, M.S. Clemens 6747 False 59 59 Clemens 6747 Clemens 1929-09-06T00:00
433266 433266 4954080658 Phyllanthaceae Aporosa confusa Gage Sarawak, Borneo; Sa Baku Poi base       1929-09-09T00:00 K005860928 Clemens, J.; Clemens, M.S. Clemens 6750 False 59 59 Clemens 6750 Clemens 1929-09-09T00:00
488925 488925 2251689538 Orchidaceae Dendrochilum Blume Borneo, Mount Poi, Open heath near summit       1929-09-09 4069841 J. Clemens Clemens 6760 False 59 59 Clemens 6760 Clemens 1929-09-09
409804 409804 5138433497 Moraceae Ficus oleifolia King Sarawak, Borneo; Mount Poi       1929-09-09T00:00 K005335931 Clemens, J.; Clemens, M.S. Clemens 6772 False 59 59 Clemens 6772 Clemens 1929-09-09T00:00
401909 401909 4958541135 Phyllanthaceae Antidesma neurocarpum Miq. Sarawak, Borneo; Mount Poi       1929-09-09T00:00 K005489292 Clemens, J.; Clemens, M.S. Clemens 6776 False 59 59 Clemens 6776 Clemens 1929-09-09T00:00
250546 250546 912464934 Annonaceae Orophea clemensiana Keßler Mount Poi     609.6 1929-09-11T00:00 K000574865 Clemens, J.; Clemens, M.S. Clemens 6780 False 59 59 Clemens 6780 Clemens 1929-09-11T00:00
339024 339024 5166261649 Vitaceae Leea aequata L. Borneo; Mount Poi       1929-09-12T00:00 K004253655 Clemens, J.; Clemens, M.S. Clemens 6794 False 59 59 Clemens 6794 Clemens 1929-09-12T00:00
378552 378552 4602150144 Lauraceae Cinnamomum griffithii Meisn. Mt. Poi, base Camp       1929-09-12T00:00 K002134398 Clemens, M.S.; Clemens, J. Clemens 6797 False 59 59 Clemens 6797 Clemens 1929-09-12T00:00
492176 492176 2251707689 Orchidaceae Dendrochilum Blume Mount Poi, Upper camp       1929-09-14 4069842 J. Clemens Clemens 6810 False 59 59 Clemens 6810 Clemens 1929-09-14
389669 389669 912537522 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Mt. Poi 1.8 109.683333 1372.0 1929-09-14T00:00 K000689434 Clemens, M.S.; Clemens, J. Clemens 6814 True 59 59 Clemens 6814 Clemens 1929-09-14T00:00
662879 662879 4053613350 Cyatheaceae Alsophila R.Br. Mt. Poi       1929-09-14 barcode-02532573 J. Clemens & M. S. Clemens Clemens 6814 False 59 59 Clemens 6814 Clemens 1929-09-14
421527 421527 5138404356 Lauraceae Lindera (Adans.) Thunb. Mount Poi       1929-09-01T00:00 K004163733 Clemens, J.; Clemens, M.S. Clemens 6815 False 59 59 Clemens 6815 Clemens 1929-09-01T00:00
258279 258279 5843803709 Symplocaceae Symplocos rubiginosa Wall. Borneo; Island or Province Sarawak.; Mount Poi [Side]       1929-09-01T00:00 K006280942 Clemens, J.; Clemens, M.S. Clemens 6827 False 59 59 Clemens 6827 Clemens 1929-09-01T00:00
410962 410962 4988908484 Rubiaceae Xanthophytum olivaceum Merr. Sarawak.; Island or Province Sarawak; Mt Side       1929-09-16T00:00 K005221948 Clemens, M.S.; Clemens, J. Clemens 6828 False 59 59 Clemens 6828 Clemens 1929-09-16T00:00
476826 476826 5058408747 Thymelaeaceae Aquilaria beccariana Tiegh. Sarawak, Borneo; Mount Poi       1929-09-16T00:00 K006000718 Clemens, J.; Clemens, M.S. Clemens 6831 False 59 59 Clemens 6831 Clemens 1929-09-16T00:00
529099 529099 5284350021 Rubiaceae Urophyllum Wall. Sarawak, Borneo; Mount Poi       1929-09-16T00:00 K005310540 Clemens, J.; Clemens, M.S. Clemens 6836 False 59 59 Clemens 6836 Clemens 1929-09-16T00:00
268709 268709 912537527 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Mt. Poi 1.8 109.683333 1372.0 1929-09-16T00:00 K000689437 Clemens, M.S.; Clemens, J. Clemens 6848 True 59 59 Clemens 6848 Clemens 1929-09-16T00:00
388036 388036 912537544 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Mt. Poi 1.8 109.683333 1372.0 1929-09-16T00:00 K000689435 Clemens, M.S.; Clemens, J. Clemens 6848 True 59 59 Clemens 6848 Clemens 1929-09-16T00:00
429750 429750 912537523 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Mt. Poi 1.8 109.683333 1372.0 1929-09-16T00:00 K000689436 Clemens, M.S.; Clemens, J. Clemens 6848 True 59 59 Clemens 6848 Clemens 1929-09-16T00:00
274313 274313 4958500380 Phyllanthaceae Antidesma neurocarpum var. hosei (Pax & K.Hoffm.) Petra Hoffm. Borneo; Island or Province Sarawak; Mt. Poi       1929-09-16T00:00 K005489472 Clemens, J.; Clemens, M.S. Clemens 6852 False 59 59 Clemens 6852 Clemens 1929-09-16T00:00
274618 274618 5130213563 Primulaceae Ardisia virens Kurz Sarawak, Borneo.; Mount Poi       1929-09-16T00:00 K006164689 Clemens, J.; Clemens, M.S. Clemens 6857 False 59 59 Clemens 6857 Clemens 1929-09-16T00:00

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