Canadian Postal Code Database technical documentation visualization
Canada Post Licensed · 23 Years

Technical Specifications & Data Dictionary

Every column, with the exact name it carries in the file you download — plus formats, encoding, and the answers to the questions developers actually ask. Nothing here is behind a sales call.

892,960active postal codes
2021Census vintage
3file formats
12/yrupdates
Delivered around the 15th · Instant download

At a glance

Columns by edition
8 / 18 / 46
Delimiter
Comma, every field quoted
Line endings
CRLF
Empty values
Empty string, not NULL
Business bundle
18 files · 228 columns
Supplemental rows
≈1.1 million

What’s actually in the download

Standard and Deluxe are a single data file. Business is a bundle — the main table plus 17 Statistics Canada reference tables, each a separate file in every format you download.

FileWhat it is ColumnsEdition
canada-postal-code-database-STANDARDThe main table8Standard
canada-postal-code-database-DELUXEThe main table15Deluxe
canada-postal-code-database-BUSINESSThe main table, with census geography resolved onto every postal code43Business
…-SUPPLEMENT-CENSUS-DISSEMINATION-BLOCKThe smallest unit census data is published for27Business
…-SUPPLEMENT-CENSUS-DISSEMINATION-AREA400–700 people each — the level most demographic joins use22Business
…-SUPPLEMENT-CENSUS-SUBDIVISIONMunicipalities and equivalents18Business
…-SUPPLEMENT-DISSEMINATION-GEOGRAPHIES-RELATIONSHIP-FILEMaster crosswalk linking every census level by DGUID16Business
…-SUPPLEMENT-POPULATION-CENTREUrban cores and rural definitions13Business
…-SUPPLEMENT-CENSUS-TRACTStable neighbourhoods in larger centres10Business
…-SUPPLEMENT-CENSUS-CONSOLIDATED-SUBDIVISIONAdjacent subdivisions grouped into one statistical unit9Business
…-SUPPLEMENT-STREETAlternate and obsolete street names8Business
…-SUPPLEMENT-FEDERAL-ELECTORAL-DISTRICTAll current federal ridings, English and French names8Business
…-SUPPLEMENT-CENSUS-METROPOLITANAREASCMAs and Census Agglomerations8Business
…-SUPPLEMENT-PROVINCEAll 13 provinces and territories, bilingual names8Business
…-SUPPLEMENT-CENSUS-DIVISIONRegional districts, counties and equivalents7Business
…-SUPPLEMENT-MUNICIPALITYAlternate municipality names mapped to the official one7Business
…-SUPPLEMENT-DESIGNATED-PLACEPlaces recognised by Statistics Canada with no municipal government7Business
…-SUPPLEMENT-ECONOMIC-REGIONCensus Divisions grouped by economic character6Business
…-SUPPLEMENT-AGGREGATE-DISSEMINATION-AREASDAs grouped where populations are too small to publish5Business
…-SUPPLEMENT-ACCENTFrench accented names mapped to their unaccented form, both ways3Business

The supplements are reference tables, not extracts. The main table carries the UID for each census geography; the supplement carries everything else about it. Join on the UID — CensusDisseminationAreaUID to the dissemination area file, FederalElectoralDistrictUID to the riding file, and so on. In Access they arrive as PostalCodeSupplement_… tables.

Business totals 228 columns across 18 files — 46 in the main table and 182 across the supplements — and about 1.1 million supplemental rows. Every edition also includes the specification PDF. Column counts measured from the shipped Business bundle; the CSV names are listed here and the same data ships as Access and Excel.

Data Dictionary

Every column in the download, with the exact name as it appears in the file header, and the type from the specification sheet that ships with it. 8 in Standard, 18 in Deluxe, 46 in Business.

Every UID column is text, not a number. Census and electoral identifiers carry significant leading zeros — 001 is not 1 — and CensusTractName also has trailing zeros after a decimal point. Import them as character columns; letting a spreadsheet or an ORM guess “integer” silently destroys the code. Columns where this bites are marked leading zeros below.

Population and Dwellings are FSA-level. They are Statistics Canada counts for the Forward Sortation Area — the first three characters — so every postal code sharing an FSA carries the same pair of numbers. The census geography columns are different: those resolve to the individual six-character code. For small-area population, join CensusDisseminationAreaUID to the dissemination area table in the Business bundle rather than summing Population.

Column name Description Type Standard Deluxe Business
Core Geographic 9 fields799
PostalCodeThe Postal Code of the record.Example: M4M 0C1Char(7)
CityThe name of the city, town or village of the Postal Code.Example: HARE BAY BBVarChar(45)
CityMixedCaseThe name of the city, town or village of the Postal Code in Mixed Case format.Example: Valley PondVarChar(45)
ProvinceThe two-letter abbreviation for the province to that Postal Code.Example: SKChar(2)
ProvinceNameThe name of the province to that Postal Code.Example: SaskatchewanVarChar(45)—
LatitudeGeographic coordinate measured in degrees north or south of the equator.Example: 43.7173160000Decimal
LongitudeGeographic coordinate measured in degrees east or west of the Greenwich Meridian.Example: -53.5755900000Decimal
ElevationAverage elevation of the Postal Code in meters.Example: 17Integer—
AreaCodeThe telephone area code for this Postal Code.Example: 709VarChar(3)
Record Type, Time & Classification 8 fields Business adds 1178
RecordTypeDefines the type of Postal Code.Values: 1 street address · 2 street, route or general delivery · 3 lock box · 4 route service · 5 general deliveryChar(1)
AddressTypeA code denoting whether an address is in the form of a civic address or in the form of a delivery installation address.Values: 1 civic address · 2 delivery installation addressChar(1)——
CityFlagYes/No flag indicating if the Postal Code is marked as a general delivery address.Values: Y / NChar(1)—
TimeZoneThe time Zone Number for which this Postal Code belongs to.Example: 6Integer—
DSTIndicates whether they observe Day Light Savings Time.Values: Y / NChar(1)—
DSTBehaviorClassifies how the location handles daylight saving time: SEASONAL, STANDARD_ONLY, PERMANENT_DSTExample: STANDARD_ONLYVarChar(16)—
UTCOffsetStandardThe UTC offset actually observed at the location during the winter half of the year, in decimal hours.Example: -5.0Decimal(3,1)—
UTCOffsetSummerThe UTC offset actually observed at the location during the daylight-saving period (second Sunday of March to first Sunday of November).Example: -4.0Decimal(3,1)—
Census counts — FSA level 2 fields022
PopulationStatistics Canada population count for the Forward Sortation Area — the first three characters of the postal code, not the individual code.Example: 25052Integer—
DwellingsStatistics Canada total private dwellings for the Forward Sortation Area, on the same basis as Population.Example: 6471Integer—
Address & Street Detail 8 fields Business adds 8008
StreetNameThe official civic name of a roadway or artery as recognized by Canada Post.Example: KILGOURVarChar(45)——
StreetnameMixedCaseThe official civic name of a roadway or artery as recognized by Canada Post, in mixed case letters (not all uppercase).Example: Rte 201VarChar(45)——
StreetTypeCodeOfficial description used to identify the type of road or artery.Example: LANEVarChar(6)——
StreetDirCodeThe street direction component of an official street name.Example: EVarChar(2)——
StreetSuffixThe address suffix associated with the street address from number.Example: AVarChar(3)——
AreaNameMajor community name or greater municipality grouping that contains the street address or its delivery installation as recognized by the Canada Post.Example: HARE BAY BBVarChar(45)——
AreaNameMixedCaseMajor community name or greater municipality grouping that contains the street address or its delivery installation as recognized by the Canada Post in Mixed Case format.Example: Valley PondVarChar(45)——
MunicipalityNameThe name of the municipality this Postal Code is in.Example: HARE BAY BBVarChar(45)——
Statistics Canada Census Geography 11 fields Business adds 110011
CensusMetropolitanAreaUIDleading zerosUniquely identifies a census metropolitan area.Example: 015VarChar(3)——
CensusMetropolitanAreaNameCensus metropolitan area name.Example: St. John'sVarChar(100)——
CensusDivisionUIDUniquely identifies a census division (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code).Example: 1002VarChar(45)——
CensusDivisionNameCensus division name.Example: Division No. 1VarChar(255)——
CensusSubDivisionUIDUniquely identifies a census subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census subdivision code).Example: 1001446VarChar(7)——
CensusSubDivisionNameCensus subdivision name.Example: Bay de VerdeVarChar(255)——
CensusConsolidatedSubdivisionUIDUniquely identifies a census consolidated subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census consolidated subdivision code).Example: 1009001VarChar(7)——
CensusConsolidatedSubdivisionNameCensus consolidated subdivision name.Example: Division No. 2, Subd. EVarChar(255)——
CensusTractUIDleading zerosUniquely identifies a census tract within a census metropolitan area/census agglomeration (composed of the 3-digit census metropolitan area/census agglomeration unique identifier followed by the 7.2-character census tract name).Example: 5350010.01VarChar(10)——
CensusTractNameleading zerosEvery census tract is assigned a 7.2-character numeric 'name' (including leading zeros, a decimal point and trailing zeros).Example: 0136.02VarChar(255)——
CensusDisseminationAreaUIDUniquely identifies a dissemination area — 400–700 people, the smallest area all census data is published for, and the level most demographic joins should use.Example: 10010499VarChar(8)——
Electoral, Economic & Settlement Areas 8 fields Business adds 8008
FederalElectoralDistrictUIDUniquely identifies a federal electoral district (composed of the 2-digit province/territory unique identifier followed by the 3-digit federal electoral district code).Example: 35081VarChar(5)——
FederalElectoralDistrictNameFederal electoral district name.Example: University--RosedaleVarChar(255)——
EconomicRegionUIDUniquely identifies an economic region (composed of the 2-digit province/territory unique identifier followed by the 2-digit economic region code).Example: 4730VarChar(4)——
EconomicRegionNameEconomic region name.Example: Saskatoon--BiggarVarChar(255)——
PopulationCentreUIDleading zerosUniquely identifies a population centreExample: 0509VarChar(4)——
PopulationCentreNamePopulation centre nameExample: Grand BankVarChar(255)——
DesignatedPlaceUIDUniquely identifies a designated place (composed of the 2-digit province or territory unique identifier followed by the 4-digit designated place code)Example: 100163VarChar(6)——
DesignatedPlaceNameDesignated place nameExample: Island HarbourVarChar(255)——

Column names are reproduced exactly as they appear in the CSV, Excel and Access files, and types are taken from the specification sheet included with every download. Examples are real values from the shipped file. Business additionally ships 17 supplemental tables carrying a further 182 columns.

File formats & conventions

The same rows and the same columns in three formats. Pick whichever drops into your stack with least effort — nothing is held back from any of them. There is no pre-built SQL script for the Canadian data; import the CSV, which every engine does natively.

CSV Comma-separated values Recommended
Delimiter
, comma
Text qualifier
" double quote — every field is quoted, not only the ones containing a comma
Encoding
Windows-1252 (Latin-1), no byte-order mark — see the note below, this one matters
Line endings
CRLF (\r\n)
Header row
Row 1 carries the column names
Empty values
Empty string — "", never the word NULL
Business bundle
18 files: the main table plus 17 supplements
XLS Microsoft Excel
Format
.xls
Why fourteen files
892,960 rows far exceeds the 65,536-row .xls limit, so the main table ships split across 14 numbered workbooks — …-01.xls through …-14.xls
Header row
Row 1 in every workbook; data starts on row 2
Supplements
One workbook each, same names as the CSVs
Leading zeros
Preserved in the file. Excel will strip them on re-import unless the column is set to text first
MDB Microsoft Access
Format
.mdb
Compatibility
Access 2000 onwards, including 365
Structure
One table for the postal code data; each supplement arrives as its own table, named PostalCodeSupplement_…
Relationships
None defined — join on the UID columns yourself
Row limit
Not a problem here; the whole table fits one Access file

All three formats carry identical data. Business is much larger than the other two in every format because it also carries the 17 supplemental tables.

Things worth knowing before you import

Character encoding — read this one

  • The CSV is Windows-1252 / Latin-1, not UTF-8. It only affects Business: measured across the full national files, Standard and Deluxe carry zero non-ASCII bytes, because every name in them comes from Canada Post unaccented.
  • In Business the accents are confined to the eight Statistics Canada name columns — census division, CMA, economic region, electoral district and the rest. StatCan does not follow the postal convention, so Québec and Saint-André arrive as written.
  • Decoding it as UTF-8 either raises or mangles — Québec becomes Qu??bec.
  • Set the source encoding to Windows-1252 on import and convert to UTF-8 yourself if that is what your database uses.
  • Excel and Access carry the accents natively; this applies to the CSV.

Leading zeros will bite you

  • CensusMetropolitanAreaUID, PopulationCentreUID, CensusTractUID and CensusTractName all carry significant leading zeros. 001 is not 1.
  • CensusTractName also carries trailing zeros after a decimal point — 0100.03 is a name, not a number.
  • Import every UID column as text. Letting a spreadsheet or an ORM infer “integer” destroys the code silently.

Keys and joins

  • PostalCode is the key of the main table.
  • Everything else joins on a UID: dissemination area, census tract, riding, population centre, designated place, economic region.
  • Rural postal codes have no PopulationCentreUID — an empty value there is how you tell urban from rural.
  • Census tracts only exist in larger centres, so CensusTractUID is empty elsewhere by design, not by omission.

Empty values, and what is not empty

  • Empty means empty string, not NULL, in all three formats.
  • Street-level columns are only populated on street-address records; on lock box, route service and general delivery rows they are legitimately blank.
  • Population and Dwellings repeat across every postal code in an FSA. That is not duplication — it is the level the count is published at.

Importing the CSV

  • MySQL: LOAD DATA LOCAL INFILE 'canada-postal-code-database-BUSINESS.csv' INTO TABLE PostalCodes CHARACTER SET latin1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 ROWS;
  • PostgreSQL: COPY PostalCodes FROM '/path/to/canada-postal-code-database-BUSINESS.csv' WITH (FORMAT csv, HEADER true, ENCODING 'WIN1252');
  • SQL Server: BULK INSERT PostalCodes FROM 'C:\path\to\canada-postal-code-database-BUSINESS.csv' WITH (FORMAT='CSV', FIRSTROW=2, FIELDTERMINATOR=',', ROWTERMINATOR='0x0d0a', CODEPAGE='1252');
  • Create the target table with the column types from the data dictionary above — every UID as VARCHAR, not INT.

Sample downloads

Real records from the production file — not mock data. Each sample carries all three formats plus that edition’s specification sheet, so you can test the one you actually intend to use. No email required.

Standard

8 columns · 1,500 records

Postal code, city, province, coordinates, telephone area code, mixed-case city name and record type.

CSV · Excel · Access

Download sample 205 KB

Deluxe

18 columns · 1,500 records

Everything in Standard, plus full province name, time zone and DST, elevation, the city-type flag, and FSA-level population and dwellings.

CSV · Excel · Access

Download sample 262 KB

Business

46 columns · 1,692 records

Everything in Deluxe, plus street and address detail and the full census geography — and all 17 supplemental tables, cut to the rows these 1,500 postal codes reference so every join in the sample resolves.

CSV · Excel · Access

Download sample 2.8 MB

Sizes measured from the files themselves. All three samples are the same 1,500 postal codes — Toronto, Saskatoon, rural Newfoundland and Yukon — so you can lay the editions side by side and see exactly which columns each one adds. That spread is deliberate: it covers four time zones, both halves of the daylight-saving classification, and the half-hour Newfoundland offset. Column counts are the full counts for each edition — see the data dictionary for every name and type.

Technical FAQ

29 real questions from developers, DBAs and GIS teams working with this data. We have been answering them since 2003, so these are the ones that come up again and again — how the three editions differ, how the 17 census tables join back to the main file, and what to watch for when a postal code spans more than one province or census division. Answers, not marketing.

The Canadian Postal Code Database is a comprehensive electronic dataset containing all valid postal codes across Canada, enhanced with geographic coordinates, census linkages, and demographic data. The database includes approximately 900,000 postal codes covering urban, suburban, and rural areas nationwide.

Unlike raw Canada Post postal code files, our database adds significant value through latitude/longitude coordinates, Statistics Canada census geography integration, multiple delivery formats (Access, Excel, CSV), and monthly updates to ensure accuracy. The database supports address validation, geocoding, territory mapping, demographic analysis, and CRM/ERP system integration.

Each edition is designed for different use cases and organizational needs:

Feature Standard (8 fields) Deluxe (18 fields) Business (46 fields)
Core Data Postal code, city, province, area code, lat/lon Adds province name, timezone, DST, elevation, FSA population/dwellings Adds full address components, PCCF census linkage, all geographic identifiers
Census Integration None FSA-level population statistics Complete PCCF linkage: CMA, CSD, DA, DB, tract, FED, economic regions, etc.
Supplemental Tables None None 17 tables including municipality cross-reference, accent supplement, street supplement, and all census geography tables
Address Components City name only City name only Area name, street name, street type, direction, suffix, municipality
Best For Basic lookups, simple validation Operational systems, timezone routing, call center applications GIS integration, market analysis, demographic segmentation, territory planning
Recommended: Choose Standard for basic postal code lookups, Deluxe for operational needs requiring timezone and population data, and Business for analytics, demographic insights, or any application requiring census geography integration.

Our database enhances Canada Post postal code data with valuable additions not available in raw Canada Post files:

  • Latitude/Longitude Coordinates: We add geocoding data with ~99% coverage, enabling mapping and GIS applications
  • Statistics Canada Census Integration: Business edition includes pre-linked PCCF data, eliminating complex file joins
  • Multiple Formats: Available in Microsoft Access, Excel, and CSV formats for easy integration
  • Monthly Updates: Automated delivery of current data with 12 months of updates included
  • Supplemental Tables: Cross-reference files for municipalities, streets, and accented names (Business edition)
  • Enhanced Fields: Timezone, DST, elevation, population, and demographic data not present in basic postal code files

Our database is optimized for database integration with normalized fields, comprehensive documentation, and technical support, making it ideal for organizations needing postal code data in production systems without the complexity of managing raw Canada Post files.

All three formats are included with every purchase for the full 12-month license term:

  • Microsoft Access (.MDB): Relational database format with tables, indexes, and relationships pre-configured. Ideal for direct querying or integration with Access-based applications.
  • Microsoft Excel (.XLS): Spreadsheet format with data organized in worksheets. Suitable for analysis, reporting, or importing into business intelligence tools.
  • CSV (Comma-Separated Values): Universal plain-text format compatible with all database systems, programming languages, and data processing tools. Field delimiter is comma, text qualifier is double-quote.

All formats contain identical data and are updated simultaneously each month. You can use different formats for different purposes throughout your license term without additional cost.

The database contains approximately 900,000 active postal codes covering all Canadian provinces and territories. This includes:

  • Urban civic addresses (street addresses in cities and towns)
  • Rural route addresses (RR, suburban service, mobile routes)
  • Post Office Box addresses and lock box ranges
  • General Delivery addresses
  • Large Volume Receiver (LVR) postal codes

The database is updated monthly to reflect new postal codes added by Canada Post, retired postal codes, and changes to existing records. Each monthly update typically includes several thousand additions, deletions, and modifications.

Canadian postal codes are assigned to different address types based on delivery method:

Postal Code Type Description Geographic Representation
Civic Address Standard street addresses in urban and suburban areas (e.g., 123 Main St) Specific street location; coordinates represent actual delivery point or street segment centroid
Rural Route (RR/SS/MR) Rural Route, Suburban Service, or Mobile Route addresses serving areas without civic addressing Service area centroid; coordinates represent approximate center of route coverage area
PO Box / Lock Box Post Office Box addresses at postal facilities Post office location; coordinates represent the postal facility, not individual box holder addresses
General Delivery Mail held at post office for pickup in areas without home delivery Post office location serving the general delivery area
Large Volume Receiver Unique postal codes assigned to high-volume mail recipients (government, institutions) Actual building or facility location

The RecordType field in all editions indicates the postal code type, allowing you to filter or handle different address types appropriately in your applications.

Coordinates are derived from multiple validated sources and provide FSA-level accuracy with street-level precision in urban areas where data is available. Typical accuracy ranges from 50-500 meters depending on postal code type, with urban civic addresses being most precise.

Accuracy by postal code type:

  • Urban Civic Addresses: 50-200 meters (street-level precision in most cases)
  • Suburban/Small Town Addresses: 100-300 meters
  • Rural Route Addresses: 200-500 meters (service area centroid)
  • PO Box and General Delivery: Postal facility location (not individual recipient addresses)

Rural routes and PO Boxes represent approximate service area centroids rather than exact delivery points, as these postal codes serve geographic areas or postal facilities rather than specific street locations.

Coordinates are continuously validated and improved based on user feedback and cross-referencing with authoritative geographic sources. Coverage is approximately 99% of all postal codes, with the highest precision in urban centers.

Use Case Suitability: Coordinates are suitable for mapping, territory assignment, demographic analysis, and proximity calculations. They are not recommended for precision navigation or applications requiring meter-level accuracy.

Coordinate differences between data providers are common and result from several factors:

  • Geocoding Methodology: Different providers use different algorithms and reference datasets (street centerlines, building footprints, parcel boundaries, or address points)
  • Source Data Quality: Accuracy depends on the underlying geographic reference data, which varies by region and update frequency
  • Postal Code Geography: A single postal code may cover multiple street segments or a geographic area, requiring providers to choose a representative point (centroid, delivery point, or route midpoint)
  • Update Timing: Postal codes change over time as communities develop; coordinates may reflect different points in time
  • Rural vs. Urban Treatment: Rural postal codes lack precise street addresses, requiring approximation methods that vary by provider

For most applications (territory mapping, demographic analysis, proximity searches), differences of 100-500 meters are acceptable and do not impact results. If your application requires higher precision for specific postal codes, see the next FAQ for improvement strategies.

Several strategies can help you work effectively with postal code coordinates and improve accuracy where needed:

Validation and Quality Control:

  • Validate Against Known Addresses: Cross-reference coordinates for your critical locations (stores, facilities, customers) against known accurate addresses
  • Report Discrepancies: Contact us with specific postal codes that appear inaccurate; we continuously improve coordinates based on user feedback
  • Use FSA Centroids for Aggregation: For demographic or market analysis, use Forward Sortation Area (first 3 characters) centroids rather than full postal code coordinates to minimize precision requirements

System Design Considerations:

  • Implement Tolerance Thresholds: Design proximity searches and territory assignments with appropriate distance buffers (e.g., 500m-1km tolerance) to account for coordinate variability
  • Understand Postal Code vs. Civic Address Differences: Postal codes represent delivery areas, not individual buildings; civic addresses provide more precise geocoding when available
  • Use Address Validation: Combine postal code coordinates with full civic address validation for applications requiring high precision
  • Leverage Census Boundary Files: Business edition's PCCF linkage allows you to use Statistics Canada boundary files for precise geographic assignment rather than relying solely on point coordinates
Best Practice: For mission-critical applications requiring meter-level accuracy, consider implementing a hybrid approach: use our database for broad coverage and validation, supplemented by secondary geocoding services for high-priority addresses.

The Forward Sortation Area (FSA) is the first three characters of a Canadian postal code (e.g., "K2G" in "K2G 0P7"). It represents a broader geographic region used by Canada Post for mail sorting and routing.

Key Differences:

Characteristic FSA (First 3 Characters) Full Postal Code (6 Characters)
Format ANA (e.g., K2G) ANA NAN (e.g., K2G 0P7)
Geographic Coverage Broad area (neighborhood, district, or rural region) Specific street segment, building, or delivery installation
Number of Addresses Hundreds to thousands of addresses Typically 10-20 addresses (up to several hundred for large buildings)
Total Count in Canada ~1,643 FSAs ~900,000 full postal codes
Typical Use Market segmentation, demographic analysis, territory definition Address validation, precise delivery, geocoding

FSA Structure: The first character indicates province or region (e.g., K=Eastern Ontario, M=Toronto, V=British Columbia). The second character indicates urban (0) or rural (1-9). The third character defines a specific area within that region.

The Deluxe and Business editions include FSA-level population and dwelling counts from Statistics Canada, making FSA analysis useful for demographic profiling without requiring full postal code precision.

The database is updated monthly, with 12 updates included during your license term. Updates are typically released during the first week of each month and reflect changes from Canada Post as of the previous month's end.

Each monthly update includes:

  • New postal codes added by Canada Post
  • Retired or deleted postal codes
  • Changes to existing postal code attributes (municipality names, boundaries, etc.)
  • Coordinate refinements and corrections
  • Census geography updates (Business edition, when Statistics Canada releases new boundary files)

Updates are provided as complete database files in all three formats (Access, Excel, CSV). We do not provide delta/change-only files; each monthly release is a full replacement dataset.

Yes, all postal codes in the database are validated against Canada Post's official postal code data and represent currently deliverable addresses. Our monthly update process ensures:

  • Active Postal Codes Only: The database contains only postal codes currently in use by Canada Post for mail delivery
  • Retired Code Removal: Postal codes that Canada Post has retired or replaced are removed in monthly updates
  • New Code Addition: Newly created postal codes (for new developments, subdivisions, or address changes) are added as Canada Post releases them
  • Attribute Accuracy: Municipality names, provinces, and other attributes reflect current Canada Post designations

However, it's important to understand the scope of validation:

Important: The database validates that postal codes exist in Canada Post's system, but does not validate specific civic addresses within those postal codes. For example, "123 Main St, Toronto ON M5H 2N2" requires full address validation beyond postal code verification, as a postal code typically covers multiple street numbers.

For complete address validation (verifying both postal code and civic address correctness), you should integrate the database with address validation logic that checks street number ranges, street names, and municipality consistency.

These three columns were added in July 2026 to Deluxe and Business. They exist because the two fields that came before them cannot answer the question people actually ask.

TimeZone tells you which zone a postal code is in. DST tells you whether the clock moves there. Neither tells you what the offset is — and that is what you need to convert a timestamp, schedule a delivery window, or stamp a record with local time. The three new columns give you the resolved answer for both halves of the year.

The three values of DSTBehavior:

  • SEASONAL — the clock moves. The summer offset is one hour ahead of the standard offset. This is most of Canada.
  • STANDARD_ONLY — the clock never moves. Both offsets are the same value, and that value is the location’s standard time.
  • PERMANENT_DST — the clock never moves, but the fixed offset is the one the location used to observe in summer. Several Canadian jurisdictions have legislation of this kind at various stages, not all of it in force, so treat membership of this category as something to read from the file rather than to assume from the news.

Why the offsets are decimals and not integers. Newfoundland is -3.5 / -2.5 — UTC−3:30 in winter and UTC−2:30 in summer. It is the reason the columns are declared Decimal(3,1). Rounding them to whole hours, or reading them into an integer column, puts every Newfoundland record thirty minutes wrong.

Worked examples, all real records from the current file:

Postal codePlace DSTBehavior StandardSummer Why it is interesting
M5HToronto, ON SEASONAL−5.0−4.0 The ordinary case — Eastern, clocks move
R3CWinnipeg, MB SEASONAL−6.0−5.0 Central, clocks move
S7KSaskatoon, SK STANDARD_ONLY−6.0−6.0 Saskatchewan does not observe daylight saving at all
A1CSt. John’s, NL SEASONAL−3.5−2.5 The half-hour zone
A2VLabrador City, NL SEASONAL−4.0−3.0 Same province as St. John’s, different zone — most of Labrador is on Atlantic time
Y1AWhitehorse, YT STANDARD_ONLY−7.0−7.0 Yukon stopped changing its clocks in 2020
P9NKenora, ON SEASONAL−6.0−5.0 Ontario, but Central — the province spans two zones
G0G 0B8Blanc-Sablon, QC STANDARD_ONLY−4.0−4.0 Quebec, but Atlantic standard year-round — and the rest of G0G is not
X0C 0A2Coral Harbour, NU STANDARD_ONLY−5.0−5.0 Nunavut’s one community that does not change its clocks — its neighbours in X0C do

Rules you can rely on:

  • Offsets are hours from UTC, negative west of Greenwich. Local time is UTC + offset.
  • Where DSTBehavior is SEASONAL, UTCOffsetSummer is always exactly one hour ahead of UTCOffsetStandard.
  • Where it is not SEASONAL, the two offsets are equal — so code that always reads the right column for the date is correct everywhere and needs no special case.
  • The changeover dates are the North American ones: second Sunday of March to first Sunday of November.
The mistake to avoid: do not derive the offset from Province. Four of the nine examples above are places where the province is the wrong unit — Newfoundland spans two zones, Ontario spans two, Quebec contains communities that opt out of daylight saving, and Nunavut contains one. Saskatchewan has a border city that follows its neighbour instead. The fields are published per postal code precisely because the province-level shortcut is wrong often enough to matter — and, as the last two rows show, so is the FSA-level one.

These columns describe the location, not an instant. To stamp a particular timestamp you still choose which of the two offsets applies based on the date — the file tells you what both of them are, and whether the choice matters at all.

Yes, the database includes bilingual naming support for Canadian locations, particularly important for Quebec and officially bilingual regions:

Standard and Deluxe Editions:

  • Municipality names are provided in their official Canada Post designation (may be English, French, or bilingual depending on location)
  • Province codes are standard 2-letter abbreviations (QC, ON, NB, etc.)
  • Mixed-case city names carry postal-standard spelling with proper capitalisation (e.g., "Montreal", "Quebec") — the accented display forms come from the Accent Supplement

Business Edition (Additional Bilingual Support):

  • Accent Supplement Table: Maps unaccented to accented name variations (8,315 records) with special character encoding for French diacritics
  • Municipality Cross-Reference Table: Includes alternate names in both English and French where applicable (8,126 records)
  • Street Names: full address components with French street type codes (RUE, BOUL, CHEMIN, etc.). Street names follow the same postal convention as city names — unaccented, with the Accent Supplement carrying the accented forms
  • Census Geography Tables: Federal Electoral District names provided in both English and French

The accent handling allows applications to perform searches using either accented or unaccented input while maintaining proper display formatting.

Canada Post publishes its place and street names without accents, so that is how they are stored — MONTREAL, not MONTRÉAL. Accents are handled in three places instead:

All Editions:

  • Mixed-Case Fields: CityMixedCase (all editions) and the address component fields (Business) carry proper capitalisation — Montreal rather than MONTREAL
  • Statistics Canada columns: the census geography names in Business are StatCan's own and are accented — Québec, Saint-André, Côte-ouest
  • Encoding: the Business CSV is Windows-1252 (Latin-1), not UTF-8 — read it as Windows-1252 and convert on the way in. Standard and Deluxe contain no accented characters at all, so the question does not arise for them. See File formats.
  • Database Collation: Access and Excel formats maintain accent-sensitive sorting and searching

Business Edition (Enhanced Accent Support):

The Accent Supplement Table (8,315 records) provides explicit mappings between unaccented and accented name variations using special character codes:

Accent Code Character Example
$Â$ME ? ÂME
*É*COLE ? ÉCOLE
%ÊFOR%T ? FORÊT
<ÇFRAN<AIS ? FRANÇAIS
@Î@LE ? ÎLE
;ÜM;LLER ? MÜLLER

This supplement enables fuzzy matching and search normalization, allowing users to find locations whether they type "Montreal" or "Montréal", "Quebec" or "Québec".

Implementation Tip: For search functionality, implement accent-insensitive matching using the Accent Supplement Table while displaying results with proper accented formatting from the main postal code records.

The Municipality Cross-Reference Table (8,126 records, Business edition only) maps alternate, abbreviated, or historical municipality names to their current official Canada Post designations.

Use Cases:

  • Address Validation: Resolve user input like "Milliken" to official name "Markham" for postal code validation
  • Historical Data Cleansing: Update legacy databases with old municipality names to current designations
  • Abbreviation Handling: Match common abbreviations (e.g., "St. John's" vs "Saint John's") to official forms
  • Regional Name Variations: Handle neighborhood names that users may enter instead of official municipality names
  • Municipal Amalgamation: Resolve former municipality names that were merged into larger jurisdictions

Table Structure:

Field Description Example
Alternate Name Historical, abbreviated, or regional name variant Milliken
Municipality Name Official Canada Post municipality name Markham
Type of Alternate Classification of alternate name type Historical / Abbreviation / Regional
Valid Flag Indicates if alternate name is currently valid V = Valid, I = Invalid/Historical
FSA Associated Forward Sortation Area L3R

The Valid Flag allows you to distinguish between current alternate names (which may appear on official documents) and purely historical names (useful for data archaeology but not current validation).

Integration Example: Before validating an address, check if the entered municipality exists in the Municipality Cross-Reference table. If found, use the official Municipality Name for postal code lookup. This significantly improves address validation success rates.

The Postal Code Conversion File (PCCF) is Statistics Canada's linkage file that connects postal codes to census geographic areas. It enables demographic and socioeconomic analysis by allowing you to attach census data to postal code records.

Our Business Edition Provides PCCF-Equivalent Linkage:

Unlike Statistics Canada's separate PCCF file (which requires complex joins and technical expertise), our Business edition includes census geography linkages pre-integrated directly into each postal code record. This provides the same analytical capability as PCCF without separate file management, complex joins, or additional licensing. Census geographies are already integrated into each postal code record, ready for immediate analysis.

Linked Census Geographies (Business Edition):

  • Census Metropolitan Area (CMA/CA): Major urban centers and surrounding areas
  • Census Division (CD): Counties, regional districts, or equivalent
  • Census Subdivision (CSD): Municipalities and equivalent areas
  • Census Consolidated Subdivision (CCS): Grouped municipalities
  • Dissemination Area (DA): Small, stable geographic units (~400-700 people)
  • Dissemination Block (DB): City blocks or equivalent small areas
  • Census Tract (CT): Neighborhoods in large urban centers
  • Federal Electoral District (FED): Parliamentary constituencies
  • Economic Region (ER): Economic analysis regions
  • Population Centre (PC): Urban core classification
  • Designated Place (DPL): Named communities

Practical Applications:

  • Demographic Profiling: Link postal codes to census profiles (income, education, household composition) for customer segmentation
  • Market Analysis: Aggregate sales data by census geography for market research and planning
  • Territory Planning: Align sales territories with census boundaries for demographic consistency
  • Site Selection: Evaluate potential locations using census demographic and economic indicators
  • Government Reporting: Report data by Federal Electoral District or other official boundaries
Business Edition Advantage: Provides the same census-to-postal-code linkage as Statistics Canada's PCCF without separate file management, complex joins, or additional licensing. Census geographies are already integrated into each postal code record, ready for immediate analysis.

The Business edition includes comprehensive census geography integration with 46 core fields in the main postal code table plus 17 supplemental reference tables.

Census Geography Fields (UIDs and Names):

Each postal code record includes both the unique identifier (UID) and descriptive name for the following census geographies:

Geography Level Description Typical Use
Census Metropolitan Area Major urban centers (100,000+) and surrounding municipalities Metro market analysis, urban planning
Census Division Counties, regional districts, or provincial equivalents Regional reporting, service area definition
Census Subdivision Municipalities (cities, towns, villages) and Indian reserves Municipal-level analysis, local government reporting
Dissemination Area Small, stable areas (~400-700 people); smallest standard geography Micro-market analysis, neighborhood profiling
Census Tract Neighborhoods in large CMAs (~2,500-8,000 people) Neighborhood analysis in major cities
Federal Electoral District Parliamentary constituencies (338 ridings) Political analysis, government constituent services
Economic Region Groups of census divisions with similar economic characteristics Economic development planning, labor market analysis

Additional Geographic Fields:

  • Street-Level Address Components: Area name, street name, street type, direction, suffix (for civic addresses)
  • Municipality Name: Official municipality designation
  • Population & Dwellings: FSA-level counts from census data

All census geography fields include both UID (unique identifier for database joins) and descriptive names (for reporting and display), eliminating the need for separate reference table lookups in most applications.

The Business edition eliminates the need for manual linkage - census geographies are already integrated into each postal code record. However, understanding the methodology helps you use the data effectively:

Pre-Linked in Database (Business Edition):

Each postal code record includes census geography UIDs (unique identifiers) and names in dedicated fields. Simply query the postal code to retrieve its associated census geographies:

-- Example: Find census data for a specific postal code
SELECT 
    PostalCode,
    CensusMetropolitanAreaName,
    CensusDivisionName,
    CensusSubdivisionName,
    CensusDisseminationAreaUID
FROM PostalCodes
WHERE PostalCode = 'K2G0P7';

Joining to Statistics Canada Census Profiles:

Once you have the census geography UID from a postal code, join it to Statistics Canada's census profile data using the UID as the key:

-- Example: Link postal codes to census demographic data
SELECT 
    pc.PostalCode,
    pc.City,
    pc.CensusDisseminationAreaUID,
    census.TotalPopulation,
    census.MedianHouseholdIncome,
    census.PercentUniversityDegree
FROM PostalCodes pc
LEFT JOIN CensusProfiles census 
    ON pc.CensusDisseminationAreaUID = census.DAUID
WHERE pc.Province = 'ON';

Using Supplemental Geography Tables:

The Business edition includes 17 supplemental tables with complete census geography reference data. These tables provide additional attributes beyond what's in the postal code records, such as Population Centre classifications, Federal Electoral District names in English and French, and hierarchical linkage files showing how different census geographies nest within each other.

Best Practice: For demographic analysis, use Dissemination Area (DA) as the finest geographic level for most applications. DAs are designed for stability across census cycles and have sufficient population for meaningful statistics while avoiding privacy suppression issues common with smaller geographies.

Yes, the Business edition's census geography linkage is specifically designed to enable demographic data appending. Here's how:

Method 1: Use Census Geography UIDs (Recommended)

Join postal code records to Statistics Canada census profile data using the census geography UID fields:

  1. Download Census Profiles: Obtain demographic data from Statistics Canada (available free at statcan.gc.ca)
  2. Choose Geography Level: Select appropriate level (DA, CSD, CT, etc.) based on your precision needs
  3. Join on UID: Match the UID field from postal codes to the geography UID in census profiles
  4. Append Demographics: Pull desired census variables (income, education, age, household size, etc.) into your postal code records

Available Demographic Data from Census:

  • Population and household counts
  • Age and sex distribution
  • Income statistics (median, average, distribution)
  • Education levels and field of study
  • Labor force characteristics and occupation
  • Housing characteristics (dwelling type, tenure, value)
  • Language and immigration status
  • Family and household composition
  • Commuting patterns and mode of transportation

Common Applications:

  • Customer Segmentation: Profile customer base by income, education, or lifestyle characteristics
  • Site Selection: Evaluate potential locations based on demographic fit
  • Market Sizing: Estimate addressable market using population and household counts
  • Direct Mail Targeting: Select postal codes matching target demographic profiles
  • Risk Assessment: Score credit or insurance risk using neighborhood demographics
Recommended Workflow: Enrich your customer database by joining customer postal codes to our Business edition, then join census geography UIDs to Statistics Canada profiles. This creates a comprehensive customer demographic view for segmentation and analysis without collecting sensitive personal information directly.

Two license types are available based on how you intend to use the database:

Regular Licenses (Internal Use):

  • Scope: Use within your organization for internal operations, analysis, or systems
  • User Tiers: Three tiers based on number of users: 1-5 users, 6-50 users, or 51+ users (enterprise)
  • Multi-Year Terms: Available in 1-year, 2-year, or 3-year terms with volume discounts
  • Permitted Uses: Address validation, internal reporting, CRM/ERP integration, sales territory mapping, customer analysis, operational systems
  • Restriction: Data cannot be redistributed, resold, or provided to external parties

Redistribution Licenses (External Distribution):

  • Scope: Embed data in commercial products, provide to clients, or otherwise distribute outside your organization
  • End-User Tiers: Three tiers based on number of end-users who will access the data: 1-5 end users, 6-50 end users, or 51+ end users
  • Term: 1-year only (multi-year not available for redistribution licenses)
  • Permitted Uses: SaaS applications, commercial software products, consulting deliverables, client-facing tools, API services

User Count Guidelines:

A "user" is any individual who accesses the database directly or indirectly through an application or system. Count all employees, contractors, or API consumers who interact with postal code data derived from the database.

Tier User Count Typical Organization
1-5 Users 1 to 5 individuals Small businesses, departments, consultants
6-50 Users 6 to 50 individuals Medium businesses, regional operations
51+ Users (Enterprise) 51 or more individuals Large organizations, enterprise deployments
Need Help Choosing? If you're unsure which license type or user tier applies to your situation, contact us at info@zip-codes.com or call 1-800-425-1169. We'll help you select the appropriate license for your needs.

The key distinction is whether data leaves your organization:

Scenario License Type Explanation
Internal CRM system used by 25 employees Regular (6-50 users) Data stays within your organization
Address validation on public website (10,000 visitors/month) Redistribution (51+ end users) External users access postal code data
SaaS product embedding postal code lookups for customers Redistribution Customers receive data through your product
Consulting firm providing postal code analysis to 3 clients Redistribution (1-5 end users) Clients receive postal code data as part of deliverable
Internal database accessed by 100 employees via reporting tools Regular (51+ users) High user count but all internal

Redistribution Indicators (Requires Redistribution License):

  • Embedding database in commercial software sold or licensed to customers
  • Providing postal code data or lookups to clients as part of consulting services or deliverables
  • Operating a public or client-facing API that returns postal code information
  • Including postal code data in reports, datasets, or analysis provided to external parties
  • Allowing partners, vendors, or contractors outside your organization to access the data

Regular License Use (No Redistribution):

  • Internal address validation for order processing, shipping, or customer records
  • Territory mapping and sales planning for internal use only
  • Demographic analysis and market research for internal strategic planning
  • CRM, ERP, or database enrichment for internal operational systems
  • Multiple departments or locations within your organization (count total users across all)
Gray Area Guidance: If your clients receive access to postal code data as part of your service - even if not the raw database itself - a Redistribution license is typically required. If you're unsure whether your use case constitutes redistribution, contact us to determine the appropriate licensing. We're here to help you stay compliant while meeting your business needs.

Yes, Regular licenses are available in 1-year, 2-year, or 3-year terms with significant volume discounts. Redistribution licenses are 1-year only.

Multi-Year Benefits:

  • Cost Savings: 2-year and 3-year terms offer 10% discounts compared to annual renewal pricing
  • Price Lock: Protect against future price increases for the duration of your term
  • Administrative Efficiency: Fewer renewal transactions and license management overhead
  • Continuous Updates: Receive all monthly updates throughout the multi-year term (24 updates for 2-year, 36 updates for 3-year)

Sample Pricing Comparison (Business Edition, 1-5 Users):

Term Price (USD) Annual Cost Savings vs. Annual
1 Year $499.95 $499.95/year -
2 Years $899.91 $449.96/year 10% discount
3 Years $1,349.87 $449.96/year 10% discount (avg)

Multi-Year License Details:

  • Monthly Updates Included: 12 updates per year for the entire term (e.g., 36 monthly updates for 3-year license)
  • All Formats Included: Access, Excel, and CSV formats for the full term
  • User Count Fixed: User tier selected at purchase applies for the entire term (cannot upgrade mid-term; contact us if needs change)
  • No Refunds: Multi-year licenses are non-refundable after 30 days; ensure user count and edition meet your long-term needs
Why Only 1-Year for Redistribution? Redistribution use cases often involve evolving end-user counts and business models. Annual terms provide flexibility to adjust licensing as your product or client base grows without being locked into outdated tier structures.

Each edition includes a progressively expanded field set designed for different use cases. Here are the key fields for each edition:

Standard Edition (8 fields):

PostalCode, City, Province, AreaCode, Latitude, Longitude, CityMixedCase, RecordType

Deluxe Edition (18 fields) - Adds:

ProvinceName, CityFlag, TimeZone, DST, Elevation, Population (FSA-level), Dwellings (FSA-level)

Business Edition (46 fields) - Adds 28 additional fields including:

  • Address Components: AreaName, StreetName, StreetTypeCode, StreetDirCode, StreetSuffix, MunicipalityName, AddressType
  • Census Geography UIDs and Names: CensusMetropolitanArea, CensusDivision, CensusSubdivision, CensusDisseminationArea, CensusTract, CensusConsolidatedSubdivision, FederalElectoralDistrict, DesignatedPlace, EconomicRegion, PopulationCentre

For every column with its type and edition availability, see the data dictionary above.

Yes, the database integrates easily with most address validation systems, CRM platforms, ERP systems, and custom applications. Standard formats (CSV, Excel, Access) ensure compatibility with virtually any technology stack.

Compatible Platforms and Systems:

  • CRM Systems: Salesforce, Microsoft Dynamics, HubSpot, Zoho, SugarCRM
  • ERP Systems: SAP, Oracle, Microsoft Dynamics 365, NetSuite
  • Database Platforms: MySQL, PostgreSQL, SQL Server, Oracle Database, MongoDB
  • Business Intelligence: Tableau, Power BI, Qlik, Looker
  • E-Commerce: Shopify, WooCommerce, Magento, BigCommerce
  • Custom Applications: Any platform supporting CSV import, ODBC, or database connectivity

Integration Use Cases:

  • Real-Time Address Validation: Query postal code table during data entry to validate city/province against entered postal code
  • Geocoding Service: Convert postal codes to lat/lon coordinates for mapping applications
  • Territory Assignment: Use census geography fields to assign customers to sales territories
  • Demographic Enrichment: Append census data to customer records based on postal code
  • Data Cleansing: Standardize existing address data against postal code reference
Technical Support: We provide integration assistance during your implementation. Contact info@zip-codes.com with specific questions about integrating with your platform or application architecture.

The Business edition includes 17 supplemental reference tables providing cross-reference data, census geography details, and alternate name mappings. These tables enhance the main postal code dataset and enable advanced address validation and demographic analysis.

Cross-Reference & Supplemental Data Tables (3 tables):

  • Municipality Cross Reference (8,126 records): Maps alternate, abbreviated, or historical municipality names to current official Canada Post designations. Includes valid/invalid flags and FSA associations for address validation and data cleansing.
  • Accent Supplement (8,315 records): Provides mappings between unaccented and accented name variations using special character codes. Enables accent-insensitive search while maintaining proper display formatting for French names.
  • Street Supplement (9,552 records): Links alternate or obsolete street names to current official names. Includes street types, directions, and municipality context for comprehensive address standardization.

Census Geography Reference Tables (11 tables):

  • Census Division (293 records): County, regional district, or equivalent boundaries with UIDs, names, and provincial associations
  • Census Tract (6,247 records): Neighborhood-level areas in large CMAs (~2,500-8,000 people)
  • Census Dissemination Area (57,936 records): Small, stable geographic units (~400-700 people); smallest standard geography for demographic analysis
  • Census Dissemination Block (498,786 records): City blocks or equivalent areas; smallest census geography
  • Census Consolidated Subdivision (1,757 records): Grouped municipalities for rural/small town analysis
  • Census Subdivision (5,161 records): Municipalities (cities, towns, villages) and Indian reserves
  • Census Metropolitan Area (156 records): Major urban centers (100,000+ population) and surrounding areas
  • Economic Region (76 records): Groups of census divisions with similar economic characteristics
  • Federal Electoral District (338 records): Parliamentary constituencies (ridings) with names in English and French
  • Population Centre (1,030 records): Classification of urban cores by population and density
  • Aggregate Dissemination Areas (5,433 records): Grouped dissemination areas for privacy-compliant demographic reporting

Geographic Reference & Relationship Tables (3 tables):

  • Province (13 records): Full names and abbreviations in English and French, plus numeric codes
  • Designated Place (1,685 records): Named population centers without official municipal status
  • Dissemination Geographies Relationship File (498,786 records): Hierarchical linkage showing how different census geographies nest within each other based on Statistics Canada 2021 DGUID structure
Usage Note: These supplemental tables are provided in separate files/worksheets within your database download. They are designed to be joined to the main postal code table via shared fields (UIDs, names, FSAs) or used as standalone reference data for geographic analysis and reporting.

Yes, all postal code types are included in the database: urban civic addresses, rural route addresses (RR/SS/MR), Post Office Box addresses, general delivery addresses, and Large Volume Receiver addresses.

The RecordType field identifies the postal code type, allowing you to filter or handle different address types appropriately in your applications.

Coordinate Accuracy by Type: PO Box and rural route coordinates represent approximate service area centroids, not physical street locations. These postal codes serve geographic areas or postal facilities rather than specific street addresses.
  • PO Box / Lock Box: Coordinates represent the postal facility location where boxes are located, not individual box holder addresses
  • Rural Route (RR/SS/MR): Coordinates represent the approximate center of the route's service area
  • General Delivery: Coordinates represent the post office serving the general delivery area

Implications for Applications:

  • Address Validation: All postal code types can be validated; civic address components (street, number) are only available for urban addresses
  • Geocoding: Coordinates are provided for all types but precision varies
  • Routing & Logistics: Rural routes and PO Boxes require special handling as coordinates don't represent delivery destinations
  • Demographic Analysis: Census linkage works for all postal code types; rural areas may have larger geographic coverage per postal code

Use the RecordType and AddressType fields (Business edition) to implement appropriate logic for different postal code types in your address validation and geocoding workflows.

Monthly updates are delivered through your online account with multiple access options:

Standard Delivery (All Customers):

  1. Account Download: Log into your account at account_database.asp using your username and password
  2. Access Current Release: Monthly updates are posted around the 15th of each month
  3. Download All Formats: All three formats (Access, Excel, CSV) are available for download simultaneously
  4. Full Database Files: Each monthly release is a complete database (not delta/change files); download and replace your previous version

FTP Access (Optional):

Customers can request FTP access for automated monthly retrieval. FTP credentials and directory paths are provided upon request, allowing you to configure automated pull scripts.

Download Specifications:

  • File Sizes: Vary by edition (Standard ~20MB, Deluxe ~30MB, Business ~150MB compressed)
  • Compression: Files are ZIP compressed to reduce download time
  • Access Period: All monthly releases from your license start date remain accessible throughout your license term

Technical Support: If you experience download issues or need alternative delivery arrangements, contact info@zip-codes.com or call 1-800-425-1169 for assistance.

Yes, you receive email notifications when each monthly update is released. Notifications are sent to the email address associated with your account.

Email Notification Content:

  • Announcement of the new release month (e.g., "October 2025 release")
  • Direct link to your account download page
  • Your account username (password not included for security)
  • Contact information for support questions

Managing Notifications:

  • Whitelist Our Address: Add info@zip-codes.com to your email whitelist to ensure delivery
  • Update Email Address: Contact us to change the email address receiving notifications
  • Unsubscribe: Notifications can be disabled via the unsubscribe link in each email (you'll still have account access)

Notification Timing:

Emails are typically sent within 24 hours of the update being posted to your account, usually during the first week of each month.

Important: Email notifications are a courtesy; you are not required to wait for notification to download updates. Check your account anytime to access the latest release. If you don't receive expected notifications, check your spam folder and ensure info@zip-codes.com is whitelisted.

Yes, FTP access is available upon request for automated monthly retrieval. FTP is particularly useful for organizations with automated data pipelines or those who want to eliminate manual download steps.

FTP Access Details:

  • Availability: Available to all license types and editions (Standard, Deluxe, Business)
  • Request Process: Contact info@zip-codes.com or call 1-800-425-1169 to request FTP provisioning
  • Provisioning Time: FTP credentials typically provided within 1-2 business days of request
  • Access Type: Pull-only access (you retrieve files from our server; we do not push files to your server)

FTP Configuration:

Upon approval, you'll receive FTP server address, username & password, directory path, and connection details (typically FTP port 21 or SFTP port 22).

Automated Pull Setup:

Customers configure their own FTP clients or automated scripts to pull updates on their preferred schedule. Files are posted to your FTP directory during the first week of each month (typically by the 5th). All three formats (Access, Excel, CSV) are available, and previous months' files remain accessible throughout your license term.

Customer Responsibility:

  • Configure and maintain your FTP client or automation scripts
  • Set your own retrieval schedule (daily, weekly, monthly)
  • Implement error handling and retry logic as needed
  • Manage storage and archiving of downloaded files
Why Pull-Only? We provide pull-only FTP access rather than pushing files to customer servers due to the wide variation in customer infrastructure, security policies, and timing preferences. This approach gives you complete control over when and how updates are retrieved while avoiding the complexity and cost of managing push delivery to diverse customer environments.

For assistance configuring FTP access or troubleshooting connection issues, contact our technical support team at info@zip-codes.com.

Still have a question? Call 1-800-425-1169 or email info@zip-codes.com — a person answers.

View pricing & editions Download a sample first