alspur/kysrc

Data from Kentucky's School Report Cards website

kysrc

This package contains Kentucky public school data for 2012-2017 from the Kentucky School Report Card website. Data from the 2017-2018 school year are from the Open House page on the Kentucky Department of Education website.

Installation

Install from Github with devtools:

library(devtools)
install_github("alspur/kysrc")

What's inside

This package contains nine different kinds of datasets with data at three different levels: state, district, and school. To reference a table for a particular level, you will need to append the suffix state, dist, or sch, respectively. For example, ach_grade_state would provide summary data for the entire state of Kentucky, while ach_grade_sch would provide the same data for each public school in Kentucky.

The datasets included in this package are:

• acctbly_...: Accountability system scores and labels (until the 2015-2016 school year).
• acctbly_essa_...: Accountablity system scores and labels after ESSA reauthorization (first year = 2017-18).
• ach_grade_...: K-PREP test data by grade level (3-8, HS).
• ach_level_...: K-PREP test data by school level (Elementary School, Middle School, High School).
• act_...: ACT test data.
• ap_...: AP test data.
• ccr_...: College/Career Readiness data.
• fin_summary_...: Financial summary data (district & state only).
• frpl_...: Free/Reduced Price Lunch Eligibility data.
• grad_...: Four-year cohort graduation rate data.
• iep_...: Individualized Education Plan (IEP) counts and rates.
• lep_...: Limited English Proficiency (LEP) counts and rates.
• profile_...: Enrollment, Title 1 status, longitude, latitude, and NCES ID
• race_...: Racial demographic data.
• rev_exp_...: Revenue and expenditure data (district & state only).
• seek_...: SEEK funding data (district & state only).
• tax_...: Tax data (district & state only).
• teach_...: Teacher data.
• discipline_...: Discipline data.
• legal_...: Legal event data.
• behavior_events...: Behavior event data.
• behavior_context...: Behavior event data by context.
• behavior_location...: Behavior event data by location.
• behavior_ses...: Behavior event data by student socioeconomic status.
• behavior_grade...: Behavior event data by grade level.

Each dataset includes a unique identifier for the school/district/state, sch_id. This variable is helpful for joining data from multiple tables, as is year, which indicates the school year during which the data was generated.

There are currently 8,323,012 rows of data in this package and a total of 90,468,003 data points.

kysrc's Issues

Additional ideas for package

See (Kentucky State Report Cards)[https://github.com/wbuchanan/kentuckyStateReportCards] for other approaches to managing all the data. So far there is one function for combining the files across years called kdecombo and a second function/command for cleaning and standardizing variables from any of the files called kdestandardize. The second command has optional parameters to specify a primary key and metric variables which is used to drop everything but those variables, sort the data, and set the display order of the variables. Haven't started throwing together the graphing functions, but those won't take too long. Would rather set up a longer term solution using something like elasticsearch or another DB backend and use D3js to render graphs and provide user controls to manipulate things.