2007 - 08 carolina hurricanes season
in the 2007 - 08 carolina hurricanes season , among the games where carolina was a visitor , 3 of them had attendance over 19,000 .
{'scope': 'subset', 'criterion': 'greater_than', 'value': '19000', 'result': '3', 'col': '6', 'subset': {'col': '2', 'criterion': 'equal', 'value': 'carolina'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'visitor', 'carolina'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; visitor ; carolina }', 'tointer': 'select the rows whose visitor record fuzzily matches to carolina .'}, 'attendance', '19000'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose visitor record fuzzily matches to carolina . among these rows , select the rows whose attendance record is greater than 19000 .', 'tostr': 'filter_greater { filter_eq { all_rows ; visitor ; carolina } ; attendance ; 19000 }'}], 'result': '3', 'ind': 2, 'tostr': 'count { filter_greater { filter_eq { all_rows ; visitor ; carolina } ; attendance ; 19000 } }', 'tointer': 'select the rows whose visitor record fuzzily matches to carolina . among these rows , select the rows whose attendance record is greater than 19000 . the number of such rows is 3 .'}, '3'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_greater { filter_eq { all_rows ; visitor ; carolina } ; attendance ; 19000 } } ; 3 } = true', 'tointer': 'select the rows whose visitor record fuzzily matches to carolina . among these rows , select the rows whose attendance record is greater than 19000 . the number of such rows is 3 .'}
eq { count { filter_greater { filter_eq { all_rows ; visitor ; carolina } ; attendance ; 19000 } } ; 3 } = true
select the rows whose visitor record fuzzily matches to carolina . among these rows , select the rows whose attendance record is greater than 19000 . the number of such rows is 3 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_greater_1': 'filter_greater', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'visitor_6': 'visitor', 'carolina_7': 'carolina', 'attendance_8': 'attendance', '19000_9': '19000', '3_10': '3'}
['date', 'visitor', 'score', 'home', 'decision', 'attendance', 'record']
[['january 2', 'atlanta', '5 - 4', 'carolina', 'ward', '13506', '20 - 18 - 4'], ['january 4', 'carolina', '4 - 3', 'atlanta', 'leighton', '16097', '21 - 18 - 4'], ['january 5', 'carolina', '0 - 1', 'st louis', 'leighton', '19150', '21 - 19 - 4'], ['january 8', 'carolina', '1 - 0', 'boston', 'ward', '14549', '22 - 19 - 4'], ['january 10', 'new jersey', '4 - 1', 'carolina', 'ward', '17173', '22 - 20 - 4'], ['january 12', 'colorado', '5 - 4', 'carolina', 'ward', '18680', '22 - 21 - 4'], ['january 15', 'carolina', '4 - 5', 'toronto', 'ward', '19444', '22 - 22 - 4'], ['january 17', 'carolina', '1 - 5', 'ottawa', 'ward', '19720', '22 - 23 - 4'], ['january 18', 'edmonton', '2 - 7', 'carolina', 'ward', '16868', '23 - 23 - 4'], ['january 21', 'carolina', '3 - 2', 'ny islanders', 'ward', '16234', '24 - 23 - 4'], ['january 22', 'ny islanders', '6 - 3', 'carolina', 'ward', '15675', '24 - 24 - 4'], ['january 29', 'ny rangers', '1 - 3', 'carolina', 'ward', '17793', '25 - 24 - 4'], ['january 31', 'toronto', '2 - 3', 'carolina', 'ward', '15159', '26 - 24 - 4']]