< Return to Datasets Menu

Farm Labor Contractor and Farm Labor Contractor Employee

Farm Labor Contractor and Farm Labor Contractor Employee V2

Migrant and Seasonal Agricultural Protection Act (MSPA) Registered Farm Labor Contractor Data: The MSPA requires a contractor to obtain federal certification prior to performing any farm labor contracting activities. There are three datasets available through the API:

  1. farm labor contractors who have obtained a federal certificate;
  2. farm labor contractor employees who have obtained a federal certificate of registration authorizing the holder to perform farm labor contracting activities under MSPA; and
  3. individuals or corporations whose authorization to operate as a farm labor contractor has been revoked and who may not engage in any activity as a Farm Labor Contractor (FLC) or as a Farm Labor Contractor Employee (FLCE) as defined by MSPA.
Note: Offset are working different on this datasets it take columns value with offset.
More information and details about the data provided can be found at https://www.dol.gov/whd/mspa/index.htm

Dataset Tables

Farm Labor Contractors Table

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

flc_cert
Column Name Data Type Column Description
Column Name flc_id Data Type int Column Description FLC ID
Column Name flc_cert_num Data Type varchar Column Description FLC certificate number
Column Name flc_name Data Type varchar Column Description FLC business or FLC individual
Column Name flc_address Data Type varchar Column Description FLC address 1
Column Name flc_address2 Data Type varchar Column Description FLC address 2
Column Name flc_city Data Type varchar Column Description FLC city
Column Name flc_state Data Type varchar Column Description FLC state
Column Name flc_zip Data Type varchar Column Description FLC zip code
Column Name flc_phone_no Data Type varchar Column Description FLC phone number
Column Name flc_business_type Data Type varchar Column Description FLC business type
Column Name driving_auth Data Type char Column Description Driving authorization
Column Name housing_auth Data Type varchar Column Description Housing authorization
Column Name transportation_auth Data Type varchar Column Description Transportation authorization
Column Name flc_cert_start_date Data Type date Column Description FLC Certificate Start Date
Column Name flc_cert_end_date Data Type date Column Description FLC Certificate End Date

Farm Labor Contractor Employees Table

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

flce_cert
Column Name Data Type Column Description
Column Name flce_id Data Type int Column Description FLCE ID
Column Name flce_cert_num Data Type varchar Column Description FLCE certificate number
Column Name flce_name Data Type varchar Column Description FLCE individual
Column Name flc Data Type varchar Column Description Authorized FLC employer
Column Name driving_auth Data Type char Column Description Driving authorization
Column Name flce_cert_start_date Data Type date Column Description FLCE Certificate Start Date
Column Name flce_cert_end_date Data Type date Column Description FLCE Certificate End Date

Ineligible Farm Labor Contractors Table

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

flc_debar
Column Name Data Type Column Description
Column Name name Data Type varchar Column Description Name
Column Name address Data Type varchar Column Description Address
Column Name city Data Type varchar Column Description City
Column Name state Data Type varchar Column Description State
Column Name zipcode Data Type varchar Column Description Zip code
Column Name final_order_date Data Type date Column Description Date of final order
Column Name action_reason Data Type varchar Column Description Reason for action