list of vehicle speed records
the schempp-hirth nimbus-4dm was the only vehicle that was manned by two people when achieving its speed record .
{'scope': 'all', 'row': '6', 'col': '5', 'col_other': '4', 'criterion': 'equal', 'value': 'and', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'pilot', 'and'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose pilot record fuzzily matches to and .', 'tostr': 'filter_eq { all_rows ; pilot ; and }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; pilot ; and } }', 'tointer': 'select the rows whose pilot record fuzzily matches to and . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'pilot', 'and'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose pilot record fuzzily matches to and .', 'tostr': 'filter_eq { all_rows ; pilot ; and }'}, 'vehicle'], 'result': 'schempp - hirth nimbus - 4dm', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; pilot ; and } ; vehicle }'}, 'schempp - hirth nimbus - 4dm'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; pilot ; and } ; vehicle } ; schempp - hirth nimbus - 4dm }', 'tointer': 'the vehicle record of this unqiue row is schempp - hirth nimbus - 4dm .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; pilot ; and } } ; eq { hop { filter_eq { all_rows ; pilot ; and } ; vehicle } ; schempp - hirth nimbus - 4dm } } = true', 'tointer': 'select the rows whose pilot record fuzzily matches to and . there is only one such row in the table . the vehicle record of this unqiue row is schempp - hirth nimbus - 4dm .'}
and { only { filter_eq { all_rows ; pilot ; and } } ; eq { hop { filter_eq { all_rows ; pilot ; and } ; vehicle } ; schempp - hirth nimbus - 4dm } } = true
select the rows whose pilot record fuzzily matches to and . there is only one such row in the table . the vehicle record of this unqiue row is schempp - hirth nimbus - 4dm .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'pilot_7': 'pilot', 'and_8': 'and', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'vehicle_9': 'vehicle', 'schempp - hirth nimbus - 4dm_10': 'schempp - hirth nimbus - 4dm'}
['category', 'speed ( km / h )', 'speed ( mph )', 'vehicle', 'pilot', 'date']
[['rocket - powered aircraft', '7258', '4510', 'north american x - 15', 'william j knight', '3 oct 1967'], ['manned air - breathing craft', '3530', '2194', 'lockheed sr - 71 blackbird', 'eldon w joersz', '28 jul 1976'], ['propeller - driven aircraft', '870', '541', 'tupolev tu - 114', 'ivan soukhomline', '00 jan 1960'], ['piston - engined propeller - driven aircraft', '850.1', '528.33', 'grumman f8f bearcat rare bear ( n777l )', 'lyle shelton', '21 aug 1989'], ['helicopter', '401.0', '249.1', 'westland lynx 800 g - lynx', 'john egginton', '11 aug 1986'], ['glider ( sailplane )', '306.8', '190.6', 'schempp - hirth nimbus - 4dm', 'klaus ohlmann and matias garcia mazzaro', '22 dec 2006'], ['human - powered aircraft', '32', '19.8', 'mit monarch b', 'frank scarabino', '1 may 1984']]