occ

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

11 rows where cluster_num_id = 81 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
280161 280161 912537566 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Mt Matang 1.583333 110.2 396.0 1929-10-25T00:00 K000689438 Clemens, M.S.; Clemens, J. Clemens 7697 True 81 81 Clemens 7697 Clemens 1929-10-25T00:00
324182 324182 912537535 Cyatheaceae Cyathea latebrosa (Wall. ex Hook.) Copel. Mt Matang 1.583333 110.2 396.0 1929-10-25T00:00 K000689439 Clemens, M.S.; Clemens, J. Clemens 7697 True 81 81 Clemens 7697 Clemens 1929-10-25T00:00
318193 318193 5888764338 Thelypteridaceae Pronephrium nitidum (Holttum) Holttum Island or Province Sarawak, Borneo; Matang; Near Bungalaw; Mount Matang       1929-10-25T00:00 K000668766 Clemens, M.S.; Clemens, J. Clemens 7699 False 81 81 Clemens 7699 Clemens 1929-10-25T00:00
422822 422822 5103987388 Rubiaceae Lasianthus tenuifolius H.Zhu Sarawak, Borneo; Mount Matang       1929-10-25T00:00 K005666930 Clemens, J.; Clemens, M.S. Clemens 7705 False 81 81 Clemens 7705 Clemens 1929-10-25T00:00
399027 399027 4850509848 Euphorbiaceae Macaranga trichocarpa (Zoll.) Müll.Arg. Borneo; Mount Matang       1929-10-26T00:00 K004153400 Clemens, J.; Clemens, M.S. Clemens 7712 False 81 81 Clemens 7712 Clemens 1929-10-26T00:00
604503 604503 4404046514 Euphorbiaceae Macaranga trichocarpa (Zoll.) Müll.Arg. Mount Matang       1929-10-26 barcode-02414699 J. Clemens & M. S. Clemens Clemens 7712 False 81 81 Clemens 7712 Clemens 1929-10-26
347372 347372 4954096323 Anisophylleaceae Anisophyllea disticha (Jack) Baill. Island or Province Sarawak, Borneo; Mount Matang       1929-10-26T00:00 K003356897 Clemens, J.; Clemens, M.S. Clemens 7715 False 81 81 Clemens 7715 Clemens 1929-10-26T00:00
410196 410196 912336524 Asparagaceae Dracaena elliptica Thunb. & Dalm. Mount Matang     335.28 1929-10-24T00:00 K000401690 Clemens, J.; Clemens M.S. Clemens 7717 False 81 81 Clemens 7717 Clemens 1929-10-24T00:00
527449 527449 5130183845 Rubiaceae Prismatomeris lepidophloia (Miq.) Ridl. Sarawak, Borneo; Mount Matang       1929-10-26T00:00 K005264378 Clemens, J.; Clemens, M.S. Clemens 7718 False 81 81 Clemens 7718 Clemens 1929-10-26T00:00
277059 277059 4988877030 Rubiaceae Ixora pyrantha Bremek. Sarawak. Borneo; Mount Matang       1929-10-26T00:00 K005597187 Clemens, J.; Clemens, M.S. Clemens 7720 False 81 81 Clemens 7720 Clemens 1929-10-26T00:00
458117 458117 5072847799 Gesneriaceae Codonoboea crinita (Jack) C.L.Lim Island or Province Sarawak, Borneo; Mount Matang       1929-10-22T00:00 K006190764 Clemens, J.; Clemens, M.S. Clemens 7735 False 81 81 Clemens 7735 Clemens 1929-10-22T00:00

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