Data source: Big Local News · About: Big Local

2,748 rows where grade = "grade_12" and state = "MA" sorted by black descending

View and edit SQL

year

grade

  • grade_12 · 2,748
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
1368413 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_12 215 99 177 0   232     1   17   367 374 *                     741.0 215 99 177 0   232     1   17   367 374                 741
1679786 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter (District) - Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2021   grade_12 10 99 89 1   2     0   4   99 106 *                     205.0 10 99 89 1   2     0   4   99 106                 205
2040968 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_12 1 99 18 0   1     0   1   64 56                       120.0 1 99 18 0   1     0   1   64 56                 120
933791 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2016   grade_12 5 97 20 2   7     0   4   82 53                       135 5 97 20 2   7     0   4   82 53                 135
937997 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2016   grade_12 24 96 22 1   32     0   3   107 71                       178 24 96 22 1   32     0   3   107 71                 178
938810 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_12 85 96 225 0   27     0   3   221 215                       436 85 96 225 0   27     0   3   221 215                 436
1123419 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_12 6 96 23 0   3     0   2   71 59                       130 6 96 23 0   3     0   2   71 59                 130
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
739609 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_12 148 95 97 2   114     2   16   246 228                       474 148 95 97 2   114     2   16   246 228                 474
1678555 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_12 276 94 60 0   5     0   15   222 228 *                     450.0 276 94 60 0   5     0   15   222 228                 450
2233417 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden: Malden High   Regular School No High 09 12 2018   grade_12 120 94 113 1   113     0   13   219 235                       454.0 120 94 113 1   113     0   13   219 235                 454
736806 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_12 9 93 74 1   42     0   1   118 102                       220 9 93 74 1   42     0   1   118 102                 220
743479 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_12 16 93 48 1   3     1   4   73 93                       166 16 93 48 1   3     1   4   73 93                 166
941933 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_12 166 92 39 0   0     0   5   164 138                       302 166 92 39 0   0     0   5   164 138                 302
1370224 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2020   grade_12 15 92 15 0   30     1   4   87 70 *                     157.0 15 92 15 0   30     1   4   87 70                 157
2230088 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston: Charlestown High   Regular School No High 09 12 2018   grade_12 13 92 93 0   42     0   2   132 110                       242.0 13 92 93 0   42     0   2   132 110                 242
736893 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_12 31 91 57 0   57     1   1   111 127                       238 31 91 57 0   57     1   1   111 127                 238
1123380 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_12 26 91 80 1   62     0   5   110 155                       265 26 91 80 1   62     0   5   110 155                 265
2230118 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston: Madison Park High   Career and Technical School No High 09 12 2018   grade_12 8 91 84 1   3     1   3   107 84                       191.0 8 91 84 1   3     1   3   107 84                 191
735869 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_12 142 9 8 0   4     0   5   80 88                       168 142 9 8 0   4     0   5   80 88                 168
736118 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2015   grade_12 281 9 26 0   7     0   2   135 190                       325 281 9 26 0   7     0   2   135 190                 325
736912 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_12 9 9 9 0   3     0   2   20 12                       32 9 9 9 0   3     0   2   20 12                 32
737301 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2015   grade_12 187 9 9 0   39     1   9   127 127                       254 187 9 9 0   39     1   9   127 127                 254
737734 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_12 229 9 4 1   9     1   1   124 130                       254 229 9 4 1   9     1   1   124 130                 254
737825 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2015   grade_12 204 9 9 0   9     0   2   117 116                       233 204 9 9 0   9     0   2   117 116                 233
739111 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_12 81 9 24 0   5     0   3   73 49                       122 81 9 24 0   5     0   3   73 49                 122
739623 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_12 288 9 5 3   18     1   3   152 175                       327 288 9 5 3   18     1   3   152 175                 327
739680 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2015   grade_12 174 9 73 0   13     0   1   142 128                       270 174 9 73 0   13     0   1   142 128                 270
740846 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2015   grade_12 360 9 63 1   10     0   10   235 218                       453 360 9 63 1   10     0   10   235 218                 453
741385 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2015   grade_12 150 9 84 2   11     0   13   136 133                       269 150 9 84 2   11     0   13   136 133                 269
742544 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No 3 09 12 2015   grade_12 158 9 12 0   22     0   5   111 95                       206 158 9 12 0   22     0   5   111 95                 206
745076 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Vocational Education School No 3 09 12 2015   grade_12 54 9 82 0   4     0   3   85 67                       152 54 9 82 0   4     0   3   85 67                 152
934483 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2016   grade_12 60 9 25 0   3     0   0   48 49                       97 60 9 25 0   3     0   0   48 49                 97
935657 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2016   grade_12 271 9 6 1   19     0   1   153 154                       307 271 9 6 1   19     0   1   153 154                 307
936468 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2016   grade_12 280 9 7 2   16     2   2   158 160                       318 280 9 7 2   16     2   2   158 160                 318
936944 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2016   grade_12 307 9 14 0   28     0   20   187 191                       378 307 9 14 0   28     0   20   187 191                 378
938255 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No 3 09 12 2016   grade_12 147 9 16 1   5     0   1   68 111                       179 147 9 16 1   5     0   1   68 111                 179
938991 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2016   grade_12 144 9 6 0   1     0   1   71 90                       161 144 9 6 0   1     0   1   71 90                 161
939168 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No 3 09 12 2016   grade_12 222 9 7 0   9     1   4   109 143                       252 222 9 7 0   9     1   4   109 143                 252
939353 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No 3 09 12 2016   grade_12 165 9 11 0   32     0   9   104 122                       226 165 9 11 0   32     0   9   104 122                 226
940332 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2016   grade_12 102 9 12 0   54     0   5   97 85                       182 102 9 12 0   54     0   5   97 85                 182
941239 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No 3 09 12 2016   grade_12 241 9 16 0   9     0   7   137 145                       282 241 9 16 0   9     0   7   137 145                 282
941867 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2016   grade_12 125 9 14 1   0     0   5   89 65                       154 125 9 14 1   0     0   5   89 65                 154
941879 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_12 287 9 17 3   9     1   13   182 157                       339 287 9 17 3   9     1   13   182 157                 339
1124205 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2017   grade_12 248 9 77 1   10     3   7   207 148                       355 248 9 77 1   10     3   7   207 148                 355
1124472 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2017   grade_12 148 9 13 0   11     2   4   90 97                       187 148 9 13 0   11     2   4   90 97                 187
1126001 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2017   grade_12 72 9 39 0   2     0   3   77 48                       125 72 9 39 0   2     0   3   77 48                 125
1126848 MA Middlesex   school 2507560 176   Medford 250756001174 1760605 Medford Vocational Technical High   Career and Technical School No High 09 12 2017   grade_12 37 9 2 0   1     0   1   35 15                       50 37 9 2 0   1     0   1   35 15                 50
1128390 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_12 104 9 5 0   166     0   1   144 140                       285 104 9 5 0   166     0   1   144 140                 285
1128896 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2017   grade_12 283 9 26 1   79     0   12   202 206                       410 283 9 26 1   79     0   12   202 206                 410
1131682 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes Other 06 12 2017   grade_12 13 9 15 0   1     0   1   15 24                       39 13 9 15 0   1     0   1   15 24                 39
1132995 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2017   grade_12 117 9 13 5   1     0   4   90 59                       149 117 9 13 5   1     0   4   90 59                 149
1368049 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_12 21 9 717 0   11     0   2   401 349 10                     760.0 21 9 717 0   11     0   2   401 349 10               760
1368156 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2020   grade_12 78 9 48 0   1     3   5   98 46 *                     144.0 78 9 48 0   1     3   5   98 46                 144
1368699 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2020   grade_12 267 9 7 0   17     0   8   165 143 *                     308.0 267 9 7 0   17     0   8   165 143                 308
1368981 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2020   grade_12 238 9 165 0   18     1   26   227 230 *                     457.0 238 9 165 0   18     1   26   227 230                 457
1370266 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2020   grade_12 266 9 6 1   19     0   3   136 168 *                     304.0 266 9 6 1   19     0   3   136 168                 304
1370484 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2020   grade_12 113 9 28 1   9     0   1   88 73 *                     161.0 113 9 28 1   9     0   1   88 73                 161
1371597 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2020   grade_12 142 9 14 0   29     0   12   106 100 *                     206.0 142 9 14 0   29     0   12   106 100                 206
1372383 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_12 4 9 81 0   9     0   1   49 55 *                     104.0 4 9 81 0   9     0   1   49 55                 104
1373315 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2020   grade_12 219 9 19 2   4     0   5   125 132 *                     258.0 219 9 19 2   4     0   5   125 132                 258
1373570 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2020   grade_12 103 9 3 2   3     0   4   65 59 *                     124.0 103 9 3 2   3     0   4   65 59                 124
1373838 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2020   grade_12 266 9 3 1   5     1   3   149 139 *                     288.0 266 9 3 1   5     1   3   149 139                 288
1374070 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2020   grade_12 255 9 12 1   7     2   4   143 147 *                     290.0 255 9 12 1   7     2   4   143 147                 290
1374172 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 145 9 3 1   4     0   8   108 62 *                     170.0 145 9 3 1   4     0   8   108 62                 170
1672151 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_12 304 9 25 0   97     0   11   196 249 *                     446.0 304 9 25 0   97     0   11   196 249                 446
1673167 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston - East Boston High   Regular School No High 09 12 2021   grade_12 27 9 198 0   7     0   6   150 97 *                     247.0 27 9 198 0   7     0   6   150 97                 247
1674675 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   grade_12 381 9 15 2   33     0   9   232 217 *                     449.0 381 9 15 2   33     0   9   232 217                 449
1675402 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Leominster - Center For Technical Education Innovation   Career and Technical School No High 09 12 2021   grade_12 91 9 56 0   2     1   4   103 60 *                     163.0 91 9 56 0   2     1   4   103 60                 163
1677514 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading - Reading Memorial High   Regular School No High 09 12 2021   grade_12 293 9 8 1   14     0   5   168 161 *                     330.0 293 9 8 1   14     0   5   168 161                 330
1677736 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus - Saugus High   Regular School No High 09 12 2021   grade_12 119 9 29 2   6     0   2   93 73 *                     167.0 119 9 29 2   6     0   2   93 73                 167
1678577 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury - Tewksbury Memorial High   Regular School No High 09 12 2021   grade_12 177 9 13 0   8     0   2   91 117 *                     209.0 177 9 13 0   8     0   2   91 117                 209
1678707 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole - Walpole High   Regular School No High 09 12 2021   grade_12 224 9 16 2   15     0   4   139 131 *                     270.0 224 9 16 2   15     0   4   139 131                 270
1678941 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough - Westborough High   Regular School No High 09 12 2021   grade_12 203 9 22 0   74     1   9   166 151 *                     318.0 203 9 22 0   74     1   9   166 151                 318
1679723 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_12 12 9 136 1   0     0   0   79 79 *                     158.0 12 9 136 1   0     0   0   79 79                 158
1681368 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_12 88 9 71 3   1     0   3   106 68 *                     175.0 88 9 71 3   1     0   3   106 68                 175
2041002 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2019   grade_12 2 9 22 0   0     0   2   20 15                       35.0 2 9 22 0   0     0   2   20 15                 35
2041859 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2019   grade_12 208 9 15 0   8     0   2   122 120                       242.0 208 9 15 0   8     0   2   122 120                 242
2043820 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2019   grade_12 129 9 149 0   6     0   6   164 135                       299.0 129 9 149 0   6     0   6   164 135                 299
2045339 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2019   grade_12 291 9 6 0   15     0   1   159 163                       322.0 291 9 6 0   15     0   1   159 163                 322
2045438 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No High 09 12 2019   grade_12 91 9 15 0   0     0   2   52 65                       117.0 91 9 15 0   0     0   2   52 65                 117
2046305 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No High 09 12 2019   grade_12 148 9 7 0   7     1   4   90 86                       176.0 148 9 7 0   7     1   4   90 86                 176
2046944 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No High 09 12 2019   grade_12 198 9 48 0   23     0   4   142 140                       282.0 198 9 48 0   23     0   4   142 140                 282
2046983 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2019   grade_12 233 9 5 0   15     0   2   133 131                       264.0 233 9 5 0   15     0   2   133 131                 264
2047456 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_12 7 9 63 0   8     0   0   40 47                       87.0 7 9 63 0   8     0   0   40 47                 87
2047901 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2019   grade_12 39 9 7 0   1     0   8   14 50                       64.0 39 9 7 0   1     0   8   14 50                 64
2048100 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_12 294 9 21 0   159     0   17   271 229                       500.0 294 9 21 0   159     0   17   271 229                 500
2048385 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2019   grade_12 208 9 8 1   5     0   9   107 133                       240.0 208 9 8 1   5     0   9   107 133                 240
2049144 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   grade_12 268 9 8 2   4     0   12   148 155                       303.0 268 9 8 2   4     0   12   148 155                 303
2049308 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2019   grade_12 4 9 7 0   0     0   1   12 9                       21.0 4 9 7 0   0     0   1   12 9                 21
2228928 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_12 311 9 19 0   64     0   8   197 213                       411.0 311 9 19 0   64     0   8   197 213                 411
2229358 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_12 241 9 10 0   16     2   3   130 151                       281.0 241 9 10 0   16     2   3   130 151                 281
2230220 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Boston: Lyon Upper 9-12   Regular School No High 09 12 2018   grade_12 8 9 7 0   0     0   3   18 9                       27.0 8 9 7 0   0     0   3   18 9                 27
2231015 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee: Chicopee High   Regular School No High 09 12 2018   grade_12 139 9 84 0   8     1   3   116 128                       244.0 139 9 84 0   8     1   3   116 128                 244
2232959 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow: Longmeadow High   Regular School No High 09 12 2018   grade_12 184 9 8 0   18     0   2   112 109                       221.0 184 9 8 0   18     0   2   112 109                 221
2233436 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield: Mansfield High   Regular School No High 09 12 2018   grade_12 262 9 11 2   10     0   8   141 161                       302.0 262 9 11 2   10     0   8   141 161                 302
2233504 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough: Marlborough High   Regular School No High 09 12 2018   grade_12 160 9 112 0   15     0   2   146 152                       298.0 160 9 112 0   15     0   2   146 152                 298
2233835 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_12 184 9 71 4   11     1   2   129 153                       282.0 184 9 71 4   11     1   2   129 153                 282
2234545 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleborough: North Attleboro High   Regular School No High 09 12 2018   grade_12 264 9 20 2   14     0   5   138 176                       314.0 264 9 20 2   14     0   5   138 176                 314
2235717 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury: Shrewsbury Sr High   Regular School No High 09 12 2018   grade_12 310 9 33 0   74     1   11   193 245                       438.0 310 9 33 0   74     1   11   193 245                 438

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);