enrollments

Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 490 ✖

grade ✖

  • grade_8 · 490 ✖
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
1124820 1124820 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_8 2 1 3 0   0     0   0   6 *                       6 2 1 3 0   0     0   0   6                   6
1125194 1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1128684 1128684 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_8 * * * *   *     *   *   2 *                       *                         2                    
1129010 1129010 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_8 2 3 6 0   0     0   0   7 *                       11 2 3 6 0   0     0   0   7                   11
1122006 1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1123655 1123655 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_8 * * * *   *     *   *   3 1                       *                         3 1                  
1122732 1122732 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_8 7 7 11 0   2     0   0   17 10                       27 7 7 11 0   2     0   0   17 10                 27
1123139 1123139 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_8 1 17 15 0   0     0   0   23 10                       33 1 17 15 0   0     0   0   23 10                 33
1124215 1124215 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_8 16 0 0 0   0     0   0   6 10                       16 16 0 0 0   0     0   0   6 10                 16
1124812 1124812 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No Middle 06 08 2017   grade_8 7 3 8 0   0     0   1   9 10                       19 7 3 8 0   0     0   1   9 10                 19
1128535 1128535 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2017   grade_8 65 5 105 2   3     0   4   84 100                       184 65 5 105 2   3     0   4   84 100                 184
1132070 1132070 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_8 178 1 19 0   1     0   6   105 100                       205 178 1 19 0   1     0   6   105 100                 205
1126534 1126534 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2017   grade_8 170 1 7 0   7     0   5   89 101                       190 170 1 7 0   7     0   5   89 101                 190
1128931 1128931 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2017   grade_8 198 2 7 1   0     0   8   115 101                       216 198 2 7 1   0     0   8   115 101                 216
1123689 1123689 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2017   grade_8 54 109 28 1   5     2   9   106 102                       208 54 109 28 1   5     2   9   106 102                 208
1124796 1124796 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2017   grade_8 103 10 59 0   12     0   6   88 102                       190 103 10 59 0   12     0   6   88 102                 190
1124883 1124883 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_8 56 14 82 0   7     0   16   73 102                       175 56 14 82 0   7     0   16   73 102                 175
1122109 1122109 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_8 147 2 9 0   26     0   5   86 103                       189 147 2 9 0   26     0   5   86 103                 189
1123697 1123697 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_8 65 79 48 2   7     0   10   108 103                       211 65 79 48 2   7     0   10   108 103                 211
1125178 1125178 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2017   grade_8 157 2 23 1   0     1   4   85 103                       188 157 2 23 1   0     1   4   85 103                 188
1128531 1128531 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2017   grade_8 57 7 101 2   14     0   4   82 103                       185 57 7 101 2   14     0   4   82 103                 185
1131791 1131791 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2017   grade_8 191 0 8 0   3     0   2   101 103                       204 191 0 8 0   3     0   2   101 103                 204
1128370 1128370 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_8 112 6 6 0   90     1   6   117 104                       221 112 6 6 0   90     1   6   117 104                 221
1132079 1132079 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   grade_8 167 6 11 2   4     0   3   89 104                       193 167 6 11 2   4     0   3   89 104                 193
1122196 1122196 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_8 144 4 27 0   19     0   8   97 105                       202 144 4 27 0   19     0   8   97 105                 202
1124394 1124394 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2017   grade_8 161 14 26 0   5     0   9   110 105                       215 161 14 26 0   5     0   9   110 105                 215
1127816 1127816 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No Middle 06 08 2017   grade_8 182 3 3 0   7     0   5   95 105                       200 182 3 3 0   7     0   5   95 105                 200
1125689 1125689 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2017   grade_8 201 3 9 2   3     0   3   115 106                       221 201 3 9 2   3     0   3   115 106                 221
1129467 1129467 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2017   grade_8 169 4 15 0   9     0   7   98 106                       204 169 4 15 0   9     0   7   98 106                 204
1124068 1124068 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_8 184 5 8 0   22     0   5   116 108                       224 184 5 8 0   22     0   5   116 108                 224
1124804 1124804 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_8 154 11 43 0   8     0   11   119 108                       227 154 11 43 0   8     0   11   119 108                 227
1125221 1125221 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2017   grade_8 174 4 10 0   19     0   7   106 108                       214 174 4 10 0   19     0   7   106 108                 214
1127756 1127756 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2017   grade_8 189 4 9 2   23     0   9   128 108                       236 189 4 9 2   23     0   9   128 108                 236
1130019 1130019 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2017   grade_8 140 10 34 2   20     0   6   104 108                       212 140 10 34 2   20     0   6   104 108                 212
1124277 1124277 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_8 184 11 12 0   14     0   6   118 109                       227 184 11 12 0   14     0   6   118 109                 227
1125532 1125532 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2017   grade_8 193 1 6 2   17     0   5   115 109                       224 193 1 6 2   17     0   5   115 109                 224
1132338 1132338 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2017   grade_8 177 2 9 0   1     0   8   88 109                       197 177 2 9 0   1     0   8   88 109                 197
1123104 1123104 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2017   grade_8 5 5 23 0   1     0   1   24 11                       35 5 5 23 0   1     0   1   24 11                 35
1131288 1131288 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_8 1 16 4 0   0     0   1   11 11                       22 1 16 4 0   0     0   1   11 11                 22
1125339 1125339 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_8 214 2 5 0   5     0   0   116 110                       226 214 2 5 0   5     0   0   116 110                 226
1127531 1127531 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_8 166 10 14 1   51     0   10   142 110                       252 166 10 14 1   51     0   10   142 110                 252
1122273 1122273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_8 181 4 5 1   12     0   5   97 111                       208 181 4 5 1   12     0   5   97 111                 208
1130255 1130255 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No Middle 06 08 2017   grade_8 179 3 21 0   2     1   4   99 111                       210 179 3 21 0   2     1   4   99 111                 210
1125450 1125450 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_8 134 7 86 0   3     0   2   120 112                       232 134 7 86 0   3     0   2   120 112                 232
1130299 1130299 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_8 142 2 1 2   57     0   5   97 112                       209 142 2 1 2   57     0   5   97 112                 209
1132656 1132656 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   grade_8 198 1 7 0   1     0   9   103 113                       216 198 1 7 0   1     0   9   103 113                 216
1128247 1128247 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 05 08 2017   grade_8 232 3 4 1   4     0   5   134 115                       249 232 3 4 1   4     0   5   134 115                 249
1127627 1127627 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_8 152 10 32 0   5     0   9   92 116                       208 152 10 32 0   5     0   9   92 116                 208
1128084 1128084 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2017   grade_8 237 4 3 0   2     0   2   132 116                       248 237 4 3 0   2     0   2   132 116                 248
1123551 1123551 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2017   grade_8 176 5 5 0   36     0   3   108 117                       225 176 5 5 0   36     0   3   108 117                 225
1132574 1132574 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2017   grade_8 221 4 3 0   7     0   4   122 117                       239 221 4 3 0   7     0   4   122 117                 239
1131558 1131558 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_8 2 129 108 0   0     1   1   123 118                       241 2 129 108 0   0     1   1   123 118                 241
1131766 1131766 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2017   grade_8 121 16 41 0   16     1   23   100 118                       218 121 16 41 0   16     1   23   100 118                 218
1132961 1132961 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2017   grade_8 194 2 4 1   2     1   4   90 118                       208 194 2 4 1   2     1   4   90 118                 208
1123547 1123547 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2017   grade_8 184 16 11 0   37     0   3   132 119                       251 184 16 11 0   37     0   3   132 119                 251
1122874 1122874 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_8 0 0 17 0   0     0   0   5 12                       17 0 0 17 0   0     0   0   5 12                 17
1132833 1132833 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_8 15 2 2 1   0     0   0   8 12                       20 15 2 2 1   0     0   0   8 12                 20
1128701 1128701 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   grade_8 223 2 2 3   9     1   1   121 120                       241 223 2 2 3   9     1   1   121 120                 241
1127539 1127539 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2017   grade_8 127 13 14 0   51     0   12   96 121                       217 127 13 14 0   51     0   12   96 121                 217
1126322 1126322 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2017   grade_8 204 4 17 0   1     0   9   113 122                       235 204 4 17 0   1     0   9   113 122                 235
1125030 1125030 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   grade_8 139 6 57 0   20     0   6   105 123                       228 139 6 57 0   20     0   6   105 123                 228
1130049 1130049 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2017   grade_8 160 12 9 0   34     0   17   108 124                       232 160 12 9 0   34     0   17   108 124                 232
1126062 1126062 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_8 152 5 9 1   85     0   14   141 125                       266 152 5 9 1   85     0   14   141 125                 266
1127175 1127175 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_8 169 7 27 0   13     1   17   109 125                       234 169 7 27 0   13     1   17   109 125                 234
1127906 1127906 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2017   grade_8 180 20 25 0   16     0   8   124 125                       249 180 20 25 0   16     0   8   124 125                 249
1130303 1130303 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_8 188 1 6 0   50     0   9   129 125                       254 188 1 6 0   50     0   9   129 125                 254
1124195 1124195 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2017   grade_8 150 8 93 1   7     1   9   143 126                       269 150 8 93 1   7     1   9   143 126                 269
1128844 1128844 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2017   grade_8 161 13 11 0   83     1   10   152 127                       279 161 13 11 0   83     1   10   152 127                 279
1132111 1132111 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2017   grade_8 249 1 2 0   3     0   3   131 127                       258 249 1 2 0   3     0   3   131 127                 258
1124485 1124485 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2017   grade_8 245 1 9 0   5     0   5   137 128                       265 245 1 9 0   5     0   5   137 128                 265
1129347 1129347 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2017   grade_8 16 46 163 0   18     0   2   117 128                       245 16 46 163 0   18     0   2   117 128                 245
1127382 1127382 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_8 101 34 113 1   1     0   17   138 129                       267 101 34 113 1   1     0   17   138 129                 267
1123123 1123123 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_8 11 9 9 1   2     0   0   19 13                       32 11 9 9 1   2     0   0   19 13                 32
1123192 1123192 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_8 0 15 10 0   1     0   3   16 13                       29 0 15 10 0   1     0   3   16 13                 29
1123201 1123201 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_8 1 17 8 0   1     0   2   16 13                       29 1 17 8 0   1     0   2   16 13                 29
1123440 1123440 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_8 0 1 24 0   0     0   0   12 13                       25 0 1 24 0   0     0   0   12 13                 25
1129217 1129217 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_8 8 8 8 0   1     0   1   13 13                       26 8 8 8 0   1     0   1   13 13                 26
1131381 1131381 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 27 0 2 0   0     0   0   16 13                       29 27 0 2 0   0     0   0   16 13                 29
1123847 1123847 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2017   grade_8 216 11 9 1   30     0   10   146 130                       277 216 11 9 1   30     0   10   146 130                 277
1126980 1126980 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_8 246 6 10 2   2     0   6   142 130                       272 246 6 10 2   2     0   6   142 130                 272
1132538 1132538 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2017   grade_8 222 9 1 0   3     0   10   115 130                       245 222 9 1 0   3     0   10   115 130                 245
1131921 1131921 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2017   grade_8 228 12 3 0   2     0   9   122 132                       254 228 12 3 0   2     0   9   122 132                 254
1128789 1128789 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No Middle 07 08 2017   grade_8 243 9 2 0   3     0   3   127 133                       260 243 9 2 0   3     0   3   127 133                 260
1124191 1124191 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_8 161 8 78 2   9     0   7   129 136                       265 161 8 78 2   9     0   7   129 136                 265
1125986 1125986 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2017   grade_8 161 22 90 1   10     0   9   157 136                       293 161 22 90 1   10     0   9   157 136                 293
1126639 1126639 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2017   grade_8 222 6 16 0   5     0   8   121 136                       257 222 6 16 0   5     0   8   121 136                 257
1124326 1124326 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2017   grade_8 244 3 24 0   4     0   9   147 137                       284 244 3 24 0   4     0   9   147 137                 284
1124000 1124000 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2017   grade_8 177 30 12 0   34     0   13   127 139                       266 177 30 12 0   34     0   13   127 139                 266
1126907 1126907 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2017   grade_8 225 16 6 0   11     0   8   127 139                       266 225 16 6 0   11     0   8   127 139                 266
1130161 1130161 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2017   grade_8 204 4 23 1   78     1   10   182 139                       321 204 4 23 1   78     1   10   182 139                 321
1131032 1131032 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_8 73 55 116 1   11     0   12   129 139                       268 73 55 116 1   11     0   12   129 139                 268
1126090 1126090 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_8 14 6 7 0   2     0   5   20 14                       34 14 6 7 0   2     0   5   20 14                 34
1131362 1131362 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 29 0 1 0   14     0   2   32 14                       46 29 0 1 0   14     0   2   32 14                 46
1126058 1126058 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_8 133 13 10 1   99     0   15   129 142                       271 133 13 10 1   99     0   15   129 142                 271
1127086 1127086 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2017   grade_8 201 56 14 1   15     1   11   157 142                       299 201 56 14 1   15     1   11   157 142                 299
1130446 1130446 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2017   grade_8 221 8 10 0   19     0   2   118 142                       260 221 8 10 0   19     0   2   118 142                 260
1124860 1124860 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_8 228 12 5 4   10     0   19   134 144                       278 228 12 5 4   10     0   19   134 144                 278
1127013 1127013 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_8 205 9 76 6   6     0   11   168 145                       313 205 9 76 6   6     0   11   168 145                 313
1129835 1129835 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_8 262 10 14 1   4     1   2   149 145                       294 262 10 14 1   4     1   2   149 145                 294

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