Skip to content

Instantly share code, notes, and snippets.

Embed
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
@andydavies

This comment has been minimized.

Copy link
Owner Author

andydavies commented Dec 10, 2015

pages_url,pages_rank,req_url
http://www.youtube.com/,3,https://fonts.gstatic.com/s/roboto/v15/1pO9eUAp8pSF8VnRTP3xnvesZW2xOQ-xsNqO47m55DA.woff
http://www.youtube.com/,3,https://fonts.gstatic.com/s/roboto/v15/RxZJdnzeo3R5zSexge8UUT8E0i7KZn-EPnyo3HZu7kw.woff
http://www.youtube.com/,3,https://fonts.gstatic.com/s/roboto/v15/2UX7WLTfW3W8TclTUvlFyQ.woff
http://www.youtube.com/,3,https://fonts.gstatic.com/s/roboto/v15/OLffGBTaF0XFOW1gnuHF0YbN6UDyHWBl620a-IRfuBk.woff
http://www.weibo.com/,16,http://img.t.sinajs.cn/t6/style/images/common/font/wbficon.eot?id=201509181405
http://www.ebay.com/,19,http://ir.ebaystatic.com/rs/v/f2jeeopmle4w1pu31tamtdpeh2f.eot?
http://www.ebay.com/,19,http://ir.ebaystatic.com/rs/v/wuw343wavy1ktdegkufz20hqneo.eot?
http://www.ebay.com/,19,http://ir.ebaystatic.com/rs/v/lb0lnbfvb2ycla0kn0skit4gc2z.eot?
http://www.instagram.com/,24,https://instagramstatic-a.akamaihd.net/bluebar/6fd9ee8/webfonts/proximanova-regit-webfont.eot?
http://www.instagram.com/,24,https://instagramstatic-a.akamaihd.net/bluebar/6fd9ee8/webfonts/proximanova-light-webfont.eot?
http://www.instagram.com/,24,https://instagramstatic-a.akamaihd.net/bluebar/6fd9ee8/webfonts/proximanova-boldit-webfont.eot?
http://www.instagram.com/,24,https://instagramstatic-a.akamaihd.net/bluebar/6fd9ee8/webfonts/proximanova-sbold-webfont.eot?
http://www.instagram.com/,24,https://instagramstatic-a.akamaihd.net/bluebar/6fd9ee8/webfonts/proximanova-bold-webfont.eot?
http://www.instagram.com/,24,https://instagramstatic-a.akamaihd.net/bluebar/6fd9ee8/webfonts/proximanova-reg-webfont.eot?
http://www.msn.com/,26,http://static-hp-wus.s-msn.com/sc/45/c9e14a.woff
http://www.wordpress.com/,33,https://fonts.gstatic.com/s/opensans/v13/DXI1ORHCpsQm3Vp6mXoaTXhCUOGz7vYGh680lGh-uXM.woff
http://www.wordpress.com/,33,https://s1.wp.com/i/noticons/Noticons.eot?
http://www.wordpress.com/,33,https://s1.wp.com/i/noticons/Noticons.woff
http://www.wordpress.com/,33,https://fonts.gstatic.com/s/opensans/v13/cJZKeOuBrn4kERxqtaUH3T8E0i7KZn-EPnyo3HZu7kw.woff
http://www.onclickads.net/,38,http://fonts.gstatic.com/s/ptsans/v8/O5pe56LvR8OXax_Q9tUMDg.woff
http://www.blogspot.com/,39,https://fonts.gstatic.com/s/opensans/v13/cJZKeOuBrn4kERxqtaUH3T8E0i7KZn-EPnyo3HZu7kw.woff
http://www.blogspot.com/,39,https://fonts.gstatic.com/s/opensans/v13/DXI1ORHCpsQm3Vp6mXoaTXhCUOGz7vYGh680lGh-uXM.woff
http://www.aliexpress.com/,41,http://i.alicdn.com/ae-wholesale-ui/node_modules/@alife/beta-apollo/src/font/open-sans.cd1c2929.eot?
http://www.tumblr.com/,42,https://secure.assets.tumblr.com/fonts/gibson/Gibson-Light-webfont.eot?3?
http://www.tumblr.com/,42,https://secure.assets.tumblr.com/fonts/gibson/Gibson-Regular-webfont.eot?3?
http://www.tumblr.com/,42,https://secure.assets.tumblr.com/fonts/gibson/Gibson-Italic-webfont.eot?3?
http://www.tumblr.com/,42,https://secure.assets.tumblr.com/fonts/gibson/Gibson-SemiBoldItalic-webfont.eot?3?
http://www.tumblr.com/,42,https://secure.assets.tumblr.com/fonts/gibson/Gibson-SemiBold-webfont.eot?3?
http://www.tumblr.com/,42,https://secure.assets.tumblr.com/fonts/gibson/Gibson-Bold-webfont.eot?3?
http://www.tumblr.com/,42,https://secure.assets.tumblr.com/fonts/gibson/Gibson-LightItalic-webfont.eot?3?
http://www.tumblr.com/,42,https://secure.assets.tumblr.com/fonts/tumblr-icons/tumblr-icons_a218830bbea1bc283e01f0a66f29d48a.eot?
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_text-italic.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_medium.woff
http://www.apple.com/,43,http://www.apple.com/v/home/cd/ac-assets/fonts/AppleIcons-Ultralight.eot?
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_text.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_semibold-italic.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_semibold.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_medium-italic.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_thin-italic.woff
http://www.apple.com/,43,http://www.apple.com/v/home/cd/ac-assets/fonts/AppleIcons-Thin.eot?
http://www.apple.com/,43,http://www.apple.com/v/home/cd/ac-assets/fonts/AppleIcons-Text.eot?
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_bold.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_bold-italic.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_ultralight.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_ultralight-italic.woff
http://www.apple.com/,43,http://www.apple.com/wss/fonts/Myriad-Set-Pro/v1/myriad-set-pro_thin.woff
http://www.microsoft.com/,46,https://assets.onestore.ms/cdnfiles/onestorerolling-1511-11008/shell/v3/fonts/shell-icons-0.4.0.eot?
http://www.microsoft.com/,46,http://c.s-microsoft.com/static/fonts/segoe-ui/west-european/Semilight/latest.eot?
http://www.microsoft.com/,46,http://c.s-microsoft.com/static/fonts/icons/homepage/normal/2.eot?
http://www.go.com/,58,http://a.dilcdn.com/a/matterhornserif-bold-d2ff06d05aee.eot?
http://www.go.com/,58,http://a.dilcdn.com/a/matterhornserif-regular-508e9050322e.eot?
http://www.go.com/,58,http://a.dilcdn.com/a/matterhornserif-semibold-ae467da2c8bf.eot?
http://www.diply.com/,70,https://fonts.gstatic.com/s/roboto/v15/RxZJdnzeo3R5zSexge8UUT8E0i7KZn-EPnyo3HZu7kw.woff
http://www.diply.com/,70,https://fonts.gstatic.com/s/roboto/v15/Hgo13k-tfSpn0qi1SFdUfT8E0i7KZn-EPnyo3HZu7kw.woff
http://www.diply.com/,70,http://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/fonts/fontawesome-webfont.eot?
http://www.diply.com/,70,https://fonts.gstatic.com/s/roboto/v15/d-6IYplOFocCacKzxwXSOD8E0i7KZn-EPnyo3HZu7kw.woff
http://www.diply.com/,70,https://fonts.gstatic.com/s/roboto/v15/2UX7WLTfW3W8TclTUvlFyQ.woff
http://www.diply.com/,70,https://fonts.gstatic.com/s/roboto/v15/vzIUHo9z-oJ4WgkpPOtg1_esZW2xOQ-xsNqO47m55DA.woff
http://www.blogger.com/,71,https://fonts.gstatic.com/s/opensans/v13/DXI1ORHCpsQm3Vp6mXoaTXhCUOGz7vYGh680lGh-uXM.woff
http://www.blogger.com/,71,https://fonts.gstatic.com/s/opensans/v13/cJZKeOuBrn4kERxqtaUH3T8E0i7KZn-EPnyo3HZu7kw.woff
http://www.outbrain.com/,79,http://www.outbrain.com/fonts/fontawesome-webfont.eot?
http://www.cnn.com/,81,http://www.i.cdn.cnn.com/.a/fonts/cnn/2.3.0/e0f8f15a-c0f6-4ddb-a86e-d0b3dd600c25.eot?
http://www.cnn.com/,81,http://www.i.cdn.cnn.com/.a/fonts/cnn/2.3.0/ae1656aa-5f8f-4905-aed0-93e667bd6e4a.eot?
http://www.cnn.com/,81,http://www.i.cdn.cnn.com/.a/fonts/cnn/2.3.0/07fe0fec-b63f-4963-8ee1-535528b67fdb.eot?
http://www.cnn.com/,81,http://www.i.cdn.cnn.com/.a/fonts/cnn/2.3.0/9eb382e7-b9a0-4ec0-86b3-7a690b9e127b.eot?
http://www.cnn.com/,81,http://www.i.cdn.cnn.com/.a/fonts/cnn/2.3.0/71c74bc5-e7c8-48ad-9b03-43f3e6760e4e.eot?
http://www.cnn.com/,81,http://www.i.cdn.cnn.com/.a/fonts/cnn/2.3.0/58a5cbff-d570-4c18-a5e3-60868dc07ae8.eot?
http://www.cnn.com/,81,http://www.i.cdn.cnn.com/.a/fonts/cnn/2.3.0/a4f9f319-dec9-4afc-8b50-e18cc1b61cb4.eot?
http://www.cnn.com/,81,http://www.i.cdn.cnn.com/.a/fonts/cnn/2.3.0/c07fef9e-a934-42d7-92ad-69205f2b8a00.eot?
http://www.dropbox.com/,85,https://fonts.gstatic.com/s/opensans/v13/k3k702ZOKiLJc3WVjuplzBa1RVmPjeKy21_GQJaLlJI.woff
http://www.dropbox.com/,85,https://fonts.gstatic.com/s/opensans/v13/u-WUoqrET9fUeobQW7jkRT8E0i7KZn-EPnyo3HZu7kw.woff
http://www.dropbox.com/,85,https://fonts.gstatic.com/s/opensans/v13/MTP_ySUJH_bn48VBG8sNSha1RVmPjeKy21_GQJaLlJI.woff
http://www.dropbox.com/,85,https://fonts.gstatic.com/s/opensans/v13/DXI1ORHCpsQm3Vp6mXoaTRa1RVmPjeKy21_GQJaLlJI.woff
http://www.github.com/,86,https://assets-cdn.github.com/static/fonts/octicons/octicons.eot?
http://www.ebay.de/,90,http://ir.ebaystatic.com/rs/v/lb0lnbfvb2ycla0kn0skit4gc2z.eot?
http://www.ebay.de/,90,http://ir.ebaystatic.com/rs/v/f2jeeopmle4w1pu31tamtdpeh2f.eot?
http://www.ebay.de/,90,http://ir.ebaystatic.com/rs/v/wuw343wavy1ktdegkufz20hqneo.eot?
http://www.bbc.co.uk/,93,http://static.bbci.co.uk/wwhp/1.89.0/fonts/wwhp-icons.eot?
http://www.ebay.co.uk/,96,http://ir.ebaystatic.com/rs/v/wuw343wavy1ktdegkufz20hqneo.eot?
http://www.ebay.co.uk/,96,http://ir.ebaystatic.com/rs/v/lb0lnbfvb2ycla0kn0skit4gc2z.eot?
http://www.ebay.co.uk/,96,http://ir.ebaystatic.com/rs/v/f2jeeopmle4w1pu31tamtdpeh2f.eot?

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.