Query UK Parliamentary election results via SQL in PostgreSQL.
npx skills add https://github.com/danbri/forgetmenot --skill psephology
Please help me install this Agent Skill. Skill: psephology Source: https://github.com/danbri/forgetmenot/tree/main/skills/psephology Command: npx skills add https://github.com/danbri/forgetmenot --skill psephology
This skill provides a structured, relational database of UK Parliamentary election results, solving the difficulty of accessing and cross-referencing historical election data, candidate performance, and constituency boundary changes.
Use the psephology skill to list all tables and their row counts to verify the current database state.
High-intent search queries and answers about installing and using this skill.
To query UK Parliamentary election results using SQL, you use a local PostgreSQL environment to execute queries against provided election data dumps. The relational database interface supports complex analytical queries across general elections and by-elections from 2010 onwards.
The available data for analyzing UK elections includes detailed records on candidacies, vote counts, shares, majorities, and constituency boundaries. You can track constituency history and boundary set legislation across general elections from 2010 to the present.
Yes, you need PostgreSQL to analyze the UK election data dumps. The skill requires a local PostgreSQL environment and depends on pg_ctlcluster and psql to execute SQL queries against the structured election data.
Yes, you can track constituency boundary changes across different general elections. The relational election data includes constituency history and boundary set legislation, allowing you to cross-reference historical election data and boundary changes from 2010 onwards.
To verify the database state when starting UK election data analysis, use the skill to list all tables and their row counts. This quick start approach confirms the current state of the election data dumps loaded in your PostgreSQL environment.
Limitations of using SQL for psephology include the requirement for a local PostgreSQL environment and dependency on command-line tools like psql. The dataset is also limited to UK Parliamentary elections from 2010 onwards, excluding earlier historical data.
kubiyabotRun PostgreSQL queries and admin tasks via the psql CLI.
iCesofTAnalyze execution plans and recommend indexing for SQL queries.
skills-ilQuery Israeli Knesset and election data from public APIs.
danbriRetrieve UK electoral candidate data from the DemocracyClub JSON API.
