Go to: Data Specification Information
The following instructions are provided for downloading the file that contains the DPL in a delimited format. If you are using a Windows or Unix based computer, right click on the "Download Delimited DPL" link below. From the dialogue box that appears, select "Save Target As" or "Save Link As" and save the file to your local computer. If you are using a Macintosh computer use the "option" key and mouse click the hypertext link to bring up a dialogue box. Then save the file to your local computer.
Download Delimited DPL [Right Click]
A data format in which each field and each record is separated by a character that is used as a delimiter. The Denied Persons List (DPL) file available here uses the TAB character to separate fields and the double quotation mark character to encapsulate data within a field. It uses the new line character to separate records. This is a popular format for transferring data from one application to another, because most database systems are able to import and export delimited data.
We update this file regularly. While we make every effort to check the accuracy of this file, the final source of authority for information about persons denied export privileges is the Federal Register.
Most popular database, spreadsheet, and similar applications will import a delimited file such as this and format it as a table. For specific information on how to import this file into the program you are using, consult that program's documentation. We cannot assist you in that regard.
This file allows you to put the data about denied persons into a program that will search and organize the data based on fields of information. For example, you can sort the denied persons by geographical location. This file also may facilitate incorporation of the data into your own export management system. How you use this data is up to you.
This file consists of nine fields. The first row consists of the field names.
You should note that some of the field names [e.g., State, Country] are longer than the data length of those fields.
The rows after the field name row contain the data as follows:
Field Name |
Description |
Max. Data Length |
---|---|---|
Name | Name of the denied person, some names may appear more than one time because a separate complete record is generated for each address with which a name is associated | 150 characters |
Street_Address | Street address of the denied person, some addresses may appear more than one time because a separate complete record is generated for each name associated with a denied person | 255 characters |
City | City of the denied person's address | 50 characters |
State | If the denied person's address is in the United States, this field contains a two letter state code. If the address is outside the United States, this field is null | 2 characters [Note: this field name is longer than the field] |
Country | A two letter country code representing the country of the
address. Go to the key (found on html
version of the list) for Country Codes either by
Country Name or by Country Code. |
2 characters [Note: this field name is longer than the field] |
Postal_Code | The postal code of the address. This includes United States zip codes and the postal codes of other countries. If the code is unknown, this field will be null | 12 characters |
Effective_Date | The first date that the person is denied under the current continuous period of denial. The date is expressed in MM/DD/YYYY format. | 10 characters [Note: this field name is longer than the field] |
Expiration_Date | The first date that a previously denied person is no longer denied. The date is expressed as a MM/DD/YYYY format. Some denial orders have no expiration date. For those orders, this field is null | 10 characters [Note: this field name is longer than the field] |
Standard_Order | A one letter code with a value of either "Y"
or "N". "Y" indicates that the denial order is standard, i.e. its terms conform to those of the standard. "N" indicates that the terms of this order differ in some way from those of that standard denial order. More information on standard and non-standard orders |
1 character [Note: this field name is longer than the field] |