Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by total

View and edit SQL

year

grade

  • grade_9 · 2,637
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
2046790 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_9 96 4 3 0   1     0   0   53 51                       104.0 96 4 3 0   1     0   0   53 51                 104
2047656 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_9 71 12 6 0   8     0   7   43 61                       104.0 71 12 6 0   8     0   7   43 61                 104
2232170 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_9 83 3 3 0   12     0   3   54 50                       104.0 83 3 3 0   12     0   3   54 50                 104
1673474 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_9 187 617 165 1   24     2   48   589 455 *                     1044.0 187 617 165 1   24     2   48   589 455                 1044
739197 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2015   grade_9 93 3 2 0   3     1   3   52 53                       105 93 3 2 0   3     1   3   52 53                 105
744849 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2015   grade_9 86 2 12 0   2     0   3   50 55                       105 86 2 12 0   2     0   3   50 55                 105
935400 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_9 84 4 4 0   12     0   1   55 50                       105 84 4 4 0   12     0   1   55 50                 105
937611 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2016   grade_9 88 3 7 0   5     0   2   45 60                       105 88 3 7 0   5     0   2   45 60                 105
1131383 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2017   grade_9 3 52 48 0   0     0   2   37 68                       105 3 52 48 0   0     0   2   37 68                 105
1365388 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_9 1 60 37 1   1     1   4   53 52 *                     105.0 1 60 37 1   1     1   4   53 52                 105
1371716 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_9 89 9 6 0   0     0   1   53 52 *                     105.0 89 9 6 0   0     0   1   53 52                 105
1678772 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware - Ware Junior/Senior High School   Regular School No High 07 12 2021   grade_9 92 2 5 0   0     1   5   50 55 *                     105.0 92 2 5 0   0     1   5   50 55                 105
2043326 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2019   grade_9 91 1 1 0   9     0   3   50 55                       105.0 91 1 1 0   9     0   3   50 55                 105
2047782 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Man   Regular School Yes High 09 12 2019   grade_9 3 39 58 1   2     0   2   37 68                       105.0 3 39 58 1   2     0   2   37 68                 105
737886 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No 3 09 12 2015   grade_9 87 5 8 0   6     0   0   52 54                       106 87 5 8 0   6     0   0   52 54                 106
939601 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport Senior High School   Regular School No 3 08 12 2016   grade_9 95 1 3 0   3     0   4   55 51                       106 95 1 3 0   3     0   4   55 51                 106
1124423 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_9 96 0 3 0   3     1   3   47 59                       106 96 0 3 0   3     1   3   47 59                 106
1131026 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2017   grade_9 5 6 81 0   11     0   3   54 52                       106 5 6 81 0   11     0   3   54 52                 106
1131490 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_9 65 16 5 2   14     0   4   39 67                       106 65 16 5 2   14     0   4   39 67                 106
1132668 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2017   grade_9 89 4 7 0   1     0   5   58 48                       106 89 4 7 0   1     0   5   58 48                 106
1366964 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No High 09 12 2020   grade_9 84 3 13 0   3     0   3   59 47 *                     106.0 84 3 13 0   3     0   3   59 47                 106
1372711 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2020   grade_9 3 39 64 0   0     0   0   34 72 *                     106.0 3 39 64 0   0     0   0   34 72                 106
1673179 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Boston - Fenway High School   Alternative School No High 09 12 2021   grade_9 4 27 68 0   2     0   5   52 54 *                     106.0 4 27 68 0   2     0   5   52 54                 106
1673763 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_9 99 1 3 0   0     0   3   66 40 *                     106.0 99 1 3 0   0     0   3   66 40                 106
2047752 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_9 31 63 5 0   5     0   2   50 56                       106.0 31 63 5 0   5     0   2   50 56                 106
2236595 MA Middlesex   school 2511760 301   Tyngsborough 251176001934 3010505 Tyngsborough: Tyngsborough High School   Regular School No High 09 12 2018   grade_9 92 2 3 1   3     0   5   47 59                       106.0 92 2 3 1   3     0   5   47 59                 106
2238674 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District: Ayer Shirley Regional High School   Regular School No High 09 12 2018   grade_9 71 5 13 2   2     0   13   47 59                       106.0 71 5 13 2   2     0   13   47 59                 106
2239095 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire: Hampshire Regional High   Regular School No High 07 12 2018   grade_9 101 1 2 0   1     0   1   40 66                       106.0 101 1 2 0   1     0   1   40 66                 106
934641 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2016   grade_9 104 0 2 0   0     0   1   56 51                       107 104 0 2 0   0     0   1   56 51                 107
936375 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2016   grade_9 5 5 92 1   1     0   3   66 41                       107 5 5 92 1   1     0   3   66 41                 107
1123315 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2017   grade_9 3 34 66 0   2     0   2   48 59                       107 3 34 66 0   2     0   2   48 59                 107
1368452 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2020   grade_9 91 1 10 0   2     0   3   61 46 *                     107.0 91 1 10 0   2     0   3   61 46                 107
2238010 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter (District): Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2018   grade_9 6 52 44 0   0     0   5   52 55                       107.0 6 52 44 0   0     0   5   52 55                 107
2238215 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District): Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2018   grade_9 2 42 57 1   0     0   5   45 62                       107.0 2 42 57 1   0     0   5   45 62                 107
2239971 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford (District): City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2018   grade_9 36 14 52 0   2     0   3   50 56                       107.0 36 14 52 0   2     0   3   50 56                 107
739390 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_9 102 1 3 0   1     0   1   50 58                       108 102 1 3 0   1     0   1   50 58                 108
934312 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2016   grade_9 105 1 0 0   0     0   2   60 48                       108 105 1 0 0   0     0   2   60 48                 108
940357 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes 3 09 12 2016   grade_9 2 87 17 0   0     0   2   46 62                       108 2 87 17 0   0     0   2   46 62                 108
1125134 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2017   grade_9 97 0 5 0   1     0   5   47 61                       108 97 0 5 0   1     0   5   47 61                 108
1131843 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2017   grade_9 80 9 11 1   3     0   4   55 53                       108 80 9 11 1   3     0   4   55 53                 108
1371608 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2020   grade_9 56 12 35 0   2     0   3   42 66 *                     108.0 56 12 35 0   2     0   3   42 66                 108
1374038 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No High 09 12 2020   grade_9 96 0 7 0   0     0   5   52 56 *                     108.0 96 0 7 0   0     0   5   52 56                 108
1679847 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_9 59 15 19 0   8     0   7   45 60 *                     108.0 59 15 19 0   8     0   7   45 60                 108
1679905 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_9 22 34 47 0   3     0   2   51 57 *                     108.0 22 34 47 0   3     0   2   51 57                 108
2047618 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_9 3 62 39 0   1     0   3   63 45                       108.0 3 62 39 0   1     0   3   63 45                 108
736979 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_9 98 1 3 0   1     0   6   55 54                       109 98 1 3 0   1     0   6   55 54                 109
743536 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes 3 09 12 2015   grade_9 3 69 35 0   0     0   2   51 58                       109 3 69 35 0   0     0   2   51 58                 109
935899 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2016   grade_9 95 6 4 1   2     1   0   54 55                       109 95 6 4 1   2     1   0   54 55                 109
936043 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2016   grade_9 99 0 1 0   4     1   4   50 59                       109 99 0 1 0   4     1   4   50 59                 109
2046452 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No High 08 12 2019   grade_9 93 3 7 0   2     0   4   57 52                       109.0 93 3 7 0   2     0   4   57 52                 109
2047739 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 2019   grade_9 19 59 25 0   6     0   0   51 58                       109.0 19 59 25 0   6     0   0   51 58                 109
2049328 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_9 1 99 9 0   0     0   0   57 52                       109.0 1 99 9 0   0     0   0   57 52                 109
2236883 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Webster: Bartlett High School   Regular School No High 09 12 2018   grade_9 65 5 28 0   1     0   10   57 52                       109.0 65 5 28 0   1     0   10   57 52                 109
742485 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham Cooperative Junior/Senior High School   Regular School No 3 07 12 2015   grade_9 9 0 2 0   0     0   0   6 5                       11 9 0 2 0   0     0   0   6 5                 11
938486 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2016   grade_9 1 5 3 0   0     0   2   6 5                       11 1 5 3 0   0     0   2   6 5                 11
1368064 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_9 2 0 9 0   0     0   0   10 1 *                     11.0 2 0 9 0   0     0   0   10 1                 11
1673863 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee - Chicopee Academy   Alternative School No High 07 12 2021   grade_9 2 1 7 0   0     0   1   6 5 *                     11.0 2 1 7 0   0     0   1   6 5                 11
1675308 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_9 1 0 10 0   0     0   0   9 2 *                     11.0 1 0 10 0   0     0   0   9 2                 11
1677964 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Somerville - Full Circle High School   Alternative School No High 09 12 2021   grade_9 0 2 9 0   0     0   0   9 2 *                     11.0 0 2 9 0   0     0   0   9 2                 11
1678008 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge - Southbridge Academy   Alternative School No High 07 12 2021   grade_9 5 0 6 0   0     0   0   7 4 *                     11.0 5 0 6 0   0     0   0   7 4                 11
2040957 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_9 0 7 4 0   0     0   0   6 5                       11.0 0 7 4 0   0     0   0   6 5                 11
2042356 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No High 09 12 2019   grade_9 5 1 5 0   0     0   0   5 6                       11.0 5 1 5 0   0     0   0   5 6                 11
2047824 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2019   grade_9 4 0 5 0   2     0   0   5 6                       11.0 4 0 5 0   2     0   0   5 6                 11
932546 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_9 93 6 6 0   0     1   4   51 59                       110 93 6 6 0   0     1   4   51 59                 110
934480 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2016   grade_9 74 3 28 0   5     0   0   53 57                       110 74 3 28 0   5     0   0   53 57                 110
940346 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_9 88 5 8 0   4     0   5   50 60                       110 88 5 8 0   4     0   5   50 60                 110
1372584 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_9 66 8 19 0   8     0   9   59 51 *                     110.0 66 8 19 0   8     0   9   59 51                 110
1374289 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_9 62 5 21 1   7     1   13   53 57 *                     110.0 62 5 21 1   7     1   13   53 57                 110
1677066 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford - Oxford High   Regular School No High 08 12 2021   grade_9 88 0 14 0   3     0   5   57 53 *                     110.0 88 0 14 0   3     0   5   57 53                 110
2048894 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   grade_9 91 3 6 0   2     0   8   50 60                       110.0 91 3 6 0   2     0   8   50 60                 110
2230241 MA Suffolk   school 2502790 35   Boston 250279002729 350658 Boston: West Roxbury Academy   Regular School No High 09 12 2018   grade_9 4 49 53 0   1     1   2   69 41                       110.0 4 49 53 0   1     1   2   69 41                 110
2238077 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_9 77 11 11 0   8     0   3   47 63                       110.0 77 11 11 0   8     0   3   47 63                 110
2238141 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District): Sabis International Charter School   Regular School Yes Other KG 12 2018   grade_9 41 22 36 0   4     0   7   52 58                       110.0 41 22 36 0   4     0   7   52 58                 110
2041311 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_9 174 708 154 3   20     4   45   585 523                       1108.0 174 708 154 3   20     4   45   585 523                 1108
739971 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_9 103 1 3 2   1     0   1   53 58                       111 103 1 3 2   1     0   1   53 58                 111
740767 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No 3 09 12 2015   grade_9 92 1 14 1   0     0   3   56 55                       111 92 1 14 1   0     0   3   56 55                 111
743525 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_9 83 4 8 0   9     0   7   51 60                       111 83 4 8 0   9     0   7   51 60                 111
936817 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2016   grade_9 92 2 11 0   1     0   5   63 48                       111 92 2 11 0   1     0   5   63 48                 111
941282 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_9 109 0 0 0   0     0   2   46 65                       111 109 0 0 0   0     0   2   46 65                 111
1131259 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2017   grade_9 3 70 37 0   0     0   1   61 50                       111 3 70 37 0   0     0   1   61 50                 111
1365940 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2020   grade_9 9 35 63 0   1     0   3   53 58 *                     111.0 9 35 63 0   1     0   3   53 58                 111
1368242 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2020   grade_9 89 0 3 1   11     0   7   56 55 *                     111.0 89 0 3 1   11     0   7   56 55                 111
2041786 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_9 98 3 2 2   4     0   2   55 56                       111.0 98 3 2 2   4     0   2   55 56                 111
2238951 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier: Frontier Regional   Regular School No High 07 12 2018   grade_9 96 2 4 0   5     0   4   53 58                       111.0 96 2 4 0   5     0   4   53 58                 111
742154 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2015   grade_9 98 0 3 2   3     0   6   59 53                       112 98 0 3 2   3     0   6   59 53                 112
743502 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_9 10 28 69 0   2     0   3   61 51                       112 10 28 69 0   2     0   3   61 51                 112
745143 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes 4 09 11 2015   grade_9 6 5 101 0   0     0   0   54 58                       112 6 5 101 0   0     0   0   54 58                 112
939472 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_9 100 4 2 0   3     0   3   49 63                       112 100 4 2 0   3     0   3   49 63                 112
941905 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 109 0 2 0   0     0   1   77 35                       112 109 0 2 0   0     0   1   77 35                 112
1126342 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2017   grade_9 97 5 1 0   6     0   3   55 57                       112 97 5 1 0   6     0   3   55 57                 112
1131893 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2017   grade_9 102 0 7 0   1     0   2   62 50                       112 102 0 7 0   1     0   2   62 50                 112
1675340 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester - Leicester High   Regular School No High 09 12 2021   grade_9 81 6 13 0   8     0   4   66 46 *                     112.0 81 6 13 0   8     0   4   66 46                 112
1680830 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District - Monomoy Regional High School   Regular School No High 08 12 2021   grade_9 88 8 11 0   1     0   4   57 55 *                     112.0 88 8 11 0   1     0   4   57 55                 112
2239202 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District: Monomoy Regional High School   Regular School No High 08 12 2018   grade_9 94 9 4 0   0     0   5   52 60                       112.0 94 9 4 0   0     0   5   52 60                 112
2239554 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District: Southwick Regional School   Regular School No High 07 12 2018   grade_9 101 2 7 0   1     0   1   57 55                       112.0 101 2 7 0   1     0   1   57 55                 112
738383 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2015   grade_9 105 3 1 0   2     0   2   63 50                       113 105 3 1 0   2     0   2   63 50                 113
933844 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_9 99 5 4 0   0     0   5   55 58                       113 99 5 4 0   0     0   5   55 58                 113
935625 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 3 5 104 0   1     0   0   56 57                       113 3 5 104 0   1     0   0   56 57                 113
938964 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2016   grade_9 106 0 2 0   1     0   4   50 63                       113 106 0 2 0   1     0   4   50 63                 113
1123382 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No High 09 12 2017   grade_9 4 56 46 0   3     0   4   73 40                       113 4 56 46 0   3     0   4   73 40                 113

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