[Nhcoll-l] Entomology taxonomy for database

[Deborah Paul]

Hi Rod,

Glad to hear you have a paleoentomologist with you. You can get names 
and taxonomy you need from Catalogue of Life via their exporter.

1. You will need a GBIF account (do you have one? they are instant to 
get) to Login.
2. Log in to Checklist Bank (where COL datasets live, to search and 
download). https://www.checklistbank.org/
3. Go to "Datasets" and find the most recent "Annual Release"
(this one: https://www.checklistbank.org/dataset/310463/about)

4. Click on Downloads to generate a download: (see options to pick below);


5. You will get more that you want / need (i. e. classification above 
Family level). You can of course delete the columns you are not 
interested in.

Please holler if you have questions. The COL team will help. I pinged my 
colleague Geoff Ower, one of the COL Developers to be sure I've pointed 
you in a useful direction.

Best,
Debbie


On 12/12/2025 12:10 PM, Pellegrini, Rodrigo [DOS] wrote:
> Greetings everyone,
>
> We are currently making an effort to catalog our entomology collection at the NJSM, ...
> A paleoentomologist recently joined our ranks, and has been identifying, re-identifying and assigning catalog numbers to our old (recent) insects, and the time to import them into our database, EMU, is nigh.
> Needless to say, our taxonomy tables in the database lack insect taxonomy. ... I'm wondering if anybody here would be kind enough to share their entomology taxonomy tables as a CSV file, for me to import them into our database. We are hoping to get a file that includes up to the Family level, and we could create the genus species for the species represented in our collections.
>
> ... if your database (whatever it may be) can produce a comma-separated-file with understandable headers for the hierarchy (or a key of what the backend name headers correspond to in the hierarchy), I can make it work.
>
> It would save us a ton of time, and we would very much appreciate it. Please let me know directly atRodrigo.Pellegrini at sos.nj.gov if you can help us out.
> Thank you very much for your time,
>
> Rod
>
>

-- 
- Deborah Paul, Biodiversity Informatics Community Liaison
- Species File Group (INHS), University of Illinois
-- Natural History Collections and Museomics NHCM Editor-in-Chiefhttps://nhcm.pensoft.net
-- Biodiversity Information Standards (TDWG) Past Chair 2021-2022
-- Florida State University Courtesy Appointment
-- Species File Group and Eventshttps://speciesfilegroup.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.yale.edu/pipermail/nhcoll-l/attachments/20251212/8b858508/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: yWQQED1XSt8U0LdQ.png
Type: image/png
Size: 141967 bytes
Desc: not available
URL: <http://mailman.yale.edu/pipermail/nhcoll-l/attachments/20251212/8b858508/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: QEBpqkhcyI6ZhcOk.png
Type: image/png
Size: 65239 bytes
Desc: not available
URL: <http://mailman.yale.edu/pipermail/nhcoll-l/attachments/20251212/8b858508/attachment-0001.png>