Data source: Big Local News · About: Big Local

499 rows where grade = "grade_8", state = "MA" and year = 2021 sorted by white

View and edit SQL

year

  • 2021 · 499

grade

  • grade_8 · 499
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
1674758 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1674916 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_8 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1675667 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_8 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1675706 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1678259 MA Hampden   school 2511130 281   Springfield 251113002916 2810318 Springfield - Emergence Academy   Regular School No Middle 06 08 2021   grade_8 * * * *   *     *   *   4 * *                     5.0                         4                   5
1680452 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_8 * * * *   *     *   *   1 * *                     1.0                         1                   1
1672783 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_8 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1673284 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_8 0 3 6 0   0     0   0   7 2 *                     9.0 0 3 6 0   0     0   0   7 2                 9
1678285 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield - Balliet Middle School   Regular School No Middle 06 08 2021   grade_8 0 4 6 0   0     0   0   8 * *                     10.0 0 4 6 0   0     0   0   8                   10
1679768 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District) - Bridge Boston Charter School   Regular School Yes Elementary PK 08 2021   grade_8 0 12 5 0   0     0   3   11 9 *                     20.0 0 12 5 0   0     0   3   11 9                 20
1679774 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public (District) - Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2021   grade_8 0 61 19 0   0     0   0   44 36 *                     80.0 0 61 19 0   0     0   0   44 36                 80
1679796 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District) - Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 08 2021   grade_8 0 0 38 0   0     0   0   20 18 *                     38.0 0 0 38 0   0     0   0   20 18                 38
1679871 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_8 0 19 2 0   0     0   0   9 12 *                     21.0 0 19 2 0   0     0   0   9 12                 21
1679885 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District) - Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2021   grade_8 0 17 12 0   0     0   1   16 14 *                     30.0 0 17 12 0   0     0   1   16 14                 30
1680029 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School (District) - KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2021   grade_8 0 33 26 0   0     0   0   37 22 *                     59.0 0 33 26 0   0     0   0   37 22                 59
1672538 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston - Jackson Mann   Regular School No Elementary PK 08 2021   grade_8 1 17 17 0   2     0   0   21 16 *                     37.0 1 17 17 0   2     0   0   21 16                 37
1672625 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_8 1 17 23 0   0     1   3   22 23 *                     45.0 1 17 23 0   0     1   3   22 23                 45
1672896 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_8 1 42 46 0   0     1   0   44 46 *                     90.0 1 42 46 0   0     1   0   44 46                 90
1673041 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_8 1 12 5 0   0     0   1   11 8 *                     19.0 1 12 5 0   0     0   1   11 8                 19
1673094 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_8 1 19 24 0   0     0   0   22 22 *                     44.0 1 19 24 0   0     0   0   22 22                 44
1673134 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston - James P Timilty Middle   Regular School No Middle 06 08 2021   grade_8 1 36 54 0   2     0   0   46 47 *                     93.0 1 36 54 0   2     0   0   46 47                 93
1673453 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_8 1 3 4 0   0     0   0   7 1 *                     8.0 1 3 4 0   0     0   0   7 1                 8
1674296 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_8 1 1 3 0   0     0   1   5 1 *                     6.0 1 1 3 0   0     0   1   5 1                 6
1675069 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke - Kelly Elementary   Regular School No Elementary PK 08 2021   grade_8 1 1 46 0   0     0   0   26 22 *                     48.0 1 1 46 0   0     0   0   26 22                 48
1678277 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield - Springfield Public Day Middle School   Regular School No Middle 06 08 2021   grade_8 1 7 11 0   0     0   2   17 4 *                     21.0 1 7 11 0   0     0   2   17 4                 21
1679754 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_8 1 73 26 0   1     0   4   57 48 *                     105.0 1 73 26 0   1     0   4   57 48                 105
1679839 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District) - Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2021   grade_8 1 0 33 0   1     0   0   16 19 *                     35.0 1 0 33 0   1     0   0   16 19                 35
1679987 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter (District) - Holyoke Community Charter School   Regular School Yes Elementary KG 08 2021   grade_8 1 0 67 0   1     0   2   39 32 *                     71.0 1 0 67 0   1     0   2   39 32                 71
1679997 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District) - Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2021   grade_8 1 1 75 0   0     0   0   29 48 *                     77.0 1 1 75 0   0     0   0   29 48                 77
1680016 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public (District) - Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2021   grade_8 1 18 31 0   15     0   4   38 31 *                     69.0 1 18 31 0   15     0   4   38 31                 69
1680059 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_8 1 42 40 0   1     0   4   34 54 *                     88.0 1 42 40 0   1     0   4   34 54                 88
1680126 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_8 1 143 107 0   1     0   2   129 125 *                     254.0 1 143 107 0   1     0   2   129 125                 254
1680146 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Learning First Charter Public School (District) - Learning First Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 1 35 33 0   0     0   2   35 36 *                     71.0 1 35 33 0   0     0   2   35 36                 71
1673828 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea - Clark Avenue School   Regular School No Middle 05 08 2021   grade_8 10 4 141 1   2     0   2   91 69 *                     160.0 10 4 141 1   2     0   2   91 69                 160
1675105 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke - Holyoke STEM Academy   Regular School No Middle 06 08 2021   grade_8 10 5 78 0   2     0   2   54 43 *                     97.0 10 5 78 0   2     0   2   54 43                 97
1675252 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence - Parthum Middle School   Regular School No Middle 05 08 2021   grade_8 10 3 146 0   1     0   0   72 86 *                     160.0 10 3 146 0   1     0   0   72 86                 160
1677907 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Somerville - Arthur D Healey   Regular School No Elementary PK 08 2021   grade_8 10 11 23 0   4     0   3   23 28 *                     51.0 10 11 23 0   4     0   3   23 28                 51
1677936 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 Somerville - E Somerville Community   Regular School No Elementary KG 08 2021   grade_8 10 4 58 1   3     0   0   34 42 *                     76.0 10 4 58 1   3     0   0   34 42                 76
1672250 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_8 100 9 41 0   9     0   5   94 70 *                     164.0 100 9 41 0   9     0   5   94 70                 164
1673943 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_8 100 4 0 0   1     0   3   64 44 *                     108.0 100 4 0 0   1     0   3   64 44                 108
1678700 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Walpole - Bird Middle   Regular School No Middle 06 08 2021   grade_8 100 9 11 0   5     0   3   63 65 *                     128.0 100 9 11 0   5     0   3   63 65                 128
1676046 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_8 101 6 5 8   5     0   16   69 72 *                     141.0 101 6 5 8   5     0   16   69 72                 141
1680309 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_8 101 14 40 0   26     0   22   115 88 *                     203.0 101 14 40 0   26     0   22   115 88                 203
1680896 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett - Narragansett Regional High   Regular School No High 08 12 2021   grade_8 101 1 10 0   0     1   4   61 56 *                     117.0 101 1 10 0   0     1   4   61 56                 117
1674948 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_8 102 7 36 0   2     0   0   72 74 *                     147.0 102 7 36 0   2     0   0   72 74                 147
1676764 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams - Drury High   Regular School No High 07 12 2021   grade_8 102 2 7 0   1     1   12   59 66 *                     125.0 102 2 7 0   1     1   12   59 66                 125
1680737 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_8 102 1 9 0   1     0   4   57 60 *                     117.0 102 1 9 0   1     0   4   57 60                 117
1679038 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford - Blanchard Middle   Regular School No Middle 06 08 2021   grade_8 104 7 6 2   54     0   10   97 86 *                     183.0 104 7 6 2   54     0   10   97 86                 183
1679069 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston - Weston Middle   Regular School No Middle 06 08 2021   grade_8 104 16 14 0   28     0   13   99 76 *                     175.0 104 16 14 0   28     0   13   99 76                 175
1675486 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton - Littleton Middle School   Regular School No Middle 06 08 2021   grade_8 105 1 8 0   10     0   4   66 62 *                     128.0 105 1 8 0   10     0   4   66 62                 128
1676712 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Newton - Bigelow Middle   Regular School No Middle 06 08 2021   grade_8 105 11 23 0   23     0   12   78 96 *                     174.0 105 11 23 0   23     0   12   78 96                 174
1678460 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton - Sutton Middle School   Regular School No Middle 06 08 2021   grade_8 106 1 4 0   1     0   6   55 63 *                     118.0 106 1 4 0   1     0   6   55 63                 118
1679083 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport - Westport Junior/Senior High School   Regular School No High 07 12 2021   grade_8 106 1 7 0   1     0   9   75 48 *                     124.0 106 1 7 0   1     0   9   75 48                 124
1681314 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_8 106 1 6 2   3     0   1   59 60 *                     119.0 106 1 6 2   3     0   1   59 60                 119
1676721 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton - Oak Hill Middle   Regular School No Middle 06 08 2021   grade_8 107 7 10 0   55     0   13   108 84 *                     192.0 107 7 10 0   55     0   13   108 84                 192
1680617 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_8 107 3 10 0   2     0   4   70 56 *                     126.0 107 3 10 0   2     0   4   70 56                 126
1681075 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar - Ralph C Mahar Regional   Regular School No High 07 12 2021   grade_8 107 2 9 1   2     0   6   75 52 *                     127.0 107 2 9 1   2     0   6   75 52                 127
1674665 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin - Annie Sullivan Middle School   Regular School No Middle 06 08 2021   grade_8 108 2 10 1   4     0   0   70 55 *                     125.0 108 2 10 1   4     0   0   70 55                 125
1677065 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford - Oxford High   Regular School No High 08 12 2021   grade_8 108 2 22 0   2     0   6   70 70 *                     140.0 108 2 22 0   2     0   6   70 70                 140
1680373 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District - Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2021   grade_8 108 4 19 1   1     0   4   79 58 *                     137.0 108 4 19 1   1     0   4   79 58                 137
1678703 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Walpole - Eleanor N Johnson Middle   Regular School No Middle 06 08 2021   grade_8 110 7 8 2   10     0   4   73 68 *                     141.0 110 7 8 2   10     0   4   73 68                 141
1681258 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett - Central Tree Middle   Regular School No Middle 06 08 2021   grade_8 111 2 8 0   4     0   3   65 63 *                     128.0 111 2 8 0   4     0   3   65 63                 128
1676910 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge - Northbridge Middle   Regular School No Middle 05 08 2021   grade_8 112 3 16 0   2     0   11   68 76 *                     144.0 112 3 16 0   2     0   11   68 76                 144
1680572 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_8 112 2 10 1   1     0   1   65 61 *                     127.0 112 2 10 1   1     0   1   65 61                 127
1674952 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_8 113 15 85 1   7     0   3   118 106 *                     224.0 113 15 85 1   7     0   3   118 106                 224
1676286 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury - Millbury Junior/Senior High   Regular School No High 07 12 2021   grade_8 114 5 12 0   8     0   12   85 65 *                     151.0 114 5 12 0   8     0   12   85 65                 151
1681122 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_8 115 1 5 0   1     0   2   60 64 *                     124.0 115 1 5 0   1     0   2   60 64                 124
1677244 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield - John T Reid Middle   Regular School No Middle 06 08 2021   grade_8 116 27 18 1   0     0   13   86 89 *                     175.0 116 27 18 1   0     0   13   86 89                 175
1677507 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Reading - Arthur W Coolidge Middle   Regular School No Middle 06 08 2021   grade_8 116 2 3 0   1     0   2   69 55 *                     124.0 116 2 3 0   1     0   2   69 55                 124
1675193 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_8 117 3 12 0   3     0   1   64 72 *                     136.0 117 3 12 0   3     0   1   64 72                 136
1673762 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_8 118 0 5 1   0     1   0   71 54 *                     125.0 118 0 5 1   0     1   0   71 54                 125
1676585 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford - Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_8 118 47 138 0   1     1   17   167 155 *                     322.0 118 47 138 0   1     1   17   167 155                 322
1678021 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley - Michael E. Smith Middle School   Regular School No Middle 05 08 2021   grade_8 118 1 25 0   1     0   2   59 88 *                     147.0 118 1 25 0   1     0   2   59 88                 147
1680707 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham - Miles River Middle   Regular School No Middle 06 08 2021   grade_8 118 1 5 0   3     0   3   66 64 *                     130.0 118 1 5 0   3     0   3   66 64                 130
1672144 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_8 119 6 14 0   29     0   7   97 78 *                     175.0 119 6 14 0   29     0   7   97 78                 175
1673901 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee - Dupont Middle   Regular School No Middle 06 08 2021   grade_8 119 11 117 0   10     0   9   149 117 *                     266.0 119 11 117 0   10     0   9   149 117                 266
1673005 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_8 12 5 11 0   1     0   4   13 20 *                     33.0 12 5 11 0   1     0   4   13 20                 33
1678280 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield - STEM Middle Academy   Regular School No Middle 06 08 2021   grade_8 12 18 58 0   1     0   3   52 40 *                     92.0 12 18 58 0   1     0   3   52 40                 92
1674914 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_8 120 13 39 0   4     0   3   89 90 *                     179.0 120 13 39 0   4     0   3   89 90                 179
1680428 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville - Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2021   grade_8 120 0 18 0   2     0   5   62 83 *                     145.0 120 0 18 0   2     0   5   62 83                 145
1680551 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn - Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2021   grade_8 120 8 4 0   22     0   8   93 69 *                     162.0 120 8 4 0   22     0   8   93 69                 162
1672077 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_8 121 5 11 0   3     1   6   70 77 *                     147.0 121 5 11 0   3     1   6   70 77                 147
1680490 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire - Nessacus Regional Middle School   Regular School No Middle 06 08 2021   grade_8 121 2 7 0   0     0   6   79 57 *                     136.0 121 2 7 0   0     0   6   79 57                 136
1679323 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop - Winthrop Middle School   Regular School No Middle 06 08 2021   grade_8 122 3 30 0   1     0   1   70 87 *                     157.0 122 3 30 0   1     0   1   70 87                 157
1676404 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick - J F Kennedy Middle School   Regular School No Middle 05 08 2021   grade_8 123 4 11 0   15     0   14   96 71 *                     167.0 123 4 11 0   15     0   14   96 71                 167
1678790 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham - Wareham Senior High   Regular School No High 08 12 2021   grade_8 123 10 11 2   1     0   17   89 75 *                     164.0 123 10 11 2   1     0   17   89 75                 164
1676579 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_8 124 44 137 0   5     0   26   184 152 *                     336.0 124 44 137 0   5     0   26   184 152                 336
1680543 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_8 124 1 4 0   0     0   7   70 66 *                     136.0 124 1 4 0   0     0   7   70 66                 136
1680778 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional - Manchester Essex Regional Middle School   Regular School No Middle 06 08 2021   grade_8 124 0 0 0   2     0   2   61 67 *                     128.0 124 0 0 0   2     0   2   61 67                 128
1680966 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_8 124 2 0 0   5     0   3   74 60 *                     134.0 124 2 0 0   5     0   3   74 60                 134
1674339 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_8 125 1 7 2   4     0   5   76 68 *                     144.0 125 1 7 2   4     0   5   76 68                 144
1674423 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River - Morton Middle   Regular School No Middle 06 08 2021   grade_8 125 20 48 1   6     1   18   103 116 *                     219.0 125 20 48 1   6     1   18   103 116                 219
1675390 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster - Sky View Middle School   Regular School No Middle 06 08 2021   grade_8 125 27 115 0   8     0   13   143 145 *                     288.0 125 27 115 0   8     0   13   143 145                 288
1679376 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_8 125 14 18 0   12     0   6   81 94 *                     175.0 125 14 18 0   12     0   6   81 94                 175
1678627 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge - Uxbridge High   Regular School No High 08 12 2021   grade_8 126 1 8 4   3     0   1   70 73 *                     143.0 126 1 8 4   3     0   1   70 73                 143
1673791 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford - Col Moses Parker School   Regular School No Middle 05 08 2021   grade_8 127 4 15 2   29     0   5   110 72 *                     182.0 127 4 15 2   29     0   5   110 72                 182
1673795 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_8 127 7 11 0   22     0   10   104 73 *                     177.0 127 7 11 0   22     0   10   104 73                 177
1674686 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner - Gardner High   Regular School No High 08 12 2021   grade_8 127 5 46 0   5     0   22   107 97 *                     205.0 127 5 46 0   5     0   22   107 97                 205
1672246 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_8 128 12 23 0   6     0   11   99 81 *                     180.0 128 12 23 0   6     0   11   99 81                 180
1676900 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough - Robert E. Melican Middle School   Regular School No Middle 06 08 2021   grade_8 129 1 19 2   20     3   9   89 94 *                     183.0 129 1 19 2   20     3   9   89 94                 183

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