Sweat & Toil

NOTICE: This dataset is deprecated. Because these tables are now included in the Sweat & Toil - All dataset, this dataset will be disabled as of September 30, 2017.

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 that contain data from the 2014 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

Region Table

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

childlabor_reg
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique region identifier
Column Name name Data Type varchar(30) Column Description Region name

Country Table

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

childlabor_cty
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique country identifier
Column Name name Data Type varchar(80) Column Description Country name
Column Name region_id Data Type int Column Description Unique Region Identifier
Column Name iso2 Data Type varchar(2) Column Description Two-letter country code established by the International Organization for Standardization
Column Name iso3 Data Type varchar(3) Column Description Three-letter country code established by the International Organization for Standardization

Advancement Level Table

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

childlabor_advlvl
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique advancement level identifier
Column Name advancement_name Data Type varchar(45) Column Description Advancement level (Significant, Moderate, Minimal, or No Advancement, or No Assessment)

Country Profile Table

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

childlabor_pro
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique country profile identifier
Column Name country_id Data Type int Column Description Unique country identifier
Column Name profile_year Data Type int Column Description Year of country profile
Column Name advancement_id Data Type int Column Description Unique advancement level identifier
Column Name description Data Type text Column Description Country profile summary description

Sector Table

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

childlabor_sec
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique sector identifier
Column Name name Data Type varchar(15) Column Description Sector name of good (Agriculture, Manufacturing, Mining, and Other)

Good Table

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

childlabor_goo
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique good identifier
Column Name name Data Type varchar(35) Column Description Name of good
Column Name sector_id Data Type int Column Description Unique sector identifier

Country Goods Table

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

childlabor_cty_goo
Column Name Data Type Column Description
Column Name country_profile_id Data Type int Column Description Unique country identifier
Column Name good_id Data Type int Column Description Unique good identifier
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

Country Statistics Table

https://data.dol.gov/childlabor_sta

childlabor_sta
Column Name Data Type Column Description
Column Name country_profile_id Data Type int Column Description Unique Country Identifier
Column Name cws_age_range Data Type varchar(5) Column Description Age range of working children
Column Name cws_total_percentage_of_workin Data Type decimal(3,1) Column Description Percent of working children
Column Name cws_total_working_population Data Type int Column Description Population of working children
Column Name cws_agriculture Data Type decimal(3,1) Column Description Percent of working children in agriculture
Column Name cws_services Data Type decimal(3,1) Column Description Percent of working children in services
Column Name cws_industry Data Type decimal(3,1) Column Description Percent of working children in industry
Column Name esas_year Data Type varchar(11) Column Description Year of school attendance data
Column Name esas_age_range Data Type varchar(5) Column Description Age range of children attending school
Column Name esas_percentage Data Type decimal(3,1) Column Description Percent of children attending school
Column Name cwas_year Data Type varchar(11) Column Description Year of data on children working and studying
Column Name cwas_age_range Data Type varchar(5) Column Description Age range of children working and studying
Column Name cwas_total Data Type decimal(3,1) Column Description Percent of children working and studying
Column Name upcr_year Data Type year(4) Column Description Year of data on primary completion rate
Column Name upcr_rate Data Type decimal(4,1) Column Description Primary completion rate

Country Master Data Table

https://data.dol.gov/childlabor_mas

childlabor_mas
Column Name Data Type Column Description
Column Name country_profile_id Data Type int Column Description Unique Country Identifier
Column Name c_138_ratified Data Type varchar(8) Column Description Status of country ratification of ILO Convention 138
Column Name c_182_ratified Data Type varchar(8) Column Description Status of country ratification of ILO Convention 182
Column Name convention_on_the_rights_of_th Data Type varchar(8) Column Description Status of country ratification of the UN Convention on the Rights of the Child
Column Name crc_commercial_sexual_exploita Data Type varchar(8) 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_armed_conflict_ratified Data Type varchar(8) 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(8) 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)
Column Name minimum_age_for_work_establish Data Type varchar(8) Column Description Status of establishment of a legal minimum age for work
Column Name minimum_age_for_work Data Type varchar(8) Column Description Legal minimum age for work
Column Name minimum_age_for_hazardous_work_established Data Type varchar(8) Column Description Status of establishment of a legal minimum age for hazardous work
Column Name minimum_age_for_hazardous_work Data Type varchar(8) Column Description Legal minimum age for hazardous work
Column Name compulsory_education_age_estab Data Type varchar(8) Column Description Status of establishment of age for completion of compulsory education
Column Name minimum_age_for_compulsory_edu Data Type varchar(8) Column Description Legal age for completion of compulsory education
Column Name free_public_education_establis Data Type varchar(8) Column Description Status of establishment of free public education

Country Suggested Actions Area Table

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

childlabor_actionarea
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique country suggested actions area identifier
Column Name name Data Type varchar(50) Column Description Suggested action area name (Legal Framework, Enforcement, Coordination, Government Policies, and Social Programs)

Country Suggested Actions Table

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

childlabor_action
Column Name Data Type Column Description
Column Name id Data Type int Column Description Unique country suggested actions identifier
Column Name country_profile_id Data Type int Column Description Unique country identifier
Column Name area_id Data Type int Column Description Unique country suggested actions area identifier
Column Name name Data Type text Column Description Suggested action
Column Name year Data Type varchar(15) Column Description Years suggested