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. Please note that all the data is in fiscal years (October-September), not in calendar years. 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. 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). Sector Fiscal year Apprehensions from a special interest country Rounds of ammunition Total apprehensions Pounds of cocaine Number of cocaine seizures Conveyances Currency (in dollars) Pounds of ecstasy Number of ecstasy seizures Number of firearms Ounces of heroin Number of heroin seizures Pounds of marijuana Number of marijuana seizures Pounds of meth Number of meth seizures Pounds of other drugs (not cocaine, heroin, ecstasy, or marijuana) Number of other drugs seizures ((not cocaine, heroin, ecstasy, or marijuana) Apprehensions of illegal immigrants from countries other than Mexico Border Patrol Staffing 1992-2019 The annual number of agents employed for each sector in the country between 1992 and 2019. Sector Fiscal year Number of agents 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. Sector Fiscal year Month Total apprehensions Unaccompanied children apprehensions (fiscal years 2010-2019 only) Family apprehensions (fiscal years 2013-2019 only) Other than Mexico Apprehensions 2000-2019 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. Sector Fiscal year Total apprehensions Total apprehensions of illegal immigrants from Mexico Total apprehensions of illegal immigrants from countries other than Mexico Nationwide Total Apprehensions 1925-2019 This is a simple count of how many apprehensions of illegal immigrants were made in the United States each year between 1925 and 2019. Fiscal year Total apprehensions Sector Profile 2011-2019 This provides a number of various variables for each sector in the country between the years 2011 and 2019. Sector Fiscal year Number of agents Total apprehensions Apprehensions of illegal immigrants from countries other than Mexico Pounds of marijuana Pounds of cocaine Number of accepted prosecutions Number of assaults Number of rescues (Southwest border only) Number of deaths (Southwest border only) Number of accompanied children (under age 18) apprehended Number of unaccompanied children (under age 18) apprehended Total number of children (under age 18) apprehended Total number of adults (age 18 or older) apprehended Total number of females apprehended Total number of males apprehended Southwest Border Apprehensions 1960-2019 The annual number of apprehensions for each sector in the Southwest border between 1960 and 2019. Sector Fiscal year Total apprehensions Southwest Border Deaths 1998-2019 The annual number of deaths for each sector in the Southwest border between 1998 and 2019. Sector Fiscal year Deaths 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. Coastal Border Livermore (closed after fiscal year 2004) Miami New Orleans Ramey Northern Border Blaine Buffalo Detroit Grand Forks Havre Houlton Spokane Southwest Border Big Bend Del Rio El Centro El Paso Laredo Rio Grande Valley San Diego Tucson Yuma