kjil
for kjil , when the class is d , there were two frequencies under 90.0 .
{'scope': 'subset', 'criterion': 'less_than', 'value': '90.0', 'result': '2', 'col': '2', 'subset': {'col': '5', 'criterion': 'equal', 'value': 'd'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_less', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'class', 'd'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; class ; d }', 'tointer': 'select the rows whose class record fuzzily matches to d .'}, 'frequency mhz', '90.0'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose class record fuzzily matches to d . among these rows , select the rows whose frequency mhz record is less than 90.0 .', 'tostr': 'filter_less { filter_eq { all_rows ; class ; d } ; frequency mhz ; 90.0 }'}], 'result': '2', 'ind': 2, 'tostr': 'count { filter_less { filter_eq { all_rows ; class ; d } ; frequency mhz ; 90.0 } }', 'tointer': 'select the rows whose class record fuzzily matches to d . among these rows , select the rows whose frequency mhz record is less than 90.0 . the number of such rows is 2 .'}, '2'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_less { filter_eq { all_rows ; class ; d } ; frequency mhz ; 90.0 } } ; 2 } = true', 'tointer': 'select the rows whose class record fuzzily matches to d . among these rows , select the rows whose frequency mhz record is less than 90.0 . the number of such rows is 2 .'}
eq { count { filter_less { filter_eq { all_rows ; class ; d } ; frequency mhz ; 90.0 } } ; 2 } = true
select the rows whose class record fuzzily matches to d . among these rows , select the rows whose frequency mhz record is less than 90.0 . the number of such rows is 2 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_less_1': 'filter_less', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'class_6': 'class', 'd_7': 'd', 'frequency mhz_8': 'frequency mhz', '90.0_9': '90.0', '2_10': '2'}
['call sign', 'frequency mhz', 'city of license', 'erp w', 'class', 'fcc info']
[['kngm', '88.9', 'guymon , oklahoma', '25000', 'c3', 'fcc'], ['kjov', '90.7', 'woodward , oklahoma', '25000', 'c2', 'fcc'], ['kjhl', '90.9', 'boise city , oklahoma', '10000', 'c3', 'fcc'], ['k229av', '93.7', 'alva , oklahoma', '170', 'd', 'fcc'], ['k204fy', '88.7', 'fairview , oklahoma', '50', 'd', 'fcc'], ['k202dc', '88.3', 'shattuck , oklahoma', '230', 'd', 'fcc']]