enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,737 ✖
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
743611 743611 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_9 24 35 29 0   6     0   2   33 63                       96 24 35 29 0   6     0   2   33 63                 96
940434 940434 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_9 27 39 17 0   6     1   3   56 37                       93 27 39 17 0   6     1   3   56 37                 93
1131335 1131335 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 2017   grade_9 27 41 20 0   5     0   3   48 48                       96 27 41 20 0   5     0   3   48 48                 96
1372668 1372668 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_9 20 50 24 0   3     0   5   53 49 *                     102.0 20 50 24 0   3     0   5   53 49                 102
1679932 1679932 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_9 18 59 16 0   3     0   1   46 51 *                     97.0 18 59 16 0   3     0   1   46 51                 97
2047739 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
2238167 2238167 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_9 16 47 29 1   6     0   2   44 57                       101.0 16 47 29 1   6     0   2   44 57                 101
735668 735668 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_9 113 1 15 0   0     0   2   61 70                       131 113 1 15 0   0     0   2   61 70                 131
932546 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
1121960 1121960 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_9 106 3 8 1   4     0   2   55 69                       124 106 3 8 1   4     0   2   55 69                 124
1364794 1364794 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_9 125 7 20 0   6     0   2   75 85 *                     160.0 125 7 20 0   6     0   2   75 85                 160
1672018 1672018 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_9 122 5 16 0   3     0   0   88 58 *                     146.0 122 5 16 0   3     0   0   88 58                 146
2039820 2039820 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_9 134 8 12 0   4     0   1   82 77                       159.0 134 8 12 0   4     0   1   82 77                 159
2228768 2228768 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_9 126 7 17 1   1     0   1   81 72                       153.0 126 7 17 1   1     0   1   81 72                 153
743430 743430 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2015   grade_9 6 33 12 0   0     0   1   22 30                       52 6 33 12 0   0     0   1   22 30                 52
940251 940251 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2016   grade_9 7 37 16 0   1     1   5   36 31                       67 7 37 16 0   1     1   5   36 31                 67
1131129 1131129 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_9 5 45 11 0   1     0   2   35 29                       64 5 45 11 0   1     0   2   35 29                 64
1372472 1372472 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_9 3 41 22 0   0     0   4   39 31 *                     70.0 3 41 22 0   0     0   4   39 31                 70
1679735 1679735 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_9 5 50 26 0   0     0   1   42 40 *                     82.0 5 50 26 0   0     0   1   42 40                 82
2047545 2047545 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_9 10 43 17 0   1     0   0   37 34                       71.0 10 43 17 0   1     0   0   37 34                 71
2237956 2237956 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   grade_9 3 46 19 0   1     0   0   37 32                       69.0 3 46 19 0   1     0   0   37 32                 69
743967 743967 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_9 294 7 13 2   115     0   26   229 228                       457 294 7 13 2   115     0   26   229 228                 457
940800 940800 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2016   grade_9 298 5 15 0   154     0   16   260 228                       488 298 5 15 0   154     0   16   260 228                 488
1131737 1131737 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_9 270 9 12 1   138     0   18   224 224                       448 270 9 12 1   138     0   18   224 224                 448
1373025 1373025 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2020   grade_9 256 16 19 1   166     0   12   250 220 *                     470.0 256 16 19 1   166     0   12   250 220                 470
1680289 1680289 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough - Acton-Boxborough Regional High   Regular School No High 09 12 2021   grade_9 206 8 27 1   149     0   15   221 185 *                     406.0 206 8 27 1   149     0   15   221 185                 406
2048097 2048097 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_9 246 9 22 0   154     0   29   227 233                       460.0 246 9 22 0   154     0   29   227 233                 460
2238574 2238574 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough: Acton-Boxborough Regional High   Regular School No High 09 12 2018   grade_9 240 9 11 1   145     0   21   225 202                       427.0 240 9 11 1   145     0   21   225 202                 427
743987 743987 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_9 73 4 1 0   0     0   1   38 41                       79 73 4 1 0   0     0   1   38 41                 79
940820 940820 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_9 87 5 4 1   3     0   0   45 55                       100 87 5 4 1   3     0   0   45 55                 100
1131760 1131760 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_9 57 3 3 0   0     0   0   29 34                       63 57 3 3 0   0     0   0   29 34                 63
1373040 1373040 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2020   grade_9 54 2 1 1   1     0   0   31 28 *                     59.0 54 2 1 1   1     0   0   31 28                 59
1680304 1680304 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Regional - Hoosac Valley High School   Regular School No High 08 12 2021   grade_9 57 1 4 2   0     0   0   33 31 *                     64.0 57 1 4 2   0     0   0   33 31                 64
2048112 2048112 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_9 71 6 2 0   0     0   2   46 35                       81.0 71 6 2 0   0     0   2   46 35                 81
2238591 2238591 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Adams-Cheshire: Hoosac Valley High School   Regular School No High 08 12 2018   grade_9 44 5 1 0   2     0   0   27 25                       52.0 44 5 1 0   2     0   0   27 25                 52
743509 743509 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_9 79 3 6 0   22     0   6   66 50                       116 79 3 6 0   22     0   6   66 50                 116
940329 940329 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2016   grade_9 93 4 2 1   24     0   11   61 74                       135 93 4 2 1   24     0   11   61 74                 135
1131225 1131225 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_9 97 5 5 1   26     0   8   84 58                       142 97 5 5 1   26     0   8   84 58                 142
1372563 1372563 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2020   grade_9 99 7 15 0   23     0   13   82 75 *                     157.0 99 7 15 0   23     0   13   82 75                 157
1679826 1679826 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_9 105 0 10 0   20     0   11   80 65 *                     146.0 105 0 10 0   20     0   11   80 65                 146
2047636 2047636 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_9 102 2 12 0   31     0   9   75 81                       156.0 102 2 12 0   31     0   9   75 81                 156
2238055 2238055 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   grade_9 99 1 10 0   43     0   5   79 79                       158.0 99 1 10 0   43     0   5   79 79                 158
735710 735710 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_9 281 6 15 0   7     1   7   172 145                       317 281 6 15 0   7     1   7   172 145                 317
932588 932588 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2016   grade_9 278 6 23 0   6     0   6   168 151                       319 278 6 23 0   6     0   6   168 151                 319
1122011 1122011 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_9 272 3 14 0   6     0   4   151 148                       299 272 3 14 0   6     0   4   151 148                 299
1364834 1364834 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_9 247 4 28 0   10     0   8   160 137 *                     297.0 247 4 28 0   10     0   8   160 137                 297
1672058 1672058 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_9 231 6 23 0   12     0   9   155 126 *                     281.0 231 6 23 0   12     0   9   155 126                 281
2039860 2039860 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_9 219 7 21 1   6     0   11   136 129                       265.0 219 7 21 1   6     0   11   136 129                 265
2228817 2228817 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   grade_9 282 5 21 0   1     0   9   159 159                       318.0 282 5 21 0   1     0   9   159 159                 318
735730 735730 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_9 147 0 8 0   1     0   4   91 69                       160 147 0 8 0   1     0   4   91 69                 160
932608 932608 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2016   grade_9 127 3 9 0   2     0   5   81 65                       146 127 3 9 0   2     0   5   81 65                 146
1122035 1122035 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_9 134 2 5 0   2     0   4   74 73                       147 134 2 5 0   2     0   4   74 73                 147
1122040 1122040 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_9 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1364854 1364854 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_9 101 2 8 0   0     0   7   63 55 *                     118.0 101 2 8 0   0     0   7   63 55                 118
1364859 1364859 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_9 7 0 1 0   0     0   0   4 4 *                     8.0 7 0 1 0   0     0   0   4 4                 8
1672078 1672078 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_9 105 6 16 0   1     0   4   61 71 *                     132.0 105 6 16 0   1     0   4   61 71                 132
2039881 2039881 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_9 119 2 6 0   2     0   5   68 66                       134.0 119 2 6 0   2     0   5   68 66                 134
2039886 2039886 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_9 9 0 2 0   0     0   1   8 4                       12.0 9 0 2 0   0     0   1   8 4                 12
2228841 2228841 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury: Amesbury High   Regular School No High 09 12 2018   grade_9 124 5 15 1   2     0   9   82 74                       156.0 124 5 15 1   2     0   9   82 74                 156
2228846 2228846 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   grade_9 8 0 0 0   0     0   1   5 4                       9.0 8 0 0 0   0     0   1   5 4                 9
743447 743447 MA Essex   school 2500069 415   Amesbury Academy Charter Public (District) 250006901666 4150505 Amesbury Academy Charter Public School   Regular School Yes 3 09 12 2015   grade_9 8 0 0 0   0     0   1   6 3                       9 8 0 0 0   0     0   1   6 3                 9
743993 743993 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   grade_9 150 15 32 0   24     0   23   139 105                       244 150 15 32 0   24     0   23   139 105                 244
940827 940827 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2016   grade_9 137 13 35 0   21     0   16   111 111                       222 137 13 35 0   21     0   16   111 111                 222
1131768 1131768 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2017   grade_9 140 15 36 1   20     0   22   115 119                       234 140 15 36 1   20     0   22   115 119                 234
1373046 1373046 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2020   grade_9 104 20 35 0   23     0   23   110 95 *                     205.0 104 20 35 0   23     0   23   110 95                 205
1680310 1680310 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_9 120 20 42 0   11     0   19   108 103 *                     212.0 120 20 42 0   11     0   19   108 103                 212
2048119 2048119 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   grade_9 150 16 29 0   20     1   15   112 119                       231.0 150 16 29 0   20     1   15   112 119                 231
2238599 2238599 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham: Amherst Regional High   Regular School No High 09 12 2018   grade_9 131 16 46 0   19     1   28   114 127                       241.0 131 16 46 0   19     1   28   114 127                 241
735801 735801 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_9 321 7 23 0   61     0   8   199 221                       420 321 7 23 0   61     0   8   199 221                 420
932677 932677 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_9 367 9 17 0   66     0   12   209 262                       471 367 9 17 0   66     0   12   209 262                 471
1122119 1122119 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2017   grade_9 335 8 26 1   67     0   9   225 221                       446 335 8 26 1   67     0   9   225 221                 446
1364925 1364925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_9 321 8 27 3   84     0   12   208 247 *                     455.0 321 8 27 3   84     0   12   208 247                 455
1672148 1672148 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_9 285 19 42 0   78     0   13   209 226 *                     437.0 285 19 42 0   78     0   13   209 226                 437
2039952 2039952 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_9 293 8 32 1   84     0   8   206 219                       426.0 293 8 32 1   84     0   8   206 219                 426
2228925 2228925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_9 333 10 21 0   98     0   10   209 262                       472.0 333 10 21 0   98     0   10   209 262                 472
1374237 1374237 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_9 49 14 24 1   2     0   3   54 39 *                     93.0 49 14 24 1   2     0   3   54 39                 93
1681477 1681477 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_9 34 10 14 1   1     0   5   42 23 *                     65.0 34 10 14 1   1     0   5   42 23                 65
2049312 2049312 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_9 68 14 23 0   2     0   7   59 55                       114.0 68 14 23 0   2     0   7   59 55                 114
2239984 2239984 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   grade_9 42 17 25 0   1     0   5   49 41                       90.0 42 17 25 0   1     0   5   49 41                 90
735852 735852 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2015   grade_9 249 16 15 0   20     0   6   153 153                       306 249 16 15 0   20     0   6   153 153                 306
932728 932728 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2016   grade_9 241 17 21 0   41     0   24   154 190                       344 241 17 21 0   41     0   24   154 190                 344
1122179 1122179 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_9 252 15 20 0   35     1   9   175 157                       332 252 15 20 0   35     1   9   175 157                 332
1364976 1364976 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_9 272 17 20 0   36     0   23   162 205 *                     368.0 272 17 20 0   36     0   23   162 205                 368
1672199 1672199 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_9 271 9 23 0   41     1   18   161 201 *                     363.0 271 9 23 0   41     1   18   161 201                 363
2040003 2040003 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_9 270 15 18 0   39     0   22   175 189                       364.0 270 15 18 0   39     0   22   175 189                 364
2228985 2228985 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   grade_9 261 16 23 0   36     0   14   168 182                       350.0 261 16 23 0   36     0   14   168 182                 350
744014 744014 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No 3 09 12 2015   grade_9 182 2 3 0   1     0   3   97 94                       191 182 2 3 0   1     0   3   97 94                 191
940848 940848 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No 3 09 12 2016   grade_9 155 0 3 0   2     0   3   77 86                       163 155 0 3 0   2     0   3   77 86                 163
1131793 1131793 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2017   grade_9 166 1 2 0   2     0   1   85 87                       172 166 1 2 0   2     0   1   85 87                 172
1373067 1373067 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2020   grade_9 160 0 5 0   2     0   4   83 88 *                     171.0 160 0 5 0   2     0   4   83 88                 171
1680331 1680331 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Ashburnham-Westminster - Oakmont Regional High School   Regular School No High 09 12 2021   grade_9 146 4 12 1   2     0   1   90 76 *                     166.0 146 4 12 1   2     0   1   90 76                 166
2048140 2048140 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2019   grade_9 134 1 6 0   1     0   3   81 64                       145.0 134 1 6 0   1     0   3   81 64                 145
2238624 2238624 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Ashburnham-Westminster: Oakmont Regional High School   Regular School No High 09 12 2018   grade_9 164 0 7 0   4     0   2   83 94                       177.0 164 0 7 0   4     0   2   83 94                 177
735866 735866 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_9 138 3 9 1   17     0   6   91 83                       174 138 3 9 1   17     0   6   91 83                 174
932742 932742 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2016   grade_9 143 3 12 0   14     0   4   84 92                       176 143 3 12 0   14     0   4   84 92                 176
1122198 1122198 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2017   grade_9 142 5 27 1   24     0   3   98 104                       202 142 5 27 1   24     0   3   98 104                 202
1364990 1364990 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_9 121 4 22 2   29     0   2   89 91 *                     180.0 121 4 22 2   29     0   2   89 91                 180
1672213 1672213 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland - Ashland High   Regular School No High 09 12 2021   grade_9 128 3 25 2   31     0   6   97 98 *                     195.0 128 3 25 2   31     0   6   97 98                 195
2040017 2040017 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_9 156 7 24 1   28     0   8   103 121                       224.0 156 7 24 1   28     0   8   103 121                 224
2229004 2229004 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_9 151 4 23 0   19     0   9   99 106                       206.0 151 4 23 0   19     0   9   99 106                 206

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