Political Survey Data Analysis • 2024 General Election & Polling
Loading Database...
Downloading 71MB database file (one-time load, will be cached)
Constituencies
-
Survey Respondents
-
Survey Responses
-
Political Parties
-
Explore Data
SELECT
p.canonical_name as party,
COUNT(*) as seats_won,
SUM(e.votes) as total_votes,
AVG(e.vote_share) * 100 as avg_vote_share
FROM fact_election_result e
JOIN dim_party p ON e.party_id = p.party_id
WHERE e.seats_won = 1 AND e.election_year = 2024
GROUP BY p.canonical_name
ORDER BY seats_won DESC;
SELECT
s.canonical_name as party,
AVG(r.numeric_value) as avg_favourability,
COUNT(*) as num_responses
FROM fact_response r
JOIN dim_question_instance qi ON r.question_instance_id = qi.question_instance_id
JOIN dim_subject s ON qi.subject_id = s.subject_id
WHERE r.numeric_value < 90 -- Exclude "Don't know"
GROUP BY s.canonical_name
ORDER BY avg_favourability DESC;
SELECT
c.canonical_name as constituency,
c.region,
AVG(CASE WHEN d.variable_name = 'Percentage of people aged 18-24' THEN d.value END) as young_pct,
AVG(CASE WHEN d.variable_name = 'Percentage of people aged 65+' THEN d.value END) as senior_pct
FROM dim_constituency c
LEFT JOIN fact_constituency_demographic d ON c.constituency_id = d.constituency_id
GROUP BY c.canonical_name, c.region
LIMIT 50;