TM_00508_All_adr and NPANXX file keys
The ALL_ADR.TXT file is a 7-column, comma-delimited table with the following format:
PCode, Primary/Alternate Location, State, County, Locality, Beginning Zip Code, Ending Zip Code
A frequently asked question concerns the purpose of the Primary/Alternate location flag. The best way to answer that is with an example -
It is set to either '0' or '1' depending on whether the corresponding location is a "Primary" location or an "Alternate" location. As an example, I am sitting in an office in Lenexa, KS. If you mailed me something and it was addressed to Lenexa, KS, you'd be sending it to my primary location. However, because the very first post office to serve this area was set up at the Shawnee Methodist Mission in the early nineteenth century, the whole area (which encompasses nearly a dozen cities - or "primary locations") is also referred to as "Shawnee Mission, KS." Thus, if you sent me mail addressed to Shawnee Mission, KS, you'd be sending to my alternate location instead of my primary location (and I'd still get the mail, by the way). There are many locations in the country with similar situations.
The NPANXX7.TXT file is a 2-column, comma-delimited table with the following format:
NPA-NXX, PCode
These two files can be used independently, or together to convert an NPA-NXX to PCode. To lookup the taxing jurisdiction information for a given NPA-NXX you would find the NPA-NXX in the NPANXX7.txt file, and obtain the corresponding PCode. The NPA-NXX at Avalara’s Overland Park office is 913-859, so from the data below the PCode is 1249200:
913856,1249600
913857,1267100
913858,1210800
913859,1249200
913860,1221200
913861,1289200
913862,1289200
Looking up this PCode yields the taxing jurisdiction of:
1249200,0,USA,KS,JOHNSON,LENEXA,66210,66210