enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by school_nces_id 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
940177 940177 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_7 82 74 167 1   28     0   23   198 177                       375 82 74 167 1   28     0   23   198 177                 375
940180 940180 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_7 114 61 168 1   41     0   15   216 184                       400 114 61 168 1   41     0   15   216 184                 400
940174 940174 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_7 235 53 145 1   33     0   26   255 238                       493 235 53 145 1   33     0   26   255 238                 493
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
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
940160 940160 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2016   grade_7 3 5 24 0   12     0   1   21 24                       45 3 5 24 0   12     0   1   21 24                 45
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
939841 939841 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2016   grade_7 144 0 17 0   1     0   1   75 88                       163 144 0 17 0   1     0   1   75 88                 163
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
939784 939784 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_7 85 1 8 1   2     0   4   48 53                       101 85 1 8 1   2     0   4   48 53                 101
939770 939770 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2016   grade_7 260 4 9 0   15     0   10   146 152                       298 260 4 9 0   15     0   10   146 152                 298
941841 941841 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_7 119 3 2 0   2     0   4   72 58                       130 119 3 2 0   2     0   4   72 58                 130
941838 941838 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2016   grade_7 200 1 3 1   2     1   4   93 119                       212 200 1 3 1   2     1   4   93 119                 212
939688 939688 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 05 08 2016   grade_7 355 27 30 2   19     0   15   227 221                       448 355 27 30 2   19     0   15   227 221                 448
939675 939675 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2016   grade_7 222 9 10 0   19     0   2   116 146                       262 222 9 10 0   19     0   2   116 146                 262
939599 939599 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Junior High School   Regular School No 2 07 08 2016   grade_7 121 1 2 2   2     0   3   76 55                       131 121 1 2 2   2     0   3   76 55                 131
939585 939585 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2016   grade_7 121 12 8 0   25     0   12   88 90                       178 121 12 8 0   25     0   12   88 90                 178
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
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
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
939520 939520 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2016   grade_7 185 2 22 0   2     1   5   99 118                       217 185 2 22 0   2     1   5   99 118                 217
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
939094 939094 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2016   grade_7 24 1 5 2   1     0   2   16 19                       35 24 1 5 2   1     0   2   16 19                 35
939634 939634 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No 2 06 08 2016   grade_7 209 5 55 0   19     0   2   140 150                       290 209 5 55 0   19     0   2   140 150                 290
939470 939470 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_7 87 2 4 0   4     0   4   48 53                       101 87 2 4 0   4     0   4   48 53                 101
939456 939456 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2016   grade_7 70 2 2 0   0     0   3   37 40                       77 70 2 2 0   0     0   3   37 40                 77
939413 939413 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2016   grade_7 313 13 20 0   47     0   23   215 201                       416 313 13 20 0   47     0   23   215 201                 416
939362 939362 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No 2 05 08 2016   grade_7 109 10 35 0   1     1   13   87 82                       169 109 10 35 0   1     1   13   87 82                 169
939348 939348 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2016   grade_7 163 11 8 0   35     0   16   111 122                       233 163 11 8 0   35     0   16   111 122                 233
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
941812 941812 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2016   grade_7 129 0 6 0   0     0   3   68 70                       138 129 0 6 0   0     0   3   68 70                 138
939285 939285 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2016   grade_7 144 11 11 4   1     0   15   100 86                       186 144 11 11 4   1     0   15   100 86                 186
939270 939270 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_7 90 4 11 0   0     2   4   64 47                       111 90 4 11 0   0     2   4   64 47                 111
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
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
939207 939207 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2016   grade_7 116 8 6 0   10     0   3   67 76                       143 116 8 6 0   10     0   3   67 76                 143
939204 939204 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No 2 06 08 2016   grade_7 138 11 8 1   2     0   3   83 80                       163 138 11 8 1   2     0   3   83 80                 163
939163 939163 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2016   grade_7 263 10 15 1   3     1   2   150 145                       295 263 10 15 1   3     1   2   150 145                 295
941776 941776 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2016   grade_7 49 1 2 0   1     0   0   28 25                       53 49 1 2 0   1     0   0   28 25                 53
941789 941789 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_7 87 1 4 0   1     0   0   57 36                       93 87 1 4 0   1     0   0   57 36                 93
941767 941767 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2016   grade_7 57 1 4 0   0     0   1   36 27                       63 57 1 4 0   0     0   1   36 27                 63
941785 941785 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2016   grade_7 123 5 6 0   3     0   2   74 65                       139 123 5 6 0   3     0   2   74 65                 139
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
939131 939131 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2016   grade_7 146 2 6 0   3     0   3   81 79                       160 146 2 6 0   3     0   3   81 79                 160
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
941710 941710 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No 2 07 08 2016   grade_7 185 0 7 2   3     0   3   106 94                       200 185 0 7 2   3     0   3   106 94                 200
939080 939080 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No 2 07 08 2016   grade_7 267 9 7 0   10     0   4   145 152                       297 267 9 7 0   10     0   4   145 152                 297
939053 939053 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2016   grade_7 90 31 38 0   1     0   4   77 87                       164 90 31 38 0   1     0   4   77 87                 164
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
939056 939056 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2016   grade_7 192 19 25 1   1     0   12   133 117                       250 192 19 25 1   1     0   12   133 117                 250
941675 941675 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No 2 07 08 2016   grade_7 263 1 12 0   2     0   3   128 153                       281 263 1 12 0   2     0   3   128 153                 281
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
938986 938986 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2016   grade_7 157 7 20 0   2     0   5   91 100                       191 157 7 20 0   2     0   5   91 100                 191
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
938944 938944 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2016   grade_7 296 8 13 0   17     0   5   168 171                       339 296 8 13 0   17     0   5   168 171                 339
938904 938904 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2016   grade_7 183 67 25 0   15     0   4   146 148                       294 183 67 25 0   15     0   4   146 148                 294
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
938802 938802 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No 2 06 08 2016   grade_7 10 25 84 0   1     0   0   69 51                       120 10 25 84 0   1     0   0   69 51                 120
938805 938805 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No 2 06 08 2016   grade_7 16 18 100 0   1     0   0   67 68                       135 16 18 100 0   1     0   0   67 68                 135
938795 938795 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2016   grade_7 10 9 53 0   2     0   3   33 44                       77 10 9 53 0   2     0   3   33 44                 77
938792 938792 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2016   grade_7 0 8 89 0   0     0   0   50 47                       97 0 8 89 0   0     0   0   50 47                 97
938789 938789 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2016   grade_7 3 8 91 0   1     0   0   62 41                       103 3 8 91 0   1     0   0   62 41                 103
938798 938798 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No 4 06 10 2016   grade_7 11 17 29 0   0     0   1   14 44                       58 11 17 29 0   0     0   1   14 44                 58
938786 938786 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2016   grade_7 1 4 20 0   0     0   0   19 6                       25 1 4 20 0   0     0   0   19 6                 25
938777 938777 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No 2 06 08 2016   grade_7 3 2 14 0   0     0   0   15 4                       19 3 2 14 0   0     0   0   15 4                 19
938783 938783 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2016   grade_7 2 16 71 0   2     0   0   50 41                       91 2 16 71 0   2     0   0   50 41                 91
938780 938780 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2016   grade_7 10 31 56 0   0     0   0   61 36                       97 10 31 56 0   0     0   0   61 36                 97
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
938771 938771 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_7 12 27 91 0   0     0   0   63 67                       130 12 27 91 0   0     0   0   63 67                 130
938768 938768 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No 2 06 08 2016   grade_7 22 47 141 0   18     0   0   114 114                       228 22 47 141 0   18     0   0   114 114                 228
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
938755 938755 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_7 24 29 53 1   0     1   0   61 47                       108 24 29 53 1   0     1   0   61 47                 108
938656 938656 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_7 8 8 8 0   1     0   1   13 13                       26 8 8 8 0   1     0   1   13 13                 26
941627 941627 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2016   grade_7 44 2 3 0   0     0   5   28 26                       54 44 2 3 0   0     0   5   28 26                 54
938522 938522 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2016   grade_7 72 3 95 2   1     0   3   92 84                       176 72 3 95 2   1     0   3   92 84                 176
938506 938506 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2016   grade_7 122 0 7 0   23     0   4   83 73                       156 122 0 7 0   23     0   4   83 73                 156
938536 938536 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2016   grade_7 118 3 13 0   1     0   5   69 71                       140 118 3 13 0   1     0   5   69 71                 140
938479 938479 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2016   grade_7 1 3 5 0   0     0   0   7 *                       9 1 3 5 0   0     0   0   7                   9
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
938447 938447 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   grade_7 21 4 16 0   2     0   0   21 22                       43 21 4 16 0   2     0   0   21 22                 43
938437 938437 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2016   grade_7 39 6 10 0   0     0   1   31 25                       56 39 6 10 0   0     0   1   31 25                 56
938456 938456 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2016   grade_7 14 4 38 0   2     0   0   34 24                       58 14 4 38 0   2     0   0   34 24                 58
938427 938427 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2016   grade_7 11 5 22 0   4     0   2   23 21                       44 11 5 22 0   4     0   2   23 21                 44
938466 938466 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2016   grade_7 22 5 10 0   2     0   3   25 17                       42 22 5 10 0   2     0   3   25 17                 42
938408 938408 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No 2 06 08 2016   grade_7 196 5 6 1   3     1   5   120 97                       217 196 5 6 1   3     1   5   120 97                 217
941600 941600 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2016   grade_7 295 3 1 0   5     0   1   146 159                       305 295 3 1 0   5     0   1   146 159                 305
938367 938367 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2016   grade_7 292 11 31 2   126     0   18   247 233                       480 292 11 31 2   126     0   18   247 233                 480
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
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
938292 938292 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No 2 07 08 2016   grade_7 243 7 1 0   2     0   3   126 130                       256 243 7 1 0   2     0   3   126 130                 256
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
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
938176 938176 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No 1 KG 08 2016   grade_7 7 3 30 0   0     0   0   21 19                       40 7 3 30 0   0     0   0   21 19                 40
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
938191 938191 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No 1 KG 08 2016   grade_7 22 0 9 0   0     0   3   12 22                       34 22 0 9 0   0     0   3   12 22                 34
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
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
938103 938103 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2016   grade_7 7 1 1 0   0     0   0   3 6                       9 7 1 1 0   0     0   0   3 6                 9
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

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