occ

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

75 rows where cluster_num_id = 25 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, locality, decimalLatitude, decimalLongitude, eventDate, recordedBy, has_coordinates, 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
405265 405265 4850374468 Ochnaceae Campylospermum serratum (Gaertn.) Bittrich & M.C.E.Amaral Mount Kinabalu Trip; Sandakan       1915-10-18T00:00 K002248457 Clemens, M.S. Clemens 9438 False 25 25 Clemens 9438 Clemens 1915-10-18T00:00
619201 619201 4977926944 Ochnaceae Gomphia serrata (Gaertn.) Kanis [no additional data]       1915-10-18 barcode-02267506 M. S. Clemens Clemens 9438 False 25 25 Clemens 9438 Clemens 1915-10-18
656380 656380 4977927065 Ochnaceae Gomphia serrata (Gaertn.) Kanis [no additional data]       1915-10-18 barcode-02267565 M. S. Clemens Clemens 9438 False 25 25 Clemens 9438 Clemens 1915-10-18
318987 318987 5103987729 Symplocaceae Symplocos adenophylla Wall. ex G.Don Mount Kinabalu Trip; Sandakan       1915-10-18T00:00 K005936273 Clemens, M.S. Clemens 9439 False 25 25 Clemens 9439 Clemens 1915-10-18T00:00
643675 643675 4950628547 Symplocaceae Symplocos adenophylla Wall. ex G.Don [no additional data]       1915-10-18 barcode-02600714 M. S. Clemens Clemens 9439 False 25 25 Clemens 9439 Clemens 1915-10-18
666509 666509 4950628436 Symplocaceae Symplocos adenophylla Wall. ex G.Don [no additional data]       1915-10-18 barcode-02600719 M. S. Clemens Clemens 9439 False 25 25 Clemens 9439 Clemens 1915-10-18
526882 526882 4857047499 Cyatheaceae Sphaeropteris trichophora (Copel.) R.M.Tryon British North Borneo: Sandakan. Mount Kinabalu.       1915-10-18 UC211766 M. S. Clemens Clemens 9440 False 25 25 Clemens 9440 Clemens 1915-10-18
629649 629649 4924688007 Melastomataceae Anerincleistus purpureus (Stapf) J.F.Maxwell [no additional data]       1915-10-18 barcode-02557418 M. S. Clemens Clemens 9444 False 25 25 Clemens 9444 Clemens 1915-10-18
626432 626432 4607706580 Gesneriaceae Henckelia Spreng. [no additional data]       1915-10-18 barcode-02314130 M. S. Clemens Clemens 9445 False 25 25 Clemens 9445 Clemens 1915-10-18
425647 425647 4958508625 Phyllanthaceae Glochidion J.R.Forst. & G.Forst. Sandakan       1915-10-18T00:00 K005533375 Clemens, M.S. Clemens 9446 False 25 25 Clemens 9446 Clemens 1915-10-18T00:00
672123 672123 5130968348 Phyllanthaceae Glochidion littorale Benth. [no additional data]       1915-10-18 barcode-02334860 M. S. Clemens Clemens 9446 False 25 25 Clemens 9446 Clemens 1915-10-18
370745 370745 5891325879 Myrtaceae Syzygium elopurae (Ridl.) Merr. & L.M.Perry British North Borneo; Sandakan       1915-10-18T00:00 K000259442 Clemens, M.S. Clemens 9448 False 25 25 Clemens 9448 Clemens 1915-10-18T00:00
641317 641317 4597962346 Myrtaceae Syzygium elopurae (Ridl.) Merr. & L.M.Perry Sandakan       1915-10-18 barcode-02448271 M. S. Clemens Clemens 9448 False 25 25 Clemens 9448 Clemens 1915-10-18
350811 350811 5004311441 Loranthaceae Macrosolen cochinchinensis (Lour.) Tiegh. Mount Kinabalu; Sandakan.       1915-10-18T00:00 K005816211 Clemens, M.S. Clemens 9450 False 25 25 Clemens 9450 Clemens 1915-10-18T00:00
596572 596572 4856467052 Loranthaceae Elytranthe (Blume) Blume Mount Kinabalu. Sandakan       1915-10-18 UC214781 Mary Strong Clemens Clemens 9450 False 25 25 Clemens 9450 Clemens 1915-10-18
672670 672670 4070113356 Smilacaceae Smilax L. [no additional data]       1915-10-18 barcode-02325495 M. S. Clemens Clemens 9451 False 25 25 Clemens 9451 Clemens 1915-10-18
285374 285374 5072752389 Primulaceae Maesa sumatrana Scheff. Mount Kinabalu Trip; Sandakan       1915-10-18T00:00 K000271237 Clemens, M.S. Clemens 9452 False 25 25 Clemens 9452 Clemens 1915-10-18T00:00
609087 609087 4927358915 Primulaceae Maesa Forssk. Sandakan       1915-10-18 barcode-02442894 M. S. Clemens Clemens 9452 False 25 25 Clemens 9452 Clemens 1915-10-18
641208 641208 4927354376 Primulaceae Maesa ramentacea (Roxb.) A.DC. [no additional data]       1915-10-18 barcode-02442835 M. S. Clemens Clemens 9452 False 25 25 Clemens 9452 Clemens 1915-10-18
255556 255556 5060754131 Melastomataceae Memecylon L. Sandakan       1915-10-18T00:00 K004411826 Clemens, M.S. Clemens 9454 False 25 25 Clemens 9454 Clemens 1915-10-18T00:00
652193 652193 5052125201 Melastomataceae Memecylon paniculatum Jack [no additional data]       1915-10-18 barcode-01539031 M. S. Clemens Clemens 9454 False 25 25 Clemens 9454 Clemens 1915-10-18
420631 420631 5060751383 Poaceae Eragrostis unioloides (Retz.) Nees ex Steud. Sandakan       1915-10-18T00:00 K003982192 Clemens, M.S. Clemens 9457 False 25 25 Clemens 9457 Clemens 1915-10-18T00:00
668935 668935 4905503441 Poaceae Eragrostis unioloides (Retz.) Nees ex Steud. [no additional data]       1915-10-18 barcode-02473023 M. S. Clemens Clemens 9457 False 25 25 Clemens 9457 Clemens 1915-10-18
454670 454670 4535522046 Cyperaceae Fimbristylis pauciflora R.Br. British North Borneo; Sandakan.       1915-10-18T00:00 K002291008 Clemens, M.S. Clemens 9459 False 25 25 Clemens 9459 Clemens 1915-10-18T00:00
635686 635686 4846546378 Cyperaceae Fimbristylis pauciflora R.Br. [no additional data]       1915-10-18 barcode-02429746 M. S. Clemens Clemens 9459 False 25 25 Clemens 9459 Clemens 1915-10-18
278022 278022 5083039397 Oleaceae Chionanthus ramiflorus Roxb. Mount Kinabalu Trip; Sandakan       1915-10-18T00:00 K006187257 Clemens, M.S. Clemens 9460 False 25 25 Clemens 9460 Clemens 1915-10-18T00:00
621899 621899 4527901572 Oleaceae Chionanthus ramiflorus Roxb. [no additional data]       1915-10-18 barcode-02459605 M. S. Clemens Clemens 9460 False 25 25 Clemens 9460 Clemens 1915-10-18
654093 654093 4527860336 Oleaceae Chionanthus ramiflorus Roxb. [no additional data]       1915-10-18 barcode-02459636 M. S. Clemens Clemens 9460 False 25 25 Clemens 9460 Clemens 1915-10-18
658708 658708 4527851530 Oleaceae Chionanthus ramiflorus Roxb. [no additional data]       1915-10-18 barcode-02459595 M. S. Clemens Clemens 9460 False 25 25 Clemens 9460 Clemens 1915-10-18
648506 648506 5917412585 Rubiaceae Aidia borneensis Ridsdale [no additional data]       1915-10-18 barcode-02635310 M. S. Clemens Clemens 9462 False 25 25 Clemens 9462 Clemens 1915-10-18
644216 644216 4950631004 Melastomataceae Clidemia hirta (L.) D.Don [no additional data]       1915-10-18 barcode-02270483 M. S. Clemens Clemens 9464 False 25 25 Clemens 9464 Clemens 1915-10-18
610871 610871 4078788337 Elaeocarpaceae Elaeocarpus longipetiolatus Merr. Sandakan       1915-10-18 barcode-01830329 M. S. Clemens Clemens 9465 False 25 25 Clemens 9465 Clemens 1915-10-18
450231 450231 4850376295 Poaceae Ischaemum muticum L. British North Borneo; Mount Kinabalu Trip; Sandakan       1915-10-18T00:00 K002383839 Clemens, M.S. Clemens 9466 False 25 25 Clemens 9466 Clemens 1915-10-18T00:00
669360 669360 4874572603 Poaceae Ischaemum muticum L. [no additional data]       1915-10-18 barcode-02469860 M. S. Clemens Clemens 9466 False 25 25 Clemens 9466 Clemens 1915-10-18
404759 404759 5103988408 Rubiaceae Lasianthus sepalinus Ridl. Mount Kinabalu Trip; Sandakan       1915-10-18T00:00 K005666814 Clemens, M.S. Clemens 9467 False 25 25 Clemens 9467 Clemens 1915-10-18T00:00
608909 608909 6159762903 Rubiaceae Gynochthodes celebica (Miq.) Razafim. & B.Bremer [no additional data]       1915-10-18 barcode-02700451 M. S. Clemens Clemens 9468 False 25 25 Clemens 9468 Clemens 1915-10-18
614169 614169 5796814762 Sapindaceae Guioa pubescens (Zoll. & Moritzi) Radlk. [no additional data]       1915-10-18 barcode-02553958 M. S. Clemens Clemens 9470 False 25 25 Clemens 9470 Clemens 1915-10-18
345220 345220 4951998892 Fabaceae Crotalaria pallida Aiton Mount Kinabalu Trip; Sandakan       1915-10-18T00:00 K003018931 Clemens, M.S. Clemens 9471 False 25 25 Clemens 9471 Clemens 1915-10-18T00:00
612821 612821 4900312145 Fabaceae Crotalaria pallida Aiton [no additional data]       1915-10-18 barcode-02233557 M. S. Clemens Clemens 9471 False 25 25 Clemens 9471 Clemens 1915-10-18
333975 333975 4607943398 Zingiberaceae Alpinia aquatica (Retz.) Roscoe Sandakan. Mount Kinabalu ,British North Borneo       1915-10-18T00:00 K002815836 Clemens, M.S. Clemens 9473 False 25 25 Clemens 9473 Clemens 1915-10-18T00:00
617147 617147 4060292420 Zingiberaceae Alpinia aquatica (Retz.) Roscoe Sandakan       1915-10-18 barcode-02532237 M. S. Clemens Clemens 9473 False 25 25 Clemens 9473 Clemens 1915-10-18
244121 244121 4058699304 Tectariaceae Tectaria barberi (Hook.) Copel. Sandakan       1915-10-18 1630737 Mary Strong Clemens Clemens 9475 False 25 25 Clemens 9475 Clemens 1915-10-18
357520 357520 912212903 Tectariaceae Tectaria barberi (Hook.) Copel. Sandakan 5.833334 118.116667   1915-10-18T00:00 K000236830 Clemens, M.S. Clemens 9475 True 25 25 Clemens 9475 Clemens 1915-10-18T00:00
621869 621869 4401126326 Tectariaceae Tectaria barberi (Hook.) Copel. Sandakan       1915-10-18 barcode-02507029 M. S. Clemens Clemens 9475 False 25 25 Clemens 9475 Clemens 1915-10-18
242639 242639 4058696411 Tectariaceae Polydictyum ternatum (Baker) S.Y.Dong & C.W.Chen Sandakan       1915-10-18 1631493 Mary Strong Clemens Clemens 9476 False 25 25 Clemens 9476 Clemens 1915-10-18
245206 245206 4058699150 Tectariaceae Tectaria barberi (Hook.) Copel. Sandakan       1915-10-18 1630732 Mary Strong Clemens Clemens 9477 False 25 25 Clemens 9477 Clemens 1915-10-18
247527 247527 4058699892 Tectariaceae Tectaria barberi (Hook.) Copel. Sandakan       1915-10-18 1630733 Mary Strong Clemens Clemens 9477 False 25 25 Clemens 9477 Clemens 1915-10-18
311617 311617 912307464 Hymenophyllaceae Trichomanes javanicum Blume Sandankan. 5.833334 118.116667   1915-10-18T00:00 K000361804 Clemens, M.S. Clemens 9478 True 25 25 Clemens 9478 Clemens 1915-10-18T00:00
628001 628001 3915837370 Hymenophyllaceae Cephalomanes javanicum (Blume) C.Presl [no additional data]       1915-10-18 barcode-02580764 M. S. Clemens Clemens 9478 False 25 25 Clemens 9478 Clemens 1915-10-18
243936 243936 3356308317 Pteridaceae Syngramma cartilagidens (Baker) Diels Sandakan       1915-10-18 1597697 Mary Strong Clemens Clemens 9479 False 25 25 Clemens 9479 Clemens 1915-10-18
386440 386440 912371610 Pteridaceae Syngramma cartilagidens (Baker) Diels Mount Kinabalu 5.833334 118.1   1915-10-18T00:00 K000443451 Clemens, M.S. Clemens 9479 True 25 25 Clemens 9479 Clemens 1915-10-18T00:00
605056 605056 4037225385 Pteridaceae Syngramma cartilagidens (Baker) Diels Sandakan       1915-10-18 barcode-02528629 M. S. Clemens Clemens 9479 False 25 25 Clemens 9479 Clemens 1915-10-18
246305 246305 4528448676 Polypodiaceae Pyrrosia lanceolata (L.) Farw. Sandakan       1915-10-18 1637756 Mary Strong Clemens Clemens 9481 False 25 25 Clemens 9481 Clemens 1915-10-18
244010 244010 4140929487 Polypodiaceae Drynaria quercifolia (L.) J.Sm. Sandakan       1915-10-18 1633977 Mary Strong Clemens Clemens 9482 False 25 25 Clemens 9482 Clemens 1915-10-18
247684 247684 3710724332 Blechnaceae Blechnopsis orientalis (L.) C.Presl Sandakan       1915-10-18 1613311 Mary Strong Clemens Clemens 9483 False 25 25 Clemens 9483 Clemens 1915-10-18
310399 310399 912133374 Nephrolepidaceae Nephrolepis biserrata (Sw.) Schott Sandakan 5.833334 118.116667   1915-10-18T00:00 K000084209 Clemens, M.S. Clemens 9484 True 25 25 Clemens 9484 Clemens 1915-10-18T00:00
541527 541527 4058693253 Nephrolepidaceae Nephrolepis biserrata (Sw.) Desv. Sadakan       1915-10-18 1628660 Mary Strong Clemens Clemens 9484 False 25 25 Clemens 9484 Clemens 1915-10-18
290364 290364 912354309 Lygodiaceae Lygodium flexuosum (L.) Sw. Sandakan 5.833334 118.116667   1915-10-18T00:00 K000422328 Clemens, M.S. Clemens 9485 True 25 25 Clemens 9485 Clemens 1915-10-18T00:00
658575 658575 3961886323 Lygodiaceae Lygodium flexuosum (L.) Sw. Sandakan       1915-10-18 barcode-02283448 M. S. Clemens Clemens 9485 False 25 25 Clemens 9485 Clemens 1915-10-18
309365 309365 912341866 Lygodiaceae Lygodium Sw. Mt. Kinabalu, Sandakan. 5.75 118.0   1915-10-18T00:00 K000409708 Clemens, M.S. Clemens 9487 True 25 25 Clemens 9487 Clemens 1915-10-18T00:00
314003 314003 912341841 Lygodiaceae Lygodium Sw. Mt. Kinabalu, Sandakan. 5.75 118.0   1915-10-18T00:00 K000409707 Clemens, M.S. Clemens 9487 True 25 25 Clemens 9487 Clemens 1915-10-18T00:00
552355 552355 3961881304 Lygodiaceae Lygodium circinnatum (Burm.fil.) Sw. Sandakan       1915-10-18 barcode-02283409 M. S. Clemens Clemens 9487 False 25 25 Clemens 9487 Clemens 1915-10-18
243115 243115 3336806431 Dennstaedtiaceae Pteridium aquilinum (L.) Kuhn Sandakan, Borneo       1915-10-18 1605910 Mary S. Clemens Clemens 9488 False 25 25 Clemens 9488 Clemens 1915-10-18
331859 331859 912421966 Dennstaedtiaceae Pteridium Gled. ex Scop. Mt. Kinabalu, Sandakan 5.833334 118.116667   1915-10-18T00:00 K000507161 Clemens, M.S. Clemens 9488 True 25 25 Clemens 9488 Clemens 1915-10-18T00:00
669622 669622 4060290358 Dennstaedtiaceae Pteridium aquilinum var. yarrabense Domin Sandakan       1915-10-18 barcode-02287833 M. S. Clemens Clemens 9488 False 25 25 Clemens 9488 Clemens 1915-10-18
244788 244788 4058692109 Davalliaceae Davallia solida (G.Forst.) Sw. Sandakan       1915-10-18 1629840 Mary Strong Clemens Clemens 9489 False 25 25 Clemens 9489 Clemens 1915-10-18
243005 243005 4499706383 Polypodiaceae Microsorum scolopendria (Burm.fil.) Copel. Sandakan       1915-10-18 1636442 Mary Strong Clemens Clemens 9490 False 25 25 Clemens 9490 Clemens 1915-10-18
330781 330781 912483053 Polypodiaceae Microsorum scolopendria (Burm.fil.) Copel. Sandakan 5.75 118.066667   1915-10-18T00:00 K000598205 Clemens, M.S. Clemens 9490 True 25 25 Clemens 9490 Clemens 1915-10-18T00:00
570031 570031 1056197722 Polypodiaceae Microsorum scolopendria (Burm.fil.) Copel.   5.377939 117.087456   1915-10-18 BM000036611 Mary Strong Clemens Clemens 9490 True 25 25 Clemens 9490 Clemens 1915-10-18
613741 613741 4404045600 Polypodiaceae Microsorum scolopendria (Burm.fil.) Copel. Sandakan       1915-10-18 barcode-02218579 M. S. Clemens Clemens 9490 False 25 25 Clemens 9490 Clemens 1915-10-18
371283 371283 912446719 Polypodiaceae Pyrrosia longifolia (Burm.fil.) C.V.Morton Sandakan 5.85 118.083333   1915-10-18T00:00 K000538324 Clemens, M.S. Clemens 9491 True 25 25 Clemens 9491 Clemens 1915-10-18T00:00
609713 609713 4404047393 Polypodiaceae Pyrrosia longifolia (Burm.fil.) C.V.Morton Sandakan       1915-10-18 barcode-02219492 M. S. Clemens Clemens 9491 False 25 25 Clemens 9491 Clemens 1915-10-18
385259 385259 912397531 Pteridaceae Pityrogramma calomelanos (L.) Link Mount Kinabalu 5.833334 118.116667   1915-10-18T00:00 K000475372 Clemens, M.S. Clemens 9495 True 25 25 Clemens 9495 Clemens 1915-10-18T00:00
655014 655014 4028166349 Pteridaceae Pityrogramma calomelanos (L.) Link Sandakan       1915-10-18 barcode-02529743 M. S. Clemens Clemens 9495 False 25 25 Clemens 9495 Clemens 1915-10-18
604066 604066 4977927204 Ochnaceae Sauvagesia serrata (Korth.) Sastre [no additional data]       1915-10-18 barcode-02267732 M. S. Clemens Clemens 9498 False 25 25 Clemens 9498 Clemens 1915-10-18

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