enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_7", state = "MA" and year = 2015 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 493 ✖

grade ✖

  • grade_7 · 493 ✖
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
736773 736773 MA Suffolk   school 2502790 35   Boston 250279001615 350413 Boston Middle School Academy   Regular School No 2 07 08 2015   grade_7 * * * *   *     *   *   1 *                       1                         1                   1
738119 738119 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_7 4 1 3 0   0     0   2   9 *                       10 4 1 3 0   0     0   2   9                   10
738476 738476 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No 2 04 07 2015   grade_7 * * * *   *     *   *   3 *                       3                         3                   3
739320 739320 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_7 * * * *   *     *   *   4 *                       4                         4                   4
741676 741676 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_7 0 2 4 0   0     0   0   5 *                       6 0 2 4 0   0     0   0   5                   6
735706 735706 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_7 * * * *   *     *   *   2 1                       3                         2 1                 3
737140 737140 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_7 * * * *   *     *   *   3 1                       4                         3 1                 4
737548 737548 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_7 2 0 4 0   0     0   0   5 1                       6 2 0 4 0   0     0   0   5 1                 6
737984 737984 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_7 * * * *   *     *   *   2 1                       3                         2 1                 3
738604 738604 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_7 * * * *   *     *   *   1 1                       2                         1 1                 2
739015 739015 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_7 3 0 9 0   0     0   0   11 1                       12 3 0 9 0   0     0   0   11 1                 12
740759 740759 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2015   grade_7 * * * *   *     *   *   1 1                       2                         1 1                 2
736290 736290 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 07 2015   grade_7 3 10 10 0   0     0   1   14 10                       24 3 10 10 0   0     0   1   14 10                 24
736546 736546 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_7 7 4 6 0   0     0   0   7 10                       17 7 4 6 0   0     0   0   7 10                 17
736735 736735 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_7 0 20 7 1   0     0   0   18 10                       28 0 20 7 1   0     0   0   18 10                 28
741276 741276 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_7 20 0 1 0   0     0   0   11 10                       21 20 0 1 0   0     0   0   11 10                 21
743652 743652 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2015   grade_7 15 0 2 0   1     0   2   10 10                       20 15 0 2 0   1     0   2   10 10                 20
741963 741963 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2015   grade_7 28 34 133 0   1     0   5   101 100                       201 28 34 133 0   1     0   5   101 100                 201
742053 742053 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No 2 05 08 2015   grade_7 181 4 9 0   7     0   5   106 100                       206 181 4 9 0   7     0   5   106 100                 206
739373 739373 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2015   grade_7 169 3 17 0   2     0   7   97 101                       198 169 3 17 0   2     0   7   97 101                 198
744335 744335 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_7 194 2 1 0   9     1   0   106 101                       207 194 2 1 0   9     1   0   106 101                 207
736024 736024 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial Middle School   Regular School No 2 05 08 2015   grade_7 168 3 10 1   7     0   3   90 102                       192 168 3 10 1   7     0   3   90 102                 192
737156 737156 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_7 69 95 32 1   8     2   8   113 102                       215 69 95 32 1   8     2   8   113 102                 215
740299 740299 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No 2 06 08 2015   grade_7 156 1 6 0   5     0   4   70 102                       172 156 1 6 0   5     0   4   70 102                 172
744260 744260 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_7 168 8 1 1   8     0   6   90 102                       192 168 8 1 1   8     0   6   90 102                 192
735796 735796 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2015   grade_7 153 2 4 1   28     0   4   89 103                       192 153 2 4 1   28     0   4   89 103                 192
741205 741205 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No 2 06 08 2015   grade_7 169 3 4 1   11     0   1   86 103                       189 169 3 4 1   11     0   1   86 103                 189
742717 742717 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2015   grade_7 164 4 29 0   8     0   2   104 103                       207 164 4 29 0   8     0   2   104 103                 207
738362 738362 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_7 164 10 26 0   4     0   9   108 105                       213 164 10 26 0   4     0   9   108 105                 213
739765 739765 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2015   grade_7 191 2 5 1   11     0   6   111 105                       216 191 2 5 1   11     0   6   111 105                 216
740667 740667 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2015   grade_7 193 2 4 0   3     1   2   100 105                       205 193 2 4 0   3     1   2   100 105                 205
741960 741960 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No 2 06 08 2015   grade_7 28 41 156 0   20     0   2   142 105                       247 28 41 156 0   20     0   2   142 105                 247
742236 742236 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2015   grade_7 180 24 14 0   2     0   7   122 105                       227 180 24 14 0   2     0   7   122 105                 227
742478 742478 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_7 152 19 13 3   3     0   25   110 105                       215 152 19 13 3   3     0   25   110 105                 215
740688 740688 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No 2 06 08 2015   grade_7 194 3 0 0   6     1   2   100 106                       206 194 3 0 0   6     1   2   100 106                 206
744481 744481 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 05 08 2015   grade_7 191 2 4 0   3     0   5   99 106                       205 191 2 4 0   3     0   5   99 106                 205
737660 737660 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_7 174 7 8 0   13     0   8   103 107                       210 174 7 8 0   13     0   8   103 107                 210
738294 738294 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_7 113 9 75 0   18     1   9   118 107                       225 113 9 75 0   18     1   9   118 107                 225
744288 744288 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2015   grade_7 248 3 1 0   3     1   2   151 107                       258 248 3 1 0   3     1   2   151 107                 258
744655 744655 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No 2 07 08 2015   grade_7 205 5 5 0   4     0   4   116 107                       223 205 5 5 0   4     0   4   116 107                 223
738419 738419 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_7 171 3 15 0   4     3   7   95 108                       203 171 3 15 0   4     3   7   95 108                 203
744685 744685 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No 2 07 08 2015   grade_7 243 0 5 0   2     0   1   143 108                       251 243 0 5 0   2     0   1   143 108                 251
736160 736160 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No 2 06 08 2015   grade_7 196 2 6 0   13     0   6   114 109                       223 196 2 6 0   13     0   6   114 109                 223
738106 738106 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2015   grade_7 125 16 53 2   16     0   13   116 109                       225 125 16 53 2   16     0   13   116 109                 225
738700 738700 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2015   grade_7 216 1 4 0   14     0   8   134 109                       243 216 1 4 0   14     0   8   134 109                 243
740649 740649 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No 2 06 08 2015   grade_7 210 1 5 0   5     0   1   113 109                       222 210 1 5 0   5     0   1   113 109                 222
742751 742751 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2015   grade_7 180 1 2 0   52     0   6   132 109                       241 180 1 2 0   52     0   6   132 109                 241
736468 736468 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   grade_7 8 4 8 0   1     0   0   10 11                       21 8 4 8 0   1     0   0   10 11                 21
736664 736664 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_7 7 6 8 0   0     0   0   10 11                       21 7 6 8 0   0     0   0   10 11                 21
736725 736725 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_7 1 14 7 0   0     0   1   12 11                       23 1 14 7 0   0     0   1   12 11                 23
743907 743907 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter(District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 10 2015   grade_7 6 1 0 0   7     0   1   4 11                       15 6 1 0 0   7     0   1   4 11                 15
737902 737902 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2015   grade_7 191 7 5 2   14     0   4   113 110                       223 191 7 5 2   14     0   4   113 110                 223
742539 742539 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2015   grade_7 151 13 16 0   28     0   11   109 110                       219 151 13 16 0   28     0   11   109 110                 219
737036 737036 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No 2 06 08 2015   grade_7 180 7 4 0   35     0   3   118 111                       229 180 7 4 0   35     0   3   118 111                 229
739515 739515 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2015   grade_7 93 16 71 1   28     0   6   104 111                       215 93 16 71 1   28     0   6   104 111                 215
743991 743991 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No 2 07 08 2015   grade_7 138 11 31 1   21     1   18   110 111                       221 138 11 31 1   21     1   18   110 111                 221
737588 737588 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Fairview Middle   Regular School No 2 06 08 2015   grade_7 147 7 63 0   4     0   6   115 112                       227 147 7 63 0   4     0   6   115 112                 227
737853 737853 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_7 177 8 3 0   1     0   6   83 112                       195 177 8 3 0   1     0   6   83 112                 195
738109 738109 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_7 150 17 44 1   7     0   10   117 112                       229 150 17 44 1   7     0   10   117 112                 229
738231 738231 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2015   grade_7 192 11 6 0   6     0   5   108 112                       220 192 11 6 0   6     0   5   108 112                 220
737162 737162 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2015   grade_7 58 97 54 1   5     0   6   108 113                       221 58 97 54 1   5     0   6   108 113                 221
737484 737484 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_7 186 3 7 0   30     1   3   117 113                       230 186 3 7 0   30     1   3   117 113                 230
738443 738443 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2015   grade_7 203 0 12 0   33     0   3   138 113                       251 203 0 12 0   33     0   3   138 113                 251
741015 741015 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No 2 05 08 2015   grade_7 217 2 4 0   2     0   7   119 113                       232 217 2 4 0   2     0   7   119 113                 232
744889 744889 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No 2 07 08 2015   grade_7 222 5 7 0   3     0   1   125 113                       238 222 5 7 0   3     0   1   125 113                 238
738829 738829 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No 2 05 07 2015   grade_7 215 5 15 1   2     0   5   129 114                       243 215 5 15 1   2     0   5   129 114                 243
740946 740946 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2015   grade_7 160 30 16 0   6     0   5   103 114                       217 160 30 16 0   6     0   5   103 114                 217
741486 741486 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No 2 07 08 2015   grade_7 215 8 0 0   4     0   5   118 114                       232 215 8 0 0   4     0   5   118 114                 232
741533 741533 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No 2 06 08 2015   grade_7 153 17 11 0   60     0   10   137 114                       251 153 17 11 0   60     0   10   137 114                 251
744961 744961 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2015   grade_7 199 6 14 0   7     0   10   122 114                       236 199 6 14 0   7     0   10   122 114                 236
738629 738629 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_7 131 9 81 1   5     0   1   111 117                       228 131 9 81 1   5     0   1   111 117                 228
740722 740722 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No 2 06 08 2015   grade_7 163 48 23 0   12     0   3   131 118                       249 163 48 23 0   12     0   3   131 118                 249
742714 742714 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2015   grade_7 197 4 22 0   2     0   9   116 118                       234 197 4 22 0   2     0   9   116 118                 234
740401 740401 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2015   grade_7 152 13 16 1   51     0   9   123 119                       242 152 13 16 1   51     0   9   123 119                 242
741118 741118 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_7 129 9 3 0   72     0   3   97 119                       216 129 9 3 0   72     0   3   97 119                 216
741163 741163 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2015   grade_7 24 139 31 0   33     2   4   114 119                       233 24 139 31 0   33     2   4   114 119                 233
744127 744127 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No 2 07 08 2015   grade_7 228 6 3 0   2     0   2   122 119                       241 228 6 3 0   2     0   2   122 119                 241
740093 740093 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2015   grade_7 200 10 8 0   13     1   10   121 121                       242 200 10 8 0   13     1   10   121 121                 242
740876 740876 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No 2 07 08 2015   grade_7 240 2 0 1   4     1   2   129 121                       250 240 2 0 1   4     1   2   129 121                 250
739642 739642 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No 2 07 08 2015   grade_7 210 8 15 0   4     0   9   124 122                       246 210 8 15 0   4     0   9   124 122                 246
742634 742634 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No 2 07 08 2015   grade_7 175 6 12 0   69     0   6   145 123                       268 175 6 12 0   69     0   6   145 123                 268
736157 736157 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2015   grade_7 237 5 15 0   8     0   5   146 124                       270 237 5 15 0   8     0   5   146 124                 270
737033 737033 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No 2 06 08 2015   grade_7 206 11 12 0   22     0   1   128 124                       252 206 11 12 0   22     0   1   128 124                 252
737760 737760 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2015   grade_7 173 20 32 1   4     0   3   109 124                       233 173 20 32 1   4     0   3   109 124                 233
740273 740273 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_7 123 31 93 1   2     2   10   136 126                       262 123 31 93 1   2     2   10   136 126                 262
741411 741411 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No 2 07 08 2015   grade_7 241 5 4 1   7     0   1   133 126                       259 241 5 4 1   7     0   1   133 126                 259
742965 742965 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2015   grade_7 240 4 9 0   9     0   3   139 126                       265 240 4 9 0   9     0   3   139 126                 265
743818 743818 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_7 5 135 90 0   2     0   3   108 127                       235 5 135 90 0   2     0   3   108 127                 235
739928 739928 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No 2 06 08 2015   grade_7 230 3 9 6   0     0   8   128 128                       256 230 3 9 6   0     0   8   128 128                 256
739161 739161 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_7 128 14 6 0   94     0   15   128 129                       257 128 14 6 0   94     0   15   128 129                 257
738562 738562 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_7 28 0 1 0   0     0   2   18 13                       31 28 0 1 0   0     0   2   18 13                 31
740434 740434 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_7 23 3 2 0   0     0   1   16 13                       29 23 3 2 0   0     0   1   16 13                 29
743558 743558 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_7 0 8 10 0   0     0   1   6 13                       19 0 8 10 0   0     0   1   6 13                 19
737426 737426 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No 2 06 08 2015   grade_7 191 24 9 0   24     0   10   127 131                       258 191 24 9 0   24     0   10   127 131                 258
737839 737839 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No 2 06 08 2015   grade_7 258 1 4 0   1     0   3   136 131                       267 258 1 4 0   1     0   3   136 131                 267
738803 738803 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No 2 06 08 2015   grade_7 247 1 1 1   18     0   3   139 132                       271 247 1 1 1   18     0   3   139 132                 271
742247 742247 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2015   grade_7 200 24 32 0   4     0   8   136 132                       268 200 24 32 0   4     0   8   136 132                 268
737925 737925 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2015   grade_7 240 11 12 1   5     0   6   142 133                       275 240 11 12 1   5     0   6   142 133                 275
744199 744199 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2015   grade_7 174 19 18 4   7     0   13   102 133                       235 174 19 18 4   7     0   13   102 133                 235
737294 737294 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2015   grade_7 219 14 14 3   37     0   9   162 134                       296 219 14 14 3   37     0   9   162 134                 296

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