TDS Zip+4 Database
Data File Format

The data file is a tab delimited (.txt) text file.  
The fields contained are:

Field Name:				Field Contains:

ZIP_CODE				Numeric 5 digit zip code (non-unique)
PLUS_4_LOW				Plus 4 Extension Low
PLUS_4_HIGH				Plus 4 Extension High
RECORD_TYPE				4 equals zip 4 record, Z equals 5 digit zip record
STATE_ABBREV				2 letter state abbreviation
COUNTY_NAME				County Name
CITY_NAME				City Name
STATE_SALES_TAX				Numeric to 6 decimal places
STATE_USE_TAX				Numeric to 6 decimal places
COUNTY_SALES_TAX			Numeric to 6 decimal places
COUNTY_USE_TAX				Numeric to 6 decimal places
CITY_SALES_TAX				Numeric to 6 decimal places
CITY_USE_TAX				Numeric to 6 decimal places
MTA_SALES_TAX				Numeric to 6 decimal places
MTA_USE_TAX				Numeric to 6 decimal places
SPD_SALES_TAX				Numeric to 6 decimal places
SPD_USE_TAX				Numeric to 6 decimal places
OTHER1_SALES_TAX			Numeric to 6 decimal places
OTHER1_USE_TAX				Numeric to 6 decimal places
OTHER2_SALES_TAX			Numeric to 6 decimal places
OTHER2_USE_TAX				Numeric to 6 decimal places
OTHER3_SALES_TAX			Numeric to 6 decimal places
OTHER3_USE_TAX				Numeric to 6 decimal places
OTHER4_SALES_TAX			Numeric to 6 decimal places
OTHER4_USE_TAX				Numeric to 6 decimal places
TOTAL_SALES_TAX				Numeric to 6 decimal places
TOTAL_USE_TAX				Numeric to 6 decimal places
COUNTY_RPT_CODE				State Assigned County Tax Reporting Code
CITY_RPT_CODE				State Assigned City Tax Reporting Code
MTA_NAME				Metro Transit Area Name
MTA_NUMBER				Metro Transit Area Reporting Code
SPD_NAME				Special Purpose District Name
SPD_NUMBER				Special Purpose District Reporting Code
OTHER1_NAME				Other1 Name
OTHER1_NUMBER				Other1 Tax Reporting Code
OTHER2_NAME				Other2 Name
OTHER2_NUMBER				Other2 Tax Reporting Code
OTHER3_NAME				Other3 Name
OTHER3_NUMBER				Other3 Tax Reporting Code
OTHER4_NAME				Other4 Name
OTHER4_NUMBER				Other4 Tax Reporting Code
TAX_SHIPPING_ALONE			Y/N (see supplemental file for details)
TAX_SHIPPING_AND_HANDLING_TOGETHER	Y/N (see supplemental file for details)
FIPS_STATE				2 digit FIPS State Code
FIPS_COUNTY				3 digit FIPS County Code
FIPS_CITY				5 digit FIPS City Code
FIPS_GEOCODE				10 digit FIPS geocode
STATE_EFFECTIVE_DATE			Date (x/x/xxxx)
COUNTY_EFFECTIVE_DATE			Date (x/x/xxxx)
CITY_EFFECTIVE_DATE			Date (x/x/xxxx)
MTA_EFFECTIVE_DATE			Date (x/x/xxxx)
SPD_EFFECTIVE_DATE			Date (x/x/xxxx)
OTHER1_EFFECTIVE_DATE			Date (x/x/xxxx)
OTHER2_EFFECTIVE_DATE			Date (x/x/xxxx)
OTHER3_EFFECTIVE_DATE			Date (x/x/xxxx)
OTHER4_EFFECTIVE_DATE			Date (x/x/xxxx)
COUNTY_TAX_COLLECTED_BY			Who Collects the County Tax
CITY_TAX_COLLECTED_BY			Who collects the City Tax
COUNTY_TAXABLE_MAX			Dollar Amount or n/a
COUNTY_TAX_OVER_MAX			n/a or Numberic to 6 Decimal Places
CITY_TAXABLE_MAX			Dollar Amount or n/a
CITY_TAX_OVER_MAX			n/a or Numberic to 6 Decimal Places