occ

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

21 rows where cluster_num_id = 80 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, elevation, eventDate, recordedBy, recordNumber_mainNumber, 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
491028 491028 2235424650 Asphodelaceae Dianella Lam. ex Juss. Mount Kinabalu, B. N. Borneo, Dallas       1931-12-31 03987754 J. Clemens Clemens 30046 False 80 80 Clemens 30046 Clemens 1931-12-31
275026 275026 5283767696 Araliaceae Trachymene saniculifolia Stapf Mount Kinabalu; B.N. Borneo; Kamburanga; Upper Kinabalu       1932-01-08T00:00 K005635541 Clemens, J.; Clemens, M.S. Clemens 30058 False 80 80 Clemens 30058 Clemens 1932-01-08T00:00
480589 480589 4535536333 Iridaceae Patersonia borneensis Stapf Mount Kinabalu; Upper Kinabalu       1932-01-08T00:00 K002430013 Clemens, J.; Clemens, M.S. Clemens 30061 False 80 80 Clemens 30061 Clemens 1932-01-08T00:00
640557 640557 5156327311 Iridaceae Patersonia borneensis Stapf Kamburanga; Upper Kinabalu       1932-01-08 barcode-02657758 J. Clemens & M. S. Clemens Clemens 30061 False 80 80 Clemens 30061 Clemens 1932-01-08
551589 551589 1699836777 Ericaceae Vaccinium uroglossum Sleumer Tenompok     1525.0 1932 HBG507706 Clemens, J. & M.S. Clemens 30076 False 80 80 Clemens 30076 Clemens 1932
529356 529356 5166247936 Proteaceae Helicia pterygota Sleumer Mount Kinabalu; Dallas       1931-12-31T00:00 K004488098 Clemens, J.; Clemens, M.S. Clemens 30080 False 80 80 Clemens 30080 Clemens 1931-12-31T00:00
671862 671862 4950631526 Proteaceae Helicia pterygota Sleumer Dallas       1931-12-31 barcode-02258074 J. Clemens & M. S. Clemens Clemens 30080 False 80 80 Clemens 30080 Clemens 1931-12-31
495082 495082 2239545570 Orchidaceae Bulbophyllum montense Ridl. Mount Kinabalu, B. N. Borneo. Upper Kinabalu       1932-01-14 4012371 J. Clemens Clemens 30087 False 80 80 Clemens 30087 Clemens 1932-01-14
606634 606634 3887805410 Orchidaceae Bulbophyllum puntjakense J.J.Sm. Lumu Hill       1932-01-14 barcode-02385125 J. Clemens & M. S. Clemens Clemens 30087 False 80 80 Clemens 30087 Clemens 1932-01-14
490708 490708 2423968843 Orchidaceae Spathoglottis Blume Mount Kinabalu, B. N. Borneo, Dallas       1931-12-31 4154973 J. Clemens Clemens 30097 False 80 80 Clemens 30097 Clemens 1931-12-31
642541 642541 3887807364 Orchidaceae Bulbophyllum mutabile (Blume) Lindl. Tenompok       1932-01 barcode-02385004 J. Clemens & M. S. Clemens Clemens 30100 False 80 80 Clemens 30100 Clemens 1932-01
492976 492976 2251711993 Orchidaceae Dendrochilum grandiflorum (Ridl.) J.J.Sm. Mount Kinabalu, B. N. Borneo, Tenompok       1931-12-31 4069648 J. Clemens Clemens 30101 False 80 80 Clemens 30101 Clemens 1931-12-31
619517 619517 3462698382 Orchidaceae Dendrochilum grandiflorum (Ridl.) J.J.Sm. Dallas-Tinompok Spur       1931-12-31 barcode-02093916 J. Clemens & M. S. Clemens Clemens 30101 False 80 80 Clemens 30101 Clemens 1931-12-31
671840 671840 3462704304 Orchidaceae Dendrochilum pterogyne Carr Dallas-Tinompok Spur       1931-12-31 barcode-02093918 J. Clemens & M. S. Clemens Clemens 30101 False 80 80 Clemens 30101 Clemens 1931-12-31
628248 628248 3462703321 Orchidaceae Dendrochilum pterogyne Carr Dallas-Tenompok       1931-12-31 barcode-02153003 J. Clemens & M. S. Clemens Clemens 30102 False 80 80 Clemens 30102 Clemens 1931-12-31
494852 494852 2382939114 Orchidaceae Phreatia Lindl. Mount Kinabalu. B. N. Borneo. Dallas       1931-12-29 4118247 J. Clemens Clemens 30120 False 80 80 Clemens 30120 Clemens 1931-12-29
495103 495103 2382909834 Orchidaceae Phreatia Lindl. Mt. Kinabalu, B. N. Borneo, Dallas       1931-12-29 4118244 J. Clemens Clemens 30120 False 80 80 Clemens 30120 Clemens 1931-12-29
611509 611509 3925620324 Orchidaceae Phreatia monticola Rolfe Dallas; Mt Spur.       1931-12-29 barcode-01828064 J. Clemens & M. S. Clemens Clemens 30120 False 80 80 Clemens 30120 Clemens 1931-12-29
653730 653730 3925617333 Orchidaceae Phreatia monticola Rolfe Dallas; Mt. Spur.       1931-12-29 barcode-01828063 J. Clemens & M. S. Clemens Clemens 30120 False 80 80 Clemens 30120 Clemens 1931-12-29
602646 602646 178099752 Orchidaceae Eria Lindl. Malaysia: Mount Kinabalu. 1931-1932, Leg.: J. Clemens & M. S. Clemens 30123.       1932 B 10 0271971 Clemens,J. & Clemens,M.S. Clemens 30123 False 80 80 Clemens 30123 Clemens 1932
602821 602821 178099770 Orchidaceae Eria Lindl. Malaysia: Mount Kinabalu. 1931-1932, Leg.: J. Clemens & M. S. Clemens 30123.       1932 B 10 0271989 Clemens,J. & Clemens,M.S. Clemens 30123 False 80 80 Clemens 30123 Clemens 1932

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