Data source: Big Local News · About: Big Local

387 rows where grade = "grade_9", state = "MA" and year = 2021 sorted by female

View and edit SQL

year

  • 2021 · 387

grade

  • grade_9 · 387
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
1674759 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1674960 MA Essex   school 2505970 128   Haverhill 250597002907 1280515 Haverhill - Crowell   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   2 * *                     3.0                         2                   3
1675312 MA Essex   school 2506660 149   Lawrence 250666002919 1490615 Lawrence - RISE Academy   Alternative School No Secondary 09 11 2021   grade_9 0 0 8 0   0     0   0   7 * *                     8.0 0 0 8 0   0     0   0   7                   8
1675707 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1680453 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_9 * * * *   *     *   *   2 * *                     4.0                         2                   4
1672372 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham - Keough Memorial Academy   Alternative School No High 08 12 2021   grade_9 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1673149 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Boston - Community Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1674433 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_9 3 1 3 0   0     0   2   8 1 *                     9.0 3 1 3 0   0     0   2   8 1                 9
1674519 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Fitchburg - Goodrich Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1674917 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_9 2 0 8 0   0     0   0   9 1 *                     10.0 2 0 8 0   0     0   0   9 1                 10
1675668 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_9 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1672336 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford - Bedford High   Regular School No High 09 12 2021   grade_9 116 16 29 0   30     1   15   107 100 *                     207.0 116 16 29 0   30     1   15   107 100                 207
1673608 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington - Burlington High   Regular School No High 09 12 2021   grade_9 133 14 15 3   35     0   5   105 100 *                     205.0 133 14 15 3   35     0   5   105 100                 205
1675030 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston - Holliston High   Regular School No High 09 12 2021   grade_9 159 1 14 1   16     0   3   94 100 *                     194.0 159 1 14 1   16     0   3   94 100                 194
1675160 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson - Hudson High   Regular School No High 08 12 2021   grade_9 140 2 21 0   6     0   2   71 100 *                     171.0 140 2 21 0   6     0   2   71 100                 171
1676246 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough - Middleborough High   Regular School No High 09 12 2021   grade_9 184 5 6 4   5     0   9   113 100 *                     213.0 184 5 6 4   5     0   9   113 100                 213
1678661 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield - Wakefield Memorial High   Regular School No High 09 12 2021   grade_9 154 8 16 1   6     0   5   90 100 *                     190.0 154 8 16 1   6     0   5   90 100                 190
1680127 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_9 1 124 103 1   4     1   4   137 100 *                     238.0 1 124 103 1   4     1   4   137 100                 238
1675679 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow - Ludlow Senior High   Regular School No High 09 12 2021   grade_9 179 3 20 0   1     0   8   110 101 *                     211.0 179 3 20 0   1     0   8   110 101                 211
1674134 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut - Dracut Senior High   Regular School No High 09 12 2021   grade_9 154 9 21 1   24     0   2   105 103 *                     211.0 154 9 21 1   24     0   2   105 103                 211
1680310 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_9 120 20 42 0   11     0   19   108 103 *                     212.0 120 20 42 0   11     0   19   108 103                 212
1672350 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown - Belchertown High   Regular School No High 09 12 2021   grade_9 154 4 10 0   2     1   3   69 104 *                     174.0 154 4 10 0   2     1   3   69 104                 174
1680612 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Freetown-Lakeville - Apponequet Regional High   Regular School No High 09 12 2021   grade_9 191 2 4 0   0     0   1   94 104 *                     198.0 191 2 4 0   0     0   1   94 104                 198
1674212 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow - East Longmeadow High   Regular School No High 09 12 2021   grade_9 171 7 11 0   9     0   5   98 105 *                     203.0 171 7 11 0   9     0   5   98 105                 203
1676614 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport - Newburyport High   Regular School No High 09 12 2021   grade_9 181 3 7 0   8     0   3   95 106 *                     202.0 181 3 7 0   8     0   3   95 106                 202
1677772 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate - Scituate High School   Regular School No High 09 12 2021   grade_9 196 3 6 0   2     0   4   105 106 *                     211.0 196 3 6 0   2     0   4   105 106                 211
1678844 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland - Wayland High School   Regular School No High 09 12 2021   grade_9 144 12 7 0   38     0   12   107 106 *                     213.0 144 12 7 0   38     0   12   107 106                 213
1680585 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset - Nauset Regional High   Regular School No High 09 12 2021   grade_9 162 9 12 0   5     0   4   85 107 *                     192.0 162 9 12 0   5     0   4   85 107                 192
1677679 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem - Salem High   Regular School No High 09 12 2021   grade_9 77 19 133 0   7     0   12   140 108 *                     248.0 77 19 133 0   7     0   12   140 108                 248
1681413 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical - Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 214 6 25 0   1     0   14   150 108 *                     260.0 214 6 25 0   1     0   14   150 108                 260
1681365 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_9 123 6 81 5   4     0   7   116 109 *                     226.0 123 6 81 5   4     0   7   116 109                 226
1674443 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_9 10 6 14 0   0     0   3   22 11 *                     33.0 10 6 14 0   0     0   3   22 11                 33
1680931 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba - Nashoba Regional   Regular School No High 09 12 2021   grade_9 190 2 10 0   13     0   8   113 110 *                     223.0 190 2 10 0   13     0   8   113 110                 223
1681328 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical - Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 128 61 39 3   5     0   11   136 111 *                     247.0 128 61 39 3   5     0   11   136 111                 247
1674015 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers - Danvers High   Regular School No High 09 12 2021   grade_9 181 7 17 0   7     0   6   106 112 *                     218.0 181 7 17 0   7     0   6   106 112                 218
1674744 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester - Gloucester High   Regular School No High 09 12 2021   grade_9 210 3 26 0   5     3   11   146 112 *                     258.0 210 3 26 0   5     3   11   146 112                 258
1674782 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton - Grafton High School   Regular School No High 09 12 2021   grade_9 163 7 13 2   22     1   5   101 112 *                     213.0 163 7 13 2   22     1   5   101 112                 213
1673738 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton - Canton High   Regular School No High 09 12 2021   grade_9 133 33 12 0   24     0   11   99 113 *                     213.0 133 33 12 0   24     0   11   99 113                 213
1673902 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee - Chicopee High   Regular School No High 09 12 2021   grade_9 87 4 104 0   8     0   8   98 113 *                     211.0 87 4 104 0   8     0   8   98 113                 211
1681315 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson - Whitman Hanson Regional   Regular School No High 09 12 2021   grade_9 206 10 14 0   3     0   7   126 114 *                     240.0 206 10 14 0   3     0   7   126 114                 240
1678403 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton - Stoughton High   Regular School No High 09 12 2021   grade_9 146 81 24 1   24     2   12   175 115 *                     290.0 146 81 24 1   24     2   12   175 115                 290
1679160 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood - Westwood High   Regular School No High 09 12 2021   grade_9 181 7 12 0   33     0   10   126 116 *                     243.0 181 7 12 0   33     0   10   126 116                 243
1676182 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose - Melrose High   Regular School No High 09 12 2021   grade_9 164 26 19 0   6     0   6   103 118 *                     221.0 164 26 19 0   6     0   6   103 118                 221
1674149 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury - Duxbury High   Regular School No High 09 12 2021   grade_9 216 2 5 0   7     0   12   123 119 *                     242.0 216 2 5 0   7     0   12   123 119                 242
1675956 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead - Marblehead High   Regular School No High 09 12 2021   grade_9 178 11 21 1   4     1   9   105 119 *                     225.0 178 11 21 1   4     1   9   105 119                 225
1681083 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake - Silver Lake Regional High   Regular School No High 09 12 2021   grade_9 238 3 6 1   5     0   4   136 121 *                     257.0 238 3 6 1   5     0   4   136 121                 257
1681429 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural - Norfolk County Agricultural   Career and Technical School No High 09 12 2021   grade_9 147 1 0 1   0     0   9   37 121 *                     158.0 147 1 0 1   0     0   9   37 121                 158
1677253 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Pittsfield - Taconic High   Regular School No High 09 12 2021   grade_9 156 32 23 0   3     0   18   110 122 *                     232.0 156 32 23 0   3     0   18   110 122                 232
1677027 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood - Norwood High   Regular School No High 09 12 2021   grade_9 142 27 33 0   16     1   5   101 123 *                     224.0 142 27 33 0   16     1   5   101 123                 224
1675516 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow - Longmeadow High   Regular School No High 09 12 2021   grade_9 166 5 23 0   23     0   6   99 124 *                     223.0 166 5 23 0   23     0   6   99 124                 223
1677327 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth - Plymouth South High   Regular School No High 09 12 2021   grade_9 247 3 8 2   1     0   14   151 124 *                     275.0 247 3 8 2   1     0   14   151 124                 275
1672483 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica - Billerica Memorial High School   Regular School No High 08 12 2021   grade_9 191 16 27 1   26     1   4   140 125 *                     266.0 191 16 27 1   26     1   4   140 125                 266
1678704 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole - Walpole High   Regular School No High 09 12 2021   grade_9 207 6 17 0   21     0   4   130 125 *                     255.0 207 6 17 0   21     0   4   130 125                 255
1672058 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_9 231 6 23 0   12     0   9   155 126 *                     281.0 231 6 23 0   12     0   9   155 126                 281
1673174 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston - Madison Park High   Career and Technical School No High 09 12 2021   grade_9 5 123 157 1   7     0   7   174 126 *                     300.0 5 123 157 1   7     0   7   174 126                 300
1675399 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Leominster - Center For Technical Education Innovation   Career and Technical School No High 09 12 2021   grade_9 118 25 135 0   13     0   7   172 126 *                     298.0 118 25 135 0   13     0   7   172 126                 298
1677819 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon - Sharon High   Regular School No High 09 12 2021   grade_9 155 14 15 1   78     0   14   150 127 *                     277.0 155 14 15 1   78     0   14   150 127                 277
1674233 MA Bristol   school 2504620 88   Easton 250462000623 880505 Easton - Oliver Ames High   Regular School No High 09 12 2021   grade_9 220 9 18 0   10     0   8   137 128 *                     265.0 220 9 18 0   10     0   8   137 128                 265
1681397 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Regional Vocational Technical - Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2021   grade_9 322 3 24 3   3     0   2   228 129 *                     357.0 322 3 24 3   3     0   2   228 129                 357
1674043 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth - Dartmouth High   Regular School No High 09 12 2021   grade_9 220 8 16 0   0     0   16   129 131 *                     260.0 220 8 16 0   0     0   16   129 131                 260
1676037 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield - Marshfield High   Regular School No High 09 12 2021   grade_9 248 0 7 0   2     0   5   130 132 *                     262.0 248 0 7 0   2     0   5   130 132                 262
1676272 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford - Milford High   Regular School No High 09 12 2021   grade_9 180 8 103 6   5     0   7   177 132 *                     309.0 180 8 103 6   5     0   7   177 132                 309
1680173 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District) - Sturgis Charter Public School   Regular School Yes High 09 12 2021   grade_9 188 4 9 0   1     1   8   79 132 *                     211.0 188 4 9 0   1     1   8   79 132                 211
1681409 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Southern Worcester County Regional Vocational Technical - Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2021   grade_9 263 3 35 0   4     0   9   181 133 *                     314.0 263 3 35 0   4     0   9   181 133                 314
1680732 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Hampden-Wilbraham - Minnechaug Regional High   Regular School No High 09 12 2021   grade_9 210 7 21 0   6     0   17   127 134 *                     261.0 210 7 21 0   6     0   17   127 134                 261
1681088 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional School District - Somerset Berkley Regional High School   Regular School No High 09 12 2021   grade_9 236 2 15 0   0     0   4   123 134 *                     257.0 236 2 15 0   0     0   4   123 134                 257
1675134 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton - Hopkinton High   Regular School No High 09 12 2021   grade_9 184 4 16 1   43     0   12   124 135 *                     260.0 184 4 16 1   43     0   12   124 135                 260
1675833 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn - Classical High   Regular School No High 09 12 2021   grade_9 44 25 240 0   23     0   16   213 135 *                     348.0 44 25 240 0   23     0   16   213 135                 348
1675937 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield - Mansfield High   Regular School No High 09 12 2021   grade_9 209 13 16 0   29     0   8   140 135 *                     275.0 209 13 16 0   29     0   8   140 135                 275
1679380 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn - Woburn High   Regular School No High 09 12 2021   grade_9 198 19 36 1   18     0   8   144 136 *                     280.0 198 19 36 1   18     0   8   144 136                 280
1676334 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton - Milton High   Regular School No High 09 12 2021   grade_9 201 38 19 0   20     0   15   156 137 *                     293.0 201 38 19 0   20     0   15   156 137                 293
1681320 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical - Assabet Valley Vocational High School   Career and Technical School No High 09 12 2021   grade_9 219 1 78 0   2     0   6   166 138 2                     306.0 219 1 78 0   2     0   6   166 138 2               306
1672445 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly - Beverly High   Regular School No High 09 12 2021   grade_9 211 10 57 0   10     0   7   156 139 *                     295.0 211 10 57 0   10     0   7   156 139                 295
1673242 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Boston - Lyon Upper 9-12   Regular School No High 09 12 2021   grade_9 3 6 22 0   0     0   5   22 14 *                     36.0 3 6 22 0   0     0   5   22 14                 36
1673479 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton - Brockton Champion High School   Alternative School No High 09 12 2021   grade_9 7 15 6 0   0     0   2   16 14 *                     30.0 7 15 6 0   0     0   2   16 14                 30
1679006 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield - Westfield High   Regular School No High 09 12 2021   grade_9 196 8 42 0   7     0   7   120 140 *                     260.0 196 8 42 0   7     0   7   120 140                 260
1681332 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Regional Vocational Technical - Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 293 16 18 0   4     0   12   202 141 *                     343.0 293 16 18 0   4     0   12   202 141                 343
1676126 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford - Medford High   Regular School No High 09 12 2021   grade_9 178 46 39 0   30     1   13   165 142 *                     307.0 178 46 39 0   30     1   13   165 142                 307
1676870 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleborough - North Attleboro High   Regular School No High 09 12 2021   grade_9 221 12 19 0   25     0   9   144 142 *                     286.0 221 12 19 0   25     0   9   144 142                 286
1680577 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Dudley-Charlton Reg - Shepherd Hill Regional High   Regular School No High 09 12 2021   grade_9 211 5 33 0   4     0   9   120 142 *                     262.0 211 5 33 0   4     0   9   120 142                 262
1673906 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee - Chicopee Comprehensive High School   Regular School No High 09 12 2021   grade_9 179 8 110 0   6     0   17   177 143 *                     320.0 179 8 110 0   6     0   17   177 143                 320
1679661 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Worcester - Doherty Memorial High   Regular School No High 09 12 2021   grade_9 119 42 139 1   20     0   14   192 143 *                     335.0 119 42 139 1   20     0   14   192 143                 335
1674992 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham - Hingham High   Regular School No High 09 12 2021   grade_9 272 7 11 0   5     0   11   161 144 *                     306.0 272 7 11 0   5     0   11   161 144                 306
1675852 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   grade_9 39 21 216 0   13     0   8   151 146 *                     297.0 39 21 216 0   13     0   8   151 146                 297
1680790 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet - Masconomet Regional High School   Regular School No High 09 12 2021   grade_9 236 2 11 0   11     0   5   119 146 *                     265.0 236 2 11 0   11     0   5   119 146                 265
1681385 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metropolitan Regional Vocational Technical - Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2021   grade_9 282 5 44 0   1     0   0   183 147 *                     332.0 282 5 44 0   1     0   0   183 147                 332
1680751 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip - King Philip Regional High   Regular School No High 09 12 2021   grade_9 273 6 14 1   12     0   0   158 148 *                     306.0 273 6 14 1   12     0   0   158 148                 306
1680017 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter (District) - Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2021   grade_9 11 0 11 0   0     0   1   8 15 *                     23.0 11 0 11 0   0     0   1   8 15                 23
1681453 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_9 6 4 13 0   5     0   1   14 15 *                     29.0 6 4 13 0   5     0   1   14 15                 29
1681511 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School (District) - Map Academy Charter School   Regular School Yes High 09 12 2021   grade_9 21 7 7 0   0     2   2   24 15 *                     39.0 21 7 7 0   0     2   2   24 15                 39
1680456 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham - Bridgewater-Raynham Regional   Regular School No High 09 12 2021   grade_9 245 29 9 0   6     0   16   153 152 *                     305.0 245 29 9 0   6     0   16   153 152                 305
1678938 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough - Westborough High   Regular School No High 09 12 2021   grade_9 167 7 19 0   93     1   11   145 153 *                     298.0 167 7 19 0   93     1   11   145 153                 298
1681324 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley Regional Vocational Technical - Blackstone Valley   Career and Technical School No High 09 12 2021   grade_9 268 6 31 0   4     0   9   164 153 *                     318.0 268 6 31 0   4     0   9   164 153                 318
1677511 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading - Reading Memorial High   Regular School No High 09 12 2021   grade_9 248 12 9 1   20     1   8   145 154 *                     299.0 248 12 9 1   20     1   8   145 154                 299
1679120 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield - West Springfield High   Regular School No High 09 12 2021   grade_9 208 9 67 0   21     0   10   159 156 *                     315.0 208 9 67 0   21     0   10   159 156                 315
1679656 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester - Burncoat Senior High   Regular School No High 09 12 2021   grade_9 104 66 126 1   12     0   11   164 156 *                     320.0 104 66 126 1   12     0   11   164 156                 320
1677959 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville - Somerville High   Regular School No High 09 12 2021   grade_9 125 38 140 0   23     0   6   172 159 *                     332.0 125 38 140 0   23     0   6   172 159                 332
1680882 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail - Mohawk Trail Regional School   Regular School No High 07 12 2021   grade_9 30 0 3 0   1     0   1   19 16 *                     35.0 30 0 3 0   1     0   1   19 16                 35
1681036 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_9 36 1 1 0   0     0   2   24 16 *                     40.0 36 1 1 0   0     0   2   24 16                 40
1672321 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_9 221 34 74 1   9     0   16   194 160 *                     355.0 221 34 74 1   9     0   16   194 160                 355

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