Using BigQuery to find public GitHub READMEs (readme%) with "blazing" in the contents: via https://twitter.com/peterbourgon/status/1039902928151052288

query.sql

SELECT
  repo_name,
  path
FROM (
  SELECT
    id,
    repo_name,
    path
  FROM
    `bigquery-public-data.github_repos.files`
  WHERE
    LOWER(path) LIKE "readme%" ) AS readmes
JOIN (
  SELECT
    id
  FROM
    `bigquery-public-data.github_repos.contents`
  WHERE
    REGEXP_CONTAINS(content, r"blazing")
    AND binary = FALSE) AS contents
ON
  readmes.id = contents.id
GROUP BY
  repo_name,
  path

results-20180913-112015.csv