24th united states congress
the virginia 2nd district seat was the only seat that was not filled during the 24th united states congress .
{'scope': 'all', 'row': '16', 'col': '5', 'col_other': '1', 'criterion': 'equal', 'value': 'not filled this congress', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'date successor seated', 'not filled this congress'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose date successor seated record fuzzily matches to not filled this congress .', 'tostr': 'filter_eq { all_rows ; date successor seated ; not filled this congress }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; date successor seated ; not filled this congress } }', 'tointer': 'select the rows whose date successor seated record fuzzily matches to not filled this congress . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'date successor seated', 'not filled this congress'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose date successor seated record fuzzily matches to not filled this congress .', 'tostr': 'filter_eq { all_rows ; date successor seated ; not filled this congress }'}, 'district'], 'result': 'virginia 2nd', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; date successor seated ; not filled this congress } ; district }'}, 'virginia 2nd'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; date successor seated ; not filled this congress } ; district } ; virginia 2nd }', 'tointer': 'the district record of this unqiue row is virginia 2nd .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; date successor seated ; not filled this congress } } ; eq { hop { filter_eq { all_rows ; date successor seated ; not filled this congress } ; district } ; virginia 2nd } } = true', 'tointer': 'select the rows whose date successor seated record fuzzily matches to not filled this congress . there is only one such row in the table . the district record of this unqiue row is virginia 2nd .'}
and { only { filter_eq { all_rows ; date successor seated ; not filled this congress } } ; eq { hop { filter_eq { all_rows ; date successor seated ; not filled this congress } ; district } ; virginia 2nd } } = true
select the rows whose date successor seated record fuzzily matches to not filled this congress . there is only one such row in the table . the district record of this unqiue row is virginia 2nd .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'date successor seated_7': 'date successor seated', 'not filled this congress_8': 'not filled this congress', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'district_9': 'district', 'virginia 2nd_10': 'virginia 2nd'}
['district', 'vacator', 'reason for change', 'successor', 'date successor seated']
[['south carolina 6th', 'vacant', 'rep warren r davis died during previous congress', 'waddy thompson , jr ( aj )', 'seated september 10 , 1835'], ['georgia at - large', 'vacant', 'rep james m wayne resigned in previous congress', 'jabez y jackson ( j )', 'seated october 5 , 1835'], ['georgia at - large', 'james c terrell ( j )', 'resigned july 8 , 1835 due to ill health', 'hopkins holsey ( j )', 'seated october 5 , 1835'], ['connecticut at - large', 'zalmon wildman ( j )', 'died december 10 , 1835', 'thomas t whittlesey ( j )', 'seated april 29 , 1836'], ['pennsylvania 24th', 'john banks ( am )', 'resigned sometime in 1836', 'john j pearson ( aj )', 'seated december 5 , 1836'], ['south carolina 4th', 'james h hammond ( n )', 'resigned february 26 , 1836 because of ill health', 'franklin h elmore ( n )', 'seated december 10 , 1836'], ['new york 17th', 'samuel beardsley ( j )', 'resigned march 29 , 1836', 'rutger b miller ( j )', 'seated november 9 , 1836'], ['north carolina 12th', 'james graham ( aj )', 'seat declared vacant march 29 , 1836', 'james graham ( aj', 'seated december 5 , 1836'], ['south carolina 8th', 'richard i manning ( j )', 'died may 1 , 1836', 'john p richardson ( j )', 'seated december 19 , 1836'], ['mississippi at - large', 'david dickson ( aj )', 'died july 31 , 1836', 'samuel j gholson ( j )', 'seated december 1 , 1836'], ['georgia at - large', 'george w towns ( j )', 'resigned september 1 , 1836', 'julius c alford ( aj )', 'seated january 2 , 1837'], ['new york 30th', 'philo c fuller ( aj )', 'resigned september 2 , 1836', 'john young ( aj )', 'seated november 9 , 1836'], ['georgia at - large', 'john e coffee ( j )', 'died september 25 , 1836', 'william c dawson ( aj )', 'seated november 7 , 1836'], ['pennsylvania 13th', 'jesse miller ( j )', 'resigned october 30 , 1836', 'james black ( j )', 'seated december 5 , 1836'], ['indiana 6th', 'george l kinnard ( j )', 'died november 26 , 1836', 'william herod ( aj )', 'seated january 25 , 1837'], ['virginia 2nd', 'john y mason ( j )', 'resigned january 11 , 1837', 'vacant', 'not filled this congress']]