Data source: Big Local News · About: Big Local

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

View and edit SQL

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
2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
743369 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2015   grade_8 64 73 178 2   19     0   13   171 178                       349 64 73 178 2   19     0   13   171 178                 349
940178 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_8 73 74 145 0   29     0   12   159 174                       333 73 74 145 0   29     0   12   159 174                 333
1131039 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_8 72 79 171 0   29     0   21   196 176                       372 72 79 171 0   29     0   21   196 176                 372
1372389 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_8 59 80 183 1   36     0   16   181 194 *                     375.0 59 80 183 1   36     0   16   181 194                 375
1679652 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester - Worcester East Middle   Regular School No Middle 07 08 2021   grade_8 67 62 187 0   20     1   15   170 182 *                     352.0 67 62 187 0   20     1   15   170 182                 352
2047462 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2019   grade_8 77 71 197 0   18     0   19   183 199                       382.0 77 71 197 0   18     0   19   183 199                 382
2237864 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_8 76 57 175 0   22     0   8   174 164                       338.0 76 57 175 0   22     0   8   174 164                 338
743372 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2015   grade_8 100 71 145 3   54     0   20   202 191                       393 100 71 145 3   54     0   20   202 191                 393
940181 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_8 107 63 173 0   49     0   14   196 210                       406 107 63 173 0   49     0   14   196 210                 406
1131043 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_8 110 62 175 1   41     0   13   217 185                       402 110 62 175 1   41     0   13   217 185                 402
1372392 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2020   grade_8 108 67 200 0   41     0   16   210 222 *                     432.0 108 67 200 0   41     0   16   210 222                 432
1679655 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester - Sullivan Middle   Regular School No Middle 06 08 2021   grade_8 129 67 176 1   44     0   20   223 214 *                     437.0 129 67 176 1   44     0   20   223 214                 437
2047465 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2019   grade_8 91 66 218 1   35     0   19   227 203                       430.0 91 66 218 1   35     0   19   227 203                 430
2237868 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_8 103 56 164 1   49     0   20   199 194                       393.0 103 56 164 1   49     0   20   199 194                 393
743366 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2015   grade_8 229 54 108 0   26     0   26   213 230                       443 229 54 108 0   26     0   26   213 230                 443
940175 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_8 237 53 151 0   23     0   28   258 234                       492 237 53 151 0   23     0   28   258 234                 492
1131035 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2017   grade_8 228 61 154 1   33     0   28   260 245                       505 228 61 154 1   33     0   28   260 245                 505
1372387 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2020   grade_8 186 64 177 1   30     0   19   258 219 *                     477.0 186 64 177 1   30     0   19   258 219                 477
1679650 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester - Forest Grove Middle   Regular School No Middle 07 08 2021   grade_8 164 66 168 2   27     0   20   232 215 *                     447.0 164 66 168 2   27     0   20   232 215                 447
2047460 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2019   grade_8 201 75 177 1   24     0   24   242 260                       502.0 201 75 177 1   24     0   24   242 260                 502
2237860 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   grade_8 213 57 173 0   27     0   22   259 233                       492.0 213 57 173 0   27     0   22   259 233                 492
743364 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2015   grade_8 112 42 113 1   14     0   11   157 136                       293 112 42 113 1   14     0   11   157 136                 293
940173 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2016   grade_8 94 55 101 1   11     0   6   129 139                       268 94 55 101 1   11     0   6   129 139                 268
1131032 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_8 73 55 116 1   11     0   12   129 139                       268 73 55 116 1   11     0   12   129 139                 268
1372385 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2020   grade_8 116 75 142 1   17     0   8   189 170 *                     359.0 116 75 142 1   17     0   8   189 170                 359
1679648 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester - Burncoat Middle School   Regular School No Middle 07 08 2021   grade_8 96 52 161 0   18     0   24   181 170 *                     351.0 96 52 161 0   18     0   24   181 170                 351
2047458 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2019   grade_8 105 59 136 0   11     0   12   145 178                       323.0 105 59 136 0   11     0   12   145 178                 323
2237857 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_8 97 33 125 0   14     0   19   158 130                       288.0 97 33 125 0   14     0   19   158 130                 288
743358 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_8 8 15 67 0   6     0   2   35 63                       98 8 15 67 0   6     0   2   35 63                 98
940167 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2016   grade_8 6 6 83 0   8     0   3   51 55                       106 6 6 83 0   8     0   3   51 55                 106
1131025 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2017   grade_8 5 4 61 0   6     0   1   45 32                       77 5 4 61 0   6     0   1   45 32                 77
1372379 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_8 7 15 71 0   7     0   2   50 52 *                     102.0 7 15 71 0   7     0   2   50 52                 102
1679642 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_8 9 14 68 1   11     0   2   54 51 *                     105.0 9 14 68 1   11     0   2   54 51                 105
2047452 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_8 4 3 69 0   7     0   0   42 41                       83.0 4 3 69 0   7     0   0   42 41                 83
2237850 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_8 7 9 69 0   9     0   1   46 49                       95.0 7 9 69 0   9     0   1   46 49                 95
743352 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2015   grade_8 7 2 20 1   11     0   3   25 19                       44 7 2 20 1   11     0   3   25 19                 44
940161 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2016   grade_8 5 4 26 0   6     0   2   22 21                       43 5 4 26 0   6     0   2   22 21                 43
1131018 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2017   grade_8 4 5 23 0   11     0   1   18 26                       44 4 5 23 0   11     0   1   18 26                 44
1372373 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2020   grade_8 4 8 26 0   5     0   1   22 22 *                     44.0 4 8 26 0   5     0   1   22 22                 44
1679636 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester - University Pk Campus School   Regular School No High 07 12 2021   grade_8 7 4 20 1   4     0   5   20 21 *                     41.0 7 4 20 1   4     0   5   20 21                 41
2047446 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2019   grade_8 4 6 21 0   10     0   3   23 21                       44.0 4 6 21 0   10     0   3   23 21                 44
2237843 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_8 4 5 26 0   9     0   0   27 17                       44.0 4 5 26 0   9     0   0   27 17                 44
743091 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_8 145 11 14 1   11     0   2   95 89                       184 145 11 14 1   11     0   2   95 89                 184
939900 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_8 138 10 10 0   9     0   1   83 85                       168 138 10 10 0   9     0   1   83 85                 168
1130720 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_8 133 17 13 0   5     0   1   88 81                       169 133 17 13 0   5     0   1   88 81                 169
1372115 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_8 112 7 13 1   9     0   5   72 75 *                     147.0 112 7 13 1   9     0   5   72 75                 147
1679376 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_8 125 14 18 0   12     0   6   81 94 *                     175.0 125 14 18 0   12     0   6   81 94                 175
2047188 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_8 110 6 13 3   12     0   2   70 76                       146.0 110 6 13 3   12     0   2   70 76                 146
2237548 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_8 141 12 19 0   12     0   2   90 96                       186.0 141 12 19 0   12     0   2   90 96                 186
743094 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2015   grade_8 149 6 14 0   12     1   6   90 98                       188 149 6 14 0   12     1   6   90 98                 188
939903 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2016   grade_8 137 14 18 0   9     0   5   84 99                       183 137 14 18 0   9     0   5   84 99                 183
1130724 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_8 122 8 13 0   8     0   3   75 79                       154 122 8 13 0   8     0   3   75 79                 154
1372118 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2020   grade_8 125 13 22 0   8     0   3   87 84 *                     171.0 125 13 22 0   8     0   3   87 84                 171
1679379 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_8 133 17 31 0   8     0   6   97 98 *                     195.0 133 17 31 0   8     0   6   97 98                 195
2047191 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_8 125 9 10 1   7     0   5   79 78                       157.0 125 9 10 1   7     0   5   79 78                 157
2237552 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn: Daniel L Joyce Middle School   Regular School No Middle 06 08 2018   grade_8 142 9 15 2   9     1   6   89 95                       184.0 142 9 15 2   9     1   6   89 95                 184
743033 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2015   grade_8 150 2 13 0   0     0   7   96 76                       172 150 2 13 0   0     0   7   96 76                 172
939842 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2016   grade_8 131 6 9 0   1     0   0   68 79                       147 131 6 9 0   1     0   0   68 79                 147
1130652 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2017   grade_8 145 1 20 0   1     0   1   80 88                       168 145 1 20 0   1     0   1   80 88                 168
1372063 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2020   grade_8 118 2 35 0   3     0   3   89 72 *                     161.0 118 2 35 0   3     0   3   89 72                 161
1679323 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop - Winthrop Middle School   Regular School No Middle 06 08 2021   grade_8 122 3 30 0   1     0   1   70 87 *                     157.0 122 3 30 0   1     0   1   70 87                 157
2047137 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2019   grade_8 132 0 19 0   1     0   2   79 75                       154.0 132 0 19 0   1     0   2   79 75                 154
2237480 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop: Winthrop Middle School   Regular School No Middle 06 08 2018   grade_8 126 1 27 0   1     0   2   85 72                       157.0 126 1 27 0   1     0   2   85 72                 157
743019 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2015   grade_8 270 3 11 1   41     0   9   166 169                       335 270 3 11 1   41     0   9   166 169                 335
939828 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2016   grade_8 259 6 14 1   67     0   15   166 196                       362 259 6 14 1   67     0   15   166 196                 362
1130634 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2017   grade_8 303 2 13 1   55     0   8   182 200                       382 303 2 13 1   55     0   8   182 200                 382
1372049 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2020   grade_8 271 4 13 2   59     0   17   168 197 *                     366.0 271 4 13 2   59     0   17   168 197                 366
1679309 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester - McCall Middle   Regular School No Middle 06 08 2021   grade_8 236 5 13 1   65     0   28   168 180 *                     348.0 236 5 13 1   65     0   28   168 180                 348
2047123 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_8 274 5 11 1   70     0   13   188 185                       374.0 274 5 11 1   70     0   13   188 185                 374
2237462 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_8 263 1 14 1   62     1   17   176 183                       359.0 263 1 14 1   62     1   17   176 183                 359
939786 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_8 * * * *   *     *   *   1 3                       4                         1 3                 4
742981 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2015   grade_8 102 3 10 0   3     0   4   58 64                       122 102 3 10 0   3     0   4   58 64                 122
939785 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_8 93 0 6 0   8     0   2   48 61                       109 93 0 6 0   8     0   2   48 61                 109
1130584 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_8 92 0 8 1   2     0   5   51 57                       108 92 0 8 1   2     0   5   51 57                 108
1372006 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2020   grade_8 72 1 6 0   0     0   3   41 41 *                     82.0 72 1 6 0   0     0   3   41 41                 82
1679266 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon - Murdock Middle School   Regular School No Middle 06 08 2021   grade_8 83 5 6 0   4     1   2   53 48 *                     101.0 83 5 6 0   4     1   2   53 48                 101
2047080 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2019   grade_8 67 0 6 0   5     0   8   47 39                       86.0 67 0 6 0   5     0   8   47 39                 86
2237412 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon: Murdock Middle School   Regular School No Middle 06 08 2018   grade_8 76 4 9 1   3     0   2   50 45                       95.0 76 4 9 1   3     0   2   50 45                 95
742966 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2015   grade_8 252 3 9 1   12     0   5   157 125                       282 252 3 9 1   12     0   5   157 125                 282
939771 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2016   grade_8 238 3 10 0   9     0   2   137 125                       262 238 3 10 0   9     0   2   137 125                 262
1130565 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_8 257 6 10 0   14     0   9   142 154                       296 257 6 10 0   14     0   9   142 154                 296
1371992 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2020   grade_8 228 5 11 1   9     1   11   142 124 *                     266.0 228 5 11 1   9     1   11   142 124                 266
1679252 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington - Wilmington Middle School   Regular School No Middle 06 08 2021   grade_8 214 4 13 0   13     0   5   115 134 *                     249.0 214 4 13 0   13     0   5   115 134                 249
2047066 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_8 213 4 11 0   10     0   10   125 123                       248.0 213 4 11 0   10     0   10   125 123                 248
2237393 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington: Wilmington Middle School   Regular School No Middle 06 08 2018   grade_8 270 5 17 1   10     0   8   164 147                       311.0 270 5 17 1   10     0   8   164 147                 311
745021 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2015   grade_8 140 4 0 1   1     0   5   77 74                       151 140 4 0 1   1     0   5   77 74                 151
941842 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_8 131 3 3 0   2     0   2   75 66                       141 131 3 3 0   2     0   2   75 66                 141
1132965 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 06 08 2017   grade_8 120 2 3 0   2     0   4   72 59                       131 120 2 3 0   2     0   4   72 59                 131
1374066 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_8 115 2 6 0   2     0   2   65 62 *                     127.0 115 2 6 0   2     0   2   65 62                 127
1681314 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_8 106 1 6 2   3     0   1   59 60 *                     119.0 106 1 6 2   3     0   1   59 60                 119
2049139 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_8 128 1 4 0   0     0   2   86 49                       135.0 128 1 4 0   0     0   2   86 49                 135
2239780 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson: Hanson Middle School   Regular School No Middle 06 08 2018   grade_8 130 2 3 0   0     0   2   69 68                       137.0 130 2 3 0   0     0   2   69 68                 137
745018 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2015   grade_8 168 5 8 0   3     0   2   87 99                       186 168 5 8 0   3     0   2   87 99                 186
941839 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2016   grade_8 166 4 2 0   5     2   4   93 90                       183 166 4 2 0   5     2   4   93 90                 183
1132961 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2017   grade_8 194 2 4 1   2     1   4   90 118                       208 194 2 4 1   2     1   4   90 118                 208
1374062 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2020   grade_8 146 10 11 2   2     0   6   102 75 *                     177.0 146 10 11 2   2     0   6   102 75                 177
1681310 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson - Whitman Middle   Regular School No Middle 06 08 2021   grade_8 159 15 18 0   4     0   7   90 113 *                     203.0 159 15 18 0   4     0   7   90 113                 203
2049135 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2019   grade_8 164 9 11 3   3     1   7   116 82                       198.0 164 9 11 3   3     1   7   116 82                 198
2239776 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson: Whitman Middle   Regular School No Middle 06 08 2018   grade_8 177 6 10 0   2     0   4   115 84                       199.0 177 6 10 0   2     0   4   115 84                 199

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