occ

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

6 rows where cluster_num_id = 96 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, 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
300423 300423 912396392 Polypodiaceae Ctenopteris curtisii (Baker) Copel. Tenompok 6.0 116.516667 914.0 1932-01-01T00:00 K000474251 Clemens, J.; Clemens, M.S. Clemens 28966 True 96 96 Clemens 28966 Clemens 1932-01-01T00:00
490739 490739 2235416248 Polypodiaceae Ctenopteris curtisii (Baker) Copel. Tenompok       1932-01 03984347 J. Clemens Clemens 28966 False 96 96 Clemens 28966 Clemens 1932-01
591264 591264 1319654044 Polypodiaceae Themelium decrescens (Christ) Parris Mt. Kinabalu, upper Kinabalu, Br N Borneo, TTenompok vicinity. Malay Islands.     1981.5 1932-01 US 1673329 J. Clemens & M. S. Clemens Clemens 28966 False 96 96 Clemens 28966 Clemens 1932-01
644696 644696 4169809383 Polypodiaceae Themelium curtisii (Baker) Parris Tenompok       1932-01 barcode-02221424 J. Clemens & M. S. Clemens Clemens 28966 False 96 96 Clemens 28966 Clemens 1932-01
593337 593337 1322196932 Polypodiaceae Prosaptia nutans (Blume) Mett. Mount Kinabalu, upper Kinabalu, B.N.Borneo, Paka.     3505.5 1932 US 1673339 J. Clemens & M. S. Clemens Clemens 28978 False 96 96 Clemens 28978 Clemens 1932
620966 620966 4060294330 Theaceae Schima brevifolia (Hook.fil.) Baill. ex Stapf Mount Kinabalu; Paka-Paka Cave       1932 barcode-02294183 J. Clemens & M. S. Clemens Clemens 28991 False 96 96 Clemens 28991 Clemens 1932

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