enrollments
Data source: Big Local News · About: Big Local
493 rows where grade = "grade_7", state = "MA" and year = 2015 sorted by black_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
741163 | 741163 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001392 | 2440410 | Randolph Community Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 24 | 139 | 31 | 0 | 33 | 2 | 4 | 114 | 119 | 233 | 24 | 139 | 31 | 0 | 33 | 2 | 4 | 114 | 119 | 233 | |||||||||||||||||||||||||||||||||
743818 | 743818 | MA | Suffolk | school | 2500063 | 484 | Roxbury Preparatory Charter (District) | 250006301453 | 4840505 | Roxbury Preparatory Charter School | Regular School | Yes | 2 | 05 | 08 | 2015 | grade_7 | 5 | 135 | 90 | 0 | 2 | 0 | 3 | 108 | 127 | 235 | 5 | 135 | 90 | 0 | 2 | 0 | 3 | 108 | 127 | 235 | |||||||||||||||||||||||||||||||||
737150 | 737150 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000404 | 440410 | North Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 18 | 133 | 19 | 1 | 2 | 1 | 9 | 106 | 77 | 183 | 18 | 133 | 19 | 1 | 2 | 1 | 9 | 106 | 77 | 183 | |||||||||||||||||||||||||||||||||
737153 | 737153 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000407 | 440415 | South Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 32 | 99 | 32 | 0 | 7 | 0 | 9 | 94 | 85 | 179 | 32 | 99 | 32 | 0 | 7 | 0 | 9 | 94 | 85 | 179 | |||||||||||||||||||||||||||||||||
737162 | 737162 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002691 | 440422 | Joseph F. Plouffe Academy | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 58 | 97 | 54 | 1 | 5 | 0 | 6 | 108 | 113 | 221 | 58 | 97 | 54 | 1 | 5 | 0 | 6 | 108 | 113 | 221 | |||||||||||||||||||||||||||||||||
737156 | 737156 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000410 | 440420 | West Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 69 | 95 | 32 | 1 | 8 | 2 | 8 | 113 | 102 | 215 | 69 | 95 | 32 | 1 | 8 | 2 | 8 | 113 | 102 | 215 | |||||||||||||||||||||||||||||||||
736923 | 736923 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002725 | 350657 | TechBoston Academy | Regular School | No | 4 | 06 | 12 | 2015 | grade_7 | 3 | 94 | 27 | 1 | 7 | 0 | 2 | 75 | 59 | 134 | 3 | 94 | 27 | 1 | 7 | 0 | 2 | 75 | 59 | 134 | |||||||||||||||||||||||||||||||||
736764 | 736764 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002013 | 350383 | Lilla G. Frederick Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 3 | 81 | 89 | 0 | 6 | 1 | 4 | 92 | 92 | 184 | 3 | 81 | 89 | 0 | 6 | 1 | 4 | 92 | 92 | 184 | |||||||||||||||||||||||||||||||||
737147 | 737147 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000389 | 440405 | East Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 29 | 80 | 14 | 0 | 4 | 0 | 6 | 81 | 52 | 133 | 29 | 80 | 14 | 0 | 4 | 0 | 6 | 81 | 52 | 133 | |||||||||||||||||||||||||||||||||
736417 | 736417 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000269 | 350179 | John W McCormack | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 11 | 76 | 90 | 0 | 17 | 0 | 5 | 112 | 87 | 199 | 11 | 76 | 90 | 0 | 17 | 0 | 5 | 112 | 87 | 199 | |||||||||||||||||||||||||||||||||
743368 | 743368 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002253 | 3480420 | Worcester East Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 78 | 74 | 157 | 0 | 29 | 0 | 17 | 175 | 180 | 355 | 78 | 74 | 157 | 0 | 29 | 0 | 17 | 175 | 180 | 355 | |||||||||||||||||||||||||||||||||
737159 | 737159 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002688 | 440421 | Ashfield Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 53 | 69 | 14 | 0 | 4 | 0 | 4 | 80 | 64 | 144 | 53 | 69 | 14 | 0 | 4 | 0 | 4 | 80 | 64 | 144 | |||||||||||||||||||||||||||||||||
743371 | 743371 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002223 | 3480423 | Sullivan Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 95 | 69 | 175 | 0 | 50 | 0 | 17 | 198 | 208 | 406 | 95 | 69 | 175 | 0 | 50 | 0 | 17 | 198 | 208 | 406 | |||||||||||||||||||||||||||||||||
743467 | 743467 | MA | Suffolk | school | 2500077 | 419 | Helen Y. Davis Leadership Academy Charter Public (District) | 250007702091 | 4190305 | Helen Y. Davis Leadership Academy Charter Public School | Regular School | Yes | 2 | 06 | 08 | 2015 | grade_7 | 0 | 69 | 13 | 0 | 0 | 0 | 2 | 45 | 39 | 84 | 0 | 69 | 13 | 0 | 0 | 0 | 2 | 45 | 39 | 84 | |||||||||||||||||||||||||||||||||
743789 | 743789 | MA | Suffolk | school | 2500533 | 480 | UP Academy Charter School of Boston (District) | 250053302713 | 4800405 | UP Academy Charter School of Boston | Regular School | Yes | 2 | 06 | 08 | 2015 | grade_7 | 15 | 66 | 46 | 1 | 9 | 0 | 2 | 62 | 77 | 139 | 15 | 66 | 46 | 1 | 9 | 0 | 2 | 62 | 77 | 139 | |||||||||||||||||||||||||||||||||
737097 | 737097 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000390 | 440023 | Edgar B Davis | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 16 | 65 | 27 | 1 | 0 | 0 | 6 | 52 | 63 | 115 | 16 | 65 | 27 | 1 | 0 | 0 | 6 | 52 | 63 | 115 | |||||||||||||||||||||||||||||||||
737126 | 737126 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000405 | 440078 | Oscar F Raymond | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 11 | 60 | 9 | 0 | 4 | 0 | 2 | 50 | 36 | 86 | 11 | 60 | 9 | 0 | 4 | 0 | 2 | 50 | 36 | 86 | |||||||||||||||||||||||||||||||||
742093 | 742093 | MA | Norfolk | school | 2511250 | 285 | Stoughton | 251125001865 | 2850405 | O'Donnell Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 198 | 60 | 24 | 0 | 20 | 1 | 7 | 166 | 144 | 310 | 198 | 60 | 24 | 0 | 20 | 1 | 7 | 166 | 144 | 310 | |||||||||||||||||||||||||||||||||
743363 | 743363 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002202 | 3480405 | Burncoat Middle School | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 105 | 59 | 108 | 2 | 9 | 0 | 6 | 132 | 157 | 289 | 105 | 59 | 108 | 2 | 9 | 0 | 6 | 132 | 157 | 289 | |||||||||||||||||||||||||||||||||
736789 | 736789 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000345 | 350470 | Wm B Rogers Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 2 | 56 | 34 | 0 | 4 | 0 | 4 | 51 | 49 | 100 | 2 | 56 | 34 | 0 | 4 | 0 | 4 | 51 | 49 | 100 | |||||||||||||||||||||||||||||||||
740267 | 740267 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001334 | 2010405 | Keith Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 117 | 56 | 95 | 3 | 2 | 2 | 17 | 158 | 134 | 292 | 117 | 56 | 95 | 3 | 2 | 2 | 17 | 158 | 134 | 292 | |||||||||||||||||||||||||||||||||
736786 | 736786 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000334 | 350445 | Washington Irving Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 3 | 55 | 43 | 0 | 0 | 0 | 4 | 63 | 42 | 105 | 3 | 55 | 43 | 0 | 0 | 0 | 4 | 63 | 42 | 105 | |||||||||||||||||||||||||||||||||
736792 | 736792 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000258 | 350485 | James P Timilty Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 0 | 53 | 99 | 0 | 0 | 0 | 3 | 89 | 66 | 155 | 0 | 53 | 99 | 0 | 0 | 0 | 3 | 89 | 66 | 155 | |||||||||||||||||||||||||||||||||
741969 | 741969 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001660 | 2810340 | Van Sickle Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 43 | 53 | 187 | 1 | 6 | 1 | 7 | 151 | 147 | 298 | 43 | 53 | 187 | 1 | 6 | 1 | 7 | 151 | 147 | 298 | |||||||||||||||||||||||||||||||||
743365 | 743365 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002213 | 3480415 | Forest Grove Middle | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 241 | 52 | 143 | 0 | 24 | 0 | 28 | 267 | 221 | 488 | 241 | 52 | 143 | 0 | 24 | 0 | 28 | 267 | 221 | 488 | |||||||||||||||||||||||||||||||||
743843 | 743843 | MA | Middlesex | school | 2500046 | 487 | Prospect Hill Academy Charter (District) | 250004600819 | 4870550 | Prospect Hill Academy Charter School | Regular School | Yes | 4 | KG | 12 | 2015 | grade_7 | 9 | 50 | 23 | 1 | 10 | 0 | 1 | 45 | 49 | 94 | 9 | 50 | 23 | 1 | 10 | 0 | 1 | 45 | 49 | 94 | |||||||||||||||||||||||||||||||||
741956 | 741956 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002599 | 2810320 | John J Duggan Middle | Regular School | No | 2 | 06 | 09 | 2015 | grade_7 | 29 | 49 | 80 | 0 | 6 | 1 | 5 | 94 | 76 | 170 | 29 | 49 | 80 | 0 | 6 | 1 | 5 | 94 | 76 | 170 | |||||||||||||||||||||||||||||||||
743708 | 743708 | MA | Essex | school | 2500537 | 463 | KIPP Academy Boston Charter School (District) | 250053702716 | 4630205 | KIPP Academy Boston Charter School | Regular School | Yes | 2 | 05 | 07 | 2015 | grade_7 | 0 | 49 | 23 | 0 | 0 | 0 | 0 | 41 | 31 | 72 | 0 | 49 | 23 | 0 | 0 | 0 | 0 | 41 | 31 | 72 | |||||||||||||||||||||||||||||||||
740722 | 740722 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001468 | 2200305 | Dr. Philip O. Coakley Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 163 | 48 | 23 | 0 | 12 | 0 | 3 | 131 | 118 | 249 | 163 | 48 | 23 | 0 | 12 | 0 | 3 | 131 | 118 | 249 | |||||||||||||||||||||||||||||||||
743428 | 743428 | MA | Suffolk | school | 2500021 | 412 | Academy Of the Pacific Rim Charter Public (District) | 250002100511 | 4120530 | Academy Of the Pacific Rim Charter Public School | Regular School | Yes | 4 | 05 | 12 | 2015 | grade_7 | 12 | 48 | 14 | 0 | 1 | 0 | 2 | 38 | 39 | 77 | 12 | 48 | 14 | 0 | 1 | 0 | 2 | 38 | 39 | 77 | |||||||||||||||||||||||||||||||||
740016 | 740016 | MA | Norfolk | school | 2507980 | 189 | Milton | 250798001257 | 1890410 | Charles S Pierce Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 192 | 47 | 22 | 1 | 17 | 1 | 9 | 153 | 136 | 289 | 192 | 47 | 22 | 1 | 17 | 1 | 9 | 153 | 136 | 289 | |||||||||||||||||||||||||||||||||
736741 | 736741 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002670 | 350378 | Mildred Avenue K-8 | Regular School | No | 2 | 04 | 08 | 2015 | grade_7 | 2 | 44 | 14 | 0 | 0 | 0 | 2 | 28 | 34 | 62 | 2 | 44 | 14 | 0 | 0 | 0 | 2 | 28 | 34 | 62 | |||||||||||||||||||||||||||||||||
743496 | 743496 | MA | Suffolk | school | 2500071 | 428 | Brooke Charter School Roslindale (District) | 250007101747 | 4280305 | Brooke Charter School Roslindale | Regular School | Yes | 1 | KG | 08 | 2015 | grade_7 | 0 | 43 | 7 | 0 | 0 | 0 | 1 | 21 | 30 | 51 | 0 | 43 | 7 | 0 | 0 | 0 | 1 | 21 | 30 | 51 | |||||||||||||||||||||||||||||||||
736278 | 736278 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000222 | 350074 | Dearborn | Regular School | No | 4 | 06 | 10 | 2015 | grade_7 | 1 | 42 | 14 | 0 | 0 | 0 | 5 | 30 | 32 | 62 | 1 | 42 | 14 | 0 | 0 | 0 | 5 | 30 | 32 | 62 | |||||||||||||||||||||||||||||||||
736854 | 736854 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000204 | 350545 | Boston Latin Academy | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 91 | 42 | 58 | 0 | 69 | 0 | 11 | 116 | 155 | 271 | 91 | 42 | 58 | 0 | 69 | 0 | 11 | 116 | 155 | 271 | |||||||||||||||||||||||||||||||||
741960 | 741960 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Forest Park Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 28 | 41 | 156 | 0 | 20 | 0 | 2 | 142 | 105 | 247 | 28 | 41 | 156 | 0 | 20 | 0 | 2 | 142 | 105 | 247 | |||||||||||||||||||||||||||||||||
736451 | 736451 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000273 | 350183 | Joseph Lee | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 1 | 40 | 15 | 0 | 4 | 0 | 4 | 41 | 23 | 64 | 1 | 40 | 15 | 0 | 4 | 0 | 4 | 41 | 23 | 64 | |||||||||||||||||||||||||||||||||
741966 | 741966 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002602 | 2810330 | M Marcus Kiley Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 33 | 40 | 113 | 0 | 5 | 0 | 12 | 113 | 90 | 203 | 33 | 40 | 113 | 0 | 5 | 0 | 12 | 113 | 90 | 203 | |||||||||||||||||||||||||||||||||
743740 | 743740 | MA | Suffolk | school | 2500066 | 469 | MATCH Charter Public School (District) | 250006601586 | 4690505 | MATCH Charter Public School | Regular School | Yes | 4 | PK | 12 | 2015 | grade_7 | 3 | 40 | 40 | 0 | 0 | 0 | 1 | 49 | 35 | 84 | 3 | 40 | 40 | 0 | 0 | 0 | 1 | 49 | 35 | 84 | |||||||||||||||||||||||||||||||||
736888 | 736888 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000205 | 350575 | O'Bryant School Math/Science | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 15 | 39 | 61 | 1 | 28 | 0 | 5 | 66 | 83 | 149 | 15 | 39 | 61 | 1 | 28 | 0 | 5 | 66 | 83 | 149 | |||||||||||||||||||||||||||||||||
739509 | 739509 | MA | Essex | school | 2507110 | 163 | Lynn | 250711000301 | 1630305 | Thurgood Marshall Mid | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 37 | 38 | 208 | 0 | 27 | 0 | 17 | 181 | 146 | 327 | 37 | 38 | 208 | 0 | 27 | 0 | 17 | 181 | 146 | 327 | |||||||||||||||||||||||||||||||||
739512 | 739512 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001063 | 1630405 | Breed Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 78 | 38 | 233 | 0 | 49 | 0 | 9 | 214 | 193 | 407 | 78 | 38 | 233 | 0 | 49 | 0 | 9 | 214 | 193 | 407 | |||||||||||||||||||||||||||||||||
743452 | 743452 | MA | Suffolk | school | 2500080 | 416 | Boston Preparatory Charter Public (District) | 250008001843 | 4160305 | Boston Preparatory Charter Public School | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_7 | 1 | 38 | 19 | 0 | 0 | 0 | 0 | 26 | 32 | 58 | 1 | 38 | 19 | 0 | 0 | 0 | 0 | 26 | 32 | 58 | |||||||||||||||||||||||||||||||||
736777 | 736777 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000952 | 350426 | Dr. William Henderson Upper | Regular School | No | 4 | 05 | 11 | 2015 | grade_7 | 7 | 37 | 8 | 0 | 3 | 0 | 3 | 27 | 31 | 58 | 7 | 37 | 8 | 0 | 3 | 0 | 3 | 27 | 31 | 58 | |||||||||||||||||||||||||||||||||
737393 | 737393 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327002768 | 490310 | Putnam Avenue Upper School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 20 | 35 | 11 | 1 | 7 | 0 | 5 | 35 | 44 | 79 | 20 | 35 | 11 | 1 | 7 | 0 | 5 | 35 | 44 | 79 | |||||||||||||||||||||||||||||||||
743577 | 743577 | MA | Hampden | school | 2500028 | 441 | Sabis International Charter (District) | 250002800537 | 4410505 | Sabis International Charter School | Regular School | Yes | 4 | KG | 12 | 2015 | grade_7 | 31 | 35 | 56 | 0 | 6 | 0 | 8 | 67 | 69 | 136 | 31 | 35 | 56 | 0 | 6 | 0 | 8 | 67 | 69 | 136 | |||||||||||||||||||||||||||||||||
741963 | 741963 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002601 | 2810328 | John F Kennedy Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 28 | 34 | 133 | 0 | 1 | 0 | 5 | 101 | 100 | 201 | 28 | 34 | 133 | 0 | 1 | 0 | 5 | 101 | 100 | 201 | |||||||||||||||||||||||||||||||||
743500 | 743500 | MA | Essex | school | 2500082 | 429 | KIPP Academy Lynn Charter (District) | 250008201845 | 4290010 | KIPP Academy Lynn Charter School | Regular School | Yes | 4 | 05 | 12 | 2015 | grade_7 | 13 | 34 | 69 | 0 | 2 | 0 | 2 | 61 | 59 | 120 | 13 | 34 | 69 | 0 | 2 | 0 | 2 | 61 | 59 | 120 | |||||||||||||||||||||||||||||||||
736556 | 736556 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002006 | 350257 | Orchard Gardens | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 1 | 33 | 43 | 0 | 1 | 1 | 2 | 27 | 54 | 81 | 1 | 33 | 43 | 0 | 1 | 1 | 2 | 27 | 54 | 81 | |||||||||||||||||||||||||||||||||
736751 | 736751 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000693 | 350380 | Young Achievers | Alternative Education School | No | 1 | PK | 08 | 2015 | grade_7 | 0 | 33 | 15 | 0 | 0 | 0 | 0 | 33 | 15 | 48 | 0 | 33 | 15 | 0 | 0 | 0 | 0 | 33 | 15 | 48 | |||||||||||||||||||||||||||||||||
737390 | 737390 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327002759 | 490305 | Cambridge Street Upper School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 35 | 32 | 13 | 2 | 4 | 2 | 4 | 53 | 39 | 92 | 35 | 32 | 13 | 2 | 4 | 2 | 4 | 53 | 39 | 92 | |||||||||||||||||||||||||||||||||
741949 | 741949 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002137 | 2810205 | The Springfield Renaissance School an Expeditionary Learning School | Regular School | No | 4 | 06 | 12 | 2015 | grade_7 | 28 | 32 | 41 | 0 | 4 | 0 | 3 | 58 | 50 | 108 | 28 | 32 | 41 | 0 | 4 | 0 | 3 | 58 | 50 | 108 | |||||||||||||||||||||||||||||||||
736562 | 736562 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000339 | 350258 | William H Ohrenberger | Regular School | No | 1 | 03 | 08 | 2015 | grade_7 | 7 | 31 | 48 | 0 | 2 | 0 | 2 | 56 | 34 | 90 | 7 | 31 | 48 | 0 | 2 | 0 | 2 | 56 | 34 | 90 | |||||||||||||||||||||||||||||||||
739604 | 739604 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001363 | 1650057 | Salemwood | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 31 | 31 | 30 | 0 | 24 | 0 | 3 | 65 | 54 | 119 | 31 | 31 | 30 | 0 | 24 | 0 | 3 | 65 | 54 | 119 | |||||||||||||||||||||||||||||||||
740273 | 740273 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001339 | 2010415 | Roosevelt Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 123 | 31 | 93 | 1 | 2 | 2 | 10 | 136 | 126 | 262 | 123 | 31 | 93 | 1 | 2 | 2 | 10 | 136 | 126 | 262 | |||||||||||||||||||||||||||||||||
743530 | 743530 | MA | Middlesex | school | 2500086 | 436 | Community Charter School of Cambridge (District) | 250008601996 | 4360305 | Community Charter School of Cambridge | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_7 | 1 | 31 | 11 | 0 | 0 | 1 | 5 | 20 | 29 | 49 | 1 | 31 | 11 | 0 | 0 | 1 | 5 | 20 | 29 | 49 | |||||||||||||||||||||||||||||||||
743622 | 743622 | MA | Norfolk | school | 2500052 | 446 | Foxborough Regional Charter (District) | 250005201250 | 4460550 | Foxborough Regional Charter School | Regular School | Yes | 4 | KG | 12 | 2015 | grade_7 | 58 | 31 | 8 | 0 | 10 | 0 | 5 | 50 | 62 | 112 | 58 | 31 | 8 | 0 | 10 | 0 | 5 | 50 | 62 | 112 | |||||||||||||||||||||||||||||||||
736529 | 736529 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000315 | 350240 | Richard J Murphy | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 15 | 30 | 11 | 1 | 20 | 0 | 2 | 37 | 42 | 79 | 15 | 30 | 11 | 1 | 20 | 0 | 2 | 37 | 42 | 79 | |||||||||||||||||||||||||||||||||
740946 | 740946 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001532 | 2360310 | Theodore Herberg Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 160 | 30 | 16 | 0 | 6 | 0 | 5 | 103 | 114 | 217 | 160 | 30 | 16 | 0 | 6 | 0 | 5 | 103 | 114 | 217 | |||||||||||||||||||||||||||||||||
745147 | 745147 | MA | Hampden | school | 2500550 | 3502 | Baystate Academy Charter Public School (District) | 250055002784 | 35020405 | Baystate Academy Charter Public School | Regular School | Yes | 2 | 06 | 08 | 2015 | grade_7 | 7 | 30 | 41 | 0 | 1 | 0 | 0 | 38 | 41 | 79 | 7 | 30 | 41 | 0 | 1 | 0 | 0 | 38 | 41 | 79 | |||||||||||||||||||||||||||||||||
735971 | 735971 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable Intermediate School | Regular School | No | 2 | 06 | 07 | 2015 | grade_7 | 292 | 29 | 38 | 4 | 13 | 1 | 11 | 185 | 203 | 388 | 292 | 29 | 38 | 4 | 13 | 1 | 11 | 185 | 203 | 388 | |||||||||||||||||||||||||||||||||
736874 | 736874 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000203 | 350560 | Boston Latin | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 202 | 29 | 55 | 0 | 103 | 0 | 17 | 183 | 223 | 406 | 202 | 29 | 55 | 0 | 103 | 0 | 17 | 183 | 223 | 406 | |||||||||||||||||||||||||||||||||
739803 | 739803 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756002063 | 1760320 | John J. McGlynn Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 80 | 29 | 13 | 0 | 18 | 0 | 3 | 81 | 62 | 143 | 80 | 29 | 13 | 0 | 18 | 0 | 3 | 81 | 62 | 143 | |||||||||||||||||||||||||||||||||
740270 | 740270 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001337 | 2010410 | Normandin Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 212 | 29 | 97 | 1 | 1 | 2 | 16 | 183 | 175 | 358 | 212 | 29 | 97 | 1 | 1 | 2 | 16 | 183 | 175 | 358 | |||||||||||||||||||||||||||||||||
743639 | 743639 | MA | Suffolk | school | 2500053 | 449 | Boston Collegiate Charter (District) | 250005301256 | 4490305 | Boston Collegiate Charter School | Regular School | Yes | 4 | 05 | 12 | 2015 | grade_7 | 39 | 29 | 21 | 2 | 2 | 0 | 2 | 48 | 47 | 95 | 39 | 29 | 21 | 2 | 2 | 0 | 2 | 48 | 47 | 95 | |||||||||||||||||||||||||||||||||
743768 | 743768 | MA | Suffolk | school | 2500521 | 475 | Dorchester Collegiate Academy Charter (District) | 250052102685 | 4750505 | Dorchester Collegiate Academy Charter | Regular School | Yes | 2 | 04 | 08 | 2015 | grade_7 | 0 | 29 | 7 | 0 | 0 | 2 | 0 | 19 | 19 | 38 | 0 | 29 | 7 | 0 | 0 | 2 | 0 | 19 | 19 | 38 | |||||||||||||||||||||||||||||||||
737399 | 737399 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327002756 | 490320 | Vassal Lane Upper School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 40 | 28 | 11 | 1 | 14 | 0 | 6 | 49 | 51 | 100 | 40 | 28 | 11 | 1 | 14 | 0 | 6 | 49 | 51 | 100 | |||||||||||||||||||||||||||||||||
745164 | 745164 | MA | Middlesex | school | 2500546 | 3506 | Pioneer Charter School of Science II (PCSS-II) (District) | 250054602780 | 35060505 | Pioneer Charter School of Science II (PCSS-II) | Regular School | Yes | 4 | 07 | 10 | 2015 | grade_7 | 22 | 28 | 11 | 0 | 7 | 0 | 2 | 34 | 36 | 70 | 22 | 28 | 11 | 0 | 7 | 0 | 2 | 34 | 36 | 70 | |||||||||||||||||||||||||||||||||
736215 | 736215 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000251 | 350013 | Jackson Mann | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 4 | 27 | 24 | 0 | 2 | 0 | 3 | 29 | 31 | 60 | 4 | 27 | 24 | 0 | 2 | 0 | 3 | 29 | 31 | 60 | |||||||||||||||||||||||||||||||||
743600 | 743600 | MA | Suffolk | school | 2500029 | 444 | Neighborhood House Charter (District) | 250002900545 | 4440205 | Neighborhood House Charter School | Regular School | Yes | 1 | PK | 08 | 2015 | grade_7 | 3 | 27 | 6 | 0 | 0 | 0 | 2 | 16 | 22 | 38 | 3 | 27 | 6 | 0 | 0 | 0 | 2 | 16 | 22 | 38 | |||||||||||||||||||||||||||||||||
736231 | 736231 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002622 | 350020 | Curley K-8 School | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 6 | 25 | 54 | 0 | 0 | 0 | 0 | 39 | 46 | 85 | 6 | 25 | 54 | 0 | 0 | 0 | 0 | 39 | 46 | 85 | |||||||||||||||||||||||||||||||||
736715 | 736715 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002689 | 350375 | Edison K-8 | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 5 | 24 | 35 | 0 | 6 | 1 | 1 | 41 | 31 | 72 | 5 | 24 | 35 | 0 | 6 | 1 | 1 | 41 | 31 | 72 | |||||||||||||||||||||||||||||||||
737396 | 737396 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327002746 | 490315 | Rindge Avenue Upper School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 41 | 24 | 12 | 0 | 12 | 0 | 6 | 48 | 47 | 95 | 41 | 24 | 12 | 0 | 12 | 0 | 6 | 48 | 47 | 95 | |||||||||||||||||||||||||||||||||
737426 | 737426 | MA | Norfolk | school | 2503300 | 50 | Canton | 250330000456 | 500305 | Wm H Galvin Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 191 | 24 | 9 | 0 | 24 | 0 | 10 | 127 | 131 | 258 | 191 | 24 | 9 | 0 | 24 | 0 | 10 | 127 | 131 | 258 | |||||||||||||||||||||||||||||||||
742236 | 742236 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001911 | 2930042 | Joseph H Martin | Regular School | No | 2 | 05 | 07 | 2015 | grade_7 | 180 | 24 | 14 | 0 | 2 | 0 | 7 | 122 | 105 | 227 | 180 | 24 | 14 | 0 | 2 | 0 | 7 | 122 | 105 | 227 | |||||||||||||||||||||||||||||||||
742244 | 742244 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152002416 | 2930305 | John F Parker Middle | Regular School | No | 2 | 05 | 07 | 2015 | grade_7 | 83 | 24 | 25 | 0 | 0 | 2 | 4 | 67 | 71 | 138 | 83 | 24 | 25 | 0 | 0 | 2 | 4 | 67 | 71 | 138 | |||||||||||||||||||||||||||||||||
742247 | 742247 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001662 | 2930315 | Benjamin Friedman Middle | Regular School | No | 2 | 05 | 07 | 2015 | grade_7 | 200 | 24 | 32 | 0 | 4 | 0 | 8 | 136 | 132 | 268 | 200 | 24 | 32 | 0 | 4 | 0 | 8 | 136 | 132 | 268 | |||||||||||||||||||||||||||||||||
738005 | 738005 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477001521 | 930058 | Parlin School | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 22 | 23 | 45 | 1 | 2 | 0 | 2 | 40 | 55 | 95 | 22 | 23 | 45 | 1 | 2 | 0 | 2 | 40 | 55 | 95 | |||||||||||||||||||||||||||||||||
741975 | 741975 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002642 | 2810350 | STEM Middle Academy | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 20 | 23 | 46 | 0 | 2 | 0 | 4 | 52 | 43 | 95 | 20 | 23 | 46 | 0 | 2 | 0 | 4 | 52 | 43 | 95 | |||||||||||||||||||||||||||||||||
743609 | 743609 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public School | Regular School | Yes | 4 | KG | 12 | 2015 | grade_7 | 38 | 23 | 47 | 0 | 5 | 0 | 4 | 59 | 58 | 117 | 38 | 23 | 47 | 0 | 5 | 0 | 4 | 59 | 58 | 117 | |||||||||||||||||||||||||||||||||
743834 | 743834 | MA | Worcester | school | 2500045 | 486 | Seven Hills Charter Public (District) | 250004500817 | 4860105 | Seven Hills Charter School | Regular School | Yes | 1 | KG | 08 | 2015 | grade_7 | 7 | 23 | 26 | 0 | 1 | 0 | 1 | 31 | 27 | 58 | 7 | 23 | 26 | 0 | 1 | 0 | 1 | 31 | 27 | 58 | |||||||||||||||||||||||||||||||||
737996 | 737996 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477001520 | 930038 | Lafayette School | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 50 | 22 | 30 | 0 | 7 | 0 | 1 | 51 | 59 | 110 | 50 | 22 | 30 | 0 | 7 | 0 | 1 | 51 | 59 | 110 | |||||||||||||||||||||||||||||||||
736205 | 736205 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston Teachers Union School | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 0 | 21 | 23 | 0 | 0 | 1 | 2 | 20 | 27 | 47 | 0 | 21 | 23 | 0 | 0 | 1 | 2 | 20 | 27 | 47 | |||||||||||||||||||||||||||||||||
738677 | 738677 | MA | Norfolk | school | 2506150 | 133 | Holbrook | 250615000878 | 1330505 | Holbrook Jr Sr High | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 66 | 21 | 5 | 1 | 3 | 0 | 8 | 52 | 52 | 104 | 66 | 21 | 5 | 1 | 3 | 0 | 8 | 52 | 52 | 104 | |||||||||||||||||||||||||||||||||
739567 | 739567 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001344 | 1650003 | Beebe | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 30 | 21 | 12 | 1 | 22 | 0 | 1 | 42 | 45 | 87 | 30 | 21 | 12 | 1 | 22 | 0 | 1 | 42 | 45 | 87 | |||||||||||||||||||||||||||||||||
742445 | 742445 | MA | Middlesex | school | 2512000 | 308 | Waltham | 251200001971 | 3080404 | John F Kennedy Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 86 | 21 | 49 | 0 | 9 | 0 | 4 | 93 | 76 | 169 | 86 | 21 | 49 | 0 | 9 | 0 | 4 | 93 | 76 | 169 | |||||||||||||||||||||||||||||||||
742604 | 742604 | MA | Norfolk | school | 2512270 | 317 | Wellesley | 251227002029 | 3170305 | Wellesley Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 296 | 21 | 20 | 0 | 32 | 0 | 14 | 188 | 195 | 383 | 296 | 21 | 20 | 0 | 32 | 0 | 14 | 188 | 195 | 383 | |||||||||||||||||||||||||||||||||
743590 | 743590 | MA | Suffolk | school | 2500528 | 443 | Brooke Charter School Mattapan (District) | 250052802711 | 4430205 | Brooke Charter School Mattapan | Regular School | Yes | 1 | KG | 08 | 2015 | grade_7 | 0 | 21 | 11 | 0 | 2 | 0 | 0 | 16 | 18 | 34 | 0 | 21 | 11 | 0 | 2 | 0 | 0 | 16 | 18 | 34 | |||||||||||||||||||||||||||||||||
743693 | 743693 | MA | Middlesex | school | 2500065 | 456 | Lowell Community Charter Public (District) | 250006501585 | 4560050 | Lowell Community Charter Public School | Regular School | Yes | 1 | PK | 07 | 2015 | grade_7 | 4 | 21 | 25 | 0 | 21 | 0 | 1 | 28 | 44 | 72 | 4 | 21 | 25 | 0 | 21 | 0 | 1 | 28 | 44 | 72 | |||||||||||||||||||||||||||||||||
743886 | 743886 | MA | Middlesex | school | 2500518 | 494 | Pioneer Charter School of Science (District) | 250051802632 | 4940205 | Pioneer Charter School of Science | Regular School | Yes | 3 | 07 | 12 | 2015 | grade_7 | 18 | 21 | 16 | 3 | 10 | 0 | 1 | 40 | 29 | 69 | 18 | 21 | 16 | 3 | 10 | 0 | 1 | 40 | 29 | 69 | |||||||||||||||||||||||||||||||||
736735 | 736735 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 0 | 20 | 7 | 1 | 0 | 0 | 0 | 18 | 10 | 28 | 0 | 20 | 7 | 1 | 0 | 0 | 0 | 18 | 10 | 28 | |||||||||||||||||||||||||||||||||
736783 | 736783 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000216 | 350430 | Clarence R Edwards Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 7 | 20 | 83 | 0 | 17 | 0 | 0 | 66 | 61 | 127 | 7 | 20 | 83 | 0 | 17 | 0 | 0 | 66 | 61 | 127 | |||||||||||||||||||||||||||||||||
737760 | 737760 | MA | Norfolk | school | 2504050 | 73 | Dedham | 250405000551 | 730305 | Dedham Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 173 | 20 | 32 | 1 | 4 | 0 | 3 | 109 | 124 | 233 | 173 | 20 | 32 | 1 | 4 | 0 | 3 | 109 | 124 | 233 | |||||||||||||||||||||||||||||||||
739100 | 739100 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678002045 | 1530320 | Sky View Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 160 | 20 | 81 | 1 | 8 | 4 | 10 | 144 | 140 | 284 | 160 | 20 | 81 | 1 | 8 | 4 | 10 | 144 | 140 | 284 | |||||||||||||||||||||||||||||||||
740404 | 740404 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000314 | 2070315 | F A Day Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 220 | 20 | 32 | 0 | 49 | 0 | 22 | 175 | 168 | 343 | 220 | 20 | 32 | 0 | 49 | 0 | 22 | 175 | 168 | 343 | |||||||||||||||||||||||||||||||||
740407 | 740407 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001042 | 2070320 | Oak Hill Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 137 | 20 | 11 | 0 | 27 | 0 | 13 | 120 | 88 | 208 | 137 | 20 | 11 | 0 | 27 | 0 | 13 | 120 | 88 | 208 | |||||||||||||||||||||||||||||||||
740943 | 740943 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001525 | 2360305 | John T Reid Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 117 | 20 | 17 | 0 | 2 | 0 | 11 | 93 | 74 | 167 | 117 | 20 | 17 | 0 | 2 | 0 | 11 | 93 | 74 | 167 | |||||||||||||||||||||||||||||||||
736338 | 736338 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000239 | 350116 | Franklin D Roosevelt | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 5 | 19 | 19 | 0 | 1 | 0 | 2 | 21 | 25 | 46 | 5 | 19 | 19 | 0 | 1 | 0 | 2 | 21 | 25 | 46 | |||||||||||||||||||||||||||||||||
737518 | 737518 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001776 | 570055 | Joseph A. Browne School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 10 | 19 | 122 | 1 | 2 | 0 | 0 | 83 | 71 | 154 | 10 | 19 | 122 | 1 | 2 | 0 | 0 | 83 | 71 | 154 | |||||||||||||||||||||||||||||||||
739800 | 739800 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756001638 | 1760315 | Madeleine Dugger Andrews | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 101 | 19 | 10 | 0 | 9 | 0 | 6 | 68 | 77 | 145 | 101 | 19 | 10 | 0 | 9 | 0 | 6 | 68 | 77 | 145 |
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]);