U.S. Customs and Border Protection Statistics and Summaries

This is a collection of data from the U.S. Customs and Border Protection (CBP), primarily about apprehensions of illegal immigrants. All the data here was originally scraped from the PDFs available from the U.S. Customs and Border Protection's Stats and Summaries page on their website (https://www.cbp.gov/newsroom/media-resources/stats). I am in no way affiliated with CBP. What I did was take their public files and scrape the tables in the PDFs to make them more accessible. I then combined some tables together and reshaped the data to make it easier to use for analysis. The data is now available in R, Stata, and Excel (.csv) formats.

<br><br>
Please note that all the data is in fiscal years (October-September), not in calendar years.

<br><br>
There are 8 files and they all contains different information and some contains different number of years. Below is the file name, a brief description, the years of data available, and which variables it has, for each file.

<br><br>
Apprehensions and Seizures Statistics 2011-2019
This provides the annual number of seizures of drugs and weapons for aggregate border sectors between the years 2011 and 2019. Drug data also includes the amount of drugs seized (in pounds for all but heroin which is measured in ounces).

<br>
Sector<br>
Fiscal year<br>
Apprehensions from a special interest country<br>
Rounds of ammunition<br>
Total apprehensions<br>
Pounds of cocaine<br>
Number of cocaine seizures<br>
Conveyances<br>
Currency (in dollars)<br>
Pounds of ecstasy<br>
Number of ecstasy seizures<br>
Number of firearms<br>
Ounces of heroin<br>
Number of heroin seizures<br>
Pounds of marijuana<br>
Number of marijuana seizures<br>
Pounds of meth<br>
Number of meth seizures<br>
Pounds of other drugs (not cocaine, heroin, ecstasy, or marijuana)<br>
Number of other drugs seizures ((not cocaine, heroin, ecstasy, or marijuana)<br>
Apprehensions of illegal immigrants from countries other than Mexico<br>

<br><br>
Border Patrol Staffing 1992-2019
The annual number of agents employed for each sector in the country between 1992 and 2019.

<br>
Sector<br>
Fiscal year<br>
Number of agents<br>

<br><br>
Family, Unaccompanied Children, and Total Apprehensions 2000-2019
The monthly number of total apprehensions, family apprehensions (defined as "the number of individuals (either a child under 18 years old, parent, or legal guardian) apprehended with a family member by the U.S. Border Patrol."), or unaccompanied children (person under the age 18 traveling alone (without a family member)) for each sector in the country. Total apprehension data is available for the years 2000 to 2019. Family apprehension data is available for the years 2013 to 2019. Unaccompanied children data is available for the years 2010 to 2019.

<br>
Sector<br>
Fiscal year<br>
Month<br>
Total apprehensions<br>
Unaccompanied children apprehensions (fiscal years 2010-2019 only)<br>
Family apprehensions (fiscal years 2013-2019 only)<br>

<br>
Other than Mexico Apprehensions 2000-2019<br>
The annual number of apprehensions for each sector in the country between 2000 and 2019. This also includes the annual number of apprehensions of immigrants from Mexico and the number of illegal immigrants from countries other than Mexico.<br>

Sector<br>
Fiscal year<br>
Total apprehensions<br>
Total apprehensions of illegal immigrants from Mexico<br>
Total apprehensions of illegal immigrants from countries other than Mexico<br>

<br>
Nationwide Total Apprehensions 1925-2019<br>
This is a simple count of how many apprehensions of illegal immigrants were made in the United States each year between 1925 and 2019.<br>

Fiscal year<br>
Total apprehensions<br>

<br>
Sector Profile 2011-2019<br>
This provides a number of various variables for each sector in the country between the years 2011 and 2019.<br>

Sector<br>
Fiscal year<br>
Number of agents<br>
Total apprehensions<br>
Apprehensions of illegal immigrants from countries other than Mexico<br>
Pounds of marijuana<br>
Pounds of cocaine<br>
Number of accepted prosecutions<br>
Number of assaults<br>
Number of rescues (Southwest border only)<br>
Number of deaths (Southwest border only)<br>
Number of accompanied children (under age 18) apprehended<br>
Number of unaccompanied children (under age 18) apprehended<br>
Total number of children (under age 18) apprehended<br>
Total number of adults (age 18 or older) apprehended<br>
Total number of females apprehended<br>
Total number of males apprehended<br>

<br>
Southwest Border Apprehensions 1960-2019<br>
The annual number of apprehensions for each sector in the Southwest border between 1960 and 2019.<br>

Sector<br>
Fiscal year<br>
Total apprehensions<br>

<br>
Southwest Border Deaths 1998-2019<br>
The annual number of deaths for each sector in the Southwest border between 1998 and 2019.<br>

Sector<br>
Fiscal year<br>
Deaths<br>

<br>
Some of the data sets present the data broken into border sectors. Below is a list of the three borders and the sectors each one includes.<br>

<br>
Coastal Border<br>

Livermore (closed after fiscal year 2004)<br>
Miami<br>
New Orleans<br>
Ramey<br>

<br>
Northern Border<br>

Blaine <br>
Buffalo<br>
Detroit<br>
Grand Forks<br>
Havre<br>
Houlton<br>
Spokane<br>

<br>
Southwest Border<br>

Big Bend<br>
Del Rio<br>
El Centro<br>
El Paso<br>
Laredo<br>
Rio Grande Valley<br>
San Diego<br>
Tucson<br>
Yuma