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 |