Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Query for HTTPArchive BigQuery data to list all font files for sites x top sites
select pages.url, pages.rank, req.url
from [httparchive:runs.latest_requests] as req
join (
select url, rank, pageid, reqFont from [httparchive:runs.latest_pages]
) as pages on pages.pageid = req.pageid
where lower(req.mimetype) contains "font"
and pages.rank <= 100 and pages.reqFont > 0
order by pages.rank

This comment has been minimized.

Copy link
Owner Author

andydavies commented Dec 10, 2015


Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.