1940 vfl season
the vfl crowd size on 15 june 1940 averaged 12,600 across five venues .
{'scope': 'subset', 'col': '6', 'type': 'average', 'result': '12,600', 'subset': {'col': '7', 'criterion': 'equal', 'value': '15 june 1940'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'date', '15 june 1940'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; date ; 15 june 1940 }', 'tointer': 'select the rows whose date record fuzzily matches to 15 june 1940 .'}, 'crowd'], 'result': '12,600', 'ind': 1, 'tostr': 'avg { filter_eq { all_rows ; date ; 15 june 1940 } ; crowd }'}, '12,600'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_eq { all_rows ; date ; 15 june 1940 } ; crowd } ; 12,600 } = true', 'tointer': 'select the rows whose date record fuzzily matches to 15 june 1940 . the average of the crowd record of these rows is 12,600 .'}
round_eq { avg { filter_eq { all_rows ; date ; 15 june 1940 } ; crowd } ; 12,600 } = true
select the rows whose date record fuzzily matches to 15 june 1940 . the average of the crowd record of these rows is 12,600 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'date_5': 'date', '15 june 1940_6': '15 june 1940', 'crowd_7': 'crowd', '12,600_8': '12,600'}
['home team', 'home team score', 'away team', 'away team score', 'venue', 'crowd', 'date']
[['collingwood', '6.13 ( 49 )', 'richmond', '10.15 ( 75 )', 'victoria park', '20000', '15 june 1940'], ['south melbourne', '12.9 ( 81 )', 'st kilda', '10.16 ( 76 )', 'lake oval', '12000', '15 june 1940'], ['north melbourne', '8.15 ( 63 )', 'geelong', '13.20 ( 98 )', 'arden street oval', '5000', '15 june 1940'], ['hawthorn', '8.17 ( 65 )', 'footscray', '15.20 ( 110 )', 'glenferrie oval', '10000', '15 june 1940'], ['essendon', '12.14 ( 86 )', 'carlton', '8.15 ( 63 )', 'windy hill', '16000', '15 june 1940'], ['melbourne', '12.15 ( 87 )', 'fitzroy', '12.13 ( 85 )', 'mcg', '19737', '17 june 1940']]