occ

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

38 rows where cluster_num_id = 32 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, locality, decimalLatitude, decimalLongitude, eventDate, recordedBy, has_coordinates, 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
243697 243697 3419900333 Aspleniaceae Asplenium subaquatile Ces. Along river Gat, Upper Rejang River       1929-07-29 1609367 J. Clemens Clemens 21986 False 32 32 Clemens 21986 Clemens 1929-07-29
494319 494319 2251693252 Aspleniaceae Asplenium subaquatile Ces. Below Gat, Near river Gat, Upper Rejang River       1929-07-29 4053430 J. Clemens Clemens 21986 False 32 32 Clemens 21986 Clemens 1929-07-29
493715 493715 2251702074 Aspleniaceae Asplenium vittaeforme Cav. Gat, Mt. Majau forest, Upper Rejang River       1929-07-22 4053554 J. Clemens Clemens 21987 False 32 32 Clemens 21987 Clemens 1929-07-22
490357 490357 2251705673 Aspleniaceae Asplenium vittaeforme Cav. Gat, Upper Rejang River, altitude: low       1929-07-06 04053550 J. Clemens Clemens 21988 False 32 32 Clemens 21988 Clemens 1929-07-06
497615 497615 1991422487 Pteridaceae Syngramma wallichii (Hook.) Bedd. Gat, Upper Rejang River, Mt. Majau       1929-07-22 03914351 J. Clemens Clemens 21990 False 32 32 Clemens 21990 Clemens 1929-07-22
497384 497384 2239546665 Aspleniaceae Asplenium cuneatum Lam. Gat, Upper Rejang River, Mount Majan       1929-07-22 4052681 J. Clemens Clemens 21991 False 32 32 Clemens 21991 Clemens 1929-07-22
489211 489211 2251706902 Athyriaceae Diplazium polypodioides Blume Gat, Upper Rejang River, low alt., Base of Mt. Majau       1929-07-24 4064240 J. Clemens Clemens 21992 False 32 32 Clemens 21992 Clemens 1929-07-24
493874 493874 1981506675 Schizaeaceae Schizaea dichotoma (L.) Sm. Rejang River, near river landing.       1929-08-14 3882897 J. Clemens Clemens 21994 False 32 32 Clemens 21994 Clemens 1929-08-14
492168 492168 1981505556 Lygodiaceae Lygodium circinnatum (Burm.fil.) Sw. Gat, Upper Rejang River       1929-06-29 3891821 J. Clemens Clemens 21996 False 32 32 Clemens 21996 Clemens 1929-06-29
495899 495899 2235401704 Cyatheaceae Cyathea J.E.Sm. Gat, Upper Rejang River       1929-07-11 4005659 M. S. Clemens Clemens 21998 False 32 32 Clemens 21998 Clemens 1929-07-11
493681 493681 2235401069 Cyatheaceae Sphaeropteris moluccana (Desv.) R.M.Tryon Borneo, Kapit, Upper Rejang River       1929-07-11 04007005 J. Clemens Clemens 21999 False 32 32 Clemens 21999 Clemens 1929-07-11
489650 489650 2447319505 Blechnaceae Stenochlaena J.Sm. Gat, upper Rejang River, Mt. Majau       1929-07-22 04180459 J. Clemens Clemens 22000 False 32 32 Clemens 22000 Clemens 1929-07-22
525337 525337 2424018740 Davalliaceae Davallia J.E.Sm. Mt. Gat, Upper Rejang River, Base Mt. Mayau       1929-07-25 4162955 M. S. Clemens Clemens 22002 False 32 32 Clemens 22002 Clemens 1929-07-25
491816 491816 2235408828 Dennstaedtiaceae Microlepia speluncae (L.) T.Moore Gat, Upper Rejang River, Below Gat, along river       1929-07-29 4014354 J. Clemens Clemens 22004 False 32 32 Clemens 22004 Clemens 1929-07-29
525968 525968 1991445875 Pteridaceae Antrophyum subfalcatum Brack. Gat, Upper Rejang River., Below Gat       1929-07-29 03923918 J. Clemens Clemens 22005 False 32 32 Clemens 22005 Clemens 1929-07-29
496899 496899 1991441647 Pteridaceae Haplopteris zosterifolia (Willd.) E.H.Crane Gat, Upper Rejang River       1929-07-25 3936987 J. Clemens Clemens 22007 False 32 32 Clemens 22007 Clemens 1929-07-25
495857 495857 2251703539 Aspleniaceae Asplenium pellucidum Lam. Borneo, Gat, upper Rejang River. Base, Mt. Majau       1929-07-27 4053268 J. Clemens Clemens 22009 False 32 32 Clemens 22009 Clemens 1929-07-27
488743 488743 2251698113 Athyriaceae Athyrium maximum (D.Don) Copel. Gat, Upper Rejang River, altitude low       1929-07-11 4058844 J. Clemens Clemens 22011 False 32 32 Clemens 22011 Clemens 1929-07-11
496733 496733 2235402593 Polypodiaceae Prosaptia alata (Blume) Christ Gat, Upper Rejang River, Mt. Majau ridge       1929-07-22 3985925 J. Clemens Clemens 22012 False 32 32 Clemens 22012 Clemens 1929-07-22
491503 491503 2012771599 Polypodiaceae Crypsinus albidosquamatus (Blume) Copel. Gat, Upper Rajang River, Below Gat, along river       1929-07-29 3952086 J. Clemens Clemens 22013 False 32 32 Clemens 22013 Clemens 1929-07-29
494175 494175 2012773779 Polypodiaceae Microsorum pteropus (Blume) Copel. Borneo, Gat, Upper Rejang River,       1929-07-16 03948309 J. Clemens Clemens 22015 False 32 32 Clemens 22015 Clemens 1929-07-16
387279 387279 912462101 Polypodiaceae Microsorum membranifolium (R.Br.) Ching Gat, Upper Rejang river 1.9 113.45   1929-07-24T00:00 K000572025 Clemens, M.S.; Clemens, J. Clemens 22016 True 32 32 Clemens 22016 Clemens 1929-07-24T00:00
497213 497213 1928111704 Hymenophyllaceae Hymenophyllum leptocarpum Copel. Sarawak, Borneo: Gat, upper Rejang River       1929-07-22 127549 J. Clemens Clemens 22018 False 32 32 Clemens 22018 Clemens 1929-07-22
596913 596913 4856621547 Hymenophyllaceae Hymenophyllum leptocarpum Copel. Borneo: Sarawak: Gat, Upper Rejang River.       1929-07-22 UC423169 J. Clemens;M. S. Clemens Clemens 22018 False 32 32 Clemens 22018 Clemens 1929-07-22
366835 366835 912308098 Hymenophyllaceae Trichomanes setaceum Bosch Gat (Gaat), upper Rejang R. (Rajang), Mt. Majau 1.833334 113.433333   1929-07-22T00:00 K000362389 Clemens, J.; Clemens, M.S. Clemens 22019 True 32 32 Clemens 22019 Clemens 1929-07-22T00:00
494128 494128 2012782395 Hymenophyllaceae Trichomanes merrillii Copel. Gat, Upper Rejang River, Mt. Mayau Summit       1929-07-22 03938928 J. Clemens Clemens 22019 False 32 32 Clemens 22019 Clemens 1929-07-22
243214 243214 3041328565 Hymenophyllaceae Cephalomanes singaporianum Bosch Yat, Upper Rejang River       1929-07-22 1574605 J. Clemens & M. S. Clemens Clemens 22020 False 32 32 Clemens 22020 Clemens 1929-07-22
497475 497475 1991415299 Hymenophyllaceae Trichomanes javanicum Blume Gat, Upper Rejang River, Mt. Majau       1929-07-22 3938846 J. Clemens Clemens 22020 False 32 32 Clemens 22020 Clemens 1929-07-22
489831 489831 2273859778 Tectariaceae Tectaria crenata Cav. Gat, Upper Rejang River       1929-07-04 4075395 J. Clemens Clemens 22023 False 32 32 Clemens 22023 Clemens 1929-07-04
493457 493457 2239547079 Thelypteridaceae Thelypteris beccariana (Ces.) C.F.Reed Gat, upper Rejang River, Mt. Majau       1929-07-22 4036144 J. Clemens Clemens 22024 False 32 32 Clemens 22024 Clemens 1929-07-22
493302 493302 2239552599 Thelypteridaceae Thelypteris recumbens (Rosenst.) C.F.Reed Below Gat along river Gat, Upper Rejang River       1929-07 04036638 J. Clemens Clemens 22025 False 32 32 Clemens 22025 Clemens 1929-07
495094 495094 2239548699 Thelypteridaceae Thelypteris recumbens (Rosenst.) C.F.Reed Gat, Upper Rejang River       1929-07-13 04036639 J. Clemens Clemens 22026 False 32 32 Clemens 22026 Clemens 1929-07-13
495903 495903 2239576217 Thelypteridaceae Thelypteris beccariana (Ces.) C.F.Reed Gat, Upper Rejang River, Mt Majau forest       1929-07-20 4036143 J. Clemens Clemens 22027 False 32 32 Clemens 22027 Clemens 1929-07-20
496400 496400 2239580924 Thelypteridaceae Thelypteris urophylla (Mett.) K.Iwats. Gat, upper Rejang River, Mt. Majau       1929-07-22 4036816 J. Clemens Clemens 22029 False 32 32 Clemens 22029 Clemens 1929-07-22
490783 490783 1949866648 Lycopodiaceae Phlegmariurus phlegmaria (L.) Holub Borneo. Gat, Upper Rejang River. West prob base of Mt. Majau       1929-07-24 3835709 M. S. Clemens Clemens 22030 False 32 32 Clemens 22030 Clemens 1929-07-24
493316 493316 1949818024 Lycopodiaceae Phlegmariurus squarrosus (G.Forst.) Á.Löve & D.Löve Gat, Upper Rejang River       1929-07-16 3842315 J. Clemens Clemens 22031 False 32 32 Clemens 22031 Clemens 1929-07-16
493921 493921 1949849139 Selaginellaceae Selaginella grandis T.Moore Gat, Upper Rejang River. Base Mt. Majau.       1929-07-22 03865196 J. Clemens Clemens 22035 False 32 32 Clemens 22035 Clemens 1929-07-22
495839 495839 1949822837 Selaginellaceae Selaginella hewittii Hieron. Borneo. Gat, Upper Rejang River. Mt. Majau forest.       1929-07-22 03865198 J. Clemens Clemens 22037 False 32 32 Clemens 22037 Clemens 1929-07-22

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