Ugly as hell Ruby

ashamed.rb

get '/sent_distributions/:email' do |@email|
  raw_data = mongo['sentdist'].find_one({:email => @email})['sent_dist']
  puts JSON raw_data
  @data = (0..23).map do |hour|
    key = to_key(hour)
    puts "Key: |#{key}|"
    value = Integer  
    index = raw_data.find_index{ |record| record['sent_hour'] == key }
    if index
      value = raw_data[index]['total']
    else
      value = 0
    end
    puts "{'sent_hour': #{key}, 'total': #{value}}"
    {'sent_hour' => key, 'total' => value}
  end

  @json = JSON @data
  puts @json
  erb :'partials/distribution'
end