césar cielo
the only event where césar cielo did the butterfly , was in rio de janeiro .
{'scope': 'all', 'row': '4', 'col': '1', 'col_other': '3', 'criterion': 'fuzzily_match', 'value': 'butterfly', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'event', 'butterfly'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose event record fuzzily matches to butterfly .', 'tostr': 'filter_eq { all_rows ; event ; butterfly }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; event ; butterfly } }', 'tointer': 'select the rows whose event record fuzzily matches to butterfly . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'event', 'butterfly'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose event record fuzzily matches to butterfly .', 'tostr': 'filter_eq { all_rows ; event ; butterfly }'}, 'venue'], 'result': 'rio de janeiro', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; event ; butterfly } ; venue }'}, 'rio de janeiro'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; event ; butterfly } ; venue } ; rio de janeiro }', 'tointer': 'the venue record of this unqiue row is rio de janeiro .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; event ; butterfly } } ; eq { hop { filter_eq { all_rows ; event ; butterfly } ; venue } ; rio de janeiro } } = true', 'tointer': 'select the rows whose event record fuzzily matches to butterfly . there is only one such row in the table . the venue record of this unqiue row is rio de janeiro .'}
and { only { filter_eq { all_rows ; event ; butterfly } } ; eq { hop { filter_eq { all_rows ; event ; butterfly } ; venue } ; rio de janeiro } } = true
select the rows whose event record fuzzily matches to butterfly . there is only one such row in the table . the venue record of this unqiue row is rio de janeiro .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'event_7': 'event', 'butterfly_8': 'butterfly', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'venue_9': 'venue', 'rio de janeiro_10': 'rio de janeiro'}
['event', 'time', 'venue', 'date', 'notes']
[['50 m freestyle', '20.91', 'são paulo', 'december 18 , 2009', 'wr'], ['100 m freestyle', '46.91', 'rome', 'july 30 , 2009', 'wr'], ['50 m freestyle', '21.30', 'beijing', 'august 16 , 2008', 'or'], ['50 m butterfly', '22.76', 'rio de janeiro', 'april 26 , 2012', 'am'], ['450 m freestyle', '1:26.12', 'são paulo', 'december 19 , 2009', 'sa'], ['4100 m freestyle', '3:10.80', 'rome', 'july 26 , 2009', 'sa'], ['4100 m medley', '3:29.16', 'rome', 'august 2 , 2009', 'sa']]