enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
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
2230210 2230210 MA Suffolk   school   35   Boston   350652               2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
743368 743368 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2015   grade_7 78 74 157 0   29     0   17   175 180                       355 78 74 157 0   29     0   17   175 180                 355
940177 940177 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_7 82 74 167 1   28     0   23   198 177                       375 82 74 167 1   28     0   23   198 177                 375
1131038 1131038 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_7 84 60 190 0   22     0   9   193 172                       365 84 60 190 0   22     0   9   193 172                 365
1372388 1372388 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_7 70 62 187 0   19     1   14   175 178 *                     353.0 70 62 187 0   19     1   14   175 178                 353
1679651 1679651 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester - Worcester East Middle   Regular School No Middle 07 08 2021   grade_7 102 79 168 0   17     0   18   201 183 *                     384.0 102 79 168 0   17     0   18   201 183                 384
2047461 2047461 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2019   grade_7 64 75 189 1   38     0   17   196 188                       384.0 64 75 189 1   38     0   17   196 188                 384
2237863 2237863 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_7 78 69 204 0   22     0   17   196 194                       390.0 78 69 204 0   22     0   17   196 194                 390
743371 743371 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2015   grade_7 95 69 175 0   50     0   17   198 208                       406 95 69 175 0   50     0   17   198 208                 406
940180 940180 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_7 114 61 168 1   41     0   15   216 184                       400 114 61 168 1   41     0   15   216 184                 400
1131042 1131042 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_7 103 57 181 1   49     0   22   209 204                       413 103 57 181 1   49     0   22   209 204                 413
1372391 1372391 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2020   grade_7 134 67 168 2   42     0   17   226 204 *                     430.0 134 67 168 2   42     0   17   226 204                 430
1679654 1679654 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester - Sullivan Middle   Regular School No Middle 06 08 2021   grade_7 136 67 182 1   35     0   23   224 220 *                     444.0 136 67 182 1   35     0   23   224 220                 444
2047464 2047464 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2019   grade_7 106 67 191 0   44     0   16   207 217                       424.0 106 67 191 0   44     0   16   207 217                 424
2237867 2237867 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_7 92 67 210 1   38     0   16   226 198                       424.0 92 67 210 1   38     0   16   226 198                 424
743365 743365 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2015   grade_7 241 52 143 0   24     0   28   267 221                       488 241 52 143 0   24     0   28   267 221                 488
940174 940174 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_7 235 53 145 1   33     0   26   255 238                       493 235 53 145 1   33     0   26   255 238                 493
1131034 1131034 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2017   grade_7 219 58 163 0   31     0   21   262 230                       492 219 58 163 0   31     0   21   262 230                 492
1372386 1372386 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2020   grade_7 168 71 167 2   29     0   24   236 225 *                     461.0 168 71 167 2   29     0   24   236 225                 461
1679649 1679649 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester - Forest Grove Middle   Regular School No Middle 07 08 2021   grade_7 206 63 145 0   20     0   24   229 229 *                     458.0 206 63 145 0   20     0   24   229 229                 458
2047459 2047459 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2019   grade_7 189 70 160 1   33     0   21   247 227                       474.0 189 70 160 1   33     0   21   247 227                 474
2237859 2237859 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   grade_7 199 65 173 1   23     0   25   238 248                       486.0 199 65 173 1   23     0   25   238 248                 486
743363 743363 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2015   grade_7 105 59 108 2   9     0   6   132 157                       289 105 59 108 2   9     0   6   132 157                 289
940172 940172 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2016   grade_7 74 49 120 1   8     0   14   127 139                       266 74 49 120 1   8     0   14   127 139                 266
1131031 1131031 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_7 105 31 120 0   14     0   25   161 134                       295 105 31 120 0   14     0   25   161 134                 295
1372384 1372384 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2020   grade_7 106 57 161 0   15     0   22   188 173 *                     361.0 106 57 161 0   15     0   22   188 173                 361
1679647 1679647 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester - Burncoat Middle School   Regular School No Middle 07 08 2021   grade_7 118 56 128 0   19     0   16   161 176 *                     337.0 118 56 128 0   19     0   16   161 176                 337
2047457 2047457 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2019   grade_7 123 68 149 1   12     0   9   186 176                       362.0 123 68 149 1   12     0   9   186 176                 362
2237856 2237856 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_7 108 64 138 0   9     0   16   153 182                       335.0 108 64 138 0   9     0   16   153 182                 335
743357 743357 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_7 7 9 80 0   8     0   3   49 58                       107 7 9 80 0   8     0   3   49 58                 107
940166 940166 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2016   grade_7 3 4 60 0   6     0   1   44 30                       74 3 4 60 0   6     0   1   44 30                 74
1131024 1131024 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2017   grade_7 7 7 63 0   8     0   1   39 47                       86 7 7 63 0   8     0   1   39 47                 86
1372378 1372378 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_7 8 12 74 1   10     0   4   54 55 *                     109.0 8 12 74 1   10     0   4   54 55                 109
1679641 1679641 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_7 11 9 70 0   8     0   0   47 51 *                     98.0 11 9 70 0   8     0   0   47 51                 98
2047451 2047451 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_7 5 12 78 0   9     0   4   57 51                       108.0 5 12 78 0   9     0   4   57 51                 108
2237849 2237849 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_7 4 5 70 0   7     0   0   46 40                       86.0 4 5 70 0   7     0   0   46 40                 86
743351 743351 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2015   grade_7 5 1 30 0   6     0   2   24 20                       44 5 1 30 0   6     0   2   24 20                 44
940160 940160 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2016   grade_7 3 5 24 0   12     0   1   21 24                       45 3 5 24 0   12     0   1   21 24                 45
1131017 1131017 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2017   grade_7 4 4 29 0   9     0   1   30 17                       47 4 4 29 0   9     0   1   30 17                 47
1372372 1372372 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2020   grade_7 8 5 20 1   6     0   5   21 24 *                     45.0 8 5 20 1   6     0   5   21 24                 45
1679635 1679635 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester - University Pk Campus School   Regular School No High 07 12 2021   grade_7 4 5 26 1   4     0   0   20 20 *                     40.0 4 5 26 1   4     0   0   20 20                 40
2047445 2047445 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2019   grade_7 7 7 24 0   5     0   1   22 22                       44.0 7 7 24 0   5     0   1   22 22                 44
2237842 2237842 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_7 4 7 21 0   10     0   2   21 23                       44.0 4 7 21 0   10     0   2   21 23                 44
743090 743090 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_7 140 10 13 0   9     0   2   85 89                       174 140 10 13 0   9     0   2   85 89                 174
939899 939899 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_7 128 15 11 0   7     0   0   80 81                       161 128 15 11 0   7     0   0   80 81                 161
1130719 1130719 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_7 141 13 18 2   13     0   3   93 97                       190 141 13 18 2   13     0   3   93 97                 190
1372114 1372114 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_7 123 13 17 0   13     0   4   78 92 *                     170.0 123 13 17 0   13     0   4   78 92                 170
1679375 1679375 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 94 19 10 0   13     2   6   71 73 *                     144.0 94 19 10 0   13     2   6   71 73                 144
2047187 2047187 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_7 109 9 16 1   9     0   6   71 79                       150.0 109 9 16 1   9     0   6   71 79                 150
2237547 2237547 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_7 112 10 10 3   10     0   2   68 79                       147.0 112 10 10 3   10     0   2   68 79                 147
743093 743093 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2015   grade_7 135 13 16 0   9     1   6   87 93                       180 135 13 16 0   9     1   6   87 93                 180
939902 939902 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2016   grade_7 127 7 13 0   7     0   3   81 76                       157 127 7 13 0   7     0   3   81 76                 157
1130723 1130723 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_7 146 10 12 2   10     1   5   93 93                       186 146 10 12 2   10     1   5   93 93                 186
1372117 1372117 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2020   grade_7 142 18 28 0   9     0   8   102 103 *                     205.0 142 18 28 0   9     0   8   102 103                 205
1679378 1679378 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_7 134 8 26 1   6     0   8   106 77 *                     183.0 134 8 26 1   6     0   8   106 77                 183
2047190 2047190 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_7 130 14 21 0   8     1   2   88 88                       176.0 130 14 21 0   8     1   2   88 88                 176
2237551 2237551 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn: Daniel L Joyce Middle School   Regular School No Middle 06 08 2018   grade_7 128 8 10 1   7     0   5   83 76                       159.0 128 8 10 1   7     0   5   83 76                 159
1130651 1130651 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2017   grade_7 127 1 20 0   1     0   2   80 71                       151 127 1 20 0   1     0   2   80 71                 151
1372062 1372062 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2020   grade_7 124 3 26 0   1     0   1   69 86 *                     155.0 124 3 26 0   1     0   1   69 86                 155
1679322 1679322 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop - Winthrop Middle School   Regular School No Middle 06 08 2021   grade_7 123 4 30 1   1     0   3   77 85 *                     162.0 123 4 30 1   1     0   3   77 85                 162
2047136 2047136 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2019   grade_7 121 1 35 0   3     0   4   93 71                       164.0 121 1 35 0   3     0   4   93 71                 164
2237479 2237479 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop: Winthrop Middle School   Regular School No Middle 06 08 2018   grade_7 130 0 21 0   1     0   2   80 74                       154.0 130 0 21 0   1     0   2   80 74                 154
743032 743032 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2015   grade_7 138 6 10 0   1     0   0   69 86                       155 138 6 10 0   1     0   0   69 86                 155
939841 939841 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2016   grade_7 144 0 17 0   1     0   1   75 88                       163 144 0 17 0   1     0   1   75 88                 163
743018 743018 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2015   grade_7 264 6 13 1   66     0   15   172 193                       365 264 6 13 1   66     0   15   172 193                 365
939827 939827 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2016   grade_7 306 2 12 1   50     0   9   180 200                       380 306 2 12 1   50     0   9   180 200                 380
1130633 1130633 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2017   grade_7 264 0 14 1   66     1   19   178 187                       365 264 0 14 1   66     1   19   178 187                 365
1372048 1372048 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2020   grade_7 238 3 12 1   64     0   31   175 174 *                     349.0 238 3 12 1   64     0   31   175 174                 349
1679308 1679308 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester - McCall Middle   Regular School No Middle 06 08 2021   grade_7 272 7 9 0   71     0   29   205 183 *                     388.0 272 7 9 0   71     0   29   205 183                 388
2047122 2047122 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_7 281 3 14 2   60     0   17   176 200                       377.0 281 3 14 2   60     0   17   176 200                 377
2237461 2237461 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_7 278 5 13 1   67     0   13   195 182                       377.0 278 5 13 1   67     0   13   195 182                 377
742980 742980 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2015   grade_7 99 1 8 0   8     0   2   53 65                       118 99 1 8 0   8     0   2   53 65                 118
939784 939784 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_7 85 1 8 1   2     0   4   48 53                       101 85 1 8 1   2     0   4   48 53                 101
1130583 1130583 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_7 74 5 9 1   3     0   2   47 47                       94 74 5 9 1   3     0   2   47 47                 94
1372005 1372005 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2020   grade_7 83 3 6 0   5     1   3   51 50 *                     101.0 83 3 6 0   5     1   3   51 50                 101
1679265 1679265 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon - Murdock Middle School   Regular School No Middle 06 08 2021   grade_7 73 1 8 0   0     0   4   41 45 *                     86.0 73 1 8 0   0     0   4   41 45                 86
2047079 2047079 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2019   grade_7 78 1 6 0   0     0   2   42 45                       87.0 78 1 6 0   0     0   2   42 45                 87
2237411 2237411 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon: Murdock Middle School   Regular School No Middle 06 08 2018   grade_7 72 0 6 0   4     0   8   51 39                       90.0 72 0 6 0   4     0   8   51 39                 90
742965 742965 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2015   grade_7 240 4 9 0   9     0   3   139 126                       265 240 4 9 0   9     0   3   139 126                 265
939770 939770 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2016   grade_7 260 4 9 0   15     0   10   146 152                       298 260 4 9 0   15     0   10   146 152                 298
1130564 1130564 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_7 267 5 16 1   11     0   8   161 147                       308 267 5 16 1   11     0   8   161 147                 308
1371991 1371991 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2020   grade_7 227 4 13 0   13     0   5   125 137 *                     262.0 227 4 13 0   13     0   5   125 137                 262
1679251 1679251 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington - Wilmington Middle School   Regular School No Middle 06 08 2021   grade_7 234 3 10 0   13     0   8   143 125 *                     268.0 234 3 10 0   13     0   8   143 125                 268
2047065 2047065 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_7 237 4 10 2   9     0   12   146 128                       274.0 237 4 10 2   9     0   12   146 128                 274
2237392 2237392 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington: Wilmington Middle School   Regular School No Middle 06 08 2018   grade_7 220 5 11 0   10     0   10   131 125                       256.0 220 5 11 0   10     0   10   131 125                 256
745020 745020 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2015   grade_7 135 3 3 0   2     0   5   79 69                       148 135 3 3 0   2     0   5   79 69                 148
941841 941841 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_7 119 3 2 0   2     0   4   72 58                       130 119 3 2 0   2     0   4   72 58                 130
1132964 1132964 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 06 08 2017   grade_7 128 2 2 0   0     0   3   68 67                       135 128 2 2 0   0     0   3   68 67                 135
1374065 1374065 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_7 106 1 6 1   3     0   1   59 59 *                     118.0 106 1 6 1   3     0   1   59 59                 118
1681313 1681313 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 7 0   1     0   4   58 58 *                     116.0 104 0 7 0   1     0   4   58 58                 116
2049138 2049138 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_7 115 2 4 0   2     0   1   66 58                       124.0 115 2 4 0   2     0   1   66 58                 124
2239779 2239779 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson: Hanson Middle School   Regular School No Middle 06 08 2018   grade_7 125 1 4 0   0     0   1   83 48                       131.0 125 1 4 0   0     0   1   83 48                 131
745017 745017 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2015   grade_7 162 7 2 0   5     2   3   92 89                       181 162 7 2 0   5     2   3   92 89                 181
941838 941838 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2016   grade_7 200 1 3 1   2     1   4   93 119                       212 200 1 3 1   2     1   4   93 119                 212
1132960 1132960 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2017   grade_7 177 5 8 0   2     0   3   111 84                       195 177 5 8 0   2     0   3   111 84                 195
1374061 1374061 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2020   grade_7 162 16 16 0   3     0   8   88 117 *                     205.0 162 16 16 0   3     0   8   88 117                 205
1681309 1681309 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson - Whitman Middle   Regular School No Middle 06 08 2021   grade_7 161 8 12 2   2     0   8   98 95 *                     193.0 161 8 12 2   2     0   8   98 95                 193
2049134 2049134 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2019   grade_7 149 9 10 2   1     0   6   98 79                       177.0 149 9 10 2   1     0   6   98 79                 177
2239775 2239775 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson: Whitman Middle   Regular School No Middle 06 08 2018   grade_7 162 9 10 3   3     1   7   112 83                       195.0 162 9 10 3   3     1   7   112 83                 195
1371954 1371954 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_7 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3

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