enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by asian descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
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
1678936 1678936 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Westborough - Sarah W Gibbons Middle   Regular School No Middle 07 08 2021   grade_7 153 15 14 0   98     0   9   134 155 *                     289.0 153 15 14 0   98     0   9   134 155                 289
936004 936004 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2016   grade_7 130 14 10 1   95     0   14   130 134                       264 130 14 10 1   95     0   14   130 134                 264
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
739161 739161 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_7 128 14 6 0   94     0   15   128 129                       257 128 14 6 0   94     0   15   128 129                 257
2235190 2235190 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy: Central Middle   Regular School No Middle 06 08 2018   grade_7 105 6 7 0   93     0   5   109 107                       216.0 105 6 7 0   93     0   5   109 107                 216
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
1672399 1672399 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_7 211 13 20 1   92     2   28   189 178 *                     367.0 211 13 20 1   92     2   28   189 178                 367
2041024 2041024 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_7 195 34 71 0   92     0   18   202 208                       410.0 195 34 71 0   92     0   18   202 208                 410
2045241 2045241 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_7 73 7 4 0   92     2   9   100 87                       187.0 73 7 4 0   92     2   9   100 87                 187
2046760 2046760 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2019   grade_7 180 4 25 0   92     1   10   153 159                       312.0 180 4 25 0   92     1   10   153 159                 312
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
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
737702 737702 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2015   grade_7 268 3 13 0   9     0   3   155 141                       296 268 3 13 0   9     0   3   155 141                 296
738548 738548 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_7 78 1 4 0   9     0   2   45 49                       94 78 1 4 0   9     0   2   45 49                 94
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
742445 742445 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2015   grade_7 86 21 49 0   9     0   4   93 76                       169 86 21 49 0   9     0   4   93 76                 169
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
742965 742965 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2015   grade_7 240 4 9 0   9     0   3   139 126                       265 240 4 9 0   9     0   3   139 126                 265
743090 743090 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_7 140 10 13 0   9     0   2   85 89                       174 140 10 13 0   9     0   2   85 89                 174
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
743789 743789 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2015   grade_7 15 66 46 1   9     0   2   62 77                       139 15 66 46 1   9     0   2   62 77                 139
744335 744335 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_7 194 2 1 0   9     1   0   106 101                       207 194 2 1 0   9     1   0   106 101                 207
932893 932893 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_7 168 3 4 0   9     0   3   111 76                       187 168 3 4 0   9     0   3   111 76                 187
932982 932982 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2016   grade_7 266 11 33 0   9     0   9   173 155                       328 266 11 33 0   9     0   9   173 155                 328
934063 934063 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_7 53 5 10 0   9     0   8   45 40                       85 53 5 10 0   9     0   8   45 40                 85
934083 934083 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2016   grade_7 38 2 4 0   9     0   1   22 32                       54 38 2 4 0   9     0   1   22 32                 54
934250 934250 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2016   grade_7 34 27 11 1   9     1   2   44 41                       85 34 27 11 1   9     1   2   44 41                 85
934445 934445 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_7 160 8 97 1   9     0   8   144 139                       283 160 8 97 1   9     0   8   144 139                 283
934778 934778 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_7 247 18 11 0   9     0   6   134 157                       291 247 18 11 0   9     0   6   134 157                 291
936041 936041 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2016   grade_7 100 0 3 1   9     0   2   47 68                       115 100 0 3 1   9     0   2   47 68                 115
936060 936060 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2016   grade_7 77 5 5 0   9     0   5   55 46                       101 77 5 5 0   9     0   5   55 46                 101
936070 936070 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_7 99 1 5 1   9     0   4   58 61                       119 99 1 5 1   9     0   4   58 61                 119
936709 936709 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No 2 06 08 2016   grade_7 233 15 5 0   9     0   7   126 143                       269 233 15 5 0   9     0   7   126 143                 269
936934 936934 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No 2 05 08 2016   grade_7 140 3 4 0   9     0   12   86 82                       168 140 3 4 0   9     0   12   86 82                 168
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
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
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
940738 940738 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_7 27 5 3 0   9     0   8   18 34                       52 27 5 3 0   9     0   8   18 34                 52
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
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
1128468 1128468 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2017   grade_7 136 5 1 0   9     0   1   85 67                       152 136 5 1 0   9     0   1   85 67                 152
1131017 1131017 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2017   grade_7 4 4 29 0   9     0   1   30 17                       47 4 4 29 0   9     0   1   30 17                 47
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
1131347 1131347 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_7 38 53 7 0   9     0   5   50 62                       112 38 53 7 0   9     0   5   50 62                 112
1365026 1365026 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_7 98 10 40 0   9     0   5   88 74 *                     162.0 98 10 40 0   9     0   5   88 74                 162
1365050 1365050 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_7 154 4 26 0   9     0   9   104 98 *                     202.0 154 4 26 0   9     0   9   104 98                 202
1365095 1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
1365143 1365143 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2020   grade_7 149 1 6 0   9     0   0   78 87 *                     165.0 149 1 6 0   9     0   0   78 87                 165
1366283 1366283 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_7 52 7 18 0   9     0   7   50 43 *                     93.0 52 7 18 0   9     0   7   50 43                 93
1366302 1366302 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2020   grade_7 39 2 7 0   9     0   5   23 39 *                     62.0 39 2 7 0   9     0   5   23 39                 62
1366672 1366672 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2020   grade_7 119 10 124 1   9     0   8   155 116 *                     271.0 119 10 124 1   9     0   8   155 116                 271
1367386 1367386 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2020   grade_7 132 10 69 1   9     0   16   114 123 *                     237.0 132 10 69 1   9     0   16   114 123                 237
1368143 1368143 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2020   grade_7 128 25 111 0   9     0   12   141 144 *                     285.0 128 25 111 0   9     0   12   141 144                 285
1369037 1369037 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2020   grade_7 118 5 14 0   9     0   11   88 69 *                     157.0 118 5 14 0   9     0   11   88 69                 157
1369548 1369548 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_7 149 10 35 0   9     0   11   88 125 *                     214.0 149 10 35 0   9     0   11   88 125                 214
1371103 1371103 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2020   grade_7 132 4 24 0   9     0   5   78 96 *                     174.0 132 4 24 0   9     0   5   78 96                 174
1371501 1371501 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_7 92 16 47 0   9     0   4   97 71 *                     168.0 92 16 47 0   9     0   4   97 71                 168
1371753 1371753 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield Middle School   Regular School No Middle 07 08 2020   grade_7 286 5 73 0   9     0   10   188 195 *                     383.0 286 5 73 0   9     0   10   188 195                 383
1372117 1372117 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2020   grade_7 142 18 28 0   9     0   8   102 103 *                     205.0 142 18 28 0   9     0   8   102 103                 205
1372963 1372963 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_7 30 9 3 0   9     0   8   35 24 *                     59.0 30 9 3 0   9     0   8   35 24                 59
1672443 1672443 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly - Beverly Middle School   Regular School No Middle 05 08 2021   grade_7 286 11 52 0   9     1   14   192 181 *                     373.0 286 11 52 0   9     1   14   192 181                 373
1673703 1673703 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge - Putnam Avenue Upper School   Regular School No Middle 06 08 2021   grade_7 24 22 12 1   9     0   10   38 40 *                     78.0 24 22 12 1   9     0   10   38 40                 78
1673751 1673751 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_7 61 0 2 0   9     0   6   43 35 *                     78.0 61 0 2 0   9     0   6   43 35                 78
1675995 1675995 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough - 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2021   grade_7 126 13 209 1   9     0   10   198 170 *                     368.0 126 13 209 1   9     0   10   198 170                 368
1677529 1677529 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere - Rumney Marsh Academy   Regular School No Middle 06 08 2021   grade_7 86 8 110 0   9     0   4   133 84 *                     217.0 86 8 110 0   9     0   4   133 84                 217
1680657 1680657 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable - Groton Dunstable Regional Middle   Regular School No Middle 05 08 2021   grade_7 149 3 7 0   9     0   4   85 87 *                     172.0 149 3 7 0   9     0   4   85 87                 172
1680788 1680788 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet - Masconomet Regional Middle School   Regular School No Middle 07 08 2021   grade_7 274 3 11 0   9     1   16   149 165 *                     314.0 274 3 11 0   9     1   16   149 165                 314
2040049 2040049 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_7 124 9 25 0   9     0   11   91 87                       178.0 124 9 25 0   9     0   11   91 87                 178
2040053 2040053 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_7 98 7 27 1   9     0   7   74 75                       149.0 98 7 27 1   9     0   7   74 75                 149
2040078 2040078 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_7 171 2 17 0   9     0   7   113 93                       206.0 171 2 17 0   9     0   7   113 93                 206
2040254 2040254 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2019   grade_7 243 9 50 0   9     0   9   172 148                       320.0 243 9 50 0   9     0   9   172 148                 320
2041309 2041309 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2019   grade_7 60 84 69 0   9     0   10   104 128                       232.0 60 84 69 0   9     0   10   104 128                 232
2041544 2041544 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2019   grade_7 43 24 10 0   9     0   8   37 57                       94.0 43 24 10 0   9     0   8   37 57                 94
2041854 2041854 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2019   grade_7 237 4 23 0   9     0   7   140 140                       280.0 237 4 23 0   9     0   7   140 140                 280
2041911 2041911 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2019   grade_7 142 11 26 0   9     0   6   110 84                       194.0 142 11 26 0   9     0   6   110 84                 194
2042051 2042051 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2019   grade_7 179 9 15 0   9     0   6   110 108                       218.0 179 9 15 0   9     0   6   110 108                 218
2042457 2042457 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_7 146 8 82 0   9     0   4   130 119                       249.0 146 8 82 0   9     0   4   130 119                 249
2043941 2043941 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2019   grade_7 124 15 10 0   9     0   8   89 77                       166.0 124 15 10 0   9     0   8   89 77                 166
2044017 2044017 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_7 77 1 47 0   9     0   7   70 71                       141.0 77 1 47 0   9     0   7   70 71                 141
2044436 2044436 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2019   grade_7 177 3 7 0   9     0   4   101 99                       200.0 177 3 7 0   9     0   4   101 99                 200
2045383 2045383 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2019   grade_7 58 5 103 1   9     0   4   86 94                       180.0 58 5 103 1   9     0   4   86 94                 180
2046436 2046436 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2019   grade_7 95 3 5 1   9     0   3   58 58                       116.0 95 3 5 1   9     0   3   58 58                 116
2046522 2046522 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2019   grade_7 137 8 13 1   9     0   1   91 78                       169.0 137 8 13 1   9     0   1   91 78                 169
2046827 2046827 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield Middle School   Regular School No Middle 07 08 2019   grade_7 329 9 56 0   9     0   10   204 209                       413.0 329 9 56 0   9     0   10   204 209                 413
2047065 2047065 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_7 237 4 10 2   9     0   12   146 128                       274.0 237 4 10 2   9     0   12   146 128                 274
2047187 2047187 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_7 109 9 16 1   9     0   6   71 79                       150.0 109 9 16 1   9     0   6   71 79                 150
2047451 2047451 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_7 5 12 78 0   9     0   4   57 51                       108.0 5 12 78 0   9     0   4   57 51                 108
2229078 2229078 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn: Auburn Middle   Regular School No Middle 06 08 2018   grade_7 181 3 21 0   9     0   4   121 97                       218.0 181 3 21 0   9     0   4   121 97                 218
2231915 2231915 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   grade_7 118 3 5 0   9     0   1   62 74                       136.0 118 3 5 0   9     0   1   62 74                 136
2232999 2232999 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell: Pyne Arts   Regular School No Elementary PK 08 2018   grade_7 24 1 20 0   9     0   2   30 26                       56.0 24 1 20 0   9     0   2   30 26                 56
2233354 2233354 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield: Lynnfield Middle School   Regular School No Middle 05 08 2018   grade_7 129 3 13 0   9     0   5   90 69                       159.0 129 3 13 0   9     0   5   90 69                 159
2234196 2234196 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford: Normandin Middle School   Regular School No Middle 06 08 2018   grade_7 198 28 151 2   9     0   29   216 201                       417.0 198 28 151 2   9     0   29   216 201                 417
2237073 2237073 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield: South Middle School   Regular School No Middle 06 08 2018   grade_7 141 7 40 0   9     0   1   105 93                       198.0 141 7 40 0   9     0   1   105 93                 198
2237856 2237856 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_7 108 64 138 0   9     0   16   153 182                       335.0 108 64 138 0   9     0   16   153 182                 335
2238357 2238357 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_7 7 67 82 0   9     0   1   88 78                       166.0 7 67 82 0   9     0   1   88 78                 166
937947 937947 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_7 119 5 6 0   89     1   6   117 109                       226 119 5 6 0   89     1   6   117 109                 226
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
2043491 2043491 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2019   grade_7 22 8 55 0   88     0   5   88 90                       178.0 22 8 55 0   88     0   5   88 90                 178
741112 741112 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2015   grade_7 49 1 2 0   87     0   1   73 67                       140 49 1 2 0   87     0   1   73 67                 140

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