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.
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 | Zip Code Distance (mi) | File Types |
|---|---|---|
| 1990 | 25 | dta, sas, csv, desc |
| 1990 | 50 | dta, sas, csv, desc |
| 1990 | 100 | dta, sas, csv, desc |
| 1990 | 500 | dta, sas, csv, desc |
| 1990 | ∞ | dta, sas, csv, desc |
| 2000 | 25 | dta, sas, csv, desc |
| 2000 | 50 | dta, sas, csv, desc |
| 2000 | 100 | dta, sas, csv, desc |
| 2000 | 500 | dta, sas, csv, desc |
| 2000 | ∞ | dta, sas, csv, desc |
| 2010 | 25 | dta, sas, csv, desc |
| 2010 | 50 | dta, sas, csv, desc |
| 2010 | 100 | dta, sas, csv, desc |
| 2010 | 500 | dta, sas, csv, desc |
| 2010 | ∞ | dta, sas, csv, desc |
| 2015 | 25 | dta, sas, csv, desc |
| 2015 | 50 | dta, sas, csv, desc |
| 2015 | 100 | dta, sas, csv, desc |
| 2015 | 500 | dta, sas, csv, desc |
| 2015 | ∞ | dta, sas, csv, desc |
| 2016 | 25 | dta, sas, csv, desc |
| 2016 | 50 | dta, sas, csv, desc |
| 2016 | 100 | dta, sas, csv, desc |
| 2016 | 500 | dta, sas, csv, desc |
| 2016 | ∞ | dta, sas, csv, desc |
Contact data@nber.org with questions, comments, or suggestions.
Related
Topics
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, and the Bulletin on Health — as well as online conference reports, video lectures, and interviews.
