occ

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

26 rows where cluster_num_id = 82 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, decimalLatitude, decimalLongitude, 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
490184 490184 1929851611 Arecaceae Salacca affinis Griff. Borneo. Gat, Upper Rejang River.       1929-07-06 02320592 J. Clemens Clemens 22081 False 82 82 Clemens 22081 Clemens 1929-07-06
491044 491044 1930781422 Arecaceae Daemonorops cristata Becc. Gat, Upper Rejang River, Mt. Majau       1929-07-22 02320793 M. S. Clemens Clemens 22082 False 82 82 Clemens 22082 Clemens 1929-07-22
495613 495613 1929090377 Arecaceae Daemonorops ingens J.Dransf. Gat, Upper Rejang River       1929-07-06 02320797 M. S. Clemens Clemens 22083 False 82 82 Clemens 22083 Clemens 1929-07-06
493988 493988 1931364947 Arecaceae Calamus divaricatus Becc. Gat, Upper Rejang River       1929-07 02390576 J. Clemens Clemens 22084 False 82 82 Clemens 22084 Clemens 1929-07
489424 489424 1930066534 Arecaceae Daemonorops ingens J.Dransf. Gat, Upper Rejang River       1929-07-24 02320783 M. S. Clemens Clemens 22087 False 82 82 Clemens 22087 Clemens 1929-07-24
496817 496817 1929051941 Arecaceae Daemonorops Blume ex Schult.f., 1830 Gat, Upper Rejang River       1929-07-05 02320771 M. S. Clemens Clemens 22089 False 82 82 Clemens 22089 Clemens 1929-07-05
492361 492361 1928690143 Arecaceae Salacca vermicularis Becc. Borneo. Gat, Upper Rejang River.       1929-07-17 02320602 J. Clemens Clemens 22093 False 82 82 Clemens 22093 Clemens 1929-07-17
495816 495816 1928602500 Arecaceae Salacca vermicularis Becc. Borneo. Gat, Upper Rejang River.       1929-07-17 02320601 J. Clemens Clemens 22093 False 82 82 Clemens 22093 Clemens 1929-07-17
449872 449872 4519386279 Arecaceae Caryota mitis Lour. Gat, upper Rejang River 1.9 113.45   1929-07-24T00:00 K000935410 Clemens, J.; Clemens, M.S. Clemens 22098 True 82 82 Clemens 22098 Clemens 1929-07-24T00:00
491710 491710 1928370108 Arecaceae Caryota mitis Lour. Sarawak, Borneo; Gat, Upper Rejang River       1929-07 02322818 J. Clemens Clemens 22098 False 82 82 Clemens 22098 Clemens 1929-07
493297 493297 1931370837 Arecaceae Caryota mitis Lour. Sarawak, Borneo; Gat, Upper Rejang River       1929-07 02322819 J. Clemens Clemens 22098 False 82 82 Clemens 22098 Clemens 1929-07
494756 494756 1929996665 Pandanaceae Pandanus biakensis H.St.John Gat, Upper Rejang River       1929-07-01 307536 J. Clemens Clemens 22101 False 82 82 Clemens 22101 Clemens 1929-07-01
489284 489284 1931262855 Polygalaceae Epirixanthes elongata Blume Gat, Upper Rejang River       1929-07-27 1115912 J. Clemens Clemens 22111 False 82 82 Clemens 22111 Clemens 1929-07-27
497124 497124 1991448209 Phyllanthaceae Antidesma montanum Blume Gat, upper Rejang River., North mt. near summit.       1929-07-15 3931451 J. Clemens Clemens 22116 False 82 82 Clemens 22116 Clemens 1929-07-15
494801 494801 1929395095 Myristicaceae Knema muscosa J.Sinclair Gatt, Upper Reejang River: Mt. Majau forest.       1929-07-20 66845 J. Clemens Clemens 22120 False 82 82 Clemens 22120 Clemens 1929-07-20
496056 496056 3328188465 Asparagaceae Dracaena elliptica Thunb. & Dalm. Gat, Upper Rejang River, Mt. Majau forest       1929-07-20 03910628 J. Clemens Clemens 22127 False 82 82 Clemens 22127 Clemens 1929-07-20
489910 489910 2239568889 Orchidaceae Coelogyne echinolabium de Vogel Borneo. Gat, Upper Rejang River. Mt. Majan.       1929-07-20 04027468 J. Clemens;M. S. Clemens Clemens 22129 False 82 82 Clemens 22129 Clemens 1929-07-20
493017 493017 2273871217 Orchidaceae Eulophia nuda Lindl. Gat, Upper Rejang River, by cottage       1929-06-28 4088569 J. Clemens Clemens 22130 False 82 82 Clemens 22130 Clemens 1929-06-28
525941 525941 1949864206 Araceae Piptospatha N.E.Br. Gat, Upper Rejang River. Via Dyak.       1929-07-08 3802065 J. Clemens Clemens 22131 False 82 82 Clemens 22131 Clemens 1929-07-08
490987 490987 1949856018 Araceae Schismatoglottis trivittata Hallier Gat, Upper Rejang River.       1929-07-08 03802664 J. Clemens Clemens 22132 False 82 82 Clemens 22132 Clemens 1929-07-08
496351 496351 1949840627 Araceae Schismatoglottis trivittata Hallier Gat, Upper Rejang River.       1929-07-13 03802663 J. Clemens Clemens 22134 False 82 82 Clemens 22134 Clemens 1929-07-13
493147 493147 1929012679 Araceae Homalomena Schott Gat, Upper Rejang River       1929-07-11 03780850 J. Clemens Clemens 22135 False 82 82 Clemens 22135 Clemens 1929-07-11
495931 495931 1928326985 Arecaceae Daemonorops hystrix (Griff.) Mart. Gat, Upper Rejang River, Mt. Majau summit.       1929-07-20 02320792 M. S. Clemens Clemens 22136 False 82 82 Clemens 22136 Clemens 1929-07-20
282575 282575 4853800846 Marantaceae Phrynium malaccense Ridl. Malay Islands       1929-07-27T00:00 K002186806 Clemens, J.; Clemens, M.S. Clemens 22140 False 82 82 Clemens 22140 Clemens 1929-07-27T00:00
395573 395573 4853804346 Marantaceae Phrynium malaccense Ridl. B. N. Borneo.       1929-07-27T00:00 K002186807 Clemens, J.; Clemens, M.S. Clemens 22140 False 82 82 Clemens 22140 Clemens 1929-07-27T00:00
279021 279021 4607918765 Zingiberaceae Globba brachyanthera var. rubra R.M.Sm. Borneo; Gat, Upper Rejang River .       1929-07-20T00:00 K002593035 Clemens, J.; Clemens, M.S. Clemens 22143 False 82 82 Clemens 22143 Clemens 1929-07-20T00: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]);