< Return to Datasets Menu

Sweat & Toil - All

Sweat & Toil - All

These datasets contain 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. There are 11 tables containing data from the 2014 and 2015 reporting cycle, and 3 tables with additional data from the 2015 reporting cycle. This information is also available in ILAB’s new app, Sweat & Toil: Child Labor, Forced Labor, and Human Trafficking Around the World. For more information, see ILAB’s International Child Labor and Forced Labor Reports page.

Dataset Tables

Regions Table

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

SweatToilAllRegions
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique region identifier
Column Name name Data Type varchar Column Description Region name

Countries Table

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

SweatToilAllCountries
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique country identifier
Column Name name Data Type varchar Column Description Country name
Column Name region_id Data Type int Column Description Unique Region Identifier
Column Name region Data Type varchar Column Description Region Name
Column Name num_territories Data Type int Column Description Number of territories within country

Territories Table

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

SweatToilAllTerritories
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique identifier
Column Name name Data Type varchar Column Description Territory name
Column Name abbreviation Data Type varchar Column Description Territory Abbreviation
Column Name country_id Data Type \int Column Description Country Identifier
Column Name country Data Type varchar Column Description Country Name

Advancement Levels Table

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

SweatToilAllAdvancementLevels
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique advancement level identifier
Column Name name Data Type varchar Column Description Advancement level (e.g. Significant, Moderate, Minimal, or No Advancement, etc.)

Assessments Table

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

SweatToilAllAssessments
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique identifier
Column Name country_id Data Type int Column Description Unique country identifier
Column Name country_name Data Type varchar Column Description Country name
Column Name year Data Type int Column Description Year
Column Name advancement_level_id Data Type int Column Description Advancement level identifier
Column Name advancement_level Data Type varchar Column Description Advancement level
Column Name description Data Type text Column Description Country assessment summary description

Sectors Table

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

SweatToilAllSectors
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique sector identifier
Column Name name Data Type varchar Column Description Sector name

Goods Table

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

SweatToilAllGoods
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique good identifier
Column Name sector_id Data Type int Column Description Unique sector identifier
Column Name sector Data Type varchar Column Description Sector name
Column Name name Data Type varchar Column Description Name of good

Country Goods Table

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

SweatToilAllCountryGoods
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique identifier
Column Name assessment_id Data Type int Column Description Assessment identifier
Column Name year Data Type int Column Description Assessment year
Column Name country_id Data Type int Column Description Country identifier
Column Name country Data Type varchar Column Description Country name
Column Name good_id Data Type int Column Description Good identifier
Column Name good Data Type varchar Column Description Good name
Column Name child_labor Data Type boolean Column Description Goods produced by child labor
Column Name forced_labor Data Type boolean Column Description Goods produced by forced labor
Column Name forced_child_labor Data Type boolean Column Description Goods produced by forced child labor

Statistics Table

https://data.dol.gov/SweatToilAllStatistics

SweatToilAllStatistics
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique Identifier
Column Name assessment_id Data Type int Column Description Assessment Identifier
Column Name year Data Type int Column Description Assessment year
Column Name country_id Data Type int Column Description Country Identifier
Column Name country Data Type varchar Column Description Country Name
Column Name age_range_of_working_children Data Type varchar Column Description Age range of working children
Column Name percent_of_working_children Data Type decimal Column Description Percent of working children
Column Name population_of_working_children Data Type int Column Description Population of working children
Column Name percent_of_working_children_agriculture Data Type decimal(3,1) Column Description Percent of working children in agriculture
Column Name percent_of_working_children_industry Data Type decimal Column Description Percent of working children in industry
Column Name percent_of_working_children_services Data Type decimal Column Description Percent of working children in services
Column Name age_range_of_children_attending_school Data Type varchar Column Description Age range of children attending school
Column Name percentage_of_children_attending_school Data Type decimal Column Description Percent of children attending school
Column Name age_range_of_children_working_and_studying Data Type varchar Column Description Age range of children working and studying
Column Name percent_of_children_working_and_studying Data Type decimal Column Description Percent of children working and studying
Column Name primary_completion_rate Data Type decimal Column Description Percent of children who complete primary education

Conventions Table

https://data.dol.gov/SweatToilAllConventions

SweatToilAllConventions
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique Identifier
Column Name assessment_id Data Type int Column Description Assessment Identifier
Column Name year Data Type int Column Description Assessment Year
Column Name country_id Data Type int Column Description Country Identifier
Column Name country Data Type varchar Column Description Country name
Column Name c_138_ratified Data Type varchar Column Description Status of country ratification of ILO Convention 138
Column Name c_182_ratified Data Type varchar Column Description Status of country ratification of ILO Convention 182
Column Name crc_ratified Data Type varchar Column Description Status of country ratification of the UN Convention on the Rights of the Child
Column Name crc_csec_ratified Data Type varchar Column Description Status of country ratification of the Optional Protocol to the Convention on the Rights of the Child on the Sale of Children, Child Prostitution and Child Pornography
Column Name crc_ac_ratified Data Type varchar Column Description Status of country ratification of the Optional Protocol to the Convention on the Rights of the Child on the Involvement of Children in Armed Conflict
Column Name palermo_ratified Data Type varchar Column Description Status of country ratification of the Protocol to Prevent, Suppress and Punish Trafficking in Persons, Especially Women and Children, supplementing the United Nations Convention Against Transnational Organized Crime (Palermo Protocol)

Suggested Actions Table

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

SweatToilAllSuggestedActions
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique identifier
Column Name assessment_id Data Type int Column Description Assessment identifier
Column Name year Data Type int Column Description Years suggested
Column Name country_id Data Type int Column Description Country identifier
Column Name country Data Type varchar Column Description Country name
Column Name area Data Type varchar Column Description Suggested action area
Column Name action Data Type text Column Description Suggested action

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

SweatToilAllLegalStandards
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique identifier
Column Name assessment_id Data Type int Column Description Assessment identifier
Column Name year Data Type int Column Description Assessment year
Column Name country_id Data Type int Column Description Country identifier
Column Name country Data Type varchar Column Description Country name
Column Name name Data Type varchar Column Description Name of legal standard
Column Name standard Data Type varchar Column Description Legal standard value
Column Name is_calculated_age Data Type boolean Column Description Identifies age calculated based on available information
Column Name conforms_standard Data Type boolean Column Description Identifies there are gaps in the legal framework, as articulated in the chapter report

Enforcements Table

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

SweatToilAllEnforcements
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique identifier
Column Name assessment_id Data Type int Column Description Assessment identifier
Column Name year Data Type int Column Description Assessment year
Column Name country_id Data Type int Column Description Country identifier
Column Name country Data Type varchar Column Description Country name
Column Name type Data Type varchar Column Description Enforcement type
Column Name name Data Type varchar Column Description Name of enforcement
Column Name enforcement Data Type varchar Column Description Enforcement value

Mechanisms Table

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

SweatToilMechanisms
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique identifier
Column Name assessment_id Data Type int Column Description Assessment identifier
Column Name year Data Type int Column Description Assessment year
Column Name country_id Data Type int Column Description Country identifier
Column Name country Data Type varchar Column Description Country name
Column Name coordination Data Type varchar Column Description Country has coordination mechanism
Column Name program Data Type varchar Column Description Country has program mechanism
Column Name policy Data Type varchar Column Description Country has a policy mechanism