pborreli/bigquery

## bigquery
SELECT
  COUNT(payload_pull_request_number) as counter, payload_pull_request_merged as merged
FROM [githubarchive:github.timeline]
WHERE type="PullRequestEvent"
  AND actor = 'parkr'
  AND payload_action = 'closed'
  AND repository_name = 'jekyll'
  AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2014-04-01 00:00:00')
GROUP BY merged;

## result.csv

          
            counter
            merged

            
              5
              false

            
              16
              true
	SELECT
	COUNT(payload_pull_request_number) as counter, payload_pull_request_merged as merged
	FROM [githubarchive:github.timeline]
	WHERE type="PullRequestEvent"
	AND actor = 'parkr'
	AND payload_action = 'closed'
	AND repository_name = 'jekyll'
	AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2014-04-01 00:00:00')
	GROUP BY merged;