occ

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

20 rows where cluster_num_id = 47 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, decimalLatitude, decimalLongitude, 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
328501 328501 912352442 Selaginellaceae Selaginella involvens (Sw.) Spring Marai Parai Spur, Mount Kinabalu 6.083333 116.516667   1915-12-01T00:00 K000420407 Clemens, M.S. Clemens 11009 True 47 47 Clemens 11009 Clemens 1915-12-01T00:00
338641 338641 5130169239 Urticaceae Elatostema penibukanense Gibbs Marai Parai Spur; Mount Kinabalu       1915-12-01T00:00 K003415342 Clemens, M.S. Clemens 11012 False 47 47 Clemens 11012 Clemens 1915-12-01T00:00
376174 376174 912307217 Athyriaceae Lunathyrium Koidz. Marai Parai spur, Mt Kinabalu 6.083333 116.516667   1915-12-01T00:00 K000361518 Clemens, M.S. Clemens 11014 True 47 47 Clemens 11014 Clemens 1915-12-01T00:00
621802 621802 4950631605 Symplocaceae Symplocos adenophylla Wall. ex G.Don Marai Parai Spur       1915-12-03 barcode-02600660 M. S. Clemens Clemens 11015 False 47 47 Clemens 11015 Clemens 1915-12-03
630484 630484 1999170025 Rutaceae Tetractomia obovata Merr. Marai Parai Spur, Mount Kinabalu       1915-12-01 barcode-00105703 M. S. Clemens Clemens 11025 False 47 47 Clemens 11025 Clemens 1915-12-01
630327 630327 1999176374 Ericaceae Diplycosia ensifolia Merr. Marai Parai Spur, Mount Kinabalu       1915-12-01 barcode-00014870 M. S. Clemens Clemens 11027 False 47 47 Clemens 11027 Clemens 1915-12-01
568931 568931 1057226000 Cyatheaceae Cyathea capitata Copel.   5.377939 117.087456   1915-12 BM001048061 Mary Strong Clemens Clemens 11033 True 47 47 Clemens 11033 Clemens 1915-12
572846 572846 1055662801 Cyatheaceae Cyathea capitata Copel.   5.377939 117.087456   1915-12 BM001048059 Mary Strong Clemens Clemens 11033 True 47 47 Clemens 11033 Clemens 1915-12
481122 481122 912409803 Polypodiaceae Ctenopteris taxodioides (Baker) Copel. Mt Kinabalu, Marai Parai spur 6.083333 116.516667   1915-12-01T00:00 K000491034 Clemens, M.S. Clemens 11040 True 47 47 Clemens 11040 Clemens 1915-12-01T00:00
532994 532994 912374285 Polypodiaceae Calymmodon clavifer (Hook.) T.Moore Mt Kinabalu, Marai Parai Spur 6.083333 116.516667   1915-12-01T00:00 K000446179 Clemens, M.S. Clemens 11043 True 47 47 Clemens 11043 Clemens 1915-12-01T00:00
568556 568556 4440095380 Polypodiaceae Calymmodon cucullatus (Nees & Blume) C.Presl   5.377939 117.087456   1915-12 BM014154646 Mary Strong Clemens Clemens 11044 True 47 47 Clemens 11044 Clemens 1915-12
375747 375747 912379187 Athyriaceae Diplazium atrosquamosum (Copel.) C.Chr. Marai Parai Spur, Mt. Kinabalu 6.083333 116.516667   1915-12-01T00:00 K000451568 Clemens, J.; Clemens, M.S. Clemens 11051 True 47 47 Clemens 11051 Clemens 1915-12-01T00:00
465048 465048 912462493 Oleandraceae Oleandra oblanceolata Copel. Mt. Kinabalu. Marai Parai Spur. 6.083333 116.516667   1915-12-01T00:00 K000572415 Clemens, M.S. Clemens 11053 True 47 47 Clemens 11053 Clemens 1915-12-01T00:00
245851 245851 2572205903 Hymenophyllaceae Abrodictyum pluma (Hook.) Ebihara & K.Iwats. Marai Parai Spur       1915-12-01 1574316 Mary Strong Clemens Clemens 11056 False 47 47 Clemens 11056 Clemens 1915-12-01
286116 286116 912307712 Hymenophyllaceae Trichomanes L. Mt Kinabalu, Marai Parai Spur. 6.083333 116.516667   1915-12-01T00:00 K000362003 Clemens, M.S. Clemens 11056 True 47 47 Clemens 11056 Clemens 1915-12-01T00:00
373832 373832 912158834 Lindsaeaceae Lindsaea jamesonioides Baker Mt. Kinabalu, Marai Parai spur. 6.0 116.5   1915-12-01T00:00 K000115785 Clemens, M.S. Clemens 11063 True 47 47 Clemens 11063 Clemens 1915-12-01T00:00
280526 280526 5843846597 Thelypteridaceae Coryphopteris gymnopoda (Baker) Holttum British North Borneo; Marai Parai Spur; Mount Kinabalu       1915-12-01T00:00 K000656575 Clemens, M.S. Clemens 11068 False 47 47 Clemens 11068 Clemens 1915-12-01T00:00
568250 568250 1057396081 Polypodiaceae Xiphopteris subpinnatifida (Blume) Copel. Mount Kinabalu; Marai Parai Plateau 6.106119 116.528514   1915-12 BM000822956 Mary Strong Clemens Clemens 11072 True 47 47 Clemens 11072 Clemens 1915-12
528044 528044 4986811553 Nepenthaceae Nepenthes rajah Hook.fil. Marai Parai Spur; Mount Kinabalu       1915-12-01T00:00 K005916970 Clemens, M.S. Clemens 11073 False 47 47 Clemens 11073 Clemens 1915-12-01T00:00
298817 298817 5839117004 Apocynaceae Chilocarpus costatus Miq. Marai Parai Spur; Mount Kinabalu       1915-12-01T00:00 K006085487 Clemens, M.S. Clemens 11089 False 47 47 Clemens 11089 Clemens 1915-12-01T00: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]);