occ

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

16 rows where cluster_num_id = 55 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, 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
334977 334977 4849333911 Poaceae Panicum incomtum Trin. Upper Kinabalu       1931-12-28T00:00 K003369063 Clemens, J.; Clemens, M.S. Clemens 28300 False 55 55 Clemens 28300 Clemens 1931-12-28T00:00
337644 337644 4849325106 Poaceae Panicum incomtum Trin. Mount Kinabalu; Upper Kinabalu       1931-12-28T00:00 K003369064 Clemens, J.; Clemens, M.S. Clemens 28300 False 55 55 Clemens 28300 Clemens 1931-12-28T00:00
492572 492572 3498237436 Poaceae Panicum sarmentosum Roxb. Mount Kinabalu, B.N. Borneo, Upper Kinabalu       1931-12-28 4307857 J. Clemens Clemens 28300 False 55 55 Clemens 28300 Clemens 1931-12-28
637190 637190 4900312943 Poaceae Panicum sarmentosum Roxb. Dallas.       1932-01-03 barcode-02471985 J. Clemens & M. S. Clemens Clemens 28300 False 55 55 Clemens 28300 Clemens 1932-01-03
493562 493562 3867490320 Poaceae Cyrtococcum patens (L.) A.Camus Dallas, Mount Kinabalu, B. N. Borneo       1932-01-03 04316624 J. Clemens Clemens 28301 False 55 55 Clemens 28301 Clemens 1932-01-03
576838 576838 3005755042 Poaceae Cyrtococcum patens (L.) A.Camus Clemens Expedition for the British Museum. The Malay Islands. Mt. Kinabalu: B. N. Borneo. Dallas.     914.0 1932-01-03 US 2182690 J. Clemens & M. S. Clemens Clemens 28301 False 55 55 Clemens 28301 Clemens 1932-01-03
629105 629105 4898392067 Poaceae Cyrtococcum patens (L.) A.Camus Dallas.       1932-01-03 barcode-02470948 J. Clemens & M. S. Clemens Clemens 28301 False 55 55 Clemens 28301 Clemens 1932-01-03
285676 285676 912307254 Hymenophyllaceae Trichomanes bipunctatum Poir. Mt. Kinabalu Tenompok 6.0 116.533333 1524.0 1932-01-01T00:00 K000361561 Clemens, J.; Clemens, M.S. Clemens 28302 True 55 55 Clemens 28302 Clemens 1932-01-01T00:00
496222 496222 1991413709 Hymenophyllaceae Trichomanes bipunctatum Poir. B.N. Borneo, Mount Kinabalu. Tenompok 6.00353 116.52906   1932-01 03935076 J. Clemens Clemens 28302 True 55 55 Clemens 28302 Clemens 1932-01
591186 591186 1319543717 Hymenophyllaceae Crepidomanes bipunctatum (Poir.) Copel. Mt Kinabalu, B.N. Borneo, Tenompok     1524.0 1932-01 US 1673263 J. Clemens & M. S. Clemens Clemens 28302 False 55 55 Clemens 28302 Clemens 1932-01
660651 660651 3915841345 Hymenophyllaceae Crepidomanes bipunctatum (Poir.) Copel. Tenompok       1932-01 barcode-02581055 J. Clemens & M. S. Clemens Clemens 28302 False 55 55 Clemens 28302 Clemens 1932-01
552029 552029 1699828131 Rubiaceae Pleiocarpidia capitata Bremek. Tenompok     1525.0 1932 HBG521241 Clemens, J. & M.S. Clemens 28307 False 55 55 Clemens 28307 Clemens 1932
250047 250047 912374289 Polypodiaceae Calymmodon clavifer (Hook.) T.Moore Mt Kinabalu, Kamburanga 6.05 116.55 2438.0 1932-01-01T00:00 K000446184 Clemens, J.; Clemens, M.S. Clemens 28315 True 55 55 Clemens 28315 Clemens 1932-01-01T00:00
495686 495686 2235421954 Polypodiaceae Calymmodon clavifer (Hook.) T.Moore B.N. Borneo, Mount Kinabalu. Kamburanga       1932-01 3983232 J. Clemens Clemens 28315 False 55 55 Clemens 28315 Clemens 1932-01
628799 628799 4406258322 Polypodiaceae Calymmodon clavifer (Hook.) T.Moore Kamburanga       1932-01 barcode-02220651 J. Clemens & M. S. Clemens Clemens 28315 False 55 55 Clemens 28315 Clemens 1932-01
654946 654946 4406246338 Polypodiaceae Calymmodon clavifer (Hook.) T.Moore Kamburanga       1932-01 barcode-02220653 J. Clemens & M. S. Clemens Clemens 28315 False 55 55 Clemens 28315 Clemens 1932-01

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