enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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 ▲
1128879 1128879 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2017   grade_7 307 6 50 1   131     0   16   258 253                       511 307 6 50 1   131     0   16   258 253                 511
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
1130463 1130463 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_7 370 34 29 0   23     1   22   248 231                       479 370 34 29 0   23     1   22   248 231                 479
1131734 1131734 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   grade_7 260 8 22 0   151     0   28   236 233                       469 260 8 22 0   151     0   28   236 233                 469
1126486 1126486 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_7 65 43 261 5   57     0   16   226 221                       447 65 43 261 5   57     0   16   226 221                 447
1127219 1127219 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2017   grade_7 352 10 15 2   41     0   25   211 234                       445 352 10 15 2   41     0   25   211 234                 445
1128042 1128042 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2017   grade_7 332 16 69 0   7     0   10   227 207                       434 332 16 69 0   7     0   10   227 207                 434
1126482 1126482 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2017   grade_7 53 41 275 5   35     0   14   223 200                       423 53 41 275 5   35     0   14   223 200                 423
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
1122176 1122176 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_7 302 16 22 0   48     0   21   201 208                       409 302 16 22 0   48     0   21   201 208                 409
1132283 1132283 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2017   grade_7 364 6 14 0   8     0   8   217 182                       400 364 6 14 0   8     0   8   217 182                 400
1122323 1122323 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2017   grade_7 302 34 36 2   8     0   15   200 197                       397 302 34 36 2   8     0   15   200 197                 397
1127377 1127377 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_7 204 31 135 0   4     0   16   205 185                       390 204 31 135 0   4     0   16   205 185                 390
1123360 1123360 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2017   grade_7 169 23 57 0   116     0   21   162 224                       386 169 23 57 0   116     0   21   162 224                 386
1125487 1125487 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_7 340 4 11 0   8     1   11   195 180                       375 340 4 11 0   8     1   11   195 180                 375
1127671 1127671 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2017   grade_7 291 15 34 0   29     1   5   194 181                       375 291 15 34 0   29     1   5   194 181                 375
1127717 1127717 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2017   grade_7 310 6 19 2   23     0   12   193 179                       372 310 6 19 2   23     0   12   193 179                 372
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
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
1130124 1130124 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_7 266 17 18 0   29     0   20   169 181                       350 266 17 18 0   29     0   20   169 181                 350
1122488 1122488 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No Middle 06 08 2017   grade_7 290 12 28 0   8     0   11   199 150                       349 290 12 28 0   8     0   11   199 150                 349
1126723 1126723 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2017   grade_7 330 0 9 0   2     0   6   196 151                       347 330 0 9 0   2     0   6   196 151                 347
1122422 1122422 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_7 243 13 17 0   51     0   19   169 174                       343 243 13 17 0   51     0   19   169 174                 343
1124357 1124357 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2017   grade_7 301 4 8 0   1     0   20   167 167                       334 301 4 8 0   1     0   20   167 167                 334
1129560 1129560 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2017   grade_7 285 6 6 0   19     1   16   188 145                       333 285 6 6 0   19     1   16   188 145                 333
1128250 1128250 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2017   grade_7 295 8 8 0   3     0   14   186 142                       328 295 8 8 0   3     0   14   186 142                 328
1126609 1126609 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2017   grade_7 267 9 10 0   18     0   14   162 156                       318 267 9 10 0   18     0   14   162 156                 318
1126057 1126057 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_7 158 19 11 0   119     0   10   171 146                       317 158 19 11 0   119     0   10   171 146                 317
1127534 1127534 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2017   grade_7 191 20 30 0   54     0   21   176 140                       316 191 20 30 0   54     0   21   176 140                 316
1132320 1132320 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2017   grade_7 290 1 9 0   10     0   6   149 167                       316 290 1 9 0   10     0   6   149 167                 316
1130160 1130160 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2017   grade_7 180 4 21 0   92     0   18   157 158                       315 180 4 21 0   92     0   18   157 158                 315
1129730 1129730 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2017   grade_7 286 6 8 0   10     0   2   132 180                       312 286 6 8 0   10     0   2   132 180                 312
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
1125985 1125985 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2017   grade_7 168 24 84 1   19     0   10   160 146                       306 168 24 84 1   19     0   10   160 146                 306
1128843 1128843 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2017   grade_7 187 10 14 1   80     0   14   160 146                       306 187 10 14 1   80     0   14   160 146                 306
1124466 1124466 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2017   grade_7 231 23 19 0   21     0   7   139 162                       301 231 23 19 0   21     0   7   139 162                 301
1127012 1127012 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_7 204 9 70 1   5     0   10   161 138                       299 204 9 70 1   5     0   10   161 138                 299
1127373 1127373 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_7 124 43 104 2   4     0   19   165 131                       296 124 43 104 2   4     0   19   165 131                 296
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
1124588 1124588 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2017   grade_7 239 17 13 1   11     0   13   147 147                       294 239 17 13 1   11     0   13   147 147                 294
1126677 1126677 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_7 132 9 137 0   3     0   13   163 131                       294 132 9 137 0   3     0   13   163 131                 294
1132769 1132769 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No Middle 07 08 2017   grade_7 262 2 12 0   5     0   12   142 151                       293 262 2 12 0   5     0   12   142 151                 293
1124859 1124859 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_7 229 14 17 4   7     0   19   157 133                       290 229 14 17 4   7     0   19   157 133                 290
1129834 1129834 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_7 252 9 12 0   11     0   6   140 150                       290 252 9 12 0   11     0   6   140 150                 290
1127085 1127085 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2017   grade_7 208 36 15 2   15     2   11   145 144                       289 208 36 15 2   15     2   11   145 144                 289
1129699 1129699 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2017   grade_7 221 22 31 2   3     0   7   142 144                       286 221 22 31 2   3     0   7   142 144                 286
1130397 1130397 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2017   grade_7 195 10 56 1   17     0   7   149 137                       286 195 10 56 1   17     0   7   149 137                 286
1126061 1126061 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_7 150 13 4 0   95     0   19   129 152                       281 150 13 4 0   95     0   19   129 152                 281
1127530 1127530 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_7 162 14 22 0   66     0   17   161 120                       281 162 14 22 0   66     0   17   161 120                 281
1124190 1124190 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_7 170 7 90 1   5     0   6   142 137                       279 170 7 90 1   5     0   6   142 137                 279
1125657 1125657 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2017   grade_7 229 2 4 1   31     0   8   130 145                       275 229 2 4 1   31     0   8   130 145                 275
1123846 1123846 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2017   grade_7 198 18 12 2   31     0   12   147 126                       273 198 18 12 2   31     0   12   147 126                 273
1125220 1125220 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2017   grade_7 220 3 9 0   30     0   9   135 136                       271 220 3 9 0   30     0   9   135 136                 271
1127381 1127381 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_7 103 43 109 1   2     1   12   141 130                       271 103 43 109 1   2     1   12   141 130                 271
1132680 1132680 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No Middle 07 08 2017   grade_7 259 4 3 0   3     0   2   148 123                       271 259 4 3 0   3     0   2   148 123                 271
1129685 1129685 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2017   grade_7 187 35 30 0   6     0   10   127 141                       268 187 35 30 0   6     0   10   127 141                 268
1132893 1132893 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2017   grade_7 227 7 16 1   8     0   8   144 123                       267 227 7 16 1   8     0   8   144 123                 267
1124325 1124325 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2017   grade_7 229 6 16 1   7     0   7   140 126                       266 229 6 16 1   7     0   7   140 126                 266
1123335 1123335 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_7 82 55 64 0   48     0   13   110 152                       262 82 55 64 0   48     0   13   110 152                 262
1123999 1123999 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2017   grade_7 184 32 18 0   23     0   5   123 139                       262 184 32 18 0   23     0   5   123 139                 262
1130445 1130445 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2017   grade_7 203 10 10 0   34     0   5   121 141                       262 203 10 10 0   34     0   5   121 141                 262
1126906 1126906 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2017   grade_7 219 13 4 0   12     0   13   138 123                       261 219 13 4 0   12     0   13   138 123                 261
1128788 1128788 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No Middle 07 08 2017   grade_7 243 9 0 0   6     0   3   126 135                       261 243 9 0 0   6     0   3   126 135                 261
1125029 1125029 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   grade_7 132 13 81 0   22     0   9   132 125                       257 132 13 81 0   22     0   9   132 125                 257
1126979 1126979 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_7 233 3 12 1   2     0   6   126 131                       257 233 3 12 1   2     0   6   126 131                 257
1128083 1128083 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2017   grade_7 246 0 3 0   4     0   3   118 138                       256 246 0 3 0   4     0   3   118 138                 256
1122008 1122008 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   grade_7 211 5 21 0   7     0   9   122 131                       253 211 5 21 0   7     0   9   122 131                 253
1131920 1131920 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2017   grade_7 226 6 7 0   2     1   10   152 100                       252 226 6 7 0   2     1   10   152 100                 252
1124276 1124276 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_7 198 11 11 1   14     0   14   103 146                       249 198 11 11 1   14     0   14   103 146                 249
1124803 1124803 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_7 151 15 51 2   13     0   17   112 137                       249 151 15 51 2   13     0   17   112 137                 249
1126638 1126638 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2017   grade_7 220 7 12 0   1     0   6   118 128                       246 220 7 12 0   1     0   6   118 128                 246
1131557 1131557 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_7 0 125 117 0   2     0   2   117 129                       246 0 125 117 0   2     0   2   117 129                 246
1132537 1132537 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2017   grade_7 222 7 5 0   3     0   9   126 120                       246 222 7 5 0   3     0   9   126 120                 246
1123546 1123546 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2017   grade_7 186 10 8 1   34     0   6   125 120                       245 186 10 8 1   34     0   6   125 120                 245
1124484 1124484 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2017   grade_7 224 0 5 1   4     0   9   127 116                       243 224 0 5 1   4     0   9   127 116                 243
1126321 1126321 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2017   grade_7 214 7 14 0   1     0   6   123 119                       242 214 7 14 0   1     0   6   123 119                 242
1127905 1127905 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2017   grade_7 178 25 25 0   9     0   4   125 116                       241 178 25 25 0   9     0   4   125 116                 241
1129513 1129513 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2017   grade_7 138 55 17 0   14     1   16   133 108                       241 138 55 17 0   14     1   16   133 108                 241
1128246 1128246 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 05 08 2017   grade_7 219 2 7 0   1     0   9   122 116                       238 219 2 7 0   1     0   9   122 116                 238
1129346 1129346 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2017   grade_7 15 51 152 0   16     1   3   113 125                       238 15 51 152 0   16     1   3   113 125                 238
1124194 1124194 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2017   grade_7 127 9 93 0   0     0   7   138 98                       236 127 9 93 0   0     0   7   138 98                 236
1129354 1129354 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2017   grade_7 27 59 144 0   5     0   0   128 107                       235 27 59 144 0   5     0   0   128 107                 235
1132110 1132110 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2017   grade_7 213 2 9 2   2     1   6   112 123                       235 213 2 9 2   2     1   6   112 123                 235
1123696 1123696 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_7 48 98 65 0   3     1   19   102 132                       234 48 98 65 0   3     1   19   102 132                 234
1125177 1125177 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2017   grade_7 206 3 17 0   2     0   6   119 115                       234 206 3 17 0   2     0   6   119 115                 234
1128700 1128700 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   grade_7 218 4 1 2   3     0   1   122 107                       229 218 4 1 2   3     0   1   122 107                 229
1132000 1132000 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2017   grade_7 158 26 26 6   3     0   10   117 112                       229 158 26 26 6   3     0   10   117 112                 229
1130254 1130254 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No Middle 06 08 2017   grade_7 185 3 29 0   5     1   4   122 105                       227 185 3 29 0   5     1   4   122 105                 227
1125531 1125531 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2017   grade_7 195 1 7 1   18     0   4   100 126                       226 195 1 7 1   18     0   4   100 126                 226
1124560 1124560 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2017   grade_7 190 4 14 0   17     0   0   115 110                       225 190 4 14 0   17     0   0   115 110                 225
1127174 1127174 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_7 180 9 12 1   9     0   14   112 113                       225 180 9 12 1   9     0   14   112 113                 225
1123550 1123550 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2017   grade_7 170 4 10 0   37     0   1   105 117                       222 170 4 10 0   37     0   1   105 117                 222
1128739 1128739 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2017   grade_7 179 12 23 1   6     0   1   109 113                       222 179 12 23 1   6     0   1   109 113                 222
1132573 1132573 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2017   grade_7 205 0 8 0   6     0   3   122 100                       222 205 0 8 0   6     0   3   122 100                 222
1127626 1127626 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_7 167 4 28 1   6     0   14   110 110                       220 167 4 28 1   6     0   14   110 110                 220
1128422 1128422 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2017   grade_7 38 110 26 0   31     1   10   107 109                       216 38 110 26 0   31     1   10   107 109                 216
1122539 1122539 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2017   grade_7 186 9 7 1   10     0   2   106 109                       215 186 9 7 1   10     0   2   106 109                 215
1124950 1124950 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_7 185 8 12 2   4     0   3   113 101                       214 185 8 12 2   4     0   3   113 101                 214
1128164 1128164 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_7 159 20 18 0   2     0   15   99 115                       214 159 20 18 0   2     0   15   99 115                 214
1130298 1130298 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_7 144 2 1 2   63     1   1   116 98                       214 144 2 1 2   63     1   1   116 98                 214

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