2009 supersport world championship season
in the 2009 supersport world championship season , when cal crutchlow had the pole position , the only race in spain was on april 5th .
{'scope': 'subset', 'row': '3', 'col': '2', 'col_other': '4', 'criterion': 'equal', 'value': 'spain', 'subset': {'col': '5', 'criterion': 'equal', 'value': 'cal crutchlow'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'pole position', 'cal crutchlow'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; pole position ; cal crutchlow }', 'tointer': 'select the rows whose pole position record fuzzily matches to cal crutchlow .'}, 'country', 'spain'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose pole position record fuzzily matches to cal crutchlow . among these rows , select the rows whose country record fuzzily matches to spain .', 'tostr': 'filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain } }', 'tointer': 'select the rows whose pole position record fuzzily matches to cal crutchlow . among these rows , select the rows whose country record fuzzily matches to spain . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'pole position', 'cal crutchlow'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; pole position ; cal crutchlow }', 'tointer': 'select the rows whose pole position record fuzzily matches to cal crutchlow .'}, 'country', 'spain'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose pole position record fuzzily matches to cal crutchlow . among these rows , select the rows whose country record fuzzily matches to spain .', 'tostr': 'filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain }'}, 'date'], 'result': '5 april', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain } ; date }'}, '5 april'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain } ; date } ; 5 april }', 'tointer': 'the date record of this unqiue row is 5 april .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain } } ; eq { hop { filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain } ; date } ; 5 april } } = true', 'tointer': 'select the rows whose pole position record fuzzily matches to cal crutchlow . among these rows , select the rows whose country record fuzzily matches to spain . there is only one such row in the table . the date record of this unqiue row is 5 april .'}
and { only { filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain } } ; eq { hop { filter_eq { filter_eq { all_rows ; pole position ; cal crutchlow } ; country ; spain } ; date } ; 5 april } } = true
select the rows whose pole position record fuzzily matches to cal crutchlow . among these rows , select the rows whose country record fuzzily matches to spain . there is only one such row in the table . the date record of this unqiue row is 5 april .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'pole position_8': 'pole position', 'cal crutchlow_9': 'cal crutchlow', 'country_10': 'country', 'spain_11': 'spain', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'date_12': 'date', '5 april_13': '5 april'}
['round', 'country', 'circuit', 'date', 'pole position', 'fastest lap', 'winning rider', 'winning team', 'report']
[['1', 'australia', 'phillip island grand prix circuit', '1 march', 'kenan sofuoğlu', 'andrew pitt', 'kenan sofuoğlu', 'ten kate honda', 'report'], ['2', 'qatar', 'losail international circuit', '14 march', 'cal crutchlow', 'andrew pitt', 'eugene laverty', 'parkalgar honda', 'report'], ['3', 'spain', 'circuit ricardo tormo', '5 april', 'cal crutchlow', 'cal crutchlow', 'cal crutchlow', 'yamaha world supersport', 'report'], ['4', 'netherlands', 'tt circuit assen', '26 april', 'cal crutchlow', 'cal crutchlow', 'eugene laverty', 'parkalgar honda', 'report'], ['5', 'italy', 'autodromo nazionale monza', '10 may', 'cal crutchlow', 'cal crutchlow', 'cal crutchlow', 'yamaha world supersport', 'report'], ['6', 'south africa', 'kyalami', '17 may', 'cal crutchlow', 'eugene laverty', 'eugene laverty', 'parkalgar honda', 'report'], ['7', 'united states', 'miller motorsports park', '31 may', 'joan lascorz', 'kenan sofuoğlu', 'kenan sofuoğlu', 'ten kate honda', 'report'], ['8', 'san marino', 'misano world circuit', '21 june', 'michele pirro', 'cal crutchlow', 'cal crutchlow', 'yamaha world supersport', 'report'], ['9', 'great britain', 'donington park', '28 june', 'cal crutchlow', 'cal crutchlow', 'cal crutchlow', 'yamaha world supersport', 'report'], ['10', 'czech republic', 'masaryk circuit', '26 july', 'cal crutchlow', 'cal crutchlow', 'fabien foret', 'yamaha world supersport', 'report'], ['11', 'germany', 'nürburgring', '6 september', 'cal crutchlow', 'cal crutchlow', 'cal crutchlow', 'yamaha world supersport', 'report'], ['12', 'italy', 'autodromo enzo e dino ferrari', '27 september', 'cal crutchlow', 'cal crutchlow', 'kenan sofuoğlu', 'ten kate honda', 'report'], ['13', 'france', 'circuit de nevers magny - cours', '4 october', 'cal crutchlow', 'cal crutchlow', 'joan lascorz', 'provec kawasaki', 'report']]