enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
2040176 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
2229198 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 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 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 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 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 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 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 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
736115 736115 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2015   grade_9 297 8 30 0   5     0   11   170 181                       351 297 8 30 0   5     0   11   170 181                 351
932984 932984 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2016   grade_9 234 14 30 0   8     2   7   132 163                       295 234 14 30 0   8     2   7   132 163                 295
1122491 1122491 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2017   grade_9 235 5 53 0   9     0   8   161 149                       310 235 5 53 0   9     0   8   161 149                 310
1365223 1365223 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2020   grade_9 270 12 43 0   8     0   14   174 173 *                     347.0 270 12 43 0   8     0   14   174 173                 347
1672445 1672445 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly - Beverly High   Regular School No High 09 12 2021   grade_9 211 10 57 0   10     0   7   156 139 *                     295.0 211 10 57 0   10     0   7   156 139                 295
2040256 2040256 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2019   grade_9 283 14 42 0   8     0   12   198 161                       359.0 283 14 42 0   8     0   12   198 161                 359
2229299 2229299 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly: Beverly High   Regular School No High 09 12 2018   grade_9 244 10 44 0   10     0   11   167 152                       319.0 244 10 44 0   10     0   11   167 152                 319
736163 736163 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2015   grade_9 292 6 11 0   14     2   5   163 167                       330 292 6 11 0   14     2   5   163 167                 330
933032 933032 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2016   grade_9 254 3 11 1   15     1   9   145 149                       294 254 3 11 1   15     1   9   145 149                 294
1122547 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
1365261 1365261 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 08 12 2020   grade_9 227 12 22 0   23     1   8   132 161 *                     293.0 227 12 22 0   23     1   8   132 161                 293
1672483 1672483 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica - Billerica Memorial High School   Regular School No High 08 12 2021   grade_9 191 16 27 1   26     1   4   140 125 *                     266.0 191 16 27 1   26     1   4   140 125                 266
2040304 2040304 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   grade_9 242 20 9 1   26     0   6   159 145                       304.0 242 20 9 1   26     0   6   159 145                 304
2229355 2229355 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_9 220 14 11 0   23     0   4   141 131                       272.0 220 14 11 0   23     0   4   141 131                 272
736239 736239 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 3 07 12 2015   grade_9 * * * *   *     *   *   1 2                       3                         1 2                 3
933107 933107 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 4 06 12 2016   grade_9 1 1 1 0   3     0   0   3 3                       6 1 1 1 0   3     0   0   3 3                 6
1122639 1122639 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1672568 1672568 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston - Carter School   Regular School No High 07 12 2021   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
2040388 2040388 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_9 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2229453 2229453 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
736280 736280 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_9 3 46 12 1   1     0   3   39 27                       66 3 46 12 1   1     0   3   39 27                 66
933150 933150 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 11 2016   grade_9 0 32 11 0   0     0   1   24 20                       44 0 32 11 0   0     0   1   24 20                 44
1122688 1122688 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_9 1 34 8 0   0     0   5   24 24                       48 1 34 8 0   0     0   5   24 24                 48
1365388 1365388 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_9 1 60 37 1   1     1   4   53 52 *                     105.0 1 60 37 1   1     1   4   53 52                 105
1672612 1672612 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_9 1 61 24 0   0     1   3   46 44 *                     90.0 1 61 24 0   0     1   3   46 44                 90
2040431 2040431 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_9 2 51 24 0   2     1   2   41 41                       82.0 2 51 24 0   2     1   2   41 41                 82
2229501 2229501 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston: Dearborn   Regular School No High 06 12 2018   grade_9 1 45 14 0   0     0   4   32 32                       64.0 1 45 14 0   0     0   4   32 32                 64
736680 736680 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_9 3 27 11 0   1     0   1   32 11                       43 3 27 11 0   1     0   1   32 11                 43
933547 933547 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_9 5 19 14 0   0     0   0   29 9                       38 5 19 14 0   0     0   0   29 9                 38
1123140 1123140 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_9 4 31 25 0   1     0   1   41 21                       62 4 31 25 0   1     0   1   41 21                 62
1365783 1365783 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_9 3 24 26 1   1     0   1   41 15 *                     56.0 3 24 26 1   1     0   1   41 15                 56
1673020 1673020 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_9 1 10 13 0   0     0   2   21 5 *                     26.0 1 10 13 0   0     0   2   21 5                 26
2040826 2040826 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_9 1 25 25 0   2     0   3   44 12                       56.0 1 25 25 0   2     0   3   44 12                 56
2229944 2229944 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_9 2 39 23 0   2     0   1   49 18                       67.0 2 39 23 0   2     0   1   49 18                 67
736779 736779 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_9 7 49 11 0   2     0   2   43 28                       71 7 49 11 0   2     0   2   43 28                 71
933647 933647 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_9 8 32 22 1   7     0   1   46 25                       71 8 32 22 1   7     0   1   46 25                 71
1123253 1123253 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_9 7 36 17 0   4     0   3   34 33                       67 7 36 17 0   4     0   3   34 33                 67
1365885 1365885 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_9 12 31 22 0   8     0   1   42 32 *                     74.0 12 31 22 0   8     0   1   42 32                 74
1673122 1673122 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_9 6 33 18 0   5     0   5   41 26 *                     67.0 6 33 18 0   5     0   5   41 26                 67
2040929 2040929 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_9 10 19 21 1   5     0   7   33 30                       63.0 10 19 21 1   5     0   7   33 30                 63
2230058 2230058 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_9 8 31 15 1   2     0   1   32 26                       58.0 8 31 15 1   2     0   1   32 26                 58
736794 736794 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2015   grade_9 6 114 101 1   7     0   2   155 76                       231 6 114 101 1   7     0   2   155 76                 231
933661 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
1123270 1123270 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   grade_9 13 84 102 0   4     0   0   137 66                       203 13 84 102 0   4     0   0   137 66                 203
1365899 1365899 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2020   grade_9 9 36 65 1   1     0   2   66 48 *                     114.0 9 36 65 1   1     0   2   66 48                 114
1673135 1673135 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston - Brighton High   Regular School No High 09 12 2021   grade_9 3 19 30 0   3     0   2   29 28 *                     57.0 3 19 30 0   3     0   2   29 28                 57
2040943 2040943 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2019   grade_9 9 45 50 1   11     0   1   79 38                       117.0 9 45 50 1   11     0   1   79 38                 117
2230075 2230075 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston: Brighton High   Regular School No High 09 12 2018   grade_9 7 54 65 2   3     1   0   84 48                       132.0 7 54 65 2   3     1   0   84 48                 132
736799 736799 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2015   grade_9 1 56 111 0   5     0   2   94 81                       175 1 56 111 0   5     0   2   94 81                 175
933666 933666 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2016   grade_9 3 49 102 0   3     2   1   91 69                       160 3 49 102 0   3     2   1   91 69                 160
1123275 1123275 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2017   grade_9 1 61 91 0   2     1   2   86 72                       158 1 61 91 0   2     1   2   86 72                 158
1365904 1365904 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2020   grade_9 3 40 103 1   8     0   0   105 50 *                     155.0 3 40 103 1   8     0   0   105 50                 155
1673140 1673140 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston - Boston International High School   Regular School No High 09 12 2021   grade_9 1 37 78 0   5     0   1   80 42 *                     122.0 1 37 78 0   5     0   1   80 42                 122
2040948 2040948 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2019   grade_9 2 45 78 0   8     0   0   76 57                       133.0 2 45 78 0   8     0   0   76 57                 133
2230080 2230080 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston: Boston International High School   Regular School No High 09 12 2018   grade_9 3 43 79 0   8     1   1   90 45                       135.0 3 43 79 0   8     1   1   90 45                 135
736803 736803 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_9 13 115 110 1   33     0   5   168 109                       277 13 115 110 1   33     0   5   168 109                 277
933670 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
1123280 1123280 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2017   grade_9 15 72 142 1   26     0   3   164 95                       259 15 72 142 1   26     0   3   164 95                 259
1365908 1365908 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2020   grade_9 12 48 168 0   10     0   4   146 96 *                     242.0 12 48 168 0   10     0   4   146 96                 242
1673144 1673144 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston - Charlestown High   Regular School No High 09 12 2021   grade_9 4 22 82 1   6     0   3   61 57 *                     118.0 4 22 82 1   6     0   3   61 57                 118
2040952 2040952 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_9 12 54 175 0   7     0   4   128 124                       252.0 12 54 175 0   7     0   4   128 124                 252
2230085 2230085 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston: Charlestown High   Regular School No High 09 12 2018   grade_9 12 85 152 0   17     0   3   162 107                       269.0 12 85 152 0   17     0   3   162 107                 269
736808 736808 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2015   grade_9 3 4 1 0   0     0   0   5 3                       8 3 4 1 0   0     0   0   5 3                 8
933675 933675 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2016   grade_9 0 7 0 0   0     0   0   5 2                       7 0 7 0 0   0     0   0   5 2                 7
1123285 1123285 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 *                       *                         2                    
1365913 1365913 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2020   grade_9 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673149 1673149 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Boston - Community Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
2040957 2040957 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_9 0 7 4 0   0     0   0   6 5                       11.0 0 7 4 0   0     0   0   6 5                 11
2230090 2230090 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Boston: Community Academy   Regular School No High 09 12 2018   grade_9 0 10 4 0   0     0   0   8 6                       14.0 0 10 4 0   0     0   0   8 6                 14
736812 736812 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2015   grade_9 19 52 36 3   17     0   1   71 57                       128 19 52 36 3   17     0   1   71 57                 128
933679 933679 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2016   grade_9 15 47 46 0   13     1   3   83 42                       125 15 47 46 0   13     1   3   83 42                 125
1123290 1123290 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2017   grade_9 14 53 50 0   14     1   2   85 49                       134 14 53 50 0   14     1   2   85 49                 134
1365917 1365917 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2020   grade_9 9 30 47 0   16     1   1   67 37 *                     104.0 9 30 47 0   16     1   1   67 37                 104
1673154 1673154 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Boston - Excel High School   Regular School No High 09 12 2021   grade_9 9 22 54 0   14     0   3   58 44 *                     102.0 9 22 54 0   14     0   3   58 44                 102
2040961 2040961 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2019   grade_9 11 56 41 0   17     0   3   73 55                       128.0 11 56 41 0   17     0   3   73 55                 128
2230095 2230095 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Boston: Excel High School   Regular School No High 09 12 2018   grade_9 6 43 41 0   20     0   5   81 34                       115.0 6 43 41 0   20     0   5   81 34                 115
736817 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
933684 933684 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2016   grade_9 4 84 41 0   1     0   2   75 57                       132 4 84 41 0   1     0   2   75 57                 132
1123295 1123295 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2017   grade_9 2 65 31 0   1     0   1   53 47                       100 2 65 31 0   1     0   1   53 47                 100
1365921 1365921 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2020   grade_9 2 55 34 0   2     0   5   47 51 *                     98.0 2 55 34 0   2     0   5   47 51                 98
1673159 1673159 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   grade_9 3 44 31 0   1     0   2   50 31 *                     81.0 3 44 31 0   1     0   2   50 31                 81
2040965 2040965 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_9 5 44 32 0   1     0   1   50 33                       83.0 5 44 32 0   1     0   1   50 33                 83
2230100 2230100 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston: Jeremiah E Burke High   Regular School No High 09 12 2018   grade_9 0 69 29 0   0     1   3   66 36                       102.0 0 69 29 0   0     1   3   66 36                 102
736822 736822 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2015   grade_9 53 43 357 2   8     0   1   286 178                       464 53 43 357 2   8     0   1   286 178                 464
933688 933688 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_9 56 28 369 2   4     0   6   272 193                       465 56 28 369 2   4     0   6   272 193                 465
1123300 1123300 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_9 33 18 307 1   3     0   3   231 134                       365 33 18 307 1   3     0   3   231 134                 365
1365925 1365925 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2020   grade_9 21 12 227 1   2     0   0   170 93 *                     263.0 21 12 227 1   2     0   0   170 93                 263
1673164 1673164 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston - East Boston High   Regular School No High 09 12 2021   grade_9 23 14 166 0   1     0   3   113 94 *                     207.0 23 14 166 0   1     0   3   113 94                 207
2040969 2040969 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2019   grade_9 29 19 229 0   8     0   7   167 125                       292.0 29 19 229 0   8     0   7   167 125                 292
2230105 2230105 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_9 34 17 277 0   6     0   6   222 118                       340.0 34 17 277 0   6     0   6   222 118                 340
736827 736827 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No 3 09 12 2015   grade_9 4 75 106 1   4     0   2   106 86                       192 4 75 106 1   4     0   2   106 86                 192

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