enrollments

Data source: Big Local News · About: Big Local

4,267 rows where grade = "sped_beyond_grade_12" and state = "MA" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • sped_beyond_grade_12 · 4,267 ✖
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
932550 932550 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 3                       5                         2 3                 5
1121948 1121948 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121953 1121953 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121956 1121956 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121959 1121959 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121964 1121964 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1364798 1364798 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 0 1 0   0     0   0   3 3 *                     6.0 5 0 1 0   0     0   0   3 3                 6
1672022 1672022 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 0 1 0   1     0   0   5 3 *                     8.0 6 0 1 0   1     0   0   5 3                 8
2039824 2039824 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2228755 2228755 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228758 2228758 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228762 2228762 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228767 2228767 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228772 2228772 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
1122130 1122130 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122137 1122137 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122144 1122144 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122151 1122151 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122153 1122153 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122160 1122160 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122167 1122167 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122174 1122174 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122178 1122178 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122183 1122183 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2228936 2228936 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228943 2228943 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228950 2228950 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228957 2228957 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228959 2228959 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228966 2228966 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228973 2228973 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228980 2228980 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228984 2228984 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228989 2228989 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1124959 1124959 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124963 1124963 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124970 1124970 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124977 1124977 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124984 1124984 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124991 1124991 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124998 1124998 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125005 1125005 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125012 1125012 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125019 1125019 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125023 1125023 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125027 1125027 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125031 1125031 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125036 1125036 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2231787 2231787 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Framingham: Juniper Hill School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231792 2231792 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham: King Elementary School   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231799 2231799 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham: Brophy   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231806 2231806 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham: Charlotte A Dunning   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231813 2231813 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham: Hemenway   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231820 2231820 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231827 2231827 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham: Potter Road   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231834 2231834 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham: Mary E Stapleton Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231841 2231841 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham: Miriam F McCarthy School   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231848 2231848 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham: Woodrow Wilson   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231852 2231852 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham: Cameron Middle School   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231856 2231856 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231860 2231860 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231865 2231865 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham: Framingham High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
935204 935204 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   sped_beyond_grade_12 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
1125038 1125038 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125045 1125045 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125052 1125052 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125059 1125059 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125066 1125066 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125073 1125073 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125080 1125080 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125084 1125084 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125088 1125088 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125092 1125092 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125097 1125097 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1367442 1367442 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   sped_beyond_grade_12 4 0 1 1   0     0   1   1 6 *                     7.0 4 0 1 1   0     0   1   1 6                 7
1674676 1674676 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   sped_beyond_grade_12 3 0 1 1   0     0   1   3 3 *                     6.0 3 0 1 1   0     0   1   3 3                 6
2042513 2042513 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2231867 2231867 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231874 2231874 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231881 2231881 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin: Helen Keller Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231888 2231888 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231895 2231895 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231902 2231902 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin: Parmenter   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231909 2231909 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231913 2231913 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231917 2231917 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231921 2231921 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin: Horace Mann   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231926 2231926 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   sped_beyond_grade_12 8 0 0 0   0     0   0                             8.0 8 0 0 0   0     0   0                       8
935219 935219 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   sped_beyond_grade_12 * * * *   *     *   *   4 1                       5                         4 1                 5
1125101 1125101 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125105 1125105 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125109 1125109 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125115 1125115 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125120 1125120 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1674691 1674691 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner - Gardner High   Regular School No High 08 12 2021   sped_beyond_grade_12 5 1 3 0   0     0   0   7 2 *                     9.0 5 1 3 0   0     0   0   7 2                 9
2042528 2042528 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   sped_beyond_grade_12 6 0 1 0   0     0   0                             7.0 6 0 1 0   0     0   0                       7
2231930 2231930 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231934 2231934 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner: Waterford Street   Regular School No Elementary PK 01 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231938 2231938 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231944 2231944 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5

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