enrollments
Data source: Big Local News · About: Big Local
3,471 rows where grade = "grade_7" and state = "MA" sorted by district_state_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
735666 | 735666 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000002 | 10405 | Frolio Middle School | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 146 | 2 | 4 | 0 | 2 | 0 | 2 | 77 | 79 | 156 | 146 | 2 | 4 | 0 | 2 | 0 | 2 | 77 | 79 | 156 | |||||||||||||||||||||||||||||||||
932544 | 932544 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000002 | 10405 | Frolio Middle School | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 150 | 7 | 8 | 0 | 1 | 0 | 3 | 90 | 79 | 169 | 150 | 7 | 8 | 0 | 1 | 0 | 3 | 90 | 79 | 169 | |||||||||||||||||||||||||||||||||
1121957 | 1121957 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000002 | 10405 | Frolio Middle School | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 142 | 2 | 9 | 0 | 5 | 0 | 1 | 84 | 75 | 159 | 142 | 2 | 9 | 0 | 5 | 0 | 1 | 84 | 75 | 159 | |||||||||||||||||||||||||||||||||
1364792 | 1364792 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000002 | 10405 | Abington Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 139 | 3 | 12 | 1 | 4 | 0 | 5 | 86 | 78 | * | 164.0 | 139 | 3 | 12 | 1 | 4 | 0 | 5 | 86 | 78 | 164 | ||||||||||||||||||||||||||||||||
1672016 | 1672016 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000002 | 10405 | Abington - Abington Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 128 | 7 | 17 | 2 | 4 | 0 | 3 | 84 | 77 | * | 161.0 | 128 | 7 | 17 | 2 | 4 | 0 | 3 | 84 | 77 | 161 | ||||||||||||||||||||||||||||||||
2039818 | 2039818 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000002 | 10405 | Abington Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 170 | 2 | 12 | 0 | 3 | 0 | 0 | 104 | 83 | 187.0 | 170 | 2 | 12 | 0 | 3 | 0 | 0 | 104 | 83 | 187 | |||||||||||||||||||||||||||||||||
2228765 | 2228765 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000002 | 10405 | Abington: Abington Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 155 | 7 | 12 | 0 | 2 | 0 | 2 | 85 | 93 | 178.0 | 155 | 7 | 12 | 0 | 2 | 0 | 2 | 85 | 93 | 178 | |||||||||||||||||||||||||||||||||
735850 | 735850 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 269 | 11 | 17 | 0 | 33 | 1 | 10 | 183 | 158 | 341 | 269 | 11 | 17 | 0 | 33 | 1 | 10 | 183 | 158 | 341 | |||||||||||||||||||||||||||||||||
932726 | 932726 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 303 | 15 | 22 | 0 | 28 | 0 | 14 | 189 | 193 | 382 | 303 | 15 | 22 | 0 | 28 | 0 | 14 | 189 | 193 | 382 | |||||||||||||||||||||||||||||||||
1122176 | 1122176 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 302 | 16 | 22 | 0 | 48 | 0 | 21 | 201 | 208 | 409 | 302 | 16 | 22 | 0 | 48 | 0 | 21 | 201 | 208 | 409 | |||||||||||||||||||||||||||||||||
1364974 | 1364974 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 321 | 15 | 33 | 1 | 53 | 1 | 31 | 247 | 207 | * | 455.0 | 321 | 15 | 33 | 1 | 53 | 1 | 31 | 247 | 207 | 455 | ||||||||||||||||||||||||||||||||
1672197 | 1672197 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Arlington - Ottoson Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 330 | 21 | 37 | 0 | 41 | 0 | 27 | 237 | 219 | * | 456.0 | 330 | 21 | 37 | 0 | 41 | 0 | 27 | 237 | 219 | 456 | ||||||||||||||||||||||||||||||||
2040001 | 2040001 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 329 | 10 | 29 | 0 | 52 | 2 | 19 | 205 | 236 | 441.0 | 329 | 10 | 29 | 0 | 52 | 2 | 19 | 205 | 236 | 441 | |||||||||||||||||||||||||||||||||
2228982 | 2228982 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Arlington: Ottoson Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 301 | 22 | 20 | 0 | 41 | 0 | 31 | 180 | 235 | 415.0 | 301 | 22 | 20 | 0 | 41 | 0 | 31 | 180 | 235 | 415 | |||||||||||||||||||||||||||||||||
738288 | 738288 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498001530 | 1000302 | Cameron Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 119 | 6 | 30 | 0 | 3 | 0 | 5 | 79 | 84 | 163 | 119 | 6 | 30 | 0 | 3 | 0 | 5 | 79 | 84 | 163 | |||||||||||||||||||||||||||||||||
738291 | 738291 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000464 | 1000305 | Fuller Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 78 | 11 | 54 | 0 | 4 | 0 | 10 | 90 | 67 | 157 | 78 | 11 | 54 | 0 | 4 | 0 | 10 | 90 | 67 | 157 | |||||||||||||||||||||||||||||||||
738294 | 738294 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Walsh Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 113 | 9 | 75 | 0 | 18 | 1 | 9 | 118 | 107 | 225 | 113 | 9 | 75 | 0 | 18 | 1 | 9 | 118 | 107 | 225 | |||||||||||||||||||||||||||||||||
935142 | 935142 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498001530 | 1000302 | Cameron Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 116 | 16 | 39 | 0 | 2 | 0 | 5 | 93 | 85 | 178 | 116 | 16 | 39 | 0 | 2 | 0 | 5 | 93 | 85 | 178 | |||||||||||||||||||||||||||||||||
935145 | 935145 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000464 | 1000305 | Fuller Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 74 | 10 | 58 | 0 | 4 | 0 | 4 | 84 | 66 | 150 | 74 | 10 | 58 | 0 | 4 | 0 | 4 | 84 | 66 | 150 | |||||||||||||||||||||||||||||||||
935148 | 935148 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Walsh Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 136 | 7 | 58 | 0 | 20 | 0 | 6 | 104 | 123 | 227 | 136 | 7 | 58 | 0 | 20 | 0 | 6 | 104 | 123 | 227 | |||||||||||||||||||||||||||||||||
1125021 | 1125021 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498001530 | 1000302 | Cameron Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 117 | 12 | 36 | 1 | 6 | 0 | 6 | 93 | 85 | 178 | 117 | 12 | 36 | 1 | 6 | 0 | 6 | 93 | 85 | 178 | |||||||||||||||||||||||||||||||||
1125025 | 1125025 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000464 | 1000305 | Fuller Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 78 | 9 | 55 | 0 | 3 | 1 | 0 | 79 | 67 | 146 | 78 | 9 | 55 | 0 | 3 | 1 | 0 | 79 | 67 | 146 | |||||||||||||||||||||||||||||||||
1125029 | 1125029 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Walsh Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 132 | 13 | 81 | 0 | 22 | 0 | 9 | 132 | 125 | 257 | 132 | 13 | 81 | 0 | 22 | 0 | 9 | 132 | 125 | 257 | |||||||||||||||||||||||||||||||||
1367380 | 1367380 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498001530 | 1000302 | Cameron Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 144 | 14 | 35 | 0 | 8 | 0 | 4 | 93 | 112 | * | 205.0 | 144 | 14 | 35 | 0 | 8 | 0 | 4 | 93 | 112 | 205 | ||||||||||||||||||||||||||||||||
1367383 | 1367383 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000464 | 1000305 | Fuller Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 67 | 21 | 101 | 0 | 2 | 0 | 5 | 115 | 81 | * | 196.0 | 67 | 21 | 101 | 0 | 2 | 0 | 5 | 115 | 81 | 196 | ||||||||||||||||||||||||||||||||
1367386 | 1367386 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Walsh Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 132 | 10 | 69 | 1 | 9 | 0 | 16 | 114 | 123 | * | 237.0 | 132 | 10 | 69 | 1 | 9 | 0 | 16 | 114 | 123 | 237 | ||||||||||||||||||||||||||||||||
1674614 | 1674614 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498001530 | 1000302 | Framingham - Cameron Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 136 | 13 | 42 | 0 | 2 | 0 | 10 | 107 | 96 | * | 203.0 | 136 | 13 | 42 | 0 | 2 | 0 | 10 | 107 | 96 | 203 | ||||||||||||||||||||||||||||||||
1674617 | 1674617 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000464 | 1000305 | Framingham - Fuller Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 58 | 15 | 101 | 1 | 4 | 0 | 8 | 111 | 76 | * | 187.0 | 58 | 15 | 101 | 1 | 4 | 0 | 8 | 111 | 76 | 187 | ||||||||||||||||||||||||||||||||
1674620 | 1674620 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Framingham - Walsh Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 148 | 9 | 86 | 0 | 16 | 0 | 7 | 127 | 139 | * | 266.0 | 148 | 9 | 86 | 0 | 16 | 0 | 7 | 127 | 139 | 266 | ||||||||||||||||||||||||||||||||
2042451 | 2042451 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498001530 | 1000302 | Cameron Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 121 | 13 | 36 | 0 | 7 | 0 | 9 | 101 | 85 | 186.0 | 121 | 13 | 36 | 0 | 7 | 0 | 9 | 101 | 85 | 186 | |||||||||||||||||||||||||||||||||
2042454 | 2042454 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000464 | 1000305 | Fuller Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 113 | 19 | 74 | 0 | 4 | 1 | 5 | 114 | 102 | 216.0 | 113 | 19 | 74 | 0 | 4 | 1 | 5 | 114 | 102 | 216 | |||||||||||||||||||||||||||||||||
2042457 | 2042457 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Walsh Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 146 | 8 | 82 | 0 | 9 | 0 | 4 | 130 | 119 | 249.0 | 146 | 8 | 82 | 0 | 9 | 0 | 4 | 130 | 119 | 249 | |||||||||||||||||||||||||||||||||
2231850 | 2231850 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498001530 | 1000302 | Framingham: Cameron Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 127 | 9 | 22 | 0 | 3 | 0 | 7 | 77 | 91 | 168.0 | 127 | 9 | 22 | 0 | 3 | 0 | 7 | 77 | 91 | 168 | |||||||||||||||||||||||||||||||||
2231854 | 2231854 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000464 | 1000305 | Framingham: Fuller Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 59 | 20 | 63 | 0 | 5 | 1 | 10 | 80 | 78 | 158.0 | 59 | 20 | 63 | 0 | 5 | 1 | 10 | 80 | 78 | 158 | |||||||||||||||||||||||||||||||||
2231858 | 2231858 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Framingham: Walsh Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 135 | 14 | 75 | 0 | 14 | 0 | 5 | 135 | 108 | 243.0 | 135 | 14 | 75 | 0 | 14 | 0 | 5 | 135 | 108 | 243 | |||||||||||||||||||||||||||||||||
738338 | 738338 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001785 | 1010040 | Annie Sullivan Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 141 | 2 | 4 | 0 | 4 | 0 | 0 | 80 | 71 | 151 | 141 | 2 | 4 | 0 | 4 | 0 | 0 | 80 | 71 | 151 | |||||||||||||||||||||||||||||||||
738341 | 738341 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000871 | 1010310 | Remington Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 141 | 1 | 2 | 0 | 8 | 2 | 7 | 81 | 80 | 161 | 141 | 1 | 2 | 0 | 8 | 2 | 7 | 81 | 80 | 161 | |||||||||||||||||||||||||||||||||
738344 | 738344 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000738 | 1010405 | Horace Mann | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 136 | 0 | 2 | 1 | 8 | 0 | 5 | 76 | 76 | 152 | 136 | 0 | 2 | 1 | 8 | 0 | 5 | 76 | 76 | 152 | |||||||||||||||||||||||||||||||||
935192 | 935192 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001785 | 1010040 | Annie Sullivan Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 141 | 3 | 1 | 0 | 7 | 0 | 1 | 79 | 74 | 153 | 141 | 3 | 1 | 0 | 7 | 0 | 1 | 79 | 74 | 153 | |||||||||||||||||||||||||||||||||
935195 | 935195 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000871 | 1010310 | Remington Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 143 | 4 | 6 | 1 | 6 | 0 | 4 | 92 | 72 | 164 | 143 | 4 | 6 | 1 | 6 | 0 | 4 | 92 | 72 | 164 | |||||||||||||||||||||||||||||||||
935198 | 935198 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000738 | 1010405 | Horace Mann | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 135 | 2 | 0 | 1 | 12 | 0 | 2 | 72 | 80 | 152 | 135 | 2 | 0 | 1 | 12 | 0 | 2 | 72 | 80 | 152 | |||||||||||||||||||||||||||||||||
1125082 | 1125082 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001785 | 1010040 | Annie Sullivan Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 140 | 0 | 5 | 0 | 6 | 2 | 1 | 81 | 73 | 154 | 140 | 0 | 5 | 0 | 6 | 2 | 1 | 81 | 73 | 154 | |||||||||||||||||||||||||||||||||
1125086 | 1125086 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000871 | 1010310 | Remington Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 137 | 1 | 6 | 0 | 8 | 0 | 5 | 83 | 74 | 157 | 137 | 1 | 6 | 0 | 8 | 0 | 5 | 83 | 74 | 157 | |||||||||||||||||||||||||||||||||
1125090 | 1125090 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000738 | 1010405 | Horace Mann | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 136 | 3 | 4 | 0 | 13 | 0 | 1 | 83 | 74 | 157 | 136 | 3 | 4 | 0 | 13 | 0 | 1 | 83 | 74 | 157 | |||||||||||||||||||||||||||||||||
1367430 | 1367430 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001785 | 1010040 | Annie Sullivan Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 105 | 2 | 10 | 1 | 4 | 0 | 0 | 68 | 54 | * | 122.0 | 105 | 2 | 10 | 1 | 4 | 0 | 0 | 68 | 54 | 122 | ||||||||||||||||||||||||||||||||
1367433 | 1367433 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000871 | 1010310 | Remington Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 104 | 5 | 6 | 0 | 10 | 0 | 1 | 69 | 57 | * | 126.0 | 104 | 5 | 6 | 0 | 10 | 0 | 1 | 69 | 57 | 126 | ||||||||||||||||||||||||||||||||
1367436 | 1367436 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000738 | 1010405 | Horace Mann | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 140 | 2 | 10 | 0 | 13 | 0 | 2 | 100 | 67 | * | 167.0 | 140 | 2 | 10 | 0 | 13 | 0 | 2 | 100 | 67 | 167 | ||||||||||||||||||||||||||||||||
1674664 | 1674664 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001785 | 1010040 | Franklin - Annie Sullivan Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 109 | 6 | 9 | 0 | 6 | 0 | 1 | 66 | 65 | * | 131.0 | 109 | 6 | 9 | 0 | 6 | 0 | 1 | 66 | 65 | 131 | ||||||||||||||||||||||||||||||||
1674667 | 1674667 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000871 | 1010310 | Franklin - Remington Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 104 | 4 | 5 | 1 | 6 | 0 | 1 | 64 | 57 | * | 121.0 | 104 | 4 | 5 | 1 | 6 | 0 | 1 | 64 | 57 | 121 | ||||||||||||||||||||||||||||||||
1674670 | 1674670 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000738 | 1010405 | Franklin - Horace Mann | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 111 | 2 | 4 | 0 | 8 | 2 | 4 | 70 | 61 | * | 131.0 | 111 | 2 | 4 | 0 | 8 | 2 | 4 | 70 | 61 | 131 | ||||||||||||||||||||||||||||||||
2042501 | 2042501 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001785 | 1010040 | Annie Sullivan Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 109 | 3 | 5 | 0 | 6 | 1 | 3 | 62 | 65 | 127.0 | 109 | 3 | 5 | 0 | 6 | 1 | 3 | 62 | 65 | 127 | |||||||||||||||||||||||||||||||||
2042504 | 2042504 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000871 | 1010310 | Remington Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 137 | 4 | 2 | 0 | 7 | 1 | 4 | 78 | 77 | 155.0 | 137 | 4 | 2 | 0 | 7 | 1 | 4 | 78 | 77 | 155 | |||||||||||||||||||||||||||||||||
2042507 | 2042507 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000738 | 1010405 | Horace Mann | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 132 | 2 | 4 | 0 | 8 | 0 | 3 | 76 | 73 | 149.0 | 132 | 2 | 4 | 0 | 8 | 0 | 3 | 76 | 73 | 149 | |||||||||||||||||||||||||||||||||
2231911 | 2231911 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001785 | 1010040 | Franklin: Annie Sullivan Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 149 | 0 | 4 | 0 | 5 | 0 | 1 | 89 | 70 | 159.0 | 149 | 0 | 4 | 0 | 5 | 0 | 1 | 89 | 70 | 159 | |||||||||||||||||||||||||||||||||
2231915 | 2231915 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000871 | 1010310 | Franklin: Remington Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 118 | 3 | 5 | 0 | 9 | 0 | 1 | 62 | 74 | 136.0 | 118 | 3 | 5 | 0 | 9 | 0 | 1 | 62 | 74 | 136 | |||||||||||||||||||||||||||||||||
2231919 | 2231919 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000738 | 1010405 | Franklin: Horace Mann | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 129 | 0 | 5 | 0 | 11 | 0 | 6 | 64 | 87 | 151.0 | 129 | 0 | 5 | 0 | 11 | 0 | 6 | 64 | 87 | 151 | |||||||||||||||||||||||||||||||||
738362 | 738362 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 164 | 10 | 26 | 0 | 4 | 0 | 9 | 108 | 105 | 213 | 164 | 10 | 26 | 0 | 4 | 0 | 9 | 108 | 105 | 213 | |||||||||||||||||||||||||||||||||
935213 | 935213 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner Middle School | Regular School | No | 2 | 05 | 07 | 2016 | grade_7 | 149 | 3 | 24 | 0 | 3 | 0 | 10 | 99 | 90 | 189 | 149 | 3 | 24 | 0 | 3 | 0 | 10 | 99 | 90 | 189 | |||||||||||||||||||||||||||||||||
1125108 | 1125108 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner Middle School | Regular School | No | Middle | 05 | 07 | 2017 | grade_7 | 123 | 6 | 30 | 1 | 3 | 0 | 18 | 96 | 85 | 181 | 123 | 6 | 30 | 1 | 3 | 0 | 18 | 96 | 85 | 181 | |||||||||||||||||||||||||||||||||
1367451 | 1367451 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner Middle School | Regular School | No | Middle | 05 | 07 | 2020 | grade_7 | 126 | 3 | 47 | 0 | 5 | 0 | 19 | 104 | 96 | * | 200.0 | 126 | 3 | 47 | 0 | 5 | 0 | 19 | 104 | 96 | 200 | ||||||||||||||||||||||||||||||||
1674685 | 1674685 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner - Gardner Middle School | Regular School | No | Middle | 05 | 07 | 2021 | grade_7 | 117 | 4 | 38 | 0 | 4 | 0 | 13 | 96 | 80 | * | 176.0 | 117 | 4 | 38 | 0 | 4 | 0 | 13 | 96 | 80 | 176 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2231937 | 2231937 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner: Gardner Middle School | Regular School | No | Middle | 05 | 07 | 2018 | grade_7 | 97 | 1 | 28 | 0 | 5 | 0 | 15 | 70 | 76 | 146.0 | 97 | 1 | 28 | 0 | 5 | 0 | 15 | 70 | 76 | 146 | |||||||||||||||||||||||||||||||||
738381 | 738381 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522002764 | 1050305 | Georgetown Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 121 | 0 | 2 | 0 | 0 | 0 | 4 | 67 | 60 | 127 | 121 | 0 | 2 | 0 | 0 | 0 | 4 | 67 | 60 | 127 | |||||||||||||||||||||||||||||||||
935232 | 935232 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522002764 | 1050305 | Georgetown Middle School | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 111 | 0 | 0 | 0 | 2 | 0 | 1 | 59 | 55 | 114 | 111 | 0 | 0 | 0 | 2 | 0 | 1 | 59 | 55 | 114 | |||||||||||||||||||||||||||||||||
1125131 | 1125131 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522002764 | 1050305 | Georgetown Middle School | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 112 | 1 | 1 | 0 | 2 | 0 | 1 | 66 | 51 | 117 | 112 | 1 | 1 | 0 | 2 | 0 | 1 | 66 | 51 | 117 | |||||||||||||||||||||||||||||||||
1367469 | 1367469 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522002764 | 1050305 | Georgetown Middle School | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 84 | 0 | 1 | 0 | 2 | 1 | 0 | 41 | 47 | * | 88.0 | 84 | 0 | 1 | 0 | 2 | 1 | 0 | 41 | 47 | 88 | ||||||||||||||||||||||||||||||||
1674704 | 1674704 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522002764 | 1050305 | Georgetown - Georgetown Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 111 | 2 | 1 | 0 | 0 | 1 | 1 | 59 | 57 | * | 116.0 | 111 | 2 | 1 | 0 | 0 | 1 | 1 | 59 | 57 | 116 | ||||||||||||||||||||||||||||||||
2042541 | 2042541 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522002764 | 1050305 | Georgetown Middle School | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 94 | 1 | 2 | 0 | 0 | 0 | 0 | 51 | 46 | 97.0 | 94 | 1 | 2 | 0 | 0 | 0 | 0 | 51 | 46 | 97 | |||||||||||||||||||||||||||||||||
2231960 | 2231960 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522002764 | 1050305 | Georgetown: Georgetown Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 107 | 2 | 1 | 0 | 1 | 0 | 1 | 62 | 50 | 112.0 | 107 | 2 | 1 | 0 | 1 | 0 | 1 | 62 | 50 | 112 | |||||||||||||||||||||||||||||||||
738419 | 738419 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Ralph B O'Maley Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 171 | 3 | 15 | 0 | 4 | 3 | 7 | 95 | 108 | 203 | 171 | 3 | 15 | 0 | 4 | 3 | 7 | 95 | 108 | 203 | |||||||||||||||||||||||||||||||||
935270 | 935270 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Ralph B O'Maley Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 161 | 0 | 20 | 1 | 0 | 1 | 3 | 87 | 99 | 186 | 161 | 0 | 20 | 1 | 0 | 1 | 3 | 87 | 99 | 186 | |||||||||||||||||||||||||||||||||
1125177 | 1125177 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Ralph B O'Maley Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 206 | 3 | 17 | 0 | 2 | 0 | 6 | 119 | 115 | 234 | 206 | 3 | 17 | 0 | 2 | 0 | 6 | 119 | 115 | 234 | |||||||||||||||||||||||||||||||||
1367507 | 1367507 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Ralph B O'Maley Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 173 | 2 | 21 | 3 | 1 | 0 | 2 | 86 | 116 | * | 202.0 | 173 | 2 | 21 | 3 | 1 | 0 | 2 | 86 | 116 | 202 | ||||||||||||||||||||||||||||||||
1674742 | 1674742 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Gloucester - Ralph B O'Maley Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 166 | 2 | 23 | 1 | 3 | 0 | 6 | 104 | 97 | * | 201.0 | 166 | 2 | 23 | 1 | 3 | 0 | 6 | 104 | 97 | 201 | ||||||||||||||||||||||||||||||||
2042579 | 2042579 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Ralph B O'Maley Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 202 | 4 | 12 | 0 | 4 | 1 | 7 | 120 | 110 | 230.0 | 202 | 4 | 12 | 0 | 4 | 1 | 7 | 120 | 110 | 230 | |||||||||||||||||||||||||||||||||
2232006 | 2232006 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Gloucester: Ralph B O'Maley Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 169 | 5 | 14 | 1 | 4 | 2 | 18 | 123 | 90 | 213.0 | 169 | 5 | 14 | 1 | 4 | 2 | 18 | 123 | 90 | 213 | |||||||||||||||||||||||||||||||||
1125193 | 1125193 | MA | Dukes | school | 2505340 | 109 | Gosnold | 250534000725 | 1090005 | Cuttyhunk Elementary | Regular School | No | Middle | 06 | 07 | 2017 | grade_7 | * | * | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||
1374314 | 1374314 | MA | Dukes | school | 2505340 | 109 | Gosnold | 250534000725 | 1090005 | Cuttyhunk Elementary | Regular School | No | Ungraded | UG | UG | 2020 | grade_7 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1674757 | 1674757 | MA | Dukes | school | 2505340 | 109 | Gosnold | 250534000725 | 1090005 | Gosnold - Cuttyhunk Elementary | Regular School | No | Middle | 07 | 07 | 2021 | grade_7 | * | * | * | * | * | * | * | * | * | * | 2.0 | 2 | |||||||||||||||||||||||||||||||||||||||||
2232022 | 2232022 | MA | Dukes | school | 2505340 | 109 | Gosnold | 250534000725 | 1090005 | Gosnold: Cuttyhunk Elementary | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | * | * | * | * | * | * | * | * | * | 1.0 | 1 | ||||||||||||||||||||||||||||||||||||||||||
738443 | 738443 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton Middle | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 203 | 0 | 12 | 0 | 33 | 0 | 3 | 138 | 113 | 251 | 203 | 0 | 12 | 0 | 33 | 0 | 3 | 138 | 113 | 251 | |||||||||||||||||||||||||||||||||
935295 | 935295 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton Middle | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 176 | 4 | 9 | 0 | 23 | 0 | 8 | 107 | 113 | 220 | 176 | 4 | 9 | 0 | 23 | 0 | 8 | 107 | 113 | 220 | |||||||||||||||||||||||||||||||||
1125220 | 1125220 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 220 | 3 | 9 | 0 | 30 | 0 | 9 | 135 | 136 | 271 | 220 | 3 | 9 | 0 | 30 | 0 | 9 | 135 | 136 | 271 | |||||||||||||||||||||||||||||||||
1367530 | 1367530 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 214 | 3 | 17 | 0 | 26 | 0 | 10 | 150 | 120 | * | 270.0 | 214 | 3 | 17 | 0 | 26 | 0 | 10 | 150 | 120 | 270 | ||||||||||||||||||||||||||||||||
1674780 | 1674780 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton - Grafton Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 186 | 6 | 20 | 1 | 28 | 0 | 5 | 138 | 108 | * | 246.0 | 186 | 6 | 20 | 1 | 28 | 0 | 5 | 138 | 108 | 246 | ||||||||||||||||||||||||||||||||
2042602 | 2042602 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton Middle | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 189 | 4 | 16 | 2 | 30 | 2 | 6 | 128 | 121 | 249.0 | 189 | 4 | 16 | 2 | 30 | 2 | 6 | 128 | 121 | 249 | |||||||||||||||||||||||||||||||||
2232049 | 2232049 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton: Grafton Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 215 | 6 | 7 | 0 | 24 | 0 | 5 | 117 | 140 | 257.0 | 215 | 6 | 7 | 0 | 24 | 0 | 5 | 117 | 140 | 257 | |||||||||||||||||||||||||||||||||
738458 | 738458 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby Jr Sr High School | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 60 | 0 | 3 | 0 | 3 | 0 | 1 | 36 | 31 | 67 | 60 | 0 | 3 | 0 | 3 | 0 | 1 | 36 | 31 | 67 | |||||||||||||||||||||||||||||||||
935309 | 935309 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby Jr Sr High School | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 52 | 1 | 6 | 0 | 3 | 0 | 0 | 38 | 24 | 62 | 52 | 1 | 6 | 0 | 3 | 0 | 0 | 38 | 24 | 62 | |||||||||||||||||||||||||||||||||
1125238 | 1125238 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby Jr Sr High School | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 68 | 1 | 5 | 0 | 0 | 0 | 0 | 41 | 33 | 74 | 68 | 1 | 5 | 0 | 0 | 0 | 0 | 41 | 33 | 74 | |||||||||||||||||||||||||||||||||
1367544 | 1367544 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby Jr Sr High School | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 47 | 0 | 4 | 0 | 0 | 0 | 1 | 29 | 23 | * | 52.0 | 47 | 0 | 4 | 0 | 0 | 0 | 1 | 29 | 23 | 52 | ||||||||||||||||||||||||||||||||
1674794 | 1674794 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby - Granby Jr Sr High School | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 42 | 0 | 6 | 0 | 1 | 0 | 2 | 30 | 20 | * | 51.0 | 42 | 0 | 6 | 0 | 1 | 0 | 2 | 30 | 20 | 51 | ||||||||||||||||||||||||||||||||
2042617 | 2042617 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby Jr Sr High School | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 50 | 0 | 4 | 0 | 1 | 0 | 1 | 27 | 29 | 56.0 | 50 | 0 | 4 | 0 | 1 | 0 | 1 | 27 | 29 | 56 | |||||||||||||||||||||||||||||||||
2232067 | 2232067 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby: Granby Jr Sr High School | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 51 | 0 | 6 | 0 | 0 | 0 | 1 | 39 | 19 | 58.0 | 51 | 0 | 6 | 0 | 0 | 0 | 1 | 39 | 19 | 58 | |||||||||||||||||||||||||||||||||
738476 | 738476 | MA | Franklin | school | 2505490 | 114 | Greenfield | 250549002771 | 1140030 | Green River | Regular School | No | 2 | 04 | 07 | 2015 | grade_7 | * | * | * | * | * | * | * | 3 | * | 3 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||
738484 | 738484 | MA | Franklin | school | 2505490 | 114 | Greenfield | 250549000800 | 1140305 | Greenfield Middle | Regular School | No | 2 | 04 | 07 | 2015 | grade_7 | 71 | 2 | 18 | 0 | 2 | 0 | 5 | 55 | 43 | 98 | 71 | 2 | 18 | 0 | 2 | 0 | 5 | 55 | 43 | 98 | |||||||||||||||||||||||||||||||||
935335 | 935335 | MA | Franklin | school | 2505490 | 114 | Greenfield | 250549000800 | 1140305 | Greenfield Middle | Regular School | No | 2 | 04 | 07 | 2016 | grade_7 | 63 | 0 | 17 | 0 | 3 | 0 | 11 | 55 | 39 | 94 | 63 | 0 | 17 | 0 | 3 | 0 | 11 | 55 | 39 | 94 | |||||||||||||||||||||||||||||||||
1125267 | 1125267 | MA | Franklin | school | 2505490 | 114 | Greenfield | 250549002771 | 1140030 | Green River | Regular School | No | Elementary | 04 | 04 | 2017 | grade_7 | * | * | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||
1125283 | 1125283 | MA | Franklin | school | 2505490 | 114 | Greenfield | 250549000800 | 1140305 | Greenfield Middle | Regular School | No | Elementary | 04 | 07 | 2017 | grade_7 | 88 | 4 | 20 | 0 | 4 | 0 | 9 | 66 | 59 | 125 | 88 | 4 | 20 | 0 | 4 | 0 | 9 | 66 | 59 | 125 |
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]);