occ

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

21 rows where cluster_num_id = 42 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, decimalLatitude, decimalLongitude, elevation, 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
385392 385392 912409906 Davalliaceae Davallodes hirsutum (J.Sm.) Copel. Upper Kinabalu, Fenibukan ridge N. of camp. 6.066667 116.516667 1371.5 1933-02-04T00:00 K000491129 Clemens, J.; Clemens, M.S. Clemens 51699 True 42 42 Clemens 51699 Clemens 1933-02-04T00:00
609898 609898 4404051342 Davalliaceae Davallodes hirsutum (J.Sm.) Copel. Penibukan ridge N. of camp       1933-02-04 barcode-02508827 J. Clemens & M. S. Clemens Clemens 51699 False 42 42 Clemens 51699 Clemens 1933-02-04
448346 448346 912511643 Polypodiaceae Polypodium persicifolium Desv. Mount Kinabalu. Penibukan 6.066667 116.516667 1371.5 1933-02-15T00:00 K000645008 Clemens, J.; Clemens, M.S. Clemens 51701 True 42 42 Clemens 51701 Clemens 1933-02-15T00:00
449294 449294 912511623 Polypodiaceae Polypodium persicifolium Desv. Upper Kinabalu       1933-02-15T00:00 K000645009 Clemens, J.; Clemens, M.S. Clemens 51701 False 42 42 Clemens 51701 Clemens 1933-02-15T00:00
496878 496878 2012791021 Polypodiaceae Goniophlebium persicifolium (Desv.) Bedd. Br. N. Borneo. Mt. Kinabalu. Penubikan       1933-02-15 3981533 J. Clemens Clemens 51701 False 42 42 Clemens 51701 Clemens 1933-02-15
316660 316660 912396264 Polypodiaceae Ctenopteris barathrophylla (Baker) Parris Mt Kinabalu, Penibukan 6.233333 116.516667 1524.0 1933-02-15T00:00 K000474087 Clemens, J.; Clemens, M.S. Clemens 51702 True 42 42 Clemens 51702 Clemens 1933-02-15T00:00
570007 570007 4075121518 Polypodiaceae Polypodium khasyanum Hook. Mount Kinabalu 6.072693 116.561508   1933-02-15 BM014156920 J. Clemens & M.S. Clemens Clemens 51702 True 42 42 Clemens 51702 Clemens 1933-02-15
607031 607031 4406260354 Polypodiaceae Prosaptia barathrophylla (Baker) M.G.Price Penibukan jungle       1933-02-15 barcode-02221090 J. Clemens & M. S. Clemens Clemens 51702 False 42 42 Clemens 51702 Clemens 1933-02-15
660326 660326 4053617312 Aspleniaceae Asplenium belangeri (Bory) Kunze Penibukan, steep side of spur. Upper Kinabalu       1933-01 barcode-02407305 J. Clemens & M. S. Clemens Clemens 51703 False 42 42 Clemens 51703 Clemens 1933-01
244509 244509 4058697152 Davalliaceae Davallia pubescens C.W.Chen Penibukan, Upper Kinabalu       1933-01-24 1629613 J. Clemens Clemens 51704 False 42 42 Clemens 51704 Clemens 1933-01-24
280355 280355 912409895 Davalliaceae Davallodes hirsutum (J.Sm.) Copel. Upper Kinabalu, Penibukan 6.066667 116.516667 1219.0 1933-01-24T00:00 K000491132 Clemens, J.; Clemens, M.S. Clemens 51704 True 42 42 Clemens 51704 Clemens 1933-01-24T00:00
497574 497574 2423975255 Davalliaceae Davallodes burbidgei C.Chr. B.N. Borneo. Mt. Kinabalu. Penibukan.       1933-01-24 04163073 J. Clemens Clemens 51704 False 42 42 Clemens 51704 Clemens 1933-01-24
647693 647693 4404058345 Davalliaceae Davallodes hirsutum (J.Sm.) Copel. Penibukan       1933-01-24 barcode-02508831 J. Clemens & M. S. Clemens Clemens 51704 False 42 42 Clemens 51704 Clemens 1933-01-24
244864 244864 4528455544 Polypodiaceae Prosaptia contigua (G.Forst.) C.Presl Penibunak       1933-01-17 1637257 J. Clemens Clemens 51707 False 42 42 Clemens 51707 Clemens 1933-01-17
484556 484556 912373589 Polypodiaceae Calymmodon gracilis (Fée) Copel. Mt Kinabalu, Penibukan 6.066667 116.516667 1219.0 1933-01-16T00:00 K000445435 Clemens, J.; Clemens, M.S. Clemens 51709 True 42 42 Clemens 51709 Clemens 1933-01-16T00:00
495111 495111 2235416848 Polypodiaceae Calymmodon gracilis (Fée) Copel. B.N. Borneo, Mt. Kinabalu. Penibukan.       1933-01-16 3983251 J. Clemens Clemens 51709 False 42 42 Clemens 51709 Clemens 1933-01-16
497415 497415 2235405188 Polypodiaceae Calymmodon gracilis (Fée) Copel. B.N. Borneo. Mt. Kinabalu. Penibukan.       1933-01-16 3983248 J. Clemens Clemens 51709 False 42 42 Clemens 51709 Clemens 1933-01-16
614349 614349 4406250396 Polypodiaceae Calymmodon C.Presl Penibukan       1933-01-16 barcode-02220682 J. Clemens & M. S. Clemens Clemens 51709 False 42 42 Clemens 51709 Clemens 1933-01-16
440445 440445 912374518 Pteridaceae Pteris amoena Blume Mt. Kinabalu, Penibukan 6.066667 116.516667 1219.0 1933-01-01T00:00 K000446395 Clemens, J.; Clemens, M.S. Clemens 51710 True 42 42 Clemens 51710 Clemens 1933-01-01T00:00
495693 495693 2012821125 Pteridaceae Pteris purpureorachis Copel. Mount Kinabalu, B. N. Borneo, Penibukan, Upper Kinabalu       1933-01 03943263 J. Clemens Clemens 51710 False 42 42 Clemens 51710 Clemens 1933-01
673929 673929 4033789390 Pteridaceae Pteris purpureorachis Copel. Penibukan, Upper Kinabalu       1933-01 barcode-02529940 J. Clemens & M. S. Clemens Clemens 51710 False 42 42 Clemens 51710 Clemens 1933-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]);