enrollments

Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,459 ✖
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
736924 736924 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_8 4 97 27 1   9     0   2   74 66                       140 4 97 27 1   9     0   2   74 66                 140
1374254 1374254 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_8 2 97 10 1   0     0   0   60 50 *                     110.0 2 97 10 1   0     0   0   60 50                 110
2240000 2240000 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_8 3 97 8 0   0     0   0   55 53                       108.0 3 97 8 0   0     0   0   55 53                 108
934014 934014 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_8 29 96 32 0   7     0   10   90 84                       174 29 96 32 0   7     0   10   90 84                 174
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
2049327 2049327 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_8 1 95 10 0   0     0   2   49 59                       108.0 1 95 10 0   0     0   2   49 59                 108
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
2230511 2230511 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_8 47 94 56 0   3     1   20   95 126                       221.0 47 94 56 0   3     1   20   95 126                 221
2041307 2041307 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2019   grade_8 48 93 20 1   5     0   6   97 76                       173.0 48 93 20 1   5     0   6   97 76                 173
2041310 2041310 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2019   grade_8 51 93 72 1   7     0   9   113 120                       233.0 51 93 72 1   7     0   9   113 120                 233
933634 933634 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2016   grade_8 3 92 85 0   12     1   3   96 100                       196 3 92 85 0   12     1   3   96 100                 196
2230041 2230041 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston: Lilla G. Frederick Middle School   Regular School No Middle 06 08 2018   grade_8 3 91 87 0   18     0   3   107 95                       202.0 3 91 87 0   18     0   3   107 95                 202
743790 743790 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2015   grade_8 13 90 53 0   5     0   3   80 84                       164 13 90 53 0   5     0   3   80 84                 164
743819 743819 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_8 2 90 60 0   0     0   4   75 81                       156 2 90 60 0   0     0   4   75 81                 156
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
1679944 1679944 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_8 34 90 4 0   15     0   8   72 79 *                     151.0 34 90 4 0   15     0   8   72 79                 151
737485 737485 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_8 185 9 5 0   17     0   4   123 97                       220 185 9 5 0   17     0   4   123 97                 220
737821 737821 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No 2 06 08 2015   grade_8 261 9 26 0   17     0   6   172 147                       319 261 9 26 0   17     0   6   172 147                 319
738591 738591 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_8 109 9 17 0   2     1   0   64 74                       138 109 9 17 0   2     1   0   64 74                 138
739359 739359 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2015   grade_8 19 9 37 0   107     0   4   98 78                       176 19 9 37 0   107     0   4   98 78                 176
739619 739619 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_8 319 9 11 0   11     0   9   178 181                       359 319 9 11 0   11     0   9   178 181                 359
739955 739955 MA Worcester   school 2507860 185   Milford 250786002439 1850310 Milford Middle East   Regular School No 4 08 08 2015   grade_8 228 9 57 7   13     0   4   170 148                       318 228 9 57 7   13     0   4   170 148                 318
740405 740405 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No 2 06 08 2015   grade_8 198 9 22 1   41     0   14   149 136                       285 198 9 22 1   41     0   14   149 136                 285
740566 740566 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_8 375 9 13 2   19     0   10   214 214                       428 375 9 13 2   19     0   10   214 214                 428
741123 741123 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No 2 05 08 2015   grade_8 36 9 6 1   10     0   4   42 24                       66 36 9 6 1   10     0   4   42 24                 66
741255 741255 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No 2 06 08 2015   grade_8 55 9 83 0   17     0   4   82 86                       168 55 9 83 0   17     0   4   82 86                 168
741258 741258 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No 2 06 08 2015   grade_8 57 9 91 2   7     0   2   81 87                       168 57 9 91 2   7     0   2   81 87                 168
741635 741635 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2015   grade_8 31 9 13 0   7     0   0   34 26                       60 31 9 13 0   7     0   0   34 26                 60
743419 743419 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_8 15 9 71 0   6     0   1   52 50                       102 15 9 71 0   6     0   1   52 50                 102
743465 743465 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_8 83 9 14 2   10     0   3   55 66                       121 83 9 14 2   10     0   3   55 66                 121
743783 743783 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes 3 07 12 2015   grade_8 42 9 6 0   0     0   10   20 47                       67 42 9 6 0   0     0   10   20 47                 67
743916 743916 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2015   grade_8 29 9 17 0   2     0   2   31 28                       59 29 9 17 0   2     0   2   31 28                 59
933506 933506 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_8 1 9 15 1   0     0   0   18 8                       26 1 9 15 1   0     0   0   18 8                 26
935149 935149 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_8 109 9 71 0   18     1   10   115 103                       218 109 9 71 0   18     1   10   115 103                 218
935476 935476 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_8 130 9 90 0   5     0   1   113 122                       235 130 9 90 0   5     0   1   113 122                 235
936464 936464 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2016   grade_8 303 9 13 0   15     0   11   188 163                       351 303 9 13 0   15     0   11   188 163                 351
936520 936520 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_8 177 9 122 1   6     0   8   161 162                       323 177 9 122 1   6     0   8   161 162                 323
936800 936800 MA Worcester   school 2507860 185   Milford 250786002439 1850310 Milford Middle East   Regular School No 4 08 08 2016   grade_8 223 9 55 7   7     0   10   152 159                       311 223 9 55 7   7     0   10   152 159                 311
937945 937945 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2016   grade_8 63 9 2 0   16     1   4   49 46                       95 63 9 2 0   16     1   4   49 46                 95
938787 938787 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2016   grade_8 1 9 15 0   0     0   0   15 10                       25 1 9 15 0   0     0   0   15 10                 25
940283 940283 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2016   grade_8 95 9 16 0   13     0   0   63 70                       133 95 9 16 0   13     0   0   63 70                 133
940527 940527 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 08 2016   grade_8 2 9 21 0   2     0   1   15 20                       35 2 9 21 0   2     0   1   15 20                 35
940799 940799 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2016   grade_8 273 9 9 2   134     0   16   226 217                       443 273 9 9 2   134     0   16   226 217                 443
941601 941601 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2016   grade_8 299 9 1 0   5     1   2   160 157                       317 299 9 1 0   5     1   2   160 157                 317
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
1365222 1365222 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_8 239 9 54 0   9     0   9   175 145 *                     320.0 239 9 54 0   9     0   9   175 145                 320
1365612 1365612 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_8 0 9 21 0   3     0   0   19 14 *                     33.0 0 9 21 0   3     0   0   19 14                 33
1365653 1365653 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_8 10 9 8 0   0     0   1   15 13 *                     28.0 10 9 8 0   0     0   1   15 13                 28
1367053 1367053 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_8 37 9 43 2   6     1   3   54 47 *                     101.0 37 9 43 2   6     1   3   54 47                 101
1367707 1367707 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_8 101 9 100 1   4     0   1   119 97 *                     216.0 101 9 100 1   4     0   1   119 97                 216
1369472 1369472 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2020   grade_8 115 9 11 1   41     1   12   108 82 *                     190.0 115 9 11 1   41     1   12   108 82                 190
1370168 1370168 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_8 74 9 4 0   96     2   8   105 88 *                     193.0 74 9 4 0   96     2   8   105 88                 193
1370171 1370171 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2020   grade_8 82 9 14 2   17     0   4   78 50 *                     128.0 82 9 14 2   17     0   4   78 50                 128
1370183 1370183 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2020   grade_8 26 9 9 0   28     0   2   40 34 *                     74.0 26 9 9 0   28     0   2   40 34                 74
1370262 1370262 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No Middle 06 08 2020   grade_8 143 9 8 1   16     0   3   91 89 *                     180.0 143 9 8 1   16     0   3   91 89                 180
1371016 1371016 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2020   grade_8 11 9 65 0   4     0   2   50 41 *                     91.0 11 9 65 0   4     0   2   50 41                 91
1371033 1371033 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_8 8 9 34 1   0     0   0   20 32 *                     52.0 8 9 34 1   0     0   0   20 32                 52
1371226 1371226 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2020   grade_8 138 9 22 0   4     0   3   83 92 *                     176.0 138 9 22 0   4     0   3   83 92                 176
1371409 1371409 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2020   grade_8 205 9 23 2   7     0   7   128 125 *                     253.0 205 9 23 2   7     0   7   128 125                 253
1371449 1371449 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2020   grade_8 135 9 13 1   9     0   1   87 81 *                     168.0 135 9 13 1   9     0   1   87 81                 168
1371754 1371754 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield Middle School   Regular School No Middle 07 08 2020   grade_8 323 9 58 0   10     0   10   209 201 *                     410.0 323 9 58 0   10     0   10   209 201                 410
1371865 1371865 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2020   grade_8 195 9 59 0   20     0   8   143 148 *                     291.0 195 9 59 0   20     0   8   143 148                 291
1372455 1372455 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_8 19 9 142 1   3     1   2   95 82 *                     177.0 19 9 142 1   3     1   2   95 82                 177
1672250 1672250 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_8 100 9 41 0   9     0   5   94 70 *                     164.0 100 9 41 0   9     0   5   94 70                 164
1673354 1673354 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_8 168 9 10 0   54     0   1   115 127 *                     242.0 168 9 10 0   54     0   1   115 127                 242
1673554 1673554 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_8 44 9 8 0   8     0   4   27 46 *                     73.0 44 9 8 0   8     0   4   27 46                 73
1674493 1674493 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg - Memorial Middle School   Regular School No Middle 05 08 2021   grade_8 40 9 83 0   14     0   15   82 79 *                     161.0 40 9 83 0   14     0   15   82 79                 161
1675449 1675449 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_8 137 9 15 0   126     0   14   143 157 *                     301.0 137 9 15 0   126     0   14   143 157                 301
1675633 1675633 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_8 42 9 34 0   77     0   7   99 70 *                     169.0 42 9 34 0   77     0   7   99 70                 169
1675645 1675645 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell - James Sullivan Middle School   Regular School No Middle 05 08 2021   grade_8 52 9 69 0   25     0   11   75 91 *                     166.0 52 9 69 0   25     0   11   75 91                 166
1676122 1676122 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford - Madeleine Dugger Andrews   Regular School No Middle 06 08 2021   grade_8 97 9 10 1   11     0   11   80 59 *                     139.0 97 9 10 1   11     0   11   80 59                 139
1676715 1676715 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton - Charles E Brown Middle   Regular School No Middle 06 08 2021   grade_8 173 9 17 1   52     0   18   135 135 *                     270.0 173 9 17 1   52     0   18   135 135                 270
1676718 1676718 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton - F A Day Middle   Regular School No Middle 06 08 2021   grade_8 204 9 30 1   50     0   19   154 158 *                     313.0 204 9 30 1   50     0   19   154 158                 313
1677559 1677559 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere - Garfield Middle School   Regular School No Middle 06 08 2021   grade_8 68 9 118 0   8     0   3   99 107 *                     206.0 68 9 118 0   8     0   3   99 107                 206
1677956 1677956 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville - Winter Hill Community   Regular School No Elementary PK 08 2021   grade_8 5 9 34 0   1     0   0   22 27 *                     49.0 5 9 34 0   1     0   0   22 27                 49
1678286 1678286 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield - Chestnut Academy   Regular School No Middle 06 08 2021   grade_8 2 9 83 0   1     0   0   49 46 *                     95.0 2 9 83 0   1     0   0   49 46                 95
1678289 1678289 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Springfield - Impact Prep at Chestnut   Regular School No Middle 06 08 2021   grade_8 3 9 59 0   0     0   1   39 33 *                     72.0 3 9 59 0   0     0   1   39 33                 72
1678700 1678700 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Walpole - Bird Middle   Regular School No Middle 06 08 2021   grade_8 100 9 11 0   5     0   3   63 65 *                     128.0 100 9 11 0   5     0   3   63 65                 128
1679719 1679719 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_8 23 9 146 0   0     1   1   95 85 *                     180.0 23 9 146 0   0     1   1   95 85                 180
1680133 1680133 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District) - Salem Academy Charter School   Regular School Yes High 06 12 2021   grade_8 31 9 22 0   8     0   2   40 31 *                     72.0 31 9 22 0   8     0   2   40 31                 72
1680215 1680215 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District) - Global Learning Charter Public School   Regular School Yes High 05 12 2021   grade_8 36 9 41 1   1     0   2   42 48 *                     90.0 36 9 41 1   1     0   2   42 48                 90
1680584 1680584 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_8 180 9 11 1   3     0   3   99 108 *                     207.0 180 9 11 1   3     0   3   99 108                 207
2040299 2040299 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_8 181 9 10 0   12     1   4   107 110                       217.0 181 9 10 0   12     1   4   107 110                 217
2040349 2040349 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_8 2 9 16 0   1     0   0   12 16                       28.0 2 9 16 0   1     0   0   12 16                 28
2041353 2041353 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_8 42 9 10 0   9     0   12   45 37                       82.0 42 9 10 0   9     0   12   45 37                 82
2043291 2043291 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_8 149 9 10 0   137     0   23   160 168                       328.0 149 9 10 0   137     0   23   160 168                 328
2043469 2043469 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_8 39 9 41 0   31     0   6   63 63                       126.0 39 9 41 0   31     0   6   63 63                 126

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