You could create a calculation to use as a filter - this is just a starting example:
If [State]="CO" or [State]="IA" or [State]="KS" then '0'
elseif [State]="CT" or [State]="MA" or [State]="ME" then '1'
Could you elaborate on the issues with the map? - I'm not understanding this - The data has some from Canada, but are not appearing. I know how to make them appear, but the US will not appear.