occ

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

8 rows where cluster_num_id = 76 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, 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
300144 300144 912336328 Asparagaceae Dracaena angustifolia (Medik.) Roxb. Mount Poi     1219.2 1929-09-16T00:00 K000401486 Clemens, J.; Clemens, M.S. Clemens 6917 False 76 76 Clemens 6917 Clemens 1929-09-16T00:00
495593 495593 2447367993 Orchidaceae Tropidia Lindl. Mount Poi       1929-09-16 4170282 J. Clemens Clemens 6918 False 76 76 Clemens 6918 Clemens 1929-09-16
392194 392194 4954082632 Actinidiaceae Saurauia sakoembangensis var. sakoembangensis Sarawak; Island or Province Sarawak; Mount Poi; Upper Camp       1929-09-16T00:00 K001260325 Clemens, M.S.; Clemens, J. Clemens 6922 False 76 76 Clemens 6922 Clemens 1929-09-16T00:00
441006 441006 5082967321 Arecaceae Iguanura minor Kiew Sarawak; Borneo; Mount Poi       1929-09-01T00:00 K001835063 Clemens, J.; Clemens, M.S. Clemens 6926 False 76 76 Clemens 6926 Clemens 1929-09-01T00:00
489864 489864 1928380678 Arecaceae Iguanura Blume Borneo, Forest. Mount Poi.       1929-09-16 02326115 J. Clemens Clemens 6926 False 76 76 Clemens 6926 Clemens 1929-09-16
269654 269654 5145860995 Myristicaceae Knema latericia Elmer Mount Poi     2000.0 1929-09-01T00:00 K004161737 Clemens, J.; Clemens, M.S. Clemens 6931 False 76 76 Clemens 6931 Clemens 1929-09-01T00:00
530441 530441 5130169843 Annonaceae Polyalthia cauliflora Hook.f. & Thomson Mount Poi bet. cave       1929-09-18T00:00 K003309476 Clemens, M.S.; Clemens, J. Clemens 6936 False 76 76 Clemens 6936 Clemens 1929-09-18T00:00
333899 333899 5130177636 Annonaceae Alphonsea kinabaluensis J.Sinclair Mt. Poi.       1929-09-18T00:00 K003305412 Clemens, J.; Clemens, M.S. Clemens 6941 False 76 76 Clemens 6941 Clemens 1929-09-18T00: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]);