1995 - 96 colorado avalanche season
the game on december 1st was the only game where the ny rangers were the home team .
{'scope': 'all', 'row': '1', 'col': '4', 'col_other': '1', 'criterion': 'equal', 'value': 'ny rangers', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'home', 'ny rangers'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose home record fuzzily matches to ny rangers .', 'tostr': 'filter_eq { all_rows ; home ; ny rangers }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; home ; ny rangers } }', 'tointer': 'select the rows whose home record fuzzily matches to ny rangers . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'home', 'ny rangers'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose home record fuzzily matches to ny rangers .', 'tostr': 'filter_eq { all_rows ; home ; ny rangers }'}, 'date'], 'result': 'december 1', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; home ; ny rangers } ; date }'}, 'december 1'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; home ; ny rangers } ; date } ; december 1 }', 'tointer': 'the date record of this unqiue row is december 1 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; home ; ny rangers } } ; eq { hop { filter_eq { all_rows ; home ; ny rangers } ; date } ; december 1 } } = true', 'tointer': 'select the rows whose home record fuzzily matches to ny rangers . there is only one such row in the table . the date record of this unqiue row is december 1 .'}
and { only { filter_eq { all_rows ; home ; ny rangers } } ; eq { hop { filter_eq { all_rows ; home ; ny rangers } ; date } ; december 1 } } = true
select the rows whose home record fuzzily matches to ny rangers . there is only one such row in the table . the date record of this unqiue row is december 1 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'home_7': 'home', 'ny rangers_8': 'ny rangers', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'date_9': 'date', 'december 1_10': 'december 1'}
['date', 'visitor', 'score', 'home', 'record']
[['december 1', 'colorado', '3 - 5', 'ny rangers', '15 - 6 - 4'], ['december 3', 'dallas', '7 - 6', 'colorado', '15 - 7 - 4'], ['december 5', 'san jose', '2 - 12', 'colorado', '16 - 7 - 4'], ['december 7', 'edmonton', '5 - 3', 'colorado', '16 - 8 - 4'], ['december 9', 'colorado', '7 - 3', 'ottawa', '17 - 8 - 4'], ['december 11', 'colorado', '5 - 1', 'toronto', '18 - 8 - 4'], ['december 13', 'colorado', '3 - 4', 'buffalo', '18 - 9 - 4'], ['december 15', 'colorado', '2 - 4', 'hartford', '18 - 10 - 4'], ['december 18', 'vancouver', '4 - 2', 'colorado', '18 - 11 - 4'], ['december 20', 'colorado', '4 - 1', 'edmonton', '19 - 11 - 4'], ['december 22', 'st louis', '1 - 2', 'colorado', '20 - 11 - 4'], ['december 23', 'colorado', '2 - 2', 'los angeles', '20 - 11 - 5'], ['december 26', 'colorado', '5 - 1', 'san jose', '21 - 11 - 5'], ['december 29', 'toronto', '2 - 3', 'colorado', '22 - 11 - 5']]