enrollments
Data source: Big Local News · About: Big Local
6,218 rows where grade = "grade_5" and state = "MA" sorted by hispanic_int 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1368743 | 1368743 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | 1 LT Charles W. Whitcomb School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 158 | 13 | 215 | 0 | 8 | 0 | 19 | 198 | 215 | * | 413.0 | 158 | 13 | 215 | 0 | 8 | 0 | 19 | 198 | 215 | 413 | ||||||||||||||||||||||||||||||||
2043813 | 2043813 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | 1 LT Charles W. Whitcomb School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 152 | 12 | 210 | 1 | 15 | 0 | 12 | 219 | 183 | 402.0 | 152 | 12 | 210 | 1 | 15 | 0 | 12 | 219 | 183 | 402 | |||||||||||||||||||||||||||||||||
2233496 | 2233496 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | Marlborough: 1 LT Charles W. Whitcomb School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 184 | 10 | 181 | 0 | 11 | 0 | 9 | 198 | 197 | 395.0 | 184 | 10 | 181 | 0 | 11 | 0 | 9 | 198 | 197 | 395 | |||||||||||||||||||||||||||||||||
2041663 | 2041663 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Clark Avenue School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 13 | 8 | 175 | 1 | 1 | 1 | 2 | 96 | 105 | 201.0 | 13 | 8 | 175 | 1 | 1 | 1 | 2 | 96 | 105 | 201 | |||||||||||||||||||||||||||||||||
936517 | 936517 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | 1 LT Charles W. Whitcomb School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 180 | 12 | 162 | 0 | 17 | 0 | 10 | 202 | 179 | 381 | 180 | 12 | 162 | 0 | 17 | 0 | 10 | 202 | 179 | 381 | |||||||||||||||||||||||||||||||||
1366594 | 1366594 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Clark Avenue School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 13 | 6 | 159 | 0 | 1 | 0 | 2 | 95 | 86 | * | 181.0 | 13 | 6 | 159 | 0 | 1 | 0 | 2 | 95 | 86 | 181 | ||||||||||||||||||||||||||||||||
1673825 | 1673825 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Chelsea - Clark Avenue School | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 10 | 5 | 159 | 0 | 0 | 0 | 2 | 95 | 81 | * | 176.0 | 10 | 5 | 159 | 0 | 0 | 0 | 2 | 95 | 81 | 176 | ||||||||||||||||||||||||||||||||
1126675 | 1126675 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | 1 LT Charles W. Whitcomb School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 162 | 9 | 156 | 0 | 19 | 0 | 18 | 168 | 196 | 364 | 162 | 9 | 156 | 0 | 19 | 0 | 18 | 168 | 196 | 364 | |||||||||||||||||||||||||||||||||
2230924 | 2230924 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001776 | 570055 | Chelsea: Joseph A. Browne School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 5 | 4 | 154 | 0 | 2 | 0 | 0 | 83 | 82 | 165.0 | 5 | 4 | 154 | 0 | 2 | 0 | 0 | 83 | 82 | 165 | |||||||||||||||||||||||||||||||||
1675214 | 1675214 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001918 | 1490004 | Lawrence - South Lawrence East Elementary School | Regular School | No | Elementary | 01 | 05 | 2021 | grade_5 | 3 | 2 | 143 | 0 | 0 | 0 | 0 | 80 | 68 | * | 148.0 | 3 | 2 | 143 | 0 | 0 | 0 | 0 | 80 | 68 | 148 | ||||||||||||||||||||||||||||||||
2043088 | 2043088 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002623 | 1490027 | Parthum Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 5 | 1 | 142 | 0 | 1 | 0 | 1 | 75 | 75 | 150.0 | 5 | 1 | 142 | 0 | 1 | 0 | 1 | 75 | 75 | 150 | |||||||||||||||||||||||||||||||||
738969 | 738969 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002758 | 1490085 | Spark Academy | Regular School | No | 2 | 05 | 07 | 2015 | grade_5 | 5 | 3 | 141 | 0 | 4 | 0 | 2 | 68 | 87 | 155 | 5 | 3 | 141 | 0 | 4 | 0 | 2 | 68 | 87 | 155 | |||||||||||||||||||||||||||||||||
2043053 | 2043053 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001918 | 1490004 | South Lawrence East Elementary School | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 11 | 1 | 141 | 0 | 3 | 0 | 1 | 77 | 80 | 157.0 | 11 | 1 | 141 | 0 | 3 | 0 | 1 | 77 | 80 | 157 | |||||||||||||||||||||||||||||||||
1124104 | 1124104 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Clark Avenue School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 11 | 2 | 138 | 1 | 1 | 0 | 0 | 84 | 69 | 153 | 11 | 2 | 138 | 1 | 1 | 0 | 0 | 84 | 69 | 153 | |||||||||||||||||||||||||||||||||
1131110 | 1131110 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | Other | 05 | 10 | 2017 | grade_5 | 19 | 4 | 138 | 1 | 3 | 1 | 2 | 87 | 81 | 168 | 19 | 4 | 138 | 1 | 3 | 1 | 2 | 87 | 81 | 168 | |||||||||||||||||||||||||||||||||
2230919 | 2230919 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Chelsea: Clark Avenue School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 9 | 5 | 138 | 1 | 0 | 0 | 3 | 84 | 72 | 156.0 | 9 | 5 | 138 | 1 | 0 | 0 | 3 | 84 | 72 | 156 | |||||||||||||||||||||||||||||||||
1679716 | 1679716 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter (District) - Excel Academy Charter School | Regular School | Yes | High | 05 | 12 | 2021 | grade_5 | 20 | 10 | 137 | 3 | 2 | 0 | 2 | 88 | 86 | * | 174.0 | 20 | 10 | 137 | 3 | 2 | 0 | 2 | 88 | 86 | 174 | ||||||||||||||||||||||||||||||||
743416 | 743416 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | 2 | 05 | 08 | 2015 | grade_5 | 14 | 10 | 136 | 5 | 2 | 0 | 0 | 80 | 87 | 167 | 14 | 10 | 136 | 5 | 2 | 0 | 0 | 80 | 87 | 167 | |||||||||||||||||||||||||||||||||
934372 | 934372 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Clark Avenue School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 7 | 7 | 136 | 1 | 1 | 0 | 2 | 91 | 63 | 154 | 7 | 7 | 136 | 1 | 1 | 0 | 2 | 91 | 63 | 154 | |||||||||||||||||||||||||||||||||
2232602 | 2232602 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001945 | 1490017 | Lawrence: Arlington Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 2 | 0 | 136 | 0 | 0 | 0 | 0 | 70 | 68 | 138.0 | 2 | 0 | 136 | 0 | 0 | 0 | 0 | 70 | 68 | 138 | |||||||||||||||||||||||||||||||||
1124109 | 1124109 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001776 | 570055 | Joseph A. Browne School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 9 | 6 | 135 | 0 | 3 | 0 | 1 | 70 | 84 | 154 | 9 | 6 | 135 | 0 | 3 | 0 | 1 | 70 | 84 | 154 | |||||||||||||||||||||||||||||||||
935745 | 935745 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001918 | 1490004 | South Lawrence East Elementary School | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 7 | 1 | 133 | 0 | 3 | 0 | 1 | 66 | 79 | 145 | 7 | 1 | 133 | 0 | 3 | 0 | 1 | 66 | 79 | 145 | |||||||||||||||||||||||||||||||||
2043067 | 2043067 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001945 | 1490017 | Arlington Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 4 | 0 | 133 | 1 | 0 | 0 | 0 | 65 | 72 | 138.0 | 4 | 0 | 133 | 1 | 0 | 0 | 0 | 65 | 72 | 138 | |||||||||||||||||||||||||||||||||
1124099 | 1124099 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001772 | 570045 | Eugene Wright Science and Technology Academy | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 14 | 10 | 132 | 0 | 1 | 0 | 2 | 92 | 67 | 159 | 14 | 10 | 132 | 0 | 1 | 0 | 2 | 92 | 67 | 159 | |||||||||||||||||||||||||||||||||
1675249 | 1675249 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002623 | 1490027 | Lawrence - Parthum Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 7 | 0 | 132 | 0 | 2 | 0 | 1 | 76 | 66 | * | 142.0 | 7 | 0 | 132 | 0 | 2 | 0 | 1 | 76 | 66 | 142 | ||||||||||||||||||||||||||||||||
2041667 | 2041667 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001776 | 570055 | Joseph A. Browne School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 9 | 12 | 132 | 0 | 4 | 0 | 0 | 92 | 65 | 157.0 | 9 | 12 | 132 | 0 | 4 | 0 | 0 | 92 | 65 | 157 | |||||||||||||||||||||||||||||||||
739673 | 739673 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | 1 LT Charles W. Whitcomb School | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 188 | 11 | 131 | 0 | 10 | 0 | 17 | 190 | 167 | 357 | 188 | 11 | 131 | 0 | 10 | 0 | 17 | 190 | 167 | 357 | |||||||||||||||||||||||||||||||||
1125767 | 1125767 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001918 | 1490004 | South Lawrence East Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | grade_5 | 4 | 3 | 131 | 0 | 3 | 0 | 0 | 65 | 76 | 141 | 4 | 3 | 131 | 0 | 3 | 0 | 0 | 65 | 76 | 141 | |||||||||||||||||||||||||||||||||
1367969 | 1367969 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001918 | 1490004 | South Lawrence East Elementary School | Regular School | No | Elementary | 01 | 05 | 2020 | grade_5 | 4 | 1 | 131 | 0 | 3 | 0 | 0 | 84 | 54 | * | 139.0 | 4 | 1 | 131 | 0 | 3 | 0 | 0 | 84 | 54 | 139 | ||||||||||||||||||||||||||||||||
738928 | 738928 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Guilmette Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 3 | 3 | 130 | 0 | 2 | 0 | 0 | 61 | 77 | 138 | 3 | 3 | 130 | 0 | 2 | 0 | 0 | 61 | 77 | 138 | |||||||||||||||||||||||||||||||||
1368004 | 1368004 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002623 | 1490027 | Parthum Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 7 | 0 | 130 | 0 | 1 | 0 | 0 | 64 | 74 | * | 138.0 | 7 | 0 | 130 | 0 | 1 | 0 | 0 | 64 | 74 | 138 | ||||||||||||||||||||||||||||||||
1372452 | 1372452 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | High | 05 | 12 | 2020 | grade_5 | 30 | 11 | 129 | 0 | 3 | 1 | 2 | 90 | 86 | * | 176.0 | 30 | 11 | 129 | 0 | 3 | 1 | 2 | 90 | 86 | 176 | ||||||||||||||||||||||||||||||||
2047525 | 2047525 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | High | 05 | 12 | 2019 | grade_5 | 28 | 12 | 129 | 1 | 2 | 0 | 1 | 82 | 91 | 173.0 | 28 | 12 | 129 | 1 | 2 | 0 | 1 | 82 | 91 | 173 | |||||||||||||||||||||||||||||||||
2232628 | 2232628 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002623 | 1490027 | Lawrence: Parthum Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 13 | 4 | 129 | 0 | 1 | 0 | 1 | 73 | 75 | 148.0 | 13 | 4 | 129 | 0 | 1 | 0 | 1 | 73 | 75 | 148 | |||||||||||||||||||||||||||||||||
935780 | 935780 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002623 | 1490027 | Parthum Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 4 | 2 | 128 | 0 | 0 | 0 | 0 | 70 | 64 | 134 | 4 | 2 | 128 | 0 | 0 | 0 | 0 | 70 | 64 | 134 | |||||||||||||||||||||||||||||||||
1367983 | 1367983 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001945 | 1490017 | Arlington Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 1 | 1 | 128 | 0 | 0 | 0 | 0 | 74 | 56 | * | 130.0 | 1 | 1 | 128 | 0 | 0 | 0 | 0 | 74 | 56 | 130 | ||||||||||||||||||||||||||||||||
2237936 | 2237936 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter (District): Excel Academy Charter School | Regular School | Yes | Middle | 05 | 11 | 2018 | grade_5 | 26 | 12 | 128 | 0 | 0 | 1 | 2 | 83 | 86 | 169.0 | 26 | 12 | 128 | 0 | 0 | 1 | 2 | 83 | 86 | 169 | |||||||||||||||||||||||||||||||||
2042937 | 2042937 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627002895 | 1370075 | Veritas Prep Holyoke | Regular School | No | Middle | 05 | 05 | 2019 | grade_5 | 3 | 8 | 127 | 0 | 0 | 0 | 1 | 79 | 60 | 139.0 | 3 | 8 | 127 | 0 | 0 | 0 | 1 | 79 | 60 | 139 | |||||||||||||||||||||||||||||||||
2043084 | 2043084 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Guilmette Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 1 | 3 | 127 | 0 | 1 | 0 | 0 | 76 | 56 | 132.0 | 1 | 3 | 127 | 0 | 1 | 0 | 0 | 76 | 56 | 132 | |||||||||||||||||||||||||||||||||
2232584 | 2232584 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001918 | 1490004 | Lawrence: South Lawrence East Elementary School | Regular School | No | Elementary | 01 | 05 | 2018 | grade_5 | 5 | 2 | 127 | 0 | 1 | 0 | 2 | 73 | 64 | 137.0 | 5 | 2 | 127 | 0 | 1 | 0 | 2 | 73 | 64 | 137 | |||||||||||||||||||||||||||||||||
737512 | 737512 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Clark Avenue School | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 1 | 2 | 124 | 0 | 2 | 0 | 1 | 71 | 59 | 130 | 1 | 2 | 124 | 0 | 2 | 0 | 1 | 71 | 59 | 130 | |||||||||||||||||||||||||||||||||
1125785 | 1125785 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001945 | 1490017 | Arlington Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 2 | 1 | 124 | 0 | 0 | 0 | 0 | 66 | 61 | 127 | 2 | 1 | 124 | 0 | 0 | 0 | 0 | 66 | 61 | 127 | |||||||||||||||||||||||||||||||||
935776 | 935776 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Guilmette Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 6 | 4 | 122 | 0 | 0 | 0 | 1 | 70 | 63 | 133 | 6 | 4 | 122 | 0 | 0 | 0 | 1 | 70 | 63 | 133 | |||||||||||||||||||||||||||||||||
935759 | 935759 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001945 | 1490017 | Arlington Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 3 | 2 | 121 | 0 | 0 | 0 | 0 | 64 | 62 | 126 | 3 | 2 | 121 | 0 | 0 | 0 | 0 | 64 | 62 | 126 | |||||||||||||||||||||||||||||||||
738932 | 738932 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002623 | 1490027 | Parthum Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 13 | 4 | 120 | 0 | 0 | 0 | 1 | 81 | 57 | 138 | 13 | 4 | 120 | 0 | 0 | 0 | 1 | 81 | 57 | 138 | |||||||||||||||||||||||||||||||||
1675228 | 1675228 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001945 | 1490017 | Lawrence - Arlington Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 4 | 2 | 120 | 0 | 0 | 0 | 0 | 74 | 51 | * | 126.0 | 4 | 2 | 120 | 0 | 0 | 0 | 0 | 74 | 51 | 126 | ||||||||||||||||||||||||||||||||
737508 | 737508 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001772 | 570045 | Eugene Wright Science and Technology Academy | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 8 | 9 | 118 | 1 | 4 | 0 | 3 | 80 | 63 | 143 | 8 | 9 | 118 | 1 | 4 | 0 | 3 | 80 | 63 | 143 | |||||||||||||||||||||||||||||||||
2230914 | 2230914 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001772 | 570045 | Chelsea: Eugene Wright Science and Technology Academy | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 11 | 10 | 118 | 0 | 3 | 0 | 4 | 67 | 79 | 146.0 | 11 | 10 | 118 | 0 | 3 | 0 | 4 | 67 | 79 | 146 | |||||||||||||||||||||||||||||||||
940235 | 940235 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | 2 | 05 | 09 | 2016 | grade_5 | 25 | 14 | 117 | 5 | 2 | 2 | 0 | 73 | 92 | 165 | 25 | 14 | 117 | 5 | 2 | 2 | 0 | 73 | 92 | 165 | |||||||||||||||||||||||||||||||||
1368000 | 1368000 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Guilmette Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 6 | 1 | 117 | 0 | 0 | 0 | 0 | 63 | 61 | * | 124.0 | 6 | 1 | 117 | 0 | 0 | 0 | 0 | 63 | 61 | 124 | ||||||||||||||||||||||||||||||||
1368051 | 1368051 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002654 | 1490525 | Frost Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 13 | 0 | 116 | 0 | 4 | 0 | 1 | 67 | 67 | * | 134.0 | 13 | 0 | 116 | 0 | 4 | 0 | 1 | 67 | 67 | 134 | ||||||||||||||||||||||||||||||||
1675296 | 1675296 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002654 | 1490525 | Lawrence - Frost Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 8 | 5 | 116 | 0 | 1 | 0 | 1 | 65 | 66 | * | 131.0 | 8 | 5 | 116 | 0 | 1 | 0 | 1 | 65 | 66 | 131 | ||||||||||||||||||||||||||||||||
1366590 | 1366590 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001772 | 570045 | Eugene Wright Science and Technology Academy | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 10 | 7 | 115 | 0 | 1 | 0 | 1 | 64 | 70 | * | 134.0 | 10 | 7 | 115 | 0 | 1 | 0 | 1 | 64 | 70 | 134 | ||||||||||||||||||||||||||||||||
743816 | 743816 | MA | Suffolk | school | 2500063 | 484 | Roxbury Preparatory Charter (District) | 250006301453 | 4840505 | Roxbury Preparatory Charter School | Regular School | Yes | 2 | 05 | 08 | 2015 | grade_5 | 2 | 128 | 114 | 0 | 2 | 0 | 3 | 137 | 112 | 249 | 2 | 128 | 114 | 0 | 2 | 0 | 3 | 137 | 112 | 249 | |||||||||||||||||||||||||||||||||
1675245 | 1675245 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Lawrence - Guilmette Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 2 | 3 | 112 | 0 | 2 | 0 | 1 | 63 | 57 | * | 120.0 | 2 | 3 | 112 | 0 | 2 | 0 | 1 | 63 | 57 | 120 | ||||||||||||||||||||||||||||||||
738911 | 738911 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666001945 | 1490017 | Arlington Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 4 | 3 | 111 | 0 | 0 | 0 | 0 | 60 | 58 | 118 | 4 | 3 | 111 | 0 | 0 | 0 | 0 | 60 | 58 | 118 | |||||||||||||||||||||||||||||||||
2042791 | 2042791 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000850 | 1280100 | Consentino Middle School | Regular School | No | Middle | 04 | 08 | 2019 | grade_5 | 58 | 5 | 111 | 0 | 6 | 0 | 5 | 102 | 83 | 185.0 | 58 | 5 | 111 | 0 | 6 | 0 | 5 | 102 | 83 | 185 | |||||||||||||||||||||||||||||||||
934376 | 934376 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001776 | 570055 | Joseph A. Browne School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 10 | 6 | 110 | 0 | 3 | 0 | 0 | 63 | 66 | 129 | 10 | 6 | 110 | 0 | 3 | 0 | 0 | 63 | 66 | 129 | |||||||||||||||||||||||||||||||||
1125806 | 1125806 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Guilmette Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 2 | 3 | 110 | 0 | 1 | 0 | 0 | 57 | 59 | 116 | 2 | 3 | 110 | 0 | 1 | 0 | 0 | 57 | 59 | 116 | |||||||||||||||||||||||||||||||||
1674500 | 1674500 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Fitchburg - Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 38 | 16 | 110 | 1 | 6 | 0 | 7 | 89 | 89 | * | 178.0 | 38 | 16 | 110 | 1 | 6 | 0 | 7 | 89 | 89 | 178 | ||||||||||||||||||||||||||||||||
2043135 | 2043135 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002654 | 1490525 | Frost Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 9 | 7 | 108 | 0 | 2 | 0 | 4 | 77 | 53 | 130.0 | 9 | 7 | 108 | 0 | 2 | 0 | 4 | 77 | 53 | 130 | |||||||||||||||||||||||||||||||||
2232685 | 2232685 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002654 | 1490525 | Lawrence: Frost Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 13 | 3 | 108 | 0 | 8 | 0 | 3 | 72 | 63 | 135.0 | 13 | 3 | 108 | 0 | 8 | 0 | 3 | 72 | 63 | 135 | |||||||||||||||||||||||||||||||||
1367266 | 1367266 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 38 | 8 | 105 | 0 | 7 | 0 | 12 | 81 | 89 | * | 170.0 | 38 | 8 | 105 | 0 | 7 | 0 | 12 | 81 | 89 | 170 | ||||||||||||||||||||||||||||||||
1676268 | 1676268 | MA | Worcester | school | 2507860 | 185 | Milford | 250786001244 | 1850090 | Milford - Woodland | Regular School | No | Elementary | 03 | 05 | 2021 | grade_5 | 194 | 11 | 103 | 3 | 7 | 0 | 14 | 171 | 161 | * | 332.0 | 194 | 11 | 103 | 3 | 7 | 0 | 14 | 171 | 161 | 332 | ||||||||||||||||||||||||||||||||
2042326 | 2042326 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 63 | 7 | 103 | 0 | 7 | 1 | 12 | 96 | 97 | 193.0 | 63 | 7 | 103 | 0 | 7 | 1 | 12 | 96 | 97 | 193 | |||||||||||||||||||||||||||||||||
2232623 | 2232623 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Lawrence: Guilmette Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 6 | 0 | 103 | 0 | 0 | 0 | 0 | 50 | 59 | 109.0 | 6 | 0 | 103 | 0 | 0 | 0 | 0 | 50 | 59 | 109 | |||||||||||||||||||||||||||||||||
2233826 | 2233826 | MA | Worcester | school | 2507860 | 185 | Milford | 250786001244 | 1850090 | Milford: Woodland | Regular School | No | Elementary | 03 | 05 | 2018 | grade_5 | 184 | 7 | 102 | 14 | 5 | 0 | 14 | 169 | 157 | 326.0 | 184 | 7 | 102 | 14 | 5 | 0 | 14 | 169 | 157 | 326 | |||||||||||||||||||||||||||||||||
935794 | 935794 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002799 | 1490048 | Oliver Partnership School | Regular School | No | 1 | 01 | 05 | 2016 | grade_5 | 3 | 0 | 101 | 0 | 0 | 0 | 0 | 57 | 47 | 104 | 3 | 0 | 101 | 0 | 0 | 0 | 0 | 57 | 47 | 104 | |||||||||||||||||||||||||||||||||
2043101 | 2043101 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002799 | 1490048 | Oliver Partnership School | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 2 | 0 | 101 | 0 | 1 | 0 | 0 | 50 | 53 | 104.0 | 2 | 0 | 101 | 0 | 1 | 0 | 0 | 50 | 53 | 104 | |||||||||||||||||||||||||||||||||
935824 | 935824 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002654 | 1490525 | Frost Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 8 | 2 | 100 | 0 | 3 | 0 | 2 | 71 | 44 | 115 | 8 | 2 | 100 | 0 | 3 | 0 | 2 | 71 | 44 | 115 | |||||||||||||||||||||||||||||||||
1125811 | 1125811 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002623 | 1490027 | Parthum Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 8 | 0 | 100 | 0 | 0 | 0 | 2 | 46 | 64 | 110 | 8 | 0 | 100 | 0 | 0 | 0 | 2 | 46 | 64 | 110 | |||||||||||||||||||||||||||||||||
1131213 | 1131213 | MA | Essex | school | 2500082 | 429 | KIPP Academy Lynn Charter (District) | 250008201845 | 4290010 | KIPP Academy Lynn Charter School | Regular School | Yes | Other | KG | 12 | 2017 | grade_5 | 5 | 18 | 100 | 0 | 2 | 0 | 1 | 66 | 60 | 126 | 5 | 18 | 100 | 0 | 2 | 0 | 1 | 66 | 60 | 126 | |||||||||||||||||||||||||||||||||
1673821 | 1673821 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001772 | 570045 | Chelsea - Eugene Wright Science and Technology Academy | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 9 | 6 | 99 | 0 | 0 | 0 | 2 | 57 | 59 | * | 116.0 | 9 | 6 | 99 | 0 | 0 | 0 | 2 | 57 | 59 | 116 | ||||||||||||||||||||||||||||||||
935023 | 935023 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Intermediate | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 62 | 12 | 98 | 0 | 12 | 0 | 16 | 104 | 96 | 200 | 62 | 12 | 98 | 0 | 12 | 0 | 16 | 104 | 96 | 200 | |||||||||||||||||||||||||||||||||
1366598 | 1366598 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001776 | 570055 | Joseph A. Browne School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 12 | 7 | 98 | 0 | 0 | 0 | 4 | 64 | 57 | * | 121.0 | 12 | 7 | 98 | 0 | 0 | 0 | 4 | 64 | 57 | 121 | ||||||||||||||||||||||||||||||||
1368012 | 1368012 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000956 | 1490040 | Francis M Leahy | Regular School | No | Elementary | 01 | 05 | 2020 | grade_5 | 1 | 0 | 98 | 0 | 0 | 0 | 0 | 55 | 44 | * | 99.0 | 1 | 0 | 98 | 0 | 0 | 0 | 0 | 55 | 44 | 99 | ||||||||||||||||||||||||||||||||
935033 | 935033 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 49 | 10 | 97 | 0 | 10 | 0 | 11 | 95 | 82 | 177 | 49 | 10 | 97 | 0 | 10 | 0 | 11 | 95 | 82 | 177 | |||||||||||||||||||||||||||||||||
2041659 | 2041659 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001772 | 570045 | Eugene Wright Science and Technology Academy | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 5 | 9 | 97 | 0 | 3 | 0 | 3 | 68 | 49 | 117.0 | 5 | 9 | 97 | 0 | 3 | 0 | 3 | 68 | 49 | 117 | |||||||||||||||||||||||||||||||||
2047930 | 2047930 | MA | Suffolk | school | 2500063 | 484 | Roxbury Preparatory Charter (District) | 250006301453 | 4840505 | Roxbury Preparatory Charter School | Regular School | Yes | High | 05 | 12 | 2019 | grade_5 | 4 | 120 | 97 | 1 | 0 | 1 | 0 | 115 | 108 | 223.0 | 4 | 120 | 97 | 1 | 0 | 1 | 0 | 115 | 108 | 223 | |||||||||||||||||||||||||||||||||
1125868 | 1125868 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002654 | 1490525 | Frost Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 15 | 3 | 96 | 0 | 7 | 0 | 1 | 55 | 67 | 122 | 15 | 3 | 96 | 0 | 7 | 0 | 1 | 55 | 67 | 122 | |||||||||||||||||||||||||||||||||
934368 | 934368 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001772 | 570045 | Eugene Wright Science and Technology Academy | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 9 | 8 | 95 | 2 | 2 | 0 | 2 | 64 | 54 | 118 | 9 | 8 | 95 | 2 | 2 | 0 | 2 | 64 | 54 | 118 | |||||||||||||||||||||||||||||||||
1125827 | 1125827 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002799 | 1490048 | Oliver Partnership School | Regular School | No | Elementary | 01 | 05 | 2017 | grade_5 | 7 | 1 | 95 | 0 | 0 | 0 | 0 | 54 | 49 | 103 | 7 | 1 | 95 | 0 | 0 | 0 | 0 | 54 | 49 | 103 | |||||||||||||||||||||||||||||||||
2044091 | 2044091 | MA | Worcester | school | 2507860 | 185 | Milford | 250786001244 | 1850090 | Woodland | Regular School | No | Elementary | 03 | 05 | 2019 | grade_5 | 190 | 11 | 95 | 8 | 11 | 0 | 14 | 178 | 151 | 329.0 | 190 | 11 | 95 | 8 | 11 | 0 | 14 | 178 | 151 | 329 | |||||||||||||||||||||||||||||||||
1675100 | 1675100 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627002895 | 1370075 | Holyoke - Veritas Prep Holyoke | Regular School | No | Middle | 05 | 07 | 2021 | grade_5 | 1 | 4 | 94 | 0 | 1 | 0 | 1 | 52 | 49 | * | 101.0 | 1 | 4 | 94 | 0 | 1 | 0 | 1 | 52 | 49 | 101 | ||||||||||||||||||||||||||||||||
1675257 | 1675257 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000956 | 1490040 | Lawrence - Francis M Leahy | Regular School | No | Elementary | 01 | 05 | 2021 | grade_5 | 6 | 1 | 94 | 0 | 0 | 0 | 0 | 49 | 52 | * | 101.0 | 6 | 1 | 94 | 0 | 0 | 0 | 0 | 49 | 52 | 101 | ||||||||||||||||||||||||||||||||
737516 | 737516 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001776 | 570055 | Joseph A. Browne School | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 8 | 6 | 93 | 0 | 5 | 0 | 0 | 54 | 58 | 112 | 8 | 6 | 93 | 0 | 5 | 0 | 0 | 54 | 58 | 112 | |||||||||||||||||||||||||||||||||
738941 | 738941 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000956 | 1490040 | Francis M Leahy | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 4 | 1 | 93 | 0 | 0 | 0 | 0 | 48 | 50 | 98 | 4 | 1 | 93 | 0 | 0 | 0 | 0 | 48 | 50 | 98 | |||||||||||||||||||||||||||||||||
935755 | 935755 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000950 | 1490015 | Alexander B Bruce | Regular School | No | 1 | 03 | 08 | 2016 | grade_5 | 8 | 0 | 93 | 0 | 3 | 0 | 0 | 47 | 57 | 104 | 8 | 0 | 93 | 0 | 3 | 0 | 0 | 47 | 57 | 104 | |||||||||||||||||||||||||||||||||
1131555 | 1131555 | MA | Suffolk | school | 2500063 | 484 | Roxbury Preparatory Charter (District) | 250006301453 | 4840505 | Roxbury Preparatory Charter School | Regular School | Yes | Other | 05 | 10 | 2017 | grade_5 | 3 | 137 | 93 | 0 | 6 | 1 | 4 | 139 | 105 | 244 | 3 | 137 | 93 | 0 | 6 | 1 | 4 | 139 | 105 | 244 | |||||||||||||||||||||||||||||||||
1369020 | 1369020 | MA | Worcester | school | 2507860 | 185 | Milford | 250786001244 | 1850090 | Woodland | Regular School | No | Elementary | 03 | 05 | 2020 | grade_5 | 199 | 11 | 93 | 8 | 4 | 1 | 17 | 180 | 153 | * | 333.0 | 199 | 11 | 93 | 8 | 4 | 1 | 17 | 180 | 153 | 333 | ||||||||||||||||||||||||||||||||
2045368 | 2045368 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001633 | 2480035 | Staff Sargent James J. Hill Elementary School | Regular School | No | Elementary | KG | 05 | 2019 | grade_5 | 31 | 7 | 93 | 0 | 2 | 0 | 4 | 74 | 63 | 137.0 | 31 | 7 | 93 | 0 | 2 | 0 | 4 | 74 | 63 | 137 | |||||||||||||||||||||||||||||||||
738169 | 738169 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Intermediate | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 44 | 7 | 92 | 0 | 9 | 0 | 12 | 80 | 84 | 164 | 44 | 7 | 92 | 0 | 9 | 0 | 12 | 80 | 84 | 164 | |||||||||||||||||||||||||||||||||
935789 | 935789 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000956 | 1490040 | Francis M Leahy | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 1 | 0 | 92 | 0 | 0 | 0 | 0 | 45 | 48 | 93 | 1 | 0 | 92 | 0 | 0 | 0 | 0 | 45 | 48 | 93 | |||||||||||||||||||||||||||||||||
1367856 | 1367856 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627002895 | 1370075 | Veritas Prep Holyoke | Regular School | No | Middle | 05 | 06 | 2020 | grade_5 | 4 | 5 | 92 | 0 | 1 | 0 | 1 | 67 | 36 | * | 103.0 | 4 | 5 | 92 | 0 | 1 | 0 | 1 | 67 | 36 | 103 | ||||||||||||||||||||||||||||||||
1674490 | 1674490 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Fitchburg - Memorial Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 47 | 6 | 92 | 0 | 6 | 0 | 12 | 77 | 86 | * | 163.0 | 47 | 6 | 92 | 0 | 6 | 0 | 12 | 77 | 86 | 163 | ||||||||||||||||||||||||||||||||
2231720 | 2231720 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Fitchburg: Arthur M Longsjo Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 41 | 8 | 92 | 0 | 4 | 1 | 14 | 82 | 78 | 160.0 | 41 | 8 | 92 | 0 | 4 | 1 | 14 | 82 | 78 | 160 | |||||||||||||||||||||||||||||||||
2238388 | 2238388 | MA | Suffolk | school | 2500063 | 484 | Roxbury Preparatory Charter (District) | 250006301453 | 4840505 | Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School | Regular School | Yes | Middle | 05 | 11 | 2018 | grade_5 | 3 | 135 | 92 | 1 | 4 | 0 | 1 | 124 | 112 | 236.0 | 3 | 135 | 92 | 1 | 4 | 0 | 1 | 124 | 112 | 236 | |||||||||||||||||||||||||||||||||
1124880 | 1124880 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489001523 | 970048 | Memorial Intermediate | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 52 | 8 | 91 | 0 | 13 | 0 | 10 | 89 | 85 | 174 | 52 | 8 | 91 | 0 | 13 | 0 | 10 | 89 | 85 | 174 | |||||||||||||||||||||||||||||||||
1128527 | 1128527 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001975 | 2480056 | Garfield Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | grade_5 | 25 | 2 | 91 | 0 | 2 | 0 | 1 | 53 | 68 | 121 | 25 | 2 | 91 | 0 | 2 | 0 | 1 | 53 | 68 | 121 | |||||||||||||||||||||||||||||||||
1676213 | 1676213 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001556 | 1810055 | Methuen - Tenney Grammar School | Regular School | No | Elementary | PK | 08 | 2021 | grade_5 | 48 | 2 | 91 | 0 | 6 | 0 | 3 | 80 | 70 | * | 150.0 | 48 | 2 | 91 | 0 | 6 | 0 | 3 | 80 | 70 | 150 |
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]);