occ

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

12 rows where cluster_num_id = 24 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
244273 244273 3947900469 Thelypteridaceae Pseudophegopteris paludosa (Blume) Ching Penataran basin       1933-07 1626779 J. Clemens Clemens 34133 False 24 24 Clemens 34133 Clemens 1933-07
650320 650320 4074161327 Thelypteridaceae Pseudophegopteris aurita (Hook.) Ching Upper Kinabalu       1933-07 barcode-02403348 J. Clemens & M. S. Clemens Clemens 34133 False 24 24 Clemens 34133 Clemens 1933-07
242372 242372 3409057404 Aspleniaceae Asplenium pachychlamys C.Chr. Columbon river       1933-06-15 1608207 J. Clemens Clemens 34134 False 24 24 Clemens 34134 Clemens 1933-06-15
286025 286025 912361431 Aspleniaceae Asplenium sumatranum Hook. Columbon R. [Kilembun R.] 6.1 116.5 1375.0 1933-06-15T00:00 K000429566 Clemens, J.; Clemens, M.S. Clemens 34134 True 24 24 Clemens 34134 Clemens 1933-06-15T00:00
494868 494868 2251698815 Aspleniaceae Asplenium pachychlamys C.Chr. Br.N. Borneo. Mount Kinabalu. Columbon river.       1933-06-15 4053244 J. Clemens Clemens 34134 False 24 24 Clemens 34134 Clemens 1933-06-15
648997 648997 4053617450 Aspleniaceae Asplenium sumatranum Hook. Columbon river       1933-06-15 barcode-02407629 J. Clemens & M. S. Clemens Clemens 34134 False 24 24 Clemens 34134 Clemens 1933-06-15
407512 407512 912306881 Lindsaeaceae Odontosoria chinensis subsp. chinensis Penataran basin 6.083333 116.5 2135.0 1933-07-01T00:00 K000361158 Clemens, J.; Clemens, M.S. Clemens 34140 True 24 24 Clemens 34140 Clemens 1933-07-01T00:00
491277 491277 2239554495 Lindsaeaceae Odontosoria chinensis (L.) J.Sm. Br.N. Borneo, Mt. Kinabalu. Penataran basin.       1933-07 4023939 J. Clemens Clemens 34140 False 24 24 Clemens 34140 Clemens 1933-07
522290 522290 4443251851 Lindsaeaceae Sphenomeris chinensis (L.) Maxon Mount Kinabalu. B.N. Borneo. Penataran basin. 6.059958 116.544614 2134.0 1933-07 UT0006536 J. & M.S. Clemens Clemens 34140 True 24 24 Clemens 34140 Clemens 1933-07
579707 579707 1319387111 Lindsaeaceae Sphenomeris chinensis var. chinensis Mount Kinabalu, B.N. Borneo, Penataran basin     2134.0 1933-07 US 1715118 J. Clemens & M. S. Clemens Clemens 34140 False 24 24 Clemens 34140 Clemens 1933-07
626921 626921 4014189375 Lindsaeaceae Odontosoria chinensis (L.) J.Sm. Penataran basin       1933-07 barcode-02286820 J. Clemens & M. S. Clemens Clemens 34140 False 24 24 Clemens 34140 Clemens 1933-07
644702 644702 4014183455 Lindsaeaceae Odontosoria chinensis (L.) J.Sm. Penataran basin       1933-07 barcode-02286816 J. Clemens & M. S. Clemens Clemens 34140 False 24 24 Clemens 34140 Clemens 1933-07

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