Data source: Big Local News · About: Big Local

386 rows where grade = "grade_9", state = "MA" and year = 2015 sorted by male

View and edit SQL

year

  • 2015 · 386

grade

  • grade_9 · 386
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
737827 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   * *                       2                                             2
736239 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 3 07 12 2015   grade_9 * * * *   *     *   *   1 2                       3                         1 2                 3
742025 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   1 3                       4                         1 3                 4
737142 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_9 7 3 5 0   0     0   0   10 5                       15 7 3 5 0   0     0   0   10 5                 15
737904 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No 3 09 12 2015   grade_9 190 7 6 0   8     0   1   100 112                       212 190 7 6 0   8     0   1   100 112                 212
738832 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No 3 08 12 2015   grade_9 184 4 12 1   3     0   3   100 107                       207 184 4 12 1   3     0   3   100 107                 207
745043 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 128 4 18 0   1     0   11   100 62                       162 128 4 18 0   1     0   11   100 62                 162
738979 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2015   grade_9 10 3 133 0   1     0   0   101 46                       147 10 3 133 0   1     0   0   101 46                 147
738535 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No 3 09 12 2015   grade_9 185 1 2 0   2     0   1   102 89                       191 185 1 2 0   2     0   1   102 89                 191
745089 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Vocational Education School No 3 09 12 2015   grade_9 175 0 10 1   1     0   8   102 93                       195 175 0 10 1   1     0   8   102 93                 195
739767 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2015   grade_9 206 1 2 0   9     1   7   103 123                       226 206 1 2 0   9     1   7   103 123                 226
740651 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2015   grade_9 206 1 7 0   9     2   1   103 123                       226 206 1 7 0   9     2   1   103 123                 226
745101 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 153 1 12 1   2     0   7   103 73                       176 153 1 12 1   2     0   7   103 73                 176
738233 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No 3 09 12 2015   grade_9 171 14 2 0   3     1   0   104 87                       191 171 14 2 0   3     1   0   104 87                 191
744657 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No 3 09 12 2015   grade_9 196 5 1 1   7     0   2   104 108                       212 196 5 1 1   7     0   2   104 108                 212
745077 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Vocational Education School No 3 09 12 2015   grade_9 117 11 14 0   4     0   2   104 44                       148 117 11 14 0   4     0   2   104 44                 148
740485 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No 3 09 12 2015   grade_9 180 6 29 0   13     0   6   105 129                       234 180 6 29 0   13     0   6   105 129                 234
736827 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No 3 09 12 2015   grade_9 4 75 106 1   4     0   2   106 86                       192 4 75 106 1   4     0   2   106 86                 192
739828 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway High   Regular School No 3 09 12 2015   grade_9 187 1 7 2   4     0   2   106 97                       203 187 1 7 2   4     0   2   106 97                 203
744337 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No 3 09 12 2015   grade_9 196 1 2 0   9     0   1   106 103                       209 196 1 2 0   9     0   1   106 103                 209
745073 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Vocational Education School No 3 09 12 2015   grade_9 77 14 85 0   0     0   3   106 73                       179 77 14 85 0   0     0   3   106 73                 179
744262 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2015   grade_9 189 8 8 1   7     1   3   107 110                       217 189 8 8 1   7     1   3   107 110                 217
744757 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2015   grade_9 195 3 10 0   2     0   7   107 110                       217 195 3 10 0   2     0   7   107 110                 217
742967 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2015   grade_9 202 5 5 0   14     1   5   108 124                       232 202 5 5 0   14     1   5   108 124                 232
739644 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No 3 09 12 2015   grade_9 216 17 15 0   1     0   2   111 140                       251 216 17 15 0   1     0   2   111 140                 251
739866 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No 3 09 12 2015   grade_9 183 23 13 0   6     0   8   111 122                       233 183 23 13 0   6     0   8   111 122                 233
745115 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 162 2 4 0   0     0   2   111 59                       170 162 2 4 0   0     0   2   111 59                 170
737590 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2015   grade_9 139 6 83 0   11     1   4   112 132                       244 139 6 83 0   11     1   4   112 132                 244
744201 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_9 157 15 20 1   8     0   10   113 98                       211 157 15 20 1   8     0   10   113 98                 211
738153 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_9 186 8 10 1   6     1   18   114 116                       230 186 8 10 1   6     1   18   114 116                 230
742872 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No 3 09 12 2015   grade_9 213 8 6 0   12     0   8   114 133                       247 213 8 6 0   12     0   8   114 133                 247
745127 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 168 3 6 1   7     0   7   114 78                       192 168 3 6 1   7     0   7   114 78                 192
742541 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No 3 09 12 2015   grade_9 158 10 6 0   34     1   9   115 103                       218 158 10 6 0   34     1   9   115 103                 218
737298 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2015   grade_9 173 11 10 2   33     1   4   117 117                       234 173 11 10 2   33     1   4   117 117                 234
738421 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2015   grade_9 205 2 22 0   3     5   4   118 123                       241 205 2 22 0   3     5   4   118 123                 241
738992 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2015   grade_9 13 2 137 0   8     0   1   118 43                       161 13 2 137 0   8     0   1   118 43                 161
740724 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2015   grade_9 185 26 18 0   8     0   5   119 123                       242 185 26 18 0   8     0   5   119 123                 242
737704 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2015   grade_9 209 7 10 0   3     1   4   120 114                       234 209 7 10 0   3     1   4   120 114                 234
740948 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2015   grade_9 146 32 24 0   4     0   15   120 101                       221 146 32 24 0   4     0   15   120 101                 221
745035 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 158 41 22 2   1     0   13   120 117                       237 158 41 22 2   1     0   13   120 117                 237
744224 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No 3 09 12 2015   grade_9 198 2 11 0   1     0   6   121 97                       218 198 2 11 0   1     0   6   121 97                 218
739226 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No 3 09 12 2015   grade_9 198 10 8 0   20     0   2   122 116                       238 198 10 8 0   20     0   2   122 116                 238
739375 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2015   grade_9 211 3 24 1   1     2   4   123 123                       246 211 3 24 1   1     2   4   123 123                 246
737731 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_9 228 5 2 0   11     0   4   127 123                       250 228 5 2 0   11     0   4   127 123                 250
742636 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No 3 09 12 2015   grade_9 184 5 15 0   51     0   7   128 134                       262 184 5 15 0   51     0   7   128 134                 262
740019 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2015   grade_9 158 65 8 0   17     3   10   129 132                       261 158 65 8 0   17     3   10   129 132                 261
744607 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No 3 09 12 2015   grade_9 240 5 14 0   7     0   8   129 145                       274 240 5 14 0   7     0   8   129 145                 274
737428 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No 3 09 12 2015   grade_9 180 25 10 0   24     1   7   130 117                       247 180 25 10 0   24     1   7   130 117                 247
738805 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2015   grade_9 233 3 2 1   25     0   2   132 134                       266 233 3 2 1   25     0   2   132 134                 266
742357 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No 3 09 12 2015   grade_9 242 8 6 1   7     1   5   132 138                       270 242 8 6 1   7     1   5   132 138                 270
741382 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2015   grade_9 105 20 108 1   8     0   12   133 121                       254 105 20 108 1   8     0   12   133 121                 254
742273 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No 3 09 12 2015   grade_9 229 3 6 0   2     1   0   134 107                       241 229 3 6 0   2     1   0   134 107                 241
739956 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_9 185 8 80 5   11     1   6   136 160                       296 185 8 80 5   11     1   6   136 160                 296
741535 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No 3 09 12 2015   grade_9 166 19 7 0   57     0   7   136 120                       256 166 19 7 0   57     0   7   136 120                 256
741207 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2015   grade_9 249 5 2 0   11     0   3   137 133                       270 249 5 2 0   11     0   3   137 133                 270
742401 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No 3 09 12 2015   grade_9 250 13 16 1   7     0   2   138 151                       289 250 13 16 1   7     0   2   138 151                 289
745022 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No 3 09 12 2015   grade_9 282 2 5 0   2     0   5   138 158                       296 282 2 5 0   2     0   5   138 158                 296
743993 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   grade_9 150 15 32 0   24     0   23   139 105                       244 150 15 32 0   24     0   23   139 105                 244
740567 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No 3 09 12 2015   grade_9 270 7 16 2   18     0   4   140 177                       317 270 7 16 2   18     0   4   140 177                 317
742095 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No 3 09 12 2015   grade_9 188 55 14 0   20     0   1   141 137                       278 188 55 14 0   20     0   1   141 137                 278
745031 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Vocational Education School No 3 09 12 2015   grade_9 300 0 7 0   1     0   2   142 168                       310 300 0 7 0   1     0   2   142 168                 310
736856 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_9 90 97 68 1   73     1   6   144 192                       336 90 97 68 1   73     1   6   144 192                 336
744468 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2015   grade_9 274 1 10 0   11     0   2   145 153                       298 274 1 10 0   11     0   2   145 153                 298
745048 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex Technical High School   Vocational Education School No 3 09 12 2015   grade_9 300 7 40 0   3     1   8   145 214                       359 300 7 40 0   3     1   8   145 214                 359
743373 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No 3 09 12 2015   grade_9 91 48 111 0   14     0   9   146 127                       273 91 48 111 0   14     0   9   146 127                 273
742029 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2015   grade_9 38 81 194 0   6     0   18   147 190                       337 38 81 194 0   6     0   18   147 190                 337
745123 MA Norfolk   school 2511735 878   Tri County Regional Vocational Technical 251173501931 8780605 Tri County Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 227 0 13 0   1     0   9   147 103                       250 227 0 13 0   1     0   9   147 103                 250
737841 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No 3 09 12 2015   grade_9 290 0 3 0   0     0   2   148 147                       295 290 0 3 0   0     0   2   148 147                 295
737927 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No 3 09 12 2015   grade_9 265 13 14 1   11     0   11   148 167                       315 265 13 14 1   11     0   11   148 167                 315
739620 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_9 269 14 13 1   10     0   7   148 166                       314 269 14 13 1   10     0   7   148 166                 314
739677 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2015   grade_9 161 12 106 0   16     0   2   148 149                       297 161 12 106 0   16     0   2   148 149                 297
741024 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2015   grade_9 252 7 9 1   3     0   7   148 131                       279 252 7 9 1   3     0   7   148 131                 279
744410 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No 3 09 12 2015   grade_9 251 10 21 1   4     2   5   148 146                       294 251 10 21 1   4     2   5   148 146                 294
739536 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_9 30 28 167 1   9     0   6   149 92                       241 30 28 167 1   9     0   6   149 92                 241
740878 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2015   grade_9 267 2 1 0   3     2   2   149 128                       277 267 2 1 0   3     2   2   149 128                 277
740625 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2015   grade_9 24 2 2 0   0     0   1   15 14                       29 24 2 2 0   0     0   1   15 14                 29
741993 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No 2 06 09 2015   grade_9 8 18 34 0   0     0   0   15 45                       60 8 18 34 0   0     0   0   15 45                 60
738194 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2015   grade_9 101 19 146 0   20     1   11   150 148                       298 101 19 146 0   20     1   11   150 148                 298
741132 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2015   grade_9 102 7 14 1   162     0   2   151 137                       288 102 7 14 1   162     0   2   151 137                 288
744255 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No 3 09 12 2015   grade_9 285 3 18 2   1     1   3   152 161                       313 285 3 18 2   1     1   3   152 161                 313
735852 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2015   grade_9 249 16 15 0   20     0   6   153 153                       306 249 16 15 0   20     0   6   153 153                 306
736890 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_9 30 112 98 0   72     0   11   154 169                       323 30 112 98 0   72     0   11   154 169                 323
736794 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2015   grade_9 6 114 101 1   7     0   2   155 76                       231 6 114 101 1   7     0   2   155 76                 231
744178 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No 3 09 12 2015   grade_9 267 11 19 0   30     0   11   155 183                       338 267 11 19 0   30     0   11   155 183                 338
744620 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_9 293 5 12 0   37     1   9   158 199                       357 293 5 12 0   37     1   9   158 199                 357
744429 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No 3 09 12 2015   grade_9 310 5 4 0   5     0   4   159 169                       328 310 5 4 0   5     0   4   159 169                 328
738564 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_9 28 1 1 0   0     0   2   16 16                       32 28 1 1 0   0     0   2   16 16                 32
745027 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Vocational Education School No 3 09 12 2015   grade_9 232 2 34 4   1     0   7   160 120                       280 232 2 34 4   1     0   7   160 120                 280
744129 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2015   grade_9 296 15 19 0   7     0   15   161 191                       352 296 15 19 0   7     0   15   161 191                 352
736163 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2015   grade_9 292 6 11 0   14     2   5   163 167                       330 292 6 11 0   14     2   5   163 167                 330
739806 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2015   grade_9 197 63 39 0   35     0   9   163 180                       343 197 63 39 0   35     0   9   163 180                 343
744777 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No 3 09 12 2015   grade_9 313 4 2 0   5     2   3   164 165                       329 313 4 2 0   5     2   3   164 165                 329
741020 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No 3 09 12 2015   grade_9 296 8 20 2   2     0   13   165 176                       341 296 8 20 2   2     0   13   165 176                 341
743389 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2015   grade_9 144 45 145 0   24     0   12   165 205                       370 144 45 145 0   24     0   12   165 205                 370
736803 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_9 13 115 110 1   33     0   5   168 109                       277 13 115 110 1   33     0   5   168 109                 277
738664 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No 3 09 12 2015   grade_9 304 4 8 0   12     0   9   169 168                       337 304 4 8 0   12     0   9   169 168                 337
737550 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_9 14 0 13 0   0     0   0   17 10                       27 14 0 13 0   0     0   0   17 10                 27
738501 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_9 33 0 1 0   1     0   2   17 20                       37 33 0 1 0   1     0   2   17 20                 37
736115 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2015   grade_9 297 8 30 0   5     0   11   170 181                       351 297 8 30 0   5     0   11   170 181                 351
735710 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_9 281 6 15 0   7     1   7   172 145                       317 281 6 15 0   7     1   7   172 145                 317

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