Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_9 · 2,637
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
745027 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Vocational Education School No 3 09 12 2015   grade_9 232 2 34 4   1     0   7   160 120                       280 232 2 34 4   1     0   7   160 120                 280
941848 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Vocational Education School No 3 09 12 2016   grade_9 233 0 44 0   1     0   6   158 126                       284 233 0 44 0   1     0   6   158 126                 284
1132972 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2017   grade_9 246 3 39 2   2     0   8   187 113                       300 246 3 39 2   2     0   8   187 113                 300
1374072 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2020   grade_9 221 10 63 1   0     0   5   182 115 3                     300.0 221 10 63 1   0     0   5   182 115 3               300
1681320 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical - Assabet Valley Vocational High School   Career and Technical School No High 09 12 2021   grade_9 219 1 78 0   2     0   6   166 138 2                     306.0 219 1 78 0   2     0   6   166 138 2               306
2049146 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2019   grade_9 208 8 70 2   3     0   9   181 119                       300.0 208 8 70 2   3     0   9   181 119                 300
2239787 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical: Assabet Valley Vocational High School   Career and Technical School No High 09 12 2018   grade_9 244 2 46 1   1     0   6   182 117                       300.0 244 2 46 1   1     0   6   182 117                 300
744041 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No 3 09 12 2015   grade_9 93 2 5 0   2     0   0   50 52                       102 93 2 5 0   2     0   0   50 52                 102
940875 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No 3 09 12 2016   grade_9 79 1 3 0   0     0   2   48 37                       85 79 1 3 0   0     0   2   48 37                 85
1131818 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2017   grade_9 87 4 6 0   2     0   2   54 47                       101 87 4 6 0   2     0   2   54 47                 101
1373089 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2020   grade_9 66 0 6 0   1     0   2   47 28 *                     75.0 66 0 6 0   1     0   2   47 28                 75
1680353 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol-Royalston - Athol High   Regular School No High 09 12 2021   grade_9 71 4 22 0   1     0   2   49 51 *                     100.0 71 4 22 0   1     0   2   49 51                 100
2048162 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2019   grade_9 80 0 2 0   0     0   3   47 38                       85.0 80 0 2 0   0     0   3   47 38                 85
2238649 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol-Royalston: Athol High   Regular School No High 09 12 2018   grade_9 80 1 9 0   0     0   5   55 40                       95.0 80 1 9 0   0     0   5   55 40                 95
743875 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_9 35 4 6 0   0     0   2   18 29                       47 35 4 6 0   0     0   2   18 29                 47
940705 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_9 49 2 8 0   3     0   1   29 34                       63 49 2 8 0   3     0   1   29 34                 63
1131622 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_9 42 7 11 1   0     0   1   23 39                       62 42 7 11 1   0     0   1   23 39                 62
1372921 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_9 56 7 18 0   2     0   1   38 46 *                     84.0 56 7 18 0   2     0   1   38 46                 84
1680186 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_9 33 5 19 0   1     0   0   30 28 *                     58.0 33 5 19 0   1     0   0   30 28                 58
2047993 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_9 58 5 16 1   1     0   1   41 41                       82.0 58 5 16 1   1     0   1   41 41                 82
2238456 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_9 55 3 12 0   3     0   2   43 32                       75.0 55 3 12 0   3     0   2   43 32                 75
735908 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_9 310 30 48 3   22     2   18   224 209                       433 310 30 48 3   22     2   18   224 209                 433
932784 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2016   grade_9 300 23 54 1   17     1   18   228 186                       414 300 23 54 1   17     1   18   228 186                 414
1122250 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2017   grade_9 317 22 72 2   15     0   21   242 207                       449 317 22 72 2   15     0   21   242 207                 449
1365032 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_9 310 28 79 1   16     0   20   259 194 *                     454.0 310 28 79 1   16     0   20   259 194                 454
1672255 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_9 291 30 73 1   26     0   28   240 209 *                     449.0 291 30 73 1   26     0   28   240 209                 449
2040059 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_9 330 35 72 1   24     1   16   260 219                       479.0 330 35 72 1   24     1   16   260 219                 479
2229056 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_9 309 27 66 1   25     2   26   242 214                       456.0 309 27 66 1   25     2   26   242 214                 456
735931 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_9 146 5 12 0   5     0   3   73 98                       171 146 5 12 0   5     0   3   73 98                 171
932805 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   grade_9 170 6 7 0   12     0   5   101 99                       200 170 6 7 0   12     0   5   101 99                 200
1122276 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_9 138 4 16 1   8     0   7   87 87                       174 138 4 16 1   8     0   7   87 87                 174
1365053 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_9 156 5 24 0   7     0   4   101 95 *                     196.0 156 5 24 0   7     0   4   101 95                 196
1672276 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn - Auburn Senior High   Regular School No High 09 12 2021   grade_9 136 3 14 0   9     0   6   84 84 *                     168.0 136 3 14 0   9     0   6   84 84                 168
2040081 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_9 141 4 14 0   6     0   8   77 96                       173.0 141 4 14 0   6     0   8   77 96                 173
2229082 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   grade_9 155 3 6 1   11     0   5   79 102                       181.0 155 3 6 1   11     0   5   79 102                 181
735946 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2015   grade_9 22 27 7 0   3     0   2   25 36                       61 22 27 7 0   3     0   2   25 36                 61
932820 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_9 23 21 4 0   2     0   1   29 22                       51 23 21 4 0   2     0   1   29 22                 51
1122292 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_9 25 18 3 0   4     0   3   23 29                       53 25 18 3 0   4     0   3   23 29                 53
1365067 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_9 17 21 7 0   1     0   4   28 22 *                     50.0 17 21 7 0   1     0   4   28 22                 50
1672291 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_9 23 16 7 1   3     0   3   33 20 *                     53.0 23 16 7 1   3     0   3   33 20                 53
2040096 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_9 22 24 3 0   3     0   4   33 23                       56.0 22 24 3 0   3     0   4   33 23                 56
2229098 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_9 19 16 1 0   2     0   1   29 10                       39.0 19 16 1 0   2     0   1   29 10                 39
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
940897 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No 3 09 12 2016   grade_9 95 6 12 0   3     0   10   59 67                       126 95 6 12 0   3     0   10   59 67                 126
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
1373110 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2020   grade_9 83 5 11 2   0     0   1   47 55 *                     102.0 83 5 11 2   0     0   1   47 55                 102
1680374 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District - Ayer Shirley Regional High School   Regular School No High 09 12 2021   grade_9 75 2 11 1   5     2   3   54 45 *                     99.0 75 2 11 1   5     2   3   54 45                 99
2048184 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2019   grade_9 62 5 8 3   2     1   6   44 43                       87.0 62 5 8 3   2     1   6   44 43                 87
2238674 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District: Ayer Shirley Regional High School   Regular School No High 09 12 2018   grade_9 71 5 13 2   2     0   13   47 59                       106.0 71 5 13 2   2     0   13   47 59                 106
735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
932847 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_9 284 30 28 3   16     2   21   186 198                       384 284 30 28 3   16     2   21   186 198                 384
1122326 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_9 269 38 44 2   13     1   13   169 211                       380 269 38 44 2   13     1   13   169 211                 380
1365097 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_9 218 30 53 2   5     1   23   134 198 *                     332.0 218 30 53 2   5     1   23   134 198                 332
1672321 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_9 221 34 74 1   9     0   16   194 160 *                     355.0 221 34 74 1   9     0   16   194 160                 355
2040123 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_9 246 35 39 1   6     0   14   177 164                       341.0 246 35 39 1   6     0   14   177 164                 341
2229132 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_9 262 31 57 1   4     1   13   200 169                       369.0 262 31 57 1   4     1   13   200 169                 369
941969 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 09 2016   grade_9 3 18 43 0   0     0   1   29 36                       65 3 18 43 0   0     0   1   29 36                 65
1133120 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_9 6 27 44 0   1     0   1   38 41                       79 6 27 44 0   1     0   1   38 41                 79
1374192 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_9 5 15 45 0   0     0   0   43 22 *                     65.0 5 15 45 0   0     0   0   43 22                 65
1681440 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District) - Baystate Academy Charter Public School   Regular School Yes High 06 12 2021   grade_9 5 15 46 0   2     1   1   41 29 *                     70.0 5 15 46 0   2     1   1   41 29                 70
2049268 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_9 2 22 43 0   0     0   0   34 33                       67.0 2 22 43 0   0     0   0   34 33                 67
2239935 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_9 3 16 54 0   1     0   1   35 40                       75.0 3 16 54 0   1     0   1   35 40                 75
735988 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_9 159 20 11 0   30     0   10   99 131                       230 159 20 11 0   30     0   10   99 131                 230
932862 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2016   grade_9 152 18 14 1   19     2   16   115 107                       222 152 18 14 1   19     2   16   115 107                 222
1122344 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   grade_9 151 17 21 0   26     2   9   111 115                       226 151 17 21 0   26     2   9   111 115                 226
1365112 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2020   grade_9 138 20 25 1   36     0   8   108 120 *                     228.0 138 20 25 1   36     0   8   108 120                 228
1672336 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford - Bedford High   Regular School No High 09 12 2021   grade_9 116 16 29 0   30     1   15   107 100 *                     207.0 116 16 29 0   30     1   15   107 100                 207
2040138 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_9 160 18 16 0   39     0   9   117 125                       242.0 160 18 16 0   39     0   9   117 125                 242
2229150 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford: Bedford High   Regular School No High 09 12 2018   grade_9 121 11 17 0   20     0   11   94 86                       180.0 121 11 17 0   20     0   11   94 86                 180
736002 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_9 169 3 5 1   2     1   3   97 87                       184 169 3 5 1   2     1   3   97 87                 184
932876 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2016   grade_9 167 7 11 0   3     0   4   104 88                       192 167 7 11 0   3     0   4   104 88                 192
1122363 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2017   grade_9 165 0 9 0   3     0   2   91 88                       179 165 0 9 0   3     0   2   91 88                 179
1365126 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2020   grade_9 171 4 6 0   3     1   7   103 89 *                     192.0 171 4 6 0   3     1   7   103 89                 192
1672350 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown - Belchertown High   Regular School No High 09 12 2021   grade_9 154 4 10 0   2     1   3   69 104 *                     174.0 154 4 10 0   2     1   3   69 104                 174
2040152 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_9 155 1 1 0   2     1   5   78 87                       165.0 155 1 1 0   2     1   5   78 87                 165
2229169 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown: Belchertown High   Regular School No High 09 12 2018   grade_9 164 5 3 1   5     0   5   91 92                       183.0 164 5 3 1   5     0   5   91 92                 183
736026 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_9 108 4 5 1   2     0   1   64 57                       121 108 4 5 1   2     0   1   64 57                 121
736031 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_9 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
932895 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 08 12 2016   grade_9 127 1 3 0   4     0   1   76 60                       136 127 1 3 0   4     0   1   76 60                 136
932900 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_9 5 0 1 0   0     0   1   4 3                       7 5 0 1 0   0     0   1   4 3                 7
1122386 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2017   grade_9 123 2 14 1   6     0   3   68 81                       149 123 2 14 1   6     0   3   68 81                 149
1122391 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   grade_9 8 0 2 0   0     0   0   6 4                       10 8 0 2 0   0     0   0   6 4                 10
1365145 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2020   grade_9 109 8 4 0   4     0   1   59 67 *                     126.0 109 8 4 0   4     0   1   59 67                 126
1365150 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_9 6 0 2 0   0     0   0   4 3 *                     8.0 6 0 2 0   0     0   0   4 3                 8
1672368 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_9 122 3 15 0   8     0   6   88 66 *                     154.0 122 3 15 0   8     0   6   88 66                 154
1672372 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham - Keough Memorial Academy   Alternative School No High 08 12 2021   grade_9 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
2040171 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_9 126 4 3 0   3     0   5   65 76                       141.0 126 4 3 0   3     0   5   65 76                 141
2040176 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_9 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
2229192 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham: Bellingham High School   Regular School No High 08 12 2018   grade_9 137 5 5 0   6     0   5   90 68                       158.0 137 5 5 0   6     0   5   90 68                 158
2229198 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham: Keough Memorial Academy   Alternative School No High 08 12 2018   grade_9 * * * *   *     *   *   1 3                       4.0                         1 3                 4
736060 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2015   grade_9 244 16 9 0   53     2   17   172 169                       341 244 16 9 0   53     2   17   172 169                 341
932929 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2016   grade_9 211 17 9 0   52     0   11   138 162                       300 211 17 9 0   52     0   11   138 162                 300
1122425 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2017   grade_9 234 12 19 0   50     0   15   152 178                       330 234 12 19 0   50     0   15   152 178                 330
1365179 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2020   grade_9 210 13 11 0   66     0   18   159 159 *                     318.0 210 13 11 0   66     0   18   159 159                 318
1672401 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont - Belmont High   Regular School No High 09 12 2021   grade_9 225 14 19 1   52     0   23   169 165 *                     334.0 225 14 19 1   52     0   23   169 165                 334
2040205 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2019   grade_9 235 11 17 0   58     0   23   170 174                       344.0 235 11 17 0   58     0   23   170 174                 344
2229233 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont: Belmont High   Regular School No High 09 12 2018   grade_9 228 10 13 1   58     0   21   171 160                       331.0 228 10 13 1   58     0   21   171 160                 331
743443 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_9 43 7 4 0   2     1   0   22 35                       57 43 7 4 0   2     1   0   22 35                 57
940264 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2016   grade_9 40 12 7 0   2     0   3   31 33                       64 40 12 7 0   2     0   3   31 33                 64
1131144 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_9 33 8 3 0   2     0   1   24 23                       47 33 8 3 0   2     0   1   24 23                 47

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