occ

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

10 rows where cluster_num_id = 13 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scientificName, locality, decimalLatitude, decimalLongitude, elevation, eventDate, catalogNumber, 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
375521 375521 912396020 Polypodiaceae Dasygrammitis Parris Mt Kinabalu, Marai Parai 6.083333 116.516667 3048.0 1933-01-01T00:00 K000473838 Clemens Clemens 33205 True 13 13 Clemens 33205 Clemens 1933-01-01T00:00
442894 442894 912396031 Polypodiaceae Dasygrammitis Parris Mt Kinabalu, Marai Parai 6.083333 116.516667 3048.0 1933-01-01T00:00 K000473837 Clemens Clemens 33205 True 13 13 Clemens 33205 Clemens 1933-01-01T00:00
458317 458317 5956163496 Polypodiaceae Dasygrammitis Parris N Borneo, Mt Kinabalu, Marai Parai     3048.0 1933-01-01 105867 Clemens, Rev. J. Clemens 33205 False 13 13 Clemens 33205 Clemens 1933-01-01
572621 572621 4075121783 Polypodiaceae Polypodium brevivenosum Alderw. Mount Kinabalu 6.072693 116.561508   1933 BM014156887 J. Clemens & M.S. Clemens Clemens 33205 True 13 13 Clemens 33205 Clemens 1933
620508 620508 4406247405 Polypodiaceae Dasygrammitis brevivenosa (Alderw.) Parris Marai Parai       1933 barcode-02220802 M. S. Clemens Clemens 33205 False 13 13 Clemens 33205 Clemens 1933
226475 226475 1090350901 Polypodiaceae Prosaptia davalliacea (F.Muell. & Baker) Copel. Br. N. Borneo, Mt Kinabalu, Marai Parai       1933 105869 Clemens Clemens 33206 False 13 13 Clemens 33206 Clemens 1933
302821 302821 912482453 Polypodiaceae Prosaptia davalliacea (F.Muell. & Baker) Copel. Mt. Kinabalu, Marai Parai 6.083333 116.516667 2896.0 1933-01-01T00:00 K000597902 Clemens Clemens 33206 True 13 13 Clemens 33206 Clemens 1933-01-01T00:00
458859 458859 5956182064 Polypodiaceae Prosaptia davalliacea (F.Muell. & Baker) Copel. Br. N. Borneo, Mt Kinabalu, Marai Parai     2896.0 1933-01-01 105869 Clemens Clemens 33206 False 13 13 Clemens 33206 Clemens 1933-01-01
495829 495829 2235397493 Polypodiaceae Prosaptia davalliacea (F.Muell. & Baker) Copel. B.N. Borneo. Mt. Kinabalu. Marai Parai.       1933 03985968 J. Clemens Clemens 33206 False 13 13 Clemens 33206 Clemens 1933
651635 651635 4406248367 Polypodiaceae Prosaptia linearis Copel. Marai Parai       1933 barcode-02221113 M. S. Clemens Clemens 33206 False 13 13 Clemens 33206 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]);