occ

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

6 rows where cluster_num_id = 72 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
347099 347099 5130162880 Rubiaceae Gardenia tubifera Wall. ex Roxb. Mount Kinabalu; Tenompok       1931-01-01T00:00 K001643379 Clemens, J.; Clemens, M.S. Clemens 30344 False 72 72 Clemens 30344 Clemens 1931-01-01T00:00
632150 632150 1998600661 Pentaphylacaceae Eurya pseudomyrtillus Suess. & Heine Upper Mount Kinabalu, 6000-13500 feet       1931-01 barcode-00024889 J. Clemens & M. S. Clemens Clemens 30347 False 72 72 Clemens 30347 Clemens 1931-01
260327 260327 5130176046 Annonaceae Artabotrys kinabaluensis I.M.Turner Mount Kinabalu; Tenompok       1931-01-01T00:00 K003312735 Clemens, J.; Clemens, M.S. Clemens 30351 False 72 72 Clemens 30351 Clemens 1931-01-01T00:00
489440 489440 1930316369 Annonaceae Artabotrys R.Br. Mount Kinabalu: Tenompok 6.00353 116.52906   1931 02059440 J. Clemens Clemens 30351 True 72 72 Clemens 30351 Clemens 1931
623018 623018 4989157372 Annonaceae Artabotrys kinabaluensis I.M.Turner Tenempok       1931 barcode-02612134 J. Clemens & M. S. Clemens Clemens 30351 False 72 72 Clemens 30351 Clemens 1931
412355 412355 4979590446 Convolvulaceae Argyreia erinacea Ooststr. Borneo: Mt. Kinabalu: Tenompok       1931-01-01T00:00 K001586822 Clemens, J.; Clemens, M.S. Clemens 30361 False 72 72 Clemens 30361 Clemens 1931-01-01T00: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]);