The question that I want to explore is: What U.S. state has the highest arrest rate of prostitution? The dataset used was the UCR Crime Data 2014.
The data were renamed and only U.S states and prostitution arrests were kept in order to answer the question. The data were then arranged in descending order highlighting the state with the highest rate of prostitution arrests per 100,000 of the population and the state with the lowest rate of prostitution arrests per 100,000 of the population.
It is important to note that the results are per 100,000 of the population
library(readr)
library(dplyr)
library(knitr)
CrimeData<-read_csv("/Users/safiesaf/Downloads/R12013569_SL040.csv")
NewCrimeData<-CrimeData%>%
rename("US_States"=Geo_Name,
"Prostitution_Arrests"=SE_T011_017)%>%
select(US_States,Prostitution_Arrests)%>%
arrange(desc(Prostitution_Arrests, na.rm= TRUE))
kable(NewCrimeData)
| US_States | Prostitution_Arrests |
|---|---|
| Nevada | 134.7962857 |
| California | 23.5989949 |
| Tennessee | 21.3761606 |
| Texas | 19.0043699 |
| Pennsylvania | 18.6123493 |
| Hawaii | 17.0475238 |
| Maryland | 16.9667160 |
| Louisiana | 16.1946768 |
| Ohio | 15.9131798 |
| South Carolina | 13.5748048 |
| Arizona | 13.3402976 |
| Wisconsin | 12.0710773 |
| Minnesota | 11.3062203 |
| Virginia | 11.2054722 |
| New Jersey | 10.8523272 |
| Wyoming | 10.7848458 |
| Massachusetts | 10.3033056 |
| Connecticut | 9.7590081 |
| Oregon | 8.1355304 |
| Washington | 8.0577439 |
| Kansas | 7.9889229 |
| Rhode Island | 7.9607799 |
| Arkansas | 7.9221432 |
| Indiana | 7.9128615 |
| New Mexico | 7.8156017 |
| Georgia | 7.6554793 |
| Nebraska | 6.9093698 |
| Delaware | 6.8404278 |
| Utah | 6.5581525 |
| Colorado | 6.5348909 |
| Mississippi | 6.4126564 |
| North Dakota | 6.3558004 |
| Missouri | 6.2174399 |
| South Dakota | 6.0948809 |
| West Virginia | 5.8368093 |
| North Carolina | 5.4605990 |
| Kentucky | 5.0753865 |
| New Hampshire | 5.0496943 |
| Alaska | 5.0015769 |
| New York | 4.7046962 |
| Michigan | 3.9859223 |
| Maine | 3.9095128 |
| Oklahoma | 3.6100608 |
| Vermont | 2.2344157 |
| Iowa | 2.1885176 |
| Idaho | 1.1012785 |
| Montana | 0.7815713 |
| Alabama | 0.0000000 |
| District of Columbia | 0.0000000 |
| Florida | NA |
| Illinois | NA |
#filter(Prostitution_Arrests>100|
#Prostitution_Arrests>=0.70)
#glimpse(NewCrimeData)According to the data, Nevada had the highest level of prostitution arrests per 100,000 of the population with a value of approximately 134.80; meaning that around 4,004 people were arrested for prostitution in 2014 if the population was approximately 3 million. The states that tied with having no prostitution arrests were District of Columbia (D.C) and Alabama. However, Montana technically had the lowest prostitution arrests per 100,000 with a value of 0.78 per 100,000 of the population; meaning that approximately 8 people were arrested in 2014 from a population of approximately 1 million.