occ

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

6 rows where datasetkey = "3111dc38-3143-4792-9802-610f1de4961c"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ gbifid institutionid basisofrecord catalognumber recordnumber recordnumber_contains_numerals recordnumber_contains_year recordedby recordedby_has_personal_name recordedbyid georeferenceverificationstatus othercatalognumbers fieldnumber fieldnumber_contains_numerals eventdate eventdate_day_offset year month day verbatimeventdate habitat fieldnotes eventremarks countrycode locality verbatimlocality decimallatitude decimallongitude scientificname datasetkey elevation elevationaccuracy nontaxonomicissue mediatype v_associatedmedia hascoordinate hasgeospatialissues issequenced institutionkey collectionkey isincluster recordnumber_mainnumber recordedby_first_familyname recordedby_team_familynames eventdate_eligible recordnumber_eligible recordedby_eligible cluster_stage1_id coordinate_source_specimen_metadata coordinate_source_collecting_event coordinate_source_collector_day coordinate_source Subject bionomia_profile_id
1137 1137 4102339957   PRESERVED_SPECIMEN BRIT500829 s.n. 0 0 DeKalb Russell, Jr. 1         0 1983-11-19 5070.0 1983.0 11.0 19.0   near river on road     MY Near river on road to Bunuk, kuching area of Sarawak, Malaysia.       Lycopodium cernuum L. Vanderbilt University Herbarium 3111dc38-3143-4792-9802-610f1de4961c     CONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYINSTITUTION_COLLECTION_MISMATCH StillImage   0 False False a68aaf8c-9bfe-4bec-bab9-70cf5d6cde4a   False   Russell   1 0 1 0 0 0 none    
1138 1138 4102474409   PRESERVED_SPECIMEN BRIT471561 8681 1 0 B. L. Stone 1     VDB 152808   0 1969-01-08 -358.0 1969.0 1.0 8.0   Mangrove swamp.     MY Malaya, Johone: Jahone Bahru.       Acrostichum speciosum Willd. Vanderbilt University Herbarium 3111dc38-3143-4792-9802-610f1de4961c     CONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYINSTITUTION_COLLECTION_MISMATCH StillImage   0 False False a68aaf8c-9bfe-4bec-bab9-70cf5d6cde4a   True 8681.0 Stone   1 1 1 356.0 356.0 0 0 0 none    
1139 1139 4102041381   PRESERVED_SPECIMEN BRIT637259 43986 1 0 F.R. Fosberg 1         0 1963-07-17 -2360.0 1963.0 7.0 17.0   In ridge-crest phase of cloud-forest, low trees draped with epiphytes.     MY Mt Kinabalu, Ridge above Kamburongoh       Embelia Burm.f. Vanderbilt University Herbarium 3111dc38-3143-4792-9802-610f1de4961c 2200.0 100.0 CONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYINSTITUTION_COLLECTION_MISMATCH StillImage   0 False False a68aaf8c-9bfe-4bec-bab9-70cf5d6cde4a   False 43986.0 Fosberg   1 1 1 8237.0 8237.0 0 0 0 none    
1140 1140 5139347930   PRESERVED_SPECIMEN BRIT594538 12105 1 0 E.C. Abbe 1         0 1964-07-24 -1987.0 1964.0 7.0 24.0         MY         Quercus gemelliflora Blume Vanderbilt University Herbarium 3111dc38-3143-4792-9802-610f1de4961c     CONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYINSTITUTION_COLLECTION_MISMATCH StillImage   0 False False a68aaf8c-9bfe-4bec-bab9-70cf5d6cde4a   True 12105.0 Abbe   1 1 1 5946.0 5946.0 0 0 0 none    
1169 1169 4102060423   PRESERVED_SPECIMEN BRIT645805 44073 1 0 F. R. Fosberg 1         0 1963-07-18 -2359.0 1963.0 7.0 18.0   S. slope; ravine; in rock crevices on steep rock slope with local low scrub.     MY Sabah (formerly British North Borneo); Mt. Kinabalu, s. slope; ravine above Paka Cave.       Carex capillacea Boott Vanderbilt University Herbarium 3111dc38-3143-4792-9802-610f1de4961c 3125.0 75.0 CONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYINSTITUTION_COLLECTION_MISMATCH StillImage   0 False False a68aaf8c-9bfe-4bec-bab9-70cf5d6cde4a   False 44073.0 Fosberg   1 1 1 8237.0 8237.0 0 0 0 none    
1170 1170 5139347097   PRESERVED_SPECIMEN BRIT585673 44050 1 0 F.R. Fosberg 1         0 1963-07-18 -2359.0 1963.0 7.0 18.0         MY         Ilex havilandii Loes. Vanderbilt University Herbarium 3111dc38-3143-4792-9802-610f1de4961c     CONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYINSTITUTION_COLLECTION_MISMATCH StillImage   0 False False a68aaf8c-9bfe-4bec-bab9-70cf5d6cde4a   False 44050.0 Fosberg   1 1 1 8237.0 8237.0 0 0 0 none    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "occ" (
   [gbifid] INTEGER,
   [institutionid] TEXT,
   [basisofrecord] TEXT,
   [catalognumber] TEXT,
   [recordnumber] TEXT,
   [recordnumber_contains_numerals] INTEGER,
   [recordnumber_contains_year] INTEGER,
   [recordedby] TEXT,
   [recordedby_has_personal_name] INTEGER,
   [recordedbyid] TEXT,
   [georeferenceverificationstatus] TEXT,
   [othercatalognumbers] TEXT,
   [fieldnumber] TEXT,
   [fieldnumber_contains_numerals] INTEGER,
   [eventdate] TEXT,
   [eventdate_day_offset] FLOAT,
   [year] FLOAT,
   [month] FLOAT,
   [day] FLOAT,
   [verbatimeventdate] TEXT,
   [habitat] TEXT,
   [fieldnotes] TEXT,
   [eventremarks] TEXT,
   [countrycode] TEXT,
   [locality] TEXT,
   [verbatimlocality] TEXT,
   [decimallatitude] TEXT,
   [decimallongitude] TEXT,
   [scientificname] TEXT,
   [datasetkey] TEXT REFERENCES [dataset]([datasetkey]),
   [elevation] TEXT,
   [elevationaccuracy] FLOAT,
   [nontaxonomicissue] TEXT,
   [mediatype] TEXT,
   [v_associatedmedia] TEXT,
   [hascoordinate] INTEGER,
   [hasgeospatialissues] TEXT,
   [issequenced] TEXT,
   [institutionkey] TEXT,
   [collectionkey] TEXT,
   [isincluster] TEXT,
   [recordnumber_mainnumber] FLOAT,
   [recordedby_first_familyname] TEXT,
   [recordedby_team_familynames] TEXT,
   [eventdate_eligible] INTEGER,
   [recordnumber_eligible] INTEGER,
   [recordedby_eligible] INTEGER,
   [cluster_stage1_id] FLOAT REFERENCES [cluster]([cluster_stage1_id]),
   [coordinate_source_specimen_metadata] INTEGER,
   [coordinate_source_collecting_event] INTEGER,
   [coordinate_source_collector_day] INTEGER,
   [coordinate_source] TEXT,
   [Subject] FLOAT,
   [bionomia_profile_id] TEXT
);
CREATE INDEX [idx_occ_cluster_stage1_id]
    ON [occ] ([cluster_stage1_id]);