https://forum.inaturalist.org/t/using-sql-to-query-inats-dwca-taxonomy-export/29377/17 but also taxon history is added since this forum post…
I should try this but I hope for you there is an easier solution…
SELECT A.scientificName, A.taxonID
FROM taxa A
LEFT JOIN vnames B
ON A.id = B.id
WHERE contributer=‘jeremygilmore’