occ

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

6 rows where cluster_num_id = 87 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
282530 282530 912527260 Polypodiaceae Thylacopteris papillosa (Blume) Kunze ex J.Sm. Mt. Kinabalu, Dallas - Tenompok 6.0 116.516667 1067.5 1932-01-01T00:00 K000672795 Clemens, J.; Clemens, M.S. Clemens 27290 True 87 87 Clemens 27290 Clemens 1932-01-01T00:00
491355 491355 2012768648 Polypodiaceae Thylacopteris papillosa (Blume) Kunze ex J.Sm. Dallas - Tenompok       1932-01 3981584 J. Clemens Clemens 27290 False 87 87 Clemens 27290 Clemens 1932-01
590419 590419 1321449555 Polypodiaceae Thylacopteris papillosa (Blume) Kunze ex J.Sm. Malay Islands, Mount Kinabalu, B. N. Borneo, Upper Kinabalu, Dallas-Tenompok     1066.5 1932-01 US 1673087 J. Clemens & M. S. Clemens Clemens 27290 False 87 87 Clemens 27290 Clemens 1932-01
617979 617979 4404052522 Polypodiaceae Thylacopteris papillosa (Blume) Kunze ex J.Sm. Dallas - Tenompok       1932-01 barcode-02220558 J. Clemens & M. S. Clemens Clemens 27290 False 87 87 Clemens 27290 Clemens 1932-01
667544 667544 4404057627 Polypodiaceae Thylacopteris papillosa (Blume) Kunze ex J.Sm. Dallas - Tenompok       1932-01 barcode-02220550 J. Clemens & M. S. Clemens Clemens 27290 False 87 87 Clemens 27290 Clemens 1932-01
579191 579191 1321503412 Polypodiaceae Loxogramme scolopendrioides (Gaudich.) C.V.Morton Malay Islands, Mount Kinabalu, B. N. Borneo, Upper Kinabalu, B. N. B., Dallas     914.0 1932-01-03 US 1673095 J. Clemens & M. S. Clemens Clemens 27300 False 87 87 Clemens 27300 Clemens 1932-01-03

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