Data source: Big Local News · About: Big Local

2,773 rows where grade = "grade_11" and state = "MA" sorted by black descending

View and edit SQL

year

grade

  • grade_11 · 2,773
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
738009 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2015   grade_11 163 99 149 2   30     0   6   236 213                       449 163 99 149 2   30     0   6   236 213                 449
1675656 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_11 206 99 179 0   227     0   25   362 374 *                     736.0 206 99 179 0   227     0   25   362 374                 736
1123418 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_11 3 98 24 1   5     1   2   64 70                       134 3 98 24 1   5     1   2   64 70                 134
2043495 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_11 232 98 195 0   237     1   19   386 396                       782.0 232 98 195 0   237     1   19   386 396                 782
1123379 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_11 22 97 84 0   77     0   6   136 150                       286 22 97 84 0   77     0   6   136 150                 286
1365937 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2020   grade_11 6 97 125 1   7     1   1   147 91 *                     238.0 6 97 125 1   7     1   1   147 91                 238
1368683 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   grade_11 100 97 125 0   104     0   7   249 183 *                     433.0 100 97 125 0   104     0   7   249 183                 433
2042162 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_11 128 97 265 2   23     2   5   270 252                       522.0 128 97 265 2   23     2   5   270 252                 522
2233416 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden: Malden High   Regular School No High 09 12 2018   grade_11 130 97 103 2   108     0   15   218 237                       455.0 130 97 103 2   108     0   15   218 237                 455
933686 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2016   grade_11 5 96 19 0   0     0   1   64 57                       121 5 96 19 0   0     0   1   64 57                 121
1123272 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   grade_11 8 96 96 2   9     0   2   131 82                       213 8 96 96 2   9     0   2   131 82                 213
1673235 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston - O'Bryant School Math/Science   Regular School No High 07 12 2021   grade_11 37 96 86 1   61     0   4   125 160 *                     285.0 37 96 86 1   61     0   4   125 160                 285
1678308 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield - Springfield Central High   Regular School No High 09 12 2021   grade_11 54 96 231 0   20     0   5   208 198 *                     406.0 54 96 231 0   20     0   5   208 198                 406
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
936453 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2016   grade_11 113 95 90 2   98     1   20   201 218                       419 113 95 90 2   98     1   20   201 218                 419
2045297 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2019   grade_11 14 95 14 1   29     1   4   87 71                       158.0 14 95 14 1   29     1   4   87 71                 158
2230184 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_11 25 95 82 2   65     1   6   126 150                       276.0 25 95 82 2   65     1   6   126 150                 276
2230238 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_11 3 95 26 1   8     0   2   78 57                       135.0 3 95 26 1   8     0   2   78 57                 135
2230194 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Boston: Community Academy of Science and Health   Regular School No High 09 12 2018   grade_11 0 94 27 0   1     0   4   67 59                       126.0 0 94 27 0   1     0   4   67 59                 126
741996 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_11 73 93 212 0   26     0   16   210 210                       420 73 93 212 0   26     0   16   210 210                 420
937115 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_11 284 93 276 5   6     3   28   351 344                       695 284 93 276 5   6     3   28   351 344                 695
1673176 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston - Madison Park High   Career and Technical School No High 09 12 2021   grade_11 5 93 124 2   1     1   3   130 99 *                     229.0 5 93 124 2   1     1   3   130 99                 229
745112 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 175 92 39 0   1     0   6   168 145                       313 175 92 39 0   1     0   6   168 145                 313
1366025 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_11 4 92 32 1   5     0   0   66 68 *                     134.0 4 92 32 1   5     0   0   66 68                 134
1681493 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_11 1 92 8 0   0     0   0   49 52 *                     101.0 1 92 8 0   0     0   0   49 52                 101
933699 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   grade_11 13 90 117 5   1     1   7   131 103                       234 13 90 117 5   1     1   7   131 103                 234
936209 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_11 274 90 165 1   247     0   6   394 389                       783 274 90 165 1   247     0   6   394 389                 783
1123339 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_11 82 90 56 1   68     1   5   127 176                       303 82 90 56 1   68     1   5   127 176                 303
1367090 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_11 96 90 221 0   24     0   11   233 209 *                     442.0 96 90 221 0   24     0   11   233 209                 442
1677471 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   grade_11 15 90 28 0   31     0   2   105 61 *                     166.0 15 90 28 0   31     0   2   105 61                 166
2046377 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_11 311 90 63 0   8     2   15   224 264                       489.0 311 90 63 0   8     2   15   224 264                 489
736911 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_11 13 9 11 0   1     0   2   20 16                       36 13 9 11 0   1     0   2   20 16                 36
739816 MA Middlesex   school 2507560 176   Medford 250756001174 1760605 Medford Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_11 51 9 8 0   2     0   1   50 21                       71 51 9 8 0   2     0   1   50 21                 71
741209 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2015   grade_11 286 9 5 0   13     0   6   175 144                       319 286 9 5 0   13     0   6   175 144                 319
742543 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No 3 09 12 2015   grade_11 170 9 12 0   32     0   9   109 123                       232 170 9 12 0   32     0   9   109 123                 232
743511 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 2015   grade_11 103 9 12 0   57     0   5   98 88                       186 103 9 12 0   57     0   5   98 88                 186
744264 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2015   grade_11 220 9 6 0   6     0   3   124 120                       244 220 9 6 0   6     0   3   124 120                 244
745045 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 135 9 14 1   1     0   5   93 72                       165 135 9 14 1   1     0   5   93 72                 165
745058 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 2015   grade_11 292 9 18 3   9     1   13   186 159                       345 292 9 18 3   9     1   13   186 159                 345
936661 MA Middlesex   school 2507560 176   Medford 250756001174 1760605 Medford Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_11 35 9 2 0   0     0   1   34 13                       47 35 9 2 0   0     0   1   34 13                 47
936804 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   grade_11 210 9 46 0   2     0   2   144 125                       269 210 9 46 0   2     0   2   144 125                 269
939211 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No 3 09 12 2016   grade_11 260 9 3 1   8     0   3   143 141                       284 260 9 3 1   8     0   3   143 141                 284
939298 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No 3 09 12 2016   grade_11 84 9 12 1   1     0   15   58 64                       122 84 9 12 1   1     0   15   58 64                 122
939327 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No 3 09 12 2016   grade_11 129 9 19 0   17     1   4   94 85                       179 129 9 19 0   17     1   4   94 85                 179
941866 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_11 116 9 13 5   1     0   4   89 59                       148 116 9 13 5   1     0   4   89 59                 148
1123332 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2017   grade_11 1 9 30 0   0     0   1   28 13                       41 1 9 30 0   0     0   1   28 13                 41
1124199 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2017   grade_11 146 9 87 0   9     1   3   115 140                       255 146 9 87 0   9     1   3   115 140                 255
1124864 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   grade_11 158 9 9 1   6     0   14   103 94                       197 158 9 9 1   6     0   14   103 94                 197
1126142 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2017   grade_11 186 9 9 0   20     0   2   115 111                       226 186 9 9 0   20     0   2   115 111                 226
1129990 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No High 09 12 2017   grade_11 87 9 10 2   2     0   10   56 64                       120 87 9 10 2   2     0   10   56 64                 120
1132989 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2017   grade_11 267 9 21 2   4     0   8   172 138                       311 267 9 21 2   4     0   8   172 138                 311
1133034 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Career and Technical School No High 09 12 2017   grade_11 110 9 16 0   6     0   2   91 52                       143 110 9 16 0   6     0   2   91 52                 143
1365181 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2020   grade_11 220 9 12 0   64     0   23   168 160 *                     328.0 220 9 12 0   64     0   23   168 160                 328
1367440 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_11 380 9 13 2   33     0   10   235 212 *                     447.0 380 9 13 2   33     0   10   235 212                 447
1368749 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2020   grade_11 104 9 138 0   3     0   6   127 133 *                     260.0 104 9 138 0   3     0   6   127 133                 260
1369587 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No High 09 12 2020   grade_11 290 9 37 0   29     0   5   191 179 *                     370.0 290 9 37 0   29     0   5   191 179                 370
1370265 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2020   grade_11 293 9 8 1   15     0   5   170 160 *                     331.0 293 9 8 1   15     0   5   170 160                 331
1370483 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2020   grade_11 128 9 36 2   6     0   2   102 80 *                     183.0 128 9 36 2   6     0   2   102 80                 183
1371324 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2020   grade_11 182 9 12 0   8     0   2   94 119 *                     213.0 182 9 12 0   8     0   2   94 119                 213
1371455 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2020   grade_11 224 9 16 1   15     0   4   139 130 *                     269.0 224 9 16 1   15     0   4   139 130                 269
1371690 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2020   grade_11 203 9 20 1   75     1   9   165 153 *                     318.0 203 9 20 1   75     1   9   165 153                 318
1372382 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_11 6 9 53 0   5     0   1   45 29 *                     74.0 6 9 53 0   5     0   1   45 29                 74
1372458 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_11 14 9 144 1   0     0   0   84 84 *                     168.0 14 9 144 1   0     0   0   84 84                 168
1373489 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2020   grade_11 283 9 8 0   8     0   6   155 159 *                     314.0 283 9 8 0   8     0   6   155 159                 314
1374119 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2020   grade_11 96 9 77 3   1     0   4   116 74 *                     190.0 96 9 77 3   1     0   4   116 74                 190
1672150 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_11 275 9 31 2   85     0   6   193 215 *                     408.0 275 9 31 2   85     0   6   193 215                 408
1672403 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont - Belmont High   Regular School No High 09 12 2021   grade_11 229 9 17 0   59     0   21   163 172 *                     335.0 229 9 17 0   59     0   21   163 172                 335
1674475 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_11 148 9 9 1   6     0   12   92 92 *                     185.0 148 9 9 1   6     0   12   92 92                 185
1675999 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough - Marlborough High   Regular School No High 09 12 2021   grade_11 94 9 135 0   4     0   6   131 117 *                     248.0 94 9 135 0   4     0   6   131 117                 248
1677735 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus - Saugus High   Regular School No High 09 12 2021   grade_11 134 9 25 1   6     0   1   83 93 *                     176.0 134 9 25 1   6     0   1   83 93                 176
1678328 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield - Springfield High School   Regular School No High 09 12 2021   grade_11 5 9 37 0   0     0   0   30 21 *                     51.0 5 9 37 0   0     0   0   30 21                 51
1678487 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott - Swampscott High   Regular School No High 09 12 2021   grade_11 146 9 27 0   7     0   2   87 104 *                     191.0 146 9 27 0   7     0   2   87 104                 191
1680734 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Hampden-Wilbraham - Minnechaug Regional High   Regular School No High 09 12 2021   grade_11 226 9 22 2   10     0   7   127 149 *                     276.0 226 9 22 2   10     0   7   127 149                 276
1681367 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_11 96 9 92 5   2     0   8   127 85 *                     212.0 96 9 92 5   2     0   8   127 85                 212
2039954 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_11 319 9 26 0   67     0   9   218 212                       430.0 319 9 26 0   67     0   9   218 212                 430
2042943 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_11 63 9 322 0   5     0   6   195 210                       405.0 63 9 322 0   5     0   6   195 210                 405
2045338 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2019   grade_11 269 9 5 1   20     0   3   139 168                       307.0 269 9 5 1   20     0   3   139 168                 307
2046486 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2019   grade_11 225 9 12 0   9     0   7   127 135                       262.0 225 9 12 0   9     0   7   127 135                 262
2048376 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2019   grade_11 231 9 22 2   4     0   5   133 139                       273.0 231 9 22 2   4     0   5   133 139                 273
2048909 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2019   grade_11 283 9 3 1   5     1   3   159 146                       305.0 283 9 3 1   5     1   3   159 146                 305
2049307 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_11 2 9 10 0   0     0   1   14 8                       22.0 2 9 10 0   0     0   1   14 8                 22
2230667 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington: Burlington High   Regular School No High 09 12 2018   grade_11 183 9 14 1   35     0   9   112 139                       251.0 183 9 14 1   35     0   9   112 139                 251
2231288 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut: Dracut Senior High   Regular School No High 09 12 2018   grade_11 167 9 13 0   15     1   4   101 108                       209.0 167 9 13 0   15     1   4   101 108                 209
2231783 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough: Foxborough High   Regular School No High 09 12 2018   grade_11 186 9 5 0   6     0   2   119 89                       208.0 186 9 5 0   6     0   2   119 89                 208
2231924 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_11 368 9 8 1   27     2   8   203 220                       423.0 368 9 8 1   27     2   8   203 220                 423
2232816 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Leominster: Center For Technical Education Innovation   Career and Technical School No High 09 12 2018   grade_11 80 9 37 0   5     0   5   101 35                       136.0 80 9 37 0   5     0   5   101 35                 136
2235298 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading: Reading Memorial High   Regular School No High 09 12 2018   grade_11 299 9 7 0   15     0   1   165 166                       331.0 299 9 7 0   15     0   1   165 166                 331
2235716 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury: Shrewsbury Sr High   Regular School No High 09 12 2018   grade_11 285 9 34 0   91     1   9   191 237                       429.0 285 9 34 0   91     1   9   191 237                 429
2236433 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott: Swampscott High   Regular School No High 09 12 2018   grade_11 148 9 10 0   6     1   4   88 90                       178.0 148 9 10 0   6     1   4   88 90                 178
2238353 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District): Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2018   grade_11 42 9 7 0   1     0   8   18 49                       67.0 42 9 7 0   1     0   8   18 49                 67
2239844 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 2018   grade_11 78 9 83 2   0     0   5   115 62                       177.0 78 9 83 2   0     0   5   115 62                 177
741167 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2015   grade_11 22 89 20 1   29     0   3   100 64                       164 22 89 20 1   29     0   3   100 64                 164
2044412 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_11 159 89 261 4   7     1   21   297 245                       542.0 159 89 261 4   7     1   21   297 245                 542
2235248 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph: Randolph High   Regular School No High 09 12 2018   grade_11 10 89 18 1   30     0   7   78 77                       155.0 10 89 18 1   30     0   7   78 77                 155
1128427 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2017   grade_11 18 88 17 1   39     1   8   96 76                       172 18 88 17 1   39     1   8   96 76                 172
1129441 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2017   grade_11 52 88 207 0   5     0   6   163 195                       358 52 88 207 0   5     0   6   163 195                 358
2041042 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2019   grade_11 18 88 76 1   68     0   8   101 158                       259.0 18 88 76 1   68     0   8   101 158                 259
1123389 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2017   grade_11 3 87 23 0   3     0   0   68 48                       116 3 87 23 0   3     0   0   68 48                 116
1129402 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2017   grade_11 88 87 174 0   25     0   4   192 186                       378 88 87 174 0   25     0   4   192 186                 378
2230077 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston: Brighton High   Regular School No High 09 12 2018   grade_11 12 87 92 1   8     0   4   117 87                       204.0 12 87 92 1   8     0   4   117 87                 204

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