enrollments

Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by multiracial_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,737 ✖
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
2041412 2041412 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_9 326 29 65 0   75     1   58   296 255                       554.0 326 29 65 0   75     1   58   296 255                 554
1366342 1366342 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_9 281 48 54 0   81     0   57   253 268 0                     521.0 281 48 54 0   81     0   57   253 268 0               521
1673575 1673575 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_9 256 32 79 0   86     0   56   268 240 *                     509.0 256 32 79 0   86     0   56   268 240                 509
1366241 1366241 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_9 169 865 231 3   29     3   52   766 586 *                     1352.0 169 865 231 3   29     3   52   766 586                 1352
934024 934024 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_9 267 694 166 5   26     3   51   637 575                       1212 267 694 166 5   26     3   51   637 575                 1212
1373494 1373494 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2020   grade_9 266 18 15 0   4     0   50   160 193 *                     353.0 266 18 15 0   4     0   50   160 193                 353
2230513 2230513 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_9 218 689 157 3   23     3   50   630 513                       1143.0 218 689 157 3   23     3   50   630 513                 1143
737264 737264 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_9 288 37 50 0   70     0   49   259 235                       494 288 37 50 0   70     0   49   259 235                 494
1123699 1123699 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_9 216 739 183 4   29     3   49   687 536                       1223 216 739 183 4   29     3   49   687 536                 1223
1123812 1123812 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_9 272 38 47 0   95     0   48   266 234                       500 272 38 47 0   95     0   48   266 234                 500
1673474 1673474 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_9 187 617 165 1   24     2   48   589 455 *                     1044.0 187 617 165 1   24     2   48   589 455                 1044
1680758 1680758 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury - Lincoln-Sudbury Regional High   Regular School No High 09 12 2021   grade_9 279 21 16 1   5     0   47   180 189 *                     369.0 279 21 16 1   5     0   47   180 189                 369
1366479 1366479 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_9 190 130 78 0   48     3   45   231 263 *                     494.0 190 130 78 0   48     3   45   231 263                 494
2041311 2041311 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_9 174 708 154 3   20     4   45   585 523                       1108.0 174 708 154 3   20     4   45   585 523                 1108
2041549 2041549 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_9 198 143 77 3   44     2   45   262 250                       512.0 198 143 77 3   44     2   45   262 250                 512
2230626 2230626 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline: Brookline High   Regular School No High 09 12 2018   grade_9 288 40 68 0   90     1   44   252 278                       531.0 288 40 68 0   90     1   44   252 278                 531
1675453 1675453 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_9 224 25 27 0   231     0   43   261 288 *                     550.0 224 25 27 0   231     0   43   261 288                 550
1369473 1369473 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2020   grade_9 316 26 51 2   65     0   42   270 232 *                     502.0 316 26 51 2   65     0   42   270 232                 502
1374108 1374108 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 306 47 147 0   9     0   40   306 243 *                     549.0 306 47 147 0   9     0   40   306 243                 549
1367203 1367203 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2020   grade_9 296 56 162 1   28     0   38   296 284 *                     581.0 296 56 162 1   28     0   38   296 284                 581
1674437 1674437 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_9 250 57 149 0   31     0   38   279 246 *                     525.0 250 57 149 0   31     0   38   279 246                 525
1678552 1678552 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_9 314 122 79 5   5     2   38   293 272 *                     565.0 314 122 79 5   5     2   38   293 272                 565
2042274 2042274 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2019   grade_9 297 53 160 1   28     0   38   316 261                       577.0 297 53 160 1   28     0   38   316 261                 577
1369337 1369337 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_9 269 89 331 3   4     0   37   377 355 *                     733.0 269 89 331 3   4     0   37   377 355                 733
1675654 1675654 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_9 202 80 340 0   221     0   37   479 401 *                     880.0 202 80 340 0   221     0   37   479 401                 880
1673711 1673711 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_9 162 114 73 0   43     0   36   198 228 *                     428.0 162 114 73 0   43     0   36   198 228                 428
2230785 2230785 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge: Cambridge Rindge and Latin   Regular School No High 09 12 2018   grade_9 183 140 71 2   50     2   36   253 231                       484.0 183 140 71 2   50     2   36   253 231                 484
737164 737164 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_9 206 707 159 6   31     2   35   624 522                       1146 206 707 159 6   31     2   35   624 522                 1146
2044546 2044546 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_9 328 32 52 2   92     0   35   283 258                       541.0 328 32 52 2   92     0   35   283 258                 541
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
2231737 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
1676586 1676586 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_9 296 101 315 2   7     1   34   407 349 *                     756.0 296 101 315 2   7     1   34   407 349                 756
2044410 2044410 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_9 232 111 247 5   9     1   34   339 300                       639.0 232 111 247 5   9     1   34   339 300                 639
1123970 1123970 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_9 197 136 70 5   49     1   33   241 250                       491 197 136 70 5   49     1   33   241 250                 491
1368208 1368208 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2020   grade_9 268 14 23 0   269     0   33   312 294 *                     607.0 268 14 23 0   269     0   33   312 294                 607
2043292 2043292 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_9 286 31 19 0   229     0   33   297 301                       598.0 286 31 19 0   229     0   33   297 301                 598
2232880 2232880 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington: Lexington High   Regular School No High 09 12 2018   grade_9 267 17 20 2   191     0   33   260 270                       530.0 267 17 20 2   191     0   33   260 270                 530
741994 741994 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_9 78 135 293 0   27     0   32   293 272                       565 78 135 293 0   27     0   32   293 272                 565
934124 934124 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2016   grade_9 307 31 58 0   71     1   32   235 265                       500 307 31 58 0   71     1   32   235 265                 500
1369478 1369478 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2020   grade_9 310 13 27 0   112     0   32   238 255 *                     494.0 310 13 27 0   112     0   32   238 255                 494
1676722 1676722 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_9 319 24 63 0   77     0   32   261 253 *                     515.0 319 24 63 0   77     0   32   261 253                 515
1681356 1681356 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical - Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 349 43 131 4   7     1   32   306 261 *                     567.0 349 43 131 4   7     1   32   306 261                 567
2044551 2044551 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_9 277 29 28 0   113     0   32   252 226                       479.0 277 29 28 0   113     0   32   252 226                 479
2234363 2234363 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton: Newton North High   Regular School No High 09 12 2018   grade_9 313 39 43 3   72     1   32   254 249                       503.0 313 39 43 3   72     1   32   254 249                 503
2049184 2049184 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 318 51 144 1   8     1   31   282 272                       554.0 318 51 144 1   8     1   31   282 272                 554
2239822 2239822 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Greater Fall River Regional Vocational Technical: Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2018   grade_9 279 16 38 3   8     0   31   200 175                       375.0 279 16 38 3   8     0   31   200 175                 375
1126958 1126958 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2017   grade_9 263 1 168 0   18     1   30   248 233                       481 263 1 168 0   18     1   30   248 233                 481
2043493 2043493 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_9 221 104 233 0   236     0   30   411 413                       824.0 221 104 233 0   236     0   30   411 413                 824
934974 934974 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2016   grade_9 330 48 149 2   29     2   29   312 277                       589 330 48 149 2   29     2   29   312 277                 589
1368410 1368410 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_9 150 79 272 0   210     0   29   388 352 *                     740.0 150 79 272 0   210     0   29   388 352                 740
1374302 1374302 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 2020   grade_9 248 21 71 1   8     0   29   176 202 *                     378.0 248 21 71 1   8     0   29   176 202                 378
2048097 2048097 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_9 246 9 22 0   154     0   29   227 233                       460.0 246 9 22 0   154     0   29   227 233                 460
2049188 2049188 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 210 31 230 2   96     0   29   300 295                       598.0 210 31 230 2   96     0   29   300 295                 598
2233118 2233118 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_9 214 80 242 1   256     0   29   409 413                       822.0 214 80 242 1   256     0   29   409 413                 822
2239887 2239887 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical: Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 173 121 47 0   6     0   29   188 187                       376.0 173 121 47 0   6     0   29   188 187                 376
1127541 1127541 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2017   grade_9 338 36 47 1   71     0   28   259 262                       521 338 36 47 1   71     0   28   259 262                 521
1133072 1133072 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 163 133 48 0   7     0   28   187 192                       379 163 133 48 0   7     0   28   187 192                 379
1370008 1370008 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2020   grade_9 137 27 24 0   3     0   28   109 109 *                     219.0 137 27 24 0   3     0   28   109 109                 219
1672255 1672255 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_9 291 30 73 1   26     0   28   240 209 *                     449.0 291 30 73 1   26     0   28   240 209                 449
2044234 2044234 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2019   grade_9 293 15 23 1   24     0   28   191 192                       384.0 293 15 23 1   24     0   28   191 192                 384
2231631 2231631 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River: B M C Durfee High   Regular School No High 09 12 2018   grade_9 345 47 164 0   31     0   28   317 298                       615.0 345 47 164 0   31     0   28   317 298                 615
2238599 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
740275 740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
1126064 1126064 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_9 254 20 18 0   233     0   27   270 282                       552 254 20 18 0   233     0   27   270 282                 552
1367388 1367388 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2020   grade_9 356 36 236 1   27     1   27   353 331 *                     684.0 356 36 236 1   27     1   27   353 331                 684
743967 743967 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_9 294 7 13 2   115     0   26   229 228                       457 294 7 13 2   115     0   26   229 228                 457
1368978 1368978 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2020   grade_9 209 6 216 0   24     0   26   251 230 *                     481.0 209 6 216 0   24     0   26   251 230                 481
1371659 1371659 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No High 09 12 2020   grade_9 273 10 17 0   50     0   26   203 173 *                     376.0 273 10 17 0   50     0   26   203 173                 376
1674622 1674622 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_9 326 39 245 0   24     1   26   356 305 *                     661.0 326 39 245 0   24     1   26   356 305                 661
1680495 1680495 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord-Carlisle - Concord Carlisle High   Regular School No High 09 12 2021   grade_9 253 14 24 1   21     0   26   168 170 *                     339.0 253 14 24 1   21     0   26   168 170                 339
2047029 2047029 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2019   grade_9 375 30 44 0   25     1   26   270 230                       501.0 375 30 44 0   25     1   26   270 230                 501
2229056 2229056 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_9 309 27 66 1   25     2   26   242 214                       456.0 309 27 66 1   25     2   26   242 214                 456
2234203 2234203 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_9 172 81 227 4   5     2   26   284 233                       517.0 172 81 227 4   5     2   26   284 233                 517
2239832 2239832 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical: Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 335 40 147 5   4     0   26   273 284                       557.0 335 40 147 5   4     0   26   273 284                 557
739163 739163 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_9 317 18 25 1   169     0   25   295 260                       555 317 18 25 1   169     0   25   295 260                 555
936009 936009 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2016   grade_9 309 14 16 0   184     0   25   275 273                       548 309 14 16 0   184     0   25   275 273                 548
937113 937113 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_9 209 68 261 9   4     1   25   339 238                       577 209 68 261 9   4     1   25   339 238                 577
941888 941888 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 227 21 190 3   96     0   25   327 235                       562 227 21 190 3   96     0   25   327 235                 562
1124822 1124822 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_9 344 45 150 3   30     0   25   298 299                       597 344 45 150 3   30     0   25   298 299                 597
2041026 2041026 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_9 166 34 53 0   129     0   25   175 232                       407.0 166 34 53 0   129     0   25   175 232                 407
2234368 2234368 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton: Newton South High   Regular School No High 09 12 2018   grade_9 299 22 34 0   105     0   25   244 239                       485.0 299 22 34 0   105     0   25   244 239                 485
932728 932728 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2016   grade_9 241 17 21 0   41     0   24   154 190                       344 241 17 21 0   41     0   24   154 190                 344
936207 936207 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_9 253 96 223 0   259     0   24   432 423                       855 253 96 223 0   259     0   24   432 423                 855
2044272 2044272 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No High 09 12 2019   grade_9 355 10 17 2   42     0   24   215 235                       450.0 355 10 17 2   42     0   24   215 235                 450
2236519 2236519 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_9 336 103 82 0   6     0   24   276 275                       551.0 336 103 82 0   6     0   24   276 275                 551
739522 739522 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_9 93 52 313 0   25     0   23   293 213                       506 93 52 313 0   25     0   23   293 213                 506
743993 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
937245 937245 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2016   grade_9 349 20 47 2   81     0   23   260 262                       522 349 20 47 2   81     0   23   260 262                 522
941262 941262 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No 3 09 12 2016   grade_9 307 19 16 0   20     1   23   199 187                       386 307 19 16 0   20     1   23   199 187                 386
1127384 1127384 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_9 189 86 270 3   3     1   23   317 258                       575 189 86 270 3   3     1   23   317 258                 575
1364976 1364976 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_9 272 17 20 0   36     0   23   162 205 *                     368.0 272 17 20 0   36     0   23   162 205                 368
1365097 1365097 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_9 218 30 53 2   5     1   23   134 198 *                     332.0 218 30 53 2   5     1   23   134 198                 332
1365982 1365982 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_9 191 41 65 0   130     2   23   211 239 *                     452.0 191 41 65 0   130     2   23   211 239                 452
1371299 1371299 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   grade_9 305 113 68 1   8     1   23   272 247 *                     519.0 305 113 68 1   8     1   23   272 247                 519
1373046 1373046 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2020   grade_9 104 20 35 0   23     0   23   110 95 *                     205.0 104 20 35 0   23     0   23   110 95                 205
1672401 1672401 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont - Belmont High   Regular School No High 09 12 2021   grade_9 225 14 19 1   52     0   23   169 165 *                     334.0 225 14 19 1   52     0   23   169 165                 334
1676448 1676448 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham - Needham High   Regular School No High 09 12 2021   grade_9 322 10 30 0   38     1   23   204 216 4                     424.0 322 10 30 0   38     1   23   204 216 4               424
1676727 1676727 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_9 252 17 25 1   94     1   23   219 194 *                     413.0 252 17 25 1   94     1   23   219 194                 413
1678791 1678791 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham - Wareham Senior High   Regular School No High 08 12 2021   grade_9 78 11 15 4   0     0   23   67 64 *                     131.0 78 11 15 4   0     0   23   67 64                 131
1681360 1681360 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 197 39 221 1   115     0   23   268 324 4                     596.0 197 39 221 1   115     0   23   268 324 4               596

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