{"action":"created","issue":{"url":"https://api.github.com/repos/graymalkin/github_data/issues/1","labels_url":"https://api.github.com/repos/graymalkin/github_data/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/graymalkin/github_data/issues/1/comments","events_url":"https://api.github.com/repos/graymalkin/github_data/issues/1/events","html_url":"https://github.com/graymalkin/github_data/issues/1","id":68901945,"number":1,"title":"Counting push events, not commits and only for own repos","user":{"login":"graymalkin","id":3636294,"avatar_url":"https://avatars.githubusercontent.com/u/3636294?v=3","gravatar_id":"","url":"https://api.github.com/users/graymalkin","html_url":"https://github.com/graymalkin","followers_url":"https://api.github.com/users/graymalkin/followers","following_url":"https://api.github.com/users/graymalkin/following{/other_user}","gists_url":"https://api.github.com/users/graymalkin/gists{/gist_id}","starred_url":"https://api.github.com/users/graymalkin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/graymalkin/subscriptions","organizations_url":"https://api.github.com/users/graymalkin/orgs","repos_url":"https://api.github.com/users/graymalkin/repos","events_url":"https://api.github.com/users/graymalkin/events{/privacy}","received_events_url":"https://api.github.com/users/graymalkin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/graymalkin/github_data/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/graymalkin/github_data/labels/help%20wanted","name":"help wanted","color":"159818"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-04-16T11:16:19Z","updated_at":"2015-04-16T12:20:10Z","closed_at":null,"body":"The query to count commits author'd is wrong - it is only counting `PushEvent` events.\r\n\r\nNot 100% sure how to fix this. The GitHub archive data does provide access to the number of commits in a `PushEvent`, but querying that and counting it against the parent repository language correctly could prove tricky.\r\n"},"comment":{"url":"https://api.github.com/repos/graymalkin/github_data/issues/comments/93720297","html_url":"https://github.com/graymalkin/github_data/issues/1#issuecomment-93720297","issue_url":"https://api.github.com/repos/graymalkin/github_data/issues/1","id":93720297,"user":{"login":"Tatskaari","id":2906700,"avatar_url":"https://avatars.githubusercontent.com/u/2906700?v=3","gravatar_id":"","url":"https://api.github.com/users/Tatskaari","html_url":"https://github.com/Tatskaari","followers_url":"https://api.github.com/users/Tatskaari/followers","following_url":"https://api.github.com/users/Tatskaari/following{/other_user}","gists_url":"https://api.github.com/users/Tatskaari/gists{/gist_id}","starred_url":"https://api.github.com/users/Tatskaari/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Tatskaari/subscriptions","organizations_url":"https://api.github.com/users/Tatskaari/orgs","repos_url":"https://api.github.com/users/Tatskaari/repos","events_url":"https://api.github.com/users/Tatskaari/events{/privacy}","received_events_url":"https://api.github.com/users/Tatskaari/received_events","type":"User","site_admin":false},"created_at":"2015-04-16T12:20:10Z","updated_at":"2015-04-16T12:20:10Z","body":"You can create an inline view like: \r\n```SQL\r\nWITH push_events AS (\r\n    SELECT timeline.id\r\n    FROM [githubarchive:github.timeline] timeline\r\n    WHERE timeline.type=\"PushEvent\"\r\n    AND timeline.repository_owner=\"USER_NAME\"\r\n)\r\n-- Then use the id list in push_events to get the commits inside the push. How you would do this depends on the data structure.\r\nSELECT *\r\nFROM push_events\r\n```\r\nand then you could select the required information out of the push events table based off push_events.id."}}