1997 tennessee oilers season
in october 1997 , total attendance at tennessee oilers games was 142,040 .
{'scope': 'subset', 'col': '7', 'type': 'sum', 'result': '142040', 'subset': {'col': '2', 'criterion': 'fuzzily_match', 'value': 'october'}}
{'func': 'round_eq', 'args': [{'func': 'sum', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'date', 'october'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; date ; october }', 'tointer': 'select the rows whose date record fuzzily matches to october .'}, 'attendance'], 'result': '142040', 'ind': 1, 'tostr': 'sum { filter_eq { all_rows ; date ; october } ; attendance }'}, '142040'], 'result': True, 'ind': 2, 'tostr': 'round_eq { sum { filter_eq { all_rows ; date ; october } ; attendance } ; 142040 } = true', 'tointer': 'select the rows whose date record fuzzily matches to october . the sum of the attendance record of these rows is 142040 .'}
round_eq { sum { filter_eq { all_rows ; date ; october } ; attendance } ; 142040 } = true
select the rows whose date record fuzzily matches to october . the sum of the attendance record of these rows is 142040 .
{'eq_2': 'eq', 'result_3': 'true', 'sum_1': 'sum', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'date_5': 'date', 'october_6': 'october', 'attendance_7': 'attendance', '142040_8': '142040'}
['week', 'date', 'opponent', 'result', 'record', 'location', 'attendance']
[['1', 'august 31 , 1997', 'oakland raiders', 'w 24 - 21', '1 - 0', 'liberty bowl memorial stadium', '30171'], ['2', 'september 7 , 1997', 'miami dolphins', 'l 16 - 13', '1 - 1', 'pro player stadium', '64439'], ['3', '-', '-', '-', '-', '-', ''], ['4', 'september 21 , 1997', 'baltimore ravens', 'l 36 - 10', '1 - 2', 'liberty bowl memorial stadium', '17737'], ['5', 'september 28 , 1997', 'pittsburgh steelers', 'l 37 - 24', '1 - 3', 'three rivers stadium', '57507'], ['6', 'october 5 , 1997', 'seattle seahawks', 'l 16 - 13', '1 - 4', 'kingdome', '49897'], ['7', 'october 12 , 1997', 'cincinnati bengals', 'w 30 - 7', '2 - 4', 'liberty bowl memorial stadium', '17071'], ['8', 'october 19 , 1997', 'washington redskins', 'w 28 - 14', '3 - 4', 'liberty bowl memorial stadium', '31042'], ['9', 'october 26 , 1997', 'arizona cardinals', 'w 41 - 14', '4 - 4', 'sun devil stadium', '44030'], ['10', 'november 2 , 1997', 'jacksonville jaguars', 'l 30 - 24', '4 - 5', 'liberty bowl memorial stadium', '27208'], ['11', 'november 9 , 1997', 'new york giants', 'w 10 - 6', '5 - 5', 'liberty bowl memorial stadium', '26744'], ['12', 'november 16 , 1997', 'jacksonville jaguars', 'l 17 - 9', '5 - 6', 'alltel stadium', '70070'], ['13', 'november 23 , 1997', 'buffalo bills', 'w 31 - 14', '6 - 6', 'liberty bowl memorial stadium', '23571'], ['14', 'november 27 , 1997', 'dallas cowboys', 'w 27 - 14', '7 - 6', 'texas stadium', '63421'], ['15', 'december 4 , 1997', 'cincinnati bengals', 'l 41 - 14', '7 - 7', 'cinergy field', '49086'], ['16', 'december 14 , 1997', 'baltimore ravens', 'l 21 - 19', '7 - 8', 'memorial stadium', '60558'], ['17', 'december 21 , 1997', 'pittsburgh steelers', 'w 16 - 6', '8 - 8', 'liberty bowl memorial stadium', '50677']]