occ

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

6 rows where cluster_num_id = 41 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
244477 244477 3770165435 Athyriaceae Athyrium puncticaule (Blume) T.Moore Colombon & Kinabaki rivers       1933 1616401 J. Clemens Clemens 31798 False 41 41 Clemens 31798 Clemens 1933
246875 246875 3770152402 Athyriaceae Athyrium puncticaule (Blume) T.Moore Colombon & Kinabaki rivers       1933 1616402 J. Clemens Clemens 31798 False 41 41 Clemens 31798 Clemens 1933
591118 591118 1456202024 Athyriaceae Athyrium macrocarpum (Blume) Bedd. Mount Kinabalu. B. N. Borneo. Colombon & Upper Kinataki rivers. Upper Kinabalu.     2895.5 1933 US 1715048 J. Clemens & M. S. Clemens Clemens 31798 False 41 41 Clemens 31798 Clemens 1933
639467 639467 3462704345 Orchidaceae Dendrochilum gibbsiae Rolfe Upper Kini Taki river       1933 barcode-02093871 J. Clemens & M. S. Clemens Clemens 31800 False 41 41 Clemens 31800 Clemens 1933
442725 442725 912340338 Hymenophyllaceae Hymenophyllum denticulatum Sw. Mt. Kinabalu, Kintaki river 6.066667 116.516667 2740.0 1933-01-01T00:00 K000407975 Clemens Clemens 31804 True 41 41 Clemens 31804 Clemens 1933-01-01T00:00
612052 612052 3922532303 Hymenophyllaceae Hymenophyllum neesii (Blume) Hook. Kinataki river       1933 barcode-02581617 M. S. Clemens Clemens 31804 False 41 41 Clemens 31804 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]);