Barry Pollard tunetheweb

## http_archive_css_alternate.sql
#standardSQL
# Percent of pages that include link[rel=alternate] for stylesheets
# Warning this uses 500GB of BigQuery usage so can be expensive to run multiple times!
CREATE TEMP FUNCTION hasAlternateCSS(payload STRING)
RETURNS BOOLEAN LANGUAGE js AS '''
  try {
    var $ = JSON.parse(payload);
    var almanac = JSON.parse($._almanac);
    return !!almanac['link-nodes'].find(
      e => e.rel.toLowerCase().includes('alternate')

## http_archive_img_height_width.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                tunetheweb
                / http_archive_img_height_width.md
            
            
              Last active
              February 9, 2020 19:53
            
          
    How many <img> elements have width and height attributes?

Query based on similar query about sizes and srcset created by Colin Bendell for the 2019 Web Almanac
This takes about 850GB to run for 2019 this produces the following results:


Row
client
hasHeight
hasWidth
hasPicture
total
pctHeight
pctWidth
pctPicture


1
mobile
3415295
3548809
108589
5447942
62.69%
65.14%
1.99%


2
desktop
2794913
2900974
94251
4474762
62.46%
64.83%
2.11%
	#standardSQL
	# Percent of pages that include link[rel=alternate] for stylesheets
	# Warning this uses 500GB of BigQuery usage so can be expensive to run multiple times!
	CREATE TEMP FUNCTION hasAlternateCSS(payload STRING)
	RETURNS BOOLEAN LANGUAGE js AS '''
	try {
	var $ = JSON.parse(payload);
	var almanac = JSON.parse($._almanac);
	return !!almanac['link-nodes'].find(
	e => e.rel.toLowerCase().includes('alternate')
Row	client	hasHeight	hasWidth	hasPicture	total	pctHeight	pctWidth	pctPicture
1	mobile	3415295	3548809	108589	5447942	62.69%	65.14%	1.99%
2	desktop	2794913	2900974	94251	4474762	62.46%	64.83%	2.11%