occ

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

9 rows where cluster_num_id = 77 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, eventDate, recordedBy, recordNumber_mainNumber, 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
488708 488708 1928337204 Arecaceae Calamus divaricatus Becc. Gat, Upper Rejang River       1929-07-22 02390575 J. Clemens Clemens 6098 False 77 77 Clemens 6098 Clemens 1929-07-22
496317 496317 3898434868 Fagaceae Castanopsis motleyana King Borneo, Gat. Upper Rejang River. Mt. Majou       1929-07-22 4360921 J. Clemens;M. S. Clemens Clemens 6101 False 77 77 Clemens 6101 Clemens 1929-07-22
489673 489673 1929554426 Araceae Homalomena lunduensis Furtado Gat, Upper Rejang River. Mt. [?] summit       1929-07-22 03780830 J. Clemens Clemens 6106 False 77 77 Clemens 6106 Clemens 1929-07-22
496519 496519 1929225138 Arecaceae Iguanura Blume Borneo, Gat. Upper Rejang River. Mt. Majou       1929-07-22 02326120 J. Clemens Clemens 6112 False 77 77 Clemens 6112 Clemens 1929-07-22
525339 525339 1930937815 Arecaceae Iguanura Blume Borneo, Gat. Upper Rejang River. Mt. Majou       1929-07-22 02326119 J. Clemens Clemens 6112 False 77 77 Clemens 6112 Clemens 1929-07-22
489808 489808 1928040346 Arecaceae Daemonorops Blume ex Schult.f., 1830 Gat, Upper Rejang River       1929-07-22 02320796 M. S. Clemens Clemens 6113 False 77 77 Clemens 6113 Clemens 1929-07-22
272900 272900 4853867684 Connaraceae Cnestis platantha Griff. Borneo; Gat, Upper Rejang River       1929-07-22T00:00 K004788382 Clemens, J.; Clemens, M.S. Clemens 6120 False 77 77 Clemens 6120 Clemens 1929-07-22T00:00
435054 435054 5060753619 Vitaceae Leea D.Royen Borneo       1929-07-24T00:00 K004253976 Clemens, M.S.; Clemens, J. Clemens 6124 False 77 77 Clemens 6124 Clemens 1929-07-24T00:00
428475 428475 912336920 Asparagaceae Dracaena Vand. ex L. Gat, Upper Rejang River, base Mt Majau       1929-07-24T00:00 K000401816 Clemens, J.; Clemens, M.S. Clemens 6136 False 77 77 Clemens 6136 Clemens 1929-07-24T00: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]);