occ

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

6 rows where cluster_num_id = 78 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, 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
273482 273482 912705718 Oleaceae Olea rubrovenia (Elmer) Kiew Upper Kinabalu, B.N.Borneo     2971.8050000000003 1931-01-01T00:00 K000979224 Clemens, J.; Clemens, M.S. Clemens 28986 False 78 78 Clemens 28986 Clemens 1931-01-01T00:00
602968 602968 3059539645 Oleaceae Olea rubrovenia (Elmer) Kiew Sabah Upper Kinabalu, B.N.Borneo, 6000-13500 feet       1931 B 10 1150019 Clemens,J. & Clemens,M.S. Clemens 28986 False 78 78 Clemens 28986 Clemens 1931
430829 430829 912705702 Oleaceae Olea rubrovenia (Elmer) Kiew Upper Kinabalu, B.N.Borneo     2971.8050000000003 1931-01-01T00:00 K000979223 Clemens, J.; Clemens, M.S. Clemens 28996 False 78 78 Clemens 28996 Clemens 1931-01-01T00:00
389806 389806 5956023341 Fagaceae Lithocarpus ruminatus Soepadmo Mount Kinabalu; Upper Kinabalu       1931-01-01T00:00 K001517185 Clemens, J.; Clemens, M.S. Clemens 28997 False 78 78 Clemens 28997 Clemens 1931-01-01T00:00
370367 370367 912256546 Cyperaceae Uncinia compacta R.Br. Sabah, Mount Kinabalu, Upper Kinabalu     1828.8 1931-01-01T00:00 K000291181 Clemens, J.; Clemens, M.S. Clemens 29004 False 78 78 Clemens 29004 Clemens 1931-01-01T00:00
384312 384312 4958538632 Sapotaceae Palaquium rioense H.J.Lam Mount Kinabalu; Tenompok       1931-01-01T00:00 K005688657 Clemens, J.; Clemens, M.S. Clemens 29022 False 78 78 Clemens 29022 Clemens 1931-01-01T00: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]);