Data source: Big Local News · About: Big Local

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

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
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
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
1674432 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_8 4 2 3 0   0     0   1   8 2 *                     10.0 4 2 3 0   0     0   1   8 2                 10
1675615 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_8 4 0 6 0   0     0   0   9 * *                     10.0 4 0 6 0   0     0   0   9                   10
1675843 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_8 3 0 4 1   0     0   2   8 2 *                     10.0 3 0 4 1   0     0   2   8 2                 10
1676593 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_8 2 2 5 0   0     0   1   6 4 *                     10.0 2 2 5 0   0     0   1   6 4                 10
1677347 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_8 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
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
1679846 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_8 76 3 7 0   13     0   1   54 46 *                     100.0 76 3 7 0   13     0   1   54 46                 100
1680387 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_8 79 3 11 0   2     0   5   60 40 *                     100.0 79 3 11 0   2     0   5   60 40                 100
1674094 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas - Douglas Middle School   Regular School No Middle 06 08 2021   grade_8 94 1 3 0   1     0   2   47 54 *                     101.0 94 1 3 0   1     0   2   47 54                 101
1679266 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon - Murdock Middle School   Regular School No Middle 06 08 2021   grade_8 83 5 6 0   4     1   2   53 48 *                     101.0 83 5 6 0   4     1   2   53 48                 101
1678302 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Springfield - Rise Academy at Van Sickle   Regular School No Middle 06 08 2021   grade_8 7 20 72 0   0     0   4   59 44 *                     103.0 7 20 72 0   0     0   4   59 44                 103
1672758 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston - John W McCormack   Regular School No Middle 06 08 2021   grade_8 5 35 60 0   3     0   2   42 63 *                     105.0 5 35 60 0   3     0   2   42 63                 105
1679642 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_8 9 14 68 1   11     0   2   54 51 *                     105.0 9 14 68 1   11     0   2   54 51                 105
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
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
1675535 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell - Rogers STEM Academy   Regular School No Elementary KG 08 2021   grade_8 15 19 49 0   23     0   2   50 58 *                     108.0 15 19 49 0   23     0   2   50 58                 108
1672032 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_8 99 0 4 0   1     0   5   59 50 *                     109.0 99 0 4 0   1     0   5   59 50                 109
1681476 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_8 69 10 24 0   1     0   5   58 51 *                     109.0 69 10 24 0   1     0   5   58 51                 109
1681526 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_8 64 4 20 0   9     0   12   57 52 0                     109.0 64 4 20 0   9     0   12   57 52 0               109
1680185 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_8 82 3 16 0   2     0   7   49 61 *                     110.0 82 3 16 0   2     0   7   49 61                 110
1675505 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow - Glenbrook Middle   Regular School No Middle 06 08 2021   grade_8 80 2 8 0   18     1   2   56 55 *                     111.0 80 2 8 0   18     1   2   56 55                 111
1679931 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_8 19 61 31 0   0     0   0   54 57 *                     111.0 19 61 31 0   0     0   0   54 57                 111
1680352 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_8 90 0 14 1   3     0   3   68 43 *                     111.0 90 0 14 1   3     0   3   68 43                 111
1675248 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_8 2 2 108 0   0     0   0   57 55 *                     112.0 2 2 108 0   0     0   0   57 55                 112
1675265 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_8 2 1 109 0   0     0   0   59 53 *                     112.0 2 1 109 0   0     0   0   59 53                 112
1675515 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow - Williams Middle   Regular School No Middle 06 08 2021   grade_8 94 1 3 0   7     0   7   59 53 *                     112.0 94 1 3 0   7     0   7   59 53                 112
1678966 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater - West Bridgewater Junior/Senior   Regular School No High 07 12 2021   grade_8 96 5 5 0   1     0   5   52 60 *                     112.0 96 5 5 0   1     0   5   52 60                 112
1675339 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester - Leicester Middle   Regular School No Middle 05 08 2021   grade_8 82 7 16 0   3     0   5   64 49 *                     113.0 82 7 16 0   3     0   5   64 49                 113
1674193 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton - White Brook Middle School   Regular School No Middle 05 08 2021   grade_8 88 1 17 1   6     0   1   55 59 *                     114.0 88 1 17 1   6     0   1   55 59                 114
1678771 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware - Ware Junior/Senior High School   Regular School No High 07 12 2021   grade_8 99 3 7 0   0     1   4   57 57 *                     114.0 99 3 7 0   0     1   4   57 57                 114
1675921 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden - Salemwood   Regular School No Elementary KG 08 2021   grade_8 21 26 40 0   23     0   5   47 68 *                     115.0 21 26 40 0   23     0   5   47 68                 115
1674819 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield - Greenfield High   Regular School No High 08 12 2021   grade_8 85 2 22 0   2     0   5   61 55 *                     116.0 85 2 22 0   2     0   5   61 55                 116
1673128 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston - Clarence R Edwards Middle   Regular School No Middle 06 08 2021   grade_8 13 17 84 0   2     0   1   60 57 *                     117.0 13 17 84 0   2     0   1   60 57                 117
1675893 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_8 22 26 43 0   18     0   8   60 57 *                     117.0 22 26 43 0   18     0   8   60 57                 117
1677419 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Quincy - Broad Meadows Middle   Regular School No Middle 06 08 2021   grade_8 74 13 9 0   20     0   1   58 59 *                     117.0 74 13 9 0   20     0   1   58 59                 117
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
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
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
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
1675692 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg - Lunenburg Middle School   Regular School No Middle 06 08 2021   grade_8 99 1 16 0   0     1   3   62 57 *                     120.0 99 1 16 0   0     1   3   62 57                 120
1681143 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_8 92 4 13 1   3     0   7   61 59 *                     120.0 92 4 13 1   3     0   7   61 59                 120
1673259 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_8 6 73 36 0   2     0   4   61 60 *                     121.0 6 73 36 0   2     0   4   61 60                 121
1677080 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer - Palmer High   Regular School No High 06 12 2021   grade_8 94 4 12 0   3     0   8   53 68 *                     121.0 94 4 12 0   3     0   8   53 68                 121
1674318 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_8 13 18 84 0   4     0   4   55 68 *                     123.0 13 18 84 0   4     0   4   55 68                 123
1674668 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_8 99 5 8 0   10     0   1   66 57 *                     123.0 99 5 8 0   10     0   1   66 57                 123
1679904 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_8 20 31 57 0   7     0   8   63 60 *                     123.0 20 31 57 0   7     0   8   63 60                 123
1681490 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_8 4 110 6 0   1     0   2   58 65 *                     123.0 4 110 6 0   1     0   2   58 65                 123
1673416 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_8 16 79 19 1   2     0   7   58 66 *                     124.0 16 79 19 1   2     0   7   58 66                 124
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
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
1679818 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_8 9 20 84 0   7     0   4   64 60 *                     124.0 9 20 84 0   7     0   4   64 60                 124
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
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
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
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
1678613 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough - Tyngsborough Middle   Regular School No Middle 06 08 2021   grade_8 96 7 14 0   6     0   2   69 56 *                     125.0 96 7 14 0   6     0   2   69 56                 125
1679825 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_8 87 2 8 0   19     0   9   65 60 *                     125.0 87 2 8 0   19     0   9   65 60                 125
1676206 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_8 57 2 57 0   5     0   5   53 73 *                     126.0 57 2 57 0   5     0   5   53 73                 126
1680072 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_8 56 21 19 0   25     0   5   62 64 *                     126.0 56 21 19 0   25     0   5   62 64                 126
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
1673824 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_8 8 7 110 0   0     0   2   55 72 *                     127.0 8 7 110 0   0     0   2   55 72                 127
1680097 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District) - UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2021   grade_8 3 54 67 0   0     1   2   62 65 *                     127.0 3 54 67 0   0     1   2   62 65                 127
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
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
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
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
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
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
1676368 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Nantucket - Cyrus Peirce   Regular School No Middle 06 08 2021   grade_8 61 13 46 0   3     0   6   64 65 *                     129.0 61 13 46 0   3     0   6   64 65                 129
1679771 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public (District) - Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2021   grade_8 60 11 34 0   15     0   9   66 62 *                     129.0 60 11 34 0   15     0   9   66 62                 129
1674532 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_8 13 0 0 0   0     0   0   8 5 *                     13.0 13 0 0 0   0     0   0   8 5                 13
1677986 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 Southborough - P Brent Trottier   Regular School No Middle 06 08 2021   grade_8 94 1 11 0   17     0   7   68 62 *                     130.0 94 1 11 0   17     0   7   68 62                 130
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
1672147 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_8 62 3 12 1   50     0   3   73 58 *                     131.0 62 3 12 1   50     0   3   73 58                 131
1674309 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_8 35 15 73 1   4     0   4   70 62 *                     132.0 35 15 73 1   4     0   4   70 62                 132
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
1672254 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_8 85 11 21 0   11     0   7   64 71 *                     135.0 85 11 21 0   11     0   7   64 71                 135
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
1678000 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge - Southbridge Middle School   Regular School No Middle 06 08 2021   grade_8 45 7 79 0   3     0   2   72 64 *                     136.0 45 7 79 0   3     0   2   72 64                 136
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
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
1673832 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_8 4 1 132 0   0     0   0   71 66 *                     137.0 4 1 132 0   0     0   0   71 66                 137
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
1674290 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_8 31 21 76 0   7     0   3   69 69 *                     138.0 31 21 76 0   7     0   3   69 69                 138
1676122 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford - Madeleine Dugger Andrews   Regular School No Middle 06 08 2021   grade_8 97 9 10 1   11     0   11   80 59 *                     139.0 97 9 10 1   11     0   11   80 59                 139
1676226 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen - Donald P Timony Grammar   Regular School No Elementary PK 08 2021   grade_8 57 2 64 1   7     0   8   75 64 *                     139.0 57 2 64 1   7     0   8   75 64                 139
1672886 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_8 7 3 2 0   1     0   1   6 8 *                     14.0 7 3 2 0   1     0   1   6 8                 14
1680721 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham - Green Meadows Elementary   Regular School No Elementary PK 08 2021   grade_8 9 1 4 0   0     0   0   4 10 *                     14.0 9 1 4 0   0     0   0   4 10                 14
1675629 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell - B.F. Butler Middle School   Regular School No Middle 05 08 2021   grade_8 31 10 51 0   40     0   8   72 68 *                     140.0 31 10 51 0   40     0   8   72 68                 140
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
1674924 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill - Dr Paul Nettle   Regular School No Middle 05 08 2021   grade_8 62 6 60 1   6     1   5   67 74 *                     141.0 62 6 60 1   6     1   5   67 74                 141
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
1676125 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 Medford - John J. McGlynn Middle School   Regular School No Middle 06 08 2021   grade_8 62 34 27 0   13     0   5   69 72 *                     141.0 62 34 27 0   13     0   5   69 72                 141
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
1673107 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston - Lilla G. Frederick Middle School   Regular School No Middle 06 08 2021   grade_8 2 62 66 0   9     0   4   78 65 *                     143.0 2 62 66 0   9     0   4   78 65                 143
1673928 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton - Clinton Middle School   Regular School No Middle 05 08 2021   grade_8 91 8 39 0   1     1   3   84 59 *                     143.0 91 8 39 0   1     1   3   84 59                 143
1676196 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   grade_8 96 3 34 0   2     0   8   75 68 *                     143.0 96 3 34 0   2     0   8   75 68                 143

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