occ

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

3 rows where datasetkey = "339e9de5-ee9a-4718-8837-0bc5b4f933f5"

✎ 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
13659 13659 4999820683   PRESERVED_SPECIMEN UPCB00073455   0 0   0     UPCB 9392   0 1931-01-24 -14222.0 1931.0 1.0 24.0 1931-1-24       MY Siam: Bukit, Pattani       Pothos latifolius Hook.f. UPCB herbarium - Universidade Federal de Paraná - Herbário Virtual REFLORA 339e9de5-ee9a-4718-8837-0bc5b4f933f5     IDENTIFIED_DATE_INVALIDCONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYCOLLECTION_MATCH_FUZZY   jbrj-public.s3-sa-east-1.amazonaws.com/fsi/server?type=image&source=DZI/upcb/upcb/0/7/34/55/upcb00073455.dzi 0 False False ab06648f-c439-4400-95d8-679bb2cd9f6e 984ad7e0-f17d-4980-9d12-2c3c9509162e False       1 0 0 0 0 0 none    
13681 13681 4999824052   PRESERVED_SPECIMEN UPCB00071835   0 0 Hosttin, R.E. 1     UPCB 9466   0 1928-08-27 -15102.0 1928.0 8.0 27.0 1928-8-27       MY Tahan, Pahang.       Mapania humilis (Hassk. ex Steud.) Fern.-Vill. UPCB herbarium - Universidade Federal de Paraná - Herbário Virtual REFLORA 339e9de5-ee9a-4718-8837-0bc5b4f933f5     IDENTIFIED_DATE_INVALIDCONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYCOLLECTION_MATCH_FUZZY   jbrj-public.s3-sa-east-1.amazonaws.com/fsi/server?type=image&source=DZI/upcb/upcb/0/7/18/35/upcb00071835.dzi 0 False False ab06648f-c439-4400-95d8-679bb2cd9f6e 984ad7e0-f17d-4980-9d12-2c3c9509162e False   Hosttin   1 0 1 0 0 0 none    
13682 13682 5936454390   PRESERVED_SPECIMEN UPCB00069803 3066 1 0 Balajadia 1     UPCB 9424   0 1933-03-07 -13449.0 1933.0 3.0 7.0 1933-3-7       MY N. Borneo: Bum-Bum.       Flagellaria indica L. UPCB herbarium - Universidade Federal de Paraná - Herbário Virtual REFLORA 339e9de5-ee9a-4718-8837-0bc5b4f933f5     RECORDED_DATE_INVALIDIDENTIFIED_DATE_INVALIDCONTINENT_DERIVED_FROM_COUNTRYINSTITUTION_MATCH_FUZZYCOLLECTION_MATCH_FUZZY   jbrj-public.s3-sa-east-1.amazonaws.com/fsi/server?type=image&source=DZI/upcb/upcb/0/6/98/3/upcb00069803.dzi 0 False False ab06648f-c439-4400-95d8-679bb2cd9f6e 984ad7e0-f17d-4980-9d12-2c3c9509162e True 3066.0 Balajadia   1 1 1 8333.0 8333.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]);