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 
Berylline_Hummingbird_Madera_Canyon_West_090324_173518  Berylline_Hummingbird3/24/20096/30/2008Madera_Canyon Accepted 
Berylline_Hummingbird_Madera_Canyon_Halsey_090324_173106  Berylline_Hummingbird3/24/20096/22/2008Madera_CanyonProbably the same pair reported by George WestAccepted 
Berylline_Hummingbird_Ramsey_Canyon_Detwiler_090324_171919  Berylline_Hummingbird3/24/20095/5/2008Ramsey_Canyon Accepted 
RFSP_PV_Ison_091213_214305  Red Fox Sparrow12/13/200912/13/2009PV Submitted 
EGWT_Tempe_Moulton_090322_232107  Eurasian Green-winged Teal3/22/20091/10/2009Tempe Accepted 
WIWR_MesaAZ_Burns_090215_205149  Eastern Winter Wren2/15/20092/15/2009MesaAZ Submitted 
Brown-backed_Solitaire_Hereford_Rosenberg_100510_121940  Brown-backed_Solitaire5/10/20107/16/2009Hereford Submitted 
WIWR_Madera_Halsey_090201_223126  Eastern Winter Wren2/1/20092/1/2009Madera Non-Accept 
Sinaloa_Wren_Sierra_Vista_Touret_090417_072649  Sinaloa_Wren4/17/20094/14/2009Sierra_Vista Accepted 
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 
Crested_Caracara_Marana_Monrgomery_100127_110258  Crested_Caracara1/27/201012/19/2009MaranaNot a review speciesSubmitted 
Least_Grebe_Phoenix_Siler_100210_171351  Least_Grebe2/10/20102/10/2010Phoenix Submitted 
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 
Harlan_Light-Morph_Hawk_Arlington_Herring_090203_225812  Harlan_Light-Morph_Hawk2/3/20091/1/2009Arlingtonnot a review speciesSubmitted 
RFSP_PSCP_Brown_091213_173352  Red Fox Sparrow12/13/200912/13/2009PSCP Submitted 
Brown-backed_Solitaire_Hereford_Benjamin_Van_Doren_090930_165940  Brown-backed_Solitaire9/30/20097/16/2009Hereford recirculated 
Brown-backed_Solitaire_Hereford_Christie_Van_Cleve_090930_174920  Brown-backed_Solitaire9/30/20097/19/2009HerefordSame as 2009-31Recirculated