Guide/Tool

Interactive Data Dashboard on Public School Facilities Funding


National Center on School Infrastructure (NCSI),

Levels of investment and spending affect the quality of school buildings and grounds. Use our interactive dashboard to visualize the scale, scope, and distribution of state and local public educational facilities inventory, investments, spending, and debt over time. The tool also enables comparison of local school facility spending patterns for rural, town, suburban, and urban community types and for low, medium, or high poverty school districts against state averages. As a tool that brings together data that historically have been difficult to access in one place, the real power of the dashboard rests in how it enables users to compare data across states and districts. Instructions for using the dashboard and notes about data sources are at the bottom of the page.

Note: The Dashboard contains the most up-to-date data that are available at a national scale, as reported by the National Center on Education Statistics (NCES). The NCES dataset is composed of data that are reported annually to NCES by all local education agencies across the country. However, there may be some discrepancies with data that are available at local or state levels due to gaps, errors, or omissions in reporting to NCES. See the data glossary and source notes for details on each data category.

Topics

Overview: Using the Dashboard

Watch these short explainer videos for tutorials on using the dashboard. Additional instructions for using the dashboard and notes about data sources are posted below the dashboard.


Details: Using the Dashboard

The Dashboard includes data on several categories of facilities spending. These categories are defined below in the Data Glossary and Source Notes, which also provide a key to related terms and information on the sources of the data.

The Dashboard menus and fields appear on two tabbed pages: Profiles and Comparisons. Buttons at the bottom of each page allow you to download or share your search results.

The Profiles page enables users to view facilities spending data in two ways: as an annual overview, and in detail over a period of years.

  • Using the three drop-down menus at the top of this page, define a search of annual facilities spending figures for the U.S. as a whole, for any single state (or the District of Columbia), or for any single public school district within a selected state. Once you define a search, the page will refresh and the figures displayed in the overview at the top of the page will reflect data for the year you selected.  For the U.S. as a whole and for most states, data are available for each year between 1995 and 2022; but, for some school districts, data are only available for a lesser span of years.
  • Further down the page, use the drop-down menus in the shaded bar to choose whether to view spending data in total or on a per-student basis, and in actual dollar figures for the selected year or in adjusted figures that convert the actual figures to their 2024 equivalents. Once you make these selections, the page will refresh and the dashboard will display a detailed break-down of spending in the state or district you selected, encompassing the entire period for which data are available (charts 1-6).

The Comparisons page enables users to compare school facilities spending across the 50 states (and the District of Columbia) from 2005 to 2022.

  • The color-coded map indicates the per-student level of capital investment in school facilities by districts in every state from 1995 to 2022. To see details for any state – including total and per-student capital outlays, and related district debt – hover your cursor over the image of that state.
  • Below the map, two charts (7-8) display detailed data on facilities spending in each state. Use the drop-down menus at left to select a year to view total annual facilities spending by districts in each state. Use the menus at right to select a specific type of spending: maintenance & operations; capital outlay; debt; or interest.

On either chart, you can refine your search in three ways:

  • Choose whether to view spending data in total, or on a per-student basis;
  • Include data from districts in all types of communities, or only in selected types;
  • Include data from communities with all levels of poverty, or only those with selected levels.

The charts are independent; so, for example, to view data for the same year on both charts, select that year from the drop-down menus both at left and at right.

Data Glossary and Source Notes

Unless otherwise stated, fiscal data documentation can be found in the Documentation for the NCES Common Core of Data National Public Education Financial Survey (NPEFS), School Year 2021-22 (Fiscal Year 2022): Provisional File Version 1a.

U.S., State, and District Profiles

 

The number of operating PK-12 public schools reported by local education agencies (LEAs) for each fiscal year, viewed for U.S. total, by state, or for an individual LEA. 

Definition: School is an institution that provides educational services; has one or more grade groups (PK through 12); has one or more teachers; is located in one or more buildings; has an assigned administrator(s). (Common Education Data Standards (CEDS))

Data Source: National Center for Education Statistics NCES Table Generator.

The number of local education agencies (LEAs) in the U.S. or states. The LEAs in the data dashboard include regular school districts, charter school operators, as well as career and technical education agencies, regional and county offices of education, special education centers, and education agencies providing services in detention facilities.

Definition: An LEA is an administrative unit at the local level that exists primarily to operate schools or to contract for educational services. These units may or may not be co-extensive with county, city, or town boundaries.” (Common Education Data Standards (CEDS)

Data Source: National Center for Education Statistics NCES Table Generator.

The number of full-time equivalent (FTE) staff employed by the local education agency as reported for each fiscal year.  

Definition: LEA staff includes all types of staff positions employed by the local education agency. The option set of titles of employment, official status, or rank of education staff can be found in Common Education Data Standards (CEDS) Elements.
Data Source: National Center for Education Statistics NCES Table Generator.

The number of students served by the local education agency.  For LEAs serving students counted in home schools, such as career technical centers, or other schools, their enrollment is 0, to avoid double counting students. 

Definition: The count of pupils (includes charter pupils) served by the reporting LEA (local education agency) on October 1 (or the closest day to October 1) of the LEA’s fiscal year.

Data Source:  Field V33, National Center for Education Statistics CCD Data Files   

Chart 1 displays school district reported expenditures for Maintenance and Operation of Plant (Field V40) for Fiscal Years 1995-2022 as total expenditures, per student expenditures for the fiscal year, in actual dollars or inflation adjusted dollars for LEAs, States, and U.S.   

Definition: Maintenance and Operations of Plant includes district expenditures for utilities, property insurance, care and upkeep of grounds and equipment, regular maintenance services, minor repairs, nonstudent transportation vehicle operation and maintenance, and security services.

Data Source: Field V40,  National Center for Education Statistics CCD Data Files
 

Chart 2 displays the percentage of the total operating expenditures of the school district (Field TCURELSC) that are spent on facilities maintenance and operations (Field V40) for Fiscal Years 1995-2022 for LEAs, States, and U.S.  

Definition: TCURELSC expenditures are the total school district (LEA) expenditures for a fiscal year. These expenditures include all instruction, support services, and other district operating expenditures, but exclude any capital outlay and interest on debt (field i86). 

Data Source: Fields V40 and TCURELSC,  National Center for Education Statistics CCD Data Files

Chart 3 displays Facilities Capital Expenditures of school districts (LEAs) and State Revenue for Capital Outlay (the red dotted line) for Fiscal Years 1995-2022 as total expenditures or per student expenditures in actual dollars or inflation-adjusted dollars for LEAs, States, and U.S. Facilities Capital Expenditures combines school district reported school construction (Field F12) and other equipment capital outlay (Field K10).  

Definition: School construction (Field F12) is "the production of fixed works and structures and additions, replacements, and major alterations thereto, including the planning and design of specific projects, site improvements, and the provision of equipment and facilities that are integral parts of a structure. Includes construction undertaken either on a contractual basis by private contractors or through a government’s own staff (i.e., force account) and other equipment.” 

Other Equipment (K10) is non-instructional equipment capital outlay and includes such major items as boilers, chillers, and air handling units for heating, ventilation, and air conditioning. Equipment expenditure refers exclusively to amounts spent on purchasing equipment, which includes both new equipment and replacements.  

State Revenue for Capital Outlay is the district reported revenue from the state to the local district specifically for school construction and building aid, including amounts to help school systems pay for servicing debt. (Field C11) 

Data Source: Fields F12, K10, and C11, U.S. Department of Education, National Center for Education Statistics CCD Data Files

Chart 4 displays the count of students enrolled in the local school districts (LEAs) reported by school districts for Fiscal Years 1995 to 2022 for LEAs, States, and U.S. The enrollment includes any PK-12 grade students served by the LEAs surveyed, so charter students, adults, and non-graded special education students. The School Year begins the year prior to the Fiscal Year, so FY1995 School Year is 1994-1995.  

Definition: The count of pupils served by the reporting LEA (local education agency) on October 1 (or the closest day to October 1) of the LEA’s fiscal year. 

Data Source: Field V33, National Center for Education Statistics CCD Data Files

Chart 5 displays District reported long term debt for Fiscal Years 1995-2022 as total expenditures, per student expenditures for LEAs, States, and U.S.-- only reported in actual dollars.  

Definition: Debt at the End of Fiscal Year includes all debt obligations that carry over from year to year and the amount unpaid at the end of the fiscal year, referred to as long-term debt.  

Data Source: Field 41, National Center for Education Statistics CCD Data Files

Chart 6 displays the amount of annual interest paid by school districts on their long-term debt.  

Data Source: Field i86, National Center for Education Statistics CCD Data Files 

Guide to State Comparisons

When rolling over a state on the Map, you can view facilities capital expenditures over the 27 year period from FY1995 through 2022, in total, and on a per student basis, as well as outstanding long term debt at the end of Fiscal Year 2022 in total and on a per student basis. The heat map displays how states compare on per student facilities capital expenditures from Fiscal Year 1995 to 2022 in 2024 inflation-adjusted dollars, with the darkest blue representing the highest levels of spending. The per student calculation is based on the total facilities capital expenditures for 27 years divided by the FY2022 enrollment. 

Chart 7 shows facilities spending of districts in each state. You can view maintenance and operation expenditures as well as facilities capital outlay, which includes school construction and other equipment capital outlay, by total or per student, for the fiscal year selected. Use the filters to further analyze district spending by community type and/or levels of child poverty. In inflation-adjusted Dollars.

Chart 8 provides a comparison of states by their district levels of long-term debt at the end of the fiscal year and the amount of interest paid on the long-term debt as totals and on a per student basis. 

Chart 7 and Chart 8 filters function separately.  Because of this, you can explore facility spending and capital investment differences by types of districts using the community type and/or by levels of child poverty filters. It is also possible to compare different fiscal years.

When “total” measure is selected, this displays the amount of local education agency maintenance and operations or facilities capital expenditures, debt, interest, or enrollment reported, either in actual dollars, or in inflation-adjusted dollars. 

When per student measure is selected, this displays the total amount of local agency maintenance and operations or facilities capital expenditures, debt, or interest divided by the student enrollment for the year selected.  

Expenditures as reported in the years they were expended, not adjusted for inflation.

To facilitate multi-year comparisons of facility expenditures, fiscal data for maintenance & operations and facilities capital expenditures are provided as “actual dollars” or in “inflated-adjusted” dollars.  

Facility Capital Expenditures were adjusted using the Turner Construction Cost Index rather than the Consumer Price Index (CPI) because construction costs rise based on a different set of factors than the general consumer price index. 

The Maintenance & Operations of Plant expenditures were adjusted using the Consumer Price Index of the US Bureau of Labor Statistics.  

Debt levels at the end of the fiscal year and annual interest paid are not adjusted for inflation.  

The years used in the Data Dashboard are fiscal years.  Fiscal year 2022, for example, is school year 2021-2022. The year data related to Child Poverty estimates are based on the U.S. Census year.

Estimated number of relevant children 5 to 17 years old in poverty related to the household for Years 2005-2022 consolidated into: 

  • High Poverty School Districts where 21% or more of the children ages 5-17 live in households that are at poverty income levels. 
  • Medium Poverty School Districts where 11% to 20.99% of the children ages 5-17 live in households that are at poverty income levels. 
  • Low Poverty School Districts where less than 10.99% of the children ages 5-17 live in households that are at poverty income levels. 

This measure is only available for regular school districts, with defined geographic boundaries—in FY2022 there are 13,306 “regular” local education agencies out of 19,540 total local education agencies.  

Data Source: U.S. Census Small Area Income and Poverty Estimates (SAIPE) 

Community type is based on the population density served by the school district. This reflects the city, suburb, town, rural areas—where most students are enrolled in school. Locales are assigned to schools and to districts based on their reported physical address location. School districts may operate schools in more than one type of locale therefore an agency locale assignment reflects the dominant locale where most students are enrolled in school.  

The locales used to the U.S. Census to identify community types are: City-Large, City-Midsize, City-Small, Suburb-Large, Suburb-Midsize, Suburb-Small, Town-Fringe, Town-Distant, Town-Remote, Rural-Fringe, Rural-Distant, Rural-Remote. NCES locale framework used is developed from population areas defined by the U.S. Census Bureau.For the Dashboard, we condense the 12 locales into four locale categories: City, Suburb, Town, and Rural.   

Data Source: National Center for Education Statistics NCES Table Generator.

Related content

Voices from the field

Gathering Insights from Data: NCSI’s Interactive Data Dashboard on Public School Facilities Funding

National Center on School Infrastructure (NCSI)

An interview with Mary Filardo of 21CSF on tools that NCSI is creating to support decision-makers and advance shared knowledge about school facilities.

Headshot of Mary Filardo