
1. Re: If You Only Have United States Zipcodes Can You Group Them To The State Level? (No State Only Zipcode)
Shawn Wallwork Jul 26, 2012 11:00 AM (in response to Joseph Pirraglia)Joseph, if you put the zipcode field on the level of detail it will put them on the map within their proper states. You don't have to tell Tableau what state they are in, it already knows (it's smart like that ).
Shawn

2. Re: If You Only Have United States Zipcodes Can You Group Them To The State Level? (No State Only Zipcode)
Joseph Pirraglia Jul 27, 2012 6:26 AM (in response to Shawn Wallwork)Can you sum them up to the State in a table? Again assuming there is no field for State in the data source. Tableau does not have an automatic field in the dimensions for State or MSA if only zipcode is provided? Is this correct?

3. Re: If You Only Have United States Zipcodes Can You Group Them To The State Level? (No State Only Zipcode)
Shawn Wallwork Jul 27, 2012 7:14 AM (in response to Joseph Pirraglia)Joseph, that is correct. Tableau is smart, but not quite that smart.
Shawn

4. Re: If You Only Have United States Zipcodes Can You Group Them To The State Level? (No State Only Zipcode)
Joseph Pirraglia Jul 27, 2012 7:17 AM (in response to Shawn Wallwork)I was trying to do that and kinda figured that was the case but just wanted to check. Thanks!

5. Re: If You Only Have United States Zipcodes Can You Group Them To The State Level? (No State Only Zipcode)
Tim Latendress Jul 27, 2012 8:30 AM (in response to Joseph Pirraglia)For what it's worth, there are zip codes that cross state and county boundaries. Something to keep in mind.
Tim

6. Re: If You Only Have United States Zipcodes Can You Group Them To The State Level? (No State Only Zipcode)
Man Tsui Jun 26, 2017 11:33 AM (in response to Joseph Pirraglia)The approach I'm trying is 3digit zip prefix from usps.com and I push it down as a calculated field (see below).
Similar calculated field has been setup for "Zip Code Desc"
// Create normalized state abbreviation through 3digit zip prefix
// 3digit zip prefix based from USPS
// http://pe.usps.com/Archive/HTML/DMMArchive20050106/print/L002.htmCASE LEFT([Zip], 3)
WHEN "005" THEN "NY"
WHEN "006" THEN "PR"
WHEN "007" THEN "PR"
WHEN "008" THEN "PR"
WHEN "009" THEN "PR"
WHEN "010" THEN "MA"
WHEN "011" THEN "MA"
WHEN "012" THEN "MA"
WHEN "013" THEN "MA"
WHEN "014" THEN "MA"
WHEN "015" THEN "MA"
WHEN "016" THEN "MA"
WHEN "017" THEN "MA"
WHEN "018" THEN "MA"
WHEN "019" THEN "MA"
WHEN "020" THEN "MA"
WHEN "021" THEN "MA"
WHEN "022" THEN "MA"
WHEN "023" THEN "MA"
WHEN "024" THEN "MA"
WHEN "025" THEN "MA"
WHEN "026" THEN "MA"
WHEN "027" THEN "RI"
WHEN "028" THEN "RI"
WHEN "029" THEN "RI"
WHEN "030" THEN "NH"
WHEN "031" THEN "NH"
WHEN "032" THEN "NH"
WHEN "033" THEN "NH"
WHEN "034" THEN "NH"
WHEN "035" THEN "VT"
WHEN "036" THEN "VT"
WHEN "037" THEN "VT"
WHEN "038" THEN "NH"
WHEN "039" THEN "NH"
WHEN "040" THEN "ME"
WHEN "041" THEN "ME"
WHEN "042" THEN "ME"
WHEN "043" THEN "ME"
WHEN "044" THEN "ME"
WHEN "045" THEN "ME"
WHEN "046" THEN "ME"
WHEN "047" THEN "ME"
WHEN "048" THEN "ME"
WHEN "049" THEN "ME"
WHEN "050" THEN "VT"
WHEN "051" THEN "VT"
WHEN "052" THEN "VT"
WHEN "053" THEN "VT"
WHEN "054" THEN "VT"
WHEN "055" THEN "MA"
WHEN "056" THEN "VT"
WHEN "057" THEN "VT"
WHEN "058" THEN "VT"
WHEN "059" THEN "VT"
WHEN "060" THEN "CT"
WHEN "061" THEN "CT"
WHEN "062" THEN "CT"
WHEN "063" THEN "CT"
WHEN "064" THEN "CT"
WHEN "065" THEN "CT"
WHEN "066" THEN "CT"
WHEN "067" THEN "CT"
WHEN "068" THEN "CT"
WHEN "069" THEN "CT"
WHEN "070" THEN "NJ"
WHEN "071" THEN "NJ"
WHEN "072" THEN "NJ"
WHEN "073" THEN "NJ"
WHEN "074" THEN "NJ"
WHEN "075" THEN "NJ"
WHEN "076" THEN "NJ"
WHEN "077" THEN "NJ"
WHEN "078" THEN "NJ"
WHEN "079" THEN "NJ"
WHEN "080" THEN "NJ"
WHEN "081" THEN "NJ"
WHEN "082" THEN "NJ"
WHEN "083" THEN "NJ"
WHEN "084" THEN "NJ"
WHEN "085" THEN "NJ"
WHEN "086" THEN "NJ"
WHEN "087" THEN "NJ"
WHEN "088" THEN "NJ"
WHEN "089" THEN "NJ"
WHEN "090" THEN "AE"
WHEN "091" THEN "AE"
WHEN "092" THEN "AE"
WHEN "093" THEN "AE"
WHEN "094" THEN "AE"
WHEN "095" THEN "AE"
WHEN "096" THEN "AE"
WHEN "097" THEN "AE"
WHEN "098" THEN "AE"
WHEN "099" THEN "AE"
WHEN "100" THEN "NY"
WHEN "101" THEN "NY"
WHEN "102" THEN "NY"
WHEN "103" THEN "NY"
WHEN "104" THEN "NY"
WHEN "105" THEN "NY"
WHEN "106" THEN "NY"
WHEN "107" THEN "NY"
WHEN "108" THEN "NY"
WHEN "109" THEN "NY"
WHEN "110" THEN "NY"
WHEN "111" THEN "NY"
WHEN "112" THEN "NY"
WHEN "113" THEN "NY"
WHEN "114" THEN "NY"
WHEN "115" THEN "NY"
WHEN "116" THEN "NY"
WHEN "117" THEN "NY"
WHEN "118" THEN "NY"
WHEN "119" THEN "NY"
WHEN "120" THEN "NY"
WHEN "121" THEN "NY"
WHEN "122" THEN "NY"
WHEN "123" THEN "NY"
WHEN "124" THEN "NY"
WHEN "125" THEN "NY"
WHEN "126" THEN "NY"
WHEN "127" THEN "NY"
WHEN "128" THEN "NY"
WHEN "129" THEN "NY"
WHEN "130" THEN "NY"
WHEN "131" THEN "NY"
WHEN "132" THEN "NY"
WHEN "133" THEN "NY"
WHEN "134" THEN "NY"
WHEN "135" THEN "NY"
WHEN "136" THEN "NY"
WHEN "137" THEN "NY"
WHEN "138" THEN "NY"
WHEN "139" THEN "NY"
WHEN "140" THEN "NY"
WHEN "141" THEN "NY"
WHEN "142" THEN "NY"
WHEN "143" THEN "NY"
WHEN "144" THEN "NY"
WHEN "145" THEN "NY"
WHEN "146" THEN "NY"
WHEN "147" THEN "NY"
WHEN "148" THEN "NY"
WHEN "149" THEN "NY"
WHEN "150" THEN "PA"
WHEN "151" THEN "PA"
WHEN "152" THEN "PA"
WHEN "153" THEN "PA"
WHEN "154" THEN "PA"
WHEN "155" THEN "PA"
WHEN "156" THEN "PA"
WHEN "157" THEN "PA"
WHEN "158" THEN "PA"
WHEN "159" THEN "PA"
WHEN "160" THEN "PA"
WHEN "161" THEN "PA"
WHEN "162" THEN "PA"
WHEN "163" THEN "PA"
WHEN "164" THEN "PA"
WHEN "165" THEN "PA"
WHEN "166" THEN "PA"
WHEN "167" THEN "PA"
WHEN "168" THEN "PA"
WHEN "169" THEN "PA"
WHEN "170" THEN "PA"
WHEN "171" THEN "PA"
WHEN "172" THEN "PA"
WHEN "173" THEN "PA"
WHEN "174" THEN "PA"
WHEN "175" THEN "PA"
WHEN "176" THEN "PA"
WHEN "177" THEN "PA"
WHEN "178" THEN "PA"
WHEN "179" THEN "PA"
WHEN "180" THEN "PA"
WHEN "181" THEN "PA"
WHEN "182" THEN "PA"
WHEN "183" THEN "PA"
WHEN "184" THEN "PA"
WHEN "185" THEN "PA"
WHEN "186" THEN "PA"
WHEN "187" THEN "PA"
WHEN "188" THEN "PA"
WHEN "189" THEN "PA"
WHEN "190" THEN "PA"
WHEN "191" THEN "PA"
WHEN "192" THEN "PA"
WHEN "193" THEN "PA"
WHEN "194" THEN "PA"
WHEN "195" THEN "PA"
WHEN "196" THEN "PA"
WHEN "197" THEN "DE"
WHEN "198" THEN "DE"
WHEN "199" THEN "DE"
WHEN "200" THEN "DC"
WHEN "201" THEN "VA"
WHEN "202" THEN "DC"
WHEN "203" THEN "DC"
WHEN "204" THEN "DC"
WHEN "205" THEN "DC"
WHEN "206" THEN "MD"
WHEN "207" THEN "MD"
WHEN "208" THEN "MD"
WHEN "209" THEN "MD"
WHEN "210" THEN "MD"
WHEN "211" THEN "MD"
WHEN "212" THEN "MD"
WHEN "214" THEN "MD"
WHEN "215" THEN "MD"
WHEN "216" THEN "MD"
WHEN "217" THEN "MD"
WHEN "218" THEN "MD"
WHEN "219" THEN "MD"
WHEN "220" THEN "VA"
WHEN "221" THEN "VA"
WHEN "222" THEN "VA"
WHEN "223" THEN "VA"
WHEN "224" THEN "VA"
WHEN "225" THEN "VA"
WHEN "226" THEN "VA"
WHEN "227" THEN "VA"
WHEN "228" THEN "VA"
WHEN "229" THEN "VA"
WHEN "230" THEN "VA"
WHEN "231" THEN "VA"
WHEN "232" THEN "VA"
WHEN "233" THEN "VA"
WHEN "234" THEN "VA"
WHEN "235" THEN "VA"
WHEN "236" THEN "VA"
WHEN "237" THEN "VA"
WHEN "238" THEN "VA"
WHEN "239" THEN "VA"
WHEN "240" THEN "VA"
WHEN "241" THEN "VA"
WHEN "242" THEN "VA"
WHEN "243" THEN "VA"
WHEN "244" THEN "VA"
WHEN "245" THEN "VA"
WHEN "246" THEN "WV"
WHEN "247" THEN "WV"
WHEN "248" THEN "WV"
WHEN "249" THEN "WV"
WHEN "250" THEN "WV"
WHEN "251" THEN "WV"
WHEN "252" THEN "WV"
WHEN "253" THEN "WV"
WHEN "254" THEN "WV"
WHEN "255" THEN "WV"
WHEN "256" THEN "WV"
WHEN "257" THEN "WV"
WHEN "258" THEN "WV"
WHEN "259" THEN "WV"
WHEN "260" THEN "WV"
WHEN "261" THEN "WV"
WHEN "262" THEN "WV"
WHEN "263" THEN "WV"
WHEN "264" THEN "WV"
WHEN "265" THEN "WV"
WHEN "266" THEN "WV"
WHEN "267" THEN "MD"
WHEN "268" THEN "WV"
WHEN "270" THEN "NC"
WHEN "271" THEN "NC"
WHEN "272" THEN "NC"
WHEN "273" THEN "NC"
WHEN "274" THEN "NC"
WHEN "275" THEN "NC"
WHEN "276" THEN "NC"
WHEN "277" THEN "NC"
WHEN "278" THEN "NC"
WHEN "279" THEN "NC"
WHEN "280" THEN "NC"
WHEN "281" THEN "NC"
WHEN "282" THEN "NC"
WHEN "283" THEN "NC"
WHEN "284" THEN "NC"
WHEN "285" THEN "NC"
WHEN "286" THEN "NC"
WHEN "287" THEN "NC"
WHEN "288" THEN "NC"
WHEN "289" THEN "NC"
WHEN "290" THEN "SC"
WHEN "291" THEN "SC"
WHEN "292" THEN "SC"
WHEN "293" THEN "SC"
WHEN "294" THEN "SC"
WHEN "295" THEN "SC"
WHEN "296" THEN "SC"
WHEN "297" THEN "NC"
WHEN "298" THEN "GA"
WHEN "299" THEN "GA"
WHEN "300" THEN "GA"
WHEN "301" THEN "GA"
WHEN "302" THEN "GA"
WHEN "303" THEN "GA"
WHEN "304" THEN "GA"
WHEN "305" THEN "GA"
WHEN "306" THEN "GA"
WHEN "307" THEN "TN"
WHEN "308" THEN "GA"
WHEN "309" THEN "GA"
WHEN "310" THEN "GA"
WHEN "311" THEN "GA"
WHEN "312" THEN "GA"
WHEN "313" THEN "GA"
WHEN "314" THEN "GA"
WHEN "315" THEN "GA"
WHEN "316" THEN "GA"
WHEN "317" THEN "GA"
WHEN "318" THEN "GA"
WHEN "319" THEN "GA"
WHEN "320" THEN "FL"
WHEN "321" THEN "FL"
WHEN "322" THEN "FL"
WHEN "323" THEN "FL"
WHEN "324" THEN "FL"
WHEN "325" THEN "FL"
WHEN "326" THEN "FL"
WHEN "327" THEN "FL"
WHEN "328" THEN "FL"
WHEN "329" THEN "FL"
WHEN "330" THEN "FL"
WHEN "331" THEN "FL"
WHEN "332" THEN "FL"
WHEN "333" THEN "FL"
WHEN "334" THEN "FL"
WHEN "335" THEN "FL"
WHEN "336" THEN "FL"
WHEN "337" THEN "FL"
WHEN "338" THEN "FL"
WHEN "339" THEN "FL"
WHEN "340" THEN "AA"
WHEN "341" THEN "FL"
WHEN "342" THEN "FL"
WHEN "344" THEN "FL"
WHEN "346" THEN "FL"
WHEN "347" THEN "FL"
WHEN "349" THEN "FL"
WHEN "350" THEN "AL"
WHEN "351" THEN "AL"
WHEN "352" THEN "AL"
WHEN "354" THEN "AL"
WHEN "355" THEN "AL"
WHEN "356" THEN "AL"
WHEN "357" THEN "AL"
WHEN "358" THEN "AL"
WHEN "359" THEN "AL"
WHEN "360" THEN "AL"
WHEN "361" THEN "AL"
WHEN "362" THEN "AL"
WHEN "363" THEN "AL"
WHEN "364" THEN "AL"
WHEN "365" THEN "AL"
WHEN "366" THEN "AL"
WHEN "367" THEN "AL"
WHEN "368" THEN "AL"
WHEN "369" THEN "MS"
WHEN "370" THEN "TN"
WHEN "371" THEN "TN"
WHEN "372" THEN "TN"
WHEN "373" THEN "TN"
WHEN "374" THEN "TN"
WHEN "375" THEN "TN"
WHEN "376" THEN "TN"
WHEN "377" THEN "TN"
WHEN "378" THEN "TN"
WHEN "379" THEN "TN"
WHEN "380" THEN "TN"
WHEN "381" THEN "TN"
WHEN "382" THEN "TN"
WHEN "383" THEN "TN"
WHEN "384" THEN "TN"
WHEN "385" THEN "TN"
WHEN "386" THEN "TN"
WHEN "387" THEN "MS"
WHEN "388" THEN "MS"
WHEN "389" THEN "MS"
WHEN "390" THEN "MS"
WHEN "391" THEN "MS"
WHEN "392" THEN "MS"
WHEN "393" THEN "MS"
WHEN "394" THEN "MS"
WHEN "395" THEN "MS"
WHEN "396" THEN "MS"
WHEN "397" THEN "MS"
WHEN "398" THEN "GA"
WHEN "399" THEN "GA"
WHEN "400" THEN "KY"
WHEN "401" THEN "KY"
WHEN "402" THEN "KY"
WHEN "403" THEN "KY"
WHEN "404" THEN "KY"
WHEN "405" THEN "KY"
WHEN "406" THEN "KY"
WHEN "407" THEN "KY"
WHEN "408" THEN "KY"
WHEN "409" THEN "KY"
WHEN "410" THEN "OH"
WHEN "411" THEN "KY"
WHEN "412" THEN "KY"
WHEN "413" THEN "KY"
WHEN "414" THEN "KY"
WHEN "415" THEN "KY"
WHEN "416" THEN "KY"
WHEN "417" THEN "KY"
WHEN "418" THEN "KY"
WHEN "420" THEN "KY"
WHEN "421" THEN "KY"
WHEN "422" THEN "KY"
WHEN "423" THEN "KY"
WHEN "424" THEN "IN"
WHEN "425" THEN "KY"
WHEN "426" THEN "KY"
WHEN "427" THEN "KY"
WHEN "430" THEN "OH"
WHEN "431" THEN "OH"
WHEN "432" THEN "OH"
WHEN "433" THEN "OH"
WHEN "434" THEN "OH"
WHEN "435" THEN "OH"
WHEN "436" THEN "OH"
WHEN "437" THEN "OH"
WHEN "438" THEN "OH"
WHEN "439" THEN "OH"
WHEN "440" THEN "OH"
WHEN "441" THEN "OH"
WHEN "442" THEN "OH"
WHEN "443" THEN "OH"
WHEN "444" THEN "OH"
WHEN "445" THEN "OH"
WHEN "446" THEN "OH"
WHEN "447" THEN "OH"
WHEN "448" THEN "OH"
WHEN "449" THEN "OH"
WHEN "450" THEN "OH"
WHEN "451" THEN "OH"
WHEN "452" THEN "OH"
WHEN "453" THEN "OH"
WHEN "454" THEN "OH"
WHEN "455" THEN "OH"
WHEN "456" THEN "OH"
WHEN "457" THEN "OH"
WHEN "458" THEN "OH"
WHEN "459" THEN "OH"
WHEN "460" THEN "IN"
WHEN "461" THEN "IN"
WHEN "462" THEN "IN"
WHEN "463" THEN "IN"
WHEN "464" THEN "IN"
WHEN "465" THEN "IN"
WHEN "466" THEN "IN"
WHEN "467" THEN "IN"
WHEN "468" THEN "IN"
WHEN "469" THEN "IN"
WHEN "470" THEN "OH"
WHEN "471" THEN "KY"
WHEN "472" THEN "IN"
WHEN "473" THEN "IN"
WHEN "474" THEN "IN"
WHEN "475" THEN "IN"
WHEN "476" THEN "IN"
WHEN "477" THEN "IN"
WHEN "478" THEN "IN"
WHEN "479" THEN "IN"
WHEN "480" THEN "MI"
WHEN "481" THEN "MI"
WHEN "482" THEN "MI"
WHEN "483" THEN "MI"
WHEN "484" THEN "MI"
WHEN "485" THEN "MI"
WHEN "486" THEN "MI"
WHEN "487" THEN "MI"
WHEN "488" THEN "MI"
WHEN "489" THEN "MI"
WHEN "490" THEN "MI"
WHEN "491" THEN "MI"
WHEN "492" THEN "MI"
WHEN "493" THEN "MI"
WHEN "494" THEN "MI"
WHEN "495" THEN "MI"
WHEN "496" THEN "MI"
WHEN "497" THEN "MI"
WHEN "498" THEN "MI"
WHEN "499" THEN "MI"
WHEN "500" THEN "IA"
WHEN "501" THEN "IA"
WHEN "502" THEN "IA"
WHEN "503" THEN "IA"
WHEN "504" THEN "IA"
WHEN "505" THEN "IA"
WHEN "506" THEN "IA"
WHEN "507" THEN "IA"
WHEN "508" THEN "IA"
WHEN "509" THEN "IA"
WHEN "510" THEN "IA"
WHEN "511" THEN "IA"
WHEN "512" THEN "IA"
WHEN "513" THEN "IA"
WHEN "514" THEN "IA"
WHEN "515" THEN "NE"
WHEN "516" THEN "NE"
WHEN "520" THEN "IA"
WHEN "521" THEN "IA"
WHEN "522" THEN "IA"
WHEN "523" THEN "IA"
WHEN "524" THEN "IA"
WHEN "525" THEN "IA"
WHEN "526" THEN "IA"
WHEN "527" THEN "IL"
WHEN "528" THEN "IA"
WHEN "530" THEN "WI"
WHEN "531" THEN "WI"
WHEN "532" THEN "WI"
WHEN "534" THEN "WI"
WHEN "535" THEN "WI"
WHEN "537" THEN "WI"
WHEN "538" THEN "WI"
WHEN "539" THEN "WI"
WHEN "540" THEN "MN"
WHEN "541" THEN "WI"
WHEN "542" THEN "WI"
WHEN "543" THEN "WI"
WHEN "544" THEN "WI"
WHEN "545" THEN "WI"
WHEN "546" THEN "WI"
WHEN "547" THEN "WI"
WHEN "548" THEN "WI"
WHEN "549" THEN "WI"
WHEN "550" THEN "MN"
WHEN "551" THEN "MN"
WHEN "553" THEN "MN"
WHEN "554" THEN "MN"
WHEN "555" THEN "MN"
WHEN "556" THEN "MN"
WHEN "557" THEN "MN"
WHEN "558" THEN "MN"
WHEN "559" THEN "MN"
WHEN "560" THEN "MN"
WHEN "561" THEN "MN"
WHEN "562" THEN "MN"
WHEN "563" THEN "MN"
WHEN "564" THEN "MN"
WHEN "565" THEN "MN"
WHEN "566" THEN "MN"
WHEN "567" THEN "ND"
WHEN "570" THEN "SD"
WHEN "571" THEN "SD"
WHEN "572" THEN "SD"
WHEN "573" THEN "SD"
WHEN "574" THEN "SD"
WHEN "575" THEN "SD"
WHEN "576" THEN "SD"
WHEN "577" THEN "SD"
WHEN "580" THEN "ND"
WHEN "581" THEN "ND"
WHEN "582" THEN "ND"
WHEN "583" THEN "ND"
WHEN "584" THEN "ND"
WHEN "585" THEN "ND"
WHEN "586" THEN "ND"
WHEN "587" THEN "ND"
WHEN "588" THEN "ND"
WHEN "590" THEN "MT"
WHEN "591" THEN "MT"
WHEN "592" THEN "MT"
WHEN "593" THEN "MT"
WHEN "594" THEN "MT"
WHEN "595" THEN "MT"
WHEN "596" THEN "MT"
WHEN "597" THEN "MT"
WHEN "598" THEN "MT"
WHEN "599" THEN "MT"
WHEN "600" THEN "IL"
WHEN "601" THEN "IL"
WHEN "602" THEN "IL"
WHEN "603" THEN "IL"
WHEN "604" THEN "IL"
WHEN "605" THEN "IL"
WHEN "606" THEN "IL"
WHEN "607" THEN "IL"
WHEN "608" THEN "IL"
WHEN "609" THEN "IL"
WHEN "610" THEN "IL"
WHEN "611" THEN "IL"
WHEN "612" THEN "IL"
WHEN "613" THEN "IL"
WHEN "614" THEN "IL"
WHEN "615" THEN "IL"
WHEN "616" THEN "IL"
WHEN "617" THEN "IL"
WHEN "618" THEN "IL"
WHEN "619" THEN "IL"
WHEN "620" THEN "MO"
WHEN "622" THEN "MO"
WHEN "623" THEN "IL"
WHEN "624" THEN "IL"
WHEN "625" THEN "IL"
WHEN "626" THEN "IL"
WHEN "627" THEN "IL"
WHEN "628" THEN "IL"
WHEN "629" THEN "IL"
WHEN "630" THEN "MO"
WHEN "631" THEN "MO"
WHEN "633" THEN "MO"
WHEN "634" THEN "IL"
WHEN "635" THEN "IL"
WHEN "636" THEN "MO"
WHEN "637" THEN "MO"
WHEN "638" THEN "MO"
WHEN "639" THEN "MO"
WHEN "640" THEN "MO"
WHEN "641" THEN "MO"
WHEN "644" THEN "MO"
WHEN "645" THEN "MO"
WHEN "646" THEN "MO"
WHEN "647" THEN "MO"
WHEN "648" THEN "MO"
WHEN "649" THEN "MO"
WHEN "650" THEN "MO"
WHEN "651" THEN "MO"
WHEN "652" THEN "MO"
WHEN "653" THEN "MO"
WHEN "654" THEN "MO"
WHEN "655" THEN "MO"
WHEN "656" THEN "MO"
WHEN "657" THEN "MO"
WHEN "658" THEN "MO"
WHEN "660" THEN "KS"
WHEN "661" THEN "KS"
WHEN "662" THEN "KS"
WHEN "664" THEN "KS"
WHEN "665" THEN "KS"
WHEN "666" THEN "KS"
WHEN "667" THEN "KS"
WHEN "668" THEN "KS"
WHEN "669" THEN "KS"
WHEN "670" THEN "KS"
WHEN "671" THEN "KS"
WHEN "672" THEN "KS"
WHEN "673" THEN "KS"
WHEN "674" THEN "KS"
WHEN "675" THEN "KS"
WHEN "676" THEN "KS"
WHEN "677" THEN "KS"
WHEN "678" THEN "KS"
WHEN "679" THEN "KS"
WHEN "680" THEN "NE"
WHEN "681" THEN "NE"
WHEN "683" THEN "NE"
WHEN "684" THEN "NE"
WHEN "685" THEN "NE"
WHEN "686" THEN "NE"
WHEN "687" THEN "NE"
WHEN "688" THEN "NE"
WHEN "689" THEN "NE"
WHEN "690" THEN "NE"
WHEN "691" THEN "NE"
WHEN "692" THEN "NE"
WHEN "693" THEN "NE"
WHEN "700" THEN "LA"
WHEN "701" THEN "LA"
WHEN "703" THEN "LA"
WHEN "704" THEN "LA"
WHEN "705" THEN "LA"
WHEN "706" THEN "LA"
WHEN "707" THEN "LA"
WHEN "708" THEN "LA"
WHEN "710" THEN "LA"
WHEN "711" THEN "LA"
WHEN "712" THEN "LA"
WHEN "713" THEN "LA"
WHEN "714" THEN "LA"
WHEN "716" THEN "AR"
WHEN "717" THEN "AR"
WHEN "718" THEN "AR"
WHEN "719" THEN "AR"
WHEN "720" THEN "AR"
WHEN "721" THEN "AR"
WHEN "722" THEN "AR"
WHEN "723" THEN "TN"
WHEN "724" THEN "AR"
WHEN "725" THEN "AR"
WHEN "726" THEN "AR"
WHEN "727" THEN "AR"
WHEN "728" THEN "AR"
WHEN "729" THEN "AR"
WHEN "730" THEN "OK"
WHEN "731" THEN "OK"
WHEN "733" THEN "TX"
WHEN "734" THEN "OK"
WHEN "735" THEN "OK"
WHEN "736" THEN "OK"
WHEN "737" THEN "OK"
WHEN "738" THEN "OK"
WHEN "739" THEN "KS"
WHEN "740" THEN "OK"
WHEN "741" THEN "OK"
WHEN "743" THEN "OK"
WHEN "744" THEN "OK"
WHEN "745" THEN "OK"
WHEN "746" THEN "OK"
WHEN "747" THEN "OK"
WHEN "748" THEN "OK"
WHEN "749" THEN "OK"
WHEN "750" THEN "TX"
WHEN "751" THEN "TX"
WHEN "752" THEN "TX"
WHEN "753" THEN "TX"
WHEN "754" THEN "TX"
WHEN "755" THEN "TX"
WHEN "756" THEN "TX"
WHEN "757" THEN "TX"
WHEN "758" THEN "TX"
WHEN "759" THEN "TX"
WHEN "760" THEN "TX"
WHEN "761" THEN "TX"
WHEN "762" THEN "TX"
WHEN "763" THEN "TX"
WHEN "764" THEN "TX"
WHEN "765" THEN "TX"
WHEN "766" THEN "TX"
WHEN "767" THEN "TX"
WHEN "768" THEN "TX"
WHEN "769" THEN "TX"
WHEN "770" THEN "TX"
WHEN "771" THEN "TX"
WHEN "772" THEN "TX"
WHEN "773" THEN "TX"
WHEN "774" THEN "TX"
WHEN "775" THEN "TX"
WHEN "776" THEN "TX"
WHEN "777" THEN "TX"
WHEN "778" THEN "TX"
WHEN "779" THEN "TX"
WHEN "780" THEN "TX"
WHEN "781" THEN "TX"
WHEN "782" THEN "TX"
WHEN "783" THEN "TX"
WHEN "784" THEN "TX"
WHEN "785" THEN "TX"
WHEN "786" THEN "TX"
WHEN "787" THEN "TX"
WHEN "788" THEN "TX"
WHEN "789" THEN "TX"
WHEN "790" THEN "TX"
WHEN "791" THEN "TX"
WHEN "792" THEN "TX"
WHEN "793" THEN "TX"
WHEN "794" THEN "TX"
WHEN "795" THEN "TX"
WHEN "796" THEN "TX"
WHEN "797" THEN "TX"
WHEN "798" THEN "TX"
WHEN "799" THEN "TX"
WHEN "800" THEN "CO"
WHEN "801" THEN "CO"
WHEN "802" THEN "CO"
WHEN "803" THEN "CO"
WHEN "804" THEN "CO"
WHEN "805" THEN "CO"
WHEN "806" THEN "CO"
WHEN "807" THEN "CO"
WHEN "808" THEN "CO"
WHEN "809" THEN "CO"
WHEN "810" THEN "CO"
WHEN "811" THEN "CO"
WHEN "812" THEN "CO"
WHEN "813" THEN "CO"
WHEN "814" THEN "CO"
WHEN "815" THEN "CO"
WHEN "816" THEN "CO"
WHEN "820" THEN "WY"
WHEN "821" THEN "WY"
WHEN "822" THEN "WY"
WHEN "823" THEN "WY"
WHEN "824" THEN "WY"
WHEN "825" THEN "WY"
WHEN "826" THEN "WY"
WHEN "827" THEN "WY"
WHEN "828" THEN "WY"
WHEN "829" THEN "WY"
WHEN "830" THEN "WY"
WHEN "831" THEN "WY"
WHEN "832" THEN "ID"
WHEN "833" THEN "ID"
WHEN "834" THEN "ID"
WHEN "835" THEN "ID"
WHEN "836" THEN "ID"
WHEN "837" THEN "ID"
WHEN "838" THEN "WA"
WHEN "840" THEN "UT"
WHEN "841" THEN "UT"
WHEN "842" THEN "UT"
WHEN "843" THEN "UT"
WHEN "844" THEN "UT"
WHEN "845" THEN "UT"
WHEN "846" THEN "UT"
WHEN "847" THEN "UT"
WHEN "850" THEN "AZ"
WHEN "852" THEN "AZ"
WHEN "853" THEN "AZ"
WHEN "855" THEN "AZ"
WHEN "856" THEN "AZ"
WHEN "857" THEN "AZ"
WHEN "859" THEN "AZ"
WHEN "860" THEN "AZ"
WHEN "863" THEN "AZ"
WHEN "864" THEN "AZ"
WHEN "865" THEN "NM"
WHEN "870" THEN "NM"
WHEN "871" THEN "NM"
WHEN "872" THEN "NM"
WHEN "873" THEN "NM"
WHEN "874" THEN "NM"
WHEN "875" THEN "NM"
WHEN "877" THEN "NM"
WHEN "878" THEN "NM"
WHEN "879" THEN "NM"
WHEN "880" THEN "NM"
WHEN "881" THEN "NM"
WHEN "882" THEN "NM"
WHEN "883" THEN "NM"
WHEN "884" THEN "NM"
WHEN "885" THEN "TX"
WHEN "889" THEN "NV"
WHEN "890" THEN "NV"
WHEN "891" THEN "NV"
WHEN "893" THEN "NV"
WHEN "894" THEN "NV"
WHEN "895" THEN "NV"
WHEN "897" THEN "NV"
WHEN "898" THEN "NV"
WHEN "900" THEN "CA"
WHEN "901" THEN "CA"
WHEN "902" THEN "CA"
WHEN "903" THEN "CA"
WHEN "904" THEN "CA"
WHEN "905" THEN "CA"
WHEN "906" THEN "CA"
WHEN "907" THEN "CA"
WHEN "908" THEN "CA"
WHEN "910" THEN "CA"
WHEN "911" THEN "CA"
WHEN "912" THEN "CA"
WHEN "913" THEN "CA"
WHEN "914" THEN "CA"
WHEN "915" THEN "CA"
WHEN "916" THEN "CA"
WHEN "917" THEN "CA"
WHEN "918" THEN "CA"
WHEN "919" THEN "CA"
WHEN "920" THEN "CA"
WHEN "921" THEN "CA"
WHEN "922" THEN "CA"
WHEN "923" THEN "CA"
WHEN "924" THEN "CA"
WHEN "925" THEN "CA"
WHEN "926" THEN "CA"
WHEN "927" THEN "CA"
WHEN "928" THEN "CA"
WHEN "930" THEN "CA"
WHEN "931" THEN "CA"
WHEN "932" THEN "CA"
WHEN "933" THEN "CA"
WHEN "934" THEN "CA"
WHEN "935" THEN "CA"
WHEN "936" THEN "CA"
WHEN "937" THEN "CA"
WHEN "938" THEN "CA"
WHEN "939" THEN "CA"
WHEN "940" THEN "CA"
WHEN "941" THEN "CA"
WHEN "942" THEN "CA"
WHEN "943" THEN "CA"
WHEN "944" THEN "CA"
WHEN "945" THEN "CA"
WHEN "946" THEN "CA"
WHEN "947" THEN "CA"
WHEN "948" THEN "CA"
WHEN "949" THEN "CA"
WHEN "950" THEN "CA"
WHEN "951" THEN "CA"
WHEN "952" THEN "CA"
WHEN "953" THEN "CA"
WHEN "954" THEN "CA"
WHEN "955" THEN "CA"
WHEN "956" THEN "CA"
WHEN "957" THEN "CA"
WHEN "958" THEN "CA"
WHEN "959" THEN "CA"
WHEN "960" THEN "CA"
WHEN "961" THEN "NV"
WHEN "962" THEN "AP"
WHEN "963" THEN "AP"
WHEN "964" THEN "AP"
WHEN "965" THEN "AP"
WHEN "966" THEN "AP"
WHEN "967" THEN "HI"
WHEN "968" THEN "HI"
WHEN "969" THEN "GU"
WHEN "970" THEN "OR"
WHEN "971" THEN "OR"
WHEN "972" THEN "OR"
WHEN "973" THEN "OR"
WHEN "974" THEN "OR"
WHEN "975" THEN "OR"
WHEN "976" THEN "OR"
WHEN "977" THEN "OR"
WHEN "978" THEN "OR"
WHEN "979" THEN "ID"
WHEN "980" THEN "WA"
WHEN "981" THEN "WA"
WHEN "982" THEN "WA"
WHEN "983" THEN "WA"
WHEN "984" THEN "WA"
WHEN "985" THEN "WA"
WHEN "986" THEN "OR"
WHEN "988" THEN "WA"
WHEN "989" THEN "WA"
WHEN "990" THEN "WA"
WHEN "991" THEN "WA"
WHEN "992" THEN "WA"
WHEN "993" THEN "WA"
WHEN "994" THEN "ID"
WHEN "995" THEN "AK"
WHEN "996" THEN "AK"
WHEN "997" THEN "AK"
WHEN "998" THEN "AK"
WHEN "999" THEN "AK"
END