occ

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

6 rows where cluster_num_id = 79 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
656788 656788 4527871134 Moraceae Ficus tarennifolia Corner Colombon basin       1933 barcode-02269314 J. Clemens & M. S. Clemens Clemens 34457 False 79 79 Clemens 34457 Clemens 1933
274578 274578 912419929 Athyriaceae Diplazium tricholepis C.Chr. Mt. Kinabalu; Colombon [Kilembun] Basin 6.1 116.5 1067.0 1933-01-01T00:00 K000505102 Clemens Clemens 34476 True 79 79 Clemens 34476 Clemens 1933-01-01T00:00
495666 495666 2251700062 Athyriaceae Diplazium tricholepis C.Chr. B.N. Borneo. Mount Kinabalu. Colombon Basin.       1933 04064325 J. Clemens Clemens 34476 False 79 79 Clemens 34476 Clemens 1933
476553 476553 912334811 Hymenophyllaceae Hymenophyllum cardunculus C.Chr. Colombon [Kilembun] Basin 6.1 116.5 1067.0 1933-01-01T00:00 K000399985 Clemens Clemens 34477 True 79 79 Clemens 34477 Clemens 1933-01-01T00:00
493187 493187 2012770792 Hymenophyllaceae Meringium lobbii (T.Moore ex Bosch) Copel. B.N. Borneo. Mt. Kinabalu. Colombon Basin.       1933 03964356 J. Clemens Clemens 34477 False 79 79 Clemens 34477 Clemens 1933
659932 659932 3922527381 Hymenophyllaceae Hymenophyllum cardunculus C.Chr. Colombon Basin       1933 barcode-02581471 M. S. Clemens Clemens 34477 False 79 79 Clemens 34477 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]);