Data

Tools

Indexes

Applications

Experiments

Open Source Science

https://github.com/datamade/bga-pensions

🏦 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.

https://github.com/datamade/bga-pensions

Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Academic email domains
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (7.8%) to scientific vocabulary
Last synced: 11 months ago · JSON representation

Repository

🏦 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.

Basic Info
Statistics
  • Stars: 2
  • Watchers: 1
  • Forks: 2
  • Open Issues: 8
  • Releases: 0
Created about 7 years ago · Last pushed over 1 year ago
Metadata Files
Readme

README.md

💵 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:

    bash git clone https://github.com/datamade/bga-pensions.git

  2. Set up docker

    bash 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.

bash 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.

bash 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.

bash docker-compose run app make data -e

Updating Pension Fund and Annual reports

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

Owner

  • Name: datamade
  • Login: datamade
  • Kind: organization
  • Email: info@datamade.us
  • Location: Chicago, IL

We build open source technology using open data to empower journalists, researchers, governments and advocacy organizations.

GitHub Events

Total
  • Member event: 1
  • Issue comment event: 1
  • Push event: 2
  • Pull request event: 2
  • Fork event: 1
Last Year
  • Member event: 1
  • Issue comment event: 1
  • Push event: 2
  • Pull request event: 2
  • Fork event: 1

Issues and Pull Requests

Last synced: 11 months ago

All Time
  • Total issues: 55
  • Total pull requests: 41
  • Average time to close issues: 10 days
  • Average time to close pull requests: 10 days
  • Total issue authors: 3
  • Total pull request authors: 5
  • Average comments per issue: 0.44
  • Average comments per pull request: 0.34
  • Merged pull requests: 34
  • Bot issues: 0
  • Bot pull requests: 5
Past Year
  • Issues: 0
  • Pull requests: 2
  • Average time to close issues: N/A
  • Average time to close pull requests: 7 days
  • Issue authors: 0
  • Pull request authors: 1
  • Average comments per issue: 0
  • Average comments per pull request: 1.0
  • Merged pull requests: 2
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
  • hancush (44)
  • xmedr (7)
  • fgregg (4)
Pull Request Authors
  • hancush (25)
  • xmedr (8)
  • dependabot[bot] (5)
  • bga-admin (2)
  • cam-rodriguez (2)
  • Infra-Genie (1)
Top Labels
Issue Labels
auth (6) question (1) bug (1)
Pull Request Labels
dependencies (5) python (3) javascript (1)

Dependencies

package-lock.json npm
  • 236 dependencies
package.json npm
  • babel-preset-env ^1.7.0
  • babelify ^7.3.0
  • browserify ^16.2.3
requirements.txt pypi
  • csvkit ==1.0.4
  • django ==2.2.28
  • django-compressor-toolkit ==0.6.0
  • django-datatables-view ==1.18.0
  • django-debug-toolbar ==2.0
  • django-postgres-stats ==1.0.0
  • flake8 ==3.7.8
  • gunicorn ==19.9.0
  • psycopg2 ==2.8.3
  • sentry-sdk ==0.13.1
.github/workflows/main.yml actions
  • actions/checkout v2 composite
  • actions/setup-python v2 composite
  • aws-actions/configure-aws-credentials v1 composite
  • webfactory/create-aws-codedeploy-deployment 0.2.2 composite
  • postgres 10.19 docker
.github/workflows/publish-docker-image.yml actions
  • docker/build-push-action v2 composite
  • docker/login-action v1 composite
Dockerfile docker
  • nikolaik/python-nodejs python3.7-nodejs12 build
docker-compose.yml docker
  • bga-pensions latest
  • ghcr.io/datamade/bga-pensions latest
  • postgres 10