enrollments

Data source: Big Local News · About: Big Local

592 rows where grade = "grade_6", state = "MA" and year = 2021 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 592 ✖

grade ✖

  • grade_6 · 592 ✖
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
1673458 1673458 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_6 24 97 18 0   0     1   7   91 56 *                     147.0 24 97 18 0   0     1   7   91 56                 147
1679803 1679803 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_6 14 96 63 1   4     0   4   85 97 *                     182.0 14 96 63 1   4     0   4   85 97                 182
1681488 1681488 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_6 1 94 11 2   2     0   7   63 54 *                     117.0 1 94 11 2   2     0   7   63 54                 117
1673414 1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1673471 1673471 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton - Joseph F. Plouffe Academy   Regular School No Middle 06 08 2021   grade_6 35 91 83 1   6     1   8   109 116 *                     225.0 35 91 83 1   6     1   8   109 116                 225
1672244 1672244 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_6 97 9 15 0   8     0   7   75 61 *                     136.0 97 9 15 0   8     0   7   75 61                 136
1673969 1673969 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_6 159 9 15 0   11     0   21   114 101 *                     215.0 159 9 15 0   11     0   21   114 101                 215
1674989 1674989 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_6 265 9 13 0   3     0   8   144 153 *                     298.0 265 9 13 0   3     0   8   144 153                 298
1676269 1676269 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_6 204 9 86 7   4     1   19   175 155 *                     330.0 204 9 86 7   4     1   19   175 155                 330
1676406 1676406 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick - Wilson Middle   Regular School No Middle 05 08 2021   grade_6 149 9 12 1   18     1   11   102 99 *                     201.0 149 9 12 1   18     1   11   102 99                 201
1677320 1677320 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth - Plymouth Commun Intermediate   Regular School No Middle 06 08 2021   grade_6 267 9 24 0   6     0   18   167 157 *                     324.0 267 9 24 0   6     0   18   167 157                 324
1677424 1677424 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy - South West Middle School   Regular School No Middle 05 08 2021   grade_6 36 9 15 1   38     1   5   74 31 *                     105.0 36 9 15 1   38     1   5   74 31                 105
1678293 1678293 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield - Conservatory of the Arts   Regular School No High 06 12 2021   grade_6 7 9 38 0   1     1   0   19 37 *                     56.0 7 9 38 0   1     1   0   19 37                 56
1678482 1678482 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott - Swampscott Middle   Regular School No Middle 05 08 2021   grade_6 107 9 24 0   7     0   6   75 78 *                     153.0 107 9 24 0   7     0   6   75 78                 153
1679377 1679377 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_6 106 9 20 2   3     0   6   70 76 *                     146.0 106 9 20 2   3     0   6   70 76                 146
1679505 1679505 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Worcester - Heard Street   Regular School No Elementary KG 06 2021   grade_6 17 9 4 0   4     0   1   15 20 *                     35.0 17 9 4 0   4     0   1   15 20                 35
1679618 1679618 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester - Union Hill School   Regular School No Elementary KG 06 2021   grade_6 12 9 39 0   0     0   0   24 36 *                     60.0 12 9 39 0   0     0   0   24 36                 60
1679769 1679769 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_6 50 9 48 1   12     0   10   75 55 *                     130.0 50 9 48 1   12     0   10   75 55                 130
1672055 1672055 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam - Roberta G. Doering School   Regular School No Middle 05 08 2021   grade_6 209 8 36 0   10     0   9   164 108 *                     272.0 209 8 36 0   10     0   9   164 108                 272
1672398 1672398 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_6 251 8 8 0   74     0   24   184 181 *                     365.0 251 8 8 0   74     0   24   184 181                 365
1672975 1672975 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_6 0 8 34 0   0     0   0   23 19 *                     42.0 0 8 34 0   0     0   0   23 19                 42
1673830 1673830 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_6 10 8 99 0   0     0   6   66 57 *                     123.0 10 8 99 0   0     0   6   66 57                 123
1674160 1674160 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater - Gordon W. Mitchell School   Regular School No Elementary 03 06 2021   grade_6 128 8 7 1   0     0   5   76 73 *                     149.0 128 8 7 1   0     0   5   76 73                 149
1674279 1674279 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett - Madeline English School   Regular School No Elementary KG 08 2021   grade_6 22 8 50 0   4     0   0   44 40 *                     84.0 22 8 50 0   4     0   0   44 40                 84
1674389 1674389 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_6 25 8 9 0   1     0   7   22 28 *                     50.0 25 8 9 0   1     0   7   22 28                 50
1674550 1674550 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_6 132 8 12 1   12     0   8   89 84 *                     173.0 132 8 12 1   12     0   8   89 84                 173
1674922 1674922 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill - Dr Paul Nettle   Regular School No Middle 05 08 2021   grade_6 72 8 93 0   6     0   6   103 82 *                     185.0 72 8 93 0   6     0   6   103 82                 185
1676284 1676284 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Millbury - Raymond E. Shaw Elementary   Regular School No Middle 04 06 2021   grade_6 99 8 5 0   9     1   10   66 66 *                     132.0 99 8 5 0   9     1   10   66 66                 132
1676795 1676795 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_6 140 8 33 1   5     0   17   121 82 *                     204.0 140 8 33 1   5     0   17   121 82                 204
1677915 1677915 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 Somerville - John F Kennedy   Regular School No Elementary PK 08 2021   grade_6 40 8 13 0   6     0   4   34 37 *                     71.0 40 8 13 0   6     0   4   34 37                 71
1678303 1678303 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Springfield - Van Sickle Academy   Regular School No Middle 06 08 2021   grade_6 8 8 76 0   1     0   1   45 49 *                     94.0 8 8 76 0   1     0   1   45 49                 94
1679475 1679475 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Worcester - Elm Park Community   Regular School No Elementary KG 06 2021   grade_6 17 8 30 0   1     0   2   29 29 *                     58.0 17 8 30 0   1     0   2   29 29                 58
1679653 1679653 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester - Sullivan Middle   Regular School No Middle 06 08 2021   grade_6 28 8 4 0   6     0   4   25 25 *                     50.0 28 8 4 0   6     0   4   25 25                 50
1680131 1680131 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District) - Salem Academy Charter School   Regular School Yes High 06 12 2021   grade_6 26 8 31 0   5     0   2   34 38 *                     72.0 26 8 31 0   5     0   2   34 38                 72
1680371 1680371 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_6 104 8 16 2   3     1   2   82 54 *                     136.0 104 8 16 2   3     1   2   82 54                 136
1680549 1680549 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn - Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2021   grade_6 115 8 7 0   18     0   14   96 66 *                     162.0 115 8 7 0   18     0   14   96 66                 162
1681524 1681524 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_6 32 8 9 0   1     2   3   33 22 0                     55.0 32 8 9 0   1     2   3   33 22 0               55
1673468 1673468 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_6 31 78 16 1   3     2   6   79 58 *                     137.0 31 78 16 1   3     2   6   79 58                 137
1679942 1679942 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_6 46 77 14 0   10     0   5   74 78 *                     152.0 46 77 14 0   10     0   5   74 78                 152
1673082 1673082 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_6 3 76 29 1   2     0   1   54 58 *                     112.0 3 76 29 1   2     0   1   54 58                 112
1678400 1678400 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton - O'Donnell Middle School   Regular School No Middle 06 08 2021   grade_6 104 73 44 1   15     0   13   127 123 *                     250.0 104 73 44 1   15     0   13   127 123                 250
1672210 1672210 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_6 158 7 27 3   29     0   5   115 114 *                     229.0 158 7 27 3   29     0   5   115 114                 229
1672526 1672526 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_6 19 7 16 0   1     0   4   19 28 *                     47.0 19 7 16 0   1     0   4   19 28                 47
1672852 1672852 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_6 3 7 4 0   1     0   2   10 7 *                     17.0 3 7 4 0   1     0   2   10 7                 17
1673552 1673552 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_6 31 7 6 0   15     0   4   25 38 *                     63.0 31 7 6 0   15     0   4   25 38                 63
1675157 1675157 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson - David J. Quinn Middle School   Regular School No Middle 05 07 2021   grade_6 124 7 29 0   2     0   1   75 88 *                     163.0 124 7 29 0   2     0   1   75 88                 163
1675469 1675469 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln - Lincoln School   Regular School No Elementary PK 08 2021   grade_6 37 7 7 0   2     0   4   31 26 *                     57.0 37 7 7 0   2     0   4   31 26                 57
1675503 1675503 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow - Glenbrook Middle   Regular School No Middle 06 08 2021   grade_6 83 7 5 0   12     0   6   61 52 *                     113.0 83 7 5 0   12     0   6   61 52                 113
1676204 1676204 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_6 44 7 49 0   1     0   7   54 54 *                     108.0 44 7 49 0   1     0   7   54 54                 108
1676214 1676214 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   grade_6 42 7 83 0   3     0   7   84 58 *                     142.0 42 7 83 0   3     0   7   84 58                 142
1676243 1676243 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough - John T. Nichols Middle   Regular School No Middle 06 08 2021   grade_6 192 7 5 1   2     0   19   125 101 *                     226.0 192 7 5 1   2     0   19   125 101                 226
1676719 1676719 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton - Oak Hill Middle   Regular School No Middle 06 08 2021   grade_6 148 7 14 1   38     0   16   108 115 *                     224.0 148 7 14 1   38     0   16   108 115                 224
1677560 1677560 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere - Susan B. Anthony Middle School   Regular School No Middle 06 08 2021   grade_6 58 7 99 0   6     0   2   74 98 *                     172.0 58 7 99 0   6     0   2   74 98                 172
1678440 1678440 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury - Ephraim Curtis Middle   Regular School No Middle 06 08 2021   grade_6 196 7 14 0   33     1   27   159 119 *                     278.0 196 7 14 0   33     1   27   159 119                 278
1678698 1678698 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Walpole - Bird Middle   Regular School No Middle 06 08 2021   grade_6 102 7 9 0   4     0   4   61 65 *                     126.0 102 7 9 0   4     0   4   61 65                 126
1679407 1679407 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Worcester - Woodland Academy   Regular School No Elementary KG 06 2021   grade_6 6 7 60 1   9     0   3   33 53 *                     86.0 6 7 60 1   9     0   3   33 53                 86
1679528 1679528 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester - Lincoln Street   Regular School No Elementary KG 06 2021   grade_6 3 7 12 0   1     0   1   12 12 *                     24.0 3 7 12 0   1     0   1   12 12                 24
1679745 1679745 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District) - Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2021   grade_6 44 7 10 0   1     0   2   37 27 *                     64.0 44 7 10 0   1     0   2   37 27                 64
1679844 1679844 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_6 71 7 9 0   6     0   7   57 43 *                     100.0 71 7 9 0   6     0   7   57 43                 100
1681495 1681495 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School (District) - Libertas Academy Charter School   Regular School Yes Middle 06 08 2021   grade_6 2 7 68 2   0     0   1   43 37 *                     80.0 2 7 68 2   0     0   1   43 37                 80
1679929 1679929 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_6 21 68 18 0   3     0   7   61 56 *                     117.0 21 68 18 0   3     0   7   61 56                 117
1679752 1679752 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_6 2 61 35 0   0     0   2   46 54 *                     100.0 2 61 35 0   0     0   2   46 54                 100
1673257 1673257 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_6 2 60 31 0   1     0   10   65 39 *                     104.0 2 60 31 0   1     0   10   65 39                 104
1672272 1672272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_6 163 6 23 0   18     0   3   110 103 *                     213.0 163 6 23 0   18     0   3   110 103                 213
1672651 1672651 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_6 59 6 22 1   10     0   7   47 58 *                     105.0 59 6 22 1   10     0   7   47 58                 105
1672885 1672885 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_6 6 6 8 0   0     0   2   18 4 *                     22.0 6 6 8 0   0     0   2   18 4                 22
1673013 1673013 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_6 1 6 14 0   2     1   1   12 13 *                     25.0 1 6 14 0   2     1   1   12 13                 25
1673505 1673505 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline - Edith C Baker   Regular School No Elementary KG 08 2021   grade_6 40 6 5 0   28     0   7   44 42 *                     86.0 40 6 5 0   28     0   7   44 42                 86
1673822 1673822 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_6 7 6 117 0   1     0   2   64 69 *                     133.0 7 6 117 0   1     0   2   64 69                 133
1673826 1673826 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea - Clark Avenue School   Regular School No Middle 05 08 2021   grade_6 13 6 155 0   1     0   2   92 85 *                     177.0 13 6 155 0   1     0   2   92 85                 177
1674860 1674860 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_6 193 6 7 0   3     0   3   106 106 *                     212.0 193 6 7 0   3     0   3   106 106                 212
1674912 1674912 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_6 113 6 40 0   3     0   5   90 77 *                     167.0 113 6 40 0   3     0   5   90 77                 167
1675555 1675555 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell - Pyne Arts   Regular School No Elementary PK 08 2021   grade_6 21 6 20 0   11     0   1   28 31 *                     59.0 21 6 20 0   11     0   1   28 31                 59
1675631 1675631 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_6 50 6 36 0   79     0   9   97 83 *                     180.0 50 6 36 0   79     0   9   97 83                 180
1676224 1676224 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen - Donald P Timony Grammar   Regular School No Elementary PK 08 2021   grade_6 51 6 75 0   6     0   5   75 68 *                     143.0 51 6 75 0   6     0   5   75 68                 143
1676967 1676967 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton - Norton Middle   Regular School No Middle 06 08 2021   grade_6 160 6 9 2   3     0   9   90 99 *                     189.0 160 6 9 2   3     0   9   90 99                 189
1677317 1677317 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth - Plymouth South Middle   Regular School No Middle 06 08 2021   grade_6 196 6 4 0   0     0   5   112 99 *                     211.0 196 6 4 0   0     0   5   112 99                 211
1677944 1677944 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville - West Somerville Neighborhood   Regular School No Elementary PK 08 2021   grade_6 26 6 8 0   0     0   1   24 17 *                     41.0 26 6 8 0   0     0   1   24 17                 41
1677954 1677954 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville - Winter Hill Community   Regular School No Elementary PK 08 2021   grade_6 15 6 42 0   3     0   1   36 31 *                     67.0 15 6 42 0   3     0   1   36 31                 67
1678815 1678815 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown - Watertown Middle   Regular School No Middle 06 08 2021   grade_6 110 6 36 0   12     0   14   80 98 *                     178.0 110 6 36 0   12     0   14   80 98                 178
1679067 1679067 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston - Weston Middle   Regular School No Middle 06 08 2021   grade_6 90 6 13 0   24     0   9   71 71 *                     142.0 90 6 13 0   24     0   9   71 71                 142
1679414 1679414 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Worcester - Burncoat Street   Regular School No Elementary KG 06 2021   grade_6 5 6 25 0   0     0   0   17 19 *                     36.0 5 6 25 0   0     0   0   17 19                 36
1679422 1679422 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Worcester - Canterbury   Regular School No Elementary PK 06 2021   grade_6 7 6 29 0   7     0   1   25 25 *                     50.0 7 6 29 0   7     0   1   25 25                 50
1679498 1679498 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Worcester - Grafton Street   Regular School No Elementary KG 06 2021   grade_6 14 6 36 1   3     0   5   32 33 *                     65.0 14 6 36 1   3     0   5   32 33                 65
1679596 1679596 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester - Worcester Arts Magnet School   Regular School No Elementary PK 06 2021   grade_6 21 6 9 0   1     0   4   15 26 *                     41.0 21 6 9 0   1     0   4   15 26                 41
1679955 1679955 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   grade_6 69 6 1 1   17     0   2   40 56 *                     96.0 69 6 1 1   17     0   2   40 56                 96
1680582 1680582 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_6 147 6 13 0   2     0   6   87 87 *                     174.0 147 6 13 0   2     0   6   87 87                 174
1680827 1680827 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District - Monomoy Regional Middle School   Regular School No Middle 05 07 2021   grade_6 130 6 10 1   0     1   10   69 89 *                     158.0 130 6 10 1   0     1   10   69 89                 158
1676577 1676577 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_6 128 59 135 0   1     0   24   181 166 *                     347.0 128 59 135 0   1     0   24   181 166                 347
1672894 1672894 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_6 1 54 29 0   1     0   1   37 49 *                     86.0 1 54 29 0   1     0   1   37 49                 86
1680095 1680095 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_6 2 52 44 1   4     1   0   55 49 *                     104.0 2 52 44 1   4     1   0   55 49                 104
1680027 1680027 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_6 0 50 21 0   0     0   0   36 35 *                     71.0 0 50 21 0   0     0   0   36 35                 71
1672015 1672015 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_6 136 5 20 0   4     1   3   95 74 *                     169.0 136 5 20 0   4     1   3   95 74                 169
1672142 1672142 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_6 129 5 18 0   26     0   4   89 93 *                     182.0 129 5 18 0   26     0   4   89 93                 182
1672952 1672952 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_6 1 5 4 0   0     0   0   5 5 *                     10.0 1 5 4 0   0     0   0   5 5                 10
1673102 1673102 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_6 5 5 5 0   0     0   1   10 6 *                     16.0 5 5 5 0   0     0   1   10 6                 16
1673515 1673515 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   grade_6 45 5 9 0   10     0   11   38 42 *                     80.0 45 5 9 0   10     0   11   38 42                 80
1673793 1673793 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_6 129 5 17 0   28     1   16   99 97 *                     196.0 129 5 17 0   28     1   16   99 97                 196
1673926 1673926 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton - Clinton Middle School   Regular School No Middle 05 08 2021   grade_6 67 5 57 0   0     0   4   69 64 *                     133.0 67 5 57 0   0     0   4   69 64                 133
1673941 1673941 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_6 105 5 0 0   3     0   6   58 61 *                     119.0 105 5 0 0   3     0   6   58 61                 119

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