12th united states congress
thomas blount was the only vacator who died in office .
{'scope': 'all', 'row': '3', 'col': '3', 'col_other': '2', 'criterion': 'fuzzily_match', 'value': 'died', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'reason for change', 'died'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose reason for change record fuzzily matches to died .', 'tostr': 'filter_eq { all_rows ; reason for change ; died }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; reason for change ; died } }', 'tointer': 'select the rows whose reason for change record fuzzily matches to died . 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', 'died'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose reason for change record fuzzily matches to died .', 'tostr': 'filter_eq { all_rows ; reason for change ; died }'}, 'vacator'], 'result': 'thomas blount ( dr )', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; reason for change ; died } ; vacator }'}, 'thomas blount ( dr )'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; reason for change ; died } ; vacator } ; thomas blount ( dr ) }', 'tointer': 'the vacator record of this unqiue row is thomas blount ( dr ) .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; reason for change ; died } } ; eq { hop { filter_eq { all_rows ; reason for change ; died } ; vacator } ; thomas blount ( dr ) } } = true', 'tointer': 'select the rows whose reason for change record fuzzily matches to died . there is only one such row in the table . the vacator record of this unqiue row is thomas blount ( dr ) .'}
and { only { filter_eq { all_rows ; reason for change ; died } } ; eq { hop { filter_eq { all_rows ; reason for change ; died } ; vacator } ; thomas blount ( dr ) } } = true
select the rows whose reason for change record fuzzily matches to died . there is only one such row in the table . the vacator record of this unqiue row is thomas blount ( dr ) .
{'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', 'died_8': 'died', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'vacator_9': 'vacator', 'thomas blount (dr)_10': 'thomas blount ( dr )'}
['district', 'vacator', 'reason for change', 'successor', 'date successor seated']
[['massachusetts 4th', 'joseph b varnum ( dr )', 'resigned june 29 , 1811 to become us senator', 'william m richardson ( dr )', 'seated november 4 , 1811'], ['virginia 8th', 'john hungerford ( dr )', 'lost contested election november 29 , 1811', 'john taliaferro ( dr )', 'seated november 29 , 1811'], ['north carolina 3rd', 'thomas blount ( dr )', 'died february 7 , 1812', 'william kennedy ( dr )', 'seated january 30 , 1813'], ['new york 6th', 'robert le roy livingston ( f )', 'resigned may 6 , 1812', 'thomas p grosvenor ( f )', 'seated january 29 , 1813'], ['missouri territory', 'territory delegate seat established', 'territory delegate seat established', 'edward hempstead', 'seated november 9 , 1812'], ['illinois territory', 'territory delegate seat established', 'territory delegate seat established', 'shadrach bond', 'seated december 3 , 1812']]