Effect of opening an Amazon fulfillment center on county private-sector employment: Percent change in employment two years before and after the opening

Common time effects

Years from warehouse opening Elasticity Elasticity, low estimate Elasticity, high estimate 
-2.5
-2.25 0.00% 0.00% 0.00%
-2 0.36% -0.35% 1.07%
-1.75 0.81% 0.20% 1.41%
-1.5 0.99% 0.24% 1.74%
-1.25 0.62% -0.22% 1.45%
-1  0.71% -0.27% 1.69%
-0.75 0.89% 0.18% 1.61%
-0.5 0.89% -0.05% 1.84%
-0.25 0.42% -0.75% 1.59%
0 0.34%  -1.13% 1.80%
0.25 0.39% -0.92% 1.70%
0.5 0.35% -1.06% 1.76%
0.75 -0.08% -1.80%  1.64% 
1 -0.35% -2.24% 1.54%
1.25 -0.60% -2.70% 1.51%
1.5 -1.32% -3.16% 0.52%
1.75 -1.63% -3.87% 0.61%
2 -0.90% -2.57% 0.77%

Division-specific time fixed effects

Years from warehouse opening Elasticity Elasticity, low estimate Elasticity, high estimate 
-2.5
-2.25 0.00% 0.00% 0.00%
-2 0.18% -0.50% 0.87%
-1.75 0.59% 0.00% 1.18%
-1.5 0.79% -0.07% 1.65%
-1.25 0.40% -0.58% 1.39%
-1  0.46% -0.58% 1.50%
-0.75 0.60% -0.06% 1.27%
-0.5 0.78% -0.15% 1.70%
-0.25 0.43% -0.61% 1.48%
0.48% -0.67% 1.63%
0.25 0.50% -0.39% 1.39%
0.5 0.56% -0.49% 1.61%
0.75 0.18% -0.95%  1.31% 
0.03% -0.96% 1.01%
1.25 -0.04% -1.09% 1.01%
1.5 -0.34% -1.33% 0.65%
1.75 -0.50% -1.58% 0.58%
2 0.20% -0.86% 1.27%

State-specific time fixed effects

Years from warehouse opening Elasticity Elasticity, low estimate Elasticity, high estimate 
-2.5
-2.25 0.00% 0.00% 0.00%
-2 0.14% -0.54% 0.81%
-1.75 0.39% -0.20% 0.98%
-1.5 0.51% -0.39% 1.42%
-1.25 0.38% -0.71% 1.47%
-1  0.53% -0.61% 1.68%
-0.75 0.45% -0.27% 1.17%
-0.5 0.57% -0.51% 1.65%
-0.25 0.55% -0.65% 1.75%
0.61% -0.60% 1.81%
0.25 0.42% -0.45% 1.29%
0.5 0.40% -0.80% 1.59%
0.75 0.29% -0.95%  1.53%  
1 0.07% -1.00% 1.15%
1.25 0.01% -1.15% 1.18%
1.5 -0.49% -1.85% 0.87%
1.75 -0.42% -1.79% 0.95%
2 0.35% -0.82% 1.53%

Notes: Cumulative employment effects are from a regression of county private-sector employment per capita on leads and lags of a count of fulfillment centers in that county as well as county fixed effects and county-specific linear time trends. The top, middle, and bottom panels, respectively, show specifications with common, Census division–specific, and state-specific time fixed effects. See the Appendix tables for results from other specifications. Regressions are weighted by mean county population, standard errors are clustered at the county level, and the figure shows 95 percent confidence intervals. We convert the marginal effects and standard errors into percent changes in employment by dividing coefficients by the sample mean employment-to-population ratio.

Sources: Authors' calculations from Quarterly Census of Employment and Wages employment data, Census population counts, and fulfillment center openings data described in the text.

View the underlying data on epi.org.