occ

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

14 rows where cluster_num_id = 75 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
622562 622562 3922525428 Hymenophyllaceae Hymenophyllum australe Willd. Marai Parai       1933 barcode-02581427 M. S. Clemens Clemens 32383 False 75 75 Clemens 32383 Clemens 1933
627843 627843 3915845464 Hymenophyllaceae Callistopteris apiifolia (C.Presl) Copel. Marai Parai       1933 barcode-02580682 M. S. Clemens Clemens 32385 False 75 75 Clemens 32385 Clemens 1933
480691 480691 912340737 Hymenophyllaceae Hymenophyllum holochilum (Bosch) C.Chr. Mt Kinabalu, Marai Parai. 6.083333 116.516667 1220.0 1933-01-01T00:00 K000408358 Clemens Clemens 32395 True 75 75 Clemens 32395 Clemens 1933-01-01T00:00
618649 618649 3922524420 Hymenophyllaceae Hymenophyllum serrulatum (C.Presl) C.Chr. Marai Parai       1933 barcode-02581721 M. S. Clemens Clemens 32395 False 75 75 Clemens 32395 Clemens 1933
376232 376232 912332751 Thelypteridaceae Sphaerostephanos J.Sm. Mt Kinabalu. W. Marai Parai 6.083333 116.516667 1200.0 1933-01-01T00:00 K000397708 Clemens Clemens 32398 True 75 75 Clemens 32398 Clemens 1933-01-01T00:00
486327 486327 5956563783 Thelypteridaceae Sphaerostephanos penniger (Hook.) Holttum North Borneo, Mt. Kinabalu, W. Marai Parai.     1219.0 1933-01-01 103629 Clemens Clemens 32398 False 75 75 Clemens 32398 Clemens 1933-01-01
665084 665084 4074161380 Thelypteridaceae Sphaerostephanos arbusculus (Willd.) Holttum W. Marai Parai       1933 barcode-02403376 M. S. Clemens Clemens 32398 False 75 75 Clemens 32398 Clemens 1933
486077 486077 5956597718 Thelypteridaceae Sphaerostephanos caulescens Holttum North Borneo, Mt. Kinabalu; Columbon River Basin.     1372.0 1933-01-01 103620 Clemens Clemens 32404 False 75 75 Clemens 32404 Clemens 1933-01-01
387049 387049 912446702 Polypodiaceae Grammitis dolichosora (Copel.) Copel. Mt Kinabalu, Marai Parai 6.083333 116.516667 1524.0 1933-01-01T00:00 K000538360 Clemens, J.; Clemens, M.S. Clemens 32407 True 75 75 Clemens 32407 Clemens 1933-01-01T00:00
458875 458875 5956347216 Polypodiaceae Oreogrammitis dolichosora (Copel.) Parris Br. N. Borneo, Mt. Kinabalu, Mari Parai     1524.0 1933-01-01 105870 Clemens Clemens 32407 False 75 75 Clemens 32407 Clemens 1933-01-01
568673 568673 1055421383 Polypodiaceae Grammitis dolichosora (Copel.) Copel. Marai Parai; 5000' 6.0597 116.5269 1524.0 1933 BM000823011 Clemens Clemens 32407 True 75 75 Clemens 32407 Clemens 1933
627546 627546 4406255328 Polypodiaceae Oreogrammitis dolichosora (Copel.) Parris Marai Parai       1933 barcode-02220864 M. S. Clemens Clemens 32407 False 75 75 Clemens 32407 Clemens 1933
264828 264828 912446700 Polypodiaceae Grammitis dolichosora (Copel.) Copel. Mt Kinabalu, Marai Parai 6.083333 116.516667 1524.0 1933-01-01T00:00 K000538362 Clemens, J.; Clemens, M.S. Clemens 32416 True 75 75 Clemens 32416 Clemens 1933-01-01T00:00
638101 638101 4406253305 Polypodiaceae Oreogrammitis dolichosora (Copel.) Parris Marai Parai       1933 barcode-02220865 M. S. Clemens Clemens 32416 False 75 75 Clemens 32416 Clemens 1933

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