Skip to content

🏦 Funding public-employee pension systems is perhaps the most vexing emergency facing Illinois taxpayers. @bettergov hopes to bring clarity to this important topic by gathering and centralizing data from the largest public pension systems in the state.

Notifications You must be signed in to change notification settings

datamade/bga-pensions

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Feb 5, 2024
c4a9d99 Β· Feb 5, 2024
Jul 1, 2023
Oct 12, 2023
Feb 5, 2024
Jul 1, 2023
Jul 1, 2023
Jul 1, 2023
Jun 29, 2023
Nov 10, 2022
Jul 1, 2023
Oct 30, 2023
Oct 30, 2023
Jun 29, 2023
Jul 21, 2023
Jun 29, 2023
Jun 27, 2019
Jul 1, 2019
Jul 1, 2019
Jun 29, 2023
Aug 8, 2019

Repository files navigation

πŸ’΅ bga-pensions

Follow the money paid to retired public-sector employees throughout Illinois.

Requirements

  • Python 3.x
  • PostgreSQL 9.x +
  • Node / npm
  • wget

Getting started

  1. Clone this repository:

    git clone https://github.com/datamade/bga-pensions.git
  2. Set up docker

    docker-compose up

Importing data

The ETL process that supports this app encompasses two phases: formatting the data, and importing it into the Django database.

By default, the import will run for every year of data available, as of 2019. To run the complete import, navigate to the project directory in your shell, activate your virtual environment, and run make.

docker-compose run app make

You can also define specific years to format and import. Simply define a custom DATA_YEARS environmental variable as a string containing each of the years you wish to import, separated by spaces.

docker-compose run -e DATA_YEARS="2018 2019" app make -e

If you wish to make the data without importing it, specify the data target.

docker-compose run app make data -e

Updating Pension Fund and Annual reports

  1. TK use recipe from makefile to update fixtures from production

About

🏦 Funding public-employee pension systems is perhaps the most vexing emergency facing Illinois taxpayers. @bettergov hopes to bring clarity to this important topic by gathering and centralizing data from the largest public pension systems in the state.

Resources

Stars

Watchers

Forks