german submarine u - 402
nine of the german submarines u-402 that were sunk during a raid were from great britain .
{'scope': 'subset', 'criterion': 'equal', 'value': 'great britain', 'result': '9', 'col': '3', 'subset': {'col': '5', 'criterion': 'equal', 'value': 'sunk'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'fate', 'sunk'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; fate ; sunk }', 'tointer': 'select the rows whose fate record fuzzily matches to sunk .'}, 'nationality', 'great britain'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose fate record fuzzily matches to sunk . among these rows , select the rows whose nationality record fuzzily matches to great britain .', 'tostr': 'filter_eq { filter_eq { all_rows ; fate ; sunk } ; nationality ; great britain }'}], 'result': '9', 'ind': 2, 'tostr': 'count { filter_eq { filter_eq { all_rows ; fate ; sunk } ; nationality ; great britain } }', 'tointer': 'select the rows whose fate record fuzzily matches to sunk . among these rows , select the rows whose nationality record fuzzily matches to great britain . the number of such rows is 9 .'}, '9'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_eq { filter_eq { all_rows ; fate ; sunk } ; nationality ; great britain } } ; 9 } = true', 'tointer': 'select the rows whose fate record fuzzily matches to sunk . among these rows , select the rows whose nationality record fuzzily matches to great britain . the number of such rows is 9 .'}
eq { count { filter_eq { filter_eq { all_rows ; fate ; sunk } ; nationality ; great britain } } ; 9 } = true
select the rows whose fate record fuzzily matches to sunk . among these rows , select the rows whose nationality record fuzzily matches to great britain . the number of such rows is 9 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'fate_6': 'fate', 'sunk_7': 'sunk', 'nationality_8': 'nationality', 'great britain_9': 'great britain', '9_10': '9'}
['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']]