Name: Massachusetts Public Schools Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

725.81 kB
1,861 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  -- 1 Enrollment,
  "n_2_enrollment" BIGINT  -- 2 Enrollment,
  "n_3_enrollment" BIGINT  -- 3 Enrollment,
  "n_4_enrollment" BIGINT  -- 4 Enrollment,
  "n_5_enrollment" BIGINT  -- 5 Enrollment,
  "n_6_enrollment" BIGINT  -- 6 Enrollment,
  "n_7_enrollment" BIGINT  -- 7 Enrollment,
  "n_8_enrollment" BIGINT  -- 8 Enrollment,
  "n_9_enrollment" BIGINT  -- 9 Enrollment,
  "n_10_enrollment" BIGINT  -- 10 Enrollment,
  "n_11_enrollment" BIGINT  -- 11 Enrollment,
  "n_12_enrollment" BIGINT  -- 12 Enrollment,
  "sp_enrollment" BIGINT,
  "total_enrollment" BIGINT,
  "first_language_not_english" DOUBLE,
  "n__first_language_not_english" DOUBLE  -- % First Language Not English,
  "english_language_learner" DOUBLE,
  "n__english_language_learner" DOUBLE  -- % English Language Learner,
  "students_with_disabilities" DOUBLE,
  "n__students_with_disabilities" DOUBLE  -- % Students With Disabilities,
  "high_needs" DOUBLE,
  "n__high_needs" DOUBLE  -- % High Needs,
  "economically_disadvantaged" DOUBLE,
  "n__economically_disadvantaged" DOUBLE  -- % Economically Disadvantaged,
  "n__african_american" DOUBLE  -- % African American,
  "n__asian" DOUBLE  -- % Asian,
  "n__hispanic" DOUBLE  -- % Hispanic,
  "n__white" DOUBLE  -- % White,
  "n__native_american" DOUBLE  -- % Native American,
  "n__native_hawaiian_pacific_islander" DOUBLE  -- % Native Hawaiian, Pacific Islander,
  "n__multi_race_non_hispanic" DOUBLE  -- % Multi-Race, Non-Hispanic,
  "n__males" DOUBLE  -- % Males,
  "n__females" DOUBLE  -- % Females,
  "total_of_classes" DOUBLE  -- Total # Of Classes,
  "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  -- # In Cohort,
  "n__graduated" DOUBLE  -- % Graduated,
  "n__still_in_school" DOUBLE  -- % Still In School,
  "n__non_grad_completers" DOUBLE  -- % Non-Grad Completers,
  "n__ged" DOUBLE  -- % GED,
  "n__dropped_out" DOUBLE  -- % Dropped Out,
  "n__permanently_excluded" DOUBLE  -- % Permanently Excluded,
  "high_school_graduates" DOUBLE  -- High School Graduates (#),
  "attending_coll_univ" DOUBLE  -- Attending Coll./Univ. (#),
  "n__attending_college" DOUBLE  -- % Attending College,
  "n__private_two_year" DOUBLE  -- % Private Two-Year,
  "n__private_four_year" DOUBLE  -- % Private Four-Year,
  "n__public_two_year" DOUBLE  -- % Public Two-Year,
  "n__public_four_year" DOUBLE  -- % Public Four-Year,
  "n__ma_community_college" DOUBLE  -- % MA Community College,
  "n__ma_state_university" DOUBLE  -- % MA State University,
  "n__umass" DOUBLE  -- % UMass,
  "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\u003d1,
  "ap_score_2" DOUBLE  -- AP Score\u003d2,
  "ap_score_3" DOUBLE  -- AP Score\u003d3,
  "ap_score_4" DOUBLE  -- AP Score\u003d4,
  "ap_score_5" DOUBLE  -- AP Score\u003d5,
  "n__ap_score_1_2" DOUBLE  -- % AP Score 1-2,
  "n__ap_score_3_5" DOUBLE  -- % AP Score 3-5,
  "sat_tests_taken" DOUBLE,
  "average_sat_reading" DOUBLE,
  "average_sat_writing" DOUBLE,
  "average_sat_math" DOUBLE,
  "mcas_3rdgrade_math_p_a" DOUBLE  -- MCAS 3rdGrade Math P+A #,
  "n__mcas_3rdgrade_math_p_a" DOUBLE  -- % MCAS 3rdGrade Math P+A,
  "mcas_3rdgrade_math_a" DOUBLE  -- MCAS 3rdGrade Math A #
);

Ma Public Schools Datadict

@kaggle.ndalziel_massachusetts_public_schools_data.ma_public_schools_datadict

8.32 kB
302 rows
4 columns

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