Rutgers Graduate School of Education - Education Law Center

School Funding Fairness Data System

Introduction

This database is a comprehensive collection of federal data at the school district level. The purpose is to provide a single source of data for researchers working in the field of education finance and economics; specifically, this dataset will be used to develop reliable measures of funding equity and adequacy to track fairness of state school finance.


This project is supported by a grant from the William T. Grant Foundation. More information is available at: http://wtgrantfoundation.org/browse-grants#/grant/183939

Data Sets – Overview

The Rutgers Graduate School of Education/Education Law Center: School Funding Fairness Data System thus far consists of three data sets:

                            1 . Local Education Agency Fiscal Database FY 1993 – 2014, v.1.0

This file is a panel of local education agency (district) level data running from 1987 to 2014, for the nation’s approximately 16,000 local education agencies. This file includes fiscal data for local public school districts from 1993 to 2014, including summed revenues and expenditures, revenues by source and expenditures by type. Some of the variables for school districts have been “rolled up” from school-level data; names and labels indicate these variables in the dataset.

                            2. State Equity Indicators Database FY 1993 – 2014, v.1.0

 This file contains a set of equity, spending, salary, staffing and student outcome indicators for each state and the District of Columbia for 1993 to 2014.   These indicators are generated by models applied to the district level panel, with additional indicators constructed using American Community Survey Data, the National Assessment of Educational Progress, and other sources described herein.  This panel is useful for studying changes in state resource levels and resource equity over time, with respect to policy and contextual changes.

                            3. School Fiscal Database FY 2011-12 & FY 2013-14, v.1.0

This file contains school level data including staffing salaries per pupil as reported in the Civil Rights Data Collection, for the two recent available years fy2011-12 and fy2013-14. These data are merged with school characteristics data from the National Center for Education Statistics Common Core, Public School Universe survey. These data provide a preliminary look into within-district, cross-school variations in total staffing resources.

Data Sources - Overview

The data sources used here are:

  •         Decennial Housing and Income Data, 1990 & 2000 (_edge)
  •         Decennial District and County Population Density, 2000 & 2010 (_uscbdist and _uscb)
  •         Education Comparable Wage Index (ECWI) (_cwi)
  •        Small Area Income and Poverty Estimates (SAIPE) (_saipe)
  •        F33 School District Fiscal Data, reduced dataset (_f33red)
  •        F33 School District Fiscal Data, full dataset (_f33full)
  •        NCES Common Core of Data: local education agency (LEA) level (_ccdlea)
  •        NCES Common Core of Data: school level ("rolled up" to LEA level) (_ccdpsu)

These sources are linked by their "leaid," a specific identifier used by the US Department of Education's National Center for Education Statistics (NCES).

Each of these sources is identified in this dataset by a variable suffix. The suffix is always preceded by an underscore (_). Variables without an underscore were either calculated by the authors of this dataset based on data from the sources above, or were used to link the sources ("leaid" and "year").

 “Year” refers to fiscal year (FY). We link fiscal data in its FY to NCES-CCD data from the spring of the given school year; for example, FY 2014 data is linked to CCD data from the 2013-14 school year. Note that file names for CCD data are for the fall of the given school year (for example, the file name for the CCD LEA survey for 2013-14 is “ag131a_supp.txt”).

DOWNLOAD CODEBOOK HERE

 

Data Set

Index/Variables

Data Sets

Local Education Agency Fiscal Database FY 1993 – 2014, v.1.0

PDF


STATA (formatted)

CSV

State Equity Indicators Database FY 1993 – 2014, v.1.0

PDF


STATA (formatted)

CSV

School Fiscal Database FY 2011-12 & FY 2013-14, v.1.0

PDF


STATA (formatted)

CSV

Data User Agreement

You agree not to use the data sets for commercial advantage, or in the course of for-profit activities. Commercial entities wishing to use this Service should contact Rutgers University’s Graduate School of Education at this link: http://gse.rutgers.edu/about/contact

You agree that you will not use these data to identify or to otherwise infringe the privacy or confidentiality rights of individuals.

THE DATA SETS ARE PROVIDED “AS IS” AND THE AUTHORS, RUTGERS UNIVERSITY, THE EDUCATION LAW CENTER, THE WILLIAM T. GRANT FOUNDATION, AND ALL OTHER ASSOCIATED PARTIES MAKE NO REPRESENTATIONS AND EXTEND NO WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED. THE ABOVE PARTIES SHALL NOT BE LIABLE FOR ANY CLAIMS OR DAMAGES WITH RESPECT TO ANY LOSS OR OTHER CLAIM BY YOU OR ANY THIRD PARTY ON ACCOUNT OF, OR ARISING FROM THE USE OF THE DATA SETS.

You agree that this Agreement and any dispute arising under it is governed by the laws of the State of New Jersey of the United States of America, applicable to agreements negotiated, executed, and performed within New Jersey.

You agree to acknowledge “Rutgers Graduate School of Education/Education Law Center: School Funding Fairness Data System” as the source of these data. In publications, please cite the data as:

Baker, B.D., Srikanth, A., Weber, M.A. (2016). Rutgers Graduate School of Education/Education Law Center: School Funding Fairness Data System. Retrieved from: http://www.schoolfundingfairness.org/data-download

Subject to your compliance with the terms and conditions set forth in this Agreement, Rutgers University grants you a revocable, non-exclusive, non-transferable right to access and make use of the Data Sets.

 

© (2016) Rutgers Graduate School of Education/Education Law Center: School Funding Fairness Data System. Data and documentation. All rights reserved.

Database construction: Bruce D. Baker, Ajay Srikanth, Mark Weber

Rutgers University, Graduate School of Education.

 

Codebook authors: Mark Weber, Ajay Srikanth & Bruce Baker