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>The code used to scrape, clean, and test this data is available here: https://github.com/jacobkap/borderpatrol<br><br><b>Please note that all the data is in fiscal years (October-September), not in calendar years.</b><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><b>Apprehensions and Seizures Statistics 2011-2017<br></b>This
provides the annual number of seizures of drugs and weapons for
aggregate border sectors between the years 2011 and 2017. Drug data also
includes the amount of drugs seized (in pounds for all but heroin which
is measured in ounces). <br>SectorFiscal yearApprehensions from a special interest countryRounds of ammunition <br>Total apprehensionsPounds of cocaine <br>Number of cocaine seizuresConveyancesCurrency (in dollars)Pounds of ecstasyNumber of ecstasy seizuresNumber of firearmsOunces of heroinNumber of heroin seizuresPounds of marijuanaNumber of marijuana seizuresPounds of methNumber of meth seizuresPounds 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<br><b>Border Patrol Staffing 1992-2018<br></b>The annual number of agents employed for each sector in the country between 1992 and 2018.<br>SectorFiscal yearNumber of agents<br><b>Family, Unaccompanied Children, and Total Apprehensions 2000-2018<br></b>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 2018. Family
apprehension data is available for the years 2013 to 2018. Unaccompanied children data is available for the years 2010 to 2018.<br>SectorFiscal yearMonthTotal apprehensionsUnaccompanied children apprehensions (fiscal years 2010-2018 only)Family apprehensions (fiscal years 2013-2018 only)<br><b>Other than Mexico Apprehensions 2000-2018</b>The
annual number of apprehensions for each sector in the country between
2000 and 2018. This also includes the annual number of apprehensions of
immigrants from Mexico and the number of illegal immigrants from countries other than Mexico.SectorFiscal yearTotal apprehensionsTotal apprehensions of illegal immigrants from MexicoTotal apprehensions of illegal immigrants from countries other than Mexico<br><b>Nationwide Total Apprehensions 1925-2018</b>This is a simple count of how many apprehensions of illegal immigrants were made in the United States each year between 1925 and 2018.Fiscal yearTotal apprehensions<br><b>Sector Profile 2011-2017<br></b>This provides a number of various variables for each sector in the country between the years 2011 and 2017.SectorFiscal yearNumber of agentsTotal apprehensionsApprehensions of illegal immigrants from countries other than MexicoPounds of marijuanaPounds of cocaineNumber of accepted prosecutionsNumber of assaultsNumber of rescues (Southwest border only)<br>Number of deaths (Southwest border only)Number of accompanied children (under age 18) apprehendedNumber of unaccompanied children (under age 18) apprehendedTotal number of children (under age 18) apprehendedTotal number of adults (age 18 or older) apprehendedTotal number of females apprehendedTotal number of males apprehended<br><b>Southwest Border Apprehensions 1960-2018</b><br>The annual number of apprehensions for each sector in the Southwest border between 1960 and 2018.<br>SectorFiscal yearTotal apprehensions<br><b>Southwest Border Deaths 1998-2018<br></b>The annual number of deaths for each sector in the Southwest border between 1998 and 2018.SectorFiscal yearDeaths<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><b>Coastal Border</b>Livermore (closed after fiscal year 2004)<br>MiamiNew OrleansRamey<b>Northern Border</b>Blaine BuffaloDetroitGrand ForksHavreHoultonSpokane<b>Southwest Border</b>Big BendDel RioEl CentroEl PasoLaredoRio Grande ValleySan DiegoTucsonYuma<br>