enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 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
1123285 1123285 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 *                       *                         2                    
1125195 1125195 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1125269 1125269 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1127949 1127949 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   3 *                       *                         3                    
1128685 1128685 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1129420 1129420 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 *                       *                         2                    
1131925 1131925 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1122639 1122639 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1123330 1123330 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1123670 1123670 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_9 3 3 0 0   0     0   0   5 1                       6 3 3 0 0   0     0   0   5 1                 6
1128679 1128679 MA Essex   school 2510380 258   Salem 251038002864 2580510 New Liberty Innovation School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1129707 1129707 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 08 12 2017   grade_9 * * * *   *     *   *   2 1                       *                         2 1                  
1133107 1133107 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2017   grade_9 122 1 4 0   1     0   5   33 100                       133 122 1 4 0   1     0   5   33 100                 133
1126790 1126790 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2017   grade_9 183 2 7 0   12     0   3   106 101                       207 183 2 7 0   12     0   3   106 101                 207
1129733 1129733 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2017   grade_9 218 3 10 0   10     1   1   142 101                       243 218 3 10 0   10     1   1   142 101                 243
1125690 1125690 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2017   grade_9 176 4 14 0   2     0   1   95 102                       197 176 4 14 0   2     0   1   95 102                 197
1127818 1127818 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2017   grade_9 198 1 3 0   5     0   1   106 102                       208 198 1 3 0   5     0   1   106 102                 208
1127413 1127413 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2017   grade_9 161 1 9 0   5     0   4   77 103                       180 161 1 9 0   5     0   4   77 103                 180
1122198 1122198 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2017   grade_9 142 5 27 1   24     0   3   98 104                       202 142 5 27 1   24     0   3   98 104                 202
1124469 1124469 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2017   grade_9 174 20 10 0   11     0   5   116 104                       220 174 20 10 0   11     0   5   116 104                 220
1125223 1125223 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2017   grade_9 180 2 10 0   24     0   5   117 104                       221 180 2 10 0   24     0   5   117 104                 221
1130567 1130567 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2017   grade_9 186 6 7 0   11     0   1   107 104                       211 186 6 7 0   11     0   1   107 104                 211
1132531 1132531 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No High 09 12 2017   grade_9 185 3 12 0   2     0   6   103 105                       208 185 3 12 0   2     0   6   103 105                 208
1125534 1125534 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2017   grade_9 199 1 4 0   15     0   6   119 106                       225 199 1 4 0   15     0   6   119 106                 225
1128167 1128167 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2017   grade_9 159 25 19 0   5     0   8   110 106                       216 159 25 19 0   5     0   8   110 106                 216
1130051 1130051 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2017   grade_9 150 12 14 0   26     0   12   108 106                       214 150 12 14 0   26     0   12   108 106                 214
1124396 1124396 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2017   grade_9 143 27 32 0   4     0   2   101 107                       208 143 27 32 0   4     0   2   101 107                 208
1125180 1125180 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2017   grade_9 183 5 27 0   4     1   6   119 107                       226 183 5 27 0   4     1   6   119 107                 226
1124197 1124197 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2017   grade_9 121 7 105 0   2     0   1   128 108                       236 121 7 105 0   2     0   1   128 108                 236
1128086 1128086 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2017   grade_9 199 2 0 0   4     1   1   99 108                       207 199 2 0 0   4     1   1   99 108                 207
1132004 1132004 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_9 138 18 22 1   4     0   11   86 108                       194 138 18 22 1   4     0   11   86 108                 194
1128791 1128791 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2017   grade_9 206 10 0 0   4     0   6   117 109                       226 206 10 0 0   4     0   6   117 109                 226
1131430 1131430 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2017   grade_9 8 0 12 0   5     0   1   15 11                       26 8 0 12 0   5     0   1   15 11                 26
1127629 1127629 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2017   grade_9 160 6 41 1   7     0   12   117 110                       227 160 6 41 1   7     0   12   117 110                 227
1124953 1124953 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2017   grade_9 178 14 9 0   6     0   5   101 111                       212 178 14 9 0   6     0   5   101 111                 212
1124563 1124563 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2017   grade_9 191 6 10 1   15     0   3   114 112                       226 191 6 10 1   15     0   3   114 112                 226
1131559 1131559 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_9 1 136 83 0   1     0   3   112 112                       224 1 136 83 0   1     0   3   112 112                 224
1123850 1123850 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2017   grade_9 168 10 18 1   37     0   7   128 113                       241 168 10 18 1   37     0   7   128 113                 241
1126512 1126512 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_9 39 11 194 0   14     0   6   151 113                       264 39 11 194 0   14     0   6   151 113                 264
1132972 1132972 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_9 246 3 39 2   2     0   8   187 113                       300 246 3 39 2   2     0   8   187 113                 300
1122344 1122344 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   grade_9 151 17 21 0   26     2   9   111 115                       226 151 17 21 0   26     2   9   111 115                 226
1127908 1127908 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No High 09 12 2017   grade_9 165 47 26 0   9     0   4   136 115                       251 165 47 26 0   9     0   4   136 115                 251
1133205 1133205 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_9 157 13 23 1   4     1   11   95 115                       210 157 13 23 1   4     1   11   95 115                 210
1128846 1128846 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2017   grade_9 145 19 9 0   66     0   11   133 117                       250 145 19 9 0   66     0   11   133 117                 250
1132482 1132482 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2017   grade_9 205 3 6 0   3     0   7   107 117                       224 205 3 6 0   3     0   7   107 117                 224
1125998 1125998 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2017   grade_9 136 27 100 0   5     2   10   162 118                       280 136 27 100 0   5     2   10   162 118                 280
1126324 1126324 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2017   grade_9 203 6 19 0   1     0   8   119 118                       237 203 6 19 0   1     0   8   119 118                 237
1128674 1128674 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2017   grade_9 109 19 103 0   3     0   7   123 118                       241 109 19 103 0   3     0   7   123 118                 241
1131608 1131608 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   grade_9 182 4 15 2   6     0   8   99 118                       217 182 4 15 2   6     0   8   99 118                 217
1132772 1132772 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No High 09 12 2017   grade_9 175 2 9 0   2     0   6   76 118                       194 175 2 9 0   2     0   6   76 118                 194
1124002 1124002 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2017   grade_9 166 28 9 0   23     0   9   115 119                       235 166 28 9 0   23     0   9   115 119                 235
1124328 1124328 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2017   grade_9 208 2 8 0   9     0   3   111 119                       230 208 2 8 0   9     0   3   111 119                 230
1131768 1131768 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2017   grade_9 140 15 36 1   20     0   22   115 119                       234 140 15 36 1   20     0   22   115 119                 234
1132081 1132081 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   grade_9 185 13 1 1   8     0   11   100 119                       219 185 13 1 1   8     0   11   100 119                 219
1131666 1131666 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2017   grade_9 9 1 1 0   2     0   1   2 12                       14 9 1 1 0   2     0   1   2 12                 14
1131045 1131045 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2017   grade_9 84 48 92 0   11     0   7   122 120                       242 84 48 92 0   11     0   7   122 120                 242
1127089 1127089 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2017   grade_9 142 49 17 0   20     0   12   119 121                       240 142 49 17 0   20     0   12   119 121                 240
1124360 1124360 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2017   grade_9 241 2 5 0   1     0   20   147 122                       269 241 2 5 0   1     0   20   147 122                 269
1128258 1128258 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2017   grade_9 236 5 8 1   2     0   10   139 123                       262 236 5 8 1   2     0   10   139 123                 262
1124909 1124909 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2017   grade_9 92 18 132 0   16     0   22   156 124                       280 92 18 132 0   16     0   22   156 124                 280
1133082 1133082 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_9 273 2 22 0   4     0   3   178 126                       304 273 2 22 0   4     0   3   178 126                 304
1124487 1124487 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No High 09 12 2017   grade_9 249 1 4 0   1     0   4   132 127                       259 249 1 4 0   1     0   4   132 127                 259
1124862 1124862 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   grade_9 195 11 11 2   9     0   12   113 127                       240 195 11 11 2   9     0   12   113 127                 240
1126680 1126680 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2017   grade_9 108 8 116 1   12     0   3   121 127                       248 108 8 116 1   12     0   3   121 127                 248
1130163 1130163 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2017   grade_9 176 5 13 0   66     0   6   137 129                       266 176 5 13 0   66     0   6   137 129                 266
1126641 1126641 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2017   grade_9 217 8 15 0   6     0   9   125 130                       255 217 8 15 0   6     0   9   125 130                 255
1132689 1132689 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2017   grade_9 251 5 11 0   0     0   11   145 133                       278 251 5 11 0   0     0   11   145 133                 278
1123300 1123300 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_9 33 18 307 1   3     0   3   231 134                       365 33 18 307 1   3     0   3   231 134                 365
1130448 1130448 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2017   grade_9 195 10 4 0   23     0   5   103 134                       237 195 10 4 0   23     0   5   103 134                 237
1124591 1124591 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No High 09 12 2017   grade_9 227 13 14 1   6     0   6   132 135                       267 227 13 14 1   6     0   6   132 135                 267
1126140 1126140 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2017   grade_9 204 3 9 0   30     0   8   118 136                       254 204 3 9 0   30     0   8   118 136                 254
1133087 1133087 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_9 250 3 12 2   2     1   14   148 136                       284 250 3 12 2   2     1   14   148 136                 284
1133067 1133067 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2017   grade_9 312 5 17 0   3     0   3   203 137                       340 312 5 17 0   3     0   3   203 137                 340
1125660 1125660 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No High 09 12 2017   grade_9 247 0 3 1   20     0   3   136 138                       274 247 0 3 1   20     0   3   136 138                 274
1132967 1132967 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2017   grade_9 244 7 7 0   7     2   4   133 138                       271 244 7 7 0   7     2   4   133 138                 271
1132323 1132323 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No High 09 12 2017   grade_9 265 0 6 1   7     0   6   146 139                       285 265 0 6 1   7     0   6   146 139                 285
1128387 1128387 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_9 85 6 12 0   167     0   2   132 140                       272 85 6 12 0   167     0   2   132 140                 272
1129889 1129889 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2017   grade_9 231 11 17 0   14     0   5   138 140                       278 231 11 17 0   14     0   5   138 140                 278
1132257 1132257 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2017   grade_9 238 7 14 0   14     0   11   144 140                       284 238 7 14 0   14     0   11   144 140                 284
1129516 1129516 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2017   grade_9 173 71 20 0   20     1   14   156 143                       299 173 71 20 0   20     1   14   156 143                 299
1129837 1129837 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2017   grade_9 234 11 10 0   9     0   8   127 145                       272 234 11 10 0   9     0   8   127 145                 272
1129410 1129410 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2017   grade_9 45 63 297 0   9     1   4   273 146                       419 45 63 297 0   9     1   4   273 146                 419
1127720 1127720 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2017   grade_9 233 7 15 1   21     1   6   137 147                       284 233 7 15 1   21     1   6   137 147                 284
1132684 1132684 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2017   grade_9 300 10 1 0   4     1   3   172 147                       319 300 10 1 0   4     1   3   172 147                 319
1122011 1122011 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_9 272 3 14 0   6     0   4   151 148                       299 272 3 14 0   6     0   4   151 148                 299
1126909 1126909 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2017   grade_9 195 18 14 0   18     0   10   107 148                       255 195 18 14 0   18     0   10   107 148                 255
1127015 1127015 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2017   grade_9 195 5 60 6   5     0   6   129 148                       277 195 5 60 6   5     0   6   129 148                 277
1122491 1122491 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2017   grade_9 235 5 53 0   9     0   8   161 149                       310 235 5 53 0   9     0   8   161 149                 310
1125490 1125490 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No High 09 12 2017   grade_9 284 0 12 0   9     0   10   166 149                       315 284 0 12 0   9     0   10   166 149                 315
1133052 1133052 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2017   grade_9 238 8 74 0   3     1   6   181 149                       330 238 8 74 0   3     1   6   181 149                 330
1125373 1125373 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_9 28 0 2 0   0     0   2   17 15                       32 28 0 2 0   0     0   2   17 15                 32
1126612 1126612 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2017   grade_9 278 8 11 0   14     0   8   169 150                       319 278 8 11 0   14     0   8   169 150                 319
1132072 1132072 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2017   grade_9 252 7 22 2   4     0   6   143 150                       293 252 7 22 2   4     0   6   143 150                 293
1128045 1128045 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No High 09 12 2017   grade_9 258 11 57 0   7     0   6   186 153                       339 258 11 57 0   7     0   6   186 153                 339
1132987 1132987 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 302 9 19 2   1     0   12   192 153                       345 302 9 19 2   1     0   12   192 153                 345
1126836 1126836 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No High 09 12 2017   grade_9 160 56 28 1   29     0   9   129 154                       283 160 56 28 1   29     0   9   129 154                 283
1129012 1129012 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No High 09 12 2017   grade_9 105 49 164 0   34     0   3   201 154                       355 105 49 164 0   34     0   3   201 154                 355
1133097 1133097 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2017   grade_9 248 5 57 2   2     0   4   163 155                       318 248 5 57 2   2     0   4   163 155                 318
1122179 1122179 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_9 252 15 20 0   35     1   9   175 157                       332 252 15 20 0   35     1   9   175 157                 332
1130400 1130400 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No High 09 12 2017   grade_9 231 10 53 0   18     0   9   162 159                       321 231 10 53 0   18     0   9   162 159                 321

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