Dataset: Massachusetts Public Schools Data

About this Dataset

Massachusetts Public Schools Data

Data Sources

This dataset compiles data from the following Massachusetts Department of Education reports:

Enrollment by Grade
Enrollment by Selected Population
Enrollment by Race/Gender
Class Size by Gender and Selected Populations
Teacher Salaries
Per Pupil Expenditure
Graduation Rates
Graduates Attending Higher Ed
Advanced Placement Participation
Advanced Placement Performance
SAT Performance
MCAS Achievement Results
Accountability Report

In each case, the data is the latest available data as of August 2017.

Data Dictionary

The data dictionary lists the report from which each field is sourced. It also includes the original field names - minor changes have been made to make the field names easier to understand. Data definitions can be found on the About the Data section of the MA DOE website.

Questions

What contributes to differences in schools outcomes?
Are there meaningful regional differences within MA?
Which schools do well despite limited resources?

Tables

Ma Public Schools 2017

@kaggle.ndalziel_massachusetts_public_schools_data.ma_public_schools_2017

708.8 KB
1861 rows
302 columns


CREATE TABLE ma_public_schools_2017 (
  "school_code" BIGINT,
  "school_name" VARCHAR,
  "school_type" VARCHAR,
  "function" VARCHAR,
  "contact_name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "town" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "phone" VARCHAR,
  "fax" VARCHAR,
  "grade" VARCHAR,
  "district_name" VARCHAR,
  "district_code" BIGINT,
  "pk_enrollment" BIGINT,
  "k_enrollment" BIGINT,
  "n_1_enrollment" BIGINT,
  "n_2_enrollment" BIGINT,
  "n_3_enrollment" BIGINT,
  "n_4_enrollment" BIGINT,
  "n_5_enrollment" BIGINT,
  "n_6_enrollment" BIGINT,
  "n_7_enrollment" BIGINT,
  "n_8_enrollment" BIGINT,
  "n_9_enrollment" BIGINT,
  "n_10_enrollment" BIGINT,
  "n_11_enrollment" BIGINT,
  "n_12_enrollment" BIGINT,
  "sp_enrollment" BIGINT,
  "total_enrollment" BIGINT,
  "first_language_not_english" DOUBLE,
  "n__first_language_not_english" DOUBLE,
  "english_language_learner" DOUBLE,
  "n__english_language_learner" DOUBLE,
  "students_with_disabilities" DOUBLE,
  "n__students_with_disabilities" DOUBLE,
  "high_needs" DOUBLE,
  "n__high_needs" DOUBLE,
  "economically_disadvantaged" DOUBLE,
  "n__economically_disadvantaged" DOUBLE,
  "n__african_american" DOUBLE,
  "n__asian" DOUBLE,
  "n__hispanic" DOUBLE,
  "n__white" DOUBLE,
  "n__native_american" DOUBLE,
  "n__native_hawaiian_pacific_islander" DOUBLE,
  "n__multi_race_non_hispanic" DOUBLE,
  "n__males" DOUBLE,
  "n__females" DOUBLE,
  "total_of_classes" DOUBLE,
  "average_class_size" DOUBLE,
  "number_of_students" DOUBLE,
  "salary_totals" DOUBLE,
  "average_salary" DOUBLE,
  "fte_count" DOUBLE,
  "in_district_expenditures" DOUBLE,
  "total_in_district_ftes" DOUBLE,
  "average_in_district_expenditures_per_pupil" DOUBLE,
  "total_expenditures" DOUBLE,
  "total_pupil_ftes" DOUBLE,
  "average_expenditures_per_pupil" DOUBLE,
  "n__in_cohort" DOUBLE,
  "n__graduated" DOUBLE,
  "n__still_in_school" DOUBLE,
  "n__non_grad_completers" DOUBLE,
  "n__ged" DOUBLE,
  "n__dropped_out" DOUBLE,
  "n__permanently_excluded" DOUBLE,
  "high_school_graduates" DOUBLE,
  "attending_coll_univ" DOUBLE,
  "n__attending_college" DOUBLE,
  "n__private_two_year" DOUBLE,
  "n__private_four_year" DOUBLE,
  "n__public_two_year" DOUBLE,
  "n__public_four_year" DOUBLE,
  "n__ma_community_college" DOUBLE,
  "n__ma_state_university" DOUBLE,
  "n__umass" DOUBLE,
  "ap_test_takers" DOUBLE,
  "ap_tests_taken" DOUBLE,
  "ap_one_test" DOUBLE,
  "ap_two_tests" DOUBLE,
  "ap_three_tests" DOUBLE,
  "ap_four_tests" DOUBLE,
  "ap_five_or_more_tests" DOUBLE,
  "ap_score_1" DOUBLE,
  "ap_score_2" DOUBLE,
  "ap_score_3" DOUBLE,
  "ap_score_4" DOUBLE,
  "ap_score_5" DOUBLE,
  "n__ap_score_1_2" DOUBLE,
  "n__ap_score_3_5" DOUBLE,
  "sat_tests_taken" DOUBLE,
  "average_sat_reading" DOUBLE,
  "average_sat_writing" DOUBLE,
  "average_sat_math" DOUBLE,
  "mcas_3rdgrade_math_p_a" DOUBLE,
  "n__mcas_3rdgrade_math_p_a" DOUBLE,
  "mcas_3rdgrade_math_a" DOUBLE
);

Ma Public Schools Datadict

@kaggle.ndalziel_massachusetts_public_schools_data.ma_public_schools_datadict

8.12 KB
302 rows
4 columns


CREATE TABLE ma_public_schools_datadict (
  "field" VARCHAR,
  "ma_doe_report" VARCHAR,
  "original_field_name" VARCHAR,
  "year" VARCHAR
);