Home
Sightings
Sightings Archives

Sightings of Genus Aimophila

select DISTINCT Report.Type, Report.ReportDate, Year([ReportDate]), Month([ReportDate]), Day([ReportDate]) from Report, ReportSpecies, Species where Report.Type = @Type and Report.ReportKey = ReportSpecies.ReportKey and ReportSpecies.SpeciesKey = Species.SpeciesKey and Species.GenusKey = 799 ORDER BY Year([ReportDate]) DESC , Month([ReportDate]), Day([ReportDate]);   Species List
 
Bachman's Sparrow (Aimophila aestivalis)
Cassin's Sparrow (Aimophila cassinii)