occ

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

3 rows where datasetkey = "3b8e9d83-b2d4-4a97-973c-31d98b67b1e9"

✎ 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
600756 600756 4974613238   PRESERVED_SPECIMEN 367256 AFO028 1 0 Farid, A.; Salam, R. 1         0 2004-05-22 12560.0 2004.0 5.0 22.0         MY Terengganu       Bruguiera cylindrica (L.) Blume MBM - Herbário do Museu Botânico Municipal 3b8e9d83-b2d4-4a97-973c-31d98b67b1e9     CONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYCOLLECTION_MATCH_FUZZY   https://images.cria.org.br/viewer/MBM367256 0 False False b745abcd-45b2-4a84-a327-9298e795dbfb d3b42067-b567-4d47-a136-bb5d52ed32fc True 28.0 Farid ['Salam'] 1 1 1 0 0 0 none    
641740 641740 1095546294   PRESERVED_SPECIMEN 209125 6342 1 0 Panero, JL 1         0                   MY         Haloragis micrantha (Thunb.) R.Br. ex Siebold & Zucc. MBM - Herbário do Museu Botânico Municipal 3b8e9d83-b2d4-4a97-973c-31d98b67b1e9     RECORDED_DATE_MISMATCHRECORDED_DATE_INVALIDCONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYCOLLECTION_MATCH_FUZZY   https://images.cria.org.br/viewer/MBM209125 0 False False b745abcd-45b2-4a84-a327-9298e795dbfb d3b42067-b567-4d47-a136-bb5d52ed32fc False 6342.0 Panero   0 1 1 0 0 0 none    
641741 641741 1095546333   PRESERVED_SPECIMEN 209129 6282 1 0 Panero, JL; et al. 1         0 1996-05-08 9624.0 1996.0 5.0 8.0         MY         Chloranthus erectus (Buch.-Ham.) Sweet MBM - Herbário do Museu Botânico Municipal 3b8e9d83-b2d4-4a97-973c-31d98b67b1e9     CONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYCOLLECTION_MATCH_FUZZY   https://images.cria.org.br/viewer/MBM209129 0 False False b745abcd-45b2-4a84-a327-9298e795dbfb d3b42067-b567-4d47-a136-bb5d52ed32fc True 6282.0 Panero   1 1 1 9854.0 9854.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]);