Selecting by Country

The most reliable way to target a shipment's country of origin or destination is to the use the available destination_countries or origin_countries filters. These fields are computed by Panjiva through analysis of multiple underlying shipment attributes, and collectively provides the best-estimation of a shipment's origin or destination.

In this example, we are finding shipments that originate from the United Kingdom, and are destined for Canada.

{
  "data_source": "global",
  "filters": {
    "origin_countries": "United Kingdom",
    "destination_countries": "Canada"
  }
}

Targeting Port Location

Another way of targeting a shipment's estimated origin or destination is by selecting based on the country of the shipment ports. Within filters, both the port_lading_country and port_unlading_country are available as selection criteria.

note

The unlading port is not always the final destination. Sometimes a shipment is being transferred through a country on its way to a final destination.

Port Country Example

In this example, we are finding shipments that originate from a port within the United Kingdom, and are to be offloaded at a port in Canada.

{
  "data_source": "global",
  "filters": {
    "port_lading_country": "United Kingdom",
    "port_unlading_country": "Canada"
  }
}

Port Destination

If a shipment is being transferred from a port of unlading to another port, the port_destination_country may additionally be used to select for the final destination. Note, this attribute is not always reliably populated depending on the data-source.

Targeting Data-Source

Another method of targeting a specific country is to select for shipping records that come from a specific country and trade direction, also known as the data-source.

Some data-sources are available on their own, such as us-imports, however others are available only as part of the global data-source. When using the global data-source, the underlying data-source of a shipment record still may be selected by using the data-source filter.

tip

Please review the data-source documentation to learn more about using specific data-sources.

Top-Level Data Source

In this example, we are only selecting shipment records that originate from import records to the United States.

{
  "data_source": "us-imports"
}

Specific data-source within global

In this example, we are using the global data-source but selecting shipment records that originate from import shipping records to Mexico.

{
  "data_source": "global"
  "filters": {
    "data_source": "MexicoShipmentImport"
  }
}