Company Attributes

Field Name	Description
ccn_id	The unique Panjiva identifier for this company
name	The text name of the company
country	Which country name for which this company is associated
profile_url	This is the URL to the company entity in the Panjiva web interface
record_count	This is the number of shipment records which matched the provided criteria, that the company was associated with
corporate_info	This is further company information for the company, as provided by S&P Capital IQ Pro

Company Entities, Representations, and Identifiers

Companies are represented in different ways within the Panjiva dataset:

Company Entity	Identifier	Source	Description
Company Country Name	ccn_id	Shipment Data	These are companies, aggregated by country, which are found in the Shipment data as either the shippers or receivers of shipments
Permanent Company Profile	pid or permanent_id	Shipment Data	These are companies that are scoped to either a buyer or supplier side, and are viewable in the Panjiva Desktop where the pid is in the URL
S&P Capital IQ Pro Company	capiq_id	S&P Capital IQ Pro	These companies originate from the S&P Capital IQ Pro dataset, which are then further combined with Panjiva shipment data and Company Country Name (ccn) company representations
S&P Capital IQ Pro Ultimate Parent	ultimate_parent_capiq_id	S&P Capital IQ Pro	These companies originate from the S&P Capital IQ Pro dataset and represent the top-level company of all related company subsidiaries