6 Replies Latest reply on Jun 26, 2017 11:33 AM by Man Tsui

    If You Only Have United States Zipcodes Can You Group Them To The State Level? (No State Only Zipcode)

    Joseph Pirraglia

      So if I only have the zipcode but no field for state can I find out which state these zipcodes belong too and have it show on the map?

        • 1. Re: If You Only Have United States Zipcodes Can You Group Them To The State Level? (No State Only Zipcode)
          Shawn Wallwork

          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

            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

              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

                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

                  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

                    The approach I'm trying is 3-digit 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 3-digit zip prefix
                    // 3-digit zip prefix based from USPS
                    // http://pe.usps.com/Archive/HTML/DMMArchive20050106/print/L002.htm

                    CASE 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