Data Access Information 

Datasets are available upon request.
However, please check for more details on this page before applying the data to your research.

Data by Topics

[A] Commuting Zones

[B] Metropolitan Statistical Areas

[C] Industry Code

[D] Industry Employment

[E] Industry Trade Exposure

[F] Government Fiscal Data

[G] Population Data

[A] Commuting Zones

Paper: "Dealing with Fiscal Stress: Cities versus Suburbs"



Questions You May Have:

Ans: Commuting zones (CZs), the concept for the local labor market, were developed by Tolber and Sizer (1996). They use county-level commuting data from 1990 Census data, and there are 741 clusters of counties. There are only 722 CZs in the entire mainland United States. 

The CZs are not included in my paper because of duplication or other issues; I drop:
1. drop #10600 keep #10700: they have the same largest cities in their CZs, Birmingham city, AL. #10700 is larger than #10600 in terms of population size.
2. drop #11304: District of Columbia has a very different character than other CZs
3. drop #20402: no fiscal data in suburbs in Nantucket County, MA
4. drop #27704: no fiscal data in central city in year 1992 and before
5. drop #30605: no fiscal data in suburbs in Culberson County, TX
6. drop #31304: no fiscal data in suburbs in Mason County, TX
7. drop #31503: no fiscal data in suburbs before 1992
8. drop #32306: no fiscal data in suburbs in Maverick County, TX
9. drop #32603: no fiscal data in suburbs in Baylor County, TX
10. drop #34101 - #34115: CZs are in Alaska state
11. drop #34701 ,34702 ,34703 ,35600: CZs are in Hawaii state
12. drop #34306: no fiscal data in suburbs in 30033 (fips_state_county) Garfield County, MT
13. drop #34307: no fiscal data in central city in year 1997 and before
14. drop #37902: no fiscal data in suburbs in 32021 (fips_state_county) Mineral County, NV
15. drop #39301: no fiscal data in suburbs in 53055 (fips_state_county) San Juan County, WA

[B] Metropolitan Statistical Areas

Papers: "Rent Capture by Central Cities," "Metropolitan Fragmentation and Transportation Investment"

Questions You May Have:

Ans: Metropolitan Statistical Areas (MSAs) are defined by the Census Bureau OMB (Office of Management and Budget) as an economic boundary different from commuting zones. MSAs include at least one county and only consider places with populations above 50,000.
There is no certain answer to this question because sometimes CZs > MSAs, sometimes MSAs > CZs.


Ans. I mainly follow Census 1990 definition to collect MSA data.

  1.     Download the county shape file: https://www.census.gov/geographies/mapping-files/time-series/geo/carto-boundary-file.1990.html#list-tab-1556094155

2.     Insert the shape file into ArcGIS or QGIS, and duplicate the layer (if you want to create a map with two layers)

3.     “Layer” > “Open Attribute Table” (where you can see the data)

4.     “Layer” > “Filter”> Click the county name you want to keep  

5.     “View” > “Identify Features”

6.     Define which county are in first ring(mc=2): touch main county boundary(mc=1, where central city is located)

7.     Define which county are in second ring(mc=3): touch first-ring county boundary(mc=2) but not touch main county boundary(mc=1)

We want to see suburban local governments in different economic environments. Some suburbs are small in population, but some are large enough to be twin cities or satellite cities.

Aggregating all suburban local governments into one unit will average out the local characteristic (possible advantage: internalizing the coordination/competition within suburbs; 
possible disadvantage: might exist aggregation bias).


I mainly target top quartile MSAs (around 70 MSAs) in terms of the population in the Census 1990 definition, and I notice that most of them have first-ring suburbs. Few of them (around 10 MSAs) have first-ring and second-ring suburbs. Only MSAs in VA state have first-ring, second-ring, third-ring, and fourth-ring suburbs.

[C] Industry Code

Papers: "Dealing with Fiscal Stress: Cities versus Suburbs", "Rent Capture by Central Cities"


Questions You May Have:

Ans: four-digit SIC industries; Pierce and Schott (2009) assign 10-digit HS products to four-digit SIC industries, ensuring each of the 397 manufacturing industries matches at least one trade code. 

Ans: County business patterns (CBP) reports employment data by county
and industry for 6-digit NAICS codes in 2000. However, in 1980 and 1990, CBP reports by the industry for 4-digit SIC codes. Based on Census "bridge" file, we can construct a weighted crosswalk file. (Details upon request)

[D] Industry Employment

Papers: "Dealing with Fiscal Stress: Cities versus Suburbs"


Questions You May Have:

Ans: County Business Pattern provides the most dis-aggregated employment data in Census years with more details than the remaining years.  

[E] Industry Trade Exposure

Papers: "Dealing with Fiscal Stress: Cities versus Suburbs"


Questions You May Have:

Ans: Generally, trade shocks are known as changes in import values per worker, import penetrations, or import exposure. However, Autor et al. (2021) define trade shocks as changes in import values divided by industry domestic absorption (US industry shipments plus net imports).

Ans: The baseline of the shock is from 2000 to 2012, one year before China joined WTO and after the culmination of the trade shock in 2010. Employees take time to migrate or find a non-manufacturing job, and we might only be able to see the complete adjustment along these margins after the shock reaches the peak. 

Ans. Acemoglu et al. (2016) collect US input-output data to build up supplier (upstream), and customer (downstream) import exposure shocks for both manufacturing and non-manufacturing industries. When customer industries are directly affected by trade shocks, the industries experience adverse employment effects. However, no evidence shows the employment changes in the industries when their suppliers are directly affected by trade shocks. 

[F] Government Fiscal Data

Papers: ALL

Questions You May Have:

Ans. I obtain government fiscal data from the Census Bureau: Annual Survey of State and Local Government Finances. The alternative source is: Pierson K., Hand M., and Thompson F. (2015). The Government Finance Database: A Common Resource for Quantitative Research in Public Financial Analysis. PLoS ONE doi: 10.1371/journal.pone.0130119
Most local governments usually report their fiscal data every five years, so I have to fill in the missing values (two methods: linear interpolation or constant growth rate). 

[G] Population Data

Papers: ALL

Questions You May Have:

Besides rusty belts, which cities are also declining in the United States?

Ans. A recent research I am working on finds that most of the declining cities started to decline from 1950.
1. Chicago city (msa_sc=15): the population maximum happened in 1950 and started declining till 1990. After 1990, it fluctuates, and the 2020 population is close to the 1990 size. 

2. Baltimore city (msa_sc=19): the population maximum happened in 1950 and started declining. 

3. Detroit city (msa_sc=21): the population maximum happened in 1950 and started declining. 2020 population only remains 1/3 of the size in 1950. 

4. St. Louis city (msa_sc=24): the population maximum happened in 1950 and started declining. 

5. Cincinnati city (msa_sc=30): the population maximum happened in 1950 and started declining. 

6. Cleveland city (msa_sc=31): the population maximum happened in 1950 and started declining. 

7. Toledo city (msa_sc=33): the population maximum happened in 1970 and started declining. 

8. Philadelphia city (msa_sc=37): the population maximum happened in 1950 and started declining. 

9. Pittsburgh city (msa_sc=38): the population maximum happened in 1950 and started declining. 

10. Milwaukee city (msa_sc=50): the population maximum happened in 1960 and started declining. 

11. Buffalo city (msa_sc=61): the population maximum happened in 1950 and started declining. 

12. Birmingham city (msa_sc=64): the population maximum happened in 1960 and started declining. 

13. Rochester city (msa_sc=66): the population maximum happened in 1950 and started declining. 

14. Akron city (msa_sc=91): the population maximum happened in 1960 and started declining. 

15. Dayton city (msa_sc=93): the population maximum happened in 1960 and started declining. 

16. Shreveport city (msa_sc=103): the population maximum happened in 1980 and started declining. 

17. Mobile city (msa_sc=105): the population maximum happened in 1960 and started declining. 

18. Jackson City (msa_sc=106): the population maximum happened in 1980 and started declining.