Looks like a RL CSV export

gistfile1.txt

create table redlist_csv_export (species_id int,kingdom text,phylum text, class text, "order" text, family text, genus text, species text, authority text, infrarank text, infraname text, infraauth text, stock text, synonyms text, common_en text, common_fr text, common_sp text, redlist_status text, redlist_criteria text, redlist_criteria_version text, year text, trend text, petitioned text);

And then:
\encoding latin-1
\copy redlist_csv_export from 'Downloads/export-whatever.csv' with csv;