BuhariBawa5/NIN-Enrollment-Coverage-in-Nigeria

An analytical study of NIN enrolment coverage across Nigerian states using publicly available data and population projections to access coverage gaps, gender disparity and how enrolment compares to projected population in 2025. # NIN-Enrollment-Coverage-in-Nigeria An analytical study of NIN enrolment coverage across Nigerian states using publicly available data and population projections with analysis performed in Excel and PostgreSQL to access coverage gaps, gender disparity and how enrolment compares to projected population in 2025. # Table Of Contents 1. Introduction 2. Data Sources 3. Data Models and Tables 4. Methodology 5. Key Analysis Questions 6. SQL Queries and Results 7. Anomaly Detection 8. Limitations 9. Reproducibility Notes # Introduction This project analyzes National Identification Number (NIN) enrollment data across Nigerian states and compares enrollment counts with projected population figures. The National Identification Number (NIN) is a unique identifier issued by the National Identity Management Commission (NIMC) to Nigerian citizens and legal residents. As a foundational identity system, NIN enrollment coverage is critical for effective service delivery, governance, and demographic planning.The objective of this analysis is to assess enrollment coverage gaps across states, examine gender disparities in enrollment, identify anomalies where total enrollments exceed projected population figures, and explore structural factors such as diaspora records and reporting boundaries that may influence these outcomes. # Data Sources I used publicly available data from official government sources: 1. NIN Enrollment Data by State 2. Population Data by State *Relationship Diagram created in lucid.app* # Data Models and Tables ## Tables ### Table 1- nin ### Columns * state - TEXT, NOT NULL * female - NUMERIC, NOT NULL * male - NUMERIC, NOT NULL * total_enrolment - NUMERIC, NOT NULL | state | female | male | total_enrolment | |-------------|---------|---------|-----------------| | Abia | 1027850 | 1659279 | 2687129 | | Adamawa | 1288294 | 1796528 | 3084822 | | Akwa_Ibom | 1026087 | 1172684 | 2198771 | | Anambra | 141 …