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本数据集收录自美国海关与边境保护局（U.S. Customs and Border Protection, CBP）的公开数据，核心内容为非法入境者逮捕相关统计。所有原始数据均从CBP官网「统计与摘要」页面（https://www.cbp.gov/newsroom/media-resources/stats）提供的PDF文件中抓取，本人与CBP无任何隶属关系。本次工作仅提取其公开文件中的表格并优化格式以提升数据易用性，后续还整合了部分表格并重构数据结构，便于分析使用。当前数据支持R、Stata及Excel（.csv）格式获取。请注意，所有数据均采用财年制（10月至次年9月），而非日历年。本数据集共包含8个文件，各文件覆盖的信息范围与数据年份存在差异。以下为各文件的文件名、简要说明、可用数据年份及包含变量： 1. 《2011-2019年逮捕与缉获统计》：涵盖2011至2019年间各边境管区的毒品与武器缉获年度总量。其中毒品数据额外包含缉获量（除海洛因以盎司计量外，其余品类均以磅为单位）。包含变量：边境管区、财年、特殊关注国国民逮捕数、弹药发数、总逮捕数、可卡因缉获量（磅）、可卡因缉获数、走私运输工具、现金（美元计价）、摇头丸缉获量（磅）、摇头丸缉获数、枪支数量、海洛因缉获量（盎司）、海洛因缉获数、大麻缉获量（磅）、大麻缉获数、冰毒缉获量（磅）、冰毒缉获数、其他毒品（非可卡因、海洛因、摇头丸或大麻）缉获量（磅）、其他毒品（非可卡因、海洛因、摇头丸或大麻）缉获数、非墨西哥籍非法移民逮捕数。 2. 《1992-2019年边境巡逻队人员配置》：涵盖1992至2019年间全国各边境管区的在职特工年度数量。包含变量：边境管区、财年、特工数量。 3. 《2000-2019年家庭、无人陪伴儿童及总逮捕统计》：涵盖全国各边境管区的月度统计数据，包括总逮捕数、家庭伴随逮捕数（定义为「美国边境巡逻队逮捕的、与家庭成员一同入境的个体，包括18岁以下儿童、父母或法定监护人」）及无人陪伴儿童逮捕数（定义为「18岁以下单独旅行、无家庭成员陪同的个体」）。其中总逮捕数据覆盖2000至2019年，家庭伴随逮捕数据覆盖2013至2019年，无人陪伴儿童逮捕数据覆盖2010至2019年。包含变量：边境管区、财年、月份、总逮捕数、无人陪伴儿童逮捕数（仅2010-2019财年可用）、家庭伴随逮捕数（仅2013-2019财年可用）。 4. 《2000-2019年非墨西哥籍移民逮捕统计》：涵盖2000至2019年间全国各边境管区的年度逮捕数据，包含墨西哥籍非法移民逮捕数与非墨西哥籍非法移民逮捕数。包含变量：边境管区、财年、总逮捕数、墨西哥籍非法移民总逮捕数、非墨西哥籍非法移民总逮捕数。 5. 《1925-2019年全国总逮捕统计》：统计1925至2019年间美国每年的非法入境移民逮捕总数量。包含变量：财年、总逮捕数。 6. 《2011-2019年边境管区概况》：涵盖2011至2019年间全国各边境管区的多项统计变量。包含变量：边境管区、财年、特工数量、总逮捕数、非墨西哥籍非法移民逮捕数、大麻缉获量（磅）、可卡因缉获量（磅）、起诉受理数、袭击事件数、救援人数（仅西南边境可用）、死亡人数（仅西南边境可用）、随行被捕儿童（18岁以下）数、无人陪伴被捕儿童（18岁以下）数、被捕儿童（18岁以下）总人数、被捕成年（18岁及以上）总人数、被捕女性总人数、被捕男性总人数。 7. 《1960-2019年西南边境逮捕统计》：涵盖1960至2019年间西南边境各管区的年度逮捕数。包含变量：边境管区、财年、总逮捕数。 8. 《1998-2019年西南边境死亡统计》：涵盖1998至2019年间西南边境各管区的年度死亡人数。包含变量：边境管区、财年、死亡人数。 部分数据集按边境管区拆分统计，以下为三大边境区域及其包含的管区列表： - 海岸边境（Coastal Border）：利弗莫尔（2004财年后撤销）、迈阿密、新奥尔良、雷米 - 北部边境（Northern Border）：布莱恩、布法罗、底特律、大福克斯、哈弗尔、霍尔顿、斯波坎 - 西南边境（Southwest Border）：大本德、德尔里奥、埃尔森特罗、埃尔帕索、拉雷多、里奥格兰德河谷、圣迭戈、图森、尤马