enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by total_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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1125863 1125863 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_9 39 16 921 1   12     0   1   561 429                       990 39 16 921 1   12     0   1   561 429                 990
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
2043130 2043130 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_9 32 14 912 0   9     0   2   543 420                       969.0 32 14 912 0   9     0   2   543 420                 969
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
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
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
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
1368046 1368046 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_9 20 5 879 0   12     0   3   483 429 7                     919.0 20 5 879 0   12     0   3   483 429 7               919
2232680 2232680 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_9 30 6 854 0   20     0   1   500 411                       911.0 30 6 854 0   20     0   1   500 411                 911
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
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
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
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
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
1675292 1675292 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_10 17 4 854 0   13     0   2   466 421 3                     890.0 17 4 854 0   13     0   2   466 421 3               890
739360 739360 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_9 277 84 226 1   289     0   12   466 423                       889 277 84 226 1   289     0   12   466 423                 889
1368047 1368047 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_10 28 16 833 0   8     0   1   489 394 3                     886.0 28 16 833 0   8     0   1   489 394 3               886
2232681 2232681 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_10 29 15 826 1   10     0   1   483 399                       882.0 29 15 826 1   10     0   1   483 399                 882
1675654 1675654 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_9 202 80 340 0   221     0   37   479 401 *                     880.0 202 80 340 0   221     0   37   479 401                 880
936207 936207 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_9 253 96 223 0   259     0   24   432 423                       855 253 96 223 0   259     0   24   432 423                 855
1126300 1126300 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_9 238 100 235 1   243     1   21   429 410                       839 238 100 235 1   243     1   21   429 410                 839
2043493 2043493 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_9 221 104 233 0   236     0   30   411 413                       824.0 221 104 233 0   236     0   30   411 413                 824
2233118 2233118 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_9 214 80 242 1   256     0   29   409 413                       822.0 214 80 242 1   256     0   29   409 413                 822
2043132 2043132 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_11 26 12 756 1   12     0   1   429 375                       808.0 26 12 756 1   12     0   1   429 375                 808
1125864 1125864 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_10 22 11 742 1   14     0   5   417 378                       795 22 11 742 1   14     0   5   417 378                 795
936208 936208 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_10 244 82 185 1   269     0   12   417 376                       793 244 82 185 1   269     0   12   417 376                 793
1125865 1125865 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_11 26 15 737 0   14     0   1   392 401                       793 26 15 737 0   14     0   1   392 401                 793
739361 739361 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_10 265 80 190 1   246     0   10   390 402                       792 265 80 190 1   246     0   10   390 402                 792
1675291 1675291 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_9 19 13 735 1   14     0   3   425 358 2                     785.0 19 13 735 1   14     0   3   425 358 2               785
1126302 1126302 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_11 247 80 175 1   267     0   14   399 385                       784 247 80 175 1   267     0   14   399 385                 784
936209 936209 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_11 274 90 165 1   247     0   6   394 389                       783 274 90 165 1   247     0   6   394 389                 783
2043495 2043495 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_11 232 98 195 0   237     1   19   386 396                       782.0 232 98 195 0   237     1   19   386 396                 782
2233119 2233119 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_10 227 93 199 0   240     1   20   393 387                       780.0 227 93 199 0   240     1   20   393 387                 780
2233120 2233120 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_11 222 104 192 0   243     0   19   380 400                       780.0 222 104 192 0   243     0   19   380 400                 780
2043496 2043496 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_12 218 102 193 0   241     0   17   380 391                       771.0 218 102 193 0   241     0   17   380 391                 771
2043494 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
1126301 1126301 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_10 226 92 178 0   248     0   19   371 392                       763 226 92 178 0   248     0   19   371 392                 763
1368049 1368049 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_12 21 9 717 0   11     0   2   401 349 10                     760.0 21 9 717 0   11     0   2   401 349 10               760
1676586 1676586 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_9 296 101 315 2   7     1   34   407 349 *                     756.0 296 101 315 2   7     1   34   407 349                 756
1676587 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
1368411 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
935823 935823 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No 4 09 09 2016   grade_9 25 12 700 1   12     0   3   391 362                       753 25 12 700 1   12     0   3   391 362                 753
1675657 1675657 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_12 212 89 176 0   248     0   26   360 391 *                     751.0 212 89 176 0   248     0   26   360 391                 751
1675293 1675293 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_11 22 13 703 0   6     0   1   389 354 2                     745.0 22 13 703 0   6     0   1   389 354 2               745
2043131 2043131 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_10 21 2 699 0   19     1   1   383 359                       743.0 21 2 699 0   19     1   1   383 359                 743
1368412 1368412 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_11 204 86 186 0   244     0   23   355 388 *                     743.0 204 86 186 0   244     0   23   355 388                 743
2233121 2233121 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_12 238 80 154 1   256     0   13   369 373                       742.0 238 80 154 1   256     0   13   369 373                 742
2232682 2232682 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_11 21 13 688 1   13     0   5   363 378                       741.0 21 13 688 1   13     0   5   363 378                 741
1368413 1368413 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_12 215 99 177 0   232     1   17   367 374 *                     741.0 215 99 177 0   232     1   17   367 374                 741
1368410 1368410 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_9 150 79 272 0   210     0   29   388 352 *                     740.0 150 79 272 0   210     0   29   388 352                 740
1675656 1675656 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_11 206 99 179 0   227     0   25   362 374 *                     736.0 206 99 179 0   227     0   25   362 374                 736
1369337 1369337 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_9 269 89 331 3   4     0   37   377 355 *                     733.0 269 89 331 3   4     0   37   377 355                 733
2232683 2232683 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_12 24 13 679 0   14     0   1   344 387                       731.0 24 13 679 0   14     0   1   344 387                 731
1368048 1368048 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_11 23 5 674 0   20     0   1   372 349 2                     723.0 23 5 674 0   20     0   1   372 349 2               723
1126303 1126303 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_12 242 80 149 1   242     0   7   350 371                       721 242 80 149 1   242     0   7   350 371                 721
740276 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
1125866 1125866 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_12 33 12 652 0   5     0   0   347 355                       702 33 12 652 0   5     0   0   347 355                 702
937115 937115 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_11 284 93 276 5   6     3   28   351 344                       695 284 93 276 5   6     3   28   351 344                 695
2236518 2236518 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_8 476 81 98 1   14     0   23   342 351                       693.0 476 81 98 1   14     0   23   342 351                 693
1371298 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
739362 739362 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_11 214 78 156 1   231     0   7   340 347                       687 214 78 156 1   231     0   7   340 347                 687
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
1367388 1367388 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2020   grade_9 356 36 236 1   27     1   27   353 331 *                     684.0 356 36 236 1   27     1   27   353 331                 684
1675294 1675294 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_12 18 5 639 1   20     0   1   347 336 1                     684.0 18 5 639 1   20     0   1   347 336 1               684
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
936210 936210 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_12 202 73 166 1   231     0   6   338 341                       679 202 73 166 1   231     0   6   338 341                 679
1678551 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
1676588 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
2043133 2043133 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_12 15 11 619 1   14     0   4   331 333                       664.0 15 11 619 1   14     0   4   331 333                 664
1674622 1674622 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_9 326 39 245 0   24     1   26   356 305 *                     661.0 326 39 245 0   24     1   26   356 305                 661
1675655 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
1678306 1678306 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield - Springfield Central High   Regular School No High 09 12 2021   grade_9 46 123 454 1   25     0   10   354 305 *                     659.0 46 123 454 1   25     0   10   354 305                 659
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
1674623 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
1369338 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
739363 739363 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_12 203 83 154 1   199     0   5   321 324                       645 203 83 154 1   199     0   5   321 324                 645
1129701 1129701 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_8 435 90 90 1   5     0   23   319 325                       644 435 90 90 1   5     0   23   319 325                 644
742248 742248 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_8 448 75 73 1   16     3   27   346 297                       643 448 75 73 1   16     3   27   346 297                 643
738123 738123 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_9 376 59 148 1   36     2   19   344 297                       641 376 59 148 1   36     2   19   344 297                 641
1371044 1371044 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2020   grade_9 51 119 434 1   23     0   13   349 292 *                     641.0 51 119 434 1   23     0   13   349 292                 641
939057 939057 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_8 458 74 79 0   6     2   20   331 308                       639 458 74 79 0   6     2   20   331 308                 639
2044410 2044410 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_9 232 111 247 5   9     1   34   339 300                       639.0 232 111 247 5   9     1   34   339 300                 639

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