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 |