Github Bigquery - get all merged PR's of a specific user

gistfile1.sql

SELECT created_at,
       repository_name,
       payload_pull_request_title,
       payload_pull_request_issue_url ,
       repository_description,
       repository_language,
       repository_url
FROM [githubarchive:github.timeline]
WHERE TYPE="PullRequestEvent"
  AND payload_pull_request_head_repo_owner_login="USERNAME"
  AND payload_pull_request_merged="true"
ORDER BY created_at ASC;