enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by asian descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 491 ✖

grade ✖

  • grade_7 · 491 ✖
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
936004 936004 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2016   grade_7 130 14 10 1   95     0   14   130 134                       264 130 14 10 1   95     0   14   130 134                 264
932893 932893 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_7 168 3 4 0   9     0   3   111 76                       187 168 3 4 0   9     0   3   111 76                 187
932982 932982 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2016   grade_7 266 11 33 0   9     0   9   173 155                       328 266 11 33 0   9     0   9   173 155                 328
934063 934063 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_7 53 5 10 0   9     0   8   45 40                       85 53 5 10 0   9     0   8   45 40                 85
934083 934083 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2016   grade_7 38 2 4 0   9     0   1   22 32                       54 38 2 4 0   9     0   1   22 32                 54
934250 934250 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2016   grade_7 34 27 11 1   9     1   2   44 41                       85 34 27 11 1   9     1   2   44 41                 85
934445 934445 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_7 160 8 97 1   9     0   8   144 139                       283 160 8 97 1   9     0   8   144 139                 283
934778 934778 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_7 247 18 11 0   9     0   6   134 157                       291 247 18 11 0   9     0   6   134 157                 291
936041 936041 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2016   grade_7 100 0 3 1   9     0   2   47 68                       115 100 0 3 1   9     0   2   47 68                 115
936060 936060 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2016   grade_7 77 5 5 0   9     0   5   55 46                       101 77 5 5 0   9     0   5   55 46                 101
936070 936070 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_7 99 1 5 1   9     0   4   58 61                       119 99 1 5 1   9     0   4   58 61                 119
936709 936709 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No 2 06 08 2016   grade_7 233 15 5 0   9     0   7   126 143                       269 233 15 5 0   9     0   7   126 143                 269
936934 936934 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No 2 05 08 2016   grade_7 140 3 4 0   9     0   12   86 82                       168 140 3 4 0   9     0   12   86 82                 168
938218 938218 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No 2 07 08 2016   grade_7 222 1 2 3   9     1   1   123 116                       239 222 1 2 3   9     1   1   123 116                 239
938774 938774 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No 2 06 08 2016   grade_7 26 54 119 0   9     0   3   104 107                       211 26 54 119 0   9     0   3   104 107                 211
939253 939253 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_7 99 22 48 0   9     0   2   88 92                       180 99 22 48 0   9     0   2   88 92                 180
940738 940738 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_7 27 5 3 0   9     0   8   18 34                       52 27 5 3 0   9     0   8   18 34                 52
937947 937947 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_7 119 5 6 0   89     1   6   117 109                       226 119 5 6 0   89     1   6   117 109                 226
938338 938338 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No 2 06 08 2016   grade_7 165 14 12 0   83     1   10   155 130                       285 165 14 12 0   83     1   10   155 130                 285
933026 933026 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2016   grade_7 172 5 7 0   8     0   2   105 89                       194 172 5 7 0   8     0   2   105 89                 194
933652 933652 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2016   grade_7 16 11 86 0   8     0   0   63 58                       121 16 11 86 0   8     0   0   63 58                 121
934300 934300 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_7 55 0 0 0   8     0   5   37 31                       68 55 0 0 0   8     0   5   37 31                 68
934848 934848 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2016   grade_7 30 18 30 0   8     0   3   40 49                       89 30 18 30 0   8     0   3   40 49                 89
934959 934959 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2016   grade_7 126 14 37 0   8     1   15   111 90                       201 126 14 37 0   8     1   15   111 90                 201
934962 934962 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2016   grade_7 161 10 46 0   8     0   8   122 111                       233 161 10 46 0   8     0   8   122 111                 233
935508 935508 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_7 342 5 4 0   8     0   6   173 192                       365 342 5 4 0   8     0   6   173 192                 365
936026 936026 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2016   grade_7 45 7 7 0   8     0   5   28 44                       72 45 7 7 0   8     0   5   28 44                 72
937478 937478 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No 2 06 08 2016   grade_7 188 4 3 0   8     0   5   103 105                       208 188 4 3 0   8     0   5   103 105                 208
938865 938865 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No 2 05 08 2016   grade_7 171 4 15 0   8     0   7   101 104                       205 171 4 15 0   8     0   7   101 104                 205
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
940344 940344 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_7 80 3 6 0   8     0   3   51 49                       100 80 3 6 0   8     0   3   51 49                 100
937941 937941 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2016   grade_7 69 7 4 2   79     0   3   75 89                       164 69 7 4 2   79     0   3   75 89                 164
936007 936007 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_7 147 5 10 1   78     0   13   134 120                       254 147 5 10 1   78     0   13   134 120                 254
939442 939442 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No 2 07 08 2016   grade_7 203 4 19 1   78     1   10   181 135                       316 203 4 19 1   78     1   10   181 135                 316
934022 934022 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2016   grade_7 63 91 51 2   7     0   10   111 113                       224 63 91 51 2   7     0   10   111 113                 224
934448 934448 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No 2 06 08 2016   grade_7 151 6 83 1   7     0   7   142 113                       255 151 6 83 1   7     0   7   142 113                 255
935005 935005 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2016   grade_7 233 10 7 4   7     0   19   136 144                       280 233 10 7 4   7     0   19   136 144                 280
935025 935025 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_7 53 11 80 0   7     0   16   73 94                       167 53 11 80 0   7     0   16   73 94                 167
935084 935084 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2016   grade_7 177 5 5 0   7     0   2   99 97                       196 177 5 5 0   7     0   2   99 97                 196
935192 935192 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2016   grade_7 141 3 1 0   7     0   1   79 74                       153 141 3 1 0   7     0   1   79 74                 153
935383 935383 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2016   grade_7 214 1 5 0   7     0   0   117 110                       227 214 1 5 0   7     0   0   117 110                 227
935826 935826 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2016   grade_7 16 1 104 0   7     0   1   68 61                       129 16 1 104 0   7     0   1   68 61                 129
936107 936107 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No 1 PK 08 2016   grade_7 29 7 7 0   7     0   2   21 31                       52 29 7 7 0   7     0   2   21 31                 52
936430 936430 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No 1 KG 08 2016   grade_7 27 10 16 0   7     0   0   35 25                       60 27 10 16 0   7     0   0   35 25                 60
936519 936519 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_7 153 5 134 0   7     0   7   163 143                       306 153 5 134 0   7     0   7   163 143                 306
936733 936733 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2016   grade_7 81 4 51 0   7     0   1   69 75                       144 81 4 51 0   7     0   1   69 75                 144
937668 937668 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No 2 06 08 2016   grade_7 357 6 50 0   7     0   9   223 206                       429 357 6 50 0   7     0   9   223 206                 429
938033 938033 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No 2 06 08 2016   grade_7 174 6 4 1   7     0   1   105 88                       193 174 6 4 1   7     0   1   105 88                 193
938200 938200 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2016   grade_7 100 9 63 0   7     0   9   100 88                       188 100 9 63 0   7     0   9   100 88                 188
938250 938250 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No 2 06 08 2016   grade_7 173 4 26 1   7     1   2   117 97                       214 173 4 26 1   7     1   2   117 97                 214
938763 938763 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No 4 06 10 2016   grade_7 35 42 77 0   7     0   1   85 77                       162 35 42 77 0   7     0   1   85 77                 162
939256 939256 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No 2 06 08 2016   grade_7 90 19 73 0   7     0   9   113 85                       198 90 19 73 0   7     0   9   113 85                 198
939523 939523 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2016   grade_7 166 4 19 0   7     0   3   103 96                       199 166 4 19 0   7     0   3   103 96                 199
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
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
940432 940432 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_7 27 49 34 1   7     0   2   54 66                       120 27 49 34 1   7     0   2   54 66                 120
940618 940618 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2016   grade_7 9 64 50 1   7     0   1   66 66                       132 9 64 50 1   7     0   1   66 66                 132
941260 941260 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2016   grade_7 343 9 9 0   7     0   4   191 181                       372 343 9 9 0   7     0   4   191 181                 372
936184 936184 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2016   grade_7 51 10 27 0   69     0   11   88 80                       168 51 10 27 0   69     0   11   88 80                 168
933718 933718 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2016   grade_7 91 51 66 0   64     0   7   121 158                       279 91 51 66 0   64     0   7   121 158                 279
932778 932778 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_7 95 9 17 0   6     2   12   79 62                       141 95 9 17 0   6     2   12   79 62                 141
933783 933783 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_7 15 7 116 0   6     0   2   77 69                       146 15 7 116 0   6     0   2   77 69                 146
933842 933842 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_7 155 3 5 1   6     0   12   103 79                       182 155 3 5 1   6     0   12   103 79                 182
934073 934073 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   grade_7 39 2 5 0   6     0   5   27 30                       57 39 2 5 0   6     0   5   27 30                 57
935195 935195 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2016   grade_7 143 4 6 1   6     0   4   92 72                       164 143 4 6 1   6     0   4   92 72                 164
935911 935911 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_7 52 0 4 0   6     0   2   35 29                       64 52 0 4 0   6     0   2   35 29                 64
936399 936399 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2016   grade_7 170 1 10 0   6     0   5   90 102                       192 170 1 10 0   6     0   5   90 102                 192
937319 937319 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_7 145 7 33 0   6     0   11   96 106                       202 145 7 33 0   6     0   11   96 106                 202
937496 937496 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2016   grade_7 192 2 4 0   6     1   3   114 94                       208 192 2 4 0   6     1   3   114 94                 208
937774 937774 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2016   grade_7 147 20 26 1   6     0   9   108 101                       209 147 20 26 1   6     0   9   108 101                 209
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
941210 941210 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No 2 06 08 2016   grade_7 123 3 3 0   6     0   3   74 64                       138 123 3 3 0   6     0   3   74 64                 138
941508 941508 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No 2 07 08 2016   grade_7 227 4 3 0   6     0   4   121 123                       244 227 4 3 0   6     0   4   121 123                 244
932927 932927 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2016   grade_7 226 11 8 1   54     0   22   155 167                       322 226 11 8 1   54     0   22   155 167                 322
939554 939554 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2016   grade_7 143 3 1 2   51     0   5   94 111                       205 143 3 1 2   51     0   5   94 111                 205
939557 939557 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2016   grade_7 185 1 6 0   51     0   9   127 125                       252 185 1 6 0   51     0   9   127 125                 252
937237 937237 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2016   grade_7 169 9 13 1   50     0   12   142 112                       254 169 9 13 1   50     0   12   142 112                 254
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
932774 932774 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_7 142 6 15 0   5     0   4   85 87                       172 142 6 15 0   5     0   4   85 87                 172
932874 932874 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No 2 07 08 2016   grade_7 185 4 3 0   5     0   4   107 94                       201 185 4 3 0   5     0   4   107 94                 201
934016 934016 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2016   grade_7 55 124 28 0   5     2   10   113 111                       224 55 124 28 0   5     2   10   113 111                 224
934492 934492 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_7 134 5 0 0   5     0   0   72 72                       144 134 5 0 0   5     0   0   72 72                 144
934561 934561 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2016   grade_7 243 5 21 0   5     0   8   146 136                       282 243 5 21 0   5     0   8   146 136                 282
934693 934693 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No 2 06 08 2016   grade_7 242 1 7 0   5     0   5   135 125                       260 242 1 7 0   5     0   5   135 125                 260
934878 934878 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2016   grade_7 126 1 7 2   5     0   1   79 63                       142 126 1 7 2   5     0   1   79 63                 142
935523 935523 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_7 62 11 15 0   5     0   2   52 43                       95 62 11 15 0   5     0   2   52 43                 95
935818 935818 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No 2 06 08 2016   grade_7 11 0 138 0   5     0   0   73 81                       154 11 0 138 0   5     0   0   73 81                 154
936486 936486 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No 2 07 08 2016   grade_7 216 6 19 0   5     0   9   125 130                       255 216 6 19 0   5     0   9   125 130                 255
936798 936798 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_7 209 9 72 6   5     0   10   163 148                       311 209 9 72 6   5     0   10   163 148                 311
936830 936830 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2016   grade_7 100 0 2 0   5     1   3   74 37                       111 100 0 2 0   5     1   3   74 37                 111
937135 937135 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No 2 06 08 2016   grade_7 176 0 2 0   5     0   4   94 93                       187 176 0 2 0   5     0   4   94 93                 187
937594 937594 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2016   grade_7 127 1 8 0   5     0   2   76 67                       143 127 1 8 0   5     0   2   76 67                 143
937847 937847 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2016   grade_7 280 7 10 1   5     0   19   160 162                       322 280 7 10 1   5     0   19   160 162                 322
938030 938030 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2016   grade_7 151 2 2 0   5     0   5   85 80                       165 151 2 2 0   5     0   5   85 80                 165
938312 938312 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No 2 06 08 2016   grade_7 163 1 8 0   5     0   2   90 89                       179 163 1 8 0   5     0   2   90 89                 179
938476 938476 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2016   grade_7 11 5 24 0   5     0   0   20 25                       45 11 5 24 0   5     0   0   20 25                 45
940400 940400 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_7 47 28 41 0   5     0   7   60 68                       128 47 28 41 0   5     0   7   60 68                 128
940651 940651 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_7 34 6 27 0   5     0   0   31 41                       72 34 6 27 0   5     0   0   31 41                 72
940917 940917 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_7 76 1 1 0   5     0   3   44 42                       86 76 1 1 0   5     0   3   44 42                 86
941429 941429 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2016   grade_7 82 0 1 0   5     0   0   58 30                       88 82 0 1 0   5     0   0   58 30                 88

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