ethnic groups in london
newham is the only london borough with a total asian population over 130000 .
{'scope': 'all', 'row': '1', 'col': '8', 'col_other': '2', 'criterion': 'greater_than', 'value': '130000', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'total asian population', '130000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose total asian population record is greater than 130000 .', 'tostr': 'filter_greater { all_rows ; total asian population ; 130000 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; total asian population ; 130000 } }', 'tointer': 'select the rows whose total asian population record is greater than 130000 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'total asian population', '130000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose total asian population record is greater than 130000 .', 'tostr': 'filter_greater { all_rows ; total asian population ; 130000 }'}, 'london borough'], 'result': 'newham', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; total asian population ; 130000 } ; london borough }'}, 'newham'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; total asian population ; 130000 } ; london borough } ; newham }', 'tointer': 'the london borough record of this unqiue row is newham .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; total asian population ; 130000 } } ; eq { hop { filter_greater { all_rows ; total asian population ; 130000 } ; london borough } ; newham } } = true', 'tointer': 'select the rows whose total asian population record is greater than 130000 . there is only one such row in the table . the london borough record of this unqiue row is newham .'}
and { only { filter_greater { all_rows ; total asian population ; 130000 } } ; eq { hop { filter_greater { all_rows ; total asian population ; 130000 } ; london borough } ; newham } } = true
select the rows whose total asian population record is greater than 130000 . there is only one such row in the table . the london borough record of this unqiue row is newham .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_greater_0': 'filter_greater', 'all_rows_6': 'all_rows', 'total asian population_7': 'total asian population', '130000_8': '130000', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'london borough_9': 'london borough', 'newham_10': 'newham'}
['rank', 'london borough', 'indian population', 'pakistani population', 'bangladeshi population', 'chinese population', 'other asian population', 'total asian population']
[['1', 'newham', '42484', '30307', '37262', '3930', '19912', '133895'], ['2', 'redbridge', '45660', '31051', '16011', '3000', '20781', '116503'], ['3', 'brent', '58017', '14381', '1749', '3250', '28589', '105986'], ['4', 'tower hamlets', '6787', '2442', '81377', '8109', '5786', '104501'], ['5', 'harrow', '63051', '7797', '1378', '2629', '26953', '101808'], ['6', 'ealing', '48240', '14711', '1786', '4132', '31570', '100439'], ['7', 'hounslow', '48161', '13676', '2189', '2405', '20826', '87257'], ['8', 'hillingdon', '36795', '9200', '2639', '2889', '17730', '69253'], ['9', 'haringey', '36795', '9200', '2639', '2889', '17730', '69253'], ['10', 'barnet', '27920', '5344', '2215', '8259', '22180', '65918'], ['11', 'croydon', '24660', '10865', '2570', '3925', '17607', '59627'], ['12', 'waltham forest', '9134', '26347', '4632', '2579', '11697', '54389'], ['13', 'merton', '8106', '7337', '2216', '2618', '15866', '36143'], ['14', 'camden', '6083', '1489', '12503', '6493', '8878', '35446'], ['15', 'enfield', '11648', '2594', '5599', '2588', '12464', '34893'], ['16', 'wandsworth', '8642', '9718', '1493', '3715', '9770', '33338'], ['17', 'westminster', '7213', '2328', '6299', '5917', '10105', '31862'], ['18', 'greenwich', '7836', '2594', '1645', '5061', '12758', '29894'], ['19', 'barking and dagenham', '7436', '8007', '7701', '1315', '5135', '29594']]