indiana high school athletics conferences : ohio river valley - western indiana
the denver warriors had 40 fewer people enrolled than the wabash norsemen .
{'row_1': '3', 'row_2': '2', 'col': '4', 'col_other': '2,3', 'relation': 'diff', 'record_mentioned': 'no', 'diff_result': {'diff_value': '40', 'bigger': 'row2'}}
{'func': 'and', 'args': [{'func': 'eq', 'args': [{'func': 'diff', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'mascot', 'warriors'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose mascot record fuzzily matches to warriors .', 'tostr': 'filter_eq { all_rows ; mascot ; warriors }'}, 'enrollment'], 'result': None, 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; mascot ; warriors } ; enrollment }', 'tointer': 'select the rows whose mascot record fuzzily matches to warriors . take the enrollment record of this row .'}, {'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'mascot', 'norsemen'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose mascot record fuzzily matches to norsemen .', 'tostr': 'filter_eq { all_rows ; mascot ; norsemen }'}, 'enrollment'], 'result': None, 'ind': 3, 'tostr': 'hop { filter_eq { all_rows ; mascot ; norsemen } ; enrollment }', 'tointer': 'select the rows whose mascot record fuzzily matches to norsemen . take the enrollment record of this row .'}], 'result': '-40', 'ind': 4, 'tostr': 'diff { hop { filter_eq { all_rows ; mascot ; warriors } ; enrollment } ; hop { filter_eq { all_rows ; mascot ; norsemen } ; enrollment } }'}, '-40'], 'result': True, 'ind': 5, 'tostr': 'eq { diff { hop { filter_eq { all_rows ; mascot ; warriors } ; enrollment } ; hop { filter_eq { all_rows ; mascot ; norsemen } ; enrollment } } ; -40 }', 'tointer': 'select the rows whose mascot record fuzzily matches to warriors . take the enrollment record of this row . select the rows whose mascot record fuzzily matches to norsemen . take the enrollment record of this row . the second record is 40 larger than the first record .'}, {'func': 'and', 'args': [{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'mascot', 'warriors'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose mascot record fuzzily matches to warriors .', 'tostr': 'filter_eq { all_rows ; mascot ; warriors }'}, 'location'], 'result': 'denver', 'ind': 6, 'tostr': 'hop { filter_eq { all_rows ; mascot ; warriors } ; location }'}, 'denver'], 'result': True, 'ind': 7, 'tostr': 'eq { hop { filter_eq { all_rows ; mascot ; warriors } ; location } ; denver }', 'tointer': 'the location record of the first row is denver .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'mascot', 'norsemen'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose mascot record fuzzily matches to norsemen .', 'tostr': 'filter_eq { all_rows ; mascot ; norsemen }'}, 'location'], 'result': 'wabash', 'ind': 8, 'tostr': 'hop { filter_eq { all_rows ; mascot ; norsemen } ; location }'}, 'wabash'], 'result': True, 'ind': 9, 'tostr': 'eq { hop { filter_eq { all_rows ; mascot ; norsemen } ; location } ; wabash }', 'tointer': 'the location record of the second row is wabash .'}], 'result': True, 'ind': 10, 'tostr': 'and { eq { hop { filter_eq { all_rows ; mascot ; warriors } ; location } ; denver } ; eq { hop { filter_eq { all_rows ; mascot ; norsemen } ; location } ; wabash } }', 'tointer': 'the location record of the first row is denver . the location record of the second row is wabash .'}], 'result': True, 'ind': 11, 'tostr': 'and { eq { diff { hop { filter_eq { all_rows ; mascot ; warriors } ; enrollment } ; hop { filter_eq { all_rows ; mascot ; norsemen } ; enrollment } } ; -40 } ; and { eq { hop { filter_eq { all_rows ; mascot ; warriors } ; location } ; denver } ; eq { hop { filter_eq { all_rows ; mascot ; norsemen } ; location } ; wabash } } } = true', 'tointer': 'select the rows whose mascot record fuzzily matches to warriors . take the enrollment record of this row . select the rows whose mascot record fuzzily matches to norsemen . take the enrollment record of this row . the second record is 40 larger than the first record . the location record of the first row is denver . the location record of the second row is wabash .'}
and { eq { diff { hop { filter_eq { all_rows ; mascot ; warriors } ; enrollment } ; hop { filter_eq { all_rows ; mascot ; norsemen } ; enrollment } } ; -40 } ; and { eq { hop { filter_eq { all_rows ; mascot ; warriors } ; location } ; denver } ; eq { hop { filter_eq { all_rows ; mascot ; norsemen } ; location } ; wabash } } } = true
select the rows whose mascot record fuzzily matches to warriors . take the enrollment record of this row . select the rows whose mascot record fuzzily matches to norsemen . take the enrollment record of this row . the second record is 40 larger than the first record . the location record of the first row is denver . the location record of the second row is wabash .
{'and_11': 'and', 'result_12': 'true', 'eq_5': 'eq', 'diff_4': 'diff', 'num_hop_2': 'num_hop', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_13': 'all_rows', 'mascot_14': 'mascot', 'warriors_15': 'warriors', 'enrollment_16': 'enrollment', 'num_hop_3': 'num_hop', 'filter_str_eq_1': 'filter_str_eq', 'all_rows_17': 'all_rows', 'mascot_18': 'mascot', 'norsemen_19': 'norsemen', 'enrollment_20': 'enrollment', '-40_21': '-40', 'and_10': 'and', 'str_eq_7': 'str_eq', 'str_hop_6': 'str_hop', 'location_22': 'location', 'denver_23': 'denver', 'str_eq_9': 'str_eq', 'str_hop_8': 'str_hop', 'location_24': 'location', 'wabash_25': 'wabash'}
['school', 'location', 'mascot', 'enrollment', 'ihsaa class', 'ihsaa football class', 'county']
[['manchester', 'north manchester', 'squires', '432', 'aa', 'aa', '85 wabash'], ['northfield', 'wabash', 'norsemen', '389', 'aa', 'a', '85 wabash'], ['north miami', 'denver', 'warriors', '349', 'aa', 'a', '52 miami'], ['rochester community', 'rochester', 'zebras', '565', 'aa', 'aa', '25 fulton'], ['southwood', 'wabash', 'knights', '413', 'aa', 'a', '85 wabash'], ['tippecanoe valley', 'akron', 'vikings', '618', 'aaa', 'aaa', '43 kosciusko'], ['wabash', 'wabash', 'apachees', '447', 'aa', 'aa', '85 wabash'], ['whitko', 'south whitley', 'wildcats', '595', 'aaa', 'aaa', '92 whitley']]