enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
743610 743610 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_8 30 42 25 0   7     1   4   68 41                       109 30 42 25 0   7     1   4   68 41                 109
940433 940433 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_8 37 22 45 0   5     0   3   55 57                       112 37 22 45 0   5     0   3   55 57                 112
1131334 1131334 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_8 23 50 32 1   7     0   2   51 64                       115 23 50 32 1   7     0   2   51 64                 115
1372667 1372667 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_8 24 61 16 0   3     1   1   51 55 *                     106.0 24 61 16 0   3     1   1   51 55                 106
1679931 1679931 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_8 19 61 31 0   0     0   0   54 57 *                     111.0 19 61 31 0   0     0   0   54 57                 111
2047738 2047738 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_8 25 61 25 0   3     0   6   64 56                       120.0 25 61 25 0   3     0   6   64 56                 120
2238166 2238166 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_8 23 62 28 0   7     0   0   54 66                       120.0 23 62 28 0   7     0   0   54 66                 120
735667 735667 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2015   grade_8 131 6 7 0   4     1   0   74 75                       149 131 6 7 0   4     1   0   74 75                 149
932545 932545 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2016   grade_8 147 2 7 0   2     0   7   81 84                       165 147 2 7 0   2     0   7   81 84                 165
1121958 1121958 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_8 151 6 11 0   1     0   0   91 78                       169 151 6 11 0   1     0   0   91 78                 169
1364793 1364793 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_8 164 6 14 0   3     0   0   106 81 *                     187.0 164 6 14 0   3     0   0   106 81                 187
1672017 1672017 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_8 136 5 18 1   3     0   6   82 87 *                     169.0 136 5 18 1   3     0   6   82 87                 169
2039819 2039819 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_8 147 7 12 0   3     0   3   83 89                       172.0 147 7 12 0   3     0   3   83 89                 172
2228766 2228766 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_8 144 5 12 0   5     0   1   84 83                       167.0 144 5 12 0   5     0   1   84 83                 167
743429 743429 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_8 10 41 20 0   2     0   5   37 41                       78 10 41 20 0   2     0   5   37 41                 78
940250 940250 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_8 10 51 12 0   1     0   2   37 39                       76 10 51 12 0   1     0   2   37 39                 76
1131128 1131128 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_8 4 53 20 0   1     0   1   40 39                       79 4 53 20 0   1     0   1   40 39                 79
1372471 1372471 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_8 5 43 25 0   1     0   1   33 42 *                     75.0 5 43 25 0   1     0   1   33 42                 75
1679734 1679734 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_8 9 44 22 0   0     0   1   39 37 *                     76.0 9 44 22 0   0     0   1   39 37                 76
2047544 2047544 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_8 3 43 23 0   0     0   4   34 39                       73.0 3 43 23 0   0     0   4   34 39                 73
2237955 2237955 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_8 11 50 18 0   2     0   0   41 40                       81.0 11 50 18 0   2     0   0   41 40                 81
743966 743966 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2015   grade_8 284 4 16 0   157     0   18   260 219                       479 284 4 16 0   157     0   18   260 219                 479
940799 940799 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2016   grade_8 273 9 9 2   134     0   16   226 217                       443 273 9 9 2   134     0   16   226 217                 443
1131735 1131735 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   grade_8 257 10 12 1   139     0   23   240 202                       442 257 10 12 1   139     0   23   240 202                 442
1373024 1373024 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2020   grade_8 234 11 30 2   150     0   21   243 205 *                     448.0 234 11 30 2   150     0   21   243 205                 448
1680288 1680288 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough - Raymond J Grey Junior High   Regular School No Middle 07 08 2021   grade_8 202 14 28 2   159     2   14   212 208 *                     421.0 202 14 28 2   159     2   14   212 208                 421
2048096 2048096 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2019   grade_8 265 17 18 1   174     0   13   262 226                       488.0 265 17 18 1   174     0   13   262 226                 488
2238572 2238572 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough: Raymond J Grey Junior High   Regular School No Middle 07 08 2018   grade_8 266 8 19 0   159     0   26   242 236                       478.0 266 8 19 0   159     0   26   242 236                 478
735682 735682 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_8 114 0 0 0   1     0   0   55 60                       115 114 0 0 0   1     0   0   55 60                 115
932560 932560 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_8 108 2 0 0   1     0   0   55 56                       111 108 2 0 0   1     0   0   55 56                 111
1121975 1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1364808 1364808 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_8 112 2 2 0   1     0   3   62 58 *                     120.0 112 2 2 0   1     0   3   62 58                 120
1672032 1672032 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_8 99 0 4 0   1     0   5   59 50 *                     109.0 99 0 4 0   1     0   5   59 50                 109
2039834 2039834 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_8 108 1 1 0   0     0   1   52 59                       111.0 108 1 1 0   0     0   1   52 59                 111
2228783 2228783 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_8 73 0 3 0   0     0   1   42 35                       77.0 73 0 3 0   0     0   1   42 35                 77
743986 743986 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_8 103 3 4 2   3     0   0   57 58                       115 103 3 4 2   3     0   0   57 58                 115
940819 940819 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_8 103 8 3 0   0     0   0   57 57                       114 103 8 3 0   0     0   0   57 57                 114
1131759 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
1373039 1373039 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2020   grade_8 87 2 1 1   0     0   1   45 47 *                     92.0 87 2 1 1   0     0   1   45 47                 92
1680303 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
2048111 2048111 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_8 85 2 1 0   0     0   1   49 40                       89.0 85 2 1 0   0     0   1   49 40                 89
2238590 2238590 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Adams-Cheshire: Hoosac Valley High School   Regular School No High 08 12 2018   grade_8 103 7 2 0   2     0   1   61 54                       115.0 103 7 2 0   2     0   1   61 54                 115
743508 743508 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_8 99 4 2 2   26     0   12   62 83                       145 99 4 2 2   26     0   12   62 83                 145
940328 940328 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_8 101 5 3 0   29     0   8   84 62                       146 101 5 3 0   29     0   8   84 62                 146
1131224 1131224 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_8 101 1 10 0   32     0   5   73 76                       149 101 1 10 0   32     0   5   73 76                 149
1372562 1372562 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_8 104 0 9 0   20     0   13   81 65 *                     146.0 104 0 9 0   20     0   13   81 65                 146
1679825 1679825 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_8 87 2 8 0   19     0   9   65 60 *                     125.0 87 2 8 0   19     0   9   65 60                 125
2047635 2047635 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_8 109 4 13 0   18     0   14   89 69                       158.0 109 4 13 0   18     0   14   89 69                 158
2238054 2238054 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_8 109 2 12 0   26     0   10   76 83                       159.0 109 2 12 0   26     0   10   76 83                 159
735707 735707 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_8 * * * *   *     *   *   2 3                       5                         2 3                 5
735709 735709 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No 2 07 08 2015   grade_8 280 5 21 0   6     0   5   161 156                       317 280 5 21 0   6     0   5   161 156                 317
932585 932585 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_8 * * * *   *     *   *   2 1                       3                         2 1                 3
932587 932587 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No 2 07 08 2016   grade_8 270 3 12 0   7     0   4   150 146                       296 270 3 12 0   7     0   4   150 146                 296
1122006 1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1122009 1122009 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   grade_8 278 3 19 0   1     0   8   147 162                       309 278 3 19 0   1     0   8   147 162                 309
1364833 1364833 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2020   grade_8 236 10 20 0   12     0   9   157 130 *                     287.0 236 10 20 0   12     0   9   157 130                 287
1672057 1672057 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam - Agawam Junior High   Regular School No Middle 07 08 2021   grade_8 229 13 20 0   4     0   9   138 137 *                     275.0 229 13 20 0   4     0   9   138 137                 275
2039859 2039859 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2019   grade_8 251 4 25 0   13     0   7   153 147                       300.0 251 4 25 0   13     0   7   153 147                 300
2228815 2228815 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam: Agawam Junior High   Regular School No Middle 07 08 2018   grade_8 216 6 24 0   7     0   9   129 133                       262.0 216 6 24 0   7     0   9   129 133                 262
1372451 1372451 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_8 16 6 21 0   0     0   0   22 21 *                     43.0 16 6 21 0   0     0   0   22 21                 43
1679715 1679715 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_8 8 11 29 0   0     0   0   19 29 *                     48.0 8 11 29 0   0     0   0   19 29                 48
2047524 2047524 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_8 10 9 20 0   0     0   1   18 22                       40.0 10 9 20 0   0     0   1   18 22                 40
2237934 2237934 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   grade_8 15 7 13 0   2     0   2   16 23                       39.0 15 7 13 0   2     0   2   16 23                 39
735729 735729 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_8 159 6 8 0   0     0   7   105 75                       180 159 6 8 0   0     0   7   105 75                 180
932607 932607 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2016   grade_8 168 2 6 0   2     0   6   92 92                       184 168 2 6 0   2     0   6   92 92                 184
1122033 1122033 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_8 142 4 11 1   2     0   10   91 79                       170 142 4 11 1   2     0   10   91 79                 170
1364853 1364853 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_8 137 6 21 0   0     1   4   85 84 *                     169.0 137 6 21 0   0     1   4   85 84                 169
1672077 1672077 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_8 121 5 11 0   3     1   6   70 77 *                     147.0 121 5 11 0   3     1   6   70 77                 147
2039880 2039880 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_8 141 1 14 0   1     0   8   83 82                       165.0 141 1 14 0   1     0   8   83 82                 165
2228839 2228839 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_8 154 2 11 0   2     0   7   93 83                       176.0 154 2 11 0   2     0   7   93 83                 176
743992 743992 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No 2 07 08 2015   grade_8 142 14 38 1   25     0   20   125 115                       240 142 14 38 1   25     0   20   125 115                 240
940826 940826 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No 2 07 08 2016   grade_8 140 16 34 1   23     1   18   116 117                       233 140 16 34 1   23     1   18   116 117                 233
1131766 1131766 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2017   grade_8 121 16 41 0   16     1   23   100 118                       218 121 16 41 0   16     1   23   100 118                 218
1373045 1373045 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2020   grade_8 119 20 44 1   10     0   18   106 106 *                     212.0 119 20 44 1   10     0   18   106 106                 212
1680309 1680309 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_8 101 14 40 0   26     0   22   115 88 *                     203.0 101 14 40 0   26     0   22   115 88                 203
2048118 2048118 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2019   grade_8 108 15 30 0   21     0   19   105 88                       193.0 108 15 30 0   21     0   19   105 88                 193
2238597 2238597 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham: Amherst Regional Middle School   Regular School No Middle 07 08 2018   grade_8 142 14 29 0   17     1   13   109 107                       216.0 142 14 29 0   17     1   13   109 107                 216
735794 735794 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2015   grade_8 161 4 5 0   16     0   6   92 100                       192 161 4 5 0   16     0   6   92 100                 192
735797 735797 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2015   grade_8 155 4 5 0   22     0   7   92 101                       193 155 4 5 0   22     0   7   92 101                 193
735800 735800 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2015   grade_8 98 2 7 0   28     0   2   76 61                       137 98 2 7 0   28     0   2   76 61                 137
932670 932670 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2016   grade_8 159 3 12 0   14     0   6   105 89                       194 159 3 12 0   14     0   6   105 89                 194
932673 932673 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2016   grade_8 147 2 5 1   29     0   5   85 104                       189 147 2 5 1   29     0   5   85 104                 189
932676 932676 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2016   grade_8 83 4 5 0   26     0   2   69 51                       120 83 4 5 0   26     0   2   69 51                 120
1122109 1122109 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_8 147 2 9 0   26     0   5   86 103                       189 147 2 9 0   26     0   5   86 103                 189
1122113 1122113 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2017   grade_8 138 2 6 0   29     0   3   86 92                       178 138 2 6 0   29     0   3   86 92                 178
1122117 1122117 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_8 99 7 7 0   40     0   3   66 90                       156 99 7 7 0   40     0   3   66 90                 156
1364918 1364918 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_8 141 4 14 0   17     0   5   77 104 *                     181.0 141 4 14 0   17     0   5   77 104                 181
1364921 1364921 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_8 121 10 10 0   28     0   3   86 86 *                     172.0 121 10 10 0   28     0   3   86 86                 172
1364924 1364924 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_8 79 4 14 0   46     0   5   81 67 *                     148.0 79 4 14 0   46     0   5   81 67                 148
1672141 1672141 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_8 133 2 12 1   17     1   4   83 87 *                     170.0 133 2 12 1   17     1   4   83 87                 170
1672144 1672144 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_8 119 6 14 0   29     0   7   97 78 *                     175.0 119 6 14 0   29     0   7   97 78                 175
1672147 1672147 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_8 62 3 12 1   50     0   3   73 58 *                     131.0 62 3 12 1   50     0   3   73 58                 131
2039945 2039945 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2019   grade_8 162 1 6 2   26     0   4   97 104                       201.0 162 1 6 2   26     0   4   97 104                 201
2039948 2039948 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_8 138 2 6 1   24     0   6   82 95                       177.0 138 2 6 1   24     0   6   82 95                 177
2039951 2039951 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_8 77 2 11 0   35     0   4   54 75                       129.0 77 2 11 0   35     0   4   54 75                 129
2228915 2228915 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_8 131 1 8 1   24     0   4   99 70                       169.0 131 1 8 1   24     0   4   99 70                 169
2228919 2228919 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_8 123 3 10 0   28     0   4   69 99                       168.0 123 3 10 0   28     0   4   69 99                 168
2228923 2228923 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_8 85 3 11 0   42     0   2   77 66                       143.0 85 3 11 0   42     0   2   77 66                 143
1133165 1133165 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_8 65 17 16 0   1     0   4   57 46                       103 65 17 16 0   1     0   4   57 46                 103
1374236 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

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