occ

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

25 rows where cluster_num_id = 38 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
463186 463186 5843815623 Thelypteridaceae Coryphopteris gymnopoda (Baker) Holttum Br.N. Borneo, Mt. Kinabalu, Colombon river       1933-01-01T00:00 K000656569 Clemens Clemens 33675 False 38 38 Clemens 33675 Clemens 1933-01-01T00:00
487956 487956 5956512849 Thelypteridaceae Coryphopteris gymnopoda (Baker) Holttum North Borneo, Mt. Kinabalu.Colombon River basin.     1829.0 1933-01-01 103617 Clemens Clemens 33675 False 38 38 Clemens 33675 Clemens 1933-01-01
673068 673068 4088833379 Thelypteridaceae Coryphopteris multisora (C.Chr.) Holttum Colombon river basin       1933 barcode-02404604 M. S. Clemens Clemens 33675 False 38 38 Clemens 33675 Clemens 1933
629406 629406 4404053304 Polypodiaceae Acrosorus streptophyllus (Baker) Copel. Colombon river basin       1933 barcode-02220622 M. S. Clemens Clemens 33677 False 38 38 Clemens 33677 Clemens 1933
672182 672182 4128526345 Athyriaceae Diplazium latisquamatum Holttum Colombon basin       1933 barcode-02402494 M. S. Clemens Clemens 33682 False 38 38 Clemens 33682 Clemens 1933
492408 492408 2012777800 Polypodiaceae Polypodiopteris brachypodia (Copel.) C.F.Reed B.N. Borneo. Mt. Kinabalu. Colombon river Basin.       1933 03952423 J. Clemens Clemens 33692 False 38 38 Clemens 33692 Clemens 1933
652703 652703 4404054365 Polypodiaceae Selliguea brachypodia (Copel.) Christenh. Colombon river basin       1933 barcode-02219956 M. S. Clemens Clemens 33692 False 38 38 Clemens 33692 Clemens 1933
245486 245486 3947900762 Thelypteridaceae Pronephrium peltatum var. aberrans Holttum Colombon R. basin, Upper Kinabalu       1933 1626662 J. Clemens Clemens 33702 False 38 38 Clemens 33702 Clemens 1933
322640 322640 912352199 Hymenophyllaceae Hymenophyllum J.E.Sm. Mt. Kinabalu, Colombon River basin 6.1 116.5 2285.0 1933-01-01T00:00 K000420147 Clemens Clemens 33718 True 38 38 Clemens 33718 Clemens 1933-01-01T00:00
458921 458921 5956308365 Hymenophyllaceae Mecodium productum (Kunze) Copel. North Borneo, Mt. Kinabalu Colombon river basin.     2286.0 1933-01-01 94617 Clemens Clemens 33718 False 38 38 Clemens 33718 Clemens 1933-01-01
494733 494733 2012796931 Hymenophyllaceae Mecodium productum (Kunze) Copel. B.N. Borneo. Mt. Kinabalu. Colombon river Basin.       1933 3964396 J. Clemens Clemens 33718 False 38 38 Clemens 33718 Clemens 1933
640387 640387 3922531326 Hymenophyllaceae Hymenophyllum productum Kunze Colombon river basin       1933 barcode-02581706 M. S. Clemens Clemens 33718 False 38 38 Clemens 33718 Clemens 1933
613377 613377 4088827322 Thelypteridaceae Plesioneuron fuchsii Holttum Colombon river basin       1933 barcode-02404869 M. S. Clemens Clemens 33719 False 38 38 Clemens 33719 Clemens 1933
244013 244013 3947894685 Athyriaceae Diplazium fuliginosum (Hook.) M.G.Price Kinataki & Colombon rivers       1933 1617755 J. Clemens Clemens 33723 False 38 38 Clemens 33723 Clemens 1933
327070 327070 912446805 Polypodiaceae Grammitis fasciata Blume Mt Kinabalu, Colombon [Kilembun] river basin 6.1 116.5 2743.0 1933-01-01T00:00 K000538467 Clemens, J.; Clemens, M.S. Clemens 33739 True 38 38 Clemens 33739 Clemens 1933-01-01T00:00
458880 458880 5956293422 Polypodiaceae Oreogrammitis fasciata (Blume) Parris North Borneo, Mt. Kinabalu, Colombon river.     2743.0 1933-01-01 105871 Clemens Clemens 33739 False 38 38 Clemens 33739 Clemens 1933-01-01
496704 496704 2235400201 Polypodiaceae Oreogrammitis fasciata (Blume) Parris Br. N. Borneo, Mt. Kinabalu, Colombon river basin       1933 3986048 J. Clemens Clemens 33739 False 38 38 Clemens 33739 Clemens 1933
605855 605855 4406256319 Polypodiaceae Oreogrammitis fasciata (Blume) Parris Colombon river basin       1933 barcode-02220898 M. S. Clemens Clemens 33739 False 38 38 Clemens 33739 Clemens 1933
420577 420577 912421081 Athyriaceae Diplazium Sw. Mt. Kinabalu. Columbon river basin 6.1 116.5 2591.0 1933-01-01T00:00 K000506278 Clemens Clemens 33747 True 38 38 Clemens 33747 Clemens 1933-01-01T00:00
491062 491062 2251693751 Athyriaceae Diplazium amplissimum (Baker) Diels B.N. Borneo. Mt. Kinabalu. Colombon river basin.       1933 04062098 J. Clemens Clemens 33747 False 38 38 Clemens 33747 Clemens 1933
668426 668426 4128533330 Athyriaceae Diplazium Sw. Colombon river basin       1933 barcode-02402740 M. S. Clemens Clemens 33747 False 38 38 Clemens 33747 Clemens 1933
409249 409249 912527003 Dryopteridaceae Dryopteris subarborea (Baker) C.Chr. Mt. Kinabalu; Kilembun river basin 6.1 116.5 2591.0 1933-01-01T00:00 K000672559 Clemens, M.S. Clemens 33750 True 38 38 Clemens 33750 Clemens 1933-01-01T00:00
432153 432153 912527028 Dryopteridaceae Dryopteris subarborea (Baker) C.Chr. Mt. Kinabalu; Kilembun river basin 6.1 116.5 2591.0 1933-01-01T00:00 K000672560 Clemens, M.S. Clemens 33750 True 38 38 Clemens 33750 Clemens 1933-01-01T00:00
486186 486186 5956566701 Dryopteridaceae Dryopteris subarborea (Baker) C.Chr. Archipel. Ind. Br. N. Borneo, Mt. Kinabalu Columbon river basin     2591.0 1933-01-01 103624 Clemens Clemens 33750 False 38 38 Clemens 33750 Clemens 1933-01-01
607329 607329 4142716306 Dryopteridaceae Dryopteris subarborea (Baker) C.Chr. Columbon river basin       1933 barcode-02505401 M. S. Clemens Clemens 33750 False 38 38 Clemens 33750 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]);