occ

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

7 rows where cluster_num_id = 98 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, 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
605063 605063 5029071978 Gentianaceae Gentiana borneensis Hook.fil. Kamburanga; Upper Kinabalu       1932-06-02 barcode-01245052 J. Clemens & M. S. Clemens Clemens 27910 False 98 98 Clemens 27910 Clemens 1932-06-02
302761 302761 5130190326 Urticaceae Elatostema bulbothrix Stapf Mount Kinabalu; Upper Kinabalu       1932-06-08T00:00 K003449467 Clemens, J.; Clemens, M.S. Clemens 27923 False 98 98 Clemens 27923 Clemens 1932-06-08T00:00
617810 617810 5238503352 Urticaceae Elatostema bulbothrix Stapf Upper Kinabalu       1932-06-08 barcode-02661837 J. Clemens & M. S. Clemens Clemens 27923 False 98 98 Clemens 27923 Clemens 1932-06-08
478083 478083 912460909 Polypodiaceae Selliguea triloba (Houtt.) M.G.Price Mt. Kinabalu, falls above Luma 6.033333 116.533333 2134.0 1932-06-08T00:00 K000570719 Clemens, J.; Clemens, M.S. Clemens 27933 True 98 98 Clemens 27933 Clemens 1932-06-08T00:00
494824 494824 2012788761 Polypodiaceae Crypsinus trilobus (Houtt.) Copel. B.N. Borneo, Mount Kinabalu. Falls above Luma       1932-06-08 3952240 J. Clemens Clemens 27933 False 98 98 Clemens 27933 Clemens 1932-06-08
638274 638274 4404046303 Polypodiaceae Selliguea triloba (Houtt.) M.G.Price Falls above Luma       1932-06-08 barcode-02220103 J. Clemens & M. S. Clemens Clemens 27933 False 98 98 Clemens 27933 Clemens 1932-06-08
229467 229467 575048265 Ericaceae Rhododendron buxifolium H.Low ex Hook.fil.         1932-06-04 E00141208 Clemens, Joseph & Clemens, Mary Strong Clemens 27943 False 98 98 Clemens 27943 Clemens 1932-06-04

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