Skip to main content

Search Companies

Use the sample searches below as a guide to using the Search Companies database. If you're new to FDO, begin by experimenting with Basic Company Searches. For more complex scenarios, try some of the Advanced Company Searches.

Basic Company Searches:

Scenario 1 — Searching for companies by company name (index search)

One of the most basic types of searches is one in which a single indexed search field is used.

Question: How can I search for a particular company, such as Wal-Mart Stores, Inc.?

Answer: Conduct a Company Name index search.

Follow these steps:

  1. Open the Company Name Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  2. In the filter box type "W" to display all company names beginning with the letter "W."
  3. Scroll down to find the index entry for "Wal-Mart Stores, Inc." Click on it to automatically insert it into the Company Name search field.

  4. Click Search. The Company Search Results Screen appears and displays the one and only company record matching your search criteria.

  5. Click on "Wal-Mart Stores, Inc." to open the Company Record Display Screen and view the record.

Scenario 2 — Searching for companies by state and business type (index search)

Though still considered basic, a search in which more than one indexed search field is used is the first step in constructing more advanced search strategies. In fact, you're actually conducting a Boolean search because the Boolean operator and is automatically inserted "behind the scenes" between each search field. Your search will retrieve results containing matches in all search fields used.

Question: How can I search for companies located in New York that manufacture pharmaceuticals?

Answer: Combine a State index search with a Business Type (SIC) index search.

Follow these steps:

  1. Click on "More location options" under "Location".
  2. Open the State Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  3. Scroll down to find the index entry for "New York." Click on it to automatically insert it into the State search field.

  4. Open the Business Type (SIC) Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  5. In the filter box type "D" to display all business type terms beginning with the letter "D."
  6. Scroll down to find the index entry for "Drugs." Click on it to automatically insert it into the Business Type (SIC) search field.

  7. Click Search. The Company Search Results Screen appears and displays a list of company records matching your search criteria.

  8. Click on a company name to open the Company Record Display Screen and view the record.

Scenario 3 — Searching for companies by city and total sales (index search, range search)

In Scenario 2, we used more than one indexed search field in a single search. You can also use more than one type of search field in a single search. Again, though still considered basic, you're actually using an advanced search technique because the Boolean operator and is automatically inserted "behind the scenes" between each search field. Your search will retrieve results containing matches in all search fields used.

Question: How can I search for companies located in Chicago with total sales between $1,000,000,000 and $50,000,000,000?

Answer: Combine a City index search with a Total Sales range search.

Follow these steps:

  1. Click on "More location options" under "Location".
  2. Open the City Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  3. In the filter type "C" to display all cities beginning with the letter "C."
  4. Scroll down to find the index entry for "Chicago." Click on it to automatically insert it into the City search field.

  5. Use the drop-down menu to select "Total Sales," if it isn't already selected.
  6. Enter 1000000000 in the "From:" field and 50000000000 in the "To:" field.

  7. Click Search. The Company Search Results Screen appears and displays a list of company records matching your search criteria.

  8. Click on a company name to open the Company Record Display Screen and view the record.

Scenario 4 — Searching for companies by subsidiary state, establishment year, and keyword (index search, range search, keyword search)

In Scenario 3, we used two types of search fields in a single search. In all, there are three types of search fields available on the Search Companies Screen and all can be used simultaneously. Again, though still considered basic, you're actually using an advanced search technique because the Boolean operator and is automatically inserted "behind the scenes" between each search field. Your search will retrieve results containing matches in all search fields used.

Question: How can I search for companies with operations in New York that were established between 1900 and 2000 and that are publicly traded?

Answer: Combine a Subsidiary State index search with an Establishment Year range search and a keyword search.

Follow these steps:

  1. Open the Subsidiary State/Country Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  2. Scroll down to find the index entry for "New York." Click on it to automatically insert it into the Subsidiary State/Country search field.

  3. Use the drop-down menu to select "Establishment Year."
  4. Enter 1900 in the "From:" field and 2000 in the "To:" field.

  5. In the Keyword Search field, type public company.

  6. Click Search. The Company Search Results Screen appears and displays a list of company records matching your search criteria.

  7. Click on a company name to open the Company Record Display Screen and view the record.

Advanced Company Searches:

Scenario 5 — Searching for companies by county and multiple business types (index search, Boolean search)

Advanced searches often involve multiple search fields and the use of Boolean operators.

Question: How can I search for companies located in Los Angeles County that operate department stores or grocery stores?

Answer: Combine a County index search with a Business Type (SIC) index search using the Boolean operator OR.

Follow these steps:

  1. Click on "More location options" under "Location".
  2. Open the County Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  3. In the filter box type "L" to display all counties beginning with the letter "L."
  4. Scroll down to find the index entry for "Los Angeles." Click on it to automatically insert it into the County search field.

  5. Open the Business Type (SIC) Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  6. In the filter box type "D" to display all business type terms beginning with the letter "D."
  7. Scroll down to find the index entry for "Department stores." Click on it to automatically insert it into the Business Type (SIC) search field.

  8. In the filter box type "G" to display all business type terms beginning with the letter "G."
  9. Scroll down to find the index entry for "Groceries--retail." Click on it to automatically insert it into the Business Type (SIC) search field. The Boolean operator OR is automatically added to the search field between each index entry.

  10. Click Search. The Company Search Results Screen appears and displays a list of company records matching your search criteria.

  11. Click on a company name to open the Company Record Display Screen and view the record.

Scenario 6 — Searching for companies by metropolitan area and multiple business types (index search, Boolean search)

Question: How can I search for companies located in the Los Angeles, California, metropolitan area that sell health insurance and life insurance?

Answer: Combine a Metro Area index search with a Business Type (SIC) index search using the Boolean operator AND.

Follow these steps:

  1. Click on "More location options" under "Location".
  2. Open the Metro Area Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  3. Scroll down to find the index entry for "Los Angeles-Long Beach-Santa Ana, CA." Click on it to automatically insert it into the Metro Area search field.

  4. Open the Business Type (SIC) Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  5. In the filter box type "I" to display all business type terms beginning with the letter "I."
  6. Scroll down to find the index entry for "Insurance/accident and health." Click on it to automatically insert it into the Business Type (SIC) search field.

  7. Scroll down to find the index entry for "Insurance/life." Click on it to automatically insert it into the Business Type (SIC) search field. The Boolean operator OR is automatically added to the search field between each index entry. Change OR to AND.

  8. Click Search. The Company Search Results Screen appears and displays a list of company records matching your search criteria.

  9. Click on a company name to open the Company Record Display Screen and view the record.

Scenario 7 — Searching for companies by subsidiary city and excluding companies by keyword (index search, keyword search, Boolean search)

Question: How can I search for companies with operations in Chicago that are not ranked in the Fortune 1000?

Answer: Combine a Subsidiary City index search with a keyword search using the Boolean operator NOT.

Follow these steps:

  1. Open the Subsidiary City Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  2. In the filter box type "C" to display all subsidiary cities beginning with the letter "C."
  3. Scroll down to find the index entry for "Chicago." Click on it to automatically insert it into the Subsidiary City search field.

  4. In the Keyword Search field, type NOT Fortune 1000.

  5. Click Search. The Company Search Results Screen appears and displays a list of company records matching your search criteria.

  6. Click on a company name to open the Company Record Display Screen and view the record.

Scenario 8 — Searching for companies by subsidiary country and variations of keywords (index search, keyword search, wildcard search)

In Scenarios 5 through 7, we used various Boolean operators. Advanced searches also often involve the use of wildcard characters.

Question: How can I conduct a very broad search for companies with operations in China that are involved in the computer industry?

Answer: Combine a Subsidiary Country index search with a keyword search using the asterisk wildcard character.

Follow these steps:

  1. Open the Subsidiary State/Country Index by clicking on the View Index link located beneath its search field title on the Search Companies Screen.
  2. Scroll down to find the index entry for "China." Click on it to automatically insert it into the Subsidiary State/Country search field.

  3. In the Keyword Search field, type computer*.

  4. Click Search. The Company Search Results Screen appears and displays a list of company records matching your search criteria.

  5. Click on a company name to open the Company Record Display Screen and view the record.