enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1128423 1128423 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2017   grade_8 28 95 34 0   39     0   9   114 91                       205 28 95 34 0   39     0   9   114 91                 205
1123685 1123685 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_8 44 94 21 0   8     0   9   100 76                       176 44 94 21 0   8     0   9   100 76                 176
1129701 1129701 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_8 435 90 90 1   5     0   23   319 325                       644 435 90 90 1   5     0   23   319 325                 644
1123021 1123021 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2017   grade_8 5 9 23 0   0     0   0   20 17                       37 5 9 23 0   0     0   0   20 17                 37
1123093 1123093 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_8 1 9 24 0   0     0   0   16 18                       34 1 9 24 0   0     0   0   16 18                 34
1123123 1123123 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_8 11 9 9 1   2     0   0   19 13                       32 11 9 9 1   2     0   0   19 13                 32
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
1127013 1127013 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_8 205 9 76 6   6     0   11   168 145                       313 205 9 76 6   6     0   11   168 145                 313
1127718 1127718 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2017   grade_8 308 9 12 0   19     0   11   189 170                       359 308 9 12 0   19     0   11   189 170                 359
1128789 1128789 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No Middle 07 08 2017   grade_8 243 9 2 0   3     0   3   127 133                       260 243 9 2 0   3     0   3   127 133                 260
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
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
1131167 1131167 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   grade_8 80 9 22 1   8     0   7   70 57                       127 80 9 22 1   8     0   7   70 57                 127
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
1132284 1132284 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2017   grade_8 349 9 7 0   6     0   5   190 186                       376 349 9 7 0   6     0   5   190 186                 376
1132370 1132370 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_8 109 9 5 1   0     0   6   58 72                       130 109 9 5 1   0     0   6   58 72                 130
1132538 1132538 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2017   grade_8 222 9 1 0   3     0   10   115 130                       245 222 9 1 0   3     0   10   115 130                 245
1123415 1123415 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_8 3 89 37 1   3     0   4   65 72                       137 3 89 37 1   3     0   4   65 72                 137
1133180 1133180 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_8 2 88 8 0   4     0   2   51 53                       104 2 88 8 0   4     0   2   51 53                 104
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
1124191 1124191 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_8 161 8 78 2   9     0   7   129 136                       265 161 8 78 2   9     0   7   129 136                 265
1124195 1124195 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2017   grade_8 150 8 93 1   7     1   9   143 126                       269 150 8 93 1   7     1   9   143 126                 269
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
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
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
1128043 1128043 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2017   grade_8 353 8 52 0   6     0   10   224 205                       429 353 8 52 0   6     0   10   224 205                 429
1128366 1128366 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2017   grade_8 90 8 5 1   22     0   6   69 63                       132 90 8 5 1   22     0   6   69 63                 132
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
1128497 1128497 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2017   grade_8 89 8 84 4   12     0   3   113 87                       200 89 8 84 4   12     0   3   113 87                 200
1129217 1129217 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_8 8 8 8 0   1     0   1   13 13                       26 8 8 8 0   1     0   1   13 13                 26
1129383 1129383 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2017   grade_8 10 8 50 0   2     0   2   27 45                       72 10 8 50 0   2     0   2   27 45                 72
1129561 1129561 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2017   grade_8 294 8 14 0   18     0   5   167 172                       339 294 8 14 0   18     0   5   167 172                 339
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
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
1130259 1130259 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No Middle 06 08 2017   grade_8 161 8 20 0   6     0   2   105 92                       197 161 8 20 0   6     0   2   105 92                 197
1130446 1130446 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2017   grade_8 221 8 10 0   19     0   2   118 142                       260 221 8 10 0   19     0   2   118 142                 260
1130724 1130724 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_8 122 8 13 0   8     0   3   75 79                       154 122 8 13 0   8     0   3   75 79                 154
1131759 1131759 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_8 86 8 0 0   2     0   0   55 41                       96 86 8 0 0   2     0   0   55 41                 96
1133204 1133204 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_8 85 8 20 1   6     0   10   60 70                       130 85 8 20 1   6     0   10   60 70                 130
1123697 1123697 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_8 65 79 48 2   7     0   10   108 103                       211 65 79 48 2   7     0   10   108 103                 211
1131039 1131039 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_8 72 79 171 0   29     0   21   196 176                       372 72 79 171 0   29     0   21   196 176                 372
1123693 1123693 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2017   grade_8 63 72 11 0   1     1   7   77 78                       155 63 72 11 0   1     1   7   77 78                 155
1129514 1129514 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2017   grade_8 180 70 25 0   15     0   9   146 153                       299 180 70 25 0   15     0   9   146 153                 299
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
1122732 1122732 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_8 7 7 11 0   2     0   0   17 10                       27 7 7 11 0   2     0   0   17 10                 27
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
1126084 1126084 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_8 46 7 6 0   8     0   5   28 44                       72 46 7 6 0   8     0   5   28 44                 72
1126183 1126183 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2017   grade_8 29 7 7 0   8     0   2   21 32                       53 29 7 7 0   8     0   2   21 32                 53
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
1126737 1126737 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_8 120 7 6 9   3     0   3   68 80                       148 120 7 6 9   3     0   3   68 80                 148
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
1127220 1127220 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2017   grade_8 353 7 19 0   35     0   17   216 215                       431 353 7 19 0   35     0   17   216 215                 431
1128473 1128473 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No Middle 06 08 2017   grade_8 174 7 5 2   7     0   1   107 89                       196 174 7 5 2   7     0   1   107 89                 196
1128531 1128531 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2017   grade_8 57 7 101 2   14     0   4   82 103                       185 57 7 101 2   14     0   4   82 103                 185
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
1128740 1128740 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2017   grade_8 168 7 32 1   8     1   3   121 99                       220 168 7 32 1   8     1   3   121 99                 220
1129887 1129887 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2017   grade_8 115 7 5 0   13     0   3   68 75                       143 115 7 5 0   13     0   3   68 75                 143
1130398 1130398 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2017   grade_8 218 7 63 0   20     0   2   153 157                       310 218 7 63 0   20     0   2   153 157                 310
1132667 1132667 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2017   grade_8 87 7 14 0   2     0   9   59 60                       119 87 7 14 0   2     0   9   59 60                 119
1123211 1123211 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_8 2 65 20 2   1     0   0   50 40                       90 2 65 20 2   1     0   0   50 40                 90
1131043 1131043 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_8 110 62 175 1   41     0   13   217 185                       402 110 62 175 1   41     0   13   217 185                 402
1131525 1131525 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2017   grade_8 10 62 44 0   5     0   0   62 59                       121 10 62 44 0   5     0   0   62 59                 121
1131035 1131035 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2017   grade_8 228 61 154 1   33     0   28   260 245                       505 228 61 154 1   33     0   28   260 245                 505
1121958 1121958 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_8 151 6 11 0   1     0   0   91 78                       169 151 6 11 0   1     0   0   91 78                 169
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
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
1122361 1122361 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2017   grade_8 189 6 4 0   4     0   4   108 99                       207 189 6 4 0   4     0   4   108 99                 207
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
1124906 1124906 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2017   grade_8 23 6 34 0   3     0   9   27 48                       75 23 6 34 0   3     0   9   27 48                 75
1125030 1125030 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   grade_8 139 6 57 0   20     0   6   105 123                       228 139 6 57 0   20     0   6   105 123                 228
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
1126126 1126126 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2017   grade_8 81 6 5 0   12     0   5   58 51                       109 81 6 5 0   12     0   5   58 51                 109
1126639 1126639 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2017   grade_8 222 6 16 0   5     0   8   121 136                       257 222 6 16 0   5     0   8   121 136                 257
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
1126980 1126980 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_8 246 6 10 2   2     0   6   142 130                       272 246 6 10 2   2     0   6   142 130                 272
1128251 1128251 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2017   grade_8 297 6 13 0   5     0   23   172 172                       344 297 6 13 0   5     0   23   172 172                 344
1128362 1128362 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2017   grade_8 68 6 2 2   82     0   2   75 87                       162 68 6 2 2   82     0   2   75 87                 162
1128370 1128370 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_8 112 6 6 0   90     1   6   117 104                       221 112 6 6 0   90     1   6   117 104                 221
1128963 1128963 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2017   grade_8 39 6 10 0   0     0   0   30 25                       55 39 6 10 0   0     0   0   30 25                 55
1129006 1129006 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_8 12 6 29 0   5     0   0   28 24                       52 12 6 29 0   5     0   0   28 24                 52
1129371 1129371 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2017   grade_8 2 6 20 0   0     0   0   21 7                       28 2 6 20 0   0     0   0   21 7                 28
1129375 1129375 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_8 4 6 89 1   1     0   0   63 38                       101 4 6 89 1   1     0   0   63 38                 101
1130565 1130565 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_8 257 6 10 0   14     0   9   142 154                       296 257 6 10 0   14     0   9   142 154                 296
1131517 1131517 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2017   grade_8 45 6 12 0   1     0   4   23 45                       68 45 6 12 0   1     0   4   23 45                 68
1131564 1131564 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes Other 06 12 2017   grade_8 30 6 29 0   6     0   1   32 40                       72 30 6 29 0   6     0   1   32 40                 72
1131841 1131841 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_8 91 6 12 2   5     0   13   62 67                       129 91 6 12 2   5     0   13   62 67                 129
1132079 1132079 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   grade_8 167 6 11 2   4     0   3   89 104                       193 167 6 11 2   4     0   3   89 104                 193
1133190 1133190 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_8 51 6 10 0   1     0   2   28 42                       70 51 6 10 0   1     0   2   28 42                 70
1123622 1123622 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_8 23 57 15 0   0     1   3   49 50                       99 23 57 15 0   0     1   3   49 50                 99
1131208 1131208 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_8 7 57 35 1   2     0   3   49 56                       105 7 57 35 1   2     0   3   49 56                 105
1131588 1131588 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_8 8 57 24 0   11     0   0   52 48                       100 8 57 24 0   11     0   0   52 48                 100
1127086 1127086 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2017   grade_8 201 56 14 1   15     1   11   157 142                       299 201 56 14 1   15     1   11   157 142                 299
1131171 1131171 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2017   grade_8 0 56 14 0   0     2   0   43 29                       72 0 56 14 0   0     2   0   43 29                 72
1131032 1131032 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_8 73 55 116 1   11     0   12   129 139                       268 73 55 116 1   11     0   12   129 139                 268
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
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
1123336 1123336 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_8 87 51 60 1   64     0   6   113 156                       269 87 51 60 1   64     0   6   113 156                 269
1131334 1131334 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_8 23 50 32 1   7     0   2   51 64                       115 23 50 32 1   7     0   2   51 64                 115
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
1122713 1122713 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_8 8 5 78 0   0     0   1   54 38                       92 8 5 78 0   0     0   1   54 38                 92

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