occ

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

8 rows where cluster_num_id = 67 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, decimalLatitude, decimalLongitude, 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
292360 292360 6115640373 Fagaceae Castanopsis costata (Blume) A.DC. Kiau; Mount Kinabalu       1915-12-01T00:00 K001318111 Clemens, M.S. Clemens 10267 False 67 67 Clemens 10267 Clemens 1915-12-01T00:00
473112 473112 912159217 Lamiaceae Vitex quinata (Lour.) F.N.Williams Mt. Kinabalu. Kiau 6.05 116.5   1915-12-01T00:00 K000116135 Clemens, M.S. Clemens 10274 True 67 67 Clemens 10274 Clemens 1915-12-01T00:00
255660 255660 4873092167 Sapindaceae Dimocarpus fumatus subsp. fumatus Mount Kinabalu Trip; Kiau; Mount Kinabalu       1915-12-01T00:00 K004311379 Clemens, M.S. Clemens 10280 False 67 67 Clemens 10280 Clemens 1915-12-01T00:00
589882 589882 1318367989 Poaceae Dendrocalamus Nees Kiau, mount kinabalu       1915-12-01 US 1061846 M. S. Clemens Clemens 10283 False 67 67 Clemens 10283 Clemens 1915-12-01
350307 350307 5130207105 Araliaceae Aralia montana Blume Kiau Mount Kinabalu.       1915-12-01T00:00 K005511601 Clemens, M.S. Clemens 10284 False 67 67 Clemens 10284 Clemens 1915-12-01T00:00
417425 417425 4608008260 Poaceae Schizostachyum brachycladum (Kurz ex Munro) Kurz British North Borneo; Kiau Mount Kinabalu       1915-12-01T00:00 K003901880 Clemens, M.S. Clemens 10285 False 67 67 Clemens 10285 Clemens 1915-12-01T00:00
577000 577000 1319059437 Poaceae Schizostachyum brachycladum (Kurz ex Munro) Kurz Kiau, mt. kinabalu       1915-12-01 US 1290922 M. S. Clemens Clemens 10285 False 67 67 Clemens 10285 Clemens 1915-12-01
592171 592171 1318457882 Poaceae Schizostachyum brachycladum (Kurz ex Munro) Kurz Kiau, mt. kinabalu       1915-12-01 US 1061845 M. S. Clemens Clemens 10285 False 67 67 Clemens 10285 Clemens 1915-12-01

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