make-red-blue-json.rb

require 'rubygems'
require 'json'
require 'open-uri'

scores = JSON.parse(open('http://spreadsheets.google.com/feeds/list/pVNrsh7EqwD6HkFTmS3v9aw/od6/public/values?alt=json').read); nil

# scores['feed']['entry'].length
newscores = {}

scores['feed']['entry'].each do |e| 
  url = e["gsx$url"]["$t"].split('/')[2]
  newscores[url] = e["gsx$score"]["$t"]
end

puts newscores.to_json