Data source: Big Local News · About: Big Local

393 rows where grade = "grade_9", state = "MA" and year = 2018 sorted by male

View and edit SQL

year

  • 2018 · 393

grade

  • grade_9 · 393
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
2230212 MA Suffolk   school   35   Boston   350652               2018   grade_9 * * * *   *     *   *   * *                       1.0                                             1
2231646 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2232024 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2237230 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2229198 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham: Keough Memorial Academy   Alternative School No High 08 12 2018   grade_9 * * * *   *     *   *   1 3                       4.0                         1 3                 4
2229453 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2230269 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_9 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2230274 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston: Boston Collaborative High School   Alternative School No High 09 12 2018   grade_9 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2233662 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Medford: Curtis-Tufts   Regular School No High 09 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
2234772 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
2230484 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_9 3 3 6 0   0     0   1   10 3                       13.0 3 3 6 0   0     0   1   10 3                 13
2232154 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover: Hanover High   Regular School No High 09 12 2018   grade_9 193 3 4 0   6     0   0   100 106                       206.0 193 3 4 0   6     0   0   100 106                 206
2234235 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport: Newburyport High   Regular School No High 09 12 2018   grade_9 195 0 4 0   5     0   4   101 107                       208.0 195 0 4 0   5     0   4   101 107                 208
2232349 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston: Holliston High   Regular School No High 09 12 2018   grade_9 175 2 5 2   15     0   3   102 100                       202.0 175 2 5 2   15     0   3   102 100                 202
2234908 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke: Pembroke High School   Regular School No High 09 12 2018   grade_9 202 3 2 0   2     0   1   104 106                       210.0 202 3 2 0   2     0   1   104 106                 210
2231689 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth: Falmouth High   Regular School No High 09 12 2018   grade_9 188 9 6 3   6     0   19   105 126                       231.0 188 9 6 3   6     0   19   105 126                 231
2231526 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven: Fairhaven High   Regular School No High 09 12 2018   grade_9 178 0 12 2   4     0   5   106 95                       201.0 178 0 12 2   4     0   5   106 95                 201
2238944 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Freetown-Lakeville: Apponequet Regional High   Regular School No High 09 12 2018   grade_9 197 1 4 0   3     0   3   106 102                       208.0 197 1 4 0   3     0   3   106 102                 208
2233799 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough: Middleborough High   Regular School No High 09 12 2018   grade_9 179 7 5 1   2     0   7   107 94                       201.0 179 7 5 1   2     0   7   107 94                 201
2232009 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester: Gloucester High   Regular School No High 09 12 2018   grade_9 162 5 30 1   0     1   3   108 94                       202.0 162 5 30 1   0     1   3   108 94                 202
2233726 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose: Melrose High   Regular School No High 09 12 2018   grade_9 197 19 6 0   10     0   7   108 131                       239.0 197 19 6 0   10     0   7   108 131                 239
2234451 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton: Northampton High   Regular School No High 09 12 2018   grade_9 178 7 21 1   6     0   9   108 114                       222.0 178 7 21 1   6     0   9   108 114                 222
2239862 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Regional Vocational Technical: Nashoba Valley Technical High School   Career and Technical School No High 09 12 2018   grade_9 152 8 6 0   6     0   4   108 68                       176.0 152 8 6 0   6     0   4   108 68                 176
2238835 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_9 132 16 19 6   4     1   11   109 80                       189.0 132 16 19 6   4     1   11   109 80                 189
2239877 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Regional Vocational Technical: Pathfinder Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 152 2 7 0   0     0   5   109 57                       166.0 152 2 7 0   0     0   5   109 57                 166
2230471 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   grade_9 0 15 2 0   0     0   0   11 6                       17.0 0 15 2 0   0     0   0   11 6                 17
2238262 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter (District): Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2018   grade_9 3 0 13 0   5     0   0   11 10                       21.0 3 0 13 0   5     0   0   11 10                 21
2239026 MA Franklin   school 2505270 674   Gill-Montague 250527000768 6740505 Gill-Montague: Turners Fall High   Regular School No High 09 12 2018   grade_9 45 0 6 0   0     0   2   11 42                       53.0 45 0 6 0   0     0   2   11 42                 53
2239401 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket: Pentucket Regional Sr High   Regular School No High 09 12 2018   grade_9 189 4 4 0   7     0   3   110 97                       207.0 189 4 4 0   7     0   3   110 97                 207
2239892 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 South Shore Regional Vocational Technical: So Shore Vocational Technical High   Career and Technical School No High 09 12 2018   grade_9 153 5 5 0   3     0   2   111 57                       168.0 153 5 5 0   3     0   2   111 57                 168
2230817 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton: Canton High   Regular School No High 09 12 2018   grade_9 164 30 12 0   34     0   12   113 139                       252.0 164 30 12 0   34     0   12   113 139                 252
2237276 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood: Westwood High   Regular School No High 09 12 2018   grade_9 215 8 10 0   18     0   2   113 140                       253.0 215 8 10 0   18     0   2   113 140                 253
2236866 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland: Wayland High School   Regular School No High 09 12 2018   grade_9 158 12 9 0   38     0   16   114 119                       233.0 158 12 9 0   38     0   16   114 119                 233
2238599 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham: Amherst Regional High   Regular School No High 09 12 2018   grade_9 131 16 46 0   19     1   28   114 127                       241.0 131 16 46 0   19     1   28   114 127                 241
2234994 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Pittsfield: Taconic High   Regular School No High 09 12 2018   grade_9 143 30 33 0   1     0   18   115 110                       225.0 143 30 33 0   1     0   18   115 110                 225
2236651 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield: Wakefield Memorial High   Regular School No High 09 12 2018   grade_9 216 11 14 1   4     1   2   115 134                       249.0 216 11 14 1   4     1   2   115 134                 249
2234989 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield: Pittsfield High   Regular School No High 09 12 2018   grade_9 152 22 30 1   5     0   13   116 106                       223.0 152 22 30 1   5     0   13   116 106                 223
2231144 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers: Danvers High   Regular School No High 09 12 2018   grade_9 200 1 20 0   3     0   7   117 114                       231.0 200 1 20 0   3     0   7   117 114                 231
2238392 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_9 2 113 81 1   0     0   2   117 82                       199.0 2 113 81 1   0     0   2   117 82                 199
2230110 MA Suffolk   school 2502790 35   Boston 250279000327 350535 Boston: The English High   Regular School No High 09 12 2018   grade_9 1 76 103 0   1     0   1   118 64                       182.0 1 76 103 0   1     0   1   118 64                 182
2230665 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington: Burlington High   Regular School No High 09 12 2018   grade_9 174 12 7 1   26     0   9   118 111                       229.0 174 12 7 1   26     0   9   118 111                 229
2231177 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth: Dartmouth High   Regular School No High 09 12 2018   grade_9 232 5 8 0   1     0   17   118 145                       263.0 232 5 8 0   1     0   17   118 145                 263
2232956 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow: Longmeadow High   Regular School No High 09 12 2018   grade_9 189 9 7 1   21     0   8   118 117                       235.0 189 9 7 1   21     0   8   118 117                 235
2234730 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood: Norwood High   Regular School No High 09 12 2018   grade_9 169 21 30 0   15     0   9   119 125                       244.0 169 21 30 0   15     0   9   119 125                 244
2234608 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield: North Brookfield High   Regular School No High 07 12 2018   grade_9 22 0 1 0   0     0   1   12 12                       24.0 22 0 1 0   0     0   1   12 12                 24
2239842 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical: Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2018   grade_9 102 9 78 4   0     0   5   120 78                       198.0 102 9 78 4   0     0   5   120 78                 198
2239088 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Hampden-Wilbraham: Minnechaug Regional High   Regular School No High 09 12 2018   grade_9 220 8 12 1   10     0   10   122 139                       261.0 220 8 12 1   10     0   10   122 139                 261
2231286 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut: Dracut Senior High   Regular School No High 09 12 2018   grade_9 165 15 14 2   23     0   6   123 102                       225.0 165 15 14 2   23     0   6   123 102                 225
2231408 MA Bristol   school 2504620 88   Easton 250462000623 880505 Easton: Oliver Ames High   Regular School No High 09 12 2018   grade_9 234 20 12 1   11     0   6   124 160                       284.0 234 20 12 1   11     0   6   124 160                 284
2233147 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow: Ludlow Senior High   Regular School No High 09 12 2018   grade_9 222 4 17 0   0     0   10   124 129                       253.0 222 4 17 0   0     0   10   124 129                 253
2238863 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth: Dighton-Rehoboth Regional High School   Regular School No High 09 12 2018   grade_9 205 2 6 0   0     0   6   124 95                       219.0 205 2 6 0   0     0   6   124 95                 219
2239797 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical: Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 133 50 26 1   5     0   9   124 100                       224.0 133 50 26 1   5     0   9   124 100                 224
2235610 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate: Scituate High School   Regular School No High 09 12 2018   grade_9 234 8 3 0   3     0   3   125 126                       251.0 234 8 3 0   3     0   3   125 126                 251
2239514 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional School District: Somerset Berkley Regional High School   Regular School No High 09 12 2018   grade_9 232 3 9 1   0     0   4   125 124                       249.0 232 3 9 1   0     0   4   125 124                 249
2235246 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph: Randolph High   Regular School No High 09 12 2018   grade_9 20 111 32 1   35     1   8   126 82                       208.0 20 111 32 1   35     1   8   126 82                 208
2239907 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Regional Vocational Technical: Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 160 9 6 2   3     0   10   126 64                       190.0 160 9 6 2   3     0   10   126 64                 190
2231012 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee: Chicopee High   Regular School No High 09 12 2018   grade_9 124 13 113 0   2     0   12   127 137                       264.0 124 13 113 0   2     0   12   127 137                 264
2233462 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead: Marblehead High   Regular School No High 09 12 2018   grade_9 233 7 14 0   6     0   6   128 138                       266.0 233 7 14 0   6     0   6   128 138                 266
2237076 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield: Westfield High   Regular School No High 09 12 2018   grade_9 228 6 38 1   11     0   3   128 159                       287.0 228 6 38 1   11     0   3   128 159                 287
2239307 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba: Nashoba Regional   Regular School No High 09 12 2018   grade_9 223 3 4 0   8     0   3   128 113                       241.0 223 3 4 0   8     0   3   128 113                 241
2235497 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem: Salem High   Regular School No High 09 12 2018   grade_9 101 10 120 0   8     0   8   129 117                       247.0 101 10 120 0   8     0   8   129 117                 247
2237870 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester: Burncoat Senior High   Regular School No High 09 12 2018   grade_9 64 48 117 0   9     0   12   129 121                       250.0 64 48 117 0   9     0   12   129 121                 250
2235363 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Revere: Seacoast School   Regular School No High 09 12 2018   grade_9 8 1 12 0   0     0   2   13 10                       23.0 8 1 12 0   0     0   2   13 10                 23
2238489 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District): Global Learning Charter Public School   Regular School Yes High 05 12 2018   grade_9 9 2 19 0   0     0   2   13 19                       32.0 9 2 19 0   0     0   2   13 19                 32
2239154 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet: Masconomet Regional High School   Regular School No High 09 12 2018   grade_9 266 1 4 1   16     1   8   131 166                       297.0 266 1 4 1   16     1   8   131 166                 297
2233501 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough: Marlborough High   Regular School No High 09 12 2018   grade_9 107 8 130 0   3     0   6   132 122                       254.0 107 8 130 0   3     0   6   132 122                 254
2240033 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_9 207 16 40 2   9     2   20   133 163                       296.0 207 16 40 2   9     2   20   133 163                 296
2234542 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleborough: North Attleboro High   Regular School No High 09 12 2018   grade_9 208 8 12 0   17     0   8   134 119                       253.0 208 8 12 0   17     0   8   134 119                 253
2239782 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson: Whitman Hanson Regional   Regular School No High 09 12 2018   grade_9 259 8 7 2   2     0   6   134 150                       284.0 259 8 7 2   2     0   6   134 150                 284
2231304 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury: Duxbury High   Regular School No High 09 12 2018   grade_9 240 1 9 0   6     0   6   135 127                       262.0 240 1 9 0   6     0   6   135 127                 262
2233906 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton: Milton High   Regular School No High 09 12 2018   grade_9 174 54 13 0   16     0   11   136 131                       268.0 174 54 13 0   16     0   11   136 131                 268
2233325 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_9 7 0 17 0   0     0   1   14 11                       25.0 7 0 17 0   0     0   1   14 11                 25
2239812 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District: Essex Technical High School   Career and Technical School No High 09 12 2018   grade_9 297 4 38 3   7     0   15   140 223                       364.0 297 4 38 3   7     0   15   140 223                 364
2229355 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_9 220 14 11 0   23     0   4   141 131                       272.0 220 14 11 0   23     0   4   141 131                 272
2236703 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole: Walpole High   Regular School No High 09 12 2018   grade_9 229 15 13 0   15     0   4   141 135                       276.0 229 15 13 0   15     0   4   141 135                 276
2231737 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg: Fitchburg High   Regular School No High 09 12 2018   grade_9 83 25 150 0   11     0   35   143 161                       304.0 83 25 150 0   11     0   35   143 161                 304
2233333 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_9 42 21 167 0   20     0   6   145 111                       256.0 42 21 167 0   20     0   6   145 111                 256
2239509 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake: Silver Lake Regional High   Regular School No High 09 12 2018   grade_9 277 3 1 0   4     0   1   147 139                       286.0 277 3 1 0   4     0   1   147 139                 286
2232306 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham: Hingham High   Regular School No High 09 12 2018   grade_9 304 6 7 0   6     0   5   149 179                       328.0 304 6 7 0   6     0   5   149 179                 328
2233832 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_9 181 11 77 6   5     0   11   149 142                       291.0 181 11 77 6   5     0   11   149 142                 291
2237554 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn: Woburn High   Regular School No High 09 12 2018   grade_9 219 27 31 0   15     0   5   149 148                       297.0 219 27 31 0   15     0   5   149 148                 297
2238804 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord-Carlisle: Concord Carlisle High   Regular School No High 09 12 2018   grade_9 237 14 11 0   24     0   9   149 146                       295.0 237 14 11 0   24     0   9   149 146                 295
2237844 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_9 4 4 19 0   9     0   0   15 21                       36.0 4 4 19 0   9     0   0   15 21                 36
2238503 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District): Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2018   grade_9 19 7 2 0   6     0   5   15 24                       39.0 19 7 2 0   6     0   5   15 24                 39
2239902 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical: Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 213 2 20 0   3     0   10   150 97                       248.0 213 2 20 0   3     0   10   150 97                 248
2235667 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon: Sharon High   Regular School No High 09 12 2018   grade_9 162 12 13 0   81     1   7   152 124                       276.0 162 12 13 0   81     1   7   152 124                 276
2239109 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip: King Philip Regional High   Regular School No High 09 12 2018   grade_9 283 9 6 0   6     0   6   152 158                       310.0 283 9 6 0   6     0   6   152 158                 310
2236333 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton: Stoughton High   Regular School No High 09 12 2018   grade_9 156 79 29 1   19     0   12   153 143                       296.0 156 79 29 1   19     0   12   153 143                 296
2235208 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy: North Quincy High   Regular School No High 09 12 2018   grade_9 105 11 12 3   157     0   3   154 137                       291.0 105 11 12 3   157     0   3   154 137                 291
2232477 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton: Hopkinton High   Regular School No High 09 12 2018   grade_9 257 3 5 1   43     0   3   155 157                       312.0 257 3 5 1   43     0   3   155 157                 312
2233547 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield: Marshfield High   Regular School No High 09 12 2018   grade_9 297 1 13 1   5     0   3   155 165                       320.0 297 1 13 1   5     0   3   155 165                 320
2230115 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston: Madison Park High   Career and Technical School No High 09 12 2018   grade_9 4 77 144 0   4     0   3   156 76                       232.0 4 77 144 0   4     0   3   156 76                 232
2230142 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_9 102 74 100 1   86     1   8   157 215                       372.0 102 74 100 1   86     1   8   157 215                 372
2238903 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Dudley-Charlton Reg: Shepherd Hill Regional High   Regular School No High 09 12 2018   grade_9 248 5 36 0   5     0   13   158 149                       307.0 248 5 36 0   5     0   13   158 149                 307
2228817 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   grade_9 282 5 21 0   1     0   9   159 159                       318.0 282 5 21 0   1     0   9   159 159                 318
2238758 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham: Bridgewater-Raynham Regional   Regular School No High 09 12 2018   grade_9 309 20 0 0   7     0   16   159 193                       352.0 309 20 0 0   7     0   16   159 193                 352
2231653 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_9 20 5 7 0   0     0   0   16 16                       32.0 20 5 7 0   0     0   0   16 16                 32
2238105 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_9 1 27 11 1   0     0   1   16 25                       41.0 1 27 11 1   0     0   1   16 25                 41
2239501 MA Franklin   school 2509900 755   Ralph C Mahar 250990002707 7550525 Ralph C Mahar: The Gateway to College   Regular School No High 09 12 2018   grade_9 30 1 8 0   1     0   0   16 24                       40.0 30 1 8 0   1     0   0   16 24                 40
2239912 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational Technical: Whittier Regional Vocational   Career and Technical School No High 09 12 2018   grade_9 210 2 60 1   4     0   11   160 128                       288.0 210 2 60 1   4     0   11   160 128                 288

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