occ

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

23 rows where cluster_num_id = 73 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
351715 351715 5145857580 Lauraceae Actinodaphne borneensis Meisn. Island or Province Sarawak; Mt. Poi       1929-09-30T00:00 K003276381 Clemens, M.S.; Clemens, J. Clemens 7256 False 73 73 Clemens 7256 Clemens 1929-09-30T00:00
267293 267293 5236067539 Melastomataceae Melastoma sanguineum var. sanguineum Island or Province Sarawak; Mt. Poi       1929-09-30T00:00 K002841075 Clemens, M.; Clemens, J. Clemens 7258 False 73 73 Clemens 7258 Clemens 1929-09-30T00:00
262698 262698 4853842310 Clusiaceae Garcinia L. Island or Province Sarawak; Mt. Poi Summit.       1929-09-30T00:00 K003861969 Clemens, M.S.; Clemens, J. Clemens 7267 False 73 73 Clemens 7267 Clemens 1929-09-30T00:00
389608 389608 5200688528 Rhamnaceae Rhamnus borneensis Steenis Sarawak, Borneo; Mount Poi       1929-09-30T00:00 K004544181 Clemens, J.; Clemens, M.S. Clemens 7269 False 73 73 Clemens 7269 Clemens 1929-09-30T00:00
325647 325647 912431026 Arecaceae Calamus poensis Becc. Mount Poi; Elfinwood, Summit of Poi 4.833334 115.5 1828.8 1929-09-30T00:00 K000521551 Clemens, M.S.; Clemens, J. Clemens 7278 True 73 73 Clemens 7278 Clemens 1929-09-30T00:00
446250 446250 912431046 Arecaceae Calamus poensis Becc. Mount Poi; Elfinwood, Summit of Poi 4.833334 115.5 1828.8 1929-09-30T00:00 K000521552 Clemens, M.S.; Clemens, J. Clemens 7278 True 73 73 Clemens 7278 Clemens 1929-09-30T00:00
274787 274787 912714573 Phyllanthaceae Glochidion littorale var. culminicola Airy Shaw Mount Poi summit.     1828.8 1929-09-30T00:00 K001081254 Clemens, J.; Clemens, M.S. Clemens 7279 False 73 73 Clemens 7279 Clemens 1929-09-30T00:00
494889 494889 1949853573 Nepenthaceae Nepenthes tentaculata Hook.fil. Mt Poi. At summit 1.78725 109.68456 1829.0 1929-09-30 3839901 M. S. Clemens Clemens 7286 True 73 73 Clemens 7286 Clemens 1929-09-30
493130 493130 1928888653 Araceae Alocasia beccarii Engl. Mt. Poi       1929-09-30 03773999 J. Clemens Clemens 7287 False 73 73 Clemens 7287 Clemens 1929-09-30
495842 495842 2273850503 Orchidaceae Epigeneium Gagnep. Mt. Poi, summit       1929-09-30 4078734 J. Clemens Clemens 7288 False 73 73 Clemens 7288 Clemens 1929-09-30
469943 469943 5072782516 Rubiaceae Schradera Vahl Province Sarawak; Mt. Poi       1929-10-02T00:00 K005224373 Clemens, M.S.; Clemens, J. Clemens 7292 False 73 73 Clemens 7292 Clemens 1929-10-02T00:00
525921 525921 2012800148 Polypodiaceae Crypsinus C.Presl Mount Poi       1929-09-30 03952105 J. Clemens Clemens 7296 False 73 73 Clemens 7296 Clemens 1929-09-30
476310 476310 5175256847 Rubiaceae Psychotria L. Sarawak, Borneo; Mount Poi       1929-10-02T00:00 K005741266 Clemens, J.; Clemens, M.S. Clemens 7299 False 73 73 Clemens 7299 Clemens 1929-10-02T00:00
448894 448894 4873819485 Euphorbiaceae Croton griffithii Hook.f. Sarawak, Borneo; Mount Poi       1929-10-02T00:00 K004446750 Clemens, J.; Clemens, M.S. Clemens 7300 False 73 73 Clemens 7300 Clemens 1929-10-02T00:00
404079 404079 5130221345 Apocynaceae Kopsia tenuis Leenh. & Steenis Island or Province Sarawak. [Mt. Poi bet cave camp forest gorge]       1929-10-02T00:00 K005621104 Clemens, M.S.; Clemens, J. Clemens 7301 False 73 73 Clemens 7301 Clemens 1929-10-02T00:00
423581 423581 5183576002 Moraceae Ficus sinuata Thunb. [Province: Sarawak; Mt. Poi]       1929-10-01T00:00 K005337627 Clemens, M.S.; Clemens, J. Clemens 7304 False 73 73 Clemens 7304 Clemens 1929-10-01T00:00
446691 446691 4873090704 Melastomataceae Medinilla muricata Blume Borneo; Mount Poi Upper Cave       1929-10-01T00:00 K003891968 Clemens, J.; Clemens, M.S. Clemens 7305 False 73 73 Clemens 7305 Clemens 1929-10-01T00:00
434407 434407 4850456166 Euphorbiaceae Macaranga depressa (Müll.Arg.) Müll.Arg. Mount Poi [Upper Cave Camp]       1929-10-01T00:00 K004153732 Clemens, J.; Clemens, M.S. Clemens 7311 False 73 73 Clemens 7311 Clemens 1929-10-01T00:00
651972 651972 5029070971 Melastomataceae Melastoma L. Mount Poi       1929-10-01 barcode-02273632 J. Clemens & M. S. Clemens Clemens 7314 False 73 73 Clemens 7314 Clemens 1929-10-01
489606 489606 2423999662 Davalliaceae Leucostegia hymenophylloides (Blume) Bedd. Mount Poi, upper cave camp       1929-10-01 04163124 J. Clemens Clemens 7320 False 73 73 Clemens 7320 Clemens 1929-10-01
277012 277012 4958508483 Phyllanthaceae Antidesma L. Sarawak, Borneo; Mount Poi; [Mt. Porjust above Sower cool camp.]       1929-10-01T00:00 K005489920 Clemens, J.; Clemens, M.S. Clemens 7326 False 73 73 Clemens 7326 Clemens 1929-10-01T00:00
339726 339726 5159772388 Proteaceae Heliciopsis artocarpoides (Elmer) Sleumer Mount Poi       1929-10-02T00:00 K002236818 Clemens, J.; Clemens, M.S. Clemens 7327 False 73 73 Clemens 7327 Clemens 1929-10-02T00:00
389642 389642 5294389109 Actinidiaceae Saurauia planchonii Hook.fil. Island or province sarawak; Mt. Pai       1929-10-03T00:00 K001260322 Clemens, M.S.; Clemens, J. Clemens 7339 False 73 73 Clemens 7339 Clemens 1929-10-03T00:00

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