primera división de fútbol profesional apertura 2008
mauricio cienfuegos had the earliest date of vacancy in the primera division de futbol .
{'scope': 'all', 'col_superlative': '4', 'row_superlative': '1', 'value_mentioned': 'no', 'max_or_min': 'min', 'other_col': '2', 'subset': None}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'argmin', 'args': ['all_rows', 'date of vacancy'], 'result': None, 'ind': 0, 'tostr': 'argmin { all_rows ; date of vacancy }'}, 'outgoing manager'], 'result': 'mauricio cienfuegos', 'ind': 1, 'tostr': 'hop { argmin { all_rows ; date of vacancy } ; outgoing manager }'}, 'mauricio cienfuegos'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { argmin { all_rows ; date of vacancy } ; outgoing manager } ; mauricio cienfuegos } = true', 'tointer': 'select the row whose date of vacancy record of all rows is minimum . the outgoing manager record of this row is mauricio cienfuegos .'}
eq { hop { argmin { all_rows ; date of vacancy } ; outgoing manager } ; mauricio cienfuegos } = true
select the row whose date of vacancy record of all rows is minimum . the outgoing manager record of this row is mauricio cienfuegos .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'argmin_0': 'argmin', 'all_rows_4': 'all_rows', 'date of vacancy_5': 'date of vacancy', 'outgoing manager_6': 'outgoing manager', 'mauricio cienfuegos_7': 'mauricio cienfuegos'}
['team', 'outgoing manager', 'manner of departure', 'date of vacancy', 'replaced by', 'date of appointment', 'position in table']
[['nejapa', 'mauricio cienfuegos', 'mutual consent', '14 august 2008', 'daniel uberti', '5 september 2008', '10th'], ['firpo', 'gerardo reinoso', 'sacked', '25 august 2008', 'oscar benitez', '2 september 2008', '7th'], ['balboa', 'gustavo de simone', 'sacked', '30 august 2008', 'roberto gamarra', '5 september 2008', '10th'], ['alianza', 'pablo centrone', 'sacked', '14 september 2008', 'carlos jurado', '16 september 2008', '5th'], ['firpo', 'oscar benítez', 'sacked', '9 december 2008', 'agustín castillo', '23 december 2008', 'post - season ( 6th )'], ['águila', 'agustín castillo', 'sacked', '15 december 2008', 'pablo centrone', '24 december 2008', 'post - season ( semifinals )'], ['fas', 'nelson ancheta', 'sacked', '27 december 2008', 'roberto gamarra', '1 january 2009', 'post - season ( semifinals )'], ['nejapa', 'daniel uberti', 'sacked', '29 december 2008', 'nelson ancheta', '29 december 2008', 'post - season ( 10th )'], ['balboa', 'roberto gamarra', 'mutual consent', '1 january 2009', 'carlos de toro', '16 january 2009', 'post - season ( 7th )'], ['independiente', 'jorge abrego', 'sacked', 'december 2008', 'ramón sánchez', 'december 2009', 'post - season ( 8th )']]