enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1672321 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
1673303 1673303 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_9 84 1 4 3   2     0   4   49 49 *                     98.0 84 1 4 3   2     0   4   49 49                 98
1674473 1674473 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_9 158 15 13 0   2     0   11   102 97 *                     199.0 158 15 13 0   2     0   11   102 97                 199
1676051 1676051 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee - Mashpee High   Regular School No High 09 12 2021   grade_9 72 3 2 6   3     0   9   56 39 *                     95.0 72 3 2 6   3     0   9   56 39                 95
1677700 1677700 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich - Sandwich High   Regular School No High 09 12 2021   grade_9 144 0 1 0   2     0   3   71 78 *                     150.0 144 0 1 0   2     0   3   71 78                 150
1680173 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
1680520 1680520 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth - Dennis-Yarmouth Regional High   Regular School No High 08 12 2021   grade_9 89 14 26 3   4     0   12   67 81 *                     148.0 89 14 26 3   4     0   12   67 81                 148
1680585 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
1680830 1680830 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District - Monomoy Regional High School   Regular School No High 08 12 2021   grade_9 88 8 11 0   1     0   4   57 55 *                     112.0 88 8 11 0   1     0   4   57 55                 112
1681336 1681336 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical - Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 128 14 16 4   1     1   10   103 70 *                     174.0 128 14 16 4   1     1   10   103 70                 174
1681417 1681417 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Regional Vocational Technical - Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 164 4 15 2   1     0   18   112 92 *                     204.0 164 4 15 2   1     0   18   112 92                 204
1675325 1675325 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee - Lee Middle/High School   Regular School No High 07 12 2021   grade_9 49 1 4 0   2     0   1   30 27 *                     57.0 49 1 4 0   2     0   1   30 27                 57
1675354 1675354 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox - Lenox Memorial High   Regular School No High 06 12 2021   grade_9 54 0 9 0   2     0   0   37 28 *                     65.0 54 0 9 0   2     0   0   37 28                 65
1676765 1676765 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams - Drury High   Regular School No High 07 12 2021   grade_9 75 4 4 0   1     1   3   41 47 *                     88.0 75 4 4 0   1     1   3   41 47                 88
1677248 1677248 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield - Pittsfield High   Regular School No High 09 12 2021   grade_9 116 19 24 0   3     0   14   91 85 *                     176.0 116 19 24 0   3     0   14   91 85                 176
1677253 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
1677257 1677257 MA Berkshire   school 2509630 236   Pittsfield 250963002915 2360525 Pittsfield - Eagle Education Academy   Special Education School No High 06 12 2021   grade_9 5 2 2 0   0     0   0   6 3 *                     9.0 5 2 2 0   0     0   0   6 3                 9
1679748 1679748 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District) - Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2021   grade_9 33 4 8 0   1     0   5   28 23 *                     51.0 33 4 8 0   1     0   5   28 23                 51
1680304 1680304 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Regional - Hoosac Valley High School   Regular School No High 08 12 2021   grade_9 57 1 4 2   0     0   0   33 31 *                     64.0 57 1 4 2   0     0   0   33 31                 64
1680388 1680388 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Berkshire Hills - Monument Mt Regional High   Regular School No High 09 12 2021   grade_9 89 3 8 1   5     0   7   59 54 *                     113.0 89 3 8 1   5     0   7   59 54                 113
1680491 1680491 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Central Berkshire - Wahconah Regional High   Regular School No High 09 12 2021   grade_9 132 1 4 0   2     0   5   72 72 *                     144.0 132 1 4 0   2     0   5   72 72                 144
1680852 1680852 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock - Mt Greylock Regional High   Regular School No High 07 12 2021   grade_9 105 2 2 0   4     0   2   49 66 *                     115.0 105 2 2 0   4     0   2   49 66                 115
1681109 1681109 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire - Mt Everett Regional   Regular School No High 06 12 2021   grade_9 32 0 1 0   0     0   2   13 22 *                     35.0 32 0 1 0   0     0   2   13 22                 35
1681377 1681377 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Northern Berkshire Regional Vocational Technical - Charles McCann Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 124 1 2 0   1     0   0   72 56 *                     128.0 124 1 2 0   1     0   0   72 56                 128
1672255 1672255 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_9 291 30 73 1   26     0   28   240 209 *                     449.0 291 30 73 1   26     0   28   240 209                 449
1674043 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
1674233 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
1674340 1674340 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven - Fairhaven High   Regular School No High 09 12 2021   grade_9 129 0 7 1   5     0   8   80 70 *                     150.0 129 0 7 1   5     0   8   80 70                 150
1674433 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
1674437 1674437 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_9 250 57 149 0   31     0   38   279 246 *                     525.0 250 57 149 0   31     0   38   279 246                 525
1674443 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
1675937 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
1676586 1676586 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_9 296 101 315 2   7     1   34   407 349 *                     756.0 296 101 315 2   7     1   34   407 349                 756
1676594 1676594 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_9 4 1 6 0   0     0   3   9 5 *                     14.0 4 1 6 0   0     0   3   9 5                 14
1676600 1676600 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford - Whaling City Junior/Senior High School   Regular School No High 06 12 2021   grade_9 7 5 6 0   0     0   0   11 7 *                     18.0 7 5 6 0   0     0   0   11 7                 18
1676870 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
1676970 1676970 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton - Norton High   Regular School No High 09 12 2021   grade_9 143 2 9 1   4     0   4   81 82 *                     163.0 143 2 9 1   4     0   4   81 82                 163
1677793 1677793 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk - Seekonk High   Regular School No High 09 12 2021   grade_9 105 3 9 0   6     0   7   55 75 *                     130.0 105 3 9 0   6     0   7   55 75                 130
1678505 1678505 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Swansea - Joseph Case High   Regular School No High 09 12 2021   grade_9 156 2 7 0   1     0   1   91 76 *                     167.0 156 2 7 0   1     0   1   91 76                 167
1678552 1678552 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_9 314 122 79 5   5     2   38   293 272 *                     565.0 314 122 79 5   5     2   38   293 272                 565
1679084 1679084 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport - Westport Junior/Senior High School   Regular School No High 07 12 2021   grade_9 80 1 6 0   0     0   5   48 44 *                     92.0 80 1 6 0   0     0   5   48 44                 92
1680186 1680186 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_9 33 5 19 0   1     0   0   30 28 *                     58.0 33 5 19 0   1     0   0   30 28                 58
1680216 1680216 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_9 10 6 19 1   0     0   3   22 17 *                     39.0 10 6 19 1   0     0   3   22 17                 39
1680453 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
1680456 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
1680544 1680544 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth - Dighton-Rehoboth Regional High School   Regular School No High 09 12 2021   grade_9 158 3 9 0   4     0   6   101 79 *                     180.0 158 3 9 0   4     0   6   101 79                 180
1680612 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
1681088 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
1681332 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
1681348 1681348 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Greater Fall River Regional Vocational Technical - Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2021   grade_9 281 15 48 2   8     0   20   194 178 *                     374.0 281 15 48 2   8     0   20   194 178                 374
1681356 1681356 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical - Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 349 43 131 4   7     1   32   306 261 *                     567.0 349 43 131 4   7     1   32   306 261                 567
1681389 1681389 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical - Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 140 1 1 0   2     0   6   94 56 *                     150.0 140 1 1 0   2     0   6   94 56                 150
1681401 1681401 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical - Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 151 150 78 0   9     0   22   187 223 *                     410.0 151 150 78 0   9     0   22   187 223                 410
1681425 1681425 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural - Bristol County Agricultural High   Career and Technical School No High 09 12 2021   grade_9 114 3 4 0   0     0   2   24 99 *                     123.0 114 3 4 0   0     0   2   24 99                 123
1681477 1681477 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_9 34 10 14 1   1     0   5   42 23 *                     65.0 34 10 14 1   1     0   5   42 23                 65
1674759 1674759 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1680044 1680044 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_9 6 0 2 0   0     0   1   1 8 *                     9.0 6 0 2 0   0     0   1   1 8                 9
1680783 1680783 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard - Martha's Vineyard Regional High   Regular School No High 09 12 2021   grade_9 114 7 28 3   1     0   12   79 86 *                     165.0 114 7 28 3   1     0   12   79 86                 165
1672078 1672078 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_9 105 6 16 0   1     0   4   61 71 *                     132.0 105 6 16 0   1     0   4   61 71                 132
1672148 1672148 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_9 285 19 42 0   78     0   13   209 226 *                     437.0 285 19 42 0   78     0   13   209 226                 437
1672445 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
1674015 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
1674706 1674706 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown - Georgetown High School   Regular School No High 09 12 2021   grade_9 71 1 2 0   0     0   0   38 36 *                     74.0 71 1 2 0   0     0   0   38 36                 74
1674744 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
1674917 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
1674955 1674955 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill - Haverhill High   Regular School No High 09 12 2021   grade_9 274 28 202 2   6     2   5   277 242 *                     519.0 274 28 202 2   6     2   5   277 242                 519
1674960 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
1675194 1675194 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich - Ipswich High   Regular School No High 09 12 2021   grade_9 116 2 10 1   2     0   3   70 63 *                     134.0 116 2 10 1   2     0   3   70 63                 134
1675291 1675291 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_9 19 13 735 1   14     0   3   425 358 2                     785.0 19 13 735 1   14     0   3   425 358 2               785
1675308 1675308 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_9 1 0 10 0   0     0   0   9 2 *                     11.0 1 0 10 0   0     0   0   9 2                 11
1675312 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
1675833 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
1675837 1675837 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_9 51 45 351 0   38     0   18   265 238 *                     503.0 51 45 351 0   38     0   18   265 238                 503
1675844 1675844 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_9 3 2 6 0   0     0   1   9 3 *                     12.0 3 2 6 0   0     0   1   9 3                 12
1675852 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
1675872 1675872 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield - Lynnfield High   Regular School No High 09 12 2021   grade_9 127 2 9 0   6     0   3   73 74 *                     147.0 127 2 9 0   6     0   3   73 74                 147
1675956 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
1676227 1676227 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_9 192 9 194 0   15     0   22   219 212 *                     432.0 192 9 194 0   15     0   22   219 212                 432
1676614 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
1676832 1676832 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover - North Andover High   Regular School No High 09 12 2021   grade_9 251 11 44 1   24     0   4   168 167 *                     335.0 251 11 44 1   24     0   4   168 167                 335
1677141 1677141 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody - Peabody Veterans Memorial High   Regular School No High 09 12 2021   grade_9 266 12 92 2   11     0   3   192 194 *                     386.0 266 12 92 2   11     0   3   192 194                 386
1677625 1677625 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport - Rockport High   Regular School No High 09 12 2021   grade_9 62 2 5 0   0     0   3   46 26 *                     72.0 62 2 5 0   0     0   3   46 26                 72
1677679 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
1677733 1677733 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus - Saugus High   Regular School No High 09 12 2021   grade_9 111 9 41 1   10     0   0   91 81 *                     172.0 111 9 41 1   10     0   0   91 81                 172
1678485 1678485 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott - Swampscott High   Regular School No High 09 12 2021   grade_9 124 9 19 0   4     0   5   78 82 *                     161.0 124 9 19 0   4     0   5   78 82                 161
1679819 1679819 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_9 4 23 99 0   3     0   1   65 65 *                     130.0 4 23 99 0   3     0   1   65 65                 130
1680134 1680134 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_9 25 9 36 0   3     0   1   42 32 *                     74.0 25 9 36 0   3     0   1   42 32                 74
1680196 1680196 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy (District) - Phoenix Charter Academy   Regular School Yes High 09 12 2021   grade_9 8 16 135 3   0     0   0   80 82 *                     162.0 8 16 135 3   0     0   0   80 82                 162
1680708 1680708 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham - Hamilton-Wenham Regional High   Regular School No High 09 12 2021   grade_9 100 1 8 0   11     0   4   50 74 *                     124.0 100 1 8 0   11     0   4   50 74                 124
1680779 1680779 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional - Manchester Essex Regional High School   Regular School No High 09 12 2021   grade_9 93 0 1 0   1     0   1   51 45 *                     96.0 93 0 1 0   1     0   1   51 45                 96
1680790 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
1681014 1681014 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket - Pentucket Regional Sr High   Regular School No High 09 12 2021   grade_9 132 0 7 0   3     1   0   60 83 *                     143.0 132 0 7 0   3     1   0   60 83                 143
1681185 1681185 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton - Triton Regional High School   Regular School No High 09 12 2021   grade_9 135 3 8 0   4     0   4   76 78 *                     154.0 135 3 8 0   4     0   4   76 78                 154
1681340 1681340 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District - Essex North Shore Agricultural and Technical School   Career and Technical School No High 09 12 2021   grade_9 338 9 54 0   10     0   15   180 244 *                     426.0 338 9 54 0   10     0   15   180 244                 426
1681352 1681352 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical - Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 79 8 328 1   3     1   0   180 240 *                     420.0 79 8 328 1   3     1   0   180 240                 420
1681421 1681421 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational Technical - Whittier Regional Vocational   Career and Technical School No High 09 12 2021   grade_9 212 10 93 1   6     0   13   174 161 *                     335.0 212 10 93 1   6     0   13   174 161                 335
1681515 1681515 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence (District) - Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2021   grade_9 8 0 112 0   0     0   0   77 42 *                     120.0 8 0 112 0   0     0   0   77 42                 120
1674820 1674820 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield - Greenfield High   Regular School No High 08 12 2021   grade_9 60 2 22 0   2     0   9   56 39 *                     95.0 60 2 22 0   2     0   9   56 39                 95
1679741 1679741 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District) - Four Rivers Charter Public School   Regular School Yes High 07 12 2021   grade_9 31 1 1 0   0     0   2   17 18 *                     35.0 31 1 1 0   0     0   2   17 18                 35
1680618 1680618 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_9 75 5 5 0   7     0   7   58 41 *                     99.0 75 5 5 0   7     0   7   58 41                 99

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