enrollments

Data source: Big Local News · About: Big Local

396 rows where grade = "grade_9", state = "MA" and year = 2019 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 396 ✖

grade ✖

  • grade_9 · 396 ✖
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
2046144 2046144 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   * 1                       1.0                           1                 1
2041676 2041676 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_9 * * * *   *     *   *   1 4                       5.0                         1 4                 5
2043952 2043952 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2044418 2044418 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_9 8 1 6 0   0     0   2   10 7                       17.0 8 1 6 0   0     0   2   10 7                 17
2042866 2042866 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2019   grade_9 181 3 8 0   21     0   5   100 118                       218.0 181 3 8 0   21     0   5   100 118                 218
2047067 2047067 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2019   grade_9 175 3 14 0   9     0   7   100 108                       208.0 175 3 14 0   9     0   7   100 108                 208
2049162 2049162 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 107 12 21 3   1     1   7   101 51                       152.0 107 12 21 3   1     1   7   101 51                 152
2040017 2040017 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_9 156 7 24 1   28     0   8   103 121                       224.0 156 7 24 1   28     0   8   103 121                 224
2041446 2041446 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   grade_9 140 19 15 2   30     0   11   103 114                       217.0 140 19 15 2   30     0   11   103 114                 217
2045077 2045077 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   grade_9 153 20 21 0   2     0   15   103 108                       211.0 153 20 21 0   2     0   15   103 108                 211
2046667 2046667 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2019   grade_9 129 9 8 0   42     1   10   104 95                       199.0 129 9 8 0   42     1   10   104 95                 199
2047980 2047980 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2019   grade_9 198 6 16 1   2     0   0   104 119                       223.0 198 6 16 1   2     0   0   104 119                 223
2042690 2042690 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2019   grade_9 186 1 2 0   5     0   0   105 89                       194.0 186 1 2 0   5     0   0   105 89                 194
2048786 2048786 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2019   grade_9 186 4 4 0   2     0   10   105 101                       206.0 186 4 4 0   2     0   10   105 101                 206
2044623 2044623 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2019   grade_9 166 3 20 1   7     0   14   106 105                       211.0 166 3 20 1   7     0   14   106 105                 211
2048382 2048382 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2019   grade_9 185 9 7 0   3     1   8   106 106                       213.0 185 9 7 0   3     1   8   106 106                 213
2048817 2048817 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2019   grade_9 175 0 9 0   5     0   4   106 87                       193.0 175 0 9 0   5     0   4   106 87                 193
2042053 2042053 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2019   grade_9 174 7 17 0   15     0   1   107 107                       214.0 174 7 17 0   15     0   1   107 107                 214
2043908 2043908 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2019   grade_9 181 1 5 0   10     0   8   108 97                       205.0 181 1 5 0   10     0   8   108 97                 205
2045082 2045082 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2019   grade_9 160 22 32 1   1     0   18   109 125                       234.0 160 22 32 1   1     0   18   109 125                 234
2046484 2046484 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2019   grade_9 208 10 14 1   9     0   4   109 137                       246.0 208 10 14 1   9     0   4   109 137                 246
2043148 2043148 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_9 1 1 13 0   0     0   0   11 4                       15.0 1 1 13 0   0     0   0   11 4                 15
2040974 2040974 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2019   grade_9 3 63 96 1   1     0   1   110 55                       165.0 3 63 96 1   1     0   1   110 55                 165
2042391 2042391 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2019   grade_9 160 12 17 2   6     0   3   111 89                       200.0 160 12 17 2   6     0   3   111 89                 200
2049209 2049209 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2019   grade_9 148 3 9 0   3     0   7   111 59                       170.0 148 3 9 0   3     0   7   111 59                 170
2041576 2041576 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2019   grade_9 169 28 18 0   28     0   5   112 136                       248.0 169 28 18 0   28     0   5   112 136                 248
2048119 2048119 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   grade_9 150 16 29 0   20     1   15   112 119                       231.0 150 16 29 0   20     1   15   112 119                 231
2041856 2041856 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2019   grade_9 173 5 17 1   6     0   6   115 93                       208.0 173 5 17 1   6     0   6   115 93                 208
2044004 2044004 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2019   grade_9 195 11 7 0   13     0   14   115 125                       240.0 195 11 7 0   13     0   14   115 125                 240
2049245 2049245 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 155 5 6 2   4     0   12   115 69                       184.0 155 5 6 2   4     0   12   115 69                 184
2044069 2044069 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2019   grade_9 200 8 11 2   2     0   4   116 111                       227.0 200 8 11 2   2     0   4   116 111                 227
2045295 2045295 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2019   grade_9 16 108 31 0   29     2   11   116 81                       197.0 16 108 31 0   29     2   11   116 81                 197
2046980 2046980 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2019   grade_9 199 10 8 0   36     0   4   116 141                       257.0 199 10 8 0   36     0   4   116 141                 257
2047934 2047934 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_9 3 132 87 0   0     1   2   116 109                       225.0 3 132 87 0   0     1   2   116 109                 225
2049221 2049221 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 161 2 11 0   0     0   6   116 63                       180.0 161 2 11 0   0     0   6   116 63                 180
2040138 2040138 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_9 160 18 16 0   39     0   9   117 125                       242.0 160 18 16 0   39     0   9   117 125                 242
2041989 2041989 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No High 09 12 2019   grade_9 219 0 4 1   3     0   9   118 118                       236.0 219 0 4 1   3     0   9   118 118                 236
2042604 2042604 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2019   grade_9 194 4 9 0   27     0   8   118 124                       242.0 194 4 9 0   27     0   8   118 124                 242
2044424 2044424 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_9 4 2 7 0   0     0   1   12 2                       14.0 4 2 7 0   0     0   1   12 2                 14
2041974 2041974 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2019   grade_9 165 27 18 0   19     0   6   120 115                       235.0 165 27 18 0   19     0   6   120 115                 235
2048737 2048737 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2019   grade_9 241 6 9 0   4     2   4   120 146                       266.0 241 6 9 0   4     2   4   120 146                 266
2049233 2049233 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2019   grade_9 150 1 11 0   3     0   7   121 51                       172.0 150 1 11 0   3     0   7   121 51                 172
2045595 2045595 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2019   grade_9 238 12 0 0   5     0   3   122 135                       258.0 238 12 0 0   5     0   3   122 135                 258
2042309 2042309 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2019   grade_9 185 15 10 5   5     0   20   123 117                       240.0 185 15 10 5   5     0   20   123 117                 240
2044853 2044853 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No High 09 12 2019   grade_9 174 24 38 0   13     1   5   124 131                       255.0 174 24 38 0   13     1   5   124 131                 255
2041005 2041005 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_9 76 70 83 0   57     0   12   126 172                       298.0 76 70 83 0   57     0   12   126 172                 298
2043784 2043784 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2019   grade_9 231 6 15 0   0     0   6   127 131                       258.0 231 6 15 0   0     0   6   127 131                 258
2048911 2048911 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2019   grade_9 239 1 9 1   1     1   1   127 126                       253.0 239 1 9 1   1     1   1   127 126                 253
2040952 2040952 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_9 12 54 175 0   7     0   4   128 124                       252.0 12 54 175 0   7     0   4   128 124                 252
2049154 2049154 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 140 47 31 0   4     0   15   128 109                       237.0 140 47 31 0   4     0   15   128 109                 237
2049193 2049193 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2019   grade_9 92 8 95 5   2     0   7   128 81                       209.0 92 8 95 5   2     0   7   128 81                 209
2043355 2043355 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2019   grade_9 211 7 11 0   12     0   8   130 119                       249.0 211 7 11 0   12     0   8   130 119                 249
2045499 2045499 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2019   grade_9 79 9 105 1   7     0   18   130 89                       219.0 79 9 105 1   7     0   18   130 89                 219
2042581 2042581 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2019   grade_9 193 5 32 0   2     2   4   131 107                       238.0 193 5 32 0   2     2   4   131 107                 238
2042969 2042969 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No High 09 12 2019   grade_9 220 2 3 1   47     0   9   131 151                       282.0 220 2 3 1   47     0   9   131 151                 282
2048530 2048530 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2019   grade_9 236 11 21 2   10     0   7   132 155                       287.0 236 11 21 2   10     0   7   132 155                 287
2046527 2046527 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2019   grade_9 228 9 12 2   19     0   8   133 145                       278.0 228 9 12 2   19     0   8   133 145                 278
2043520 2043520 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2019   grade_9 214 8 24 0   2     0   8   134 121                       256.0 214 8 24 0   2     0   8   134 121                 256
2044159 2044159 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   grade_9 185 40 17 2   15     2   10   134 137                       271.0 185 40 17 2   15     2   10   134 137                 271
2048587 2048587 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No High 09 12 2019   grade_9 265 1 11 0   12     1   6   135 161                       296.0 265 1 11 0   12     1   6   135 161                 296
2039860 2039860 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_9 219 7 21 1   6     0   11   136 129                       265.0 219 7 21 1   6     0   11   136 129                 265
2041884 2041884 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2019   grade_9 242 5 11 0   1     0   22   136 145                       281.0 242 5 11 0   1     0   22   136 145                 281
2044696 2044696 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2019   grade_9 208 12 16 1   23     0   10   137 131                       270.0 208 12 16 1   23     0   10   137 131                 270
2046219 2046219 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2019   grade_9 128 62 20 0   13     1   14   137 101                       238.0 128 62 20 0   13     1   14   137 101                 238
2043817 2043817 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2019   grade_9 93 13 136 0   4     0   8   138 116                       254.0 93 13 136 0   4     0   8   138 116                 254
2049150 2049150 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2019   grade_9 276 7 19 0   8     0   0   138 172                       310.0 276 7 19 0   8     0   0   138 172                 310
2042280 2042280 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_9 11 4 7 1   0     0   1   14 10                       24.0 11 4 7 1   0     0   1   14 10                 24
2043498 2043498 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 The Career Academy   Regular School No High 09 12 2019   grade_9 6 2 8 0   2     0   0   14 4                       18.0 6 2 8 0   2     0   0   14 4                 18
2042076 2042076 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No High 09 12 2019   grade_9 224 21 13 2   10     0   12   141 141                       282.0 224 21 13 2   10     0   12   141 141                 282
2043762 2043762 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2019   grade_9 229 10 10 0   14     0   11   141 133                       274.0 229 10 10 0   14     0   11   141 133                 274
2045153 2045153 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2019   grade_9 242 4 7 0   1     0   8   141 121                       262.0 242 4 7 0   1     0   8   141 121                 262
2048907 2048907 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2019   grade_9 256 3 7 0   3     0   1   144 126                       270.0 256 3 7 0   3     0   1   144 126                 270
2041744 2041744 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2019   grade_9 142 13 124 0   4     0   5   145 143                       288.0 142 13 124 0   4     0   5   145 143                 288
2048294 2048294 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2019   grade_9 250 14 18 1   25     0   22   145 184                       330.0 250 14 18 1   25     0   22   145 184                 330
2040978 2040978 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_9 5 88 137 2   4     0   5   146 95                       241.0 5 88 137 2   4     0   5   146 95                 241
2046762 2046762 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2019   grade_9 169 3 28 0   93     0   15   146 162                       308.0 169 3 28 0   93     0   15   146 162                 308
2041040 2041040 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2019   grade_9 44 108 100 1   71     0   6   147 183                       330.0 44 108 100 1   71     0   6   147 183                 330
2049141 2049141 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   grade_9 265 8 9 1   1     0   6   147 143                       290.0 265 8 9 1   1     0   6   147 143                 290
2048374 2048374 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2019   grade_9 247 4 30 0   3     0   4   148 140                       288.0 247 4 30 0   3     0   4   148 140                 288
2044752 2044752 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2019   grade_9 33 0 4 0   0     0   2   15 24                       39.0 33 0 4 0   0     0   2   15 24                 39
2048852 2048852 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2019   grade_9 32 0 0 0   0     0   1   15 18                       33.0 32 0 0 0   0     0   1   15 18                 33
2045336 2045336 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2019   grade_9 261 6 4 0   17     0   5   150 143                       293.0 261 6 4 0   17     0   5   150 143                 293
2049167 2049167 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School   Career and Technical School No High 09 12 2019   grade_9 310 4 44 1   6     0   14   151 228                       379.0 310 4 44 1   6     0   14   151 228                 379
2041748 2041748 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2019   grade_9 191 5 72 0   6     0   6   152 128                       280.0 191 5 72 0   6     0   6   152 128                 280
2042351 2042351 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2019   grade_9 77 13 144 0   16     0   23   152 121                       273.0 77 13 144 0   16     0   23   152 121                 273
2043677 2043677 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_9 39 19 186 4   18     0   9   152 122                       275.0 39 19 186 4   18     0   9   152 122                 275
2046829 2046829 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No High 09 12 2019   grade_9 237 7 47 0   9     0   5   155 150                       305.0 237 7 47 0   9     0   5   155 150                 305
2048750 2048750 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2019   grade_9 261 3 12 1   42     2   13   156 178                       334.0 261 3 12 1   42     2   13   156 178                 334
2044095 2044095 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_9 177 9 84 1   6     0   10   157 130                       287.0 177 9 84 1   6     0   10   157 130                 287
2049371 2049371 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 2019   grade_9 252 35 56 1   10     1   35   157 233                       390.0 252 35 56 1   10     1   35   157 233                 390
2040304 2040304 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   grade_9 242 20 9 1   26     0   6   159 145                       304.0 242 20 9 1   26     0   6   159 145                 304
2042719 2042719 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_9 38 0 0 0   3     0   3   16 28                       44.0 38 0 0 0   3     0   3   16 28                 44
2045643 2045643 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2019   grade_9 185 10 19 1   80     0   13   162 146                       308.0 185 10 19 1   80     0   13   162 146                 308
2049249 2049249 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2019   grade_9 215 15 71 2   2     0   15   164 156                       320.0 215 15 71 2   2     0   15   164 156                 320
2046152 2046152 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2019   grade_9 32 72 263 0   5     0   3   166 209                       375.0 32 72 263 0   5     0   3   166 209                 375
2040969 2040969 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2019   grade_9 29 19 229 0   8     0   7   167 125                       292.0 29 19 229 0   8     0   7   167 125                 292
2043237 2043237 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2019   grade_9 104 20 95 0   9     0   7   167 68                       235.0 104 20 95 0   9     0   7   167 68                 235
2047192 2047192 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2019   grade_9 244 25 41 1   21     1   8   167 174                       341.0 244 25 41 1   21     1   8   167 174                 341
2045783 2045783 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No High 09 12 2019   grade_9 101 39 158 1   18     1   11   169 160                       329.0 101 39 158 1   18     1   11   169 160                 329
2046732 2046732 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No High 09 12 2019   grade_9 260 16 17 0   42     0   20   169 186                       355.0 260 16 17 0   42     0   20   169 186                 355

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