lessons to be learned
the only location where the album was released in 2009 was the united states .
{'scope': 'all', 'row': '8', 'col': '1', 'col_other': '2', 'criterion': 'equal', 'value': 'united states', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'region', 'united states'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose region record fuzzily matches to united states .', 'tostr': 'filter_eq { all_rows ; region ; united states }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; region ; united states } }', 'tointer': 'select the rows whose region record fuzzily matches to united states . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'region', 'united states'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose region record fuzzily matches to united states .', 'tostr': 'filter_eq { all_rows ; region ; united states }'}, 'date'], 'result': '17 march 2009', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; region ; united states } ; date }'}, '17 march 2009'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; region ; united states } ; date } ; 17 march 2009 }', 'tointer': 'the date record of this unqiue row is 17 march 2009 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; region ; united states } } ; eq { hop { filter_eq { all_rows ; region ; united states } ; date } ; 17 march 2009 } } = true', 'tointer': 'select the rows whose region record fuzzily matches to united states . there is only one such row in the table . the date record of this unqiue row is 17 march 2009 .'}
and { only { filter_eq { all_rows ; region ; united states } } ; eq { hop { filter_eq { all_rows ; region ; united states } ; date } ; 17 march 2009 } } = true
select the rows whose region record fuzzily matches to united states . there is only one such row in the table . the date record of this unqiue row is 17 march 2009 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'region_7': 'region', 'united states_8': 'united states', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'date_9': 'date', '17 march 2009_10': '17 march 2009'}
['region', 'date', 'label', 'format', 'catalogue']
[['united kingdom', '31 march 2008', 'island', 'cd , digital download', '1763307'], ['australia', '10 may 2008', 'mushroom', 'cd , digital download', '5144275002'], ['new zealand', '12 may 2008', 'warner bros', 'cd , digital download', '5144275002'], ['europe', '20 june 2008', 'island', 'cd , digital download', '060251773945'], ['brazil', '10 september 2008', 'universal', 'cd', '602517739468'], ['australia ( deluxe edition )', '11 october 2008', 'mushroom', 'cd', '5186504315'], ['poland', '28 october 2008', 'universal', 'cd', '1785089'], ['united states', '17 march 2009', 'universal republic', 'cd', 'b0012720 - 02']]