2.3.8 :007 > vv.first
 => {"name"=>"Adams County, Illinois", "state"=>17}
2.3.8 :008 > vv.first['state']
 => 17
2.3.8 :009 > m_state = vv.first['state']
 => 17
2.3.8 :010 > asd = client.query("select value from census_details where geo_type = 'state' and year = 2017
2.3.8 :011">                                         and name_id = '#{m_state}'
2.3.8 :012">                                         and label = 'Estimate!!Total' and concept = 'Total Population'
2.3.8 :013">                                         and state != 72;").to_a.first['value']
 => 12854526
2.3.8 :014 >