united states house of representatives elections , 1812
north carolina 9 was the only district of the 1812 house of representatives elections with a new seat democratic - republican gain .
{'scope': 'all', 'row': '4', 'col': '5', 'col_other': '1', 'criterion': 'equal', 'value': 'new seat democratic - republican gain', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'result', 'new seat democratic - republican gain'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose result record fuzzily matches to new seat democratic - republican gain .', 'tostr': 'filter_eq { all_rows ; result ; new seat democratic - republican gain }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; result ; new seat democratic - republican gain } }', 'tointer': 'select the rows whose result record fuzzily matches to new seat democratic - republican gain . 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', 'new seat democratic - republican gain'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose result record fuzzily matches to new seat democratic - republican gain .', 'tostr': 'filter_eq { all_rows ; result ; new seat democratic - republican gain }'}, 'district'], 'result': 'north carolina 9', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; result ; new seat democratic - republican gain } ; district }'}, 'north carolina 9'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; result ; new seat democratic - republican gain } ; district } ; north carolina 9 }', 'tointer': 'the district record of this unqiue row is north carolina 9 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; result ; new seat democratic - republican gain } } ; eq { hop { filter_eq { all_rows ; result ; new seat democratic - republican gain } ; district } ; north carolina 9 } } = true', 'tointer': 'select the rows whose result record fuzzily matches to new seat democratic - republican gain . there is only one such row in the table . the district record of this unqiue row is north carolina 9 .'}
and { only { filter_eq { all_rows ; result ; new seat democratic - republican gain } } ; eq { hop { filter_eq { all_rows ; result ; new seat democratic - republican gain } ; district } ; north carolina 9 } } = true
select the rows whose result record fuzzily matches to new seat democratic - republican gain . there is only one such row in the table . the district record of this unqiue row is north carolina 9 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'result_7': 'result', 'new seat democratic - republican gain_8': 'new seat democratic - republican gain', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'district_9': 'district', 'north carolina 9_10': 'north carolina 9'}
['district', 'incumbent', 'party', 'first elected', 'result', 'candidates']
[['north carolina 2', 'willis alston', 'democratic - republican', '1798', 're - elected', 'willis alston ( dr ) 56.0 % daniel mason ( f ) 44.0 %'], ['north carolina 5', 'william r king', 'democratic - republican', '1810', 're - elected', 'william r king ( dr ) 100 %'], ['north carolina 6', 'nathaniel macon', 'democratic - republican', '1791', 're - elected', 'nathaniel macon ( dr )'], ['north carolina 9', 'none ( district created )', 'none ( district created )', 'none ( district created )', 'new seat democratic - republican gain', 'bartlett yancey ( dr ) 61.1 % james martin ( f ) 38.9 %'], ['north carolina 10', 'joseph pearson', 'federalist', '1808', 're - elected', 'joseph pearson ( f ) 54.1 % alexander gary ( dr ) 45.9 %']]