Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by black descending

View and edit SQL

year

grade

  • grade_9 · 2,737
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
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
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
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
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
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
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
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
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
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
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
2042160 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_9 102 94 273 4   23     0   7   258 245                       503.0 102 94 273 4   23     0   7   258 245                 503
1679806 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_9 3 93 50 0   1     0   1   72 76 *                     148.0 3 93 50 0   1     0   1   72 76                 148
741165 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2015   grade_9 25 92 14 1   36     1   10   97 82                       179 25 92 14 1   36     1   10   97 82                 179
1372543 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_9 5 91 32 0   1     0   2   71 60 *                     131.0 5 91 32 0   1     0   2   71 60                 131
736817 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2015   grade_9 4 90 38 0   2     0   1   85 50                       135 4 90 38 0   2     0   1   85 50                 135
934859 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2016   grade_9 164 90 235 3   24     1   8   281 244                       525 164 90 235 3   24     1   8   281 244                 525
1370221 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2020   grade_9 13 90 22 0   22     0   12   91 68 *                     159.0 13 90 22 0   22     0   12   91 68                 159
737130 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 3 07 12 2015   grade_9 2 9 1 0   0     0   0   8 4                       12 2 9 1 0   0     0   0   8 4                 12
737855 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_9 157 9 3 0   0     2   2   82 91                       173 157 9 3 0   0     2   2   82 91                 173
741572 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No 3 09 12 2015   grade_9 310 9 26 0   73     1   13   187 245                       432 310 9 26 0   73     1   13   187 245                 432
744063 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No 3 09 12 2015   grade_9 74 9 7 0   1     1   5   49 48                       97 74 9 7 0   1     1   5   49 48                 97
932677 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_9 367 9 17 0   66     0   12   209 262                       471 367 9 17 0   66     0   12   209 262                 471
933825 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative Education School No 3 08 12 2016   grade_9 1 9 6 1   0     0   0   8 9                       17 1 9 6 1   0     0   0   8 9                 17
933993 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 4 06 12 2016   grade_9 3 9 0 0   0     0   0   9 3                       12 3 9 0 0   0     0   0   9 3                 12
934563 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2016   grade_9 225 9 15 0   7     0   3   129 130                       259 225 9 15 0   7     0   3   129 130                 259
938294 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2016   grade_9 199 9 0 0   3     0   2   101 112                       213 199 9 0 0   3     0   2   101 112                 213
938988 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2016   grade_9 149 9 11 0   6     1   6   87 95                       182 149 9 11 0   6     1   6   87 95                 182
942018 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_9 44 9 10 1   2     1   1   30 38                       68 44 9 10 1   2     1   1   30 38                 68
1122547 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2017   grade_9 306 9 17 0   21     0   7   176 184                       360 306 9 17 0   21     0   7   176 184                 360
1125619 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2017   grade_9 72 9 340 0   6     0   6   223 210                       433 72 9 340 0   6     0   6   223 210                 433
1128590 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No High 09 12 2017   grade_9 154 9 23 0   0     0   10   103 93                       196 154 9 23 0   0     0   10   103 93                 196
1130636 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2017   grade_9 246 9 15 1   72     0   16   169 190                       359 246 9 15 1   72     0   16   169 190                 359
1131737 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_9 270 9 12 1   138     0   18   224 224                       448 270 9 12 1   138     0   18   224 224                 448
1131843 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2017   grade_9 80 9 11 1   3     0   4   55 53                       108 80 9 11 1   3     0   4   55 53                 108
1132987 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_9 302 9 19 2   1     0   12   192 153                       345 302 9 19 2   1     0   12   192 153                 345
1133191 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_9 51 9 16 0   2     0   3   35 46                       81 51 9 16 0   2     0   3   35 46                 81
1366678 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2020   grade_9 186 9 100 0   5     0   6   182 124 *                     306.0 186 9 100 0   5     0   6   182 124                 306
1371034 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_9 4 9 39 0   0     0   2   12 42 *                     54.0 4 9 39 0   0     0   2   12 42                 54
1371057 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No High 09 12 2020   grade_9 3 9 23 0   0     0   0   28 7 *                     35.0 3 9 23 0   0     0   0   28 7                 35
1371322 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2020   grade_9 173 9 6 1   7     0   2   95 103 *                     198.0 173 9 6 1   7     0   2   95 103                 198
1371410 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2020   grade_9 182 9 17 0   7     0   4   112 107 *                     219.0 182 9 17 0   7     0   4   112 107                 219
1371594 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2020   grade_9 131 9 8 0   38     0   16   94 108 *                     202.0 131 9 8 0   38     0   16   94 108                 202
1371716 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_9 89 9 6 0   0     0   1   53 52 *                     105.0 89 9 6 0   0     0   1   53 52                 105
1374084 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 306 9 19 1   4     0   18   197 160 *                     357.0 306 9 19 1   4     0   18   197 160                 357
1374137 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2020   grade_9 193 9 127 0   2     1   4   190 146 *                     336.0 193 9 127 0   2     1   4   190 146                 336
1374169 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_9 141 9 7 1   1     1   13   100 73 *                     173.0 141 9 7 1   1     1   13   100 73                 173
1374185 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2020   grade_9 0 9 74 0   0     0   0   43 40 *                     83.0 0 9 74 0   0     0   0   43 40                 83
1672199 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_9 271 9 23 0   41     1   18   161 201 *                     363.0 271 9 23 0   41     1   18   161 201                 363
1674134 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut - Dracut Senior High   Regular School No High 09 12 2021   grade_9 154 9 21 1   24     0   2   105 103 *                     211.0 154 9 21 1   24     0   2   105 103                 211
1674233 MA Bristol   school 2504620 88   Easton 250462000623 880505 Easton - Oliver Ames High   Regular School No High 09 12 2021   grade_9 220 9 18 0   10     0   8   137 128 *                     265.0 220 9 18 0   10     0   8   137 128                 265
1676227 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_9 192 9 194 0   15     0   22   219 212 *                     432.0 192 9 194 0   15     0   22   219 212                 432
1677733 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus - Saugus High   Regular School No High 09 12 2021   grade_9 111 9 41 1   10     0   0   91 81 *                     172.0 111 9 41 1   10     0   0   91 81                 172
1678485 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott - Swampscott High   Regular School No High 09 12 2021   grade_9 124 9 19 0   4     0   5   78 82 *                     161.0 124 9 19 0   4     0   5   78 82                 161
1679120 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield - West Springfield High   Regular School No High 09 12 2021   grade_9 208 9 67 0   21     0   10   159 156 *                     315.0 208 9 67 0   21     0   10   159 156                 315
1680134 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District) - Salem Academy Charter School   Regular School Yes High 06 12 2021   grade_9 25 9 36 0   3     0   1   42 32 *                     74.0 25 9 36 0   3     0   1   42 32                 74
1680585 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset - Nauset Regional High   Regular School No High 09 12 2021   grade_9 162 9 12 0   5     0   4   85 107 *                     192.0 162 9 12 0   5     0   4   85 107                 192
1681340 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District - Essex North Shore Agricultural and Technical School   Career and Technical School No High 09 12 2021   grade_9 338 9 54 0   10     0   15   180 244 *                     426.0 338 9 54 0   10     0   15   180 244                 426
1681369 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional Vocational Technical - Minuteman Regional High   Career and Technical School No High 09 12 2021   grade_9 136 9 17 1   4     0   12   101 78 *                     179.0 136 9 17 1   4     0   12   101 78                 179
2041913 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2019   grade_9 124 9 31 0   2     0   4   95 75                       170.0 124 9 31 0   2     0   4   95 75                 170
2042995 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_9 128 9 18 0   0     1   5   69 92                       161.0 128 9 18 0   0     1   5   69 92                 161
2044095 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_9 177 9 84 1   6     0   10   157 130                       287.0 177 9 84 1   6     0   10   157 130                 287
2045149 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No High 09 12 2019   grade_9 306 9 16 1   5     0   19   200 156                       356.0 306 9 16 1   5     0   19   200 156                 356
2045435 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No High 09 12 2019   grade_9 105 9 20 0   3     0   7   66 78                       144.0 105 9 20 0   3     0   7   66 78                 144
2045499 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2019   grade_9 79 9 105 1   7     0   18   130 89                       219.0 79 9 105 1   7     0   18   130 89                 219
2046302 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No High 09 12 2019   grade_9 139 9 26 0   7     0   2   80 103                       183.0 139 9 26 0   7     0   2   80 103                 183
2046527 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2019   grade_9 228 9 12 2   19     0   8   133 145                       278.0 228 9 12 2   19     0   8   133 145                 278
2046641 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2019   grade_9 91 9 38 0   19     0   7   83 81                       164.0 91 9 38 0   19     0   7   83 81                 164
2046667 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2019   grade_9 129 9 8 0   42     1   10   104 95                       199.0 129 9 8 0   42     1   10   104 95                 199
2047941 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes High 06 12 2019   grade_9 29 9 36 0   4     0   1   36 43                       79.0 29 9 36 0   4     0   1   36 43                 79
2048097 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_9 246 9 22 0   154     0   29   227 233                       460.0 246 9 22 0   154     0   29   227 233                 460
2048382 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2019   grade_9 185 9 7 0   3     1   8   106 106                       213.0 185 9 7 0   3     1   8   106 106                 213
2049358 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_9 52 9 19 1   2     1   2   32 54                       86.0 52 9 19 1   2     1   2   32 54                 86
2231017 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee: Chicopee Comprehensive High School   Regular School No High 09 12 2018   grade_9 222 9 89 2   12     0   8   191 151                       342.0 222 9 89 2   12     0   8   191 151                 342
2231689 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth: Falmouth High   Regular School No High 09 12 2018   grade_9 188 9 6 3   6     0   19   105 126                       231.0 188 9 6 3   6     0   19   105 126                 231
2231922 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_9 386 9 10 2   36     0   9   231 221                       452.0 386 9 10 2   36     0   9   231 221                 452
2231940 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_9 128 9 21 0   2     0   9   93 76                       169.0 128 9 21 0   2     0   9   93 76                 169
2232956 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow: Longmeadow High   Regular School No High 09 12 2018   grade_9 189 9 7 1   21     0   8   118 117                       235.0 189 9 7 1   21     0   8   118 117                 235
2235296 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading: Reading Memorial High   Regular School No High 09 12 2018   grade_9 291 9 6 1   14     0   4   167 158                       325.0 291 9 6 1   14     0   4   167 158                 325
2236549 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury: Tewksbury Memorial High   Regular School No High 09 12 2018   grade_9 182 9 10 0   9     0   7   94 123                       217.0 182 9 10 0   9     0   7   94 123                 217
2236803 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham: Wareham Senior High   Regular School No High 09 12 2018   grade_9 88 9 11 4   1     0   13   66 60                       126.0 88 9 11 4   1     0   13   66 60                 126
2237215 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield: West Springfield High   Regular School No High 09 12 2018   grade_9 222 9 75 0   21     0   2   161 168                       329.0 222 9 75 0   21     0   2   161 168                 329
2237940 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_9 12 9 148 1   0     0   2   89 83                       172.0 12 9 148 1   0     0   2   89 83                 172
2238574 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough: Acton-Boxborough Regional High   Regular School No High 09 12 2018   grade_9 240 9 11 1   145     0   21   225 202                       427.0 240 9 11 1   145     0   21   225 202                 427
2239109 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip: King Philip Regional High   Regular School No High 09 12 2018   grade_9 283 9 6 0   6     0   6   152 158                       310.0 283 9 6 0   6     0   6   152 158                 310
2239202 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District: Monomoy Regional High School   Regular School No High 08 12 2018   grade_9 94 9 4 0   0     0   5   52 60                       112.0 94 9 4 0   0     0   5   52 60                 112
2239842 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_9 102 9 78 4   0     0   5   120 78                       198.0 102 9 78 4   0     0   5   120 78                 198
2239852 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical: Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 292 9 54 0   6     0   13   172 201                       374.0 292 9 54 0   6     0   13   172 201                 374
2239907 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Regional Vocational Technical: Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 160 9 6 2   3     0   10   126 64                       190.0 160 9 6 2   3     0   10   126 64                 190
933670 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2016   grade_9 17 89 147 0   33     0   2   182 106                       288 17 89 147 0   33     0   2   182 106                 288
1123377 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_9 21 89 89 1   66     0   10   107 169                       276 21 89 89 1   66     0   10   107 169                 276
1369337 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_9 269 89 331 3   4     0   37   377 355 *                     733.0 269 89 331 3   4     0   37   377 355                 733
933661 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2016   grade_9 6 88 116 1   3     0   5   139 80                       219 6 88 116 1   3     0   5   139 80                 219
1673260 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_9 8 88 60 1   4     1   4   97 69 *                     166.0 8 88 60 1   4     1   4   97 69                 166
2040978 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_9 5 88 137 2   4     0   5   146 95                       241.0 5 88 137 2   4     0   5   146 95                 241
2230236 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_9 4 88 41 1   3     0   3   74 66                       140.0 4 88 41 1   3     0   3   74 66                 140
940357 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes 3 09 12 2016   grade_9 2 87 17 0   0     0   2   46 62                       108 2 87 17 0   0     0   2   46 62                 108
1681491 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_9 2 87 7 1   0     0   1   53 45 *                     98.0 2 87 7 1   0     0   1   53 45                 98
2233414 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden: Malden High   Regular School No High 09 12 2018   grade_9 131 87 127 2   108     0   17   278 193                       472.0 131 87 127 2   108     0   17   278 193                 472
2240001 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_9 1 87 6 0   5     0   0   52 47                       99.0 1 87 6 0   5     0   0   52 47                 99
1366241 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_9 169 865 231 3   29     3   52   766 586 *                     1352.0 169 865 231 3   29     3   52   766 586                 1352

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