enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1681069 1681069 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin - Quabbin Regional High School   Regular School No High 09 12 2021   grade_9 162 1 6 1   4     0   2   80 94 *                     176.0 162 1 6 1   4     0   2   80 94                 176
1681144 1681144 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 Spencer-E Brookfield - David Prouty High   Regular School No High 09 12 2021   grade_9 64 2 19 0   2     0   5   55 37 *                     92.0 64 2 19 0   2     0   5   55 37                 92
1681123 1681123 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_9 93 0 7 0   1     0   3   53 51 *                     104.0 93 0 7 0   1     0   3   53 51                 104
1679735 1679735 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_9 5 50 26 0   0     0   1   42 40 *                     82.0 5 50 26 0   0     0   1   42 40                 82
1679847 1679847 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_9 59 15 19 0   8     0   7   45 60 *                     108.0 59 15 19 0   8     0   7   45 60                 108
1679858 1679858 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street (District) - City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2021   grade_9 1 52 16 0   0     0   0   32 37 *                     69.0 1 52 16 0   0     0   0   32 37                 69
1679905 1679905 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_9 22 34 47 0   3     0   2   51 57 *                     108.0 22 34 47 0   3     0   2   51 57                 108
1679919 1679919 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District) - Neighborhood House Charter School   Regular School Yes Other PK 12 2021   grade_9 7 46 20 1   1     0   6   44 37 *                     81.0 7 46 20 1   1     0   6   44 37                 81
1680017 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
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
1680085 1680085 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential (District) - Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2021   grade_9 61 0 2 1   0     0   4   37 31 *                     68.0 61 0 2 1   0     0   4   37 31                 68
1680169 1680169 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District) - South Shore Charter Public School   Regular School Yes Other KG 12 2021   grade_9 28 38 4 0   9     0   7   43 42 *                     86.0 28 38 4 0   9     0   7   43 42                 86
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
1680091 1680091 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District) - Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2021   grade_9 40 7 14 0   0     0   7   27 41 *                     68.0 40 7 14 0   0     0   7   27 41                 68
1680156 1680156 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District) - Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2021   grade_9 17 48 18 0   9     0   4   59 37 *                     96.0 17 48 18 0   9     0   4   59 37                 96
1679783 1679783 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter (District) - Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2021   grade_9 2 31 38 0   1     0   1   31 42 *                     73.0 2 31 38 0   1     0   1   31 42                 73
1679932 1679932 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_9 18 59 16 0   3     0   1   46 51 *                     97.0 18 59 16 0   3     0   1   46 51                 97
1679945 1679945 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_9 31 68 7 0   7     0   4   55 62 *                     117.0 31 68 7 0   7     0   4   55 62                 117
1679962 1679962 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District) - Boston Collegiate Charter School   Regular School Yes High 05 12 2021   grade_9 26 38 21 0   2     0   4   53 38 *                     91.0 26 38 21 0   2     0   4   53 38                 91
1679975 1679975 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) - Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2021   grade_9 5 39 47 0   2     0   7   38 62 *                     100.0 5 39 47 0   2     0   7   38 62                 100
1680073 1680073 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   grade_9 47 36 7 0   32     0   3   57 68 *                     125.0 47 36 7 0   32     0   3   57 68                 125
1680119 1680119 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District) - Rising Tide Charter Public School   Regular School Yes High 05 12 2021   grade_9 68 0 5 2   2     0   8   41 43 *                     85.0 68 0 5 2   2     0   8   41 43                 85
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
1680127 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
1680060 1680060 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_9 1 33 50 0   0     0   1   43 42 *                     85.0 1 33 50 0   0     0   1   43 42                 85
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
1679872 1679872 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 2021   grade_9 0 34 9 0   0     0   0   17 26 *                     43.0 0 34 9 0   0     0   0   17 26                 43
1679806 1679806 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_9 3 93 50 0   1     0   1   72 76 *                     148.0 3 93 50 0   1     0   1   72 76                 148
1680079 1680079 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential (District) - Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2021   grade_9 46 7 13 1   1     0   1   39 30 *                     69.0 46 7 13 1   1     0   1   39 30                 69
1679720 1679720 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_9 16 10 148 1   4     1   1   96 85 *                     181.0 16 10 148 1   4     1   1   96 85                 181
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
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
1679755 1679755 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District) - Boston Preparatory Charter Public School   Regular School Yes High 06 12 2021   grade_9 1 80 35 0   0     0   8   62 62 *                     124.0 1 80 35 0   0     0   8   62 62                 124
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
1679826 1679826 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_9 105 0 10 0   20     0   11   80 65 *                     146.0 105 0 10 0   20     0   11   80 65                 146
1679854 1679854 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District) - Community Charter School of Cambridge   Regular School Yes High 06 12 2021   grade_9 3 37 11 0   2     0   2   20 35 *                     55.0 3 37 11 0   2     0   2   20 35                 55
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
1680229 1680229 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_9 19 4 0 0   3     0   5   12 19 *                     31.0 19 4 0 0   3     0   5   12 19                 31
1680208 1680208 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District) - Pioneer Charter School of Science   Regular School Yes Other KG 12 2021   grade_9 24 11 18 2   3     0   2   34 26 *                     60.0 24 11 18 2   3     0   2   34 26                 60
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
1680240 1680240 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science East (District) - Hampden Charter School of Science East   Regular School Yes High 06 12 2021   grade_9 17 20 43 0   2     0   1   47 36 *                     83.0 17 20 43 0   2     0   1   47 36                 83
1679727 1679727 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District) - Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2021   grade_9 7 35 42 0   1     0   2   43 44 *                     87.0 7 35 42 0   1     0   2   43 44                 87
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
1680374 1680374 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District - Ayer Shirley Regional High School   Regular School No High 09 12 2021   grade_9 75 2 11 1   5     2   3   54 45 *                     99.0 75 2 11 1   5     2   3   54 45                 99
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
1681453 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
1681467 1681467 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II) (District) - Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2021   grade_9 17 21 16 0   7     0   1   39 23 *                     62.0 17 21 16 0   7     0   1   39 23                 62
1681433 1681433 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School (District) - Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2021   grade_9 2 4 63 0   0     0   0   32 37 *                     69.0 2 4 63 0   0     0   0   32 37                 69
1681440 1681440 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District) - Baystate Academy Charter Public School   Regular School Yes High 06 12 2021   grade_9 5 15 46 0   2     1   1   41 29 *                     70.0 5 15 46 0   2     1   1   41 29                 70
1681527 1681527 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_9 81 8 27 1   4     1   10   62 68 2                     132.0 81 8 27 1   4     1   10   62 68 2               132
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
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
1681471 1681471 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield (District) - Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2021   grade_9 6 19 120 1   0     1   2   85 64 *                     149.0 6 19 120 1   0     1   2   85 64                 149
1681540 1681540 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District - TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_9 240 34 60 0   6     0   21   167 193 *                     361.0 240 34 60 0   6     0   21   167 193                 361
1681491 1681491 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_9 2 87 7 1   0     0   1   53 45 *                     98.0 2 87 7 1   0     0   1   53 45                 98
1681508 1681508 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_9 33 8 16 0   1     0   1   37 22 *                     59.0 33 8 16 0   1     0   1   37 22                 59
1681511 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
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
1672018 1672018 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_9 122 5 16 0   3     0   0   88 58 *                     146.0 122 5 16 0   3     0   0   88 58                 146
1680289 1680289 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough - Acton-Boxborough Regional High   Regular School No High 09 12 2021   grade_9 206 8 27 1   149     0   15   221 185 *                     406.0 206 8 27 1   149     0   15   221 185                 406
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
1672058 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
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
1680310 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
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
1672199 1672199 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_9 271 9 23 0   41     1   18   161 201 *                     363.0 271 9 23 0   41     1   18   161 201                 363
1680331 1680331 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Ashburnham-Westminster - Oakmont Regional High School   Regular School No High 09 12 2021   grade_9 146 4 12 1   2     0   1   90 76 *                     166.0 146 4 12 1   2     0   1   90 76                 166
1672213 1672213 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland - Ashland High   Regular School No High 09 12 2021   grade_9 128 3 25 2   31     0   6   97 98 *                     195.0 128 3 25 2   31     0   6   97 98                 195
1681320 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
1680353 1680353 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol-Royalston - Athol High   Regular School No High 09 12 2021   grade_9 71 4 22 0   1     0   2   49 51 *                     100.0 71 4 22 0   1     0   2   49 51                 100
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
1672276 1672276 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn - Auburn Senior High   Regular School No High 09 12 2021   grade_9 136 3 14 0   9     0   6   84 84 *                     168.0 136 3 14 0   9     0   6   84 84                 168
1672291 1672291 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_9 23 16 7 1   3     0   3   33 20 *                     53.0 23 16 7 1   3     0   3   33 20                 53
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
1672336 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
1672350 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
1672368 1672368 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_9 122 3 15 0   8     0   6   88 66 *                     154.0 122 3 15 0   8     0   6   88 66                 154
1672372 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
1672401 1672401 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont - Belmont High   Regular School No High 09 12 2021   grade_9 225 14 19 1   52     0   23   169 165 *                     334.0 225 14 19 1   52     0   23   169 165                 334
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
1680409 1680409 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston - Tahanto Regional High   Regular School No High 06 12 2021   grade_9 66 1 10 0   7     0   1   45 40 *                     85.0 66 1 10 0   7     0   1   45 40                 85
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
1672483 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
1681324 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
1680429 1680429 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone-Millville - Blackstone Millville RHS   Regular School No High 09 12 2021   grade_9 88 2 4 0   0     0   5   60 38 *                     99.0 88 2 4 0   0     0   5   60 38                 99
1681328 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
1673219 1673219 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_9 197 38 72 0   97     0   20   209 215 *                     424.0 197 38 72 0   97     0   20   209 215                 424
1673198 1673198 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston - Boston Latin Academy   Regular School No High 07 12 2021   grade_9 92 76 87 0   48     0   6   113 195 *                     309.0 92 76 87 0   48     0   6   113 195                 309
1673233 1673233 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston - O'Bryant School Math/Science   Regular School No High 07 12 2021   grade_9 32 114 104 1   65     1   6   136 187 *                     323.0 32 114 104 1   65     1   6   136 187                 323
1673135 1673135 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston - Brighton High   Regular School No High 09 12 2021   grade_9 3 19 30 0   3     0   2   29 28 *                     57.0 3 19 30 0   3     0   2   29 28                 57
1672568 1672568 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston - Carter School   Regular School No High 07 12 2021   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673144 1673144 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston - Charlestown High   Regular School No High 09 12 2021   grade_9 4 22 82 1   6     0   3   61 57 *                     118.0 4 22 82 1   6     0   3   61 57                 118
1673264 1673264 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Boston - Snowden International School at Copley   Regular School No High 09 12 2021   grade_9 8 36 72 0   9     0   1   64 62 *                     126.0 8 36 72 0   9     0   1   64 62                 126
1672612 1672612 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_9 1 61 24 0   0     1   3   46 44 *                     90.0 1 61 24 0   0     1   3   46 44                 90
1673164 1673164 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston - East Boston High   Regular School No High 09 12 2021   grade_9 23 14 166 0   1     0   3   113 94 *                     207.0 23 14 166 0   1     0   3   113 94                 207
1673159 1673159 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   grade_9 3 44 31 0   1     0   2   50 31 *                     81.0 3 44 31 0   1     0   2   50 31                 81
1673174 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
1673169 1673169 MA Suffolk   school 2502790 35   Boston 250279000327 350535 Boston - The English High   Regular School No High 09 12 2021   grade_9 5 44 43 1   1     0   6   54 46 *                     100.0 5 44 43 1   1     0   6   54 46                 100
1673020 1673020 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_9 1 10 13 0   0     0   2   21 5 *                     26.0 1 10 13 0   0     0   2   21 5                 26

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