faithmorlu-pixel/Liberia-Voters-registration-Data-Analysis

SQL analysis of Liberia voter registration data (2017–2023) exploring gender participation, registration growth, accessibility, and unregistered population gaps. Built with PostgreSQL. # Liberia Voter Registration Analysis (2017–2023) ## Project Overview This project analyzes voter registration data across Liberia's electoral districts, exploring regional distribution, gender participation, registration growth, voting center accessibility, and unregistered population gaps. The data was cleaned, loaded into a PostgreSQL database, and analyzed using SQL to surface insights relevant to electoral planning and civic inclusion. --- ## Dataset - **Source:** National Elections Commission Liberia (necliberia.org) - **Coverage:** 73 electoral districts across 15 counties - **Key fields:** registered voters (male/female), voting centers, unregistered population, total voting population (2017 & 2023) --- ## Dashboard 🔗 View Interactive Tableau Dashboard) > "Who Is Registering? and Who Is Missing?" — an interactive > exploration of Liberia voter registration trends, gender > participation, and accessibility gaps (2017–2023). ## Tools Used - **PostgreSQL** — data storage and querying - **Excel / CSV** — raw data format - **GitHub** — version control and project sharing --- ## Project Files | File | Description | |---|---| | `voter_registration_inserts_v2.sql` | Cleaned INSERT statements to load data into PostgreSQL | | `queries.sql` | All 9 SQL analysis queries | | `results/` | CSV exports of each query result | --- ## SQL Analyses | # | Analysis | Key Question | |---|---|---| | 1 | Total voters by county | Which counties have the most registered voters? | | 2 | Male vs Female distribution | How does gender break down by county? | | 3 | Female participation % | Which counties have the highest/lowest female inclusion? | | 4 | Registration growth 2017→2023 | Where did voter registration grow the most? | | 5 | Growth percentage by county | Which counties grew fastest in relative terms? | | 6 | Voters by electoral district | How are voters distributed at the district level? | | 7 | Avg voters per center | Which counties face the most overcrowded votin …