enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
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
1673475 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
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
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
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
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
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
934025 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
1123700 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
2230514 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
2230516 2230516 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_12 150 635 102 4   30     2   27   476 474                       950.0 150 635 102 4   30     2   27   476 474                 950
1123701 1123701 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_11 169 633 111 4   31     2   28   494 484                       978 169 633 111 4   31     2   28   494 484                 978
737166 737166 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_11 231 627 106 3   26     0   23   530 486                       1016 231 627 106 3   26     0   23   530 486                 1016
737165 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
1123702 1123702 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_12 194 622 125 3   23     1   25   444 549                       993 194 622 125 3   23     1   25   444 549                 993
2041313 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
934027 934027 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_12 225 618 104 1   23     0   23   503 491                       994 225 618 104 1   23     0   23   503 491                 994
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
934026 934026 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_11 204 610 130 3   22     1   24   465 529                       994 204 610 130 3   22     1   24   465 529                 994
2041312 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
2230515 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
1366244 1366244 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_12 138 598 111 5   28     0   29   473 436 *                     909.0 138 598 111 5   28     0   29   473 436                 909
2041314 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
1673476 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
737167 737167 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_12 219 572 101 4   25     0   17   445 493                       938 219 572 101 4   25     0   17   445 493                 938
1673477 1673477 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_12 166 561 110 4   19     4   31   471 424 *                     895.0 166 561 110 4   19     4   31   471 424                 895
1366243 1366243 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_11 174 559 117 4   19     4   31   475 433 *                     908.0 174 559 117 4   19     4   31   475 433                 908
1366242 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
1366226 1366226 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2020   grade_7 24 199 33 2   3     0   11   139 133 *                     272.0 24 199 33 2   3     0   11   139 133                 272
1673460 1673460 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_8 24 188 31 2   3     0   10   128 130 *                     258.0 24 188 31 2   3     0   10   128 130                 258
2041294 2041294 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2019   grade_6 34 179 34 2   2     0   11   122 140                       262.0 34 179 34 2   2     0   11   122 140                 262
737401 737401 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_9 185 172 64 4   56     0   18   270 229                       499 185 172 64 4   56     0   18   270 229                 499
1123971 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
2230787 2230787 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge: Cambridge Rindge and Latin   Regular School No High 09 12 2018   grade_11 178 167 74 2   60     1   25   264 243                       507.0 178 167 74 2   60     1   25   264 243                 507
2230495 2230495 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_8 20 164 23 0   3     2   4   111 105                       216.0 20 164 23 0   3     2   4   111 105                 216
2236218 2236218 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_9 76 162 408 0   34     0   7   394 293                       687.0 76 162 408 0   34     0   7   394 293                 687
2041302 2041302 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2019   grade_6 59 162 25 3   9     1   6   151 114                       265.0 59 162 25 3   9     1   6   151 114                 265
1680124 1680124 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_6 7 161 106 2   1     0   5   141 141 *                     282.0 7 161 106 2   1     0   5   141 141                 282
1673467 1673467 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton - West Middle School   Regular School No Middle 06 08 2021   grade_8 52 160 23 2   8     0   6   137 114 *                     251.0 52 160 23 2   8     0   6   137 114                 251
934262 934262 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2016   grade_10 194 159 62 3   58     0   17   268 225                       493 194 159 62 3   58     0   17   268 225                 493
737403 737403 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_11 169 157 53 3   41     0   16   215 224                       439 169 157 53 3   41     0   16   215 224                 439
2041552 2041552 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_12 183 156 68 2   60     1   23   249 244                       493.0 183 156 68 2   60     1   23   249 244                 493
934264 934264 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2016   grade_12 171 155 54 3   41     0   16   215 225                       440 171 155 54 3   41     0   16   215 225                 440
1123972 1123972 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_11 192 155 64 3   60     0   16   262 228                       490 192 155 64 3   60     0   16   262 228                 490
940645 940645 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_5 4 154 80 0   0     0   0   120 118                       238 4 154 80 0   0     0   0   120 118                 238
1366233 1366233 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2020   grade_7 53 154 23 2   8     0   7   137 110 *                     247.0 53 154 23 2   8     0   7   137 110                 247
2047933 2047933 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_8 4 153 91 0   1     1   0   119 131                       250.0 4 153 91 0   1     1   0   119 131                 250
934261 934261 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2016   grade_9 166 152 71 1   54     1   20   239 226                       465 166 152 71 1   54     1   20   239 226                 465
1123632 1123632 MA Plymouth   school 2503090 44   Brockton 250309000221 440050 Gilmore School Early Childhood Center   Regular School No Elementary PK KG 2017   pre_kindergarten 74 152 22 1   4     0   10   164 99                       263 74 152 22 1   4     0   10   164 99                 263
1131556 1131556 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_6 2 152 86 0   0     0   2   114 128                       242 2 152 86 0   0     0   2   114 128                 242
2230788 2230788 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge: Cambridge Rindge and Latin   Regular School No High 09 12 2018   grade_12 193 152 60 2   62     0   16   260 225                       485.0 193 152 60 2   62     0   16   260 225                 485
1372862 1372862 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_9 6 152 89 0   4     1   1   141 112 *                     253.0 6 152 89 0   4     1   1   141 112                 253
1129400 1129400 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2017   grade_9 88 151 403 1   31     1   8   365 318                       683 88 151 403 1   31     1   8   365 318                 683
2238390 2238390 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_7 5 150 86 0   1     1   1   116 128                       244.0 5 150 86 0   1     1   1   116 128                 244
1681401 1681401 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 2021   grade_9 151 150 78 0   9     0   22   187 223 *                     410.0 151 150 78 0   9     0   22   187 223                 410
934009 934009 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2016   grade_6 18 148 20 0   3     1   5   102 93                       195 18 148 20 0   3     1   5   102 93                 195
938807 938807 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_9 99 148 327 0   44     1   9   347 281                       628 99 148 327 0   44     1   9   347 281                 628
1680125 1680125 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_7 2 147 111 1   0     1   2   142 122 *                     264.0 2 147 111 1   0     1   2   142 122                 264
1681402 1681402 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 2021   grade_10 175 147 52 0   4     0   21   179 220 *                     399.0 175 147 52 0   4     0   21   179 220                 399
2041301 2041301 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2019   grade_8 22 146 30 0   6     0   11   120 95                       215.0 22 146 30 0   6     0   11   120 95                 215
737404 737404 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_12 163 145 49 3   54     0   9   205 218                       423 163 145 49 3   54     0   9   205 218                 423
2230493 2230493 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_6 18 145 33 2   6     0   8   126 86                       212.0 18 145 33 2   6     0   8   126 86                 212
2230494 2230494 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_7 14 145 30 0   5     0   7   109 92                       201.0 14 145 30 0   5     0   7   109 92                 201
1673459 1673459 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_7 27 144 47 1   3     0   10   125 107 *                     232.0 27 144 47 1   3     0   10   125 107                 232
934011 934011 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2016   grade_8 19 143 20 1   5     1   9   109 89                       198 19 143 20 1   5     1   9   109 89                 198
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
1680126 1680126 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_8 1 143 107 0   1     0   2   129 125 *                     254.0 1 143 107 0   1     0   2   129 125                 254
1366225 1366225 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2020   grade_6 27 142 47 1   3     0   11   121 110 *                     231.0 27 142 47 1   3     0   11   121 110                 231
1673464 1673464 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton - South Middle School   Regular School No Middle 06 08 2021   grade_8 26 142 30 0   0     0   6   113 91 *                     204.0 26 142 30 0   0     0   6   113 91                 204
941930 941930 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 180 141 47 0   4     0   12   197 187                       384 180 141 47 0   4     0   12   197 187                 384
2230182 2230182 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_9 39 141 148 1   60     2   6   178 219                       397.0 39 141 148 1   60     2   6   178 219                 397
2041551 2041551 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_11 184 141 62 3   60     1   32   248 235                       483.0 184 141 62 3   60     1   32   248 235                 483
741999 741999 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2015   grade_9 55 140 422 0   3     0   17   352 285                       637 55 140 422 0   3     0   17   352 285                 637
1123680 1123680 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 06 08 2017   grade_7 18 140 22 0   3     1   5   99 90                       189 18 140 22 0   3     1   5   99 90                 189
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
2046119 2046119 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2019   grade_9 63 140 427 1   21     0   6   388 270                       658.0 63 140 427 1   21     0   6   388 270                 658
1366480 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
1366482 1366482 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_12 189 140 69 3   61     1   31   249 245 *                     494.0 189 140 69 3   61     1   31   249 245                 494
1372859 1372859 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_6 2 140 105 1   0     3   0   136 115 *                     251.0 2 140 105 1   0     3   0   136 115                 251
1374153 1374153 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 175 140 51 0   3     0   19   175 213 *                     388.0 175 140 51 0   3     0   19   175 213                 388
737402 737402 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_10 193 139 64 2   56     2   15   250 221                       471 193 139 64 2   56     2   15   250 221                 471
741163 741163 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2015   grade_7 24 139 31 0   33     2   4   114 119                       233 24 139 31 0   33     2   4   114 119                 233
741995 741995 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_10 78 139 263 0   32     0   18   278 252                       530 78 139 263 0   32     0   18   278 252                 530
940648 940648 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_8 2 139 99 0   2     0   3   117 128                       245 2 139 99 0   2     0   3   117 128                 245
1123677 1123677 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2017   grade_8 24 139 29 0   0     1   9   113 89                       202 24 139 29 0   0     1   9   113 89                 202
1366481 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
2049229 2049229 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_9 168 138 45 0   6     0   19   181 195                       376.0 168 138 45 0   6     0   19   181 195                 376
1372858 1372858 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_5 8 138 78 2   1     0   1   128 100 *                     228.0 8 138 78 2   1     0   1   128 100                 228
934010 934010 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2016   grade_7 13 137 30 0   4     1   6   98 93                       191 13 137 30 0   4     1   6   98 93                 191
1123679 1123679 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 06 08 2017   grade_6 18 137 34 1   5     0   7   111 91                       202 18 137 34 1   5     0   7   111 91                 202
1131555 1131555 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_5 3 137 93 0   6     1   4   139 105                       244 3 137 93 0   6     1   4   139 105                 244
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
1131559 1131559 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_9 1 136 83 0   1     0   3   112 112                       224 1 136 83 0   1     0   3   112 112                 224
2238391 2238391 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_8 1 136 115 0   1     0   2   118 137                       255.0 1 136 115 0   1     0   2   118 137                 255
2041550 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
2046120 2046120 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2019   grade_10 61 136 294 0   25     0   5   293 228                       521.0 61 136 294 0   25     0   5   293 228                 521
1366230 1366230 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2020   grade_7 25 136 30 0   0     0   7   108 90 *                     198.0 25 136 30 0   0     0   7   108 90                 198
1673461 1673461 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton - North Middle School   Regular School No Middle 06 08 2021   grade_6 21 136 27 1   3     0   12   96 104 *                     200.0 21 136 27 1   3     0   12   96 104                 200
1681403 1681403 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 2021   grade_11 157 136 41 0   6     0   17   177 180 *                     357.0 157 136 41 0   6     0   17   177 180                 357
737151 737151 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_8 26 135 23 1   5     0   8   98 100                       198 26 135 23 1   5     0   8   98 100                 198

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