occ

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

15 rows where cluster_num_id = 40 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
246858 246858 1989051463 Euphorbiaceae Hancea penangensis (Müll.Arg.) S.E.C.Sierra, Kulju & Welzen Penibukan; Upper Kinabalu     4000.0 1933-09-14 1114984 J. Clemens & M.S. Clemens Clemens 40103 False 40 40 Clemens 40103 Clemens 1933-09-14
496609 496609 1930763364 Araceae Anadendrum Schott Mount Kinabalu, B. N. Borneo. Upper Kinabalu       1933-09-17 03774165 J. Clemens Clemens 40104 False 40 40 Clemens 40104 Clemens 1933-09-17
550557 550557 1056665764 Araceae Homalomena gillii Furtado   5.377939 117.087456   1933-09-13 BM000571570 J. Clemens & M.S. Clemens Clemens 40104 True 40 40 Clemens 40104 Clemens 1933-09-13
568664 568664 1057245724 Araceae Anadendrum microstachyum (de Vriese & Miq.) Backer & Alderw.   5.377939 117.087456 1219.0 1933-09-17 BM000957233 J. Clemens & M.S. Clemens Clemens 40104 True 40 40 Clemens 40104 Clemens 1933-09-17
245113 245113 5900717359 Vitaceae Pterisanthes polita (Miq.) Planch. Plants of Mount Kinabalu B. N. Borneo; Upper Kinabalu     1219.2 1933-09-17 1767978 J. Clemens & M. S. Clemens Clemens 40105 False 40 40 Clemens 40105 Clemens 1933-09-17
493640 493640 3991086835 Loranthaceae Helixanthera maxwelliana (Gibbs) Danser B. N. Borneo Mount Kinabalu Penibukan, jungle ridge Upper Kinabalu       1933-09-17 04391460 J. Clemens Clemens 40105 False 40 40 Clemens 40105 Clemens 1933-09-17
571577 571577 1057123043 Vitaceae Pterisanthes polita (Miq.) M.A.Lawson Mount Kinabalu 6.072693 116.561508   1933-09-17 BM000896415 J. Clemens & M.S. Clemens Clemens 40105 True 40 40 Clemens 40105 Clemens 1933-09-17
387897 387897 912628084 Apocynaceae Willughbeia lanceolata (Markgr.) D.J.Middleton Penibukan ridge, forest hill.; Upper Kinabalu     2667.005 1933-09-17T00:00 K000832870 Clemens, J.; Clemens, M.S. Clemens 40106 False 40 40 Clemens 40106 Clemens 1933-09-17T00:00
490161 490161 1928984529 Apocynaceae Urnularia lanceolata Markgr. Penibukan Ridge, Mt. Kinabalu       1933-09-17 318433 J. Clemens Clemens 40106 False 40 40 Clemens 40106 Clemens 1933-09-17
512761 512761 1144801049 Apocynaceae Willughbeia lanceolata (Markgr.) Mabb.   6.066667 116.55 1300.0 1933-09-17 G00190773 Clemens, J. & M. S. Clemens Clemens 40106 True 40 40 Clemens 40106 Clemens 1933-09-17
568399 568399 1056266909 Apocynaceae Willughbeia lanceolata (Markgr.) D.J.Middleton   5.377939 117.087456   1933-09-17 BM000838598 J. Clemens & M.S. Clemens Clemens 40106 True 40 40 Clemens 40106 Clemens 1933-09-17
662749 662749 1998348735 Apocynaceae Urnularia lanceolata Markgr. Upper Mount Kinabalu, Penibukan ridge, 4000 feet       1933-09-17 barcode-00067384 J. Clemens & M. S. Clemens Clemens 40106 False 40 40 Clemens 40106 Clemens 1933-09-17
244454 244454 5886547870 Phyllanthaceae Aporosa hosei Merr. Penibukan, Jungle     1219.2 1933-09-17 1762589 J. Clemens & M. S. Clemens Clemens 40107 False 40 40 Clemens 40107 Clemens 1933-09-17
314760 314760 4954067061 Phyllanthaceae Aporosa falcifera Hook.f. Mt Kinabalu. Penibukan ridge.       1933-09-17T00:00 K004834913 Clemens, J.; Clemens, M.S. Clemens 40107 False 40 40 Clemens 40107 Clemens 1933-09-17T00:00
614579 614579 4981856773 Phyllanthaceae Aporosa falcifera Hook.f. Penibukan; Upper Kinabalu       1933-09-17 barcode-02487431 J. Clemens & M. S. Clemens Clemens 40107 False 40 40 Clemens 40107 Clemens 1933-09-17

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