A query against the GitHub Archive for "seven dirty word" usage in 2012

github_profanity.sql

SELECT repository_name, repository_language, repository_description, repository_watchers, payload_commit_msg, url, PARSE_UTC_USEC(created_at) as timestamp
FROM [githubarchive:github.timeline]
WHERE type="PushEvent"
  AND (
    LOWER(payload_commit_msg) CONTAINS "shit" OR
    LOWER(payload_commit_msg) CONTAINS "piss" OR
    LOWER(payload_commit_msg) CONTAINS "fuck" OR
    LOWER(payload_commit_msg) CONTAINS "cunt" OR
    LOWER(payload_commit_msg) CONTAINS "cocksucker" OR
    LOWER(payload_commit_msg) CONTAINS "motherfucker" OR
    LOWER(payload_commit_msg) CONTAINS "tits"
  )
  AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2012-01-01 00:00:00')
ORDER BY timestamp DESC;