occ

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

8 rows where cluster_num_id = 97 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, 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
274919 274919 4873138648 Melastomataceae Anerincleistus quintuplinervis (Cogn.) J.F.Maxwell Mount Kinabalu; B. N. Borneo; Dallas       1932-11-10T00:00 K003895476 Clemens, J.; Clemens, M.S. Clemens 27013 False 97 97 Clemens 27013 Clemens 1932-11-10T00:00
496324 496324 4029509165 Melastomataceae Anerincleistus Korth. B. N. Borneo Mt. Kinabalu Dallas       1932-11-10 4395521 J. Clemens Clemens 27013 False 97 97 Clemens 27013 Clemens 1932-11-10
417672 417672 4979573635 Violaceae Viola yunnanensis W.Becker & H.Boissieu Mount Kinabalu; Tenompok       1932-11-10T00:00 K005043991 Clemens, J.; Clemens, M.S. Clemens 27032 False 97 97 Clemens 27032 Clemens 1932-11-10T00:00
625614 625614 5169585310 Violaceae Viola yunnanensis W.Becker & H.Boissieu Tenompok       1932-11-10 barcode-02659319 J. Clemens & M. S. Clemens Clemens 27032 False 97 97 Clemens 27032 Clemens 1932-11-10
302528 302528 912132983 Plagiogyriaceae Plagiogyria pycnophylla (Kunze) Mett. Mt. Kinabalu, Top Lowe's Peak 6.083333 116.55 4115.0 1932-11-14T00:00 K000083802 Clemens, J.; Clemens, M.S. Clemens 27043 True 97 97 Clemens 27043 Clemens 1932-11-14T00:00
494162 494162 1981506487 Plagiogyriaceae Plagiogyria pycnophylla (Kunze) Mett. Mount Kinabalu, Upper Kinabalu, Top Lowe's peak,       1932-11-14 03882302 J. Clemens Clemens 27043 False 97 97 Clemens 27043 Clemens 1932-11-14
368963 368963 912451309 Polypodiaceae Grammitis fasciata Blume Mt Kinabalu, below Paka 6.05 116.55 2972.5 1932-11-14T00:00 K000547817 Clemens, J.; Clemens, M.S. Clemens 27050 True 97 97 Clemens 27050 Clemens 1932-11-14T00:00
659564 659564 4406252364 Polypodiaceae Oreogrammitis fasciata (Blume) Parris Below Paka       1932-11-14 barcode-02220911 J. Clemens & M. S. Clemens Clemens 27050 False 97 97 Clemens 27050 Clemens 1932-11-14

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