pborreli · August 29, 2015 13:59 · pborreli · Apr 12, 2014
diff --git a/bigquery b/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; 
diff --git a/result.csv b/result.csv
	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;