enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by multiracial 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
932782 932782 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_7 86 9 30 0   11     0   9   73 72                       145 86 9 30 0   11     0   9   73 72                 145
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
934007 934007 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2016   grade_7 21 123 24 0   1     2   9   98 82                       180 21 123 24 0   1     2   9   98 82                 180
934013 934013 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_7 48 101 22 1   10     0   9   108 83                       191 48 101 22 1   10     0   9   108 83                 191
934110 934110 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2016   grade_7 37 10 12 0   13     0   9   41 40                       81 37 10 12 0   13     0   9   41 40                 81
934154 934154 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2016   grade_7 216 9 8 1   29     0   9   147 125                       272 216 9 8 1   29     0   9   147 125                 272
934617 934617 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2016   grade_7 166 16 27 1   4     0   9   116 107                       223 166 16 27 1   4     0   9   116 107                 223
935035 935035 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_7 35 8 58 0   3     0   9   58 55                       113 35 8 58 0   3     0   9   58 55                 113
936363 936363 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2016   grade_7 92 12 65 1   21     0   9   112 88                       200 92 12 65 1   21     0   9   112 88                 200
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
936863 936863 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2016   grade_7 207 49 13 1   21     1   9   163 138                       301 207 49 13 1   21     1   9   163 138                 301
937234 937234 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2016   grade_7 93 15 13 1   28     1   9   80 80                       160 93 15 13 1   28     1   9   80 80                 160
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
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
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
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
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
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
940961 940961 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No 2 07 08 2016   grade_7 226 11 4 0   2     0   9   121 131                       252 226 11 4 0   2     0   9   121 131                 252
941291 941291 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No 2 07 08 2016   grade_7 299 2 4 1   14     1   9   154 176                       330 299 2 4 1   14     1   9   154 176                 330
941782 941782 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2016   grade_7 240 4 14 1   17     0   9   131 154                       285 240 4 14 1   17     0   9   131 154                 285
932586 932586 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No 2 07 08 2016   grade_7 271 2 23 0   1     0   8   141 164                       305 271 2 23 0   1     0   8   141 164                 305
932740 932740 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_7 150 4 25 0   18     0   8   98 107                       205 150 4 25 0   18     0   8   98 107                 205
934019 934019 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2016   grade_7 67 64 11 0   1     0   8   73 78                       151 67 64 11 0   1     0   8   73 78                 151
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
934259 934259 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2016   grade_7 31 22 6 2   10     0   8   47 32                       79 31 22 6 2   10     0   8   47 32                 79
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
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
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
935045 935045 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_7 26 5 36 0   3     0   8   32 46                       78 26 5 36 0   3     0   8   32 46                 78
935295 935295 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2016   grade_7 176 4 9 0   23     0   8   107 113                       220 176 4 9 0   23     0   8   107 113                 220
935948 935948 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2016   grade_7 160 17 88 0   10     0   8   155 128                       283 160 17 88 0   10     0   8   155 128                 283
937357 937357 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2016   grade_7 329 9 32 1   32     0   8   216 195                       411 329 9 32 1   32     0   8   216 195                 411
937992 937992 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2016   grade_7 29 113 37 0   41     1   8   123 106                       229 29 113 37 0   41     1   8   123 106                 229
939045 939045 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2016   grade_7 156 34 32 0   4     0   8   108 126                       234 156 34 32 0   4     0   8   108 126                 234
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
941580 941580 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No 2 07 08 2016   grade_7 202 1 7 0   2     0   8   101 119                       220 202 1 7 0   2     0   8   101 119                 220
941589 941589 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2016   grade_7 88 6 14 0   3     0   8   60 59                       119 88 6 14 0   3     0   8   60 59                 119
932859 932859 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2016   grade_7 112 7 15 0   13     0   7   79 75                       154 112 7 15 0   13     0   7   79 75                 154
933431 933431 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_7 9 26 46 0   3     0   7   60 31                       91 9 26 46 0   3     0   7   60 31                 91
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
934092 934092 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2016   grade_7 27 3 3 0   21     0   7   30 31                       61 27 3 3 0   21     0   7   30 31                 61
934101 934101 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_7 29 4 8 0   10     0   7   33 25                       58 29 4 8 0   10     0   7   33 25                 58
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
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
936609 936609 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2016   grade_7 178 1 4 0   10     0   7   105 95                       200 178 1 4 0   10     0   7   105 95                 200
936647 936647 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No 2 06 08 2016   grade_7 88 20 25 0   18     0   7   84 74                       158 88 20 25 0   18     0   7   84 74                 158
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
937551 937551 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No 2 06 08 2016   grade_7 178 19 23 0   21     0   7   123 125                       248 178 19 23 0   21     0   7   123 125                 248
938143 938143 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No 2 06 08 2016   grade_7 70 1 0 0   1     0   7   41 38                       79 70 1 0 0   1     0   7   41 38                 79
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
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
940959 940959 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2016   grade_7 168 4 5 0   4     0   7   86 102                       188 168 4 5 0   4     0   7   86 102                 188
941305 941305 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 04 08 2016   grade_7 180 2 9 0   3     0   7   89 112                       201 180 2 9 0   3     0   7   89 112                 201
941462 941462 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2016   grade_7 107 1 4 0   2     0   7   61 60                       121 107 1 4 0   2     0   7   61 60                 121
941471 941471 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2016   grade_7 133 2 3 1   2     0   7   73 75                       148 133 2 3 1   2     0   7   73 75                 148
932669 932669 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2016   grade_7 149 1 9 0   26     0   6   89 102                       191 149 1 9 0   26     0   6   89 102                 191
933398 933398 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2016   grade_7 12 26 18 0   25     1   6   56 32                       88 12 26 18 0   25     1   6   56 32                 88
934010 934010 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2016   grade_7 13 137 30 0   4     1   6   98 93                       191 13 137 30 0   4     1   6   98 93                 191
934054 934054 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_7 40 3 10 0   25     1   6   48 37                       85 40 3 10 0   25     1   6   48 37                 85
934120 934120 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_7 33 2 7 0   14     0   6   29 33                       62 33 2 7 0   14     0   6   29 33                 62
934344 934344 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2016   grade_7 184 4 7 0   22     0   6   110 113                       223 184 4 7 0   22     0   6   110 113                 223
934519 934519 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2016   grade_7 189 12 11 0   14     0   6   122 110                       232 189 12 11 0   14     0   6   122 110                 232
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
934956 934956 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2016   grade_7 113 13 56 0   13     0   6   94 107                       201 113 13 56 0   13     0   6   94 107                 201
935148 935148 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_7 136 7 58 0   20     0   6   104 123                       227 136 7 58 0   20     0   6   104 123                 227
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
936031 936031 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2016   grade_7 17 11 11 2   1     0   6   23 25                       48 17 11 11 2   1     0   6   23 25                 48
936193 936193 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No 2 05 08 2016   grade_7 32 12 71 0   35     0   6   84 72                       156 32 12 71 0   35     0   6   84 72                 156
936449 936449 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2016   grade_7 26 25 26 0   23     0   6   53 53                       106 26 25 26 0   23     0   6   53 53                 106
937438 937438 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2016   grade_7 174 0 10 0   2     1   6   101 92                       193 174 0 10 0   2     1   6   101 92                 193
937944 937944 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2016   grade_7 89 8 5 1   24     0   6   71 62                       133 89 8 5 1   24     0   6   71 62                 133
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
938085 938085 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No 2 06 08 2016   grade_7 68 6 103 2   4     0   6   86 103                       189 68 6 103 2   4     0   6   86 103                 189
938128 938128 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2016   grade_7 142 8 19 0   0     0   6   90 85                       175 142 8 19 0   0     0   6   90 85                 175
938962 938962 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2016   grade_7 111 3 0 0   3     0   6   66 57                       123 111 3 0 0   3     0   6   66 57                 123
939006 939006 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No 2 06 08 2016   grade_7 151 3 3 0   3     0   6   89 77                       166 151 3 3 0   3     0   6   89 77                 166
939120 939120 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2016   grade_7 121 2 4 1   3     0   6   61 76                       137 121 2 4 1   3     0   6   61 76                 137
939323 939323 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2016   grade_7 137 8 38 2   20     0   6   105 106                       211 137 8 38 2   20     0   6   105 106                 211
940445 940445 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_7 47 40 4 0   14     1   6   60 52                       112 47 40 4 0   14     1   6   60 52                 112
940998 940998 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2016   grade_7 139 1 5 1   2     0   6   79 75                       154 139 1 5 1   2     0   6   79 75                 154
941056 941056 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No 2 06 08 2016   grade_7 149 3 2 1   11     0   6   95 77                       172 149 3 2 1   11     0   6   95 77                 172
941080 941080 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2016   grade_7 180 0 19 0   1     0   6   103 103                       206 180 0 19 0   1     0   6   103 103                 206
941332 941332 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2016   grade_7 116 6 5 1   0     0   6   58 76                       134 116 6 5 1   0     0   6   58 76                 134
932802 932802 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2016   grade_7 181 3 6 1   10     0   5   100 106                       206 181 3 6 1   10     0   5   100 106                 206
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
934256 934256 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2016   grade_7 30 28 14 0   10     0   5   47 40                       87 30 28 14 0   10     0   5   47 40                 87
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
934340 934340 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No 2 05 08 2016   grade_7 151 7 6 0   20     0   5   103 86                       189 151 7 6 0   20     0   5   103 86                 189
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
934707 934707 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_7 171 2 0 1   3     0   5   87 95                       182 171 2 0 1   3     0   5   87 95                 182
934918 934918 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_7 41 6 12 0   4     0   5   31 37                       68 41 6 12 0   4     0   5   31 37                 68
935142 935142 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2016   grade_7 116 16 39 0   2     0   5   93 85                       178 116 16 39 0   2     0   5   93 85                 178
935545 935545 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2016   grade_7 198 1 5 2   15     0   5   113 113                       226 198 1 5 2   15     0   5   113 113                 226
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
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
936205 936205 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2016   grade_7 15 4 43 0   101     0   5   90 78                       168 15 4 43 0   101     0   5   90 78                 168
936220 936220 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2016   grade_7 204 5 15 1   3     2   5   110 125                       235 204 5 15 1   3     2   5   110 125                 235
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
936421 936421 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_7 29 24 20 1   22     0   5   68 33                       101 29 24 20 1   22     0   5   68 33                 101

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