SQL = select [id], [accepted], [species], [obsdate], [number], [region], [county], [location], [observer], [your_name], [email], [context], [details], [comments] From [speciesView] ORDER BY [obsdate] DESC

Table: Sightings View 

speciesnumberdateregioncountycontextlocationobserverdetails
Clay-colored Sparrow15/10/2013SoutheastPimaRare spring migrant in the regionTucson, Rio Vista Natural Resource ParkJoan GellatlySee photos in eBird checklist here: http://ebird.org/ebird/view/checklist?subID=S14062170
Batimore Oriole14/28/2013SoutheastPimaRare migrant in Arizona.. Madera Canyon - Proctor RdPaul Jaussi / Bill GriffithsWe were on the Audubon field trip on Sunday, April 28, 2013. The oriole flew in and landed above us on a tree. We didn't realize what we had until we reviewed the photos from our trip a few weeks later. We have clear photos but don't know where to post them. Orange oriole with black head and back. Black covers throat and extends down to chest. See photos here: http://www.azfo.org/gallery/2013/html03/BAOR_Madera_Jaussi_28_April_2013.html
Broad-winged Hawk14/21/2013GilaGilaa rare migrant in the Gila regionPine Cr. Canyon/PineBrian Isonseen from about 100 ft. away in morning light perched in bare tree near Pine Cr. The hawk was viewed for about 20 seconds before flying upstream a short distance, where it was mobbed by an Acorn Woodpecker. I noted light reddish bands across upper breast, white throat framed by black stripes. Also seen were dark bill, head and eye. Wing tips almost reached tail tip. Tail seemed square at tip and had white bands.
Pacific Wren23/17/2013GilaGilauncommon to rare. One wren was a singing malePine Cr. Canyon/PineBrian Isonthe first bird was a singing male, heard and then seen on flood debris next to fast-flowing Pine Creek. I was about 30 ft. above creek and watched the wren for about 5 minutes as it moved in and out of the fallen logs, etc. The second wren was seen from about 10 ft. away as it "dust bathed". This bird called several times (like a Wilson's Warbler call) and was about 50 yds upstream from the male.
Peach faced and dutch blue lovebirds1003/3/2013South CentralMaricopaNot a native species to this continent or area.22617 N. 70th Dr. GlendaleMichelle SavagePreviously in the week had seen several varieties of birds in my yard, including a cardinal, a starling along with the usual yellow finches, cactus wrens, red house finches, humming birds, quails, doves and regular finches.....geese had been staying in the area for some time with the erratic weather thriving on the baseball fields behind my home, with the occassional visit to my back yard. This is the first time in the 13 years in my home that I have seen lovebirds. I have photos.
Greater White-fronted Goose33/3/2013GilaGilarare winter visitors to Gila Co.Pine cabinBrian Isonseen from below flying about 500 ft. overhead. I noted orange bill color and darkish barring on bellies as they flew over in great light; they were leading a flock of 25 Canada Geese and were seen at about 8:00 AM.
Neotropic Cormorant22/23/2013White MountainsNavajoFirst record for Navajo County, only third time species has been observed in the region.Overgaard, Bison Ranch pondEric & Bob HoughPhotographed (see AZFO gallery)
Red-breasted Sapsucker12/18/2013SoutheastPimaUnusual bird for AZ. I am not familiar enough with this species to determine if this is pure Red-breasted or a hybrid. TucsonDavid BygottSeen in garden, residential area, watched from about 30', took photos - links below. Neighbors indicate that it has been in the area for at least a week. http://www.flickr.com/photos/davidbygott/8488684115/in/photostream http://www.flickr.com/photos/davidbygott/8489781740/in/photostream/
Neotropic Cormorant12/17/2013GilaGilaPossibly the first record for the Payson area. There are previous Gila County records from Roosevelt Lake and San Carlos Lake further southeast.Payson--Green Valley ParkEric Hough, Samantha DorrPhotographed. Dark lores, white border to gular patch, short bill relative to the head.
Zone-tailed Hawk12/17/2013GilaGilaAccidental north of the Phoenix area in winter (it is casual to rare in the Phoenix area in winter), possibly the northernmost winter record for the state (?).Payson--Green Valley ParkEric Hough, Samantha DorrPhotographed; dark tail with white band, yellow bill, flying in dihedral shape similar to that of a Turkey Vulture's shape and wing posture during flight.
Cliff Swallow22/13/2013South CentralMaricopaEarly arrival date and observed nest building activity.Glendale Recharge PondsMelanie HerringI spent a considerable amount of time watching 1-2 swallows go collect mud and bring it back to the NW corner of a culvert. Noted the dark throat area, light rump, and light patch on foreheard. They also vocalized (live wire sound) as they flew over. Might be more out there since I did hear them vocalize amongst a large number of N Rough-wings that were foraging very high in the air over one of the basins away from the culvert.
Yellow Warbler86452557422/10/2013South CentralMaricopa Gilbert Water RanchJacob Plant 
Sandhill Crane62/10/2013South CentralMaricopaSandhill Cranes rather uncommon in this area. SRPMICFrank Clear, cool, 8:30 a.m. Plowed Field @ Extension & Montecito on SRPMIC Reservation. Observed within 10 yards- all appeared Adult by color and Markings.
Greater White-fronted Geese52/9/2013South CentralMaricopaRareAvondaleMelanie HerringFirst detected 4 foraging with Canada geese in Crystal Gardens. At dusk, when they were foraging in an Ag field south of McDowell and west of Avondale blvd, I noted a fifth individual. (photographed)
"Myrtle" Yellow-rumped Warbler32/6/2013White MountainsNavajoProbably uncommon, but status of most birds is poorly known on the White Mountain Apache Reservation.N. Fk. of the White River from Alchesay Hatchery downstreamEric & Bob Hough 
White-throated Sparrow12/6/2013White MountainsNavajoRare winter visitorAlchesay Hatchery Rd., a couple miles south of the hatcheryEric & Bob Hough 
White-throated Sparrow12/6/2013White MountainsNavajoRare winter visitor.Alchesay HatcheryEric & Bob HoughPhotographed. Immature or a tan-striped individual.
Lincoln's Sparrow12/6/2013White MountainsNavajoUncommon in winter.Alchesay HatcheryEric & Bob HoughHanging out with a flock of several Song Sparrows and one White-throated Sparrow in the weeds around one of the fish rearing ponds (all three sparrow species photographed together).
American Dipper42/6/2013White MountainsNavajoOne breeding pair, with at least two of four birds singing would seem to indicate local breeding here, which has not yet been documented in s. Navajo County (not entirely unexpected though since they breed higher up on this drainage in Apache Co. and in other drainages of the White Mountains). The pair appeared to have a nesting location under overhanging pine roots along the river on 2 March and one bird present on 24 March.N. Fk. of White River downstream from Alchesay HatcheryEric & Bob Hough 
Lewis's Woodpecker12/3/2013GilaGilaUncommon winter visitor below the Mogollon RimHwy. 260 near Diamond Point Shadows (<10 miles e. of Star Valley)Eric Hough