enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,371 ✖
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
1364920 1364920 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_7 124 5 11 0   28     0   8   97 79 *                     176.0 124 5 11 0   28     0   8   97 79                 176
2039947 2039947 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_7 124 8 10 0   28     0   4   91 83                       174.0 124 8 10 0   28     0   4   91 83                 174
2228918 2228918 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_7 141 2 6 1   25     0   6   84 97                       181.0 141 2 6 1   25     0   6   84 97                 181
2228914 2228914 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_7 162 1 5 2   27     0   5   97 105                       202.0 162 1 5 2   27     0   5   97 105                 202
2228922 2228922 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_7 73 2 11 0   35     0   4   50 75                       125.0 73 2 11 0   35     0   4   50 75                 125
738338 738338 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2015   grade_7 141 2 4 0   4     0   0   80 71                       151 141 2 4 0   4     0   0   80 71                 151
935192 935192 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2016   grade_7 141 3 1 0   7     0   1   79 74                       153 141 3 1 0   7     0   1   79 74                 153
1125082 1125082 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_7 140 0 5 0   6     2   1   81 73                       154 140 0 5 0   6     2   1   81 73                 154
1367430 1367430 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_7 105 2 10 1   4     0   0   68 54 *                     122.0 105 2 10 1   4     0   0   68 54                 122
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
942000 942000 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 07 2016   grade_7 64 12 19 1   1     0   3   58 42                       100 64 12 19 1   1     0   3   58 42                 100
1133164 1133164 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_7 78 4 12 1   2     1   4   52 50                       102 78 4 12 1   2     1   4   52 50                 102
1374235 1374235 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_7 73 11 26 0   3     0   7   62 58 *                     120.0 73 11 26 0   3     0   7   62 58                 120
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
1681475 1681475 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_7 49 15 40 0   3     0   2   53 56 *                     109.0 49 15 40 0   3     0   2   53 56                 109
2239982 2239982 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   grade_7 65 10 15 1   3     1   8   54 49                       103.0 65 10 15 1   3     1   8   54 49                 103
1672197 1672197 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington - Ottoson Middle   Regular School No Middle 07 08 2021   grade_7 330 21 37 0   41     0   27   237 219 *                     456.0 330 21 37 0   41     0   27   237 219                 456
738913 738913 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_7 1 0 133 0   0     0   0   69 65                       134 1 0 133 0   0     0   0   69 65                 134
935761 935761 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2016   grade_7 2 1 132 0   0     0   0   72 63                       135 2 1 132 0   0     0   0   72 63                 135
1125787 1125787 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_7 3 1 142 0   0     0   0   65 81                       146 3 1 142 0   0     0   0   65 81                 146
1367985 1367985 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_7 1 1 162 0   0     0   1   82 83 *                     165.0 1 1 162 0   0     0   1   82 83                 165
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
2228982 2228982 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_7 301 22 20 0   41     0   31   180 235                       415.0 301 22 20 0   41     0   31   180 235                 415
741624 741624 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   grade_7 23 14 24 0   2     0   1   33 31                       64 23 14 24 0   2     0   1   33 31                 64
938427 938427 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2016   grade_7 11 5 22 0   4     0   2   23 21                       44 11 5 22 0   4     0   2   23 21                 44
1128951 1128951 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_7 21 1 20 0   2     0   2   23 23                       46 21 1 20 0   2     0   2   23 23                 46
1370655 1370655 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2020   grade_7 12 11 26 0   4     0   2   25 30 *                     55.0 12 11 26 0   4     0   2   25 30                 55
2045731 2045731 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_7 18 7 17 0   3     0   1   17 29                       46.0 18 7 17 0   3     0   1   17 29                 46
738181 738181 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_7 44 7 47 0   6     0   8   66 46                       112 44 7 47 0   6     0   8   66 46                 112
935035 935035 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_7 35 8 58 0   3     0   9   58 55                       113 35 8 58 0   3     0   9   58 55                 113
1124894 1124894 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_7 38 6 49 0   7     0   10   62 48                       110 38 6 49 0   7     0   10   62 48                 110
1367268 1367268 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_7 31 9 92 0   4     1   12   77 72 *                     149.0 31 9 92 0   4     1   12   77 72                 149
2042338 2042338 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2019   grade_7 35 12 92 0   7     0   10   87 69                       156.0 35 12 92 0   7     0   10   87 69                 156
743032 743032 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2015   grade_7 138 6 10 0   1     0   0   69 86                       155 138 6 10 0   1     0   0   69 86                 155
939841 939841 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2016   grade_7 144 0 17 0   1     0   1   75 88                       163 144 0 17 0   1     0   1   75 88                 163
741202 741202 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2015   grade_7 140 5 1 0   7     0   4   88 69                       157 140 5 1 0   7     0   4   88 69                 157
938030 938030 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2016   grade_7 151 2 2 0   5     0   5   85 80                       165 151 2 2 0   5     0   5   85 80                 165
1128468 1128468 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2017   grade_7 136 5 1 0   9     0   1   85 67                       152 136 5 1 0   9     0   1   85 67                 152
1370258 1370258 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2020   grade_7 119 2 3 0   1     0   3   71 57 *                     128.0 119 2 3 0   1     0   3   71 57                 128
2045331 2045331 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2019   grade_7 143 4 6 0   8     1   5   87 80                       167.0 143 4 6 0   8     1   5   87 80                 167
1680329 1680329 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster - Overlook Middle School   Regular School No Middle 06 08 2021   grade_7 160 4 15 0   0     0   10   99 90 *                     189.0 160 4 15 0   0     0   10   99 90                 189
2238621 2238621 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster: Overlook Middle School   Regular School No Middle 06 08 2018   grade_7 187 1 6 0   1     0   4   92 107                       199.0 187 1 6 0   1     0   4   92 107                 199
737159 737159 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2015   grade_7 53 69 14 0   4     0   4   80 64                       144 53 69 14 0   4     0   4   80 64                 144
934019 934019 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2016   grade_7 67 64 11 0   1     0   8   73 78                       151 67 64 11 0   1     0   8   73 78                 151
1123692 1123692 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2017   grade_7 77 64 16 0   4     1   6   83 85                       168 77 64 16 0   4     1   6   83 85                 168
1366236 1366236 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_7 64 117 25 2   7     2   4   96 125 *                     221.0 64 117 25 2   7     2   4   96 125                 221
2041306 2041306 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2019   grade_7 55 76 22 1   5     0   7   88 78                       166.0 55 76 22 1   5     0   7   88 78                 166
1672211 1672211 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_7 143 6 35 3   28     0   9   118 106 *                     224.0 143 6 35 3   28     0   9   118 106                 224
735864 735864 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2015   grade_7 136 6 28 2   18     0   4   97 97                       194 136 6 28 2   18     0   4   97 97                 194
932740 932740 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_7 150 4 25 0   18     0   8   98 107                       205 150 4 25 0   18     0   8   98 107                 205
1122195 1122195 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_7 146 5 23 0   27     0   5   93 113                       206 146 5 23 0   27     0   5   93 113                 206
1364988 1364988 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_7 147 7 28 0   29     0   8   111 108 *                     219.0 147 7 28 0   29     0   8   111 108                 219
2040015 2040015 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2019   grade_7 137 4 31 1   29     0   6   103 105                       208.0 137 4 31 1   29     0   6   103 105                 208
2229001 2229001 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_7 124 4 23 2   28     0   5   99 87                       186.0 124 4 23 2   28     0   5   99 87                 186
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
744039 744039 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_7 99 2 10 0   1     0   0   57 55                       112 99 2 10 0   1     0   0   57 55                 112
940873 940873 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_7 99 1 10 0   0     0   4   61 53                       114 99 1 10 0   0     0   4   61 53                 114
1131815 1131815 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_7 96 1 6 1   0     0   3   53 54                       107 96 1 6 1   0     0   3   53 54                 107
1373087 1373087 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_7 93 0 12 1   3     0   4   66 47 *                     113.0 93 0 12 1   3     0   4   66 47                 113
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
2238646 2238646 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston: Athol-Royalston Middle School   Regular School No Middle 05 08 2018   grade_7 91 0 6 0   0     0   3   49 51                       100.0 91 0 6 0   0     0   3   49 51                 100
741112 741112 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2015   grade_7 49 1 2 0   87     0   1   73 67                       140 49 1 2 0   87     0   1   73 67                 140
937941 937941 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2016   grade_7 69 7 4 2   79     0   3   75 89                       164 69 7 4 2   79     0   3   75 89                 164
1128361 1128361 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2017   grade_7 66 2 0 0   82     1   9   80 80                       160 66 2 0 0   82     1   9   80 80                 160
1370167 1370167 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_7 68 4 8 0   111     0   3   105 89 *                     194.0 68 4 8 0   111     0   3   105 89                 194
2045241 2045241 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_7 73 7 4 0   92     2   9   100 87                       187.0 73 7 4 0   92     2   9   100 87                 187
1680184 1680184 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_7 91 1 16 0   2     0   0   52 58 *                     110.0 91 1 16 0   2     0   0   52 58                 110
2238454 2238454 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_7 85 7 11 0   3     0   3   56 53                       109.0 85 7 11 0   3     0   3   56 53                 109
743873 743873 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_7 80 5 8 0   1     0   6   36 64                       100 80 5 8 0   1     0   6   36 64                 100
940703 940703 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_7 87 3 5 0   4     0   1   51 49                       100 87 3 5 0   4     0   1   51 49                 100
1131620 1131620 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_7 86 3 7 0   2     0   2   50 50                       100 86 3 7 0   2     0   2   50 50                 100
1372919 1372919 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_7 83 3 17 0   0     0   7   48 62 *                     110.0 83 3 17 0   0     0   7   48 62                 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
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
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
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
2229048 2229048 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_7 82 10 25 1   3     0   11   70 62                       132.0 82 10 25 1   3     0   11   70 62                 132
2229043 2229043 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_7 109 2 10 0   5     0   11   69 68                       137.0 109 2 10 0   5     0   11   69 68                 137
2229053 2229053 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_7 101 9 24 0   7     0   2   87 56                       143.0 101 9 24 0   7     0   2   87 56                 143
1672273 1672273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_7 175 9 20 0   6     0   8   94 124 *                     218.0 175 9 20 0   6     0   8   94 124                 218
735928 735928 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_7 164 4 10 1   6     0   11   106 90                       196 164 4 10 1   6     0   11   106 90                 196
932802 932802 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2016   grade_7 181 3 6 1   10     0   5   100 106                       206 181 3 6 1   10     0   5   100 106                 206
1122272 1122272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_7 179 3 14 0   5     0   9   105 105                       210 179 3 14 0   5     0   9   105 105                 210
1365050 1365050 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_7 154 4 26 0   9     0   9   104 98 *                     202.0 154 4 26 0   9     0   9   104 98                 202
2040078 2040078 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_7 171 2 17 0   9     0   7   113 93                       206.0 171 2 17 0   9     0   7   113 93                 206
2229078 2229078 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn: Auburn Middle   Regular School No Middle 06 08 2018   grade_7 181 3 21 0   9     0   4   121 97                       218.0 181 3 21 0   9     0   4   121 97                 218
1672289 1672289 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_7 28 14 5 3   4     0   5   33 26 *                     59.0 28 14 5 3   4     0   5   33 26                 59
735944 735944 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2015   grade_7 29 16 7 0   5     0   5   35 27                       62 29 16 7 0   5     0   5   35 27                 62
932818 932818 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_7 34 21 4 1   4     0   2   36 30                       66 34 21 4 1   4     0   2   36 30                 66
1122290 1122290 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_7 39 12 2 0   3     0   3   33 26                       59 39 12 2 0   3     0   3   33 26                 59
1365065 1365065 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_7 29 17 7 0   3     0   6   28 34 *                     62.0 29 17 7 0   3     0   6   28 34                 62
2040094 2040094 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_7 29 17 4 1   3     0   3   32 25                       57.0 29 17 4 1   3     0   3   32 25                 57
2229096 2229096 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_7 34 18 7 0   1     0   5   29 36                       65.0 34 18 7 0   1     0   5   29 36                 65
744061 744061 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2015   grade_7 93 10 12 0   3     0   5   68 55                       123 93 10 12 0   3     0   5   68 55                 123
940895 940895 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2016   grade_7 94 6 8 2   4     0   13   62 65                       127 94 6 8 2   4     0   13   62 65                 127
1131840 1131840 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_7 88 5 10 1   2     1   6   52 61                       113 88 5 10 1   2     1   6   52 61                 113
1373108 1373108 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_7 113 3 19 1   1     0   4   78 63 *                     141.0 113 3 19 1   1     0   4   78 63                 141
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
1680372 1680372 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_7 98 7 23 1   4     0   4   72 65 *                     137.0 98 7 23 1   4     0   4   72 65                 137
2238671 2238671 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 2018   grade_7 109 7 18 1   0     1   2   67 71                       138.0 109 7 18 1   0     1   2   67 71                 138

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