Trade Data Center

One-stop shop for searchable trade databases, case lists & more

Eyes on Trade

Public Citizen's Global Trade Watch blog on globalization and trade

Connect with GTW

Back to Trade Data Center
Trade Adjustment Assistance Database Technical Documentation

Source of the Data

Public Citizen submitted a Freedom of Information Act (FOIA) request to the Department of Labor (DOL) that asked for their database of all petition records submitted to the Trade Adjustment Assistance (TAA) program with determination dates between January 1, 1994 and June 1, 2010.  Public Citizen submitted a separate FOIA request that asked for the DOL's database of all petition records submitted to the North American Free Trade Agreement-Transitional Adjustment Assistance (NAFTA-TAA) program, which operated between 1994 and 2002. The records contained information on the name of the company where layoffs occurred, its address, who submitted the petition, the product produced by the workers, the date that the petition was filed, the date that worker separations began, the date that the DOL certified or denied the petition, the number of workers laid off, and the country implicated in the layoffs, among other information. For the TAA data dictionary that Public Citizen received from the Department of Labor, click here.

Merger of TAA and NAFTA-TAA Database

Workers and companies could apply under both the TAA and NAFTA-TAA programs and receive certification under both. Certification under both programs was quite common: about two-thirds of petitions certified under the NAFTA-TAA program were certified under the "vanilla” TAA program. Thus, certified petitions can show up in the TAA and NAFTA-TAA databases that refer to the same instance of job loss. Therefore, simply combining the two databases would lead to some double-counting of job loss.

Public Citizen developed a procedure to combine the databases and yet avoid double-counting, which we believe leads to maximum usefulness of the resultant database.

The NAFTA-TAA database that we received from the DOL had a field for the “vanilla” TAA petition record that is associated with the NAFTA-TAA petition, if the petitioners filed under both programs. We use the following procedure to merge the two datasets:

1. NAFTA-TAA records that do not have an associated petition under the vanilla TAA program are retained.

2. For NAFTA-TAA records that do have an associated petition under the vanilla TAA program, we aggregate the estimated job loss numbers for each record by the numeric “stem” record number. Note that if a search is performed on the Department of Labor's TAA petition determination online database here, many petitions’ “TAW Numbers” have letter suffixes – we aggregate these in this stage of the process because there is no accurate concordance between the letter suffixes given in the  NAFTA-TAA and vanilla TAA petition records. At the end of the data processing procedure, these records are put back into their original disaggregated forms.

3. If a given NAFTA-TAA record has reported job loss greater or equal to its associated vanilla TAA record, we keep the NAFTA-TAA record and discard the vanilla TAA record. Otherwise, we keep the vanilla TAA record.

We believe that this is the most useful way to combine the two datasets because we do not undercount the job losses reported in the TAA system – we know that at least X number of jobs were lost due to imports or outsourcing as certified by TAA. When the NAFTA-TAA and vanilla TAA records report the same job losses, we take the NAFTA-TAA record because that record provides more information as to the cause of the job loss.

Enhanced Geographic Information of Records

The TAA petition records that Public Citizen received from the DOL contained the street address, city, and state of the companies that shed workers.  The records did not originally hold information about the congressional district, county, or metropolitan area where the workplace was located. To determine the congressional district, county, or metropolitan area for each petition record, the address information for each record was submitted to the University of Southern California’s WebGIS Services to obtain the precise latitude and longitude of the workplace (the attribute relaxation, substring matching, soundex matching, and uncertainty hierarchy options of the batch geocoding were all enabled).

Each point, represented by its latitude and longitude combination, was tested for inclusion in each polygon defined by the borders of each congressional district.  The shapefiles containing the boundary information for the congressional districts were obtained from the Census Bureau, available here. The same procedure was used for counties and metropolitan areas.

Citation

If you choose to cite data from this database, please consider the following fact/citation format: "The Department of Labor certified [NUMBER] workers in [GEOGRAPHIC AREA] as having lost their jobs to imports or outsourcing during the NAFTA-WTO era. Source: Public Citizen. 2010. Department of Labor Trade Adjustment Assistance Consolidated Petitions Database. Washington, DC, http://www.citizen.org/taadatabase"

 

 Written by Travis McArthur. Last modified on October 8, 2010.

Copyright © 2014 Public Citizen. Some rights reserved. Non-commercial use of text and images in which Public Citizen holds the copyright is permitted, with attribution, under the terms and conditions of a Creative Commons License. This Web site is shared by Public Citizen Inc. and Public Citizen Foundation. Learn More about the distinction between these two components of Public Citizen.


Public Citizen, Inc. and Public Citizen Foundation

 

Together, two separate corporate entities called Public Citizen, Inc. and Public Citizen Foundation, Inc., form Public Citizen. Both entities are part of the same overall organization, and this Web site refers to the two organizations collectively as Public Citizen.

Although the work of the two components overlaps, some activities are done by one component and not the other. The primary distinction is with respect to lobbying activity. Public Citizen, Inc., an IRS § 501(c)(4) entity, lobbies Congress to advance Public Citizen’s mission of protecting public health and safety, advancing government transparency, and urging corporate accountability. Public Citizen Foundation, however, is an IRS § 501(c)(3) organization. Accordingly, its ability to engage in lobbying is limited by federal law, but it may receive donations that are tax-deductible by the contributor. Public Citizen Inc. does most of the lobbying activity discussed on the Public Citizen Web site. Public Citizen Foundation performs most of the litigation and education activities discussed on the Web site.

You may make a contribution to Public Citizen, Inc., Public Citizen Foundation, or both. Contributions to both organizations are used to support our public interest work. However, each Public Citizen component will use only the funds contributed directly to it to carry out the activities it conducts as part of Public Citizen’s mission. Only gifts to the Foundation are tax-deductible. Individuals who want to join Public Citizen should make a contribution to Public Citizen, Inc., which will not be tax deductible.

 

To become a member of Public Citizen, click here.
To become a member and make an additional tax-deductible donation to Public Citizen Foundation, click here.