mid - states football association
trine university is the only mid - states institution with the whac primary conference when joining the msfa .
{'scope': 'all', 'row': '10', 'col': '9', 'col_other': '1', 'criterion': 'equal', 'value': 'whac', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'primary conference when joining the msfa', 'whac'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose primary conference when joining the msfa record fuzzily matches to whac .', 'tostr': 'filter_eq { all_rows ; primary conference when joining the msfa ; whac }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; primary conference when joining the msfa ; whac } }', 'tointer': 'select the rows whose primary conference when joining the msfa record fuzzily matches to whac . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'primary conference when joining the msfa', 'whac'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose primary conference when joining the msfa record fuzzily matches to whac .', 'tostr': 'filter_eq { all_rows ; primary conference when joining the msfa ; whac }'}, 'institution'], 'result': 'trine university', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; primary conference when joining the msfa ; whac } ; institution }'}, 'trine university'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; primary conference when joining the msfa ; whac } ; institution } ; trine university }', 'tointer': 'the institution record of this unqiue row is trine university .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; primary conference when joining the msfa ; whac } } ; eq { hop { filter_eq { all_rows ; primary conference when joining the msfa ; whac } ; institution } ; trine university } } = true', 'tointer': 'select the rows whose primary conference when joining the msfa record fuzzily matches to whac . there is only one such row in the table . the institution record of this unqiue row is trine university .'}
and { only { filter_eq { all_rows ; primary conference when joining the msfa ; whac } } ; eq { hop { filter_eq { all_rows ; primary conference when joining the msfa ; whac } ; institution } ; trine university } } = true
select the rows whose primary conference when joining the msfa record fuzzily matches to whac . there is only one such row in the table . the institution record of this unqiue row is trine university .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'primary conference when joining the msfa_7': 'primary conference when joining the msfa', 'whac_8': 'whac', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'institution_9': 'institution', 'trine university_10': 'trine university'}
['institution', 'location', 'founded', 'type', 'enrollment', 'joined', 'left', 'nickname', 'primary conference when joining the msfa', 'current primary conference']
[['university of findlay', 'findlay , ohio', '1882', 'private', '4600', '1994 - 95', '1997 - 98', 'oilers', 'american mideast', 'gliac ( ncaa division ii )'], ['geneva college', 'beaver falls , pennsylvania', '1848', 'private', '1791', '1994 - 95', '2006 - 07', 'golden tornadoes', 'american mideast', "presidents ' ( pac ) ( ncaa division iii )"], ['iowa wesleyan college', 'mount pleasant , iowa', '1842', 'private', '850', '1996 - 97', '2011 - 12', 'tigers', 'mcc', 'ncaa d - iii independent'], ['lindenwood university', 'st charles , missouri', '1827', 'private', '17351', '1994 - 95', '1995 - 96', 'lions', 'american midwest', 'miaa ( ncaa division ii )'], ['malone university', 'canton , ohio', '1892', 'private', '2559', '1994 - 95', '2010 - 11', 'pioneers', 'american mideast', 'gliac ( ncaa division ii )'], ['mckendree university', 'lebanon , illinois', '1828', 'private', '3220', '1998 - 99', '2010 - 11', 'bearcats', 'american midwest', 'glvc ( ncaa division ii )'], ['ohio dominican university', 'columbus , ohio', '1911', 'private', '3052', '2004 - 05', '2008 - 09', 'panthers', 'american mideast', 'gliac ( ncaa division ii )'], ['quincy university', 'quincy , illinois', '1860', 'private', '1169', '2003 - 04', '2011 - 12', 'hawks', 'glvc ( ncaa division ii )', 'glvc ( ncaa division ii )'], ['tiffin university', 'tiffin , ohio', '1888', 'private', '6816', '1994 - 95', '2001 - 02', 'dragons', 'american mideast', 'gliac ( ncaa division ii )'], ['trine university', 'angola , indiana', '1884', 'private', '1779', '1996 - 97', '2002 - 03', 'thunder', 'whac', 'miaa ( ncaa division iii )'], ['urbana university', 'urbana , ohio', '1850', 'private', '1505', '1994 - 95', '2007 - 08', 'blue knights', 'american mideast', 'g - mac ( ncaa division ii )'], ['walsh university', 'north canton , ohio', '1960', 'private', '2500', '1996 - 97', '2010 - 11', 'cavaliers', 'american mideast', 'gliac ( ncaa division ii )']]