occ

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

8 rows where cluster_num_id = 94 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
281648 281648 912594690 Pandanaceae Pandanus rusticus B.C.Stone Dallas     914.4 1932-09-26T00:00 K000781361 Clemens, J.; Clemens, M.S. Clemens 26609 False 94 94 Clemens 26609 Clemens 1932-09-26T00:00
295685 295685 4602048220 Araceae Arisaema umbrinum Ridl. Mount Kinablau; B.N. Borneo       1932-09-29T00:00 K002823726 Clemens, J.; Clemens, M.S. Clemens 26628 False 94 94 Clemens 26628 Clemens 1932-09-29T00:00
674233 674233 1999288921 Araceae Arisaema simplicifolium Ridl. Dallas, Mount Kinabalu       1932-09-29 barcode-01655162 J. Clemens & M. S. Clemens Clemens 26628 False 94 94 Clemens 26628 Clemens 1932-09-29
302550 302550 4519403115 Arecaceae Pinanga capitata var. capitata Mt. Kinabalu. Tenompok 6.0 116.516667   1932-09-28T00:00 K001261204 Clemens, J.; Clemens, M.S. Clemens 26643 True 94 94 Clemens 26643 Clemens 1932-09-28T00:00
406489 406489 4519400101 Arecaceae Pinanga capitata var. capitata Mt. Kinabalu. Tenompok 6.0 116.516667   1932-09-28T00:00 K001261203 Clemens, J.; Clemens, M.S. Clemens 26643 True 94 94 Clemens 26643 Clemens 1932-09-28T00:00
497232 497232 1928569472 Arecaceae Pinanga Blume Mount Kinabalu. Tenempok. British North Borneo. 6.00353 116.52906   1932-09-28 02325864 J. Clemens Clemens 26643 True 94 94 Clemens 26643 Clemens 1932-09-28
655016 655016 5281570496 Urticaceae Elatostema flavovirens R.S.Beaman & Cellin. Tenompok       1932-10 barcode-02661844 J. Clemens & M. S. Clemens Clemens 26653 False 94 94 Clemens 26653 Clemens 1932-10
495070 495070 4058644258 Menispermaceae Pericampylus glaucus (Lam.) Merr. B. N. Borneo, Mount Kinabalu, Dallas       1932-10-01 4724164 J. Clemens Clemens 26663 False 94 94 Clemens 26663 Clemens 1932-10-01

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