rural community
saint - andré is the only rural community located in new brunswick that has a population under 1000 in 2006 .
{'scope': 'all', 'row': '4', 'col': '3', 'col_other': '1', 'criterion': 'less_than', 'value': '1000', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'population ( 2006 )', '1000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose population ( 2006 ) record is less than 1000 .', 'tostr': 'filter_less { all_rows ; population ( 2006 ) ; 1000 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_less { all_rows ; population ( 2006 ) ; 1000 } }', 'tointer': 'select the rows whose population ( 2006 ) record is less than 1000 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'population ( 2006 )', '1000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose population ( 2006 ) record is less than 1000 .', 'tostr': 'filter_less { all_rows ; population ( 2006 ) ; 1000 }'}, 'name'], 'result': 'saint - andré', 'ind': 2, 'tostr': 'hop { filter_less { all_rows ; population ( 2006 ) ; 1000 } ; name }'}, 'saint - andré'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_less { all_rows ; population ( 2006 ) ; 1000 } ; name } ; saint - andré }', 'tointer': 'the name record of this unqiue row is saint - andré .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_less { all_rows ; population ( 2006 ) ; 1000 } } ; eq { hop { filter_less { all_rows ; population ( 2006 ) ; 1000 } ; name } ; saint - andré } } = true', 'tointer': 'select the rows whose population ( 2006 ) record is less than 1000 . there is only one such row in the table . the name record of this unqiue row is saint - andré .'}
and { only { filter_less { all_rows ; population ( 2006 ) ; 1000 } } ; eq { hop { filter_less { all_rows ; population ( 2006 ) ; 1000 } ; name } ; saint - andré } } = true
select the rows whose population ( 2006 ) record is less than 1000 . there is only one such row in the table . the name record of this unqiue row is saint - andré .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_less_0': 'filter_less', 'all_rows_6': 'all_rows', 'population (2006)_7': 'population ( 2006 )', '1000_8': '1000', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'name_9': 'name', 'saint - andré_10': 'saint - andré'}
['name', 'population ( 2011 )', 'population ( 2006 )', 'change ( % )', 'area ( km square )', 'population density']
[['beaubassin east', '6200', '6429', '- 3.6', '291.12', '21.3'], ['campobello island', '925', '1056', '- 12.4', '39.67', '23.3'], ['kedgwick', '993', '1146', '- 13.4', '4.28', '232.2'], ['saint - andré', '819', '868', '- 5.6', '8.12', '100.8'], ['upper miramichi', '2373', '2414', '- 1.7', '1835.01', '1.3']]