Get the top 100 NYC bike share riders from July, 2013.

bike-share-top-100.sh

curl -s "http://www.civicdata.com/api/action/datastore_search_sql?sql=SELECT%20*%20from%20%229dd48bd2-fa77-43bb-a433-1227b3a17623%22%20ORDER%20BY%20tripduration%20DESC%20LIMIT%20100" \
| sed 's/birth year/birth_year/g;s/start station name/start_station_name/g;s/end station name/end_station_name/g' \
|  jq .result.records[] \
| jq '[.tripduration, .birth_year, .gender, .start_station_name, .end_station_name]' \
| jq @csv \
| sed 's/\\//g;s/""/"/g'

To run the above, you'll need to install jq.

http://stedolan.github.io/jq/

Redirect the output of the above recipe to a new file. Just append with

>> my-new-file.csv