Skip to content
Wes Turner edited this page Apr 23, 2017 · 7 revisions

GitHub Quicklinks

GitHub Features

Repositories

Activity

Pull Requests

Issues

Archive

My Activity

sql
SELECT actor, repository_url, created_at, payload_action, url, type
FROM [githubarchive:github.timeline]
WHERE
actor=="westurner"
LIMIT 1000

My Activity > -WatchEvent

SELECT actor, repository_url, created_at, payload_action, url, type
FROM [githubarchive:github.timeline]
WHERE
actor=="westurner"
and
type!="WatchEvent"
ORDER BY created_at
LIMIT 1000

My Activity > Recently Starred

SELECT repository_url, created_at
FROM [githubarchive:github.timeline]
WHERE
  actor=="westurner"
  AND
  payload_action=="started"
GROUP BY
 repository_url, created_at
ORDER BY
 created_at DESC
LIMIT 1000

Clone this wiki locally