2007 - 08 uci america tour
tour de santa catarina is the only race that took place in brazil .
{'scope': 'all', 'row': '5', 'col': '3', 'col_other': '2', 'criterion': 'equal', 'value': 'brazil', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'location', 'brazil'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose location record fuzzily matches to brazil .', 'tostr': 'filter_eq { all_rows ; location ; brazil }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; location ; brazil } }', 'tointer': 'select the rows whose location record fuzzily matches to brazil . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'location', 'brazil'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose location record fuzzily matches to brazil .', 'tostr': 'filter_eq { all_rows ; location ; brazil }'}, 'race name'], 'result': 'tour de santa catarina', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; location ; brazil } ; race name }'}, 'tour de santa catarina'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; location ; brazil } ; race name } ; tour de santa catarina }', 'tointer': 'the race name record of this unqiue row is tour de santa catarina .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; location ; brazil } } ; eq { hop { filter_eq { all_rows ; location ; brazil } ; race name } ; tour de santa catarina } } = true', 'tointer': 'select the rows whose location record fuzzily matches to brazil . there is only one such row in the table . the race name record of this unqiue row is tour de santa catarina .'}
and { only { filter_eq { all_rows ; location ; brazil } } ; eq { hop { filter_eq { all_rows ; location ; brazil } ; race name } ; tour de santa catarina } } = true
select the rows whose location record fuzzily matches to brazil . there is only one such row in the table . the race name record of this unqiue row is tour de santa catarina .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'location_7': 'location', 'brazil_8': 'brazil', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'race name_9': 'race name', 'tour de santa catarina_10': 'tour de santa catarina'}
['date', 'race name', 'location', 'uci rating', 'winner', 'team']
[['7 - 14 october', 'clasico ciclistico banfoandes', 'venezuela', '2.2', 'sergio luis henao ( col )', 'colombia és pasión coldeportes'], ['7 - 14 october', 'vuelta chihuahua internacional', 'mexico', '2.2', 'francisco mancebo ( esp )', 'relax - gam'], ['20 october - 1 november', 'vuelta a guatemala', 'guatemala', '2.2', 'carlos lópez ( mex )', "canel 's - turbo - mayordomo"], ['6 - 11 november', 'doble copacabana gp fides', 'bolivia', '2.2', 'óscar soliz ( bol )', 'coordinadora ebsa'], ['15 - 25 november', 'tour de santa catarina', 'brazil', '2.2', 'alex diniz ( bra )', 'scott - marcondes cesar - são josé dos campos'], ['17 - 25 november', 'vuelta a ecuador', 'ecuador', '2.2', 'alex atapuma ( col )', 'indernariño'], ['14 - 28 december', 'vuelta ciclista a costa rica', 'costa rica', '2.2', 'henry raabe ( crc )', 'bcr - pizza hut']]