This repo consists of Nigerian Budget Data for data accessible period.
I once needed a transparent budget data of Nigeria and found none but some summaries on the internet and pdf files on Nigerian Budget Office's website. Thus, I decided to covert this pdf's to data with the following aims in view:
- To serve the information and decision-making needs of people.
- To provide a locally accessible data for data-analyst enthusiasts.
MDA => Ministries, Departments and Agencies
📂Budget_Data/
┣📂database/ --------- Sample Schema for database
┃ ┣🧾budget_18_19_20.sql
┃ ┣🧾mda-lookup.sql
┃ ┗🧾sub_mda_lookup.sql
┣📂summary/
┃ ┣🧾2018_summary_by_MDA --------- 2018 Budget Summary
┃ ┣🧾2019_summary_by_MDA --------- 2019 Budget Summary
┃ ┣🧾2020_summary_by_MDA --------- 2020 Budget Summary
┃ ┗🧾mda_by_year.json.csv --------- 2018 MDA Distribution by Year
┣🧾budget_2018.csv --------- 2018 Fiscal Budget
┣🧾budget_2019.csv --------- 2019 Fiscal Budget
┗🧾budget_2020.csv --------- 2020 Fiscal Budget
| Processed names | Raw Names |
| --------------------------- | -------------------- |
| MDA Code | table_identifier |
| MDA Name | table_identifier_MDA |
| Main MDA Code | costCenter_Code |
| Main MDA Name | costCenter_Code_MDA |
| Expenditure Code | lineExpCode |
| Expenditure | lineExpTerm |
| Fund Code | lineExpCodeLevel1 |
| Fund | lineExpTermLevel1 |
| Line Expense Code | lineExpCodeLevel2 |
| Line Expense | lineExpTermLevel2 |
| Line Expense Sub-group Code | lineExpCodeLevel3 |
| Line Expense Sub-group | lineExpTermLevel3 |
| Main Cost Code | lineExpCodeLevel4 |
| Main Cost Item | lineExpTermLevel4 |
-
- Data in MySql format.
-
- Detailed Exploratory Analytics and Visualization through blogposts.
-
- Update repo with 2104-2017 budget data.