Overview

This dataset comes from the National Center for Educational Statistics' Common Core of Data. Data is available for every state and the District of Columbia from the 2009-2010 school year. The data is roughly categorized into four categories: funding, how much money is given to the school; score, how students perform academically; attendance, the rate at which students and teachers attend; enrollment, the size of the schools. Funding is given in dollars. The 'Year' field has records for Preschool, Kindergarten, and grades 1-12.

https://nces.ed.gov/ccd/aboutCCD.asp

Downloads

Download all of the following files.

Field Descriptions

JSON Path Type Comment Example Value
[0].data.score.math.[0].grade int 4
[0].data.score.math.[0].scale score int 228
[0].state unicode alabama
[0].data dict {u'enrollment': {u'schools': 1615, u'students': {u'gender': {u'male': 387549, u'female': 368003}, u'all': 755552, u'race': {u'biracial': 2534, u'hispanic': 35389, u'black': 261255, u'asian': 9753, u'white': 440519, u'native american': 6102}, u'other': {u'individualized education program': 81216, u'free lunch eligible': 356929, u'ungraded students': u'', u'lep/ell students': 17559, u'reduced-price lunch eligible': 45457}, u'year': [8179, 57665, 58448, 56699, 57216, 59117, 59897, 59157, 59242, 57992, 62615, 57644, 51962, 49719]}, u'staff': 95144.48, u'teachers': 49363.24, u'student teacher ratio': 15.31}, u'attendance': {u'average student rate': 96, u'average teacher rate': 93.38461538, u'average minutes': 61768.53846}, u'funding': {u'expenditures': 7646087117L, u'revenue': 7239690678L}, u'score': {u'science': [{u'grade': 4, u'scale score': 142}, {u'grade': 8, u'scale score': 138}], u'reading': [{u'grade': 4, u'scale score': 216}, {u'grade': 8, u'scale score': 252}], u'math': [{u'grade': 4, u'scale score': 228}, {u'grade': 8, u'scale score': 269}], u'writing': [{u'grade': 4, u'scale score': 140}, {u'grade': 8, u'scale score': 148}]}, u'location': {u'latitude': 32.3182314, u'longitude': -86.902298}}
[0].data.score.science.[0].grade int 4
[0].data.score.science.[0].scale score int 142
[0].data.enrollment.students.gender.male int 387549
[0].data.enrollment.students.gender.female int 368003
[0].data.enrollment dict {u'schools': 1615, u'students': {u'gender': {u'male': 387549, u'female': 368003}, u'all': 755552, u'race': {u'biracial': 2534, u'hispanic': 35389, u'black': 261255, u'asian': 9753, u'white': 440519, u'native american': 6102}, u'other': {u'individualized education program': 81216, u'free lunch eligible': 356929, u'ungraded students': u'', u'lep/ell students': 17559, u'reduced-price lunch eligible': 45457}, u'year': [8179, 57665, 58448, 56699, 57216, 59117, 59897, 59157, 59242, 57992, 62615, 57644, 51962, 49719]}, u'staff': 95144.48, u'teachers': 49363.24, u'student teacher ratio': 15.31}
[0].data.attendance dict {u'average student rate': 96, u'average teacher rate': 93.38461538, u'average minutes': 61768.53846}
[0].data.funding dict {u'expenditures': 7646087117L, u'revenue': 7239690678L}
[0].data.score dict {u'science': [{u'grade': 4, u'scale score': 142}, {u'grade': 8, u'scale score': 138}], u'reading': [{u'grade': 4, u'scale score': 216}, {u'grade': 8, u'scale score': 252}], u'math': [{u'grade': 4, u'scale score': 228}, {u'grade': 8, u'scale score': 269}], u'writing': [{u'grade': 4, u'scale score': 140}, {u'grade': 8, u'scale score': 148}]}
[0].data.location dict {u'latitude': 32.3182314, u'longitude': -86.902298}
[0].data.attendance.average student rate int 96
[0].data.attendance.average teacher rate float 93.38461538
[0].data.attendance.average minutes float 61768.53846
[0].data.enrollment.students.gender dict {u'male': 387549, u'female': 368003}
[0].data.enrollment.students.all int 755552
[0].data.enrollment.students.race dict {u'biracial': 2534, u'hispanic': 35389, u'black': 261255, u'asian': 9753, u'white': 440519, u'native american': 6102}
[0].data.enrollment.students.other dict {u'individualized education program': 81216, u'free lunch eligible': 356929, u'ungraded students': u'', u'lep/ell students': 17559, u'reduced-price lunch eligible': 45457}
[0].data.enrollment.students.year list[int] Each of these match to the different age groups for students: The first one is Preschool, the second is Kindergarten, and so on for 1st grade - 12th grade. [8179, 57665, 58448, 56699, 57216, 59117, 59897, 59157, 59242, 57992, 62615, 57644, 51962, 49719]
[0].data.enrollment.schools int 1615
[0].data.enrollment.students dict {u'gender': {u'male': 387549, u'female': 368003}, u'all': 755552, u'race': {u'biracial': 2534, u'hispanic': 35389, u'black': 261255, u'asian': 9753, u'white': 440519, u'native american': 6102}, u'other': {u'individualized education program': 81216, u'free lunch eligible': 356929, u'ungraded students': u'', u'lep/ell students': 17559, u'reduced-price lunch eligible': 45457}, u'year': [8179, 57665, 58448, 56699, 57216, 59117, 59897, 59157, 59242, 57992, 62615, 57644, 51962, 49719]}
[0].data.enrollment.student teacher ratio float 15.31
[0].data.enrollment.teachers float 49363.24
[0].data.enrollment.staff float 95144.48
[0].data.score.science list[dict] [{u'grade': 4, u'scale score': 142}, {u'grade': 8, u'scale score': 138}]
[0].data.score.reading list[dict] [{u'grade': 4, u'scale score': 216}, {u'grade': 8, u'scale score': 252}]
[0].data.score.math list[dict] [{u'grade': 4, u'scale score': 228}, {u'grade': 8, u'scale score': 269}]
[0].data.score.writing list[dict] [{u'grade': 4, u'scale score': 140}, {u'grade': 8, u'scale score': 148}]
[0].data.funding.expenditures long 7646087117
[0].data.funding.revenue long 7239690678
[0].data.score.reading.[0].grade int 4
[0].data.score.reading.[0].scale score int 216
[0].data.enrollment.students.other.individualized education program int 81216
[0].data.enrollment.students.other.free lunch eligible int 356929
[0].data.enrollment.students.other.ungraded students unicode
[0].data.enrollment.students.other.lep/ell students int 17559
[0].data.enrollment.students.other.reduced-price lunch eligible int 45457
[0].data.location.latitude float 32.3182314
[0].data.location.longitude float -86.902298
[0].data.score.writing.[0].grade int 4
[0].data.score.writing.[0].scale score int 140
[0].data.enrollment.students.race.biracial int 2534
[0].data.enrollment.students.race.hispanic int 35389
[0].data.enrollment.students.race.black int 261255
[0].data.enrollment.students.race.asian int 9753
[0].data.enrollment.students.race.white int 440519
[0].data.enrollment.students.race.native american int 6102