north yorkshire
in north yorkshire , ripon has the highest population among those of civil parish definition .
{'scope': 'subset', 'row': '4', 'col': '3', 'order': '1', 'col_other': '2', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'subset': {'col': '6', 'criterion': 'equal', 'value': 'civil parish'}}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'definition', 'civil parish'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; definition ; civil parish }', 'tointer': 'select the rows whose definition record fuzzily matches to civil parish .'}, 'population', '1'], 'result': None, 'ind': 1, 'tostr': 'nth_argmax { filter_eq { all_rows ; definition ; civil parish } ; population ; 1 }'}, 'town'], 'result': 'ripon', 'ind': 2, 'tostr': 'hop { nth_argmax { filter_eq { all_rows ; definition ; civil parish } ; population ; 1 } ; town }'}, 'ripon'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { nth_argmax { filter_eq { all_rows ; definition ; civil parish } ; population ; 1 } ; town } ; ripon } = true', 'tointer': 'select the rows whose definition record fuzzily matches to civil parish . select the row whose population record of these rows is 1st maximum . the town record of this row is ripon .'}
eq { hop { nth_argmax { filter_eq { all_rows ; definition ; civil parish } ; population ; 1 } ; town } ; ripon } = true
select the rows whose definition record fuzzily matches to civil parish . select the row whose population record of these rows is 1st maximum . the town record of this row is ripon .
{'str_eq_3': 'str_eq', 'result_4': 'true', 'str_hop_2': 'str_hop', 'nth_argmax_1': 'nth_argmax', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'definition_6': 'definition', 'civil parish_7': 'civil parish', 'population_8': 'population', '1_9': '1', 'town_10': 'town', 'ripon_11': 'ripon'}
['rank', 'town', 'population', 'year', 'borough', 'definition']
[['1', 'harrogate', '71594', '2001', 'harrogate', 'town'], ['2', 'scarborough', '50135', '2001', 'scarborough', 'town'], ['3', 'acomb', '22215', '2001', 'york', 'town'], ['4', 'ripon', '15922', '2001', 'harrogate', 'civil parish'], ['5', 'northallerton', '15741', '2001', 'hambleton', 'civil parish'], ['6', 'knaresborough', '14740', '2001', 'harrogate', 'civil parish'], ['7', 'skipton', '14313', '2001', 'craven', 'civil parish'], ['8', 'whitby', '13594', '2001', 'scarborough', 'civil parish'], ['9', 'selby', '13012', '2001', 'selby', 'civil parish'], ['10', 'richmond', '8178', '2001', 'richmondshire', 'civil parish'], ['11', 'tadcaster', '7000', '2001', 'selby', 'civil parish'], ['12', 'norton', '6943', '2001', 'ryedale', 'civil parish'], ['13', 'pickering', '6846', '2001', 'ryedale', 'civil parish'], ['14', 'filey', '6819', '2001', 'scarborough', 'civil parish'], ['15', 'sherburn - in - elmet', '6221', '2001', 'selby', 'civil parish']]