Gettin the data Using bash: Download the files baseurl="http://www.nyc.gov/html/nypd/downloads/zip/analysis_and_planning/YYYY_sqf_csv.zip" for year in $(seq 2003 2014); do url=$(echo $baseurl | sed "s/YYYY/$year/") echo $url curl -sO $url done Unzip the files unzip -o "*.zip"