54th united states congress
in the 54th united states congress , of the successors that took office in 1895 , the only time that the vacancy was due to a resignation was when the vacator was edwin j jordan .
{'scope': 'subset', 'row': '1', 'col': '3', 'col_other': '2', 'criterion': 'equal', 'value': 'resigned', 'subset': {'col': '5', 'criterion': 'fuzzily_match', 'value': '1895'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'date of successors taking office', '1895'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; date of successors taking office ; 1895 }', 'tointer': 'select the rows whose date of successors taking office record fuzzily matches to 1895 .'}, 'reason for vacancy', 'resigned'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose date of successors taking office record fuzzily matches to 1895 . among these rows , select the rows whose reason for vacancy record fuzzily matches to resigned .', 'tostr': 'filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned } }', 'tointer': 'select the rows whose date of successors taking office record fuzzily matches to 1895 . among these rows , select the rows whose reason for vacancy 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': [{'func': 'filter_str_eq', 'args': ['all_rows', 'date of successors taking office', '1895'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; date of successors taking office ; 1895 }', 'tointer': 'select the rows whose date of successors taking office record fuzzily matches to 1895 .'}, 'reason for vacancy', 'resigned'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose date of successors taking office record fuzzily matches to 1895 . among these rows , select the rows whose reason for vacancy record fuzzily matches to resigned .', 'tostr': 'filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned }'}, 'vacator'], 'result': 'edwin j jordan ( r )', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned } ; vacator }'}, 'edwin j jordan ( r )'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned } ; vacator } ; edwin j jordan ( r ) }', 'tointer': 'the vacator record of this unqiue row is edwin j jordan ( r ) .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned } } ; eq { hop { filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned } ; vacator } ; edwin j jordan ( r ) } } = true', 'tointer': 'select the rows whose date of successors taking office record fuzzily matches to 1895 . among these rows , select the rows whose reason for vacancy record fuzzily matches to resigned . there is only one such row in the table . the vacator record of this unqiue row is edwin j jordan ( r ) .'}
and { only { filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned } } ; eq { hop { filter_eq { filter_eq { all_rows ; date of successors taking office ; 1895 } ; reason for vacancy ; resigned } ; vacator } ; edwin j jordan ( r ) } } = true
select the rows whose date of successors taking office record fuzzily matches to 1895 . among these rows , select the rows whose reason for vacancy record fuzzily matches to resigned . there is only one such row in the table . the vacator record of this unqiue row is edwin j jordan ( r ) .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'date of successors taking office_8': 'date of successors taking office', '1895_9': '1895', 'reason for vacancy_10': 'reason for vacancy', 'resigned_11': 'resigned', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'vacator_12': 'vacator', 'edwin j jordan (r)_13': 'edwin j jordan ( r )'}
['district', 'vacator', 'reason for vacancy', 'successor', 'date of successors taking office']
[['pennsylvania 15th', 'edwin j jordan ( r )', 'resigned march 4 , 1895', 'james h codding ( r )', 'november 5 , 1895'], ['utah at - large', 'new seat', 'state was admitted to the union', 'clarence e allen ( r )', 'january 4 , 1896'], ['massachusetts 6th', 'william cogswell ( r )', 'died may 22 , 1895', 'william h moody ( r )', 'november 5 , 1895'], ['illinois 18th', 'frederick remann ( r )', 'died july 14 , 1895', 'william f l hadley ( r )', 'december 2 , 1895'], ['utah territory al', 'frank j cannon ( r )', 'resigned january 4 , 1896', 'statehood achieved', 'statehood achieved'], ['texas 11th', 'william h crain ( d )', 'died february 10 , 1896', 'rudolph kleberg ( d )', 'april 7 , 1896'], ['georgia 3rd', 'charles f crisp ( d )', 'died october 23 , 1896', 'charles r crisp ( d )', 'december 19 , 1896']]