enrollments
Data source: Big Local News · About: Big Local
9,565 rows where state = "MA" and year = 2019 sorted by male descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2040139 | 2040139 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000128 | 230505 | Bedford High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 121 | 11 | 22 | 0 | 22 | 0 | 12 | 99 | 89 | 188.0 | 121 | 11 | 22 | 0 | 22 | 0 | 12 | 99 | 89 | 188 | |||||||||||||||||||||||||||||||||
2040914 | 2040914 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002013 | 350383 | Lilla G. Frederick Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 0 | 74 | 72 | 0 | 16 | 1 | 4 | 99 | 68 | 167.0 | 0 | 74 | 72 | 0 | 16 | 1 | 4 | 99 | 68 | 167 | |||||||||||||||||||||||||||||||||
2041003 | 2041003 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000204 | 350545 | Boston Latin Academy | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 98 | 65 | 73 | 0 | 41 | 0 | 6 | 99 | 184 | 283.0 | 98 | 65 | 73 | 0 | 41 | 0 | 6 | 99 | 184 | 283 | |||||||||||||||||||||||||||||||||
2042045 | 2042045 | MA | Hampden | school | 2504500 | 87 | East Longmeadow | 250450000605 | 870013 | Meadow Brook | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 153 | 1 | 26 | 0 | 5 | 0 | 7 | 99 | 93 | 192.0 | 153 | 1 | 26 | 0 | 5 | 0 | 7 | 99 | 93 | 192 | |||||||||||||||||||||||||||||||||
2042046 | 2042046 | MA | Hampden | school | 2504500 | 87 | East Longmeadow | 250450000605 | 870013 | Meadow Brook | Regular School | No | Elementary | PK | 02 | 2019 | grade_2 | 140 | 1 | 16 | 0 | 11 | 0 | 9 | 99 | 78 | 177.0 | 140 | 1 | 16 | 0 | 11 | 0 | 9 | 99 | 78 | 177 | |||||||||||||||||||||||||||||||||
2043471 | 2043471 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001036 | 1600315 | James S Daley Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 42 | 7 | 35 | 0 | 80 | 0 | 7 | 99 | 72 | 171.0 | 42 | 7 | 35 | 0 | 80 | 0 | 7 | 99 | 72 | 171 | |||||||||||||||||||||||||||||||||
2043905 | 2043905 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001156 | 1750305 | Thomas Blake Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 156 | 1 | 13 | 0 | 7 | 0 | 9 | 99 | 87 | 186.0 | 156 | 1 | 13 | 0 | 7 | 0 | 9 | 99 | 87 | 186 | |||||||||||||||||||||||||||||||||
2044793 | 2044793 | MA | Bristol | school | 2509000 | 218 | Norton | 250900001209 | 2180060 | Henri A. Yelle | Regular School | No | Elementary | 04 | 05 | 2019 | grade_5 | 173 | 6 | 3 | 0 | 7 | 0 | 11 | 99 | 101 | 200.0 | 173 | 6 | 3 | 0 | 7 | 0 | 11 | 99 | 101 | 200 | |||||||||||||||||||||||||||||||||
2044794 | 2044794 | MA | Bristol | school | 2509000 | 218 | Norton | 250900001452 | 2180305 | Norton Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 179 | 3 | 7 | 0 | 3 | 0 | 11 | 99 | 104 | 203.0 | 179 | 3 | 7 | 0 | 3 | 0 | 11 | 99 | 104 | 203 | |||||||||||||||||||||||||||||||||
2045594 | 2045594 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Gates Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 206 | 3 | 3 | 0 | 3 | 0 | 2 | 99 | 118 | 217.0 | 206 | 3 | 3 | 0 | 3 | 0 | 2 | 99 | 118 | 217 | |||||||||||||||||||||||||||||||||
2045664 | 2045664 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Floral Street School | Regular School | No | Elementary | 01 | 04 | 2019 | grade_4 | 72 | 6 | 11 | 2 | 96 | 0 | 10 | 99 | 98 | 197.0 | 72 | 6 | 11 | 2 | 96 | 0 | 10 | 99 | 98 | 197 | |||||||||||||||||||||||||||||||||
2046834 | 2046834 | MA | Hampden | school | 2512630 | 325 | Westfield | 251263002074 | 3250605 | Westfield Technical Academy | Career and Technical School | No | High | 09 | 12 | 2019 | grade_9 | 123 | 1 | 18 | 0 | 2 | 0 | 0 | 99 | 45 | 144.0 | 123 | 1 | 18 | 0 | 2 | 0 | 0 | 99 | 45 | 144 | |||||||||||||||||||||||||||||||||
2046893 | 2046893 | MA | Middlesex | school | 2512750 | 330 | Weston | 251275002087 | 3300505 | Weston High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 114 | 12 | 5 | 1 | 37 | 0 | 4 | 99 | 74 | 173.0 | 114 | 12 | 5 | 1 | 37 | 0 | 4 | 99 | 74 | 173 | |||||||||||||||||||||||||||||||||
2048137 | 2048137 | MA | Worcester | school | 2502040 | 610 | Ashburnham-Westminster | 250204000831 | 6100305 | Overlook Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 176 | 1 | 6 | 0 | 1 | 0 | 5 | 99 | 90 | 189.0 | 176 | 1 | 6 | 0 | 1 | 0 | 5 | 99 | 90 | 189 | |||||||||||||||||||||||||||||||||
2048347 | 2048347 | MA | Norfolk | school | 2504290 | 655 | Dover-Sherborn | 250429000575 | 6550405 | Dover-Sherborn Regional Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 131 | 8 | 6 | 0 | 21 | 0 | 6 | 99 | 73 | 172.0 | 131 | 8 | 6 | 0 | 21 | 0 | 6 | 99 | 73 | 172 | |||||||||||||||||||||||||||||||||
2048819 | 2048819 | MA | Essex | school | 2509450 | 745 | Pentucket | 250945001513 | 7450505 | Pentucket Regional Sr High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 182 | 0 | 9 | 0 | 1 | 0 | 0 | 99 | 93 | 192.0 | 182 | 0 | 9 | 0 | 1 | 0 | 0 | 99 | 93 | 192 | |||||||||||||||||||||||||||||||||
2049196 | 2049196 | MA | Middlesex | school | 2511060 | 829 | South Middlesex Regional Vocational Technical | 251106002291 | 8290605 | Joseph P Keefe Technical High School | Career and Technical School | No | High | 09 | 12 | 2019 | grade_12 | 71 | 7 | 69 | 2 | 1 | 0 | 7 | 99 | 58 | 157.0 | 71 | 7 | 69 | 2 | 1 | 0 | 7 | 99 | 58 | 157 | |||||||||||||||||||||||||||||||||
2049217 | 2049217 | MA | Plymouth | school | 2509140 | 855 | Old Colony Regional Vocational Technical | 250914001471 | 8550605 | Old Colony Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2019 | grade_9 | 132 | 1 | 5 | 0 | 1 | 0 | 5 | 99 | 45 | 144.0 | 132 | 1 | 5 | 0 | 1 | 0 | 5 | 99 | 45 | 144 | |||||||||||||||||||||||||||||||||
2040019 | 2040019 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000070 | 140505 | Ashland High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 148 | 7 | 31 | 1 | 25 | 0 | 2 | 98 | 116 | 214.0 | 148 | 7 | 31 | 1 | 25 | 0 | 2 | 98 | 116 | 214 | |||||||||||||||||||||||||||||||||
2040048 | 2040048 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000096 | 160305 | Robert J. Coelho Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 120 | 9 | 24 | 0 | 6 | 0 | 10 | 98 | 71 | 169.0 | 120 | 9 | 24 | 0 | 6 | 0 | 10 | 98 | 71 | 169 | |||||||||||||||||||||||||||||||||
2040077 | 2040077 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222002567 | 170305 | Auburn Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 154 | 3 | 23 | 0 | 7 | 0 | 9 | 98 | 98 | 196.0 | 154 | 3 | 23 | 0 | 7 | 0 | 9 | 98 | 98 | 196 | |||||||||||||||||||||||||||||||||
2040135 | 2040135 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000130 | 230305 | John Glenn Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 114 | 13 | 10 | 0 | 27 | 0 | 14 | 98 | 80 | 178.0 | 114 | 13 | 10 | 0 | 27 | 0 | 14 | 98 | 80 | 178 | |||||||||||||||||||||||||||||||||
2040155 | 2040155 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000134 | 240505 | Belchertown High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 157 | 6 | 7 | 0 | 3 | 0 | 3 | 98 | 78 | 176.0 | 157 | 6 | 7 | 0 | 3 | 0 | 3 | 98 | 78 | 176 | |||||||||||||||||||||||||||||||||
2041634 | 2041634 | MA | Middlesex | school | 2503510 | 56 | Chelmsford | 250351000478 | 560310 | McCarthy Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_8 | 152 | 6 | 6 | 0 | 29 | 0 | 7 | 98 | 102 | 200.0 | 152 | 6 | 6 | 0 | 29 | 0 | 7 | 98 | 102 | 200 | |||||||||||||||||||||||||||||||||
2041916 | 2041916 | MA | Norfolk | school | 2504050 | 73 | Dedham | 250405000548 | 730505 | Dedham High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 130 | 20 | 25 | 0 | 9 | 0 | 3 | 98 | 89 | 187.0 | 130 | 20 | 25 | 0 | 9 | 0 | 3 | 98 | 89 | 187 | |||||||||||||||||||||||||||||||||
2041977 | 2041977 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432000579 | 790505 | Dracut Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 164 | 8 | 15 | 1 | 16 | 0 | 4 | 98 | 110 | 208.0 | 164 | 8 | 15 | 1 | 16 | 0 | 4 | 98 | 110 | 208 | |||||||||||||||||||||||||||||||||
2041984 | 2041984 | MA | Plymouth | school | 2504410 | 82 | Duxbury | 250441000593 | 820006 | Chandler Elementary | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 175 | 2 | 5 | 0 | 0 | 0 | 8 | 98 | 92 | 190.0 | 175 | 2 | 5 | 0 | 0 | 0 | 8 | 98 | 92 | 190 | |||||||||||||||||||||||||||||||||
2042506 | 2042506 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000738 | 1010405 | Horace Mann | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 139 | 2 | 8 | 0 | 13 | 0 | 2 | 98 | 66 | 164.0 | 139 | 2 | 8 | 0 | 13 | 0 | 2 | 98 | 66 | 164 | |||||||||||||||||||||||||||||||||
2042867 | 2042867 | MA | Middlesex | school | 2506240 | 136 | Holliston | 250624000894 | 1360505 | Holliston High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 170 | 2 | 4 | 2 | 15 | 0 | 2 | 98 | 97 | 195.0 | 170 | 2 | 4 | 2 | 15 | 0 | 2 | 98 | 97 | 195 | |||||||||||||||||||||||||||||||||
2042993 | 2042993 | MA | Middlesex | school | 2506390 | 141 | Hudson | 250639000927 | 1410410 | David J. Quinn Middle School | Regular School | No | Middle | 05 | 07 | 2019 | grade_7 | 179 | 0 | 24 | 0 | 7 | 0 | 2 | 98 | 114 | 212.0 | 179 | 0 | 24 | 0 | 7 | 0 | 2 | 98 | 114 | 212 | |||||||||||||||||||||||||||||||||
2043518 | 2043518 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705001055 | 1610305 | Paul R Baird Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 157 | 5 | 22 | 0 | 1 | 0 | 6 | 98 | 93 | 191.0 | 157 | 5 | 22 | 0 | 1 | 0 | 6 | 98 | 93 | 191 | |||||||||||||||||||||||||||||||||
2043519 | 2043519 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705001055 | 1610305 | Paul R Baird Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 184 | 2 | 16 | 2 | 2 | 0 | 2 | 98 | 110 | 208.0 | 184 | 2 | 16 | 2 | 2 | 0 | 2 | 98 | 110 | 208 | |||||||||||||||||||||||||||||||||
2043775 | 2043775 | MA | Essex | school | 2507260 | 168 | Marblehead | 250726001788 | 1680016 | Village School | Regular School | No | Middle | 04 | 06 | 2019 | grade_5 | 165 | 6 | 15 | 0 | 3 | 0 | 8 | 98 | 99 | 197.0 | 165 | 6 | 15 | 0 | 3 | 0 | 8 | 98 | 99 | 197 | |||||||||||||||||||||||||||||||||
2043904 | 2043904 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001159 | 1750007 | Ralph Wheelock School | Regular School | No | Elementary | 02 | 03 | 2019 | grade_3 | 174 | 4 | 6 | 0 | 11 | 0 | 6 | 98 | 103 | 201.0 | 174 | 4 | 6 | 0 | 11 | 0 | 6 | 98 | 103 | 201 | |||||||||||||||||||||||||||||||||
2044437 | 2044437 | MA | Essex | school | 2508580 | 204 | Newburyport | 250858001355 | 2040305 | Rupert A Nock Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 177 | 0 | 8 | 0 | 1 | 0 | 3 | 98 | 91 | 189.0 | 177 | 0 | 8 | 0 | 1 | 0 | 3 | 98 | 91 | 189 | |||||||||||||||||||||||||||||||||
2044798 | 2044798 | MA | Bristol | school | 2509000 | 218 | Norton | 250900001451 | 2180505 | Norton High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 165 | 3 | 4 | 0 | 5 | 1 | 2 | 98 | 82 | 180.0 | 165 | 3 | 4 | 0 | 5 | 1 | 2 | 98 | 82 | 180 | |||||||||||||||||||||||||||||||||
2044817 | 2044817 | MA | Plymouth | school | 2509030 | 219 | Norwell | 250903001456 | 2190405 | Norwell Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 143 | 0 | 4 | 0 | 6 | 1 | 5 | 98 | 61 | 159.0 | 143 | 0 | 4 | 0 | 6 | 1 | 5 | 98 | 61 | 159 | |||||||||||||||||||||||||||||||||
2046398 | 2046398 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158001926 | 2950505 | Tewksbury Memorial High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 203 | 4 | 9 | 0 | 9 | 0 | 1 | 98 | 128 | 226.0 | 203 | 4 | 9 | 0 | 9 | 0 | 1 | 98 | 128 | 226 | |||||||||||||||||||||||||||||||||
2046857 | 2046857 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266000170 | 3260310 | Blanchard Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 105 | 5 | 3 | 2 | 55 | 0 | 11 | 98 | 83 | 181.0 | 105 | 5 | 3 | 2 | 55 | 0 | 11 | 98 | 83 | 181 | |||||||||||||||||||||||||||||||||
2049134 | 2049134 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293000207 | 7800310 | Whitman Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 149 | 9 | 10 | 2 | 1 | 0 | 6 | 98 | 79 | 177.0 | 149 | 9 | 10 | 2 | 1 | 0 | 6 | 98 | 79 | 177 | |||||||||||||||||||||||||||||||||
2049235 | 2049235 | MA | Plymouth | school | 2510930 | 873 | South Shore Regional Vocational Technical | 251093001756 | 8730605 | So Shore Vocational Technical High | Career and Technical School | No | High | 09 | 12 | 2019 | grade_11 | 127 | 5 | 11 | 0 | 0 | 0 | 7 | 98 | 52 | 150.0 | 127 | 5 | 11 | 0 | 0 | 0 | 7 | 98 | 52 | 150 | |||||||||||||||||||||||||||||||||
2039945 | 2039945 | MA | Essex | school | 2501950 | 9 | Andover | 250195002510 | 90305 | Doherty Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 162 | 1 | 6 | 2 | 26 | 0 | 4 | 97 | 104 | 201.0 | 162 | 1 | 6 | 2 | 26 | 0 | 4 | 97 | 104 | 201 | |||||||||||||||||||||||||||||||||
2040131 | 2040131 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000132 | 230012 | Lt Job Lane School | Regular School | No | Elementary | 03 | 05 | 2019 | grade_3 | 124 | 11 | 13 | 0 | 38 | 0 | 16 | 97 | 105 | 202.0 | 124 | 11 | 13 | 0 | 38 | 0 | 16 | 97 | 105 | 202 | |||||||||||||||||||||||||||||||||
2041307 | 2041307 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002688 | 440421 | Ashfield Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 48 | 93 | 20 | 1 | 5 | 0 | 6 | 97 | 76 | 173.0 | 48 | 93 | 20 | 1 | 5 | 0 | 6 | 97 | 76 | 173 | |||||||||||||||||||||||||||||||||
2042519 | 2042519 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Waterford Street | Regular School | No | Elementary | PK | 01 | 2019 | grade_1 | 121 | 7 | 45 | 0 | 7 | 0 | 10 | 97 | 93 | 190.0 | 121 | 7 | 45 | 0 | 7 | 0 | 10 | 97 | 93 | 190 | |||||||||||||||||||||||||||||||||
2042691 | 2042691 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579000829 | 1220505 | Hanover High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 193 | 3 | 5 | 0 | 7 | 1 | 0 | 97 | 112 | 209.0 | 193 | 3 | 5 | 0 | 7 | 1 | 0 | 97 | 112 | 209 | |||||||||||||||||||||||||||||||||
2042998 | 2042998 | MA | Middlesex | school | 2506390 | 141 | Hudson | 250639000926 | 1410505 | Hudson High | Regular School | No | High | 08 | 12 | 2019 | grade_12 | 154 | 3 | 16 | 0 | 7 | 0 | 1 | 97 | 84 | 181.0 | 154 | 3 | 16 | 0 | 7 | 0 | 1 | 97 | 84 | 181 | |||||||||||||||||||||||||||||||||
2043902 | 2043902 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001155 | 1750005 | Dale Street | Regular School | No | Elementary | 04 | 05 | 2019 | grade_5 | 162 | 1 | 14 | 0 | 5 | 0 | 6 | 97 | 91 | 188.0 | 162 | 1 | 14 | 0 | 5 | 0 | 6 | 97 | 91 | 188 | |||||||||||||||||||||||||||||||||
2044775 | 2044775 | MA | Middlesex | school | 2508820 | 217 | North Reading | 250882002592 | 2170305 | North Reading Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 166 | 0 | 8 | 0 | 6 | 0 | 3 | 97 | 86 | 183.0 | 166 | 0 | 8 | 0 | 6 | 0 | 3 | 97 | 86 | 183 | |||||||||||||||||||||||||||||||||
2045076 | 2045076 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001532 | 2360310 | Theodore Herberg Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 127 | 21 | 27 | 0 | 3 | 0 | 18 | 97 | 99 | 196.0 | 127 | 21 | 27 | 0 | 3 | 0 | 18 | 97 | 99 | 196 | |||||||||||||||||||||||||||||||||
2045296 | 2045296 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001596 | 2440505 | Randolph High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 11 | 75 | 23 | 0 | 40 | 1 | 6 | 97 | 59 | 156.0 | 11 | 75 | 23 | 0 | 40 | 1 | 6 | 97 | 59 | 156 | |||||||||||||||||||||||||||||||||
2045335 | 2045335 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001612 | 2460310 | Walter S Parker Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 172 | 3 | 7 | 0 | 11 | 0 | 3 | 97 | 99 | 196.0 | 172 | 3 | 7 | 0 | 11 | 0 | 3 | 97 | 99 | 196 | |||||||||||||||||||||||||||||||||
2045385 | 2045385 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005002113 | 2480305 | Susan B. Anthony Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 61 | 4 | 138 | 0 | 5 | 0 | 2 | 97 | 113 | 210.0 | 61 | 4 | 138 | 0 | 5 | 0 | 2 | 97 | 113 | 210 | |||||||||||||||||||||||||||||||||
2045430 | 2045430 | MA | Plymouth | school | 2510170 | 251 | Rockland | 251017001642 | 2510305 | John W Rogers Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 152 | 9 | 31 | 0 | 3 | 0 | 3 | 97 | 101 | 198.0 | 152 | 9 | 31 | 0 | 3 | 0 | 3 | 97 | 101 | 198 | |||||||||||||||||||||||||||||||||
2046299 | 2046299 | MA | Essex | school | 2511430 | 291 | Swampscott | 251143002562 | 2910305 | Swampscott Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 135 | 4 | 17 | 2 | 1 | 0 | 8 | 97 | 70 | 167.0 | 135 | 4 | 17 | 2 | 1 | 0 | 8 | 97 | 70 | 167 | |||||||||||||||||||||||||||||||||
2047902 | 2047902 | MA | Suffolk | school | 2500533 | 480 | UP Academy Charter School of Boston (District) | 250053302713 | 4800405 | UP Academy Charter School of Boston | Regular School | Yes | Middle | 06 | 08 | 2019 | grade_6 | 3 | 74 | 88 | 0 | 9 | 1 | 7 | 97 | 85 | 182.0 | 3 | 74 | 88 | 0 | 9 | 1 | 7 | 97 | 85 | 182 | |||||||||||||||||||||||||||||||||
2047981 | 2047981 | MA | Barnstable | school | 2500058 | 489 | Sturgis Charter Public (District) | 250005801272 | 4890505 | Sturgis Charter Public School | Regular School | Yes | High | 09 | 12 | 2019 | grade_10 | 188 | 6 | 5 | 0 | 11 | 1 | 9 | 97 | 123 | 220.0 | 188 | 6 | 5 | 0 | 11 | 1 | 9 | 97 | 123 | 220 | |||||||||||||||||||||||||||||||||
2048139 | 2048139 | MA | Worcester | school | 2502040 | 610 | Ashburnham-Westminster | 250204000831 | 6100305 | Overlook Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 188 | 0 | 7 | 0 | 1 | 0 | 4 | 97 | 103 | 200.0 | 188 | 0 | 7 | 0 | 1 | 0 | 4 | 97 | 103 | 200 | |||||||||||||||||||||||||||||||||
2048342 | 2048342 | MA | Bristol | school | 2504200 | 650 | Dighton-Rehoboth | 250420000568 | 6500505 | Dighton-Rehoboth Regional High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 181 | 3 | 13 | 1 | 1 | 0 | 3 | 97 | 105 | 202.0 | 181 | 3 | 13 | 1 | 1 | 0 | 3 | 97 | 105 | 202 | |||||||||||||||||||||||||||||||||
2048413 | 2048413 | MA | Plymouth | school | 2505070 | 665 | Freetown-Lakeville | 250507000746 | 6650505 | Apponequet Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 174 | 3 | 4 | 1 | 2 | 0 | 8 | 97 | 95 | 192.0 | 174 | 3 | 4 | 1 | 2 | 0 | 8 | 97 | 95 | 192 | |||||||||||||||||||||||||||||||||
2048581 | 2048581 | MA | Dukes | school | 2507380 | 700 | Martha's Vineyard | 250738001145 | 7000505 | Martha's Vineyard Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 99 | 10 | 30 | 5 | 2 | 2 | 5 | 97 | 56 | 153.0 | 99 | 10 | 30 | 5 | 2 | 2 | 5 | 97 | 56 | 153 | |||||||||||||||||||||||||||||||||
2048625 | 2048625 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402832 | 7120315 | Monomoy Regional Middle School | Regular School | No | Middle | 05 | 07 | 2019 | grade_6 | 146 | 14 | 14 | 0 | 2 | 1 | 4 | 97 | 84 | 181.0 | 146 | 14 | 14 | 0 | 2 | 1 | 4 | 97 | 84 | 181 | |||||||||||||||||||||||||||||||||
2049164 | 2049164 | MA | Barnstable | school | 2503310 | 815 | Cape Cod Regional Vocational Technical | 250331002264 | 8150605 | Cape Cod Region Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2019 | grade_11 | 114 | 11 | 18 | 2 | 2 | 0 | 8 | 97 | 58 | 155.0 | 114 | 11 | 18 | 2 | 2 | 0 | 8 | 97 | 58 | 155 | |||||||||||||||||||||||||||||||||
2049223 | 2049223 | MA | Hampden | school | 2509310 | 860 | Pathfinder Regional Vocational Technical | 250931002285 | 8600605 | Pathfinder Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2019 | grade_11 | 149 | 1 | 8 | 0 | 2 | 0 | 5 | 97 | 66 | 165.0 | 149 | 1 | 8 | 0 | 2 | 0 | 5 | 97 | 66 | 165 | |||||||||||||||||||||||||||||||||
2039943 | 2039943 | MA | Essex | school | 2501950 | 9 | Andover | 250195002510 | 90305 | Doherty Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 139 | 3 | 11 | 1 | 23 | 1 | 5 | 96 | 87 | 183.0 | 139 | 3 | 11 | 1 | 23 | 1 | 5 | 96 | 87 | 183 | |||||||||||||||||||||||||||||||||
2040136 | 2040136 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000130 | 230305 | John Glenn Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 126 | 14 | 12 | 0 | 32 | 0 | 7 | 96 | 95 | 191.0 | 126 | 14 | 12 | 0 | 32 | 0 | 7 | 96 | 95 | 191 | |||||||||||||||||||||||||||||||||
2040140 | 2040140 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000128 | 230505 | Bedford High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 141 | 12 | 16 | 0 | 25 | 1 | 7 | 96 | 106 | 202.0 | 141 | 12 | 16 | 0 | 25 | 1 | 7 | 96 | 106 | 202 | |||||||||||||||||||||||||||||||||
2041297 | 2041297 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000404 | 440410 | North Middle School | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 14 | 99 | 29 | 1 | 4 | 0 | 8 | 96 | 59 | 155.0 | 14 | 99 | 29 | 1 | 4 | 0 | 8 | 96 | 59 | 155 | |||||||||||||||||||||||||||||||||
2041663 | 2041663 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Clark Avenue School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 13 | 8 | 175 | 1 | 1 | 1 | 2 | 96 | 105 | 201.0 | 13 | 8 | 175 | 1 | 1 | 1 | 2 | 96 | 105 | 201 | |||||||||||||||||||||||||||||||||
2041767 | 2041767 | MA | Worcester | school | 2503750 | 64 | Clinton | 250375000512 | 640305 | Clinton Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 127 | 6 | 30 | 0 | 2 | 0 | 6 | 96 | 75 | 171.0 | 127 | 6 | 30 | 0 | 2 | 0 | 6 | 96 | 75 | 171 | |||||||||||||||||||||||||||||||||
2042310 | 2042310 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000686 | 960505 | Falmouth High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 175 | 8 | 7 | 2 | 5 | 0 | 8 | 96 | 108 | 205.0 | 175 | 8 | 7 | 2 | 5 | 0 | 8 | 96 | 108 | 205 | |||||||||||||||||||||||||||||||||
2042326 | 2042326 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 63 | 7 | 103 | 0 | 7 | 1 | 12 | 96 | 97 | 193.0 | 63 | 7 | 103 | 0 | 7 | 1 | 12 | 96 | 97 | 193 | |||||||||||||||||||||||||||||||||
2043483 | 2043483 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000073 | 1600340 | James Sullivan Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 54 | 16 | 71 | 0 | 26 | 0 | 5 | 96 | 76 | 172.0 | 54 | 16 | 71 | 0 | 26 | 0 | 5 | 96 | 76 | 172 | |||||||||||||||||||||||||||||||||
2043513 | 2043513 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705002665 | 1610020 | Chapin Street Elementary School | Regular School | No | Elementary | 02 | 03 | 2019 | grade_2 | 140 | 4 | 20 | 0 | 0 | 0 | 1 | 96 | 69 | 165.0 | 140 | 4 | 20 | 0 | 0 | 0 | 1 | 96 | 69 | 165 | |||||||||||||||||||||||||||||||||
2043522 | 2043522 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705001056 | 1610505 | Ludlow Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 165 | 5 | 15 | 1 | 2 | 0 | 6 | 96 | 98 | 194.0 | 165 | 5 | 15 | 1 | 2 | 0 | 6 | 96 | 98 | 194 | |||||||||||||||||||||||||||||||||
2043541 | 2043541 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002801 | 1630004 | Early Childhood Center | Regular School | No | Elementary | PK | 05 | 2019 | kindergarten | 14 | 17 | 130 | 1 | 13 | 0 | 6 | 96 | 85 | 181.0 | 14 | 17 | 130 | 1 | 13 | 0 | 6 | 96 | 85 | 181 | |||||||||||||||||||||||||||||||||
2043909 | 2043909 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001157 | 1750505 | Medfield Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 174 | 3 | 4 | 0 | 9 | 0 | 8 | 96 | 102 | 198.0 | 174 | 3 | 4 | 0 | 9 | 0 | 8 | 96 | 102 | 198 | |||||||||||||||||||||||||||||||||
2043911 | 2043911 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001157 | 1750505 | Medfield Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 169 | 1 | 3 | 0 | 14 | 0 | 3 | 96 | 94 | 190.0 | 169 | 1 | 3 | 0 | 14 | 0 | 3 | 96 | 94 | 190 | |||||||||||||||||||||||||||||||||
2044737 | 2044737 | MA | Worcester | school | 2508940 | 214 | Northbridge | 250894001445 | 2140505 | Northbridge High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 145 | 2 | 10 | 0 | 3 | 1 | 7 | 96 | 72 | 168.0 | 145 | 2 | 10 | 0 | 3 | 1 | 7 | 96 | 72 | 168 | |||||||||||||||||||||||||||||||||
2046399 | 2046399 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158001926 | 2950505 | Tewksbury Memorial High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 180 | 11 | 11 | 0 | 8 | 0 | 6 | 96 | 120 | 216.0 | 180 | 11 | 11 | 0 | 8 | 0 | 6 | 96 | 120 | 216 | |||||||||||||||||||||||||||||||||
2046894 | 2046894 | MA | Middlesex | school | 2512750 | 330 | Weston | 251275002087 | 3300505 | Weston High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 132 | 11 | 14 | 1 | 34 | 0 | 9 | 96 | 105 | 201.0 | 132 | 11 | 14 | 1 | 34 | 0 | 9 | 96 | 105 | 201 | |||||||||||||||||||||||||||||||||
2048348 | 2048348 | MA | Norfolk | school | 2504290 | 655 | Dover-Sherborn | 250429000575 | 6550405 | Dover-Sherborn Regional Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 137 | 3 | 8 | 0 | 18 | 0 | 7 | 96 | 77 | 173.0 | 137 | 3 | 8 | 0 | 18 | 0 | 7 | 96 | 77 | 173 | |||||||||||||||||||||||||||||||||
2039946 | 2039946 | MA | Essex | school | 2501950 | 9 | Andover | 250195002511 | 90310 | Andover West Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 124 | 4 | 9 | 0 | 27 | 0 | 7 | 95 | 76 | 171.0 | 124 | 4 | 9 | 0 | 27 | 0 | 7 | 95 | 76 | 171 | |||||||||||||||||||||||||||||||||
2040011 | 2040011 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000071 | 140015 | David Mindess | Regular School | No | Elementary | 03 | 05 | 2019 | grade_3 | 124 | 3 | 27 | 0 | 30 | 0 | 7 | 95 | 96 | 191.0 | 124 | 3 | 27 | 0 | 30 | 0 | 7 | 95 | 96 | 191 | |||||||||||||||||||||||||||||||||
2041913 | 2041913 | MA | Norfolk | school | 2504050 | 73 | Dedham | 250405000548 | 730505 | Dedham High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 124 | 9 | 31 | 0 | 2 | 0 | 4 | 95 | 75 | 170.0 | 124 | 9 | 31 | 0 | 2 | 0 | 4 | 95 | 75 | 170 | |||||||||||||||||||||||||||||||||
2042336 | 2042336 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 53 | 20 | 88 | 0 | 8 | 0 | 15 | 95 | 89 | 184.0 | 53 | 20 | 88 | 0 | 8 | 0 | 15 | 95 | 89 | 184 | |||||||||||||||||||||||||||||||||
2042582 | 2042582 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000774 | 1070505 | Gloucester High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 155 | 3 | 21 | 0 | 0 | 0 | 3 | 95 | 87 | 182.0 | 155 | 3 | 21 | 0 | 0 | 0 | 3 | 95 | 87 | 182 | |||||||||||||||||||||||||||||||||
2043070 | 2043070 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001945 | 1490017 | Arlington Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_8 | 3 | 0 | 165 | 0 | 0 | 0 | 1 | 95 | 74 | 169.0 | 3 | 0 | 165 | 0 | 0 | 0 | 1 | 95 | 74 | 169 | |||||||||||||||||||||||||||||||||
2043797 | 2043797 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732001368 | 1700006 | Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 91 | 12 | 42 | 0 | 20 | 3 | 7 | 95 | 80 | 175.0 | 91 | 12 | 42 | 0 | 20 | 3 | 7 | 95 | 80 | 175 | |||||||||||||||||||||||||||||||||
2043899 | 2043899 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753000114 | 1750003 | Memorial School | Regular School | No | Elementary | PK | 01 | 2019 | kindergarten | 167 | 0 | 5 | 2 | 6 | 0 | 4 | 95 | 89 | 184.0 | 167 | 0 | 5 | 2 | 6 | 0 | 4 | 95 | 89 | 184 | |||||||||||||||||||||||||||||||||
2045240 | 2045240 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001561 | 2430305 | Atlantic Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 71 | 3 | 8 | 0 | 101 | 0 | 3 | 95 | 91 | 186.0 | 71 | 3 | 8 | 0 | 101 | 0 | 3 | 95 | 91 | 186 | |||||||||||||||||||||||||||||||||
2045334 | 2045334 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001612 | 2460310 | Walter S Parker Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 151 | 9 | 7 | 1 | 17 | 0 | 3 | 95 | 93 | 188.0 | 151 | 9 | 7 | 1 | 17 | 0 | 3 | 95 | 93 | 188 | |||||||||||||||||||||||||||||||||
2046081 | 2046081 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002601 | 2810328 | John F Kennedy Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 18 | 33 | 108 | 0 | 0 | 0 | 3 | 95 | 67 | 162.0 | 18 | 33 | 108 | 0 | 0 | 0 | 3 | 95 | 67 | 162 | |||||||||||||||||||||||||||||||||
2046603 | 2046603 | MA | Plymouth | school | 2512060 | 310 | Wareham | 251206001989 | 3100017 | Minot Forest | Regular School | No | Elementary | 03 | 04 | 2019 | grade_3 | 110 | 13 | 17 | 5 | 1 | 0 | 20 | 95 | 71 | 166.0 | 110 | 13 | 17 | 5 | 1 | 0 | 20 | 95 | 71 | 166 | |||||||||||||||||||||||||||||||||
2046642 | 2046642 | MA | Middlesex | school | 2512180 | 314 | Watertown | 251218002005 | 3140505 | Watertown High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 109 | 8 | 44 | 2 | 18 | 0 | 4 | 95 | 90 | 185.0 | 109 | 8 | 44 | 2 | 18 | 0 | 4 | 95 | 90 | 185 | |||||||||||||||||||||||||||||||||
2047615 | 2047615 | MA | Suffolk | school | 2500071 | 428 | Brooke Charter School (District) | 250007101747 | 4280305 | Brooke Charter School | Regular School | Yes | Other | KG | 11 | 2019 | grade_6 | 10 | 85 | 79 | 1 | 3 | 0 | 5 | 95 | 88 | 183.0 | 10 | 85 | 79 | 1 | 3 | 0 | 5 | 95 | 88 | 183 | |||||||||||||||||||||||||||||||||
2039877 | 2039877 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000035 | 70013 | Amesbury Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 133 | 4 | 15 | 0 | 2 | 0 | 8 | 94 | 68 | 162.0 | 133 | 4 | 15 | 0 | 2 | 0 | 8 | 94 | 68 | 162 | |||||||||||||||||||||||||||||||||
2041123 | 2041123 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 136 | 2 | 11 | 2 | 2 | 0 | 9 | 94 | 68 | 162.0 | 136 | 2 | 11 | 2 | 2 | 0 | 9 | 94 | 68 | 162 | |||||||||||||||||||||||||||||||||
2042605 | 2042605 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537000786 | 1100505 | Grafton High School | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 161 | 8 | 6 | 0 | 11 | 0 | 6 | 94 | 98 | 192.0 | 161 | 8 | 6 | 0 | 11 | 0 | 6 | 94 | 98 | 192 | |||||||||||||||||||||||||||||||||
2042692 | 2042692 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579000829 | 1220505 | Hanover High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 175 | 0 | 2 | 0 | 6 | 0 | 0 | 94 | 89 | 183.0 | 175 | 0 | 2 | 0 | 6 | 0 | 0 | 94 | 89 | 183 |
Advanced export
JSON shape: default, array, newline-delimited
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]);