occ

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

20 rows where cluster_num_id = 57 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
280237 280237 912307904 Hymenophyllaceae Trichomanes L. Mt. Kinabalu, Colombon R. 6.1 116.5 1375.0 1933-01-01T00:00 K000362202 Clemens Clemens 32513 True 57 57 Clemens 32513 Clemens 1933-01-01T00:00
428587 428587 912211607 Hymenophyllaceae Trichomanes apiifolium C.Presl Mt Kinabalu, Colombon R. [Kilembun] 6.1 116.5 1375.0 1933-01-01T00:00 K000235539 Clemens, J. Clemens 32513 True 57 57 Clemens 32513 Clemens 1933-01-01T00:00
460817 460817 5956364779 Hymenophyllaceae Trichomanes obscurum Blume North Borneo, Mt. Kinabalu, Colombon River.     1372.0 1933-01-01 95030 Clemens Clemens 32513 False 57 57 Clemens 32513 Clemens 1933-01-01
494752 494752 1991436797 Hymenophyllaceae Trichomanes apiifolium C.Presl Br.N. Borneo, Mt. Kinabalu, Colombon river.       1933 03934969 J. Clemens Clemens 32513 False 57 57 Clemens 32513 Clemens 1933
620796 620796 3915845437 Hymenophyllaceae Callistopteris apiifolia (C.Presl) Copel. Colombon River       1933 barcode-02580683 M. S. Clemens Clemens 32513 False 57 57 Clemens 32513 Clemens 1933
626811 626811 3915852353 Hymenophyllaceae Abrodictyum obscurum (Blume) Ebihara & K.Iwats. Colombon river       1933 barcode-02580487 M. S. Clemens Clemens 32513 False 57 57 Clemens 32513 Clemens 1933
661217 661217 3828131431 Orchidaceae Phaius subtrilobus Ames & C.Schweinf. Pantaran river       1933 barcode-02388641 J. Clemens & M. S. Clemens Clemens 32528 False 57 57 Clemens 32528 Clemens 1933
649088 649088 4074169385 Thelypteridaceae Sphaerostephanos stipellatus (Blume) Holttum Panataran river       1933 barcode-02403488 M. S. Clemens Clemens 32548 False 57 57 Clemens 32548 Clemens 1933
603538 603538 4125836351 Athyriaceae Diplazium atrosquamosum (Copel.) C.Chr. Panataran river       1933 barcode-02402338 M. S. Clemens Clemens 32558 False 57 57 Clemens 32558 Clemens 1933
458281 458281 5956178673 Athyriaceae Athyrium boryanum (Willd.) Tagawa North Borneo, Mt. Kinabalu, Penataran River basin.     1372.0 1933-01-01 98393 Clemens Clemens 32563 False 57 57 Clemens 32563 Clemens 1933-01-01
496805 496805 2251703258 Athyriaceae Dryoathyrium boryanum (Willd.) Ching B.N. Borneo. Mt. Kinabalu. Penataran river basin.       1933 04066365 J. Clemens Clemens 32563 False 57 57 Clemens 32563 Clemens 1933
610288 610288 4128526381 Athyriaceae Diplazium Sw. Penataran river basin       1933 barcode-02402752 M. S. Clemens Clemens 32563 False 57 57 Clemens 32563 Clemens 1933
250344 250344 912421033 Athyriaceae Diplazium Sw. Mt. Kinabalu. Penataran river basin 6.1 116.533333 1372.0 1933-01-01T00:00 K000506277 Clemens Clemens 32565 True 57 57 Clemens 32565 Clemens 1933-01-01T00:00
343726 343726 912446672 Polypodiaceae Grammitis congener Blume Mt Kinabaku, Penataran River Basin 6.116667 116.516667 1067.0 1933-01-01T00:00 K000538353 Clemens, J.; Clemens, M.S. Clemens 32570 True 57 57 Clemens 32570 Clemens 1933-01-01T00:00
458326 458326 5956320571 Polypodiaceae Oreogrammitis congener (Blume) Parris North Borneo, Mt. Kinabalu, Penataran river basin.     1067.0 1933-01-01 103966 Clemens Clemens 32570 False 57 57 Clemens 32570 Clemens 1933-01-01
635347 635347 3887812411 Orchidaceae Bulbophyllum placochilum J.J.Verm. Columbon river       1933 barcode-02385085 J. Clemens & M. S. Clemens Clemens 32587 False 57 57 Clemens 32587 Clemens 1933
301258 301258 912333103 Thelypteridaceae Sphaerostephanos trichochlamys Holttum Mt.Kinabalu, Marai Parai 6.083333 116.516667 1500.0 1933-01-01T00:00 K000398055 Clemens. Clemens 32593 True 57 57 Clemens 32593 Clemens 1933-01-01T00:00
495343 495343 2239571750 Thelypteridaceae Thelypteris trichochlamys (Holttum) Christenh. Br. N. Borneo, Mt. Kinabalu, Marai Parai       1933 4036763 J. Clemens Clemens 32593 False 57 57 Clemens 32593 Clemens 1933
616264 616264 4074161325 Thelypteridaceae Sphaerostephanos heterocarpos (Blume) Holttum Marai Parai       1933 barcode-02403410 M. S. Clemens Clemens 32593 False 57 57 Clemens 32593 Clemens 1933
666346 666346 4088826318 Thelypteridaceae Pneumatopteris callosa Nakai [no additional data]       1933 barcode-02404952 M. S. Clemens Clemens 32593 False 57 57 Clemens 32593 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]);