occ

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

10 rows where cluster_num_id = 71 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
620160 620160 3412435331 Orchidaceae Oberonia dubia J.J.Sm. Dallas       1932 barcode-02096482 J. Clemens & M. S. Clemens Clemens 30172 False 71 71 Clemens 30172 Clemens 1932
630624 630624 3459880369 Orchidaceae Dendrochilum exasperatum Ames above Lumus       1932-01 barcode-02093864 J. Clemens & M. S. Clemens Clemens 30173 False 71 71 Clemens 30173 Clemens 1932-01
260020 260020 912594717 Pandanaceae Pandanus Parkinson Tenompok. Mount Kinabalu     1524.0 1932-01-01T00:00 K000781353 Clemens, J.; Clemens, M.S. Clemens 30176 False 71 71 Clemens 30176 Clemens 1932-01-01T00:00
311130 311130 912594735 Pandanaceae Pandanus Parkinson Tenompok. Mount Kinabalu     1524.0 1932-01-01T00:00 K000781354 Clemens, J.; Clemens, M.S. Clemens 30176 False 71 71 Clemens 30176 Clemens 1932-01-01T00:00
312231 312231 912594683 Pandanaceae Pandanus Parkinson Tenompok. Mount Kinabalu     1524.0 1932-01-01T00:00 K000781355 Clemens, J.; Clemens, M.S. Clemens 30176 False 71 71 Clemens 30176 Clemens 1932-01-01T00:00
324897 324897 912595096 Pandanaceae Pandanus Parkinson Tenompok. Mount Kinabalu     1524.0 1932-01-01T00:00 K000781701 Clemens, J.; Clemens, M.S. Clemens 30176 False 71 71 Clemens 30176 Clemens 1932-01-01T00:00
505427 505427 1258096545 Pandanaceae Benstonea tunicata (B.C.Stone) Callm. & Buerki British North Borneo, Mount Kinabalu, Tenompok 5.9825 116.516945 1300.0 1932-01 100766972 Joseph Clemens Clemens 30176 True 71 71 Clemens 30176 Clemens 1932-01
508130 508130 1144746880 Pandanaceae Pandanus kinabaluensis H.St.John ex B.C.Stone       1500.0 1932 G00164232 Clemens, J. & M. S. Clemens Clemens 30176 False 71 71 Clemens 30176 Clemens 1932
338925 338925 4906859741 Meliaceae Aglaia rivularis Merr. Mount Kinabalu; Kabayo       1931-12-25T00:00 K005395912 Clemens, J.; Clemens, M.S. Clemens 30177 False 71 71 Clemens 30177 Clemens 1931-12-25T00:00
552685 552685 5054523238 Meliaceae Aglaia rivularis Merr. Kabayo       1931-12-25 barcode-02481477 J. Clemens & M. S. Clemens Clemens 30177 False 71 71 Clemens 30177 Clemens 1931-12-25

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