Skip to content

Instantly share code, notes, and snippets.

@patrickkettner

patrickkettner/icon font bigquery

Created June 20, 2018 23:23
Show Gist options
  • Save patrickkettner/eac5eeb1fe7a3fca528add918bd41e96 to your computer and use it in GitHub Desktop.
Save patrickkettner/eac5eeb1fe7a3fca528add918bd41e96 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
icon font bigquery
SELECT REGEXP_EXTRACT(url, r'(captainicon|octicon|typicon|entypo|mfglabsiconset|ionicons|fontawesome|icomoon)') type, count(distinct(pageid)) cnt
FROM [httparchive:runs.2018_01_15_requests]
WHERE REGEXP_MATCH(url, r'captainicon|octicon|typicon|entypo|mfglabsiconset|ionicons|fontawesome|icomoon')
GROUP BY type
ORDER BY cnt desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment