Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_8 · 3,459
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
1366475 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2020   grade_8 43 26 11 0   11     0   8   41 58 *                     99.0 43 26 11 0   11     0   8   41 58                 99
1374037 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2020   grade_8 88 1 6 0   0     0   4   56 43 *                     99.0 88 1 6 0   0     0   4   56 43                 99
1675884 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_8 24 13 19 0   40     0   3   56 43 *                     99.0 24 13 19 0   40     0   3   56 43                 99
2041934 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2019   grade_8 90 1 5 0   1     0   2   48 51                       99.0 90 1 5 0   1     0   2   48 51                 99
2046091 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_8 10 16 70 0   3     0   0   64 35                       99.0 10 16 70 0   3     0   0   64 35                 99
2230065 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_8 7 13 71 0   5     0   3   48 51                       99.0 7 13 71 0   5     0   3   48 51                 99
2233380 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden: Ferryway   Regular School No Elementary KG 08 2018   grade_8 20 27 28 1   21     0   2   39 60                       99.0 20 27 28 1   21     0   2   39 60                 99
2239297 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba: Florence Sawyer School   Regular School No Elementary PK 08 2018   grade_8 90 0 3 0   3     0   3   41 58                       99.0 90 0 3 0   3     0   3   41 58                 99
741127 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2015   grade_8 57 7 8 0   21     1   5   50 49                       99 57 7 8 0   21     1   5   50 49                 99
741976 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2015   grade_8 14 29 50 0   3     0   3   61 38                       99 14 29 50 0   3     0   3   61 38                 99
744040 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_8 89 1 5 0   0     0   4   53 46                       99 89 1 5 0   0     0   4   53 46                 99
940704 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_8 78 6 9 0   1     0   5   35 64                       99 78 6 9 0   1     0   5   35 64                 99
1122440 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_8 93 1 1 0   1     0   3   44 55                       99 93 1 1 0   1     0   3   44 55                 99
1123622 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_8 23 57 15 0   0     1   3   49 50                       99 23 57 15 0   0     1   3   49 50                 99
1129332 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_8 22 25 51 0   0     1   0   59 40                       99 22 25 51 0   0     1   0   59 40                 99
1131621 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_8 86 4 5 0   3     0   1   48 51                       99 86 4 5 0   3     0   1   48 51                 99
1371030 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_8 14 19 62 0   3     0   0   45 53 *                     98.0 14 19 62 0   3     0   0   45 53                 98
1374236 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_8 65 12 14 0   2     0   5   56 42 *                     98.0 65 12 14 0   2     0   5   56 42                 98
1672635 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_8 5 1 91 0   1     0   0   52 46 *                     98.0 5 1 91 0   1     0   0   52 46                 98
2041548 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No Middle 06 08 2019   grade_8 47 22 6 0   17     1   5   44 54                       98.0 47 22 6 0   17     1   5   44 54                 98
2233921 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Monson: Granite Valley Middle   Regular School No Middle 05 08 2018   grade_8 91 1 1 0   0     2   3   54 44                       98.0 91 1 1 0   0     2   3   54 44                 98
736563 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_8 7 45 46 0   0     0   0   56 42                       98 7 45 46 0   0     0   0   56 42                 98
737997 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_8 44 19 30 0   5     0   0   52 46                       98 44 19 30 0   5     0   0   52 46                 98
739568 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2015   grade_8 43 17 8 1   25     0   4   51 47                       98 43 17 8 1   25     0   4   51 47                 98
740033 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_8 93 0 1 0   1     0   3   54 44                       98 93 0 1 0   1     0   3   54 44                 98
740452 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_8 77 4 11 0   0     0   6   41 57                       98 77 4 11 0   0     0   6   41 57                 98
743358 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_8 8 15 67 0   6     0   2   35 63                       98 8 15 67 0   6     0   2   35 63                 98
937287 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2016   grade_8 84 6 5 0   0     0   3   55 43                       98 84 6 5 0   0     0   3   55 43                 98
941813 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2016   grade_8 88 3 6 0   1     0   0   55 43                       98 88 3 6 0   1     0   0   55 43                 98
1132472 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2017   grade_8 93 1 1 0   2     0   1   46 52                       98 93 1 1 0   2     0   1   46 52                 98
1366715 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_8 86 3 3 0   3     0   2   47 50 *                     97.0 86 3 3 0   3     0   2   47 50                 97
1366963 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_8 78 0 11 0   6     0   2   39 58 *                     97.0 78 0 11 0   6     0   2   39 58                 97
1373145 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2020   grade_8 84 2 3 0   5     0   3   55 42 *                     97.0 84 2 3 0   5     0   3   55 42                 97
1673710 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge - Vassal Lane Upper School   Regular School No Middle 06 08 2021   grade_8 43 27 4 0   17     0   6   50 46 *                     97.0 43 27 4 0   17     0   6   50 46                 97
1675105 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke - Holyoke STEM Academy   Regular School No Middle 06 08 2021   grade_8 10 5 78 0   2     0   2   54 43 *                     97.0 10 5 78 0   2     0   2   54 43                 97
1676072 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard - Fowler School   Regular School No Middle 04 08 2021   grade_8 74 3 15 0   2     0   3   55 41 *                     97.0 74 3 15 0   2     0   3   55 41                 97
1678292 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield - Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2021   grade_8 9 22 59 0   5     0   2   43 54 *                     97.0 9 22 59 0   5     0   2   43 54                 97
2040939 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2019   grade_8 2 43 48 2   2     0   0   51 46                       97.0 2 43 48 2   2     0   0   51 46                 97
2043066 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_8 6 0 88 0   3     0   0   46 51                       97.0 6 0 88 0   3     0   0   46 51                 97
2232169 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_8 72 2 5 0   17     0   1   43 54                       97.0 72 2 5 0   17     0   1   43 54                 97
2236182 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield: STEM Middle Academy   Regular School No Middle 06 08 2018   grade_8 13 26 56 0   2     0   0   61 36                       97.0 13 26 56 0   2     0   0   61 36                 97
743844 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_8 9 56 19 0   8     0   5   47 50                       97 9 56 19 0   8     0   5   47 50                 97
1131489 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_8 57 11 4 0   23     0   2   50 47                       97 57 11 4 0   23     0   2   50 47                 97
1367470 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_8 91 2 3 0   0     0   0   50 46 *                     96.0 91 2 3 0   0     0   0   50 46                 96
1372491 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_8 2 57 32 0   0     0   5   48 48 *                     96.0 2 57 32 0   0     0   5   48 48                 96
1672414 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_8 88 1 5 0   0     0   2   48 48 *                     96.0 88 1 5 0   0     0   2   48 48                 96
1675006 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   grade_8 46 18 14 0   7     0   11   39 56 *                     96.0 46 18 14 0   7     0   11   39 56                 96
1678244 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_8 18 20 58 0   0     0   0   36 60 *                     96.0 18 20 58 0   0     0   0   36 60                 96
2049088 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2019   grade_8 82 1 8 0   2     0   3   48 48                       96.0 82 1 8 0   2     0   3   48 48                 96
2238308 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 2018   grade_8 2 39 50 1   1     0   3   48 48                       96.0 2 39 50 1   1     0   3   48 48                 96
2239577 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield: Knox Trail Middle School   Regular School No Middle 05 08 2018   grade_8 82 0 9 0   1     0   4   53 43                       96.0 82 0 9 0   1     0   4   53 43                 96
742464 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2015   grade_8 86 1 5 1   1     0   2   50 46                       96 86 1 5 1   1     0   2   50 46                 96
935336 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2016   grade_8 69 2 18 0   2     0   5   57 39                       96 69 2 18 0   2     0   5   57 39                 96
938781 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2016   grade_8 18 25 51 0   2     0   0   50 46                       96 18 25 51 0   2     0   0   50 46                 96
1125853 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_8 4 0 87 0   4     0   1   52 44                       96 4 0 87 0   4     0   1   52 44                 96
1131759 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_8 86 8 0 0   2     0   0   55 41                       96 86 8 0 0   2     0   0   55 41                 96
1372697 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_8 27 39 22 0   3     0   4   57 38 *                     95.0 27 39 22 0   3     0   4   57 38                 95
1374014 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2020   grade_8 88 0 4 0   1     0   2   42 53 *                     95.0 88 0 4 0   1     0   2   42 53                 95
1673704 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge - Putnam Avenue Upper School   Regular School No Middle 06 08 2021   grade_8 28 34 12 0   12     1   8   38 56 *                     95.0 28 34 12 0   12     1   8   38 56                 95
1678286 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield - Chestnut Academy   Regular School No Middle 06 08 2021   grade_8 2 9 83 0   1     0   0   49 46 *                     95.0 2 9 83 0   1     0   0   49 46                 95
1679961 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_8 47 34 10 0   0     0   4   47 48 *                     95.0 47 34 10 0   0     0   4   47 48                 95
1680303 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Regional - Hoosac Valley High School   Regular School No High 08 12 2021   grade_8 83 6 4 0   0     0   2   48 47 *                     95.0 83 6 4 0   0     0   2   48 47                 95
1680539 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth - Dighton Middle School   Regular School No Middle 05 08 2021   grade_8 82 1 7 0   0     0   5   48 47 *                     95.0 82 1 7 0   0     0   5   48 47                 95
2040218 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_8 89 0 0 0   0     0   6   48 47                       95.0 89 0 0 0   0     0   6   48 47                 95
2041545 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2019   grade_8 43 31 7 0   7     1   6   43 52                       95.0 43 31 7 0   7     1   6   43 52                 95
2042134 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_8 27 19 42 0   6     0   1   52 43                       95.0 27 19 42 0   6     0   1   52 43                 95
2046105 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2019   grade_8 11 28 47 1   4     1   3   38 57                       95.0 11 28 47 1   4     1   3   38 57                 95
2047866 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_8 0 42 50 0   1     0   2   50 45                       95.0 0 42 50 0   1     0   2   50 45                 95
2048023 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2019   grade_8 47 10 30 0   1     0   7   52 43                       95.0 47 10 30 0   1     0   7   52 43                 95
2230069 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston: Washington Irving Middle   Regular School No Middle 06 08 2018   grade_8 3 43 45 2   0     0   2   45 50                       95.0 3 43 45 2   0     0   2   45 50                 95
2237412 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon: Murdock Middle School   Regular School No Middle 06 08 2018   grade_8 76 4 9 1   3     0   2   50 45                       95.0 76 4 9 1   3     0   2   50 45                 95
2237850 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_8 7 9 69 0   9     0   1   46 49                       95.0 7 9 69 0   9     0   1   46 49                 95
738790 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_8 87 0 2 4   0     0   2   45 50                       95 87 0 2 4   0     0   2   45 50                 95
741991 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2015   grade_8 16 16 45 0   11     1   6   54 41                       95 16 16 45 0   11     1   6   54 41                 95
743501 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_8 7 27 57 0   2     0   2   42 53                       95 7 27 57 0   2     0   2   42 53                 95
744553 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No 3 07 12 2015   grade_8 86 1 4 0   0     0   4   50 45                       95 86 1 4 0   0     0   4   50 45                 95
934260 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2016   grade_8 40 24 10 1   14     0   6   45 50                       95 40 24 10 1   14     0   6   45 50                 95
937945 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2016   grade_8 63 9 2 0   16     1   4   49 46                       95 63 9 2 0   16     1   4   49 46                 95
1365192 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_8 87 2 4 0   0     0   1   50 44 *                     94.0 87 2 4 0   0     0   1   50 44                 94
1365663 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_8 2 52 38 1   0     0   1   45 49 *                     94.0 2 52 38 1   0     0   1   45 49                 94
1368670 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2020   grade_8 41 17 15 1   17     0   3   48 45 *                     94.0 41 17 15 1   17     0   3   48 45                 94
1372794 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_8 1 33 59 0   0     0   1   46 48 *                     94.0 1 33 59 0   0     0   1   46 48                 94
1676300 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis - Millis Middle   Regular School No Middle 06 08 2021   grade_8 77 2 7 0   0     0   8   45 48 *                     94.0 77 2 7 0   0     0   8   45 48                 94
1680155 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 2021   grade_8 14 50 19 0   7     0   4   51 43 *                     94.0 14 50 19 0   7     0   4   51 43                 94
1681497 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School (District) - Libertas Academy Charter School   Regular School Yes Middle 06 08 2021   grade_8 2 23 67 0   1     0   1   49 45 *                     94.0 2 23 67 0   1     0   1   49 45                 94
2043718 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_8 17 20 32 0   19     0   6   46 48                       94.0 17 20 32 0   19     0   6   46 48                 94
2046593 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2019   grade_8 80 2 6 0   2     0   4   46 48                       94.0 80 2 6 0   2     0   4   46 48                 94
2048161 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_8 84 0 6 0   1     0   3   48 46                       94.0 84 0 6 0   1     0   3   48 46                 94
2230775 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge: Putnam Avenue Upper School   Regular School No Middle 06 08 2018   grade_8 23 33 19 1   9     1   8   48 46                       94.0 23 33 19 1   9     1   8   48 46                 94
2230779 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Cambridge: Rindge Avenue Upper School   Regular School No Middle 06 08 2018   grade_8 42 26 6 1   12     0   7   52 42                       94.0 42 26 6 1   12     0   7   52 42                 94
2238199 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_8 40 32 21 0   0     0   1   46 48                       94.0 40 32 21 0   0     0   1   46 48                 94
2239718 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   grade_8 86 3 4 0   1     0   0   49 45                       94.0 86 3 4 0   1     0   0   49 45                 94
737400 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2015   grade_8 30 33 9 1   13     1   7   54 40                       94 30 33 9 1   13     1   7   54 40                 94
743640 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_8 53 20 17 0   3     0   1   39 55                       94 53 20 17 0   3     0   1   39 55                 94
1123264 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2017   grade_8 6 39 45 1   1     0   2   61 33                       94 6 39 45 1   1     0   2   61 33                 94
1124672 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_8 24 22 37 0   8     0   3   41 53                       94 24 22 37 0   8     0   3   41 53                 94
1131475 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_8 2 46 44 1   0     0   1   48 46                       94 2 46 44 1   0     0   1   48 46                 94
1132476 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2017   grade_8 84 4 2 0   2     0   2   50 44                       94 84 4 2 0   2     0   2   50 44                 94
1132615 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2017   grade_8 85 2 5 0   1     0   1   55 39                       94 85 2 5 0   1     0   1   55 39                 94
1673134 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston - James P Timilty Middle   Regular School No Middle 06 08 2021   grade_8 1 36 54 0   2     0   0   46 47 *                     93.0 1 36 54 0   2     0   0   46 47                 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]);