Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
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                  
1123449 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_8 * * * *   *     *   *   1 2                       *                         1 2                  
1122569 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_8 11 1 3 0   1     0   1   10 7                       17 11 1 3 0   1     0   1   10 7                 17
1126504 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_8 11 0 6 0   0     0   0   10 7                       17 11 0 6 0   0     0   0   10 7                 17
1123685 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_8 44 94 21 0   8     0   9   100 76                       176 44 94 21 0   8     0   9   100 76                 176
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
1127769 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2017   grade_8 172 0 11 0   2     1   5   101 90                       191 172 0 11 0   2     1   5   101 90                 191
1128672 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2017   grade_8 98 10 67 0   4     0   5   101 83                       184 98 10 67 0   4     0   5   101 83                 184
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
1124063 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_8 153 6 6 0   21     0   4   103 87                       190 153 6 6 0   21     0   4   103 87                 190
1129355 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2017   grade_8 29 43 116 1   9     0   3   103 98                       201 29 43 116 1   9     0   3   103 98                 201
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
1123477 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_8 162 4 7 1   5     0   12   104 87                       191 162 4 7 1   5     0   12   104 87                 191
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
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
1126788 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2017   grade_8 180 2 4 0   11     0   7   105 99                       204 180 2 4 0   11     0   7   105 99                 204
1130259 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No Middle 06 08 2017   grade_8 161 8 20 0   6     0   2   105 92                       197 161 8 20 0   6     0   2   105 92                 197
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
1122540 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2017   grade_8 177 5 8 0   11     0   3   106 98                       204 177 5 8 0   11     0   3   106 98                 204
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
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
1128473 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No Middle 06 08 2017   grade_8 174 7 5 2   7     0   1   107 89                       196 174 7 5 2   7     0   1   107 89                 196
1132810 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No Middle 07 08 2017   grade_8 185 1 6 2   4     0   3   107 94                       201 185 1 6 2   4     0   3   107 94                 201
1122361 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2017   grade_8 189 6 4 0   4     0   4   108 99                       207 189 6 4 0   4     0   4   108 99                 207
1123237 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2017   grade_8 4 103 80 0   13     1   3   108 96                       204 4 103 80 0   13     1   3   108 96                 204
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
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
1129946 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2017   grade_8 84 17 73 0   5     0   11   108 82                       190 84 17 73 0   5     0   11   108 82                 190
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
1122385 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2017   grade_8 163 4 7 0   8     0   3   109 76                       185 163 4 7 0   8     0   3   109 76                 185
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
1127394 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No Other 06 12 2017   grade_8 3 3 8 0   0     0   1   11 4                       15 3 3 8 0   0     0   1   11 4                 15
1128280 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_8 9 1 4 0   0     0   3   11 6                       17 9 1 4 0   0     0   3   11 6                 17
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
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
1128165 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_8 148 24 24 1   6     0   7   111 99                       210 148 24 24 1   6     0   7   111 99                 210
1123336 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_8 87 51 60 1   64     0   6   113 156                       269 87 51 60 1   64     0   6   113 156                 269
1123677 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2017   grade_8 24 139 29 0   0     1   9   113 89                       202 24 139 29 0   0     1   9   113 89                 202
1124800 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2017   grade_8 125 16 40 0   8     1   14   113 91                       204 125 16 40 0   8     1   14   113 91                 204
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
1128497 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2017   grade_8 89 8 84 4   12     0   3   113 87                       200 89 8 84 4   12     0   3   113 87                 200
1132167 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2017   grade_8 186 3 4 0   15     0   1   113 96                       209 186 3 4 0   15     0   1   113 96                 209
1127839 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2017   grade_8 192 3 4 0   6     1   3   114 95                       209 192 3 4 0   6     1   3   114 95                 209
1128423 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2017   grade_8 28 95 34 0   39     0   9   114 91                       205 28 95 34 0   39     0   9   114 91                 205
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
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
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
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
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
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
1126491 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2017   grade_8 89 11 77 1   21     0   8   117 90                       207 89 11 77 1   21     0   8   117 90                 207
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
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
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
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
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
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
1129387 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No Other 06 11 2017   grade_8 11 20 26 0   0     0   1   12 46                       58 11 20 26 0   0     0   1   12 46                 58
1131457 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_8 11 0 1 0   2     0   1   12 3                       15 11 0 1 0   2     0   1   12 3                 15
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
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
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
1128740 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2017   grade_8 168 7 32 1   8     1   3   121 99                       220 168 7 32 1   8     1   3   121 99                 220
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
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 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
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
1132003 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_8 154 20 21 8   4     1   13   125 96                       221 154 20 21 8   4     1   13   125 96                 221
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 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
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
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
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
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
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
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
1122992 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_8 8 3 5 0   0     1   3   13 7                       20 8 3 5 0   0     1   3   13 7                 20
1128661 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2017   grade_8 24 0 10 0   0     0   3   13 24                       37 24 0 10 0   0     0   3   13 24                 37
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
1131417 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 26 2 6 0   0     0   0   13 21                       34 26 2 6 0   0     0   0   13 21                 34
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
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
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
1132770 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No Middle 07 08 2017   grade_8 267 2 14 0   2     0   4   132 157                       289 267 2 14 0   2     0   4   132 157                 289
1132894 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2017   grade_8 244 5 13 1   17     0   9   132 157                       289 244 5 13 1   17     0   9   132 157                 289
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
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
1124589 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2017   grade_8 248 17 13 0   10     0   5   135 158                       293 248 17 13 0   10     0   5   135 158                 293
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
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
1127786 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2017   grade_8 29 0 1 0   0     0   1   14 17                       31 29 0 1 0   0     0   1   14 17                 31
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
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
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
1130565 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_8 257 6 10 0   14     0   9   142 154                       296 257 6 10 0   14     0   9   142 154                 296
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
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
1127374 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_8 113 48 102 3   4     2   21   146 147                       293 113 48 102 3   4     2   21   146 147                 293

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