list of widows and widowers
norris church mailer and norman mailer were the only widow and widowers with 1 son .
{'scope': 'all', 'row': '5', 'col': '6', 'col_other': '1,2', 'criterion': 'equal', 'value': '1 son', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'children together', '1 son'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose children together record fuzzily matches to 1 son .', 'tostr': 'filter_eq { all_rows ; children together ; 1 son }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; children together ; 1 son } }', 'tointer': 'select the rows whose children together record fuzzily matches to 1 son . there is only one such row in the table .'}, {'func': 'and', 'args': [{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'children together', '1 son'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose children together record fuzzily matches to 1 son .', 'tostr': 'filter_eq { all_rows ; children together ; 1 son }'}, 'name'], 'result': 'norris church mailer', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; children together ; 1 son } ; name }'}, 'norris church mailer'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; children together ; 1 son } ; name } ; norris church mailer }', 'tointer': 'the name record of this unqiue row is norris church mailer .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'children together', '1 son'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose children together record fuzzily matches to 1 son .', 'tostr': 'filter_eq { all_rows ; children together ; 1 son }'}, 'deceased spouse'], 'result': 'norman mailer', 'ind': 4, 'tostr': 'hop { filter_eq { all_rows ; children together ; 1 son } ; deceased spouse }'}, 'norman mailer'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { filter_eq { all_rows ; children together ; 1 son } ; deceased spouse } ; norman mailer }', 'tointer': 'the deceased spouse record of this unqiue row is norman mailer .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { hop { filter_eq { all_rows ; children together ; 1 son } ; name } ; norris church mailer } ; eq { hop { filter_eq { all_rows ; children together ; 1 son } ; deceased spouse } ; norman mailer } }', 'tointer': 'the name record of this unqiue row is norris church mailer . the deceased spouse record of this unqiue row is norman mailer .'}], 'result': True, 'ind': 7, 'tostr': 'and { only { filter_eq { all_rows ; children together ; 1 son } } ; and { eq { hop { filter_eq { all_rows ; children together ; 1 son } ; name } ; norris church mailer } ; eq { hop { filter_eq { all_rows ; children together ; 1 son } ; deceased spouse } ; norman mailer } } } = true', 'tointer': 'select the rows whose children together record fuzzily matches to 1 son . there is only one such row in the table . the name record of this unqiue row is norris church mailer . the deceased spouse record of this unqiue row is norman mailer .'}
and { only { filter_eq { all_rows ; children together ; 1 son } } ; and { eq { hop { filter_eq { all_rows ; children together ; 1 son } ; name } ; norris church mailer } ; eq { hop { filter_eq { all_rows ; children together ; 1 son } ; deceased spouse } ; norman mailer } } } = true
select the rows whose children together record fuzzily matches to 1 son . there is only one such row in the table . the name record of this unqiue row is norris church mailer . the deceased spouse record of this unqiue row is norman mailer .
{'and_7': 'and', 'result_8': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_9': 'all_rows', 'children together_10': 'children together', '1 son_11': '1 son', 'and_6': 'and', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'name_12': 'name', 'norris church mailer_13': 'norris church mailer', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'deceased spouse_14': 'deceased spouse', 'norman mailer_15': 'norman mailer'}
['name', 'deceased spouse', 'cause of death', 'date of spouses death', 'length of marriage', 'children together', 'current marital status']
[['samuel beckett', 'suzanne dãchevaux - dumesnil', 'unknown', 'july 17 , 1989 ( aged89 )', '28 years', 'none', 'deceased ( 1989 )'], ['jan berenstain', 'stan berenstain', 'unknown', 'november 26 , 2005 ( aged82 )', '59 years', '2 sons ( leo , michael )', 'deceased ( 2012 )'], ['ray bradbury', 'marguerite mcclure', 'not known', 'november 24 , 2003 ( aged81 )', '56 years', '4 daughters ( susan , ramona , bettina , alexandra )', 'deceased ( 2012 )'], ['mary welsh hemingway', 'ernest hemingway', 'suicide', 'july 2 , 1961 ( aged61 )', '15 years', 'none ( miscarriage )', 'deceased ( 1986 )'], ['norris church mailer', 'norman mailer', 'acute renal failure', 'november 10 , 2007 ( aged84 )', '27 years', '1 son ( john )', 'deceased ( 2010 )'], ['frederica sagor maas', 'ernest maas', 'natural causes', 'july 21 , 1986 ( aged94 )', '59 years', 'none', 'deceased ( 2012 )'], ['edgar allan poe', 'virginia eliza clemm poe', 'tuberculosis', 'january 30 , 1847 ( aged24 )', '11 years', 'none', 'deceased ( 1849 )'], ['dr seuss', 'helen palmer geisel', 'overdose of barbiturates', 'october 23 , 1967 ( aged68 )', '40 years', 'none', 'deceased ( 1991 )'], ['robert treuhaft', 'jessica mitford', 'lung cancer', 'july 22 , 1996 ( aged78 )', '53 years', '2 sons ( nicholas , benjamin )', 'deceased ( 2001 )']]