1972 san francisco 49ers season
in the 1972 san francisco 49ers season , when the 49ers won , the only time the opponent was the san diego chargers was on september 17 .
{'scope': 'subset', 'row': '1', 'col': '3', 'col_other': '2,4', 'criterion': 'equal', 'value': 'san diego chargers', 'subset': {'col': '4', 'criterion': 'fuzzily_match', 'value': 'w'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'result', 'w'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; result ; w }', 'tointer': 'select the rows whose result record fuzzily matches to w .'}, 'opponent', 'san diego chargers'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose result record fuzzily matches to w . among these rows , select the rows whose opponent record fuzzily matches to san diego chargers .', 'tostr': 'filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers } }', 'tointer': 'select the rows whose result record fuzzily matches to w . among these rows , select the rows whose opponent record fuzzily matches to san diego chargers . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'result', 'w'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; result ; w }', 'tointer': 'select the rows whose result record fuzzily matches to w .'}, 'opponent', 'san diego chargers'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose result record fuzzily matches to w . among these rows , select the rows whose opponent record fuzzily matches to san diego chargers .', 'tostr': 'filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers }'}, 'date'], 'result': 'september 17 , 1972', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers } ; date }'}, 'september 17 , 1972'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers } ; date } ; september 17 , 1972 }', 'tointer': 'the date record of this unqiue row is september 17 , 1972 .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers } } ; eq { hop { filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers } ; date } ; september 17 , 1972 } } = true', 'tointer': 'select the rows whose result record fuzzily matches to w . among these rows , select the rows whose opponent record fuzzily matches to san diego chargers . there is only one such row in the table . the date record of this unqiue row is september 17 , 1972 .'}
and { only { filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers } } ; eq { hop { filter_eq { filter_eq { all_rows ; result ; w } ; opponent ; san diego chargers } ; date } ; september 17 , 1972 } } = true
select the rows whose result record fuzzily matches to w . among these rows , select the rows whose opponent record fuzzily matches to san diego chargers . there is only one such row in the table . the date record of this unqiue row is september 17 , 1972 .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'result_8': 'result', 'w_9': 'w', 'opponent_10': 'opponent', 'san diego chargers_11': 'san diego chargers', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'date_12': 'date', 'september 17 , 1972_13': 'september 17 , 1972'}
['week', 'date', 'opponent', 'result', 'attendance']
[['1', 'september 17 , 1972', 'san diego chargers', 'w 34 - 3', '59438'], ['2', 'september 24 , 1972', 'buffalo bills', 'l 27 - 20', '45845'], ['3', 'october 1 , 1972', 'new orleans saints', 'w 37 - 2', '69840'], ['4', 'october 8 , 1972', 'los angeles rams', 'l 31 - 7', '77382'], ['5', 'october 15 , 1972', 'new york giants', 'l 23 - 17', '58606'], ['6', 'october 22 , 1972', 'new orleans saints', 't 20 - 20', '59167'], ['7', 'october 29 , 1972', 'atlanta falcons', 'w 49 - 14', '58850'], ['8', 'november 5 , 1972', 'green bay packers', 'l 34 - 24', '47897'], ['9', 'november 12 , 1972', 'baltimore colts', 'w 24 - 21', '61214'], ['10', 'november 19 , 1972', 'chicago bears', 'w 34 - 21', '55701'], ['11', 'november 23 , 1972', 'dallas cowboys', 'w 31 - 10', '65124'], ['12', 'december 4 , 1972', 'los angeles rams', 'l 26 - 16', '61214'], ['13', 'december 10 , 1972', 'atlanta falcons', 'w 20 - 0', '61214'], ['14', 'december 16 , 1972', 'minnesota vikings', 'w 20 - 17', '61214']]