Data source: Big Local News · About: Big Local

8,415 rows where state = "NH" and year = 2021 sorted by ccd_school_lvl descending

View and edit SQL

year

  • 2021 · 8,415
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ▲ ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
349857 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_1                                                   0                                             0
349858 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_10                                                   7                                             7
349859 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_11                                                   0                                             0
349860 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_12                                                   0                                             0
349861 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_2                                                   0                                             0
349862 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_3                                                   0                                             0
349863 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_4                                                   0                                             0
349864 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_5                                                   0                                             0
349865 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_6                                                   0                                             0
349866 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_7                                                   0                                             0
349867 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_8                                                   0                                             0
349868 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_9                                                   5                                             5
349869 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   kindergarten                                                   0                                             0
349870 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   pk_12_total                                                   12                                             12
349871 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   post_graduate                                                   0                                             0
349872 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   pre_kindergarten                                                   0                                             0
349873 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   readiness                                                   0                                             0
353036 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_1                                                   0                                             0
353037 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_10                                                   11                                             11
353038 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_11                                                   6                                             6
353039 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_12                                                   0                                             0
353040 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_2                                                   0                                             0
353041 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_3                                                   0                                             0
353042 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_4                                                   0                                             0
353043 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_5                                                   0                                             0
353044 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_6                                                   0                                             0
353045 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_7                                                   0                                             0
353046 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_8                                                   0                                             0
353047 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   grade_9                                                   19                                             19
353048 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   kindergarten                                                   0                                             0
353049 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   pk_12_total                                                   36                                             36
353050 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   post_graduate                                                   0                                             0
353051 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   pre_kindergarten                                                   0                                             0
353052 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   readiness                                                   0                                             0
355892 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_1                                                   0                                             0
355893 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_10                                                   22                                             22
355894 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_11                                                   0                                             0
355895 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_12                                                   0                                             0
355896 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_2                                                   0                                             0
355897 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_3                                                   0                                             0
355898 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_4                                                   0                                             0
355899 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_5                                                   0                                             0
355900 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_6                                                   0                                             0
355901 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_7                                                   0                                             0
355902 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_8                                                   0                                             0
355903 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_9                                                   12                                             12
355904 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   kindergarten                                                   0                                             0
355905 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   pk_12_total                                                   34                                             34
355906 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   post_graduate                                                   0                                             0
355907 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   pre_kindergarten                                                   0                                             0
355908 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   readiness                                                   0                                             0
349738 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_1                                                   0                                             0
349739 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
349740 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
349741 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
349742 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_2                                                   0                                             0
349743 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_3                                                   0                                             0
349744 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
349745 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_5                                                   0                                             0
349746 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_6                                                   0                                             0
349747 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
349748 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
349749 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
349750 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
349751 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   51                                             51
349752 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   post_graduate                                                   0                                             0
349753 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   51                                             51
349754 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   readiness                                                   0                                             0
350129 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_1                                                   0                                             0
350130 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
350131 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
350132 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
350133 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_2                                                   0                                             0
350134 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_3                                                   0                                             0
350135 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
350136 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_5                                                   0                                             0
350137 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_6                                                   0                                             0
350138 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
350139 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
350140 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
350141 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
350142 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   74                                             74
350143 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   post_graduate                                                   0                                             0
350144 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   74                                             74
350145 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   readiness                                                   0                                             0
350639 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_1                                                   0                                             0
350640 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
350641 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
350642 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
350643 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_2                                                   0                                             0
350644 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_3                                                   0                                             0
350645 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
350646 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_5                                                   0                                             0
350647 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_6                                                   0                                             0
350648 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
350649 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
350650 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
350651 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
350652 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   9                                             9
350653 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   post_graduate                                                   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);