occ

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

8 rows where cluster_num_id = 92 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
470007 470007 5130196359 Urticaceae Elatostema kuchingense H.Schroet. Borneo; Mount Poi; [Bas camp]       1929-10-04T00:00 K003449379 Clemens, J.; Clemens, M.S. Clemens 20803 False 92 92 Clemens 20803 Clemens 1929-10-04T00:00
496801 496801 1949810620 Urticaceae Elatostema kuchingense H.Schroet. Mount Poi, Base Camp.       1929-10-04 3836872 J. Clemens Clemens 20803 False 92 92 Clemens 20803 Clemens 1929-10-04
488990 488990 3991084720 Urticaceae Elatostema variolaminosum var. latum H.Schroet. Sarawak, Bidli Cave hut[?] Low elev.       1929-10-21 4388066 J. Clemens Clemens 20808 False 92 92 Clemens 20808 Clemens 1929-10-21
397158 397158 5130195333 Urticaceae Elatostema penninerve H.Schroet. Borno; Bidi Cave       1929-10-18T00:00 K003449358 Clemens, J.; Clemens, M.S. Clemens 20812 False 92 92 Clemens 20812 Clemens 1929-10-18T00:00
489041 489041 1949854562 Urticaceae Elatostema penninerve H.Schroet. Bidi Caves, Low elevation.       1929-10-18 03836947 J. Clemens Clemens 20812 False 92 92 Clemens 20812 Clemens 1929-10-18
291464 291464 912551096 Elaeocarpaceae Elaeocarpus cupreus Merr. Mount Matang Below [illegible]     3596.65 1929-10-24T00:00 K000708113 Clemens, J.; Clemens M.S. Clemens 20820 False 92 92 Clemens 20820 Clemens 1929-10-24T00:00
450492 450492 4535525039 Cyperaceae Fimbristylis pauciflora R.Br. Borneo; Kuching and vicinity; [Kuching to Matang]       1929-10-24T00:00 K002291004 Clemens, J.; Clemens, M.S. Clemens 20823 False 92 92 Clemens 20823 Clemens 1929-10-24T00:00
492115 492115 2447328833 Apocynaceae Telosma Coville Kuching and vicinity. Rest House Grounds.       1929-10-23 04173249 J. Clemens Clemens 20831 False 92 92 Clemens 20831 Clemens 1929-10-23

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