-- Auto-generated BigQuery query for Blink UseCounter features
-- Generated: 2026-06-22
-- Dumps EVERY pre-aggregated counter from httparchive.blink_features.usage
-- for the crawl date at rank=50000000 (all sites, the comparable
-- population). Attribution to web-features happens downstream in
-- collect-httparchive.mjs (buildBlinkReverseMap): bare api.* interfaces
-- AND the curated member-level counters in BLINK_COUNTER_RULES (Lever A).
-- Dumping the full table (a small, pre-aggregated dataset, ~3 MB) keeps
-- newly-added counters discoverable without editing this filter.

DECLARE crawl_date DATE DEFAULT '2026-05-01';

-- 818 bare interfaces + 44 curated member-level counters are attributed downstream.
SELECT
  uf.feature,
  uf.pct_urls AS pct,
  uf.client
FROM `httparchive.blink_features.usage` uf
WHERE uf.date = crawl_date
  AND uf.client = 'desktop'
  AND uf.rank = 50000000
ORDER BY pct DESC;