https://github.com/datamade/school-report-cards

Tools for parsing annual school report card data from the state of Illinois

https://github.com/datamade/school-report-cards

Science Score: 10.0%

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

  • CITATION.cff file
  • codemeta.json file
  • .zenodo.json file
  • DOI references
  • Academic publication links
  • Committers with academic emails
    1 of 4 committers (25.0%) from academic institutions
  • Institutional organization owner
  • JOSS paper metadata
  • Scientific vocabulary similarity
    Low similarity (9.6%) to scientific vocabulary

Keywords

database illinois school school-report-cards

Keywords from Contributors

datamade de-duplicating dedupe dedupe-library entity-resolution record-linkage
Last synced: 5 months ago · JSON representation

Repository

Tools for parsing annual school report card data from the state of Illinois

Basic Info
  • Host: GitHub
  • Owner: datamade
  • License: mit
  • Language: Makefile
  • Default Branch: master
  • Homepage:
  • Size: 8.73 MB
Statistics
  • Stars: 10
  • Watchers: 5
  • Forks: 2
  • Open Issues: 6
  • Releases: 0
Topics
database illinois school school-report-cards
Created over 12 years ago · Last pushed over 7 years ago
Metadata Files
Readme License

README.md

School Report Cards

Linux buildMac OS X build

Tools for parsing annual school report card data from the state of Illinois

Requirements

Ubuntu

Most of these dependencies are installed by default sudo apt-get install postgresql pip install csvkit pip install xlsx2csv

Mac OS X

Most of these dependencies are installed by default brew install postgresql pip install csvkit pip install xlsx2csv

make database

You will need to run createdb schools to initialize the postgres database.

Running make database will import the data into normalized tables in a postgresql database.

Right now, the database scripts only fully process the school-level data that appears in all 22 years of data. These include:

  • ACT Scores
  • Demography and enrollment
  • Time spent on subject
  • Class sizes, by grade
  • School level characteristics like parent involvement, truancy, and graduation rate.

make csv

If you just wish to download the data without importing it into a database, run make csv. It will:

  1. Download ISBE report card data from 1997-2015
  2. Convert the fixed width files to csv format, with year-over-year normalized column names

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
  • Fork event: 1
Last Year
  • Fork event: 1

Committers

Last synced: 9 months ago

All Time
  • Total Commits: 99
  • Total Committers: 4
  • Avg Commits per committer: 24.75
  • Development Distribution Score (DDS): 0.111
Past Year
  • Commits: 0
  • Committers: 0
  • Avg Commits per committer: 0.0
  • Development Distribution Score (DDS): 0.0
Top Committers
Name Email Commits
Forest Gregg f****g@u****u 88
Eric van Zanten e****c@b****s 6
Derek Eder d****k@d****m 4
Adam Chainz a****m@a****u 1
Committer Domains (Top 20 + Academic)

Issues and Pull Requests

Last synced: 9 months ago

All Time
  • Total issues: 5
  • Total pull requests: 4
  • Average time to close issues: 21 days
  • Average time to close pull requests: 17 days
  • Total issue authors: 3
  • Total pull request authors: 4
  • Average comments per issue: 1.6
  • Average comments per pull request: 0.75
  • Merged pull requests: 1
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 0
  • Pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 0
  • Pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Top Authors
Issue Authors
  • fgregg (3)
  • alexsoble (1)
  • hancush (1)
Pull Request Authors
  • fgregg (1)
  • thcrock (1)
  • adamchainz (1)
  • hancush (1)
Top Labels
Issue Labels
Pull Request Labels

Dependencies

requirements.txt pypi
  • csvkit *
  • psycopg2 *
  • xlsx2csv *