enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
735851 735851 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2015   grade_8 266 18 21 0   41     0   23   169 200                       369 266 18 21 0   41     0   23   169 200                 369
932727 932727 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2016   grade_8 263 13 16 0   34     1   9   177 159                       336 263 13 16 0   34     1   9   177 159                 336
1122177 1122177 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_8 302 14 22 0   28     0   12   179 199                       378 302 14 22 0   28     0   12   179 199                 378
1364975 1364975 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2020   grade_8 328 12 31 0   51     1   21   203 240 *                     444.0 328 12 31 0   51     1   21   203 240                 444
1672198 1672198 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington - Ottoson Middle   Regular School No Middle 07 08 2021   grade_8 309 15 35 1   46     1   29   239 196 *                     436.0 309 15 35 1   46     1   29   239 196                 436
2040002 2040002 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_8 301 18 21 0   42     0   32   184 230                       414.0 301 18 21 0   42     0   32   184 230                 414
2228983 2228983 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_8 299 16 24 0   41     0   21   196 205                       401.0 299 16 24 0   41     0   21   196 205                 401
738289 738289 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2015   grade_8 121 10 32 0   4     0   8   92 83                       175 121 10 32 0   4     0   8   92 83                 175
738292 738292 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No 2 06 08 2015   grade_8 70 13 59 0   5     0   5   88 64                       152 70 13 59 0   5     0   5   88 64                 152
738295 738295 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_8 122 16 68 0   19     0   7   117 115                       232 122 16 68 0   19     0   7   117 115                 232
935143 935143 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2016   grade_8 121 6 33 0   3     0   6   79 90                       169 121 6 33 0   3     0   6   79 90                 169
935146 935146 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No 2 06 08 2016   grade_8 82 11 58 0   5     0   11   88 79                       167 82 11 58 0   5     0   11   88 79                 167
935149 935149 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_8 109 9 71 0   18     1   10   115 103                       218 109 9 71 0   18     1   10   115 103                 218
1125022 1125022 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_8 120 17 40 0   2     0   7   97 89                       186 120 17 40 0   2     0   7   97 89                 186
1125026 1125026 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2017   grade_8 81 17 60 0   5     0   5   88 80                       168 81 17 60 0   5     0   5   88 80                 168
1125030 1125030 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   grade_8 139 6 57 0   20     0   6   105 123                       228 139 6 57 0   20     0   6   105 123                 228
1367381 1367381 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2020   grade_8 108 15 43 0   6     0   8   95 85 *                     180.0 108 15 43 0   6     0   8   95 85                 180
1367384 1367384 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2020   grade_8 107 17 113 0   7     1   5   123 127 *                     250.0 107 17 113 0   7     1   5   123 127                 250
1367387 1367387 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2020   grade_8 149 7 85 0   7     0   4   130 122 *                     252.0 149 7 85 0   7     0   4   130 122                 252
1674615 1674615 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham - Cameron Middle School   Regular School No Middle 06 08 2021   grade_8 132 14 35 0   8     0   3   86 106 *                     192.0 132 14 35 0   8     0   3   86 106                 192
1674618 1674618 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham - Fuller Middle   Regular School No Middle 06 08 2021   grade_8 57 19 110 0   1     0   4   116 75 *                     191.0 57 19 110 0   1     0   4   116 75                 191
1674621 1674621 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_8 132 12 74 0   9     0   17   114 130 *                     244.0 132 12 74 0   9     0   17   114 130                 244
2042452 2042452 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_8 123 12 27 0   5     0   7   84 90                       174.0 123 12 27 0   5     0   7   84 90                 174
2042455 2042455 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_8 70 22 65 0   6     1   12   92 84                       176.0 70 22 65 0   6     1   12   92 84                 176
2042458 2042458 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_8 138 14 72 0   13     0   5   134 108                       242.0 138 14 72 0   13     0   5   134 108                 242
2231851 2231851 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham: Cameron Middle School   Regular School No Middle 06 08 2018   grade_8 115 16 36 1   5     0   6   94 85                       179.0 115 16 36 1   5     0   6   94 85                 179
2231855 2231855 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   grade_8 82 12 59 0   4     1   1   77 82                       159.0 82 12 59 0   4     1   1   77 82                 159
2231859 2231859 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_8 133 12 82 0   21     0   9   134 123                       257.0 133 12 82 0   21     0   9   134 123                 257
738339 738339 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2015   grade_8 150 2 1 1   3     0   2   77 82                       159 150 2 1 1   3     0   2   77 82                 159
738342 738342 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_8 134 0 6 0   6     2   2   73 77                       150 134 0 6 0   6     2   2   73 77                 150
738345 738345 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2015   grade_8 127 1 3 1   9     1   4   78 68                       146 127 1 3 1   9     1   4   78 68                 146
935193 935193 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2016   grade_8 139 2 4 0   5     0   0   77 73                       150 139 2 4 0   5     0   0   77 73                 150
935196 935196 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2016   grade_8 140 0 3 0   8     2   7   81 79                       160 140 0 3 0   8     2   7   81 79                 160
935199 935199 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2016   grade_8 137 0 1 1   7     0   5   76 75                       151 137 0 1 1   7     0   5   76 75                 151
1125083 1125083 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_8 141 3 0 0   7     0   1   77 75                       152 141 3 0 0   7     0   1   77 75                 152
1125087 1125087 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2017   grade_8 146 3 6 1   6     0   4   94 72                       166 146 3 6 1   6     0   4   94 72                 166
1125091 1125091 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2017   grade_8 137 3 1 1   12     0   2   72 84                       156 137 3 1 1   12     0   2   72 84                 156
1367431 1367431 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_8 108 1 11 0   6     1   3   67 63 *                     130.0 108 1 11 0   6     1   3   67 63                 130
1367434 1367434 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2020   grade_8 137 4 2 0   7     0   3   77 76 *                     153.0 137 4 2 0   7     0   3   77 76                 153
1367437 1367437 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2020   grade_8 130 3 4 0   9     0   4   77 73 *                     150.0 130 3 4 0   9     0   4   77 73                 150
1674665 1674665 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin - Annie Sullivan Middle School   Regular School No Middle 06 08 2021   grade_8 108 2 10 1   4     0   0   70 55 *                     125.0 108 2 10 1   4     0   0   70 55                 125
1674668 1674668 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_8 99 5 8 0   10     0   1   66 57 *                     123.0 99 5 8 0   10     0   1   66 57                 123
1674671 1674671 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_8 138 2 10 0   14     0   2   99 67 *                     166.0 138 2 10 0   14     0   2   99 67                 166
2042502 2042502 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_8 145 0 4 0   6     1   2   92 65                       158.0 145 0 4 0   6     1   2   92 65                 158
2042505 2042505 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_8 119 3 6 0   9     0   1   62 76                       138.0 119 3 6 0   9     0   1   62 76                 138
2042508 2042508 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2019   grade_8 133 0 5 0   11     0   6   66 89                       155.0 133 0 5 0   11     0   6   66 89                 155
2231912 2231912 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   grade_8 144 0 4 0   6     2   1   82 75                       157.0 144 0 4 0   6     2   1   82 75                 157
2231916 2231916 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   grade_8 134 0 6 0   7     0   5   82 70                       152.0 134 0 6 0   7     0   5   82 70                 152
2231920 2231920 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin: Horace Mann   Regular School No Middle 06 08 2018   grade_8 139 3 5 0   13     0   1   86 75                       161.0 139 3 5 0   13     0   1   86 75                 161
738363 738363 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_8 134 3 28 0   6     0   8   89 90                       179 134 3 28 0   6     0   8   89 90                 179
935214 935214 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   grade_8 162 10 26 0   5     0   9   107 105                       212 162 10 26 0   5     0   9   107 105                 212
1125110 1125110 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2017   grade_8 144 5 22 0   3     0   7   96 85                       181 144 5 22 0   3     0   7   96 85                 181
1367452 1367452 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2020   grade_8 131 6 41 0   1     0   12   97 94 *                     191.0 131 6 41 0   1     0   12   97 94                 191
1674686 1674686 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner - Gardner High   Regular School No High 08 12 2021   grade_8 127 5 46 0   5     0   22   107 97 *                     205.0 127 5 46 0   5     0   22   107 97                 205
2042523 2042523 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_8 94 1 34 0   6     0   15   72 78                       150.0 94 1 34 0   6     0   15   72 78                 150
2231939 2231939 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_8 108 5 32 1   3     0   14   91 72                       163.0 108 5 32 1   3     0   14   91 72                 163
738382 738382 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_8 110 0 0 0   1     0   1   56 56                       112 110 0 0 0   1     0   1   56 56                 112
935233 935233 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 07 08 2016   grade_8 120 0 2 0   0     0   4   62 64                       126 120 0 2 0   0     0   4   62 64                 126
1125132 1125132 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_8 112 0 0 0   1     0   1   59 55                       114 112 0 0 0   1     0   1   59 55                 114
1367470 1367470 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_8 91 2 3 0   0     0   0   50 46 *                     96.0 91 2 3 0   0     0   0   50 46                 96
1674705 1674705 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown - Georgetown Middle School   Regular School No Middle 07 08 2021   grade_8 82 0 2 0   2     1   1   41 47 *                     88.0 82 0 2 0   2     1   1   41 47                 88
2042542 2042542 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_8 105 3 1 0   1     0   1   62 49                       111.0 105 3 1 0   1     0   1   62 49                 111
2231961 2231961 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown: Georgetown Middle School   Regular School No Middle 07 08 2018   grade_8 112 1 2 0   2     0   1   65 53                       118.0 112 1 2 0   2     0   1   65 53                 118
738420 738420 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_8 215 2 10 2   5     1   3   133 105                       238 215 2 10 2   5     1   3   133 105                 238
935271 935271 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2016   grade_8 164 3 15 0   4     4   7   94 103                       197 164 3 15 0   4     4   7   94 103                 197
1125178 1125178 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2017   grade_8 157 2 23 1   0     1   4   85 103                       188 157 2 23 1   0     1   4   85 103                 188
1367508 1367508 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_8 201 4 19 0   4     1   8   123 114 *                     237.0 201 4 19 0   4     1   8   123 114                 237
1674743 1674743 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester - Ralph B O'Maley Middle   Regular School No Middle 06 08 2021   grade_8 168 2 25 1   1     0   2   85 114 *                     199.0 168 2 25 1   1     0   2   85 114                 199
2042580 2042580 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_8 164 5 16 1   3     1   17   117 90                       207.0 164 5 16 1   3     1   17   117 90                 207
2232007 2232007 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_8 198 3 21 0   2     0   5   115 114                       229.0 198 3 21 0   2     0   5   115 114                 229
1125194 1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1374315 1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1674758 1674758 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
2232023 2232023 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_8 * * * *   *     *   *   * *                       1.0                                             1
738444 738444 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2015   grade_8 196 6 6 0   32     0   7   124 123                       247 196 6 6 0   32     0   7   124 123                 247
935296 935296 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2016   grade_8 208 2 11 0   34     0   3   147 111                       258 208 2 11 0   34     0   3   147 111                 258
1125221 1125221 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2017   grade_8 174 4 10 0   19     0   7   106 108                       214 174 4 10 0   19     0   7   106 108                 214
1367531 1367531 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2020   grade_8 201 5 16 2   28     2   6   130 130 *                     260.0 201 5 16 2   28     2   6   130 130                 260
1674781 1674781 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton - Grafton Middle   Regular School No Middle 07 08 2021   grade_8 211 2 15 0   29     0   10   150 117 *                     267.0 211 2 15 0   29     0   10   150 117                 267
2042603 2042603 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_8 214 7 8 0   30     0   6   125 140                       265.0 214 7 8 0   30     0   6   125 140                 265
2232050 2232050 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton: Grafton Middle   Regular School No Middle 07 08 2018   grade_8 215 3 9 0   31     0   9   135 132                       267.0 215 3 9 0   31     0   9   135 132                 267
738459 738459 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2015   grade_8 64 1 2 0   2     0   4   43 30                       73 64 1 2 0   2     0   4   43 30                 73
935310 935310 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_8 58 0 6 0   3     0   0   35 32                       67 58 0 6 0   3     0   0   35 32                 67
1125239 1125239 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2017   grade_8 51 1 6 0   3     0   0   39 22                       61 51 1 6 0   3     0   0   39 22                 61
1367545 1367545 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2020   grade_8 50 0 4 0   1     0   2   29 28 *                     57.0 50 0 4 0   1     0   2   29 28                 57
1674795 1674795 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby - Granby Jr Sr High School   Regular School No High 07 12 2021   grade_8 47 0 3 0   0     0   1   31 20 *                     51.0 47 0 3 0   0     0   1   31 20                 51
2042618 2042618 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_8 53 0 5 0   1     0   0   40 19                       59.0 53 0 5 0   1     0   0   40 19                 59
2232068 2232068 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   grade_8 61 1 7 0   0     0   0   38 31                       69.0 61 1 7 0   0     0   0   38 31                 69
738485 738485 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2015   grade_8 89 2 22 1   3     0   3   68 52                       120 89 2 22 1   3     0   3   68 52                 120
935336 935336 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2016   grade_8 69 2 18 0   2     0   5   57 39                       96 69 2 18 0   2     0   5   57 39                 96
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125285 1125285 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2017   grade_8 66 0 15 0   2     0   7   53 37                       90 66 0 15 0   2     0   7   53 37                 90
1367569 1367569 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2020   grade_8 82 2 21 0   3     0   10   64 54 *                     118.0 82 2 21 0   3     0   10   64 54                 118

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