john garamendi
the only time that john garamendi was elected as state assemblyman was in 1974 .
{'scope': 'all', 'row': '1', 'col': '1', 'col_other': '4', 'criterion': 'equal', 'value': 'state assemblyman', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'office', 'state assemblyman'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose office record fuzzily matches to state assemblyman .', 'tostr': 'filter_eq { all_rows ; office ; state assemblyman }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; office ; state assemblyman } }', 'tointer': 'select the rows whose office record fuzzily matches to state assemblyman . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'office', 'state assemblyman'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose office record fuzzily matches to state assemblyman .', 'tostr': 'filter_eq { all_rows ; office ; state assemblyman }'}, 'elected'], 'result': '1974', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; office ; state assemblyman } ; elected }'}, '1974'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; office ; state assemblyman } ; elected } ; 1974 }', 'tointer': 'the elected record of this unqiue row is 1974 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; office ; state assemblyman } } ; eq { hop { filter_eq { all_rows ; office ; state assemblyman } ; elected } ; 1974 } } = true', 'tointer': 'select the rows whose office record fuzzily matches to state assemblyman . there is only one such row in the table . the elected record of this unqiue row is 1974 .'}
and { only { filter_eq { all_rows ; office ; state assemblyman } } ; eq { hop { filter_eq { all_rows ; office ; state assemblyman } ; elected } ; 1974 } } = true
select the rows whose office record fuzzily matches to state assemblyman . there is only one such row in the table . the elected record of this unqiue row is 1974 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'office_7': 'office', 'state assemblyman_8': 'state assemblyman', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'elected_9': 'elected', '1974_10': '1974'}
['office', 'type', 'location', 'elected', 'term began', 'term ended']
[['state assemblyman', 'legislature', 'sacramento', '1974', 'december 7 , 1974', 'december 2 , 1976'], ['state senator', 'legislature', 'sacramento', '1976', 'december 2 , 1976', 'december 8 , 1980'], ['state senator', 'legislature', 'sacramento', '1980', 'december 8 , 1980', 'december 3 , 1984'], ['state senator', 'legislature', 'sacramento', '1984', 'december 3 , 1984', 'december 5 , 1988'], ['state senator', 'legislature', 'sacramento', '1988', 'december 5 , 1988', 'december 3 , 1990'], ['insurance commissioner', 'executive', 'sacramento', '1990', 'january 7 , 1991', 'january 2 , 1995'], ['insurance commissioner', 'executive', 'sacramento', '2002', 'january 6 , 2003', 'january 8 , 2007'], ['lieutenant governor', 'executive', 'sacramento', '2006', 'january 8 , 2007', 'november 5 , 2009'], ['us representative', 'legislative', 'washington , dc', '2009', 'november 5 , 2009', 'january 3 , 2011']]