Data source: Big Local News · About: Big Local

392 rows where grade = "grade_9", state = "MA" and year = 2016 sorted by female

View and edit SQL

year

  • 2016 · 392

grade

  • grade_9 · 392
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
936655 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   1 *                       1                         1                   1
937588 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_9 5 1 2 0   0     0   0   6 *                       8 5 1 2 0   0     0   0   6                   8
939288 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_9 * * * *   *     *   *   * *                       1                                             1
933714 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
935434 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2016   grade_9 6 2 2 0   0     0   0   9 1                       10 6 2 2 0   0     0   0   9 1                 10
935828 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2016   grade_9 1 0 14 0   0     0   0   14 1                       15 1 0 14 0   0     0   0   14 1                 15
935854 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2016   grade_9 0 0 8 0   0     0   0   7 1                       8 0 0 8 0   0     0   0   7 1                 8
938837 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2016   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
939063 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2016   grade_9 * * * *   *     *   *   4 1                       5                         4 1                 5
935220 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2016   grade_9 11 0 0 0   0     0   1   2 10                       12 11 0 0 0   0     0   1   2 10                 12
933697 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   grade_9 3 83 119 0   2     0   6   113 100                       213 3 83 119 0   2     0   6   113 100                 213
941163 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No 3 09 12 2016   grade_9 180 4 2 0   11     0   4   101 100                       201 180 4 2 0   11     0   4   101 100                 201
941856 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 132 53 28 3   2     0   9   127 100                       227 132 53 28 3   2     0   9   127 100                 227
939772 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2016   grade_9 186 2 6 1   11     0   5   110 101                       211 186 2 6 1   11     0   5   110 101                 211
941480 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No 3 09 12 2016   grade_9 169 3 4 0   7     0   3   85 101                       186 169 3 4 0   7     0   3   85 101                 186
941954 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Vocational Education School No 3 09 12 2016   grade_9 118 0 3 1   0     0   4   25 101                       126 118 0 3 1   0     0   4   25 101                 126
941116 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No 3 09 12 2016   grade_9 179 4 4 1   1     0   8   95 102                       197 179 4 4 1   1     0   8   95 102                 197
934450 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2016   grade_9 108 7 73 0   2     0   4   91 103                       194 108 7 73 0   2     0   4   91 103                 194
937137 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2016   grade_9 172 3 12 0   3     0   2   89 103                       192 172 3 12 0   3     0   2   89 103                 192
937553 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2016   grade_9 166 24 14 0   9     0   7   117 103                       220 166 24 14 0   9     0   7   117 103                 220
941473 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No 3 09 12 2016   grade_9 174 2 3 0   2     0   5   83 103                       186 174 2 3 0   2     0   5   83 103                 186
934758 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No 3 09 12 2016   grade_9 175 11 9 1   7     1   1   101 104                       205 175 11 9 1   7     1   1   101 104                 205
936775 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No 3 09 12 2016   grade_9 164 8 9 0   4     0   9   90 104                       194 164 8 9 0   4     0   9   90 104                 194
933670 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2016   grade_9 17 89 147 0   33     0   2   182 106                       288 17 89 147 0   33     0   2   182 106                 288
932862 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2016   grade_9 152 18 14 1   19     2   16   115 107                       222 152 18 14 1   19     2   16   115 107                 222
934964 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No 3 09 12 2016   grade_9 13 5 12 0   2     0   2   23 11                       34 13 5 12 0   2     0   2   23 11                 34
938765 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No 4 06 10 2016   grade_9 9 14 30 0   0     0   1   43 11                       54 9 14 30 0   0     0   1   43 11                 54
940528 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes 3 09 12 2016   grade_9 11 0 7 0   2     0   2   11 11                       22 11 0 7 0   2     0   2   11 11                 22
938202 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2016   grade_9 105 20 111 1   4     0   8   139 110                       249 105 20 111 1   4     0   8   139 110                 249
939587 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No 3 09 12 2016   grade_9 140 12 16 1   27     0   10   96 110                       206 140 12 16 1   27     0   10   96 110                 206
941958 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Vocational Education School No 3 09 12 2016   grade_9 136 2 4 1   1     0   4   38 110                       148 136 2 4 1   1     0   4   38 110                 148
940827 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2016   grade_9 137 13 35 0   21     0   16   111 111                       222 137 13 35 0   21     0   16   111 111                 222
934680 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2016   grade_9 176 8 16 0   14     0   4   106 112                       218 176 8 16 0   14     0   4   106 112                 218
935272 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2016   grade_9 214 3 12 2   5     1   5   130 112                       242 214 3 12 2   5     1   5   130 112                 242
938294 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2016   grade_9 199 9 0 0   3     0   2   101 112                       213 199 9 0 0   3     0   2   101 112                 213
941027 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2016   grade_9 154 18 21 2   9     0   16   107 113                       220 154 18 21 2   9     0   16   107 113                 220
936072 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No 3 09 12 2016   grade_9 210 5 9 0   20     0   3   131 116                       247 210 5 9 0   20     0   3   131 116                 247
937776 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2016   grade_9 161 25 25 0   5     0   17   117 116                       233 161 25 25 0   5     0   17   117 116                 233
939082 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No 3 09 12 2016   grade_9 222 6 4 0   9     0   1   126 116                       242 222 6 4 0   9     0   1   126 116                 242
934029 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No 3 08 12 2016   grade_9 9 18 9 1   0     0   3   28 12                       40 9 18 9 1   0     0   3   28 12                 40
938821 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No 3 09 12 2016   grade_9 2 6 22 0   0     0   0   18 12                       30 2 6 22 0   0     0   0   18 12                 30
935297 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No 3 09 12 2016   grade_9 186 5 6 0   30     1   5   113 120                       233 186 5 6 0   30     1   5   113 120                 233
936222 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2016   grade_9 210 7 22 1   0     0   4   124 120                       244 210 7 22 1   0     0   4   124 120                 244
937706 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2016   grade_9 237 4 1 0   1     0   1   124 120                       244 237 4 1 0   1     0   1   124 120                 244
939165 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No 3 09 12 2016   grade_9 194 8 5 0   7     1   5   99 121                       220 194 8 5 0   7     1   5   99 121                 220
935007 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_9 183 10 5 6   9     0   10   101 122                       223 183 10 5 6   9     0   10   101 122                 223
941938 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Vocational Education School No 3 09 12 2016   grade_9 278 2 21 0   0     0   4   182 123                       305 278 2 21 0   0     0   4   182 123                 305
937321 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No 3 09 12 2016   grade_9 174 6 28 0   12     0   9   104 125                       229 174 6 28 0   12     0   9   104 125                 229
939677 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No 3 09 12 2016   grade_9 231 8 6 0   14     0   1   134 126                       260 231 8 6 0   14     0   1   134 126                 260
941848 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Vocational Education School No 3 09 12 2016   grade_9 233 0 44 0   1     0   6   158 126                       284 233 0 44 0   1     0   6   158 126                 284
935654 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2016   grade_9 234 0 6 0   13     0   6   132 127                       259 234 0 6 0   13     0   6   132 127                 259
936802 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   grade_9 183 6 60 5   9     0   2   138 127                       265 183 6 60 5   9     0   2   138 127                 265
934695 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No 3 09 12 2016   grade_9 242 1 5 0   8     0   3   130 129                       259 242 1 5 0   8     0   3   130 129                 259
940740 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_9 15 4 1 0   8     0   2   17 13                       30 15 4 1 0   8     0   2   17 13                 30
934288 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No 3 09 12 2016   grade_9 169 20 10 1   30     0   11   111 130                       241 169 20 10 1   30     0   11   111 130                 241
934563 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2016   grade_9 225 9 15 0   7     0   3   129 130                       259 225 9 15 0   7     0   3   129 130                 259
936711 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No 3 09 12 2016   grade_9 217 17 9 0   5     1   3   122 130                       252 217 17 9 0   5     1   3   122 130                 252
941255 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No 3 09 12 2016   grade_9 289 6 3 0   6     0   2   176 130                       306 289 6 3 0   6     0   2   176 130                 306
941860 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 276 14 29 2   1     0   12   204 130                       334 276 14 29 2   1     0   12   204 130                 334
937397 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No 3 09 12 2016   grade_9 235 10 12 1   18     0   6   151 131                       282 235 10 12 1   18     0   6   151 131                 282
941089 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2016   grade_9 216 5 9 1   6     0   5   111 131                       242 216 5 9 1   6     0   5   111 131                 242
936866 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2016   grade_9 158 51 12 0   14     1   11   115 132                       247 158 51 12 0   14     1   11   115 132                 247
941431 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No 3 09 12 2016   grade_9 216 8 11 0   9     0   11   123 132                       255 216 8 11 0   9     0   11   123 132                 255
934590 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2016   grade_9 242 4 6 0   1     0   8   128 133                       261 242 4 6 0   1     0   8   128 133                 261
940692 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2016   grade_9 184 6 12 2   8     1   7   87 133                       220 184 6 12 2   8     1   7   87 133                 220
936521 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2016   grade_9 133 8 127 0   4     0   6   144 134                       278 133 8 127 0   4     0   6   144 134                 278
937853 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2016   grade_9 246 3 7 1   1     1   10   135 134                       269 246 3 7 1   1     1   10   135 134                 269
941942 MA Norfolk   school 2511735 878   Tri County Regional Vocational Technical 251173501931 8780605 Tri County Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 261 1 13 0   4     1   11   156 135                       291 261 1 13 0   4     1   11   156 135                 291
934158 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2016   grade_9 189 8 8 1   33     0   9   112 136                       248 189 8 8 1   33     0   9   112 136                 248
941603 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No 3 09 12 2016   grade_9 267 5 6 0   0     0   2   142 138                       280 267 5 6 0   0     0   2   142 138                 280
936488 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No 3 09 12 2016   grade_9 229 10 15 1   6     0   4   126 139                       265 229 10 15 1   6     0   4   126 139                 265
938340 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No 3 09 12 2016   grade_9 179 22 13 1   65     0   7   148 139                       287 179 22 13 1   65     0   7   148 139                 287
941607 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No 3 09 12 2016   grade_9 239 4 5 0   2     1   6   118 139                       257 239 4 5 0   2     1   6   118 139                 257
933772 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2016   grade_9 11 4 12 0   2     0   1   16 14                       30 11 4 12 0   2     0   1   16 14                 30
935832 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2016   grade_9 0 2 32 0   1     0   0   21 14                       35 0 2 32 0   1     0   0   21 14                 35
941597 MA Worcester   school 2509900 755   Ralph C Mahar 250990002707 7550525 The Gateway to College   Regular School No 3 09 12 2016   grade_9 13 1 1 0   1     0   1   3 14                       17 13 1 1 0   1     0   1   3 14                 17
939444 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No 3 09 12 2016   grade_9 184 7 12 0   59     0   8   129 141                       270 184 7 12 0   59     0   8   129 141                 270
941293 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2016   grade_9 262 2 5 2   9     0   6   145 141                       286 262 2 5 2   9     0   6   145 141                 286
941926 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Vocational Education School No 3 09 12 2016   grade_9 292 6 14 1   3     0   8   183 141                       324 292 6 14 1   3     0   8   183 141                 324
935510 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No 3 09 12 2016   grade_9 271 4 4 0   3     0   4   144 142                       286 271 4 4 0   3     0   4   144 142                 286
938906 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No 3 09 12 2016   grade_9 203 69 18 0   12     0   4   163 143                       306 203 69 18 0   12     0   4   163 143                 306
940182 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No 3 09 12 2016   grade_9 96 49 136 0   14     0   17   168 144                       312 96 49 136 0   14     0   17   168 144                 312
941082 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No 3 09 12 2016   grade_9 240 4 17 0   10     0   8   135 144                       279 240 4 17 0   10     0   8   135 144                 279
935048 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2016   grade_9 94 21 141 0   19     0   21   150 146                       296 94 21 141 0   19     0   21   150 146                 296
941843 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No 3 09 12 2016   grade_9 265 6 5 2   3     0   8   142 147                       289 265 6 5 2   3     0   8   142 147                 289
937961 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2016   grade_9 120 14 10 0   164     1   6   167 148                       315 120 14 10 0   164     1   6   167 148                 315
933032 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2016   grade_9 254 3 11 1   15     1   9   145 149                       294 254 3 11 1   15     1   9   145 149                 294
940190 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No 3 09 12 2016   grade_9 57 64 153 3   18     0   12   158 149                       307 57 64 153 3   18     0   12   158 149                 307
938829 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield High School   Regular School No 3 09 12 2016   grade_9 9 11 38 0   0     0   1   44 15                       59 9 11 38 0   0     0   1   44 15                 59
939829 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No 3 09 12 2016   grade_9 229 1 12 0   41     0   11   144 150                       294 229 1 12 0   41     0   11   144 150                 294
932588 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2016   grade_9 278 6 23 0   6     0   6   168 151                       319 278 6 23 0   6     0   6   168 151                 319
941852 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Vocational Education School No 3 09 12 2016   grade_9 293 1 5 0   7     0   5   159 152                       311 293 1 5 0   7     0   5   159 152                 311
937957 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2016   grade_9 252 21 27 1   61     2   14   225 153                       378 252 21 27 1   61     2   14   225 153                 378
939636 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No 3 09 12 2016   grade_9 224 8 66 0   22     0   5   171 154                       325 224 8 66 0   22     0   5   171 154                 325
941236 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No 3 09 12 2016   grade_9 271 5 19 0   9     0   9   157 156                       313 271 5 19 0   9     0   9   157 156                 313
939209 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No 3 09 12 2016   grade_9 260 14 16 0   10     0   3   146 157                       303 260 14 16 0   10     0   3   146 157                 303
941950 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 260 6 59 2   5     0   10   181 161                       342 260 6 59 2   5     0   10   181 161                 342
932929 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2016   grade_9 211 17 9 0   52     0   11   138 162                       300 211 17 9 0   52     0   11   138 162                 300
933754 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2016   grade_9 33 96 91 2   69     1   6   136 162                       298 33 96 91 2   69     1   6   136 162                 298
932984 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2016   grade_9 234 14 30 0   8     2   7   132 163                       295 234 14 30 0   8     2   7   132 163                 295

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