occ

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

5 rows where cluster_num_id = 37 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
243823 243823 1988647565 Selaginellaceae Selaginella P.Beauv. B. N. B. Kinabalu, Dallas-Tenompok ridge     1219.0 1931-01-31 1173498 J. Clemens & M.S. Clemens Clemens 28154 False 37 37 Clemens 28154 Clemens 1931-01-31
280252 280252 912396349 Athyriaceae Diplazium crenatoserratum (Blume) T.Moore Dallas 6.033333 116.466667 914.0 1931-01-31T00:00 K000474203 Clemens, J.; Clemens, M.S. Clemens 28155 True 37 37 Clemens 28155 Clemens 1931-01-31T00:00
494014 494014 2235407212 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Mount Kinabalu, B. N. Borneo Dallas 6.0333 116.4667 914.0 1931-01-31 04005527 J. Clemens Clemens 28158 True 37 37 Clemens 28158 Clemens 1931-01-31
569819 569819 6132150102 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Tenompok, Mount Kinabalu     1433.0 1931-01-31 BM015185205 J. Clemens & M.S. Clemens Clemens 28158 False 37 37 Clemens 28158 Clemens 1931-01-31
590959 590959 1318661052 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Mount Kinabalu. B.N. Borneo. Upper Kinabalu. dallas-Tinompok ridge     1219.0 1931-01-31 US 1673246 J. Clemens & M. S. Clemens Clemens 28158 False 37 37 Clemens 28158 Clemens 1931-01-31

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