lonhro
lonhro 's distance between august 18 , 2001 and september 15 , 2001 was 1300 m.
{'scope': 'subset', 'col': '6', 'type': 'average', 'result': '1300', 'subset': {'col': '2', 'criterion': 'less_than_eq', 'value': 'september 15 2001'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_less_eq', 'args': ['all_rows', 'date', 'september 15 2001'], 'result': None, 'ind': 0, 'tostr': 'filter_less_eq { all_rows ; date ; september 15 2001 }', 'tointer': 'select the rows whose date record is less than or equal to september 15 2001 .'}, 'distance'], 'result': '1300', 'ind': 1, 'tostr': 'avg { filter_less_eq { all_rows ; date ; september 15 2001 } ; distance }'}, '1300'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_less_eq { all_rows ; date ; september 15 2001 } ; distance } ; 1300 } = true', 'tointer': 'select the rows whose date record is less than or equal to september 15 2001 . the average of the distance record of these rows is 1300 .'}
round_eq { avg { filter_less_eq { all_rows ; date ; september 15 2001 } ; distance } ; 1300 } = true
select the rows whose date record is less than or equal to september 15 2001 . the average of the distance record of these rows is 1300 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_less_eq_0': 'filter_less_eq', 'all_rows_4': 'all_rows', 'date_5': 'date', 'september 15 2001_6': 'september 15 2001', 'distance_7': 'distance', '1300_8': '1300'}
['result', 'date', 'race', 'venue', 'group', 'distance', 'weight ( kg )', 'time', 'jockey', 'winner / 2nd']
[['won', '18 aug 2001', 'warwick stakes', 'warwick farm', 'g2', '1300 m', '49.5', '1:17.30', 'd mclellan', '2nd - diamond dane'], ['won', '01 sep 2001', 'ming dynasty quality', 'randwick', 'g3', '1400 m', '57.5', '1:23.87', 'r quinn', '2nd - prince of play'], ['won', '15 sep 2001', 'heritage stakes', 'rosehill', 'lr', '1200 m', '55.5', '1:10.28', 'r quinn', '2nd - perfect crime'], ['won', '29 sep 2001', 'stan fox stakes', 'randwick', 'g2', '1400 m', '55', '1:24.00', 'r quinn', '2nd - magic albert'], ['won', '13 oct 2001', 'caulfield guineas', 'caulfield', 'g1', '1600 m', '55.5', '1:36.70', 'd gauci', '2nd - ustinov'], ['won', '02 feb 2002', 'royal sovereign stakes', 'warwick farm', 'g2', '1200 m', '57.5', '1:11.06', 'r quinn', '2nd - viking ruler'], ['won', '16 feb 2002', 'hobartville stakes', 'randwick', 'g2', '1400 m', '55.5', '1:23.58', 'r quinn', '2nd - athens']]