good news network
for good news network , when the city of license is in georgia , there were 4 times when the class was a.
{'scope': 'subset', 'criterion': 'equal', 'value': 'a', 'result': '4', 'col': '5', 'subset': {'col': '3', 'criterion': 'fuzzily_match', 'value': 'ga'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'city of license', 'ga'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; city of license ; ga }', 'tointer': 'select the rows whose city of license record fuzzily matches to ga .'}, 'class', 'a'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose city of license record fuzzily matches to ga . among these rows , select the rows whose class record fuzzily matches to a .', 'tostr': 'filter_eq { filter_eq { all_rows ; city of license ; ga } ; class ; a }'}], 'result': '4', 'ind': 2, 'tostr': 'count { filter_eq { filter_eq { all_rows ; city of license ; ga } ; class ; a } }', 'tointer': 'select the rows whose city of license record fuzzily matches to ga . among these rows , select the rows whose class record fuzzily matches to a . the number of such rows is 4 .'}, '4'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_eq { filter_eq { all_rows ; city of license ; ga } ; class ; a } } ; 4 } = true', 'tointer': 'select the rows whose city of license record fuzzily matches to ga . among these rows , select the rows whose class record fuzzily matches to a . the number of such rows is 4 .'}
eq { count { filter_eq { filter_eq { all_rows ; city of license ; ga } ; class ; a } } ; 4 } = true
select the rows whose city of license record fuzzily matches to ga . among these rows , select the rows whose class record fuzzily matches to a . the number of such rows is 4 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'city of license_6': 'city of license', 'ga_7': 'ga', 'class_8': 'class', 'a_9': 'a', '4_10': '4'}
['call sign', 'frequency mhz', 'city of license', 'erp w', 'class', 'fcc info']
[['wlpe', '91.7', 'augusta , ga', '1150', 'a', 'fcc'], ['wgph', '91.5', 'vidalia , ga', '31000', 'c2', 'fcc'], ['wwgf', '107.5', 'donalsonville , ga', '6000', 'a', 'fcc'], ['wpwb', '90.5', 'byron , ga', '16500', 'c2', 'fcc'], ['wlpf', '98.5', 'ocilla , ga', '2300', 'a', 'fcc'], ['wziq', '106.5', 'smithville , ga', '2450', 'a', 'fcc'], ['wlpg', '91.7', 'florence , sc', '20000', 'c2', 'fcc'], ['wpma', '102.7', 'greensboro , ga', '7500', 'c3', 'fcc'], ['wthp', '94.3', 'gibson , ga', '6300', 'c3', 'fcc'], ['wlpt', '88.3', 'jesup , ga', '20000', 'c1', 'fcc'], ['wsja', '91.3', 'york , al', '5000', 'a', 'fcc'], ['wlgp', '100.3', 'jacksonville , nc', '100000', 'c1', 'fcc']]