Animals in AZA Institutions, a spreadsheet

TinoPup

Well-Known Member
5+ year member
I really like making spreadsheets, especially animal related ones. So over the last couple of weeks, I've put together one of all animals held by AZA zoos / aquariums / etc, based on their websites.

A few notes:
-It's broken down into a couple of sections (the tabs are at the bottom). The main spreadsheet is general zoos in the USA. The second tab is Aquariums and other institutions that are more specialized, like reptileland and butterfly pavilion. Third is all foreign locations, including Canada. 4th is places that are certified but not accredited, which generally means they're not regularly open to the public. At the end I've included my list of break-down for even-toed ungulates... I had to break them down into a few columns somehow, and I did it by orders for the most part, but I made that page to help me remember which go where.

-I've done my best to get everything off of websites! I looked not just at species lists but exhibit and area descriptions, adopt-an-animal options, anything that could give me names of what each zoo has. There is a column near the beginning that mentions whether I think it is a complete list or not. Ones with a "yes" are websites with PDFs, etc that specifically say they contain every held animal. On a few occasions I used wikipedia, but those are mentioned.

-I'm mostly a mammal person, and zoos tend to put more emphasis on their mammals on websites, so I've broken them down into more columns that others. I've learned a lot about bird species as I've gone along, but doing water birds (waterfowl, waders, penguins, etc) and everything else was the best way for me to break it down without having to look up every other species.

-For the most part, I went with what a website called each species. That means there are species that go by multiple names within, especially anything non-mammal and primates (my mammal weakness). The two main exceptions would be I always use mountain lion and african wild dog.

-A generic listing, ex. butterflies, is usually in lower case. I didn't start doing that until about halfway through, and I've fixed ones I've noticed while proofreading it, but I'm sure I've missed some.

-I'm sure there's typos I missed, sorry! Usually dumb ones. Some that look like typos are from websites, ex hamerkop vs hammerkop. I usually corrected ones that I knew were wrong on websites, ex Bangal for Bengal.

-Shedd Aquarium isn't on here because the website doesn't work, and hasn't for months.

I'd love to expand on this with zoochatters info! To keep it manageable, if you'd like to contribute, please try to send me stuff broken down into the columns I have, or at least in alphabetical order by mammals/birds/reptiles/amphibians/fish/etc. It'll better allow me to keep it flowing and save me time. Feel free to post in here or PM me.

I'm going to be away from home from May 3-20 so not sure how much I'll be able to update it then, but I'll try.

Here it is!

[EDIT - link removed]
 
Last edited by a moderator:
Are you kidding me? This is incredible! How long did it take, I know you have the dates on there but how many hours
 
Let's just say there's a lot of housework I need to do, LOL. Once I got started I wanted it done! I included the dates for future reference.
If it's a living thing and not a plant, it's on there, including corals, anemones, etc.
 
Is there a way to work in the reverse direction on this site? For example, search for all the zoos that have snow leopards
 
The way to do that would be to do a search of the document (ctrl+f on a pc) with whatever term you're looking for. I considered doing a second document like that, but there's just so many species, and when you factor in different names for the same thing and stuff like that, it becomes a little unmanageable for one person, I think. At least snow leopard is an easy search ;)
 
I've updated Zoo Atlanta (thanks to Dsimmons917!), found Shedd's other website and added the species from there, and fixed a few birds that I had in the wrong columns.
 
It's not usable as a PDF, unfortunately. There's 26 columns on the main page, most of them being rather wide, and 160 rows. A PDF also isn't able to be updated.
 
Last edited by a moderator:
wow, this is amazing and a major help to me. I always try to research zoos before a trip and this will save a lot of time. In addition, I've started seeking out certain species at zoos I still need to photograph and this will help with that as well.
 
You're welcome! I'll try to keep it updated in some fashion, but I might need reminders of changes - if you guys happen to hear of a new species at a zoo, or one leaving, drop me a note and I'll update it.

Absolutely brilliant! I'm not sure I would even have the patience to do this. Incredible work, hats off to your sir.:)

Madam ;) Tino is actually my dog.
 
I really like making spreadsheets, especially animal related ones. So over the last couple of weeks, I've put together one of all animals held by AZA zoos / aquariums / etc, based on their websites.

A few notes:
-It's broken down into a couple of sections (the tabs are at the bottom). The main spreadsheet is general zoos in the USA. The second tab is Aquariums and other institutions that are more specialized, like reptileland and butterfly pavilion. Third is all foreign locations, including Canada. 4th is places that are certified but not accredited, which generally means they're not regularly open to the public. At the end I've included my list of break-down for even-toed ungulates... I had to break them down into a few columns somehow, and I did it by orders for the most part, but I made that page to help me remember which go where.

-I've done my best to get everything off of websites! I looked not just at species lists but exhibit and area descriptions, adopt-an-animal options, anything that could give me names of what each zoo has. There is a column near the beginning that mentions whether I think it is a complete list or not. Ones with a "yes" are websites with PDFs, etc that specifically say they contain every held animal. On a few occasions I used wikipedia, but those are mentioned.

-I'm mostly a mammal person, and zoos tend to put more emphasis on their mammals on websites, so I've broken them down into more columns that others. I've learned a lot about bird species as I've gone along, but doing water birds (waterfowl, waders, penguins, etc) and everything else was the best way for me to break it down without having to look up every other species.

-For the most part, I went with what a website called each species. That means there are species that go by multiple names within, especially anything non-mammal and primates (my mammal weakness). The two main exceptions would be I always use mountain lion and african wild dog.

-A generic listing, ex. butterflies, is usually in lower case. I didn't start doing that until about halfway through, and I've fixed ones I've noticed while proofreading it, but I'm sure I've missed some.

-I'm sure there's typos I missed, sorry! Usually dumb ones. Some that look like typos are from websites, ex hamerkop vs hammerkop. I usually corrected ones that I knew were wrong on websites, ex Bangal for Bengal.

-Shedd Aquarium isn't on here because the website doesn't work, and hasn't for months.

I'd love to expand on this with zoochatters info! To keep it manageable, if you'd like to contribute, please try to send me stuff broken down into the columns I have, or at least in alphabetical order by mammals/birds/reptiles/amphibians/fish/etc. It'll better allow me to keep it flowing and save me time. Feel free to post in here or PM me.

I'm going to be away from home from May 3-20 so not sure how much I'll be able to update it then, but I'll try.

Here it is!
AZA Zoo Species.xlsx
So are the ungulates listed on the fifth tab all the ungulates housed in AZA facilities?
 
Very impressive achievement! I didn't know about this thread. It's the closest thing to American ZTL I have ever seen. Respect!
 
I really like making spreadsheets, especially animal related ones. So over the last couple of weeks, I've put together one of all animals held by AZA zoos / aquariums / etc, based on their websites.

A few notes:
-It's broken down into a couple of sections (the tabs are at the bottom). The main spreadsheet is general zoos in the USA. The second tab is Aquariums and other institutions that are more specialized, like reptileland and butterfly pavilion. Third is all foreign locations, including Canada. 4th is places that are certified but not accredited, which generally means they're not regularly open to the public. At the end I've included my list of break-down for even-toed ungulates... I had to break them down into a few columns somehow, and I did it by orders for the most part, but I made that page to help me remember which go where.

-I've done my best to get everything off of websites! I looked not just at species lists but exhibit and area descriptions, adopt-an-animal options, anything that could give me names of what each zoo has. There is a column near the beginning that mentions whether I think it is a complete list or not. Ones with a "yes" are websites with PDFs, etc that specifically say they contain every held animal. On a few occasions I used wikipedia, but those are mentioned.

-I'm mostly a mammal person, and zoos tend to put more emphasis on their mammals on websites, so I've broken them down into more columns that others. I've learned a lot about bird species as I've gone along, but doing water birds (waterfowl, waders, penguins, etc) and everything else was the best way for me to break it down without having to look up every other species.

-For the most part, I went with what a website called each species. That means there are species that go by multiple names within, especially anything non-mammal and primates (my mammal weakness). The two main exceptions would be I always use mountain lion and african wild dog.

-A generic listing, ex. butterflies, is usually in lower case. I didn't start doing that until about halfway through, and I've fixed ones I've noticed while proofreading it, but I'm sure I've missed some.

-I'm sure there's typos I missed, sorry! Usually dumb ones. Some that look like typos are from websites, ex hamerkop vs hammerkop. I usually corrected ones that I knew were wrong on websites, ex Bangal for Bengal.

-Shedd Aquarium isn't on here because the website doesn't work, and hasn't for months.

I'd love to expand on this with zoochatters info! To keep it manageable, if you'd like to contribute, please try to send me stuff broken down into the columns I have, or at least in alphabetical order by mammals/birds/reptiles/amphibians/fish/etc. It'll better allow me to keep it flowing and save me time. Feel free to post in here or PM me.

I'm going to be away from home from May 3-20 so not sure how much I'll be able to update it then, but I'll try.

Here it is!
AZA Zoo Species.xlsx
Amazing work and a much needed spreadsheet! Hats off to you!
 
Back
Top