Trade Flow Data Dashboard & Explore

TRADE FLOW DATA DASHBOARD

This Dashboard includes 2 tiles:

“Top 100 Destinations Trade Value Routes” is a map chart showing the largest 100 trade value routes from the filtered Origin region(s) to the filtered Destination region(s).
“Trade Flows Table” is a table chart listing Commodity and Trade Value between the filtered Origin and Destination region(s) for any commodity trade between the regions over the filtered Trade Value.

When viewing a Dashboard, use the filters to change the data points displayed. Filter options include:

Dollar Type: by default dollars are displayed in Real dollars, see Dollar Year
Data Year: most recent Data Year by default in County View and Commodity Table tiles. All available Data Years are displayed in the Year.
Dollar Year: by default dollars are shown in current-year dollars
Aggregation: Aggregation level of Commodities by default is the unaggregated 546 scheme
Commodity: no default set
Destination State: no default set
Destination County Name: No default set
Origin State: no default set
Origin County Name: Mecklenburg County, NC by default.
Trade Value: by default only trade values greater than 500,000 are displayed in the Trade Flows Table

The gear in the upper right provides more options such as downloading the Dashboard to a PDF. On each tile, click the Table Menu (a series of three vertical dots that appears in the upper right of a tile when hovering over it with your cursor) for the option to download the data within that tile. Choose “Explore from here” within the Table Menu to access more data query options. Exploring from the Dashboard allows you to dig into the data starting from the settings within the Dashboard tile.

EXPLORING TRADE FLOW DATA

Explore the Trade Flow Data by choosing Trade Flow Data from the Explore dropdown menu, or by choosing “Explore from here” from an Trade Flow Data Dashboard Tile or Look.

By default in Explore > Trade Flow Data, the Dollar Type is Real, the Dollar Year is the current year, and the Data Year is the most recent Data Year. With this setting, all dollar values included in a data query will be adjusted for inflation and displayed in current year dollars. It is recommended to always either filter or pivot on Data Year. Otherwise, data measures will be summed over Data Years. The default Aggregation Scheme Param is 546 Unaggregated. Commodity Dimensions will be available in the 546 Industry scheme with this setting.

EXPLORE: FILTER-ONLY FIELDS

Aggregation Scheme Param

The aggregation filter provides the option to view data by Commodity at one of the following levels of granularity:

546 Unaggregated: most granular. Data is available for each IMPLAN Commodity according to the most recent 546 Industry Scheme.
IMPLAN 2 Digit NAICS 546: Data is aggregated for Commodities corresponding to each 2 Digit NAICS.
IMPLAN 3 Digit NAICS 546: Data is aggregated for Commodities corresponding to each 3 Digit NAICS.

Download the aggregated NAICS to IMPLAN 546 Industries bridge for details.

Dollar Type

When Dollar Type is Real, Nominal dollar values are adjusted for inflation/deflation such that each dollar value Measures will be displayed in the selected Dollar Year(s). Dollar Year only applies when Dollar Type is Real.

When Dollar Type is Nominal, dollar value Measures will be unadjusted, therefore they will be displayed in the same Dollar Year as the Data Year.

EXPLORE: DIMENSIONS

Select a Dimension to include as a column with all Dimension possibilities. Filter a Dimension to specify which Dimension possibilities appear in the data query. Pivot a Dimension to transpose the Dimension rows into columns.

Dimensions	Details
Commodity	All IMPLAN Commodities (Code and Description) are possible Dimensions.
Commodity Code	All IMPLAN Commodity Codes (numbers) are possible Dimensions.
Commodity Description	All IMPLAN Commodity Descriptions (names) are possible Dimensions.
Data Year	All IMPLAN Data Years are possible Dimensions.
Destination County	“Destination” Dimensions refer to the recipient region where a commodity is demanded, either as intermediate demand (to be used as production input) or as final demand. All U.S. counties are possible Dimensions. When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected.
Destination County Fips	A County Fips is a three digit county code designated to counties within a given state. All U.S. County Fips are possible Dimensions. Note, County Fips are not state specific, therefore it is recommended to include and/or filter on the State Dimension in addition to this Dimension. A list of FIPS codes can be found at the following link: https://www.census.gov/geographies/referenc
Destination County Geolocation	The latitude and longitude of all U.S. counties are possible Dimensions.
Destination Description	All U.S. county names are possible Dimensions.
Destination Five Digit Fips	A Five Digit Fips is a county code. The first two digits indicate the state and the following three digits indicate the county. All U.S. Five Digit Fips codes are possible Dimensions. This Dimension is used to map the data in the County View Map Chart found on the Dashboard. A list of FIPS codes can be found at the following link: https://www.census.gov/geographies/referenc
Destination State	All 50 States plus the District of Columbia are possible Dimensions.
Destination State Fips	A State Fips is a two digit state code. States Fips for all 50 States plus the District of Columbia are possible Dimensions. A list of FIPS codes can be found at the following link: https://www.census.gov/geographies/referenc
Dollar Year	Years 1997 through 2060 are possible Dimensions. Dollar Year only applies when Dollar Type is Real.
Origin County	“Origin” Dimensions refer to the place of production. All U.S. counties are possible Dimensions. When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected.
Origin County Fips	A County Fips is a three digit county code designated to counties within a given state. All U.S. County Fips are possible Dimensions. Note, County Fips are not state specific, therefore it is recommended to include and/or filter on the State Dimension in addition to this Dimension. A list of FIPS codes can be found at the following link: https://www.census.gov/geographies/referenc
Origin County Geolocation	The latitude and longitude of all U.S. counties are possible Dimensions.
Origin Description	All U.S. county names are possible Dimensions.
Origin Five Digit Fips	A Five Digit Fips is a county code. The first two digits indicate the state and the following three digits indicate the county. All U.S. Five Digit Fips codes are possible Dimensions. This Dimension is used to map the data in the County View Map Chart found on the Dashboard. A list of FIPS codes can be found at the following link: https://www.census.gov/geographies/referenc
Origin State	All 50 States plus the District of Columbia are possible Dimensions.
Origin State Fips	A State Fips is a two digit state code. States Fips for all 50 States plus the District of Columbia are possible Dimensions. A list of FIPS codes can be found at the following link: https://www.census.gov/geographies/referenc

EXPLORE: MEASURES

Measures are displayed based on Dimension settings. Select a Measure to include as a column in the data query.

Measures	Details
Commodity Count	Count of unique commodities traded per county origin and county destination.
Trade Value	Value of trade in dollars.

Trade Flow Data "From the Data"

Dashboards

Explore

Written November 16, 2020

Articles in this section