Data source: Big Local News · About: Big Local

2,758 rows where grade = "grade_10" and state = "MA" sorted by multiracial_int descending

View and edit SQL

year

grade

  • grade_10 · 2,758
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
1366343 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_10 323 32 64 0   83     1   54   296 257 4                     557.0 323 32 64 0   83     1   54   296 257 4               557
1673576 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_10 263 50 53 0   72     0   52   242 247 *                     490.0 263 50 53 0   72     0   52   242 247                 490
1673475 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_10 132 759 198 3   27     2   50   651 520 *                     1171.0 132 759 198 3   27     2   50   651 520                 1171
1680759 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury - Lincoln-Sudbury Regional High   Regular School No High 09 12 2021   grade_10 270 20 17 0   7     1   48   169 194 *                     363.0 270 20 17 0   7     1   48   169 194                 363
934125 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2016   grade_10 291 35 52 0   82     0   47   267 240                       507 291 35 52 0   82     0   47   267 240                 507
2230627 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline: Brookline High   Regular School No High 09 12 2018   grade_10 268 37 56 0   102     0   47   269 241                       510.0 268 37 56 0   102     0   47   269 241                 510
1366480 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_10 192 140 81 2   51     2   44   270 242 *                     512.0 192 140 81 2   51     2   44   270 242                 512
1673712 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_10 179 128 79 0   45     3   44   226 252 *                     478.0 179 128 79 0   45     3   44   226 252                 478
1123700 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_10 218 642 115 4   27     1   41   515 533                       1048 218 642 115 4   27     1   41   515 533                 1048
1366242 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_10 144 547 130 4   22     2   41   449 441 *                     890.0 144 547 130 4   22     2   41   449 441                 890
1681357 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_10 300 43 136 0   7     0   41   293 234 *                     527.0 300 43 136 0   7     0   41   293 234                 527
2041413 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_10 287 40 73 0   100     1   41   261 279                       542.0 287 40 73 0   100     1   41   261 279                 542
1676723 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_10 308 22 55 2   66     0   40   257 235 *                     493.0 308 22 55 2   66     0   40   257 235                 493
1369474 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2020   grade_10 322 30 60 0   88     0   38   279 259 *                     538.0 322 30 60 0   88     0   38   279 259                 538
2041312 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_10 197 601 130 3   22     4   38   541 454                       995.0 197 601 130 3   22     4   38   541 454                 995
2041550 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_10 188 136 74 2   54     2   37   256 237                       493.0 188 136 74 2   54     2   37   256 237                 493
2230786 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge: Cambridge Rindge and Latin   Regular School No High 09 12 2018   grade_10 195 134 63 3   54     1   36   245 241                       486.0 195 134 63 3   54     1   36   245 241                 486
1369479 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2020   grade_10 283 29 32 0   118     0   35   271 225 *                     497.0 283 29 32 0   118     0   35   271 225                 497
1675454 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_10 257 15 25 0   267     0   35   305 293 *                     599.0 257 15 25 0   267     0   35   305 293                 599
1676587 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_10 263 97 352 5   4     0   35   397 359 *                     756.0 263 97 352 5   4     0   35   397 359                 756
2042352 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2019   grade_10 81 24 154 0   11     0   35   143 162                       305.0 81 24 154 0   11     0   35   143 162                 305
2044547 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_10 307 42 44 3   68     0   34   254 242                       498.0 307 42 44 3   68     0   34   254 242                 498
2230514 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_10 167 642 144 6   27     2   34   556 466                       1022.0 167 642 144 6   27     2   34   556 466                 1022
737265 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_10 280 41 46 0   78     0   33   222 256                       478 280 41 46 0   78     0   33   222 256                 478
1674438 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_10 297 57 169 1   26     0   33   288 294 *                     583.0 297 57 169 1   26     0   33   288 294                 583
2043293 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_10 269 15 24 2   199     0   33   264 278                       542.0 269 15 24 2   199     0   33   264 278                 542
2232881 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington: Lexington High   Regular School No High 09 12 2018   grade_10 266 22 17 0   238     0   33   284 292                       576.0 266 22 17 0   238     0   33   284 292                 576
740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
1368209 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2020   grade_10 279 30 20 0   230     0   32   300 291 *                     591.0 279 30 20 0   230     0   32   300 291                 591
1676728 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_10 297 14 26 0   116     0   32   236 248 *                     485.0 297 14 26 0   116     0   32   236 248                 485
1123813 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_10 300 34 58 0   85     1   31   243 266                       509 300 34 58 0   85     1   31   243 266                 509
1367204 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2020   grade_10 300 52 154 1   29     0   31   298 269 *                     567.0 300 52 154 1   29     0   31   298 269                 567
1369338 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_10 214 107 288 4   7     1   31   350 302 *                     652.0 214 107 288 4   7     1   31   350 302                 652
740410 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_10 333 21 50 0   64     0   30   227 271                       498 333 21 50 0   64     0   30   227 271                 498
934025 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_10 183 648 120 4   34     3   30   535 487                       1022 183 648 120 4   34     3   30   535 487                 1022
1373026 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2020   grade_10 244 10 26 0   153     0   30   231 231 *                     463.0 244 10 26 0   153     0   30   231 231                 463
1677254 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Pittsfield - Taconic High   Regular School No High 09 12 2021   grade_10 130 29 27 0   3     0   30   108 110 *                     219.0 130 29 27 0   3     0   30   108 110                 219
2049176 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2019   grade_10 274 13 36 3   8     0   30   202 162                       364.0 274 13 36 3   8     0   30   202 162                 364
2233776 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen: Methuen High   Regular School No High 09 12 2018   grade_10 253 3 189 0   17     1   30   260 233                       493.0 253 3 189 0   17     1   30   260 233                 493
1124823 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_10 283 43 128 0   28     2   29   261 252                       513 283 43 128 0   28     2   29   261 252                 513
1374109 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_10 314 49 140 1   8     1   29   276 266 *                     542.0 314 49 140 1   8     1   29   276 266                 542
2234364 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton: Newton North High   Regular School No High 09 12 2018   grade_10 339 36 44 1   73     0   29   254 266                       522.0 339 36 44 1   73     0   29   254 266                 522
1126959 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2017   grade_10 279 1 171 2   17     1   28   271 228                       499 279 1 171 2   17     1   28   271 228                 499
1374113 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 2020   grade_10 208 29 221 2   96     0   28   287 294 3                     584.0 208 29 221 2   96     0   28   287 294 3               584
1374303 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_10 242 29 52 2   3     1   28   130 227 *                     357.0 242 29 52 2   3     1   28   130 227                 357
2049230 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 175 120 46 1   7     0   28   190 186                       377.0 175 120 46 1   7     0   28   190 186                 377
736061 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2015   grade_10 213 14 8 0   42     0   27   132 172                       304 213 14 8 0   42     0   27   132 172                 304
1123971 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_10 182 169 73 1   58     1   27   274 237                       511 182 169 73 1   58     1   27   274 237                 511
1369164 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2020   grade_10 299 15 23 1   22     0   27   196 189 *                     387.0 299 15 23 1   22     0   27   196 189                 387
2040060 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_10 295 30 72 1   25     2   27   239 213                       452.0 295 30 72 1   25     2   27   239 213                 452
2048120 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   grade_10 121 17 42 0   24     0   27   104 127                       231.0 121 17 42 0   24     0   27   104 127                 231
2239888 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_10 157 118 47 0   7     0   27   183 173                       356.0 157 118 47 0   7     0   27   183 173                 356
940801 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2016   grade_10 293 9 12 2   114     0   26   229 227                       456 293 9 12 2   114     0   26   229 227                 456
1369202 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No High 09 12 2020   grade_10 354 12 17 2   41     1   26   217 235 *                     453.0 354 12 17 2   41     1   26   217 235                 453
1674623 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_10 335 37 226 1   28     1   26   329 325 *                     654.0 335 37 226 1   28     1   26   329 325                 654
1678910 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley - Wellesley Sr High   Regular School No High 09 12 2021   grade_10 261 11 17 0   52     0   26   197 170 *                     367.0 261 11 17 0   52     0   26   197 170                 367
2044411 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_10 159 101 241 3   5     2   26   268 269                       537.0 159 101 241 3   5     2   26   268 269                 537
737165 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_10 220 623 140 4   27     3   25   503 539                       1042 220 623 140 4   27     3   25   503 539                 1042
1367282 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2020   grade_10 78 18 138 0   18     0   25   157 120 *                     277.0 78 18 138 0   18     0   25   157 120                 277
1368411 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_10 221 97 182 0   229     0   25   366 388 *                     754.0 221 97 182 0   229     0   25   366 388                 754
1675655 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_10 123 69 231 0   212     0   25   355 305 *                     660.0 123 69 231 0   212     0   25   355 305                 660
1676228 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_10 217 11 234 0   23     0   25   271 239 *                     510.0 217 11 234 0   23     0   25   271 239                 510
2043494 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_10 202 83 203 1   251     0   25   370 395                       765.0 202 83 203 1   251     0   25   370 395                 765
2044050 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2019   grade_10 260 6 201 1   25     0   25   280 238                       518.0 260 6 201 1   25     0   25   280 238                 518
2044552 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_10 301 25 34 0   111     0   25   257 237                       496.0 301 25 34 0   111     0   25   257 237                 496
2049185 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_10 326 39 144 4   3     0   25   264 277                       541.0 326 39 144 4   3     0   25   264 277                 541
936010 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2016   grade_10 310 18 26 0   184     0   24   298 264                       562 310 18 26 0   184     0   24   298 264                 562
1133023 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 2017   grade_10 235 22 193 3   90     0   24   332 235                       567 235 22 193 3   90     0   24   332 235                 567
1371956 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2020   grade_10 349 25 37 0   23     1   24   242 216 *                     459.0 349 25 37 0   23     1   24   242 216                 459
1678553 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_10 298 108 70 1   6     1   24   264 244 *                     508.0 298 108 70 1   6     1   24   264 244                 508
1681541 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 2021   grade_10 243 30 52 2   6     0   24   144 213 *                     357.0 243 30 52 2   6     0   24   144 213                 357
2042275 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2019   grade_10 308 52 151 1   28     0   24   278 286                       564.0 308 52 151 1   28     0   24   278 286                 564
740415 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_10 281 26 33 0   91     0   23   227 227                       454 281 26 33 0   91     0   23   227 227                 454
745065 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 366 55 107 2   3     0   23   247 309                       556 366 55 107 2   3     0   23   247 309                 556
932785 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2016   grade_10 312 24 54 2   21     2   23   230 208                       438 312 24 54 2   21     2   23   230 208                 438
940828 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2016   grade_10 137 17 34 0   25     0   23   133 103                       236 137 17 34 0   25     0   23   133 103                 236
1127542 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2017   grade_10 362 21 50 3   78     0   23   268 269                       537 362 21 50 3   78     0   23   268 269                 537
1129703 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_10 314 71 57 0   14     4   23   261 221                       483 314 71 57 0   14     4   23   261 221                 483
1365180 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2020   grade_10 232 10 18 0   58     0   23   167 174 *                     341.0 232 10 18 0   58     0   23   167 174                 341
1674044 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth - Dartmouth High   Regular School No High 09 12 2021   grade_10 198 7 14 0   0     0   23   126 116 *                     242.0 198 7 14 0   0     0   23   126 116                 242
2042460 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_10 345 47 128 0   31     0   23   287 287                       574.0 345 47 128 0   31     0   23   287 287                 574
2046733 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No High 09 12 2019   grade_10 294 13 19 0   56     0   23   206 199                       405.0 294 13 19 0   56     0   23   206 199                 405
2048098 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_10 243 8 11 1   143     0   23   223 206                       429.0 243 8 11 1   143     0   23   223 206                 429
2229057 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_10 305 23 74 2   14     0   23   230 211                       441.0 305 23 74 2   14     0   23   230 211                 441
2234369 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton: Newton South High   Regular School No High 09 12 2018   grade_10 314 31 29 0   91     0   23   265 223                       488.0 314 31 29 0   91     0   23   265 223                 488
739607 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_10 123 98 94 1   102     1   22   223 218                       441 123 98 94 1   102     1   22   223 218                 441
1122180 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_10 244 16 26 0   42     0   22   157 193                       350 244 16 26 0   42     0   22   157 193                 350
1126065 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_10 305 14 22 0   192     0   22   279 276                       555 305 14 22 0   192     0   22   279 276                 555
1127385 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_10 160 62 268 6   7     2   22   299 228                       527 160 62 268 6   7     2   22   299 228                 527
1132287 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2017   grade_10 295 20 17 0   23     1   22   198 180                       378 295 20 17 0   23     1   22   198 180                 378
1364977 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_10 269 16 19 0   38     0   22   172 192 *                     364.0 269 16 19 0   38     0   22   172 192                 364
1373233 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2020   grade_10 247 14 18 1   23     0   22   140 184 *                     325.0 247 14 18 1   23     0   22   140 184                 325
1672200 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_10 260 17 20 0   33     0   22   152 198 *                     352.0 260 17 20 0   33     0   22   152 198                 352
1672322 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_10 210 30 65 2   5     1   22   136 199 *                     335.0 210 30 65 2   5     1   22   136 199                 335
1680311 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_10 104 21 37 0   22     0   22   116 90 *                     206.0 104 21 37 0   22     0   22   116 90                 206
2044235 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2019   grade_10 319 14 32 0   20     1   22   190 218                       408.0 319 14 32 0   20     1   22   190 218                 408
2231632 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River: B M C Durfee High   Regular School No High 09 12 2018   grade_10 315 42 131 2   31     1   22   253 291                       544.0 315 42 131 2   31     1   22   253 291                 544
2234204 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_10 179 90 285 4   5     1   22   325 261                       586.0 179 90 285 4   5     1   22   325 261                 586
2240034 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_10 169 8 32 1   9     1   22   85 157                       242.0 169 8 32 1   9     1   22   85 157                 242
934975 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2016   grade_10 350 44 113 1   31     0   21   294 266                       560 350 44 113 1   31     0   21   294 266                 560

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