Data source: Big Local News · About: Big Local

36,585 rows where state = "SC" sorted by ccd_school_type descending

View and edit SQL

grade

year

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
247349 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2020   grade_11                                                   4.0                                             4
247350 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401228 5207009 SC School For Deaf Elem/Middle   Special Education School No Elementary PK 08 2020   grade_11                                                   0.0                                             0
247351 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401246 5207010 SC School For Blind Elem/Middle   Special Education School No Elementary PK 08 2020   grade_11                                                   0.0                                             0
247352 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2020   grade_11                                                   5.0                                             5
247934 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_12                                                   10.0                                             10
248303 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_12                                                   53.0                                             53
248541 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_12                                                   0.0                                             0
248567 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2020   grade_12                                                   5.0                                             5
248568 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2020   grade_12                                                   7.0                                             7
248569 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401228 5207009 SC School For Deaf Elem/Middle   Special Education School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
248570 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401246 5207010 SC School For Blind Elem/Middle   Special Education School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
248571 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2020   grade_12                                                   25.0                                             25
249153 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   pk_12_total 65.0 38.0 24.0 0.0   5.0     0.0   1.0 0.0 85.0 48.0   0.0         125.0         133.0 65 38 24 0   5     0   1 0 85 48   0     125       133
249522 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   pk_12_total 9.0 62.0 5.0 0.0   0.0     0.0   2.0 0.0 51.0 27.0   0.0         70.0         78.0 9 62 5 0   0     0   2 0 51 27   0     70       78
249760 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   pk_12_total 50.0 8.0 10.0 0.0   0.0     0.0   3.0 0.0 40.0 31.0   0.0         64.0         71.0 50 8 10 0   0     0   3 0 40 31   0     64       71
249786 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2020   pk_12_total 14.0 8.0 3.0 0.0   1.0     0.0   0.0 0.0 14.0 12.0   0.0         18.0         26.0 14 8 3 0   1     0   0 0 14 12   0     18       26
249787 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2020   pk_12_total 9.0 8.0 2.0 0.0   2.0     0.0   3.0 0.0 7.0 17.0   0.0         18.0         24.0 9 8 2 0   2     0   3 0 7 17   0     18       24
249788 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401228 5207009 SC School For Deaf Elem/Middle   Special Education School No Elementary PK 08 2020   pk_12_total 15.0 21.0 5.0 0.0   5.0     0.0   1.0 0.0 27.0 20.0   0.0         34.0         47.0 15 21 5 0   5     0   1 0 27 20   0     34       47
249789 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401246 5207010 SC School For Blind Elem/Middle   Special Education School No Elementary PK 08 2020   pk_12_total 13.0 14.0 3.0 0.0   1.0     0.0   0.0 0.0 15.0 16.0   0.0         24.0         31.0 13 14 3 0   1     0   0 0 15 16   0     24       31
249790 SC     school 4500004 5207   SC School for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2020   pk_12_total 29.0 29.0 13.0 0.0   1.0     0.0   1.0 0.0 37.0 36.0   0.0         61.0         73.0 29 29 13 0   1     0   1 0 37 36   0     61       73
368360 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   pre_kindergarten                                                   6.0                                             6
368730 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   pre_kindergarten                                                   6.0                                             6
368966 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   pre_kindergarten                                                   37.0                                             37
368999 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   pre_kindergarten                                                   0.0                                             0
369000 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   pre_kindergarten                                                   0.0                                             0
369001 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   pre_kindergarten                                                   3.0                                             3
369002 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   pre_kindergarten                                                   2.0                                             2
369003 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   pre_kindergarten                                                   4.0                                             4
369580 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   kindergarten                                                   5.0                                             5
369950 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   kindergarten                                                   0.0                                             0
370186 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   kindergarten                                                   21.0                                             21
370219 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   kindergarten                                                   0.0                                             0
370220 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   kindergarten                                                   0.0                                             0
370221 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   kindergarten                                                   1.0                                             1
370222 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   kindergarten                                                   1.0                                             1
370223 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   kindergarten                                                   4.0                                             4
370800 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   grade_1                                                   7.0                                             7
371170 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   grade_1                                                   0.0                                             0
371406 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   grade_1                                                   11.0                                             11
371439 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   grade_1                                                   0.0                                             0
371440 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   grade_1                                                   0.0                                             0
371441 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   grade_1                                                   1.0                                             1
371442 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   grade_1                                                   4.0                                             4
371443 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   grade_1                                                   0.0                                             0
372020 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   grade_2                                                   10.0                                             10
372390 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   grade_2                                                   0.0                                             0
372626 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   grade_2                                                   11.0                                             11
372659 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   grade_2                                                   0.0                                             0
372660 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   grade_2                                                   0.0                                             0
372661 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   grade_2                                                   2.0                                             2
372662 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   grade_2                                                   1.0                                             1
372663 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   grade_2                                                   4.0                                             4
373240 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   grade_3                                                   3.0                                             3
373610 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   grade_3                                                   0.0                                             0
373846 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   grade_3                                                   0.0                                             0
373879 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   grade_3                                                   0.0                                             0
373880 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   grade_3                                                   0.0                                             0
373881 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   grade_3                                                   2.0                                             2
373882 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   grade_3                                                   1.0                                             1
373883 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   grade_3                                                   2.0                                             2
374460 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   grade_4                                                   3.0                                             3
374830 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   grade_4                                                   0.0                                             0
375066 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   grade_4                                                   0.0                                             0
375099 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   grade_4                                                   0.0                                             0
375100 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   grade_4                                                   0.0                                             0
375101 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   grade_4                                                   9.0                                             9
375102 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   grade_4                                                   1.0                                             1
375103 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   grade_4                                                   0.0                                             0
375680 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   grade_5                                                   8.0                                             8
376050 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   grade_5                                                   0.0                                             0
376286 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   grade_5                                                   0.0                                             0
376319 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   grade_5                                                   0.0                                             0
376320 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   grade_5                                                   0.0                                             0
376321 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   grade_5                                                   4.0                                             4
376322 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   grade_5                                                   2.0                                             2
376323 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   grade_5                                                   8.0                                             8
376900 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   grade_6                                                   4.0                                             4
377270 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   grade_6                                                   0.0                                             0
377506 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   grade_6                                                   0.0                                             0
377539 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   grade_6                                                   0.0                                             0
377540 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   grade_6                                                   0.0                                             0
377541 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   grade_6                                                   4.0                                             4
377542 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   grade_6                                                   5.0                                             5
377543 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   grade_6                                                   2.0                                             2
378120 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   grade_7                                                   3.0                                             3
378490 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   grade_7                                                   2.0                                             2
378726 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   grade_7                                                   0.0                                             0
378759 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   grade_7                                                   0.0                                             0
378760 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   grade_7                                                   0.0                                             0
378761 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   grade_7                                                   6.0                                             6
378762 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   grade_7                                                   5.0                                             5
378763 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   grade_7                                                   2.0                                             2
379340 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2021   grade_8                                                   10.0                                             10
379710 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2021   grade_8                                                   3.0                                             3
379946 SC     school 4503901 4701   SC Public Charter School 450390101689 4701049 Meyers Center for SpecialChildren   Special Education School Yes Elementary PK 02 2021   grade_8                                                   0.0                                             0
379979 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401226 5207005 SC School For Blind High   Special Education School No High 09 12 2021   grade_8                                                   0.0                                             0
379980 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401227 5207007 SC School For Deaf High   Special Education School No High 09 12 2021   grade_8                                                   0.0                                             0
379981 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401228 5207009 SC School For DeafElem/Middle   Special Education School No Elementary PK 08 2021   grade_8                                                   6.0                                             6
379982 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401246 5207010 SC School For BlindElem/Middle   Special Education School No Elementary PK 08 2021   grade_8                                                   3.0                                             3
379983 SC     school 4500004 5207   SC Schools for the Deaf and the Blind 450000401402 5207011 Cedar Springs Academy   Special Education School No Other PK 12 2021   grade_8                                                   2.0                                             2

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