occ

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

20 rows where cluster_num_id = 48 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, decimalLatitude, decimalLongitude, 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
378746 378746 5072766455 Cyperaceae Carex cruciata Wahlenb. British North Borneo; Mount kinabalu Trip, Marai Parai Spur Mount kinabalu.       1915-11-22T00:00 K002805910 Clemens, M.S. Clemens 10885 False 48 48 Clemens 10885 Clemens 1915-11-22T00:00
313623 313623 4601988666 Cyperaceae Tetraria pilisepala (Steud.) Larridon British North Borneo; Mount Kinabalu Trip, Marai Parai Spur Mount Kinabalu       1915-11-22T00:00 K002395907 Clemens, M.S. Clemens 10897 False 48 48 Clemens 10897 Clemens 1915-11-22T00:00
442088 442088 912158857 Lindsaeaceae Lindsaea jamesonioides Baker Mt. Kinabalu, Marai Parai spur. 6.0 116.5   1915-11-22T00:00 K000115784 Clemens, M.S. Clemens 10909 True 48 48 Clemens 10909 Clemens 1915-11-22T00:00
245928 245928 3023622302 Hymenophyllaceae Vandenboschia maxima (Blume) Copel. Mount Kinabalu, Marai Parai Spur       1915-11-22 1572543 Mary Strong Clemens Clemens 10911 False 48 48 Clemens 10911 Clemens 1915-11-22
323509 323509 912396322 Athyriaceae Diplazium crenatoserratum (Blume) T.Moore Marai Parai Spur, Mt. Kinabalu 6.083333 116.516667   1915-11-22T00:00 K000474202 Clemens, M.S. Clemens 10914 True 48 48 Clemens 10914 Clemens 1915-11-22T00:00
342850 342850 912544110 Cyatheaceae Cyathea longipes Copel. Sabah: Marai Parai Spur, Mt. Kinabalu 6.083333 116.516667   1915-11-22T00:00 K000698125 Clemens, M.S. Clemens 10915 True 48 48 Clemens 10915 Clemens 1915-11-22T00:00
316062 316062 912361785 Aspleniaceae Asplenium borneense Hook. Mt Kinabalu, Marai Parai Spur 6.083333 116.516667   1915-11-22T00:00 K000429920 Clemens, M.S. Clemens 10916 True 48 48 Clemens 10916 Clemens 1915-11-22T00:00
246166 246166 3356315310 Pteridaceae Syngramma alismifolia (C.Presl) J.Sm. Marai Parai Spur, Mount Kinabalu       1915-11-22 1597678 Mary Strong Clemens Clemens 10917 False 48 48 Clemens 10917 Clemens 1915-11-22
464168 464168 912340457 Schizaeaceae Schizaea malaccana var. robustior C.Chr. Mount Kinabalu, Marai Parai spur 6.083333 116.516667   1915-11-22T00:00 K000408063 Clemens, M.S. Clemens 10919 True 48 48 Clemens 10919 Clemens 1915-11-22T00:00
365038 365038 912550358 Cyatheaceae Cyathea glabra (Blume) Copel. Mt Kinabalu, Marai Parai Spur 6.083333 116.516667   1915-11-22T00:00 K000706129 Clemens, M.S. Clemens 10924 True 48 48 Clemens 10924 Clemens 1915-11-22T00:00
654130 654130 4597963369 Myrtaceae Syzygium dasyphyllum Merr. & L.M.Perry Marai Parai Spur; Mount Kinabalu       1915-11-22 barcode-02448248 M. S. Clemens Clemens 10931 False 48 48 Clemens 10931 Clemens 1915-11-22
630515 630515 5843775804 Actinidiaceae Saurauia amoena Stapf Marai Parai Spur, Mount Kinabalu       1915-11-22 barcode-02667973 M. S. Clemens Clemens 10943 False 48 48 Clemens 10943 Clemens 1915-11-22
426189 426189 5104014760 Symplocaceae Symplocos pendula Wight Mount Kinabalu Trip; Marai Parai Spur; Mount Kinabalu       1915-11-22T00:00 K005936086 Clemens, M.S. Clemens 10945 False 48 48 Clemens 10945 Clemens 1915-11-22T00:00
467036 467036 912482857 Gleicheniaceae Gleichenia J.E.Sm. Mt. Kinabalu, Marai Parai Spur 6.083333 116.516667   1915-11-22T00:00 K000598434 Clemens, M.S. Clemens 10947 True 48 48 Clemens 10947 Clemens 1915-11-22T00:00
572172 572172 1230861874 Schisandraceae Illicium stapfii Merr. British North Borneo, Marai Parai Spur, Mount Kinabalu.       1915-11-22 2003-0001783 Clemens,M.S. 10949 Clemens 10949 False 48 48 Clemens 10949 Clemens 1915-11-22
303235 303235 5159808831 Podocarpaceae Falcatifolium falciforme (Parl.) de Laub. Mount Kinabalu Trip; Marai Parai Spur; Mount Kinabalu       1915-12-01T00:00 K005268955 Clemens, M.S. Clemens 10962 False 48 48 Clemens 10962 Clemens 1915-12-01T00:00
418268 418268 4958512925 Fagaceae Quercus lowii King Marai Parai Spur; Mount Kinabalu       1915-12-01T00:00 K003813061 Clemens, M.S. Clemens 10963 False 48 48 Clemens 10963 Clemens 1915-12-01T00:00
596560 596560 4856437913 Loranthaceae Loranthus Jacq. British North Borneo; Marai Parai Spur, Mount Kinabalu       1915-12-01 UC214895 Mary Strong Clemens Clemens 10975 False 48 48 Clemens 10975 Clemens 1915-12-01
398308 398308 5283773889 Goodeniaceae Scaevola micrantha C.Presl Mount Kinabalu Trip; Marai Parai Spur Mount Kinabalu       1915-12-01T00:00 K005518090 Clemens, M.S. Clemens 10984 False 48 48 Clemens 10984 Clemens 1915-12-01T00:00
620711 620711 5054522555 Goodeniaceae Scaevola micrantha C.Presl Marai Parai Spur       1915-12-02 barcode-02305448 M. S. Clemens Clemens 10984 False 48 48 Clemens 10984 Clemens 1915-12-02

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