occ

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

19 rows where cluster_num_id = 95 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
413076 413076 5130236546 Primulaceae Ardisia copelandii Mez Mount Kinabalu; Tenompok       1932-01-08T00:00 K006164859 Clemens, J.; Clemens, M.S. Clemens 28259 False 95 95 Clemens 28259 Clemens 1932-01-08T00:00
344397 344397 912429072 Dennstaedtiaceae Histiopteris stipulacea (Hook.) Copel. Mt. Kinabalu 6.05 116.55   1932-01-01T00:00 K000519644 Clemens, J.; Clemens, M.S. Clemens 28268 True 95 95 Clemens 28268 Clemens 1932-01-01T00:00
380545 380545 5276386549 Fabaceae Mucuna toppingii Merr. Mount Kinabalu; Tenompok       1932-01-04T00:00 K001860225 Clemens, J.; Clemens, M.S. Clemens 28270 False 95 95 Clemens 28270 Clemens 1932-01-04T00:00
341970 341970 4849329246 Poaceae Panicum notatum Retz. Malay Island; Island or Province Mt. Kinabalu, B. N. Borneo; Dallas       1932-01-03T00:00 K003369011 Clemens, J.; Clemens, M.S. Clemens 28271 False 95 95 Clemens 28271 Clemens 1932-01-03T00:00
342049 342049 4849327220 Poaceae Panicum notatum Retz. Dallas, Mt. Kinabalu, B. N. Borneo       1932-01-03T00:00 K003369010 Clemens, J.; Clemens, M.S. Clemens 28271 False 95 95 Clemens 28271 Clemens 1932-01-03T00:00
297594 297594 4849331826 Poaceae Ichnanthus pallens var. major (Nees) Stieber Malay Island; Mt. Kinabalu; Dallas       1932-01-03T00:00 K003365538 Clemens, J.; Clemens, M.S. Clemens 28272 False 95 95 Clemens 28272 Clemens 1932-01-03T00:00
353207 353207 4849432025 Poaceae Ichnanthus pallens var. major (Nees) Stieber Dallas, Mt. Kinabalu.       1932-01-03T00:00 K003365532 Clemens, J.; Clemens, M.S. Clemens 28272 False 95 95 Clemens 28272 Clemens 1932-01-03T00:00
490081 490081 3898413584 Poaceae Ichnanthus pallens (Sw.) Munro ex Benth. Mount Kinabalu, B.N. Borneo, Dallas       1932-01-03 4312538 J. Clemens Clemens 28272 False 95 95 Clemens 28272 Clemens 1932-01-03
618020 618020 4900309337 Poaceae Ichnanthus pallens var. major (Nees) Stieber Dallas.       1932-01-03 barcode-02471405 J. Clemens & M. S. Clemens Clemens 28272 False 95 95 Clemens 28272 Clemens 1932-01-03
489209 489209 3455086435 Poaceae Sacciolepis indica (L.) Chase Mount Kinabalu, Dallas       1932-01-03 4292317 J. Clemens Clemens 28273 False 95 95 Clemens 28273 Clemens 1932-01-03
658920 658920 4903526809 Poaceae Sacciolepis indica (L.) Chase Dallas.       1932-01-03 barcode-02472366 J. Clemens & M. S. Clemens Clemens 28273 False 95 95 Clemens 28273 Clemens 1932-01-03
367309 367309 4849329252 Poaceae Panicum humidorum Buch.-Ham. ex Hook.f. Mt. Kinabalu; Dallas       1932-01-01T00:00 K003369080 Clemens, J.; Clemens, M.S. Clemens 28275 False 95 95 Clemens 28275 Clemens 1932-01-01T00:00
369982 369982 4849333913 Poaceae Panicum humidorum Buch.-Ham. ex Hook.f. Malay Islands; Mt. Kinabalu; Dallas       1932-01-03T00:00 K003369081 Clemens, J.; Clemens, M.S. Clemens 28275 False 95 95 Clemens 28275 Clemens 1932-01-03T00:00
491296 491296 3498245342 Poaceae Panicum humidorum Buch.-Ham. ex Hook.f. Mount Kinabalu, B.N. Borneo, Dallas       1932-01 4307682 J. Clemens Clemens 28275 False 95 95 Clemens 28275 Clemens 1932-01
491983 491983 3498252458 Poaceae Panicum humidorum Buch.-Ham. ex Hook.f. Mount Kinabalu, B.N. Borneo, Dallas       1932-01-03 4307683 J. Clemens Clemens 28275 False 95 95 Clemens 28275 Clemens 1932-01-03
646944 646944 4900310867 Poaceae Panicum humidorum Buch.-Ham. ex Hook.f. Dallas.       1932-01-03 barcode-02471929 J. Clemens & M. S. Clemens Clemens 28275 False 95 95 Clemens 28275 Clemens 1932-01-03
647984 647984 4900309914 Poaceae Panicum humidorum Buch.-Ham. ex Hook.f. Dallas.       1932-01 barcode-02471930 J. Clemens & M. S. Clemens Clemens 28275 False 95 95 Clemens 28275 Clemens 1932-01
464957 464957 5130171961 Annonaceae Meiogyne virgata (Blume) Miq. Mount Kinabalu; Dallas       1932-01-03T00:00 K003311931 Clemens, J.; Clemens, M.S. Clemens 28279 False 95 95 Clemens 28279 Clemens 1932-01-03T00:00
666805 666805 5135203539 Annonaceae Meiogyne virgata (Blume) Miq. Dallas       1932-01-03 barcode-02614843 J. Clemens & M. S. Clemens Clemens 28279 False 95 95 Clemens 28279 Clemens 1932-01-03

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