Including US States in Spot Database Entries
To include the US State in the Spot Database Entry for stations in the United States,
Direct DXView to install the USAP database, which will enable SpotCollector to determine the US State of each callsign issued by the Federal Communications Commission
on the General tab of SpotCollector's Configuration window, check the Lookup missing location info box
on the Spot Database tab of SpotCollector's Configuration window, click the Recomputation panel's Recomp button
You can filter the Spot Database Display to show stations in specific states by referencing the Primary field in an SQL filter, e.g.
(DXCCPrefix='K') and (Primary in ('MN','VT'))