HTTP Archive Lighthouse Queries

big-query-lighthouse.sql

/* Get the distribution of performance scores */
SELECT
  QUANTILES(FLOAT(JSON_EXTRACT_SCALAR(report, '$.categories.performance.score')), 21)
FROM
  [httparchive:lighthouse.2018_07_01_mobile]
WHERE
  report != 'null'
  AND JSON_EXTRACT(report, '$.categories.performance.score') != 'null'
  
/* Get the distribution of FCP values */
SELECT
  QUANTILES(FLOAT(JSON_EXTRACT_SCALAR(report, '$.audits.first-contentful-paint.rawValue')), 21)
FROM
  [httparchive:lighthouse.2018_07_01_mobile]
WHERE
  report != 'null'
  AND JSON_EXTRACT(report, '$.audits.first-contentful-paint.rawValue') != 'null'