Basic geocoded United States 5-digit ZIP and Canadian Postal Codes data. This product contains all United States ZIP codes and Canadian postal codes in a single package. Contains over 800,000 records.
Each record contains the ZIP or postal code, the preferred city or location name with state or province abbreviation and associated latitude and longitude coordinates.
Produced: on or before 5th calendar day quarterly
Current Release: April 2, 2024
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
Combined Postal Code Database Standard Edition Reference Manual
Combined Postal Code Database Standard Edition Sample Data
Postal Code Assignments File
| Field | Data Type | Field Description |
|---|---|---|
| PostalCode | VARCHAR(7) | The five or six character post code. |
| City | VARCHAR(64) | Name of city or location. |
| StateProvince | CHAR(2) | Official abbreviation of the state or province. |
| Country | CHAR(2) | ISO 3166 country code. |
| CityType | CHAR(1) | Postal Service recognition of the CITY field name
|
| PostalCodeType | CHAR(1) | The postal code definition or type for delivery purposes. |
| Latitude | DOUBLE | Latitude in decimal degrees to the center of the postal code. |
| Longitude | DOUBLE | Longitude in decimal degrees to the center of the postal code. |
SQL Table Definitions
CREATE DATABASE IF NOT EXISTS `postalcodestandard`;
USE `postalcodestandard`;
DROP TABLE IF EXISTS `postalcodes`;
CREATE TABLE `postalcodes` (
`PostalCode` CHAR(7) NOT NULL,
`City` VARCHAR(64) DEFAULT NULL,
`StateProvince` CHAR(2) DEFAULT NULL,
`Country` CHAR(2) DEFAULT NULL,
`CityType` CHAR(1) DEFAULT NULL,
`PostalCodeType` CHAR(1) DEFAULT NULL,
`Latitude` DOUBLE DEFAULT 0,
`Longitude` DOUBLE DEFAULT 0,
PRIMARY KEY (`PostalCode`));