occ

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

32 rows where cluster_num_id = 33 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
612164 612164 3909062306 Apocynaceae Strophanthus gratus (Wall. & Hook.) Baill. British North Borneo. Mount Kinabalu Trip.       1915-12-21 barcode-02375013 M. S. Clemens Clemens 9500 False 33 33 Clemens 9500 Clemens 1915-12-21
637026 637026 5829789943 Dilleniaceae Dillenia suffruticosa (Griff.) Martelli [no additional data]       1915-12-21 barcode-02665853 M. S. Clemens Clemens 9504 False 33 33 Clemens 9504 Clemens 1915-12-21
671159 671159 4924692270 Casuarinaceae Casuarina nobilis Whitmore [no additional data]       1915-12-21 barcode-02245738 M. S. Clemens Clemens 9505 False 33 33 Clemens 9505 Clemens 1915-12-21
285767 285767 4954063890 Myrtaceae Baeckea frutescens L. Mount Kinabalu Trip; Sandakan       1915-12-21T00:00 K004772403 Clemens, M.S. Clemens 9506 False 33 33 Clemens 9506 Clemens 1915-12-21T00:00
617477 617477 4173196377 Myrtaceae Baeckea frutescens L. [no additional data]       1915-12-21 barcode-02543751 M. S. Clemens Clemens 9506 False 33 33 Clemens 9506 Clemens 1915-12-21
634509 634509 4173196352 Myrtaceae Baeckea frutescens L. Sandakan       1915-12-21 barcode-02543732 M. S. Clemens Clemens 9506 False 33 33 Clemens 9506 Clemens 1915-12-21
632190 632190 4155227337 Elaeocarpaceae Elaeocarpus stipularis var. longipetiolatus (Merr.) Coode [no additional data]       1915-12-21 barcode-02467950 M. S. Clemens Clemens 9508 False 33 33 Clemens 9508 Clemens 1915-12-21
648857 648857 4536378325 Myrtaceae Syzygium bankense (Hassk.) Merr. & L.M.Perry on banks near the beach.       1915-12-21 barcode-02449779 M. S. Clemens Clemens 9509 False 33 33 Clemens 9509 Clemens 1915-12-21
616448 616448 4854212068 Fagaceae Lithocarpus conocarpus (Oudem.) Rehder Sandakan       1915-12-21 barcode-02554938 M. S. Clemens Clemens 9513 False 33 33 Clemens 9513 Clemens 1915-12-21
661209 661209 4527868272 Dipterocarpaceae Shorea smithiana Symington [no additional data]       1915-12-21 barcode-02227521 M. S. Clemens Clemens 9515 False 33 33 Clemens 9515 Clemens 1915-12-21
299825 299825 4850376501 Ochnaceae Campylospermum serratum (Gaertn.) Bittrich & M.C.E.Amaral Mount Kinabalu Trip; Sandakan       1915-12-21T00:00 K002248459 Clemens, M.S. Clemens 9519 False 33 33 Clemens 9519 Clemens 1915-12-21T00:00
642403 642403 4977926048 Ochnaceae Gomphia serrata (Gaertn.) Kanis [no additional data]       1915-12-21 barcode-02267507 M. S. Clemens Clemens 9519 False 33 33 Clemens 9519 Clemens 1915-12-21
630850 630850 4142720349 Verbenaceae Lantana camara L. [no additional data]       1915-12-21 barcode-02324688 M. S. Clemens Clemens 9521 False 33 33 Clemens 9521 Clemens 1915-12-21
243232 243232 3710723587 Blechnaceae Blechnopsis finlaysoniana (Wall. ex Hook. & Grev.) C.Presl Sandakan       1915-12-21 1613513 Mary Strong Clemens Clemens 9527 False 33 33 Clemens 9527 Clemens 1915-12-21
408263 408263 4850390704 Poaceae Imperata conferta (J.Presl) Ohwi North Borneo; Mount Kinabalu; Sandakan.       1915-12-21T00:00 K002388423 Clemens, M.S. Clemens 9528 False 33 33 Clemens 9528 Clemens 1915-12-21T00:00
613238 613238 5917411624 Rubiaceae Catunaregam spinosa (Thunb.) Tirveng. [no additional data]       1915-12-21 barcode-02635226 M. S. Clemens Clemens 9529 False 33 33 Clemens 9529 Clemens 1915-12-21
243886 243886 2628267366 Pteridaceae Adiantum caudatum L. Kudat       1915-12-20 1225448 Mary Strong Clemens Clemens 9532 False 33 33 Clemens 9532 Clemens 1915-12-20
375227 375227 912420118 Pteridaceae Adiantum caudatum L. Mt. Kinabalu: Kudat 6.883334 116.833334   1915-12-20T00:00 K000505305 Clemens, M.S. Clemens 9532 True 33 33 Clemens 9532 Clemens 1915-12-20T00:00
294881 294881 5236111377 Convolvulaceae Porana volubilis Burm.fil. Mount Kinabalu; Kudat       1915-12-20T00:00 K001786381 Clemens, M.S. Clemens 9533 False 33 33 Clemens 9533 Clemens 1915-12-20T00:00
619117 619117 4981857205 Convolvulaceae Porana volubilis Burm.fil. [no additional data]       1915-12-20 barcode-02421316 M. S. Clemens Clemens 9533 False 33 33 Clemens 9533 Clemens 1915-12-20
634307 634307 4981856476 Convolvulaceae Porana volubilis Burm.fil. [no additional data]       1915-12-20 barcode-02421314 M. S. Clemens Clemens 9533 False 33 33 Clemens 9533 Clemens 1915-12-20
658939 658939 5029074844 Anacardiaceae Buchanania arborescens (Blume) Blume [no additional data]       1915-12-20 barcode-02278835 M. S. Clemens Clemens 9540 False 33 33 Clemens 9540 Clemens 1915-12-20
606853 606853 4981856983 Phyllanthaceae Aporosa octandra var. malesiana Schot [no additional data]       1915-12-20 barcode-02487932 M. S. Clemens Clemens 9541 False 33 33 Clemens 9541 Clemens 1915-12-20
610003 610003 5891501139 Malvaceae Grewia acuminata Juss. [no additional data]       1915-12-20 barcode-02677030 M. S. Clemens Clemens 9542 False 33 33 Clemens 9542 Clemens 1915-12-20
636793 636793 4078780482 Lamiaceae Callicarpa cana L. Kudat       1915-12-20 barcode-02325917 M. S. Clemens Clemens 9543 False 33 33 Clemens 9543 Clemens 1915-12-20
670545 670545 4602980471 Fabaceae Peltophorum pterocarpum (DC.) Backer ex K.Heyne [no additional data]       1915-12-20 barcode-02231939 M. S. Clemens Clemens 9546 False 33 33 Clemens 9546 Clemens 1915-12-20
468485 468485 4608053627 Poaceae Eriochloa procera (Retz.) C.E.Hubb. North Borneo; Mount Kinabalu Trip; Kudat       1915-12-20T00:00 K003925821 Clemens, M.S. Clemens 9551 False 33 33 Clemens 9551 Clemens 1915-12-20T00:00
428733 428733 4949690741 Fabaceae Clitoria ternatea L. British North Borneo; Mount Kinabalu Trip; Kudat       1915-12-20T00:00 K003218931 Clemens, M.S. Clemens 9553 False 33 33 Clemens 9553 Clemens 1915-12-20T00:00
631723 631723 4900310381 Fabaceae Clitoria ternatea L. [no additional data]       1915-12-20 barcode-02233454 M. S. Clemens Clemens 9553 False 33 33 Clemens 9553 Clemens 1915-12-20
300001 300001 5145875988 Orobanchaceae Centranthera humifusa Wall., 1831 Mount Kinabalu; Kudai       1915-12-20T00:00 K004128018 Clemens, M.S. Clemens 9555 False 33 33 Clemens 9555 Clemens 1915-12-20T00:00
348692 348692 4849375679 Poaceae Eragrostis pilosa (L.) P.Beauv. British North Borneo; Mount Kinabalu Trip; Kudai       1915-12-20T00:00 K003982095 Clemens, M.S. Clemens 9561 False 33 33 Clemens 9561 Clemens 1915-12-20T00:00
609121 609121 4905504431 Poaceae Eragrostis pilosa (L.) P.Beauv. [no additional data]       1915-12-20 barcode-02472996 M. S. Clemens Clemens 9561 False 33 33 Clemens 9561 Clemens 1915-12-20

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