enrollments
Data source: Big Local News · About: Big Local
3,471 rows where grade = "grade_7" and state = "MA" sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2235522 | 2235522 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002824 | 2610305 | Sandwich: Sandwich STEM Academy | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 221 | 1 | 1 | 4 | 6 | 0 | 1 | 120 | 114 | 234.0 | 221 | 1 | 1 | 4 | 6 | 0 | 1 | 120 | 114 | 234 | |||||||||||||||||||||||||||||||||
2235494 | 2235494 | MA | Essex | school | 2510380 | 258 | Salem | 251038002404 | 2580305 | Salem: Collins Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 105 | 15 | 51 | 0 | 7 | 0 | 7 | 91 | 94 | 185.0 | 105 | 15 | 51 | 0 | 7 | 0 | 7 | 91 | 94 | 185 | |||||||||||||||||||||||||||||||||
2235483 | 2235483 | MA | Essex | school | 2510380 | 258 | Salem | 251038000773 | 2580050 | Salem: Saltonstall School | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 22 | 1 | 13 | 0 | 0 | 0 | 4 | 21 | 19 | 40.0 | 22 | 1 | 13 | 0 | 0 | 0 | 4 | 21 | 19 | 40 | |||||||||||||||||||||||||||||||||
2235466 | 2235466 | MA | Essex | school | 2510380 | 258 | Salem | 251038002559 | 2580025 | Salem: Nathaniel Bowditch | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 9 | 2 | 33 | 1 | 0 | 0 | 0 | 24 | 21 | 45.0 | 9 | 2 | 33 | 1 | 0 | 0 | 0 | 24 | 21 | 45 | |||||||||||||||||||||||||||||||||
2235426 | 2235426 | MA | Essex | school | 2510200 | 252 | Rockport | 251020000506 | 2520305 | Rockport: Rockport Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 74 | 0 | 2 | 0 | 0 | 0 | 0 | 34 | 42 | 76.0 | 74 | 0 | 2 | 0 | 0 | 0 | 0 | 34 | 42 | 76 | |||||||||||||||||||||||||||||||||
2235408 | 2235408 | MA | Plymouth | school | 2510170 | 251 | Rockland | 251017001642 | 2510305 | Rockland: John W Rogers Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 128 | 7 | 16 | 0 | 2 | 0 | 4 | 90 | 67 | 157.0 | 128 | 7 | 16 | 0 | 2 | 0 | 4 | 90 | 67 | 157 | |||||||||||||||||||||||||||||||||
2235376 | 2235376 | MA | Berkshire | school | 2510080 | 249 | Richmond | 251008001635 | 2490005 | Richmond: Richmond Consolidated | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 5 | 13.0 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | |||||||||||||||||||||||||||||||||
2235355 | 2235355 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005002113 | 2480305 | Revere: Susan B. Anthony Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 59 | 11 | 109 | 1 | 10 | 0 | 5 | 85 | 110 | 195.0 | 59 | 11 | 109 | 1 | 10 | 0 | 5 | 85 | 110 | 195 | |||||||||||||||||||||||||||||||||
2235351 | 2235351 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001976 | 2480057 | Revere: Garfield Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 59 | 6 | 101 | 0 | 13 | 0 | 2 | 93 | 88 | 181.0 | 59 | 6 | 101 | 0 | 13 | 0 | 2 | 93 | 88 | 181 | |||||||||||||||||||||||||||||||||
2235317 | 2235317 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001963 | 2480014 | Revere: Rumney Marsh Academy | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 94 | 7 | 84 | 1 | 6 | 1 | 2 | 102 | 93 | 195.0 | 94 | 7 | 84 | 1 | 6 | 1 | 2 | 102 | 93 | 195 | |||||||||||||||||||||||||||||||||
2235293 | 2235293 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001612 | 2460310 | Reading: Walter S Parker Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 175 | 5 | 7 | 0 | 11 | 0 | 3 | 101 | 100 | 201.0 | 175 | 5 | 7 | 0 | 11 | 0 | 3 | 101 | 100 | 201 | |||||||||||||||||||||||||||||||||
2235289 | 2235289 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001605 | 2460305 | Reading: Arthur W Coolidge Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 138 | 1 | 3 | 0 | 6 | 0 | 4 | 84 | 68 | 152.0 | 138 | 1 | 3 | 0 | 6 | 0 | 4 | 84 | 68 | 152 | |||||||||||||||||||||||||||||||||
2235243 | 2235243 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001392 | 2440410 | Randolph: Randolph Community Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 28 | 91 | 29 | 1 | 32 | 0 | 10 | 95 | 96 | 191.0 | 28 | 91 | 29 | 1 | 32 | 0 | 10 | 95 | 96 | 191 | |||||||||||||||||||||||||||||||||
2235200 | 2235200 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001381 | 2430325 | Quincy: Point Webster Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 37 | 12 | 8 | 1 | 33 | 0 | 3 | 51 | 43 | 94.0 | 37 | 12 | 8 | 1 | 33 | 0 | 3 | 51 | 43 | 94 | |||||||||||||||||||||||||||||||||
2235195 | 2235195 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001581 | 2430320 | Quincy: Reay E Sterling Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 40 | 12 | 12 | 0 | 18 | 0 | 3 | 42 | 43 | 85.0 | 40 | 12 | 12 | 0 | 18 | 0 | 3 | 42 | 43 | 85 | |||||||||||||||||||||||||||||||||
2235190 | 2235190 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Quincy: Central Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 105 | 6 | 7 | 0 | 93 | 0 | 5 | 109 | 107 | 216.0 | 105 | 6 | 7 | 0 | 93 | 0 | 5 | 109 | 107 | 216 | |||||||||||||||||||||||||||||||||
2235186 | 2235186 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001563 | 2430310 | Quincy: Broad Meadows Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 84 | 10 | 8 | 1 | 21 | 1 | 3 | 59 | 69 | 128.0 | 84 | 10 | 8 | 1 | 21 | 1 | 3 | 59 | 69 | 128 | |||||||||||||||||||||||||||||||||
2235182 | 2235182 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001561 | 2430305 | Quincy: Atlantic Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 48 | 13 | 9 | 0 | 74 | 0 | 5 | 69 | 80 | 149.0 | 48 | 13 | 9 | 0 | 74 | 0 | 5 | 69 | 80 | 149 | |||||||||||||||||||||||||||||||||
2235100 | 2235100 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown: Provincetown Schools | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 5 | 1 | 3 | 0 | 0 | 0 | 1 | 7 | 3 | 10.0 | 5 | 1 | 3 | 0 | 0 | 0 | 1 | 7 | 3 | 10 | |||||||||||||||||||||||||||||||||
2235071 | 2235071 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972002531 | 2390405 | Plymouth: Plymouth Commun Intermediate | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 277 | 9 | 16 | 1 | 10 | 0 | 8 | 181 | 139 | 321.0 | 277 | 9 | 16 | 1 | 10 | 0 | 8 | 181 | 139 | 321 | |||||||||||||||||||||||||||||||||
2235067 | 2235067 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001380 | 2390305 | Plymouth: Plymouth South Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 217 | 1 | 8 | 2 | 2 | 0 | 8 | 128 | 110 | 238.0 | 217 | 1 | 8 | 2 | 2 | 0 | 8 | 128 | 110 | 238 | |||||||||||||||||||||||||||||||||
2234986 | 2234986 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001532 | 2360310 | Pittsfield: Theodore Herberg Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 128 | 22 | 28 | 0 | 3 | 0 | 21 | 100 | 102 | 202.0 | 128 | 22 | 28 | 0 | 3 | 0 | 21 | 100 | 102 | 202 | |||||||||||||||||||||||||||||||||
2234982 | 2234982 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001525 | 2360305 | Pittsfield: John T Reid Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 110 | 20 | 25 | 0 | 3 | 1 | 20 | 97 | 82 | 179.0 | 110 | 20 | 25 | 0 | 3 | 1 | 20 | 97 | 82 | 179 | |||||||||||||||||||||||||||||||||
2234905 | 2234905 | MA | Plymouth | school | 2509420 | 231 | Pembroke | 250942001823 | 2310305 | Pembroke: Pembroke Community Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 238 | 3 | 1 | 0 | 3 | 0 | 0 | 131 | 114 | 245.0 | 238 | 3 | 1 | 0 | 3 | 0 | 0 | 131 | 114 | 245 | |||||||||||||||||||||||||||||||||
2234864 | 2234864 | MA | Essex | school | 2509360 | 229 | Peabody | 250936001495 | 2290305 | Peabody: J Henry Higgins Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 367 | 20 | 77 | 0 | 8 | 0 | 7 | 246 | 233 | 479.0 | 367 | 20 | 77 | 0 | 8 | 0 | 7 | 246 | 233 | 479 | |||||||||||||||||||||||||||||||||
2234796 | 2234796 | MA | Hampden | school | 2509300 | 227 | Palmer | 250930001485 | 2270505 | Palmer: Palmer High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 95 | 3 | 13 | 0 | 0 | 0 | 8 | 70 | 49 | 119.0 | 95 | 3 | 13 | 0 | 0 | 0 | 8 | 70 | 49 | 119 | |||||||||||||||||||||||||||||||||
2234779 | 2234779 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927001483 | 2260405 | Oxford: Oxford Middle | Regular School | No | Middle | 05 | 07 | 2018 | grade_7 | 116 | 2 | 14 | 0 | 3 | 0 | 2 | 70 | 67 | 137.0 | 116 | 2 | 14 | 0 | 3 | 0 | 2 | 70 | 67 | 137 | |||||||||||||||||||||||||||||||||
2234743 | 2234743 | MA | Dukes | school | 2504650 | 221 | Oak Bluffs | 250465000625 | 2210005 | Oak Bluffs: Oak Bluffs Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 30 | 3 | 8 | 1 | 1 | 0 | 5 | 25 | 23 | 48.0 | 30 | 3 | 8 | 1 | 1 | 0 | 5 | 25 | 23 | 48 | |||||||||||||||||||||||||||||||||
2234727 | 2234727 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001468 | 2200305 | Norwood: Dr. Philip O. Coakley Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 167 | 36 | 35 | 0 | 13 | 0 | 7 | 133 | 125 | 258.0 | 167 | 36 | 35 | 0 | 13 | 0 | 7 | 133 | 125 | 258 | |||||||||||||||||||||||||||||||||
2234684 | 2234684 | MA | Plymouth | school | 2509030 | 219 | Norwell | 250903001456 | 2190405 | Norwell: Norwell Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 170 | 0 | 1 | 0 | 4 | 0 | 2 | 81 | 96 | 177.0 | 170 | 0 | 1 | 0 | 4 | 0 | 2 | 81 | 96 | 177 | |||||||||||||||||||||||||||||||||
2234659 | 2234659 | MA | Bristol | school | 2509000 | 218 | Norton | 250900001452 | 2180305 | Norton: Norton Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 176 | 3 | 5 | 0 | 3 | 0 | 5 | 92 | 100 | 192.0 | 176 | 3 | 5 | 0 | 3 | 0 | 5 | 92 | 100 | 192 | |||||||||||||||||||||||||||||||||
2234636 | 2234636 | MA | Middlesex | school | 2508820 | 217 | North Reading | 250882002592 | 2170305 | North Reading: North Reading Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 174 | 1 | 7 | 0 | 6 | 0 | 7 | 91 | 104 | 195.0 | 174 | 1 | 7 | 0 | 6 | 0 | 7 | 91 | 104 | 195 | |||||||||||||||||||||||||||||||||
2234606 | 2234606 | MA | Worcester | school | 2508760 | 215 | North Brookfield | 250876001411 | 2150505 | North Brookfield: North Brookfield High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 41 | 1 | 3 | 0 | 0 | 0 | 2 | 32 | 15 | 47.0 | 41 | 1 | 3 | 0 | 0 | 0 | 2 | 32 | 15 | 47 | |||||||||||||||||||||||||||||||||
2234589 | 2234589 | MA | Worcester | school | 2508940 | 214 | Northbridge | 250894002591 | 2140305 | Northbridge: Northbridge Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 164 | 1 | 10 | 0 | 0 | 0 | 10 | 103 | 82 | 185.0 | 164 | 1 | 10 | 0 | 0 | 0 | 10 | 103 | 82 | 185 | |||||||||||||||||||||||||||||||||
2234576 | 2234576 | MA | Worcester | school | 2508880 | 213 | Northborough | 250888001440 | 2130305 | Northborough: Robert E. Melican Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 156 | 4 | 16 | 2 | 15 | 2 | 10 | 112 | 93 | 205.0 | 156 | 4 | 16 | 2 | 15 | 2 | 10 | 112 | 93 | 205 | |||||||||||||||||||||||||||||||||
2234539 | 2234539 | MA | Bristol | school | 2508730 | 212 | North Attleborough | 250873001207 | 2120305 | North Attleborough: North Attleborough Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 284 | 10 | 14 | 1 | 25 | 1 | 11 | 183 | 163 | 346.0 | 284 | 10 | 14 | 1 | 25 | 1 | 11 | 183 | 163 | 346 | |||||||||||||||||||||||||||||||||
2234493 | 2234493 | MA | Essex | school | 2508700 | 211 | North Andover | 250870001398 | 2110305 | North Andover: North Andover Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 280 | 8 | 33 | 1 | 21 | 1 | 10 | 186 | 168 | 354.0 | 280 | 8 | 33 | 1 | 21 | 1 | 10 | 186 | 168 | 354 | |||||||||||||||||||||||||||||||||
2234448 | 2234448 | MA | Hampshire | school | 2508850 | 210 | Northampton | 250885001430 | 2100410 | Northampton: John F Kennedy Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 150 | 4 | 50 | 1 | 5 | 0 | 13 | 116 | 107 | 223.0 | 150 | 4 | 50 | 1 | 5 | 0 | 13 | 116 | 107 | 223 | |||||||||||||||||||||||||||||||||
2234410 | 2234410 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001387 | 2090505 | North Adams: Drury High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 85 | 4 | 4 | 0 | 0 | 0 | 7 | 52 | 48 | 100.0 | 85 | 4 | 4 | 0 | 0 | 0 | 7 | 52 | 48 | 100 | |||||||||||||||||||||||||||||||||
2234360 | 2234360 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001042 | 2070320 | Newton: Oak Hill Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 143 | 8 | 12 | 0 | 53 | 0 | 17 | 108 | 125 | 233.0 | 143 | 8 | 12 | 0 | 53 | 0 | 17 | 108 | 125 | 233 | |||||||||||||||||||||||||||||||||
2234356 | 2234356 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000314 | 2070315 | Newton: F A Day Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 197 | 19 | 21 | 2 | 41 | 0 | 24 | 175 | 129 | 304.0 | 197 | 19 | 21 | 2 | 41 | 0 | 24 | 175 | 129 | 304 | |||||||||||||||||||||||||||||||||
2234352 | 2234352 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000310 | 2070310 | Newton: Charles E Brown Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 156 | 7 | 13 | 0 | 44 | 0 | 20 | 117 | 123 | 240.0 | 156 | 7 | 13 | 0 | 44 | 0 | 20 | 117 | 123 | 240 | |||||||||||||||||||||||||||||||||
2234348 | 2234348 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000307 | 2070305 | Newton: Bigelow Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 105 | 7 | 21 | 0 | 27 | 0 | 11 | 83 | 88 | 171.0 | 105 | 7 | 21 | 0 | 27 | 0 | 11 | 83 | 88 | 171 | |||||||||||||||||||||||||||||||||
2234232 | 2234232 | MA | Essex | school | 2508580 | 204 | Newburyport | 250858001355 | 2040305 | Newburyport: Rupert A Nock Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 184 | 0 | 6 | 0 | 1 | 0 | 3 | 100 | 94 | 194.0 | 184 | 0 | 6 | 0 | 1 | 0 | 3 | 100 | 94 | 194 | |||||||||||||||||||||||||||||||||
2234215 | 2234215 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843002681 | 2010515 | New Bedford: Whaling City Junior/Senior High School | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 6 | 1 | 7.0 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | |||||||||||||||||||||||||||||||||
2234208 | 2234208 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843002590 | 2010510 | New Bedford: Trinity Day Academy | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 4 | 0 | 2 | 1 | 0 | 0 | 0 | 5 | 2 | 7.0 | 4 | 0 | 2 | 1 | 0 | 0 | 0 | 5 | 2 | 7 | |||||||||||||||||||||||||||||||||
2234200 | 2234200 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001339 | 2010415 | New Bedford: Roosevelt Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 98 | 43 | 95 | 1 | 0 | 0 | 19 | 136 | 120 | 256.0 | 98 | 43 | 95 | 1 | 0 | 0 | 19 | 136 | 120 | 256 | |||||||||||||||||||||||||||||||||
2234196 | 2234196 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001337 | 2010410 | New Bedford: Normandin Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 198 | 28 | 151 | 2 | 9 | 0 | 29 | 216 | 201 | 417.0 | 198 | 28 | 151 | 2 | 9 | 0 | 29 | 216 | 201 | 417 | |||||||||||||||||||||||||||||||||
2234192 | 2234192 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001334 | 2010405 | New Bedford: Keith Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 121 | 38 | 111 | 1 | 2 | 1 | 12 | 140 | 146 | 286.0 | 121 | 38 | 111 | 1 | 2 | 1 | 12 | 140 | 146 | 286 | |||||||||||||||||||||||||||||||||
2234037 | 2234037 | MA | Norfolk | school | 2508370 | 199 | Needham | 250837001308 | 1990405 | Needham: Pollard Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 320 | 6 | 31 | 0 | 30 | 0 | 21 | 193 | 215 | 408.0 | 320 | 6 | 31 | 0 | 30 | 0 | 21 | 193 | 215 | 408 | |||||||||||||||||||||||||||||||||
2233992 | 2233992 | MA | Middlesex | school | 2508340 | 198 | Natick | 250834001305 | 1980310 | Natick: Wilson Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 168 | 10 | 16 | 0 | 14 | 0 | 15 | 112 | 111 | 223.0 | 168 | 10 | 16 | 0 | 14 | 0 | 15 | 112 | 111 | 223 | |||||||||||||||||||||||||||||||||
2233987 | 2233987 | MA | Middlesex | school | 2508340 | 198 | Natick | 250834001297 | 1980305 | Natick: J F Kennedy Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 125 | 2 | 7 | 0 | 19 | 0 | 4 | 69 | 88 | 157.0 | 125 | 2 | 7 | 0 | 19 | 0 | 4 | 69 | 88 | 157 | |||||||||||||||||||||||||||||||||
2233943 | 2233943 | MA | Nantucket | school | 2508250 | 197 | Nantucket | 250825001281 | 1970010 | Nantucket: Cyrus Peirce | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 71 | 14 | 36 | 0 | 1 | 0 | 5 | 63 | 64 | 127.0 | 71 | 14 | 36 | 0 | 1 | 0 | 5 | 63 | 64 | 127 | |||||||||||||||||||||||||||||||||
2233920 | 2233920 | MA | Hampden | school | 2508040 | 191 | Monson | 250804001655 | 1910310 | Monson: Granite Valley Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 48 | 0 | 1 | 1 | 0 | 0 | 0 | 21 | 29 | 50.0 | 48 | 0 | 1 | 1 | 0 | 0 | 0 | 21 | 29 | 50 | |||||||||||||||||||||||||||||||||
2233902 | 2233902 | MA | Norfolk | school | 2507980 | 189 | Milton | 250798001257 | 1890410 | Milton: Charles S Pierce Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 215 | 55 | 12 | 0 | 16 | 0 | 7 | 133 | 172 | 305.0 | 215 | 55 | 12 | 0 | 16 | 0 | 7 | 133 | 172 | 305 | |||||||||||||||||||||||||||||||||
2233863 | 2233863 | MA | Norfolk | school | 2507920 | 187 | Millis | 250792001254 | 1870020 | Millis: Millis Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 89 | 1 | 12 | 0 | 0 | 0 | 3 | 53 | 52 | 105.0 | 89 | 1 | 12 | 0 | 0 | 0 | 3 | 53 | 52 | 105 | |||||||||||||||||||||||||||||||||
2233847 | 2233847 | MA | Worcester | school | 2507890 | 186 | Millbury | 250789001249 | 1860505 | Millbury: Millbury Junior/Senior High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 117 | 3 | 9 | 0 | 2 | 0 | 1 | 56 | 76 | 132.0 | 117 | 3 | 9 | 0 | 2 | 0 | 1 | 56 | 76 | 132 | |||||||||||||||||||||||||||||||||
2233829 | 2233829 | MA | Worcester | school | 2507860 | 185 | Milford | 250786001240 | 1850305 | Milford: Stacy Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 223 | 10 | 97 | 4 | 12 | 0 | 9 | 178 | 177 | 355.0 | 223 | 10 | 97 | 4 | 12 | 0 | 9 | 178 | 177 | 355 | |||||||||||||||||||||||||||||||||
2233796 | 2233796 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777001378 | 1820305 | Middleborough: John T. Nichols Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 215 | 6 | 12 | 4 | 6 | 0 | 10 | 114 | 139 | 253.0 | 215 | 6 | 12 | 4 | 6 | 0 | 10 | 114 | 139 | 253 | |||||||||||||||||||||||||||||||||
2233772 | 2233772 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001376 | 1810060 | Methuen: Donald P Timony Grammar | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 53 | 0 | 83 | 0 | 8 | 0 | 5 | 92 | 57 | 149.0 | 53 | 0 | 83 | 0 | 8 | 0 | 5 | 92 | 57 | 149 | |||||||||||||||||||||||||||||||||
2233761 | 2233761 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001556 | 1810055 | Methuen: Tenney Grammar School | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 80 | 0 | 72 | 0 | 6 | 0 | 14 | 94 | 78 | 172.0 | 80 | 0 | 72 | 0 | 6 | 0 | 14 | 94 | 78 | 172 | |||||||||||||||||||||||||||||||||
2233750 | 2233750 | MA | Essex | school | 2507740 | 181 | Methuen | 250774002558 | 1810050 | Methuen: Comprehensive Grammar School | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 59 | 2 | 46 | 0 | 8 | 0 | 8 | 58 | 65 | 123.0 | 59 | 2 | 46 | 0 | 8 | 0 | 8 | 58 | 65 | 123 | |||||||||||||||||||||||||||||||||
2233739 | 2233739 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001211 | 1810030 | Methuen: Marsh Grammar School | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 100 | 0 | 33 | 0 | 4 | 0 | 5 | 70 | 72 | 142.0 | 100 | 0 | 33 | 0 | 4 | 0 | 5 | 70 | 72 | 142 | |||||||||||||||||||||||||||||||||
2233723 | 2233723 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762002557 | 1780305 | Melrose: Melrose Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 196 | 17 | 8 | 2 | 12 | 0 | 12 | 123 | 124 | 247.0 | 196 | 17 | 8 | 2 | 12 | 0 | 12 | 123 | 124 | 247 | |||||||||||||||||||||||||||||||||
2233677 | 2233677 | MA | Norfolk | school | 2507590 | 177 | Medway | 250759002483 | 1770305 | Medway: Medway Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 158 | 1 | 8 | 1 | 5 | 0 | 2 | 79 | 96 | 175.0 | 158 | 1 | 8 | 1 | 5 | 0 | 2 | 79 | 96 | 175 | |||||||||||||||||||||||||||||||||
2233653 | 2233653 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756002063 | 1760320 | Medford: John J. McGlynn Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 89 | 25 | 25 | 0 | 20 | 0 | 3 | 83 | 79 | 162.0 | 89 | 25 | 25 | 0 | 20 | 0 | 3 | 83 | 79 | 162 | |||||||||||||||||||||||||||||||||
2233649 | 2233649 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756001638 | 1760315 | Medford: Madeleine Dugger Andrews | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 127 | 13 | 12 | 0 | 6 | 0 | 7 | 90 | 75 | 165.0 | 127 | 13 | 12 | 0 | 6 | 0 | 7 | 90 | 75 | 165 | |||||||||||||||||||||||||||||||||
2233608 | 2233608 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001156 | 1750305 | Medfield: Thomas Blake Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 192 | 2 | 6 | 1 | 10 | 0 | 7 | 103 | 115 | 218.0 | 192 | 2 | 6 | 1 | 10 | 0 | 7 | 103 | 115 | 218 | |||||||||||||||||||||||||||||||||
2233589 | 2233589 | MA | Middlesex | school | 2507500 | 174 | Maynard | 250750000105 | 1740305 | Maynard: Fowler School | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 70 | 2 | 11 | 0 | 2 | 0 | 5 | 48 | 42 | 90.0 | 70 | 2 | 11 | 0 | 2 | 0 | 5 | 48 | 42 | 90 | |||||||||||||||||||||||||||||||||
2233557 | 2233557 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744002638 | 1720020 | Mashpee: Mashpee Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 104 | 10 | 2 | 13 | 4 | 0 | 7 | 58 | 82 | 140.0 | 104 | 10 | 2 | 13 | 4 | 0 | 7 | 58 | 82 | 140 | |||||||||||||||||||||||||||||||||
2233544 | 2233544 | MA | Plymouth | school | 2507350 | 171 | Marshfield | 250735001143 | 1710310 | Marshfield: Furnace Brook Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 328 | 1 | 8 | 0 | 4 | 1 | 3 | 183 | 161 | 345.0 | 328 | 1 | 8 | 0 | 4 | 1 | 3 | 183 | 161 | 345 | |||||||||||||||||||||||||||||||||
2233498 | 2233498 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | Marlborough: 1 LT Charles W. Whitcomb School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 123 | 13 | 173 | 0 | 8 | 0 | 8 | 176 | 149 | 325.0 | 123 | 13 | 173 | 0 | 8 | 0 | 8 | 176 | 149 | 325 | |||||||||||||||||||||||||||||||||
2233459 | 2233459 | MA | Essex | school | 2507260 | 168 | Marblehead | 250726001789 | 1680300 | Marblehead: Marblehead Veterans Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 208 | 11 | 11 | 0 | 4 | 0 | 2 | 115 | 121 | 236.0 | 208 | 11 | 11 | 0 | 4 | 0 | 2 | 115 | 121 | 236 | |||||||||||||||||||||||||||||||||
2233430 | 2233430 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001112 | 1670035 | Mansfield: Harold L Qualters Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 280 | 5 | 15 | 0 | 12 | 0 | 14 | 175 | 151 | 326.0 | 280 | 5 | 15 | 0 | 12 | 0 | 14 | 175 | 151 | 326 | |||||||||||||||||||||||||||||||||
2233411 | 2233411 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001363 | 1650057 | Malden: Salemwood | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 32 | 33 | 45 | 0 | 23 | 0 | 1 | 66 | 68 | 134.0 | 32 | 33 | 45 | 0 | 23 | 0 | 1 | 66 | 68 | 134 | |||||||||||||||||||||||||||||||||
2233399 | 2233399 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001361 | 1650047 | Malden: Linden | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 34 | 16 | 18 | 1 | 19 | 0 | 3 | 44 | 47 | 91.0 | 34 | 16 | 18 | 1 | 19 | 0 | 3 | 44 | 47 | 91 | |||||||||||||||||||||||||||||||||
2233389 | 2233389 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001351 | 1650027 | Malden: Forestdale | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 22 | 11 | 22 | 0 | 7 | 0 | 0 | 32 | 30 | 62.0 | 22 | 11 | 22 | 0 | 7 | 0 | 0 | 32 | 30 | 62 | |||||||||||||||||||||||||||||||||
2233379 | 2233379 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001345 | 1650013 | Malden: Ferryway | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 18 | 18 | 26 | 0 | 17 | 0 | 5 | 41 | 43 | 84.0 | 18 | 18 | 26 | 0 | 17 | 0 | 5 | 41 | 43 | 84 | |||||||||||||||||||||||||||||||||
2233369 | 2233369 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001344 | 1650003 | Malden: Beebe | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 23 | 11 | 10 | 0 | 41 | 0 | 2 | 40 | 47 | 87.0 | 23 | 11 | 10 | 0 | 41 | 0 | 2 | 40 | 47 | 87 | |||||||||||||||||||||||||||||||||
2233354 | 2233354 | MA | Essex | school | 2507140 | 164 | Lynnfield | 250714001091 | 1640405 | Lynnfield: Lynnfield Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 129 | 3 | 13 | 0 | 9 | 0 | 5 | 90 | 69 | 159.0 | 129 | 3 | 13 | 0 | 9 | 0 | 5 | 90 | 69 | 159 | |||||||||||||||||||||||||||||||||
2233332 | 2233332 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002277 | 1630605 | Lynn: Lynn Vocational Technical Institute | Career and Technical School | No | High | 06 | 12 | 2018 | grade_7 | * | * | * | * | * | * | * | 2 | 1 | 3.0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||||
2233323 | 2233323 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002647 | 1630525 | Lynn: Fecteau-Leary Junior/Senior High School | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 2 | 2 | 3 | 1 | 0 | 0 | 0 | 4 | 4 | 8.0 | 2 | 2 | 3 | 1 | 0 | 0 | 0 | 4 | 4 | 8 | |||||||||||||||||||||||||||||||||
2233310 | 2233310 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001083 | 1630420 | Lynn: Pickering Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 66 | 20 | 79 | 2 | 22 | 0 | 10 | 103 | 96 | 199.0 | 66 | 20 | 79 | 2 | 22 | 0 | 10 | 103 | 96 | 199 | |||||||||||||||||||||||||||||||||
2233306 | 2233306 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001063 | 1630405 | Lynn: Breed Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 67 | 37 | 264 | 1 | 49 | 0 | 16 | 216 | 218 | 434.0 | 67 | 37 | 264 | 1 | 49 | 0 | 16 | 216 | 218 | 434 | |||||||||||||||||||||||||||||||||
2233302 | 2233302 | MA | Essex | school | 2507110 | 163 | Lynn | 250711000301 | 1630305 | Lynn: Thurgood Marshall Mid | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 41 | 40 | 269 | 0 | 35 | 0 | 13 | 195 | 203 | 398.0 | 41 | 40 | 269 | 0 | 35 | 0 | 13 | 195 | 203 | 398 | |||||||||||||||||||||||||||||||||
2233162 | 2233162 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002870 | 1620305 | Lunenburg: Lunenburg Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 107 | 2 | 12 | 0 | 2 | 0 | 2 | 74 | 51 | 125.0 | 107 | 2 | 12 | 0 | 2 | 0 | 2 | 74 | 51 | 125 | |||||||||||||||||||||||||||||||||
2233144 | 2233144 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705001055 | 1610305 | Ludlow: Paul R Baird Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 187 | 2 | 15 | 2 | 2 | 0 | 1 | 99 | 110 | 209.0 | 187 | 2 | 15 | 2 | 2 | 0 | 1 | 99 | 110 | 209 | |||||||||||||||||||||||||||||||||
2233115 | 2233115 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001955 | 1600360 | Lowell: Kathryn P. Stoklosa Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 16 | 6 | 55 | 0 | 85 | 0 | 6 | 91 | 77 | 168.0 | 16 | 6 | 55 | 0 | 85 | 0 | 6 | 91 | 77 | 168 | |||||||||||||||||||||||||||||||||
2233110 | 2233110 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000086 | 1600345 | Lowell: Dr An Wang School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 35 | 16 | 70 | 0 | 23 | 0 | 6 | 92 | 58 | 150.0 | 35 | 16 | 70 | 0 | 23 | 0 | 6 | 92 | 58 | 150 | |||||||||||||||||||||||||||||||||
2233105 | 2233105 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000073 | 1600340 | Lowell: James Sullivan Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 48 | 13 | 57 | 0 | 21 | 0 | 5 | 77 | 67 | 144.0 | 48 | 13 | 57 | 0 | 21 | 0 | 5 | 77 | 67 | 144 | |||||||||||||||||||||||||||||||||
2233100 | 2233100 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001034 | 1600330 | Lowell: Henry J Robinson Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 37 | 23 | 63 | 0 | 26 | 0 | 7 | 83 | 73 | 156.0 | 37 | 23 | 63 | 0 | 26 | 0 | 7 | 83 | 73 | 156 | |||||||||||||||||||||||||||||||||
2233090 | 2233090 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001036 | 1600315 | Lowell: James S Daley Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 46 | 8 | 35 | 0 | 76 | 0 | 8 | 93 | 80 | 173.0 | 46 | 8 | 35 | 0 | 76 | 0 | 8 | 93 | 80 | 173 | |||||||||||||||||||||||||||||||||
2233085 | 2233085 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001026 | 1600310 | Lowell: B.F. Butler Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 39 | 11 | 41 | 0 | 30 | 0 | 6 | 68 | 59 | 127.0 | 39 | 11 | 41 | 0 | 30 | 0 | 6 | 68 | 59 | 127 | |||||||||||||||||||||||||||||||||
2233080 | 2233080 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001954 | 1600090 | Lowell: Bartlett Community Partnership | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 8 | 3 | 24 | 0 | 19 | 0 | 1 | 22 | 33 | 55.0 | 8 | 3 | 24 | 0 | 19 | 0 | 1 | 22 | 33 | 55 | |||||||||||||||||||||||||||||||||
2233069 | 2233069 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002726 | 1600085 | Lowell: Laura Lee Therapeutic Day School | Regular School | No | Middle | KG | 08 | 2018 | grade_7 | * | * | * | * | * | * | * | 4 | * | 5.0 | 4 | 5 | |||||||||||||||||||||||||||||||||||||||||
2232999 | 2232999 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001038 | 1600018 | Lowell: Pyne Arts | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 24 | 1 | 20 | 0 | 9 | 0 | 2 | 30 | 26 | 56.0 | 24 | 1 | 20 | 0 | 9 | 0 | 2 | 30 | 26 | 56 | |||||||||||||||||||||||||||||||||
2232953 | 2232953 | MA | Hampden | school | 2506990 | 159 | Longmeadow | 250699000743 | 1590305 | Longmeadow: Williams Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 84 | 1 | 4 | 0 | 6 | 0 | 3 | 61 | 37 | 98.0 | 84 | 1 | 4 | 0 | 6 | 0 | 3 | 61 | 37 | 98 | |||||||||||||||||||||||||||||||||
2232941 | 2232941 | MA | Hampden | school | 2506990 | 159 | Longmeadow | 250699001019 | 1590017 | Longmeadow: Glenbrook Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 87 | 4 | 6 | 0 | 14 | 0 | 2 | 57 | 56 | 113.0 | 87 | 4 | 6 | 0 | 14 | 0 | 2 | 57 | 56 | 113 | |||||||||||||||||||||||||||||||||
2232918 | 2232918 | MA | Middlesex | school | 2506960 | 158 | Littleton | 250696001628 | 1580305 | Littleton: Littleton Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 103 | 0 | 1 | 1 | 8 | 0 | 6 | 57 | 62 | 119.0 | 103 | 0 | 1 | 1 | 8 | 0 | 6 | 57 | 62 | 119 | |||||||||||||||||||||||||||||||||
2232905 | 2232905 | MA | Middlesex | school | 2506900 | 157 | Lincoln | 250690001008 | 1570305 | Lincoln: Hanscom Middle | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 30 | 5 | 7 | 0 | 1 | 0 | 3 | 20 | 26 | 46.0 | 30 | 5 | 7 | 0 | 1 | 0 | 3 | 20 | 26 | 46 |
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]);