occ

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

29 rows where cluster_num_id = 1 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, 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
492332 492332 3783410332 Commelinaceae Forrestia glabrata (Hassk.) Hassk. Mount Kinabalu B. N. Borneo Penataran river       1933-07-26 4319742 J. Clemens Clemens 34272 False 1 1 Clemens 34272 Clemens 1933-07-26
629361 629361 5130972715 Commelinaceae Amischotolype glabrata Hassk. Penataran rievr       1933-07-26 barcode-02655267 J. Clemens & M. S. Clemens Clemens 34272 False 1 1 Clemens 34272 Clemens 1933-07-26
494472 494472 3898430931 Hypoxidaceae Curculigo Gaertn. Mount Kinabalu B. N. Borneo Keebambang river       1933-07-20 4354761 J. Clemens Clemens 34273 False 1 1 Clemens 34273 Clemens 1933-07-20
609168 609168 4167030531 Hypoxidaceae Curculigo Gaertn. B. N. Borneo; Keebambang river       1933-07-20 barcode-02461809 J. Clemens Clemens 34273 False 1 1 Clemens 34273 Clemens 1933-07-20
664501 664501 4851581201 Cyperaceae Machaerina glomerata (Gaudich.) T.Koyama N. Penataran River.       1933-07-26 barcode-02430885 J. Clemens & M. S. Clemens Clemens 34274 False 1 1 Clemens 34274 Clemens 1933-07-26
373685 373685 912504073 Polypodiaceae Xiphopteris murudensis (Copel.) Copel. Mt. Kinabalu, ridge N [of] Panataran River 6.116667 116.533333 1300.0 1933-07-26T00:00 K000636834 Clemens, J.; Clemens, M.S. Clemens 34279 True 1 1 Clemens 34279 Clemens 1933-07-26T00:00
588799 588799 1320506174 Polypodiaceae Xiphopterella hieronymusii (C.Chr.) Parris Brit. Borneo. Mt. Kinabalu, Ridge North Panataran River.     1300.0 1933-07-26 US 2898578 -. Clemens Clemens 34279 False 1 1 Clemens 34279 Clemens 1933-07-26
464488 464488 5060740807 Clusiaceae Garcinia maingayi Hook.fil. ex T.Anderson Mount Kinabalu; B. N. Borneo; Penataran river       1933-07-28T00:00 K003860355 Clemens, J.; Clemens, M.S. Clemens 34286 False 1 1 Clemens 34286 Clemens 1933-07-28T00:00
475347 475347 4853868486 Begoniaceae Begonia fuscisetosa Sands Mount Kinabalu; B. N. Borneo; Penataran river       1933-07-28T00:00 K004752357 Clemens, J.; Clemens, M.S. Clemens 34287 False 1 1 Clemens 34287 Clemens 1933-07-28T00:00
634404 634404 4527891645 Begoniaceae Begonia fuscisetosa Sands Penataran river       1933-07-28 barcode-02225785 J. Clemens & M. S. Clemens Clemens 34287 False 1 1 Clemens 34287 Clemens 1933-07-28
264103 264103 5138398723 Lauraceae Beilschmiedia wallichiana (G.Don) Kosterm. Mount Kinabalu; Margin Penataran river       1933-07-26T00:00 K003272690 Clemens, J.; Clemens, M.S. Clemens 34290 False 1 1 Clemens 34290 Clemens 1933-07-26T00:00
653508 653508 4074169371 Lauraceae Beilschmiedia maingayi Hook.fil. Margin Penataran river       1933-07-26 barcode-02535544 J. Clemens & M. S. Clemens Clemens 34290 False 1 1 Clemens 34290 Clemens 1933-07-26
631053 631053 4866889786 Araliaceae Aralia merrillii C.B.Shang Penataran river       1933-07-28 barcode-02456279 J. Clemens & M. S. Clemens Clemens 34291 False 1 1 Clemens 34291 Clemens 1933-07-28
268557 268557 5236102650 Myristicaceae Knema kinabaluensis J.Sinclair Mount Kinabalu; Keebambang R.       1933-08-01T00:00 K004161578 Clemens, J.; Clemens, M.S. Clemens 34292 False 1 1 Clemens 34292 Clemens 1933-08-01T00:00
494795 494795 4093667847 Myristicaceae Knema kinabaluensis J.Sinclair Mount Kinabalu B. N. Borneo Keebambang R.       1933-08-01 4743658 J. Clemens Clemens 34292 False 1 1 Clemens 34292 Clemens 1933-08-01
12 12 473555398 Cyperaceae Carex exploratorum Nelmes Mount Kinabalu, Penataran River, head of gorge     1200.0 1933-07-28 MT00072448 Clemens, Joseph, Rev.; Clemens, Mary K.S. Clemens 34297 False 1 1 Clemens 34297 Clemens 1933-07-28
404914 404914 912256676 Cyperaceae Carex graeffeana Boeckeler Mount Kinabalu, Penataran River     1219.2 1933-07-28T00:00 K000291263 Clemens, J.; Clemens, M.S. Clemens 34297 False 1 1 Clemens 34297 Clemens 1933-07-28T00:00
491643 491643 1928832806 Cyperaceae Carex exploratorum Nelmes Mount Kimbalu. Penataran river. B. N. Borneo       1933-07-28 11569 J. Clemens Clemens 34297 False 1 1 Clemens 34297 Clemens 1933-07-28
603267 603267 237341700 Cyperaceae Carex exploratorum Nelmes Penataran river (Sungai Panataran).     1331.0 1933-07-28 B 10 0296462 Clemens,M.S. & Clemens,J. Clemens 34297 False 1 1 Clemens 34297 Clemens 1933-07-28
669146 669146 1998725867 Cyperaceae Carex exploratorum Nelmes Penataran River, Mount Kinabalu, 4000 feet       1933-07-28 barcode-00027555 J. Clemens & M. S. Clemens Clemens 34297 False 1 1 Clemens 34297 Clemens 1933-07-28
489498 489498 1949855868 Araceae Rhaphidophora korthalsii Schott Penataran river, Mount Kinabalu       1933-07-28 3802454 J. Clemens Clemens 34298 False 1 1 Clemens 34298 Clemens 1933-07-28
572954 572954 1057176555 Araceae Rhaphidophora korthalsii Schott   5.377939 117.087456 1066.5 1933-07-28 BM000581258 J. Clemens & M.S. Clemens Clemens 34298 True 1 1 Clemens 34298 Clemens 1933-07-28
644007 644007 1998664207 Araceae Rhaphidophora korthalsii Schott Mount Kinabalu, Penatrana river       1933-07-28 barcode-01630249 J. Clemens & M. S. Clemens Clemens 34298 False 1 1 Clemens 34298 Clemens 1933-07-28
496572 496572 2235426734 Orchidaceae Bulbophyllum caudatisepalum Ames & C.Schweinf. Mount Kinabalu, B.N. Borneo, Keebambang nr. Lobang.       1933-08-08 4012174 J. Clemens Clemens 34305 False 1 1 Clemens 34305 Clemens 1933-08-08
626340 626340 3880669336 Orchidaceae Bulbophyllum caudatisepalum Ames & C.Schweinf. Keebambang       1933-08-08 barcode-02386625 J. Clemens & M. S. Clemens Clemens 34305 False 1 1 Clemens 34305 Clemens 1933-08-08
624105 624105 4088831342 Ericaceae Vaccinium clementis Merr. Penaturan basin       1933-08-03 barcode-02544135 J. Clemens & M. S. Clemens Clemens 34310 False 1 1 Clemens 34310 Clemens 1933-08-03
670307 670307 3989249334 Orchidaceae Trichoglottis collenetteae J.J.Wood, C.L.Chan & A.Lamb Keebambang river       1933-08-09 barcode-01828934 J. Clemens & M. S. Clemens Clemens 34311 False 1 1 Clemens 34311 Clemens 1933-08-09
491374 491374 2273851153 Orchidaceae Eria Lindl. Mount Kinabalu, Marai Parai       1933-08-09 4088250 J. Clemens Clemens 34314 False 1 1 Clemens 34314 Clemens 1933-08-09
550572 550572 1057267330 Orchidaceae Aeridostachya robusta (Blume) Brieger Marei Parei Spur [Marai Parai Spur; NW Mt. Kinabalu]       1933-08-09 BM000506646 J. Clemens & M.S. Clemens Clemens 34314 False 1 1 Clemens 34314 Clemens 1933-08-09

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