| ZIP | CHAR (5) | The United States 5-digit ZIP code |
| City | VARCHAR (28) | City, organization, or entity name associated with the ZIP Code |
| Abbreviation | VARCHAR (13) | USPS abbreviation for the City name |
| CountyName | VARCHAR (25) | Name of primary county, parish, or borough for the ZIP Code location |
| StateName | VARCHAR (28) | Full name of the state or territory |
| State | CHAR (2) | USPS state or territory abbreviation |
| CityType | CHAR (1) | USPS recognition of the CITY name when used with this ZIP code |
| ZipType | CHAR (1) | General classification or type for the ZIP code |
| CSA | CHAR (3) | 3-digit OMB code of the CSA the ZIP code is located in |
| CBSA | CHAR (5) | 5-digit OMB code of the CBSA the ZIP code is located in |
| CBSA_DIVISION | CHAR (5) | 5-digit OMB code of the CBSA Division the ZIP code is located in |
| CBSA_STATUS | CHAR (1) | Specifies whether the CBSA is a Metropolitan or Micropolitan area |
| NECMA | DECIMAL(4,0) | Historical OMB 4-digit code of the New England County Metropolitan Area the ZIP Code is located in |
| Combined Necta | DECIMAL(3,0) | OMB 3-digit code of the Combined New England City and Towns Area the ZIP Code is located in |
| NECTA | DECIMAL(5,0) | OMB 5-digit code of the New England City and Towns Area the ZIP Code is located in |
| NECTA Division | DECIMAL(5,0) | OMB 5-digit code of the New England City and Towns Area division the ZIP Code is located in |
| MSA | CHAR (4) | 4-digit OMB code of the MSA the ZIP code is located in |
| PMSA | CHAR (4) | 4-digit OMB code of the PMSA the ZIP code is located in |
| FIPS | CHAR (5) | FIPS 5-digit county number |
| AreaCode | CHAR (3) | Predominate 3-digit telephone area code |
| Overlay | VARCHAR (28) | Additional telephone area codes in use when the predominate telephone area code is an overlayed area code. |
| TimeZone | CHAR (2) | Primary time zone the ZIP code is located within |
| DST | CHAR (1) | Daylight savings time is recognized within the area cover by this ZIP code |
| UTC | VARCHAR (28) | Time zone the ZIP Code is located in specified as a Universal Time Coordinate offset. |
| Latitude | DOUBLE | Latitude in decimal degrees of the geographic centroid of the ZIP code |
| Longitude | DOUBLE | Longitude in decimal degrees of the geographic centroid of the ZIP code |
| CustomerServiceArea | CHAR(1) | United States Postal Service Customer Service Area code for this ZIP Code |
| CustomerServiceAreaName | VARCHAR(35) | Name of the USPS Customer Service Area for this ZIP Code |
| CustomerServiceDistrict | DECIMAL(3,0) | United States Postal Service Customer Service Area District code for this ZIP Code |
| CustomerServiceDistrictName | VARCHAR(35) | Name of the USPS Customer Service Area District for this ZIP Code |
data sample
