Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by black descending

View and edit SQL

grade

year

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
737124 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_5 9 99 14 0   3     1   6   65 67                       132 9 99 14 0   3     1   6   65 67                 132
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
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
1123651 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2017   grade_3 17 99 11 0   2     0   9   73 65                       138 17 99 11 0   2     0   9   73 65                 138
2238030 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_2 8 99 68 0   2     0   3   81 99                       180.0 8 99 68 0   2     0   3   81 99                 180
2238035 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_7 9 99 59 0   3     0   4   88 86                       174.0 9 99 59 0   3     0   4   88 86                 174
2238393 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_10 1 99 58 0   1     0   3   79 83                       162.0 1 99 58 0   1     0   3   79 83                 162
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
2041297 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 07 08 2019   grade_7 14 99 29 1   4     0   8   96 59                       155.0 14 99 29 1   4     0   8   96 59                 155
2047616 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_7 5 99 73 0   2     0   0   91 88                       179.0 5 99 73 0   2     0   0   91 88                 179
2049328 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_9 1 99 9 0   0     0   0   57 52                       109.0 1 99 9 0   0     0   0   57 52                 109
1367089 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_10 103 99 298 3   24     0   7   274 260 *                     534.0 103 99 298 3   24     0   7   274 260                 534
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
1372534 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   kindergarten 6 99 68 1   5     0   7   81 105 *                     186.0 6 99 68 1   5     0   7   81 105                 186
1372538 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_4 10 99 66 0   2     0   4   85 96 *                     181.0 10 99 66 0   2     0   4   85 96                 181
1372540 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_6 6 99 64 0   5     0   2   80 96 *                     176.0 6 99 64 0   5     0   2   80 96                 176
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
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
739607 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_10 123 98 94 1   102     1   22   223 218                       441 123 98 94 1   102     1   22   223 218                 441
745154 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes 4 09 10 2015   grade_9 3 98 30 0   3     0   3   64 73                       137 3 98 30 0   3     0   3   64 73                 137
933927 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_1 17 98 30 2   0     0   15   90 72                       162 17 98 30 2   0     0   15   90 72                 162
934021 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2016   grade_6 49 98 59 0   4     1   17   103 125                       228 49 98 59 0   4     1   17   103 125                 228
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
1123696 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_7 48 98 65 0   3     1   19   102 132                       234 48 98 65 0   3     1   19   102 132                 234
1126593 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_9 137 98 121 2   100     0   15   257 216                       473 137 98 121 2   100     0   15   257 216                 473
2230460 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton: Louis F Angelo Elementary   Regular School No Elementary KG 05 2018   grade_4 58 98 29 2   15     0   10   101 111                       212.0 58 98 29 2   15     0   10   101 111                 212
2238031 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_3 14 98 66 1   4     0   4   91 96                       187.0 14 98 66 1   4     0   4   91 96                 187
2040979 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_10 3 98 164 0   4     0   3   175 97                       272.0 3 98 164 0   4     0   3   175 97                 272
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
1368681 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   grade_9 119 98 146 1   108     0   15   241 246 *                     487.0 119 98 146 1   108     0   15   241 246                 487
1374253 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1673388 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton - Manthala George Jr. School   Regular School No Elementary KG 05 2021   kindergarten 18 98 49 0   0     1   3   87 82 *                     169.0 18 98 49 0   0     1   3   87 82                 169
1673433 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_4 53 98 27 1   7     0   4   96 94 *                     190.0 53 98 27 1   7     0   4   96 94                 190
1679804 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_7 5 98 66 0   4     0   3   83 93 *                     176.0 5 98 66 0   4     0   3   83 93                 176
736856 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_9 90 97 68 1   73     1   6   144 192                       336 90 97 68 1   73     1   6   144 192                 336
736924 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_8 4 97 27 1   9     0   2   74 66                       140 4 97 27 1   9     0   2   74 66                 140
737122 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_3 8 97 11 1   1     0   4   67 55                       122 8 97 11 1   1     0   4   67 55                 122
737152 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_6 47 97 23 0   11     0   11   106 83                       189 47 97 23 0   11     0   11   106 83                 189
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
739606 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_9 133 97 138 2   117     0   15   274 228                       502 133 97 138 2   117     0   15   274 228                 502
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
933929 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_3 18 97 26 1   0     0   5   73 74                       147 18 97 26 1   0     0   5   73 74                 147
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
1131205 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_5 11 97 71 0   3     0   2   87 97                       184 11 97 71 0   3     0   2   87 97                 184
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
2240000 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 Middle 06 09 2018   grade_8 3 97 8 0   0     0   0   55 53                       108.0 3 97 8 0   0     0   0   55 53                 108
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
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
1368411 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_10 221 97 182 0   229     0   25   366 388 *                     754.0 221 97 182 0   229     0   25   366 388                 754
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
1374254 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_8 2 97 10 1   0     0   0   60 50 *                     110.0 2 97 10 1   0     0   0   60 50                 110
1673458 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_6 24 97 18 0   0     1   7   91 56 *                     147.0 24 97 18 0   0     1   7   91 56                 147
1676587 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_10 263 97 352 5   4     0   35   397 359 *                     756.0 263 97 352 5   4     0   35   397 359                 756
737146 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2015   grade_6 19 96 18 0   1     1   7   77 65                       142 19 96 18 0   1     1   7   77 65                 142
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
933754 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2016   grade_9 33 96 91 2   69     1   6   136 162                       298 33 96 91 2   69     1   6   136 162                 298
934014 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_8 29 96 32 0   7     0   10   90 84                       174 29 96 32 0   7     0   10   90 84                 174
936207 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_9 253 96 223 0   259     0   24   432 423                       855 253 96 223 0   259     0   24   432 423                 855
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
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
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
1123579 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_2 16 96 24 2   0     0   14   88 64                       152 16 96 24 2   0     0   14   88 64                 152
1123581 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_4 16 96 27 1   0     0   5   74 71                       145 16 96 27 1   0     0   5   74 71                 145
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
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
1366023 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_9 2 96 33 1   5     0   8   94 51 *                     145.0 2 96 33 1   5     0   8   94 51                 145
1366199 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_4 49 96 32 1   10     0   11   105 94 *                     199.0 49 96 32 1   10     0   11   105 94                 199
1366201 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   kindergarten 7 96 11 0   0     1   3   66 52 *                     118.0 7 96 11 0   0     1   3   66 52                 118
1366202 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   grade_1 7 96 18 0   0     0   1   69 53 *                     122.0 7 96 18 0   0     0   1   69 53                 122
1372537 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_3 9 96 73 0   4     0   0   82 100 *                     182.0 9 96 73 0   4     0   0   82 100                 182
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
1679803 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_6 14 96 63 1   4     0   4   85 97 *                     182.0 14 96 63 1   4     0   4   85 97                 182
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
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
933991 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 05 2016   grade_5 9 95 16 1   5     0   5   70 61                       131 9 95 16 1   5     0   5   70 61                 131
934012 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_6 53 95 27 0   4     1   9   95 94                       189 53 95 27 0   4     1   9   95 94                 189
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
1123695 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_6 60 95 72 1   8     0   12   124 124                       248 60 95 72 1   8     0   12   124 124                 248
1128423 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2017   grade_8 28 95 34 0   39     0   9   114 91                       205 28 95 34 0   39     0   9   114 91                 205
1131201 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_1 8 95 73 0   2     0   4   87 95                       182 8 95 73 0   2     0   4   87 95                 182
1131202 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_2 14 95 63 2   5     0   4   86 97                       183 14 95 63 2   5     0   4   86 97                 183
1131204 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_4 13 95 73 2   4     0   4   102 89                       191 13 95 73 2   4     0   4   102 89                 191
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
2239999 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 Middle 06 09 2018   grade_7 1 95 10 0   0     0   2   51 57                       108.0 1 95 10 0   0     0   2   51 57                 108
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
2049327 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_8 1 95 10 0   0     0   2   49 59                       108.0 1 95 10 0   0     0   2   49 59                 108
1366156 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2020   grade_1 15 95 73 0   1     0   5   98 91 *                     189.0 15 95 73 0   1     0   5   98 91                 189
1372536 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_2 4 95 81 0   5     0   2   91 96 *                     187.0 4 95 81 0   5     0   2   91 96                 187
1372539 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_5 13 95 64 1   4     0   4   83 98 *                     181.0 13 95 64 1   4     0   4   83 98                 181
1372863 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_10 2 95 63 0   0     0   1   77 84 *                     161.0 2 95 63 0   0     0   1   77 84                 161
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
938811 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_9 43 94 303 0   4     0   8   239 213                       452 43 94 303 0   4     0   8   239 213                 452
1123683 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_6 26 94 30 0   6     1   14   89 82                       171 26 94 30 0   6     1   14   89 82                 171
1123685 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_8 44 94 21 0   8     0   9   100 76                       176 44 94 21 0   8     0   9   100 76                 176
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
2230511 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_8 47 94 56 0   3     1   20   95 126                       221.0 47 94 56 0   3     1   20   95 126                 221
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

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