occ

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

13 rows where cluster_num_id = 46 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
245536 245536 1988823937 Poaceae Aniselytron treutleri (Kuntze) Soják Upper Mt. Kinabalu, Masilau River     2134.0 1933-12-26 1108602 J. Clemens & M.S. Clemens Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26
247156 247156 4058692853 Poaceae Aniselytron treutleri (Kuntze) Soják Masilau R. unexplored region     2133.6 1933-12-26 1703277 J. Clemens, M. S. Clemens Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26
374459 374459 912703554 Poaceae Aniselytron Merr. Masilau R., Mt. Kinabalu, unexplored region     2133.6 1933-12-26T00:00 K000975192 Clemens, J.; Clemens, M.S. Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26T00:00
441391 441391 912703547 Poaceae Aniselytron Merr. Masilau R., Mt. Kinabalu, unexplored region     2133.6 1933-12-26T00:00 K000975191 Clemens, J.; Clemens, M.S. Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26T00:00
441885 441885 912703558 Poaceae Aniselytron Merr. Masilau R., Mt. Kinabalu, unexplored region     2133.6 1933-12-26T00:00 K000975190 Clemens, J.; Clemens, M.S. Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26T00:00
505582 505582 4061173758 Poaceae Aniselytron treutleri (Kuntze) Soják Borneo. Sabah State. Margin of Masilau River, Mt. Kinabalu     2133.6 1933-12-26 101469755 Mary Strong Clemens Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26
508190 508190 1144595430 Poaceae Aniselytron treutleri (Kuntze) Soják       2150.0 1933-12-26 G00164249 Clemens, J. & M. S. Clemens Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26
561193 561193 1259575891 Poaceae Aniselytron treutleri (Kuntze) Soják Borneo. Sabah State. Margin of Masilau River, Mt. Kinabalu     2133.6 1933-12-26 227804 Mary Strong Clemens Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26
572585 572585 1057180982 Poaceae Calamagrostis treutleri (Kuntze) U.Shukla   5.377939 117.087456   1933-12-26 BM000959446 J. Clemens & M.S. Clemens Clemens 34448 True 46 46 Clemens 34448 Clemens 1933-12-26
573524 573524 1055413030 Poaceae Calamagrostis treutleri (Kuntze) U.Shukla   5.377939 117.087456   1933-12-26 BM000959445 J. Clemens & M.S. Clemens Clemens 34448 True 46 46 Clemens 34448 Clemens 1933-12-26
576701 576701 1322831044 Poaceae Aulacolepis clemensae Hitchc. Margin of Masilau river, Mt. Kinabalu; alt. 7000 ft. (approx.).     2134.0 1933-12-26 US 1538647 M. S. Clemens Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26
628808 628808 1998388996 Poaceae Aulacolepis clemensae Hitchc. Masilau R[iver] amoung boulders subject to overflow, Upper Mount Kinabalu       1933-12-26 barcode-00065399 J. Clemens & M. S. Clemens Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-26
644706 644706 1999231699 Poaceae Aulacolepis clemensae Hitchc. Masilau R[iver] amoung boulders subject to overflow, Upper Mount Kinabalu       1933-12-26 barcode-00065398 J. Clemens & M. S. Clemens Clemens 34448 False 46 46 Clemens 34448 Clemens 1933-12-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]);