occ

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

5 rows where cluster_num_id = 83 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scientificName, 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
279571 279571 5106476316 Polypodiaceae Calymmodon C.Presl B. N. Borneo. Upper Kinabalu     2743.21 1931-01-01T00:00 K001666970 Clemens, J.; Clemens, M.S. Clemens 30461 False 83 83 Clemens 30461 Clemens 1931-01-01T00:00
328685 328685 5106476422 Polypodiaceae Calymmodon C.Presl B. N. Borneo. Upper Kinabalu     2743.21 1931-01-01T00:00 K001933315 Clemens, J.; Clemens, M.S. Clemens 30461 False 83 83 Clemens 30461 Clemens 1931-01-01T00:00
331213 331213 5106477428 Polypodiaceae Calymmodon C.Presl B. N. Borneo. Upper Kinabalu     2743.21 1931-01-01T00:00 K001933316 Clemens, J.; Clemens, M.S. Clemens 30461 False 83 83 Clemens 30461 Clemens 1931-01-01T00:00
410975 410975 5106476423 Polypodiaceae Calymmodon C.Presl B. N. Borneo. Upper Kinabalu     2743.21 1931-01-01T00:00 K001933317 Clemens, J.; Clemens, M.S. Clemens 30461 False 83 83 Clemens 30461 Clemens 1931-01-01T00:00
412692 412692 5106476315 Polypodiaceae Calymmodon gracilis (Fée) Copel. B. N. Borneo. Upper Kinabalu     2743.21 1931-01-01T00:00 K001666969 Clemens, J.; Clemens, M.S. Clemens 30461 False 83 83 Clemens 30461 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]);