28th united states congress
the tennessee ( 2 ) seat in the 28th united states congress was the only seat that had failure to elect as a reason for change .
{'scope': 'all', 'row': '1', 'col': '3', 'col_other': '1', 'criterion': 'equal', 'value': 'failure to elect', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'reason for change', 'failure to elect'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose reason for change record fuzzily matches to failure to elect .', 'tostr': 'filter_eq { all_rows ; reason for change ; failure to elect }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; reason for change ; failure to elect } }', 'tointer': 'select the rows whose reason for change record fuzzily matches to failure to elect . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'reason for change', 'failure to elect'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose reason for change record fuzzily matches to failure to elect .', 'tostr': 'filter_eq { all_rows ; reason for change ; failure to elect }'}, 'state ( class )'], 'result': 'tennessee ( 2 )', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; reason for change ; failure to elect } ; state ( class ) }'}, 'tennessee ( 2 )'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; reason for change ; failure to elect } ; state ( class ) } ; tennessee ( 2 ) }', 'tointer': 'the state ( class ) record of this unqiue row is tennessee ( 2 ) .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; reason for change ; failure to elect } } ; eq { hop { filter_eq { all_rows ; reason for change ; failure to elect } ; state ( class ) } ; tennessee ( 2 ) } } = true', 'tointer': 'select the rows whose reason for change record fuzzily matches to failure to elect . there is only one such row in the table . the state ( class ) record of this unqiue row is tennessee ( 2 ) .'}
and { only { filter_eq { all_rows ; reason for change ; failure to elect } } ; eq { hop { filter_eq { all_rows ; reason for change ; failure to elect } ; state ( class ) } ; tennessee ( 2 ) } } = true
select the rows whose reason for change record fuzzily matches to failure to elect . there is only one such row in the table . the state ( class ) record of this unqiue row is tennessee ( 2 ) .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'reason for change_7': 'reason for change', 'failure to elect_8': 'failure to elect', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'state (class)_9': 'state ( class )', 'tennessee (2)_10': 'tennessee ( 2 )'}
['state ( class )', 'vacator', 'reason for change', 'successor', 'date of successors formal installation']
[['tennessee ( 2 )', 'vacant', 'failure to elect', 'spencer jarnagin ( w )', 'elected october 17 , 1843'], ['maine ( 1 )', 'vacant', 'rep reuel williams resigned in previous congress', 'john fairfield ( d )', 'elected december 4 , 1843'], ['illinois ( 2 )', 'samuel mcroberts ( d )', 'died march 27 , 1843', 'james semple ( d )', 'elected december 4 , 1843'], ['missouri ( 3 )', 'lewis f linn ( d )', 'died october 3 , 1843', 'david r atchison ( d )', 'elected december 14 , 1843'], ['rhode island ( 1 )', 'william sprague ( d )', 'resigned january 17 , 1844', 'john b francis ( lo )', 'elected january 25 , 1844'], ['arkansas ( 2 )', 'william s fulton ( d )', 'died august 15 , 1844', 'chester ashley ( d )', 'elected november 8 , 1844'], ['new york ( 3 )', 'henry a foster ( d )', 'successor elected january 27 , 1845', 'john a dix ( d )', 'elected january 27 , 1845'], ['south carolina ( 2 )', 'daniel e huger ( d )', 'resigned march 3 , 1845', 'vacant', 'not filled this term'], ['florida ( 1 )', 'vacant', 'florida admitted to the union march 3 , 1845', 'vacant', 'not filled this term']]