2010 atlantic coast conference football season
in the public school type , the only one that joined the acc in the 1970s was georgia tech .
{'scope': 'subset', 'row': '5', 'col': '5', 'col_other': '1', 'criterion': 'fuzzily_match', 'value': '197', 'subset': {'col': '6', 'criterion': 'equal', 'value': 'public'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'school type', 'public'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; school type ; public }', 'tointer': 'select the rows whose school type record fuzzily matches to public .'}, 'joined acc', '197'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose school type record fuzzily matches to public . among these rows , select the rows whose joined acc record fuzzily matches to 197 .', 'tostr': 'filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 } }', 'tointer': 'select the rows whose school type record fuzzily matches to public . among these rows , select the rows whose joined acc record fuzzily matches to 197 . 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', 'school type', 'public'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; school type ; public }', 'tointer': 'select the rows whose school type record fuzzily matches to public .'}, 'joined acc', '197'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose school type record fuzzily matches to public . among these rows , select the rows whose joined acc record fuzzily matches to 197 .', 'tostr': 'filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 }'}, 'institution'], 'result': 'georgia tech', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 } ; institution }'}, 'georgia tech'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 } ; institution } ; georgia tech }', 'tointer': 'the institution record of this unqiue row is georgia tech .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 } } ; eq { hop { filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 } ; institution } ; georgia tech } } = true', 'tointer': 'select the rows whose school type record fuzzily matches to public . among these rows , select the rows whose joined acc record fuzzily matches to 197 . there is only one such row in the table . the institution record of this unqiue row is georgia tech .'}
and { only { filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 } } ; eq { hop { filter_eq { filter_eq { all_rows ; school type ; public } ; joined acc ; 197 } ; institution } ; georgia tech } } = true
select the rows whose school type record fuzzily matches to public . among these rows , select the rows whose joined acc record fuzzily matches to 197 . there is only one such row in the table . the institution record of this unqiue row is georgia tech .
{'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', 'school type_8': 'school type', 'public_9': 'public', 'joined acc_10': 'joined acc', '197_11': '197', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'institution_12': 'institution', 'georgia tech_13': 'georgia tech'}
['institution', 'nickname', 'location', 'founded', 'joined acc', 'school type', 'acc football titles']
[['boston college', 'eagles', 'chestnut hill , massachusetts', '1863', '2005', 'private / jesuit', '0'], ['clemson', 'tigers', 'clemson , south carolina', '1889', '1953', 'public', '13'], ['duke', 'blue devils', 'durham , north carolina', '1838', '1953', 'private / non - sectarian', '7'], ['florida state', 'seminoles', 'tallahassee , florida', '1851', '1991', 'public', '12'], ['georgia tech', 'yellow jackets', 'atlanta , georgia', '1885', '1979', 'public', '3'], ['maryland', 'terrapins', 'college park , maryland', '1856', '1953', 'public', '9'], ['miami', 'hurricanes', 'coral gables , florida', '1925', '2004', 'private / non - sectarian', '0'], ['north carolina', 'tar heels', 'chapel hill , north carolina', '1789', '1953', 'public', '5'], ['nc state', 'wolfpack', 'raleigh , north carolina', '1887', '1953', 'public', '7'], ['virginia', 'cavaliers', 'charlottesville , virginia', '1819', '1953', 'public', '2'], ['virginia tech', 'hokies', 'blacksburg , virginia', '1872', '2004', 'public', '3']]