list of birmingham city f.c. records and statistics
joe bradford began playing for birmingham city f. c. 50 years before trevor francis .
{'row_1': '1', 'row_2': '2', 'col': '2', 'col_other': '1', 'relation': 'diff', 'record_mentioned': 'no', 'diff_result': {'diff_value': '50 years', 'bigger': 'row2'}}
{'func': 'eq', 'args': [{'func': 'diff', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'name', 'joe bradford'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose name record fuzzily matches to joe bradford .', 'tostr': 'filter_eq { all_rows ; name ; joe bradford }'}, 'years'], 'result': None, 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; name ; joe bradford } ; years }', 'tointer': 'select the rows whose name record fuzzily matches to joe bradford . take the years record of this row .'}, {'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'name', 'trevor francis'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose name record fuzzily matches to trevor francis .', 'tostr': 'filter_eq { all_rows ; name ; trevor francis }'}, 'years'], 'result': None, 'ind': 3, 'tostr': 'hop { filter_eq { all_rows ; name ; trevor francis } ; years }', 'tointer': 'select the rows whose name record fuzzily matches to trevor francis . take the years record of this row .'}], 'result': '-50 years', 'ind': 4, 'tostr': 'diff { hop { filter_eq { all_rows ; name ; joe bradford } ; years } ; hop { filter_eq { all_rows ; name ; trevor francis } ; years } }'}, '-50 years'], 'result': True, 'ind': 5, 'tostr': 'eq { diff { hop { filter_eq { all_rows ; name ; joe bradford } ; years } ; hop { filter_eq { all_rows ; name ; trevor francis } ; years } } ; -50 years } = true', 'tointer': 'select the rows whose name record fuzzily matches to joe bradford . take the years record of this row . select the rows whose name record fuzzily matches to trevor francis . take the years record of this row . the second record is 50 years larger than the first record .'}
eq { diff { hop { filter_eq { all_rows ; name ; joe bradford } ; years } ; hop { filter_eq { all_rows ; name ; trevor francis } ; years } } ; -50 years } = true
select the rows whose name record fuzzily matches to joe bradford . take the years record of this row . select the rows whose name record fuzzily matches to trevor francis . take the years record of this row . the second record is 50 years larger than the first record .
{'str_eq_5': 'str_eq', 'result_6': 'true', 'diff_4': 'diff', 'str_hop_2': 'str_hop', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'name_8': 'name', 'joe bradford_9': 'joe bradford', 'years_10': 'years', 'str_hop_3': 'str_hop', 'filter_str_eq_1': 'filter_str_eq', 'all_rows_11': 'all_rows', 'name_12': 'name', 'trevor francis_13': 'trevor francis', 'years_14': 'years', '-50 years_15': '-50 years'}
['name', 'years', 'league a', 'fa cup', 'league cup', 'other b', 'total']
[['joe bradford', '1920 - 1935', '249 ( 414 )', '18 ( 31 )', '0 ( 0 )', '0 ( 0 )', '267 ( 445 )'], ['trevor francis', '1970 - 1979', '119 ( 280 )', '6 ( 20 )', '4 ( 19 )', '4 ( 10 )', '133 ( 329 )'], ['peter murphy', '1952 - 1960', '107 ( 245 )', '16 ( 24 )', '0 ( 0 )', '4 ( 9 )', '127 ( 278 )'], ['fred wheldon', '1890 - 1896', '99 ( 155 )', '12 ( 13 )', '0 ( 0 )', '5 ( 7 )', '116 ( 175 )'], ['george briggs', '1924 - 1933', '98 ( 298 )', '9 ( 26 )', '0 ( 0 )', '0 ( 0 )', '107 ( 324 )'], ['billy jones', '1901 - 1909 1912 - 1913', '99 ( 236 )', '3 ( 17 )', '0 ( 0 )', '0 ( 0 )', '102 ( 253 )'], ['geoff vowden', '1964 - 1970', '79 ( 221 )', '8 ( 16 )', '7 ( 16 )', '0 ( 0 )', '94 ( 253 )'], ['eddy brown', '1954 - 1958', '74 ( 158 )', '13 ( 18 )', '0 ( 0 )', '3 ( 9 )', '90 ( 185 )'], ['bob latchford', '1969 - 1974', '68 ( 160 )', '6 ( 12 )', '6 ( 16 )', '4 ( 6 )', '84 ( 193 )'], ['bob mcroberts', '1898 - 1905', '70 ( 173 )', '12 ( 14 )', '0 ( 0 )', '0 ( 0 )', '82 ( 187 )']]