occ

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

8 rows where cluster_num_id = 11 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, 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
5633 5633 2829897117 Polypodiaceae Lemmaphyllum accedens (Blume) Donk Borneo: Mt Kinabalu. Tenompok.     1500.0 1932-05-24 CANB 277074.1 Clemens, J. Clemens 28199 False 11 11 Clemens 28199 Clemens 1932-05-24
576930 576930 1322282290 Polypodiaceae Lemmaphyllum accedens (Blume) Donk B. N. Borneo: Mt. Kinabalu, Tenompok, Upper Kinabalu     1524.0 1932-05-24 US 1673254 J. Clemens & M. S. Clemens Clemens 28199 False 11 11 Clemens 28199 Clemens 1932-05-24
664932 664932 4404044597 Polypodiaceae Lemmaphyllum accedens (Blume) Donk Dallas       1932-05-24 barcode-02509708 J. Clemens & M. S. Clemens Clemens 28199 False 11 11 Clemens 28199 Clemens 1932-05-24
302408 302408 5000168645 Apocynaceae Rauvolfia verticillata (Lour.) Baill. Mount Kinabalu; Tenompok       1932-05-09T00:00 K005623354 Clemens, J.; Clemens, M.S. Clemens 28200 False 11 11 Clemens 28200 Clemens 1932-05-09T00:00
357411 357411 4992570347 Apocynaceae Rauvolfia verticillata (Lour.) Baill. Mt. Kinabalu       1932-05-09T00:00 K005623321 Clemens Clemens 28200 False 11 11 Clemens 28200 Clemens 1932-05-09T00:00
492821 492821 2447317875 Apocynaceae Rauvolfia verticillata (Lour.) Baill. Mount Kinabalu, Tenompok       1932-05-09 4203050 J. Clemens Clemens 28200 False 11 11 Clemens 28200 Clemens 1932-05-09
614859 614859 3899644308 Apocynaceae Rauvolfia verticillata (Lour.) Baill. Mount Kinabalu, B. N. Borneo, Tenompok       1932-05-09 barcode-02009049 J. Clemens & M. S. Clemens Clemens 28200 False 11 11 Clemens 28200 Clemens 1932-05-09
641541 641541 3899636301 Apocynaceae Rauvolfia verticillata (Lour.) Baill. Mount Kinabalu, B. N. Borneo       1932-05-08 barcode-02009055 J. Clemens & M. S. Clemens Clemens 28200 False 11 11 Clemens 28200 Clemens 1932-05-08

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