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% New% Hampshire%'
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% New% Hampshire%' order by spcode, comname, rating DESC LIMIT 100
406 Images found.
|
Common Loon Gavia immer |
 f11/3/003 Common Loon |  r10/22/021 Common Loon |  r10/22/022 Common Loon |  f11/4/001 Common Loon |
|
Red-necked Grebe Podiceps grisegena |
 m50/1/300 Red-necked Grebe |
Wood Duck Aix sponsa |
 m50/1/367 Wood Duck |  m50/1/384 Wood Duck |
American Black Duck Anas rubripes |
 m50/1/001 American Black Duck |
Barrow's Goldeneye Bucephala islandica |
 m50/1/011 Barrow's Goldeneye |
Hooded Merganser Lophodytes cucullatus |
 m50/1/189 Hooded Merganser |  m50/1/191 Hooded Merganser |  m50/1/192 Hooded Merganser |  m50/1/187 Hooded Merganser |
 m50/1/188 Hooded Merganser |  m50/1/190 Hooded Merganser |  f11/4/016 Hooded Merganser |
Common Merganser Mergus merganser |
 m50/1/091 Common Merganser |  m50/1/092 Common Merganser |  m50/1/094 Common Merganser |  m50/1/095 Common Merganser |
 m50/1/096 Common Merganser |  m50/1/097 Common Merganser |  m50/1/098 Common Merganser |  m50/1/090 Common Merganser |
 m50/1/093 Common Merganser |  l05/2/023 Common Merganser |
Spruce Grouse Falcipennis canadensis |
 l05/2/027 Spruce Grouse |
Ruffed Grouse Bonasa umbellus |
 m50/3/074 Ruffed Grouse |  m50/5/073 Ruffed Grouse |
Virginia Rail Rallus limicola |
 m50/3/091 Virginia Rail |  m50/3/092 Virginia Rail |  m50/3/093 Virginia Rail |  m50/3/094 Virginia Rail |
 m50/3/095 Virginia Rail |  m50/1/352 Virginia Rail |
Killdeer Charadrius vociferus |
 m50/1/217 Killdeer |
Ring-billed Gull Larus delawarensis |
 m50/1/295 Ring-billed Gull |
Herring Gull Larus argentatus |
 m50/1/181 Herring Gull |
Hybrid Nelson's Gull L. argentatus x L. hyperboreus |
 m50/1/249 Hybrid Nelson's Gull |  m50/1/250 Hybrid Nelson's Gull |  m50/1/251 Hybrid Nelson's Gull |  m50/1/252 Hybrid Nelson's Gull |
 m50/1/253 Hybrid Nelson's Gull |
Lesser Black-backed Gull Larus fuscus |
 m50/1/218 Lesser Black-backed Gull |
Glaucous Gull Larus hyperboreus |
 m50/1/153 Glaucous Gull |  m50/1/154 Glaucous Gull |  m50/1/155 Glaucous Gull |  m50/1/156 Glaucous Gull |
 m50/1/158 Glaucous Gull |  m50/1/159 Glaucous Gull |  m50/1/157 Glaucous Gull |
Iceland Gull Larus glaucoides |
 m50/1/204 Iceland Gull |  m50/2/008 Iceland Gull |  m50/2/009 Iceland Gull |  m50/2/010 Iceland Gull |
 m50/2/011 Iceland Gull |  m50/2/012 Iceland Gull |
Solitary Sandpiper Tringa solitaria |
 m50/1/325 Solitary Sandpiper |
Red-necked Phalarope Phalaropus lobatus |
 m50/3/072 Red-necked Phalarope |  m50/3/073 Red-necked Phalarope |
Red Phalarope Phalaropus fulicarius |
 m50/3/068 Red Phalarope |  m50/3/069 Red Phalarope |  m50/3/070 Red Phalarope |  m50/3/071 Red Phalarope |
|
American Woodcock Scolopax minor |
 m50/3/001 American Woodcock |  m50/3/002 American Woodcock |  m50/3/003 American Woodcock |  m50/5/005 American Woodcock |
 m50/5/006 American Woodcock |
White-rumped Sandpiper Calidris fuscicollis |
 m50/1/368 White-rumped Sandpiper |
Baird's Sandpiper Calidris bairdii |
 m50/1/012 Baird's Sandpiper |  m50/1/013 Baird's Sandpiper |
Common Tern Sterna hirundo |
 m50/3/025 Common Tern |  m50/3/026 Common Tern |  m50/1/111 Common Tern |  m50/1/112 Common Tern |
 m50/1/113 Common Tern |
Arctic Tern Sterna paradisaea |
 m50/1/010 Arctic Tern |
Roseate Tern Sterna dougallii |
 m50/1/302 Roseate Tern |
Black-billed Cuckoo Coccyzus erythropthalmus |
 m50/3/008 Black-billed Cuckoo |  m50/3/009 Black-billed Cuckoo |
Yellow-billed Cuckoo Coccyzus americanus |
 m50/3/100 Yellow-billed Cuckoo |
Ruby-throated Hummingbird Archilochus colubris |
 m50/1/304 Ruby-throated Hummingbird |  m50/1/305 Ruby-throated Hummingbird |
Yellow-bellied Sapsucker Sphyrapicus varius |
 m50/1/375 Yellow-bellied Sapsucker |
Downy Woodpecker Picoides pubescens |
 m50/4/017 Downy Woodpecker |  m50/1/129 Downy Woodpecker |
Hairy Woodpecker Picoides villosus |
 m50/4/029 Hairy Woodpecker |
Black-backed Woodpecker Picoides arcticus |
 m50/1/015 Black-backed Woodpecker |  m50/1/016 Black-backed Woodpecker |  m50/1/017 Black-backed Woodpecker |  m50/1/018 Black-backed Woodpecker |
 m50/1/019 Black-backed Woodpecker |  m50/1/020 Black-backed Woodpecker |  m50/2/001 Black-backed Woodpecker |  m50/2/002 Black-backed Woodpecker |
 m50/3/010 Black-backed Woodpecker |
Pileated Woodpecker Dryocopus pileatus |
 l05/11/033 Pileated Woodpecker |
Horned Lark Eremophila alpestris |
 m50/1/184 Horned Lark |  m50/1/186 Horned Lark |