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.

15th Annual Feldstein Lecture, Mario Draghi, "The Next Flight of the Bumblebee: The Path to Common Fiscal Policy in the Eurozone cover slide
  • Lecture
Dr. Mario Draghi, who served as President of the European Central Bank and Prime Minister of Italy, presented the 2023...
2023 Methods Lectures, Jesse Shapiro and Liyang (Sophie) Sun, "Linear Panel Event Studies" Primary tabs
  • Lecture
Overview: Linear panel event studies are increasingly used to estimate and plot causal effects of changes in policies...
2023, SI Economics of Social Security, Panel Discussion, "Long-Term Dynamics of the Employment-to-Population Ratio" Primary tabs
  • Lecture
Supported by the Alfred P. Sloan Foundation, the National Science Foundation, and the Lynde and Harry Bradley...