enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 390 ✖

grade ✖

  • grade_8 · 390 ✖
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
1132714 1132714 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_8 43 1 3 0   0     0   5   28 24                       52 43 1 3 0   0     0   5   28 24                 52
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
1132810 1132810 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No Middle 07 08 2017   grade_8 185 1 6 2   4     0   3   107 94                       201 185 1 6 2   4     0   3   107 94                 201
1132886 1132886 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2017   grade_8 46 1 2 0   0     0   1   25 25                       50 46 1 2 0   0     0   1   25 25                 50
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
1132929 1132929 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2017   grade_8 122 1 6 0   0     0   2   63 68                       131 122 1 6 0   0     0   2   63 68                 131
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
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
1122598 1122598 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_8 5 10 16 0   2     0   2   17 18                       35 5 10 16 0   2     0   2   17 18                 35
1122947 1122947 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_8 0 10 37 0   0     0   0   26 21                       47 0 10 37 0   0     0   0   26 21                 47
1123796 1123796 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_8 40 10 11 0   11     0   8   38 42                       80 40 10 11 0   11     0   8   38 42                 80
1124643 1124643 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_8 29 10 31 0   5     0   2   44 33                       77 29 10 31 0   5     0   2   44 33                 77
1124796 1124796 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2017   grade_8 103 10 59 0   12     0   6   88 102                       190 103 10 59 0   12     0   6   88 102                 190
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
1127531 1127531 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_8 166 10 14 1   51     0   10   142 110                       252 166 10 14 1   51     0   10   142 110                 252
1127627 1127627 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_8 152 10 32 0   5     0   9   92 116                       208 152 10 32 0   5     0   9   92 116                 208
1128672 1128672 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2017   grade_8 98 10 67 0   4     0   5   101 83                       184 98 10 67 0   4     0   5   101 83                 184
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
1129883 1129883 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2017   grade_8 136 10 11 1   2     0   2   82 80                       162 136 10 11 1   2     0   2   82 80                 162
1130019 1130019 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2017   grade_8 140 10 34 2   20     0   6   104 108                       212 140 10 34 2   20     0   6   104 108                 212
1131735 1131735 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   grade_8 257 10 12 1   139     0   23   240 202                       442 257 10 12 1   139     0   23   240 202                 442
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
1123689 1123689 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2017   grade_8 54 109 28 1   5     2   9   106 102                       208 54 109 28 1   5     2   9   106 102                 208
1123847 1123847 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2017   grade_8 216 11 9 1   30     0   10   146 130                       277 216 11 9 1   30     0   10   146 130                 277
1124277 1124277 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_8 184 11 12 0   14     0   6   118 109                       227 184 11 12 0   14     0   6   118 109                 227
1124804 1124804 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_8 154 11 43 0   8     0   11   119 108                       227 154 11 43 0   8     0   11   119 108                 227
1126491 1126491 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2017   grade_8 89 11 77 1   21     0   8   117 90                       207 89 11 77 1   21     0   8   117 90                 207
1126569 1126569 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2017   grade_8 24 11 16 0   5     0   0   30 26                       56 24 11 16 0   5     0   0   30 26                 56
1126829 1126829 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2017   grade_8 125 11 7 0   10     1   4   79 79                       158 125 11 7 0   10     1   4   79 79                 158
1127672 1127672 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2017   grade_8 329 11 37 1   32     0   6   218 198                       416 329 11 37 1   32     0   6   218 198                 416
1129379 1129379 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_8 1 11 89 0   0     0   0   54 47                       101 1 11 89 0   0     0   0   54 47                 101
1129731 1129731 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2017   grade_8 272 11 6 0   10     0   6   147 158                       305 272 11 6 0   10     0   6   147 158                 305
1130336 1130336 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2017   grade_8 122 11 9 0   25     0   14   88 93                       181 122 11 9 0   25     0   14   88 93                 181
1131489 1131489 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_8 57 11 4 0   23     0   2   50 47                       97 57 11 4 0   23     0   2   50 47                 97
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
1124860 1124860 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_8 228 12 5 4   10     0   19   134 144                       278 228 12 5 4   10     0   19   134 144                 278
1125506 1125506 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No High 07 12 2017   grade_8 57 12 13 0   5     0   2   50 39                       89 57 12 13 0   5     0   2   50 39                 89
1126549 1126549 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_8 30 12 13 0   24     1   4   43 41                       84 30 12 13 0   24     1   4   43 41                 84
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
1128880 1128880 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2017   grade_8 297 12 31 2   131     0   19   253 239                       492 297 12 31 2   131     0   19   253 239                 492
1129367 1129367 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2017   grade_8 2 12 63 0   1     0   0   44 34                       78 2 12 63 0   1     0   0   44 34                 78
1130049 1130049 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2017   grade_8 160 12 9 0   34     0   17   108 124                       232 160 12 9 0   34     0   17   108 124                 232
1130125 1130125 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_8 303 12 16 0   50     0   22   206 197                       403 303 12 16 0   50     0   22   206 197                 403
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
1131921 1131921 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2017   grade_8 228 12 3 0   2     0   9   122 132                       254 228 12 3 0   2     0   9   122 132                 254
1123681 1123681 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 06 08 2017   grade_8 14 123 26 0   4     1   5   89 84                       173 14 123 26 0   4     1   5   89 84                 173
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
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
1126058 1126058 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_8 133 13 10 1   99     0   15   129 142                       271 133 13 10 1   99     0   15   129 142                 271
1126579 1126579 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_8 39 13 15 0   19     0   3   45 44                       89 39 13 15 0   19     0   3   45 44                 89
1127539 1127539 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2017   grade_8 127 13 14 0   51     0   12   96 121                       217 127 13 14 0   51     0   12   96 121                 217
1128844 1128844 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2017   grade_8 161 13 11 0   83     1   10   152 127                       279 161 13 11 0   83     1   10   152 127                 279
1123677 1123677 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2017   grade_8 24 139 29 0   0     1   9   113 89                       202 24 139 29 0   0     1   9   113 89                 202
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
1124394 1124394 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2017   grade_8 161 14 26 0   5     0   9   110 105                       215 161 14 26 0   5     0   9   110 105                 215
1124653 1124653 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_8 34 14 39 0   11     0   3   53 48                       101 34 14 39 0   11     0   3   53 48                 101
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
1125982 1125982 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2017   grade_8 92 14 45 0   4     0   2   78 79                       157 92 14 45 0   4     0   2   78 79                 157
1131143 1131143 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_8 50 14 2 0   0     0   1   35 31                       67 50 14 2 0   0     0   1   35 31                 67
1123192 1123192 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_8 0 15 10 0   1     0   3   16 13                       29 0 15 10 0   1     0   3   16 13                 29
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
1126610 1126610 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2017   grade_8 313 15 14 0   21     0   13   191 185                       376 313 15 14 0   21     0   13   191 185                 376
1127130 1127130 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2017   grade_8 65 15 19 0   2     1   3   56 49                       105 65 15 19 0   2     1   3   56 49                 105
1127527 1127527 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_8 96 15 12 2   27     1   10   77 86                       163 96 15 12 2   27     1   10   77 86                 163
1131602 1131602 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_8 42 15 1 2   4     0   2   29 37                       66 42 15 1 2   4     0   2   29 37                 66
1122803 1122803 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_8 0 16 36 0   0     1   0   31 22                       53 0 16 36 0   0     1   0   31 22                 53
1123369 1123369 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_8 2 16 15 0   39     1   2   46 29                       75 2 16 15 0   39     1   2   46 29                 75
1123547 1123547 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2017   grade_8 184 16 11 0   37     0   3   132 119                       251 184 16 11 0   37     0   3   132 119                 251
1124800 1124800 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2017   grade_8 125 16 40 0   8     1   14   113 91                       204 125 16 40 0   8     1   14   113 91                 204
1126907 1126907 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2017   grade_8 225 16 6 0   11     0   8   127 139                       266 225 16 6 0   11     0   8   127 139                 266
1131288 1131288 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_8 1 16 4 0   0     0   1   11 11                       22 1 16 4 0   0     0   1   11 11                 22
1131578 1131578 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2017   grade_8 6 16 27 0   1     0   1   26 25                       51 6 16 27 0   1     0   1   26 25                 51
1131766 1131766 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2017   grade_8 121 16 41 0   16     1   23   100 118                       218 121 16 41 0   16     1   23   100 118                 218
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
1123201 1123201 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_8 1 17 8 0   1     0   2   16 13                       29 1 17 8 0   1     0   2   16 13                 29
1123260 1123260 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2017   grade_8 15 17 85 0   10     0   1   70 58                       128 15 17 85 0   10     0   1   70 58                 128
1124589 1124589 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2017   grade_8 248 17 13 0   10     0   5   135 158                       293 248 17 13 0   10     0   5   135 158                 293
1125022 1125022 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_8 120 17 40 0   2     0   7   97 89                       186 120 17 40 0   2     0   7   97 89                 186
1125026 1125026 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2017   grade_8 81 17 60 0   5     0   5   88 80                       168 81 17 60 0   5     0   5   88 80                 168
1129946 1129946 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2017   grade_8 84 17 73 0   5     0   11   108 82                       190 84 17 73 0   5     0   11   108 82                 190
1130720 1130720 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_8 133 17 13 0   5     0   1   88 81                       169 133 17 13 0   5     0   1   88 81                 169
1131273 1131273 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_8 1 17 5 0   0     0   0   8 15                       23 1 17 5 0   0     0   0   8 15                 23
1133165 1133165 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_8 65 17 16 0   1     0   4   57 46                       103 65 17 16 0   1     0   4   57 46                 103
1122630 1122630 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_8 0 18 67 0   0     0   0   40 45                       85 0 18 67 0   0     0   0   40 45                 85
1123181 1123181 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2017   grade_8 8 18 46 1   12     0   2   53 34                       87 8 18 46 1   12     0   2   53 34                 87
1131642 1131642 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2017   grade_8 14 18 29 3   5     1   1   33 38                       71 14 18 29 3   5     1   1   33 38                 71
1133119 1133119 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_8 3 18 57 0   1     0   1   36 44                       80 3 18 57 0   1     0   1   36 44                 80
1123162 1123162 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_8 1 19 6 0   0     0   0   9 17                       26 1 19 6 0   0     0   0   9 17                 26
1127378 1127378 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_8 188 19 104 4   2     2   10   181 148                       329 188 19 104 4   2     2   10   181 148                 329
1129942 1129942 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_8 95 19 52 0   9     0   2   91 86                       177 95 19 52 0   9     0   2   91 86                 177
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
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
1123455 1123455 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_8 0 2 5 0   0     0   0   5 2                       7 0 2 5 0   0     0   0   5 2                 7
1123766 1123766 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2017   grade_8 38 2 4 0   11     0   2   25 31                       57 38 2 4 0   11     0   2   25 31                 57
1123807 1123807 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2017   grade_8 34 2 6 0   12     0   6   30 30                       60 34 2 6 0   12     0   6   30 30                 60
1123872 1123872 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_8 10 2 13 0   0     0   2   8 19                       27 10 2 13 0   0     0   2   8 19                 27
1124421 1124421 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_8 121 2 3 0   2     1   3   64 68                       132 121 2 3 0   2     1   3   64 68                 132

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