enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
738232 738232 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2015   grade_8 203 6 4 0   8     0   2   122 101                       223 203 6 4 0   8     0   2   122 101                 223
935085 935085 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2016   grade_8 191 14 7 0   6     0   5   110 113                       223 191 14 7 0   6     0   5   110 113                 223
1124951 1124951 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_8 174 5 5 0   7     0   2   98 95                       193 174 5 5 0   7     0   2   98 95                 193
1367318 1367318 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_8 168 16 15 0   4     1   5   108 100 *                     209.0 168 16 15 0   4     1   5   108 100                 209
1674552 1674552 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_8 175 15 6 1   7     0   5   111 98 *                     209.0 175 15 6 1   7     0   5   111 98                 209
2042390 2042390 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2019   grade_8 171 8 11 2   3     0   5   92 108                       200.0 171 8 11 2   3     0   5   92 108                 200
2231779 2231779 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough: John J Ahern   Regular School No Middle 05 08 2018   grade_8 184 9 18 2   6     0   4   123 100                       223.0 184 9 18 2   6     0   4   123 100                 223
738212 738212 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_8 10 0 1 0   0     0   0   4 7                       11 10 0 1 0   0     0   0   4 7                 11
935065 935065 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_8 8 2 0 0   0     0   1   6 5                       11 8 2 0 0   0     0   1   6 5                 11
1367298 1367298 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_8 7 0 0 0   0     0   0   1 6 *                     7.0 7 0 0 0   0     0   0   1 6                 7
1674532 1674532 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_8 13 0 0 0   0     0   0   8 5 *                     13.0 13 0 0 0   0     0   0   8 5                 13
2042370 2042370 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_8 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2231755 2231755 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_8 11 0 0 0   0     0   0   6 5                       11.0 11 0 0 0   0     0   0   6 5                 11
738172 738172 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_8 58 12 74 0   10     0   11   81 84                       165 58 12 74 0   10     0   11   81 84                 165
738182 738182 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_8 31 11 53 0   7     0   10   50 62                       112 31 11 53 0   7     0   10   50 62                 112
738192 738192 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_8 30 4 27 0   3     0   4   27 41                       68 30 4 27 0   3     0   4   27 41                 68
935026 935026 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_8 39 12 78 0   13     0   7   74 75                       149 39 12 78 0   13     0   7   74 75                 149
935036 935036 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_8 42 5 47 0   6     0   12   66 46                       112 42 5 47 0   6     0   12   66 46                 112
935046 935046 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_8 24 3 31 0   4     0   6   34 34                       68 24 3 31 0   4     0   6   34 34                 68
1124883 1124883 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_8 56 14 82 0   7     0   16   73 102                       175 56 14 82 0   7     0   16   73 102                 175
1124895 1124895 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_8 28 8 61 0   3     0   11   62 49                       111 28 8 61 0   3     0   11   62 49                 111
1124906 1124906 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2017   grade_8 23 6 34 0   3     0   9   27 48                       75 23 6 34 0   3     0   9   27 48                 75
1367259 1367259 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_8 50 10 94 0   14     0   10   82 96 *                     178.0 50 10 94 0   14     0   10   82 96                 178
1367269 1367269 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_8 33 10 95 0   7     0   10   85 70 *                     155.0 33 10 95 0   7     0   10   85 70                 155
1367279 1367279 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2020   grade_8 21 4 34 0   4     0   3   35 31 *                     66.0 21 4 34 0   4     0   3   35 31                 66
1674493 1674493 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg - Memorial Middle School   Regular School No Middle 05 08 2021   grade_8 40 9 83 0   14     0   15   82 79 *                     161.0 40 9 83 0   14     0   15   82 79                 161
1674503 1674503 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg - Arthur M Longsjo Middle School   Regular School No Middle 05 08 2021   grade_8 33 7 95 0   3     1   13   80 72 *                     152.0 33 7 95 0   3     1   13   80 72                 152
1674513 1674513 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg - McKay Arts Academy   Regular School No Elementary PK 08 2021   grade_8 13 2 32 0   4     0   10   29 32 *                     61.0 13 2 32 0   4     0   10   29 32                 61
2042329 2042329 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_8 56 15 107 0   13     0   9   100 100                       200.0 56 15 107 0   13     0   9   100 100                 200
2042339 2042339 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2019   grade_8 43 10 82 0   8     0   8   84 67                       151.0 43 10 82 0   8     0   8   84 67                 151
2042349 2042349 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2019   grade_8 22 3 35 0   3     0   5   29 39                       68.0 22 3 35 0   3     0   5   29 39                 68
2231711 2231711 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg: Memorial Intermediate   Regular School No Middle 05 08 2018   grade_8 43 6 101 0   8     0   10   89 79                       168.0 43 6 101 0   8     0   10   89 79                 168
2231723 2231723 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_8 37 5 48 0   6     0   6   56 46                       102.0 37 5 48 0   6     0   6   56 46                 102
2231734 2231734 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg: McKay Arts Academy   Regular School No Elementary PK 08 2018   grade_8 16 2 38 0   6     0   6   26 42                       68.0 16 2 38 0   6     0   6   26 42                 68
738152 738152 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2015   grade_8 228 15 8 3   9     0   12   133 142                       275 228 15 8 3   9     0   12   133 142                 275
935006 935006 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2016   grade_8 239 15 11 1   8     0   16   147 143                       290 239 15 11 1   8     0   16   147 143                 290
1124860 1124860 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_8 228 12 5 4   10     0   19   134 144                       278 228 12 5 4   10     0   19   134 144                 278
1367238 1367238 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_8 204 19 16 1   2     0   14   130 126 *                     256.0 204 19 16 1   2     0   14   130 126                 256
1674472 1674472 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_8 197 15 15 1   12     0   17   134 123 *                     257.0 197 15 15 1   12     0   17   134 123                 257
2042308 2042308 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2019   grade_8 255 16 13 1   5     1   15   148 158                       306.0 255 16 13 1   5     1   15   148 158                 306
2231687 2231687 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth: Lawrence   Regular School No Middle 07 08 2018   grade_8 229 16 14 3   6     0   19   160 127                       287.0 229 16 14 3   6     0   19   160 127                 287
738075 738075 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_8 18 5 13 1   1     0   2   17 23                       40 18 5 13 1   1     0   2   17 23                 40
738107 738107 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2015   grade_8 142 13 66 0   15     0   7   123 120                       243 142 13 66 0   15     0   7   123 120                 243
738110 738110 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_8 126 13 40 0   8     2   11   84 116                       200 126 13 40 0   8     2   11   84 116                 200
738113 738113 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2015   grade_8 163 16 47 2   8     0   15   125 126                       251 163 16 47 2   8     0   15   125 126                 251
738120 738120 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_8 9 0 2 0   0     1   1   10 *                       13 9 0 2 0   0     1   1   10                   13
738122 738122 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2015   grade_8 6 2 9 0   0     0   1   8 10                       18 6 2 9 0   0     0   1   8 10                 18
934928 934928 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2016   grade_8 28 5 7 0   0     0   2   21 21                       42 28 5 7 0   0     0   2   21 21                 42
934957 934957 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2016   grade_8 111 14 50 2   16     0   10   103 100                       203 111 14 50 2   16     0   10   103 100                 203
934960 934960 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2016   grade_8 145 13 37 2   7     0   13   112 105                       217 145 13 37 2   7     0   13   112 105                 217
934963 934963 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2016   grade_8 157 13 56 0   11     1   4   111 131                       242 157 13 56 0   11     1   4   111 131                 242
934969 934969 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2016   grade_8 14 4 4 0   0     0   3   18 7                       25 14 4 4 0   0     0   3   18 7                 25
934973 934973 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_8 6 1 2 0   0     0   2   9 2                       11 6 1 2 0   0     0   2   9 2                 11
1124752 1124752 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_8 42 5 10 0   4     0   5   33 33                       66 42 5 10 0   4     0   5   33 33                 66
1124763 1124763 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_8 26 2 20 0   3     0   2   30 23                       53 26 2 20 0   3     0   2   30 23                 53
1124796 1124796 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2017   grade_8 103 10 59 0   12     0   6   88 102                       190 103 10 59 0   12     0   6   88 102                 190
1124800 1124800 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2017   grade_8 125 16 40 0   8     1   14   113 91                       204 125 16 40 0   8     1   14   113 91                 204
1124804 1124804 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_8 154 11 43 0   8     0   11   119 108                       227 154 11 43 0   8     0   11   119 108                 227
1124812 1124812 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No Middle 06 08 2017   grade_8 7 3 8 0   0     0   1   9 10                       19 7 3 8 0   0     0   1   9 10                 19
1124820 1124820 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_8 2 1 3 0   0     0   0   6 *                       6 2 1 3 0   0     0   0   6                   6
1367150 1367150 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_8 19 7 17 0   2     0   5   33 17 *                     50.0 19 7 17 0   2     0   5   33 17                 50
1367160 1367160 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_8 22 3 8 0   3     0   5   22 19 *                     41.0 22 3 8 0   3     0   5   22 19                 41
1367189 1367189 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_8 72 18 65 0   6     0   13   92 82 *                     174.0 72 18 65 0   6     0   13   92 82                 174
1367192 1367192 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_8 112 16 45 0   9     0   13   118 77 *                     195.0 112 16 45 0   9     0   13   118 77                 195
1367195 1367195 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_8 138 24 40 0   13     0   11   106 120 *                     226.0 138 24 40 0   13     0   11   106 120                 226
1367199 1367199 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_8 3 1 0 0   0     0   4   7 1 *                     8.0 3 1 0 0   0     0   4   7 1                 8
1367208 1367208 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_8 8 5 11 0   0     0   2   14 12 *                     26.0 8 5 11 0   0     0   2   14 12                 26
1674381 1674381 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_8 24 8 41 0   3     0   8   36 48 *                     84.0 24 8 41 0   3     0   8   36 48                 84
1674391 1674391 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_8 28 2 17 0   0     0   4   27 24 *                     51.0 28 2 17 0   0     0   4   27 24                 51
1674420 1674420 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River - Talbot Innovation School   Regular School No Middle 06 08 2021   grade_8 74 12 61 0   9     0   12   93 75 *                     168.0 74 12 61 0   9     0   12   93 75                 168
1674423 1674423 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River - Morton Middle   Regular School No Middle 06 08 2021   grade_8 125 20 48 1   6     1   18   103 116 *                     219.0 125 20 48 1   6     1   18   103 116                 219
1674426 1674426 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River - Matthew J Kuss Middle   Regular School No Middle 06 08 2021   grade_8 143 16 59 0   10     0   25   113 140 *                     253.0 143 16 59 0   10     0   25   113 140                 253
1674432 1674432 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_8 4 2 3 0   0     0   1   8 2 *                     10.0 4 2 3 0   0     0   1   8 2                 10
1674442 1674442 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_8 6 6 11 0   0     0   2   19 6 *                     25.0 6 6 11 0   0     0   2   19 6                 25
2042223 2042223 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_8 28 5 18 1   2     0   1   30 25                       55.0 28 5 18 1   2     0   1   30 25                 55
2042233 2042233 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_8 19 3 21 0   1     0   3   17 30                       47.0 19 3 21 0   1     0   3   17 30                 47
2042261 2042261 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2019   grade_8 83 14 47 0   8     0   10   88 74                       162.0 83 14 47 0   8     0   10   88 74                 162
2042264 2042264 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_8 114 14 41 1   13     0   16   104 95                       199.0 114 14 41 1   13     0   16   104 95                 199
2042267 2042267 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2019   grade_8 144 23 51 0   7     0   17   117 125                       242.0 144 23 51 0   7     0   17   117 125                 242
2042271 2042271 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_8 4 0 2 0   0     0   0   3 3                       6.0 4 0 2 0   0     0   0   3 3                 6
2042279 2042279 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_8 13 2 4 0   0     0   2   12 9                       21.0 13 2 4 0   0     0   2   12 9                 21
2231571 2231571 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River: Henry Lord Community School   Regular School No Elementary PK 08 2018   grade_8 35 2 18 1   5     0   5   31 35                       66.0 35 2 18 1   5     0   5   31 35                 66
2231582 2231582 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   grade_8 31 3 10 0   0     0   2   26 20                       46.0 31 3 10 0   0     0   2   26 20                 46
2231615 2231615 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River: Talbot Innovation School   Regular School No Middle 06 08 2018   grade_8 73 18 63 0   8     0   19   97 84                       181.0 73 18 63 0   8     0   19   97 84                 181
2231619 2231619 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River: Morton Middle   Regular School No Middle 06 08 2018   grade_8 113 19 46 1   6     1   7   109 84                       193.0 113 19 46 1   6     1   7   109 84                 193
2231623 2231623 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_8 136 16 45 1   13     0   16   99 128                       227.0 136 16 45 1   13     0   16   99 128                 227
2231645 2231645 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2231652 2231652 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_8 8 1 3 0   0     0   1   6 7                       13.0 8 1 3 0   0     0   1   6 7                 13
738027 738027 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_8 125 0 5 0   1     0   2   73 60                       133 125 0 5 0   1     0   2   73 60                 133
934879 934879 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2016   grade_8 140 1 6 0   3     0   3   76 77                       153 140 1 6 0   3     0   3   76 77                 153
1124706 1124706 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2017   grade_8 137 1 6 2   5     0   1   84 68                       152 137 1 6 2   5     0   1   84 68                 152
1367108 1367108 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2020   grade_8 136 2 8 0   5     0   9   92 68 *                     160.0 136 2 8 0   5     0   9   92 68                 160
1674339 1674339 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_8 125 1 7 2   4     0   5   76 68 *                     144.0 125 1 7 2   4     0   5   76 68                 144
2042181 2042181 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2019   grade_8 142 6 9 2   4     0   6   82 87                       169.0 142 6 9 2   4     0   6   82 87                 169
2231524 2231524 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven: Hastings Middle   Regular School No Middle 06 08 2018   grade_8 127 1 7 0   3     0   4   72 70                       142.0 127 1 7 0   3     0   4   72 70                 142
737958 737958 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_8 12 7 20 2   4     0   1   21 25                       46 12 7 20 2   4     0   1   21 25                 46
737973 737973 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_8 47 18 37 0   0     0   4   62 44                       106 47 18 37 0   0     0   4   62 44                 106
737982 737982 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_8 35 12 31 1   10     1   1   44 47                       91 35 12 31 1   10     1   1   44 47                 91
737985 737985 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_8 2 1 3 0   0     0   1   6 1                       7 2 1 3 0   0     0   1   6 1                 7
737997 737997 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_8 44 19 30 0   5     0   0   52 46                       98 44 19 30 0   5     0   0   52 46                 98

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