occ

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

11 rows where cluster_num_id = 66 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, locality, eventDate, recordedBy, 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
468588 468588 5072763178 Gentianaceae Cyrtophyllum fragrans (Roxb.) DC. Mount Kinabalu Trip; Jesselton       1915-10-23T00:00 K004916093 Clemens, M.S. Clemens 9563 False 66 66 Clemens 9563 Clemens 1915-10-23T00:00
254745 254745 4988862325 Rubiaceae Oldenlandia tetrangularis (Korth.) Merr. Mount Kinabalu; Jesselton       1915-10-23T00:00 K004993688 Clemens, M.S. Clemens 9566 False 66 66 Clemens 9566 Clemens 1915-10-23T00:00
448064 448064 4952019623 Polygalaceae Salomonia ciliata (L.) DC. Mount Kinabalu Trip, Jesselton       1915-10-23T00:00 K002732675 Clemens, M.S. Clemens 9569 False 66 66 Clemens 9569 Clemens 1915-10-23T00:00
664023 664023 1999163917 Myrtaceae Tristania clementis Merr. Jesselton, hillsides       1915-10-23 barcode-00071581 M. S. Clemens Clemens 9570 False 66 66 Clemens 9570 Clemens 1915-10-23
473352 473352 4954008131 Myrtaceae Baeckea frutescens L. Mount Kinabalu Trip; Jesselton       1915-10-23T00:00 K004772402 Clemens, M.S. Clemens 9574 False 66 66 Clemens 9574 Clemens 1915-10-23T00:00
335115 335115 4858966226 Myrtaceae Decaspermum fruticosum J.R.Forst. & G.Forst. British North Boreno; Jesselton       1915-10-23T00:00 K004207217 Clemens, M.S. Clemens 9575 False 66 66 Clemens 9575 Clemens 1915-10-23T00:00
401807 401807 5145857930 Orobanchaceae Centranthera humifusa Wall., 1831 Mount Kinabalu; Jesselton       1915-10-23T00:00 K004128023 Clemens, M.S. Clemens 9580 False 66 66 Clemens 9580 Clemens 1915-10-23T00:00
455525 455525 4849380990 Poaceae Eragrostis pilosa (L.) P.Beauv. British North Borneo; Mount Kinabalu Trip, Jesselton       1915-10-23T00:00 K003982097 Clemens, M.S. Clemens 9586 False 66 66 Clemens 9586 Clemens 1915-10-23T00:00
315764 315764 5077873034 Nepenthaceae Nepenthes gracilis Korth. Mount Kinabalu Trip; Jesselton       1915-10-23T00:00 K005916452 Clemens, M.S. Clemens 9588 False 66 66 Clemens 9588 Clemens 1915-10-23T00:00
347718 347718 4602121457 Burmanniaceae Burmannia coelestis D.Don British North Borneo; Mount Kinabalu Trip; Jesselton       1915-10-23T00:00 K003635897 Clemens, M.S. Clemens 9590 False 66 66 Clemens 9590 Clemens 1915-10-23T00:00
268028 268028 5152178597 Haloragaceae Gonocarpus chinensis (Lour.) Orchard Mount Kinabalau Trip; Jesselton       1915-10-23T00:00 K004250656 Clemens, M.S. Clemens 9591 False 66 66 Clemens 9591 Clemens 1915-10-23T00:00

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