occ

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

5 rows where cluster_num_id = 35 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, elevation, eventDate, recordedBy, recordNumber_mainNumber, 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
245185 245185 5886545777 Ochnaceae Neckia serrata Korth. Upper Kinabalu     1219.2 1933-09-25 1772092 J. Clemens & M. S. Clemens Clemens 51331 False 35 35 Clemens 51331 Clemens 1933-09-25
664096 664096 5029074337 Putranjivaceae Drypetes Vahl Upper Kinabalu, Penibukan ridge nr. tent       1933-09-26 barcode-02409156 J. Clemens & M. S. Clemens Clemens 51337 False 35 35 Clemens 51337 Clemens 1933-09-26
492617 492617 4029518028 Melastomataceae Phyllagathis elliptica Stapf B, N, Borneo Mt. Kinabalu Penibukan ridge Jungle near camp       1933-09-26 4419954 J. Clemens Clemens 51338 False 35 35 Clemens 51338 Clemens 1933-09-26
243583 243583 5886545865 Phyllanthaceae Aporosa hosei Merr. Penibukan, Jungle     1066.8 1933-09-26 1762588 J. Clemens & M. S. Clemens Clemens 51339 False 35 35 Clemens 51339 Clemens 1933-09-26
626611 626611 4981856209 Phyllanthaceae Aporosa falcifera Hook.f. Penibukan, Upper Kinabalu       1933-09-26 barcode-02487433 J. Clemens & M. S. Clemens Clemens 51339 False 35 35 Clemens 51339 Clemens 1933-09-26

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