enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_7", state = "MA" and year = 2015 sorted by multiracial descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 493 ✖

grade ✖

  • grade_7 · 493 ✖
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
737150 737150 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_7 18 133 19 1   2     1   9   106 77                       183 18 133 19 1   2     1   9   106 77                 183
737153 737153 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_7 32 99 32 0   7     0   9   94 85                       179 32 99 32 0   7     0   9   94 85                 179
737294 737294 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2015   grade_7 219 14 14 3   37     0   9   162 134                       296 219 14 14 3   37     0   9   162 134                 296
738294 738294 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_7 113 9 75 0   18     1   9   118 107                       225 113 9 75 0   18     1   9   118 107                 225
738362 738362 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_7 164 10 26 0   4     0   9   108 105                       213 164 10 26 0   4     0   9   108 105                 213
738662 738662 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2015   grade_7 303 1 14 0   8     0   9   176 159                       335 303 1 14 0   8     0   9   176 159                 335
739512 739512 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2015   grade_7 78 38 233 0   49     0   9   214 193                       407 78 38 233 0   49     0   9   214 193                 407
739642 739642 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No 2 07 08 2015   grade_7 210 8 15 0   4     0   9   124 122                       246 210 8 15 0   4     0   9   124 122                 246
740016 740016 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2015   grade_7 192 47 22 1   17     1   9   153 136                       289 192 47 22 1   17     1   9   153 136                 289
740401 740401 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2015   grade_7 152 13 16 1   51     0   9   123 119                       242 152 13 16 1   51     0   9   123 119                 242
740483 740483 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_7 132 4 41 2   4     0   9   95 97                       192 132 4 41 2   4     0   9   95 97                 192
741301 741301 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2015   grade_7 175 9 16 0   0     0   9   112 97                       209 175 9 16 0   0     0   9   112 97                 209
741380 741380 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2015   grade_7 107 9 78 0   6     0   9   110 99                       209 107 9 78 0   6     0   9   110 99                 209
741732 741732 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2015   grade_7 118 2 7 0   2     0   9   63 75                       138 118 2 7 0   2     0   9   63 75                 138
742355 742355 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2015   grade_7 262 3 11 1   10     0   9   150 146                       296 262 3 11 1   10     0   9   150 146                 296
742515 742515 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2015   grade_7 121 4 19 3   9     0   9   76 89                       165 121 4 19 3   9     0   9   76 89                 165
742714 742714 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2015   grade_7 197 4 22 0   2     0   9   116 118                       234 197 4 22 0   2     0   9   116 118                 234
742829 742829 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No 2 06 08 2015   grade_7 216 12 49 0   15     0   9   156 145                       301 216 12 49 0   15     0   9   156 145                 301
742882 742882 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 07 08 2015   grade_7 375 19 39 2   30     0   9   241 233                       474 375 19 39 2   30     0   9   241 233                 474
735906 735906 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2015   grade_7 90 6 24 0   3     0   8   64 67                       131 90 6 24 0   3     0   8   64 67                 131
737156 737156 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_7 69 95 32 1   8     2   8   113 102                       215 69 95 32 1   8     2   8   113 102                 215
737203 737203 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   grade_7 46 12 5 0   8     0   8   37 42                       79 46 12 5 0   8     0   8   37 42                 79
737241 737241 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2015   grade_7 23 7 7 0   9     0   8   30 24                       54 23 7 7 0   9     0   8   30 24                 54
737660 737660 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_7 174 7 8 0   13     0   8   103 107                       210 174 7 8 0   13     0   8   103 107                 210
738171 738171 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_7 39 13 74 0   14     0   8   68 80                       148 39 13 74 0   14     0   8   68 80                 148
738181 738181 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_7 44 7 47 0   6     0   8   66 46                       112 44 7 47 0   6     0   8   66 46                 112
738677 738677 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2015   grade_7 66 21 5 1   3     0   8   52 52                       104 66 21 5 1   3     0   8   52 52                 104
738700 738700 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2015   grade_7 216 1 4 0   14     0   8   134 109                       243 216 1 4 0   14     0   8   134 109                 243
739675 739675 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_7 177 6 115 1   10     0   8   158 159                       317 177 6 115 1   10     0   8   158 159                 317
739928 739928 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No 2 06 08 2015   grade_7 230 3 9 6   0     0   8   128 128                       256 230 3 9 6   0     0   8   128 128                 256
740398 740398 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2015   grade_7 108 18 12 0   22     0   8   75 93                       168 108 18 12 0   22     0   8   75 93                 168
742247 742247 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2015   grade_7 200 24 32 0   4     0   8   136 132                       268 200 24 32 0   4     0   8   136 132                 268
742311 742311 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2015   grade_7 132 0 6 0   12     0   8   76 82                       158 132 0 6 0   12     0   8   76 82                 158
743507 743507 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_7 101 5 3 0   30     0   8   85 62                       147 101 5 3 0   30     0   8   85 62                 147
743577 743577 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_7 31 35 56 0   6     0   8   67 69                       136 31 35 56 0   6     0   8   67 69                 136
744229 744229 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No 2 06 08 2015   grade_7 150 4 9 0   10     0   8   90 91                       181 150 4 9 0   10     0   8   90 91                 181
744763 744763 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2015   grade_7 101 7 7 1   1     0   8   71 54                       125 101 7 7 1   1     0   8   71 54                 125
744854 744854 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No 2 07 08 2015   grade_7 252 2 16 1   3     0   8   132 150                       282 252 2 16 1   3     0   8   132 150                 282
736977 736977 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_7 167 3 6 0   4     0   7   92 95                       187 167 3 6 0   4     0   7   92 95                 187
737729 737729 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2015   grade_7 297 3 8 1   12     0   7   187 141                       328 297 3 8 1   12     0   7   187 141                 328
737820 737820 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No 2 06 08 2015   grade_7 280 16 22 1   12     0   7   182 156                       338 280 16 22 1   12     0   7   182 156                 338
738341 738341 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_7 141 1 2 0   8     2   7   81 80                       161 141 1 2 0   8     2   7   81 80                 161
738419 738419 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_7 171 3 15 0   4     3   7   95 108                       203 171 3 15 0   4     3   7   95 108                 203
739333 739333 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2015   grade_7 38 8 42 0   46     1   7   65 77                       142 38 8 42 0   46     1   7   65 77                 142
739373 739373 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2015   grade_7 169 3 17 0   2     0   7   97 101                       198 169 3 17 0   2     0   7   97 101                 198
739954 739954 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 07 2015   grade_7 229 9 58 6   7     0   7   157 159                       316 229 9 58 6   7     0   7   157 159                 316
740608 740608 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_7 159 0 11 0   2     0   7   93 86                       179 159 0 11 0   2     0   7   93 86                 179
741015 741015 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No 2 05 08 2015   grade_7 217 2 4 0   2     0   7   119 113                       232 217 2 4 0   2     0   7   119 113                 232
741126 741126 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2015   grade_7 34 5 4 0   27     0   7   44 33                       77 34 5 4 0   27     0   7   44 33                 77
741969 741969 MA Hampden   school 2511130 281   Springfield 251113001660 2810340 Van Sickle Middle School   Regular School No 2 06 08 2015   grade_7 43 53 187 1   6     1   7   151 147                       298 43 53 187 1   6     1   7   151 147                 298
742093 742093 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2015   grade_7 198 60 24 0   20     1   7   166 144                       310 198 60 24 0   20     1   7   166 144                 310
742236 742236 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2015   grade_7 180 24 14 0   2     0   7   122 105                       227 180 24 14 0   2     0   7   122 105                 227
742322 742322 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2015   grade_7 125 1 4 2   3     0   7   82 60                       142 125 1 4 2   3     0   7   82 60                 142
742448 742448 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No 2 06 08 2015   grade_7 93 16 79 1   5     0   7   111 90                       201 93 16 79 1   5     0   7   111 90                 201
743913 743913 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes 2 05 07 2015   grade_7 4 17 47 0   1     0   7   37 39                       76 4 17 47 0   1     0   7   37 39                 76
744125 744125 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2015   grade_7 152 5 4 0   5     1   7   92 82                       174 152 5 4 0   5     1   7   92 82                 174
744466 744466 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No 2 07 08 2015   grade_7 306 0 8 1   5     0   7   162 165                       327 306 0 8 1   5     0   7   162 165                 327
735793 735793 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2015   grade_7 159 3 11 0   13     0   6   107 85                       192 159 3 11 0   13     0   6   107 85                 192
735902 735902 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_7 109 2 25 2   6     1   6   72 79                       151 109 2 25 2   6     1   6   72 79                 151
735985 735985 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2015   grade_7 127 14 9 0   21     0   6   87 90                       177 127 14 9 0   21     0   6   87 90                 177
736160 736160 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No 2 06 08 2015   grade_7 196 2 6 0   13     0   6   114 109                       223 196 2 6 0   13     0   6   114 109                 223
737097 737097 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_7 16 65 27 1   0     0   6   52 63                       115 16 65 27 1   0     0   6   52 63                 115
737147 737147 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2015   grade_7 29 80 14 0   4     0   6   81 52                       133 29 80 14 0   4     0   6   81 52                 133
737162 737162 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2015   grade_7 58 97 54 1   5     0   6   108 113                       221 58 97 54 1   5     0   6   108 113                 221
737194 737194 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_7 42 3 4 0   23     0   6   37 41                       78 42 3 4 0   23     0   6   37 41                 78
737232 737232 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2015   grade_7 34 4 4 0   9     0   6   27 30                       57 34 4 4 0   9     0   6   27 30                 57
737250 737250 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2015   grade_7 37 4 6 0   18     0   6   35 36                       71 37 4 6 0   18     0   6   35 36                 71
737396 737396 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2015   grade_7 41 24 12 0   12     0   6   48 47                       95 41 24 12 0   12     0   6   48 47                 95
737399 737399 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2015   grade_7 40 28 11 1   14     0   6   49 51                       100 40 28 11 1   14     0   6   49 51                 100
737440 737440 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   grade_7 57 1 4 0   7     0   6   32 43                       75 57 1 4 0   7     0   6   32 43                 75
737588 737588 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Fairview Middle   Regular School No 2 06 08 2015   grade_7 147 7 63 0   4     0   6   115 112                       227 147 7 63 0   4     0   6   115 112                 227
737853 737853 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_7 177 8 3 0   1     0   6   83 112                       195 177 8 3 0   1     0   6   83 112                 195
737925 737925 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2015   grade_7 240 11 12 1   5     0   6   142 133                       275 240 11 12 1   5     0   6   142 133                 275
739180 739180 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2015   grade_7 43 7 6 0   2     0   6   35 29                       64 43 7 6 0   2     0   6   35 29                 64
739515 739515 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2015   grade_7 93 16 71 1   28     0   6   104 111                       215 93 16 71 1   28     0   6   104 111                 215
739576 739576 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2015   grade_7 28 16 28 0   22     0   6   54 46                       100 28 16 28 0   22     0   6   54 46                 100
739725 739725 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_7 101 6 4 5   5     0   6   66 61                       127 101 6 4 5   5     0   6   66 61                 127
739765 739765 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2015   grade_7 191 2 5 1   11     0   6   111 105                       216 191 2 5 1   11     0   6   111 105                 216
739800 739800 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No 2 06 08 2015   grade_7 101 19 10 0   9     0   6   68 77                       145 101 19 10 0   9     0   6   68 77                 145
739826 739826 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2015   grade_7 197 2 6 2   3     0   6   121 95                       216 197 2 6 2   3     0   6   121 95                 216
740737 740737 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_7 28 1 3 0   1     0   6   15 24                       39 28 1 3 0   1     0   6   15 24                 39
741225 741225 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2015   grade_7 89 9 75 2   4     0   6   91 94                       185 89 9 75 2   4     0   6   91 94                 185
741254 741254 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No 2 06 08 2015   grade_7 54 4 87 0   10     0   6   76 85                       161 54 4 87 0   10     0   6   76 85                 161
742634 742634 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No 2 07 08 2015   grade_7 175 6 12 0   69     0   6   145 123                       268 175 6 12 0   69     0   6   145 123                 268
742751 742751 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2015   grade_7 180 1 2 0   52     0   6   132 109                       241 180 1 2 0   52     0   6   132 109                 241
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
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
743753 743753 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_7 76 17 6 2   14     0   6   47 74                       121 76 17 6 2   14     0   6   47 74                 121
743873 743873 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_7 80 5 8 0   1     0   6   36 64                       100 80 5 8 0   1     0   6   36 64                 100
744260 744260 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_7 168 8 1 1   8     0   6   90 102                       192 168 8 1 1   8     0   6   90 102                 192
744408 744408 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No 2 06 08 2015   grade_7 142 3 5 0   10     0   6   76 90                       166 142 3 5 0   10     0   6   76 90                 166
735728 735728 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_7 174 4 7 0   2     0   5   94 98                       192 174 4 7 0   2     0   5   94 98                 192
735944 735944 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2015   grade_7 29 16 7 0   5     0   5   35 27                       62 29 16 7 0   5     0   5   35 27                 62
736157 736157 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2015   grade_7 237 5 15 0   8     0   5   146 124                       270 237 5 15 0   8     0   5   146 124                 270
736278 736278 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_7 1 42 14 0   0     0   5   30 32                       62 1 42 14 0   0     0   5   30 32                 62
736417 736417 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2015   grade_7 11 76 90 0   17     0   5   112 87                       199 11 76 90 0   17     0   5   112 87                 199
736888 736888 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_7 15 39 61 1   28     0   5   66 83                       149 15 39 61 1   28     0   5   66 83                 149
737213 737213 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2015   grade_7 35 3 6 0   15     0   5   31 33                       64 35 3 6 0   15     0   5   31 33                 64
737393 737393 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No 2 06 08 2015   grade_7 20 35 11 1   7     0   5   35 44                       79 20 35 11 1   7     0   5   35 44                 79
737585 737585 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_7 155 9 131 0   2     0   5   156 146                       302 155 9 131 0   2     0   5   156 146                 302

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