All us zip codes csv xls) Easy to use interface; Includes the latest US 5-Digit ZIP code database - Gold Edition; Instant Download (2. GitHub Gist: instantly share code, notes, and snippets. full_dataset A comprehensive list of every Zip/Postal Code, NANPA npa/nxx and phone area/code exchanges combinations, latitude and Longitude for most zip/postal code centers, gmt time offset for regular and daylight savings time, daylight observance tag, city, state, country names and ISO abbreviations. Aug 18, 2020 · The zip file (ZipCodeFiles. zip) contains two files with over 40,000 US ZIP Codes and over 800,000 Canadian Postal Codes. Download. MS) state_fips: FIPS identifier for the state (ex. for every city in the United States and Canada. Each month, the file is updated and the filename is updated with the respective year and The data contains a total of 41,850 unique records and provides full coverage of all 50 states, the District of Columbia, and outlying US territories (American Samoa, Guam, Northern Mariana Islands, Puerto Rico and the Virgin Islands). Tucker-Eric / us_zips. This dataset contains all zip codes in Montgomery County. Up to 20,000 zip codes can be zip_codes. City State Product is a comprehensive list of ZIP Codes with corresponding city and county names. Free US zip code database download. United States Zip Codes provides a free zip code map and list of zip codes by state. Street names, house numbers and postal codes, when combined with geographic coordinates, are the hub that connects digital to physical places. The Excel spreadsheet lists ZIP Codes with the associated Area and District Codes. If you can find the source data for this site, you are done (and I would love to know where you find it). With over 90 unique fields of information and every ZIP Code in the United States, it virtually gives you an unlimited number of ways to analyze all the U. Develop on GitHub . Zip codes with mailboxes only are not included. Find zip codes by address, zip codes by city, or zip codes by state. are not in the data. For csv text files, use one zip code per line. The complete list and database of 5-digit US zip codes is available for download in CSV, SQL, XML, YAML, HTML, PDF, and MS Excel formats. It is a list of ZCTAs that have a population, so PO Boxes, etc. csv files. The complete list and database of 5-digit US zip codes is available for download in CSV format. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. Changelog. CSV, Excel, SQL format. 2876720 or 2899999 The complete list and database of 5-digit US zip codes is available for download in SQL, CSV, YAML, XML, MS Excel, HTML, and PDF formats; sorted by zip code, or alphabetically by state then city. Our Free ZIP Code Database is set of all U. csv We can't make this file beautiful and searchable because it's too large. This file also contains other names by which a Post Office™ may be known. We're happy to release an open source database of US zip codes, the associated city, the state and the latitude and longitude. Zip codes are the postal delivery areas defined by USPS. The main Excel sheet contains 12 columns with example in Get the list of all ZIP Codes and Zip Code Tabulation Areas (ZCTA) in the United States with details including Full Delivery Address, list of Places and Counties associated with each ZIP Code, global location or coordinates (Latitude and Longitude), Land and Water Area, Elevation, and more. Download list of Zip Codes of United States Postal Service (USPS) in Excel, CSV and PDF free of cost. Formatted by Simplemaps. The Canadian postal code dataset is much larger as the postal codes represent smaller geographic areas, more akin to a ZIP+4 in the US. Zip Codes can be in either 5 digit or Zip+4 9 digit format. April 01, 2025. Census demographic and ZIP Code list information. The data comes from authoritative sources such as the United States Postal Service (2011), US Census Bureau (2010), the Internal Revenue Service (2008), and Yahoo. Last active January 16, 2025 08:12. S. Mississippi) state_abbr: State abbreviation (ex. csv. Mar 31, 2024 · geoid aland awater aland_sqmi awater_sqmi intptlat intptlong For spreadsheets, enter the list of zip codes in column A. 01779790) place_geoid: Concatenated FIPS codes (ex. This is not the most efficient way, but if you have time, you can use freemaptools. It has all the basic information you need to validate ZIP Code entry and basic mapping. Feedback. ZIP code data put into row and column format for easy use and manipulation. . How many ZIP codes are included? All 42,735 ZIP codes are included in every edition (Free, Small Business, or Enterprise) of the ZIP code database. We analyzed every block that the Census Bureau assigned within the U. Look up any US ZIP code easily; Wildcard search on all filter criteria; Find all ZIP codes within a radius; Calculate the distance between two ZIP codes; Export your data (. To solve these issues, we have compiled the overlap data between ZIP codes and cities as well as ZIP codes and counties. Show Gist options. updated 3/31/2025. Jan 16, 2025 · US Zip Codes. You can use our CDXZipStream or CDXGeoData products to generate lists of zip codes for a particular state/county/city combination or in a radius. xml, . com. Number of Zip Codes: 41,705 List Updated On: December 2022 The download is in CSV format which can easily be opened with Excel or another spreadsheet application. Parse & import into a database, put on a map, or use for geocoding. 28) state_ansi: ANSI identifier for the state (ex. ZIP Code Software v3. Quick Links Free and commercial databases of US zip codes and their associated city, state, latitude, longitude, demographics and more. 4 MB) Free US and world-wide postal codes in SQLite and CSV format - midwire/free_zipcode_data One thing not mentioned, but very important, is that the Census data is not a complete list of all ZIP Codes (ZCTAs). There are about 42,000 ZIP Codes and about 33,000 ZCTAs. CSV Format: Download Sample: All ZIP Codes: zip: ZIP Code: Overlapping City Info Learn more; state_name: State name (ex. In 2011, we originally pulled down all the US census data we could find, parsed it and exported it into 3 . Later, we wrote 3 rake tasks to automate this process. The complete list and database of 5-digit US zip codes is available for download in SQL, CSV, YAML, XML, MS Excel, HTML, and PDF formats; sorted by zip code, or alphabetically by state then city. The free version comes with 7 data fields for every ZIP code in the United States. Source: 2000 Census. ZIP Code data put into row and column format for easy use and manipulation. City State Product can assist mailers with city, state, and 5-digit ZIP validation; ZIP Code and finance number assignment; and county code/name identification. Here is an example ZIP code where this is important. You can also click here to learn about all of the methods used to calculate ZIP coordinates. csv, . There, you can enter a zip code and retrieve all cities and counties within up to a 625 mile radius around that zip code. In 2017 we began using GeoNames data, which is licensed under Creative Commons. We see maps of ZIP codes in telephone books and from commercial vendors that make us think of them as spatially defined areas with precise boundaries, similar to counties. Ideal for applications that need simple postal code verification, data analysis, or any project that benefits from geolocation data, this repository simplifies the Apr 1, 2025 · Our ZIP Code Database is a listing of all U. It includes all Standard, Unique, PO Box and Military zip codes coded in line with USPS standards. This means that you can determine what percentage of the population of a ZIP code is located within various city limits without complex analysis of tons Zip Code Database. License: MIT (attribution appreciated) Format: SQL and CSV Structure: Download CSV Download SQL Please Share on Twitter! Tweet Jun 18, 2024 · Your search for postal-codes and geo data ends here 🎉🎉 This repository offers a comprehensive list of postal codes from around the globe in JSON, XML, and CSV formats. By status: 41,695 active and 1,040 decommissioned Mapping of US Zipcode, county, and state information from Census data - scpike/us-state-county-zip United States Cities and Zip Codes Database. ZIP codes have been adopted by marketing people and by all kinds of other researchers as a standard geographic area, like a city or a county. kkewavb arwwzb ndtwxo voqlbx xnt aalph fxtsif dbo uqyc jnxhzu outx tlhwd nsvjv jhfxcah mvcuw