occ

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

7 rows where cluster_num_id = 50 sorted by recordNumber_mainNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
491462 491462 1991410796 Pteridaceae Coniogramme macrophylla (Blume) Hieron. B.N. Borneo. Mount Kinabalu. Dallas. 6.0333 116.4667   1931-11-23 3914583 J. Clemens Clemens 27727 True 50 50 Clemens 27727 Clemens 1931-11-23
246922 246922 3710722361 Pteridaceae Pteris amoena Blume Mount Kinabalu     3000.0 1931-12-01 1597369 J. Clemens & M.S. Clemens Clemens 27730 False 50 50 Clemens 27730 Clemens 1931-12-01
372866 372866 912374490 Pteridaceae Pteris amoena Blume Mt. Kinabalu, Dallas 6.033333 116.466667 1219.0 1931-12-01T00:00 K000446396 Clemens, J.; Clemens, M.S. Clemens 27730 True 50 50 Clemens 27730 Clemens 1931-12-01T00:00
491989 491989 2012801556 Pteridaceae Pteris purpureorachis Copel. Mount Kinabalu, B.N. Borneo. Dallas. 6.0333 116.4667   1931-12-01 03943264 J. Clemens Clemens 27730 True 50 50 Clemens 27730 Clemens 1931-12-01
585214 585214 1319406015 Pteridaceae Pteris purpureorachis Copel. Mount Kinabalu, B.N. Borneo, Kinabalu, Dallas-Tenompok spur Jungle ridge     1219.0 1931-12-01 US 1673156 J. Clemens & M. S. Clemens Clemens 27730 False 50 50 Clemens 27730 Clemens 1931-12-01
612267 612267 4033784338 Pteridaceae Pteris purpureorachis Copel. Dallas       1931-12-01 barcode-02529939 J. Clemens & M. S. Clemens Clemens 27730 False 50 50 Clemens 27730 Clemens 1931-12-01
633046 633046 4033781348 Pteridaceae Pteris purpureorachis Copel. Dallas       1931-12-01 barcode-02529938 J. Clemens & M. S. Clemens Clemens 27730 False 50 50 Clemens 27730 Clemens 1931-12-01

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