occ

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

7 rows where cluster_num_id = 99 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
667352 667352 4527883194 Begoniaceae Begonia fuscisetosa Sands Keebambang       1933 barcode-02225783 J. Clemens & M. S. Clemens Clemens 34339 False 99 99 Clemens 34339 Clemens 1933
490966 490966 3422285329 Gnetaceae Gnetum leptostachyum var. abbreviatum Markgr. Mount Kinabalu, B. N. Borneo, Murutura ridge       1933 4279952 J. Clemens Clemens 34343 False 99 99 Clemens 34343 Clemens 1933
624172 624172 4163457355 Gnetaceae Gnetum leptostachyum var. abbreviatum Markgr. Murutura ridge       1933 barcode-02461267 J. Clemens & M. S. Clemens Clemens 34343 False 99 99 Clemens 34343 Clemens 1933
303011 303011 5060744912 Clusiaceae Garcinia maingayi Hook.fil. ex T.Anderson Mount Kinabalu, B. N. Borneo; Keebambang river       1933-01-01T00:00 K003860376 Clemens, J.; Clemens, M.S. Clemens 34354 False 99 99 Clemens 34354 Clemens 1933-01-01T00:00
323277 323277 912308007 Hymenophyllaceae Trichomanes pallidum Blume Mt Kinabalu, Keebambang R. 6.1 116.516667 1200.0 1933-01-01T00:00 K000362289 Clemens Clemens 34372 True 99 99 Clemens 34372 Clemens 1933-01-01T00:00
460822 460822 5956271556 Hymenophyllaceae Pleuromanes pallidum (Blume) C.Presl North Borneo, Mt. Kinabalu. Keebambang river.     1219.0 1933-01-01 95031 Clemens Clemens 34372 False 99 99 Clemens 34372 Clemens 1933-01-01
648138 648138 3922524325 Hymenophyllaceae Hymenophyllum pallidum (Blume) Ebihara & K.Iwats. Keebambang river       1933 barcode-02581643 M. S. Clemens Clemens 34372 False 99 99 Clemens 34372 Clemens 1933

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