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:
- farm labor contractors who have obtained a federal certificate;
- farm labor contractor employees who have obtained a federal certificate of registration authorizing the holder to perform farm labor contracting activities under MSPA; and
- 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 is working different on these datasets as it takes column's 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
| 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
| 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 |