Data source: Big Local News · About: Big Local

395 rows where grade = "grade_11", state = "MA" and year = 2017 sorted by male

View and edit SQL

year

  • 2017 · 395

grade

  • grade_11 · 395
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
1125197 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_11 * * * *   *     *   *   * *                       *                                              
1125271 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_11 * * * *   *     *   *   * *                       *                                              
1132663 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   grade_11 6 1 0 0   0     0   0   * 5                       7 6 1 0 0   0     0   0     5                 7
1122641 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_11 * * * *   *     *   *   1 2                       *                         1 2                  
1128687 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_11 * * * *   *     *   *   1 *                       *                         1                    
1129431 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2017   grade_11 0 2 5 0   0     0   0   1 6                       7 0 2 5 0   0     0   0   1 6                 7
1131184 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   grade_11 * * * *   *     *   *   1 2                       *                         1 2                  
1126307 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 The Career Academy   Regular School No High 09 12 2017   grade_11 5 2 8 0   3     0   0   10 8                       18 5 2 8 0   3     0   0   10 8                 18
1129709 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 08 12 2017   grade_11 11 0 0 0   0     0   3   10 4                       14 11 0 0 0   0     0   3   10 4                 14
1125182 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2017   grade_11 176 3 16 0   3     4   2   101 103                       204 176 3 16 0   3     4   2   101 103                 204
1126326 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2017   grade_11 184 3 16 1   0     0   5   101 108                       209 184 3 16 1   0     0   5   101 108                 209
1127820 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2017   grade_11 205 1 5 0   9     2   1   102 121                       223 205 1 5 0   9     2   1   102 121                 223
1133094 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2017   grade_11 158 1 1 2   7     0   7   102 74                       176 158 1 1 2   7     0   7   102 74                 176
1122346 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   grade_11 153 17 15 0   25     0   10   103 117                       220 153 17 15 0   25     0   10   103 117                 220
1124864 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   grade_11 158 9 9 1   6     0   14   103 94                       197 158 9 9 1   6     0   14   103 94                 197
1132115 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2017   grade_11 186 3 4 0   7     0   1   103 98                       201 186 3 4 0   7     0   1   103 98                 201
1126792 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2017   grade_11 197 3 2 0   10     1   7   104 116                       220 197 3 2 0   10     1   7   104 116                 220
1124565 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2017   grade_11 189 8 8 0   9     0   1   105 110                       215 189 8 8 0   9     0   1   105 110                 215
1130569 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2017   grade_11 198 7 7 0   15     1   5   105 128                       233 198 7 7 0   15     1   5   105 128                 233
1132994 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2017   grade_11 130 5 17 1   1     0   7   105 56                       161 130 5 17 1   1     0   7   105 56                 161
1125343 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2017   grade_11 184 2 2 0   3     0   1   106 85                       192 184 2 2 0   3     0   1   106 85                 192
1133029 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2017   grade_11 82 12 86 0   0     0   4   106 78                       184 82 12 86 0   0     0   4   106 78                 184
1132083 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   grade_11 188 11 9 0   6     1   2   107 110                       217 188 11 9 0   6     1   2   107 110                 217
1124955 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2017   grade_11 172 13 3 0   3     1   1   108 85                       193 172 13 3 0   3     1   1   108 85                 193
1126865 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway High   Regular School No High 09 12 2017   grade_11 185 1 7 1   4     0   2   108 92                       200 185 1 7 1   4     0   2   108 92                 200
1127843 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No High 09 12 2017   grade_11 186 5 5 0   4     0   0   108 92                       200 186 5 5 0   4     0   0   108 92                 200
1132171 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2017   grade_11 194 1 1 1   13     0   0   108 102                       210 194 1 1 1   13     0   0   108 102                 210
1132006 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_11 144 19 22 2   8     0   7   109 93                       202 144 19 22 2   8     0   7   109 93                 202
1129985 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham Cooperative Alternative School   Regular School No High 09 12 2017   grade_11 15 0 2 0   0     0   2   11 8                       19 15 0 2 0   0     0   2   11 8                 19
1126643 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2017   grade_11 214 14 14 0   1     0   2   110 135                       245 214 14 14 0   1     0   2   110 135                 245
1133079 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2017   grade_11 159 1 3 0   0     0   2   112 53                       165 159 1 3 0   0     0   2   112 53                 165
1123852 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2017   grade_11 162 13 12 2   37     1   5   113 119                       232 162 13 12 2   37     1   5   113 119                 232
1130450 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2017   grade_11 219 7 5 0   10     0   7   113 135                       248 219 7 5 0   10     0   7   113 135                 248
1132034 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2017   grade_11 188 2 11 0   0     0   6   113 94                       207 188 2 11 0   0     0   6   113 94                 207
1124199 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2017   grade_11 146 9 87 0   9     1   3   115 140                       255 146 9 87 0   9     1   3   115 140                 255
1126142 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2017   grade_11 186 9 9 0   20     0   2   115 111                       226 186 9 9 0   20     0   2   115 111                 226
1128676 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2017   grade_11 88 14 105 0   8     0   12   116 111                       227 88 14 105 0   8     0   12   116 111                 227
1124330 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2017   grade_11 210 4 10 0   3     0   4   117 114                       231 210 4 10 0   3     0   4   117 114                 231
1127910 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No High 09 12 2017   grade_11 177 24 21 0   8     0   4   117 117                       234 177 24 21 0   8     0   4   117 117                 234
1132984 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_11 151 41 23 1   0     0   11   117 110                       227 151 41 23 1   0     0   11   117 110                 227
1130053 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2017   grade_11 154 11 8 0   35     1   10   118 101                       219 154 11 8 0   35     1   10   118 101                 219
1123282 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2017   grade_11 8 86 89 0   39     0   3   119 106                       225 8 86 89 0   39     0   3   119 106                 225
1128544 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Seacoast School   Regular School No High 09 12 2017   grade_11 3 0 11 0   0     0   3   12 5                       17 3 0 11 0   0     0   3   12 5                 17
1131146 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_11 24 2 2 0   2     1   0   12 19                       31 24 2 2 0   2     1   0   12 19                 31
1126911 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2017   grade_11 187 22 12 0   7     0   6   120 114                       234 187 22 12 0   7     0   6   120 114                 234
1123339 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_11 82 90 56 1   68     1   5   127 176                       303 82 90 56 1   68     1   5   127 176                 303
1131047 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2017   grade_11 86 52 84 0   15     0   14   127 124                       251 86 52 84 0   15     0   14   127 124                 251
1130165 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2017   grade_11 197 7 15 0   46     0   6   129 142                       271 197 7 15 0   46     0   6   129 142                 271
1125893 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   grade_11 1 1 23 0   0     0   0   13 12                       25 1 1 23 0   0     0   0   13 12                 25
1127789 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2017   grade_11 26 1 1 0   0     0   0   13 15                       28 26 1 1 0   0     0   0   13 15                 28
1132259 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2017   grade_11 238 8 19 1   3     2   3   130 144                       274 238 8 19 1   3     2   3   130 144                 274
1123272 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   grade_11 8 96 96 2   9     0   2   131 82                       213 8 96 96 2   9     0   2   131 82                 213
1129518 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2017   grade_11 170 52 11 0   20     0   1   131 123                       254 170 52 11 0   20     0   1   131 123                 254
1125662 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No High 09 12 2017   grade_11 237 2 1 1   25     0   4   132 138                       270 237 2 1 1   25     0   4   132 138                 270
1133089 MA Norfolk   school 2511735 878   Tri County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_11 204 0 10 0   1     0   10   132 93                       225 204 0 10 0   1     0   10   132 93                 225
1124489 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No High 09 12 2017   grade_11 269 0 3 0   1     0   2   133 142                       275 269 0 3 0   1     0   2   133 142                 275
1132484 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2017   grade_11 239 4 16 1   6     0   8   133 141                       274 239 4 16 1   6     0   8   133 141                 274
1126514 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_11 25 26 152 1   8     0   2   134 80                       214 25 26 152 1   8     0   2   134 80                 214
1127091 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2017   grade_11 162 58 9 0   21     3   9   134 128                       262 162 58 9 0   21     3   9   134 128                 262
1129735 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2017   grade_11 227 3 9 0   4     1   1   134 111                       245 227 3 9 0   4     1   1   134 111                 245
1129839 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2017   grade_11 243 7 8 1   8     1   3   134 137                       271 243 7 8 1   8     1   3   134 137                 271
1128848 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2017   grade_11 167 19 8 0   59     0   7   135 125                       260 167 19 8 0   59     0   7   135 125                 260
1123379 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_11 22 97 84 0   77     0   6   136 150                       286 22 97 84 0   77     0   6   136 150                 286
1127722 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2017   grade_11 263 8 18 2   14     0   3   136 172                       308 263 8 18 2   14     0   3   136 172                 308
1131770 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2017   grade_11 135 24 31 0   24     0   23   136 101                       237 135 24 31 0   24     0   23   136 101                 237
1132325 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No High 09 12 2017   grade_11 262 1 10 0   14     0   2   137 152                       289 262 1 10 0   14     0   2   137 152                 289
1132969 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2017   grade_11 277 3 11 0   2     0   6   137 162                       299 277 3 11 0   2     0   6   137 162                 299
1127017 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2017   grade_11 185 10 82 4   10     1   5   138 159                       297 185 10 82 4   10     1   5   138 159                 297
1132999 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex Technical High School   Career and Technical School No High 09 12 2017   grade_11 285 7 35 0   2     1   8   138 200                       338 285 7 35 0   2     1   8   138 200                 338
1124362 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2017   grade_11 243 4 6 0   2     0   15   139 131                       270 243 4 6 0   2     0   15   139 131                 270
1129891 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2017   grade_11 245 14 18 1   8     0   0   139 147                       286 245 14 18 1   8     0   0   139 147                 286
1124151 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_11 8 1 8 0   0     0   2   14 5                       19 8 1 8 0   0     0   2   14 5                 19
1125118 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   grade_11 17 0 3 0   1     0   0   14 7                       21 17 0 3 0   1     0   0   14 7                 21
1124004 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2017   grade_11 193 26 11 0   22     1   7   140 119                       260 193 26 11 0   22     1   7   140 119                 260
1128477 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2017   grade_11 251 5 3 0   12     0   4   141 134                       275 251 5 3 0   12     0   4   141 134                 275
1132074 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2017   grade_11 268 5 18 2   3     1   6   141 162                       303 268 5 18 2   3     1   6   141 162                 303
1126838 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No High 09 12 2017   grade_11 176 55 33 1   34     0   10   142 167                       309 176 55 33 1   34     0   10   142 167                 309
1128088 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2017   grade_11 265 2 1 0   3     2   2   143 132                       275 265 2 1 0   3     2   2   143 132                 275
1128260 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2017   grade_11 243 6 8 2   4     0   4   143 124                       267 243 6 8 2   4     0   4   143 124                 267
1132979 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2017   grade_11 289 1 7 0   1     0   2   143 157                       300 289 1 7 0   1     0   2   143 157                 300
1126682 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2017   grade_11 158 8 107 0   15     0   2   144 146                       290 158 8 107 0   15     0   2   144 146                 290
1129014 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No High 09 12 2017   grade_11 72 35 135 0   21     0   1   146 118                       264 72 35 135 0   21     0   1   146 118                 264
1126614 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2017   grade_11 267 10 15 1   10     0   8   147 164                       311 267 10 15 1   10     0   8   147 164                 311
1123287 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2017   grade_11 0 8 7 0   0     0   1   15 *                       16 0 8 7 0   0     0   1   15                   16
1125375 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_11 25 2 0 0   0     0   2   15 14                       29 25 2 0 0   0     0   2   15 14                 29
1125888 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_11 0 1 16 0   0     0   0   15 2                       17 0 1 16 0   0     0   0   15 2                 17
1133151 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_11 10 20 1 0   5     0   1   15 22                       37 10 20 1 0   5     0   1   15 22                 37
1133160 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2017   grade_11 0 6 23 0   0     0   0   15 14                       29 0 6 23 0   0     0   0   15 14                 29
1122549 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2017   grade_11 272 5 11 0   16     2   4   151 159                       310 272 5 11 0   16     2   4   151 159                 310
1132974 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2017   grade_11 215 3 37 3   1     0   7   151 115                       266 215 3 37 3   1     0   7   151 115                 266
1131977 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2017   grade_11 252 12 19 0   32     0   10   152 173                       325 252 12 19 0   32     0   10   152 173                 325
1131067 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   grade_11 130 47 139 0   20     0   11   153 194                       347 130 47 139 0   20     0   11   153 194                 347
1128389 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_11 101 3 14 1   181     0   2   154 148                       302 101 3 14 1   181     0   2   154 148                 302
1130263 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No High 09 12 2017   grade_11 269 7 36 0   8     1   1   155 167                       322 269 7 36 0   8     1   1   155 167                 322
1125621 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2017   grade_11 84 6 182 0   3     0   5   156 124                       280 84 6 182 0   3     0   5   156 124                 280
1133084 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2017   grade_11 239 2 21 0   1     0   2   156 109                       265 239 2 21 0   1     0   2   156 109                 265
1124593 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No High 09 12 2017   grade_11 267 13 20 1   13     0   12   158 168                       326 267 13 20 1   13     0   12   158 168                 326
1132686 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2017   grade_11 308 4 4 0   4     2   1   158 165                       323 308 4 4 0   4     2   1   158 165                 323
1122013 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_11 257 5 16 0   6     1   8   159 134                       293 257 5 16 0   6     1   8   159 134                 293
1122493 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2017   grade_11 284 8 23 0   9     0   9   159 174                       333 284 8 23 0   9     0   9   159 174                 333

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