turkish airlines
the turkish airlines flight crash on 2 february 1969 was the only one with 0 fatalities .
{'scope': 'all', 'row': '5', 'col': '6', 'col_other': '1', 'criterion': 'equal', 'value': '0', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'fatalities', '0'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose fatalities record is equal to 0 .', 'tostr': 'filter_eq { all_rows ; fatalities ; 0 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; fatalities ; 0 } }', 'tointer': 'select the rows whose fatalities record is equal to 0 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'fatalities', '0'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose fatalities record is equal to 0 .', 'tostr': 'filter_eq { all_rows ; fatalities ; 0 }'}, 'date'], 'result': '2 february 1969', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; fatalities ; 0 } ; date }'}, '2 february 1969'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; fatalities ; 0 } ; date } ; 2 february 1969 }', 'tointer': 'the date record of this unqiue row is 2 february 1969 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; fatalities ; 0 } } ; eq { hop { filter_eq { all_rows ; fatalities ; 0 } ; date } ; 2 february 1969 } } = true', 'tointer': 'select the rows whose fatalities record is equal to 0 . there is only one such row in the table . the date record of this unqiue row is 2 february 1969 .'}
and { only { filter_eq { all_rows ; fatalities ; 0 } } ; eq { hop { filter_eq { all_rows ; fatalities ; 0 } ; date } ; 2 february 1969 } } = true
select the rows whose fatalities record is equal to 0 . there is only one such row in the table . the date record of this unqiue row is 2 february 1969 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_eq_0': 'filter_eq', 'all_rows_6': 'all_rows', 'fatalities_7': 'fatalities', '0_8': '0', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'date_9': 'date', '2 february 1969_10': '2 february 1969'}
['date', 'flight', 'aircraft', 'registration', 'location', 'fatalities']
[['17 february 1959', 'n / a', 'vickers viscount type 793', 'tc - sev', 'london', '14'], ['23 september 1961', '100', 'fokker f27 - 100', 'tc - tay', 'ankara', '28'], ['8 march 1962', 'n / a', 'fairchild f - 27', 'tc - kop', 'adana', '11'], ['3 february 1964', 'n / a', 'douglas c - 47', 'tc - eti', 'ankara', '3'], ['2 february 1969', 'n / a', 'vickers viscount type 794', 'tc - set', 'ankara', '0'], ['26 january 1974', 'n / a', 'fokker f28 - 1000', 'tc - jao', 'izmir', '66'], ['3 march 1974', '981', 'mcdonnell douglas dc - 10', 'tc - jav', 'fontaine - chaalis , oise', '346'], ['30 january 1975', '345', 'fokker f28 - 1000', 'tc - jap', 'istanbul', '42'], ['19 september 1976', '452', 'boeing 727', 'tc - jbh', 'isparta', '154'], ['23 december 1979', 'n / a', 'fokker f28 - 1000', 'tc - jat', 'ankara', '41'], ['16 january 1983', '158', 'boeing 727', 'tc - jbr', 'ankara', '47'], ['29 december 1994', '278', 'boeing 737', 'tc - jes', 'van', '57'], ['7 april 1999', '5904', 'boeing 737', 'tc - jep', 'ceyhan', '6'], ['8 january 2003', '634', 'avro rj - 100', 'tc - thg', 'diyarbakä ± r', '75'], ['25 february 2009', '1951', 'boeing 737', 'tc - jge', 'amsterdam', '9']]