A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 Cleanup | The follow samples were discarded for being wildly out of line with previous and subsequent cycles | ||||||||||||||||||||||||
3 | desktop | 2016 | 12 | 16.56% | ||||||||||||||||||||||
4 | desktop | 2017 | 1 | 0.00% | ||||||||||||||||||||||
5 | desktop | 2019 | 3 | 1.17% | ||||||||||||||||||||||
6 | desktop | 2019 | 4 | 0.00% | ||||||||||||||||||||||
7 | ||||||||||||||||||||||||||
8 | ||||||||||||||||||||||||||
9 | query results, desktop | computed additions | query results, mobile | computed additions | ||||||||||||||||||||||
10 | client | year | month | desktop_pct_w_fonts | date | client | year | month | mobile_pct_w_fonts | date | ||||||||||||||||
11 | desktop | 2010 | 11 | 1.49% | 11/1/2010 | mobile | 2011 | 5 | 1.00% | 5/1/2011 | ||||||||||||||||
12 | desktop | 2010 | 12 | 1.71% | 12/1/2010 | mobile | 2011 | 6 | 1.74% | 6/1/2011 | ||||||||||||||||
13 | desktop | 2011 | 1 | 1.95% | 1/1/2011 | mobile | 2011 | 7 | 2.10% | 7/1/2011 | ||||||||||||||||
14 | desktop | 2011 | 2 | 2.31% | 2/1/2011 | mobile | 2011 | 8 | 2.61% | 8/1/2011 | ||||||||||||||||
15 | desktop | 2011 | 3 | 2.65% | 3/1/2011 | mobile | 2011 | 9 | 3.45% | 9/1/2011 | ||||||||||||||||
16 | desktop | 2011 | 4 | 2.95% | 4/1/2011 | mobile | 2011 | 10 | 3.56% | 10/1/2011 | ||||||||||||||||
17 | desktop | 2011 | 5 | 3.24% | 5/1/2011 | mobile | 2011 | 11 | 3.87% | 11/1/2011 | ||||||||||||||||
18 | desktop | 2011 | 6 | 3.57% | 6/1/2011 | mobile | 2011 | 12 | 4.29% | 12/1/2011 | ||||||||||||||||
19 | desktop | 2011 | 7 | 4.00% | 7/1/2011 | mobile | 2012 | 1 | 4.44% | 1/1/2012 | ||||||||||||||||
20 | desktop | 2011 | 8 | 4.40% | 8/1/2011 | mobile | 2012 | 2 | 5.13% | 2/1/2012 | ||||||||||||||||
21 | desktop | 2011 | 9 | 4.95% | 9/1/2011 | mobile | 2012 | 3 | 5.60% | 3/1/2012 | ||||||||||||||||
22 | desktop | 2011 | 10 | 5.58% | 10/1/2011 | mobile | 2012 | 4 | 5.85% | 4/1/2012 | ||||||||||||||||
23 | desktop | 2011 | 11 | 6.45% | 11/1/2011 | mobile | 2012 | 5 | 6.14% | 5/1/2012 | ||||||||||||||||
24 | desktop | 2011 | 12 | 6.90% | 12/1/2011 | mobile | 2012 | 6 | 7.16% | 6/1/2012 | ||||||||||||||||
25 | desktop | 2012 | 1 | 7.46% | 1/1/2012 | mobile | 2012 | 7 | 7.58% | 7/1/2012 | ||||||||||||||||
26 | desktop | 2012 | 2 | 8.22% | 2/1/2012 | mobile | 2012 | 8 | 8.20% | 8/1/2012 | ||||||||||||||||
27 | desktop | 2012 | 3 | 7.78% | 3/1/2012 | mobile | 2012 | 9 | 8.29% | 9/1/2012 | ||||||||||||||||
28 | desktop | 2012 | 4 | 7.71% | 4/1/2012 | mobile | 2012 | 10 | 9.06% | 10/1/2012 | ||||||||||||||||
29 | desktop | 2012 | 5 | 8.30% | 5/1/2012 | mobile | 2012 | 11 | 9.62% | 11/1/2012 | ||||||||||||||||
30 | desktop | 2012 | 6 | 9.14% | 6/1/2012 | mobile | 2012 | 12 | 10.19% | 12/1/2012 | ||||||||||||||||
31 | desktop | 2012 | 7 | 10.02% | 7/1/2012 | mobile | 2013 | 1 | 11.33% | 1/1/2013 | ||||||||||||||||
32 | desktop | 2012 | 8 | 10.29% | 8/1/2012 | mobile | 2013 | 2 | 11.78% | 2/1/2013 | ||||||||||||||||
33 | desktop | 2012 | 9 | 11.02% | 9/1/2012 | mobile | 2013 | 3 | 12.56% | 3/1/2013 | ||||||||||||||||
34 | desktop | 2012 | 10 | 12.16% | 10/1/2012 | mobile | 2013 | 4 | 13.21% | 4/1/2013 | ||||||||||||||||
35 | desktop | 2012 | 11 | 13.01% | 11/1/2012 | mobile | 2013 | 5 | 14.08% | 5/1/2013 | ||||||||||||||||
36 | desktop | 2012 | 12 | 13.73% | 12/1/2012 | mobile | 2013 | 6 | 14.44% | 6/1/2013 | ||||||||||||||||
37 | desktop | 2013 | 1 | 14.06% | 1/1/2013 | mobile | 2013 | 7 | 14.49% | 7/1/2013 | ||||||||||||||||
38 | desktop | 2013 | 2 | 15.22% | 2/1/2013 | mobile | 2013 | 8 | 18.27% | 8/1/2013 | ||||||||||||||||
39 | desktop | 2013 | 3 | 16.20% | 3/1/2013 | mobile | 2013 | 9 | 21.07% | 9/1/2013 | ||||||||||||||||
40 | desktop | 2013 | 4 | 16.89% | 4/1/2013 | mobile | 2013 | 10 | 21.26% | 10/1/2013 | ||||||||||||||||
41 | desktop | 2013 | 5 | 17.80% | 5/1/2013 | mobile | 2013 | 11 | 23.99% | 11/1/2013 | ||||||||||||||||
42 | desktop | 2013 | 6 | 18.57% | 6/1/2013 | mobile | 2013 | 12 | 27.60% | 12/1/2013 | ||||||||||||||||
43 | desktop | 2013 | 7 | 19.15% | 7/1/2013 | mobile | 2014 | 1 | 28.56% | 1/1/2014 | ||||||||||||||||
44 | desktop | 2013 | 8 | 22.94% | 8/1/2013 | mobile | 2014 | 2 | 29.35% | 2/1/2014 | ||||||||||||||||
45 | desktop | 2013 | 9 | 25.25% | 9/1/2013 | mobile | 2014 | 3 | 30.61% | 3/1/2014 | ||||||||||||||||
46 | desktop | 2013 | 10 | 26.97% | 10/1/2013 | mobile | 2014 | 4 | 32.74% | 4/1/2014 | ||||||||||||||||
47 | desktop | 2013 | 11 | 31.46% | 11/1/2013 | mobile | 2014 | 5 | 34.70% | 5/1/2014 | ||||||||||||||||
48 | desktop | 2013 | 12 | 36.39% | 12/1/2013 | mobile | 2014 | 6 | 35.59% | 6/1/2014 | ||||||||||||||||
49 | desktop | 2014 | 1 | 36.70% | 1/1/2014 | mobile | 2014 | 7 | 37.15% | 7/1/2014 | ||||||||||||||||
50 | desktop | 2014 | 2 | 37.67% | 2/1/2014 | mobile | 2014 | 8 | 38.93% | 8/1/2014 | ||||||||||||||||
51 | desktop | 2014 | 3 | 38.76% | 3/1/2014 | mobile | 2014 | 9 | 39.42% | 9/1/2014 | ||||||||||||||||
52 | desktop | 2014 | 4 | 42.75% | 4/1/2014 | mobile | 2014 | 10 | 39.99% | 10/1/2014 | ||||||||||||||||
53 | desktop | 2014 | 5 | 44.10% | 5/1/2014 | mobile | 2014 | 11 | 41.21% | 11/1/2014 | ||||||||||||||||
54 | desktop | 2014 | 6 | 44.97% | 6/1/2014 | mobile | 2014 | 12 | 42.05% | 12/1/2014 | ||||||||||||||||
55 | desktop | 2014 | 7 | 45.84% | 7/1/2014 | mobile | 2015 | 1 | 42.16% | 1/1/2015 | ||||||||||||||||
56 | desktop | 2014 | 8 | 46.66% | 8/1/2014 | mobile | 2015 | 2 | 44.28% | 2/1/2015 | ||||||||||||||||
57 | desktop | 2014 | 9 | 47.35% | 9/1/2014 | mobile | 2015 | 3 | 45.21% | 3/1/2015 | ||||||||||||||||
58 | desktop | 2014 | 10 | 48.33% | 10/1/2014 | mobile | 2015 | 4 | 46.13% | 4/1/2015 | ||||||||||||||||
59 | desktop | 2014 | 11 | 47.81% | 11/1/2014 | mobile | 2015 | 5 | 46.45% | 5/1/2015 | ||||||||||||||||
60 | desktop | 2014 | 12 | 47.39% | 12/1/2014 | mobile | 2015 | 6 | 46.91% | 6/1/2015 | ||||||||||||||||
61 | desktop | 2015 | 1 | 48.23% | 1/1/2015 | mobile | 2015 | 7 | 48.48% | 7/1/2015 | ||||||||||||||||
62 | desktop | 2015 | 2 | 49.48% | 2/1/2015 | mobile | 2015 | 8 | 50.40% | 8/1/2015 | ||||||||||||||||
63 | desktop | 2015 | 3 | 50.00% | 3/1/2015 | mobile | 2015 | 9 | 50.36% | 9/1/2015 | ||||||||||||||||
64 | desktop | 2015 | 4 | 50.02% | 4/1/2015 | mobile | 2015 | 10 | 51.45% | 10/1/2015 | ||||||||||||||||
65 | desktop | 2015 | 5 | 52.81% | 5/1/2015 | mobile | 2015 | 11 | 52.40% | 11/1/2015 | ||||||||||||||||
66 | desktop | 2015 | 6 | 53.41% | 6/1/2015 | mobile | 2015 | 12 | 53.39% | 12/1/2015 | ||||||||||||||||
67 | desktop | 2015 | 7 | 53.85% | 7/1/2015 | mobile | 2016 | 1 | 55.04% | 1/1/2016 | ||||||||||||||||
68 | desktop | 2015 | 8 | 56.19% | 8/1/2015 | mobile | 2016 | 2 | 56.16% | 2/1/2016 | ||||||||||||||||
69 | desktop | 2015 | 9 | 57.59% | 9/1/2015 | mobile | 2016 | 3 | 55.89% | 3/1/2016 | ||||||||||||||||
70 | desktop | 2015 | 10 | 57.02% | 10/1/2015 | mobile | 2016 | 4 | 56.09% | 4/1/2016 | ||||||||||||||||
71 | desktop | 2015 | 11 | 57.32% | 11/1/2015 | mobile | 2016 | 5 | 58.02% | 5/1/2016 | ||||||||||||||||
72 | desktop | 2015 | 12 | 58.85% | 12/1/2015 | mobile | 2016 | 6 | 60.56% | 6/1/2016 | ||||||||||||||||
73 | desktop | 2016 | 1 | 59.62% | 1/1/2016 | mobile | 2016 | 7 | 60.36% | 7/1/2016 | ||||||||||||||||
74 | desktop | 2016 | 2 | 59.45% | 2/1/2016 | mobile | 2016 | 8 | 61.22% | 8/1/2016 | ||||||||||||||||
75 | desktop | 2016 | 3 | 59.48% | 3/1/2016 | mobile | 2016 | 9 | 61.57% | 9/1/2016 | ||||||||||||||||
76 | desktop | 2016 | 4 | 59.52% | 4/1/2016 | mobile | 2016 | 10 | 65.28% | 10/1/2016 | ||||||||||||||||
77 | desktop | 2016 | 5 | 59.50% | 5/1/2016 | mobile | 2016 | 11 | 65.84% | 11/1/2016 | ||||||||||||||||
78 | desktop | 2016 | 6 | 60.59% | 6/1/2016 | mobile | 2016 | 12 | 64.64% | 12/1/2016 | ||||||||||||||||
79 | desktop | 2016 | 7 | 61.69% | 7/1/2016 | mobile | 2017 | 1 | 64.98% | 1/1/2017 | ||||||||||||||||
80 | desktop | 2016 | 8 | 63.10% | 8/1/2016 | mobile | 2017 | 2 | 66.37% | 2/1/2017 | ||||||||||||||||
81 | desktop | 2016 | 9 | 62.39% | 9/1/2016 | mobile | 2017 | 3 | 66.97% | 3/1/2017 | ||||||||||||||||
82 | desktop | 2016 | 10 | 63.36% | 10/1/2016 | mobile | 2017 | 4 | 67.02% | 4/1/2017 | ||||||||||||||||
83 | desktop | 2016 | 11 | 64.37% | 11/1/2016 | mobile | 2017 | 5 | 67.33% | 5/1/2017 | ||||||||||||||||
84 | desktop | 2017 | 2 | 63.54% | 2/1/2017 | mobile | 2017 | 6 | 68.05% | 6/1/2017 | ||||||||||||||||
85 | desktop | 2017 | 3 | 66.90% | 3/1/2017 | mobile | 2017 | 7 | 68.57% | 7/1/2017 | ||||||||||||||||
86 | desktop | 2017 | 4 | 67.21% | 4/1/2017 | mobile | 2017 | 8 | 68.11% | 8/1/2017 | ||||||||||||||||
87 | desktop | 2017 | 5 | 67.88% | 5/1/2017 | mobile | 2017 | 9 | 68.49% | 9/1/2017 | ||||||||||||||||
88 | desktop | 2017 | 6 | 68.44% | 6/1/2017 | mobile | 2017 | 10 | 68.83% | 10/1/2017 | ||||||||||||||||
89 | desktop | 2017 | 7 | 68.54% | 7/1/2017 | mobile | 2017 | 11 | 69.09% | 11/1/2017 | ||||||||||||||||
90 | desktop | 2017 | 8 | 68.11% | 8/1/2017 | mobile | 2017 | 12 | 69.90% | 12/1/2017 | ||||||||||||||||
91 | desktop | 2017 | 9 | 68.72% | 9/1/2017 | mobile | 2018 | 1 | 69.67% | 1/1/2018 | ||||||||||||||||
92 | desktop | 2017 | 10 | 69.26% | 10/1/2017 | mobile | 2018 | 2 | 70.13% | 2/1/2018 | ||||||||||||||||
93 | desktop | 2017 | 11 | 69.75% | 11/1/2017 | mobile | 2018 | 3 | 70.30% | 3/1/2018 | ||||||||||||||||
94 | desktop | 2017 | 12 | 69.88% | 12/1/2017 | mobile | 2018 | 4 | 70.73% | 4/1/2018 | ||||||||||||||||
95 | desktop | 2018 | 1 | 70.04% | 1/1/2018 | mobile | 2018 | 5 | 70.48% | 5/1/2018 | ||||||||||||||||
96 | desktop | 2018 | 2 | 70.47% | 2/1/2018 | mobile | 2018 | 6 | 70.40% | 6/1/2018 | ||||||||||||||||
97 | desktop | 2018 | 3 | 70.44% | 3/1/2018 | mobile | 2018 | 7 | 68.24% | 7/1/2018 | ||||||||||||||||
98 | desktop | 2018 | 4 | 70.27% | 4/1/2018 | mobile | 2018 | 8 | 67.06% | 8/1/2018 | ||||||||||||||||
99 | desktop | 2018 | 5 | 70.49% | 5/1/2018 | mobile | 2018 | 9 | 66.95% | 9/1/2018 | ||||||||||||||||
100 | desktop | 2018 | 6 | 70.19% | 6/1/2018 | mobile | 2018 | 10 | 67.25% | 10/1/2018 |