enrollments
Data source: Big Local News · About: Big Local
3,471 rows where grade = "grade_7" and state = "MA" sorted by district_state_id 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
738231 | 738231 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | John J Ahern | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 192 | 11 | 6 | 0 | 6 | 0 | 5 | 108 | 112 | 220 | 192 | 11 | 6 | 0 | 6 | 0 | 5 | 108 | 112 | 220 | |||||||||||||||||||||||||||||||||
935084 | 935084 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | John J Ahern | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 177 | 5 | 5 | 0 | 7 | 0 | 2 | 99 | 97 | 196 | 177 | 5 | 5 | 0 | 7 | 0 | 2 | 99 | 97 | 196 | |||||||||||||||||||||||||||||||||
1124950 | 1124950 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | John J Ahern | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 185 | 8 | 12 | 2 | 4 | 0 | 3 | 113 | 101 | 214 | 185 | 8 | 12 | 2 | 4 | 0 | 3 | 113 | 101 | 214 | |||||||||||||||||||||||||||||||||
1367317 | 1367317 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | John J Ahern | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 181 | 13 | 8 | 1 | 8 | 0 | 5 | 117 | 99 | * | 216.0 | 181 | 13 | 8 | 1 | 8 | 0 | 5 | 117 | 99 | 216 | ||||||||||||||||||||||||||||||||
1674551 | 1674551 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | Foxborough - John J Ahern | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 172 | 13 | 16 | 1 | 8 | 0 | 5 | 115 | 100 | * | 215.0 | 172 | 13 | 16 | 1 | 8 | 0 | 5 | 115 | 100 | 215 | ||||||||||||||||||||||||||||||||
2042389 | 2042389 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | John J Ahern | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 172 | 17 | 14 | 0 | 5 | 1 | 5 | 109 | 104 | 214.0 | 172 | 17 | 14 | 0 | 5 | 1 | 5 | 109 | 104 | 214 | |||||||||||||||||||||||||||||||||
2231778 | 2231778 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | Foxborough: John J Ahern | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 177 | 9 | 8 | 2 | 3 | 0 | 5 | 93 | 111 | 204.0 | 177 | 9 | 8 | 2 | 3 | 0 | 5 | 93 | 111 | 204 | |||||||||||||||||||||||||||||||||
738211 | 738211 | MA | Berkshire | school | 2504920 | 98 | Florida | 250492000706 | 980005 | Abbott Memorial | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 8 | 2 | 0 | 0 | 0 | 0 | 1 | 7 | 4 | 11 | 8 | 2 | 0 | 0 | 0 | 0 | 1 | 7 | 4 | 11 | |||||||||||||||||||||||||||||||||
1124927 | 1124927 | MA | Berkshire | school | 2504920 | 98 | Florida | 250492000706 | 980005 | Abbott Memorial | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 5 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 5 | 11 | |||||||||||||||||||||||||||||||||
1367297 | 1367297 | MA | Berkshire | school | 2504920 | 98 | Florida | 250492000706 | 980005 | Abbott Memorial | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 13 | 1 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | * | 14.0 | 13 | 1 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | ||||||||||||||||||||||||||||||||
1674531 | 1674531 | MA | Berkshire | school | 2504920 | 98 | Florida | 250492000706 | 980005 | Florida - Abbott Memorial | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 7 | * | 18.0 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||
2042369 | 2042369 | MA | Berkshire | school | 2504920 | 98 | Florida | 250492000706 | 980005 | Abbott Memorial | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 7 | 9.0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 7 | 9 | |||||||||||||||||||||||||||||||||
738171 | 738171 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Intermediate | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 39 | 13 | 74 | 0 | 14 | 0 | 8 | 68 | 80 | 148 | 39 | 13 | 74 | 0 | 14 | 0 | 8 | 68 | 80 | 148 | |||||||||||||||||||||||||||||||||
738181 | 738181 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 44 | 7 | 47 | 0 | 6 | 0 | 8 | 66 | 46 | 112 | 44 | 7 | 47 | 0 | 6 | 0 | 8 | 66 | 46 | 112 | |||||||||||||||||||||||||||||||||
738191 | 738191 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002775 | 970340 | McKay Arts Academy | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 29 | 3 | 27 | 0 | 5 | 0 | 5 | 34 | 35 | 69 | 29 | 3 | 27 | 0 | 5 | 0 | 5 | 34 | 35 | 69 | |||||||||||||||||||||||||||||||||
935025 | 935025 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Intermediate | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 53 | 11 | 80 | 0 | 7 | 0 | 16 | 73 | 94 | 167 | 53 | 11 | 80 | 0 | 7 | 0 | 16 | 73 | 94 | 167 | |||||||||||||||||||||||||||||||||
935035 | 935035 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 35 | 8 | 58 | 0 | 3 | 0 | 9 | 58 | 55 | 113 | 35 | 8 | 58 | 0 | 3 | 0 | 9 | 58 | 55 | 113 | |||||||||||||||||||||||||||||||||
935045 | 935045 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002775 | 970340 | McKay Arts Academy | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 26 | 5 | 36 | 0 | 3 | 0 | 8 | 32 | 46 | 78 | 26 | 5 | 36 | 0 | 3 | 0 | 8 | 32 | 46 | 78 | |||||||||||||||||||||||||||||||||
1124882 | 1124882 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Intermediate | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 42 | 6 | 98 | 0 | 7 | 0 | 10 | 91 | 72 | 163 | 42 | 6 | 98 | 0 | 7 | 0 | 10 | 91 | 72 | 163 | |||||||||||||||||||||||||||||||||
1124894 | 1124894 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 38 | 6 | 49 | 0 | 7 | 0 | 10 | 62 | 48 | 110 | 38 | 6 | 49 | 0 | 7 | 0 | 10 | 62 | 48 | 110 | |||||||||||||||||||||||||||||||||
1124905 | 1124905 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002775 | 970340 | McKay Arts Academy | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 20 | 3 | 36 | 0 | 4 | 0 | 5 | 29 | 39 | 68 | 20 | 3 | 36 | 0 | 4 | 0 | 5 | 29 | 39 | 68 | |||||||||||||||||||||||||||||||||
1367258 | 1367258 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 43 | 7 | 83 | 0 | 14 | 0 | 13 | 79 | 81 | * | 160.0 | 43 | 7 | 83 | 0 | 14 | 0 | 13 | 79 | 81 | 160 | ||||||||||||||||||||||||||||||||
1367268 | 1367268 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 31 | 9 | 92 | 0 | 4 | 1 | 12 | 77 | 72 | * | 149.0 | 31 | 9 | 92 | 0 | 4 | 1 | 12 | 77 | 72 | 149 | ||||||||||||||||||||||||||||||||
1367278 | 1367278 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002775 | 970340 | McKay Arts Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 18 | 3 | 38 | 0 | 4 | 0 | 10 | 33 | 40 | * | 73.0 | 18 | 3 | 38 | 0 | 4 | 0 | 10 | 33 | 40 | 73 | ||||||||||||||||||||||||||||||||
1674492 | 1674492 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Fitchburg - Memorial Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 50 | 10 | 84 | 0 | 6 | 1 | 11 | 70 | 92 | * | 162.0 | 50 | 10 | 84 | 0 | 6 | 1 | 11 | 70 | 92 | 162 | ||||||||||||||||||||||||||||||||
1674502 | 1674502 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Fitchburg - Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 42 | 14 | 89 | 0 | 5 | 0 | 15 | 82 | 83 | * | 165.0 | 42 | 14 | 89 | 0 | 5 | 0 | 15 | 82 | 83 | 165 | ||||||||||||||||||||||||||||||||
1674512 | 1674512 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002775 | 970340 | Fitchburg - McKay Arts Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 9 | 6 | 41 | 0 | 1 | 0 | 4 | 27 | 34 | * | 61.0 | 9 | 6 | 41 | 0 | 1 | 0 | 4 | 27 | 34 | 61 | ||||||||||||||||||||||||||||||||
2042328 | 2042328 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 52 | 9 | 92 | 0 | 13 | 0 | 7 | 79 | 94 | 173.0 | 52 | 9 | 92 | 0 | 13 | 0 | 7 | 79 | 94 | 173 | |||||||||||||||||||||||||||||||||
2042338 | 2042338 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 35 | 12 | 92 | 0 | 7 | 0 | 10 | 87 | 69 | 156.0 | 35 | 12 | 92 | 0 | 7 | 0 | 10 | 87 | 69 | 156 | |||||||||||||||||||||||||||||||||
2042348 | 2042348 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002775 | 970340 | McKay Arts Academy | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 21 | 3 | 33 | 0 | 3 | 0 | 2 | 34 | 28 | 62.0 | 21 | 3 | 33 | 0 | 3 | 0 | 2 | 34 | 28 | 62 | |||||||||||||||||||||||||||||||||
2231710 | 2231710 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Fitchburg: Memorial Intermediate | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 54 | 12 | 95 | 0 | 12 | 0 | 10 | 93 | 90 | 183.0 | 54 | 12 | 95 | 0 | 12 | 0 | 10 | 93 | 90 | 183 | |||||||||||||||||||||||||||||||||
2231722 | 2231722 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Fitchburg: Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 42 | 12 | 88 | 0 | 8 | 0 | 8 | 88 | 70 | 158.0 | 42 | 12 | 88 | 0 | 8 | 0 | 8 | 88 | 70 | 158 | |||||||||||||||||||||||||||||||||
2231733 | 2231733 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002775 | 970340 | Fitchburg: McKay Arts Academy | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 25 | 1 | 33 | 0 | 3 | 0 | 5 | 25 | 42 | 67.0 | 25 | 1 | 33 | 0 | 3 | 0 | 5 | 25 | 42 | 67 | |||||||||||||||||||||||||||||||||
738151 | 738151 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Lawrence | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 247 | 14 | 9 | 1 | 7 | 0 | 18 | 152 | 144 | 296 | 247 | 14 | 9 | 1 | 7 | 0 | 18 | 152 | 144 | 296 | |||||||||||||||||||||||||||||||||
935005 | 935005 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Lawrence | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 233 | 10 | 7 | 4 | 7 | 0 | 19 | 136 | 144 | 280 | 233 | 10 | 7 | 4 | 7 | 0 | 19 | 136 | 144 | 280 | |||||||||||||||||||||||||||||||||
1124859 | 1124859 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Lawrence | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 229 | 14 | 17 | 4 | 7 | 0 | 19 | 157 | 133 | 290 | 229 | 14 | 17 | 4 | 7 | 0 | 19 | 157 | 133 | 290 | |||||||||||||||||||||||||||||||||
1367237 | 1367237 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Lawrence | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 205 | 15 | 14 | 1 | 13 | 0 | 18 | 142 | 124 | * | 266.0 | 205 | 15 | 14 | 1 | 13 | 0 | 18 | 142 | 124 | 266 | ||||||||||||||||||||||||||||||||
1674471 | 1674471 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Falmouth - Lawrence | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 197 | 9 | 15 | 9 | 3 | 0 | 20 | 131 | 122 | * | 253.0 | 197 | 9 | 15 | 9 | 3 | 0 | 20 | 131 | 122 | 253 | ||||||||||||||||||||||||||||||||
2042307 | 2042307 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Lawrence | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 212 | 18 | 17 | 2 | 3 | 0 | 14 | 131 | 135 | 266.0 | 212 | 18 | 17 | 2 | 3 | 0 | 14 | 131 | 135 | 266 | |||||||||||||||||||||||||||||||||
2231686 | 2231686 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Falmouth: Lawrence | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 257 | 17 | 16 | 1 | 5 | 1 | 15 | 151 | 161 | 312.0 | 257 | 17 | 16 | 1 | 5 | 1 | 15 | 151 | 161 | 312 | |||||||||||||||||||||||||||||||||
738074 | 738074 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000666 | 950045 | John J Doran | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 28 | 4 | 9 | 0 | 0 | 0 | 3 | 22 | 22 | 44 | 28 | 4 | 9 | 0 | 0 | 0 | 3 | 22 | 22 | 44 | |||||||||||||||||||||||||||||||||
738106 | 738106 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000655 | 950305 | Talbot Innovation School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 125 | 16 | 53 | 2 | 16 | 0 | 13 | 116 | 109 | 225 | 125 | 16 | 53 | 2 | 16 | 0 | 13 | 116 | 109 | 225 | |||||||||||||||||||||||||||||||||
738109 | 738109 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Morton Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 150 | 17 | 44 | 1 | 7 | 0 | 10 | 117 | 112 | 229 | 150 | 17 | 44 | 1 | 7 | 0 | 10 | 117 | 112 | 229 | |||||||||||||||||||||||||||||||||
738112 | 738112 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000671 | 950320 | Matthew J Kuss Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 165 | 12 | 57 | 0 | 12 | 1 | 11 | 124 | 134 | 258 | 165 | 12 | 57 | 0 | 12 | 1 | 11 | 124 | 134 | 258 | |||||||||||||||||||||||||||||||||
738119 | 738119 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002696 | 950326 | Stone Therapeutic Day Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 4 | 1 | 3 | 0 | 0 | 0 | 2 | 9 | * | 10 | 4 | 1 | 3 | 0 | 0 | 0 | 2 | 9 | 10 | ||||||||||||||||||||||||||||||||||
738121 | 738121 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002838 | 950335 | Resiliency Middle School | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 11 | 4 | 4 | 0 | 1 | 0 | 1 | 16 | 5 | 21 | 11 | 4 | 4 | 0 | 1 | 0 | 1 | 16 | 5 | 21 | |||||||||||||||||||||||||||||||||
934918 | 934918 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Henry Lord Community School | Regular School | No | 1 | PK | 07 | 2016 | grade_7 | 41 | 6 | 12 | 0 | 4 | 0 | 5 | 31 | 37 | 68 | 41 | 6 | 12 | 0 | 4 | 0 | 5 | 31 | 37 | 68 | |||||||||||||||||||||||||||||||||
934927 | 934927 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000666 | 950045 | John J Doran | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 30 | 2 | 19 | 0 | 3 | 0 | 4 | 31 | 27 | 58 | 30 | 2 | 19 | 0 | 3 | 0 | 4 | 31 | 27 | 58 | |||||||||||||||||||||||||||||||||
934956 | 934956 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000655 | 950305 | Talbot Innovation School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 113 | 13 | 56 | 0 | 13 | 0 | 6 | 94 | 107 | 201 | 113 | 13 | 56 | 0 | 13 | 0 | 6 | 94 | 107 | 201 | |||||||||||||||||||||||||||||||||
934959 | 934959 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Morton Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 126 | 14 | 37 | 0 | 8 | 1 | 15 | 111 | 90 | 201 | 126 | 14 | 37 | 0 | 8 | 1 | 15 | 111 | 90 | 201 | |||||||||||||||||||||||||||||||||
934962 | 934962 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000671 | 950320 | Matthew J Kuss Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 161 | 10 | 46 | 0 | 8 | 0 | 8 | 122 | 111 | 233 | 161 | 10 | 46 | 0 | 8 | 0 | 8 | 122 | 111 | 233 | |||||||||||||||||||||||||||||||||
934968 | 934968 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002838 | 950335 | Resiliency Middle School | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | |||||||||||||||||||||||||||||||||
934972 | 934972 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002852 | 950340 | Stone Day School | Regular School | No | 1 | 01 | 08 | 2016 | grade_7 | 2 | 1 | 5 | 0 | 0 | 0 | 1 | 7 | 2 | 9 | 2 | 1 | 5 | 0 | 0 | 0 | 1 | 7 | 2 | 9 | |||||||||||||||||||||||||||||||||
1124751 | 1124751 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Henry Lord Community School | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 33 | 2 | 20 | 0 | 6 | 0 | 7 | 30 | 38 | 68 | 33 | 2 | 20 | 0 | 6 | 0 | 7 | 30 | 38 | 68 | |||||||||||||||||||||||||||||||||
1124762 | 1124762 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000666 | 950045 | John J Doran | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 30 | 3 | 13 | 0 | 0 | 0 | 2 | 26 | 22 | 48 | 30 | 3 | 13 | 0 | 0 | 0 | 2 | 26 | 22 | 48 | |||||||||||||||||||||||||||||||||
1124795 | 1124795 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000655 | 950305 | Talbot Innovation School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 88 | 14 | 59 | 0 | 8 | 0 | 15 | 97 | 87 | 184 | 88 | 14 | 59 | 0 | 8 | 0 | 15 | 97 | 87 | 184 | |||||||||||||||||||||||||||||||||
1124799 | 1124799 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Morton Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 119 | 14 | 50 | 0 | 7 | 1 | 13 | 123 | 81 | 204 | 119 | 14 | 50 | 0 | 7 | 1 | 13 | 123 | 81 | 204 | |||||||||||||||||||||||||||||||||
1124803 | 1124803 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000671 | 950320 | Matthew J Kuss Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 151 | 15 | 51 | 2 | 13 | 0 | 17 | 112 | 137 | 249 | 151 | 15 | 51 | 2 | 13 | 0 | 17 | 112 | 137 | 249 | |||||||||||||||||||||||||||||||||
1124811 | 1124811 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002838 | 950335 | Resiliency Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 4 | 2 | 6 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 4 | 2 | 6 | |||||||||||||||||||||||||||||||||
1124819 | 1124819 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002852 | 950340 | Stone Day School | Regular School | No | Elementary | 02 | 08 | 2017 | grade_7 | 1 | 2 | 2 | 0 | 0 | 0 | 2 | 6 | * | 7 | 1 | 2 | 2 | 0 | 0 | 0 | 2 | 6 | 7 | ||||||||||||||||||||||||||||||||||
1367149 | 1367149 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Henry Lord Community School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 27 | 7 | 38 | 0 | 5 | 0 | 8 | 38 | 47 | * | 85.0 | 27 | 7 | 38 | 0 | 5 | 0 | 8 | 38 | 47 | 85 | ||||||||||||||||||||||||||||||||
1367159 | 1367159 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000666 | 950045 | John J Doran | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 26 | 2 | 21 | 0 | 0 | 0 | 4 | 27 | 26 | * | 53.0 | 26 | 2 | 21 | 0 | 0 | 0 | 4 | 27 | 26 | 53 | ||||||||||||||||||||||||||||||||
1367188 | 1367188 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000655 | 950305 | Talbot Innovation School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 81 | 10 | 63 | 0 | 8 | 0 | 13 | 98 | 77 | * | 175.0 | 81 | 10 | 63 | 0 | 8 | 0 | 13 | 98 | 77 | 175 | ||||||||||||||||||||||||||||||||
1367191 | 1367191 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Morton Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 127 | 19 | 46 | 1 | 6 | 1 | 16 | 99 | 117 | * | 216.0 | 127 | 19 | 46 | 1 | 6 | 1 | 16 | 99 | 117 | 216 | ||||||||||||||||||||||||||||||||
1367194 | 1367194 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000671 | 950320 | Matthew J Kuss Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 148 | 16 | 63 | 0 | 11 | 0 | 22 | 112 | 148 | * | 260.0 | 148 | 16 | 63 | 0 | 11 | 0 | 22 | 112 | 148 | 260 | ||||||||||||||||||||||||||||||||
1367198 | 1367198 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002852 | 950340 | Stone PK-12 School | Regular School | No | Other | 01 | 12 | 2020 | grade_7 | 2 | 2 | 5 | 0 | 0 | 0 | 2 | 9 | 2 | * | 11.0 | 2 | 2 | 5 | 0 | 0 | 0 | 2 | 9 | 2 | 11 | ||||||||||||||||||||||||||||||||
1367207 | 1367207 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002873 | 950525 | Resiliency Preparatory Academy | Alternative School | No | High | 07 | 12 | 2020 | grade_7 | 3 | 2 | 8 | 0 | 0 | 0 | 3 | 12 | 4 | * | 16.0 | 3 | 2 | 8 | 0 | 0 | 0 | 3 | 12 | 4 | 16 | ||||||||||||||||||||||||||||||||
1674380 | 1674380 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Fall River - Henry Lord Community School | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 38 | 6 | 25 | 0 | 3 | 0 | 15 | 52 | 35 | * | 87.0 | 38 | 6 | 25 | 0 | 3 | 0 | 15 | 52 | 35 | 87 | ||||||||||||||||||||||||||||||||
1674390 | 1674390 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000666 | 950045 | Fall River - John J Doran | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 24 | 3 | 17 | 0 | 1 | 0 | 3 | 25 | 23 | * | 48.0 | 24 | 3 | 17 | 0 | 1 | 0 | 3 | 25 | 23 | 48 | ||||||||||||||||||||||||||||||||
1674419 | 1674419 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000655 | 950305 | Fall River - Talbot Innovation School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 84 | 15 | 70 | 1 | 5 | 0 | 23 | 105 | 93 | * | 198.0 | 84 | 15 | 70 | 1 | 5 | 0 | 23 | 105 | 93 | 198 | ||||||||||||||||||||||||||||||||
1674422 | 1674422 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Fall River - Morton Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 127 | 22 | 59 | 1 | 10 | 0 | 16 | 132 | 103 | * | 235.0 | 127 | 22 | 59 | 1 | 10 | 0 | 16 | 132 | 103 | 235 | ||||||||||||||||||||||||||||||||
1674425 | 1674425 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000671 | 950320 | Fall River - Matthew J Kuss Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 144 | 13 | 52 | 0 | 12 | 0 | 24 | 116 | 129 | * | 245.0 | 144 | 13 | 52 | 0 | 12 | 0 | 24 | 116 | 129 | 245 | ||||||||||||||||||||||||||||||||
1674431 | 1674431 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002852 | 950340 | Fall River - Stone PK-12 School | Regular School | No | Other | 01 | 12 | 2021 | grade_7 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 7 | 1 | * | 8.0 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 7 | 1 | 8 | ||||||||||||||||||||||||||||||||
1674441 | 1674441 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002873 | 950525 | Fall River - Resiliency Preparatory Academy | Alternative School | No | High | 07 | 12 | 2021 | grade_7 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 3 | * | 7.0 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||
2042222 | 2042222 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Henry Lord Community School | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 18 | 7 | 18 | 0 | 2 | 0 | 6 | 34 | 17 | 51.0 | 18 | 7 | 18 | 0 | 2 | 0 | 6 | 34 | 17 | 51 | |||||||||||||||||||||||||||||||||
2042232 | 2042232 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000666 | 950045 | John J Doran | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 25 | 4 | 7 | 0 | 3 | 0 | 5 | 24 | 20 | 44.0 | 25 | 4 | 7 | 0 | 3 | 0 | 5 | 24 | 20 | 44 | |||||||||||||||||||||||||||||||||
2042260 | 2042260 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000655 | 950305 | Talbot Innovation School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 69 | 15 | 71 | 0 | 8 | 0 | 18 | 106 | 75 | 181.0 | 69 | 15 | 71 | 0 | 8 | 0 | 18 | 106 | 75 | 181 | |||||||||||||||||||||||||||||||||
2042263 | 2042263 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Morton Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 106 | 14 | 49 | 0 | 10 | 0 | 16 | 111 | 84 | 195.0 | 106 | 14 | 49 | 0 | 10 | 0 | 16 | 111 | 84 | 195 | |||||||||||||||||||||||||||||||||
2042266 | 2042266 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000671 | 950320 | Matthew J Kuss Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 144 | 29 | 40 | 0 | 13 | 0 | 14 | 111 | 129 | 240.0 | 144 | 29 | 40 | 0 | 13 | 0 | 14 | 111 | 129 | 240 | |||||||||||||||||||||||||||||||||
2042270 | 2042270 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002852 | 950340 | Stone PK-12 School | Regular School | No | Other | 01 | 12 | 2019 | grade_7 | 3 | 1 | 0 | 0 | 0 | 0 | 5 | 8 | 1 | 9.0 | 3 | 1 | 0 | 0 | 0 | 0 | 5 | 8 | 1 | 9 | |||||||||||||||||||||||||||||||||
2042278 | 2042278 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002873 | 950525 | Resiliency Preparatory Academy | Alternative School | No | High | 07 | 12 | 2019 | grade_7 | 9 | 1 | 5 | 0 | 0 | 0 | 2 | 7 | 10 | 17.0 | 9 | 1 | 5 | 0 | 0 | 0 | 2 | 7 | 10 | 17 | |||||||||||||||||||||||||||||||||
2231570 | 2231570 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Fall River: Henry Lord Community School | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 30 | 8 | 22 | 0 | 2 | 0 | 2 | 36 | 28 | 64.0 | 30 | 8 | 22 | 0 | 2 | 0 | 2 | 36 | 28 | 64 | |||||||||||||||||||||||||||||||||
2231581 | 2231581 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000666 | 950045 | Fall River: John J Doran | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 25 | 3 | 22 | 0 | 1 | 0 | 2 | 20 | 33 | 53.0 | 25 | 3 | 22 | 0 | 1 | 0 | 2 | 20 | 33 | 53 | |||||||||||||||||||||||||||||||||
2231614 | 2231614 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000655 | 950305 | Fall River: Talbot Innovation School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 87 | 13 | 55 | 0 | 10 | 0 | 8 | 96 | 77 | 173.0 | 87 | 13 | 55 | 0 | 10 | 0 | 8 | 96 | 77 | 173 | |||||||||||||||||||||||||||||||||
2231618 | 2231618 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Fall River: Morton Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 120 | 16 | 44 | 2 | 13 | 0 | 12 | 112 | 95 | 207.0 | 120 | 16 | 44 | 2 | 13 | 0 | 12 | 112 | 95 | 207 | |||||||||||||||||||||||||||||||||
2231622 | 2231622 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000671 | 950320 | Fall River: Matthew J Kuss Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 157 | 26 | 61 | 0 | 7 | 0 | 16 | 136 | 131 | 267.0 | 157 | 26 | 61 | 0 | 7 | 0 | 16 | 136 | 131 | 267 | |||||||||||||||||||||||||||||||||
2231628 | 2231628 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002852 | 950340 | Fall River: Stone PK-12 School | Regular School | No | Other | 02 | 12 | 2018 | grade_7 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | 7 | 1 | 8.0 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | 7 | 1 | 8 | |||||||||||||||||||||||||||||||||
2231644 | 2231644 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002858 | 950515 | Fall River: Fall River Gateway to College @ BCC | Regular School | No | High | 12 | 12 | 2018 | grade_7 | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2231651 | 2231651 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002873 | 950525 | Fall River: Resiliency Preparatory Academy | Alternative School | No | High | 07 | 12 | 2018 | grade_7 | 12 | 3 | 3 | 0 | 0 | 0 | 5 | 12 | 11 | 23.0 | 12 | 3 | 3 | 0 | 0 | 0 | 5 | 12 | 11 | 23 | |||||||||||||||||||||||||||||||||
738026 | 738026 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480002572 | 940305 | Hastings Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 138 | 1 | 6 | 0 | 3 | 0 | 1 | 78 | 71 | 149 | 138 | 1 | 6 | 0 | 3 | 0 | 1 | 78 | 71 | 149 | |||||||||||||||||||||||||||||||||
934878 | 934878 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480002572 | 940305 | Hastings Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 126 | 1 | 7 | 2 | 5 | 0 | 1 | 79 | 63 | 142 | 126 | 1 | 7 | 2 | 5 | 0 | 1 | 79 | 63 | 142 | |||||||||||||||||||||||||||||||||
1124705 | 1124705 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480002572 | 940305 | Hastings Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 127 | 1 | 6 | 0 | 3 | 0 | 4 | 74 | 67 | 141 | 127 | 1 | 6 | 0 | 3 | 0 | 4 | 74 | 67 | 141 | |||||||||||||||||||||||||||||||||
1367107 | 1367107 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480002572 | 940305 | Hastings Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 126 | 1 | 7 | 2 | 4 | 0 | 4 | 74 | 70 | * | 144.0 | 126 | 1 | 7 | 2 | 4 | 0 | 4 | 74 | 70 | 144 | ||||||||||||||||||||||||||||||||
1674338 | 1674338 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480002572 | 940305 | Fairhaven - Hastings Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 121 | 6 | 12 | 1 | 4 | 0 | 6 | 76 | 74 | * | 150.0 | 121 | 6 | 12 | 1 | 4 | 0 | 6 | 76 | 74 | 150 | ||||||||||||||||||||||||||||||||
2042180 | 2042180 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480002572 | 940305 | Hastings Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 138 | 2 | 8 | 0 | 5 | 0 | 6 | 90 | 69 | 159.0 | 138 | 2 | 8 | 0 | 5 | 0 | 6 | 90 | 69 | 159 | |||||||||||||||||||||||||||||||||
2231523 | 2231523 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480002572 | 940305 | Fairhaven: Hastings Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 145 | 3 | 10 | 1 | 4 | 0 | 5 | 83 | 85 | 168.0 | 145 | 3 | 10 | 1 | 4 | 0 | 5 | 83 | 85 | 168 | |||||||||||||||||||||||||||||||||
737957 | 737957 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000631 | 930010 | Sumner G. Whittier School | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 16 | 5 | 18 | 0 | 4 | 0 | 0 | 17 | 26 | 43 | 16 | 5 | 18 | 0 | 4 | 0 | 0 | 17 | 26 | 43 | |||||||||||||||||||||||||||||||||
737972 | 737972 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002033 | 930018 | Madeline English School | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 40 | 14 | 32 | 0 | 5 | 1 | 1 | 50 | 43 | 93 | 40 | 14 | 32 | 0 | 5 | 1 | 1 | 50 | 43 | 93 | |||||||||||||||||||||||||||||||||
737981 | 737981 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002038 | 930028 | George Keverian School | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 38 | 12 | 38 | 0 | 7 | 0 | 3 | 54 | 44 | 98 | 38 | 12 | 38 | 0 | 7 | 0 | 3 | 54 | 44 | 98 | |||||||||||||||||||||||||||||||||
737984 | 737984 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002787 | 930030 | Devens School | Regular School | No | 4 | 01 | 12 | 2015 | grade_7 | * | * | * | * | * | * | * | 2 | 1 | 3 | 2 | 1 | 3 |
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]);