Bigquery - Popular new github repositories

bigquery-popular-new-github-repositories

/* POPULAR NEW GITHUB REPOSITORIES */
/* Change 2014-08-15 0:00:00 */
SELECT repository_url, COUNT(repository_name) as cnt, repository_language
FROM githubarchive:github.timeline
WHERE type="WatchEvent"
AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC("2014-08-15 0:00:00")
AND repository_url IN (
     SELECT repository_url
     FROM githubarchive:github.timeline
     WHERE type="CreateEvent"
     AND PARSE_UTC_USEC(repository_created_at) >= PARSE_UTC_USEC('2014-08-15 00:00:00')
     AND repository_fork = "false"
     AND payload_ref_type = "repository"
     GROUP BY repository_url
)
GROUP BY repository_name, repository_language, repository_description, repository_url
HAVING cnt >= 5
ORDER 

Output

{"kind": "bigquery#queryResponse", "rows": [{"f": [{"v": "https://github.com/the4dpatrick/possible-email"}, {"v": "Ruby"}, {"v": "71"}]}, {"f": [{"v": "https://github.com/djyde/V2EX-API"}, {"v": null}, {"v": "36"}]}, {"f": [{"v": "https://github.com/rails/globalid"}, {"v": "Ruby"}, {"v": "30"}]}, {"f": [{"v": "https://github.com/benbalter/markdown-to-pdf"}, {"v": "Ruby"}, {"v": "26"}]}, {"f": [{"v": "https://github.com/dboudro/AnimateSVGText"}, {"v": null}, {"v": "26"}]}], "jobReference": {"projectId": "oceanic-column-675", "jobId": "job_UXl9bVcv0K3HL9KdMMmt7Q7gYr8"}, "jobComplete": true, "totalRows": "5", "totalBytesProcessed": "28273995336", "cacheHit": false, "schema": {"fields": [{"type": "STRING", "name": "repository_url", "mode": "NULLABLE"}, {"type": "STRING", "name": "repository_language", "mode": "NULLABLE"}, {"type": "INTEGER", "name": "cnt", "mode": "NULLABLE"}]}}