select webflatfileid, comname, sciname, webflatfile.vcode, rating, Day, height, width, spcode, photodata, country_state, locality, age, sex, month, dname, comments from webflatfile left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND country_state LIKE '%USA% Missouri%'
select webflatfileid, comname, sciname, webflatfile.vcode, rating, Day, height, width, spcode, photodata, country_state, locality, age, sex, month, dname, comments from webflatfile left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND country_state LIKE '%USA% Missouri%' order by spcode, comname, rating DESC LIMIT 100
81 Images found.
|
American White Pelican Pelecanus erythrorhynchos |
 b62/1/002 American White Pelican |  b62/1/003 American White Pelican |  b62/1/004 American White Pelican |  b62/1/005 American White Pelican |
|
Black-crowned Night-Heron Nycticorax nycticorax |
 b62/1/008 Black-crowned Night-Heron |
Yellow-crowned Night-Heron Nyctanassa violacea |
 b62/1/047 Yellow-crowned Night-Heron |  b62/1/048 Yellow-crowned Night-Heron |
Little Blue Heron Egretta caerulea |
 b62/1/032 Little Blue Heron |
Snow Goose Chen caerulescens |
 m17/42/164 Snow Goose |  m17/42/163 Snow Goose |
Canada Goose Branta canadensis |
 b62/1/023 Canada Goose |  b62/1/024 Canada Goose |  b62/1/025 Canada Goose |
Wood Duck Aix sponsa |
 b62/1/044 Wood Duck |  b62/1/045 Wood Duck |  b62/1/046 Wood Duck |
Mallard Anas platyrhynchos |
 b62/1/033 Mallard |
Northern Pintail Anas acuta |
 b62/1/034 Northern Pintail |  b62/1/035 Northern Pintail |  b62/1/036 Northern Pintail |  b62/1/037 Northern Pintail |
|
Bufflehead Bucephala albeola |
 b62/1/010 Bufflehead |
Hooded Merganser Lophodytes cucullatus |
 b62/1/027 Hooded Merganser |  b62/1/028 Hooded Merganser |  m17/64/006 Hooded Merganser |  m17/42/191 Hooded Merganser |
|
Red-breasted Merganser Mergus serrator |
 b62/1/039 Red-breasted Merganser |
Common Merganser Mergus merganser |
 b62/1/013 Common Merganser |  b62/1/014 Common Merganser |  b62/1/015 Common Merganser |
Trumpeter Swan Cygnus buccinator |
 b62/1/041 Trumpeter Swan |  b62/1/042 Trumpeter Swan |
Bald Eagle Haliaeetus leucocephalus |
 w13/9/003 Bald Eagle |  b62/1/006 Bald Eagle |  d18/9/002 Bald Eagle |
Red-tailed Hawk Buteo jamaicensis |
 w13/6/005 Red-tailed Hawk |
Turkey Vulture Cathartes aura |
 b62/1/029 Turkey Vulture |  b62/1/030 Turkey Vulture |
Wild Turkey Meleagris gallopavo |
 b62/1/021 Wild Turkey |  b62/1/022 Wild Turkey |
Indian Peafowl Pavo cristatus |
|
Barred Owl Strix varia |
 b62/1/007 Barred Owl |
Downy Woodpecker Picoides pubescens |
 b62/1/001 Downy Woodpecker |  d01/34/610 Downy Woodpecker |
Pileated Woodpecker Dryocopus pileatus |
 b62/1/038 Pileated Woodpecker |
Cedar Waxwing Bombycilla cedrorum |
 b62/1/011 Cedar Waxwing |  b62/1/012 Cedar Waxwing |
American Crow Corvus brachyrhynchos |
 w04/3/073 American Crow |  w04/3/074 American Crow |
Henslow's Sparrow Ammodramus henslowii |
 b13/37/176 Henslow's Sparrow |  b13/37/175 Henslow's Sparrow |  b13/15/096 Henslow's Sparrow |  b13/15/097 Henslow's Sparrow |
 b13/15/099 Henslow's Sparrow |  b13/15/100 Henslow's Sparrow |
Dickcissel Spiza americana |
 b13/51/017 Dickcissel |  b62/1/017 Dickcissel |  b62/1/018 Dickcissel |  b13/51/018 Dickcissel |
|
Indigo Bunting Passerina cyanea |
 b13/39/271 Indigo Bunting |  b13/39/272 Indigo Bunting |  b13/39/273 Indigo Bunting |  b62/1/031 Indigo Bunting |
|
Blackbird sp. Icterid sp. |
 m17/42/300 Blackbird sp. |  m17/42/302 Blackbird sp. |
Red-winged Blackbird Agelaius phoeniceus |
 b13/45/153 Red-winged Blackbird |  b13/44/063 Red-winged Blackbird |
Common Grackle Quiscalus quiscula |
 b13/38/214 Common Grackle |  b13/38/215 Common Grackle |  b13/38/216 Common Grackle |  b13/38/217 Common Grackle |
|
Yellow-rumped Warbler Setophaga coronata |
 b62/1/049 Yellow-rumped Warbler |
Louisiana Waterthrush Seiurus motacilla |
 c22/25/004 Louisiana Waterthrush |  c22/24/014 Louisiana Waterthrush |
Common Yellowthroat Geothlypis trichas |
 b13/39/213 Common Yellowthroat |  b62/1/016 Common Yellowthroat |
Eurasian Tree Sparrow Passer montanus |
 m51/1/002 Eurasian Tree Sparrow |
Eastern Bluebird Sialia sialis |
 b62/1/019 Eastern Bluebird |
White-eyed Vireo Vireo griseus |
 b13/51/020 White-eyed Vireo |
Bell's Vireo Vireo bellii |
 b13/51/016 Bell's Vireo |  b13/51/019 Bell's Vireo |