home / geonomia

occ

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

44 rows where cluster_num_id = 64 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, locality, elevation, eventDate, recordedBy, recordNumber_mainNumber, 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
476770 476770 5068157679 Symplocaceae Symplocos laeteviridis var. laeteviridis Mount Kinabalu; Dallas       1931-12-05T00:00 K006280642 Clemens, J.; Clemens, M.S. Clemens 30223 False 64 64 Clemens 30223 Clemens 1931-12-05T00:00
654322 654322 4954813667 Symplocaceae Symplocos laeteviridis Stapf Dallas       1931-12-05 barcode-02601279 J. Clemens & M. S. Clemens Clemens 30223 False 64 64 Clemens 30223 Clemens 1931-12-05
657621 657621 6159760589 Acanthaceae Staurogyne axillaris S.Moore Mount Kinabalu; Dallas       1931-12 barcode-02634809 J. Clemens & M. S. Clemens Clemens 30236 False 64 64 Clemens 30236 Clemens 1931-12
477898 477898 5891322267 Myrtaceae Syzygium valdevenosum (Duthie) Merr. & L.M.Perry Mount Kinabalu; B. N. Borneo; Dallas       1931-11-25T00:00 K000304661 Clemens, J.; Clemens, M.S. Clemens 30248 False 64 64 Clemens 30248 Clemens 1931-11-25T00:00
657851 657851 4878452482 Myrtaceae Syzygium valdevenosum (Duthie) Merr. & L.M.Perry Dallas       1931-11-25 barcode-02425550 J. Clemens & M. S. Clemens Clemens 30248 False 64 64 Clemens 30248 Clemens 1931-11-25
358651 358651 5891324156 Myrtaceae Syzygium hirtum (Korth.) Merr. & L.M.Perry Mount Kinabalu;B.N. Borneo;Dallas       1931-12-17T00:00 K000258067 Clemens, J.; Clemens, M.S. Clemens 30249 False 64 64 Clemens 30249 Clemens 1931-12-17T00:00
616894 616894 4607700579 Myrtaceae Syzygium hirtum (Korth.) Merr. & L.M.Perry Dallas       1931-12-17 barcode-02448626 J. Clemens & M. S. Clemens Clemens 30249 False 64 64 Clemens 30249 Clemens 1931-12-17
463945 463945 4938762723 Acanthaceae Strobilanthes annamitica Kuntze Mount Kinabalu; B.N. Borneo; Tenompok       1932-01-01T00:00 K005282143 Clemens, J.; Clemens, M.S. Clemens 30253 False 64 64 Clemens 30253 Clemens 1932-01-01T00:00
330044 330044 4608012149 Poaceae Thysanolaena latifolia (Roxb. ex Hornem.) Honda Dallas; Mount Kinabalu; B. N. Borneo       1931-12-01T00:00 K003940039 Clemens, J.; Clemens, M.S. Clemens 30262 False 64 64 Clemens 30262 Clemens 1931-12-01T00:00
365919 365919 4608055201 Poaceae Thysanolaena latifolia (Roxb. ex Hornem.) Honda Dallas; Mt Kinabalu; B. n. Borneo       1931-12-01T00:00 K003940038 Clemens, J.; Clemens, M.S. Clemens 30262 False 64 64 Clemens 30262 Clemens 1931-12-01T00:00
492935 492935 4129427024 Pittosporaceae Pittosporum Gaertn. Mount Kinabalu B. N. Borneo Dallas       1931-11-30 4767359 J. Clemens Clemens 30264 False 64 64 Clemens 30264 Clemens 1931-11-30
641018 641018 5841340081 Pittosporaceae Pittosporum ferrugineum W.T.Aiton Mount Kinabalu; Dallas       1931-11-30 barcode-02667042 J. Clemens & M. S. Clemens Clemens 30264 False 64 64 Clemens 30264 Clemens 1931-11-30
296573 296573 4849371532 Poaceae Microstegium geniculatum (Hayata) Honda Mt. Kinabalu.; B. N. Borneo: Mt. Kinabalu.; Dallas-[Teuoupok]       1932-01-01T00:00 K003645868 Clemens, J.; Clemens, M.S. Clemens 30265 False 64 64 Clemens 30265 Clemens 1932-01-01T00:00
603554 603554 5843776533 Sapindaceae Lepisanthes tetraphylla (Vahl) Radlk. Dallas       1931-11-20 barcode-02685158 J. Clemens & M. S. Clemens Clemens 30266 False 64 64 Clemens 30266 Clemens 1931-11-20
345576 345576 912710155 Poaceae Isachne albomarginata Jansen Tenompok       1932-01-01T00:00 K001056200 Clemens, J.; Clemens, M.S. Clemens 30270 False 64 64 Clemens 30270 Clemens 1932-01-01T00:00
603231 603231 1839026324 Poaceae Isachne clarkei Hook.f. Plants of Mount Kinabalu, B. N. Borneo, Dallas, 3000 ft.     914.0 1931-12-31 B 10 0525290 Clemens,J. & Clemens,M.S. Clemens 30270 False 64 64 Clemens 30270 Clemens 1931-12-31
603233 603233 1839026452 Poaceae Isachne clarkei Hook.f. Plants of Mount Kinabalu, B. N. Borneo, Tenompok     1524.0 1932-01 B 10 0525291 Clemens,J. & Clemens,M.S. Clemens 30270 False 64 64 Clemens 30270 Clemens 1932-01
611896 611896 4900309524 Poaceae Ottochloa nodosa (Kunth) Dandy Dallas.       1932-01-03 barcode-02471872 J. Clemens & M. S. Clemens Clemens 30274 False 64 64 Clemens 30274 Clemens 1932-01-03
417602 417602 5060708837 Poaceae Lophatherum gracile Brongn. Malay Islands; Mt. Kinabalu, B.N. Borneo Dallas-Tenompok.       1931-12-15T00:00 K003095872 Clemens, J.; Clemens, M.S. Clemens 30275 False 64 64 Clemens 30275 Clemens 1931-12-15T00:00
491393 491393 3898413783 Poaceae Lophatherum gracile Brongn. Mount Kinabalu, B.N. Borneo, Dallas       1931-12-15 4309593 J. Clemens Clemens 30275 False 64 64 Clemens 30275 Clemens 1931-12-15
671975 671975 4909960980 Poaceae Lophatherum gracile Brongn. Dallas.       1931-12-15 barcode-02243504 J. Clemens & M. S. Clemens Clemens 30275 False 64 64 Clemens 30275 Clemens 1931-12-15
347960 347960 5762664911 Piperaceae Peperomia laevifolia (Blume) Miq. Mount Kinabalu; Tenompok       1931-11-21T00:00 K003519296 Clemens, J.; Clemens, M.S. Clemens 30277 False 64 64 Clemens 30277 Clemens 1931-11-21T00:00
448818 448818 5072751217 Poaceae Coelorachis glandulosa (Trin.) Stapf ex Ridl. Mt. Kinabalu; Dallas.       1931-12-01T00:00 K002700381 Clemens, J.; Clemens, M.S. Clemens 30277 False 64 64 Clemens 30277 Clemens 1931-12-01T00:00
492586 492586 2382929527 Piperaceae Peperomia Ruiz & Pav. Mount Kinabalu, Tenompok, B. N. Borneo       1931-11-21 4125770 J. Clemens Clemens 30277 False 64 64 Clemens 30277 Clemens 1931-11-21
494845 494845 3455084419 Poaceae Rottboellia glandulosa Trin. B. N. Borneo, Mount Kinabalu, Dallas       1931-12 4292105 J. Clemens Clemens 30277 False 64 64 Clemens 30277 Clemens 1931-12
648607 648607 2236951668 Piperaceae Peperomia laevifolia (Blume) Miq. Mount Kinabalu, Tenompok       1931-11-21 barcode-01978321 J. Clemens & M. S. Clemens Clemens 30277 False 64 64 Clemens 30277 Clemens 1931-11-21
674324 674324 4878453731 Poaceae Mnesithea glandulosa (Trin.) de Koning & Sosef Dallas.       1931-12 barcode-02470113 J. Clemens & M. S. Clemens Clemens 30277 False 64 64 Clemens 30277 Clemens 1931-12
492788 492788 3867469511 Poaceae Cyrtococcum trigonum (Retz.) A.Camus Dallas, Mount Kinabalu, B. N. Borneo       1931-12-25 4316688 J. Clemens Clemens 30280 False 64 64 Clemens 30280 Clemens 1931-12-25
349539 349539 4986806359 Poaceae Cyrtococcum patens (L.) A.Camus Dallas; Mt. Kinabalu       1932-01-03T00:00 K003382501 Clemens, J.; Clemens, M.S. Clemens 30281 False 64 64 Clemens 30281 Clemens 1932-01-03T00:00
452473 452473 4986788608 Poaceae Cyrtococcum patens (L.) A.Camus Dallas; Mount Kinabalu       1932-01-03T00:00 K003382500 Clemens, J.; Clemens, M.S. Clemens 30281 False 64 64 Clemens 30281 Clemens 1932-01-03T00:00
555887 555887 5177576685 Poaceae Cyrtococcum patens (L.) A.Camus Malaysia: Mount Kinabalu, Borneo.       1932-01-03 BRI AQ0282338 Clemens, M.S. Clemens 30281 False 64 64 Clemens 30281 Clemens 1932-01-03
453949 453949 4849360039 Poaceae Microstegium ciliatum (Trin.) A.Camus Mount Kinabalu; B. N. Borneo; Dallas       1931-12-15T00:00 K003645854 Clemens, J.; Clemens, M.S. Clemens 30282 False 64 64 Clemens 30282 Clemens 1931-12-15T00:00
270667 270667 5060752387 Poaceae Eragrostis unioloides (Retz.) Nees ex Steud. Moutn Kinabalu; B. N. Borneo; Upper Kinabalu; and Tenompok       1931-12-28T00:00 K003982180 Clemens, J.; Clemens, M.S. Clemens 30284 False 64 64 Clemens 30284 Clemens 1931-12-28T00:00
451551 451551 912709056 Moraceae Ficus grandiflora Corner Dallas,; Mount Kinabalu       1931-12-02T00:00 K001050524 Clemens, J.; Clemens M.S. Clemens 30290 False 64 64 Clemens 30290 Clemens 1931-12-02T00:00
643449 643449 4600559544 Moraceae Ficus grandiflora Corner Dallas       1931-12-02 barcode-02406754 J. Clemens & M. S. Clemens Clemens 30290 False 64 64 Clemens 30290 Clemens 1931-12-02
465569 465569 5145904843 Piperaceae Piper aurilimbum C.DC. Mount Kinabalu; Dallas       1931-12-07T00:00 K003534238 Clemens, J.; Clemens, M.S. Clemens 30300 False 64 64 Clemens 30300 Clemens 1931-12-07T00:00
491049 491049 2423966711 Piperaceae Piper L. Mount Kinabalu. B. N. Borneo. Dallas       1931-12-07 4158991 J. Clemens Clemens 30300 False 64 64 Clemens 30300 Clemens 1931-12-07
631784 631784 2446830209 Piperaceae Piper aurilimbum C.DC. Dallas       1931-12-07 barcode-01936587 J. Clemens & M. S. Clemens Clemens 30300 False 64 64 Clemens 30300 Clemens 1931-12-07
252575 252575 5166267457 Piperaceae Piper vestitum C.DC. Mount Kinabalu; Dallas       1931-12-01T00:00 K003534974 Clemens, J.; Clemens, M.S. Clemens 30302 False 64 64 Clemens 30302 Clemens 1931-12-01T00:00
497205 497205 2423986534 Piperaceae Piper L. Mount Kinabalu. B. N. Borneo. Dallas       1931-12 4158990 J. Clemens Clemens 30302 False 64 64 Clemens 30302 Clemens 1931-12
629126 629126 2446827732 Piperaceae Piper majusculum Blume Dallas       1931-12 barcode-01936775 J. Clemens & M. S. Clemens Clemens 30302 False 64 64 Clemens 30302 Clemens 1931-12
360733 360733 5891327208 Myrtaceae Syzygium kiauense (Merr.) Merr. & L.M.Perry B.N. Borneo;Dallas;Mt. Kinabalu       1931-12-01T00:00 K000258470 Clemens, J.; Clemens, M.S. Clemens 30308 False 64 64 Clemens 30308 Clemens 1931-12-01T00:00
635724 635724 4846548364 Myrtaceae Syzygium kiauense (Merr.) Merr. & L.M.Perry Dallas       1931-12-01 barcode-02448777 J. Clemens & M. S. Clemens Clemens 30308 False 64 64 Clemens 30308 Clemens 1931-12-01
398242 398242 5166256429 Sabiaceae Meliosma pinnata subsp. ridleyi (King) van Beusekom B.N. Borneo; Mount Kinabalu; Dallas       1931-11-26T00:00 K003274936 Clemens, J.; Clemens, M.S. Clemens 30319 False 64 64 Clemens 30319 Clemens 1931-11-26T00: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]);
Powered by Datasette · Queries took 29.213ms