united states house of representatives elections , 1974
harold r collier is the only incumbent who retired .
{'scope': 'all', 'row': '3', 'col': '5', 'col_other': '2', 'criterion': 'fuzzily_match', 'value': 'retired', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'result', 'retired'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose result record fuzzily matches to retired .', 'tostr': 'filter_eq { all_rows ; result ; retired }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; result ; retired } }', 'tointer': 'select the rows whose result record fuzzily matches to retired . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'result', 'retired'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose result record fuzzily matches to retired .', 'tostr': 'filter_eq { all_rows ; result ; retired }'}, 'incumbent'], 'result': 'harold r collier', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; result ; retired } ; incumbent }'}, 'harold r collier'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; result ; retired } ; incumbent } ; harold r collier }', 'tointer': 'the incumbent record of this unqiue row is harold r collier .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; result ; retired } } ; eq { hop { filter_eq { all_rows ; result ; retired } ; incumbent } ; harold r collier } } = true', 'tointer': 'select the rows whose result record fuzzily matches to retired . there is only one such row in the table . the incumbent record of this unqiue row is harold r collier .'}
and { only { filter_eq { all_rows ; result ; retired } } ; eq { hop { filter_eq { all_rows ; result ; retired } ; incumbent } ; harold r collier } } = true
select the rows whose result record fuzzily matches to retired . there is only one such row in the table . the incumbent record of this unqiue row is harold r collier .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'result_7': 'result', 'retired_8': 'retired', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'incumbent_9': 'incumbent', 'harold r collier_10': 'harold r collier'}
['district', 'incumbent', 'party', 'first elected', 'result', 'candidates']
[['illinois 3', 'robert p hanrahan', 'republican', '1972', 'lost re - election democratic gain', 'marty russo ( d ) 52.6 % robert p hanrahan ( r ) 47.4 %'], ['illinois 4', 'ed derwinski', 'republican', '1958', 're - elected', 'ed derwinski ( r ) 59.2 % ronald a rodger ( d ) 40.8 %'], ['illinois 6', 'harold r collier', 'republican', '1956', 'retired republican hold', 'henry hyde ( r ) 53.4 % edward v hanrahan ( d ) 46.6 %'], ['illinois 9', 'sidney r yates', 'democratic', '1964', 're - elected', 'sidney r yates ( d ) unopposed'], ['illinois 10', 'samuel h young', 'republican', '1972', 'lost re - election democratic gain', 'abner j mikva ( d ) 50.9 % samuel h young ( r ) 49.1 %'], ['illinois 12', 'phil crane', 'republican', '1969', 're - elected', 'phil crane ( r ) 61.1 % betty c spence ( d ) 38.9 %'], ['illinois 19', 'tom railsback', 'republican', '1966', 're - elected', 'tom railsback ( r ) 65.3 % jim gende ( d ) 34.7 %'], ['illinois 20', 'paul findley', 'republican', '1960', 're - elected', 'paul findley ( r ) 54.8 % peter f mack ( d ) 45.2 %'], ['illinois 23', 'melvin price', 'democratic', '1944', 're - elected', 'melvin price ( d ) 80.5 % scott randolph ( r ) 19.5 %']]