shell script to extract vote counts by location into CSV file from okfnindex2015 voting

votes2csv.sh

# get votes from the map (curl)
# extract the lines containing values and reformat as csv (grep, sed)

echo "lat,lon,votes,location,country" > votes.csv
curl 'http://allourideas.org/globalopendataindex15/voter_map?type=votes' \
 | grep "data.setValue" votes.html \
 | sed 's/.*data.setValue([0-9]*, //;s/);//;s/, /,/' \
 | sed 'N;s/\n[1-3]//' | sed 'N;s/\n[1-3]//' \
 | sed 's/, \(..\)"$/",\1/;s/ ,"/,"/;s/^0,//' \
>> votes.csv