Our ZIP Code Database is set of all U.S. ZIP code data put into row and column format for easy use and manipulation. The free version comes with 7 data fields for every ZIP code in the United States.
Zip Code By Dma
It has all the basic information you need to validate ZIP Code entry and basic mapping. Use our ZIP Code data on your website for easy lookups and data filling. Multiple data formats - Excel, Access, CSV, and SQL for easy use.
Immediately download the data. 2010 Census Population. Updated Monthly. Download the Free ZIP Code Database. You must create an account to access the monthly database. A valid email address is required.
Download all file formats (Access, Excel, CSV, and SQL). First Name:. Last Name:.
Email:. Password:. Confirm Password: An email will be sent to the address entered confirmation before you can download. Need More Detailed Data?
Try our professional ZIP Code Databases. Immediate Download after purchase. 1 Year Subscription with Monthly Updates. Multi-Year Licenses available. All subscriptions are not automatically renewed.
Visa, Mastercard, American Express, or Mail In Check/Purchase Order accepted. Download all file formats if needed (Access, Excel, Comma Delimited, and SQL). Learn more about our Professional. Database Technical Specifications Downloads. Free Database:.
Standard Database:. Deluxe Database:. Business Database: Field Name Data Type Description ZipCode Char(5) 9 Five digit numeric ZIP Code of the area. State Char(2) 2 letter state name abbreviation. City VarChar(35) Name of the city as designated by the USPS.
Latitude Decimal(12, 4) Geographic coordinate as a point measured in degrees north or south of the equator. Longitude Decimal(12, 4) Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian. ClassificationCode Char(1) The classification type of this ZIP Code.
Population Integer The population of the ZIP Code based on 2010 Census data. ZIP Code Database FAQs.
Q. What methods of payment do you accept? We accept Visa, Mastercard, American Express, and PayPal for immediate download. You can also place your order choosing Mail In Check or Purchase Order but you will be unable to download the database until your payment is received.
Do you accept purchase orders? Yes, we can accept purchase orders. Simply go through the order process as normal.
When you come to the payment screen, choose Purchase Order as the payment type and complete your order. You can then print out a purchase order and mail in the payment. Once payment is received, access to download the database will be turned on.
What format does the database come in? Our US ZIP Code Database is provided in three (3) formats: Microsoft® Access MDB, Microsoft® Excel XLS, and ASCII Comma Delimited CSV. How do I get the monthly database updates? When you purchase, you setup a username and password. Each month, we will notify you via email that an updated database is available. Visit our site and login using your username and password.
The updated databases will be available for download in any format we provide as well as a transactional log file with just the changes only. Will a CD be mailed to me?
How do I get the database? No, our US ZIP Code Database is not mailed to you on CD. Once your order is completed, you will be able to download immediately. All monthly updates are also provided for online download. This ensures fastest delivery as the database is updated each month. What happens after my 1 year subscription?
When your ZIP Code Database subscription is expiring, we will notify you by email 30, 10, and 1 day in advance. You can choose to renew at the current rate, or let your subscription expire. You can continue to use the database after your subscription has expired, but if you don't renew, you won't continue to get monthly updates. How much does it cost to renew?
Currently, renewal prices are the same as the original purchase price. Do you include ZIP Codes for the entire United States? ZIP Code data is provided for all 50 U.S. States, Washington DC, Puerto Rico, Virgin Islands, Guam, and APO/FPO Military ZIP Codes.
Why do some ZIP codes only have 3 or 4 digits in Excel? Several ZIP Codes start 0 or 00. Excel interprets the column as numeric data, therefore it removes all preceding zeros. The data is good, it is simply Excel formatting the output. To correct this, open the spreadsheet. Highlight the column by clicking on 'A' above the ZIP Code Label. From the menu at the top of the application, choose 'Format' and then 'Cells'.
On the popup window, choose 'Special' from the 'Number Tab' section, and then choose 'ZIP Code' to the right. The ZIP Codes should now be formatted properly.
How often do you update the database? Our ZIP Code Database is updated every month. How current is the data? Our ZIP Code Database is updated every month. The data is current as of February, 2018 Q. What are the sources of the data?
Our ZIP Code Database is licensed and compiled from various sources. Postal and Delivery data comes from the USPS, Demographic data from the US Census, Statistical Areas from the OMB (Office of Management & Budget), private data sources, and some are computed by Zip-Codes.com. How accurate is the data? Accurate data is critical to the success of your business and ours. Zip-Codes.com implements a very rigorous set of data integrity checks to ensure our database is as accurate as possible.
In the unlikely event that a portion of data is confirmed as inaccurate, we will correct it within 2 business days. Do you have any other countries besides the U.S.? We also have the.
How long does it take to get the data? As soon as your order is confirmed and payment is received, you can download the database. Can I automate the database delivery?
Please email us requesting an FTP Account be setup for you to use in automating your processes. Please include your username or order number for reference.
We will have it up and running within 1 hour. Do ZIP Codes change often? ZIP code data changes frequently.
Every year there are thousands of changes to the USPS ZIP Code records. Cities are added and removed.
ZIP codes are created or discontinued. Corrections are made. Boundaries change. Streets are added and street names change.
Within a short time period, the database will be outdated if you do not download it every month. Do you sport Military APO/FPO/DPO ZIP Codes??
Overseas military post offices operated or supported by the Army or Air Force use the city abbreviation APO Army Post Office / Air (Force) Post Office, while overseas military post offices operated or supported by the Navy, Marine Corps or U.S. Coast Guard use the city abbreviation FPO (Fleet Post Office). Recently, the Department of State has begun establishing a semi-independent overseas postal system. Their city abbreviation is DPO. As of March 2009, less than 10 U.S. Embassy locations are known as DPOs. The other approximately 90 overseas U.S.
Embassy post offices fall under the management oversight of the military services and so are known as either as APOs or FPOs. Three quasi-state codes have been assigned depending on the (approximate) geographic location of the military mail recipient and also the carrier route to be taken. They are:. AE (Armed Forces Europe / Canada / Middle East / Africa) - 09XXX. AP (Armed Forces Pacific) - 962XX through 966XX. AA (Armed Forces Americas excluding domestic and Canada) - 340XX Q. Do you have DMA information?
No, Nielsen is the provider of that data and they do not allow others to redistribute it. If you need it, you need to go directly to them to get it at Nielsen.com Q. How long have you been in business? We have been selling our databases online since 2003 and have become the most trusted source of ZIP code data. What separates you from your competitors?
What separates us from our competitors is our level of customer service. We are here every day and we answer the phones during business hours.
If you have a question or problem, we are here to help you. Additionally, we provide the most comprehensive database at the most competitive price. Our competition doesn't even come close. Try calling them!
Also, our rigorous data integrity checks make our data the most accurate you can purchase. Multiple County Data in the Business Database NEW!
The Zip-Codes.com Business ZIP Code Database now comes with Multi-County Data. ZIP Codes are assigned by the US Postal Service and as such, do not follow State, County, or even City boundaries. Many ZIP Codes even cross county borders (about 25%). With the Business Database, you can now know every county a ZIP Code covers. The data is provided in a separate file (or separate table for our Access MDB users). This secondary file/table gives you every ZIP Code, as well as the State and County information that it falls into. Each ZIP Code that falls into more than one State/County will be listed in this table for each State and County it covers.
In addition to this, we have added a 'Multi County Flag' column in all versions of our ZIP Code Database. This column will give a 'Y' indicating flag letting you know this ZIP Code is located in more than one county making it even easier to use. ZIP Code Tools & Resources Zip-Codes.com offers our customers several free applications, tools, and sample code. We hope these tools make your life a little easier with regards to manipulating our databases.
Tutorials These tutorials will walk you through the process of performing different functions that can be achieved by using our ZIP Code Database. Database Scripts These scripts work on your SQL Server or MySQL Server establishing the table, columns, and column definitions before importing the data. To use them, execute the full file contents in Enterprise Manager, SQL Server Management Studio, phpMyAdmin, or other SQL Command Interface.
SQL Server 2000 & 2005. Standard Database. Deluxe Database. Business Database MySQL. Standard Database. Deluxe Database. Business Database Sample Code The sample code provided here is meant as an example of how some functions can be performed.
DMA Data Reports. ZIP by DMA. The ZIP by DMA database provides ZIP Code listings within U.S. Counties by DMA region. The ZIP by DMA report is produced annually and consists of three sections:. Alphabetical sequence by DMA name. Numeric sequence by ZIP Code.
Universe Estimates by DMA name. Data files for ZIP by DMA are available via Excel® and delivered via email. U.S. Television Household Estimates. Provides household population estimates for each DMA region.
Data includes county level data, county size designation, and TV penetration. Data file is available via PDF format only.
Thousands of businesses have relied on TRUCKADS® free designated market maps to assist them in making critical media buying decisions. In 2014, we began offering ZIP codes by designated market in a clear and concise format to complement. Postal ZIP® code data and U.S. Census data, properly organized by designated market, become an essential marketing tool for any organization, media buyer, marketer, researcher or advertiser seeking industry standard market specific data to help them target and market to U.S.
Zip Code List By Dma
Consumers and businesses. Other companies charge $6000+ for market ZIP® codes and market demographics. TRUCKADS® ZIP® Code data for all 210 designated markets is. Receive 2 Files for Each Designated Market ZIP® CODE DATA Grouped by Designated Market in Excel Format All U.S. Postal ZIP® code data is provided in one Excel® file for each designated market. Each file contains 8 data fields: 1) ZIP® Codes, 2) City Names, 3) State Codes, 4) Telephone Area Codes, 5) County FIPS Codes, 6) County Names, 7) Preferred and Alias City Names, and 8) ZIP® Code Type. ZIP® Codes updated every year.
Last update 10/2017. 8 DATA FIELDS 5 digit ZIP® Codes The ZIP® code field lists only valid 5-digit ZIP® codes currently defined by the USPS. Obsolete ZIP® codes which have been 'retired' by the USPS are purged every October. A particular ZIP® code may appear in more than one record if the USPS has defined more than one city name for that ZIP® code. City Names The City Name field identifies a city name associated with the ZIP® code by the USPS. There may be several different city names associated with a particular ZIP® code. If so, the ZIP® code will appear in several different records, each with a different city name.
State Codes Telephone Area Codes The telephone area code is the 'most prevalent' area code for that one ZIP® code. If multiple area codes apply to one ZIP® code, only the primary area code is listed. Overlay area codes are not listed. County FIPS Codes The County FIPS code is a 5-digit numeric field containing a unique numeric identification assigned to each county by the US government.
The County FIPS code field and the County Name field identify the 'most prevalent' county for the 5-digit ZIP® code listed in a given record. County Names Preferred and Alias City Names The Preferred flag can have one of three states, which indicates how that name can be used for delivery of mail to the associated ZIP® code. The three states are: P - This is the preferred city name for this ZIP® code A - This city name is approved (but NOT preferred) for this ZIP® code N - The city name is NOT approved for mail delivery to this ZIP® code ZIP® Code Type The ZIP® Code type field identifies special ZIP® codes used for PO Boxes, companies, or the military. DEMOGRAPHIC DATA Grouped by Designated Market in PDF Format All U.S.
Census population demographics and housing data are provided in one PDF® file for each designated market. Enounce my speed crack serial adobe reader. Each file contains 29 data fields for each county, plus a summary total page of each data field for all the counties. Also included is a designated market map and an alphabetical list of counties within the market area.
Census files updated every 10 years. Last update: 2010.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |