Name: NCES US Education Data
Creator: Kaggle
License: https://www.usa.gov/government-works

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

49.34 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] 2016-17,
  "total_revenues_tr_per_pupil_membr_state_finance_2015_16" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2015-16,
  "total_revenues_tr_per_pupil_membr_state_finance_2014_15" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2014-15,
  "total_revenues_tr_per_pupil_membr_state_finance_2013_14" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2013-14,
  "total_revenues_tr_per_pupil_membr_state_finance_2012_13" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2012-13,
  "total_revenues_tr_per_pupil_membr_state_finance_2011_12" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2011-12,
  "total_revenues_tr_per_pupil_membr_state_finance_2010_11" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2010-11,
  "total_revenues_tr_per_pupil_membr_state_finance_2009_10" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2009-10,
  "total_revenues_tr_per_pupil_membr_state_finance_2008_09" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2008-09,
  "total_revenues_tr_per_pupil_membr_state_finance_2007_08" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2007-08,
  "total_revenues_tr_per_pupil_membr_state_finance_2006_07" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2006-07,
  "total_revenues_tr_per_pupil_membr_state_finance_2005_06" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2005-06,
  "total_revenues_tr_per_pupil_membr_state_finance_2004_05" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2004-05,
  "total_revenues_tr_per_pupil_membr_state_finance_2003_04" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2003-04,
  "total_revenues_tr_per_pupil_membr_state_finance_2002_03" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2002-03,
  "total_revenues_tr_per_pupil_membr_state_finance_2001_02" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2001-02,
  "total_revenues_tr_per_pupil_membr_state_finance_2000_01" BIGINT  -- Total Revenues (TR) Per Pupil (MEMBR) [State Finance] 2000-01,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_cb67d31e" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2016-17,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_52c48e22" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2015-16,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_c759df7b" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2014-15,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_9c106e7b" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2013-14,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_df2ad92a" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2012-13,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_725b6727" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2011-12,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_06e47233" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2010-11,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_d9d156fe" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2009-10,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_ac150c13" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2008-09,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_b3e5080e" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2007-08,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_fa4d5be7" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2006-07,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_426c0673" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2005-06,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_cc0a7175" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2004-05,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_32dd6587" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2003-04,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_da7b99ee" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2002-03,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_605e9af8" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2001-02,
  "total_expenditures_te11_e4d_e7a1_per_pupil_membr_state_adf708be" BIGINT  -- Total Expenditures (TE11+E4D+E7A1) Per Pupil (MEMBR) [State Finance] 2000-01
);

Elsi Export Fte

@kaggle.georgetryfiates_national_center_for_education_statistics.elsi_export_fte

52.63 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] 2018-19,
  "full_time_equivalent_fte_teachers_state_2017_18" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2017-18,
  "full_time_equivalent_fte_teachers_state_2016_17" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2016-17,
  "full_time_equivalent_fte_teachers_state_2015_16" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2015-16,
  "full_time_equivalent_fte_teachers_state_2014_15" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2014-15,
  "full_time_equivalent_fte_teachers_state_2013_14" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2013-14,
  "full_time_equivalent_fte_teachers_state_2012_13" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2012-13,
  "full_time_equivalent_fte_teachers_state_2011_12" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2011-12,
  "full_time_equivalent_fte_teachers_state_2010_11" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2010-11,
  "full_time_equivalent_fte_teachers_state_2009_10" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2009-10,
  "full_time_equivalent_fte_teachers_state_2008_09" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2008-09,
  "full_time_equivalent_fte_teachers_state_2007_08" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2007-08,
  "full_time_equivalent_fte_teachers_state_2006_07" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2006-07,
  "full_time_equivalent_fte_teachers_state_2005_06" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2005-06,
  "full_time_equivalent_fte_teachers_state_2004_05" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2004-05,
  "full_time_equivalent_fte_teachers_state_2003_04" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2003-04,
  "full_time_equivalent_fte_teachers_state_2002_03" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2002-03,
  "full_time_equivalent_fte_teachers_state_2001_02" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2001-02,
  "full_time_equivalent_fte_teachers_state_2000_01" DOUBLE  -- Full-Time Equivalent (FTE) Teachers [State] 2000-01,
  "grades_9_12_students_state_2018_19" DOUBLE  -- Grades 9-12 Students [State] 2018-19,
  "grades_9_12_students_state_2017_18" DOUBLE  -- Grades 9-12 Students [State] 2017-18,
  "grades_9_12_students_state_2016_17" DOUBLE  -- Grades 9-12 Students [State] 2016-17,
  "grades_9_12_students_state_2015_16" DOUBLE  -- Grades 9-12 Students [State] 2015-16,
  "grades_9_12_students_state_2014_15" DOUBLE  -- Grades 9-12 Students [State] 2014-15,
  "grades_9_12_students_state_2013_14" DOUBLE  -- Grades 9-12 Students [State] 2013-14,
  "grades_9_12_students_state_2012_13" DOUBLE  -- Grades 9-12 Students [State] 2012-13,
  "grades_9_12_students_state_2011_12" DOUBLE  -- Grades 9-12 Students [State] 2011-12,
  "grades_9_12_students_state_2010_11" DOUBLE  -- Grades 9-12 Students [State] 2010-11,
  "grades_9_12_students_state_2009_10" DOUBLE  -- Grades 9-12 Students [State] 2009-10,
  "grades_9_12_students_state_2008_09" DOUBLE  -- Grades 9-12 Students [State] 2008-09,
  "grades_9_12_students_state_2007_08" DOUBLE  -- Grades 9-12 Students [State] 2007-08,
  "grades_9_12_students_state_2006_07" DOUBLE  -- Grades 9-12 Students [State] 2006-07,
  "grades_9_12_students_state_2005_06" DOUBLE  -- Grades 9-12 Students [State] 2005-06,
  "grades_9_12_students_state_2004_05" DOUBLE  -- Grades 9-12 Students [State] 2004-05,
  "grades_9_12_students_state_2003_04" DOUBLE  -- Grades 9-12 Students [State] 2003-04,
  "grades_9_12_students_state_2002_03" DOUBLE  -- Grades 9-12 Students [State] 2002-03,
  "grades_9_12_students_state_2001_02" DOUBLE  -- Grades 9-12 Students [State] 2001-02,
  "grades_9_12_students_state_2000_01" DOUBLE  -- Grades 9-12 Students [State] 2000-01
);

Finances 2001–2017

@kaggle.georgetryfiates_national_center_for_education_statistics.finances_2001_2017

12.96 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

26.22 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
);