occ

cluster_num_id

{'link': '/cluster/{value}'}

gbifID

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

1 row where datasetkey = "55a29b7c-9cb3-4721-b1e3-40561c955e21"

✎ View and edit SQL

This data as json, CSV (advanced)

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