occ

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

35 rows where cluster_num_id = 43 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
288967 288967 5089805650 Ebenaceae Diospyros lanceifolia Roxb. Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K001423477 Clemens, M.S. Clemens 9600 False 43 43 Clemens 9600 Clemens 1915-12-14T00:00
265385 265385 4850452740 Poaceae Paspalum conjugatum P.J.Bergius British North Borneo; Mount Kinabalu Trip; Jesselton.       1915-12-14T00:00 K003928337 Clemens, M.S. Clemens 9601 False 43 43 Clemens 9601 Clemens 1915-12-14T00:00
265933 265933 4850457646 Poaceae Paspalum conjugatum P.J.Bergius British North Borneo; Mount Kinabalu Trip; Jesselton.       1915-12-14T00:00 K003928338 Clemens, M.S. Clemens 9601 False 43 43 Clemens 9601 Clemens 1915-12-14T00:00
323811 323811 4922201277 Fabaceae Phanera excelsa Miq. Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K002471523 Clemens, M.S. Clemens 9610 False 43 43 Clemens 9610 Clemens 1915-12-14T00:00
306438 306438 4849417439 Poaceae Dactyloctenium aegyptium (L.) Willd. Mount Kinabalu Trip, British North Borneo.       1915-12-14T00:00 K002091407 Clemens, M.S. Clemens 9624 False 43 43 Clemens 9624 Clemens 1915-12-14T00:00
614565 614565 1999323929 Gentianaceae Fagraea cymosa Merr. Jesselton       1915-12-14 barcode-00075984 M. S. Clemens Clemens 9627 False 43 43 Clemens 9627 Clemens 1915-12-14
416332 416332 4920381360 Fabaceae Desmodium heterophyllum (Willd.) DC. British North Borneo; Jesselton       1915-12-14T00:00 K003402534 Clemens, M.S. Clemens 9628 False 43 43 Clemens 9628 Clemens 1915-12-14T00:00
455994 455994 5130196250 Rubiaceae Timonius flavescens (Jacq.) Baker Jesselton       1915-12-14T00:00 K004684149 Clemens, M.S. Clemens 9629 False 43 43 Clemens 9629 Clemens 1915-12-14T00:00
472776 472776 4876588726 Elaeocarpaceae Elaeocarpus stipularis var. longipetiolatus (Merr.) Coode Jesselton       1915-12-14T00:00 K004630180 Clemens, M.S. Clemens 9634 False 43 43 Clemens 9634 Clemens 1915-12-14T00:00
244726 244726 3710731485 Pteridaceae Pteris vittata L. Mount Kinabalu, Jesselton       1915-12-14 1599163 M. S. Clemens Clemens 9637 False 43 43 Clemens 9637 Clemens 1915-12-14
342939 342939 912373395 Pteridaceae Pteris L. Jesselton [Kota Kinabalu]. 5.983334 116.066667   1915-12-14T00:00 K000445241 Clemens, M.S. Clemens 9637 True 43 43 Clemens 9637 Clemens 1915-12-14T00:00
354855 354855 5175242553 Rosaceae Rubus moluccanus var. angulosus Kalkman Mount Kinabalu; Jesselton       1915-12-14T00:00 K004274014 Clemens, M.S. Clemens 9643 False 43 43 Clemens 9643 Clemens 1915-12-14T00:00
258291 258291 4988867814 Rubiaceae Ixora labuanensis Bremek. Jesselton       1915-12-14T00:00 K005597503 Clemens, M.S. Clemens 9658 False 43 43 Clemens 9658 Clemens 1915-12-14T00:00
256683 256683 5200663645 Moraceae Ficus variegata Blume Jesselton.       1915-12-14T00:00 K005338686 Clemens, M.S. Clemens 9660 False 43 43 Clemens 9660 Clemens 1915-12-14T00:00
435866 435866 5082983949 Amaranthaceae Amaranthus viridis L. Jesselton       1915-12-14T00:00 K005478751 Clemens, M.S. Clemens 9667 False 43 43 Clemens 9667 Clemens 1915-12-14T00:00
314848 314848 4850387436 Poaceae Ischaemum rugosum Salisb. British North Borneo; Mount Kinablau Trip; Jesselton       1915-12-14T00:00 K002383821 Clemens, M.S. Clemens 9672 False 43 43 Clemens 9672 Clemens 1915-12-14T00:00
347411 347411 4602119507 Burmanniaceae Burmannia coelestis D.Don British North Borneo; Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K003635896 Clemens, M.S. Clemens 9680 False 43 43 Clemens 9680 Clemens 1915-12-14T00:00
449207 449207 4850389427 Poaceae Ischaemum muticum L. British North Borneo; Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K002383838 Clemens, M.S. Clemens 9681 False 43 43 Clemens 9681 Clemens 1915-12-14T00:00
298015 298015 4996970834 Nepenthaceae Nepenthes gracilis Korth. Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K005916412 Clemens, M.S. Clemens 9687 False 43 43 Clemens 9687 Clemens 1915-12-14T00:00
340307 340307 912512938 Lamiaceae Premna serratifolia L. Jesselton [Kota Kinabalu] 5.983334 116.066667   1915-12-14T00:00 K000646934 Clemens, M.S. Clemens 9693 True 43 43 Clemens 9693 Clemens 1915-12-14T00:00
465504 465504 4945338224 Fabaceae Airyantha borneensis (Oliv.) Brummitt Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K003826444 Clemens, M.S. Clemens 9695 False 43 43 Clemens 9695 Clemens 1915-12-14T00:00
246908 246908 3446894548 Pteridaceae Adiantum capillus-veneris L. Jesselton       1915-12 1225445 Mary S. Clemens Clemens 9700 False 43 43 Clemens 9700 Clemens 1915-12
325240 325240 912421172 Pteridaceae Adiantum tenerum Sw. Mt. Kinabalu: Jesselton 5.983333 116.066667   1915-12-14T00:00 K000506357 Clemens, M.S. Clemens 9700 True 43 43 Clemens 9700 Clemens 1915-12-14T00:00
372827 372827 5085164525 Rubiaceae Spermacoce exilis (L.O.Williams) C.D.Adams ex W.C.Burger & C.M.Taylor Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K006213115 Clemens, M.S. Clemens 9705 False 43 43 Clemens 9705 Clemens 1915-12-14T00:00
347799 347799 4873110655 Aquifoliaceae Ilex cymosa Blume Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K004920261 Clemens, M.S. Clemens 9706 False 43 43 Clemens 9706 Clemens 1915-12-14T00:00
250294 250294 4519491201 Commelinaceae Floscopa scandens Lour. British North Borneo; Jesselton; [Mount Kinabalu Trip]       1915-12-14T00:00 K002794891 Clemens, M.S. Clemens 9709 False 43 43 Clemens 9709 Clemens 1915-12-14T00:00
441571 441571 912620768 Lamiaceae Pogostemon auricularius (L.) Hassk. Jesseltown [Kota Kinabalu] 5.983334 116.066667   1915-12-14T00:00 K000824722 Clemens, M.S. Clemens 9711 True 43 43 Clemens 9711 Clemens 1915-12-14T00:00
294675 294675 4602004516 Cyperaceae Eleocharis spiralis (Rottb.) Roem. & Schult. British North Borneo; Mount Kinabalu; Jesselton       1915-12-14T00:00 K002422837 Clemens, M.S. Clemens 9716 False 43 43 Clemens 9716 Clemens 1915-12-14T00:00
310012 310012 4601927798 Cyperaceae Fuirena umbellata Rottb. Jesselton       1915-12-14T00:00 K002053286 Clemens, M.S. Clemens 9717 False 43 43 Clemens 9717 Clemens 1915-12-14T00:00
394933 394933 4602005269 Cyperaceae Cyperus polystachyos Rottb. British North Borneo; Mount Kinabalu Trip; Jesselton.       1915-12-14T00:00 K002454652 Clemens, M.S. Clemens 9722 False 43 43 Clemens 9722 Clemens 1915-12-14T00:00
395146 395146 4602147947 Cyperaceae Lepironia articulata (Retz.) Domin British North Borneo, Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K002060196 Clemens, M.S. Clemens 9723 False 43 43 Clemens 9723 Clemens 1915-12-14T00:00
484604 484604 4849373644 Poaceae Zoysia matrella (L.) Merr. British North Borneo; Mount Kinabau Trip; Jesselton       1915-12-14T00:00 K003920685 Clemens, M.S. Clemens 9728 False 43 43 Clemens 9728 Clemens 1915-12-14T00:00
566694 566694 2268929947 Poaceae Zoysia matrella (L.) Merr. Kota Kinabalu [original label Jesselton, Borneo].       1915-12-14 101031605 Mary Strong Clemens Clemens 9728 False 43 43 Clemens 9728 Clemens 1915-12-14
529892 529892 4928997482 Malvaceae Corchorus L. Mount Kinabalu Trip; Jesselton       1915-12-14T00:00 K005349853 Clemens, M.S. Clemens 9732 False 43 43 Clemens 9732 Clemens 1915-12-14T00:00
352045 352045 4938757463 Acanthaceae Asystasia gangetica (L.) T.Anderson North Borneo; Mount Kinabalu Trip; Jesselton.       1915-12-14T00:00 K004887077 Clemens, M.S. Clemens 9739 False 43 43 Clemens 9739 Clemens 1915-12-14T00: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]);