enrollments

Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,359 ✖
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
1679642 1679642 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_8 9 14 68 1   11     0   2   54 51 *                     105.0 9 14 68 1   11     0   2   54 51                 105
1679754 1679754 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District) - Boston Preparatory Charter Public School   Regular School Yes High 06 12 2021   grade_8 1 73 26 0   1     0   4   57 48 *                     105.0 1 73 26 0   1     0   4   57 48                 105
2040936 2040936 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_8 7 17 72 0   8     0   1   63 42                       105.0 7 17 72 0   8     0   1   63 42                 105
2048336 2048336 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_8 95 1 4 0   1     0   4   58 47                       105.0 95 1 4 0   1     0   4   58 47                 105
2238672 2238672 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District: Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2018   grade_8 82 5 7 2   1     1   7   54 51                       105.0 82 5 7 2   1     1   7   54 51                 105
2238950 2238950 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier: Frontier Regional   Regular School No High 07 12 2018   grade_8 93 1 6 0   1     1   3   53 52                       105.0 93 1 6 0   1     1   3   53 52                 105
736742 736742 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_8 1 76 25 1   2     0   1   68 38                       106 1 76 25 1   2     0   1   68 38                 106
737127 737127 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_8 16 74 8 1   1     0   6   51 55                       106 16 74 8 1   1     0   6   51 55                 106
737973 737973 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_8 47 18 37 0   0     0   4   62 44                       106 47 18 37 0   0     0   4   62 44                 106
741985 741985 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2015   grade_8 6 10 89 0   1     0   0   54 52                       106 6 10 89 0   1     0   0   54 52                 106
744295 744295 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2015   grade_8 97 1 4 0   1     0   3   59 47                       106 97 1 4 0   1     0   3   59 47                 106
744516 744516 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2015   grade_8 97 2 1 0   2     0   4   59 47                       106 97 2 1 0   2     0   4   59 47                 106
934849 934849 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2016   grade_8 48 21 28 0   8     0   1   52 54                       106 48 21 28 0   8     0   1   52 54                 106
940167 940167 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2016   grade_8 6 6 83 0   8     0   3   51 55                       106 6 6 83 0   8     0   3   51 55                 106
940446 940446 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_8 52 34 5 0   9     0   6   43 63                       106 52 34 5 0   9     0   6   43 63                 106
940910 940910 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_8 93 2 8 0   2     0   1   57 49                       106 93 2 8 0   2     0   1   57 49                 106
1132440 1132440 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_8 91 2 7 0   1     0   5   54 52                       106 91 2 7 0   1     0   5   54 52                 106
1368652 1368652 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_8 20 18 42 0   19     0   7   45 61 *                     106.0 20 18 42 0   19     0   7   45 61                 106
1368957 1368957 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_8 63 4 32 0   5     0   2   44 62 *                     106.0 63 4 32 0   5     0   2   44 62                 106
1372667 1372667 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_8 24 61 16 0   3     1   1   51 55 *                     106.0 24 61 16 0   3     1   1   51 55                 106
1373675 1373675 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_8 100 0 2 0   1     0   3   50 56 *                     106.0 100 0 2 0   1     0   3   50 56                 106
2044124 2044124 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2019   grade_8 89 2 12 0   0     0   3   55 51                       106.0 89 2 12 0   0     0   3   55 51                 106
739752 739752 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2015   grade_8 79 3 12 0   4     0   9   55 52                       107 79 3 12 0   4     0   9   55 52                 107
743623 743623 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_8 59 27 5 0   13     0   3   51 56                       107 59 27 5 0   13     0   3   51 56                 107
935524 935524 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_8 65 22 7 1   3     0   9   56 51                       107 65 22 7 1   3     0   9   56 51                 107
1132762 1132762 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_8 94 1 8 1   0     0   3   51 56                       107 94 1 8 1   0     0   3   51 56                 107
1371519 1371519 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2020   grade_8 98 2 3 0   0     0   4   55 52 *                     107.0 98 2 3 0   0     0   4   55 52                 107
1371715 1371715 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_8 89 5 5 2   1     0   5   51 56 *                     107.0 89 5 5 2   1     0   5   51 56                 107
2233944 2233944 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Nantucket: Cyrus Peirce   Regular School No Middle 06 08 2018   grade_8 55 13 28 0   1     0   10   50 57                       107.0 55 13 28 0   1     0   10   50 57                 107
740056 740056 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No 2 06 08 2015   grade_8 71 12 19 0   1     0   5   56 52                       108 71 12 19 0   1     0   5   56 52                 108
743754 743754 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_8 60 17 6 0   23     0   2   54 54                       108 60 17 6 0   23     0   2   54 54                 108
938756 938756 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_8 29 32 41 0   4     0   2   56 52                       108 29 32 41 0   4     0   2   56 52                 108
1130584 1130584 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_8 92 0 8 1   2     0   5   51 57                       108 92 0 8 1   2     0   5   51 57                 108
1673943 1673943 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_8 100 4 0 0   1     0   3   64 44 *                     108.0 100 4 0 0   1     0   3   64 44                 108
1675535 1675535 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell - Rogers STEM Academy   Regular School No Elementary KG 08 2021   grade_8 15 19 49 0   23     0   2   50 58 *                     108.0 15 19 49 0   23     0   2   50 58                 108
2049327 2049327 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_8 1 95 10 0   0     0   2   49 59                       108.0 1 95 10 0   0     0   2   49 59                 108
2240000 2240000 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_8 3 97 8 0   0     0   0   55 53                       108.0 3 97 8 0   0     0   0   55 53                 108
743610 743610 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_8 30 42 25 0   7     1   4   68 41                       109 30 42 25 0   7     1   4   68 41                 109
939471 939471 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_8 97 5 1 0   1     0   5   54 55                       109 97 5 1 0   1     0   5   54 55                 109
939785 939785 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_8 93 0 6 0   8     0   2   48 61                       109 93 0 6 0   8     0   2   48 61                 109
941790 941790 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_8 102 0 4 0   3     0   0   58 51                       109 102 0 4 0   3     0   0   58 51                 109
1126126 1126126 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2017   grade_8 81 6 5 0   12     0   5   58 51                       109 81 6 5 0   12     0   5   58 51                 109
1367078 1367078 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_8 21 21 55 1   6     0   5   45 64 *                     109.0 21 21 55 1   6     0   5   45 64                 109
1368003 1368003 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_8 0 3 105 0   1     0   0   50 59 *                     109.0 0 3 105 0   1     0   0   50 59                 109
1368796 1368796 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_8 85 4 4 6   3     0   7   59 50 *                     109.0 85 4 4 6   3     0   7   59 50                 109
1672032 1672032 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_8 99 0 4 0   1     0   5   59 50 *                     109.0 99 0 4 0   1     0   5   59 50                 109
1681476 1681476 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_8 69 10 24 0   1     0   5   58 51 *                     109.0 69 10 24 0   1     0   5   58 51                 109
1681526 1681526 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_8 64 4 20 0   9     0   12   57 52 0                     109.0 64 4 20 0   9     0   12   57 52 0               109
2047992 2047992 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_8 84 9 10 0   4     0   2   60 49                       109.0 84 9 10 0   4     0   2   60 49                 109
2048968 2048968 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_8 87 2 17 0   2     0   1   61 48                       109.0 87 2 17 0   2     0   1   61 48                 109
2229248 2229248 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_8 101 1 3 0   1     0   3   56 53                       109.0 101 1 3 0   1     0   3   56 53                 109
2238455 2238455 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_8 90 3 12 0   2     0   2   56 53                       109.0 90 3 12 0   2     0   2   56 53                 109
2238647 2238647 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston: Athol-Royalston Middle School   Regular School No Middle 05 08 2018   grade_8 94 1 7 0   0     0   7   54 55                       109.0 94 1 7 0   0     0   7   54 55                 109
738212 738212 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_8 10 0 1 0   0     0   0   4 7                       11 10 0 1 0   0     0   0   4 7                 11
933818 933818 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_8 0 5 5 0   1     0   0   5 6                       11 0 5 5 0   1     0   0   5 6                 11
934973 934973 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_8 6 1 2 0   0     0   2   9 2                       11 6 1 2 0   0     0   2   9 2                 11
935065 935065 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_8 8 2 0 0   0     0   1   6 5                       11 8 2 0 0   0     0   1   6 5                 11
935865 935865 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_8 4 0 7 0   0     0   0   9 2                       11 4 0 7 0   0     0   0   9 2                 11
937873 937873 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   grade_8 2 7 1 0   0     0   1   4 7                       11 2 7 1 0   0     0   1   4 7                 11
940739 940739 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_8 5 1 0 0   4     0   1   2 9                       11 5 1 0 0   4     0   1   2 9                 11
1129010 1129010 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_8 2 3 6 0   0     0   0   7 *                       11 2 3 6 0   0     0   0   7                   11
2231755 2231755 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_8 11 0 0 0   0     0   0   6 5                       11.0 11 0 0 0   0     0   0   6 5                 11
737098 737098 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_8 20 73 12 0   2     0   3   55 55                       110 20 73 12 0   2     0   3   55 55                 110
1124102 1124102 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_8 7 9 91 0   2     0   1   66 44                       110 7 9 91 0   2     0   1   66 44                 110
1131348 1131348 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_8 38 44 7 0   13     1   7   52 58                       110 38 44 7 0   13     1   7   52 58                 110
1371024 1371024 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_8 4 13 93 0   0     0   0   60 50 *                     110.0 4 13 93 0   0     0   0   60 50                 110
1372920 1372920 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_8 85 5 16 0   2     0   2   52 58 *                     110.0 85 5 16 0   2     0   2   52 58                 110
1373274 1373274 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_8 99 2 4 0   1     0   4   61 49 *                     110.0 99 2 4 0   1     0   4   61 49                 110
1373827 1373827 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2020   grade_8 96 2 9 1   1     0   1   63 47 *                     110.0 96 2 9 1   1     0   1   63 47                 110
1374254 1374254 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_8 2 97 10 1   0     0   0   60 50 *                     110.0 2 97 10 1   0     0   0   60 50                 110
1680185 1680185 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_8 82 3 16 0   2     0   7   49 61 *                     110.0 82 3 16 0   2     0   7   49 61                 110
2232919 2232919 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton: Littleton Middle School   Regular School No Middle 06 08 2018   grade_8 96 2 2 0   7     0   3   54 56                       110.0 96 2 2 0   7     0   3   54 56                 110
2239744 2239744 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional: Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2018   grade_8 92 0 14 0   1     0   3   52 58                       110.0 92 0 14 0   1     0   3   52 58                 110
932560 932560 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_8 108 2 0 0   1     0   0   55 56                       111 108 2 0 0   1     0   0   55 56                 111
941396 941396 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_8 105 2 3 0   0     0   1   53 58                       111 105 2 3 0   0     0   1   53 58                 111
1124539 1124539 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_8 93 3 8 0   3     0   4   52 59                       111 93 3 8 0   3     0   4   52 59                 111
1124895 1124895 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_8 28 8 61 0   3     0   11   62 49                       111 28 8 61 0   3     0   11   62 49                 111
1126770 1126770 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No High 08 12 2017   grade_8 95 3 8 0   2     0   3   54 57                       111 95 3 8 0   2     0   3   54 57                 111
1373514 1373514 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_8 106 0 2 0   1     0   2   59 52 *                     111.0 106 0 2 0   1     0   2   59 52                 111
1675505 1675505 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow - Glenbrook Middle   Regular School No Middle 06 08 2021   grade_8 80 2 8 0   18     1   2   56 55 *                     111.0 80 2 8 0   18     1   2   56 55                 111
1679931 1679931 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_8 19 61 31 0   0     0   0   54 57 *                     111.0 19 61 31 0   0     0   0   54 57                 111
1680352 1680352 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_8 90 0 14 1   3     0   3   68 43 *                     111.0 90 0 14 1   3     0   3   68 43                 111
2039834 2039834 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_8 108 1 1 0   0     0   1   52 59                       111.0 108 1 1 0   0     0   1   52 59                 111
2040942 2040942 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_8 1 43 66 0   0     1   0   48 63                       111.0 1 43 66 0   0     1   0   48 63                 111
2042542 2042542 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_8 105 3 1 0   1     0   1   62 49                       111.0 105 3 1 0   1     0   1   62 49                 111
738182 738182 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_8 31 11 53 0   7     0   10   50 62                       112 31 11 53 0   7     0   10   50 62                 112
738382 738382 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_8 110 0 0 0   1     0   1   56 56                       112 110 0 0 0   1     0   1   56 56                 112
739196 739196 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2015   grade_8 104 1 1 0   1     1   4   48 64                       112 104 1 1 0   1     1   4   48 64                 112
935036 935036 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_8 42 5 47 0   6     0   12   66 46                       112 42 5 47 0   6     0   12   66 46                 112
940433 940433 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_8 37 22 45 0   5     0   3   55 57                       112 37 22 45 0   5     0   3   55 57                 112
941669 941669 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No 2 05 08 2016   grade_8 94 3 13 0   1     0   1   75 37                       112 94 3 13 0   1     0   1   75 37                 112
1127047 1127047 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_8 99 1 2 0   6     1   3   70 42                       112 99 1 2 0   6     1   3   70 42                 112
1129394 1129394 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No Middle 06 08 2017   grade_8 9 30 71 0   1     0   1   62 50                       112 9 30 71 0   1     0   1   62 50                 112
1131816 1131816 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_8 99 0 9 0   0     0   4   60 52                       112 99 0 9 0   0     0   4   60 52                 112
1368260 1368260 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2020   grade_8 79 4 9 0   16     0   4   51 61 *                     112.0 79 4 9 0   16     0   4   51 61                 112
1368270 1368270 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_8 88 1 10 0   10     0   3   52 60 *                     112.0 88 1 10 0   10     0   3   52 60                 112
1675248 1675248 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_8 2 2 108 0   0     0   0   57 55 *                     112.0 2 2 108 0   0     0   0   57 55                 112
1675265 1675265 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_8 2 1 109 0   0     0   0   59 53 *                     112.0 2 1 109 0   0     0   0   59 53                 112
1675515 1675515 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow - Williams Middle   Regular School No Middle 06 08 2021   grade_8 94 1 3 0   7     0   7   59 53 *                     112.0 94 1 3 0   7     0   7   59 53                 112
1678966 1678966 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater - West Bridgewater Junior/Senior   Regular School No High 07 12 2021   grade_8 96 5 5 0   1     0   5   52 60 *                     112.0 96 5 5 0   1     0   5   52 60                 112

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