SQL = select [record], [genus], [species_latin], [species], [date_submitted], [date_observed], [location], [secretary_comments], [status], [Tax_Order] From [_ABCReports Public View]

Table: ABC Reports Public View 

Recordgenusspecies_latinSpeciesDate SubmittedDate ObservedLocationSecretary CommentsStatusTax_Order
WIWR_Mesa_Moore_090124_125541  Eastern Winter Wren1/24/20091/24/2009MesaExcellent photos and sound recordings confirm this as an "Eastern"Accepted 
Brown-backed_Solitaire_Hereford_Rosenberg_100510_121940  Brown-backed_Solitaire5/10/20107/16/2009Hereford Submitted 
Berylline_Hummingbird_Ramsey_Canyon_Detwiler_090324_171919  Berylline_Hummingbird3/24/20095/5/2008Ramsey_Canyon Accepted 
EGWT_Tempe_Moulton_090322_232107  Eurasian Green-winged Teal3/22/20091/10/2009Tempe Accepted 
White-eared_Hummingbird_Flagstaff_Coons_100628_191305  White-eared_Hummingbird6/28/20106/23/2010Flagstaff Submitted 
WIWR_MesaAZ_Burns_090215_205149  Eastern Winter Wren2/15/20092/15/2009MesaAZ Submitted 
Harlan_Light-Morph_Hawk_Arlington_Herring_090203_225812  Harlan_Light-Morph_Hawk2/3/20091/1/2009Arlingtonnot a review speciesSubmitted 
Brown-backed_Solitaire_Hereford_Benjamin_Van_Doren_090930_165940  Brown-backed_Solitaire9/30/20097/16/2009Hereford recirculated 
Berylline_Hummingbird_Madera_Canyon_West_090324_173518  Berylline_Hummingbird3/24/20096/30/2008Madera_Canyon Accepted 
WIWR_Madera_Halsey_090201_223126  Eastern Winter Wren2/1/20092/1/2009Madera Non-Accept 
PAJA_Lake_Havasu_Lehman_081118_162423-2  Parasitic Jaejer 9/29/2008Lake_Havasu_CityAccepted as Jaeger sp.Non-Accept 
Least_Grebe_Phoenix_Siler_100210_171351  Least_Grebe2/10/20102/10/2010Phoenix Submitted 
WIWR_HortonCk._Hough_090119_031204  Eastern Winter Wren1/19/20091/17/2009HortonCk. Accepted 
YSFL_CatalinaSP_Beringer_090114_112031  Yellow-shafted Northern Flicker1/14/20091/13/2009CatalinaSPNot a review speciesNot Reviewed 
EGWT_TEMPELAKE_Deviche_090110_125034  Eurasian Green-winged Teal1/10/20091/10/2009TEMPELAKE Accepted 
RFSP_Florida_Halsey_081228_230209  Red Fox Sparrow12/28/200812/28/2008Florida Submitted 
Gray-collared_Becard_Portal_Jillian_Johnston_100510_115043  Gray-collared_Becard5/10/20106/5/2009Portal Submitted 
Brown-backed_Solitaire_Madera_Canyon_Nigel_Crook_100601_173854  Brown-backed_Solitaire6/1/201010/4/1996Madera_Canyon Submitted 
Crested_Caracara_Marana_Monrgomery_100127_110258  Crested_Caracara1/27/201012/19/2009MaranaNot a review speciesSubmitted 
Gray-collared_Becard_Portal_Johnston_090613_215323  Gray-collared_Becard6/13/20096/5/2009Portal Recirculated