Campus Crime Rates

Sweet mother of Abraham Lincoln, this one was difficult. The FBI crime statistics had to be pulled up one year at a time, and came in the form of massive files with data for approximately 600 colleges each year. I had to merge 2008-2011, create some new fields that generated results so I could get rate per 1,000 students (instead of absolute number of crimes), and generally do a ton of work you won’t see in the final product.

Which is this:




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s