occ

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

7 rows where cluster_num_id = 85 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scientificName, locality, decimalLatitude, decimalLongitude, elevation, eventDate, recordedBy, has_coordinates, 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
281044 281044 912504502 Polypodiaceae Scleroglossum pyxidatum Alderw. Mt. Kinabalu, Colombon [Kilembun] river 6.1 116.5 2896.0 1933-06-30T00:00 K000637431 Clemens, J.; Clemens, M.S. Clemens 51368 True 85 85 Clemens 51368 Clemens 1933-06-30T00:00
324347 324347 912504498 Polypodiaceae Scleroglossum pyxidatum Alderw. Mt. Kinabalu, Colombon [Kilembun] river 6.1 116.5 2895.5 1933-07-11T00:00 K000637432 Clemens, J.; Clemens, M.S. Clemens 51368 True 85 85 Clemens 51368 Clemens 1933-07-11T00:00
490589 490589 2235432985 Polypodiaceae Scleroglossum debile (Mett.) Alderw. B.N. Borneo, Mount Kinabalu. Colombon river.       1933-06-30 03986133 J. Clemens Clemens 51368 False 85 85 Clemens 51368 Clemens 1933-06-30
568052 568052 4075121528 Polypodiaceae Scleroglossum minus (Fée) C.Chr. Mount Kinabalu 6.072693 116.561508   1933-07-11 BM014156903 J. Clemens & M.S. Clemens Clemens 51368 True 85 85 Clemens 51368 Clemens 1933-07-11
570365 570365 4074998401 Polypodiaceae Scleroglossum minus (Fée) C.Chr. Mount Kinabalu 6.072693 116.561508   1933-06-30 BM014156904 J. Clemens & M.S. Clemens Clemens 51368 True 85 85 Clemens 51368 Clemens 1933-06-30
609280 609280 4169802305 Polypodiaceae Scleroglossum minus (Fée) C.Chr. Colombon river       1933-06-30 barcode-02221372 J. Clemens & M. S. Clemens Clemens 51368 False 85 85 Clemens 51368 Clemens 1933-06-30
632313 632313 4169806383 Polypodiaceae Scleroglossum intermedium (Copel.) Copel. Columbon river       1933-07-11 barcode-02221369 J. Clemens & M. S. Clemens Clemens 51368 False 85 85 Clemens 51368 Clemens 1933-07-11

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