occ

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

24 rows where cluster_num_id = 26 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
242714 242714 3947896583 Thelypteridaceae Sphaerostephanos baramensis (C.Chr.) Holttum Tenompok       1932 1623792 J. Clemens Clemens 30456 False 26 26 Clemens 30456 Clemens 1932
428384 428384 912160456 Thelypteridaceae Sphaerostephanos baramensis (C.Chr.) Holttum Tenompok 6.0 116.533333 1500.0 1932-01-01T00:00 K000117375 Clemens, J.; Clemens, M.S. Clemens 30456 True 26 26 Clemens 30456 Clemens 1932-01-01T00:00
575315 575315 1318307731 Thelypteridaceae Sphaerostephanos baramensis (C.Chr.) Holttum Malay Islands, Mount Kinabalu, B. N. Borneo, Upper Kinabalu, Br N Borneo, Tenompok     1524.0 1932 US 1673475 J. Clemens & M. S. Clemens Clemens 30456 False 26 26 Clemens 30456 Clemens 1932
250582 250582 912456509 Lomariopsidaceae Lomariopsis spectabilis (Kunze) Mett. Dallas 6.0 116.466667 914.0 1931-12-31T00:00 K000559395 Clemens, J.; Clemens, M.S. Clemens 30457 True 26 26 Clemens 30457 Clemens 1931-12-31T00:00
250678 250678 912456536 Lomariopsidaceae Lomariopsis spectabilis (Kunze) Mett. Dallas 6.0 116.466667 914.0 1931-12-31T00:00 K000559396 Clemens, J.; Clemens, M.S. Clemens 30457 True 26 26 Clemens 30457 Clemens 1931-12-31T00:00
495013 495013 2424018711 Lomariopsidaceae Lomariopsis spectabilis (Kunze) Mett. B.N. Borneo, Mount Kinabalu. Dallas 6.0333 116.4667   1931-12-31 04162217 J. Clemens Clemens 30457 True 26 26 Clemens 30457 Clemens 1931-12-31
552832 552832 4173202376 Dryopteridaceae Lomariopsis leptocarpa Fée Dallas       1931-12-31 barcode-02506303 J. Clemens & M. S. Clemens Clemens 30457 False 26 26 Clemens 30457 Clemens 1931-12-31
649341 649341 4173196406 Dryopteridaceae Lomariopsis leptocarpa Fée Dallas       1931-12-31 barcode-02506304 J. Clemens & M. S. Clemens Clemens 30457 False 26 26 Clemens 30457 Clemens 1931-12-31
571243 571243 6132196862 Thelypteridaceae Pronephrium menisciicarpon (Blume) Holttum Mount Kinabalu 6.072693 116.561508   1931-12-22 BM015185234 J. Clemens & M.S. Clemens Clemens 30458 True 26 26 Clemens 30458 Clemens 1931-12-22
576874 576874 1318551843 Thelypteridaceae Cyclosorus menisciicarpus (Blume) Holttum Mount Kinabalu, B. N. Borneo, Dallas     914.0 1931-12-22 US 1673478 J. Clemens & M. S. Clemens Clemens 30458 False 26 26 Clemens 30458 Clemens 1931-12-22
489461 489461 1981513791 Marattiaceae Ptisana pellucida (C.Presl) Murdock B.N. Borneo. Mount Kinabalu. Tenompok. 6.00353 116.52906   1931-12-05 3881654 J. Clemens Clemens 30459 True 26 26 Clemens 30459 Clemens 1931-12-05
571769 571769 6161885357 Marattiaceae Ptisana sylvatica (Blume) Murdock   5.377939 117.087456   1931-12-05 BM000786206 Joseph Clemens;Mary Strong Clemens Clemens 30459 True 26 26 Clemens 30459 Clemens 1931-12-05
572771 572771 6161886082 Marattiaceae Ptisana sylvatica (Blume) Murdock   5.377939 117.087456   1931-12-05 BM000786205 Joseph Clemens;Mary Strong Clemens Clemens 30459 True 26 26 Clemens 30459 Clemens 1931-12-05
595730 595730 1321347372 Marattiaceae Ptisana sylvatica (Blume) Murdock B.N.Borneo, Tenompok     1524.0 1931-12-05 US 1673479 J. Clemens & M. S. Clemens Clemens 30459 False 26 26 Clemens 30459 Clemens 1931-12-05
493509 493509 2235400313 Polypodiaceae Calymmodon gracilis (Fée) Copel. B.N. Borneo, Mount Kinabalu. Above 9,000'       1932-01-09 3983249 J. Clemens Clemens 30461 False 26 26 Clemens 30461 Clemens 1932-01-09
582654 582654 1319384726 Polypodiaceae Calymmodon gracilis (Fée) Copel. Mount Kinabalu, B.N. Borneo, Upper Kinabalu, Granite summit. Malay islands     2743.0 1932-01-09 US 1673480 J. Clemens & M. S. Clemens Clemens 30461 False 26 26 Clemens 30461 Clemens 1932-01-09
610997 610997 4406255349 Polypodiaceae Calymmodon C.Presl Granite summit       1932-01-09 barcode-02220680 J. Clemens & M. S. Clemens Clemens 30461 False 26 26 Clemens 30461 Clemens 1932-01-09
659747 659747 4406253316 Polypodiaceae Calymmodon C.Presl Granite summit       1932-01-09 barcode-02220678 J. Clemens & M. S. Clemens Clemens 30461 False 26 26 Clemens 30461 Clemens 1932-01-09
367958 367958 912451365 Polypodiaceae Grammitis fasciata Blume Mt Kinabalu, below Paka 6.05 116.55 2667.5 1932-01-07T00:00 K000547816 Clemens, J.; Clemens, M.S. Clemens 30462 True 26 26 Clemens 30462 Clemens 1932-01-07T00:00
495797 495797 2235398256 Polypodiaceae Oreogrammitis fasciata (Blume) Parris Mt. Kinabalu, B. N. Borneo, Upper Kinabalu, Below Paka       1932-01-07 3986045 J. Clemens Clemens 30462 False 26 26 Clemens 30462 Clemens 1932-01-07
581640 581640 1319315779 Polypodiaceae Oreogrammitis fasciata (Blume) Parris Mount Kinabalu, B.N.Borneo, Upper Kinabalu, The Malay Islands, Net Kambotanga + Paka     2667.0 1932-01-07 US 1673481 J. Clemens & M. S. Clemens Clemens 30462 False 26 26 Clemens 30462 Clemens 1932-01-07
647948 647948 4406258393 Polypodiaceae Oreogrammitis fasciata (Blume) Parris Below Paka       1932-01-07 barcode-02220913 J. Clemens & M. S. Clemens Clemens 30462 False 26 26 Clemens 30462 Clemens 1932-01-07
670435 670435 4406256336 Polypodiaceae Oreogrammitis fasciata (Blume) Parris Below Paka       1932-01-07 barcode-02220909 J. Clemens & M. S. Clemens Clemens 30462 False 26 26 Clemens 30462 Clemens 1932-01-07
247729 247729 3947895598 Thelypteridaceae Pneumatopteris microauriculata Holttum Tenompok? Dallas       1932 1626611 J. Clemens Clemens 30463 False 26 26 Clemens 30463 Clemens 1932

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