Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by multiracial_int descending

View and edit SQL

grade

year

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 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 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 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
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
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
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
1673577 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_11 296 31 64 0   71     1   52   274 238 *                     515.0 296 31 64 0   71     1   52   274 238                 515
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
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
2230629 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline: Brookline High   Regular School No High 09 12 2018   grade_12 286 35 53 0   82     0   50   266 240                       506.0 286 35 53 0   82     0   50   266 240                 506
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
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
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 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 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 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
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
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
1123814 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_11 279 35 52 0   80     0   46   260 232                       492 279 35 52 0   80     0   46   260 232                 492
2041414 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_11 266 38 51 0   88     0   46   260 227                       489.0 266 38 51 0   88     0   46   260 227                 489
1366345 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_12 254 39 48 0   87     0   46   250 221 3                     474.0 254 39 48 0   87     0   46   250 221 3               474
1673713 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_11 186 129 65 2   46     2   46   246 230 *                     476.0 186 129 65 2   46     2   46   246 230                 476
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 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
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
1371298 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   grade_8 427 122 83 4   8     1   45   356 334 *                     690.0 427 122 83 4   8     1   45   356 334                 690
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
1366344 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_11 268 43 67 0   89     1   44   245 265 2                     512.0 268 43 67 0   89     1   44   245 265 2               512
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
2230515 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_11 209 598 112 2   27     1   43   469 523                       992.0 209 598 112 2   27     1   43   469 523                 992
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 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
737267 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_12 281 28 45 0   78     0   41   232 241                       473 281 28 45 0   78     0   41   232 241                 473
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
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
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
1673578 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_12 263 45 65 0   88     1   41   248 255 *                     503.0 263 45 65 0   88     1   41   248 255                 503
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
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
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
1676724 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_11 316 31 60 0   91     0   40   279 259 *                     538.0 316 31 60 0   91     0   40   279 259                 538
1673476 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_11 131 580 128 3   22     2   39   450 455 *                     905.0 131 580 128 3   22     2   39   450 455                 905
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
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
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
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
1672397 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_5 201 14 14 2   66     0   38   164 171 *                     335.0 201 14 14 2   66     0   38   164 171                 335
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 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
2041314 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_12 201 593 108 2   22     1   37   450 514                       964.0 201 593 108 2   22     1   37   450 514                 964
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
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 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
934126 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2016   grade_11 279 43 46 0   76     0   36   233 247                       480 279 43 46 0   76     0   36   233 247                 480
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
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
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
1676588 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_11 216 109 298 3   7     2   36   359 311 *                     671.0 216 109 298 3   7     2   36   359 311                 671
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
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
2041313 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_11 151 620 120 5   28     1   35   504 456                       960.0 151 620 120 5   28     1   35   504 456                 960
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
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 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
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
1676729 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_11 268 28 34 0   114     0   35   268 210 *                     479.0 268 28 34 0   114     0   35   268 210                 479
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
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
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
1369328 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2020   grade_6 120 59 143 2   3     0   34   202 159 *                     361.0 120 59 143 2   3     0   34   202 159                 361
1672196 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Arlington - Gibbs School   Regular School No Middle 06 06 2021   grade_6 334 21 31 2   60     1   34   260 223 *                     483.0 334 21 31 2   60     1   34   260 223                 483
1675456 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_12 252 14 25 2   203     0   34   260 270 *                     530.0 252 14 25 2   203     0   34   260 270                 530
1676578 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_7 113 62 137 2   3     0   34   198 153 *                     351.0 113 62 137 2   3     0   34   198 153                 351
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
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
1123815 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_12 280 44 49 0   73     0   33   224 255                       479 280 44 49 0   73     0   33   224 255                 479
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
2230628 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline: Brookline High   Regular School No High 09 12 2018   grade_11 294 31 61 0   77     1   33   242 255                       497.0 294 31 61 0   77     1   33   242 255                 497
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
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
2041415 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_12 292 33 59 0   81     1   33   243 255                       499.0 292 33 59 0   81     1   33   243 255                 499
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
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
2043294 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_11 258 23 19 1   238     0   33   287 284                       572.0 258 23 19 1   238     0   33   287 284                 572
1366481 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_11 183 139 63 2   49     2   33   230 241 *                     471.0 183 139 63 2   49     2   33   230 241                 471
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
1368210 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2020   grade_11 248 14 26 2   203     0   33   262 264 *                     526.0 248 14 26 2   203     0   33   262 264                 526
1369475 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2020   grade_11 312 38 44 1   69     0   33   255 241 *                     497.0 312 38 44 1   69     0   33   255 241                 497
1369476 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2020   grade_12 333 38 45 0   75     0   33   249 273 *                     524.0 333 38 45 0   75     0   33   249 273                 524
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
1676725 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_12 309 37 48 1   71     0   33   248 249 *                     499.0 309 37 48 1   71     0   33   248 249                 499
1678551 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_8 426 113 92 4   5     2   33   337 338 *                     675.0 426 113 92 4   5     2   33   337 338                 675
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
740278 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_12 183 71 105 1   10     4   32   200 206                       406 183 71 105 1   10     4   32   200 206                 406
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

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