enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 499 ✖

grade ✖

  • grade_7 · 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
2041274 2041274 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_7 * * * *   *     *   *   1 *                       1.0                         1                   1
2044123 2044123 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2019   grade_7 75 1 12 0   6     0   6   54 46                       100.0 75 1 12 0   6     0   6   54 46                 100
2047654 2047654 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_7 68 3 12 0   6     0   11   46 54                       100.0 68 3 12 0   6     0   11   46 54                 100
2040453 2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2043708 2043708 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_7 25 18 15 0   41     1   1   57 44                       101.0 25 18 15 0   41     1   1   57 44                 101
2046098 2046098 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_7 3 11 85 0   0     0   2   52 49                       101.0 3 11 85 0   0     0   2   52 49                 101
2048892 2048892 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   grade_7 93 0 6 0   1     0   2   60 42                       102.0 93 0 6 0   1     0   2   60 42                 102
2044027 2044027 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   grade_7 65 3 25 0   6     0   4   43 60                       103.0 65 3 25 0   6     0   4   43 60                 103
2041784 2041784 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_7 95 3 3 0   3     0   1   55 50                       105.0 95 3 3 0   3     0   1   55 50                 105
2044909 2044909 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_7 84 1 10 0   4     0   6   49 56                       105.0 84 1 10 0   4     0   6   49 56                 105
2048735 2048735 MA Middlesex   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2019   grade_7 99 0 1 0   1     0   4   48 57                       105.0 99 0 1 0   1     0   4   48 57                 105
2049310 2049310 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_7 69 13 16 0   2     0   6   62 44                       106.0 69 13 16 0   2     0   6   62 44                 106
2046061 2046061 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2019   grade_7 19 25 57 0   2     0   4   62 45                       107.0 19 25 57 0   2     0   4   62 45                 107
2046592 2046592 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2019   grade_7 94 2 5 0   0     0   6   53 54                       107.0 94 2 5 0   0     0   6   53 54                 107
2040935 2040935 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_7 7 18 67 0   13     0   3   64 44                       108.0 7 18 67 0   13     0   3   64 44                 108
2043353 2043353 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_7 85 1 9 0   10     0   3   50 58                       108.0 85 1 9 0   10     0   3   50 58                 108
2047451 2047451 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_7 5 12 78 0   9     0   4   57 51                       108.0 5 12 78 0   9     0   4   57 51                 108
2043147 2043147 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_7 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2042841 2042841 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_7 64 18 15 0   5     0   8   62 48                       110.0 64 18 15 0   5     0   8   62 48                 110
2047991 2047991 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_7 87 5 14 0   2     0   2   53 57                       110.0 87 5 14 0   2     0   2   53 57                 110
2048335 2048335 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_7 99 2 4 0   1     0   4   62 48                       110.0 99 2 4 0   1     0   4   62 48                 110
2042149 2042149 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_7 22 22 54 1   6     0   6   50 61                       111.0 22 22 54 1   6     0   6   50 61                 111
2043866 2043866 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_7 89 4 2 6   3     0   7   66 45                       111.0 89 4 2 6   3     0   7   66 45                 111
2041248 2041248 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_7 17 74 14 0   0     1   7   61 52                       113.0 17 74 14 0   0     1   7   61 52                 113
2042124 2042124 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_7 41 10 50 2   7     1   2   57 56                       113.0 41 10 50 2   7     1   2   57 56                 113
2042158 2042158 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_7 12 18 80 0   3     0   0   53 60                       113.0 12 18 80 0   3     0   0   53 60                 113
2043086 2043086 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_7 2 2 108 0   1     0   0   50 63                       113.0 2 2 108 0   1     0   0   50 63                 113
2043103 2043103 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 106 0   0     0   0   61 52                       113.0 7 0 106 0   0     0   0   61 52                 113
2046104 2046104 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2019   grade_7 17 20 72 1   2     0   1   51 62                       113.0 17 20 72 1   2     0   1   51 62                 113
2046276 2046276 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2019   grade_7 103 2 2 0   3     0   3   56 57                       113.0 103 2 2 0   3     0   3   56 57                 113
2048575 2048575 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_7 107 0 3 0   1     0   2   59 54                       113.0 107 0 3 0   1     0   2   59 54                 113
2048945 2048945 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_7 101 0 7 0   1     0   4   57 56                       113.0 101 0 7 0   1     0   4   57 56                 113
2044587 2044587 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   grade_7 100 4 4 0   1     0   5   61 53                       114.0 100 4 4 0   1     0   5   61 53                 114
2047737 2047737 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_7 29 63 17 0   3     1   1   57 57                       114.0 29 63 17 0   3     1   1   57 57                 114
2049326 2049326 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_7 3 101 9 1   0     0   0   62 52                       114.0 3 101 9 1   0     0   0   62 52                 114
2041069 2041069 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_7 2 60 45 0   4     0   4   57 58                       115.0 2 60 45 0   4     0   4   57 58                 115
2048700 2048700 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2019   grade_7 108 0 4 0   0     0   3   63 52                       115.0 108 0 4 0   0     0   3   63 52                 115
2043343 2043343 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2019   grade_7 79 6 9 0   18     0   4   55 61                       116.0 79 6 9 0   18     0   4   55 61                 116
2046101 2046101 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_7 7 17 92 0   0     0   0   55 61                       116.0 7 17 92 0   0     0   0   55 61                 116
2046436 2046436 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2019   grade_7 95 3 5 1   9     0   3   58 58                       116.0 95 3 5 1   9     0   3   58 58                 116
2048160 2048160 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_7 86 5 21 0   1     0   3   52 64                       116.0 86 5 21 0   1     0   3   52 64                 116
2048414 2048414 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2019   grade_7 98 3 5 0   5     0   7   68 50                       118.0 98 3 5 0   5     0   7   68 50                 118
2042641 2042641 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2019   grade_7 84 3 21 0   2     0   9   63 56                       119.0 84 3 21 0   2     0   9   63 56                 119
2048967 2048967 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_7 91 2 19 0   2     0   5   73 46                       119.0 91 2 19 0   2     0   5   73 46                 119
2045172 2045172 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_7 5 4 2 0   0     0   1   6 6                       12.0 5 4 2 0   0     0   1   6 6                 12
2040572 2040572 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2019   grade_7 4 30 75 0   4     0   7   70 50                       120.0 4 30 75 0   4     0   7   70 50                 120
2049083 2049083 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2019   grade_7 108 3 3 0   3     0   3   49 71                       120.0 108 3 3 0   3     0   3   49 71                 120
2039833 2039833 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_7 117 2 1 0   0     0   1   64 57                       121.0 117 2 1 0   0     0   1   64 57                 121
2042788 2042788 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_7 75 6 35 1   3     0   1   64 57                       121.0 75 6 35 1   3     0   1   64 57                 121
2041933 2041933 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2019   grade_7 114 0 3 0   1     0   4   79 43                       122.0 114 0 3 0   1     0   4   79 43                 122
2043324 2043324 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_7 105 5 1 0   6     0   5   51 71                       122.0 105 5 1 0   6     0   5   51 71                 122
2044191 2044191 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2019   grade_7 65 17 35 0   3     0   2   58 64                       122.0 65 17 35 0   3     0   2   58 64                 122
2047627 2047627 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_7 4 20 96 0   1     0   1   60 62                       122.0 4 20 96 0   1     0   1   60 62                 122
2048649 2048649 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2019   grade_7 116 3 1 0   1     0   1   50 72                       122.0 116 3 1 0   1     0   1   50 72                 122
2042133 2042133 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_7 31 21 57 1   13     0   1   61 63                       124.0 31 21 57 1   13     0   1   61 63                 124
2046679 2046679 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2019   grade_7 74 9 29 0   3     0   9   65 59                       124.0 74 9 29 0   3     0   9   65 59                 124
2048768 2048768 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2019   grade_7 106 3 5 0   4     0   6   68 56                       124.0 106 3 5 0   4     0   6   68 56                 124
2049138 2049138 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_7 115 2 4 0   2     0   1   66 58                       124.0 115 2 4 0   2     0   1   66 58                 124
2043137 2043137 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_7 11 4 104 0   6     0   0   62 63                       125.0 11 4 104 0   6     0   0   62 63                 125
2048182 2048182 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_7 92 3 13 2   8     2   5   66 59                       125.0 92 3 13 2   8     2   5   66 59                 125
2048224 2048224 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2019   grade_7 111 2 6 0   0     0   6   71 53                       125.0 111 2 6 0   0     0   6   71 53                 125
2048504 2048504 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2019   grade_7 106 1 7 0   8     1   2   43 82                       125.0 106 1 7 0   8     1   2   43 82                 125
2042501 2042501 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_7 109 3 5 0   6     1   3   62 65                       127.0 109 3 5 0   6     1   3   62 65                 127
2041599 2041599 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_7 121 1 3 0   0     0   3   80 48                       128.0 121 1 3 0   0     0   3   80 48                 128
2047712 2047712 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_7 26 41 53 0   4     0   4   58 70                       128.0 26 41 53 0   4     0   4   58 70                 128
2048777 2048777 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2019   grade_7 114 3 6 0   3     0   2   75 53                       128.0 114 3 6 0   3     0   2   75 53                 128
2048287 2048287 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2019   grade_7 119 0 3 0   2     0   5   66 63                       129.0 119 0 3 0   2     0   5   66 63                 129
2042752 2042752 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_7 58 4 62 0   2     1   3   61 69                       130.0 58 4 62 0   2     1   3   61 69                 130
2043745 2043745 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2019   grade_7 31 27 46 0   25     0   2   60 71                       131.0 31 27 46 0   25     0   2   60 71                 131
2047878 2047878 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2019   grade_7 55 34 8 0   32     0   3   62 70                       132.0 55 34 8 0   32     0   3   62 70                 132
2047579 2047579 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2019   grade_7 82 8 20 0   7     0   16   65 68                       133.0 82 8 20 0   7     0   16   65 68                 133
2048626 2048626 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2019   grade_7 98 13 13 1   1     1   7   70 64                       134.0 98 13 13 1   1     1   7   70 64                 134
2041661 2041661 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_7 9 10 116 0   0     0   0   73 62                       135.0 9 10 116 0   0     0   0   73 62                 135
2041769 2041769 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2019   grade_7 90 3 41 0   2     0   0   68 68                       136.0 90 3 41 0   2     0   0   68 68                 136
2044108 2044108 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2019   grade_7 106 4 13 0   6     0   7   69 67                       136.0 106 4 13 0   6     0   7   69 67                 136
2045244 2045244 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2019   grade_7 84 11 14 2   19     0   6   81 55                       136.0 84 11 14 2   19     0   6   81 55                 136
2048535 2048535 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2019   grade_7 128 0 3 0   1     0   4   70 65                       136.0 128 0 3 0   1     0   4   70 65                 136
2043176 2043176 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2019   grade_7 106 6 14 0   7     0   4   81 56                       137.0 106 6 14 0   7     0   4   81 56                 137
2043090 2043090 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_7 7 0 129 0   0     0   2   60 78                       138.0 7 0 129 0   0     0   2   60 78                 138
2045841 2045841 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2019   grade_7 113 3 15 0   4     0   4   77 62                       139.0 113 3 15 0   4     0   4   77 62                 139
2040623 2040623 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_7 6 2 6 0   0     0   0   7 7                       14.0 6 2 6 0   0     0   0   7 7                 14
2041665 2041665 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_7 11 3 124 1   1     0   0   73 67                       140.0 11 3 124 1   1     0   0   73 67                 140
2043944 2043944 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No Middle 06 08 2019   grade_7 58 28 25 0   21     1   7   80 60                       140.0 58 28 25 0   21     1   7   80 60                 140
2041669 2041669 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2019   grade_7 8 5 126 0   1     0   1   63 78                       141.0 8 5 126 0   1     0   1   63 78                 141
2043533 2043533 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2019   grade_7 124 2 9 2   1     0   3   74 67                       141.0 124 2 9 2   1     0   3   74 67                 141
2044017 2044017 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_7 77 1 47 0   9     0   7   70 71                       141.0 77 1 47 0   9     0   7   70 71                 141
2046450 2046450 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2019   grade_7 127 1 6 1   4     0   3   78 64                       142.0 127 1 6 1   4     0   3   78 64                 142
2048246 2048246 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2019   grade_7 120 9 5 0   6     0   2   70 72                       142.0 120 9 5 0   6     0   2   70 72                 142
2043069 2043069 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_7 2 1 140 0   0     0   0   71 70                       143.0 2 1 140 0   0     0   0   71 70                 143
2046525 2046525 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2019   grade_7 114 1 6 0   17     0   5   69 74                       143.0 114 1 6 0   17     0   5   69 74                 143
2047634 2047634 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_7 102 0 9 0   21     0   12   78 66                       144.0 102 0 9 0   21     0   12   78 66                 144
2047750 2047750 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_7 42 73 11 0   12     0   6   66 78                       144.0 42 73 11 0   12     0   6   66 78                 144
2043030 2043030 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2019   grade_7 128 2 9 1   3     0   3   71 75                       146.0 128 2 9 1   3     0   3   71 75                 146
2043468 2043468 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_7 44 13 51 0   33     0   6   65 82                       147.0 44 13 51 0   33     0   6   65 82                 147
2044894 2044894 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2019   grade_7 121 1 14 0   3     1   8   81 67                       148.0 121 1 14 0   3     1   8   81 67                 148
2039950 2039950 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_7 81 4 15 0   44     0   5   82 67                       149.0 81 4 15 0   44     0   5   82 67                 149
2040053 2040053 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_7 98 7 27 1   9     0   7   74 75                       149.0 98 7 27 1   9     0   7   74 75                 149
2040057 2040057 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_7 101 6 24 0   7     0   11   79 70                       149.0 101 6 24 0   7     0   11   79 70                 149
2042507 2042507 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2019   grade_7 132 2 4 0   8     0   3   76 73                       149.0 132 2 4 0   8     0   3   76 73                 149

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