# Web font use since inception; define "site"

**URL:** <https://discuss.httparchive.org/t/web-font-use-since-inception-define-site/1999>\
**Category:** Analysis\
**Created:** [July 22, 2020, 9:23pm UTC](https://discuss.httparchive.org/t/web-font-use-since-inception-define-site/1999 "2020-07-22T21:23:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsheeter](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rsheeter/32/1784_2.png) [@rsheeter](https://discuss.httparchive.org/u/rsheeter)\
**Post date:** [July 22, 2020, 9:23pm UTC](https://discuss.httparchive.org/t/web-font-use-since-inception-define-site/1999/1 "2020-07-22T21:23:01Z")

</div>

After seeing questions about % web font usage on [https://github.com/HTTPArchive/almanac.httparchive.org/issues/902](https://github.com/HTTPArchive/almanac.httparchive.org/issues/902) I tried to answer via bigquery and wound up with this after rviscomi kindly fixed my initial query 🙂

![Web font usage](https://canada1.discourse-cdn.com/flex035/uploads/httparchive/original/2X/2/2ea9e5589c635b7581a1ca14c3209e64d5b8da6d.png)

> **[HTTP Archive pages with webfonts \[PUBLIC \]](https://docs.google.com/spreadsheets/d/1N5oaO5Sgod70VSplx521E7lkiPww97cOxd7iBD7GLkc/edit#gid=464027685)**
>
> mk2
> 
> BigQuery,select
> if(ends\_with(\_table\_suffix, 'desktop'), 'desktop', 'mobile') client,
> cast(substr(\_table\_suffix, 1, 4) as int64) year,
> cast(substr(\_table\_suffix, 6, 2) as int64) month,
> countif(reqFont \> 0) / count(0)...

The original question was in terms of site. This answer is in terms of page. Defining site seems a little awkward. A host or domain might have many things a user would think of as a site, and what a user thinks of as a site might have many hosts or domains. I’m curious if there is a definition of “site” httparchive uses?

---

<div class="post-metadata">

**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\
**Post date:** [July 23, 2020, 12:07am UTC](https://discuss.httparchive.org/t/web-font-use-since-inception-define-site/1999/2 "2020-07-23T00:07:21Z")

</div>

Here’s the query from the sheet, for visibility:

```sql
select
  if(ends_with(_table_suffix, 'desktop'), 'desktop', 'mobile') client,
  cast(substr(_table_suffix, 1, 4) as int64) year,
  cast(substr(_table_suffix, 6, 2) as int64) month,
  countif(reqFont > 0) / count(0) pct_pages_with_fonts
from `httparchive.summary_pages.*`
group by 1, 2, 3
order by 1, 2, 3;

```