enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
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
1366468 1366468 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2020   grade_7 45 19 15 1   10     0   9   57 42 *                     99.0 45 19 15 1   10     0   9   57 42                 99
1678279 1678279 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield - STEM Middle Academy   Regular School No Middle 06 08 2021   grade_7 10 25 59 0   4     0   1   59 40 *                     99.0 10 25 59 0   4     0   1   59 40                 99
2232599 2232599 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_7 6 0 90 0   3     0   0   46 53                       99.0 6 0 90 0   3     0   0   46 53                 99
935398 935398 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_7 79 3 3 0   11     0   3   52 47                       99 79 3 3 0   11     0   3   52 47                 99
1124652 1124652 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_7 29 20 40 1   8     0   1   56 43                       99 29 20 40 1   8     0   1   56 43                 99
1366471 1366471 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2020   grade_7 29 33 14 0   14     1   7   39 59 *                     98.0 29 33 14 0   14     1   7   39 59                 98
1367859 1367859 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2020   grade_7 9 6 79 0   2     0   2   52 46 *                     98.0 9 6 79 0   2     0   2   52 46                 98
1368642 1368642 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_7 25 13 18 0   39     0   3   55 43 *                     98.0 25 13 18 0   39     0   3   55 43                 98
1370986 1370986 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2020   grade_7 18 22 58 0   0     0   0   40 58 *                     98.0 18 22 58 0   0     0   0   40 58                 98
1373674 1373674 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_7 77 1 7 1   11     0   1   58 40 *                     98.0 77 1 7 1   11     0   1   58 40                 98
1679641 1679641 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_7 11 9 70 0   8     0   0   47 51 *                     98.0 11 9 70 0   8     0   0   47 51                 98
2040941 2040941 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_7 1 41 54 0   0     0   2   42 56                       98.0 1 41 54 0   0     0   2   42 56                 98
2046090 2046090 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_7 13 11 68 0   4     0   2   54 44                       98.0 13 11 68 0   4     0   2   54 44                 98
2232320 2232320 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_7 50 20 15 0   4     0   9   47 51                       98.0 50 20 15 0   4     0   9   47 51                 98
2232953 2232953 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow: Williams Middle   Regular School No Middle 06 08 2018   grade_7 84 1 4 0   6     0   3   61 37                       98.0 84 1 4 0   6     0   3   61 37                 98
2238198 2238198 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   grade_7 49 24 22 0   1     0   2   53 45                       98.0 49 24 22 0   1     0   2   53 45                 98
737981 737981 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_7 38 12 38 0   7     0   3   54 44                       98 38 12 38 0   7     0   3   54 44                 98
738484 738484 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2015   grade_7 71 2 18 0   2     0   5   55 43                       98 71 2 18 0   2     0   5   55 43                 98
1125355 1125355 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_7 76 2 3 0   16     0   1   44 54                       98 76 2 3 0   16     0   1   44 54                 98
1127103 1127103 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_7 91 1 1 0   0     2   3   51 47                       98 91 1 1 0   0     2   3   51 47                 98
1129393 1129393 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No Middle 06 08 2017   grade_7 10 16 67 0   3     0   2   52 46                       98 10 16 67 0   3     0   2   52 46                 98
1131366 1131366 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_7 43 31 23 0   0     0   1   47 51                       98 43 31 23 0   0     0   1   47 51                 98
1365191 1365191 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_7 91 0 4 0   0     0   2   48 49 *                     97.0 91 0 4 0   0     0   2   48 49                 97
1368669 1368669 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2020   grade_7 38 18 13 0   23     0   5   49 48 *                     97.0 38 18 13 0   23     0   5   49 48                 97
1372490 1372490 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_7 2 65 24 0   1     0   5   52 45 *                     97.0 2 65 24 0   1     0   5   52 45                 97
1372696 1372696 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_7 49 34 10 1   0     0   3   51 46 *                     97.0 49 34 10 1   0     0   3   51 46                 97
1373122 1373122 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_7 77 3 10 0   2     0   5   56 41 *                     97.0 77 3 10 0   2     0   5   56 41                 97
1373273 1373273 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_7 84 1 7 0   0     0   5   47 50 *                     97.0 84 1 7 0   0     0   5   47 50                 97
1672868 1672868 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_7 6 20 21 0   46     0   4   47 50 *                     97.0 6 20 21 0   46     0   4   47 50                 97
2042541 2042541 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_7 94 1 2 0   0     0   0   51 46                       97.0 94 1 2 0   0     0   0   51 46                 97
2043717 2043717 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_7 20 15 38 0   16     0   8   48 49                       97.0 20 15 38 0   16     0   8   48 49                 97
2046788 2046788 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_7 80 4 5 2   1     0   5   46 51                       97.0 80 4 5 2   1     0   5   46 51                 97
2229247 2229247 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_7 92 0 0 0   0     0   5   47 50                       97.0 92 0 0 0   0     0   5   47 50                 97
744515 744515 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2015   grade_7 90 0 3 0   1     1   2   51 46                       97 90 0 3 0   1     1   2   51 46                 97
933656 933656 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 05 08 2016   grade_7 6 38 49 1   1     0   2   57 40                       97 6 38 49 1   1     0   2   57 40                 97
938780 938780 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2016   grade_7 10 31 56 0   0     0   0   61 36                       97 10 31 56 0   0     0   0   61 36                 97
938792 938792 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2016   grade_7 0 8 89 0   0     0   0   50 47                       97 0 8 89 0   0     0   0   50 47                 97
940818 940818 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_7 88 7 0 0   2     0   0   55 42                       97 88 7 0 0   2     0   0   55 42                 97
1132471 1132471 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2017   grade_7 87 0 4 0   3     0   3   40 57                       97 87 0 4 0   3     0   3   40 57                 97
1132761 1132761 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_7 82 0 10 0   1     0   4   52 45                       97 82 0 10 0   1     0   4   52 45                 97
1372889 1372889 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_7 17 49 18 2   7     0   3   55 41 *                     96.0 17 49 18 2   7     0   3   55 41                 96
1675226 1675226 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_7 3 1 90 0   2     0   0   47 49 *                     96.0 3 1 90 0   2     0   0   47 49                 96
1675892 1675892 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_7 19 14 39 0   20     0   4   47 48 *                     96.0 19 14 39 0   20     0   4   47 48                 96
1680058 1680058 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_7 4 47 41 0   0     0   4   49 47 *                     96.0 4 47 41 0   0     0   4   49 47                 96
1680929 1680929 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba - Hale   Regular School No Middle 06 08 2021   grade_7 85 1 2 0   3     0   5   53 43 *                     96.0 85 1 2 0   3     0   5   53 43                 96
2042033 2042033 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_7 77 0 11 0   6     0   2   43 53                       96.0 77 0 11 0   6     0   2   43 53                 96
2043735 2043735 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_7 42 17 13 1   19     0   4   51 44                       96.0 42 17 13 1   19     0   4   51 44                 96
2047767 2047767 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_7 30 38 21 0   4     0   3   55 41                       96.0 30 38 21 0   4     0   3   55 41                 96
2048204 2048204 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2019   grade_7 82 2 4 0   5     0   3   55 41                       96.0 82 2 4 0   5     0   3   55 41                 96
2049110 2049110 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2019   grade_7 85 1 6 0   0     0   4   53 43                       96.0 85 1 6 0   0     0   4   53 43                 96
2239717 2239717 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   grade_7 83 1 7 0   2     0   3   48 48                       96.0 83 1 7 0   2     0   3   48 48                 96
936879 936879 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2016   grade_7 95 1 0 0   0     0   0   45 51                       96 95 1 0 0   0     0   0   45 51                 96
941426 941426 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2016   grade_7 86 3 2 0   2     0   3   51 45                       96 86 3 2 0   2     0   3   51 45                 96
1366273 1366273 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_7 57 4 11 0   17     0   6   51 44 *                     95.0 57 4 11 0   17     0   6   51 44                 95
1366474 1366474 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2020   grade_7 37 34 6 0   8     0   10   48 47 *                     95.0 37 34 6 0   8     0   10   48 47                 95
2040381 2040381 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_7 5 23 65 0   1     0   1   50 45                       95.0 5 23 65 0   1     0   1   50 45                 95
2236778 2236778 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware: Ware Junior/Senior High School   Regular School No High 07 12 2018   grade_7 78 2 8 0   2     0   5   45 50                       95.0 78 2 8 0   2     0   5   45 50                 95
737396 737396 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2015   grade_7 41 24 12 0   12     0   6   48 47                       95 41 24 12 0   12     0   6   48 47                 95
738005 738005 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_7 22 23 45 1   2     0   2   40 55                       95 22 23 45 1   2     0   2   40 55                 95
741975 741975 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2015   grade_7 20 23 46 0   2     0   4   52 43                       95 20 23 46 0   2     0   4   52 43                 95
743639 743639 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_7 39 29 21 2   2     0   2   48 47                       95 39 29 21 2   2     0   2   48 47                 95
744991 744991 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2015   grade_7 87 3 4 0   1     0   0   55 40                       95 87 3 4 0   1     0   0   55 40                 95
935523 935523 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_7 62 11 15 0   5     0   2   52 43                       95 62 11 15 0   5     0   2   52 43                 95
936439 936439 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2016   grade_7 37 17 17 0   21     0   3   46 49                       95 37 17 17 0   21     0   3   46 49                 95
1123959 1123959 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2017   grade_7 23 34 18 1   11     1   7   50 45                       95 23 34 18 1   11     1   7   50 45                 95
1130177 1130177 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No Other 06 12 2017   grade_7 79 1 9 1   1     0   4   45 50                       95 79 1 9 1   1     0   4   45 50                 95
1131587 1131587 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_7 10 59 19 0   5     0   2   40 55                       95 10 59 19 0   5     0   2   40 55                 95
1365846 1365846 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_7 2 52 38 0   0     0   2   55 39 *                     94.0 2 52 38 0   0     0   2   55 39                 94
1367760 1367760 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_7 45 20 13 0   7     0   9   40 53 *                     94.0 45 20 13 0   7     0   9   40 53                 94
1368821 1368821 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_7 74 3 13 0   2     0   2   55 38 *                     94.0 74 3 13 0   2     0   2   55 38                 94
1373038 1373038 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_7 84 5 2 0   1     0   2   48 46 *                     94.0 84 5 2 0   1     0   2   48 46                 94
1673083 1673083 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_7 2 60 25 1   2     0   4   47 47 *                     94.0 2 60 25 1   2     0   4   47 47                 94
1673709 1673709 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge - Vassal Lane Upper School   Regular School No Middle 06 08 2021   grade_7 39 28 7 0   14     0   6   53 41 *                     94.0 39 28 7 0   14     0   6   53 41                 94
1676071 1676071 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard - Fowler School   Regular School No Middle 04 08 2021   grade_7 72 4 15 0   0     0   3   44 50 *                     94.0 72 4 15 0   0     0   3   44 50                 94
1679714 1679714 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_7 24 15 55 0   0     0   0   43 51 *                     94.0 24 15 55 0   0     0   0   43 51                 94
2041544 2041544 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2019   grade_7 43 24 10 0   9     0   8   37 57                       94.0 43 24 10 0   9     0   8   37 57                 94
2048478 2048478 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No Middle 06 08 2019   grade_7 77 1 7 0   0     0   9   43 51                       94.0 77 1 7 0   0     0   9   43 51                 94
2049087 2049087 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 4 0   1     0   2   43 51                       94.0 86 1 4 0   1     0   2   43 51                 94
2235200 2235200 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy: Point Webster Middle   Regular School No Middle 05 08 2018   grade_7 37 12 8 1   33     0   3   51 43                       94.0 37 12 8 1   33     0   3   51 43                 94
2239023 2239023 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague: Great Falls Middle   Regular School No Middle 06 08 2018   grade_7 74 4 9 0   0     0   7   56 38                       94.0 74 4 9 0   0     0   7   56 38                 94
2239207 2239207 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock: Mt Greylock Regional High   Regular School No High 07 12 2018   grade_7 86 1 2 0   4     0   1   47 47                       94.0 86 1 2 0   4     0   1   47 47                 94
738548 738548 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_7 78 1 4 0   9     0   2   45 49                       94 78 1 4 0   9     0   2   45 49                 94
743843 743843 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_7 9 50 23 1   10     0   1   45 49                       94 9 50 23 1   10     0   1   45 49                 94
935335 935335 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2016   grade_7 63 0 17 0   3     0   11   55 39                       94 63 0 17 0   3     0   11   55 39                 94
940462 940462 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_7 40 31 18 1   2     0   2   49 45                       94 40 31 18 1   2     0   2   49 45                 94
1123963 1123963 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2017   grade_7 38 29 6 2   12     0   7   54 40                       94 38 29 6 2   12     0   7   54 40                 94
1126558 1126558 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   grade_7 18 24 28 1   22     0   1   37 57                       94 18 24 28 1   22     0   1   37 57                 94
1130583 1130583 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_7 74 5 9 1   3     0   2   47 47                       94 74 5 9 1   3     0   2   47 47                 94
1366283 1366283 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_7 52 7 18 0   9     0   7   50 43 *                     93.0 52 7 18 0   9     0   7   50 43                 93
2040890 2040890 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_7 3 62 23 2   0     0   3   47 46                       93.0 3 62 23 2   0     0   3   47 46                 93
2041031 2041031 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   grade_7 3 20 22 0   45     0   3   48 45                       93.0 3 20 22 0   45     0   3   48 45                 93
2048732 2048732 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2019   grade_7 83 1 4 0   2     0   3   48 45                       93.0 83 1 4 0   2     0   3   48 45                 93
2238421 2238421 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2018   grade_7 7 64 14 0   4     0   4   52 41                       93.0 7 64 14 0   4     0   4   52 41                 93
736072 736072 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2015   grade_7 87 2 3 0   0     0   1   45 48                       93 87 2 3 0   0     0   1   45 48                 93
737972 737972 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_7 40 14 32 0   5     1   1   50 43                       93 40 14 32 0   5     1   1   50 43                 93
740032 740032 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_7 88 0 2 0   0     1   2   43 50                       93 88 0 2 0   0     1   2   43 50                 93
743665 743665 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes 1 KG 08 2015   grade_7 10 0 80 0   0     0   3   42 51                       93 10 0 80 0   0     0   3   42 51                 93
744217 744217 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2015   grade_7 85 1 3 0   3     0   1   47 46                       93 85 1 3 0   3     0   1   47 46                 93
932941 932941 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_7 88 1 1 0   1     0   2   42 51                       93 88 1 1 0   1     0   2   42 51                 93
935796 935796 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2016   grade_7 1 1 90 0   1     0   0   45 48                       93 1 1 90 0   1     0   0   45 48                 93

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