To find all public companies with headquarters in Houston use Mergent Online (geographical search). To find all public companies with a location in Houston (branch, division, etc) use Reference Solutions (formerly Reference USA), run an Advanced Search...select Geography, tick City/State and enter Houston, TX, select Ownership, tick Public/Private Company.