ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
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) pct_pages_with_fonts
from `httparchive.summary_pages.*`
group by 1, 2, 3
order by 1, 2, 3;
2
Data CleanupThe follow samples were discarded for being wildly out of line with previous and subsequent cycles
3
desktop20161216.56%
4
desktop201710.00%
5
desktop201931.17%
6
desktop201940.00%
7
8
9
query results, desktopcomputed additionsquery results, mobile
computed additions
10
clientyearmonthdesktop_pct_w_fontsdateclientyearmonth
mobile_pct_w_fonts
date
11
desktop2010111.49%11/1/2010mobile201151.00%5/1/2011
12
desktop2010121.71%12/1/2010mobile201161.74%6/1/2011
13
desktop201111.95%1/1/2011mobile201172.10%7/1/2011
14
desktop201122.31%2/1/2011mobile201182.61%8/1/2011
15
desktop201132.65%3/1/2011mobile201193.45%9/1/2011
16
desktop201142.95%4/1/2011mobile2011103.56%10/1/2011
17
desktop201153.24%5/1/2011mobile2011113.87%11/1/2011
18
desktop201163.57%6/1/2011mobile2011124.29%12/1/2011
19
desktop201174.00%7/1/2011mobile201214.44%1/1/2012
20
desktop201184.40%8/1/2011mobile201225.13%2/1/2012
21
desktop201194.95%9/1/2011mobile201235.60%3/1/2012
22
desktop2011105.58%10/1/2011mobile201245.85%4/1/2012
23
desktop2011116.45%11/1/2011mobile201256.14%5/1/2012
24
desktop2011126.90%12/1/2011mobile201267.16%6/1/2012
25
desktop201217.46%1/1/2012mobile201277.58%7/1/2012
26
desktop201228.22%2/1/2012mobile201288.20%8/1/2012
27
desktop201237.78%3/1/2012mobile201298.29%9/1/2012
28
desktop201247.71%4/1/2012mobile2012109.06%10/1/2012
29
desktop201258.30%5/1/2012mobile2012119.62%11/1/2012
30
desktop201269.14%6/1/2012mobile20121210.19%12/1/2012
31
desktop2012710.02%7/1/2012mobile2013111.33%1/1/2013
32
desktop2012810.29%8/1/2012mobile2013211.78%2/1/2013
33
desktop2012911.02%9/1/2012mobile2013312.56%3/1/2013
34
desktop20121012.16%10/1/2012mobile2013413.21%4/1/2013
35
desktop20121113.01%11/1/2012mobile2013514.08%5/1/2013
36
desktop20121213.73%12/1/2012mobile2013614.44%6/1/2013
37
desktop2013114.06%1/1/2013mobile2013714.49%7/1/2013
38
desktop2013215.22%2/1/2013mobile2013818.27%8/1/2013
39
desktop2013316.20%3/1/2013mobile2013921.07%9/1/2013
40
desktop2013416.89%4/1/2013mobile20131021.26%10/1/2013
41
desktop2013517.80%5/1/2013mobile20131123.99%11/1/2013
42
desktop2013618.57%6/1/2013mobile20131227.60%12/1/2013
43
desktop2013719.15%7/1/2013mobile2014128.56%1/1/2014
44
desktop2013822.94%8/1/2013mobile2014229.35%2/1/2014
45
desktop2013925.25%9/1/2013mobile2014330.61%3/1/2014
46
desktop20131026.97%10/1/2013mobile2014432.74%4/1/2014
47
desktop20131131.46%11/1/2013mobile2014534.70%5/1/2014
48
desktop20131236.39%12/1/2013mobile2014635.59%6/1/2014
49
desktop2014136.70%1/1/2014mobile2014737.15%7/1/2014
50
desktop2014237.67%2/1/2014mobile2014838.93%8/1/2014
51
desktop2014338.76%3/1/2014mobile2014939.42%9/1/2014
52
desktop2014442.75%4/1/2014mobile20141039.99%10/1/2014
53
desktop2014544.10%5/1/2014mobile20141141.21%11/1/2014
54
desktop2014644.97%6/1/2014mobile20141242.05%12/1/2014
55
desktop2014745.84%7/1/2014mobile2015142.16%1/1/2015
56
desktop2014846.66%8/1/2014mobile2015244.28%2/1/2015
57
desktop2014947.35%9/1/2014mobile2015345.21%3/1/2015
58
desktop20141048.33%10/1/2014mobile2015446.13%4/1/2015
59
desktop20141147.81%11/1/2014mobile2015546.45%5/1/2015
60
desktop20141247.39%12/1/2014mobile2015646.91%6/1/2015
61
desktop2015148.23%1/1/2015mobile2015748.48%7/1/2015
62
desktop2015249.48%2/1/2015mobile2015850.40%8/1/2015
63
desktop2015350.00%3/1/2015mobile2015950.36%9/1/2015
64
desktop2015450.02%4/1/2015mobile20151051.45%10/1/2015
65
desktop2015552.81%5/1/2015mobile20151152.40%11/1/2015
66
desktop2015653.41%6/1/2015mobile20151253.39%12/1/2015
67
desktop2015753.85%7/1/2015mobile2016155.04%1/1/2016
68
desktop2015856.19%8/1/2015mobile2016256.16%2/1/2016
69
desktop2015957.59%9/1/2015mobile2016355.89%3/1/2016
70
desktop20151057.02%10/1/2015mobile2016456.09%4/1/2016
71
desktop20151157.32%11/1/2015mobile2016558.02%5/1/2016
72
desktop20151258.85%12/1/2015mobile2016660.56%6/1/2016
73
desktop2016159.62%1/1/2016mobile2016760.36%7/1/2016
74
desktop2016259.45%2/1/2016mobile2016861.22%8/1/2016
75
desktop2016359.48%3/1/2016mobile2016961.57%9/1/2016
76
desktop2016459.52%4/1/2016mobile20161065.28%10/1/2016
77
desktop2016559.50%5/1/2016mobile20161165.84%11/1/2016
78
desktop2016660.59%6/1/2016mobile20161264.64%12/1/2016
79
desktop2016761.69%7/1/2016mobile2017164.98%1/1/2017
80
desktop2016863.10%8/1/2016mobile2017266.37%2/1/2017
81
desktop2016962.39%9/1/2016mobile2017366.97%3/1/2017
82
desktop20161063.36%10/1/2016mobile2017467.02%4/1/2017
83
desktop20161164.37%11/1/2016mobile2017567.33%5/1/2017
84
desktop2017263.54%2/1/2017mobile2017668.05%6/1/2017
85
desktop2017366.90%3/1/2017mobile2017768.57%7/1/2017
86
desktop2017467.21%4/1/2017mobile2017868.11%8/1/2017
87
desktop2017567.88%5/1/2017mobile2017968.49%9/1/2017
88
desktop2017668.44%6/1/2017mobile20171068.83%10/1/2017
89
desktop2017768.54%7/1/2017mobile20171169.09%11/1/2017
90
desktop2017868.11%8/1/2017mobile20171269.90%12/1/2017
91
desktop2017968.72%9/1/2017mobile2018169.67%1/1/2018
92
desktop20171069.26%10/1/2017mobile2018270.13%2/1/2018
93
desktop20171169.75%11/1/2017mobile2018370.30%3/1/2018
94
desktop20171269.88%12/1/2017mobile2018470.73%4/1/2018
95
desktop2018170.04%1/1/2018mobile2018570.48%5/1/2018
96
desktop2018270.47%2/1/2018mobile2018670.40%6/1/2018
97
desktop2018370.44%3/1/2018mobile2018768.24%7/1/2018
98
desktop2018470.27%4/1/2018mobile2018867.06%8/1/2018
99
desktop2018570.49%5/1/2018mobile2018966.95%9/1/2018
100
desktop2018670.19%6/1/2018mobile20181067.25%10/1/2018