QUERY: SELECT * FROM amphib WHERE state_code like "%CO%" order by ordr, family, subfamily, genus, species

Number of matches: 18

FROGS only (17)         SALAMANDERS only (1)        

Scientific Name	Photo	Sound	IUCN Red List Status	Vernacular Name	Family	Order
Anaxyrus boreas	photos	sounds	Least Concern (LC)	Western Toad	Bufonidae	Anura
Anaxyrus cognatus	photos	sounds	Least Concern (LC)	Great Plains Toad	Bufonidae	Anura
Anaxyrus debilis	photos	sounds	Least Concern (LC)	Green Toad	Bufonidae	Anura
Anaxyrus punctatus	photos	sounds	Least Concern (LC)	Red-Spotted Toad	Bufonidae	Anura
Anaxyrus woodhousii	photos	sounds	Least Concern (LC)	Woodhouse's Toad	Bufonidae	Anura
Acris blanchardi	photos	sounds		Blanchard's Cricket Frog	Hylidae	Anura
Hyla arenicolor	photos	sounds	Least Concern (LC)	Canyon Treefrog	Hylidae	Anura
Pseudacris maculata	photos		Least Concern (LC)	Boreal Chorus Frog	Hylidae	Anura
Gastrophryne olivacea	photos	sounds	Least Concern (LC)	Great Plains Narrow-mouthed Toad	Microhylidae	Anura
Rana blairi	photos		Least Concern (LC)	Plains Leopard Frog	Ranidae	Anura
Rana catesbeiana	photos	sounds	Least Concern (LC)	American Bullfrog	Ranidae	Anura
Rana pipiens	photos		Least Concern (LC)	Northern Leopard Frog	Ranidae	Anura
Rana sylvatica	photos		Least Concern (LC)	Wood Frog	Ranidae	Anura
Scaphiopus couchii	photos	sounds	Least Concern (LC)	Couch's Spadefoot	Scaphiopodidae	Anura
Spea bombifrons	photos		Least Concern (LC)	Plains Spadefoot Toad	Scaphiopodidae	Anura
Spea intermontana	photos	sounds	Least Concern (LC)	Great Basin Spadefoot	Scaphiopodidae	Anura
Spea multiplicata	photos	sounds	Least Concern (LC)	Mexican Spadefoot	Scaphiopodidae	Anura
Ambystoma mavortium	photos		Least Concern (LC)	Barred Tiger Salamander	Ambystomatidae	Caudata