Reports

Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles

Bowers, Alex J.; Choi, Yeonsoo; Huan, Yingqi; Huang, Yanxing; Jiang, Jingjing; Cibrian Lopez, Ghipsel; Murdoch, Alyssa; Pu, Kecen; Sill, Maeghan; Williams, Jonathan; Wu, Yue Summer; Xu, Guoliang; Saldaña, Christopher; Halverson, Richard

The purpose of this report is to map the landscape of thousands of publicly accessible PK-12 school datasets from seven U.S. states and Washington, D.C. to the National Academies of Sciences, Engineering, and Medicine (NASEM) framework of 16 indicators for schools and districts, including California, Kentucky, Maryland, North Carolina, Ohio, Oregon, and Texas. Consistent with NASEM (2019, 2020), we extend the focus on outcome data (such as test scores and graduation rates) to include a wide range of opportunity and resource data. Despite longstanding calls and mandates to leverage public education data for informed decision-making, data reuse remains limited due in part to poor adherence to the Findability, Accessibility, Interoperability, and Reusability (FAIR) data management principles. To address this challenge, we systematically identified and qualitatively coded public education datasets across the eight jurisdictions. Using a standardized data ingestion protocol grounded in the FAIR principles and a coding scheme based on the NASEM framework, we identified 3,822 datasets and created a metadata catalog for each locale. The report includes the full metadata catalogs, Preferred Reporting Items for Systematic Reviews and Meta-Analyses (PRISMA) flow diagrams visualizing data sources, network visualizations of data-indicator relationships, and data ingestion protocols and coding schemes. Additionally, we present an interrater reliability analysis of the NASEM indicator coding within and across the states, and a link rot analysis to assess the stability of public data over time. This report provides both a replicable methodological framework and a practical resource for researchers, policymakers, and educators seeking to navigate public education data for decision-making focused on opportunities and achievement for all students.

Files

  • thumbnail for Bowers et al 2025 Mapping Public Open Access K-12 Indicators.pdf Bowers et al 2025 Mapping Public Open Access K-12 Indicators.pdf application/pdf 36.4 MB Download File

More About This Work

Academic Units
Education Leadership
Published Here
January 13, 2026

Related Items

Supplemented by:
Online Supplement 1 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: California v1.3 Metadata Megatable
Supplemented by:
Online Supplement 2 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Kentucky v1.3 Metadata Megatable
Supplemented by:
Online Supplement 3 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Maryland v1.3 Metadata Megatable
Supplemented by:
Online Supplement 4 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: North Carolina v1.3 Metadata Megatable
Supplemented by:
Online Supplement 5 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Ohio v1.3 Metadata Megatable
Supplemented by:
Online Supplement 6 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Oregon v1.3 Metadata Megatable
Supplemented by:
Online Supplement 7 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Texas v1.3 Metadata Megatable
Supplemented by:
Online Supplement 8 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Washington, D.C. v1.3 Metadata Megatable
Supplemented by:
Online Supplement 9 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Data Dictionary v1.3 Metadata Megatable
Supplemented by:
Online Supplement 10 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Interrater Reliability Tracker Data
Supplemented by:
Online Supplement 11 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Social Network Analysis Visualizations and Code
Supplemented by:
Online Supplement 12 Appendix for Bowers et al. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles: Interrater Reliability Visualizations and Code

Notes

Suggested Citation:
Bowers, A.J., Choi, Y., Huan, Y., Huang, Y., Jiang, J., Cibrian Lopez, G., Murdoch, A., Pu, K., Sill, M., Williams, J., Wu, Y., Xu, G., Saldaña, C., Halverson, R. (2025) Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles. Teachers College, Columbia University, New York, NY. https://doi.org/10.7916/c0jk-5e64