occ

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

12 rows where cluster_num_id = 20 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: family, scientificName, locality, elevation, eventDate, recordedBy, recordNumber_mainNumber, 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
663776 663776 4954815655 Symplocaceae Symplocos ophirensis var. cumingiana (Brand) Noot. Columbon river       1933-07-10 barcode-02601412 J. Clemens & M. S. Clemens Clemens 35042 False 20 20 Clemens 35042 Clemens 1933-07-10
497015 497015 3898414543 Myricaceae Myrica javanica Reinw. ex Blume Mount Kinabalu, B. N. Borneo, Columbon river       1933-07-12 4358368 J. Clemens Clemens 35045 False 20 20 Clemens 35045 Clemens 1933-07-12
573617 573617 1056458272 Myricaceae Myrica javanica Reinw. ex Blume Mt. Kinabalu: Head of Columbon river; 7000'     2134.0 1933-07-12 BM000608042 Joseph Clemens;Mary Strong Clemens Clemens 35045 False 20 20 Clemens 35045 Clemens 1933-07-12
672142 672142 5161611336 Myricaceae Morella javanica (Blume) I.M.Turner Mount Kinabalu; Columbon river       1933-07-12 barcode-02658489 J. Clemens & M. S. Clemens Clemens 35045 False 20 20 Clemens 35045 Clemens 1933-07-12
489716 489716 4439084637 Campanulaceae Lobelia borneensis subsp. grandiflora (Stapf) Lammers Mount Kinabalu B. N. Borneo Colombon river       1933-06-30 4831777 J. Clemens Clemens 35055 False 20 20 Clemens 35055 Clemens 1933-06-30
616057 616057 6061894927 Campanulaceae Lobelia borneensis (Hemsl.) Moeliono Colombon river       1933-06-30 barcode-01172558 J. Clemens & M. S. Clemens Clemens 35055 False 20 20 Clemens 35055 Clemens 1933-06-30
237166 237166 574938988 Ericaceae Rhododendron rugosum H.Low ex Hook.fil.         1933-06-27 E00144757 Clemens, Joseph & Clemens, Mary Strong Clemens 35071 False 20 20 Clemens 35071 Clemens 1933-06-27
651629 651629 4024405374 Ericaceae Rhododendron rugosum H.Low ex Hook.fil. Colombon river       1933-06-27 barcode-01820896 J. Clemens & M. S. Clemens Clemens 35071 False 20 20 Clemens 35071 Clemens 1933-06-27
494299 494299 3991065031 Ericaceae Diplycosia chrysothrix Stapf Mount Kinabalu B. N. Borneo Panataran river       1933-06-14 4368432 J. Clemens Clemens 35076 False 20 20 Clemens 35076 Clemens 1933-06-14
620784 620784 3993964314 Ericaceae Diplycosia chrysothrix Stapf B. N. Borneo, Panataran river       1933-06-14 barcode-01819862 J. Clemens & M. S. Clemens Clemens 35076 False 20 20 Clemens 35076 Clemens 1933-06-14
551427 551427 1699810890 Ericaceae Diplycosia clementium Sleumer Colombon river     1370.0 1933-06-13 HBG515499 Clemens, J. & M.S. Clemens 35077 False 20 20 Clemens 35077 Clemens 1933-06-13
634117 634117 3993957343 Ericaceae Diplycosia memecyloides Stapf Penataran river       1933-06-21 barcode-01819968 J. Clemens & M. S. Clemens Clemens 35078 False 20 20 Clemens 35078 Clemens 1933-06-21

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