tamil nadu dr. m.g.r. medical university
madras medical college and research institute is the only affiliate college of tamil nadu dr mgr medical university to be established before the year 1900 .
{'scope': 'all', 'row': '2', 'col': '5', 'col_other': '1', 'criterion': 'less_than', 'value': '1900', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'estd', '1900'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose estd record is less than 1900 .', 'tostr': 'filter_less { all_rows ; estd ; 1900 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_less { all_rows ; estd ; 1900 } }', 'tointer': 'select the rows whose estd record is less than 1900 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'estd', '1900'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose estd record is less than 1900 .', 'tostr': 'filter_less { all_rows ; estd ; 1900 }'}, 'college name'], 'result': 'madras medical college and research institute', 'ind': 2, 'tostr': 'hop { filter_less { all_rows ; estd ; 1900 } ; college name }'}, 'madras medical college and research institute'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_less { all_rows ; estd ; 1900 } ; college name } ; madras medical college and research institute }', 'tointer': 'the college name record of this unqiue row is madras medical college and research institute .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_less { all_rows ; estd ; 1900 } } ; eq { hop { filter_less { all_rows ; estd ; 1900 } ; college name } ; madras medical college and research institute } } = true', 'tointer': 'select the rows whose estd record is less than 1900 . there is only one such row in the table . the college name record of this unqiue row is madras medical college and research institute .'}
and { only { filter_less { all_rows ; estd ; 1900 } } ; eq { hop { filter_less { all_rows ; estd ; 1900 } ; college name } ; madras medical college and research institute } } = true
select the rows whose estd record is less than 1900 . there is only one such row in the table . the college name record of this unqiue row is madras medical college and research institute .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_less_0': 'filter_less', 'all_rows_6': 'all_rows', 'estd_7': 'estd', '1900_8': '1900', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'college name_9': 'college name', 'madras medical college and research institute_10': 'madras medical college and research institute'}
['college name', 'location', 'district', 'affiliation', 'estd']
[['thanjavur medical college', 'thanjavur', 'thanjavur district', 'tamil nadu dr mgr medical university', '1958'], ['madras medical college and research institute', 'park town , chennai', 'chennai district', 'tamil nadu dr mgr medical university', '1835'], ['stanley medical college', 'royapuram , chennai', 'chennai district', 'tamil nadu dr mgr medical university', '1938'], ['government kilpauk medical college', 'chetput ( chennai ) chennai', 'chennai district', 'tamil nadu dr mgr medical university', '1960'], ['chengalpattu medical college', 'chengalpattu', 'kanchipuram district', 'tamil nadu dr mgr medical university', '1965'], ['madurai medical college', 'madurai', 'madurai district', 'tamil nadu dr mgr medical university', '1954'], ['coimbatore medical college', 'coimbatore', 'coimbatore', 'tamil nadu dr mgr medical university', '1966'], ['tirunelveli medical college', 'tirunelveli', 'tirunelveli district', 'tamil nadu dr mgr medical university', 'july 1966'], ['mohan kumaramangalam medical college', 'salem , tamil nadu', 'salem district', 'tamil nadu dr mgr medical university', '1990'], ['kapviswanatham government medical college', 'tiruchirappalli tamil nadu', 'tiruchirappalli district', 'tamil nadu dr mgr medical university', '1929'], ['thoothukudi medical college', 'thoothukudi', 'thoothukudi', 'tamil nadu dr mgr medical university', '1982'], ['government vellore medical college', 'bagayam', 'vellore', 'tamil nadu dr mgr medical university', '2005'], ['kanyakumari government medical college', 'kanniyakumari', 'kanniyakumari', 'tamil nadu dr mgr medical university', '1965'], ['government theni medical college', 'theni', 'theni', 'tamil nadu dr mgr medical university', '2006'], ['government dharmapuri medical college', 'coimbatore', 'coimbatore', 'tamil nadu dr mgr medical university', '1982'], ['government villupuram medical college', 'villupuram', 'villupuram', 'tamil nadu dr mgr medical university', '1965'], ['government thiruvarur medical college', 'thiruvarur', 'thiruvarur', 'tamil nadu dr mgr medical university', '2007'], ['government sivgangai medical college', 'sivgangai', 'sivgangai', 'tamil nadu dr mgr medical university', 'proposed']]