alberta senate nominee election , 2004
link byfield is the only elected candidate in the alberta senate nominee election of 2004 that resigned .
{'scope': 'all', 'row': '4', 'col': '7', 'col_other': '1', 'criterion': 'equal', 'value': 'resigned', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'appointed', 'resigned'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose appointed record fuzzily matches to resigned .', 'tostr': 'filter_eq { all_rows ; appointed ; resigned }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; appointed ; resigned } }', 'tointer': 'select the rows whose appointed record fuzzily matches to resigned . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'appointed', 'resigned'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose appointed record fuzzily matches to resigned .', 'tostr': 'filter_eq { all_rows ; appointed ; resigned }'}, 'candidate'], 'result': 'link byfield', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; appointed ; resigned } ; candidate }'}, 'link byfield'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; appointed ; resigned } ; candidate } ; link byfield }', 'tointer': 'the candidate record of this unqiue row is link byfield .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; appointed ; resigned } } ; eq { hop { filter_eq { all_rows ; appointed ; resigned } ; candidate } ; link byfield } } = true', 'tointer': 'select the rows whose appointed record fuzzily matches to resigned . there is only one such row in the table . the candidate record of this unqiue row is link byfield .'}
and { only { filter_eq { all_rows ; appointed ; resigned } } ; eq { hop { filter_eq { all_rows ; appointed ; resigned } ; candidate } ; link byfield } } = true
select the rows whose appointed record fuzzily matches to resigned . there is only one such row in the table . the candidate record of this unqiue row is link byfield .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'appointed_7': 'appointed', 'resigned_8': 'resigned', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'candidate_9': 'candidate', 'link byfield_10': 'link byfield'}
['candidate', 'party', 'votes', 'votes %', 'ballots %', 'elected', 'appointed']
[['bert brown', 'progressive conservative', '312041', '14.3 %', '43.7 %', 'x', 'july 10 , 2007'], ['betty unger', 'progressive conservative', '311964', '14.3 %', '43.6 %', 'x', 'january 6 , 2012'], ['cliff breitkreuz', 'progressive conservative', '241306', '11.1 %', '33.8 %', 'x', 'term ended march 26 , 2012'], ['link byfield', 'independent', '238751', '11.0 %', '33.4 %', 'x', 'resigned november 2010'], ['jim silye', 'progressive conservative', '217857', '10.0 %', '30.5 %', '30.5 %', '30.5 %'], ['david usherwood', 'progressive conservative', '193056', '8.9 %', '27.0 %', '27.0 %', '27.0 %'], ['michael roth', 'alberta alliance', '176339', '8.1 %', '24.7 %', '24.7 %', '24.7 %'], ['vance gough', 'alberta alliance', '167770', '7.7 %', '23.5 %', '23.5 %', '23.5 %'], ['tom sindlinger', 'independent', '161082', '7.4 %', '22.5 %', '22.5 %', '22.5 %'], ['gary horan', 'alberta alliance', '156175', '7.2 %', '21.9 %', '21.9 %', '21.9 %']]