Skip to main content

If the size of the full data file is too large and distances for only a handful of ZIPs is required, then running the calculations for the necessary ZIP codes only using the ZCTA centroid data file might be one helpful approach.

ZIP Code Tabulation Areas (ZCTA) are from Census 2000 SF1, Census 2010 SF1, and Gazetteer files.

2010 and 2000 Decennial Census Short Form (SF1) ZCTA-level data for is also available.

Jean Roth created the SAS, Stata, and CSV distance files to make the data easier to use.

The size of the file increases with the radius. Smaller files (<= 25 or <= 50 miles) may be easier to use if only ZIP Code distances <= 25 or <= 50 miles respectively are needed. The ∞ has all combinations of ZIP Codes.

Information that might be helpful for opening the large files in Access or Excel is available.

Updates and changes.

Internal users can access the programs and data in a UNIX shell or RDP at /homes/data/distance, or on an NBER PC at Network Neighborhood --> NBER --> home --> data --> distance.

Data

Centroid, distance and smaller radius distance files are available for the following years for easier access. Each link has a the full distance file in csv, dta, and sas format, as well as folder containing similar files centroid data and 5, 25, 100, and 500 mile radius.  

     
     

Historical Data

Census ZCTA Centroids

Year File Types
1990 dta, sas, csv, desc
2000 dta, sas, csv, desc
2010 dta, sas, csv, desc
2015 dta, sas, csv, desc
2016 dta, sas, csv, desc

Census Zip Code Distance Data

Year File Types
1990 dta, sas, csv, desc
2000 dta, sas, csv, desc
2010 dta, sas, csv, desc
2015 dta, sas, csv, desc
2016 dta, sas, csv, desc

Contact data@nber.org with questions, comments, or suggestions.

Related

Data Categories

More from NBER

In addition to working papers, the NBER disseminates affiliates’ latest findings through a range of free periodicals — the NBER Reporter, the NBER Digest, the Bulletin on Retirement and Disability, the Bulletin on Health, and the Bulletin on Entrepreneurship — as well as online conference reports, video lectures, and interviews.

2024, 16th Annual Feldstein Lecture, Cecilia E. Rouse," Lessons for Economists from the Pandemic" cover slide
  • Feldstein Lecture
Cecilia Rouse, president of the Brookings Institution and a professor at Princeton University, who chaired the Council...
 2024 Methods Lecture, Susan Athey, "Analysis and Design of Multi-Armed Bandit Experiments and Policy Learning"
  • Methods Lectures
Background Materials:backgroundAthey, Susan, Undral Byambadalai, Vitor Hadad, Sanath Kumar Krishnamurthy, Weiwen Leung...