enrollments
Data source: Big Local News · About: Big Local
9,565 rows where state = "MA" and year = 2019 sorted by female 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2040084 | 2040084 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000100 | 170505 | Auburn Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 160 | 6 | 7 | 0 | 11 | 0 | 5 | 90 | 99 | 189.0 | 160 | 6 | 7 | 0 | 11 | 0 | 5 | 90 | 99 | 189 | |||||||||||||||||||||||||||||||||
2042312 | 2042312 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000686 | 960505 | Falmouth High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 148 | 4 | 7 | 3 | 10 | 0 | 7 | 79 | 99 | 179.0 | 148 | 4 | 7 | 3 | 10 | 0 | 7 | 79 | 99 | 179 | |||||||||||||||||||||||||||||||||
2042521 | 2042521 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner Middle School | Regular School | No | Middle | 05 | 07 | 2019 | grade_6 | 131 | 3 | 48 | 0 | 5 | 0 | 19 | 107 | 99 | 206.0 | 131 | 3 | 48 | 0 | 5 | 0 | 19 | 107 | 99 | 206 | |||||||||||||||||||||||||||||||||
2042688 | 2042688 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579002548 | 1220305 | Hanover Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 204 | 4 | 5 | 0 | 6 | 0 | 1 | 121 | 99 | 220.0 | 204 | 4 | 5 | 0 | 6 | 0 | 1 | 121 | 99 | 220 | |||||||||||||||||||||||||||||||||
2042861 | 2042861 | MA | Middlesex | school | 2506240 | 136 | Holliston | 250624001172 | 1360010 | Placentino Elementary | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 160 | 1 | 13 | 0 | 19 | 0 | 13 | 107 | 99 | 206.0 | 160 | 1 | 13 | 0 | 19 | 0 | 13 | 107 | 99 | 206 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2044436 | 2044436 | MA | Essex | school | 2508580 | 204 | Newburyport | 250858001355 | 2040305 | Rupert A Nock Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 177 | 3 | 7 | 0 | 9 | 0 | 4 | 101 | 99 | 200.0 | 177 | 3 | 7 | 0 | 9 | 0 | 4 | 101 | 99 | 200 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2045559 | 2045559 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001684 | 2620505 | Saugus High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 138 | 5 | 29 | 0 | 7 | 0 | 1 | 81 | 99 | 180.0 | 138 | 5 | 29 | 0 | 7 | 0 | 1 | 81 | 99 | 180 | |||||||||||||||||||||||||||||||||
2045654 | 2045654 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077002496 | 2710005 | Beal School | Regular School | No | Elementary | KG | 01 | 2019 | kindergarten | 87 | 8 | 18 | 4 | 96 | 0 | 8 | 122 | 99 | 221.0 | 87 | 8 | 18 | 4 | 96 | 0 | 8 | 122 | 99 | 221 | |||||||||||||||||||||||||||||||||
2045715 | 2045715 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002561 | 2740005 | Capuano Early Childhood Center | Regular School | No | Elementary | PK | KG | 2019 | pre_kindergarten | 108 | 15 | 68 | 0 | 21 | 0 | 26 | 139 | 99 | 238.0 | 108 | 15 | 68 | 0 | 21 | 0 | 26 | 139 | 99 | 238 | |||||||||||||||||||||||||||||||||
2046605 | 2046605 | MA | Plymouth | school | 2512060 | 310 | Wareham | 251206002603 | 3100305 | Wareham Middle | Regular School | No | Middle | 05 | 07 | 2019 | grade_5 | 123 | 15 | 12 | 2 | 2 | 0 | 29 | 84 | 99 | 183.0 | 123 | 15 | 12 | 2 | 2 | 0 | 29 | 84 | 99 | 183 | |||||||||||||||||||||||||||||||||
2047189 | 2047189 | MA | Middlesex | school | 2513200 | 347 | Woburn | 251320002182 | 3470410 | Daniel L Joyce Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 137 | 16 | 23 | 0 | 8 | 1 | 6 | 92 | 99 | 191.0 | 137 | 16 | 23 | 0 | 8 | 1 | 6 | 92 | 99 | 191 | |||||||||||||||||||||||||||||||||
2047612 | 2047612 | MA | Suffolk | school | 2500071 | 428 | Brooke Charter School (District) | 250007101747 | 4280305 | Brooke Charter School | Regular School | Yes | Other | KG | 11 | 2019 | grade_3 | 8 | 102 | 69 | 0 | 2 | 0 | 3 | 85 | 99 | 184.0 | 8 | 102 | 69 | 0 | 2 | 0 | 3 | 85 | 99 | 184 | |||||||||||||||||||||||||||||||||
2048789 | 2048789 | MA | Plymouth | school | 2509150 | 740 | Old Rochester | 250915001472 | 7400505 | Old Rochester Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 173 | 5 | 1 | 0 | 7 | 0 | 3 | 90 | 99 | 189.0 | 173 | 5 | 1 | 0 | 7 | 0 | 3 | 90 | 99 | 189 | |||||||||||||||||||||||||||||||||
2049010 | 2049010 | MA | Essex | school | 2511740 | 773 | Triton | 251174001470 | 7730405 | Triton Regional Middle School | Regular School | No | Middle | 07 | 08 | 2019 | grade_8 | 195 | 2 | 4 | 0 | 1 | 0 | 2 | 105 | 99 | 204.0 | 195 | 2 | 4 | 0 | 1 | 0 | 2 | 105 | 99 | 204 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2041222 | 2041222 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002655 | 440003 | Manthala George Jr. School | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 16 | 105 | 78 | 0 | 1 | 0 | 5 | 107 | 98 | 205.0 | 16 | 105 | 78 | 0 | 1 | 0 | 5 | 107 | 98 | 205 | |||||||||||||||||||||||||||||||||
2041228 | 2041228 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002792 | 440008 | Barrett Russell Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 57 | 107 | 33 | 0 | 1 | 1 | 8 | 109 | 98 | 207.0 | 57 | 107 | 33 | 0 | 1 | 1 | 8 | 109 | 98 | 207 | |||||||||||||||||||||||||||||||||
2041300 | 2041300 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000407 | 440415 | South Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 29 | 130 | 37 | 0 | 3 | 0 | 6 | 107 | 98 | 205.0 | 29 | 130 | 37 | 0 | 3 | 0 | 6 | 107 | 98 | 205 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2042997 | 2042997 | MA | Middlesex | school | 2506390 | 141 | Hudson | 250639000926 | 1410505 | Hudson High | Regular School | No | High | 08 | 12 | 2019 | grade_11 | 157 | 3 | 17 | 0 | 2 | 0 | 0 | 81 | 98 | 179.0 | 157 | 3 | 17 | 0 | 2 | 0 | 0 | 81 | 98 | 179 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2044724 | 2044724 | MA | Worcester | school | 2508880 | 213 | Northborough | 250888001440 | 2130305 | Robert E. Melican Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 127 | 2 | 16 | 0 | 28 | 1 | 7 | 83 | 98 | 181.0 | 127 | 2 | 16 | 0 | 28 | 1 | 7 | 83 | 98 | 181 | |||||||||||||||||||||||||||||||||
2045078 | 2045078 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001526 | 2360505 | Pittsfield High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 142 | 20 | 27 | 1 | 6 | 0 | 9 | 107 | 98 | 205.0 | 142 | 20 | 27 | 1 | 6 | 0 | 9 | 107 | 98 | 205 | |||||||||||||||||||||||||||||||||
2045387 | 2045387 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005002113 | 2480305 | Susan B. Anthony Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 54 | 11 | 103 | 1 | 8 | 0 | 4 | 83 | 98 | 181.0 | 54 | 11 | 103 | 1 | 8 | 0 | 4 | 83 | 98 | 181 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2046640 | 2046640 | MA | Middlesex | school | 2512180 | 314 | Watertown | 251218002501 | 3140305 | Watertown Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 128 | 9 | 24 | 2 | 12 | 1 | 9 | 87 | 98 | 185.0 | 128 | 9 | 24 | 2 | 12 | 1 | 9 | 87 | 98 | 185 | |||||||||||||||||||||||||||||||||
2047613 | 2047613 | MA | Suffolk | school | 2500071 | 428 | Brooke Charter School (District) | 250007101747 | 4280305 | Brooke Charter School | Regular School | Yes | Other | KG | 11 | 2019 | grade_4 | 14 | 93 | 67 | 1 | 4 | 0 | 4 | 85 | 98 | 183.0 | 14 | 93 | 67 | 1 | 4 | 0 | 4 | 85 | 98 | 183 | |||||||||||||||||||||||||||||||||
2048379 | 2048379 | MA | Barnstable | school | 2504560 | 660 | Nauset | 250456000609 | 6600305 | Nauset Regional Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 164 | 9 | 12 | 1 | 3 | 0 | 3 | 94 | 98 | 192.0 | 164 | 9 | 12 | 1 | 3 | 0 | 3 | 94 | 98 | 192 | |||||||||||||||||||||||||||||||||
2048411 | 2048411 | MA | Plymouth | school | 2505070 | 665 | Freetown-Lakeville | 250507000746 | 6650505 | Apponequet Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 195 | 1 | 6 | 0 | 3 | 0 | 2 | 109 | 98 | 207.0 | 195 | 1 | 6 | 0 | 3 | 0 | 2 | 109 | 98 | 207 | |||||||||||||||||||||||||||||||||
2048887 | 2048887 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000101558 | 7530505 | Quabbin Regional High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 165 | 1 | 12 | 0 | 1 | 1 | 6 | 88 | 98 | 186.0 | 165 | 1 | 12 | 0 | 1 | 1 | 6 | 88 | 98 | 186 | |||||||||||||||||||||||||||||||||
2040075 | 2040075 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222002846 | 170030 | Swanson Road Intermediate School | Regular School | No | Elementary | 03 | 05 | 2019 | grade_4 | 159 | 5 | 22 | 0 | 14 | 0 | 4 | 107 | 97 | 204.0 | 159 | 5 | 22 | 0 | 14 | 0 | 4 | 107 | 97 | 204 | |||||||||||||||||||||||||||||||||
2040130 | 2040130 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000131 | 230010 | Lt Elezer Davis | Regular School | No | Elementary | KG | 02 | 2019 | grade_2 | 126 | 13 | 9 | 0 | 34 | 0 | 15 | 100 | 97 | 197.0 | 126 | 13 | 9 | 0 | 34 | 0 | 15 | 100 | 97 | 197 | |||||||||||||||||||||||||||||||||
2040297 | 2040297 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000183 | 310305 | Marshall Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 156 | 14 | 11 | 1 | 12 | 0 | 4 | 101 | 97 | 198.0 | 156 | 14 | 11 | 1 | 12 | 0 | 4 | 101 | 97 | 198 | |||||||||||||||||||||||||||||||||
2040979 | 2040979 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Madison Park High | Career and Technical School | No | High | 09 | 12 | 2019 | grade_10 | 3 | 98 | 164 | 0 | 4 | 0 | 3 | 175 | 97 | 272.0 | 3 | 98 | 164 | 0 | 4 | 0 | 3 | 175 | 97 | 272 | |||||||||||||||||||||||||||||||||
2041631 | 2041631 | MA | Middlesex | school | 2503510 | 56 | Chelmsford | 250351000478 | 560310 | McCarthy Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 144 | 5 | 9 | 1 | 34 | 0 | 7 | 103 | 97 | 200.0 | 144 | 5 | 9 | 1 | 34 | 0 | 7 | 103 | 97 | 200 | |||||||||||||||||||||||||||||||||
2041889 | 2041889 | MA | Norfolk | school | 2504050 | 73 | Dedham | 250405000460 | 730005 | Early Childhood Center | Regular School | No | Elementary | PK | KG | 2019 | kindergarten | 144 | 7 | 29 | 0 | 6 | 0 | 15 | 104 | 97 | 201.0 | 144 | 7 | 29 | 0 | 6 | 0 | 15 | 104 | 97 | 201 | |||||||||||||||||||||||||||||||||
2042184 | 2042184 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480000642 | 940505 | Fairhaven High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 144 | 0 | 13 | 0 | 3 | 0 | 3 | 66 | 97 | 163.0 | 144 | 0 | 13 | 0 | 3 | 0 | 3 | 66 | 97 | 163 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2043774 | 2043774 | MA | Essex | school | 2507260 | 168 | Marblehead | 250726001788 | 1680016 | Village School | Regular School | No | Middle | 04 | 06 | 2019 | grade_4 | 179 | 10 | 18 | 0 | 5 | 0 | 9 | 124 | 97 | 221.0 | 179 | 10 | 18 | 0 | 5 | 0 | 9 | 124 | 97 | 221 | |||||||||||||||||||||||||||||||||
2043908 | 2043908 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001157 | 1750505 | Medfield Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 181 | 1 | 5 | 0 | 10 | 0 | 8 | 108 | 97 | 205.0 | 181 | 1 | 5 | 0 | 10 | 0 | 8 | 108 | 97 | 205 | |||||||||||||||||||||||||||||||||
2043964 | 2043964 | MA | Norfolk | school | 2507590 | 177 | Medway | 250759002483 | 1770305 | Medway Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_8 | 157 | 1 | 9 | 1 | 5 | 0 | 2 | 78 | 97 | 175.0 | 157 | 1 | 9 | 1 | 5 | 0 | 2 | 78 | 97 | 175 | |||||||||||||||||||||||||||||||||
2044441 | 2044441 | MA | Essex | school | 2508580 | 204 | Newburyport | 250858001354 | 2040505 | Newburyport High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 167 | 3 | 9 | 0 | 3 | 0 | 2 | 87 | 97 | 184.0 | 167 | 3 | 9 | 0 | 3 | 0 | 2 | 87 | 97 | 184 | |||||||||||||||||||||||||||||||||
2044780 | 2044780 | MA | Middlesex | school | 2508820 | 217 | North Reading | 250882001422 | 2170505 | North Reading High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 190 | 1 | 4 | 0 | 5 | 0 | 1 | 104 | 97 | 201.0 | 190 | 1 | 4 | 0 | 5 | 0 | 1 | 104 | 97 | 201 | |||||||||||||||||||||||||||||||||
2045714 | 2045714 | MA | Bristol | school | 2510860 | 273 | Somerset | 251086002537 | 2730305 | Somerset Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 186 | 4 | 8 | 0 | 2 | 0 | 6 | 109 | 97 | 206.0 | 186 | 4 | 8 | 0 | 2 | 0 | 6 | 109 | 97 | 206 | |||||||||||||||||||||||||||||||||
2046181 | 2046181 | MA | Middlesex | school | 2511220 | 284 | Stoneham | 251122002295 | 2840505 | Stoneham High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 147 | 4 | 19 | 0 | 10 | 0 | 8 | 91 | 97 | 188.0 | 147 | 4 | 19 | 0 | 10 | 0 | 8 | 91 | 97 | 188 | |||||||||||||||||||||||||||||||||
2046860 | 2046860 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266002080 | 3260330 | Stony Brook School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 144 | 1 | 6 | 0 | 45 | 0 | 8 | 107 | 97 | 204.0 | 144 | 1 | 6 | 0 | 45 | 0 | 8 | 107 | 97 | 204 | |||||||||||||||||||||||||||||||||
2048458 | 2048458 | MA | Middlesex | school | 2505500 | 673 | Groton-Dunstable | 250550000807 | 6730505 | Groton Dunstable Regional | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 152 | 1 | 6 | 0 | 19 | 0 | 4 | 85 | 97 | 182.0 | 152 | 1 | 6 | 0 | 19 | 0 | 4 | 85 | 97 | 182 | |||||||||||||||||||||||||||||||||
2048459 | 2048459 | MA | Middlesex | school | 2505500 | 673 | Groton-Dunstable | 250550000807 | 6730505 | Groton Dunstable Regional | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 171 | 2 | 3 | 0 | 14 | 0 | 1 | 94 | 97 | 191.0 | 171 | 2 | 3 | 0 | 14 | 0 | 1 | 94 | 97 | 191 | |||||||||||||||||||||||||||||||||
2049155 | 2049155 | MA | Norfolk | school | 2502740 | 806 | Blue Hills Regional Vocational Technical | 250274000193 | 8060605 | Blue Hills Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2019 | grade_10 | 125 | 50 | 24 | 1 | 5 | 0 | 9 | 117 | 97 | 214.0 | 125 | 50 | 24 | 1 | 5 | 0 | 9 | 117 | 97 | 214 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2040081 | 2040081 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000100 | 170505 | Auburn Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 141 | 4 | 14 | 0 | 6 | 0 | 8 | 77 | 96 | 173.0 | 141 | 4 | 14 | 0 | 6 | 0 | 8 | 77 | 96 | 173 | |||||||||||||||||||||||||||||||||
2042392 | 2042392 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000708 | 990505 | Foxborough High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 155 | 11 | 8 | 0 | 7 | 0 | 1 | 86 | 96 | 182.0 | 155 | 11 | 8 | 0 | 7 | 0 | 1 | 86 | 96 | 182 | |||||||||||||||||||||||||||||||||
2042514 | 2042514 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000750 | 1030001 | Elm Street School | Regular School | No | Elementary | 02 | 04 | 2019 | grade_2 | 124 | 2 | 39 | 0 | 3 | 0 | 11 | 83 | 96 | 179.0 | 124 | 2 | 39 | 0 | 3 | 0 | 11 | 83 | 96 | 179 | |||||||||||||||||||||||||||||||||
2042522 | 2042522 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner Middle School | Regular School | No | Middle | 05 | 07 | 2019 | grade_7 | 127 | 8 | 36 | 0 | 1 | 0 | 17 | 93 | 96 | 189.0 | 127 | 8 | 36 | 0 | 1 | 0 | 17 | 93 | 96 | 189 | |||||||||||||||||||||||||||||||||
2042606 | 2042606 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537000786 | 1100505 | Grafton High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 164 | 3 | 7 | 0 | 21 | 0 | 6 | 105 | 96 | 201.0 | 164 | 3 | 7 | 0 | 21 | 0 | 6 | 105 | 96 | 201 | |||||||||||||||||||||||||||||||||
2042869 | 2042869 | MA | Middlesex | school | 2506240 | 136 | Holliston | 250624000894 | 1360505 | Holliston High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 161 | 1 | 7 | 0 | 11 | 0 | 4 | 88 | 96 | 184.0 | 161 | 1 | 7 | 0 | 11 | 0 | 4 | 88 | 96 | 184 | |||||||||||||||||||||||||||||||||
2043517 | 2043517 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705001055 | 1610305 | Paul R Baird Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 179 | 7 | 19 | 2 | 0 | 0 | 4 | 115 | 96 | 211.0 | 179 | 7 | 19 | 2 | 0 | 0 | 4 | 115 | 96 | 211 | |||||||||||||||||||||||||||||||||
2044065 | 2044065 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777002626 | 1820011 | Memorial Early Childhood Center | Regular School | No | Elementary | PK | KG | 2019 | kindergarten | 192 | 2 | 5 | 0 | 5 | 0 | 1 | 109 | 96 | 205.0 | 192 | 2 | 5 | 0 | 5 | 0 | 1 | 109 | 96 | 205 | |||||||||||||||||||||||||||||||||
2044625 | 2044625 | MA | Hampshire | school | 2508850 | 210 | Northampton | 250885001432 | 2100505 | Northampton High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 145 | 6 | 34 | 0 | 6 | 0 | 12 | 107 | 96 | 203.0 | 145 | 6 | 34 | 0 | 6 | 0 | 12 | 107 | 96 | 203 | |||||||||||||||||||||||||||||||||
2045080 | 2045080 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001526 | 2360505 | Pittsfield High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 127 | 17 | 28 | 0 | 3 | 0 | 11 | 90 | 96 | 186.0 | 127 | 17 | 28 | 0 | 3 | 0 | 11 | 90 | 96 | 186 | |||||||||||||||||||||||||||||||||
2045355 | 2045355 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001963 | 2480014 | Rumney Marsh Academy | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 94 | 6 | 88 | 1 | 6 | 1 | 2 | 102 | 96 | 198.0 | 94 | 6 | 88 | 1 | 6 | 1 | 2 | 102 | 96 | 198 | |||||||||||||||||||||||||||||||||
2045382 | 2045382 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001976 | 2480057 | Garfield Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 70 | 7 | 114 | 0 | 7 | 0 | 3 | 105 | 96 | 201.0 | 70 | 7 | 114 | 0 | 7 | 0 | 3 | 105 | 96 | 201 | |||||||||||||||||||||||||||||||||
2046362 | 2046362 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001911 | 2930042 | Joseph H Martin | Regular School | No | Middle | 05 | 07 | 2019 | grade_7 | 155 | 35 | 20 | 1 | 2 | 0 | 15 | 132 | 96 | 228.0 | 155 | 35 | 20 | 1 | 2 | 0 | 15 | 132 | 96 | 228 | |||||||||||||||||||||||||||||||||
2046670 | 2046670 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002010 | 3150505 | Wayland High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 143 | 6 | 7 | 0 | 38 | 0 | 10 | 108 | 96 | 204.0 | 143 | 6 | 7 | 0 | 38 | 0 | 10 | 108 | 96 | 204 | |||||||||||||||||||||||||||||||||
2046891 | 2046891 | MA | Middlesex | school | 2512750 | 330 | Weston | 251275002087 | 3300505 | Weston High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 107 | 11 | 7 | 2 | 31 | 0 | 6 | 68 | 96 | 164.0 | 107 | 11 | 7 | 2 | 31 | 0 | 6 | 68 | 96 | 164 | |||||||||||||||||||||||||||||||||
2048455 | 2048455 | MA | Middlesex | school | 2505500 | 673 | Groton-Dunstable | 250550000805 | 6730305 | Groton Dunstable Regional Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 162 | 5 | 5 | 0 | 9 | 0 | 4 | 89 | 96 | 185.0 | 162 | 5 | 5 | 0 | 9 | 0 | 4 | 89 | 96 | 185 | |||||||||||||||||||||||||||||||||
2048456 | 2048456 | MA | Middlesex | school | 2505500 | 673 | Groton-Dunstable | 250550000805 | 6730305 | Groton Dunstable Regional Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 182 | 2 | 2 | 1 | 8 | 1 | 4 | 104 | 96 | 200.0 | 182 | 2 | 2 | 1 | 8 | 1 | 4 | 104 | 96 | 200 | |||||||||||||||||||||||||||||||||
2048460 | 2048460 | MA | Middlesex | school | 2505500 | 673 | Groton-Dunstable | 250550000807 | 6730505 | Groton Dunstable Regional | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 168 | 1 | 1 | 0 | 10 | 1 | 0 | 85 | 96 | 181.0 | 168 | 1 | 1 | 0 | 10 | 1 | 0 | 85 | 96 | 181 | |||||||||||||||||||||||||||||||||
2048598 | 2048598 | MA | Worcester | school | 2507680 | 710 | Mendon-Upton | 250768001279 | 7100015 | Miscoe Hill School | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 177 | 0 | 11 | 0 | 6 | 0 | 7 | 105 | 96 | 201.0 | 177 | 0 | 11 | 0 | 6 | 0 | 7 | 105 | 96 | 201 | |||||||||||||||||||||||||||||||||
2048885 | 2048885 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102003 | 7530405 | Quabbin Regional Middle School | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 170 | 1 | 7 | 0 | 3 | 0 | 2 | 87 | 96 | 183.0 | 170 | 1 | 7 | 0 | 3 | 0 | 2 | 87 | 96 | 183 | |||||||||||||||||||||||||||||||||
2049014 | 2049014 | MA | Essex | school | 2511740 | 773 | Triton | 251174001932 | 7730505 | Triton Regional High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 167 | 0 | 9 | 0 | 2 | 0 | 2 | 84 | 96 | 180.0 | 167 | 0 | 9 | 0 | 2 | 0 | 2 | 84 | 96 | 180 | |||||||||||||||||||||||||||||||||
2039948 | 2039948 | MA | Essex | school | 2501950 | 9 | Andover | 250195002511 | 90310 | Andover West Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 138 | 2 | 6 | 1 | 24 | 0 | 6 | 82 | 95 | 177.0 | 138 | 2 | 6 | 1 | 24 | 0 | 6 | 82 | 95 | 177 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2040145 | 2040145 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243001871 | 240006 | Chestnut Hill Community School | Regular School | No | Middle | 04 | 06 | 2019 | grade_5 | 162 | 2 | 8 | 1 | 2 | 0 | 3 | 83 | 95 | 178.0 | 162 | 2 | 8 | 1 | 2 | 0 | 3 | 83 | 95 | 178 | |||||||||||||||||||||||||||||||||
2040978 | 2040978 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Madison Park High | Career and Technical School | No | High | 09 | 12 | 2019 | grade_9 | 5 | 88 | 137 | 2 | 4 | 0 | 5 | 146 | 95 | 241.0 | 5 | 88 | 137 | 2 | 4 | 0 | 5 | 146 | 95 | 241 | |||||||||||||||||||||||||||||||||
2040980 | 2040980 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Madison Park High | Career and Technical School | No | High | 09 | 12 | 2019 | grade_11 | 2 | 72 | 113 | 1 | 2 | 1 | 4 | 100 | 95 | 195.0 | 2 | 72 | 113 | 1 | 2 | 1 | 4 | 100 | 95 | 195 | |||||||||||||||||||||||||||||||||
2041301 | 2041301 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000407 | 440415 | South Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 22 | 146 | 30 | 0 | 6 | 0 | 11 | 120 | 95 | 215.0 | 22 | 146 | 30 | 0 | 6 | 0 | 11 | 120 | 95 | 215 | |||||||||||||||||||||||||||||||||
2041914 | 2041914 | MA | Norfolk | school | 2504050 | 73 | Dedham | 250405000548 | 730505 | Dedham High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 128 | 18 | 29 | 0 | 6 | 0 | 7 | 93 | 95 | 188.0 | 128 | 18 | 29 | 0 | 6 | 0 | 7 | 93 | 95 | 188 | |||||||||||||||||||||||||||||||||
2041976 | 2041976 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432000579 | 790505 | Dracut Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 160 | 18 | 10 | 2 | 13 | 0 | 4 | 112 | 95 | 207.0 | 160 | 18 | 10 | 2 | 13 | 0 | 4 | 112 | 95 | 207 | |||||||||||||||||||||||||||||||||
2042264 | 2042264 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Morton Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 114 | 14 | 41 | 1 | 13 | 0 | 16 | 104 | 95 | 199.0 | 114 | 14 | 41 | 1 | 13 | 0 | 16 | 104 | 95 | 199 | |||||||||||||||||||||||||||||||||
2042744 | 2042744 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597002881 | 1280030 | Caleb Dustin Hunking School | Regular School | No | Elementary | KG | 08 | 2019 | grade_7 | 147 | 12 | 35 | 0 | 3 | 1 | 3 | 106 | 95 | 201.0 | 147 | 12 | 35 | 0 | 3 | 1 | 3 | 106 | 95 | 201 | |||||||||||||||||||||||||||||||||
2042793 | 2042793 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000850 | 1280100 | Consentino Middle School | Regular School | No | Middle | 04 | 08 | 2019 | grade_7 | 109 | 10 | 95 | 1 | 3 | 0 | 1 | 124 | 95 | 219.0 | 109 | 10 | 95 | 1 | 3 | 0 | 1 | 124 | 95 | 219 | |||||||||||||||||||||||||||||||||
2044781 | 2044781 | MA | Middlesex | school | 2508820 | 217 | North Reading | 250882001422 | 2170505 | North Reading High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 171 | 1 | 3 | 0 | 5 | 0 | 4 | 89 | 95 | 184.0 | 171 | 1 | 3 | 0 | 5 | 0 | 4 | 89 | 95 | 184 | |||||||||||||||||||||||||||||||||
2044818 | 2044818 | MA | Plymouth | school | 2509030 | 219 | Norwell | 250903001456 | 2190405 | Norwell Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 162 | 0 | 0 | 1 | 3 | 0 | 3 | 74 | 95 | 169.0 | 162 | 0 | 0 | 1 | 3 | 0 | 3 | 74 | 95 | 169 | |||||||||||||||||||||||||||||||||
2045354 | 2045354 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001963 | 2480014 | Rumney Marsh Academy | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 56 | 11 | 115 | 1 | 10 | 0 | 5 | 103 | 95 | 198.0 | 56 | 11 | 115 | 1 | 10 | 0 | 5 | 103 | 95 | 198 | |||||||||||||||||||||||||||||||||
2045516 | 2045516 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002857 | 2610002 | Forestdale School | Regular School | No | Elementary | PK | 02 | 2019 | grade_2 | 165 | 1 | 10 | 1 | 5 | 0 | 4 | 91 | 95 | 186.0 | 165 | 1 | 10 | 1 | 5 | 0 | 4 | 91 | 95 | 186 | |||||||||||||||||||||||||||||||||
2046183 | 2046183 | MA | Middlesex | school | 2511220 | 284 | Stoneham | 251122002295 | 2840505 | Stoneham High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 151 | 7 | 7 | 0 | 4 | 0 | 2 | 76 | 95 | 171.0 | 151 | 7 | 7 | 0 | 4 | 0 | 2 | 76 | 95 | 171 | |||||||||||||||||||||||||||||||||
2046370 | 2046370 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152002416 | 2930305 | John F Parker Middle | Regular School | No | Middle | 05 | 07 | 2019 | grade_7 | 82 | 48 | 29 | 2 | 2 | 0 | 14 | 82 | 95 | 177.0 | 82 | 48 | 29 | 2 | 2 | 0 | 14 | 82 | 95 | 177 | |||||||||||||||||||||||||||||||||
2046667 | 2046667 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002010 | 3150505 | Wayland High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 129 | 9 | 8 | 0 | 42 | 1 | 10 | 104 | 95 | 199.0 | 129 | 9 | 8 | 0 | 42 | 1 | 10 | 104 | 95 | 199 | |||||||||||||||||||||||||||||||||
2046680 | 2046680 | MA | Worcester | school | 2512240 | 316 | Webster | 251224002849 | 3160315 | Webster Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_8 | 87 | 12 | 40 | 0 | 2 | 0 | 9 | 55 | 95 | 150.0 | 87 | 12 | 40 | 0 | 2 | 0 | 9 | 55 | 95 | 150 | |||||||||||||||||||||||||||||||||
2048141 | 2048141 | MA | Worcester | school | 2502040 | 610 | Ashburnham-Westminster | 250204000069 | 6100505 | Oakmont Regional High School | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 163 | 0 | 5 | 0 | 4 | 0 | 2 | 79 | 95 | 174.0 | 163 | 0 | 5 | 0 | 4 | 0 | 2 | 79 | 95 | 174 | |||||||||||||||||||||||||||||||||
2048349 | 2048349 | MA | Norfolk | school | 2504290 | 655 | Dover-Sherborn | 250429000575 | 6550405 | Dover-Sherborn Regional Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 135 | 7 | 7 | 1 | 17 | 0 | 10 | 82 | 95 | 177.0 | 135 | 7 | 7 | 1 | 17 | 0 | 10 | 82 | 95 | 177 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2048785 | 2048785 | MA | Plymouth | school | 2509150 | 740 | Old Rochester | 250915001473 | 7400405 | Old Rochester Regional Jr High | Regular School | No | Middle | 07 | 08 | 2019 | grade_8 | 206 | 2 | 5 | 0 | 4 | 0 | 8 | 130 | 95 | 225.0 | 206 | 2 | 5 | 0 | 4 | 0 | 8 | 130 | 95 | 225 | |||||||||||||||||||||||||||||||||
2048818 | 2048818 | MA | Essex | school | 2509450 | 745 | Pentucket | 250945001513 | 7450505 | Pentucket Regional Sr High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 182 | 4 | 3 | 0 | 8 | 0 | 3 | 105 | 95 | 200.0 | 182 | 4 | 3 | 0 | 8 | 0 | 3 | 105 | 95 | 200 | |||||||||||||||||||||||||||||||||
2040016 | 2040016 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000938 | 140405 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 123 | 3 | 25 | 2 | 30 | 0 | 2 | 91 | 94 | 185.0 | 123 | 3 | 25 | 2 | 30 | 0 | 2 | 91 | 94 | 185 |
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]);