enrollments
Data source: Big Local News · About: Big Local
572 rows where grade = "grade_6", state = "MA" and year = 2019 sorted by female
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2042770 | 2042770 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597001706 | 1280073 | TEACH | Regular School | No | Other | 01 | 12 | 2019 | grade_6 | 4 | 0 | 3 | 0 | 0 | 0 | 1 | 7 | * | 8.0 | 4 | 0 | 3 | 0 | 0 | 0 | 1 | 7 | 8 | ||||||||||||||||||||||||||||||||||
2043453 | 2043453 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002726 | 1600085 | Laura Lee Therapeutic Day School | Regular School | No | Middle | 02 | 08 | 2019 | grade_6 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 6 | * | 6.0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||
2040420 | 2040420 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002835 | 350066 | Dante Alighieri Montessori School | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | * | * | * | * | * | * | * | 3 | 1 | 4.0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||
2041287 | 2041287 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002544 | 440400 | Huntington Therapeutic Day School | Alternative School | No | Other | 03 | 12 | 2019 | grade_6 | * | * | * | * | * | * | * | 3 | 1 | 4.0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||
2042136 | 2042136 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002787 | 930030 | Devens School | Regular School | No | Other | KG | 12 | 2019 | grade_6 | 2 | 5 | 3 | 0 | 0 | 0 | 1 | 10 | 1 | 11.0 | 2 | 5 | 3 | 0 | 0 | 0 | 1 | 10 | 1 | 11 | |||||||||||||||||||||||||||||||||
2042269 | 2042269 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002852 | 950340 | Stone PK-12 School | Regular School | No | Other | 01 | 12 | 2019 | grade_6 | * | * | * | * | * | * | * | 3 | 1 | 4.0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||
2043675 | 2043675 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002277 | 1630605 | Lynn Vocational Technical Institute | Career and Technical School | No | High | 06 | 12 | 2019 | grade_6 | * | * | * | * | * | * | * | 1 | 1 | 2.0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
2048406 | 2048406 | MA | Plymouth | school | 2505070 | 665 | Freetown-Lakeville | 250507001852 | 6650015 | George R Austin Intermediate School | Regular School | No | Middle | 04 | 06 | 2019 | grade_6 | * | * | * | * | * | * | * | 1 | 1 | 2.0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
2045163 | 2045163 | MA | Plymouth | school | 2509780 | 240 | Plympton | 250978001551 | 2400010 | Dennett Elementary | Regular School | No | Elementary | KG | 06 | 2019 | grade_6 | 18 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 10 | 20.0 | 18 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
2047352 | 2047352 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002214 | 3480177 | Francis J McGrath Elementary | Regular School | No | Elementary | KG | 06 | 2019 | grade_6 | 5 | 8 | 6 | 0 | 1 | 0 | 3 | 13 | 10 | 23.0 | 5 | 8 | 6 | 0 | 1 | 0 | 3 | 13 | 10 | 23 | |||||||||||||||||||||||||||||||||
2048549 | 2048549 | MA | Franklin | school | 2506000 | 685 | Hawlemont | 250600000869 | 6850005 | Hawlemont Regional | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 16 | 1 | 1 | 0 | 0 | 0 | 1 | 9 | 10 | 19.0 | 16 | 1 | 1 | 0 | 0 | 0 | 1 | 9 | 10 | 19 | |||||||||||||||||||||||||||||||||
2048671 | 2048671 | MA | Franklin | school | 2507990 | 717 | Mohawk Trail | 250799000425 | 7170010 | Colrain Central | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 13 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 10 | 15.0 | 13 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | |||||||||||||||||||||||||||||||||
2048749 | 2048749 | MA | Franklin | school | 2508530 | 728 | New Salem-Wendell | 250853001346 | 7280015 | Swift River | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 18 | 0 | 2 | 0 | 0 | 0 | 2 | 12 | 10 | 22.0 | 18 | 0 | 2 | 0 | 0 | 0 | 2 | 12 | 10 | 22 | |||||||||||||||||||||||||||||||||
2041065 | 2041065 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002721 | 350656 | Mario Umana Academy | Regular School | No | Elementary | PK | 08 | 2019 | grade_6 | 13 | 2 | 174 | 0 | 2 | 0 | 1 | 92 | 100 | 192.0 | 13 | 2 | 174 | 0 | 2 | 0 | 1 | 92 | 100 | 192 | |||||||||||||||||||||||||||||||||
2042388 | 2042388 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | John J Ahern | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 181 | 10 | 8 | 1 | 10 | 0 | 5 | 115 | 100 | 215.0 | 181 | 10 | 8 | 1 | 10 | 0 | 5 | 115 | 100 | 215 | |||||||||||||||||||||||||||||||||
2046083 | 2046083 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002602 | 2810330 | M Marcus Kiley Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 22 | 54 | 148 | 0 | 4 | 0 | 1 | 129 | 100 | 229.0 | 22 | 54 | 148 | 0 | 4 | 0 | 1 | 129 | 100 | 229 | |||||||||||||||||||||||||||||||||
2046177 | 2046177 | MA | Middlesex | school | 2511220 | 284 | Stoneham | 251122001857 | 2840405 | Stoneham Central Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 143 | 3 | 21 | 0 | 10 | 0 | 4 | 81 | 100 | 181.0 | 143 | 3 | 21 | 0 | 10 | 0 | 4 | 81 | 100 | 181 | |||||||||||||||||||||||||||||||||
2042050 | 2042050 | MA | Hampden | school | 2504500 | 87 | East Longmeadow | 250450000602 | 870305 | Birchland Park | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 149 | 10 | 16 | 0 | 9 | 0 | 9 | 92 | 101 | 193.0 | 149 | 10 | 16 | 0 | 9 | 0 | 9 | 92 | 101 | 193 | |||||||||||||||||||||||||||||||||
2045496 | 2045496 | MA | Essex | school | 2510380 | 258 | Salem | 251038002404 | 2580305 | Collins Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 101 | 16 | 91 | 0 | 6 | 0 | 9 | 122 | 101 | 223.0 | 101 | 16 | 91 | 0 | 6 | 0 | 9 | 122 | 101 | 223 | |||||||||||||||||||||||||||||||||
2045520 | 2045520 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002535 | 2610025 | Oak Ridge | Regular School | No | Elementary | 03 | 06 | 2019 | grade_6 | 194 | 4 | 3 | 1 | 2 | 0 | 4 | 107 | 101 | 208.0 | 194 | 4 | 3 | 1 | 2 | 0 | 4 | 107 | 101 | 208 | |||||||||||||||||||||||||||||||||
2045712 | 2045712 | MA | Bristol | school | 2510860 | 273 | Somerset | 251086002537 | 2730305 | Somerset Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 181 | 4 | 14 | 1 | 1 | 0 | 5 | 105 | 101 | 206.0 | 181 | 4 | 14 | 1 | 1 | 0 | 5 | 105 | 101 | 206 | |||||||||||||||||||||||||||||||||
2043776 | 2043776 | MA | Essex | school | 2507260 | 168 | Marblehead | 250726001788 | 1680016 | Village School | Regular School | No | Middle | 04 | 06 | 2019 | grade_6 | 196 | 5 | 13 | 0 | 3 | 0 | 7 | 121 | 103 | 224.0 | 196 | 5 | 13 | 0 | 3 | 0 | 7 | 121 | 103 | 224 | |||||||||||||||||||||||||||||||||
2045246 | 2045246 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Central Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 92 | 5 | 6 | 0 | 83 | 2 | 9 | 94 | 103 | 197.0 | 92 | 5 | 6 | 0 | 83 | 2 | 9 | 94 | 103 | 197 | |||||||||||||||||||||||||||||||||
2045292 | 2045292 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001392 | 2440410 | Randolph Community Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 25 | 94 | 50 | 1 | 45 | 0 | 14 | 126 | 103 | 229.0 | 25 | 94 | 50 | 1 | 45 | 0 | 14 | 126 | 103 | 229 | |||||||||||||||||||||||||||||||||
2046977 | 2046977 | MA | Norfolk | school | 2512810 | 335 | Westwood | 251281002097 | 3350305 | E W Thurston Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 186 | 4 | 10 | 0 | 29 | 0 | 5 | 131 | 103 | 234.0 | 186 | 4 | 10 | 0 | 29 | 0 | 5 | 131 | 103 | 234 | |||||||||||||||||||||||||||||||||
2042992 | 2042992 | MA | Middlesex | school | 2506390 | 141 | Hudson | 250639000927 | 1410410 | David J. Quinn Middle School | Regular School | No | Middle | 05 | 07 | 2019 | grade_6 | 163 | 5 | 26 | 0 | 2 | 0 | 10 | 102 | 104 | 206.0 | 163 | 5 | 26 | 0 | 2 | 0 | 10 | 102 | 104 | 206 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2045553 | 2045553 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001685 | 2620305 | Belmonte Saugus Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 149 | 8 | 40 | 1 | 10 | 1 | 6 | 111 | 104 | 215.0 | 149 | 8 | 40 | 1 | 10 | 1 | 6 | 111 | 104 | 215 | |||||||||||||||||||||||||||||||||
2045071 | 2045071 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001525 | 2360305 | John T Reid Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 127 | 30 | 20 | 1 | 0 | 0 | 16 | 89 | 105 | 194.0 | 127 | 30 | 20 | 1 | 0 | 0 | 16 | 89 | 105 | 194 | |||||||||||||||||||||||||||||||||
2042863 | 2042863 | MA | Middlesex | school | 2506240 | 136 | Holliston | 250624001304 | 1360305 | Robert H. Adams Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 203 | 0 | 14 | 0 | 14 | 0 | 6 | 131 | 106 | 237.0 | 203 | 0 | 14 | 0 | 14 | 0 | 6 | 131 | 106 | 237 | |||||||||||||||||||||||||||||||||
2040014 | 2040014 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000938 | 140405 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 145 | 6 | 26 | 0 | 30 | 0 | 8 | 107 | 108 | 215.0 | 145 | 6 | 26 | 0 | 30 | 0 | 8 | 107 | 108 | 215 | |||||||||||||||||||||||||||||||||
2046361 | 2046361 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001911 | 2930042 | Joseph H Martin | Regular School | No | Middle | 05 | 07 | 2019 | grade_6 | 149 | 33 | 29 | 1 | 2 | 1 | 7 | 114 | 108 | 222.0 | 149 | 33 | 29 | 1 | 2 | 1 | 7 | 114 | 108 | 222 | |||||||||||||||||||||||||||||||||
2045353 | 2045353 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001963 | 2480014 | Rumney Marsh Academy | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 67 | 7 | 117 | 1 | 14 | 0 | 9 | 106 | 109 | 215.0 | 67 | 7 | 117 | 1 | 14 | 0 | 9 | 106 | 109 | 215 | |||||||||||||||||||||||||||||||||
2041758 | 2041758 | MA | Berkshire | school | 2503720 | 63 | Clarksburg | 250372000510 | 630010 | Clarksburg Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_6 | 21 | 0 | 0 | 0 | 0 | 0 | 2 | 12 | 11 | 23.0 | 21 | 0 | 0 | 0 | 0 | 0 | 2 | 12 | 11 | 23 | |||||||||||||||||||||||||||||||||
2041821 | 2041821 | MA | Franklin | school | 2503900 | 68 | Conway | 250390000528 | 680005 | Conway Grammar | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 19 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 11 | 20.0 | 19 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | |||||||||||||||||||||||||||||||||
2045404 | 2045404 | MA | Berkshire | school | 2510080 | 249 | Richmond | 251008001635 | 2490005 | Richmond Consolidated | Regular School | No | Elementary | PK | 08 | 2019 | grade_6 | 18 | 1 | 2 | 0 | 0 | 0 | 0 | 10 | 11 | 21.0 | 18 | 1 | 2 | 0 | 0 | 0 | 0 | 10 | 11 | 21 | |||||||||||||||||||||||||||||||||
2047211 | 2047211 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002250 | 3480026 | Wawecus Road School | Regular School | No | Elementary | KG | 06 | 2019 | grade_6 | 11 | 5 | 6 | 0 | 0 | 0 | 0 | 11 | 11 | 22.0 | 11 | 5 | 6 | 0 | 0 | 0 | 0 | 11 | 11 | 22 | |||||||||||||||||||||||||||||||||
2047848 | 2047848 | MA | Dukes | school | 2500035 | 466 | Martha's Vineyard Charter (District) | 250003500569 | 4660550 | Martha's Vineyard Charter School | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 14 | 1 | 4 | 0 | 0 | 0 | 2 | 10 | 11 | 21.0 | 14 | 1 | 4 | 0 | 0 | 0 | 2 | 10 | 11 | 21 | |||||||||||||||||||||||||||||||||
2048959 | 2048959 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201766 | 7670008 | East Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 9 | 11 | 20.0 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 9 | 11 | 20 | |||||||||||||||||||||||||||||||||
2045143 | 2045143 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001380 | 2390305 | Plymouth South Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 205 | 3 | 10 | 1 | 2 | 0 | 5 | 114 | 112 | 226.0 | 205 | 3 | 10 | 1 | 2 | 0 | 5 | 114 | 112 | 226 | |||||||||||||||||||||||||||||||||
2045074 | 2045074 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001532 | 2360310 | Theodore Herberg Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 149 | 31 | 32 | 0 | 2 | 0 | 13 | 114 | 113 | 227.0 | 149 | 31 | 32 | 0 | 2 | 0 | 13 | 114 | 113 | 227 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2045592 | 2045592 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Gates Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 213 | 9 | 6 | 0 | 1 | 0 | 2 | 118 | 113 | 231.0 | 213 | 9 | 6 | 0 | 1 | 0 | 2 | 118 | 113 | 231 | |||||||||||||||||||||||||||||||||
2041302 | 2041302 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000410 | 440420 | West Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 59 | 162 | 25 | 3 | 9 | 1 | 6 | 151 | 114 | 265.0 | 59 | 162 | 25 | 3 | 9 | 1 | 6 | 151 | 114 | 265 | |||||||||||||||||||||||||||||||||
2041811 | 2041811 | MA | Middlesex | school | 2503840 | 67 | Concord | 250384000522 | 670305 | Concord Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 181 | 12 | 12 | 1 | 28 | 0 | 11 | 129 | 115 | 245.0 | 181 | 12 | 12 | 1 | 28 | 0 | 11 | 129 | 115 | 245 | |||||||||||||||||||||||||||||||||
2042450 | 2042450 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498001530 | 1000302 | Cameron Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 151 | 18 | 40 | 0 | 7 | 0 | 5 | 106 | 115 | 221.0 | 151 | 18 | 40 | 0 | 7 | 0 | 5 | 106 | 115 | 221 | |||||||||||||||||||||||||||||||||
2044620 | 2044620 | MA | Hampshire | school | 2508850 | 210 | Northampton | 250885001430 | 2100410 | John F Kennedy Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 129 | 9 | 38 | 0 | 11 | 0 | 16 | 87 | 116 | 203.0 | 129 | 9 | 38 | 0 | 11 | 0 | 16 | 87 | 116 | 203 | |||||||||||||||||||||||||||||||||
2048314 | 2048314 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414000562 | 6450305 | Mattacheese Middle School | Regular School | No | Middle | 06 | 07 | 2019 | grade_6 | 160 | 19 | 32 | 6 | 6 | 0 | 12 | 119 | 116 | 235.0 | 160 | 19 | 32 | 6 | 6 | 0 | 12 | 119 | 116 | 235 | |||||||||||||||||||||||||||||||||
2042262 | 2042262 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Morton Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 127 | 19 | 47 | 1 | 6 | 1 | 23 | 107 | 117 | 224.0 | 127 | 19 | 47 | 1 | 6 | 1 | 23 | 107 | 117 | 224 | |||||||||||||||||||||||||||||||||
2042578 | 2042578 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Ralph B O'Maley Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 175 | 3 | 19 | 3 | 3 | 0 | 1 | 87 | 117 | 204.0 | 175 | 3 | 19 | 3 | 3 | 0 | 1 | 87 | 117 | 204 | |||||||||||||||||||||||||||||||||
2044230 | 2044230 | MA | Middlesex | school | 2508340 | 198 | Natick | 250834001305 | 1980310 | Wilson Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 187 | 10 | 13 | 0 | 16 | 0 | 18 | 127 | 117 | 244.0 | 187 | 10 | 13 | 0 | 16 | 0 | 18 | 127 | 117 | 244 | |||||||||||||||||||||||||||||||||
2049133 | 2049133 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293000207 | 7800310 | Whitman Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 171 | 9 | 15 | 0 | 4 | 0 | 6 | 88 | 117 | 205.0 | 171 | 9 | 15 | 0 | 4 | 0 | 6 | 88 | 117 | 205 | |||||||||||||||||||||||||||||||||
2041910 | 2041910 | MA | Norfolk | school | 2504050 | 73 | Dedham | 250405000551 | 730305 | Dedham Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 177 | 15 | 43 | 1 | 7 | 0 | 12 | 137 | 118 | 255.0 | 177 | 15 | 43 | 1 | 7 | 0 | 12 | 137 | 118 | 255 | |||||||||||||||||||||||||||||||||
2042687 | 2042687 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579002548 | 1220305 | Hanover Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 197 | 5 | 8 | 0 | 5 | 0 | 3 | 100 | 118 | 218.0 | 197 | 5 | 8 | 0 | 5 | 0 | 3 | 100 | 118 | 218 | |||||||||||||||||||||||||||||||||
2047931 | 2047931 | MA | Suffolk | school | 2500063 | 484 | Roxbury Preparatory Charter (District) | 250006301453 | 4840505 | Roxbury Preparatory Charter School | Regular School | Yes | High | 05 | 12 | 2019 | grade_6 | 3 | 133 | 98 | 1 | 3 | 0 | 1 | 121 | 118 | 239.0 | 3 | 133 | 98 | 1 | 3 | 0 | 1 | 121 | 118 | 239 | |||||||||||||||||||||||||||||||||
2041741 | 2041741 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366000722 | 610310 | Dupont Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 122 | 9 | 111 | 1 | 8 | 0 | 9 | 141 | 119 | 260.0 | 122 | 9 | 111 | 1 | 8 | 0 | 9 | 141 | 119 | 260 | |||||||||||||||||||||||||||||||||
2040694 | 2040694 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000297 | 350255 | Oliver Hazard Perry | Regular School | No | Elementary | PK | 08 | 2019 | grade_6 | 10 | 8 | 3 | 1 | 2 | 0 | 1 | 13 | 12 | 25.0 | 10 | 8 | 3 | 1 | 2 | 0 | 1 | 13 | 12 | 25 | |||||||||||||||||||||||||||||||||
2042098 | 2042098 | MA | Franklin | school | 2504710 | 91 | Erving | 250471000626 | 910030 | Erving Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 17 | 0 | 0 | 0 | 0 | 0 | 3 | 8 | 12 | 20.0 | 17 | 0 | 0 | 0 | 0 | 0 | 3 | 8 | 12 | 20 | |||||||||||||||||||||||||||||||||
2047041 | 2047041 | MA | Franklin | school | 2512870 | 337 | Whately | 251287002126 | 3370005 | Whately Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 19 | 0 | 2 | 0 | 0 | 0 | 0 | 9 | 12 | 21.0 | 19 | 0 | 2 | 0 | 0 | 0 | 0 | 9 | 12 | 21 | |||||||||||||||||||||||||||||||||
2047678 | 2047678 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2019 | grade_6 | 0 | 17 | 2 | 0 | 0 | 0 | 0 | 7 | 12 | 19.0 | 0 | 17 | 2 | 0 | 0 | 0 | 0 | 7 | 12 | 19 | |||||||||||||||||||||||||||||||||
2048517 | 2048517 | MA | Hampden | school | 2505730 | 680 | Hampden-Wilbraham | 250573000822 | 6800005 | Green Meadows Elementary | Regular School | No | Elementary | PK | 08 | 2019 | grade_6 | 14 | 2 | 3 | 0 | 0 | 0 | 0 | 7 | 12 | 19.0 | 14 | 2 | 3 | 0 | 0 | 0 | 0 | 7 | 12 | 19 | |||||||||||||||||||||||||||||||||
2048862 | 2048862 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102398 | 7530005 | Hardwick Elementary | Regular School | No | Elementary | KG | 06 | 2019 | grade_6 | 25 | 1 | 3 | 0 | 0 | 0 | 0 | 17 | 12 | 29.0 | 25 | 1 | 3 | 0 | 0 | 0 | 0 | 17 | 12 | 29 | |||||||||||||||||||||||||||||||||
2043657 | 2043657 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001083 | 1630420 | Pickering Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 74 | 24 | 110 | 1 | 24 | 0 | 15 | 128 | 120 | 248.0 | 74 | 24 | 110 | 1 | 24 | 0 | 15 | 128 | 120 | 248 | |||||||||||||||||||||||||||||||||
2043759 | 2043759 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001112 | 1670035 | Harold L Qualters Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 222 | 11 | 17 | 1 | 13 | 0 | 5 | 146 | 123 | 269.0 | 222 | 11 | 17 | 1 | 13 | 0 | 5 | 146 | 123 | 269 | |||||||||||||||||||||||||||||||||
2046077 | 2046077 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Forest Park Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 26 | 46 | 162 | 0 | 13 | 0 | 8 | 131 | 124 | 255.0 | 26 | 46 | 162 | 0 | 13 | 0 | 8 | 131 | 124 | 255 | |||||||||||||||||||||||||||||||||
2046372 | 2046372 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001662 | 2930315 | Benjamin Friedman Middle | Regular School | No | Middle | 05 | 07 | 2019 | grade_6 | 194 | 26 | 26 | 0 | 2 | 0 | 13 | 137 | 124 | 261.0 | 194 | 26 | 26 | 0 | 2 | 0 | 13 | 137 | 124 | 261 | |||||||||||||||||||||||||||||||||
2041305 | 2041305 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002688 | 440421 | Ashfield Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 63 | 126 | 27 | 1 | 7 | 1 | 5 | 104 | 126 | 230.0 | 63 | 126 | 27 | 1 | 7 | 1 | 5 | 104 | 126 | 230 | |||||||||||||||||||||||||||||||||
2046393 | 2046393 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158001426 | 2950023 | John F. Ryan | Regular School | No | Middle | 05 | 06 | 2019 | grade_6 | 219 | 12 | 10 | 0 | 12 | 0 | 1 | 128 | 126 | 254.0 | 219 | 12 | 10 | 0 | 12 | 0 | 1 | 128 | 126 | 254 | |||||||||||||||||||||||||||||||||
2048407 | 2048407 | MA | Plymouth | school | 2505070 | 665 | Freetown-Lakeville | 250507000748 | 6650305 | Freetown-Lakeville Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 220 | 7 | 2 | 1 | 4 | 0 | 4 | 112 | 126 | 238.0 | 220 | 7 | 2 | 1 | 4 | 0 | 4 | 112 | 126 | 238 | |||||||||||||||||||||||||||||||||
2041308 | 2041308 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002691 | 440422 | Joseph F. Plouffe Academy | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 51 | 121 | 64 | 1 | 7 | 0 | 15 | 132 | 127 | 259.0 | 51 | 121 | 64 | 1 | 7 | 0 | 15 | 132 | 127 | 259 | |||||||||||||||||||||||||||||||||
2041182 | 2041182 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000364 | 400305 | East Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 154 | 27 | 17 | 0 | 62 | 0 | 2 | 134 | 128 | 262.0 | 154 | 27 | 17 | 0 | 62 | 0 | 2 | 134 | 128 | 262 | |||||||||||||||||||||||||||||||||
2042792 | 2042792 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000850 | 1280100 | Consentino Middle School | Regular School | No | Middle | 04 | 08 | 2019 | grade_6 | 127 | 13 | 103 | 1 | 7 | 0 | 3 | 126 | 128 | 254.0 | 127 | 13 | 103 | 1 | 7 | 0 | 3 | 126 | 128 | 254 | |||||||||||||||||||||||||||||||||
2044001 | 2044001 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762002557 | 1780305 | Melrose Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 222 | 14 | 12 | 0 | 13 | 0 | 12 | 145 | 128 | 273.0 | 222 | 14 | 12 | 0 | 13 | 0 | 12 | 145 | 128 | 273 | |||||||||||||||||||||||||||||||||
2044066 | 2044066 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777001378 | 1820305 | John T. Nichols Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 233 | 11 | 9 | 3 | 1 | 0 | 8 | 137 | 128 | 265.0 | 233 | 11 | 9 | 3 | 1 | 0 | 8 | 137 | 128 | 265 | |||||||||||||||||||||||||||||||||
2042456 | 2042456 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Walsh Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 135 | 8 | 73 | 0 | 10 | 0 | 16 | 112 | 129 | 242.0 | 135 | 8 | 73 | 0 | 10 | 0 | 16 | 112 | 129 | 242 | |||||||||||||||||||||||||||||||||
2048841 | 2048841 | MA | Franklin | school | 2509600 | 750 | Pioneer Valley | 250960002614 | 7500008 | Northfield Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 25 | 0 | 0 | 0 | 0 | 0 | 1 | 13 | 13 | 26.0 | 25 | 0 | 0 | 0 | 0 | 0 | 1 | 13 | 13 | 26 | |||||||||||||||||||||||||||||||||
2041185 | 2041185 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000372 | 400310 | South Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 181 | 11 | 9 | 0 | 50 | 0 | 1 | 122 | 130 | 252.0 | 181 | 11 | 9 | 0 | 50 | 0 | 1 | 122 | 130 | 252 | |||||||||||||||||||||||||||||||||
2046664 | 2046664 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002502 | 3150305 | Wayland Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 162 | 16 | 10 | 0 | 42 | 1 | 11 | 112 | 130 | 242.0 | 162 | 16 | 10 | 0 | 42 | 1 | 11 | 112 | 130 | 242 | |||||||||||||||||||||||||||||||||
2046481 | 2046481 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191000776 | 3050310 | Galvin Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | 219 | 7 | 25 | 0 | 6 | 0 | 11 | 137 | 131 | 268.0 | 219 | 7 | 25 | 0 | 6 | 0 | 11 | 137 | 131 | 268 | |||||||||||||||||||||||||||||||||
2046576 | 2046576 | MA | Middlesex | school | 2512000 | 308 | Waltham | 251200001977 | 3080415 | John W. McDevitt Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 79 | 25 | 128 | 0 | 12 | 0 | 3 | 115 | 132 | 247.0 | 79 | 25 | 128 | 0 | 12 | 0 | 3 | 115 | 132 | 247 | |||||||||||||||||||||||||||||||||
2042306 | 2042306 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000688 | 960305 | Morse Pond School | Regular School | No | Middle | 05 | 06 | 2019 | grade_6 | 210 | 16 | 15 | 2 | 10 | 0 | 16 | 136 | 133 | 269.0 | 210 | 16 | 15 | 2 | 10 | 0 | 16 | 136 | 133 | 269 | |||||||||||||||||||||||||||||||||
2041881 | 2041881 | MA | Bristol | school | 2504020 | 72 | Dartmouth | 250402000541 | 720050 | Dartmouth Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 272 | 3 | 11 | 0 | 2 | 1 | 18 | 173 | 134 | 307.0 | 272 | 3 | 11 | 0 | 2 | 1 | 18 | 173 | 134 | 307 | |||||||||||||||||||||||||||||||||
2044850 | 2044850 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001468 | 2200305 | Dr. Philip O. Coakley Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 175 | 26 | 31 | 0 | 17 | 1 | 5 | 121 | 134 | 255.0 | 175 | 26 | 31 | 0 | 17 | 1 | 5 | 121 | 134 | 255 | |||||||||||||||||||||||||||||||||
2039857 | 2039857 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000026 | 50303 | Roberta G. Doering School | Regular School | No | Middle | 05 | 07 | 2019 | grade_6 | 235 | 12 | 16 | 0 | 4 | 0 | 8 | 140 | 135 | 275.0 | 235 | 12 | 16 | 0 | 4 | 0 | 8 | 140 | 135 | 275 | |||||||||||||||||||||||||||||||||
2046938 | 2046938 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251001243 | 3320305 | West Springfield Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 201 | 12 | 58 | 0 | 25 | 1 | 8 | 170 | 135 | 305.0 | 201 | 12 | 58 | 0 | 25 | 1 | 8 | 170 | 135 | 305 | |||||||||||||||||||||||||||||||||
2041853 | 2041853 | MA | Essex | school | 2503990 | 71 | Danvers | 250399002517 | 710305 | Holten Richmond Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 221 | 11 | 26 | 1 | 4 | 0 | 10 | 137 | 136 | 273.0 | 221 | 11 | 26 | 1 | 4 | 0 | 10 | 137 | 136 | 273 | |||||||||||||||||||||||||||||||||
2044537 | 2044537 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000310 | 2070310 | Charles E Brown Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 182 | 8 | 19 | 1 | 48 | 0 | 16 | 136 | 138 | 274.0 | 182 | 8 | 19 | 1 | 48 | 0 | 16 | 136 | 138 | 274 | |||||||||||||||||||||||||||||||||
2041441 | 2041441 | MA | Middlesex | school | 2503240 | 48 | Burlington | 250324000429 | 480303 | Marshall Simonds Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 167 | 17 | 15 | 0 | 56 | 0 | 14 | 130 | 139 | 269.0 | 167 | 17 | 15 | 0 | 56 | 0 | 14 | 130 | 139 | 269 | |||||||||||||||||||||||||||||||||
2047064 | 2047064 | MA | Middlesex | school | 2513050 | 342 | Wilmington | 251305001578 | 3420330 | Wilmington Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 223 | 2 | 15 | 0 | 13 | 0 | 6 | 120 | 139 | 259.0 | 223 | 2 | 15 | 0 | 13 | 0 | 6 | 120 | 139 | 259 | |||||||||||||||||||||||||||||||||
2049079 | 2049079 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188000888 | 7750305 | Mountview Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 234 | 7 | 16 | 0 | 12 | 0 | 8 | 138 | 139 | 277.0 | 234 | 7 | 16 | 0 | 12 | 0 | 8 | 138 | 139 | 277 | |||||||||||||||||||||||||||||||||
2040782 | 2040782 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2019 | grade_6 | 2 | 8 | 20 | 0 | 0 | 0 | 1 | 17 | 14 | 31.0 | 2 | 8 | 20 | 0 | 0 | 0 | 1 | 17 | 14 | 31 | |||||||||||||||||||||||||||||||||
2044185 | 2044185 | MA | Essex | school | 2508220 | 196 | Nahant | 250822002394 | 1960010 | Johnson | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 14 | 23.0 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 14 | 23 | |||||||||||||||||||||||||||||||||
2044578 | 2044578 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001389 | 2090015 | Greylock | Regular School | No | Elementary | PK | 06 | 2019 | grade_6 | 25 | 1 | 4 | 0 | 0 | 1 | 3 | 20 | 14 | 34.0 | 25 | 1 | 4 | 0 | 0 | 1 | 3 | 20 | 14 | 34 | |||||||||||||||||||||||||||||||||
2047359 | 2047359 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002233 | 3480185 | Midland Street | Regular School | No | Elementary | KG | 06 | 2019 | grade_6 | 14 | 3 | 4 | 0 | 3 | 0 | 0 | 10 | 14 | 24.0 | 14 | 3 | 4 | 0 | 3 | 0 | 0 | 10 | 14 | 24 | |||||||||||||||||||||||||||||||||
2047660 | 2047660 | MA | Middlesex | school | 2500086 | 436 | Community Charter School of Cambridge (District) | 250008601996 | 4360305 | Community Charter School of Cambridge | Regular School | Yes | High | 06 | 12 | 2019 | grade_6 | 0 | 22 | 6 | 0 | 3 | 1 | 3 | 21 | 14 | 35.0 | 0 | 22 | 6 | 0 | 3 | 1 | 3 | 21 | 14 | 35 | |||||||||||||||||||||||||||||||||
2041294 | 2041294 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000389 | 440405 | East Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 34 | 179 | 34 | 2 | 2 | 0 | 11 | 122 | 140 | 262.0 | 34 | 179 | 34 | 2 | 2 | 0 | 11 | 122 | 140 | 262 | |||||||||||||||||||||||||||||||||
2041738 | 2041738 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366000491 | 610305 | Bellamy Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 143 | 9 | 120 | 0 | 5 | 0 | 11 | 148 | 140 | 288.0 | 143 | 9 | 120 | 0 | 5 | 0 | 11 | 148 | 140 | 288 | |||||||||||||||||||||||||||||||||
2041986 | 2041986 | MA | Plymouth | school | 2504410 | 82 | Duxbury | 250441000975 | 820305 | Duxbury Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 241 | 0 | 6 | 1 | 3 | 0 | 7 | 117 | 141 | 258.0 | 241 | 0 | 6 | 1 | 3 | 0 | 7 | 117 | 141 | 258 | |||||||||||||||||||||||||||||||||
2041573 | 2041573 | MA | Norfolk | school | 2503300 | 50 | Canton | 250330000456 | 500305 | Wm H Galvin Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 181 | 36 | 7 | 0 | 30 | 0 | 12 | 123 | 143 | 266.0 | 181 | 36 | 7 | 0 | 30 | 0 | 12 | 123 | 143 | 266 | |||||||||||||||||||||||||||||||||
2042265 | 2042265 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000671 | 950320 | Matthew J Kuss Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 139 | 18 | 64 | 0 | 11 | 0 | 22 | 111 | 143 | 254.0 | 139 | 18 | 64 | 0 | 11 | 0 | 22 | 111 | 143 | 254 |
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]);