Selecting by Company

The company data available is specific to each data-source, however below are some commonly available company data points and their respective selection methods.

Selection Type	Company Data
Text Search	Company name, address, and industry.
Filters	Company identifier, name, tax-number, country or region, employee count, annual revenue, market cap, or trade roles.

warning

Not all companies have associated metrics such as employee count or annual revenue. Using these types of filters will inherently limit the resulting set to companies with this available data.

Understanding shippers and consignees

Within shipment data, companies exist only in reference to being the shipper of goods, or the receiver of goods (referred to as the consignee). Due to the two-sided nature of this relationship, all company query and filter fields in the Panjiva API are scoped to either the shipper or consignee side of the shipment.

Searching against both SHIPPER and CONSIGNEE

In queries, use the company_data group to include both shipper and consignee fields, or define your own custom_group.

In filters, use the OR filter group and specify your desired value for both the consignee and shipper filters.

Filter Example

In this example we are trying to find all shipments for a company with ccn_id of 12345, regardless if the company is the shipper or the receiver.

{
  "data_source": "global",
  "filters": {
    "OR": [{
      "shipper_ccn_id": 12345
    }, {
      "consignee_ccn_id": 12345
    }]
  }
}

Company Identifiers

Companies are identified within the Panjiva dataset by either the ccn_id, pid, capiq_id, or the ultimate_parent_capiq_id. Please refer to the company entity documentation to learn more about each type.

Which company entity should I use?

For the most granular company results, use the pid entities as they are derived directly from the shipment data itself. For more aggregated results, use the capiq and capiq_ultimate_parent entities.

Examples

Searching by company name

In this example, we are selecting all shipments where the term electric is present in the consignee business name.

{
  "data_source": "global",
  "query": {
    "group": "consignee_name",
    "text": "electric"
  }
}

Filtering by company employee count

In this example, we are selecting for all shipments where the shipper has an estimated more than 1,000 employees.

{
  "data_source": "global",
  "filters": {
    "shipper_employee_count": {
      "gte": 1000
    }
  }
}