list of amusement park rankings
summerland is the only one of the water parks in the amusement park rankings that is located in japan .
{'scope': 'all', 'row': '14', 'col': '3', 'col_other': '2', 'criterion': 'fuzzily_match', 'value': 'japan', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'location', 'japan'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose location record fuzzily matches to japan .', 'tostr': 'filter_eq { all_rows ; location ; japan }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; location ; japan } }', 'tointer': 'select the rows whose location record fuzzily matches to japan . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'location', 'japan'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose location record fuzzily matches to japan .', 'tostr': 'filter_eq { all_rows ; location ; japan }'}, 'water park'], 'result': 'summerland', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; location ; japan } ; water park }'}, 'summerland'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; location ; japan } ; water park } ; summerland }', 'tointer': 'the water park record of this unqiue row is summerland .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; location ; japan } } ; eq { hop { filter_eq { all_rows ; location ; japan } ; water park } ; summerland } } = true', 'tointer': 'select the rows whose location record fuzzily matches to japan . there is only one such row in the table . the water park record of this unqiue row is summerland .'}
and { only { filter_eq { all_rows ; location ; japan } } ; eq { hop { filter_eq { all_rows ; location ; japan } ; water park } ; summerland } } = true
select the rows whose location record fuzzily matches to japan . there is only one such row in the table . the water park record of this unqiue row is summerland .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'location_7': 'location', 'japan_8': 'japan', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'water park_9': 'water park', 'summerland_10': 'summerland'}
['rank', 'water park', 'location', '2011', '2012']
[['1', 'typhoon lagoon at walt disney world resort', 'lake buena vista , florida , usa', '2058000', '2100000'], ['2', 'chime - long water park', 'guangzhou , china', '1900000', '2021000'], ['3', 'blizzard beach at walt disney world resort', 'lake buena vista , florida , usa', '1891000', '1929000'], ['4', 'ocean world', 'gangwon - do , south korea', '1726000', '1720000'], ['5', 'aquatica', 'orlando , florida , usa', '1500000', '1538000'], ['6', 'caribbean bay at everland resort', 'gyeonggi - do , south korea', '1497000', '1508000'], ['7', 'aquaventure', 'dubai , united arab emirates', '1200000', '1300000'], ['8', "wet 'n wild orlando", 'orlando , florida , usa', '1223000', '1247000'], ['9', "wet 'n' wild water world", 'gold coast , queensland , australia', '1200000', '1200000'], ['10', 'sunway lagoon', 'kuala lumpur , malaysia', '1040000', '1200000'], ['11', 'resom spa castle', 'chungcheongnam - do , south korea', '1034000', '1158000'], ['12', 'schlitterbahn', 'new braunfels , texas , usa', '982000', '1017000'], ['13', 'atlantis water adventure', 'jakarta , indonesia', '950000', '1000000'], ['14', 'summerland', 'tokyo , japan', '850000', '990000'], ['15', 'happy magic water cube', 'beijing , china', '768000', '968000'], ['16', 'the jungle water adventure', 'bogor , indonesia', '871000', '951000'], ['17', 'wild wadi water park', 'dubai , united arab emirates', '890000', '860000'], ['18', 'siam water park', 'tenerife , spain', '800000', '800000'], ['19', 'ocean park water adventure', 'jakarta , indonesia', '600000', '750000'], ['20', 'water country usa', 'williamsburg , virginia , usa', '723000', '748000']]