occ

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

8 rows where cluster_num_id = 93 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, elevation, 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
326046 326046 912189199 Arecaceae Calamus scapigerus (Becc.) W.J.Baker Sarawak, Mt. Poi, [betcane] camps     1066.8 1929-09-01T00:00 K000207690 Clemens, M.S.; Clemens, J. Clemens 6959 False 93 93 Clemens 6959 Clemens 1929-09-01T00:00
386904 386904 912189252 Arecaceae Calamus scapigerus (Becc.) W.J.Baker Sarawak, Mt. Poi, [betcane] camps     1066.8 1929-09-01T00:00 K000207689 Clemens, M.S.; Clemens, J. Clemens 6959 False 93 93 Clemens 6959 Clemens 1929-09-01T00:00
479889 479889 5068154650 Rubiaceae Timonius Rumph. ex DC. Borneo; Sarawak; Mount Poi Near Apex       1929-09-19T00:00 K004684359 Clemens, J.; Clemens, M.S. Clemens 6963 False 93 93 Clemens 6963 Clemens 1929-09-19T00:00
438123 438123 5839115151 Primulaceae Ardisia sanguinolenta Blume Sarawak. Borneo; near summit; Mount Poi       1929-09-19T00:00 K006163709 Clemens, J.; Clemens, M.S. Clemens 6966 False 93 93 Clemens 6966 Clemens 1929-09-19T00:00
295310 295310 5145871587 Lauraceae Actinodaphne borneensis Meisn. Island or Province Sarawak; Mt. Poi near summit       1929-09-19T00:00 K003276380 Clemens, M.S.; Clemens, J. Clemens 6967 False 93 93 Clemens 6967 Clemens 1929-09-19T00:00
384062 384062 5028704932 Aquifoliaceae Ilex Tourn. ex L. Island of Province: Sarawak, Borneo; Mount Poi       1929-09-19T00:00 K005601613 Clemens, J.; Clemens, M.S. Clemens 6968 False 93 93 Clemens 6968 Clemens 1929-09-19T00:00
337744 337744 5130239634 Ericaceae Vaccinium bancanum var. tenuinervium J.J.Sm. Sarawak, Borneo; Mt. Poi near summit       1929-09-19T00:00 K006206692 Clemens, J.; Clemens, M.S. Clemens 6972 False 93 93 Clemens 6972 Clemens 1929-09-19T00:00
308199 308199 4538754701 Asphodelaceae Dianella ensifolia (L.) Redouté Mt. Poi Near Summit. Borneo       1929-09-01T00:00 K002848144 Clemens, J.; Clemens, M.S. Clemens 6977 False 93 93 Clemens 6977 Clemens 1929-09-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]);