enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1123138 1123138 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_7 1 11 14 0   0     0   4   23 7                       30 1 11 14 0   0     0   4   23 7                 30
1125425 1125425 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1125884 1125884 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_7 2 1 10 0   0     0   0   11 2                       13 2 1 10 0   0     0   0   11 2                 13
1124819 1124819 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_7 1 2 2 0   0     0   2   6 *                       7 1 2 2 0   0     0   2   6                   7
1126252 1126252 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_7 2 0 3 0   0     0   1   6 *                       6 2 0 3 0   0     0   1   6                   6
1123009 1123009 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_7 7 31 41 0   2     0   1   44 38                       82 7 31 41 0   2     0   1   44 38                 82
1123251 1123251 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_7 13 25 13 0   5     0   3   31 28                       59 13 25 13 0   5     0   3   31 28                 59
1125782 1125782 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_7 2 2 75 0   0     0   0   39 40                       79 2 2 75 0   0     0   0   39 40                 79
1122383 1122383 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Elementary 04 07 2017   grade_7 165 5 3 0   5     0   4   86 96                       182 165 5 3 0   5     0   4   86 96                 182
1124226 1124226 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_7 90 4 30 0   1     0   2   70 57                       127 90 4 30 0   1     0   2   70 57                 127
1125267 1125267 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125283 1125283 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_7 88 4 20 0   4     0   9   66 59                       125 88 4 20 0   4     0   9   66 59                 125
1125569 1125569 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_7 7 2 84 0   0     0   0   47 46                       93 7 2 84 0   0     0   0   47 46                 93
1126089 1126089 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_7 27 5 9 0   1     0   7   24 24                       49 27 5 9 0   1     0   7   24 24                 49
1126768 1126768 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Elementary 04 07 2017   grade_7 93 4 13 1   1     0   2   54 60                       114 93 4 13 1   1     0   2   54 60                 114
1131446 1131446 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   grade_7 41 1 0 0   1     0   1   24 20                       44 41 1 0 0   1     0   1   24 20                 44
1121974 1121974 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_7 73 0 3 0   0     0   1   42 35                       77 73 0 3 0   0     0   1   42 35                 77
1122005 1122005 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1122032 1122032 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_7 160 0 10 0   2     0   6   96 82                       178 160 0 10 0   2     0   6   96 82                 178
1122237 1122237 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_7 153 8 21 0   5     0   8   103 92                       195 153 8 21 0   5     0   8   103 92                 195
1122242 1122242 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_7 97 8 24 0   4     0   8   77 64                       141 97 8 24 0   4     0   8   77 64                 141
1122247 1122247 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_7 90 9 22 0   10     1   4   74 62                       136 90 9 22 0   10     1   4   74 62                 136
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
1122439 1122439 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_7 98 1 3 0   2     0   2   54 52                       106 98 1 3 0   2     0   2   54 52                 106
1123476 1123476 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_7 170 3 2 2   6     0   0   86 97                       183 170 3 2 2   6     0   0   86 97                 183
1123668 1123668 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_7 * * * *   *     *   *   4 1                       *                         4 1                  
1124062 1124062 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_7 133 3 11 0   34     0   0   88 93                       181 133 3 11 0   34     0   0   88 93                 181
1124067 1124067 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_7 155 8 9 0   30     1   5   102 106                       208 155 8 9 0   30     1   5   102 106                 208
1124101 1124101 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_7 6 7 112 1   3     0   2   70 61                       131 6 7 112 1   3     0   2   70 61                 131
1124106 1124106 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_7 1 2 117 0   2     0   1   65 58                       123 1 2 117 0   2     0   1   65 58                 123
1124111 1124111 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_7 5 9 115 0   4     0   0   67 66                       133 5 9 115 0   4     0   0   67 66                 133
1124538 1124538 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_7 100 1 17 0   4     0   2   57 67                       124 100 1 17 0   4     0   2   57 67                 124
1124882 1124882 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_7 42 6 98 0   7     0   10   91 72                       163 42 6 98 0   7     0   10   91 72                 163
1124894 1124894 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_7 38 6 49 0   7     0   10   62 48                       110 38 6 49 0   7     0   10   62 48                 110
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
1125108 1125108 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   grade_7 123 6 30 1   3     0   18   96 85                       181 123 6 30 1   3     0   18   96 85                 181
1125338 1125338 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_7 201 1 3 0   4     0   0   115 94                       209 201 1 3 0   4     0   0   115 94                 209
1125413 1125413 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_7 69 7 41 0   2     0   0   52 67                       119 69 7 41 0   2     0   0   52 67                 119
1125440 1125440 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_7 97 7 30 0   3     1   1   67 72                       139 97 7 30 0   3     1   1   67 72                 139
1125687 1125687 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2017   grade_7 177 4 16 0   0     1   7   97 108                       205 177 4 16 0   0     1   7   97 108                 205
1125787 1125787 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_7 3 1 142 0   0     0   0   65 81                       146 3 1 142 0   0     0   0   65 81                 146
1125808 1125808 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_7 1 2 125 0   2     0   0   57 73                       130 1 2 125 0   2     0   0   57 73                 130
1125813 1125813 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_7 12 5 127 0   0     0   1   82 63                       145 12 5 127 0   0     0   1   82 63                 145
1125870 1125870 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_7 16 3 98 0   3     0   1   63 58                       121 16 3 98 0   3     0   1   63 58                 121
1126267 1126267 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_7 49 14 31 0   38     0   9   69 72                       141 49 14 31 0   38     0   9   69 72                 141
1126272 1126272 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2017   grade_7 48 5 32 0   73     0   11   84 85                       169 48 5 32 0   73     0   11   84 85                 169
1126282 1126282 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2017   grade_7 49 26 55 0   34     0   5   90 79                       169 49 26 55 0   34     0   5   90 79                 169
1126287 1126287 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2017   grade_7 66 20 63 0   18     0   5   86 86                       172 66 20 63 0   18     0   5   86 86                 172
1126292 1126292 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2017   grade_7 55 15 62 0   29     0   4   82 83                       165 55 15 62 0   29     0   4   82 83                 165
1126297 1126297 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2017   grade_7 19 17 53 0   89     0   3   91 90                       181 19 17 53 0   89     0   3   91 90                 181
1126533 1126533 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2017   grade_7 164 1 3 0   5     0   4   83 94                       177 164 1 3 0   5     0   4   83 94                 177
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
1126860 1126860 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2017   grade_7 172 3 7 1   8     0   4   100 95                       195 172 3 7 1   8     0   4   100 95                 195
1127046 1127046 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_7 91 5 5 0   3     0   1   58 47                       105 91 5 5 0   3     0   1   58 47                 105
1127103 1127103 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_7 91 1 1 0   0     2   3   51 47                       98 91 1 1 0   0     2   3   51 47                 98
1127169 1127169 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2017   grade_7 126 4 5 0   13     0   7   79 76                       155 126 4 5 0   13     0   7   79 76                 155
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
1127768 1127768 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2017   grade_7 180 2 13 0   5     0   8   116 92                       208 180 2 13 0   5     0   8   116 92                 208
1127956 1127956 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2017   grade_7 111 4 11 1   1     2   7   60 77                       137 111 4 11 1   1     2   7   60 77                 137
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
1128374 1128374 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No Middle 05 08 2017   grade_7 37 14 8 0   26     1   5   45 46                       91 37 14 8 0   26     1   5   45 46                 91
1128379 1128379 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2017   grade_7 32 10 9 0   32     0   3   44 42                       86 32 10 9 0   32     0   3   44 42                 86
1128586 1128586 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2017   grade_7 135 6 14 0   4     0   11   84 86                       170 135 6 14 0   4     0   11   84 86                 170
1129079 1129079 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2017   grade_7 106 4 18 0   4     0   5   65 72                       137 106 4 18 0   4     0   5   65 72                 137
1129466 1129466 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2017   grade_7 145 1 12 0   7     0   6   90 81                       171 145 1 12 0   7     0   6   90 81                 171
1129611 1129611 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2017   grade_7 162 8 24 0   8     0   3   95 110                       205 162 8 24 0   8     0   3   95 110                 205
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
1129695 1129695 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2017   grade_7 86 19 29 0   6     1   7   70 78                       148 86 19 29 0   6     1   7   70 78                 148
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
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
1129980 1129980 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_7 148 15 9 3   1     0   15   92 99                       191 148 15 9 3   1     0   15   92 99                 191
1130065 1130065 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_7 96 10 31 1   3     2   10   66 87                       153 96 10 31 1   3     2   10   66 87                 153
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
1131112 1131112 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_7 14 10 146 3   1     0   0   85 89                       174 14 10 146 3   1     0   0   85 89                 174
1131127 1131127 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_7 13 47 20 0   1     0   0   37 44                       81 13 47 20 0   1     0   0   37 44                 81
1131244 1131244 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_7 84 4 1 0   9     0   2   47 53                       100 84 4 1 0   9     0   2   47 53                 100
1131366 1131366 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_7 43 31 23 0   0     0   1   47 51                       98 43 31 23 0   0     0   1   47 51                 98
1131548 1131548 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes Other 05 12 2017   grade_7 81 1 0 0   3     0   4   50 39                       89 81 1 0 0   3     0   4   50 39                 89
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
1131650 1131650 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes Other 05 12 2017   grade_7 42 7 23 0   2     0   6   46 34                       80 42 7 23 0   2     0   6   46 34                 80
1131673 1131673 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2017   grade_7 5 14 59 0   0     0   1   44 35                       79 5 14 59 0   0     0   1   44 35                 79
1131815 1131815 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_7 96 1 6 1   0     0   3   53 54                       107 96 1 6 1   0     0   3   53 54                 107
1131857 1131857 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_7 104 1 10 1   1     0   2   42 77                       119 104 1 10 1   1     0   2   42 77                 119
1131917 1131917 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2017   grade_7 165 5 6 0   2     0   9   99 88                       187 165 5 6 0   2     0   9   99 88                 187
1131924 1131924 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_7 * * * *   *     *   *   1 *                       *                         1                    
1132023 1132023 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2017   grade_7 77 1 3 0   1     0   2   47 37                       84 77 1 3 0   1     0   2   47 37                 84
1132028 1132028 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2017   grade_7 135 1 7 1   1     0   0   73 72                       145 135 1 7 1   1     0   0   73 72                 145
1132064 1132064 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2017   grade_7 145 2 15 0   2     0   2   81 85                       166 145 2 15 0   2     0   2   81 85                 166
1132069 1132069 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_7 165 2 4 0   3     0   2   98 78                       176 165 2 4 0   3     0   2   98 78                 176
1132166 1132166 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2017   grade_7 174 1 4 0   19     0   4   97 105                       202 174 1 4 0   19     0   4   97 105                 202
1132250 1132250 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No Middle 05 08 2017   grade_7 48 4 3 2   2     0   0   28 31                       59 48 4 3 2   2     0   0   28 31                 59
1132337 1132337 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2017   grade_7 183 2 11 0   5     0   0   104 97                       201 183 2 11 0   5     0   0   104 97                 201
1132368 1132368 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_7 108 3 13 2   2     1   6   67 68                       135 108 3 13 2   2     1   6   67 68                 135
1132439 1132439 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_7 99 2 7 0   0     1   2   60 51                       111 99 2 7 0   0     1   2   60 51                 111
1132517 1132517 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_7 112 0 7 0   2     0   4   57 68                       125 112 0 7 0   2     0   4   57 68                 125
1132528 1132528 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2017   grade_7 112 2 5 0   0     0   3   59 63                       122 112 2 5 0   0     0   3   59 63                 122
1132761 1132761 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_7 82 0 10 0   1     0   4   52 45                       97 82 0 10 0   1     0   4   52 45                 97
1132902 1132902 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_7 87 3 1 0   1     0   0   48 44                       92 87 3 1 0   1     0   0   48 44                 92
1122108 1122108 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_7 132 1 7 1   23     0   4   100 68                       168 132 1 7 1   23     0   4   100 68                 168

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