Jacob Kaplan's Concatenated Files: Uniform Crime Reporting (UCR) Program Data: Arrests by Age, Sex, and Race, 1974-2019

For a comprehensive guide to this data and other UCR data, please see my book at ucrbook.comVersion 12 release notes:Adds 2019 data.Version 11 release notes:Changes release notes description, does not change data.Version 10 release notes:The data now has the following age categories (which were previously aggregated into larger groups to reduce file size): under 10, 10-12, 13-14, 40-44, 45-49, 50-54, 55-59, 60-64, over 64. These categories are available for female, male, and total (female+male) arrests. The previous aggregated categories (under 15,  40-49, and over 49 have been removed from the data). Version 9 release notes:For each offense, adds a variable indicating the number of months that offense was reported - these variables are labeled as "num_months_[crime]" where [crime] is the offense name. These variables are generated by the number of times one or more arrests were reported per month for that crime. For example, if there was at least one arrest for assault in January, February, March, and August (and no other months), there would be four months reported for assault. Please note that this does not differentiate between an agency not reporting that month and actually having zero arrests. The variable "number_of_months_reported" is still in the data and is the number of months that any offense was reported. So if any agency reports murder arrests every month but no other crimes, the murder number of months variable and the "number_of_months_reported" variable will both be 12 while every other offense number of month variable will be 0. Adds data for 2017 and 2018.Version 8 release notes:Adds annual data in R format.Changes project name to avoid confusing this data for the ones done by NACJD.Fixes bug where bookmaking was excluded as an arrest category. Changed the number of categories to include more offenses per category to have fewer total files. Added a "total_race" file for each category - this file has total arrests by race for each crime and a breakdown of juvenile/adult by race. Version 7 release notes: Adds 1974-1979 dataAdds monthly data (only totals by sex and race, not by age-categories). All data now from FBI, not NACJD. Changes some column names so all columns are <=32 characters to be usable in Stata.Changes how number of months reported is calculated. Now it is the number of unique months with arrest data reported - months of data from the monthly header file (i.e. juvenile disposition data) are not considered in this calculation. Version 6 release notes: Fix bug where juvenile female columns had the same value as juvenile male columns.Version 5 release notes: Removes support for SPSS and Excel data.Changes the crimes that are stored in each file. There are more files now with fewer crimes per file. The files and their included crimes have been updated below.Adds in agencies that report 0 months of the year.Adds a column that indicates the number of months reported. This is generated summing up the number of unique months an agency reports data for. Note that this indicates the number of months an agency reported arrests for ANY crime. They may not necessarily report every crime every month. Agencies that did not report a crime with have a value of NA for every arrest column for that crime.Removes data on runaways.Version 4 release notes: Changes column names from "poss_coke" and "sale_coke" to "poss_heroin_coke" and "sale_heroin_coke" to clearly indicate that these column includes the sale of heroin as well as similar opiates such as morphine, codeine, and opium. Also changes column names for the narcotic columns to indicate that they are only for synthetic narcotics. Version 3 release notes: Add data for 2016.Order rows by year (descending) and ORI.Version 2 release notes: Fix bug where Philadelphia Police Department had incorrect FIPS county code. The Arrests by Age, Sex, and Race (ASR) data is an FBI data set that is part of the annual Uniform Crime Reporting (UCR) Program data. This data contains highly granular data on the number of people arrested for a variety of crimes (see below for a full list of included crimes). The data sets here combine data from the years 1974-2019 into a single file for each group of crimes. Each monthly file is only a single year as my laptop can't handle combining all the years together. These files are quite large and may take some time to load. Col

为获取关于本数据集及其他UCR数据集的全面指南，请参阅我所著书籍，详情请访问ucrbook.com。版本12发布说明：新增2019年数据。版本11发布说明：修改了发布说明的描述，但未更改数据。版本10发布说明：数据现在包含以下年龄类别（这些类别之前被合并为较大的组以减少文件大小）：10岁以下、10-12岁、13-14岁、40-44岁、45-49岁、50-54岁、55-59岁、60-64岁、64岁以上。这些类别适用于女性、男性和总逮捕人数（女性+男性）。之前的合并类别（15岁以下、40-49岁及以上）已从数据中删除。版本9发布说明：针对每种违法行为，增加了一个变量，表示该违法行为被报告的月份数——这些变量被标记为“num_months_[crime]”，其中[crime]是违法行为名称。这些变量是通过统计每月报告的逮捕次数来生成的。例如，如果1月、2月、3月和8月（且没有其他月份）至少有一起攻击逮捕，则攻击报告的月份数将为四个月。请注意，此变量并不能区分一个机构未报告该月和实际上没有逮捕的情况。变量“number_of_months_reported”仍然存在于数据中，表示任何违法行为被报告的月份数。因此，如果任何机构每月报告谋杀逮捕，但没有其他犯罪，则谋杀月份数变量和“number_of_months_reported”变量都将为12，而其他所有违法行为的月份数变量将为0。新增2017年和2018年的数据。版本8发布说明：新增R格式的年度数据。将项目名称更改为避免与NACJD进行的其他数据混淆。修复了将赌博排除为逮捕类别的错误。将类别数量增加到每个类别包含更多违法行为，以减少总文件数。为每个类别添加了一个“total_race”文件——此文件包含每种犯罪的种族总逮捕人数以及青少年/成人按种族的细分。版本7发布说明：新增1974-1979年的数据。新增月度数据（仅按性别和种族汇总，不包括按年龄类别汇总）。所有数据现在来自FBI，而不是NACJD。更改了一些列名，以确保所有列的长度均不超过32个字符，以便在Stata中使用。更改了计算报告月份数的方法。现在，它是报告逮捕数据的唯一月份的数量——不考虑月度标题文件（即青少年处置数据）中的数据月份。版本6发布说明：修复了青少年女性列与青少年男性列具有相同值的错误。版本5发布说明：移除了对SPSS和Excel数据支持。更改了每个文件中存储的犯罪。现在有更多文件，每个文件包含的犯罪数量更少。以下列出了文件及其包含的犯罪。新增报告了全年0个月的机构。新增了一个指示报告月份数的列。这是通过累加机构报告数据的唯一月份的数量来生成的。请注意，这表示机构报告了任何犯罪的月份数。他们可能并不一定每个月都报告所有犯罪。未报告犯罪的机构，该犯罪的每个逮捕列的值将为NA。移除了关于逃跑者的数据。版本4发布说明：将列名从“poss_coke”和“sale_coke”更改为“poss_heroin_coke”和“sale_heroin_coke”，以明确指出这些列包括海洛因以及类似吗啡、可待因和鸦片等类似阿片类药物的销售。同时更改了麻醉品列的名称，以表明它们仅针对合成麻醉品。版本3发布说明：新增2016年的数据。按年份（降序）和ORI排序。版本2发布说明：修复了费城警察局有错误的FIPS县代码的错误。逮捕按年龄、性别和种族（ASR）数据是美国联邦调查局（FBI）的数据集，是年度统一犯罪报告（UCR）计划数据的一部分。该数据集包含关于因各种犯罪而被逮捕的人数的高度细化数据（以下为包含的犯罪全列表）。此处的数据集将1974-2019年的数据合并为单个文件。每个月度文件仅包含一个年份，因为我的笔记本电脑无法处理所有年份的合并。这些文件相当大，可能需要一些时间才能加载。