enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,371 ✖
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
1133179 1133179 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_7 4 92 8 0   0     0   0   59 45                       104 4 92 8 0   0     0   0   59 45                 104
1365897 1365897 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_7 1 43 58 0   2     0   0   55 49 *                     104.0 1 43 58 0   2     0   0   55 49                 104
1673700 1673700 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge - Cambridge Street Upper School   Regular School No Middle 06 08 2021   grade_7 41 27 17 1   7     0   11   62 41 *                     104.0 41 27 17 1   7     0   11   62 41                 104
1678243 1678243 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield - The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2021   grade_7 13 24 62 0   2     0   3   53 50 *                     104.0 13 24 62 0   2     0   3   53 50                 104
2236200 2236200 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield: Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2018   grade_7 14 30 52 0   4     1   3   44 60                       104.0 14 30 52 0   4     1   3   44 60                 104
2239264 2239264 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett: Narragansett Middle   Regular School No Middle 05 08 2018   grade_7 95 0 7 0   0     0   2   55 49                       104.0 95 0 7 0   0     0   2   55 49                 104
736786 736786 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 06 08 2015   grade_7 3 55 43 0   0     0   4   63 42                       105 3 55 43 0   0     0   4   63 42                 105
744075 744075 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_7 93 2 7 0   1     1   1   55 50                       105 93 2 7 0   1     1   1   55 50                 105
1127046 1127046 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_7 91 5 5 0   3     0   1   58 47                       105 91 5 5 0   3     0   1   58 47                 105
1129378 1129378 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_7 4 13 87 0   1     0   0   53 52                       105 4 13 87 0   1     0   0   53 52                 105
1131488 1131488 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_7 68 15 5 0   15     0   2   50 55                       105 68 15 5 0   15     0   2   50 55                 105
1365410 1365410 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_7 6 1 97 0   1     0   0   55 50 *                     105.0 6 1 97 0   1     0   0   55 50                 105
1366864 1366864 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_7 96 1 4 0   2     0   2   47 58 *                     105.0 96 1 4 0   2     0   2   47 58                 105
1678304 1678304 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Springfield - Van Sickle Academy   Regular School No Middle 06 08 2021   grade_7 7 8 88 0   1     0   1   55 50 *                     105.0 7 8 88 0   1     0   1   55 50                 105
2041784 2041784 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_7 95 3 3 0   3     0   1   55 50                       105.0 95 3 3 0   3     0   1   55 50                 105
2044909 2044909 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_7 84 1 10 0   4     0   6   49 56                       105.0 84 1 10 0   4     0   6   49 56                 105
2048735 2048735 MA Middlesex   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2019   grade_7 99 0 1 0   1     0   4   48 57                       105.0 99 0 1 0   1     0   4   48 57                 105
2230064 2230064 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_7 7 14 75 0   7     0   2   63 42                       105.0 7 14 75 0   7     0   2   63 42                 105
2231355 2231355 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_7 86 2 12 0   3     0   2   60 45                       105.0 86 2 12 0   3     0   2   60 45                 105
2233863 2233863 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis: Millis Middle   Regular School No Middle 05 08 2018   grade_7 89 1 12 0   0     0   3   53 52                       105.0 89 1 12 0   0     0   3   53 52                 105
934833 934833 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_7 43 13 35 0   12     0   3   58 48                       106 43 13 35 0   12     0   3   58 48                 106
936449 936449 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2016   grade_7 26 25 26 0   23     0   6   53 53                       106 26 25 26 0   23     0   6   53 53                 106
1122439 1122439 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_7 98 1 3 0   2     0   2   54 52                       106 98 1 3 0   2     0   2   54 52                 106
1132118 1132118 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2017   grade_7 94 2 6 0   1     1   2   55 51                       106 94 2 6 0   1     1   2   55 51                 106
1132928 1132928 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2017   grade_7 95 0 8 0   0     0   3   52 54                       106 95 0 8 0   0     0   3   52 54                 106
1371029 1371029 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_7 12 22 65 0   5     0   2   50 56 *                     106.0 12 22 65 0   5     0   2   50 56                 106
1371039 1371039 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2020   grade_7 6 19 77 0   0     0   4   63 43 *                     106.0 6 19 77 0   0     0   4   63 43                 106
1674317 1674317 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_7 11 14 77 0   3     0   1   53 53 *                     106.0 11 14 77 0   3     0   1   53 53                 106
1678291 1678291 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield - Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2021   grade_7 12 23 64 0   4     0   3   53 53 *                     106.0 12 23 64 0   4     0   3   53 53                 106
1679082 1679082 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport - Westport Junior/Senior High School   Regular School No High 07 12 2021   grade_7 98 0 2 0   0     0   6   61 45 *                     106.0 98 0 2 0   0     0   6   61 45                 106
1679960 1679960 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 2021   grade_7 36 36 25 0   5     0   4   53 53 *                     106.0 36 36 25 0   5     0   4   53 53                 106
2049310 2049310 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_7 69 13 16 0   2     0   6   62 44                       106.0 69 13 16 0   2     0   6   62 44                 106
2231489 2231489 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett: Lafayette School   Regular School No Elementary KG 08 2018   grade_7 32 18 50 1   2     0   3   49 57                       106.0 32 18 50 1   2     0   3   49 57                 106
2231498 2231498 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_7 11 10 81 0   4     0   0   58 48                       106.0 11 10 81 0   4     0   0   58 48                 106
2237010 2237010 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater: West Bridgewater Junior/Senior   Regular School No High 07 12 2018   grade_7 96 5 5 0   0     0   0   61 45                       106.0 96 5 5 0   0     0   0   61 45                 106
743357 743357 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_7 7 9 80 0   8     0   3   49 58                       107 7 9 80 0   8     0   3   49 58                 107
941668 941668 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No 2 05 08 2016   grade_7 95 1 8 1   0     0   2   49 58                       107 95 1 8 1   0     0   2   49 58                 107
1131815 1131815 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_7 96 1 6 1   0     0   3   53 54                       107 96 1 6 1   0     0   3   53 54                 107
1371714 1371714 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_7 91 6 5 0   1     0   4   47 60 *                     107.0 91 6 5 0   1     0   4   47 60                 107
1374253 1374253 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_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1677418 1677418 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Quincy - Broad Meadows Middle   Regular School No Middle 06 08 2021   grade_7 62 13 10 0   19     0   3   50 57 *                     107.0 62 13 10 0   19     0   3   50 57                 107
1679753 1679753 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_7 2 74 26 0   1     1   3   57 50 *                     107.0 2 74 26 0   1     1   3   57 50                 107
1680302 1680302 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_7 100 3 2 0   0     0   2   55 52 *                     107.0 100 3 2 0   0     0   2   55 52                 107
2046061 2046061 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2019   grade_7 19 25 57 0   2     0   4   62 45                       107.0 19 25 57 0   2     0   4   62 45                 107
2046592 2046592 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2019   grade_7 94 2 5 0   0     0   6   53 54                       107.0 94 2 5 0   0     0   6   53 54                 107
741949 741949 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_7 28 32 41 0   4     0   3   58 50                       108 28 32 41 0   4     0   3   58 50                 108
934738 934738 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2016   grade_7 91 4 6 0   3     0   4   52 56                       108 91 4 6 0   3     0   4   52 56                 108
936595 936595 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No 2 04 07 2016   grade_7 94 2 7 0   2     0   3   52 56                       108 94 2 7 0   2     0   3   52 56                 108
938755 938755 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_7 24 29 53 1   0     1   0   61 47                       108 24 29 53 1   0     1   0   61 47                 108
941339 941339 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2016   grade_7 86 2 7 0   3     0   10   56 52                       108 86 2 7 0   3     0   10   56 52                 108
1368259 1368259 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2020   grade_7 78 3 7 0   16     1   3   53 55 *                     108.0 78 3 7 0   16     1   3   53 55                 108
1673258 1673258 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_7 2 62 42 0   0     0   2   53 55 *                     108.0 2 62 42 0   0     0   2   53 55                 108
2040935 2040935 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_7 7 18 67 0   13     0   3   64 44                       108.0 7 18 67 0   13     0   3   64 44                 108
2043353 2043353 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_7 85 1 9 0   10     0   3   50 58                       108.0 85 1 9 0   10     0   3   50 58                 108
2047451 2047451 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_7 5 12 78 0   9     0   4   57 51                       108.0 5 12 78 0   9     0   4   57 51                 108
2239342 2239342 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex: Hawthorne Brook   Regular School No Middle 05 08 2018   grade_7 105 0 1 0   0     0   2   46 62                       108.0 105 0 1 0   0     0   2   46 62                 108
2239999 2239999 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_7 1 95 10 0   0     0   2   51 57                       108.0 1 95 10 0   0     0   2   51 57                 108
1368019 1368019 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_7 2 0 106 0   0     0   1   58 51 *                     109.0 2 0 106 0   0     0   1   58 51                 109
1372378 1372378 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_7 8 12 74 1   10     0   4   54 55 *                     109.0 8 12 74 1   10     0   4   54 55                 109
1672413 1672413 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 0 0   0     0   5   56 53 *                     109.0 104 0 0 0   0     0   5   56 53                 109
1675289 1675289 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence - UP Academy Leonard Middle School   Regular School No Middle 06 08 2021   grade_7 4 0 105 0   0     0   0   51 58 *                     109.0 4 0 105 0   0     0   0   51 58                 109
1675504 1675504 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow - Glenbrook Middle   Regular School No Middle 06 08 2021   grade_7 80 5 7 0   15     0   2   62 47 *                     109.0 80 5 7 0   15     0   2   62 47                 109
1675534 1675534 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell - Rogers STEM Academy   Regular School No Elementary KG 08 2021   grade_7 23 11 45 0   27     0   3   62 47 *                     109.0 23 11 45 0   27     0   3   62 47                 109
1681257 1681257 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett - Central Tree Middle   Regular School No Middle 06 08 2021   grade_7 89 3 9 0   3     0   5   55 54 *                     109.0 89 3 9 0   3     0   5   55 54                 109
1681475 1681475 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_7 49 15 40 0   3     0   2   53 56 *                     109.0 49 15 40 0   3     0   2   53 56                 109
2236150 2236150 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_7 24 22 62 0   1     0   0   55 54                       109.0 24 22 62 0   1     0   0   55 54                 109
2238454 2238454 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_7 85 7 11 0   3     0   3   56 53                       109.0 85 7 11 0   3     0   3   56 53                 109
2238514 2238514 MA Hampden   school 2500522 499   Hampden Charter School of Science East (District) 250052202680 4990305 Hampden Charter School of Science East (District): Hampden Charter School of Science East   Regular School Yes High 06 12 2018   grade_7 40 29 36 0   1     0   3   52 57                       109.0 40 29 36 0   1     0   3   52 57                 109
736958 736958 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_7 0 5 5 0   1     0   0   5 6                       11 0 5 5 0   1     0   0   5 6                 11
738211 738211 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_7 8 2 0 0   0     0   1   7 4                       11 8 2 0 0   0     0   1   7 4                 11
934968 934968 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2016   grade_7 3 4 4 0   0     0   0   5 6                       11 3 4 4 0   0     0   0   5 6                 11
1124927 1124927 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
1126503 1126503 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_7 3 0 7 0   0     0   1   9 2                       11 3 0 7 0   0     0   1   9 2                 11
1129370 1129370 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2017   grade_7 1 2 8 0   0     0   0   7 4                       11 1 2 8 0   0     0   0   7 4                 11
1367198 1367198 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_7 2 2 5 0   0     0   2   9 2 *                     11.0 2 2 5 0   0     0   2   9 2                 11
1675306 1675306 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_7 0 0 11 0   0     0   0   10 1 *                     11.0 0 0 11 0   0     0   0   10 1                 11
2043147 2043147 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_7 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2232700 2232700 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_7 2 0 9 0   0     0   0   10 1                       11.0 2 0 9 0   0     0   0   10 1                 11
737996 737996 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_7 50 22 30 0   7     0   1   51 59                       110 50 22 30 0   7     0   1   51 59                 110
739215 739215 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2015   grade_7 88 1 5 0   12     0   4   50 60                       110 88 1 5 0   12     0   4   50 60                 110
934370 934370 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2016   grade_7 6 8 93 0   2     0   1   64 46                       110 6 8 93 0   2     0   1   64 46                 110
1123259 1123259 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2017   grade_7 9 16 75 0   7     0   3   58 52                       110 9 16 75 0   7     0   3   58 52                 110
1124894 1124894 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_7 38 6 49 0   7     0   10   62 48                       110 38 6 49 0   7     0   10   62 48                 110
1129331 1129331 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_7 28 27 54 0   1     0   0   57 53                       110 28 27 54 0   1     0   0   57 53                 110
1372919 1372919 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_7 83 3 17 0   0     0   7   48 62 *                     110.0 83 3 17 0   0     0   7   48 62                 110
1677079 1677079 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer - Palmer High   Regular School No High 06 12 2021   grade_7 93 1 9 0   2     0   5   68 42 *                     110.0 93 1 9 0   2     0   5   68 42                 110
1680184 1680184 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_7 91 1 16 0   2     0   0   52 58 *                     110.0 91 1 16 0   2     0   0   52 58                 110
2042841 2042841 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_7 64 18 15 0   5     0   8   62 48                       110.0 64 18 15 0   5     0   8   62 48                 110
2047991 2047991 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_7 87 5 14 0   2     0   2   53 57                       110.0 87 5 14 0   2     0   2   53 57                 110
2048335 2048335 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_7 99 2 4 0   1     0   4   62 48                       110.0 99 2 4 0   1     0   4   62 48                 110
735681 735681 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_7 108 1 1 0   1     0   0   55 56                       111 108 1 1 0   1     0   0   55 56                 111
744968 744968 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2015   grade_7 103 0 4 0   4     0   0   61 50                       111 103 0 4 0   4     0   0   61 50                 111
936830 936830 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2016   grade_7 100 0 2 0   5     1   3   74 37                       111 100 0 2 0   5     1   3   74 37                 111
939270 939270 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_7 90 4 11 0   0     2   4   64 47                       111 90 4 11 0   0     2   4   64 47                 111
1132439 1132439 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_7 99 2 7 0   0     1   2   60 51                       111 99 2 7 0   0     1   2   60 51                 111
1365529 1365529 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2020   grade_7 8 36 61 1   3     0   2   48 63 *                     111.0 8 36 61 1   3     0   2   48 63                 111
1366962 1366962 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_7 85 1 17 1   6     0   1   53 58 *                     111.0 85 1 17 1   6     0   1   53 58                 111
1368092 1368092 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_7 83 7 13 0   3     0   5   62 49 *                     111.0 83 7 13 0   3     0   5   62 49                 111
2042149 2042149 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_7 22 22 54 1   6     0   6   50 61                       111.0 22 22 54 1   6     0   6   50 61                 111
2043866 2043866 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_7 89 4 2 6   3     0   7   66 45                       111.0 89 4 2 6   3     0   7   66 45                 111

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