[Request] Arrests and stops in NY Boroughs with race, income etc.

I am doing exploratory research on the prevalence of police action in NY neighborhoods, including demographic elements and their impact on those communities.

Thanks.

Posted Apr 14, 2014, 11:34 AM UTC

43
TwoFucksGiven•

Here's the data for all Stop and Frisks: http://www.nyc.gov/html/nypd/html/analysis_and_planning/stop_question_and_frisk_report.shtml. It's an SPSS portable file which is kind of a bummer. I'm not sure where to find arrests in general though.

2
orangepotionOP•

Thank you very much.

1
bordumb•

http://www.statmethods.net/input/importingdata.html

R, which is free, has some libraries that can read SPSS files and you can also convert them to CSV or anything else if need be. Personally, I did the following with the stop/frisk data a while back:

  1. Downloaded SPSS files
  2. Converted to CSV
  3. Imported into a PostgreSQL database
  4. Unioned all the different year tables

And now I can query and run analysis through other tools really easily.

1