occ

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

7 rows where cluster_num_id = 56 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
250245 250245 912487527 Gleicheniaceae Gleichenia peltophora Copel. Upper Kinabalu, below Pakka 6.05 116.55 2895.5 1932-05-30T00:00 K000603103 Clemens, J.; Clemens, M.S. Clemens 27470 True 56 56 Clemens 27470 Clemens 1932-05-30T00:00
494219 494219 1981512990 Gleicheniaceae Gleichenia borneensis (Baker) C.Chr. B.N. Borneo. Mount Kinabalu. Below Paka.       1932-05-30 03868219 J. Clemens Clemens 27470 False 56 56 Clemens 27470 Clemens 1932-05-30
580806 580806 1321919279 Gleicheniaceae Gleichenia peltophora Copel. Mount Kinabalu. B. N. Borneo. Upper Kinabalu. Below Paka. Malay islands.     2972.0 1932-05-30 US 1673122 J. Clemens & M. S. Clemens Clemens 27470 False 56 56 Clemens 27470 Clemens 1932-05-30
639200 639200 3925613368 Gleicheniaceae Gleichenia borneensis (Baker) C.Chr. Upper Kinabalu. Below Paka       1932-05-30 barcode-02552791 J. Clemens & M. S. Clemens Clemens 27470 False 56 56 Clemens 27470 Clemens 1932-05-30
491943 491943 2012800853 Polypodiaceae Pyrrosia kinabaluensis Hovenkamp Mount Kinabalu, B. N. Borneo, Tenompok       1932-05-24 03947396 J. Clemens Clemens 27479 False 56 56 Clemens 27479 Clemens 1932-05-24
590768 590768 1318202841 Polypodiaceae Pyrrosia kinabaluensis Hovenkamp Mount Kinabalu, B. N. Borneo.     1524.0 1932-05-24 US 1673128 J. Clemens & M. S. Clemens Clemens 27479 False 56 56 Clemens 27479 Clemens 1932-05-24
634948 634948 4404048400 Polypodiaceae Pyrrosia kinabaluensis Hovenkamp Tenompok       1932-05-24 barcode-02219401 J. Clemens & M. S. Clemens Clemens 27479 False 56 56 Clemens 27479 Clemens 1932-05-24

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