When searching by name. It may best to start with city and state and then do fuzzy matching on all the results. The spelling of the name of a company doesn’t always match what you think.

for example, to find a company called “Gains Financial Services” in Indianapolis, Indiana, I would first search with

where = {“HQSTATE”: “Indiana”, “HQCITY”: “Indianapolis”}

which converts to

"where = {\"HQ_STATE\": \"Indiana"\, \"HQ_CITY\": \"Indianapolis\"}"

and then when fuzzy matching on all the results, I find that the closest match is

“Gains Finacial Sevices Inc”

Notice that “Financial” and “Services” are both misspelled and there is an “Inc” at the end.