united states house of representatives elections , 2006
harold ford jr is the only tennessee representative to retire to run for senate .
{'scope': 'all', 'row': '9', 'col': '5', 'col_other': '2', 'criterion': 'equal', 'value': 'retired to run for us senate democratic hold', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'results', 'retired to run for us senate democratic hold'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose results record fuzzily matches to retired to run for us senate democratic hold .', 'tostr': 'filter_eq { all_rows ; results ; retired to run for us senate democratic hold }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; results ; retired to run for us senate democratic hold } }', 'tointer': 'select the rows whose results record fuzzily matches to retired to run for us senate democratic hold . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'results', 'retired to run for us senate democratic hold'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose results record fuzzily matches to retired to run for us senate democratic hold .', 'tostr': 'filter_eq { all_rows ; results ; retired to run for us senate democratic hold }'}, 'incumbent'], 'result': 'harold ford jr', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; results ; retired to run for us senate democratic hold } ; incumbent }'}, 'harold ford jr'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; results ; retired to run for us senate democratic hold } ; incumbent } ; harold ford jr }', 'tointer': 'the incumbent record of this unqiue row is harold ford jr .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; results ; retired to run for us senate democratic hold } } ; eq { hop { filter_eq { all_rows ; results ; retired to run for us senate democratic hold } ; incumbent } ; harold ford jr } } = true', 'tointer': 'select the rows whose results record fuzzily matches to retired to run for us senate democratic hold . there is only one such row in the table . the incumbent record of this unqiue row is harold ford jr .'}
and { only { filter_eq { all_rows ; results ; retired to run for us senate democratic hold } } ; eq { hop { filter_eq { all_rows ; results ; retired to run for us senate democratic hold } ; incumbent } ; harold ford jr } } = true
select the rows whose results record fuzzily matches to retired to run for us senate democratic hold . there is only one such row in the table . the incumbent record of this unqiue row is harold ford jr .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'results_7': 'results', 'retired to run for us senate democratic hold_8': 'retired to run for us senate democratic hold', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'incumbent_9': 'incumbent', 'harold ford jr_10': 'harold ford jr'}
['district', 'incumbent', 'party', 'first elected', 'results']
[['tennessee 1', 'william l jenkins', 'republican', '1996', 'retired republican hold'], ['tennessee 2', 'jimmy duncan jr', 'republican', '1998', 're - elected'], ['tennessee 3', 'zach wamp', 'republican', '1994', 're - elected'], ['tennessee 4', 'lincoln davis', 'democratic', '2002', 're - elected'], ['tennessee 5', 'jim cooper', 'democratic', '2002', 're - elected'], ['tennessee 6', 'bart gordon', 'democratic', '1984', 're - elected'], ['tennessee 7', 'marsha blackburn', 'republican', '2002', 're - elected'], ['tennessee 8', 'john tanner', 'democratic', '1988', 're - elected'], ['tennessee 9', 'harold ford jr', 'democratic', '1996', 'retired to run for us senate democratic hold']]