Dataset: NCES US Education Data

About this Dataset

NCES US Education Data

I downloaded this data from the ElSi (Elementary/Secondary Information System) tableGenerator hosted by the Institute of Educational Sciences' National Center for Education Statistics.
ELSI tableGenerator

The cleaned, analysis-ready files are "finances_2001_2017.csv" and "pupils_fte_teachers_2001_2019.csv".

I am going to add graduation rate data. This is for an undergrad project on marijuana legalization and high school graduation rates.

Variable Definitions:
"Total Expenditures (TE11+E4D+E7A1) per Pupil (MEMBR) [State Finance] This is the Total Expenditures (Digest) divided by the fall membership as reported in the state finance file. The Total Expenditures (Digest) is the subtotal of Direct State Support Expenditures for Private Schools (e4d), Debt Services Expenditures - Interest (e7a1) and Total Expenditures for Education (te11). These data are from the CCD National Public Education Financial Survey."

"Total revenues per student are the total revenues from all sources (tr) divided by the fall membership as reported in the state finance file. These data are from the CCD National Public Education Financial Survey."

"Full-Time Equivalent (FTE) Teachers [State] This is the total number of full-time equivalent teachers in a state as defined by the CCD State Nonfiscal Survey."

"Grades 9-12 Students [State] This is the number of students in a state who are enrolled in ninth grade through twelfth grade. These data are taken from the CCD State Nonfiscal survey."

Wallpaper by NeONBRAND on Unsplash

Tables

Elsi Export Finance

@kaggle.georgetryfiates_national_center_for_education_statistics.elsi_export_finance

48.18 KB
51 rows
35 columns


CREATE TABLE elsi_export_finance (
  "state_name" VARCHAR,
  "total_revenues_tr_per_pupil_membr_state_finance_2016_17" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2015_16" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2014_15" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2013_14" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2012_13" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2011_12" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2010_11" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2009_10" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2008_09" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2007_08" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2006_07" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2005_06" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2004_05" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2003_04" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2002_03" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2001_02" BIGINT,
  "total_revenues_tr_per_pupil_membr_state_finance_2000_01" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_cb67d31e" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_52c48e22" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_c759df7b" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_9c106e7b" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_df2ad92a" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_725b6727" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_06e47233" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_d9d156fe" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_ac150c13" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_b3e5080e" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_fa4d5be7" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_426c0673" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_cc0a7175" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_32dd6587" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_da7b99ee" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_605e9af8" BIGINT,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_adf708be" BIGINT
);

Elsi Export Fte

@kaggle.georgetryfiates_national_center_for_education_statistics.elsi_export_fte

51.4 KB
58 rows
39 columns


CREATE TABLE elsi_export_fte (
  "state_name" VARCHAR,
  "full_time_equivalent_fte_teachers_state_2018_19" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2017_18" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2016_17" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2015_16" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2014_15" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2013_14" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2012_13" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2011_12" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2010_11" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2009_10" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2008_09" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2007_08" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2006_07" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2005_06" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2004_05" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2003_04" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2002_03" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2001_02" DOUBLE,
  "full_time_equivalent_fte_teachers_state_2000_01" DOUBLE,
  "grades_9_12_students_state_2018_19" DOUBLE,
  "grades_9_12_students_state_2017_18" DOUBLE,
  "grades_9_12_students_state_2016_17" DOUBLE,
  "grades_9_12_students_state_2015_16" DOUBLE,
  "grades_9_12_students_state_2014_15" DOUBLE,
  "grades_9_12_students_state_2013_14" DOUBLE,
  "grades_9_12_students_state_2012_13" DOUBLE,
  "grades_9_12_students_state_2011_12" DOUBLE,
  "grades_9_12_students_state_2010_11" DOUBLE,
  "grades_9_12_students_state_2009_10" DOUBLE,
  "grades_9_12_students_state_2008_09" DOUBLE,
  "grades_9_12_students_state_2007_08" DOUBLE,
  "grades_9_12_students_state_2006_07" DOUBLE,
  "grades_9_12_students_state_2005_06" DOUBLE,
  "grades_9_12_students_state_2004_05" DOUBLE,
  "grades_9_12_students_state_2003_04" DOUBLE,
  "grades_9_12_students_state_2002_03" DOUBLE,
  "grades_9_12_students_state_2001_02" DOUBLE,
  "grades_9_12_students_state_2000_01" DOUBLE
);

Finances 2001–2017

@kaggle.georgetryfiates_national_center_for_education_statistics.finances_2001_2017

12.66 KB
867 rows
4 columns


CREATE TABLE finances_2001_2017 (
  "state" VARCHAR,
  "year" BIGINT,
  "tr_per_pupil" BIGINT,
  "te_per_pupil" BIGINT
);

Pupils Fte Teachers 2001–2019

@kaggle.georgetryfiates_national_center_for_education_statistics.pupils_fte_teachers_2001_2019

25.61 KB
969 rows
5 columns


CREATE TABLE pupils_fte_teachers_2001_2019 (
  "state" VARCHAR,
  "year" BIGINT,
  "fte_teachers" DOUBLE,
  "pupils" BIGINT,
  "pupil_per_fte_teacher" DOUBLE
);