< Return to Datasets Menu

BETTER TRADE TOOL

BETTER TRADE TOOL V2

These datasets match information on child labor and forced labor worldwide from ILAB’s three flagship reports (Findings on the Worst Forms of Child Labor; List of Goods Produced by Child Labor or Forced Labor; and List of Products Produced by Forced or Indentured Child Labor) with U.S. import trade data, including Harmonized Tariff Schedule Codes, to empower users to advance efforts in supply chain transparency as well as strategic sourcing priorities. There are 3 tables combining data from ILAB’s essential reporting with U.S. import trade data. For more information, see ILAB’s International Child Labor and Forced Labor Reports page and ILAB’s Better Trade Tool page.

Dataset Tables

Better Trade Tool Core Data

https://data.dol.gov/get/BetterTradeToolCoreData

Column Name Data Type Column Description
Column Name Country Data Type varchar Column Description Name of the TVPRA Country
Column Name Country_ISOCode Data Type varchar Column Description ISO two-letter country code
Column Name Region Data Type varchar Column Description Report geographic region
Column Name Sector Data Type varchar Column Description Sector name
Column Name Good Data Type varchar Column Description The ILAB Good flagged for exploitation
Column Name All_Exploitations Data Type varchar Column Description List of all exploitation types
Column Name CL Data Type varchar Column Description Date range of when child labor exploitation type was added to the list. Optionally if the item was removed from the TVPRA List, there is an ending year.
Column Name FL Data Type varchar Column Description Date range of when forced labor exploitation type was added to the list. Optionally if the item was removed from the TVPRA List, there is an ending year.
Column Name FCL Data Type varchar Column Description Date range of when forced child labor exploitation type was added to the list. Optionally if the item was removed from the EO list, there is an ending year.
Column Name Country_NumericCode Data Type int Column Description Four digit numeric code. This code scheme is used by the US Census Bureau

Better Trade Country Codes

https://data.dol.gov/get/BetterTradeCountryCodes

Column Name Data Type Column Description
Column Name ILAB_ID Data Type varchar Column Description ILAB ID of the Country
Column Name ComTrade_NumCode Data Type varchar Column Description 3-digit ComTrade Country Code
Column Name ComTrade_CountryName Data Type varchar Column Description UN ComTrade Name of the Country or Region
Column Name CB_Numeric_Code Data Type varchar Column Description 4-digit Census Bureau Country Code (Same as ISO Codes)
Column Name CB_CountryName Data Type varchar Column Description Full Country Name as per Census Bureau
Column Name CB_Overwrite Data Type varchar Column Description A flag (*) to depict whether the name was modified
Column Name Latitude Data Type varchar Column Description Latitude of the Country
Column Name Longitude Data Type varchar Column Description Longitude of the Country

Better Trade Mapping Data

https://data.dol.gov/get/BetterTradeMappingData

Column Name Data Type Column Description
Column Name ID Data Type varchar Column Description Unique identifier for each Good and HTS combination
Column Name Good Data Type varchar Column Description Good description as noted in ILAB’s TVPRA and EO Lists
Column Name HTS Code Data Type varchar Column Description Assigned Harmonized Tariff Schedule codes