enrollments

Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 490 ✖

grade ✖

  • grade_8 · 490 ✖
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
1123139 1123139 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_8 1 17 15 0   0     0   0   23 10                       33 1 17 15 0   0     0   0   23 10                 33
1125426 1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1125450 1125450 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_8 134 7 86 0   3     0   2   120 112                       232 134 7 86 0   3     0   2   120 112                 232
1125885 1125885 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_8 1 0 17 0   1     0   0   15 4                       19 1 0 17 0   1     0   0   15 4                 19
1124820 1124820 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_8 2 1 3 0   0     0   0   6 *                       6 2 1 3 0   0     0   0   6                   6
1123010 1123010 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_8 9 25 45 0   2     0   5   58 28                       86 9 25 45 0   2     0   5   58 28                 86
1123252 1123252 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_8 11 28 14 0   5     0   2   26 34                       60 11 28 14 0   5     0   2   26 34                 60
1125783 1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1124227 1124227 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_8 93 12 28 0   2     0   4   70 69                       139 93 12 28 0   2     0   4   70 69                 139
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125570 1125570 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_8 5 0 65 0   0     0   0   37 33                       70 5 0 65 0   0     0   0   37 33                 70
1126090 1126090 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_8 14 6 7 0   2     0   5   20 14                       34 14 6 7 0   2     0   5   20 14                 34
1131447 1131447 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   grade_8 37 0 2 0   1     0   0   19 21                       40 37 0 2 0   1     0   0   19 21                 40
1121975 1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1122006 1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1122033 1122033 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_8 142 4 11 1   2     0   10   91 79                       170 142 4 11 1   2     0   10   91 79                 170
1122238 1122238 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_8 136 6 12 0   5     0   4   81 82                       163 136 6 12 0   5     0   4   81 82                 163
1122243 1122243 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_8 91 8 21 0   9     2   12   82 61                       143 91 8 21 0   9     2   12   82 61                 143
1122248 1122248 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_8 87 10 31 0   11     0   8   72 75                       147 87 10 31 0   11     0   8   72 75                 147
1122423 1122423 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_8 226 10 12 1   55     0   21   159 166                       325 226 10 12 1   55     0   21   159 166                 325
1122440 1122440 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_8 93 1 1 0   1     0   3   44 55                       99 93 1 1 0   1     0   3   44 55                 99
1123477 1123477 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_8 162 4 7 1   5     0   12   104 87                       191 162 4 7 1   5     0   12   104 87                 191
1123669 1123669 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_8 2 3 3 0   0     0   0   6 2                       8 2 3 3 0   0     0   0   6 2                 8
1124063 1124063 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_8 153 6 6 0   21     0   4   103 87                       190 153 6 6 0   21     0   4   103 87                 190
1124068 1124068 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_8 184 5 8 0   22     0   5   116 108                       224 184 5 8 0   22     0   5   116 108                 224
1124102 1124102 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_8 7 9 91 0   2     0   1   66 44                       110 7 9 91 0   2     0   1   66 44                 110
1124107 1124107 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_8 8 5 104 0   3     0   2   66 56                       122 8 5 104 0   3     0   2   66 56                 122
1124112 1124112 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_8 7 13 124 0   3     0   0   75 72                       147 7 13 124 0   3     0   0   75 72                 147
1124539 1124539 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_8 93 3 8 0   3     0   4   52 59                       111 93 3 8 0   3     0   4   52 59                 111
1124883 1124883 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_8 56 14 82 0   7     0   16   73 102                       175 56 14 82 0   7     0   16   73 102                 175
1124895 1124895 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_8 28 8 61 0   3     0   11   62 49                       111 28 8 61 0   3     0   11   62 49                 111
1124951 1124951 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_8 174 5 5 0   7     0   2   98 95                       193 174 5 5 0   7     0   2   98 95                 193
1125339 1125339 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_8 214 2 5 0   5     0   0   116 110                       226 214 2 5 0   5     0   0   116 110                 226
1125414 1125414 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_8 80 2 50 0   2     0   0   65 69                       134 80 2 50 0   2     0   0   65 69                 134
1125441 1125441 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_8 92 2 33 0   1     0   1   74 55                       129 92 2 33 0   1     0   1   74 55                 129
1125788 1125788 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_8 2 1 143 0   0     0   0   73 73                       146 2 1 143 0   0     0   0   73 73                 146
1125809 1125809 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_8 2 2 119 0   4     0   2   62 67                       129 2 2 119 0   4     0   2   62 67                 129
1125814 1125814 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_8 11 0 113 0   1     0   1   70 56                       126 11 0 113 0   1     0   1   70 56                 126
1125871 1125871 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_8 14 2 94 0   7     0   1   63 55                       118 14 2 94 0   7     0   1   63 55                 118
1126268 1126268 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_8 52 8 37 0   40     0   0   63 74                       137 52 8 37 0   40     0   0   63 74                 137
1126273 1126273 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2017   grade_8 56 10 31 0   70     0   10   89 88                       177 56 10 31 0   70     0   10   89 88                 177
1126283 1126283 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2017   grade_8 28 15 73 0   35     0   5   84 72                       156 28 15 73 0   35     0   5   84 72                 156
1126288 1126288 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2017   grade_8 69 15 65 0   17     0   4   88 82                       170 69 15 65 0   17     0   4   88 82                 170
1126293 1126293 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2017   grade_8 61 8 70 0   29     0   4   95 77                       172 61 8 70 0   29     0   4   95 77                 172
1126298 1126298 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2017   grade_8 17 3 46 0   106     0   6   97 81                       178 17 3 46 0   106     0   6   97 81                 178
1126534 1126534 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2017   grade_8 170 1 7 0   7     0   5   89 101                       190 170 1 7 0   7     0   5   89 101                 190
1126678 1126678 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_8 152 7 146 0   5     0   8   167 151                       318 152 7 146 0   5     0   8   167 151                 318
1126861 1126861 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2017   grade_8 148 6 5 1   13     0   1   91 83                       174 148 6 5 1   13     0   1   91 83                 174
1127047 1127047 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_8 99 1 2 0   6     1   3   70 42                       112 99 1 2 0   6     1   3   70 42                 112
1127104 1127104 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_8 90 2 0 0   0     0   0   42 50                       92 90 2 0 0   0     0   0   42 50                 92
1127170 1127170 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2017   grade_8 140 4 4 0   8     0   12   86 82                       168 140 4 4 0   8     0   12   86 82                 168
1127175 1127175 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_8 169 7 27 0   13     1   17   109 125                       234 169 7 27 0   13     1   17   109 125                 234
1127769 1127769 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2017   grade_8 172 0 11 0   2     1   5   101 90                       191 172 0 11 0   2     1   5   101 90                 191
1128247 1128247 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 05 08 2017   grade_8 232 3 4 1   4     0   5   134 115                       249 232 3 4 1   4     0   5   134 115                 249
1128375 1128375 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No Middle 05 08 2017   grade_8 31 12 12 1   24     0   2   48 34                       82 31 12 12 1   24     0   2   48 34                 82
1128380 1128380 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2017   grade_8 41 8 2 0   27     0   2   46 34                       80 41 8 2 0   27     0   2   46 34                 80
1128587 1128587 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2017   grade_8 143 7 23 0   0     0   6   92 87                       179 143 7 23 0   0     0   6   92 87                 179
1129080 1129080 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2017   grade_8 111 4 15 0   1     0   6   73 64                       137 111 4 15 0   1     0   6   73 64                 137
1129467 1129467 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2017   grade_8 169 4 15 0   9     0   7   98 106                       204 169 4 15 0   9     0   7   98 106                 204
1129612 1129612 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2017   grade_8 161 8 21 0   1     0   6   98 99                       197 161 8 21 0   1     0   6   98 99                 197
1129835 1129835 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_8 262 10 14 1   4     1   2   149 145                       294 262 10 14 1   4     1   2   149 145                 294
1129981 1129981 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_8 137 8 13 4   2     0   18   96 86                       182 137 8 13 4   2     0   18   96 86                 182
1130066 1130066 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_8 92 9 23 0   2     1   7   69 65                       134 92 9 23 0   2     1   7   69 65                 134
1130464 1130464 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_8 334 29 27 1   24     0   16   214 217                       431 334 29 27 1   24     0   16   214 217                 431
1131113 1131113 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_8 14 9 139 1   1     0   1   89 76                       165 14 9 139 1   1     0   1   89 76                 165
1131128 1131128 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_8 4 53 20 0   1     0   1   40 39                       79 4 53 20 0   1     0   1   40 39                 79
1131245 1131245 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_8 77 4 6 0   10     0   3   51 49                       100 77 4 6 0   10     0   3   51 49                 100
1131367 1131367 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_8 35 28 17 1   2     0   1   38 46                       84 35 28 17 1   2     0   1   38 46                 84
1131549 1131549 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes Other 05 12 2017   grade_8 87 0 1 0   1     0   1   39 51                       90 87 0 1 0   1     0   1   39 51                 90
1131558 1131558 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_8 2 129 108 0   0     1   1   123 118                       241 2 129 108 0   0     1   1   123 118                 241
1131651 1131651 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes Other 05 12 2017   grade_8 33 9 30 0   1     0   4   37 40                       77 33 9 30 0   1     0   4   37 40                 77
1131674 1131674 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2017   grade_8 5 12 37 0   2     0   1   31 26                       57 5 12 37 0   2     0   1   31 26                 57
1131816 1131816 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_8 99 0 9 0   0     0   4   60 52                       112 99 0 9 0   0     0   4   60 52                 112
1131858 1131858 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_8 87 2 7 0   3     2   3   52 52                       104 87 2 7 0   3     2   3   52 52                 104
1131918 1131918 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2017   grade_8 167 5 5 0   6     0   6   90 99                       189 167 5 5 0   6     0   6   90 99                 189
1132024 1132024 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2017   grade_8 111 1 5 0   0     0   2   66 53                       119 111 1 5 0   0     0   2   66 53                 119
1132029 1132029 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2017   grade_8 123 2 6 0   0     0   5   77 59                       136 123 2 6 0   0     0   5   77 59                 136
1132065 1132065 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2017   grade_8 135 3 15 0   4     0   5   88 74                       162 135 3 15 0   4     0   5   88 74                 162
1132070 1132070 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_8 178 1 19 0   1     0   6   105 100                       205 178 1 19 0   1     0   6   105 100                 205
1132167 1132167 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2017   grade_8 186 3 4 0   15     0   1   113 96                       209 186 3 4 0   15     0   1   113 96                 209
1132251 1132251 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No Middle 05 08 2017   grade_8 58 3 3 0   0     0   1   37 28                       65 58 3 3 0   0     0   1   37 28                 65
1132338 1132338 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2017   grade_8 177 2 9 0   1     0   8   88 109                       197 177 2 9 0   1     0   8   88 109                 197
1132440 1132440 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_8 91 2 7 0   1     0   5   54 52                       106 91 2 7 0   1     0   5   54 52                 106
1132518 1132518 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_8 106 1 5 0   1     1   7   59 62                       121 106 1 5 0   1     1   7   59 62                 121
1132529 1132529 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2017   grade_8 135 1 3 1   2     0   7   77 72                       149 135 1 3 1   2     0   7   77 72                 149
1132762 1132762 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_8 94 1 8 1   0     0   3   51 56                       107 94 1 8 1   0     0   3   51 56                 107
1132903 1132903 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_8 85 1 4 0   1     0   0   56 35                       91 85 1 4 0   1     0   0   56 35                 91
1122109 1122109 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_8 147 2 9 0   26     0   5   86 103                       189 147 2 9 0   26     0   5   86 103                 189
1122113 1122113 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2017   grade_8 138 2 6 0   29     0   3   86 92                       178 138 2 6 0   29     0   3   86 92                 178
1122117 1122117 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_8 99 7 7 0   40     0   3   66 90                       156 99 7 7 0   40     0   3   66 90                 156
1122177 1122177 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_8 302 14 22 0   28     0   12   179 199                       378 302 14 22 0   28     0   12   179 199                 378
1122196 1122196 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_8 144 4 27 0   19     0   8   97 105                       202 144 4 27 0   19     0   8   97 105                 202
1122273 1122273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_8 181 4 5 1   12     0   5   97 111                       208 181 4 5 1   12     0   5   97 111                 208
1122341 1122341 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2017   grade_8 114 6 13 0   18     0   7   81 77                       158 114 6 13 0   18     0   7   81 77                 158
1122489 1122489 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No Middle 06 08 2017   grade_8 262 10 37 0   10     0   9   170 158                       328 262 10 37 0   10     0   9   170 158                 328
1122540 1122540 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2017   grade_8 177 5 8 0   11     0   3   106 98                       204 177 5 8 0   11     0   3   106 98                 204
1122544 1122544 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2017   grade_8 163 4 6 0   14     0   3   98 92                       190 163 4 6 0   14     0   3   98 92                 190
1122687 1122687 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_8 1 33 17 0   0     0   2   28 25                       53 1 33 17 0   0     0   2   28 25                 53
1122847 1122847 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2017   grade_8 9 54 90 0   11     0   1   83 82                       165 9 54 90 0   11     0   1   83 82                 165
1123237 1123237 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2017   grade_8 4 103 80 0   13     1   3   108 96                       204 4 103 80 0   13     1   3   108 96                 204

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);