occ

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

7 rows where cluster_num_id = 86 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, 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
489146 489146 2251706891 Euphorbiaceae Macaranga Thouars Mount Kinabalu, Columbon river, B. N. Borneo       1933-06-16 4079297 J. Clemens Clemens 33920 False 86 86 Clemens 33920 Clemens 1933-06-16
614537 614537 4404044354 Euphorbiaceae Macaranga rostrata Heine Columbon River       1933-06-16 barcode-02414505 J. Clemens & M. S. Clemens Clemens 33920 False 86 86 Clemens 33920 Clemens 1933-06-16
662462 662462 5859092341 Actinidiaceae Saurauia tristyla DC. Mount Kinabalu; Columbon river       1933-06-15 barcode-02668441 J. Clemens & M. S. Clemens Clemens 33921 False 86 86 Clemens 33921 Clemens 1933-06-15
494986 494986 2239545964 Orchidaceae Bulbophyllum placochilum J.J.Verm. Malay Islands. Mount Kinabalu. B. N. Borneo. Columbon River basin, bank above river.       1933-06-15 04012407 J. Clemens Clemens 33922 False 86 86 Clemens 33922 Clemens 1933-06-15
666740 666740 4527882588 Moraceae Ficus midotis Corner Columbon river       1933-06-15 barcode-02268083 J. Clemens & M. S. Clemens Clemens 33924 False 86 86 Clemens 33924 Clemens 1933-06-15
281066 281066 912503289 Polypodiaceae Loxogramme wallichiana (Hook.) M.G.Price Mt. Kinabalu, Columbon [Kilembun] river basin 6.1 116.5 1372.0 1933-06-15T00:00 K000636046 Clemens, J.; Clemens, M.S. Clemens 33925 True 86 86 Clemens 33925 Clemens 1933-06-15T00:00
620258 620258 4404054427 Polypodiaceae Loxogramme nidiformis C.Chr. Colombon R. basin       1933-06-15 barcode-02218281 J. Clemens & M. S. Clemens Clemens 33925 False 86 86 Clemens 33925 Clemens 1933-06-15

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