two miles
mike ryan was the only athlete to run two miles out of santa clara , california .
{'scope': 'all', 'row': '1', 'col': '4', 'col_other': '2', 'criterion': 'equal', 'value': 'santa clara , california', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'city', 'santa clara , california'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose city record fuzzily matches to santa clara , california .', 'tostr': 'filter_eq { all_rows ; city ; santa clara , california }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; city ; santa clara , california } }', 'tointer': 'select the rows whose city record fuzzily matches to santa clara , california . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'city', 'santa clara , california'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose city record fuzzily matches to santa clara , california .', 'tostr': 'filter_eq { all_rows ; city ; santa clara , california }'}, 'athlete'], 'result': 'mike ryan', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; city ; santa clara , california } ; athlete }'}, 'mike ryan'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; city ; santa clara , california } ; athlete } ; mike ryan }', 'tointer': 'the athlete record of this unqiue row is mike ryan .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; city ; santa clara , california } } ; eq { hop { filter_eq { all_rows ; city ; santa clara , california } ; athlete } ; mike ryan } } = true', 'tointer': 'select the rows whose city record fuzzily matches to santa clara , california . there is only one such row in the table . the athlete record of this unqiue row is mike ryan .'}
and { only { filter_eq { all_rows ; city ; santa clara , california } } ; eq { hop { filter_eq { all_rows ; city ; santa clara , california } ; athlete } ; mike ryan } } = true
select the rows whose city record fuzzily matches to santa clara , california . there is only one such row in the table . the athlete record of this unqiue row is mike ryan .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'city_7': 'city', 'santa clara, california_8': 'santa clara , california', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'athlete_9': 'athlete', 'mike ryan_10': 'mike ryan'}
['time', 'athlete', 'school', 'city', 'date']
[['8:57.8', 'mike ryan', 'wilcox high school', 'santa clara , california', '1965'], ['8:48.3', 'rick riley', 'ferris high school', 'spokane , washington', 'may 28 , 1966'], ['8:41.5', 'steve prefontaine', 'marshfield high school', 'coos bay , oregon', 'april 25 , 1969'], ['8:40.9', 'craig virgin', 'lebanon high school', 'lebanon , illinois', 'june 9 , 1973'], ['( 8:40.0 i )', 'gerry lindgren', 'rogers high school', 'spokane , washington', 'february 15 , 1964'], ['8:36.3', 'jeff nelson', 'burbank high school', 'burbank , california', 'may 6 , 1979'], ['8:34.23', 'german fernandez', 'riverbank high school', 'riverbank , california', 'june 20 , 2008'], ['8:29.46', 'lukas verzbicas', 'carl sandburg high school', 'orland hills , illinois', 'june 4 , 2011']]