Data Extracts

Global corporate licensees to ComPair Data may extract data from ComPair Data in order to develop customized reports or to integrate data into their internal systems.

Two public extracts are currently available but we can also generate customized extracts from either existing data or from data resulting in additional research. ComPair will charge for customized research or for the cost of developing customized extracts but no additional data charges will apply.

The two existing public extracts are the Trade Route Report and the Port Competitive Extract.

These reports are only accessible from your corporate network.

Trade Route Report

The Trade Route Report permits the user to query the database on the services available on one or more trade routes and generates an MS Excel report with two spread sheets. Sheet 2a includes detail information about the services operating between the two trade regions including transit times between ports, average TEU and reefer capacities for the service, carriers participating in the service and more.

A second sheet, labeled 'Vessels' has detailed information about the vessels used by the services operating in the trade.

Port Competitive Extract

The port competitive extract also creates a MS Excel spreadsheet but is designed for users who want to download data into a database for for further analysis or to generate data for sales staff or other presentation. It is a port based query that allows for extracting data on services between operation on a particular port to port parings.  The resulting extract contains eight modular tables:

Ports
Trade Region
Trade Route
Alliances
Carriers
Service Trade Routes
Services -- including detail information a transit times and days of arrival and departure.

Competitive Extract Tool 

ComPair Data has release a MS Access tool that permits corporate users to extract data from the Competitive Extract into a MS Access database and then use that data to create one of nine standard reports included with the tool or to create their own customizable reports. Data can also be extracted to a MS Excel format.

You can view a demo of the Competitive Extract tool by clicking on the See Demo button above and you can download the latest version of the tool here.