enrollments

Data source: Big Local News · About: Big Local

496 rows where grade = "grade_7", state = "MA" and year = 2021 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 496 ✖

grade ✖

  • grade_7 · 496 ✖
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
1674431 1674431 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_7 7 1 0 0   0     0   0   7 1 *                     8.0 7 1 0 0   0     0   0   7 1                 8
1673120 1673120 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_7 6 33 19 0   0     0   5   34 29 *                     63.0 6 33 19 0   0     0   5   34 29                 63
1673452 1673452 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_7 1 3 1 0   0     0   1   4 2 *                     6.0 1 3 1 0   0     0   1   4 2                 6
1672901 1672901 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_7 11 25 40 0   1     0   4   42 39 *                     81.0 11 25 40 0   1     0   4   42 39                 81
1673073 1673073 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_7 1 27 16 0   2     0   3   22 27 *                     49.0 1 27 16 0   2     0   3   22 27                 49
1675226 1675226 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_7 3 1 90 0   2     0   0   47 49 *                     96.0 3 1 90 0   2     0   0   47 49                 96
1675614 1675614 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_7 1 0 5 0   0     0   1   7 * *                     7.0 1 0 5 0   0     0   1   7                   7
1672366 1672366 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham - Bellingham Memorial School   Regular School No Middle 04 07 2021   grade_7 158 4 14 0   4     0   8   81 107 *                     188.0 158 4 14 0   4     0   8   81 107                 188
1675061 1675061 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke - William R. Peck School   Regular School No Middle 04 08 2021   grade_7 4 1 49 0   0     0   1   34 21 *                     55.0 4 1 49 0   0     0   1   34 21                 55
1675475 1675475 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_7 33 3 13 0   0     0   3   28 24 *                     52.0 33 3 13 0   0     0   3   28 24                 52
1676071 1676071 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard - Fowler School   Regular School No Middle 04 08 2021   grade_7 72 4 15 0   0     0   3   44 50 *                     94.0 72 4 15 0   0     0   3   44 50                 94
1676592 1676592 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_7 6 4 2 0   0     0   0   10 2 *                     12.0 6 4 2 0   0     0   0   10 2                 12
1678626 1678626 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Uxbridge - Whitin Intermediate   Regular School No Middle 04 07 2021   grade_7 104 0 9 1   1     0   3   73 45 *                     118.0 104 0 9 1   1     0   3   73 45                 118
1680033 1680033 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District) - Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2021   grade_7 25 1 5 0   0     0   1   20 12 *                     32.0 25 1 5 0   0     0   1   20 12                 32
1680302 1680302 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_7 100 3 2 0   0     0   2   55 52 *                     107.0 100 3 2 0   0     0   2   55 52                 107
1672016 1672016 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_7 128 7 17 2   4     0   3   84 77 *                     161.0 128 7 17 2   4     0   3   84 77                 161
1672031 1672031 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_7 95 1 2 1   1     0   0   55 45 *                     100.0 95 1 2 1   1     0   0   55 45                 100
1672076 1672076 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_7 119 3 21 0   2     0   10   90 65 *                     155.0 119 3 21 0   2     0   10   90 65                 155
1672245 1672245 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_7 113 19 12 2   10     0   14   90 80 *                     170.0 113 19 12 2   10     0   14   90 80                 170
1672249 1672249 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_7 86 3 22 0   10     0   13   66 67 *                     134.0 86 3 22 0   10     0   13   66 67                 134
1672253 1672253 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_7 107 10 26 0   5     0   11   86 73 *                     159.0 107 10 26 0   5     0   11   86 73                 159
1672399 1672399 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_7 211 13 20 1   92     2   28   189 178 *                     367.0 211 13 20 1   92     2   28   189 178                 367
1672413 1672413 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 0 0   0     0   5   56 53 *                     109.0 104 0 0 0   0     0   5   56 53                 109
1672443 1672443 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly - Beverly Middle School   Regular School No Middle 05 08 2021   grade_7 286 11 52 0   9     1   14   192 181 *                     373.0 286 11 52 0   9     1   14   192 181                 373
1672477 1672477 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica - Marshall Middle School   Regular School No Middle 05 07 2021   grade_7 155 14 18 0   13     0   4   102 102 *                     204.0 155 14 18 0   13     0   4   102 102                 204
1672480 1672480 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica - Locke Middle   Regular School No Middle 05 07 2021   grade_7 146 4 10 0   12     0   9   104 77 *                     181.0 146 4 10 0   12     0   9   104 77                 181
1673350 1673350 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree - East Middle School   Regular School No Middle 05 08 2021   grade_7 180 21 17 0   53     1   3   138 137 *                     275.0 180 21 17 0   53     1   3   138 137                 275
1673790 1673790 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford - Col Moses Parker School   Regular School No Middle 05 08 2021   grade_7 124 10 17 2   27     0   7   121 66 *                     187.0 124 10 17 2   27     0   7   121 66                 187
1673794 1673794 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_7 145 8 8 0   39     0   6   101 105 *                     206.0 145 8 8 0   39     0   6   101 105                 206
1673823 1673823 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_7 9 11 117 2   0     0   6   79 66 *                     145.0 9 11 117 2   0     0   6   79 66                 145
1673827 1673827 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea - Clark Avenue School   Regular School No Middle 05 08 2021   grade_7 10 5 173 1   0     0   2   97 94 *                     191.0 10 5 173 1   0     0   2   97 94                 191
1673831 1673831 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_7 9 8 151 0   0     0   1   97 72 *                     169.0 9 8 151 0   0     0   1   97 72                 169
1673927 1673927 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton - Clinton Middle School   Regular School No Middle 05 08 2021   grade_7 112 6 40 0   2     0   5   94 71 *                     165.0 112 6 40 0   2     0   5   94 71                 165
1674192 1674192 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton - White Brook Middle School   Regular School No Middle 05 08 2021   grade_7 68 1 15 0   7     0   1   59 32 *                     92.0 68 1 15 0   7     0   1   59 32                 92
1674492 1674492 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg - Memorial Middle School   Regular School No Middle 05 08 2021   grade_7 50 10 84 0   6     1   11   70 92 *                     162.0 50 10 84 0   6     1   11   70 92                 162
1674502 1674502 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg - Arthur M Longsjo Middle School   Regular School No Middle 05 08 2021   grade_7 42 14 89 0   5     0   15   82 83 *                     165.0 42 14 89 0   5     0   15   82 83                 165
1674551 1674551 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_7 172 13 16 1   8     0   5   115 100 *                     215.0 172 13 16 1   8     0   5   115 100                 215
1674685 1674685 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_7 117 4 38 0   4     0   13   96 80 *                     176.0 117 4 38 0   4     0   13   96 80                 176
1674818 1674818 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield - Greenfield Middle   Regular School No Middle 05 07 2021   grade_7 85 5 19 0   1     0   9   61 58 *                     119.0 85 5 19 0   1     0   9   61 58                 119
1674861 1674861 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_7 170 1 8 0   4     0   0   103 80 *                     183.0 170 1 8 0   4     0   0   103 80                 183
1674923 1674923 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill - Dr Paul Nettle   Regular School No Middle 05 08 2021   grade_7 53 11 75 0   2     0   2   81 62 *                     143.0 53 11 75 0   2     0   2   81 62                 143
1674947 1674947 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_7 60 8 66 0   2     1   3   60 80 *                     140.0 60 8 66 0   2     1   3   60 80                 140
1674951 1674951 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_7 81 10 115 0   6     0   4   120 96 *                     216.0 81 10 115 0   6     0   4   120 96                 216
1675102 1675102 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_7 3 6 108 0   1     0   1   64 55 *                     119.0 3 6 108 0   1     0   1   64 55                 119
1675158 1675158 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson - David J. Quinn Middle School   Regular School No Middle 05 07 2021   grade_7 161 2 29 0   3     0   5   98 102 *                     200.0 161 2 29 0   3     0   5   98 102                 200
1675230 1675230 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence - Arlington Middle School   Regular School No Middle 05 08 2021   grade_7 4 1 139 1   0     0   0   72 73 *                     145.0 4 1 139 1   0     0   0   72 73                 145
1675247 1675247 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_7 1 3 130 0   1     0   0   82 53 *                     135.0 1 3 130 0   1     0   0   82 53                 135
1675251 1675251 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence - Parthum Middle School   Regular School No Middle 05 08 2021   grade_7 5 0 160 0   1     0   1   82 85 *                     167.0 5 0 160 0   1     0   1   82 85                 167
1675298 1675298 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_7 9 3 113 0   3     0   6   74 60 *                     134.0 9 3 113 0   3     0   6   74 60                 134
1675338 1675338 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester - Leicester Middle   Regular School No Middle 05 08 2021   grade_7 100 7 17 0   2     0   2   75 53 *                     128.0 100 7 17 0   2     0   2   75 53                 128
1675628 1675628 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell - B.F. Butler Middle School   Regular School No Middle 05 08 2021   grade_7 26 7 49 0   45     0   13   71 69 *                     140.0 26 7 49 0   45     0   13   71 69                 140
1675632 1675632 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_7 44 8 25 0   82     0   10   92 77 *                     169.0 44 8 25 0   82     0   10   92 77                 169
1675640 1675640 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Lowell - Henry J Robinson Middle   Regular School No Middle 05 08 2021   grade_7 46 18 75 0   22     0   4   83 82 *                     165.0 46 18 75 0   22     0   4   83 82                 165
1675644 1675644 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell - James Sullivan Middle School   Regular School No Middle 05 08 2021   grade_7 49 7 77 0   25     0   8   79 87 *                     166.0 49 7 77 0   25     0   8   79 87                 166
1675648 1675648 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell - Dr An Wang School   Regular School No Middle 05 08 2021   grade_7 50 15 69 0   20     0   14   86 82 *                     168.0 50 15 69 0   20     0   14   86 82                 168
1675652 1675652 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell - Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2021   grade_7 26 9 49 0   80     0   4   91 77 *                     168.0 26 9 49 0   80     0   4   91 77                 168
1675870 1675870 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield - Lynnfield Middle School   Regular School No Middle 05 08 2021   grade_7 131 4 8 0   16     0   3   87 75 *                     162.0 131 4 8 0   16     0   3   87 75                 162
1675995 1675995 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough - 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2021   grade_7 126 13 209 1   9     0   10   198 170 *                     368.0 126 13 209 1   9     0   10   198 170                 368
1676141 1676141 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway - Medway Middle   Regular School No Middle 05 08 2021   grade_7 150 4 9 0   7     1   7   70 108 *                     178.0 150 4 9 0   7     1   7   70 108                 178
1676403 1676403 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick - J F Kennedy Middle School   Regular School No Middle 05 08 2021   grade_7 147 0 15 0   21     0   4   102 85 *                     187.0 147 0 15 0   21     0   4   102 85                 187
1676407 1676407 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick - Wilson Middle   Regular School No Middle 05 08 2021   grade_7 175 15 6 1   21     0   6   118 106 *                     224.0 175 15 6 1   21     0   6   118 106                 224
1676909 1676909 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge - Northbridge Middle   Regular School No Middle 05 08 2021   grade_7 164 1 19 0   2     0   5   105 86 *                     191.0 164 1 19 0   2     0   5   105 86                 191
1677064 1677064 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford - Oxford Middle   Regular School No Middle 05 07 2021   grade_7 101 1 8 0   0     0   5   61 54 *                     115.0 101 1 8 0   0     0   5   61 54                 115
1677425 1677425 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy - South West Middle School   Regular School No Middle 05 08 2021   grade_7 46 22 14 0   20     0   10   65 47 *                     112.0 46 22 14 0   20     0   10   65 47                 112
1677430 1677430 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_7 26 9 7 1   39     1   6   50 39 *                     89.0 26 9 7 1   39     1   6   50 39                 89
1677607 1677607 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 Rockland - John W Rogers Middle   Regular School No Middle 05 08 2021   grade_7 139 10 37 0   3     0   4   96 97 *                     193.0 139 10 37 0   3     0   4   96 97                 193
1678020 1678020 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley - Michael E. Smith Middle School   Regular School No Middle 05 08 2021   grade_7 96 3 21 0   3     0   0   67 56 *                     123.0 96 3 21 0   3     0   0   67 56                 123
1678362 1678362 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham - Stoneham Central Middle School   Regular School No Middle 05 08 2021   grade_7 159 6 18 0   8     0   6   107 89 *                     197.0 159 6 18 0   8     0   6   107 89                 197
1678483 1678483 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott - Swampscott Middle   Regular School No Middle 05 08 2021   grade_7 139 5 19 0   5     0   4   80 92 *                     172.0 139 5 19 0   5     0   4   80 92                 172
1678539 1678539 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton - Joseph H Martin   Regular School No Middle 05 07 2021   grade_7 145 39 26 0   2     0   13   121 104 *                     225.0 145 39 26 0   2     0   13   121 104                 225
1678547 1678547 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 Taunton - John F Parker Middle   Regular School No Middle 05 07 2021   grade_7 84 34 28 2   1     1   9   70 89 *                     159.0 84 34 28 2   1     1   9   70 89                 159
1678550 1678550 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton - Benjamin Friedman Middle   Regular School No Middle 05 07 2021   grade_7 211 33 18 0   2     0   11   145 130 *                     275.0 211 33 18 0   2     0   11   145 130                 275
1678659 1678659 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Wakefield - Galvin Middle School   Regular School No Middle 05 08 2021   grade_7 220 7 21 0   10     0   6   126 138 *                     264.0 220 7 21 0   10     0   6   126 138                 264
1678785 1678785 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham - Wareham Middle   Regular School No Middle 05 07 2021   grade_7 126 14 12 3   2     0   30   84 103 *                     187.0 126 14 12 3   2     0   30   84 103                 187
1678856 1678856 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster - Webster Middle School   Regular School No Middle 05 08 2021   grade_7 71 5 46 0   2     0   5   66 63 *                     129.0 71 5 46 0   2     0   5   66 63                 129
1679214 1679214 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Weymouth - Abigail Adams Middle School   Regular School No Middle 05 08 2021   grade_7 311 28 63 1   31     0   22   230 226 *                     456.0 311 28 63 1   31     0   22   230 226                 456
1679718 1679718 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_7 28 11 134 1   2     0   1   88 89 *                     177.0 28 11 134 1   2     0   1   88 89                 177
1679733 1679733 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_7 2 49 20 0   0     0   2   42 31 *                     73.0 2 49 20 0   0     0   2   42 31                 73
1679845 1679845 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_7 75 4 10 1   8     0   4   45 57 *                     102.0 75 4 10 1   8     0   4   45 57                 102
1679960 1679960 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District) - Boston Collegiate Charter School   Regular School Yes High 05 12 2021   grade_7 36 36 25 0   5     0   4   53 53 *                     106.0 36 36 25 0   5     0   4   53 53                 106
1680117 1680117 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District) - Rising Tide Charter Public School   Regular School Yes High 05 12 2021   grade_7 77 0 5 0   1     0   7   41 49 *                     90.0 77 0 5 0   1     0   7   41 49                 90
1680125 1680125 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_7 2 147 111 1   0     1   2   142 122 *                     264.0 2 147 111 1   0     1   2   142 122                 264
1680214 1680214 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District) - Global Learning Charter Public School   Regular School Yes High 05 12 2021   grade_7 36 9 40 0   2     0   4   48 43 *                     91.0 36 9 40 0   2     0   4   48 43                 91
1680235 1680235 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School (District) - Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2021   grade_7 4 26 85 1   3     0   2   58 63 *                     121.0 4 26 85 1   3     0   2   58 63                 121
1680351 1680351 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_7 92 3 15 0   1     0   5   71 45 *                     116.0 92 3 15 0   1     0   5   71 45                 116
1680386 1680386 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_7 73 0 10 0   3     0   4   47 43 *                     90.0 73 0 10 0   3     0   4   47 43                 90
1680448 1680448 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_7 149 16 1 0   5     0   5   94 82 *                     176.0 149 16 1 0   5     0   5   94 82                 176
1680538 1680538 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth - Dighton Middle School   Regular School No Middle 05 08 2021   grade_7 88 2 4 0   1     0   5   59 41 *                     100.0 88 2 4 0   1     0   5   59 41                 100
1680542 1680542 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_7 116 1 7 1   2     0   4   63 68 *                     131.0 116 1 7 1   2     0   4   63 68                 131
1680571 1680571 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_7 116 6 15 1   1     0   6   63 82 *                     145.0 116 6 15 1   1     0   6   63 82                 145
1680575 1680575 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg - Charlton Middle School   Regular School No Middle 05 08 2021   grade_7 161 1 15 1   3     0   3   93 91 *                     184.0 161 1 15 1   3     0   3   93 91                 184
1680657 1680657 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable - Groton Dunstable Regional Middle   Regular School No Middle 05 08 2021   grade_7 149 3 7 0   9     0   4   85 87 *                     172.0 149 3 7 0   9     0   4   85 87                 172
1680802 1680802 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton - Miscoe Hill School   Regular School No Middle 05 08 2021   grade_7 172 0 11 0   7     0   5   109 86 *                     195.0 172 0 11 0   7     0   5   109 86                 195
1680828 1680828 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_7 100 9 13 2   3     0   13   64 76 *                     140.0 100 9 13 2   3     0   13   64 76                 140
1680895 1680895 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_7 106 0 7 1   2     0   7   66 57 *                     123.0 106 0 7 1   2     0   7   66 57                 123
1680965 1680965 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_7 122 0 4 0   3     0   4   72 61 *                     133.0 122 0 4 0   3     0   4   72 61                 133
1680974 1680974 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex - Nissitissit Middle School   Regular School No Middle 05 08 2021   grade_7 103 2 5 0   1     0   8   65 54 *                     119.0 103 2 5 0   1     0   8   65 54                 119
1681142 1681142 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_7 99 4 17 0   2     0   6   66 62 *                     128.0 99 4 17 0   2     0   6   66 62                 128
1681261 1681261 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett - Chocksett Middle School   Regular School No Middle 05 08 2021   grade_7 74 1 6 0   0     0   2   46 37 *                     83.0 74 1 6 0   0     0   2   46 37                 83
1681313 1681313 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 7 0   1     0   4   58 58 *                     116.0 104 0 7 0   1     0   4   58 58                 116

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