label VARCHAR(100) NOT NULL, 

    label VARCHAR(100) UNIQUE NOT NULL, -- UNIQUE not implemented directly as duckdb wont allow alter table, see unique index

-- delete this next time you do an export-reimport, changed schema above but duckdb will not allow an alter table
CREATE UNIQUE INDEX idx_species_label_unique ON species(label);