occ

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

7 rows where cluster_num_id = 61 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
582679 582679 1317869859 Dryopteridaceae Dryopteris pseudocaenopteris (Kunze) Li Bing Zhang Mount Kinabalu, B.N. Borneo, Upper Kinabalu     1524.0 1933 US 1715113 J. Clemens & M. S. Clemens Clemens 34093 False 61 61 Clemens 34093 Clemens 1933
458936 458936 5956227986 Hymenophyllaceae Mecodium productum (Kunze) Copel. North Borneo, Mt. Kinabalu Penataran basin.     1067.0 1933-01-01 94616 Clemens Clemens 34104 False 61 61 Clemens 34104 Clemens 1933-01-01
465140 465140 912352152 Hymenophyllaceae Hymenophyllum J.E.Sm. Mt. Kinabalu, Penataran basin 6.1 116.533333 1070.0 1933-01-01T00:00 K000420146 Clemens Clemens 34104 True 61 61 Clemens 34104 Clemens 1933-01-01T00:00
490952 490952 2012817086 Hymenophyllaceae Mecodium productum (Kunze) Copel. Br.N. Borneo, Mt. Kinabalu, Marai Penataran basin.       1933 03964395 J. Clemens Clemens 34104 False 61 61 Clemens 34104 Clemens 1933
674046 674046 3922526408 Hymenophyllaceae Hymenophyllum productum Kunze Penataran basin       1933 barcode-02581705 M. S. Clemens Clemens 34104 False 61 61 Clemens 34104 Clemens 1933
251121 251121 5836630324 Thelypteridaceae Chingia atrospinosa (C.Chr. ex Kjellb. & C.Chr.) Holttum Mt. Kinabalu Colombon Basin.       1933-01-01T00:00 K000655786 Clemens Clemens 34105 False 61 61 Clemens 34105 Clemens 1933-01-01T00:00
636395 636395 4088827363 Thelypteridaceae Chingia atrospinosa (C.Chr. ex Kjellb. & C.Chr.) Holttum Colombon Basin       1933 barcode-02404433 M. S. Clemens Clemens 34105 False 61 61 Clemens 34105 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]);