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% Pennsylvania%'
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% Pennsylvania%' order by spcode, comname, rating DESC LIMIT 100
511 Images found.
|
Tiktaalik Tiktaalik roseae |
d02/3/015 Tiktaalik | d02/3/016 Tiktaalik | f25/1/001 Tiktaalik | x02/1/001 Tiktaalik |
|
Human Homo sapiens |
s39/1/045 Human | s39/1/046 Human | s39/1/047 Human | w02/53/239 Human |
w02/50/005 Human | m17/37/001 Human | w02/43/042 Human | r16/5/001 Human |
b52/3/065 Human | b52/3/066 Human | b52/3/067 Human | b52/3/068 Human |
w02/50/056 Human |
Red-throated Loon Gavia stellata |
m55/2/044 Red-throated Loon | w02/37/001 Red-throated Loon |
Yellow-billed Loon Gavia adamsii |
b52/4/012 Yellow-billed Loon | b52/4/011 Yellow-billed Loon |
Horned Grebe Podiceps auritus |
m55/2/014 Horned Grebe |
Brown Pelican Pelecanus occidentalis |
w02/37/002 Brown Pelican |
Least Bittern Ixobrychus exilis |
m55/3/008 Least Bittern | m55/3/009 Least Bittern |
Cattle Egret Bubulcus ibis |
m55/3/024 Cattle Egret |
Snowy Egret Egretta thula |
w02/37/003 Snowy Egret |
Great Blue Heron Ardea herodias |
w02/37/004 Great Blue Heron |
Wood Stork Mycteria americana |
w02/37/005 Wood Stork |
White Ibis Eudocimus albus |
w02/37/006 White Ibis |
Tundra Swan Cygnus columbianus |
b52/3/171 Tundra Swan | b52/3/172 Tundra Swan | b52/3/173 Tundra Swan | b52/3/174 Tundra Swan |
b52/3/175 Tundra Swan | b52/3/176 Tundra Swan |
Snow Goose Chen caerulescens |
v01/6/209 Snow Goose | v01/6/210 Snow Goose |
Ross's Goose Chen rossii |
v01/6/211 Ross's Goose | v01/6/212 Ross's Goose |
Canada Goose Branta canadensis |
v01/6/029 Canada Goose | v01/6/030 Canada Goose | w02/37/007 Canada Goose |
White-winged Duck Cairina scutulata |
h02/4/038 White-winged Duck |
Wood Duck Aix sponsa |
m55/3/022 Wood Duck | v01/6/005 Wood Duck | v01/6/006 Wood Duck | v01/6/009 Wood Duck |
v01/6/010 Wood Duck | v01/6/011 Wood Duck | v01/6/012 Wood Duck |
Mallard Anas platyrhynchos |
w02/37/008 Mallard |
American Black Duck Anas rubripes |
v01/6/017 American Black Duck | v01/6/018 American Black Duck | v01/6/019 American Black Duck | v01/6/020 American Black Duck |
h21/10/017 American Black Duck |
Northern Pintail Anas acuta |
v01/6/319 Northern Pintail | v01/6/320 Northern Pintail |
Hybrid Cinnamon x Blue-winged Teal Anas discors x cyanoptera |
m55/2/035 Hybrid Cinnamon x Blue-winged Teal | m55/2/036 Hybrid Cinnamon x Blue-winged Teal |
Blue-winged Teal Anas discors |
m55/3/123 Blue-winged Teal | m55/3/124 Blue-winged Teal |
Canvasback Aythya valisineria |
m55/3/013 Canvasback |
Redhead Aythya americana |
v01/6/423 Redhead | v01/6/424 Redhead | w02/37/009 Redhead |
Greater Scaup Aythya marila |
v01/6/027 Greater Scaup | v01/6/028 Greater Scaup |
Lesser Scaup Aythya affinis |
v01/6/025 Lesser Scaup | v01/6/026 Lesser Scaup | v01/6/317 Lesser Scaup | v01/6/318 Lesser Scaup |
|
King Eider Somateria spectabilis |
h02/3/013 King Eider |
Labrador Duck Camptorhynchus labradorius |
h21/99/077 Labrador Duck | h21/99/078 Labrador Duck | h21/99/079 Labrador Duck | l01/8/022 Labrador Duck |
l01/8/023 Labrador Duck |
Long-tailed Duck Clangula hyemalis |
v01/6/303 Long-tailed Duck | v01/6/304 Long-tailed Duck | m55/1/001 Long-tailed Duck |
Black Scoter Melanitta nigra |
m55/3/105 Black Scoter |
Bufflehead Bucephala albeola |
v01/6/031 Bufflehead | v01/6/032 Bufflehead | v01/6/033 Bufflehead | v01/6/034 Bufflehead |
v01/6/035 Bufflehead | v01/6/036 Bufflehead | v01/6/037 Bufflehead | v01/6/038 Bufflehead |
|
Hooded Merganser Lophodytes cucullatus |
l07/55/088 Hooded Merganser |
Red-breasted Merganser Mergus serrator |
m55/3/083 Red-breasted Merganser | m55/2/045 Red-breasted Merganser |
Common Merganser Mergus merganser |
m55/3/082 Common Merganser | b52/3/026 Common Merganser |
Ruddy Duck Oxyura jamaicensis |
v01/6/049 Ruddy Duck | v01/6/050 Ruddy Duck |
Bald Eagle Haliaeetus leucocephalus |
r32/1/025 Bald Eagle |
Northern Harrier Circus cyaneus |
m55/3/071 Northern Harrier |