enrollments
Data source: Big Local News · About: Big Local
11,284 rows where state = "MA" and year = 2018 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2232680 | 2232680 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002856 | 1490515 | Lawrence: Lawrence High School | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 30 | 6 | 854 | 0 | 20 | 0 | 1 | 500 | 411 | 911.0 | 30 | 6 | 854 | 0 | 20 | 0 | 1 | 500 | 411 | 911 | |||||||||||||||||||||||||||||||||
2232681 | 2232681 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002856 | 1490515 | Lawrence: Lawrence High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 29 | 15 | 826 | 1 | 10 | 0 | 1 | 483 | 399 | 882.0 | 29 | 15 | 826 | 1 | 10 | 0 | 1 | 483 | 399 | 882 | |||||||||||||||||||||||||||||||||
2232682 | 2232682 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002856 | 1490515 | Lawrence: Lawrence High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 21 | 13 | 688 | 1 | 13 | 0 | 5 | 363 | 378 | 741.0 | 21 | 13 | 688 | 1 | 13 | 0 | 5 | 363 | 378 | 741 | |||||||||||||||||||||||||||||||||
2232683 | 2232683 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002856 | 1490515 | Lawrence: Lawrence High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 24 | 13 | 679 | 0 | 14 | 0 | 1 | 344 | 387 | 731.0 | 24 | 13 | 679 | 0 | 14 | 0 | 1 | 344 | 387 | 731 | |||||||||||||||||||||||||||||||||
2230890 | 2230890 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000235 | 570003 | Chelsea: Shurtleff Early Childhood | Regular School | No | Elementary | PK | 01 | 2018 | kindergarten | 39 | 33 | 429 | 0 | 8 | 0 | 4 | 241 | 272 | 513.0 | 39 | 33 | 429 | 0 | 8 | 0 | 4 | 241 | 272 | 513 | |||||||||||||||||||||||||||||||||
2236218 | 2236218 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield: Springfield Central High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 76 | 162 | 408 | 0 | 34 | 0 | 7 | 394 | 293 | 687.0 | 76 | 162 | 408 | 0 | 34 | 0 | 7 | 394 | 293 | 687 | |||||||||||||||||||||||||||||||||
2232436 | 2232436 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000900 | 1370505 | Holyoke: Holyoke High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 74 | 6 | 378 | 1 | 4 | 0 | 2 | 254 | 211 | 465.0 | 74 | 6 | 378 | 1 | 4 | 0 | 2 | 254 | 211 | 465 | |||||||||||||||||||||||||||||||||
2235358 | 2235358 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001630 | 2480505 | Revere: Revere High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 184 | 19 | 363 | 8 | 30 | 0 | 10 | 320 | 294 | 614.0 | 184 | 19 | 363 | 8 | 30 | 0 | 10 | 320 | 294 | 614 | |||||||||||||||||||||||||||||||||
2230930 | 2230930 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000482 | 570505 | Chelsea: Chelsea High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 21 | 21 | 361 | 0 | 7 | 1 | 2 | 218 | 195 | 413.0 | 21 | 21 | 361 | 0 | 7 | 1 | 2 | 218 | 195 | 413 | |||||||||||||||||||||||||||||||||
2230931 | 2230931 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000482 | 570505 | Chelsea: Chelsea High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 17 | 22 | 346 | 0 | 6 | 0 | 2 | 206 | 187 | 393.0 | 17 | 22 | 346 | 0 | 6 | 0 | 2 | 206 | 187 | 393 | |||||||||||||||||||||||||||||||||
2233318 | 2233318 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001080 | 1630510 | Lynn: Lynn English High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 73 | 44 | 345 | 1 | 41 | 0 | 13 | 317 | 200 | 517.0 | 73 | 44 | 345 | 1 | 41 | 0 | 13 | 317 | 200 | 517 | |||||||||||||||||||||||||||||||||
2230929 | 2230929 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000482 | 570505 | Chelsea: Chelsea High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 17 | 29 | 343 | 0 | 8 | 0 | 1 | 236 | 162 | 398.0 | 17 | 29 | 343 | 0 | 8 | 0 | 1 | 236 | 162 | 398 | |||||||||||||||||||||||||||||||||
2239827 | 2239827 | MA | Essex | school | 2505470 | 823 | Greater Lawrence Regional Vocational Technical | 250547002267 | 8230605 | Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_9 | 66 | 3 | 341 | 1 | 8 | 0 | 0 | 217 | 202 | 419.0 | 66 | 3 | 341 | 1 | 8 | 0 | 0 | 217 | 202 | 419 | |||||||||||||||||||||||||||||||||
2239828 | 2239828 | MA | Essex | school | 2505470 | 823 | Greater Lawrence Regional Vocational Technical | 250547002267 | 8230605 | Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_10 | 60 | 3 | 328 | 1 | 4 | 0 | 0 | 180 | 216 | 396.0 | 60 | 3 | 328 | 1 | 4 | 0 | 0 | 180 | 216 | 396 | |||||||||||||||||||||||||||||||||
2233301 | 2233301 | MA | Essex | school | 2507110 | 163 | Lynn | 250711000301 | 1630305 | Lynn: Thurgood Marshall Mid | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 45 | 45 | 317 | 0 | 33 | 0 | 15 | 230 | 225 | 455.0 | 45 | 45 | 317 | 0 | 33 | 0 | 15 | 230 | 225 | 455 | |||||||||||||||||||||||||||||||||
2233305 | 2233305 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001063 | 1630405 | Lynn: Breed Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 49 | 45 | 316 | 0 | 41 | 0 | 19 | 265 | 205 | 470.0 | 49 | 45 | 316 | 0 | 41 | 0 | 19 | 265 | 205 | 470 | |||||||||||||||||||||||||||||||||
2239829 | 2239829 | MA | Essex | school | 2505470 | 823 | Greater Lawrence Regional Vocational Technical | 250547002267 | 8230605 | Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_11 | 65 | 6 | 305 | 0 | 2 | 0 | 0 | 193 | 185 | 378.0 | 65 | 6 | 305 | 0 | 2 | 0 | 0 | 193 | 185 | 378 | |||||||||||||||||||||||||||||||||
2236219 | 2236219 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield: Springfield Central High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 76 | 121 | 298 | 1 | 28 | 1 | 5 | 267 | 263 | 530.0 | 76 | 121 | 298 | 1 | 28 | 1 | 5 | 267 | 263 | 530 | |||||||||||||||||||||||||||||||||
2233303 | 2233303 | MA | Essex | school | 2507110 | 163 | Lynn | 250711000301 | 1630305 | Lynn: Thurgood Marshall Mid | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 53 | 40 | 291 | 6 | 35 | 0 | 15 | 227 | 213 | 440.0 | 53 | 40 | 291 | 6 | 35 | 0 | 15 | 227 | 213 | 440 | |||||||||||||||||||||||||||||||||
2237559 | 2237559 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002684 | 3480002 | Worcester: Head Start | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 104 | 107 | 290 | 0 | 12 | 0 | 16 | 254 | 275 | 529.0 | 104 | 107 | 290 | 0 | 12 | 0 | 16 | 254 | 275 | 529 | |||||||||||||||||||||||||||||||||
2230107 | 2230107 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000226 | 350530 | Boston: East Boston High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 45 | 30 | 286 | 2 | 5 | 0 | 4 | 200 | 172 | 372.0 | 45 | 30 | 286 | 2 | 5 | 0 | 4 | 200 | 172 | 372 | |||||||||||||||||||||||||||||||||
2233319 | 2233319 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001080 | 1630510 | Lynn: Lynn English High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 66 | 30 | 286 | 0 | 48 | 0 | 10 | 217 | 223 | 440.0 | 66 | 30 | 286 | 0 | 48 | 0 | 10 | 217 | 223 | 440 | |||||||||||||||||||||||||||||||||
2234204 | 2234204 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001336 | 2010505 | New Bedford: New Bedford High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 179 | 90 | 285 | 4 | 5 | 1 | 22 | 325 | 261 | 586.0 | 179 | 90 | 285 | 4 | 5 | 1 | 22 | 325 | 261 | 586 | |||||||||||||||||||||||||||||||||
2230932 | 2230932 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000482 | 570505 | Chelsea: Chelsea High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 16 | 21 | 283 | 0 | 12 | 0 | 1 | 160 | 173 | 333.0 | 16 | 21 | 283 | 0 | 12 | 0 | 1 | 160 | 173 | 333 | |||||||||||||||||||||||||||||||||
2236228 | 2236228 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000901 | 2810530 | Springfield: Springfield High School of Science and Technology | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 27 | 69 | 281 | 0 | 6 | 0 | 1 | 229 | 155 | 384.0 | 27 | 69 | 281 | 0 | 6 | 0 | 1 | 229 | 155 | 384 | |||||||||||||||||||||||||||||||||
2230105 | 2230105 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000226 | 350530 | Boston: East Boston High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 34 | 17 | 277 | 0 | 6 | 0 | 6 | 222 | 118 | 340.0 | 34 | 17 | 277 | 0 | 6 | 0 | 6 | 222 | 118 | 340 | |||||||||||||||||||||||||||||||||
2233313 | 2233313 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001067 | 1630505 | Lynn: Classical High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 68 | 30 | 274 | 2 | 30 | 0 | 7 | 240 | 171 | 411.0 | 68 | 30 | 274 | 2 | 30 | 0 | 7 | 240 | 171 | 411 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2230108 | 2230108 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000226 | 350530 | Boston: East Boston High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 43 | 36 | 268 | 2 | 6 | 0 | 3 | 200 | 158 | 358.0 | 43 | 36 | 268 | 2 | 6 | 0 | 3 | 200 | 158 | 358 | |||||||||||||||||||||||||||||||||
2231502 | 2231502 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000634 | 930505 | Everett: Everett High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 132 | 91 | 266 | 2 | 27 | 2 | 5 | 271 | 254 | 525.0 | 132 | 91 | 266 | 2 | 27 | 2 | 5 | 271 | 254 | 525 | |||||||||||||||||||||||||||||||||
2236229 | 2236229 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000901 | 2810530 | Springfield: Springfield High School of Science and Technology | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 35 | 64 | 265 | 1 | 6 | 1 | 6 | 225 | 153 | 378.0 | 35 | 64 | 265 | 1 | 6 | 1 | 6 | 225 | 153 | 378 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2239830 | 2239830 | MA | Essex | school | 2505470 | 823 | Greater Lawrence Regional Vocational Technical | 250547002267 | 8230605 | Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_12 | 47 | 2 | 263 | 0 | 4 | 0 | 0 | 163 | 153 | 316.0 | 47 | 2 | 263 | 0 | 4 | 0 | 0 | 163 | 153 | 316 | |||||||||||||||||||||||||||||||||
2235360 | 2235360 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001630 | 2480505 | Revere: Revere High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 146 | 25 | 262 | 2 | 36 | 0 | 10 | 234 | 247 | 481.0 | 146 | 25 | 262 | 2 | 36 | 0 | 10 | 234 | 247 | 481 | |||||||||||||||||||||||||||||||||
2236255 | 2236255 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002293 | 2810620 | Springfield: Roger L. Putnam Vocational Technical Academy | Career and Technical School | No | High | 09 | 12 | 2018 | grade_9 | 29 | 71 | 260 | 1 | 3 | 0 | 3 | 180 | 187 | 367.0 | 29 | 71 | 260 | 1 | 3 | 0 | 3 | 180 | 187 | 367 | |||||||||||||||||||||||||||||||||
2233314 | 2233314 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001067 | 1630505 | Lynn: Classical High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 92 | 44 | 258 | 1 | 47 | 0 | 9 | 254 | 197 | 451.0 | 92 | 44 | 258 | 1 | 47 | 0 | 9 | 254 | 197 | 451 | |||||||||||||||||||||||||||||||||
2236223 | 2236223 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001806 | 2810510 | Springfield: High School Of Commerce | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 35 | 53 | 257 | 0 | 6 | 0 | 5 | 177 | 179 | 356.0 | 35 | 53 | 257 | 0 | 6 | 0 | 5 | 177 | 179 | 356 | |||||||||||||||||||||||||||||||||
2233307 | 2233307 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001063 | 1630405 | Lynn: Breed Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 65 | 40 | 256 | 4 | 52 | 0 | 12 | 223 | 206 | 429.0 | 65 | 40 | 256 | 4 | 52 | 0 | 12 | 223 | 206 | 429 | |||||||||||||||||||||||||||||||||
2236256 | 2236256 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002293 | 2810620 | Springfield: Roger L. Putnam Vocational Technical Academy | Career and Technical School | No | High | 09 | 12 | 2018 | grade_10 | 48 | 66 | 255 | 0 | 6 | 0 | 1 | 164 | 212 | 376.0 | 48 | 66 | 255 | 0 | 6 | 0 | 1 | 164 | 212 | 376 | |||||||||||||||||||||||||||||||||
2235361 | 2235361 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001630 | 2480505 | Revere: Revere High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 134 | 24 | 253 | 0 | 28 | 0 | 7 | 224 | 222 | 446.0 | 134 | 24 | 253 | 0 | 28 | 0 | 7 | 224 | 222 | 446 | |||||||||||||||||||||||||||||||||
2234205 | 2234205 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001336 | 2010505 | New Bedford: New Bedford High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 152 | 75 | 252 | 2 | 8 | 2 | 19 | 280 | 230 | 510.0 | 152 | 75 | 252 | 2 | 8 | 2 | 19 | 280 | 230 | 510 | |||||||||||||||||||||||||||||||||
2231503 | 2231503 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000634 | 930505 | Everett: Everett High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 141 | 96 | 251 | 1 | 23 | 1 | 5 | 260 | 258 | 518.0 | 141 | 96 | 251 | 1 | 23 | 1 | 5 | 260 | 258 | 518 | |||||||||||||||||||||||||||||||||
2232437 | 2232437 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000900 | 1370505 | Holyoke: Holyoke High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 59 | 6 | 244 | 0 | 3 | 0 | 5 | 146 | 170 | 317.0 | 59 | 6 | 244 | 0 | 3 | 0 | 5 | 146 | 170 | 317 | |||||||||||||||||||||||||||||||||
2233118 | 2233118 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001041 | 1600505 | Lowell: Lowell High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 214 | 80 | 242 | 1 | 256 | 0 | 29 | 409 | 413 | 822.0 | 214 | 80 | 242 | 1 | 256 | 0 | 29 | 409 | 413 | 822 | |||||||||||||||||||||||||||||||||
2235359 | 2235359 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001630 | 2480505 | Revere: Revere High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 150 | 12 | 240 | 2 | 28 | 0 | 11 | 226 | 217 | 443.0 | 150 | 12 | 240 | 2 | 28 | 0 | 11 | 226 | 217 | 443 | |||||||||||||||||||||||||||||||||
2236257 | 2236257 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002293 | 2810620 | Springfield: Roger L. Putnam Vocational Technical Academy | Career and Technical School | No | High | 09 | 12 | 2018 | grade_11 | 36 | 58 | 240 | 0 | 6 | 0 | 1 | 155 | 186 | 341.0 | 36 | 58 | 240 | 0 | 6 | 0 | 1 | 155 | 186 | 341 | |||||||||||||||||||||||||||||||||
2233320 | 2233320 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001080 | 1630510 | Lynn: Lynn English High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 62 | 45 | 238 | 1 | 23 | 0 | 11 | 210 | 170 | 380.0 | 62 | 45 | 238 | 1 | 23 | 0 | 11 | 210 | 170 | 380 | |||||||||||||||||||||||||||||||||
2230891 | 2230891 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000235 | 570003 | Chelsea: Shurtleff Early Childhood | Regular School | No | Elementary | PK | 01 | 2018 | pre_kindergarten | 29 | 8 | 236 | 0 | 0 | 0 | 2 | 151 | 124 | 275.0 | 29 | 8 | 236 | 0 | 0 | 0 | 2 | 151 | 124 | 275 | |||||||||||||||||||||||||||||||||
2236764 | 2236764 | MA | Middlesex | school | 2512000 | 308 | Waltham | 251200001979 | 3080505 | Waltham: Waltham Sr High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 164 | 37 | 232 | 1 | 16 | 0 | 6 | 271 | 185 | 456.0 | 164 | 37 | 232 | 1 | 16 | 0 | 6 | 271 | 185 | 456 | |||||||||||||||||||||||||||||||||
2230106 | 2230106 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000226 | 350530 | Boston: East Boston High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 27 | 11 | 228 | 1 | 4 | 0 | 3 | 147 | 127 | 274.0 | 27 | 11 | 228 | 1 | 4 | 0 | 3 | 147 | 127 | 274 | |||||||||||||||||||||||||||||||||
2234203 | 2234203 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001336 | 2010505 | New Bedford: New Bedford High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 172 | 81 | 227 | 4 | 5 | 2 | 26 | 284 | 233 | 517.0 | 172 | 81 | 227 | 4 | 5 | 2 | 26 | 284 | 233 | 517 | |||||||||||||||||||||||||||||||||
2233321 | 2233321 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001080 | 1630510 | Lynn: Lynn English High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 74 | 46 | 221 | 0 | 30 | 0 | 15 | 207 | 179 | 386.0 | 74 | 46 | 221 | 0 | 30 | 0 | 15 | 207 | 179 | 386 | |||||||||||||||||||||||||||||||||
2231501 | 2231501 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000634 | 930505 | Everett: Everett High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 100 | 86 | 212 | 0 | 28 | 0 | 10 | 230 | 206 | 436.0 | 100 | 86 | 212 | 0 | 28 | 0 | 10 | 230 | 206 | 436 | |||||||||||||||||||||||||||||||||
2237867 | 2237867 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002223 | 3480423 | Worcester: Sullivan Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 92 | 67 | 210 | 1 | 38 | 0 | 16 | 226 | 198 | 424.0 | 92 | 67 | 210 | 1 | 38 | 0 | 16 | 226 | 198 | 424 | |||||||||||||||||||||||||||||||||
2231504 | 2231504 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000634 | 930505 | Everett: Everett High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 150 | 112 | 208 | 2 | 23 | 0 | 5 | 253 | 247 | 500.0 | 150 | 112 | 208 | 2 | 23 | 0 | 5 | 253 | 247 | 500 | |||||||||||||||||||||||||||||||||
2233315 | 2233315 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001067 | 1630505 | Lynn: Classical High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 114 | 43 | 205 | 1 | 46 | 1 | 10 | 224 | 196 | 420.0 | 114 | 43 | 205 | 1 | 46 | 1 | 10 | 224 | 196 | 420 | |||||||||||||||||||||||||||||||||
2236258 | 2236258 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002293 | 2810620 | Springfield: Roger L. Putnam Vocational Technical Academy | Career and Technical School | No | High | 09 | 12 | 2018 | grade_12 | 49 | 88 | 205 | 0 | 5 | 0 | 5 | 160 | 192 | 352.0 | 49 | 88 | 205 | 0 | 5 | 0 | 5 | 160 | 192 | 352 | |||||||||||||||||||||||||||||||||
2237863 | 2237863 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002253 | 3480420 | Worcester: Worcester East Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 78 | 69 | 204 | 0 | 22 | 0 | 17 | 196 | 194 | 390.0 | 78 | 69 | 204 | 0 | 22 | 0 | 17 | 196 | 194 | 390 | |||||||||||||||||||||||||||||||||
2233334 | 2233334 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002277 | 1630605 | Lynn: Lynn Vocational Technical Institute | Career and Technical School | No | High | 06 | 12 | 2018 | grade_10 | 36 | 10 | 200 | 0 | 13 | 0 | 7 | 150 | 116 | 266.0 | 36 | 10 | 200 | 0 | 13 | 0 | 7 | 150 | 116 | 266 | |||||||||||||||||||||||||||||||||
2233119 | 2233119 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001041 | 1600505 | Lowell: Lowell High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 227 | 93 | 199 | 0 | 240 | 1 | 20 | 393 | 387 | 780.0 | 227 | 93 | 199 | 0 | 240 | 1 | 20 | 393 | 387 | 780 | |||||||||||||||||||||||||||||||||
2236230 | 2236230 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000901 | 2810530 | Springfield: Springfield High School of Science and Technology | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 40 | 52 | 198 | 0 | 6 | 0 | 4 | 165 | 135 | 300.0 | 40 | 52 | 198 | 0 | 6 | 0 | 4 | 165 | 135 | 300 | |||||||||||||||||||||||||||||||||
2232268 | 2232268 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000856 | 1280505 | Haverhill: Haverhill High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 339 | 25 | 197 | 1 | 6 | 0 | 8 | 309 | 267 | 576.0 | 339 | 25 | 197 | 1 | 6 | 0 | 8 | 309 | 267 | 576 | |||||||||||||||||||||||||||||||||
2236220 | 2236220 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield: Springfield Central High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 76 | 109 | 196 | 0 | 39 | 1 | 7 | 220 | 208 | 428.0 | 76 | 109 | 196 | 0 | 39 | 1 | 7 | 220 | 208 | 428 | |||||||||||||||||||||||||||||||||
2232578 | 2232578 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000730 | 1490003 | Lawrence: John Breen School | Regular School | No | Elementary | PK | KG | 2018 | pre_kindergarten | 10 | 6 | 195 | 0 | 7 | 0 | 1 | 123 | 96 | 219.0 | 10 | 6 | 195 | 0 | 7 | 0 | 1 | 123 | 96 | 219 | |||||||||||||||||||||||||||||||||
2236221 | 2236221 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield: Springfield Central High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 82 | 96 | 195 | 0 | 26 | 0 | 5 | 212 | 192 | 404.0 | 82 | 96 | 195 | 0 | 26 | 0 | 5 | 212 | 192 | 404 | |||||||||||||||||||||||||||||||||
2239837 | 2239837 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_9 | 277 | 29 | 195 | 1 | 98 | 0 | 20 | 335 | 285 | 620.0 | 277 | 29 | 195 | 1 | 98 | 0 | 20 | 335 | 285 | 620 | |||||||||||||||||||||||||||||||||
2232439 | 2232439 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000900 | 1370505 | Holyoke: Holyoke High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 83 | 8 | 192 | 0 | 3 | 0 | 7 | 159 | 134 | 293.0 | 83 | 8 | 192 | 0 | 3 | 0 | 7 | 159 | 134 | 293 | |||||||||||||||||||||||||||||||||
2233120 | 2233120 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001041 | 1600505 | Lowell: Lowell High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 222 | 104 | 192 | 0 | 243 | 0 | 19 | 380 | 400 | 780.0 | 222 | 104 | 192 | 0 | 243 | 0 | 19 | 380 | 400 | 780 | |||||||||||||||||||||||||||||||||
2236194 | 2236194 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002830 | 2810365 | Springfield: Chestnut Academy | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 9 | 26 | 190 | 1 | 1 | 0 | 2 | 121 | 108 | 229.0 | 9 | 26 | 190 | 1 | 1 | 0 | 2 | 121 | 108 | 229 | |||||||||||||||||||||||||||||||||
2233776 | 2233776 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001213 | 1810505 | Methuen: Methuen High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 253 | 3 | 189 | 0 | 17 | 1 | 30 | 260 | 233 | 493.0 | 253 | 3 | 189 | 0 | 17 | 1 | 30 | 260 | 233 | 493 | |||||||||||||||||||||||||||||||||
2233775 | 2233775 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001213 | 1810505 | Methuen: Methuen High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 258 | 4 | 188 | 1 | 24 | 0 | 23 | 264 | 234 | 498.0 | 258 | 4 | 188 | 1 | 24 | 0 | 23 | 264 | 234 | 498 | |||||||||||||||||||||||||||||||||
2239838 | 2239838 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_10 | 246 | 20 | 188 | 1 | 90 | 0 | 19 | 297 | 267 | 564.0 | 246 | 20 | 188 | 1 | 90 | 0 | 19 | 297 | 267 | 564 | |||||||||||||||||||||||||||||||||
2239839 | 2239839 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_11 | 227 | 21 | 185 | 2 | 87 | 0 | 23 | 317 | 228 | 545.0 | 227 | 21 | 185 | 2 | 87 | 0 | 23 | 317 | 228 | 545 | |||||||||||||||||||||||||||||||||
2233316 | 2233316 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001067 | 1630505 | Lynn: Classical High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 81 | 48 | 182 | 2 | 53 | 0 | 12 | 181 | 197 | 378.0 | 81 | 48 | 182 | 2 | 53 | 0 | 12 | 181 | 197 | 378 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2232438 | 2232438 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000900 | 1370505 | Holyoke: Holyoke High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 61 | 12 | 179 | 0 | 1 | 1 | 3 | 127 | 130 | 257.0 | 61 | 12 | 179 | 0 | 1 | 1 | 3 | 127 | 130 | 257 | |||||||||||||||||||||||||||||||||
2230229 | 2230229 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002721 | 350656 | Boston: Mario Umana Academy | Regular School | No | Elementary | PK | 08 | 2018 | grade_6 | 16 | 5 | 177 | 0 | 6 | 0 | 1 | 104 | 101 | 205.0 | 16 | 5 | 177 | 0 | 6 | 0 | 1 | 104 | 101 | 205 | |||||||||||||||||||||||||||||||||
2236226 | 2236226 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001806 | 2810510 | Springfield: High School Of Commerce | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 24 | 53 | 175 | 0 | 2 | 0 | 3 | 142 | 115 | 257.0 | 24 | 53 | 175 | 0 | 2 | 0 | 3 | 142 | 115 | 257 | |||||||||||||||||||||||||||||||||
2237864 | 2237864 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002253 | 3480420 | Worcester: Worcester East Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 76 | 57 | 175 | 0 | 22 | 0 | 8 | 174 | 164 | 338.0 | 76 | 57 | 175 | 0 | 22 | 0 | 8 | 174 | 164 | 338 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2237859 | 2237859 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002213 | 3480415 | Worcester: Forest Grove Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 199 | 65 | 173 | 1 | 23 | 0 | 25 | 238 | 248 | 486.0 | 199 | 65 | 173 | 1 | 23 | 0 | 25 | 238 | 248 | 486 | |||||||||||||||||||||||||||||||||
2237860 | 2237860 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002213 | 3480415 | Worcester: Forest Grove Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 213 | 57 | 173 | 0 | 27 | 0 | 22 | 259 | 233 | 492.0 | 213 | 57 | 173 | 0 | 27 | 0 | 22 | 259 | 233 | 492 | |||||||||||||||||||||||||||||||||
2237885 | 2237885 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002244 | 3480520 | Worcester: South High Community | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 84 | 53 | 173 | 0 | 38 | 0 | 15 | 185 | 178 | 363.0 | 84 | 53 | 173 | 0 | 38 | 0 | 15 | 185 | 178 | 363 | |||||||||||||||||||||||||||||||||
2236165 | 2236165 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Springfield: Forest Park Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 8 | 43 | 168 | 0 | 24 | 0 | 1 | 120 | 124 | 244.0 | 8 | 43 | 168 | 0 | 24 | 0 | 1 | 120 | 124 | 244 | |||||||||||||||||||||||||||||||||
2237886 | 2237886 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002244 | 3480520 | Worcester: South High Community | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 79 | 60 | 168 | 0 | 47 | 0 | 9 | 189 | 174 | 363.0 | 79 | 60 | 168 | 0 | 47 | 0 | 9 | 189 | 174 | 363 | |||||||||||||||||||||||||||||||||
2233333 | 2233333 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002277 | 1630605 | Lynn: Lynn Vocational Technical Institute | Career and Technical School | No | High | 06 | 12 | 2018 | grade_9 | 42 | 21 | 167 | 0 | 20 | 0 | 6 | 145 | 111 | 256.0 | 42 | 21 | 167 | 0 | 20 | 0 | 6 | 145 | 111 | 256 | |||||||||||||||||||||||||||||||||
2237880 | 2237880 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002239 | 3480515 | Worcester: North High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 58 | 81 | 167 | 0 | 22 | 0 | 13 | 170 | 171 | 341.0 | 58 | 81 | 167 | 0 | 22 | 0 | 13 | 170 | 171 | 341 | |||||||||||||||||||||||||||||||||
2231631 | 2231631 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000649 | 950505 | Fall River: B M C Durfee High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 345 | 47 | 164 | 0 | 31 | 0 | 28 | 317 | 298 | 615.0 | 345 | 47 | 164 | 0 | 31 | 0 | 28 | 317 | 298 | 615 | |||||||||||||||||||||||||||||||||
2235913 | 2235913 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001794 | 2810010 | Springfield: Edward P. Boland School | Regular School | No | Elementary | PK | 05 | 2018 | pre_kindergarten | 21 | 12 | 164 | 0 | 5 | 0 | 2 | 115 | 89 | 204.0 | 21 | 12 | 164 | 0 | 5 | 0 | 2 | 115 | 89 | 204 | |||||||||||||||||||||||||||||||||
2237868 | 2237868 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002223 | 3480423 | Worcester: Sullivan Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 103 | 56 | 164 | 1 | 49 | 0 | 20 | 199 | 194 | 393.0 | 103 | 56 | 164 | 1 | 49 | 0 | 20 | 199 | 194 | 393 | |||||||||||||||||||||||||||||||||
2236167 | 2236167 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Springfield: Forest Park Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 13 | 51 | 163 | 0 | 20 | 1 | 3 | 129 | 122 | 251.0 | 13 | 51 | 163 | 0 | 20 | 1 | 3 | 129 | 122 | 251 | |||||||||||||||||||||||||||||||||
2236224 | 2236224 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001806 | 2810510 | Springfield: High School Of Commerce | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 24 | 48 | 161 | 0 | 5 | 1 | 3 | 140 | 102 | 242.0 | 24 | 48 | 161 | 0 | 5 | 1 | 3 | 140 | 102 | 242 | |||||||||||||||||||||||||||||||||
2233777 | 2233777 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001213 | 1810505 | Methuen: Methuen High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 283 | 2 | 159 | 2 | 18 | 1 | 28 | 268 | 225 | 493.0 | 283 | 2 | 159 | 2 | 18 | 1 | 28 | 268 | 225 | 493 | |||||||||||||||||||||||||||||||||
2232575 | 2232575 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000471 | 1490002 | Lawrence: Lawlor Early Childhood Center | Regular School | No | Elementary | KG | KG | 2018 | kindergarten | 2 | 2 | 158 | 0 | 0 | 0 | 1 | 87 | 76 | 163.0 | 2 | 2 | 158 | 0 | 0 | 0 | 1 | 87 | 76 | 163 | |||||||||||||||||||||||||||||||||
2230513 | 2230513 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000385 | 440505 | Brockton: Brockton High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 218 | 689 | 157 | 3 | 23 | 3 | 50 | 630 | 513 | 1143.0 | 218 | 689 | 157 | 3 | 23 | 3 | 50 | 630 | 513 | 1143 | |||||||||||||||||||||||||||||||||
2233336 | 2233336 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002277 | 1630605 | Lynn: Lynn Vocational Technical Institute | Career and Technical School | No | High | 06 | 12 | 2018 | grade_12 | 30 | 24 | 157 | 1 | 8 | 0 | 4 | 141 | 83 | 224.0 | 30 | 24 | 157 | 1 | 8 | 0 | 4 | 141 | 83 | 224 | |||||||||||||||||||||||||||||||||
2233778 | 2233778 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001213 | 1810505 | Methuen: Methuen High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 258 | 5 | 157 | 0 | 23 | 0 | 21 | 237 | 227 | 464.0 | 258 | 5 | 157 | 0 | 23 | 0 | 21 | 237 | 227 | 464 | |||||||||||||||||||||||||||||||||
2239840 | 2239840 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_12 | 236 | 12 | 157 | 2 | 92 | 0 | 14 | 294 | 219 | 513.0 | 236 | 12 | 157 | 2 | 92 | 0 | 14 | 294 | 219 | 513 | |||||||||||||||||||||||||||||||||
2230116 | 2230116 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Boston: Madison Park High | Career and Technical School | No | High | 09 | 12 | 2018 | grade_10 | 2 | 72 | 155 | 1 | 2 | 0 | 6 | 130 | 108 | 238.0 | 2 | 72 | 155 | 1 | 2 | 0 | 6 | 130 | 108 | 238 | |||||||||||||||||||||||||||||||||
2232630 | 2232630 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002623 | 1490027 | Lawrence: Parthum Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 6 | 0 | 155 | 0 | 1 | 0 | 0 | 83 | 79 | 162.0 | 6 | 0 | 155 | 0 | 1 | 0 | 0 | 83 | 79 | 162 |
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]);