occ

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

16 rows where cluster_num_id = 68 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
455497 455497 5103988751 Symplocaceae Symplocos henschelii (Moritzi) Benth. ex Clarke Mount Kinabalu; Tenompok       1932-05-03T00:00 K005936058 Clemens, J.; Clemens, M.S. Clemens 28651 False 68 68 Clemens 28651 Clemens 1932-05-03T00:00
500686 500686 3969789681 Piperaceae Piper L. Mount Kinabalu; Tenompok.     1524.0 1932-04-17 BRIT501783 J. Clemens; M.S. Clemens Clemens 28662 False 68 68 Clemens 28662 Clemens 1932-04-17
314544 314544 912189479 Arecaceae Pinanga keahii Furtado Sabah, Mount Kinabalu, Tenompok 6.0 116.516667 1524.0 1932-04-21T00:00 K000207916 Clemens, J.; Clemens, M.S. Clemens 28670 True 68 68 Clemens 28670 Clemens 1932-04-21T00:00
428764 428764 912189480 Arecaceae Pinanga keahii Furtado Sabah, Mount Kinabalu, Tenompok 6.0 116.516667 1524.0 1932-04-21T00:00 K000207917 Clemens, J.; Clemens, M.S. Clemens 28670 True 68 68 Clemens 28670 Clemens 1932-04-21T00:00
493070 493070 1930347271 Arecaceae Pinanga Blume Mount Kinabalu. Tenempok. British North Borneo. 6.00353 116.52906   1932-04-21 02325863 J. Clemens Clemens 28670 True 68 68 Clemens 28670 Clemens 1932-04-21
512865 512865 1144737076 Arecaceae Pinanga keahii Furtado       1500.0 1932-04-21 G00039995 Clemens, J. & M. S. Clemens Clemens 28670 False 68 68 Clemens 28670 Clemens 1932-04-21
608122 608122 4602986358 Arecaceae Pinanga keahii Furtado Tenompok.       1932-04-21 barcode-02428014 J. Clemens & M. S. Clemens Clemens 28670 False 68 68 Clemens 28670 Clemens 1932-04-21
638572 638572 4602980449 Arecaceae Pinanga keahii Furtado Tenompok.       1932-04-21 barcode-02428013 J. Clemens & M. S. Clemens Clemens 28670 False 68 68 Clemens 28670 Clemens 1932-04-21
663021 663021 4602982357 Arecaceae Pinanga keahii Furtado Tenompok.       1932-04-21 barcode-02428015 J. Clemens & M. S. Clemens Clemens 28670 False 68 68 Clemens 28670 Clemens 1932-04-21
306625 306625 4873781630 Melastomataceae Memecylon L. Mt. Kinabalu.; Tenompok. Mi. E. lodge       1932-05-04T00:00 K004411850 Clemens, J.; Clemens, M.S. Clemens 28676 False 68 68 Clemens 28676 Clemens 1932-05-04T00:00
494050 494050 4029515593 Melastomataceae Memecylon paniculatum Jack Tenompok, Mount Kinabalu, B. N. Borneo       1932-05-04 4397837 J. Clemens Clemens 28676 False 68 68 Clemens 28676 Clemens 1932-05-04
639938 639938 5052120266 Melastomataceae Memecylon paniculatum Jack Tenompok       1932-05-04 barcode-01539025 J. Clemens & M. S. Clemens Clemens 28676 False 68 68 Clemens 28676 Clemens 1932-05-04
257080 257080 5085156701 Sapotaceae Payena microphylla (de Vriese) Burck Mount Kinabalu; Tenompok       1932-05-04T00:00 K005687279 Clemens, J.; Clemens, M.S. Clemens 28688 False 68 68 Clemens 28688 Clemens 1932-05-04T00:00
502193 502193 1257900462 Staphyleaceae Dalrympelea sphaerocarpa var. microcerotis (J.T.Pereira) Nor-Ezzaw. Mt. Kinabalu, Tenompok.     1524.0 1932-05-07 100555299 Joseph Clemens;Mary Strong Clemens Clemens 28707 False 68 68 Clemens 28707 Clemens 1932-05-07
502568 502568 4061154360 Staphyleaceae Dalrympelea sphaerocarpa var. microcerotis (J.T.Pereira) Nor-Ezzaw. Mt. Kinabalu, Tenompok.     1524.0 1932-05-07 102811637 Joseph Clemens;Mary Strong Clemens Clemens 28707 False 68 68 Clemens 28707 Clemens 1932-05-07
505483 505483 4061661799 Staphyleaceae Dalrympelea sphaerocarpa var. microcerotis (J.T.Pereira) Nor-Ezzaw. Mt. Kinabalu, Tenompok.     1524.0 1932-05-07 102811636 Joseph Clemens;Mary Strong Clemens Clemens 28707 False 68 68 Clemens 28707 Clemens 1932-05-07

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