occ

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

7 rows where cluster_num_id = 90 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, 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
426797 426797 5956073546 Fagaceae Lithocarpus revolutus Hatus. ex Soepadmo Mount Kinabalu; Tenompok       1932-04-28T00:00 K001517168 Clemens, J.; Clemens, M.S. Clemens 28562 False 90 90 Clemens 28562 Clemens 1932-04-28T00:00
287362 287362 912376109 Dennstaedtiaceae Microlepia manilensis C.Presl Mt Kinabalu; Tinompok 6.0 116.516667 1524.0 1932-04-26T00:00 K000448166 Clemens, J.; Clemens, M.S. Clemens 28570 True 90 90 Clemens 28570 Clemens 1932-04-26T00:00
595969 595969 1322146106 Dennstaedtiaceae Microlepia manilensis (C.Presl ex Goldm.) C.Chr. Mount Kinabalu, B.N. Borneo, Tenompok, below Lumu trail [interpreted]     1524.0 1932-04-26 US 1673293 J. Clemens & M. S. Clemens Clemens 28570 False 90 90 Clemens 28570 Clemens 1932-04-26
494839 494839 2251698164 Orchidaceae Dendrobium Sw. Mount Kinabalu. B.N. Borneo. Tenompok.       1932-05-02 4056189 J. Clemens Clemens 28582 False 90 90 Clemens 28582 Clemens 1932-05-02
643193 643193 3745235363 Orchidaceae Dendrobium minimum Ames & C.Schweinf. Tenompok       1932-05 barcode-02157137 J. Clemens & M. S. Clemens Clemens 28582 False 90 90 Clemens 28582 Clemens 1932-05
446049 446049 5145839434 Lauraceae Litsea globosa Kosterm. Mount Kinabalu; Tenompok       1932-04-26T00:00 K002138220 Clemens, J.; Clemens, M.S. Clemens 28585 False 90 90 Clemens 28585 Clemens 1932-04-26T00:00
633357 633357 4846544419 Lauraceae Litsea oppositifolia Gibbs Tenompok       1932-04-26 barcode-02499213 J. Clemens & M. S. Clemens Clemens 28585 False 90 90 Clemens 28585 Clemens 1932-04-26

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