Provides data on petitions received by the Office of Trade Adjustment Assistance (OTAA) and determinations of group eligibility by the Department from 1975 to present. Determinations reflect whether worker separations for each group of workers were affected by foreign trade as defined by the Trade Act of 1974, as amended.
Dataset Tables
ETA OTAA Petitions
https://data.dol.gov/get/eta_otaa_petitions
| Column Name | Data Type | Column Description |
|---|---|---|
| Column Name TAWSUFF | Data Type String/Varchar | Column Description Provides a concatenation of TAW and Suffix fields. The TAW and Suffix combination provides a unique key for worker groups (records) in the dataset. This data is available for years 1975-Present. |
| Column Name TAW | Data Type Integer | Column Description TAW number is the number we assign to a properly received, valid petition. While a petition may cover multiple worker groups, the petition number is consistent across all worker groups resulting from that petition. This data is available for years 1975-Present. |
| Column Name SUFFIX | Data Type String/Varchar | Column Description The suffix identifies the worker group for a particular petition. Suffix is a blank space for the first worker group for a TAW and then a suffix A-ZZ is assigned for each subsequent worker group. A TAW and suffix uniquely identify a worker group (record) in the dataset. This data is available for years 1975-Present. |
| Column Name WORKER_GROUP_NAME | Data Type String/Varchar | Column Description This is the primary name of the identified worker group. Typically it is the firm or company, but maybe a more specific articulation depending on the decision. This data is available for years 1975-Present. |
| Column Name SECOND_NAME | Data Type String/Varchar | Column Description The second name provides details on individual unit names, department names, leased worker groups, parent or subsidiary company names, or other clarifications. This field may be incomplete. Because of length limitations in this field, second names are truncated to include only the most relevant names. If space was still insufficient, inclusion of "etc." helps to indicate that further clarifications are in the decision that could not be documented in the dataset. This data is available for years 1975-Present. |
| Column Name STREET_ADDRESS | Data Type String/Varchar | Column Description This is the street address that is the primary work location of the worker group. In some cases, an address may not be available such as due to company closure or because the worker group covers a broader geographic region. Since 2013, the Department has increased efforts to ensure addresses are validated. Starting in 2020, address verification is done automatically. Older data will be subject to greater error. This data is available for years 1975-Present. |
| Column Name CITY | Data Type String/Varchar | Column Description The name of the city in which the primary work location of the worker group resides. Some may specify a broader geographic region. Since 2013, the Department has increased efforts to ensure addresses are validated. Starting in 2020, address verification is done automatically. Older data will be subject to greater error. This data is available for years 1975-Present. |
| Column Name STATE | Data Type String/Varchar | Column Description The name of the abbreviation for the state or territory in which the primary work location of the worker group resides. Some may specify a broader geographic region. Since 2013, the Department has increased efforts to ensure addresses are validated. Starting in 2020, address verification is done automatically. Older data will be subject to greater error. This data is available for years 1975-Present. |
| Column Name ZIP | Data Type String/Varchar | Column Description The zip code in which the primary work location of the worker group resides. Some may specify a broader geographic region. Note that this is coded as a string to ensure leading zeros are not removed. Since 2013, the Department has increased efforts to ensure addresses are validated. Starting in 2020, address verification is done automatically. Older data will be subject to greater error. This data is available for years 1975-Present. |
| Column Name ZIP_PLUS_4 | Data Type String/Varchar | Column Description The zip+4 in which the primary work location of the worker group resides. Some may specify a broader geographic region. Note that this is coded as a string to ensure leading zeros are not removed. Zip+4 was not used until 2011 and was only provided when available. New address verification changes starting in 2020 are expected to substantially increase the availability of zip+4 information. This data is available for years 2011-Present. |
| Column Name COUNTY_LONG | Data Type String/Varchar | Column Description Provides the county name of the primary work location of the worker group as provided by geolocation API data. All "Geo" data fields are looked up through the use of a standard address verification API. As such, it is subject to error and may not be available where the location could not be found. Lookup has been done since 2013 with some historic data also being available. This data is available for years 2013-Present. |
| Column Name LATITUDE_GEO | Data Type Decimal | Column Description Provides the latitude of the primary work location of the worker group as provided by geolocation API data. All "Geo" data fields are looked up through the use of a standard address verification API. As such, it is subject to error and may not be available where the location could not be found. Lookup has been done since 2013 with some historic data also being available. This data is available for years 2013-Present. |
| Column Name LONGITUDE_GEO | Data Type Decimal | Column Description Provides the longitude of the primary work location of the worker group as provided by geolocation API data. All "Geo" data fields are looked up through the use of a standard address verification API. As such, it is subject to error and may not be available where the location could not be found. Lookup has been done since 2013 with some historic data also being available. This data is available for years 2013-Present. |
| Column Name CONGRESSIONAL_DISCTRICT_SHORT_GEO | Data Type Integer | Column Description Provides the current congressional district number of the primary work location of the worker group as provided by geolocation API data. The district is the congressional district at time of data publication, not when the determination was rendered. All "Geo" data fields are looked up through the use of a standard address verification API. As such, it is subject to error and may not be available where the location could not be found. Lookup has been done since 2013 with some historic data also being available. This data is available for years 2013-Present. |
| Column Name WORKER_GROUP_TYPE | Data Type String/Varchar | Column Description Production, Service, or Mixed. This should align with whether a product was listed (Production), a service was listed (Service), or both were listed (Mixed). This data is available for years 1975-Present. |
| Column Name PRODUCT | Data Type String/Varchar | Column Description Free-text field designed to capture the product that the specific worker group is engaged with. This may mean that while the company works on broader products or services, the specific group may list a product or service more narrowly tailored to their specific activities. For example, a computer company may have ‘credit approval services’ listed because the worker group did credit approval services for the computer company. This data is available for years 1975-Present. |
| Column Name SERVICE | Data Type String/Varchar | Column Description Free-text field designed to capture the service that the specific worker group is engaged with. This may mean that while the company works on broader products or services, the specific group may list a product or service more narrowly tailored to their specific activities. For example, a computer company may have ‘credit approval services’ listed because the worker group did credit approval services for the computer company. This data is available for years 1975-Present. |
| Column Name PETITIONER | Data Type String/Varchar | Column Description This provides the category of the petitioner who submitted the petition. If a petition is submitted by multiple petitioners of different types, this follows the prioritization list: Company Official, State, American Jobs Center, Union, Workers, Other Authorized Representative. In some years, categories have been combined. The raw data has changed in format substantially since TAA's inception including using a free-text field and code values with no corresponding lookup table. The coding values prior to 1992 provided an unknown categorization. Data since 1992 has been recoded in to predictable categories to aid analysis. This data is available for years 1992-Present. |
| Column Name SIC | Data Type String/Varchar | Column Description The SIC code that designates the industry that the worker group's firm engages in. If more than one code is available, it is provided as a semi-colon delimited list with a maximum of 3 codes. Used from 1974 to 2011. The Department began utilizing NAICS codes in 2007 and uses them presently. No systematic validation was done on SIC codes. This data is available for years 1975-2011. |
| Column Name NAICS_CODE | Data Type String/Varchar | Column Description The NAICS code that designates the industry that the worker group's firm engages in. The Department began using NAICS codes in 2007 and phased out the use of SIC codes. Initial validation only confirmed the first two digits that indicate the broad industry sector. Beginning in 2017, a full 6-digit validation began to ensure codes were accurate. This data is available for years 2007-Present. |
| Column Name NAICS_CODE_YEAR | Data Type Integer | Column Description The code year of the NAICS code provided. Provides the last code year in which that NAICS was valid. The Department began using NAICS codes in 2007 and phased out the use of SIC codes. Initial validation only confirmed the first two digits that indicate the broad industry sector. Beginning in 2017, a full 6-digit validation began to ensure codes were accurate. This data is available for years 2007-Present. |
| Column Name NAICS_TITLE_2 | Data Type String/Varchar | Column Description The title of the major industry sector designated by the first two digits of the NAICS code. The Department began using NAICS codes in 2007 and phased out the use of SIC codes. Initial validation only confirmed the first two digits that indicate the broad industry sector. Beginning in 2017, a full 6-digit validation began to ensure codes were accurate. This data is available for years 2007-Present. |
| Column Name NAICS_TITLE_6 | Data Type String/Varchar | Column Description The title of the full six digit NAICS industry. The Department began using NAICS codes in 2007 and phased out the use of SIC codes. Initial validation only confirmed the first two digits that indicate the broad industry sector. Beginning in 2017, a full 6-digit validation began to ensure codes were accurate. This data is available for years 2007-Present. |
| Column Name PETITION_DATE | Data Type Date | Column Description The date on which the submitted petition was signed. The petition date was collected beginning in 1992. As with most data fields, validation has improved over time with redundant petition date checks being implemented in 2012. This data is available for years 1992-Present. |
| Column Name INST_DATE | Data Type Date | Column Description The institution date indicates when the office began their investigation. Delays between the petition date and institution date may result from transmission method (such as mail), because of delays transmitting the message, or that some additional information was needed for the petition to be valid. This data is available for years 1975-Present. |
| Column Name DET_DATE | Data Type Date | Column Description The determination date indicates when the Department rendered a decision on the worker group. When multiple determinations exist, this date will reflect the earliest date of certification (if applicable), the most recent statutory reconsideration (2015 only), or the initial determination date if other dates do not apply. This the best way to know when a worker group was certified or initially denied if the worker group was never certified. For calculating processing times, please use the CAS First Decision Date that will represent the initial determination date. This data is available for years 1975-Present. |
| Column Name INV_DET_CODE | Data Type String/Varchar | Column Description Provides the statutory basis for the determination. Code prefixes are: C = Certification, S = Certification, D = Denial, and T = Termination. A full reference table is available at: https://www.dol.gov/agencies/eta/tradeact/data/petitions-determinations. Codes are based on the statute under which the determination was rendered. Increased validation mechanisms implemented between 2012 and 2014 have ensured that codes are correct and align with Det Code. Prior years may have errors in alignment and accuracy. This data is available for years 2002-Present. |
| Column Name DET_CODE | Data Type String/Varchar | Column Description Provides the broad determination outcome of the worker group indicating whether they were certified, denied, or the investigation was terminated. Partial certifications indicate that portions of the worker group were certified while other parts were denied. Code prefixes are: C = Certification, D = Denial, T = Termination, and P = Partial Certification. A full reference table is available at: https://www.dol.gov/agencies/eta/tradeact/data/petitions-determinations. Prior to the 2002 law, the category of certification was not articulated. Beginning in 2002, the broad category was provided. Code tables for Inv Det Code provide a crosswalk between the two codes. Prior to 2012, there may be misalignment between the two codes. This data is available for years 1975-Present. |
| Column Name IMPACT_DATE | Data Type Date | Column Description The impact date is the earliest date a separation can occur for a participant to be eligible. By statute, this is typically one year before the petition is filed. However, some exceptions apply for C-ITC determinations, to prevent overlapping certifications, substantial delays in the receipt of a petition, and others. This is not an indicator of when separations actually occurred. This data is available for years 1975-Present. |
| Column Name EXPIRATION_DATE | Data Type Date | Column Description The expiration date is the date on which a certification's eligibility period ends. This indicates the last date a separation can occur for a participant to be eligible or the last date that a threatened, but not separated worker may be served. It is typically two years after a certification is rendered, but exceptions apply for C-ITC determinations, to prevent overlapping certifications, and others. This data is available for years 1975-Present. |
| Column Name LAST_INVESTIGATOR | Data Type String/Varchar | Column Description This field displays the investigator on the initial investigation for the petition to determine group eligibility. If multiple investigators worked on an investigation, the investigator who completed the initial investigation is listed. Tracking of investigators began in 1979, however only one investigator could be tracked. Beginning in 2005, systems were able to keep track of two investigators (the first and initial). In 2020, further improvements were made to be able to track all investigators. This data is available for years 1980-Present. |
| Column Name CAS_LAST_ASSIGNMENT_ON_INITIAL_INVESTIGATION | Data Type Date | Column Description This file provides the date on which the last investigator was assigned or reassigned the investigation. The date of assignment is not tracked for the initial assignment until 2020. This will be the institution date for determinations prior to 2005. This data is available for years 1980-Present. |
| Column Name CERTIFYING_OFFICER_LAST_NAME | Data Type String/Varchar | Column Description This field displays the certifying officer who signed the initial investigation determination. Not tracked prior to 2001. This data is available for years 2001-Present. |
| Column Name CAS_FIRST_DECISION_DATE | Data Type Date | Column Description Displays the date the initial determination was rendered on the case. Note that this will be the same for all suffixes even if a suffix was added by a post-initial determination. For investigations prior to 2016, this determination date could have been updated by a subsequent post-initial revision on reconsideration or remand. Beginning in 2016, post-initial determinations were tracked separately which prevents overwriting of the decision. This data is available for years 1975-Present. |
| Column Name MOST_RECENT_UPDATE | Data Type Date | Column Description Displays the date of the most recent decision affecting this worker group record. After the initial investigation, post-initial decisions may This data is available for years 2016-Present. |
| Column Name ATAA_APPL_MIS | Data Type Boolean (0/1) | Column Description This Boolean flag (1=Yes, 0=No) indicates whether there was an application for ATAA. This separate ATAA certification only applies to the 2002 program. This only applies to the 2002 program although the flag may be incorrectly checked in some other records. This was not tracked during Reversion programs in 2011 and 2015. This data is available for years 2002-2010. |
| Column Name ATAA_CERT_MIS | Data Type Integer | Column Description This is the count of estimated workers who would be eligible for ATAA. This only applies to the 2002 program although the flag may be incorrectly checked in some other records. This was not tracked during Reversion programs in 2011 and 2015. This data is available for years 2002-2010. |
| Column Name ATAA_REVISED_MIS | Data Type Boolean (0/1) | Column Description This Boolean flag (1=Yes, 0=No) indicates whether the determination was changed to include ATAA after the initial determination. This only applies to the 2002 program although the flag may be incorrectly checked in some other records. This was not tracked during Reversion programs in 2011 and 2015. This data is available for years 2002-2010. |
| Column Name DISPLAY_PDF | Data Type Boolean (0/1) | Column Description This Boolean flag (Yes=1, No=0) indicates whether to display the hyperlink to the redacted petition PDF on the website. Note, that display requires both that the flag is set to yes and that the file is actually posted. This data is available for years. |
| Column Name DISPLAY_TEXT | Data Type Boolean (0/1) | Column Description This Boolean flag (Yes=1, No=0) indicates whether to display the hyperlink to the determination on the website. Note, that display requires both that the flag is set to yes and that the file is actually posted. This data is available for years. |
| Column Name COUNTRIES_OBJ | Data Type String/Varchar | Column Description This field shows what countries were cited in the decision such as the destination of a shift or the source of foreign imports. The order of countries in this field is not based on anything and does not communicate any relative impact of the countries cited. It also does not provide information on the reason for the citation. Specific countries are not required in most contexts for a decision and many decisions do not cite any countries. For cases with TAW numbers below 96500, this was collected based on free-text fields that were size limited resulting in inconsistent naming and formatting. This field may be incomplete if cited country names exceeded field size. For TAW numbers of 96500 and above, a standardized list of countries and multiple response field allow this field to be consistent and complete. This data is available for years 2002-Present. |
| Column Name REQRECON2_MIS | Data Type Integer | Column Description Tracks the request for Reconsideration for TAW numbers lower than 96500. Null = No Information 0 = No Reconsideration requested 1 = TAA requested reconsideration 2 = (Unknown, Category no longer utilized) 3 = (Unknown, Category no longer utilized) 4 = Direct to Remand This tracking field has been inconsistently populated and provides no further information on reconsideration status. It has been deprecated and replaced with separate tracking of application for reconsideration and reconsideration investigations beginning in 2016. This data is available for years 2004-2016. |
| Column Name PETITIONER_NAMES | Data Type String/Varchar | Column Description The names of the petitioners who made the original request. Only available for TAW numbers of 50000 and above. This data is available for years 2011-Present. |
| Column Name PETITIONERS_UNION | Data Type String/Varchar | Column Description If the petitioner was a union official, the name of the union they represent. This is a free-text field and not standardized. Only available for TAW numbers of 96500 and above and not available for 98000 series. This data is available for years 2020-Present. |
| Column Name ALLEGATION_TEXT | Data Type String/Varchar | Column Description The trade allegation provided by the petitioner in the petition. Only available for TAW numbers of 96500 and above and not available for 98000 series. This data is available for years 2020-Present. |
| Column Name REQUEST_FOR_AMENDMENT | Data Type Boolean (0/1) | Column Description Whether the petition was a request for amendment provided as a Yes(1)/No(0) Flag. Blank if the information is not available. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGATION_OF_COMPANY_IMPORTS | Data Type Boolean (0/1) | Column Description Whether the petition alleged company imports provided as a Yes(1)/No(0) Flag. Blank if the information is not available. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGATION_OF_CUSTOMER_IMPORTS | Data Type Boolean (0/1) | Column Description Whether the petition alleged customer imports provided as a Yes(1)/No(0) Flag. Blank if the information is not available. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGATION_OF_DOWNSTREAM_PRODUCER | Data Type Boolean (0/1) | Column Description Whether the petition alleged the worker group is a downstream producer of another TAA certified firm provided as a Yes(1)/No(0) Flag. Blank if the information is not available. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGATION_OF_SECONDARY_SUPPLIER | Data Type Boolean (0/1) | Column Description Whether the petition alleged the worker group is a secondary supplier another TAA certified firm provided as a Yes(1)/No(0) Flag. Blank if the information is not available. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGATION_OF_SHIFT | Data Type Boolean (0/1) | Column Description Whether the petition alleged there as a shift in services or production to another country provided as a Yes(1)/No(0) Flag. Blank if the information is not available. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGATION_OF_ITC | Data Type Boolean (0/1) | Column Description Whether the petition alleged that the worker group was the subject of an ITC determination provided as a Yes(1)/No(0) Flag. Blank if the information is not available. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGED_ITC_NUMBER | Data Type String/Varchar | Column Description If an ITC determination was alleged, the case number of the ITC determination. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGED_ITC_TITLE | Data Type String/Varchar | Column Description If an ITC determination was alleged, the title of the ITC determination. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name ALLEGED_ITC_FRN_DATE | Data Type Date | Column Description If an ITC determination was alleged, the FRN posting date of the ITC determination. Only available for TAW numbers of 96500 and above and not available for 98000 series. Coded based on the Department's reading of the allegation. This data is available for years 2020-Present. |
| Column Name INV_DAYS | Data Type Integer | Column Description This number is the number of days that the initial investigation took to complete. It is calculated by subtracting the institution date from the initial decision determination date. Investigation timeframes apply to each petition rather than each worker group, so additional worker groups (suffix is not null) do not calculate investigation days and are left blank. For decisions prior to 2012, initial decision dates were not systematically tracked. Det Date has been utilized when initial determination information was not available. This data is available for years 1975-Present. |
| Column Name EST_WORKERS_ATAA_DEPRECATED | Data Type Integer | Column Description Estimated workers threatened with total or partial separation who would potentially qualify for ATAA benefits for older workers. This estimate is determined during the investigation predominantly from information provided by company officials. OTAA does not estimate workers for terminated petitions (because they are not actual decisions) and are coded as zero estimated workers. This number was only utilized from 2002 to 2009. Reversion programs did not track the number of workers within this category as a separate number. This data is available for years 2002-2009. |
| Column Name EST_WORKERS_OBJ | Data Type Integer | Column Description This is a count of the number of investigators who were assigned to the initial investigation. The number of investigators that can be tracked has been substantially limited over time. Prior to 2005, only one investigator could be tracked. From 2005 to 2020, only a maximum of two investigators could be tracked. Beginning in 2020 with TAW 96500, the number that could be tracked is no longer limited. This data is available for years 2005-Present. |
| Column Name WG_INITIAL_INVESTIGATION_COUNT | Data Type Integer | Column Description This is the number of initial investigations that that the particular TAW and Suffix combination. For initial investigations the maximum is one. The number may be zero if the suffix was added through a post-initial determination such as an amendment or reconsideration. No data prior to 2012 and not comprehensively tracked until 2016. This data is available for years 2012-Present. |
| Column Name WG_AMENDMENT_INVESTIGATION_COUNT | Data Type Integer | Column Description This is the number of amendment investigations (such as to clarify the worker group) that that the particular TAW and Suffix combination. No data prior to 2012 and not comprehensively tracked until 2016. This data is available for years 2012-Present. |
| Column Name WG_CORRECTION_INVESTIGATION_COUNT | Data Type Integer | Column Description This is the number of correction investigations that that the particular TAW and Suffix combination. Corrections make minor changes with a decision text without fundamentally changing the outcome. No data prior to 2012 and not comprehensively tracked until 2016. This data is available for years 2012-Present. |
| Column Name WG_APPLICATION_FOR_RECONSIDERATION_INVESTIGATION_COUNT | Data Type Integer | Column Description This is the number of application for reconsiderations investigations that that the particular TAW and Suffix combination. Prior to the implementation of new regulations in September 2020, requests for reconsideration required an initial assessment to determine if the application justified a reconsideration investigation. This step is no longer required under the new regulations. No data prior to 2012 and not comprehensively tracked until 2016. This data is available for years 2012-Present. |
| Column Name WG_RECONSIDERATION_INVESTIGATION_COUNT | Data Type Integer | Column Description This is the number of reconsideration investigations that that the particular TAW and Suffix combination. Reconsideration investigations are only applicable to groups initially denied or terminated and may result in an affirmation of the denial or being revised to a certification. No data prior to 2012 and not comprehensively tracked until 2016. This data is available for years 2012-Present. |
| Column Name WG_REMAND_INVESTIGATION_COUNT | Data Type Integer | Column Description This is the number of remand investigations that that the particular TAW and Suffix combination. Remand investigations are similar to reconsideration investigations, but ordered by the court. No data prior to 2012 and not comprehensively tracked until 2016. This data is available for years 2012-Present. |
| Column Name WG_STATUTORY_RECONSIDERATION_INVESTIGATION_COUNT | Data Type Integer | Column Description This is the number of statutory investigations that that the particular TAW and Suffix combination. Statutory investigations are the result of legislative changes that mandate the reopening of denied petitions under new statutory criteria. Tracked 2014 to present. This data is available for years 2014-Present. |