Monday, April 21, 2014

Jobs, Businesses, and Income (2001-2011)

For DFW area counties, taken from US Dept of Commerce census data:

Dallas County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 1239445 68003484 61034 $54,866.08 $57,269.21 20.3074516
2001 1505640 63999089 63613 $42,506.24 $56,350.52 23.668747
Net -266195 4004395 -2579 $12,359.84 $918.69 -3.3612954
  -17.68% 6.26% -4.05% 29.08% 1.63% -14.20%
Collin County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 304938 16770189 18207 $54,995.41 $57,404.20 16.7483935
2001 207894 9127395 11855 $43,904.08 $58,203.64 17.5363981
Net 97044 7642794 6352 $11,091.32 -$799.44 -0.7880047
  46.68% 83.73% 53.58% 25.26% -1.37% -4.49%
Tarrant County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 687510 30348511 37210 $44,142.65 $46,076.09 18.4764848
2001 635894 21094910 33748 $33,173.63 $43,978.28 18.8424203
Net 51616 9253601 3462 $10,969.02 $2,097.82 -0.3659355
  8.12% 43.87% 10.26% 33.07% 4.77% -1.94%
Kauffman County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 19594 645775 1635 $32,957.79 $34,401.34 11.9840979
2001 18554 453531 1462 $24,443.84 $32,405.20 12.6908345
Net 1040 192244 173 $8,513.95 $1,996.15 -0.7067366
  5.61% 42.39% 11.83% 34.83% 6.16% -5.57%
Denton County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 166739 6620563 11449 $39,706.15 $41,445.27 14.56
2001 113375 3371726 8277 $29,739.59 $39,425.77 13.70
Net 53364 3248837 3172 $9,966.56 $2,019.50 0.87
  47.07% 96.36% 38.32% 33.51% 5.12% 6.32%
Rockwall County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 19861 627747 1721 $31,607.02 $32,991.41 11.54
2001 11640 286390 1076 $24,603.95 $32,617.46 10.82
Net 8221 341357 645 $7,003.07 $373.95 0.72
  70.63% 119.19% 59.94% 28.46% 1.15% 6.68%
Ellis County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 32677 1110570 2455 $33,986.29 $35,474.89 13.31
2001 28669 769775 2062 $26,850.43 $35,595.62 13.90
Net 4008 340795 393 $7,135.86 -$120.73 -0.59
  13.98% 44.27% 19.06% 26.58% -0.34% -4.27%
Parker County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 24484 895671 2217 $36,581.89 $38,184.18 11.04
2001 15083 366537 1562 $24,301.33 $32,216.28 9.66
Net 9401 529134 655 $12,280.56 $5,967.90 1.39
  62.33% 144.36% 41.93% 50.53% 18.52% 14.37%
Johnson County
Year Jobs Payroll Biz Salary 2014 $ Jobs/Biz
2011 32937 1221068 2510 $37,072.84 $38,696.63 13.12
2001 26995 651704 2216 $24,141.66 $32,004.59 12.18
Net 5942 569364 294 $12,931.18 $6,692.03 0.94
  22.01% 87.37% 13.27% 53.56% 20.91% 7.72%

The most interesting data from the above is that Dallas County is the only one that lost jobs during the period of 2001-2011.  I chose 2001 because that was Dallas County's peak number of total jobs.  Also worth noting that in 2014 dollars Dallas and Collin make by far the most on average, but Collin and Ellis were the only two to see reductions in payroll per job based on 2014 dollars.

*cut n pasted straight from excel, excuse any formatting issues.