enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
939287 939287 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_8 * * * *   *     *   *   * *                       1                                             1
1125194 1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1368465 1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1374315 1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1674758 1674758 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1675706 1675706 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
2230211 2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2231645 2231645 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2232023 2232023 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_8 * * * *   *     *   *   * *                       1.0                                             1
2237229 2237229 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
739535 739535 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_8 * * * *   *     *   *   1 1                       2                         1 1                 2
932899 932899 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_8 * * * *   *     *   *   1 2                       3                         1 2                 3
936380 936380 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 08 12 2016   grade_8 * * * *   *     *   *   1 3                       4                         1 3                 4
936799 936799 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_8 * * * *   *     *   *   1 1                       2                         1 1                 2
937587 937587 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_8 * * * *   *     *   *   1 *                       1                         1                   1
939786 939786 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_8 * * * *   *     *   *   1 3                       4                         1 3                 4
1122006 1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1123449 1123449 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_8 * * * *   *     *   *   1 2                       *                         1 2                  
1365149 1365149 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_8 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1365345 1365345 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter School   Regular School No High 07 12 2020   grade_8 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1367298 1367298 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_8 7 0 0 0   0     0   0   1 6 *                     7.0 7 0 0 0   0     0   0   1 6                 7
1368389 1368389 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No High 08 12 2020   grade_8 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1373190 1373190 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_8 * * * *   *     *   *   1 * *                     2.0                         1                   2
1680452 1680452 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_8 * * * *   *     *   *   1 * *                     1.0                         1                   1
2040175 2040175 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_8 6 0 0 0   0     0   0   1 4                       6.0 6 0 0 0   0     0   0   1 4                 6
2045508 2045508 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2019   grade_8 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2045829 2045829 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 08 12 2019   grade_8 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2234771 2234771 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_8 * * * *   *     *   *   1 *                       1.0                         1                   1
738120 738120 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_8 9 0 2 0   0     1   1   10 *                       13 9 0 2 0   0     1   1   10                   13
740287 740287 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_8 7 4 6 0   0     0   0   10 7                       17 7 4 6 0   0     0   0   10 7                 17
743722 743722 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_8 14 2 1 0   1     0   0   10 8                       18 14 2 1 0   1     0   0   10 8                 18
743908 743908 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter(District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 10 2015   grade_8 11 2 0 0   5     0   2   10 10                       20 11 2 0 0   5     0   2   10 10                 20
933311 933311 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2016   grade_8 1 0 16 0   0     0   0   10 7                       17 1 0 16 0   0     0   0   10 7                 17
933594 933594 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   grade_8 1 13 7 0   0     0   2   10 13                       23 1 13 7 0   0     0   2   10 13                 23
1122569 1122569 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_8 11 1 3 0   1     0   1   10 7                       17 11 1 3 0   1     0   1   10 7                 17
1126504 1126504 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_8 11 0 6 0   0     0   0   10 7                       17 11 0 6 0   0     0   0   10 7                 17
1365306 1365306 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_8 0 8 14 0   0     0   1   10 13 *                     23.0 0 8 14 0   0     0   1   10 13                 23
1365867 1365867 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_8 0 3 9 0   0     0   2   10 4 *                     14.0 0 3 9 0   0     0   2   10 4                 14
1369350 1369350 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2020   grade_8 3 6 5 0   0     0   0   10 4 *                     14.0 3 6 5 0   0     0   0   10 4                 14
1371013 1371013 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2020   grade_8 2 2 10 0   0     0   0   10 4 *                     14.0 2 2 10 0   0     0   0   10 4                 14
1372505 1372505 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_8 0 15 6 0   0     0   1   10 12 *                     22.0 0 15 6 0   0     0   1   10 12                 22
1372608 1372608 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_8 0 15 4 0   0     0   0   10 9 *                     19.0 0 15 4 0   0     0   0   10 9                 19
1372632 1372632 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2020   grade_8 2 0 30 0   0     0   0   10 22 *                     32.0 2 0 30 0   0     0   0   10 22                 32
1673104 1673104 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_8 3 2 12 0   0     0   1   10 8 *                     18.0 3 2 12 0   0     0   1   10 8                 18
1678142 1678142 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield - Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2021   grade_8 7 2 17 0   0     0   1   10 17 *                     27.0 7 2 17 0   0     0   1   10 17                 27
1680006 1680006 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District) - Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 20 2 9 0   1     0   0   10 22 *                     32.0 20 2 9 0   1     0   0   10 22                 32
1680114 1680114 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District) - River Valley Charter School   Regular School Yes Elementary KG 08 2021   grade_8 27 0 0 0   1     0   3   10 21 *                     31.0 27 0 0 0   1     0   3   10 21                 31
2041466 2041466 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_8 14 2 13 0   0     0   7   10 26                       36.0 14 2 13 0   0     0   7   10 26                 36
2046108 2046108 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_8 5 15 36 0   0     0   1   10 47                       57.0 5 15 36 0   0     0   1   10 47                 57
2047680 2047680 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_8 0 17 1 0   0     0   0   10 8                       18.0 0 17 1 0   0     0   0   10 8                 18
2047850 2047850 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_8 12 2 3 0   0     0   2   10 9                       19.0 12 2 3 0   0     0   2   10 9                 19
2233324 2233324 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_8 3 0 9 0   0     0   1   10 3                       13.0 3 0 9 0   0     0   1   10 3                 13
2238104 2238104 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_8 0 15 4 0   0     0   1   10 10                       20.0 0 15 4 0   0     0   1   10 10                 20
2238249 2238249 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2018   grade_8 20 1 9 0   0     0   1   10 21                       31.0 20 1 9 0   0     0   1   10 21                 31
740689 740689 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No 2 06 08 2015   grade_8 190 0 3 1   4     0   2   100 100                       200 190 0 3 1   4     0   2   100 100                 200
741302 741302 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2015   grade_8 147 7 18 0   0     0   7   100 79                       179 147 7 18 0   0     0   7   100 79                 179
741381 741381 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2015   grade_8 90 19 66 0   5     0   12   100 92                       192 90 19 66 0   5     0   12   100 92                 192
744261 744261 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_8 176 3 8 1   3     0   4   100 95                       195 176 3 8 1   3     0   4   100 95                 195
938772 938772 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_8 23 29 125 0   0     0   0   100 77                       177 23 29 125 0   0     0   0   100 77                 177
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
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
1368591 1368591 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_8 57 8 89 1   16     0   10   100 81 *                     181.0 57 8 89 1   16     0   10   100 81                 181
1369364 1369364 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2020   grade_8 176 3 7 0   9     0   4   100 99 *                     199.0 176 3 7 0   9     0   4   100 99                 199
1676951 1676951 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading - North Reading Middle   Regular School No Middle 06 08 2021   grade_8 168 0 8 0   6     0   3   100 85 *                     185.0 168 0 8 0   6     0   3   100 85                 185
2042329 2042329 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_8 56 15 107 0   13     0   9   100 100                       200.0 56 15 107 0   13     0   9   100 100                 200
2044736 2044736 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2019   grade_8 163 2 11 0   0     0   8   100 84                       184.0 163 2 11 0   0     0   8   100 84                 184
2046666 2046666 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2019   grade_8 135 12 9 0   38     0   16   100 110                       210.0 135 12 9 0   38     0   16   100 110                 210
2234637 2234637 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading: North Reading Middle   Regular School No Middle 06 08 2018   grade_8 170 0 4 0   7     1   6   100 88                       188.0 170 0 4 0   7     1   6   100 88                 188
2239625 2239625 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton: Triton Regional Middle School   Regular School No Middle 07 08 2018   grade_8 183 3 7 0   4     1   4   100 102                       202.0 183 3 7 0   4     1   4   100 102                 202
740408 740408 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No 2 06 08 2015   grade_8 144 13 8 0   42     0   8   101 114                       215 144 13 8 0   42     0   8   101 114                 215
741119 741119 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_8 127 7 5 0   50     1   5   101 94                       195 127 7 5 0   50     1   5   101 94                 195
742178 742178 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2015   grade_8 168 8 12 0   5     1   5   101 98                       199 168 8 12 0   5     1   5   101 98                 199
939555 939555 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2016   grade_8 149 0 3 0   40     0   2   101 93                       194 149 0 3 0   40     0   2   101 93                 194
1127769 1127769 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2017   grade_8 172 0 11 0   2     1   5   101 90                       191 172 0 11 0   2     1   5   101 90                 191
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
1131791 1131791 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2017   grade_8 191 0 8 0   3     0   2   101 103                       204 191 0 8 0   3     0   2   101 103                 204
1365111 1365111 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2020   grade_8 113 11 15 0   28     0   14   101 80 *                     181.0 113 11 15 0   28     0   14   101 80                 181
1672349 1672349 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Belchertown - Jabish Middle School   Regular School No Middle 07 08 2021   grade_8 165 7 7 0   3     1   4   101 85 *                     187.0 165 7 7 0   3     1   4   101 85                 187
740947 740947 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2015   grade_8 142 28 15 0   5     0   13   102 101                       203 142 28 15 0   5     0   13   102 101                 203
742779 742779 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2015   grade_8 150 13 17 0   24     0   10   102 112                       214 150 13 17 0   24     0   10   102 112                 214
939254 939254 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_8 87 21 57 0   9     0   4   102 76                       178 87 21 57 0   9     0   4   102 76                 178
1366227 1366227 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2020   grade_8 31 130 24 0   2     0   4   102 89 *                     191.0 31 130 24 0   2     0   4   102 89                 191
1366228 1366228 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 08 08 2020   grade_8 16 112 29 1   4     0   6   102 66 *                     168.0 16 112 29 1   4     0   6   102 66                 168
1366932 1366932 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2020   grade_8 167 2 5 1   0     0   4   102 77 *                     179.0 167 2 5 1   0     0   4   102 77                 179
1371789 1371789 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2020   grade_8 145 3 0 0   54     0   7   102 107 *                     209.0 145 3 0 0   54     0   7   102 107                 209
1374062 1374062 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2020   grade_8 146 10 11 2   2     0   6   102 75 *                     177.0 146 10 11 2   2     0   6   102 75                 177
1674162 1674162 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater - East Bridgewater JR./SR. High School   Regular School No High 07 12 2021   grade_8 148 14 2 1   0     1   6   102 70 *                     172.0 148 14 2 1   0     1   6   102 70                 172
1675159 1675159 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson - Hudson High   Regular School No High 08 12 2021   grade_8 164 6 26 0   2     0   8   102 104 *                     206.0 164 6 26 0   2     0   8   102 104                 206
1675649 1675649 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell - Dr An Wang School   Regular School No Middle 05 08 2021   grade_8 52 13 69 0   29     0   8   102 69 *                     171.0 52 13 69 0   29     0   8   102 69                 171
1676216 1676216 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   grade_8 54 7 103 0   6     0   7   102 75 *                     177.0 54 7 103 0   6     0   7   102 75                 177
1681013 1681013 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket - Pentucket Regional Middle   Regular School No Middle 07 08 2021   grade_8 184 1 13 0   1     0   4   102 101 *                     203.0 184 1 13 0   1     0   4   102 101                 203
2041304 2041304 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2019   grade_8 43 117 37 0   7     0   10   102 112                       214.0 43 117 37 0   7     0   10   102 112                 214
2045355 2045355 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_8 94 6 88 1   6     1   2   102 96                       198.0 94 6 88 1   6     1   2   102 96                 198
2046575 2046575 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2019   grade_8 82 23 63 0   10     0   2   102 78                       180.0 82 23 63 0   10     0   2   102 78                 180
2046578 2046578 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2019   grade_8 81 19 93 0   6     0   5   102 102                       204.0 81 19 93 0   6     0   5   102 102                 204
2046859 2046859 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2019   grade_8 133 1 1 0   58     0   1   102 92                       194.0 133 1 1 0   58     0   1   102 92                 194
2234660 2234660 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton: Norton Middle   Regular School No Middle 06 08 2018   grade_8 191 6 6 0   3     0   5   102 109                       211.0 191 6 6 0   3     0   5   102 109                 211
2234987 2234987 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield: Theodore Herberg Middle   Regular School No Middle 06 08 2018   grade_8 160 20 22 0   2     0   15   102 117                       219.0 160 20 22 0   2     0   15   102 117                 219
2236761 2236761 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham: John W. McDevitt Middle School   Regular School No Middle 06 08 2018   grade_8 79 20 89 0   7     0   3   102 96                       198.0 79 20 89 0   7     0   3   102 96                 198

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