occ

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

15 rows where cluster_num_id = 19 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
568083 568083 1055360355 Araceae Pothos atropurpurascens M.Hotta   5.377939 117.087456   1933-02 BM001011445 J. Clemens & M.S. Clemens Clemens 35003 True 19 19 Clemens 35003 Clemens 1933-02
571980 571980 1056303295 Araceae Scindapsus rupestris Ridl. Mt. Kinabalu; Penibukan; 4000-5000' 6.066667 116.5 1371.5 1933-02-14 BM000581242 J. Clemens & M.S. Clemens Clemens 35004 True 19 19 Clemens 35004 Clemens 1933-02-14
603061 603061 864882703 Balanophoraceae Balanophora reflexa Becc. Malaysia: Marai Parai. Alt.: 1500 m. 03.1933-04.1933, Leg.: M. S. Clemens & J. Clemens 35015.     1500.0 1933-03 B 10 0365177 Clemens,M.S. & Clemens,J. Clemens 35015 False 19 19 Clemens 35015 Clemens 1933-03
236173 236173 575203693 Ericaceae Rhododendron retivenium Sleumer Malaysia:Sabah:Mount Kinabalu, Upper Kinataki river     2134.0 1933-02-22 E00001309 Clemens, Joseph & Clemens, Mary Strong Clemens 35017 False 19 19 Clemens 35017 Clemens 1933-02-22
488694 488694 1928064757 Ericaceae Rhododendron retivenium Sleumer B. N. Borneo. Upper Kinataki river. Mt. Kinabalu       1933-02-22 10393 J. Clemens Clemens 35017 False 19 19 Clemens 35017 Clemens 1933-02-22
508107 508107 1144761416 Ericaceae Rhododendron retivenium Sleumer       2100.0 1933-02-22 G00352182 Clemens, J. & M. S. Clemens Clemens 35017 False 19 19 Clemens 35017 Clemens 1933-02-22
573075 573075 1056043311 Ericaceae Rhododendron gracile H.Low ex Lindl.   5.377939 117.087456   1933-02-22 BM000996709 J. Clemens & M.S. Clemens Clemens 35017 True 19 19 Clemens 35017 Clemens 1933-02-22
611226 611226 1998587161 Ericaceae Rhododendron retivenium Sleumer Upper Kinataki River, 7000 feet       1933-02-22 barcode-00015645 J. Clemens & M. S. Clemens Clemens 35017 False 19 19 Clemens 35017 Clemens 1933-02-22
608326 608326 4028157315 Gesneriaceae Agalmyla bracteata (Stapf) B.L.Burtt B. N. Borneo, Marai Parai       1933-03-06 barcode-02312036 J. Clemens & M. S. Clemens Clemens 35026 False 19 19 Clemens 35026 Clemens 1933-03-06
376234 376234 912336929 Asparagaceae Dracaena Vand. ex L. Penibukan     1371.6 1933-03-11T00:00 K000401847 Clemens, J.; Clemens, M.S. Clemens 35031 False 19 19 Clemens 35031 Clemens 1933-03-11T00:00
496744 496744 2012793470 Asparagaceae Dracaena Vand. ex L. Mount Kinabalu, B. N. Borneo, Penibukan, 4-5000 ft.       1933-03-11 3910658 J. Clemens Clemens 35031 False 19 19 Clemens 35031 Clemens 1933-03-11
604554 604554 5139646508 Asparagaceae Dracaena Vand. ex L. Mount Kinabalu; Penibukan       1933-03-11 barcode-02656562 J. Clemens & M. S. Clemens Clemens 35031 False 19 19 Clemens 35031 Clemens 1933-03-11
634011 634011 4128526375 Daphniphyllaceae Daphniphyllum laurinum (Benth.) Baill. Mount Kinabalu; Penibukan       1933-03-06 barcode-02294528 J. Clemens & M. S. Clemens Clemens 35035 False 19 19 Clemens 35035 Clemens 1933-03-06
573728 573728 1919898037 Violaceae Rinorea obtusa (Korth.) Kuntze Mt. Kinabalu; Penibukan; 4000-5000' 6.066667 116.5 1371.5 1933-03-18 BM001217657 Joseph Clemens;Mary Strong Clemens Clemens 35047 True 19 19 Clemens 35047 Clemens 1933-03-18
663191 663191 5169603339 Violaceae Rinorea bengalensis (Wall.) Kuntze Mount Kinabalu; Penibukan       1933-03-18 barcode-02658936 J. Clemens & M. S. Clemens Clemens 35047 False 19 19 Clemens 35047 Clemens 1933-03-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]);