cleethorpes coast light railway
the ted railway train was the only one to be colored brown .
{'scope': 'all', 'row': '1', 'col': '6', 'col_other': '1', 'criterion': 'equal', 'value': 'brown', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'colour', 'brown'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose colour record fuzzily matches to brown .', 'tostr': 'filter_eq { all_rows ; colour ; brown }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; colour ; brown } }', 'tointer': 'select the rows whose colour record fuzzily matches to brown . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'colour', 'brown'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose colour record fuzzily matches to brown .', 'tostr': 'filter_eq { all_rows ; colour ; brown }'}, 'name'], 'result': 'ted', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; colour ; brown } ; name }'}, 'ted'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; colour ; brown } ; name } ; ted }', 'tointer': 'the name record of this unqiue row is ted .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; colour ; brown } } ; eq { hop { filter_eq { all_rows ; colour ; brown } ; name } ; ted } } = true', 'tointer': 'select the rows whose colour record fuzzily matches to brown . there is only one such row in the table . the name record of this unqiue row is ted .'}
and { only { filter_eq { all_rows ; colour ; brown } } ; eq { hop { filter_eq { all_rows ; colour ; brown } ; name } ; ted } } = true
select the rows whose colour record fuzzily matches to brown . there is only one such row in the table . the name record of this unqiue row is ted .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'colour_7': 'colour', 'brown_8': 'brown', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'name_9': 'name', 'ted_10': 'ted'}
['name', 'built', 'wheels', 'fuel / trans', 'status', 'colour']
[['ted', 'lister 1944', '0 - 4 - 0', 'diesel - mechanical', 'under rebuild', 'brown'], ['the cub / john', 'minirail 1954', '0 - 4 - 0 bo', 'diesel - hydraulic', 'stored', 'grey undercoat'], ['battison', 'battison 1958', '2 - 6 - 4de', 'diesel - electric', 'out of service', 'lner black'], ['dudley', 'g & s light engineering 1946', 'bo - bo', '4 petrol - mechanical', 'on display', 'grey & red'], ['da1', 'bush mill railway 1986', '0 - 4 - 0', 'diesel - mechanical', 'in service', 'royal blue with white linings'], ['kd1', 'unknown', 'articulated', 'diesel electric', 'long term restoration , stored', 'ran in a red livery previously']]