occ

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

29 rows where cluster_num_id = 65 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, 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
313660 313660 4928989429 Moraceae Ficus pallescens (Weiblen) C.C.Berg Sarawak; Island or Province Sarawak; Mt. Matang       1929-10-27T00:00 K004599904 Clemens, M.S.; Clemens, J. Clemens 7759 False 65 65 Clemens 7759 Clemens 1929-10-27T00:00
426536 426536 5103936773 Rubiaceae Gardenia elata Ridl. Sarawak; Mt. Matang; Above trail Mt Side forest       1929-10-27T00:00 K001644797 Clemens, M.S.; Clemens, J. Clemens 7768 False 65 65 Clemens 7768 Clemens 1929-10-27T00:00
452533 452533 5294406641 Actinidiaceae Saurauia subcordata Korth. Sarawak; Borneo; Mount Matang       1929-10-27T00:00 K001261905 Clemens, J.; Clemens, M.S. Clemens 7769 False 65 65 Clemens 7769 Clemens 1929-10-27T00:00
455883 455883 5077843116 Rubiaceae Chassalia Comm. ex Poir. Sarawak, Borneo; Mount Matang       1929-10-27T00:00 K005722327 Clemens, J.; Clemens, M.S. Clemens 7772 False 65 65 Clemens 7772 Clemens 1929-10-27T00:00
424669 424669 5051841876 Thymelaeaceae Wikstroemia tenuiramis Miq. Island or Province Sarawak, Borneo; Mount Matang       1929-10-27T00:00 K005973930 Clemens, J.; Clemens, M.S. Clemens 7773 False 65 65 Clemens 7773 Clemens 1929-10-27T00:00
489395 489395 2447321933 Orchidaceae Trichotosia Blume forest, Mount Matang       1929-10-28 4169977 J. Clemens Clemens 7773 False 65 65 Clemens 7773 Clemens 1929-10-28
295818 295818 4873138643 Melastomataceae Anerincleistus macrophyllus Bakh.fil. Borneo; Mount Matang       1929-10-27T00:00 K003895399 Clemens, J.; Clemens, M.S. Clemens 7778 False 65 65 Clemens 7778 Clemens 1929-10-27T00:00
400181 400181 4873144297 Melastomataceae Anerincleistus angustifolius (Stapf) J.F.Maxwell Borneo; Mount Matang       1929-10-27T00:00 K003895347 Clemens, J.; Clemens, M.S. Clemens 7779 False 65 65 Clemens 7779 Clemens 1929-10-27T00:00
495039 495039 3311253322 Phyllanthaceae Sauropus androgynus (L.) Merr. Mount Matang, near Valombrosa       1929-10-29 4095878 J. Clemens Clemens 7781 False 65 65 Clemens 7781 Clemens 1929-10-29
489664 489664 2447367856 Orchidaceae Orchidaceae Mount Matang       1929-10-29 04170706 J. Clemens Clemens 7782 False 65 65 Clemens 7782 Clemens 1929-10-29
273470 273470 4988853981 Gentianaceae Cyrtophyllum fragrans (Roxb.) DC. Sarawak; M. Matang       1929-10-26T00:00 K004916132 Clemens, M.S.; Clemens, J. Clemens 7783 False 65 65 Clemens 7783 Clemens 1929-10-26T00:00
253389 253389 4988879414 Rubiaceae Oldenlandia santubongensis W.W.Sm. Sarawak, Borneo; Forest near summit; Island of Province Sarawak; [M. Matang]       1929-10-28T00:00 K004993674 Clemens, J.; Clemens, M.S. Clemens 7789 False 65 65 Clemens 7789 Clemens 1929-10-28T00:00
615235 615235 5105311408 Celastraceae Microtropis rigida Ridl. Mt. Matang       1929-10-28 barcode-02409683 M. S. Clemens Clemens 7794 False 65 65 Clemens 7794 Clemens 1929-10-28
624655 624655 4037224365 Pteridaceae Taenitis blechnoides (Willd.) Sw. Mt Matang       1929-10-28 barcode-02528734 J. Clemens & M. S. Clemens Clemens 7797 False 65 65 Clemens 7797 Clemens 1929-10-28
271191 271191 912559253 Cyatheaceae Cyathea arthropoda Copel. Mt. Matang, near top 1.6 110.183333 516.0 1929-10-28T00:00 K000721061 Clemens, J.; Clemens, M.S. Clemens 7800 True 65 65 Clemens 7800 Clemens 1929-10-28T00:00
380807 380807 5284344355 Rubiaceae Urophyllum Wall. Sarawak, Borneo; Mount Matang       1929-10-28T00:00 K005310539 Clemens, J.; Clemens, M.S. Clemens 7811 False 65 65 Clemens 7811 Clemens 1929-10-28T00:00
404444 404444 912665976 Selaginellaceae Selaginella P.Beauv. Mount Matang 1.583333 110.2   1929-10-26T00:00 K000889206 Clemens, J.; Clemens, M.S. Clemens 7812 True 65 65 Clemens 7812 Clemens 1929-10-26T00:00
309848 309848 912594693 Pandanaceae Pandanus korthalsii Solms Mt. Matang     853.44 1929-10-28T00:00 K000781352 Clemens, M.S.; Clemens, J. Clemens 7814 False 65 65 Clemens 7814 Clemens 1929-10-28T00:00
415735 415735 5138400242 Chloranthaceae Chloranthus Sw. Sarawak, Borneo; Mount Matang       1929-10-28T00:00 K003994975 Clemens, J.; Clemens, M.S. Clemens 7816 False 65 65 Clemens 7816 Clemens 1929-10-28T00:00
394976 394976 5843826214 Symplocaceae Symplocos rubiginosa Wall. Borneo; Island or Province Sarawak; Mount Matang       1929-10-28T00:00 K006280934 Clemens, J.; Clemens, M.S. Clemens 7821 False 65 65 Clemens 7821 Clemens 1929-10-28T00:00
286585 286585 5083008020 Primulaceae Ardisia Sw. Sarawak, Borneo; Mount Matang       1929-10-28T00:00 K006164205 Clemens, J.; Clemens, M.S. Clemens 7828 False 65 65 Clemens 7828 Clemens 1929-10-28T00:00
320385 320385 4607920426 Zingiberaceae Zingiber Mill. Mt. Matang.       1929-10-28T00:00 K002429157 Clemens, M.S.; Clemens, J. Clemens 7834 False 65 65 Clemens 7834 Clemens 1929-10-28T00:00
391906 391906 5175230399 Primulaceae Embelia coriacea Wall. ex A.DC. Borneo; Island or Province: Sarawak; Mt Matang       1929-10-28T00:00 K001099849 Clemens, J.; Clemens, M.S. Clemens 7845 False 65 65 Clemens 7845 Clemens 1929-10-28T00:00
270510 270510 4876606730 Melastomataceae Pternandra Jack Sarawak, Borneo; Island or Province; Mount Matang       1929-10-28T00:00 K004410551 Clemens, J.; Clemens, M.S. Clemens 7851 False 65 65 Clemens 7851 Clemens 1929-10-28T00:00
276684 276684 5083014416 Pentaphylacaceae Eurya Thunb. Sarawak, Borneo; Mount Matang; Side of Peak       1929-10-28T00:00 K006002758 Clemens, J.; Clemens, M.S. Clemens 7853 False 65 65 Clemens 7853 Clemens 1929-10-28T00:00
378147 378147 5228666519 Marattiaceae Angiopteris brooksii Copel. Island or Province Sarawak, Borneo; Mount Matang       1929-10-28T00:00 K006540169 Clemens, J.; Clemens, M.S. Clemens 7872 False 65 65 Clemens 7872 Clemens 1929-10-28T00:00
262862 262862 4954099645 Casuarinaceae Gymnostoma sumatranum (Jungh. ex de Vriese) L.A.S.Johnson Mt Matang; bungalow garden at Valambrosa       1929-10-28T00:00 K003417901 Clemens, J.; Clemens, M.S. Clemens 7874 False 65 65 Clemens 7874 Clemens 1929-10-28T00:00
495261 495261 2239558219 Orchidaceae Cleisostoma teretifolium Teijsm. & Binn. Mt. Matang       1929-10-29 04027141 J. Clemens Clemens 7885 False 65 65 Clemens 7885 Clemens 1929-10-29
434151 434151 4873091873 Melastomataceae Ochthocharis bornensis Blume Borneo; Kuching Ferry to Bau       1929-10-30T00:00 K003896062 Clemens, J.; Clemens, M.S. Clemens 7890 False 65 65 Clemens 7890 Clemens 1929-10-30T00: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]);