{"sources":[{"key":"mediawatch_hours_recorded","measures":"Whole hours of TV and radio MediaWatch has recorded"},{"key":"mediawatch_channels_7d","measures":"Channels MediaWatch recorded in the last 7 days"},{"key":"crm_texts_sent","measures":"Confirmed delivered outbound text messages from the platform"},{"key":"polls_published","measures":"AFWH polls published through Pollster (current releases)"},{"key":"polling_polls","measures":"Public poll records in the Polling catalog","query":"SELECT count(*) FROM polling.polls"},{"key":"polling_crosstab_polls","measures":"Poll records with at least one stored crosstab cell","query":"SELECT count(DISTINCT pr.poll_id) FROM polling.poll_crosstabs pc JOIN polling.poll_results pr ON pr.id = pc.poll_result_id"},{"key":"polling_crosstab_cells","measures":"Stored crosstab cells in the Polling catalog","query":"SELECT count(*) FROM polling.poll_crosstabs"},{"key":"research_house_races","measures":"House contest records for the current calendar year; includes special elections","query":"SELECT count(*) FROM candidates.races WHERE race_year = extract(year FROM CURRENT_DATE)::int AND office = 'house'"},{"key":"research_senate_races","measures":"Senate contest records for the current calendar year; includes special elections","query":"SELECT count(*) FROM candidates.races WHERE race_year = extract(year FROM CURRENT_DATE)::int AND office = 'senate'"},{"key":"voterfile_states","measures":"States with canonical records in the VoterFile owner inventory; not a resale availability claim","query":"SELECT count(*) FROM voterfile.state_ingest_status WHERE canonical_voters > 0"},{"key":"voterfile_voters","measures":"Canonical voter records reported by the VoterFile owner inventory; not a fresh full-table census","query":"SELECT sum(canonical_voters) FROM voterfile.state_ingest_status WHERE canonical_voters > 0"}]}