1963 vfl season
in the 1963 vfl season , when the crowd is over 20000 , the only time the venue is mcg is when the home team is melbourne .
{'scope': 'subset', 'row': '1', 'col': '5', 'col_other': '2', 'criterion': 'equal', 'value': 'mcg', 'subset': {'col': '6', 'criterion': 'greater_than', 'value': '20000'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'crowd', '20000'], 'result': None, 'ind': 0, 'tostr': 'filter_greater { all_rows ; crowd ; 20000 }', 'tointer': 'select the rows whose crowd record is greater than 20000 .'}, 'venue', 'mcg'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose crowd record is greater than 20000 . among these rows , select the rows whose venue record fuzzily matches to mcg .', 'tostr': 'filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg } }', 'tointer': 'select the rows whose crowd record is greater than 20000 . among these rows , select the rows whose venue record fuzzily matches to mcg . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'crowd', '20000'], 'result': None, 'ind': 0, 'tostr': 'filter_greater { all_rows ; crowd ; 20000 }', 'tointer': 'select the rows whose crowd record is greater than 20000 .'}, 'venue', 'mcg'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose crowd record is greater than 20000 . among these rows , select the rows whose venue record fuzzily matches to mcg .', 'tostr': 'filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg }'}, 'home team score'], 'result': '18.6 ( 114 )', 'ind': 3, 'tostr': 'hop { filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg } ; home team score }'}, '18.6 ( 114 )'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg } ; home team score } ; 18.6 ( 114 ) }', 'tointer': 'the home team score record of this unqiue row is 18.6 ( 114 ) .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg } } ; eq { hop { filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg } ; home team score } ; 18.6 ( 114 ) } } = true', 'tointer': 'select the rows whose crowd record is greater than 20000 . among these rows , select the rows whose venue record fuzzily matches to mcg . there is only one such row in the table . the home team score record of this unqiue row is 18.6 ( 114 ) .'}
and { only { filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg } } ; eq { hop { filter_eq { filter_greater { all_rows ; crowd ; 20000 } ; venue ; mcg } ; home team score } ; 18.6 ( 114 ) } } = true
select the rows whose crowd record is greater than 20000 . among these rows , select the rows whose venue record fuzzily matches to mcg . there is only one such row in the table . the home team score record of this unqiue row is 18.6 ( 114 ) .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_str_eq_1': 'filter_str_eq', 'filter_greater_0': 'filter_greater', 'all_rows_7': 'all_rows', 'crowd_8': 'crowd', '20000_9': '20000', 'venue_10': 'venue', 'mcg_11': 'mcg', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'home team score_12': 'home team score', '18.6 (114)_13': '18.6 ( 114 )'}
['home team', 'home team score', 'away team', 'away team score', 'venue', 'crowd', 'date']
[['melbourne', '18.6 ( 114 )', 'north melbourne', '9.10 ( 64 )', 'mcg', '23971', '22 june 1963'], ['geelong', '16.13 ( 109 )', 'richmond', '10.11 ( 71 )', 'kardinia park', '20681', '22 june 1963'], ['essendon', '4.16 ( 40 )', 'st kilda', '8.8 ( 56 )', 'windy hill', '24725', '22 june 1963'], ['collingwood', '11.6 ( 72 )', 'footscray', '6.4 ( 40 )', 'victoria park', '26173', '22 june 1963'], ['south melbourne', '8.10 ( 58 )', 'fitzroy', '5.9 ( 39 )', 'lake oval', '12850', '22 june 1963'], ['hawthorn', '9.6 ( 60 )', 'carlton', '7.12 ( 54 )', 'glenferrie oval', '25300', '22 june 1963']]