occ

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

6 rows where cluster_num_id = 74 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, locality, decimalLatitude, decimalLongitude, eventDate, recordedBy, has_coordinates, 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
447645 447645 912523861 Aquifoliaceae Ilex poiensis S.Andrews Mount Poi       1929-01-01T00:00 K000669009 Clemens, J.; Clemens, M.S. Clemens 22582 False 74 74 Clemens 22582 Clemens 1929-01-01T00:00
263021 263021 4873091899 Melastomataceae Oxyspora beccarii (Cogn.) J.F.Maxwell Borneo       1929-01-01T00:00 K003896545 Clemens, J.; Clemens, M.S. Clemens 22584 False 74 74 Clemens 22584 Clemens 1929-01-01T00:00
491900 491900 1930142497 Orchidaceae Dendrobium quadrisulcatum J.J.Sm. Mount Poi 1.78725 109.68456   1929 679870 J. Clemens Clemens 22586 True 74 74 Clemens 22586 Clemens 1929
671252 671252 1998731809 Orchidaceae Dendrochilum mucronatum J.J.Sm. Mount Poi, mossy forest, 5500 feet       1929 barcode-00061168 J. Clemens & M. S. Clemens Clemens 22587 False 74 74 Clemens 22587 Clemens 1929
614311 614311 4088837315 Ericaceae Vaccinium borneense var. poianum (J.J.Sm.) Sleumer Mount Poi       1929 barcode-02544088 J. Clemens & M. S. Clemens Clemens 22589 False 74 74 Clemens 22589 Clemens 1929
640252 640252 5052127695 Anacardiaceae Semecarpus L.f. Kapit, Rejang River       1929 barcode-02281498 J. Clemens & M. S. Clemens Clemens 22591 False 74 74 Clemens 22591 Clemens 1929

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