2025 Reports
Mapping Public Open Access K-12 State Education Indicator Data Across 7 States and Washington D.C. Using the FAIR Data Principles
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.
Subjects
Files
-
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