occ

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

29 rows where cluster_num_id = 89 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, eventDate, recordedBy, recordNumber_mainNumber, 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
406292 406292 5152207318 Gesneriaceae Cyrtandra subgrandis B.L.Burtt Gat, Upper Rejang River       1929-06-30T00:00 K001376809 Clemens, J.; Clemens, M.S. Clemens 21618 False 89 89 Clemens 21618 Clemens 1929-06-30T00:00
292713 292713 5152181312 Gesneriaceae Cyrtandra phoenicolasia Lauterb. Gat, Upper Rejang River       1929-07-06T00:00 K001376743 Clemens, J.; Clemens, M.S. Clemens 21619 False 89 89 Clemens 21619 Clemens 1929-07-06T00:00
481818 481818 5152212319 Gesneriaceae Cyrtandra vaginata B.L.Burtt Gat, Upper Rejang River       1929-06-29T00:00 K001376853 Clemens, J.; Clemens, M.S. Clemens 21619 False 89 89 Clemens 21619 Clemens 1929-06-29T00:00
526028 526028 1930274950 Myrtaceae Syzygium odoardoi Merr. & L.M.Perry Gat, Upper Rejang River       1929-07 405625 J. Clemens Clemens 21633 False 89 89 Clemens 21633 Clemens 1929-07
497004 497004 2382928437 Orchidaceae Neuwiedia veratrifolia Blume Borneo , Gat, Upper Rejang River, altitude: low       1929-07-10 4109141 J. Clemens Clemens 21636 False 89 89 Clemens 21636 Clemens 1929-07-10
491258 491258 2239578580 Orchidaceae Corymborkis veratrifolia (Reinw.) Blume Gat, Upper Rejang River, low alt       1929-07-06 4038559 J. Clemens Clemens 21637 False 89 89 Clemens 21637 Clemens 1929-07-06
356722 356722 912128073 Orchidaceae Coelogyne echinolabium de Vogel Coordinates have been hidden for this Occurrence.       1929-07-01T00:00 K000078842 Clemens, J.; Clemens, M.S. Clemens 21639 False 89 89 Clemens 21639 Clemens 1929-07-01T00:00
490152 490152 1930468557 Orchidaceae Coelogyne echinolabium de Vogel Gat, Upper Rejang River       1929-07 8663 J. Clemens Clemens 21639 False 89 89 Clemens 21639 Clemens 1929-07
492397 492397 1991445558 Phyllanthaceae Antidesma leucopodum Miq. Gat, Upper Rejang River., Altitude: Low.       1929-07-06 3931283 J. Clemens Clemens 21650 False 89 89 Clemens 21650 Clemens 1929-07-06
443986 443986 4903205491 Actinidiaceae Saurauia myrmecoidea Merr. Borneo.; Island or Province Sarawak.; Gat, Upper Rejang River.       1929-06-29T00:00 K001260251 Clemens, J.; Clemens, M.S. Clemens 21659 False 89 89 Clemens 21659 Clemens 1929-06-29T00:00
491874 491874 1929892031 Elaeocarpaceae Elaeocarpus barbulatus Knuth Gat; Mt. Majau Summit       1929-07-20 415240 J. Clemens Clemens 21662 False 89 89 Clemens 21662 Clemens 1929-07-20
496198 496198 2012779865 Phyllanthaceae Baccaurea Lour. Borneo, Gat, Upper Rejang River,       1929-07-10 3933225 J. Clemens Clemens 21664 False 89 89 Clemens 21664 Clemens 1929-07-10
492174 492174 2012814731 Phyllanthaceae Cleistanthus Hook.f. ex Planch. Mt Gat, Upper Rejang River       1929-07-25 3951367 J. Clemens Clemens 21666 False 89 89 Clemens 21666 Clemens 1929-07-25
495383 495383 1991408328 Phyllanthaceae Antidesma montanum Blume Gat, Upper Rejang River, Mt. Gat       1929-07-25 3931329 J. Clemens Clemens 21669 False 89 89 Clemens 21669 Clemens 1929-07-25
490040 490040 2012799268 Phyllanthaceae Antidesma venosum E.Mey. ex Tul. Gat, Upper Rejang River, Altitude: Low.       1929-06-29 3931716 J. Clemens Clemens 21670 False 89 89 Clemens 21670 Clemens 1929-06-29
497464 497464 2012784967 Phyllanthaceae Breynia J.R.Forst. & G.Forst. Borneo,Gat, Upper Rejang River       1929-07-04 3949461 J. Clemens Clemens 21671 False 89 89 Clemens 21671 Clemens 1929-07-04
284073 284073 4850445998 Euphorbiaceae Homalanthus populneus (Geiseler) Pax Borneo; Gat, Upper Rejang River       1929-06-27T00:00 K003871417 Clemens, J.; Clemens, M.S. Clemens 21673 False 89 89 Clemens 21673 Clemens 1929-06-27T00:00
488939 488939 2273861974 Euphorbiaceae Omalanthus populneus Kuntze Borneo., Gat, Upper Rejang River, low altitude       1929-07-08 4084404 J. Clemens Clemens 21673 False 89 89 Clemens 21673 Clemens 1929-07-08
494550 494550 2251699321 Euphorbiaceae Macaranga Thouars Borneo., Gat, Upper Rejang River,, North Mt. Forest., altitude: low       1929-07-15 4079331 J. Clemens Clemens 21676 False 89 89 Clemens 21676 Clemens 1929-07-15
492823 492823 2251695516 Euphorbiaceae Macaranga Thouars Gat, Upper Rejang River       1929-07-02 4079289 J. Clemens Clemens 21677 False 89 89 Clemens 21677 Clemens 1929-07-02
492570 492570 2012801828 Euphorbiaceae Claoxylon A.Juss. Borneo, Gat, Upper Rejang River, Mt. Gat       1929-07-25 3950965 J. Clemens Clemens 21681 False 89 89 Clemens 21681 Clemens 1929-07-25
494735 494735 2447351742 Apocynaceae Leuconotis elastica Becc. Gat, Upper Rejang River       1929-07-24 04193787 J. Clemens Clemens 21692 False 89 89 Clemens 21692 Clemens 1929-07-24
492999 492999 2447343981 Apocynaceae Tabernaemontana corymbosa Roxb. ex Wall. Gat, Upper Rejang River       1929-07 4189892 J. Clemens Clemens 21704 False 89 89 Clemens 21704 Clemens 1929-07
496193 496193 2447350972 Apocynaceae Tabernaemontana corymbosa Roxb. ex Wall. Gat, upper Rejang River, Mt. Majau       1929-07-24 4189897 J. Clemens Clemens 21704 False 89 89 Clemens 21704 Clemens 1929-07-24
650969 650969 4024407348 Apocynaceae Tabernaemontana corymbosa Roxb. ex Wall. Gat, Upper Rejang River       1929-07 barcode-02372420 J. Clemens & M. S. Clemens Clemens 21704 False 89 89 Clemens 21704 Clemens 1929-07
263101 263101 4850423115 Cucurbitaceae Trichosanthes auriculata Rugayah Borneo; Gat, Upper Rejang River       1929-07-27T00:00 K003479435 Clemens, J.; Clemens, M.S. Clemens 21708 False 89 89 Clemens 21708 Clemens 1929-07-27T00:00
292135 292135 4988848772 Rubiaceae Urophyllum Wall. Sarawak, Borneo; Gat, Upper Rejang River       1929-07-22T00:00 K005311359 Clemens, J.; Clemens, M.S. Clemens 21709 False 89 89 Clemens 21709 Clemens 1929-07-22T00:00
453013 453013 4988892413 Rubiaceae Urophyllum Wall. Sarawak, Borneo; Gat, Upper Rejang River       1929-07-06T00:00 K005311361 Clemens, J.; Clemens, M.S. Clemens 21714 False 89 89 Clemens 21714 Clemens 1929-07-06T00:00
349734 349734 4988852781 Rubiaceae Urophyllum Wall. Sarawak, Borneo; Gat, Upper Rejang River       1929-07-06T00:00 K005311360 Clemens, J.; Clemens, M.S. Clemens 21719 False 89 89 Clemens 21719 Clemens 1929-07-06T00: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]);