german submarine u - 402
in german submarine u - 402 , llangibby castle is the earliest among the damaged ships .
{'scope': 'subset', 'row': '1', 'col': '1', 'order': '1', 'col_other': '2', 'max_or_min': 'min_to_max', 'value_mentioned': 'no', 'subset': {'col': '5', 'criterion': 'equal', 'value': 'damaged'}}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmin', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'fate', 'damaged'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; fate ; damaged }', 'tointer': 'select the rows whose fate record fuzzily matches to damaged .'}, 'date', '1'], 'result': None, 'ind': 1, 'tostr': 'nth_argmin { filter_eq { all_rows ; fate ; damaged } ; date ; 1 }'}, 'ship'], 'result': 'llangibby castle', 'ind': 2, 'tostr': 'hop { nth_argmin { filter_eq { all_rows ; fate ; damaged } ; date ; 1 } ; ship }'}, 'llangibby castle'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { nth_argmin { filter_eq { all_rows ; fate ; damaged } ; date ; 1 } ; ship } ; llangibby castle } = true', 'tointer': 'select the rows whose fate record fuzzily matches to damaged . select the row whose date record of these rows is 1st minimum . the ship record of this row is llangibby castle .'}
eq { hop { nth_argmin { filter_eq { all_rows ; fate ; damaged } ; date ; 1 } ; ship } ; llangibby castle } = true
select the rows whose fate record fuzzily matches to damaged . select the row whose date record of these rows is 1st minimum . the ship record of this row is llangibby castle .
{'str_eq_3': 'str_eq', 'result_4': 'true', 'str_hop_2': 'str_hop', 'nth_argmin_1': 'nth_argmin', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'fate_6': 'fate', 'damaged_7': 'damaged', 'date_8': 'date', '1_9': '1', 'ship_10': 'ship', 'llangibby castle_11': 'llangibby castle'}
['date', 'ship', 'nationality', 'tonnage', 'fate']
[['16 may 1941', 'llangibby castle', 'great britain', '11951', 'damaged'], ['13 april 1942', 'empire progress', 'great britain', '5249', 'sunk'], ['30 april 1942', 'ashkhabad', 'soviet union', '5284', 'sunk'], ['2 may 1942', 'uss cythera', 'usa', '602', 'sunk'], ['2 november 1942', 'dalcroy', 'great britain', '4558', 'sunk'], ['2 november 1942', 'empire antelope', 'great britain', '4945', 'sunk'], ['2 november 1942', 'empire leopard', 'great britain', '5676', 'sunk'], ['2 november 1942', 'empire sunrise', 'great britain', '7459', 'damaged'], ['2 november 1942', 'rinos', 'greece', '4649', 'sunk'], ['7 february 1942', 'afrika', 'great britain', '8597', 'sunk'], ['7 february 1942', 'daghild', 'norway', '9272', 'damaged'], ['7 february 1942', 'henry r mallory', 'usa', '6063', 'sunk'], ['7 february 1942', 'kalliopi', 'greece', '4695', 'sunk'], ['7 february 1942', 'robert e hopkins', 'great britain', '6625', 'sunk'], ['7 february 1942', 'toward', 'great britain', '1571', 'sunk'], ['8 february 1942', 'newton ash', 'great britain', '1571', 'sunk'], ['11 may 1943', 'antigone', 'great britain', '4545', 'sunk'], ['11 may 1943', 'grado', 'norway', '3082', 'sunk']]